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 `id` int(11) NOT NULL auto_increment,
204 `tran_date` date NOT NULL default '0000-00-00',
205 `account` varchar(15) NOT NULL default '',
206 `memo_` tinytext NOT NULL,
207 `amount` double NOT NULL default '0',
208 `dimension_id` int(11) default '0',
209 `dimension2_id` int(11) default '0',
211 KEY `Account` (`account`,`tran_date`,`dimension_id`,`dimension2_id`)
212 ) ENGINE=InnoDB AUTO_INCREMENT=1 ;
215 -- Dumping data for table `0_budget_trans`
219 -- --------------------------------------------------------
222 -- Table structure for table `0_chart_class`
225 DROP TABLE IF EXISTS `0_chart_class`;
226 CREATE TABLE IF NOT EXISTS `0_chart_class` (
227 `cid` varchar(3) NOT NULL,
228 `class_name` varchar(60) NOT NULL default '',
229 `ctype` tinyint(1) NOT NULL default '0',
230 `inactive` tinyint(1) NOT NULL default '0',
235 -- Dumping data for table `0_chart_class`
238 INSERT INTO `0_chart_class` VALUES('1', 'Assets', 1, 0);
239 INSERT INTO `0_chart_class` VALUES('2', 'Liabilities', 2, 0);
240 INSERT INTO `0_chart_class` VALUES('3', 'Income', 4, 0);
241 INSERT INTO `0_chart_class` VALUES('4', 'Costs', 6, 0);
243 -- --------------------------------------------------------
246 -- Table structure for table `0_chart_master`
249 DROP TABLE IF EXISTS `0_chart_master`;
250 CREATE TABLE IF NOT EXISTS `0_chart_master` (
251 `account_code` varchar(15) NOT NULL default '',
252 `account_code2` varchar(15) NOT NULL default '',
253 `account_name` varchar(60) NOT NULL default '',
254 `account_type` varchar(10) NOT NULL default '0',
255 `inactive` tinyint(1) NOT NULL default '0',
256 PRIMARY KEY (`account_code`),
257 KEY `account_name` (`account_name`),
258 KEY `accounts_by_type` (`account_type`,`account_code`)
262 -- Dumping data for table `0_chart_master`
265 INSERT INTO `0_chart_master` VALUES('1060', '', 'Checking Account', '1', 0);
266 INSERT INTO `0_chart_master` VALUES('1065', '', 'Petty Cash', '1', 0);
267 INSERT INTO `0_chart_master` VALUES('1200', '', 'Accounts Receivables', '1', 0);
268 INSERT INTO `0_chart_master` VALUES('1205', '', 'Allowance for doubtful accounts', '1', 0);
269 INSERT INTO `0_chart_master` VALUES('1510', '', 'Inventory', '2', 0);
270 INSERT INTO `0_chart_master` VALUES('1520', '', 'Stocks of Raw Materials', '2', 0);
271 INSERT INTO `0_chart_master` VALUES('1530', '', 'Stocks of Work In Progress', '2', 0);
272 INSERT INTO `0_chart_master` VALUES('1540', '', 'Stocks of Finsihed Goods', '2', 0);
273 INSERT INTO `0_chart_master` VALUES('1550', '', 'Goods Received Clearing account', '2', 0);
274 INSERT INTO `0_chart_master` VALUES('1820', '', 'Office Furniture & Equipment', '3', 0);
275 INSERT INTO `0_chart_master` VALUES('1825', '', 'Accum. Amort. -Furn. & Equip.', '3', 0);
276 INSERT INTO `0_chart_master` VALUES('1840', '', 'Vehicle', '3', 0);
277 INSERT INTO `0_chart_master` VALUES('1845', '', 'Accum. Amort. -Vehicle', '3', 0);
278 INSERT INTO `0_chart_master` VALUES('2100', '', 'Accounts Payable', '4', 0);
279 INSERT INTO `0_chart_master` VALUES('2110', '', 'Accrued Income Tax - Federal', '4', 0);
280 INSERT INTO `0_chart_master` VALUES('2120', '', 'Accrued Income Tax - State', '4', 0);
281 INSERT INTO `0_chart_master` VALUES('2130', '', 'Accrued Franchise Tax', '4', 0);
282 INSERT INTO `0_chart_master` VALUES('2140', '', 'Accrued Real & Personal Prop Tax', '4', 0);
283 INSERT INTO `0_chart_master` VALUES('2150', '', 'Sales Tax', '4', 0);
284 INSERT INTO `0_chart_master` VALUES('2160', '', 'Accrued Use Tax Payable', '4', 0);
285 INSERT INTO `0_chart_master` VALUES('2210', '', 'Accrued Wages', '4', 0);
286 INSERT INTO `0_chart_master` VALUES('2220', '', 'Accrued Comp Time', '4', 0);
287 INSERT INTO `0_chart_master` VALUES('2230', '', 'Accrued Holiday Pay', '4', 0);
288 INSERT INTO `0_chart_master` VALUES('2240', '', 'Accrued Vacation Pay', '4', 0);
289 INSERT INTO `0_chart_master` VALUES('2310', '', 'Accr. Benefits - 401K', '4', 0);
290 INSERT INTO `0_chart_master` VALUES('2320', '', 'Accr. Benefits - Stock Purchase', '4', 0);
291 INSERT INTO `0_chart_master` VALUES('2330', '', 'Accr. Benefits - Med, Den', '4', 0);
292 INSERT INTO `0_chart_master` VALUES('2340', '', 'Accr. Benefits - Payroll Taxes', '4', 0);
293 INSERT INTO `0_chart_master` VALUES('2350', '', 'Accr. Benefits - Credit Union', '4', 0);
294 INSERT INTO `0_chart_master` VALUES('2360', '', 'Accr. Benefits - Savings Bond', '4', 0);
295 INSERT INTO `0_chart_master` VALUES('2370', '', 'Accr. Benefits - Garnish', '4', 0);
296 INSERT INTO `0_chart_master` VALUES('2380', '', 'Accr. Benefits - Charity Cont.', '4', 0);
297 INSERT INTO `0_chart_master` VALUES('2620', '', 'Bank Loans', '5', 0);
298 INSERT INTO `0_chart_master` VALUES('2680', '', 'Loans from Shareholders', '5', 0);
299 INSERT INTO `0_chart_master` VALUES('3350', '', 'Common Shares', '6', 0);
300 INSERT INTO `0_chart_master` VALUES('3590', '', 'Retained Earnings - prior years', '7', 0);
301 INSERT INTO `0_chart_master` VALUES('4010', '', 'Sales', '8', 0);
302 INSERT INTO `0_chart_master` VALUES('4430', '', 'Shipping & Handling', '9', 0);
303 INSERT INTO `0_chart_master` VALUES('4440', '', 'Interest', '9', 0);
304 INSERT INTO `0_chart_master` VALUES('4450', '', 'Foreign Exchange Gain', '9', 0);
305 INSERT INTO `0_chart_master` VALUES('4500', '', 'Prompt Payment Discounts', '9', 0);
306 INSERT INTO `0_chart_master` VALUES('4510', '', 'Discounts Given', '9', 0);
307 INSERT INTO `0_chart_master` VALUES('5010', '', 'Cost of Goods Sold - Retail', '10', 0);
308 INSERT INTO `0_chart_master` VALUES('5020', '', 'Material Usage Varaiance', '10', 0);
309 INSERT INTO `0_chart_master` VALUES('5030', '', 'Consumable Materials', '10', 0);
310 INSERT INTO `0_chart_master` VALUES('5040', '', 'Purchase price Variance', '10', 0);
311 INSERT INTO `0_chart_master` VALUES('5050', '', 'Purchases of materials', '10', 0);
312 INSERT INTO `0_chart_master` VALUES('5060', '', 'Discounts Received', '10', 0);
313 INSERT INTO `0_chart_master` VALUES('5100', '', 'Freight', '10', 0);
314 INSERT INTO `0_chart_master` VALUES('5410', '', 'Wages & Salaries', '11', 0);
315 INSERT INTO `0_chart_master` VALUES('5420', '', 'Wages - Overtime', '11', 0);
316 INSERT INTO `0_chart_master` VALUES('5430', '', 'Benefits - Comp Time', '11', 0);
317 INSERT INTO `0_chart_master` VALUES('5440', '', 'Benefits - Payroll Taxes', '11', 0);
318 INSERT INTO `0_chart_master` VALUES('5450', '', 'Benefits - Workers Comp', '11', 0);
319 INSERT INTO `0_chart_master` VALUES('5460', '', 'Benefits - Pension', '11', 0);
320 INSERT INTO `0_chart_master` VALUES('5470', '', 'Benefits - General Benefits', '11', 0);
321 INSERT INTO `0_chart_master` VALUES('5510', '', 'Inc Tax Exp - Federal', '11', 0);
322 INSERT INTO `0_chart_master` VALUES('5520', '', 'Inc Tax Exp - State', '11', 0);
323 INSERT INTO `0_chart_master` VALUES('5530', '', 'Taxes - Real Estate', '11', 0);
324 INSERT INTO `0_chart_master` VALUES('5540', '', 'Taxes - Personal Property', '11', 0);
325 INSERT INTO `0_chart_master` VALUES('5550', '', 'Taxes - Franchise', '11', 0);
326 INSERT INTO `0_chart_master` VALUES('5560', '', 'Taxes - Foreign Withholding', '11', 0);
327 INSERT INTO `0_chart_master` VALUES('5610', '', 'Accounting & Legal', '12', 0);
328 INSERT INTO `0_chart_master` VALUES('5615', '', 'Advertising & Promotions', '12', 0);
329 INSERT INTO `0_chart_master` VALUES('5620', '', 'Bad Debts', '12', 0);
330 INSERT INTO `0_chart_master` VALUES('5660', '', 'Amortization Expense', '12', 0);
331 INSERT INTO `0_chart_master` VALUES('5685', '', 'Insurance', '12', 0);
332 INSERT INTO `0_chart_master` VALUES('5690', '', 'Interest & Bank Charges', '12', 0);
333 INSERT INTO `0_chart_master` VALUES('5700', '', 'Office Supplies', '12', 0);
334 INSERT INTO `0_chart_master` VALUES('5760', '', 'Rent', '12', 0);
335 INSERT INTO `0_chart_master` VALUES('5765', '', 'Repair & Maintenance', '12', 0);
336 INSERT INTO `0_chart_master` VALUES('5780', '', 'Telephone', '12', 0);
337 INSERT INTO `0_chart_master` VALUES('5785', '', 'Travel & Entertainment', '12', 0);
338 INSERT INTO `0_chart_master` VALUES('5790', '', 'Utilities', '12', 0);
339 INSERT INTO `0_chart_master` VALUES('5795', '', 'Registrations', '12', 0);
340 INSERT INTO `0_chart_master` VALUES('5800', '', 'Licenses', '12', 0);
341 INSERT INTO `0_chart_master` VALUES('5810', '', 'Foreign Exchange Loss', '12', 0);
342 INSERT INTO `0_chart_master` VALUES('9990', '', 'Year Profit/Loss', '12', 0);
344 -- --------------------------------------------------------
347 -- Table structure for table `0_chart_types`
350 DROP TABLE IF EXISTS `0_chart_types`;
351 CREATE TABLE IF NOT EXISTS `0_chart_types` (
352 `id` varchar(10) NOT NULL,
353 `name` varchar(60) NOT NULL default '',
354 `class_id` varchar(3) NOT NULL default '',
355 `parent` varchar(10) NOT NULL default '-1',
356 `inactive` tinyint(1) NOT NULL default '0',
359 KEY `class_id` (`class_id`)
363 -- Dumping data for table `0_chart_types`
366 INSERT INTO `0_chart_types` VALUES('1', 'Current Assets', '1', '', 0);
367 INSERT INTO `0_chart_types` VALUES('2', 'Inventory Assets', '1', '', 0);
368 INSERT INTO `0_chart_types` VALUES('3', 'Capital Assets', '1', '', 0);
369 INSERT INTO `0_chart_types` VALUES('4', 'Current Liabilities', '2', '', 0);
370 INSERT INTO `0_chart_types` VALUES('5', 'Long Term Liabilities', '2', '', 0);
371 INSERT INTO `0_chart_types` VALUES('6', 'Share Capital', '2', '', 0);
372 INSERT INTO `0_chart_types` VALUES('7', 'Retained Earnings', '2', '', 0);
373 INSERT INTO `0_chart_types` VALUES('8', 'Sales Revenue', '3', '', 0);
374 INSERT INTO `0_chart_types` VALUES('9', 'Other Revenue', '3', '', 0);
375 INSERT INTO `0_chart_types` VALUES('10', 'Cost of Goods Sold', '4', '', 0);
376 INSERT INTO `0_chart_types` VALUES('11', 'Payroll Expenses', '4', '', 0);
377 INSERT INTO `0_chart_types` VALUES('12', 'General & Administrative expenses', '4', '', 0);
379 -- --------------------------------------------------------
382 -- Table structure for table `0_comments`
385 DROP TABLE IF EXISTS `0_comments`;
386 CREATE TABLE IF NOT EXISTS `0_comments` (
387 `type` int(11) NOT NULL default '0',
388 `id` int(11) NOT NULL default '0',
389 `date_` date default '0000-00-00',
391 KEY `type_and_id` (`type`,`id`)
395 -- Dumping data for table `0_comments`
399 -- --------------------------------------------------------
402 -- Table structure for table `0_credit_status`
405 DROP TABLE IF EXISTS `0_credit_status`;
406 CREATE TABLE IF NOT EXISTS `0_credit_status` (
407 `id` int(11) NOT NULL auto_increment,
408 `reason_description` char(100) NOT NULL default '',
409 `dissallow_invoices` tinyint(1) NOT NULL default '0',
410 `inactive` tinyint(1) NOT NULL default '0',
412 UNIQUE KEY `reason_description` (`reason_description`)
413 ) ENGINE=MyISAM AUTO_INCREMENT=5 ;
416 -- Dumping data for table `0_credit_status`
419 INSERT INTO `0_credit_status` VALUES(1, 'Good History', 0, 0);
420 INSERT INTO `0_credit_status` VALUES(3, 'No more work until payment received', 1, 0);
421 INSERT INTO `0_credit_status` VALUES(4, 'In liquidation', 1, 0);
423 -- --------------------------------------------------------
426 -- Table structure for table `0_crm_categories`
429 DROP TABLE IF EXISTS `0_crm_categories`;
430 CREATE TABLE IF NOT EXISTS `0_crm_categories` (
431 `id` int(11) NOT NULL auto_increment COMMENT 'pure technical key',
432 `type` varchar(20) NOT NULL COMMENT 'contact type e.g. customer',
433 `action` varchar(20) NOT NULL COMMENT 'detailed usage e.g. department',
434 `name` varchar(30) NOT NULL COMMENT 'for category selector',
435 `description` tinytext NOT NULL COMMENT 'usage description',
436 `system` tinyint(1) NOT NULL default '0' COMMENT 'nonzero for core system usage',
437 `inactive` tinyint(1) NOT NULL default '0',
439 UNIQUE KEY `type` (`type`,`action`),
440 UNIQUE KEY `type_2` (`type`,`name`)
441 ) ENGINE=InnoDB AUTO_INCREMENT=13 ;
444 -- Dumping data for table `0_crm_categories`
447 INSERT INTO `0_crm_categories` VALUES(1, 'cust_branch', 'general', 'General', 'General contact data for customer branch (overrides company setting)', 1, 0);
448 INSERT INTO `0_crm_categories` VALUES(2, 'cust_branch', 'invoice', 'Invoices', 'Invoice posting (overrides company setting)', 1, 0);
449 INSERT INTO `0_crm_categories` VALUES(3, 'cust_branch', 'order', 'Orders', 'Order confirmation (overrides company setting)', 1, 0);
450 INSERT INTO `0_crm_categories` VALUES(4, 'cust_branch', 'delivery', 'Deliveries', 'Delivery coordination (overrides company setting)', 1, 0);
451 INSERT INTO `0_crm_categories` VALUES(5, 'customer', 'general', 'General', 'General contact data for customer', 1, 0);
452 INSERT INTO `0_crm_categories` VALUES(6, 'customer', 'order', 'Orders', 'Order confirmation', 1, 0);
453 INSERT INTO `0_crm_categories` VALUES(7, 'customer', 'delivery', 'Deliveries', 'Delivery coordination', 1, 0);
454 INSERT INTO `0_crm_categories` VALUES(8, 'customer', 'invoice', 'Invoices', 'Invoice posting', 1, 0);
455 INSERT INTO `0_crm_categories` VALUES(9, 'supplier', 'general', 'General', 'General contact data for supplier', 1, 0);
456 INSERT INTO `0_crm_categories` VALUES(10, 'supplier', 'order', 'Orders', 'Order confirmation', 1, 0);
457 INSERT INTO `0_crm_categories` VALUES(11, 'supplier', 'delivery', 'Deliveries', 'Delivery coordination', 1, 0);
458 INSERT INTO `0_crm_categories` VALUES(12, 'supplier', 'invoice', 'Invoices', 'Invoice posting', 1, 0);
460 -- --------------------------------------------------------
463 -- Table structure for table `0_crm_contacts`
466 DROP TABLE IF EXISTS `0_crm_contacts`;
467 CREATE TABLE IF NOT EXISTS `0_crm_contacts` (
468 `id` int(11) NOT NULL auto_increment,
469 `person_id` int(11) NOT NULL default '0' COMMENT 'foreign key to crm_contacts',
470 `type` varchar(20) NOT NULL COMMENT 'foreign key to crm_categories',
471 `action` varchar(20) NOT NULL COMMENT 'foreign key to crm_categories',
472 `entity_id` varchar(11) default NULL COMMENT 'entity id in related class table',
474 KEY `type` (`type`,`action`)
475 ) ENGINE=InnoDB AUTO_INCREMENT=10 ;
478 -- Dumping data for table `0_crm_contacts`
481 INSERT INTO `0_crm_contacts` VALUES(1, 1, 'customer', 'general', '1');
482 INSERT INTO `0_crm_contacts` VALUES(2, 2, 'customer', 'general', '2');
483 INSERT INTO `0_crm_contacts` VALUES(3, 3, 'customer', 'general', '3');
484 INSERT INTO `0_crm_contacts` VALUES(4, 4, 'cust_branch', 'general', '1');
485 INSERT INTO `0_crm_contacts` VALUES(5, 5, 'cust_branch', 'general', '2');
486 INSERT INTO `0_crm_contacts` VALUES(6, 6, 'cust_branch', 'general', '3');
487 INSERT INTO `0_crm_contacts` VALUES(7, 7, 'supplier', 'general', '1');
488 INSERT INTO `0_crm_contacts` VALUES(8, 8, 'supplier', 'general', '2');
489 INSERT INTO `0_crm_contacts` VALUES(9, 9, 'supplier', 'general', '3');
491 -- --------------------------------------------------------
494 -- Table structure for table `0_crm_persons`
497 DROP TABLE IF EXISTS `0_crm_persons`;
498 CREATE TABLE IF NOT EXISTS `0_crm_persons` (
499 `id` int(11) NOT NULL auto_increment,
500 `ref` varchar(30) NOT NULL,
501 `name` varchar(60) NOT NULL,
502 `name2` varchar(60) default NULL,
504 `phone` varchar(30) default NULL,
505 `phone2` varchar(30) default NULL,
506 `fax` varchar(30) default NULL,
507 `email` varchar(100) default NULL,
508 `lang` char(5) default NULL,
509 `notes` tinytext NOT NULL,
510 `inactive` tinyint(1) NOT NULL default '0',
513 ) ENGINE=InnoDB AUTO_INCREMENT=10 ;
516 -- Dumping data for table `0_crm_persons`
519 INSERT INTO `0_crm_persons` VALUES(1, 'Beefeater', '', NULL, NULL, NULL, NULL, NULL, '', '', '', 0);
520 INSERT INTO `0_crm_persons` VALUES(2, 'Ghostbusters', '', NULL, NULL, NULL, NULL, NULL, '', NULL, '', 0);
521 INSERT INTO `0_crm_persons` VALUES(3, 'Brezan', '', NULL, NULL, NULL, NULL, NULL, '', '', '', 0);
522 INSERT INTO `0_crm_persons` VALUES(4, 'Beefeater', 'Main Branch', NULL, '', '', '', '', '', NULL, '', 0);
523 INSERT INTO `0_crm_persons` VALUES(5, 'Ghostbusters', 'Main Branch', NULL, 'Address 1\nAddress 2\nAddress 3', '', '', '', '', NULL, '', 0);
524 INSERT INTO `0_crm_persons` VALUES(6, 'Brezan', 'Main Branch', NULL, 'Address 1\nAddress 2\nAddress 3', '', '', '', '', NULL, '', 0);
525 INSERT INTO `0_crm_persons` VALUES(7, 'Junk Beer', 'Contact', NULL, 'Address 1\nAddress 2\nAddress 3', '+45 55667788', '', '', '', '', '', 0);
526 INSERT INTO `0_crm_persons` VALUES(8, 'Lucky Luke', 'Luke', NULL, 'Address 1\nAddress 2\nAddress 3', '(111) 222.333.444', '', '', '', NULL, '', 0);
527 INSERT INTO `0_crm_persons` VALUES(9, 'Money Makers', 'Makers', NULL, 'Address 1\nAddress 2\nAddress 3', '+44 444 555 666', '', '', '', '', '', 0);
529 -- --------------------------------------------------------
532 -- Table structure for table `0_currencies`
535 DROP TABLE IF EXISTS `0_currencies`;
536 CREATE TABLE IF NOT EXISTS `0_currencies` (
537 `currency` varchar(60) NOT NULL default '',
538 `curr_abrev` char(3) NOT NULL default '',
539 `curr_symbol` varchar(10) NOT NULL default '',
540 `country` varchar(100) NOT NULL default '',
541 `hundreds_name` varchar(15) NOT NULL default '',
542 `auto_update` tinyint(1) NOT NULL default '1',
543 `inactive` tinyint(1) NOT NULL default '0',
544 PRIMARY KEY (`curr_abrev`)
548 -- Dumping data for table `0_currencies`
551 INSERT INTO `0_currencies` VALUES('US Dollars', 'USD', '$', 'United States', 'Cents', 1, 0);
552 INSERT INTO `0_currencies` VALUES('CA Dollars', 'CAD', '$', 'Canada', 'Cents', 1, 0);
553 INSERT INTO `0_currencies` VALUES('Euro', 'EUR', '?', 'Europe', 'Cents', 1, 0);
554 INSERT INTO `0_currencies` VALUES('Pounds', 'GBP', '?', 'England', 'Pence', 1, 0);
555 INSERT INTO `0_currencies` VALUES('DK Kroner', 'DKK', '?', 'Denmark', 'Ore', 1, 0);
557 -- --------------------------------------------------------
560 -- Table structure for table `0_cust_allocations`
563 DROP TABLE IF EXISTS `0_cust_allocations`;
564 CREATE TABLE IF NOT EXISTS `0_cust_allocations` (
565 `id` int(11) NOT NULL auto_increment,
566 `amt` double unsigned default NULL,
567 `date_alloc` date NOT NULL default '0000-00-00',
568 `trans_no_from` int(11) default NULL,
569 `trans_type_from` int(11) default NULL,
570 `trans_no_to` int(11) default NULL,
571 `trans_type_to` int(11) default NULL,
573 UNIQUE KEY (`trans_type_from`,`trans_no_from`,`trans_type_to`,`trans_no_to`),
574 KEY `From` (`trans_type_from`,`trans_no_from`),
575 KEY `To` (`trans_type_to`,`trans_no_to`)
576 ) ENGINE=InnoDB AUTO_INCREMENT=2 ;
579 -- Dumping data for table `0_cust_allocations`
582 INSERT INTO `0_cust_allocations` VALUES(1, 37.68, '2009-06-21', 3, 11, 18, 10);
584 -- --------------------------------------------------------
587 -- Table structure for table `0_cust_branch`
590 DROP TABLE IF EXISTS `0_cust_branch`;
591 CREATE TABLE IF NOT EXISTS `0_cust_branch` (
592 `branch_code` int(11) NOT NULL auto_increment,
593 `debtor_no` int(11) NOT NULL default '0',
594 `br_name` varchar(60) NOT NULL default '',
595 `branch_ref` varchar(30) NOT NULL default '',
596 `br_address` tinytext NOT NULL,
597 `area` int(11) default NULL,
598 `salesman` int(11) NOT NULL default '0',
599 `contact_name` varchar(60) NOT NULL default '',
600 `default_location` varchar(5) NOT NULL default '',
601 `tax_group_id` int(11) default NULL,
602 `sales_account` varchar(15) NOT NULL default '',
603 `sales_discount_account` varchar(15) NOT NULL default '',
604 `receivables_account` varchar(15) NOT NULL default '',
605 `payment_discount_account` varchar(15) NOT NULL default '',
606 `default_ship_via` int(11) NOT NULL default '1',
607 `disable_trans` tinyint(4) NOT NULL default '0',
608 `br_post_address` tinytext NOT NULL,
609 `group_no` int(11) NOT NULL default '0',
610 `notes` tinytext NOT NULL,
611 `bank_account` varchar(60) DEFAULT NULL,
612 `inactive` tinyint(1) NOT NULL default '0',
613 PRIMARY KEY (`branch_code`,`debtor_no`),
614 KEY `branch_code` (`branch_code`),
615 KEY `branch_ref` (`branch_ref`),
616 KEY `group_no` (`group_no`)
617 ) ENGINE=MyISAM AUTO_INCREMENT=4 ;
620 -- Dumping data for table `0_cust_branch`
623 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);
624 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);
625 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);
627 -- --------------------------------------------------------
630 -- Table structure for table `0_debtors_master`
633 DROP TABLE IF EXISTS `0_debtors_master`;
634 CREATE TABLE IF NOT EXISTS `0_debtors_master` (
635 `debtor_no` int(11) NOT NULL auto_increment,
636 `name` varchar(100) NOT NULL default '',
637 `debtor_ref` varchar(30) NOT NULL,
639 `tax_id` varchar(55) NOT NULL default '',
640 `curr_code` char(3) NOT NULL default '',
641 `sales_type` int(11) NOT NULL default '1',
642 `dimension_id` int(11) NOT NULL default '0',
643 `dimension2_id` int(11) NOT NULL default '0',
644 `credit_status` int(11) NOT NULL default '0',
645 `payment_terms` int(11) default NULL,
646 `discount` double NOT NULL default '0',
647 `pymt_discount` double NOT NULL default '0',
648 `credit_limit` float NOT NULL default '1000',
649 `notes` tinytext NOT NULL,
650 `inactive` tinyint(1) NOT NULL default '0',
651 PRIMARY KEY (`debtor_no`),
653 UNIQUE KEY `debtor_ref` (`debtor_ref`)
654 ) ENGINE=MyISAM AUTO_INCREMENT=4 ;
657 -- Dumping data for table `0_debtors_master`
660 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);
661 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);
662 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);
664 -- --------------------------------------------------------
667 -- Table structure for table `0_debtor_trans`
670 DROP TABLE IF EXISTS `0_debtor_trans`;
671 CREATE TABLE IF NOT EXISTS `0_debtor_trans` (
672 `trans_no` int(11) unsigned NOT NULL default '0',
673 `type` smallint(6) unsigned NOT NULL default '0',
674 `version` tinyint(1) unsigned NOT NULL default '0',
675 `debtor_no` int(11) unsigned default NULL,
676 `branch_code` int(11) NOT NULL default '-1',
677 `tran_date` date NOT NULL default '0000-00-00',
678 `due_date` date NOT NULL default '0000-00-00',
679 `reference` varchar(60) NOT NULL default '',
680 `tpe` int(11) NOT NULL default '0',
681 `order_` int(11) NOT NULL default '0',
682 `ov_amount` double NOT NULL default '0',
683 `ov_gst` double NOT NULL default '0',
684 `ov_freight` double NOT NULL default '0',
685 `ov_freight_tax` double NOT NULL default '0',
686 `ov_discount` double NOT NULL default '0',
687 `alloc` double NOT NULL default '0',
688 `prep_amount` double NOT NULL DEFAULT '0',
689 `rate` double NOT NULL default '1',
690 `ship_via` int(11) default NULL,
691 `dimension_id` int(11) NOT NULL default '0',
692 `dimension2_id` int(11) NOT NULL default '0',
693 `payment_terms` int(11) default NULL,
694 `tax_included` tinyint(1) unsigned NOT NULL default '0',
695 PRIMARY KEY (`type`,`trans_no`),
696 KEY `debtor_no` (`debtor_no`,`branch_code`),
697 KEY `tran_date` (`tran_date`)
701 -- Dumping data for table `0_debtor_trans`
704 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);
705 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);
706 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);
707 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);
708 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);
709 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);
710 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);
711 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);
713 -- --------------------------------------------------------
716 -- Table structure for table `0_debtor_trans_details`
719 DROP TABLE IF EXISTS `0_debtor_trans_details`;
720 CREATE TABLE IF NOT EXISTS `0_debtor_trans_details` (
721 `id` int(11) NOT NULL auto_increment,
722 `debtor_trans_no` int(11) default NULL,
723 `debtor_trans_type` int(11) default NULL,
724 `stock_id` varchar(20) NOT NULL default '',
725 `description` tinytext,
726 `unit_price` double NOT NULL default '0',
727 `unit_tax` double NOT NULL default '0',
728 `quantity` double NOT NULL default '0',
729 `discount_percent` double NOT NULL default '0',
730 `standard_cost` double NOT NULL default '0',
731 `qty_done` double NOT NULL default '0',
732 `src_id` int(11) NOT NULL,
734 KEY `Transaction` (`debtor_trans_type`,`debtor_trans_no`),
736 ) ENGINE=InnoDB AUTO_INCREMENT=9 ;
739 -- Dumping data for table `0_debtor_trans_details`
742 INSERT INTO `0_debtor_trans_details` VALUES(1, 2, 13, '102', '17inch VGA Monitor', 30.4, 0, 2, 0, 10, 0, 1);
743 INSERT INTO `0_debtor_trans_details` VALUES(2, 3, 13, '102', '17inch VGA Monitor', 50, 2.5, 1, 0, 10, 1, 2);
744 INSERT INTO `0_debtor_trans_details` VALUES(3, 17, 10, '102', '17inch VGA Monitor', 50, 2.5, 1, 0, 10, 2, 2);
745 INSERT INTO `0_debtor_trans_details` VALUES(4, 4, 13, '102', '17inch VGA Monitor', 35.89, 1.79, 1, 0, 10, 1,3);
746 INSERT INTO `0_debtor_trans_details` VALUES(5, 18, 10, '102', '17inch VGA Monitor', 35.89, 1.79, 1, 0, 10, 1,4);
747 INSERT INTO `0_debtor_trans_details` VALUES(6, 5, 13, '102', '17inch VGA Monitor', 50, 2.38, 1, 0, 10, 1,5);
748 INSERT INTO `0_debtor_trans_details` VALUES(7, 19, 10, '102', '17inch VGA Monitor', 50, 2.38, 1, 0, 10, 0,6);
749 INSERT INTO `0_debtor_trans_details` VALUES(8, 3, 11, '102', '17inch VGA Monitor', 35.89, 1.79, 1, 0, 10, 0,5);
751 -- --------------------------------------------------------
754 -- Table structure for table `0_dimensions`
757 DROP TABLE IF EXISTS `0_dimensions`;
758 CREATE TABLE IF NOT EXISTS `0_dimensions` (
759 `id` int(11) NOT NULL auto_increment,
760 `reference` varchar(60) NOT NULL default '',
761 `name` varchar(60) NOT NULL default '',
762 `type_` tinyint(1) NOT NULL default '1',
763 `closed` tinyint(1) NOT NULL default '0',
764 `date_` date NOT NULL default '0000-00-00',
765 `due_date` date NOT NULL default '0000-00-00',
767 UNIQUE KEY `reference` (`reference`),
768 KEY `date_` (`date_`),
769 KEY `due_date` (`due_date`),
770 KEY `type_` (`type_`)
771 ) ENGINE=InnoDB AUTO_INCREMENT=3 ;
774 -- Dumping data for table `0_dimensions`
777 INSERT INTO `0_dimensions` VALUES(1, '1', 'Support', 1, 0, '2009-06-21', '2015-07-11');
778 INSERT INTO `0_dimensions` VALUES(2, '2', 'Development', 1, 0, '2009-06-21', '2015-07-11');
780 -- --------------------------------------------------------
783 -- Table structure for table `0_exchange_rates`
786 DROP TABLE IF EXISTS `0_exchange_rates`;
787 CREATE TABLE IF NOT EXISTS `0_exchange_rates` (
788 `id` int(11) NOT NULL auto_increment,
789 `curr_code` char(3) NOT NULL default '',
790 `rate_buy` double NOT NULL default '0',
791 `rate_sell` double NOT NULL default '0',
792 `date_` date NOT NULL default '0000-00-00',
794 UNIQUE KEY `curr_code` (`curr_code`,`date_`)
795 ) ENGINE=MyISAM AUTO_INCREMENT=4 ;
798 -- Dumping data for table `0_exchange_rates`
801 INSERT INTO `0_exchange_rates` VALUES(1, 'DKK', 0.18717252868313, 0.18717252868313, '2009-06-21');
802 INSERT INTO `0_exchange_rates` VALUES(2, 'GBP', 1.6445729799917, 1.6445729799917, '2009-06-21');
803 INSERT INTO `0_exchange_rates` VALUES(3, 'EUR', 1.3932, 1.3932, '2009-06-21');
805 -- --------------------------------------------------------
808 -- Table structure for table `0_fiscal_year`
811 DROP TABLE IF EXISTS `0_fiscal_year`;
812 CREATE TABLE IF NOT EXISTS `0_fiscal_year` (
813 `id` int(11) NOT NULL auto_increment,
814 `begin` date default '0000-00-00',
815 `end` date default '0000-00-00',
816 `closed` tinyint(1) NOT NULL default '0',
818 UNIQUE KEY `begin` (`begin`),
819 UNIQUE KEY `end` (`end`)
820 ) ENGINE=InnoDB AUTO_INCREMENT=4 ;
823 -- Dumping data for table `0_fiscal_year`
826 INSERT INTO `0_fiscal_year` VALUES(1, '2008-01-01', '2008-12-31', 1);
827 INSERT INTO `0_fiscal_year` VALUES(2, '2009-01-01', '2009-12-31', 1);
828 INSERT INTO `0_fiscal_year` VALUES(3, '2010-01-01', '2010-12-31', 0);
829 INSERT INTO `0_fiscal_year` VALUES(4, '2011-01-01', '2011-12-31', 0);
830 INSERT INTO `0_fiscal_year` VALUES(5, '2012-01-01', '2012-12-31', 0);
831 INSERT INTO `0_fiscal_year` VALUES(6, '2013-01-01', '2013-12-31', 0);
834 -- Table structure for table `0_gl_trans`
837 DROP TABLE IF EXISTS `0_gl_trans`;
838 CREATE TABLE IF NOT EXISTS `0_gl_trans` (
839 `counter` int(11) NOT NULL auto_increment,
840 `type` smallint(6) NOT NULL default '0',
841 `type_no` bigint(16) NOT NULL default '1',
842 `tran_date` date NOT NULL default '0000-00-00',
843 `account` varchar(15) NOT NULL default '',
844 `memo_` tinytext NOT NULL,
845 `amount` double NOT NULL default '0',
846 `dimension_id` int(11) NOT NULL default '0',
847 `dimension2_id` int(11) NOT NULL default '0',
848 `person_type_id` int(11) default NULL,
849 `person_id` tinyblob,
850 PRIMARY KEY (`counter`),
851 KEY `Type_and_Number` (`type`,`type_no`),
852 KEY `dimension_id` (`dimension_id`),
853 KEY `dimension2_id` (`dimension2_id`),
854 KEY `tran_date` (`tran_date`),
855 KEY `account_and_tran_date` (`account`,`tran_date`)
856 ) ENGINE=InnoDB AUTO_INCREMENT=84 ;
859 -- Dumping data for table `0_gl_trans`
862 INSERT INTO `0_gl_trans` VALUES(1, 20, 7, '2009-06-21', '2100', '', -3465, 0, 0, 3, '2');
863 INSERT INTO `0_gl_trans` VALUES(2, 20, 7, '2009-06-21', '1510', '', 1000, 0, 0, 3, '2');
864 INSERT INTO `0_gl_trans` VALUES(3, 20, 7, '2009-06-21', '1510', '', 1100, 0, 0, 3, '2');
865 INSERT INTO `0_gl_trans` VALUES(4, 20, 7, '2009-06-21', '1510', '', 1200, 0, 0, 3, '2');
866 INSERT INTO `0_gl_trans` VALUES(5, 20, 7, '2009-06-21', '2150', '', 165, 0, 0, 3, '2');
867 INSERT INTO `0_gl_trans` VALUES(6, 22, 4, '2009-06-21', '2100', '', 3465, 0, 0, 3, '2');
868 INSERT INTO `0_gl_trans` VALUES(7, 22, 4, '2009-06-21', '1060', '', -3465, 0, 0, 3, '2');
869 INSERT INTO `0_gl_trans` VALUES(8, 26, 1, '2009-06-21', '1510', '', -100, 0, 0, NULL, '');
870 INSERT INTO `0_gl_trans` VALUES(9, 26, 1, '2009-06-21', '1510', '', -110, 0, 0, NULL, '');
871 INSERT INTO `0_gl_trans` VALUES(10, 26, 1, '2009-06-21', '1510', '', -120, 0, 0, NULL, '');
872 INSERT INTO `0_gl_trans` VALUES(11, 26, 1, '2009-06-21', '1060', 'Overhead Cost', -10, 0, 0, 1, '1');
873 INSERT INTO `0_gl_trans` VALUES(12, 26, 1, '2009-06-21', '1530', 'Overhead Cost', 10, 0, 0, 1, '1');
874 INSERT INTO `0_gl_trans` VALUES(13, 26, 1, '2009-06-21', '1060', 'Labour Cost', -20, 0, 0, 1, '0');
875 INSERT INTO `0_gl_trans` VALUES(14, 26, 1, '2009-06-21', '1530', 'Labour Cost', 20, 0, 0, 1, '0');
876 INSERT INTO `0_gl_trans` VALUES(15, 26, 1, '2009-06-21', '1510', '', 330, 0, 0, NULL, '');
877 INSERT INTO `0_gl_trans` VALUES(16, 13, 2, '2009-06-21', '5010', '', 20, 0, 0, 2, '1');
878 INSERT INTO `0_gl_trans` VALUES(17, 13, 2, '2009-06-21', '1510', '', -20, 0, 0, 2, '1');
879 INSERT INTO `0_gl_trans` VALUES(18, 13, 3, '2009-06-21', '5010', '', 10, 0, 0, 2, '2');
880 INSERT INTO `0_gl_trans` VALUES(19, 13, 3, '2009-06-21', '1510', '', -10, 0, 0, 2, '2');
881 INSERT INTO `0_gl_trans` VALUES(20, 10, 17, '2009-06-21', '4010', '', -50, 0, 0, 2, '2');
882 INSERT INTO `0_gl_trans` VALUES(21, 10, 17, '2009-06-21', '1200', '', 52.5, 0, 0, 2, '2');
883 INSERT INTO `0_gl_trans` VALUES(22, 10, 17, '2009-06-21', '2150', '', -2.5, 0, 0, 2, '2');
884 INSERT INTO `0_gl_trans` VALUES(23, 13, 4, '2009-06-21', '5010', '', 10, 2, 0, 2, '3');
885 INSERT INTO `0_gl_trans` VALUES(24, 13, 4, '2009-06-21', '1510', '', -10, 0, 0, 2, '3');
886 INSERT INTO `0_gl_trans` VALUES(25, 10, 18, '2009-06-21', '4010', '', -50, 2, 0, 2, '3');
887 INSERT INTO `0_gl_trans` VALUES(26, 10, 18, '2009-06-21', '1200', '', 52.5, 0, 0, 2, '3');
888 INSERT INTO `0_gl_trans` VALUES(27, 10, 18, '2009-06-21', '2150', '', -2.5, 0, 0, 2, '3');
889 INSERT INTO `0_gl_trans` VALUES(28, 0, 18, '2009-02-20', '1060', '', 1000, 0, 0, NULL, '');
890 INSERT INTO `0_gl_trans` VALUES(29, 0, 18, '2009-02-20', '3350', '', -1000, 0, 0, NULL, '');
891 INSERT INTO `0_gl_trans` VALUES(30, 0, 19, '2009-02-21', '1060', '', 4000, 0, 0, NULL, '');
892 INSERT INTO `0_gl_trans` VALUES(31, 0, 19, '2009-02-21', '3350', '', -4000, 0, 0, NULL, '');
893 INSERT INTO `0_gl_trans` VALUES(32, 26, 3, '2009-06-21', '1510', '', -20, 0, 0, NULL, '');
894 INSERT INTO `0_gl_trans` VALUES(33, 26, 3, '2009-06-21', '1510', '', -22, 0, 0, NULL, '');
895 INSERT INTO `0_gl_trans` VALUES(34, 26, 3, '2009-06-21', '1510', '', -24, 0, 0, NULL, '');
896 INSERT INTO `0_gl_trans` VALUES(35, 26, 3, '2009-06-21', '1540', '', 66, 0, 0, NULL, '');
897 INSERT INTO `0_gl_trans` VALUES(36, 2, 5, '2009-06-21', '2150', 'Cash Sales', -4.76, 0, 0, 4, '3');
898 INSERT INTO `0_gl_trans` VALUES(37, 2, 5, '2009-06-21', '4010', 'Cash Sales', -95.24, 0, 0, 4, '3');
899 INSERT INTO `0_gl_trans` VALUES(38, 2, 5, '2009-06-21', '1060', '', 100, 0, 0, 4, '3');
900 INSERT INTO `0_gl_trans` VALUES(39, 1, 8, '2009-06-21', '2150', 'Maintenance', 2.38, 0, 0, 4, '1');
901 INSERT INTO `0_gl_trans` VALUES(40, 1, 8, '2009-06-21', '5765', 'Maintenance', 47.62, 0, 0, 4, '1');
902 INSERT INTO `0_gl_trans` VALUES(41, 1, 8, '2009-06-21', '1060', '', -50, 0, 0, 4, '1');
903 INSERT INTO `0_gl_trans` VALUES(42, 20, 8, '2009-06-21', '2100', '', -20, 0, 0, 3, '2');
904 INSERT INTO `0_gl_trans` VALUES(43, 20, 8, '2009-06-21', '2150', '', 0.95, 0, 0, 3, '2');
905 INSERT INTO `0_gl_trans` VALUES(44, 20, 8, '2009-06-21', '5780', '', 19.05, 0, 0, 3, '2');
906 INSERT INTO `0_gl_trans` VALUES(45, 26, 4, '2009-06-21', '1510', '', -40, 0, 0, NULL, '');
907 INSERT INTO `0_gl_trans` VALUES(46, 26, 4, '2009-06-21', '1510', '', -44, 0, 0, NULL, '');
908 INSERT INTO `0_gl_trans` VALUES(47, 26, 4, '2009-06-21', '1510', '', -48, 0, 0, NULL, '');
909 INSERT INTO `0_gl_trans` VALUES(48, 26, 4, '2009-06-21', '1540', '', 132, 0, 0, NULL, '');
910 INSERT INTO `0_gl_trans` VALUES(49, 26, 2, '2009-06-21', '1510', '', -20, 0, 0, NULL, '');
911 INSERT INTO `0_gl_trans` VALUES(50, 26, 2, '2009-06-21', '1510', '', -22, 0, 0, NULL, '');
912 INSERT INTO `0_gl_trans` VALUES(51, 26, 2, '2009-06-21', '1510', '', -24, 0, 0, NULL, '');
913 INSERT INTO `0_gl_trans` VALUES(52, 26, 2, '2009-06-21', '1540', '', 66, 0, 0, NULL, '');
914 INSERT INTO `0_gl_trans` VALUES(53, 26, 5, '2009-06-21', '1510', '', -50, 0, 0, NULL, '');
915 INSERT INTO `0_gl_trans` VALUES(54, 26, 5, '2009-06-21', '1510', '', -55, 0, 0, NULL, '');
916 INSERT INTO `0_gl_trans` VALUES(55, 26, 5, '2009-06-21', '1510', '', -60, 0, 0, NULL, '');
917 INSERT INTO `0_gl_trans` VALUES(56, 26, 5, '2009-06-21', '1060', 'Overhead Cost', -10, 0, 0, 1, '1');
918 INSERT INTO `0_gl_trans` VALUES(57, 26, 5, '2009-06-21', '1530', 'Overhead Cost', 10, 0, 0, 1, '1');
919 INSERT INTO `0_gl_trans` VALUES(58, 26, 5, '2009-06-21', '1060', 'Labour Cost', -20, 0, 0, 1, '0');
920 INSERT INTO `0_gl_trans` VALUES(59, 26, 5, '2009-06-21', '1530', 'Labour Cost', 20, 0, 0, 1, '0');
921 INSERT INTO `0_gl_trans` VALUES(60, 26, 5, '2009-06-21', '1540', '', 165, 0, 0, NULL, '');
922 INSERT INTO `0_gl_trans` VALUES(61, 26, 6, '2009-06-21', '1510', '', 50, 0, 0, NULL, '');
923 INSERT INTO `0_gl_trans` VALUES(62, 26, 6, '2009-06-21', '1510', '', 55, 0, 0, NULL, '');
924 INSERT INTO `0_gl_trans` VALUES(63, 26, 6, '2009-06-21', '1510', '', 60, 0, 0, NULL, '');
925 INSERT INTO `0_gl_trans` VALUES(64, 26, 6, '2009-06-21', '1540', '', -165, 0, 0, NULL, '');
926 INSERT INTO `0_gl_trans` VALUES(65, 26, 7, '2009-06-21', '1510', '', 20, 0, 0, NULL, '');
927 INSERT INTO `0_gl_trans` VALUES(66, 26, 7, '2009-06-21', '1510', '', 22, 0, 0, NULL, '');
928 INSERT INTO `0_gl_trans` VALUES(67, 26, 7, '2009-06-21', '1510', '', 24, 0, 0, NULL, '');
929 INSERT INTO `0_gl_trans` VALUES(68, 26, 7, '2009-06-21', '1060', 'Overhead Cost', -10, 0, 0, 1, '1');
930 INSERT INTO `0_gl_trans` VALUES(69, 26, 7, '2009-06-21', '1530', 'Overhead Cost', 10, 0, 0, 1, '1');
931 INSERT INTO `0_gl_trans` VALUES(70, 26, 7, '2009-06-21', '1060', 'Labour Cost', -20, 0, 0, 1, '0');
932 INSERT INTO `0_gl_trans` VALUES(71, 26, 7, '2009-06-21', '1530', 'Labour Cost', 20, 0, 0, 1, '0');
933 INSERT INTO `0_gl_trans` VALUES(72, 26, 7, '2009-06-21', '1540', '', -66, 0, 0, NULL, '');
934 INSERT INTO `0_gl_trans` VALUES(73, 13, 5, '2009-06-21', '5010', '', 10, 0, 0, 2, '2');
935 INSERT INTO `0_gl_trans` VALUES(74, 13, 5, '2009-06-21', '1510', '', -10, 0, 0, 2, '2');
936 INSERT INTO `0_gl_trans` VALUES(75, 10, 19, '2009-06-21', '4010', '', -47.62, 0, 0, 2, '2');
937 INSERT INTO `0_gl_trans` VALUES(76, 10, 19, '2009-06-21', '1200', '', 55, 0, 0, 2, '2');
938 INSERT INTO `0_gl_trans` VALUES(77, 10, 19, '2009-06-21', '4430', '', -5, 0, 0, 2, '2');
939 INSERT INTO `0_gl_trans` VALUES(78, 10, 19, '2009-06-21', '2150', '', -2.38, 0, 0, 2, '2');
940 INSERT INTO `0_gl_trans` VALUES(79, 11, 3, '2009-06-21', '5010', '', -10, 2, 0, 2, '3');
941 INSERT INTO `0_gl_trans` VALUES(80, 11, 3, '2009-06-21', '1510', '', 10, 0, 0, 2, '3');
942 INSERT INTO `0_gl_trans` VALUES(81, 11, 3, '2009-06-21', '4010', '', 50, 2, 0, 2, '3');
943 INSERT INTO `0_gl_trans` VALUES(82, 11, 3, '2009-06-21', '1200', '', -52.5, 0, 0, 2, '3');
944 INSERT INTO `0_gl_trans` VALUES(83, 11, 3, '2009-06-21', '2150', '', 2.5, 0, 0, 2, '3');
945 INSERT INTO `0_gl_trans` VALUES ('84', '0', '20', '2009-12-31', '3590', 'Closing Year', '-91.19', '0', '0', NULL, NULL);
946 INSERT INTO `0_gl_trans` VALUES ('85', '0', '20', '2009-12-31', '9990', 'Closing Year', '91.19', '0', '0', NULL, NULL);
948 -- --------------------------------------------------------
951 -- Table structure for table `0_grn_batch`
954 DROP TABLE IF EXISTS `0_grn_batch`;
955 CREATE TABLE IF NOT EXISTS `0_grn_batch` (
956 `id` int(11) NOT NULL auto_increment,
957 `supplier_id` int(11) NOT NULL default '0',
958 `purch_order_no` int(11) default NULL,
959 `reference` varchar(60) NOT NULL default '',
960 `delivery_date` date NOT NULL default '0000-00-00',
961 `loc_code` varchar(5) default NULL,
962 `rate` double NOT NULL default '1',
964 KEY `delivery_date` (`delivery_date`),
965 KEY `purch_order_no` (`purch_order_no`)
966 ) ENGINE=InnoDB AUTO_INCREMENT=2 ;
969 -- Dumping data for table `0_grn_batch`
972 INSERT INTO `0_grn_batch` VALUES(1, 2, 1, '1', '2009-06-21', 'DEF', '1');
974 -- --------------------------------------------------------
977 -- Table structure for table `0_grn_items`
980 DROP TABLE IF EXISTS `0_grn_items`;
981 CREATE TABLE IF NOT EXISTS `0_grn_items` (
982 `id` int(11) NOT NULL auto_increment,
983 `grn_batch_id` int(11) default NULL,
984 `po_detail_item` int(11) NOT NULL default '0',
985 `item_code` varchar(20) NOT NULL default '',
986 `description` tinytext,
987 `qty_recd` double NOT NULL default '0',
988 `quantity_inv` double NOT NULL default '0',
990 KEY `grn_batch_id` (`grn_batch_id`)
991 ) ENGINE=InnoDB AUTO_INCREMENT=4 ;
994 -- Dumping data for table `0_grn_items`
997 INSERT INTO `0_grn_items` VALUES(1, 1, 1, '102', '17inch VGA Monitor', 100, 100);
998 INSERT INTO `0_grn_items` VALUES(2, 1, 2, '103', '32MB VGA Card', 100, 100);
999 INSERT INTO `0_grn_items` VALUES(3, 1, 3, '104', '52x CD Drive', 100, 100);
1001 -- --------------------------------------------------------
1004 -- Table structure for table `0_groups`
1007 DROP TABLE IF EXISTS `0_groups`;
1008 CREATE TABLE IF NOT EXISTS `0_groups` (
1009 `id` smallint(6) unsigned NOT NULL auto_increment,
1010 `description` varchar(60) NOT NULL default '',
1011 `inactive` tinyint(1) NOT NULL default '0',
1013 UNIQUE KEY `description` (`description`)
1014 ) ENGINE=MyISAM AUTO_INCREMENT=4 ;
1017 -- Dumping data for table `0_groups`
1020 INSERT INTO `0_groups` VALUES(1, 'Small', 0);
1021 INSERT INTO `0_groups` VALUES(2, 'Medium', 0);
1022 INSERT INTO `0_groups` VALUES(3, 'Large', 0);
1024 -- --------------------------------------------------------
1027 -- Table structure for table `0_item_codes`
1030 DROP TABLE IF EXISTS `0_item_codes`;
1031 CREATE TABLE IF NOT EXISTS `0_item_codes` (
1032 `id` int(11) unsigned NOT NULL auto_increment,
1033 `item_code` varchar(20) NOT NULL,
1034 `stock_id` varchar(20) NOT NULL,
1035 `description` varchar(200) NOT NULL default '',
1036 `category_id` smallint(6) unsigned NOT NULL,
1037 `quantity` double NOT NULL default '1',
1038 `is_foreign` tinyint(1) NOT NULL default '0',
1039 `inactive` tinyint(1) NOT NULL default '0',
1041 UNIQUE KEY `stock_id` (`stock_id`,`item_code`),
1042 KEY `item_code` (`item_code`)
1043 ) ENGINE=MyISAM AUTO_INCREMENT=6 ;
1046 -- Dumping data for table `0_item_codes`
1049 INSERT INTO `0_item_codes` VALUES(1, '102', '102', '17inch VGA Monitor', 1, 1, 0, 0);
1050 INSERT INTO `0_item_codes` VALUES(2, '103', '103', '32MB VGA Card', 1, 1, 0, 0);
1051 INSERT INTO `0_item_codes` VALUES(3, '104', '104', '52x CD Drive', 1, 1, 0, 0);
1052 INSERT INTO `0_item_codes` VALUES(4, '3400', '3400', 'P4 Business System', 3, 1, 0, 0);
1053 INSERT INTO `0_item_codes` VALUES(5, '201', '201', 'Assembly Labour', 4, 1, 0, 0);
1055 -- --------------------------------------------------------
1058 -- Table structure for table `0_item_tax_types`
1061 DROP TABLE IF EXISTS `0_item_tax_types`;
1062 CREATE TABLE IF NOT EXISTS `0_item_tax_types` (
1063 `id` int(11) NOT NULL auto_increment,
1064 `name` varchar(60) NOT NULL default '',
1065 `exempt` tinyint(1) NOT NULL default '0',
1066 `inactive` tinyint(1) NOT NULL default '0',
1068 UNIQUE KEY `name` (`name`)
1069 ) ENGINE=InnoDB AUTO_INCREMENT=2 ;
1072 -- Dumping data for table `0_item_tax_types`
1075 INSERT INTO `0_item_tax_types` VALUES(1, 'Regular', 0, 0);
1077 -- --------------------------------------------------------
1080 -- Table structure for table `0_item_tax_type_exemptions`
1083 DROP TABLE IF EXISTS `0_item_tax_type_exemptions`;
1084 CREATE TABLE IF NOT EXISTS `0_item_tax_type_exemptions` (
1085 `item_tax_type_id` int(11) NOT NULL default '0',
1086 `tax_type_id` int(11) NOT NULL default '0',
1087 PRIMARY KEY (`item_tax_type_id`,`tax_type_id`)
1091 -- Dumping data for table `0_item_tax_type_exemptions`
1095 -- --------------------------------------------------------
1098 -- Table structure for table `0_item_units`
1101 DROP TABLE IF EXISTS `0_item_units`;
1102 CREATE TABLE IF NOT EXISTS `0_item_units` (
1103 `abbr` varchar(20) NOT NULL,
1104 `name` varchar(40) NOT NULL,
1105 `decimals` tinyint(2) NOT NULL,
1106 `inactive` tinyint(1) NOT NULL default '0',
1107 PRIMARY KEY (`abbr`),
1108 UNIQUE KEY `name` (`name`)
1112 -- Dumping data for table `0_item_units`
1115 INSERT INTO `0_item_units` VALUES('ea.', 'Each', 0, 0);
1116 INSERT INTO `0_item_units` VALUES('hrs', 'Hours', 1, 0);
1118 -- --------------------------------------------------------
1121 -- Table structure for table `0_locations`
1124 DROP TABLE IF EXISTS `0_locations`;
1125 CREATE TABLE IF NOT EXISTS `0_locations` (
1126 `loc_code` varchar(5) NOT NULL default '',
1127 `location_name` varchar(60) NOT NULL default '',
1128 `delivery_address` tinytext NOT NULL,
1129 `phone` varchar(30) NOT NULL default '',
1130 `phone2` varchar(30) NOT NULL default '',
1131 `fax` varchar(30) NOT NULL default '',
1132 `email` varchar(100) NOT NULL default '',
1133 `contact` varchar(30) NOT NULL default '',
1134 `inactive` tinyint(1) NOT NULL default '0',
1135 PRIMARY KEY (`loc_code`)
1139 -- Dumping data for table `0_locations`
1142 INSERT INTO `0_locations` VALUES('DEF', 'Default', 'Delivery 1\nDelivery 2\nDelivery 3', '', '', '', '', '', 0);
1144 -- --------------------------------------------------------
1147 -- Table structure for table `0_loc_stock`
1150 DROP TABLE IF EXISTS `0_loc_stock`;
1151 CREATE TABLE IF NOT EXISTS `0_loc_stock` (
1152 `loc_code` char(5) NOT NULL default '',
1153 `stock_id` char(20) NOT NULL default '',
1154 `reorder_level` bigint(20) NOT NULL default '0',
1155 PRIMARY KEY (`loc_code`,`stock_id`),
1156 KEY `stock_id` (`stock_id`)
1160 -- Dumping data for table `0_loc_stock`
1163 INSERT INTO `0_loc_stock` VALUES('DEF', '102', 0);
1164 INSERT INTO `0_loc_stock` VALUES('DEF', '103', 0);
1165 INSERT INTO `0_loc_stock` VALUES('DEF', '104', 0);
1166 INSERT INTO `0_loc_stock` VALUES('DEF', '201', 0);
1167 INSERT INTO `0_loc_stock` VALUES('DEF', '3400', 0);
1169 -- --------------------------------------------------------
1172 -- Table structure for table `0_movement_types`
1175 DROP TABLE IF EXISTS `0_movement_types`;
1176 CREATE TABLE IF NOT EXISTS `0_movement_types` (
1177 `id` int(11) NOT NULL auto_increment,
1178 `name` varchar(60) NOT NULL default '',
1179 `inactive` tinyint(1) NOT NULL default '0',
1181 UNIQUE KEY `name` (`name`)
1182 ) ENGINE=MyISAM AUTO_INCREMENT=2 ;
1185 -- Dumping data for table `0_movement_types`
1188 INSERT INTO `0_movement_types` VALUES(1, 'Adjustment', 0);
1190 -- --------------------------------------------------------
1193 -- Table structure for table `0_payment_terms`
1196 DROP TABLE IF EXISTS `0_payment_terms`;
1197 CREATE TABLE IF NOT EXISTS `0_payment_terms` (
1198 `terms_indicator` int(11) NOT NULL auto_increment,
1199 `terms` char(80) NOT NULL default '',
1200 `days_before_due` smallint(6) NOT NULL default '0',
1201 `day_in_following_month` smallint(6) NOT NULL default '0',
1202 `inactive` tinyint(1) NOT NULL default '0',
1203 PRIMARY KEY (`terms_indicator`),
1204 UNIQUE KEY `terms` (`terms`)
1205 ) ENGINE=MyISAM AUTO_INCREMENT=5 ;
1208 -- Dumping data for table `0_payment_terms`
1211 INSERT INTO `0_payment_terms` VALUES(1, 'Due 15th Of the Following Month', 0, 17, 0);
1212 INSERT INTO `0_payment_terms` VALUES(2, 'Due By End Of The Following Month', 0, 30, 0);
1213 INSERT INTO `0_payment_terms` VALUES(3, 'Payment due within 10 days', 10, 0, 0);
1214 INSERT INTO `0_payment_terms` VALUES(4, 'Cash Only', 0, 0, 0);
1216 -- --------------------------------------------------------
1219 -- Table structure for table `0_prices`
1222 DROP TABLE IF EXISTS `0_prices`;
1223 CREATE TABLE IF NOT EXISTS `0_prices` (
1224 `id` int(11) NOT NULL auto_increment,
1225 `stock_id` varchar(20) NOT NULL default '',
1226 `sales_type_id` int(11) NOT NULL default '0',
1227 `curr_abrev` char(3) NOT NULL default '',
1228 `price` double NOT NULL default '0',
1230 UNIQUE KEY `price` (`stock_id`,`sales_type_id`,`curr_abrev`)
1231 ) ENGINE=MyISAM AUTO_INCREMENT=5 ;
1234 -- Dumping data for table `0_prices`
1237 INSERT INTO `0_prices` VALUES(1, '3400', 1, 'USD', 100);
1238 INSERT INTO `0_prices` VALUES(2, '102', 1, 'USD', 50);
1239 INSERT INTO `0_prices` VALUES(3, '103', 1, 'USD', 55);
1240 INSERT INTO `0_prices` VALUES(4, '104', 1, 'USD', 60);
1242 -- --------------------------------------------------------
1245 -- Table structure for table `0_printers`
1248 DROP TABLE IF EXISTS `0_printers`;
1249 CREATE TABLE IF NOT EXISTS `0_printers` (
1250 `id` tinyint(3) unsigned NOT NULL auto_increment,
1251 `name` varchar(20) NOT NULL,
1252 `description` varchar(60) NOT NULL,
1253 `queue` varchar(20) NOT NULL,
1254 `host` varchar(40) NOT NULL,
1255 `port` smallint(11) unsigned NOT NULL,
1256 `timeout` tinyint(3) unsigned NOT NULL,
1258 UNIQUE KEY `name` (`name`)
1259 ) ENGINE=MyISAM AUTO_INCREMENT=4 ;
1262 -- Dumping data for table `0_printers`
1265 INSERT INTO `0_printers` VALUES(1, 'QL500', 'Label printer', 'QL500', 'server', 127, 20);
1266 INSERT INTO `0_printers` VALUES(2, 'Samsung', 'Main network printer', 'scx4521F', 'server', 515, 5);
1267 INSERT INTO `0_printers` VALUES(3, 'Local', 'Local print server at user IP', 'lp', '', 515, 10);
1269 -- --------------------------------------------------------
1272 -- Table structure for table `0_print_profiles`
1275 DROP TABLE IF EXISTS `0_print_profiles`;
1276 CREATE TABLE IF NOT EXISTS `0_print_profiles` (
1277 `id` smallint(6) unsigned NOT NULL auto_increment,
1278 `profile` varchar(30) NOT NULL,
1279 `report` varchar(5) default NULL,
1280 `printer` tinyint(3) unsigned default NULL,
1282 UNIQUE KEY `profile` (`profile`,`report`)
1283 ) ENGINE=MyISAM AUTO_INCREMENT=10 ;
1286 -- Dumping data for table `0_print_profiles`
1289 INSERT INTO `0_print_profiles` VALUES(1, 'Out of office', '', 0);
1290 INSERT INTO `0_print_profiles` VALUES(2, 'Sales Department', '', 0);
1291 INSERT INTO `0_print_profiles` VALUES(3, 'Central', '', 2);
1292 INSERT INTO `0_print_profiles` VALUES(4, 'Sales Department', '104', 2);
1293 INSERT INTO `0_print_profiles` VALUES(5, 'Sales Department', '105', 2);
1294 INSERT INTO `0_print_profiles` VALUES(6, 'Sales Department', '107', 2);
1295 INSERT INTO `0_print_profiles` VALUES(7, 'Sales Department', '109', 2);
1296 INSERT INTO `0_print_profiles` VALUES(8, 'Sales Department', '110', 2);
1297 INSERT INTO `0_print_profiles` VALUES(9, 'Sales Department', '201', 2);
1299 -- --------------------------------------------------------
1302 -- Table structure for table `0_purch_data`
1305 DROP TABLE IF EXISTS `0_purch_data`;
1306 CREATE TABLE IF NOT EXISTS `0_purch_data` (
1307 `supplier_id` int(11) NOT NULL default '0',
1308 `stock_id` char(20) NOT NULL default '',
1309 `price` double NOT NULL default '0',
1310 `suppliers_uom` char(50) NOT NULL default '',
1311 `conversion_factor` double NOT NULL default '1',
1312 `supplier_description` char(50) NOT NULL default '',
1313 PRIMARY KEY (`supplier_id`,`stock_id`)
1317 -- Dumping data for table `0_purch_data`
1320 INSERT INTO `0_purch_data` VALUES(2, '102', 10, '', 1, '17inch VGA Monitor');
1321 INSERT INTO `0_purch_data` VALUES(2, '103', 11, '', 1, '32MB VGA Card');
1322 INSERT INTO `0_purch_data` VALUES(2, '104', 12, '', 1, '52x CD Drive');
1324 -- --------------------------------------------------------
1327 -- Table structure for table `0_purch_orders`
1330 DROP TABLE IF EXISTS `0_purch_orders`;
1331 CREATE TABLE IF NOT EXISTS `0_purch_orders` (
1332 `order_no` int(11) NOT NULL auto_increment,
1333 `supplier_id` int(11) NOT NULL default '0',
1334 `comments` tinytext,
1335 `ord_date` date NOT NULL default '0000-00-00',
1336 `reference` tinytext NOT NULL,
1337 `requisition_no` tinytext,
1338 `into_stock_location` varchar(5) NOT NULL default '',
1339 `delivery_address` tinytext NOT NULL,
1340 `total` double NOT NULL default '0',
1341 `prep_amount` double NOT NULL DEFAULT '0',
1342 `alloc` double NOT NULL DEFAULT '0',
1343 `tax_included` tinyint(1) NOT NULL default '0',
1344 PRIMARY KEY (`order_no`),
1345 KEY `ord_date` (`ord_date`)
1346 ) ENGINE=InnoDB AUTO_INCREMENT=3 ;
1349 -- Dumping data for table `0_purch_orders`
1352 INSERT INTO `0_purch_orders` VALUES(1, 2, '', '2009-06-01', '1', '', 'DEF', 'Delivery 1\nDelivery 2\nDelivery 3', 0, 0, 0, 0);
1353 INSERT INTO `0_purch_orders` VALUES(2, 3, '', '2009-06-21', '2', '', 'DEF', 'Delivery 1\nDelivery 2\nDelivery 3', 0, 0, 0, 0);
1355 -- --------------------------------------------------------
1358 -- Table structure for table `0_purch_order_details`
1361 DROP TABLE IF EXISTS `0_purch_order_details`;
1362 CREATE TABLE IF NOT EXISTS `0_purch_order_details` (
1363 `po_detail_item` int(11) NOT NULL auto_increment,
1364 `order_no` int(11) NOT NULL default '0',
1365 `item_code` varchar(20) NOT NULL default '',
1366 `description` tinytext,
1367 `delivery_date` date NOT NULL default '0000-00-00',
1368 `qty_invoiced` double NOT NULL default '0',
1369 `unit_price` double NOT NULL default '0',
1370 `act_price` double NOT NULL default '0',
1371 `std_cost_unit` double NOT NULL default '0',
1372 `quantity_ordered` double NOT NULL default '0',
1373 `quantity_received` double NOT NULL default '0',
1374 PRIMARY KEY (`po_detail_item`),
1375 KEY `order` (`order_no`,`po_detail_item`),
1376 KEY `itemcode` (`item_code`)
1377 ) ENGINE=InnoDB AUTO_INCREMENT=6 ;
1380 -- Dumping data for table `0_purch_order_details`
1383 INSERT INTO `0_purch_order_details` VALUES(1, 1, '102', '17inch VGA Monitor', '2009-07-01', 100, 10, 10, 10, 100, 100);
1384 INSERT INTO `0_purch_order_details` VALUES(2, 1, '103', '32MB VGA Card', '2009-07-01', 100, 11, 11, 11, 100, 100);
1385 INSERT INTO `0_purch_order_details` VALUES(3, 1, '104', '52x CD Drive', '2009-07-01', 100, 12, 12, 12, 100, 100);
1386 INSERT INTO `0_purch_order_details` VALUES(4, 2, '102', '17inch VGA Monitor', '2009-07-01', 0, 5, 0, 0, 1, 0);
1387 INSERT INTO `0_purch_order_details` VALUES(5, 2, '103', '32MB VGA Card', '2009-07-01', 0, 5, 0, 0, 1, 0);
1389 -- --------------------------------------------------------
1392 -- Table structure for table `0_quick_entries`
1395 DROP TABLE IF EXISTS `0_quick_entries`;
1396 CREATE TABLE IF NOT EXISTS `0_quick_entries` (
1397 `id` smallint(6) unsigned NOT NULL auto_increment,
1398 `type` tinyint(1) NOT NULL default '0',
1399 `description` varchar(60) NOT NULL,
1400 `base_amount` double NOT NULL default '0',
1401 `base_desc` varchar(60) default NULL,
1402 `bal_type` tinyint(1) NOT NULL default '0',
1404 KEY `description` (`description`)
1405 ) ENGINE=MyISAM AUTO_INCREMENT=4 ;
1408 -- Dumping data for table `0_quick_entries`
1411 INSERT INTO `0_quick_entries` VALUES(1, 1, 'Maintenance', 0, 'Amount', 0);
1412 INSERT INTO `0_quick_entries` VALUES(2, 4, 'Phone', 0, 'Amount', 0);
1413 INSERT INTO `0_quick_entries` VALUES(3, 2, 'Cash Sales', 0, 'Amount', 0);
1415 -- --------------------------------------------------------
1418 -- Table structure for table `0_quick_entry_lines`
1421 DROP TABLE IF EXISTS `0_quick_entry_lines`;
1422 CREATE TABLE IF NOT EXISTS `0_quick_entry_lines` (
1423 `id` smallint(6) unsigned NOT NULL auto_increment,
1424 `qid` smallint(6) unsigned NOT NULL,
1425 `amount` double default '0',
1426 `action` varchar(2) NOT NULL,
1427 `dest_id` varchar(15) NOT NULL default '',
1428 `dimension_id` smallint(6) unsigned default NULL,
1429 `dimension2_id` smallint(6) unsigned default NULL,
1432 ) ENGINE=MyISAM AUTO_INCREMENT=8 ;
1435 -- Dumping data for table `0_quick_entry_lines`
1438 INSERT INTO `0_quick_entry_lines` VALUES(1, 1, 0, 't-', '1', 0, 0);
1439 INSERT INTO `0_quick_entry_lines` VALUES(2, 2, 0, 't-', '1', 0, 0);
1440 INSERT INTO `0_quick_entry_lines` VALUES(3, 3, 0, 't-', '1', 0, 0);
1441 INSERT INTO `0_quick_entry_lines` VALUES(4, 3, 0, '=', '4010', 0, 0);
1442 INSERT INTO `0_quick_entry_lines` VALUES(5, 1, 0, '=', '5765', 0, 0);
1443 INSERT INTO `0_quick_entry_lines` VALUES(6, 2, 0, '=', '5780', 0, 0);
1445 -- --------------------------------------------------------
1448 -- Table structure for table `0_recurrent_invoices`
1451 DROP TABLE IF EXISTS `0_recurrent_invoices`;
1452 CREATE TABLE IF NOT EXISTS `0_recurrent_invoices` (
1453 `id` smallint(6) unsigned NOT NULL auto_increment,
1454 `description` varchar(60) NOT NULL default '',
1455 `order_no` int(11) unsigned NOT NULL,
1456 `debtor_no` int(11) unsigned default NULL,
1457 `group_no` smallint(6) unsigned default NULL,
1458 `days` int(11) NOT NULL default '0',
1459 `monthly` int(11) NOT NULL default '0',
1460 `begin` date NOT NULL default '0000-00-00',
1461 `end` date NOT NULL default '0000-00-00',
1462 `last_sent` date NOT NULL default '0000-00-00',
1464 UNIQUE KEY `description` (`description`)
1465 ) ENGINE=InnoDB AUTO_INCREMENT=1 ;
1468 -- Dumping data for table `0_recurrent_invoices`
1472 -- --------------------------------------------------------
1475 -- Table structure for table `0_refs`
1478 DROP TABLE IF EXISTS `0_refs`;
1479 CREATE TABLE IF NOT EXISTS `0_refs` (
1480 `id` int(11) NOT NULL default '0',
1481 `type` int(11) NOT NULL default '0',
1482 `reference` varchar(100) NOT NULL default '',
1483 PRIMARY KEY (`id`,`type`),
1484 KEY `Type_and_Reference` (`type`,`reference`)
1488 -- Dumping data for table `0_refs`
1491 INSERT INTO `0_refs` VALUES(18, 0, '1');
1492 INSERT INTO `0_refs` VALUES(19, 0, '2');
1494 -- --------------------------------------------------------
1497 -- Table structure for table `0_salesman`
1500 DROP TABLE IF EXISTS `0_salesman`;
1501 CREATE TABLE IF NOT EXISTS `0_salesman` (
1502 `salesman_code` int(11) NOT NULL auto_increment,
1503 `salesman_name` char(60) NOT NULL default '',
1504 `salesman_phone` char(30) NOT NULL default '',
1505 `salesman_fax` char(30) NOT NULL default '',
1506 `salesman_email` varchar(100) NOT NULL default '',
1507 `provision` double NOT NULL default '0',
1508 `break_pt` double NOT NULL default '0',
1509 `provision2` double NOT NULL default '0',
1510 `inactive` tinyint(1) NOT NULL default '0',
1511 PRIMARY KEY (`salesman_code`),
1512 UNIQUE KEY `salesman_name` (`salesman_name`)
1513 ) ENGINE=MyISAM AUTO_INCREMENT=2 ;
1516 -- Dumping data for table `0_salesman`
1519 INSERT INTO `0_salesman` VALUES(1, 'Sales Person', '', '', '', 5, 1000, 4, 0);
1521 -- --------------------------------------------------------
1524 -- Table structure for table `0_sales_orders`
1527 DROP TABLE IF EXISTS `0_sales_orders`;
1528 CREATE TABLE IF NOT EXISTS `0_sales_orders` (
1529 `order_no` int(11) NOT NULL,
1530 `trans_type` smallint(6) NOT NULL default '30',
1531 `version` tinyint(1) unsigned NOT NULL default '0',
1532 `type` tinyint(1) NOT NULL default '0',
1533 `debtor_no` int(11) NOT NULL default '0',
1534 `branch_code` int(11) NOT NULL default '0',
1535 `reference` varchar(100) NOT NULL default '',
1536 `customer_ref` tinytext NOT NULL,
1537 `comments` tinytext,
1538 `ord_date` date NOT NULL default '0000-00-00',
1539 `order_type` int(11) NOT NULL default '0',
1540 `ship_via` int(11) NOT NULL default '0',
1541 `delivery_address` tinytext NOT NULL,
1542 `contact_phone` varchar(30) default NULL,
1543 `contact_email` varchar(100) default NULL,
1544 `deliver_to` tinytext NOT NULL,
1545 `freight_cost` double NOT NULL default '0',
1546 `from_stk_loc` varchar(5) NOT NULL default '',
1547 `delivery_date` date NOT NULL default '0000-00-00',
1548 `payment_terms` int(11) default NULL,
1549 `total` double NOT NULL default '0',
1550 `prep_amount` double NOT NULL DEFAULT '0',
1551 `alloc` double NOT NULL DEFAULT '0',
1552 PRIMARY KEY (`trans_type`,`order_no`)
1556 -- Dumping data for table `0_sales_orders`
1559 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);
1560 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);
1561 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);
1562 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);
1563 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);
1565 -- --------------------------------------------------------
1568 -- Table structure for table `0_sales_order_details`
1571 DROP TABLE IF EXISTS `0_sales_order_details`;
1572 CREATE TABLE IF NOT EXISTS `0_sales_order_details` (
1573 `id` int(11) NOT NULL auto_increment,
1574 `order_no` int(11) NOT NULL default '0',
1575 `trans_type` smallint(6) NOT NULL default '30',
1576 `stk_code` varchar(20) NOT NULL default '',
1577 `description` tinytext,
1578 `qty_sent` double NOT NULL default '0',
1579 `unit_price` double NOT NULL default '0',
1580 `quantity` double NOT NULL default '0',
1581 `invoiced` double NOT NULL DEFAULT '0',
1582 `discount_percent` double NOT NULL default '0',
1584 KEY `sorder` (`trans_type`,`order_no`),
1585 KEY `stkcode` (`stk_code`)
1586 ) ENGINE=InnoDB AUTO_INCREMENT=6 ;
1589 -- Dumping data for table `0_sales_order_details`
1592 INSERT INTO `0_sales_order_details` VALUES(1, 1, 30, '102', '17inch VGA Monitor', 2, 30.4, 2, 0, 0);
1593 INSERT INTO `0_sales_order_details` VALUES(2, 2, 30, '102', '17inch VGA Monitor', 1, 50, 1, 0, 0);
1594 INSERT INTO `0_sales_order_details` VALUES(3, 3, 30, '102', '17inch VGA Monitor', 1, 35.89, 1, 0, 0);
1595 INSERT INTO `0_sales_order_details` VALUES(4, 4, 30, '102', '17inch VGA Monitor', 0, 21.28, 2, 0, 0);
1596 INSERT INTO `0_sales_order_details` VALUES(5, 5, 30, '102', '17inch VGA Monitor', 1, 50, 1, 0, 0);
1598 -- --------------------------------------------------------
1601 -- Table structure for table `0_sales_pos`
1604 DROP TABLE IF EXISTS `0_sales_pos`;
1605 CREATE TABLE IF NOT EXISTS `0_sales_pos` (
1606 `id` smallint(6) unsigned NOT NULL auto_increment,
1607 `pos_name` varchar(30) NOT NULL,
1608 `cash_sale` tinyint(1) NOT NULL,
1609 `credit_sale` tinyint(1) NOT NULL,
1610 `pos_location` varchar(5) NOT NULL,
1611 `pos_account` smallint(6) unsigned NOT NULL,
1612 `inactive` tinyint(1) NOT NULL default '0',
1614 UNIQUE KEY `pos_name` (`pos_name`)
1615 ) ENGINE=MyISAM AUTO_INCREMENT=2 ;
1618 -- Dumping data for table `0_sales_pos`
1621 INSERT INTO `0_sales_pos` VALUES(1, 'Default', 1, 1, 'DEF', 2, 0);
1623 -- --------------------------------------------------------
1626 -- Table structure for table `0_sales_types`
1629 DROP TABLE IF EXISTS `0_sales_types`;
1630 CREATE TABLE IF NOT EXISTS `0_sales_types` (
1631 `id` int(11) NOT NULL auto_increment,
1632 `sales_type` char(50) NOT NULL default '',
1633 `tax_included` int(1) NOT NULL default '0',
1634 `factor` double NOT NULL default '1',
1635 `inactive` tinyint(1) NOT NULL default '0',
1637 UNIQUE KEY `sales_type` (`sales_type`)
1638 ) ENGINE=MyISAM AUTO_INCREMENT=3 ;
1641 -- Dumping data for table `0_sales_types`
1644 INSERT INTO `0_sales_types` VALUES(1, 'Retail', 1, 1, 0);
1645 INSERT INTO `0_sales_types` VALUES(2, 'Wholesale', 0, 0.7, 0);
1647 -- --------------------------------------------------------
1650 -- Table structure for table `0_security_roles`
1653 DROP TABLE IF EXISTS `0_security_roles`;
1654 CREATE TABLE IF NOT EXISTS `0_security_roles` (
1655 `id` int(11) NOT NULL auto_increment,
1656 `role` varchar(30) NOT NULL,
1657 `description` varchar(50) default NULL,
1660 `inactive` tinyint(1) NOT NULL default '0',
1662 UNIQUE KEY `role` (`role`)
1663 ) ENGINE=MyISAM AUTO_INCREMENT=11 ;
1666 -- Dumping data for table `0_security_roles`
1669 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);
1670 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);
1671 INSERT INTO `0_security_roles` VALUES(3, 'Salesman', 'Salesman', '768;3072;5632;8192;15872', '773;774;3073;3075;3081;5633;8194;15873;775', 0);
1672 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);
1673 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);
1674 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);
1675 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);
1676 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);
1677 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);
1678 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);
1680 -- --------------------------------------------------------
1683 -- Table structure for table `0_shippers`
1686 DROP TABLE IF EXISTS `0_shippers`;
1687 CREATE TABLE IF NOT EXISTS `0_shippers` (
1688 `shipper_id` int(11) NOT NULL auto_increment,
1689 `shipper_name` varchar(60) NOT NULL default '',
1690 `phone` varchar(30) NOT NULL default '',
1691 `phone2` varchar(30) NOT NULL default '',
1692 `contact` tinytext NOT NULL,
1693 `address` tinytext NOT NULL,
1694 `inactive` tinyint(1) NOT NULL default '0',
1695 PRIMARY KEY (`shipper_id`),
1696 UNIQUE KEY `name` (`shipper_name`)
1697 ) ENGINE=MyISAM AUTO_INCREMENT=2 ;
1700 -- Dumping data for table `0_shippers`
1703 INSERT INTO `0_shippers` VALUES(1, 'Default', '', '', '', '', 0);
1705 -- --------------------------------------------------------
1708 -- Table structure for table `0_sql_trail`
1711 DROP TABLE IF EXISTS `0_sql_trail`;
1712 CREATE TABLE IF NOT EXISTS `0_sql_trail` (
1713 `id` int(11) unsigned NOT NULL auto_increment,
1714 `sql` text NOT NULL,
1715 `result` tinyint(1) NOT NULL,
1716 `msg` varchar(255) NOT NULL,
1718 ) ENGINE=MyISAM AUTO_INCREMENT=1 ;
1721 -- Dumping data for table `0_sql_trail`
1725 -- --------------------------------------------------------
1728 -- Table structure for table `0_stock_category`
1731 DROP TABLE IF EXISTS `0_stock_category`;
1732 CREATE TABLE IF NOT EXISTS `0_stock_category` (
1733 `category_id` int(11) NOT NULL auto_increment,
1734 `description` varchar(60) NOT NULL default '',
1735 `dflt_tax_type` int(11) NOT NULL default '1',
1736 `dflt_units` varchar(20) NOT NULL default 'each',
1737 `dflt_mb_flag` char(1) NOT NULL default 'B',
1738 `dflt_sales_act` varchar(15) NOT NULL default '',
1739 `dflt_cogs_act` varchar(15) NOT NULL default '',
1740 `dflt_inventory_act` varchar(15) NOT NULL default '',
1741 `dflt_adjustment_act` varchar(15) NOT NULL default '',
1742 `dflt_assembly_act` varchar(15) NOT NULL default '',
1743 `dflt_dim1` int(11) default NULL,
1744 `dflt_dim2` int(11) default NULL,
1745 `inactive` tinyint(1) NOT NULL default '0',
1746 `dflt_no_sale` tinyint(1) NOT NULL default '0',
1747 `dflt_no_purchase` tinyint(1) NOT NULL default '0',
1748 PRIMARY KEY (`category_id`),
1749 UNIQUE KEY `description` (`description`)
1750 ) ENGINE=MyISAM AUTO_INCREMENT=5 ;
1753 -- Dumping data for table `0_stock_category`
1756 INSERT INTO `0_stock_category` VALUES(1, 'Components', 1, 'each', 'B', '4010', '5010', '1510', '5040', '1530', 0, 0, 0, 0, 0);
1757 INSERT INTO `0_stock_category` VALUES(2, 'Charges', 1, 'each', 'D', '4010', '5010', '1510', '5040', '1530', 0, 0, 0, 0, 0);
1758 INSERT INTO `0_stock_category` VALUES(3, 'Systems', 1, 'each', 'M', '4010', '5010', '1510', '5040', '1530', 0, 0, 0, 0, 0);
1759 INSERT INTO `0_stock_category` VALUES(4, 'Services', 1, 'hrs', 'D', '4010', '5010', '1510', '5040', '1530', 0, 0, 0, 0, 0);
1761 -- --------------------------------------------------------
1764 -- Table structure for table `0_stock_master`
1767 DROP TABLE IF EXISTS `0_stock_master`;
1768 CREATE TABLE IF NOT EXISTS `0_stock_master` (
1769 `stock_id` varchar(20) NOT NULL default '',
1770 `category_id` int(11) NOT NULL default '0',
1771 `tax_type_id` int(11) NOT NULL default '0',
1772 `description` varchar(200) NOT NULL default '',
1773 `long_description` tinytext NOT NULL,
1774 `units` varchar(20) NOT NULL default 'each',
1775 `mb_flag` char(1) NOT NULL default 'B',
1776 `sales_account` varchar(15) NOT NULL default '',
1777 `cogs_account` varchar(15) NOT NULL default '',
1778 `inventory_account` varchar(15) NOT NULL default '',
1779 `adjustment_account` varchar(15) NOT NULL default '',
1780 `assembly_account` varchar(15) NOT NULL default '',
1781 `dimension_id` int(11) default NULL,
1782 `dimension2_id` int(11) default NULL,
1783 `actual_cost` double NOT NULL default '0',
1784 `last_cost` double NOT NULL default '0',
1785 `material_cost` double NOT NULL default '0',
1786 `labour_cost` double NOT NULL default '0',
1787 `overhead_cost` double NOT NULL default '0',
1788 `inactive` tinyint(1) NOT NULL default '0',
1789 `no_sale` tinyint(1) NOT NULL default '0',
1790 `no_purchase` tinyint(1) NOT NULL default '0',
1791 `editable` tinyint(1) NOT NULL default '0',
1792 PRIMARY KEY (`stock_id`)
1796 -- Dumping data for table `0_stock_master`
1799 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);
1800 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);
1801 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);
1802 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);
1803 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);
1805 -- --------------------------------------------------------
1808 -- Table structure for table `0_stock_moves`
1811 DROP TABLE IF EXISTS `0_stock_moves`;
1812 CREATE TABLE IF NOT EXISTS `0_stock_moves` (
1813 `trans_id` int(11) NOT NULL auto_increment,
1814 `trans_no` int(11) NOT NULL default '0',
1815 `stock_id` char(20) NOT NULL default '',
1816 `type` smallint(6) NOT NULL default '0',
1817 `loc_code` char(5) NOT NULL default '',
1818 `tran_date` date NOT NULL default '0000-00-00',
1819 `person_id` int(11) default NULL,
1820 `price` double NOT NULL default '0',
1821 `reference` char(40) NOT NULL default '',
1822 `qty` double NOT NULL default '1',
1823 `discount_percent` double NOT NULL default '0',
1824 `standard_cost` double NOT NULL default '0',
1825 `visible` tinyint(1) NOT NULL default '1',
1826 PRIMARY KEY (`trans_id`),
1827 KEY `type` (`type`,`trans_no`),
1828 KEY `Move` (`stock_id`,`loc_code`,`tran_date`)
1829 ) ENGINE=InnoDB AUTO_INCREMENT=37 ;
1832 -- Dumping data for table `0_stock_moves`
1835 INSERT INTO `0_stock_moves` VALUES(1, 1, '102', 25, 'DEF', '2009-06-21', 2, 10, '', 100, 0, 10, 1);
1836 INSERT INTO `0_stock_moves` VALUES(2, 1, '103', 25, 'DEF', '2009-06-21', 2, 11, '', 100, 0, 11, 1);
1837 INSERT INTO `0_stock_moves` VALUES(3, 1, '104', 25, 'DEF', '2009-06-21', 2, 12, '', 100, 0, 12, 1);
1838 INSERT INTO `0_stock_moves` VALUES(4, 1, '102', 26, 'DEF', '2009-06-21', 0, 0, '1', -10, 0, 0, 1);
1839 INSERT INTO `0_stock_moves` VALUES(5, 1, '103', 26, 'DEF', '2009-06-21', 0, 0, '1', -10, 0, 0, 1);
1840 INSERT INTO `0_stock_moves` VALUES(6, 1, '104', 26, 'DEF', '2009-06-21', 0, 0, '1', -10, 0, 0, 1);
1841 INSERT INTO `0_stock_moves` VALUES(7, 1, '3400', 26, 'DEF', '2009-06-21', 0, 0, '1', 10, 0, 0, 1);
1842 INSERT INTO `0_stock_moves` VALUES(8, 2, '102', 13, 'DEF', '2009-06-21', 0, 30.4, '1', -2, 0, 10, 1);
1843 INSERT INTO `0_stock_moves` VALUES(9, 3, '102', 13, 'DEF', '2009-06-21', 0, 50, 'auto', -1, 0, 10, 1);
1844 INSERT INTO `0_stock_moves` VALUES(10, 4, '102', 13, 'DEF', '2009-06-21', 0, 35.89, 'auto', -1, 0, 10, 1);
1845 INSERT INTO `0_stock_moves` VALUES(11, 3, '102', 26, 'DEF', '2009-06-21', 0, 0, '3', -2, 0, 0, 1);
1846 INSERT INTO `0_stock_moves` VALUES(12, 3, '103', 26, 'DEF', '2009-06-21', 0, 0, '3', -2, 0, 0, 1);
1847 INSERT INTO `0_stock_moves` VALUES(13, 3, '104', 26, 'DEF', '2009-06-21', 0, 0, '3', -2, 0, 0, 1);
1848 INSERT INTO `0_stock_moves` VALUES(14, 3, '3400', 26, 'DEF', '2009-06-21', 0, 0, '3', 2, 0, 0, 1);
1849 INSERT INTO `0_stock_moves` VALUES(15, 4, '102', 26, 'DEF', '2009-06-21', 0, 0, '4', -4, 0, 0, 1);
1850 INSERT INTO `0_stock_moves` VALUES(16, 4, '103', 26, 'DEF', '2009-06-21', 0, 0, '4', -4, 0, 0, 1);
1851 INSERT INTO `0_stock_moves` VALUES(17, 4, '104', 26, 'DEF', '2009-06-21', 0, 0, '4', -4, 0, 0, 1);
1852 INSERT INTO `0_stock_moves` VALUES(18, 4, '3400', 26, 'DEF', '2009-06-21', 0, 0, '4', 4, 0, 0, 1);
1853 INSERT INTO `0_stock_moves` VALUES(19, 2, '102', 26, 'DEF', '2009-06-21', 0, 0, '', -2, 0, 0, 1);
1854 INSERT INTO `0_stock_moves` VALUES(20, 2, '103', 26, 'DEF', '2009-06-21', 0, 0, '', -2, 0, 0, 1);
1855 INSERT INTO `0_stock_moves` VALUES(21, 2, '104', 26, 'DEF', '2009-06-21', 0, 0, '', -2, 0, 0, 1);
1856 INSERT INTO `0_stock_moves` VALUES(22, 1, '3400', 29, 'DEF', '2009-06-21', 0, 0, '', 2, 0, 0, 1);
1857 INSERT INTO `0_stock_moves` VALUES(23, 5, '102', 26, 'DEF', '2009-06-21', 0, 0, '5', -5, 0, 0, 1);
1858 INSERT INTO `0_stock_moves` VALUES(24, 5, '103', 26, 'DEF', '2009-06-21', 0, 0, '5', -5, 0, 0, 1);
1859 INSERT INTO `0_stock_moves` VALUES(25, 5, '104', 26, 'DEF', '2009-06-21', 0, 0, '5', -5, 0, 0, 1);
1860 INSERT INTO `0_stock_moves` VALUES(26, 5, '3400', 26, 'DEF', '2009-06-21', 0, 0, '5', 5, 0, 0, 1);
1861 INSERT INTO `0_stock_moves` VALUES(27, 6, '102', 26, 'DEF', '2009-06-21', 0, 0, '6', 5, 0, 0, 1);
1862 INSERT INTO `0_stock_moves` VALUES(28, 6, '103', 26, 'DEF', '2009-06-21', 0, 0, '6', 5, 0, 0, 1);
1863 INSERT INTO `0_stock_moves` VALUES(29, 6, '104', 26, 'DEF', '2009-06-21', 0, 0, '6', 5, 0, 0, 1);
1864 INSERT INTO `0_stock_moves` VALUES(30, 6, '3400', 26, 'DEF', '2009-06-21', 0, 0, '6', -5, 0, 0, 1);
1865 INSERT INTO `0_stock_moves` VALUES(31, 7, '102', 26, 'DEF', '2009-06-21', 0, 0, '7', 2, 0, 0, 1);
1866 INSERT INTO `0_stock_moves` VALUES(32, 7, '103', 26, 'DEF', '2009-06-21', 0, 0, '7', 2, 0, 0, 1);
1867 INSERT INTO `0_stock_moves` VALUES(33, 7, '104', 26, 'DEF', '2009-06-21', 0, 0, '7', 2, 0, 0, 1);
1868 INSERT INTO `0_stock_moves` VALUES(34, 7, '3400', 26, 'DEF', '2009-06-21', 0, 0, '7', -2, 0, 0, 1);
1869 INSERT INTO `0_stock_moves` VALUES(35, 5, '102', 13, 'DEF', '2009-06-21', 0, 50, 'auto', -1, 0, 10, 1);
1870 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);
1872 -- --------------------------------------------------------
1875 -- Table structure for table `0_suppliers`
1878 DROP TABLE IF EXISTS `0_suppliers`;
1879 CREATE TABLE IF NOT EXISTS `0_suppliers` (
1880 `supplier_id` int(11) NOT NULL auto_increment,
1881 `supp_name` varchar(60) NOT NULL default '',
1882 `supp_ref` varchar(30) NOT NULL default '',
1883 `address` tinytext NOT NULL,
1884 `supp_address` tinytext NOT NULL,
1885 `gst_no` varchar(25) NOT NULL default '',
1886 `contact` varchar(60) NOT NULL default '',
1887 `supp_account_no` varchar(40) NOT NULL default '',
1888 `website` varchar(100) NOT NULL default '',
1889 `bank_account` varchar(60) NOT NULL default '',
1890 `curr_code` char(3) default NULL,
1891 `payment_terms` int(11) default NULL,
1892 `tax_included` tinyint(1) NOT NULL default '0',
1893 `tax_algorithm` tinyint(1) NOT NULL default '1',
1894 `dimension_id` int(11) default '0',
1895 `dimension2_id` int(11) default '0',
1896 `tax_group_id` int(11) default NULL,
1897 `credit_limit` double NOT NULL default '0',
1898 `purchase_account` varchar(15) NOT NULL default '',
1899 `payable_account` varchar(15) NOT NULL default '',
1900 `payment_discount_account` varchar(15) NOT NULL default '',
1901 `notes` tinytext NOT NULL,
1902 `inactive` tinyint(1) NOT NULL default '0',
1903 PRIMARY KEY (`supplier_id`),
1904 KEY `supp_ref` (`supp_ref`)
1905 ) ENGINE=MyISAM AUTO_INCREMENT=4 ;
1908 -- Dumping data for table `0_suppliers`
1911 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);
1912 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);
1913 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);
1915 -- --------------------------------------------------------
1918 -- Table structure for table `0_supp_allocations`
1921 DROP TABLE IF EXISTS `0_supp_allocations`;
1922 CREATE TABLE IF NOT EXISTS `0_supp_allocations` (
1923 `id` int(11) NOT NULL auto_increment,
1924 `amt` double unsigned default NULL,
1925 `date_alloc` date NOT NULL default '0000-00-00',
1926 `trans_no_from` int(11) default NULL,
1927 `trans_type_from` int(11) default NULL,
1928 `trans_no_to` int(11) default NULL,
1929 `trans_type_to` int(11) default NULL,
1931 UNIQUE KEY (`trans_type_from`,`trans_no_from`,`trans_type_to`,`trans_no_to`),
1932 KEY `From` (`trans_type_from`,`trans_no_from`),
1933 KEY `To` (`trans_type_to`,`trans_no_to`)
1934 ) ENGINE=InnoDB AUTO_INCREMENT=2 ;
1937 -- Dumping data for table `0_supp_allocations`
1940 INSERT INTO `0_supp_allocations` VALUES(1, 3465, '2009-06-21', 4, 22, 7, 20);
1942 -- --------------------------------------------------------
1945 -- Table structure for table `0_supp_invoice_items`
1948 DROP TABLE IF EXISTS `0_supp_invoice_items`;
1949 CREATE TABLE IF NOT EXISTS `0_supp_invoice_items` (
1950 `id` int(11) NOT NULL auto_increment,
1951 `supp_trans_no` int(11) default NULL,
1952 `supp_trans_type` int(11) default NULL,
1953 `gl_code` varchar(15) NOT NULL default '',
1954 `grn_item_id` int(11) default NULL,
1955 `po_detail_item_id` int(11) default NULL,
1956 `stock_id` varchar(20) NOT NULL default '',
1957 `description` tinytext,
1958 `quantity` double NOT NULL default '0',
1959 `unit_price` double NOT NULL default '0',
1960 `unit_tax` double NOT NULL default '0',
1963 KEY `Transaction` (`supp_trans_type`,`supp_trans_no`,`stock_id`)
1964 ) ENGINE=InnoDB AUTO_INCREMENT=6 ;
1967 -- Dumping data for table `0_supp_invoice_items`
1970 INSERT INTO `0_supp_invoice_items` VALUES(1, 7, 20, '0', 1, 1, '102', '17inch VGA Monitor', 100, 10, 0.5, '');
1971 INSERT INTO `0_supp_invoice_items` VALUES(2, 7, 20, '0', 2, 2, '103', '32MB VGA Card', 100, 11, 0.55, '');
1972 INSERT INTO `0_supp_invoice_items` VALUES(3, 7, 20, '0', 3, 3, '104', '52x CD Drive', 100, 12, 0.6, '');
1973 INSERT INTO `0_supp_invoice_items` VALUES(4, 8, 20, '2150', 0, 0, '', '', 0, 0.95, 0, 'Phone');
1974 INSERT INTO `0_supp_invoice_items` VALUES(5, 8, 20, '5780', 0, 0, '', '', 0, 19.05, 0, 'Phone');
1976 -- --------------------------------------------------------
1979 -- Table structure for table `0_supp_trans`
1982 DROP TABLE IF EXISTS `0_supp_trans`;
1983 CREATE TABLE IF NOT EXISTS `0_supp_trans` (
1984 `trans_no` int(11) unsigned NOT NULL default '0',
1985 `type` smallint(6) unsigned NOT NULL default '0',
1986 `supplier_id` int(11) unsigned default NULL,
1987 `reference` tinytext NOT NULL,
1988 `supp_reference` varchar(60) NOT NULL default '',
1989 `tran_date` date NOT NULL default '0000-00-00',
1990 `due_date` date NOT NULL default '0000-00-00',
1991 `ov_amount` double NOT NULL default '0',
1992 `ov_discount` double NOT NULL default '0',
1993 `ov_gst` double NOT NULL default '0',
1994 `rate` double NOT NULL default '1',
1995 `alloc` double NOT NULL default '0',
1996 `tax_included` tinyint(1) NOT NULL default '0',
1997 `tax_algorithm` tinyint(1) NOT NULL default '1',
1998 PRIMARY KEY (`type`,`trans_no`),
1999 KEY `supplier_id` (`supplier_id`),
2000 KEY `SupplierID_2` (`supplier_id`,`supp_reference`),
2001 KEY `type` (`type`),
2002 KEY `tran_date` (`tran_date`)
2006 -- Dumping data for table `0_supp_trans`
2009 INSERT INTO `0_supp_trans` VALUES(7, 20, 2, '1', '5t', '2009-06-21', '2009-07-01', 3300, 0, 165, 1, 3465, 0, 1);
2010 INSERT INTO `0_supp_trans` VALUES(8, 20, 2, '2', 'cc', '2009-06-21', '2009-07-01', 20, 0, 0, 1, 0, 0, 1);
2011 INSERT INTO `0_supp_trans` VALUES(4, 22, 2, '1', '', '2009-06-21', '2009-06-21', -3465, 0, 0, 1, 3465, 0, 1);
2013 -- --------------------------------------------------------
2016 -- Table structure for table `0_sys_prefs`
2019 DROP TABLE IF EXISTS `0_sys_prefs`;
2020 CREATE TABLE IF NOT EXISTS `0_sys_prefs` (
2021 `name` varchar(35) NOT NULL default '',
2022 `category` varchar(30) default NULL,
2023 `type` varchar(20) NOT NULL default '',
2024 `length` smallint(6) default NULL,
2025 `value` text NOT NULL,
2026 PRIMARY KEY (`name`),
2027 KEY `category` (`category`)
2031 -- Dumping data for table `0_sys_prefs`
2034 INSERT INTO `0_sys_prefs` VALUES('coy_name', 'setup.company', 'varchar', 60, 'Training Co.');
2035 INSERT INTO `0_sys_prefs` VALUES('gst_no', 'setup.company', 'varchar', 25, '9876543');
2036 INSERT INTO `0_sys_prefs` VALUES('coy_no', 'setup.company', 'varchar', 25, '123456789');
2037 INSERT INTO `0_sys_prefs` VALUES('tax_prd', 'setup.company', 'int', 11, '1');
2038 INSERT INTO `0_sys_prefs` VALUES('tax_last', 'setup.company', 'int', 11, '1');
2039 INSERT INTO `0_sys_prefs` VALUES('postal_address', 'setup.company', 'tinytext', 0, 'Address 1\nAddress 2\nAddress 3');
2040 INSERT INTO `0_sys_prefs` VALUES('phone', 'setup.company', 'varchar', 30, '(222) 111.222.333');
2041 INSERT INTO `0_sys_prefs` VALUES('fax', 'setup.company', 'varchar', 30, '');
2042 INSERT INTO `0_sys_prefs` VALUES('email', 'setup.company', 'varchar', 100, 'delta@delta.com');
2043 INSERT INTO `0_sys_prefs` VALUES('coy_logo', 'setup.company', 'varchar', 100, 'logo_frontaccounting.jpg');
2044 INSERT INTO `0_sys_prefs` VALUES('domicile', 'setup.company', 'varchar', 55, '');
2045 INSERT INTO `0_sys_prefs` VALUES('curr_default', 'setup.company', 'char', 3, 'USD');
2046 INSERT INTO `0_sys_prefs` VALUES('use_dimension', 'setup.company', 'tinyint', 1, '1');
2047 INSERT INTO `0_sys_prefs` VALUES('f_year', 'setup.company', 'int', 11, '6');
2048 INSERT INTO `0_sys_prefs` VALUES('no_item_list', 'setup.company', 'tinyint', 1, '0');
2049 INSERT INTO `0_sys_prefs` VALUES('no_customer_list', 'setup.company', 'tinyint', 1, '0');
2050 INSERT INTO `0_sys_prefs` VALUES('no_supplier_list', 'setup.company', 'tinyint', 1, '0');
2051 INSERT INTO `0_sys_prefs` VALUES('base_sales', 'setup.company', 'int', 11, '1');
2052 INSERT INTO `0_sys_prefs` VALUES('time_zone', 'setup.company', 'tinyint', 1, '0');
2053 INSERT INTO `0_sys_prefs` VALUES('add_pct', 'setup.company', 'int', 5, '-1');
2054 INSERT INTO `0_sys_prefs` VALUES('round_to', 'setup.company', 'int', 5, '1');
2055 INSERT INTO `0_sys_prefs` VALUES('login_tout', 'setup.company', 'smallint', 6, '600');
2056 INSERT INTO `0_sys_prefs` VALUES('past_due_days', 'glsetup.general', 'int', 11, '30');
2057 INSERT INTO `0_sys_prefs` VALUES('profit_loss_year_act', 'glsetup.general', 'varchar', 15, '9990');
2058 INSERT INTO `0_sys_prefs` VALUES('retained_earnings_act', 'glsetup.general', 'varchar', 15, '3590');
2059 INSERT INTO `0_sys_prefs` VALUES('bank_charge_act', 'glsetup.general', 'varchar', 15, '5690');
2060 INSERT INTO `0_sys_prefs` VALUES('exchange_diff_act', 'glsetup.general', 'varchar', 15, '4450');
2061 INSERT INTO `0_sys_prefs` VALUES('tax_algorithm', 'glsetup.customer', 'tinyint', 1, '1');
2062 INSERT INTO `0_sys_prefs` VALUES('default_credit_limit', 'glsetup.customer', 'int', 11, '1000');
2063 INSERT INTO `0_sys_prefs` VALUES('accumulate_shipping', 'glsetup.customer', 'tinyint', 1, '0');
2064 INSERT INTO `0_sys_prefs` VALUES('legal_text', 'glsetup.customer', 'tinytext', 0, '');
2065 INSERT INTO `0_sys_prefs` VALUES('freight_act', 'glsetup.customer', 'varchar', 15, '4430');
2066 INSERT INTO `0_sys_prefs` VALUES('debtors_act', 'glsetup.sales', 'varchar', 15, '1200');
2067 INSERT INTO `0_sys_prefs` VALUES('default_sales_act', 'glsetup.sales', 'varchar', 15, '4010');
2068 INSERT INTO `0_sys_prefs` VALUES('default_sales_discount_act', 'glsetup.sales', 'varchar', 15, '4510');
2069 INSERT INTO `0_sys_prefs` VALUES('default_prompt_payment_act', 'glsetup.sales', 'varchar', 15, '4500');
2070 INSERT INTO `0_sys_prefs` VALUES('default_delivery_required', 'glsetup.sales', 'smallint', 6, '1');
2071 INSERT INTO `0_sys_prefs` VALUES('default_receival_required', 'glsetup.purchase', 'smallint', 6, '10');
2072 INSERT INTO `0_sys_prefs` VALUES('default_dim_required', 'glsetup.dims', 'int', 11, '20');
2073 INSERT INTO `0_sys_prefs` VALUES('pyt_discount_act', 'glsetup.purchase', 'varchar', 15, '5060');
2074 INSERT INTO `0_sys_prefs` VALUES('creditors_act', 'glsetup.purchase', 'varchar', 15, '2100');
2075 INSERT INTO `0_sys_prefs` VALUES('po_over_receive', 'glsetup.purchase', 'int', 11, '10');
2076 INSERT INTO `0_sys_prefs` VALUES('po_over_charge', 'glsetup.purchase', 'int', 11, '10');
2077 INSERT INTO `0_sys_prefs` VALUES('allow_negative_stock', 'glsetup.inventory', 'tinyint', 1, '0');
2078 INSERT INTO `0_sys_prefs` VALUES('default_inventory_act', 'glsetup.items', 'varchar', 15, '1510');
2079 INSERT INTO `0_sys_prefs` VALUES('default_cogs_act', 'glsetup.items', 'varchar', 15, '5010');
2080 INSERT INTO `0_sys_prefs` VALUES('default_adj_act', 'glsetup.items', 'varchar', 15, '5040');
2081 INSERT INTO `0_sys_prefs` VALUES('default_inv_sales_act', 'glsetup.items', 'varchar', 15, '4010');
2082 INSERT INTO `0_sys_prefs` VALUES('default_assembly_act', 'glsetup.items', 'varchar', 15, '1530');
2083 INSERT INTO `0_sys_prefs` VALUES('default_workorder_required', 'glsetup.manuf', 'int', 11, '20');
2084 INSERT INTO `0_sys_prefs` VALUES('version_id', 'system', 'varchar', 11, '2.3rc');
2085 INSERT INTO `0_sys_prefs` VALUES('auto_curr_reval', 'setup.company', 'smallint', 6, '1');
2086 INSERT INTO `0_sys_prefs` VALUES('grn_clearing_act', 'glsetup.purchase', 'varchar', 15, '1550');
2087 INSERT INTO `0_sys_prefs` VALUES('bcc_email', 'setup.company', 'varchar', 100, '');
2088 INSERT INTO `0_sys_prefs` VALUES('deferred_income_act', 'glsetup.sales', 'varchar', '15', '');
2089 INSERT INTO `0_sys_prefs` VALUES('gl_closing_date','setup.closing_date', 'date', 8, '');
2091 -- --------------------------------------------------------
2094 -- Table structure for table `0_sys_types`
2097 DROP TABLE IF EXISTS `0_sys_types`;
2098 CREATE TABLE IF NOT EXISTS `0_sys_types` (
2099 `type_id` smallint(6) NOT NULL default '0',
2100 `type_no` int(11) NOT NULL default '1',
2101 `next_reference` varchar(100) NOT NULL default '',
2102 PRIMARY KEY (`type_id`)
2106 -- Dumping data for table `0_sys_types`
2109 INSERT INTO `0_sys_types` VALUES(0, 19, '3');
2110 INSERT INTO `0_sys_types` VALUES(1, 8, '2');
2111 INSERT INTO `0_sys_types` VALUES(2, 5, '2');
2112 INSERT INTO `0_sys_types` VALUES(4, 3, '1');
2113 INSERT INTO `0_sys_types` VALUES(10, 19, '4');
2114 INSERT INTO `0_sys_types` VALUES(11, 3, '2');
2115 INSERT INTO `0_sys_types` VALUES(12, 6, '1');
2116 INSERT INTO `0_sys_types` VALUES(13, 5, '2');
2117 INSERT INTO `0_sys_types` VALUES(16, 2, '1');
2118 INSERT INTO `0_sys_types` VALUES(17, 2, '1');
2119 INSERT INTO `0_sys_types` VALUES(18, 1, '3');
2120 INSERT INTO `0_sys_types` VALUES(20, 8, '3');
2121 INSERT INTO `0_sys_types` VALUES(21, 1, '1');
2122 INSERT INTO `0_sys_types` VALUES(22, 4, '2');
2123 INSERT INTO `0_sys_types` VALUES(25, 1, '2');
2124 INSERT INTO `0_sys_types` VALUES(26, 1, '8');
2125 INSERT INTO `0_sys_types` VALUES(28, 1, '1');
2126 INSERT INTO `0_sys_types` VALUES(29, 1, '2');
2127 INSERT INTO `0_sys_types` VALUES(30, 5, '6');
2128 INSERT INTO `0_sys_types` VALUES(32, 0, '1');
2129 INSERT INTO `0_sys_types` VALUES(35, 1, '1');
2130 INSERT INTO `0_sys_types` VALUES(40, 1, '3');
2132 -- --------------------------------------------------------
2135 -- Table structure for table `0_tags`
2138 DROP TABLE IF EXISTS `0_tags`;
2139 CREATE TABLE IF NOT EXISTS `0_tags` (
2140 `id` int(11) NOT NULL auto_increment,
2141 `type` smallint(6) NOT NULL,
2142 `name` varchar(30) NOT NULL,
2143 `description` varchar(60) default NULL,
2144 `inactive` tinyint(1) NOT NULL default '0',
2146 UNIQUE KEY `type` (`type`,`name`)
2147 ) ENGINE=MyISAM AUTO_INCREMENT=1 ;
2150 -- Dumping data for table `0_tags`
2154 -- --------------------------------------------------------
2157 -- Table structure for table `0_tag_associations`
2160 DROP TABLE IF EXISTS `0_tag_associations`;
2161 CREATE TABLE IF NOT EXISTS `0_tag_associations` (
2162 `record_id` varchar(15) NOT NULL,
2163 `tag_id` int(11) NOT NULL,
2164 UNIQUE KEY `record_id` (`record_id`,`tag_id`)
2168 -- Dumping data for table `0_tag_associations`
2172 -- --------------------------------------------------------
2175 -- Table structure for table `0_tax_groups`
2178 DROP TABLE IF EXISTS `0_tax_groups`;
2179 CREATE TABLE IF NOT EXISTS `0_tax_groups` (
2180 `id` int(11) NOT NULL auto_increment,
2181 `name` varchar(60) NOT NULL default '',
2182 `inactive` tinyint(1) NOT NULL default '0',
2184 UNIQUE KEY `name` (`name`)
2185 ) ENGINE=InnoDB AUTO_INCREMENT=3 ;
2188 -- Dumping data for table `0_tax_groups`
2191 INSERT INTO `0_tax_groups` VALUES(1, 'Tax', 0);
2192 INSERT INTO `0_tax_groups` VALUES(2, 'Tax Exempt', 0);
2194 -- --------------------------------------------------------
2197 -- Table structure for table `0_tax_group_items`
2200 DROP TABLE IF EXISTS `0_tax_group_items`;
2201 CREATE TABLE IF NOT EXISTS `0_tax_group_items` (
2202 `tax_group_id` int(11) NOT NULL default '0',
2203 `tax_type_id` int(11) NOT NULL default '0',
2204 `tax_shipping` tinyint(1) NOT NULL default '0',
2205 PRIMARY KEY (`tax_group_id`,`tax_type_id`)
2209 -- Dumping data for table `0_tax_group_items`
2212 INSERT INTO `0_tax_group_items` VALUES(1, 1, 1);
2214 -- --------------------------------------------------------
2217 -- Table structure for table `0_tax_types`
2220 DROP TABLE IF EXISTS `0_tax_types`;
2221 CREATE TABLE IF NOT EXISTS `0_tax_types` (
2222 `id` int(11) NOT NULL auto_increment,
2223 `rate` double NOT NULL default '0',
2224 `sales_gl_code` varchar(15) NOT NULL default '',
2225 `purchasing_gl_code` varchar(15) NOT NULL default '',
2226 `name` varchar(60) NOT NULL default '',
2227 `inactive` tinyint(1) NOT NULL default '0',
2229 ) ENGINE=InnoDB AUTO_INCREMENT=2 ;
2232 -- Dumping data for table `0_tax_types`
2235 INSERT INTO `0_tax_types` VALUES(1, 5, '2150', '2150', 'Tax', 0);
2237 -- --------------------------------------------------------
2240 -- Table structure for table `0_trans_tax_details`
2243 DROP TABLE IF EXISTS `0_trans_tax_details`;
2244 CREATE TABLE IF NOT EXISTS `0_trans_tax_details` (
2245 `id` int(11) NOT NULL auto_increment,
2246 `trans_type` smallint(6) default NULL,
2247 `trans_no` int(11) default NULL,
2248 `tran_date` date NOT NULL,
2249 `tax_type_id` int(11) NOT NULL default '0',
2250 `rate` double NOT NULL default '0',
2251 `ex_rate` double NOT NULL default '1',
2252 `included_in_price` tinyint(1) NOT NULL default '0',
2253 `net_amount` double NOT NULL default '0',
2254 `amount` double NOT NULL default '0',
2257 KEY `Type_and_Number` (`trans_type`,`trans_no`),
2258 KEY `tran_date` (`tran_date`)
2259 ) ENGINE=InnoDB AUTO_INCREMENT=12 ;
2262 -- Dumping data for table `0_trans_tax_details`
2265 INSERT INTO `0_trans_tax_details` VALUES(1, 20, 7, '2009-06-21', 1, 5, 1, 0, 3300, 165, '5t');
2266 INSERT INTO `0_trans_tax_details` VALUES(2, 13, 3, '2009-06-21', 1, 5, 1, 0, 50, 2.5, 'auto');
2267 INSERT INTO `0_trans_tax_details` VALUES(3, 10, 17, '2009-06-21', 1, 5, 1, 0, 50, 2.5, '1');
2268 INSERT INTO `0_trans_tax_details` VALUES(4, 13, 4, '2009-06-21', 1, 5, 1.3932, 0, 35.89, 1.7945, 'auto');
2269 INSERT INTO `0_trans_tax_details` VALUES(5, 10, 18, '2009-06-21', 1, 5, 1.3932, 0, 35.89, 1.7945, '2');
2270 INSERT INTO `0_trans_tax_details` VALUES(6, 2, 5, '2009-06-21', 1, 5, 1, 0, 95.2, 4.76, '');
2271 INSERT INTO `0_trans_tax_details` VALUES(7, 1, 8, '2009-06-21', 1, 5, 1, 0, -47.6, -2.38, '');
2272 INSERT INTO `0_trans_tax_details` VALUES(8, 20, 8, '2009-06-21', 1, 5, 1, 0, -19, -0.95, 'cc');
2273 INSERT INTO `0_trans_tax_details` VALUES(9, 13, 5, '2009-06-21', 1, 5, 1, 1, 47.619047619048, 2.3809523809524, 'auto');
2274 INSERT INTO `0_trans_tax_details` VALUES(10, 10, 19, '2009-06-21', 1, 5, 1, 1, 47.619047619048, 2.3809523809524, '3');
2275 INSERT INTO `0_trans_tax_details` VALUES(11, 11, 3, '2009-06-21', 1, 5, 1.3932, 0, 35.89, 1.7945, '1');
2277 -- --------------------------------------------------------
2280 -- Table structure for table `0_useronline`
2283 DROP TABLE IF EXISTS `0_useronline`;
2284 CREATE TABLE IF NOT EXISTS `0_useronline` (
2285 `id` int(11) NOT NULL auto_increment,
2286 `timestamp` int(15) NOT NULL default '0',
2287 `ip` varchar(40) NOT NULL default '',
2288 `file` varchar(100) NOT NULL default '',
2290 KEY `timestamp` (`timestamp`),
2292 ) ENGINE=MyISAM AUTO_INCREMENT=1 ;
2295 -- Dumping data for table `0_useronline`
2299 -- --------------------------------------------------------
2302 -- Table structure for table `0_users`
2305 DROP TABLE IF EXISTS `0_users`;
2306 CREATE TABLE IF NOT EXISTS `0_users` (
2307 `id` smallint(6) NOT NULL auto_increment,
2308 `user_id` varchar(60) NOT NULL default '',
2309 `password` varchar(100) NOT NULL default '',
2310 `real_name` varchar(100) NOT NULL default '',
2311 `role_id` int(11) NOT NULL default '1',
2312 `phone` varchar(30) NOT NULL default '',
2313 `email` varchar(100) default NULL,
2314 `language` varchar(20) default NULL,
2315 `date_format` tinyint(1) NOT NULL default '0',
2316 `date_sep` tinyint(1) NOT NULL default '0',
2317 `tho_sep` tinyint(1) NOT NULL default '0',
2318 `dec_sep` tinyint(1) NOT NULL default '0',
2319 `theme` varchar(20) NOT NULL default 'default',
2320 `page_size` varchar(20) NOT NULL default 'A4',
2321 `prices_dec` smallint(6) NOT NULL default '2',
2322 `qty_dec` smallint(6) NOT NULL default '2',
2323 `rates_dec` smallint(6) NOT NULL default '4',
2324 `percent_dec` smallint(6) NOT NULL default '1',
2325 `show_gl` tinyint(1) NOT NULL default '1',
2326 `show_codes` tinyint(1) NOT NULL default '0',
2327 `show_hints` tinyint(1) NOT NULL default '0',
2328 `last_visit_date` datetime default NULL,
2329 `query_size` tinyint(1) unsigned default '10',
2330 `graphic_links` tinyint(1) default '1',
2331 `pos` smallint(6) default '1',
2332 `print_profile` varchar(30) NOT NULL default '1',
2333 `rep_popup` tinyint(1) default '1',
2334 `sticky_doc_date` tinyint(1) default '0',
2335 `startup_tab` varchar(20) NOT NULL default '',
2336 `transaction_days` smallint(6) NOT NULL default '30',
2337 `inactive` tinyint(1) NOT NULL default '0',
2339 UNIQUE KEY `user_id` (`user_id`)
2340 ) ENGINE=MyISAM AUTO_INCREMENT=3 ;
2343 -- Dumping data for table `0_users`
2346 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);
2347 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);
2349 -- --------------------------------------------------------
2352 -- Table structure for table `0_voided`
2355 DROP TABLE IF EXISTS `0_voided`;
2356 CREATE TABLE IF NOT EXISTS `0_voided` (
2357 `type` int(11) NOT NULL default '0',
2358 `id` int(11) NOT NULL default '0',
2359 `date_` date NOT NULL default '0000-00-00',
2360 `memo_` tinytext NOT NULL,
2361 UNIQUE KEY `id` (`type`,`id`)
2365 -- Dumping data for table `0_voided`
2369 -- --------------------------------------------------------
2372 -- Table structure for table `0_workcentres`
2375 DROP TABLE IF EXISTS `0_workcentres`;
2376 CREATE TABLE IF NOT EXISTS `0_workcentres` (
2377 `id` int(11) NOT NULL auto_increment,
2378 `name` char(40) NOT NULL default '',
2379 `description` char(50) NOT NULL default '',
2380 `inactive` tinyint(1) NOT NULL default '0',
2382 UNIQUE KEY `name` (`name`)
2383 ) ENGINE=MyISAM AUTO_INCREMENT=2 ;
2386 -- Dumping data for table `0_workcentres`
2389 INSERT INTO `0_workcentres` VALUES(1, 'Workshop', 'Workshop in Alabama', 0);
2391 -- --------------------------------------------------------
2394 -- Table structure for table `0_workorders`
2397 DROP TABLE IF EXISTS `0_workorders`;
2398 CREATE TABLE IF NOT EXISTS `0_workorders` (
2399 `id` int(11) NOT NULL auto_increment,
2400 `wo_ref` varchar(60) NOT NULL default '',
2401 `loc_code` varchar(5) NOT NULL default '',
2402 `units_reqd` double NOT NULL default '1',
2403 `stock_id` varchar(20) NOT NULL default '',
2404 `date_` date NOT NULL default '0000-00-00',
2405 `type` tinyint(4) NOT NULL default '0',
2406 `required_by` date NOT NULL default '0000-00-00',
2407 `released_date` date NOT NULL default '0000-00-00',
2408 `units_issued` double NOT NULL default '0',
2409 `closed` tinyint(1) NOT NULL default '0',
2410 `released` tinyint(1) NOT NULL default '0',
2411 `additional_costs` double NOT NULL default '0',
2413 UNIQUE KEY `wo_ref` (`wo_ref`)
2414 ) ENGINE=InnoDB AUTO_INCREMENT=8 ;
2417 -- Dumping data for table `0_workorders`
2420 INSERT INTO `0_workorders` VALUES(1, '1', 'DEF', 10, '3400', '2009-06-21', 0, '2009-06-21', '2009-06-21', 10, 1, 1, 10);
2421 INSERT INTO `0_workorders` VALUES(2, '2', 'DEF', 3, '3400', '2009-06-21', 2, '2009-07-11', '2009-06-21', 2, 0, 1, 0);
2422 INSERT INTO `0_workorders` VALUES(3, '3', 'DEF', 2, '3400', '2009-06-21', 0, '2009-06-21', '2009-06-21', 2, 1, 1, 0);
2423 INSERT INTO `0_workorders` VALUES(4, '4', 'DEF', 4, '3400', '2009-06-21', 0, '2009-06-21', '2009-06-21', 4, 1, 1, 0);
2424 INSERT INTO `0_workorders` VALUES(5, '5', 'DEF', 5, '3400', '2009-06-21', 0, '2009-06-21', '2009-06-21', 5, 1, 1, 10);
2425 INSERT INTO `0_workorders` VALUES(6, '6', 'DEF', -5, '3400', '2009-06-21', 1, '2009-06-21', '2009-06-21', -5, 1, 1, 0);
2426 INSERT INTO `0_workorders` VALUES(7, '7', 'DEF', -2, '3400', '2009-06-21', 1, '2009-06-21', '2009-06-21', -2, 1, 1, 10);
2428 -- --------------------------------------------------------
2431 -- Table structure for table `0_wo_costing`
2434 DROP TABLE IF EXISTS `0_wo_costing`;
2435 CREATE TABLE `0_wo_costing` (
2436 `id` int(11) NOT NULL auto_increment,
2437 `workorder_id` int(11) NOT NULL default '0',
2438 `cost_type` tinyint(1) NOT NULL default '0',
2439 `trans_type` int(11) NOT NULL default '0',
2440 `trans_no` int(11) NOT NULL default '0',
2441 `factor` double NOT NULL default '1',
2446 -- Dumping data for table `0_wo_costing`
2450 -- --------------------------------------------------------
2453 -- Table structure for table `0_wo_issues`
2456 DROP TABLE IF EXISTS `0_wo_issues`;
2457 CREATE TABLE IF NOT EXISTS `0_wo_issues` (
2458 `issue_no` int(11) NOT NULL auto_increment,
2459 `workorder_id` int(11) NOT NULL default '0',
2460 `reference` varchar(100) default NULL,
2461 `issue_date` date default NULL,
2462 `loc_code` varchar(5) default NULL,
2463 `workcentre_id` int(11) default NULL,
2464 PRIMARY KEY (`issue_no`),
2465 KEY `workorder_id` (`workorder_id`)
2466 ) ENGINE=InnoDB AUTO_INCREMENT=1 ;
2469 -- Dumping data for table `0_wo_issues`
2473 -- --------------------------------------------------------
2476 -- Table structure for table `0_wo_issue_items`
2479 DROP TABLE IF EXISTS `0_wo_issue_items`;
2480 CREATE TABLE IF NOT EXISTS `0_wo_issue_items` (
2481 `id` int(11) NOT NULL auto_increment,
2482 `stock_id` varchar(40) default NULL,
2483 `issue_id` int(11) default NULL,
2484 `qty_issued` double default NULL,
2486 ) ENGINE=InnoDB AUTO_INCREMENT=1 ;
2489 -- Dumping data for table `0_wo_issue_items`
2493 -- --------------------------------------------------------
2496 -- Table structure for table `0_wo_manufacture`
2499 DROP TABLE IF EXISTS `0_wo_manufacture`;
2500 CREATE TABLE IF NOT EXISTS `0_wo_manufacture` (
2501 `id` int(11) NOT NULL auto_increment,
2502 `reference` varchar(100) default NULL,
2503 `workorder_id` int(11) NOT NULL default '0',
2504 `quantity` double NOT NULL default '0',
2505 `date_` date NOT NULL default '0000-00-00',
2507 KEY `workorder_id` (`workorder_id`)
2508 ) ENGINE=InnoDB AUTO_INCREMENT=2 ;
2511 -- Dumping data for table `0_wo_manufacture`
2514 INSERT INTO `0_wo_manufacture` VALUES(1, '1', 2, 2, '2009-06-21');
2516 -- --------------------------------------------------------
2519 -- Table structure for table `0_wo_requirements`
2522 DROP TABLE IF EXISTS `0_wo_requirements`;
2523 CREATE TABLE IF NOT EXISTS `0_wo_requirements` (
2524 `id` int(11) NOT NULL auto_increment,
2525 `workorder_id` int(11) NOT NULL default '0',
2526 `stock_id` char(20) NOT NULL default '',
2527 `workcentre` int(11) NOT NULL default '0',
2528 `units_req` double NOT NULL default '1',
2529 `std_cost` double NOT NULL default '0',
2530 `loc_code` char(5) NOT NULL default '',
2531 `units_issued` double NOT NULL default '0',
2533 KEY `workorder_id` (`workorder_id`)
2534 ) ENGINE=InnoDB AUTO_INCREMENT=22 ;
2537 -- Dumping data for table `0_wo_requirements`
2540 INSERT INTO `0_wo_requirements` VALUES(1, 1, '102', 1, 1, 0, 'DEF', 10);
2541 INSERT INTO `0_wo_requirements` VALUES(2, 1, '103', 1, 1, 0, 'DEF', 10);
2542 INSERT INTO `0_wo_requirements` VALUES(3, 1, '104', 1, 1, 0, 'DEF', 10);
2543 INSERT INTO `0_wo_requirements` VALUES(4, 2, '102', 1, 1, 0, 'DEF', 0);
2544 INSERT INTO `0_wo_requirements` VALUES(5, 2, '103', 1, 1, 0, 'DEF', 0);
2545 INSERT INTO `0_wo_requirements` VALUES(6, 2, '104', 1, 1, 0, 'DEF', 0);
2546 INSERT INTO `0_wo_requirements` VALUES(7, 3, '102', 1, 1, 0, 'DEF', 2);
2547 INSERT INTO `0_wo_requirements` VALUES(8, 3, '103', 1, 1, 0, 'DEF', 2);
2548 INSERT INTO `0_wo_requirements` VALUES(9, 3, '104', 1, 1, 0, 'DEF', 2);
2549 INSERT INTO `0_wo_requirements` VALUES(10, 4, '102', 1, 1, 0, 'DEF', 4);
2550 INSERT INTO `0_wo_requirements` VALUES(11, 4, '103', 1, 1, 0, 'DEF', 4);
2551 INSERT INTO `0_wo_requirements` VALUES(12, 4, '104', 1, 1, 0, 'DEF', 4);
2552 INSERT INTO `0_wo_requirements` VALUES(13, 5, '102', 1, 1, 0, 'DEF', 5);
2553 INSERT INTO `0_wo_requirements` VALUES(14, 5, '103', 1, 1, 0, 'DEF', 5);
2554 INSERT INTO `0_wo_requirements` VALUES(15, 5, '104', 1, 1, 0, 'DEF', 5);
2555 INSERT INTO `0_wo_requirements` VALUES(16, 6, '102', 1, 1, 0, 'DEF', -5);
2556 INSERT INTO `0_wo_requirements` VALUES(17, 6, '103', 1, 1, 0, 'DEF', -5);
2557 INSERT INTO `0_wo_requirements` VALUES(18, 6, '104', 1, 1, 0, 'DEF', -5);
2558 INSERT INTO `0_wo_requirements` VALUES(19, 7, '102', 1, 1, 0, 'DEF', -2);
2559 INSERT INTO `0_wo_requirements` VALUES(20, 7, '103', 1, 1, 0, 'DEF', -2);
2560 INSERT INTO `0_wo_requirements` VALUES(21, 7, '104', 1, 1, 0, 'DEF', -2);
projects / fa-stable.git / blob