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 `pymt_discount` double NOT NULL DEFAULT '0',
702 `credit_limit` float NOT NULL DEFAULT '1000',
703 `notes` tinytext NOT NULL,
704 `inactive` tinyint(1) NOT NULL DEFAULT '0',
705 PRIMARY KEY (`debtor_no`),
706 UNIQUE KEY `debtor_ref` (`debtor_ref`),
708 ) ENGINE=InnoDB AUTO_INCREMENT=3 ;
710 -- Data of table `0_debtors_master` --
712 INSERT INTO `0_debtors_master` VALUES
713 ('1', 'Donald Easter LLC', 'Donald Easter', 'N/A', '123456789', 'USD', '1', '0', '0', '1', '4', '0', '0', '1000', '', '0'),
714 ('2', 'MoneyMaker Ltd.', 'MoneyMaker', 'N/A', '54354333', 'EUR', '1', '1', '0', '1', '1', '0', '0', '1000', '', '0');
716 -- Structure of table `0_dimensions` --
718 DROP TABLE IF EXISTS `0_dimensions`;
720 CREATE TABLE `0_dimensions` (
721 `id` int(11) NOT NULL AUTO_INCREMENT,
722 `reference` varchar(60) NOT NULL DEFAULT '',
723 `name` varchar(60) NOT NULL DEFAULT '',
724 `type_` tinyint(1) NOT NULL DEFAULT '1',
725 `closed` tinyint(1) NOT NULL DEFAULT '0',
726 `date_` date NOT NULL DEFAULT '0000-00-00',
727 `due_date` date NOT NULL DEFAULT '0000-00-00',
729 UNIQUE KEY `reference` (`reference`),
730 KEY `date_` (`date_`),
731 KEY `due_date` (`due_date`),
732 KEY `type_` (`type_`)
733 ) ENGINE=InnoDB AUTO_INCREMENT=2 ;
735 -- Data of table `0_dimensions` --
737 INSERT INTO `0_dimensions` VALUES
738 ('1', '001/2018', 'Cost Centre', '1', '0', '2018-05-05', '2018-05-25');
740 -- Structure of table `0_exchange_rates` --
742 DROP TABLE IF EXISTS `0_exchange_rates`;
744 CREATE TABLE `0_exchange_rates` (
745 `id` int(11) NOT NULL AUTO_INCREMENT,
746 `curr_code` char(3) NOT NULL DEFAULT '',
747 `rate_buy` double NOT NULL DEFAULT '0',
748 `rate_sell` double NOT NULL DEFAULT '0',
749 `date_` date NOT NULL DEFAULT '0000-00-00',
751 UNIQUE KEY `curr_code` (`curr_code`,`date_`)
752 ) ENGINE=InnoDB AUTO_INCREMENT=2 ;
754 -- Data of table `0_exchange_rates` --
756 INSERT INTO `0_exchange_rates` VALUES
757 ('1', 'EUR', '1.123', '1.123', '2018-05-07');
759 -- Structure of table `0_fiscal_year` --
761 DROP TABLE IF EXISTS `0_fiscal_year`;
763 CREATE TABLE `0_fiscal_year` (
764 `id` int(11) NOT NULL AUTO_INCREMENT,
765 `begin` date DEFAULT '0000-00-00',
766 `end` date DEFAULT '0000-00-00',
767 `closed` tinyint(1) NOT NULL DEFAULT '0',
769 UNIQUE KEY `begin` (`begin`),
770 UNIQUE KEY `end` (`end`)
771 ) ENGINE=InnoDB AUTO_INCREMENT=3 ;
773 -- Data of table `0_fiscal_year` --
775 INSERT INTO `0_fiscal_year` VALUES
776 ('1', '2018-01-01', '2018-12-31', '1'),
777 ('2', '2019-01-01', '2019-12-31', '0');
779 -- Structure of table `0_gl_trans` --
781 DROP TABLE IF EXISTS `0_gl_trans`;
783 CREATE TABLE `0_gl_trans` (
784 `counter` int(11) NOT NULL AUTO_INCREMENT,
785 `type` smallint(6) NOT NULL DEFAULT '0',
786 `type_no` int(11) NOT NULL DEFAULT '0',
787 `tran_date` date NOT NULL DEFAULT '0000-00-00',
788 `account` varchar(15) NOT NULL DEFAULT '',
789 `memo_` tinytext NOT NULL,
790 `amount` double NOT NULL DEFAULT '0',
791 `dimension_id` int(11) NOT NULL DEFAULT '0',
792 `dimension2_id` int(11) NOT NULL DEFAULT '0',
793 `person_type_id` int(11) DEFAULT NULL,
794 `person_id` tinyblob,
795 PRIMARY KEY (`counter`),
796 KEY `Type_and_Number` (`type`,`type_no`),
797 KEY `dimension_id` (`dimension_id`),
798 KEY `dimension2_id` (`dimension2_id`),
799 KEY `tran_date` (`tran_date`),
800 KEY `account_and_tran_date` (`account`,`tran_date`)
801 ) ENGINE=InnoDB AUTO_INCREMENT=55 ;
803 -- Data of table `0_gl_trans` --
805 INSERT INTO `0_gl_trans` VALUES
806 ('1', '25', '1', '2018-05-05', '1510', '101', '20000', '0', '0', NULL, NULL),
807 ('2', '25', '1', '2018-05-05', '1510', '102', '15000', '0', '0', NULL, NULL),
808 ('3', '25', '1', '2018-05-05', '1510', '103', '1000', '0', '0', NULL, NULL),
809 ('4', '25', '1', '2018-05-05', '1550', '', '-36000', '0', '0', NULL, NULL),
810 ('5', '13', '1', '2018-05-10', '5010', '', '4000', '0', '0', NULL, NULL),
811 ('6', '13', '1', '2018-05-10', '1510', '', '-4000', '0', '0', NULL, NULL),
812 ('7', '10', '1', '2018-05-10', '4010', '', '-5714.29', '0', '0', NULL, NULL),
813 ('8', '10', '1', '2018-05-10', '4010', '', '-228.57', '0', '0', NULL, NULL),
814 ('9', '10', '1', '2018-05-10', '1200', '', '6240', '0', '0', '2', '1'),
815 ('10', '10', '1', '2018-05-10', '2150', '', '-297.14', '0', '0', NULL, NULL),
816 ('11', '12', '1', '2018-05-10', '1065', '', '6240', '0', '0', NULL, NULL),
817 ('12', '12', '1', '2018-05-10', '1200', '', '-6240', '0', '0', '2', '1'),
818 ('13', '29', '1', '2018-05-05', '1510', '1 * iPad Air 2 16GB', '-400', '0', '0', NULL, NULL),
819 ('14', '29', '1', '2018-05-05', '1510', '1 * iPhone 6 64GB', '-300', '0', '0', NULL, NULL),
820 ('15', '29', '1', '2018-05-05', '1510', '1 * iPhone Cover Case', '-20', '0', '0', NULL, NULL),
821 ('16', '29', '1', '2018-05-05', '1530', '1 * Support', '720', '0', '0', NULL, NULL),
822 ('17', '26', '1', '2018-05-05', '1530', '', '-720', '0', '0', NULL, NULL),
823 ('18', '26', '1', '2018-05-05', '1510', '', '720', '0', '0', NULL, NULL),
824 ('19', '25', '2', '2018-05-05', '1510', '101', '3000', '0', '0', NULL, NULL),
825 ('20', '25', '2', '2018-05-05', '1550', '', '-3000', '0', '0', NULL, NULL),
826 ('21', '20', '1', '2018-05-05', '2150', '', '150', '0', '0', NULL, NULL),
827 ('22', '20', '1', '2018-05-05', '2100', '', '-3150', '0', '0', '3', '1'),
828 ('23', '20', '1', '2018-05-05', '1550', '', '3000', '0', '0', NULL, NULL),
829 ('24', '13', '2', '2018-05-07', '5010', '', '200', '0', '0', NULL, NULL),
830 ('25', '13', '2', '2018-05-07', '1510', '', '-200', '0', '0', NULL, NULL),
831 ('26', '10', '2', '2018-05-07', '4010', '', '-285.71', '0', '0', NULL, NULL),
832 ('27', '10', '2', '2018-05-07', '1200', '', '300', '0', '0', '2', '1'),
833 ('28', '10', '2', '2018-05-07', '2150', '', '-14.29', '0', '0', NULL, NULL),
834 ('29', '12', '2', '2018-05-07', '1065', '', '300', '0', '0', NULL, NULL),
835 ('30', '12', '2', '2018-05-07', '1200', '', '-300', '0', '0', '2', '1'),
836 ('31', '13', '3', '2018-05-07', '5010', '', '150', '1', '0', NULL, NULL),
837 ('32', '13', '3', '2018-05-07', '1510', '', '-150', '0', '0', NULL, NULL),
838 ('33', '13', '3', '2018-05-07', '5010', '', '10', '1', '0', NULL, NULL),
839 ('34', '13', '3', '2018-05-07', '1510', '', '-10', '0', '0', NULL, NULL),
840 ('35', '10', '3', '2018-05-07', '4010', '', '-250', '1', '0', NULL, NULL),
841 ('36', '10', '3', '2018-05-07', '4010', '', '-50', '1', '0', NULL, NULL),
842 ('37', '10', '3', '2018-05-07', '1200', '', '300', '0', '0', '2', '2'),
843 ('38', '12', '3', '2018-05-07', '1065', '', '0', '0', '0', NULL, NULL),
844 ('39', '1', '1', '2018-05-07', '5010', '', '5', '1', '0', NULL, NULL),
845 ('40', '1', '1', '2018-05-07', '1060', '', '-5', '0', '0', NULL, NULL),
846 ('41', '13', '5', '2019-01-21', '5010', '', '750', '0', '0', NULL, NULL),
847 ('42', '13', '5', '2019-01-21', '1510', '', '-750', '0', '0', NULL, NULL),
848 ('43', '10', '5', '2019-01-21', '4010', '', '-1190.48', '0', '0', NULL, NULL),
849 ('44', '10', '5', '2019-01-21', '1200', '', '1250', '0', '0', '2', '1'),
850 ('45', '10', '5', '2019-01-21', '2150', '', '-59.52', '0', '0', NULL, NULL),
851 ('46', '12', '4', '2019-01-21', '1065', '', '1250', '0', '0', NULL, NULL),
852 ('47', '12', '4', '2019-01-21', '1200', '', '-1250', '0', '0', '2', '1'),
853 ('48', '25', '3', '2019-01-21', '1510', '102', '900', '0', '0', NULL, NULL),
854 ('49', '25', '3', '2019-01-21', '1550', '', '-900', '0', '0', NULL, NULL),
855 ('50', '20', '2', '2019-01-21', '2150', '', '45', '0', '0', NULL, NULL),
856 ('51', '20', '2', '2019-01-21', '2100', '', '-945', '0', '0', '3', '1'),
857 ('52', '20', '2', '2019-01-21', '1550', '', '900', '0', '0', NULL, NULL),
858 ('53', '0', '1', '2018-12-31', '3590', 'Closing Year', '-2163.57', '0', '0', NULL, NULL),
859 ('54', '0', '1', '2018-12-31', '9990', 'Closing Year', '2163.57', '0', '0', NULL, NULL);
861 -- Structure of table `0_grn_batch` --
863 DROP TABLE IF EXISTS `0_grn_batch`;
865 CREATE TABLE `0_grn_batch` (
866 `id` int(11) NOT NULL AUTO_INCREMENT,
867 `supplier_id` int(11) NOT NULL DEFAULT '0',
868 `purch_order_no` int(11) DEFAULT NULL,
869 `reference` varchar(60) NOT NULL DEFAULT '',
870 `delivery_date` date NOT NULL DEFAULT '0000-00-00',
871 `loc_code` varchar(5) DEFAULT NULL,
872 `rate` double DEFAULT '1',
874 KEY `delivery_date` (`delivery_date`),
875 KEY `purch_order_no` (`purch_order_no`)
876 ) ENGINE=InnoDB AUTO_INCREMENT=4 ;
878 -- Data of table `0_grn_batch` --
880 INSERT INTO `0_grn_batch` VALUES
881 ('1', '1', '1', '001/2018', '2018-05-05', 'DEF', '1'),
882 ('2', '1', '2', 'auto', '2018-05-05', 'DEF', '1'),
883 ('3', '1', '3', 'auto', '2019-01-21', 'DEF', '1');
885 -- Structure of table `0_grn_items` --
887 DROP TABLE IF EXISTS `0_grn_items`;
889 CREATE TABLE `0_grn_items` (
890 `id` int(11) NOT NULL AUTO_INCREMENT,
891 `grn_batch_id` int(11) DEFAULT NULL,
892 `po_detail_item` int(11) NOT NULL DEFAULT '0',
893 `item_code` varchar(20) NOT NULL DEFAULT '',
894 `description` tinytext,
895 `qty_recd` double NOT NULL DEFAULT '0',
896 `quantity_inv` double NOT NULL DEFAULT '0',
898 KEY `grn_batch_id` (`grn_batch_id`)
899 ) ENGINE=InnoDB AUTO_INCREMENT=6 ;
901 -- Data of table `0_grn_items` --
903 INSERT INTO `0_grn_items` VALUES
904 ('1', '1', '1', '101', 'iPad Air 2 16GB', '100', '0'),
905 ('2', '1', '2', '102', 'iPhone 6 64GB', '100', '0'),
906 ('3', '1', '3', '103', 'iPhone Cover Case', '100', '0'),
907 ('4', '2', '4', '101', 'iPad Air 2 16GB', '15', '15'),
908 ('5', '3', '5', '102', 'iPhone 6 64GB', '6', '6');
910 -- Structure of table `0_groups` --
912 DROP TABLE IF EXISTS `0_groups`;
914 CREATE TABLE `0_groups` (
915 `id` smallint(6) unsigned NOT NULL AUTO_INCREMENT,
916 `description` varchar(60) NOT NULL DEFAULT '',
917 `inactive` tinyint(1) NOT NULL DEFAULT '0',
919 UNIQUE KEY `description` (`description`)
920 ) ENGINE=InnoDB AUTO_INCREMENT=4 ;
922 -- Data of table `0_groups` --
924 INSERT INTO `0_groups` VALUES
926 ('2', 'Medium', '0'),
929 -- Structure of table `0_item_codes` --
931 DROP TABLE IF EXISTS `0_item_codes`;
933 CREATE TABLE `0_item_codes` (
934 `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
935 `item_code` varchar(20) NOT NULL,
936 `stock_id` varchar(20) NOT NULL,
937 `description` varchar(200) NOT NULL DEFAULT '',
938 `category_id` smallint(6) unsigned NOT NULL,
939 `quantity` double NOT NULL DEFAULT '1',
940 `is_foreign` tinyint(1) NOT NULL DEFAULT '0',
941 `inactive` tinyint(1) NOT NULL DEFAULT '0',
943 UNIQUE KEY `stock_id` (`stock_id`,`item_code`),
944 KEY `item_code` (`item_code`)
945 ) ENGINE=InnoDB AUTO_INCREMENT=9 ;
947 -- Data of table `0_item_codes` --
949 INSERT INTO `0_item_codes` VALUES
950 ('1', '101', '101', 'iPad Air 2 16GB', '1', '1', '0', '0'),
951 ('2', '102', '102', 'iPhone 6 64GB', '1', '1', '0', '0'),
952 ('3', '103', '103', 'iPhone Cover Case', '1', '1', '0', '0'),
953 ('4', '201', '201', 'AP Surf Set', '3', '1', '0', '0'),
954 ('5', '301', '301', 'Support', '4', '1', '0', '0'),
955 ('6', '501', '102', 'iPhone Pack', '1', '1', '0', '0'),
956 ('7', '501', '103', 'iPhone Pack', '1', '1', '0', '0'),
957 ('8', '202', '202', 'Maintenance', '4', '1', '0', '0');
959 -- Structure of table `0_item_tax_type_exemptions` --
961 DROP TABLE IF EXISTS `0_item_tax_type_exemptions`;
963 CREATE TABLE `0_item_tax_type_exemptions` (
964 `item_tax_type_id` int(11) NOT NULL DEFAULT '0',
965 `tax_type_id` int(11) NOT NULL DEFAULT '0',
966 PRIMARY KEY (`item_tax_type_id`,`tax_type_id`)
969 -- Data of table `0_item_tax_type_exemptions` --
971 -- Structure of table `0_item_tax_types` --
973 DROP TABLE IF EXISTS `0_item_tax_types`;
975 CREATE TABLE `0_item_tax_types` (
976 `id` int(11) NOT NULL AUTO_INCREMENT,
977 `name` varchar(60) NOT NULL DEFAULT '',
978 `exempt` tinyint(1) NOT NULL DEFAULT '0',
979 `inactive` tinyint(1) NOT NULL DEFAULT '0',
981 UNIQUE KEY `name` (`name`)
982 ) ENGINE=InnoDB AUTO_INCREMENT=2 ;
984 -- Data of table `0_item_tax_types` --
986 INSERT INTO `0_item_tax_types` VALUES
987 ('1', 'Regular', '0', '0');
989 -- Structure of table `0_item_units` --
991 DROP TABLE IF EXISTS `0_item_units`;
993 CREATE TABLE `0_item_units` (
994 `abbr` varchar(20) NOT NULL,
995 `name` varchar(40) NOT NULL,
996 `decimals` tinyint(2) NOT NULL,
997 `inactive` tinyint(1) NOT NULL DEFAULT '0',
998 PRIMARY KEY (`abbr`),
999 UNIQUE KEY `name` (`name`)
1002 -- Data of table `0_item_units` --
1004 INSERT INTO `0_item_units` VALUES
1005 ('each', 'Each', '0', '0'),
1006 ('hr', 'Hours', '0', '0');
1008 -- Structure of table `0_journal` --
1010 DROP TABLE IF EXISTS `0_journal`;
1012 CREATE TABLE `0_journal` (
1013 `type` smallint(6) NOT NULL DEFAULT '0',
1014 `trans_no` int(11) NOT NULL DEFAULT '0',
1015 `tran_date` date DEFAULT '0000-00-00',
1016 `reference` varchar(60) NOT NULL DEFAULT '',
1017 `source_ref` varchar(60) NOT NULL DEFAULT '',
1018 `event_date` date DEFAULT '0000-00-00',
1019 `doc_date` date NOT NULL DEFAULT '0000-00-00',
1020 `currency` char(3) NOT NULL DEFAULT '',
1021 `amount` double NOT NULL DEFAULT '0',
1022 `rate` double NOT NULL DEFAULT '1',
1023 PRIMARY KEY (`type`,`trans_no`),
1024 KEY `tran_date` (`tran_date`)
1027 -- Data of table `0_journal` --
1029 INSERT INTO `0_journal` VALUES
1030 ('0', '1', '2018-12-31', '001/2012', '', '2018-12-31', '2018-12-31', 'USD', '2163.57', '1');
1032 -- Structure of table `0_loc_stock` --
1034 DROP TABLE IF EXISTS `0_loc_stock`;
1036 CREATE TABLE `0_loc_stock` (
1037 `loc_code` char(5) NOT NULL DEFAULT '',
1038 `stock_id` char(20) NOT NULL DEFAULT '',
1039 `reorder_level` double NOT NULL DEFAULT '0',
1040 PRIMARY KEY (`loc_code`,`stock_id`),
1041 KEY `stock_id` (`stock_id`)
1044 -- Data of table `0_loc_stock` --
1046 INSERT INTO `0_loc_stock` VALUES
1047 ('DEF', '101', '0'),
1048 ('DEF', '102', '0'),
1049 ('DEF', '103', '0'),
1050 ('DEF', '201', '0'),
1051 ('DEF', '202', '0'),
1052 ('DEF', '301', '0');
1054 -- Structure of table `0_locations` --
1056 DROP TABLE IF EXISTS `0_locations`;
1058 CREATE TABLE `0_locations` (
1059 `loc_code` varchar(5) NOT NULL DEFAULT '',
1060 `location_name` varchar(60) NOT NULL DEFAULT '',
1061 `delivery_address` tinytext NOT NULL,
1062 `phone` varchar(30) NOT NULL DEFAULT '',
1063 `phone2` varchar(30) NOT NULL DEFAULT '',
1064 `fax` varchar(30) NOT NULL DEFAULT '',
1065 `email` varchar(100) NOT NULL DEFAULT '',
1066 `contact` varchar(30) NOT NULL DEFAULT '',
1067 `fixed_asset` tinyint(1) NOT NULL DEFAULT '0',
1068 `inactive` tinyint(1) NOT NULL DEFAULT '0',
1069 PRIMARY KEY (`loc_code`)
1072 -- Data of table `0_locations` --
1074 INSERT INTO `0_locations` VALUES
1075 ('DEF', 'Default', 'N/A', '', '', '', '', '', '0', '0');
1077 -- Structure of table `0_payment_terms` --
1079 DROP TABLE IF EXISTS `0_payment_terms`;
1081 CREATE TABLE `0_payment_terms` (
1082 `terms_indicator` int(11) NOT NULL AUTO_INCREMENT,
1083 `terms` char(80) NOT NULL DEFAULT '',
1084 `days_before_due` smallint(6) NOT NULL DEFAULT '0',
1085 `day_in_following_month` smallint(6) NOT NULL DEFAULT '0',
1086 `inactive` tinyint(1) NOT NULL DEFAULT '0',
1087 PRIMARY KEY (`terms_indicator`),
1088 UNIQUE KEY `terms` (`terms`)
1089 ) ENGINE=InnoDB AUTO_INCREMENT=6 ;
1091 -- Data of table `0_payment_terms` --
1093 INSERT INTO `0_payment_terms` VALUES
1094 ('1', 'Due 15th Of the Following Month', '0', '17', '0'),
1095 ('2', 'Due By End Of The Following Month', '0', '30', '0'),
1096 ('3', 'Payment due within 10 days', '10', '0', '0'),
1097 ('4', 'Cash Only', '0', '0', '0'),
1098 ('5', 'Prepaid', '-1', '0', '0');
1100 -- Structure of table `0_prices` --
1102 DROP TABLE IF EXISTS `0_prices`;
1104 CREATE TABLE `0_prices` (
1105 `id` int(11) NOT NULL AUTO_INCREMENT,
1106 `stock_id` varchar(20) NOT NULL DEFAULT '',
1107 `sales_type_id` int(11) NOT NULL DEFAULT '0',
1108 `curr_abrev` char(3) NOT NULL DEFAULT '',
1109 `price` double NOT NULL DEFAULT '0',
1111 UNIQUE KEY `price` (`stock_id`,`sales_type_id`,`curr_abrev`)
1112 ) ENGINE=InnoDB AUTO_INCREMENT=4 ;
1114 -- Data of table `0_prices` --
1116 INSERT INTO `0_prices` VALUES
1117 ('1', '101', '1', 'USD', '300'),
1118 ('2', '102', '1', 'USD', '250'),
1119 ('3', '103', '1', 'USD', '50');
1121 -- Structure of table `0_print_profiles` --
1123 DROP TABLE IF EXISTS `0_print_profiles`;
1125 CREATE TABLE `0_print_profiles` (
1126 `id` smallint(6) unsigned NOT NULL AUTO_INCREMENT,
1127 `profile` varchar(30) NOT NULL,
1128 `report` varchar(5) DEFAULT NULL,
1129 `printer` tinyint(3) unsigned DEFAULT NULL,
1131 UNIQUE KEY `profile` (`profile`,`report`)
1132 ) ENGINE=InnoDB AUTO_INCREMENT=10 ;
1134 -- Data of table `0_print_profiles` --
1136 INSERT INTO `0_print_profiles` VALUES
1137 ('1', 'Out of office', NULL, '0'),
1138 ('2', 'Sales Department', NULL, '0'),
1139 ('3', 'Central', NULL, '2'),
1140 ('4', 'Sales Department', '104', '2'),
1141 ('5', 'Sales Department', '105', '2'),
1142 ('6', 'Sales Department', '107', '2'),
1143 ('7', 'Sales Department', '109', '2'),
1144 ('8', 'Sales Department', '110', '2'),
1145 ('9', 'Sales Department', '201', '2');
1147 -- Structure of table `0_printers` --
1149 DROP TABLE IF EXISTS `0_printers`;
1151 CREATE TABLE `0_printers` (
1152 `id` tinyint(3) unsigned NOT NULL AUTO_INCREMENT,
1153 `name` varchar(20) NOT NULL,
1154 `description` varchar(60) NOT NULL,
1155 `queue` varchar(20) NOT NULL,
1156 `host` varchar(40) NOT NULL,
1157 `port` smallint(11) unsigned NOT NULL,
1158 `timeout` tinyint(3) unsigned NOT NULL,
1160 UNIQUE KEY `name` (`name`)
1161 ) ENGINE=InnoDB AUTO_INCREMENT=4 ;
1163 -- Data of table `0_printers` --
1165 INSERT INTO `0_printers` VALUES
1166 ('1', 'QL500', 'Label printer', 'QL500', 'server', '127', '20'),
1167 ('2', 'Samsung', 'Main network printer', 'scx4521F', 'server', '515', '5'),
1168 ('3', 'Local', 'Local print server at user IP', 'lp', '', '515', '10');
1170 -- Structure of table `0_purch_data` --
1172 DROP TABLE IF EXISTS `0_purch_data`;
1174 CREATE TABLE `0_purch_data` (
1175 `supplier_id` int(11) NOT NULL DEFAULT '0',
1176 `stock_id` char(20) NOT NULL DEFAULT '',
1177 `price` double NOT NULL DEFAULT '0',
1178 `suppliers_uom` char(50) NOT NULL DEFAULT '',
1179 `conversion_factor` double NOT NULL DEFAULT '1',
1180 `supplier_description` char(50) NOT NULL DEFAULT '',
1181 PRIMARY KEY (`supplier_id`,`stock_id`)
1184 -- Data of table `0_purch_data` --
1186 INSERT INTO `0_purch_data` VALUES
1187 ('1', '101', '200', '', '1', 'iPad Air 2 16GB'),
1188 ('1', '102', '150', '', '1', 'iPhone 6 64GB'),
1189 ('1', '103', '10', '', '1', 'iPhone Cover Case');
1191 -- Structure of table `0_purch_order_details` --
1193 DROP TABLE IF EXISTS `0_purch_order_details`;
1195 CREATE TABLE `0_purch_order_details` (
1196 `po_detail_item` int(11) NOT NULL AUTO_INCREMENT,
1197 `order_no` int(11) NOT NULL DEFAULT '0',
1198 `item_code` varchar(20) NOT NULL DEFAULT '',
1199 `description` tinytext,
1200 `delivery_date` date NOT NULL DEFAULT '0000-00-00',
1201 `qty_invoiced` double NOT NULL DEFAULT '0',
1202 `unit_price` double NOT NULL DEFAULT '0',
1203 `act_price` double NOT NULL DEFAULT '0',
1204 `std_cost_unit` double NOT NULL DEFAULT '0',
1205 `quantity_ordered` double NOT NULL DEFAULT '0',
1206 `quantity_received` double NOT NULL DEFAULT '0',
1207 PRIMARY KEY (`po_detail_item`),
1208 KEY `order` (`order_no`,`po_detail_item`),
1209 KEY `itemcode` (`item_code`)
1210 ) ENGINE=InnoDB AUTO_INCREMENT=6 ;
1212 -- Data of table `0_purch_order_details` --
1214 INSERT INTO `0_purch_order_details` VALUES
1215 ('1', '1', '101', 'iPad Air 2 16GB', '2018-05-15', '0', '200', '200', '200', '100', '100'),
1216 ('2', '1', '102', 'iPhone 6 64GB', '2018-05-15', '0', '150', '150', '150', '100', '100'),
1217 ('3', '1', '103', 'iPhone Cover Case', '2018-05-15', '0', '10', '10', '10', '100', '100'),
1218 ('4', '2', '101', 'iPad Air 2 16GB', '2018-05-05', '15', '200', '200', '200', '15', '15'),
1219 ('5', '3', '102', 'iPhone 6 64GB', '2019-01-21', '6', '150', '150', '150', '6', '6');
1221 -- Structure of table `0_purch_orders` --
1223 DROP TABLE IF EXISTS `0_purch_orders`;
1225 CREATE TABLE `0_purch_orders` (
1226 `order_no` int(11) NOT NULL AUTO_INCREMENT,
1227 `supplier_id` int(11) NOT NULL DEFAULT '0',
1228 `comments` tinytext,
1229 `ord_date` date NOT NULL DEFAULT '0000-00-00',
1230 `reference` tinytext NOT NULL,
1231 `supp_reference` tinytext,
1232 `into_stock_location` varchar(5) NOT NULL DEFAULT '',
1233 `delivery_address` tinytext NOT NULL,
1234 `total` double NOT NULL DEFAULT '0',
1235 `prep_amount` double NOT NULL DEFAULT '0',
1236 `alloc` double NOT NULL DEFAULT '0',
1237 `tax_included` tinyint(1) NOT NULL DEFAULT '0',
1238 PRIMARY KEY (`order_no`),
1239 KEY `ord_date` (`ord_date`)
1240 ) ENGINE=InnoDB AUTO_INCREMENT=4 ;
1242 -- Data of table `0_purch_orders` --
1244 INSERT INTO `0_purch_orders` VALUES
1245 ('1', '1', NULL, '2018-05-05', '001/2018', NULL, 'DEF', 'N/A', '37800', '0', '0', '0'),
1246 ('2', '1', NULL, '2018-05-05', 'auto', 'rr4', 'DEF', 'N/A', '3150', '0', '0', '0'),
1247 ('3', '1', NULL, '2019-01-21', 'auto', 'asd5', 'DEF', 'N/A', '945', '0', '0', '0');
1249 -- Structure of table `0_quick_entries` --
1251 DROP TABLE IF EXISTS `0_quick_entries`;
1253 CREATE TABLE `0_quick_entries` (
1254 `id` smallint(6) unsigned NOT NULL AUTO_INCREMENT,
1255 `type` tinyint(1) NOT NULL DEFAULT '0',
1256 `description` varchar(60) NOT NULL,
1257 `usage` varchar(120) DEFAULT NULL,
1258 `base_amount` double NOT NULL DEFAULT '0',
1259 `base_desc` varchar(60) DEFAULT NULL,
1260 `bal_type` tinyint(1) NOT NULL DEFAULT '0',
1262 KEY `description` (`description`)
1263 ) ENGINE=InnoDB AUTO_INCREMENT=4 ;
1265 -- Data of table `0_quick_entries` --
1267 INSERT INTO `0_quick_entries` VALUES
1268 ('1', '1', 'Maintenance', NULL, '0', 'Amount', '0'),
1269 ('2', '4', 'Phone', NULL, '0', 'Amount', '0'),
1270 ('3', '2', 'Cash Sales', 'Retail sales without invoice', '0', 'Amount', '0');
1272 -- Structure of table `0_quick_entry_lines` --
1274 DROP TABLE IF EXISTS `0_quick_entry_lines`;
1276 CREATE TABLE `0_quick_entry_lines` (
1277 `id` smallint(6) unsigned NOT NULL AUTO_INCREMENT,
1278 `qid` smallint(6) unsigned NOT NULL,
1279 `amount` double DEFAULT '0',
1280 `memo` tinytext NOT NULL,
1281 `action` varchar(2) NOT NULL,
1282 `dest_id` varchar(15) NOT NULL DEFAULT '',
1283 `dimension_id` smallint(6) unsigned DEFAULT NULL,
1284 `dimension2_id` smallint(6) unsigned DEFAULT NULL,
1287 ) ENGINE=InnoDB AUTO_INCREMENT=7 ;
1289 -- Data of table `0_quick_entry_lines` --
1291 INSERT INTO `0_quick_entry_lines` VALUES
1292 ('1', '1', '0', '', 't-', '1', '0', '0'),
1293 ('2', '2', '0', '', 't-', '1', '0', '0'),
1294 ('3', '3', '0', '', 't-', '1', '0', '0'),
1295 ('4', '3', '0', '', '=', '4010', '0', '0'),
1296 ('5', '1', '0', '', '=', '5765', '0', '0'),
1297 ('6', '2', '0', '', '=', '5780', '0', '0');
1299 -- Structure of table `0_recurrent_invoices` --
1301 DROP TABLE IF EXISTS `0_recurrent_invoices`;
1303 CREATE TABLE `0_recurrent_invoices` (
1304 `id` smallint(6) unsigned NOT NULL AUTO_INCREMENT,
1305 `description` varchar(60) NOT NULL DEFAULT '',
1306 `order_no` int(11) unsigned NOT NULL,
1307 `debtor_no` int(11) unsigned DEFAULT NULL,
1308 `group_no` smallint(6) unsigned DEFAULT NULL,
1309 `days` int(11) NOT NULL DEFAULT '0',
1310 `monthly` int(11) NOT NULL DEFAULT '0',
1311 `begin` date NOT NULL DEFAULT '0000-00-00',
1312 `end` date NOT NULL DEFAULT '0000-00-00',
1313 `last_sent` date NOT NULL DEFAULT '0000-00-00',
1315 UNIQUE KEY `description` (`description`)
1316 ) ENGINE=InnoDB AUTO_INCREMENT=2 ;
1318 -- Data of table `0_recurrent_invoices` --
1320 INSERT INTO `0_recurrent_invoices` VALUES
1321 ('1', 'Weekly Maintenance', '6', '1', '1', '7', '0', '2018-04-01', '2020-05-07', '2018-04-08');
1323 -- Structure of table `0_reflines` --
1325 DROP TABLE IF EXISTS `0_reflines`;
1327 CREATE TABLE `0_reflines` (
1328 `id` int(11) NOT NULL AUTO_INCREMENT,
1329 `trans_type` int(11) NOT NULL,
1330 `prefix` char(5) NOT NULL DEFAULT '',
1331 `pattern` varchar(35) NOT NULL DEFAULT '1',
1332 `description` varchar(60) NOT NULL DEFAULT '',
1333 `default` tinyint(1) NOT NULL DEFAULT '0',
1334 `inactive` tinyint(1) NOT NULL DEFAULT '0',
1336 UNIQUE KEY `prefix` (`trans_type`,`prefix`)
1337 ) ENGINE=InnoDB AUTO_INCREMENT=23 ;
1339 -- Data of table `0_reflines` --
1341 INSERT INTO `0_reflines` VALUES
1342 ('1', '0', '', '{001}/{YYYY}', '', '1', '0'),
1343 ('2', '1', '', '{001}/{YYYY}', '', '1', '0'),
1344 ('3', '2', '', '{001}/{YYYY}', '', '1', '0'),
1345 ('4', '4', '', '{001}/{YYYY}', '', '1', '0'),
1346 ('5', '10', '', '{001}/{YYYY}', '', '1', '0'),
1347 ('6', '11', '', '{001}/{YYYY}', '', '1', '0'),
1348 ('7', '12', '', '{001}/{YYYY}', '', '1', '0'),
1349 ('8', '13', '', '{001}/{YYYY}', '', '1', '0'),
1350 ('9', '16', '', '{001}/{YYYY}', '', '1', '0'),
1351 ('10', '17', '', '{001}/{YYYY}', '', '1', '0'),
1352 ('11', '18', '', '{001}/{YYYY}', '', '1', '0'),
1353 ('12', '20', '', '{001}/{YYYY}', '', '1', '0'),
1354 ('13', '21', '', '{001}/{YYYY}', '', '1', '0'),
1355 ('14', '22', '', '{001}/{YYYY}', '', '1', '0'),
1356 ('15', '25', '', '{001}/{YYYY}', '', '1', '0'),
1357 ('16', '26', '', '{001}/{YYYY}', '', '1', '0'),
1358 ('17', '28', '', '{001}/{YYYY}', '', '1', '0'),
1359 ('18', '29', '', '{001}/{YYYY}', '', '1', '0'),
1360 ('19', '30', '', '{001}/{YYYY}', '', '1', '0'),
1361 ('20', '32', '', '{001}/{YYYY}', '', '1', '0'),
1362 ('21', '35', '', '{001}/{YYYY}', '', '1', '0'),
1363 ('22', '40', '', '{001}/{YYYY}', '', '1', '0');
1365 -- Structure of table `0_refs` --
1367 DROP TABLE IF EXISTS `0_refs`;
1369 CREATE TABLE `0_refs` (
1370 `id` int(11) NOT NULL DEFAULT '0',
1371 `type` int(11) NOT NULL DEFAULT '0',
1372 `reference` varchar(100) NOT NULL DEFAULT '',
1373 PRIMARY KEY (`id`,`type`),
1374 KEY `Type_and_Reference` (`type`,`reference`)
1377 -- Data of table `0_refs` --
1379 INSERT INTO `0_refs` VALUES
1380 ('1', '1', '001/2018'),
1381 ('1', '10', '001/2018'),
1382 ('5', '10', '001/2019'),
1383 ('2', '10', '002/2018'),
1384 ('3', '10', '003/2018'),
1385 ('4', '10', '004/2018'),
1386 ('1', '12', '001/2018'),
1387 ('4', '12', '001/2019'),
1388 ('2', '12', '002/2018'),
1389 ('3', '12', '003/2018'),
1390 ('1', '18', '001/2018'),
1391 ('1', '20', '001/2018'),
1392 ('2', '20', '001/2019'),
1393 ('1', '25', '001/2018'),
1394 ('1', '26', '001/2018'),
1395 ('2', '26', '002/2018'),
1396 ('3', '26', '003/2018'),
1397 ('3', '30', '001/2018'),
1398 ('4', '30', '002/2018'),
1399 ('6', '30', '003/2018'),
1400 ('1', '40', '001/2018');
1402 -- Structure of table `0_sales_order_details` --
1404 DROP TABLE IF EXISTS `0_sales_order_details`;
1406 CREATE TABLE `0_sales_order_details` (
1407 `id` int(11) NOT NULL AUTO_INCREMENT,
1408 `order_no` int(11) NOT NULL DEFAULT '0',
1409 `trans_type` smallint(6) NOT NULL DEFAULT '30',
1410 `stk_code` varchar(20) NOT NULL DEFAULT '',
1411 `description` tinytext,
1412 `qty_sent` double NOT NULL DEFAULT '0',
1413 `unit_price` double NOT NULL DEFAULT '0',
1414 `quantity` double NOT NULL DEFAULT '0',
1415 `invoiced` double NOT NULL DEFAULT '0',
1416 `discount_percent` double NOT NULL DEFAULT '0',
1418 KEY `sorder` (`trans_type`,`order_no`),
1419 KEY `stkcode` (`stk_code`)
1420 ) ENGINE=InnoDB AUTO_INCREMENT=12 ;
1422 -- Data of table `0_sales_order_details` --
1424 INSERT INTO `0_sales_order_details` VALUES
1425 ('1', '1', '30', '101', 'iPad Air 2 16GB', '20', '300', '20', '0', '0'),
1426 ('2', '1', '30', '301', 'Support', '3', '80', '3', '0', '0'),
1427 ('3', '2', '30', '101', 'iPad Air 2 16GB', '1', '300', '1', '0', '0'),
1428 ('4', '3', '30', '102', 'iPhone 6 64GB', '0', '250', '1', '0', '0'),
1429 ('5', '3', '30', '103', 'iPhone Cover Case', '0', '50', '1', '0', '0'),
1430 ('6', '4', '30', '101', 'iPad Air 2 16GB', '0', '267.14', '1', '0', '0'),
1431 ('7', '5', '30', '102', 'iPhone 6 64GB', '1', '222.62', '1', '0', '0'),
1432 ('8', '5', '30', '103', 'iPhone Cover Case', '1', '44.52', '1', '0', '0'),
1433 ('9', '6', '30', '202', 'Maintenance', '0', '90', '5', '0', '0'),
1434 ('10', '7', '30', '202', 'Maintenance', '5', '0', '5', '0', '0'),
1435 ('11', '8', '30', '102', 'iPhone 6 64GB', '5', '250', '5', '0', '0');
1437 -- Structure of table `0_sales_orders` --
1439 DROP TABLE IF EXISTS `0_sales_orders`;
1441 CREATE TABLE `0_sales_orders` (
1442 `order_no` int(11) NOT NULL,
1443 `trans_type` smallint(6) NOT NULL DEFAULT '30',
1444 `version` tinyint(1) unsigned NOT NULL DEFAULT '0',
1445 `type` tinyint(1) NOT NULL DEFAULT '0',
1446 `debtor_no` int(11) NOT NULL DEFAULT '0',
1447 `branch_code` int(11) NOT NULL DEFAULT '0',
1448 `reference` varchar(100) NOT NULL DEFAULT '',
1449 `customer_ref` tinytext NOT NULL,
1450 `comments` tinytext,
1451 `ord_date` date NOT NULL DEFAULT '0000-00-00',
1452 `order_type` int(11) NOT NULL DEFAULT '0',
1453 `ship_via` varchar(20) NOT NULL DEFAULT '',
1454 `delivery_address` tinytext NOT NULL,
1455 `contact_phone` varchar(30) DEFAULT NULL,
1456 `contact_email` varchar(100) DEFAULT NULL,
1457 `deliver_to` tinytext NOT NULL,
1458 `freight_cost` double NOT NULL DEFAULT '0',
1459 `from_stk_loc` varchar(5) NOT NULL DEFAULT '',
1460 `delivery_date` date NOT NULL DEFAULT '0000-00-00',
1461 `payment_terms` int(11) DEFAULT NULL,
1462 `total` double NOT NULL DEFAULT '0',
1463 `prep_amount` double NOT NULL DEFAULT '0',
1464 `alloc` double NOT NULL DEFAULT '0',
1465 PRIMARY KEY (`trans_type`,`order_no`)
1468 -- Data of table `0_sales_orders` --
1470 INSERT INTO `0_sales_orders` VALUES
1471 ('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'),
1472 ('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'),
1473 ('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'),
1474 ('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'),
1475 ('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'),
1476 ('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'),
1477 ('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'),
1478 ('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');
1480 -- Structure of table `0_sales_pos` --
1482 DROP TABLE IF EXISTS `0_sales_pos`;
1484 CREATE TABLE `0_sales_pos` (
1485 `id` smallint(6) unsigned NOT NULL AUTO_INCREMENT,
1486 `pos_name` varchar(30) NOT NULL,
1487 `cash_sale` tinyint(1) NOT NULL,
1488 `credit_sale` tinyint(1) NOT NULL,
1489 `pos_location` varchar(5) NOT NULL,
1490 `pos_account` smallint(6) unsigned NOT NULL,
1491 `inactive` tinyint(1) NOT NULL DEFAULT '0',
1493 UNIQUE KEY `pos_name` (`pos_name`)
1494 ) ENGINE=InnoDB AUTO_INCREMENT=2 ;
1496 -- Data of table `0_sales_pos` --
1498 INSERT INTO `0_sales_pos` VALUES
1499 ('1', 'Default', '1', '1', 'DEF', '2', '0');
1501 -- Structure of table `0_sales_types` --
1503 DROP TABLE IF EXISTS `0_sales_types`;
1505 CREATE TABLE `0_sales_types` (
1506 `id` int(11) NOT NULL AUTO_INCREMENT,
1507 `sales_type` char(50) NOT NULL DEFAULT '',
1508 `tax_included` int(1) NOT NULL DEFAULT '0',
1509 `factor` double NOT NULL DEFAULT '1',
1510 `inactive` tinyint(1) NOT NULL DEFAULT '0',
1512 UNIQUE KEY `sales_type` (`sales_type`)
1513 ) ENGINE=InnoDB AUTO_INCREMENT=3 ;
1515 -- Data of table `0_sales_types` --
1517 INSERT INTO `0_sales_types` VALUES
1518 ('1', 'Retail', '1', '1', '0'),
1519 ('2', 'Wholesale', '0', '0.7', '0');
1521 -- Structure of table `0_salesman` --
1523 DROP TABLE IF EXISTS `0_salesman`;
1525 CREATE TABLE `0_salesman` (
1526 `salesman_code` int(11) NOT NULL AUTO_INCREMENT,
1527 `salesman_name` char(60) NOT NULL DEFAULT '',
1528 `salesman_phone` char(30) NOT NULL DEFAULT '',
1529 `salesman_fax` char(30) NOT NULL DEFAULT '',
1530 `salesman_email` varchar(100) NOT NULL DEFAULT '',
1531 `provision` double NOT NULL DEFAULT '0',
1532 `break_pt` double NOT NULL DEFAULT '0',
1533 `provision2` double NOT NULL DEFAULT '0',
1534 `inactive` tinyint(1) NOT NULL DEFAULT '0',
1535 PRIMARY KEY (`salesman_code`),
1536 UNIQUE KEY `salesman_name` (`salesman_name`)
1537 ) ENGINE=InnoDB AUTO_INCREMENT=2 ;
1539 -- Data of table `0_salesman` --
1541 INSERT INTO `0_salesman` VALUES
1542 ('1', 'Sales Person', '', '', '', '5', '1000', '4', '0');
1544 -- Structure of table `0_security_roles` --
1546 DROP TABLE IF EXISTS `0_security_roles`;
1548 CREATE TABLE `0_security_roles` (
1549 `id` int(11) NOT NULL AUTO_INCREMENT,
1550 `role` varchar(30) NOT NULL,
1551 `description` varchar(50) DEFAULT NULL,
1554 `inactive` tinyint(1) NOT NULL DEFAULT '0',
1556 UNIQUE KEY `role` (`role`)
1557 ) ENGINE=InnoDB AUTO_INCREMENT=11 ;
1559 -- Data of table `0_security_roles` --
1561 INSERT INTO `0_security_roles` VALUES
1562 ('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'),
1563 ('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'),
1564 ('3', 'Salesman', 'Salesman', '768;3072;5632;8192;15872', '773;774;3073;3075;3081;5633;8194;15873;775', '0'),
1565 ('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'),
1566 ('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'),
1567 ('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'),
1568 ('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'),
1569 ('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'),
1570 ('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'),
1571 ('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');
1573 -- Structure of table `0_shippers` --
1575 DROP TABLE IF EXISTS `0_shippers`;
1577 CREATE TABLE `0_shippers` (
1578 `shipper_id` int(11) NOT NULL AUTO_INCREMENT,
1579 `shipper_name` varchar(60) NOT NULL DEFAULT '',
1580 `phone` varchar(30) NOT NULL DEFAULT '',
1581 `phone2` varchar(30) NOT NULL DEFAULT '',
1582 `contact` tinytext NOT NULL,
1583 `address` tinytext NOT NULL,
1584 `inactive` tinyint(1) NOT NULL DEFAULT '0',
1585 PRIMARY KEY (`shipper_id`),
1586 UNIQUE KEY `name` (`shipper_name`)
1587 ) ENGINE=InnoDB AUTO_INCREMENT=2 ;
1589 -- Data of table `0_shippers` --
1591 INSERT INTO `0_shippers` VALUES
1592 ('1', 'Default', '', '', '', '', '0');
1594 -- Structure of table `0_stock_category` --
1596 DROP TABLE IF EXISTS `0_stock_category`;
1598 CREATE TABLE `0_stock_category` (
1599 `category_id` int(11) NOT NULL AUTO_INCREMENT,
1600 `description` varchar(60) NOT NULL DEFAULT '',
1601 `dflt_tax_type` int(11) NOT NULL DEFAULT '1',
1602 `dflt_units` varchar(20) NOT NULL DEFAULT 'each',
1603 `dflt_mb_flag` char(1) NOT NULL DEFAULT 'B',
1604 `dflt_sales_act` varchar(15) NOT NULL DEFAULT '',
1605 `dflt_cogs_act` varchar(15) NOT NULL DEFAULT '',
1606 `dflt_inventory_act` varchar(15) NOT NULL DEFAULT '',
1607 `dflt_adjustment_act` varchar(15) NOT NULL DEFAULT '',
1608 `dflt_wip_act` varchar(15) NOT NULL DEFAULT '',
1609 `dflt_dim1` int(11) DEFAULT NULL,
1610 `dflt_dim2` int(11) DEFAULT NULL,
1611 `inactive` tinyint(1) NOT NULL DEFAULT '0',
1612 `dflt_no_sale` tinyint(1) NOT NULL DEFAULT '0',
1613 `dflt_no_purchase` tinyint(1) NOT NULL DEFAULT '0',
1614 `vat_category` tinyint(1) NOT NULL DEFAULT '0',
1615 PRIMARY KEY (`category_id`),
1616 UNIQUE KEY `description` (`description`)
1617 ) ENGINE=InnoDB AUTO_INCREMENT=5 ;
1619 -- Data of table `0_stock_category` --
1621 INSERT INTO `0_stock_category` VALUES
1622 ('1', 'Components', '1', 'each', 'B', '4010', '5010', '1510', '5040', '1530', '0', '0', '0', '0', '0', '0'),
1623 ('2', 'Charges', '1', 'each', 'D', '4010', '5010', '1510', '5040', '1530', '0', '0', '0', '0', '0', '0'),
1624 ('3', 'Systems', '1', 'each', 'M', '4010', '5010', '1510', '5040', '1530', '0', '0', '0', '0', '0', '0'),
1625 ('4', 'Services', '1', 'hr', 'D', '4010', '5010', '1510', '5040', '1530', '0', '0', '0', '0', '0', '0'),
1626 ('5', 'Shipping', '1', 'each', 'T', '4430', '5010', '', '', '', '0', '0', '0', '1', '0', '0');
1628 -- Structure of table `0_stock_fa_class` --
1630 DROP TABLE IF EXISTS `0_stock_fa_class`;
1632 CREATE TABLE `0_stock_fa_class` (
1633 `fa_class_id` varchar(20) NOT NULL DEFAULT '',
1634 `parent_id` varchar(20) NOT NULL DEFAULT '',
1635 `description` varchar(200) NOT NULL DEFAULT '',
1636 `long_description` tinytext NOT NULL,
1637 `depreciation_rate` double NOT NULL DEFAULT '0',
1638 `inactive` tinyint(1) NOT NULL DEFAULT '0',
1639 PRIMARY KEY (`fa_class_id`)
1642 -- Data of table `0_stock_fa_class` --
1644 -- Structure of table `0_stock_master` --
1646 DROP TABLE IF EXISTS `0_stock_master`;
1648 CREATE TABLE `0_stock_master` (
1649 `stock_id` varchar(20) NOT NULL DEFAULT '',
1650 `category_id` int(11) NOT NULL DEFAULT '0',
1651 `tax_type_id` int(11) NOT NULL DEFAULT '0',
1652 `description` varchar(200) NOT NULL DEFAULT '',
1653 `long_description` tinytext NOT NULL,
1654 `units` varchar(20) NOT NULL DEFAULT 'each',
1655 `mb_flag` char(1) NOT NULL DEFAULT 'B',
1656 `sales_account` varchar(15) NOT NULL DEFAULT '',
1657 `cogs_account` varchar(15) NOT NULL DEFAULT '',
1658 `inventory_account` varchar(15) NOT NULL DEFAULT '',
1659 `adjustment_account` varchar(15) NOT NULL DEFAULT '',
1660 `wip_account` varchar(15) NOT NULL DEFAULT '',
1661 `dimension_id` int(11) DEFAULT NULL,
1662 `dimension2_id` int(11) DEFAULT NULL,
1663 `purchase_cost` double NOT NULL DEFAULT '0',
1664 `material_cost` double NOT NULL DEFAULT '0',
1665 `labour_cost` double NOT NULL DEFAULT '0',
1666 `overhead_cost` double NOT NULL DEFAULT '0',
1667 `inactive` tinyint(1) NOT NULL DEFAULT '0',
1668 `no_sale` tinyint(1) NOT NULL DEFAULT '0',
1669 `no_purchase` tinyint(1) NOT NULL DEFAULT '0',
1670 `editable` tinyint(1) NOT NULL DEFAULT '0',
1671 `depreciation_method` char(1) NOT NULL DEFAULT 'S',
1672 `depreciation_rate` double NOT NULL DEFAULT '0',
1673 `depreciation_factor` double NOT NULL DEFAULT '1',
1674 `depreciation_start` date NOT NULL DEFAULT '0000-00-00',
1675 `depreciation_date` date NOT NULL DEFAULT '0000-00-00',
1676 `fa_class_id` varchar(20) NOT NULL DEFAULT '',
1677 `vat_category` tinyint(1) NOT NULL DEFAULT '0',
1678 `shipper_id` int(11) NOT NULL DEFAULT '0',
1679 PRIMARY KEY (`stock_id`)
1682 -- Data of table `0_stock_master` --
1684 INSERT INTO `0_stock_master` VALUES
1685 ('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'),
1686 ('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'),
1687 ('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'),
1688 ('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'),
1689 ('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'),
1690 ('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'),
1691 ('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');
1693 -- Structure of table `0_stock_moves` --
1695 DROP TABLE IF EXISTS `0_stock_moves`;
1697 CREATE TABLE `0_stock_moves` (
1698 `trans_id` int(11) NOT NULL AUTO_INCREMENT,
1699 `trans_no` int(11) NOT NULL DEFAULT '0',
1700 `stock_id` char(20) NOT NULL DEFAULT '',
1701 `type` smallint(6) NOT NULL DEFAULT '0',
1702 `loc_code` char(5) NOT NULL DEFAULT '',
1703 `tran_date` date NOT NULL DEFAULT '0000-00-00',
1704 `price` double NOT NULL DEFAULT '0',
1705 `reference` char(40) NOT NULL DEFAULT '',
1706 `qty` double NOT NULL DEFAULT '1',
1707 `unit_cost` double NOT NULL DEFAULT '0',
1708 PRIMARY KEY (`trans_id`),
1709 KEY `type` (`type`,`trans_no`),
1710 KEY `Move` (`stock_id`,`loc_code`,`tran_date`)
1711 ) ENGINE=InnoDB AUTO_INCREMENT=18 ;
1713 -- Data of table `0_stock_moves` --
1715 INSERT INTO `0_stock_moves` VALUES
1716 ('1', '1', '101', '25', 'DEF', '2018-05-05', '200', '', '100', '200'),
1717 ('2', '1', '102', '25', 'DEF', '2018-05-05', '150', '', '100', '150'),
1718 ('3', '1', '103', '25', 'DEF', '2018-05-05', '10', '', '100', '10'),
1719 ('4', '1', '101', '13', 'DEF', '2018-05-10', '300', 'auto', '-20', '200'),
1720 ('5', '1', '301', '13', 'DEF', '2018-05-10', '80', 'auto', '-3', '0'),
1721 ('6', '1', '101', '29', 'DEF', '2018-05-05', '200', '001/2018', '-2', '200'),
1722 ('7', '1', '102', '29', 'DEF', '2018-05-05', '150', '001/2018', '-2', '150'),
1723 ('8', '1', '103', '29', 'DEF', '2018-05-05', '10', '001/2018', '-2', '10'),
1724 ('9', '1', '301', '29', 'DEF', '2018-05-05', '0', '001/2018', '-2', '0'),
1725 ('10', '1', '201', '26', 'DEF', '2018-05-05', '0', '001/2018', '2', '360'),
1726 ('11', '2', '101', '25', 'DEF', '2018-05-05', '200', '', '15', '200'),
1727 ('12', '2', '101', '13', 'DEF', '2018-05-07', '300', 'auto', '-1', '200'),
1728 ('13', '3', '102', '13', 'DEF', '2018-05-07', '222.62', 'auto', '-1', '150'),
1729 ('14', '3', '103', '13', 'DEF', '2018-05-07', '44.52', 'auto', '-1', '10'),
1730 ('15', '4', '202', '13', 'DEF', '2018-05-07', '0', 'auto', '-5', '0'),
1731 ('16', '5', '102', '13', 'DEF', '2019-01-21', '250', 'auto', '-5', '150'),
1732 ('17', '3', '102', '25', 'DEF', '2019-01-21', '150', '', '6', '150');
1734 -- Structure of table `0_supp_allocations` --
1736 DROP TABLE IF EXISTS `0_supp_allocations`;
1738 CREATE TABLE `0_supp_allocations` (
1739 `id` int(11) NOT NULL AUTO_INCREMENT,
1740 `person_id` int(11) DEFAULT NULL,
1741 `amt` double unsigned DEFAULT NULL,
1742 `date_alloc` date NOT NULL DEFAULT '0000-00-00',
1743 `trans_no_from` int(11) DEFAULT NULL,
1744 `trans_type_from` int(11) DEFAULT NULL,
1745 `trans_no_to` int(11) DEFAULT NULL,
1746 `trans_type_to` int(11) DEFAULT NULL,
1748 UNIQUE KEY `trans_type_from` (`person_id`,`trans_type_from`,`trans_no_from`,`trans_type_to`,`trans_no_to`),
1749 KEY `From` (`trans_type_from`,`trans_no_from`),
1750 KEY `To` (`trans_type_to`,`trans_no_to`)
1753 -- Data of table `0_supp_allocations` --
1755 -- Structure of table `0_supp_invoice_items` --
1757 DROP TABLE IF EXISTS `0_supp_invoice_items`;
1759 CREATE TABLE `0_supp_invoice_items` (
1760 `id` int(11) NOT NULL AUTO_INCREMENT,
1761 `supp_trans_no` int(11) DEFAULT NULL,
1762 `supp_trans_type` int(11) DEFAULT NULL,
1763 `gl_code` varchar(15) NOT NULL DEFAULT '',
1764 `grn_item_id` int(11) DEFAULT NULL,
1765 `po_detail_item_id` int(11) DEFAULT NULL,
1766 `stock_id` varchar(20) NOT NULL DEFAULT '',
1767 `description` tinytext,
1768 `quantity` double NOT NULL DEFAULT '0',
1769 `unit_price` double NOT NULL DEFAULT '0',
1770 `unit_tax` double NOT NULL DEFAULT '0',
1772 `dimension_id` int(11) NOT NULL DEFAULT '0',
1773 `dimension2_id` int(11) NOT NULL DEFAULT '0',
1775 KEY `Transaction` (`supp_trans_type`,`supp_trans_no`,`stock_id`)
1776 ) ENGINE=InnoDB AUTO_INCREMENT=3 ;
1778 -- Data of table `0_supp_invoice_items` --
1780 INSERT INTO `0_supp_invoice_items` VALUES
1781 ('1', '1', '20', '0', '4', '4', '101', 'iPad Air 2 16GB', '15', '200', '10', NULL, '0', '0'),
1782 ('2', '2', '20', '0', '5', '5', '102', 'iPhone 6 64GB', '6', '150', '7.5', NULL, '0', '0');
1784 -- Structure of table `0_supp_trans` --
1786 DROP TABLE IF EXISTS `0_supp_trans`;
1788 CREATE TABLE `0_supp_trans` (
1789 `trans_no` int(11) unsigned NOT NULL DEFAULT '0',
1790 `type` smallint(6) unsigned NOT NULL DEFAULT '0',
1791 `supplier_id` int(11) unsigned NOT NULL,
1792 `reference` tinytext NOT NULL,
1793 `supp_reference` varchar(60) NOT NULL DEFAULT '',
1794 `tran_date` date NOT NULL DEFAULT '0000-00-00',
1795 `due_date` date NOT NULL DEFAULT '0000-00-00',
1796 `ov_amount` double NOT NULL DEFAULT '0',
1797 `ov_discount` double NOT NULL DEFAULT '0',
1798 `ov_gst` double NOT NULL DEFAULT '0',
1799 `rate` double NOT NULL DEFAULT '1',
1800 `alloc` double NOT NULL DEFAULT '0',
1801 `tax_included` tinyint(1) NOT NULL DEFAULT '0',
1802 PRIMARY KEY (`type`,`trans_no`,`supplier_id`),
1803 KEY `supplier_id` (`supplier_id`),
1804 KEY `tran_date` (`tran_date`)
1807 -- Data of table `0_supp_trans` --
1809 INSERT INTO `0_supp_trans` VALUES
1810 ('1', '20', '1', '001/2018', 'rr4', '2018-05-05', '2018-05-15', '3000', '0', '150', '1', '0', '0'),
1811 ('2', '20', '1', '001/2019', 'asd5', '2019-01-21', '2019-01-31', '900', '0', '45', '1', '0', '0');
1813 -- Structure of table `0_suppliers` --
1815 DROP TABLE IF EXISTS `0_suppliers`;
1817 CREATE TABLE `0_suppliers` (
1818 `supplier_id` int(11) NOT NULL AUTO_INCREMENT,
1819 `supp_name` varchar(60) NOT NULL DEFAULT '',
1820 `supp_ref` varchar(30) NOT NULL DEFAULT '',
1821 `address` tinytext NOT NULL,
1822 `supp_address` tinytext NOT NULL,
1823 `gst_no` varchar(25) NOT NULL DEFAULT '',
1824 `contact` varchar(60) NOT NULL DEFAULT '',
1825 `supp_account_no` varchar(40) NOT NULL DEFAULT '',
1826 `website` varchar(100) NOT NULL DEFAULT '',
1827 `bank_account` varchar(60) NOT NULL DEFAULT '',
1828 `curr_code` char(3) DEFAULT NULL,
1829 `payment_terms` int(11) DEFAULT NULL,
1830 `tax_included` tinyint(1) NOT NULL DEFAULT '0',
1831 `dimension_id` int(11) DEFAULT '0',
1832 `dimension2_id` int(11) DEFAULT '0',
1833 `tax_group_id` int(11) DEFAULT NULL,
1834 `credit_limit` double NOT NULL DEFAULT '0',
1835 `purchase_account` varchar(15) NOT NULL DEFAULT '',
1836 `payable_account` varchar(15) NOT NULL DEFAULT '',
1837 `payment_discount_account` varchar(15) NOT NULL DEFAULT '',
1838 `notes` tinytext NOT NULL,
1839 `inactive` tinyint(1) NOT NULL DEFAULT '0',
1840 PRIMARY KEY (`supplier_id`),
1841 KEY `supp_ref` (`supp_ref`)
1842 ) ENGINE=InnoDB AUTO_INCREMENT=3 ;
1844 -- Data of table `0_suppliers` --
1846 INSERT INTO `0_suppliers` VALUES
1847 ('1', 'Dino Saurius Inc.', 'Dino Saurius', 'N/A', '', '987654321', '', '', '', '', 'USD', '3', '0', '0', '0', '1', '0', '', '2100', '5060', '', '0'),
1848 ('2', 'Beefeater Ltd.', 'Beefeater', 'N/A', '', '67565590', '', '', '', '', 'GBP', '4', '0', '0', '0', '1', '0', '', '2100', '5060', '', '0');
1850 -- Structure of table `0_sys_prefs` --
1852 DROP TABLE IF EXISTS `0_sys_prefs`;
1854 CREATE TABLE `0_sys_prefs` (
1855 `name` varchar(35) NOT NULL DEFAULT '',
1856 `category` varchar(30) DEFAULT NULL,
1857 `type` varchar(20) NOT NULL DEFAULT '',
1858 `length` smallint(6) DEFAULT NULL,
1859 `value` text NOT NULL,
1860 PRIMARY KEY (`name`),
1861 KEY `category` (`category`)
1864 -- Data of table `0_sys_prefs` --
1866 INSERT INTO `0_sys_prefs` VALUES
1867 ('coy_name', 'setup.company', 'varchar', 60, 'Company name'),
1868 ('gst_no', 'setup.company', 'varchar', 25, ''),
1869 ('coy_no', 'setup.company', 'varchar', 25, ''),
1870 ('tax_prd', 'setup.company', 'int', 11, '1'),
1871 ('tax_last', 'setup.company', 'int', 11, '1'),
1872 ('postal_address', 'setup.company', 'tinytext', 0, 'N/A'),
1873 ('phone', 'setup.company', 'varchar', 30, ''),
1874 ('fax', 'setup.company', 'varchar', 30, ''),
1875 ('email', 'setup.company', 'varchar', 100, ''),
1876 ('coy_logo', 'setup.company', 'varchar', 100, ''),
1877 ('domicile', 'setup.company', 'varchar', 55, ''),
1878 ('curr_default', 'setup.company', 'char', 3, 'USD'),
1879 ('use_dimension', 'setup.company', 'tinyint', 1, '1'),
1880 ('f_year', 'setup.company', 'int', 11, '2'),
1881 ('shortname_name_in_list','setup.company', 'tinyint', 1, '0'),
1882 ('no_item_list', 'setup.company', 'tinyint', 1, '0'),
1883 ('no_customer_list', 'setup.company', 'tinyint', 1, '0'),
1884 ('no_supplier_list', 'setup.company', 'tinyint', 1, '0'),
1885 ('base_sales', 'setup.company', 'int', 11, '1'),
1886 ('time_zone', 'setup.company', 'tinyint', 1, '0'),
1887 ('add_pct', 'setup.company', 'int', 5, '-1'),
1888 ('round_to', 'setup.company', 'int', 5, '1'),
1889 ('login_tout', 'setup.company', 'smallint', 6, '600'),
1890 ('past_due_days', 'glsetup.general', 'int', 11, '30'),
1891 ('profit_loss_year_act', 'glsetup.general', 'varchar', 15, '9990'),
1892 ('retained_earnings_act', 'glsetup.general', 'varchar', 15, '3590'),
1893 ('bank_charge_act', 'glsetup.general', 'varchar', 15, '5690'),
1894 ('exchange_diff_act', 'glsetup.general', 'varchar', 15, '4450'),
1895 ('tax_algorithm', 'glsetup.customer', 'tinyint', 1, '1'),
1896 ('default_credit_limit', 'glsetup.customer', 'int', 11, '1000'),
1897 ('accumulate_shipping', 'glsetup.customer', 'tinyint', 1, '0'),
1898 ('legal_text', 'glsetup.customer', 'tinytext', 0, ''),
1899 ('freight_act', 'glsetup.customer', 'varchar', 15, '4430'),
1900 ('debtors_act', 'glsetup.sales', 'varchar', 15, '1200'),
1901 ('default_sales_act', 'glsetup.sales', 'varchar', 15, '4010'),
1902 ('default_sales_discount_act', 'glsetup.sales', 'varchar', 15, '4510'),
1903 ('default_prompt_payment_act', 'glsetup.sales', 'varchar', 15, '4500'),
1904 ('default_delivery_required', 'glsetup.sales', 'smallint', 6, '1'),
1905 ('default_receival_required', 'glsetup.purchase', 'smallint', 6, '10'),
1906 ('default_quote_valid_days', 'glsetup.sales', 'smallint', 6, '30'),
1907 ('default_dim_required', 'glsetup.dims', 'int', 11, '20'),
1908 ('pyt_discount_act', 'glsetup.purchase', 'varchar', 15, '5060'),
1909 ('creditors_act', 'glsetup.purchase', 'varchar', 15, '2100'),
1910 ('po_over_receive', 'glsetup.purchase', 'int', 11, '10'),
1911 ('po_over_charge', 'glsetup.purchase', 'int', 11, '10'),
1912 ('allow_negative_stock', 'glsetup.inventory', 'tinyint', 1, '0'),
1913 ('default_inventory_act', 'glsetup.items', 'varchar', 15, '1510'),
1914 ('default_cogs_act', 'glsetup.items', 'varchar', 15, '5010'),
1915 ('default_adj_act', 'glsetup.items', 'varchar', 15, '5040'),
1916 ('default_inv_sales_act', 'glsetup.items', 'varchar', 15, '4010'),
1917 ('default_wip_act', 'glsetup.items', 'varchar', 15, '1530'),
1918 ('default_workorder_required', 'glsetup.manuf', 'int', 11, '20'),
1919 ('version_id', 'system', 'varchar', 11, '2.5.0'),
1920 ('auto_curr_reval', 'setup.company', 'smallint', 6, '1'),
1921 ('grn_clearing_act', 'glsetup.purchase', 'varchar', 15, '1550'),
1922 ('bcc_email', 'setup.company', 'varchar', 100, ''),
1923 ('deferred_income_act', 'glsetup.sales', 'varchar', '15', '2105'),
1924 ('gl_closing_date','setup.closing_date', 'date', 8, ''),
1925 ('alternative_tax_include_on_docs','setup.company', 'tinyint', 1, '0'),
1926 ('no_zero_lines_amount','glsetup.sales', 'tinyint', 1, '1'),
1927 ('show_po_item_codes','glsetup.purchase', 'tinyint', 1, '0'),
1928 ('accounts_alpha','glsetup.general', 'tinyint', 1, '0'),
1929 ('loc_notification','glsetup.inventory', 'tinyint', 1, '0'),
1930 ('print_invoice_no','glsetup.sales', 'tinyint', 1, '0'),
1931 ('allow_negative_prices','glsetup.inventory', 'tinyint', 1, '1'),
1932 ('print_item_images_on_quote','glsetup.inventory', 'tinyint', 1, '0'),
1933 ('suppress_tax_rates','setup.company', 'tinyint', 1, '0'),
1934 ('company_logo_report','setup.company', 'tinyint', 1, '0'),
1935 ('barcodes_on_stock','setup.company', 'tinyint', 1, '0'),
1936 ('print_dialog_direct','setup.company', 'tinyint', 1, '0'),
1937 ('ref_no_auto_increase','setup.company', 'tinyint', 1, '0'),
1938 ('default_loss_on_asset_disposal_act', 'glsetup.items', 'varchar', '15', '5660'),
1939 ('depreciation_period', 'glsetup.company', 'tinyint', '1', '1'),
1940 ('use_manufacturing','setup.company', 'tinyint', 1, '1'),
1941 ('use_fixed_assets','setup.company', 'tinyint', 1, '1');
1943 -- Structure of table `0_tag_associations` --
1945 DROP TABLE IF EXISTS `0_tag_associations`;
1947 CREATE TABLE `0_tag_associations` (
1948 `record_id` varchar(15) NOT NULL,
1949 `tag_id` int(11) NOT NULL,
1950 PRIMARY KEY (`record_id`,`tag_id`)
1953 -- Data of table `0_tag_associations` --
1955 -- Structure of table `0_tags` --
1957 DROP TABLE IF EXISTS `0_tags`;
1959 CREATE TABLE `0_tags` (
1960 `id` int(11) NOT NULL AUTO_INCREMENT,
1961 `type` smallint(6) NOT NULL,
1962 `name` varchar(30) NOT NULL,
1963 `description` varchar(60) DEFAULT NULL,
1964 `inactive` tinyint(1) NOT NULL DEFAULT '0',
1966 UNIQUE KEY `type` (`type`,`name`)
1969 -- Data of table `0_tags` --
1971 -- Structure of table `0_tax_group_items` --
1973 DROP TABLE IF EXISTS `0_tax_group_items`;
1975 CREATE TABLE `0_tax_group_items` (
1976 `tax_group_id` int(11) NOT NULL DEFAULT '0',
1977 `tax_type_id` int(11) NOT NULL DEFAULT '0',
1978 PRIMARY KEY (`tax_group_id`,`tax_type_id`)
1981 -- Data of table `0_tax_group_items` --
1983 INSERT INTO `0_tax_group_items` VALUES
1986 -- Structure of table `0_tax_groups` --
1988 DROP TABLE IF EXISTS `0_tax_groups`;
1990 CREATE TABLE `0_tax_groups` (
1991 `id` int(11) NOT NULL AUTO_INCREMENT,
1992 `name` varchar(60) NOT NULL DEFAULT '',
1993 `tax_area` tinyint(1) NOT NULL DEFAULT '0',
1994 `inactive` tinyint(1) NOT NULL DEFAULT '0',
1996 UNIQUE KEY `name` (`name`)
1997 ) ENGINE=InnoDB AUTO_INCREMENT=3 ;
1999 -- Data of table `0_tax_groups` --
2001 INSERT INTO `0_tax_groups` VALUES
2002 ('1', 'Tax', '0', '0'),
2003 ('2', 'Export/Import', '1', '0');
2005 -- Structure of table `0_tax_types` --
2007 DROP TABLE IF EXISTS `0_tax_types`;
2009 CREATE TABLE `0_tax_types` (
2010 `id` int(11) NOT NULL AUTO_INCREMENT,
2011 `rate` double NOT NULL DEFAULT '0',
2012 `sales_gl_code` varchar(15) NOT NULL DEFAULT '',
2013 `purchasing_gl_code` varchar(15) NOT NULL DEFAULT '',
2014 `name` varchar(60) NOT NULL DEFAULT '',
2015 `inactive` tinyint(1) NOT NULL DEFAULT '0',
2017 ) ENGINE=InnoDB AUTO_INCREMENT=2 ;
2019 -- Data of table `0_tax_types` --
2021 INSERT INTO `0_tax_types` VALUES
2022 ('1', '5', '2150', '2150', 'Tax', '0');
2024 -- Structure of table `0_trans_tax_details` --
2026 DROP TABLE IF EXISTS `0_trans_tax_details`;
2028 CREATE TABLE `0_trans_tax_details` (
2029 `id` int(11) NOT NULL AUTO_INCREMENT,
2030 `trans_type` smallint(6) DEFAULT NULL,
2031 `trans_no` int(11) DEFAULT NULL,
2032 `tran_date` date NOT NULL,
2033 `tax_type_id` int(11) NOT NULL DEFAULT '0',
2034 `rate` double NOT NULL DEFAULT '0',
2035 `ex_rate` double NOT NULL DEFAULT '1',
2036 `included_in_price` tinyint(1) NOT NULL DEFAULT '0',
2037 `net_amount` double NOT NULL DEFAULT '0',
2038 `amount` double NOT NULL DEFAULT '0',
2040 `reg_type` tinyint(1) DEFAULT NULL,
2041 `vat_category` int(11) NOT NULL DEFAULT '0',
2042 `tax_group_id` tinyint(2) DEFAULT NULL,
2044 KEY `Type_and_Number` (`trans_type`,`trans_no`),
2045 KEY `tran_date` (`tran_date`)
2046 ) ENGINE=InnoDB AUTO_INCREMENT=11 ;
2048 -- Data of table `0_trans_tax_details` --
2050 INSERT INTO `0_trans_tax_details` VALUES
2051 ('1', '13', '1', '2018-05-10', '1', '5', '1', '1', '5942.86', '297.14', 'auto', NULL, '0', '1'),
2052 ('2', '10', '1', '2018-05-10', '1', '5', '1', '1', '5942.86', '297.14', '001/2018', '0', '0', '1'),
2053 ('3', '20', '1', '2018-05-05', '1', '5', '1', '0', '3000', '150', 'rr4', '1', '0', '1'),
2054 ('4', '13', '2', '2018-05-07', '1', '5', '1', '1', '285.71', '14.29', 'auto', NULL, '0', '1'),
2055 ('5', '10', '2', '2018-05-07', '1', '5', '1', '1', '285.71', '14.29', '002/2018', '0', '0', '1'),
2056 ('6', '13', '3', '2018-05-07', '0', '0', '1.123', '1', '267.14', '0', 'auto', NULL, '0', '1'),
2057 ('7', '10', '3', '2018-05-07', '0', '0', '1.123', '1', '267.14', '0', '003/2018', '0', '0', '1'),
2058 ('8', '13', '5', '2019-01-21', '1', '5', '1', '1', '1190.48', '59.52', 'auto', NULL, '0', '1'),
2059 ('9', '10', '5', '2019-01-21', '1', '5', '1', '1', '1190.48', '59.52', '001/2019', '0', '0', '1'),
2060 ('10', '20', '2', '2019-01-21', '1', '5', '1', '0', '900', '45', 'asd5', '1', '0', '1');
2062 -- Structure of table `0_useronline` --
2064 DROP TABLE IF EXISTS `0_useronline`;
2066 CREATE TABLE `0_useronline` (
2067 `id` int(11) NOT NULL AUTO_INCREMENT,
2068 `timestamp` int(15) NOT NULL DEFAULT '0',
2069 `ip` varchar(40) NOT NULL DEFAULT '',
2070 `file` varchar(100) NOT NULL DEFAULT '',
2072 KEY `timestamp` (`timestamp`),
2076 -- Data of table `0_useronline` --
2079 -- Structure of table `0_users` --
2081 DROP TABLE IF EXISTS `0_users`;
2083 CREATE TABLE `0_users` (
2084 `id` smallint(6) NOT NULL AUTO_INCREMENT,
2085 `user_id` varchar(60) NOT NULL DEFAULT '',
2086 `password` varchar(100) NOT NULL DEFAULT '',
2087 `real_name` varchar(100) NOT NULL DEFAULT '',
2088 `role_id` int(11) NOT NULL DEFAULT '1',
2089 `phone` varchar(30) NOT NULL DEFAULT '',
2090 `email` varchar(100) DEFAULT NULL,
2091 `language` varchar(20) DEFAULT NULL,
2092 `date_format` tinyint(1) NOT NULL DEFAULT '0',
2093 `date_sep` tinyint(1) NOT NULL DEFAULT '0',
2094 `tho_sep` tinyint(1) NOT NULL DEFAULT '0',
2095 `dec_sep` tinyint(1) NOT NULL DEFAULT '0',
2096 `theme` varchar(20) NOT NULL DEFAULT 'default',
2097 `page_size` varchar(20) NOT NULL DEFAULT 'A4',
2098 `prices_dec` smallint(6) NOT NULL DEFAULT '2',
2099 `qty_dec` smallint(6) NOT NULL DEFAULT '2',
2100 `rates_dec` smallint(6) NOT NULL DEFAULT '4',
2101 `percent_dec` smallint(6) NOT NULL DEFAULT '1',
2102 `show_gl` tinyint(1) NOT NULL DEFAULT '1',
2103 `show_codes` tinyint(1) NOT NULL DEFAULT '0',
2104 `show_hints` tinyint(1) NOT NULL DEFAULT '0',
2105 `last_visit_date` datetime DEFAULT NULL,
2106 `query_size` tinyint(1) unsigned NOT NULL DEFAULT '10',
2107 `graphic_links` tinyint(1) DEFAULT '1',
2108 `pos` smallint(6) DEFAULT '1',
2109 `print_profile` varchar(30) NOT NULL DEFAULT '',
2110 `rep_popup` tinyint(1) DEFAULT '1',
2111 `sticky_doc_date` tinyint(1) DEFAULT '0',
2112 `startup_tab` varchar(20) NOT NULL DEFAULT '',
2113 `transaction_days` smallint(6) NOT NULL DEFAULT '30',
2114 `save_report_selections` smallint(6) NOT NULL DEFAULT '0',
2115 `use_date_picker` tinyint(1) NOT NULL DEFAULT '1',
2116 `def_print_destination` tinyint(1) NOT NULL DEFAULT '0',
2117 `def_print_orientation` tinyint(1) NOT NULL DEFAULT '0',
2118 `inactive` tinyint(1) NOT NULL DEFAULT '0',
2120 UNIQUE KEY `user_id` (`user_id`)
2121 ) ENGINE=InnoDB AUTO_INCREMENT=2 ;
2123 -- Data of table `0_users` --
2125 INSERT INTO `0_users` VALUES
2126 ('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');
2128 -- Structure of table `0_voided` --
2130 DROP TABLE IF EXISTS `0_voided`;
2132 CREATE TABLE `0_voided` (
2133 `type` int(11) NOT NULL DEFAULT '0',
2134 `id` int(11) NOT NULL DEFAULT '0',
2135 `date_` date NOT NULL DEFAULT '0000-00-00',
2136 `memo_` tinytext NOT NULL,
2137 UNIQUE KEY `id` (`type`,`id`)
2140 -- Data of table `0_voided` --
2143 -- Structure of table `0_wo_costing` --
2145 DROP TABLE IF EXISTS `0_wo_costing`;
2147 CREATE TABLE `0_wo_costing` (
2148 `id` int(11) NOT NULL AUTO_INCREMENT,
2149 `workorder_id` int(11) NOT NULL DEFAULT '0',
2150 `cost_type` tinyint(1) NOT NULL DEFAULT '0',
2151 `trans_type` int(11) NOT NULL DEFAULT '0',
2152 `trans_no` int(11) NOT NULL DEFAULT '0',
2153 `factor` double NOT NULL DEFAULT '1',
2157 -- Data of table `0_wo_costing` --
2159 -- Structure of table `0_wo_issue_items` --
2161 DROP TABLE IF EXISTS `0_wo_issue_items`;
2163 CREATE TABLE `0_wo_issue_items` (
2164 `id` int(11) NOT NULL AUTO_INCREMENT,
2165 `stock_id` varchar(40) DEFAULT NULL,
2166 `issue_id` int(11) DEFAULT NULL,
2167 `qty_issued` double DEFAULT NULL,
2168 `unit_cost` double NOT NULL DEFAULT '0',
2172 -- Data of table `0_wo_issue_items` --
2175 -- Structure of table `0_wo_issues` --
2177 DROP TABLE IF EXISTS `0_wo_issues`;
2179 CREATE TABLE `0_wo_issues` (
2180 `issue_no` int(11) NOT NULL AUTO_INCREMENT,
2181 `workorder_id` int(11) NOT NULL DEFAULT '0',
2182 `reference` varchar(100) DEFAULT NULL,
2183 `issue_date` date DEFAULT NULL,
2184 `loc_code` varchar(5) DEFAULT NULL,
2185 `workcentre_id` int(11) DEFAULT NULL,
2186 PRIMARY KEY (`issue_no`),
2187 KEY `workorder_id` (`workorder_id`)
2190 -- Data of table `0_wo_issues` --
2192 -- Structure of table `0_wo_manufacture` --
2194 DROP TABLE IF EXISTS `0_wo_manufacture`;
2196 CREATE TABLE `0_wo_manufacture` (
2197 `id` int(11) NOT NULL AUTO_INCREMENT,
2198 `reference` varchar(100) DEFAULT NULL,
2199 `workorder_id` int(11) NOT NULL DEFAULT '0',
2200 `quantity` double NOT NULL DEFAULT '0',
2201 `date_` date NOT NULL DEFAULT '0000-00-00',
2203 KEY `workorder_id` (`workorder_id`)
2204 ) ENGINE=InnoDB AUTO_INCREMENT=2 ;
2206 -- Data of table `0_wo_manufacture` --
2208 INSERT INTO `0_wo_manufacture` VALUES
2209 ('1', '001/2018', '1', '2', '2018-05-05');
2211 -- Structure of table `0_wo_requirements` --
2213 DROP TABLE IF EXISTS `0_wo_requirements`;
2215 CREATE TABLE `0_wo_requirements` (
2216 `id` int(11) NOT NULL AUTO_INCREMENT,
2217 `workorder_id` int(11) NOT NULL DEFAULT '0',
2218 `stock_id` char(20) NOT NULL DEFAULT '',
2219 `workcentre` int(11) NOT NULL DEFAULT '0',
2220 `units_req` double NOT NULL DEFAULT '1',
2221 `unit_cost` double NOT NULL DEFAULT '0',
2222 `loc_code` char(5) NOT NULL DEFAULT '',
2223 `units_issued` double NOT NULL DEFAULT '0',
2225 KEY `workorder_id` (`workorder_id`)
2226 ) ENGINE=InnoDB AUTO_INCREMENT=9 ;
2228 -- Data of table `0_wo_requirements` --
2230 INSERT INTO `0_wo_requirements` VALUES
2231 ('1', '1', '101', '1', '1', '200', 'DEF', '2'),
2232 ('2', '1', '102', '1', '1', '150', 'DEF', '2'),
2233 ('3', '1', '103', '1', '1', '10', 'DEF', '2'),
2234 ('4', '1', '301', '1', '1', '0', 'DEF', '2'),
2235 ('5', '2', '101', '1', '1', '200', 'DEF', '0'),
2236 ('6', '2', '102', '1', '1', '150', 'DEF', '0'),
2237 ('7', '2', '103', '1', '1', '10', 'DEF', '0'),
2238 ('8', '2', '301', '1', '1', '0', 'DEF', '0');
2240 -- Structure of table `0_workcentres` --
2242 DROP TABLE IF EXISTS `0_workcentres`;
2244 CREATE TABLE `0_workcentres` (
2245 `id` int(11) NOT NULL AUTO_INCREMENT,
2246 `name` char(40) NOT NULL DEFAULT '',
2247 `description` char(50) NOT NULL DEFAULT '',
2248 `inactive` tinyint(1) NOT NULL DEFAULT '0',
2250 UNIQUE KEY `name` (`name`)
2251 ) ENGINE=InnoDB AUTO_INCREMENT=2 ;
2253 -- Data of table `0_workcentres` --
2255 INSERT INTO `0_workcentres` VALUES
2256 ('1', 'Work Centre', '', '0');
2258 -- Structure of table `0_workorders` --
2260 DROP TABLE IF EXISTS `0_workorders`;
2262 CREATE TABLE `0_workorders` (
2263 `id` int(11) NOT NULL AUTO_INCREMENT,
2264 `wo_ref` varchar(60) NOT NULL DEFAULT '',
2265 `loc_code` varchar(5) NOT NULL DEFAULT '',
2266 `units_reqd` double NOT NULL DEFAULT '1',
2267 `stock_id` varchar(20) NOT NULL DEFAULT '',
2268 `date_` date NOT NULL DEFAULT '0000-00-00',
2269 `type` tinyint(4) NOT NULL DEFAULT '0',
2270 `required_by` date NOT NULL DEFAULT '0000-00-00',
2271 `released_date` date NOT NULL DEFAULT '0000-00-00',
2272 `units_issued` double NOT NULL DEFAULT '0',
2273 `closed` tinyint(1) NOT NULL DEFAULT '0',
2274 `released` tinyint(1) NOT NULL DEFAULT '0',
2276 KEY `wo_ref` (`wo_ref`)
2277 ) ENGINE=InnoDB AUTO_INCREMENT=4 ;
2279 -- Data of table `0_workorders` --
2281 INSERT INTO `0_workorders` VALUES
2282 ('1', '001/2018', 'DEF', '2', '201', '2018-05-05', '0', '2018-05-05', '2018-05-05', '2', '1', '1'),
2283 ('2', '002/2018', 'DEF', '5', '201', '2018-05-07', '2', '2018-05-27', '2018-05-07', '0', '0', '1'),
2284 ('3', '003/2018', 'DEF', '5', '201', '2018-05-07', '2', '2018-05-27', '0000-00-00', '0', '0', '0');