2 -- version 2.11.8.1deb5
3 -- http://www.phpmyadmin.net
6 -- Generation Time: Sep 26, 2014 at 11:32 AM
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=InnoDB DEFAULT CHARSET=utf8 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=InnoDB DEFAULT CHARSET=utf8 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 default 0,
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 DEFAULT CHARSET=utf8 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=InnoDB DEFAULT CHARSET=utf8 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 DEFAULT CHARSET=utf8 AUTO_INCREMENT=12 ;
150 -- Dumping data for table `0_bank_trans`
153 INSERT INTO `0_bank_trans` VALUES(1, 22, 4, '1', '1', '2014-06-21', -3465, 0, 0, 3, '2', NULL);
154 INSERT INTO `0_bank_trans` VALUES(2, 26, 1, '1', '', '2014-06-21', -10, 0, 0, 1, '1', NULL);
155 INSERT INTO `0_bank_trans` VALUES(3, 26, 1, '1', '', '2014-06-21', -20, 0, 0, 1, '0', NULL);
156 INSERT INTO `0_bank_trans` VALUES(4, 0, 18, '1', '1', '2014-02-20', 1000, 0, 0, 0, '', NULL);
157 INSERT INTO `0_bank_trans` VALUES(5, 0, 19, '1', '2', '2014-02-21', 4000, 0, 0, 0, '', NULL);
158 INSERT INTO `0_bank_trans` VALUES(6, 2, 5, '1', '1', '2014-06-21', 100, 0, 0, 4, '3', NULL);
159 INSERT INTO `0_bank_trans` VALUES(7, 1, 8, '1', '1', '2014-06-21', -50, 0, 0, 4, '1', NULL);
160 INSERT INTO `0_bank_trans` VALUES(8, 26, 5, '1', '', '2014-06-21', -10, 0, 0, 1, '1', NULL);
161 INSERT INTO `0_bank_trans` VALUES(9, 26, 5, '1', '', '2014-06-21', -20, 0, 0, 1, '0', NULL);
162 INSERT INTO `0_bank_trans` VALUES(10, 26, 7, '1', '', '2014-06-21', -10, 0, 0, 1, '1', NULL);
163 INSERT INTO `0_bank_trans` VALUES(11, 26, 7, '1', '', '2014-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=InnoDB DEFAULT CHARSET=utf8 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 DEFAULT CHARSET=utf8 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',
232 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
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`)
259 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
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`)
360 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ;
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`)
392 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
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=InnoDB DEFAULT CHARSET=utf8 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 DEFAULT CHARSET=utf8 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 DEFAULT CHARSET=utf8 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 DEFAULT CHARSET=utf8 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`)
545 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
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', 'kr', '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 `person_id` int(11) DEFAULT NULL,
567 `amt` double unsigned default NULL,
568 `date_alloc` date NOT NULL default '0000-00-00',
569 `trans_no_from` int(11) default NULL,
570 `trans_type_from` int(11) default NULL,
571 `trans_no_to` int(11) default NULL,
572 `trans_type_to` int(11) default NULL,
574 UNIQUE KEY `trans_type_from` (`person_id`,`trans_type_from`,`trans_no_from`,`trans_type_to`,`trans_no_to`),
575 KEY `From` (`trans_type_from`,`trans_no_from`),
576 KEY `To` (`trans_type_to`,`trans_no_to`)
577 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;
580 -- Dumping data for table `0_cust_allocations`
583 INSERT INTO `0_cust_allocations` VALUES(1, 3, 37.68, '2014-06-21', 3, 11, 18, 10);
585 -- --------------------------------------------------------
588 -- Table structure for table `0_cust_branch`
591 DROP TABLE IF EXISTS `0_cust_branch`;
592 CREATE TABLE IF NOT EXISTS `0_cust_branch` (
593 `branch_code` int(11) NOT NULL auto_increment,
594 `debtor_no` int(11) NOT NULL default '0',
595 `br_name` varchar(60) NOT NULL default '',
596 `branch_ref` varchar(30) NOT NULL default '',
597 `br_address` tinytext NOT NULL,
598 `area` int(11) default NULL,
599 `salesman` int(11) NOT NULL default '0',
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 `br_post_address` tinytext NOT NULL,
608 `group_no` int(11) NOT NULL default '0',
609 `notes` tinytext NOT NULL,
610 `bank_account` varchar(60) DEFAULT NULL,
611 `inactive` tinyint(1) NOT NULL default '0',
612 PRIMARY KEY (`branch_code`,`debtor_no`),
613 KEY `branch_code` (`branch_code`),
614 KEY `branch_ref` (`branch_ref`),
615 KEY `group_no` (`group_no`)
616 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=4 ;
619 -- Dumping data for table `0_cust_branch`
622 INSERT INTO `0_cust_branch` VALUES(1, 1, 'Beefeater Ltd.', 'Beefeater', '', 1, 1, 'DEF', 2, '', '4510', '1200', '4500', 1, 'Address 1\nAddress 2\nAddress 3', 0, '', '', 0);
623 INSERT INTO `0_cust_branch` VALUES(2, 2, 'Ghostbusters Corp.', 'Ghostbusters', 'Address 1\nAddress 2\nAddress 3', 1, 1, 'DEF', 1, '', '4510', '1200', '4500', 1, 'Address 1\nAddress 2\nAddress 3', 0, '','', 0);
624 INSERT INTO `0_cust_branch` VALUES(3, 3, 'Brezan', 'Brezan', 'Address 1\nAddress 2\nAddress 3', 1, 1, 'DEF', 1, '', '4510', '1200', '4500', 1, 'Address 1\nAddress 2\nAddress 3', 0, '', '', 0);
626 -- --------------------------------------------------------
629 -- Table structure for table `0_debtors_master`
632 DROP TABLE IF EXISTS `0_debtors_master`;
633 CREATE TABLE IF NOT EXISTS `0_debtors_master` (
634 `debtor_no` int(11) NOT NULL auto_increment,
635 `name` varchar(100) NOT NULL default '',
636 `debtor_ref` varchar(30) NOT NULL,
638 `tax_id` varchar(55) NOT NULL default '',
639 `curr_code` char(3) NOT NULL default '',
640 `sales_type` int(11) NOT NULL default '1',
641 `dimension_id` int(11) NOT NULL default '0',
642 `dimension2_id` int(11) NOT NULL default '0',
643 `credit_status` int(11) NOT NULL default '0',
644 `payment_terms` int(11) default NULL,
645 `discount` double NOT NULL default '0',
646 `pymt_discount` double NOT NULL default '0',
647 `credit_limit` float NOT NULL default '1000',
648 `notes` tinytext NOT NULL,
649 `inactive` tinyint(1) NOT NULL default '0',
650 PRIMARY KEY (`debtor_no`),
652 UNIQUE KEY `debtor_ref` (`debtor_ref`)
653 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=4 ;
656 -- Dumping data for table `0_debtors_master`
659 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);
660 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);
661 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);
663 -- --------------------------------------------------------
666 -- Table structure for table `0_debtor_trans`
669 DROP TABLE IF EXISTS `0_debtor_trans`;
670 CREATE TABLE IF NOT EXISTS `0_debtor_trans` (
671 `trans_no` int(11) unsigned NOT NULL default '0',
672 `type` smallint(6) unsigned NOT NULL default '0',
673 `version` tinyint(1) unsigned NOT NULL default '0',
674 `debtor_no` int(11) unsigned default NULL,
675 `branch_code` int(11) NOT NULL default '-1',
676 `tran_date` date NOT NULL default '0000-00-00',
677 `due_date` date NOT NULL default '0000-00-00',
678 `reference` varchar(60) NOT NULL default '',
679 `tpe` int(11) NOT NULL default '0',
680 `order_` int(11) NOT NULL default '0',
681 `ov_amount` double NOT NULL default '0',
682 `ov_gst` double NOT NULL default '0',
683 `ov_freight` double NOT NULL default '0',
684 `ov_freight_tax` double NOT NULL default '0',
685 `ov_discount` double NOT NULL default '0',
686 `alloc` double NOT NULL default '0',
687 `prep_amount` double NOT NULL DEFAULT '0',
688 `rate` double NOT NULL default '1',
689 `ship_via` int(11) default NULL,
690 `dimension_id` int(11) NOT NULL default '0',
691 `dimension2_id` int(11) NOT NULL default '0',
692 `payment_terms` int(11) default NULL,
693 `tax_included` tinyint(1) unsigned NOT NULL default '0',
694 PRIMARY KEY (`type`,`trans_no`),
695 KEY `debtor_no` (`debtor_no`,`branch_code`),
696 KEY `tran_date` (`tran_date`),
697 KEY `order_` (`order_`)
698 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
701 -- Dumping data for table `0_debtor_trans`
704 INSERT INTO `0_debtor_trans` VALUES(17, 10, 0, 2, 2, '2014-06-21', '2014-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, '2014-06-21', '2014-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, '2014-06-21', '2014-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, '2014-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, '2014-06-21', '2014-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, '2014-06-21', '2014-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, '2014-06-21', '2014-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, '2014-06-21', '2014-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 DEFAULT CHARSET=utf8 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 DEFAULT CHARSET=utf8 AUTO_INCREMENT=3 ;
774 -- Dumping data for table `0_dimensions`
777 INSERT INTO `0_dimensions` VALUES(1, '1', 'Support', 1, 0, '2014-06-21', '2020-07-11');
778 INSERT INTO `0_dimensions` VALUES(2, '2', 'Development', 1, 0, '2014-06-21', '2020-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=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=4 ;
798 -- Dumping data for table `0_exchange_rates`
801 INSERT INTO `0_exchange_rates` VALUES(1, 'DKK', 0.18717252868313, 0.18717252868313, '2014-06-21');
802 INSERT INTO `0_exchange_rates` VALUES(2, 'GBP', 1.6445729799917, 1.6445729799917, '2014-06-21');
803 INSERT INTO `0_exchange_rates` VALUES(3, 'EUR', 1.3932, 1.3932, '2014-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 DEFAULT CHARSET=utf8 AUTO_INCREMENT=3 ;
823 -- Dumping data for table `0_fiscal_year`
826 INSERT INTO `0_fiscal_year` VALUES(1, '2013-01-01', '2013-12-31', 0);
827 INSERT INTO `0_fiscal_year` VALUES(2, '2014-01-01', '2014-12-31', 0);
830 -- Table structure for table `0_gl_trans`
833 DROP TABLE IF EXISTS `0_gl_trans`;
834 CREATE TABLE IF NOT EXISTS `0_gl_trans` (
835 `counter` int(11) NOT NULL auto_increment,
836 `type` smallint(6) NOT NULL default '0',
837 `type_no` int(11) NOT NULL default '0',
838 `tran_date` date NOT NULL default '0000-00-00',
839 `account` varchar(15) NOT NULL default '',
840 `memo_` tinytext NOT NULL,
841 `amount` double NOT NULL default '0',
842 `dimension_id` int(11) NOT NULL default '0',
843 `dimension2_id` int(11) NOT NULL default '0',
844 `person_type_id` int(11) default NULL,
845 `person_id` tinyblob,
846 PRIMARY KEY (`counter`),
847 KEY `Type_and_Number` (`type`,`type_no`),
848 KEY `dimension_id` (`dimension_id`),
849 KEY `dimension2_id` (`dimension2_id`),
850 KEY `tran_date` (`tran_date`),
851 KEY `account_and_tran_date` (`account`,`tran_date`)
852 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=84 ;
855 -- Dumping data for table `0_gl_trans`
858 INSERT INTO `0_gl_trans` VALUES(1, 20, 7, '2014-06-21', '2100', '', -3465, 0, 0, 3, '2');
859 INSERT INTO `0_gl_trans` VALUES(2, 20, 7, '2014-06-21', '1510', '', 1000, 0, 0, 3, '2');
860 INSERT INTO `0_gl_trans` VALUES(3, 20, 7, '2014-06-21', '1510', '', 1100, 0, 0, 3, '2');
861 INSERT INTO `0_gl_trans` VALUES(4, 20, 7, '2014-06-21', '1510', '', 1200, 0, 0, 3, '2');
862 INSERT INTO `0_gl_trans` VALUES(5, 20, 7, '2014-06-21', '2150', '', 165, 0, 0, 3, '2');
863 INSERT INTO `0_gl_trans` VALUES(6, 22, 4, '2014-06-21', '2100', '', 3465, 0, 0, 3, '2');
864 INSERT INTO `0_gl_trans` VALUES(7, 22, 4, '2014-06-21', '1060', '', -3465, 0, 0, 3, '2');
865 INSERT INTO `0_gl_trans` VALUES(8, 26, 1, '2014-06-21', '1510', '', -100, 0, 0, NULL, '');
866 INSERT INTO `0_gl_trans` VALUES(9, 26, 1, '2014-06-21', '1510', '', -110, 0, 0, NULL, '');
867 INSERT INTO `0_gl_trans` VALUES(10, 26, 1, '2014-06-21', '1510', '', -120, 0, 0, NULL, '');
868 INSERT INTO `0_gl_trans` VALUES(11, 26, 1, '2014-06-21', '1060', 'Overhead Cost', -10, 0, 0, 1, '1');
869 INSERT INTO `0_gl_trans` VALUES(12, 26, 1, '2014-06-21', '1530', 'Overhead Cost', 10, 0, 0, 1, '1');
870 INSERT INTO `0_gl_trans` VALUES(13, 26, 1, '2014-06-21', '1060', 'Labour Cost', -20, 0, 0, 1, '0');
871 INSERT INTO `0_gl_trans` VALUES(14, 26, 1, '2014-06-21', '1530', 'Labour Cost', 20, 0, 0, 1, '0');
872 INSERT INTO `0_gl_trans` VALUES(15, 26, 1, '2014-06-21', '1510', '', 330, 0, 0, NULL, '');
873 INSERT INTO `0_gl_trans` VALUES(16, 13, 2, '2014-06-21', '5010', '', 20, 0, 0, 2, '1');
874 INSERT INTO `0_gl_trans` VALUES(17, 13, 2, '2014-06-21', '1510', '', -20, 0, 0, 2, '1');
875 INSERT INTO `0_gl_trans` VALUES(18, 13, 3, '2014-06-21', '5010', '', 10, 0, 0, 2, '2');
876 INSERT INTO `0_gl_trans` VALUES(19, 13, 3, '2014-06-21', '1510', '', -10, 0, 0, 2, '2');
877 INSERT INTO `0_gl_trans` VALUES(20, 10, 17, '2014-06-21', '4010', '', -50, 0, 0, 2, '2');
878 INSERT INTO `0_gl_trans` VALUES(21, 10, 17, '2014-06-21', '1200', '', 52.5, 0, 0, 2, '2');
879 INSERT INTO `0_gl_trans` VALUES(22, 10, 17, '2014-06-21', '2150', '', -2.5, 0, 0, 2, '2');
880 INSERT INTO `0_gl_trans` VALUES(23, 13, 4, '2014-06-21', '5010', '', 10, 2, 0, 2, '3');
881 INSERT INTO `0_gl_trans` VALUES(24, 13, 4, '2014-06-21', '1510', '', -10, 0, 0, 2, '3');
882 INSERT INTO `0_gl_trans` VALUES(25, 10, 18, '2014-06-21', '4010', '', -50, 2, 0, 2, '3');
883 INSERT INTO `0_gl_trans` VALUES(26, 10, 18, '2014-06-21', '1200', '', 52.5, 0, 0, 2, '3');
884 INSERT INTO `0_gl_trans` VALUES(27, 10, 18, '2014-06-21', '2150', '', -2.5, 0, 0, 2, '3');
885 INSERT INTO `0_gl_trans` VALUES(28, 0, 18, '2014-02-20', '1060', '', 1000, 0, 0, NULL, '');
886 INSERT INTO `0_gl_trans` VALUES(29, 0, 18, '2014-02-20', '3350', '', -1000, 0, 0, NULL, '');
887 INSERT INTO `0_gl_trans` VALUES(30, 0, 19, '2014-02-21', '1060', '', 4000, 0, 0, NULL, '');
888 INSERT INTO `0_gl_trans` VALUES(31, 0, 19, '2014-02-21', '3350', '', -4000, 0, 0, NULL, '');
889 INSERT INTO `0_gl_trans` VALUES(32, 26, 3, '2014-06-21', '1510', '', -20, 0, 0, NULL, '');
890 INSERT INTO `0_gl_trans` VALUES(33, 26, 3, '2014-06-21', '1510', '', -22, 0, 0, NULL, '');
891 INSERT INTO `0_gl_trans` VALUES(34, 26, 3, '2014-06-21', '1510', '', -24, 0, 0, NULL, '');
892 INSERT INTO `0_gl_trans` VALUES(35, 26, 3, '2014-06-21', '1540', '', 66, 0, 0, NULL, '');
893 INSERT INTO `0_gl_trans` VALUES(36, 2, 5, '2014-06-21', '2150', 'Cash Sales', -4.76, 0, 0, 4, '3');
894 INSERT INTO `0_gl_trans` VALUES(37, 2, 5, '2014-06-21', '4010', 'Cash Sales', -95.24, 0, 0, 4, '3');
895 INSERT INTO `0_gl_trans` VALUES(38, 2, 5, '2014-06-21', '1060', '', 100, 0, 0, 4, '3');
896 INSERT INTO `0_gl_trans` VALUES(39, 1, 8, '2014-06-21', '2150', 'Maintenance', 2.38, 0, 0, 4, '1');
897 INSERT INTO `0_gl_trans` VALUES(40, 1, 8, '2014-06-21', '5765', 'Maintenance', 47.62, 0, 0, 4, '1');
898 INSERT INTO `0_gl_trans` VALUES(41, 1, 8, '2014-06-21', '1060', '', -50, 0, 0, 4, '1');
899 INSERT INTO `0_gl_trans` VALUES(42, 20, 8, '2014-06-21', '2100', '', -20, 0, 0, 3, '2');
900 INSERT INTO `0_gl_trans` VALUES(43, 20, 8, '2014-06-21', '2150', '', 0.95, 0, 0, 3, '2');
901 INSERT INTO `0_gl_trans` VALUES(44, 20, 8, '2014-06-21', '5780', '', 19.05, 0, 0, 3, '2');
902 INSERT INTO `0_gl_trans` VALUES(45, 26, 4, '2014-06-21', '1510', '', -40, 0, 0, NULL, '');
903 INSERT INTO `0_gl_trans` VALUES(46, 26, 4, '2014-06-21', '1510', '', -44, 0, 0, NULL, '');
904 INSERT INTO `0_gl_trans` VALUES(47, 26, 4, '2014-06-21', '1510', '', -48, 0, 0, NULL, '');
905 INSERT INTO `0_gl_trans` VALUES(48, 26, 4, '2014-06-21', '1540', '', 132, 0, 0, NULL, '');
906 INSERT INTO `0_gl_trans` VALUES(49, 26, 2, '2014-06-21', '1510', '', -20, 0, 0, NULL, '');
907 INSERT INTO `0_gl_trans` VALUES(50, 26, 2, '2014-06-21', '1510', '', -22, 0, 0, NULL, '');
908 INSERT INTO `0_gl_trans` VALUES(51, 26, 2, '2014-06-21', '1510', '', -24, 0, 0, NULL, '');
909 INSERT INTO `0_gl_trans` VALUES(52, 26, 2, '2014-06-21', '1540', '', 66, 0, 0, NULL, '');
910 INSERT INTO `0_gl_trans` VALUES(53, 26, 5, '2014-06-21', '1510', '', -50, 0, 0, NULL, '');
911 INSERT INTO `0_gl_trans` VALUES(54, 26, 5, '2014-06-21', '1510', '', -55, 0, 0, NULL, '');
912 INSERT INTO `0_gl_trans` VALUES(55, 26, 5, '2014-06-21', '1510', '', -60, 0, 0, NULL, '');
913 INSERT INTO `0_gl_trans` VALUES(56, 26, 5, '2014-06-21', '1060', 'Overhead Cost', -10, 0, 0, 1, '1');
914 INSERT INTO `0_gl_trans` VALUES(57, 26, 5, '2014-06-21', '1530', 'Overhead Cost', 10, 0, 0, 1, '1');
915 INSERT INTO `0_gl_trans` VALUES(58, 26, 5, '2014-06-21', '1060', 'Labour Cost', -20, 0, 0, 1, '0');
916 INSERT INTO `0_gl_trans` VALUES(59, 26, 5, '2014-06-21', '1530', 'Labour Cost', 20, 0, 0, 1, '0');
917 INSERT INTO `0_gl_trans` VALUES(60, 26, 5, '2014-06-21', '1540', '', 165, 0, 0, NULL, '');
918 INSERT INTO `0_gl_trans` VALUES(61, 26, 6, '2014-06-21', '1510', '', 50, 0, 0, NULL, '');
919 INSERT INTO `0_gl_trans` VALUES(62, 26, 6, '2014-06-21', '1510', '', 55, 0, 0, NULL, '');
920 INSERT INTO `0_gl_trans` VALUES(63, 26, 6, '2014-06-21', '1510', '', 60, 0, 0, NULL, '');
921 INSERT INTO `0_gl_trans` VALUES(64, 26, 6, '2014-06-21', '1540', '', -165, 0, 0, NULL, '');
922 INSERT INTO `0_gl_trans` VALUES(65, 26, 7, '2014-06-21', '1510', '', 20, 0, 0, NULL, '');
923 INSERT INTO `0_gl_trans` VALUES(66, 26, 7, '2014-06-21', '1510', '', 22, 0, 0, NULL, '');
924 INSERT INTO `0_gl_trans` VALUES(67, 26, 7, '2014-06-21', '1510', '', 24, 0, 0, NULL, '');
925 INSERT INTO `0_gl_trans` VALUES(68, 26, 7, '2014-06-21', '1060', 'Overhead Cost', -10, 0, 0, 1, '1');
926 INSERT INTO `0_gl_trans` VALUES(69, 26, 7, '2014-06-21', '1530', 'Overhead Cost', 10, 0, 0, 1, '1');
927 INSERT INTO `0_gl_trans` VALUES(70, 26, 7, '2014-06-21', '1060', 'Labour Cost', -20, 0, 0, 1, '0');
928 INSERT INTO `0_gl_trans` VALUES(71, 26, 7, '2014-06-21', '1530', 'Labour Cost', 20, 0, 0, 1, '0');
929 INSERT INTO `0_gl_trans` VALUES(72, 26, 7, '2014-06-21', '1540', '', -66, 0, 0, NULL, '');
930 INSERT INTO `0_gl_trans` VALUES(73, 13, 5, '2014-06-21', '5010', '', 10, 0, 0, 2, '2');
931 INSERT INTO `0_gl_trans` VALUES(74, 13, 5, '2014-06-21', '1510', '', -10, 0, 0, 2, '2');
932 INSERT INTO `0_gl_trans` VALUES(75, 10, 19, '2014-06-21', '4010', '', -47.62, 0, 0, 2, '2');
933 INSERT INTO `0_gl_trans` VALUES(76, 10, 19, '2014-06-21', '1200', '', 55, 0, 0, 2, '2');
934 INSERT INTO `0_gl_trans` VALUES(77, 10, 19, '2014-06-21', '4430', '', -5, 0, 0, 2, '2');
935 INSERT INTO `0_gl_trans` VALUES(78, 10, 19, '2014-06-21', '2150', '', -2.38, 0, 0, 2, '2');
936 INSERT INTO `0_gl_trans` VALUES(79, 11, 3, '2014-06-21', '5010', '', -10, 2, 0, 2, '3');
937 INSERT INTO `0_gl_trans` VALUES(80, 11, 3, '2014-06-21', '1510', '', 10, 0, 0, 2, '3');
938 INSERT INTO `0_gl_trans` VALUES(81, 11, 3, '2014-06-21', '4010', '', 50, 2, 0, 2, '3');
939 INSERT INTO `0_gl_trans` VALUES(82, 11, 3, '2014-06-21', '1200', '', -52.5, 0, 0, 2, '3');
940 INSERT INTO `0_gl_trans` VALUES(83, 11, 3, '2014-06-21', '2150', '', 2.5, 0, 0, 2, '3');
942 -- --------------------------------------------------------
945 -- Table structure for table `0_grn_batch`
948 DROP TABLE IF EXISTS `0_grn_batch`;
949 CREATE TABLE IF NOT EXISTS `0_grn_batch` (
950 `id` int(11) NOT NULL auto_increment,
951 `supplier_id` int(11) NOT NULL default '0',
952 `purch_order_no` int(11) default NULL,
953 `reference` varchar(60) NOT NULL default '',
954 `delivery_date` date NOT NULL default '0000-00-00',
955 `loc_code` varchar(5) default NULL,
956 `rate` double NULL default '1',
958 KEY `delivery_date` (`delivery_date`),
959 KEY `purch_order_no` (`purch_order_no`)
960 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;
963 -- Dumping data for table `0_grn_batch`
966 INSERT INTO `0_grn_batch` VALUES(1, 2, 1, '1', '2014-06-21', 'DEF', '1');
968 -- --------------------------------------------------------
971 -- Table structure for table `0_grn_items`
974 DROP TABLE IF EXISTS `0_grn_items`;
975 CREATE TABLE IF NOT EXISTS `0_grn_items` (
976 `id` int(11) NOT NULL auto_increment,
977 `grn_batch_id` int(11) default NULL,
978 `po_detail_item` int(11) NOT NULL default '0',
979 `item_code` varchar(20) NOT NULL default '',
980 `description` tinytext,
981 `qty_recd` double NOT NULL default '0',
982 `quantity_inv` double NOT NULL default '0',
984 KEY `grn_batch_id` (`grn_batch_id`)
985 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=4 ;
988 -- Dumping data for table `0_grn_items`
991 INSERT INTO `0_grn_items` VALUES(1, 1, 1, '102', '17inch VGA Monitor', 100, 100);
992 INSERT INTO `0_grn_items` VALUES(2, 1, 2, '103', '32MB VGA Card', 100, 100);
993 INSERT INTO `0_grn_items` VALUES(3, 1, 3, '104', '52x CD Drive', 100, 100);
995 -- --------------------------------------------------------
998 -- Table structure for table `0_groups`
1001 DROP TABLE IF EXISTS `0_groups`;
1002 CREATE TABLE IF NOT EXISTS `0_groups` (
1003 `id` smallint(6) unsigned NOT NULL auto_increment,
1004 `description` varchar(60) NOT NULL default '',
1005 `inactive` tinyint(1) NOT NULL default '0',
1007 UNIQUE KEY `description` (`description`)
1008 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=4 ;
1011 -- Dumping data for table `0_groups`
1014 INSERT INTO `0_groups` VALUES(1, 'Small', 0);
1015 INSERT INTO `0_groups` VALUES(2, 'Medium', 0);
1016 INSERT INTO `0_groups` VALUES(3, 'Large', 0);
1018 -- --------------------------------------------------------
1021 -- Table structure for table `0_item_codes`
1024 DROP TABLE IF EXISTS `0_item_codes`;
1025 CREATE TABLE IF NOT EXISTS `0_item_codes` (
1026 `id` int(11) unsigned NOT NULL auto_increment,
1027 `item_code` varchar(20) NOT NULL,
1028 `stock_id` varchar(20) NOT NULL,
1029 `description` varchar(200) NOT NULL default '',
1030 `category_id` smallint(6) unsigned NOT NULL,
1031 `quantity` double NOT NULL default '1',
1032 `is_foreign` tinyint(1) NOT NULL default '0',
1033 `inactive` tinyint(1) NOT NULL default '0',
1035 UNIQUE KEY `stock_id` (`stock_id`,`item_code`),
1036 KEY `item_code` (`item_code`)
1037 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=6 ;
1040 -- Dumping data for table `0_item_codes`
1043 INSERT INTO `0_item_codes` VALUES(1, '102', '102', '17inch VGA Monitor', 1, 1, 0, 0);
1044 INSERT INTO `0_item_codes` VALUES(2, '103', '103', '32MB VGA Card', 1, 1, 0, 0);
1045 INSERT INTO `0_item_codes` VALUES(3, '104', '104', '52x CD Drive', 1, 1, 0, 0);
1046 INSERT INTO `0_item_codes` VALUES(4, '3400', '3400', 'P4 Business System', 3, 1, 0, 0);
1047 INSERT INTO `0_item_codes` VALUES(5, '201', '201', 'Assembly Labour', 4, 1, 0, 0);
1049 -- --------------------------------------------------------
1052 -- Table structure for table `0_item_tax_types`
1055 DROP TABLE IF EXISTS `0_item_tax_types`;
1056 CREATE TABLE IF NOT EXISTS `0_item_tax_types` (
1057 `id` int(11) NOT NULL auto_increment,
1058 `name` varchar(60) NOT NULL default '',
1059 `exempt` tinyint(1) NOT NULL default '0',
1060 `inactive` tinyint(1) NOT NULL default '0',
1062 UNIQUE KEY `name` (`name`)
1063 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;
1066 -- Dumping data for table `0_item_tax_types`
1069 INSERT INTO `0_item_tax_types` VALUES(1, 'Regular', 0, 0);
1071 -- --------------------------------------------------------
1074 -- Table structure for table `0_item_tax_type_exemptions`
1077 DROP TABLE IF EXISTS `0_item_tax_type_exemptions`;
1078 CREATE TABLE IF NOT EXISTS `0_item_tax_type_exemptions` (
1079 `item_tax_type_id` int(11) NOT NULL default '0',
1080 `tax_type_id` int(11) NOT NULL default '0',
1081 PRIMARY KEY (`item_tax_type_id`,`tax_type_id`)
1082 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1085 -- Dumping data for table `0_item_tax_type_exemptions`
1089 -- --------------------------------------------------------
1092 -- Table structure for table `0_item_units`
1095 DROP TABLE IF EXISTS `0_item_units`;
1096 CREATE TABLE IF NOT EXISTS `0_item_units` (
1097 `abbr` varchar(20) NOT NULL,
1098 `name` varchar(40) NOT NULL,
1099 `decimals` tinyint(2) NOT NULL,
1100 `inactive` tinyint(1) NOT NULL default '0',
1101 PRIMARY KEY (`abbr`),
1102 UNIQUE KEY `name` (`name`)
1103 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1106 -- Dumping data for table `0_item_units`
1109 INSERT INTO `0_item_units` VALUES('each', 'Each', 0, 0);
1110 INSERT INTO `0_item_units` VALUES('hr', 'Hours', 1, 0);
1112 --- Structure of table `0_journal`
1114 DROP TABLE IF EXISTS `0_journal`;
1115 CREATE TABLE `0_journal` (
1116 `type` smallint(6) NOT NULL DEFAULT '0',
1117 `trans_no` int(11) NOT NULL DEFAULT '0',
1118 `tran_date` date DEFAULT '0000-00-00',
1119 `reference` varchar(60) NOT NULL DEFAULT '',
1120 `source_ref` varchar(60) NOT NULL DEFAULT '',
1121 `event_date` date DEFAULT '0000-00-00',
1122 `doc_date` date NOT NULL DEFAULT '0000-00-00',
1123 `currency` char(3) NOT NULL DEFAULT '',
1124 `amount` double NOT NULL DEFAULT '0',
1125 `rate` double NOT NULL DEFAULT '1',
1126 PRIMARY KEY (`type`,`trans_no`),
1127 KEY `tran_date` (`tran_date`)
1128 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ;
1130 --- Data of table `0_journal`
1133 -- --------------------------------------------------------
1136 -- Table structure for table `0_locations`
1139 DROP TABLE IF EXISTS `0_locations`;
1140 CREATE TABLE IF NOT EXISTS `0_locations` (
1141 `loc_code` varchar(5) NOT NULL default '',
1142 `location_name` varchar(60) NOT NULL default '',
1143 `delivery_address` tinytext NOT NULL,
1144 `phone` varchar(30) NOT NULL default '',
1145 `phone2` varchar(30) NOT NULL default '',
1146 `fax` varchar(30) NOT NULL default '',
1147 `email` varchar(100) NOT NULL default '',
1148 `contact` varchar(30) NOT NULL default '',
1149 `inactive` tinyint(1) NOT NULL default '0',
1150 PRIMARY KEY (`loc_code`)
1151 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1154 -- Dumping data for table `0_locations`
1157 INSERT INTO `0_locations` VALUES('DEF', 'Default', 'Delivery 1\nDelivery 2\nDelivery 3', '', '', '', '', '', 0);
1159 -- --------------------------------------------------------
1162 -- Table structure for table `0_loc_stock`
1165 DROP TABLE IF EXISTS `0_loc_stock`;
1166 CREATE TABLE IF NOT EXISTS `0_loc_stock` (
1167 `loc_code` char(5) NOT NULL default '',
1168 `stock_id` char(20) NOT NULL default '',
1169 `reorder_level` double NOT NULL default '0',
1170 PRIMARY KEY (`loc_code`,`stock_id`),
1171 KEY `stock_id` (`stock_id`)
1172 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1175 -- Dumping data for table `0_loc_stock`
1178 INSERT INTO `0_loc_stock` VALUES('DEF', '102', 0);
1179 INSERT INTO `0_loc_stock` VALUES('DEF', '103', 0);
1180 INSERT INTO `0_loc_stock` VALUES('DEF', '104', 0);
1181 INSERT INTO `0_loc_stock` VALUES('DEF', '201', 0);
1182 INSERT INTO `0_loc_stock` VALUES('DEF', '3400', 0);
1184 -- --------------------------------------------------------
1187 -- Table structure for table `0_movement_types`
1190 DROP TABLE IF EXISTS `0_movement_types`;
1191 CREATE TABLE IF NOT EXISTS `0_movement_types` (
1192 `id` int(11) NOT NULL auto_increment,
1193 `name` varchar(60) NOT NULL default '',
1194 `inactive` tinyint(1) NOT NULL default '0',
1196 UNIQUE KEY `name` (`name`)
1197 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;
1200 -- Dumping data for table `0_movement_types`
1203 INSERT INTO `0_movement_types` VALUES(1, 'Adjustment', 0);
1205 -- --------------------------------------------------------
1208 -- Table structure for table `0_payment_terms`
1211 DROP TABLE IF EXISTS `0_payment_terms`;
1212 CREATE TABLE IF NOT EXISTS `0_payment_terms` (
1213 `terms_indicator` int(11) NOT NULL auto_increment,
1214 `terms` char(80) NOT NULL default '',
1215 `days_before_due` smallint(6) NOT NULL default '0',
1216 `day_in_following_month` smallint(6) NOT NULL default '0',
1217 `inactive` tinyint(1) NOT NULL default '0',
1218 PRIMARY KEY (`terms_indicator`),
1219 UNIQUE KEY `terms` (`terms`)
1220 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=5 ;
1223 -- Dumping data for table `0_payment_terms`
1226 INSERT INTO `0_payment_terms` VALUES(1, 'Due 15th Of the Following Month', 0, 17, 0);
1227 INSERT INTO `0_payment_terms` VALUES(2, 'Due By End Of The Following Month', 0, 30, 0);
1228 INSERT INTO `0_payment_terms` VALUES(3, 'Payment due within 10 days', 10, 0, 0);
1229 INSERT INTO `0_payment_terms` VALUES(4, 'Cash Only', 0, 0, 0);
1231 -- --------------------------------------------------------
1234 -- Table structure for table `0_prices`
1237 DROP TABLE IF EXISTS `0_prices`;
1238 CREATE TABLE IF NOT EXISTS `0_prices` (
1239 `id` int(11) NOT NULL auto_increment,
1240 `stock_id` varchar(20) NOT NULL default '',
1241 `sales_type_id` int(11) NOT NULL default '0',
1242 `curr_abrev` char(3) NOT NULL default '',
1243 `price` double NOT NULL default '0',
1245 UNIQUE KEY `price` (`stock_id`,`sales_type_id`,`curr_abrev`)
1246 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=5 ;
1249 -- Dumping data for table `0_prices`
1252 INSERT INTO `0_prices` VALUES(1, '3400', 1, 'USD', 100);
1253 INSERT INTO `0_prices` VALUES(2, '102', 1, 'USD', 50);
1254 INSERT INTO `0_prices` VALUES(3, '103', 1, 'USD', 55);
1255 INSERT INTO `0_prices` VALUES(4, '104', 1, 'USD', 60);
1257 -- --------------------------------------------------------
1260 -- Table structure for table `0_printers`
1263 DROP TABLE IF EXISTS `0_printers`;
1264 CREATE TABLE IF NOT EXISTS `0_printers` (
1265 `id` tinyint(3) unsigned NOT NULL auto_increment,
1266 `name` varchar(20) NOT NULL,
1267 `description` varchar(60) NOT NULL,
1268 `queue` varchar(20) NOT NULL,
1269 `host` varchar(40) NOT NULL,
1270 `port` smallint(11) unsigned NOT NULL,
1271 `timeout` tinyint(3) unsigned NOT NULL,
1273 UNIQUE KEY `name` (`name`)
1274 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=4 ;
1277 -- Dumping data for table `0_printers`
1280 INSERT INTO `0_printers` VALUES(1, 'QL500', 'Label printer', 'QL500', 'server', 127, 20);
1281 INSERT INTO `0_printers` VALUES(2, 'Samsung', 'Main network printer', 'scx4521F', 'server', 515, 5);
1282 INSERT INTO `0_printers` VALUES(3, 'Local', 'Local print server at user IP', 'lp', '', 515, 10);
1284 -- --------------------------------------------------------
1287 -- Table structure for table `0_print_profiles`
1290 DROP TABLE IF EXISTS `0_print_profiles`;
1291 CREATE TABLE IF NOT EXISTS `0_print_profiles` (
1292 `id` smallint(6) unsigned NOT NULL auto_increment,
1293 `profile` varchar(30) NOT NULL,
1294 `report` varchar(5) default NULL,
1295 `printer` tinyint(3) unsigned default NULL,
1297 UNIQUE KEY `profile` (`profile`,`report`)
1298 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=10 ;
1301 -- Dumping data for table `0_print_profiles`
1304 INSERT INTO `0_print_profiles` VALUES(1, 'Out of office', '', 0);
1305 INSERT INTO `0_print_profiles` VALUES(2, 'Sales Department', '', 0);
1306 INSERT INTO `0_print_profiles` VALUES(3, 'Central', '', 2);
1307 INSERT INTO `0_print_profiles` VALUES(4, 'Sales Department', '104', 2);
1308 INSERT INTO `0_print_profiles` VALUES(5, 'Sales Department', '105', 2);
1309 INSERT INTO `0_print_profiles` VALUES(6, 'Sales Department', '107', 2);
1310 INSERT INTO `0_print_profiles` VALUES(7, 'Sales Department', '109', 2);
1311 INSERT INTO `0_print_profiles` VALUES(8, 'Sales Department', '110', 2);
1312 INSERT INTO `0_print_profiles` VALUES(9, 'Sales Department', '201', 2);
1314 -- --------------------------------------------------------
1317 -- Table structure for table `0_purch_data`
1320 DROP TABLE IF EXISTS `0_purch_data`;
1321 CREATE TABLE IF NOT EXISTS `0_purch_data` (
1322 `supplier_id` int(11) NOT NULL default '0',
1323 `stock_id` char(20) NOT NULL default '',
1324 `price` double NOT NULL default '0',
1325 `suppliers_uom` char(50) NOT NULL default '',
1326 `conversion_factor` double NOT NULL default '1',
1327 `supplier_description` char(50) NOT NULL default '',
1328 PRIMARY KEY (`supplier_id`,`stock_id`)
1329 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1332 -- Dumping data for table `0_purch_data`
1335 INSERT INTO `0_purch_data` VALUES(2, '102', 10, '', 1, '17inch VGA Monitor');
1336 INSERT INTO `0_purch_data` VALUES(2, '103', 11, '', 1, '32MB VGA Card');
1337 INSERT INTO `0_purch_data` VALUES(2, '104', 12, '', 1, '52x CD Drive');
1339 -- --------------------------------------------------------
1342 -- Table structure for table `0_purch_orders`
1345 DROP TABLE IF EXISTS `0_purch_orders`;
1346 CREATE TABLE IF NOT EXISTS `0_purch_orders` (
1347 `order_no` int(11) NOT NULL auto_increment,
1348 `supplier_id` int(11) NOT NULL default '0',
1349 `comments` tinytext,
1350 `ord_date` date NOT NULL default '0000-00-00',
1351 `reference` tinytext NOT NULL,
1352 `requisition_no` tinytext,
1353 `into_stock_location` varchar(5) NOT NULL default '',
1354 `delivery_address` tinytext NOT NULL,
1355 `total` double NOT NULL default '0',
1356 `prep_amount` double NOT NULL DEFAULT '0',
1357 `alloc` double NOT NULL DEFAULT '0',
1358 `tax_included` tinyint(1) NOT NULL default '0',
1359 PRIMARY KEY (`order_no`),
1360 KEY `ord_date` (`ord_date`)
1361 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=3 ;
1364 -- Dumping data for table `0_purch_orders`
1367 INSERT INTO `0_purch_orders` VALUES(1, 2, '', '2014-06-01', '1', '', 'DEF', 'Delivery 1\nDelivery 2\nDelivery 3', 0, 0, 0, 0);
1368 INSERT INTO `0_purch_orders` VALUES(2, 3, '', '2014-06-21', '2', '', 'DEF', 'Delivery 1\nDelivery 2\nDelivery 3', 0, 0, 0, 0);
1370 -- --------------------------------------------------------
1373 -- Table structure for table `0_purch_order_details`
1376 DROP TABLE IF EXISTS `0_purch_order_details`;
1377 CREATE TABLE IF NOT EXISTS `0_purch_order_details` (
1378 `po_detail_item` int(11) NOT NULL auto_increment,
1379 `order_no` int(11) NOT NULL default '0',
1380 `item_code` varchar(20) NOT NULL default '',
1381 `description` tinytext,
1382 `delivery_date` date NOT NULL default '0000-00-00',
1383 `qty_invoiced` double NOT NULL default '0',
1384 `unit_price` double NOT NULL default '0',
1385 `act_price` double NOT NULL default '0',
1386 `std_cost_unit` double NOT NULL default '0',
1387 `quantity_ordered` double NOT NULL default '0',
1388 `quantity_received` double NOT NULL default '0',
1389 PRIMARY KEY (`po_detail_item`),
1390 KEY `order` (`order_no`,`po_detail_item`),
1391 KEY `itemcode` (`item_code`)
1392 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=6 ;
1395 -- Dumping data for table `0_purch_order_details`
1398 INSERT INTO `0_purch_order_details` VALUES(1, 1, '102', '17inch VGA Monitor', '2014-07-01', 100, 10, 10, 10, 100, 100);
1399 INSERT INTO `0_purch_order_details` VALUES(2, 1, '103', '32MB VGA Card', '2014-07-01', 100, 11, 11, 11, 100, 100);
1400 INSERT INTO `0_purch_order_details` VALUES(3, 1, '104', '52x CD Drive', '2014-07-01', 100, 12, 12, 12, 100, 100);
1401 INSERT INTO `0_purch_order_details` VALUES(4, 2, '102', '17inch VGA Monitor', '2014-07-01', 0, 5, 0, 0, 1, 0);
1402 INSERT INTO `0_purch_order_details` VALUES(5, 2, '103', '32MB VGA Card', '2014-07-01', 0, 5, 0, 0, 1, 0);
1404 -- --------------------------------------------------------
1407 -- Table structure for table `0_quick_entries`
1410 DROP TABLE IF EXISTS `0_quick_entries`;
1411 CREATE TABLE IF NOT EXISTS `0_quick_entries` (
1412 `id` smallint(6) unsigned NOT NULL auto_increment,
1413 `type` tinyint(1) NOT NULL default '0',
1414 `description` varchar(60) NOT NULL,
1415 `usage` varchar(120) NULL,
1416 `base_amount` double NOT NULL default '0',
1417 `base_desc` varchar(60) default NULL,
1418 `bal_type` tinyint(1) NOT NULL default '0',
1420 KEY `description` (`description`)
1421 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=4 ;
1424 -- Dumping data for table `0_quick_entries`
1427 INSERT INTO `0_quick_entries` VALUES(1, 1, 'Maintenance', NULL, 0, 'Amount', 0);
1428 INSERT INTO `0_quick_entries` VALUES(2, 4, 'Phone', NULL, 0, 'Amount', 0);
1429 INSERT INTO `0_quick_entries` VALUES(3, 2, 'Cash Sales', 'Retail sales without invoice', 0, 'Amount', 0);
1431 -- --------------------------------------------------------
1434 -- Table structure for table `0_quick_entry_lines`
1437 DROP TABLE IF EXISTS `0_quick_entry_lines`;
1438 CREATE TABLE IF NOT EXISTS `0_quick_entry_lines` (
1439 `id` smallint(6) unsigned NOT NULL auto_increment,
1440 `qid` smallint(6) unsigned NOT NULL,
1441 `amount` double default '0',
1442 `memo` tinytext NOT NULL,
1443 `action` varchar(2) NOT NULL,
1444 `dest_id` varchar(15) NOT NULL default '',
1445 `dimension_id` smallint(6) unsigned default NULL,
1446 `dimension2_id` smallint(6) unsigned default NULL,
1449 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=8 ;
1452 -- Dumping data for table `0_quick_entry_lines`
1455 INSERT INTO `0_quick_entry_lines` VALUES(1, 1, 0, '', 't-', '1', 0, 0);
1456 INSERT INTO `0_quick_entry_lines` VALUES(2, 2, 0, '', 't-', '1', 0, 0);
1457 INSERT INTO `0_quick_entry_lines` VALUES(3, 3, 0, '', 't-', '1', 0, 0);
1458 INSERT INTO `0_quick_entry_lines` VALUES(4, 3, 0, '', '=', '4010', 0, 0);
1459 INSERT INTO `0_quick_entry_lines` VALUES(5, 1, 0, '', '=', '5765', 0, 0);
1460 INSERT INTO `0_quick_entry_lines` VALUES(6, 2, 0, '', '=', '5780', 0, 0);
1462 -- --------------------------------------------------------
1465 -- Table structure for table `0_recurrent_invoices`
1468 DROP TABLE IF EXISTS `0_recurrent_invoices`;
1469 CREATE TABLE IF NOT EXISTS `0_recurrent_invoices` (
1470 `id` smallint(6) unsigned NOT NULL auto_increment,
1471 `description` varchar(60) NOT NULL default '',
1472 `order_no` int(11) unsigned NOT NULL,
1473 `debtor_no` int(11) unsigned default NULL,
1474 `group_no` smallint(6) unsigned default NULL,
1475 `days` int(11) NOT NULL default '0',
1476 `monthly` int(11) NOT NULL default '0',
1477 `begin` date NOT NULL default '0000-00-00',
1478 `end` date NOT NULL default '0000-00-00',
1479 `last_sent` date NOT NULL default '0000-00-00',
1481 UNIQUE KEY `description` (`description`)
1482 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
1485 -- Dumping data for table `0_recurrent_invoices`
1489 -- --------------------------------------------------------
1492 -- Table structure for table `0_refs`
1495 DROP TABLE IF EXISTS `0_refs`;
1496 CREATE TABLE IF NOT EXISTS `0_refs` (
1497 `id` int(11) NOT NULL default '0',
1498 `type` int(11) NOT NULL default '0',
1499 `reference` varchar(100) NOT NULL default '',
1500 PRIMARY KEY (`id`,`type`),
1501 KEY `Type_and_Reference` (`type`,`reference`)
1502 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1505 -- Dumping data for table `0_refs`
1508 INSERT INTO `0_refs` VALUES(18, 0, '1');
1509 INSERT INTO `0_refs` VALUES(19, 0, '2');
1511 -- --------------------------------------------------------
1514 -- Table structure for table `0_salesman`
1517 DROP TABLE IF EXISTS `0_salesman`;
1518 CREATE TABLE IF NOT EXISTS `0_salesman` (
1519 `salesman_code` int(11) NOT NULL auto_increment,
1520 `salesman_name` char(60) NOT NULL default '',
1521 `salesman_phone` char(30) NOT NULL default '',
1522 `salesman_fax` char(30) NOT NULL default '',
1523 `salesman_email` varchar(100) NOT NULL default '',
1524 `provision` double NOT NULL default '0',
1525 `break_pt` double NOT NULL default '0',
1526 `provision2` double NOT NULL default '0',
1527 `inactive` tinyint(1) NOT NULL default '0',
1528 PRIMARY KEY (`salesman_code`),
1529 UNIQUE KEY `salesman_name` (`salesman_name`)
1530 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;
1533 -- Dumping data for table `0_salesman`
1536 INSERT INTO `0_salesman` VALUES(1, 'Sales Person', '', '', '', 5, 1000, 4, 0);
1538 -- --------------------------------------------------------
1541 -- Table structure for table `0_sales_orders`
1544 DROP TABLE IF EXISTS `0_sales_orders`;
1545 CREATE TABLE IF NOT EXISTS `0_sales_orders` (
1546 `order_no` int(11) NOT NULL,
1547 `trans_type` smallint(6) NOT NULL default '30',
1548 `version` tinyint(1) unsigned NOT NULL default '0',
1549 `type` tinyint(1) NOT NULL default '0',
1550 `debtor_no` int(11) NOT NULL default '0',
1551 `branch_code` int(11) NOT NULL default '0',
1552 `reference` varchar(100) NOT NULL default '',
1553 `customer_ref` tinytext NOT NULL,
1554 `comments` tinytext,
1555 `ord_date` date NOT NULL default '0000-00-00',
1556 `order_type` int(11) NOT NULL default '0',
1557 `ship_via` int(11) NOT NULL default '0',
1558 `delivery_address` tinytext NOT NULL,
1559 `contact_phone` varchar(30) default NULL,
1560 `contact_email` varchar(100) default NULL,
1561 `deliver_to` tinytext NOT NULL,
1562 `freight_cost` double NOT NULL default '0',
1563 `from_stk_loc` varchar(5) NOT NULL default '',
1564 `delivery_date` date NOT NULL default '0000-00-00',
1565 `payment_terms` int(11) default NULL,
1566 `total` double NOT NULL default '0',
1567 `prep_amount` double NOT NULL DEFAULT '0',
1568 `alloc` double NOT NULL DEFAULT '0',
1569 PRIMARY KEY (`trans_type`,`order_no`)
1570 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1573 -- Dumping data for table `0_sales_orders`
1576 INSERT INTO `0_sales_orders` VALUES(1, 30, 1, 0, 1, 1, '1', '', '', '2014-06-21', 2, 1, 'Address 1\nAddress 2\nAddress 3', '', '', 'Beefeater Ltd.', 10, 'DEF', '2014-06-22', 3, 0, 0, 0);
1577 INSERT INTO `0_sales_orders` VALUES(2, 30, 1, 0, 2, 2, '2', '', '', '2014-06-21', 1, 1, 'Address 1\nAddress 2\nAddress 3', '', '', 'Ghostbusters Corp.', 0, 'DEF', '2014-06-22', 4, 0, 0, 0);
1578 INSERT INTO `0_sales_orders` VALUES(3, 30, 1, 0, 3, 3, '3', '', '', '2014-06-21', 2, 1, 'Address 1\nAddress 2\nAddress 3', '', '', 'Brezan', 0, 'DEF', '2014-07-01', 3, 0, 0, 0);
1579 INSERT INTO `0_sales_orders` VALUES(4, 30, 0, 0, 1, 1, '4', '', '', '2014-06-21', 2, 1, 'Address 1\nAddress 2\nAddress 3', '', '', 'Beefeater Ltd.', 0, 'DEF', '2014-06-22', 3, 0, 0, 0);
1580 INSERT INTO `0_sales_orders` VALUES(5, 30, 1, 0, 2, 2, '5', '', '', '2014-06-21', 1, 1, 'Address 1\nAddress 2\nAddress 3', '', '', 'Ghostbusters Corp.', 5, 'DEF', '2014-06-22', 4, 0, 0, 0);
1582 -- --------------------------------------------------------
1585 -- Table structure for table `0_sales_order_details`
1588 DROP TABLE IF EXISTS `0_sales_order_details`;
1589 CREATE TABLE IF NOT EXISTS `0_sales_order_details` (
1590 `id` int(11) NOT NULL auto_increment,
1591 `order_no` int(11) NOT NULL default '0',
1592 `trans_type` smallint(6) NOT NULL default '30',
1593 `stk_code` varchar(20) NOT NULL default '',
1594 `description` tinytext,
1595 `qty_sent` double NOT NULL default '0',
1596 `unit_price` double NOT NULL default '0',
1597 `quantity` double NOT NULL default '0',
1598 `invoiced` double NOT NULL DEFAULT '0',
1599 `discount_percent` double NOT NULL default '0',
1601 KEY `sorder` (`trans_type`,`order_no`),
1602 KEY `stkcode` (`stk_code`)
1603 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=6 ;
1606 -- Dumping data for table `0_sales_order_details`
1609 INSERT INTO `0_sales_order_details` VALUES(1, 1, 30, '102', '17inch VGA Monitor', 2, 30.4, 2, 0, 0);
1610 INSERT INTO `0_sales_order_details` VALUES(2, 2, 30, '102', '17inch VGA Monitor', 1, 50, 1, 0, 0);
1611 INSERT INTO `0_sales_order_details` VALUES(3, 3, 30, '102', '17inch VGA Monitor', 1, 35.89, 1, 0, 0);
1612 INSERT INTO `0_sales_order_details` VALUES(4, 4, 30, '102', '17inch VGA Monitor', 0, 21.28, 2, 0, 0);
1613 INSERT INTO `0_sales_order_details` VALUES(5, 5, 30, '102', '17inch VGA Monitor', 1, 50, 1, 0, 0);
1615 -- --------------------------------------------------------
1618 -- Table structure for table `0_sales_pos`
1621 DROP TABLE IF EXISTS `0_sales_pos`;
1622 CREATE TABLE IF NOT EXISTS `0_sales_pos` (
1623 `id` smallint(6) unsigned NOT NULL auto_increment,
1624 `pos_name` varchar(30) NOT NULL,
1625 `cash_sale` tinyint(1) NOT NULL,
1626 `credit_sale` tinyint(1) NOT NULL,
1627 `pos_location` varchar(5) NOT NULL,
1628 `pos_account` smallint(6) unsigned NOT NULL,
1629 `inactive` tinyint(1) NOT NULL default '0',
1631 UNIQUE KEY `pos_name` (`pos_name`)
1632 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;
1635 -- Dumping data for table `0_sales_pos`
1638 INSERT INTO `0_sales_pos` VALUES(1, 'Default', 1, 1, 'DEF', 2, 0);
1640 -- --------------------------------------------------------
1643 -- Table structure for table `0_sales_types`
1646 DROP TABLE IF EXISTS `0_sales_types`;
1647 CREATE TABLE IF NOT EXISTS `0_sales_types` (
1648 `id` int(11) NOT NULL auto_increment,
1649 `sales_type` char(50) NOT NULL default '',
1650 `tax_included` int(1) NOT NULL default '0',
1651 `factor` double NOT NULL default '1',
1652 `inactive` tinyint(1) NOT NULL default '0',
1654 UNIQUE KEY `sales_type` (`sales_type`)
1655 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=3 ;
1658 -- Dumping data for table `0_sales_types`
1661 INSERT INTO `0_sales_types` VALUES(1, 'Retail', 1, 1, 0);
1662 INSERT INTO `0_sales_types` VALUES(2, 'Wholesale', 0, 0.7, 0);
1664 -- --------------------------------------------------------
1667 -- Table structure for table `0_security_roles`
1670 DROP TABLE IF EXISTS `0_security_roles`;
1671 CREATE TABLE IF NOT EXISTS `0_security_roles` (
1672 `id` int(11) NOT NULL auto_increment,
1673 `role` varchar(30) NOT NULL,
1674 `description` varchar(50) default NULL,
1677 `inactive` tinyint(1) NOT NULL default '0',
1679 UNIQUE KEY `role` (`role`)
1680 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=11 ;
1683 -- Dumping data for table `0_security_roles`
1686 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);
1687 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);
1688 INSERT INTO `0_security_roles` VALUES(3, 'Salesman', 'Salesman', '768;3072;5632;8192;15872', '773;774;3073;3075;3081;5633;8194;15873;775', 0);
1689 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);
1690 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);
1691 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);
1692 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);
1693 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);
1694 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);
1695 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);
1697 -- --------------------------------------------------------
1700 -- Table structure for table `0_shippers`
1703 DROP TABLE IF EXISTS `0_shippers`;
1704 CREATE TABLE IF NOT EXISTS `0_shippers` (
1705 `shipper_id` int(11) NOT NULL auto_increment,
1706 `shipper_name` varchar(60) NOT NULL default '',
1707 `phone` varchar(30) NOT NULL default '',
1708 `phone2` varchar(30) NOT NULL default '',
1709 `contact` tinytext NOT NULL,
1710 `address` tinytext NOT NULL,
1711 `inactive` tinyint(1) NOT NULL default '0',
1712 PRIMARY KEY (`shipper_id`),
1713 UNIQUE KEY `name` (`shipper_name`)
1714 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;
1717 -- Dumping data for table `0_shippers`
1720 INSERT INTO `0_shippers` VALUES(1, 'Default', '', '', '', '', 0);
1722 -- --------------------------------------------------------
1725 -- Table structure for table `0_sql_trail`
1728 DROP TABLE IF EXISTS `0_sql_trail`;
1729 CREATE TABLE IF NOT EXISTS `0_sql_trail` (
1730 `id` int(11) unsigned NOT NULL auto_increment,
1731 `sql` text NOT NULL,
1732 `result` tinyint(1) NOT NULL,
1733 `msg` varchar(255) NOT NULL,
1735 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
1738 -- Dumping data for table `0_sql_trail`
1742 -- --------------------------------------------------------
1745 -- Table structure for table `0_stock_category`
1748 DROP TABLE IF EXISTS `0_stock_category`;
1749 CREATE TABLE IF NOT EXISTS `0_stock_category` (
1750 `category_id` int(11) NOT NULL auto_increment,
1751 `description` varchar(60) NOT NULL default '',
1752 `dflt_tax_type` int(11) NOT NULL default '1',
1753 `dflt_units` varchar(20) NOT NULL default 'each',
1754 `dflt_mb_flag` char(1) NOT NULL default 'B',
1755 `dflt_sales_act` varchar(15) NOT NULL default '',
1756 `dflt_cogs_act` varchar(15) NOT NULL default '',
1757 `dflt_inventory_act` varchar(15) NOT NULL default '',
1758 `dflt_adjustment_act` varchar(15) NOT NULL default '',
1759 `dflt_assembly_act` varchar(15) NOT NULL default '',
1760 `dflt_dim1` int(11) default NULL,
1761 `dflt_dim2` int(11) default NULL,
1762 `inactive` tinyint(1) NOT NULL default '0',
1763 `dflt_no_sale` tinyint(1) NOT NULL default '0',
1764 `dflt_no_purchase` tinyint(1) NOT NULL default '0',
1765 PRIMARY KEY (`category_id`),
1766 UNIQUE KEY `description` (`description`)
1767 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=5 ;
1770 -- Dumping data for table `0_stock_category`
1773 INSERT INTO `0_stock_category` VALUES(1, 'Components', 1, 'each', 'B', '4010', '5010', '1510', '5040', '1530', 0, 0, 0, 0, 0);
1774 INSERT INTO `0_stock_category` VALUES(2, 'Charges', 1, 'each', 'D', '4010', '5010', '1510', '5040', '1530', 0, 0, 0, 0, 0);
1775 INSERT INTO `0_stock_category` VALUES(3, 'Systems', 1, 'each', 'M', '4010', '5010', '1510', '5040', '1530', 0, 0, 0, 0, 0);
1776 INSERT INTO `0_stock_category` VALUES(4, 'Services', 1, 'hr', 'D', '4010', '5010', '1510', '5040', '1530', 0, 0, 0, 0, 0);
1778 -- --------------------------------------------------------
1781 -- Table structure for table `0_stock_master`
1784 DROP TABLE IF EXISTS `0_stock_master`;
1785 CREATE TABLE IF NOT EXISTS `0_stock_master` (
1786 `stock_id` varchar(20) NOT NULL default '',
1787 `category_id` int(11) NOT NULL default '0',
1788 `tax_type_id` int(11) NOT NULL default '0',
1789 `description` varchar(200) NOT NULL default '',
1790 `long_description` tinytext NOT NULL,
1791 `units` varchar(20) NOT NULL default 'each',
1792 `mb_flag` char(1) NOT NULL default 'B',
1793 `sales_account` varchar(15) NOT NULL default '',
1794 `cogs_account` varchar(15) NOT NULL default '',
1795 `inventory_account` varchar(15) NOT NULL default '',
1796 `adjustment_account` varchar(15) NOT NULL default '',
1797 `assembly_account` varchar(15) NOT NULL default '',
1798 `dimension_id` int(11) default NULL,
1799 `dimension2_id` int(11) default NULL,
1800 `actual_cost` double NOT NULL default '0',
1801 `last_cost` double NOT NULL default '0',
1802 `material_cost` double NOT NULL default '0',
1803 `labour_cost` double NOT NULL default '0',
1804 `overhead_cost` double NOT NULL default '0',
1805 `inactive` tinyint(1) NOT NULL default '0',
1806 `no_sale` tinyint(1) NOT NULL default '0',
1807 `no_purchase` tinyint(1) NOT NULL default '0',
1808 `editable` tinyint(1) NOT NULL default '0',
1809 PRIMARY KEY (`stock_id`)
1810 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1813 -- Dumping data for table `0_stock_master`
1816 INSERT INTO `0_stock_master` VALUES('102', 1, 1, '17inch VGA Monitor', '', 'each', 'B', '4010', '5010', '1510', '5040', '1530', 0, 0, 0, 0, 10, 0, 0, 0, 0, 0, 0);
1817 INSERT INTO `0_stock_master` VALUES('103', 1, 1, '32MB VGA Card', '', 'each', 'B', '4010', '5010', '1510', '5040', '1530', 0, 0, 0, 0, 11, 0, 0, 0, 0, 0, 0);
1818 INSERT INTO `0_stock_master` VALUES('104', 1, 1, '52x CD Drive', '', 'each', 'B', '4010', '5010', '1510', '5040', '1530', 0, 0, 0, 0, 12, 0, 0, 0, 0, 0, 0);
1819 INSERT INTO `0_stock_master` VALUES('201', 4, 1, 'Assembly Labour', '', 'hr', 'D', '4010', '5010', '5010', '5040', '1530', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0);
1820 INSERT INTO `0_stock_master` VALUES('3400', 3, 1, 'P4 Business System', '', 'each', 'M', '4010', '5010', '1540', '5040', '1530', 0, 0, 0, 0, 33, 3.9999999999999, 2, 0, 0, 0, 0);
1822 -- --------------------------------------------------------
1825 -- Table structure for table `0_stock_moves`
1828 DROP TABLE IF EXISTS `0_stock_moves`;
1829 CREATE TABLE IF NOT EXISTS `0_stock_moves` (
1830 `trans_id` int(11) NOT NULL auto_increment,
1831 `trans_no` int(11) NOT NULL default '0',
1832 `stock_id` char(20) NOT NULL default '',
1833 `type` smallint(6) NOT NULL default '0',
1834 `loc_code` char(5) NOT NULL default '',
1835 `tran_date` date NOT NULL default '0000-00-00',
1836 `person_id` int(11) default NULL,
1837 `price` double NOT NULL default '0',
1838 `reference` char(40) NOT NULL default '',
1839 `qty` double NOT NULL default '1',
1840 `discount_percent` double NOT NULL default '0',
1841 `standard_cost` double NOT NULL default '0',
1842 `visible` tinyint(1) NOT NULL default '1',
1843 PRIMARY KEY (`trans_id`),
1844 KEY `type` (`type`,`trans_no`),
1845 KEY `Move` (`stock_id`,`loc_code`,`tran_date`)
1846 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=37 ;
1849 -- Dumping data for table `0_stock_moves`
1852 INSERT INTO `0_stock_moves` VALUES(1, 1, '102', 25, 'DEF', '2014-06-21', 2, 10, '', 100, 0, 10, 1);
1853 INSERT INTO `0_stock_moves` VALUES(2, 1, '103', 25, 'DEF', '2014-06-21', 2, 11, '', 100, 0, 11, 1);
1854 INSERT INTO `0_stock_moves` VALUES(3, 1, '104', 25, 'DEF', '2014-06-21', 2, 12, '', 100, 0, 12, 1);
1855 INSERT INTO `0_stock_moves` VALUES(4, 1, '102', 26, 'DEF', '2014-06-21', 0, 0, '1', -10, 0, 0, 1);
1856 INSERT INTO `0_stock_moves` VALUES(5, 1, '103', 26, 'DEF', '2014-06-21', 0, 0, '1', -10, 0, 0, 1);
1857 INSERT INTO `0_stock_moves` VALUES(6, 1, '104', 26, 'DEF', '2014-06-21', 0, 0, '1', -10, 0, 0, 1);
1858 INSERT INTO `0_stock_moves` VALUES(7, 1, '3400', 26, 'DEF', '2014-06-21', 0, 0, '1', 10, 0, 0, 1);
1859 INSERT INTO `0_stock_moves` VALUES(8, 2, '102', 13, 'DEF', '2014-06-21', 0, 30.4, '1', -2, 0, 10, 1);
1860 INSERT INTO `0_stock_moves` VALUES(9, 3, '102', 13, 'DEF', '2014-06-21', 0, 50, 'auto', -1, 0, 10, 1);
1861 INSERT INTO `0_stock_moves` VALUES(10, 4, '102', 13, 'DEF', '2014-06-21', 0, 35.89, 'auto', -1, 0, 10, 1);
1862 INSERT INTO `0_stock_moves` VALUES(11, 3, '102', 26, 'DEF', '2014-06-21', 0, 0, '3', -2, 0, 0, 1);
1863 INSERT INTO `0_stock_moves` VALUES(12, 3, '103', 26, 'DEF', '2014-06-21', 0, 0, '3', -2, 0, 0, 1);
1864 INSERT INTO `0_stock_moves` VALUES(13, 3, '104', 26, 'DEF', '2014-06-21', 0, 0, '3', -2, 0, 0, 1);
1865 INSERT INTO `0_stock_moves` VALUES(14, 3, '3400', 26, 'DEF', '2014-06-21', 0, 0, '3', 2, 0, 0, 1);
1866 INSERT INTO `0_stock_moves` VALUES(15, 4, '102', 26, 'DEF', '2014-06-21', 0, 0, '4', -4, 0, 0, 1);
1867 INSERT INTO `0_stock_moves` VALUES(16, 4, '103', 26, 'DEF', '2014-06-21', 0, 0, '4', -4, 0, 0, 1);
1868 INSERT INTO `0_stock_moves` VALUES(17, 4, '104', 26, 'DEF', '2014-06-21', 0, 0, '4', -4, 0, 0, 1);
1869 INSERT INTO `0_stock_moves` VALUES(18, 4, '3400', 26, 'DEF', '2014-06-21', 0, 0, '4', 4, 0, 0, 1);
1870 INSERT INTO `0_stock_moves` VALUES(19, 2, '102', 26, 'DEF', '2014-06-21', 0, 0, '', -2, 0, 0, 1);
1871 INSERT INTO `0_stock_moves` VALUES(20, 2, '103', 26, 'DEF', '2014-06-21', 0, 0, '', -2, 0, 0, 1);
1872 INSERT INTO `0_stock_moves` VALUES(21, 2, '104', 26, 'DEF', '2014-06-21', 0, 0, '', -2, 0, 0, 1);
1873 INSERT INTO `0_stock_moves` VALUES(22, 1, '3400', 29, 'DEF', '2014-06-21', 0, 0, '', 2, 0, 0, 1);
1874 INSERT INTO `0_stock_moves` VALUES(23, 5, '102', 26, 'DEF', '2014-06-21', 0, 0, '5', -5, 0, 0, 1);
1875 INSERT INTO `0_stock_moves` VALUES(24, 5, '103', 26, 'DEF', '2014-06-21', 0, 0, '5', -5, 0, 0, 1);
1876 INSERT INTO `0_stock_moves` VALUES(25, 5, '104', 26, 'DEF', '2014-06-21', 0, 0, '5', -5, 0, 0, 1);
1877 INSERT INTO `0_stock_moves` VALUES(26, 5, '3400', 26, 'DEF', '2014-06-21', 0, 0, '5', 5, 0, 0, 1);
1878 INSERT INTO `0_stock_moves` VALUES(27, 6, '102', 26, 'DEF', '2014-06-21', 0, 0, '6', 5, 0, 0, 1);
1879 INSERT INTO `0_stock_moves` VALUES(28, 6, '103', 26, 'DEF', '2014-06-21', 0, 0, '6', 5, 0, 0, 1);
1880 INSERT INTO `0_stock_moves` VALUES(29, 6, '104', 26, 'DEF', '2014-06-21', 0, 0, '6', 5, 0, 0, 1);
1881 INSERT INTO `0_stock_moves` VALUES(30, 6, '3400', 26, 'DEF', '2014-06-21', 0, 0, '6', -5, 0, 0, 1);
1882 INSERT INTO `0_stock_moves` VALUES(31, 7, '102', 26, 'DEF', '2014-06-21', 0, 0, '7', 2, 0, 0, 1);
1883 INSERT INTO `0_stock_moves` VALUES(32, 7, '103', 26, 'DEF', '2014-06-21', 0, 0, '7', 2, 0, 0, 1);
1884 INSERT INTO `0_stock_moves` VALUES(33, 7, '104', 26, 'DEF', '2014-06-21', 0, 0, '7', 2, 0, 0, 1);
1885 INSERT INTO `0_stock_moves` VALUES(34, 7, '3400', 26, 'DEF', '2014-06-21', 0, 0, '7', -2, 0, 0, 1);
1886 INSERT INTO `0_stock_moves` VALUES(35, 5, '102', 13, 'DEF', '2014-06-21', 0, 50, 'auto', -1, 0, 10, 1);
1887 INSERT INTO `0_stock_moves` VALUES(36, 3, '102', 11, 'DEF', '2014-06-21', 0, 37.68, 'Return Ex Inv: 18', 1, 0, 10, 0);
1889 -- --------------------------------------------------------
1892 -- Table structure for table `0_suppliers`
1895 DROP TABLE IF EXISTS `0_suppliers`;
1896 CREATE TABLE IF NOT EXISTS `0_suppliers` (
1897 `supplier_id` int(11) NOT NULL auto_increment,
1898 `supp_name` varchar(60) NOT NULL default '',
1899 `supp_ref` varchar(30) NOT NULL default '',
1900 `address` tinytext NOT NULL,
1901 `supp_address` tinytext NOT NULL,
1902 `gst_no` varchar(25) NOT NULL default '',
1903 `contact` varchar(60) NOT NULL default '',
1904 `supp_account_no` varchar(40) NOT NULL default '',
1905 `website` varchar(100) NOT NULL default '',
1906 `bank_account` varchar(60) NOT NULL default '',
1907 `curr_code` char(3) default NULL,
1908 `payment_terms` int(11) default NULL,
1909 `tax_included` tinyint(1) NOT NULL default '0',
1910 `dimension_id` int(11) default '0',
1911 `dimension2_id` int(11) default '0',
1912 `tax_group_id` int(11) default NULL,
1913 `credit_limit` double NOT NULL default '0',
1914 `purchase_account` varchar(15) NOT NULL default '',
1915 `payable_account` varchar(15) NOT NULL default '',
1916 `payment_discount_account` varchar(15) NOT NULL default '',
1917 `notes` tinytext NOT NULL,
1918 `inactive` tinyint(1) NOT NULL default '0',
1919 PRIMARY KEY (`supplier_id`),
1920 KEY `supp_ref` (`supp_ref`)
1921 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=4 ;
1924 -- Dumping data for table `0_suppliers`
1927 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, 0, 2, 1000, '', '2100', '5060', 'A supplier with junk beers.', 0);
1928 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, 0, 0, 1, 500, '', '2100', '5060', '', 0);
1929 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, 0, 0, 2, 300, '', '2100', '5060', '', 0);
1931 -- --------------------------------------------------------
1934 -- Table structure for table `0_supp_allocations`
1937 DROP TABLE IF EXISTS `0_supp_allocations`;
1938 CREATE TABLE IF NOT EXISTS `0_supp_allocations` (
1939 `id` int(11) NOT NULL auto_increment,
1940 `person_id` int(11) DEFAULT NULL,
1941 `amt` double unsigned default NULL,
1942 `date_alloc` date NOT NULL default '0000-00-00',
1943 `trans_no_from` int(11) default NULL,
1944 `trans_type_from` int(11) default NULL,
1945 `trans_no_to` int(11) default NULL,
1946 `trans_type_to` int(11) default NULL,
1948 UNIQUE KEY `trans_type_from` (`person_id`,`trans_type_from`,`trans_no_from`,`trans_type_to`,`trans_no_to`),
1949 KEY `From` (`trans_type_from`,`trans_no_from`),
1950 KEY `To` (`trans_type_to`,`trans_no_to`)
1951 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;
1954 -- Dumping data for table `0_supp_allocations`
1957 INSERT INTO `0_supp_allocations` VALUES(1, 2, 3465, '2014-06-21', 4, 22, 7, 20);
1959 -- --------------------------------------------------------
1962 -- Table structure for table `0_supp_invoice_items`
1965 DROP TABLE IF EXISTS `0_supp_invoice_items`;
1966 CREATE TABLE IF NOT EXISTS `0_supp_invoice_items` (
1967 `id` int(11) NOT NULL auto_increment,
1968 `supp_trans_no` int(11) default NULL,
1969 `supp_trans_type` int(11) default NULL,
1970 `gl_code` varchar(15) NOT NULL default '',
1971 `grn_item_id` int(11) default NULL,
1972 `po_detail_item_id` int(11) default NULL,
1973 `stock_id` varchar(20) NOT NULL default '',
1974 `description` tinytext,
1975 `quantity` double NOT NULL default '0',
1976 `unit_price` double NOT NULL default '0',
1977 `unit_tax` double NOT NULL default '0',
1979 `dimension_id` int(11) NOT NULL DEFAULT '0',
1980 `dimension2_id` int(11) NOT NULL DEFAULT '0',
1982 KEY `Transaction` (`supp_trans_type`,`supp_trans_no`,`stock_id`)
1983 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=6 ;
1986 -- Dumping data for table `0_supp_invoice_items`
1989 INSERT INTO `0_supp_invoice_items` VALUES(1, 7, 20, '0', 1, 1, '102', '17inch VGA Monitor', 100, 10, 0.5, '', 0, 0);
1990 INSERT INTO `0_supp_invoice_items` VALUES(2, 7, 20, '0', 2, 2, '103', '32MB VGA Card', 100, 11, 0.55, '', 0, 0);
1991 INSERT INTO `0_supp_invoice_items` VALUES(3, 7, 20, '0', 3, 3, '104', '52x CD Drive', 100, 12, 0.6, '', 0, 0);
1992 INSERT INTO `0_supp_invoice_items` VALUES(4, 8, 20, '2150', 0, 0, '', '', 0, 0.95, 0, 'Phone', 0, 0);
1993 INSERT INTO `0_supp_invoice_items` VALUES(5, 8, 20, '5780', 0, 0, '', '', 0, 19.05, 0, 'Phone', 0, 0);
1995 -- --------------------------------------------------------
1998 -- Table structure for table `0_supp_trans`
2001 DROP TABLE IF EXISTS `0_supp_trans`;
2002 CREATE TABLE IF NOT EXISTS `0_supp_trans` (
2003 `trans_no` int(11) unsigned NOT NULL default '0',
2004 `type` smallint(6) unsigned NOT NULL default '0',
2005 `supplier_id` int(11) unsigned default NULL,
2006 `reference` tinytext NOT NULL,
2007 `supp_reference` varchar(60) NOT NULL default '',
2008 `tran_date` date NOT NULL default '0000-00-00',
2009 `due_date` date NOT NULL default '0000-00-00',
2010 `ov_amount` double NOT NULL default '0',
2011 `ov_discount` double NOT NULL default '0',
2012 `ov_gst` double NOT NULL default '0',
2013 `rate` double NOT NULL default '1',
2014 `alloc` double NOT NULL default '0',
2015 `tax_included` tinyint(1) NOT NULL default '0',
2016 PRIMARY KEY (`type`,`trans_no`),
2017 KEY `supplier_id` (`supplier_id`),
2018 KEY `SupplierID_2` (`supplier_id`,`supp_reference`),
2019 KEY `type` (`type`),
2020 KEY `tran_date` (`tran_date`)
2021 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
2024 -- Dumping data for table `0_supp_trans`
2027 INSERT INTO `0_supp_trans` VALUES(7, 20, 2, '1', '5t', '2014-06-21', '2014-07-01', 3300, 0, 165, 1, 3465, 0);
2028 INSERT INTO `0_supp_trans` VALUES(8, 20, 2, '2', 'cc', '2014-06-21', '2014-07-01', 20, 0, 0, 1, 0, 0);
2029 INSERT INTO `0_supp_trans` VALUES(4, 22, 2, '1', '', '2014-06-21', '2014-06-21', -3465, 0, 0, 1, 3465, 0);
2031 -- --------------------------------------------------------
2034 -- Table structure for table `0_sys_prefs`
2037 DROP TABLE IF EXISTS `0_sys_prefs`;
2038 CREATE TABLE IF NOT EXISTS `0_sys_prefs` (
2039 `name` varchar(35) NOT NULL default '',
2040 `category` varchar(30) default NULL,
2041 `type` varchar(20) NOT NULL default '',
2042 `length` smallint(6) default NULL,
2043 `value` text NOT NULL,
2044 PRIMARY KEY (`name`),
2045 KEY `category` (`category`)
2046 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
2049 -- Dumping data for table `0_sys_prefs`
2052 INSERT INTO `0_sys_prefs` VALUES('coy_name', 'setup.company', 'varchar', 60, 'Training Co.');
2053 INSERT INTO `0_sys_prefs` VALUES('gst_no', 'setup.company', 'varchar', 25, '9876543');
2054 INSERT INTO `0_sys_prefs` VALUES('coy_no', 'setup.company', 'varchar', 25, '123456789');
2055 INSERT INTO `0_sys_prefs` VALUES('tax_prd', 'setup.company', 'int', 11, '1');
2056 INSERT INTO `0_sys_prefs` VALUES('tax_last', 'setup.company', 'int', 11, '1');
2057 INSERT INTO `0_sys_prefs` VALUES('postal_address', 'setup.company', 'tinytext', 0, 'Address 1\nAddress 2\nAddress 3');
2058 INSERT INTO `0_sys_prefs` VALUES('phone', 'setup.company', 'varchar', 30, '(222) 111.222.333');
2059 INSERT INTO `0_sys_prefs` VALUES('fax', 'setup.company', 'varchar', 30, '');
2060 INSERT INTO `0_sys_prefs` VALUES('email', 'setup.company', 'varchar', 100, 'delta@delta.com');
2061 INSERT INTO `0_sys_prefs` VALUES('coy_logo', 'setup.company', 'varchar', 100, 'logo_frontaccounting.jpg');
2062 INSERT INTO `0_sys_prefs` VALUES('domicile', 'setup.company', 'varchar', 55, '');
2063 INSERT INTO `0_sys_prefs` VALUES('curr_default', 'setup.company', 'char', 3, 'USD');
2064 INSERT INTO `0_sys_prefs` VALUES('use_dimension', 'setup.company', 'tinyint', 1, '1');
2065 INSERT INTO `0_sys_prefs` VALUES('f_year', 'setup.company', 'int', 11, '2');
2066 INSERT INTO `0_sys_prefs` VALUES('no_item_list', 'setup.company', 'tinyint', 1, '0');
2067 INSERT INTO `0_sys_prefs` VALUES('no_customer_list', 'setup.company', 'tinyint', 1, '0');
2068 INSERT INTO `0_sys_prefs` VALUES('no_supplier_list', 'setup.company', 'tinyint', 1, '0');
2069 INSERT INTO `0_sys_prefs` VALUES('base_sales', 'setup.company', 'int', 11, '1');
2070 INSERT INTO `0_sys_prefs` VALUES('time_zone', 'setup.company', 'tinyint', 1, '0');
2071 INSERT INTO `0_sys_prefs` VALUES('add_pct', 'setup.company', 'int', 5, '-1');
2072 INSERT INTO `0_sys_prefs` VALUES('round_to', 'setup.company', 'int', 5, '1');
2073 INSERT INTO `0_sys_prefs` VALUES('login_tout', 'setup.company', 'smallint', 6, '600');
2074 INSERT INTO `0_sys_prefs` VALUES('past_due_days', 'glsetup.general', 'int', 11, '30');
2075 INSERT INTO `0_sys_prefs` VALUES('profit_loss_year_act', 'glsetup.general', 'varchar', 15, '9990');
2076 INSERT INTO `0_sys_prefs` VALUES('retained_earnings_act', 'glsetup.general', 'varchar', 15, '3590');
2077 INSERT INTO `0_sys_prefs` VALUES('bank_charge_act', 'glsetup.general', 'varchar', 15, '5690');
2078 INSERT INTO `0_sys_prefs` VALUES('exchange_diff_act', 'glsetup.general', 'varchar', 15, '4450');
2079 INSERT INTO `0_sys_prefs` VALUES('tax_algorithm', 'glsetup.customer', 'tinyint', 1, '1');
2080 INSERT INTO `0_sys_prefs` VALUES('default_credit_limit', 'glsetup.customer', 'int', 11, '1000');
2081 INSERT INTO `0_sys_prefs` VALUES('accumulate_shipping', 'glsetup.customer', 'tinyint', 1, '0');
2082 INSERT INTO `0_sys_prefs` VALUES('legal_text', 'glsetup.customer', 'tinytext', 0, '');
2083 INSERT INTO `0_sys_prefs` VALUES('freight_act', 'glsetup.customer', 'varchar', 15, '4430');
2084 INSERT INTO `0_sys_prefs` VALUES('debtors_act', 'glsetup.sales', 'varchar', 15, '1200');
2085 INSERT INTO `0_sys_prefs` VALUES('default_sales_act', 'glsetup.sales', 'varchar', 15, '4010');
2086 INSERT INTO `0_sys_prefs` VALUES('default_sales_discount_act', 'glsetup.sales', 'varchar', 15, '4510');
2087 INSERT INTO `0_sys_prefs` VALUES('default_prompt_payment_act', 'glsetup.sales', 'varchar', 15, '4500');
2088 INSERT INTO `0_sys_prefs` VALUES('default_delivery_required', 'glsetup.sales', 'smallint', 6, '1');
2089 INSERT INTO `0_sys_prefs` VALUES('default_receival_required', 'glsetup.purchase', 'smallint', 6, '10');
2090 INSERT INTO `0_sys_prefs` VALUES('default_quote_valid_days', 'glsetup.sales', 'smallint', 6, '30');
2091 INSERT INTO `0_sys_prefs` VALUES('default_dim_required', 'glsetup.dims', 'int', 11, '20');
2092 INSERT INTO `0_sys_prefs` VALUES('pyt_discount_act', 'glsetup.purchase', 'varchar', 15, '5060');
2093 INSERT INTO `0_sys_prefs` VALUES('creditors_act', 'glsetup.purchase', 'varchar', 15, '2100');
2094 INSERT INTO `0_sys_prefs` VALUES('po_over_receive', 'glsetup.purchase', 'int', 11, '10');
2095 INSERT INTO `0_sys_prefs` VALUES('po_over_charge', 'glsetup.purchase', 'int', 11, '10');
2096 INSERT INTO `0_sys_prefs` VALUES('allow_negative_stock', 'glsetup.inventory', 'tinyint', 1, '0');
2097 INSERT INTO `0_sys_prefs` VALUES('default_inventory_act', 'glsetup.items', 'varchar', 15, '1510');
2098 INSERT INTO `0_sys_prefs` VALUES('default_cogs_act', 'glsetup.items', 'varchar', 15, '5010');
2099 INSERT INTO `0_sys_prefs` VALUES('default_adj_act', 'glsetup.items', 'varchar', 15, '5040');
2100 INSERT INTO `0_sys_prefs` VALUES('default_inv_sales_act', 'glsetup.items', 'varchar', 15, '4010');
2101 INSERT INTO `0_sys_prefs` VALUES('default_assembly_act', 'glsetup.items', 'varchar', 15, '1530');
2102 INSERT INTO `0_sys_prefs` VALUES('default_workorder_required', 'glsetup.manuf', 'int', 11, '20');
2103 INSERT INTO `0_sys_prefs` VALUES('version_id', 'system', 'varchar', 11, '2.4.0');
2104 INSERT INTO `0_sys_prefs` VALUES('auto_curr_reval', 'setup.company', 'smallint', 6, '1');
2105 INSERT INTO `0_sys_prefs` VALUES('grn_clearing_act', 'glsetup.purchase', 'varchar', 15, '1550');
2106 INSERT INTO `0_sys_prefs` VALUES('bcc_email', 'setup.company', 'varchar', 100, '');
2107 INSERT INTO `0_sys_prefs` VALUES('deferred_income_act', 'glsetup.sales', 'varchar', '15', '');
2108 INSERT INTO `0_sys_prefs` VALUES('gl_closing_date','setup.closing_date', 'date', 8, '');
2109 INSERT INTO `0_sys_prefs` VALUES('no_zero_lines_amount','glsetup.sales', 'tinyint', 1, '1');
2110 INSERT INTO `0_sys_prefs` VALUES('show_po_item_codes','glsetup.purchase', 'tinyint', 1, '0');
2111 INSERT INTO `0_sys_prefs` VALUES('accounts_alpha','glsetup.general', 'tinyint', 1, '0');
2112 INSERT INTO `0_sys_prefs` VALUES('loc_notification','glsetup.inventory', 'tinyint', 1, '0');
2113 INSERT INTO `0_sys_prefs` VALUES('print_invoice_no','glsetup.sales', 'tinyint', 1, '0');
2114 INSERT INTO `0_sys_prefs` VALUES('allow_negative_prices','glsetup.inventory', 'tinyint', 1, '1');
2115 INSERT INTO `0_sys_prefs` VALUES('print_item_images_on_quote','glsetup.inventory', 'tinyint', 1, '0');
2116 INSERT INTO `0_sys_prefs` VALUES('alternative_tax_include_on_docs','setup.company', 'tinyint', 1, '0');
2117 INSERT INTO `0_sys_prefs` VALUES('suppress_tax_rates','setup.company', 'tinyint', 1, '0');
2120 -- --------------------------------------------------------
2123 -- Table structure for table `0_sys_types`
2126 DROP TABLE IF EXISTS `0_sys_types`;
2127 CREATE TABLE IF NOT EXISTS `0_sys_types` (
2128 `type_id` smallint(6) NOT NULL default '0',
2129 `type_no` int(11) NOT NULL default '1',
2130 `next_reference` varchar(100) NOT NULL default '',
2131 PRIMARY KEY (`type_id`)
2132 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
2135 -- Dumping data for table `0_sys_types`
2138 INSERT INTO `0_sys_types` VALUES(0, 19, '3');
2139 INSERT INTO `0_sys_types` VALUES(1, 8, '2');
2140 INSERT INTO `0_sys_types` VALUES(2, 5, '2');
2141 INSERT INTO `0_sys_types` VALUES(4, 3, '1');
2142 INSERT INTO `0_sys_types` VALUES(10, 19, '4');
2143 INSERT INTO `0_sys_types` VALUES(11, 3, '2');
2144 INSERT INTO `0_sys_types` VALUES(12, 6, '1');
2145 INSERT INTO `0_sys_types` VALUES(13, 5, '2');
2146 INSERT INTO `0_sys_types` VALUES(16, 2, '1');
2147 INSERT INTO `0_sys_types` VALUES(17, 2, '1');
2148 INSERT INTO `0_sys_types` VALUES(18, 1, '3');
2149 INSERT INTO `0_sys_types` VALUES(20, 8, '3');
2150 INSERT INTO `0_sys_types` VALUES(21, 1, '1');
2151 INSERT INTO `0_sys_types` VALUES(22, 4, '2');
2152 INSERT INTO `0_sys_types` VALUES(25, 1, '2');
2153 INSERT INTO `0_sys_types` VALUES(26, 1, '8');
2154 INSERT INTO `0_sys_types` VALUES(28, 1, '1');
2155 INSERT INTO `0_sys_types` VALUES(29, 1, '2');
2156 INSERT INTO `0_sys_types` VALUES(30, 5, '6');
2157 INSERT INTO `0_sys_types` VALUES(32, 0, '1');
2158 INSERT INTO `0_sys_types` VALUES(35, 1, '1');
2159 INSERT INTO `0_sys_types` VALUES(40, 1, '3');
2161 -- --------------------------------------------------------
2164 -- Table structure for table `0_tags`
2167 DROP TABLE IF EXISTS `0_tags`;
2168 CREATE TABLE IF NOT EXISTS `0_tags` (
2169 `id` int(11) NOT NULL auto_increment,
2170 `type` smallint(6) NOT NULL,
2171 `name` varchar(30) NOT NULL,
2172 `description` varchar(60) default NULL,
2173 `inactive` tinyint(1) NOT NULL default '0',
2175 UNIQUE KEY `type` (`type`,`name`)
2176 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
2179 -- Dumping data for table `0_tags`
2183 -- --------------------------------------------------------
2186 -- Table structure for table `0_tag_associations`
2189 DROP TABLE IF EXISTS `0_tag_associations`;
2190 CREATE TABLE IF NOT EXISTS `0_tag_associations` (
2191 `record_id` varchar(15) NOT NULL,
2192 `tag_id` int(11) NOT NULL,
2193 UNIQUE KEY `record_id` (`record_id`,`tag_id`)
2194 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
2197 -- Dumping data for table `0_tag_associations`
2201 -- --------------------------------------------------------
2204 -- Table structure for table `0_tax_groups`
2207 DROP TABLE IF EXISTS `0_tax_groups`;
2208 CREATE TABLE IF NOT EXISTS `0_tax_groups` (
2209 `id` int(11) NOT NULL auto_increment,
2210 `name` varchar(60) NOT NULL default '',
2211 `inactive` tinyint(1) NOT NULL default '0',
2213 UNIQUE KEY `name` (`name`)
2214 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=3 ;
2217 -- Dumping data for table `0_tax_groups`
2220 INSERT INTO `0_tax_groups` VALUES(1, 'Tax', 0);
2221 INSERT INTO `0_tax_groups` VALUES(2, 'Tax Exempt', 0);
2223 -- --------------------------------------------------------
2226 -- Table structure for table `0_tax_group_items`
2229 DROP TABLE IF EXISTS `0_tax_group_items`;
2230 CREATE TABLE IF NOT EXISTS `0_tax_group_items` (
2231 `tax_group_id` int(11) NOT NULL default '0',
2232 `tax_type_id` int(11) NOT NULL default '0',
2233 `tax_shipping` tinyint(1) NOT NULL default '0',
2234 PRIMARY KEY (`tax_group_id`,`tax_type_id`)
2235 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
2238 -- Dumping data for table `0_tax_group_items`
2241 INSERT INTO `0_tax_group_items` VALUES(1, 1, 1);
2243 -- --------------------------------------------------------
2246 -- Table structure for table `0_tax_types`
2249 DROP TABLE IF EXISTS `0_tax_types`;
2250 CREATE TABLE IF NOT EXISTS `0_tax_types` (
2251 `id` int(11) NOT NULL auto_increment,
2252 `rate` double NOT NULL default '0',
2253 `sales_gl_code` varchar(15) NOT NULL default '',
2254 `purchasing_gl_code` varchar(15) NOT NULL default '',
2255 `name` varchar(60) NOT NULL default '',
2256 `inactive` tinyint(1) NOT NULL default '0',
2258 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;
2261 -- Dumping data for table `0_tax_types`
2264 INSERT INTO `0_tax_types` VALUES(1, 5, '2150', '2150', 'Tax', 0);
2266 -- --------------------------------------------------------
2269 -- Table structure for table `0_trans_tax_details`
2272 DROP TABLE IF EXISTS `0_trans_tax_details`;
2273 CREATE TABLE IF NOT EXISTS `0_trans_tax_details` (
2274 `id` int(11) NOT NULL auto_increment,
2275 `trans_type` smallint(6) default NULL,
2276 `trans_no` int(11) default NULL,
2277 `tran_date` date NOT NULL,
2278 `tax_type_id` int(11) NOT NULL default '0',
2279 `rate` double NOT NULL default '0',
2280 `ex_rate` double NOT NULL default '1',
2281 `included_in_price` tinyint(1) NOT NULL default '0',
2282 `net_amount` double NOT NULL default '0',
2283 `amount` double NOT NULL default '0',
2285 `reg_type` tinyint(1) default NULL,
2287 KEY `Type_and_Number` (`trans_type`,`trans_no`),
2288 KEY `tran_date` (`tran_date`)
2289 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=12 ;
2292 -- Dumping data for table `0_trans_tax_details`
2295 INSERT INTO `0_trans_tax_details` VALUES(1, 20, 7, '2014-06-21', 1, 5, 1, 0, 3300, 165, '5t', 1);
2296 INSERT INTO `0_trans_tax_details` VALUES(2, 13, 3, '2014-06-21', 1, 5, 1, 0, 50, 2.5, 'auto', NULL);
2297 INSERT INTO `0_trans_tax_details` VALUES(3, 10, 17, '2014-06-21', 1, 5, 1, 0, 50, 2.5, '1', 0);
2298 INSERT INTO `0_trans_tax_details` VALUES(4, 13, 4, '2014-06-21', 1, 5, 1.3932, 0, 35.89, 1.7945, 'auto', NULL);
2299 INSERT INTO `0_trans_tax_details` VALUES(5, 10, 18, '2014-06-21', 1, 5, 1.3932, 0, 35.89, 1.7945, '2', 0);
2300 INSERT INTO `0_trans_tax_details` VALUES(6, 2, 5, '2014-06-21', 1, 5, 1, 0, 95.2, 4.76, '', NULL);
2301 INSERT INTO `0_trans_tax_details` VALUES(7, 1, 8, '2014-06-21', 1, 5, 1, 0, -47.6, -2.38, '', NULL);
2302 INSERT INTO `0_trans_tax_details` VALUES(8, 20, 8, '2014-06-21', 1, 5, 1, 0, -19, -0.95, 'cc', 1);
2303 INSERT INTO `0_trans_tax_details` VALUES(9, 13, 5, '2014-06-21', 1, 5, 1, 1, 47.619047619048, 2.3809523809524, 'auto', NULL);
2304 INSERT INTO `0_trans_tax_details` VALUES(10, 10, 19, '2014-06-21', 1, 5, 1, 1, 47.619047619048, 2.3809523809524, '3', 0);
2305 INSERT INTO `0_trans_tax_details` VALUES(11, 11, 3, '2014-06-21', 1, 5, 1.3932, 0, 35.89, 1.7945, '1', 0);
2307 -- --------------------------------------------------------
2310 -- Table structure for table `0_useronline`
2313 DROP TABLE IF EXISTS `0_useronline`;
2314 CREATE TABLE IF NOT EXISTS `0_useronline` (
2315 `id` int(11) NOT NULL auto_increment,
2316 `timestamp` int(15) NOT NULL default '0',
2317 `ip` varchar(40) NOT NULL default '',
2318 `file` varchar(100) NOT NULL default '',
2320 KEY `timestamp` (`timestamp`),
2322 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
2325 -- Dumping data for table `0_useronline`
2329 -- --------------------------------------------------------
2332 -- Table structure for table `0_users`
2335 DROP TABLE IF EXISTS `0_users`;
2336 CREATE TABLE IF NOT EXISTS `0_users` (
2337 `id` smallint(6) NOT NULL auto_increment,
2338 `user_id` varchar(60) NOT NULL default '',
2339 `password` varchar(100) NOT NULL default '',
2340 `real_name` varchar(100) NOT NULL default '',
2341 `role_id` int(11) NOT NULL default '1',
2342 `phone` varchar(30) NOT NULL default '',
2343 `email` varchar(100) default NULL,
2344 `language` varchar(20) default NULL,
2345 `date_format` tinyint(1) NOT NULL default '0',
2346 `date_sep` tinyint(1) NOT NULL default '0',
2347 `tho_sep` tinyint(1) NOT NULL default '0',
2348 `dec_sep` tinyint(1) NOT NULL default '0',
2349 `theme` varchar(20) NOT NULL default 'default',
2350 `page_size` varchar(20) NOT NULL default 'A4',
2351 `prices_dec` smallint(6) NOT NULL default '2',
2352 `qty_dec` smallint(6) NOT NULL default '2',
2353 `rates_dec` smallint(6) NOT NULL default '4',
2354 `percent_dec` smallint(6) NOT NULL default '1',
2355 `show_gl` tinyint(1) NOT NULL default '1',
2356 `show_codes` tinyint(1) NOT NULL default '0',
2357 `show_hints` tinyint(1) NOT NULL default '0',
2358 `last_visit_date` datetime default NULL,
2359 `query_size` tinyint(1) unsigned NOT NULL default '10',
2360 `graphic_links` tinyint(1) default '1',
2361 `pos` smallint(6) default '1',
2362 `print_profile` varchar(30) NOT NULL default '',
2363 `rep_popup` tinyint(1) default '1',
2364 `sticky_doc_date` tinyint(1) default '0',
2365 `startup_tab` varchar(20) NOT NULL default '',
2366 `transaction_days` smallint(6) NOT NULL default '30',
2367 `save_report_selections` smallint(6) NOT NULL default '0',
2368 `use_date_picker` tinyint(1) NOT NULL default '1',
2369 `def_print_destination` tinyint(1) NOT NULL default '0',
2370 `def_print_orientation` tinyint(1) NOT NULL default '0',
2371 `inactive` tinyint(1) NOT NULL default '0',
2373 UNIQUE KEY `user_id` (`user_id`)
2374 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=3 ;
2377 -- Dumping data for table `0_users`
2380 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, '2014-05-11 23:27:46', 10, 1, 1, '1', 1, 0, 'orders', 30, 0, 1, 0, 0, 0);
2381 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, '2014-02-06 19:02:35', 10, 1, 1, '1', 1, 0, 'orders', 30, 0, 1, 0, 0, 0);
2383 -- --------------------------------------------------------
2386 -- Table structure for table `0_voided`
2389 DROP TABLE IF EXISTS `0_voided`;
2390 CREATE TABLE IF NOT EXISTS `0_voided` (
2391 `type` int(11) NOT NULL default '0',
2392 `id` int(11) NOT NULL default '0',
2393 `date_` date NOT NULL default '0000-00-00',
2394 `memo_` tinytext NOT NULL,
2395 UNIQUE KEY `id` (`type`,`id`)
2396 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
2399 -- Dumping data for table `0_voided`
2403 -- --------------------------------------------------------
2406 -- Table structure for table `0_workcentres`
2409 DROP TABLE IF EXISTS `0_workcentres`;
2410 CREATE TABLE IF NOT EXISTS `0_workcentres` (
2411 `id` int(11) NOT NULL auto_increment,
2412 `name` char(40) NOT NULL default '',
2413 `description` char(50) NOT NULL default '',
2414 `inactive` tinyint(1) NOT NULL default '0',
2416 UNIQUE KEY `name` (`name`)
2417 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;
2420 -- Dumping data for table `0_workcentres`
2423 INSERT INTO `0_workcentres` VALUES(1, 'Workshop', 'Workshop in Alabama', 0);
2425 -- --------------------------------------------------------
2428 -- Table structure for table `0_workorders`
2431 DROP TABLE IF EXISTS `0_workorders`;
2432 CREATE TABLE IF NOT EXISTS `0_workorders` (
2433 `id` int(11) NOT NULL auto_increment,
2434 `wo_ref` varchar(60) NOT NULL default '',
2435 `loc_code` varchar(5) NOT NULL default '',
2436 `units_reqd` double NOT NULL default '1',
2437 `stock_id` varchar(20) NOT NULL default '',
2438 `date_` date NOT NULL default '0000-00-00',
2439 `type` tinyint(4) NOT NULL default '0',
2440 `required_by` date NOT NULL default '0000-00-00',
2441 `released_date` date NOT NULL default '0000-00-00',
2442 `units_issued` double NOT NULL default '0',
2443 `closed` tinyint(1) NOT NULL default '0',
2444 `released` tinyint(1) NOT NULL default '0',
2445 `additional_costs` double NOT NULL default '0',
2447 UNIQUE KEY `wo_ref` (`wo_ref`)
2448 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=8 ;
2451 -- Dumping data for table `0_workorders`
2454 INSERT INTO `0_workorders` VALUES(1, '1', 'DEF', 10, '3400', '2014-06-21', 0, '2014-06-21', '2014-06-21', 10, 1, 1, 10);
2455 INSERT INTO `0_workorders` VALUES(2, '2', 'DEF', 3, '3400', '2014-06-21', 2, '2014-07-11', '2014-06-21', 2, 0, 1, 0);
2456 INSERT INTO `0_workorders` VALUES(3, '3', 'DEF', 2, '3400', '2014-06-21', 0, '2014-06-21', '2014-06-21', 2, 1, 1, 0);
2457 INSERT INTO `0_workorders` VALUES(4, '4', 'DEF', 4, '3400', '2014-06-21', 0, '2014-06-21', '2014-06-21', 4, 1, 1, 0);
2458 INSERT INTO `0_workorders` VALUES(5, '5', 'DEF', 5, '3400', '2014-06-21', 0, '2014-06-21', '2014-06-21', 5, 1, 1, 10);
2459 INSERT INTO `0_workorders` VALUES(6, '6', 'DEF', -5, '3400', '2014-06-21', 1, '2014-06-21', '2014-06-21', -5, 1, 1, 0);
2460 INSERT INTO `0_workorders` VALUES(7, '7', 'DEF', -2, '3400', '2014-06-21', 1, '2014-06-21', '2014-06-21', -2, 1, 1, 10);
2462 -- --------------------------------------------------------
2465 -- Table structure for table `0_wo_costing`
2468 DROP TABLE IF EXISTS `0_wo_costing`;
2469 CREATE TABLE `0_wo_costing` (
2470 `id` int(11) NOT NULL auto_increment,
2471 `workorder_id` int(11) NOT NULL default '0',
2472 `cost_type` tinyint(1) NOT NULL default '0',
2473 `trans_type` int(11) NOT NULL default '0',
2474 `trans_no` int(11) NOT NULL default '0',
2475 `factor` double NOT NULL default '1',
2477 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
2480 -- Dumping data for table `0_wo_costing`
2484 -- --------------------------------------------------------
2487 -- Table structure for table `0_wo_issues`
2490 DROP TABLE IF EXISTS `0_wo_issues`;
2491 CREATE TABLE IF NOT EXISTS `0_wo_issues` (
2492 `issue_no` int(11) NOT NULL auto_increment,
2493 `workorder_id` int(11) NOT NULL default '0',
2494 `reference` varchar(100) default NULL,
2495 `issue_date` date default NULL,
2496 `loc_code` varchar(5) default NULL,
2497 `workcentre_id` int(11) default NULL,
2498 PRIMARY KEY (`issue_no`),
2499 KEY `workorder_id` (`workorder_id`)
2500 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
2503 -- Dumping data for table `0_wo_issues`
2507 -- --------------------------------------------------------
2510 -- Table structure for table `0_wo_issue_items`
2513 DROP TABLE IF EXISTS `0_wo_issue_items`;
2514 CREATE TABLE IF NOT EXISTS `0_wo_issue_items` (
2515 `id` int(11) NOT NULL auto_increment,
2516 `stock_id` varchar(40) default NULL,
2517 `issue_id` int(11) default NULL,
2518 `qty_issued` double default NULL,
2520 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
2523 -- Dumping data for table `0_wo_issue_items`
2527 -- --------------------------------------------------------
2530 -- Table structure for table `0_wo_manufacture`
2533 DROP TABLE IF EXISTS `0_wo_manufacture`;
2534 CREATE TABLE IF NOT EXISTS `0_wo_manufacture` (
2535 `id` int(11) NOT NULL auto_increment,
2536 `reference` varchar(100) default NULL,
2537 `workorder_id` int(11) NOT NULL default '0',
2538 `quantity` double NOT NULL default '0',
2539 `date_` date NOT NULL default '0000-00-00',
2541 KEY `workorder_id` (`workorder_id`)
2542 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;
2545 -- Dumping data for table `0_wo_manufacture`
2548 INSERT INTO `0_wo_manufacture` VALUES(1, '1', 2, 2, '2014-06-21');
2550 -- --------------------------------------------------------
2553 -- Table structure for table `0_wo_requirements`
2556 DROP TABLE IF EXISTS `0_wo_requirements`;
2557 CREATE TABLE IF NOT EXISTS `0_wo_requirements` (
2558 `id` int(11) NOT NULL auto_increment,
2559 `workorder_id` int(11) NOT NULL default '0',
2560 `stock_id` char(20) NOT NULL default '',
2561 `workcentre` int(11) NOT NULL default '0',
2562 `units_req` double NOT NULL default '1',
2563 `std_cost` double NOT NULL default '0',
2564 `loc_code` char(5) NOT NULL default '',
2565 `units_issued` double NOT NULL default '0',
2567 KEY `workorder_id` (`workorder_id`)
2568 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=22 ;
2571 -- Dumping data for table `0_wo_requirements`
2574 INSERT INTO `0_wo_requirements` VALUES(1, 1, '102', 1, 1, 0, 'DEF', 10);
2575 INSERT INTO `0_wo_requirements` VALUES(2, 1, '103', 1, 1, 0, 'DEF', 10);
2576 INSERT INTO `0_wo_requirements` VALUES(3, 1, '104', 1, 1, 0, 'DEF', 10);
2577 INSERT INTO `0_wo_requirements` VALUES(4, 2, '102', 1, 1, 0, 'DEF', 0);
2578 INSERT INTO `0_wo_requirements` VALUES(5, 2, '103', 1, 1, 0, 'DEF', 0);
2579 INSERT INTO `0_wo_requirements` VALUES(6, 2, '104', 1, 1, 0, 'DEF', 0);
2580 INSERT INTO `0_wo_requirements` VALUES(7, 3, '102', 1, 1, 0, 'DEF', 2);
2581 INSERT INTO `0_wo_requirements` VALUES(8, 3, '103', 1, 1, 0, 'DEF', 2);
2582 INSERT INTO `0_wo_requirements` VALUES(9, 3, '104', 1, 1, 0, 'DEF', 2);
2583 INSERT INTO `0_wo_requirements` VALUES(10, 4, '102', 1, 1, 0, 'DEF', 4);
2584 INSERT INTO `0_wo_requirements` VALUES(11, 4, '103', 1, 1, 0, 'DEF', 4);
2585 INSERT INTO `0_wo_requirements` VALUES(12, 4, '104', 1, 1, 0, 'DEF', 4);
2586 INSERT INTO `0_wo_requirements` VALUES(13, 5, '102', 1, 1, 0, 'DEF', 5);
2587 INSERT INTO `0_wo_requirements` VALUES(14, 5, '103', 1, 1, 0, 'DEF', 5);
2588 INSERT INTO `0_wo_requirements` VALUES(15, 5, '104', 1, 1, 0, 'DEF', 5);
2589 INSERT INTO `0_wo_requirements` VALUES(16, 6, '102', 1, 1, 0, 'DEF', -5);
2590 INSERT INTO `0_wo_requirements` VALUES(17, 6, '103', 1, 1, 0, 'DEF', -5);
2591 INSERT INTO `0_wo_requirements` VALUES(18, 6, '104', 1, 1, 0, 'DEF', -5);
2592 INSERT INTO `0_wo_requirements` VALUES(19, 7, '102', 1, 1, 0, 'DEF', -2);
2593 INSERT INTO `0_wo_requirements` VALUES(20, 7, '103', 1, 1, 0, 'DEF', -2);
2594 INSERT INTO `0_wo_requirements` VALUES(21, 7, '104', 1, 1, 0, 'DEF', -2);