---
--- Dumping data for table `0_chart_master`
---
-
-INSERT INTO `0_chart_master` VALUES ('1060', '', 'Checking Account', '1', 0);
-INSERT INTO `0_chart_master` VALUES ('1065', '', 'Petty Cash', '1', 0);
-INSERT INTO `0_chart_master` VALUES ('1200', '', 'Accounts Receivables', '1', 0);
-INSERT INTO `0_chart_master` VALUES ('1205', '', 'Allowance for doubtful accounts', '1', 0);
-INSERT INTO `0_chart_master` VALUES ('1510', '', 'Inventory', '2', 0);
-INSERT INTO `0_chart_master` VALUES ('1520', '', 'Stocks of Raw Materials', '2', 0);
-INSERT INTO `0_chart_master` VALUES ('1530', '', 'Stocks of Work In Progress', '2', 0);
-INSERT INTO `0_chart_master` VALUES ('1540', '', 'Stocks of Finished Goods', '2', 0);
-INSERT INTO `0_chart_master` VALUES ('1550', '', 'Goods Received Clearing account', '2', 0);
-INSERT INTO `0_chart_master` VALUES ('1820', '', 'Office Furniture & Equipment', '3', 0);
-INSERT INTO `0_chart_master` VALUES ('1825', '', 'Accum. Amort. -Furn. & Equip.', '3', 0);
-INSERT INTO `0_chart_master` VALUES ('1840', '', 'Vehicle', '3', 0);
-INSERT INTO `0_chart_master` VALUES ('1845', '', 'Accum. Amort. -Vehicle', '3', 0);
-INSERT INTO `0_chart_master` VALUES ('2100', '', 'Accounts Payable', '4', 0);
-INSERT INTO `0_chart_master` VALUES ('2110', '', 'Accrued Income Tax - Federal', '4', 0);
-INSERT INTO `0_chart_master` VALUES ('2120', '', 'Accrued Income Tax - State', '4', 0);
-INSERT INTO `0_chart_master` VALUES ('2130', '', 'Accrued Franchise Tax', '4', 0);
-INSERT INTO `0_chart_master` VALUES ('2140', '', 'Accrued Real & Personal Prop Tax', '4', 0);
-INSERT INTO `0_chart_master` VALUES ('2150', '', 'Sales Tax', '4', 0);
-INSERT INTO `0_chart_master` VALUES ('2160', '', 'Accrued Use Tax Payable', '4', 0);
-INSERT INTO `0_chart_master` VALUES ('2210', '', 'Accrued Wages', '4', 0);
-INSERT INTO `0_chart_master` VALUES ('2220', '', 'Accrued Comp Time', '4', 0);
-INSERT INTO `0_chart_master` VALUES ('2230', '', 'Accrued Holiday Pay', '4', 0);
-INSERT INTO `0_chart_master` VALUES ('2240', '', 'Accrued Vacation Pay', '4', 0);
-INSERT INTO `0_chart_master` VALUES ('2310', '', 'Accr. Benefits - 401K', '4', 0);
-INSERT INTO `0_chart_master` VALUES ('2320', '', 'Accr. Benefits - Stock Purchase', '4', 0);
-INSERT INTO `0_chart_master` VALUES ('2330', '', 'Accr. Benefits - Med, Den', '4', 0);
-INSERT INTO `0_chart_master` VALUES ('2340', '', 'Accr. Benefits - Payroll Taxes', '4', 0);
-INSERT INTO `0_chart_master` VALUES ('2350', '', 'Accr. Benefits - Credit Union', '4', 0);
-INSERT INTO `0_chart_master` VALUES ('2360', '', 'Accr. Benefits - Savings Bond', '4', 0);
-INSERT INTO `0_chart_master` VALUES ('2370', '', 'Accr. Benefits - Garnish', '4', 0);
-INSERT INTO `0_chart_master` VALUES ('2380', '', 'Accr. Benefits - Charity Cont.', '4', 0);
-INSERT INTO `0_chart_master` VALUES ('2620', '', 'Bank Loans', '5', 0);
-INSERT INTO `0_chart_master` VALUES ('2680', '', 'Loans from Shareholders', '5', 0);
-INSERT INTO `0_chart_master` VALUES ('3350', '', 'Common Shares', '6', 0);
-INSERT INTO `0_chart_master` VALUES ('3590', '', 'Retained Earnings - prior years', '7', 0);
-INSERT INTO `0_chart_master` VALUES ('4010', '', 'Sales', '8', 0);
-INSERT INTO `0_chart_master` VALUES ('4430', '', 'Shipping & Handling', '9', 0);
-INSERT INTO `0_chart_master` VALUES ('4440', '', 'Interest', '9', 0);
-INSERT INTO `0_chart_master` VALUES ('4450', '', 'Foreign Exchange Gain', '9', 0);
-INSERT INTO `0_chart_master` VALUES ('4500', '', 'Prompt Payment Discounts', '9', 0);
-INSERT INTO `0_chart_master` VALUES ('4510', '', 'Discounts Given', '9', 0);
-INSERT INTO `0_chart_master` VALUES ('5010', '', 'Cost of Goods Sold - Retail', '10', 0);
-INSERT INTO `0_chart_master` VALUES ('5020', '', 'Material Usage Varaiance', '10', 0);
-INSERT INTO `0_chart_master` VALUES ('5030', '', 'Consumable Materials', '10', 0);
-INSERT INTO `0_chart_master` VALUES ('5040', '', 'Purchase price Variance', '10', 0);
-INSERT INTO `0_chart_master` VALUES ('5050', '', 'Purchases of materials', '10', 0);
-INSERT INTO `0_chart_master` VALUES ('5060', '', 'Discounts Received', '10', 0);
-INSERT INTO `0_chart_master` VALUES ('5100', '', 'Freight', '10', 0);
-INSERT INTO `0_chart_master` VALUES ('5410', '', 'Wages & Salaries', '11', 0);
-INSERT INTO `0_chart_master` VALUES ('5420', '', 'Wages - Overtime', '11', 0);
-INSERT INTO `0_chart_master` VALUES ('5430', '', 'Benefits - Comp Time', '11', 0);
-INSERT INTO `0_chart_master` VALUES ('5440', '', 'Benefits - Payroll Taxes', '11', 0);
-INSERT INTO `0_chart_master` VALUES ('5450', '', 'Benefits - Workers Comp', '11', 0);
-INSERT INTO `0_chart_master` VALUES ('5460', '', 'Benefits - Pension', '11', 0);
-INSERT INTO `0_chart_master` VALUES ('5470', '', 'Benefits - General Benefits', '11', 0);
-INSERT INTO `0_chart_master` VALUES ('5510', '', 'Inc Tax Exp - Federal', '11', 0);
-INSERT INTO `0_chart_master` VALUES ('5520', '', 'Inc Tax Exp - State', '11', 0);
-INSERT INTO `0_chart_master` VALUES ('5530', '', 'Taxes - Real Estate', '11', 0);
-INSERT INTO `0_chart_master` VALUES ('5540', '', 'Taxes - Personal Property', '11', 0);
-INSERT INTO `0_chart_master` VALUES ('5550', '', 'Taxes - Franchise', '11', 0);
-INSERT INTO `0_chart_master` VALUES ('5560', '', 'Taxes - Foreign Withholding', '11', 0);
-INSERT INTO `0_chart_master` VALUES ('5610', '', 'Accounting & Legal', '12', 0);
-INSERT INTO `0_chart_master` VALUES ('5615', '', 'Advertising & Promotions', '12', 0);
-INSERT INTO `0_chart_master` VALUES ('5620', '', 'Bad Debts', '12', 0);
-INSERT INTO `0_chart_master` VALUES ('5660', '', 'Amortization Expense', '12', 0);
-INSERT INTO `0_chart_master` VALUES ('5685', '', 'Insurance', '12', 0);
-INSERT INTO `0_chart_master` VALUES ('5690', '', 'Interest & Bank Charges', '12', 0);
-INSERT INTO `0_chart_master` VALUES ('5700', '', 'Office Supplies', '12', 0);
-INSERT INTO `0_chart_master` VALUES ('5760', '', 'Rent', '12', 0);
-INSERT INTO `0_chart_master` VALUES ('5765', '', 'Repair & Maintenance', '12', 0);
-INSERT INTO `0_chart_master` VALUES ('5780', '', 'Telephone', '12', 0);
-INSERT INTO `0_chart_master` VALUES ('5785', '', 'Travel & Entertainment', '12', 0);
-INSERT INTO `0_chart_master` VALUES ('5790', '', 'Utilities', '12', 0);
-INSERT INTO `0_chart_master` VALUES ('5795', '', 'Registrations', '12', 0);
-INSERT INTO `0_chart_master` VALUES ('5800', '', 'Licenses', '12', 0);
-INSERT INTO `0_chart_master` VALUES ('5810', '', 'Foreign Exchange Loss', '12', 0);
-INSERT INTO `0_chart_master` VALUES ('9990', '', 'Year Profit/Loss', '12', 0);
-
--- --------------------------------------------------------
-
---
--- Table structure for table `0_chart_types`
---
+-- Data of table `0_chart_master` --
+
+INSERT INTO `0_chart_master` VALUES
+('1060', '', 'Checking Account', '1', '0'),
+('1065', '', 'Petty Cash', '1', '0'),
+('1200', '', 'Accounts Receivables', '1', '0'),
+('1205', '', 'Allowance for doubtful accounts', '1', '0'),
+('1510', '', 'Inventory', '2', '0'),
+('1520', '', 'Stocks of Raw Materials', '2', '0'),
+('1530', '', 'Stocks of Work In Progress', '2', '0'),
+('1540', '', 'Stocks of Finished Goods', '2', '0'),
+('1550', '', 'Goods Received Clearing account', '2', '0'),
+('1820', '', 'Office Furniture & Equipment', '3', '0'),
+('1825', '', 'Accum. Amort. -Furn. & Equip.', '3', '0'),
+('1840', '', 'Vehicle', '3', '0'),
+('1845', '', 'Accum. Amort. -Vehicle', '3', '0'),
+('2100', '', 'Accounts Payable', '4', '0'),
+('2105', '', 'Deferred Income', '4', '0'),
+('2110', '', 'Accrued Income Tax - Federal', '4', '0'),
+('2120', '', 'Accrued Income Tax - State', '4', '0'),
+('2130', '', 'Accrued Franchise Tax', '4', '0'),
+('2140', '', 'Accrued Real & Personal Prop Tax', '4', '0'),
+('2150', '', 'Sales Tax', '4', '0'),
+('2160', '', 'Accrued Use Tax Payable', '4', '0'),
+('2210', '', 'Accrued Wages', '4', '0'),
+('2220', '', 'Accrued Comp Time', '4', '0'),
+('2230', '', 'Accrued Holiday Pay', '4', '0'),
+('2240', '', 'Accrued Vacation Pay', '4', '0'),
+('2310', '', 'Accr. Benefits - 401K', '4', '0'),
+('2320', '', 'Accr. Benefits - Stock Purchase', '4', '0'),
+('2330', '', 'Accr. Benefits - Med, Den', '4', '0'),
+('2340', '', 'Accr. Benefits - Payroll Taxes', '4', '0'),
+('2350', '', 'Accr. Benefits - Credit Union', '4', '0'),
+('2360', '', 'Accr. Benefits - Savings Bond', '4', '0'),
+('2370', '', 'Accr. Benefits - Garnish', '4', '0'),
+('2380', '', 'Accr. Benefits - Charity Cont.', '4', '0'),
+('2620', '', 'Bank Loans', '5', '0'),
+('2680', '', 'Loans from Shareholders', '5', '0'),
+('3350', '', 'Common Shares', '6', '0'),
+('3590', '', 'Retained Earnings - prior years', '7', '0'),
+('4010', '', 'Sales', '8', '0'),
+('4430', '', 'Shipping & Handling', '9', '0'),
+('4440', '', 'Interest', '9', '0'),
+('4450', '', 'Foreign Exchange Gain', '9', '0'),
+('4500', '', 'Prompt Payment Discounts', '9', '0'),
+('4510', '', 'Discounts Given', '9', '0'),
+('5010', '', 'Cost of Goods Sold - Retail', '10', '0'),
+('5020', '', 'Material Usage Varaiance', '10', '0'),
+('5030', '', 'Consumable Materials', '10', '0'),
+('5040', '', 'Purchase price Variance', '10', '0'),
+('5050', '', 'Purchases of materials', '10', '0'),
+('5060', '', 'Discounts Received', '10', '0'),
+('5100', '', 'Freight', '10', '0'),
+('5410', '', 'Wages & Salaries', '11', '0'),
+('5420', '', 'Wages - Overtime', '11', '0'),
+('5430', '', 'Benefits - Comp Time', '11', '0'),
+('5440', '', 'Benefits - Payroll Taxes', '11', '0'),
+('5450', '', 'Benefits - Workers Comp', '11', '0'),
+('5460', '', 'Benefits - Pension', '11', '0'),
+('5470', '', 'Benefits - General Benefits', '11', '0'),
+('5510', '', 'Inc Tax Exp - Federal', '11', '0'),
+('5520', '', 'Inc Tax Exp - State', '11', '0'),
+('5530', '', 'Taxes - Real Estate', '11', '0'),
+('5540', '', 'Taxes - Personal Property', '11', '0'),
+('5550', '', 'Taxes - Franchise', '11', '0'),
+('5560', '', 'Taxes - Foreign Withholding', '11', '0'),
+('5610', '', 'Accounting & Legal', '12', '0'),
+('5615', '', 'Advertising & Promotions', '12', '0'),
+('5620', '', 'Bad Debts', '12', '0'),
+('5660', '', 'Amortization Expense', '12', '0'),
+('5685', '', 'Insurance', '12', '0'),
+('5690', '', 'Interest & Bank Charges', '12', '0'),
+('5700', '', 'Office Supplies', '12', '0'),
+('5760', '', 'Rent', '12', '0'),
+('5765', '', 'Repair & Maintenance', '12', '0'),
+('5780', '', 'Telephone', '12', '0'),
+('5785', '', 'Travel & Entertainment', '12', '0'),
+('5790', '', 'Utilities', '12', '0'),
+('5795', '', 'Registrations', '12', '0'),
+('5800', '', 'Licenses', '12', '0'),
+('5810', '', 'Foreign Exchange Loss', '12', '0'),
+('9990', '', 'Year Profit/Loss', '12', '0');
+
+-- Structure of table `0_chart_types` --