1 # Built by FrontAccounting 2.1.2
2 # http://frontaccounting.net
3 # Company: Training Co.
8 ### Structure of table `0_areas` ###
10 DROP TABLE IF EXISTS `0_areas`;
12 CREATE TABLE `0_areas` (
13 `area_code` int(11) NOT NULL auto_increment,
14 `description` varchar(60) NOT NULL default '',
15 `inactive` tinyint(1) NOT NULL default '0',
16 PRIMARY KEY (`area_code`),
17 UNIQUE KEY `description` (`description`)
18 ) TYPE=MyISAM AUTO_INCREMENT=2 ;
21 ### Data of table `0_areas` ###
23 INSERT INTO `0_areas` VALUES ('1', 'Global', '0');
26 ### Structure of table `0_attachments` ###
28 DROP TABLE IF EXISTS `0_attachments`;
30 CREATE TABLE `0_attachments` (
31 `id` int(11) unsigned NOT NULL auto_increment,
32 `description` varchar(60) NOT NULL default '',
33 `type_no` int(11) NOT NULL default '0',
34 `trans_no` int(11) NOT NULL default '0',
35 `unique_name` varchar(60) NOT NULL default '',
36 `tran_date` date NOT NULL default '0000-00-00',
37 `filename` varchar(60) NOT NULL default '',
38 `filesize` int(11) NOT NULL default '0',
39 `filetype` varchar(60) NOT NULL default '',
41 KEY `type_no` (`type_no`,`trans_no`)
42 ) TYPE=MyISAM AUTO_INCREMENT=1 ;
45 ### Data of table `0_attachments` ###
47 ### Structure of table `0_audit_trail` ###
49 DROP TABLE IF EXISTS `0_audit_trail`;
51 CREATE TABLE `0_audit_trail` (
52 `id` int(11) NOT NULL AUTO_INCREMENT,
53 `type` smallint(6) unsigned NOT NULL default '0',
54 `trans_no` int(11) unsigned NOT NULL default '0',
55 `user` smallint(6) unsigned NOT NULL default '0',
56 `stamp` timestamp NOT NULL,
57 `description` varchar(60) default NULL,
58 `fiscal_year` int(11) NOT NULL,
59 `gl_date` date NOT NULL default '0000-00-00',
60 `gl_seq` int(11) unsigned default NULL,
62 KEY (`fiscal_year`, `gl_seq`)
65 ### Data of table `0_audit_trail` ###
71 ### Structure of table `0_bank_accounts` ###
73 DROP TABLE IF EXISTS `0_bank_accounts`;
75 CREATE TABLE `0_bank_accounts` (
76 `account_code` varchar(11) NOT NULL default '',
77 `account_type` smallint(6) NOT NULL default '0',
78 `bank_account_name` varchar(60) NOT NULL default '',
79 `bank_account_number` varchar(100) NOT NULL default '',
80 `bank_name` varchar(60) NOT NULL default '',
81 `bank_address` tinytext,
82 `bank_curr_code` char(3) NOT NULL default '',
83 `id` smallint(6) NOT NULL auto_increment,
84 `last_reconciled_date` timestamp NOT NULL default '0000-00-00 00:00:00',
85 `ending_reconcile_balance` double NOT NULL default '0',
86 `inactive` tinyint(1) NOT NULL default '0',
88 KEY `bank_account_name` (`bank_account_name`),
89 KEY `bank_account_number` (`bank_account_number`)
90 ) TYPE=MyISAM AUTO_INCREMENT=3 ;
93 ### Data of table `0_bank_accounts` ###
95 INSERT INTO `0_bank_accounts` VALUES ('1060', '0', 'Current account', '9999999999', 'Wachovia Bank', '', 'USD', '1', '0000-00-00 00:00:00', '0', '0');
96 INSERT INTO `0_bank_accounts` VALUES ('1065', '3', 'Petty Cash account', 'N/A', 'N/A', '', 'USD', '2', '0000-00-00 00:00:00', '0', '0');
99 ### Structure of table `0_bank_trans` ###
101 DROP TABLE IF EXISTS `0_bank_trans`;
103 CREATE TABLE `0_bank_trans` (
104 `id` int(11) NOT NULL auto_increment,
105 `type` smallint(6) default NULL,
106 `trans_no` int(11) default NULL,
107 `bank_act` varchar(11) default NULL,
108 `ref` varchar(40) default NULL,
109 `trans_date` date NOT NULL default '0000-00-00',
110 `amount` double default NULL,
111 `dimension_id` int(11) NOT NULL default '0',
112 `dimension2_id` int(11) NOT NULL default '0',
113 `person_type_id` int(11) NOT NULL default '0',
114 `person_id` tinyblob,
115 `reconciled` date default NULL,
117 KEY `bank_act` (`bank_act`,`ref`),
118 KEY `type` (`type`,`trans_no`)
119 ) TYPE=InnoDB AUTO_INCREMENT=12 ;
122 ### Data of table `0_bank_trans` ###
124 INSERT INTO `0_bank_trans` VALUES ('1', '22', '4', '1', '1', '2009-06-21', '-3465', '0', '0', '3', '2', '');
125 INSERT INTO `0_bank_trans` VALUES ('2', '26', '1', '1', '', '2009-06-21', '-10', '0', '0', '1', '1', '');
126 INSERT INTO `0_bank_trans` VALUES ('3', '26', '1', '1', '', '2009-06-21', '-20', '0', '0', '1', '0', '');
127 INSERT INTO `0_bank_trans` VALUES ('4', '0', '18', '1', '1', '2009-02-20', '1000', '0', '0', '0', '', '');
128 INSERT INTO `0_bank_trans` VALUES ('5', '0', '19', '1', '2', '2009-02-21', '4000', '0', '0', '0', '', '');
129 INSERT INTO `0_bank_trans` VALUES ('6', '2', '5', '1', '1', '2009-06-21', '100', '0', '0', '4', '3', '');
130 INSERT INTO `0_bank_trans` VALUES ('7', '1', '8', '1', '1', '2009-06-21', '-50', '0', '0', '4', '1', '');
131 INSERT INTO `0_bank_trans` VALUES ('8', '26', '5', '1', '', '2009-06-21', '-10', '0', '0', '1', '1', '');
132 INSERT INTO `0_bank_trans` VALUES ('9', '26', '5', '1', '', '2009-06-21', '-20', '0', '0', '1', '0', '');
133 INSERT INTO `0_bank_trans` VALUES ('10', '26', '7', '1', '', '2009-06-21', '-10', '0', '0', '1', '1', '');
134 INSERT INTO `0_bank_trans` VALUES ('11', '26', '7', '1', '', '2009-06-21', '-20', '0', '0', '1', '0', '');
137 ### Structure of table `0_bom` ###
139 DROP TABLE IF EXISTS `0_bom`;
141 CREATE TABLE `0_bom` (
142 `id` int(11) NOT NULL auto_increment,
143 `parent` char(20) NOT NULL default '',
144 `component` char(20) NOT NULL default '',
145 `workcentre_added` int(11) NOT NULL default '0',
146 `loc_code` char(5) NOT NULL default '',
147 `quantity` double NOT NULL default '1',
148 PRIMARY KEY (`parent`,`component`,`workcentre_added`,`loc_code`),
149 KEY `component` (`component`),
151 KEY `loc_code` (`loc_code`),
152 KEY `parent` (`parent`,`loc_code`),
153 KEY `Parent_2` (`parent`),
154 KEY `workcentre_added` (`workcentre_added`)
155 ) TYPE=MyISAM AUTO_INCREMENT=4 ;
158 ### Data of table `0_bom` ###
160 INSERT INTO `0_bom` VALUES ('1', '3400', '102', '1', 'DEF', '1');
161 INSERT INTO `0_bom` VALUES ('2', '3400', '103', '1', 'DEF', '1');
162 INSERT INTO `0_bom` VALUES ('3', '3400', '104', '1', 'DEF', '1');
165 ### Structure of table `0_budget_trans` ###
167 DROP TABLE IF EXISTS `0_budget_trans`;
169 CREATE TABLE `0_budget_trans` (
170 `counter` int(11) NOT NULL auto_increment,
171 `type` smallint(6) NOT NULL default '0',
172 `type_no` bigint(16) NOT NULL default '1',
173 `tran_date` date NOT NULL default '0000-00-00',
174 `account` varchar(11) NOT NULL default '',
175 `memo_` tinytext NOT NULL,
176 `amount` double NOT NULL default '0',
177 `dimension_id` int(11) default '0',
178 `dimension2_id` int(11) default '0',
179 `person_type_id` int(11) default NULL,
180 `person_id` tinyblob,
181 PRIMARY KEY (`counter`),
182 KEY `Type_and_Number` (`type`,`type_no`)
183 ) TYPE=InnoDB AUTO_INCREMENT=1 ;
186 ### Data of table `0_budget_trans` ###
190 ### Structure of table `0_chart_class` ###
192 DROP TABLE IF EXISTS `0_chart_class`;
194 CREATE TABLE `0_chart_class` (
195 `cid` int(11) NOT NULL default '0',
196 `class_name` varchar(60) NOT NULL default '',
197 `ctype` tinyint(1) NOT NULL default '0',
198 `inactive` tinyint(1) NOT NULL default '0',
203 ### Data of table `0_chart_class` ###
205 INSERT INTO `0_chart_class` VALUES ('1', 'Assets', '1', '0');
206 INSERT INTO `0_chart_class` VALUES ('2', 'Liabilities', '2', '0');
207 INSERT INTO `0_chart_class` VALUES ('3', 'Income', '4', '0');
208 INSERT INTO `0_chart_class` VALUES ('4', 'Costs', '6', '0');
211 ### Structure of table `0_chart_master` ###
213 DROP TABLE IF EXISTS `0_chart_master`;
215 CREATE TABLE `0_chart_master` (
216 `account_code` varchar(11) NOT NULL default '',
217 `account_code2` varchar(11) default '',
218 `account_name` varchar(60) NOT NULL default '',
219 `account_type` int(11) NOT NULL default '0',
220 `inactive` tinyint(1) NOT NULL default '0',
221 PRIMARY KEY (`account_code`),
222 KEY `account_code` (`account_code`),
223 KEY `account_name` (`account_name`)
227 ### Data of table `0_chart_master` ###
229 INSERT INTO `0_chart_master` VALUES ('1060', '', 'Checking Account', '1', '0');
230 INSERT INTO `0_chart_master` VALUES ('1065', '', 'Petty Cash', '1', '0');
231 INSERT INTO `0_chart_master` VALUES ('1200', '', 'Accounts Receivables', '1', '0');
232 INSERT INTO `0_chart_master` VALUES ('1205', '', 'Allowance for doubtful accounts', '1', '0');
233 INSERT INTO `0_chart_master` VALUES ('1510', '', 'Inventory', '2', '0');
234 INSERT INTO `0_chart_master` VALUES ('1520', '', 'Stocks of Raw Materials', '2', '0');
235 INSERT INTO `0_chart_master` VALUES ('1530', '', 'Stocks of Work In Progress', '2', '0');
236 INSERT INTO `0_chart_master` VALUES ('1540', '', 'Stocks of Finsihed Goods', '2', '0');
237 INSERT INTO `0_chart_master` VALUES ('1550', '', 'Goods Received Clearing account', '2', '0');
238 INSERT INTO `0_chart_master` VALUES ('1820', '', 'Office Furniture & Equipment', '3', '0');
239 INSERT INTO `0_chart_master` VALUES ('1825', '', 'Accum. Amort. -Furn. & Equip.', '3', '0');
240 INSERT INTO `0_chart_master` VALUES ('1840', '', 'Vehicle', '3', '0');
241 INSERT INTO `0_chart_master` VALUES ('1845', '', 'Accum. Amort. -Vehicle', '3', '0');
242 INSERT INTO `0_chart_master` VALUES ('2100', '', 'Accounts Payable', '4', '0');
243 INSERT INTO `0_chart_master` VALUES ('2110', '', 'Accrued Income Tax - Federal', '4', '0');
244 INSERT INTO `0_chart_master` VALUES ('2120', '', 'Accrued Income Tax - State', '4', '0');
245 INSERT INTO `0_chart_master` VALUES ('2130', '', 'Accrued Franchise Tax', '4', '0');
246 INSERT INTO `0_chart_master` VALUES ('2140', '', 'Accrued Real & Personal Prop Tax', '4', '0');
247 INSERT INTO `0_chart_master` VALUES ('2150', '', 'Sales Tax', '4', '0');
248 INSERT INTO `0_chart_master` VALUES ('2160', '', 'Accrued Use Tax Payable', '4', '0');
249 INSERT INTO `0_chart_master` VALUES ('2210', '', 'Accrued Wages', '4', '0');
250 INSERT INTO `0_chart_master` VALUES ('2220', '', 'Accrued Comp Time', '4', '0');
251 INSERT INTO `0_chart_master` VALUES ('2230', '', 'Accrued Holiday Pay', '4', '0');
252 INSERT INTO `0_chart_master` VALUES ('2240', '', 'Accrued Vacation Pay', '4', '0');
253 INSERT INTO `0_chart_master` VALUES ('2310', '', 'Accr. Benefits - 401K', '4', '0');
254 INSERT INTO `0_chart_master` VALUES ('2320', '', 'Accr. Benefits - Stock Purchase', '4', '0');
255 INSERT INTO `0_chart_master` VALUES ('2330', '', 'Accr. Benefits - Med, Den', '4', '0');
256 INSERT INTO `0_chart_master` VALUES ('2340', '', 'Accr. Benefits - Payroll Taxes', '4', '0');
257 INSERT INTO `0_chart_master` VALUES ('2350', '', 'Accr. Benefits - Credit Union', '4', '0');
258 INSERT INTO `0_chart_master` VALUES ('2360', '', 'Accr. Benefits - Savings Bond', '4', '0');
259 INSERT INTO `0_chart_master` VALUES ('2370', '', 'Accr. Benefits - Garnish', '4', '0');
260 INSERT INTO `0_chart_master` VALUES ('2380', '', 'Accr. Benefits - Charity Cont.', '4', '0');
261 INSERT INTO `0_chart_master` VALUES ('2620', '', 'Bank Loans', '5', '0');
262 INSERT INTO `0_chart_master` VALUES ('2680', '', 'Loans from Shareholders', '5', '0');
263 INSERT INTO `0_chart_master` VALUES ('3350', '', 'Common Shares', '6', '0');
264 INSERT INTO `0_chart_master` VALUES ('3590', '', 'Retained Earnings - prior years', '7', '0');
265 INSERT INTO `0_chart_master` VALUES ('4010', '', 'Sales', '8', '0');
266 INSERT INTO `0_chart_master` VALUES ('4430', '', 'Shipping & Handling', '9', '0');
267 INSERT INTO `0_chart_master` VALUES ('4440', '', 'Interest', '9', '0');
268 INSERT INTO `0_chart_master` VALUES ('4450', '', 'Foreign Exchange Gain', '9', '0');
269 INSERT INTO `0_chart_master` VALUES ('4500', '', 'Prompt Payment Discounts', '9', '0');
270 INSERT INTO `0_chart_master` VALUES ('4510', '', 'Discounts Given', '9', '0');
271 INSERT INTO `0_chart_master` VALUES ('5010', '', 'Cost of Goods Sold - Retail', '10', '0');
272 INSERT INTO `0_chart_master` VALUES ('5020', '', 'Material Usage Varaiance', '10', '0');
273 INSERT INTO `0_chart_master` VALUES ('5030', '', 'Consumable Materials', '10', '0');
274 INSERT INTO `0_chart_master` VALUES ('5040', '', 'Purchase price Variance', '10', '0');
275 INSERT INTO `0_chart_master` VALUES ('5050', '', 'Purchases of materials', '10', '0');
276 INSERT INTO `0_chart_master` VALUES ('5060', '', 'Discounts Received', '10', '0');
277 INSERT INTO `0_chart_master` VALUES ('5100', '', 'Freight', '10', '0');
278 INSERT INTO `0_chart_master` VALUES ('5410', '', 'Wages & Salaries', '11', '0');
279 INSERT INTO `0_chart_master` VALUES ('5420', '', 'Wages - Overtime', '11', '0');
280 INSERT INTO `0_chart_master` VALUES ('5430', '', 'Benefits - Comp Time', '11', '0');
281 INSERT INTO `0_chart_master` VALUES ('5440', '', 'Benefits - Payroll Taxes', '11', '0');
282 INSERT INTO `0_chart_master` VALUES ('5450', '', 'Benefits - Workers Comp', '11', '0');
283 INSERT INTO `0_chart_master` VALUES ('5460', '', 'Benefits - Pension', '11', '0');
284 INSERT INTO `0_chart_master` VALUES ('5470', '', 'Benefits - General Benefits', '11', '0');
285 INSERT INTO `0_chart_master` VALUES ('5510', '', 'Inc Tax Exp - Federal', '11', '0');
286 INSERT INTO `0_chart_master` VALUES ('5520', '', 'Inc Tax Exp - State', '11', '0');
287 INSERT INTO `0_chart_master` VALUES ('5530', '', 'Taxes - Real Estate', '11', '0');
288 INSERT INTO `0_chart_master` VALUES ('5540', '', 'Taxes - Personal Property', '11', '0');
289 INSERT INTO `0_chart_master` VALUES ('5550', '', 'Taxes - Franchise', '11', '0');
290 INSERT INTO `0_chart_master` VALUES ('5560', '', 'Taxes - Foreign Withholding', '11', '0');
291 INSERT INTO `0_chart_master` VALUES ('5610', '', 'Accounting & Legal', '12', '0');
292 INSERT INTO `0_chart_master` VALUES ('5615', '', 'Advertising & Promotions', '12', '0');
293 INSERT INTO `0_chart_master` VALUES ('5620', '', 'Bad Debts', '12', '0');
294 INSERT INTO `0_chart_master` VALUES ('5660', '', 'Amortization Expense', '12', '0');
295 INSERT INTO `0_chart_master` VALUES ('5685', '', 'Insurance', '12', '0');
296 INSERT INTO `0_chart_master` VALUES ('5690', '', 'Interest & Bank Charges', '12', '0');
297 INSERT INTO `0_chart_master` VALUES ('5700', '', 'Office Supplies', '12', '0');
298 INSERT INTO `0_chart_master` VALUES ('5760', '', 'Rent', '12', '0');
299 INSERT INTO `0_chart_master` VALUES ('5765', '', 'Repair & Maintenance', '12', '0');
300 INSERT INTO `0_chart_master` VALUES ('5780', '', 'Telephone', '12', '0');
301 INSERT INTO `0_chart_master` VALUES ('5785', '', 'Travel & Entertainment', '12', '0');
302 INSERT INTO `0_chart_master` VALUES ('5790', '', 'Utilities', '12', '0');
303 INSERT INTO `0_chart_master` VALUES ('5795', '', 'Registrations', '12', '0');
304 INSERT INTO `0_chart_master` VALUES ('5800', '', 'Licenses', '12', '0');
305 INSERT INTO `0_chart_master` VALUES ('5810', '', 'Foreign Exchange Loss', '12', '0');
306 INSERT INTO `0_chart_master` VALUES ('9990', '', 'Year Profit/Loss', '12', '0');
308 ### Structure of table `0_chart_types` ###
310 DROP TABLE IF EXISTS `0_chart_types`;
312 CREATE TABLE `0_chart_types` (
313 `id` int(11) NOT NULL auto_increment,
314 `name` varchar(60) NOT NULL default '',
315 `class_id` tinyint(1) NOT NULL default '0',
316 `parent` int(11) NOT NULL default '-1',
317 `inactive` tinyint(1) NOT NULL default '0',
320 ) TYPE=MyISAM AUTO_INCREMENT=13 ;
323 ### Data of table `0_chart_types` ###
325 INSERT INTO `0_chart_types` VALUES ('1', 'Current Assets', '1', '-1', '0');
326 INSERT INTO `0_chart_types` VALUES ('2', 'Inventory Assets', '1', '-1', '0');
327 INSERT INTO `0_chart_types` VALUES ('3', 'Capital Assets', '1', '-1', '0');
328 INSERT INTO `0_chart_types` VALUES ('4', 'Current Liabilities', '2', '-1', '0');
329 INSERT INTO `0_chart_types` VALUES ('5', 'Long Term Liabilities', '2', '-1', '0');
330 INSERT INTO `0_chart_types` VALUES ('6', 'Share Capital', '2', '-1', '0');
331 INSERT INTO `0_chart_types` VALUES ('7', 'Retained Earnings', '2', '-1', '0');
332 INSERT INTO `0_chart_types` VALUES ('8', 'Sales Revenue', '3', '-1', '0');
333 INSERT INTO `0_chart_types` VALUES ('9', 'Other Revenue', '3', '-1', '0');
334 INSERT INTO `0_chart_types` VALUES ('10', 'Cost of Goods Sold', '4', '-1', '0');
335 INSERT INTO `0_chart_types` VALUES ('11', 'Payroll Expenses', '4', '-1', '0');
336 INSERT INTO `0_chart_types` VALUES ('12', 'General & Administrative expenses', '4', '-1', '0');
339 ### Structure of table `0_comments` ###
341 DROP TABLE IF EXISTS `0_comments`;
343 CREATE TABLE `0_comments` (
344 `type` int(11) NOT NULL default '0',
345 `id` int(11) NOT NULL default '0',
346 `date_` date default '0000-00-00',
351 ### Data of table `0_comments` ###
355 ### Structure of table `0_company` ###
357 DROP TABLE IF EXISTS `0_company`;
359 CREATE TABLE `0_company` (
360 `coy_code` int(11) NOT NULL default '1',
361 `coy_name` varchar(60) NOT NULL default '',
362 `gst_no` varchar(25) NOT NULL default '',
363 `coy_no` varchar(25) NOT NULL default '0',
364 `tax_prd` int(11) NOT NULL default '1',
365 `tax_last` int(11) NOT NULL default '1',
366 `postal_address` tinytext NOT NULL,
367 `phone` varchar(30) NOT NULL default '',
368 `fax` varchar(30) NOT NULL default '',
369 `email` varchar(100) NOT NULL default '',
370 `coy_logo` varchar(100) NOT NULL default '',
371 `domicile` varchar(55) NOT NULL default '',
372 `curr_default` char(3) NOT NULL default '',
373 `debtors_act` varchar(11) NOT NULL default '',
374 `pyt_discount_act` varchar(11) NOT NULL default '',
375 `creditors_act` varchar(11) NOT NULL default '',
376 `bank_charge_act` varchar(11) NOT NULL default '',
377 `exchange_diff_act` varchar(11) NOT NULL default '',
378 `profit_loss_year_act` varchar(11) NOT NULL default '',
379 `retained_earnings_act` varchar(11) NOT NULL default '',
380 `freight_act` varchar(11) NOT NULL default '',
381 `default_sales_act` varchar(11) NOT NULL default '',
382 `default_sales_discount_act` varchar(11) NOT NULL default '',
383 `default_prompt_payment_act` varchar(11) NOT NULL default '',
384 `default_inventory_act` varchar(11) NOT NULL default '',
385 `default_cogs_act` varchar(11) NOT NULL default '',
386 `default_adj_act` varchar(11) NOT NULL default '',
387 `default_inv_sales_act` varchar(11) NOT NULL default '',
388 `default_assembly_act` varchar(11) NOT NULL default '',
389 `payroll_act` varchar(11) NOT NULL default '',
390 `allow_negative_stock` tinyint(1) NOT NULL default '0',
391 `po_over_receive` int(11) NOT NULL default '10',
392 `po_over_charge` int(11) NOT NULL default '10',
393 `default_credit_limit` int(11) NOT NULL default '1000',
394 `default_workorder_required` int(11) NOT NULL default '20',
395 `default_dim_required` int(11) NOT NULL default '20',
396 `past_due_days` int(11) NOT NULL default '30',
397 `use_dimension` tinyint(1) default '0',
398 `f_year` int(11) NOT NULL default '1',
399 `no_item_list` tinyint(1) NOT NULL default '0',
400 `no_customer_list` tinyint(1) NOT NULL default '0',
401 `no_supplier_list` tinyint(1) NOT NULL default '0',
402 `base_sales` int(11) NOT NULL default '-1',
403 `foreign_codes` tinyint(1) NOT NULL default '0',
404 `accumulate_shipping` tinyint(1) NOT NULL default '0',
405 `legal_text` tinytext NOT NULL,
406 `default_delivery_required` smallint(6) NOT NULL default '1',
407 `version_id` varchar(11) NOT NULL default '',
408 `time_zone` tinyint(1) NOT NULL default '0',
409 `add_pct` int(5) NOT NULL default '-1',
410 `round_to` int(5) NOT NULL default '1',
411 `login_tout` SMALLINT(6) NOT NULL DEFAULT '600',
412 PRIMARY KEY (`coy_code`)
415 ### Data of table `0_company` ###
417 INSERT INTO `0_company` VALUES ('1', 'Training Co.', '9876543', '123456789', '1', '1', 'Address 1\r\nAddress 2\r\nAddress 3', '(222) 111.222.333', '', 'delta@delta.com', 'logo_frontaccounting.jpg', '', 'USD', '1200', '5060', '2100', '5690', '4450', '9990', '3590', '4430', '4010', '4510', '4500', '1510', '5010', '5040', '4010', '1530', '5000', '0', '10', '10', '1000', '20', '20', '30', '1', '2', '0', '0', '0', '1', '0', '0', '', '1', '2.2', '0', '-1', '1', '600');
419 ### Structure of table `0_credit_status` ###
421 DROP TABLE IF EXISTS `0_credit_status`;
423 CREATE TABLE `0_credit_status` (
424 `id` int(11) NOT NULL auto_increment,
425 `reason_description` char(100) NOT NULL default '',
426 `dissallow_invoices` tinyint(1) NOT NULL default '0',
427 `inactive` tinyint(1) NOT NULL default '0',
429 UNIQUE KEY `reason_description` (`reason_description`)
430 ) TYPE=MyISAM AUTO_INCREMENT=5 ;
433 ### Data of table `0_credit_status` ###
435 INSERT INTO `0_credit_status` VALUES ('1', 'Good History', '0', '0');
436 INSERT INTO `0_credit_status` VALUES ('3', 'No more work until payment received', '1', '0');
437 INSERT INTO `0_credit_status` VALUES ('4', 'In liquidation', '1', '0');
440 ### Structure of table `0_currencies` ###
442 DROP TABLE IF EXISTS `0_currencies`;
444 CREATE TABLE `0_currencies` (
445 `currency` varchar(60) NOT NULL default '',
446 `curr_abrev` char(3) NOT NULL default '',
447 `curr_symbol` varchar(10) NOT NULL default '',
448 `country` varchar(100) NOT NULL default '',
449 `hundreds_name` varchar(15) NOT NULL default '',
450 `auto_update` tinyint(1) NOT NULL default '1',
451 `inactive` tinyint(1) NOT NULL default '0',
452 PRIMARY KEY (`curr_abrev`)
456 ### Data of table `0_currencies` ###
458 INSERT INTO `0_currencies` VALUES ('US Dollars', 'USD', '$', 'United States', 'Cents', '1', '0');
459 INSERT INTO `0_currencies` VALUES ('CA Dollars', 'CAD', '$', 'Canada', 'Cents', '1', '0');
460 INSERT INTO `0_currencies` VALUES ('Euro', 'EUR', '?', 'Europe', 'Cents', '1', '0');
461 INSERT INTO `0_currencies` VALUES ('Pounds', 'GBP', '?', 'England', 'Pence', '1', '0');
462 INSERT INTO `0_currencies` VALUES ('DK Kroner', 'DKK', '?', 'Denmark', 'Ore', '1', '0');
464 ### Structure of table `0_cust_allocations` ###
466 DROP TABLE IF EXISTS `0_cust_allocations`;
468 CREATE TABLE `0_cust_allocations` (
469 `id` int(11) NOT NULL auto_increment,
470 `amt` double unsigned default NULL,
471 `date_alloc` date NOT NULL default '0000-00-00',
472 `trans_no_from` int(11) default NULL,
473 `trans_type_from` int(11) default NULL,
474 `trans_no_to` int(11) default NULL,
475 `trans_type_to` int(11) default NULL,
477 ) TYPE=InnoDB AUTO_INCREMENT=2 ;
480 ### Data of table `0_cust_allocations` ###
482 INSERT INTO `0_cust_allocations` VALUES ('1', '37.68', '2009-06-21', '3', '11', '18', '10');
485 ### Structure of table `0_cust_branch` ###
487 DROP TABLE IF EXISTS `0_cust_branch`;
489 CREATE TABLE `0_cust_branch` (
490 `branch_code` int(11) NOT NULL auto_increment,
491 `debtor_no` int(11) NOT NULL default '0',
492 `br_name` varchar(60) NOT NULL default '',
493 `branch_ref` varchar(30) NOT NULL default '',
494 `br_address` tinytext NOT NULL,
495 `area` int(11) default NULL,
496 `salesman` int(11) NOT NULL default '0',
497 `phone` varchar(30) NOT NULL default '',
498 `fax` varchar(30) NOT NULL default '',
499 `contact_name` varchar(60) NOT NULL default '',
500 `email` varchar(100) NOT NULL default '',
501 `default_location` varchar(5) NOT NULL default '',
502 `tax_group_id` int(11) default NULL,
503 `sales_account` varchar(11) default NULL,
504 `sales_discount_account` varchar(11) default NULL,
505 `receivables_account` varchar(11) default NULL,
506 `payment_discount_account` varchar(11) default NULL,
507 `default_ship_via` int(11) NOT NULL default '1',
508 `disable_trans` tinyint(4) NOT NULL default '0',
509 `br_post_address` tinytext NOT NULL,
510 `group_no` int(11) NOT NULL default '0',
511 `inactive` tinyint(1) NOT NULL default '0',
512 PRIMARY KEY (`branch_code`,`debtor_no`),
513 KEY `branch_code` (`branch_code`),
514 KEY `br_name` (`br_name`)
515 ) TYPE=MyISAM AUTO_INCREMENT=4 ;
518 ### Data of table `0_cust_branch` ###
520 INSERT INTO `0_cust_branch` VALUES ('1', '1', 'Beefeater Ltd.', 'Beefeater', '', '1', '1', '', '', 'Main Branch', '', 'DEF', '2', '', '4510', '1200', '4500', '1', '0', 'Address 1\r\nAddress 2\r\nAddress 3', '0', '0');
521 INSERT INTO `0_cust_branch` VALUES ('2', '2', 'Ghostbusters Corp.', 'Ghostbusters', 'Address 1\r\nAddress 2\r\nAddress 3', '1', '1', '', '', 'Main Branch', '', 'DEF', '1', '', '4510', '1200', '4500', '1', '0', 'Address 1\r\nAddress 2\r\nAddress 3', '0', '0');
522 INSERT INTO `0_cust_branch` VALUES ('3', '3', 'Brezan', 'Brezan', 'Address 1\r\nAddress 2\r\nAddress 3', '1', '1', '', '', 'Main Branch', '', 'DEF', '1', '', '4510', '1200', '4500', '1', '0', 'Address 1\r\nAddress 2\r\nAddress 3', '0', '0');
525 ### Structure of table `0_debtor_trans` ###
527 DROP TABLE IF EXISTS `0_debtor_trans`;
529 CREATE TABLE `0_debtor_trans` (
530 `trans_no` int(11) unsigned NOT NULL default '0',
531 `type` smallint(6) unsigned NOT NULL default '0',
532 `version` tinyint(1) unsigned NOT NULL default '0',
533 `debtor_no` int(11) unsigned default NULL,
534 `branch_code` int(11) NOT NULL default '-1',
535 `tran_date` date NOT NULL default '0000-00-00',
536 `due_date` date NOT NULL default '0000-00-00',
537 `reference` varchar(60) NOT NULL default '',
538 `tpe` int(11) NOT NULL default '0',
539 `order_` int(11) NOT NULL default '0',
540 `ov_amount` double NOT NULL default '0',
541 `ov_gst` double NOT NULL default '0',
542 `ov_freight` double NOT NULL default '0',
543 `ov_freight_tax` double NOT NULL default '0',
544 `ov_discount` double NOT NULL default '0',
545 `alloc` double NOT NULL default '0',
546 `rate` double NOT NULL default '1',
547 `ship_via` int(11) default NULL,
548 `trans_link` int(11) NOT NULL default '0',
549 `dimension_id` int(11) NOT NULL default '0',
550 `dimension2_id` int(11) NOT NULL default '0',
551 PRIMARY KEY (`trans_no`,`type`),
552 KEY `debtor_no` (`debtor_no`,`branch_code`)
556 ### Data of table `0_debtor_trans` ###
558 INSERT INTO `0_debtor_trans` VALUES ('2', '13', '0', '1', '1', '2009-06-21', '2009-06-22', '1', '2', '1', '60.8', '0', '10', '0', '0', '0', '1.6445729799917', '1', '0', '0', '0');
559 INSERT INTO `0_debtor_trans` VALUES ('3', '11', '0', '3', '3', '2009-06-21', '0000-00-00', '1', '2', '3', '35.89', '1.79', '0', '0', '0', '37.68', '1.3932', '1', '18', '2', '0');
560 INSERT INTO `0_debtor_trans` VALUES ('3', '13', '1', '2', '2', '2009-06-21', '2009-06-22', 'auto', '1', '2', '50', '2.5', '0', '0', '0', '0', '1', '1', '17', '0', '0');
561 INSERT INTO `0_debtor_trans` VALUES ('4', '13', '1', '3', '3', '2009-06-21', '2009-07-01', 'auto', '2', '3', '35.89', '1.79', '0', '0', '0', '0', '1.3932', '1', '18', '2', '0');
562 INSERT INTO `0_debtor_trans` VALUES ('5', '13', '1', '2', '2', '2009-06-21', '2009-06-22', 'auto', '1', '5', '50', '0', '5', '0', '0', '0', '1', '1', '19', '0', '0');
563 INSERT INTO `0_debtor_trans` VALUES ('17', '10', '0', '2', '2', '2009-06-21', '2009-06-22', '1', '1', '2', '50', '2.5', '0', '0', '0', '0', '1', '1', '3', '0', '0');
564 INSERT INTO `0_debtor_trans` VALUES ('18', '10', '1', '3', '3', '2009-06-21', '2009-07-01', '2', '2', '3', '35.89', '1.79', '0', '0', '0', '37.68', '1.3932', '1', '4', '2', '0');
565 INSERT INTO `0_debtor_trans` VALUES ('19', '10', '0', '2', '2', '2009-06-21', '2009-06-22', '3', '1', '5', '50', '0', '5', '0', '0', '0', '1', '1', '5', '0', '0');
568 ### Structure of table `0_debtor_trans_details` ###
570 DROP TABLE IF EXISTS `0_debtor_trans_details`;
572 CREATE TABLE `0_debtor_trans_details` (
573 `id` int(11) NOT NULL auto_increment,
574 `debtor_trans_no` int(11) default NULL,
575 `debtor_trans_type` int(11) default NULL,
576 `stock_id` varchar(20) NOT NULL default '',
577 `description` tinytext,
578 `unit_price` double NOT NULL default '0',
579 `unit_tax` double NOT NULL default '0',
580 `quantity` double NOT NULL default '0',
581 `discount_percent` double NOT NULL default '0',
582 `standard_cost` double NOT NULL default '0',
583 `qty_done` double NOT NULL default '0',
585 ) TYPE=InnoDB AUTO_INCREMENT=9 ;
588 ### Data of table `0_debtor_trans_details` ###
590 INSERT INTO `0_debtor_trans_details` VALUES ('1', '2', '13', '102', '17inch VGA Monitor', '30.4', '0', '2', '0', '10', '0');
591 INSERT INTO `0_debtor_trans_details` VALUES ('2', '3', '13', '102', '17inch VGA Monitor', '50', '2.5', '1', '0', '10', '1');
592 INSERT INTO `0_debtor_trans_details` VALUES ('3', '17', '10', '102', '17inch VGA Monitor', '50', '2.5', '1', '0', '10', '0');
593 INSERT INTO `0_debtor_trans_details` VALUES ('4', '4', '13', '102', '17inch VGA Monitor', '35.89', '1.79', '1', '0', '10', '1');
594 INSERT INTO `0_debtor_trans_details` VALUES ('5', '18', '10', '102', '17inch VGA Monitor', '35.89', '1.79', '1', '0', '10', '1');
595 INSERT INTO `0_debtor_trans_details` VALUES ('6', '5', '13', '102', '17inch VGA Monitor', '50', '2.38', '1', '0', '10', '1');
596 INSERT INTO `0_debtor_trans_details` VALUES ('7', '19', '10', '102', '17inch VGA Monitor', '50', '2.38', '1', '0', '10', '0');
597 INSERT INTO `0_debtor_trans_details` VALUES ('8', '3', '11', '102', '17inch VGA Monitor', '35.89', '1.79', '1', '0', '10', '0');
600 ### Structure of table `0_debtors_master` ###
602 DROP TABLE IF EXISTS `0_debtors_master`;
604 CREATE TABLE `0_debtors_master` (
605 `debtor_no` int(11) NOT NULL auto_increment,
606 `name` varchar(80) NOT NULL default '',
607 `debtor_ref` varchar(30) NOT NULL,
609 `email` varchar(100) NOT NULL default '',
610 `tax_id` varchar(55) NOT NULL default '',
611 `curr_code` char(3) NOT NULL default '',
612 `sales_type` int(11) NOT NULL default '1',
613 `dimension_id` int(11) NOT NULL default '0',
614 `dimension2_id` int(11) NOT NULL default '0',
615 `credit_status` int(11) NOT NULL default '0',
616 `payment_terms` int(11) default NULL,
617 `discount` double NOT NULL default '0',
618 `pymt_discount` double NOT NULL default '0',
619 `credit_limit` float NOT NULL default '1000',
620 `inactive` tinyint(1) NOT NULL default '0',
621 PRIMARY KEY (`debtor_no`),
622 UNIQUE KEY `name` (`name`)
623 ) TYPE=MyISAM AUTO_INCREMENT=4 ;
626 ### Data of table `0_debtors_master` ###
628 INSERT INTO `0_debtors_master` VALUES ('1', 'Beefeater Ltd.', 'Beefeater', 'Addr 1\r\nAddr 2\r\nAddr 3', '', '345678', 'GBP', '2', '0', '0', '1', '3', '0', '0', '1000', '0');
629 INSERT INTO `0_debtors_master` VALUES ('2', 'Ghostbusters Corp.', 'Ghostbusters', 'Address 1\r\nAddress 2\r\nAddress 3', '', '2222222', 'USD', '1', '0', '0', '1', '4', '0', '0', '1000', '0');
630 INSERT INTO `0_debtors_master` VALUES ('3', 'Brezan', 'Brezan', 'Address 1\r\nAddress 2\r\nAddress 3', '', '7777777', 'EUR', '2', '0', '0', '1', '3', '0', '0', '1000', '0');
633 ### Structure of table `0_dimensions` ###
635 DROP TABLE IF EXISTS `0_dimensions`;
637 CREATE TABLE `0_dimensions` (
638 `id` int(11) NOT NULL auto_increment,
639 `reference` varchar(60) NOT NULL default '',
640 `name` varchar(60) NOT NULL default '',
641 `type_` tinyint(1) NOT NULL default '1',
642 `closed` tinyint(1) NOT NULL default '0',
643 `date_` date NOT NULL default '0000-00-00',
644 `due_date` date NOT NULL default '0000-00-00',
646 UNIQUE KEY `reference` (`reference`)
647 ) TYPE=InnoDB AUTO_INCREMENT=3 ;
650 ### Data of table `0_dimensions` ###
652 INSERT INTO `0_dimensions` VALUES ('1', '1', 'Support', '1', '0', '2009-06-21', '2015-07-11');
653 INSERT INTO `0_dimensions` VALUES ('2', '2', 'Development', '1', '0', '2009-06-21', '2015-07-11');
656 ### Structure of table `0_exchange_rates` ###
658 DROP TABLE IF EXISTS `0_exchange_rates`;
660 CREATE TABLE `0_exchange_rates` (
661 `id` int(11) NOT NULL auto_increment,
662 `curr_code` char(3) NOT NULL default '',
663 `rate_buy` double NOT NULL default '0',
664 `rate_sell` double NOT NULL default '0',
665 `date_` date NOT NULL default '0000-00-00',
667 UNIQUE KEY `curr_code` (`curr_code`,`date_`)
668 ) TYPE=MyISAM AUTO_INCREMENT=4 ;
671 ### Data of table `0_exchange_rates` ###
673 INSERT INTO `0_exchange_rates` VALUES ('1', 'DKK', '0.18717252868313', '0.18717252868313', '2009-06-21');
674 INSERT INTO `0_exchange_rates` VALUES ('2', 'GBP', '1.6445729799917', '1.6445729799917', '2009-06-21');
675 INSERT INTO `0_exchange_rates` VALUES ('3', 'EUR', '1.3932', '1.3932', '2009-06-21');
678 ### Structure of table `0_fiscal_year` ###
680 DROP TABLE IF EXISTS `0_fiscal_year`;
682 CREATE TABLE `0_fiscal_year` (
683 `id` int(11) NOT NULL auto_increment,
684 `begin` date default '0000-00-00',
685 `end` date default '0000-00-00',
686 `closed` tinyint(1) NOT NULL default '0',
688 ) TYPE=InnoDB AUTO_INCREMENT=3 ;
691 ### Data of table `0_fiscal_year` ###
693 INSERT INTO `0_fiscal_year` VALUES ('1', '2008-01-01', '2008-12-31', '0');
694 INSERT INTO `0_fiscal_year` VALUES ('2', '2009-01-01', '2009-12-31', '0');
697 ### Structure of table `0_gl_trans` ###
699 DROP TABLE IF EXISTS `0_gl_trans`;
701 CREATE TABLE `0_gl_trans` (
702 `counter` int(11) NOT NULL auto_increment,
703 `type` smallint(6) NOT NULL default '0',
704 `type_no` bigint(16) NOT NULL default '1',
705 `tran_date` date NOT NULL default '0000-00-00',
706 `account` varchar(11) NOT NULL default '',
707 `memo_` tinytext NOT NULL,
708 `amount` double NOT NULL default '0',
709 `dimension_id` int(11) NOT NULL default '0',
710 `dimension2_id` int(11) NOT NULL default '0',
711 `person_type_id` int(11) default NULL,
712 `person_id` tinyblob,
713 PRIMARY KEY (`counter`),
714 KEY `Type_and_Number` (`type`,`type_no`)
715 ) TYPE=InnoDB AUTO_INCREMENT=84 ;
718 ### Data of table `0_gl_trans` ###
720 INSERT INTO `0_gl_trans` VALUES ('1', '20', '7', '2009-06-21', '2100', '', '-3465', '0', '0', '3', '2');
721 INSERT INTO `0_gl_trans` VALUES ('2', '20', '7', '2009-06-21', '1510', '', '1000', '0', '0', '3', '2');
722 INSERT INTO `0_gl_trans` VALUES ('3', '20', '7', '2009-06-21', '1510', '', '1100', '0', '0', '3', '2');
723 INSERT INTO `0_gl_trans` VALUES ('4', '20', '7', '2009-06-21', '1510', '', '1200', '0', '0', '3', '2');
724 INSERT INTO `0_gl_trans` VALUES ('5', '20', '7', '2009-06-21', '2150', '', '165', '0', '0', '3', '2');
725 INSERT INTO `0_gl_trans` VALUES ('6', '22', '4', '2009-06-21', '2100', '', '3465', '0', '0', '3', '2');
726 INSERT INTO `0_gl_trans` VALUES ('7', '22', '4', '2009-06-21', '1060', '', '-3465', '0', '0', '3', '2');
727 INSERT INTO `0_gl_trans` VALUES ('8', '26', '1', '2009-06-21', '1510', '', '-100', '0', '0', '', '');
728 INSERT INTO `0_gl_trans` VALUES ('9', '26', '1', '2009-06-21', '1510', '', '-110', '0', '0', '', '');
729 INSERT INTO `0_gl_trans` VALUES ('10', '26', '1', '2009-06-21', '1510', '', '-120', '0', '0', '', '');
730 INSERT INTO `0_gl_trans` VALUES ('11', '26', '1', '2009-06-21', '1060', 'Overhead Cost', '-10', '0', '0', '1', '1');
731 INSERT INTO `0_gl_trans` VALUES ('12', '26', '1', '2009-06-21', '1530', 'Overhead Cost', '10', '0', '0', '1', '1');
732 INSERT INTO `0_gl_trans` VALUES ('13', '26', '1', '2009-06-21', '1060', 'Labour Cost', '-20', '0', '0', '1', '0');
733 INSERT INTO `0_gl_trans` VALUES ('14', '26', '1', '2009-06-21', '1530', 'Labour Cost', '20', '0', '0', '1', '0');
734 INSERT INTO `0_gl_trans` VALUES ('15', '26', '1', '2009-06-21', '1510', '', '330', '0', '0', '', '');
735 INSERT INTO `0_gl_trans` VALUES ('16', '13', '2', '2009-06-21', '5010', '', '20', '0', '0', '2', '1');
736 INSERT INTO `0_gl_trans` VALUES ('17', '13', '2', '2009-06-21', '1510', '', '-20', '0', '0', '2', '1');
737 INSERT INTO `0_gl_trans` VALUES ('18', '13', '3', '2009-06-21', '5010', '', '10', '0', '0', '2', '2');
738 INSERT INTO `0_gl_trans` VALUES ('19', '13', '3', '2009-06-21', '1510', '', '-10', '0', '0', '2', '2');
739 INSERT INTO `0_gl_trans` VALUES ('20', '10', '17', '2009-06-21', '4010', '', '-50', '0', '0', '2', '2');
740 INSERT INTO `0_gl_trans` VALUES ('21', '10', '17', '2009-06-21', '1200', '', '52.5', '0', '0', '2', '2');
741 INSERT INTO `0_gl_trans` VALUES ('22', '10', '17', '2009-06-21', '2150', '', '-2.5', '0', '0', '2', '2');
742 INSERT INTO `0_gl_trans` VALUES ('23', '13', '4', '2009-06-21', '5010', '', '10', '2', '0', '2', '3');
743 INSERT INTO `0_gl_trans` VALUES ('24', '13', '4', '2009-06-21', '1510', '', '-10', '0', '0', '2', '3');
744 INSERT INTO `0_gl_trans` VALUES ('25', '10', '18', '2009-06-21', '4010', '', '-50', '2', '0', '2', '3');
745 INSERT INTO `0_gl_trans` VALUES ('26', '10', '18', '2009-06-21', '1200', '', '52.5', '0', '0', '2', '3');
746 INSERT INTO `0_gl_trans` VALUES ('27', '10', '18', '2009-06-21', '2150', '', '-2.5', '0', '0', '2', '3');
747 INSERT INTO `0_gl_trans` VALUES ('28', '0', '18', '2009-02-20', '1060', '', '1000', '0', '0', '', '');
748 INSERT INTO `0_gl_trans` VALUES ('29', '0', '18', '2009-02-20', '3350', '', '-1000', '0', '0', '', '');
749 INSERT INTO `0_gl_trans` VALUES ('30', '0', '19', '2009-02-21', '1060', '', '4000', '0', '0', '', '');
750 INSERT INTO `0_gl_trans` VALUES ('31', '0', '19', '2009-02-21', '3350', '', '-4000', '0', '0', '', '');
751 INSERT INTO `0_gl_trans` VALUES ('32', '26', '3', '2009-06-21', '1510', '', '-20', '0', '0', '', '');
752 INSERT INTO `0_gl_trans` VALUES ('33', '26', '3', '2009-06-21', '1510', '', '-22', '0', '0', '', '');
753 INSERT INTO `0_gl_trans` VALUES ('34', '26', '3', '2009-06-21', '1510', '', '-24', '0', '0', '', '');
754 INSERT INTO `0_gl_trans` VALUES ('35', '26', '3', '2009-06-21', '1540', '', '66', '0', '0', '', '');
755 INSERT INTO `0_gl_trans` VALUES ('36', '2', '5', '2009-06-21', '2150', 'Cash Sales', '-4.76', '0', '0', '4', '3');
756 INSERT INTO `0_gl_trans` VALUES ('37', '2', '5', '2009-06-21', '4010', 'Cash Sales', '-95.24', '0', '0', '4', '3');
757 INSERT INTO `0_gl_trans` VALUES ('38', '2', '5', '2009-06-21', '1060', '', '100', '0', '0', '4', '3');
758 INSERT INTO `0_gl_trans` VALUES ('39', '1', '8', '2009-06-21', '2150', 'Maintenance', '2.38', '0', '0', '4', '1');
759 INSERT INTO `0_gl_trans` VALUES ('40', '1', '8', '2009-06-21', '5765', 'Maintenance', '47.62', '0', '0', '4', '1');
760 INSERT INTO `0_gl_trans` VALUES ('41', '1', '8', '2009-06-21', '1060', '', '-50', '0', '0', '4', '1');
761 INSERT INTO `0_gl_trans` VALUES ('42', '20', '8', '2009-06-21', '2100', '', '-20', '0', '0', '3', '2');
762 INSERT INTO `0_gl_trans` VALUES ('43', '20', '8', '2009-06-21', '2150', '', '0.95', '0', '0', '3', '2');
763 INSERT INTO `0_gl_trans` VALUES ('44', '20', '8', '2009-06-21', '5780', '', '19.05', '0', '0', '3', '2');
764 INSERT INTO `0_gl_trans` VALUES ('45', '26', '4', '2009-06-21', '1510', '', '-40', '0', '0', '', '');
765 INSERT INTO `0_gl_trans` VALUES ('46', '26', '4', '2009-06-21', '1510', '', '-44', '0', '0', '', '');
766 INSERT INTO `0_gl_trans` VALUES ('47', '26', '4', '2009-06-21', '1510', '', '-48', '0', '0', '', '');
767 INSERT INTO `0_gl_trans` VALUES ('48', '26', '4', '2009-06-21', '1540', '', '132', '0', '0', '', '');
768 INSERT INTO `0_gl_trans` VALUES ('49', '26', '2', '2009-06-21', '1510', '', '-20', '0', '0', '', '');
769 INSERT INTO `0_gl_trans` VALUES ('50', '26', '2', '2009-06-21', '1510', '', '-22', '0', '0', '', '');
770 INSERT INTO `0_gl_trans` VALUES ('51', '26', '2', '2009-06-21', '1510', '', '-24', '0', '0', '', '');
771 INSERT INTO `0_gl_trans` VALUES ('52', '26', '2', '2009-06-21', '1540', '', '66', '0', '0', '', '');
772 INSERT INTO `0_gl_trans` VALUES ('53', '26', '5', '2009-06-21', '1510', '', '-50', '0', '0', '', '');
773 INSERT INTO `0_gl_trans` VALUES ('54', '26', '5', '2009-06-21', '1510', '', '-55', '0', '0', '', '');
774 INSERT INTO `0_gl_trans` VALUES ('55', '26', '5', '2009-06-21', '1510', '', '-60', '0', '0', '', '');
775 INSERT INTO `0_gl_trans` VALUES ('56', '26', '5', '2009-06-21', '1060', 'Overhead Cost', '-10', '0', '0', '1', '1');
776 INSERT INTO `0_gl_trans` VALUES ('57', '26', '5', '2009-06-21', '1530', 'Overhead Cost', '10', '0', '0', '1', '1');
777 INSERT INTO `0_gl_trans` VALUES ('58', '26', '5', '2009-06-21', '1060', 'Labour Cost', '-20', '0', '0', '1', '0');
778 INSERT INTO `0_gl_trans` VALUES ('59', '26', '5', '2009-06-21', '1530', 'Labour Cost', '20', '0', '0', '1', '0');
779 INSERT INTO `0_gl_trans` VALUES ('60', '26', '5', '2009-06-21', '1540', '', '165', '0', '0', '', '');
780 INSERT INTO `0_gl_trans` VALUES ('61', '26', '6', '2009-06-21', '1510', '', '50', '0', '0', '', '');
781 INSERT INTO `0_gl_trans` VALUES ('62', '26', '6', '2009-06-21', '1510', '', '55', '0', '0', '', '');
782 INSERT INTO `0_gl_trans` VALUES ('63', '26', '6', '2009-06-21', '1510', '', '60', '0', '0', '', '');
783 INSERT INTO `0_gl_trans` VALUES ('64', '26', '6', '2009-06-21', '1540', '', '-165', '0', '0', '', '');
784 INSERT INTO `0_gl_trans` VALUES ('65', '26', '7', '2009-06-21', '1510', '', '20', '0', '0', '', '');
785 INSERT INTO `0_gl_trans` VALUES ('66', '26', '7', '2009-06-21', '1510', '', '22', '0', '0', '', '');
786 INSERT INTO `0_gl_trans` VALUES ('67', '26', '7', '2009-06-21', '1510', '', '24', '0', '0', '', '');
787 INSERT INTO `0_gl_trans` VALUES ('68', '26', '7', '2009-06-21', '1060', 'Overhead Cost', '-10', '0', '0', '1', '1');
788 INSERT INTO `0_gl_trans` VALUES ('69', '26', '7', '2009-06-21', '1530', 'Overhead Cost', '10', '0', '0', '1', '1');
789 INSERT INTO `0_gl_trans` VALUES ('70', '26', '7', '2009-06-21', '1060', 'Labour Cost', '-20', '0', '0', '1', '0');
790 INSERT INTO `0_gl_trans` VALUES ('71', '26', '7', '2009-06-21', '1530', 'Labour Cost', '20', '0', '0', '1', '0');
791 INSERT INTO `0_gl_trans` VALUES ('72', '26', '7', '2009-06-21', '1540', '', '-66', '0', '0', '', '');
792 INSERT INTO `0_gl_trans` VALUES ('73', '13', '5', '2009-06-21', '5010', '', '10', '0', '0', '2', '2');
793 INSERT INTO `0_gl_trans` VALUES ('74', '13', '5', '2009-06-21', '1510', '', '-10', '0', '0', '2', '2');
794 INSERT INTO `0_gl_trans` VALUES ('75', '10', '19', '2009-06-21', '4010', '', '-47.62', '0', '0', '2', '2');
795 INSERT INTO `0_gl_trans` VALUES ('76', '10', '19', '2009-06-21', '1200', '', '55', '0', '0', '2', '2');
796 INSERT INTO `0_gl_trans` VALUES ('77', '10', '19', '2009-06-21', '4430', '', '-5', '0', '0', '2', '2');
797 INSERT INTO `0_gl_trans` VALUES ('78', '10', '19', '2009-06-21', '2150', '', '-2.38', '0', '0', '2', '2');
798 INSERT INTO `0_gl_trans` VALUES ('79', '11', '3', '2009-06-21', '5010', '', '-10', '2', '0', '2', '3');
799 INSERT INTO `0_gl_trans` VALUES ('80', '11', '3', '2009-06-21', '1510', '', '10', '0', '0', '2', '3');
800 INSERT INTO `0_gl_trans` VALUES ('81', '11', '3', '2009-06-21', '4010', '', '50', '2', '0', '2', '3');
801 INSERT INTO `0_gl_trans` VALUES ('82', '11', '3', '2009-06-21', '1200', '', '-52.5', '0', '0', '2', '3');
802 INSERT INTO `0_gl_trans` VALUES ('83', '11', '3', '2009-06-21', '2150', '', '2.5', '0', '0', '2', '3');
805 ### Structure of table `0_grn_batch` ###
807 DROP TABLE IF EXISTS `0_grn_batch`;
809 CREATE TABLE `0_grn_batch` (
810 `id` int(11) NOT NULL auto_increment,
811 `supplier_id` int(11) NOT NULL default '0',
812 `purch_order_no` int(11) default NULL,
813 `reference` varchar(60) NOT NULL default '',
814 `delivery_date` date NOT NULL default '0000-00-00',
815 `loc_code` varchar(5) default NULL,
817 ) TYPE=InnoDB AUTO_INCREMENT=2 ;
820 ### Data of table `0_grn_batch` ###
822 INSERT INTO `0_grn_batch` VALUES ('1', '2', '1', '1', '2009-06-21', 'DEF');
825 ### Structure of table `0_grn_items` ###
827 DROP TABLE IF EXISTS `0_grn_items`;
829 CREATE TABLE `0_grn_items` (
830 `id` int(11) NOT NULL auto_increment,
831 `grn_batch_id` int(11) default NULL,
832 `po_detail_item` int(11) NOT NULL default '0',
833 `item_code` varchar(20) NOT NULL default '',
834 `description` tinytext,
835 `qty_recd` double NOT NULL default '0',
836 `quantity_inv` double NOT NULL default '0',
838 ) TYPE=InnoDB AUTO_INCREMENT=4 ;
841 ### Data of table `0_grn_items` ###
843 INSERT INTO `0_grn_items` VALUES ('1', '1', '1', '102', '17inch VGA Monitor', '100', '100');
844 INSERT INTO `0_grn_items` VALUES ('2', '1', '2', '103', '32MB VGA Card', '100', '100');
845 INSERT INTO `0_grn_items` VALUES ('3', '1', '3', '104', '52x CD Drive', '100', '100');
848 ### Structure of table `0_groups` ###
850 DROP TABLE IF EXISTS `0_groups`;
852 CREATE TABLE `0_groups` (
853 `id` smallint(6) unsigned NOT NULL auto_increment,
854 `description` varchar(60) NOT NULL default '',
855 `inactive` tinyint(1) NOT NULL default '0',
857 UNIQUE KEY `description` (`description`)
858 ) TYPE=MyISAM AUTO_INCREMENT=4 AUTO_INCREMENT=4 ;
861 ### Data of table `0_groups` ###
863 INSERT INTO `0_groups` VALUES ('1', 'Small', '0');
864 INSERT INTO `0_groups` VALUES ('2', 'Medium', '0');
865 INSERT INTO `0_groups` VALUES ('3', 'Large', '0');
868 ### Structure of table `0_item_codes` ###
870 DROP TABLE IF EXISTS `0_item_codes`;
872 CREATE TABLE `0_item_codes` (
873 `id` int(11) unsigned NOT NULL auto_increment,
874 `item_code` varchar(20) NOT NULL,
875 `stock_id` varchar(20) NOT NULL,
876 `description` varchar(200) NOT NULL default '',
877 `category_id` smallint(6) unsigned NOT NULL,
878 `quantity` double NOT NULL default '1',
879 `is_foreign` tinyint(1) NOT NULL default '0',
880 `inactive` tinyint(1) NOT NULL default '0',
882 UNIQUE KEY `stock_id` (`stock_id`,`item_code`)
883 ) TYPE=MyISAM AUTO_INCREMENT=6 ;
886 ### Data of table `0_item_codes` ###
888 INSERT INTO `0_item_codes` VALUES ('1', '102', '102', '17inch VGA Monitor', '1', '1', '0', '0');
889 INSERT INTO `0_item_codes` VALUES ('2', '103', '103', '32MB VGA Card', '1', '1', '0', '0');
890 INSERT INTO `0_item_codes` VALUES ('3', '104', '104', '52x CD Drive', '1', '1', '0', '0');
891 INSERT INTO `0_item_codes` VALUES ('4', '3400', '3400', 'P4 Business System', '3', '1', '0', '0');
892 INSERT INTO `0_item_codes` VALUES ('5', '201', '201', 'Assembly Labour', '4', '1', '0', '0');
895 ### Structure of table `0_item_tax_type_exemptions` ###
897 DROP TABLE IF EXISTS `0_item_tax_type_exemptions`;
899 CREATE TABLE `0_item_tax_type_exemptions` (
900 `item_tax_type_id` int(11) NOT NULL default '0',
901 `tax_type_id` int(11) NOT NULL default '0',
902 PRIMARY KEY (`item_tax_type_id`,`tax_type_id`)
906 ### Data of table `0_item_tax_type_exemptions` ###
910 ### Structure of table `0_item_tax_types` ###
912 DROP TABLE IF EXISTS `0_item_tax_types`;
914 CREATE TABLE `0_item_tax_types` (
915 `id` int(11) NOT NULL auto_increment,
916 `name` varchar(60) NOT NULL default '',
917 `exempt` tinyint(1) NOT NULL default '0',
918 `inactive` tinyint(1) NOT NULL default '0',
920 UNIQUE KEY `name` (`name`)
921 ) TYPE=InnoDB AUTO_INCREMENT=2 ;
924 ### Data of table `0_item_tax_types` ###
926 INSERT INTO `0_item_tax_types` VALUES ('1', 'Regular', '0', '0');
928 ### Structure of table `0_item_units` ###
930 DROP TABLE IF EXISTS `0_item_units`;
932 CREATE TABLE `0_item_units` (
933 `abbr` varchar(20) NOT NULL,
934 `name` varchar(40) NOT NULL,
935 `decimals` tinyint(2) NOT NULL,
936 `inactive` tinyint(1) NOT NULL default '0',
937 PRIMARY KEY (`abbr`),
938 UNIQUE KEY `name` (`name`)
942 ### Data of table `0_item_units` ###
944 INSERT INTO `0_item_units` VALUES ('ea.', 'Each', '0', '0');
945 INSERT INTO `0_item_units` VALUES ('hrs', 'Hours', '1', '0');
948 ### Structure of table `0_loc_stock` ###
950 DROP TABLE IF EXISTS `0_loc_stock`;
952 CREATE TABLE `0_loc_stock` (
953 `loc_code` char(5) NOT NULL default '',
954 `stock_id` char(20) NOT NULL default '',
955 `reorder_level` bigint(20) NOT NULL default '0',
956 PRIMARY KEY (`loc_code`,`stock_id`),
957 KEY `stock_id` (`stock_id`)
961 ### Data of table `0_loc_stock` ###
963 INSERT INTO `0_loc_stock` VALUES ('DEF', '102', '0');
964 INSERT INTO `0_loc_stock` VALUES ('DEF', '103', '0');
965 INSERT INTO `0_loc_stock` VALUES ('DEF', '104', '0');
966 INSERT INTO `0_loc_stock` VALUES ('DEF', '201', '0');
967 INSERT INTO `0_loc_stock` VALUES ('DEF', '3400', '0');
970 ### Structure of table `0_locations` ###
972 DROP TABLE IF EXISTS `0_locations`;
974 CREATE TABLE `0_locations` (
975 `loc_code` varchar(5) NOT NULL default '',
976 `location_name` varchar(60) NOT NULL default '',
977 `delivery_address` tinytext NOT NULL,
978 `phone` varchar(30) NOT NULL default '',
979 `fax` varchar(30) NOT NULL default '',
980 `email` varchar(100) NOT NULL default '',
981 `contact` varchar(30) NOT NULL default '',
982 `inactive` tinyint(1) NOT NULL default '0',
983 PRIMARY KEY (`loc_code`)
987 ### Data of table `0_locations` ###
989 INSERT INTO `0_locations` VALUES ('DEF', 'Default', 'Delivery 1\r\nDelivery 2\r\nDelivery 3', '', '', '', '', '0');
992 ### Structure of table `0_movement_types` ###
994 DROP TABLE IF EXISTS `0_movement_types`;
996 CREATE TABLE `0_movement_types` (
997 `id` int(11) NOT NULL auto_increment,
998 `name` varchar(60) NOT NULL default '',
999 `inactive` tinyint(1) NOT NULL default '0',
1001 UNIQUE KEY `name` (`name`)
1002 ) TYPE=MyISAM AUTO_INCREMENT=2 ;
1005 ### Data of table `0_movement_types` ###
1007 INSERT INTO `0_movement_types` VALUES ('1', 'Adjustment', '0');
1010 ### Structure of table `0_payment_terms` ###
1012 DROP TABLE IF EXISTS `0_payment_terms`;
1014 CREATE TABLE `0_payment_terms` (
1015 `terms_indicator` int(11) NOT NULL auto_increment,
1016 `terms` char(80) NOT NULL default '',
1017 `days_before_due` smallint(6) NOT NULL default '0',
1018 `day_in_following_month` smallint(6) NOT NULL default '0',
1019 `inactive` tinyint(1) NOT NULL default '0',
1020 PRIMARY KEY (`terms_indicator`),
1021 UNIQUE KEY `terms` (`terms`)
1022 ) TYPE=MyISAM AUTO_INCREMENT=5 ;
1025 ### Data of table `0_payment_terms` ###
1027 INSERT INTO `0_payment_terms` VALUES ('1', 'Due 15th Of the Following Month', '0', '17', '0');
1028 INSERT INTO `0_payment_terms` VALUES ('2', 'Due By End Of The Following Month', '0', '30', '0');
1029 INSERT INTO `0_payment_terms` VALUES ('3', 'Payment due within 10 days', '10', '0', '0');
1030 INSERT INTO `0_payment_terms` VALUES ('4', 'Cash Only', '1', '0', '0');
1033 ### Structure of table `0_prices` ###
1035 DROP TABLE IF EXISTS `0_prices`;
1037 CREATE TABLE `0_prices` (
1038 `id` int(11) NOT NULL auto_increment,
1039 `stock_id` varchar(20) NOT NULL default '',
1040 `sales_type_id` int(11) NOT NULL default '0',
1041 `curr_abrev` char(3) NOT NULL default '',
1042 `price` double NOT NULL default '0',
1044 UNIQUE KEY `price` (`stock_id`,`sales_type_id`,`curr_abrev`)
1045 ) TYPE=MyISAM AUTO_INCREMENT=5 ;
1048 ### Data of table `0_prices` ###
1050 INSERT INTO `0_prices` VALUES ('1', '3400', '1', 'USD', '100');
1051 INSERT INTO `0_prices` VALUES ('2', '102', '1', 'USD', '50');
1052 INSERT INTO `0_prices` VALUES ('3', '103', '1', 'USD', '55');
1053 INSERT INTO `0_prices` VALUES ('4', '104', '1', 'USD', '60');
1056 ### Structure of table `0_print_profiles` ###
1058 DROP TABLE IF EXISTS `0_print_profiles`;
1060 CREATE TABLE `0_print_profiles` (
1061 `id` smallint(6) unsigned NOT NULL auto_increment,
1062 `profile` varchar(30) NOT NULL,
1063 `report` varchar(5) default NULL,
1064 `printer` tinyint(3) unsigned default NULL,
1066 UNIQUE KEY `profile` (`profile`,`report`)
1067 ) TYPE=MyISAM AUTO_INCREMENT=10 ;
1070 ### Data of table `0_print_profiles` ###
1072 INSERT INTO `0_print_profiles` VALUES ('1', 'Out of office', '', '0');
1073 INSERT INTO `0_print_profiles` VALUES ('2', 'Sales Department', '', '0');
1074 INSERT INTO `0_print_profiles` VALUES ('3', 'Central', '', '2');
1075 INSERT INTO `0_print_profiles` VALUES ('4', 'Sales Department', '104', '2');
1076 INSERT INTO `0_print_profiles` VALUES ('5', 'Sales Department', '105', '2');
1077 INSERT INTO `0_print_profiles` VALUES ('6', 'Sales Department', '107', '2');
1078 INSERT INTO `0_print_profiles` VALUES ('7', 'Sales Department', '109', '2');
1079 INSERT INTO `0_print_profiles` VALUES ('8', 'Sales Department', '110', '2');
1080 INSERT INTO `0_print_profiles` VALUES ('9', 'Sales Department', '201', '2');
1083 ### Structure of table `0_printers` ###
1085 DROP TABLE IF EXISTS `0_printers`;
1087 CREATE TABLE `0_printers` (
1088 `id` tinyint(3) unsigned NOT NULL auto_increment,
1089 `name` varchar(20) NOT NULL,
1090 `description` varchar(60) NOT NULL,
1091 `queue` varchar(20) NOT NULL,
1092 `host` varchar(40) NOT NULL,
1093 `port` smallint(11) unsigned NOT NULL,
1094 `timeout` tinyint(3) unsigned NOT NULL,
1096 UNIQUE KEY `name` (`name`)
1097 ) TYPE=MyISAM AUTO_INCREMENT=4 ;
1100 ### Data of table `0_printers` ###
1102 INSERT INTO `0_printers` VALUES ('1', 'QL500', 'Label printer', 'QL500', 'server', '127', '20');
1103 INSERT INTO `0_printers` VALUES ('2', 'Samsung', 'Main network printer', 'scx4521F', 'server', '515', '5');
1104 INSERT INTO `0_printers` VALUES ('3', 'Local', 'Local print server at user IP', 'lp', '', '515', '10');
1107 ### Structure of table `0_purch_data` ###
1109 DROP TABLE IF EXISTS `0_purch_data`;
1111 CREATE TABLE `0_purch_data` (
1112 `supplier_id` int(11) NOT NULL default '0',
1113 `stock_id` char(20) NOT NULL default '',
1114 `price` double NOT NULL default '0',
1115 `suppliers_uom` char(50) NOT NULL default '',
1116 `conversion_factor` double NOT NULL default '1',
1117 `supplier_description` char(50) NOT NULL default '',
1118 PRIMARY KEY (`supplier_id`,`stock_id`)
1122 ### Data of table `0_purch_data` ###
1124 INSERT INTO `0_purch_data` VALUES ('2', '102', '10', '', '1', '17inch VGA Monitor');
1125 INSERT INTO `0_purch_data` VALUES ('2', '103', '11', '', '1', '32MB VGA Card');
1126 INSERT INTO `0_purch_data` VALUES ('2', '104', '12', '', '1', '52x CD Drive');
1129 ### Structure of table `0_purch_order_details` ###
1131 DROP TABLE IF EXISTS `0_purch_order_details`;
1133 CREATE TABLE `0_purch_order_details` (
1134 `po_detail_item` int(11) NOT NULL auto_increment,
1135 `order_no` int(11) NOT NULL default '0',
1136 `item_code` varchar(20) NOT NULL default '',
1137 `description` tinytext,
1138 `delivery_date` date NOT NULL default '0000-00-00',
1139 `qty_invoiced` double NOT NULL default '0',
1140 `unit_price` double NOT NULL default '0',
1141 `act_price` double NOT NULL default '0',
1142 `std_cost_unit` double NOT NULL default '0',
1143 `quantity_ordered` double NOT NULL default '0',
1144 `quantity_received` double NOT NULL default '0',
1145 PRIMARY KEY (`po_detail_item`)
1146 ) TYPE=InnoDB AUTO_INCREMENT=6 ;
1149 ### Data of table `0_purch_order_details` ###
1151 INSERT INTO `0_purch_order_details` VALUES ('1', '1', '102', '17inch VGA Monitor', '2009-07-01', '100', '10', '10', '10', '100', '100');
1152 INSERT INTO `0_purch_order_details` VALUES ('2', '1', '103', '32MB VGA Card', '2009-07-01', '100', '11', '11', '11', '100', '100');
1153 INSERT INTO `0_purch_order_details` VALUES ('3', '1', '104', '52x CD Drive', '2009-07-01', '100', '12', '12', '12', '100', '100');
1154 INSERT INTO `0_purch_order_details` VALUES ('4', '2', '102', '17inch VGA Monitor', '2009-07-01', '0', '5', '0', '0', '1', '0');
1155 INSERT INTO `0_purch_order_details` VALUES ('5', '2', '103', '32MB VGA Card', '2009-07-01', '0', '5', '0', '0', '1', '0');
1158 ### Structure of table `0_purch_orders` ###
1160 DROP TABLE IF EXISTS `0_purch_orders`;
1162 CREATE TABLE `0_purch_orders` (
1163 `order_no` int(11) NOT NULL auto_increment,
1164 `supplier_id` int(11) NOT NULL default '0',
1165 `comments` tinytext,
1166 `ord_date` date NOT NULL default '0000-00-00',
1167 `reference` tinytext NOT NULL,
1168 `requisition_no` tinytext,
1169 `into_stock_location` varchar(5) NOT NULL default '',
1170 `delivery_address` tinytext NOT NULL,
1171 PRIMARY KEY (`order_no`)
1172 ) TYPE=InnoDB AUTO_INCREMENT=3 ;
1175 ### Data of table `0_purch_orders` ###
1177 INSERT INTO `0_purch_orders` VALUES ('1', '2', '', '2009-06-01', '1', '', 'DEF', 'Delivery 1\r\nDelivery 2\r\nDelivery 3');
1178 INSERT INTO `0_purch_orders` VALUES ('2', '3', '', '2009-06-21', '2', '', 'DEF', 'Delivery 1\r\nDelivery 2\r\nDelivery 3');
1181 ### Structure of table `0_quick_entries` ###
1183 DROP TABLE IF EXISTS `0_quick_entries`;
1185 CREATE TABLE `0_quick_entries` (
1186 `id` smallint(6) unsigned NOT NULL auto_increment,
1187 `type` tinyint(1) NOT NULL default '0',
1188 `description` varchar(60) NOT NULL,
1189 `base_amount` double NOT NULL default '0',
1190 `base_desc` varchar(60) default NULL,
1192 KEY `description` (`description`)
1193 ) TYPE=MyISAM AUTO_INCREMENT=4 ;
1196 ### Data of table `0_quick_entries` ###
1198 INSERT INTO `0_quick_entries` VALUES ('1', '1', 'Maintenance', '0', 'Amount');
1199 INSERT INTO `0_quick_entries` VALUES ('2', '4', 'Phone', '0', 'Amount');
1200 INSERT INTO `0_quick_entries` VALUES ('3', '2', 'Cash Sales', '0', 'Amount');
1203 ### Structure of table `0_quick_entry_lines` ###
1205 DROP TABLE IF EXISTS `0_quick_entry_lines`;
1207 CREATE TABLE `0_quick_entry_lines` (
1208 `id` smallint(6) unsigned NOT NULL auto_increment,
1209 `qid` smallint(6) unsigned NOT NULL,
1210 `amount` double default '0',
1211 `action` varchar(2) NOT NULL,
1212 `dest_id` varchar(11) NOT NULL,
1213 `dimension_id` smallint(6) unsigned default NULL,
1214 `dimension2_id` smallint(6) unsigned default NULL,
1217 ) TYPE=MyISAM AUTO_INCREMENT=8 ;
1220 ### Data of table `0_quick_entry_lines` ###
1222 INSERT INTO `0_quick_entry_lines` VALUES ('1', '1', '0', 't-', '1', '0', '0');
1223 INSERT INTO `0_quick_entry_lines` VALUES ('2', '2', '0', 't-', '1', '0', '0');
1224 INSERT INTO `0_quick_entry_lines` VALUES ('3', '3', '0', 't-', '1', '0', '0');
1225 INSERT INTO `0_quick_entry_lines` VALUES ('4', '3', '0', '=', '4010', '0', '0');
1226 INSERT INTO `0_quick_entry_lines` VALUES ('5', '1', '0', '=', '5765', '0', '0');
1227 INSERT INTO `0_quick_entry_lines` VALUES ('6', '2', '0', '=', '5780', '0', '0');
1230 ### Structure of table `0_recurrent_invoices` ###
1232 DROP TABLE IF EXISTS `0_recurrent_invoices`;
1234 CREATE TABLE `0_recurrent_invoices` (
1235 `id` smallint(6) unsigned NOT NULL auto_increment,
1236 `description` varchar(60) NOT NULL default '',
1237 `order_no` int(11) unsigned NOT NULL,
1238 `debtor_no` int(11) unsigned default NULL,
1239 `group_no` smallint(6) unsigned default NULL,
1240 `days` int(11) NOT NULL default '0',
1241 `monthly` int(11) NOT NULL default '0',
1242 `begin` date NOT NULL default '0000-00-00',
1243 `end` date NOT NULL default '0000-00-00',
1244 `last_sent` date NOT NULL default '0000-00-00',
1246 UNIQUE KEY `description` (`description`)
1247 ) TYPE=InnoDB AUTO_INCREMENT=1 ;
1250 ### Data of table `0_recurrent_invoices` ###
1254 ### Structure of table `0_refs` ###
1256 DROP TABLE IF EXISTS `0_refs`;
1258 CREATE TABLE `0_refs` (
1259 `id` int(11) NOT NULL default '0',
1260 `type` int(11) NOT NULL default '0',
1261 `reference` varchar(100) NOT NULL default '',
1262 PRIMARY KEY (`id`,`type`)
1266 ### Data of table `0_refs` ###
1268 INSERT INTO `0_refs` VALUES ('18', '0', '1');
1269 INSERT INTO `0_refs` VALUES ('19', '0', '2');
1272 ### Structure of table `0_sales_order_details` ###
1274 DROP TABLE IF EXISTS `0_sales_order_details`;
1276 CREATE TABLE `0_sales_order_details` (
1277 `id` int(11) NOT NULL auto_increment,
1278 `order_no` int(11) NOT NULL default '0',
1279 `trans_type` smallint(6) NOT NULL default '30',
1280 `stk_code` varchar(20) NOT NULL default '',
1281 `description` tinytext,
1282 `qty_sent` double NOT NULL default '0',
1283 `unit_price` double NOT NULL default '0',
1284 `quantity` double NOT NULL default '0',
1285 `discount_percent` double NOT NULL default '0',
1287 ) TYPE=InnoDB AUTO_INCREMENT=6 ;
1290 ### Data of table `0_sales_order_details` ###
1292 INSERT INTO `0_sales_order_details` VALUES ('1', '1', '30', '102', '17inch VGA Monitor', '2', '30.4', '2', '0');
1293 INSERT INTO `0_sales_order_details` VALUES ('2', '2', '30', '102', '17inch VGA Monitor', '1', '50', '1', '0');
1294 INSERT INTO `0_sales_order_details` VALUES ('3', '3', '30', '102', '17inch VGA Monitor', '1', '35.89', '1', '0');
1295 INSERT INTO `0_sales_order_details` VALUES ('4', '4', '30', '102', '17inch VGA Monitor', '0', '21.28', '2', '0');
1296 INSERT INTO `0_sales_order_details` VALUES ('5', '5', '30', '102', '17inch VGA Monitor', '1', '50', '1', '0');
1299 ### Structure of table `0_sales_orders` ###
1301 DROP TABLE IF EXISTS `0_sales_orders`;
1303 CREATE TABLE `0_sales_orders` (
1304 `order_no` int(11) NOT NULL auto_increment,
1305 `trans_type` smallint(6) NOT NULL default '30',
1306 `version` tinyint(1) unsigned NOT NULL default '0',
1307 `type` tinyint(1) NOT NULL default '0',
1308 `debtor_no` int(11) NOT NULL default '0',
1309 `branch_code` int(11) NOT NULL default '0',
1310 `reference` varchar(100) NOT NULL default '',
1311 `customer_ref` tinytext NOT NULL,
1312 `comments` tinytext,
1313 `ord_date` date NOT NULL default '0000-00-00',
1314 `order_type` int(11) NOT NULL default '0',
1315 `ship_via` int(11) NOT NULL default '0',
1316 `delivery_address` tinytext NOT NULL,
1317 `contact_phone` varchar(30) default NULL,
1318 `contact_email` varchar(100) default NULL,
1319 `deliver_to` tinytext NOT NULL,
1320 `freight_cost` double NOT NULL default '0',
1321 `from_stk_loc` varchar(5) NOT NULL default '',
1322 `delivery_date` date NOT NULL default '0000-00-00',
1323 PRIMARY KEY (`trans_type`, `order_no`)
1326 ### Data of table `0_sales_orders` ###
1328 INSERT INTO `0_sales_orders` VALUES ('1', '30', '1', '0', '1', '1', '1', '', '', '2009-06-21', '2', '1', 'Address 1\r\nAddress 2\r\nAddress 3', '', '', 'Beefeater Ltd.', '10', 'DEF', '2009-06-22');
1329 INSERT INTO `0_sales_orders` VALUES ('2', '30', '1', '0', '2', '2', '2', '', '', '2009-06-21', '1', '1', 'Address 1\r\nAddress 2\r\nAddress 3', '', '', 'Ghostbusters Corp.', '0', 'DEF', '2009-06-22');
1330 INSERT INTO `0_sales_orders` VALUES ('3', '30', '1', '0', '3', '3', '3', '', '', '2009-06-21', '2', '1', 'Address 1\r\nAddress 2\r\nAddress 3', '', '', 'Brezan', '0', 'DEF', '2009-07-01');
1331 INSERT INTO `0_sales_orders` VALUES ('4', '30', '0', '0', '1', '1', '4', '', '', '2009-06-21', '2', '1', 'Address 1\r\nAddress 2\r\nAddress 3', '', '', 'Beefeater Ltd.', '0', 'DEF', '2009-06-22');
1332 INSERT INTO `0_sales_orders` VALUES ('5', '30', '1', '0', '2', '2', '5', '', '', '2009-06-21', '1', '1', 'Address 1\r\nAddress 2\r\nAddress 3', '', '', 'Ghostbusters Corp.', '5', 'DEF', '2009-06-22');
1335 ### Structure of table `0_sales_pos` ###
1337 DROP TABLE IF EXISTS `0_sales_pos`;
1339 CREATE TABLE `0_sales_pos` (
1340 `id` smallint(6) unsigned NOT NULL auto_increment,
1341 `pos_name` varchar(30) NOT NULL,
1342 `cash_sale` tinyint(1) NOT NULL,
1343 `credit_sale` tinyint(1) NOT NULL,
1344 `pos_location` varchar(5) NOT NULL,
1345 `pos_account` smallint(6) unsigned NOT NULL,
1346 `inactive` tinyint(1) NOT NULL default '0',
1348 UNIQUE KEY `pos_name` (`pos_name`)
1349 ) TYPE=MyISAM AUTO_INCREMENT=2 ;
1352 ### Data of table `0_sales_pos` ###
1354 INSERT INTO `0_sales_pos` VALUES ('1', 'Default', '1', '1', 'DEF', '2', '0');
1357 ### Structure of table `0_sales_types` ###
1359 DROP TABLE IF EXISTS `0_sales_types`;
1361 CREATE TABLE `0_sales_types` (
1362 `id` int(11) NOT NULL auto_increment,
1363 `sales_type` char(50) NOT NULL default '',
1364 `tax_included` int(1) NOT NULL default '0',
1365 `factor` double NOT NULL default '1',
1366 `inactive` tinyint(1) NOT NULL default '0',
1368 UNIQUE KEY `sales_type` (`sales_type`)
1369 ) TYPE=MyISAM AUTO_INCREMENT=3 ;
1372 ### Data of table `0_sales_types` ###
1374 INSERT INTO `0_sales_types` VALUES ('1', 'Retail', '1', '1', '0');
1375 INSERT INTO `0_sales_types` VALUES ('2', 'Wholesale', '0', '0.7', '0');
1378 ### Structure of table `0_salesman` ###
1380 DROP TABLE IF EXISTS `0_salesman`;
1382 CREATE TABLE `0_salesman` (
1383 `salesman_code` int(11) NOT NULL auto_increment,
1384 `salesman_name` char(60) NOT NULL default '',
1385 `salesman_phone` char(30) NOT NULL default '',
1386 `salesman_fax` char(30) NOT NULL default '',
1387 `salesman_email` varchar(100) NOT NULL default '',
1388 `provision` double NOT NULL default '0',
1389 `break_pt` double NOT NULL default '0',
1390 `provision2` double NOT NULL default '0',
1391 `inactive` tinyint(1) NOT NULL default '0',
1392 PRIMARY KEY (`salesman_code`),
1393 UNIQUE KEY `salesman_name` (`salesman_name`)
1394 ) TYPE=MyISAM AUTO_INCREMENT=2 ;
1397 ### Data of table `0_salesman` ###
1399 INSERT INTO `0_salesman` VALUES ('1', 'Sales Person', '', '', '', '5', '1000', '4', '0');
1402 ### Structure of table `0_shippers` ###
1404 DROP TABLE IF EXISTS `0_shippers`;
1406 CREATE TABLE `0_shippers` (
1407 `shipper_id` int(11) NOT NULL auto_increment,
1408 `shipper_name` varchar(60) NOT NULL default '',
1409 `phone` varchar(30) NOT NULL default '',
1410 `contact` tinytext NOT NULL,
1411 `address` tinytext NOT NULL,
1412 `inactive` tinyint(1) NOT NULL default '0',
1413 PRIMARY KEY (`shipper_id`),
1414 UNIQUE KEY `name` (`shipper_name`)
1415 ) TYPE=MyISAM AUTO_INCREMENT=2 ;
1418 ### Data of table `0_shippers` ###
1420 INSERT INTO `0_shippers` VALUES ('1', 'Default', '', '', '', '0');
1423 ### Structure of table `0_sql_trail` ###
1425 DROP TABLE IF EXISTS `0_sql_trail`;
1427 CREATE TABLE `0_sql_trail` (
1428 `id` int(11) unsigned NOT NULL auto_increment,
1429 `sql` text NOT NULL,
1430 `result` tinyint(1) NOT NULL,
1431 `msg` varchar(255) NOT NULL,
1433 ) TYPE=MyISAM AUTO_INCREMENT=1 ;
1436 ### Data of table `0_sql_trail` ###
1440 ### Structure of table `0_stock_category` ###
1442 DROP TABLE IF EXISTS `0_stock_category`;
1444 CREATE TABLE `0_stock_category` (
1445 `category_id` int(11) NOT NULL auto_increment,
1446 `description` varchar(60) NOT NULL default '',
1447 `dflt_tax_type` int(11) NOT NULL default '1',
1448 `dflt_units` varchar(20) NOT NULL default 'each',
1449 `dflt_mb_flag` char(1) NOT NULL default 'B',
1450 `dflt_sales_act` varchar(11) NOT NULL default '',
1451 `dflt_cogs_act` varchar(11) NOT NULL default '',
1452 `dflt_inventory_act` varchar(11) NOT NULL default '',
1453 `dflt_adjustment_act` varchar(11) NOT NULL default '',
1454 `dflt_assembly_act` varchar(11) NOT NULL default '',
1455 `dflt_dim1` int(11) default NULL,
1456 `dflt_dim2` int(11) default NULL,
1457 `inactive` tinyint(1) NOT NULL default '0',
1458 `dflt_no_sale` tinyint(1) NOT NULL default '0',
1459 PRIMARY KEY (`category_id`),
1460 UNIQUE KEY `description` (`description`)
1461 ) TYPE=MyISAM AUTO_INCREMENT=5 ;
1463 ### Data of table `0_stock_category` ###
1465 INSERT INTO `0_stock_category` VALUES ('1', 'Components', '1', 'each', 'B', '4010', '5010', '1510', '5040', '1530', '0', '0', '0', '0');
1466 INSERT INTO `0_stock_category` VALUES ('2', 'Charges', '1', 'each', 'D', '4010', '5010', '1510', '5040', '1530', '0', '0', '0', '0');
1467 INSERT INTO `0_stock_category` VALUES ('3', 'Systems', '1', 'each', 'M', '4010', '5010', '1510', '5040', '1530', '0', '0', '0', '0');
1468 INSERT INTO `0_stock_category` VALUES ('4', 'Services', '1', 'hrs', 'D', '4010', '5010', '1510', '5040', '1530', '0', '0', '0', '0');
1471 ### Structure of table `0_stock_master` ###
1473 DROP TABLE IF EXISTS `0_stock_master`;
1475 CREATE TABLE `0_stock_master` (
1476 `stock_id` varchar(20) NOT NULL default '',
1477 `category_id` int(11) NOT NULL default '0',
1478 `tax_type_id` int(11) NOT NULL default '0',
1479 `description` varchar(200) NOT NULL default '',
1480 `long_description` tinytext NOT NULL,
1481 `units` varchar(20) NOT NULL default 'each',
1482 `mb_flag` char(1) NOT NULL default 'B',
1483 `sales_account` varchar(11) NOT NULL default '',
1484 `cogs_account` varchar(11) NOT NULL default '',
1485 `inventory_account` varchar(11) NOT NULL default '',
1486 `adjustment_account` varchar(11) NOT NULL default '',
1487 `assembly_account` varchar(11) NOT NULL default '',
1488 `dimension_id` int(11) default NULL,
1489 `dimension2_id` int(11) default NULL,
1490 `actual_cost` double NOT NULL default '0',
1491 `last_cost` double NOT NULL default '0',
1492 `material_cost` double NOT NULL default '0',
1493 `labour_cost` double NOT NULL default '0',
1494 `overhead_cost` double NOT NULL default '0',
1495 `inactive` tinyint(1) NOT NULL default '0',
1496 `no_sale` tinyint(1) NOT NULL default '0',
1497 PRIMARY KEY (`stock_id`)
1501 ### Data of table `0_stock_master` ###
1503 INSERT INTO `0_stock_master` VALUES ('102', '1', '1', '17inch VGA Monitor', '', 'ea.', 'B', '4010', '5010', '1510', '5040', '1530', '0', '0', '0', '0', '10', '0', '0', '0', '0');
1504 INSERT INTO `0_stock_master` VALUES ('103', '1', '1', '32MB VGA Card', '', 'ea.', 'B', '4010', '5010', '1510', '5040', '1530', '0', '0', '0', '0', '11', '0', '0', '0', '0');
1505 INSERT INTO `0_stock_master` VALUES ('104', '1', '1', '52x CD Drive', '', 'ea.', 'B', '4010', '5010', '1510', '5040', '1530', '0', '0', '0', '0', '12', '0', '0', '0', '0');
1506 INSERT INTO `0_stock_master` VALUES ('201', '4', '1', 'Assembly Labour', '', 'hrs', 'D', '4010', '5010', '5010', '5040', '1530', '0', '0', '0', '0', '0', '0', '0', '0', '0');
1507 INSERT INTO `0_stock_master` VALUES ('3400', '3', '1', 'P4 Business System', '', 'ea.', 'M', '4010', '5010', '1540', '5040', '1530', '0', '0', '0', '0', '33', '3.9999999999999', '2', '0', '0');
1510 ### Structure of table `0_stock_moves` ###
1512 DROP TABLE IF EXISTS `0_stock_moves`;
1514 CREATE TABLE `0_stock_moves` (
1515 `trans_id` int(11) NOT NULL auto_increment,
1516 `trans_no` int(11) NOT NULL default '0',
1517 `stock_id` char(20) NOT NULL default '',
1518 `type` smallint(6) NOT NULL default '0',
1519 `loc_code` char(5) NOT NULL default '',
1520 `tran_date` date NOT NULL default '0000-00-00',
1521 `person_id` int(11) default NULL,
1522 `price` double NOT NULL default '0',
1523 `reference` char(40) NOT NULL default '',
1524 `qty` double NOT NULL default '1',
1525 `discount_percent` double NOT NULL default '0',
1526 `standard_cost` double NOT NULL default '0',
1527 `visible` tinyint(1) NOT NULL default '1',
1528 PRIMARY KEY (`trans_id`),
1529 KEY `type` (`type`,`trans_no`)
1530 ) TYPE=InnoDB AUTO_INCREMENT=37 ;
1533 ### Data of table `0_stock_moves` ###
1535 INSERT INTO `0_stock_moves` VALUES ('1', '1', '102', '25', 'DEF', '2009-06-21', '2', '10', '', '100', '0', '10', '1');
1536 INSERT INTO `0_stock_moves` VALUES ('2', '1', '103', '25', 'DEF', '2009-06-21', '2', '11', '', '100', '0', '11', '1');
1537 INSERT INTO `0_stock_moves` VALUES ('3', '1', '104', '25', 'DEF', '2009-06-21', '2', '12', '', '100', '0', '12', '1');
1538 INSERT INTO `0_stock_moves` VALUES ('4', '1', '102', '26', 'DEF', '2009-06-21', '0', '0', '1', '-10', '0', '0', '1');
1539 INSERT INTO `0_stock_moves` VALUES ('5', '1', '103', '26', 'DEF', '2009-06-21', '0', '0', '1', '-10', '0', '0', '1');
1540 INSERT INTO `0_stock_moves` VALUES ('6', '1', '104', '26', 'DEF', '2009-06-21', '0', '0', '1', '-10', '0', '0', '1');
1541 INSERT INTO `0_stock_moves` VALUES ('7', '1', '3400', '26', 'DEF', '2009-06-21', '0', '0', '1', '10', '0', '0', '1');
1542 INSERT INTO `0_stock_moves` VALUES ('8', '2', '102', '13', 'DEF', '2009-06-21', '0', '30.4', '1', '-2', '0', '10', '1');
1543 INSERT INTO `0_stock_moves` VALUES ('9', '3', '102', '13', 'DEF', '2009-06-21', '0', '50', 'auto', '-1', '0', '10', '1');
1544 INSERT INTO `0_stock_moves` VALUES ('10', '4', '102', '13', 'DEF', '2009-06-21', '0', '35.89', 'auto', '-1', '0', '10', '1');
1545 INSERT INTO `0_stock_moves` VALUES ('11', '3', '102', '26', 'DEF', '2009-06-21', '0', '0', '3', '-2', '0', '0', '1');
1546 INSERT INTO `0_stock_moves` VALUES ('12', '3', '103', '26', 'DEF', '2009-06-21', '0', '0', '3', '-2', '0', '0', '1');
1547 INSERT INTO `0_stock_moves` VALUES ('13', '3', '104', '26', 'DEF', '2009-06-21', '0', '0', '3', '-2', '0', '0', '1');
1548 INSERT INTO `0_stock_moves` VALUES ('14', '3', '3400', '26', 'DEF', '2009-06-21', '0', '0', '3', '2', '0', '0', '1');
1549 INSERT INTO `0_stock_moves` VALUES ('15', '4', '102', '26', 'DEF', '2009-06-21', '0', '0', '4', '-4', '0', '0', '1');
1550 INSERT INTO `0_stock_moves` VALUES ('16', '4', '103', '26', 'DEF', '2009-06-21', '0', '0', '4', '-4', '0', '0', '1');
1551 INSERT INTO `0_stock_moves` VALUES ('17', '4', '104', '26', 'DEF', '2009-06-21', '0', '0', '4', '-4', '0', '0', '1');
1552 INSERT INTO `0_stock_moves` VALUES ('18', '4', '3400', '26', 'DEF', '2009-06-21', '0', '0', '4', '4', '0', '0', '1');
1553 INSERT INTO `0_stock_moves` VALUES ('19', '2', '102', '26', 'DEF', '2009-06-21', '0', '0', '', '-2', '0', '0', '1');
1554 INSERT INTO `0_stock_moves` VALUES ('20', '2', '103', '26', 'DEF', '2009-06-21', '0', '0', '', '-2', '0', '0', '1');
1555 INSERT INTO `0_stock_moves` VALUES ('21', '2', '104', '26', 'DEF', '2009-06-21', '0', '0', '', '-2', '0', '0', '1');
1556 INSERT INTO `0_stock_moves` VALUES ('22', '1', '3400', '29', 'DEF', '2009-06-21', '0', '0', '', '2', '0', '0', '1');
1557 INSERT INTO `0_stock_moves` VALUES ('23', '5', '102', '26', 'DEF', '2009-06-21', '0', '0', '5', '-5', '0', '0', '1');
1558 INSERT INTO `0_stock_moves` VALUES ('24', '5', '103', '26', 'DEF', '2009-06-21', '0', '0', '5', '-5', '0', '0', '1');
1559 INSERT INTO `0_stock_moves` VALUES ('25', '5', '104', '26', 'DEF', '2009-06-21', '0', '0', '5', '-5', '0', '0', '1');
1560 INSERT INTO `0_stock_moves` VALUES ('26', '5', '3400', '26', 'DEF', '2009-06-21', '0', '0', '5', '5', '0', '0', '1');
1561 INSERT INTO `0_stock_moves` VALUES ('27', '6', '102', '26', 'DEF', '2009-06-21', '0', '0', '6', '5', '0', '0', '1');
1562 INSERT INTO `0_stock_moves` VALUES ('28', '6', '103', '26', 'DEF', '2009-06-21', '0', '0', '6', '5', '0', '0', '1');
1563 INSERT INTO `0_stock_moves` VALUES ('29', '6', '104', '26', 'DEF', '2009-06-21', '0', '0', '6', '5', '0', '0', '1');
1564 INSERT INTO `0_stock_moves` VALUES ('30', '6', '3400', '26', 'DEF', '2009-06-21', '0', '0', '6', '-5', '0', '0', '1');
1565 INSERT INTO `0_stock_moves` VALUES ('31', '7', '102', '26', 'DEF', '2009-06-21', '0', '0', '7', '2', '0', '0', '1');
1566 INSERT INTO `0_stock_moves` VALUES ('32', '7', '103', '26', 'DEF', '2009-06-21', '0', '0', '7', '2', '0', '0', '1');
1567 INSERT INTO `0_stock_moves` VALUES ('33', '7', '104', '26', 'DEF', '2009-06-21', '0', '0', '7', '2', '0', '0', '1');
1568 INSERT INTO `0_stock_moves` VALUES ('34', '7', '3400', '26', 'DEF', '2009-06-21', '0', '0', '7', '-2', '0', '0', '1');
1569 INSERT INTO `0_stock_moves` VALUES ('35', '5', '102', '13', 'DEF', '2009-06-21', '0', '50', 'auto', '-1', '0', '10', '1');
1570 INSERT INTO `0_stock_moves` VALUES ('36', '3', '102', '11', 'DEF', '2009-06-21', '0', '37.68', 'Return Ex Inv: 18', '1', '0', '10', '0');
1573 ### Structure of table `0_supp_allocations` ###
1575 DROP TABLE IF EXISTS `0_supp_allocations`;
1577 CREATE TABLE `0_supp_allocations` (
1578 `id` int(11) NOT NULL auto_increment,
1579 `amt` double unsigned default NULL,
1580 `date_alloc` date NOT NULL default '0000-00-00',
1581 `trans_no_from` int(11) default NULL,
1582 `trans_type_from` int(11) default NULL,
1583 `trans_no_to` int(11) default NULL,
1584 `trans_type_to` int(11) default NULL,
1586 ) TYPE=InnoDB AUTO_INCREMENT=2 ;
1589 ### Data of table `0_supp_allocations` ###
1591 INSERT INTO `0_supp_allocations` VALUES ('1', '3465', '2009-06-21', '4', '22', '7', '20');
1594 ### Structure of table `0_supp_invoice_items` ###
1596 DROP TABLE IF EXISTS `0_supp_invoice_items`;
1598 CREATE TABLE `0_supp_invoice_items` (
1599 `id` int(11) NOT NULL auto_increment,
1600 `supp_trans_no` int(11) default NULL,
1601 `supp_trans_type` int(11) default NULL,
1602 `gl_code` varchar(11) NOT NULL default '0',
1603 `grn_item_id` int(11) default NULL,
1604 `po_detail_item_id` int(11) default NULL,
1605 `stock_id` varchar(20) NOT NULL default '',
1606 `description` tinytext,
1607 `quantity` double NOT NULL default '0',
1608 `unit_price` double NOT NULL default '0',
1609 `unit_tax` double NOT NULL default '0',
1612 ) TYPE=InnoDB AUTO_INCREMENT=6 ;
1615 ### Data of table `0_supp_invoice_items` ###
1617 INSERT INTO `0_supp_invoice_items` VALUES ('1', '7', '20', '0', '1', '1', '102', '17inch VGA Monitor', '100', '10', '0.5', '');
1618 INSERT INTO `0_supp_invoice_items` VALUES ('2', '7', '20', '0', '2', '2', '103', '32MB VGA Card', '100', '11', '0.55', '');
1619 INSERT INTO `0_supp_invoice_items` VALUES ('3', '7', '20', '0', '3', '3', '104', '52x CD Drive', '100', '12', '0.6', '');
1620 INSERT INTO `0_supp_invoice_items` VALUES ('4', '8', '20', '2150', '0', '0', '', '', '0', '0.95', '0', 'Phone');
1621 INSERT INTO `0_supp_invoice_items` VALUES ('5', '8', '20', '5780', '0', '0', '', '', '0', '19.05', '0', 'Phone');
1624 ### Structure of table `0_supp_trans` ###
1626 DROP TABLE IF EXISTS `0_supp_trans`;
1628 CREATE TABLE `0_supp_trans` (
1629 `trans_no` int(11) unsigned NOT NULL default '0',
1630 `type` smallint(6) unsigned NOT NULL default '0',
1631 `supplier_id` int(11) unsigned default NULL,
1632 `reference` tinytext NOT NULL,
1633 `supp_reference` varchar(60) NOT NULL default '',
1634 `tran_date` date NOT NULL default '0000-00-00',
1635 `due_date` date NOT NULL default '0000-00-00',
1636 `ov_amount` double NOT NULL default '0',
1637 `ov_discount` double NOT NULL default '0',
1638 `ov_gst` double NOT NULL default '0',
1639 `rate` double NOT NULL default '1',
1640 `alloc` double NOT NULL default '0',
1641 PRIMARY KEY (`trans_no`,`type`),
1642 KEY `supplier_id` (`supplier_id`),
1643 KEY `SupplierID_2` (`supplier_id`,`supp_reference`),
1648 ### Data of table `0_supp_trans` ###
1650 INSERT INTO `0_supp_trans` VALUES ('4', '22', '2', '1', '', '2009-06-21', '2009-06-21', '-3465', '0', '0', '1', '3465');
1651 INSERT INTO `0_supp_trans` VALUES ('7', '20', '2', '1', '5t', '2009-06-21', '2009-07-01', '3300', '0', '165', '1', '3465');
1652 INSERT INTO `0_supp_trans` VALUES ('8', '20', '2', '2', 'cc', '2009-06-21', '2009-07-01', '20', '0', '0', '1', '0');
1655 ### Structure of table `0_suppliers` ###
1657 DROP TABLE IF EXISTS `0_suppliers`;
1659 CREATE TABLE `0_suppliers` (
1660 `supplier_id` int(11) NOT NULL auto_increment,
1661 `supp_name` varchar(60) NOT NULL default '',
1662 `supp_ref` varchar(30) NOT NULL default '',
1663 `address` tinytext NOT NULL,
1664 `supp_address` tinytext NOT NULL,
1665 `phone` varchar(30) NOT NULL default '',
1666 `fax` varchar(30) NOT NULL default '',
1667 `gst_no` varchar(25) NOT NULL default '',
1668 `contact` varchar(60) NOT NULL default '',
1669 `supp_account_no` varchar(40) NOT NULL default '',
1670 `email` varchar(100) NOT NULL default '',
1671 `website` varchar(100) NOT NULL default '',
1672 `bank_account` varchar(60) NOT NULL default '',
1673 `curr_code` char(3) default NULL,
1674 `payment_terms` int(11) default NULL,
1675 `dimension_id` int(11) default '0',
1676 `dimension2_id` int(11) default '0',
1677 `tax_group_id` int(11) default NULL,
1678 `credit_limit` double NOT NULL default '0',
1679 `purchase_account` varchar(11) default NULL,
1680 `payable_account` varchar(11) default NULL,
1681 `payment_discount_account` varchar(11) default NULL,
1682 `notes` tinytext NOT NULL,
1683 `inactive` tinyint(1) NOT NULL default '0',
1684 PRIMARY KEY (`supplier_id`)
1685 ) TYPE=MyISAM AUTO_INCREMENT=4 ;
1688 ### Data of table `0_suppliers` ###
1690 INSERT INTO `0_suppliers` VALUES ('1', 'Junk Beer ApS', 'Junk Beer', 'Mailing 1\r\nMailing 2\r\nMailing 3', 'Address 1\r\nAddress 2\r\nAddress 3', '+45 55667788', '', '123456', 'Contact', '111', '', '', '', 'DKK', '3', '1', '0', '2', '1', '5010', '2100', '5060', 'A supplier with junk beers.', '0');
1691 INSERT INTO `0_suppliers` VALUES ('2', 'Lucky Luke Inc.', 'Lucky Luke', 'Mailing 1\r\nMailing 2\r\nMailing 3', 'Address 1\r\nAddress 2\r\nAddress 3', '(111) 222.333.444', '', '654321', 'Luke', '333', '', '', '', 'USD', '3', '0', '0', '1', '1', '5010', '2100', '5060', '', '0');
1692 INSERT INTO `0_suppliers` VALUES ('3', 'Money Makers Ltd.', 'Money Makers', 'Mailing 1\r\nMailing 2\r\nMailing 3', 'Address 1\r\nAddress 2\r\nAddress 3', '+44 444 555 666', '', '987654', 'Makers', '222', '', '', '', 'GBP', '3', '0', '0', '2', '1', '5010', '2100', '5060', '', '0');
1695 ### Structure of table `0_sys_types` ###
1697 DROP TABLE IF EXISTS `0_sys_types`;
1699 CREATE TABLE `0_sys_types` (
1700 `type_id` smallint(6) NOT NULL default '0',
1701 `type_no` int(11) NOT NULL default '1',
1702 `next_reference` varchar(100) NOT NULL default '',
1703 PRIMARY KEY (`type_id`)
1707 ### Data of table `0_sys_types` ###
1709 INSERT INTO `0_sys_types` VALUES ('0', '19', '3');
1710 INSERT INTO `0_sys_types` VALUES ('1', '8', '2');
1711 INSERT INTO `0_sys_types` VALUES ('2', '5', '2');
1712 INSERT INTO `0_sys_types` VALUES ('4', '3', '1');
1713 INSERT INTO `0_sys_types` VALUES ('10', '19', '4');
1714 INSERT INTO `0_sys_types` VALUES ('11', '3', '2');
1715 INSERT INTO `0_sys_types` VALUES ('12', '6', '1');
1716 INSERT INTO `0_sys_types` VALUES ('13', '5', '2');
1717 INSERT INTO `0_sys_types` VALUES ('16', '2', '1');
1718 INSERT INTO `0_sys_types` VALUES ('17', '2', '1');
1719 INSERT INTO `0_sys_types` VALUES ('18', '1', '3');
1720 INSERT INTO `0_sys_types` VALUES ('20', '8', '3');
1721 INSERT INTO `0_sys_types` VALUES ('21', '1', '1');
1722 INSERT INTO `0_sys_types` VALUES ('22', '4', '2');
1723 INSERT INTO `0_sys_types` VALUES ('25', '1', '2');
1724 INSERT INTO `0_sys_types` VALUES ('26', '1', '8');
1725 INSERT INTO `0_sys_types` VALUES ('28', '1', '1');
1726 INSERT INTO `0_sys_types` VALUES ('29', '1', '2');
1727 INSERT INTO `0_sys_types` VALUES ('30', '5', '6');
1728 INSERT INTO `0_sys_types` VALUES ('32', '0', '1');
1729 INSERT INTO `0_sys_types` VALUES ('35', '1', '1');
1730 INSERT INTO `0_sys_types` VALUES ('40', '1', '3');
1733 ### Structure of table `0_tax_group_items` ###
1735 DROP TABLE IF EXISTS `0_tax_group_items`;
1737 CREATE TABLE `0_tax_group_items` (
1738 `tax_group_id` int(11) NOT NULL default '0',
1739 `tax_type_id` int(11) NOT NULL default '0',
1740 `rate` double NOT NULL default '0',
1741 PRIMARY KEY (`tax_group_id`,`tax_type_id`)
1745 ### Data of table `0_tax_group_items` ###
1747 INSERT INTO `0_tax_group_items` VALUES ('1', '1', '5');
1750 ### Structure of table `0_tax_groups` ###
1752 DROP TABLE IF EXISTS `0_tax_groups`;
1754 CREATE TABLE `0_tax_groups` (
1755 `id` int(11) NOT NULL auto_increment,
1756 `name` varchar(60) NOT NULL default '',
1757 `tax_shipping` tinyint(1) NOT NULL default '0',
1758 `inactive` tinyint(1) NOT NULL default '0',
1760 UNIQUE KEY `name` (`name`)
1761 ) TYPE=InnoDB AUTO_INCREMENT=3 ;
1764 ### Data of table `0_tax_groups` ###
1766 INSERT INTO `0_tax_groups` VALUES ('1', 'Tax', '0', '0');
1767 INSERT INTO `0_tax_groups` VALUES ('2', 'Tax Exempt', '0', '0');
1769 ### Structure of table `0_tax_types` ###
1771 DROP TABLE IF EXISTS `0_tax_types`;
1773 CREATE TABLE `0_tax_types` (
1774 `id` int(11) NOT NULL auto_increment,
1775 `rate` double NOT NULL default '0',
1776 `sales_gl_code` varchar(11) NOT NULL default '',
1777 `purchasing_gl_code` varchar(11) NOT NULL default '',
1778 `name` varchar(60) NOT NULL default '',
1779 `inactive` tinyint(1) NOT NULL default '0',
1781 ) TYPE=InnoDB AUTO_INCREMENT=5 AUTO_INCREMENT=5 ;
1784 ### Data of table `0_tax_types` ###
1786 INSERT INTO `0_tax_types` VALUES ('1', '5', '2150', '2150', 'Tax', '0');
1788 ### Structure of table `0_trans_tax_details` ###
1790 DROP TABLE IF EXISTS `0_trans_tax_details`;
1792 CREATE TABLE `0_trans_tax_details` (
1793 `id` int(11) NOT NULL auto_increment,
1794 `trans_type` smallint(6) default NULL,
1795 `trans_no` int(11) default NULL,
1796 `tran_date` date NOT NULL,
1797 `tax_type_id` int(11) NOT NULL default '0',
1798 `rate` double NOT NULL default '0',
1799 `ex_rate` double NOT NULL default '1',
1800 `included_in_price` tinyint(1) NOT NULL default '0',
1801 `net_amount` double NOT NULL default '0',
1802 `amount` double NOT NULL default '0',
1805 ) TYPE=InnoDB AUTO_INCREMENT=12 ;
1808 ### Data of table `0_trans_tax_details` ###
1810 INSERT INTO `0_trans_tax_details` VALUES ('1', '20', '7', '2009-06-21', '1', '5', '1', '0', '3300', '165', '5t');
1811 INSERT INTO `0_trans_tax_details` VALUES ('2', '13', '3', '2009-06-21', '1', '5', '1', '0', '50', '2.5', 'auto');
1812 INSERT INTO `0_trans_tax_details` VALUES ('3', '10', '17', '2009-06-21', '1', '5', '1', '0', '50', '2.5', '1');
1813 INSERT INTO `0_trans_tax_details` VALUES ('4', '13', '4', '2009-06-21', '1', '5', '1.3932', '0', '35.89', '1.7945', 'auto');
1814 INSERT INTO `0_trans_tax_details` VALUES ('5', '10', '18', '2009-06-21', '1', '5', '1.3932', '0', '35.89', '1.7945', '2');
1815 INSERT INTO `0_trans_tax_details` VALUES ('6', '2', '5', '2009-06-21', '1', '5', '1', '0', '95.2', '4.76', '');
1816 INSERT INTO `0_trans_tax_details` VALUES ('7', '1', '8', '2009-06-21', '1', '5', '1', '0', '-47.6', '-2.38', '');
1817 INSERT INTO `0_trans_tax_details` VALUES ('8', '20', '8', '2009-06-21', '1', '5', '1', '0', '-19', '-0.95', 'cc');
1818 INSERT INTO `0_trans_tax_details` VALUES ('9', '13', '5', '2009-06-21', '1', '5', '1', '1', '47.619047619048', '2.3809523809524', 'auto');
1819 INSERT INTO `0_trans_tax_details` VALUES ('10', '10', '19', '2009-06-21', '1', '5', '1', '1', '47.619047619048', '2.3809523809524', '3');
1820 INSERT INTO `0_trans_tax_details` VALUES ('11', '11', '3', '2009-06-21', '1', '5', '1.3932', '0', '35.89', '1.7945', '1');
1822 ### Structure of table `0_users` ###
1824 DROP TABLE IF EXISTS `0_users`;
1826 CREATE TABLE `0_users` (
1827 `id` SMALLINT(6) AUTO_INCREMENT,
1828 `user_id` varchar(60) NOT NULL default '',
1829 `password` varchar(100) NOT NULL default '',
1830 `real_name` varchar(100) NOT NULL default '',
1831 `role_id` int(11) NOT NULL default '1',
1832 `phone` varchar(30) NOT NULL default '',
1833 `email` varchar(100) default NULL,
1834 `language` varchar(20) default NULL,
1835 `date_format` tinyint(1) NOT NULL default '0',
1836 `date_sep` tinyint(1) NOT NULL default '0',
1837 `tho_sep` tinyint(1) NOT NULL default '0',
1838 `dec_sep` tinyint(1) NOT NULL default '0',
1839 `theme` varchar(20) NOT NULL default 'default',
1840 `page_size` varchar(20) NOT NULL default 'A4',
1841 `prices_dec` smallint(6) NOT NULL default '2',
1842 `qty_dec` smallint(6) NOT NULL default '2',
1843 `rates_dec` smallint(6) NOT NULL default '4',
1844 `percent_dec` smallint(6) NOT NULL default '1',
1845 `show_gl` tinyint(1) NOT NULL default '1',
1846 `show_codes` tinyint(1) NOT NULL default '0',
1847 `show_hints` tinyint(1) NOT NULL default '0',
1848 `last_visit_date` datetime default NULL,
1849 `query_size` tinyint(1) default '10',
1850 `graphic_links` tinyint(1) default '1',
1851 `pos` smallint(6) default '1',
1852 `print_profile` varchar(30) NOT NULL default '1',
1853 `rep_popup` tinyint(1) default '1',
1854 `sticky_doc_date` tinyint(1) default '0',
1855 `startup_tab` varchar(20) NOT NULL default '',
1856 `inactive` tinyint(1) NOT NULL default '0',
1858 UNIQUE KEY (`user_id`)
1859 ) TYPE=MyISAM AUTO_INCREMENT=2;
1862 ### Data of table `0_users` ###
1864 INSERT INTO `0_users` VALUES ('1', 'admin', '5f4dcc3b5aa765d61d8327deb882cf99', 'Administrator', '2', '', 'adm@adm.com', 'en_US', '0', '0', '0', '0', 'default', 'Letter', '2', '2', '4', '1', '1', '0', '0', '2009-01-30 09:39:03', '10', '1', '1', '1', '1', '0', 'orders', '0');
1865 INSERT INTO `0_users` VALUES ('2', 'demouser', '5f4dcc3b5aa765d61d8327deb882cf99', 'Demo User', '1', '999-999-999', 'demo@demo.nu', 'en_US', '0', '0', '0', '0', 'default', 'Letter', '2', '2', '3', '1', '1', '0', '0', '2008-02-06 19:02:35', '10', '1', '1', '1', '1', '0', 'orders', '0');
1867 ### Structure of table `0_voided` ###
1869 DROP TABLE IF EXISTS `0_voided`;
1871 CREATE TABLE `0_voided` (
1872 `type` int(11) NOT NULL default '0',
1873 `id` int(11) NOT NULL default '0',
1874 `date_` date NOT NULL default '0000-00-00',
1875 `memo_` tinytext NOT NULL,
1876 UNIQUE KEY `id` (`type`,`id`)
1880 ### Data of table `0_voided` ###
1884 ### Structure of table `0_wo_issue_items` ###
1886 DROP TABLE IF EXISTS `0_wo_issue_items`;
1888 CREATE TABLE `0_wo_issue_items` (
1889 `id` int(11) NOT NULL auto_increment,
1890 `stock_id` varchar(40) default NULL,
1891 `issue_id` int(11) default NULL,
1892 `qty_issued` double default NULL,
1894 ) TYPE=InnoDB AUTO_INCREMENT=1 ;
1897 ### Data of table `0_wo_issue_items` ###
1901 ### Structure of table `0_wo_issues` ###
1903 DROP TABLE IF EXISTS `0_wo_issues`;
1905 CREATE TABLE `0_wo_issues` (
1906 `issue_no` int(11) NOT NULL auto_increment,
1907 `workorder_id` int(11) NOT NULL default '0',
1908 `reference` varchar(100) default NULL,
1909 `issue_date` date default NULL,
1910 `loc_code` varchar(5) default NULL,
1911 `workcentre_id` int(11) default NULL,
1912 PRIMARY KEY (`issue_no`)
1913 ) TYPE=InnoDB AUTO_INCREMENT=1 ;
1916 ### Data of table `0_wo_issues` ###
1920 ### Structure of table `0_wo_manufacture` ###
1922 DROP TABLE IF EXISTS `0_wo_manufacture`;
1924 CREATE TABLE `0_wo_manufacture` (
1925 `id` int(11) NOT NULL auto_increment,
1926 `reference` varchar(100) default NULL,
1927 `workorder_id` int(11) NOT NULL default '0',
1928 `quantity` double NOT NULL default '0',
1929 `date_` date NOT NULL default '0000-00-00',
1931 ) TYPE=InnoDB AUTO_INCREMENT=2 ;
1934 ### Data of table `0_wo_manufacture` ###
1936 INSERT INTO `0_wo_manufacture` VALUES ('1', '1', '2', '2', '2009-06-21');
1939 ### Structure of table `0_wo_requirements` ###
1941 DROP TABLE IF EXISTS `0_wo_requirements`;
1943 CREATE TABLE `0_wo_requirements` (
1944 `id` int(11) NOT NULL auto_increment,
1945 `workorder_id` int(11) NOT NULL default '0',
1946 `stock_id` char(20) NOT NULL default '',
1947 `workcentre` int(11) NOT NULL default '0',
1948 `units_req` double NOT NULL default '1',
1949 `std_cost` double NOT NULL default '0',
1950 `loc_code` char(5) NOT NULL default '',
1951 `units_issued` double NOT NULL default '0',
1953 ) TYPE=InnoDB AUTO_INCREMENT=22 ;
1956 ### Data of table `0_wo_requirements` ###
1958 INSERT INTO `0_wo_requirements` VALUES ('1', '1', '102', '1', '1', '0', 'DEF', '10');
1959 INSERT INTO `0_wo_requirements` VALUES ('2', '1', '103', '1', '1', '0', 'DEF', '10');
1960 INSERT INTO `0_wo_requirements` VALUES ('3', '1', '104', '1', '1', '0', 'DEF', '10');
1961 INSERT INTO `0_wo_requirements` VALUES ('4', '2', '102', '1', '1', '0', 'DEF', '0');
1962 INSERT INTO `0_wo_requirements` VALUES ('5', '2', '103', '1', '1', '0', 'DEF', '0');
1963 INSERT INTO `0_wo_requirements` VALUES ('6', '2', '104', '1', '1', '0', 'DEF', '0');
1964 INSERT INTO `0_wo_requirements` VALUES ('7', '3', '102', '1', '1', '0', 'DEF', '2');
1965 INSERT INTO `0_wo_requirements` VALUES ('8', '3', '103', '1', '1', '0', 'DEF', '2');
1966 INSERT INTO `0_wo_requirements` VALUES ('9', '3', '104', '1', '1', '0', 'DEF', '2');
1967 INSERT INTO `0_wo_requirements` VALUES ('10', '4', '102', '1', '1', '0', 'DEF', '4');
1968 INSERT INTO `0_wo_requirements` VALUES ('11', '4', '103', '1', '1', '0', 'DEF', '4');
1969 INSERT INTO `0_wo_requirements` VALUES ('12', '4', '104', '1', '1', '0', 'DEF', '4');
1970 INSERT INTO `0_wo_requirements` VALUES ('13', '5', '102', '1', '1', '0', 'DEF', '5');
1971 INSERT INTO `0_wo_requirements` VALUES ('14', '5', '103', '1', '1', '0', 'DEF', '5');
1972 INSERT INTO `0_wo_requirements` VALUES ('15', '5', '104', '1', '1', '0', 'DEF', '5');
1973 INSERT INTO `0_wo_requirements` VALUES ('16', '6', '102', '1', '1', '0', 'DEF', '-5');
1974 INSERT INTO `0_wo_requirements` VALUES ('17', '6', '103', '1', '1', '0', 'DEF', '-5');
1975 INSERT INTO `0_wo_requirements` VALUES ('18', '6', '104', '1', '1', '0', 'DEF', '-5');
1976 INSERT INTO `0_wo_requirements` VALUES ('19', '7', '102', '1', '1', '0', 'DEF', '-2');
1977 INSERT INTO `0_wo_requirements` VALUES ('20', '7', '103', '1', '1', '0', 'DEF', '-2');
1978 INSERT INTO `0_wo_requirements` VALUES ('21', '7', '104', '1', '1', '0', 'DEF', '-2');
1981 ### Structure of table `0_workcentres` ###
1983 DROP TABLE IF EXISTS `0_workcentres`;
1985 CREATE TABLE `0_workcentres` (
1986 `id` int(11) NOT NULL auto_increment,
1987 `name` char(40) NOT NULL default '',
1988 `description` char(50) NOT NULL default '',
1989 `inactive` tinyint(1) NOT NULL default '0',
1991 UNIQUE KEY `name` (`name`)
1992 ) TYPE=MyISAM AUTO_INCREMENT=2 ;
1995 ### Data of table `0_workcentres` ###
1997 INSERT INTO `0_workcentres` VALUES ('1', 'Workshop', 'Workshop in Alabama', '0');
2000 ### Structure of table `0_workorders` ###
2002 DROP TABLE IF EXISTS `0_workorders`;
2004 CREATE TABLE `0_workorders` (
2005 `id` int(11) NOT NULL auto_increment,
2006 `wo_ref` varchar(60) NOT NULL default '',
2007 `loc_code` varchar(5) NOT NULL default '',
2008 `units_reqd` double NOT NULL default '1',
2009 `stock_id` varchar(20) NOT NULL default '',
2010 `date_` date NOT NULL default '0000-00-00',
2011 `type` tinyint(4) NOT NULL default '0',
2012 `required_by` date NOT NULL default '0000-00-00',
2013 `released_date` date NOT NULL default '0000-00-00',
2014 `units_issued` double NOT NULL default '0',
2015 `closed` tinyint(1) NOT NULL default '0',
2016 `released` tinyint(1) NOT NULL default '0',
2017 `additional_costs` double NOT NULL default '0',
2019 UNIQUE KEY `wo_ref` (`wo_ref`)
2020 ) TYPE=InnoDB AUTO_INCREMENT=8 ;
2023 ### Data of table `0_workorders` ###
2025 INSERT INTO `0_workorders` VALUES ('1', '1', 'DEF', '10', '3400', '2009-06-21', '0', '2009-06-21', '2009-06-21', '10', '1', '1', '10');
2026 INSERT INTO `0_workorders` VALUES ('2', '2', 'DEF', '3', '3400', '2009-06-21', '2', '2009-07-11', '2009-06-21', '2', '0', '1', '0');
2027 INSERT INTO `0_workorders` VALUES ('3', '3', 'DEF', '2', '3400', '2009-06-21', '0', '2009-06-21', '2009-06-21', '2', '1', '1', '0');
2028 INSERT INTO `0_workorders` VALUES ('4', '4', 'DEF', '4', '3400', '2009-06-21', '0', '2009-06-21', '2009-06-21', '4', '1', '1', '0');
2029 INSERT INTO `0_workorders` VALUES ('5', '5', 'DEF', '5', '3400', '2009-06-21', '0', '2009-06-21', '2009-06-21', '5', '1', '1', '10');
2030 INSERT INTO `0_workorders` VALUES ('6', '6', 'DEF', '-5', '3400', '2009-06-21', '1', '2009-06-21', '2009-06-21', '-5', '1', '1', '0');
2031 INSERT INTO `0_workorders` VALUES ('7', '7', 'DEF', '-2', '3400', '2009-06-21', '1', '2009-06-21', '2009-06-21', '-2', '1', '1', '10');
2033 DROP TABLE IF EXISTS `0_security_roles`;
2035 CREATE TABLE `0_security_roles` (
2036 `id` int(11) NOT NULL auto_increment,
2037 `role` varchar(20) NOT NULL,
2038 `description` varchar(50) default NULL,
2041 `inactive` tinyint(1) NOT NULL default '0',
2043 UNIQUE KEY `role` (`role`)
2044 ) ENGINE=MyISAM AUTO_INCREMENT=8 DEFAULT CHARSET=latin1 AUTO_INCREMENT=8 ;
2047 ### Data of table `0_security_roles` ###
2049 INSERT INTO `0_security_roles` VALUES ('2', 'System Admin', 'Full system access', '256;512;768;1024;1280;1536;1792', '257;258;259;260;261;262;263;264;267;268;269;270;271;272;277;278;279;280;513;523;524;525;526;527;533;534;535;536;769;770;771;772;773;774;775;776;777;779;780;789;790;791;799;800;801;1025;1026;1035;1036;1045;1046;1047;1281;1291;1301;1302;1303;1537;1538;1539;1540;1541;1542;1543;1547;1548;1549;1550;1551;1552;1557;1558;1559;1793;1794;1795;1796;1797;1798;1799;1800;1801;1802;1803;1804;1805;1806;1807;1808;1809;1810', '0');
2050 INSERT INTO `0_security_roles` VALUES ('7', 'Accountant', 'Accounting features and most non-admin options', '256;512;768;1024;1280;1536;1792', '257;258;263;264;267;268;269;270;271;272;277;278;279;280;513;523;524;525;526;527;533;534;535;536;769;770;771;772;773;774;775;776;777;779;780;789;790;791;799;800;801;1026;1045;1046;1047;1291;1301;1302;1538;1547;1548;1549;1550;1552;1557;1558;1559;1796;1804;1805', '0');
2051 INSERT INTO `0_security_roles` VALUES ('6', 'Sub Admin', 'Near full system access', '256;512;768;1024;1280;1536;1792', '257;258;263;264;267;268;269;270;271;272;277;278;279;280;513;523;524;525;526;527;533;534;535;536;769;770;771;772;773;774;775;776;777;779;780;789;790;791;799;800;801;1026;1045;1046;1047;1291;1301;1302;1538;1547;1548;1549;1550;1552;1557;1558;1559;1796;1804;1805', '0');