1 -- MySQL dump of database 'en_US-new' on host 'localhost'
2 -- Backup Date and Time: 2019-01-21 11:16
3 -- Built by FrontAccounting 2.5.0
4 -- http://frontaccounting.com
5 -- Company: Training Co.
8 -- Compatibility: 2.5.0
14 -- Structure of table `0_areas` --
16 DROP TABLE IF EXISTS `0_areas`;
18 CREATE TABLE `0_areas` (
19 `area_code` int(11) NOT NULL AUTO_INCREMENT,
20 `description` varchar(60) NOT NULL DEFAULT '',
21 `inactive` tinyint(1) NOT NULL DEFAULT '0',
22 PRIMARY KEY (`area_code`),
23 UNIQUE KEY `description` (`description`)
24 ) ENGINE=InnoDB AUTO_INCREMENT=2 ;
26 -- Data of table `0_areas` --
28 INSERT INTO `0_areas` VALUES
31 -- Structure of table `0_attachments` --
33 DROP TABLE IF EXISTS `0_attachments`;
35 CREATE TABLE `0_attachments` (
36 `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
37 `description` varchar(60) NOT NULL DEFAULT '',
38 `type_no` int(11) NOT NULL DEFAULT '0',
39 `trans_no` int(11) NOT NULL DEFAULT '0',
40 `unique_name` varchar(60) NOT NULL DEFAULT '',
41 `tran_date` date NOT NULL DEFAULT '0000-00-00',
42 `filename` varchar(60) NOT NULL DEFAULT '',
43 `filesize` int(11) NOT NULL DEFAULT '0',
44 `filetype` varchar(60) NOT NULL DEFAULT '',
46 KEY `type_no` (`type_no`,`trans_no`)
49 -- Data of table `0_attachments` --
51 -- Structure of table `0_audit_trail` --
53 DROP TABLE IF EXISTS `0_audit_trail`;
55 CREATE TABLE `0_audit_trail` (
56 `id` int(11) NOT NULL AUTO_INCREMENT,
57 `type` smallint(6) unsigned NOT NULL DEFAULT '0',
58 `trans_no` int(11) unsigned NOT NULL DEFAULT '0',
59 `user` smallint(6) unsigned NOT NULL DEFAULT '0',
60 `stamp` timestamp NOT NULL,
61 `description` varchar(60) DEFAULT NULL,
62 `fiscal_year` int(11) NOT NULL DEFAULT '0',
63 `gl_date` date NOT NULL DEFAULT '0000-00-00',
64 `gl_seq` int(11) unsigned DEFAULT NULL,
66 KEY `Seq` (`fiscal_year`,`gl_date`,`gl_seq`),
67 KEY `Type_and_Number` (`type`,`trans_no`)
70 -- Data of table `0_audit_trail` --
72 -- Structure of table `0_bank_accounts` --
74 DROP TABLE IF EXISTS `0_bank_accounts`;
76 CREATE TABLE `0_bank_accounts` (
77 `account_code` varchar(15) NOT NULL DEFAULT '',
78 `account_type` smallint(6) NOT NULL DEFAULT '0',
79 `bank_account_name` varchar(60) NOT NULL DEFAULT '',
80 `bank_account_number` varchar(100) NOT NULL DEFAULT '',
81 `bank_name` varchar(60) NOT NULL DEFAULT '',
82 `bank_address` tinytext,
83 `bank_curr_code` char(3) NOT NULL DEFAULT '',
84 `dflt_curr_act` tinyint(1) NOT NULL DEFAULT '0',
85 `id` smallint(6) NOT NULL AUTO_INCREMENT,
86 `bank_charge_act` varchar(15) NOT NULL DEFAULT '',
87 `last_reconciled_date` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
88 `ending_reconcile_balance` double NOT NULL DEFAULT '0',
89 `inactive` tinyint(1) NOT NULL DEFAULT '0',
91 KEY `bank_account_name` (`bank_account_name`),
92 KEY `bank_account_number` (`bank_account_number`),
93 KEY `account_code` (`account_code`)
94 ) ENGINE=InnoDB AUTO_INCREMENT=3 ;
96 -- Data of table `0_bank_accounts` --
98 INSERT INTO `0_bank_accounts` VALUES
99 ('1060', '0', 'Current account', 'N/A', 'N/A', NULL, 'USD', '1', '1', '5690', '0000-00-00 00:00:00', '0', '0'),
100 ('1065', '3', 'Petty Cash account', 'N/A', 'N/A', NULL, 'USD', '0', '2', '5690', '0000-00-00 00:00:00', '0', '0');
102 -- Structure of table `0_bank_trans` --
104 DROP TABLE IF EXISTS `0_bank_trans`;
106 CREATE TABLE `0_bank_trans` (
107 `id` int(11) NOT NULL AUTO_INCREMENT,
108 `type` smallint(6) DEFAULT NULL,
109 `trans_no` int(11) DEFAULT NULL,
110 `bank_act` varchar(15) NOT NULL DEFAULT '',
111 `ref` varchar(40) DEFAULT NULL,
112 `trans_date` date NOT NULL DEFAULT '0000-00-00',
113 `amount` double DEFAULT NULL,
114 `dimension_id` int(11) NOT NULL DEFAULT '0',
115 `dimension2_id` int(11) NOT NULL DEFAULT '0',
116 `person_type_id` int(11) NOT NULL DEFAULT '0',
117 `person_id` tinyblob,
118 `reconciled` date DEFAULT NULL,
120 KEY `bank_act` (`bank_act`,`ref`),
121 KEY `type` (`type`,`trans_no`),
122 KEY `bank_act_2` (`bank_act`,`reconciled`),
123 KEY `bank_act_3` (`bank_act`,`trans_date`)
126 -- Data of table `0_bank_trans` --
128 -- Structure of table `0_bom` --
130 DROP TABLE IF EXISTS `0_bom`;
132 CREATE TABLE `0_bom` (
133 `id` int(11) NOT NULL AUTO_INCREMENT,
134 `parent` char(20) NOT NULL DEFAULT '',
135 `component` char(20) NOT NULL DEFAULT '',
136 `workcentre_added` int(11) NOT NULL DEFAULT '0',
137 `loc_code` char(5) NOT NULL DEFAULT '',
138 `quantity` double NOT NULL DEFAULT '1',
139 PRIMARY KEY (`parent`,`component`,`workcentre_added`,`loc_code`),
140 KEY `component` (`component`),
142 KEY `loc_code` (`loc_code`),
143 KEY `parent` (`parent`,`loc_code`),
144 KEY `workcentre_added` (`workcentre_added`)
147 -- Data of table `0_bom` --
149 -- Structure of table `0_budget_trans` --
151 DROP TABLE IF EXISTS `0_budget_trans`;
153 CREATE TABLE `0_budget_trans` (
154 `id` int(11) NOT NULL AUTO_INCREMENT,
155 `tran_date` date NOT NULL DEFAULT '0000-00-00',
156 `account` varchar(15) NOT NULL DEFAULT '',
157 `memo_` tinytext NOT NULL,
158 `amount` double NOT NULL DEFAULT '0',
159 `dimension_id` int(11) DEFAULT '0',
160 `dimension2_id` int(11) DEFAULT '0',
162 KEY `Account` (`account`,`tran_date`,`dimension_id`,`dimension2_id`)
165 -- Data of table `0_budget_trans` --
167 -- Structure of table `0_chart_class` --
169 DROP TABLE IF EXISTS `0_chart_class`;
171 CREATE TABLE `0_chart_class` (
172 `cid` varchar(3) NOT NULL,
173 `class_name` varchar(60) NOT NULL DEFAULT '',
174 `ctype` tinyint(1) NOT NULL DEFAULT '0',
175 `inactive` tinyint(1) NOT NULL DEFAULT '0',
179 -- Data of table `0_chart_class` --
181 INSERT INTO `0_chart_class` VALUES
182 ('1', 'Assets', '1', '0'),
183 ('2', 'Liabilities', '2', '0'),
184 ('3', 'Income', '4', '0'),
185 ('4', 'Costs', '6', '0');
187 -- Structure of table `0_chart_master` --
189 DROP TABLE IF EXISTS `0_chart_master`;
191 CREATE TABLE `0_chart_master` (
192 `account_code` varchar(15) NOT NULL DEFAULT '',
193 `account_code2` varchar(15) NOT NULL DEFAULT '',
194 `account_name` varchar(60) NOT NULL DEFAULT '',
195 `account_type` varchar(10) NOT NULL DEFAULT '0',
196 `inactive` tinyint(1) NOT NULL DEFAULT '0',
197 PRIMARY KEY (`account_code`),
198 KEY `account_name` (`account_name`),
199 KEY `accounts_by_type` (`account_type`,`account_code`)
202 -- Data of table `0_chart_master` --
204 INSERT INTO `0_chart_master` VALUES
205 ('1060', '', 'Checking Account', '1', '0'),
206 ('1065', '', 'Petty Cash', '1', '0'),
207 ('1200', '', 'Accounts Receivables', '1', '0'),
208 ('1205', '', 'Allowance for doubtful accounts', '1', '0'),
209 ('1510', '', 'Inventory', '2', '0'),
210 ('1520', '', 'Stocks of Raw Materials', '2', '0'),
211 ('1530', '', 'Stocks of Work In Progress', '2', '0'),
212 ('1540', '', 'Stocks of Finished Goods', '2', '0'),
213 ('1550', '', 'Goods Received Clearing account', '2', '0'),
214 ('1820', '', 'Office Furniture & Equipment', '3', '0'),
215 ('1825', '', 'Accum. Amort. -Furn. & Equip.', '3', '0'),
216 ('1840', '', 'Vehicle', '3', '0'),
217 ('1845', '', 'Accum. Amort. -Vehicle', '3', '0'),
218 ('2100', '', 'Accounts Payable', '4', '0'),
219 ('2105', '', 'Deferred Income', '4', '0'),
220 ('2110', '', 'Accrued Income Tax - Federal', '4', '0'),
221 ('2120', '', 'Accrued Income Tax - State', '4', '0'),
222 ('2130', '', 'Accrued Franchise Tax', '4', '0'),
223 ('2140', '', 'Accrued Real & Personal Prop Tax', '4', '0'),
224 ('2150', '', 'Sales Tax', '4', '0'),
225 ('2160', '', 'Accrued Use Tax Payable', '4', '0'),
226 ('2210', '', 'Accrued Wages', '4', '0'),
227 ('2220', '', 'Accrued Comp Time', '4', '0'),
228 ('2230', '', 'Accrued Holiday Pay', '4', '0'),
229 ('2240', '', 'Accrued Vacation Pay', '4', '0'),
230 ('2310', '', 'Accr. Benefits - 401K', '4', '0'),
231 ('2320', '', 'Accr. Benefits - Stock Purchase', '4', '0'),
232 ('2330', '', 'Accr. Benefits - Med, Den', '4', '0'),
233 ('2340', '', 'Accr. Benefits - Payroll Taxes', '4', '0'),
234 ('2350', '', 'Accr. Benefits - Credit Union', '4', '0'),
235 ('2360', '', 'Accr. Benefits - Savings Bond', '4', '0'),
236 ('2370', '', 'Accr. Benefits - Garnish', '4', '0'),
237 ('2380', '', 'Accr. Benefits - Charity Cont.', '4', '0'),
238 ('2620', '', 'Bank Loans', '5', '0'),
239 ('2680', '', 'Loans from Shareholders', '5', '0'),
240 ('3350', '', 'Common Shares', '6', '0'),
241 ('3590', '', 'Retained Earnings - prior years', '7', '0'),
242 ('4010', '', 'Sales', '8', '0'),
243 ('4430', '', 'Shipping & Handling', '9', '0'),
244 ('4440', '', 'Interest', '9', '0'),
245 ('4450', '', 'Foreign Exchange Gain', '9', '0'),
246 ('4500', '', 'Prompt Payment Discounts', '9', '0'),
247 ('4510', '', 'Discounts Given', '9', '0'),
248 ('5010', '', 'Cost of Goods Sold - Retail', '10', '0'),
249 ('5020', '', 'Material Usage Varaiance', '10', '0'),
250 ('5030', '', 'Consumable Materials', '10', '0'),
251 ('5040', '', 'Purchase price Variance', '10', '0'),
252 ('5050', '', 'Purchases of materials', '10', '0'),
253 ('5060', '', 'Discounts Received', '10', '0'),
254 ('5100', '', 'Freight', '10', '0'),
255 ('5410', '', 'Wages & Salaries', '11', '0'),
256 ('5420', '', 'Wages - Overtime', '11', '0'),
257 ('5430', '', 'Benefits - Comp Time', '11', '0'),
258 ('5440', '', 'Benefits - Payroll Taxes', '11', '0'),
259 ('5450', '', 'Benefits - Workers Comp', '11', '0'),
260 ('5460', '', 'Benefits - Pension', '11', '0'),
261 ('5470', '', 'Benefits - General Benefits', '11', '0'),
262 ('5510', '', 'Inc Tax Exp - Federal', '11', '0'),
263 ('5520', '', 'Inc Tax Exp - State', '11', '0'),
264 ('5530', '', 'Taxes - Real Estate', '11', '0'),
265 ('5540', '', 'Taxes - Personal Property', '11', '0'),
266 ('5550', '', 'Taxes - Franchise', '11', '0'),
267 ('5560', '', 'Taxes - Foreign Withholding', '11', '0'),
268 ('5610', '', 'Accounting & Legal', '12', '0'),
269 ('5615', '', 'Advertising & Promotions', '12', '0'),
270 ('5620', '', 'Bad Debts', '12', '0'),
271 ('5660', '', 'Amortization Expense', '12', '0'),
272 ('5685', '', 'Insurance', '12', '0'),
273 ('5690', '', 'Interest & Bank Charges', '12', '0'),
274 ('5700', '', 'Office Supplies', '12', '0'),
275 ('5760', '', 'Rent', '12', '0'),
276 ('5765', '', 'Repair & Maintenance', '12', '0'),
277 ('5780', '', 'Telephone', '12', '0'),
278 ('5785', '', 'Travel & Entertainment', '12', '0'),
279 ('5790', '', 'Utilities', '12', '0'),
280 ('5795', '', 'Registrations', '12', '0'),
281 ('5800', '', 'Licenses', '12', '0'),
282 ('5810', '', 'Foreign Exchange Loss', '12', '0'),
283 ('9990', '', 'Year Profit/Loss', '12', '0');
285 -- Structure of table `0_chart_types` --
287 DROP TABLE IF EXISTS `0_chart_types`;
289 CREATE TABLE `0_chart_types` (
290 `id` varchar(10) NOT NULL,
291 `name` varchar(60) NOT NULL DEFAULT '',
292 `class_id` varchar(3) NOT NULL DEFAULT '',
293 `parent` varchar(10) NOT NULL DEFAULT '-1',
294 `inactive` tinyint(1) NOT NULL DEFAULT '0',
297 KEY `class_id` (`class_id`)
300 -- Data of table `0_chart_types` --
302 INSERT INTO `0_chart_types` VALUES
303 ('1', 'Current Assets', '1', '', '0'),
304 ('2', 'Inventory Assets', '1', '', '0'),
305 ('3', 'Capital Assets', '1', '', '0'),
306 ('4', 'Current Liabilities', '2', '', '0'),
307 ('5', 'Long Term Liabilities', '2', '', '0'),
308 ('6', 'Share Capital', '2', '', '0'),
309 ('7', 'Retained Earnings', '2', '', '0'),
310 ('8', 'Sales Revenue', '3', '', '0'),
311 ('9', 'Other Revenue', '3', '', '0'),
312 ('10', 'Cost of Goods Sold', '4', '', '0'),
313 ('11', 'Payroll Expenses', '4', '', '0'),
314 ('12', 'General & Administrative expenses', '4', '', '0');
316 -- Structure of table `0_comments` --
318 DROP TABLE IF EXISTS `0_comments`;
320 CREATE TABLE `0_comments` (
321 `type` int(11) NOT NULL DEFAULT '0',
322 `id` int(11) NOT NULL DEFAULT '0',
323 `date_` date DEFAULT '0000-00-00',
325 KEY `type_and_id` (`type`,`id`)
328 -- Data of table `0_comments` --
330 -- Structure of table `0_credit_status` --
332 DROP TABLE IF EXISTS `0_credit_status`;
334 CREATE TABLE `0_credit_status` (
335 `id` int(11) NOT NULL AUTO_INCREMENT,
336 `reason_description` char(100) NOT NULL DEFAULT '',
337 `dissallow_invoices` tinyint(1) NOT NULL DEFAULT '0',
338 `inactive` tinyint(1) NOT NULL DEFAULT '0',
340 UNIQUE KEY `reason_description` (`reason_description`)
341 ) ENGINE=InnoDB AUTO_INCREMENT=5 ;
343 -- Data of table `0_credit_status` --
345 INSERT INTO `0_credit_status` VALUES
346 ('1', 'Good History', '0', '0'),
347 ('3', 'No more work until payment received', '1', '0'),
348 ('4', 'In liquidation', '1', '0');
350 -- Structure of table `0_crm_categories` --
352 DROP TABLE IF EXISTS `0_crm_categories`;
354 CREATE TABLE `0_crm_categories` (
355 `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'pure technical key',
356 `type` varchar(20) NOT NULL COMMENT 'contact type e.g. customer',
357 `action` varchar(20) NOT NULL COMMENT 'detailed usage e.g. department',
358 `name` varchar(30) NOT NULL COMMENT 'for category selector',
359 `description` tinytext NOT NULL COMMENT 'usage description',
360 `system` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'nonzero for core system usage',
361 `inactive` tinyint(1) NOT NULL DEFAULT '0',
363 UNIQUE KEY `type` (`type`,`action`),
364 UNIQUE KEY `type_2` (`type`,`name`)
365 ) ENGINE=InnoDB AUTO_INCREMENT=13 ;
367 -- Data of table `0_crm_categories` --
369 INSERT INTO `0_crm_categories` VALUES
370 ('1', 'cust_branch', 'general', 'General', 'General contact data for customer branch (overrides company setting)', '1', '0'),
371 ('2', 'cust_branch', 'invoice', 'Invoices', 'Invoice posting (overrides company setting)', '1', '0'),
372 ('3', 'cust_branch', 'order', 'Orders', 'Order confirmation (overrides company setting)', '1', '0'),
373 ('4', 'cust_branch', 'delivery', 'Deliveries', 'Delivery coordination (overrides company setting)', '1', '0'),
374 ('5', 'customer', 'general', 'General', 'General contact data for customer', '1', '0'),
375 ('6', 'customer', 'order', 'Orders', 'Order confirmation', '1', '0'),
376 ('7', 'customer', 'delivery', 'Deliveries', 'Delivery coordination', '1', '0'),
377 ('8', 'customer', 'invoice', 'Invoices', 'Invoice posting', '1', '0'),
378 ('9', 'supplier', 'general', 'General', 'General contact data for supplier', '1', '0'),
379 ('10', 'supplier', 'order', 'Orders', 'Order confirmation', '1', '0'),
380 ('11', 'supplier', 'delivery', 'Deliveries', 'Delivery coordination', '1', '0'),
381 ('12', 'supplier', 'invoice', 'Invoices', 'Invoice posting', '1', '0');
383 -- Structure of table `0_crm_contacts` --
385 DROP TABLE IF EXISTS `0_crm_contacts`;
387 CREATE TABLE `0_crm_contacts` (
388 `id` int(11) NOT NULL AUTO_INCREMENT,
389 `person_id` int(11) NOT NULL DEFAULT '0' COMMENT 'foreign key to crm_persons',
390 `type` varchar(20) NOT NULL COMMENT 'foreign key to crm_categories',
391 `action` varchar(20) NOT NULL COMMENT 'foreign key to crm_categories',
392 `entity_id` varchar(11) DEFAULT NULL COMMENT 'entity id in related class table',
394 KEY `type` (`type`,`action`)
397 -- Data of table `0_crm_contacts` --
399 -- Structure of table `0_crm_persons` --
401 DROP TABLE IF EXISTS `0_crm_persons`;
403 CREATE TABLE `0_crm_persons` (
404 `id` int(11) NOT NULL AUTO_INCREMENT,
405 `ref` varchar(30) NOT NULL,
406 `name` varchar(60) NOT NULL,
407 `name2` varchar(60) DEFAULT NULL,
409 `phone` varchar(30) DEFAULT NULL,
410 `phone2` varchar(30) DEFAULT NULL,
411 `fax` varchar(30) DEFAULT NULL,
412 `email` varchar(100) DEFAULT NULL,
413 `lang` char(5) DEFAULT NULL,
414 `notes` tinytext NOT NULL,
415 `inactive` tinyint(1) NOT NULL DEFAULT '0',
420 -- Data of table `0_crm_persons` --
422 -- Structure of table `0_currencies` --
424 DROP TABLE IF EXISTS `0_currencies`;
426 CREATE TABLE `0_currencies` (
427 `currency` varchar(60) NOT NULL DEFAULT '',
428 `curr_abrev` char(3) NOT NULL DEFAULT '',
429 `curr_symbol` varchar(10) NOT NULL DEFAULT '',
430 `country` varchar(100) NOT NULL DEFAULT '',
431 `hundreds_name` varchar(15) NOT NULL DEFAULT '',
432 `auto_update` tinyint(1) NOT NULL DEFAULT '1',
433 `inactive` tinyint(1) NOT NULL DEFAULT '0',
434 PRIMARY KEY (`curr_abrev`)
437 -- Data of table `0_currencies` --
439 INSERT INTO `0_currencies` VALUES
440 ('CA Dollars', 'CAD', '$', 'Canada', 'Cents', '1', '0'),
441 ('Euro', 'EUR', '€', 'Europe', 'Cents', '1', '0'),
442 ('Pounds', 'GBP', '£', 'England', 'Pence', '1', '0'),
443 ('US Dollars', 'USD', '$', 'United States', 'Cents', '1', '0');
445 -- Structure of table `0_cust_allocations` --
447 DROP TABLE IF EXISTS `0_cust_allocations`;
449 CREATE TABLE `0_cust_allocations` (
450 `id` int(11) NOT NULL AUTO_INCREMENT,
451 `person_id` int(11) DEFAULT NULL,
452 `amt` double unsigned DEFAULT NULL,
453 `date_alloc` date NOT NULL DEFAULT '0000-00-00',
454 `trans_no_from` int(11) DEFAULT NULL,
455 `trans_type_from` int(11) DEFAULT NULL,
456 `trans_no_to` int(11) DEFAULT NULL,
457 `trans_type_to` int(11) DEFAULT NULL,
459 UNIQUE KEY `trans_type_from` (`person_id`,`trans_type_from`,`trans_no_from`,`trans_type_to`,`trans_no_to`),
460 KEY `From` (`trans_type_from`,`trans_no_from`),
461 KEY `To` (`trans_type_to`,`trans_no_to`)
464 -- Data of table `0_cust_allocations` --
466 -- Structure of table `0_cust_branch` --
468 DROP TABLE IF EXISTS `0_cust_branch`;
470 CREATE TABLE `0_cust_branch` (
471 `branch_code` int(11) NOT NULL AUTO_INCREMENT,
472 `debtor_no` int(11) NOT NULL DEFAULT '0',
473 `br_name` varchar(60) NOT NULL DEFAULT '',
474 `branch_ref` varchar(30) NOT NULL DEFAULT '',
475 `br_address` tinytext NOT NULL,
476 `area` int(11) DEFAULT NULL,
477 `salesman` int(11) NOT NULL DEFAULT '0',
478 `default_location` varchar(5) NOT NULL DEFAULT '',
479 `tax_group_id` int(11) DEFAULT NULL,
480 `sales_account` varchar(15) NOT NULL DEFAULT '',
481 `sales_discount_account` varchar(15) NOT NULL DEFAULT '',
482 `receivables_account` varchar(15) NOT NULL DEFAULT '',
483 `payment_discount_account` varchar(15) NOT NULL DEFAULT '',
484 `default_ship_via` varchar(20) NOT NULL DEFAULT '',
485 `br_post_address` tinytext NOT NULL,
486 `group_no` int(11) NOT NULL DEFAULT '0',
487 `notes` tinytext NOT NULL,
488 `bank_account` varchar(60) DEFAULT NULL,
489 `inactive` tinyint(1) NOT NULL DEFAULT '0',
490 PRIMARY KEY (`branch_code`,`debtor_no`),
491 KEY `branch_ref` (`branch_ref`),
492 KEY `group_no` (`group_no`)
495 -- Data of table `0_cust_branch` --
497 DROP TABLE IF EXISTS `0_sql_trail`;
498 CREATE TABLE `0_db_trail` (
499 `id` int(11) NOT NULL AUTO_INCREMENT,
500 `stamp` timestamp DEFAULT CURRENT_TIMESTAMP,
501 `user` tinyint(3) unsigned NOT NULL DEFAULT '0',
502 `msg` varchar(255) DEFAULT '',
503 `entry` varchar(255) DEFAULT '',
504 `data` text DEFAULT NULL,
508 -- Structure of table `0_debtor_trans` --
510 DROP TABLE IF EXISTS `0_debtor_trans`;
512 CREATE TABLE `0_debtor_trans` (
513 `trans_no` int(11) unsigned NOT NULL DEFAULT '0',
514 `type` smallint(6) unsigned NOT NULL DEFAULT '0',
515 `version` tinyint(1) unsigned NOT NULL DEFAULT '0',
516 `debtor_no` int(11) unsigned NOT NULL,
517 `branch_code` int(11) NOT NULL DEFAULT '-1',
518 `tran_date` date NOT NULL DEFAULT '0000-00-00',
519 `due_date` date NOT NULL DEFAULT '0000-00-00',
520 `reference` varchar(60) NOT NULL DEFAULT '',
521 `tpe` int(11) NOT NULL DEFAULT '0',
522 `order_` int(11) NOT NULL DEFAULT '0',
523 `ov_amount` double NOT NULL DEFAULT '0',
524 `ov_gst` double NOT NULL DEFAULT '0',
525 `ov_freight` double NOT NULL DEFAULT '0',
526 `ov_freight_tax` double NOT NULL DEFAULT '0',
527 `ov_discount` double NOT NULL DEFAULT '0',
528 `alloc` double NOT NULL DEFAULT '0',
529 `prep_amount` double NOT NULL DEFAULT '0',
530 `rate` double NOT NULL DEFAULT '1',
531 `ship_via` varchar(20) NOT NULL DEFAULT '',
532 `dimension_id` int(11) NOT NULL DEFAULT '0',
533 `dimension2_id` int(11) NOT NULL DEFAULT '0',
534 `payment_terms` int(11) DEFAULT NULL,
535 `tax_included` tinyint(1) unsigned NOT NULL DEFAULT '0',
536 PRIMARY KEY (`type`,`trans_no`,`debtor_no`),
537 KEY `debtor_no` (`debtor_no`,`branch_code`),
538 KEY `tran_date` (`tran_date`),
539 KEY `order_` (`order_`)
542 -- Data of table `0_debtor_trans` --
544 -- Structure of table `0_debtor_trans_details` --
546 DROP TABLE IF EXISTS `0_debtor_trans_details`;
548 CREATE TABLE `0_debtor_trans_details` (
549 `id` int(11) NOT NULL AUTO_INCREMENT,
550 `debtor_trans_no` int(11) DEFAULT NULL,
551 `debtor_trans_type` int(11) DEFAULT NULL,
552 `stock_id` varchar(20) NOT NULL DEFAULT '',
553 `description` tinytext,
554 `unit_price` double NOT NULL DEFAULT '0',
555 `unit_tax` double NOT NULL DEFAULT '0',
556 `quantity` double NOT NULL DEFAULT '0',
557 `discount_percent` double NOT NULL DEFAULT '0',
558 `unit_cost` double NOT NULL DEFAULT '0',
559 `qty_done` double NOT NULL DEFAULT '0',
560 `src_id` int(11) NOT NULL,
562 KEY `Transaction` (`debtor_trans_type`,`debtor_trans_no`),
563 KEY `src_id` (`src_id`)
566 -- Data of table `0_debtor_trans_details` --
568 -- Structure of table `0_debtors_master` --
570 DROP TABLE IF EXISTS `0_debtors_master`;
572 CREATE TABLE `0_debtors_master` (
573 `debtor_no` int(11) NOT NULL AUTO_INCREMENT,
574 `name` varchar(100) NOT NULL DEFAULT '',
575 `debtor_ref` varchar(30) NOT NULL,
577 `tax_id` varchar(55) NOT NULL DEFAULT '',
578 `curr_code` char(3) NOT NULL DEFAULT '',
579 `sales_type` int(11) NOT NULL DEFAULT '1',
580 `dimension_id` int(11) NOT NULL DEFAULT '0',
581 `dimension2_id` int(11) NOT NULL DEFAULT '0',
582 `credit_status` int(11) NOT NULL DEFAULT '0',
583 `payment_terms` int(11) DEFAULT NULL,
584 `discount` double NOT NULL DEFAULT '0',
585 `credit_limit` float NOT NULL DEFAULT '1000',
586 `notes` tinytext NOT NULL,
587 `inactive` tinyint(1) NOT NULL DEFAULT '0',
588 PRIMARY KEY (`debtor_no`),
589 UNIQUE KEY `debtor_ref` (`debtor_ref`),
593 -- Data of table `0_debtors_master` --
595 -- Structure of table `0_dimensions` --
597 DROP TABLE IF EXISTS `0_dimensions`;
599 CREATE TABLE `0_dimensions` (
600 `id` int(11) NOT NULL AUTO_INCREMENT,
601 `reference` varchar(60) NOT NULL DEFAULT '',
602 `name` varchar(60) NOT NULL DEFAULT '',
603 `type_` tinyint(1) NOT NULL DEFAULT '1',
604 `closed` tinyint(1) NOT NULL DEFAULT '0',
605 `date_` date NOT NULL DEFAULT '0000-00-00',
606 `due_date` date NOT NULL DEFAULT '0000-00-00',
608 UNIQUE KEY `reference` (`reference`),
609 KEY `date_` (`date_`),
610 KEY `due_date` (`due_date`),
611 KEY `type_` (`type_`)
614 -- Data of table `0_dimensions` --
616 -- Structure of table `0_exchange_rates` --
618 DROP TABLE IF EXISTS `0_exchange_rates`;
620 CREATE TABLE `0_exchange_rates` (
621 `id` int(11) NOT NULL AUTO_INCREMENT,
622 `curr_code` char(3) NOT NULL DEFAULT '',
623 `rate_buy` double NOT NULL DEFAULT '0',
624 `rate_sell` double NOT NULL DEFAULT '0',
625 `date_` date NOT NULL DEFAULT '0000-00-00',
627 UNIQUE KEY `curr_code` (`curr_code`,`date_`)
630 -- Data of table `0_exchange_rates` --
632 -- Structure of table `0_fiscal_year` --
634 DROP TABLE IF EXISTS `0_fiscal_year`;
636 CREATE TABLE `0_fiscal_year` (
637 `id` int(11) NOT NULL AUTO_INCREMENT,
638 `begin` date DEFAULT '0000-00-00',
639 `end` date DEFAULT '0000-00-00',
640 `closed` tinyint(1) NOT NULL DEFAULT '0',
642 UNIQUE KEY `begin` (`begin`),
643 UNIQUE KEY `end` (`end`)
644 ) ENGINE=InnoDB AUTO_INCREMENT=2 ;
646 -- Data of table `0_fiscal_year` --
648 INSERT INTO `0_fiscal_year` VALUES
649 ('1', '2018-01-01', '2018-12-31', '1');
651 -- Structure of table `0_gl_trans` --
653 DROP TABLE IF EXISTS `0_gl_trans`;
655 CREATE TABLE `0_gl_trans` (
656 `counter` int(11) NOT NULL AUTO_INCREMENT,
657 `type` smallint(6) NOT NULL DEFAULT '0',
658 `type_no` int(11) NOT NULL DEFAULT '0',
659 `tran_date` date NOT NULL DEFAULT '0000-00-00',
660 `account` varchar(15) NOT NULL DEFAULT '',
661 `memo_` tinytext NOT NULL,
662 `amount` double NOT NULL DEFAULT '0',
663 `dimension_id` int(11) NOT NULL DEFAULT '0',
664 `dimension2_id` int(11) NOT NULL DEFAULT '0',
665 `person_type_id` int(11) DEFAULT NULL,
666 `person_id` tinyblob,
667 PRIMARY KEY (`counter`),
668 KEY `Type_and_Number` (`type`,`type_no`),
669 KEY `dimension_id` (`dimension_id`),
670 KEY `dimension2_id` (`dimension2_id`),
671 KEY `tran_date` (`tran_date`),
672 KEY `account_and_tran_date` (`account`,`tran_date`)
675 -- Data of table `0_gl_trans` --
677 -- Structure of table `0_grn_batch` --
679 DROP TABLE IF EXISTS `0_grn_batch`;
681 CREATE TABLE `0_grn_batch` (
682 `id` int(11) NOT NULL AUTO_INCREMENT,
683 `supplier_id` int(11) NOT NULL DEFAULT '0',
684 `purch_order_no` int(11) DEFAULT NULL,
685 `reference` varchar(60) NOT NULL DEFAULT '',
686 `delivery_date` date NOT NULL DEFAULT '0000-00-00',
687 `loc_code` varchar(5) DEFAULT NULL,
688 `rate` double DEFAULT '1',
690 KEY `delivery_date` (`delivery_date`),
691 KEY `purch_order_no` (`purch_order_no`)
694 -- Data of table `0_grn_batch` --
696 -- Structure of table `0_grn_items` --
698 DROP TABLE IF EXISTS `0_grn_items`;
700 CREATE TABLE `0_grn_items` (
701 `id` int(11) NOT NULL AUTO_INCREMENT,
702 `grn_batch_id` int(11) DEFAULT NULL,
703 `po_detail_item` int(11) NOT NULL DEFAULT '0',
704 `item_code` varchar(20) NOT NULL DEFAULT '',
705 `description` tinytext,
706 `qty_recd` double NOT NULL DEFAULT '0',
707 `quantity_inv` double NOT NULL DEFAULT '0',
709 KEY `grn_batch_id` (`grn_batch_id`)
712 -- Data of table `0_grn_items` --
714 -- Structure of table `0_groups` --
716 DROP TABLE IF EXISTS `0_groups`;
718 CREATE TABLE `0_groups` (
719 `id` smallint(6) unsigned NOT NULL AUTO_INCREMENT,
720 `description` varchar(60) NOT NULL DEFAULT '',
721 `inactive` tinyint(1) NOT NULL DEFAULT '0',
723 UNIQUE KEY `description` (`description`)
724 ) ENGINE=InnoDB AUTO_INCREMENT=4 ;
726 -- Data of table `0_groups` --
728 INSERT INTO `0_groups` VALUES
730 ('2', 'Medium', '0'),
733 -- Structure of table `0_item_codes` --
735 DROP TABLE IF EXISTS `0_item_codes`;
737 CREATE TABLE `0_item_codes` (
738 `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
739 `item_code` varchar(20) NOT NULL,
740 `stock_id` varchar(20) NOT NULL,
741 `description` varchar(200) NOT NULL DEFAULT '',
742 `category_id` smallint(6) unsigned NOT NULL,
743 `quantity` double NOT NULL DEFAULT '1',
744 `is_foreign` tinyint(1) NOT NULL DEFAULT '0',
745 `inactive` tinyint(1) NOT NULL DEFAULT '0',
747 UNIQUE KEY `stock_id` (`stock_id`,`item_code`),
748 KEY `item_code` (`item_code`)
751 -- Data of table `0_item_codes` --
753 -- Structure of table `0_item_tax_type_exemptions` --
755 DROP TABLE IF EXISTS `0_item_tax_type_exemptions`;
757 CREATE TABLE `0_item_tax_type_exemptions` (
758 `item_tax_type_id` int(11) NOT NULL DEFAULT '0',
759 `tax_type_id` int(11) NOT NULL DEFAULT '0',
760 PRIMARY KEY (`item_tax_type_id`,`tax_type_id`)
763 -- Data of table `0_item_tax_type_exemptions` --
765 -- Structure of table `0_item_tax_types` --
767 DROP TABLE IF EXISTS `0_item_tax_types`;
769 CREATE TABLE `0_item_tax_types` (
770 `id` int(11) NOT NULL AUTO_INCREMENT,
771 `name` varchar(60) NOT NULL DEFAULT '',
772 `exempt` tinyint(1) NOT NULL DEFAULT '0',
773 `inactive` tinyint(1) NOT NULL DEFAULT '0',
775 UNIQUE KEY `name` (`name`)
776 ) ENGINE=InnoDB AUTO_INCREMENT=2 ;
778 -- Data of table `0_item_tax_types` --
780 INSERT INTO `0_item_tax_types` VALUES
781 ('1', 'Regular', '0', '0');
783 -- Structure of table `0_item_units` --
785 DROP TABLE IF EXISTS `0_item_units`;
787 CREATE TABLE `0_item_units` (
788 `abbr` varchar(20) NOT NULL,
789 `name` varchar(40) NOT NULL,
790 `decimals` tinyint(2) NOT NULL,
791 `inactive` tinyint(1) NOT NULL DEFAULT '0',
792 PRIMARY KEY (`abbr`),
793 UNIQUE KEY `name` (`name`)
796 -- Data of table `0_item_units` --
798 INSERT INTO `0_item_units` VALUES
799 ('each', 'Each', '0', '0'),
800 ('hr', 'Hours', '0', '0');
802 -- Structure of table `0_journal` --
804 DROP TABLE IF EXISTS `0_journal`;
806 CREATE TABLE `0_journal` (
807 `type` smallint(6) NOT NULL DEFAULT '0',
808 `trans_no` int(11) NOT NULL DEFAULT '0',
809 `tran_date` date DEFAULT '0000-00-00',
810 `reference` varchar(60) NOT NULL DEFAULT '',
811 `source_ref` varchar(60) NOT NULL DEFAULT '',
812 `event_date` date DEFAULT '0000-00-00',
813 `doc_date` date NOT NULL DEFAULT '0000-00-00',
814 `currency` char(3) NOT NULL DEFAULT '',
815 `amount` double NOT NULL DEFAULT '0',
816 `rate` double NOT NULL DEFAULT '1',
817 PRIMARY KEY (`type`,`trans_no`),
818 KEY `tran_date` (`tran_date`)
821 -- Data of table `0_journal` --
823 -- Structure of table `0_loc_stock` --
825 DROP TABLE IF EXISTS `0_loc_stock`;
827 CREATE TABLE `0_loc_stock` (
828 `loc_code` char(5) NOT NULL DEFAULT '',
829 `stock_id` char(20) NOT NULL DEFAULT '',
830 `reorder_level` double NOT NULL DEFAULT '0',
831 PRIMARY KEY (`loc_code`,`stock_id`),
832 KEY `stock_id` (`stock_id`)
835 -- Data of table `0_loc_stock` --
837 -- Structure of table `0_locations` --
839 DROP TABLE IF EXISTS `0_locations`;
841 CREATE TABLE `0_locations` (
842 `loc_code` varchar(5) NOT NULL DEFAULT '',
843 `location_name` varchar(60) NOT NULL DEFAULT '',
844 `delivery_address` tinytext NOT NULL,
845 `phone` varchar(30) NOT NULL DEFAULT '',
846 `phone2` varchar(30) NOT NULL DEFAULT '',
847 `fax` varchar(30) NOT NULL DEFAULT '',
848 `email` varchar(100) NOT NULL DEFAULT '',
849 `contact` varchar(30) NOT NULL DEFAULT '',
850 `fixed_asset` tinyint(1) NOT NULL DEFAULT '0',
851 `inactive` tinyint(1) NOT NULL DEFAULT '0',
852 PRIMARY KEY (`loc_code`)
855 -- Data of table `0_locations` --
857 INSERT INTO `0_locations` VALUES
858 ('DEF', 'Default', 'N/A', '', '', '', '', '', '0', '0');
860 -- Structure of table `0_payment_terms` --
862 DROP TABLE IF EXISTS `0_payment_terms`;
864 CREATE TABLE `0_payment_terms` (
865 `id` int(11) NOT NULL AUTO_INCREMENT,
866 `terms` char(80) NOT NULL DEFAULT '',
867 `type` tinyint(1) NOT NULL DEFAULT '1'
868 `days` int(11) NOT NULL DEFAULT '0'
869 `early_discount` double NOT NULL DEFAULT '0'
870 `early_days` double NOT NULL DEFAULT '0',
871 `inactive` tinyint(1) NOT NULL DEFAULT '0',
873 UNIQUE KEY `terms` (`terms`)
874 ) ENGINE=InnoDB AUTO_INCREMENT=6 ;
876 -- Data of table `0_payment_terms` --
878 INSERT INTO `0_payment_terms` VALUES
879 ('1', 'Due 15th Of the Following Month', '4', '17', '0', '0', '0'),
880 ('2', 'Due By End Of The Following Month', '4', '31', '0', '0', '0'),
881 ('3', 'Payment due within 10 days', '3', '10', '0', '0', '0'),
882 ('4', 'Cash Only', '2', '0', '0', '0', '0'),
883 ('5', 'Prepaid', '1', '0', '0', '0', '0');
885 -- Structure of table `0_prices` --
887 DROP TABLE IF EXISTS `0_prices`;
889 CREATE TABLE `0_prices` (
890 `id` int(11) NOT NULL AUTO_INCREMENT,
891 `stock_id` varchar(20) NOT NULL DEFAULT '',
892 `sales_type_id` int(11) NOT NULL DEFAULT '0',
893 `curr_abrev` char(3) NOT NULL DEFAULT '',
894 `price` double NOT NULL DEFAULT '0',
896 UNIQUE KEY `price` (`stock_id`,`sales_type_id`,`curr_abrev`)
899 -- Data of table `0_prices` --
901 -- Structure of table `0_print_profiles` --
903 DROP TABLE IF EXISTS `0_print_profiles`;
905 CREATE TABLE `0_print_profiles` (
906 `id` smallint(6) unsigned NOT NULL AUTO_INCREMENT,
907 `profile` varchar(30) NOT NULL,
908 `report` varchar(5) DEFAULT NULL,
909 `printer` tinyint(3) unsigned DEFAULT NULL,
911 UNIQUE KEY `profile` (`profile`,`report`)
912 ) ENGINE=InnoDB AUTO_INCREMENT=10 ;
914 -- Data of table `0_print_profiles` --
916 INSERT INTO `0_print_profiles` VALUES
917 ('1', 'Out of office', NULL, '0'),
918 ('2', 'Sales Department', NULL, '0'),
919 ('3', 'Central', NULL, '2'),
920 ('4', 'Sales Department', '104', '2'),
921 ('5', 'Sales Department', '105', '2'),
922 ('6', 'Sales Department', '107', '2'),
923 ('7', 'Sales Department', '109', '2'),
924 ('8', 'Sales Department', '110', '2'),
925 ('9', 'Sales Department', '201', '2');
927 -- Structure of table `0_printers` --
929 DROP TABLE IF EXISTS `0_printers`;
931 CREATE TABLE `0_printers` (
932 `id` tinyint(3) unsigned NOT NULL AUTO_INCREMENT,
933 `name` varchar(20) NOT NULL,
934 `description` varchar(60) NOT NULL,
935 `queue` varchar(20) NOT NULL,
936 `host` varchar(40) NOT NULL,
937 `port` smallint(11) unsigned NOT NULL,
938 `timeout` tinyint(3) unsigned NOT NULL,
940 UNIQUE KEY `name` (`name`)
941 ) ENGINE=InnoDB AUTO_INCREMENT=4 ;
943 -- Data of table `0_printers` --
945 INSERT INTO `0_printers` VALUES
946 ('1', 'QL500', 'Label printer', 'QL500', 'server', '127', '20'),
947 ('2', 'Samsung', 'Main network printer', 'scx4521F', 'server', '515', '5'),
948 ('3', 'Local', 'Local print server at user IP', 'lp', '', '515', '10');
950 -- Structure of table `0_purch_data` --
952 DROP TABLE IF EXISTS `0_purch_data`;
954 CREATE TABLE `0_purch_data` (
955 `supplier_id` int(11) NOT NULL DEFAULT '0',
956 `stock_id` char(20) NOT NULL DEFAULT '',
957 `price` double NOT NULL DEFAULT '0',
958 `suppliers_uom` char(50) NOT NULL DEFAULT '',
959 `conversion_factor` double NOT NULL DEFAULT '1',
960 `supplier_description` char(50) NOT NULL DEFAULT '',
961 PRIMARY KEY (`supplier_id`,`stock_id`)
964 -- Data of table `0_purch_data` --
966 -- Structure of table `0_purch_order_details` --
968 DROP TABLE IF EXISTS `0_purch_order_details`;
970 CREATE TABLE `0_purch_order_details` (
971 `po_detail_item` int(11) NOT NULL AUTO_INCREMENT,
972 `order_no` int(11) NOT NULL DEFAULT '0',
973 `item_code` varchar(20) NOT NULL DEFAULT '',
974 `description` tinytext,
975 `delivery_date` date NOT NULL DEFAULT '0000-00-00',
976 `qty_invoiced` double NOT NULL DEFAULT '0',
977 `unit_price` double NOT NULL DEFAULT '0',
978 `act_price` double NOT NULL DEFAULT '0',
979 `std_cost_unit` double NOT NULL DEFAULT '0',
980 `quantity_ordered` double NOT NULL DEFAULT '0',
981 `quantity_received` double NOT NULL DEFAULT '0',
982 PRIMARY KEY (`po_detail_item`),
983 KEY `order` (`order_no`,`po_detail_item`),
984 KEY `itemcode` (`item_code`)
987 -- Data of table `0_purch_order_details` --
989 -- Structure of table `0_purch_orders` --
991 DROP TABLE IF EXISTS `0_purch_orders`;
993 CREATE TABLE `0_purch_orders` (
994 `order_no` int(11) NOT NULL AUTO_INCREMENT,
995 `supplier_id` int(11) NOT NULL DEFAULT '0',
997 `ord_date` date NOT NULL DEFAULT '0000-00-00',
998 `reference` tinytext NOT NULL,
999 `supp_reference` tinytext,
1000 `into_stock_location` varchar(5) NOT NULL DEFAULT '',
1001 `delivery_address` tinytext NOT NULL,
1002 `total` double NOT NULL DEFAULT '0',
1003 `prep_amount` double NOT NULL DEFAULT '0',
1004 `alloc` double NOT NULL DEFAULT '0',
1005 `tax_included` tinyint(1) NOT NULL DEFAULT '0',
1006 PRIMARY KEY (`order_no`),
1007 KEY `ord_date` (`ord_date`)
1010 -- Data of table `0_purch_orders` --
1012 -- Structure of table `0_quick_entries` --
1014 DROP TABLE IF EXISTS `0_quick_entries`;
1016 CREATE TABLE `0_quick_entries` (
1017 `id` smallint(6) unsigned NOT NULL AUTO_INCREMENT,
1018 `type` tinyint(1) NOT NULL DEFAULT '0',
1019 `description` varchar(60) NOT NULL,
1020 `usage` varchar(120) DEFAULT NULL,
1021 `base_amount` double NOT NULL DEFAULT '0',
1022 `base_desc` varchar(60) DEFAULT NULL,
1023 `bal_type` tinyint(1) NOT NULL DEFAULT '0',
1025 KEY `description` (`description`)
1026 ) ENGINE=InnoDB AUTO_INCREMENT=4 ;
1028 -- Data of table `0_quick_entries` --
1030 INSERT INTO `0_quick_entries` VALUES
1031 ('1', '1', 'Maintenance', NULL, '0', 'Amount', '0'),
1032 ('2', '4', 'Phone', NULL, '0', 'Amount', '0'),
1033 ('3', '2', 'Cash Sales', 'Retail sales without invoice', '0', 'Amount', '0');
1035 -- Structure of table `0_quick_entry_lines` --
1037 DROP TABLE IF EXISTS `0_quick_entry_lines`;
1039 CREATE TABLE `0_quick_entry_lines` (
1040 `id` smallint(6) unsigned NOT NULL AUTO_INCREMENT,
1041 `qid` smallint(6) unsigned NOT NULL,
1042 `amount` double DEFAULT '0',
1043 `memo` tinytext NOT NULL,
1044 `action` varchar(2) NOT NULL,
1045 `dest_id` varchar(15) NOT NULL DEFAULT '',
1046 `dimension_id` smallint(6) unsigned DEFAULT NULL,
1047 `dimension2_id` smallint(6) unsigned DEFAULT NULL,
1050 ) ENGINE=InnoDB AUTO_INCREMENT=7 ;
1052 -- Data of table `0_quick_entry_lines` --
1054 INSERT INTO `0_quick_entry_lines` VALUES
1055 ('1', '1', '0', '', 't-', '1', '0', '0'),
1056 ('2', '2', '0', '', 't-', '1', '0', '0'),
1057 ('3', '3', '0', '', 't-', '1', '0', '0'),
1058 ('4', '3', '0', '', '=', '4010', '0', '0'),
1059 ('5', '1', '0', '', '=', '5765', '0', '0'),
1060 ('6', '2', '0', '', '=', '5780', '0', '0');
1062 -- Structure of table `0_recurrent_invoices` --
1064 DROP TABLE IF EXISTS `0_recurrent_invoices`;
1066 CREATE TABLE `0_recurrent_invoices` (
1067 `id` smallint(6) unsigned NOT NULL AUTO_INCREMENT,
1068 `description` varchar(60) NOT NULL DEFAULT '',
1069 `order_no` int(11) unsigned NOT NULL,
1070 `debtor_no` int(11) unsigned DEFAULT NULL,
1071 `group_no` smallint(6) unsigned DEFAULT NULL,
1072 `days` int(11) NOT NULL DEFAULT '0',
1073 `monthly` int(11) NOT NULL DEFAULT '0',
1074 `begin` date NOT NULL DEFAULT '0000-00-00',
1075 `end` date NOT NULL DEFAULT '0000-00-00',
1076 `last_sent` date NOT NULL DEFAULT '0000-00-00',
1078 UNIQUE KEY `description` (`description`)
1081 -- Data of table `0_recurrent_invoices` --
1083 -- Structure of table `0_reflines` --
1085 DROP TABLE IF EXISTS `0_reflines`;
1087 CREATE TABLE `0_reflines` (
1088 `id` int(11) NOT NULL AUTO_INCREMENT,
1089 `trans_type` int(11) NOT NULL,
1090 `prefix` char(5) NOT NULL DEFAULT '',
1091 `pattern` varchar(35) NOT NULL DEFAULT '1',
1092 `description` varchar(60) NOT NULL DEFAULT '',
1093 `default` tinyint(1) NOT NULL DEFAULT '0',
1094 `inactive` tinyint(1) NOT NULL DEFAULT '0',
1096 UNIQUE KEY `prefix` (`trans_type`,`prefix`)
1097 ) ENGINE=InnoDB AUTO_INCREMENT=23 ;
1099 -- Data of table `0_reflines` --
1101 INSERT INTO `0_reflines` VALUES
1102 ('1', '0', '', '{001}/{YYYY}', '', '1', '0'),
1103 ('2', '1', '', '{001}/{YYYY}', '', '1', '0'),
1104 ('3', '2', '', '{001}/{YYYY}', '', '1', '0'),
1105 ('4', '4', '', '{001}/{YYYY}', '', '1', '0'),
1106 ('5', '10', '', '{001}/{YYYY}', '', '1', '0'),
1107 ('6', '11', '', '{001}/{YYYY}', '', '1', '0'),
1108 ('7', '12', '', '{001}/{YYYY}', '', '1', '0'),
1109 ('8', '13', '', '{001}/{YYYY}', '', '1', '0'),
1110 ('9', '16', '', '{001}/{YYYY}', '', '1', '0'),
1111 ('10', '17', '', '{001}/{YYYY}', '', '1', '0'),
1112 ('11', '18', '', '{001}/{YYYY}', '', '1', '0'),
1113 ('12', '20', '', '{001}/{YYYY}', '', '1', '0'),
1114 ('13', '21', '', '{001}/{YYYY}', '', '1', '0'),
1115 ('14', '22', '', '{001}/{YYYY}', '', '1', '0'),
1116 ('15', '25', '', '{001}/{YYYY}', '', '1', '0'),
1117 ('16', '26', '', '{001}/{YYYY}', '', '1', '0'),
1118 ('17', '28', '', '{001}/{YYYY}', '', '1', '0'),
1119 ('18', '29', '', '{001}/{YYYY}', '', '1', '0'),
1120 ('19', '30', '', '{001}/{YYYY}', '', '1', '0'),
1121 ('20', '32', '', '{001}/{YYYY}', '', '1', '0'),
1122 ('21', '35', '', '{001}/{YYYY}', '', '1', '0'),
1123 ('22', '40', '', '{001}/{YYYY}', '', '1', '0');
1125 -- Structure of table `0_refs` --
1127 DROP TABLE IF EXISTS `0_refs`;
1129 CREATE TABLE `0_refs` (
1130 `id` int(11) NOT NULL DEFAULT '0',
1131 `type` int(11) NOT NULL DEFAULT '0',
1132 `reference` varchar(100) NOT NULL DEFAULT '',
1133 PRIMARY KEY (`id`,`type`),
1134 KEY `Type_and_Reference` (`type`,`reference`)
1137 -- Data of table `0_refs` --
1139 -- Structure of table `0_sales_order_details` --
1141 DROP TABLE IF EXISTS `0_sales_order_details`;
1143 CREATE TABLE `0_sales_order_details` (
1144 `id` int(11) NOT NULL AUTO_INCREMENT,
1145 `order_no` int(11) NOT NULL DEFAULT '0',
1146 `trans_type` smallint(6) NOT NULL DEFAULT '30',
1147 `stk_code` varchar(20) NOT NULL DEFAULT '',
1148 `description` tinytext,
1149 `qty_sent` double NOT NULL DEFAULT '0',
1150 `unit_price` double NOT NULL DEFAULT '0',
1151 `quantity` double NOT NULL DEFAULT '0',
1152 `invoiced` double NOT NULL DEFAULT '0',
1153 `discount_percent` double NOT NULL DEFAULT '0',
1155 KEY `sorder` (`trans_type`,`order_no`),
1156 KEY `stkcode` (`stk_code`)
1159 -- Data of table `0_sales_order_details` --
1161 -- Structure of table `0_sales_orders` --
1163 DROP TABLE IF EXISTS `0_sales_orders`;
1165 CREATE TABLE `0_sales_orders` (
1166 `order_no` int(11) NOT NULL,
1167 `trans_type` smallint(6) NOT NULL DEFAULT '30',
1168 `version` tinyint(1) unsigned NOT NULL DEFAULT '0',
1169 `type` tinyint(1) NOT NULL DEFAULT '0',
1170 `debtor_no` int(11) NOT NULL DEFAULT '0',
1171 `branch_code` int(11) NOT NULL DEFAULT '0',
1172 `reference` varchar(100) NOT NULL DEFAULT '',
1173 `customer_ref` tinytext NOT NULL,
1174 `comments` tinytext,
1175 `ord_date` date NOT NULL DEFAULT '0000-00-00',
1176 `order_type` int(11) NOT NULL DEFAULT '0',
1177 `ship_via` varchar(20) NOT NULL DEFAULT '',
1178 `delivery_address` tinytext NOT NULL,
1179 `contact_phone` varchar(30) DEFAULT NULL,
1180 `contact_email` varchar(100) DEFAULT NULL,
1181 `deliver_to` tinytext NOT NULL,
1182 `freight_cost` double NOT NULL DEFAULT '0',
1183 `from_stk_loc` varchar(5) NOT NULL DEFAULT '',
1184 `delivery_date` date NOT NULL DEFAULT '0000-00-00',
1185 `payment_terms` int(11) DEFAULT NULL,
1186 `total` double NOT NULL DEFAULT '0',
1187 `prep_amount` double NOT NULL DEFAULT '0',
1188 `alloc` double NOT NULL DEFAULT '0',
1189 PRIMARY KEY (`trans_type`,`order_no`)
1192 -- Data of table `0_sales_orders` --
1194 -- Structure of table `0_sales_pos` --
1196 DROP TABLE IF EXISTS `0_sales_pos`;
1198 CREATE TABLE `0_sales_pos` (
1199 `id` smallint(6) unsigned NOT NULL AUTO_INCREMENT,
1200 `pos_name` varchar(30) NOT NULL,
1201 `cash_sale` tinyint(1) NOT NULL,
1202 `credit_sale` tinyint(1) NOT NULL,
1203 `pos_location` varchar(5) NOT NULL,
1204 `pos_account` smallint(6) unsigned NOT NULL,
1205 `inactive` tinyint(1) NOT NULL DEFAULT '0',
1207 UNIQUE KEY `pos_name` (`pos_name`)
1208 ) ENGINE=InnoDB AUTO_INCREMENT=2 ;
1210 -- Data of table `0_sales_pos` --
1212 INSERT INTO `0_sales_pos` VALUES
1213 ('1', 'Default', '1', '1', 'DEF', '2', '0');
1215 -- Structure of table `0_sales_types` --
1217 DROP TABLE IF EXISTS `0_sales_types`;
1219 CREATE TABLE `0_sales_types` (
1220 `id` int(11) NOT NULL AUTO_INCREMENT,
1221 `sales_type` char(50) NOT NULL DEFAULT '',
1222 `tax_included` int(1) NOT NULL DEFAULT '0',
1223 `factor` double NOT NULL DEFAULT '1',
1224 `inactive` tinyint(1) NOT NULL DEFAULT '0',
1226 UNIQUE KEY `sales_type` (`sales_type`)
1227 ) ENGINE=InnoDB AUTO_INCREMENT=3 ;
1229 -- Data of table `0_sales_types` --
1231 INSERT INTO `0_sales_types` VALUES
1232 ('1', 'Retail', '1', '1', '0'),
1233 ('2', 'Wholesale', '0', '0.7', '0');
1235 -- Structure of table `0_salesman` --
1237 DROP TABLE IF EXISTS `0_salesman`;
1239 CREATE TABLE `0_salesman` (
1240 `salesman_code` int(11) NOT NULL AUTO_INCREMENT,
1241 `salesman_name` char(60) NOT NULL DEFAULT '',
1242 `salesman_phone` char(30) NOT NULL DEFAULT '',
1243 `salesman_fax` char(30) NOT NULL DEFAULT '',
1244 `salesman_email` varchar(100) NOT NULL DEFAULT '',
1245 `provision` double NOT NULL DEFAULT '0',
1246 `break_pt` double NOT NULL DEFAULT '0',
1247 `provision2` double NOT NULL DEFAULT '0',
1248 `inactive` tinyint(1) NOT NULL DEFAULT '0',
1249 PRIMARY KEY (`salesman_code`),
1250 UNIQUE KEY `salesman_name` (`salesman_name`)
1251 ) ENGINE=InnoDB AUTO_INCREMENT=2 ;
1253 -- Data of table `0_salesman` --
1255 INSERT INTO `0_salesman` VALUES
1256 ('1', 'Sales Person', '', '', '', '5', '1000', '4', '0');
1258 -- Structure of table `0_security_roles` --
1260 DROP TABLE IF EXISTS `0_security_roles`;
1262 CREATE TABLE `0_security_roles` (
1263 `id` int(11) NOT NULL AUTO_INCREMENT,
1264 `role` varchar(30) NOT NULL,
1265 `description` varchar(50) DEFAULT NULL,
1268 `inactive` tinyint(1) NOT NULL DEFAULT '0',
1270 UNIQUE KEY `role` (`role`)
1271 ) ENGINE=InnoDB AUTO_INCREMENT=11 ;
1273 -- Data of table `0_security_roles` --
1275 INSERT INTO `0_security_roles` VALUES
1276 ('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'),
1277 ('2', 'System Administrator', 'System Administrator', '256;512;768;2816;3072;3328;5376;5632;5888;7936;8192;8448;9472;9728;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;9217;9218;9220;9473;9474;9475;9476;9729;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'),
1278 ('3', 'Salesman', 'Salesman', '768;3072;5632;8192;15872', '773;774;3073;3075;3081;5633;8194;15873;775', '0'),
1279 ('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'),
1280 ('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'),
1281 ('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'),
1282 ('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'),
1283 ('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'),
1284 ('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'),
1285 ('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');
1287 -- Structure of table `0_shippers` --
1289 DROP TABLE IF EXISTS `0_shippers`;
1291 CREATE TABLE `0_shippers` (
1292 `shipper_id` int(11) NOT NULL AUTO_INCREMENT,
1293 `shipper_name` varchar(60) NOT NULL DEFAULT '',
1294 `phone` varchar(30) NOT NULL DEFAULT '',
1295 `phone2` varchar(30) NOT NULL DEFAULT '',
1296 `contact` tinytext NOT NULL,
1297 `address` tinytext NOT NULL,
1298 `inactive` tinyint(1) NOT NULL DEFAULT '0',
1299 PRIMARY KEY (`shipper_id`),
1300 UNIQUE KEY `name` (`shipper_name`)
1301 ) ENGINE=InnoDB AUTO_INCREMENT=2 ;
1303 -- Data of table `0_shippers` --
1305 INSERT INTO `0_shippers` VALUES
1306 ('1', 'Default', '', '', '', '', '0');
1308 -- Structure of table `0_stock_category` --
1310 DROP TABLE IF EXISTS `0_stock_category`;
1312 CREATE TABLE `0_stock_category` (
1313 `category_id` int(11) NOT NULL AUTO_INCREMENT,
1314 `description` varchar(60) NOT NULL DEFAULT '',
1315 `dflt_tax_type` int(11) NOT NULL DEFAULT '1',
1316 `dflt_units` varchar(20) NOT NULL DEFAULT 'each',
1317 `dflt_mb_flag` char(1) NOT NULL DEFAULT 'B',
1318 `dflt_sales_act` varchar(15) NOT NULL DEFAULT '',
1319 `dflt_cogs_act` varchar(15) NOT NULL DEFAULT '',
1320 `dflt_inventory_act` varchar(15) NOT NULL DEFAULT '',
1321 `dflt_adjustment_act` varchar(15) NOT NULL DEFAULT '',
1322 `dflt_wip_act` varchar(15) NOT NULL DEFAULT '',
1323 `dflt_dim1` int(11) DEFAULT NULL,
1324 `dflt_dim2` int(11) DEFAULT NULL,
1325 `inactive` tinyint(1) NOT NULL DEFAULT '0',
1326 `dflt_no_sale` tinyint(1) NOT NULL DEFAULT '0',
1327 `dflt_no_purchase` tinyint(1) NOT NULL DEFAULT '0',
1328 `vat_category` tinyint(1) NOT NULL DEFAULT '0',
1329 PRIMARY KEY (`category_id`),
1330 UNIQUE KEY `description` (`description`)
1331 ) ENGINE=InnoDB AUTO_INCREMENT=5 ;
1333 -- Data of table `0_stock_category` --
1335 INSERT INTO `0_stock_category` VALUES
1336 ('1', 'Components', '1', 'each', 'B', '4010', '5010', '1510', '5040', '1530', '0', '0', '0', '0', '0', '0'),
1337 ('2', 'Charges', '1', 'each', 'D', '4010', '5010', '1510', '5040', '1530', '0', '0', '0', '0', '0', '0'),
1338 ('3', 'Systems', '1', 'each', 'M', '4010', '5010', '1510', '5040', '1530', '0', '0', '0', '0', '0', '0'),
1339 ('4', 'Services', '1', 'hr', 'D', '4010', '5010', '1510', '5040', '1530', '0', '0', '0', '0', '0', '0'),
1340 ('5', 'Shipping', '1', 'each', 'T', '4430', '5010', '', '', '', '0', '0', '0', '1', '0', '0');
1342 -- Structure of table `0_stock_fa_class` --
1344 DROP TABLE IF EXISTS `0_stock_fa_class`;
1346 CREATE TABLE `0_stock_fa_class` (
1347 `fa_class_id` varchar(20) NOT NULL DEFAULT '',
1348 `parent_id` varchar(20) NOT NULL DEFAULT '',
1349 `description` varchar(200) NOT NULL DEFAULT '',
1350 `long_description` tinytext NOT NULL,
1351 `depreciation_rate` double NOT NULL DEFAULT '0',
1352 `inactive` tinyint(1) NOT NULL DEFAULT '0',
1353 PRIMARY KEY (`fa_class_id`)
1356 -- Data of table `0_stock_fa_class` --
1358 -- Structure of table `0_stock_master` --
1360 DROP TABLE IF EXISTS `0_stock_master`;
1362 CREATE TABLE `0_stock_master` (
1363 `stock_id` varchar(20) NOT NULL DEFAULT '',
1364 `category_id` int(11) NOT NULL DEFAULT '0',
1365 `tax_type_id` int(11) NOT NULL DEFAULT '0',
1366 `description` varchar(200) NOT NULL DEFAULT '',
1367 `long_description` tinytext NOT NULL,
1368 `units` varchar(20) NOT NULL DEFAULT 'each',
1369 `mb_flag` char(1) NOT NULL DEFAULT 'B',
1370 `sales_account` varchar(15) NOT NULL DEFAULT '',
1371 `cogs_account` varchar(15) NOT NULL DEFAULT '',
1372 `inventory_account` varchar(15) NOT NULL DEFAULT '',
1373 `adjustment_account` varchar(15) NOT NULL DEFAULT '',
1374 `wip_account` varchar(15) NOT NULL DEFAULT '',
1375 `dimension_id` int(11) DEFAULT NULL,
1376 `dimension2_id` int(11) DEFAULT NULL,
1377 `purchase_cost` double NOT NULL DEFAULT '0',
1378 `material_cost` double NOT NULL DEFAULT '0',
1379 `labour_cost` double NOT NULL DEFAULT '0',
1380 `overhead_cost` double NOT NULL DEFAULT '0',
1381 `inactive` tinyint(1) NOT NULL DEFAULT '0',
1382 `no_sale` tinyint(1) NOT NULL DEFAULT '0',
1383 `no_purchase` tinyint(1) NOT NULL DEFAULT '0',
1384 `editable` tinyint(1) NOT NULL DEFAULT '0',
1385 `depreciation_method` char(1) NOT NULL DEFAULT 'S',
1386 `depreciation_rate` double NOT NULL DEFAULT '0',
1387 `depreciation_factor` double NOT NULL DEFAULT '1',
1388 `depreciation_start` date NOT NULL DEFAULT '0000-00-00',
1389 `depreciation_date` date NOT NULL DEFAULT '0000-00-00',
1390 `fa_class_id` varchar(20) NOT NULL DEFAULT '',
1391 `vat_category` tinyint(1) NOT NULL DEFAULT '0',
1392 `shipper_id` int(11) NOT NULL DEFAULT '0',
1393 PRIMARY KEY (`stock_id`)
1396 -- Data of table `0_stock_master` --
1397 INSERT INTO `0_stock_master` VALUES
1398 ('post-std', '5', '1', 'Standard post package', '', 'each', 'T', '4430', '5010', '', '', '', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', 'S', '0', '1', '0000-00-00', '0000-00-00', '', '0', '0');
1399 -- Structure of table `0_stock_moves` --
1401 DROP TABLE IF EXISTS `0_stock_moves`;
1403 CREATE TABLE `0_stock_moves` (
1404 `trans_id` int(11) NOT NULL AUTO_INCREMENT,
1405 `trans_no` int(11) NOT NULL DEFAULT '0',
1406 `stock_id` char(20) NOT NULL DEFAULT '',
1407 `type` smallint(6) NOT NULL DEFAULT '0',
1408 `loc_code` char(5) NOT NULL DEFAULT '',
1409 `tran_date` date NOT NULL DEFAULT '0000-00-00',
1410 `price` double NOT NULL DEFAULT '0',
1411 `reference` char(40) NOT NULL DEFAULT '',
1412 `qty` double NOT NULL DEFAULT '1',
1413 `unit_cost` double NOT NULL DEFAULT '0',
1414 PRIMARY KEY (`trans_id`),
1415 KEY `type` (`type`,`trans_no`),
1416 KEY `Move` (`stock_id`,`loc_code`,`tran_date`)
1419 -- Data of table `0_stock_moves` --
1421 -- Structure of table `0_supp_allocations` --
1423 DROP TABLE IF EXISTS `0_supp_allocations`;
1425 CREATE TABLE `0_supp_allocations` (
1426 `id` int(11) NOT NULL AUTO_INCREMENT,
1427 `person_id` int(11) DEFAULT NULL,
1428 `amt` double unsigned DEFAULT NULL,
1429 `date_alloc` date NOT NULL DEFAULT '0000-00-00',
1430 `trans_no_from` int(11) DEFAULT NULL,
1431 `trans_type_from` int(11) DEFAULT NULL,
1432 `trans_no_to` int(11) DEFAULT NULL,
1433 `trans_type_to` int(11) DEFAULT NULL,
1435 UNIQUE KEY `trans_type_from` (`person_id`,`trans_type_from`,`trans_no_from`,`trans_type_to`,`trans_no_to`),
1436 KEY `From` (`trans_type_from`,`trans_no_from`),
1437 KEY `To` (`trans_type_to`,`trans_no_to`)
1440 -- Data of table `0_supp_allocations` --
1442 -- Structure of table `0_supp_invoice_items` --
1444 DROP TABLE IF EXISTS `0_supp_invoice_items`;
1446 CREATE TABLE `0_supp_invoice_items` (
1447 `id` int(11) NOT NULL AUTO_INCREMENT,
1448 `supp_trans_no` int(11) DEFAULT NULL,
1449 `supp_trans_type` int(11) DEFAULT NULL,
1450 `gl_code` varchar(15) NOT NULL DEFAULT '',
1451 `grn_item_id` int(11) DEFAULT NULL,
1452 `po_detail_item_id` int(11) DEFAULT NULL,
1453 `stock_id` varchar(20) NOT NULL DEFAULT '',
1454 `description` tinytext,
1455 `quantity` double NOT NULL DEFAULT '0',
1456 `unit_price` double NOT NULL DEFAULT '0',
1457 `unit_tax` double NOT NULL DEFAULT '0',
1459 `dimension_id` int(11) NOT NULL DEFAULT '0',
1460 `dimension2_id` int(11) NOT NULL DEFAULT '0',
1462 KEY `Transaction` (`supp_trans_type`,`supp_trans_no`,`stock_id`)
1465 -- Data of table `0_supp_invoice_items` --
1467 -- Structure of table `0_supp_trans` --
1469 DROP TABLE IF EXISTS `0_supp_trans`;
1471 CREATE TABLE `0_supp_trans` (
1472 `trans_no` int(11) unsigned NOT NULL DEFAULT '0',
1473 `type` smallint(6) unsigned NOT NULL DEFAULT '0',
1474 `supplier_id` int(11) unsigned NOT NULL,
1475 `reference` tinytext NOT NULL,
1476 `supp_reference` varchar(60) NOT NULL DEFAULT '',
1477 `tran_date` date NOT NULL DEFAULT '0000-00-00',
1478 `due_date` date NOT NULL DEFAULT '0000-00-00',
1479 `ov_amount` double NOT NULL DEFAULT '0',
1480 `ov_discount` double NOT NULL DEFAULT '0',
1481 `ov_gst` double NOT NULL DEFAULT '0',
1482 `rate` double NOT NULL DEFAULT '1',
1483 `alloc` double NOT NULL DEFAULT '0',
1484 `tax_included` tinyint(1) NOT NULL DEFAULT '0',
1485 PRIMARY KEY (`type`,`trans_no`,`supplier_id`),
1486 KEY `supplier_id` (`supplier_id`),
1487 KEY `tran_date` (`tran_date`)
1490 -- Data of table `0_supp_trans` --
1492 -- Structure of table `0_suppliers` --
1494 DROP TABLE IF EXISTS `0_suppliers`;
1496 CREATE TABLE `0_suppliers` (
1497 `supplier_id` int(11) NOT NULL AUTO_INCREMENT,
1498 `supp_name` varchar(60) NOT NULL DEFAULT '',
1499 `supp_ref` varchar(30) NOT NULL DEFAULT '',
1500 `address` tinytext NOT NULL,
1501 `supp_address` tinytext NOT NULL,
1502 `gst_no` varchar(25) NOT NULL DEFAULT '',
1503 `contact` varchar(60) NOT NULL DEFAULT '',
1504 `supp_account_no` varchar(40) NOT NULL DEFAULT '',
1505 `website` varchar(100) NOT NULL DEFAULT '',
1506 `bank_account` varchar(60) NOT NULL DEFAULT '',
1507 `curr_code` char(3) DEFAULT NULL,
1508 `payment_terms` int(11) DEFAULT NULL,
1509 `tax_included` tinyint(1) NOT NULL DEFAULT '0',
1510 `dimension_id` int(11) DEFAULT '0',
1511 `dimension2_id` int(11) DEFAULT '0',
1512 `tax_group_id` int(11) DEFAULT NULL,
1513 `credit_limit` double NOT NULL DEFAULT '0',
1514 `purchase_account` varchar(15) NOT NULL DEFAULT '',
1515 `payable_account` varchar(15) NOT NULL DEFAULT '',
1516 `payment_discount_account` varchar(15) NOT NULL DEFAULT '',
1517 `notes` tinytext NOT NULL,
1518 `inactive` tinyint(1) NOT NULL DEFAULT '0',
1519 PRIMARY KEY (`supplier_id`),
1520 KEY `supp_ref` (`supp_ref`)
1523 -- Data of table `0_suppliers` --
1525 -- Structure of table `0_sys_prefs` --
1527 DROP TABLE IF EXISTS `0_sys_prefs`;
1529 CREATE TABLE `0_sys_prefs` (
1530 `name` varchar(35) NOT NULL DEFAULT '',
1531 `category` varchar(30) DEFAULT NULL,
1532 `type` varchar(20) NOT NULL DEFAULT '',
1533 `length` smallint(6) DEFAULT NULL,
1534 `value` text NOT NULL,
1535 PRIMARY KEY (`name`),
1536 KEY `category` (`category`)
1539 -- Data of table `0_sys_prefs` --
1541 INSERT INTO `0_sys_prefs` VALUES
1542 ('coy_name', 'setup.company', 'varchar', 60, 'Company name'),
1543 ('gst_no', 'setup.company', 'varchar', 25, ''),
1544 ('coy_no', 'setup.company', 'varchar', 25, ''),
1545 ('tax_prd', 'setup.company', 'int', 11, '1'),
1546 ('tax_last', 'setup.company', 'int', 11, '1'),
1547 ('postal_address', 'setup.company', 'tinytext', 0, 'N/A'),
1548 ('phone', 'setup.company', 'varchar', 30, ''),
1549 ('fax', 'setup.company', 'varchar', 30, ''),
1550 ('email', 'setup.company', 'varchar', 100, ''),
1551 ('coy_logo', 'setup.company', 'varchar', 100, ''),
1552 ('domicile', 'setup.company', 'varchar', 55, ''),
1553 ('curr_default', 'setup.company', 'char', 3, 'USD'),
1554 ('use_dimension', 'setup.company', 'tinyint', 1, '1'),
1555 ('f_year', 'setup.company', 'int', 11, '1'),
1556 ('shortname_name_in_list','setup.company', 'tinyint', 1, '0'),
1557 ('no_item_list', 'setup.company', 'tinyint', 1, '0'),
1558 ('no_customer_list', 'setup.company', 'tinyint', 1, '0'),
1559 ('no_supplier_list', 'setup.company', 'tinyint', 1, '0'),
1560 ('base_sales', 'setup.company', 'int', 11, '1'),
1561 ('time_zone', 'setup.company', 'tinyint', 1, '0'),
1562 ('add_pct', 'setup.company', 'int', 5, '-1'),
1563 ('round_to', 'setup.company', 'int', 5, '1'),
1564 ('login_tout', 'setup.company', 'smallint', 6, '600'),
1565 ('past_due_days', 'glsetup.general', 'int', 11, '30'),
1566 ('profit_loss_year_act', 'glsetup.general', 'varchar', 15, '9990'),
1567 ('retained_earnings_act', 'glsetup.general', 'varchar', 15, '3590'),
1568 ('bank_charge_act', 'glsetup.general', 'varchar', 15, '5690'),
1569 ('exchange_diff_act', 'glsetup.general', 'varchar', 15, '4450'),
1570 ('tax_algorithm', 'glsetup.customer', 'tinyint', 1, '1'),
1571 ('default_credit_limit', 'glsetup.customer', 'int', 11, '1000'),
1572 ('accumulate_shipping', 'glsetup.customer', 'tinyint', 1, '0'),
1573 ('legal_text', 'glsetup.customer', 'tinytext', 0, ''),
1574 ('freight_act', 'glsetup.customer', 'varchar', 15, '4430'),
1575 ('debtors_act', 'glsetup.sales', 'varchar', 15, '1200'),
1576 ('default_sales_act', 'glsetup.sales', 'varchar', 15, '4010'),
1577 ('default_sales_discount_act', 'glsetup.sales', 'varchar', 15, '4510'),
1578 ('default_prompt_payment_act', 'glsetup.sales', 'varchar', 15, '4500'),
1579 ('default_delivery_required', 'glsetup.sales', 'smallint', 6, '1'),
1580 ('default_receival_required', 'glsetup.purchase', 'smallint', 6, '10'),
1581 ('default_quote_valid_days', 'glsetup.sales', 'smallint', 6, '30'),
1582 ('default_dim_required', 'glsetup.dims', 'int', 11, '20'),
1583 ('pyt_discount_act', 'glsetup.purchase', 'varchar', 15, '5060'),
1584 ('creditors_act', 'glsetup.purchase', 'varchar', 15, '2100'),
1585 ('po_over_receive', 'glsetup.purchase', 'int', 11, '10'),
1586 ('po_over_charge', 'glsetup.purchase', 'int', 11, '10'),
1587 ('allow_negative_stock', 'glsetup.inventory', 'tinyint', 1, '0'),
1588 ('default_inventory_act', 'glsetup.items', 'varchar', 15, '1510'),
1589 ('default_cogs_act', 'glsetup.items', 'varchar', 15, '5010'),
1590 ('default_adj_act', 'glsetup.items', 'varchar', 15, '5040'),
1591 ('default_inv_sales_act', 'glsetup.items', 'varchar', 15, '4010'),
1592 ('default_wip_act', 'glsetup.items', 'varchar', 15, '1530'),
1593 ('default_workorder_required', 'glsetup.manuf', 'int', 11, '20'),
1594 ('version_id', 'system', 'varchar', 11, '2.5.0'),
1595 ('auto_curr_reval', 'setup.company', 'smallint', 6, '1'),
1596 ('grn_clearing_act', 'glsetup.purchase', 'varchar', 15, '1550'),
1597 ('bcc_email', 'setup.company', 'varchar', 100, ''),
1598 ('deferred_income_act', 'glsetup.sales', 'varchar', '15', '2105'),
1599 ('gl_closing_date','setup.closing_date', 'date', 8, ''),
1600 ('alternative_tax_include_on_docs','setup.company', 'tinyint', 1, '0'),
1601 ('no_zero_lines_amount','glsetup.sales', 'tinyint', 1, '1'),
1602 ('show_po_item_codes','glsetup.purchase', 'tinyint', 1, '0'),
1603 ('accounts_alpha','glsetup.general', 'tinyint', 1, '0'),
1604 ('loc_notification','glsetup.inventory', 'tinyint', 1, '0'),
1605 ('print_invoice_no','glsetup.sales', 'tinyint', 1, '0'),
1606 ('allow_negative_prices','glsetup.inventory', 'tinyint', 1, '1'),
1607 ('print_item_images_on_quote','glsetup.inventory', 'tinyint', 1, '0'),
1608 ('suppress_tax_rates','setup.company', 'tinyint', 1, '0'),
1609 ('company_logo_report','setup.company', 'tinyint', 1, '0'),
1610 ('barcodes_on_stock','setup.company', 'tinyint', 1, '0'),
1611 ('print_dialog_direct','setup.company', 'tinyint', 1, '0'),
1612 ('ref_no_auto_increase','setup.company', 'tinyint', 1, '0'),
1613 ('default_loss_on_asset_disposal_act', 'glsetup.items', 'varchar', '15', '5660'),
1614 ('depreciation_period', 'glsetup.company', 'tinyint', '1', '1'),
1615 ('use_manufacturing','setup.company', 'tinyint', 1, '1'),
1616 ('use_fixed_assets','setup.company', 'tinyint', 1, '1');
1618 -- Structure of table `0_tag_associations` --
1620 DROP TABLE IF EXISTS `0_tag_associations`;
1622 CREATE TABLE `0_tag_associations` (
1623 `record_id` varchar(15) NOT NULL,
1624 `tag_id` int(11) NOT NULL,
1625 PRIMARY KEY (`record_id`,`tag_id`)
1628 -- Data of table `0_tag_associations` --
1630 -- Structure of table `0_tags` --
1632 DROP TABLE IF EXISTS `0_tags`;
1634 CREATE TABLE `0_tags` (
1635 `id` int(11) NOT NULL AUTO_INCREMENT,
1636 `type` smallint(6) NOT NULL,
1637 `name` varchar(30) NOT NULL,
1638 `description` varchar(60) DEFAULT NULL,
1639 `inactive` tinyint(1) NOT NULL DEFAULT '0',
1641 UNIQUE KEY `type` (`type`,`name`)
1644 -- Data of table `0_tags` --
1646 -- Structure of table `0_tax_group_items` --
1648 DROP TABLE IF EXISTS `0_tax_group_items`;
1650 CREATE TABLE `0_tax_group_items` (
1651 `tax_group_id` int(11) NOT NULL DEFAULT '0',
1652 `tax_type_id` int(11) NOT NULL DEFAULT '0',
1653 PRIMARY KEY (`tax_group_id`,`tax_type_id`)
1656 -- Data of table `0_tax_group_items` --
1658 INSERT INTO `0_tax_group_items` VALUES
1661 -- Structure of table `0_tax_groups` --
1663 DROP TABLE IF EXISTS `0_tax_groups`;
1665 CREATE TABLE `0_tax_groups` (
1666 `id` int(11) NOT NULL AUTO_INCREMENT,
1667 `name` varchar(60) NOT NULL DEFAULT '',
1668 `tax_area` tinyint(1) NOT NULL DEFAULT '0',
1669 `inactive` tinyint(1) NOT NULL DEFAULT '0',
1671 UNIQUE KEY `name` (`name`)
1672 ) ENGINE=InnoDB AUTO_INCREMENT=3 ;
1674 -- Data of table `0_tax_groups` --
1676 INSERT INTO `0_tax_groups` VALUES
1677 ('1', 'Tax', '0', '0'),
1678 ('2', 'Export/Import', '1', '0');
1680 -- Structure of table `0_tax_types` --
1682 DROP TABLE IF EXISTS `0_tax_types`;
1684 CREATE TABLE `0_tax_types` (
1685 `id` int(11) NOT NULL AUTO_INCREMENT,
1686 `rate` double NOT NULL DEFAULT '0',
1687 `sales_gl_code` varchar(15) NOT NULL DEFAULT '',
1688 `purchasing_gl_code` varchar(15) NOT NULL DEFAULT '',
1689 `name` varchar(60) NOT NULL DEFAULT '',
1690 `inactive` tinyint(1) NOT NULL DEFAULT '0',
1692 ) ENGINE=InnoDB AUTO_INCREMENT=2 ;
1694 -- Data of table `0_tax_types` --
1696 INSERT INTO `0_tax_types` VALUES
1697 ('1', '5', '2150', '2150', 'Tax', '0');
1699 -- Structure of table `0_trans_tax_details` --
1701 DROP TABLE IF EXISTS `0_trans_tax_details`;
1703 CREATE TABLE `0_trans_tax_details` (
1704 `id` int(11) NOT NULL AUTO_INCREMENT,
1705 `trans_type` smallint(6) DEFAULT NULL,
1706 `trans_no` int(11) DEFAULT NULL,
1707 `tran_date` date NOT NULL,
1708 `tax_type_id` int(11) NOT NULL DEFAULT '0',
1709 `rate` double NOT NULL DEFAULT '0',
1710 `ex_rate` double NOT NULL DEFAULT '1',
1711 `included_in_price` tinyint(1) NOT NULL DEFAULT '0',
1712 `net_amount` double NOT NULL DEFAULT '0',
1713 `amount` double NOT NULL DEFAULT '0',
1715 `reg_type` tinyint(1) DEFAULT NULL,
1716 `vat_category` int(11) NOT NULL DEFAULT '0',
1717 `tax_group_id` tinyint(2) DEFAULT NULL,
1719 KEY `Type_and_Number` (`trans_type`,`trans_no`),
1720 KEY `tran_date` (`tran_date`)
1723 -- Data of table `0_trans_tax_details` --
1725 -- Structure of table `0_useronline` --
1727 DROP TABLE IF EXISTS `0_useronline`;
1729 CREATE TABLE `0_useronline` (
1730 `id` int(11) NOT NULL AUTO_INCREMENT,
1731 `timestamp` int(15) NOT NULL DEFAULT '0',
1732 `ip` varchar(40) NOT NULL DEFAULT '',
1733 `file` varchar(100) NOT NULL DEFAULT '',
1735 KEY `timestamp` (`timestamp`),
1739 -- Data of table `0_useronline` --
1742 -- Structure of table `0_users` --
1744 DROP TABLE IF EXISTS `0_users`;
1746 CREATE TABLE `0_users` (
1747 `id` smallint(6) NOT NULL AUTO_INCREMENT,
1748 `user_id` varchar(60) NOT NULL DEFAULT '',
1749 `password` varchar(100) NOT NULL DEFAULT '',
1750 `real_name` varchar(100) NOT NULL DEFAULT '',
1751 `role_id` int(11) NOT NULL DEFAULT '1',
1752 `phone` varchar(30) NOT NULL DEFAULT '',
1753 `email` varchar(100) DEFAULT NULL,
1754 `language` varchar(20) DEFAULT NULL,
1755 `date_format` tinyint(1) NOT NULL DEFAULT '0',
1756 `date_sep` tinyint(1) NOT NULL DEFAULT '0',
1757 `tho_sep` tinyint(1) NOT NULL DEFAULT '0',
1758 `dec_sep` tinyint(1) NOT NULL DEFAULT '0',
1759 `theme` varchar(20) NOT NULL DEFAULT 'default',
1760 `page_size` varchar(20) NOT NULL DEFAULT 'A4',
1761 `prices_dec` smallint(6) NOT NULL DEFAULT '2',
1762 `qty_dec` smallint(6) NOT NULL DEFAULT '2',
1763 `rates_dec` smallint(6) NOT NULL DEFAULT '4',
1764 `percent_dec` smallint(6) NOT NULL DEFAULT '1',
1765 `show_gl` tinyint(1) NOT NULL DEFAULT '1',
1766 `show_codes` tinyint(1) NOT NULL DEFAULT '0',
1767 `show_hints` tinyint(1) NOT NULL DEFAULT '0',
1768 `last_visit_date` datetime DEFAULT NULL,
1769 `query_size` tinyint(1) unsigned NOT NULL DEFAULT '10',
1770 `graphic_links` tinyint(1) DEFAULT '1',
1771 `pos` smallint(6) DEFAULT '1',
1772 `print_profile` varchar(30) NOT NULL DEFAULT '',
1773 `rep_popup` tinyint(1) DEFAULT '1',
1774 `sticky_doc_date` tinyint(1) DEFAULT '0',
1775 `startup_tab` varchar(20) NOT NULL DEFAULT '',
1776 `transaction_days` smallint(6) NOT NULL DEFAULT '30',
1777 `save_report_selections` smallint(6) NOT NULL DEFAULT '0',
1778 `use_date_picker` tinyint(1) NOT NULL DEFAULT '1',
1779 `def_print_destination` tinyint(1) NOT NULL DEFAULT '0',
1780 `def_print_orientation` tinyint(1) NOT NULL DEFAULT '0',
1781 `inactive` tinyint(1) NOT NULL DEFAULT '0',
1783 UNIQUE KEY `user_id` (`user_id`)
1784 ) ENGINE=InnoDB AUTO_INCREMENT=2 ;
1786 -- Data of table `0_users` --
1788 INSERT INTO `0_users` VALUES
1789 ('1', 'admin', '5f4dcc3b5aa765d61d8327deb882cf99', 'Administrator', '2', '', 'adm@example.com', 'C', '0', '0', '0', '0', 'default', 'Letter', '2', '2', '4', '1', '1', '0', '0', '2018-05-07 13:58:33', '10', '1', '1', '1', '1', '0', 'orders', '30', '0', '1', '0', '0', '0');
1791 -- Structure of table `0_voided` --
1793 DROP TABLE IF EXISTS `0_voided`;
1795 CREATE TABLE `0_voided` (
1796 `type` int(11) NOT NULL DEFAULT '0',
1797 `id` int(11) NOT NULL DEFAULT '0',
1798 `date_` date NOT NULL DEFAULT '0000-00-00',
1799 `memo_` tinytext NOT NULL,
1800 UNIQUE KEY `id` (`type`,`id`)
1803 -- Data of table `0_voided` --
1806 -- Structure of table `0_wo_costing` --
1808 DROP TABLE IF EXISTS `0_wo_costing`;
1810 CREATE TABLE `0_wo_costing` (
1811 `id` int(11) NOT NULL AUTO_INCREMENT,
1812 `workorder_id` int(11) NOT NULL DEFAULT '0',
1813 `cost_type` tinyint(1) NOT NULL DEFAULT '0',
1814 `trans_type` int(11) NOT NULL DEFAULT '0',
1815 `trans_no` int(11) NOT NULL DEFAULT '0',
1816 `factor` double NOT NULL DEFAULT '1',
1820 -- Data of table `0_wo_costing` --
1822 -- Structure of table `0_wo_issue_items` --
1824 DROP TABLE IF EXISTS `0_wo_issue_items`;
1826 CREATE TABLE `0_wo_issue_items` (
1827 `id` int(11) NOT NULL AUTO_INCREMENT,
1828 `stock_id` varchar(40) DEFAULT NULL,
1829 `issue_id` int(11) DEFAULT NULL,
1830 `qty_issued` double DEFAULT NULL,
1831 `unit_cost` double NOT NULL DEFAULT '0',
1835 -- Data of table `0_wo_issue_items` --
1838 -- Structure of table `0_wo_issues` --
1840 DROP TABLE IF EXISTS `0_wo_issues`;
1842 CREATE TABLE `0_wo_issues` (
1843 `issue_no` int(11) NOT NULL AUTO_INCREMENT,
1844 `workorder_id` int(11) NOT NULL DEFAULT '0',
1845 `reference` varchar(100) DEFAULT NULL,
1846 `issue_date` date DEFAULT NULL,
1847 `loc_code` varchar(5) DEFAULT NULL,
1848 `workcentre_id` int(11) DEFAULT NULL,
1849 PRIMARY KEY (`issue_no`),
1850 KEY `workorder_id` (`workorder_id`)
1853 -- Data of table `0_wo_issues` --
1855 -- Structure of table `0_wo_manufacture` --
1857 DROP TABLE IF EXISTS `0_wo_manufacture`;
1859 CREATE TABLE `0_wo_manufacture` (
1860 `id` int(11) NOT NULL AUTO_INCREMENT,
1861 `reference` varchar(100) DEFAULT NULL,
1862 `workorder_id` int(11) NOT NULL DEFAULT '0',
1863 `quantity` double NOT NULL DEFAULT '0',
1864 `date_` date NOT NULL DEFAULT '0000-00-00',
1866 KEY `workorder_id` (`workorder_id`)
1869 -- Data of table `0_wo_manufacture` --
1871 -- Structure of table `0_wo_requirements` --
1873 DROP TABLE IF EXISTS `0_wo_requirements`;
1875 CREATE TABLE `0_wo_requirements` (
1876 `id` int(11) NOT NULL AUTO_INCREMENT,
1877 `workorder_id` int(11) NOT NULL DEFAULT '0',
1878 `stock_id` char(20) NOT NULL DEFAULT '',
1879 `workcentre` int(11) NOT NULL DEFAULT '0',
1880 `units_req` double NOT NULL DEFAULT '1',
1881 `unit_cost` double NOT NULL DEFAULT '0',
1882 `loc_code` char(5) NOT NULL DEFAULT '',
1883 `units_issued` double NOT NULL DEFAULT '0',
1885 KEY `workorder_id` (`workorder_id`)
1888 -- Data of table `0_wo_requirements` --
1890 -- Structure of table `0_workcentres` --
1892 DROP TABLE IF EXISTS `0_workcentres`;
1894 CREATE TABLE `0_workcentres` (
1895 `id` int(11) NOT NULL AUTO_INCREMENT,
1896 `name` char(40) NOT NULL DEFAULT '',
1897 `description` char(50) NOT NULL DEFAULT '',
1898 `inactive` tinyint(1) NOT NULL DEFAULT '0',
1900 UNIQUE KEY `name` (`name`)
1901 ) ENGINE=InnoDB AUTO_INCREMENT=2 ;
1903 -- Data of table `0_workcentres` --
1905 INSERT INTO `0_workcentres` VALUES
1906 ('1', 'Work Centre', '', '0');
1908 -- Structure of table `0_workorders` --
1910 DROP TABLE IF EXISTS `0_workorders`;
1912 CREATE TABLE `0_workorders` (
1913 `id` int(11) NOT NULL AUTO_INCREMENT,
1914 `wo_ref` varchar(60) NOT NULL DEFAULT '',
1915 `loc_code` varchar(5) NOT NULL DEFAULT '',
1916 `units_reqd` double NOT NULL DEFAULT '1',
1917 `stock_id` varchar(20) NOT NULL DEFAULT '',
1918 `date_` date NOT NULL DEFAULT '0000-00-00',
1919 `type` tinyint(4) NOT NULL DEFAULT '0',
1920 `required_by` date NOT NULL DEFAULT '0000-00-00',
1921 `released_date` date NOT NULL DEFAULT '0000-00-00',
1922 `units_issued` double NOT NULL DEFAULT '0',
1923 `closed` tinyint(1) NOT NULL DEFAULT '0',
1924 `released` tinyint(1) NOT NULL DEFAULT '0',
1926 KEY `wo_ref` (`wo_ref`)
1929 -- Data of table `0_workorders` --