1 -- MySQL dump of database 'en_US-demo' on host 'localhost'
2 -- Backup Date and Time: 2015-05-07 14:03
3 -- Built by FrontAccounting 2.4.Beta
4 -- http://frontaccounting.com
5 -- Company: Training Co
8 -- Compatibility: 2.4.Beta
11 -- Database: `fatraining`
14 -- --------------------------------------------------------
19 -- Table structure for table `0_areas`
22 DROP TABLE IF EXISTS `0_areas`;
23 CREATE TABLE IF NOT EXISTS `0_areas` (
24 `area_code` int(11) NOT NULL AUTO_INCREMENT,
25 `description` varchar(60) NOT NULL DEFAULT '',
26 `inactive` tinyint(1) NOT NULL DEFAULT '0',
27 PRIMARY KEY (`area_code`),
28 UNIQUE KEY `description` (`description`)
29 ) ENGINE=InnoDB AUTO_INCREMENT=2 ;
32 -- Dumping data for table `0_areas`
35 INSERT INTO `0_areas` VALUES (1, 'Global', 0);
37 -- --------------------------------------------------------
40 -- Table structure for table `0_attachments`
43 DROP TABLE IF EXISTS `0_attachments`;
44 CREATE TABLE IF NOT EXISTS `0_attachments` (
45 `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
46 `description` varchar(60) NOT NULL DEFAULT '',
47 `type_no` int(11) NOT NULL DEFAULT '0',
48 `trans_no` int(11) NOT NULL DEFAULT '0',
49 `unique_name` varchar(60) NOT NULL DEFAULT '',
50 `tran_date` date NOT NULL DEFAULT '0000-00-00',
51 `filename` varchar(60) NOT NULL DEFAULT '',
52 `filesize` int(11) NOT NULL DEFAULT '0',
53 `filetype` varchar(60) NOT NULL DEFAULT '',
55 KEY `type_no` (`type_no`,`trans_no`)
59 -- Dumping data for table `0_attachments`
62 -- --------------------------------------------------------
65 -- Table structure for table `0_audit_trail`
68 DROP TABLE IF EXISTS `0_audit_trail`;
69 CREATE TABLE IF NOT EXISTS `0_audit_trail` (
70 `id` int(11) NOT NULL AUTO_INCREMENT,
71 `type` smallint(6) unsigned NOT NULL DEFAULT '0',
72 `trans_no` int(11) unsigned NOT NULL DEFAULT '0',
73 `user` smallint(6) unsigned NOT NULL DEFAULT '0',
74 `stamp` timestamp NOT NULL,
75 `description` varchar(60) DEFAULT NULL,
76 `fiscal_year` int(11) NOT NULL default 0,
77 `gl_date` date NOT NULL DEFAULT '0000-00-00',
78 `gl_seq` int(11) unsigned DEFAULT NULL,
80 KEY `Seq` (`fiscal_year`,`gl_date`,`gl_seq`),
81 KEY `Type_and_Number` (`type`,`trans_no`)
82 ) ENGINE=InnoDB AUTO_INCREMENT=29 ;
85 -- Dumping data for table `0_audit_trail`
88 INSERT INTO `0_audit_trail` VALUES
89 ('1', '18', '1', '1', '2015-05-05 14:08:02', NULL, '1', '2015-05-05', '0'),
90 ('2', '25', '1', '1', '2015-05-05 14:08:14', NULL, '1', '2015-05-05', '0'),
91 ('3', '30', '1', '1', '2015-05-05 14:09:54', NULL, '1', '2015-05-10', '0'),
92 ('4', '13', '1', '1', '2015-05-05 14:09:55', NULL, '1', '2015-05-10', '0'),
93 ('5', '10', '1', '1', '2015-05-05 14:09:55', NULL, '1', '2015-05-10', '0'),
94 ('6', '12', '1', '1', '2015-05-05 14:09:55', NULL, '1', '2015-05-10', '0'),
95 ('7', '26', '1', '1', '2015-05-05 14:18:49', 'Quick production.', '1', '2015-05-05', '0'),
96 ('8', '18', '2', '1', '2015-05-05 14:22:32', NULL, '1', '2015-05-05', '0'),
97 ('9', '25', '2', '1', '2015-05-05 14:22:32', NULL, '1', '2015-05-05', '0'),
98 ('10', '20', '1', '1', '2015-05-05 14:22:32', NULL, '1', '2015-05-05', '0'),
99 ('11', '30', '2', '1', '2015-05-07 07:55:15', NULL, '1', '2015-05-07', '0'),
100 ('12', '13', '2', '1', '2015-05-07 07:55:16', NULL, '1', '2015-05-07', '0'),
101 ('13', '10', '2', '1', '2015-05-07 07:55:16', NULL, '1', '2015-05-07', '0'),
102 ('14', '12', '2', '1', '2015-05-07 07:55:16', NULL, '1', '2015-05-07', '0'),
103 ('15', '30', '3', '1', '2015-05-07 08:08:24', NULL, '1', '2015-05-07', '0'),
104 ('16', '30', '4', '1', '2015-05-07 09:18:44', NULL, '1', '2015-05-07', '0'),
105 ('17', '30', '5', '1', '2015-05-07 11:42:41', NULL, '1', '2015-05-07', '0'),
106 ('18', '13', '3', '1', '2015-05-07 11:42:41', NULL, '1', '2015-05-07', '0'),
107 ('19', '10', '3', '1', '2015-05-07 11:42:41', NULL, '1', '2015-05-07', '0'),
108 ('20', '30', '6', '1', '2015-05-07 14:02:35', NULL, '1', '2015-05-07', '0'),
109 ('21', '30', '7', '1', '2015-05-07 14:05:38', NULL, '1', '2015-05-07', '0'),
110 ('22', '13', '4', '1', '2015-05-07 14:05:38', NULL, '1', '2015-05-07', '0'),
111 ('23', '10', '4', '1', '2015-05-07 14:05:38', NULL, '1', '2015-05-07', '0'),
112 ('24', '12', '3', '1', '2015-05-07 14:05:38', NULL, '1', '2015-05-07', '0'),
113 ('25', '26', '2', '1', '2015-05-07 15:59:34', NULL, '1', '2015-05-07', NULL),
114 ('26', '26', '3', '1', '2015-05-07 15:59:01', NULL, '1', '2015-05-07', '0'),
115 ('27', '26', '2', '1', '2015-05-07 15:59:34', 'Released.', '1', '2015-05-07', '0'),
116 ('28', '1', '1', '1', '2015-05-07 16:01:00', NULL, '1', '2015-05-07', '0');
118 -- --------------------------------------------------------
121 -- Table structure for table `0_bank_accounts`
124 DROP TABLE IF EXISTS `0_bank_accounts`;
125 CREATE TABLE IF NOT EXISTS `0_bank_accounts` (
126 `account_code` varchar(15) NOT NULL DEFAULT '',
127 `account_type` smallint(6) NOT NULL DEFAULT '0',
128 `bank_account_name` varchar(60) NOT NULL DEFAULT '',
129 `bank_account_number` varchar(100) NOT NULL DEFAULT '',
130 `bank_name` varchar(60) NOT NULL DEFAULT '',
131 `bank_address` tinytext,
132 `bank_curr_code` char(3) NOT NULL DEFAULT '',
133 `dflt_curr_act` tinyint(1) NOT NULL DEFAULT '0',
134 `id` smallint(6) NOT NULL AUTO_INCREMENT,
135 `bank_charge_act` varchar(15) NOT NULL DEFAULT '',
136 `last_reconciled_date` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
137 `ending_reconcile_balance` double NOT NULL DEFAULT '0',
138 `inactive` tinyint(1) NOT NULL DEFAULT '0',
140 KEY `bank_account_name` (`bank_account_name`),
141 KEY `bank_account_number` (`bank_account_number`),
142 KEY `account_code` (`account_code`)
143 ) ENGINE=InnoDB AUTO_INCREMENT=3 ;
146 -- Dumping data for table `0_bank_accounts`
149 INSERT INTO `0_bank_accounts` VALUES ('1060', 0, 'Current account', 'N/A', 'N/A', '', 'USD', 1, 1, '5690', '0000-00-00 00:00:00', 0, 0);
150 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);
152 -- --------------------------------------------------------
155 -- Table structure for table `0_bank_trans`
158 DROP TABLE IF EXISTS `0_bank_trans`;
159 CREATE TABLE IF NOT EXISTS `0_bank_trans` (
160 `id` int(11) NOT NULL AUTO_INCREMENT,
161 `type` smallint(6) DEFAULT NULL,
162 `trans_no` int(11) DEFAULT NULL,
163 `bank_act` varchar(15) NOT NULL DEFAULT '',
164 `ref` varchar(40) DEFAULT NULL,
165 `trans_date` date NOT NULL DEFAULT '0000-00-00',
166 `amount` double DEFAULT NULL,
167 `dimension_id` int(11) NOT NULL DEFAULT '0',
168 `dimension2_id` int(11) NOT NULL DEFAULT '0',
169 `person_type_id` int(11) NOT NULL DEFAULT '0',
170 `person_id` tinyblob,
171 `reconciled` date DEFAULT NULL,
173 KEY `bank_act` (`bank_act`,`ref`),
174 KEY `type` (`type`,`trans_no`),
175 KEY `bank_act_2` (`bank_act`,`reconciled`),
176 KEY `bank_act_3` (`bank_act`,`trans_date`)
177 ) ENGINE=InnoDB AUTO_INCREMENT=5 ;
180 -- Dumping data for table `0_bank_trans`
183 INSERT INTO `0_bank_trans` VALUES
184 ('1', '12', '1', '2', '001/2015', '2015-05-10', '6240', '0', '0', '2', '1', NULL),
185 ('2', '12', '2', '2', '002/2015', '2015-05-07', '300', '0', '0', '2', '1', NULL),
186 ('3', '12', '3', '2', '003/2015', '2015-05-07', '0', '0', '0', '2', '1', NULL),
187 ('4', '1', '1', '1', '001/2015', '2015-05-07', '-5', '0', '0', '0', 'Goods received', NULL);
189 -- --------------------------------------------------------
192 -- Table structure for table `0_bom`
195 DROP TABLE IF EXISTS `0_bom`;
196 CREATE TABLE IF NOT EXISTS `0_bom` (
197 `id` int(11) NOT NULL AUTO_INCREMENT,
198 `parent` char(20) NOT NULL DEFAULT '',
199 `component` char(20) NOT NULL DEFAULT '',
200 `workcentre_added` int(11) NOT NULL DEFAULT '0',
201 `loc_code` char(5) NOT NULL DEFAULT '',
202 `quantity` double NOT NULL DEFAULT '1',
203 PRIMARY KEY (`parent`,`component`,`workcentre_added`,`loc_code`),
204 KEY `component` (`component`),
206 KEY `loc_code` (`loc_code`),
207 KEY `parent` (`parent`,`loc_code`),
208 KEY `workcentre_added` (`workcentre_added`)
209 ) ENGINE=InnoDB AUTO_INCREMENT=5 ;
212 -- Dumping data for table `0_bom`
215 INSERT INTO `0_bom` VALUES
216 ('1', '201', '101', '1', 'DEF', '1'),
217 ('2', '201', '102', '1', 'DEF', '1'),
218 ('3', '201', '103', '1', 'DEF', '1'),
219 ('4', '201', '301', '1', 'DEF', '1');
221 -- --------------------------------------------------------
224 -- Table structure for table `0_budget_trans`
227 DROP TABLE IF EXISTS `0_budget_trans`;
228 CREATE TABLE IF NOT EXISTS `0_budget_trans` (
229 `id` int(11) NOT NULL AUTO_INCREMENT,
230 `tran_date` date NOT NULL DEFAULT '0000-00-00',
231 `account` varchar(15) NOT NULL DEFAULT '',
232 `memo_` tinytext NOT NULL,
233 `amount` double NOT NULL DEFAULT '0',
234 `dimension_id` int(11) DEFAULT '0',
235 `dimension2_id` int(11) DEFAULT '0',
237 KEY `Account` (`account`,`tran_date`,`dimension_id`,`dimension2_id`)
241 -- Dumping data for table `0_budget_trans`
244 -- --------------------------------------------------------
247 -- Table structure for table `0_chart_class`
250 DROP TABLE IF EXISTS `0_chart_class`;
251 CREATE TABLE IF NOT EXISTS `0_chart_class` (
252 `cid` varchar(3) NOT NULL,
253 `class_name` varchar(60) NOT NULL DEFAULT '',
254 `ctype` tinyint(1) NOT NULL DEFAULT '0',
255 `inactive` tinyint(1) NOT NULL DEFAULT '0',
260 -- Dumping data for table `0_chart_class`
263 INSERT INTO `0_chart_class` VALUES ('1', 'Assets', 1, 0);
264 INSERT INTO `0_chart_class` VALUES ('2', 'Liabilities', 2, 0);
265 INSERT INTO `0_chart_class` VALUES ('3', 'Income', 4, 0);
266 INSERT INTO `0_chart_class` VALUES ('4', 'Costs', 6, 0);
268 -- --------------------------------------------------------
271 -- Table structure for table `0_chart_master`
274 DROP TABLE IF EXISTS `0_chart_master`;
275 CREATE TABLE IF NOT EXISTS `0_chart_master` (
276 `account_code` varchar(15) NOT NULL DEFAULT '',
277 `account_code2` varchar(15) NOT NULL DEFAULT '',
278 `account_name` varchar(60) NOT NULL DEFAULT '',
279 `account_type` varchar(10) NOT NULL DEFAULT '0',
280 `inactive` tinyint(1) NOT NULL DEFAULT '0',
281 PRIMARY KEY (`account_code`),
282 KEY `account_name` (`account_name`),
283 KEY `accounts_by_type` (`account_type`,`account_code`)
287 -- Dumping data for table `0_chart_master`
290 INSERT INTO `0_chart_master` VALUES ('1060', '', 'Checking Account', '1', 0);
291 INSERT INTO `0_chart_master` VALUES ('1065', '', 'Petty Cash', '1', 0);
292 INSERT INTO `0_chart_master` VALUES ('1200', '', 'Accounts Receivables', '1', 0);
293 INSERT INTO `0_chart_master` VALUES ('1205', '', 'Allowance for doubtful accounts', '1', 0);
294 INSERT INTO `0_chart_master` VALUES ('1510', '', 'Inventory', '2', 0);
295 INSERT INTO `0_chart_master` VALUES ('1520', '', 'Stocks of Raw Materials', '2', 0);
296 INSERT INTO `0_chart_master` VALUES ('1530', '', 'Stocks of Work In Progress', '2', 0);
297 INSERT INTO `0_chart_master` VALUES ('1540', '', 'Stocks of Finished Goods', '2', 0);
298 INSERT INTO `0_chart_master` VALUES ('1550', '', 'Goods Received Clearing account', '2', 0);
299 INSERT INTO `0_chart_master` VALUES ('1820', '', 'Office Furniture & Equipment', '3', 0);
300 INSERT INTO `0_chart_master` VALUES ('1825', '', 'Accum. Amort. -Furn. & Equip.', '3', 0);
301 INSERT INTO `0_chart_master` VALUES ('1840', '', 'Vehicle', '3', 0);
302 INSERT INTO `0_chart_master` VALUES ('1845', '', 'Accum. Amort. -Vehicle', '3', 0);
303 INSERT INTO `0_chart_master` VALUES ('2100', '', 'Accounts Payable', '4', 0);
304 INSERT INTO `0_chart_master` VALUES ('2110', '', 'Accrued Income Tax - Federal', '4', 0);
305 INSERT INTO `0_chart_master` VALUES ('2120', '', 'Accrued Income Tax - State', '4', 0);
306 INSERT INTO `0_chart_master` VALUES ('2130', '', 'Accrued Franchise Tax', '4', 0);
307 INSERT INTO `0_chart_master` VALUES ('2140', '', 'Accrued Real & Personal Prop Tax', '4', 0);
308 INSERT INTO `0_chart_master` VALUES ('2150', '', 'Sales Tax', '4', 0);
309 INSERT INTO `0_chart_master` VALUES ('2160', '', 'Accrued Use Tax Payable', '4', 0);
310 INSERT INTO `0_chart_master` VALUES ('2210', '', 'Accrued Wages', '4', 0);
311 INSERT INTO `0_chart_master` VALUES ('2220', '', 'Accrued Comp Time', '4', 0);
312 INSERT INTO `0_chart_master` VALUES ('2230', '', 'Accrued Holiday Pay', '4', 0);
313 INSERT INTO `0_chart_master` VALUES ('2240', '', 'Accrued Vacation Pay', '4', 0);
314 INSERT INTO `0_chart_master` VALUES ('2310', '', 'Accr. Benefits - 401K', '4', 0);
315 INSERT INTO `0_chart_master` VALUES ('2320', '', 'Accr. Benefits - Stock Purchase', '4', 0);
316 INSERT INTO `0_chart_master` VALUES ('2330', '', 'Accr. Benefits - Med, Den', '4', 0);
317 INSERT INTO `0_chart_master` VALUES ('2340', '', 'Accr. Benefits - Payroll Taxes', '4', 0);
318 INSERT INTO `0_chart_master` VALUES ('2350', '', 'Accr. Benefits - Credit Union', '4', 0);
319 INSERT INTO `0_chart_master` VALUES ('2360', '', 'Accr. Benefits - Savings Bond', '4', 0);
320 INSERT INTO `0_chart_master` VALUES ('2370', '', 'Accr. Benefits - Garnish', '4', 0);
321 INSERT INTO `0_chart_master` VALUES ('2380', '', 'Accr. Benefits - Charity Cont.', '4', 0);
322 INSERT INTO `0_chart_master` VALUES ('2620', '', 'Bank Loans', '5', 0);
323 INSERT INTO `0_chart_master` VALUES ('2680', '', 'Loans from Shareholders', '5', 0);
324 INSERT INTO `0_chart_master` VALUES ('3350', '', 'Common Shares', '6', 0);
325 INSERT INTO `0_chart_master` VALUES ('3590', '', 'Retained Earnings - prior years', '7', 0);
326 INSERT INTO `0_chart_master` VALUES ('4010', '', 'Sales', '8', 0);
327 INSERT INTO `0_chart_master` VALUES ('4430', '', 'Shipping & Handling', '9', 0);
328 INSERT INTO `0_chart_master` VALUES ('4440', '', 'Interest', '9', 0);
329 INSERT INTO `0_chart_master` VALUES ('4450', '', 'Foreign Exchange Gain', '9', 0);
330 INSERT INTO `0_chart_master` VALUES ('4500', '', 'Prompt Payment Discounts', '9', 0);
331 INSERT INTO `0_chart_master` VALUES ('4510', '', 'Discounts Given', '9', 0);
332 INSERT INTO `0_chart_master` VALUES ('5010', '', 'Cost of Goods Sold - Retail', '10', 0);
333 INSERT INTO `0_chart_master` VALUES ('5020', '', 'Material Usage Varaiance', '10', 0);
334 INSERT INTO `0_chart_master` VALUES ('5030', '', 'Consumable Materials', '10', 0);
335 INSERT INTO `0_chart_master` VALUES ('5040', '', 'Purchase price Variance', '10', 0);
336 INSERT INTO `0_chart_master` VALUES ('5050', '', 'Purchases of materials', '10', 0);
337 INSERT INTO `0_chart_master` VALUES ('5060', '', 'Discounts Received', '10', 0);
338 INSERT INTO `0_chart_master` VALUES ('5100', '', 'Freight', '10', 0);
339 INSERT INTO `0_chart_master` VALUES ('5410', '', 'Wages & Salaries', '11', 0);
340 INSERT INTO `0_chart_master` VALUES ('5420', '', 'Wages - Overtime', '11', 0);
341 INSERT INTO `0_chart_master` VALUES ('5430', '', 'Benefits - Comp Time', '11', 0);
342 INSERT INTO `0_chart_master` VALUES ('5440', '', 'Benefits - Payroll Taxes', '11', 0);
343 INSERT INTO `0_chart_master` VALUES ('5450', '', 'Benefits - Workers Comp', '11', 0);
344 INSERT INTO `0_chart_master` VALUES ('5460', '', 'Benefits - Pension', '11', 0);
345 INSERT INTO `0_chart_master` VALUES ('5470', '', 'Benefits - General Benefits', '11', 0);
346 INSERT INTO `0_chart_master` VALUES ('5510', '', 'Inc Tax Exp - Federal', '11', 0);
347 INSERT INTO `0_chart_master` VALUES ('5520', '', 'Inc Tax Exp - State', '11', 0);
348 INSERT INTO `0_chart_master` VALUES ('5530', '', 'Taxes - Real Estate', '11', 0);
349 INSERT INTO `0_chart_master` VALUES ('5540', '', 'Taxes - Personal Property', '11', 0);
350 INSERT INTO `0_chart_master` VALUES ('5550', '', 'Taxes - Franchise', '11', 0);
351 INSERT INTO `0_chart_master` VALUES ('5560', '', 'Taxes - Foreign Withholding', '11', 0);
352 INSERT INTO `0_chart_master` VALUES ('5610', '', 'Accounting & Legal', '12', 0);
353 INSERT INTO `0_chart_master` VALUES ('5615', '', 'Advertising & Promotions', '12', 0);
354 INSERT INTO `0_chart_master` VALUES ('5620', '', 'Bad Debts', '12', 0);
355 INSERT INTO `0_chart_master` VALUES ('5660', '', 'Amortization Expense', '12', 0);
356 INSERT INTO `0_chart_master` VALUES ('5685', '', 'Insurance', '12', 0);
357 INSERT INTO `0_chart_master` VALUES ('5690', '', 'Interest & Bank Charges', '12', 0);
358 INSERT INTO `0_chart_master` VALUES ('5700', '', 'Office Supplies', '12', 0);
359 INSERT INTO `0_chart_master` VALUES ('5760', '', 'Rent', '12', 0);
360 INSERT INTO `0_chart_master` VALUES ('5765', '', 'Repair & Maintenance', '12', 0);
361 INSERT INTO `0_chart_master` VALUES ('5780', '', 'Telephone', '12', 0);
362 INSERT INTO `0_chart_master` VALUES ('5785', '', 'Travel & Entertainment', '12', 0);
363 INSERT INTO `0_chart_master` VALUES ('5790', '', 'Utilities', '12', 0);
364 INSERT INTO `0_chart_master` VALUES ('5795', '', 'Registrations', '12', 0);
365 INSERT INTO `0_chart_master` VALUES ('5800', '', 'Licenses', '12', 0);
366 INSERT INTO `0_chart_master` VALUES ('5810', '', 'Foreign Exchange Loss', '12', 0);
367 INSERT INTO `0_chart_master` VALUES ('9990', '', 'Year Profit/Loss', '12', 0);
369 -- --------------------------------------------------------
372 -- Table structure for table `0_chart_types`
375 DROP TABLE IF EXISTS `0_chart_types`;
376 CREATE TABLE IF NOT EXISTS `0_chart_types` (
377 `id` varchar(10) NOT NULL,
378 `name` varchar(60) NOT NULL DEFAULT '',
379 `class_id` varchar(3) NOT NULL DEFAULT '',
380 `parent` varchar(10) NOT NULL DEFAULT '-1',
381 `inactive` tinyint(1) NOT NULL DEFAULT '0',
384 KEY `class_id` (`class_id`)
388 -- Dumping data for table `0_chart_types`
391 INSERT INTO `0_chart_types` VALUES ('1', 'Current Assets', '1', '', 0);
392 INSERT INTO `0_chart_types` VALUES ('2', 'Inventory Assets', '1', '', 0);
393 INSERT INTO `0_chart_types` VALUES ('3', 'Capital Assets', '1', '', 0);
394 INSERT INTO `0_chart_types` VALUES ('4', 'Current Liabilities', '2', '', 0);
395 INSERT INTO `0_chart_types` VALUES ('5', 'Long Term Liabilities', '2', '', 0);
396 INSERT INTO `0_chart_types` VALUES ('6', 'Share Capital', '2', '', 0);
397 INSERT INTO `0_chart_types` VALUES ('7', 'Retained Earnings', '2', '', 0);
398 INSERT INTO `0_chart_types` VALUES ('8', 'Sales Revenue', '3', '', 0);
399 INSERT INTO `0_chart_types` VALUES ('9', 'Other Revenue', '3', '', 0);
400 INSERT INTO `0_chart_types` VALUES ('10', 'Cost of Goods Sold', '4', '', 0);
401 INSERT INTO `0_chart_types` VALUES ('11', 'Payroll Expenses', '4', '', 0);
402 INSERT INTO `0_chart_types` VALUES ('12', 'General & Administrative expenses', '4', '', 0);
404 -- --------------------------------------------------------
407 -- Table structure for table `0_comments`
410 DROP TABLE IF EXISTS `0_comments`;
411 CREATE TABLE IF NOT EXISTS `0_comments` (
412 `type` int(11) NOT NULL DEFAULT '0',
413 `id` int(11) NOT NULL DEFAULT '0',
414 `date_` date DEFAULT '0000-00-00',
416 KEY `type_and_id` (`type`,`id`)
420 -- Dumping data for table `0_comments`
423 INSERT INTO `0_comments` VALUES
424 ('12', '1', '2015-05-10', 'Cash invoice 1'),
425 ('12', '2', '2015-05-07', 'Cash invoice 2'),
426 ('13', '4', '2015-05-07', 'Recurrent Invoice covers period 04/01/2015 - 04/07/2015.'),
427 ('10', '4', '2015-05-07', 'Recurrent Invoice covers period 04/01/2015 - 04/07/2015.'),
428 ('12', '3', '2015-05-07', 'Cash invoice 4');
430 -- --------------------------------------------------------
433 -- Table structure for table `0_credit_status`
436 DROP TABLE IF EXISTS `0_credit_status`;
437 CREATE TABLE IF NOT EXISTS `0_credit_status` (
438 `id` int(11) NOT NULL AUTO_INCREMENT,
439 `reason_description` char(100) NOT NULL DEFAULT '',
440 `dissallow_invoices` tinyint(1) NOT NULL DEFAULT '0',
441 `inactive` tinyint(1) NOT NULL DEFAULT '0',
443 UNIQUE KEY `reason_description` (`reason_description`)
444 ) ENGINE=InnoDB AUTO_INCREMENT=5 ;
447 -- Dumping data for table `0_credit_status`
450 INSERT INTO `0_credit_status` VALUES (1, 'Good History', 0, 0);
451 INSERT INTO `0_credit_status` VALUES (3, 'No more work until payment received', 1, 0);
452 INSERT INTO `0_credit_status` VALUES (4, 'In liquidation', 1, 0);
454 -- --------------------------------------------------------
457 -- Table structure for table `0_crm_categories`
460 DROP TABLE IF EXISTS `0_crm_categories`;
461 CREATE TABLE IF NOT EXISTS `0_crm_categories` (
462 `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'pure technical key',
463 `type` varchar(20) NOT NULL COMMENT 'contact type e.g. customer',
464 `action` varchar(20) NOT NULL COMMENT 'detailed usage e.g. department',
465 `name` varchar(30) NOT NULL COMMENT 'for category selector',
466 `description` tinytext NOT NULL COMMENT 'usage description',
467 `system` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'nonzero for core system usage',
468 `inactive` tinyint(1) NOT NULL DEFAULT '0',
470 UNIQUE KEY `type` (`type`,`action`),
471 UNIQUE KEY `type_2` (`type`,`name`)
472 ) ENGINE=InnoDB AUTO_INCREMENT=13 ;
475 -- Dumping data for table `0_crm_categories`
478 INSERT INTO `0_crm_categories` VALUES (1, 'cust_branch', 'general', 'General', 'General contact data for customer branch (overrides company setting)', 1, 0);
479 INSERT INTO `0_crm_categories` VALUES (2, 'cust_branch', 'invoice', 'Invoices', 'Invoice posting (overrides company setting)', 1, 0);
480 INSERT INTO `0_crm_categories` VALUES (3, 'cust_branch', 'order', 'Orders', 'Order confirmation (overrides company setting)', 1, 0);
481 INSERT INTO `0_crm_categories` VALUES (4, 'cust_branch', 'delivery', 'Deliveries', 'Delivery coordination (overrides company setting)', 1, 0);
482 INSERT INTO `0_crm_categories` VALUES (5, 'customer', 'general', 'General', 'General contact data for customer', 1, 0);
483 INSERT INTO `0_crm_categories` VALUES (6, 'customer', 'order', 'Orders', 'Order confirmation', 1, 0);
484 INSERT INTO `0_crm_categories` VALUES (7, 'customer', 'delivery', 'Deliveries', 'Delivery coordination', 1, 0);
485 INSERT INTO `0_crm_categories` VALUES (8, 'customer', 'invoice', 'Invoices', 'Invoice posting', 1, 0);
486 INSERT INTO `0_crm_categories` VALUES (9, 'supplier', 'general', 'General', 'General contact data for supplier', 1, 0);
487 INSERT INTO `0_crm_categories` VALUES (10, 'supplier', 'order', 'Orders', 'Order confirmation', 1, 0);
488 INSERT INTO `0_crm_categories` VALUES (11, 'supplier', 'delivery', 'Deliveries', 'Delivery coordination', 1, 0);
489 INSERT INTO `0_crm_categories` VALUES (12, 'supplier', 'invoice', 'Invoices', 'Invoice posting', 1, 0);
491 -- --------------------------------------------------------
494 -- Table structure for table `0_crm_contacts`
497 DROP TABLE IF EXISTS `0_crm_contacts`;
498 CREATE TABLE IF NOT EXISTS `0_crm_contacts` (
499 `id` int(11) NOT NULL AUTO_INCREMENT,
500 `person_id` int(11) NOT NULL DEFAULT '0' COMMENT 'foreign key to crm_contacts',
501 `type` varchar(20) NOT NULL COMMENT 'foreign key to crm_categories',
502 `action` varchar(20) NOT NULL COMMENT 'foreign key to crm_categories',
503 `entity_id` varchar(11) DEFAULT NULL COMMENT 'entity id in related class table',
505 KEY `type` (`type`,`action`)
506 ) ENGINE=InnoDB AUTO_INCREMENT=11 ;
509 -- Dumping data for table `0_crm_contacts`
512 INSERT INTO `0_crm_contacts` VALUES
513 ('4', '2', 'supplier', 'general', '2'),
514 ('5', '3', 'cust_branch', 'general', '1'),
515 ('7', '3', 'customer', 'general', '1'),
516 ('8', '1', 'supplier', 'general', '1'),
517 ('9', '4', 'cust_branch', 'general', '2'),
518 ('10', '4', 'customer', 'general', '2');
520 -- --------------------------------------------------------
523 -- Table structure for table `0_crm_persons`
526 DROP TABLE IF EXISTS `0_crm_persons`;
527 CREATE TABLE IF NOT EXISTS `0_crm_persons` (
528 `id` int(11) NOT NULL AUTO_INCREMENT,
529 `ref` varchar(30) NOT NULL,
530 `name` varchar(60) NOT NULL,
531 `name2` varchar(60) DEFAULT NULL,
533 `phone` varchar(30) DEFAULT NULL,
534 `phone2` varchar(30) DEFAULT NULL,
535 `fax` varchar(30) DEFAULT NULL,
536 `email` varchar(100) DEFAULT NULL,
537 `lang` char(5) DEFAULT NULL,
538 `notes` tinytext NOT NULL,
539 `inactive` tinyint(1) NOT NULL DEFAULT '0',
542 ) ENGINE=InnoDB AUTO_INCREMENT=5 ;
545 -- Dumping data for table `0_crm_persons`
548 INSERT INTO `0_crm_persons` VALUES
549 ('1', 'Dino Saurius', 'John Doe', NULL, 'N/A', NULL, NULL, NULL, NULL, NULL, '', '0'),
550 ('2', 'Beefeater', 'Joe Oversea', NULL, 'N/A', NULL, NULL, NULL, NULL, NULL, '', '0'),
551 ('3', 'Donald Easter', 'Donald Easter LLC', NULL, 'N/A', NULL, NULL, NULL, NULL, NULL, '', '0'),
552 ('4', 'MoneyMaker', 'MoneyMaker Ltd.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', '0');
554 -- --------------------------------------------------------
557 -- Table structure for table `0_currencies`
560 DROP TABLE IF EXISTS `0_currencies`;
561 CREATE TABLE IF NOT EXISTS `0_currencies` (
562 `currency` varchar(60) NOT NULL DEFAULT '',
563 `curr_abrev` char(3) NOT NULL DEFAULT '',
564 `curr_symbol` varchar(10) NOT NULL DEFAULT '',
565 `country` varchar(100) NOT NULL DEFAULT '',
566 `hundreds_name` varchar(15) NOT NULL DEFAULT '',
567 `auto_update` tinyint(1) NOT NULL DEFAULT '1',
568 `inactive` tinyint(1) NOT NULL DEFAULT '0',
569 PRIMARY KEY (`curr_abrev`)
573 -- Dumping data for table `0_currencies`
576 INSERT INTO `0_currencies` VALUES ('US Dollars', 'USD', '$', 'United States', 'Cents', 1, 0);
577 INSERT INTO `0_currencies` VALUES ('CA Dollars', 'CAD', '$', 'Canada', 'Cents', 1, 0);
578 INSERT INTO `0_currencies` VALUES ('Euro', 'EUR', '€', 'Europe', 'Cents', 1, 0);
579 INSERT INTO `0_currencies` VALUES ('Pounds', 'GBP', '£', 'England', 'Pence', 1, 0);
581 -- --------------------------------------------------------
584 -- Table structure for table `0_cust_allocations`
587 DROP TABLE IF EXISTS `0_cust_allocations`;
588 CREATE TABLE IF NOT EXISTS `0_cust_allocations` (
589 `id` int(11) NOT NULL AUTO_INCREMENT,
590 `person_id` int(11) DEFAULT NULL,
591 `amt` double unsigned DEFAULT NULL,
592 `date_alloc` date NOT NULL DEFAULT '0000-00-00',
593 `trans_no_from` int(11) DEFAULT NULL,
594 `trans_type_from` int(11) DEFAULT NULL,
595 `trans_no_to` int(11) DEFAULT NULL,
596 `trans_type_to` int(11) DEFAULT NULL,
598 UNIQUE KEY `trans_type_from` (`person_id`,`trans_type_from`,`trans_no_from`,`trans_type_to`,`trans_no_to`),
599 KEY `From` (`trans_type_from`,`trans_no_from`),
600 KEY `To` (`trans_type_to`,`trans_no_to`)
601 ) ENGINE=InnoDB AUTO_INCREMENT=4 ;
604 -- Dumping data for table `0_cust_allocations`
607 INSERT INTO `0_cust_allocations` VALUES
608 ('1', '1', '6240', '2015-05-10', '1', '12', '1', '10'),
609 ('2', '1', '300', '2015-05-07', '2', '12', '2', '10'),
610 ('3', '1', '0', '2015-05-07', '3', '12', '4', '10');
612 -- --------------------------------------------------------
615 -- Table structure for table `0_cust_branch`
618 DROP TABLE IF EXISTS `0_cust_branch`;
619 CREATE TABLE IF NOT EXISTS `0_cust_branch` (
620 `branch_code` int(11) NOT NULL AUTO_INCREMENT,
621 `debtor_no` int(11) NOT NULL DEFAULT '0',
622 `br_name` varchar(60) NOT NULL DEFAULT '',
623 `branch_ref` varchar(30) NOT NULL DEFAULT '',
624 `br_address` tinytext NOT NULL,
625 `area` int(11) DEFAULT NULL,
626 `salesman` int(11) NOT NULL DEFAULT '0',
627 `default_location` varchar(5) NOT NULL DEFAULT '',
628 `tax_group_id` int(11) DEFAULT NULL,
629 `sales_account` varchar(15) NOT NULL DEFAULT '',
630 `sales_discount_account` varchar(15) NOT NULL DEFAULT '',
631 `receivables_account` varchar(15) NOT NULL DEFAULT '',
632 `payment_discount_account` varchar(15) NOT NULL DEFAULT '',
633 `default_ship_via` int(11) NOT NULL DEFAULT '1',
634 `br_post_address` tinytext NOT NULL,
635 `group_no` int(11) NOT NULL DEFAULT '0',
636 `notes` tinytext NOT NULL,
637 `bank_account` varchar(60) DEFAULT NULL,
638 `inactive` tinyint(1) NOT NULL DEFAULT '0',
639 PRIMARY KEY (`branch_code`,`debtor_no`),
640 KEY `branch_ref` (`branch_ref`),
641 KEY `group_no` (`group_no`)
642 ) ENGINE=InnoDB AUTO_INCREMENT=3 ;
645 -- Dumping data for table `0_cust_branch`
648 INSERT INTO `0_cust_branch` VALUES
649 ('1', '1', 'Donald Easter LLC', 'Donald Easter', 'N/A', '1', '1', 'DEF', '1', '', '4510', '1200', '4500', '1', 'N/A', '0', '', NULL, '0'),
650 ('2', '2', 'MoneyMaker Ltd.', 'MoneyMaker', '', '1', '1', 'DEF', '2', '', '4510', '1200', '4500', '1', '', '0', '', NULL, '0');
652 -- --------------------------------------------------------
655 -- Table structure for table `0_debtors_master`
658 DROP TABLE IF EXISTS `0_debtors_master`;
659 CREATE TABLE IF NOT EXISTS `0_debtors_master` (
660 `debtor_no` int(11) NOT NULL auto_increment,
661 `name` varchar(100) NOT NULL default '',
662 `debtor_ref` varchar(30) NOT NULL,
664 `tax_id` varchar(55) NOT NULL default '',
665 `curr_code` char(3) NOT NULL default '',
666 `sales_type` int(11) NOT NULL default '1',
667 `dimension_id` int(11) NOT NULL default '0',
668 `dimension2_id` int(11) NOT NULL default '0',
669 `credit_status` int(11) NOT NULL default '0',
670 `payment_terms` int(11) default NULL,
671 `discount` double NOT NULL default '0',
672 `pymt_discount` double NOT NULL default '0',
673 `credit_limit` float NOT NULL default '1000',
674 `notes` tinytext NOT NULL,
675 `inactive` tinyint(1) NOT NULL default '0',
676 PRIMARY KEY (`debtor_no`),
678 UNIQUE KEY `debtor_ref` (`debtor_ref`)
682 -- Dumping data for table `0_debtors_master`
686 INSERT INTO `0_debtors_master` VALUES
687 ('1', 'Donald Easter LLC', 'Donald Easter', 'N/A', '123456789', 'USD', '1', '0', '0', '1', '4', '0', '0', '1000', '', '0'),
688 ('2', 'MoneyMaker Ltd.', 'MoneyMaker', 'N/A', '54354333', 'EUR', '1', '1', '0', '1', '1', '0', '0', '1000', '', '0');
690 -- --------------------------------------------------------
693 -- Table structure for table `0_debtor_trans`
696 DROP TABLE IF EXISTS `0_debtor_trans`;
697 CREATE TABLE IF NOT EXISTS `0_debtor_trans` (
698 `trans_no` int(11) unsigned NOT NULL DEFAULT '0',
699 `type` smallint(6) unsigned NOT NULL DEFAULT '0',
700 `version` tinyint(1) unsigned NOT NULL DEFAULT '0',
701 `debtor_no` int(11) unsigned DEFAULT NULL,
702 `branch_code` int(11) NOT NULL DEFAULT '-1',
703 `tran_date` date NOT NULL DEFAULT '0000-00-00',
704 `due_date` date NOT NULL DEFAULT '0000-00-00',
705 `reference` varchar(60) NOT NULL DEFAULT '',
706 `tpe` int(11) NOT NULL DEFAULT '0',
707 `order_` int(11) NOT NULL DEFAULT '0',
708 `ov_amount` double NOT NULL DEFAULT '0',
709 `ov_gst` double NOT NULL DEFAULT '0',
710 `ov_freight` double NOT NULL DEFAULT '0',
711 `ov_freight_tax` double NOT NULL DEFAULT '0',
712 `ov_discount` double NOT NULL DEFAULT '0',
713 `alloc` double NOT NULL DEFAULT '0',
714 `prep_amount` double NOT NULL DEFAULT '0',
715 `rate` double NOT NULL DEFAULT '1',
716 `ship_via` int(11) DEFAULT NULL,
717 `dimension_id` int(11) NOT NULL DEFAULT '0',
718 `dimension2_id` int(11) NOT NULL DEFAULT '0',
719 `payment_terms` int(11) DEFAULT NULL,
720 `tax_included` tinyint(1) unsigned NOT NULL DEFAULT '0',
721 PRIMARY KEY (`type`,`trans_no`),
722 KEY `debtor_no` (`debtor_no`,`branch_code`),
723 KEY `tran_date` (`tran_date`),
724 KEY `order_` (`order_`)
728 -- Dumping data for table `0_debtor_trans`
732 INSERT INTO `0_debtor_trans` VALUES
733 ('1', '10', '0', '1', '1', '2015-05-10', '2015-05-05', '001/2015', '1', '1', '6240', '0', '0', '0', '0', '6240', '0', '1', '1', '0', '0', '4', '1'),
734 ('2', '10', '0', '1', '1', '2015-05-07', '2015-05-07', '002/2015', '1', '2', '300', '0', '0', '0', '0', '300', '0', '1', '1', '0', '0', '4', '1'),
735 ('3', '10', '0', '2', '2', '2015-05-07', '2015-06-17', '003/2015', '1', '5', '267.14', '0', '0', '0', '0', '0', '0', '1.123', '1', '1', '0', '1', '1'),
736 ('4', '10', '0', '1', '1', '2015-05-07', '2015-05-07', '004/2015', '1', '7', '0', '0', '0', '0', '0', '0', '0', '1', '1', '0', '0', '4', '1'),
737 ('1', '12', '0', '1', '1', '2015-05-10', '0000-00-00', '001/2015', '0', '0', '6240', '0', '0', '0', '0', '6240', '0', '1', '0', '0', '0', NULL, '0'),
738 ('2', '12', '0', '1', '1', '2015-05-07', '0000-00-00', '002/2015', '0', '0', '300', '0', '0', '0', '0', '300', '0', '1', '0', '0', '0', NULL, '0'),
739 ('3', '12', '0', '1', '1', '2015-05-07', '0000-00-00', '003/2015', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', NULL, '0'),
740 ('1', '13', '1', '1', '1', '2015-05-10', '2015-05-05', 'auto', '1', '1', '6240', '0', '0', '0', '0', '0', '0', '1', '1', '0', '0', '4', '1'),
741 ('2', '13', '1', '1', '1', '2015-05-07', '2015-05-07', 'auto', '1', '2', '300', '0', '0', '0', '0', '0', '0', '1', '1', '0', '0', '4', '1'),
742 ('3', '13', '1', '2', '2', '2015-05-07', '2015-06-17', 'auto', '1', '5', '267.14', '0', '0', '0', '0', '0', '0', '1.123', '1', '1', '0', '1', '1'),
743 ('4', '13', '1', '1', '1', '2015-05-07', '2015-05-07', 'auto', '1', '7', '0', '0', '0', '0', '0', '0', '0', '1', '1', '0', '0', '4', '1');
745 -- --------------------------------------------------------
748 -- Table structure for table `0_debtor_trans_details`
751 DROP TABLE IF EXISTS `0_debtor_trans_details`;
752 CREATE TABLE IF NOT EXISTS `0_debtor_trans_details` (
753 `id` int(11) NOT NULL AUTO_INCREMENT,
754 `debtor_trans_no` int(11) DEFAULT NULL,
755 `debtor_trans_type` int(11) DEFAULT NULL,
756 `stock_id` varchar(20) NOT NULL DEFAULT '',
757 `description` tinytext,
758 `unit_price` double NOT NULL DEFAULT '0',
759 `unit_tax` double NOT NULL DEFAULT '0',
760 `quantity` double NOT NULL DEFAULT '0',
761 `discount_percent` double NOT NULL DEFAULT '0',
762 `standard_cost` double NOT NULL DEFAULT '0',
763 `qty_done` double NOT NULL DEFAULT '0',
764 `src_id` int(11) NOT NULL,
766 KEY `Transaction` (`debtor_trans_type`,`debtor_trans_no`),
768 ) ENGINE=InnoDB AUTO_INCREMENT=13 ;
771 -- Dumping data for table `0_debtor_trans_details`
774 INSERT INTO `0_debtor_trans_details` VALUES
775 ('1', '1', '13', '101', 'iPad Air 2 16GB', '300', '14.29', '20', '0', '200', '20', '1'),
776 ('2', '1', '13', '301', 'Support', '80', '3.81', '3', '0', '0', '3', '2'),
777 ('3', '1', '10', '101', 'iPad Air 2 16GB', '300', '14.2855', '20', '0', '200', '0', '1'),
778 ('4', '1', '10', '301', 'Support', '80', '3.81', '3', '0', '0', '0', '2'),
779 ('5', '2', '13', '101', 'iPad Air 2 16GB', '300', '14.29', '1', '0', '200', '1', '3'),
780 ('6', '2', '10', '101', 'iPad Air 2 16GB', '300', '14.29', '1', '0', '200', '0', '5'),
781 ('7', '3', '13', '102', 'iPhone 6 64GB', '222.62', '0', '1', '0', '150', '1', '7'),
782 ('8', '3', '13', '103', 'iPhone Cover Case', '44.52', '0', '1', '0', '10', '1', '8'),
783 ('9', '3', '10', '102', 'iPhone 6 64GB', '222.62', '0', '1', '0', '150', '0', '7'),
784 ('10', '3', '10', '103', 'iPhone Cover Case', '44.52', '0', '1', '0', '10', '0', '8'),
785 ('11', '4', '13', '202', 'Maintenance', '0', '0', '5', '0', '0', '5', '10'),
786 ('12', '4', '10', '202', 'Maintenance', '0', '0', '5', '0', '0', '0', '11');
788 -- --------------------------------------------------------
791 -- Table structure for table `0_dimensions`
794 DROP TABLE IF EXISTS `0_dimensions`;
795 CREATE TABLE IF NOT EXISTS `0_dimensions` (
796 `id` int(11) NOT NULL AUTO_INCREMENT,
797 `reference` varchar(60) NOT NULL DEFAULT '',
798 `name` varchar(60) NOT NULL DEFAULT '',
799 `type_` tinyint(1) NOT NULL DEFAULT '1',
800 `closed` tinyint(1) NOT NULL DEFAULT '0',
801 `date_` date NOT NULL DEFAULT '0000-00-00',
802 `due_date` date NOT NULL DEFAULT '0000-00-00',
804 UNIQUE KEY `reference` (`reference`),
805 KEY `date_` (`date_`),
806 KEY `due_date` (`due_date`),
807 KEY `type_` (`type_`)
808 ) ENGINE=InnoDB AUTO_INCREMENT=2 ;
811 -- Dumping data for table `0_dimensions`
814 INSERT INTO `0_dimensions` VALUES ('1', '001/2015', 'Cost Centre', '1', '0', '2015-05-05', '2015-05-25');
816 -- --------------------------------------------------------
819 -- Table structure for table `0_exchange_rates`
822 DROP TABLE IF EXISTS `0_exchange_rates`;
823 CREATE TABLE IF NOT EXISTS `0_exchange_rates` (
824 `id` int(11) NOT NULL AUTO_INCREMENT,
825 `curr_code` char(3) NOT NULL DEFAULT '',
826 `rate_buy` double NOT NULL DEFAULT '0',
827 `rate_sell` double NOT NULL DEFAULT '0',
828 `date_` date NOT NULL DEFAULT '0000-00-00',
830 UNIQUE KEY `curr_code` (`curr_code`,`date_`)
831 ) ENGINE=InnoDB AUTO_INCREMENT=2 ;
834 -- Dumping data for table `0_exchange_rates`
837 INSERT INTO `0_exchange_rates` VALUES ('1', 'EUR', '1.123', '1.123', '2015-05-07');
839 -- --------------------------------------------------------
842 -- Table structure for table `0_fiscal_year`
845 DROP TABLE IF EXISTS `0_fiscal_year`;
846 CREATE TABLE IF NOT EXISTS `0_fiscal_year` (
847 `id` int(11) NOT NULL AUTO_INCREMENT,
848 `begin` date DEFAULT '0000-00-00',
849 `end` date DEFAULT '0000-00-00',
850 `closed` tinyint(1) NOT NULL DEFAULT '0',
852 UNIQUE KEY `begin` (`begin`),
853 UNIQUE KEY `end` (`end`)
854 ) ENGINE=InnoDB AUTO_INCREMENT=2 ;
857 -- Dumping data for table `0_fiscal_year`
860 INSERT INTO `0_fiscal_year` VALUES (1, '2015-01-01', '2015-12-31', 0);
862 -- --------------------------------------------------------
865 -- Table structure for table `0_gl_trans`
868 DROP TABLE IF EXISTS `0_gl_trans`;
869 CREATE TABLE IF NOT EXISTS `0_gl_trans` (
870 `counter` int(11) NOT NULL AUTO_INCREMENT,
871 `type` smallint(6) NOT NULL DEFAULT '0',
872 `type_no` int(11) NOT NULL DEFAULT '0',
873 `tran_date` date NOT NULL DEFAULT '0000-00-00',
874 `account` varchar(15) NOT NULL DEFAULT '',
875 `memo_` tinytext NOT NULL,
876 `amount` double NOT NULL DEFAULT '0',
877 `dimension_id` int(11) NOT NULL DEFAULT '0',
878 `dimension2_id` int(11) NOT NULL DEFAULT '0',
879 `person_type_id` int(11) DEFAULT NULL,
880 `person_id` tinyblob,
881 PRIMARY KEY (`counter`),
882 KEY `Type_and_Number` (`type`,`type_no`),
883 KEY `dimension_id` (`dimension_id`),
884 KEY `dimension2_id` (`dimension2_id`),
885 KEY `tran_date` (`tran_date`),
886 KEY `account_and_tran_date` (`account`,`tran_date`)
887 ) ENGINE=InnoDB AUTO_INCREMENT=39 ;
890 -- Dumping data for table `0_gl_trans`
893 INSERT INTO `0_gl_trans` VALUES
894 ('1', '25', '1', '2015-05-05', '1510', '101', '20000', '0', '0', NULL, NULL),
895 ('2', '25', '1', '2015-05-05', '1510', '102', '15000', '0', '0', NULL, NULL),
896 ('3', '25', '1', '2015-05-05', '1510', '103', '1000', '0', '0', NULL, NULL),
897 ('4', '25', '1', '2015-05-05', '1550', '', '-36000', '0', '0', NULL, NULL),
898 ('5', '13', '1', '2015-05-10', '5010', '', '4000', '0', '0', NULL, NULL),
899 ('6', '13', '1', '2015-05-10', '1510', '', '-4000', '0', '0', NULL, NULL),
900 ('7', '10', '1', '2015-05-10', '4010', '', '-5714.29', '0', '0', NULL, NULL),
901 ('8', '10', '1', '2015-05-10', '4010', '', '-228.57', '0', '0', NULL, NULL),
902 ('9', '10', '1', '2015-05-10', '1200', '', '6240', '0', '0', '2', '1'),
903 ('10', '10', '1', '2015-05-10', '2150', '', '-297.14', '0', '0', NULL, NULL),
904 ('11', '12', '1', '2015-05-10', '1065', '', '6240', '0', '0', NULL, NULL),
905 ('12', '12', '1', '2015-05-10', '1200', '', '-6240', '0', '0', '2', '1'),
906 ('13', '26', '1', '2015-05-05', '1510', '1 * iPad Air 2 16GB', '-400', '0', '0', NULL, NULL),
907 ('14', '26', '1', '2015-05-05', '1510', '1 * iPhone 6 64GB', '-300', '0', '0', NULL, NULL),
908 ('15', '26', '1', '2015-05-05', '1510', '1 * iPhone Cover Case', '-20', '0', '0', NULL, NULL),
909 ('16', '26', '1', '2015-05-05', '1510', 'Produced 2 * AP Surf Set', '720', '0', '0', NULL, NULL),
910 ('17', '25', '2', '2015-05-05', '1510', '101', '3000', '0', '0', NULL, NULL),
911 ('18', '25', '2', '2015-05-05', '1550', '', '-3000', '0', '0', NULL, NULL),
912 ('19', '20', '1', '2015-05-05', '2150', '', '150', '0', '0', NULL, NULL),
913 ('20', '20', '1', '2015-05-05', '2100', '', '-3150', '0', '0', '3', '1'),
914 ('21', '20', '1', '2015-05-05', '1550', '', '3000', '0', '0', NULL, NULL),
915 ('22', '13', '2', '2015-05-07', '5010', '', '200', '0', '0', NULL, NULL),
916 ('23', '13', '2', '2015-05-07', '1510', '', '-200', '0', '0', NULL, NULL),
917 ('24', '10', '2', '2015-05-07', '4010', '', '-285.71', '0', '0', NULL, NULL),
918 ('25', '10', '2', '2015-05-07', '1200', '', '300', '0', '0', '2', '1'),
919 ('26', '10', '2', '2015-05-07', '2150', '', '-14.29', '0', '0', NULL, NULL),
920 ('27', '12', '2', '2015-05-07', '1065', '', '300', '0', '0', NULL, NULL),
921 ('28', '12', '2', '2015-05-07', '1200', '', '-300', '0', '0', '2', '1'),
922 ('29', '13', '3', '2015-05-07', '5010', '', '150', '1', '0', NULL, NULL),
923 ('30', '13', '3', '2015-05-07', '1510', '', '-150', '0', '0', NULL, NULL),
924 ('31', '13', '3', '2015-05-07', '5010', '', '10', '1', '0', NULL, NULL),
925 ('32', '13', '3', '2015-05-07', '1510', '', '-10', '0', '0', NULL, NULL),
926 ('33', '10', '3', '2015-05-07', '4010', '', '-250', '1', '0', NULL, NULL),
927 ('34', '10', '3', '2015-05-07', '4010', '', '-50', '1', '0', NULL, NULL),
928 ('35', '10', '3', '2015-05-07', '1200', '', '300', '0', '0', '2', '2'),
929 ('36', '12', '3', '2015-05-07', '1065', '', '0', '0', '0', NULL, NULL),
930 ('37', '1', '1', '2015-05-07', '5010', '', '5', '1', '0', NULL, NULL),
931 ('38', '1', '1', '2015-05-07', '1060', '', '-5', '0', '0', NULL, NULL);
933 -- --------------------------------------------------------
936 -- Table structure for table `0_grn_batch`
939 DROP TABLE IF EXISTS `0_grn_batch`;
940 CREATE TABLE IF NOT EXISTS `0_grn_batch` (
941 `id` int(11) NOT NULL AUTO_INCREMENT,
942 `supplier_id` int(11) NOT NULL DEFAULT '0',
943 `purch_order_no` int(11) DEFAULT NULL,
944 `reference` varchar(60) NOT NULL DEFAULT '',
945 `delivery_date` date NOT NULL DEFAULT '0000-00-00',
946 `loc_code` varchar(5) DEFAULT NULL,
947 `rate` double DEFAULT '1',
949 KEY `delivery_date` (`delivery_date`),
950 KEY `purch_order_no` (`purch_order_no`)
951 ) ENGINE=InnoDB AUTO_INCREMENT=3 ;
954 -- Dumping data for table `0_grn_batch`
957 INSERT INTO `0_grn_batch` VALUES
958 ('1', '1', '1', '001/2015', '2015-05-05', 'DEF', '1'),
959 ('2', '1', '2', 'auto', '2015-05-05', 'DEF', '1');
961 -- --------------------------------------------------------
964 -- Table structure for table `0_grn_items`
967 DROP TABLE IF EXISTS `0_grn_items`;
968 CREATE TABLE IF NOT EXISTS `0_grn_items` (
969 `id` int(11) NOT NULL AUTO_INCREMENT,
970 `grn_batch_id` int(11) DEFAULT NULL,
971 `po_detail_item` int(11) NOT NULL DEFAULT '0',
972 `item_code` varchar(20) NOT NULL DEFAULT '',
973 `description` tinytext,
974 `qty_recd` double NOT NULL DEFAULT '0',
975 `quantity_inv` double NOT NULL DEFAULT '0',
977 KEY `grn_batch_id` (`grn_batch_id`)
978 ) ENGINE=InnoDB AUTO_INCREMENT=5 ;
981 -- Dumping data for table `0_grn_items`
984 INSERT INTO `0_grn_items` VALUES
985 ('1', '1', '1', '101', 'iPad Air 2 16GB', '100', '0'),
986 ('2', '1', '2', '102', 'iPhone 6 64GB', '100', '0'),
987 ('3', '1', '3', '103', 'iPhone Cover Case', '100', '0'),
988 ('4', '2', '4', '101', 'iPad Air 2 16GB', '15', '15');
990 -- --------------------------------------------------------
993 -- Table structure for table `0_groups`
996 DROP TABLE IF EXISTS `0_groups`;
997 CREATE TABLE IF NOT EXISTS `0_groups` (
998 `id` smallint(6) unsigned NOT NULL AUTO_INCREMENT,
999 `description` varchar(60) NOT NULL DEFAULT '',
1000 `inactive` tinyint(1) NOT NULL DEFAULT '0',
1002 UNIQUE KEY `description` (`description`)
1003 ) ENGINE=InnoDB AUTO_INCREMENT=4 ;
1006 -- Dumping data for table `0_groups`
1009 INSERT INTO `0_groups` VALUES (1, 'Small', 0);
1010 INSERT INTO `0_groups` VALUES (2, 'Medium', 0);
1011 INSERT INTO `0_groups` VALUES (3, 'Large', 0);
1013 -- --------------------------------------------------------
1016 -- Table structure for table `0_item_codes`
1019 DROP TABLE IF EXISTS `0_item_codes`;
1020 CREATE TABLE IF NOT EXISTS `0_item_codes` (
1021 `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
1022 `item_code` varchar(20) NOT NULL,
1023 `stock_id` varchar(20) NOT NULL,
1024 `description` varchar(200) NOT NULL DEFAULT '',
1025 `category_id` smallint(6) unsigned NOT NULL,
1026 `quantity` double NOT NULL DEFAULT '1',
1027 `is_foreign` tinyint(1) NOT NULL DEFAULT '0',
1028 `inactive` tinyint(1) NOT NULL DEFAULT '0',
1030 UNIQUE KEY `stock_id` (`stock_id`,`item_code`),
1031 KEY `item_code` (`item_code`)
1032 ) ENGINE=InnoDB AUTO_INCREMENT=9 ;
1035 -- Dumping data for table `0_item_codes`
1038 INSERT INTO `0_item_codes` VALUES
1039 ('1', '101', '101', 'iPad Air 2 16GB', '1', '1', '0', '0'),
1040 ('2', '102', '102', 'iPhone 6 64GB', '1', '1', '0', '0'),
1041 ('3', '103', '103', 'iPhone Cover Case', '1', '1', '0', '0'),
1042 ('4', '201', '201', 'AP Surf Set', '3', '1', '0', '0'),
1043 ('5', '301', '301', 'Support', '4', '1', '0', '0'),
1044 ('6', '501', '102', 'iPhone Pack', '1', '1', '0', '0'),
1045 ('7', '501', '103', 'iPhone Pack', '1', '1', '0', '0'),
1046 ('8', '202', '202', 'Maintenance', '4', '1', '0', '0');
1048 -- --------------------------------------------------------
1051 -- Table structure for table `0_item_tax_types`
1054 DROP TABLE IF EXISTS `0_item_tax_types`;
1055 CREATE TABLE IF NOT EXISTS `0_item_tax_types` (
1056 `id` int(11) NOT NULL auto_increment,
1057 `name` varchar(60) NOT NULL default '',
1058 `exempt` tinyint(1) NOT NULL default '0',
1059 `inactive` tinyint(1) NOT NULL default '0',
1061 UNIQUE KEY `name` (`name`)
1062 ) ENGINE=InnoDB AUTO_INCREMENT=2 ;
1065 -- Dumping data for table `0_item_tax_types`
1068 INSERT INTO `0_item_tax_types` VALUES (1, 'Regular', 0, 0);
1070 -- --------------------------------------------------------
1073 -- Table structure for table `0_item_tax_type_exemptions`
1076 DROP TABLE IF EXISTS `0_item_tax_type_exemptions`;
1077 CREATE TABLE IF NOT EXISTS `0_item_tax_type_exemptions` (
1078 `item_tax_type_id` int(11) NOT NULL DEFAULT '0',
1079 `tax_type_id` int(11) NOT NULL DEFAULT '0',
1080 PRIMARY KEY (`item_tax_type_id`,`tax_type_id`)
1084 -- Dumping data for table `0_item_tax_type_exemptions`
1087 -- --------------------------------------------------------
1090 -- Table structure for table `0_item_units`
1093 DROP TABLE IF EXISTS `0_item_units`;
1094 CREATE TABLE IF NOT EXISTS `0_item_units` (
1095 `abbr` varchar(20) NOT NULL,
1096 `name` varchar(40) NOT NULL,
1097 `decimals` tinyint(2) NOT NULL,
1098 `inactive` tinyint(1) NOT NULL DEFAULT '0',
1099 PRIMARY KEY (`abbr`),
1100 UNIQUE KEY `name` (`name`)
1104 -- Dumping data for table `0_item_units`
1107 INSERT INTO `0_item_units` VALUES ('each', 'Each', 0, 0);
1108 INSERT INTO `0_item_units` VALUES ('hr', 'Hours', 0, 0);
1110 -- --------------------------------------------------------
1113 -- Table structure for table `0_journal`
1116 DROP TABLE IF EXISTS `0_journal`;
1117 CREATE TABLE `0_journal` (
1118 `type` smallint(6) NOT NULL DEFAULT '0',
1119 `trans_no` int(11) NOT NULL DEFAULT '0',
1120 `tran_date` date DEFAULT '0000-00-00',
1121 `reference` varchar(60) NOT NULL DEFAULT '',
1122 `source_ref` varchar(60) NOT NULL DEFAULT '',
1123 `event_date` date DEFAULT '0000-00-00',
1124 `doc_date` date NOT NULL DEFAULT '0000-00-00',
1125 `currency` char(3) NOT NULL DEFAULT '',
1126 `amount` double NOT NULL DEFAULT '0',
1127 `rate` double NOT NULL DEFAULT '1',
1128 PRIMARY KEY (`type`,`trans_no`),
1129 KEY `tran_date` (`tran_date`)
1133 -- Dumping data for table `0_journal`
1136 -- --------------------------------------------------------
1139 -- Table structure for table `0_locations`
1142 DROP TABLE IF EXISTS `0_locations`;
1143 CREATE TABLE IF NOT EXISTS `0_locations` (
1144 `loc_code` varchar(5) NOT NULL DEFAULT '',
1145 `location_name` varchar(60) NOT NULL DEFAULT '',
1146 `delivery_address` tinytext NOT NULL,
1147 `phone` varchar(30) NOT NULL DEFAULT '',
1148 `phone2` varchar(30) NOT NULL DEFAULT '',
1149 `fax` varchar(30) NOT NULL DEFAULT '',
1150 `email` varchar(100) NOT NULL DEFAULT '',
1151 `contact` varchar(30) NOT NULL DEFAULT '',
1152 `fixed_asset` tinyint(1) NOT NULL DEFAULT '0',
1153 `inactive` tinyint(1) NOT NULL DEFAULT '0',
1154 PRIMARY KEY (`loc_code`)
1158 -- Dumping data for table `0_locations`
1161 INSERT INTO `0_locations` VALUES ('DEF', 'Default', 'N/A', '', '', '', '', '', 0, 0);
1163 -- --------------------------------------------------------
1166 -- Table structure for table `0_loc_stock`
1169 DROP TABLE IF EXISTS `0_loc_stock`;
1170 CREATE TABLE IF NOT EXISTS `0_loc_stock` (
1171 `loc_code` char(5) NOT NULL DEFAULT '',
1172 `stock_id` char(20) NOT NULL DEFAULT '',
1173 `reorder_level` double NOT NULL DEFAULT '0',
1174 PRIMARY KEY (`loc_code`,`stock_id`),
1175 KEY `stock_id` (`stock_id`)
1179 -- Dumping data for table `0_loc_stock`
1182 INSERT INTO `0_loc_stock` VALUES
1183 ('DEF', '101', '0'),
1184 ('DEF', '102', '0'),
1185 ('DEF', '103', '0'),
1186 ('DEF', '201', '0'),
1187 ('DEF', '202', '0'),
1188 ('DEF', '301', '0');
1190 -- --------------------------------------------------------
1193 -- Table structure for table `0_payment_terms`
1196 DROP TABLE IF EXISTS `0_payment_terms`;
1197 CREATE TABLE IF NOT EXISTS `0_payment_terms` (
1198 `terms_indicator` int(11) NOT NULL AUTO_INCREMENT,
1199 `terms` char(80) NOT NULL DEFAULT '',
1200 `days_before_due` smallint(6) NOT NULL DEFAULT '0',
1201 `day_in_following_month` smallint(6) NOT NULL DEFAULT '0',
1202 `inactive` tinyint(1) NOT NULL DEFAULT '0',
1203 PRIMARY KEY (`terms_indicator`),
1204 UNIQUE KEY `terms` (`terms`)
1205 ) ENGINE=InnoDB AUTO_INCREMENT=5 ;
1208 -- Dumping data for table `0_payment_terms`
1211 INSERT INTO `0_payment_terms` VALUES (1, 'Due 15th Of the Following Month', 0, 17, 0);
1212 INSERT INTO `0_payment_terms` VALUES (2, 'Due By End Of The Following Month', 0, 30, 0);
1213 INSERT INTO `0_payment_terms` VALUES (3, 'Payment due within 10 days', 10, 0, 0);
1214 INSERT INTO `0_payment_terms` VALUES (4, 'Cash Only', 0, 0, 0);
1216 -- --------------------------------------------------------
1219 -- Table structure for table `0_prices`
1222 DROP TABLE IF EXISTS `0_prices`;
1223 CREATE TABLE IF NOT EXISTS `0_prices` (
1224 `id` int(11) NOT NULL AUTO_INCREMENT,
1225 `stock_id` varchar(20) NOT NULL DEFAULT '',
1226 `sales_type_id` int(11) NOT NULL DEFAULT '0',
1227 `curr_abrev` char(3) NOT NULL DEFAULT '',
1228 `price` double NOT NULL DEFAULT '0',
1230 UNIQUE KEY `price` (`stock_id`,`sales_type_id`,`curr_abrev`)
1231 ) ENGINE=InnoDB AUTO_INCREMENT=4 ;
1234 -- Dumping data for table `0_prices`
1237 INSERT INTO `0_prices` VALUES
1238 ('1', '101', '1', 'USD', '300'),
1239 ('2', '102', '1', 'USD', '250'),
1240 ('3', '103', '1', 'USD', '50');
1242 -- --------------------------------------------------------
1245 -- Table structure for table `0_printers`
1248 DROP TABLE IF EXISTS `0_printers`;
1249 CREATE TABLE IF NOT EXISTS `0_printers` (
1250 `id` tinyint(3) unsigned NOT NULL AUTO_INCREMENT,
1251 `name` varchar(20) NOT NULL,
1252 `description` varchar(60) NOT NULL,
1253 `queue` varchar(20) NOT NULL,
1254 `host` varchar(40) NOT NULL,
1255 `port` smallint(11) unsigned NOT NULL,
1256 `timeout` tinyint(3) unsigned NOT NULL,
1258 UNIQUE KEY `name` (`name`)
1259 ) ENGINE=InnoDB AUTO_INCREMENT=4 ;
1262 -- Dumping data for table `0_printers`
1265 INSERT INTO `0_printers` VALUES (1, 'QL500', 'Label printer', 'QL500', 'server', 127, 20);
1266 INSERT INTO `0_printers` VALUES (2, 'Samsung', 'Main network printer', 'scx4521F', 'server', 515, 5);
1267 INSERT INTO `0_printers` VALUES (3, 'Local', 'Local print server at user IP', 'lp', '', 515, 10);
1269 -- --------------------------------------------------------
1272 -- Table structure for table `0_print_profiles`
1275 DROP TABLE IF EXISTS `0_print_profiles`;
1276 CREATE TABLE IF NOT EXISTS `0_print_profiles` (
1277 `id` smallint(6) unsigned NOT NULL AUTO_INCREMENT,
1278 `profile` varchar(30) NOT NULL,
1279 `report` varchar(5) DEFAULT NULL,
1280 `printer` tinyint(3) unsigned DEFAULT NULL,
1282 UNIQUE KEY `profile` (`profile`,`report`)
1283 ) ENGINE=InnoDB AUTO_INCREMENT=10 ;
1286 -- Dumping data for table `0_print_profiles`
1289 INSERT INTO `0_print_profiles` VALUES (1, 'Out of office', '', 0);
1290 INSERT INTO `0_print_profiles` VALUES (2, 'Sales Department', '', 0);
1291 INSERT INTO `0_print_profiles` VALUES (3, 'Central', '', 2);
1292 INSERT INTO `0_print_profiles` VALUES (4, 'Sales Department', '104', 2);
1293 INSERT INTO `0_print_profiles` VALUES (5, 'Sales Department', '105', 2);
1294 INSERT INTO `0_print_profiles` VALUES (6, 'Sales Department', '107', 2);
1295 INSERT INTO `0_print_profiles` VALUES (7, 'Sales Department', '109', 2);
1296 INSERT INTO `0_print_profiles` VALUES (8, 'Sales Department', '110', 2);
1297 INSERT INTO `0_print_profiles` VALUES (9, 'Sales Department', '201', 2);
1299 -- --------------------------------------------------------
1302 -- Table structure for table `0_purch_data`
1305 DROP TABLE IF EXISTS `0_purch_data`;
1306 CREATE TABLE IF NOT EXISTS `0_purch_data` (
1307 `supplier_id` int(11) NOT NULL DEFAULT '0',
1308 `stock_id` char(20) NOT NULL DEFAULT '',
1309 `price` double NOT NULL DEFAULT '0',
1310 `suppliers_uom` char(50) NOT NULL DEFAULT '',
1311 `conversion_factor` double NOT NULL DEFAULT '1',
1312 `supplier_description` char(50) NOT NULL DEFAULT '',
1313 PRIMARY KEY (`supplier_id`,`stock_id`)
1317 -- Dumping data for table `0_purch_data`
1320 INSERT INTO `0_purch_data` VALUES
1321 ('1', '101', '200', '', '1', 'iPad Air 2 16GB'),
1322 ('1', '102', '150', '', '1', 'iPhone 6 64GB'),
1323 ('1', '103', '10', '', '1', 'iPhone Cover Case');
1325 -- --------------------------------------------------------
1328 -- Table structure for table `0_purch_orders`
1331 DROP TABLE IF EXISTS `0_purch_orders`;
1332 CREATE TABLE IF NOT EXISTS `0_purch_orders` (
1333 `order_no` int(11) NOT NULL AUTO_INCREMENT,
1334 `supplier_id` int(11) NOT NULL DEFAULT '0',
1335 `comments` tinytext,
1336 `ord_date` date NOT NULL DEFAULT '0000-00-00',
1337 `reference` tinytext NOT NULL,
1338 `requisition_no` tinytext,
1339 `into_stock_location` varchar(5) NOT NULL DEFAULT '',
1340 `delivery_address` tinytext NOT NULL,
1341 `total` double NOT NULL DEFAULT '0',
1342 `prep_amount` double NOT NULL DEFAULT '0',
1343 `alloc` double NOT NULL DEFAULT '0',
1344 `tax_included` tinyint(1) NOT NULL DEFAULT '0',
1345 PRIMARY KEY (`order_no`),
1346 KEY `ord_date` (`ord_date`)
1347 ) ENGINE=InnoDB AUTO_INCREMENT=3 ;
1350 -- Dumping data for table `0_purch_orders`
1353 INSERT INTO `0_purch_orders` VALUES
1354 ('1', '1', NULL, '2015-05-05', '001/2015', NULL, 'DEF', 'N/A', '37800', '0', '0', '0'),
1355 ('2', '1', NULL, '2015-05-05', 'auto', 'rr4', 'DEF', 'N/A', '3150', '0', '0', '0');
1357 -- --------------------------------------------------------
1360 -- Table structure for table `0_purch_order_details`
1363 DROP TABLE IF EXISTS `0_purch_order_details`;
1364 CREATE TABLE IF NOT EXISTS `0_purch_order_details` (
1365 `po_detail_item` int(11) NOT NULL AUTO_INCREMENT,
1366 `order_no` int(11) NOT NULL DEFAULT '0',
1367 `item_code` varchar(20) NOT NULL DEFAULT '',
1368 `description` tinytext,
1369 `delivery_date` date NOT NULL DEFAULT '0000-00-00',
1370 `qty_invoiced` double NOT NULL DEFAULT '0',
1371 `unit_price` double NOT NULL DEFAULT '0',
1372 `act_price` double NOT NULL DEFAULT '0',
1373 `std_cost_unit` double NOT NULL DEFAULT '0',
1374 `quantity_ordered` double NOT NULL DEFAULT '0',
1375 `quantity_received` double NOT NULL DEFAULT '0',
1376 PRIMARY KEY (`po_detail_item`),
1377 KEY `order` (`order_no`,`po_detail_item`),
1378 KEY `itemcode` (`item_code`)
1379 ) ENGINE=InnoDB AUTO_INCREMENT=5 ;
1382 -- Dumping data for table `0_purch_order_details`
1385 INSERT INTO `0_purch_order_details` VALUES
1386 ('1', '1', '101', 'iPad Air 2 16GB', '2015-05-15', '0', '200', '200', '200', '100', '100'),
1387 ('2', '1', '102', 'iPhone 6 64GB', '2015-05-15', '0', '150', '150', '150', '100', '100'),
1388 ('3', '1', '103', 'iPhone Cover Case', '2015-05-15', '0', '10', '10', '10', '100', '100'),
1389 ('4', '2', '101', 'iPad Air 2 16GB', '2015-05-05', '15', '200', '200', '200', '15', '15');
1391 -- --------------------------------------------------------
1394 -- Table structure for table `0_quick_entries`
1397 DROP TABLE IF EXISTS `0_quick_entries`;
1398 CREATE TABLE IF NOT EXISTS `0_quick_entries` (
1399 `id` smallint(6) unsigned NOT NULL AUTO_INCREMENT,
1400 `type` tinyint(1) NOT NULL DEFAULT '0',
1401 `description` varchar(60) NOT NULL,
1402 `usage` varchar(120) NULL,
1403 `base_amount` double NOT NULL DEFAULT '0',
1404 `base_desc` varchar(60) DEFAULT NULL,
1405 `bal_type` tinyint(1) NOT NULL DEFAULT '0',
1407 KEY `description` (`description`)
1408 ) ENGINE=InnoDB AUTO_INCREMENT=4 ;
1411 -- Dumping data for table `0_quick_entries`
1414 INSERT INTO `0_quick_entries` VALUES (1, 1, 'Maintenance', NULL, 0, 'Amount', 0);
1415 INSERT INTO `0_quick_entries` VALUES (2, 4, 'Phone', NULL, 0, 'Amount', 0);
1416 INSERT INTO `0_quick_entries` VALUES (3, 2, 'Cash Sales', 'Retail sales without invoice', 0, 'Amount', 0);
1418 -- --------------------------------------------------------
1421 -- Table structure for table `0_quick_entry_lines`
1424 DROP TABLE IF EXISTS `0_quick_entry_lines`;
1425 CREATE TABLE IF NOT EXISTS `0_quick_entry_lines` (
1426 `id` smallint(6) unsigned NOT NULL AUTO_INCREMENT,
1427 `qid` smallint(6) unsigned NOT NULL,
1428 `amount` double DEFAULT '0',
1429 `memo` tinytext NOT NULL,
1430 `action` varchar(2) NOT NULL,
1431 `dest_id` varchar(15) NOT NULL DEFAULT '',
1432 `dimension_id` smallint(6) unsigned DEFAULT NULL,
1433 `dimension2_id` smallint(6) unsigned DEFAULT NULL,
1436 ) ENGINE=InnoDB AUTO_INCREMENT=7 ;
1439 -- Dumping data for table `0_quick_entry_lines`
1442 INSERT INTO `0_quick_entry_lines` VALUES (1, 1, 0, '', 't-', '1', 0, 0);
1443 INSERT INTO `0_quick_entry_lines` VALUES (2, 2, 0, '', 't-', '1', 0, 0);
1444 INSERT INTO `0_quick_entry_lines` VALUES (3, 3, 0, '', 't-', '1', 0, 0);
1445 INSERT INTO `0_quick_entry_lines` VALUES (4, 3, 0, '', '=', '4010', 0, 0);
1446 INSERT INTO `0_quick_entry_lines` VALUES (5, 1, 0, '', '=', '5765', 0, 0);
1447 INSERT INTO `0_quick_entry_lines` VALUES (6, 2, 0, '', '=', '5780', 0, 0);
1449 -- --------------------------------------------------------
1452 -- Table structure for table `0_recurrent_invoices`
1455 DROP TABLE IF EXISTS `0_recurrent_invoices`;
1456 CREATE TABLE IF NOT EXISTS `0_recurrent_invoices` (
1457 `id` smallint(6) unsigned NOT NULL AUTO_INCREMENT,
1458 `description` varchar(60) NOT NULL DEFAULT '',
1459 `order_no` int(11) unsigned NOT NULL,
1460 `debtor_no` int(11) unsigned DEFAULT NULL,
1461 `group_no` smallint(6) unsigned DEFAULT NULL,
1462 `days` int(11) NOT NULL DEFAULT '0',
1463 `monthly` int(11) NOT NULL DEFAULT '0',
1464 `begin` date NOT NULL DEFAULT '0000-00-00',
1465 `end` date NOT NULL DEFAULT '0000-00-00',
1466 `last_sent` date NOT NULL DEFAULT '0000-00-00',
1468 UNIQUE KEY `description` (`description`)
1469 ) ENGINE=InnoDB AUTO_INCREMENT=2 ;
1472 -- Dumping data for table `0_recurrent_invoices`
1475 INSERT INTO `0_recurrent_invoices` VALUES ('1', 'Weekly Maintenance', '6', '1', '1', '7', '0', '2015-04-01', '2020-05-07', '2015-04-08');
1477 -- --------------------------------------------------------
1480 --- Table structure for table `0_reflines`
1483 DROP TABLE IF EXISTS `0_reflines`;
1485 CREATE TABLE `0_reflines` (
1486 `id` int(11) NOT NULL AUTO_INCREMENT,
1487 `trans_type` int(11) NOT NULL,
1488 `prefix` char(5) NOT NULL DEFAULT '',
1489 `pattern` varchar(35) NOT NULL DEFAULT '1',
1490 `description` varchar(60) NOT NULL DEFAULT '',
1491 `default` tinyint(1) NOT NULL DEFAULT '0',
1492 `inactive` tinyint(1) NOT NULL DEFAULT '0',
1494 UNIQUE KEY `prefix` (`trans_type`, `prefix`)
1495 ) ENGINE=InnoDB AUTO_INCREMENT=23;
1498 --- Dumping data for table `0_reflines`
1501 INSERT INTO `0_reflines` VALUES
1502 ('1', '0', '', '{001}/{YYYY}', '', '1', '0'),
1503 ('2', '1', '', '{001}/{YYYY}', '', '1', '0'),
1504 ('3', '2', '', '{001}/{YYYY}', '', '1', '0'),
1505 ('4', '4', '', '{001}/{YYYY}', '', '1', '0'),
1506 ('5', '10', '', '{001}/{YYYY}', '', '1', '0'),
1507 ('6', '11', '', '{001}/{YYYY}', '', '1', '0'),
1508 ('7', '12', '', '{001}/{YYYY}', '', '1', '0'),
1509 ('8', '13', '', '{001}/{YYYY}', '', '1', '0'),
1510 ('9', '16', '', '{001}/{YYYY}', '', '1', '0'),
1511 ('10', '17', '', '{001}/{YYYY}', '', '1', '0'),
1512 ('11', '18', '', '{001}/{YYYY}', '', '1', '0'),
1513 ('12', '20', '', '{001}/{YYYY}', '', '1', '0'),
1514 ('13', '21', '', '{001}/{YYYY}', '', '1', '0'),
1515 ('14', '22', '', '{001}/{YYYY}', '', '1', '0'),
1516 ('15', '25', '', '{001}/{YYYY}', '', '1', '0'),
1517 ('16', '26', '', '{001}/{YYYY}', '', '1', '0'),
1518 ('17', '28', '', '{001}/{YYYY}', '', '1', '0'),
1519 ('18', '29', '', '{001}/{YYYY}', '', '1', '0'),
1520 ('19', '30', '', '{001}/{YYYY}', '', '1', '0'),
1521 ('20', '32', '', '{001}/{YYYY}', '', '1', '0'),
1522 ('21', '35', '', '{001}/{YYYY}', '', '1', '0'),
1523 ('22', '40', '', '{001}/{YYYY}', '', '1', '0');
1525 -- --------------------------------------------------------
1528 -- Table structure for table `0_refs`
1531 DROP TABLE IF EXISTS `0_refs`;
1532 CREATE TABLE IF NOT EXISTS `0_refs` (
1533 `id` int(11) NOT NULL DEFAULT '0',
1534 `type` int(11) NOT NULL DEFAULT '0',
1535 `reference` varchar(100) NOT NULL DEFAULT '',
1536 PRIMARY KEY (`id`,`type`),
1537 KEY `Type_and_Reference` (`type`,`reference`)
1541 -- Dumping data for table `0_refs`
1544 INSERT INTO `0_refs` VALUES
1545 ('1', '1', '001/2015'),
1546 ('1', '10', '001/2015'),
1547 ('2', '10', '002/2015'),
1548 ('3', '10', '003/2015'),
1549 ('4', '10', '004/2015'),
1550 ('1', '12', '001/2015'),
1551 ('2', '12', '002/2015'),
1552 ('3', '12', '003/2015'),
1553 ('1', '18', '001/2015'),
1554 ('1', '20', '001/2015'),
1555 ('1', '25', '001/2015'),
1556 ('1', '26', '001/2015'),
1557 ('2', '26', '002/2015'),
1558 ('3', '26', '003/2015'),
1559 ('3', '30', '001/2015'),
1560 ('4', '30', '002/2015'),
1561 ('6', '30', '003/2015'),
1562 ('1', '40', '001/2015');
1564 -- --------------------------------------------------------
1567 -- Table structure for table `0_salesman`
1570 DROP TABLE IF EXISTS `0_salesman`;
1571 CREATE TABLE IF NOT EXISTS `0_salesman` (
1572 `salesman_code` int(11) NOT NULL AUTO_INCREMENT,
1573 `salesman_name` char(60) NOT NULL DEFAULT '',
1574 `salesman_phone` char(30) NOT NULL DEFAULT '',
1575 `salesman_fax` char(30) NOT NULL DEFAULT '',
1576 `salesman_email` varchar(100) NOT NULL DEFAULT '',
1577 `provision` double NOT NULL DEFAULT '0',
1578 `break_pt` double NOT NULL DEFAULT '0',
1579 `provision2` double NOT NULL DEFAULT '0',
1580 `inactive` tinyint(1) NOT NULL DEFAULT '0',
1581 PRIMARY KEY (`salesman_code`),
1582 UNIQUE KEY `salesman_name` (`salesman_name`)
1583 ) ENGINE=InnoDB AUTO_INCREMENT=2 ;
1586 -- Dumping data for table `0_salesman`
1589 INSERT INTO `0_salesman` VALUES (1, 'Sales Person', '', '', '', 5, 1000, 4, 0);
1591 -- --------------------------------------------------------
1594 -- Table structure for table `0_sales_orders`
1597 DROP TABLE IF EXISTS `0_sales_orders`;
1598 CREATE TABLE IF NOT EXISTS `0_sales_orders` (
1599 `order_no` int(11) NOT NULL,
1600 `trans_type` smallint(6) NOT NULL DEFAULT '30',
1601 `version` tinyint(1) unsigned NOT NULL DEFAULT '0',
1602 `type` tinyint(1) NOT NULL DEFAULT '0',
1603 `debtor_no` int(11) NOT NULL DEFAULT '0',
1604 `branch_code` int(11) NOT NULL DEFAULT '0',
1605 `reference` varchar(100) NOT NULL DEFAULT '',
1606 `customer_ref` tinytext NOT NULL,
1607 `comments` tinytext,
1608 `ord_date` date NOT NULL DEFAULT '0000-00-00',
1609 `order_type` int(11) NOT NULL DEFAULT '0',
1610 `ship_via` int(11) NOT NULL DEFAULT '0',
1611 `delivery_address` tinytext NOT NULL,
1612 `contact_phone` varchar(30) DEFAULT NULL,
1613 `contact_email` varchar(100) DEFAULT NULL,
1614 `deliver_to` tinytext NOT NULL,
1615 `freight_cost` double NOT NULL DEFAULT '0',
1616 `from_stk_loc` varchar(5) NOT NULL DEFAULT '',
1617 `delivery_date` date NOT NULL DEFAULT '0000-00-00',
1618 `payment_terms` int(11) DEFAULT NULL,
1619 `total` double NOT NULL DEFAULT '0',
1620 `prep_amount` double NOT NULL DEFAULT '0',
1621 `alloc` double NOT NULL DEFAULT '0',
1622 PRIMARY KEY (`trans_type`,`order_no`)
1626 -- Dumping data for table `0_sales_orders`
1629 INSERT INTO `0_sales_orders` VALUES
1630 ('1', '30', '1', '0', '1', '1', 'auto', '', NULL, '2015-05-10', '1', '1', 'N/A', NULL, NULL, 'Donald Easter LLC', '0', 'DEF', '2015-05-05', '4', '6240', '0', '0'),
1631 ('2', '30', '1', '0', '1', '1', 'auto', '', NULL, '2015-05-07', '1', '1', 'N/A', NULL, NULL, 'Donald Easter LLC', '0', 'DEF', '2015-05-07', '4', '300', '0', '0'),
1632 ('3', '30', '0', '0', '1', '1', '001/2015', '', NULL, '2015-05-07', '1', '1', 'N/A', NULL, NULL, 'Donald Easter LLC', '0', 'DEF', '2015-05-08', '4', '300', '0', '0'),
1633 ('4', '30', '0', '0', '2', '2', '002/2015', '', NULL, '2015-05-07', '1', '1', 'N/A', NULL, NULL, 'MoneyMaker Ltd.', '0', 'DEF', '2015-05-08', '1', '267.14', '0', '0'),
1634 ('5', '30', '1', '0', '2', '2', 'auto', '', NULL, '2015-05-07', '1', '1', 'N/A', NULL, NULL, 'MoneyMaker Ltd.', '0', 'DEF', '2015-06-17', '1', '267.14', '0', '0'),
1635 ('6', '30', '0', '1', '1', '1', '003/2015', '', NULL, '2015-05-07', '1', '1', 'N/A', NULL, NULL, 'Donald Easter LLC', '0', 'DEF', '2015-05-08', '4', '450', '0', '0'),
1636 ('7', '30', '1', '0', '1', '1', 'auto', '', 'Recurrent Invoice covers period 04/01/2015 - 04/07/2015.', '2015-05-07', '1', '1', 'N/A', NULL, NULL, 'Donald Easter LLC', '0', 'DEF', '2015-05-07', '4', '0', '0', '0');
1638 -- --------------------------------------------------------
1641 -- Table structure for table `0_sales_order_details`
1644 DROP TABLE IF EXISTS `0_sales_order_details`;
1645 CREATE TABLE IF NOT EXISTS `0_sales_order_details` (
1646 `id` int(11) NOT NULL AUTO_INCREMENT,
1647 `order_no` int(11) NOT NULL DEFAULT '0',
1648 `trans_type` smallint(6) NOT NULL DEFAULT '30',
1649 `stk_code` varchar(20) NOT NULL DEFAULT '',
1650 `description` tinytext,
1651 `qty_sent` double NOT NULL DEFAULT '0',
1652 `unit_price` double NOT NULL DEFAULT '0',
1653 `quantity` double NOT NULL DEFAULT '0',
1654 `invoiced` double NOT NULL DEFAULT '0',
1655 `discount_percent` double NOT NULL DEFAULT '0',
1657 KEY `sorder` (`trans_type`,`order_no`),
1658 KEY `stkcode` (`stk_code`)
1659 ) ENGINE=InnoDB AUTO_INCREMENT=11 ;
1662 -- Dumping data for table `0_sales_order_details`
1665 INSERT INTO `0_sales_order_details` VALUES
1666 ('1', '1', '30', '101', 'iPad Air 2 16GB', '20', '300', '20', '0', '0'),
1667 ('2', '1', '30', '301', 'Support', '3', '80', '3', '0', '0'),
1668 ('3', '2', '30', '101', 'iPad Air 2 16GB', '1', '300', '1', '0', '0'),
1669 ('4', '3', '30', '102', 'iPhone 6 64GB', '0', '250', '1', '0', '0'),
1670 ('5', '3', '30', '103', 'iPhone Cover Case', '0', '50', '1', '0', '0'),
1671 ('6', '4', '30', '101', 'iPad Air 2 16GB', '0', '267.14', '1', '0', '0'),
1672 ('7', '5', '30', '102', 'iPhone 6 64GB', '1', '222.62', '1', '0', '0'),
1673 ('8', '5', '30', '103', 'iPhone Cover Case', '1', '44.52', '1', '0', '0'),
1674 ('9', '6', '30', '202', 'Maintenance', '0', '90', '5', '0', '0'),
1675 ('10', '7', '30', '202', 'Maintenance', '5', '0', '5', '0', '0');
1677 -- --------------------------------------------------------
1680 -- Table structure for table `0_sales_pos`
1683 DROP TABLE IF EXISTS `0_sales_pos`;
1684 CREATE TABLE IF NOT EXISTS `0_sales_pos` (
1685 `id` smallint(6) unsigned NOT NULL AUTO_INCREMENT,
1686 `pos_name` varchar(30) NOT NULL,
1687 `cash_sale` tinyint(1) NOT NULL,
1688 `credit_sale` tinyint(1) NOT NULL,
1689 `pos_location` varchar(5) NOT NULL,
1690 `pos_account` smallint(6) unsigned NOT NULL,
1691 `inactive` tinyint(1) NOT NULL DEFAULT '0',
1693 UNIQUE KEY `pos_name` (`pos_name`)
1694 ) ENGINE=InnoDB AUTO_INCREMENT=2 ;
1697 -- Dumping data for table `0_sales_pos`
1700 INSERT INTO `0_sales_pos` VALUES (1, 'Default', 1, 1, 'DEF', 2, 0);
1702 -- --------------------------------------------------------
1705 -- Table structure for table `0_sales_types`
1708 DROP TABLE IF EXISTS `0_sales_types`;
1709 CREATE TABLE IF NOT EXISTS `0_sales_types` (
1710 `id` int(11) NOT NULL AUTO_INCREMENT,
1711 `sales_type` char(50) NOT NULL DEFAULT '',
1712 `tax_included` int(1) NOT NULL DEFAULT '0',
1713 `factor` double NOT NULL DEFAULT '1',
1714 `inactive` tinyint(1) NOT NULL DEFAULT '0',
1716 UNIQUE KEY `sales_type` (`sales_type`)
1717 ) ENGINE=InnoDB AUTO_INCREMENT=3 ;
1720 -- Dumping data for table `0_sales_types`
1723 INSERT INTO `0_sales_types` VALUES (1, 'Retail', 1, 1, 0);
1724 INSERT INTO `0_sales_types` VALUES (2, 'Wholesale', 0, 0.7, 0);
1726 -- --------------------------------------------------------
1729 -- Table structure for table `0_security_roles`
1732 DROP TABLE IF EXISTS `0_security_roles`;
1733 CREATE TABLE IF NOT EXISTS `0_security_roles` (
1734 `id` int(11) NOT NULL AUTO_INCREMENT,
1735 `role` varchar(30) NOT NULL,
1736 `description` varchar(50) DEFAULT NULL,
1739 `inactive` tinyint(1) NOT NULL DEFAULT '0',
1741 UNIQUE KEY `role` (`role`)
1742 ) ENGINE=InnoDB AUTO_INCREMENT=11 ;
1745 -- Dumping data for table `0_security_roles`
1748 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);
1749 INSERT INTO `0_security_roles` VALUES (2, 'System Administrator', 'System Administrator', '256;512;768;2816;3072;3328;5376;5632;5888;7936;8192;8448;9472;9728;10496;10752;11008;13056;13312;15616;15872;16128', '257;258;259;260;513;514;515;516;517;518;519;520;521;522;523;524;525;526;769;770;771;772;773;774;2817;2818;2819;2820;2821;2822;2823;3073;3074;3082;3075;3076;3077;3078;3079;3080;3081;3329;3330;3331;3332;3333;3334;3335;5377;5633;5634;5635;5636;5637;5641;5638;5639;5640;5889;5890;5891;7937;7938;7939;7940;8193;8194;8195;8196;8197;8449;8450;8451;9217;9218;9220;9473;9474;9475;9476;9729;10497;10753;10754;10755;10756;10757;11009;11010;11011;11012;13057;13313;13314;13315;15617;15618;15619;15620;15621;15622;15623;15624;15628;15625;15626;15627;15873;15874;15875;15876;15877;15878;15879;15880;15883;15881;15882;16129;16130;16131;16132;775', 0);
1750 INSERT INTO `0_security_roles` VALUES (3, 'Salesman', 'Salesman', '768;3072;5632;8192;15872', '773;774;3073;3075;3081;5633;8194;15873;775', 0);
1751 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);
1752 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);
1753 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);
1754 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);
1755 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);
1756 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);
1757 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);
1759 -- --------------------------------------------------------
1762 -- Table structure for table `0_shippers`
1765 DROP TABLE IF EXISTS `0_shippers`;
1766 CREATE TABLE IF NOT EXISTS `0_shippers` (
1767 `shipper_id` int(11) NOT NULL AUTO_INCREMENT,
1768 `shipper_name` varchar(60) NOT NULL DEFAULT '',
1769 `phone` varchar(30) NOT NULL DEFAULT '',
1770 `phone2` varchar(30) NOT NULL DEFAULT '',
1771 `contact` tinytext NOT NULL,
1772 `address` tinytext NOT NULL,
1773 `inactive` tinyint(1) NOT NULL DEFAULT '0',
1774 PRIMARY KEY (`shipper_id`),
1775 UNIQUE KEY `name` (`shipper_name`)
1776 ) ENGINE=InnoDB AUTO_INCREMENT=2 ;
1779 -- Dumping data for table `0_shippers`
1782 INSERT INTO `0_shippers` VALUES (1, 'Default', '', '', '', '', 0);
1784 -- --------------------------------------------------------
1787 -- Table structure for table `0_sql_trail`
1790 DROP TABLE IF EXISTS `0_sql_trail`;
1791 CREATE TABLE IF NOT EXISTS `0_sql_trail` (
1792 `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
1793 `sql` text NOT NULL,
1794 `result` tinyint(1) NOT NULL,
1795 `msg` varchar(255) NOT NULL,
1800 -- Dumping data for table `0_sql_trail`
1803 -- --------------------------------------------------------
1806 -- Table structure for table `0_stock_category`
1809 DROP TABLE IF EXISTS `0_stock_category`;
1810 CREATE TABLE IF NOT EXISTS `0_stock_category` (
1811 `category_id` int(11) NOT NULL AUTO_INCREMENT,
1812 `description` varchar(60) NOT NULL DEFAULT '',
1813 `dflt_tax_type` int(11) NOT NULL DEFAULT '1',
1814 `dflt_units` varchar(20) NOT NULL DEFAULT 'each',
1815 `dflt_mb_flag` char(1) NOT NULL DEFAULT 'B',
1816 `dflt_sales_act` varchar(15) NOT NULL DEFAULT '',
1817 `dflt_cogs_act` varchar(15) NOT NULL DEFAULT '',
1818 `dflt_inventory_act` varchar(15) NOT NULL DEFAULT '',
1819 `dflt_adjustment_act` varchar(15) NOT NULL DEFAULT '',
1820 `dflt_assembly_act` varchar(15) NOT NULL DEFAULT '',
1821 `dflt_dim1` int(11) DEFAULT NULL,
1822 `dflt_dim2` int(11) DEFAULT NULL,
1823 `inactive` tinyint(1) NOT NULL DEFAULT '0',
1824 `dflt_no_sale` tinyint(1) NOT NULL DEFAULT '0',
1825 `dflt_no_purchase` tinyint(1) NOT NULL DEFAULT '0',
1826 PRIMARY KEY (`category_id`),
1827 UNIQUE KEY `description` (`description`)
1828 ) ENGINE=InnoDB AUTO_INCREMENT=5 ;
1831 -- Dumping data for table `0_stock_category`
1834 INSERT INTO `0_stock_category` VALUES (1, 'Components', 1, 'each', 'B', '4010', '5010', '1510', '5040', '1530', 0, 0, 0, 0, 0);
1835 INSERT INTO `0_stock_category` VALUES (2, 'Charges', 1, 'each', 'D', '4010', '5010', '1510', '5040', '1530', 0, 0, 0, 0, 0);
1836 INSERT INTO `0_stock_category` VALUES (3, 'Systems', 1, 'each', 'M', '4010', '5010', '1510', '5040', '1530', 0, 0, 0, 0, 0);
1837 INSERT INTO `0_stock_category` VALUES (4, 'Services', 1, 'hr', 'D', '4010', '5010', '1510', '5040', '1530', 0, 0, 0, 0, 0);
1839 -- --------------------------------------------------------
1842 -- Structure of table `0_stock_fa_class` ###
1845 DROP TABLE IF EXISTS `0_stock_fa_class`;
1846 CREATE TABLE `0_stock_fa_class` (
1847 `fa_class_id` varchar(20) NOT NULL DEFAULT '',
1848 `parent_id` varchar(20) NOT NULL DEFAULT '',
1849 `description` varchar(200) NOT NULL DEFAULT '',
1850 `long_description` tinytext NOT NULL,
1851 `depreciation_rate` double NOT NULL DEFAULT '0',
1852 `inactive` tinyint(1) NOT NULL DEFAULT '0',
1853 PRIMARY KEY (`fa_class_id`)
1856 -- --------------------------------------------------------
1859 -- Table structure for table `0_stock_master`
1862 DROP TABLE IF EXISTS `0_stock_master`;
1863 CREATE TABLE IF NOT EXISTS `0_stock_master` (
1864 `stock_id` varchar(20) NOT NULL DEFAULT '',
1865 `category_id` int(11) NOT NULL DEFAULT '0',
1866 `tax_type_id` int(11) NOT NULL DEFAULT '0',
1867 `description` varchar(200) NOT NULL DEFAULT '',
1868 `long_description` tinytext NOT NULL,
1869 `units` varchar(20) NOT NULL DEFAULT 'each',
1870 `mb_flag` char(1) NOT NULL DEFAULT 'B',
1871 `sales_account` varchar(15) NOT NULL DEFAULT '',
1872 `cogs_account` varchar(15) NOT NULL DEFAULT '',
1873 `inventory_account` varchar(15) NOT NULL DEFAULT '',
1874 `adjustment_account` varchar(15) NOT NULL DEFAULT '',
1875 `assembly_account` varchar(15) NOT NULL DEFAULT '',
1876 `dimension_id` int(11) DEFAULT NULL,
1877 `dimension2_id` int(11) DEFAULT NULL,
1878 `purchase_cost` double NOT NULL DEFAULT '0',
1879 `material_cost` double NOT NULL DEFAULT '0',
1880 `labour_cost` double NOT NULL DEFAULT '0',
1881 `overhead_cost` double NOT NULL DEFAULT '0',
1882 `inactive` tinyint(1) NOT NULL DEFAULT '0',
1883 `no_sale` tinyint(1) NOT NULL DEFAULT '0',
1884 `no_purchase` tinyint(1) NOT NULL DEFAULT '0',
1885 `editable` tinyint(1) NOT NULL DEFAULT '0',
1886 `depreciation_method` char(1) NOT NULL DEFAULT 'S',
1887 `depreciation_rate` double NOT NULL DEFAULT '0',
1888 `depreciation_factor` double NOT NULL DEFAULT '1',
1889 `depreciation_start` date NOT NULL DEFAULT '0000-00-00',
1890 `depreciation_date` date NOT NULL DEFAULT '0000-00-00',
1891 `fa_class_id` varchar(20) NOT NULL DEFAULT '',
1892 PRIMARY KEY (`stock_id`)
1896 -- Dumping data for table `0_stock_master`
1899 INSERT INTO `0_stock_master` VALUES
1900 ('101', '1', '1', 'iPad Air 2 16GB', '', 'each', 'B', '4010', '5010', '1510', '5040', '1530', '0', '0', '0', '200', '0', '0', '0', '0', '0', '0', 'S', '0', '1', '0000-00-00', '0000-00-00', ''),
1901 ('102', '1', '1', 'iPhone 6 64GB', '', 'each', 'B', '4010', '5010', '1510', '5040', '1530', '0', '0', '0', '150', '0', '0', '0', '0', '0', '0', 'S', '0', '1', '0000-00-00', '0000-00-00', ''),
1902 ('103', '1', '1', 'iPhone Cover Case', '', 'each', 'B', '4010', '5010', '1510', '5040', '1530', '0', '0', '0', '10', '0', '0', '0', '0', '0', '0', 'S', '0', '1', '0000-00-00', '0000-00-00', ''),
1903 ('201', '3', '1', 'AP Surf Set', '', 'each', 'M', '4010', '5010', '1510', '5040', '1530', '0', '0', '0', '360', '0', '0', '0', '0', '0', '0', 'S', '0', '1', '0000-00-00', '0000-00-00', ''),
1904 ('202', '4', '1', 'Maintenance', '', 'hr', 'D', '4010', '5010', '1510', '5040', '1530', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', 'S', '0', '1', '0000-00-00', '0000-00-00', ''),
1905 ('301', '4', '1', 'Support', '', 'hr', 'D', '4010', '5010', '1510', '5040', '1530', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', 'S', '0', '1', '0000-00-00', '0000-00-00', '');
1907 -- --------------------------------------------------------
1910 -- Table structure for table `0_stock_moves`
1913 DROP TABLE IF EXISTS `0_stock_moves`;
1914 CREATE TABLE `0_stock_moves` (
1915 `trans_id` int(11) NOT NULL AUTO_INCREMENT,
1916 `trans_no` int(11) NOT NULL DEFAULT '0',
1917 `stock_id` char(20) NOT NULL DEFAULT '',
1918 `type` smallint(6) NOT NULL DEFAULT '0',
1919 `loc_code` char(5) NOT NULL DEFAULT '',
1920 `tran_date` date NOT NULL DEFAULT '0000-00-00',
1921 `price` double NOT NULL DEFAULT '0',
1922 `reference` char(40) NOT NULL DEFAULT '',
1923 `qty` double NOT NULL DEFAULT '1',
1924 `standard_cost` double NOT NULL DEFAULT '0',
1925 PRIMARY KEY (`trans_id`),
1926 KEY `type` (`type`,`trans_no`),
1927 KEY `Move` (`stock_id`,`loc_code`,`tran_date`)
1928 ) ENGINE=InnoDB AUTO_INCREMENT=16 ;
1931 -- Dumping data for table `0_stock_moves`
1934 INSERT INTO `0_stock_moves` VALUES
1935 ('1', '1', '101', '25', 'DEF', '2015-05-05', '200', '', '100', '200'),
1936 ('2', '1', '102', '25', 'DEF', '2015-05-05', '150', '', '100', '150'),
1937 ('3', '1', '103', '25', 'DEF', '2015-05-05', '10', '', '100', '10'),
1938 ('4', '1', '101', '13', 'DEF', '2015-05-10', '300', 'auto', '-20', '200'),
1939 ('5', '1', '301', '13', 'DEF', '2015-05-10', '80', 'auto', '-3', '0'),
1940 ('6', '1', '101', '26', 'DEF', '2015-05-05', '200', '001/2015', '-2', '200'),
1941 ('7', '1', '102', '26', 'DEF', '2015-05-05', '150', '001/2015', '-2', '150'),
1942 ('8', '1', '103', '26', 'DEF', '2015-05-05', '10', '001/2015', '-2', '10'),
1943 ('9', '1', '301', '26', 'DEF', '2015-05-05', '0', '001/2015', '-2', '0'),
1944 ('10', '1', '201', '26', 'DEF', '2015-05-05', '0', '001/2015', '2', '0'),
1945 ('11', '2', '101', '25', 'DEF', '2015-05-05', '200', '', '15', '200'),
1946 ('12', '2', '101', '13', 'DEF', '2015-05-07', '300', 'auto', '-1', '200'),
1947 ('13', '3', '102', '13', 'DEF', '2015-05-07', '222.62', 'auto', '-1', '150'),
1948 ('14', '3', '103', '13', 'DEF', '2015-05-07', '44.52', 'auto', '-1', '10'),
1949 ('15', '4', '202', '13', 'DEF', '2015-05-07', '0', 'auto', '-5', '0');
1951 -- --------------------------------------------------------
1954 -- Table structure for table `0_suppliers`
1957 DROP TABLE IF EXISTS `0_suppliers`;
1958 CREATE TABLE IF NOT EXISTS `0_suppliers` (
1959 `supplier_id` int(11) NOT NULL AUTO_INCREMENT,
1960 `supp_name` varchar(60) NOT NULL DEFAULT '',
1961 `supp_ref` varchar(30) NOT NULL DEFAULT '',
1962 `address` tinytext NOT NULL,
1963 `supp_address` tinytext NOT NULL,
1964 `gst_no` varchar(25) NOT NULL DEFAULT '',
1965 `contact` varchar(60) NOT NULL DEFAULT '',
1966 `supp_account_no` varchar(40) NOT NULL DEFAULT '',
1967 `website` varchar(100) NOT NULL DEFAULT '',
1968 `bank_account` varchar(60) NOT NULL DEFAULT '',
1969 `curr_code` char(3) DEFAULT NULL,
1970 `payment_terms` int(11) DEFAULT NULL,
1971 `tax_included` tinyint(1) NOT NULL DEFAULT '0',
1972 `dimension_id` int(11) DEFAULT '0',
1973 `dimension2_id` int(11) DEFAULT '0',
1974 `tax_group_id` int(11) DEFAULT NULL,
1975 `credit_limit` double NOT NULL DEFAULT '0',
1976 `purchase_account` varchar(15) NOT NULL DEFAULT '',
1977 `payable_account` varchar(15) NOT NULL DEFAULT '',
1978 `payment_discount_account` varchar(15) NOT NULL DEFAULT '',
1979 `notes` tinytext NOT NULL,
1980 `inactive` tinyint(1) NOT NULL DEFAULT '0',
1981 PRIMARY KEY (`supplier_id`),
1982 KEY `supp_ref` (`supp_ref`)
1983 ) ENGINE=InnoDB AUTO_INCREMENT=3 ;
1986 -- Dumping data for table `0_suppliers`
1989 INSERT INTO `0_suppliers` VALUES
1990 ('1', 'Dino Saurius Inc.', 'Dino Saurius', 'N/A', '', '987654321', '', '', '', '', 'USD', '3', '0', '0', '0', '1', '0', '', '2100', '5060', '', '0'),
1991 ('2', 'Beefeater Ltd.', 'Beefeater', 'N/A', '', '67565590', '', '', '', '', 'GBP', '4', '0', '0', '0', '1', '0', '', '2100', '5060', '', '0');
1993 -- --------------------------------------------------------
1996 -- Table structure for table `0_supp_allocations`
1999 DROP TABLE IF EXISTS `0_supp_allocations`;
2000 CREATE TABLE IF NOT EXISTS `0_supp_allocations` (
2001 `id` int(11) NOT NULL AUTO_INCREMENT,
2002 `person_id` int(11) DEFAULT NULL,
2003 `amt` double unsigned DEFAULT NULL,
2004 `date_alloc` date NOT NULL DEFAULT '0000-00-00',
2005 `trans_no_from` int(11) DEFAULT NULL,
2006 `trans_type_from` int(11) DEFAULT NULL,
2007 `trans_no_to` int(11) DEFAULT NULL,
2008 `trans_type_to` int(11) DEFAULT NULL,
2010 UNIQUE KEY `trans_type_from` (`person_id`,`trans_type_from`,`trans_no_from`,`trans_type_to`,`trans_no_to`),
2011 KEY `From` (`trans_type_from`,`trans_no_from`),
2012 KEY `To` (`trans_type_to`,`trans_no_to`)
2016 -- Dumping data for table `0_supp_allocations`
2019 -- --------------------------------------------------------
2022 -- Table structure for table `0_supp_invoice_items`
2025 DROP TABLE IF EXISTS `0_supp_invoice_items`;
2026 CREATE TABLE IF NOT EXISTS `0_supp_invoice_items` (
2027 `id` int(11) NOT NULL AUTO_INCREMENT,
2028 `supp_trans_no` int(11) DEFAULT NULL,
2029 `supp_trans_type` int(11) DEFAULT NULL,
2030 `gl_code` varchar(15) NOT NULL DEFAULT '',
2031 `grn_item_id` int(11) DEFAULT NULL,
2032 `po_detail_item_id` int(11) DEFAULT NULL,
2033 `stock_id` varchar(20) NOT NULL DEFAULT '',
2034 `description` tinytext,
2035 `quantity` double NOT NULL DEFAULT '0',
2036 `unit_price` double NOT NULL DEFAULT '0',
2037 `unit_tax` double NOT NULL DEFAULT '0',
2039 `dimension_id` int(11) NOT NULL DEFAULT '0',
2040 `dimension2_id` int(11) NOT NULL DEFAULT '0',
2042 KEY `Transaction` (`supp_trans_type`,`supp_trans_no`,`stock_id`)
2043 ) ENGINE=InnoDB AUTO_INCREMENT=2 ;
2046 -- Dumping data for table `0_supp_invoice_items`
2049 INSERT INTO `0_supp_invoice_items` VALUES ('1', '1', '20', '0', '4', '4', '101', 'iPad Air 2 16GB', '15', '200', '10', NULL, '0', '0');
2051 -- --------------------------------------------------------
2054 -- Table structure for table `0_supp_trans`
2057 DROP TABLE IF EXISTS `0_supp_trans`;
2058 CREATE TABLE IF NOT EXISTS `0_supp_trans` (
2059 `trans_no` int(11) unsigned NOT NULL DEFAULT '0',
2060 `type` smallint(6) unsigned NOT NULL DEFAULT '0',
2061 `supplier_id` int(11) unsigned DEFAULT NULL,
2062 `reference` tinytext NOT NULL,
2063 `supp_reference` varchar(60) NOT NULL DEFAULT '',
2064 `tran_date` date NOT NULL DEFAULT '0000-00-00',
2065 `due_date` date NOT NULL DEFAULT '0000-00-00',
2066 `ov_amount` double NOT NULL DEFAULT '0',
2067 `ov_discount` double NOT NULL DEFAULT '0',
2068 `ov_gst` double NOT NULL DEFAULT '0',
2069 `rate` double NOT NULL DEFAULT '1',
2070 `alloc` double NOT NULL DEFAULT '0',
2071 `tax_included` tinyint(1) NOT NULL DEFAULT '0',
2072 PRIMARY KEY (`type`,`trans_no`),
2073 KEY `supplier_id` (`supplier_id`),
2074 KEY `tran_date` (`tran_date`)
2078 -- Dumping data for table `0_supp_trans`
2082 INSERT INTO `0_supp_trans` VALUES ('1', '20', '1', '001/2015', 'rr4', '2015-05-05', '2015-05-15', '3000', '0', '150', '1', '0', '0');
2084 -- --------------------------------------------------------
2087 -- Table structure for table `0_sys_prefs`
2090 DROP TABLE IF EXISTS `0_sys_prefs`;
2091 CREATE TABLE IF NOT EXISTS `0_sys_prefs` (
2092 `name` varchar(35) NOT NULL DEFAULT '',
2093 `category` varchar(30) DEFAULT NULL,
2094 `type` varchar(20) NOT NULL DEFAULT '',
2095 `length` smallint(6) DEFAULT NULL,
2096 `value` text NOT NULL DEFAULT '',
2097 PRIMARY KEY (`name`),
2098 KEY `category` (`category`)
2102 -- Dumping data for table `0_sys_prefs`
2105 INSERT INTO `0_sys_prefs` VALUES ('coy_name', 'setup.company', 'varchar', 60, 'Training Co');
2106 INSERT INTO `0_sys_prefs` VALUES ('gst_no', 'setup.company', 'varchar', 25, '33445566');
2107 INSERT INTO `0_sys_prefs` VALUES ('coy_no', 'setup.company', 'varchar', 25, '');
2108 INSERT INTO `0_sys_prefs` VALUES ('tax_prd', 'setup.company', 'int', 11, '1');
2109 INSERT INTO `0_sys_prefs` VALUES ('tax_last', 'setup.company', 'int', 11, '1');
2110 INSERT INTO `0_sys_prefs` VALUES ('postal_address', 'setup.company', 'tinytext', 0, 'N/A');
2111 INSERT INTO `0_sys_prefs` VALUES ('phone', 'setup.company', 'varchar', 30, '');
2112 INSERT INTO `0_sys_prefs` VALUES ('fax', 'setup.company', 'varchar', 30, '');
2113 INSERT INTO `0_sys_prefs` VALUES ('email', 'setup.company', 'varchar', 100, 'delta@delta.com');
2114 INSERT INTO `0_sys_prefs` VALUES ('coy_logo', 'setup.company', 'varchar', 100, 'logo_frontaccounting.jpg');
2115 INSERT INTO `0_sys_prefs` VALUES ('domicile', 'setup.company', 'varchar', 55, '');
2116 INSERT INTO `0_sys_prefs` VALUES ('curr_default', 'setup.company', 'char', 3, 'USD');
2117 INSERT INTO `0_sys_prefs` VALUES ('use_dimension', 'setup.company', 'tinyint', 1, '1');
2118 INSERT INTO `0_sys_prefs` VALUES ('f_year', 'setup.company', 'int', 11, '1');
2119 INSERT INTO `0_sys_prefs` VALUES ('no_item_list', 'setup.company', 'tinyint', 1, '0');
2120 INSERT INTO `0_sys_prefs` VALUES ('no_customer_list', 'setup.company', 'tinyint', 1, '0');
2121 INSERT INTO `0_sys_prefs` VALUES ('no_supplier_list', 'setup.company', 'tinyint', 1, '0');
2122 INSERT INTO `0_sys_prefs` VALUES ('base_sales', 'setup.company', 'int', 11, '1');
2123 INSERT INTO `0_sys_prefs` VALUES ('time_zone', 'setup.company', 'tinyint', 1, '0');
2124 INSERT INTO `0_sys_prefs` VALUES ('add_pct', 'setup.company', 'int', 5, '-1');
2125 INSERT INTO `0_sys_prefs` VALUES ('round_to', 'setup.company', 'int', 5, '1');
2126 INSERT INTO `0_sys_prefs` VALUES ('login_tout', 'setup.company', 'smallint', 6, '600');
2127 INSERT INTO `0_sys_prefs` VALUES ('past_due_days', 'glsetup.general', 'int', 11, '30');
2128 INSERT INTO `0_sys_prefs` VALUES ('profit_loss_year_act', 'glsetup.general', 'varchar', 15, '9990');
2129 INSERT INTO `0_sys_prefs` VALUES ('retained_earnings_act', 'glsetup.general', 'varchar', 15, '3590');
2130 INSERT INTO `0_sys_prefs` VALUES ('bank_charge_act', 'glsetup.general', 'varchar', 15, '5690');
2131 INSERT INTO `0_sys_prefs` VALUES ('exchange_diff_act', 'glsetup.general', 'varchar', 15, '4450');
2132 INSERT INTO `0_sys_prefs` VALUES ('tax_algorithm', 'glsetup.customer', 'tinyint', 1, '1');
2133 INSERT INTO `0_sys_prefs` VALUES ('default_credit_limit', 'glsetup.customer', 'int', 11, '1000');
2134 INSERT INTO `0_sys_prefs` VALUES ('accumulate_shipping', 'glsetup.customer', 'tinyint', 1, '0');
2135 INSERT INTO `0_sys_prefs` VALUES ('legal_text', 'glsetup.customer', 'tinytext', 0, '');
2136 INSERT INTO `0_sys_prefs` VALUES ('freight_act', 'glsetup.customer', 'varchar', 15, '4430');
2137 INSERT INTO `0_sys_prefs` VALUES ('debtors_act', 'glsetup.sales', 'varchar', 15, '1200');
2138 INSERT INTO `0_sys_prefs` VALUES ('default_sales_act', 'glsetup.sales', 'varchar', 15, '4010');
2139 INSERT INTO `0_sys_prefs` VALUES ('default_sales_discount_act', 'glsetup.sales', 'varchar', 15, '4510');
2140 INSERT INTO `0_sys_prefs` VALUES ('default_prompt_payment_act', 'glsetup.sales', 'varchar', 15, '4500');
2141 INSERT INTO `0_sys_prefs` VALUES ('default_delivery_required', 'glsetup.sales', 'smallint', 6, '1');
2142 INSERT INTO `0_sys_prefs` VALUES ('default_receival_required', 'glsetup.purchase', 'smallint', 6, '10');
2143 INSERT INTO `0_sys_prefs` VALUES ('default_quote_valid_days', 'glsetup.sales', 'smallint', 6, '30');
2144 INSERT INTO `0_sys_prefs` VALUES ('default_dim_required', 'glsetup.dims', 'int', 11, '20');
2145 INSERT INTO `0_sys_prefs` VALUES ('pyt_discount_act', 'glsetup.purchase', 'varchar', 15, '5060');
2146 INSERT INTO `0_sys_prefs` VALUES ('creditors_act', 'glsetup.purchase', 'varchar', 15, '2100');
2147 INSERT INTO `0_sys_prefs` VALUES ('po_over_receive', 'glsetup.purchase', 'int', 11, '10');
2148 INSERT INTO `0_sys_prefs` VALUES ('po_over_charge', 'glsetup.purchase', 'int', 11, '10');
2149 INSERT INTO `0_sys_prefs` VALUES ('allow_negative_stock', 'glsetup.inventory', 'tinyint', 1, '0');
2150 INSERT INTO `0_sys_prefs` VALUES ('default_inventory_act', 'glsetup.items', 'varchar', 15, '1510');
2151 INSERT INTO `0_sys_prefs` VALUES ('default_cogs_act', 'glsetup.items', 'varchar', 15, '5010');
2152 INSERT INTO `0_sys_prefs` VALUES ('default_adj_act', 'glsetup.items', 'varchar', 15, '5040');
2153 INSERT INTO `0_sys_prefs` VALUES ('default_inv_sales_act', 'glsetup.items', 'varchar', 15, '4010');
2154 INSERT INTO `0_sys_prefs` VALUES ('default_assembly_act', 'glsetup.items', 'varchar', 15, '1530');
2155 INSERT INTO `0_sys_prefs` VALUES ('default_workorder_required', 'glsetup.manuf', 'int', 11, '20');
2156 INSERT INTO `0_sys_prefs` VALUES ('version_id', 'system', 'varchar', 11, '2.4.1');
2157 INSERT INTO `0_sys_prefs` VALUES ('auto_curr_reval', 'setup.company', 'smallint', 6, '1');
2158 INSERT INTO `0_sys_prefs` VALUES ('grn_clearing_act', 'glsetup.purchase', 'varchar', 15, '1550');
2159 INSERT INTO `0_sys_prefs` VALUES ('bcc_email', 'setup.company', 'varchar', 100, '');
2160 INSERT INTO `0_sys_prefs` VALUES ('deferred_income_act', 'glsetup.sales', 'varchar', '15', '');
2161 INSERT INTO `0_sys_prefs` VALUES ('gl_closing_date','setup.closing_date', 'date', 8, '');
2162 INSERT INTO `0_sys_prefs` VALUES ('alternative_tax_include_on_docs','setup.company', 'tinyint', 1, '0');
2163 INSERT INTO `0_sys_prefs` VALUES ('no_zero_lines_amount','glsetup.sales', 'tinyint', 1, '1');
2164 INSERT INTO `0_sys_prefs` VALUES ('show_po_item_codes','glsetup.purchase', 'tinyint', 1, '0');
2165 INSERT INTO `0_sys_prefs` VALUES ('accounts_alpha','glsetup.general', 'tinyint', 1, '0');
2166 INSERT INTO `0_sys_prefs` VALUES ('loc_notification','glsetup.inventory', 'tinyint', 1, '0');
2167 INSERT INTO `0_sys_prefs` VALUES ('print_invoice_no','glsetup.sales', 'tinyint', 1, '0');
2168 INSERT INTO `0_sys_prefs` VALUES ('allow_negative_prices','glsetup.inventory', 'tinyint', 1, '1');
2169 INSERT INTO `0_sys_prefs` VALUES ('print_item_images_on_quote','glsetup.inventory', 'tinyint', 1, '0');
2170 INSERT INTO `0_sys_prefs` VALUES ('suppress_tax_rates','setup.company', 'tinyint', 1, '0');
2171 INSERT INTO `0_sys_prefs` VALUES ('default_loss_on_asset_disposal_act', 'glsetup.items', 'varchar', '15', '5660');
2172 INSERT INTO `0_sys_prefs` VALUES ('depreciation_period', 'glsetup.company', 'tinyint', '1', '1');
2173 INSERT INTO `0_sys_prefs` VALUES ('use_manufacturing','setup.company', 'tinyint', 1, '1');
2174 INSERT INTO `0_sys_prefs` VALUES ('use_fixed_assets','setup.company', 'tinyint', 1, '1');
2175 INSERT INTO `0_sys_prefs` VALUES ('wip_act', 'glsetup.manuf', 'varchar', '15', '1530');
2178 -- --------------------------------------------------------
2181 -- Table structure for table `0_tags`
2184 DROP TABLE IF EXISTS `0_tags`;
2185 CREATE TABLE IF NOT EXISTS `0_tags` (
2186 `id` int(11) NOT NULL AUTO_INCREMENT,
2187 `type` smallint(6) NOT NULL,
2188 `name` varchar(30) NOT NULL,
2189 `description` varchar(60) DEFAULT NULL,
2190 `inactive` tinyint(1) NOT NULL DEFAULT '0',
2192 UNIQUE KEY `type` (`type`,`name`)
2196 -- Dumping data for table `0_tags`
2199 -- --------------------------------------------------------
2202 -- Table structure for table `0_tag_associations`
2205 DROP TABLE IF EXISTS `0_tag_associations`;
2206 CREATE TABLE IF NOT EXISTS `0_tag_associations` (
2207 `record_id` varchar(15) NOT NULL,
2208 `tag_id` int(11) NOT NULL,
2209 UNIQUE KEY `record_id` (`record_id`,`tag_id`)
2213 -- Dumping data for table `0_tag_associations`
2216 -- --------------------------------------------------------
2219 -- Table structure for table `0_tax_groups`
2222 DROP TABLE IF EXISTS `0_tax_groups`;
2223 CREATE TABLE IF NOT EXISTS `0_tax_groups` (
2224 `id` int(11) NOT NULL AUTO_INCREMENT,
2225 `name` varchar(60) NOT NULL DEFAULT '',
2226 `inactive` tinyint(1) NOT NULL DEFAULT '0',
2228 UNIQUE KEY `name` (`name`)
2229 ) ENGINE=InnoDB AUTO_INCREMENT=3 ;
2232 -- Dumping data for table `0_tax_groups`
2235 INSERT INTO `0_tax_groups` VALUES (1, 'Tax', 0);
2236 INSERT INTO `0_tax_groups` VALUES (2, 'Tax Exempt', 0);
2238 -- --------------------------------------------------------
2241 -- Table structure for table `0_tax_group_items`
2244 DROP TABLE IF EXISTS `0_tax_group_items`;
2245 CREATE TABLE IF NOT EXISTS `0_tax_group_items` (
2246 `tax_group_id` int(11) NOT NULL DEFAULT '0',
2247 `tax_type_id` int(11) NOT NULL DEFAULT '0',
2248 `tax_shipping` tinyint(1) NOT NULL DEFAULT '0',
2249 PRIMARY KEY (`tax_group_id`,`tax_type_id`)
2253 -- Dumping data for table `0_tax_group_items`
2256 INSERT INTO `0_tax_group_items` VALUES (1, 1, 1);
2258 -- --------------------------------------------------------
2261 -- Table structure for table `0_tax_types`
2264 DROP TABLE IF EXISTS `0_tax_types`;
2265 CREATE TABLE IF NOT EXISTS `0_tax_types` (
2266 `id` int(11) NOT NULL AUTO_INCREMENT,
2267 `rate` double NOT NULL DEFAULT '0',
2268 `sales_gl_code` varchar(15) NOT NULL DEFAULT '',
2269 `purchasing_gl_code` varchar(15) NOT NULL DEFAULT '',
2270 `name` varchar(60) NOT NULL DEFAULT '',
2271 `inactive` tinyint(1) NOT NULL DEFAULT '0',
2273 ) ENGINE=InnoDB AUTO_INCREMENT=2 ;
2276 -- Dumping data for table `0_tax_types`
2279 INSERT INTO `0_tax_types` VALUES (1, 5, '2150', '2150', 'Tax', 0);
2281 -- --------------------------------------------------------
2284 -- Table structure for table `0_trans_tax_details`
2287 DROP TABLE IF EXISTS `0_trans_tax_details`;
2288 CREATE TABLE IF NOT EXISTS `0_trans_tax_details` (
2289 `id` int(11) NOT NULL AUTO_INCREMENT,
2290 `trans_type` smallint(6) DEFAULT NULL,
2291 `trans_no` int(11) DEFAULT NULL,
2292 `tran_date` date NOT NULL,
2293 `tax_type_id` int(11) NOT NULL DEFAULT '0',
2294 `rate` double NOT NULL DEFAULT '0',
2295 `ex_rate` double NOT NULL DEFAULT '1',
2296 `included_in_price` tinyint(1) NOT NULL DEFAULT '0',
2297 `net_amount` double NOT NULL DEFAULT '0',
2298 `amount` double NOT NULL DEFAULT '0',
2300 `reg_type` tinyint(1) DEFAULT NULL,
2302 KEY `Type_and_Number` (`trans_type`,`trans_no`),
2303 KEY `tran_date` (`tran_date`)
2304 ) ENGINE=InnoDB AUTO_INCREMENT=8 ;
2307 -- Dumping data for table `0_trans_tax_details`
2310 INSERT INTO `0_trans_tax_details` VALUES
2311 ('1', '13', '1', '2015-05-10', '1', '5', '1', '1', '5942.86', '297.14', 'auto', NULL),
2312 ('2', '10', '1', '2015-05-10', '1', '5', '1', '1', '5942.86', '297.14', '001/2015', '0'),
2313 ('3', '20', '1', '2015-05-05', '1', '5', '1', '0', '3000', '150', 'rr4', '1'),
2314 ('4', '13', '2', '2015-05-07', '1', '5', '1', '1', '285.71', '14.29', 'auto', NULL),
2315 ('5', '10', '2', '2015-05-07', '1', '5', '1', '1', '285.71', '14.29', '002/2015', '0'),
2316 ('6', '13', '3', '2015-05-07', '0', '0', '1.123', '1', '267.14', '0', 'auto', NULL),
2317 ('7', '10', '3', '2015-05-07', '0', '0', '1.123', '1', '267.14', '0', '003/2015', '0');
2319 -- --------------------------------------------------------
2322 -- Table structure for table `0_useronline`
2325 DROP TABLE IF EXISTS `0_useronline`;
2326 CREATE TABLE IF NOT EXISTS `0_useronline` (
2327 `id` int(11) NOT NULL AUTO_INCREMENT,
2328 `timestamp` int(15) NOT NULL DEFAULT '0',
2329 `ip` varchar(40) NOT NULL DEFAULT '',
2330 `file` varchar(100) NOT NULL DEFAULT '',
2332 KEY `timestamp` (`timestamp`),
2337 -- Dumping data for table `0_useronline`
2340 -- --------------------------------------------------------
2343 -- Table structure for table `0_users`
2346 DROP TABLE IF EXISTS `0_users`;
2347 CREATE TABLE IF NOT EXISTS `0_users` (
2348 `id` smallint(6) NOT NULL AUTO_INCREMENT,
2349 `user_id` varchar(60) NOT NULL DEFAULT '',
2350 `password` varchar(100) NOT NULL DEFAULT '',
2351 `real_name` varchar(100) NOT NULL DEFAULT '',
2352 `role_id` int(11) NOT NULL DEFAULT '1',
2353 `phone` varchar(30) NOT NULL DEFAULT '',
2354 `email` varchar(100) DEFAULT NULL,
2355 `language` varchar(20) DEFAULT NULL,
2356 `date_format` tinyint(1) NOT NULL DEFAULT '0',
2357 `date_sep` tinyint(1) NOT NULL DEFAULT '0',
2358 `tho_sep` tinyint(1) NOT NULL DEFAULT '0',
2359 `dec_sep` tinyint(1) NOT NULL DEFAULT '0',
2360 `theme` varchar(20) NOT NULL DEFAULT 'default',
2361 `page_size` varchar(20) NOT NULL DEFAULT 'A4',
2362 `prices_dec` smallint(6) NOT NULL DEFAULT '2',
2363 `qty_dec` smallint(6) NOT NULL DEFAULT '2',
2364 `rates_dec` smallint(6) NOT NULL DEFAULT '4',
2365 `percent_dec` smallint(6) NOT NULL DEFAULT '1',
2366 `show_gl` tinyint(1) NOT NULL DEFAULT '1',
2367 `show_codes` tinyint(1) NOT NULL DEFAULT '0',
2368 `show_hints` tinyint(1) NOT NULL DEFAULT '0',
2369 `last_visit_date` datetime DEFAULT NULL,
2370 `query_size` tinyint(1) unsigned NOT NULL DEFAULT '10',
2371 `graphic_links` tinyint(1) DEFAULT '1',
2372 `pos` smallint(6) DEFAULT '1',
2373 `print_profile` varchar(30) NOT NULL DEFAULT '',
2374 `rep_popup` tinyint(1) DEFAULT '1',
2375 `sticky_doc_date` tinyint(1) DEFAULT '0',
2376 `startup_tab` varchar(20) NOT NULL DEFAULT '',
2377 `transaction_days` smallint(6) NOT NULL DEFAULT '30',
2378 `save_report_selections` smallint(6) NOT NULL DEFAULT '0',
2379 `use_date_picker` tinyint(1) NOT NULL DEFAULT '1',
2380 `def_print_destination` tinyint(1) NOT NULL DEFAULT '0',
2381 `def_print_orientation` tinyint(1) NOT NULL DEFAULT '0',
2382 `inactive` tinyint(1) NOT NULL DEFAULT '0',
2384 UNIQUE KEY `user_id` (`user_id`)
2385 ) ENGINE=InnoDB AUTO_INCREMENT=2 ;
2388 -- Dumping data for table `0_users`
2391 INSERT INTO `0_users` VALUES (1, 'admin', '5f4dcc3b5aa765d61d8327deb882cf99', 'Administrator', 2, '', 'adm@example.com', 'C', 0, 0, 0, 0, 'default', 'Letter', 2, 2, 4, 1, 1, 0, 0, '2015-05-07 13:58:33', 10, 1, 1, '1', 1, 0, 'orders', 30, 0, 1, 0, 0, 0);
2393 -- --------------------------------------------------------
2396 -- Table structure for table `0_voided`
2399 DROP TABLE IF EXISTS `0_voided`;
2400 CREATE TABLE IF NOT EXISTS `0_voided` (
2401 `type` int(11) NOT NULL DEFAULT '0',
2402 `id` int(11) NOT NULL DEFAULT '0',
2403 `date_` date NOT NULL DEFAULT '0000-00-00',
2404 `memo_` tinytext NOT NULL,
2405 UNIQUE KEY `id` (`type`,`id`)
2409 -- Dumping data for table `0_voided`
2412 -- --------------------------------------------------------
2415 -- Table structure for table `0_workcentres`
2418 DROP TABLE IF EXISTS `0_workcentres`;
2419 CREATE TABLE IF NOT EXISTS `0_workcentres` (
2420 `id` int(11) NOT NULL AUTO_INCREMENT,
2421 `name` char(40) NOT NULL DEFAULT '',
2422 `description` char(50) NOT NULL DEFAULT '',
2423 `inactive` tinyint(1) NOT NULL DEFAULT '0',
2425 UNIQUE KEY `name` (`name`)
2426 ) ENGINE=InnoDB AUTO_INCREMENT=2 ;
2429 -- Dumping data for table `0_workcentres`
2432 INSERT INTO `0_workcentres` VALUES ('1', 'Work Centre', '', '0');
2434 -- --------------------------------------------------------
2437 -- Table structure for table `0_workorders`
2440 DROP TABLE IF EXISTS `0_workorders`;
2441 CREATE TABLE IF NOT EXISTS `0_workorders` (
2442 `id` int(11) NOT NULL AUTO_INCREMENT,
2443 `wo_ref` varchar(60) NOT NULL DEFAULT '',
2444 `loc_code` varchar(5) NOT NULL DEFAULT '',
2445 `units_reqd` double NOT NULL DEFAULT '1',
2446 `stock_id` varchar(20) NOT NULL DEFAULT '',
2447 `date_` date NOT NULL DEFAULT '0000-00-00',
2448 `type` tinyint(4) NOT NULL DEFAULT '0',
2449 `required_by` date NOT NULL DEFAULT '0000-00-00',
2450 `released_date` date NOT NULL DEFAULT '0000-00-00',
2451 `units_issued` double NOT NULL DEFAULT '0',
2452 `closed` tinyint(1) NOT NULL DEFAULT '0',
2453 `released` tinyint(1) NOT NULL DEFAULT '0',
2454 `additional_costs` double NOT NULL DEFAULT '0',
2456 UNIQUE KEY `wo_ref` (`wo_ref`)
2457 ) ENGINE=InnoDB AUTO_INCREMENT=4 ;
2460 -- Dumping data for table `0_workorders`
2463 INSERT INTO `0_workorders` VALUES
2464 ('1', '001/2015', 'DEF', '2', '201', '2015-05-05', '0', '2015-05-05', '2015-05-05', '2', '1', '1', '0'),
2465 ('2', '002/2015', 'DEF', '5', '201', '2015-05-07', '2', '2015-05-27', '2015-05-07', '0', '0', '1', '0'),
2466 ('3', '003/2015', 'DEF', '5', '201', '2015-05-07', '2', '2015-05-27', '0000-00-00', '0', '0', '0', '0');
2468 -- --------------------------------------------------------
2471 -- Table structure for table `0_wo_costing`
2474 DROP TABLE IF EXISTS `0_wo_costing`;
2475 CREATE TABLE `0_wo_costing` (
2476 `id` int(11) NOT NULL AUTO_INCREMENT,
2477 `workorder_id` int(11) NOT NULL DEFAULT '0',
2478 `cost_type` tinyint(1) NOT NULL DEFAULT '0',
2479 `trans_type` int(11) NOT NULL DEFAULT '0',
2480 `trans_no` int(11) NOT NULL DEFAULT '0',
2481 `factor` double NOT NULL DEFAULT '1',
2486 -- Dumping data for table `0_wo_costing`
2489 -- --------------------------------------------------------
2492 -- Table structure for table `0_wo_issues`
2495 DROP TABLE IF EXISTS `0_wo_issues`;
2496 CREATE TABLE IF NOT EXISTS `0_wo_issues` (
2497 `issue_no` int(11) NOT NULL AUTO_INCREMENT,
2498 `workorder_id` int(11) NOT NULL DEFAULT '0',
2499 `reference` varchar(100) DEFAULT NULL,
2500 `issue_date` date DEFAULT NULL,
2501 `loc_code` varchar(5) DEFAULT NULL,
2502 `workcentre_id` int(11) DEFAULT NULL,
2503 PRIMARY KEY (`issue_no`),
2504 KEY `workorder_id` (`workorder_id`)
2508 -- Dumping data for table `0_wo_issues`
2511 -- --------------------------------------------------------
2514 -- Table structure for table `0_wo_issue_items`
2517 DROP TABLE IF EXISTS `0_wo_issue_items`;
2518 CREATE TABLE IF NOT EXISTS `0_wo_issue_items` (
2519 `id` int(11) NOT NULL AUTO_INCREMENT,
2520 `stock_id` varchar(40) DEFAULT NULL,
2521 `issue_id` int(11) DEFAULT NULL,
2522 `qty_issued` double DEFAULT NULL,
2523 `unit_cost` double NOT NULL default '0',
2528 -- Dumping data for table `0_wo_issue_items`
2531 -- --------------------------------------------------------
2534 -- Table structure for table `0_wo_manufacture`
2537 DROP TABLE IF EXISTS `0_wo_manufacture`;
2538 CREATE TABLE IF NOT EXISTS `0_wo_manufacture` (
2539 `id` int(11) NOT NULL AUTO_INCREMENT,
2540 `reference` varchar(100) DEFAULT NULL,
2541 `workorder_id` int(11) NOT NULL DEFAULT '0',
2542 `quantity` double NOT NULL DEFAULT '0',
2543 `date_` date NOT NULL DEFAULT '0000-00-00',
2545 KEY `workorder_id` (`workorder_id`)
2549 -- Dumping data for table `0_wo_manufacture`
2552 -- --------------------------------------------------------
2555 -- Table structure for table `0_wo_requirements`
2558 DROP TABLE IF EXISTS `0_wo_requirements`;
2559 CREATE TABLE IF NOT EXISTS `0_wo_requirements` (
2560 `id` int(11) NOT NULL AUTO_INCREMENT,
2561 `workorder_id` int(11) NOT NULL DEFAULT '0',
2562 `stock_id` char(20) NOT NULL DEFAULT '',
2563 `workcentre` int(11) NOT NULL DEFAULT '0',
2564 `units_req` double NOT NULL DEFAULT '1',
2565 `unit_cost` double NOT NULL DEFAULT '0',
2566 `loc_code` char(5) NOT NULL DEFAULT '',
2567 `units_issued` double NOT NULL DEFAULT '0',
2569 KEY `workorder_id` (`workorder_id`)
2570 ) ENGINE=InnoDB AUTO_INCREMENT=9 ;
2573 -- Dumping data for table `0_wo_requirements`
2576 INSERT INTO `0_wo_requirements` VALUES
2577 ('1', '1', '101', '1', '1', '0', 'DEF', '2'),
2578 ('2', '1', '102', '1', '1', '0', 'DEF', '2'),
2579 ('3', '1', '103', '1', '1', '0', 'DEF', '2'),
2580 ('4', '1', '301', '1', '1', '0', 'DEF', '2'),
2581 ('5', '2', '101', '1', '1', '0', 'DEF', '0'),
2582 ('6', '2', '102', '1', '1', '0', 'DEF', '0'),
2583 ('7', '2', '103', '1', '1', '0', 'DEF', '0'),
2584 ('8', '2', '301', '1', '1', '0', 'DEF', '0');