-- phpMyAdmin SQL Dump
-- version 5.0.4
-- https://www.phpmyadmin.net/
--
-- Host: 127.0.0.1
-- Generation Time: Jun 07, 2021 at 07:40 AM
-- Server version: 10.4.17-MariaDB
-- PHP Version: 7.4.13

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
START TRANSACTION;
SET time_zone = "+00:00";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;

--
-- Database: `restaurants`
--

-- --------------------------------------------------------

--
-- Table structure for table `setting`
--

CREATE TABLE `setting` (
  `id` int(20) NOT NULL,
  `head` varchar(20) NOT NULL,
  `type` varchar(20) NOT NULL,
  `name` varchar(50) NOT NULL,
  `foreign_name` varchar(50) NOT NULL,
  `category_code` int(11) NOT NULL,
  `ob` varchar(20) NOT NULL,
  `acces` varchar(20) NOT NULL,
  `orders` int(20) NOT NULL,
  `ware` int(11) NOT NULL,
  `by` int(11) NOT NULL,
  `model` int(2) NOT NULL,
  `note` int(5) NOT NULL,
  `accounts_id` bigint(20) NOT NULL,
  `acc_level` int(3) NOT NULL DEFAULT 1,
  `status` int(1) NOT NULL DEFAULT 1 COMMENT '1=active,2=inactive',
  `trace` int(1) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `setting`
--

INSERT INTO `setting` (`id`, `head`, `type`, `name`, `foreign_name`, `category_code`, `ob`, `acces`, `orders`, `ware`, `by`, `model`, `note`, `accounts_id`, `acc_level`, `status`, `trace`) VALUES
(1, '0', '1', 'Assets', '', 0, '1', '', 0, 0, 0, 0, 0, 1000, 1, 1, 0),
(2, '0', '1', 'Liablities', '', 0, '2', '', 0, 0, 0, 0, 11, 2000, 1, 1, 0),
(3, '0', '1', 'Expense', '', 0, '1', '', 0, 0, 0, 0, 12, 3000, 1, 1, 0),
(4, '0', '1', 'Revenue', '', 0, '2', '0', 0, 0, 0, 0, 13, 4000, 1, 1, 0),
(12, '13', '1', 'Cash At Bank', '', 0, '1', '1', 0, 0, 1, 0, 0, 1000020502, 0, 1, 0),
(13, '528', '1', 'Cash & Cash Equivalent', '', 0, '1', '1', 0, 0, 1, 0, 0, 10000205, 0, 1, 0),
(77, '576', '1', 'Goods Suppliers', '', 0, '2', '1', 0, 0, 1, 0, 11, 2000020101, 0, 1, 0),
(83, '11', '2', 'Inventories', '', 10, '1', '', 5, 0, 0, 0, 2, 10000408, 1, 1, 0),
(109, '13', '1', 'Cash In Hand', '', 0, '1', '1', 0, 0, 1, 0, 0, 1000020501, 0, 1, 0),
(511, '1', '1', 'Noncurrent Assets', '', 0, '1', '1', 0, 0, 1, 0, 0, 100001, 0, 1, 0),
(512, '511', '1', 'Intangible Assets ', '', 0, '1', '1', 0, 0, 1, 0, 0, 10000101, 0, 1, 0),
(513, '511', '1', 'Property,Plant and Equipment ( PPE ) NET ', '', 0, '1', '1', 0, 0, 1, 0, 0, 10000102, 0, 1, 0),
(514, '513', '1', 'Funiture, Fixtures & Fittings ', '', 0, '1', '1', 0, 0, 1, 0, 0, 1000010201, 0, 1, 0),
(515, '514', '1', 'Funiture, Fixtures & Fittings ', '', 0, '1', '1', 0, 0, 1, 0, 0, 100001020101, 0, 1, 0),
(516, '513', '1', 'Computer Equipment', '', 0, '1', '1', 0, 0, 1, 0, 0, 1000010202, 0, 1, 0),
(517, '516', '1', 'Computer Equipment', '', 0, '1', '1', 0, 0, 1, 0, 0, 100001020201, 0, 1, 0),
(518, '513', '1', 'Air Conditioner', '', 0, '1', '1', 0, 0, 1, 0, 0, 1000010203, 0, 1, 0),
(519, '513', '1', 'Electrical Equipements', '', 0, '1', '1', 0, 0, 1, 0, 0, 1000010204, 0, 1, 0),
(520, '513', '1', 'Motor Vehicles', '', 0, '1', '1', 0, 0, 1, 0, 0, 1000010205, 0, 1, 0),
(521, '513', '1', 'Plant & Machinery', '', 0, '1', '1', 0, 0, 1, 0, 0, 1000010206, 0, 1, 0),
(522, '513', '1', 'Accessories & Tools ', '', 0, '1', '1', 0, 0, 1, 0, 0, 1000010207, 0, 1, 0),
(523, '511', '1', 'Long Term Investments', '', 0, '1', '1', 0, 0, 1, 0, 0, 10000103, 0, 1, 0),
(524, '523', '1', 'Investments', '', 0, '1', '1', 0, 0, 1, 0, 0, 1000010301, 0, 1, 0),
(525, '511', '1', 'Capital Work In Progress ', '', 0, '1', '1', 0, 0, 1, 0, 0, 10000104, 0, 1, 0),
(526, '525', '1', 'Capital Work In Progress ', '', 0, '1', '1', 0, 0, 1, 0, 0, 1000010401, 0, 1, 0),
(527, '511', '1', 'Other Investments ', '', 0, '1', '1', 0, 0, 1, 0, 0, 10000105, 0, 1, 0),
(528, '1', '1', 'Current Assets', '', 0, '1', '1', 0, 0, 1, 0, 0, 100002, 0, 1, 0),
(529, '528', '1', 'Inventories', '', 0, '1', '1', 0, 0, 1, 0, 0, 10000201, 0, 1, 0),
(530, '529', '1', 'Consumable Items', '', 0, '1', '1', 0, 0, 1, 0, 0, 1000020101, 0, 1, 0),
(531, '529', '1', 'Good In Transit', '', 0, '1', '1', 0, 0, 1, 0, 0, 1000020102, 0, 1, 0),
(532, '529', '1', 'Slump Provision', '', 0, '1', '1', 0, 0, 1, 0, 0, 1000020103, 0, 1, 0),
(533, '532', '1', 'Provision for Inventory', '', 0, '1', '1', 0, 0, 1, 0, 0, 100002010301, 0, 1, 0),
(534, '528', '1', 'Net Accounts Receivable', '', 0, '1', '1', 0, 0, 1, 0, 0, 10000202, 0, 1, 0),
(535, '534', '1', 'Accounts Receivable', '', 0, '1', '1', 0, 0, 1, 0, 0, 1000020201, 0, 1, 0),
(536, '535', '1', 'Accounts Receivable', '', 0, '1', '1', 0, 0, 1, 0, 0, 100002020101, 0, 1, 0),
(537, '528', '1', 'Other Receivables', '', 0, '1', '1', 0, 0, 1, 0, 0, 10000203, 0, 1, 0),
(538, '537', '1', 'Other Receivables', '', 0, '1', '1', 0, 0, 1, 0, 0, 1000020301, 0, 1, 0),
(539, '538', '1', 'Other Receivables', '', 0, '1', '1', 0, 0, 1, 0, 0, 100002030101, 0, 1, 0),
(540, '538', '1', 'Due from Associate Company', '', 0, '1', '1', 0, 0, 1, 0, 0, 100002030102, 0, 1, 0),
(541, '528', '1', 'Advances, Deposits & Pre-payments', '', 0, '1', '1', 0, 0, 1, 0, 0, 10000204, 0, 1, 0),
(542, '541', '1', 'Advances, Deposits & Prepayments', '', 0, '1', '1', 0, 0, 1, 0, 0, 1000020401, 0, 1, 0),
(543, '542', '1', 'Advances', '', 0, '1', '1', 0, 0, 1, 0, 0, 100002040101, 0, 1, 0),
(544, '4', '1', 'Revenue', '', 0, '2', '1', 0, 0, 1, 0, 13, 400001, 0, 1, 0),
(545, '544', '1', 'Revenue ', '', 0, '2', '1', 0, 0, 1, 0, 13, 40000101, 0, 1, 0),
(546, '541', '1', 'Deposits', '', 0, '1', '1', 0, 0, 1, 0, 0, 1000020402, 0, 1, 0),
(547, '545', '1', 'Revenue ', '', 0, '2', '1', 0, 0, 1, 0, 13, 4000010101, 0, 1, 0),
(548, '546', '1', 'Deposits', '', 0, '1', '1', 0, 0, 1, 0, 0, 100002040201, 0, 1, 0),
(549, '547', '1', 'Rooms Revenue ', '', 0, '2', '1', 0, 0, 1, 0, 13, 400001010101, 0, 1, 0),
(550, '541', '1', 'Pre-Payments', '', 0, '1', '1', 0, 0, 1, 0, 0, 1000020403, 0, 1, 0),
(551, '550', '1', 'Pre-Payments', '', 0, '1', '1', 0, 0, 1, 0, 0, 100002040301, 0, 1, 0),
(553, '545', '1', 'Revenue Related To Activity ', '', 0, '2', '1', 0, 0, 1, 0, 13, 4000010102, 0, 1, 0),
(555, '109', '1', 'Cash In Hand', '', 0, '1', '1', 0, 0, 1, 0, 0, 100002050101, 0, 1, 0),
(556, '553', '1', 'Occasional Revenues ', '', 0, '2', '1', 0, 0, 1, 0, 13, 400001010201, 0, 1, 0),
(558, '12', '1', 'Cash At Bank', '', 0, '1', '1', 0, 0, 1, 0, 0, 100002050201, 0, 1, 0),
(559, '528', '1', 'Short Term Investment', '', 0, '1', '1', 0, 0, 1, 0, 0, 10000206, 0, 1, 0),
(560, '559', '1', 'Short Term Investment', '', 0, '1', '1', 0, 0, 1, 0, 0, 1000020601, 0, 1, 0),
(561, '4', '1', 'Other Revenue ', '', 0, '2', '1', 0, 0, 1, 0, 13, 400002, 0, 1, 0),
(562, '560', '1', 'Short Term Investment', '', 0, '1', '1', 0, 0, 1, 0, 0, 100002060101, 0, 1, 0),
(563, '561', '1', 'Other Revenue ', '', 0, '2', '1', 0, 0, 1, 0, 13, 40000201, 0, 1, 0),
(564, '563', '1', 'Other Revenue ', '', 0, '2', '1', 0, 0, 1, 0, 13, 4000020101, 0, 1, 0),
(565, '564', '1', 'Other Revenue ', '', 0, '2', '1', 0, 0, 1, 0, 13, 400002010101, 0, 1, 0),
(566, '528', '1', 'Notes Receivable', '', 0, '1', '1', 0, 0, 1, 0, 0, 10000207, 0, 1, 0),
(567, '566', '1', 'Notes Receivable', '', 0, '1', '1', 0, 0, 1, 0, 0, 1000020701, 0, 1, 0),
(568, '567', '1', 'Notes Receivable', '', 0, '1', '1', 0, 0, 1, 0, 0, 100002070101, 0, 1, 0),
(569, '3', '1', 'Cost of Activity ', '', 0, '1', '1', 0, 0, 1, 0, 12, 300001, 0, 1, 0),
(570, '2', '1', 'Non-current Liabilities', '', 0, '2', '1', 0, 0, 1, 0, 11, 200001, 0, 1, 0),
(571, '570', '1', 'Long Term Loan ', '', 0, '2', '1', 0, 0, 1, 0, 11, 20000101, 0, 1, 0),
(572, '571', '1', 'Long Term Loan ', '', 0, '2', '1', 0, 0, 1, 0, 11, 2000010101, 0, 1, 0),
(573, '572', '1', 'Long Term Loan', '', 0, '2', '1', 0, 0, 1, 0, 11, 200001010101, 0, 1, 0),
(574, '570', '1', 'Other Non Current Liabilities', '', 0, '2', '1', 0, 0, 1, 0, 11, 20000102, 0, 1, 0),
(575, '2', '1', 'Current Liabilities', '', 0, '2', '1', 0, 0, 1, 0, 11, 200002, 0, 1, 0),
(576, '575', '1', 'Accounts Payable', '', 0, '2', '1', 0, 0, 1, 0, 11, 20000201, 0, 1, 0),
(578, '77', '1', 'Trade Payables', '', 0, '2', '1', 0, 0, 1, 0, 11, 200002010101, 0, 1, 0),
(579, '569', '1', 'Cost of Material Consumed ', '', 0, '1', '1', 0, 0, 1, 0, 12, 30000101, 0, 1, 0),
(580, '579', '1', 'Material Consumption ', '', 0, '1', '1', 0, 0, 1, 0, 12, 3000010101, 0, 1, 0),
(581, '580', '1', 'Material Consumption ', '', 0, '1', '1', 0, 0, 1, 0, 12, 300001010101, 0, 1, 0),
(582, '77', '1', 'Accounts Payable', '', 0, '2', '1', 0, 0, 1, 0, 11, 200002010102, 0, 1, 0),
(583, '575', '1', 'Loan From Outsiders', '', 0, '2', '1', 0, 0, 1, 0, 11, 20000202, 0, 1, 0),
(584, '583', '1', 'Loan From Outsiders', '', 0, '2', '1', 0, 0, 1, 0, 11, 2000020201, 0, 1, 0),
(585, '584', '1', 'Payable to Others', '', 0, '2', '1', 0, 0, 1, 0, 11, 200002020101, 0, 1, 0),
(586, '575', '1', 'Short Term Loan', '', 0, '2', '1', 0, 0, 1, 0, 11, 20000203, 0, 1, 0),
(587, '586', '1', 'Short Term Loan', '', 0, '2', '1', 0, 0, 1, 0, 11, 2000020301, 0, 1, 0),
(588, '587', '1', 'Short Term Loan', '', 0, '2', '1', 0, 0, 1, 0, 11, 200002030101, 0, 1, 0),
(589, '579', '1', 'Discount Allowed ', '', 0, '1', '1', 0, 0, 1, 0, 12, 3000010102, 0, 1, 0),
(590, '589', '1', ' Discount Allowed ', '', 0, '1', '1', 0, 0, 1, 0, 12, 300001010201, 0, 1, 0),
(591, '579', '1', ' Stock Adjustment ', '', 0, '1', '1', 0, 0, 1, 0, 12, 3000010103, 0, 1, 0),
(592, '3', '1', ' Expenses For The Activity ', '', 0, '1', '1', 0, 0, 1, 0, 12, 300002, 0, 1, 0),
(593, '592', '1', ' Administrative Expenses ', '', 0, '1', '1', 0, 0, 1, 0, 12, 30000201, 0, 1, 0),
(594, '587', '1', 'Loan From Outsiders', '', 0, '2', '1', 0, 0, 1, 0, 11, 200002030102, 0, 1, 0),
(595, '593', '1', ' Administrative Expenses ', '', 0, '1', '1', 0, 0, 1, 0, 12, 3000020101, 0, 1, 0),
(596, '595', '1', ' Employee Related Expenses ', '', 0, '1', '1', 0, 0, 1, 0, 12, 300002010101, 0, 1, 0),
(597, '575', '1', 'Other Payables', '', 0, '2', '1', 0, 0, 1, 0, 11, 20000204, 0, 1, 0),
(598, '597', '1', 'Other Payables', '', 0, '2', '1', 0, 0, 1, 0, 11, 2000020401, 0, 1, 0),
(599, '598', '1', 'Unearned revenue', '', 0, '2', '1', 0, 0, 1, 0, 11, 200002040101, 0, 1, 0),
(600, '598', '1', 'End of Service Benefit Provision ', '', 0, '2', '1', 0, 0, 1, 0, 11, 200002040102, 0, 1, 0),
(601, '598', '1', 'Taxes Payable', '', 0, '2', '1', 0, 0, 1, 0, 11, 200002040103, 0, 1, 0),
(602, '598', '1', 'Dividends Payable', '', 0, '2', '1', 0, 0, 1, 0, 11, 200002040104, 0, 1, 0),
(603, '595', '1', ' Depreciation Expenses ', '', 0, '1', '1', 0, 0, 1, 0, 12, 300002010102, 0, 1, 0),
(604, '575', '1', 'Liabilities For Expenses', '', 0, '2', '1', 0, 0, 1, 0, 11, 20000205, 0, 1, 0),
(605, '595', '1', ' Amortization Expenses ', '', 0, '1', '1', 0, 0, 1, 0, 12, 300002010103, 0, 1, 0),
(606, '595', '1', ' Hotel Certification Expenses ', '', 0, '1', '1', 0, 0, 1, 0, 12, 300002010104, 0, 1, 0),
(607, '604', '1', 'Liabilities For Expenses', '', 0, '2', '1', 0, 0, 1, 0, 11, 2000020501, 0, 1, 0),
(608, '595', '1', ' Overhead Expenses ', '', 0, '1', '1', 0, 0, 1, 0, 12, 300002010105, 0, 1, 0),
(609, '595', '1', ' Rent or Lease Expenses ', '', 0, '1', '1', 0, 0, 1, 0, 12, 300002010106, 0, 1, 0),
(610, '595', '1', ' Maintenance ', '', 0, '1', '1', 0, 0, 1, 0, 12, 300002010107, 0, 1, 0),
(611, '595', '1', ' Diff & Expire Accounts ', '', 0, '1', '1', 0, 0, 1, 0, 12, 300002010108, 0, 1, 0),
(612, '595', '1', ' Fines ', '', 0, '1', '1', 0, 0, 1, 0, 12, 300002010109, 0, 1, 0),
(613, '592', '1', ' Sales & Marketing Expenses ', '', 0, '1', '1', 0, 0, 1, 0, 12, 30000202, 0, 1, 0),
(614, '613', '1', ' Marketing Expenses ', '', 0, '1', '1', 0, 0, 1, 0, 12, 3000020201, 0, 1, 0),
(615, '614', '1', ' Marketing Expenses ', '', 0, '1', '1', 0, 0, 1, 0, 12, 300002020101, 0, 1, 0),
(616, '614', '1', ' Tax Exp ', '', 0, '1', '1', 0, 0, 1, 0, 12, 300002020102, 0, 1, 0),
(617, '592', '1', ' Interest And Financial Charges ', '', 0, '1', '1', 0, 0, 1, 0, 12, 30000203, 0, 1, 0),
(618, '617', '1', ' Interest And Financial Charges ', '', 0, '1', '1', 0, 0, 1, 0, 12, 3000020301, 0, 1, 0),
(619, '83', '2', 'Consumable Items', '', 1, '1', '1', 0, 0, 1, 0, 0, 1000040801, 1, 1, 0),
(620, '83', '2', 'Revenue Items', '', 2, '1', '1', 0, 0, 1, 0, 0, 1000040802, 1, 1, 0),
(621, '83', '2', 'Expenses Items', '', 3, '1', '1', 0, 0, 1, 0, 0, 1000040803, 1, 1, 0),
(622, '83', '2', 'Fixed Assets', '', 4, '1', '1', 0, 0, 1, 0, 0, 1000040804, 1, 1, 0),
(623, '619', '2', 'Electrical Goods', '', 11, '1', '1', 0, 0, 1, 0, 0, 100004080101, 2, 1, 0),
(624, '619', '2', 'Plumbing Goods', '', 12, '1', '1', 0, 0, 1, 0, 0, 100004080102, 2, 1, 0),
(625, '619', '2', 'Fire & Safety', '', 13, '1', '1', 0, 0, 1, 0, 0, 100004080103, 2, 1, 0),
(626, '619', '2', 'Hardware Goods', '', 14, '1', '1', 0, 0, 1, 0, 0, 100004080104, 2, 1, 0),
(627, '619', '2', 'Guest Amenities', '', 15, '1', '1', 0, 0, 1, 0, 0, 100004080105, 2, 1, 0),
(628, '619', '2', 'Cleaning Goods', '', 16, '1', '1', 0, 0, 1, 0, 0, 100004080106, 2, 1, 0),
(629, '619', '2', 'Printing & Stationary', '', 17, '1', '1', 0, 0, 1, 0, 0, 100004080107, 2, 1, 0),
(630, '619', '2', 'Pest Control Goods', '', 18, '1', '1', 0, 0, 1, 0, 0, 100004080108, 2, 1, 0),
(631, '619', '2', 'General Goods', '', 19, '1', '1', 0, 0, 1, 0, 0, 100004080109, 2, 1, 0),
(632, '83', '2', 'Good In Transit', '', 1, '1', '1', 0, 0, 1, 0, 0, 1000040805, 1, 1, 0),
(633, '632', '2', 'Intermediary W. H Transfer', '', 1, '1', '1', 0, 0, 1, 0, 0, 100004080501, 2, 1, 0),
(634, '632', '2', 'Goods In Transit (Foreign)', '', 1, '1', '1', 0, 0, 1, 0, 0, 100004080502, 2, 1, 0),
(635, '83', '2', 'Slump Provision', '', 1, '1', '1', 0, 0, 1, 0, 0, 1000040806, 1, 1, 0),
(636, '635', '2', 'Provision for Inventory', '', 1, '1', '1', 0, 0, 1, 0, 0, 100004080601, 2, 1, 0),
(637, '622', '2', 'Funiture, Fixtures & Fittings', '', 41, '1', '1', 0, 0, 1, 0, 0, 100004080401, 2, 1, 0),
(640, '637', '2', 'Office Furniture', '', 411, '1', '1', 0, 0, 1, 0, 0, 10000408040101, 3, 1, 0),
(641, '637', '2', 'Hotel Furniture', '', 412, '1', '1', 0, 0, 1, 0, 0, 10000408040102, 3, 1, 0),
(645, '622', '2', 'Computer Equipment', '', 42, '1', '1', 0, 0, 1, 0, 0, 100004080402, 2, 1, 0),
(646, '645', '2', 'Computer & Accessories', '', 421, '1', '1', 0, 0, 1, 0, 0, 10000408040201, 3, 1, 0),
(647, '645', '2', 'Printer & Scanner', '', 422, '1', '1', 0, 0, 1, 0, 0, 10000408040202, 3, 1, 0),
(648, '622', '2', 'Air Conditioner', '', 43, '1', '1', 0, 0, 1, 0, 0, 100004080403, 2, 1, 0),
(649, '622', '2', 'Electrical Equipments', '', 44, '1', '1', 0, 0, 1, 0, 0, 100004080404, 2, 1, 0),
(650, '622', '2', 'Motor Vehicles', '', 45, '1', '1', 0, 0, 1, 0, 0, 100004080405, 2, 1, 0),
(651, '622', '2', 'Plant & Machinery', '', 46, '1', '1', 0, 0, 1, 0, 0, 100004080406, 2, 1, 0),
(652, '535', '1', 'Revceivable Agent', '', 0, '1', '1', 0, 0, 1, 0, 0, 100002020102, 0, 1, 0),
(653, '595', '1', 'Other Expenses', '', 0, '1', '1', 0, 0, 1, 0, 12, 300002010110, 0, 1, 0),
(654, '561', '1', 'Room Extra Charge', '', 0, '2', '1', 0, 0, 1, 0, 13, 40000202, 0, 1, 0),
(655, '619', '2', 'Electronic Good', '', 110, '1', '1', 0, 0, 1, 0, 0, 100004080110, 2, 1, 0),
(656, '620', '2', 'Rental Services', '', 21, '1', '1', 0, 0, 1, 0, 0, 100004080201, 2, 1, 0),
(657, '621', '2', 'Services Expenses', '', 1, '1', '1', 0, 0, 1, 0, 0, 100004080301, 2, 1, 0),
(658, '637', '2', 'Furniture Fittings', '', 413, '1', '1', 0, 0, 1, 0, 0, 10000408040103, 3, 1, 0),
(659, '657', '2', 'Electricity Bill', '', 1, '1', '1', 0, 0, 1, 0, 0, 10000408030101, 3, 1, 0),
(660, '657', '2', 'Water Bill', '', 1, '1', '1', 0, 0, 1, 0, 0, 10000408030102, 3, 1, 0),
(661, '657', '2', 'Consultancy fee', '', 1, '1', '1', 0, 0, 1, 0, 0, 10000408030103, 3, 1, 0),
(662, '657', '2', 'Postal Charges', '', 1, '1', '1', 0, 0, 1, 0, 0, 10000408030104, 3, 1, 0),
(663, '657', '2', 'Internet Charges', '', 1, '1', '1', 0, 0, 1, 0, 0, 10000408030105, 3, 1, 0),
(664, '657', '2', 'Telecom Expenses', '', 1, '1', '1', 0, 0, 1, 0, 0, 10000408030106, 3, 1, 0),
(665, '657', '2', 'Printing & Stationary', '', 1, '1', '1', 0, 0, 1, 0, 0, 10000408030107, 3, 1, 0),
(666, '657', '2', 'Advertisement Expenses', '', 1, '1', '1', 0, 0, 1, 0, 0, 10000408030108, 3, 1, 0),
(667, '657', '2', 'Machinery Maintenance', '', 1, '1', '1', 0, 0, 1, 0, 0, 10000408030109, 3, 1, 0),
(668, '657', '2', 'Repair & Other Maintenance', '', 1, '1', '1', 0, 0, 1, 0, 0, 10000408030110, 3, 1, 0),
(669, '657', '2', 'Electrical Maintenance', '', 1, '1', '1', 0, 0, 1, 0, 0, 10000408030111, 3, 1, 0),
(670, '657', '2', 'Vehicle Maintenance', '', 1, '1', '1', 0, 0, 1, 0, 0, 10000408030112, 3, 1, 0),
(671, '657', '2', 'Elevators Maintenance', '', 1, '1', '1', 0, 0, 1, 0, 0, 10000408030113, 3, 1, 0),
(672, '656', '2', 'Daily', '', 1, '1', '1', 0, 0, 1, 0, 0, 10000408020101, 3, 1, 0),
(673, '656', '2', 'Monthly', '', 1, '1', '1', 0, 0, 1, 0, 0, 10000408020102, 3, 1, 0),
(674, '656', '2', 'Quarterly', '', 1, '1', '1', 0, 0, 1, 0, 0, 10000408020103, 3, 1, 0),
(675, '656', '2', 'Half-Yearly', '', 1, '1', '1', 0, 0, 1, 0, 0, 10000408020104, 3, 1, 0),
(676, '656', '2', 'Yearly', '', 1, '1', '1', 0, 0, 1, 0, 0, 10000408020105, 3, 1, 0),
(677, '619', '2', 'Test group', '', 0, '1', '1', 0, 0, 1, 0, 0, 100004080111, 2, 1, 0),
(678, '656', '2', 'Allotment', '', 1, '1', '1', 0, 0, 1, 0, 0, 10000408020106, 3, 1, 0),
(679, '619', '2', 'Test group 2', '', 123, '1', '1', 0, 0, 1, 0, 0, 100004080112, 2, 1, 0),
(680, '619', '2', 'Test Group 3', '', 0, '1', '1', 0, 0, 1, 0, 0, 100004080113, 2, 1, 0),
(681, '619', '2', 'Test group 4', '', 444, '1', '1', 0, 0, 1, 0, 0, 100004080114, 2, 1, 0),
(686, '619', '2', 'Test 5', '', 101, '1', '1', 0, 0, 1, 0, 0, 100004080115, 2, 1, 0),
(687, '619', '2', 'Electrical Goods-test', '', 1, '1', '1', 0, 0, 1, 0, 0, 100004080116, 2, 1, 0),
(688, '83', '2', 'Restaurant Items', '', 1, '1', '1', 0, 0, 1, 0, 0, 1000040807, 1, 1, 0),
(689, '688', '2', 'Meat Items', '', 1, '1', '1', 0, 0, 1, 0, 0, 100004080701, 2, 1, 0),
(690, '688', '2', 'Poultry', '', 1, '1', '1', 0, 0, 1, 0, 0, 100004080702, 2, 1, 0);

--
-- Indexes for dumped tables
--

--
-- Indexes for table `setting`
--
ALTER TABLE `setting`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `id` (`id`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `setting`
--
ALTER TABLE `setting`
  MODIFY `id` int(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=691;
COMMIT;

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
