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=3 ;
857 -- Dumping data for table `0_fiscal_year`
860 INSERT INTO `0_fiscal_year` VALUES (1, '2015-01-01', '2015-12-31', 0);
861 INSERT INTO `0_fiscal_year` VALUES (2, '2016-01-01', '2016-12-31', 0);
863 -- --------------------------------------------------------
866 -- Table structure for table `0_gl_trans`
869 DROP TABLE IF EXISTS `0_gl_trans`;
870 CREATE TABLE IF NOT EXISTS `0_gl_trans` (
871 `counter` int(11) NOT NULL AUTO_INCREMENT,
872 `type` smallint(6) NOT NULL DEFAULT '0',
873 `type_no` int(11) NOT NULL DEFAULT '0',
874 `tran_date` date NOT NULL DEFAULT '0000-00-00',
875 `account` varchar(15) NOT NULL DEFAULT '',
876 `memo_` tinytext NOT NULL,
877 `amount` double NOT NULL DEFAULT '0',
878 `dimension_id` int(11) NOT NULL DEFAULT '0',
879 `dimension2_id` int(11) NOT NULL DEFAULT '0',
880 `person_type_id` int(11) DEFAULT NULL,
881 `person_id` tinyblob,
882 PRIMARY KEY (`counter`),
883 KEY `Type_and_Number` (`type`,`type_no`),
884 KEY `dimension_id` (`dimension_id`),
885 KEY `dimension2_id` (`dimension2_id`),
886 KEY `tran_date` (`tran_date`),
887 KEY `account_and_tran_date` (`account`,`tran_date`)
888 ) ENGINE=InnoDB AUTO_INCREMENT=39 ;
891 -- Dumping data for table `0_gl_trans`
894 INSERT INTO `0_gl_trans` VALUES
895 ('1', '25', '1', '2015-05-05', '1510', '101', '20000', '0', '0', NULL, NULL),
896 ('2', '25', '1', '2015-05-05', '1510', '102', '15000', '0', '0', NULL, NULL),
897 ('3', '25', '1', '2015-05-05', '1510', '103', '1000', '0', '0', NULL, NULL),
898 ('4', '25', '1', '2015-05-05', '1550', '', '-36000', '0', '0', NULL, NULL),
899 ('5', '13', '1', '2015-05-10', '5010', '', '4000', '0', '0', NULL, NULL),
900 ('6', '13', '1', '2015-05-10', '1510', '', '-4000', '0', '0', NULL, NULL),
901 ('7', '10', '1', '2015-05-10', '4010', '', '-5714.29', '0', '0', NULL, NULL),
902 ('8', '10', '1', '2015-05-10', '4010', '', '-228.57', '0', '0', NULL, NULL),
903 ('9', '10', '1', '2015-05-10', '1200', '', '6240', '0', '0', '2', '1'),
904 ('10', '10', '1', '2015-05-10', '2150', '', '-297.14', '0', '0', NULL, NULL),
905 ('11', '12', '1', '2015-05-10', '1065', '', '6240', '0', '0', NULL, NULL),
906 ('12', '12', '1', '2015-05-10', '1200', '', '-6240', '0', '0', '2', '1'),
907 ('13', '26', '1', '2015-05-05', '1510', '1 * iPad Air 2 16GB', '-400', '0', '0', NULL, NULL),
908 ('14', '26', '1', '2015-05-05', '1510', '1 * iPhone 6 64GB', '-300', '0', '0', NULL, NULL),
909 ('15', '26', '1', '2015-05-05', '1510', '1 * iPhone Cover Case', '-20', '0', '0', NULL, NULL),
910 ('16', '26', '1', '2015-05-05', '1510', 'Produced 2 * AP Surf Set', '720', '0', '0', NULL, NULL),
911 ('17', '25', '2', '2015-05-05', '1510', '101', '3000', '0', '0', NULL, NULL),
912 ('18', '25', '2', '2015-05-05', '1550', '', '-3000', '0', '0', NULL, NULL),
913 ('19', '20', '1', '2015-05-05', '2150', '', '150', '0', '0', NULL, NULL),
914 ('20', '20', '1', '2015-05-05', '2100', '', '-3150', '0', '0', '3', '1'),
915 ('21', '20', '1', '2015-05-05', '1550', '', '3000', '0', '0', NULL, NULL),
916 ('22', '13', '2', '2015-05-07', '5010', '', '200', '0', '0', NULL, NULL),
917 ('23', '13', '2', '2015-05-07', '1510', '', '-200', '0', '0', NULL, NULL),
918 ('24', '10', '2', '2015-05-07', '4010', '', '-285.71', '0', '0', NULL, NULL),
919 ('25', '10', '2', '2015-05-07', '1200', '', '300', '0', '0', '2', '1'),
920 ('26', '10', '2', '2015-05-07', '2150', '', '-14.29', '0', '0', NULL, NULL),
921 ('27', '12', '2', '2015-05-07', '1065', '', '300', '0', '0', NULL, NULL),
922 ('28', '12', '2', '2015-05-07', '1200', '', '-300', '0', '0', '2', '1'),
923 ('29', '13', '3', '2015-05-07', '5010', '', '150', '1', '0', NULL, NULL),
924 ('30', '13', '3', '2015-05-07', '1510', '', '-150', '0', '0', NULL, NULL),
925 ('31', '13', '3', '2015-05-07', '5010', '', '10', '1', '0', NULL, NULL),
926 ('32', '13', '3', '2015-05-07', '1510', '', '-10', '0', '0', NULL, NULL),
927 ('33', '10', '3', '2015-05-07', '4010', '', '-250', '1', '0', NULL, NULL),
928 ('34', '10', '3', '2015-05-07', '4010', '', '-50', '1', '0', NULL, NULL),
929 ('35', '10', '3', '2015-05-07', '1200', '', '300', '0', '0', '2', '2'),
930 ('36', '12', '3', '2015-05-07', '1065', '', '0', '0', '0', NULL, NULL),
931 ('37', '1', '1', '2015-05-07', '5010', '', '5', '1', '0', NULL, NULL),
932 ('38', '1', '1', '2015-05-07', '1060', '', '-5', '0', '0', NULL, NULL);
934 -- --------------------------------------------------------
937 -- Table structure for table `0_grn_batch`
940 DROP TABLE IF EXISTS `0_grn_batch`;
941 CREATE TABLE IF NOT EXISTS `0_grn_batch` (
942 `id` int(11) NOT NULL AUTO_INCREMENT,
943 `supplier_id` int(11) NOT NULL DEFAULT '0',
944 `purch_order_no` int(11) DEFAULT NULL,
945 `reference` varchar(60) NOT NULL DEFAULT '',
946 `delivery_date` date NOT NULL DEFAULT '0000-00-00',
947 `loc_code` varchar(5) DEFAULT NULL,
948 `rate` double DEFAULT '1',
950 KEY `delivery_date` (`delivery_date`),
951 KEY `purch_order_no` (`purch_order_no`)
952 ) ENGINE=InnoDB AUTO_INCREMENT=3 ;
955 -- Dumping data for table `0_grn_batch`
958 INSERT INTO `0_grn_batch` VALUES
959 ('1', '1', '1', '001/2015', '2015-05-05', 'DEF', '1'),
960 ('2', '1', '2', 'auto', '2015-05-05', 'DEF', '1');
962 -- --------------------------------------------------------
965 -- Table structure for table `0_grn_items`
968 DROP TABLE IF EXISTS `0_grn_items`;
969 CREATE TABLE IF NOT EXISTS `0_grn_items` (
970 `id` int(11) NOT NULL AUTO_INCREMENT,
971 `grn_batch_id` int(11) DEFAULT NULL,
972 `po_detail_item` int(11) NOT NULL DEFAULT '0',
973 `item_code` varchar(20) NOT NULL DEFAULT '',
974 `description` tinytext,
975 `qty_recd` double NOT NULL DEFAULT '0',
976 `quantity_inv` double NOT NULL DEFAULT '0',
978 KEY `grn_batch_id` (`grn_batch_id`)
979 ) ENGINE=InnoDB AUTO_INCREMENT=5 ;
982 -- Dumping data for table `0_grn_items`
985 INSERT INTO `0_grn_items` VALUES
986 ('1', '1', '1', '101', 'iPad Air 2 16GB', '100', '0'),
987 ('2', '1', '2', '102', 'iPhone 6 64GB', '100', '0'),
988 ('3', '1', '3', '103', 'iPhone Cover Case', '100', '0'),
989 ('4', '2', '4', '101', 'iPad Air 2 16GB', '15', '15');
991 -- --------------------------------------------------------
994 -- Table structure for table `0_groups`
997 DROP TABLE IF EXISTS `0_groups`;
998 CREATE TABLE IF NOT EXISTS `0_groups` (
999 `id` smallint(6) unsigned NOT NULL AUTO_INCREMENT,
1000 `description` varchar(60) NOT NULL DEFAULT '',
1001 `inactive` tinyint(1) NOT NULL DEFAULT '0',
1003 UNIQUE KEY `description` (`description`)
1004 ) ENGINE=InnoDB AUTO_INCREMENT=4 ;
1007 -- Dumping data for table `0_groups`
1010 INSERT INTO `0_groups` VALUES (1, 'Small', 0);
1011 INSERT INTO `0_groups` VALUES (2, 'Medium', 0);
1012 INSERT INTO `0_groups` VALUES (3, 'Large', 0);
1014 -- --------------------------------------------------------
1017 -- Table structure for table `0_item_codes`
1020 DROP TABLE IF EXISTS `0_item_codes`;
1021 CREATE TABLE IF NOT EXISTS `0_item_codes` (
1022 `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
1023 `item_code` varchar(20) NOT NULL,
1024 `stock_id` varchar(20) NOT NULL,
1025 `description` varchar(200) NOT NULL DEFAULT '',
1026 `category_id` smallint(6) unsigned NOT NULL,
1027 `quantity` double NOT NULL DEFAULT '1',
1028 `is_foreign` tinyint(1) NOT NULL DEFAULT '0',
1029 `inactive` tinyint(1) NOT NULL DEFAULT '0',
1031 UNIQUE KEY `stock_id` (`stock_id`,`item_code`),
1032 KEY `item_code` (`item_code`)
1033 ) ENGINE=InnoDB AUTO_INCREMENT=9 ;
1036 -- Dumping data for table `0_item_codes`
1039 INSERT INTO `0_item_codes` VALUES
1040 ('1', '101', '101', 'iPad Air 2 16GB', '1', '1', '0', '0'),
1041 ('2', '102', '102', 'iPhone 6 64GB', '1', '1', '0', '0'),
1042 ('3', '103', '103', 'iPhone Cover Case', '1', '1', '0', '0'),
1043 ('4', '201', '201', 'AP Surf Set', '3', '1', '0', '0'),
1044 ('5', '301', '301', 'Support', '4', '1', '0', '0'),
1045 ('6', '501', '102', 'iPhone Pack', '1', '1', '0', '0'),
1046 ('7', '501', '103', 'iPhone Pack', '1', '1', '0', '0'),
1047 ('8', '202', '202', 'Maintenance', '4', '1', '0', '0');
1049 -- --------------------------------------------------------
1052 -- Table structure for table `0_item_tax_types`
1055 DROP TABLE IF EXISTS `0_item_tax_types`;
1056 CREATE TABLE IF NOT EXISTS `0_item_tax_types` (
1057 `id` int(11) NOT NULL auto_increment,
1058 `name` varchar(60) NOT NULL default '',
1059 `exempt` tinyint(1) NOT NULL default '0',
1060 `inactive` tinyint(1) NOT NULL default '0',
1062 UNIQUE KEY `name` (`name`)
1063 ) ENGINE=InnoDB AUTO_INCREMENT=2 ;
1066 -- Dumping data for table `0_item_tax_types`
1069 INSERT INTO `0_item_tax_types` VALUES (1, 'Regular', 0, 0);
1071 -- --------------------------------------------------------
1074 -- Table structure for table `0_item_tax_type_exemptions`
1077 DROP TABLE IF EXISTS `0_item_tax_type_exemptions`;
1078 CREATE TABLE IF NOT EXISTS `0_item_tax_type_exemptions` (
1079 `item_tax_type_id` int(11) NOT NULL DEFAULT '0',
1080 `tax_type_id` int(11) NOT NULL DEFAULT '0',
1081 PRIMARY KEY (`item_tax_type_id`,`tax_type_id`)
1085 -- Dumping data for table `0_item_tax_type_exemptions`
1088 -- --------------------------------------------------------
1091 -- Table structure for table `0_item_units`
1094 DROP TABLE IF EXISTS `0_item_units`;
1095 CREATE TABLE IF NOT EXISTS `0_item_units` (
1096 `abbr` varchar(20) NOT NULL,
1097 `name` varchar(40) NOT NULL,
1098 `decimals` tinyint(2) NOT NULL,
1099 `inactive` tinyint(1) NOT NULL DEFAULT '0',
1100 PRIMARY KEY (`abbr`),
1101 UNIQUE KEY `name` (`name`)
1105 -- Dumping data for table `0_item_units`
1108 INSERT INTO `0_item_units` VALUES ('each', 'Each', 0, 0);
1109 INSERT INTO `0_item_units` VALUES ('hr', 'Hours', 0, 0);
1111 -- --------------------------------------------------------
1114 -- Table structure for table `0_journal`
1117 DROP TABLE IF EXISTS `0_journal`;
1118 CREATE TABLE `0_journal` (
1119 `type` smallint(6) NOT NULL DEFAULT '0',
1120 `trans_no` int(11) NOT NULL DEFAULT '0',
1121 `tran_date` date DEFAULT '0000-00-00',
1122 `reference` varchar(60) NOT NULL DEFAULT '',
1123 `source_ref` varchar(60) NOT NULL DEFAULT '',
1124 `event_date` date DEFAULT '0000-00-00',
1125 `doc_date` date NOT NULL DEFAULT '0000-00-00',
1126 `currency` char(3) NOT NULL DEFAULT '',
1127 `amount` double NOT NULL DEFAULT '0',
1128 `rate` double NOT NULL DEFAULT '1',
1129 PRIMARY KEY (`type`,`trans_no`),
1130 KEY `tran_date` (`tran_date`)
1134 -- Dumping data for table `0_journal`
1137 -- --------------------------------------------------------
1140 -- Table structure for table `0_locations`
1143 DROP TABLE IF EXISTS `0_locations`;
1144 CREATE TABLE IF NOT EXISTS `0_locations` (
1145 `loc_code` varchar(5) NOT NULL DEFAULT '',
1146 `location_name` varchar(60) NOT NULL DEFAULT '',
1147 `delivery_address` tinytext NOT NULL,
1148 `phone` varchar(30) NOT NULL DEFAULT '',
1149 `phone2` varchar(30) NOT NULL DEFAULT '',
1150 `fax` varchar(30) NOT NULL DEFAULT '',
1151 `email` varchar(100) NOT NULL DEFAULT '',
1152 `contact` varchar(30) NOT NULL DEFAULT '',
1153 `fixed_asset` tinyint(1) NOT NULL DEFAULT '0',
1154 `inactive` tinyint(1) NOT NULL DEFAULT '0',
1155 PRIMARY KEY (`loc_code`)
1159 -- Dumping data for table `0_locations`
1162 INSERT INTO `0_locations` VALUES ('DEF', 'Default', 'N/A', '', '', '', '', '', 0, 0);
1164 -- --------------------------------------------------------
1167 -- Table structure for table `0_loc_stock`
1170 DROP TABLE IF EXISTS `0_loc_stock`;
1171 CREATE TABLE IF NOT EXISTS `0_loc_stock` (
1172 `loc_code` char(5) NOT NULL DEFAULT '',
1173 `stock_id` char(20) NOT NULL DEFAULT '',
1174 `reorder_level` double NOT NULL DEFAULT '0',
1175 PRIMARY KEY (`loc_code`,`stock_id`),
1176 KEY `stock_id` (`stock_id`)
1180 -- Dumping data for table `0_loc_stock`
1183 INSERT INTO `0_loc_stock` VALUES
1184 ('DEF', '101', '0'),
1185 ('DEF', '102', '0'),
1186 ('DEF', '103', '0'),
1187 ('DEF', '201', '0'),
1188 ('DEF', '202', '0'),
1189 ('DEF', '301', '0');
1191 -- --------------------------------------------------------
1194 -- Table structure for table `0_payment_terms`
1197 DROP TABLE IF EXISTS `0_payment_terms`;
1198 CREATE TABLE IF NOT EXISTS `0_payment_terms` (
1199 `terms_indicator` int(11) NOT NULL AUTO_INCREMENT,
1200 `terms` char(80) NOT NULL DEFAULT '',
1201 `days_before_due` smallint(6) NOT NULL DEFAULT '0',
1202 `day_in_following_month` smallint(6) NOT NULL DEFAULT '0',
1203 `inactive` tinyint(1) NOT NULL DEFAULT '0',
1204 PRIMARY KEY (`terms_indicator`),
1205 UNIQUE KEY `terms` (`terms`)
1206 ) ENGINE=InnoDB AUTO_INCREMENT=5 ;
1209 -- Dumping data for table `0_payment_terms`
1212 INSERT INTO `0_payment_terms` VALUES (1, 'Due 15th Of the Following Month', 0, 17, 0);
1213 INSERT INTO `0_payment_terms` VALUES (2, 'Due By End Of The Following Month', 0, 30, 0);
1214 INSERT INTO `0_payment_terms` VALUES (3, 'Payment due within 10 days', 10, 0, 0);
1215 INSERT INTO `0_payment_terms` VALUES (4, 'Cash Only', 0, 0, 0);
1217 -- --------------------------------------------------------
1220 -- Table structure for table `0_prices`
1223 DROP TABLE IF EXISTS `0_prices`;
1224 CREATE TABLE IF NOT EXISTS `0_prices` (
1225 `id` int(11) NOT NULL AUTO_INCREMENT,
1226 `stock_id` varchar(20) NOT NULL DEFAULT '',
1227 `sales_type_id` int(11) NOT NULL DEFAULT '0',
1228 `curr_abrev` char(3) NOT NULL DEFAULT '',
1229 `price` double NOT NULL DEFAULT '0',
1231 UNIQUE KEY `price` (`stock_id`,`sales_type_id`,`curr_abrev`)
1232 ) ENGINE=InnoDB AUTO_INCREMENT=4 ;
1235 -- Dumping data for table `0_prices`
1238 INSERT INTO `0_prices` VALUES
1239 ('1', '101', '1', 'USD', '300'),
1240 ('2', '102', '1', 'USD', '250'),
1241 ('3', '103', '1', 'USD', '50');
1243 -- --------------------------------------------------------
1246 -- Table structure for table `0_printers`
1249 DROP TABLE IF EXISTS `0_printers`;
1250 CREATE TABLE IF NOT EXISTS `0_printers` (
1251 `id` tinyint(3) unsigned NOT NULL AUTO_INCREMENT,
1252 `name` varchar(20) NOT NULL,
1253 `description` varchar(60) NOT NULL,
1254 `queue` varchar(20) NOT NULL,
1255 `host` varchar(40) NOT NULL,
1256 `port` smallint(11) unsigned NOT NULL,
1257 `timeout` tinyint(3) unsigned NOT NULL,
1259 UNIQUE KEY `name` (`name`)
1260 ) ENGINE=InnoDB AUTO_INCREMENT=4 ;
1263 -- Dumping data for table `0_printers`
1266 INSERT INTO `0_printers` VALUES (1, 'QL500', 'Label printer', 'QL500', 'server', 127, 20);
1267 INSERT INTO `0_printers` VALUES (2, 'Samsung', 'Main network printer', 'scx4521F', 'server', 515, 5);
1268 INSERT INTO `0_printers` VALUES (3, 'Local', 'Local print server at user IP', 'lp', '', 515, 10);
1270 -- --------------------------------------------------------
1273 -- Table structure for table `0_print_profiles`
1276 DROP TABLE IF EXISTS `0_print_profiles`;
1277 CREATE TABLE IF NOT EXISTS `0_print_profiles` (
1278 `id` smallint(6) unsigned NOT NULL AUTO_INCREMENT,
1279 `profile` varchar(30) NOT NULL,
1280 `report` varchar(5) DEFAULT NULL,
1281 `printer` tinyint(3) unsigned DEFAULT NULL,
1283 UNIQUE KEY `profile` (`profile`,`report`)
1284 ) ENGINE=InnoDB AUTO_INCREMENT=10 ;
1287 -- Dumping data for table `0_print_profiles`
1290 INSERT INTO `0_print_profiles` VALUES (1, 'Out of office', '', 0);
1291 INSERT INTO `0_print_profiles` VALUES (2, 'Sales Department', '', 0);
1292 INSERT INTO `0_print_profiles` VALUES (3, 'Central', '', 2);
1293 INSERT INTO `0_print_profiles` VALUES (4, 'Sales Department', '104', 2);
1294 INSERT INTO `0_print_profiles` VALUES (5, 'Sales Department', '105', 2);
1295 INSERT INTO `0_print_profiles` VALUES (6, 'Sales Department', '107', 2);
1296 INSERT INTO `0_print_profiles` VALUES (7, 'Sales Department', '109', 2);
1297 INSERT INTO `0_print_profiles` VALUES (8, 'Sales Department', '110', 2);
1298 INSERT INTO `0_print_profiles` VALUES (9, 'Sales Department', '201', 2);
1300 -- --------------------------------------------------------
1303 -- Table structure for table `0_purch_data`
1306 DROP TABLE IF EXISTS `0_purch_data`;
1307 CREATE TABLE IF NOT EXISTS `0_purch_data` (
1308 `supplier_id` int(11) NOT NULL DEFAULT '0',
1309 `stock_id` char(20) NOT NULL DEFAULT '',
1310 `price` double NOT NULL DEFAULT '0',
1311 `suppliers_uom` char(50) NOT NULL DEFAULT '',
1312 `conversion_factor` double NOT NULL DEFAULT '1',
1313 `supplier_description` char(50) NOT NULL DEFAULT '',
1314 PRIMARY KEY (`supplier_id`,`stock_id`)
1318 -- Dumping data for table `0_purch_data`
1321 INSERT INTO `0_purch_data` VALUES
1322 ('1', '101', '200', '', '1', 'iPad Air 2 16GB'),
1323 ('1', '102', '150', '', '1', 'iPhone 6 64GB'),
1324 ('1', '103', '10', '', '1', 'iPhone Cover Case');
1326 -- --------------------------------------------------------
1329 -- Table structure for table `0_purch_orders`
1332 DROP TABLE IF EXISTS `0_purch_orders`;
1333 CREATE TABLE IF NOT EXISTS `0_purch_orders` (
1334 `order_no` int(11) NOT NULL AUTO_INCREMENT,
1335 `supplier_id` int(11) NOT NULL DEFAULT '0',
1336 `comments` tinytext,
1337 `ord_date` date NOT NULL DEFAULT '0000-00-00',
1338 `reference` tinytext NOT NULL,
1339 `requisition_no` tinytext,
1340 `into_stock_location` varchar(5) NOT NULL DEFAULT '',
1341 `delivery_address` tinytext NOT NULL,
1342 `total` double NOT NULL DEFAULT '0',
1343 `prep_amount` double NOT NULL DEFAULT '0',
1344 `alloc` double NOT NULL DEFAULT '0',
1345 `tax_included` tinyint(1) NOT NULL DEFAULT '0',
1346 PRIMARY KEY (`order_no`),
1347 KEY `ord_date` (`ord_date`)
1348 ) ENGINE=InnoDB AUTO_INCREMENT=3 ;
1351 -- Dumping data for table `0_purch_orders`
1354 INSERT INTO `0_purch_orders` VALUES
1355 ('1', '1', NULL, '2015-05-05', '001/2015', NULL, 'DEF', 'N/A', '37800', '0', '0', '0'),
1356 ('2', '1', NULL, '2015-05-05', 'auto', 'rr4', 'DEF', 'N/A', '3150', '0', '0', '0');
1358 -- --------------------------------------------------------
1361 -- Table structure for table `0_purch_order_details`
1364 DROP TABLE IF EXISTS `0_purch_order_details`;
1365 CREATE TABLE IF NOT EXISTS `0_purch_order_details` (
1366 `po_detail_item` int(11) NOT NULL AUTO_INCREMENT,
1367 `order_no` int(11) NOT NULL DEFAULT '0',
1368 `item_code` varchar(20) NOT NULL DEFAULT '',
1369 `description` tinytext,
1370 `delivery_date` date NOT NULL DEFAULT '0000-00-00',
1371 `qty_invoiced` double NOT NULL DEFAULT '0',
1372 `unit_price` double NOT NULL DEFAULT '0',
1373 `act_price` double NOT NULL DEFAULT '0',
1374 `std_cost_unit` double NOT NULL DEFAULT '0',
1375 `quantity_ordered` double NOT NULL DEFAULT '0',
1376 `quantity_received` double NOT NULL DEFAULT '0',
1377 PRIMARY KEY (`po_detail_item`),
1378 KEY `order` (`order_no`,`po_detail_item`),
1379 KEY `itemcode` (`item_code`)
1380 ) ENGINE=InnoDB AUTO_INCREMENT=5 ;
1383 -- Dumping data for table `0_purch_order_details`
1386 INSERT INTO `0_purch_order_details` VALUES
1387 ('1', '1', '101', 'iPad Air 2 16GB', '2015-05-15', '0', '200', '200', '200', '100', '100'),
1388 ('2', '1', '102', 'iPhone 6 64GB', '2015-05-15', '0', '150', '150', '150', '100', '100'),
1389 ('3', '1', '103', 'iPhone Cover Case', '2015-05-15', '0', '10', '10', '10', '100', '100'),
1390 ('4', '2', '101', 'iPad Air 2 16GB', '2015-05-05', '15', '200', '200', '200', '15', '15');
1392 -- --------------------------------------------------------
1395 -- Table structure for table `0_quick_entries`
1398 DROP TABLE IF EXISTS `0_quick_entries`;
1399 CREATE TABLE IF NOT EXISTS `0_quick_entries` (
1400 `id` smallint(6) unsigned NOT NULL AUTO_INCREMENT,
1401 `type` tinyint(1) NOT NULL DEFAULT '0',
1402 `description` varchar(60) NOT NULL,
1403 `usage` varchar(120) NULL,
1404 `base_amount` double NOT NULL DEFAULT '0',
1405 `base_desc` varchar(60) DEFAULT NULL,
1406 `bal_type` tinyint(1) NOT NULL DEFAULT '0',
1408 KEY `description` (`description`)
1409 ) ENGINE=InnoDB AUTO_INCREMENT=4 ;
1412 -- Dumping data for table `0_quick_entries`
1415 INSERT INTO `0_quick_entries` VALUES (1, 1, 'Maintenance', NULL, 0, 'Amount', 0);
1416 INSERT INTO `0_quick_entries` VALUES (2, 4, 'Phone', NULL, 0, 'Amount', 0);
1417 INSERT INTO `0_quick_entries` VALUES (3, 2, 'Cash Sales', 'Retail sales without invoice', 0, 'Amount', 0);
1419 -- --------------------------------------------------------
1422 -- Table structure for table `0_quick_entry_lines`
1425 DROP TABLE IF EXISTS `0_quick_entry_lines`;
1426 CREATE TABLE IF NOT EXISTS `0_quick_entry_lines` (
1427 `id` smallint(6) unsigned NOT NULL AUTO_INCREMENT,
1428 `qid` smallint(6) unsigned NOT NULL,
1429 `amount` double DEFAULT '0',
1430 `memo` tinytext NOT NULL,
1431 `action` varchar(2) NOT NULL,
1432 `dest_id` varchar(15) NOT NULL DEFAULT '',
1433 `dimension_id` smallint(6) unsigned DEFAULT NULL,
1434 `dimension2_id` smallint(6) unsigned DEFAULT NULL,
1437 ) ENGINE=InnoDB AUTO_INCREMENT=7 ;
1440 -- Dumping data for table `0_quick_entry_lines`
1443 INSERT INTO `0_quick_entry_lines` VALUES (1, 1, 0, '', 't-', '1', 0, 0);
1444 INSERT INTO `0_quick_entry_lines` VALUES (2, 2, 0, '', 't-', '1', 0, 0);
1445 INSERT INTO `0_quick_entry_lines` VALUES (3, 3, 0, '', 't-', '1', 0, 0);
1446 INSERT INTO `0_quick_entry_lines` VALUES (4, 3, 0, '', '=', '4010', 0, 0);
1447 INSERT INTO `0_quick_entry_lines` VALUES (5, 1, 0, '', '=', '5765', 0, 0);
1448 INSERT INTO `0_quick_entry_lines` VALUES (6, 2, 0, '', '=', '5780', 0, 0);
1450 -- --------------------------------------------------------
1453 -- Table structure for table `0_recurrent_invoices`
1456 DROP TABLE IF EXISTS `0_recurrent_invoices`;
1457 CREATE TABLE IF NOT EXISTS `0_recurrent_invoices` (
1458 `id` smallint(6) unsigned NOT NULL AUTO_INCREMENT,
1459 `description` varchar(60) NOT NULL DEFAULT '',
1460 `order_no` int(11) unsigned NOT NULL,
1461 `debtor_no` int(11) unsigned DEFAULT NULL,
1462 `group_no` smallint(6) unsigned DEFAULT NULL,
1463 `days` int(11) NOT NULL DEFAULT '0',
1464 `monthly` int(11) NOT NULL DEFAULT '0',
1465 `begin` date NOT NULL DEFAULT '0000-00-00',
1466 `end` date NOT NULL DEFAULT '0000-00-00',
1467 `last_sent` date NOT NULL DEFAULT '0000-00-00',
1469 UNIQUE KEY `description` (`description`)
1470 ) ENGINE=InnoDB AUTO_INCREMENT=2 ;
1473 -- Dumping data for table `0_recurrent_invoices`
1476 INSERT INTO `0_recurrent_invoices` VALUES ('1', 'Weekly Maintenance', '6', '1', '1', '7', '0', '2015-04-01', '2020-05-07', '2015-04-08');
1478 -- --------------------------------------------------------
1481 --- Table structure for table `0_reflines`
1484 DROP TABLE IF EXISTS `0_reflines`;
1486 CREATE TABLE `0_reflines` (
1487 `id` int(11) NOT NULL AUTO_INCREMENT,
1488 `trans_type` int(11) NOT NULL,
1489 `prefix` char(5) NOT NULL DEFAULT '',
1490 `pattern` varchar(35) NOT NULL DEFAULT '1',
1491 `description` varchar(60) NOT NULL DEFAULT '',
1492 `default` tinyint(1) NOT NULL DEFAULT '0',
1493 `inactive` tinyint(1) NOT NULL DEFAULT '0',
1495 UNIQUE KEY `prefix` (`trans_type`, `prefix`)
1496 ) ENGINE=InnoDB AUTO_INCREMENT=23;
1499 --- Dumping data for table `0_reflines`
1502 INSERT INTO `0_reflines` VALUES
1503 ('1', '0', '', '{001}/{YYYY}', '', '1', '0'),
1504 ('2', '1', '', '{001}/{YYYY}', '', '1', '0'),
1505 ('3', '2', '', '{001}/{YYYY}', '', '1', '0'),
1506 ('4', '4', '', '{001}/{YYYY}', '', '1', '0'),
1507 ('5', '10', '', '{001}/{YYYY}', '', '1', '0'),
1508 ('6', '11', '', '{001}/{YYYY}', '', '1', '0'),
1509 ('7', '12', '', '{001}/{YYYY}', '', '1', '0'),
1510 ('8', '13', '', '{001}/{YYYY}', '', '1', '0'),
1511 ('9', '16', '', '{001}/{YYYY}', '', '1', '0'),
1512 ('10', '17', '', '{001}/{YYYY}', '', '1', '0'),
1513 ('11', '18', '', '{001}/{YYYY}', '', '1', '0'),
1514 ('12', '20', '', '{001}/{YYYY}', '', '1', '0'),
1515 ('13', '21', '', '{001}/{YYYY}', '', '1', '0'),
1516 ('14', '22', '', '{001}/{YYYY}', '', '1', '0'),
1517 ('15', '25', '', '{001}/{YYYY}', '', '1', '0'),
1518 ('16', '26', '', '{001}/{YYYY}', '', '1', '0'),
1519 ('17', '28', '', '{001}/{YYYY}', '', '1', '0'),
1520 ('18', '29', '', '{001}/{YYYY}', '', '1', '0'),
1521 ('19', '30', '', '{001}/{YYYY}', '', '1', '0'),
1522 ('20', '32', '', '{001}/{YYYY}', '', '1', '0'),
1523 ('21', '35', '', '{001}/{YYYY}', '', '1', '0'),
1524 ('22', '40', '', '{001}/{YYYY}', '', '1', '0');
1526 -- --------------------------------------------------------
1529 -- Table structure for table `0_refs`
1532 DROP TABLE IF EXISTS `0_refs`;
1533 CREATE TABLE IF NOT EXISTS `0_refs` (
1534 `id` int(11) NOT NULL DEFAULT '0',
1535 `type` int(11) NOT NULL DEFAULT '0',
1536 `reference` varchar(100) NOT NULL DEFAULT '',
1537 PRIMARY KEY (`id`,`type`),
1538 KEY `Type_and_Reference` (`type`,`reference`)
1542 -- Dumping data for table `0_refs`
1545 INSERT INTO `0_refs` VALUES
1546 ('1', '1', '001/2015'),
1547 ('1', '10', '001/2015'),
1548 ('2', '10', '002/2015'),
1549 ('3', '10', '003/2015'),
1550 ('4', '10', '004/2015'),
1551 ('1', '12', '001/2015'),
1552 ('2', '12', '002/2015'),
1553 ('3', '12', '003/2015'),
1554 ('1', '18', '001/2015'),
1555 ('1', '20', '001/2015'),
1556 ('1', '25', '001/2015'),
1557 ('1', '26', '001/2015'),
1558 ('2', '26', '002/2015'),
1559 ('3', '26', '003/2015'),
1560 ('3', '30', '001/2015'),
1561 ('4', '30', '002/2015'),
1562 ('6', '30', '003/2015'),
1563 ('1', '40', '001/2015');
1565 -- --------------------------------------------------------
1568 -- Table structure for table `0_salesman`
1571 DROP TABLE IF EXISTS `0_salesman`;
1572 CREATE TABLE IF NOT EXISTS `0_salesman` (
1573 `salesman_code` int(11) NOT NULL AUTO_INCREMENT,
1574 `salesman_name` char(60) NOT NULL DEFAULT '',
1575 `salesman_phone` char(30) NOT NULL DEFAULT '',
1576 `salesman_fax` char(30) NOT NULL DEFAULT '',
1577 `salesman_email` varchar(100) NOT NULL DEFAULT '',
1578 `provision` double NOT NULL DEFAULT '0',
1579 `break_pt` double NOT NULL DEFAULT '0',
1580 `provision2` double NOT NULL DEFAULT '0',
1581 `inactive` tinyint(1) NOT NULL DEFAULT '0',
1582 PRIMARY KEY (`salesman_code`),
1583 UNIQUE KEY `salesman_name` (`salesman_name`)
1584 ) ENGINE=InnoDB AUTO_INCREMENT=2 ;
1587 -- Dumping data for table `0_salesman`
1590 INSERT INTO `0_salesman` VALUES (1, 'Sales Person', '', '', '', 5, 1000, 4, 0);
1592 -- --------------------------------------------------------
1595 -- Table structure for table `0_sales_orders`
1598 DROP TABLE IF EXISTS `0_sales_orders`;
1599 CREATE TABLE IF NOT EXISTS `0_sales_orders` (
1600 `order_no` int(11) NOT NULL,
1601 `trans_type` smallint(6) NOT NULL DEFAULT '30',
1602 `version` tinyint(1) unsigned NOT NULL DEFAULT '0',
1603 `type` tinyint(1) NOT NULL DEFAULT '0',
1604 `debtor_no` int(11) NOT NULL DEFAULT '0',
1605 `branch_code` int(11) NOT NULL DEFAULT '0',
1606 `reference` varchar(100) NOT NULL DEFAULT '',
1607 `customer_ref` tinytext NOT NULL,
1608 `comments` tinytext,
1609 `ord_date` date NOT NULL DEFAULT '0000-00-00',
1610 `order_type` int(11) NOT NULL DEFAULT '0',
1611 `ship_via` int(11) NOT NULL DEFAULT '0',
1612 `delivery_address` tinytext NOT NULL,
1613 `contact_phone` varchar(30) DEFAULT NULL,
1614 `contact_email` varchar(100) DEFAULT NULL,
1615 `deliver_to` tinytext NOT NULL,
1616 `freight_cost` double NOT NULL DEFAULT '0',
1617 `from_stk_loc` varchar(5) NOT NULL DEFAULT '',
1618 `delivery_date` date NOT NULL DEFAULT '0000-00-00',
1619 `payment_terms` int(11) DEFAULT NULL,
1620 `total` double NOT NULL DEFAULT '0',
1621 `prep_amount` double NOT NULL DEFAULT '0',
1622 `alloc` double NOT NULL DEFAULT '0',
1623 PRIMARY KEY (`trans_type`,`order_no`)
1627 -- Dumping data for table `0_sales_orders`
1630 INSERT INTO `0_sales_orders` VALUES
1631 ('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'),
1632 ('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'),
1633 ('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'),
1634 ('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'),
1635 ('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'),
1636 ('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'),
1637 ('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');
1639 -- --------------------------------------------------------
1642 -- Table structure for table `0_sales_order_details`
1645 DROP TABLE IF EXISTS `0_sales_order_details`;
1646 CREATE TABLE IF NOT EXISTS `0_sales_order_details` (
1647 `id` int(11) NOT NULL AUTO_INCREMENT,
1648 `order_no` int(11) NOT NULL DEFAULT '0',
1649 `trans_type` smallint(6) NOT NULL DEFAULT '30',
1650 `stk_code` varchar(20) NOT NULL DEFAULT '',
1651 `description` tinytext,
1652 `qty_sent` double NOT NULL DEFAULT '0',
1653 `unit_price` double NOT NULL DEFAULT '0',
1654 `quantity` double NOT NULL DEFAULT '0',
1655 `invoiced` double NOT NULL DEFAULT '0',
1656 `discount_percent` double NOT NULL DEFAULT '0',
1658 KEY `sorder` (`trans_type`,`order_no`),
1659 KEY `stkcode` (`stk_code`)
1660 ) ENGINE=InnoDB AUTO_INCREMENT=11 ;
1663 -- Dumping data for table `0_sales_order_details`
1666 INSERT INTO `0_sales_order_details` VALUES
1667 ('1', '1', '30', '101', 'iPad Air 2 16GB', '20', '300', '20', '0', '0'),
1668 ('2', '1', '30', '301', 'Support', '3', '80', '3', '0', '0'),
1669 ('3', '2', '30', '101', 'iPad Air 2 16GB', '1', '300', '1', '0', '0'),
1670 ('4', '3', '30', '102', 'iPhone 6 64GB', '0', '250', '1', '0', '0'),
1671 ('5', '3', '30', '103', 'iPhone Cover Case', '0', '50', '1', '0', '0'),
1672 ('6', '4', '30', '101', 'iPad Air 2 16GB', '0', '267.14', '1', '0', '0'),
1673 ('7', '5', '30', '102', 'iPhone 6 64GB', '1', '222.62', '1', '0', '0'),
1674 ('8', '5', '30', '103', 'iPhone Cover Case', '1', '44.52', '1', '0', '0'),
1675 ('9', '6', '30', '202', 'Maintenance', '0', '90', '5', '0', '0'),
1676 ('10', '7', '30', '202', 'Maintenance', '5', '0', '5', '0', '0');
1678 -- --------------------------------------------------------
1681 -- Table structure for table `0_sales_pos`
1684 DROP TABLE IF EXISTS `0_sales_pos`;
1685 CREATE TABLE IF NOT EXISTS `0_sales_pos` (
1686 `id` smallint(6) unsigned NOT NULL AUTO_INCREMENT,
1687 `pos_name` varchar(30) NOT NULL,
1688 `cash_sale` tinyint(1) NOT NULL,
1689 `credit_sale` tinyint(1) NOT NULL,
1690 `pos_location` varchar(5) NOT NULL,
1691 `pos_account` smallint(6) unsigned NOT NULL,
1692 `inactive` tinyint(1) NOT NULL DEFAULT '0',
1694 UNIQUE KEY `pos_name` (`pos_name`)
1695 ) ENGINE=InnoDB AUTO_INCREMENT=2 ;
1698 -- Dumping data for table `0_sales_pos`
1701 INSERT INTO `0_sales_pos` VALUES (1, 'Default', 1, 1, 'DEF', 2, 0);
1703 -- --------------------------------------------------------
1706 -- Table structure for table `0_sales_types`
1709 DROP TABLE IF EXISTS `0_sales_types`;
1710 CREATE TABLE IF NOT EXISTS `0_sales_types` (
1711 `id` int(11) NOT NULL AUTO_INCREMENT,
1712 `sales_type` char(50) NOT NULL DEFAULT '',
1713 `tax_included` int(1) NOT NULL DEFAULT '0',
1714 `factor` double NOT NULL DEFAULT '1',
1715 `inactive` tinyint(1) NOT NULL DEFAULT '0',
1717 UNIQUE KEY `sales_type` (`sales_type`)
1718 ) ENGINE=InnoDB AUTO_INCREMENT=3 ;
1721 -- Dumping data for table `0_sales_types`
1724 INSERT INTO `0_sales_types` VALUES (1, 'Retail', 1, 1, 0);
1725 INSERT INTO `0_sales_types` VALUES (2, 'Wholesale', 0, 0.7, 0);
1727 -- --------------------------------------------------------
1730 -- Table structure for table `0_security_roles`
1733 DROP TABLE IF EXISTS `0_security_roles`;
1734 CREATE TABLE IF NOT EXISTS `0_security_roles` (
1735 `id` int(11) NOT NULL AUTO_INCREMENT,
1736 `role` varchar(30) NOT NULL,
1737 `description` varchar(50) DEFAULT NULL,
1740 `inactive` tinyint(1) NOT NULL DEFAULT '0',
1742 UNIQUE KEY `role` (`role`)
1743 ) ENGINE=InnoDB AUTO_INCREMENT=11 ;
1746 -- Dumping data for table `0_security_roles`
1749 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);
1750 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);
1751 INSERT INTO `0_security_roles` VALUES (3, 'Salesman', 'Salesman', '768;3072;5632;8192;15872', '773;774;3073;3075;3081;5633;8194;15873;775', 0);
1752 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);
1753 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);
1754 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);
1755 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);
1756 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);
1757 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);
1758 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);
1760 -- --------------------------------------------------------
1763 -- Table structure for table `0_shippers`
1766 DROP TABLE IF EXISTS `0_shippers`;
1767 CREATE TABLE IF NOT EXISTS `0_shippers` (
1768 `shipper_id` int(11) NOT NULL AUTO_INCREMENT,
1769 `shipper_name` varchar(60) NOT NULL DEFAULT '',
1770 `phone` varchar(30) NOT NULL DEFAULT '',
1771 `phone2` varchar(30) NOT NULL DEFAULT '',
1772 `contact` tinytext NOT NULL,
1773 `address` tinytext NOT NULL,
1774 `inactive` tinyint(1) NOT NULL DEFAULT '0',
1775 PRIMARY KEY (`shipper_id`),
1776 UNIQUE KEY `name` (`shipper_name`)
1777 ) ENGINE=InnoDB AUTO_INCREMENT=2 ;
1780 -- Dumping data for table `0_shippers`
1783 INSERT INTO `0_shippers` VALUES (1, 'Default', '', '', '', '', 0);
1785 -- --------------------------------------------------------
1788 -- Table structure for table `0_sql_trail`
1791 DROP TABLE IF EXISTS `0_sql_trail`;
1792 CREATE TABLE IF NOT EXISTS `0_sql_trail` (
1793 `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
1794 `sql` text NOT NULL,
1795 `result` tinyint(1) NOT NULL,
1796 `msg` varchar(255) NOT NULL,
1801 -- Dumping data for table `0_sql_trail`
1804 -- --------------------------------------------------------
1807 -- Table structure for table `0_stock_category`
1810 DROP TABLE IF EXISTS `0_stock_category`;
1811 CREATE TABLE IF NOT EXISTS `0_stock_category` (
1812 `category_id` int(11) NOT NULL AUTO_INCREMENT,
1813 `description` varchar(60) NOT NULL DEFAULT '',
1814 `dflt_tax_type` int(11) NOT NULL DEFAULT '1',
1815 `dflt_units` varchar(20) NOT NULL DEFAULT 'each',
1816 `dflt_mb_flag` char(1) NOT NULL DEFAULT 'B',
1817 `dflt_sales_act` varchar(15) NOT NULL DEFAULT '',
1818 `dflt_cogs_act` varchar(15) NOT NULL DEFAULT '',
1819 `dflt_inventory_act` varchar(15) NOT NULL DEFAULT '',
1820 `dflt_adjustment_act` varchar(15) NOT NULL DEFAULT '',
1821 `dflt_assembly_act` varchar(15) NOT NULL DEFAULT '',
1822 `dflt_dim1` int(11) DEFAULT NULL,
1823 `dflt_dim2` int(11) DEFAULT NULL,
1824 `inactive` tinyint(1) NOT NULL DEFAULT '0',
1825 `dflt_no_sale` tinyint(1) NOT NULL DEFAULT '0',
1826 `dflt_no_purchase` tinyint(1) NOT NULL DEFAULT '0',
1827 PRIMARY KEY (`category_id`),
1828 UNIQUE KEY `description` (`description`)
1829 ) ENGINE=InnoDB AUTO_INCREMENT=5 ;
1832 -- Dumping data for table `0_stock_category`
1835 INSERT INTO `0_stock_category` VALUES (1, 'Components', 1, 'each', 'B', '4010', '5010', '1510', '5040', '1530', 0, 0, 0, 0, 0);
1836 INSERT INTO `0_stock_category` VALUES (2, 'Charges', 1, 'each', 'D', '4010', '5010', '1510', '5040', '1530', 0, 0, 0, 0, 0);
1837 INSERT INTO `0_stock_category` VALUES (3, 'Systems', 1, 'each', 'M', '4010', '5010', '1510', '5040', '1530', 0, 0, 0, 0, 0);
1838 INSERT INTO `0_stock_category` VALUES (4, 'Services', 1, 'hr', 'D', '4010', '5010', '1510', '5040', '1530', 0, 0, 0, 0, 0);
1840 -- --------------------------------------------------------
1843 -- Structure of table `0_stock_fa_class` ###
1846 DROP TABLE IF EXISTS `0_stock_fa_class`;
1847 CREATE TABLE `0_stock_fa_class` (
1848 `fa_class_id` varchar(20) NOT NULL DEFAULT '',
1849 `parent_id` varchar(20) NOT NULL DEFAULT '',
1850 `description` varchar(200) NOT NULL DEFAULT '',
1851 `long_description` tinytext NOT NULL,
1852 `depreciation_rate` double NOT NULL DEFAULT '0',
1853 `inactive` tinyint(1) NOT NULL DEFAULT '0',
1854 PRIMARY KEY (`fa_class_id`)
1857 -- --------------------------------------------------------
1860 -- Table structure for table `0_stock_master`
1863 DROP TABLE IF EXISTS `0_stock_master`;
1864 CREATE TABLE IF NOT EXISTS `0_stock_master` (
1865 `stock_id` varchar(20) NOT NULL DEFAULT '',
1866 `category_id` int(11) NOT NULL DEFAULT '0',
1867 `tax_type_id` int(11) NOT NULL DEFAULT '0',
1868 `description` varchar(200) NOT NULL DEFAULT '',
1869 `long_description` tinytext NOT NULL,
1870 `units` varchar(20) NOT NULL DEFAULT 'each',
1871 `mb_flag` char(1) NOT NULL DEFAULT 'B',
1872 `sales_account` varchar(15) NOT NULL DEFAULT '',
1873 `cogs_account` varchar(15) NOT NULL DEFAULT '',
1874 `inventory_account` varchar(15) NOT NULL DEFAULT '',
1875 `adjustment_account` varchar(15) NOT NULL DEFAULT '',
1876 `assembly_account` varchar(15) NOT NULL DEFAULT '',
1877 `dimension_id` int(11) DEFAULT NULL,
1878 `dimension2_id` int(11) DEFAULT NULL,
1879 `purchase_cost` double NOT NULL DEFAULT '0',
1880 `material_cost` double NOT NULL DEFAULT '0',
1881 `labour_cost` double NOT NULL DEFAULT '0',
1882 `overhead_cost` double NOT NULL DEFAULT '0',
1883 `inactive` tinyint(1) NOT NULL DEFAULT '0',
1884 `no_sale` tinyint(1) NOT NULL DEFAULT '0',
1885 `no_purchase` tinyint(1) NOT NULL DEFAULT '0',
1886 `editable` tinyint(1) NOT NULL DEFAULT '0',
1887 `depreciation_method` char(1) NOT NULL DEFAULT 'S',
1888 `depreciation_rate` double NOT NULL DEFAULT '0',
1889 `depreciation_factor` double NOT NULL DEFAULT '1',
1890 `depreciation_start` date NOT NULL DEFAULT '0000-00-00',
1891 `depreciation_date` date NOT NULL DEFAULT '0000-00-00',
1892 `fa_class_id` varchar(20) NOT NULL DEFAULT '',
1893 PRIMARY KEY (`stock_id`)
1897 -- Dumping data for table `0_stock_master`
1900 INSERT INTO `0_stock_master` VALUES
1901 ('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', ''),
1902 ('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', ''),
1903 ('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', ''),
1904 ('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', ''),
1905 ('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', ''),
1906 ('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', '');
1908 -- --------------------------------------------------------
1911 -- Table structure for table `0_stock_moves`
1914 DROP TABLE IF EXISTS `0_stock_moves`;
1915 CREATE TABLE `0_stock_moves` (
1916 `trans_id` int(11) NOT NULL AUTO_INCREMENT,
1917 `trans_no` int(11) NOT NULL DEFAULT '0',
1918 `stock_id` char(20) NOT NULL DEFAULT '',
1919 `type` smallint(6) NOT NULL DEFAULT '0',
1920 `loc_code` char(5) NOT NULL DEFAULT '',
1921 `tran_date` date NOT NULL DEFAULT '0000-00-00',
1922 `price` double NOT NULL DEFAULT '0',
1923 `reference` char(40) NOT NULL DEFAULT '',
1924 `qty` double NOT NULL DEFAULT '1',
1925 `standard_cost` double NOT NULL DEFAULT '0',
1926 PRIMARY KEY (`trans_id`),
1927 KEY `type` (`type`,`trans_no`),
1928 KEY `Move` (`stock_id`,`loc_code`,`tran_date`)
1929 ) ENGINE=InnoDB AUTO_INCREMENT=16 ;
1932 -- Dumping data for table `0_stock_moves`
1935 INSERT INTO `0_stock_moves` VALUES
1936 ('1', '1', '101', '25', 'DEF', '2015-05-05', '200', '', '100', '200'),
1937 ('2', '1', '102', '25', 'DEF', '2015-05-05', '150', '', '100', '150'),
1938 ('3', '1', '103', '25', 'DEF', '2015-05-05', '10', '', '100', '10'),
1939 ('4', '1', '101', '13', 'DEF', '2015-05-10', '300', 'auto', '-20', '200'),
1940 ('5', '1', '301', '13', 'DEF', '2015-05-10', '80', 'auto', '-3', '0'),
1941 ('6', '1', '101', '26', 'DEF', '2015-05-05', '200', '001/2015', '-2', '200'),
1942 ('7', '1', '102', '26', 'DEF', '2015-05-05', '150', '001/2015', '-2', '150'),
1943 ('8', '1', '103', '26', 'DEF', '2015-05-05', '10', '001/2015', '-2', '10'),
1944 ('9', '1', '301', '26', 'DEF', '2015-05-05', '0', '001/2015', '-2', '0'),
1945 ('10', '1', '201', '26', 'DEF', '2015-05-05', '0', '001/2015', '2', '0'),
1946 ('11', '2', '101', '25', 'DEF', '2015-05-05', '200', '', '15', '200'),
1947 ('12', '2', '101', '13', 'DEF', '2015-05-07', '300', 'auto', '-1', '200'),
1948 ('13', '3', '102', '13', 'DEF', '2015-05-07', '222.62', 'auto', '-1', '150'),
1949 ('14', '3', '103', '13', 'DEF', '2015-05-07', '44.52', 'auto', '-1', '10'),
1950 ('15', '4', '202', '13', 'DEF', '2015-05-07', '0', 'auto', '-5', '0');
1952 -- --------------------------------------------------------
1955 -- Table structure for table `0_suppliers`
1958 DROP TABLE IF EXISTS `0_suppliers`;
1959 CREATE TABLE IF NOT EXISTS `0_suppliers` (
1960 `supplier_id` int(11) NOT NULL AUTO_INCREMENT,
1961 `supp_name` varchar(60) NOT NULL DEFAULT '',
1962 `supp_ref` varchar(30) NOT NULL DEFAULT '',
1963 `address` tinytext NOT NULL,
1964 `supp_address` tinytext NOT NULL,
1965 `gst_no` varchar(25) NOT NULL DEFAULT '',
1966 `contact` varchar(60) NOT NULL DEFAULT '',
1967 `supp_account_no` varchar(40) NOT NULL DEFAULT '',
1968 `website` varchar(100) NOT NULL DEFAULT '',
1969 `bank_account` varchar(60) NOT NULL DEFAULT '',
1970 `curr_code` char(3) DEFAULT NULL,
1971 `payment_terms` int(11) DEFAULT NULL,
1972 `tax_included` tinyint(1) NOT NULL DEFAULT '0',
1973 `dimension_id` int(11) DEFAULT '0',
1974 `dimension2_id` int(11) DEFAULT '0',
1975 `tax_group_id` int(11) DEFAULT NULL,
1976 `credit_limit` double NOT NULL DEFAULT '0',
1977 `purchase_account` varchar(15) NOT NULL DEFAULT '',
1978 `payable_account` varchar(15) NOT NULL DEFAULT '',
1979 `payment_discount_account` varchar(15) NOT NULL DEFAULT '',
1980 `notes` tinytext NOT NULL,
1981 `inactive` tinyint(1) NOT NULL DEFAULT '0',
1982 PRIMARY KEY (`supplier_id`),
1983 KEY `supp_ref` (`supp_ref`)
1984 ) ENGINE=InnoDB AUTO_INCREMENT=3 ;
1987 -- Dumping data for table `0_suppliers`
1990 INSERT INTO `0_suppliers` VALUES
1991 ('1', 'Dino Saurius Inc.', 'Dino Saurius', 'N/A', '', '987654321', '', '', '', '', 'USD', '3', '0', '0', '0', '1', '0', '', '2100', '5060', '', '0'),
1992 ('2', 'Beefeater Ltd.', 'Beefeater', 'N/A', '', '67565590', '', '', '', '', 'GBP', '4', '0', '0', '0', '1', '0', '', '2100', '5060', '', '0');
1994 -- --------------------------------------------------------
1997 -- Table structure for table `0_supp_allocations`
2000 DROP TABLE IF EXISTS `0_supp_allocations`;
2001 CREATE TABLE IF NOT EXISTS `0_supp_allocations` (
2002 `id` int(11) NOT NULL AUTO_INCREMENT,
2003 `person_id` int(11) DEFAULT NULL,
2004 `amt` double unsigned DEFAULT NULL,
2005 `date_alloc` date NOT NULL DEFAULT '0000-00-00',
2006 `trans_no_from` int(11) DEFAULT NULL,
2007 `trans_type_from` int(11) DEFAULT NULL,
2008 `trans_no_to` int(11) DEFAULT NULL,
2009 `trans_type_to` int(11) DEFAULT NULL,
2011 UNIQUE KEY `trans_type_from` (`person_id`,`trans_type_from`,`trans_no_from`,`trans_type_to`,`trans_no_to`),
2012 KEY `From` (`trans_type_from`,`trans_no_from`),
2013 KEY `To` (`trans_type_to`,`trans_no_to`)
2017 -- Dumping data for table `0_supp_allocations`
2020 -- --------------------------------------------------------
2023 -- Table structure for table `0_supp_invoice_items`
2026 DROP TABLE IF EXISTS `0_supp_invoice_items`;
2027 CREATE TABLE IF NOT EXISTS `0_supp_invoice_items` (
2028 `id` int(11) NOT NULL AUTO_INCREMENT,
2029 `supp_trans_no` int(11) DEFAULT NULL,
2030 `supp_trans_type` int(11) DEFAULT NULL,
2031 `gl_code` varchar(15) NOT NULL DEFAULT '',
2032 `grn_item_id` int(11) DEFAULT NULL,
2033 `po_detail_item_id` int(11) DEFAULT NULL,
2034 `stock_id` varchar(20) NOT NULL DEFAULT '',
2035 `description` tinytext,
2036 `quantity` double NOT NULL DEFAULT '0',
2037 `unit_price` double NOT NULL DEFAULT '0',
2038 `unit_tax` double NOT NULL DEFAULT '0',
2040 `dimension_id` int(11) NOT NULL DEFAULT '0',
2041 `dimension2_id` int(11) NOT NULL DEFAULT '0',
2043 KEY `Transaction` (`supp_trans_type`,`supp_trans_no`,`stock_id`)
2044 ) ENGINE=InnoDB AUTO_INCREMENT=2 ;
2047 -- Dumping data for table `0_supp_invoice_items`
2050 INSERT INTO `0_supp_invoice_items` VALUES ('1', '1', '20', '0', '4', '4', '101', 'iPad Air 2 16GB', '15', '200', '10', NULL, '0', '0');
2052 -- --------------------------------------------------------
2055 -- Table structure for table `0_supp_trans`
2058 DROP TABLE IF EXISTS `0_supp_trans`;
2059 CREATE TABLE IF NOT EXISTS `0_supp_trans` (
2060 `trans_no` int(11) unsigned NOT NULL DEFAULT '0',
2061 `type` smallint(6) unsigned NOT NULL DEFAULT '0',
2062 `supplier_id` int(11) unsigned DEFAULT NULL,
2063 `reference` tinytext NOT NULL,
2064 `supp_reference` varchar(60) NOT NULL DEFAULT '',
2065 `tran_date` date NOT NULL DEFAULT '0000-00-00',
2066 `due_date` date NOT NULL DEFAULT '0000-00-00',
2067 `ov_amount` double NOT NULL DEFAULT '0',
2068 `ov_discount` double NOT NULL DEFAULT '0',
2069 `ov_gst` double NOT NULL DEFAULT '0',
2070 `rate` double NOT NULL DEFAULT '1',
2071 `alloc` double NOT NULL DEFAULT '0',
2072 `tax_included` tinyint(1) NOT NULL DEFAULT '0',
2073 PRIMARY KEY (`type`,`trans_no`),
2074 KEY `supplier_id` (`supplier_id`),
2075 KEY `tran_date` (`tran_date`)
2079 -- Dumping data for table `0_supp_trans`
2083 INSERT INTO `0_supp_trans` VALUES ('1', '20', '1', '001/2015', 'rr4', '2015-05-05', '2015-05-15', '3000', '0', '150', '1', '0', '0');
2085 -- --------------------------------------------------------
2088 -- Table structure for table `0_sys_prefs`
2091 DROP TABLE IF EXISTS `0_sys_prefs`;
2092 CREATE TABLE IF NOT EXISTS `0_sys_prefs` (
2093 `name` varchar(35) NOT NULL DEFAULT '',
2094 `category` varchar(30) DEFAULT NULL,
2095 `type` varchar(20) NOT NULL DEFAULT '',
2096 `length` smallint(6) DEFAULT NULL,
2097 `value` text NOT NULL DEFAULT '',
2098 PRIMARY KEY (`name`),
2099 KEY `category` (`category`)
2103 -- Dumping data for table `0_sys_prefs`
2106 INSERT INTO `0_sys_prefs` VALUES ('coy_name', 'setup.company', 'varchar', 60, 'Training Co');
2107 INSERT INTO `0_sys_prefs` VALUES ('gst_no', 'setup.company', 'varchar', 25, '33445566');
2108 INSERT INTO `0_sys_prefs` VALUES ('coy_no', 'setup.company', 'varchar', 25, '');
2109 INSERT INTO `0_sys_prefs` VALUES ('tax_prd', 'setup.company', 'int', 11, '1');
2110 INSERT INTO `0_sys_prefs` VALUES ('tax_last', 'setup.company', 'int', 11, '1');
2111 INSERT INTO `0_sys_prefs` VALUES ('postal_address', 'setup.company', 'tinytext', 0, 'N/A');
2112 INSERT INTO `0_sys_prefs` VALUES ('phone', 'setup.company', 'varchar', 30, '');
2113 INSERT INTO `0_sys_prefs` VALUES ('fax', 'setup.company', 'varchar', 30, '');
2114 INSERT INTO `0_sys_prefs` VALUES ('email', 'setup.company', 'varchar', 100, 'delta@delta.com');
2115 INSERT INTO `0_sys_prefs` VALUES ('coy_logo', 'setup.company', 'varchar', 100, 'logo_frontaccounting.jpg');
2116 INSERT INTO `0_sys_prefs` VALUES ('domicile', 'setup.company', 'varchar', 55, '');
2117 INSERT INTO `0_sys_prefs` VALUES ('curr_default', 'setup.company', 'char', 3, 'USD');
2118 INSERT INTO `0_sys_prefs` VALUES ('use_dimension', 'setup.company', 'tinyint', 1, '1');
2119 INSERT INTO `0_sys_prefs` VALUES ('f_year', 'setup.company', 'int', 11, '1');
2120 INSERT INTO `0_sys_prefs` VALUES ('no_item_list', 'setup.company', 'tinyint', 1, '0');
2121 INSERT INTO `0_sys_prefs` VALUES ('no_customer_list', 'setup.company', 'tinyint', 1, '0');
2122 INSERT INTO `0_sys_prefs` VALUES ('no_supplier_list', 'setup.company', 'tinyint', 1, '0');
2123 INSERT INTO `0_sys_prefs` VALUES ('base_sales', 'setup.company', 'int', 11, '1');
2124 INSERT INTO `0_sys_prefs` VALUES ('time_zone', 'setup.company', 'tinyint', 1, '0');
2125 INSERT INTO `0_sys_prefs` VALUES ('add_pct', 'setup.company', 'int', 5, '-1');
2126 INSERT INTO `0_sys_prefs` VALUES ('round_to', 'setup.company', 'int', 5, '1');
2127 INSERT INTO `0_sys_prefs` VALUES ('login_tout', 'setup.company', 'smallint', 6, '600');
2128 INSERT INTO `0_sys_prefs` VALUES ('past_due_days', 'glsetup.general', 'int', 11, '30');
2129 INSERT INTO `0_sys_prefs` VALUES ('profit_loss_year_act', 'glsetup.general', 'varchar', 15, '9990');
2130 INSERT INTO `0_sys_prefs` VALUES ('retained_earnings_act', 'glsetup.general', 'varchar', 15, '3590');
2131 INSERT INTO `0_sys_prefs` VALUES ('bank_charge_act', 'glsetup.general', 'varchar', 15, '5690');
2132 INSERT INTO `0_sys_prefs` VALUES ('exchange_diff_act', 'glsetup.general', 'varchar', 15, '4450');
2133 INSERT INTO `0_sys_prefs` VALUES ('tax_algorithm', 'glsetup.customer', 'tinyint', 1, '1');
2134 INSERT INTO `0_sys_prefs` VALUES ('default_credit_limit', 'glsetup.customer', 'int', 11, '1000');
2135 INSERT INTO `0_sys_prefs` VALUES ('accumulate_shipping', 'glsetup.customer', 'tinyint', 1, '0');
2136 INSERT INTO `0_sys_prefs` VALUES ('legal_text', 'glsetup.customer', 'tinytext', 0, '');
2137 INSERT INTO `0_sys_prefs` VALUES ('freight_act', 'glsetup.customer', 'varchar', 15, '4430');
2138 INSERT INTO `0_sys_prefs` VALUES ('debtors_act', 'glsetup.sales', 'varchar', 15, '1200');
2139 INSERT INTO `0_sys_prefs` VALUES ('default_sales_act', 'glsetup.sales', 'varchar', 15, '4010');
2140 INSERT INTO `0_sys_prefs` VALUES ('default_sales_discount_act', 'glsetup.sales', 'varchar', 15, '4510');
2141 INSERT INTO `0_sys_prefs` VALUES ('default_prompt_payment_act', 'glsetup.sales', 'varchar', 15, '4500');
2142 INSERT INTO `0_sys_prefs` VALUES ('default_delivery_required', 'glsetup.sales', 'smallint', 6, '1');
2143 INSERT INTO `0_sys_prefs` VALUES ('default_receival_required', 'glsetup.purchase', 'smallint', 6, '10');
2144 INSERT INTO `0_sys_prefs` VALUES ('default_quote_valid_days', 'glsetup.sales', 'smallint', 6, '30');
2145 INSERT INTO `0_sys_prefs` VALUES ('default_dim_required', 'glsetup.dims', 'int', 11, '20');
2146 INSERT INTO `0_sys_prefs` VALUES ('pyt_discount_act', 'glsetup.purchase', 'varchar', 15, '5060');
2147 INSERT INTO `0_sys_prefs` VALUES ('creditors_act', 'glsetup.purchase', 'varchar', 15, '2100');
2148 INSERT INTO `0_sys_prefs` VALUES ('po_over_receive', 'glsetup.purchase', 'int', 11, '10');
2149 INSERT INTO `0_sys_prefs` VALUES ('po_over_charge', 'glsetup.purchase', 'int', 11, '10');
2150 INSERT INTO `0_sys_prefs` VALUES ('allow_negative_stock', 'glsetup.inventory', 'tinyint', 1, '0');
2151 INSERT INTO `0_sys_prefs` VALUES ('default_inventory_act', 'glsetup.items', 'varchar', 15, '1510');
2152 INSERT INTO `0_sys_prefs` VALUES ('default_cogs_act', 'glsetup.items', 'varchar', 15, '5010');
2153 INSERT INTO `0_sys_prefs` VALUES ('default_adj_act', 'glsetup.items', 'varchar', 15, '5040');
2154 INSERT INTO `0_sys_prefs` VALUES ('default_inv_sales_act', 'glsetup.items', 'varchar', 15, '4010');
2155 INSERT INTO `0_sys_prefs` VALUES ('default_assembly_act', 'glsetup.items', 'varchar', 15, '1530');
2156 INSERT INTO `0_sys_prefs` VALUES ('default_workorder_required', 'glsetup.manuf', 'int', 11, '20');
2157 INSERT INTO `0_sys_prefs` VALUES ('version_id', 'system', 'varchar', 11, '2.4.1');
2158 INSERT INTO `0_sys_prefs` VALUES ('auto_curr_reval', 'setup.company', 'smallint', 6, '1');
2159 INSERT INTO `0_sys_prefs` VALUES ('grn_clearing_act', 'glsetup.purchase', 'varchar', 15, '1550');
2160 INSERT INTO `0_sys_prefs` VALUES ('bcc_email', 'setup.company', 'varchar', 100, '');
2161 INSERT INTO `0_sys_prefs` VALUES ('deferred_income_act', 'glsetup.sales', 'varchar', '15', '');
2162 INSERT INTO `0_sys_prefs` VALUES ('gl_closing_date','setup.closing_date', 'date', 8, '');
2163 INSERT INTO `0_sys_prefs` VALUES ('alternative_tax_include_on_docs','setup.company', 'tinyint', 1, '0');
2164 INSERT INTO `0_sys_prefs` VALUES ('no_zero_lines_amount','glsetup.sales', 'tinyint', 1, '1');
2165 INSERT INTO `0_sys_prefs` VALUES ('show_po_item_codes','glsetup.purchase', 'tinyint', 1, '0');
2166 INSERT INTO `0_sys_prefs` VALUES ('accounts_alpha','glsetup.general', 'tinyint', 1, '0');
2167 INSERT INTO `0_sys_prefs` VALUES ('loc_notification','glsetup.inventory', 'tinyint', 1, '0');
2168 INSERT INTO `0_sys_prefs` VALUES ('print_invoice_no','glsetup.sales', 'tinyint', 1, '0');
2169 INSERT INTO `0_sys_prefs` VALUES ('allow_negative_prices','glsetup.inventory', 'tinyint', 1, '1');
2170 INSERT INTO `0_sys_prefs` VALUES ('print_item_images_on_quote','glsetup.inventory', 'tinyint', 1, '0');
2171 INSERT INTO `0_sys_prefs` VALUES ('suppress_tax_rates','setup.company', 'tinyint', 1, '0');
2172 INSERT INTO `0_sys_prefs` VALUES ('default_loss_on_asset_disposal_act', 'glsetup.items', 'varchar', '15', '5660');
2173 INSERT INTO `0_sys_prefs` VALUES ('depreciation_period', 'glsetup.company', 'tinyint', '1', '1');
2174 INSERT INTO `0_sys_prefs` VALUES ('use_manufacturing','setup.company', 'tinyint', 1, '1');
2175 INSERT INTO `0_sys_prefs` VALUES ('use_fixed_assets','setup.company', 'tinyint', 1, '1');
2176 INSERT INTO `0_sys_prefs` VALUES ('wip_act', 'glsetup.manuf', 'varchar', '15', '1530');
2179 -- --------------------------------------------------------
2182 -- Table structure for table `0_tags`
2185 DROP TABLE IF EXISTS `0_tags`;
2186 CREATE TABLE IF NOT EXISTS `0_tags` (
2187 `id` int(11) NOT NULL AUTO_INCREMENT,
2188 `type` smallint(6) NOT NULL,
2189 `name` varchar(30) NOT NULL,
2190 `description` varchar(60) DEFAULT NULL,
2191 `inactive` tinyint(1) NOT NULL DEFAULT '0',
2193 UNIQUE KEY `type` (`type`,`name`)
2197 -- Dumping data for table `0_tags`
2200 -- --------------------------------------------------------
2203 -- Table structure for table `0_tag_associations`
2206 DROP TABLE IF EXISTS `0_tag_associations`;
2207 CREATE TABLE IF NOT EXISTS `0_tag_associations` (
2208 `record_id` varchar(15) NOT NULL,
2209 `tag_id` int(11) NOT NULL,
2210 UNIQUE KEY `record_id` (`record_id`,`tag_id`)
2214 -- Dumping data for table `0_tag_associations`
2217 -- --------------------------------------------------------
2220 -- Table structure for table `0_tax_groups`
2223 DROP TABLE IF EXISTS `0_tax_groups`;
2224 CREATE TABLE IF NOT EXISTS `0_tax_groups` (
2225 `id` int(11) NOT NULL AUTO_INCREMENT,
2226 `name` varchar(60) NOT NULL DEFAULT '',
2227 `inactive` tinyint(1) NOT NULL DEFAULT '0',
2229 UNIQUE KEY `name` (`name`)
2230 ) ENGINE=InnoDB AUTO_INCREMENT=3 ;
2233 -- Dumping data for table `0_tax_groups`
2236 INSERT INTO `0_tax_groups` VALUES (1, 'Tax', 0);
2237 INSERT INTO `0_tax_groups` VALUES (2, 'Tax Exempt', 0);
2239 -- --------------------------------------------------------
2242 -- Table structure for table `0_tax_group_items`
2245 DROP TABLE IF EXISTS `0_tax_group_items`;
2246 CREATE TABLE IF NOT EXISTS `0_tax_group_items` (
2247 `tax_group_id` int(11) NOT NULL DEFAULT '0',
2248 `tax_type_id` int(11) NOT NULL DEFAULT '0',
2249 `tax_shipping` tinyint(1) NOT NULL DEFAULT '0',
2250 PRIMARY KEY (`tax_group_id`,`tax_type_id`)
2254 -- Dumping data for table `0_tax_group_items`
2257 INSERT INTO `0_tax_group_items` VALUES (1, 1, 1);
2259 -- --------------------------------------------------------
2262 -- Table structure for table `0_tax_types`
2265 DROP TABLE IF EXISTS `0_tax_types`;
2266 CREATE TABLE IF NOT EXISTS `0_tax_types` (
2267 `id` int(11) NOT NULL AUTO_INCREMENT,
2268 `rate` double NOT NULL DEFAULT '0',
2269 `sales_gl_code` varchar(15) NOT NULL DEFAULT '',
2270 `purchasing_gl_code` varchar(15) NOT NULL DEFAULT '',
2271 `name` varchar(60) NOT NULL DEFAULT '',
2272 `inactive` tinyint(1) NOT NULL DEFAULT '0',
2274 ) ENGINE=InnoDB AUTO_INCREMENT=2 ;
2277 -- Dumping data for table `0_tax_types`
2280 INSERT INTO `0_tax_types` VALUES (1, 5, '2150', '2150', 'Tax', 0);
2282 -- --------------------------------------------------------
2285 -- Table structure for table `0_trans_tax_details`
2288 DROP TABLE IF EXISTS `0_trans_tax_details`;
2289 CREATE TABLE IF NOT EXISTS `0_trans_tax_details` (
2290 `id` int(11) NOT NULL AUTO_INCREMENT,
2291 `trans_type` smallint(6) DEFAULT NULL,
2292 `trans_no` int(11) DEFAULT NULL,
2293 `tran_date` date NOT NULL,
2294 `tax_type_id` int(11) NOT NULL DEFAULT '0',
2295 `rate` double NOT NULL DEFAULT '0',
2296 `ex_rate` double NOT NULL DEFAULT '1',
2297 `included_in_price` tinyint(1) NOT NULL DEFAULT '0',
2298 `net_amount` double NOT NULL DEFAULT '0',
2299 `amount` double NOT NULL DEFAULT '0',
2301 `reg_type` tinyint(1) DEFAULT NULL,
2303 KEY `Type_and_Number` (`trans_type`,`trans_no`),
2304 KEY `tran_date` (`tran_date`)
2305 ) ENGINE=InnoDB AUTO_INCREMENT=8 ;
2308 -- Dumping data for table `0_trans_tax_details`
2311 INSERT INTO `0_trans_tax_details` VALUES
2312 ('1', '13', '1', '2015-05-10', '1', '5', '1', '1', '5942.86', '297.14', 'auto', NULL),
2313 ('2', '10', '1', '2015-05-10', '1', '5', '1', '1', '5942.86', '297.14', '001/2015', '0'),
2314 ('3', '20', '1', '2015-05-05', '1', '5', '1', '0', '3000', '150', 'rr4', '1'),
2315 ('4', '13', '2', '2015-05-07', '1', '5', '1', '1', '285.71', '14.29', 'auto', NULL),
2316 ('5', '10', '2', '2015-05-07', '1', '5', '1', '1', '285.71', '14.29', '002/2015', '0'),
2317 ('6', '13', '3', '2015-05-07', '0', '0', '1.123', '1', '267.14', '0', 'auto', NULL),
2318 ('7', '10', '3', '2015-05-07', '0', '0', '1.123', '1', '267.14', '0', '003/2015', '0');
2320 -- --------------------------------------------------------
2323 -- Table structure for table `0_useronline`
2326 DROP TABLE IF EXISTS `0_useronline`;
2327 CREATE TABLE IF NOT EXISTS `0_useronline` (
2328 `id` int(11) NOT NULL AUTO_INCREMENT,
2329 `timestamp` int(15) NOT NULL DEFAULT '0',
2330 `ip` varchar(40) NOT NULL DEFAULT '',
2331 `file` varchar(100) NOT NULL DEFAULT '',
2333 KEY `timestamp` (`timestamp`),
2338 -- Dumping data for table `0_useronline`
2341 -- --------------------------------------------------------
2344 -- Table structure for table `0_users`
2347 DROP TABLE IF EXISTS `0_users`;
2348 CREATE TABLE IF NOT EXISTS `0_users` (
2349 `id` smallint(6) NOT NULL AUTO_INCREMENT,
2350 `user_id` varchar(60) NOT NULL DEFAULT '',
2351 `password` varchar(100) NOT NULL DEFAULT '',
2352 `real_name` varchar(100) NOT NULL DEFAULT '',
2353 `role_id` int(11) NOT NULL DEFAULT '1',
2354 `phone` varchar(30) NOT NULL DEFAULT '',
2355 `email` varchar(100) DEFAULT NULL,
2356 `language` varchar(20) DEFAULT NULL,
2357 `date_format` tinyint(1) NOT NULL DEFAULT '0',
2358 `date_sep` tinyint(1) NOT NULL DEFAULT '0',
2359 `tho_sep` tinyint(1) NOT NULL DEFAULT '0',
2360 `dec_sep` tinyint(1) NOT NULL DEFAULT '0',
2361 `theme` varchar(20) NOT NULL DEFAULT 'default',
2362 `page_size` varchar(20) NOT NULL DEFAULT 'A4',
2363 `prices_dec` smallint(6) NOT NULL DEFAULT '2',
2364 `qty_dec` smallint(6) NOT NULL DEFAULT '2',
2365 `rates_dec` smallint(6) NOT NULL DEFAULT '4',
2366 `percent_dec` smallint(6) NOT NULL DEFAULT '1',
2367 `show_gl` tinyint(1) NOT NULL DEFAULT '1',
2368 `show_codes` tinyint(1) NOT NULL DEFAULT '0',
2369 `show_hints` tinyint(1) NOT NULL DEFAULT '0',
2370 `last_visit_date` datetime DEFAULT NULL,
2371 `query_size` tinyint(1) unsigned NOT NULL DEFAULT '10',
2372 `graphic_links` tinyint(1) DEFAULT '1',
2373 `pos` smallint(6) DEFAULT '1',
2374 `print_profile` varchar(30) NOT NULL DEFAULT '',
2375 `rep_popup` tinyint(1) DEFAULT '1',
2376 `sticky_doc_date` tinyint(1) DEFAULT '0',
2377 `startup_tab` varchar(20) NOT NULL DEFAULT '',
2378 `transaction_days` smallint(6) NOT NULL DEFAULT '30',
2379 `save_report_selections` smallint(6) NOT NULL DEFAULT '0',
2380 `use_date_picker` tinyint(1) NOT NULL DEFAULT '1',
2381 `def_print_destination` tinyint(1) NOT NULL DEFAULT '0',
2382 `def_print_orientation` tinyint(1) NOT NULL DEFAULT '0',
2383 `inactive` tinyint(1) NOT NULL DEFAULT '0',
2385 UNIQUE KEY `user_id` (`user_id`)
2386 ) ENGINE=InnoDB AUTO_INCREMENT=2 ;
2389 -- Dumping data for table `0_users`
2392 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);
2394 -- --------------------------------------------------------
2397 -- Table structure for table `0_voided`
2400 DROP TABLE IF EXISTS `0_voided`;
2401 CREATE TABLE IF NOT EXISTS `0_voided` (
2402 `type` int(11) NOT NULL DEFAULT '0',
2403 `id` int(11) NOT NULL DEFAULT '0',
2404 `date_` date NOT NULL DEFAULT '0000-00-00',
2405 `memo_` tinytext NOT NULL,
2406 UNIQUE KEY `id` (`type`,`id`)
2410 -- Dumping data for table `0_voided`
2413 -- --------------------------------------------------------
2416 -- Table structure for table `0_workcentres`
2419 DROP TABLE IF EXISTS `0_workcentres`;
2420 CREATE TABLE IF NOT EXISTS `0_workcentres` (
2421 `id` int(11) NOT NULL AUTO_INCREMENT,
2422 `name` char(40) NOT NULL DEFAULT '',
2423 `description` char(50) NOT NULL DEFAULT '',
2424 `inactive` tinyint(1) NOT NULL DEFAULT '0',
2426 UNIQUE KEY `name` (`name`)
2427 ) ENGINE=InnoDB AUTO_INCREMENT=2 ;
2430 -- Dumping data for table `0_workcentres`
2433 INSERT INTO `0_workcentres` VALUES ('1', 'Work Centre', '', '0');
2435 -- --------------------------------------------------------
2438 -- Table structure for table `0_workorders`
2441 DROP TABLE IF EXISTS `0_workorders`;
2442 CREATE TABLE IF NOT EXISTS `0_workorders` (
2443 `id` int(11) NOT NULL AUTO_INCREMENT,
2444 `wo_ref` varchar(60) NOT NULL DEFAULT '',
2445 `loc_code` varchar(5) NOT NULL DEFAULT '',
2446 `units_reqd` double NOT NULL DEFAULT '1',
2447 `stock_id` varchar(20) NOT NULL DEFAULT '',
2448 `date_` date NOT NULL DEFAULT '0000-00-00',
2449 `type` tinyint(4) NOT NULL DEFAULT '0',
2450 `required_by` date NOT NULL DEFAULT '0000-00-00',
2451 `released_date` date NOT NULL DEFAULT '0000-00-00',
2452 `units_issued` double NOT NULL DEFAULT '0',
2453 `closed` tinyint(1) NOT NULL DEFAULT '0',
2454 `released` tinyint(1) NOT NULL DEFAULT '0',
2455 `additional_costs` double NOT NULL DEFAULT '0',
2457 UNIQUE KEY `wo_ref` (`wo_ref`)
2458 ) ENGINE=InnoDB AUTO_INCREMENT=4 ;
2461 -- Dumping data for table `0_workorders`
2464 INSERT INTO `0_workorders` VALUES
2465 ('1', '001/2015', 'DEF', '2', '201', '2015-05-05', '0', '2015-05-05', '2015-05-05', '2', '1', '1', '0'),
2466 ('2', '002/2015', 'DEF', '5', '201', '2015-05-07', '2', '2015-05-27', '2015-05-07', '0', '0', '1', '0'),
2467 ('3', '003/2015', 'DEF', '5', '201', '2015-05-07', '2', '2015-05-27', '0000-00-00', '0', '0', '0', '0');
2469 -- --------------------------------------------------------
2472 -- Table structure for table `0_wo_costing`
2475 DROP TABLE IF EXISTS `0_wo_costing`;
2476 CREATE TABLE `0_wo_costing` (
2477 `id` int(11) NOT NULL AUTO_INCREMENT,
2478 `workorder_id` int(11) NOT NULL DEFAULT '0',
2479 `cost_type` tinyint(1) NOT NULL DEFAULT '0',
2480 `trans_type` int(11) NOT NULL DEFAULT '0',
2481 `trans_no` int(11) NOT NULL DEFAULT '0',
2482 `factor` double NOT NULL DEFAULT '1',
2487 -- Dumping data for table `0_wo_costing`
2490 -- --------------------------------------------------------
2493 -- Table structure for table `0_wo_issues`
2496 DROP TABLE IF EXISTS `0_wo_issues`;
2497 CREATE TABLE IF NOT EXISTS `0_wo_issues` (
2498 `issue_no` int(11) NOT NULL AUTO_INCREMENT,
2499 `workorder_id` int(11) NOT NULL DEFAULT '0',
2500 `reference` varchar(100) DEFAULT NULL,
2501 `issue_date` date DEFAULT NULL,
2502 `loc_code` varchar(5) DEFAULT NULL,
2503 `workcentre_id` int(11) DEFAULT NULL,
2504 PRIMARY KEY (`issue_no`),
2505 KEY `workorder_id` (`workorder_id`)
2509 -- Dumping data for table `0_wo_issues`
2512 -- --------------------------------------------------------
2515 -- Table structure for table `0_wo_issue_items`
2518 DROP TABLE IF EXISTS `0_wo_issue_items`;
2519 CREATE TABLE IF NOT EXISTS `0_wo_issue_items` (
2520 `id` int(11) NOT NULL AUTO_INCREMENT,
2521 `stock_id` varchar(40) DEFAULT NULL,
2522 `issue_id` int(11) DEFAULT NULL,
2523 `qty_issued` double DEFAULT NULL,
2524 `unit_cost` double NOT NULL default '0',
2529 -- Dumping data for table `0_wo_issue_items`
2532 -- --------------------------------------------------------
2535 -- Table structure for table `0_wo_manufacture`
2538 DROP TABLE IF EXISTS `0_wo_manufacture`;
2539 CREATE TABLE IF NOT EXISTS `0_wo_manufacture` (
2540 `id` int(11) NOT NULL AUTO_INCREMENT,
2541 `reference` varchar(100) DEFAULT NULL,
2542 `workorder_id` int(11) NOT NULL DEFAULT '0',
2543 `quantity` double NOT NULL DEFAULT '0',
2544 `date_` date NOT NULL DEFAULT '0000-00-00',
2546 KEY `workorder_id` (`workorder_id`)
2550 -- Dumping data for table `0_wo_manufacture`
2553 -- --------------------------------------------------------
2556 -- Table structure for table `0_wo_requirements`
2559 DROP TABLE IF EXISTS `0_wo_requirements`;
2560 CREATE TABLE IF NOT EXISTS `0_wo_requirements` (
2561 `id` int(11) NOT NULL AUTO_INCREMENT,
2562 `workorder_id` int(11) NOT NULL DEFAULT '0',
2563 `stock_id` char(20) NOT NULL DEFAULT '',
2564 `workcentre` int(11) NOT NULL DEFAULT '0',
2565 `units_req` double NOT NULL DEFAULT '1',
2566 `unit_cost` double NOT NULL DEFAULT '0',
2567 `loc_code` char(5) NOT NULL DEFAULT '',
2568 `units_issued` double NOT NULL DEFAULT '0',
2570 KEY `workorder_id` (`workorder_id`)
2571 ) ENGINE=InnoDB AUTO_INCREMENT=9 ;
2574 -- Dumping data for table `0_wo_requirements`
2577 INSERT INTO `0_wo_requirements` VALUES
2578 ('1', '1', '101', '1', '1', '0', 'DEF', '2'),
2579 ('2', '1', '102', '1', '1', '0', 'DEF', '2'),
2580 ('3', '1', '103', '1', '1', '0', 'DEF', '2'),
2581 ('4', '1', '301', '1', '1', '0', 'DEF', '2'),
2582 ('5', '2', '101', '1', '1', '0', 'DEF', '0'),
2583 ('6', '2', '102', '1', '1', '0', 'DEF', '0'),
2584 ('7', '2', '103', '1', '1', '0', 'DEF', '0'),
2585 ('8', '2', '301', '1', '1', '0', 'DEF', '0');