1 -- MySQL dump of database 'en_US-demo' on host 'localhost'
2 -- Backup Date and Time: 2019-01-21 11:16
3 -- Built by FrontAccounting 2.5.0
4 -- http://frontaccounting.com
5 -- Company: Training Co.
8 -- Compatibility: 2.5.0
14 -- Structure of table `0_areas` --
16 DROP TABLE IF EXISTS `0_areas`;
18 CREATE TABLE `0_areas` (
19 `area_code` int(11) NOT NULL AUTO_INCREMENT,
20 `description` varchar(60) NOT NULL DEFAULT '',
21 `inactive` tinyint(1) NOT NULL DEFAULT '0',
22 PRIMARY KEY (`area_code`),
23 UNIQUE KEY `description` (`description`)
24 ) ENGINE=InnoDB AUTO_INCREMENT=2 ;
26 -- Data of table `0_areas` --
28 INSERT INTO `0_areas` VALUES
31 -- Structure of table `0_attachments` --
33 DROP TABLE IF EXISTS `0_attachments`;
35 CREATE TABLE `0_attachments` (
36 `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
37 `description` varchar(60) NOT NULL DEFAULT '',
38 `type_no` int(11) NOT NULL DEFAULT '0',
39 `trans_no` int(11) NOT NULL DEFAULT '0',
40 `unique_name` varchar(60) NOT NULL DEFAULT '',
41 `tran_date` date NOT NULL DEFAULT '0000-00-00',
42 `filename` varchar(60) NOT NULL DEFAULT '',
43 `filesize` int(11) NOT NULL DEFAULT '0',
44 `filetype` varchar(60) NOT NULL DEFAULT '',
46 KEY `type_no` (`type_no`,`trans_no`)
49 -- Data of table `0_attachments` --
51 -- Structure of table `0_audit_trail` --
53 DROP TABLE IF EXISTS `0_audit_trail`;
55 CREATE TABLE `0_audit_trail` (
56 `id` int(11) NOT NULL AUTO_INCREMENT,
57 `type` smallint(6) unsigned NOT NULL DEFAULT '0',
58 `trans_no` int(11) unsigned NOT NULL DEFAULT '0',
59 `user` smallint(6) unsigned NOT NULL DEFAULT '0',
60 `stamp` timestamp NOT NULL,
61 `description` varchar(60) DEFAULT NULL,
62 `fiscal_year` int(11) NOT NULL DEFAULT '0',
63 `gl_date` date NOT NULL DEFAULT '0000-00-00',
64 `gl_seq` int(11) unsigned DEFAULT NULL,
66 KEY `Seq` (`fiscal_year`,`gl_date`,`gl_seq`),
67 KEY `Type_and_Number` (`type`,`trans_no`)
68 ) ENGINE=InnoDB AUTO_INCREMENT=37 ;
70 -- Data of table `0_audit_trail` --
72 INSERT INTO `0_audit_trail` VALUES
73 ('1', '18', '1', '1', '2018-05-05 14:08:02', NULL, '1', '2018-05-05', '0'),
74 ('2', '25', '1', '1', '2018-05-05 14:08:14', NULL, '1', '2018-05-05', '1'),
75 ('3', '30', '1', '1', '2018-05-05 14:09:54', NULL, '1', '2018-05-10', '0'),
76 ('4', '13', '1', '1', '2018-05-05 14:09:55', NULL, '1', '2018-05-10', '13'),
77 ('5', '10', '1', '1', '2018-05-05 14:09:55', NULL, '1', '2018-05-10', '14'),
78 ('6', '12', '1', '1', '2018-05-05 14:09:55', NULL, '1', '2018-05-10', '15'),
79 ('7', '29', '1', '1', '2018-05-05 14:18:49', 'Quick production.', '1', '2018-05-05', '2'),
80 ('8', '18', '2', '1', '2018-05-05 14:22:32', NULL, '1', '2018-05-05', '0'),
81 ('9', '25', '2', '1', '2018-05-05 14:22:32', NULL, '1', '2018-05-05', '3'),
82 ('10', '20', '1', '1', '2018-05-05 14:22:32', NULL, '1', '2018-05-05', '4'),
83 ('11', '30', '2', '1', '2018-05-07 07:55:15', NULL, '1', '2018-05-07', '0'),
84 ('12', '13', '2', '1', '2018-05-07 07:55:16', NULL, '1', '2018-05-07', '7'),
85 ('13', '10', '2', '1', '2018-05-07 07:55:16', NULL, '1', '2018-05-07', '8'),
86 ('14', '12', '2', '1', '2018-05-07 07:55:16', NULL, '1', '2018-05-07', '9'),
87 ('15', '30', '3', '1', '2018-05-07 08:08:24', NULL, '1', '2018-05-07', '0'),
88 ('16', '30', '4', '1', '2018-05-07 09:18:44', NULL, '1', '2018-05-07', '0'),
89 ('17', '30', '5', '1', '2018-05-07 11:42:41', NULL, '1', '2018-05-07', '0'),
90 ('18', '13', '3', '1', '2018-05-07 11:42:41', NULL, '1', '2018-05-07', '10'),
91 ('19', '10', '3', '1', '2018-05-07 11:42:41', NULL, '1', '2018-05-07', '11'),
92 ('20', '30', '6', '1', '2018-05-07 14:02:35', NULL, '1', '2018-05-07', '0'),
93 ('21', '30', '7', '1', '2018-05-07 14:05:38', NULL, '1', '2018-05-07', '0'),
94 ('22', '13', '4', '1', '2018-05-07 14:05:38', NULL, '1', '2018-05-07', '0'),
95 ('23', '10', '4', '1', '2018-05-07 14:05:38', NULL, '1', '2018-05-07', '0'),
96 ('24', '12', '3', '1', '2018-05-07 14:05:38', NULL, '1', '2018-05-07', '0'),
97 ('25', '26', '1', '1', '2018-05-07 15:59:34', NULL, '1', '2018-05-07', NULL),
98 ('26', '29', '1', '1', '2018-05-07 15:59:01', 'Production.', '1', '2018-05-07', '5'),
99 ('27', '26', '1', '1', '2018-05-07 15:59:34', 'Released.', '1', '2018-05-07', '6'),
100 ('28', '1', '1', '1', '2018-05-07 16:01:00', NULL, '1', '2018-05-07', '12'),
101 ('29', '30', '8', '1', '2019-01-21 11:13:06', NULL, '2', '2019-01-21', '0'),
102 ('30', '13', '5', '1', '2019-01-21 11:13:06', NULL, '2', '2019-01-21', '0'),
103 ('31', '10', '5', '1', '2019-01-21 11:13:06', NULL, '2', '2019-01-21', '0'),
104 ('32', '12', '4', '1', '2019-01-21 11:13:06', NULL, '2', '2019-01-21', '0'),
105 ('33', '18', '3', '1', '2019-01-21 11:14:14', NULL, '2', '2019-01-21', '0'),
106 ('34', '25', '3', '1', '2019-01-21 11:14:14', NULL, '2', '2019-01-21', '0'),
107 ('35', '20', '2', '1', '2019-01-21 11:14:14', NULL, '2', '2019-01-21', '0'),
108 ('36', '0', '1', '1', '2019-01-21 11:15:35', NULL, '1', '2018-12-31', '16');
110 -- Structure of table `0_bank_accounts` --
112 DROP TABLE IF EXISTS `0_bank_accounts`;
114 CREATE TABLE `0_bank_accounts` (
115 `account_code` varchar(15) NOT NULL DEFAULT '',
116 `account_type` smallint(6) NOT NULL DEFAULT '0',
117 `bank_account_name` varchar(60) NOT NULL DEFAULT '',
118 `bank_account_number` varchar(100) NOT NULL DEFAULT '',
119 `bank_name` varchar(60) NOT NULL DEFAULT '',
120 `bank_address` tinytext,
121 `bank_curr_code` char(3) NOT NULL DEFAULT '',
122 `dflt_curr_act` tinyint(1) NOT NULL DEFAULT '0',
123 `id` smallint(6) NOT NULL AUTO_INCREMENT,
124 `bank_charge_act` varchar(15) NOT NULL DEFAULT '',
125 `last_reconciled_date` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
126 `ending_reconcile_balance` double NOT NULL DEFAULT '0',
127 `inactive` tinyint(1) NOT NULL DEFAULT '0',
129 KEY `bank_account_name` (`bank_account_name`),
130 KEY `bank_account_number` (`bank_account_number`),
131 KEY `account_code` (`account_code`)
132 ) ENGINE=InnoDB AUTO_INCREMENT=3 ;
134 -- Data of table `0_bank_accounts` --
136 INSERT INTO `0_bank_accounts` VALUES
137 ('1060', '0', 'Current account', 'N/A', 'N/A', NULL, 'USD', '1', '1', '5690', '0000-00-00 00:00:00', '0', '0'),
138 ('1065', '3', 'Petty Cash account', 'N/A', 'N/A', NULL, 'USD', '0', '2', '5690', '0000-00-00 00:00:00', '0', '0');
140 -- Structure of table `0_bank_trans` --
142 DROP TABLE IF EXISTS `0_bank_trans`;
144 CREATE TABLE `0_bank_trans` (
145 `id` int(11) NOT NULL AUTO_INCREMENT,
146 `type` smallint(6) DEFAULT NULL,
147 `trans_no` int(11) DEFAULT NULL,
148 `bank_act` varchar(15) NOT NULL DEFAULT '',
149 `ref` varchar(40) DEFAULT NULL,
150 `trans_date` date NOT NULL DEFAULT '0000-00-00',
151 `amount` double DEFAULT NULL,
152 `dimension_id` int(11) NOT NULL DEFAULT '0',
153 `dimension2_id` int(11) NOT NULL DEFAULT '0',
154 `person_type_id` int(11) NOT NULL DEFAULT '0',
155 `person_id` tinyblob,
156 `reconciled` date DEFAULT NULL,
158 KEY `bank_act` (`bank_act`,`ref`),
159 KEY `type` (`type`,`trans_no`),
160 KEY `bank_act_2` (`bank_act`,`reconciled`),
161 KEY `bank_act_3` (`bank_act`,`trans_date`)
162 ) ENGINE=InnoDB AUTO_INCREMENT=6 ;
164 -- Data of table `0_bank_trans` --
166 INSERT INTO `0_bank_trans` VALUES
167 ('1', '12', '1', '2', '001/2018', '2018-05-10', '6240', '0', '0', '2', '1', NULL),
168 ('2', '12', '2', '2', '002/2018', '2018-05-07', '300', '0', '0', '2', '1', NULL),
169 ('3', '12', '3', '2', '003/2018', '2018-05-07', '0', '0', '0', '2', '1', NULL),
170 ('4', '1', '1', '1', '001/2018', '2018-05-07', '-5', '0', '0', '0', 'Goods received', NULL),
171 ('5', '12', '4', '2', '001/2019', '2019-01-21', '1250', '0', '0', '2', '1', NULL);
173 -- Structure of table `0_bom` --
175 DROP TABLE IF EXISTS `0_bom`;
177 CREATE TABLE `0_bom` (
178 `id` int(11) NOT NULL AUTO_INCREMENT,
179 `parent` char(20) NOT NULL DEFAULT '',
180 `component` char(20) NOT NULL DEFAULT '',
181 `workcentre_added` int(11) NOT NULL DEFAULT '0',
182 `loc_code` char(5) NOT NULL DEFAULT '',
183 `quantity` double NOT NULL DEFAULT '1',
184 PRIMARY KEY (`parent`,`component`,`workcentre_added`,`loc_code`),
185 KEY `component` (`component`),
187 KEY `loc_code` (`loc_code`),
188 KEY `parent` (`parent`,`loc_code`),
189 KEY `workcentre_added` (`workcentre_added`)
190 ) ENGINE=InnoDB AUTO_INCREMENT=5 ;
192 -- Data of table `0_bom` --
194 INSERT INTO `0_bom` VALUES
195 ('1', '201', '101', '1', 'DEF', '1'),
196 ('2', '201', '102', '1', 'DEF', '1'),
197 ('3', '201', '103', '1', 'DEF', '1'),
198 ('4', '201', '301', '1', 'DEF', '1');
200 -- Structure of table `0_budget_trans` --
202 DROP TABLE IF EXISTS `0_budget_trans`;
204 CREATE TABLE `0_budget_trans` (
205 `id` int(11) NOT NULL AUTO_INCREMENT,
206 `tran_date` date NOT NULL DEFAULT '0000-00-00',
207 `account` varchar(15) NOT NULL DEFAULT '',
208 `memo_` tinytext NOT NULL,
209 `amount` double NOT NULL DEFAULT '0',
210 `dimension_id` int(11) DEFAULT '0',
211 `dimension2_id` int(11) DEFAULT '0',
213 KEY `Account` (`account`,`tran_date`,`dimension_id`,`dimension2_id`)
216 -- Data of table `0_budget_trans` --
218 -- Structure of table `0_chart_class` --
220 DROP TABLE IF EXISTS `0_chart_class`;
222 CREATE TABLE `0_chart_class` (
223 `cid` varchar(3) NOT NULL,
224 `class_name` varchar(60) NOT NULL DEFAULT '',
225 `ctype` tinyint(1) NOT NULL DEFAULT '0',
226 `inactive` tinyint(1) NOT NULL DEFAULT '0',
230 -- Data of table `0_chart_class` --
232 INSERT INTO `0_chart_class` VALUES
233 ('1', 'Assets', '1', '0'),
234 ('2', 'Liabilities', '2', '0'),
235 ('3', 'Income', '4', '0'),
236 ('4', 'Costs', '6', '0');
238 -- Structure of table `0_chart_master` --
240 DROP TABLE IF EXISTS `0_chart_master`;
242 CREATE TABLE `0_chart_master` (
243 `account_code` varchar(15) NOT NULL DEFAULT '',
244 `account_code2` varchar(15) NOT NULL DEFAULT '',
245 `account_name` varchar(60) NOT NULL DEFAULT '',
246 `account_type` varchar(10) NOT NULL DEFAULT '0',
247 `inactive` tinyint(1) NOT NULL DEFAULT '0',
248 PRIMARY KEY (`account_code`),
249 KEY `account_name` (`account_name`),
250 KEY `accounts_by_type` (`account_type`,`account_code`)
253 -- Data of table `0_chart_master` --
255 INSERT INTO `0_chart_master` VALUES
256 ('1060', '', 'Checking Account', '1', '0'),
257 ('1065', '', 'Petty Cash', '1', '0'),
258 ('1200', '', 'Accounts Receivables', '1', '0'),
259 ('1205', '', 'Allowance for doubtful accounts', '1', '0'),
260 ('1510', '', 'Inventory', '2', '0'),
261 ('1520', '', 'Stocks of Raw Materials', '2', '0'),
262 ('1530', '', 'Stocks of Work In Progress', '2', '0'),
263 ('1540', '', 'Stocks of Finished Goods', '2', '0'),
264 ('1550', '', 'Goods Received Clearing account', '2', '0'),
265 ('1820', '', 'Office Furniture & Equipment', '3', '0'),
266 ('1825', '', 'Accum. Amort. -Furn. & Equip.', '3', '0'),
267 ('1840', '', 'Vehicle', '3', '0'),
268 ('1845', '', 'Accum. Amort. -Vehicle', '3', '0'),
269 ('2100', '', 'Accounts Payable', '4', '0'),
270 ('2105', '', 'Deferred Income', '4', '0'),
271 ('2110', '', 'Accrued Income Tax - Federal', '4', '0'),
272 ('2120', '', 'Accrued Income Tax - State', '4', '0'),
273 ('2130', '', 'Accrued Franchise Tax', '4', '0'),
274 ('2140', '', 'Accrued Real & Personal Prop Tax', '4', '0'),
275 ('2150', '', 'Sales Tax', '4', '0'),
276 ('2160', '', 'Accrued Use Tax Payable', '4', '0'),
277 ('2210', '', 'Accrued Wages', '4', '0'),
278 ('2220', '', 'Accrued Comp Time', '4', '0'),
279 ('2230', '', 'Accrued Holiday Pay', '4', '0'),
280 ('2240', '', 'Accrued Vacation Pay', '4', '0'),
281 ('2310', '', 'Accr. Benefits - 401K', '4', '0'),
282 ('2320', '', 'Accr. Benefits - Stock Purchase', '4', '0'),
283 ('2330', '', 'Accr. Benefits - Med, Den', '4', '0'),
284 ('2340', '', 'Accr. Benefits - Payroll Taxes', '4', '0'),
285 ('2350', '', 'Accr. Benefits - Credit Union', '4', '0'),
286 ('2360', '', 'Accr. Benefits - Savings Bond', '4', '0'),
287 ('2370', '', 'Accr. Benefits - Garnish', '4', '0'),
288 ('2380', '', 'Accr. Benefits - Charity Cont.', '4', '0'),
289 ('2620', '', 'Bank Loans', '5', '0'),
290 ('2680', '', 'Loans from Shareholders', '5', '0'),
291 ('3350', '', 'Common Shares', '6', '0'),
292 ('3590', '', 'Retained Earnings - prior years', '7', '0'),
293 ('4010', '', 'Sales', '8', '0'),
294 ('4430', '', 'Shipping & Handling', '9', '0'),
295 ('4440', '', 'Interest', '9', '0'),
296 ('4450', '', 'Foreign Exchange Gain', '9', '0'),
297 ('4500', '', 'Prompt Payment Discounts', '9', '0'),
298 ('4510', '', 'Discounts Given', '9', '0'),
299 ('5010', '', 'Cost of Goods Sold - Retail', '10', '0'),
300 ('5020', '', 'Material Usage Varaiance', '10', '0'),
301 ('5030', '', 'Consumable Materials', '10', '0'),
302 ('5040', '', 'Purchase price Variance', '10', '0'),
303 ('5050', '', 'Purchases of materials', '10', '0'),
304 ('5060', '', 'Discounts Received', '10', '0'),
305 ('5100', '', 'Freight', '10', '0'),
306 ('5410', '', 'Wages & Salaries', '11', '0'),
307 ('5420', '', 'Wages - Overtime', '11', '0'),
308 ('5430', '', 'Benefits - Comp Time', '11', '0'),
309 ('5440', '', 'Benefits - Payroll Taxes', '11', '0'),
310 ('5450', '', 'Benefits - Workers Comp', '11', '0'),
311 ('5460', '', 'Benefits - Pension', '11', '0'),
312 ('5470', '', 'Benefits - General Benefits', '11', '0'),
313 ('5510', '', 'Inc Tax Exp - Federal', '11', '0'),
314 ('5520', '', 'Inc Tax Exp - State', '11', '0'),
315 ('5530', '', 'Taxes - Real Estate', '11', '0'),
316 ('5540', '', 'Taxes - Personal Property', '11', '0'),
317 ('5550', '', 'Taxes - Franchise', '11', '0'),
318 ('5560', '', 'Taxes - Foreign Withholding', '11', '0'),
319 ('5610', '', 'Accounting & Legal', '12', '0'),
320 ('5615', '', 'Advertising & Promotions', '12', '0'),
321 ('5620', '', 'Bad Debts', '12', '0'),
322 ('5660', '', 'Amortization Expense', '12', '0'),
323 ('5685', '', 'Insurance', '12', '0'),
324 ('5690', '', 'Interest & Bank Charges', '12', '0'),
325 ('5700', '', 'Office Supplies', '12', '0'),
326 ('5760', '', 'Rent', '12', '0'),
327 ('5765', '', 'Repair & Maintenance', '12', '0'),
328 ('5780', '', 'Telephone', '12', '0'),
329 ('5785', '', 'Travel & Entertainment', '12', '0'),
330 ('5790', '', 'Utilities', '12', '0'),
331 ('5795', '', 'Registrations', '12', '0'),
332 ('5800', '', 'Licenses', '12', '0'),
333 ('5810', '', 'Foreign Exchange Loss', '12', '0'),
334 ('9990', '', 'Year Profit/Loss', '12', '0');
336 -- Structure of table `0_chart_types` --
338 DROP TABLE IF EXISTS `0_chart_types`;
340 CREATE TABLE `0_chart_types` (
341 `id` varchar(10) NOT NULL,
342 `name` varchar(60) NOT NULL DEFAULT '',
343 `class_id` varchar(3) NOT NULL DEFAULT '',
344 `parent` varchar(10) NOT NULL DEFAULT '-1',
345 `inactive` tinyint(1) NOT NULL DEFAULT '0',
348 KEY `class_id` (`class_id`)
351 -- Data of table `0_chart_types` --
353 INSERT INTO `0_chart_types` VALUES
354 ('1', 'Current Assets', '1', '', '0'),
355 ('2', 'Inventory Assets', '1', '', '0'),
356 ('3', 'Capital Assets', '1', '', '0'),
357 ('4', 'Current Liabilities', '2', '', '0'),
358 ('5', 'Long Term Liabilities', '2', '', '0'),
359 ('6', 'Share Capital', '2', '', '0'),
360 ('7', 'Retained Earnings', '2', '', '0'),
361 ('8', 'Sales Revenue', '3', '', '0'),
362 ('9', 'Other Revenue', '3', '', '0'),
363 ('10', 'Cost of Goods Sold', '4', '', '0'),
364 ('11', 'Payroll Expenses', '4', '', '0'),
365 ('12', 'General & Administrative expenses', '4', '', '0');
367 -- Structure of table `0_comments` --
369 DROP TABLE IF EXISTS `0_comments`;
371 CREATE TABLE `0_comments` (
372 `type` int(11) NOT NULL DEFAULT '0',
373 `id` int(11) NOT NULL DEFAULT '0',
374 `date_` date DEFAULT '0000-00-00',
376 KEY `type_and_id` (`type`,`id`)
379 -- Data of table `0_comments` --
381 INSERT INTO `0_comments` VALUES
382 ('12', '1', '2018-05-10', 'Cash invoice 1'),
383 ('12', '2', '2018-05-07', 'Cash invoice 2'),
384 ('13', '4', '2018-05-07', 'Recurrent Invoice covers period 04/01/2018 - 04/07/2018.'),
385 ('10', '4', '2018-05-07', 'Recurrent Invoice covers period 04/01/2018 - 04/07/2018.'),
386 ('12', '3', '2018-05-07', 'Cash invoice 4'),
387 ('12', '4', '2019-01-21', 'Default #5'),
388 ('0', '1', '2018-12-31', 'Closing Year');
390 -- Structure of table `0_credit_status` --
392 DROP TABLE IF EXISTS `0_credit_status`;
394 CREATE TABLE `0_credit_status` (
395 `id` int(11) NOT NULL AUTO_INCREMENT,
396 `reason_description` char(100) NOT NULL DEFAULT '',
397 `dissallow_invoices` tinyint(1) NOT NULL DEFAULT '0',
398 `inactive` tinyint(1) NOT NULL DEFAULT '0',
400 UNIQUE KEY `reason_description` (`reason_description`)
401 ) ENGINE=InnoDB AUTO_INCREMENT=5 ;
403 -- Data of table `0_credit_status` --
405 INSERT INTO `0_credit_status` VALUES
406 ('1', 'Good History', '0', '0'),
407 ('3', 'No more work until payment received', '1', '0'),
408 ('4', 'In liquidation', '1', '0');
410 -- Structure of table `0_crm_categories` --
412 DROP TABLE IF EXISTS `0_crm_categories`;
414 CREATE TABLE `0_crm_categories` (
415 `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'pure technical key',
416 `type` varchar(20) NOT NULL COMMENT 'contact type e.g. customer',
417 `action` varchar(20) NOT NULL COMMENT 'detailed usage e.g. department',
418 `name` varchar(30) NOT NULL COMMENT 'for category selector',
419 `description` tinytext NOT NULL COMMENT 'usage description',
420 `system` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'nonzero for core system usage',
421 `inactive` tinyint(1) NOT NULL DEFAULT '0',
423 UNIQUE KEY `type` (`type`,`action`),
424 UNIQUE KEY `type_2` (`type`,`name`)
425 ) ENGINE=InnoDB AUTO_INCREMENT=13 ;
427 -- Data of table `0_crm_categories` --
429 INSERT INTO `0_crm_categories` VALUES
430 ('1', 'cust_branch', 'general', 'General', 'General contact data for customer branch (overrides company setting)', '1', '0'),
431 ('2', 'cust_branch', 'invoice', 'Invoices', 'Invoice posting (overrides company setting)', '1', '0'),
432 ('3', 'cust_branch', 'order', 'Orders', 'Order confirmation (overrides company setting)', '1', '0'),
433 ('4', 'cust_branch', 'delivery', 'Deliveries', 'Delivery coordination (overrides company setting)', '1', '0'),
434 ('5', 'customer', 'general', 'General', 'General contact data for customer', '1', '0'),
435 ('6', 'customer', 'order', 'Orders', 'Order confirmation', '1', '0'),
436 ('7', 'customer', 'delivery', 'Deliveries', 'Delivery coordination', '1', '0'),
437 ('8', 'customer', 'invoice', 'Invoices', 'Invoice posting', '1', '0'),
438 ('9', 'supplier', 'general', 'General', 'General contact data for supplier', '1', '0'),
439 ('10', 'supplier', 'order', 'Orders', 'Order confirmation', '1', '0'),
440 ('11', 'supplier', 'delivery', 'Deliveries', 'Delivery coordination', '1', '0'),
441 ('12', 'supplier', 'invoice', 'Invoices', 'Invoice posting', '1', '0');
443 -- Structure of table `0_crm_contacts` --
445 DROP TABLE IF EXISTS `0_crm_contacts`;
447 CREATE TABLE `0_crm_contacts` (
448 `id` int(11) NOT NULL AUTO_INCREMENT,
449 `person_id` int(11) NOT NULL DEFAULT '0' COMMENT 'foreign key to crm_persons',
450 `type` varchar(20) NOT NULL COMMENT 'foreign key to crm_categories',
451 `action` varchar(20) NOT NULL COMMENT 'foreign key to crm_categories',
452 `entity_id` varchar(11) DEFAULT NULL COMMENT 'entity id in related class table',
454 KEY `type` (`type`,`action`)
455 ) ENGINE=InnoDB AUTO_INCREMENT=11 ;
457 -- Data of table `0_crm_contacts` --
459 INSERT INTO `0_crm_contacts` VALUES
460 ('4', '2', 'supplier', 'general', '2'),
461 ('5', '3', 'cust_branch', 'general', '1'),
462 ('7', '3', 'customer', 'general', '1'),
463 ('8', '1', 'supplier', 'general', '1'),
464 ('9', '4', 'cust_branch', 'general', '2'),
465 ('10', '4', 'customer', 'general', '2');
467 -- Structure of table `0_crm_persons` --
469 DROP TABLE IF EXISTS `0_crm_persons`;
471 CREATE TABLE `0_crm_persons` (
472 `id` int(11) NOT NULL AUTO_INCREMENT,
473 `ref` varchar(30) NOT NULL,
474 `name` varchar(60) NOT NULL,
475 `name2` varchar(60) DEFAULT NULL,
477 `phone` varchar(30) DEFAULT NULL,
478 `phone2` varchar(30) DEFAULT NULL,
479 `fax` varchar(30) DEFAULT NULL,
480 `email` varchar(100) DEFAULT NULL,
481 `lang` char(5) DEFAULT NULL,
482 `notes` tinytext NOT NULL,
483 `inactive` tinyint(1) NOT NULL DEFAULT '0',
486 ) ENGINE=InnoDB AUTO_INCREMENT=5 ;
488 -- Data of table `0_crm_persons` --
490 INSERT INTO `0_crm_persons` VALUES
491 ('1', 'Dino Saurius', 'John Doe', NULL, 'N/A', NULL, NULL, NULL, NULL, NULL, '', '0'),
492 ('2', 'Beefeater', 'Joe Oversea', NULL, 'N/A', NULL, NULL, NULL, NULL, NULL, '', '0'),
493 ('3', 'Donald Easter', 'Donald Easter LLC', NULL, 'N/A', NULL, NULL, NULL, NULL, NULL, '', '0'),
494 ('4', 'MoneyMaker', 'MoneyMaker Ltd.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', '0');
496 -- Structure of table `0_currencies` --
498 DROP TABLE IF EXISTS `0_currencies`;
500 CREATE TABLE `0_currencies` (
501 `currency` varchar(60) NOT NULL DEFAULT '',
502 `curr_abrev` char(3) NOT NULL DEFAULT '',
503 `curr_symbol` varchar(10) NOT NULL DEFAULT '',
504 `country` varchar(100) NOT NULL DEFAULT '',
505 `hundreds_name` varchar(15) NOT NULL DEFAULT '',
506 `auto_update` tinyint(1) NOT NULL DEFAULT '1',
507 `inactive` tinyint(1) NOT NULL DEFAULT '0',
508 PRIMARY KEY (`curr_abrev`)
511 -- Data of table `0_currencies` --
513 INSERT INTO `0_currencies` VALUES
514 ('CA Dollars', 'CAD', '$', 'Canada', 'Cents', '1', '0'),
515 ('Euro', 'EUR', '€', 'Europe', 'Cents', '1', '0'),
516 ('Pounds', 'GBP', '£', 'England', 'Pence', '1', '0'),
517 ('US Dollars', 'USD', '$', 'United States', 'Cents', '1', '0');
519 -- Structure of table `0_cust_allocations` --
521 DROP TABLE IF EXISTS `0_cust_allocations`;
523 CREATE TABLE `0_cust_allocations` (
524 `id` int(11) NOT NULL AUTO_INCREMENT,
525 `person_id` int(11) DEFAULT NULL,
526 `amt` double unsigned DEFAULT NULL,
527 `date_alloc` date NOT NULL DEFAULT '0000-00-00',
528 `trans_no_from` int(11) DEFAULT NULL,
529 `trans_type_from` int(11) DEFAULT NULL,
530 `trans_no_to` int(11) DEFAULT NULL,
531 `trans_type_to` int(11) DEFAULT NULL,
533 UNIQUE KEY `trans_type_from` (`person_id`,`trans_type_from`,`trans_no_from`,`trans_type_to`,`trans_no_to`),
534 KEY `From` (`trans_type_from`,`trans_no_from`),
535 KEY `To` (`trans_type_to`,`trans_no_to`)
536 ) ENGINE=InnoDB AUTO_INCREMENT=5 ;
538 -- Data of table `0_cust_allocations` --
540 INSERT INTO `0_cust_allocations` VALUES
541 ('1', '1', '6240', '2018-05-10', '1', '12', '1', '10'),
542 ('2', '1', '300', '2018-05-07', '2', '12', '2', '10'),
543 ('3', '1', '0', '2018-05-07', '3', '12', '4', '10'),
544 ('4', '1', '1250', '2019-01-21', '4', '12', '5', '10');
546 -- Structure of table `0_cust_branch` --
548 DROP TABLE IF EXISTS `0_cust_branch`;
550 CREATE TABLE `0_cust_branch` (
551 `branch_code` int(11) NOT NULL AUTO_INCREMENT,
552 `debtor_no` int(11) NOT NULL DEFAULT '0',
553 `br_name` varchar(60) NOT NULL DEFAULT '',
554 `branch_ref` varchar(30) NOT NULL DEFAULT '',
555 `br_address` tinytext NOT NULL,
556 `area` int(11) DEFAULT NULL,
557 `salesman` int(11) NOT NULL DEFAULT '0',
558 `default_location` varchar(5) NOT NULL DEFAULT '',
559 `tax_group_id` int(11) DEFAULT NULL,
560 `sales_account` varchar(15) NOT NULL DEFAULT '',
561 `sales_discount_account` varchar(15) NOT NULL DEFAULT '',
562 `receivables_account` varchar(15) NOT NULL DEFAULT '',
563 `payment_discount_account` varchar(15) NOT NULL DEFAULT '',
564 `default_ship_via` varchar(20) NOT NULL DEFAULT '',
565 `br_post_address` tinytext NOT NULL,
566 `group_no` int(11) NOT NULL DEFAULT '0',
567 `notes` tinytext NOT NULL,
568 `bank_account` varchar(60) DEFAULT NULL,
569 `inactive` tinyint(1) NOT NULL DEFAULT '0',
570 PRIMARY KEY (`branch_code`,`debtor_no`),
571 KEY `branch_ref` (`branch_ref`),
572 KEY `group_no` (`group_no`)
573 ) ENGINE=InnoDB AUTO_INCREMENT=3 ;
575 -- Data of table `0_cust_branch` --
577 INSERT INTO `0_cust_branch` VALUES
578 ('1', '1', 'Donald Easter LLC', 'Donald Easter', 'N/A', '1', '1', 'DEF', '1', '', '4510', '1200', '4500', 'post-std', 'N/A', '0', '', NULL, '0'),
579 ('2', '2', 'MoneyMaker Ltd.', 'MoneyMaker', '', '1', '1', 'DEF', '2', '', '4510', '1200', '4500', 'post-std', '', '0', '', NULL, '0');
581 DROP TABLE IF EXISTS `0_sql_trail`;
582 CREATE TABLE `0_db_trail` (
583 `id` int(11) NOT NULL AUTO_INCREMENT,
584 `stamp` timestamp DEFAULT CURRENT_TIMESTAMP,
585 `user` tinyint(3) unsigned NOT NULL DEFAULT '0',
586 `msg` varchar(255) DEFAULT '',
587 `entry` varchar(255) DEFAULT '',
588 `data` text DEFAULT NULL,
592 -- Structure of table `0_debtor_trans` --
594 DROP TABLE IF EXISTS `0_debtor_trans`;
596 CREATE TABLE `0_debtor_trans` (
597 `trans_no` int(11) unsigned NOT NULL DEFAULT '0',
598 `type` smallint(6) unsigned NOT NULL DEFAULT '0',
599 `version` tinyint(1) unsigned NOT NULL DEFAULT '0',
600 `debtor_no` int(11) unsigned NOT NULL,
601 `branch_code` int(11) NOT NULL DEFAULT '-1',
602 `tran_date` date NOT NULL DEFAULT '0000-00-00',
603 `due_date` date NOT NULL DEFAULT '0000-00-00',
604 `reference` varchar(60) NOT NULL DEFAULT '',
605 `tpe` int(11) NOT NULL DEFAULT '0',
606 `order_` int(11) NOT NULL DEFAULT '0',
607 `ov_amount` double NOT NULL DEFAULT '0',
608 `ov_gst` double NOT NULL DEFAULT '0',
609 `ov_freight` double NOT NULL DEFAULT '0',
610 `ov_freight_tax` double NOT NULL DEFAULT '0',
611 `ov_discount` double NOT NULL DEFAULT '0',
612 `alloc` double NOT NULL DEFAULT '0',
613 `prep_amount` double NOT NULL DEFAULT '0',
614 `rate` double NOT NULL DEFAULT '1',
615 `ship_via` varchar(20) NOT NULL DEFAULT '',
616 `dimension_id` int(11) NOT NULL DEFAULT '0',
617 `dimension2_id` int(11) NOT NULL DEFAULT '0',
618 `payment_terms` int(11) DEFAULT NULL,
619 `tax_included` tinyint(1) unsigned NOT NULL DEFAULT '0',
620 PRIMARY KEY (`type`,`trans_no`,`debtor_no`),
621 KEY `debtor_no` (`debtor_no`,`branch_code`),
622 KEY `tran_date` (`tran_date`),
623 KEY `order_` (`order_`)
626 -- Data of table `0_debtor_trans` --
628 INSERT INTO `0_debtor_trans` VALUES
629 ('1', '10', '0', '1', '1', '2018-05-10', '2018-05-05', '001/2018', '1', '1', '6240', '0', '0', '0', '0', '6240', '0', '1', 'std-post', '0', '0', '4', '1'),
630 ('2', '10', '0', '1', '1', '2018-05-07', '2018-05-07', '002/2018', '1', '2', '300', '0', '0', '0', '0', '300', '0', '1', 'std-post', '0', '0', '4', '1'),
631 ('3', '10', '0', '2', '2', '2018-05-07', '2018-06-17', '003/2018', '1', '5', '267.14', '0', '0', '0', '0', '0', '0', '1.123', 'std-post', '1', '0', '1', '1'),
632 ('4', '10', '0', '1', '1', '2018-05-07', '2018-05-07', '004/2018', '1', '7', '0', '0', '0', '0', '0', '0', '0', '1', 'std-post', '0', '0', '4', '1'),
633 ('5', '10', '0', '1', '1', '2019-01-21', '2019-01-21', '001/2019', '1', '8', '1250', '0', '0', '0', '0', '1250', '0', '1', 'std-post', '0', '0', '4', '1'),
634 ('1', '12', '0', '1', '1', '2018-05-10', '0000-00-00', '001/2018', '0', '0', '6240', '0', '0', '0', '0', '6240', '0', '1', '', '0', '0', NULL, '0'),
635 ('2', '12', '0', '1', '1', '2018-05-07', '0000-00-00', '002/2018', '0', '0', '300', '0', '0', '0', '0', '300', '0', '1', '', '0', '0', NULL, '0'),
636 ('3', '12', '0', '1', '1', '2018-05-07', '0000-00-00', '003/2018', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '', '0', '0', NULL, '0'),
637 ('4', '12', '0', '1', '1', '2019-01-21', '0000-00-00', '001/2019', '0', '0', '1250', '0', '0', '0', '0', '1250', '0', '', '0', '0', '0', NULL, '0'),
638 ('1', '13', '1', '1', '1', '2018-05-10', '2018-05-05', 'auto', '1', '1', '6240', '0', '0', '0', '0', '0', '0', '1', 'std-post', '0', '0', '4', '1'),
639 ('2', '13', '1', '1', '1', '2018-05-07', '2018-05-07', 'auto', '1', '2', '300', '0', '0', '0', '0', '0', '0', '1', 'std-post', '0', '0', '4', '1'),
640 ('3', '13', '1', '2', '2', '2018-05-07', '2018-06-17', 'auto', '1', '5', '267.14', '0', '0', '0', '0', '0', '0', '1.123', 'std-post', '1', '0', '1', '1'),
641 ('4', '13', '1', '1', '1', '2018-05-07', '2018-05-07', 'auto', '1', '7', '0', '0', '0', '0', '0', '0', '0', '1', 'std-post', '0', '0', '4', '1'),
642 ('5', '13', '1', '1', '1', '2019-01-21', '2019-01-21', 'auto', '1', '8', '1250', '0', '0', '0', '0', '0', '0', '1', 'std-post', '0', '0', '4', '1');
644 -- Structure of table `0_debtor_trans_details` --
646 DROP TABLE IF EXISTS `0_debtor_trans_details`;
648 CREATE TABLE `0_debtor_trans_details` (
649 `id` int(11) NOT NULL AUTO_INCREMENT,
650 `debtor_trans_no` int(11) DEFAULT NULL,
651 `debtor_trans_type` int(11) DEFAULT NULL,
652 `stock_id` varchar(20) NOT NULL DEFAULT '',
653 `description` tinytext,
654 `unit_price` double NOT NULL DEFAULT '0',
655 `unit_tax` double NOT NULL DEFAULT '0',
656 `quantity` double NOT NULL DEFAULT '0',
657 `discount_percent` double NOT NULL DEFAULT '0',
658 `unit_cost` double NOT NULL DEFAULT '0',
659 `qty_done` double NOT NULL DEFAULT '0',
660 `src_id` int(11) NOT NULL,
662 KEY `Transaction` (`debtor_trans_type`,`debtor_trans_no`),
663 KEY `src_id` (`src_id`)
664 ) ENGINE=InnoDB AUTO_INCREMENT=15 ;
666 -- Data of table `0_debtor_trans_details` --
668 INSERT INTO `0_debtor_trans_details` VALUES
669 ('1', '1', '13', '101', 'iPad Air 2 16GB', '300', '14.29', '20', '0', '200', '20', '1'),
670 ('2', '1', '13', '301', 'Support', '80', '3.81', '3', '0', '0', '3', '2'),
671 ('3', '1', '10', '101', 'iPad Air 2 16GB', '300', '14.2855', '20', '0', '200', '0', '1'),
672 ('4', '1', '10', '301', 'Support', '80', '3.81', '3', '0', '0', '0', '2'),
673 ('5', '2', '13', '101', 'iPad Air 2 16GB', '300', '14.29', '1', '0', '200', '1', '3'),
674 ('6', '2', '10', '101', 'iPad Air 2 16GB', '300', '14.29', '1', '0', '200', '0', '5'),
675 ('7', '3', '13', '102', 'iPhone 6 64GB', '222.62', '0', '1', '0', '150', '1', '7'),
676 ('8', '3', '13', '103', 'iPhone Cover Case', '44.52', '0', '1', '0', '10', '1', '8'),
677 ('9', '3', '10', '102', 'iPhone 6 64GB', '222.62', '0', '1', '0', '150', '0', '7'),
678 ('10', '3', '10', '103', 'iPhone Cover Case', '44.52', '0', '1', '0', '10', '0', '8'),
679 ('11', '4', '13', '202', 'Maintenance', '0', '0', '5', '0', '0', '5', '10'),
680 ('12', '4', '10', '202', 'Maintenance', '0', '0', '5', '0', '0', '0', '11'),
681 ('13', '5', '13', '102', 'iPhone 6 64GB', '250', '11.904', '5', '0', '150', '5', '11'),
682 ('14', '5', '10', '102', 'iPhone 6 64GB', '250', '11.904', '5', '0', '150', '0', '13');
684 -- Structure of table `0_debtors_master` --
686 DROP TABLE IF EXISTS `0_debtors_master`;
688 CREATE TABLE `0_debtors_master` (
689 `debtor_no` int(11) NOT NULL AUTO_INCREMENT,
690 `name` varchar(100) NOT NULL DEFAULT '',
691 `debtor_ref` varchar(30) NOT NULL,
693 `tax_id` varchar(55) NOT NULL DEFAULT '',
694 `curr_code` char(3) NOT NULL DEFAULT '',
695 `sales_type` int(11) NOT NULL DEFAULT '1',
696 `dimension_id` int(11) NOT NULL DEFAULT '0',
697 `dimension2_id` int(11) NOT NULL DEFAULT '0',
698 `credit_status` int(11) NOT NULL DEFAULT '0',
699 `payment_terms` int(11) DEFAULT NULL,
700 `discount` double NOT NULL DEFAULT '0',
701 `credit_limit` float NOT NULL DEFAULT '1000',
702 `notes` tinytext NOT NULL,
703 `inactive` tinyint(1) NOT NULL DEFAULT '0',
704 PRIMARY KEY (`debtor_no`),
705 UNIQUE KEY `debtor_ref` (`debtor_ref`),
707 ) ENGINE=InnoDB AUTO_INCREMENT=3 ;
709 -- Data of table `0_debtors_master` --
711 INSERT INTO `0_debtors_master` VALUES
712 ('1', 'Donald Easter LLC', 'Donald Easter', 'N/A', '123456789', 'USD', '1', '0', '0', '1', '4', '0', '1000', '', '0'),
713 ('2', 'MoneyMaker Ltd.', 'MoneyMaker', 'N/A', '54354333', 'EUR', '1', '1', '0', '1', '1', '0', '1000', '', '0');
715 -- Structure of table `0_dimensions` --
717 DROP TABLE IF EXISTS `0_dimensions`;
719 CREATE TABLE `0_dimensions` (
720 `id` int(11) NOT NULL AUTO_INCREMENT,
721 `reference` varchar(60) NOT NULL DEFAULT '',
722 `name` varchar(60) NOT NULL DEFAULT '',
723 `type_` tinyint(1) NOT NULL DEFAULT '1',
724 `closed` tinyint(1) NOT NULL DEFAULT '0',
725 `date_` date NOT NULL DEFAULT '0000-00-00',
726 `due_date` date NOT NULL DEFAULT '0000-00-00',
728 UNIQUE KEY `reference` (`reference`),
729 KEY `date_` (`date_`),
730 KEY `due_date` (`due_date`),
731 KEY `type_` (`type_`)
732 ) ENGINE=InnoDB AUTO_INCREMENT=2 ;
734 -- Data of table `0_dimensions` --
736 INSERT INTO `0_dimensions` VALUES
737 ('1', '001/2018', 'Cost Centre', '1', '0', '2018-05-05', '2018-05-25');
739 -- Structure of table `0_exchange_rates` --
741 DROP TABLE IF EXISTS `0_exchange_rates`;
743 CREATE TABLE `0_exchange_rates` (
744 `id` int(11) NOT NULL AUTO_INCREMENT,
745 `curr_code` char(3) NOT NULL DEFAULT '',
746 `rate_buy` double NOT NULL DEFAULT '0',
747 `rate_sell` double NOT NULL DEFAULT '0',
748 `date_` date NOT NULL DEFAULT '0000-00-00',
750 UNIQUE KEY `curr_code` (`curr_code`,`date_`)
751 ) ENGINE=InnoDB AUTO_INCREMENT=2 ;
753 -- Data of table `0_exchange_rates` --
755 INSERT INTO `0_exchange_rates` VALUES
756 ('1', 'EUR', '1.123', '1.123', '2018-05-07');
758 -- Structure of table `0_fiscal_year` --
760 DROP TABLE IF EXISTS `0_fiscal_year`;
762 CREATE TABLE `0_fiscal_year` (
763 `id` int(11) NOT NULL AUTO_INCREMENT,
764 `begin` date DEFAULT '0000-00-00',
765 `end` date DEFAULT '0000-00-00',
766 `closed` tinyint(1) NOT NULL DEFAULT '0',
768 UNIQUE KEY `begin` (`begin`),
769 UNIQUE KEY `end` (`end`)
770 ) ENGINE=InnoDB AUTO_INCREMENT=3 ;
772 -- Data of table `0_fiscal_year` --
774 INSERT INTO `0_fiscal_year` VALUES
775 ('1', '2018-01-01', '2018-12-31', '1'),
776 ('2', '2019-01-01', '2019-12-31', '0');
778 -- Structure of table `0_gl_trans` --
780 DROP TABLE IF EXISTS `0_gl_trans`;
782 CREATE TABLE `0_gl_trans` (
783 `counter` int(11) NOT NULL AUTO_INCREMENT,
784 `type` smallint(6) NOT NULL DEFAULT '0',
785 `type_no` int(11) NOT NULL DEFAULT '0',
786 `tran_date` date NOT NULL DEFAULT '0000-00-00',
787 `account` varchar(15) NOT NULL DEFAULT '',
788 `memo_` tinytext NOT NULL,
789 `amount` double NOT NULL DEFAULT '0',
790 `dimension_id` int(11) NOT NULL DEFAULT '0',
791 `dimension2_id` int(11) NOT NULL DEFAULT '0',
792 `person_type_id` int(11) DEFAULT NULL,
793 `person_id` tinyblob,
794 PRIMARY KEY (`counter`),
795 KEY `Type_and_Number` (`type`,`type_no`),
796 KEY `dimension_id` (`dimension_id`),
797 KEY `dimension2_id` (`dimension2_id`),
798 KEY `tran_date` (`tran_date`),
799 KEY `account_and_tran_date` (`account`,`tran_date`)
800 ) ENGINE=InnoDB AUTO_INCREMENT=55 ;
802 -- Data of table `0_gl_trans` --
804 INSERT INTO `0_gl_trans` VALUES
805 ('1', '25', '1', '2018-05-05', '1510', '101', '20000', '0', '0', NULL, NULL),
806 ('2', '25', '1', '2018-05-05', '1510', '102', '15000', '0', '0', NULL, NULL),
807 ('3', '25', '1', '2018-05-05', '1510', '103', '1000', '0', '0', NULL, NULL),
808 ('4', '25', '1', '2018-05-05', '1550', '', '-36000', '0', '0', NULL, NULL),
809 ('5', '13', '1', '2018-05-10', '5010', '', '4000', '0', '0', NULL, NULL),
810 ('6', '13', '1', '2018-05-10', '1510', '', '-4000', '0', '0', NULL, NULL),
811 ('7', '10', '1', '2018-05-10', '4010', '', '-5714.29', '0', '0', NULL, NULL),
812 ('8', '10', '1', '2018-05-10', '4010', '', '-228.57', '0', '0', NULL, NULL),
813 ('9', '10', '1', '2018-05-10', '1200', '', '6240', '0', '0', '2', '1'),
814 ('10', '10', '1', '2018-05-10', '2150', '', '-297.14', '0', '0', NULL, NULL),
815 ('11', '12', '1', '2018-05-10', '1065', '', '6240', '0', '0', NULL, NULL),
816 ('12', '12', '1', '2018-05-10', '1200', '', '-6240', '0', '0', '2', '1'),
817 ('13', '29', '1', '2018-05-05', '1510', '1 * iPad Air 2 16GB', '-400', '0', '0', NULL, NULL),
818 ('14', '29', '1', '2018-05-05', '1510', '1 * iPhone 6 64GB', '-300', '0', '0', NULL, NULL),
819 ('15', '29', '1', '2018-05-05', '1510', '1 * iPhone Cover Case', '-20', '0', '0', NULL, NULL),
820 ('16', '29', '1', '2018-05-05', '1530', '1 * Support', '720', '0', '0', NULL, NULL),
821 ('17', '26', '1', '2018-05-05', '1530', '', '-720', '0', '0', NULL, NULL),
822 ('18', '26', '1', '2018-05-05', '1510', '', '720', '0', '0', NULL, NULL),
823 ('19', '25', '2', '2018-05-05', '1510', '101', '3000', '0', '0', NULL, NULL),
824 ('20', '25', '2', '2018-05-05', '1550', '', '-3000', '0', '0', NULL, NULL),
825 ('21', '20', '1', '2018-05-05', '2150', '', '150', '0', '0', NULL, NULL),
826 ('22', '20', '1', '2018-05-05', '2100', '', '-3150', '0', '0', '3', '1'),
827 ('23', '20', '1', '2018-05-05', '1550', '', '3000', '0', '0', NULL, NULL),
828 ('24', '13', '2', '2018-05-07', '5010', '', '200', '0', '0', NULL, NULL),
829 ('25', '13', '2', '2018-05-07', '1510', '', '-200', '0', '0', NULL, NULL),
830 ('26', '10', '2', '2018-05-07', '4010', '', '-285.71', '0', '0', NULL, NULL),
831 ('27', '10', '2', '2018-05-07', '1200', '', '300', '0', '0', '2', '1'),
832 ('28', '10', '2', '2018-05-07', '2150', '', '-14.29', '0', '0', NULL, NULL),
833 ('29', '12', '2', '2018-05-07', '1065', '', '300', '0', '0', NULL, NULL),
834 ('30', '12', '2', '2018-05-07', '1200', '', '-300', '0', '0', '2', '1'),
835 ('31', '13', '3', '2018-05-07', '5010', '', '150', '1', '0', NULL, NULL),
836 ('32', '13', '3', '2018-05-07', '1510', '', '-150', '0', '0', NULL, NULL),
837 ('33', '13', '3', '2018-05-07', '5010', '', '10', '1', '0', NULL, NULL),
838 ('34', '13', '3', '2018-05-07', '1510', '', '-10', '0', '0', NULL, NULL),
839 ('35', '10', '3', '2018-05-07', '4010', '', '-250', '1', '0', NULL, NULL),
840 ('36', '10', '3', '2018-05-07', '4010', '', '-50', '1', '0', NULL, NULL),
841 ('37', '10', '3', '2018-05-07', '1200', '', '300', '0', '0', '2', '2'),
842 ('38', '12', '3', '2018-05-07', '1065', '', '0', '0', '0', NULL, NULL),
843 ('39', '1', '1', '2018-05-07', '5010', '', '5', '1', '0', NULL, NULL),
844 ('40', '1', '1', '2018-05-07', '1060', '', '-5', '0', '0', NULL, NULL),
845 ('41', '13', '5', '2019-01-21', '5010', '', '750', '0', '0', NULL, NULL),
846 ('42', '13', '5', '2019-01-21', '1510', '', '-750', '0', '0', NULL, NULL),
847 ('43', '10', '5', '2019-01-21', '4010', '', '-1190.48', '0', '0', NULL, NULL),
848 ('44', '10', '5', '2019-01-21', '1200', '', '1250', '0', '0', '2', '1'),
849 ('45', '10', '5', '2019-01-21', '2150', '', '-59.52', '0', '0', NULL, NULL),
850 ('46', '12', '4', '2019-01-21', '1065', '', '1250', '0', '0', NULL, NULL),
851 ('47', '12', '4', '2019-01-21', '1200', '', '-1250', '0', '0', '2', '1'),
852 ('48', '25', '3', '2019-01-21', '1510', '102', '900', '0', '0', NULL, NULL),
853 ('49', '25', '3', '2019-01-21', '1550', '', '-900', '0', '0', NULL, NULL),
854 ('50', '20', '2', '2019-01-21', '2150', '', '45', '0', '0', NULL, NULL),
855 ('51', '20', '2', '2019-01-21', '2100', '', '-945', '0', '0', '3', '1'),
856 ('52', '20', '2', '2019-01-21', '1550', '', '900', '0', '0', NULL, NULL),
857 ('53', '0', '1', '2018-12-31', '3590', 'Closing Year', '-2163.57', '0', '0', NULL, NULL),
858 ('54', '0', '1', '2018-12-31', '9990', 'Closing Year', '2163.57', '0', '0', NULL, NULL);
860 -- Structure of table `0_grn_batch` --
862 DROP TABLE IF EXISTS `0_grn_batch`;
864 CREATE TABLE `0_grn_batch` (
865 `id` int(11) NOT NULL AUTO_INCREMENT,
866 `supplier_id` int(11) NOT NULL DEFAULT '0',
867 `purch_order_no` int(11) DEFAULT NULL,
868 `reference` varchar(60) NOT NULL DEFAULT '',
869 `delivery_date` date NOT NULL DEFAULT '0000-00-00',
870 `loc_code` varchar(5) DEFAULT NULL,
871 `rate` double DEFAULT '1',
873 KEY `delivery_date` (`delivery_date`),
874 KEY `purch_order_no` (`purch_order_no`)
875 ) ENGINE=InnoDB AUTO_INCREMENT=4 ;
877 -- Data of table `0_grn_batch` --
879 INSERT INTO `0_grn_batch` VALUES
880 ('1', '1', '1', '001/2018', '2018-05-05', 'DEF', '1'),
881 ('2', '1', '2', 'auto', '2018-05-05', 'DEF', '1'),
882 ('3', '1', '3', 'auto', '2019-01-21', 'DEF', '1');
884 -- Structure of table `0_grn_items` --
886 DROP TABLE IF EXISTS `0_grn_items`;
888 CREATE TABLE `0_grn_items` (
889 `id` int(11) NOT NULL AUTO_INCREMENT,
890 `grn_batch_id` int(11) DEFAULT NULL,
891 `po_detail_item` int(11) NOT NULL DEFAULT '0',
892 `item_code` varchar(20) NOT NULL DEFAULT '',
893 `description` tinytext,
894 `qty_recd` double NOT NULL DEFAULT '0',
895 `quantity_inv` double NOT NULL DEFAULT '0',
897 KEY `grn_batch_id` (`grn_batch_id`)
898 ) ENGINE=InnoDB AUTO_INCREMENT=6 ;
900 -- Data of table `0_grn_items` --
902 INSERT INTO `0_grn_items` VALUES
903 ('1', '1', '1', '101', 'iPad Air 2 16GB', '100', '0'),
904 ('2', '1', '2', '102', 'iPhone 6 64GB', '100', '0'),
905 ('3', '1', '3', '103', 'iPhone Cover Case', '100', '0'),
906 ('4', '2', '4', '101', 'iPad Air 2 16GB', '15', '15'),
907 ('5', '3', '5', '102', 'iPhone 6 64GB', '6', '6');
909 -- Structure of table `0_groups` --
911 DROP TABLE IF EXISTS `0_groups`;
913 CREATE TABLE `0_groups` (
914 `id` smallint(6) unsigned NOT NULL AUTO_INCREMENT,
915 `description` varchar(60) NOT NULL DEFAULT '',
916 `inactive` tinyint(1) NOT NULL DEFAULT '0',
918 UNIQUE KEY `description` (`description`)
919 ) ENGINE=InnoDB AUTO_INCREMENT=4 ;
921 -- Data of table `0_groups` --
923 INSERT INTO `0_groups` VALUES
925 ('2', 'Medium', '0'),
928 -- Structure of table `0_item_codes` --
930 DROP TABLE IF EXISTS `0_item_codes`;
932 CREATE TABLE `0_item_codes` (
933 `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
934 `item_code` varchar(20) NOT NULL,
935 `stock_id` varchar(20) NOT NULL,
936 `description` varchar(200) NOT NULL DEFAULT '',
937 `category_id` smallint(6) unsigned NOT NULL,
938 `quantity` double NOT NULL DEFAULT '1',
939 `is_foreign` tinyint(1) NOT NULL DEFAULT '0',
940 `inactive` tinyint(1) NOT NULL DEFAULT '0',
942 UNIQUE KEY `stock_id` (`stock_id`,`item_code`),
943 KEY `item_code` (`item_code`)
944 ) ENGINE=InnoDB AUTO_INCREMENT=9 ;
946 -- Data of table `0_item_codes` --
948 INSERT INTO `0_item_codes` VALUES
949 ('1', '101', '101', 'iPad Air 2 16GB', '1', '1', '0', '0'),
950 ('2', '102', '102', 'iPhone 6 64GB', '1', '1', '0', '0'),
951 ('3', '103', '103', 'iPhone Cover Case', '1', '1', '0', '0'),
952 ('4', '201', '201', 'AP Surf Set', '3', '1', '0', '0'),
953 ('5', '301', '301', 'Support', '4', '1', '0', '0'),
954 ('6', '501', '102', 'iPhone Pack', '1', '1', '0', '0'),
955 ('7', '501', '103', 'iPhone Pack', '1', '1', '0', '0'),
956 ('8', '202', '202', 'Maintenance', '4', '1', '0', '0');
958 -- Structure of table `0_item_tax_type_exemptions` --
960 DROP TABLE IF EXISTS `0_item_tax_type_exemptions`;
962 CREATE TABLE `0_item_tax_type_exemptions` (
963 `item_tax_type_id` int(11) NOT NULL DEFAULT '0',
964 `tax_type_id` int(11) NOT NULL DEFAULT '0',
965 PRIMARY KEY (`item_tax_type_id`,`tax_type_id`)
968 -- Data of table `0_item_tax_type_exemptions` --
970 -- Structure of table `0_item_tax_types` --
972 DROP TABLE IF EXISTS `0_item_tax_types`;
974 CREATE TABLE `0_item_tax_types` (
975 `id` int(11) NOT NULL AUTO_INCREMENT,
976 `name` varchar(60) NOT NULL DEFAULT '',
977 `exempt` tinyint(1) NOT NULL DEFAULT '0',
978 `inactive` tinyint(1) NOT NULL DEFAULT '0',
980 UNIQUE KEY `name` (`name`)
981 ) ENGINE=InnoDB AUTO_INCREMENT=2 ;
983 -- Data of table `0_item_tax_types` --
985 INSERT INTO `0_item_tax_types` VALUES
986 ('1', 'Regular', '0', '0');
988 -- Structure of table `0_item_units` --
990 DROP TABLE IF EXISTS `0_item_units`;
992 CREATE TABLE `0_item_units` (
993 `abbr` varchar(20) NOT NULL,
994 `name` varchar(40) NOT NULL,
995 `decimals` tinyint(2) NOT NULL,
996 `inactive` tinyint(1) NOT NULL DEFAULT '0',
997 PRIMARY KEY (`abbr`),
998 UNIQUE KEY `name` (`name`)
1001 -- Data of table `0_item_units` --
1003 INSERT INTO `0_item_units` VALUES
1004 ('each', 'Each', '0', '0'),
1005 ('hr', 'Hours', '0', '0');
1007 -- Structure of table `0_journal` --
1009 DROP TABLE IF EXISTS `0_journal`;
1011 CREATE TABLE `0_journal` (
1012 `type` smallint(6) NOT NULL DEFAULT '0',
1013 `trans_no` int(11) NOT NULL DEFAULT '0',
1014 `tran_date` date DEFAULT '0000-00-00',
1015 `reference` varchar(60) NOT NULL DEFAULT '',
1016 `source_ref` varchar(60) NOT NULL DEFAULT '',
1017 `event_date` date DEFAULT '0000-00-00',
1018 `doc_date` date NOT NULL DEFAULT '0000-00-00',
1019 `currency` char(3) NOT NULL DEFAULT '',
1020 `amount` double NOT NULL DEFAULT '0',
1021 `rate` double NOT NULL DEFAULT '1',
1022 PRIMARY KEY (`type`,`trans_no`),
1023 KEY `tran_date` (`tran_date`)
1026 -- Data of table `0_journal` --
1028 INSERT INTO `0_journal` VALUES
1029 ('0', '1', '2018-12-31', '001/2012', '', '2018-12-31', '2018-12-31', 'USD', '2163.57', '1');
1031 -- Structure of table `0_loc_stock` --
1033 DROP TABLE IF EXISTS `0_loc_stock`;
1035 CREATE TABLE `0_loc_stock` (
1036 `loc_code` char(5) NOT NULL DEFAULT '',
1037 `stock_id` char(20) NOT NULL DEFAULT '',
1038 `reorder_level` double NOT NULL DEFAULT '0',
1039 PRIMARY KEY (`loc_code`,`stock_id`),
1040 KEY `stock_id` (`stock_id`)
1043 -- Data of table `0_loc_stock` --
1045 INSERT INTO `0_loc_stock` VALUES
1046 ('DEF', '101', '0'),
1047 ('DEF', '102', '0'),
1048 ('DEF', '103', '0'),
1049 ('DEF', '201', '0'),
1050 ('DEF', '202', '0'),
1051 ('DEF', '301', '0');
1053 -- Structure of table `0_locations` --
1055 DROP TABLE IF EXISTS `0_locations`;
1057 CREATE TABLE `0_locations` (
1058 `loc_code` varchar(5) NOT NULL DEFAULT '',
1059 `location_name` varchar(60) NOT NULL DEFAULT '',
1060 `delivery_address` tinytext NOT NULL,
1061 `phone` varchar(30) NOT NULL DEFAULT '',
1062 `phone2` varchar(30) NOT NULL DEFAULT '',
1063 `fax` varchar(30) NOT NULL DEFAULT '',
1064 `email` varchar(100) NOT NULL DEFAULT '',
1065 `contact` varchar(30) NOT NULL DEFAULT '',
1066 `fixed_asset` tinyint(1) NOT NULL DEFAULT '0',
1067 `inactive` tinyint(1) NOT NULL DEFAULT '0',
1068 PRIMARY KEY (`loc_code`)
1071 -- Data of table `0_locations` --
1073 INSERT INTO `0_locations` VALUES
1074 ('DEF', 'Default', 'N/A', '', '', '', '', '', '0', '0');
1076 -- Structure of table `0_payment_terms` --
1078 DROP TABLE IF EXISTS `0_payment_terms`;
1080 CREATE TABLE `0_payment_terms` (
1081 `id` int(11) NOT NULL AUTO_INCREMENT,
1082 `terms` char(80) NOT NULL DEFAULT '',
1083 `type` tinyint(1) NOT NULL DEFAULT '1'
1084 `days` int(11) NOT NULL DEFAULT '0'
1085 `early_discount` double NOT NULL DEFAULT '0'
1086 `early_days` double NOT NULL DEFAULT '0',
1087 `inactive` tinyint(1) NOT NULL DEFAULT '0',
1089 UNIQUE KEY `terms` (`terms`)
1090 ) ENGINE=InnoDB AUTO_INCREMENT=6 ;
1092 -- Data of table `0_payment_terms` --
1094 INSERT INTO `0_payment_terms` VALUES
1095 ('1', 'Due 15th Of the Following Month', '4', '17', '0', '0', '0'),
1096 ('2', 'Due By End Of The Following Month', '4', '31', '0', '0', '0'),
1097 ('3', 'Payment due within 10 days', '10', '3', '0', '0', '0', '0'),
1098 ('4', 'Cash Only', '2', '0', '0', '0', '0'),
1099 ('5', 'Prepaid', '1', '0', '0', '0', '0');
1101 -- Structure of table `0_prices` --
1103 DROP TABLE IF EXISTS `0_prices`;
1105 CREATE TABLE `0_prices` (
1106 `id` int(11) NOT NULL AUTO_INCREMENT,
1107 `stock_id` varchar(20) NOT NULL DEFAULT '',
1108 `sales_type_id` int(11) NOT NULL DEFAULT '0',
1109 `curr_abrev` char(3) NOT NULL DEFAULT '',
1110 `price` double NOT NULL DEFAULT '0',
1112 UNIQUE KEY `price` (`stock_id`,`sales_type_id`,`curr_abrev`)
1113 ) ENGINE=InnoDB AUTO_INCREMENT=4 ;
1115 -- Data of table `0_prices` --
1117 INSERT INTO `0_prices` VALUES
1118 ('1', '101', '1', 'USD', '300'),
1119 ('2', '102', '1', 'USD', '250'),
1120 ('3', '103', '1', 'USD', '50');
1122 -- Structure of table `0_print_profiles` --
1124 DROP TABLE IF EXISTS `0_print_profiles`;
1126 CREATE TABLE `0_print_profiles` (
1127 `id` smallint(6) unsigned NOT NULL AUTO_INCREMENT,
1128 `profile` varchar(30) NOT NULL,
1129 `report` varchar(5) DEFAULT NULL,
1130 `printer` tinyint(3) unsigned DEFAULT NULL,
1132 UNIQUE KEY `profile` (`profile`,`report`)
1133 ) ENGINE=InnoDB AUTO_INCREMENT=10 ;
1135 -- Data of table `0_print_profiles` --
1137 INSERT INTO `0_print_profiles` VALUES
1138 ('1', 'Out of office', NULL, '0'),
1139 ('2', 'Sales Department', NULL, '0'),
1140 ('3', 'Central', NULL, '2'),
1141 ('4', 'Sales Department', '104', '2'),
1142 ('5', 'Sales Department', '105', '2'),
1143 ('6', 'Sales Department', '107', '2'),
1144 ('7', 'Sales Department', '109', '2'),
1145 ('8', 'Sales Department', '110', '2'),
1146 ('9', 'Sales Department', '201', '2');
1148 -- Structure of table `0_printers` --
1150 DROP TABLE IF EXISTS `0_printers`;
1152 CREATE TABLE `0_printers` (
1153 `id` tinyint(3) unsigned NOT NULL AUTO_INCREMENT,
1154 `name` varchar(20) NOT NULL,
1155 `description` varchar(60) NOT NULL,
1156 `queue` varchar(20) NOT NULL,
1157 `host` varchar(40) NOT NULL,
1158 `port` smallint(11) unsigned NOT NULL,
1159 `timeout` tinyint(3) unsigned NOT NULL,
1161 UNIQUE KEY `name` (`name`)
1162 ) ENGINE=InnoDB AUTO_INCREMENT=4 ;
1164 -- Data of table `0_printers` --
1166 INSERT INTO `0_printers` VALUES
1167 ('1', 'QL500', 'Label printer', 'QL500', 'server', '127', '20'),
1168 ('2', 'Samsung', 'Main network printer', 'scx4521F', 'server', '515', '5'),
1169 ('3', 'Local', 'Local print server at user IP', 'lp', '', '515', '10');
1171 -- Structure of table `0_purch_data` --
1173 DROP TABLE IF EXISTS `0_purch_data`;
1175 CREATE TABLE `0_purch_data` (
1176 `supplier_id` int(11) NOT NULL DEFAULT '0',
1177 `stock_id` char(20) NOT NULL DEFAULT '',
1178 `price` double NOT NULL DEFAULT '0',
1179 `suppliers_uom` char(50) NOT NULL DEFAULT '',
1180 `conversion_factor` double NOT NULL DEFAULT '1',
1181 `supplier_description` char(50) NOT NULL DEFAULT '',
1182 PRIMARY KEY (`supplier_id`,`stock_id`)
1185 -- Data of table `0_purch_data` --
1187 INSERT INTO `0_purch_data` VALUES
1188 ('1', '101', '200', '', '1', 'iPad Air 2 16GB'),
1189 ('1', '102', '150', '', '1', 'iPhone 6 64GB'),
1190 ('1', '103', '10', '', '1', 'iPhone Cover Case');
1192 -- Structure of table `0_purch_order_details` --
1194 DROP TABLE IF EXISTS `0_purch_order_details`;
1196 CREATE TABLE `0_purch_order_details` (
1197 `po_detail_item` int(11) NOT NULL AUTO_INCREMENT,
1198 `order_no` int(11) NOT NULL DEFAULT '0',
1199 `item_code` varchar(20) NOT NULL DEFAULT '',
1200 `description` tinytext,
1201 `delivery_date` date NOT NULL DEFAULT '0000-00-00',
1202 `qty_invoiced` double NOT NULL DEFAULT '0',
1203 `unit_price` double NOT NULL DEFAULT '0',
1204 `act_price` double NOT NULL DEFAULT '0',
1205 `std_cost_unit` double NOT NULL DEFAULT '0',
1206 `quantity_ordered` double NOT NULL DEFAULT '0',
1207 `quantity_received` double NOT NULL DEFAULT '0',
1208 PRIMARY KEY (`po_detail_item`),
1209 KEY `order` (`order_no`,`po_detail_item`),
1210 KEY `itemcode` (`item_code`)
1211 ) ENGINE=InnoDB AUTO_INCREMENT=6 ;
1213 -- Data of table `0_purch_order_details` --
1215 INSERT INTO `0_purch_order_details` VALUES
1216 ('1', '1', '101', 'iPad Air 2 16GB', '2018-05-15', '0', '200', '200', '200', '100', '100'),
1217 ('2', '1', '102', 'iPhone 6 64GB', '2018-05-15', '0', '150', '150', '150', '100', '100'),
1218 ('3', '1', '103', 'iPhone Cover Case', '2018-05-15', '0', '10', '10', '10', '100', '100'),
1219 ('4', '2', '101', 'iPad Air 2 16GB', '2018-05-05', '15', '200', '200', '200', '15', '15'),
1220 ('5', '3', '102', 'iPhone 6 64GB', '2019-01-21', '6', '150', '150', '150', '6', '6');
1222 -- Structure of table `0_purch_orders` --
1224 DROP TABLE IF EXISTS `0_purch_orders`;
1226 CREATE TABLE `0_purch_orders` (
1227 `order_no` int(11) NOT NULL AUTO_INCREMENT,
1228 `supplier_id` int(11) NOT NULL DEFAULT '0',
1229 `comments` tinytext,
1230 `ord_date` date NOT NULL DEFAULT '0000-00-00',
1231 `reference` tinytext NOT NULL,
1232 `supp_reference` tinytext,
1233 `into_stock_location` varchar(5) NOT NULL DEFAULT '',
1234 `delivery_address` tinytext NOT NULL,
1235 `total` double NOT NULL DEFAULT '0',
1236 `prep_amount` double NOT NULL DEFAULT '0',
1237 `alloc` double NOT NULL DEFAULT '0',
1238 `tax_included` tinyint(1) NOT NULL DEFAULT '0',
1239 PRIMARY KEY (`order_no`),
1240 KEY `ord_date` (`ord_date`)
1241 ) ENGINE=InnoDB AUTO_INCREMENT=4 ;
1243 -- Data of table `0_purch_orders` --
1245 INSERT INTO `0_purch_orders` VALUES
1246 ('1', '1', NULL, '2018-05-05', '001/2018', NULL, 'DEF', 'N/A', '37800', '0', '0', '0'),
1247 ('2', '1', NULL, '2018-05-05', 'auto', 'rr4', 'DEF', 'N/A', '3150', '0', '0', '0'),
1248 ('3', '1', NULL, '2019-01-21', 'auto', 'asd5', 'DEF', 'N/A', '945', '0', '0', '0');
1250 -- Structure of table `0_quick_entries` --
1252 DROP TABLE IF EXISTS `0_quick_entries`;
1254 CREATE TABLE `0_quick_entries` (
1255 `id` smallint(6) unsigned NOT NULL AUTO_INCREMENT,
1256 `type` tinyint(1) NOT NULL DEFAULT '0',
1257 `description` varchar(60) NOT NULL,
1258 `usage` varchar(120) DEFAULT NULL,
1259 `base_amount` double NOT NULL DEFAULT '0',
1260 `base_desc` varchar(60) DEFAULT NULL,
1261 `bal_type` tinyint(1) NOT NULL DEFAULT '0',
1263 KEY `description` (`description`)
1264 ) ENGINE=InnoDB AUTO_INCREMENT=4 ;
1266 -- Data of table `0_quick_entries` --
1268 INSERT INTO `0_quick_entries` VALUES
1269 ('1', '1', 'Maintenance', NULL, '0', 'Amount', '0'),
1270 ('2', '4', 'Phone', NULL, '0', 'Amount', '0'),
1271 ('3', '2', 'Cash Sales', 'Retail sales without invoice', '0', 'Amount', '0');
1273 -- Structure of table `0_quick_entry_lines` --
1275 DROP TABLE IF EXISTS `0_quick_entry_lines`;
1277 CREATE TABLE `0_quick_entry_lines` (
1278 `id` smallint(6) unsigned NOT NULL AUTO_INCREMENT,
1279 `qid` smallint(6) unsigned NOT NULL,
1280 `amount` double DEFAULT '0',
1281 `memo` tinytext NOT NULL,
1282 `action` varchar(2) NOT NULL,
1283 `dest_id` varchar(15) NOT NULL DEFAULT '',
1284 `dimension_id` smallint(6) unsigned DEFAULT NULL,
1285 `dimension2_id` smallint(6) unsigned DEFAULT NULL,
1288 ) ENGINE=InnoDB AUTO_INCREMENT=7 ;
1290 -- Data of table `0_quick_entry_lines` --
1292 INSERT INTO `0_quick_entry_lines` VALUES
1293 ('1', '1', '0', '', 't-', '1', '0', '0'),
1294 ('2', '2', '0', '', 't-', '1', '0', '0'),
1295 ('3', '3', '0', '', 't-', '1', '0', '0'),
1296 ('4', '3', '0', '', '=', '4010', '0', '0'),
1297 ('5', '1', '0', '', '=', '5765', '0', '0'),
1298 ('6', '2', '0', '', '=', '5780', '0', '0');
1300 -- Structure of table `0_recurrent_invoices` --
1302 DROP TABLE IF EXISTS `0_recurrent_invoices`;
1304 CREATE TABLE `0_recurrent_invoices` (
1305 `id` smallint(6) unsigned NOT NULL AUTO_INCREMENT,
1306 `description` varchar(60) NOT NULL DEFAULT '',
1307 `order_no` int(11) unsigned NOT NULL,
1308 `debtor_no` int(11) unsigned DEFAULT NULL,
1309 `group_no` smallint(6) unsigned DEFAULT NULL,
1310 `days` int(11) NOT NULL DEFAULT '0',
1311 `monthly` int(11) NOT NULL DEFAULT '0',
1312 `begin` date NOT NULL DEFAULT '0000-00-00',
1313 `end` date NOT NULL DEFAULT '0000-00-00',
1314 `last_sent` date NOT NULL DEFAULT '0000-00-00',
1316 UNIQUE KEY `description` (`description`)
1317 ) ENGINE=InnoDB AUTO_INCREMENT=2 ;
1319 -- Data of table `0_recurrent_invoices` --
1321 INSERT INTO `0_recurrent_invoices` VALUES
1322 ('1', 'Weekly Maintenance', '6', '1', '1', '7', '0', '2018-04-01', '2020-05-07', '2018-04-08');
1324 -- Structure of table `0_reflines` --
1326 DROP TABLE IF EXISTS `0_reflines`;
1328 CREATE TABLE `0_reflines` (
1329 `id` int(11) NOT NULL AUTO_INCREMENT,
1330 `trans_type` int(11) NOT NULL,
1331 `prefix` char(5) NOT NULL DEFAULT '',
1332 `pattern` varchar(35) NOT NULL DEFAULT '1',
1333 `description` varchar(60) NOT NULL DEFAULT '',
1334 `default` tinyint(1) NOT NULL DEFAULT '0',
1335 `inactive` tinyint(1) NOT NULL DEFAULT '0',
1337 UNIQUE KEY `prefix` (`trans_type`,`prefix`)
1338 ) ENGINE=InnoDB AUTO_INCREMENT=23 ;
1340 -- Data of table `0_reflines` --
1342 INSERT INTO `0_reflines` VALUES
1343 ('1', '0', '', '{001}/{YYYY}', '', '1', '0'),
1344 ('2', '1', '', '{001}/{YYYY}', '', '1', '0'),
1345 ('3', '2', '', '{001}/{YYYY}', '', '1', '0'),
1346 ('4', '4', '', '{001}/{YYYY}', '', '1', '0'),
1347 ('5', '10', '', '{001}/{YYYY}', '', '1', '0'),
1348 ('6', '11', '', '{001}/{YYYY}', '', '1', '0'),
1349 ('7', '12', '', '{001}/{YYYY}', '', '1', '0'),
1350 ('8', '13', '', '{001}/{YYYY}', '', '1', '0'),
1351 ('9', '16', '', '{001}/{YYYY}', '', '1', '0'),
1352 ('10', '17', '', '{001}/{YYYY}', '', '1', '0'),
1353 ('11', '18', '', '{001}/{YYYY}', '', '1', '0'),
1354 ('12', '20', '', '{001}/{YYYY}', '', '1', '0'),
1355 ('13', '21', '', '{001}/{YYYY}', '', '1', '0'),
1356 ('14', '22', '', '{001}/{YYYY}', '', '1', '0'),
1357 ('15', '25', '', '{001}/{YYYY}', '', '1', '0'),
1358 ('16', '26', '', '{001}/{YYYY}', '', '1', '0'),
1359 ('17', '28', '', '{001}/{YYYY}', '', '1', '0'),
1360 ('18', '29', '', '{001}/{YYYY}', '', '1', '0'),
1361 ('19', '30', '', '{001}/{YYYY}', '', '1', '0'),
1362 ('20', '32', '', '{001}/{YYYY}', '', '1', '0'),
1363 ('21', '35', '', '{001}/{YYYY}', '', '1', '0'),
1364 ('22', '40', '', '{001}/{YYYY}', '', '1', '0');
1366 -- Structure of table `0_refs` --
1368 DROP TABLE IF EXISTS `0_refs`;
1370 CREATE TABLE `0_refs` (
1371 `id` int(11) NOT NULL DEFAULT '0',
1372 `type` int(11) NOT NULL DEFAULT '0',
1373 `reference` varchar(100) NOT NULL DEFAULT '',
1374 PRIMARY KEY (`id`,`type`),
1375 KEY `Type_and_Reference` (`type`,`reference`)
1378 -- Data of table `0_refs` --
1380 INSERT INTO `0_refs` VALUES
1381 ('1', '1', '001/2018'),
1382 ('1', '10', '001/2018'),
1383 ('5', '10', '001/2019'),
1384 ('2', '10', '002/2018'),
1385 ('3', '10', '003/2018'),
1386 ('4', '10', '004/2018'),
1387 ('1', '12', '001/2018'),
1388 ('4', '12', '001/2019'),
1389 ('2', '12', '002/2018'),
1390 ('3', '12', '003/2018'),
1391 ('1', '18', '001/2018'),
1392 ('1', '20', '001/2018'),
1393 ('2', '20', '001/2019'),
1394 ('1', '25', '001/2018'),
1395 ('1', '26', '001/2018'),
1396 ('2', '26', '002/2018'),
1397 ('3', '26', '003/2018'),
1398 ('3', '30', '001/2018'),
1399 ('4', '30', '002/2018'),
1400 ('6', '30', '003/2018'),
1401 ('1', '40', '001/2018');
1403 -- Structure of table `0_sales_order_details` --
1405 DROP TABLE IF EXISTS `0_sales_order_details`;
1407 CREATE TABLE `0_sales_order_details` (
1408 `id` int(11) NOT NULL AUTO_INCREMENT,
1409 `order_no` int(11) NOT NULL DEFAULT '0',
1410 `trans_type` smallint(6) NOT NULL DEFAULT '30',
1411 `stk_code` varchar(20) NOT NULL DEFAULT '',
1412 `description` tinytext,
1413 `qty_sent` double NOT NULL DEFAULT '0',
1414 `unit_price` double NOT NULL DEFAULT '0',
1415 `quantity` double NOT NULL DEFAULT '0',
1416 `invoiced` double NOT NULL DEFAULT '0',
1417 `discount_percent` double NOT NULL DEFAULT '0',
1419 KEY `sorder` (`trans_type`,`order_no`),
1420 KEY `stkcode` (`stk_code`)
1421 ) ENGINE=InnoDB AUTO_INCREMENT=12 ;
1423 -- Data of table `0_sales_order_details` --
1425 INSERT INTO `0_sales_order_details` VALUES
1426 ('1', '1', '30', '101', 'iPad Air 2 16GB', '20', '300', '20', '0', '0'),
1427 ('2', '1', '30', '301', 'Support', '3', '80', '3', '0', '0'),
1428 ('3', '2', '30', '101', 'iPad Air 2 16GB', '1', '300', '1', '0', '0'),
1429 ('4', '3', '30', '102', 'iPhone 6 64GB', '0', '250', '1', '0', '0'),
1430 ('5', '3', '30', '103', 'iPhone Cover Case', '0', '50', '1', '0', '0'),
1431 ('6', '4', '30', '101', 'iPad Air 2 16GB', '0', '267.14', '1', '0', '0'),
1432 ('7', '5', '30', '102', 'iPhone 6 64GB', '1', '222.62', '1', '0', '0'),
1433 ('8', '5', '30', '103', 'iPhone Cover Case', '1', '44.52', '1', '0', '0'),
1434 ('9', '6', '30', '202', 'Maintenance', '0', '90', '5', '0', '0'),
1435 ('10', '7', '30', '202', 'Maintenance', '5', '0', '5', '0', '0'),
1436 ('11', '8', '30', '102', 'iPhone 6 64GB', '5', '250', '5', '0', '0');
1438 -- Structure of table `0_sales_orders` --
1440 DROP TABLE IF EXISTS `0_sales_orders`;
1442 CREATE TABLE `0_sales_orders` (
1443 `order_no` int(11) NOT NULL,
1444 `trans_type` smallint(6) NOT NULL DEFAULT '30',
1445 `version` tinyint(1) unsigned NOT NULL DEFAULT '0',
1446 `type` tinyint(1) NOT NULL DEFAULT '0',
1447 `debtor_no` int(11) NOT NULL DEFAULT '0',
1448 `branch_code` int(11) NOT NULL DEFAULT '0',
1449 `reference` varchar(100) NOT NULL DEFAULT '',
1450 `customer_ref` tinytext NOT NULL,
1451 `comments` tinytext,
1452 `ord_date` date NOT NULL DEFAULT '0000-00-00',
1453 `order_type` int(11) NOT NULL DEFAULT '0',
1454 `ship_via` varchar(20) NOT NULL DEFAULT '',
1455 `delivery_address` tinytext NOT NULL,
1456 `contact_phone` varchar(30) DEFAULT NULL,
1457 `contact_email` varchar(100) DEFAULT NULL,
1458 `deliver_to` tinytext NOT NULL,
1459 `freight_cost` double NOT NULL DEFAULT '0',
1460 `from_stk_loc` varchar(5) NOT NULL DEFAULT '',
1461 `delivery_date` date NOT NULL DEFAULT '0000-00-00',
1462 `payment_terms` int(11) DEFAULT NULL,
1463 `total` double NOT NULL DEFAULT '0',
1464 `prep_amount` double NOT NULL DEFAULT '0',
1465 `alloc` double NOT NULL DEFAULT '0',
1466 PRIMARY KEY (`trans_type`,`order_no`)
1469 -- Data of table `0_sales_orders` --
1471 INSERT INTO `0_sales_orders` VALUES
1472 ('1', '30', '1', '0', '1', '1', 'auto', '', NULL, '2018-05-10', '1', 'post-std', 'N/A', NULL, NULL, 'Donald Easter LLC', '0', 'DEF', '2018-05-05', '4', '6240', '0', '0'),
1473 ('2', '30', '1', '0', '1', '1', 'auto', '', NULL, '2018-05-07', '1', 'post-std', 'N/A', NULL, NULL, 'Donald Easter LLC', '0', 'DEF', '2018-05-07', '4', '300', '0', '0'),
1474 ('3', '30', '0', '0', '1', '1', '001/2018', '', NULL, '2018-05-07', '1', 'post-std', 'N/A', NULL, NULL, 'Donald Easter LLC', '0', 'DEF', '2018-05-08', '4', '300', '0', '0'),
1475 ('4', '30', '0', '0', '2', '2', '002/2018', '', NULL, '2018-05-07', '1', 'post-std', 'N/A', NULL, NULL, 'MoneyMaker Ltd.', '0', 'DEF', '2018-05-08', '1', '267.14', '0', '0'),
1476 ('5', '30', '1', '0', '2', '2', 'auto', '', NULL, '2018-05-07', '1', 'post-std', 'N/A', NULL, NULL, 'MoneyMaker Ltd.', '0', 'DEF', '2018-06-17', '1', '267.14', '0', '0'),
1477 ('6', '30', '0', '1', '1', '1', '003/2018', '', NULL, '2018-05-07', '1', 'post-std', 'N/A', NULL, NULL, 'Donald Easter LLC', '0', 'DEF', '2018-05-08', '4', '450', '0', '0'),
1478 ('7', '30', '1', '0', '1', '1', 'auto', '', 'Recurrent Invoice covers period 04/01/2018 - 04/07/2018.', '2018-05-07', '1', 'post-std', 'N/A', NULL, NULL, 'Donald Easter LLC', '0', 'DEF', '2018-05-07', '4', '0', '0', '0'),
1479 ('8', '30', '1', '0', '1', '1', 'auto', '', NULL, '2019-01-21', '1', 'post-std', 'N/A', NULL, NULL, 'Donald Easter LLC', '0', 'DEF', '2019-01-21', '4', '1250', '0', '0');
1481 -- Structure of table `0_sales_pos` --
1483 DROP TABLE IF EXISTS `0_sales_pos`;
1485 CREATE TABLE `0_sales_pos` (
1486 `id` smallint(6) unsigned NOT NULL AUTO_INCREMENT,
1487 `pos_name` varchar(30) NOT NULL,
1488 `cash_sale` tinyint(1) NOT NULL,
1489 `credit_sale` tinyint(1) NOT NULL,
1490 `pos_location` varchar(5) NOT NULL,
1491 `pos_account` smallint(6) unsigned NOT NULL,
1492 `inactive` tinyint(1) NOT NULL DEFAULT '0',
1494 UNIQUE KEY `pos_name` (`pos_name`)
1495 ) ENGINE=InnoDB AUTO_INCREMENT=2 ;
1497 -- Data of table `0_sales_pos` --
1499 INSERT INTO `0_sales_pos` VALUES
1500 ('1', 'Default', '1', '1', 'DEF', '2', '0');
1502 -- Structure of table `0_sales_types` --
1504 DROP TABLE IF EXISTS `0_sales_types`;
1506 CREATE TABLE `0_sales_types` (
1507 `id` int(11) NOT NULL AUTO_INCREMENT,
1508 `sales_type` char(50) NOT NULL DEFAULT '',
1509 `tax_included` int(1) NOT NULL DEFAULT '0',
1510 `factor` double NOT NULL DEFAULT '1',
1511 `inactive` tinyint(1) NOT NULL DEFAULT '0',
1513 UNIQUE KEY `sales_type` (`sales_type`)
1514 ) ENGINE=InnoDB AUTO_INCREMENT=3 ;
1516 -- Data of table `0_sales_types` --
1518 INSERT INTO `0_sales_types` VALUES
1519 ('1', 'Retail', '1', '1', '0'),
1520 ('2', 'Wholesale', '0', '0.7', '0');
1522 -- Structure of table `0_salesman` --
1524 DROP TABLE IF EXISTS `0_salesman`;
1526 CREATE TABLE `0_salesman` (
1527 `salesman_code` int(11) NOT NULL AUTO_INCREMENT,
1528 `salesman_name` char(60) NOT NULL DEFAULT '',
1529 `salesman_phone` char(30) NOT NULL DEFAULT '',
1530 `salesman_fax` char(30) NOT NULL DEFAULT '',
1531 `salesman_email` varchar(100) NOT NULL DEFAULT '',
1532 `provision` double NOT NULL DEFAULT '0',
1533 `break_pt` double NOT NULL DEFAULT '0',
1534 `provision2` double NOT NULL DEFAULT '0',
1535 `inactive` tinyint(1) NOT NULL DEFAULT '0',
1536 PRIMARY KEY (`salesman_code`),
1537 UNIQUE KEY `salesman_name` (`salesman_name`)
1538 ) ENGINE=InnoDB AUTO_INCREMENT=2 ;
1540 -- Data of table `0_salesman` --
1542 INSERT INTO `0_salesman` VALUES
1543 ('1', 'Sales Person', '', '', '', '5', '1000', '4', '0');
1545 -- Structure of table `0_security_roles` --
1547 DROP TABLE IF EXISTS `0_security_roles`;
1549 CREATE TABLE `0_security_roles` (
1550 `id` int(11) NOT NULL AUTO_INCREMENT,
1551 `role` varchar(30) NOT NULL,
1552 `description` varchar(50) DEFAULT NULL,
1555 `inactive` tinyint(1) NOT NULL DEFAULT '0',
1557 UNIQUE KEY `role` (`role`)
1558 ) ENGINE=InnoDB AUTO_INCREMENT=11 ;
1560 -- Data of table `0_security_roles` --
1562 INSERT INTO `0_security_roles` VALUES
1563 ('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'),
1564 ('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'),
1565 ('3', 'Salesman', 'Salesman', '768;3072;5632;8192;15872', '773;774;3073;3075;3081;5633;8194;15873;775', '0'),
1566 ('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'),
1567 ('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'),
1568 ('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'),
1569 ('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'),
1570 ('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'),
1571 ('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'),
1572 ('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');
1574 -- Structure of table `0_shippers` --
1576 DROP TABLE IF EXISTS `0_shippers`;
1578 CREATE TABLE `0_shippers` (
1579 `shipper_id` int(11) NOT NULL AUTO_INCREMENT,
1580 `shipper_name` varchar(60) NOT NULL DEFAULT '',
1581 `phone` varchar(30) NOT NULL DEFAULT '',
1582 `phone2` varchar(30) NOT NULL DEFAULT '',
1583 `contact` tinytext NOT NULL,
1584 `address` tinytext NOT NULL,
1585 `inactive` tinyint(1) NOT NULL DEFAULT '0',
1586 PRIMARY KEY (`shipper_id`),
1587 UNIQUE KEY `name` (`shipper_name`)
1588 ) ENGINE=InnoDB AUTO_INCREMENT=2 ;
1590 -- Data of table `0_shippers` --
1592 INSERT INTO `0_shippers` VALUES
1593 ('1', 'Default', '', '', '', '', '0');
1595 -- Structure of table `0_stock_category` --
1597 DROP TABLE IF EXISTS `0_stock_category`;
1599 CREATE TABLE `0_stock_category` (
1600 `category_id` int(11) NOT NULL AUTO_INCREMENT,
1601 `description` varchar(60) NOT NULL DEFAULT '',
1602 `dflt_tax_type` int(11) NOT NULL DEFAULT '1',
1603 `dflt_units` varchar(20) NOT NULL DEFAULT 'each',
1604 `dflt_mb_flag` char(1) NOT NULL DEFAULT 'B',
1605 `dflt_sales_act` varchar(15) NOT NULL DEFAULT '',
1606 `dflt_cogs_act` varchar(15) NOT NULL DEFAULT '',
1607 `dflt_inventory_act` varchar(15) NOT NULL DEFAULT '',
1608 `dflt_adjustment_act` varchar(15) NOT NULL DEFAULT '',
1609 `dflt_wip_act` varchar(15) NOT NULL DEFAULT '',
1610 `dflt_dim1` int(11) DEFAULT NULL,
1611 `dflt_dim2` int(11) DEFAULT NULL,
1612 `inactive` tinyint(1) NOT NULL DEFAULT '0',
1613 `dflt_no_sale` tinyint(1) NOT NULL DEFAULT '0',
1614 `dflt_no_purchase` tinyint(1) NOT NULL DEFAULT '0',
1615 `vat_category` tinyint(1) NOT NULL DEFAULT '0',
1616 PRIMARY KEY (`category_id`),
1617 UNIQUE KEY `description` (`description`)
1618 ) ENGINE=InnoDB AUTO_INCREMENT=5 ;
1620 -- Data of table `0_stock_category` --
1622 INSERT INTO `0_stock_category` VALUES
1623 ('1', 'Components', '1', 'each', 'B', '4010', '5010', '1510', '5040', '1530', '0', '0', '0', '0', '0', '0'),
1624 ('2', 'Charges', '1', 'each', 'D', '4010', '5010', '1510', '5040', '1530', '0', '0', '0', '0', '0', '0'),
1625 ('3', 'Systems', '1', 'each', 'M', '4010', '5010', '1510', '5040', '1530', '0', '0', '0', '0', '0', '0'),
1626 ('4', 'Services', '1', 'hr', 'D', '4010', '5010', '1510', '5040', '1530', '0', '0', '0', '0', '0', '0'),
1627 ('5', 'Shipping', '1', 'each', 'T', '4430', '5010', '', '', '', '0', '0', '0', '1', '0', '0');
1629 -- Structure of table `0_stock_fa_class` --
1631 DROP TABLE IF EXISTS `0_stock_fa_class`;
1633 CREATE TABLE `0_stock_fa_class` (
1634 `fa_class_id` varchar(20) NOT NULL DEFAULT '',
1635 `parent_id` varchar(20) NOT NULL DEFAULT '',
1636 `description` varchar(200) NOT NULL DEFAULT '',
1637 `long_description` tinytext NOT NULL,
1638 `depreciation_rate` double NOT NULL DEFAULT '0',
1639 `inactive` tinyint(1) NOT NULL DEFAULT '0',
1640 PRIMARY KEY (`fa_class_id`)
1643 -- Data of table `0_stock_fa_class` --
1645 -- Structure of table `0_stock_master` --
1647 DROP TABLE IF EXISTS `0_stock_master`;
1649 CREATE TABLE `0_stock_master` (
1650 `stock_id` varchar(20) NOT NULL DEFAULT '',
1651 `category_id` int(11) NOT NULL DEFAULT '0',
1652 `tax_type_id` int(11) NOT NULL DEFAULT '0',
1653 `description` varchar(200) NOT NULL DEFAULT '',
1654 `long_description` tinytext NOT NULL,
1655 `units` varchar(20) NOT NULL DEFAULT 'each',
1656 `mb_flag` char(1) NOT NULL DEFAULT 'B',
1657 `sales_account` varchar(15) NOT NULL DEFAULT '',
1658 `cogs_account` varchar(15) NOT NULL DEFAULT '',
1659 `inventory_account` varchar(15) NOT NULL DEFAULT '',
1660 `adjustment_account` varchar(15) NOT NULL DEFAULT '',
1661 `wip_account` varchar(15) NOT NULL DEFAULT '',
1662 `dimension_id` int(11) DEFAULT NULL,
1663 `dimension2_id` int(11) DEFAULT NULL,
1664 `purchase_cost` double NOT NULL DEFAULT '0',
1665 `material_cost` double NOT NULL DEFAULT '0',
1666 `labour_cost` double NOT NULL DEFAULT '0',
1667 `overhead_cost` double NOT NULL DEFAULT '0',
1668 `inactive` tinyint(1) NOT NULL DEFAULT '0',
1669 `no_sale` tinyint(1) NOT NULL DEFAULT '0',
1670 `no_purchase` tinyint(1) NOT NULL DEFAULT '0',
1671 `editable` tinyint(1) NOT NULL DEFAULT '0',
1672 `depreciation_method` char(1) NOT NULL DEFAULT 'S',
1673 `depreciation_rate` double NOT NULL DEFAULT '0',
1674 `depreciation_factor` double NOT NULL DEFAULT '1',
1675 `depreciation_start` date NOT NULL DEFAULT '0000-00-00',
1676 `depreciation_date` date NOT NULL DEFAULT '0000-00-00',
1677 `fa_class_id` varchar(20) NOT NULL DEFAULT '',
1678 `vat_category` tinyint(1) NOT NULL DEFAULT '0',
1679 `shipper_id` int(11) NOT NULL DEFAULT '0',
1680 PRIMARY KEY (`stock_id`)
1683 -- Data of table `0_stock_master` --
1685 INSERT INTO `0_stock_master` VALUES
1686 ('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', '', '0', '0'),
1687 ('102', '1', '1', 'iPhone 6 64GB', '', 'each', 'B', '4010', '5010', '1510', '5040', '1530', '0', '0', '150', '150', '0', '0', '0', '0', '0', '0', 'S', '0', '1', '0000-00-00', '0000-00-00', '', '0', '0'),
1688 ('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', '', '0', '0'),
1689 ('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', '', '0', '0'),
1690 ('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', '', '0', '0'),
1691 ('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', '', '0', '0'),
1692 ('post-std', '5', '1', 'Standard post package', '', 'each', 'T', '4430', '5010', '', '', '', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', 'S', '0', '1', '0000-00-00', '0000-00-00', '', '0', '0');
1694 -- Structure of table `0_stock_moves` --
1696 DROP TABLE IF EXISTS `0_stock_moves`;
1698 CREATE TABLE `0_stock_moves` (
1699 `trans_id` int(11) NOT NULL AUTO_INCREMENT,
1700 `trans_no` int(11) NOT NULL DEFAULT '0',
1701 `stock_id` char(20) NOT NULL DEFAULT '',
1702 `type` smallint(6) NOT NULL DEFAULT '0',
1703 `loc_code` char(5) NOT NULL DEFAULT '',
1704 `tran_date` date NOT NULL DEFAULT '0000-00-00',
1705 `price` double NOT NULL DEFAULT '0',
1706 `reference` char(40) NOT NULL DEFAULT '',
1707 `qty` double NOT NULL DEFAULT '1',
1708 `unit_cost` double NOT NULL DEFAULT '0',
1709 PRIMARY KEY (`trans_id`),
1710 KEY `type` (`type`,`trans_no`),
1711 KEY `Move` (`stock_id`,`loc_code`,`tran_date`)
1712 ) ENGINE=InnoDB AUTO_INCREMENT=18 ;
1714 -- Data of table `0_stock_moves` --
1716 INSERT INTO `0_stock_moves` VALUES
1717 ('1', '1', '101', '25', 'DEF', '2018-05-05', '200', '', '100', '200'),
1718 ('2', '1', '102', '25', 'DEF', '2018-05-05', '150', '', '100', '150'),
1719 ('3', '1', '103', '25', 'DEF', '2018-05-05', '10', '', '100', '10'),
1720 ('4', '1', '101', '13', 'DEF', '2018-05-10', '300', 'auto', '-20', '200'),
1721 ('5', '1', '301', '13', 'DEF', '2018-05-10', '80', 'auto', '-3', '0'),
1722 ('6', '1', '101', '29', 'DEF', '2018-05-05', '200', '001/2018', '-2', '200'),
1723 ('7', '1', '102', '29', 'DEF', '2018-05-05', '150', '001/2018', '-2', '150'),
1724 ('8', '1', '103', '29', 'DEF', '2018-05-05', '10', '001/2018', '-2', '10'),
1725 ('9', '1', '301', '29', 'DEF', '2018-05-05', '0', '001/2018', '-2', '0'),
1726 ('10', '1', '201', '26', 'DEF', '2018-05-05', '0', '001/2018', '2', '360'),
1727 ('11', '2', '101', '25', 'DEF', '2018-05-05', '200', '', '15', '200'),
1728 ('12', '2', '101', '13', 'DEF', '2018-05-07', '300', 'auto', '-1', '200'),
1729 ('13', '3', '102', '13', 'DEF', '2018-05-07', '222.62', 'auto', '-1', '150'),
1730 ('14', '3', '103', '13', 'DEF', '2018-05-07', '44.52', 'auto', '-1', '10'),
1731 ('15', '4', '202', '13', 'DEF', '2018-05-07', '0', 'auto', '-5', '0'),
1732 ('16', '5', '102', '13', 'DEF', '2019-01-21', '250', 'auto', '-5', '150'),
1733 ('17', '3', '102', '25', 'DEF', '2019-01-21', '150', '', '6', '150');
1735 -- Structure of table `0_supp_allocations` --
1737 DROP TABLE IF EXISTS `0_supp_allocations`;
1739 CREATE TABLE `0_supp_allocations` (
1740 `id` int(11) NOT NULL AUTO_INCREMENT,
1741 `person_id` int(11) DEFAULT NULL,
1742 `amt` double unsigned DEFAULT NULL,
1743 `date_alloc` date NOT NULL DEFAULT '0000-00-00',
1744 `trans_no_from` int(11) DEFAULT NULL,
1745 `trans_type_from` int(11) DEFAULT NULL,
1746 `trans_no_to` int(11) DEFAULT NULL,
1747 `trans_type_to` int(11) DEFAULT NULL,
1749 UNIQUE KEY `trans_type_from` (`person_id`,`trans_type_from`,`trans_no_from`,`trans_type_to`,`trans_no_to`),
1750 KEY `From` (`trans_type_from`,`trans_no_from`),
1751 KEY `To` (`trans_type_to`,`trans_no_to`)
1754 -- Data of table `0_supp_allocations` --
1756 -- Structure of table `0_supp_invoice_items` --
1758 DROP TABLE IF EXISTS `0_supp_invoice_items`;
1760 CREATE TABLE `0_supp_invoice_items` (
1761 `id` int(11) NOT NULL AUTO_INCREMENT,
1762 `supp_trans_no` int(11) DEFAULT NULL,
1763 `supp_trans_type` int(11) DEFAULT NULL,
1764 `gl_code` varchar(15) NOT NULL DEFAULT '',
1765 `grn_item_id` int(11) DEFAULT NULL,
1766 `po_detail_item_id` int(11) DEFAULT NULL,
1767 `stock_id` varchar(20) NOT NULL DEFAULT '',
1768 `description` tinytext,
1769 `quantity` double NOT NULL DEFAULT '0',
1770 `unit_price` double NOT NULL DEFAULT '0',
1771 `unit_tax` double NOT NULL DEFAULT '0',
1773 `dimension_id` int(11) NOT NULL DEFAULT '0',
1774 `dimension2_id` int(11) NOT NULL DEFAULT '0',
1776 KEY `Transaction` (`supp_trans_type`,`supp_trans_no`,`stock_id`)
1777 ) ENGINE=InnoDB AUTO_INCREMENT=3 ;
1779 -- Data of table `0_supp_invoice_items` --
1781 INSERT INTO `0_supp_invoice_items` VALUES
1782 ('1', '1', '20', '0', '4', '4', '101', 'iPad Air 2 16GB', '15', '200', '10', NULL, '0', '0'),
1783 ('2', '2', '20', '0', '5', '5', '102', 'iPhone 6 64GB', '6', '150', '7.5', NULL, '0', '0');
1785 -- Structure of table `0_supp_trans` --
1787 DROP TABLE IF EXISTS `0_supp_trans`;
1789 CREATE TABLE `0_supp_trans` (
1790 `trans_no` int(11) unsigned NOT NULL DEFAULT '0',
1791 `type` smallint(6) unsigned NOT NULL DEFAULT '0',
1792 `supplier_id` int(11) unsigned NOT NULL,
1793 `reference` tinytext NOT NULL,
1794 `supp_reference` varchar(60) NOT NULL DEFAULT '',
1795 `tran_date` date NOT NULL DEFAULT '0000-00-00',
1796 `due_date` date NOT NULL DEFAULT '0000-00-00',
1797 `ov_amount` double NOT NULL DEFAULT '0',
1798 `ov_discount` double NOT NULL DEFAULT '0',
1799 `ov_gst` double NOT NULL DEFAULT '0',
1800 `rate` double NOT NULL DEFAULT '1',
1801 `alloc` double NOT NULL DEFAULT '0',
1802 `tax_included` tinyint(1) NOT NULL DEFAULT '0',
1803 PRIMARY KEY (`type`,`trans_no`,`supplier_id`),
1804 KEY `supplier_id` (`supplier_id`),
1805 KEY `tran_date` (`tran_date`)
1808 -- Data of table `0_supp_trans` --
1810 INSERT INTO `0_supp_trans` VALUES
1811 ('1', '20', '1', '001/2018', 'rr4', '2018-05-05', '2018-05-15', '3000', '0', '150', '1', '0', '0'),
1812 ('2', '20', '1', '001/2019', 'asd5', '2019-01-21', '2019-01-31', '900', '0', '45', '1', '0', '0');
1814 -- Structure of table `0_suppliers` --
1816 DROP TABLE IF EXISTS `0_suppliers`;
1818 CREATE TABLE `0_suppliers` (
1819 `supplier_id` int(11) NOT NULL AUTO_INCREMENT,
1820 `supp_name` varchar(60) NOT NULL DEFAULT '',
1821 `supp_ref` varchar(30) NOT NULL DEFAULT '',
1822 `address` tinytext NOT NULL,
1823 `supp_address` tinytext NOT NULL,
1824 `gst_no` varchar(25) NOT NULL DEFAULT '',
1825 `contact` varchar(60) NOT NULL DEFAULT '',
1826 `supp_account_no` varchar(40) NOT NULL DEFAULT '',
1827 `website` varchar(100) NOT NULL DEFAULT '',
1828 `bank_account` varchar(60) NOT NULL DEFAULT '',
1829 `curr_code` char(3) DEFAULT NULL,
1830 `payment_terms` int(11) DEFAULT NULL,
1831 `tax_included` tinyint(1) NOT NULL DEFAULT '0',
1832 `dimension_id` int(11) DEFAULT '0',
1833 `dimension2_id` int(11) DEFAULT '0',
1834 `tax_group_id` int(11) DEFAULT NULL,
1835 `credit_limit` double NOT NULL DEFAULT '0',
1836 `purchase_account` varchar(15) NOT NULL DEFAULT '',
1837 `payable_account` varchar(15) NOT NULL DEFAULT '',
1838 `payment_discount_account` varchar(15) NOT NULL DEFAULT '',
1839 `notes` tinytext NOT NULL,
1840 `inactive` tinyint(1) NOT NULL DEFAULT '0',
1841 PRIMARY KEY (`supplier_id`),
1842 KEY `supp_ref` (`supp_ref`)
1843 ) ENGINE=InnoDB AUTO_INCREMENT=3 ;
1845 -- Data of table `0_suppliers` --
1847 INSERT INTO `0_suppliers` VALUES
1848 ('1', 'Dino Saurius Inc.', 'Dino Saurius', 'N/A', '', '987654321', '', '', '', '', 'USD', '3', '0', '0', '0', '1', '0', '', '2100', '5060', '', '0'),
1849 ('2', 'Beefeater Ltd.', 'Beefeater', 'N/A', '', '67565590', '', '', '', '', 'GBP', '4', '0', '0', '0', '1', '0', '', '2100', '5060', '', '0');
1851 -- Structure of table `0_sys_prefs` --
1853 DROP TABLE IF EXISTS `0_sys_prefs`;
1855 CREATE TABLE `0_sys_prefs` (
1856 `name` varchar(35) NOT NULL DEFAULT '',
1857 `category` varchar(30) DEFAULT NULL,
1858 `type` varchar(20) NOT NULL DEFAULT '',
1859 `length` smallint(6) DEFAULT NULL,
1860 `value` text NOT NULL,
1861 PRIMARY KEY (`name`),
1862 KEY `category` (`category`)
1865 -- Data of table `0_sys_prefs` --
1867 INSERT INTO `0_sys_prefs` VALUES
1868 ('coy_name', 'setup.company', 'varchar', 60, 'Company name'),
1869 ('gst_no', 'setup.company', 'varchar', 25, ''),
1870 ('coy_no', 'setup.company', 'varchar', 25, ''),
1871 ('tax_prd', 'setup.company', 'int', 11, '1'),
1872 ('tax_last', 'setup.company', 'int', 11, '1'),
1873 ('postal_address', 'setup.company', 'tinytext', 0, 'N/A'),
1874 ('phone', 'setup.company', 'varchar', 30, ''),
1875 ('fax', 'setup.company', 'varchar', 30, ''),
1876 ('email', 'setup.company', 'varchar', 100, ''),
1877 ('coy_logo', 'setup.company', 'varchar', 100, ''),
1878 ('domicile', 'setup.company', 'varchar', 55, ''),
1879 ('curr_default', 'setup.company', 'char', 3, 'USD'),
1880 ('use_dimension', 'setup.company', 'tinyint', 1, '1'),
1881 ('f_year', 'setup.company', 'int', 11, '2'),
1882 ('shortname_name_in_list','setup.company', 'tinyint', 1, '0'),
1883 ('no_item_list', 'setup.company', 'tinyint', 1, '0'),
1884 ('no_customer_list', 'setup.company', 'tinyint', 1, '0'),
1885 ('no_supplier_list', 'setup.company', 'tinyint', 1, '0'),
1886 ('base_sales', 'setup.company', 'int', 11, '1'),
1887 ('time_zone', 'setup.company', 'tinyint', 1, '0'),
1888 ('add_pct', 'setup.company', 'int', 5, '-1'),
1889 ('round_to', 'setup.company', 'int', 5, '1'),
1890 ('login_tout', 'setup.company', 'smallint', 6, '600'),
1891 ('past_due_days', 'glsetup.general', 'int', 11, '30'),
1892 ('profit_loss_year_act', 'glsetup.general', 'varchar', 15, '9990'),
1893 ('retained_earnings_act', 'glsetup.general', 'varchar', 15, '3590'),
1894 ('bank_charge_act', 'glsetup.general', 'varchar', 15, '5690'),
1895 ('exchange_diff_act', 'glsetup.general', 'varchar', 15, '4450'),
1896 ('tax_algorithm', 'glsetup.customer', 'tinyint', 1, '1'),
1897 ('default_credit_limit', 'glsetup.customer', 'int', 11, '1000'),
1898 ('accumulate_shipping', 'glsetup.customer', 'tinyint', 1, '0'),
1899 ('legal_text', 'glsetup.customer', 'tinytext', 0, ''),
1900 ('freight_act', 'glsetup.customer', 'varchar', 15, '4430'),
1901 ('debtors_act', 'glsetup.sales', 'varchar', 15, '1200'),
1902 ('default_sales_act', 'glsetup.sales', 'varchar', 15, '4010'),
1903 ('default_sales_discount_act', 'glsetup.sales', 'varchar', 15, '4510'),
1904 ('default_prompt_payment_act', 'glsetup.sales', 'varchar', 15, '4500'),
1905 ('default_delivery_required', 'glsetup.sales', 'smallint', 6, '1'),
1906 ('default_receival_required', 'glsetup.purchase', 'smallint', 6, '10'),
1907 ('default_quote_valid_days', 'glsetup.sales', 'smallint', 6, '30'),
1908 ('default_dim_required', 'glsetup.dims', 'int', 11, '20'),
1909 ('pyt_discount_act', 'glsetup.purchase', 'varchar', 15, '5060'),
1910 ('creditors_act', 'glsetup.purchase', 'varchar', 15, '2100'),
1911 ('po_over_receive', 'glsetup.purchase', 'int', 11, '10'),
1912 ('po_over_charge', 'glsetup.purchase', 'int', 11, '10'),
1913 ('allow_negative_stock', 'glsetup.inventory', 'tinyint', 1, '0'),
1914 ('default_inventory_act', 'glsetup.items', 'varchar', 15, '1510'),
1915 ('default_cogs_act', 'glsetup.items', 'varchar', 15, '5010'),
1916 ('default_adj_act', 'glsetup.items', 'varchar', 15, '5040'),
1917 ('default_inv_sales_act', 'glsetup.items', 'varchar', 15, '4010'),
1918 ('default_wip_act', 'glsetup.items', 'varchar', 15, '1530'),
1919 ('default_workorder_required', 'glsetup.manuf', 'int', 11, '20'),
1920 ('version_id', 'system', 'varchar', 11, '2.5.0'),
1921 ('auto_curr_reval', 'setup.company', 'smallint', 6, '1'),
1922 ('grn_clearing_act', 'glsetup.purchase', 'varchar', 15, '1550'),
1923 ('bcc_email', 'setup.company', 'varchar', 100, ''),
1924 ('deferred_income_act', 'glsetup.sales', 'varchar', '15', '2105'),
1925 ('gl_closing_date','setup.closing_date', 'date', 8, ''),
1926 ('alternative_tax_include_on_docs','setup.company', 'tinyint', 1, '0'),
1927 ('no_zero_lines_amount','glsetup.sales', 'tinyint', 1, '1'),
1928 ('show_po_item_codes','glsetup.purchase', 'tinyint', 1, '0'),
1929 ('accounts_alpha','glsetup.general', 'tinyint', 1, '0'),
1930 ('loc_notification','glsetup.inventory', 'tinyint', 1, '0'),
1931 ('print_invoice_no','glsetup.sales', 'tinyint', 1, '0'),
1932 ('allow_negative_prices','glsetup.inventory', 'tinyint', 1, '1'),
1933 ('print_item_images_on_quote','glsetup.inventory', 'tinyint', 1, '0'),
1934 ('suppress_tax_rates','setup.company', 'tinyint', 1, '0'),
1935 ('company_logo_report','setup.company', 'tinyint', 1, '0'),
1936 ('barcodes_on_stock','setup.company', 'tinyint', 1, '0'),
1937 ('print_dialog_direct','setup.company', 'tinyint', 1, '0'),
1938 ('ref_no_auto_increase','setup.company', 'tinyint', 1, '0'),
1939 ('default_loss_on_asset_disposal_act', 'glsetup.items', 'varchar', '15', '5660'),
1940 ('depreciation_period', 'glsetup.company', 'tinyint', '1', '1'),
1941 ('use_manufacturing','setup.company', 'tinyint', 1, '1'),
1942 ('use_fixed_assets','setup.company', 'tinyint', 1, '1');
1944 -- Structure of table `0_tag_associations` --
1946 DROP TABLE IF EXISTS `0_tag_associations`;
1948 CREATE TABLE `0_tag_associations` (
1949 `record_id` varchar(15) NOT NULL,
1950 `tag_id` int(11) NOT NULL,
1951 PRIMARY KEY (`record_id`,`tag_id`)
1954 -- Data of table `0_tag_associations` --
1956 -- Structure of table `0_tags` --
1958 DROP TABLE IF EXISTS `0_tags`;
1960 CREATE TABLE `0_tags` (
1961 `id` int(11) NOT NULL AUTO_INCREMENT,
1962 `type` smallint(6) NOT NULL,
1963 `name` varchar(30) NOT NULL,
1964 `description` varchar(60) DEFAULT NULL,
1965 `inactive` tinyint(1) NOT NULL DEFAULT '0',
1967 UNIQUE KEY `type` (`type`,`name`)
1970 -- Data of table `0_tags` --
1972 -- Structure of table `0_tax_group_items` --
1974 DROP TABLE IF EXISTS `0_tax_group_items`;
1976 CREATE TABLE `0_tax_group_items` (
1977 `tax_group_id` int(11) NOT NULL DEFAULT '0',
1978 `tax_type_id` int(11) NOT NULL DEFAULT '0',
1979 PRIMARY KEY (`tax_group_id`,`tax_type_id`)
1982 -- Data of table `0_tax_group_items` --
1984 INSERT INTO `0_tax_group_items` VALUES
1987 -- Structure of table `0_tax_groups` --
1989 DROP TABLE IF EXISTS `0_tax_groups`;
1991 CREATE TABLE `0_tax_groups` (
1992 `id` int(11) NOT NULL AUTO_INCREMENT,
1993 `name` varchar(60) NOT NULL DEFAULT '',
1994 `tax_area` tinyint(1) NOT NULL DEFAULT '0',
1995 `inactive` tinyint(1) NOT NULL DEFAULT '0',
1997 UNIQUE KEY `name` (`name`)
1998 ) ENGINE=InnoDB AUTO_INCREMENT=3 ;
2000 -- Data of table `0_tax_groups` --
2002 INSERT INTO `0_tax_groups` VALUES
2003 ('1', 'Tax', '0', '0'),
2004 ('2', 'Export/Import', '1', '0');
2006 -- Structure of table `0_tax_types` --
2008 DROP TABLE IF EXISTS `0_tax_types`;
2010 CREATE TABLE `0_tax_types` (
2011 `id` int(11) NOT NULL AUTO_INCREMENT,
2012 `rate` double NOT NULL DEFAULT '0',
2013 `sales_gl_code` varchar(15) NOT NULL DEFAULT '',
2014 `purchasing_gl_code` varchar(15) NOT NULL DEFAULT '',
2015 `name` varchar(60) NOT NULL DEFAULT '',
2016 `inactive` tinyint(1) NOT NULL DEFAULT '0',
2018 ) ENGINE=InnoDB AUTO_INCREMENT=2 ;
2020 -- Data of table `0_tax_types` --
2022 INSERT INTO `0_tax_types` VALUES
2023 ('1', '5', '2150', '2150', 'Tax', '0');
2025 -- Structure of table `0_trans_tax_details` --
2027 DROP TABLE IF EXISTS `0_trans_tax_details`;
2029 CREATE TABLE `0_trans_tax_details` (
2030 `id` int(11) NOT NULL AUTO_INCREMENT,
2031 `trans_type` smallint(6) DEFAULT NULL,
2032 `trans_no` int(11) DEFAULT NULL,
2033 `tran_date` date NOT NULL,
2034 `tax_type_id` int(11) NOT NULL DEFAULT '0',
2035 `rate` double NOT NULL DEFAULT '0',
2036 `ex_rate` double NOT NULL DEFAULT '1',
2037 `included_in_price` tinyint(1) NOT NULL DEFAULT '0',
2038 `net_amount` double NOT NULL DEFAULT '0',
2039 `amount` double NOT NULL DEFAULT '0',
2041 `reg_type` tinyint(1) DEFAULT NULL,
2042 `vat_category` int(11) NOT NULL DEFAULT '0',
2043 `tax_group_id` tinyint(2) DEFAULT NULL,
2045 KEY `Type_and_Number` (`trans_type`,`trans_no`),
2046 KEY `tran_date` (`tran_date`)
2047 ) ENGINE=InnoDB AUTO_INCREMENT=11 ;
2049 -- Data of table `0_trans_tax_details` --
2051 INSERT INTO `0_trans_tax_details` VALUES
2052 ('1', '13', '1', '2018-05-10', '1', '5', '1', '1', '5942.86', '297.14', 'auto', NULL, '0', '1'),
2053 ('2', '10', '1', '2018-05-10', '1', '5', '1', '1', '5942.86', '297.14', '001/2018', '0', '0', '1'),
2054 ('3', '20', '1', '2018-05-05', '1', '5', '1', '0', '3000', '150', 'rr4', '1', '0', '1'),
2055 ('4', '13', '2', '2018-05-07', '1', '5', '1', '1', '285.71', '14.29', 'auto', NULL, '0', '1'),
2056 ('5', '10', '2', '2018-05-07', '1', '5', '1', '1', '285.71', '14.29', '002/2018', '0', '0', '1'),
2057 ('6', '13', '3', '2018-05-07', '0', '0', '1.123', '1', '267.14', '0', 'auto', NULL, '0', '1'),
2058 ('7', '10', '3', '2018-05-07', '0', '0', '1.123', '1', '267.14', '0', '003/2018', '0', '0', '1'),
2059 ('8', '13', '5', '2019-01-21', '1', '5', '1', '1', '1190.48', '59.52', 'auto', NULL, '0', '1'),
2060 ('9', '10', '5', '2019-01-21', '1', '5', '1', '1', '1190.48', '59.52', '001/2019', '0', '0', '1'),
2061 ('10', '20', '2', '2019-01-21', '1', '5', '1', '0', '900', '45', 'asd5', '1', '0', '1');
2063 -- Structure of table `0_useronline` --
2065 DROP TABLE IF EXISTS `0_useronline`;
2067 CREATE TABLE `0_useronline` (
2068 `id` int(11) NOT NULL AUTO_INCREMENT,
2069 `timestamp` int(15) NOT NULL DEFAULT '0',
2070 `ip` varchar(40) NOT NULL DEFAULT '',
2071 `file` varchar(100) NOT NULL DEFAULT '',
2073 KEY `timestamp` (`timestamp`),
2077 -- Data of table `0_useronline` --
2080 -- Structure of table `0_users` --
2082 DROP TABLE IF EXISTS `0_users`;
2084 CREATE TABLE `0_users` (
2085 `id` smallint(6) NOT NULL AUTO_INCREMENT,
2086 `user_id` varchar(60) NOT NULL DEFAULT '',
2087 `password` varchar(100) NOT NULL DEFAULT '',
2088 `real_name` varchar(100) NOT NULL DEFAULT '',
2089 `role_id` int(11) NOT NULL DEFAULT '1',
2090 `phone` varchar(30) NOT NULL DEFAULT '',
2091 `email` varchar(100) DEFAULT NULL,
2092 `language` varchar(20) DEFAULT NULL,
2093 `date_format` tinyint(1) NOT NULL DEFAULT '0',
2094 `date_sep` tinyint(1) NOT NULL DEFAULT '0',
2095 `tho_sep` tinyint(1) NOT NULL DEFAULT '0',
2096 `dec_sep` tinyint(1) NOT NULL DEFAULT '0',
2097 `theme` varchar(20) NOT NULL DEFAULT 'default',
2098 `page_size` varchar(20) NOT NULL DEFAULT 'A4',
2099 `prices_dec` smallint(6) NOT NULL DEFAULT '2',
2100 `qty_dec` smallint(6) NOT NULL DEFAULT '2',
2101 `rates_dec` smallint(6) NOT NULL DEFAULT '4',
2102 `percent_dec` smallint(6) NOT NULL DEFAULT '1',
2103 `show_gl` tinyint(1) NOT NULL DEFAULT '1',
2104 `show_codes` tinyint(1) NOT NULL DEFAULT '0',
2105 `show_hints` tinyint(1) NOT NULL DEFAULT '0',
2106 `last_visit_date` datetime DEFAULT NULL,
2107 `query_size` tinyint(1) unsigned NOT NULL DEFAULT '10',
2108 `graphic_links` tinyint(1) DEFAULT '1',
2109 `pos` smallint(6) DEFAULT '1',
2110 `print_profile` varchar(30) NOT NULL DEFAULT '',
2111 `rep_popup` tinyint(1) DEFAULT '1',
2112 `sticky_doc_date` tinyint(1) DEFAULT '0',
2113 `startup_tab` varchar(20) NOT NULL DEFAULT '',
2114 `transaction_days` smallint(6) NOT NULL DEFAULT '30',
2115 `save_report_selections` smallint(6) NOT NULL DEFAULT '0',
2116 `use_date_picker` tinyint(1) NOT NULL DEFAULT '1',
2117 `def_print_destination` tinyint(1) NOT NULL DEFAULT '0',
2118 `def_print_orientation` tinyint(1) NOT NULL DEFAULT '0',
2119 `inactive` tinyint(1) NOT NULL DEFAULT '0',
2121 UNIQUE KEY `user_id` (`user_id`)
2122 ) ENGINE=InnoDB AUTO_INCREMENT=2 ;
2124 -- Data of table `0_users` --
2126 INSERT INTO `0_users` VALUES
2127 ('1', 'admin', '5f4dcc3b5aa765d61d8327deb882cf99', 'Administrator', '2', '', 'adm@example.com', 'C', '0', '0', '0', '0', 'default', 'Letter', '2', '2', '4', '1', '1', '0', '0', '2018-05-07 13:58:33', '10', '1', '1', '1', '1', '0', 'orders', '30', '0', '1', '0', '0', '0');
2129 -- Structure of table `0_voided` --
2131 DROP TABLE IF EXISTS `0_voided`;
2133 CREATE TABLE `0_voided` (
2134 `type` int(11) NOT NULL DEFAULT '0',
2135 `id` int(11) NOT NULL DEFAULT '0',
2136 `date_` date NOT NULL DEFAULT '0000-00-00',
2137 `memo_` tinytext NOT NULL,
2138 UNIQUE KEY `id` (`type`,`id`)
2141 -- Data of table `0_voided` --
2144 -- Structure of table `0_wo_costing` --
2146 DROP TABLE IF EXISTS `0_wo_costing`;
2148 CREATE TABLE `0_wo_costing` (
2149 `id` int(11) NOT NULL AUTO_INCREMENT,
2150 `workorder_id` int(11) NOT NULL DEFAULT '0',
2151 `cost_type` tinyint(1) NOT NULL DEFAULT '0',
2152 `trans_type` int(11) NOT NULL DEFAULT '0',
2153 `trans_no` int(11) NOT NULL DEFAULT '0',
2154 `factor` double NOT NULL DEFAULT '1',
2158 -- Data of table `0_wo_costing` --
2160 -- Structure of table `0_wo_issue_items` --
2162 DROP TABLE IF EXISTS `0_wo_issue_items`;
2164 CREATE TABLE `0_wo_issue_items` (
2165 `id` int(11) NOT NULL AUTO_INCREMENT,
2166 `stock_id` varchar(40) DEFAULT NULL,
2167 `issue_id` int(11) DEFAULT NULL,
2168 `qty_issued` double DEFAULT NULL,
2169 `unit_cost` double NOT NULL DEFAULT '0',
2173 -- Data of table `0_wo_issue_items` --
2176 -- Structure of table `0_wo_issues` --
2178 DROP TABLE IF EXISTS `0_wo_issues`;
2180 CREATE TABLE `0_wo_issues` (
2181 `issue_no` int(11) NOT NULL AUTO_INCREMENT,
2182 `workorder_id` int(11) NOT NULL DEFAULT '0',
2183 `reference` varchar(100) DEFAULT NULL,
2184 `issue_date` date DEFAULT NULL,
2185 `loc_code` varchar(5) DEFAULT NULL,
2186 `workcentre_id` int(11) DEFAULT NULL,
2187 PRIMARY KEY (`issue_no`),
2188 KEY `workorder_id` (`workorder_id`)
2191 -- Data of table `0_wo_issues` --
2193 -- Structure of table `0_wo_manufacture` --
2195 DROP TABLE IF EXISTS `0_wo_manufacture`;
2197 CREATE TABLE `0_wo_manufacture` (
2198 `id` int(11) NOT NULL AUTO_INCREMENT,
2199 `reference` varchar(100) DEFAULT NULL,
2200 `workorder_id` int(11) NOT NULL DEFAULT '0',
2201 `quantity` double NOT NULL DEFAULT '0',
2202 `date_` date NOT NULL DEFAULT '0000-00-00',
2204 KEY `workorder_id` (`workorder_id`)
2205 ) ENGINE=InnoDB AUTO_INCREMENT=2 ;
2207 -- Data of table `0_wo_manufacture` --
2209 INSERT INTO `0_wo_manufacture` VALUES
2210 ('1', '001/2018', '1', '2', '2018-05-05');
2212 -- Structure of table `0_wo_requirements` --
2214 DROP TABLE IF EXISTS `0_wo_requirements`;
2216 CREATE TABLE `0_wo_requirements` (
2217 `id` int(11) NOT NULL AUTO_INCREMENT,
2218 `workorder_id` int(11) NOT NULL DEFAULT '0',
2219 `stock_id` char(20) NOT NULL DEFAULT '',
2220 `workcentre` int(11) NOT NULL DEFAULT '0',
2221 `units_req` double NOT NULL DEFAULT '1',
2222 `unit_cost` double NOT NULL DEFAULT '0',
2223 `loc_code` char(5) NOT NULL DEFAULT '',
2224 `units_issued` double NOT NULL DEFAULT '0',
2226 KEY `workorder_id` (`workorder_id`)
2227 ) ENGINE=InnoDB AUTO_INCREMENT=9 ;
2229 -- Data of table `0_wo_requirements` --
2231 INSERT INTO `0_wo_requirements` VALUES
2232 ('1', '1', '101', '1', '1', '200', 'DEF', '2'),
2233 ('2', '1', '102', '1', '1', '150', 'DEF', '2'),
2234 ('3', '1', '103', '1', '1', '10', 'DEF', '2'),
2235 ('4', '1', '301', '1', '1', '0', 'DEF', '2'),
2236 ('5', '2', '101', '1', '1', '200', 'DEF', '0'),
2237 ('6', '2', '102', '1', '1', '150', 'DEF', '0'),
2238 ('7', '2', '103', '1', '1', '10', 'DEF', '0'),
2239 ('8', '2', '301', '1', '1', '0', 'DEF', '0');
2241 -- Structure of table `0_workcentres` --
2243 DROP TABLE IF EXISTS `0_workcentres`;
2245 CREATE TABLE `0_workcentres` (
2246 `id` int(11) NOT NULL AUTO_INCREMENT,
2247 `name` char(40) NOT NULL DEFAULT '',
2248 `description` char(50) NOT NULL DEFAULT '',
2249 `inactive` tinyint(1) NOT NULL DEFAULT '0',
2251 UNIQUE KEY `name` (`name`)
2252 ) ENGINE=InnoDB AUTO_INCREMENT=2 ;
2254 -- Data of table `0_workcentres` --
2256 INSERT INTO `0_workcentres` VALUES
2257 ('1', 'Work Centre', '', '0');
2259 -- Structure of table `0_workorders` --
2261 DROP TABLE IF EXISTS `0_workorders`;
2263 CREATE TABLE `0_workorders` (
2264 `id` int(11) NOT NULL AUTO_INCREMENT,
2265 `wo_ref` varchar(60) NOT NULL DEFAULT '',
2266 `loc_code` varchar(5) NOT NULL DEFAULT '',
2267 `units_reqd` double NOT NULL DEFAULT '1',
2268 `stock_id` varchar(20) NOT NULL DEFAULT '',
2269 `date_` date NOT NULL DEFAULT '0000-00-00',
2270 `type` tinyint(4) NOT NULL DEFAULT '0',
2271 `required_by` date NOT NULL DEFAULT '0000-00-00',
2272 `released_date` date NOT NULL DEFAULT '0000-00-00',
2273 `units_issued` double NOT NULL DEFAULT '0',
2274 `closed` tinyint(1) NOT NULL DEFAULT '0',
2275 `released` tinyint(1) NOT NULL DEFAULT '0',
2277 KEY `wo_ref` (`wo_ref`)
2278 ) ENGINE=InnoDB AUTO_INCREMENT=4 ;
2280 -- Data of table `0_workorders` --
2282 INSERT INTO `0_workorders` VALUES
2283 ('1', '001/2018', 'DEF', '2', '201', '2018-05-05', '0', '2018-05-05', '2018-05-05', '2', '1', '1'),
2284 ('2', '002/2018', 'DEF', '5', '201', '2018-05-07', '2', '2018-05-27', '2018-05-07', '0', '0', '1'),
2285 ('3', '003/2018', 'DEF', '5', '201', '2018-05-07', '2', '2018-05-27', '0000-00-00', '0', '0', '0');