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 `last_reconciled_date` timestamp NOT NULL default '0000-00-00 00:00:00',
106 `ending_reconcile_balance` double NOT NULL default '0',
107 `inactive` tinyint(1) NOT NULL default '0',
109 KEY `bank_account_name` (`bank_account_name`),
110 KEY `bank_account_number` (`bank_account_number`),
111 KEY `account_code` (`account_code`)
112 ) ENGINE=MyISAM AUTO_INCREMENT=3 ;
115 -- Dumping data for table `0_bank_accounts`
118 INSERT INTO `0_bank_accounts` VALUES('1060', 0, 'Current account', '9999999999', 'Wachovia Bank', '', 'USD', 1, 1, '0000-00-00 00:00:00', 0, 0);
119 INSERT INTO `0_bank_accounts` VALUES('1065', 3, 'Petty Cash account', 'N/A', 'N/A', '', 'USD', 0, 2, '0000-00-00 00:00:00', 0, 0);
121 -- --------------------------------------------------------
124 -- Table structure for table `0_bank_trans`
127 DROP TABLE IF EXISTS `0_bank_trans`;
128 CREATE TABLE IF NOT EXISTS `0_bank_trans` (
129 `id` int(11) NOT NULL auto_increment,
130 `type` smallint(6) default NULL,
131 `trans_no` int(11) default NULL,
132 `bank_act` varchar(15) NOT NULL default '',
133 `ref` varchar(40) default NULL,
134 `trans_date` date NOT NULL default '0000-00-00',
135 `amount` double default NULL,
136 `dimension_id` int(11) NOT NULL default '0',
137 `dimension2_id` int(11) NOT NULL default '0',
138 `person_type_id` int(11) NOT NULL default '0',
139 `person_id` tinyblob,
140 `reconciled` date default NULL,
142 KEY `bank_act` (`bank_act`,`ref`),
143 KEY `type` (`type`,`trans_no`),
144 KEY `bank_act_2` (`bank_act`,`reconciled`),
145 KEY `bank_act_3` (`bank_act`,`trans_date`)
146 ) ENGINE=InnoDB AUTO_INCREMENT=12 ;
149 -- Dumping data for table `0_bank_trans`
152 INSERT INTO `0_bank_trans` VALUES(1, 22, 4, '1', '1', '2009-06-21', -3465, 0, 0, 3, '2', NULL);
153 INSERT INTO `0_bank_trans` VALUES(2, 26, 1, '1', '', '2009-06-21', -10, 0, 0, 1, '1', NULL);
154 INSERT INTO `0_bank_trans` VALUES(3, 26, 1, '1', '', '2009-06-21', -20, 0, 0, 1, '0', NULL);
155 INSERT INTO `0_bank_trans` VALUES(4, 0, 18, '1', '1', '2009-02-20', 1000, 0, 0, 0, '', NULL);
156 INSERT INTO `0_bank_trans` VALUES(5, 0, 19, '1', '2', '2009-02-21', 4000, 0, 0, 0, '', NULL);
157 INSERT INTO `0_bank_trans` VALUES(6, 2, 5, '1', '1', '2009-06-21', 100, 0, 0, 4, '3', NULL);
158 INSERT INTO `0_bank_trans` VALUES(7, 1, 8, '1', '1', '2009-06-21', -50, 0, 0, 4, '1', NULL);
159 INSERT INTO `0_bank_trans` VALUES(8, 26, 5, '1', '', '2009-06-21', -10, 0, 0, 1, '1', NULL);
160 INSERT INTO `0_bank_trans` VALUES(9, 26, 5, '1', '', '2009-06-21', -20, 0, 0, 1, '0', NULL);
161 INSERT INTO `0_bank_trans` VALUES(10, 26, 7, '1', '', '2009-06-21', -10, 0, 0, 1, '1', NULL);
162 INSERT INTO `0_bank_trans` VALUES(11, 26, 7, '1', '', '2009-06-21', -20, 0, 0, 1, '0', NULL);
164 -- --------------------------------------------------------
167 -- Table structure for table `0_bom`
170 DROP TABLE IF EXISTS `0_bom`;
171 CREATE TABLE IF NOT EXISTS `0_bom` (
172 `id` int(11) NOT NULL auto_increment,
173 `parent` char(20) NOT NULL default '',
174 `component` char(20) NOT NULL default '',
175 `workcentre_added` int(11) NOT NULL default '0',
176 `loc_code` char(5) NOT NULL default '',
177 `quantity` double NOT NULL default '1',
178 PRIMARY KEY (`parent`,`component`,`workcentre_added`,`loc_code`),
179 KEY `component` (`component`),
181 KEY `loc_code` (`loc_code`),
182 KEY `parent` (`parent`,`loc_code`),
183 KEY `workcentre_added` (`workcentre_added`)
184 ) ENGINE=MyISAM AUTO_INCREMENT=4 ;
187 -- Dumping data for table `0_bom`
190 INSERT INTO `0_bom` VALUES(1, '3400', '102', 1, 'DEF', 1);
191 INSERT INTO `0_bom` VALUES(2, '3400', '103', 1, 'DEF', 1);
192 INSERT INTO `0_bom` VALUES(3, '3400', '104', 1, 'DEF', 1);
194 -- --------------------------------------------------------
197 -- Table structure for table `0_budget_trans`
200 DROP TABLE IF EXISTS `0_budget_trans`;
201 CREATE TABLE IF NOT EXISTS `0_budget_trans` (
202 `counter` int(11) NOT NULL auto_increment,
203 `type` smallint(6) NOT NULL default '0',
204 `type_no` bigint(16) NOT NULL default '1',
205 `tran_date` date NOT NULL default '0000-00-00',
206 `account` varchar(15) NOT NULL default '',
207 `memo_` tinytext NOT NULL,
208 `amount` double NOT NULL default '0',
209 `dimension_id` int(11) default '0',
210 `dimension2_id` int(11) default '0',
211 `person_type_id` int(11) default NULL,
212 `person_id` tinyblob,
213 PRIMARY KEY (`counter`),
214 KEY `Type_and_Number` (`type`,`type_no`),
215 KEY `Account` (`account`,`tran_date`,`dimension_id`,`dimension2_id`)
216 ) ENGINE=InnoDB AUTO_INCREMENT=1 ;
219 -- Dumping data for table `0_budget_trans`
223 -- --------------------------------------------------------
226 -- Table structure for table `0_chart_class`
229 DROP TABLE IF EXISTS `0_chart_class`;
230 CREATE TABLE IF NOT EXISTS `0_chart_class` (
231 `cid` varchar(3) NOT NULL,
232 `class_name` varchar(60) NOT NULL default '',
233 `ctype` tinyint(1) NOT NULL default '0',
234 `inactive` tinyint(1) NOT NULL default '0',
239 -- Dumping data for table `0_chart_class`
242 INSERT INTO `0_chart_class` VALUES('1', 'Assets', 1, 0);
243 INSERT INTO `0_chart_class` VALUES('2', 'Liabilities', 2, 0);
244 INSERT INTO `0_chart_class` VALUES('3', 'Income', 4, 0);
245 INSERT INTO `0_chart_class` VALUES('4', 'Costs', 6, 0);
247 -- --------------------------------------------------------
250 -- Table structure for table `0_chart_master`
253 DROP TABLE IF EXISTS `0_chart_master`;
254 CREATE TABLE IF NOT EXISTS `0_chart_master` (
255 `account_code` varchar(15) NOT NULL default '',
256 `account_code2` varchar(15) NOT NULL default '',
257 `account_name` varchar(60) NOT NULL default '',
258 `account_type` varchar(10) NOT NULL default '0',
259 `inactive` tinyint(1) NOT NULL default '0',
260 PRIMARY KEY (`account_code`),
261 KEY `account_name` (`account_name`),
262 KEY `accounts_by_type` (`account_type`,`account_code`)
266 -- Dumping data for table `0_chart_master`
269 INSERT INTO `0_chart_master` VALUES('1060', '', 'Checking Account', '1', 0);
270 INSERT INTO `0_chart_master` VALUES('1065', '', 'Petty Cash', '1', 0);
271 INSERT INTO `0_chart_master` VALUES('1200', '', 'Accounts Receivables', '1', 0);
272 INSERT INTO `0_chart_master` VALUES('1205', '', 'Allowance for doubtful accounts', '1', 0);
273 INSERT INTO `0_chart_master` VALUES('1510', '', 'Inventory', '2', 0);
274 INSERT INTO `0_chart_master` VALUES('1520', '', 'Stocks of Raw Materials', '2', 0);
275 INSERT INTO `0_chart_master` VALUES('1530', '', 'Stocks of Work In Progress', '2', 0);
276 INSERT INTO `0_chart_master` VALUES('1540', '', 'Stocks of Finsihed Goods', '2', 0);
277 INSERT INTO `0_chart_master` VALUES('1550', '', 'Goods Received Clearing account', '2', 0);
278 INSERT INTO `0_chart_master` VALUES('1820', '', 'Office Furniture & Equipment', '3', 0);
279 INSERT INTO `0_chart_master` VALUES('1825', '', 'Accum. Amort. -Furn. & Equip.', '3', 0);
280 INSERT INTO `0_chart_master` VALUES('1840', '', 'Vehicle', '3', 0);
281 INSERT INTO `0_chart_master` VALUES('1845', '', 'Accum. Amort. -Vehicle', '3', 0);
282 INSERT INTO `0_chart_master` VALUES('2100', '', 'Accounts Payable', '4', 0);
283 INSERT INTO `0_chart_master` VALUES('2110', '', 'Accrued Income Tax - Federal', '4', 0);
284 INSERT INTO `0_chart_master` VALUES('2120', '', 'Accrued Income Tax - State', '4', 0);
285 INSERT INTO `0_chart_master` VALUES('2130', '', 'Accrued Franchise Tax', '4', 0);
286 INSERT INTO `0_chart_master` VALUES('2140', '', 'Accrued Real & Personal Prop Tax', '4', 0);
287 INSERT INTO `0_chart_master` VALUES('2150', '', 'Sales Tax', '4', 0);
288 INSERT INTO `0_chart_master` VALUES('2160', '', 'Accrued Use Tax Payable', '4', 0);
289 INSERT INTO `0_chart_master` VALUES('2210', '', 'Accrued Wages', '4', 0);
290 INSERT INTO `0_chart_master` VALUES('2220', '', 'Accrued Comp Time', '4', 0);
291 INSERT INTO `0_chart_master` VALUES('2230', '', 'Accrued Holiday Pay', '4', 0);
292 INSERT INTO `0_chart_master` VALUES('2240', '', 'Accrued Vacation Pay', '4', 0);
293 INSERT INTO `0_chart_master` VALUES('2310', '', 'Accr. Benefits - 401K', '4', 0);
294 INSERT INTO `0_chart_master` VALUES('2320', '', 'Accr. Benefits - Stock Purchase', '4', 0);
295 INSERT INTO `0_chart_master` VALUES('2330', '', 'Accr. Benefits - Med, Den', '4', 0);
296 INSERT INTO `0_chart_master` VALUES('2340', '', 'Accr. Benefits - Payroll Taxes', '4', 0);
297 INSERT INTO `0_chart_master` VALUES('2350', '', 'Accr. Benefits - Credit Union', '4', 0);
298 INSERT INTO `0_chart_master` VALUES('2360', '', 'Accr. Benefits - Savings Bond', '4', 0);
299 INSERT INTO `0_chart_master` VALUES('2370', '', 'Accr. Benefits - Garnish', '4', 0);
300 INSERT INTO `0_chart_master` VALUES('2380', '', 'Accr. Benefits - Charity Cont.', '4', 0);
301 INSERT INTO `0_chart_master` VALUES('2620', '', 'Bank Loans', '5', 0);
302 INSERT INTO `0_chart_master` VALUES('2680', '', 'Loans from Shareholders', '5', 0);
303 INSERT INTO `0_chart_master` VALUES('3350', '', 'Common Shares', '6', 0);
304 INSERT INTO `0_chart_master` VALUES('3590', '', 'Retained Earnings - prior years', '7', 0);
305 INSERT INTO `0_chart_master` VALUES('4010', '', 'Sales', '8', 0);
306 INSERT INTO `0_chart_master` VALUES('4430', '', 'Shipping & Handling', '9', 0);
307 INSERT INTO `0_chart_master` VALUES('4440', '', 'Interest', '9', 0);
308 INSERT INTO `0_chart_master` VALUES('4450', '', 'Foreign Exchange Gain', '9', 0);
309 INSERT INTO `0_chart_master` VALUES('4500', '', 'Prompt Payment Discounts', '9', 0);
310 INSERT INTO `0_chart_master` VALUES('4510', '', 'Discounts Given', '9', 0);
311 INSERT INTO `0_chart_master` VALUES('5010', '', 'Cost of Goods Sold - Retail', '10', 0);
312 INSERT INTO `0_chart_master` VALUES('5020', '', 'Material Usage Varaiance', '10', 0);
313 INSERT INTO `0_chart_master` VALUES('5030', '', 'Consumable Materials', '10', 0);
314 INSERT INTO `0_chart_master` VALUES('5040', '', 'Purchase price Variance', '10', 0);
315 INSERT INTO `0_chart_master` VALUES('5050', '', 'Purchases of materials', '10', 0);
316 INSERT INTO `0_chart_master` VALUES('5060', '', 'Discounts Received', '10', 0);
317 INSERT INTO `0_chart_master` VALUES('5100', '', 'Freight', '10', 0);
318 INSERT INTO `0_chart_master` VALUES('5410', '', 'Wages & Salaries', '11', 0);
319 INSERT INTO `0_chart_master` VALUES('5420', '', 'Wages - Overtime', '11', 0);
320 INSERT INTO `0_chart_master` VALUES('5430', '', 'Benefits - Comp Time', '11', 0);
321 INSERT INTO `0_chart_master` VALUES('5440', '', 'Benefits - Payroll Taxes', '11', 0);
322 INSERT INTO `0_chart_master` VALUES('5450', '', 'Benefits - Workers Comp', '11', 0);
323 INSERT INTO `0_chart_master` VALUES('5460', '', 'Benefits - Pension', '11', 0);
324 INSERT INTO `0_chart_master` VALUES('5470', '', 'Benefits - General Benefits', '11', 0);
325 INSERT INTO `0_chart_master` VALUES('5510', '', 'Inc Tax Exp - Federal', '11', 0);
326 INSERT INTO `0_chart_master` VALUES('5520', '', 'Inc Tax Exp - State', '11', 0);
327 INSERT INTO `0_chart_master` VALUES('5530', '', 'Taxes - Real Estate', '11', 0);
328 INSERT INTO `0_chart_master` VALUES('5540', '', 'Taxes - Personal Property', '11', 0);
329 INSERT INTO `0_chart_master` VALUES('5550', '', 'Taxes - Franchise', '11', 0);
330 INSERT INTO `0_chart_master` VALUES('5560', '', 'Taxes - Foreign Withholding', '11', 0);
331 INSERT INTO `0_chart_master` VALUES('5610', '', 'Accounting & Legal', '12', 0);
332 INSERT INTO `0_chart_master` VALUES('5615', '', 'Advertising & Promotions', '12', 0);
333 INSERT INTO `0_chart_master` VALUES('5620', '', 'Bad Debts', '12', 0);
334 INSERT INTO `0_chart_master` VALUES('5660', '', 'Amortization Expense', '12', 0);
335 INSERT INTO `0_chart_master` VALUES('5685', '', 'Insurance', '12', 0);
336 INSERT INTO `0_chart_master` VALUES('5690', '', 'Interest & Bank Charges', '12', 0);
337 INSERT INTO `0_chart_master` VALUES('5700', '', 'Office Supplies', '12', 0);
338 INSERT INTO `0_chart_master` VALUES('5760', '', 'Rent', '12', 0);
339 INSERT INTO `0_chart_master` VALUES('5765', '', 'Repair & Maintenance', '12', 0);
340 INSERT INTO `0_chart_master` VALUES('5780', '', 'Telephone', '12', 0);
341 INSERT INTO `0_chart_master` VALUES('5785', '', 'Travel & Entertainment', '12', 0);
342 INSERT INTO `0_chart_master` VALUES('5790', '', 'Utilities', '12', 0);
343 INSERT INTO `0_chart_master` VALUES('5795', '', 'Registrations', '12', 0);
344 INSERT INTO `0_chart_master` VALUES('5800', '', 'Licenses', '12', 0);
345 INSERT INTO `0_chart_master` VALUES('5810', '', 'Foreign Exchange Loss', '12', 0);
346 INSERT INTO `0_chart_master` VALUES('9990', '', 'Year Profit/Loss', '12', 0);
348 -- --------------------------------------------------------
351 -- Table structure for table `0_chart_types`
354 DROP TABLE IF EXISTS `0_chart_types`;
355 CREATE TABLE IF NOT EXISTS `0_chart_types` (
356 `id` varchar(10) NOT NULL,
357 `name` varchar(60) NOT NULL default '',
358 `class_id` varchar(3) NOT NULL default '',
359 `parent` varchar(10) NOT NULL default '-1',
360 `inactive` tinyint(1) NOT NULL default '0',
363 KEY `class_id` (`class_id`)
367 -- Dumping data for table `0_chart_types`
370 INSERT INTO `0_chart_types` VALUES('1', 'Current Assets', '1', '', 0);
371 INSERT INTO `0_chart_types` VALUES('2', 'Inventory Assets', '1', '', 0);
372 INSERT INTO `0_chart_types` VALUES('3', 'Capital Assets', '1', '', 0);
373 INSERT INTO `0_chart_types` VALUES('4', 'Current Liabilities', '2', '', 0);
374 INSERT INTO `0_chart_types` VALUES('5', 'Long Term Liabilities', '2', '', 0);
375 INSERT INTO `0_chart_types` VALUES('6', 'Share Capital', '2', '', 0);
376 INSERT INTO `0_chart_types` VALUES('7', 'Retained Earnings', '2', '', 0);
377 INSERT INTO `0_chart_types` VALUES('8', 'Sales Revenue', '3', '', 0);
378 INSERT INTO `0_chart_types` VALUES('9', 'Other Revenue', '3', '', 0);
379 INSERT INTO `0_chart_types` VALUES('10', 'Cost of Goods Sold', '4', '', 0);
380 INSERT INTO `0_chart_types` VALUES('11', 'Payroll Expenses', '4', '', 0);
381 INSERT INTO `0_chart_types` VALUES('12', 'General & Administrative expenses', '4', '', 0);
383 -- --------------------------------------------------------
386 -- Table structure for table `0_comments`
389 DROP TABLE IF EXISTS `0_comments`;
390 CREATE TABLE IF NOT EXISTS `0_comments` (
391 `type` int(11) NOT NULL default '0',
392 `id` int(11) NOT NULL default '0',
393 `date_` date default '0000-00-00',
395 KEY `type_and_id` (`type`,`id`)
399 -- Dumping data for table `0_comments`
403 -- --------------------------------------------------------
406 -- Table structure for table `0_credit_status`
409 DROP TABLE IF EXISTS `0_credit_status`;
410 CREATE TABLE IF NOT EXISTS `0_credit_status` (
411 `id` int(11) NOT NULL auto_increment,
412 `reason_description` char(100) NOT NULL default '',
413 `dissallow_invoices` tinyint(1) NOT NULL default '0',
414 `inactive` tinyint(1) NOT NULL default '0',
416 UNIQUE KEY `reason_description` (`reason_description`)
417 ) ENGINE=MyISAM AUTO_INCREMENT=5 ;
420 -- Dumping data for table `0_credit_status`
423 INSERT INTO `0_credit_status` VALUES(1, 'Good History', 0, 0);
424 INSERT INTO `0_credit_status` VALUES(3, 'No more work until payment received', 1, 0);
425 INSERT INTO `0_credit_status` VALUES(4, 'In liquidation', 1, 0);
427 -- --------------------------------------------------------
430 -- Table structure for table `0_crm_categories`
433 DROP TABLE IF EXISTS `0_crm_categories`;
434 CREATE TABLE IF NOT EXISTS `0_crm_categories` (
435 `id` int(11) NOT NULL auto_increment COMMENT 'pure technical key',
436 `type` varchar(20) NOT NULL COMMENT 'contact type e.g. customer',
437 `action` varchar(20) NOT NULL COMMENT 'detailed usage e.g. department',
438 `name` varchar(30) NOT NULL COMMENT 'for category selector',
439 `description` tinytext NOT NULL COMMENT 'usage description',
440 `system` tinyint(1) NOT NULL default '0' COMMENT 'nonzero for core system usage',
441 `inactive` tinyint(1) NOT NULL default '0',
443 UNIQUE KEY `type` (`type`,`action`),
444 UNIQUE KEY `type_2` (`type`,`name`)
445 ) ENGINE=InnoDB AUTO_INCREMENT=13 ;
448 -- Dumping data for table `0_crm_categories`
451 INSERT INTO `0_crm_categories` VALUES(1, 'cust_branch', 'general', 'General', 'General contact data for customer branch (overrides company setting)', 1, 0);
452 INSERT INTO `0_crm_categories` VALUES(2, 'cust_branch', 'invoice', 'Invoices', 'Invoice posting (overrides company setting)', 1, 0);
453 INSERT INTO `0_crm_categories` VALUES(3, 'cust_branch', 'order', 'Orders', 'Order confirmation (overrides company setting)', 1, 0);
454 INSERT INTO `0_crm_categories` VALUES(4, 'cust_branch', 'delivery', 'Deliveries', 'Delivery coordination (overrides company setting)', 1, 0);
455 INSERT INTO `0_crm_categories` VALUES(5, 'customer', 'general', 'General', 'General contact data for customer', 1, 0);
456 INSERT INTO `0_crm_categories` VALUES(6, 'customer', 'order', 'Orders', 'Order confirmation', 1, 0);
457 INSERT INTO `0_crm_categories` VALUES(7, 'customer', 'delivery', 'Deliveries', 'Delivery coordination', 1, 0);
458 INSERT INTO `0_crm_categories` VALUES(8, 'customer', 'invoice', 'Invoices', 'Invoice posting', 1, 0);
459 INSERT INTO `0_crm_categories` VALUES(9, 'supplier', 'general', 'General', 'General contact data for supplier', 1, 0);
460 INSERT INTO `0_crm_categories` VALUES(10, 'supplier', 'order', 'Orders', 'Order confirmation', 1, 0);
461 INSERT INTO `0_crm_categories` VALUES(11, 'supplier', 'delivery', 'Deliveries', 'Delivery coordination', 1, 0);
462 INSERT INTO `0_crm_categories` VALUES(12, 'supplier', 'invoice', 'Invoices', 'Invoice posting', 1, 0);
464 -- --------------------------------------------------------
467 -- Table structure for table `0_crm_contacts`
470 DROP TABLE IF EXISTS `0_crm_contacts`;
471 CREATE TABLE IF NOT EXISTS `0_crm_contacts` (
472 `id` int(11) NOT NULL auto_increment,
473 `person_id` int(11) NOT NULL default '0' COMMENT 'foreign key to crm_contacts',
474 `type` varchar(20) NOT NULL COMMENT 'foreign key to crm_categories',
475 `action` varchar(20) NOT NULL COMMENT 'foreign key to crm_categories',
476 `entity_id` varchar(11) default NULL COMMENT 'entity id in related class table',
478 KEY `type` (`type`,`action`)
479 ) ENGINE=InnoDB AUTO_INCREMENT=10 ;
482 -- Dumping data for table `0_crm_contacts`
485 INSERT INTO `0_crm_contacts` VALUES(1, 1, 'customer', 'general', '1');
486 INSERT INTO `0_crm_contacts` VALUES(2, 2, 'customer', 'general', '2');
487 INSERT INTO `0_crm_contacts` VALUES(3, 3, 'customer', 'general', '3');
488 INSERT INTO `0_crm_contacts` VALUES(4, 4, 'cust_branch', 'general', '1');
489 INSERT INTO `0_crm_contacts` VALUES(5, 5, 'cust_branch', 'general', '2');
490 INSERT INTO `0_crm_contacts` VALUES(6, 6, 'cust_branch', 'general', '3');
491 INSERT INTO `0_crm_contacts` VALUES(7, 7, 'supplier', 'general', '1');
492 INSERT INTO `0_crm_contacts` VALUES(8, 8, 'supplier', 'general', '2');
493 INSERT INTO `0_crm_contacts` VALUES(9, 9, 'supplier', 'general', '3');
495 -- --------------------------------------------------------
498 -- Table structure for table `0_crm_persons`
501 DROP TABLE IF EXISTS `0_crm_persons`;
502 CREATE TABLE IF NOT EXISTS `0_crm_persons` (
503 `id` int(11) NOT NULL auto_increment,
504 `ref` varchar(30) NOT NULL,
505 `name` varchar(60) NOT NULL,
506 `name2` varchar(60) default NULL,
508 `phone` varchar(30) default NULL,
509 `phone2` varchar(30) default NULL,
510 `fax` varchar(30) default NULL,
511 `email` varchar(100) default NULL,
512 `lang` char(5) default NULL,
513 `notes` tinytext NOT NULL,
514 `inactive` tinyint(1) NOT NULL default '0',
517 ) ENGINE=InnoDB AUTO_INCREMENT=10 ;
520 -- Dumping data for table `0_crm_persons`
523 INSERT INTO `0_crm_persons` VALUES(1, 'Beefeater', '', NULL, NULL, NULL, NULL, NULL, '', 'C', '', 0);
524 INSERT INTO `0_crm_persons` VALUES(2, 'Ghostbusters', '', NULL, NULL, NULL, NULL, NULL, '', NULL, '', 0);
525 INSERT INTO `0_crm_persons` VALUES(3, 'Brezan', '', NULL, NULL, NULL, NULL, NULL, '', 'C', '', 0);
526 INSERT INTO `0_crm_persons` VALUES(4, 'Beefeater', 'Main Branch', NULL, '', '', '', '', '', NULL, '', 0);
527 INSERT INTO `0_crm_persons` VALUES(5, 'Ghostbusters', 'Main Branch', NULL, 'Address 1\nAddress 2\nAddress 3', '', '', '', '', NULL, '', 0);
528 INSERT INTO `0_crm_persons` VALUES(6, 'Brezan', 'Main Branch', NULL, 'Address 1\nAddress 2\nAddress 3', '', '', '', '', NULL, '', 0);
529 INSERT INTO `0_crm_persons` VALUES(7, 'Junk Beer', 'Contact', NULL, 'Address 1\nAddress 2\nAddress 3', '+45 55667788', '', '', '', 'C', '', 0);
530 INSERT INTO `0_crm_persons` VALUES(8, 'Lucky Luke', 'Luke', NULL, 'Address 1\nAddress 2\nAddress 3', '(111) 222.333.444', '', '', '', NULL, '', 0);
531 INSERT INTO `0_crm_persons` VALUES(9, 'Money Makers', 'Makers', NULL, 'Address 1\nAddress 2\nAddress 3', '+44 444 555 666', '', '', '', 'C', '', 0);
533 -- --------------------------------------------------------
536 -- Table structure for table `0_currencies`
539 DROP TABLE IF EXISTS `0_currencies`;
540 CREATE TABLE IF NOT EXISTS `0_currencies` (
541 `currency` varchar(60) NOT NULL default '',
542 `curr_abrev` char(3) NOT NULL default '',
543 `curr_symbol` varchar(10) NOT NULL default '',
544 `country` varchar(100) NOT NULL default '',
545 `hundreds_name` varchar(15) NOT NULL default '',
546 `auto_update` tinyint(1) NOT NULL default '1',
547 `inactive` tinyint(1) NOT NULL default '0',
548 PRIMARY KEY (`curr_abrev`)
552 -- Dumping data for table `0_currencies`
555 INSERT INTO `0_currencies` VALUES('US Dollars', 'USD', '$', 'United States', 'Cents', 1, 0);
556 INSERT INTO `0_currencies` VALUES('CA Dollars', 'CAD', '$', 'Canada', 'Cents', 1, 0);
557 INSERT INTO `0_currencies` VALUES('Euro', 'EUR', '?', 'Europe', 'Cents', 1, 0);
558 INSERT INTO `0_currencies` VALUES('Pounds', 'GBP', '?', 'England', 'Pence', 1, 0);
559 INSERT INTO `0_currencies` VALUES('DK Kroner', 'DKK', '?', 'Denmark', 'Ore', 1, 0);
561 -- --------------------------------------------------------
564 -- Table structure for table `0_cust_allocations`
567 DROP TABLE IF EXISTS `0_cust_allocations`;
568 CREATE TABLE IF NOT EXISTS `0_cust_allocations` (
569 `id` int(11) NOT NULL auto_increment,
570 `amt` double unsigned default NULL,
571 `date_alloc` date NOT NULL default '0000-00-00',
572 `trans_no_from` int(11) default NULL,
573 `trans_type_from` int(11) default NULL,
574 `trans_no_to` int(11) default NULL,
575 `trans_type_to` int(11) default NULL,
577 KEY `From` (`trans_type_from`,`trans_no_from`),
578 KEY `To` (`trans_type_to`,`trans_no_to`)
579 ) ENGINE=InnoDB AUTO_INCREMENT=2 ;
582 -- Dumping data for table `0_cust_allocations`
585 INSERT INTO `0_cust_allocations` VALUES(1, 37.68, '2009-06-21', 3, 11, 18, 10);
587 -- --------------------------------------------------------
590 -- Table structure for table `0_cust_branch`
593 DROP TABLE IF EXISTS `0_cust_branch`;
594 CREATE TABLE IF NOT EXISTS `0_cust_branch` (
595 `branch_code` int(11) NOT NULL auto_increment,
596 `debtor_no` int(11) NOT NULL default '0',
597 `br_name` varchar(60) NOT NULL default '',
598 `branch_ref` varchar(30) NOT NULL default '',
599 `br_address` tinytext NOT NULL,
600 `area` int(11) default NULL,
601 `salesman` int(11) NOT NULL default '0',
602 `contact_name` varchar(60) NOT NULL default '',
603 `default_location` varchar(5) NOT NULL default '',
604 `tax_group_id` int(11) default NULL,
605 `sales_account` varchar(15) NOT NULL default '',
606 `sales_discount_account` varchar(15) NOT NULL default '',
607 `receivables_account` varchar(15) NOT NULL default '',
608 `payment_discount_account` varchar(15) NOT NULL default '',
609 `default_ship_via` int(11) NOT NULL default '1',
610 `disable_trans` tinyint(4) NOT NULL default '0',
611 `br_post_address` tinytext NOT NULL,
612 `group_no` int(11) NOT NULL default '0',
613 `notes` tinytext NOT NULL,
614 `bank_account` varchar(60) DEFAULT NULL,
615 `inactive` tinyint(1) NOT NULL default '0',
616 PRIMARY KEY (`branch_code`,`debtor_no`),
617 KEY `branch_code` (`branch_code`),
618 KEY `branch_ref` (`branch_ref`),
619 KEY `group_no` (`group_no`)
620 ) ENGINE=MyISAM AUTO_INCREMENT=4 ;
623 -- Dumping data for table `0_cust_branch`
626 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);
627 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);
628 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);
630 -- --------------------------------------------------------
633 -- Table structure for table `0_debtors_master`
636 DROP TABLE IF EXISTS `0_debtors_master`;
637 CREATE TABLE IF NOT EXISTS `0_debtors_master` (
638 `debtor_no` int(11) NOT NULL auto_increment,
639 `name` varchar(100) NOT NULL default '',
640 `debtor_ref` varchar(30) NOT NULL,
642 `tax_id` varchar(55) NOT NULL default '',
643 `curr_code` char(3) NOT NULL default '',
644 `sales_type` int(11) NOT NULL default '1',
645 `dimension_id` int(11) NOT NULL default '0',
646 `dimension2_id` int(11) NOT NULL default '0',
647 `credit_status` int(11) NOT NULL default '0',
648 `payment_terms` int(11) default NULL,
649 `discount` double NOT NULL default '0',
650 `pymt_discount` double NOT NULL default '0',
651 `credit_limit` float NOT NULL default '1000',
652 `notes` tinytext NOT NULL,
653 `inactive` tinyint(1) NOT NULL default '0',
654 PRIMARY KEY (`debtor_no`),
656 UNIQUE KEY `debtor_ref` (`debtor_ref`)
657 ) ENGINE=MyISAM AUTO_INCREMENT=4 ;
660 -- Dumping data for table `0_debtors_master`
663 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);
664 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);
665 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);
667 -- --------------------------------------------------------
670 -- Table structure for table `0_debtor_trans`
673 DROP TABLE IF EXISTS `0_debtor_trans`;
674 CREATE TABLE IF NOT EXISTS `0_debtor_trans` (
675 `trans_no` int(11) unsigned NOT NULL default '0',
676 `type` smallint(6) unsigned NOT NULL default '0',
677 `version` tinyint(1) unsigned NOT NULL default '0',
678 `debtor_no` int(11) unsigned default NULL,
679 `branch_code` int(11) NOT NULL default '-1',
680 `tran_date` date NOT NULL default '0000-00-00',
681 `due_date` date NOT NULL default '0000-00-00',
682 `reference` varchar(60) NOT NULL default '',
683 `tpe` int(11) NOT NULL default '0',
684 `order_` int(11) NOT NULL default '0',
685 `ov_amount` double NOT NULL default '0',
686 `ov_gst` double NOT NULL default '0',
687 `ov_freight` double NOT NULL default '0',
688 `ov_freight_tax` double NOT NULL default '0',
689 `ov_discount` double NOT NULL default '0',
690 `alloc` double NOT NULL default '0',
691 `rate` double NOT NULL default '1',
692 `ship_via` int(11) default NULL,
693 `dimension_id` int(11) NOT NULL default '0',
694 `dimension2_id` int(11) NOT NULL default '0',
695 `payment_terms` int(11) default NULL,
696 `tax_included` tinyint(1) unsigned NOT NULL default '0',
697 PRIMARY KEY (`type`,`trans_no`),
698 KEY `debtor_no` (`debtor_no`,`branch_code`),
699 KEY `tran_date` (`tran_date`)
703 -- Dumping data for table `0_debtor_trans`
706 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);
707 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);
708 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);
709 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);
710 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);
711 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);
712 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);
713 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);
715 -- --------------------------------------------------------
718 -- Table structure for table `0_debtor_trans_details`
721 DROP TABLE IF EXISTS `0_debtor_trans_details`;
722 CREATE TABLE IF NOT EXISTS `0_debtor_trans_details` (
723 `id` int(11) NOT NULL auto_increment,
724 `debtor_trans_no` int(11) default NULL,
725 `debtor_trans_type` int(11) default NULL,
726 `stock_id` varchar(20) NOT NULL default '',
727 `description` tinytext,
728 `unit_price` double NOT NULL default '0',
729 `unit_tax` double NOT NULL default '0',
730 `quantity` double NOT NULL default '0',
731 `discount_percent` double NOT NULL default '0',
732 `standard_cost` double NOT NULL default '0',
733 `qty_done` double NOT NULL default '0',
734 `src_id` int(11) NOT NULL,
736 KEY `Transaction` (`debtor_trans_type`,`debtor_trans_no`),
738 ) ENGINE=InnoDB AUTO_INCREMENT=9 ;
741 -- Dumping data for table `0_debtor_trans_details`
744 INSERT INTO `0_debtor_trans_details` VALUES(1, 2, 13, '102', '17inch VGA Monitor', 30.4, 0, 2, 0, 10, 0, 1);
745 INSERT INTO `0_debtor_trans_details` VALUES(2, 3, 13, '102', '17inch VGA Monitor', 50, 2.5, 1, 0, 10, 1, 2);
746 INSERT INTO `0_debtor_trans_details` VALUES(3, 17, 10, '102', '17inch VGA Monitor', 50, 2.5, 1, 0, 10, 2, 2);
747 INSERT INTO `0_debtor_trans_details` VALUES(4, 4, 13, '102', '17inch VGA Monitor', 35.89, 1.79, 1, 0, 10, 1,3);
748 INSERT INTO `0_debtor_trans_details` VALUES(5, 18, 10, '102', '17inch VGA Monitor', 35.89, 1.79, 1, 0, 10, 1,4);
749 INSERT INTO `0_debtor_trans_details` VALUES(6, 5, 13, '102', '17inch VGA Monitor', 50, 2.38, 1, 0, 10, 1,5);
750 INSERT INTO `0_debtor_trans_details` VALUES(7, 19, 10, '102', '17inch VGA Monitor', 50, 2.38, 1, 0, 10, 0,6);
751 INSERT INTO `0_debtor_trans_details` VALUES(8, 3, 11, '102', '17inch VGA Monitor', 35.89, 1.79, 1, 0, 10, 0,5);
753 -- --------------------------------------------------------
756 -- Table structure for table `0_dimensions`
759 DROP TABLE IF EXISTS `0_dimensions`;
760 CREATE TABLE IF NOT EXISTS `0_dimensions` (
761 `id` int(11) NOT NULL auto_increment,
762 `reference` varchar(60) NOT NULL default '',
763 `name` varchar(60) NOT NULL default '',
764 `type_` tinyint(1) NOT NULL default '1',
765 `closed` tinyint(1) NOT NULL default '0',
766 `date_` date NOT NULL default '0000-00-00',
767 `due_date` date NOT NULL default '0000-00-00',
769 UNIQUE KEY `reference` (`reference`),
770 KEY `date_` (`date_`),
771 KEY `due_date` (`due_date`),
772 KEY `type_` (`type_`)
773 ) ENGINE=InnoDB AUTO_INCREMENT=3 ;
776 -- Dumping data for table `0_dimensions`
779 INSERT INTO `0_dimensions` VALUES(1, '1', 'Support', 1, 0, '2009-06-21', '2015-07-11');
780 INSERT INTO `0_dimensions` VALUES(2, '2', 'Development', 1, 0, '2009-06-21', '2015-07-11');
782 -- --------------------------------------------------------
785 -- Table structure for table `0_exchange_rates`
788 DROP TABLE IF EXISTS `0_exchange_rates`;
789 CREATE TABLE IF NOT EXISTS `0_exchange_rates` (
790 `id` int(11) NOT NULL auto_increment,
791 `curr_code` char(3) NOT NULL default '',
792 `rate_buy` double NOT NULL default '0',
793 `rate_sell` double NOT NULL default '0',
794 `date_` date NOT NULL default '0000-00-00',
796 UNIQUE KEY `curr_code` (`curr_code`,`date_`)
797 ) ENGINE=MyISAM AUTO_INCREMENT=4 ;
800 -- Dumping data for table `0_exchange_rates`
803 INSERT INTO `0_exchange_rates` VALUES(1, 'DKK', 0.18717252868313, 0.18717252868313, '2009-06-21');
804 INSERT INTO `0_exchange_rates` VALUES(2, 'GBP', 1.6445729799917, 1.6445729799917, '2009-06-21');
805 INSERT INTO `0_exchange_rates` VALUES(3, 'EUR', 1.3932, 1.3932, '2009-06-21');
807 -- --------------------------------------------------------
810 -- Table structure for table `0_fiscal_year`
813 DROP TABLE IF EXISTS `0_fiscal_year`;
814 CREATE TABLE IF NOT EXISTS `0_fiscal_year` (
815 `id` int(11) NOT NULL auto_increment,
816 `begin` date default '0000-00-00',
817 `end` date default '0000-00-00',
818 `closed` tinyint(1) NOT NULL default '0',
820 UNIQUE KEY `begin` (`begin`),
821 UNIQUE KEY `end` (`end`)
822 ) ENGINE=InnoDB AUTO_INCREMENT=4 ;
825 -- Dumping data for table `0_fiscal_year`
828 INSERT INTO `0_fiscal_year` VALUES(1, '2008-01-01', '2008-12-31', 1);
829 INSERT INTO `0_fiscal_year` VALUES(2, '2009-01-01', '2009-12-31', 1);
830 INSERT INTO `0_fiscal_year` VALUES(3, '2010-01-01', '2010-12-31', 0);
831 INSERT INTO `0_fiscal_year` VALUES(4, '2011-01-01', '2011-12-31', 0);
834 -- Table structure for table `0_gl_trans`
837 DROP TABLE IF EXISTS `0_gl_trans`;
838 CREATE TABLE IF NOT EXISTS `0_gl_trans` (
839 `counter` int(11) NOT NULL auto_increment,
840 `type` smallint(6) NOT NULL default '0',
841 `type_no` bigint(16) NOT NULL default '1',
842 `tran_date` date NOT NULL default '0000-00-00',
843 `account` varchar(15) NOT NULL default '',
844 `memo_` tinytext NOT NULL,
845 `amount` double NOT NULL default '0',
846 `dimension_id` int(11) NOT NULL default '0',
847 `dimension2_id` int(11) NOT NULL default '0',
848 `person_type_id` int(11) default NULL,
849 `person_id` tinyblob,
850 PRIMARY KEY (`counter`),
851 KEY `Type_and_Number` (`type`,`type_no`),
852 KEY `dimension_id` (`dimension_id`),
853 KEY `dimension2_id` (`dimension2_id`),
854 KEY `tran_date` (`tran_date`),
855 KEY `account_and_tran_date` (`account`,`tran_date`)
856 ) ENGINE=InnoDB AUTO_INCREMENT=84 ;
859 -- Dumping data for table `0_gl_trans`
862 INSERT INTO `0_gl_trans` VALUES(1, 20, 7, '2009-06-21', '2100', '', -3465, 0, 0, 3, '2');
863 INSERT INTO `0_gl_trans` VALUES(2, 20, 7, '2009-06-21', '1510', '', 1000, 0, 0, 3, '2');
864 INSERT INTO `0_gl_trans` VALUES(3, 20, 7, '2009-06-21', '1510', '', 1100, 0, 0, 3, '2');
865 INSERT INTO `0_gl_trans` VALUES(4, 20, 7, '2009-06-21', '1510', '', 1200, 0, 0, 3, '2');
866 INSERT INTO `0_gl_trans` VALUES(5, 20, 7, '2009-06-21', '2150', '', 165, 0, 0, 3, '2');
867 INSERT INTO `0_gl_trans` VALUES(6, 22, 4, '2009-06-21', '2100', '', 3465, 0, 0, 3, '2');
868 INSERT INTO `0_gl_trans` VALUES(7, 22, 4, '2009-06-21', '1060', '', -3465, 0, 0, 3, '2');
869 INSERT INTO `0_gl_trans` VALUES(8, 26, 1, '2009-06-21', '1510', '', -100, 0, 0, NULL, '');
870 INSERT INTO `0_gl_trans` VALUES(9, 26, 1, '2009-06-21', '1510', '', -110, 0, 0, NULL, '');
871 INSERT INTO `0_gl_trans` VALUES(10, 26, 1, '2009-06-21', '1510', '', -120, 0, 0, NULL, '');
872 INSERT INTO `0_gl_trans` VALUES(11, 26, 1, '2009-06-21', '1060', 'Overhead Cost', -10, 0, 0, 1, '1');
873 INSERT INTO `0_gl_trans` VALUES(12, 26, 1, '2009-06-21', '1530', 'Overhead Cost', 10, 0, 0, 1, '1');
874 INSERT INTO `0_gl_trans` VALUES(13, 26, 1, '2009-06-21', '1060', 'Labour Cost', -20, 0, 0, 1, '0');
875 INSERT INTO `0_gl_trans` VALUES(14, 26, 1, '2009-06-21', '1530', 'Labour Cost', 20, 0, 0, 1, '0');
876 INSERT INTO `0_gl_trans` VALUES(15, 26, 1, '2009-06-21', '1510', '', 330, 0, 0, NULL, '');
877 INSERT INTO `0_gl_trans` VALUES(16, 13, 2, '2009-06-21', '5010', '', 20, 0, 0, 2, '1');
878 INSERT INTO `0_gl_trans` VALUES(17, 13, 2, '2009-06-21', '1510', '', -20, 0, 0, 2, '1');
879 INSERT INTO `0_gl_trans` VALUES(18, 13, 3, '2009-06-21', '5010', '', 10, 0, 0, 2, '2');
880 INSERT INTO `0_gl_trans` VALUES(19, 13, 3, '2009-06-21', '1510', '', -10, 0, 0, 2, '2');
881 INSERT INTO `0_gl_trans` VALUES(20, 10, 17, '2009-06-21', '4010', '', -50, 0, 0, 2, '2');
882 INSERT INTO `0_gl_trans` VALUES(21, 10, 17, '2009-06-21', '1200', '', 52.5, 0, 0, 2, '2');
883 INSERT INTO `0_gl_trans` VALUES(22, 10, 17, '2009-06-21', '2150', '', -2.5, 0, 0, 2, '2');
884 INSERT INTO `0_gl_trans` VALUES(23, 13, 4, '2009-06-21', '5010', '', 10, 2, 0, 2, '3');
885 INSERT INTO `0_gl_trans` VALUES(24, 13, 4, '2009-06-21', '1510', '', -10, 0, 0, 2, '3');
886 INSERT INTO `0_gl_trans` VALUES(25, 10, 18, '2009-06-21', '4010', '', -50, 2, 0, 2, '3');
887 INSERT INTO `0_gl_trans` VALUES(26, 10, 18, '2009-06-21', '1200', '', 52.5, 0, 0, 2, '3');
888 INSERT INTO `0_gl_trans` VALUES(27, 10, 18, '2009-06-21', '2150', '', -2.5, 0, 0, 2, '3');
889 INSERT INTO `0_gl_trans` VALUES(28, 0, 18, '2009-02-20', '1060', '', 1000, 0, 0, NULL, '');
890 INSERT INTO `0_gl_trans` VALUES(29, 0, 18, '2009-02-20', '3350', '', -1000, 0, 0, NULL, '');
891 INSERT INTO `0_gl_trans` VALUES(30, 0, 19, '2009-02-21', '1060', '', 4000, 0, 0, NULL, '');
892 INSERT INTO `0_gl_trans` VALUES(31, 0, 19, '2009-02-21', '3350', '', -4000, 0, 0, NULL, '');
893 INSERT INTO `0_gl_trans` VALUES(32, 26, 3, '2009-06-21', '1510', '', -20, 0, 0, NULL, '');
894 INSERT INTO `0_gl_trans` VALUES(33, 26, 3, '2009-06-21', '1510', '', -22, 0, 0, NULL, '');
895 INSERT INTO `0_gl_trans` VALUES(34, 26, 3, '2009-06-21', '1510', '', -24, 0, 0, NULL, '');
896 INSERT INTO `0_gl_trans` VALUES(35, 26, 3, '2009-06-21', '1540', '', 66, 0, 0, NULL, '');
897 INSERT INTO `0_gl_trans` VALUES(36, 2, 5, '2009-06-21', '2150', 'Cash Sales', -4.76, 0, 0, 4, '3');
898 INSERT INTO `0_gl_trans` VALUES(37, 2, 5, '2009-06-21', '4010', 'Cash Sales', -95.24, 0, 0, 4, '3');
899 INSERT INTO `0_gl_trans` VALUES(38, 2, 5, '2009-06-21', '1060', '', 100, 0, 0, 4, '3');
900 INSERT INTO `0_gl_trans` VALUES(39, 1, 8, '2009-06-21', '2150', 'Maintenance', 2.38, 0, 0, 4, '1');
901 INSERT INTO `0_gl_trans` VALUES(40, 1, 8, '2009-06-21', '5765', 'Maintenance', 47.62, 0, 0, 4, '1');
902 INSERT INTO `0_gl_trans` VALUES(41, 1, 8, '2009-06-21', '1060', '', -50, 0, 0, 4, '1');
903 INSERT INTO `0_gl_trans` VALUES(42, 20, 8, '2009-06-21', '2100', '', -20, 0, 0, 3, '2');
904 INSERT INTO `0_gl_trans` VALUES(43, 20, 8, '2009-06-21', '2150', '', 0.95, 0, 0, 3, '2');
905 INSERT INTO `0_gl_trans` VALUES(44, 20, 8, '2009-06-21', '5780', '', 19.05, 0, 0, 3, '2');
906 INSERT INTO `0_gl_trans` VALUES(45, 26, 4, '2009-06-21', '1510', '', -40, 0, 0, NULL, '');
907 INSERT INTO `0_gl_trans` VALUES(46, 26, 4, '2009-06-21', '1510', '', -44, 0, 0, NULL, '');
908 INSERT INTO `0_gl_trans` VALUES(47, 26, 4, '2009-06-21', '1510', '', -48, 0, 0, NULL, '');
909 INSERT INTO `0_gl_trans` VALUES(48, 26, 4, '2009-06-21', '1540', '', 132, 0, 0, NULL, '');
910 INSERT INTO `0_gl_trans` VALUES(49, 26, 2, '2009-06-21', '1510', '', -20, 0, 0, NULL, '');
911 INSERT INTO `0_gl_trans` VALUES(50, 26, 2, '2009-06-21', '1510', '', -22, 0, 0, NULL, '');
912 INSERT INTO `0_gl_trans` VALUES(51, 26, 2, '2009-06-21', '1510', '', -24, 0, 0, NULL, '');
913 INSERT INTO `0_gl_trans` VALUES(52, 26, 2, '2009-06-21', '1540', '', 66, 0, 0, NULL, '');
914 INSERT INTO `0_gl_trans` VALUES(53, 26, 5, '2009-06-21', '1510', '', -50, 0, 0, NULL, '');
915 INSERT INTO `0_gl_trans` VALUES(54, 26, 5, '2009-06-21', '1510', '', -55, 0, 0, NULL, '');
916 INSERT INTO `0_gl_trans` VALUES(55, 26, 5, '2009-06-21', '1510', '', -60, 0, 0, NULL, '');
917 INSERT INTO `0_gl_trans` VALUES(56, 26, 5, '2009-06-21', '1060', 'Overhead Cost', -10, 0, 0, 1, '1');
918 INSERT INTO `0_gl_trans` VALUES(57, 26, 5, '2009-06-21', '1530', 'Overhead Cost', 10, 0, 0, 1, '1');
919 INSERT INTO `0_gl_trans` VALUES(58, 26, 5, '2009-06-21', '1060', 'Labour Cost', -20, 0, 0, 1, '0');
920 INSERT INTO `0_gl_trans` VALUES(59, 26, 5, '2009-06-21', '1530', 'Labour Cost', 20, 0, 0, 1, '0');
921 INSERT INTO `0_gl_trans` VALUES(60, 26, 5, '2009-06-21', '1540', '', 165, 0, 0, NULL, '');
922 INSERT INTO `0_gl_trans` VALUES(61, 26, 6, '2009-06-21', '1510', '', 50, 0, 0, NULL, '');
923 INSERT INTO `0_gl_trans` VALUES(62, 26, 6, '2009-06-21', '1510', '', 55, 0, 0, NULL, '');
924 INSERT INTO `0_gl_trans` VALUES(63, 26, 6, '2009-06-21', '1510', '', 60, 0, 0, NULL, '');
925 INSERT INTO `0_gl_trans` VALUES(64, 26, 6, '2009-06-21', '1540', '', -165, 0, 0, NULL, '');
926 INSERT INTO `0_gl_trans` VALUES(65, 26, 7, '2009-06-21', '1510', '', 20, 0, 0, NULL, '');
927 INSERT INTO `0_gl_trans` VALUES(66, 26, 7, '2009-06-21', '1510', '', 22, 0, 0, NULL, '');
928 INSERT INTO `0_gl_trans` VALUES(67, 26, 7, '2009-06-21', '1510', '', 24, 0, 0, NULL, '');
929 INSERT INTO `0_gl_trans` VALUES(68, 26, 7, '2009-06-21', '1060', 'Overhead Cost', -10, 0, 0, 1, '1');
930 INSERT INTO `0_gl_trans` VALUES(69, 26, 7, '2009-06-21', '1530', 'Overhead Cost', 10, 0, 0, 1, '1');
931 INSERT INTO `0_gl_trans` VALUES(70, 26, 7, '2009-06-21', '1060', 'Labour Cost', -20, 0, 0, 1, '0');
932 INSERT INTO `0_gl_trans` VALUES(71, 26, 7, '2009-06-21', '1530', 'Labour Cost', 20, 0, 0, 1, '0');
933 INSERT INTO `0_gl_trans` VALUES(72, 26, 7, '2009-06-21', '1540', '', -66, 0, 0, NULL, '');
934 INSERT INTO `0_gl_trans` VALUES(73, 13, 5, '2009-06-21', '5010', '', 10, 0, 0, 2, '2');
935 INSERT INTO `0_gl_trans` VALUES(74, 13, 5, '2009-06-21', '1510', '', -10, 0, 0, 2, '2');
936 INSERT INTO `0_gl_trans` VALUES(75, 10, 19, '2009-06-21', '4010', '', -47.62, 0, 0, 2, '2');
937 INSERT INTO `0_gl_trans` VALUES(76, 10, 19, '2009-06-21', '1200', '', 55, 0, 0, 2, '2');
938 INSERT INTO `0_gl_trans` VALUES(77, 10, 19, '2009-06-21', '4430', '', -5, 0, 0, 2, '2');
939 INSERT INTO `0_gl_trans` VALUES(78, 10, 19, '2009-06-21', '2150', '', -2.38, 0, 0, 2, '2');
940 INSERT INTO `0_gl_trans` VALUES(79, 11, 3, '2009-06-21', '5010', '', -10, 2, 0, 2, '3');
941 INSERT INTO `0_gl_trans` VALUES(80, 11, 3, '2009-06-21', '1510', '', 10, 0, 0, 2, '3');
942 INSERT INTO `0_gl_trans` VALUES(81, 11, 3, '2009-06-21', '4010', '', 50, 2, 0, 2, '3');
943 INSERT INTO `0_gl_trans` VALUES(82, 11, 3, '2009-06-21', '1200', '', -52.5, 0, 0, 2, '3');
944 INSERT INTO `0_gl_trans` VALUES(83, 11, 3, '2009-06-21', '2150', '', 2.5, 0, 0, 2, '3');
945 INSERT INTO `0_gl_trans` VALUES ('84', '0', '20', '2009-12-31', '3590', 'Closing Year', '-91.19', '0', '0', NULL, NULL);
946 INSERT INTO `0_gl_trans` VALUES ('85', '0', '20', '2009-12-31', '9990', 'Closing Year', '91.19', '0', '0', NULL, NULL);
948 -- --------------------------------------------------------
951 -- Table structure for table `0_grn_batch`
954 DROP TABLE IF EXISTS `0_grn_batch`;
955 CREATE TABLE IF NOT EXISTS `0_grn_batch` (
956 `id` int(11) NOT NULL auto_increment,
957 `supplier_id` int(11) NOT NULL default '0',
958 `purch_order_no` int(11) default NULL,
959 `reference` varchar(60) NOT NULL default '',
960 `delivery_date` date NOT NULL default '0000-00-00',
961 `loc_code` varchar(5) default NULL,
963 KEY `delivery_date` (`delivery_date`),
964 KEY `purch_order_no` (`purch_order_no`)
965 ) ENGINE=InnoDB AUTO_INCREMENT=2 ;
968 -- Dumping data for table `0_grn_batch`
971 INSERT INTO `0_grn_batch` VALUES(1, 2, 1, '1', '2009-06-21', 'DEF');
973 -- --------------------------------------------------------
976 -- Table structure for table `0_grn_items`
979 DROP TABLE IF EXISTS `0_grn_items`;
980 CREATE TABLE IF NOT EXISTS `0_grn_items` (
981 `id` int(11) NOT NULL auto_increment,
982 `grn_batch_id` int(11) default NULL,
983 `po_detail_item` int(11) NOT NULL default '0',
984 `item_code` varchar(20) NOT NULL default '',
985 `description` tinytext,
986 `qty_recd` double NOT NULL default '0',
987 `quantity_inv` double NOT NULL default '0',
989 KEY `grn_batch_id` (`grn_batch_id`)
990 ) ENGINE=InnoDB AUTO_INCREMENT=4 ;
993 -- Dumping data for table `0_grn_items`
996 INSERT INTO `0_grn_items` VALUES(1, 1, 1, '102', '17inch VGA Monitor', 100, 100);
997 INSERT INTO `0_grn_items` VALUES(2, 1, 2, '103', '32MB VGA Card', 100, 100);
998 INSERT INTO `0_grn_items` VALUES(3, 1, 3, '104', '52x CD Drive', 100, 100);
1000 -- --------------------------------------------------------
1003 -- Table structure for table `0_groups`
1006 DROP TABLE IF EXISTS `0_groups`;
1007 CREATE TABLE IF NOT EXISTS `0_groups` (
1008 `id` smallint(6) unsigned NOT NULL auto_increment,
1009 `description` varchar(60) NOT NULL default '',
1010 `inactive` tinyint(1) NOT NULL default '0',
1012 UNIQUE KEY `description` (`description`)
1013 ) ENGINE=MyISAM AUTO_INCREMENT=4 ;
1016 -- Dumping data for table `0_groups`
1019 INSERT INTO `0_groups` VALUES(1, 'Small', 0);
1020 INSERT INTO `0_groups` VALUES(2, 'Medium', 0);
1021 INSERT INTO `0_groups` VALUES(3, 'Large', 0);
1023 -- --------------------------------------------------------
1026 -- Table structure for table `0_item_codes`
1029 DROP TABLE IF EXISTS `0_item_codes`;
1030 CREATE TABLE IF NOT EXISTS `0_item_codes` (
1031 `id` int(11) unsigned NOT NULL auto_increment,
1032 `item_code` varchar(20) NOT NULL,
1033 `stock_id` varchar(20) NOT NULL,
1034 `description` varchar(200) NOT NULL default '',
1035 `category_id` smallint(6) unsigned NOT NULL,
1036 `quantity` double NOT NULL default '1',
1037 `is_foreign` tinyint(1) NOT NULL default '0',
1038 `inactive` tinyint(1) NOT NULL default '0',
1040 UNIQUE KEY `stock_id` (`stock_id`,`item_code`),
1041 KEY `item_code` (`item_code`)
1042 ) ENGINE=MyISAM AUTO_INCREMENT=6 ;
1045 -- Dumping data for table `0_item_codes`
1048 INSERT INTO `0_item_codes` VALUES(1, '102', '102', '17inch VGA Monitor', 1, 1, 0, 0);
1049 INSERT INTO `0_item_codes` VALUES(2, '103', '103', '32MB VGA Card', 1, 1, 0, 0);
1050 INSERT INTO `0_item_codes` VALUES(3, '104', '104', '52x CD Drive', 1, 1, 0, 0);
1051 INSERT INTO `0_item_codes` VALUES(4, '3400', '3400', 'P4 Business System', 3, 1, 0, 0);
1052 INSERT INTO `0_item_codes` VALUES(5, '201', '201', 'Assembly Labour', 4, 1, 0, 0);
1054 -- --------------------------------------------------------
1057 -- Table structure for table `0_item_tax_types`
1060 DROP TABLE IF EXISTS `0_item_tax_types`;
1061 CREATE TABLE IF NOT EXISTS `0_item_tax_types` (
1062 `id` int(11) NOT NULL auto_increment,
1063 `name` varchar(60) NOT NULL default '',
1064 `exempt` tinyint(1) NOT NULL default '0',
1065 `inactive` tinyint(1) NOT NULL default '0',
1067 UNIQUE KEY `name` (`name`)
1068 ) ENGINE=InnoDB AUTO_INCREMENT=2 ;
1071 -- Dumping data for table `0_item_tax_types`
1074 INSERT INTO `0_item_tax_types` VALUES(1, 'Regular', 0, 0);
1076 -- --------------------------------------------------------
1079 -- Table structure for table `0_item_tax_type_exemptions`
1082 DROP TABLE IF EXISTS `0_item_tax_type_exemptions`;
1083 CREATE TABLE IF NOT EXISTS `0_item_tax_type_exemptions` (
1084 `item_tax_type_id` int(11) NOT NULL default '0',
1085 `tax_type_id` int(11) NOT NULL default '0',
1086 PRIMARY KEY (`item_tax_type_id`,`tax_type_id`)
1090 -- Dumping data for table `0_item_tax_type_exemptions`
1094 -- --------------------------------------------------------
1097 -- Table structure for table `0_item_units`
1100 DROP TABLE IF EXISTS `0_item_units`;
1101 CREATE TABLE IF NOT EXISTS `0_item_units` (
1102 `abbr` varchar(20) NOT NULL,
1103 `name` varchar(40) NOT NULL,
1104 `decimals` tinyint(2) NOT NULL,
1105 `inactive` tinyint(1) NOT NULL default '0',
1106 PRIMARY KEY (`abbr`),
1107 UNIQUE KEY `name` (`name`)
1111 -- Dumping data for table `0_item_units`
1114 INSERT INTO `0_item_units` VALUES('ea.', 'Each', 0, 0);
1115 INSERT INTO `0_item_units` VALUES('hrs', 'Hours', 1, 0);
1117 -- --------------------------------------------------------
1120 -- Table structure for table `0_locations`
1123 DROP TABLE IF EXISTS `0_locations`;
1124 CREATE TABLE IF NOT EXISTS `0_locations` (
1125 `loc_code` varchar(5) NOT NULL default '',
1126 `location_name` varchar(60) NOT NULL default '',
1127 `delivery_address` tinytext NOT NULL,
1128 `phone` varchar(30) NOT NULL default '',
1129 `phone2` varchar(30) NOT NULL default '',
1130 `fax` varchar(30) NOT NULL default '',
1131 `email` varchar(100) NOT NULL default '',
1132 `contact` varchar(30) NOT NULL default '',
1133 `inactive` tinyint(1) NOT NULL default '0',
1134 PRIMARY KEY (`loc_code`)
1138 -- Dumping data for table `0_locations`
1141 INSERT INTO `0_locations` VALUES('DEF', 'Default', 'Delivery 1\nDelivery 2\nDelivery 3', '', '', '', '', '', 0);
1143 -- --------------------------------------------------------
1146 -- Table structure for table `0_loc_stock`
1149 DROP TABLE IF EXISTS `0_loc_stock`;
1150 CREATE TABLE IF NOT EXISTS `0_loc_stock` (
1151 `loc_code` char(5) NOT NULL default '',
1152 `stock_id` char(20) NOT NULL default '',
1153 `reorder_level` bigint(20) NOT NULL default '0',
1154 PRIMARY KEY (`loc_code`,`stock_id`),
1155 KEY `stock_id` (`stock_id`)
1159 -- Dumping data for table `0_loc_stock`
1162 INSERT INTO `0_loc_stock` VALUES('DEF', '102', 0);
1163 INSERT INTO `0_loc_stock` VALUES('DEF', '103', 0);
1164 INSERT INTO `0_loc_stock` VALUES('DEF', '104', 0);
1165 INSERT INTO `0_loc_stock` VALUES('DEF', '201', 0);
1166 INSERT INTO `0_loc_stock` VALUES('DEF', '3400', 0);
1168 -- --------------------------------------------------------
1171 -- Table structure for table `0_movement_types`
1174 DROP TABLE IF EXISTS `0_movement_types`;
1175 CREATE TABLE IF NOT EXISTS `0_movement_types` (
1176 `id` int(11) NOT NULL auto_increment,
1177 `name` varchar(60) NOT NULL default '',
1178 `inactive` tinyint(1) NOT NULL default '0',
1180 UNIQUE KEY `name` (`name`)
1181 ) ENGINE=MyISAM AUTO_INCREMENT=2 ;
1184 -- Dumping data for table `0_movement_types`
1187 INSERT INTO `0_movement_types` VALUES(1, 'Adjustment', 0);
1189 -- --------------------------------------------------------
1192 -- Table structure for table `0_payment_terms`
1195 DROP TABLE IF EXISTS `0_payment_terms`;
1196 CREATE TABLE IF NOT EXISTS `0_payment_terms` (
1197 `terms_indicator` int(11) NOT NULL auto_increment,
1198 `terms` char(80) NOT NULL default '',
1199 `days_before_due` smallint(6) NOT NULL default '0',
1200 `day_in_following_month` smallint(6) NOT NULL default '0',
1201 `inactive` tinyint(1) NOT NULL default '0',
1202 PRIMARY KEY (`terms_indicator`),
1203 UNIQUE KEY `terms` (`terms`)
1204 ) ENGINE=MyISAM AUTO_INCREMENT=5 ;
1207 -- Dumping data for table `0_payment_terms`
1210 INSERT INTO `0_payment_terms` VALUES(1, 'Due 15th Of the Following Month', 0, 17, 0);
1211 INSERT INTO `0_payment_terms` VALUES(2, 'Due By End Of The Following Month', 0, 30, 0);
1212 INSERT INTO `0_payment_terms` VALUES(3, 'Payment due within 10 days', 10, 0, 0);
1213 INSERT INTO `0_payment_terms` VALUES(4, 'Cash Only', 0, 0, 0);
1215 -- --------------------------------------------------------
1218 -- Table structure for table `0_prices`
1221 DROP TABLE IF EXISTS `0_prices`;
1222 CREATE TABLE IF NOT EXISTS `0_prices` (
1223 `id` int(11) NOT NULL auto_increment,
1224 `stock_id` varchar(20) NOT NULL default '',
1225 `sales_type_id` int(11) NOT NULL default '0',
1226 `curr_abrev` char(3) NOT NULL default '',
1227 `price` double NOT NULL default '0',
1229 UNIQUE KEY `price` (`stock_id`,`sales_type_id`,`curr_abrev`)
1230 ) ENGINE=MyISAM AUTO_INCREMENT=5 ;
1233 -- Dumping data for table `0_prices`
1236 INSERT INTO `0_prices` VALUES(1, '3400', 1, 'USD', 100);
1237 INSERT INTO `0_prices` VALUES(2, '102', 1, 'USD', 50);
1238 INSERT INTO `0_prices` VALUES(3, '103', 1, 'USD', 55);
1239 INSERT INTO `0_prices` VALUES(4, '104', 1, 'USD', 60);
1241 -- --------------------------------------------------------
1244 -- Table structure for table `0_printers`
1247 DROP TABLE IF EXISTS `0_printers`;
1248 CREATE TABLE IF NOT EXISTS `0_printers` (
1249 `id` tinyint(3) unsigned NOT NULL auto_increment,
1250 `name` varchar(20) NOT NULL,
1251 `description` varchar(60) NOT NULL,
1252 `queue` varchar(20) NOT NULL,
1253 `host` varchar(40) NOT NULL,
1254 `port` smallint(11) unsigned NOT NULL,
1255 `timeout` tinyint(3) unsigned NOT NULL,
1257 UNIQUE KEY `name` (`name`)
1258 ) ENGINE=MyISAM AUTO_INCREMENT=4 ;
1261 -- Dumping data for table `0_printers`
1264 INSERT INTO `0_printers` VALUES(1, 'QL500', 'Label printer', 'QL500', 'server', 127, 20);
1265 INSERT INTO `0_printers` VALUES(2, 'Samsung', 'Main network printer', 'scx4521F', 'server', 515, 5);
1266 INSERT INTO `0_printers` VALUES(3, 'Local', 'Local print server at user IP', 'lp', '', 515, 10);
1268 -- --------------------------------------------------------
1271 -- Table structure for table `0_print_profiles`
1274 DROP TABLE IF EXISTS `0_print_profiles`;
1275 CREATE TABLE IF NOT EXISTS `0_print_profiles` (
1276 `id` smallint(6) unsigned NOT NULL auto_increment,
1277 `profile` varchar(30) NOT NULL,
1278 `report` varchar(5) default NULL,
1279 `printer` tinyint(3) unsigned default NULL,
1281 UNIQUE KEY `profile` (`profile`,`report`)
1282 ) ENGINE=MyISAM AUTO_INCREMENT=10 ;
1285 -- Dumping data for table `0_print_profiles`
1288 INSERT INTO `0_print_profiles` VALUES(1, 'Out of office', '', 0);
1289 INSERT INTO `0_print_profiles` VALUES(2, 'Sales Department', '', 0);
1290 INSERT INTO `0_print_profiles` VALUES(3, 'Central', '', 2);
1291 INSERT INTO `0_print_profiles` VALUES(4, 'Sales Department', '104', 2);
1292 INSERT INTO `0_print_profiles` VALUES(5, 'Sales Department', '105', 2);
1293 INSERT INTO `0_print_profiles` VALUES(6, 'Sales Department', '107', 2);
1294 INSERT INTO `0_print_profiles` VALUES(7, 'Sales Department', '109', 2);
1295 INSERT INTO `0_print_profiles` VALUES(8, 'Sales Department', '110', 2);
1296 INSERT INTO `0_print_profiles` VALUES(9, 'Sales Department', '201', 2);
1298 -- --------------------------------------------------------
1301 -- Table structure for table `0_purch_data`
1304 DROP TABLE IF EXISTS `0_purch_data`;
1305 CREATE TABLE IF NOT EXISTS `0_purch_data` (
1306 `supplier_id` int(11) NOT NULL default '0',
1307 `stock_id` char(20) NOT NULL default '',
1308 `price` double NOT NULL default '0',
1309 `suppliers_uom` char(50) NOT NULL default '',
1310 `conversion_factor` double NOT NULL default '1',
1311 `supplier_description` char(50) NOT NULL default '',
1312 PRIMARY KEY (`supplier_id`,`stock_id`)
1316 -- Dumping data for table `0_purch_data`
1319 INSERT INTO `0_purch_data` VALUES(2, '102', 10, '', 1, '17inch VGA Monitor');
1320 INSERT INTO `0_purch_data` VALUES(2, '103', 11, '', 1, '32MB VGA Card');
1321 INSERT INTO `0_purch_data` VALUES(2, '104', 12, '', 1, '52x CD Drive');
1323 -- --------------------------------------------------------
1326 -- Table structure for table `0_purch_orders`
1329 DROP TABLE IF EXISTS `0_purch_orders`;
1330 CREATE TABLE IF NOT EXISTS `0_purch_orders` (
1331 `order_no` int(11) NOT NULL auto_increment,
1332 `supplier_id` int(11) NOT NULL default '0',
1333 `comments` tinytext,
1334 `ord_date` date NOT NULL default '0000-00-00',
1335 `reference` tinytext NOT NULL,
1336 `requisition_no` tinytext,
1337 `into_stock_location` varchar(5) NOT NULL default '',
1338 `delivery_address` tinytext NOT NULL,
1339 `total` double NOT NULL default '0',
1340 `tax_included` tinyint(1) NOT NULL default '0',
1341 PRIMARY KEY (`order_no`),
1342 KEY `ord_date` (`ord_date`)
1343 ) ENGINE=InnoDB AUTO_INCREMENT=3 ;
1346 -- Dumping data for table `0_purch_orders`
1349 INSERT INTO `0_purch_orders` VALUES(1, 2, '', '2009-06-01', '1', '', 'DEF', 'Delivery 1\nDelivery 2\nDelivery 3', 0, 0);
1350 INSERT INTO `0_purch_orders` VALUES(2, 3, '', '2009-06-21', '2', '', 'DEF', 'Delivery 1\nDelivery 2\nDelivery 3', 0, 0);
1352 -- --------------------------------------------------------
1355 -- Table structure for table `0_purch_order_details`
1358 DROP TABLE IF EXISTS `0_purch_order_details`;
1359 CREATE TABLE IF NOT EXISTS `0_purch_order_details` (
1360 `po_detail_item` int(11) NOT NULL auto_increment,
1361 `order_no` int(11) NOT NULL default '0',
1362 `item_code` varchar(20) NOT NULL default '',
1363 `description` tinytext,
1364 `delivery_date` date NOT NULL default '0000-00-00',
1365 `qty_invoiced` double NOT NULL default '0',
1366 `unit_price` double NOT NULL default '0',
1367 `act_price` double NOT NULL default '0',
1368 `std_cost_unit` double NOT NULL default '0',
1369 `quantity_ordered` double NOT NULL default '0',
1370 `quantity_received` double NOT NULL default '0',
1371 PRIMARY KEY (`po_detail_item`),
1372 KEY `order` (`order_no`,`po_detail_item`),
1373 KEY `itemcode` (`item_code`)
1374 ) ENGINE=InnoDB AUTO_INCREMENT=6 ;
1377 -- Dumping data for table `0_purch_order_details`
1380 INSERT INTO `0_purch_order_details` VALUES(1, 1, '102', '17inch VGA Monitor', '2009-07-01', 100, 10, 10, 10, 100, 100);
1381 INSERT INTO `0_purch_order_details` VALUES(2, 1, '103', '32MB VGA Card', '2009-07-01', 100, 11, 11, 11, 100, 100);
1382 INSERT INTO `0_purch_order_details` VALUES(3, 1, '104', '52x CD Drive', '2009-07-01', 100, 12, 12, 12, 100, 100);
1383 INSERT INTO `0_purch_order_details` VALUES(4, 2, '102', '17inch VGA Monitor', '2009-07-01', 0, 5, 0, 0, 1, 0);
1384 INSERT INTO `0_purch_order_details` VALUES(5, 2, '103', '32MB VGA Card', '2009-07-01', 0, 5, 0, 0, 1, 0);
1386 -- --------------------------------------------------------
1389 -- Table structure for table `0_quick_entries`
1392 DROP TABLE IF EXISTS `0_quick_entries`;
1393 CREATE TABLE IF NOT EXISTS `0_quick_entries` (
1394 `id` smallint(6) unsigned NOT NULL auto_increment,
1395 `type` tinyint(1) NOT NULL default '0',
1396 `description` varchar(60) NOT NULL,
1397 `base_amount` double NOT NULL default '0',
1398 `base_desc` varchar(60) default NULL,
1399 `bal_type` tinyint(1) NOT NULL default '0',
1401 KEY `description` (`description`)
1402 ) ENGINE=MyISAM AUTO_INCREMENT=4 ;
1405 -- Dumping data for table `0_quick_entries`
1408 INSERT INTO `0_quick_entries` VALUES(1, 1, 'Maintenance', 0, 'Amount', 0);
1409 INSERT INTO `0_quick_entries` VALUES(2, 4, 'Phone', 0, 'Amount', 0);
1410 INSERT INTO `0_quick_entries` VALUES(3, 2, 'Cash Sales', 0, 'Amount', 0);
1412 -- --------------------------------------------------------
1415 -- Table structure for table `0_quick_entry_lines`
1418 DROP TABLE IF EXISTS `0_quick_entry_lines`;
1419 CREATE TABLE IF NOT EXISTS `0_quick_entry_lines` (
1420 `id` smallint(6) unsigned NOT NULL auto_increment,
1421 `qid` smallint(6) unsigned NOT NULL,
1422 `amount` double default '0',
1423 `action` varchar(2) NOT NULL,
1424 `dest_id` varchar(15) NOT NULL default '',
1425 `dimension_id` smallint(6) unsigned default NULL,
1426 `dimension2_id` smallint(6) unsigned default NULL,
1429 ) ENGINE=MyISAM AUTO_INCREMENT=8 ;
1432 -- Dumping data for table `0_quick_entry_lines`
1435 INSERT INTO `0_quick_entry_lines` VALUES(1, 1, 0, 't-', '1', 0, 0);
1436 INSERT INTO `0_quick_entry_lines` VALUES(2, 2, 0, 't-', '1', 0, 0);
1437 INSERT INTO `0_quick_entry_lines` VALUES(3, 3, 0, 't-', '1', 0, 0);
1438 INSERT INTO `0_quick_entry_lines` VALUES(4, 3, 0, '=', '4010', 0, 0);
1439 INSERT INTO `0_quick_entry_lines` VALUES(5, 1, 0, '=', '5765', 0, 0);
1440 INSERT INTO `0_quick_entry_lines` VALUES(6, 2, 0, '=', '5780', 0, 0);
1442 -- --------------------------------------------------------
1445 -- Table structure for table `0_recurrent_invoices`
1448 DROP TABLE IF EXISTS `0_recurrent_invoices`;
1449 CREATE TABLE IF NOT EXISTS `0_recurrent_invoices` (
1450 `id` smallint(6) unsigned NOT NULL auto_increment,
1451 `description` varchar(60) NOT NULL default '',
1452 `order_no` int(11) unsigned NOT NULL,
1453 `debtor_no` int(11) unsigned default NULL,
1454 `group_no` smallint(6) unsigned default NULL,
1455 `days` int(11) NOT NULL default '0',
1456 `monthly` int(11) NOT NULL default '0',
1457 `begin` date NOT NULL default '0000-00-00',
1458 `end` date NOT NULL default '0000-00-00',
1459 `last_sent` date NOT NULL default '0000-00-00',
1461 UNIQUE KEY `description` (`description`)
1462 ) ENGINE=InnoDB AUTO_INCREMENT=1 ;
1465 -- Dumping data for table `0_recurrent_invoices`
1469 -- --------------------------------------------------------
1472 -- Table structure for table `0_refs`
1475 DROP TABLE IF EXISTS `0_refs`;
1476 CREATE TABLE IF NOT EXISTS `0_refs` (
1477 `id` int(11) NOT NULL default '0',
1478 `type` int(11) NOT NULL default '0',
1479 `reference` varchar(100) NOT NULL default '',
1480 PRIMARY KEY (`id`,`type`),
1481 KEY `Type_and_Reference` (`type`,`reference`)
1485 -- Dumping data for table `0_refs`
1488 INSERT INTO `0_refs` VALUES(18, 0, '1');
1489 INSERT INTO `0_refs` VALUES(19, 0, '2');
1491 -- --------------------------------------------------------
1494 -- Table structure for table `0_salesman`
1497 DROP TABLE IF EXISTS `0_salesman`;
1498 CREATE TABLE IF NOT EXISTS `0_salesman` (
1499 `salesman_code` int(11) NOT NULL auto_increment,
1500 `salesman_name` char(60) NOT NULL default '',
1501 `salesman_phone` char(30) NOT NULL default '',
1502 `salesman_fax` char(30) NOT NULL default '',
1503 `salesman_email` varchar(100) NOT NULL default '',
1504 `provision` double NOT NULL default '0',
1505 `break_pt` double NOT NULL default '0',
1506 `provision2` double NOT NULL default '0',
1507 `inactive` tinyint(1) NOT NULL default '0',
1508 PRIMARY KEY (`salesman_code`),
1509 UNIQUE KEY `salesman_name` (`salesman_name`)
1510 ) ENGINE=MyISAM AUTO_INCREMENT=2 ;
1513 -- Dumping data for table `0_salesman`
1516 INSERT INTO `0_salesman` VALUES(1, 'Sales Person', '', '', '', 5, 1000, 4, 0);
1518 -- --------------------------------------------------------
1521 -- Table structure for table `0_sales_orders`
1524 DROP TABLE IF EXISTS `0_sales_orders`;
1525 CREATE TABLE IF NOT EXISTS `0_sales_orders` (
1526 `order_no` int(11) NOT NULL,
1527 `trans_type` smallint(6) NOT NULL default '30',
1528 `version` tinyint(1) unsigned NOT NULL default '0',
1529 `type` tinyint(1) NOT NULL default '0',
1530 `debtor_no` int(11) NOT NULL default '0',
1531 `branch_code` int(11) NOT NULL default '0',
1532 `reference` varchar(100) NOT NULL default '',
1533 `customer_ref` tinytext NOT NULL,
1534 `comments` tinytext,
1535 `ord_date` date NOT NULL default '0000-00-00',
1536 `order_type` int(11) NOT NULL default '0',
1537 `ship_via` int(11) NOT NULL default '0',
1538 `delivery_address` tinytext NOT NULL,
1539 `contact_phone` varchar(30) default NULL,
1540 `contact_email` varchar(100) default NULL,
1541 `deliver_to` tinytext NOT NULL,
1542 `freight_cost` double NOT NULL default '0',
1543 `from_stk_loc` varchar(5) NOT NULL default '',
1544 `delivery_date` date NOT NULL default '0000-00-00',
1545 `payment_terms` int(11) default NULL,
1546 `total` double NOT NULL default '0',
1547 PRIMARY KEY (`trans_type`,`order_no`)
1551 -- Dumping data for table `0_sales_orders`
1554 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);
1555 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);
1556 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);
1557 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);
1558 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);
1560 -- --------------------------------------------------------
1563 -- Table structure for table `0_sales_order_details`
1566 DROP TABLE IF EXISTS `0_sales_order_details`;
1567 CREATE TABLE IF NOT EXISTS `0_sales_order_details` (
1568 `id` int(11) NOT NULL auto_increment,
1569 `order_no` int(11) NOT NULL default '0',
1570 `trans_type` smallint(6) NOT NULL default '30',
1571 `stk_code` varchar(20) NOT NULL default '',
1572 `description` tinytext,
1573 `qty_sent` double NOT NULL default '0',
1574 `unit_price` double NOT NULL default '0',
1575 `quantity` double NOT NULL default '0',
1576 `discount_percent` double NOT NULL default '0',
1578 KEY `sorder` (`trans_type`,`order_no`),
1579 KEY `stkcode` (`stk_code`)
1580 ) ENGINE=InnoDB AUTO_INCREMENT=6 ;
1583 -- Dumping data for table `0_sales_order_details`
1586 INSERT INTO `0_sales_order_details` VALUES(1, 1, 30, '102', '17inch VGA Monitor', 2, 30.4, 2, 0);
1587 INSERT INTO `0_sales_order_details` VALUES(2, 2, 30, '102', '17inch VGA Monitor', 1, 50, 1, 0);
1588 INSERT INTO `0_sales_order_details` VALUES(3, 3, 30, '102', '17inch VGA Monitor', 1, 35.89, 1, 0);
1589 INSERT INTO `0_sales_order_details` VALUES(4, 4, 30, '102', '17inch VGA Monitor', 0, 21.28, 2, 0);
1590 INSERT INTO `0_sales_order_details` VALUES(5, 5, 30, '102', '17inch VGA Monitor', 1, 50, 1, 0);
1592 -- --------------------------------------------------------
1595 -- Table structure for table `0_sales_pos`
1598 DROP TABLE IF EXISTS `0_sales_pos`;
1599 CREATE TABLE IF NOT EXISTS `0_sales_pos` (
1600 `id` smallint(6) unsigned NOT NULL auto_increment,
1601 `pos_name` varchar(30) NOT NULL,
1602 `cash_sale` tinyint(1) NOT NULL,
1603 `credit_sale` tinyint(1) NOT NULL,
1604 `pos_location` varchar(5) NOT NULL,
1605 `pos_account` smallint(6) unsigned NOT NULL,
1606 `inactive` tinyint(1) NOT NULL default '0',
1608 UNIQUE KEY `pos_name` (`pos_name`)
1609 ) ENGINE=MyISAM AUTO_INCREMENT=2 ;
1612 -- Dumping data for table `0_sales_pos`
1615 INSERT INTO `0_sales_pos` VALUES(1, 'Default', 1, 1, 'DEF', 2, 0);
1617 -- --------------------------------------------------------
1620 -- Table structure for table `0_sales_types`
1623 DROP TABLE IF EXISTS `0_sales_types`;
1624 CREATE TABLE IF NOT EXISTS `0_sales_types` (
1625 `id` int(11) NOT NULL auto_increment,
1626 `sales_type` char(50) NOT NULL default '',
1627 `tax_included` int(1) NOT NULL default '0',
1628 `factor` double NOT NULL default '1',
1629 `inactive` tinyint(1) NOT NULL default '0',
1631 UNIQUE KEY `sales_type` (`sales_type`)
1632 ) ENGINE=MyISAM AUTO_INCREMENT=3 ;
1635 -- Dumping data for table `0_sales_types`
1638 INSERT INTO `0_sales_types` VALUES(1, 'Retail', 1, 1, 0);
1639 INSERT INTO `0_sales_types` VALUES(2, 'Wholesale', 0, 0.7, 0);
1641 -- --------------------------------------------------------
1644 -- Table structure for table `0_security_roles`
1647 DROP TABLE IF EXISTS `0_security_roles`;
1648 CREATE TABLE IF NOT EXISTS `0_security_roles` (
1649 `id` int(11) NOT NULL auto_increment,
1650 `role` varchar(30) NOT NULL,
1651 `description` varchar(50) default NULL,
1654 `inactive` tinyint(1) NOT NULL default '0',
1656 UNIQUE KEY `role` (`role`)
1657 ) ENGINE=MyISAM AUTO_INCREMENT=11 ;
1660 -- Dumping data for table `0_security_roles`
1663 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);
1664 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);
1665 INSERT INTO `0_security_roles` VALUES(3, 'Salesman', 'Salesman', '768;3072;5632;8192;15872', '773;774;3073;3075;3081;5633;8194;15873', 0);
1666 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);
1667 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);
1668 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);
1669 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);
1670 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);
1671 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);
1672 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);
1674 -- --------------------------------------------------------
1677 -- Table structure for table `0_shippers`
1680 DROP TABLE IF EXISTS `0_shippers`;
1681 CREATE TABLE IF NOT EXISTS `0_shippers` (
1682 `shipper_id` int(11) NOT NULL auto_increment,
1683 `shipper_name` varchar(60) NOT NULL default '',
1684 `phone` varchar(30) NOT NULL default '',
1685 `phone2` varchar(30) NOT NULL default '',
1686 `contact` tinytext NOT NULL,
1687 `address` tinytext NOT NULL,
1688 `inactive` tinyint(1) NOT NULL default '0',
1689 PRIMARY KEY (`shipper_id`),
1690 UNIQUE KEY `name` (`shipper_name`)
1691 ) ENGINE=MyISAM AUTO_INCREMENT=2 ;
1694 -- Dumping data for table `0_shippers`
1697 INSERT INTO `0_shippers` VALUES(1, 'Default', '', '', '', '', 0);
1699 -- --------------------------------------------------------
1702 -- Table structure for table `0_sql_trail`
1705 DROP TABLE IF EXISTS `0_sql_trail`;
1706 CREATE TABLE IF NOT EXISTS `0_sql_trail` (
1707 `id` int(11) unsigned NOT NULL auto_increment,
1708 `sql` text NOT NULL,
1709 `result` tinyint(1) NOT NULL,
1710 `msg` varchar(255) NOT NULL,
1712 ) ENGINE=MyISAM AUTO_INCREMENT=1 ;
1715 -- Dumping data for table `0_sql_trail`
1719 -- --------------------------------------------------------
1722 -- Table structure for table `0_stock_category`
1725 DROP TABLE IF EXISTS `0_stock_category`;
1726 CREATE TABLE IF NOT EXISTS `0_stock_category` (
1727 `category_id` int(11) NOT NULL auto_increment,
1728 `description` varchar(60) NOT NULL default '',
1729 `dflt_tax_type` int(11) NOT NULL default '1',
1730 `dflt_units` varchar(20) NOT NULL default 'each',
1731 `dflt_mb_flag` char(1) NOT NULL default 'B',
1732 `dflt_sales_act` varchar(15) NOT NULL default '',
1733 `dflt_cogs_act` varchar(15) NOT NULL default '',
1734 `dflt_inventory_act` varchar(15) NOT NULL default '',
1735 `dflt_adjustment_act` varchar(15) NOT NULL default '',
1736 `dflt_assembly_act` varchar(15) NOT NULL default '',
1737 `dflt_dim1` int(11) default NULL,
1738 `dflt_dim2` int(11) default NULL,
1739 `inactive` tinyint(1) NOT NULL default '0',
1740 `dflt_no_sale` tinyint(1) NOT NULL default '0',
1741 PRIMARY KEY (`category_id`),
1742 UNIQUE KEY `description` (`description`)
1743 ) ENGINE=MyISAM AUTO_INCREMENT=5 ;
1746 -- Dumping data for table `0_stock_category`
1749 INSERT INTO `0_stock_category` VALUES(1, 'Components', 1, 'each', 'B', '4010', '5010', '1510', '5040', '1530', 0, 0, 0, 0);
1750 INSERT INTO `0_stock_category` VALUES(2, 'Charges', 1, 'each', 'D', '4010', '5010', '1510', '5040', '1530', 0, 0, 0, 0);
1751 INSERT INTO `0_stock_category` VALUES(3, 'Systems', 1, 'each', 'M', '4010', '5010', '1510', '5040', '1530', 0, 0, 0, 0);
1752 INSERT INTO `0_stock_category` VALUES(4, 'Services', 1, 'hrs', 'D', '4010', '5010', '1510', '5040', '1530', 0, 0, 0, 0);
1754 -- --------------------------------------------------------
1757 -- Table structure for table `0_stock_master`
1760 DROP TABLE IF EXISTS `0_stock_master`;
1761 CREATE TABLE IF NOT EXISTS `0_stock_master` (
1762 `stock_id` varchar(20) NOT NULL default '',
1763 `category_id` int(11) NOT NULL default '0',
1764 `tax_type_id` int(11) NOT NULL default '0',
1765 `description` varchar(200) NOT NULL default '',
1766 `long_description` tinytext NOT NULL,
1767 `units` varchar(20) NOT NULL default 'each',
1768 `mb_flag` char(1) NOT NULL default 'B',
1769 `sales_account` varchar(15) NOT NULL default '',
1770 `cogs_account` varchar(15) NOT NULL default '',
1771 `inventory_account` varchar(15) NOT NULL default '',
1772 `adjustment_account` varchar(15) NOT NULL default '',
1773 `assembly_account` varchar(15) NOT NULL default '',
1774 `dimension_id` int(11) default NULL,
1775 `dimension2_id` int(11) default NULL,
1776 `actual_cost` double NOT NULL default '0',
1777 `last_cost` double NOT NULL default '0',
1778 `material_cost` double NOT NULL default '0',
1779 `labour_cost` double NOT NULL default '0',
1780 `overhead_cost` double NOT NULL default '0',
1781 `inactive` tinyint(1) NOT NULL default '0',
1782 `no_sale` tinyint(1) NOT NULL default '0',
1783 `editable` tinyint(1) NOT NULL default '0',
1784 PRIMARY KEY (`stock_id`)
1788 -- Dumping data for table `0_stock_master`
1791 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);
1792 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);
1793 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);
1794 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);
1795 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);
1797 -- --------------------------------------------------------
1800 -- Table structure for table `0_stock_moves`
1803 DROP TABLE IF EXISTS `0_stock_moves`;
1804 CREATE TABLE IF NOT EXISTS `0_stock_moves` (
1805 `trans_id` int(11) NOT NULL auto_increment,
1806 `trans_no` int(11) NOT NULL default '0',
1807 `stock_id` char(20) NOT NULL default '',
1808 `type` smallint(6) NOT NULL default '0',
1809 `loc_code` char(5) NOT NULL default '',
1810 `tran_date` date NOT NULL default '0000-00-00',
1811 `person_id` int(11) default NULL,
1812 `price` double NOT NULL default '0',
1813 `reference` char(40) NOT NULL default '',
1814 `qty` double NOT NULL default '1',
1815 `discount_percent` double NOT NULL default '0',
1816 `standard_cost` double NOT NULL default '0',
1817 `visible` tinyint(1) NOT NULL default '1',
1818 PRIMARY KEY (`trans_id`),
1819 KEY `type` (`type`,`trans_no`),
1820 KEY `Move` (`stock_id`,`loc_code`,`tran_date`)
1821 ) ENGINE=InnoDB AUTO_INCREMENT=37 ;
1824 -- Dumping data for table `0_stock_moves`
1827 INSERT INTO `0_stock_moves` VALUES(1, 1, '102', 25, 'DEF', '2009-06-21', 2, 10, '', 100, 0, 10, 1);
1828 INSERT INTO `0_stock_moves` VALUES(2, 1, '103', 25, 'DEF', '2009-06-21', 2, 11, '', 100, 0, 11, 1);
1829 INSERT INTO `0_stock_moves` VALUES(3, 1, '104', 25, 'DEF', '2009-06-21', 2, 12, '', 100, 0, 12, 1);
1830 INSERT INTO `0_stock_moves` VALUES(4, 1, '102', 26, 'DEF', '2009-06-21', 0, 0, '1', -10, 0, 0, 1);
1831 INSERT INTO `0_stock_moves` VALUES(5, 1, '103', 26, 'DEF', '2009-06-21', 0, 0, '1', -10, 0, 0, 1);
1832 INSERT INTO `0_stock_moves` VALUES(6, 1, '104', 26, 'DEF', '2009-06-21', 0, 0, '1', -10, 0, 0, 1);
1833 INSERT INTO `0_stock_moves` VALUES(7, 1, '3400', 26, 'DEF', '2009-06-21', 0, 0, '1', 10, 0, 0, 1);
1834 INSERT INTO `0_stock_moves` VALUES(8, 2, '102', 13, 'DEF', '2009-06-21', 0, 30.4, '1', -2, 0, 10, 1);
1835 INSERT INTO `0_stock_moves` VALUES(9, 3, '102', 13, 'DEF', '2009-06-21', 0, 50, 'auto', -1, 0, 10, 1);
1836 INSERT INTO `0_stock_moves` VALUES(10, 4, '102', 13, 'DEF', '2009-06-21', 0, 35.89, 'auto', -1, 0, 10, 1);
1837 INSERT INTO `0_stock_moves` VALUES(11, 3, '102', 26, 'DEF', '2009-06-21', 0, 0, '3', -2, 0, 0, 1);
1838 INSERT INTO `0_stock_moves` VALUES(12, 3, '103', 26, 'DEF', '2009-06-21', 0, 0, '3', -2, 0, 0, 1);
1839 INSERT INTO `0_stock_moves` VALUES(13, 3, '104', 26, 'DEF', '2009-06-21', 0, 0, '3', -2, 0, 0, 1);
1840 INSERT INTO `0_stock_moves` VALUES(14, 3, '3400', 26, 'DEF', '2009-06-21', 0, 0, '3', 2, 0, 0, 1);
1841 INSERT INTO `0_stock_moves` VALUES(15, 4, '102', 26, 'DEF', '2009-06-21', 0, 0, '4', -4, 0, 0, 1);
1842 INSERT INTO `0_stock_moves` VALUES(16, 4, '103', 26, 'DEF', '2009-06-21', 0, 0, '4', -4, 0, 0, 1);
1843 INSERT INTO `0_stock_moves` VALUES(17, 4, '104', 26, 'DEF', '2009-06-21', 0, 0, '4', -4, 0, 0, 1);
1844 INSERT INTO `0_stock_moves` VALUES(18, 4, '3400', 26, 'DEF', '2009-06-21', 0, 0, '4', 4, 0, 0, 1);
1845 INSERT INTO `0_stock_moves` VALUES(19, 2, '102', 26, 'DEF', '2009-06-21', 0, 0, '', -2, 0, 0, 1);
1846 INSERT INTO `0_stock_moves` VALUES(20, 2, '103', 26, 'DEF', '2009-06-21', 0, 0, '', -2, 0, 0, 1);
1847 INSERT INTO `0_stock_moves` VALUES(21, 2, '104', 26, 'DEF', '2009-06-21', 0, 0, '', -2, 0, 0, 1);
1848 INSERT INTO `0_stock_moves` VALUES(22, 1, '3400', 29, 'DEF', '2009-06-21', 0, 0, '', 2, 0, 0, 1);
1849 INSERT INTO `0_stock_moves` VALUES(23, 5, '102', 26, 'DEF', '2009-06-21', 0, 0, '5', -5, 0, 0, 1);
1850 INSERT INTO `0_stock_moves` VALUES(24, 5, '103', 26, 'DEF', '2009-06-21', 0, 0, '5', -5, 0, 0, 1);
1851 INSERT INTO `0_stock_moves` VALUES(25, 5, '104', 26, 'DEF', '2009-06-21', 0, 0, '5', -5, 0, 0, 1);
1852 INSERT INTO `0_stock_moves` VALUES(26, 5, '3400', 26, 'DEF', '2009-06-21', 0, 0, '5', 5, 0, 0, 1);
1853 INSERT INTO `0_stock_moves` VALUES(27, 6, '102', 26, 'DEF', '2009-06-21', 0, 0, '6', 5, 0, 0, 1);
1854 INSERT INTO `0_stock_moves` VALUES(28, 6, '103', 26, 'DEF', '2009-06-21', 0, 0, '6', 5, 0, 0, 1);
1855 INSERT INTO `0_stock_moves` VALUES(29, 6, '104', 26, 'DEF', '2009-06-21', 0, 0, '6', 5, 0, 0, 1);
1856 INSERT INTO `0_stock_moves` VALUES(30, 6, '3400', 26, 'DEF', '2009-06-21', 0, 0, '6', -5, 0, 0, 1);
1857 INSERT INTO `0_stock_moves` VALUES(31, 7, '102', 26, 'DEF', '2009-06-21', 0, 0, '7', 2, 0, 0, 1);
1858 INSERT INTO `0_stock_moves` VALUES(32, 7, '103', 26, 'DEF', '2009-06-21', 0, 0, '7', 2, 0, 0, 1);
1859 INSERT INTO `0_stock_moves` VALUES(33, 7, '104', 26, 'DEF', '2009-06-21', 0, 0, '7', 2, 0, 0, 1);
1860 INSERT INTO `0_stock_moves` VALUES(34, 7, '3400', 26, 'DEF', '2009-06-21', 0, 0, '7', -2, 0, 0, 1);
1861 INSERT INTO `0_stock_moves` VALUES(35, 5, '102', 13, 'DEF', '2009-06-21', 0, 50, 'auto', -1, 0, 10, 1);
1862 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);
1864 -- --------------------------------------------------------
1867 -- Table structure for table `0_suppliers`
1870 DROP TABLE IF EXISTS `0_suppliers`;
1871 CREATE TABLE IF NOT EXISTS `0_suppliers` (
1872 `supplier_id` int(11) NOT NULL auto_increment,
1873 `supp_name` varchar(60) NOT NULL default '',
1874 `supp_ref` varchar(30) NOT NULL default '',
1875 `address` tinytext NOT NULL,
1876 `supp_address` tinytext NOT NULL,
1877 `gst_no` varchar(25) NOT NULL default '',
1878 `contact` varchar(60) NOT NULL default '',
1879 `supp_account_no` varchar(40) NOT NULL default '',
1880 `website` varchar(100) NOT NULL default '',
1881 `bank_account` varchar(60) NOT NULL default '',
1882 `curr_code` char(3) default NULL,
1883 `payment_terms` int(11) default NULL,
1884 `tax_included` tinyint(1) NOT NULL default '0',
1885 `tax_algorithm` tinyint(1) NOT NULL default '1',
1886 `dimension_id` int(11) default '0',
1887 `dimension2_id` int(11) default '0',
1888 `tax_group_id` int(11) default NULL,
1889 `credit_limit` double NOT NULL default '0',
1890 `purchase_account` varchar(15) NOT NULL default '',
1891 `payable_account` varchar(15) NOT NULL default '',
1892 `payment_discount_account` varchar(15) NOT NULL default '',
1893 `notes` tinytext NOT NULL,
1894 `inactive` tinyint(1) NOT NULL default '0',
1895 PRIMARY KEY (`supplier_id`),
1896 KEY `supp_ref` (`supp_ref`)
1897 ) ENGINE=MyISAM AUTO_INCREMENT=4 ;
1900 -- Dumping data for table `0_suppliers`
1903 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);
1904 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);
1905 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);
1907 -- --------------------------------------------------------
1910 -- Table structure for table `0_supp_allocations`
1913 DROP TABLE IF EXISTS `0_supp_allocations`;
1914 CREATE TABLE IF NOT EXISTS `0_supp_allocations` (
1915 `id` int(11) NOT NULL auto_increment,
1916 `amt` double unsigned default NULL,
1917 `date_alloc` date NOT NULL default '0000-00-00',
1918 `trans_no_from` int(11) default NULL,
1919 `trans_type_from` int(11) default NULL,
1920 `trans_no_to` int(11) default NULL,
1921 `trans_type_to` int(11) default NULL,
1923 KEY `From` (`trans_type_from`,`trans_no_from`),
1924 KEY `To` (`trans_type_to`,`trans_no_to`)
1925 ) ENGINE=InnoDB AUTO_INCREMENT=2 ;
1928 -- Dumping data for table `0_supp_allocations`
1931 INSERT INTO `0_supp_allocations` VALUES(1, 3465, '2009-06-21', 4, 22, 7, 20);
1933 -- --------------------------------------------------------
1936 -- Table structure for table `0_supp_invoice_items`
1939 DROP TABLE IF EXISTS `0_supp_invoice_items`;
1940 CREATE TABLE IF NOT EXISTS `0_supp_invoice_items` (
1941 `id` int(11) NOT NULL auto_increment,
1942 `supp_trans_no` int(11) default NULL,
1943 `supp_trans_type` int(11) default NULL,
1944 `gl_code` varchar(15) NOT NULL default '',
1945 `grn_item_id` int(11) default NULL,
1946 `po_detail_item_id` int(11) default NULL,
1947 `stock_id` varchar(20) NOT NULL default '',
1948 `description` tinytext,
1949 `quantity` double NOT NULL default '0',
1950 `unit_price` double NOT NULL default '0',
1951 `unit_tax` double NOT NULL default '0',
1954 KEY `Transaction` (`supp_trans_type`,`supp_trans_no`,`stock_id`)
1955 ) ENGINE=InnoDB AUTO_INCREMENT=6 ;
1958 -- Dumping data for table `0_supp_invoice_items`
1961 INSERT INTO `0_supp_invoice_items` VALUES(1, 7, 20, '0', 1, 1, '102', '17inch VGA Monitor', 100, 10, 0.5, '');
1962 INSERT INTO `0_supp_invoice_items` VALUES(2, 7, 20, '0', 2, 2, '103', '32MB VGA Card', 100, 11, 0.55, '');
1963 INSERT INTO `0_supp_invoice_items` VALUES(3, 7, 20, '0', 3, 3, '104', '52x CD Drive', 100, 12, 0.6, '');
1964 INSERT INTO `0_supp_invoice_items` VALUES(4, 8, 20, '2150', 0, 0, '', '', 0, 0.95, 0, 'Phone');
1965 INSERT INTO `0_supp_invoice_items` VALUES(5, 8, 20, '5780', 0, 0, '', '', 0, 19.05, 0, 'Phone');
1967 -- --------------------------------------------------------
1970 -- Table structure for table `0_supp_trans`
1973 DROP TABLE IF EXISTS `0_supp_trans`;
1974 CREATE TABLE IF NOT EXISTS `0_supp_trans` (
1975 `trans_no` int(11) unsigned NOT NULL default '0',
1976 `type` smallint(6) unsigned NOT NULL default '0',
1977 `supplier_id` int(11) unsigned default NULL,
1978 `reference` tinytext NOT NULL,
1979 `supp_reference` varchar(60) NOT NULL default '',
1980 `tran_date` date NOT NULL default '0000-00-00',
1981 `due_date` date NOT NULL default '0000-00-00',
1982 `ov_amount` double NOT NULL default '0',
1983 `ov_discount` double NOT NULL default '0',
1984 `ov_gst` double NOT NULL default '0',
1985 `rate` double NOT NULL default '1',
1986 `alloc` double NOT NULL default '0',
1987 `tax_included` tinyint(1) NOT NULL default '0',
1988 `tax_algorihm` tinyint(1) NOT NULL default '1',
1989 PRIMARY KEY (`type`,`trans_no`),
1990 KEY `supplier_id` (`supplier_id`),
1991 KEY `SupplierID_2` (`supplier_id`,`supp_reference`),
1992 KEY `type` (`type`),
1993 KEY `tran_date` (`tran_date`)
1997 -- Dumping data for table `0_supp_trans`
2000 INSERT INTO `0_supp_trans` VALUES(7, 20, 2, '1', '5t', '2009-06-21', '2009-07-01', 3300, 0, 165, 1, 3465, 0, 1);
2001 INSERT INTO `0_supp_trans` VALUES(8, 20, 2, '2', 'cc', '2009-06-21', '2009-07-01', 20, 0, 0, 1, 0, 0, 1);
2002 INSERT INTO `0_supp_trans` VALUES(4, 22, 2, '1', '', '2009-06-21', '2009-06-21', -3465, 0, 0, 1, 3465, 0, 1);
2004 -- --------------------------------------------------------
2007 -- Table structure for table `0_sys_prefs`
2010 DROP TABLE IF EXISTS `0_sys_prefs`;
2011 CREATE TABLE IF NOT EXISTS `0_sys_prefs` (
2012 `name` varchar(35) NOT NULL default '',
2013 `category` varchar(30) default NULL,
2014 `type` varchar(20) NOT NULL default '',
2015 `length` smallint(6) default NULL,
2017 PRIMARY KEY (`name`),
2018 KEY `category` (`category`)
2022 -- Dumping data for table `0_sys_prefs`
2025 INSERT INTO `0_sys_prefs` VALUES('coy_name', 'setup.company', 'varchar', 60, 'Training Co.');
2026 INSERT INTO `0_sys_prefs` VALUES('gst_no', 'setup.company', 'varchar', 25, '9876543');
2027 INSERT INTO `0_sys_prefs` VALUES('coy_no', 'setup.company', 'varchar', 25, '123456789');
2028 INSERT INTO `0_sys_prefs` VALUES('tax_prd', 'setup.company', 'int', 11, '1');
2029 INSERT INTO `0_sys_prefs` VALUES('tax_last', 'setup.company', 'int', 11, '1');
2030 INSERT INTO `0_sys_prefs` VALUES('postal_address', 'setup.company', 'tinytext', 0, 'Address 1\nAddress 2\nAddress 3');
2031 INSERT INTO `0_sys_prefs` VALUES('phone', 'setup.company', 'varchar', 30, '(222) 111.222.333');
2032 INSERT INTO `0_sys_prefs` VALUES('fax', 'setup.company', 'varchar', 30, '');
2033 INSERT INTO `0_sys_prefs` VALUES('email', 'setup.company', 'varchar', 100, 'delta@delta.com');
2034 INSERT INTO `0_sys_prefs` VALUES('coy_logo', 'setup.company', 'varchar', 100, 'logo_frontaccounting.jpg');
2035 INSERT INTO `0_sys_prefs` VALUES('domicile', 'setup.company', 'varchar', 55, '');
2036 INSERT INTO `0_sys_prefs` VALUES('curr_default', 'setup.company', 'char', 3, 'USD');
2037 INSERT INTO `0_sys_prefs` VALUES('use_dimension', 'setup.company', 'tinyint', 1, '1');
2038 INSERT INTO `0_sys_prefs` VALUES('f_year', 'setup.company', 'int', 11, '3');
2039 INSERT INTO `0_sys_prefs` VALUES('no_item_list', 'setup.company', 'tinyint', 1, '0');
2040 INSERT INTO `0_sys_prefs` VALUES('no_customer_list', 'setup.company', 'tinyint', 1, '0');
2041 INSERT INTO `0_sys_prefs` VALUES('no_supplier_list', 'setup.company', 'tinyint', 1, '0');
2042 INSERT INTO `0_sys_prefs` VALUES('base_sales', 'setup.company', 'int', 11, '1');
2043 INSERT INTO `0_sys_prefs` VALUES('time_zone', 'setup.company', 'tinyint', 1, '0');
2044 INSERT INTO `0_sys_prefs` VALUES('add_pct', 'setup.company', 'int', 5, '-1');
2045 INSERT INTO `0_sys_prefs` VALUES('round_to', 'setup.company', 'int', 5, '1');
2046 INSERT INTO `0_sys_prefs` VALUES('login_tout', 'setup.company', 'smallint', 6, '600');
2047 INSERT INTO `0_sys_prefs` VALUES('past_due_days', 'glsetup.general', 'int', 11, '30');
2048 INSERT INTO `0_sys_prefs` VALUES('profit_loss_year_act', 'glsetup.general', 'varchar', 15, '9990');
2049 INSERT INTO `0_sys_prefs` VALUES('retained_earnings_act', 'glsetup.general', 'varchar', 15, '3590');
2050 INSERT INTO `0_sys_prefs` VALUES('bank_charge_act', 'glsetup.general', 'varchar', 15, '5690');
2051 INSERT INTO `0_sys_prefs` VALUES('exchange_diff_act', 'glsetup.general', 'varchar', 15, '4450');
2052 INSERT INTO `0_sys_prefs` VALUES('tax_algorithm', 'glsetup.general', 'tinyint', 1, '1');
2053 INSERT INTO `0_sys_prefs` VALUES('default_credit_limit', 'glsetup.customer', 'int', 11, '1000');
2054 INSERT INTO `0_sys_prefs` VALUES('accumulate_shipping', 'glsetup.customer', 'tinyint', 1, '0');
2055 INSERT INTO `0_sys_prefs` VALUES('legal_text', 'glsetup.customer', 'tinytext', 0, '');
2056 INSERT INTO `0_sys_prefs` VALUES('freight_act', 'glsetup.customer', 'varchar', 15, '4430');
2057 INSERT INTO `0_sys_prefs` VALUES('debtors_act', 'glsetup.sales', 'varchar', 15, '1200');
2058 INSERT INTO `0_sys_prefs` VALUES('default_sales_act', 'glsetup.sales', 'varchar', 15, '4010');
2059 INSERT INTO `0_sys_prefs` VALUES('default_sales_discount_act', 'glsetup.sales', 'varchar', 15, '4510');
2060 INSERT INTO `0_sys_prefs` VALUES('default_prompt_payment_act', 'glsetup.sales', 'varchar', 15, '4500');
2061 INSERT INTO `0_sys_prefs` VALUES('default_delivery_required', 'glsetup.sales', 'smallint', 6, '1');
2062 INSERT INTO `0_sys_prefs` VALUES('default_receival_required', 'glsetup.purchase', 'smallint', 6, '10');
2063 INSERT INTO `0_sys_prefs` VALUES('default_dim_required', 'glsetup.dims', 'int', 11, '20');
2064 INSERT INTO `0_sys_prefs` VALUES('pyt_discount_act', 'glsetup.purchase', 'varchar', 15, '5060');
2065 INSERT INTO `0_sys_prefs` VALUES('creditors_act', 'glsetup.purchase', 'varchar', 15, '2100');
2066 INSERT INTO `0_sys_prefs` VALUES('po_over_receive', 'glsetup.purchase', 'int', 11, '10');
2067 INSERT INTO `0_sys_prefs` VALUES('po_over_charge', 'glsetup.purchase', 'int', 11, '10');
2068 INSERT INTO `0_sys_prefs` VALUES('allow_negative_stock', 'glsetup.inventory', 'tinyint', 1, '0');
2069 INSERT INTO `0_sys_prefs` VALUES('default_inventory_act', 'glsetup.items', 'varchar', 15, '1510');
2070 INSERT INTO `0_sys_prefs` VALUES('default_cogs_act', 'glsetup.items', 'varchar', 15, '5010');
2071 INSERT INTO `0_sys_prefs` VALUES('default_adj_act', 'glsetup.items', 'varchar', 15, '5040');
2072 INSERT INTO `0_sys_prefs` VALUES('default_inv_sales_act', 'glsetup.items', 'varchar', 15, '4010');
2073 INSERT INTO `0_sys_prefs` VALUES('default_assembly_act', 'glsetup.items', 'varchar', 15, '1530');
2074 INSERT INTO `0_sys_prefs` VALUES('default_workorder_required', 'glsetup.manuf', 'int', 11, '20');
2075 INSERT INTO `0_sys_prefs` VALUES('version_id', 'system', 'varchar', 11, '2.3rc');
2076 INSERT INTO `0_sys_prefs` VALUES('auto_curr_reval', 'setup.company', 'smallint', 6, '1');
2077 INSERT INTO `0_sys_prefs` VALUES('grn_clearing_act', 'glsetup.purchase', 'varchar', 15, '1550');
2079 -- --------------------------------------------------------
2082 -- Table structure for table `0_sys_types`
2085 DROP TABLE IF EXISTS `0_sys_types`;
2086 CREATE TABLE IF NOT EXISTS `0_sys_types` (
2087 `type_id` smallint(6) NOT NULL default '0',
2088 `type_no` int(11) NOT NULL default '1',
2089 `next_reference` varchar(100) NOT NULL default '',
2090 PRIMARY KEY (`type_id`)
2094 -- Dumping data for table `0_sys_types`
2097 INSERT INTO `0_sys_types` VALUES(0, 19, '3');
2098 INSERT INTO `0_sys_types` VALUES(1, 8, '2');
2099 INSERT INTO `0_sys_types` VALUES(2, 5, '2');
2100 INSERT INTO `0_sys_types` VALUES(4, 3, '1');
2101 INSERT INTO `0_sys_types` VALUES(10, 19, '4');
2102 INSERT INTO `0_sys_types` VALUES(11, 3, '2');
2103 INSERT INTO `0_sys_types` VALUES(12, 6, '1');
2104 INSERT INTO `0_sys_types` VALUES(13, 5, '2');
2105 INSERT INTO `0_sys_types` VALUES(16, 2, '1');
2106 INSERT INTO `0_sys_types` VALUES(17, 2, '1');
2107 INSERT INTO `0_sys_types` VALUES(18, 1, '3');
2108 INSERT INTO `0_sys_types` VALUES(20, 8, '3');
2109 INSERT INTO `0_sys_types` VALUES(21, 1, '1');
2110 INSERT INTO `0_sys_types` VALUES(22, 4, '2');
2111 INSERT INTO `0_sys_types` VALUES(25, 1, '2');
2112 INSERT INTO `0_sys_types` VALUES(26, 1, '8');
2113 INSERT INTO `0_sys_types` VALUES(28, 1, '1');
2114 INSERT INTO `0_sys_types` VALUES(29, 1, '2');
2115 INSERT INTO `0_sys_types` VALUES(30, 5, '6');
2116 INSERT INTO `0_sys_types` VALUES(32, 0, '1');
2117 INSERT INTO `0_sys_types` VALUES(35, 1, '1');
2118 INSERT INTO `0_sys_types` VALUES(40, 1, '3');
2120 -- --------------------------------------------------------
2123 -- Table structure for table `0_tags`
2126 DROP TABLE IF EXISTS `0_tags`;
2127 CREATE TABLE IF NOT EXISTS `0_tags` (
2128 `id` int(11) NOT NULL auto_increment,
2129 `type` smallint(6) NOT NULL,
2130 `name` varchar(30) NOT NULL,
2131 `description` varchar(60) default NULL,
2132 `inactive` tinyint(1) NOT NULL default '0',
2134 UNIQUE KEY `type` (`type`,`name`)
2135 ) ENGINE=MyISAM AUTO_INCREMENT=1 ;
2138 -- Dumping data for table `0_tags`
2142 -- --------------------------------------------------------
2145 -- Table structure for table `0_tag_associations`
2148 DROP TABLE IF EXISTS `0_tag_associations`;
2149 CREATE TABLE IF NOT EXISTS `0_tag_associations` (
2150 `record_id` varchar(15) NOT NULL,
2151 `tag_id` int(11) NOT NULL,
2152 UNIQUE KEY `record_id` (`record_id`,`tag_id`)
2156 -- Dumping data for table `0_tag_associations`
2160 -- --------------------------------------------------------
2163 -- Table structure for table `0_tax_groups`
2166 DROP TABLE IF EXISTS `0_tax_groups`;
2167 CREATE TABLE IF NOT EXISTS `0_tax_groups` (
2168 `id` int(11) NOT NULL auto_increment,
2169 `name` varchar(60) NOT NULL default '',
2170 `inactive` tinyint(1) NOT NULL default '0',
2172 UNIQUE KEY `name` (`name`)
2173 ) ENGINE=InnoDB AUTO_INCREMENT=3 ;
2176 -- Dumping data for table `0_tax_groups`
2179 INSERT INTO `0_tax_groups` VALUES(1, 'Tax', 0);
2180 INSERT INTO `0_tax_groups` VALUES(2, 'Tax Exempt', 0);
2182 -- --------------------------------------------------------
2185 -- Table structure for table `0_tax_group_items`
2188 DROP TABLE IF EXISTS `0_tax_group_items`;
2189 CREATE TABLE IF NOT EXISTS `0_tax_group_items` (
2190 `tax_group_id` int(11) NOT NULL default '0',
2191 `tax_type_id` int(11) NOT NULL default '0',
2192 `tax_shipping` tinyint(1) NOT NULL default '0',
2193 PRIMARY KEY (`tax_group_id`,`tax_type_id`)
2197 -- Dumping data for table `0_tax_group_items`
2200 INSERT INTO `0_tax_group_items` VALUES(1, 1, 1);
2202 -- --------------------------------------------------------
2205 -- Table structure for table `0_tax_types`
2208 DROP TABLE IF EXISTS `0_tax_types`;
2209 CREATE TABLE IF NOT EXISTS `0_tax_types` (
2210 `id` int(11) NOT NULL auto_increment,
2211 `rate` double NOT NULL default '0',
2212 `sales_gl_code` varchar(15) NOT NULL default '',
2213 `purchasing_gl_code` varchar(15) NOT NULL default '',
2214 `name` varchar(60) NOT NULL default '',
2215 `inactive` tinyint(1) NOT NULL default '0',
2217 ) ENGINE=InnoDB AUTO_INCREMENT=2 ;
2220 -- Dumping data for table `0_tax_types`
2223 INSERT INTO `0_tax_types` VALUES(1, 5, '2150', '2150', 'Tax', 0);
2225 -- --------------------------------------------------------
2228 -- Table structure for table `0_trans_tax_details`
2231 DROP TABLE IF EXISTS `0_trans_tax_details`;
2232 CREATE TABLE IF NOT EXISTS `0_trans_tax_details` (
2233 `id` int(11) NOT NULL auto_increment,
2234 `trans_type` smallint(6) default NULL,
2235 `trans_no` int(11) default NULL,
2236 `tran_date` date NOT NULL,
2237 `tax_type_id` int(11) NOT NULL default '0',
2238 `rate` double NOT NULL default '0',
2239 `ex_rate` double NOT NULL default '1',
2240 `included_in_price` tinyint(1) NOT NULL default '0',
2241 `net_amount` double NOT NULL default '0',
2242 `amount` double NOT NULL default '0',
2245 KEY `Type_and_Number` (`trans_type`,`trans_no`),
2246 KEY `tran_date` (`tran_date`)
2247 ) ENGINE=InnoDB AUTO_INCREMENT=12 ;
2250 -- Dumping data for table `0_trans_tax_details`
2253 INSERT INTO `0_trans_tax_details` VALUES(1, 20, 7, '2009-06-21', 1, 5, 1, 0, 3300, 165, '5t');
2254 INSERT INTO `0_trans_tax_details` VALUES(2, 13, 3, '2009-06-21', 1, 5, 1, 0, 50, 2.5, 'auto');
2255 INSERT INTO `0_trans_tax_details` VALUES(3, 10, 17, '2009-06-21', 1, 5, 1, 0, 50, 2.5, '1');
2256 INSERT INTO `0_trans_tax_details` VALUES(4, 13, 4, '2009-06-21', 1, 5, 1.3932, 0, 35.89, 1.7945, 'auto');
2257 INSERT INTO `0_trans_tax_details` VALUES(5, 10, 18, '2009-06-21', 1, 5, 1.3932, 0, 35.89, 1.7945, '2');
2258 INSERT INTO `0_trans_tax_details` VALUES(6, 2, 5, '2009-06-21', 1, 5, 1, 0, 95.2, 4.76, '');
2259 INSERT INTO `0_trans_tax_details` VALUES(7, 1, 8, '2009-06-21', 1, 5, 1, 0, -47.6, -2.38, '');
2260 INSERT INTO `0_trans_tax_details` VALUES(8, 20, 8, '2009-06-21', 1, 5, 1, 0, -19, -0.95, 'cc');
2261 INSERT INTO `0_trans_tax_details` VALUES(9, 13, 5, '2009-06-21', 1, 5, 1, 1, 47.619047619048, 2.3809523809524, 'auto');
2262 INSERT INTO `0_trans_tax_details` VALUES(10, 10, 19, '2009-06-21', 1, 5, 1, 1, 47.619047619048, 2.3809523809524, '3');
2263 INSERT INTO `0_trans_tax_details` VALUES(11, 11, 3, '2009-06-21', 1, 5, 1.3932, 0, 35.89, 1.7945, '1');
2265 -- --------------------------------------------------------
2268 -- Table structure for table `0_useronline`
2271 DROP TABLE IF EXISTS `0_useronline`;
2272 CREATE TABLE IF NOT EXISTS `0_useronline` (
2273 `id` int(11) NOT NULL auto_increment,
2274 `timestamp` int(15) NOT NULL default '0',
2275 `ip` varchar(40) NOT NULL default '',
2276 `file` varchar(100) NOT NULL default '',
2278 KEY `timestamp` (`timestamp`),
2280 ) ENGINE=MyISAM AUTO_INCREMENT=1 ;
2283 -- Dumping data for table `0_useronline`
2287 -- --------------------------------------------------------
2290 -- Table structure for table `0_users`
2293 DROP TABLE IF EXISTS `0_users`;
2294 CREATE TABLE IF NOT EXISTS `0_users` (
2295 `id` smallint(6) NOT NULL auto_increment,
2296 `user_id` varchar(60) NOT NULL default '',
2297 `password` varchar(100) NOT NULL default '',
2298 `real_name` varchar(100) NOT NULL default '',
2299 `role_id` int(11) NOT NULL default '1',
2300 `phone` varchar(30) NOT NULL default '',
2301 `email` varchar(100) default NULL,
2302 `language` varchar(20) default NULL,
2303 `date_format` tinyint(1) NOT NULL default '0',
2304 `date_sep` tinyint(1) NOT NULL default '0',
2305 `tho_sep` tinyint(1) NOT NULL default '0',
2306 `dec_sep` tinyint(1) NOT NULL default '0',
2307 `theme` varchar(20) NOT NULL default 'default',
2308 `page_size` varchar(20) NOT NULL default 'A4',
2309 `prices_dec` smallint(6) NOT NULL default '2',
2310 `qty_dec` smallint(6) NOT NULL default '2',
2311 `rates_dec` smallint(6) NOT NULL default '4',
2312 `percent_dec` smallint(6) NOT NULL default '1',
2313 `show_gl` tinyint(1) NOT NULL default '1',
2314 `show_codes` tinyint(1) NOT NULL default '0',
2315 `show_hints` tinyint(1) NOT NULL default '0',
2316 `last_visit_date` datetime default NULL,
2317 `query_size` tinyint(1) default '10',
2318 `graphic_links` tinyint(1) default '1',
2319 `pos` smallint(6) default '1',
2320 `print_profile` varchar(30) NOT NULL default '1',
2321 `rep_popup` tinyint(1) default '1',
2322 `sticky_doc_date` tinyint(1) default '0',
2323 `startup_tab` varchar(20) NOT NULL default '',
2324 `inactive` tinyint(1) NOT NULL default '0',
2326 UNIQUE KEY `user_id` (`user_id`)
2327 ) ENGINE=MyISAM AUTO_INCREMENT=3 ;
2330 -- Dumping data for table `0_users`
2333 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', 0);
2334 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', 0);
2336 -- --------------------------------------------------------
2339 -- Table structure for table `0_voided`
2342 DROP TABLE IF EXISTS `0_voided`;
2343 CREATE TABLE IF NOT EXISTS `0_voided` (
2344 `type` int(11) NOT NULL default '0',
2345 `id` int(11) NOT NULL default '0',
2346 `date_` date NOT NULL default '0000-00-00',
2347 `memo_` tinytext NOT NULL,
2348 UNIQUE KEY `id` (`type`,`id`)
2352 -- Dumping data for table `0_voided`
2356 -- --------------------------------------------------------
2359 -- Table structure for table `0_workcentres`
2362 DROP TABLE IF EXISTS `0_workcentres`;
2363 CREATE TABLE IF NOT EXISTS `0_workcentres` (
2364 `id` int(11) NOT NULL auto_increment,
2365 `name` char(40) NOT NULL default '',
2366 `description` char(50) NOT NULL default '',
2367 `inactive` tinyint(1) NOT NULL default '0',
2369 UNIQUE KEY `name` (`name`)
2370 ) ENGINE=MyISAM AUTO_INCREMENT=2 ;
2373 -- Dumping data for table `0_workcentres`
2376 INSERT INTO `0_workcentres` VALUES(1, 'Workshop', 'Workshop in Alabama', 0);
2378 -- --------------------------------------------------------
2381 -- Table structure for table `0_workorders`
2384 DROP TABLE IF EXISTS `0_workorders`;
2385 CREATE TABLE IF NOT EXISTS `0_workorders` (
2386 `id` int(11) NOT NULL auto_increment,
2387 `wo_ref` varchar(60) NOT NULL default '',
2388 `loc_code` varchar(5) NOT NULL default '',
2389 `units_reqd` double NOT NULL default '1',
2390 `stock_id` varchar(20) NOT NULL default '',
2391 `date_` date NOT NULL default '0000-00-00',
2392 `type` tinyint(4) NOT NULL default '0',
2393 `required_by` date NOT NULL default '0000-00-00',
2394 `released_date` date NOT NULL default '0000-00-00',
2395 `units_issued` double NOT NULL default '0',
2396 `closed` tinyint(1) NOT NULL default '0',
2397 `released` tinyint(1) NOT NULL default '0',
2398 `additional_costs` double NOT NULL default '0',
2400 UNIQUE KEY `wo_ref` (`wo_ref`)
2401 ) ENGINE=InnoDB AUTO_INCREMENT=8 ;
2404 -- Dumping data for table `0_workorders`
2407 INSERT INTO `0_workorders` VALUES(1, '1', 'DEF', 10, '3400', '2009-06-21', 0, '2009-06-21', '2009-06-21', 10, 1, 1, 10);
2408 INSERT INTO `0_workorders` VALUES(2, '2', 'DEF', 3, '3400', '2009-06-21', 2, '2009-07-11', '2009-06-21', 2, 0, 1, 0);
2409 INSERT INTO `0_workorders` VALUES(3, '3', 'DEF', 2, '3400', '2009-06-21', 0, '2009-06-21', '2009-06-21', 2, 1, 1, 0);
2410 INSERT INTO `0_workorders` VALUES(4, '4', 'DEF', 4, '3400', '2009-06-21', 0, '2009-06-21', '2009-06-21', 4, 1, 1, 0);
2411 INSERT INTO `0_workorders` VALUES(5, '5', 'DEF', 5, '3400', '2009-06-21', 0, '2009-06-21', '2009-06-21', 5, 1, 1, 10);
2412 INSERT INTO `0_workorders` VALUES(6, '6', 'DEF', -5, '3400', '2009-06-21', 1, '2009-06-21', '2009-06-21', -5, 1, 1, 0);
2413 INSERT INTO `0_workorders` VALUES(7, '7', 'DEF', -2, '3400', '2009-06-21', 1, '2009-06-21', '2009-06-21', -2, 1, 1, 10);
2415 -- --------------------------------------------------------
2418 -- Table structure for table `0_wo_issues`
2421 DROP TABLE IF EXISTS `0_wo_issues`;
2422 CREATE TABLE IF NOT EXISTS `0_wo_issues` (
2423 `issue_no` int(11) NOT NULL auto_increment,
2424 `workorder_id` int(11) NOT NULL default '0',
2425 `reference` varchar(100) default NULL,
2426 `issue_date` date default NULL,
2427 `loc_code` varchar(5) default NULL,
2428 `workcentre_id` int(11) default NULL,
2429 PRIMARY KEY (`issue_no`),
2430 KEY `workorder_id` (`workorder_id`)
2431 ) ENGINE=InnoDB AUTO_INCREMENT=1 ;
2434 -- Dumping data for table `0_wo_issues`
2438 -- --------------------------------------------------------
2441 -- Table structure for table `0_wo_issue_items`
2444 DROP TABLE IF EXISTS `0_wo_issue_items`;
2445 CREATE TABLE IF NOT EXISTS `0_wo_issue_items` (
2446 `id` int(11) NOT NULL auto_increment,
2447 `stock_id` varchar(40) default NULL,
2448 `issue_id` int(11) default NULL,
2449 `qty_issued` double default NULL,
2451 ) ENGINE=InnoDB AUTO_INCREMENT=1 ;
2454 -- Dumping data for table `0_wo_issue_items`
2458 -- --------------------------------------------------------
2461 -- Table structure for table `0_wo_manufacture`
2464 DROP TABLE IF EXISTS `0_wo_manufacture`;
2465 CREATE TABLE IF NOT EXISTS `0_wo_manufacture` (
2466 `id` int(11) NOT NULL auto_increment,
2467 `reference` varchar(100) default NULL,
2468 `workorder_id` int(11) NOT NULL default '0',
2469 `quantity` double NOT NULL default '0',
2470 `date_` date NOT NULL default '0000-00-00',
2472 KEY `workorder_id` (`workorder_id`)
2473 ) ENGINE=InnoDB AUTO_INCREMENT=2 ;
2476 -- Dumping data for table `0_wo_manufacture`
2479 INSERT INTO `0_wo_manufacture` VALUES(1, '1', 2, 2, '2009-06-21');
2481 -- --------------------------------------------------------
2484 -- Table structure for table `0_wo_requirements`
2487 DROP TABLE IF EXISTS `0_wo_requirements`;
2488 CREATE TABLE IF NOT EXISTS `0_wo_requirements` (
2489 `id` int(11) NOT NULL auto_increment,
2490 `workorder_id` int(11) NOT NULL default '0',
2491 `stock_id` char(20) NOT NULL default '',
2492 `workcentre` int(11) NOT NULL default '0',
2493 `units_req` double NOT NULL default '1',
2494 `std_cost` double NOT NULL default '0',
2495 `loc_code` char(5) NOT NULL default '',
2496 `units_issued` double NOT NULL default '0',
2498 KEY `workorder_id` (`workorder_id`)
2499 ) ENGINE=InnoDB AUTO_INCREMENT=22 ;
2502 -- Dumping data for table `0_wo_requirements`
2505 INSERT INTO `0_wo_requirements` VALUES(1, 1, '102', 1, 1, 0, 'DEF', 10);
2506 INSERT INTO `0_wo_requirements` VALUES(2, 1, '103', 1, 1, 0, 'DEF', 10);
2507 INSERT INTO `0_wo_requirements` VALUES(3, 1, '104', 1, 1, 0, 'DEF', 10);
2508 INSERT INTO `0_wo_requirements` VALUES(4, 2, '102', 1, 1, 0, 'DEF', 0);
2509 INSERT INTO `0_wo_requirements` VALUES(5, 2, '103', 1, 1, 0, 'DEF', 0);
2510 INSERT INTO `0_wo_requirements` VALUES(6, 2, '104', 1, 1, 0, 'DEF', 0);
2511 INSERT INTO `0_wo_requirements` VALUES(7, 3, '102', 1, 1, 0, 'DEF', 2);
2512 INSERT INTO `0_wo_requirements` VALUES(8, 3, '103', 1, 1, 0, 'DEF', 2);
2513 INSERT INTO `0_wo_requirements` VALUES(9, 3, '104', 1, 1, 0, 'DEF', 2);
2514 INSERT INTO `0_wo_requirements` VALUES(10, 4, '102', 1, 1, 0, 'DEF', 4);
2515 INSERT INTO `0_wo_requirements` VALUES(11, 4, '103', 1, 1, 0, 'DEF', 4);
2516 INSERT INTO `0_wo_requirements` VALUES(12, 4, '104', 1, 1, 0, 'DEF', 4);
2517 INSERT INTO `0_wo_requirements` VALUES(13, 5, '102', 1, 1, 0, 'DEF', 5);
2518 INSERT INTO `0_wo_requirements` VALUES(14, 5, '103', 1, 1, 0, 'DEF', 5);
2519 INSERT INTO `0_wo_requirements` VALUES(15, 5, '104', 1, 1, 0, 'DEF', 5);
2520 INSERT INTO `0_wo_requirements` VALUES(16, 6, '102', 1, 1, 0, 'DEF', -5);
2521 INSERT INTO `0_wo_requirements` VALUES(17, 6, '103', 1, 1, 0, 'DEF', -5);
2522 INSERT INTO `0_wo_requirements` VALUES(18, 6, '104', 1, 1, 0, 'DEF', -5);
2523 INSERT INTO `0_wo_requirements` VALUES(19, 7, '102', 1, 1, 0, 'DEF', -2);
2524 INSERT INTO `0_wo_requirements` VALUES(20, 7, '103', 1, 1, 0, 'DEF', -2);
2525 INSERT INTO `0_wo_requirements` VALUES(21, 7, '104', 1, 1, 0, 'DEF', -2);