2 -- version 2.11.8.1deb5
3 -- http://www.phpmyadmin.net
6 -- Generation Time: May 11, 2010 at 11:32 PM
7 -- Server version: 5.0.51
8 -- PHP Version: 5.2.6-1+lenny2
14 -- --------------------------------------------------------
17 -- Table structure for table `0_areas`
20 DROP TABLE IF EXISTS `0_areas`;
21 CREATE TABLE IF NOT EXISTS `0_areas` (
22 `area_code` int(11) NOT NULL auto_increment,
23 `description` varchar(60) NOT NULL default '',
24 `inactive` tinyint(1) NOT NULL default '0',
25 PRIMARY KEY (`area_code`),
26 UNIQUE KEY `description` (`description`)
27 ) ENGINE=MyISAM AUTO_INCREMENT=2 ;
30 -- Dumping data for table `0_areas`
33 INSERT INTO `0_areas` VALUES(1, 'Global', 0);
35 -- --------------------------------------------------------
38 -- Table structure for table `0_attachments`
41 DROP TABLE IF EXISTS `0_attachments`;
42 CREATE TABLE IF NOT EXISTS `0_attachments` (
43 `id` int(11) unsigned NOT NULL auto_increment,
44 `description` varchar(60) NOT NULL default '',
45 `type_no` int(11) NOT NULL default '0',
46 `trans_no` int(11) NOT NULL default '0',
47 `unique_name` varchar(60) NOT NULL default '',
48 `tran_date` date NOT NULL default '0000-00-00',
49 `filename` varchar(60) NOT NULL default '',
50 `filesize` int(11) NOT NULL default '0',
51 `filetype` varchar(60) NOT NULL default '',
53 KEY `type_no` (`type_no`,`trans_no`)
54 ) ENGINE=MyISAM AUTO_INCREMENT=1 ;
57 -- Dumping data for table `0_attachments`
61 -- --------------------------------------------------------
64 -- Table structure for table `0_audit_trail`
67 DROP TABLE IF EXISTS `0_audit_trail`;
68 CREATE TABLE IF NOT EXISTS `0_audit_trail` (
69 `id` int(11) NOT NULL auto_increment,
70 `type` smallint(6) unsigned NOT NULL default '0',
71 `trans_no` int(11) unsigned NOT NULL default '0',
72 `user` smallint(6) unsigned NOT NULL default '0',
73 `stamp` timestamp NOT NULL,
74 `description` varchar(60) default NULL,
75 `fiscal_year` int(11) NOT NULL,
76 `gl_date` date NOT NULL default '0000-00-00',
77 `gl_seq` int(11) unsigned default NULL,
79 KEY `Seq` (`fiscal_year`,`gl_date`,`gl_seq`),
80 KEY `Type_and_Number` (`type`,`trans_no`)
81 ) ENGINE=InnoDB AUTO_INCREMENT=1 ;
84 -- Dumping data for table `0_audit_trail`
88 -- --------------------------------------------------------
91 -- Table structure for table `0_bank_accounts`
94 DROP TABLE IF EXISTS `0_bank_accounts`;
95 CREATE TABLE IF NOT EXISTS `0_bank_accounts` (
96 `account_code` varchar(15) NOT NULL default '',
97 `account_type` smallint(6) NOT NULL default '0',
98 `bank_account_name` varchar(60) NOT NULL default '',
99 `bank_account_number` varchar(100) NOT NULL default '',
100 `bank_name` varchar(60) NOT NULL default '',
101 `bank_address` tinytext,
102 `bank_curr_code` char(3) NOT NULL default '',
103 `dflt_curr_act` tinyint(1) NOT NULL default '0',
104 `id` smallint(6) NOT NULL auto_increment,
105 `bank_charge_act` varchar(15) NOT NULL default '',
106 `last_reconciled_date` timestamp NOT NULL default '0000-00-00 00:00:00',
107 `ending_reconcile_balance` double NOT NULL default '0',
108 `inactive` tinyint(1) NOT NULL default '0',
110 KEY `bank_account_name` (`bank_account_name`),
111 KEY `bank_account_number` (`bank_account_number`),
112 KEY `account_code` (`account_code`)
113 ) ENGINE=MyISAM AUTO_INCREMENT=3 ;
116 -- Dumping data for table `0_bank_accounts`
119 INSERT INTO `0_bank_accounts` VALUES('1060', 0, 'Current account', '9999999999', 'Wachovia Bank', '', 'USD', 1, 1, '5690', '0000-00-00 00:00:00', 0, 0);
120 INSERT INTO `0_bank_accounts` VALUES('1065', 3, 'Petty Cash account', 'N/A', 'N/A', '', 'USD', 0, 2, '5690', '0000-00-00 00:00:00', 0, 0);
122 -- --------------------------------------------------------
125 -- Table structure for table `0_bank_trans`
128 DROP TABLE IF EXISTS `0_bank_trans`;
129 CREATE TABLE IF NOT EXISTS `0_bank_trans` (
130 `id` int(11) NOT NULL auto_increment,
131 `type` smallint(6) default NULL,
132 `trans_no` int(11) default NULL,
133 `bank_act` varchar(15) NOT NULL default '',
134 `ref` varchar(40) default NULL,
135 `trans_date` date NOT NULL default '0000-00-00',
136 `amount` double default NULL,
137 `dimension_id` int(11) NOT NULL default '0',
138 `dimension2_id` int(11) NOT NULL default '0',
139 `person_type_id` int(11) NOT NULL default '0',
140 `person_id` tinyblob,
141 `reconciled` date default NULL,
143 KEY `bank_act` (`bank_act`,`ref`),
144 KEY `type` (`type`,`trans_no`),
145 KEY `bank_act_2` (`bank_act`,`reconciled`),
146 KEY `bank_act_3` (`bank_act`,`trans_date`)
147 ) ENGINE=InnoDB AUTO_INCREMENT=12 ;
150 -- Dumping data for table `0_bank_trans`
153 INSERT INTO `0_bank_trans` VALUES(1, 22, 4, '1', '1', '2009-06-21', -3465, 0, 0, 3, '2', NULL);
154 INSERT INTO `0_bank_trans` VALUES(2, 26, 1, '1', '', '2009-06-21', -10, 0, 0, 1, '1', NULL);
155 INSERT INTO `0_bank_trans` VALUES(3, 26, 1, '1', '', '2009-06-21', -20, 0, 0, 1, '0', NULL);
156 INSERT INTO `0_bank_trans` VALUES(4, 0, 18, '1', '1', '2009-02-20', 1000, 0, 0, 0, '', NULL);
157 INSERT INTO `0_bank_trans` VALUES(5, 0, 19, '1', '2', '2009-02-21', 4000, 0, 0, 0, '', NULL);
158 INSERT INTO `0_bank_trans` VALUES(6, 2, 5, '1', '1', '2009-06-21', 100, 0, 0, 4, '3', NULL);
159 INSERT INTO `0_bank_trans` VALUES(7, 1, 8, '1', '1', '2009-06-21', -50, 0, 0, 4, '1', NULL);
160 INSERT INTO `0_bank_trans` VALUES(8, 26, 5, '1', '', '2009-06-21', -10, 0, 0, 1, '1', NULL);
161 INSERT INTO `0_bank_trans` VALUES(9, 26, 5, '1', '', '2009-06-21', -20, 0, 0, 1, '0', NULL);
162 INSERT INTO `0_bank_trans` VALUES(10, 26, 7, '1', '', '2009-06-21', -10, 0, 0, 1, '1', NULL);
163 INSERT INTO `0_bank_trans` VALUES(11, 26, 7, '1', '', '2009-06-21', -20, 0, 0, 1, '0', NULL);
165 -- --------------------------------------------------------
168 -- Table structure for table `0_bom`
171 DROP TABLE IF EXISTS `0_bom`;
172 CREATE TABLE IF NOT EXISTS `0_bom` (
173 `id` int(11) NOT NULL auto_increment,
174 `parent` char(20) NOT NULL default '',
175 `component` char(20) NOT NULL default '',
176 `workcentre_added` int(11) NOT NULL default '0',
177 `loc_code` char(5) NOT NULL default '',
178 `quantity` double NOT NULL default '1',
179 PRIMARY KEY (`parent`,`component`,`workcentre_added`,`loc_code`),
180 KEY `component` (`component`),
182 KEY `loc_code` (`loc_code`),
183 KEY `parent` (`parent`,`loc_code`),
184 KEY `workcentre_added` (`workcentre_added`)
185 ) ENGINE=MyISAM AUTO_INCREMENT=4 ;
188 -- Dumping data for table `0_bom`
191 INSERT INTO `0_bom` VALUES(1, '3400', '102', 1, 'DEF', 1);
192 INSERT INTO `0_bom` VALUES(2, '3400', '103', 1, 'DEF', 1);
193 INSERT INTO `0_bom` VALUES(3, '3400', '104', 1, 'DEF', 1);
195 -- --------------------------------------------------------
198 -- Table structure for table `0_budget_trans`
201 DROP TABLE IF EXISTS `0_budget_trans`;
202 CREATE TABLE IF NOT EXISTS `0_budget_trans` (
203 `counter` int(11) NOT NULL auto_increment,
204 `type` smallint(6) NOT NULL default '0',
205 `type_no` bigint(16) NOT NULL default '1',
206 `tran_date` date NOT NULL default '0000-00-00',
207 `account` varchar(15) NOT NULL default '',
208 `memo_` tinytext NOT NULL,
209 `amount` double NOT NULL default '0',
210 `dimension_id` int(11) default '0',
211 `dimension2_id` int(11) default '0',
212 `person_type_id` int(11) default NULL,
213 `person_id` tinyblob,
214 PRIMARY KEY (`counter`),
215 KEY `Type_and_Number` (`type`,`type_no`),
216 KEY `Account` (`account`,`tran_date`,`dimension_id`,`dimension2_id`)
217 ) ENGINE=InnoDB AUTO_INCREMENT=1 ;
220 -- Dumping data for table `0_budget_trans`
224 -- --------------------------------------------------------
227 -- Table structure for table `0_chart_class`
230 DROP TABLE IF EXISTS `0_chart_class`;
231 CREATE TABLE IF NOT EXISTS `0_chart_class` (
232 `cid` varchar(3) NOT NULL,
233 `class_name` varchar(60) NOT NULL default '',
234 `ctype` tinyint(1) NOT NULL default '0',
235 `inactive` tinyint(1) NOT NULL default '0',
240 -- Dumping data for table `0_chart_class`
243 INSERT INTO `0_chart_class` VALUES('1', 'Assets', 1, 0);
244 INSERT INTO `0_chart_class` VALUES('2', 'Liabilities', 2, 0);
245 INSERT INTO `0_chart_class` VALUES('3', 'Income', 4, 0);
246 INSERT INTO `0_chart_class` VALUES('4', 'Costs', 6, 0);
248 -- --------------------------------------------------------
251 -- Table structure for table `0_chart_master`
254 DROP TABLE IF EXISTS `0_chart_master`;
255 CREATE TABLE IF NOT EXISTS `0_chart_master` (
256 `account_code` varchar(15) NOT NULL default '',
257 `account_code2` varchar(15) NOT NULL default '',
258 `account_name` varchar(60) NOT NULL default '',
259 `account_type` varchar(10) NOT NULL default '0',
260 `inactive` tinyint(1) NOT NULL default '0',
261 PRIMARY KEY (`account_code`),
262 KEY `account_name` (`account_name`),
263 KEY `accounts_by_type` (`account_type`,`account_code`)
267 -- Dumping data for table `0_chart_master`
270 INSERT INTO `0_chart_master` VALUES('1060', '', 'Checking Account', '1', 0);
271 INSERT INTO `0_chart_master` VALUES('1065', '', 'Petty Cash', '1', 0);
272 INSERT INTO `0_chart_master` VALUES('1200', '', 'Accounts Receivables', '1', 0);
273 INSERT INTO `0_chart_master` VALUES('1205', '', 'Allowance for doubtful accounts', '1', 0);
274 INSERT INTO `0_chart_master` VALUES('1510', '', 'Inventory', '2', 0);
275 INSERT INTO `0_chart_master` VALUES('1520', '', 'Stocks of Raw Materials', '2', 0);
276 INSERT INTO `0_chart_master` VALUES('1530', '', 'Stocks of Work In Progress', '2', 0);
277 INSERT INTO `0_chart_master` VALUES('1540', '', 'Stocks of Finsihed Goods', '2', 0);
278 INSERT INTO `0_chart_master` VALUES('1550', '', 'Goods Received Clearing account', '2', 0);
279 INSERT INTO `0_chart_master` VALUES('1820', '', 'Office Furniture & Equipment', '3', 0);
280 INSERT INTO `0_chart_master` VALUES('1825', '', 'Accum. Amort. -Furn. & Equip.', '3', 0);
281 INSERT INTO `0_chart_master` VALUES('1840', '', 'Vehicle', '3', 0);
282 INSERT INTO `0_chart_master` VALUES('1845', '', 'Accum. Amort. -Vehicle', '3', 0);
283 INSERT INTO `0_chart_master` VALUES('2100', '', 'Accounts Payable', '4', 0);
284 INSERT INTO `0_chart_master` VALUES('2110', '', 'Accrued Income Tax - Federal', '4', 0);
285 INSERT INTO `0_chart_master` VALUES('2120', '', 'Accrued Income Tax - State', '4', 0);
286 INSERT INTO `0_chart_master` VALUES('2130', '', 'Accrued Franchise Tax', '4', 0);
287 INSERT INTO `0_chart_master` VALUES('2140', '', 'Accrued Real & Personal Prop Tax', '4', 0);
288 INSERT INTO `0_chart_master` VALUES('2150', '', 'Sales Tax', '4', 0);
289 INSERT INTO `0_chart_master` VALUES('2160', '', 'Accrued Use Tax Payable', '4', 0);
290 INSERT INTO `0_chart_master` VALUES('2210', '', 'Accrued Wages', '4', 0);
291 INSERT INTO `0_chart_master` VALUES('2220', '', 'Accrued Comp Time', '4', 0);
292 INSERT INTO `0_chart_master` VALUES('2230', '', 'Accrued Holiday Pay', '4', 0);
293 INSERT INTO `0_chart_master` VALUES('2240', '', 'Accrued Vacation Pay', '4', 0);
294 INSERT INTO `0_chart_master` VALUES('2310', '', 'Accr. Benefits - 401K', '4', 0);
295 INSERT INTO `0_chart_master` VALUES('2320', '', 'Accr. Benefits - Stock Purchase', '4', 0);
296 INSERT INTO `0_chart_master` VALUES('2330', '', 'Accr. Benefits - Med, Den', '4', 0);
297 INSERT INTO `0_chart_master` VALUES('2340', '', 'Accr. Benefits - Payroll Taxes', '4', 0);
298 INSERT INTO `0_chart_master` VALUES('2350', '', 'Accr. Benefits - Credit Union', '4', 0);
299 INSERT INTO `0_chart_master` VALUES('2360', '', 'Accr. Benefits - Savings Bond', '4', 0);
300 INSERT INTO `0_chart_master` VALUES('2370', '', 'Accr. Benefits - Garnish', '4', 0);
301 INSERT INTO `0_chart_master` VALUES('2380', '', 'Accr. Benefits - Charity Cont.', '4', 0);
302 INSERT INTO `0_chart_master` VALUES('2620', '', 'Bank Loans', '5', 0);
303 INSERT INTO `0_chart_master` VALUES('2680', '', 'Loans from Shareholders', '5', 0);
304 INSERT INTO `0_chart_master` VALUES('3350', '', 'Common Shares', '6', 0);
305 INSERT INTO `0_chart_master` VALUES('3590', '', 'Retained Earnings - prior years', '7', 0);
306 INSERT INTO `0_chart_master` VALUES('4010', '', 'Sales', '8', 0);
307 INSERT INTO `0_chart_master` VALUES('4430', '', 'Shipping & Handling', '9', 0);
308 INSERT INTO `0_chart_master` VALUES('4440', '', 'Interest', '9', 0);
309 INSERT INTO `0_chart_master` VALUES('4450', '', 'Foreign Exchange Gain', '9', 0);
310 INSERT INTO `0_chart_master` VALUES('4500', '', 'Prompt Payment Discounts', '9', 0);
311 INSERT INTO `0_chart_master` VALUES('4510', '', 'Discounts Given', '9', 0);
312 INSERT INTO `0_chart_master` VALUES('5010', '', 'Cost of Goods Sold - Retail', '10', 0);
313 INSERT INTO `0_chart_master` VALUES('5020', '', 'Material Usage Varaiance', '10', 0);
314 INSERT INTO `0_chart_master` VALUES('5030', '', 'Consumable Materials', '10', 0);
315 INSERT INTO `0_chart_master` VALUES('5040', '', 'Purchase price Variance', '10', 0);
316 INSERT INTO `0_chart_master` VALUES('5050', '', 'Purchases of materials', '10', 0);
317 INSERT INTO `0_chart_master` VALUES('5060', '', 'Discounts Received', '10', 0);
318 INSERT INTO `0_chart_master` VALUES('5100', '', 'Freight', '10', 0);
319 INSERT INTO `0_chart_master` VALUES('5410', '', 'Wages & Salaries', '11', 0);
320 INSERT INTO `0_chart_master` VALUES('5420', '', 'Wages - Overtime', '11', 0);
321 INSERT INTO `0_chart_master` VALUES('5430', '', 'Benefits - Comp Time', '11', 0);
322 INSERT INTO `0_chart_master` VALUES('5440', '', 'Benefits - Payroll Taxes', '11', 0);
323 INSERT INTO `0_chart_master` VALUES('5450', '', 'Benefits - Workers Comp', '11', 0);
324 INSERT INTO `0_chart_master` VALUES('5460', '', 'Benefits - Pension', '11', 0);
325 INSERT INTO `0_chart_master` VALUES('5470', '', 'Benefits - General Benefits', '11', 0);
326 INSERT INTO `0_chart_master` VALUES('5510', '', 'Inc Tax Exp - Federal', '11', 0);
327 INSERT INTO `0_chart_master` VALUES('5520', '', 'Inc Tax Exp - State', '11', 0);
328 INSERT INTO `0_chart_master` VALUES('5530', '', 'Taxes - Real Estate', '11', 0);
329 INSERT INTO `0_chart_master` VALUES('5540', '', 'Taxes - Personal Property', '11', 0);
330 INSERT INTO `0_chart_master` VALUES('5550', '', 'Taxes - Franchise', '11', 0);
331 INSERT INTO `0_chart_master` VALUES('5560', '', 'Taxes - Foreign Withholding', '11', 0);
332 INSERT INTO `0_chart_master` VALUES('5610', '', 'Accounting & Legal', '12', 0);
333 INSERT INTO `0_chart_master` VALUES('5615', '', 'Advertising & Promotions', '12', 0);
334 INSERT INTO `0_chart_master` VALUES('5620', '', 'Bad Debts', '12', 0);
335 INSERT INTO `0_chart_master` VALUES('5660', '', 'Amortization Expense', '12', 0);
336 INSERT INTO `0_chart_master` VALUES('5685', '', 'Insurance', '12', 0);
337 INSERT INTO `0_chart_master` VALUES('5690', '', 'Interest & Bank Charges', '12', 0);
338 INSERT INTO `0_chart_master` VALUES('5700', '', 'Office Supplies', '12', 0);
339 INSERT INTO `0_chart_master` VALUES('5760', '', 'Rent', '12', 0);
340 INSERT INTO `0_chart_master` VALUES('5765', '', 'Repair & Maintenance', '12', 0);
341 INSERT INTO `0_chart_master` VALUES('5780', '', 'Telephone', '12', 0);
342 INSERT INTO `0_chart_master` VALUES('5785', '', 'Travel & Entertainment', '12', 0);
343 INSERT INTO `0_chart_master` VALUES('5790', '', 'Utilities', '12', 0);
344 INSERT INTO `0_chart_master` VALUES('5795', '', 'Registrations', '12', 0);
345 INSERT INTO `0_chart_master` VALUES('5800', '', 'Licenses', '12', 0);
346 INSERT INTO `0_chart_master` VALUES('5810', '', 'Foreign Exchange Loss', '12', 0);
347 INSERT INTO `0_chart_master` VALUES('9990', '', 'Year Profit/Loss', '12', 0);
349 -- --------------------------------------------------------
352 -- Table structure for table `0_chart_types`
355 DROP TABLE IF EXISTS `0_chart_types`;
356 CREATE TABLE IF NOT EXISTS `0_chart_types` (
357 `id` varchar(10) NOT NULL,
358 `name` varchar(60) NOT NULL default '',
359 `class_id` varchar(3) NOT NULL default '',
360 `parent` varchar(10) NOT NULL default '-1',
361 `inactive` tinyint(1) NOT NULL default '0',
364 KEY `class_id` (`class_id`)
368 -- Dumping data for table `0_chart_types`
371 INSERT INTO `0_chart_types` VALUES('1', 'Current Assets', '1', '', 0);
372 INSERT INTO `0_chart_types` VALUES('2', 'Inventory Assets', '1', '', 0);
373 INSERT INTO `0_chart_types` VALUES('3', 'Capital Assets', '1', '', 0);
374 INSERT INTO `0_chart_types` VALUES('4', 'Current Liabilities', '2', '', 0);
375 INSERT INTO `0_chart_types` VALUES('5', 'Long Term Liabilities', '2', '', 0);
376 INSERT INTO `0_chart_types` VALUES('6', 'Share Capital', '2', '', 0);
377 INSERT INTO `0_chart_types` VALUES('7', 'Retained Earnings', '2', '', 0);
378 INSERT INTO `0_chart_types` VALUES('8', 'Sales Revenue', '3', '', 0);
379 INSERT INTO `0_chart_types` VALUES('9', 'Other Revenue', '3', '', 0);
380 INSERT INTO `0_chart_types` VALUES('10', 'Cost of Goods Sold', '4', '', 0);
381 INSERT INTO `0_chart_types` VALUES('11', 'Payroll Expenses', '4', '', 0);
382 INSERT INTO `0_chart_types` VALUES('12', 'General & Administrative expenses', '4', '', 0);
384 -- --------------------------------------------------------
387 -- Table structure for table `0_comments`
390 DROP TABLE IF EXISTS `0_comments`;
391 CREATE TABLE IF NOT EXISTS `0_comments` (
392 `type` int(11) NOT NULL default '0',
393 `id` int(11) NOT NULL default '0',
394 `date_` date default '0000-00-00',
396 KEY `type_and_id` (`type`,`id`)
400 -- Dumping data for table `0_comments`
404 -- --------------------------------------------------------
407 -- Table structure for table `0_credit_status`
410 DROP TABLE IF EXISTS `0_credit_status`;
411 CREATE TABLE IF NOT EXISTS `0_credit_status` (
412 `id` int(11) NOT NULL auto_increment,
413 `reason_description` char(100) NOT NULL default '',
414 `dissallow_invoices` tinyint(1) NOT NULL default '0',
415 `inactive` tinyint(1) NOT NULL default '0',
417 UNIQUE KEY `reason_description` (`reason_description`)
418 ) ENGINE=MyISAM AUTO_INCREMENT=5 ;
421 -- Dumping data for table `0_credit_status`
424 INSERT INTO `0_credit_status` VALUES(1, 'Good History', 0, 0);
425 INSERT INTO `0_credit_status` VALUES(3, 'No more work until payment received', 1, 0);
426 INSERT INTO `0_credit_status` VALUES(4, 'In liquidation', 1, 0);
428 -- --------------------------------------------------------
431 -- Table structure for table `0_crm_categories`
434 DROP TABLE IF EXISTS `0_crm_categories`;
435 CREATE TABLE IF NOT EXISTS `0_crm_categories` (
436 `id` int(11) NOT NULL auto_increment COMMENT 'pure technical key',
437 `type` varchar(20) NOT NULL COMMENT 'contact type e.g. customer',
438 `action` varchar(20) NOT NULL COMMENT 'detailed usage e.g. department',
439 `name` varchar(30) NOT NULL COMMENT 'for category selector',
440 `description` tinytext NOT NULL COMMENT 'usage description',
441 `system` tinyint(1) NOT NULL default '0' COMMENT 'nonzero for core system usage',
442 `inactive` tinyint(1) NOT NULL default '0',
444 UNIQUE KEY `type` (`type`,`action`),
445 UNIQUE KEY `type_2` (`type`,`name`)
446 ) ENGINE=InnoDB AUTO_INCREMENT=13 ;
449 -- Dumping data for table `0_crm_categories`
452 INSERT INTO `0_crm_categories` VALUES(1, 'cust_branch', 'general', 'General', 'General contact data for customer branch (overrides company setting)', 1, 0);
453 INSERT INTO `0_crm_categories` VALUES(2, 'cust_branch', 'invoice', 'Invoices', 'Invoice posting (overrides company setting)', 1, 0);
454 INSERT INTO `0_crm_categories` VALUES(3, 'cust_branch', 'order', 'Orders', 'Order confirmation (overrides company setting)', 1, 0);
455 INSERT INTO `0_crm_categories` VALUES(4, 'cust_branch', 'delivery', 'Deliveries', 'Delivery coordination (overrides company setting)', 1, 0);
456 INSERT INTO `0_crm_categories` VALUES(5, 'customer', 'general', 'General', 'General contact data for customer', 1, 0);
457 INSERT INTO `0_crm_categories` VALUES(6, 'customer', 'order', 'Orders', 'Order confirmation', 1, 0);
458 INSERT INTO `0_crm_categories` VALUES(7, 'customer', 'delivery', 'Deliveries', 'Delivery coordination', 1, 0);
459 INSERT INTO `0_crm_categories` VALUES(8, 'customer', 'invoice', 'Invoices', 'Invoice posting', 1, 0);
460 INSERT INTO `0_crm_categories` VALUES(9, 'supplier', 'general', 'General', 'General contact data for supplier', 1, 0);
461 INSERT INTO `0_crm_categories` VALUES(10, 'supplier', 'order', 'Orders', 'Order confirmation', 1, 0);
462 INSERT INTO `0_crm_categories` VALUES(11, 'supplier', 'delivery', 'Deliveries', 'Delivery coordination', 1, 0);
463 INSERT INTO `0_crm_categories` VALUES(12, 'supplier', 'invoice', 'Invoices', 'Invoice posting', 1, 0);
465 -- --------------------------------------------------------
468 -- Table structure for table `0_crm_contacts`
471 DROP TABLE IF EXISTS `0_crm_contacts`;
472 CREATE TABLE IF NOT EXISTS `0_crm_contacts` (
473 `id` int(11) NOT NULL auto_increment,
474 `person_id` int(11) NOT NULL default '0' COMMENT 'foreign key to crm_contacts',
475 `type` varchar(20) NOT NULL COMMENT 'foreign key to crm_categories',
476 `action` varchar(20) NOT NULL COMMENT 'foreign key to crm_categories',
477 `entity_id` varchar(11) default NULL COMMENT 'entity id in related class table',
479 KEY `type` (`type`,`action`)
480 ) ENGINE=InnoDB AUTO_INCREMENT=10 ;
483 -- Dumping data for table `0_crm_contacts`
486 INSERT INTO `0_crm_contacts` VALUES(1, 1, 'customer', 'general', '1');
487 INSERT INTO `0_crm_contacts` VALUES(2, 2, 'customer', 'general', '2');
488 INSERT INTO `0_crm_contacts` VALUES(3, 3, 'customer', 'general', '3');
489 INSERT INTO `0_crm_contacts` VALUES(4, 4, 'cust_branch', 'general', '1');
490 INSERT INTO `0_crm_contacts` VALUES(5, 5, 'cust_branch', 'general', '2');
491 INSERT INTO `0_crm_contacts` VALUES(6, 6, 'cust_branch', 'general', '3');
492 INSERT INTO `0_crm_contacts` VALUES(7, 7, 'supplier', 'general', '1');
493 INSERT INTO `0_crm_contacts` VALUES(8, 8, 'supplier', 'general', '2');
494 INSERT INTO `0_crm_contacts` VALUES(9, 9, 'supplier', 'general', '3');
496 -- --------------------------------------------------------
499 -- Table structure for table `0_crm_persons`
502 DROP TABLE IF EXISTS `0_crm_persons`;
503 CREATE TABLE IF NOT EXISTS `0_crm_persons` (
504 `id` int(11) NOT NULL auto_increment,
505 `ref` varchar(30) NOT NULL,
506 `name` varchar(60) NOT NULL,
507 `name2` varchar(60) default NULL,
509 `phone` varchar(30) default NULL,
510 `phone2` varchar(30) default NULL,
511 `fax` varchar(30) default NULL,
512 `email` varchar(100) default NULL,
513 `lang` char(5) default NULL,
514 `notes` tinytext NOT NULL,
515 `inactive` tinyint(1) NOT NULL default '0',
518 ) ENGINE=InnoDB AUTO_INCREMENT=10 ;
521 -- Dumping data for table `0_crm_persons`
524 INSERT INTO `0_crm_persons` VALUES(1, 'Beefeater', '', NULL, NULL, NULL, NULL, NULL, '', '', '', 0);
525 INSERT INTO `0_crm_persons` VALUES(2, 'Ghostbusters', '', NULL, NULL, NULL, NULL, NULL, '', NULL, '', 0);
526 INSERT INTO `0_crm_persons` VALUES(3, 'Brezan', '', NULL, NULL, NULL, NULL, NULL, '', '', '', 0);
527 INSERT INTO `0_crm_persons` VALUES(4, 'Beefeater', 'Main Branch', NULL, '', '', '', '', '', NULL, '', 0);
528 INSERT INTO `0_crm_persons` VALUES(5, 'Ghostbusters', 'Main Branch', NULL, 'Address 1\nAddress 2\nAddress 3', '', '', '', '', NULL, '', 0);
529 INSERT INTO `0_crm_persons` VALUES(6, 'Brezan', 'Main Branch', NULL, 'Address 1\nAddress 2\nAddress 3', '', '', '', '', NULL, '', 0);
530 INSERT INTO `0_crm_persons` VALUES(7, 'Junk Beer', 'Contact', NULL, 'Address 1\nAddress 2\nAddress 3', '+45 55667788', '', '', '', '', '', 0);
531 INSERT INTO `0_crm_persons` VALUES(8, 'Lucky Luke', 'Luke', NULL, 'Address 1\nAddress 2\nAddress 3', '(111) 222.333.444', '', '', '', NULL, '', 0);
532 INSERT INTO `0_crm_persons` VALUES(9, 'Money Makers', 'Makers', NULL, 'Address 1\nAddress 2\nAddress 3', '+44 444 555 666', '', '', '', '', '', 0);
534 -- --------------------------------------------------------
537 -- Table structure for table `0_currencies`
540 DROP TABLE IF EXISTS `0_currencies`;
541 CREATE TABLE IF NOT EXISTS `0_currencies` (
542 `currency` varchar(60) NOT NULL default '',
543 `curr_abrev` char(3) NOT NULL default '',
544 `curr_symbol` varchar(10) NOT NULL default '',
545 `country` varchar(100) NOT NULL default '',
546 `hundreds_name` varchar(15) NOT NULL default '',
547 `auto_update` tinyint(1) NOT NULL default '1',
548 `inactive` tinyint(1) NOT NULL default '0',
549 PRIMARY KEY (`curr_abrev`)
553 -- Dumping data for table `0_currencies`
556 INSERT INTO `0_currencies` VALUES('US Dollars', 'USD', '$', 'United States', 'Cents', 1, 0);
557 INSERT INTO `0_currencies` VALUES('CA Dollars', 'CAD', '$', 'Canada', 'Cents', 1, 0);
558 INSERT INTO `0_currencies` VALUES('Euro', 'EUR', '?', 'Europe', 'Cents', 1, 0);
559 INSERT INTO `0_currencies` VALUES('Pounds', 'GBP', '?', 'England', 'Pence', 1, 0);
560 INSERT INTO `0_currencies` VALUES('DK Kroner', 'DKK', '?', 'Denmark', 'Ore', 1, 0);
562 -- --------------------------------------------------------
565 -- Table structure for table `0_cust_allocations`
568 DROP TABLE IF EXISTS `0_cust_allocations`;
569 CREATE TABLE IF NOT EXISTS `0_cust_allocations` (
570 `id` int(11) NOT NULL auto_increment,
571 `amt` double unsigned default NULL,
572 `date_alloc` date NOT NULL default '0000-00-00',
573 `trans_no_from` int(11) default NULL,
574 `trans_type_from` int(11) default NULL,
575 `trans_no_to` int(11) default NULL,
576 `trans_type_to` int(11) default NULL,
578 UNIQUE KEY (`trans_type_from`,`trans_no_from`,`trans_type_to`,`trans_no_to`),
579 KEY `From` (`trans_type_from`,`trans_no_from`),
580 KEY `To` (`trans_type_to`,`trans_no_to`)
581 ) ENGINE=InnoDB AUTO_INCREMENT=2 ;
584 -- Dumping data for table `0_cust_allocations`
587 INSERT INTO `0_cust_allocations` VALUES(1, 37.68, '2009-06-21', 3, 11, 18, 10);
589 -- --------------------------------------------------------
592 -- Table structure for table `0_cust_branch`
595 DROP TABLE IF EXISTS `0_cust_branch`;
596 CREATE TABLE IF NOT EXISTS `0_cust_branch` (
597 `branch_code` int(11) NOT NULL auto_increment,
598 `debtor_no` int(11) NOT NULL default '0',
599 `br_name` varchar(60) NOT NULL default '',
600 `branch_ref` varchar(30) NOT NULL default '',
601 `br_address` tinytext NOT NULL,
602 `area` int(11) default NULL,
603 `salesman` int(11) NOT NULL default '0',
604 `contact_name` varchar(60) NOT NULL default '',
605 `default_location` varchar(5) NOT NULL default '',
606 `tax_group_id` int(11) default NULL,
607 `sales_account` varchar(15) NOT NULL default '',
608 `sales_discount_account` varchar(15) NOT NULL default '',
609 `receivables_account` varchar(15) NOT NULL default '',
610 `payment_discount_account` varchar(15) NOT NULL default '',
611 `default_ship_via` int(11) NOT NULL default '1',
612 `disable_trans` tinyint(4) NOT NULL default '0',
613 `br_post_address` tinytext NOT NULL,
614 `group_no` int(11) NOT NULL default '0',
615 `notes` tinytext NOT NULL,
616 `bank_account` varchar(60) DEFAULT NULL,
617 `inactive` tinyint(1) NOT NULL default '0',
618 PRIMARY KEY (`branch_code`,`debtor_no`),
619 KEY `branch_code` (`branch_code`),
620 KEY `branch_ref` (`branch_ref`),
621 KEY `group_no` (`group_no`)
622 ) ENGINE=MyISAM AUTO_INCREMENT=4 ;
625 -- Dumping data for table `0_cust_branch`
628 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);
629 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);
630 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);
632 -- --------------------------------------------------------
635 -- Table structure for table `0_debtors_master`
638 DROP TABLE IF EXISTS `0_debtors_master`;
639 CREATE TABLE IF NOT EXISTS `0_debtors_master` (
640 `debtor_no` int(11) NOT NULL auto_increment,
641 `name` varchar(100) NOT NULL default '',
642 `debtor_ref` varchar(30) NOT NULL,
644 `tax_id` varchar(55) NOT NULL default '',
645 `curr_code` char(3) NOT NULL default '',
646 `sales_type` int(11) NOT NULL default '1',
647 `dimension_id` int(11) NOT NULL default '0',
648 `dimension2_id` int(11) NOT NULL default '0',
649 `credit_status` int(11) NOT NULL default '0',
650 `payment_terms` int(11) default NULL,
651 `discount` double NOT NULL default '0',
652 `pymt_discount` double NOT NULL default '0',
653 `credit_limit` float NOT NULL default '1000',
654 `notes` tinytext NOT NULL,
655 `inactive` tinyint(1) NOT NULL default '0',
656 PRIMARY KEY (`debtor_no`),
658 UNIQUE KEY `debtor_ref` (`debtor_ref`)
659 ) ENGINE=MyISAM AUTO_INCREMENT=4 ;
662 -- Dumping data for table `0_debtors_master`
665 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);
666 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);
667 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);
669 -- --------------------------------------------------------
672 -- Table structure for table `0_debtor_trans`
675 DROP TABLE IF EXISTS `0_debtor_trans`;
676 CREATE TABLE IF NOT EXISTS `0_debtor_trans` (
677 `trans_no` int(11) unsigned NOT NULL default '0',
678 `type` smallint(6) unsigned NOT NULL default '0',
679 `version` tinyint(1) unsigned NOT NULL default '0',
680 `debtor_no` int(11) unsigned default NULL,
681 `branch_code` int(11) NOT NULL default '-1',
682 `tran_date` date NOT NULL default '0000-00-00',
683 `due_date` date NOT NULL default '0000-00-00',
684 `reference` varchar(60) NOT NULL default '',
685 `tpe` int(11) NOT NULL default '0',
686 `order_` int(11) NOT NULL default '0',
687 `ov_amount` double NOT NULL default '0',
688 `ov_gst` double NOT NULL default '0',
689 `ov_freight` double NOT NULL default '0',
690 `ov_freight_tax` double NOT NULL default '0',
691 `ov_discount` double NOT NULL default '0',
692 `alloc` double NOT NULL default '0',
693 `prep_amount` double NOT NULL DEFAULT '0',
694 `rate` double NOT NULL default '1',
695 `ship_via` int(11) default NULL,
696 `dimension_id` int(11) NOT NULL default '0',
697 `dimension2_id` int(11) NOT NULL default '0',
698 `payment_terms` int(11) default NULL,
699 `tax_included` tinyint(1) unsigned NOT NULL default '0',
700 PRIMARY KEY (`type`,`trans_no`),
701 KEY `debtor_no` (`debtor_no`,`branch_code`),
702 KEY `tran_date` (`tran_date`)
706 -- Dumping data for table `0_debtor_trans`
709 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, 0, 1, 1, 0, 0, 4, 0);
710 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, 0, 1.3932, 1, 2, 0, 3, 0);
711 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, 0, 1, 1, 0, 0, 4, 0);
712 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, 0, 1.3932, 1, 2, 0, 3, 0);
713 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, 0, 1.6445729799917, 1, 0, 0, 3, 0);
714 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, 0, 1, 1, 0, 0, 4, 0);
715 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, 0, 1.3932, 1, 2, 0, 3, 0);
716 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, 0, 1, 1, 0, 0, 4, 0);
718 -- --------------------------------------------------------
721 -- Table structure for table `0_debtor_trans_details`
724 DROP TABLE IF EXISTS `0_debtor_trans_details`;
725 CREATE TABLE IF NOT EXISTS `0_debtor_trans_details` (
726 `id` int(11) NOT NULL auto_increment,
727 `debtor_trans_no` int(11) default NULL,
728 `debtor_trans_type` int(11) default NULL,
729 `stock_id` varchar(20) NOT NULL default '',
730 `description` tinytext,
731 `unit_price` double NOT NULL default '0',
732 `unit_tax` double NOT NULL default '0',
733 `quantity` double NOT NULL default '0',
734 `discount_percent` double NOT NULL default '0',
735 `standard_cost` double NOT NULL default '0',
736 `qty_done` double NOT NULL default '0',
737 `src_id` int(11) NOT NULL,
739 KEY `Transaction` (`debtor_trans_type`,`debtor_trans_no`),
741 ) ENGINE=InnoDB AUTO_INCREMENT=9 ;
744 -- Dumping data for table `0_debtor_trans_details`
747 INSERT INTO `0_debtor_trans_details` VALUES(1, 2, 13, '102', '17inch VGA Monitor', 30.4, 0, 2, 0, 10, 0, 1);
748 INSERT INTO `0_debtor_trans_details` VALUES(2, 3, 13, '102', '17inch VGA Monitor', 50, 2.5, 1, 0, 10, 1, 2);
749 INSERT INTO `0_debtor_trans_details` VALUES(3, 17, 10, '102', '17inch VGA Monitor', 50, 2.5, 1, 0, 10, 2, 2);
750 INSERT INTO `0_debtor_trans_details` VALUES(4, 4, 13, '102', '17inch VGA Monitor', 35.89, 1.79, 1, 0, 10, 1,3);
751 INSERT INTO `0_debtor_trans_details` VALUES(5, 18, 10, '102', '17inch VGA Monitor', 35.89, 1.79, 1, 0, 10, 1,4);
752 INSERT INTO `0_debtor_trans_details` VALUES(6, 5, 13, '102', '17inch VGA Monitor', 50, 2.38, 1, 0, 10, 1,5);
753 INSERT INTO `0_debtor_trans_details` VALUES(7, 19, 10, '102', '17inch VGA Monitor', 50, 2.38, 1, 0, 10, 0,6);
754 INSERT INTO `0_debtor_trans_details` VALUES(8, 3, 11, '102', '17inch VGA Monitor', 35.89, 1.79, 1, 0, 10, 0,5);
756 -- --------------------------------------------------------
759 -- Table structure for table `0_dimensions`
762 DROP TABLE IF EXISTS `0_dimensions`;
763 CREATE TABLE IF NOT EXISTS `0_dimensions` (
764 `id` int(11) NOT NULL auto_increment,
765 `reference` varchar(60) NOT NULL default '',
766 `name` varchar(60) NOT NULL default '',
767 `type_` tinyint(1) NOT NULL default '1',
768 `closed` tinyint(1) NOT NULL default '0',
769 `date_` date NOT NULL default '0000-00-00',
770 `due_date` date NOT NULL default '0000-00-00',
772 UNIQUE KEY `reference` (`reference`),
773 KEY `date_` (`date_`),
774 KEY `due_date` (`due_date`),
775 KEY `type_` (`type_`)
776 ) ENGINE=InnoDB AUTO_INCREMENT=3 ;
779 -- Dumping data for table `0_dimensions`
782 INSERT INTO `0_dimensions` VALUES(1, '1', 'Support', 1, 0, '2009-06-21', '2015-07-11');
783 INSERT INTO `0_dimensions` VALUES(2, '2', 'Development', 1, 0, '2009-06-21', '2015-07-11');
785 -- --------------------------------------------------------
788 -- Table structure for table `0_exchange_rates`
791 DROP TABLE IF EXISTS `0_exchange_rates`;
792 CREATE TABLE IF NOT EXISTS `0_exchange_rates` (
793 `id` int(11) NOT NULL auto_increment,
794 `curr_code` char(3) NOT NULL default '',
795 `rate_buy` double NOT NULL default '0',
796 `rate_sell` double NOT NULL default '0',
797 `date_` date NOT NULL default '0000-00-00',
799 UNIQUE KEY `curr_code` (`curr_code`,`date_`)
800 ) ENGINE=MyISAM AUTO_INCREMENT=4 ;
803 -- Dumping data for table `0_exchange_rates`
806 INSERT INTO `0_exchange_rates` VALUES(1, 'DKK', 0.18717252868313, 0.18717252868313, '2009-06-21');
807 INSERT INTO `0_exchange_rates` VALUES(2, 'GBP', 1.6445729799917, 1.6445729799917, '2009-06-21');
808 INSERT INTO `0_exchange_rates` VALUES(3, 'EUR', 1.3932, 1.3932, '2009-06-21');
810 -- --------------------------------------------------------
813 -- Table structure for table `0_fiscal_year`
816 DROP TABLE IF EXISTS `0_fiscal_year`;
817 CREATE TABLE IF NOT EXISTS `0_fiscal_year` (
818 `id` int(11) NOT NULL auto_increment,
819 `begin` date default '0000-00-00',
820 `end` date default '0000-00-00',
821 `closed` tinyint(1) NOT NULL default '0',
823 UNIQUE KEY `begin` (`begin`),
824 UNIQUE KEY `end` (`end`)
825 ) ENGINE=InnoDB AUTO_INCREMENT=4 ;
828 -- Dumping data for table `0_fiscal_year`
831 INSERT INTO `0_fiscal_year` VALUES(1, '2008-01-01', '2008-12-31', 1);
832 INSERT INTO `0_fiscal_year` VALUES(2, '2009-01-01', '2009-12-31', 1);
833 INSERT INTO `0_fiscal_year` VALUES(3, '2010-01-01', '2010-12-31', 0);
834 INSERT INTO `0_fiscal_year` VALUES(4, '2011-01-01', '2011-12-31', 0);
837 -- Table structure for table `0_gl_trans`
840 DROP TABLE IF EXISTS `0_gl_trans`;
841 CREATE TABLE IF NOT EXISTS `0_gl_trans` (
842 `counter` int(11) NOT NULL auto_increment,
843 `type` smallint(6) NOT NULL default '0',
844 `type_no` bigint(16) NOT NULL default '1',
845 `tran_date` date NOT NULL default '0000-00-00',
846 `account` varchar(15) NOT NULL default '',
847 `memo_` tinytext NOT NULL,
848 `amount` double NOT NULL default '0',
849 `dimension_id` int(11) NOT NULL default '0',
850 `dimension2_id` int(11) NOT NULL default '0',
851 `person_type_id` int(11) default NULL,
852 `person_id` tinyblob,
853 PRIMARY KEY (`counter`),
854 KEY `Type_and_Number` (`type`,`type_no`),
855 KEY `dimension_id` (`dimension_id`),
856 KEY `dimension2_id` (`dimension2_id`),
857 KEY `tran_date` (`tran_date`),
858 KEY `account_and_tran_date` (`account`,`tran_date`)
859 ) ENGINE=InnoDB AUTO_INCREMENT=84 ;
862 -- Dumping data for table `0_gl_trans`
865 INSERT INTO `0_gl_trans` VALUES(1, 20, 7, '2009-06-21', '2100', '', -3465, 0, 0, 3, '2');
866 INSERT INTO `0_gl_trans` VALUES(2, 20, 7, '2009-06-21', '1510', '', 1000, 0, 0, 3, '2');
867 INSERT INTO `0_gl_trans` VALUES(3, 20, 7, '2009-06-21', '1510', '', 1100, 0, 0, 3, '2');
868 INSERT INTO `0_gl_trans` VALUES(4, 20, 7, '2009-06-21', '1510', '', 1200, 0, 0, 3, '2');
869 INSERT INTO `0_gl_trans` VALUES(5, 20, 7, '2009-06-21', '2150', '', 165, 0, 0, 3, '2');
870 INSERT INTO `0_gl_trans` VALUES(6, 22, 4, '2009-06-21', '2100', '', 3465, 0, 0, 3, '2');
871 INSERT INTO `0_gl_trans` VALUES(7, 22, 4, '2009-06-21', '1060', '', -3465, 0, 0, 3, '2');
872 INSERT INTO `0_gl_trans` VALUES(8, 26, 1, '2009-06-21', '1510', '', -100, 0, 0, NULL, '');
873 INSERT INTO `0_gl_trans` VALUES(9, 26, 1, '2009-06-21', '1510', '', -110, 0, 0, NULL, '');
874 INSERT INTO `0_gl_trans` VALUES(10, 26, 1, '2009-06-21', '1510', '', -120, 0, 0, NULL, '');
875 INSERT INTO `0_gl_trans` VALUES(11, 26, 1, '2009-06-21', '1060', 'Overhead Cost', -10, 0, 0, 1, '1');
876 INSERT INTO `0_gl_trans` VALUES(12, 26, 1, '2009-06-21', '1530', 'Overhead Cost', 10, 0, 0, 1, '1');
877 INSERT INTO `0_gl_trans` VALUES(13, 26, 1, '2009-06-21', '1060', 'Labour Cost', -20, 0, 0, 1, '0');
878 INSERT INTO `0_gl_trans` VALUES(14, 26, 1, '2009-06-21', '1530', 'Labour Cost', 20, 0, 0, 1, '0');
879 INSERT INTO `0_gl_trans` VALUES(15, 26, 1, '2009-06-21', '1510', '', 330, 0, 0, NULL, '');
880 INSERT INTO `0_gl_trans` VALUES(16, 13, 2, '2009-06-21', '5010', '', 20, 0, 0, 2, '1');
881 INSERT INTO `0_gl_trans` VALUES(17, 13, 2, '2009-06-21', '1510', '', -20, 0, 0, 2, '1');
882 INSERT INTO `0_gl_trans` VALUES(18, 13, 3, '2009-06-21', '5010', '', 10, 0, 0, 2, '2');
883 INSERT INTO `0_gl_trans` VALUES(19, 13, 3, '2009-06-21', '1510', '', -10, 0, 0, 2, '2');
884 INSERT INTO `0_gl_trans` VALUES(20, 10, 17, '2009-06-21', '4010', '', -50, 0, 0, 2, '2');
885 INSERT INTO `0_gl_trans` VALUES(21, 10, 17, '2009-06-21', '1200', '', 52.5, 0, 0, 2, '2');
886 INSERT INTO `0_gl_trans` VALUES(22, 10, 17, '2009-06-21', '2150', '', -2.5, 0, 0, 2, '2');
887 INSERT INTO `0_gl_trans` VALUES(23, 13, 4, '2009-06-21', '5010', '', 10, 2, 0, 2, '3');
888 INSERT INTO `0_gl_trans` VALUES(24, 13, 4, '2009-06-21', '1510', '', -10, 0, 0, 2, '3');
889 INSERT INTO `0_gl_trans` VALUES(25, 10, 18, '2009-06-21', '4010', '', -50, 2, 0, 2, '3');
890 INSERT INTO `0_gl_trans` VALUES(26, 10, 18, '2009-06-21', '1200', '', 52.5, 0, 0, 2, '3');
891 INSERT INTO `0_gl_trans` VALUES(27, 10, 18, '2009-06-21', '2150', '', -2.5, 0, 0, 2, '3');
892 INSERT INTO `0_gl_trans` VALUES(28, 0, 18, '2009-02-20', '1060', '', 1000, 0, 0, NULL, '');
893 INSERT INTO `0_gl_trans` VALUES(29, 0, 18, '2009-02-20', '3350', '', -1000, 0, 0, NULL, '');
894 INSERT INTO `0_gl_trans` VALUES(30, 0, 19, '2009-02-21', '1060', '', 4000, 0, 0, NULL, '');
895 INSERT INTO `0_gl_trans` VALUES(31, 0, 19, '2009-02-21', '3350', '', -4000, 0, 0, NULL, '');
896 INSERT INTO `0_gl_trans` VALUES(32, 26, 3, '2009-06-21', '1510', '', -20, 0, 0, NULL, '');
897 INSERT INTO `0_gl_trans` VALUES(33, 26, 3, '2009-06-21', '1510', '', -22, 0, 0, NULL, '');
898 INSERT INTO `0_gl_trans` VALUES(34, 26, 3, '2009-06-21', '1510', '', -24, 0, 0, NULL, '');
899 INSERT INTO `0_gl_trans` VALUES(35, 26, 3, '2009-06-21', '1540', '', 66, 0, 0, NULL, '');
900 INSERT INTO `0_gl_trans` VALUES(36, 2, 5, '2009-06-21', '2150', 'Cash Sales', -4.76, 0, 0, 4, '3');
901 INSERT INTO `0_gl_trans` VALUES(37, 2, 5, '2009-06-21', '4010', 'Cash Sales', -95.24, 0, 0, 4, '3');
902 INSERT INTO `0_gl_trans` VALUES(38, 2, 5, '2009-06-21', '1060', '', 100, 0, 0, 4, '3');
903 INSERT INTO `0_gl_trans` VALUES(39, 1, 8, '2009-06-21', '2150', 'Maintenance', 2.38, 0, 0, 4, '1');
904 INSERT INTO `0_gl_trans` VALUES(40, 1, 8, '2009-06-21', '5765', 'Maintenance', 47.62, 0, 0, 4, '1');
905 INSERT INTO `0_gl_trans` VALUES(41, 1, 8, '2009-06-21', '1060', '', -50, 0, 0, 4, '1');
906 INSERT INTO `0_gl_trans` VALUES(42, 20, 8, '2009-06-21', '2100', '', -20, 0, 0, 3, '2');
907 INSERT INTO `0_gl_trans` VALUES(43, 20, 8, '2009-06-21', '2150', '', 0.95, 0, 0, 3, '2');
908 INSERT INTO `0_gl_trans` VALUES(44, 20, 8, '2009-06-21', '5780', '', 19.05, 0, 0, 3, '2');
909 INSERT INTO `0_gl_trans` VALUES(45, 26, 4, '2009-06-21', '1510', '', -40, 0, 0, NULL, '');
910 INSERT INTO `0_gl_trans` VALUES(46, 26, 4, '2009-06-21', '1510', '', -44, 0, 0, NULL, '');
911 INSERT INTO `0_gl_trans` VALUES(47, 26, 4, '2009-06-21', '1510', '', -48, 0, 0, NULL, '');
912 INSERT INTO `0_gl_trans` VALUES(48, 26, 4, '2009-06-21', '1540', '', 132, 0, 0, NULL, '');
913 INSERT INTO `0_gl_trans` VALUES(49, 26, 2, '2009-06-21', '1510', '', -20, 0, 0, NULL, '');
914 INSERT INTO `0_gl_trans` VALUES(50, 26, 2, '2009-06-21', '1510', '', -22, 0, 0, NULL, '');
915 INSERT INTO `0_gl_trans` VALUES(51, 26, 2, '2009-06-21', '1510', '', -24, 0, 0, NULL, '');
916 INSERT INTO `0_gl_trans` VALUES(52, 26, 2, '2009-06-21', '1540', '', 66, 0, 0, NULL, '');
917 INSERT INTO `0_gl_trans` VALUES(53, 26, 5, '2009-06-21', '1510', '', -50, 0, 0, NULL, '');
918 INSERT INTO `0_gl_trans` VALUES(54, 26, 5, '2009-06-21', '1510', '', -55, 0, 0, NULL, '');
919 INSERT INTO `0_gl_trans` VALUES(55, 26, 5, '2009-06-21', '1510', '', -60, 0, 0, NULL, '');
920 INSERT INTO `0_gl_trans` VALUES(56, 26, 5, '2009-06-21', '1060', 'Overhead Cost', -10, 0, 0, 1, '1');
921 INSERT INTO `0_gl_trans` VALUES(57, 26, 5, '2009-06-21', '1530', 'Overhead Cost', 10, 0, 0, 1, '1');
922 INSERT INTO `0_gl_trans` VALUES(58, 26, 5, '2009-06-21', '1060', 'Labour Cost', -20, 0, 0, 1, '0');
923 INSERT INTO `0_gl_trans` VALUES(59, 26, 5, '2009-06-21', '1530', 'Labour Cost', 20, 0, 0, 1, '0');
924 INSERT INTO `0_gl_trans` VALUES(60, 26, 5, '2009-06-21', '1540', '', 165, 0, 0, NULL, '');
925 INSERT INTO `0_gl_trans` VALUES(61, 26, 6, '2009-06-21', '1510', '', 50, 0, 0, NULL, '');
926 INSERT INTO `0_gl_trans` VALUES(62, 26, 6, '2009-06-21', '1510', '', 55, 0, 0, NULL, '');
927 INSERT INTO `0_gl_trans` VALUES(63, 26, 6, '2009-06-21', '1510', '', 60, 0, 0, NULL, '');
928 INSERT INTO `0_gl_trans` VALUES(64, 26, 6, '2009-06-21', '1540', '', -165, 0, 0, NULL, '');
929 INSERT INTO `0_gl_trans` VALUES(65, 26, 7, '2009-06-21', '1510', '', 20, 0, 0, NULL, '');
930 INSERT INTO `0_gl_trans` VALUES(66, 26, 7, '2009-06-21', '1510', '', 22, 0, 0, NULL, '');
931 INSERT INTO `0_gl_trans` VALUES(67, 26, 7, '2009-06-21', '1510', '', 24, 0, 0, NULL, '');
932 INSERT INTO `0_gl_trans` VALUES(68, 26, 7, '2009-06-21', '1060', 'Overhead Cost', -10, 0, 0, 1, '1');
933 INSERT INTO `0_gl_trans` VALUES(69, 26, 7, '2009-06-21', '1530', 'Overhead Cost', 10, 0, 0, 1, '1');
934 INSERT INTO `0_gl_trans` VALUES(70, 26, 7, '2009-06-21', '1060', 'Labour Cost', -20, 0, 0, 1, '0');
935 INSERT INTO `0_gl_trans` VALUES(71, 26, 7, '2009-06-21', '1530', 'Labour Cost', 20, 0, 0, 1, '0');
936 INSERT INTO `0_gl_trans` VALUES(72, 26, 7, '2009-06-21', '1540', '', -66, 0, 0, NULL, '');
937 INSERT INTO `0_gl_trans` VALUES(73, 13, 5, '2009-06-21', '5010', '', 10, 0, 0, 2, '2');
938 INSERT INTO `0_gl_trans` VALUES(74, 13, 5, '2009-06-21', '1510', '', -10, 0, 0, 2, '2');
939 INSERT INTO `0_gl_trans` VALUES(75, 10, 19, '2009-06-21', '4010', '', -47.62, 0, 0, 2, '2');
940 INSERT INTO `0_gl_trans` VALUES(76, 10, 19, '2009-06-21', '1200', '', 55, 0, 0, 2, '2');
941 INSERT INTO `0_gl_trans` VALUES(77, 10, 19, '2009-06-21', '4430', '', -5, 0, 0, 2, '2');
942 INSERT INTO `0_gl_trans` VALUES(78, 10, 19, '2009-06-21', '2150', '', -2.38, 0, 0, 2, '2');
943 INSERT INTO `0_gl_trans` VALUES(79, 11, 3, '2009-06-21', '5010', '', -10, 2, 0, 2, '3');
944 INSERT INTO `0_gl_trans` VALUES(80, 11, 3, '2009-06-21', '1510', '', 10, 0, 0, 2, '3');
945 INSERT INTO `0_gl_trans` VALUES(81, 11, 3, '2009-06-21', '4010', '', 50, 2, 0, 2, '3');
946 INSERT INTO `0_gl_trans` VALUES(82, 11, 3, '2009-06-21', '1200', '', -52.5, 0, 0, 2, '3');
947 INSERT INTO `0_gl_trans` VALUES(83, 11, 3, '2009-06-21', '2150', '', 2.5, 0, 0, 2, '3');
948 INSERT INTO `0_gl_trans` VALUES ('84', '0', '20', '2009-12-31', '3590', 'Closing Year', '-91.19', '0', '0', NULL, NULL);
949 INSERT INTO `0_gl_trans` VALUES ('85', '0', '20', '2009-12-31', '9990', 'Closing Year', '91.19', '0', '0', NULL, NULL);
951 -- --------------------------------------------------------
954 -- Table structure for table `0_grn_batch`
957 DROP TABLE IF EXISTS `0_grn_batch`;
958 CREATE TABLE IF NOT EXISTS `0_grn_batch` (
959 `id` int(11) NOT NULL auto_increment,
960 `supplier_id` int(11) NOT NULL default '0',
961 `purch_order_no` int(11) default NULL,
962 `reference` varchar(60) NOT NULL default '',
963 `delivery_date` date NOT NULL default '0000-00-00',
964 `loc_code` varchar(5) default NULL,
966 KEY `delivery_date` (`delivery_date`),
967 KEY `purch_order_no` (`purch_order_no`)
968 ) ENGINE=InnoDB AUTO_INCREMENT=2 ;
971 -- Dumping data for table `0_grn_batch`
974 INSERT INTO `0_grn_batch` VALUES(1, 2, 1, '1', '2009-06-21', 'DEF');
976 -- --------------------------------------------------------
979 -- Table structure for table `0_grn_items`
982 DROP TABLE IF EXISTS `0_grn_items`;
983 CREATE TABLE IF NOT EXISTS `0_grn_items` (
984 `id` int(11) NOT NULL auto_increment,
985 `grn_batch_id` int(11) default NULL,
986 `po_detail_item` int(11) NOT NULL default '0',
987 `item_code` varchar(20) NOT NULL default '',
988 `description` tinytext,
989 `qty_recd` double NOT NULL default '0',
990 `quantity_inv` double NOT NULL default '0',
992 KEY `grn_batch_id` (`grn_batch_id`)
993 ) ENGINE=InnoDB AUTO_INCREMENT=4 ;
996 -- Dumping data for table `0_grn_items`
999 INSERT INTO `0_grn_items` VALUES(1, 1, 1, '102', '17inch VGA Monitor', 100, 100);
1000 INSERT INTO `0_grn_items` VALUES(2, 1, 2, '103', '32MB VGA Card', 100, 100);
1001 INSERT INTO `0_grn_items` VALUES(3, 1, 3, '104', '52x CD Drive', 100, 100);
1003 -- --------------------------------------------------------
1006 -- Table structure for table `0_groups`
1009 DROP TABLE IF EXISTS `0_groups`;
1010 CREATE TABLE IF NOT EXISTS `0_groups` (
1011 `id` smallint(6) unsigned NOT NULL auto_increment,
1012 `description` varchar(60) NOT NULL default '',
1013 `inactive` tinyint(1) NOT NULL default '0',
1015 UNIQUE KEY `description` (`description`)
1016 ) ENGINE=MyISAM AUTO_INCREMENT=4 ;
1019 -- Dumping data for table `0_groups`
1022 INSERT INTO `0_groups` VALUES(1, 'Small', 0);
1023 INSERT INTO `0_groups` VALUES(2, 'Medium', 0);
1024 INSERT INTO `0_groups` VALUES(3, 'Large', 0);
1026 -- --------------------------------------------------------
1029 -- Table structure for table `0_item_codes`
1032 DROP TABLE IF EXISTS `0_item_codes`;
1033 CREATE TABLE IF NOT EXISTS `0_item_codes` (
1034 `id` int(11) unsigned NOT NULL auto_increment,
1035 `item_code` varchar(20) NOT NULL,
1036 `stock_id` varchar(20) NOT NULL,
1037 `description` varchar(200) NOT NULL default '',
1038 `category_id` smallint(6) unsigned NOT NULL,
1039 `quantity` double NOT NULL default '1',
1040 `is_foreign` tinyint(1) NOT NULL default '0',
1041 `inactive` tinyint(1) NOT NULL default '0',
1043 UNIQUE KEY `stock_id` (`stock_id`,`item_code`),
1044 KEY `item_code` (`item_code`)
1045 ) ENGINE=MyISAM AUTO_INCREMENT=6 ;
1048 -- Dumping data for table `0_item_codes`
1051 INSERT INTO `0_item_codes` VALUES(1, '102', '102', '17inch VGA Monitor', 1, 1, 0, 0);
1052 INSERT INTO `0_item_codes` VALUES(2, '103', '103', '32MB VGA Card', 1, 1, 0, 0);
1053 INSERT INTO `0_item_codes` VALUES(3, '104', '104', '52x CD Drive', 1, 1, 0, 0);
1054 INSERT INTO `0_item_codes` VALUES(4, '3400', '3400', 'P4 Business System', 3, 1, 0, 0);
1055 INSERT INTO `0_item_codes` VALUES(5, '201', '201', 'Assembly Labour', 4, 1, 0, 0);
1057 -- --------------------------------------------------------
1060 -- Table structure for table `0_item_tax_types`
1063 DROP TABLE IF EXISTS `0_item_tax_types`;
1064 CREATE TABLE IF NOT EXISTS `0_item_tax_types` (
1065 `id` int(11) NOT NULL auto_increment,
1066 `name` varchar(60) NOT NULL default '',
1067 `exempt` tinyint(1) NOT NULL default '0',
1068 `inactive` tinyint(1) NOT NULL default '0',
1070 UNIQUE KEY `name` (`name`)
1071 ) ENGINE=InnoDB AUTO_INCREMENT=2 ;
1074 -- Dumping data for table `0_item_tax_types`
1077 INSERT INTO `0_item_tax_types` VALUES(1, 'Regular', 0, 0);
1079 -- --------------------------------------------------------
1082 -- Table structure for table `0_item_tax_type_exemptions`
1085 DROP TABLE IF EXISTS `0_item_tax_type_exemptions`;
1086 CREATE TABLE IF NOT EXISTS `0_item_tax_type_exemptions` (
1087 `item_tax_type_id` int(11) NOT NULL default '0',
1088 `tax_type_id` int(11) NOT NULL default '0',
1089 PRIMARY KEY (`item_tax_type_id`,`tax_type_id`)
1093 -- Dumping data for table `0_item_tax_type_exemptions`
1097 -- --------------------------------------------------------
1100 -- Table structure for table `0_item_units`
1103 DROP TABLE IF EXISTS `0_item_units`;
1104 CREATE TABLE IF NOT EXISTS `0_item_units` (
1105 `abbr` varchar(20) NOT NULL,
1106 `name` varchar(40) NOT NULL,
1107 `decimals` tinyint(2) NOT NULL,
1108 `inactive` tinyint(1) NOT NULL default '0',
1109 PRIMARY KEY (`abbr`),
1110 UNIQUE KEY `name` (`name`)
1114 -- Dumping data for table `0_item_units`
1117 INSERT INTO `0_item_units` VALUES('ea.', 'Each', 0, 0);
1118 INSERT INTO `0_item_units` VALUES('hrs', 'Hours', 1, 0);
1120 -- --------------------------------------------------------
1123 -- Table structure for table `0_locations`
1126 DROP TABLE IF EXISTS `0_locations`;
1127 CREATE TABLE IF NOT EXISTS `0_locations` (
1128 `loc_code` varchar(5) NOT NULL default '',
1129 `location_name` varchar(60) NOT NULL default '',
1130 `delivery_address` tinytext NOT NULL,
1131 `phone` varchar(30) NOT NULL default '',
1132 `phone2` varchar(30) NOT NULL default '',
1133 `fax` varchar(30) NOT NULL default '',
1134 `email` varchar(100) NOT NULL default '',
1135 `contact` varchar(30) NOT NULL default '',
1136 `inactive` tinyint(1) NOT NULL default '0',
1137 PRIMARY KEY (`loc_code`)
1141 -- Dumping data for table `0_locations`
1144 INSERT INTO `0_locations` VALUES('DEF', 'Default', 'Delivery 1\nDelivery 2\nDelivery 3', '', '', '', '', '', 0);
1146 -- --------------------------------------------------------
1149 -- Table structure for table `0_loc_stock`
1152 DROP TABLE IF EXISTS `0_loc_stock`;
1153 CREATE TABLE IF NOT EXISTS `0_loc_stock` (
1154 `loc_code` char(5) NOT NULL default '',
1155 `stock_id` char(20) NOT NULL default '',
1156 `reorder_level` bigint(20) NOT NULL default '0',
1157 PRIMARY KEY (`loc_code`,`stock_id`),
1158 KEY `stock_id` (`stock_id`)
1162 -- Dumping data for table `0_loc_stock`
1165 INSERT INTO `0_loc_stock` VALUES('DEF', '102', 0);
1166 INSERT INTO `0_loc_stock` VALUES('DEF', '103', 0);
1167 INSERT INTO `0_loc_stock` VALUES('DEF', '104', 0);
1168 INSERT INTO `0_loc_stock` VALUES('DEF', '201', 0);
1169 INSERT INTO `0_loc_stock` VALUES('DEF', '3400', 0);
1171 -- --------------------------------------------------------
1174 -- Table structure for table `0_movement_types`
1177 DROP TABLE IF EXISTS `0_movement_types`;
1178 CREATE TABLE IF NOT EXISTS `0_movement_types` (
1179 `id` int(11) NOT NULL auto_increment,
1180 `name` varchar(60) NOT NULL default '',
1181 `inactive` tinyint(1) NOT NULL default '0',
1183 UNIQUE KEY `name` (`name`)
1184 ) ENGINE=MyISAM AUTO_INCREMENT=2 ;
1187 -- Dumping data for table `0_movement_types`
1190 INSERT INTO `0_movement_types` VALUES(1, 'Adjustment', 0);
1192 -- --------------------------------------------------------
1195 -- Table structure for table `0_payment_terms`
1198 DROP TABLE IF EXISTS `0_payment_terms`;
1199 CREATE TABLE IF NOT EXISTS `0_payment_terms` (
1200 `terms_indicator` int(11) NOT NULL auto_increment,
1201 `terms` char(80) NOT NULL default '',
1202 `days_before_due` smallint(6) NOT NULL default '0',
1203 `day_in_following_month` smallint(6) NOT NULL default '0',
1204 `inactive` tinyint(1) NOT NULL default '0',
1205 PRIMARY KEY (`terms_indicator`),
1206 UNIQUE KEY `terms` (`terms`)
1207 ) ENGINE=MyISAM AUTO_INCREMENT=5 ;
1210 -- Dumping data for table `0_payment_terms`
1213 INSERT INTO `0_payment_terms` VALUES(1, 'Due 15th Of the Following Month', 0, 17, 0);
1214 INSERT INTO `0_payment_terms` VALUES(2, 'Due By End Of The Following Month', 0, 30, 0);
1215 INSERT INTO `0_payment_terms` VALUES(3, 'Payment due within 10 days', 10, 0, 0);
1216 INSERT INTO `0_payment_terms` VALUES(4, 'Cash Only', 0, 0, 0);
1218 -- --------------------------------------------------------
1221 -- Table structure for table `0_prices`
1224 DROP TABLE IF EXISTS `0_prices`;
1225 CREATE TABLE IF NOT EXISTS `0_prices` (
1226 `id` int(11) NOT NULL auto_increment,
1227 `stock_id` varchar(20) NOT NULL default '',
1228 `sales_type_id` int(11) NOT NULL default '0',
1229 `curr_abrev` char(3) NOT NULL default '',
1230 `price` double NOT NULL default '0',
1232 UNIQUE KEY `price` (`stock_id`,`sales_type_id`,`curr_abrev`)
1233 ) ENGINE=MyISAM AUTO_INCREMENT=5 ;
1236 -- Dumping data for table `0_prices`
1239 INSERT INTO `0_prices` VALUES(1, '3400', 1, 'USD', 100);
1240 INSERT INTO `0_prices` VALUES(2, '102', 1, 'USD', 50);
1241 INSERT INTO `0_prices` VALUES(3, '103', 1, 'USD', 55);
1242 INSERT INTO `0_prices` VALUES(4, '104', 1, 'USD', 60);
1244 -- --------------------------------------------------------
1247 -- Table structure for table `0_printers`
1250 DROP TABLE IF EXISTS `0_printers`;
1251 CREATE TABLE IF NOT EXISTS `0_printers` (
1252 `id` tinyint(3) unsigned NOT NULL auto_increment,
1253 `name` varchar(20) NOT NULL,
1254 `description` varchar(60) NOT NULL,
1255 `queue` varchar(20) NOT NULL,
1256 `host` varchar(40) NOT NULL,
1257 `port` smallint(11) unsigned NOT NULL,
1258 `timeout` tinyint(3) unsigned NOT NULL,
1260 UNIQUE KEY `name` (`name`)
1261 ) ENGINE=MyISAM AUTO_INCREMENT=4 ;
1264 -- Dumping data for table `0_printers`
1267 INSERT INTO `0_printers` VALUES(1, 'QL500', 'Label printer', 'QL500', 'server', 127, 20);
1268 INSERT INTO `0_printers` VALUES(2, 'Samsung', 'Main network printer', 'scx4521F', 'server', 515, 5);
1269 INSERT INTO `0_printers` VALUES(3, 'Local', 'Local print server at user IP', 'lp', '', 515, 10);
1271 -- --------------------------------------------------------
1274 -- Table structure for table `0_print_profiles`
1277 DROP TABLE IF EXISTS `0_print_profiles`;
1278 CREATE TABLE IF NOT EXISTS `0_print_profiles` (
1279 `id` smallint(6) unsigned NOT NULL auto_increment,
1280 `profile` varchar(30) NOT NULL,
1281 `report` varchar(5) default NULL,
1282 `printer` tinyint(3) unsigned default NULL,
1284 UNIQUE KEY `profile` (`profile`,`report`)
1285 ) ENGINE=MyISAM AUTO_INCREMENT=10 ;
1288 -- Dumping data for table `0_print_profiles`
1291 INSERT INTO `0_print_profiles` VALUES(1, 'Out of office', '', 0);
1292 INSERT INTO `0_print_profiles` VALUES(2, 'Sales Department', '', 0);
1293 INSERT INTO `0_print_profiles` VALUES(3, 'Central', '', 2);
1294 INSERT INTO `0_print_profiles` VALUES(4, 'Sales Department', '104', 2);
1295 INSERT INTO `0_print_profiles` VALUES(5, 'Sales Department', '105', 2);
1296 INSERT INTO `0_print_profiles` VALUES(6, 'Sales Department', '107', 2);
1297 INSERT INTO `0_print_profiles` VALUES(7, 'Sales Department', '109', 2);
1298 INSERT INTO `0_print_profiles` VALUES(8, 'Sales Department', '110', 2);
1299 INSERT INTO `0_print_profiles` VALUES(9, 'Sales Department', '201', 2);
1301 -- --------------------------------------------------------
1304 -- Table structure for table `0_purch_data`
1307 DROP TABLE IF EXISTS `0_purch_data`;
1308 CREATE TABLE IF NOT EXISTS `0_purch_data` (
1309 `supplier_id` int(11) NOT NULL default '0',
1310 `stock_id` char(20) NOT NULL default '',
1311 `price` double NOT NULL default '0',
1312 `suppliers_uom` char(50) NOT NULL default '',
1313 `conversion_factor` double NOT NULL default '1',
1314 `supplier_description` char(50) NOT NULL default '',
1315 PRIMARY KEY (`supplier_id`,`stock_id`)
1319 -- Dumping data for table `0_purch_data`
1322 INSERT INTO `0_purch_data` VALUES(2, '102', 10, '', 1, '17inch VGA Monitor');
1323 INSERT INTO `0_purch_data` VALUES(2, '103', 11, '', 1, '32MB VGA Card');
1324 INSERT INTO `0_purch_data` VALUES(2, '104', 12, '', 1, '52x CD Drive');
1326 -- --------------------------------------------------------
1329 -- Table structure for table `0_purch_orders`
1332 DROP TABLE IF EXISTS `0_purch_orders`;
1333 CREATE TABLE IF NOT EXISTS `0_purch_orders` (
1334 `order_no` int(11) NOT NULL auto_increment,
1335 `supplier_id` int(11) NOT NULL default '0',
1336 `comments` tinytext,
1337 `ord_date` date NOT NULL default '0000-00-00',
1338 `reference` tinytext NOT NULL,
1339 `requisition_no` tinytext,
1340 `into_stock_location` varchar(5) NOT NULL default '',
1341 `delivery_address` tinytext NOT NULL,
1342 `total` double NOT NULL default '0',
1343 `prep_amount` double NOT NULL DEFAULT '0',
1344 `alloc` double NOT NULL DEFAULT '0',
1345 `tax_included` tinyint(1) NOT NULL default '0',
1346 PRIMARY KEY (`order_no`),
1347 KEY `ord_date` (`ord_date`)
1348 ) ENGINE=InnoDB AUTO_INCREMENT=3 ;
1351 -- Dumping data for table `0_purch_orders`
1354 INSERT INTO `0_purch_orders` VALUES(1, 2, '', '2009-06-01', '1', '', 'DEF', 'Delivery 1\nDelivery 2\nDelivery 3', 0, 0, 0, 0);
1355 INSERT INTO `0_purch_orders` VALUES(2, 3, '', '2009-06-21', '2', '', 'DEF', 'Delivery 1\nDelivery 2\nDelivery 3', 0, 0, 0, 0);
1357 -- --------------------------------------------------------
1360 -- Table structure for table `0_purch_order_details`
1363 DROP TABLE IF EXISTS `0_purch_order_details`;
1364 CREATE TABLE IF NOT EXISTS `0_purch_order_details` (
1365 `po_detail_item` int(11) NOT NULL auto_increment,
1366 `order_no` int(11) NOT NULL default '0',
1367 `item_code` varchar(20) NOT NULL default '',
1368 `description` tinytext,
1369 `delivery_date` date NOT NULL default '0000-00-00',
1370 `qty_invoiced` double NOT NULL default '0',
1371 `unit_price` double NOT NULL default '0',
1372 `act_price` double NOT NULL default '0',
1373 `std_cost_unit` double NOT NULL default '0',
1374 `quantity_ordered` double NOT NULL default '0',
1375 `quantity_received` double NOT NULL default '0',
1376 PRIMARY KEY (`po_detail_item`),
1377 KEY `order` (`order_no`,`po_detail_item`),
1378 KEY `itemcode` (`item_code`)
1379 ) ENGINE=InnoDB AUTO_INCREMENT=6 ;
1382 -- Dumping data for table `0_purch_order_details`
1385 INSERT INTO `0_purch_order_details` VALUES(1, 1, '102', '17inch VGA Monitor', '2009-07-01', 100, 10, 10, 10, 100, 100);
1386 INSERT INTO `0_purch_order_details` VALUES(2, 1, '103', '32MB VGA Card', '2009-07-01', 100, 11, 11, 11, 100, 100);
1387 INSERT INTO `0_purch_order_details` VALUES(3, 1, '104', '52x CD Drive', '2009-07-01', 100, 12, 12, 12, 100, 100);
1388 INSERT INTO `0_purch_order_details` VALUES(4, 2, '102', '17inch VGA Monitor', '2009-07-01', 0, 5, 0, 0, 1, 0);
1389 INSERT INTO `0_purch_order_details` VALUES(5, 2, '103', '32MB VGA Card', '2009-07-01', 0, 5, 0, 0, 1, 0);
1391 -- --------------------------------------------------------
1394 -- Table structure for table `0_quick_entries`
1397 DROP TABLE IF EXISTS `0_quick_entries`;
1398 CREATE TABLE IF NOT EXISTS `0_quick_entries` (
1399 `id` smallint(6) unsigned NOT NULL auto_increment,
1400 `type` tinyint(1) NOT NULL default '0',
1401 `description` varchar(60) NOT NULL,
1402 `base_amount` double NOT NULL default '0',
1403 `base_desc` varchar(60) default NULL,
1404 `bal_type` tinyint(1) NOT NULL default '0',
1406 KEY `description` (`description`)
1407 ) ENGINE=MyISAM AUTO_INCREMENT=4 ;
1410 -- Dumping data for table `0_quick_entries`
1413 INSERT INTO `0_quick_entries` VALUES(1, 1, 'Maintenance', 0, 'Amount', 0);
1414 INSERT INTO `0_quick_entries` VALUES(2, 4, 'Phone', 0, 'Amount', 0);
1415 INSERT INTO `0_quick_entries` VALUES(3, 2, 'Cash Sales', 0, 'Amount', 0);
1417 -- --------------------------------------------------------
1420 -- Table structure for table `0_quick_entry_lines`
1423 DROP TABLE IF EXISTS `0_quick_entry_lines`;
1424 CREATE TABLE IF NOT EXISTS `0_quick_entry_lines` (
1425 `id` smallint(6) unsigned NOT NULL auto_increment,
1426 `qid` smallint(6) unsigned NOT NULL,
1427 `amount` double default '0',
1428 `action` varchar(2) NOT NULL,
1429 `dest_id` varchar(15) NOT NULL default '',
1430 `dimension_id` smallint(6) unsigned default NULL,
1431 `dimension2_id` smallint(6) unsigned default NULL,
1434 ) ENGINE=MyISAM AUTO_INCREMENT=8 ;
1437 -- Dumping data for table `0_quick_entry_lines`
1440 INSERT INTO `0_quick_entry_lines` VALUES(1, 1, 0, 't-', '1', 0, 0);
1441 INSERT INTO `0_quick_entry_lines` VALUES(2, 2, 0, 't-', '1', 0, 0);
1442 INSERT INTO `0_quick_entry_lines` VALUES(3, 3, 0, 't-', '1', 0, 0);
1443 INSERT INTO `0_quick_entry_lines` VALUES(4, 3, 0, '=', '4010', 0, 0);
1444 INSERT INTO `0_quick_entry_lines` VALUES(5, 1, 0, '=', '5765', 0, 0);
1445 INSERT INTO `0_quick_entry_lines` VALUES(6, 2, 0, '=', '5780', 0, 0);
1447 -- --------------------------------------------------------
1450 -- Table structure for table `0_recurrent_invoices`
1453 DROP TABLE IF EXISTS `0_recurrent_invoices`;
1454 CREATE TABLE IF NOT EXISTS `0_recurrent_invoices` (
1455 `id` smallint(6) unsigned NOT NULL auto_increment,
1456 `description` varchar(60) NOT NULL default '',
1457 `order_no` int(11) unsigned NOT NULL,
1458 `debtor_no` int(11) unsigned default NULL,
1459 `group_no` smallint(6) unsigned default NULL,
1460 `days` int(11) NOT NULL default '0',
1461 `monthly` int(11) NOT NULL default '0',
1462 `begin` date NOT NULL default '0000-00-00',
1463 `end` date NOT NULL default '0000-00-00',
1464 `last_sent` date NOT NULL default '0000-00-00',
1466 UNIQUE KEY `description` (`description`)
1467 ) ENGINE=InnoDB AUTO_INCREMENT=1 ;
1470 -- Dumping data for table `0_recurrent_invoices`
1474 -- --------------------------------------------------------
1477 -- Table structure for table `0_refs`
1480 DROP TABLE IF EXISTS `0_refs`;
1481 CREATE TABLE IF NOT EXISTS `0_refs` (
1482 `id` int(11) NOT NULL default '0',
1483 `type` int(11) NOT NULL default '0',
1484 `reference` varchar(100) NOT NULL default '',
1485 PRIMARY KEY (`id`,`type`),
1486 KEY `Type_and_Reference` (`type`,`reference`)
1490 -- Dumping data for table `0_refs`
1493 INSERT INTO `0_refs` VALUES(18, 0, '1');
1494 INSERT INTO `0_refs` VALUES(19, 0, '2');
1496 -- --------------------------------------------------------
1499 -- Table structure for table `0_salesman`
1502 DROP TABLE IF EXISTS `0_salesman`;
1503 CREATE TABLE IF NOT EXISTS `0_salesman` (
1504 `salesman_code` int(11) NOT NULL auto_increment,
1505 `salesman_name` char(60) NOT NULL default '',
1506 `salesman_phone` char(30) NOT NULL default '',
1507 `salesman_fax` char(30) NOT NULL default '',
1508 `salesman_email` varchar(100) NOT NULL default '',
1509 `provision` double NOT NULL default '0',
1510 `break_pt` double NOT NULL default '0',
1511 `provision2` double NOT NULL default '0',
1512 `inactive` tinyint(1) NOT NULL default '0',
1513 PRIMARY KEY (`salesman_code`),
1514 UNIQUE KEY `salesman_name` (`salesman_name`)
1515 ) ENGINE=MyISAM AUTO_INCREMENT=2 ;
1518 -- Dumping data for table `0_salesman`
1521 INSERT INTO `0_salesman` VALUES(1, 'Sales Person', '', '', '', 5, 1000, 4, 0);
1523 -- --------------------------------------------------------
1526 -- Table structure for table `0_sales_orders`
1529 DROP TABLE IF EXISTS `0_sales_orders`;
1530 CREATE TABLE IF NOT EXISTS `0_sales_orders` (
1531 `order_no` int(11) NOT NULL,
1532 `trans_type` smallint(6) NOT NULL default '30',
1533 `version` tinyint(1) unsigned NOT NULL default '0',
1534 `type` tinyint(1) NOT NULL default '0',
1535 `debtor_no` int(11) NOT NULL default '0',
1536 `branch_code` int(11) NOT NULL default '0',
1537 `reference` varchar(100) NOT NULL default '',
1538 `customer_ref` tinytext NOT NULL,
1539 `comments` tinytext,
1540 `ord_date` date NOT NULL default '0000-00-00',
1541 `order_type` int(11) NOT NULL default '0',
1542 `ship_via` int(11) NOT NULL default '0',
1543 `delivery_address` tinytext NOT NULL,
1544 `contact_phone` varchar(30) default NULL,
1545 `contact_email` varchar(100) default NULL,
1546 `deliver_to` tinytext NOT NULL,
1547 `freight_cost` double NOT NULL default '0',
1548 `from_stk_loc` varchar(5) NOT NULL default '',
1549 `delivery_date` date NOT NULL default '0000-00-00',
1550 `payment_terms` int(11) default NULL,
1551 `total` double NOT NULL default '0',
1552 `prep_amount` double NOT NULL DEFAULT '0',
1553 `alloc` double NOT NULL DEFAULT '0',
1554 PRIMARY KEY (`trans_type`,`order_no`)
1558 -- Dumping data for table `0_sales_orders`
1561 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, 0, 0);
1562 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, 0, 0);
1563 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, 0, 0);
1564 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, 0, 0);
1565 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, 0, 0);
1567 -- --------------------------------------------------------
1570 -- Table structure for table `0_sales_order_details`
1573 DROP TABLE IF EXISTS `0_sales_order_details`;
1574 CREATE TABLE IF NOT EXISTS `0_sales_order_details` (
1575 `id` int(11) NOT NULL auto_increment,
1576 `order_no` int(11) NOT NULL default '0',
1577 `trans_type` smallint(6) NOT NULL default '30',
1578 `stk_code` varchar(20) NOT NULL default '',
1579 `description` tinytext,
1580 `qty_sent` double NOT NULL default '0',
1581 `unit_price` double NOT NULL default '0',
1582 `quantity` double NOT NULL default '0',
1583 `invoiced` double NOT NULL DEFAULT '0',
1584 `discount_percent` double NOT NULL default '0',
1586 KEY `sorder` (`trans_type`,`order_no`),
1587 KEY `stkcode` (`stk_code`)
1588 ) ENGINE=InnoDB AUTO_INCREMENT=6 ;
1591 -- Dumping data for table `0_sales_order_details`
1594 INSERT INTO `0_sales_order_details` VALUES(1, 1, 30, '102', '17inch VGA Monitor', 2, 30.4, 2, 0, 0);
1595 INSERT INTO `0_sales_order_details` VALUES(2, 2, 30, '102', '17inch VGA Monitor', 1, 50, 1, 0, 0);
1596 INSERT INTO `0_sales_order_details` VALUES(3, 3, 30, '102', '17inch VGA Monitor', 1, 35.89, 1, 0, 0);
1597 INSERT INTO `0_sales_order_details` VALUES(4, 4, 30, '102', '17inch VGA Monitor', 0, 21.28, 2, 0, 0);
1598 INSERT INTO `0_sales_order_details` VALUES(5, 5, 30, '102', '17inch VGA Monitor', 1, 50, 1, 0, 0);
1600 -- --------------------------------------------------------
1603 -- Table structure for table `0_sales_pos`
1606 DROP TABLE IF EXISTS `0_sales_pos`;
1607 CREATE TABLE IF NOT EXISTS `0_sales_pos` (
1608 `id` smallint(6) unsigned NOT NULL auto_increment,
1609 `pos_name` varchar(30) NOT NULL,
1610 `cash_sale` tinyint(1) NOT NULL,
1611 `credit_sale` tinyint(1) NOT NULL,
1612 `pos_location` varchar(5) NOT NULL,
1613 `pos_account` smallint(6) unsigned NOT NULL,
1614 `inactive` tinyint(1) NOT NULL default '0',
1616 UNIQUE KEY `pos_name` (`pos_name`)
1617 ) ENGINE=MyISAM AUTO_INCREMENT=2 ;
1620 -- Dumping data for table `0_sales_pos`
1623 INSERT INTO `0_sales_pos` VALUES(1, 'Default', 1, 1, 'DEF', 2, 0);
1625 -- --------------------------------------------------------
1628 -- Table structure for table `0_sales_types`
1631 DROP TABLE IF EXISTS `0_sales_types`;
1632 CREATE TABLE IF NOT EXISTS `0_sales_types` (
1633 `id` int(11) NOT NULL auto_increment,
1634 `sales_type` char(50) NOT NULL default '',
1635 `tax_included` int(1) NOT NULL default '0',
1636 `factor` double NOT NULL default '1',
1637 `inactive` tinyint(1) NOT NULL default '0',
1639 UNIQUE KEY `sales_type` (`sales_type`)
1640 ) ENGINE=MyISAM AUTO_INCREMENT=3 ;
1643 -- Dumping data for table `0_sales_types`
1646 INSERT INTO `0_sales_types` VALUES(1, 'Retail', 1, 1, 0);
1647 INSERT INTO `0_sales_types` VALUES(2, 'Wholesale', 0, 0.7, 0);
1649 -- --------------------------------------------------------
1652 -- Table structure for table `0_security_roles`
1655 DROP TABLE IF EXISTS `0_security_roles`;
1656 CREATE TABLE IF NOT EXISTS `0_security_roles` (
1657 `id` int(11) NOT NULL auto_increment,
1658 `role` varchar(30) NOT NULL,
1659 `description` varchar(50) default NULL,
1662 `inactive` tinyint(1) NOT NULL default '0',
1664 UNIQUE KEY `role` (`role`)
1665 ) ENGINE=MyISAM AUTO_INCREMENT=11 ;
1668 -- Dumping data for table `0_security_roles`
1671 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;775', 0);
1672 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;775', 0);
1673 INSERT INTO `0_security_roles` VALUES(3, 'Salesman', 'Salesman', '768;3072;5632;8192;15872', '773;774;3073;3075;3081;5633;8194;15873;775', 0);
1674 INSERT INTO `0_security_roles` VALUES(4, 'Stock Manager', 'Stock Manager', '768;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;775', 0);
1675 INSERT INTO `0_security_roles` VALUES(5, 'Production Manager', 'Production Manager', '512;768;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;775', 0);
1676 INSERT INTO `0_security_roles` VALUES(6, 'Purchase Officer', 'Purchase Officer', '512;768;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;775', 0);
1677 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;775', 0);
1678 INSERT INTO `0_security_roles` VALUES(8, 'AP Officer', 'AP Officer', '512;768;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;775', 0);
1679 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;775', 0);
1680 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;775', 0);
1682 -- --------------------------------------------------------
1685 -- Table structure for table `0_shippers`
1688 DROP TABLE IF EXISTS `0_shippers`;
1689 CREATE TABLE IF NOT EXISTS `0_shippers` (
1690 `shipper_id` int(11) NOT NULL auto_increment,
1691 `shipper_name` varchar(60) NOT NULL default '',
1692 `phone` varchar(30) NOT NULL default '',
1693 `phone2` varchar(30) NOT NULL default '',
1694 `contact` tinytext NOT NULL,
1695 `address` tinytext NOT NULL,
1696 `inactive` tinyint(1) NOT NULL default '0',
1697 PRIMARY KEY (`shipper_id`),
1698 UNIQUE KEY `name` (`shipper_name`)
1699 ) ENGINE=MyISAM AUTO_INCREMENT=2 ;
1702 -- Dumping data for table `0_shippers`
1705 INSERT INTO `0_shippers` VALUES(1, 'Default', '', '', '', '', 0);
1707 -- --------------------------------------------------------
1710 -- Table structure for table `0_sql_trail`
1713 DROP TABLE IF EXISTS `0_sql_trail`;
1714 CREATE TABLE IF NOT EXISTS `0_sql_trail` (
1715 `id` int(11) unsigned NOT NULL auto_increment,
1716 `sql` text NOT NULL,
1717 `result` tinyint(1) NOT NULL,
1718 `msg` varchar(255) NOT NULL,
1720 ) ENGINE=MyISAM AUTO_INCREMENT=1 ;
1723 -- Dumping data for table `0_sql_trail`
1727 -- --------------------------------------------------------
1730 -- Table structure for table `0_stock_category`
1733 DROP TABLE IF EXISTS `0_stock_category`;
1734 CREATE TABLE IF NOT EXISTS `0_stock_category` (
1735 `category_id` int(11) NOT NULL auto_increment,
1736 `description` varchar(60) NOT NULL default '',
1737 `dflt_tax_type` int(11) NOT NULL default '1',
1738 `dflt_units` varchar(20) NOT NULL default 'each',
1739 `dflt_mb_flag` char(1) NOT NULL default 'B',
1740 `dflt_sales_act` varchar(15) NOT NULL default '',
1741 `dflt_cogs_act` varchar(15) NOT NULL default '',
1742 `dflt_inventory_act` varchar(15) NOT NULL default '',
1743 `dflt_adjustment_act` varchar(15) NOT NULL default '',
1744 `dflt_assembly_act` varchar(15) NOT NULL default '',
1745 `dflt_dim1` int(11) default NULL,
1746 `dflt_dim2` int(11) default NULL,
1747 `inactive` tinyint(1) NOT NULL default '0',
1748 `dflt_no_sale` tinyint(1) NOT NULL default '0',
1749 `dflt_no_purchase` tinyint(1) NOT NULL default '0',
1750 PRIMARY KEY (`category_id`),
1751 UNIQUE KEY `description` (`description`)
1752 ) ENGINE=MyISAM AUTO_INCREMENT=5 ;
1755 -- Dumping data for table `0_stock_category`
1758 INSERT INTO `0_stock_category` VALUES(1, 'Components', 1, 'each', 'B', '4010', '5010', '1510', '5040', '1530', 0, 0, 0, 0, 0);
1759 INSERT INTO `0_stock_category` VALUES(2, 'Charges', 1, 'each', 'D', '4010', '5010', '1510', '5040', '1530', 0, 0, 0, 0, 0);
1760 INSERT INTO `0_stock_category` VALUES(3, 'Systems', 1, 'each', 'M', '4010', '5010', '1510', '5040', '1530', 0, 0, 0, 0, 0);
1761 INSERT INTO `0_stock_category` VALUES(4, 'Services', 1, 'hrs', 'D', '4010', '5010', '1510', '5040', '1530', 0, 0, 0, 0, 0);
1763 -- --------------------------------------------------------
1766 -- Table structure for table `0_stock_master`
1769 DROP TABLE IF EXISTS `0_stock_master`;
1770 CREATE TABLE IF NOT EXISTS `0_stock_master` (
1771 `stock_id` varchar(20) NOT NULL default '',
1772 `category_id` int(11) NOT NULL default '0',
1773 `tax_type_id` int(11) NOT NULL default '0',
1774 `description` varchar(200) NOT NULL default '',
1775 `long_description` tinytext NOT NULL,
1776 `units` varchar(20) NOT NULL default 'each',
1777 `mb_flag` char(1) NOT NULL default 'B',
1778 `sales_account` varchar(15) NOT NULL default '',
1779 `cogs_account` varchar(15) NOT NULL default '',
1780 `inventory_account` varchar(15) NOT NULL default '',
1781 `adjustment_account` varchar(15) NOT NULL default '',
1782 `assembly_account` varchar(15) NOT NULL default '',
1783 `dimension_id` int(11) default NULL,
1784 `dimension2_id` int(11) default NULL,
1785 `actual_cost` double NOT NULL default '0',
1786 `last_cost` double NOT NULL default '0',
1787 `material_cost` double NOT NULL default '0',
1788 `labour_cost` double NOT NULL default '0',
1789 `overhead_cost` double NOT NULL default '0',
1790 `inactive` tinyint(1) NOT NULL default '0',
1791 `no_sale` tinyint(1) NOT NULL default '0',
1792 `no_purchase` tinyint(1) NOT NULL default '0',
1793 `editable` tinyint(1) NOT NULL default '0',
1794 PRIMARY KEY (`stock_id`)
1798 -- Dumping data for table `0_stock_master`
1801 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, 0);
1802 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, 0);
1803 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, 0);
1804 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, 0);
1805 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, 0);
1807 -- --------------------------------------------------------
1810 -- Table structure for table `0_stock_moves`
1813 DROP TABLE IF EXISTS `0_stock_moves`;
1814 CREATE TABLE IF NOT EXISTS `0_stock_moves` (
1815 `trans_id` int(11) NOT NULL auto_increment,
1816 `trans_no` int(11) NOT NULL default '0',
1817 `stock_id` char(20) NOT NULL default '',
1818 `type` smallint(6) NOT NULL default '0',
1819 `loc_code` char(5) NOT NULL default '',
1820 `tran_date` date NOT NULL default '0000-00-00',
1821 `person_id` int(11) default NULL,
1822 `price` double NOT NULL default '0',
1823 `reference` char(40) NOT NULL default '',
1824 `qty` double NOT NULL default '1',
1825 `discount_percent` double NOT NULL default '0',
1826 `standard_cost` double NOT NULL default '0',
1827 `visible` tinyint(1) NOT NULL default '1',
1828 PRIMARY KEY (`trans_id`),
1829 KEY `type` (`type`,`trans_no`),
1830 KEY `Move` (`stock_id`,`loc_code`,`tran_date`)
1831 ) ENGINE=InnoDB AUTO_INCREMENT=37 ;
1834 -- Dumping data for table `0_stock_moves`
1837 INSERT INTO `0_stock_moves` VALUES(1, 1, '102', 25, 'DEF', '2009-06-21', 2, 10, '', 100, 0, 10, 1);
1838 INSERT INTO `0_stock_moves` VALUES(2, 1, '103', 25, 'DEF', '2009-06-21', 2, 11, '', 100, 0, 11, 1);
1839 INSERT INTO `0_stock_moves` VALUES(3, 1, '104', 25, 'DEF', '2009-06-21', 2, 12, '', 100, 0, 12, 1);
1840 INSERT INTO `0_stock_moves` VALUES(4, 1, '102', 26, 'DEF', '2009-06-21', 0, 0, '1', -10, 0, 0, 1);
1841 INSERT INTO `0_stock_moves` VALUES(5, 1, '103', 26, 'DEF', '2009-06-21', 0, 0, '1', -10, 0, 0, 1);
1842 INSERT INTO `0_stock_moves` VALUES(6, 1, '104', 26, 'DEF', '2009-06-21', 0, 0, '1', -10, 0, 0, 1);
1843 INSERT INTO `0_stock_moves` VALUES(7, 1, '3400', 26, 'DEF', '2009-06-21', 0, 0, '1', 10, 0, 0, 1);
1844 INSERT INTO `0_stock_moves` VALUES(8, 2, '102', 13, 'DEF', '2009-06-21', 0, 30.4, '1', -2, 0, 10, 1);
1845 INSERT INTO `0_stock_moves` VALUES(9, 3, '102', 13, 'DEF', '2009-06-21', 0, 50, 'auto', -1, 0, 10, 1);
1846 INSERT INTO `0_stock_moves` VALUES(10, 4, '102', 13, 'DEF', '2009-06-21', 0, 35.89, 'auto', -1, 0, 10, 1);
1847 INSERT INTO `0_stock_moves` VALUES(11, 3, '102', 26, 'DEF', '2009-06-21', 0, 0, '3', -2, 0, 0, 1);
1848 INSERT INTO `0_stock_moves` VALUES(12, 3, '103', 26, 'DEF', '2009-06-21', 0, 0, '3', -2, 0, 0, 1);
1849 INSERT INTO `0_stock_moves` VALUES(13, 3, '104', 26, 'DEF', '2009-06-21', 0, 0, '3', -2, 0, 0, 1);
1850 INSERT INTO `0_stock_moves` VALUES(14, 3, '3400', 26, 'DEF', '2009-06-21', 0, 0, '3', 2, 0, 0, 1);
1851 INSERT INTO `0_stock_moves` VALUES(15, 4, '102', 26, 'DEF', '2009-06-21', 0, 0, '4', -4, 0, 0, 1);
1852 INSERT INTO `0_stock_moves` VALUES(16, 4, '103', 26, 'DEF', '2009-06-21', 0, 0, '4', -4, 0, 0, 1);
1853 INSERT INTO `0_stock_moves` VALUES(17, 4, '104', 26, 'DEF', '2009-06-21', 0, 0, '4', -4, 0, 0, 1);
1854 INSERT INTO `0_stock_moves` VALUES(18, 4, '3400', 26, 'DEF', '2009-06-21', 0, 0, '4', 4, 0, 0, 1);
1855 INSERT INTO `0_stock_moves` VALUES(19, 2, '102', 26, 'DEF', '2009-06-21', 0, 0, '', -2, 0, 0, 1);
1856 INSERT INTO `0_stock_moves` VALUES(20, 2, '103', 26, 'DEF', '2009-06-21', 0, 0, '', -2, 0, 0, 1);
1857 INSERT INTO `0_stock_moves` VALUES(21, 2, '104', 26, 'DEF', '2009-06-21', 0, 0, '', -2, 0, 0, 1);
1858 INSERT INTO `0_stock_moves` VALUES(22, 1, '3400', 29, 'DEF', '2009-06-21', 0, 0, '', 2, 0, 0, 1);
1859 INSERT INTO `0_stock_moves` VALUES(23, 5, '102', 26, 'DEF', '2009-06-21', 0, 0, '5', -5, 0, 0, 1);
1860 INSERT INTO `0_stock_moves` VALUES(24, 5, '103', 26, 'DEF', '2009-06-21', 0, 0, '5', -5, 0, 0, 1);
1861 INSERT INTO `0_stock_moves` VALUES(25, 5, '104', 26, 'DEF', '2009-06-21', 0, 0, '5', -5, 0, 0, 1);
1862 INSERT INTO `0_stock_moves` VALUES(26, 5, '3400', 26, 'DEF', '2009-06-21', 0, 0, '5', 5, 0, 0, 1);
1863 INSERT INTO `0_stock_moves` VALUES(27, 6, '102', 26, 'DEF', '2009-06-21', 0, 0, '6', 5, 0, 0, 1);
1864 INSERT INTO `0_stock_moves` VALUES(28, 6, '103', 26, 'DEF', '2009-06-21', 0, 0, '6', 5, 0, 0, 1);
1865 INSERT INTO `0_stock_moves` VALUES(29, 6, '104', 26, 'DEF', '2009-06-21', 0, 0, '6', 5, 0, 0, 1);
1866 INSERT INTO `0_stock_moves` VALUES(30, 6, '3400', 26, 'DEF', '2009-06-21', 0, 0, '6', -5, 0, 0, 1);
1867 INSERT INTO `0_stock_moves` VALUES(31, 7, '102', 26, 'DEF', '2009-06-21', 0, 0, '7', 2, 0, 0, 1);
1868 INSERT INTO `0_stock_moves` VALUES(32, 7, '103', 26, 'DEF', '2009-06-21', 0, 0, '7', 2, 0, 0, 1);
1869 INSERT INTO `0_stock_moves` VALUES(33, 7, '104', 26, 'DEF', '2009-06-21', 0, 0, '7', 2, 0, 0, 1);
1870 INSERT INTO `0_stock_moves` VALUES(34, 7, '3400', 26, 'DEF', '2009-06-21', 0, 0, '7', -2, 0, 0, 1);
1871 INSERT INTO `0_stock_moves` VALUES(35, 5, '102', 13, 'DEF', '2009-06-21', 0, 50, 'auto', -1, 0, 10, 1);
1872 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);
1874 -- --------------------------------------------------------
1877 -- Table structure for table `0_suppliers`
1880 DROP TABLE IF EXISTS `0_suppliers`;
1881 CREATE TABLE IF NOT EXISTS `0_suppliers` (
1882 `supplier_id` int(11) NOT NULL auto_increment,
1883 `supp_name` varchar(60) NOT NULL default '',
1884 `supp_ref` varchar(30) NOT NULL default '',
1885 `address` tinytext NOT NULL,
1886 `supp_address` tinytext NOT NULL,
1887 `gst_no` varchar(25) NOT NULL default '',
1888 `contact` varchar(60) NOT NULL default '',
1889 `supp_account_no` varchar(40) NOT NULL default '',
1890 `website` varchar(100) NOT NULL default '',
1891 `bank_account` varchar(60) NOT NULL default '',
1892 `curr_code` char(3) default NULL,
1893 `payment_terms` int(11) default NULL,
1894 `tax_included` tinyint(1) NOT NULL default '0',
1895 `tax_algorithm` tinyint(1) NOT NULL default '1',
1896 `dimension_id` int(11) default '0',
1897 `dimension2_id` int(11) default '0',
1898 `tax_group_id` int(11) default NULL,
1899 `credit_limit` double NOT NULL default '0',
1900 `purchase_account` varchar(15) NOT NULL default '',
1901 `payable_account` varchar(15) NOT NULL default '',
1902 `payment_discount_account` varchar(15) NOT NULL default '',
1903 `notes` tinytext NOT NULL,
1904 `inactive` tinyint(1) NOT NULL default '0',
1905 PRIMARY KEY (`supplier_id`),
1906 KEY `supp_ref` (`supp_ref`)
1907 ) ENGINE=MyISAM AUTO_INCREMENT=4 ;
1910 -- Dumping data for table `0_suppliers`
1913 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);
1914 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);
1915 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);
1917 -- --------------------------------------------------------
1920 -- Table structure for table `0_supp_allocations`
1923 DROP TABLE IF EXISTS `0_supp_allocations`;
1924 CREATE TABLE IF NOT EXISTS `0_supp_allocations` (
1925 `id` int(11) NOT NULL auto_increment,
1926 `amt` double unsigned default NULL,
1927 `date_alloc` date NOT NULL default '0000-00-00',
1928 `trans_no_from` int(11) default NULL,
1929 `trans_type_from` int(11) default NULL,
1930 `trans_no_to` int(11) default NULL,
1931 `trans_type_to` int(11) default NULL,
1933 UNIQUE KEY (`trans_type_from`,`trans_no_from`,`trans_type_to`,`trans_no_to`),
1934 KEY `From` (`trans_type_from`,`trans_no_from`),
1935 KEY `To` (`trans_type_to`,`trans_no_to`)
1936 ) ENGINE=InnoDB AUTO_INCREMENT=2 ;
1939 -- Dumping data for table `0_supp_allocations`
1942 INSERT INTO `0_supp_allocations` VALUES(1, 3465, '2009-06-21', 4, 22, 7, 20);
1944 -- --------------------------------------------------------
1947 -- Table structure for table `0_supp_invoice_items`
1950 DROP TABLE IF EXISTS `0_supp_invoice_items`;
1951 CREATE TABLE IF NOT EXISTS `0_supp_invoice_items` (
1952 `id` int(11) NOT NULL auto_increment,
1953 `supp_trans_no` int(11) default NULL,
1954 `supp_trans_type` int(11) default NULL,
1955 `gl_code` varchar(15) NOT NULL default '',
1956 `grn_item_id` int(11) default NULL,
1957 `po_detail_item_id` int(11) default NULL,
1958 `stock_id` varchar(20) NOT NULL default '',
1959 `description` tinytext,
1960 `quantity` double NOT NULL default '0',
1961 `unit_price` double NOT NULL default '0',
1962 `unit_tax` double NOT NULL default '0',
1965 KEY `Transaction` (`supp_trans_type`,`supp_trans_no`,`stock_id`)
1966 ) ENGINE=InnoDB AUTO_INCREMENT=6 ;
1969 -- Dumping data for table `0_supp_invoice_items`
1972 INSERT INTO `0_supp_invoice_items` VALUES(1, 7, 20, '0', 1, 1, '102', '17inch VGA Monitor', 100, 10, 0.5, '');
1973 INSERT INTO `0_supp_invoice_items` VALUES(2, 7, 20, '0', 2, 2, '103', '32MB VGA Card', 100, 11, 0.55, '');
1974 INSERT INTO `0_supp_invoice_items` VALUES(3, 7, 20, '0', 3, 3, '104', '52x CD Drive', 100, 12, 0.6, '');
1975 INSERT INTO `0_supp_invoice_items` VALUES(4, 8, 20, '2150', 0, 0, '', '', 0, 0.95, 0, 'Phone');
1976 INSERT INTO `0_supp_invoice_items` VALUES(5, 8, 20, '5780', 0, 0, '', '', 0, 19.05, 0, 'Phone');
1978 -- --------------------------------------------------------
1981 -- Table structure for table `0_supp_trans`
1984 DROP TABLE IF EXISTS `0_supp_trans`;
1985 CREATE TABLE IF NOT EXISTS `0_supp_trans` (
1986 `trans_no` int(11) unsigned NOT NULL default '0',
1987 `type` smallint(6) unsigned NOT NULL default '0',
1988 `supplier_id` int(11) unsigned default NULL,
1989 `reference` tinytext NOT NULL,
1990 `supp_reference` varchar(60) NOT NULL default '',
1991 `tran_date` date NOT NULL default '0000-00-00',
1992 `due_date` date NOT NULL default '0000-00-00',
1993 `ov_amount` double NOT NULL default '0',
1994 `ov_discount` double NOT NULL default '0',
1995 `ov_gst` double NOT NULL default '0',
1996 `rate` double NOT NULL default '1',
1997 `alloc` double NOT NULL default '0',
1998 `tax_included` tinyint(1) NOT NULL default '0',
1999 `tax_algorithm` tinyint(1) NOT NULL default '1',
2000 PRIMARY KEY (`type`,`trans_no`),
2001 KEY `supplier_id` (`supplier_id`),
2002 KEY `SupplierID_2` (`supplier_id`,`supp_reference`),
2003 KEY `type` (`type`),
2004 KEY `tran_date` (`tran_date`)
2008 -- Dumping data for table `0_supp_trans`
2011 INSERT INTO `0_supp_trans` VALUES(7, 20, 2, '1', '5t', '2009-06-21', '2009-07-01', 3300, 0, 165, 1, 3465, 0, 1);
2012 INSERT INTO `0_supp_trans` VALUES(8, 20, 2, '2', 'cc', '2009-06-21', '2009-07-01', 20, 0, 0, 1, 0, 0, 1);
2013 INSERT INTO `0_supp_trans` VALUES(4, 22, 2, '1', '', '2009-06-21', '2009-06-21', -3465, 0, 0, 1, 3465, 0, 1);
2015 -- --------------------------------------------------------
2018 -- Table structure for table `0_sys_prefs`
2021 DROP TABLE IF EXISTS `0_sys_prefs`;
2022 CREATE TABLE IF NOT EXISTS `0_sys_prefs` (
2023 `name` varchar(35) NOT NULL default '',
2024 `category` varchar(30) default NULL,
2025 `type` varchar(20) NOT NULL default '',
2026 `length` smallint(6) default NULL,
2027 `value` text NOT NULL,
2028 PRIMARY KEY (`name`),
2029 KEY `category` (`category`)
2033 -- Dumping data for table `0_sys_prefs`
2036 INSERT INTO `0_sys_prefs` VALUES('coy_name', 'setup.company', 'varchar', 60, 'Training Co.');
2037 INSERT INTO `0_sys_prefs` VALUES('gst_no', 'setup.company', 'varchar', 25, '9876543');
2038 INSERT INTO `0_sys_prefs` VALUES('coy_no', 'setup.company', 'varchar', 25, '123456789');
2039 INSERT INTO `0_sys_prefs` VALUES('tax_prd', 'setup.company', 'int', 11, '1');
2040 INSERT INTO `0_sys_prefs` VALUES('tax_last', 'setup.company', 'int', 11, '1');
2041 INSERT INTO `0_sys_prefs` VALUES('postal_address', 'setup.company', 'tinytext', 0, 'Address 1\nAddress 2\nAddress 3');
2042 INSERT INTO `0_sys_prefs` VALUES('phone', 'setup.company', 'varchar', 30, '(222) 111.222.333');
2043 INSERT INTO `0_sys_prefs` VALUES('fax', 'setup.company', 'varchar', 30, '');
2044 INSERT INTO `0_sys_prefs` VALUES('email', 'setup.company', 'varchar', 100, 'delta@delta.com');
2045 INSERT INTO `0_sys_prefs` VALUES('coy_logo', 'setup.company', 'varchar', 100, 'logo_frontaccounting.jpg');
2046 INSERT INTO `0_sys_prefs` VALUES('domicile', 'setup.company', 'varchar', 55, '');
2047 INSERT INTO `0_sys_prefs` VALUES('curr_default', 'setup.company', 'char', 3, 'USD');
2048 INSERT INTO `0_sys_prefs` VALUES('use_dimension', 'setup.company', 'tinyint', 1, '1');
2049 INSERT INTO `0_sys_prefs` VALUES('f_year', 'setup.company', 'int', 11, '3');
2050 INSERT INTO `0_sys_prefs` VALUES('no_item_list', 'setup.company', 'tinyint', 1, '0');
2051 INSERT INTO `0_sys_prefs` VALUES('no_customer_list', 'setup.company', 'tinyint', 1, '0');
2052 INSERT INTO `0_sys_prefs` VALUES('no_supplier_list', 'setup.company', 'tinyint', 1, '0');
2053 INSERT INTO `0_sys_prefs` VALUES('base_sales', 'setup.company', 'int', 11, '1');
2054 INSERT INTO `0_sys_prefs` VALUES('time_zone', 'setup.company', 'tinyint', 1, '0');
2055 INSERT INTO `0_sys_prefs` VALUES('add_pct', 'setup.company', 'int', 5, '-1');
2056 INSERT INTO `0_sys_prefs` VALUES('round_to', 'setup.company', 'int', 5, '1');
2057 INSERT INTO `0_sys_prefs` VALUES('login_tout', 'setup.company', 'smallint', 6, '600');
2058 INSERT INTO `0_sys_prefs` VALUES('past_due_days', 'glsetup.general', 'int', 11, '30');
2059 INSERT INTO `0_sys_prefs` VALUES('profit_loss_year_act', 'glsetup.general', 'varchar', 15, '9990');
2060 INSERT INTO `0_sys_prefs` VALUES('retained_earnings_act', 'glsetup.general', 'varchar', 15, '3590');
2061 INSERT INTO `0_sys_prefs` VALUES('bank_charge_act', 'glsetup.general', 'varchar', 15, '5690');
2062 INSERT INTO `0_sys_prefs` VALUES('exchange_diff_act', 'glsetup.general', 'varchar', 15, '4450');
2063 INSERT INTO `0_sys_prefs` VALUES('tax_algorithm', 'glsetup.customer', 'tinyint', 1, '1');
2064 INSERT INTO `0_sys_prefs` VALUES('default_credit_limit', 'glsetup.customer', 'int', 11, '1000');
2065 INSERT INTO `0_sys_prefs` VALUES('accumulate_shipping', 'glsetup.customer', 'tinyint', 1, '0');
2066 INSERT INTO `0_sys_prefs` VALUES('legal_text', 'glsetup.customer', 'tinytext', 0, '');
2067 INSERT INTO `0_sys_prefs` VALUES('freight_act', 'glsetup.customer', 'varchar', 15, '4430');
2068 INSERT INTO `0_sys_prefs` VALUES('debtors_act', 'glsetup.sales', 'varchar', 15, '1200');
2069 INSERT INTO `0_sys_prefs` VALUES('default_sales_act', 'glsetup.sales', 'varchar', 15, '4010');
2070 INSERT INTO `0_sys_prefs` VALUES('default_sales_discount_act', 'glsetup.sales', 'varchar', 15, '4510');
2071 INSERT INTO `0_sys_prefs` VALUES('default_prompt_payment_act', 'glsetup.sales', 'varchar', 15, '4500');
2072 INSERT INTO `0_sys_prefs` VALUES('default_delivery_required', 'glsetup.sales', 'smallint', 6, '1');
2073 INSERT INTO `0_sys_prefs` VALUES('default_receival_required', 'glsetup.purchase', 'smallint', 6, '10');
2074 INSERT INTO `0_sys_prefs` VALUES('default_dim_required', 'glsetup.dims', 'int', 11, '20');
2075 INSERT INTO `0_sys_prefs` VALUES('pyt_discount_act', 'glsetup.purchase', 'varchar', 15, '5060');
2076 INSERT INTO `0_sys_prefs` VALUES('creditors_act', 'glsetup.purchase', 'varchar', 15, '2100');
2077 INSERT INTO `0_sys_prefs` VALUES('po_over_receive', 'glsetup.purchase', 'int', 11, '10');
2078 INSERT INTO `0_sys_prefs` VALUES('po_over_charge', 'glsetup.purchase', 'int', 11, '10');
2079 INSERT INTO `0_sys_prefs` VALUES('allow_negative_stock', 'glsetup.inventory', 'tinyint', 1, '0');
2080 INSERT INTO `0_sys_prefs` VALUES('default_inventory_act', 'glsetup.items', 'varchar', 15, '1510');
2081 INSERT INTO `0_sys_prefs` VALUES('default_cogs_act', 'glsetup.items', 'varchar', 15, '5010');
2082 INSERT INTO `0_sys_prefs` VALUES('default_adj_act', 'glsetup.items', 'varchar', 15, '5040');
2083 INSERT INTO `0_sys_prefs` VALUES('default_inv_sales_act', 'glsetup.items', 'varchar', 15, '4010');
2084 INSERT INTO `0_sys_prefs` VALUES('default_assembly_act', 'glsetup.items', 'varchar', 15, '1530');
2085 INSERT INTO `0_sys_prefs` VALUES('default_workorder_required', 'glsetup.manuf', 'int', 11, '20');
2086 INSERT INTO `0_sys_prefs` VALUES('version_id', 'system', 'varchar', 11, '2.3rc');
2087 INSERT INTO `0_sys_prefs` VALUES('auto_curr_reval', 'setup.company', 'smallint', 6, '1');
2088 INSERT INTO `0_sys_prefs` VALUES('grn_clearing_act', 'glsetup.purchase', 'varchar', 15, '1550');
2089 INSERT INTO `0_sys_prefs` VALUES('deferred_income_act', 'glsetup.sales', 'varchar', '15', '');
2090 INSERT INTO `0_sys_prefs` VALUES('gl_closing_date','setup.closing_date', 'date', 8, '');
2092 -- --------------------------------------------------------
2095 -- Table structure for table `0_sys_types`
2098 DROP TABLE IF EXISTS `0_sys_types`;
2099 CREATE TABLE IF NOT EXISTS `0_sys_types` (
2100 `type_id` smallint(6) NOT NULL default '0',
2101 `type_no` int(11) NOT NULL default '1',
2102 `next_reference` varchar(100) NOT NULL default '',
2103 PRIMARY KEY (`type_id`)
2107 -- Dumping data for table `0_sys_types`
2110 INSERT INTO `0_sys_types` VALUES(0, 19, '3');
2111 INSERT INTO `0_sys_types` VALUES(1, 8, '2');
2112 INSERT INTO `0_sys_types` VALUES(2, 5, '2');
2113 INSERT INTO `0_sys_types` VALUES(4, 3, '1');
2114 INSERT INTO `0_sys_types` VALUES(10, 19, '4');
2115 INSERT INTO `0_sys_types` VALUES(11, 3, '2');
2116 INSERT INTO `0_sys_types` VALUES(12, 6, '1');
2117 INSERT INTO `0_sys_types` VALUES(13, 5, '2');
2118 INSERT INTO `0_sys_types` VALUES(16, 2, '1');
2119 INSERT INTO `0_sys_types` VALUES(17, 2, '1');
2120 INSERT INTO `0_sys_types` VALUES(18, 1, '3');
2121 INSERT INTO `0_sys_types` VALUES(20, 8, '3');
2122 INSERT INTO `0_sys_types` VALUES(21, 1, '1');
2123 INSERT INTO `0_sys_types` VALUES(22, 4, '2');
2124 INSERT INTO `0_sys_types` VALUES(25, 1, '2');
2125 INSERT INTO `0_sys_types` VALUES(26, 1, '8');
2126 INSERT INTO `0_sys_types` VALUES(28, 1, '1');
2127 INSERT INTO `0_sys_types` VALUES(29, 1, '2');
2128 INSERT INTO `0_sys_types` VALUES(30, 5, '6');
2129 INSERT INTO `0_sys_types` VALUES(32, 0, '1');
2130 INSERT INTO `0_sys_types` VALUES(35, 1, '1');
2131 INSERT INTO `0_sys_types` VALUES(40, 1, '3');
2133 -- --------------------------------------------------------
2136 -- Table structure for table `0_tags`
2139 DROP TABLE IF EXISTS `0_tags`;
2140 CREATE TABLE IF NOT EXISTS `0_tags` (
2141 `id` int(11) NOT NULL auto_increment,
2142 `type` smallint(6) NOT NULL,
2143 `name` varchar(30) NOT NULL,
2144 `description` varchar(60) default NULL,
2145 `inactive` tinyint(1) NOT NULL default '0',
2147 UNIQUE KEY `type` (`type`,`name`)
2148 ) ENGINE=MyISAM AUTO_INCREMENT=1 ;
2151 -- Dumping data for table `0_tags`
2155 -- --------------------------------------------------------
2158 -- Table structure for table `0_tag_associations`
2161 DROP TABLE IF EXISTS `0_tag_associations`;
2162 CREATE TABLE IF NOT EXISTS `0_tag_associations` (
2163 `record_id` varchar(15) NOT NULL,
2164 `tag_id` int(11) NOT NULL,
2165 UNIQUE KEY `record_id` (`record_id`,`tag_id`)
2169 -- Dumping data for table `0_tag_associations`
2173 -- --------------------------------------------------------
2176 -- Table structure for table `0_tax_groups`
2179 DROP TABLE IF EXISTS `0_tax_groups`;
2180 CREATE TABLE IF NOT EXISTS `0_tax_groups` (
2181 `id` int(11) NOT NULL auto_increment,
2182 `name` varchar(60) NOT NULL default '',
2183 `inactive` tinyint(1) NOT NULL default '0',
2185 UNIQUE KEY `name` (`name`)
2186 ) ENGINE=InnoDB AUTO_INCREMENT=3 ;
2189 -- Dumping data for table `0_tax_groups`
2192 INSERT INTO `0_tax_groups` VALUES(1, 'Tax', 0);
2193 INSERT INTO `0_tax_groups` VALUES(2, 'Tax Exempt', 0);
2195 -- --------------------------------------------------------
2198 -- Table structure for table `0_tax_group_items`
2201 DROP TABLE IF EXISTS `0_tax_group_items`;
2202 CREATE TABLE IF NOT EXISTS `0_tax_group_items` (
2203 `tax_group_id` int(11) NOT NULL default '0',
2204 `tax_type_id` int(11) NOT NULL default '0',
2205 `tax_shipping` tinyint(1) NOT NULL default '0',
2206 PRIMARY KEY (`tax_group_id`,`tax_type_id`)
2210 -- Dumping data for table `0_tax_group_items`
2213 INSERT INTO `0_tax_group_items` VALUES(1, 1, 1);
2215 -- --------------------------------------------------------
2218 -- Table structure for table `0_tax_types`
2221 DROP TABLE IF EXISTS `0_tax_types`;
2222 CREATE TABLE IF NOT EXISTS `0_tax_types` (
2223 `id` int(11) NOT NULL auto_increment,
2224 `rate` double NOT NULL default '0',
2225 `sales_gl_code` varchar(15) NOT NULL default '',
2226 `purchasing_gl_code` varchar(15) NOT NULL default '',
2227 `name` varchar(60) NOT NULL default '',
2228 `inactive` tinyint(1) NOT NULL default '0',
2230 ) ENGINE=InnoDB AUTO_INCREMENT=2 ;
2233 -- Dumping data for table `0_tax_types`
2236 INSERT INTO `0_tax_types` VALUES(1, 5, '2150', '2150', 'Tax', 0);
2238 -- --------------------------------------------------------
2241 -- Table structure for table `0_trans_tax_details`
2244 DROP TABLE IF EXISTS `0_trans_tax_details`;
2245 CREATE TABLE IF NOT EXISTS `0_trans_tax_details` (
2246 `id` int(11) NOT NULL auto_increment,
2247 `trans_type` smallint(6) default NULL,
2248 `trans_no` int(11) default NULL,
2249 `tran_date` date NOT NULL,
2250 `tax_type_id` int(11) NOT NULL default '0',
2251 `rate` double NOT NULL default '0',
2252 `ex_rate` double NOT NULL default '1',
2253 `included_in_price` tinyint(1) NOT NULL default '0',
2254 `net_amount` double NOT NULL default '0',
2255 `amount` double NOT NULL default '0',
2258 KEY `Type_and_Number` (`trans_type`,`trans_no`),
2259 KEY `tran_date` (`tran_date`)
2260 ) ENGINE=InnoDB AUTO_INCREMENT=12 ;
2263 -- Dumping data for table `0_trans_tax_details`
2266 INSERT INTO `0_trans_tax_details` VALUES(1, 20, 7, '2009-06-21', 1, 5, 1, 0, 3300, 165, '5t');
2267 INSERT INTO `0_trans_tax_details` VALUES(2, 13, 3, '2009-06-21', 1, 5, 1, 0, 50, 2.5, 'auto');
2268 INSERT INTO `0_trans_tax_details` VALUES(3, 10, 17, '2009-06-21', 1, 5, 1, 0, 50, 2.5, '1');
2269 INSERT INTO `0_trans_tax_details` VALUES(4, 13, 4, '2009-06-21', 1, 5, 1.3932, 0, 35.89, 1.7945, 'auto');
2270 INSERT INTO `0_trans_tax_details` VALUES(5, 10, 18, '2009-06-21', 1, 5, 1.3932, 0, 35.89, 1.7945, '2');
2271 INSERT INTO `0_trans_tax_details` VALUES(6, 2, 5, '2009-06-21', 1, 5, 1, 0, 95.2, 4.76, '');
2272 INSERT INTO `0_trans_tax_details` VALUES(7, 1, 8, '2009-06-21', 1, 5, 1, 0, -47.6, -2.38, '');
2273 INSERT INTO `0_trans_tax_details` VALUES(8, 20, 8, '2009-06-21', 1, 5, 1, 0, -19, -0.95, 'cc');
2274 INSERT INTO `0_trans_tax_details` VALUES(9, 13, 5, '2009-06-21', 1, 5, 1, 1, 47.619047619048, 2.3809523809524, 'auto');
2275 INSERT INTO `0_trans_tax_details` VALUES(10, 10, 19, '2009-06-21', 1, 5, 1, 1, 47.619047619048, 2.3809523809524, '3');
2276 INSERT INTO `0_trans_tax_details` VALUES(11, 11, 3, '2009-06-21', 1, 5, 1.3932, 0, 35.89, 1.7945, '1');
2278 -- --------------------------------------------------------
2281 -- Table structure for table `0_useronline`
2284 DROP TABLE IF EXISTS `0_useronline`;
2285 CREATE TABLE IF NOT EXISTS `0_useronline` (
2286 `id` int(11) NOT NULL auto_increment,
2287 `timestamp` int(15) NOT NULL default '0',
2288 `ip` varchar(40) NOT NULL default '',
2289 `file` varchar(100) NOT NULL default '',
2291 KEY `timestamp` (`timestamp`),
2293 ) ENGINE=MyISAM AUTO_INCREMENT=1 ;
2296 -- Dumping data for table `0_useronline`
2300 -- --------------------------------------------------------
2303 -- Table structure for table `0_users`
2306 DROP TABLE IF EXISTS `0_users`;
2307 CREATE TABLE IF NOT EXISTS `0_users` (
2308 `id` smallint(6) NOT NULL auto_increment,
2309 `user_id` varchar(60) NOT NULL default '',
2310 `password` varchar(100) NOT NULL default '',
2311 `real_name` varchar(100) NOT NULL default '',
2312 `role_id` int(11) NOT NULL default '1',
2313 `phone` varchar(30) NOT NULL default '',
2314 `email` varchar(100) default NULL,
2315 `language` varchar(20) default NULL,
2316 `date_format` tinyint(1) NOT NULL default '0',
2317 `date_sep` tinyint(1) NOT NULL default '0',
2318 `tho_sep` tinyint(1) NOT NULL default '0',
2319 `dec_sep` tinyint(1) NOT NULL default '0',
2320 `theme` varchar(20) NOT NULL default 'default',
2321 `page_size` varchar(20) NOT NULL default 'A4',
2322 `prices_dec` smallint(6) NOT NULL default '2',
2323 `qty_dec` smallint(6) NOT NULL default '2',
2324 `rates_dec` smallint(6) NOT NULL default '4',
2325 `percent_dec` smallint(6) NOT NULL default '1',
2326 `show_gl` tinyint(1) NOT NULL default '1',
2327 `show_codes` tinyint(1) NOT NULL default '0',
2328 `show_hints` tinyint(1) NOT NULL default '0',
2329 `last_visit_date` datetime default NULL,
2330 `query_size` tinyint(1) default '10',
2331 `graphic_links` tinyint(1) default '1',
2332 `pos` smallint(6) default '1',
2333 `print_profile` varchar(30) NOT NULL default '1',
2334 `rep_popup` tinyint(1) default '1',
2335 `sticky_doc_date` tinyint(1) default '0',
2336 `startup_tab` varchar(20) NOT NULL default '',
2337 `transaction_days` smallint(6) NOT NULL default '30',
2338 `inactive` tinyint(1) NOT NULL default '0',
2340 UNIQUE KEY `user_id` (`user_id`)
2341 ) ENGINE=MyISAM AUTO_INCREMENT=3 ;
2344 -- Dumping data for table `0_users`
2347 INSERT INTO `0_users` VALUES(1, 'admin', '5f4dcc3b5aa765d61d8327deb882cf99', 'Administrator', 2, '', 'adm@adm.com', 'en_US', 0, 0, 0, 0, 'default', 'Letter', 2, 2, 4, 1, 1, 0, 0, '2010-05-11 23:27:46', 10, 1, 1, '1', 1, 0, 'orders', 30, 0);
2348 INSERT INTO `0_users` VALUES(2, 'demouser', '5f4dcc3b5aa765d61d8327deb882cf99', 'Demo User', 9, '999-999-999', 'demo@demo.nu', 'en_US', 0, 0, 0, 0, 'default', 'Letter', 2, 2, 3, 1, 1, 0, 0, '2008-02-06 19:02:35', 10, 1, 1, '1', 1, 0, 'orders', 30, 0);
2350 -- --------------------------------------------------------
2353 -- Table structure for table `0_voided`
2356 DROP TABLE IF EXISTS `0_voided`;
2357 CREATE TABLE IF NOT EXISTS `0_voided` (
2358 `type` int(11) NOT NULL default '0',
2359 `id` int(11) NOT NULL default '0',
2360 `date_` date NOT NULL default '0000-00-00',
2361 `memo_` tinytext NOT NULL,
2362 UNIQUE KEY `id` (`type`,`id`)
2366 -- Dumping data for table `0_voided`
2370 -- --------------------------------------------------------
2373 -- Table structure for table `0_workcentres`
2376 DROP TABLE IF EXISTS `0_workcentres`;
2377 CREATE TABLE IF NOT EXISTS `0_workcentres` (
2378 `id` int(11) NOT NULL auto_increment,
2379 `name` char(40) NOT NULL default '',
2380 `description` char(50) NOT NULL default '',
2381 `inactive` tinyint(1) NOT NULL default '0',
2383 UNIQUE KEY `name` (`name`)
2384 ) ENGINE=MyISAM AUTO_INCREMENT=2 ;
2387 -- Dumping data for table `0_workcentres`
2390 INSERT INTO `0_workcentres` VALUES(1, 'Workshop', 'Workshop in Alabama', 0);
2392 -- --------------------------------------------------------
2395 -- Table structure for table `0_workorders`
2398 DROP TABLE IF EXISTS `0_workorders`;
2399 CREATE TABLE IF NOT EXISTS `0_workorders` (
2400 `id` int(11) NOT NULL auto_increment,
2401 `wo_ref` varchar(60) NOT NULL default '',
2402 `loc_code` varchar(5) NOT NULL default '',
2403 `units_reqd` double NOT NULL default '1',
2404 `stock_id` varchar(20) NOT NULL default '',
2405 `date_` date NOT NULL default '0000-00-00',
2406 `type` tinyint(4) NOT NULL default '0',
2407 `required_by` date NOT NULL default '0000-00-00',
2408 `released_date` date NOT NULL default '0000-00-00',
2409 `units_issued` double NOT NULL default '0',
2410 `closed` tinyint(1) NOT NULL default '0',
2411 `released` tinyint(1) NOT NULL default '0',
2412 `additional_costs` double NOT NULL default '0',
2414 UNIQUE KEY `wo_ref` (`wo_ref`)
2415 ) ENGINE=InnoDB AUTO_INCREMENT=8 ;
2418 -- Dumping data for table `0_workorders`
2421 INSERT INTO `0_workorders` VALUES(1, '1', 'DEF', 10, '3400', '2009-06-21', 0, '2009-06-21', '2009-06-21', 10, 1, 1, 10);
2422 INSERT INTO `0_workorders` VALUES(2, '2', 'DEF', 3, '3400', '2009-06-21', 2, '2009-07-11', '2009-06-21', 2, 0, 1, 0);
2423 INSERT INTO `0_workorders` VALUES(3, '3', 'DEF', 2, '3400', '2009-06-21', 0, '2009-06-21', '2009-06-21', 2, 1, 1, 0);
2424 INSERT INTO `0_workorders` VALUES(4, '4', 'DEF', 4, '3400', '2009-06-21', 0, '2009-06-21', '2009-06-21', 4, 1, 1, 0);
2425 INSERT INTO `0_workorders` VALUES(5, '5', 'DEF', 5, '3400', '2009-06-21', 0, '2009-06-21', '2009-06-21', 5, 1, 1, 10);
2426 INSERT INTO `0_workorders` VALUES(6, '6', 'DEF', -5, '3400', '2009-06-21', 1, '2009-06-21', '2009-06-21', -5, 1, 1, 0);
2427 INSERT INTO `0_workorders` VALUES(7, '7', 'DEF', -2, '3400', '2009-06-21', 1, '2009-06-21', '2009-06-21', -2, 1, 1, 10);
2429 -- --------------------------------------------------------
2432 -- Table structure for table `0_wo_costing`
2435 DROP TABLE IF EXISTS `0_wo_costing`;
2436 CREATE TABLE `0_wo_costing` (
2437 `id` int(11) NOT NULL auto_increment,
2438 `workorder_id` int(11) NOT NULL default '0',
2439 `cost_type` tinyint(1) NOT NULL default '0',
2440 `trans_type` int(11) NOT NULL default '0',
2441 `trans_no` int(11) NOT NULL default '0',
2442 `factor` double NOT NULL default '1',
2447 -- Dumping data for table `0_wo_costing`
2451 -- --------------------------------------------------------
2454 -- Table structure for table `0_wo_issues`
2457 DROP TABLE IF EXISTS `0_wo_issues`;
2458 CREATE TABLE IF NOT EXISTS `0_wo_issues` (
2459 `issue_no` int(11) NOT NULL auto_increment,
2460 `workorder_id` int(11) NOT NULL default '0',
2461 `reference` varchar(100) default NULL,
2462 `issue_date` date default NULL,
2463 `loc_code` varchar(5) default NULL,
2464 `workcentre_id` int(11) default NULL,
2465 PRIMARY KEY (`issue_no`),
2466 KEY `workorder_id` (`workorder_id`)
2467 ) ENGINE=InnoDB AUTO_INCREMENT=1 ;
2470 -- Dumping data for table `0_wo_issues`
2474 -- --------------------------------------------------------
2477 -- Table structure for table `0_wo_issue_items`
2480 DROP TABLE IF EXISTS `0_wo_issue_items`;
2481 CREATE TABLE IF NOT EXISTS `0_wo_issue_items` (
2482 `id` int(11) NOT NULL auto_increment,
2483 `stock_id` varchar(40) default NULL,
2484 `issue_id` int(11) default NULL,
2485 `qty_issued` double default NULL,
2487 ) ENGINE=InnoDB AUTO_INCREMENT=1 ;
2490 -- Dumping data for table `0_wo_issue_items`
2494 -- --------------------------------------------------------
2497 -- Table structure for table `0_wo_manufacture`
2500 DROP TABLE IF EXISTS `0_wo_manufacture`;
2501 CREATE TABLE IF NOT EXISTS `0_wo_manufacture` (
2502 `id` int(11) NOT NULL auto_increment,
2503 `reference` varchar(100) default NULL,
2504 `workorder_id` int(11) NOT NULL default '0',
2505 `quantity` double NOT NULL default '0',
2506 `date_` date NOT NULL default '0000-00-00',
2508 KEY `workorder_id` (`workorder_id`)
2509 ) ENGINE=InnoDB AUTO_INCREMENT=2 ;
2512 -- Dumping data for table `0_wo_manufacture`
2515 INSERT INTO `0_wo_manufacture` VALUES(1, '1', 2, 2, '2009-06-21');
2517 -- --------------------------------------------------------
2520 -- Table structure for table `0_wo_requirements`
2523 DROP TABLE IF EXISTS `0_wo_requirements`;
2524 CREATE TABLE IF NOT EXISTS `0_wo_requirements` (
2525 `id` int(11) NOT NULL auto_increment,
2526 `workorder_id` int(11) NOT NULL default '0',
2527 `stock_id` char(20) NOT NULL default '',
2528 `workcentre` int(11) NOT NULL default '0',
2529 `units_req` double NOT NULL default '1',
2530 `std_cost` double NOT NULL default '0',
2531 `loc_code` char(5) NOT NULL default '',
2532 `units_issued` double NOT NULL default '0',
2534 KEY `workorder_id` (`workorder_id`)
2535 ) ENGINE=InnoDB AUTO_INCREMENT=22 ;
2538 -- Dumping data for table `0_wo_requirements`
2541 INSERT INTO `0_wo_requirements` VALUES(1, 1, '102', 1, 1, 0, 'DEF', 10);
2542 INSERT INTO `0_wo_requirements` VALUES(2, 1, '103', 1, 1, 0, 'DEF', 10);
2543 INSERT INTO `0_wo_requirements` VALUES(3, 1, '104', 1, 1, 0, 'DEF', 10);
2544 INSERT INTO `0_wo_requirements` VALUES(4, 2, '102', 1, 1, 0, 'DEF', 0);
2545 INSERT INTO `0_wo_requirements` VALUES(5, 2, '103', 1, 1, 0, 'DEF', 0);
2546 INSERT INTO `0_wo_requirements` VALUES(6, 2, '104', 1, 1, 0, 'DEF', 0);
2547 INSERT INTO `0_wo_requirements` VALUES(7, 3, '102', 1, 1, 0, 'DEF', 2);
2548 INSERT INTO `0_wo_requirements` VALUES(8, 3, '103', 1, 1, 0, 'DEF', 2);
2549 INSERT INTO `0_wo_requirements` VALUES(9, 3, '104', 1, 1, 0, 'DEF', 2);
2550 INSERT INTO `0_wo_requirements` VALUES(10, 4, '102', 1, 1, 0, 'DEF', 4);
2551 INSERT INTO `0_wo_requirements` VALUES(11, 4, '103', 1, 1, 0, 'DEF', 4);
2552 INSERT INTO `0_wo_requirements` VALUES(12, 4, '104', 1, 1, 0, 'DEF', 4);
2553 INSERT INTO `0_wo_requirements` VALUES(13, 5, '102', 1, 1, 0, 'DEF', 5);
2554 INSERT INTO `0_wo_requirements` VALUES(14, 5, '103', 1, 1, 0, 'DEF', 5);
2555 INSERT INTO `0_wo_requirements` VALUES(15, 5, '104', 1, 1, 0, 'DEF', 5);
2556 INSERT INTO `0_wo_requirements` VALUES(16, 6, '102', 1, 1, 0, 'DEF', -5);
2557 INSERT INTO `0_wo_requirements` VALUES(17, 6, '103', 1, 1, 0, 'DEF', -5);
2558 INSERT INTO `0_wo_requirements` VALUES(18, 6, '104', 1, 1, 0, 'DEF', -5);
2559 INSERT INTO `0_wo_requirements` VALUES(19, 7, '102', 1, 1, 0, 'DEF', -2);
2560 INSERT INTO `0_wo_requirements` VALUES(20, 7, '103', 1, 1, 0, 'DEF', -2);
2561 INSERT INTO `0_wo_requirements` VALUES(21, 7, '104', 1, 1, 0, 'DEF', -2);