2 -- version 2.11.8.1deb5
3 -- http://www.phpmyadmin.net
6 -- Generation Time: May 11, 2010 at 11:32 PM
7 -- Server version: 5.0.51
8 -- PHP Version: 5.2.6-1+lenny2
14 -- --------------------------------------------------------
17 -- Table structure for table `0_areas`
20 DROP TABLE IF EXISTS `0_areas`;
21 CREATE TABLE IF NOT EXISTS `0_areas` (
22 `area_code` int(11) NOT NULL auto_increment,
23 `description` varchar(60) NOT NULL default '',
24 `inactive` tinyint(1) NOT NULL default '0',
25 PRIMARY KEY (`area_code`),
26 UNIQUE KEY `description` (`description`)
27 ) ENGINE=MyISAM AUTO_INCREMENT=2 ;
30 -- Dumping data for table `0_areas`
33 INSERT INTO `0_areas` VALUES(1, 'Global', 0);
35 -- --------------------------------------------------------
38 -- Table structure for table `0_attachments`
41 DROP TABLE IF EXISTS `0_attachments`;
42 CREATE TABLE IF NOT EXISTS `0_attachments` (
43 `id` int(11) unsigned NOT NULL auto_increment,
44 `description` varchar(60) NOT NULL default '',
45 `type_no` int(11) NOT NULL default '0',
46 `trans_no` int(11) NOT NULL default '0',
47 `unique_name` varchar(60) NOT NULL default '',
48 `tran_date` date NOT NULL default '0000-00-00',
49 `filename` varchar(60) NOT NULL default '',
50 `filesize` int(11) NOT NULL default '0',
51 `filetype` varchar(60) NOT NULL default '',
53 KEY `type_no` (`type_no`,`trans_no`)
54 ) ENGINE=MyISAM AUTO_INCREMENT=1 ;
57 -- Dumping data for table `0_attachments`
61 -- --------------------------------------------------------
64 -- Table structure for table `0_audit_trail`
67 DROP TABLE IF EXISTS `0_audit_trail`;
68 CREATE TABLE IF NOT EXISTS `0_audit_trail` (
69 `id` int(11) NOT NULL auto_increment,
70 `type` smallint(6) unsigned NOT NULL default '0',
71 `trans_no` int(11) unsigned NOT NULL default '0',
72 `user` smallint(6) unsigned NOT NULL default '0',
73 `stamp` timestamp NOT NULL,
74 `description` varchar(60) default NULL,
75 `fiscal_year` int(11) NOT NULL,
76 `gl_date` date NOT NULL default '0000-00-00',
77 `gl_seq` int(11) unsigned default NULL,
79 KEY `Seq` (`fiscal_year`,`gl_date`,`gl_seq`),
80 KEY `Type_and_Number` (`type`,`trans_no`)
81 ) ENGINE=InnoDB AUTO_INCREMENT=1 ;
84 -- Dumping data for table `0_audit_trail`
88 -- --------------------------------------------------------
91 -- Table structure for table `0_bank_accounts`
94 DROP TABLE IF EXISTS `0_bank_accounts`;
95 CREATE TABLE IF NOT EXISTS `0_bank_accounts` (
96 `account_code` varchar(15) NOT NULL default '',
97 `account_type` smallint(6) NOT NULL default '0',
98 `bank_account_name` varchar(60) NOT NULL default '',
99 `bank_account_number` varchar(100) NOT NULL default '',
100 `bank_name` varchar(60) NOT NULL default '',
101 `bank_address` tinytext,
102 `bank_curr_code` char(3) NOT NULL default '',
103 `dflt_curr_act` tinyint(1) NOT NULL default '0',
104 `id` smallint(6) NOT NULL auto_increment,
105 `bank_charge_act` varchar(15) NOT NULL default '',
106 `last_reconciled_date` timestamp NOT NULL default '0000-00-00 00:00:00',
107 `ending_reconcile_balance` double NOT NULL default '0',
108 `inactive` tinyint(1) NOT NULL default '0',
110 KEY `bank_account_name` (`bank_account_name`),
111 KEY `bank_account_number` (`bank_account_number`),
112 KEY `account_code` (`account_code`)
113 ) ENGINE=MyISAM AUTO_INCREMENT=3 ;
116 -- Dumping data for table `0_bank_accounts`
119 INSERT INTO `0_bank_accounts` VALUES('1060', 0, 'Current account', '9999999999', 'Wachovia Bank', '', 'USD', 1, 1, '5690', '0000-00-00 00:00:00', 0, 0);
120 INSERT INTO `0_bank_accounts` VALUES('1065', 3, 'Petty Cash account', 'N/A', 'N/A', '', 'USD', 0, 2, '5690', '0000-00-00 00:00:00', 0, 0);
122 -- --------------------------------------------------------
125 -- Table structure for table `0_bank_trans`
128 DROP TABLE IF EXISTS `0_bank_trans`;
129 CREATE TABLE IF NOT EXISTS `0_bank_trans` (
130 `id` int(11) NOT NULL auto_increment,
131 `type` smallint(6) default NULL,
132 `trans_no` int(11) default NULL,
133 `bank_act` varchar(15) NOT NULL default '',
134 `ref` varchar(40) default NULL,
135 `trans_date` date NOT NULL default '0000-00-00',
136 `amount` double default NULL,
137 `dimension_id` int(11) NOT NULL default '0',
138 `dimension2_id` int(11) NOT NULL default '0',
139 `person_type_id` int(11) NOT NULL default '0',
140 `person_id` tinyblob,
141 `reconciled` date default NULL,
143 KEY `bank_act` (`bank_act`,`ref`),
144 KEY `type` (`type`,`trans_no`),
145 KEY `bank_act_2` (`bank_act`,`reconciled`),
146 KEY `bank_act_3` (`bank_act`,`trans_date`)
147 ) ENGINE=InnoDB AUTO_INCREMENT=12 ;
150 -- Dumping data for table `0_bank_trans`
153 INSERT INTO `0_bank_trans` VALUES(1, 22, 4, '1', '1', '2009-06-21', -3465, 0, 0, 3, '2', NULL);
154 INSERT INTO `0_bank_trans` VALUES(2, 26, 1, '1', '', '2009-06-21', -10, 0, 0, 1, '1', NULL);
155 INSERT INTO `0_bank_trans` VALUES(3, 26, 1, '1', '', '2009-06-21', -20, 0, 0, 1, '0', NULL);
156 INSERT INTO `0_bank_trans` VALUES(4, 0, 18, '1', '1', '2009-02-20', 1000, 0, 0, 0, '', NULL);
157 INSERT INTO `0_bank_trans` VALUES(5, 0, 19, '1', '2', '2009-02-21', 4000, 0, 0, 0, '', NULL);
158 INSERT INTO `0_bank_trans` VALUES(6, 2, 5, '1', '1', '2009-06-21', 100, 0, 0, 4, '3', NULL);
159 INSERT INTO `0_bank_trans` VALUES(7, 1, 8, '1', '1', '2009-06-21', -50, 0, 0, 4, '1', NULL);
160 INSERT INTO `0_bank_trans` VALUES(8, 26, 5, '1', '', '2009-06-21', -10, 0, 0, 1, '1', NULL);
161 INSERT INTO `0_bank_trans` VALUES(9, 26, 5, '1', '', '2009-06-21', -20, 0, 0, 1, '0', NULL);
162 INSERT INTO `0_bank_trans` VALUES(10, 26, 7, '1', '', '2009-06-21', -10, 0, 0, 1, '1', NULL);
163 INSERT INTO `0_bank_trans` VALUES(11, 26, 7, '1', '', '2009-06-21', -20, 0, 0, 1, '0', NULL);
165 -- --------------------------------------------------------
168 -- Table structure for table `0_bom`
171 DROP TABLE IF EXISTS `0_bom`;
172 CREATE TABLE IF NOT EXISTS `0_bom` (
173 `id` int(11) NOT NULL auto_increment,
174 `parent` char(20) NOT NULL default '',
175 `component` char(20) NOT NULL default '',
176 `workcentre_added` int(11) NOT NULL default '0',
177 `loc_code` char(5) NOT NULL default '',
178 `quantity` double NOT NULL default '1',
179 PRIMARY KEY (`parent`,`component`,`workcentre_added`,`loc_code`),
180 KEY `component` (`component`),
182 KEY `loc_code` (`loc_code`),
183 KEY `parent` (`parent`,`loc_code`),
184 KEY `workcentre_added` (`workcentre_added`)
185 ) ENGINE=MyISAM AUTO_INCREMENT=4 ;
188 -- Dumping data for table `0_bom`
191 INSERT INTO `0_bom` VALUES(1, '3400', '102', 1, 'DEF', 1);
192 INSERT INTO `0_bom` VALUES(2, '3400', '103', 1, 'DEF', 1);
193 INSERT INTO `0_bom` VALUES(3, '3400', '104', 1, 'DEF', 1);
195 -- --------------------------------------------------------
198 -- Table structure for table `0_budget_trans`
201 DROP TABLE IF EXISTS `0_budget_trans`;
202 CREATE TABLE IF NOT EXISTS `0_budget_trans` (
203 `counter` int(11) NOT NULL auto_increment,
204 `type` smallint(6) NOT NULL default '0',
205 `type_no` bigint(16) NOT NULL default '1',
206 `tran_date` date NOT NULL default '0000-00-00',
207 `account` varchar(15) NOT NULL default '',
208 `memo_` tinytext NOT NULL,
209 `amount` double NOT NULL default '0',
210 `dimension_id` int(11) default '0',
211 `dimension2_id` int(11) default '0',
212 `person_type_id` int(11) default NULL,
213 `person_id` tinyblob,
214 PRIMARY KEY (`counter`),
215 KEY `Type_and_Number` (`type`,`type_no`),
216 KEY `Account` (`account`,`tran_date`,`dimension_id`,`dimension2_id`)
217 ) ENGINE=InnoDB AUTO_INCREMENT=1 ;
220 -- Dumping data for table `0_budget_trans`
224 -- --------------------------------------------------------
227 -- Table structure for table `0_chart_class`
230 DROP TABLE IF EXISTS `0_chart_class`;
231 CREATE TABLE IF NOT EXISTS `0_chart_class` (
232 `cid` varchar(3) NOT NULL,
233 `class_name` varchar(60) NOT NULL default '',
234 `ctype` tinyint(1) NOT NULL default '0',
235 `inactive` tinyint(1) NOT NULL default '0',
240 -- Dumping data for table `0_chart_class`
243 INSERT INTO `0_chart_class` VALUES('1', 'Assets', 1, 0);
244 INSERT INTO `0_chart_class` VALUES('2', 'Liabilities', 2, 0);
245 INSERT INTO `0_chart_class` VALUES('3', 'Income', 4, 0);
246 INSERT INTO `0_chart_class` VALUES('4', 'Costs', 6, 0);
248 -- --------------------------------------------------------
251 -- Table structure for table `0_chart_master`
254 DROP TABLE IF EXISTS `0_chart_master`;
255 CREATE TABLE IF NOT EXISTS `0_chart_master` (
256 `account_code` varchar(15) NOT NULL default '',
257 `account_code2` varchar(15) NOT NULL default '',
258 `account_name` varchar(60) NOT NULL default '',
259 `account_type` varchar(10) NOT NULL default '0',
260 `inactive` tinyint(1) NOT NULL default '0',
261 PRIMARY KEY (`account_code`),
262 KEY `account_name` (`account_name`),
263 KEY `accounts_by_type` (`account_type`,`account_code`)
267 -- Dumping data for table `0_chart_master`
270 INSERT INTO `0_chart_master` VALUES('1060', '', 'Checking Account', '1', 0);
271 INSERT INTO `0_chart_master` VALUES('1065', '', 'Petty Cash', '1', 0);
272 INSERT INTO `0_chart_master` VALUES('1200', '', 'Accounts Receivables', '1', 0);
273 INSERT INTO `0_chart_master` VALUES('1205', '', 'Allowance for doubtful accounts', '1', 0);
274 INSERT INTO `0_chart_master` VALUES('1510', '', 'Inventory', '2', 0);
275 INSERT INTO `0_chart_master` VALUES('1520', '', 'Stocks of Raw Materials', '2', 0);
276 INSERT INTO `0_chart_master` VALUES('1530', '', 'Stocks of Work In Progress', '2', 0);
277 INSERT INTO `0_chart_master` VALUES('1540', '', 'Stocks of Finsihed Goods', '2', 0);
278 INSERT INTO `0_chart_master` VALUES('1550', '', 'Goods Received Clearing account', '2', 0);
279 INSERT INTO `0_chart_master` VALUES('1820', '', 'Office Furniture & Equipment', '3', 0);
280 INSERT INTO `0_chart_master` VALUES('1825', '', 'Accum. Amort. -Furn. & Equip.', '3', 0);
281 INSERT INTO `0_chart_master` VALUES('1840', '', 'Vehicle', '3', 0);
282 INSERT INTO `0_chart_master` VALUES('1845', '', 'Accum. Amort. -Vehicle', '3', 0);
283 INSERT INTO `0_chart_master` VALUES('2100', '', 'Accounts Payable', '4', 0);
284 INSERT INTO `0_chart_master` VALUES('2110', '', 'Accrued Income Tax - Federal', '4', 0);
285 INSERT INTO `0_chart_master` VALUES('2120', '', 'Accrued Income Tax - State', '4', 0);
286 INSERT INTO `0_chart_master` VALUES('2130', '', 'Accrued Franchise Tax', '4', 0);
287 INSERT INTO `0_chart_master` VALUES('2140', '', 'Accrued Real & Personal Prop Tax', '4', 0);
288 INSERT INTO `0_chart_master` VALUES('2150', '', 'Sales Tax', '4', 0);
289 INSERT INTO `0_chart_master` VALUES('2160', '', 'Accrued Use Tax Payable', '4', 0);
290 INSERT INTO `0_chart_master` VALUES('2210', '', 'Accrued Wages', '4', 0);
291 INSERT INTO `0_chart_master` VALUES('2220', '', 'Accrued Comp Time', '4', 0);
292 INSERT INTO `0_chart_master` VALUES('2230', '', 'Accrued Holiday Pay', '4', 0);
293 INSERT INTO `0_chart_master` VALUES('2240', '', 'Accrued Vacation Pay', '4', 0);
294 INSERT INTO `0_chart_master` VALUES('2310', '', 'Accr. Benefits - 401K', '4', 0);
295 INSERT INTO `0_chart_master` VALUES('2320', '', 'Accr. Benefits - Stock Purchase', '4', 0);
296 INSERT INTO `0_chart_master` VALUES('2330', '', 'Accr. Benefits - Med, Den', '4', 0);
297 INSERT INTO `0_chart_master` VALUES('2340', '', 'Accr. Benefits - Payroll Taxes', '4', 0);
298 INSERT INTO `0_chart_master` VALUES('2350', '', 'Accr. Benefits - Credit Union', '4', 0);
299 INSERT INTO `0_chart_master` VALUES('2360', '', 'Accr. Benefits - Savings Bond', '4', 0);
300 INSERT INTO `0_chart_master` VALUES('2370', '', 'Accr. Benefits - Garnish', '4', 0);
301 INSERT INTO `0_chart_master` VALUES('2380', '', 'Accr. Benefits - Charity Cont.', '4', 0);
302 INSERT INTO `0_chart_master` VALUES('2620', '', 'Bank Loans', '5', 0);
303 INSERT INTO `0_chart_master` VALUES('2680', '', 'Loans from Shareholders', '5', 0);
304 INSERT INTO `0_chart_master` VALUES('3350', '', 'Common Shares', '6', 0);
305 INSERT INTO `0_chart_master` VALUES('3590', '', 'Retained Earnings - prior years', '7', 0);
306 INSERT INTO `0_chart_master` VALUES('4010', '', 'Sales', '8', 0);
307 INSERT INTO `0_chart_master` VALUES('4430', '', 'Shipping & Handling', '9', 0);
308 INSERT INTO `0_chart_master` VALUES('4440', '', 'Interest', '9', 0);
309 INSERT INTO `0_chart_master` VALUES('4450', '', 'Foreign Exchange Gain', '9', 0);
310 INSERT INTO `0_chart_master` VALUES('4500', '', 'Prompt Payment Discounts', '9', 0);
311 INSERT INTO `0_chart_master` VALUES('4510', '', 'Discounts Given', '9', 0);
312 INSERT INTO `0_chart_master` VALUES('5010', '', 'Cost of Goods Sold - Retail', '10', 0);
313 INSERT INTO `0_chart_master` VALUES('5020', '', 'Material Usage Varaiance', '10', 0);
314 INSERT INTO `0_chart_master` VALUES('5030', '', 'Consumable Materials', '10', 0);
315 INSERT INTO `0_chart_master` VALUES('5040', '', 'Purchase price Variance', '10', 0);
316 INSERT INTO `0_chart_master` VALUES('5050', '', 'Purchases of materials', '10', 0);
317 INSERT INTO `0_chart_master` VALUES('5060', '', 'Discounts Received', '10', 0);
318 INSERT INTO `0_chart_master` VALUES('5100', '', 'Freight', '10', 0);
319 INSERT INTO `0_chart_master` VALUES('5410', '', 'Wages & Salaries', '11', 0);
320 INSERT INTO `0_chart_master` VALUES('5420', '', 'Wages - Overtime', '11', 0);
321 INSERT INTO `0_chart_master` VALUES('5430', '', 'Benefits - Comp Time', '11', 0);
322 INSERT INTO `0_chart_master` VALUES('5440', '', 'Benefits - Payroll Taxes', '11', 0);
323 INSERT INTO `0_chart_master` VALUES('5450', '', 'Benefits - Workers Comp', '11', 0);
324 INSERT INTO `0_chart_master` VALUES('5460', '', 'Benefits - Pension', '11', 0);
325 INSERT INTO `0_chart_master` VALUES('5470', '', 'Benefits - General Benefits', '11', 0);
326 INSERT INTO `0_chart_master` VALUES('5510', '', 'Inc Tax Exp - Federal', '11', 0);
327 INSERT INTO `0_chart_master` VALUES('5520', '', 'Inc Tax Exp - State', '11', 0);
328 INSERT INTO `0_chart_master` VALUES('5530', '', 'Taxes - Real Estate', '11', 0);
329 INSERT INTO `0_chart_master` VALUES('5540', '', 'Taxes - Personal Property', '11', 0);
330 INSERT INTO `0_chart_master` VALUES('5550', '', 'Taxes - Franchise', '11', 0);
331 INSERT INTO `0_chart_master` VALUES('5560', '', 'Taxes - Foreign Withholding', '11', 0);
332 INSERT INTO `0_chart_master` VALUES('5610', '', 'Accounting & Legal', '12', 0);
333 INSERT INTO `0_chart_master` VALUES('5615', '', 'Advertising & Promotions', '12', 0);
334 INSERT INTO `0_chart_master` VALUES('5620', '', 'Bad Debts', '12', 0);
335 INSERT INTO `0_chart_master` VALUES('5660', '', 'Amortization Expense', '12', 0);
336 INSERT INTO `0_chart_master` VALUES('5685', '', 'Insurance', '12', 0);
337 INSERT INTO `0_chart_master` VALUES('5690', '', 'Interest & Bank Charges', '12', 0);
338 INSERT INTO `0_chart_master` VALUES('5700', '', 'Office Supplies', '12', 0);
339 INSERT INTO `0_chart_master` VALUES('5760', '', 'Rent', '12', 0);
340 INSERT INTO `0_chart_master` VALUES('5765', '', 'Repair & Maintenance', '12', 0);
341 INSERT INTO `0_chart_master` VALUES('5780', '', 'Telephone', '12', 0);
342 INSERT INTO `0_chart_master` VALUES('5785', '', 'Travel & Entertainment', '12', 0);
343 INSERT INTO `0_chart_master` VALUES('5790', '', 'Utilities', '12', 0);
344 INSERT INTO `0_chart_master` VALUES('5795', '', 'Registrations', '12', 0);
345 INSERT INTO `0_chart_master` VALUES('5800', '', 'Licenses', '12', 0);
346 INSERT INTO `0_chart_master` VALUES('5810', '', 'Foreign Exchange Loss', '12', 0);
347 INSERT INTO `0_chart_master` VALUES('9990', '', 'Year Profit/Loss', '12', 0);
349 -- --------------------------------------------------------
352 -- Table structure for table `0_chart_types`
355 DROP TABLE IF EXISTS `0_chart_types`;
356 CREATE TABLE IF NOT EXISTS `0_chart_types` (
357 `id` varchar(10) NOT NULL,
358 `name` varchar(60) NOT NULL default '',
359 `class_id` varchar(3) NOT NULL default '',
360 `parent` varchar(10) NOT NULL default '-1',
361 `inactive` tinyint(1) NOT NULL default '0',
364 KEY `class_id` (`class_id`)
368 -- Dumping data for table `0_chart_types`
371 INSERT INTO `0_chart_types` VALUES('1', 'Current Assets', '1', '', 0);
372 INSERT INTO `0_chart_types` VALUES('2', 'Inventory Assets', '1', '', 0);
373 INSERT INTO `0_chart_types` VALUES('3', 'Capital Assets', '1', '', 0);
374 INSERT INTO `0_chart_types` VALUES('4', 'Current Liabilities', '2', '', 0);
375 INSERT INTO `0_chart_types` VALUES('5', 'Long Term Liabilities', '2', '', 0);
376 INSERT INTO `0_chart_types` VALUES('6', 'Share Capital', '2', '', 0);
377 INSERT INTO `0_chart_types` VALUES('7', 'Retained Earnings', '2', '', 0);
378 INSERT INTO `0_chart_types` VALUES('8', 'Sales Revenue', '3', '', 0);
379 INSERT INTO `0_chart_types` VALUES('9', 'Other Revenue', '3', '', 0);
380 INSERT INTO `0_chart_types` VALUES('10', 'Cost of Goods Sold', '4', '', 0);
381 INSERT INTO `0_chart_types` VALUES('11', 'Payroll Expenses', '4', '', 0);
382 INSERT INTO `0_chart_types` VALUES('12', 'General & Administrative expenses', '4', '', 0);
384 -- --------------------------------------------------------
387 -- Table structure for table `0_comments`
390 DROP TABLE IF EXISTS `0_comments`;
391 CREATE TABLE IF NOT EXISTS `0_comments` (
392 `type` int(11) NOT NULL default '0',
393 `id` int(11) NOT NULL default '0',
394 `date_` date default '0000-00-00',
396 KEY `type_and_id` (`type`,`id`)
400 -- Dumping data for table `0_comments`
404 -- --------------------------------------------------------
407 -- Table structure for table `0_credit_status`
410 DROP TABLE IF EXISTS `0_credit_status`;
411 CREATE TABLE IF NOT EXISTS `0_credit_status` (
412 `id` int(11) NOT NULL auto_increment,
413 `reason_description` char(100) NOT NULL default '',
414 `dissallow_invoices` tinyint(1) NOT NULL default '0',
415 `inactive` tinyint(1) NOT NULL default '0',
417 UNIQUE KEY `reason_description` (`reason_description`)
418 ) ENGINE=MyISAM AUTO_INCREMENT=5 ;
421 -- Dumping data for table `0_credit_status`
424 INSERT INTO `0_credit_status` VALUES(1, 'Good History', 0, 0);
425 INSERT INTO `0_credit_status` VALUES(3, 'No more work until payment received', 1, 0);
426 INSERT INTO `0_credit_status` VALUES(4, 'In liquidation', 1, 0);
428 -- --------------------------------------------------------
431 -- Table structure for table `0_crm_categories`
434 DROP TABLE IF EXISTS `0_crm_categories`;
435 CREATE TABLE IF NOT EXISTS `0_crm_categories` (
436 `id` int(11) NOT NULL auto_increment COMMENT 'pure technical key',
437 `type` varchar(20) NOT NULL COMMENT 'contact type e.g. customer',
438 `action` varchar(20) NOT NULL COMMENT 'detailed usage e.g. department',
439 `name` varchar(30) NOT NULL COMMENT 'for category selector',
440 `description` tinytext NOT NULL COMMENT 'usage description',
441 `system` tinyint(1) NOT NULL default '0' COMMENT 'nonzero for core system usage',
442 `inactive` tinyint(1) NOT NULL default '0',
444 UNIQUE KEY `type` (`type`,`action`),
445 UNIQUE KEY `type_2` (`type`,`name`)
446 ) ENGINE=InnoDB AUTO_INCREMENT=13 ;
449 -- Dumping data for table `0_crm_categories`
452 INSERT INTO `0_crm_categories` VALUES(1, 'cust_branch', 'general', 'General', 'General contact data for customer branch (overrides company setting)', 1, 0);
453 INSERT INTO `0_crm_categories` VALUES(2, 'cust_branch', 'invoice', 'Invoices', 'Invoice posting (overrides company setting)', 1, 0);
454 INSERT INTO `0_crm_categories` VALUES(3, 'cust_branch', 'order', 'Orders', 'Order confirmation (overrides company setting)', 1, 0);
455 INSERT INTO `0_crm_categories` VALUES(4, 'cust_branch', 'delivery', 'Deliveries', 'Delivery coordination (overrides company setting)', 1, 0);
456 INSERT INTO `0_crm_categories` VALUES(5, 'customer', 'general', 'General', 'General contact data for customer', 1, 0);
457 INSERT INTO `0_crm_categories` VALUES(6, 'customer', 'order', 'Orders', 'Order confirmation', 1, 0);
458 INSERT INTO `0_crm_categories` VALUES(7, 'customer', 'delivery', 'Deliveries', 'Delivery coordination', 1, 0);
459 INSERT INTO `0_crm_categories` VALUES(8, 'customer', 'invoice', 'Invoices', 'Invoice posting', 1, 0);
460 INSERT INTO `0_crm_categories` VALUES(9, 'supplier', 'general', 'General', 'General contact data for supplier', 1, 0);
461 INSERT INTO `0_crm_categories` VALUES(10, 'supplier', 'order', 'Orders', 'Order confirmation', 1, 0);
462 INSERT INTO `0_crm_categories` VALUES(11, 'supplier', 'delivery', 'Deliveries', 'Delivery coordination', 1, 0);
463 INSERT INTO `0_crm_categories` VALUES(12, 'supplier', 'invoice', 'Invoices', 'Invoice posting', 1, 0);
465 -- --------------------------------------------------------
468 -- Table structure for table `0_crm_contacts`
471 DROP TABLE IF EXISTS `0_crm_contacts`;
472 CREATE TABLE IF NOT EXISTS `0_crm_contacts` (
473 `id` int(11) NOT NULL auto_increment,
474 `person_id` int(11) NOT NULL default '0' COMMENT 'foreign key to crm_contacts',
475 `type` varchar(20) NOT NULL COMMENT 'foreign key to crm_categories',
476 `action` varchar(20) NOT NULL COMMENT 'foreign key to crm_categories',
477 `entity_id` varchar(11) default NULL COMMENT 'entity id in related class table',
479 KEY `type` (`type`,`action`)
480 ) ENGINE=InnoDB AUTO_INCREMENT=10 ;
483 -- Dumping data for table `0_crm_contacts`
486 INSERT INTO `0_crm_contacts` VALUES(1, 1, 'customer', 'general', '1');
487 INSERT INTO `0_crm_contacts` VALUES(2, 2, 'customer', 'general', '2');
488 INSERT INTO `0_crm_contacts` VALUES(3, 3, 'customer', 'general', '3');
489 INSERT INTO `0_crm_contacts` VALUES(4, 4, 'cust_branch', 'general', '1');
490 INSERT INTO `0_crm_contacts` VALUES(5, 5, 'cust_branch', 'general', '2');
491 INSERT INTO `0_crm_contacts` VALUES(6, 6, 'cust_branch', 'general', '3');
492 INSERT INTO `0_crm_contacts` VALUES(7, 7, 'supplier', 'general', '1');
493 INSERT INTO `0_crm_contacts` VALUES(8, 8, 'supplier', 'general', '2');
494 INSERT INTO `0_crm_contacts` VALUES(9, 9, 'supplier', 'general', '3');
496 -- --------------------------------------------------------
499 -- Table structure for table `0_crm_persons`
502 DROP TABLE IF EXISTS `0_crm_persons`;
503 CREATE TABLE IF NOT EXISTS `0_crm_persons` (
504 `id` int(11) NOT NULL auto_increment,
505 `ref` varchar(30) NOT NULL,
506 `name` varchar(60) NOT NULL,
507 `name2` varchar(60) default NULL,
509 `phone` varchar(30) default NULL,
510 `phone2` varchar(30) default NULL,
511 `fax` varchar(30) default NULL,
512 `email` varchar(100) default NULL,
513 `lang` char(5) default NULL,
514 `notes` tinytext NOT NULL,
515 `inactive` tinyint(1) NOT NULL default '0',
518 ) ENGINE=InnoDB AUTO_INCREMENT=10 ;
521 -- Dumping data for table `0_crm_persons`
524 INSERT INTO `0_crm_persons` VALUES(1, 'Beefeater', '', NULL, NULL, NULL, NULL, NULL, '', 'C', '', 0);
525 INSERT INTO `0_crm_persons` VALUES(2, 'Ghostbusters', '', NULL, NULL, NULL, NULL, NULL, '', NULL, '', 0);
526 INSERT INTO `0_crm_persons` VALUES(3, 'Brezan', '', NULL, NULL, NULL, NULL, NULL, '', 'C', '', 0);
527 INSERT INTO `0_crm_persons` VALUES(4, 'Beefeater', 'Main Branch', NULL, '', '', '', '', '', NULL, '', 0);
528 INSERT INTO `0_crm_persons` VALUES(5, 'Ghostbusters', 'Main Branch', NULL, 'Address 1\nAddress 2\nAddress 3', '', '', '', '', NULL, '', 0);
529 INSERT INTO `0_crm_persons` VALUES(6, 'Brezan', 'Main Branch', NULL, 'Address 1\nAddress 2\nAddress 3', '', '', '', '', NULL, '', 0);
530 INSERT INTO `0_crm_persons` VALUES(7, 'Junk Beer', 'Contact', NULL, 'Address 1\nAddress 2\nAddress 3', '+45 55667788', '', '', '', 'C', '', 0);
531 INSERT INTO `0_crm_persons` VALUES(8, 'Lucky Luke', 'Luke', NULL, 'Address 1\nAddress 2\nAddress 3', '(111) 222.333.444', '', '', '', NULL, '', 0);
532 INSERT INTO `0_crm_persons` VALUES(9, 'Money Makers', 'Makers', NULL, 'Address 1\nAddress 2\nAddress 3', '+44 444 555 666', '', '', '', 'C', '', 0);
534 -- --------------------------------------------------------
537 -- Table structure for table `0_currencies`
540 DROP TABLE IF EXISTS `0_currencies`;
541 CREATE TABLE IF NOT EXISTS `0_currencies` (
542 `currency` varchar(60) NOT NULL default '',
543 `curr_abrev` char(3) NOT NULL default '',
544 `curr_symbol` varchar(10) NOT NULL default '',
545 `country` varchar(100) NOT NULL default '',
546 `hundreds_name` varchar(15) NOT NULL default '',
547 `auto_update` tinyint(1) NOT NULL default '1',
548 `inactive` tinyint(1) NOT NULL default '0',
549 PRIMARY KEY (`curr_abrev`)
553 -- Dumping data for table `0_currencies`
556 INSERT INTO `0_currencies` VALUES('US Dollars', 'USD', '$', 'United States', 'Cents', 1, 0);
557 INSERT INTO `0_currencies` VALUES('CA Dollars', 'CAD', '$', 'Canada', 'Cents', 1, 0);
558 INSERT INTO `0_currencies` VALUES('Euro', 'EUR', '?', 'Europe', 'Cents', 1, 0);
559 INSERT INTO `0_currencies` VALUES('Pounds', 'GBP', '?', 'England', 'Pence', 1, 0);
560 INSERT INTO `0_currencies` VALUES('DK Kroner', 'DKK', '?', 'Denmark', 'Ore', 1, 0);
562 -- --------------------------------------------------------
565 -- Table structure for table `0_cust_allocations`
568 DROP TABLE IF EXISTS `0_cust_allocations`;
569 CREATE TABLE IF NOT EXISTS `0_cust_allocations` (
570 `id` int(11) NOT NULL auto_increment,
571 `amt` double unsigned default NULL,
572 `date_alloc` date NOT NULL default '0000-00-00',
573 `trans_no_from` int(11) default NULL,
574 `trans_type_from` int(11) default NULL,
575 `trans_no_to` int(11) default NULL,
576 `trans_type_to` int(11) default NULL,
578 KEY `From` (`trans_type_from`,`trans_no_from`),
579 KEY `To` (`trans_type_to`,`trans_no_to`)
580 ) ENGINE=InnoDB AUTO_INCREMENT=2 ;
583 -- Dumping data for table `0_cust_allocations`
586 INSERT INTO `0_cust_allocations` VALUES(1, 37.68, '2009-06-21', 3, 11, 18, 10);
588 -- --------------------------------------------------------
591 -- Table structure for table `0_cust_branch`
594 DROP TABLE IF EXISTS `0_cust_branch`;
595 CREATE TABLE IF NOT EXISTS `0_cust_branch` (
596 `branch_code` int(11) NOT NULL auto_increment,
597 `debtor_no` int(11) NOT NULL default '0',
598 `br_name` varchar(60) NOT NULL default '',
599 `branch_ref` varchar(30) NOT NULL default '',
600 `br_address` tinytext NOT NULL,
601 `area` int(11) default NULL,
602 `salesman` int(11) NOT NULL default '0',
603 `contact_name` varchar(60) NOT NULL default '',
604 `default_location` varchar(5) NOT NULL default '',
605 `tax_group_id` int(11) default NULL,
606 `sales_account` varchar(15) NOT NULL default '',
607 `sales_discount_account` varchar(15) NOT NULL default '',
608 `receivables_account` varchar(15) NOT NULL default '',
609 `payment_discount_account` varchar(15) NOT NULL default '',
610 `default_ship_via` int(11) NOT NULL default '1',
611 `disable_trans` tinyint(4) NOT NULL default '0',
612 `br_post_address` tinytext NOT NULL,
613 `group_no` int(11) NOT NULL default '0',
614 `notes` tinytext NOT NULL,
615 `bank_account` varchar(60) DEFAULT NULL,
616 `inactive` tinyint(1) NOT NULL default '0',
617 PRIMARY KEY (`branch_code`,`debtor_no`),
618 KEY `branch_code` (`branch_code`),
619 KEY `branch_ref` (`branch_ref`),
620 KEY `group_no` (`group_no`)
621 ) ENGINE=MyISAM AUTO_INCREMENT=4 ;
624 -- Dumping data for table `0_cust_branch`
627 INSERT INTO `0_cust_branch` VALUES(1, 1, 'Beefeater Ltd.', 'Beefeater', '', 1, 1, 'Main Branch', 'DEF', 2, '', '4510', '1200', '4500', 1, 0, 'Address 1\nAddress 2\nAddress 3', 0, '', '', 0);
628 INSERT INTO `0_cust_branch` VALUES(2, 2, 'Ghostbusters Corp.', 'Ghostbusters', 'Address 1\nAddress 2\nAddress 3', 1, 1, 'Main Branch', 'DEF', 1, '', '4510', '1200', '4500', 1, 0, 'Address 1\nAddress 2\nAddress 3', 0, '','', 0);
629 INSERT INTO `0_cust_branch` VALUES(3, 3, 'Brezan', 'Brezan', 'Address 1\nAddress 2\nAddress 3', 1, 1, 'Main Branch', 'DEF', 1, '', '4510', '1200', '4500', 1, 0, 'Address 1\nAddress 2\nAddress 3', 0, '', '', 0);
631 -- --------------------------------------------------------
634 -- Table structure for table `0_debtors_master`
637 DROP TABLE IF EXISTS `0_debtors_master`;
638 CREATE TABLE IF NOT EXISTS `0_debtors_master` (
639 `debtor_no` int(11) NOT NULL auto_increment,
640 `name` varchar(100) NOT NULL default '',
641 `debtor_ref` varchar(30) NOT NULL,
643 `tax_id` varchar(55) NOT NULL default '',
644 `curr_code` char(3) NOT NULL default '',
645 `sales_type` int(11) NOT NULL default '1',
646 `dimension_id` int(11) NOT NULL default '0',
647 `dimension2_id` int(11) NOT NULL default '0',
648 `credit_status` int(11) NOT NULL default '0',
649 `payment_terms` int(11) default NULL,
650 `discount` double NOT NULL default '0',
651 `pymt_discount` double NOT NULL default '0',
652 `credit_limit` float NOT NULL default '1000',
653 `notes` tinytext NOT NULL,
654 `inactive` tinyint(1) NOT NULL default '0',
655 PRIMARY KEY (`debtor_no`),
657 UNIQUE KEY `debtor_ref` (`debtor_ref`)
658 ) ENGINE=MyISAM AUTO_INCREMENT=4 ;
661 -- Dumping data for table `0_debtors_master`
664 INSERT INTO `0_debtors_master` VALUES(1, 'Beefeater Ltd.', 'Beefeater', 'Addr 1\nAddr 2\nAddr 3', '345678', 'GBP', 2, 0, 0, 1, 3, 0, 0, 1000, '', 0);
665 INSERT INTO `0_debtors_master` VALUES(2, 'Ghostbusters Corp.', 'Ghostbusters', 'Address 1\nAddress 2\nAddress 3', '2222222', 'USD', 1, 0, 0, 1, 4, 0, 0, 1000, '', 0);
666 INSERT INTO `0_debtors_master` VALUES(3, 'Brezan', 'Brezan', 'Address 1\nAddress 2\nAddress 3', '7777777', 'EUR', 2, 0, 0, 1, 3, 0, 0, 1000, '', 0);
668 -- --------------------------------------------------------
671 -- Table structure for table `0_debtor_trans`
674 DROP TABLE IF EXISTS `0_debtor_trans`;
675 CREATE TABLE IF NOT EXISTS `0_debtor_trans` (
676 `trans_no` int(11) unsigned NOT NULL default '0',
677 `type` smallint(6) unsigned NOT NULL default '0',
678 `version` tinyint(1) unsigned NOT NULL default '0',
679 `debtor_no` int(11) unsigned default NULL,
680 `branch_code` int(11) NOT NULL default '-1',
681 `tran_date` date NOT NULL default '0000-00-00',
682 `due_date` date NOT NULL default '0000-00-00',
683 `reference` varchar(60) NOT NULL default '',
684 `tpe` int(11) NOT NULL default '0',
685 `order_` int(11) NOT NULL default '0',
686 `ov_amount` double NOT NULL default '0',
687 `ov_gst` double NOT NULL default '0',
688 `ov_freight` double NOT NULL default '0',
689 `ov_freight_tax` double NOT NULL default '0',
690 `ov_discount` double NOT NULL default '0',
691 `alloc` double NOT NULL default '0',
692 `rate` double NOT NULL default '1',
693 `ship_via` int(11) default NULL,
694 `dimension_id` int(11) NOT NULL default '0',
695 `dimension2_id` int(11) NOT NULL default '0',
696 `payment_terms` int(11) default NULL,
697 `tax_included` tinyint(1) unsigned NOT NULL default '0',
698 PRIMARY KEY (`type`,`trans_no`),
699 KEY `debtor_no` (`debtor_no`,`branch_code`),
700 KEY `tran_date` (`tran_date`)
704 -- Dumping data for table `0_debtor_trans`
707 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, 0, 0, 4, 0);
708 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, 2, 0, 3, 0);
709 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, 0, 0, 4, 0);
710 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, 2, 0, 3, 0);
711 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, 3, 0);
712 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, 0, 0, 4, 0);
713 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, 2, 0, 3, 0);
714 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, 0, 0, 4, 0);
716 -- --------------------------------------------------------
719 -- Table structure for table `0_debtor_trans_details`
722 DROP TABLE IF EXISTS `0_debtor_trans_details`;
723 CREATE TABLE IF NOT EXISTS `0_debtor_trans_details` (
724 `id` int(11) NOT NULL auto_increment,
725 `debtor_trans_no` int(11) default NULL,
726 `debtor_trans_type` int(11) default NULL,
727 `stock_id` varchar(20) NOT NULL default '',
728 `description` tinytext,
729 `unit_price` double NOT NULL default '0',
730 `unit_tax` double NOT NULL default '0',
731 `quantity` double NOT NULL default '0',
732 `discount_percent` double NOT NULL default '0',
733 `standard_cost` double NOT NULL default '0',
734 `qty_done` double NOT NULL default '0',
735 `src_id` int(11) NOT NULL,
737 KEY `Transaction` (`debtor_trans_type`,`debtor_trans_no`),
739 ) ENGINE=InnoDB AUTO_INCREMENT=9 ;
742 -- Dumping data for table `0_debtor_trans_details`
745 INSERT INTO `0_debtor_trans_details` VALUES(1, 2, 13, '102', '17inch VGA Monitor', 30.4, 0, 2, 0, 10, 0, 1);
746 INSERT INTO `0_debtor_trans_details` VALUES(2, 3, 13, '102', '17inch VGA Monitor', 50, 2.5, 1, 0, 10, 1, 2);
747 INSERT INTO `0_debtor_trans_details` VALUES(3, 17, 10, '102', '17inch VGA Monitor', 50, 2.5, 1, 0, 10, 2, 2);
748 INSERT INTO `0_debtor_trans_details` VALUES(4, 4, 13, '102', '17inch VGA Monitor', 35.89, 1.79, 1, 0, 10, 1,3);
749 INSERT INTO `0_debtor_trans_details` VALUES(5, 18, 10, '102', '17inch VGA Monitor', 35.89, 1.79, 1, 0, 10, 1,4);
750 INSERT INTO `0_debtor_trans_details` VALUES(6, 5, 13, '102', '17inch VGA Monitor', 50, 2.38, 1, 0, 10, 1,5);
751 INSERT INTO `0_debtor_trans_details` VALUES(7, 19, 10, '102', '17inch VGA Monitor', 50, 2.38, 1, 0, 10, 0,6);
752 INSERT INTO `0_debtor_trans_details` VALUES(8, 3, 11, '102', '17inch VGA Monitor', 35.89, 1.79, 1, 0, 10, 0,5);
754 -- --------------------------------------------------------
757 -- Table structure for table `0_dimensions`
760 DROP TABLE IF EXISTS `0_dimensions`;
761 CREATE TABLE IF NOT EXISTS `0_dimensions` (
762 `id` int(11) NOT NULL auto_increment,
763 `reference` varchar(60) NOT NULL default '',
764 `name` varchar(60) NOT NULL default '',
765 `type_` tinyint(1) NOT NULL default '1',
766 `closed` tinyint(1) NOT NULL default '0',
767 `date_` date NOT NULL default '0000-00-00',
768 `due_date` date NOT NULL default '0000-00-00',
770 UNIQUE KEY `reference` (`reference`),
771 KEY `date_` (`date_`),
772 KEY `due_date` (`due_date`),
773 KEY `type_` (`type_`)
774 ) ENGINE=InnoDB AUTO_INCREMENT=3 ;
777 -- Dumping data for table `0_dimensions`
780 INSERT INTO `0_dimensions` VALUES(1, '1', 'Support', 1, 0, '2009-06-21', '2015-07-11');
781 INSERT INTO `0_dimensions` VALUES(2, '2', 'Development', 1, 0, '2009-06-21', '2015-07-11');
783 -- --------------------------------------------------------
786 -- Table structure for table `0_exchange_rates`
789 DROP TABLE IF EXISTS `0_exchange_rates`;
790 CREATE TABLE IF NOT EXISTS `0_exchange_rates` (
791 `id` int(11) NOT NULL auto_increment,
792 `curr_code` char(3) NOT NULL default '',
793 `rate_buy` double NOT NULL default '0',
794 `rate_sell` double NOT NULL default '0',
795 `date_` date NOT NULL default '0000-00-00',
797 UNIQUE KEY `curr_code` (`curr_code`,`date_`)
798 ) ENGINE=MyISAM AUTO_INCREMENT=4 ;
801 -- Dumping data for table `0_exchange_rates`
804 INSERT INTO `0_exchange_rates` VALUES(1, 'DKK', 0.18717252868313, 0.18717252868313, '2009-06-21');
805 INSERT INTO `0_exchange_rates` VALUES(2, 'GBP', 1.6445729799917, 1.6445729799917, '2009-06-21');
806 INSERT INTO `0_exchange_rates` VALUES(3, 'EUR', 1.3932, 1.3932, '2009-06-21');
808 -- --------------------------------------------------------
811 -- Table structure for table `0_fiscal_year`
814 DROP TABLE IF EXISTS `0_fiscal_year`;
815 CREATE TABLE IF NOT EXISTS `0_fiscal_year` (
816 `id` int(11) NOT NULL auto_increment,
817 `begin` date default '0000-00-00',
818 `end` date default '0000-00-00',
819 `closed` tinyint(1) NOT NULL default '0',
821 UNIQUE KEY `begin` (`begin`),
822 UNIQUE KEY `end` (`end`)
823 ) ENGINE=InnoDB AUTO_INCREMENT=4 ;
826 -- Dumping data for table `0_fiscal_year`
829 INSERT INTO `0_fiscal_year` VALUES(1, '2008-01-01', '2008-12-31', 1);
830 INSERT INTO `0_fiscal_year` VALUES(2, '2009-01-01', '2009-12-31', 1);
831 INSERT INTO `0_fiscal_year` VALUES(3, '2010-01-01', '2010-12-31', 0);
832 INSERT INTO `0_fiscal_year` VALUES(4, '2011-01-01', '2011-12-31', 0);
835 -- Table structure for table `0_gl_trans`
838 DROP TABLE IF EXISTS `0_gl_trans`;
839 CREATE TABLE IF NOT EXISTS `0_gl_trans` (
840 `counter` int(11) NOT NULL auto_increment,
841 `type` smallint(6) NOT NULL default '0',
842 `type_no` bigint(16) NOT NULL default '1',
843 `tran_date` date NOT NULL default '0000-00-00',
844 `account` varchar(15) NOT NULL default '',
845 `memo_` tinytext NOT NULL,
846 `amount` double NOT NULL default '0',
847 `dimension_id` int(11) NOT NULL default '0',
848 `dimension2_id` int(11) NOT NULL default '0',
849 `person_type_id` int(11) default NULL,
850 `person_id` tinyblob,
851 PRIMARY KEY (`counter`),
852 KEY `Type_and_Number` (`type`,`type_no`),
853 KEY `dimension_id` (`dimension_id`),
854 KEY `dimension2_id` (`dimension2_id`),
855 KEY `tran_date` (`tran_date`),
856 KEY `account_and_tran_date` (`account`,`tran_date`)
857 ) ENGINE=InnoDB AUTO_INCREMENT=84 ;
860 -- Dumping data for table `0_gl_trans`
863 INSERT INTO `0_gl_trans` VALUES(1, 20, 7, '2009-06-21', '2100', '', -3465, 0, 0, 3, '2');
864 INSERT INTO `0_gl_trans` VALUES(2, 20, 7, '2009-06-21', '1510', '', 1000, 0, 0, 3, '2');
865 INSERT INTO `0_gl_trans` VALUES(3, 20, 7, '2009-06-21', '1510', '', 1100, 0, 0, 3, '2');
866 INSERT INTO `0_gl_trans` VALUES(4, 20, 7, '2009-06-21', '1510', '', 1200, 0, 0, 3, '2');
867 INSERT INTO `0_gl_trans` VALUES(5, 20, 7, '2009-06-21', '2150', '', 165, 0, 0, 3, '2');
868 INSERT INTO `0_gl_trans` VALUES(6, 22, 4, '2009-06-21', '2100', '', 3465, 0, 0, 3, '2');
869 INSERT INTO `0_gl_trans` VALUES(7, 22, 4, '2009-06-21', '1060', '', -3465, 0, 0, 3, '2');
870 INSERT INTO `0_gl_trans` VALUES(8, 26, 1, '2009-06-21', '1510', '', -100, 0, 0, NULL, '');
871 INSERT INTO `0_gl_trans` VALUES(9, 26, 1, '2009-06-21', '1510', '', -110, 0, 0, NULL, '');
872 INSERT INTO `0_gl_trans` VALUES(10, 26, 1, '2009-06-21', '1510', '', -120, 0, 0, NULL, '');
873 INSERT INTO `0_gl_trans` VALUES(11, 26, 1, '2009-06-21', '1060', 'Overhead Cost', -10, 0, 0, 1, '1');
874 INSERT INTO `0_gl_trans` VALUES(12, 26, 1, '2009-06-21', '1530', 'Overhead Cost', 10, 0, 0, 1, '1');
875 INSERT INTO `0_gl_trans` VALUES(13, 26, 1, '2009-06-21', '1060', 'Labour Cost', -20, 0, 0, 1, '0');
876 INSERT INTO `0_gl_trans` VALUES(14, 26, 1, '2009-06-21', '1530', 'Labour Cost', 20, 0, 0, 1, '0');
877 INSERT INTO `0_gl_trans` VALUES(15, 26, 1, '2009-06-21', '1510', '', 330, 0, 0, NULL, '');
878 INSERT INTO `0_gl_trans` VALUES(16, 13, 2, '2009-06-21', '5010', '', 20, 0, 0, 2, '1');
879 INSERT INTO `0_gl_trans` VALUES(17, 13, 2, '2009-06-21', '1510', '', -20, 0, 0, 2, '1');
880 INSERT INTO `0_gl_trans` VALUES(18, 13, 3, '2009-06-21', '5010', '', 10, 0, 0, 2, '2');
881 INSERT INTO `0_gl_trans` VALUES(19, 13, 3, '2009-06-21', '1510', '', -10, 0, 0, 2, '2');
882 INSERT INTO `0_gl_trans` VALUES(20, 10, 17, '2009-06-21', '4010', '', -50, 0, 0, 2, '2');
883 INSERT INTO `0_gl_trans` VALUES(21, 10, 17, '2009-06-21', '1200', '', 52.5, 0, 0, 2, '2');
884 INSERT INTO `0_gl_trans` VALUES(22, 10, 17, '2009-06-21', '2150', '', -2.5, 0, 0, 2, '2');
885 INSERT INTO `0_gl_trans` VALUES(23, 13, 4, '2009-06-21', '5010', '', 10, 2, 0, 2, '3');
886 INSERT INTO `0_gl_trans` VALUES(24, 13, 4, '2009-06-21', '1510', '', -10, 0, 0, 2, '3');
887 INSERT INTO `0_gl_trans` VALUES(25, 10, 18, '2009-06-21', '4010', '', -50, 2, 0, 2, '3');
888 INSERT INTO `0_gl_trans` VALUES(26, 10, 18, '2009-06-21', '1200', '', 52.5, 0, 0, 2, '3');
889 INSERT INTO `0_gl_trans` VALUES(27, 10, 18, '2009-06-21', '2150', '', -2.5, 0, 0, 2, '3');
890 INSERT INTO `0_gl_trans` VALUES(28, 0, 18, '2009-02-20', '1060', '', 1000, 0, 0, NULL, '');
891 INSERT INTO `0_gl_trans` VALUES(29, 0, 18, '2009-02-20', '3350', '', -1000, 0, 0, NULL, '');
892 INSERT INTO `0_gl_trans` VALUES(30, 0, 19, '2009-02-21', '1060', '', 4000, 0, 0, NULL, '');
893 INSERT INTO `0_gl_trans` VALUES(31, 0, 19, '2009-02-21', '3350', '', -4000, 0, 0, NULL, '');
894 INSERT INTO `0_gl_trans` VALUES(32, 26, 3, '2009-06-21', '1510', '', -20, 0, 0, NULL, '');
895 INSERT INTO `0_gl_trans` VALUES(33, 26, 3, '2009-06-21', '1510', '', -22, 0, 0, NULL, '');
896 INSERT INTO `0_gl_trans` VALUES(34, 26, 3, '2009-06-21', '1510', '', -24, 0, 0, NULL, '');
897 INSERT INTO `0_gl_trans` VALUES(35, 26, 3, '2009-06-21', '1540', '', 66, 0, 0, NULL, '');
898 INSERT INTO `0_gl_trans` VALUES(36, 2, 5, '2009-06-21', '2150', 'Cash Sales', -4.76, 0, 0, 4, '3');
899 INSERT INTO `0_gl_trans` VALUES(37, 2, 5, '2009-06-21', '4010', 'Cash Sales', -95.24, 0, 0, 4, '3');
900 INSERT INTO `0_gl_trans` VALUES(38, 2, 5, '2009-06-21', '1060', '', 100, 0, 0, 4, '3');
901 INSERT INTO `0_gl_trans` VALUES(39, 1, 8, '2009-06-21', '2150', 'Maintenance', 2.38, 0, 0, 4, '1');
902 INSERT INTO `0_gl_trans` VALUES(40, 1, 8, '2009-06-21', '5765', 'Maintenance', 47.62, 0, 0, 4, '1');
903 INSERT INTO `0_gl_trans` VALUES(41, 1, 8, '2009-06-21', '1060', '', -50, 0, 0, 4, '1');
904 INSERT INTO `0_gl_trans` VALUES(42, 20, 8, '2009-06-21', '2100', '', -20, 0, 0, 3, '2');
905 INSERT INTO `0_gl_trans` VALUES(43, 20, 8, '2009-06-21', '2150', '', 0.95, 0, 0, 3, '2');
906 INSERT INTO `0_gl_trans` VALUES(44, 20, 8, '2009-06-21', '5780', '', 19.05, 0, 0, 3, '2');
907 INSERT INTO `0_gl_trans` VALUES(45, 26, 4, '2009-06-21', '1510', '', -40, 0, 0, NULL, '');
908 INSERT INTO `0_gl_trans` VALUES(46, 26, 4, '2009-06-21', '1510', '', -44, 0, 0, NULL, '');
909 INSERT INTO `0_gl_trans` VALUES(47, 26, 4, '2009-06-21', '1510', '', -48, 0, 0, NULL, '');
910 INSERT INTO `0_gl_trans` VALUES(48, 26, 4, '2009-06-21', '1540', '', 132, 0, 0, NULL, '');
911 INSERT INTO `0_gl_trans` VALUES(49, 26, 2, '2009-06-21', '1510', '', -20, 0, 0, NULL, '');
912 INSERT INTO `0_gl_trans` VALUES(50, 26, 2, '2009-06-21', '1510', '', -22, 0, 0, NULL, '');
913 INSERT INTO `0_gl_trans` VALUES(51, 26, 2, '2009-06-21', '1510', '', -24, 0, 0, NULL, '');
914 INSERT INTO `0_gl_trans` VALUES(52, 26, 2, '2009-06-21', '1540', '', 66, 0, 0, NULL, '');
915 INSERT INTO `0_gl_trans` VALUES(53, 26, 5, '2009-06-21', '1510', '', -50, 0, 0, NULL, '');
916 INSERT INTO `0_gl_trans` VALUES(54, 26, 5, '2009-06-21', '1510', '', -55, 0, 0, NULL, '');
917 INSERT INTO `0_gl_trans` VALUES(55, 26, 5, '2009-06-21', '1510', '', -60, 0, 0, NULL, '');
918 INSERT INTO `0_gl_trans` VALUES(56, 26, 5, '2009-06-21', '1060', 'Overhead Cost', -10, 0, 0, 1, '1');
919 INSERT INTO `0_gl_trans` VALUES(57, 26, 5, '2009-06-21', '1530', 'Overhead Cost', 10, 0, 0, 1, '1');
920 INSERT INTO `0_gl_trans` VALUES(58, 26, 5, '2009-06-21', '1060', 'Labour Cost', -20, 0, 0, 1, '0');
921 INSERT INTO `0_gl_trans` VALUES(59, 26, 5, '2009-06-21', '1530', 'Labour Cost', 20, 0, 0, 1, '0');
922 INSERT INTO `0_gl_trans` VALUES(60, 26, 5, '2009-06-21', '1540', '', 165, 0, 0, NULL, '');
923 INSERT INTO `0_gl_trans` VALUES(61, 26, 6, '2009-06-21', '1510', '', 50, 0, 0, NULL, '');
924 INSERT INTO `0_gl_trans` VALUES(62, 26, 6, '2009-06-21', '1510', '', 55, 0, 0, NULL, '');
925 INSERT INTO `0_gl_trans` VALUES(63, 26, 6, '2009-06-21', '1510', '', 60, 0, 0, NULL, '');
926 INSERT INTO `0_gl_trans` VALUES(64, 26, 6, '2009-06-21', '1540', '', -165, 0, 0, NULL, '');
927 INSERT INTO `0_gl_trans` VALUES(65, 26, 7, '2009-06-21', '1510', '', 20, 0, 0, NULL, '');
928 INSERT INTO `0_gl_trans` VALUES(66, 26, 7, '2009-06-21', '1510', '', 22, 0, 0, NULL, '');
929 INSERT INTO `0_gl_trans` VALUES(67, 26, 7, '2009-06-21', '1510', '', 24, 0, 0, NULL, '');
930 INSERT INTO `0_gl_trans` VALUES(68, 26, 7, '2009-06-21', '1060', 'Overhead Cost', -10, 0, 0, 1, '1');
931 INSERT INTO `0_gl_trans` VALUES(69, 26, 7, '2009-06-21', '1530', 'Overhead Cost', 10, 0, 0, 1, '1');
932 INSERT INTO `0_gl_trans` VALUES(70, 26, 7, '2009-06-21', '1060', 'Labour Cost', -20, 0, 0, 1, '0');
933 INSERT INTO `0_gl_trans` VALUES(71, 26, 7, '2009-06-21', '1530', 'Labour Cost', 20, 0, 0, 1, '0');
934 INSERT INTO `0_gl_trans` VALUES(72, 26, 7, '2009-06-21', '1540', '', -66, 0, 0, NULL, '');
935 INSERT INTO `0_gl_trans` VALUES(73, 13, 5, '2009-06-21', '5010', '', 10, 0, 0, 2, '2');
936 INSERT INTO `0_gl_trans` VALUES(74, 13, 5, '2009-06-21', '1510', '', -10, 0, 0, 2, '2');
937 INSERT INTO `0_gl_trans` VALUES(75, 10, 19, '2009-06-21', '4010', '', -47.62, 0, 0, 2, '2');
938 INSERT INTO `0_gl_trans` VALUES(76, 10, 19, '2009-06-21', '1200', '', 55, 0, 0, 2, '2');
939 INSERT INTO `0_gl_trans` VALUES(77, 10, 19, '2009-06-21', '4430', '', -5, 0, 0, 2, '2');
940 INSERT INTO `0_gl_trans` VALUES(78, 10, 19, '2009-06-21', '2150', '', -2.38, 0, 0, 2, '2');
941 INSERT INTO `0_gl_trans` VALUES(79, 11, 3, '2009-06-21', '5010', '', -10, 2, 0, 2, '3');
942 INSERT INTO `0_gl_trans` VALUES(80, 11, 3, '2009-06-21', '1510', '', 10, 0, 0, 2, '3');
943 INSERT INTO `0_gl_trans` VALUES(81, 11, 3, '2009-06-21', '4010', '', 50, 2, 0, 2, '3');
944 INSERT INTO `0_gl_trans` VALUES(82, 11, 3, '2009-06-21', '1200', '', -52.5, 0, 0, 2, '3');
945 INSERT INTO `0_gl_trans` VALUES(83, 11, 3, '2009-06-21', '2150', '', 2.5, 0, 0, 2, '3');
946 INSERT INTO `0_gl_trans` VALUES ('84', '0', '20', '2009-12-31', '3590', 'Closing Year', '-91.19', '0', '0', NULL, NULL);
947 INSERT INTO `0_gl_trans` VALUES ('85', '0', '20', '2009-12-31', '9990', 'Closing Year', '91.19', '0', '0', NULL, NULL);
949 -- --------------------------------------------------------
952 -- Table structure for table `0_grn_batch`
955 DROP TABLE IF EXISTS `0_grn_batch`;
956 CREATE TABLE IF NOT EXISTS `0_grn_batch` (
957 `id` int(11) NOT NULL auto_increment,
958 `supplier_id` int(11) NOT NULL default '0',
959 `purch_order_no` int(11) default NULL,
960 `reference` varchar(60) NOT NULL default '',
961 `delivery_date` date NOT NULL default '0000-00-00',
962 `loc_code` varchar(5) default NULL,
964 KEY `delivery_date` (`delivery_date`),
965 KEY `purch_order_no` (`purch_order_no`)
966 ) ENGINE=InnoDB AUTO_INCREMENT=2 ;
969 -- Dumping data for table `0_grn_batch`
972 INSERT INTO `0_grn_batch` VALUES(1, 2, 1, '1', '2009-06-21', 'DEF');
974 -- --------------------------------------------------------
977 -- Table structure for table `0_grn_items`
980 DROP TABLE IF EXISTS `0_grn_items`;
981 CREATE TABLE IF NOT EXISTS `0_grn_items` (
982 `id` int(11) NOT NULL auto_increment,
983 `grn_batch_id` int(11) default NULL,
984 `po_detail_item` int(11) NOT NULL default '0',
985 `item_code` varchar(20) NOT NULL default '',
986 `description` tinytext,
987 `qty_recd` double NOT NULL default '0',
988 `quantity_inv` double NOT NULL default '0',
990 KEY `grn_batch_id` (`grn_batch_id`)
991 ) ENGINE=InnoDB AUTO_INCREMENT=4 ;
994 -- Dumping data for table `0_grn_items`
997 INSERT INTO `0_grn_items` VALUES(1, 1, 1, '102', '17inch VGA Monitor', 100, 100);
998 INSERT INTO `0_grn_items` VALUES(2, 1, 2, '103', '32MB VGA Card', 100, 100);
999 INSERT INTO `0_grn_items` VALUES(3, 1, 3, '104', '52x CD Drive', 100, 100);
1001 -- --------------------------------------------------------
1004 -- Table structure for table `0_groups`
1007 DROP TABLE IF EXISTS `0_groups`;
1008 CREATE TABLE IF NOT EXISTS `0_groups` (
1009 `id` smallint(6) unsigned NOT NULL auto_increment,
1010 `description` varchar(60) NOT NULL default '',
1011 `inactive` tinyint(1) NOT NULL default '0',
1013 UNIQUE KEY `description` (`description`)
1014 ) ENGINE=MyISAM AUTO_INCREMENT=4 ;
1017 -- Dumping data for table `0_groups`
1020 INSERT INTO `0_groups` VALUES(1, 'Small', 0);
1021 INSERT INTO `0_groups` VALUES(2, 'Medium', 0);
1022 INSERT INTO `0_groups` VALUES(3, 'Large', 0);
1024 -- --------------------------------------------------------
1027 -- Table structure for table `0_item_codes`
1030 DROP TABLE IF EXISTS `0_item_codes`;
1031 CREATE TABLE IF NOT EXISTS `0_item_codes` (
1032 `id` int(11) unsigned NOT NULL auto_increment,
1033 `item_code` varchar(20) NOT NULL,
1034 `stock_id` varchar(20) NOT NULL,
1035 `description` varchar(200) NOT NULL default '',
1036 `category_id` smallint(6) unsigned NOT NULL,
1037 `quantity` double NOT NULL default '1',
1038 `is_foreign` tinyint(1) NOT NULL default '0',
1039 `inactive` tinyint(1) NOT NULL default '0',
1041 UNIQUE KEY `stock_id` (`stock_id`,`item_code`),
1042 KEY `item_code` (`item_code`)
1043 ) ENGINE=MyISAM AUTO_INCREMENT=6 ;
1046 -- Dumping data for table `0_item_codes`
1049 INSERT INTO `0_item_codes` VALUES(1, '102', '102', '17inch VGA Monitor', 1, 1, 0, 0);
1050 INSERT INTO `0_item_codes` VALUES(2, '103', '103', '32MB VGA Card', 1, 1, 0, 0);
1051 INSERT INTO `0_item_codes` VALUES(3, '104', '104', '52x CD Drive', 1, 1, 0, 0);
1052 INSERT INTO `0_item_codes` VALUES(4, '3400', '3400', 'P4 Business System', 3, 1, 0, 0);
1053 INSERT INTO `0_item_codes` VALUES(5, '201', '201', 'Assembly Labour', 4, 1, 0, 0);
1055 -- --------------------------------------------------------
1058 -- Table structure for table `0_item_tax_types`
1061 DROP TABLE IF EXISTS `0_item_tax_types`;
1062 CREATE TABLE IF NOT EXISTS `0_item_tax_types` (
1063 `id` int(11) NOT NULL auto_increment,
1064 `name` varchar(60) NOT NULL default '',
1065 `exempt` tinyint(1) NOT NULL default '0',
1066 `inactive` tinyint(1) NOT NULL default '0',
1068 UNIQUE KEY `name` (`name`)
1069 ) ENGINE=InnoDB AUTO_INCREMENT=2 ;
1072 -- Dumping data for table `0_item_tax_types`
1075 INSERT INTO `0_item_tax_types` VALUES(1, 'Regular', 0, 0);
1077 -- --------------------------------------------------------
1080 -- Table structure for table `0_item_tax_type_exemptions`
1083 DROP TABLE IF EXISTS `0_item_tax_type_exemptions`;
1084 CREATE TABLE IF NOT EXISTS `0_item_tax_type_exemptions` (
1085 `item_tax_type_id` int(11) NOT NULL default '0',
1086 `tax_type_id` int(11) NOT NULL default '0',
1087 PRIMARY KEY (`item_tax_type_id`,`tax_type_id`)
1091 -- Dumping data for table `0_item_tax_type_exemptions`
1095 -- --------------------------------------------------------
1098 -- Table structure for table `0_item_units`
1101 DROP TABLE IF EXISTS `0_item_units`;
1102 CREATE TABLE IF NOT EXISTS `0_item_units` (
1103 `abbr` varchar(20) NOT NULL,
1104 `name` varchar(40) NOT NULL,
1105 `decimals` tinyint(2) NOT NULL,
1106 `inactive` tinyint(1) NOT NULL default '0',
1107 PRIMARY KEY (`abbr`),
1108 UNIQUE KEY `name` (`name`)
1112 -- Dumping data for table `0_item_units`
1115 INSERT INTO `0_item_units` VALUES('ea.', 'Each', 0, 0);
1116 INSERT INTO `0_item_units` VALUES('hrs', 'Hours', 1, 0);
1118 -- --------------------------------------------------------
1121 -- Table structure for table `0_locations`
1124 DROP TABLE IF EXISTS `0_locations`;
1125 CREATE TABLE IF NOT EXISTS `0_locations` (
1126 `loc_code` varchar(5) NOT NULL default '',
1127 `location_name` varchar(60) NOT NULL default '',
1128 `delivery_address` tinytext NOT NULL,
1129 `phone` varchar(30) NOT NULL default '',
1130 `phone2` varchar(30) NOT NULL default '',
1131 `fax` varchar(30) NOT NULL default '',
1132 `email` varchar(100) NOT NULL default '',
1133 `contact` varchar(30) NOT NULL default '',
1134 `inactive` tinyint(1) NOT NULL default '0',
1135 PRIMARY KEY (`loc_code`)
1139 -- Dumping data for table `0_locations`
1142 INSERT INTO `0_locations` VALUES('DEF', 'Default', 'Delivery 1\nDelivery 2\nDelivery 3', '', '', '', '', '', 0);
1144 -- --------------------------------------------------------
1147 -- Table structure for table `0_loc_stock`
1150 DROP TABLE IF EXISTS `0_loc_stock`;
1151 CREATE TABLE IF NOT EXISTS `0_loc_stock` (
1152 `loc_code` char(5) NOT NULL default '',
1153 `stock_id` char(20) NOT NULL default '',
1154 `reorder_level` bigint(20) NOT NULL default '0',
1155 PRIMARY KEY (`loc_code`,`stock_id`),
1156 KEY `stock_id` (`stock_id`)
1160 -- Dumping data for table `0_loc_stock`
1163 INSERT INTO `0_loc_stock` VALUES('DEF', '102', 0);
1164 INSERT INTO `0_loc_stock` VALUES('DEF', '103', 0);
1165 INSERT INTO `0_loc_stock` VALUES('DEF', '104', 0);
1166 INSERT INTO `0_loc_stock` VALUES('DEF', '201', 0);
1167 INSERT INTO `0_loc_stock` VALUES('DEF', '3400', 0);
1169 -- --------------------------------------------------------
1172 -- Table structure for table `0_movement_types`
1175 DROP TABLE IF EXISTS `0_movement_types`;
1176 CREATE TABLE IF NOT EXISTS `0_movement_types` (
1177 `id` int(11) NOT NULL auto_increment,
1178 `name` varchar(60) NOT NULL default '',
1179 `inactive` tinyint(1) NOT NULL default '0',
1181 UNIQUE KEY `name` (`name`)
1182 ) ENGINE=MyISAM AUTO_INCREMENT=2 ;
1185 -- Dumping data for table `0_movement_types`
1188 INSERT INTO `0_movement_types` VALUES(1, 'Adjustment', 0);
1190 -- --------------------------------------------------------
1193 -- Table structure for table `0_payment_terms`
1196 DROP TABLE IF EXISTS `0_payment_terms`;
1197 CREATE TABLE IF NOT EXISTS `0_payment_terms` (
1198 `terms_indicator` int(11) NOT NULL auto_increment,
1199 `terms` char(80) NOT NULL default '',
1200 `days_before_due` smallint(6) NOT NULL default '0',
1201 `day_in_following_month` smallint(6) NOT NULL default '0',
1202 `inactive` tinyint(1) NOT NULL default '0',
1203 PRIMARY KEY (`terms_indicator`),
1204 UNIQUE KEY `terms` (`terms`)
1205 ) ENGINE=MyISAM AUTO_INCREMENT=5 ;
1208 -- Dumping data for table `0_payment_terms`
1211 INSERT INTO `0_payment_terms` VALUES(1, 'Due 15th Of the Following Month', 0, 17, 0);
1212 INSERT INTO `0_payment_terms` VALUES(2, 'Due By End Of The Following Month', 0, 30, 0);
1213 INSERT INTO `0_payment_terms` VALUES(3, 'Payment due within 10 days', 10, 0, 0);
1214 INSERT INTO `0_payment_terms` VALUES(4, 'Cash Only', 0, 0, 0);
1216 -- --------------------------------------------------------
1219 -- Table structure for table `0_prices`
1222 DROP TABLE IF EXISTS `0_prices`;
1223 CREATE TABLE IF NOT EXISTS `0_prices` (
1224 `id` int(11) NOT NULL auto_increment,
1225 `stock_id` varchar(20) NOT NULL default '',
1226 `sales_type_id` int(11) NOT NULL default '0',
1227 `curr_abrev` char(3) NOT NULL default '',
1228 `price` double NOT NULL default '0',
1230 UNIQUE KEY `price` (`stock_id`,`sales_type_id`,`curr_abrev`)
1231 ) ENGINE=MyISAM AUTO_INCREMENT=5 ;
1234 -- Dumping data for table `0_prices`
1237 INSERT INTO `0_prices` VALUES(1, '3400', 1, 'USD', 100);
1238 INSERT INTO `0_prices` VALUES(2, '102', 1, 'USD', 50);
1239 INSERT INTO `0_prices` VALUES(3, '103', 1, 'USD', 55);
1240 INSERT INTO `0_prices` VALUES(4, '104', 1, 'USD', 60);
1242 -- --------------------------------------------------------
1245 -- Table structure for table `0_printers`
1248 DROP TABLE IF EXISTS `0_printers`;
1249 CREATE TABLE IF NOT EXISTS `0_printers` (
1250 `id` tinyint(3) unsigned NOT NULL auto_increment,
1251 `name` varchar(20) NOT NULL,
1252 `description` varchar(60) NOT NULL,
1253 `queue` varchar(20) NOT NULL,
1254 `host` varchar(40) NOT NULL,
1255 `port` smallint(11) unsigned NOT NULL,
1256 `timeout` tinyint(3) unsigned NOT NULL,
1258 UNIQUE KEY `name` (`name`)
1259 ) ENGINE=MyISAM AUTO_INCREMENT=4 ;
1262 -- Dumping data for table `0_printers`
1265 INSERT INTO `0_printers` VALUES(1, 'QL500', 'Label printer', 'QL500', 'server', 127, 20);
1266 INSERT INTO `0_printers` VALUES(2, 'Samsung', 'Main network printer', 'scx4521F', 'server', 515, 5);
1267 INSERT INTO `0_printers` VALUES(3, 'Local', 'Local print server at user IP', 'lp', '', 515, 10);
1269 -- --------------------------------------------------------
1272 -- Table structure for table `0_print_profiles`
1275 DROP TABLE IF EXISTS `0_print_profiles`;
1276 CREATE TABLE IF NOT EXISTS `0_print_profiles` (
1277 `id` smallint(6) unsigned NOT NULL auto_increment,
1278 `profile` varchar(30) NOT NULL,
1279 `report` varchar(5) default NULL,
1280 `printer` tinyint(3) unsigned default NULL,
1282 UNIQUE KEY `profile` (`profile`,`report`)
1283 ) ENGINE=MyISAM AUTO_INCREMENT=10 ;
1286 -- Dumping data for table `0_print_profiles`
1289 INSERT INTO `0_print_profiles` VALUES(1, 'Out of office', '', 0);
1290 INSERT INTO `0_print_profiles` VALUES(2, 'Sales Department', '', 0);
1291 INSERT INTO `0_print_profiles` VALUES(3, 'Central', '', 2);
1292 INSERT INTO `0_print_profiles` VALUES(4, 'Sales Department', '104', 2);
1293 INSERT INTO `0_print_profiles` VALUES(5, 'Sales Department', '105', 2);
1294 INSERT INTO `0_print_profiles` VALUES(6, 'Sales Department', '107', 2);
1295 INSERT INTO `0_print_profiles` VALUES(7, 'Sales Department', '109', 2);
1296 INSERT INTO `0_print_profiles` VALUES(8, 'Sales Department', '110', 2);
1297 INSERT INTO `0_print_profiles` VALUES(9, 'Sales Department', '201', 2);
1299 -- --------------------------------------------------------
1302 -- Table structure for table `0_purch_data`
1305 DROP TABLE IF EXISTS `0_purch_data`;
1306 CREATE TABLE IF NOT EXISTS `0_purch_data` (
1307 `supplier_id` int(11) NOT NULL default '0',
1308 `stock_id` char(20) NOT NULL default '',
1309 `price` double NOT NULL default '0',
1310 `suppliers_uom` char(50) NOT NULL default '',
1311 `conversion_factor` double NOT NULL default '1',
1312 `supplier_description` char(50) NOT NULL default '',
1313 PRIMARY KEY (`supplier_id`,`stock_id`)
1317 -- Dumping data for table `0_purch_data`
1320 INSERT INTO `0_purch_data` VALUES(2, '102', 10, '', 1, '17inch VGA Monitor');
1321 INSERT INTO `0_purch_data` VALUES(2, '103', 11, '', 1, '32MB VGA Card');
1322 INSERT INTO `0_purch_data` VALUES(2, '104', 12, '', 1, '52x CD Drive');
1324 -- --------------------------------------------------------
1327 -- Table structure for table `0_purch_orders`
1330 DROP TABLE IF EXISTS `0_purch_orders`;
1331 CREATE TABLE IF NOT EXISTS `0_purch_orders` (
1332 `order_no` int(11) NOT NULL auto_increment,
1333 `supplier_id` int(11) NOT NULL default '0',
1334 `comments` tinytext,
1335 `ord_date` date NOT NULL default '0000-00-00',
1336 `reference` tinytext NOT NULL,
1337 `requisition_no` tinytext,
1338 `into_stock_location` varchar(5) NOT NULL default '',
1339 `delivery_address` tinytext NOT NULL,
1340 `total` double NOT NULL default '0',
1341 `tax_included` tinyint(1) NOT NULL default '0',
1342 PRIMARY KEY (`order_no`),
1343 KEY `ord_date` (`ord_date`)
1344 ) ENGINE=InnoDB AUTO_INCREMENT=3 ;
1347 -- Dumping data for table `0_purch_orders`
1350 INSERT INTO `0_purch_orders` VALUES(1, 2, '', '2009-06-01', '1', '', 'DEF', 'Delivery 1\nDelivery 2\nDelivery 3', 0, 0);
1351 INSERT INTO `0_purch_orders` VALUES(2, 3, '', '2009-06-21', '2', '', 'DEF', 'Delivery 1\nDelivery 2\nDelivery 3', 0, 0);
1353 -- --------------------------------------------------------
1356 -- Table structure for table `0_purch_order_details`
1359 DROP TABLE IF EXISTS `0_purch_order_details`;
1360 CREATE TABLE IF NOT EXISTS `0_purch_order_details` (
1361 `po_detail_item` int(11) NOT NULL auto_increment,
1362 `order_no` int(11) NOT NULL default '0',
1363 `item_code` varchar(20) NOT NULL default '',
1364 `description` tinytext,
1365 `delivery_date` date NOT NULL default '0000-00-00',
1366 `qty_invoiced` double NOT NULL default '0',
1367 `unit_price` double NOT NULL default '0',
1368 `act_price` double NOT NULL default '0',
1369 `std_cost_unit` double NOT NULL default '0',
1370 `quantity_ordered` double NOT NULL default '0',
1371 `quantity_received` double NOT NULL default '0',
1372 PRIMARY KEY (`po_detail_item`),
1373 KEY `order` (`order_no`,`po_detail_item`),
1374 KEY `itemcode` (`item_code`)
1375 ) ENGINE=InnoDB AUTO_INCREMENT=6 ;
1378 -- Dumping data for table `0_purch_order_details`
1381 INSERT INTO `0_purch_order_details` VALUES(1, 1, '102', '17inch VGA Monitor', '2009-07-01', 100, 10, 10, 10, 100, 100);
1382 INSERT INTO `0_purch_order_details` VALUES(2, 1, '103', '32MB VGA Card', '2009-07-01', 100, 11, 11, 11, 100, 100);
1383 INSERT INTO `0_purch_order_details` VALUES(3, 1, '104', '52x CD Drive', '2009-07-01', 100, 12, 12, 12, 100, 100);
1384 INSERT INTO `0_purch_order_details` VALUES(4, 2, '102', '17inch VGA Monitor', '2009-07-01', 0, 5, 0, 0, 1, 0);
1385 INSERT INTO `0_purch_order_details` VALUES(5, 2, '103', '32MB VGA Card', '2009-07-01', 0, 5, 0, 0, 1, 0);
1387 -- --------------------------------------------------------
1390 -- Table structure for table `0_quick_entries`
1393 DROP TABLE IF EXISTS `0_quick_entries`;
1394 CREATE TABLE IF NOT EXISTS `0_quick_entries` (
1395 `id` smallint(6) unsigned NOT NULL auto_increment,
1396 `type` tinyint(1) NOT NULL default '0',
1397 `description` varchar(60) NOT NULL,
1398 `base_amount` double NOT NULL default '0',
1399 `base_desc` varchar(60) default NULL,
1400 `bal_type` tinyint(1) NOT NULL default '0',
1402 KEY `description` (`description`)
1403 ) ENGINE=MyISAM AUTO_INCREMENT=4 ;
1406 -- Dumping data for table `0_quick_entries`
1409 INSERT INTO `0_quick_entries` VALUES(1, 1, 'Maintenance', 0, 'Amount', 0);
1410 INSERT INTO `0_quick_entries` VALUES(2, 4, 'Phone', 0, 'Amount', 0);
1411 INSERT INTO `0_quick_entries` VALUES(3, 2, 'Cash Sales', 0, 'Amount', 0);
1413 -- --------------------------------------------------------
1416 -- Table structure for table `0_quick_entry_lines`
1419 DROP TABLE IF EXISTS `0_quick_entry_lines`;
1420 CREATE TABLE IF NOT EXISTS `0_quick_entry_lines` (
1421 `id` smallint(6) unsigned NOT NULL auto_increment,
1422 `qid` smallint(6) unsigned NOT NULL,
1423 `amount` double default '0',
1424 `action` varchar(2) NOT NULL,
1425 `dest_id` varchar(15) NOT NULL default '',
1426 `dimension_id` smallint(6) unsigned default NULL,
1427 `dimension2_id` smallint(6) unsigned default NULL,
1430 ) ENGINE=MyISAM AUTO_INCREMENT=8 ;
1433 -- Dumping data for table `0_quick_entry_lines`
1436 INSERT INTO `0_quick_entry_lines` VALUES(1, 1, 0, 't-', '1', 0, 0);
1437 INSERT INTO `0_quick_entry_lines` VALUES(2, 2, 0, 't-', '1', 0, 0);
1438 INSERT INTO `0_quick_entry_lines` VALUES(3, 3, 0, 't-', '1', 0, 0);
1439 INSERT INTO `0_quick_entry_lines` VALUES(4, 3, 0, '=', '4010', 0, 0);
1440 INSERT INTO `0_quick_entry_lines` VALUES(5, 1, 0, '=', '5765', 0, 0);
1441 INSERT INTO `0_quick_entry_lines` VALUES(6, 2, 0, '=', '5780', 0, 0);
1443 -- --------------------------------------------------------
1446 -- Table structure for table `0_recurrent_invoices`
1449 DROP TABLE IF EXISTS `0_recurrent_invoices`;
1450 CREATE TABLE IF NOT EXISTS `0_recurrent_invoices` (
1451 `id` smallint(6) unsigned NOT NULL auto_increment,
1452 `description` varchar(60) NOT NULL default '',
1453 `order_no` int(11) unsigned NOT NULL,
1454 `debtor_no` int(11) unsigned default NULL,
1455 `group_no` smallint(6) unsigned default NULL,
1456 `days` int(11) NOT NULL default '0',
1457 `monthly` int(11) NOT NULL default '0',
1458 `begin` date NOT NULL default '0000-00-00',
1459 `end` date NOT NULL default '0000-00-00',
1460 `last_sent` date NOT NULL default '0000-00-00',
1462 UNIQUE KEY `description` (`description`)
1463 ) ENGINE=InnoDB AUTO_INCREMENT=1 ;
1466 -- Dumping data for table `0_recurrent_invoices`
1470 -- --------------------------------------------------------
1473 -- Table structure for table `0_refs`
1476 DROP TABLE IF EXISTS `0_refs`;
1477 CREATE TABLE IF NOT EXISTS `0_refs` (
1478 `id` int(11) NOT NULL default '0',
1479 `type` int(11) NOT NULL default '0',
1480 `reference` varchar(100) NOT NULL default '',
1481 PRIMARY KEY (`id`,`type`),
1482 KEY `Type_and_Reference` (`type`,`reference`)
1486 -- Dumping data for table `0_refs`
1489 INSERT INTO `0_refs` VALUES(18, 0, '1');
1490 INSERT INTO `0_refs` VALUES(19, 0, '2');
1492 -- --------------------------------------------------------
1495 -- Table structure for table `0_salesman`
1498 DROP TABLE IF EXISTS `0_salesman`;
1499 CREATE TABLE IF NOT EXISTS `0_salesman` (
1500 `salesman_code` int(11) NOT NULL auto_increment,
1501 `salesman_name` char(60) NOT NULL default '',
1502 `salesman_phone` char(30) NOT NULL default '',
1503 `salesman_fax` char(30) NOT NULL default '',
1504 `salesman_email` varchar(100) NOT NULL default '',
1505 `provision` double NOT NULL default '0',
1506 `break_pt` double NOT NULL default '0',
1507 `provision2` double NOT NULL default '0',
1508 `inactive` tinyint(1) NOT NULL default '0',
1509 PRIMARY KEY (`salesman_code`),
1510 UNIQUE KEY `salesman_name` (`salesman_name`)
1511 ) ENGINE=MyISAM AUTO_INCREMENT=2 ;
1514 -- Dumping data for table `0_salesman`
1517 INSERT INTO `0_salesman` VALUES(1, 'Sales Person', '', '', '', 5, 1000, 4, 0);
1519 -- --------------------------------------------------------
1522 -- Table structure for table `0_sales_orders`
1525 DROP TABLE IF EXISTS `0_sales_orders`;
1526 CREATE TABLE IF NOT EXISTS `0_sales_orders` (
1527 `order_no` int(11) NOT NULL,
1528 `trans_type` smallint(6) NOT NULL default '30',
1529 `version` tinyint(1) unsigned NOT NULL default '0',
1530 `type` tinyint(1) NOT NULL default '0',
1531 `debtor_no` int(11) NOT NULL default '0',
1532 `branch_code` int(11) NOT NULL default '0',
1533 `reference` varchar(100) NOT NULL default '',
1534 `customer_ref` tinytext NOT NULL,
1535 `comments` tinytext,
1536 `ord_date` date NOT NULL default '0000-00-00',
1537 `order_type` int(11) NOT NULL default '0',
1538 `ship_via` int(11) NOT NULL default '0',
1539 `delivery_address` tinytext NOT NULL,
1540 `contact_phone` varchar(30) default NULL,
1541 `contact_email` varchar(100) default NULL,
1542 `deliver_to` tinytext NOT NULL,
1543 `freight_cost` double NOT NULL default '0',
1544 `from_stk_loc` varchar(5) NOT NULL default '',
1545 `delivery_date` date NOT NULL default '0000-00-00',
1546 `payment_terms` int(11) default NULL,
1547 `total` double NOT NULL default '0',
1548 PRIMARY KEY (`trans_type`,`order_no`)
1552 -- Dumping data for table `0_sales_orders`
1555 INSERT INTO `0_sales_orders` VALUES(1, 30, 1, 0, 1, 1, '1', '', '', '2009-06-21', 2, 1, 'Address 1\nAddress 2\nAddress 3', '', '', 'Beefeater Ltd.', 10, 'DEF', '2009-06-22', 3, 0);
1556 INSERT INTO `0_sales_orders` VALUES(2, 30, 1, 0, 2, 2, '2', '', '', '2009-06-21', 1, 1, 'Address 1\nAddress 2\nAddress 3', '', '', 'Ghostbusters Corp.', 0, 'DEF', '2009-06-22', 4, 0);
1557 INSERT INTO `0_sales_orders` VALUES(3, 30, 1, 0, 3, 3, '3', '', '', '2009-06-21', 2, 1, 'Address 1\nAddress 2\nAddress 3', '', '', 'Brezan', 0, 'DEF', '2009-07-01', 3, 0);
1558 INSERT INTO `0_sales_orders` VALUES(4, 30, 0, 0, 1, 1, '4', '', '', '2009-06-21', 2, 1, 'Address 1\nAddress 2\nAddress 3', '', '', 'Beefeater Ltd.', 0, 'DEF', '2009-06-22', 3, 0);
1559 INSERT INTO `0_sales_orders` VALUES(5, 30, 1, 0, 2, 2, '5', '', '', '2009-06-21', 1, 1, 'Address 1\nAddress 2\nAddress 3', '', '', 'Ghostbusters Corp.', 5, 'DEF', '2009-06-22', 4, 0);
1561 -- --------------------------------------------------------
1564 -- Table structure for table `0_sales_order_details`
1567 DROP TABLE IF EXISTS `0_sales_order_details`;
1568 CREATE TABLE IF NOT EXISTS `0_sales_order_details` (
1569 `id` int(11) NOT NULL auto_increment,
1570 `order_no` int(11) NOT NULL default '0',
1571 `trans_type` smallint(6) NOT NULL default '30',
1572 `stk_code` varchar(20) NOT NULL default '',
1573 `description` tinytext,
1574 `qty_sent` double NOT NULL default '0',
1575 `unit_price` double NOT NULL default '0',
1576 `quantity` double NOT NULL default '0',
1577 `discount_percent` double NOT NULL default '0',
1579 KEY `sorder` (`trans_type`,`order_no`),
1580 KEY `stkcode` (`stk_code`)
1581 ) ENGINE=InnoDB AUTO_INCREMENT=6 ;
1584 -- Dumping data for table `0_sales_order_details`
1587 INSERT INTO `0_sales_order_details` VALUES(1, 1, 30, '102', '17inch VGA Monitor', 2, 30.4, 2, 0);
1588 INSERT INTO `0_sales_order_details` VALUES(2, 2, 30, '102', '17inch VGA Monitor', 1, 50, 1, 0);
1589 INSERT INTO `0_sales_order_details` VALUES(3, 3, 30, '102', '17inch VGA Monitor', 1, 35.89, 1, 0);
1590 INSERT INTO `0_sales_order_details` VALUES(4, 4, 30, '102', '17inch VGA Monitor', 0, 21.28, 2, 0);
1591 INSERT INTO `0_sales_order_details` VALUES(5, 5, 30, '102', '17inch VGA Monitor', 1, 50, 1, 0);
1593 -- --------------------------------------------------------
1596 -- Table structure for table `0_sales_pos`
1599 DROP TABLE IF EXISTS `0_sales_pos`;
1600 CREATE TABLE IF NOT EXISTS `0_sales_pos` (
1601 `id` smallint(6) unsigned NOT NULL auto_increment,
1602 `pos_name` varchar(30) NOT NULL,
1603 `cash_sale` tinyint(1) NOT NULL,
1604 `credit_sale` tinyint(1) NOT NULL,
1605 `pos_location` varchar(5) NOT NULL,
1606 `pos_account` smallint(6) unsigned NOT NULL,
1607 `inactive` tinyint(1) NOT NULL default '0',
1609 UNIQUE KEY `pos_name` (`pos_name`)
1610 ) ENGINE=MyISAM AUTO_INCREMENT=2 ;
1613 -- Dumping data for table `0_sales_pos`
1616 INSERT INTO `0_sales_pos` VALUES(1, 'Default', 1, 1, 'DEF', 2, 0);
1618 -- --------------------------------------------------------
1621 -- Table structure for table `0_sales_types`
1624 DROP TABLE IF EXISTS `0_sales_types`;
1625 CREATE TABLE IF NOT EXISTS `0_sales_types` (
1626 `id` int(11) NOT NULL auto_increment,
1627 `sales_type` char(50) NOT NULL default '',
1628 `tax_included` int(1) NOT NULL default '0',
1629 `factor` double NOT NULL default '1',
1630 `inactive` tinyint(1) NOT NULL default '0',
1632 UNIQUE KEY `sales_type` (`sales_type`)
1633 ) ENGINE=MyISAM AUTO_INCREMENT=3 ;
1636 -- Dumping data for table `0_sales_types`
1639 INSERT INTO `0_sales_types` VALUES(1, 'Retail', 1, 1, 0);
1640 INSERT INTO `0_sales_types` VALUES(2, 'Wholesale', 0, 0.7, 0);
1642 -- --------------------------------------------------------
1645 -- Table structure for table `0_security_roles`
1648 DROP TABLE IF EXISTS `0_security_roles`;
1649 CREATE TABLE IF NOT EXISTS `0_security_roles` (
1650 `id` int(11) NOT NULL auto_increment,
1651 `role` varchar(30) NOT NULL,
1652 `description` varchar(50) default NULL,
1655 `inactive` tinyint(1) NOT NULL default '0',
1657 UNIQUE KEY `role` (`role`)
1658 ) ENGINE=MyISAM AUTO_INCREMENT=11 ;
1661 -- Dumping data for table `0_security_roles`
1664 INSERT INTO `0_security_roles` VALUES(1, 'Inquiries', 'Inquiries', '768;2816;3072;3328;5632;5888;8192;8448;10752;11008;13312;15872;16128', '257;258;259;260;513;514;515;516;517;518;519;520;521;522;523;524;525;773;774;2822;3073;3075;3076;3077;3329;3330;3331;3332;3333;3334;3335;5377;5633;5640;5889;5890;5891;7937;7938;7939;7940;8193;8194;8450;8451;10497;10753;11009;11010;11012;13313;13315;15617;15618;15619;15620;15621;15622;15623;15624;15625;15626;15873;15882;16129;16130;16131;16132', 0);
1665 INSERT INTO `0_security_roles` VALUES(2, 'System Administrator', 'System Administrator', '256;512;768;2816;3072;3328;5376;5632;5888;7936;8192;8448;10496;10752;11008;13056;13312;15616;15872;16128', '257;258;259;260;513;514;515;516;517;518;519;520;521;522;523;524;525;526;769;770;771;772;773;774;2817;2818;2819;2820;2821;2822;2823;3073;3074;3082;3075;3076;3077;3078;3079;3080;3081;3329;3330;3331;3332;3333;3334;3335;5377;5633;5634;5635;5636;5637;5641;5638;5639;5640;5889;5890;5891;7937;7938;7939;7940;8193;8194;8195;8196;8197;8449;8450;8451;10497;10753;10754;10755;10756;10757;11009;11010;11011;11012;13057;13313;13314;13315;15617;15618;15619;15620;15621;15622;15623;15624;15628;15625;15626;15627;15873;15874;15875;15876;15877;15878;15879;15880;15883;15881;15882;16129;16130;16131;16132', 0);
1666 INSERT INTO `0_security_roles` VALUES(3, 'Salesman', 'Salesman', '768;3072;5632;8192;15872', '773;774;3073;3075;3081;5633;8194;15873', 0);
1667 INSERT INTO `0_security_roles` VALUES(4, 'Stock Manager', 'Stock Manager', '2816;3072;3328;5632;5888;8192;8448;10752;11008;13312;15872;16128', '2818;2822;3073;3076;3077;3329;3330;3330;3330;3331;3331;3332;3333;3334;3335;5633;5640;5889;5890;5891;8193;8194;8450;8451;10753;11009;11010;11012;13313;13315;15882;16129;16130;16131;16132', 0);
1668 INSERT INTO `0_security_roles` VALUES(5, 'Production Manager', 'Production Manager', '512;2816;3072;3328;5632;5888;8192;8448;10752;11008;13312;15616;15872;16128', '521;523;524;2818;2819;2820;2821;2822;2823;3073;3074;3076;3077;3078;3079;3080;3081;3329;3330;3330;3330;3331;3331;3332;3333;3334;3335;5633;5640;5640;5889;5890;5891;8193;8194;8196;8197;8450;8451;10753;10755;11009;11010;11012;13313;13315;15617;15619;15620;15621;15624;15624;15876;15877;15880;15882;16129;16130;16131;16132', 0);
1669 INSERT INTO `0_security_roles` VALUES(6, 'Purchase Officer', 'Purchase Officer', '512;2816;3072;3328;5376;5632;5888;8192;8448;10752;11008;13312;15616;15872;16128', '521;523;524;2818;2819;2820;2821;2822;2823;3073;3074;3076;3077;3078;3079;3080;3081;3329;3330;3330;3330;3331;3331;3332;3333;3334;3335;5377;5633;5635;5640;5640;5889;5890;5891;8193;8194;8196;8197;8449;8450;8451;10753;10755;11009;11010;11012;13313;13315;15617;15619;15620;15621;15624;15624;15876;15877;15880;15882;16129;16130;16131;16132', 0);
1670 INSERT INTO `0_security_roles` VALUES(7, 'AR Officer', 'AR Officer', '512;768;2816;3072;3328;5632;5888;8192;8448;10752;11008;13312;15616;15872;16128', '521;523;524;771;773;774;2818;2819;2820;2821;2822;2823;3073;3073;3074;3075;3076;3077;3078;3079;3080;3081;3081;3329;3330;3330;3330;3331;3331;3332;3333;3334;3335;5633;5633;5634;5637;5638;5639;5640;5640;5889;5890;5891;8193;8194;8194;8196;8197;8450;8451;10753;10755;11009;11010;11012;13313;13315;15617;15619;15620;15621;15624;15624;15873;15876;15877;15878;15880;15882;16129;16130;16131;16132', 0);
1671 INSERT INTO `0_security_roles` VALUES(8, 'AP Officer', 'AP Officer', '512;2816;3072;3328;5376;5632;5888;8192;8448;10752;11008;13312;15616;15872;16128', '257;258;259;260;521;523;524;769;770;771;772;773;774;2818;2819;2820;2821;2822;2823;3073;3074;3082;3076;3077;3078;3079;3080;3081;3329;3330;3331;3332;3333;3334;3335;5377;5633;5635;5640;5889;5890;5891;7937;7938;7939;7940;8193;8194;8196;8197;8449;8450;8451;10497;10753;10755;11009;11010;11012;13057;13313;13315;15617;15619;15620;15621;15624;15876;15877;15880;15882;16129;16130;16131;16132', 0);
1672 INSERT INTO `0_security_roles` VALUES(9, 'Accountant', 'New Accountant', '512;768;2816;3072;3328;5376;5632;5888;8192;8448;10752;11008;13312;15616;15872;16128', '257;258;259;260;521;523;524;771;772;773;774;2818;2819;2820;2821;2822;2823;3073;3074;3075;3076;3077;3078;3079;3080;3081;3329;3330;3331;3332;3333;3334;3335;5377;5633;5634;5635;5637;5638;5639;5640;5889;5890;5891;7937;7938;7939;7940;8193;8194;8196;8197;8449;8450;8451;10497;10753;10755;11009;11010;11012;13313;13315;15617;15618;15619;15620;15621;15624;15873;15876;15877;15878;15880;15882;16129;16130;16131;16132', 0);
1673 INSERT INTO `0_security_roles` VALUES(10, 'Sub Admin', 'Sub Admin', '512;768;2816;3072;3328;5376;5632;5888;8192;8448;10752;11008;13312;15616;15872;16128', '257;258;259;260;521;523;524;771;772;773;774;2818;2819;2820;2821;2822;2823;3073;3074;3082;3075;3076;3077;3078;3079;3080;3081;3329;3330;3331;3332;3333;3334;3335;5377;5633;5634;5635;5637;5638;5639;5640;5889;5890;5891;7937;7938;7939;7940;8193;8194;8196;8197;8449;8450;8451;10497;10753;10755;11009;11010;11012;13057;13313;13315;15617;15619;15620;15621;15624;15873;15874;15876;15877;15878;15879;15880;15882;16129;16130;16131;16132', 0);
1675 -- --------------------------------------------------------
1678 -- Table structure for table `0_shippers`
1681 DROP TABLE IF EXISTS `0_shippers`;
1682 CREATE TABLE IF NOT EXISTS `0_shippers` (
1683 `shipper_id` int(11) NOT NULL auto_increment,
1684 `shipper_name` varchar(60) NOT NULL default '',
1685 `phone` varchar(30) NOT NULL default '',
1686 `phone2` varchar(30) NOT NULL default '',
1687 `contact` tinytext NOT NULL,
1688 `address` tinytext NOT NULL,
1689 `inactive` tinyint(1) NOT NULL default '0',
1690 PRIMARY KEY (`shipper_id`),
1691 UNIQUE KEY `name` (`shipper_name`)
1692 ) ENGINE=MyISAM AUTO_INCREMENT=2 ;
1695 -- Dumping data for table `0_shippers`
1698 INSERT INTO `0_shippers` VALUES(1, 'Default', '', '', '', '', 0);
1700 -- --------------------------------------------------------
1703 -- Table structure for table `0_sql_trail`
1706 DROP TABLE IF EXISTS `0_sql_trail`;
1707 CREATE TABLE IF NOT EXISTS `0_sql_trail` (
1708 `id` int(11) unsigned NOT NULL auto_increment,
1709 `sql` text NOT NULL,
1710 `result` tinyint(1) NOT NULL,
1711 `msg` varchar(255) NOT NULL,
1713 ) ENGINE=MyISAM AUTO_INCREMENT=1 ;
1716 -- Dumping data for table `0_sql_trail`
1720 -- --------------------------------------------------------
1723 -- Table structure for table `0_stock_category`
1726 DROP TABLE IF EXISTS `0_stock_category`;
1727 CREATE TABLE IF NOT EXISTS `0_stock_category` (
1728 `category_id` int(11) NOT NULL auto_increment,
1729 `description` varchar(60) NOT NULL default '',
1730 `dflt_tax_type` int(11) NOT NULL default '1',
1731 `dflt_units` varchar(20) NOT NULL default 'each',
1732 `dflt_mb_flag` char(1) NOT NULL default 'B',
1733 `dflt_sales_act` varchar(15) NOT NULL default '',
1734 `dflt_cogs_act` varchar(15) NOT NULL default '',
1735 `dflt_inventory_act` varchar(15) NOT NULL default '',
1736 `dflt_adjustment_act` varchar(15) NOT NULL default '',
1737 `dflt_assembly_act` varchar(15) NOT NULL default '',
1738 `dflt_dim1` int(11) default NULL,
1739 `dflt_dim2` int(11) default NULL,
1740 `inactive` tinyint(1) NOT NULL default '0',
1741 `dflt_no_sale` tinyint(1) NOT NULL default '0',
1742 PRIMARY KEY (`category_id`),
1743 UNIQUE KEY `description` (`description`)
1744 ) ENGINE=MyISAM AUTO_INCREMENT=5 ;
1747 -- Dumping data for table `0_stock_category`
1750 INSERT INTO `0_stock_category` VALUES(1, 'Components', 1, 'each', 'B', '4010', '5010', '1510', '5040', '1530', 0, 0, 0, 0);
1751 INSERT INTO `0_stock_category` VALUES(2, 'Charges', 1, 'each', 'D', '4010', '5010', '1510', '5040', '1530', 0, 0, 0, 0);
1752 INSERT INTO `0_stock_category` VALUES(3, 'Systems', 1, 'each', 'M', '4010', '5010', '1510', '5040', '1530', 0, 0, 0, 0);
1753 INSERT INTO `0_stock_category` VALUES(4, 'Services', 1, 'hrs', 'D', '4010', '5010', '1510', '5040', '1530', 0, 0, 0, 0);
1755 -- --------------------------------------------------------
1758 -- Table structure for table `0_stock_master`
1761 DROP TABLE IF EXISTS `0_stock_master`;
1762 CREATE TABLE IF NOT EXISTS `0_stock_master` (
1763 `stock_id` varchar(20) NOT NULL default '',
1764 `category_id` int(11) NOT NULL default '0',
1765 `tax_type_id` int(11) NOT NULL default '0',
1766 `description` varchar(200) NOT NULL default '',
1767 `long_description` tinytext NOT NULL,
1768 `units` varchar(20) NOT NULL default 'each',
1769 `mb_flag` char(1) NOT NULL default 'B',
1770 `sales_account` varchar(15) NOT NULL default '',
1771 `cogs_account` varchar(15) NOT NULL default '',
1772 `inventory_account` varchar(15) NOT NULL default '',
1773 `adjustment_account` varchar(15) NOT NULL default '',
1774 `assembly_account` varchar(15) NOT NULL default '',
1775 `dimension_id` int(11) default NULL,
1776 `dimension2_id` int(11) default NULL,
1777 `actual_cost` double NOT NULL default '0',
1778 `last_cost` double NOT NULL default '0',
1779 `material_cost` double NOT NULL default '0',
1780 `labour_cost` double NOT NULL default '0',
1781 `overhead_cost` double NOT NULL default '0',
1782 `inactive` tinyint(1) NOT NULL default '0',
1783 `no_sale` tinyint(1) NOT NULL default '0',
1784 `editable` tinyint(1) NOT NULL default '0',
1785 PRIMARY KEY (`stock_id`)
1789 -- Dumping data for table `0_stock_master`
1792 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, 0);
1793 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, 0);
1794 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, 0);
1795 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, 0);
1796 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, 0);
1798 -- --------------------------------------------------------
1801 -- Table structure for table `0_stock_moves`
1804 DROP TABLE IF EXISTS `0_stock_moves`;
1805 CREATE TABLE IF NOT EXISTS `0_stock_moves` (
1806 `trans_id` int(11) NOT NULL auto_increment,
1807 `trans_no` int(11) NOT NULL default '0',
1808 `stock_id` char(20) NOT NULL default '',
1809 `type` smallint(6) NOT NULL default '0',
1810 `loc_code` char(5) NOT NULL default '',
1811 `tran_date` date NOT NULL default '0000-00-00',
1812 `person_id` int(11) default NULL,
1813 `price` double NOT NULL default '0',
1814 `reference` char(40) NOT NULL default '',
1815 `qty` double NOT NULL default '1',
1816 `discount_percent` double NOT NULL default '0',
1817 `standard_cost` double NOT NULL default '0',
1818 `visible` tinyint(1) NOT NULL default '1',
1819 PRIMARY KEY (`trans_id`),
1820 KEY `type` (`type`,`trans_no`),
1821 KEY `Move` (`stock_id`,`loc_code`,`tran_date`)
1822 ) ENGINE=InnoDB AUTO_INCREMENT=37 ;
1825 -- Dumping data for table `0_stock_moves`
1828 INSERT INTO `0_stock_moves` VALUES(1, 1, '102', 25, 'DEF', '2009-06-21', 2, 10, '', 100, 0, 10, 1);
1829 INSERT INTO `0_stock_moves` VALUES(2, 1, '103', 25, 'DEF', '2009-06-21', 2, 11, '', 100, 0, 11, 1);
1830 INSERT INTO `0_stock_moves` VALUES(3, 1, '104', 25, 'DEF', '2009-06-21', 2, 12, '', 100, 0, 12, 1);
1831 INSERT INTO `0_stock_moves` VALUES(4, 1, '102', 26, 'DEF', '2009-06-21', 0, 0, '1', -10, 0, 0, 1);
1832 INSERT INTO `0_stock_moves` VALUES(5, 1, '103', 26, 'DEF', '2009-06-21', 0, 0, '1', -10, 0, 0, 1);
1833 INSERT INTO `0_stock_moves` VALUES(6, 1, '104', 26, 'DEF', '2009-06-21', 0, 0, '1', -10, 0, 0, 1);
1834 INSERT INTO `0_stock_moves` VALUES(7, 1, '3400', 26, 'DEF', '2009-06-21', 0, 0, '1', 10, 0, 0, 1);
1835 INSERT INTO `0_stock_moves` VALUES(8, 2, '102', 13, 'DEF', '2009-06-21', 0, 30.4, '1', -2, 0, 10, 1);
1836 INSERT INTO `0_stock_moves` VALUES(9, 3, '102', 13, 'DEF', '2009-06-21', 0, 50, 'auto', -1, 0, 10, 1);
1837 INSERT INTO `0_stock_moves` VALUES(10, 4, '102', 13, 'DEF', '2009-06-21', 0, 35.89, 'auto', -1, 0, 10, 1);
1838 INSERT INTO `0_stock_moves` VALUES(11, 3, '102', 26, 'DEF', '2009-06-21', 0, 0, '3', -2, 0, 0, 1);
1839 INSERT INTO `0_stock_moves` VALUES(12, 3, '103', 26, 'DEF', '2009-06-21', 0, 0, '3', -2, 0, 0, 1);
1840 INSERT INTO `0_stock_moves` VALUES(13, 3, '104', 26, 'DEF', '2009-06-21', 0, 0, '3', -2, 0, 0, 1);
1841 INSERT INTO `0_stock_moves` VALUES(14, 3, '3400', 26, 'DEF', '2009-06-21', 0, 0, '3', 2, 0, 0, 1);
1842 INSERT INTO `0_stock_moves` VALUES(15, 4, '102', 26, 'DEF', '2009-06-21', 0, 0, '4', -4, 0, 0, 1);
1843 INSERT INTO `0_stock_moves` VALUES(16, 4, '103', 26, 'DEF', '2009-06-21', 0, 0, '4', -4, 0, 0, 1);
1844 INSERT INTO `0_stock_moves` VALUES(17, 4, '104', 26, 'DEF', '2009-06-21', 0, 0, '4', -4, 0, 0, 1);
1845 INSERT INTO `0_stock_moves` VALUES(18, 4, '3400', 26, 'DEF', '2009-06-21', 0, 0, '4', 4, 0, 0, 1);
1846 INSERT INTO `0_stock_moves` VALUES(19, 2, '102', 26, 'DEF', '2009-06-21', 0, 0, '', -2, 0, 0, 1);
1847 INSERT INTO `0_stock_moves` VALUES(20, 2, '103', 26, 'DEF', '2009-06-21', 0, 0, '', -2, 0, 0, 1);
1848 INSERT INTO `0_stock_moves` VALUES(21, 2, '104', 26, 'DEF', '2009-06-21', 0, 0, '', -2, 0, 0, 1);
1849 INSERT INTO `0_stock_moves` VALUES(22, 1, '3400', 29, 'DEF', '2009-06-21', 0, 0, '', 2, 0, 0, 1);
1850 INSERT INTO `0_stock_moves` VALUES(23, 5, '102', 26, 'DEF', '2009-06-21', 0, 0, '5', -5, 0, 0, 1);
1851 INSERT INTO `0_stock_moves` VALUES(24, 5, '103', 26, 'DEF', '2009-06-21', 0, 0, '5', -5, 0, 0, 1);
1852 INSERT INTO `0_stock_moves` VALUES(25, 5, '104', 26, 'DEF', '2009-06-21', 0, 0, '5', -5, 0, 0, 1);
1853 INSERT INTO `0_stock_moves` VALUES(26, 5, '3400', 26, 'DEF', '2009-06-21', 0, 0, '5', 5, 0, 0, 1);
1854 INSERT INTO `0_stock_moves` VALUES(27, 6, '102', 26, 'DEF', '2009-06-21', 0, 0, '6', 5, 0, 0, 1);
1855 INSERT INTO `0_stock_moves` VALUES(28, 6, '103', 26, 'DEF', '2009-06-21', 0, 0, '6', 5, 0, 0, 1);
1856 INSERT INTO `0_stock_moves` VALUES(29, 6, '104', 26, 'DEF', '2009-06-21', 0, 0, '6', 5, 0, 0, 1);
1857 INSERT INTO `0_stock_moves` VALUES(30, 6, '3400', 26, 'DEF', '2009-06-21', 0, 0, '6', -5, 0, 0, 1);
1858 INSERT INTO `0_stock_moves` VALUES(31, 7, '102', 26, 'DEF', '2009-06-21', 0, 0, '7', 2, 0, 0, 1);
1859 INSERT INTO `0_stock_moves` VALUES(32, 7, '103', 26, 'DEF', '2009-06-21', 0, 0, '7', 2, 0, 0, 1);
1860 INSERT INTO `0_stock_moves` VALUES(33, 7, '104', 26, 'DEF', '2009-06-21', 0, 0, '7', 2, 0, 0, 1);
1861 INSERT INTO `0_stock_moves` VALUES(34, 7, '3400', 26, 'DEF', '2009-06-21', 0, 0, '7', -2, 0, 0, 1);
1862 INSERT INTO `0_stock_moves` VALUES(35, 5, '102', 13, 'DEF', '2009-06-21', 0, 50, 'auto', -1, 0, 10, 1);
1863 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);
1865 -- --------------------------------------------------------
1868 -- Table structure for table `0_suppliers`
1871 DROP TABLE IF EXISTS `0_suppliers`;
1872 CREATE TABLE IF NOT EXISTS `0_suppliers` (
1873 `supplier_id` int(11) NOT NULL auto_increment,
1874 `supp_name` varchar(60) NOT NULL default '',
1875 `supp_ref` varchar(30) NOT NULL default '',
1876 `address` tinytext NOT NULL,
1877 `supp_address` tinytext NOT NULL,
1878 `gst_no` varchar(25) NOT NULL default '',
1879 `contact` varchar(60) NOT NULL default '',
1880 `supp_account_no` varchar(40) NOT NULL default '',
1881 `website` varchar(100) NOT NULL default '',
1882 `bank_account` varchar(60) NOT NULL default '',
1883 `curr_code` char(3) default NULL,
1884 `payment_terms` int(11) default NULL,
1885 `tax_included` tinyint(1) NOT NULL default '0',
1886 `tax_algorithm` tinyint(1) NOT NULL default '1',
1887 `dimension_id` int(11) default '0',
1888 `dimension2_id` int(11) default '0',
1889 `tax_group_id` int(11) default NULL,
1890 `credit_limit` double NOT NULL default '0',
1891 `purchase_account` varchar(15) NOT NULL default '',
1892 `payable_account` varchar(15) NOT NULL default '',
1893 `payment_discount_account` varchar(15) NOT NULL default '',
1894 `notes` tinytext NOT NULL,
1895 `inactive` tinyint(1) NOT NULL default '0',
1896 PRIMARY KEY (`supplier_id`),
1897 KEY `supp_ref` (`supp_ref`)
1898 ) ENGINE=MyISAM AUTO_INCREMENT=4 ;
1901 -- Dumping data for table `0_suppliers`
1904 INSERT INTO `0_suppliers` VALUES(1, 'Junk Beer ApS', 'Junk Beer', 'Mailing 1\nMailing 2\nMailing 3', 'Address 1\nAddress 2\nAddress 3', '123456', 'Contact', '111', '', '', 'DKK', 3, 0, 1, 1, 0, 2, 1000, '', '2100', '5060', 'A supplier with junk beers.', 0);
1905 INSERT INTO `0_suppliers` VALUES(2, 'Lucky Luke Inc.', 'Lucky Luke', 'Mailing 1\nMailing 2\nMailing 3', 'Address 1\nAddress 2\nAddress 3', '654321', 'Luke', '333', '', '', 'USD', 3, 0, 1, 0, 0, 1, 500, '', '2100', '5060', '', 0);
1906 INSERT INTO `0_suppliers` VALUES(3, 'Money Makers Ltd.', 'Money Makers', 'Mailing 1\nMailing 2\nMailing 3', 'Address 1\nAddress 2\nAddress 3', '987654', 'Makers', '222', '', '', 'GBP', 3, 0, 1, 0, 0, 2, 300, '', '2100', '5060', '', 0);
1908 -- --------------------------------------------------------
1911 -- Table structure for table `0_supp_allocations`
1914 DROP TABLE IF EXISTS `0_supp_allocations`;
1915 CREATE TABLE IF NOT EXISTS `0_supp_allocations` (
1916 `id` int(11) NOT NULL auto_increment,
1917 `amt` double unsigned default NULL,
1918 `date_alloc` date NOT NULL default '0000-00-00',
1919 `trans_no_from` int(11) default NULL,
1920 `trans_type_from` int(11) default NULL,
1921 `trans_no_to` int(11) default NULL,
1922 `trans_type_to` int(11) default NULL,
1924 KEY `From` (`trans_type_from`,`trans_no_from`),
1925 KEY `To` (`trans_type_to`,`trans_no_to`)
1926 ) ENGINE=InnoDB AUTO_INCREMENT=2 ;
1929 -- Dumping data for table `0_supp_allocations`
1932 INSERT INTO `0_supp_allocations` VALUES(1, 3465, '2009-06-21', 4, 22, 7, 20);
1934 -- --------------------------------------------------------
1937 -- Table structure for table `0_supp_invoice_items`
1940 DROP TABLE IF EXISTS `0_supp_invoice_items`;
1941 CREATE TABLE IF NOT EXISTS `0_supp_invoice_items` (
1942 `id` int(11) NOT NULL auto_increment,
1943 `supp_trans_no` int(11) default NULL,
1944 `supp_trans_type` int(11) default NULL,
1945 `gl_code` varchar(15) NOT NULL default '',
1946 `grn_item_id` int(11) default NULL,
1947 `po_detail_item_id` int(11) default NULL,
1948 `stock_id` varchar(20) NOT NULL default '',
1949 `description` tinytext,
1950 `quantity` double NOT NULL default '0',
1951 `unit_price` double NOT NULL default '0',
1952 `unit_tax` double NOT NULL default '0',
1955 KEY `Transaction` (`supp_trans_type`,`supp_trans_no`,`stock_id`)
1956 ) ENGINE=InnoDB AUTO_INCREMENT=6 ;
1959 -- Dumping data for table `0_supp_invoice_items`
1962 INSERT INTO `0_supp_invoice_items` VALUES(1, 7, 20, '0', 1, 1, '102', '17inch VGA Monitor', 100, 10, 0.5, '');
1963 INSERT INTO `0_supp_invoice_items` VALUES(2, 7, 20, '0', 2, 2, '103', '32MB VGA Card', 100, 11, 0.55, '');
1964 INSERT INTO `0_supp_invoice_items` VALUES(3, 7, 20, '0', 3, 3, '104', '52x CD Drive', 100, 12, 0.6, '');
1965 INSERT INTO `0_supp_invoice_items` VALUES(4, 8, 20, '2150', 0, 0, '', '', 0, 0.95, 0, 'Phone');
1966 INSERT INTO `0_supp_invoice_items` VALUES(5, 8, 20, '5780', 0, 0, '', '', 0, 19.05, 0, 'Phone');
1968 -- --------------------------------------------------------
1971 -- Table structure for table `0_supp_trans`
1974 DROP TABLE IF EXISTS `0_supp_trans`;
1975 CREATE TABLE IF NOT EXISTS `0_supp_trans` (
1976 `trans_no` int(11) unsigned NOT NULL default '0',
1977 `type` smallint(6) unsigned NOT NULL default '0',
1978 `supplier_id` int(11) unsigned default NULL,
1979 `reference` tinytext NOT NULL,
1980 `supp_reference` varchar(60) NOT NULL default '',
1981 `tran_date` date NOT NULL default '0000-00-00',
1982 `due_date` date NOT NULL default '0000-00-00',
1983 `ov_amount` double NOT NULL default '0',
1984 `ov_discount` double NOT NULL default '0',
1985 `ov_gst` double NOT NULL default '0',
1986 `rate` double NOT NULL default '1',
1987 `alloc` double NOT NULL default '0',
1988 `tax_included` tinyint(1) NOT NULL default '0',
1989 `tax_algorihm` tinyint(1) NOT NULL default '1',
1990 PRIMARY KEY (`type`,`trans_no`),
1991 KEY `supplier_id` (`supplier_id`),
1992 KEY `SupplierID_2` (`supplier_id`,`supp_reference`),
1993 KEY `type` (`type`),
1994 KEY `tran_date` (`tran_date`)
1998 -- Dumping data for table `0_supp_trans`
2001 INSERT INTO `0_supp_trans` VALUES(7, 20, 2, '1', '5t', '2009-06-21', '2009-07-01', 3300, 0, 165, 1, 3465, 0, 1);
2002 INSERT INTO `0_supp_trans` VALUES(8, 20, 2, '2', 'cc', '2009-06-21', '2009-07-01', 20, 0, 0, 1, 0, 0, 1);
2003 INSERT INTO `0_supp_trans` VALUES(4, 22, 2, '1', '', '2009-06-21', '2009-06-21', -3465, 0, 0, 1, 3465, 0, 1);
2005 -- --------------------------------------------------------
2008 -- Table structure for table `0_sys_prefs`
2011 DROP TABLE IF EXISTS `0_sys_prefs`;
2012 CREATE TABLE IF NOT EXISTS `0_sys_prefs` (
2013 `name` varchar(35) NOT NULL default '',
2014 `category` varchar(30) default NULL,
2015 `type` varchar(20) NOT NULL default '',
2016 `length` smallint(6) default NULL,
2018 PRIMARY KEY (`name`),
2019 KEY `category` (`category`)
2023 -- Dumping data for table `0_sys_prefs`
2026 INSERT INTO `0_sys_prefs` VALUES('coy_name', 'setup.company', 'varchar', 60, 'Training Co.');
2027 INSERT INTO `0_sys_prefs` VALUES('gst_no', 'setup.company', 'varchar', 25, '9876543');
2028 INSERT INTO `0_sys_prefs` VALUES('coy_no', 'setup.company', 'varchar', 25, '123456789');
2029 INSERT INTO `0_sys_prefs` VALUES('tax_prd', 'setup.company', 'int', 11, '1');
2030 INSERT INTO `0_sys_prefs` VALUES('tax_last', 'setup.company', 'int', 11, '1');
2031 INSERT INTO `0_sys_prefs` VALUES('postal_address', 'setup.company', 'tinytext', 0, 'Address 1\nAddress 2\nAddress 3');
2032 INSERT INTO `0_sys_prefs` VALUES('phone', 'setup.company', 'varchar', 30, '(222) 111.222.333');
2033 INSERT INTO `0_sys_prefs` VALUES('fax', 'setup.company', 'varchar', 30, '');
2034 INSERT INTO `0_sys_prefs` VALUES('email', 'setup.company', 'varchar', 100, 'delta@delta.com');
2035 INSERT INTO `0_sys_prefs` VALUES('coy_logo', 'setup.company', 'varchar', 100, 'logo_frontaccounting.jpg');
2036 INSERT INTO `0_sys_prefs` VALUES('domicile', 'setup.company', 'varchar', 55, '');
2037 INSERT INTO `0_sys_prefs` VALUES('curr_default', 'setup.company', 'char', 3, 'USD');
2038 INSERT INTO `0_sys_prefs` VALUES('use_dimension', 'setup.company', 'tinyint', 1, '1');
2039 INSERT INTO `0_sys_prefs` VALUES('f_year', 'setup.company', 'int', 11, '3');
2040 INSERT INTO `0_sys_prefs` VALUES('no_item_list', 'setup.company', 'tinyint', 1, '0');
2041 INSERT INTO `0_sys_prefs` VALUES('no_customer_list', 'setup.company', 'tinyint', 1, '0');
2042 INSERT INTO `0_sys_prefs` VALUES('no_supplier_list', 'setup.company', 'tinyint', 1, '0');
2043 INSERT INTO `0_sys_prefs` VALUES('base_sales', 'setup.company', 'int', 11, '1');
2044 INSERT INTO `0_sys_prefs` VALUES('time_zone', 'setup.company', 'tinyint', 1, '0');
2045 INSERT INTO `0_sys_prefs` VALUES('add_pct', 'setup.company', 'int', 5, '-1');
2046 INSERT INTO `0_sys_prefs` VALUES('round_to', 'setup.company', 'int', 5, '1');
2047 INSERT INTO `0_sys_prefs` VALUES('login_tout', 'setup.company', 'smallint', 6, '600');
2048 INSERT INTO `0_sys_prefs` VALUES('past_due_days', 'glsetup.general', 'int', 11, '30');
2049 INSERT INTO `0_sys_prefs` VALUES('profit_loss_year_act', 'glsetup.general', 'varchar', 15, '9990');
2050 INSERT INTO `0_sys_prefs` VALUES('retained_earnings_act', 'glsetup.general', 'varchar', 15, '3590');
2051 INSERT INTO `0_sys_prefs` VALUES('bank_charge_act', 'glsetup.general', 'varchar', 15, '5690');
2052 INSERT INTO `0_sys_prefs` VALUES('exchange_diff_act', 'glsetup.general', 'varchar', 15, '4450');
2053 INSERT INTO `0_sys_prefs` VALUES('tax_algorithm', 'glsetup.general', 'tinyint', 1, '1');
2054 INSERT INTO `0_sys_prefs` VALUES('default_credit_limit', 'glsetup.customer', 'int', 11, '1000');
2055 INSERT INTO `0_sys_prefs` VALUES('accumulate_shipping', 'glsetup.customer', 'tinyint', 1, '0');
2056 INSERT INTO `0_sys_prefs` VALUES('legal_text', 'glsetup.customer', 'tinytext', 0, '');
2057 INSERT INTO `0_sys_prefs` VALUES('freight_act', 'glsetup.customer', 'varchar', 15, '4430');
2058 INSERT INTO `0_sys_prefs` VALUES('debtors_act', 'glsetup.sales', 'varchar', 15, '1200');
2059 INSERT INTO `0_sys_prefs` VALUES('default_sales_act', 'glsetup.sales', 'varchar', 15, '4010');
2060 INSERT INTO `0_sys_prefs` VALUES('default_sales_discount_act', 'glsetup.sales', 'varchar', 15, '4510');
2061 INSERT INTO `0_sys_prefs` VALUES('default_prompt_payment_act', 'glsetup.sales', 'varchar', 15, '4500');
2062 INSERT INTO `0_sys_prefs` VALUES('default_delivery_required', 'glsetup.sales', 'smallint', 6, '1');
2063 INSERT INTO `0_sys_prefs` VALUES('default_receival_required', 'glsetup.purchase', 'smallint', 6, '10');
2064 INSERT INTO `0_sys_prefs` VALUES('default_dim_required', 'glsetup.dims', 'int', 11, '20');
2065 INSERT INTO `0_sys_prefs` VALUES('pyt_discount_act', 'glsetup.purchase', 'varchar', 15, '5060');
2066 INSERT INTO `0_sys_prefs` VALUES('creditors_act', 'glsetup.purchase', 'varchar', 15, '2100');
2067 INSERT INTO `0_sys_prefs` VALUES('po_over_receive', 'glsetup.purchase', 'int', 11, '10');
2068 INSERT INTO `0_sys_prefs` VALUES('po_over_charge', 'glsetup.purchase', 'int', 11, '10');
2069 INSERT INTO `0_sys_prefs` VALUES('allow_negative_stock', 'glsetup.inventory', 'tinyint', 1, '0');
2070 INSERT INTO `0_sys_prefs` VALUES('default_inventory_act', 'glsetup.items', 'varchar', 15, '1510');
2071 INSERT INTO `0_sys_prefs` VALUES('default_cogs_act', 'glsetup.items', 'varchar', 15, '5010');
2072 INSERT INTO `0_sys_prefs` VALUES('default_adj_act', 'glsetup.items', 'varchar', 15, '5040');
2073 INSERT INTO `0_sys_prefs` VALUES('default_inv_sales_act', 'glsetup.items', 'varchar', 15, '4010');
2074 INSERT INTO `0_sys_prefs` VALUES('default_assembly_act', 'glsetup.items', 'varchar', 15, '1530');
2075 INSERT INTO `0_sys_prefs` VALUES('default_workorder_required', 'glsetup.manuf', 'int', 11, '20');
2076 INSERT INTO `0_sys_prefs` VALUES('version_id', 'system', 'varchar', 11, '2.3rc');
2077 INSERT INTO `0_sys_prefs` VALUES('auto_curr_reval', 'setup.company', 'smallint', 6, '1');
2078 INSERT INTO `0_sys_prefs` VALUES('grn_clearing_act', 'glsetup.purchase', 'varchar', 15, '1550');
2080 -- --------------------------------------------------------
2083 -- Table structure for table `0_sys_types`
2086 DROP TABLE IF EXISTS `0_sys_types`;
2087 CREATE TABLE IF NOT EXISTS `0_sys_types` (
2088 `type_id` smallint(6) NOT NULL default '0',
2089 `type_no` int(11) NOT NULL default '1',
2090 `next_reference` varchar(100) NOT NULL default '',
2091 PRIMARY KEY (`type_id`)
2095 -- Dumping data for table `0_sys_types`
2098 INSERT INTO `0_sys_types` VALUES(0, 19, '3');
2099 INSERT INTO `0_sys_types` VALUES(1, 8, '2');
2100 INSERT INTO `0_sys_types` VALUES(2, 5, '2');
2101 INSERT INTO `0_sys_types` VALUES(4, 3, '1');
2102 INSERT INTO `0_sys_types` VALUES(10, 19, '4');
2103 INSERT INTO `0_sys_types` VALUES(11, 3, '2');
2104 INSERT INTO `0_sys_types` VALUES(12, 6, '1');
2105 INSERT INTO `0_sys_types` VALUES(13, 5, '2');
2106 INSERT INTO `0_sys_types` VALUES(16, 2, '1');
2107 INSERT INTO `0_sys_types` VALUES(17, 2, '1');
2108 INSERT INTO `0_sys_types` VALUES(18, 1, '3');
2109 INSERT INTO `0_sys_types` VALUES(20, 8, '3');
2110 INSERT INTO `0_sys_types` VALUES(21, 1, '1');
2111 INSERT INTO `0_sys_types` VALUES(22, 4, '2');
2112 INSERT INTO `0_sys_types` VALUES(25, 1, '2');
2113 INSERT INTO `0_sys_types` VALUES(26, 1, '8');
2114 INSERT INTO `0_sys_types` VALUES(28, 1, '1');
2115 INSERT INTO `0_sys_types` VALUES(29, 1, '2');
2116 INSERT INTO `0_sys_types` VALUES(30, 5, '6');
2117 INSERT INTO `0_sys_types` VALUES(32, 0, '1');
2118 INSERT INTO `0_sys_types` VALUES(35, 1, '1');
2119 INSERT INTO `0_sys_types` VALUES(40, 1, '3');
2121 -- --------------------------------------------------------
2124 -- Table structure for table `0_tags`
2127 DROP TABLE IF EXISTS `0_tags`;
2128 CREATE TABLE IF NOT EXISTS `0_tags` (
2129 `id` int(11) NOT NULL auto_increment,
2130 `type` smallint(6) NOT NULL,
2131 `name` varchar(30) NOT NULL,
2132 `description` varchar(60) default NULL,
2133 `inactive` tinyint(1) NOT NULL default '0',
2135 UNIQUE KEY `type` (`type`,`name`)
2136 ) ENGINE=MyISAM AUTO_INCREMENT=1 ;
2139 -- Dumping data for table `0_tags`
2143 -- --------------------------------------------------------
2146 -- Table structure for table `0_tag_associations`
2149 DROP TABLE IF EXISTS `0_tag_associations`;
2150 CREATE TABLE IF NOT EXISTS `0_tag_associations` (
2151 `record_id` varchar(15) NOT NULL,
2152 `tag_id` int(11) NOT NULL,
2153 UNIQUE KEY `record_id` (`record_id`,`tag_id`)
2157 -- Dumping data for table `0_tag_associations`
2161 -- --------------------------------------------------------
2164 -- Table structure for table `0_tax_groups`
2167 DROP TABLE IF EXISTS `0_tax_groups`;
2168 CREATE TABLE IF NOT EXISTS `0_tax_groups` (
2169 `id` int(11) NOT NULL auto_increment,
2170 `name` varchar(60) NOT NULL default '',
2171 `inactive` tinyint(1) NOT NULL default '0',
2173 UNIQUE KEY `name` (`name`)
2174 ) ENGINE=InnoDB AUTO_INCREMENT=3 ;
2177 -- Dumping data for table `0_tax_groups`
2180 INSERT INTO `0_tax_groups` VALUES(1, 'Tax', 0);
2181 INSERT INTO `0_tax_groups` VALUES(2, 'Tax Exempt', 0);
2183 -- --------------------------------------------------------
2186 -- Table structure for table `0_tax_group_items`
2189 DROP TABLE IF EXISTS `0_tax_group_items`;
2190 CREATE TABLE IF NOT EXISTS `0_tax_group_items` (
2191 `tax_group_id` int(11) NOT NULL default '0',
2192 `tax_type_id` int(11) NOT NULL default '0',
2193 `tax_shipping` tinyint(1) NOT NULL default '0',
2194 PRIMARY KEY (`tax_group_id`,`tax_type_id`)
2198 -- Dumping data for table `0_tax_group_items`
2201 INSERT INTO `0_tax_group_items` VALUES(1, 1, 1);
2203 -- --------------------------------------------------------
2206 -- Table structure for table `0_tax_types`
2209 DROP TABLE IF EXISTS `0_tax_types`;
2210 CREATE TABLE IF NOT EXISTS `0_tax_types` (
2211 `id` int(11) NOT NULL auto_increment,
2212 `rate` double NOT NULL default '0',
2213 `sales_gl_code` varchar(15) NOT NULL default '',
2214 `purchasing_gl_code` varchar(15) NOT NULL default '',
2215 `name` varchar(60) NOT NULL default '',
2216 `inactive` tinyint(1) NOT NULL default '0',
2218 ) ENGINE=InnoDB AUTO_INCREMENT=2 ;
2221 -- Dumping data for table `0_tax_types`
2224 INSERT INTO `0_tax_types` VALUES(1, 5, '2150', '2150', 'Tax', 0);
2226 -- --------------------------------------------------------
2229 -- Table structure for table `0_trans_tax_details`
2232 DROP TABLE IF EXISTS `0_trans_tax_details`;
2233 CREATE TABLE IF NOT EXISTS `0_trans_tax_details` (
2234 `id` int(11) NOT NULL auto_increment,
2235 `trans_type` smallint(6) default NULL,
2236 `trans_no` int(11) default NULL,
2237 `tran_date` date NOT NULL,
2238 `tax_type_id` int(11) NOT NULL default '0',
2239 `rate` double NOT NULL default '0',
2240 `ex_rate` double NOT NULL default '1',
2241 `included_in_price` tinyint(1) NOT NULL default '0',
2242 `net_amount` double NOT NULL default '0',
2243 `amount` double NOT NULL default '0',
2246 KEY `Type_and_Number` (`trans_type`,`trans_no`),
2247 KEY `tran_date` (`tran_date`)
2248 ) ENGINE=InnoDB AUTO_INCREMENT=12 ;
2251 -- Dumping data for table `0_trans_tax_details`
2254 INSERT INTO `0_trans_tax_details` VALUES(1, 20, 7, '2009-06-21', 1, 5, 1, 0, 3300, 165, '5t');
2255 INSERT INTO `0_trans_tax_details` VALUES(2, 13, 3, '2009-06-21', 1, 5, 1, 0, 50, 2.5, 'auto');
2256 INSERT INTO `0_trans_tax_details` VALUES(3, 10, 17, '2009-06-21', 1, 5, 1, 0, 50, 2.5, '1');
2257 INSERT INTO `0_trans_tax_details` VALUES(4, 13, 4, '2009-06-21', 1, 5, 1.3932, 0, 35.89, 1.7945, 'auto');
2258 INSERT INTO `0_trans_tax_details` VALUES(5, 10, 18, '2009-06-21', 1, 5, 1.3932, 0, 35.89, 1.7945, '2');
2259 INSERT INTO `0_trans_tax_details` VALUES(6, 2, 5, '2009-06-21', 1, 5, 1, 0, 95.2, 4.76, '');
2260 INSERT INTO `0_trans_tax_details` VALUES(7, 1, 8, '2009-06-21', 1, 5, 1, 0, -47.6, -2.38, '');
2261 INSERT INTO `0_trans_tax_details` VALUES(8, 20, 8, '2009-06-21', 1, 5, 1, 0, -19, -0.95, 'cc');
2262 INSERT INTO `0_trans_tax_details` VALUES(9, 13, 5, '2009-06-21', 1, 5, 1, 1, 47.619047619048, 2.3809523809524, 'auto');
2263 INSERT INTO `0_trans_tax_details` VALUES(10, 10, 19, '2009-06-21', 1, 5, 1, 1, 47.619047619048, 2.3809523809524, '3');
2264 INSERT INTO `0_trans_tax_details` VALUES(11, 11, 3, '2009-06-21', 1, 5, 1.3932, 0, 35.89, 1.7945, '1');
2266 -- --------------------------------------------------------
2269 -- Table structure for table `0_useronline`
2272 DROP TABLE IF EXISTS `0_useronline`;
2273 CREATE TABLE IF NOT EXISTS `0_useronline` (
2274 `id` int(11) NOT NULL auto_increment,
2275 `timestamp` int(15) NOT NULL default '0',
2276 `ip` varchar(40) NOT NULL default '',
2277 `file` varchar(100) NOT NULL default '',
2279 KEY `timestamp` (`timestamp`),
2281 ) ENGINE=MyISAM AUTO_INCREMENT=1 ;
2284 -- Dumping data for table `0_useronline`
2288 -- --------------------------------------------------------
2291 -- Table structure for table `0_users`
2294 DROP TABLE IF EXISTS `0_users`;
2295 CREATE TABLE IF NOT EXISTS `0_users` (
2296 `id` smallint(6) NOT NULL auto_increment,
2297 `user_id` varchar(60) NOT NULL default '',
2298 `password` varchar(100) NOT NULL default '',
2299 `real_name` varchar(100) NOT NULL default '',
2300 `role_id` int(11) NOT NULL default '1',
2301 `phone` varchar(30) NOT NULL default '',
2302 `email` varchar(100) default NULL,
2303 `language` varchar(20) default NULL,
2304 `date_format` tinyint(1) NOT NULL default '0',
2305 `date_sep` tinyint(1) NOT NULL default '0',
2306 `tho_sep` tinyint(1) NOT NULL default '0',
2307 `dec_sep` tinyint(1) NOT NULL default '0',
2308 `theme` varchar(20) NOT NULL default 'default',
2309 `page_size` varchar(20) NOT NULL default 'A4',
2310 `prices_dec` smallint(6) NOT NULL default '2',
2311 `qty_dec` smallint(6) NOT NULL default '2',
2312 `rates_dec` smallint(6) NOT NULL default '4',
2313 `percent_dec` smallint(6) NOT NULL default '1',
2314 `show_gl` tinyint(1) NOT NULL default '1',
2315 `show_codes` tinyint(1) NOT NULL default '0',
2316 `show_hints` tinyint(1) NOT NULL default '0',
2317 `last_visit_date` datetime default NULL,
2318 `query_size` tinyint(1) default '10',
2319 `graphic_links` tinyint(1) default '1',
2320 `pos` smallint(6) default '1',
2321 `print_profile` varchar(30) NOT NULL default '1',
2322 `rep_popup` tinyint(1) default '1',
2323 `sticky_doc_date` tinyint(1) default '0',
2324 `startup_tab` varchar(20) NOT NULL default '',
2325 `transaction_days` smallint(6) NOT NULL default '0',
2326 `inactive` tinyint(1) NOT NULL default '0',
2328 UNIQUE KEY `user_id` (`user_id`)
2329 ) ENGINE=MyISAM AUTO_INCREMENT=3 ;
2332 -- Dumping data for table `0_users`
2335 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, '2010-05-11 23:27:46', 10, 1, 1, '1', 1, 0, 'orders', 30, 0);
2336 INSERT INTO `0_users` VALUES(2, 'demouser', '5f4dcc3b5aa765d61d8327deb882cf99', 'Demo User', 9, '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', 30, 0);
2338 -- --------------------------------------------------------
2341 -- Table structure for table `0_voided`
2344 DROP TABLE IF EXISTS `0_voided`;
2345 CREATE TABLE IF NOT EXISTS `0_voided` (
2346 `type` int(11) NOT NULL default '0',
2347 `id` int(11) NOT NULL default '0',
2348 `date_` date NOT NULL default '0000-00-00',
2349 `memo_` tinytext NOT NULL,
2350 UNIQUE KEY `id` (`type`,`id`)
2354 -- Dumping data for table `0_voided`
2358 -- --------------------------------------------------------
2361 -- Table structure for table `0_workcentres`
2364 DROP TABLE IF EXISTS `0_workcentres`;
2365 CREATE TABLE IF NOT EXISTS `0_workcentres` (
2366 `id` int(11) NOT NULL auto_increment,
2367 `name` char(40) NOT NULL default '',
2368 `description` char(50) NOT NULL default '',
2369 `inactive` tinyint(1) NOT NULL default '0',
2371 UNIQUE KEY `name` (`name`)
2372 ) ENGINE=MyISAM AUTO_INCREMENT=2 ;
2375 -- Dumping data for table `0_workcentres`
2378 INSERT INTO `0_workcentres` VALUES(1, 'Workshop', 'Workshop in Alabama', 0);
2380 -- --------------------------------------------------------
2383 -- Table structure for table `0_workorders`
2386 DROP TABLE IF EXISTS `0_workorders`;
2387 CREATE TABLE IF NOT EXISTS `0_workorders` (
2388 `id` int(11) NOT NULL auto_increment,
2389 `wo_ref` varchar(60) NOT NULL default '',
2390 `loc_code` varchar(5) NOT NULL default '',
2391 `units_reqd` double NOT NULL default '1',
2392 `stock_id` varchar(20) NOT NULL default '',
2393 `date_` date NOT NULL default '0000-00-00',
2394 `type` tinyint(4) NOT NULL default '0',
2395 `required_by` date NOT NULL default '0000-00-00',
2396 `released_date` date NOT NULL default '0000-00-00',
2397 `units_issued` double NOT NULL default '0',
2398 `closed` tinyint(1) NOT NULL default '0',
2399 `released` tinyint(1) NOT NULL default '0',
2400 `additional_costs` double NOT NULL default '0',
2402 UNIQUE KEY `wo_ref` (`wo_ref`)
2403 ) ENGINE=InnoDB AUTO_INCREMENT=8 ;
2406 -- Dumping data for table `0_workorders`
2409 INSERT INTO `0_workorders` VALUES(1, '1', 'DEF', 10, '3400', '2009-06-21', 0, '2009-06-21', '2009-06-21', 10, 1, 1, 10);
2410 INSERT INTO `0_workorders` VALUES(2, '2', 'DEF', 3, '3400', '2009-06-21', 2, '2009-07-11', '2009-06-21', 2, 0, 1, 0);
2411 INSERT INTO `0_workorders` VALUES(3, '3', 'DEF', 2, '3400', '2009-06-21', 0, '2009-06-21', '2009-06-21', 2, 1, 1, 0);
2412 INSERT INTO `0_workorders` VALUES(4, '4', 'DEF', 4, '3400', '2009-06-21', 0, '2009-06-21', '2009-06-21', 4, 1, 1, 0);
2413 INSERT INTO `0_workorders` VALUES(5, '5', 'DEF', 5, '3400', '2009-06-21', 0, '2009-06-21', '2009-06-21', 5, 1, 1, 10);
2414 INSERT INTO `0_workorders` VALUES(6, '6', 'DEF', -5, '3400', '2009-06-21', 1, '2009-06-21', '2009-06-21', -5, 1, 1, 0);
2415 INSERT INTO `0_workorders` VALUES(7, '7', 'DEF', -2, '3400', '2009-06-21', 1, '2009-06-21', '2009-06-21', -2, 1, 1, 10);
2417 -- --------------------------------------------------------
2420 -- Table structure for table `0_wo_issues`
2423 DROP TABLE IF EXISTS `0_wo_issues`;
2424 CREATE TABLE IF NOT EXISTS `0_wo_issues` (
2425 `issue_no` int(11) NOT NULL auto_increment,
2426 `workorder_id` int(11) NOT NULL default '0',
2427 `reference` varchar(100) default NULL,
2428 `issue_date` date default NULL,
2429 `loc_code` varchar(5) default NULL,
2430 `workcentre_id` int(11) default NULL,
2431 PRIMARY KEY (`issue_no`),
2432 KEY `workorder_id` (`workorder_id`)
2433 ) ENGINE=InnoDB AUTO_INCREMENT=1 ;
2436 -- Dumping data for table `0_wo_issues`
2440 -- --------------------------------------------------------
2443 -- Table structure for table `0_wo_issue_items`
2446 DROP TABLE IF EXISTS `0_wo_issue_items`;
2447 CREATE TABLE IF NOT EXISTS `0_wo_issue_items` (
2448 `id` int(11) NOT NULL auto_increment,
2449 `stock_id` varchar(40) default NULL,
2450 `issue_id` int(11) default NULL,
2451 `qty_issued` double default NULL,
2453 ) ENGINE=InnoDB AUTO_INCREMENT=1 ;
2456 -- Dumping data for table `0_wo_issue_items`
2460 -- --------------------------------------------------------
2463 -- Table structure for table `0_wo_manufacture`
2466 DROP TABLE IF EXISTS `0_wo_manufacture`;
2467 CREATE TABLE IF NOT EXISTS `0_wo_manufacture` (
2468 `id` int(11) NOT NULL auto_increment,
2469 `reference` varchar(100) default NULL,
2470 `workorder_id` int(11) NOT NULL default '0',
2471 `quantity` double NOT NULL default '0',
2472 `date_` date NOT NULL default '0000-00-00',
2474 KEY `workorder_id` (`workorder_id`)
2475 ) ENGINE=InnoDB AUTO_INCREMENT=2 ;
2478 -- Dumping data for table `0_wo_manufacture`
2481 INSERT INTO `0_wo_manufacture` VALUES(1, '1', 2, 2, '2009-06-21');
2483 -- --------------------------------------------------------
2486 -- Table structure for table `0_wo_requirements`
2489 DROP TABLE IF EXISTS `0_wo_requirements`;
2490 CREATE TABLE IF NOT EXISTS `0_wo_requirements` (
2491 `id` int(11) NOT NULL auto_increment,
2492 `workorder_id` int(11) NOT NULL default '0',
2493 `stock_id` char(20) NOT NULL default '',
2494 `workcentre` int(11) NOT NULL default '0',
2495 `units_req` double NOT NULL default '1',
2496 `std_cost` double NOT NULL default '0',
2497 `loc_code` char(5) NOT NULL default '',
2498 `units_issued` double NOT NULL default '0',
2500 KEY `workorder_id` (`workorder_id`)
2501 ) ENGINE=InnoDB AUTO_INCREMENT=22 ;
2504 -- Dumping data for table `0_wo_requirements`
2507 INSERT INTO `0_wo_requirements` VALUES(1, 1, '102', 1, 1, 0, 'DEF', 10);
2508 INSERT INTO `0_wo_requirements` VALUES(2, 1, '103', 1, 1, 0, 'DEF', 10);
2509 INSERT INTO `0_wo_requirements` VALUES(3, 1, '104', 1, 1, 0, 'DEF', 10);
2510 INSERT INTO `0_wo_requirements` VALUES(4, 2, '102', 1, 1, 0, 'DEF', 0);
2511 INSERT INTO `0_wo_requirements` VALUES(5, 2, '103', 1, 1, 0, 'DEF', 0);
2512 INSERT INTO `0_wo_requirements` VALUES(6, 2, '104', 1, 1, 0, 'DEF', 0);
2513 INSERT INTO `0_wo_requirements` VALUES(7, 3, '102', 1, 1, 0, 'DEF', 2);
2514 INSERT INTO `0_wo_requirements` VALUES(8, 3, '103', 1, 1, 0, 'DEF', 2);
2515 INSERT INTO `0_wo_requirements` VALUES(9, 3, '104', 1, 1, 0, 'DEF', 2);
2516 INSERT INTO `0_wo_requirements` VALUES(10, 4, '102', 1, 1, 0, 'DEF', 4);
2517 INSERT INTO `0_wo_requirements` VALUES(11, 4, '103', 1, 1, 0, 'DEF', 4);
2518 INSERT INTO `0_wo_requirements` VALUES(12, 4, '104', 1, 1, 0, 'DEF', 4);
2519 INSERT INTO `0_wo_requirements` VALUES(13, 5, '102', 1, 1, 0, 'DEF', 5);
2520 INSERT INTO `0_wo_requirements` VALUES(14, 5, '103', 1, 1, 0, 'DEF', 5);
2521 INSERT INTO `0_wo_requirements` VALUES(15, 5, '104', 1, 1, 0, 'DEF', 5);
2522 INSERT INTO `0_wo_requirements` VALUES(16, 6, '102', 1, 1, 0, 'DEF', -5);
2523 INSERT INTO `0_wo_requirements` VALUES(17, 6, '103', 1, 1, 0, 'DEF', -5);
2524 INSERT INTO `0_wo_requirements` VALUES(18, 6, '104', 1, 1, 0, 'DEF', -5);
2525 INSERT INTO `0_wo_requirements` VALUES(19, 7, '102', 1, 1, 0, 'DEF', -2);
2526 INSERT INTO `0_wo_requirements` VALUES(20, 7, '103', 1, 1, 0, 'DEF', -2);
2527 INSERT INTO `0_wo_requirements` VALUES(21, 7, '104', 1, 1, 0, 'DEF', -2);