1 -- MySQL dump of database 'en_US-demo' on host 'localhost'
2 -- Backup Date and Time: 2020-01-21 11:16
3 -- Built by FrontAccounting 2.4.7
4 -- http://frontaccounting.com
5 -- Company: Training Co.
8 -- Compatibility: 2.4.1
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', '2019-05-05 14:08:02', NULL, '1', '2019-05-05', '0'),
74 ('2', '25', '1', '1', '2019-05-05 14:08:14', NULL, '1', '2019-05-05', '1'),
75 ('3', '30', '1', '1', '2019-05-05 14:09:54', NULL, '1', '2019-05-10', '0'),
76 ('4', '13', '1', '1', '2019-05-05 14:09:55', NULL, '1', '2019-05-10', '13'),
77 ('5', '10', '1', '1', '2019-05-05 14:09:55', NULL, '1', '2019-05-10', '14'),
78 ('6', '12', '1', '1', '2019-05-05 14:09:55', NULL, '1', '2019-05-10', '15'),
79 ('7', '29', '1', '1', '2019-05-05 14:18:49', 'Quick production.', '1', '2019-05-05', '2'),
80 ('8', '18', '2', '1', '2019-05-05 14:22:32', NULL, '1', '2019-05-05', '0'),
81 ('9', '25', '2', '1', '2019-05-05 14:22:32', NULL, '1', '2019-05-05', '3'),
82 ('10', '20', '1', '1', '2019-05-05 14:22:32', NULL, '1', '2019-05-05', '4'),
83 ('11', '30', '2', '1', '2019-05-07 07:55:15', NULL, '1', '2019-05-07', '0'),
84 ('12', '13', '2', '1', '2019-05-07 07:55:16', NULL, '1', '2019-05-07', '7'),
85 ('13', '10', '2', '1', '2019-05-07 07:55:16', NULL, '1', '2019-05-07', '8'),
86 ('14', '12', '2', '1', '2019-05-07 07:55:16', NULL, '1', '2019-05-07', '9'),
87 ('15', '30', '3', '1', '2019-05-07 08:08:24', NULL, '1', '2019-05-07', '0'),
88 ('16', '30', '4', '1', '2019-05-07 09:18:44', NULL, '1', '2019-05-07', '0'),
89 ('17', '30', '5', '1', '2019-05-07 11:42:41', NULL, '1', '2019-05-07', '0'),
90 ('18', '13', '3', '1', '2019-05-07 11:42:41', NULL, '1', '2019-05-07', '10'),
91 ('19', '10', '3', '1', '2019-05-07 11:42:41', NULL, '1', '2019-05-07', '11'),
92 ('20', '30', '6', '1', '2019-05-07 14:02:35', NULL, '1', '2019-05-07', '0'),
93 ('21', '30', '7', '1', '2019-05-07 14:05:38', NULL, '1', '2019-05-07', '0'),
94 ('22', '13', '4', '1', '2019-05-07 14:05:38', NULL, '1', '2019-05-07', '0'),
95 ('23', '10', '4', '1', '2019-05-07 14:05:38', NULL, '1', '2019-05-07', '0'),
96 ('24', '12', '3', '1', '2019-05-07 14:05:38', NULL, '1', '2019-05-07', '0'),
97 ('25', '26', '1', '1', '2019-05-07 15:59:34', NULL, '1', '2019-05-07', NULL),
98 ('26', '29', '1', '1', '2019-05-07 15:59:01', 'Production.', '1', '2019-05-07', '5'),
99 ('27', '26', '1', '1', '2019-05-07 15:59:34', 'Released.', '1', '2019-05-07', '6'),
100 ('28', '1', '1', '1', '2019-05-07 16:01:00', NULL, '1', '2019-05-07', '12'),
101 ('29', '30', '8', '1', '2020-01-21 11:13:06', NULL, '2', '2020-01-21', '0'),
102 ('30', '13', '5', '1', '2020-01-21 11:13:06', NULL, '2', '2020-01-21', '0'),
103 ('31', '10', '5', '1', '2020-01-21 11:13:06', NULL, '2', '2020-01-21', '0'),
104 ('32', '12', '4', '1', '2020-01-21 11:13:06', NULL, '2', '2020-01-21', '0'),
105 ('33', '18', '3', '1', '2020-01-21 11:14:14', NULL, '2', '2020-01-21', '0'),
106 ('34', '25', '3', '1', '2020-01-21 11:14:14', NULL, '2', '2020-01-21', '0'),
107 ('35', '20', '2', '1', '2020-01-21 11:14:14', NULL, '2', '2020-01-21', '0'),
108 ('36', '0', '1', '1', '2020-01-21 11:15:35', NULL, '1', '2019-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/2019', '2019-05-10', '6240', '0', '0', '2', '1', NULL),
168 ('2', '12', '2', '2', '002/2019', '2019-05-07', '300', '0', '0', '2', '1', NULL),
169 ('3', '12', '3', '2', '003/2019', '2019-05-07', '0', '0', '0', '2', '1', NULL),
170 ('4', '1', '1', '1', '001/2019', '2019-05-07', '-5', '0', '0', '0', 'Goods received', NULL),
171 ('5', '12', '4', '2', '001/2020', '2020-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', '2019-05-10', 'Cash invoice 1'),
383 ('12', '2', '2019-05-07', 'Cash invoice 2'),
384 ('13', '4', '2019-05-07', 'Recurrent Invoice covers period 04/01/2019 - 04/07/2019.'),
385 ('10', '4', '2019-05-07', 'Recurrent Invoice covers period 04/01/2019 - 04/07/2019.'),
386 ('12', '3', '2019-05-07', 'Cash invoice 4'),
387 ('12', '4', '2020-01-21', 'Default #5'),
388 ('0', '1', '2019-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', '2019-05-10', '1', '12', '1', '10'),
542 ('2', '1', '300', '2019-05-07', '2', '12', '2', '10'),
543 ('3', '1', '0', '2019-05-07', '3', '12', '4', '10'),
544 ('4', '1', '1250', '2020-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` int(11) NOT NULL DEFAULT '1',
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', '1', 'N/A', '0', '', NULL, '0'),
579 ('2', '2', 'MoneyMaker Ltd.', 'MoneyMaker', '', '1', '1', 'DEF', '2', '', '4510', '1200', '4500', '1', '', '0', '', NULL, '0');
581 -- Structure of table `0_debtor_trans` --
583 DROP TABLE IF EXISTS `0_debtor_trans`;
585 CREATE TABLE `0_debtor_trans` (
586 `trans_no` int(11) unsigned NOT NULL DEFAULT '0',
587 `type` smallint(6) unsigned NOT NULL DEFAULT '0',
588 `version` tinyint(1) unsigned NOT NULL DEFAULT '0',
589 `debtor_no` int(11) unsigned NOT NULL,
590 `branch_code` int(11) NOT NULL DEFAULT '-1',
591 `tran_date` date NOT NULL DEFAULT '0000-00-00',
592 `due_date` date NOT NULL DEFAULT '0000-00-00',
593 `reference` varchar(60) NOT NULL DEFAULT '',
594 `tpe` int(11) NOT NULL DEFAULT '0',
595 `order_` int(11) NOT NULL DEFAULT '0',
596 `ov_amount` double NOT NULL DEFAULT '0',
597 `ov_gst` double NOT NULL DEFAULT '0',
598 `ov_freight` double NOT NULL DEFAULT '0',
599 `ov_freight_tax` double NOT NULL DEFAULT '0',
600 `ov_discount` double NOT NULL DEFAULT '0',
601 `alloc` double NOT NULL DEFAULT '0',
602 `prep_amount` double NOT NULL DEFAULT '0',
603 `rate` double NOT NULL DEFAULT '1',
604 `ship_via` int(11) DEFAULT NULL,
605 `dimension_id` int(11) NOT NULL DEFAULT '0',
606 `dimension2_id` int(11) NOT NULL DEFAULT '0',
607 `payment_terms` int(11) DEFAULT NULL,
608 `tax_included` tinyint(1) unsigned NOT NULL DEFAULT '0',
609 PRIMARY KEY (`type`,`trans_no`,`debtor_no`),
610 KEY `debtor_no` (`debtor_no`,`branch_code`),
611 KEY `tran_date` (`tran_date`),
612 KEY `order_` (`order_`)
615 -- Data of table `0_debtor_trans` --
617 INSERT INTO `0_debtor_trans` VALUES
618 ('1', '10', '0', '1', '1', '2019-05-10', '2019-05-05', '001/2019', '1', '1', '6240', '0', '0', '0', '0', '6240', '0', '1', '1', '0', '0', '4', '1'),
619 ('2', '10', '0', '1', '1', '2019-05-07', '2019-05-07', '002/2019', '1', '2', '300', '0', '0', '0', '0', '300', '0', '1', '1', '0', '0', '4', '1'),
620 ('3', '10', '0', '2', '2', '2019-05-07', '2019-06-17', '003/2019', '1', '5', '267.14', '0', '0', '0', '0', '0', '0', '1.123', '1', '1', '0', '1', '1'),
621 ('4', '10', '0', '1', '1', '2019-05-07', '2019-05-07', '004/2019', '1', '7', '0', '0', '0', '0', '0', '0', '0', '1', '1', '0', '0', '4', '1'),
622 ('5', '10', '0', '1', '1', '2020-01-21', '2020-01-21', '001/2020', '1', '8', '1250', '0', '0', '0', '0', '1250', '0', '1', '1', '0', '0', '4', '1'),
623 ('1', '12', '0', '1', '1', '2019-05-10', '0000-00-00', '001/2019', '0', '0', '6240', '0', '0', '0', '0', '6240', '0', '1', '0', '0', '0', NULL, '0'),
624 ('2', '12', '0', '1', '1', '2019-05-07', '0000-00-00', '002/2019', '0', '0', '300', '0', '0', '0', '0', '300', '0', '1', '0', '0', '0', NULL, '0'),
625 ('3', '12', '0', '1', '1', '2019-05-07', '0000-00-00', '003/2019', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', NULL, '0'),
626 ('4', '12', '0', '1', '1', '2020-01-21', '0000-00-00', '001/2020', '0', '0', '1250', '0', '0', '0', '0', '1250', '0', '1', '0', '0', '0', NULL, '0'),
627 ('1', '13', '1', '1', '1', '2019-05-10', '2019-05-05', 'auto', '1', '1', '6240', '0', '0', '0', '0', '0', '0', '1', '1', '0', '0', '4', '1'),
628 ('2', '13', '1', '1', '1', '2019-05-07', '2019-05-07', 'auto', '1', '2', '300', '0', '0', '0', '0', '0', '0', '1', '1', '0', '0', '4', '1'),
629 ('3', '13', '1', '2', '2', '2019-05-07', '2019-06-17', 'auto', '1', '5', '267.14', '0', '0', '0', '0', '0', '0', '1.123', '1', '1', '0', '1', '1'),
630 ('4', '13', '1', '1', '1', '2019-05-07', '2019-05-07', 'auto', '1', '7', '0', '0', '0', '0', '0', '0', '0', '1', '1', '0', '0', '4', '1'),
631 ('5', '13', '1', '1', '1', '2020-01-21', '2020-01-21', 'auto', '1', '8', '1250', '0', '0', '0', '0', '0', '0', '1', '1', '0', '0', '4', '1');
633 -- Structure of table `0_debtor_trans_details` --
635 DROP TABLE IF EXISTS `0_debtor_trans_details`;
637 CREATE TABLE `0_debtor_trans_details` (
638 `id` int(11) NOT NULL AUTO_INCREMENT,
639 `debtor_trans_no` int(11) DEFAULT NULL,
640 `debtor_trans_type` int(11) DEFAULT NULL,
641 `stock_id` varchar(20) NOT NULL DEFAULT '',
642 `description` tinytext,
643 `unit_price` double NOT NULL DEFAULT '0',
644 `unit_tax` double NOT NULL DEFAULT '0',
645 `quantity` double NOT NULL DEFAULT '0',
646 `discount_percent` double NOT NULL DEFAULT '0',
647 `standard_cost` double NOT NULL DEFAULT '0',
648 `qty_done` double NOT NULL DEFAULT '0',
649 `src_id` int(11) NOT NULL,
651 KEY `Transaction` (`debtor_trans_type`,`debtor_trans_no`),
652 KEY `src_id` (`src_id`)
653 ) ENGINE=InnoDB AUTO_INCREMENT=15 ;
655 -- Data of table `0_debtor_trans_details` --
657 INSERT INTO `0_debtor_trans_details` VALUES
658 ('1', '1', '13', '101', 'iPad Air 2 16GB', '300', '14.29', '20', '0', '200', '20', '1'),
659 ('2', '1', '13', '301', 'Support', '80', '3.81', '3', '0', '0', '3', '2'),
660 ('3', '1', '10', '101', 'iPad Air 2 16GB', '300', '14.2855', '20', '0', '200', '0', '1'),
661 ('4', '1', '10', '301', 'Support', '80', '3.81', '3', '0', '0', '0', '2'),
662 ('5', '2', '13', '101', 'iPad Air 2 16GB', '300', '14.29', '1', '0', '200', '1', '3'),
663 ('6', '2', '10', '101', 'iPad Air 2 16GB', '300', '14.29', '1', '0', '200', '0', '5'),
664 ('7', '3', '13', '102', 'iPhone 6 64GB', '222.62', '0', '1', '0', '150', '1', '7'),
665 ('8', '3', '13', '103', 'iPhone Cover Case', '44.52', '0', '1', '0', '10', '1', '8'),
666 ('9', '3', '10', '102', 'iPhone 6 64GB', '222.62', '0', '1', '0', '150', '0', '7'),
667 ('10', '3', '10', '103', 'iPhone Cover Case', '44.52', '0', '1', '0', '10', '0', '8'),
668 ('11', '4', '13', '202', 'Maintenance', '0', '0', '5', '0', '0', '5', '10'),
669 ('12', '4', '10', '202', 'Maintenance', '0', '0', '5', '0', '0', '0', '11'),
670 ('13', '5', '13', '102', 'iPhone 6 64GB', '250', '11.904', '5', '0', '150', '5', '11'),
671 ('14', '5', '10', '102', 'iPhone 6 64GB', '250', '11.904', '5', '0', '150', '0', '13');
673 -- Structure of table `0_debtors_master` --
675 DROP TABLE IF EXISTS `0_debtors_master`;
677 CREATE TABLE `0_debtors_master` (
678 `debtor_no` int(11) NOT NULL AUTO_INCREMENT,
679 `name` varchar(100) NOT NULL DEFAULT '',
680 `debtor_ref` varchar(30) NOT NULL,
682 `tax_id` varchar(55) NOT NULL DEFAULT '',
683 `curr_code` char(3) NOT NULL DEFAULT '',
684 `sales_type` int(11) NOT NULL DEFAULT '1',
685 `dimension_id` int(11) NOT NULL DEFAULT '0',
686 `dimension2_id` int(11) NOT NULL DEFAULT '0',
687 `credit_status` int(11) NOT NULL DEFAULT '0',
688 `payment_terms` int(11) DEFAULT NULL,
689 `discount` double NOT NULL DEFAULT '0',
690 `pymt_discount` double NOT NULL DEFAULT '0',
691 `credit_limit` float NOT NULL DEFAULT '1000',
692 `notes` tinytext NOT NULL,
693 `inactive` tinyint(1) NOT NULL DEFAULT '0',
694 PRIMARY KEY (`debtor_no`),
695 UNIQUE KEY `debtor_ref` (`debtor_ref`),
697 ) ENGINE=InnoDB AUTO_INCREMENT=3 ;
699 -- Data of table `0_debtors_master` --
701 INSERT INTO `0_debtors_master` VALUES
702 ('1', 'Donald Easter LLC', 'Donald Easter', 'N/A', '123456789', 'USD', '1', '0', '0', '1', '4', '0', '0', '1000', '', '0'),
703 ('2', 'MoneyMaker Ltd.', 'MoneyMaker', 'N/A', '54354333', 'EUR', '1', '1', '0', '1', '1', '0', '0', '1000', '', '0');
705 -- Structure of table `0_dimensions` --
707 DROP TABLE IF EXISTS `0_dimensions`;
709 CREATE TABLE `0_dimensions` (
710 `id` int(11) NOT NULL AUTO_INCREMENT,
711 `reference` varchar(60) NOT NULL DEFAULT '',
712 `name` varchar(60) NOT NULL DEFAULT '',
713 `type_` tinyint(1) NOT NULL DEFAULT '1',
714 `closed` tinyint(1) NOT NULL DEFAULT '0',
715 `date_` date NOT NULL DEFAULT '0000-00-00',
716 `due_date` date NOT NULL DEFAULT '0000-00-00',
718 UNIQUE KEY `reference` (`reference`),
719 KEY `date_` (`date_`),
720 KEY `due_date` (`due_date`),
721 KEY `type_` (`type_`)
722 ) ENGINE=InnoDB AUTO_INCREMENT=2 ;
724 -- Data of table `0_dimensions` --
726 INSERT INTO `0_dimensions` VALUES
727 ('1', '001/2019', 'Cost Centre', '1', '0', '2019-05-05', '2019-05-25');
729 -- Structure of table `0_exchange_rates` --
731 DROP TABLE IF EXISTS `0_exchange_rates`;
733 CREATE TABLE `0_exchange_rates` (
734 `id` int(11) NOT NULL AUTO_INCREMENT,
735 `curr_code` char(3) NOT NULL DEFAULT '',
736 `rate_buy` double NOT NULL DEFAULT '0',
737 `rate_sell` double NOT NULL DEFAULT '0',
738 `date_` date NOT NULL DEFAULT '0000-00-00',
740 UNIQUE KEY `curr_code` (`curr_code`,`date_`)
741 ) ENGINE=InnoDB AUTO_INCREMENT=2 ;
743 -- Data of table `0_exchange_rates` --
745 INSERT INTO `0_exchange_rates` VALUES
746 ('1', 'EUR', '1.123', '1.123', '2019-05-07');
748 -- Structure of table `0_fiscal_year` --
750 DROP TABLE IF EXISTS `0_fiscal_year`;
752 CREATE TABLE `0_fiscal_year` (
753 `id` int(11) NOT NULL AUTO_INCREMENT,
754 `begin` date DEFAULT '0000-00-00',
755 `end` date DEFAULT '0000-00-00',
756 `closed` tinyint(1) NOT NULL DEFAULT '0',
758 UNIQUE KEY `begin` (`begin`),
759 UNIQUE KEY `end` (`end`)
760 ) ENGINE=InnoDB AUTO_INCREMENT=3 ;
762 -- Data of table `0_fiscal_year` --
764 INSERT INTO `0_fiscal_year` VALUES
765 ('1', '2019-01-01', '2019-12-31', '1'),
766 ('2', '2020-01-01', '2020-12-31', '0');
768 -- Structure of table `0_gl_trans` --
770 DROP TABLE IF EXISTS `0_gl_trans`;
772 CREATE TABLE `0_gl_trans` (
773 `counter` int(11) NOT NULL AUTO_INCREMENT,
774 `type` smallint(6) NOT NULL DEFAULT '0',
775 `type_no` int(11) NOT NULL DEFAULT '0',
776 `tran_date` date NOT NULL DEFAULT '0000-00-00',
777 `account` varchar(15) NOT NULL DEFAULT '',
778 `memo_` tinytext NOT NULL,
779 `amount` double NOT NULL DEFAULT '0',
780 `dimension_id` int(11) NOT NULL DEFAULT '0',
781 `dimension2_id` int(11) NOT NULL DEFAULT '0',
782 `person_type_id` int(11) DEFAULT NULL,
783 `person_id` tinyblob,
784 PRIMARY KEY (`counter`),
785 KEY `Type_and_Number` (`type`,`type_no`),
786 KEY `dimension_id` (`dimension_id`),
787 KEY `dimension2_id` (`dimension2_id`),
788 KEY `tran_date` (`tran_date`),
789 KEY `account_and_tran_date` (`account`,`tran_date`)
790 ) ENGINE=InnoDB AUTO_INCREMENT=55 ;
792 -- Data of table `0_gl_trans` --
794 INSERT INTO `0_gl_trans` VALUES
795 ('1', '25', '1', '2019-05-05', '1510', '101', '20000', '0', '0', NULL, NULL),
796 ('2', '25', '1', '2019-05-05', '1510', '102', '15000', '0', '0', NULL, NULL),
797 ('3', '25', '1', '2019-05-05', '1510', '103', '1000', '0', '0', NULL, NULL),
798 ('4', '25', '1', '2019-05-05', '1550', '', '-36000', '0', '0', NULL, NULL),
799 ('5', '13', '1', '2019-05-10', '5010', '', '4000', '0', '0', NULL, NULL),
800 ('6', '13', '1', '2019-05-10', '1510', '', '-4000', '0', '0', NULL, NULL),
801 ('7', '10', '1', '2019-05-10', '4010', '', '-5714.29', '0', '0', NULL, NULL),
802 ('8', '10', '1', '2019-05-10', '4010', '', '-228.57', '0', '0', NULL, NULL),
803 ('9', '10', '1', '2019-05-10', '1200', '', '6240', '0', '0', '2', '1'),
804 ('10', '10', '1', '2019-05-10', '2150', '', '-297.14', '0', '0', NULL, NULL),
805 ('11', '12', '1', '2019-05-10', '1065', '', '6240', '0', '0', NULL, NULL),
806 ('12', '12', '1', '2019-05-10', '1200', '', '-6240', '0', '0', '2', '1'),
807 ('13', '29', '1', '2019-05-05', '1510', '1 * iPad Air 2 16GB', '-400', '0', '0', NULL, NULL),
808 ('14', '29', '1', '2019-05-05', '1510', '1 * iPhone 6 64GB', '-300', '0', '0', NULL, NULL),
809 ('15', '29', '1', '2019-05-05', '1510', '1 * iPhone Cover Case', '-20', '0', '0', NULL, NULL),
810 ('16', '29', '1', '2019-05-05', '1530', '1 * Support', '720', '0', '0', NULL, NULL),
811 ('17', '26', '1', '2019-05-05', '1530', '', '-720', '0', '0', NULL, NULL),
812 ('18', '26', '1', '2019-05-05', '1510', '', '720', '0', '0', NULL, NULL),
813 ('19', '25', '2', '2019-05-05', '1510', '101', '3000', '0', '0', NULL, NULL),
814 ('20', '25', '2', '2019-05-05', '1550', '', '-3000', '0', '0', NULL, NULL),
815 ('21', '20', '1', '2019-05-05', '2150', '', '150', '0', '0', NULL, NULL),
816 ('22', '20', '1', '2019-05-05', '2100', '', '-3150', '0', '0', '3', '1'),
817 ('23', '20', '1', '2019-05-05', '1550', '', '3000', '0', '0', NULL, NULL),
818 ('24', '13', '2', '2019-05-07', '5010', '', '200', '0', '0', NULL, NULL),
819 ('25', '13', '2', '2019-05-07', '1510', '', '-200', '0', '0', NULL, NULL),
820 ('26', '10', '2', '2019-05-07', '4010', '', '-285.71', '0', '0', NULL, NULL),
821 ('27', '10', '2', '2019-05-07', '1200', '', '300', '0', '0', '2', '1'),
822 ('28', '10', '2', '2019-05-07', '2150', '', '-14.29', '0', '0', NULL, NULL),
823 ('29', '12', '2', '2019-05-07', '1065', '', '300', '0', '0', NULL, NULL),
824 ('30', '12', '2', '2019-05-07', '1200', '', '-300', '0', '0', '2', '1'),
825 ('31', '13', '3', '2019-05-07', '5010', '', '150', '1', '0', NULL, NULL),
826 ('32', '13', '3', '2019-05-07', '1510', '', '-150', '0', '0', NULL, NULL),
827 ('33', '13', '3', '2019-05-07', '5010', '', '10', '1', '0', NULL, NULL),
828 ('34', '13', '3', '2019-05-07', '1510', '', '-10', '0', '0', NULL, NULL),
829 ('35', '10', '3', '2019-05-07', '4010', '', '-250', '1', '0', NULL, NULL),
830 ('36', '10', '3', '2019-05-07', '4010', '', '-50', '1', '0', NULL, NULL),
831 ('37', '10', '3', '2019-05-07', '1200', '', '300', '0', '0', '2', '2'),
832 ('38', '12', '3', '2019-05-07', '1065', '', '0', '0', '0', NULL, NULL),
833 ('39', '1', '1', '2019-05-07', '5010', '', '5', '1', '0', NULL, NULL),
834 ('40', '1', '1', '2019-05-07', '1060', '', '-5', '0', '0', NULL, NULL),
835 ('41', '13', '5', '2020-01-21', '5010', '', '750', '0', '0', NULL, NULL),
836 ('42', '13', '5', '2020-01-21', '1510', '', '-750', '0', '0', NULL, NULL),
837 ('43', '10', '5', '2020-01-21', '4010', '', '-1190.48', '0', '0', NULL, NULL),
838 ('44', '10', '5', '2020-01-21', '1200', '', '1250', '0', '0', '2', '1'),
839 ('45', '10', '5', '2020-01-21', '2150', '', '-59.52', '0', '0', NULL, NULL),
840 ('46', '12', '4', '2020-01-21', '1065', '', '1250', '0', '0', NULL, NULL),
841 ('47', '12', '4', '2020-01-21', '1200', '', '-1250', '0', '0', '2', '1'),
842 ('48', '25', '3', '2020-01-21', '1510', '102', '900', '0', '0', NULL, NULL),
843 ('49', '25', '3', '2020-01-21', '1550', '', '-900', '0', '0', NULL, NULL),
844 ('50', '20', '2', '2020-01-21', '2150', '', '45', '0', '0', NULL, NULL),
845 ('51', '20', '2', '2020-01-21', '2100', '', '-945', '0', '0', '3', '1'),
846 ('52', '20', '2', '2020-01-21', '1550', '', '900', '0', '0', NULL, NULL),
847 ('53', '0', '1', '2019-12-31', '3590', 'Closing Year', '-2163.57', '0', '0', NULL, NULL),
848 ('54', '0', '1', '2019-12-31', '9990', 'Closing Year', '2163.57', '0', '0', NULL, NULL);
850 -- Structure of table `0_grn_batch` --
852 DROP TABLE IF EXISTS `0_grn_batch`;
854 CREATE TABLE `0_grn_batch` (
855 `id` int(11) NOT NULL AUTO_INCREMENT,
856 `supplier_id` int(11) NOT NULL DEFAULT '0',
857 `purch_order_no` int(11) DEFAULT NULL,
858 `reference` varchar(60) NOT NULL DEFAULT '',
859 `delivery_date` date NOT NULL DEFAULT '0000-00-00',
860 `loc_code` varchar(5) DEFAULT NULL,
861 `rate` double DEFAULT '1',
863 KEY `delivery_date` (`delivery_date`),
864 KEY `purch_order_no` (`purch_order_no`)
865 ) ENGINE=InnoDB AUTO_INCREMENT=4 ;
867 -- Data of table `0_grn_batch` --
869 INSERT INTO `0_grn_batch` VALUES
870 ('1', '1', '1', '001/2019', '2019-05-05', 'DEF', '1'),
871 ('2', '1', '2', 'auto', '2019-05-05', 'DEF', '1'),
872 ('3', '1', '3', 'auto', '2020-01-21', 'DEF', '1');
874 -- Structure of table `0_grn_items` --
876 DROP TABLE IF EXISTS `0_grn_items`;
878 CREATE TABLE `0_grn_items` (
879 `id` int(11) NOT NULL AUTO_INCREMENT,
880 `grn_batch_id` int(11) DEFAULT NULL,
881 `po_detail_item` int(11) NOT NULL DEFAULT '0',
882 `item_code` varchar(20) NOT NULL DEFAULT '',
883 `description` tinytext,
884 `qty_recd` double NOT NULL DEFAULT '0',
885 `quantity_inv` double NOT NULL DEFAULT '0',
887 KEY `grn_batch_id` (`grn_batch_id`)
888 ) ENGINE=InnoDB AUTO_INCREMENT=6 ;
890 -- Data of table `0_grn_items` --
892 INSERT INTO `0_grn_items` VALUES
893 ('1', '1', '1', '101', 'iPad Air 2 16GB', '100', '0'),
894 ('2', '1', '2', '102', 'iPhone 6 64GB', '100', '0'),
895 ('3', '1', '3', '103', 'iPhone Cover Case', '100', '0'),
896 ('4', '2', '4', '101', 'iPad Air 2 16GB', '15', '15'),
897 ('5', '3', '5', '102', 'iPhone 6 64GB', '6', '6');
899 -- Structure of table `0_groups` --
901 DROP TABLE IF EXISTS `0_groups`;
903 CREATE TABLE `0_groups` (
904 `id` smallint(6) unsigned NOT NULL AUTO_INCREMENT,
905 `description` varchar(60) NOT NULL DEFAULT '',
906 `inactive` tinyint(1) NOT NULL DEFAULT '0',
908 UNIQUE KEY `description` (`description`)
909 ) ENGINE=InnoDB AUTO_INCREMENT=4 ;
911 -- Data of table `0_groups` --
913 INSERT INTO `0_groups` VALUES
915 ('2', 'Medium', '0'),
918 -- Structure of table `0_item_codes` --
920 DROP TABLE IF EXISTS `0_item_codes`;
922 CREATE TABLE `0_item_codes` (
923 `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
924 `item_code` varchar(20) NOT NULL,
925 `stock_id` varchar(20) NOT NULL,
926 `description` varchar(200) NOT NULL DEFAULT '',
927 `category_id` smallint(6) unsigned NOT NULL,
928 `quantity` double NOT NULL DEFAULT '1',
929 `is_foreign` tinyint(1) NOT NULL DEFAULT '0',
930 `inactive` tinyint(1) NOT NULL DEFAULT '0',
932 UNIQUE KEY `stock_id` (`stock_id`,`item_code`),
933 KEY `item_code` (`item_code`)
934 ) ENGINE=InnoDB AUTO_INCREMENT=9 ;
936 -- Data of table `0_item_codes` --
938 INSERT INTO `0_item_codes` VALUES
939 ('1', '101', '101', 'iPad Air 2 16GB', '1', '1', '0', '0'),
940 ('2', '102', '102', 'iPhone 6 64GB', '1', '1', '0', '0'),
941 ('3', '103', '103', 'iPhone Cover Case', '1', '1', '0', '0'),
942 ('4', '201', '201', 'AP Surf Set', '3', '1', '0', '0'),
943 ('5', '301', '301', 'Support', '4', '1', '0', '0'),
944 ('6', '501', '102', 'iPhone Pack', '1', '1', '0', '0'),
945 ('7', '501', '103', 'iPhone Pack', '1', '1', '0', '0'),
946 ('8', '202', '202', 'Maintenance', '4', '1', '0', '0');
948 -- Structure of table `0_item_tax_type_exemptions` --
950 DROP TABLE IF EXISTS `0_item_tax_type_exemptions`;
952 CREATE TABLE `0_item_tax_type_exemptions` (
953 `item_tax_type_id` int(11) NOT NULL DEFAULT '0',
954 `tax_type_id` int(11) NOT NULL DEFAULT '0',
955 PRIMARY KEY (`item_tax_type_id`,`tax_type_id`)
958 -- Data of table `0_item_tax_type_exemptions` --
960 -- Structure of table `0_item_tax_types` --
962 DROP TABLE IF EXISTS `0_item_tax_types`;
964 CREATE TABLE `0_item_tax_types` (
965 `id` int(11) NOT NULL AUTO_INCREMENT,
966 `name` varchar(60) NOT NULL DEFAULT '',
967 `exempt` tinyint(1) NOT NULL DEFAULT '0',
968 `inactive` tinyint(1) NOT NULL DEFAULT '0',
970 UNIQUE KEY `name` (`name`)
971 ) ENGINE=InnoDB AUTO_INCREMENT=2 ;
973 -- Data of table `0_item_tax_types` --
975 INSERT INTO `0_item_tax_types` VALUES
976 ('1', 'Regular', '0', '0');
978 -- Structure of table `0_item_units` --
980 DROP TABLE IF EXISTS `0_item_units`;
982 CREATE TABLE `0_item_units` (
983 `abbr` varchar(20) NOT NULL,
984 `name` varchar(40) NOT NULL,
985 `decimals` tinyint(2) NOT NULL,
986 `inactive` tinyint(1) NOT NULL DEFAULT '0',
987 PRIMARY KEY (`abbr`),
988 UNIQUE KEY `name` (`name`)
991 -- Data of table `0_item_units` --
993 INSERT INTO `0_item_units` VALUES
994 ('each', 'Each', '0', '0'),
995 ('hr', 'Hours', '0', '0');
997 -- Structure of table `0_journal` --
999 DROP TABLE IF EXISTS `0_journal`;
1001 CREATE TABLE `0_journal` (
1002 `type` smallint(6) NOT NULL DEFAULT '0',
1003 `trans_no` int(11) NOT NULL DEFAULT '0',
1004 `tran_date` date DEFAULT '0000-00-00',
1005 `reference` varchar(60) NOT NULL DEFAULT '',
1006 `source_ref` varchar(60) NOT NULL DEFAULT '',
1007 `event_date` date DEFAULT '0000-00-00',
1008 `doc_date` date NOT NULL DEFAULT '0000-00-00',
1009 `currency` char(3) NOT NULL DEFAULT '',
1010 `amount` double NOT NULL DEFAULT '0',
1011 `rate` double NOT NULL DEFAULT '1',
1012 PRIMARY KEY (`type`,`trans_no`),
1013 KEY `tran_date` (`tran_date`)
1016 -- Data of table `0_journal` --
1018 INSERT INTO `0_journal` VALUES
1019 ('0', '1', '2019-12-31', '001/2012', '', '2019-12-31', '2019-12-31', 'USD', '2163.57', '1');
1021 -- Structure of table `0_loc_stock` --
1023 DROP TABLE IF EXISTS `0_loc_stock`;
1025 CREATE TABLE `0_loc_stock` (
1026 `loc_code` char(5) NOT NULL DEFAULT '',
1027 `stock_id` char(20) NOT NULL DEFAULT '',
1028 `reorder_level` double NOT NULL DEFAULT '0',
1029 PRIMARY KEY (`loc_code`,`stock_id`),
1030 KEY `stock_id` (`stock_id`)
1033 -- Data of table `0_loc_stock` --
1035 INSERT INTO `0_loc_stock` VALUES
1036 ('DEF', '101', '0'),
1037 ('DEF', '102', '0'),
1038 ('DEF', '103', '0'),
1039 ('DEF', '201', '0'),
1040 ('DEF', '202', '0'),
1041 ('DEF', '301', '0');
1043 -- Structure of table `0_locations` --
1045 DROP TABLE IF EXISTS `0_locations`;
1047 CREATE TABLE `0_locations` (
1048 `loc_code` varchar(5) NOT NULL DEFAULT '',
1049 `location_name` varchar(60) NOT NULL DEFAULT '',
1050 `delivery_address` tinytext NOT NULL,
1051 `phone` varchar(30) NOT NULL DEFAULT '',
1052 `phone2` varchar(30) NOT NULL DEFAULT '',
1053 `fax` varchar(30) NOT NULL DEFAULT '',
1054 `email` varchar(100) NOT NULL DEFAULT '',
1055 `contact` varchar(30) NOT NULL DEFAULT '',
1056 `fixed_asset` tinyint(1) NOT NULL DEFAULT '0',
1057 `inactive` tinyint(1) NOT NULL DEFAULT '0',
1058 PRIMARY KEY (`loc_code`)
1061 -- Data of table `0_locations` --
1063 INSERT INTO `0_locations` VALUES
1064 ('DEF', 'Default', 'N/A', '', '', '', '', '', '0', '0');
1066 -- Structure of table `0_payment_terms` --
1068 DROP TABLE IF EXISTS `0_payment_terms`;
1070 CREATE TABLE `0_payment_terms` (
1071 `terms_indicator` int(11) NOT NULL AUTO_INCREMENT,
1072 `terms` char(80) NOT NULL DEFAULT '',
1073 `days_before_due` smallint(6) NOT NULL DEFAULT '0',
1074 `day_in_following_month` smallint(6) NOT NULL DEFAULT '0',
1075 `inactive` tinyint(1) NOT NULL DEFAULT '0',
1076 PRIMARY KEY (`terms_indicator`),
1077 UNIQUE KEY `terms` (`terms`)
1078 ) ENGINE=InnoDB AUTO_INCREMENT=6 ;
1080 -- Data of table `0_payment_terms` --
1082 INSERT INTO `0_payment_terms` VALUES
1083 ('1', 'Due 15th Of the Following Month', '0', '17', '0'),
1084 ('2', 'Due By End Of The Following Month', '0', '30', '0'),
1085 ('3', 'Payment due within 10 days', '10', '0', '0'),
1086 ('4', 'Cash Only', '0', '0', '0'),
1087 ('5', 'Prepaid', '-1', '0', '0');
1089 -- Structure of table `0_prices` --
1091 DROP TABLE IF EXISTS `0_prices`;
1093 CREATE TABLE `0_prices` (
1094 `id` int(11) NOT NULL AUTO_INCREMENT,
1095 `stock_id` varchar(20) NOT NULL DEFAULT '',
1096 `sales_type_id` int(11) NOT NULL DEFAULT '0',
1097 `curr_abrev` char(3) NOT NULL DEFAULT '',
1098 `price` double NOT NULL DEFAULT '0',
1100 UNIQUE KEY `price` (`stock_id`,`sales_type_id`,`curr_abrev`)
1101 ) ENGINE=InnoDB AUTO_INCREMENT=4 ;
1103 -- Data of table `0_prices` --
1105 INSERT INTO `0_prices` VALUES
1106 ('1', '101', '1', 'USD', '300'),
1107 ('2', '102', '1', 'USD', '250'),
1108 ('3', '103', '1', 'USD', '50');
1110 -- Structure of table `0_print_profiles` --
1112 DROP TABLE IF EXISTS `0_print_profiles`;
1114 CREATE TABLE `0_print_profiles` (
1115 `id` smallint(6) unsigned NOT NULL AUTO_INCREMENT,
1116 `profile` varchar(30) NOT NULL,
1117 `report` varchar(5) DEFAULT NULL,
1118 `printer` tinyint(3) unsigned DEFAULT NULL,
1120 UNIQUE KEY `profile` (`profile`,`report`)
1121 ) ENGINE=InnoDB AUTO_INCREMENT=10 ;
1123 -- Data of table `0_print_profiles` --
1125 INSERT INTO `0_print_profiles` VALUES
1126 ('1', 'Out of office', NULL, '0'),
1127 ('2', 'Sales Department', NULL, '0'),
1128 ('3', 'Central', NULL, '2'),
1129 ('4', 'Sales Department', '104', '2'),
1130 ('5', 'Sales Department', '105', '2'),
1131 ('6', 'Sales Department', '107', '2'),
1132 ('7', 'Sales Department', '109', '2'),
1133 ('8', 'Sales Department', '110', '2'),
1134 ('9', 'Sales Department', '201', '2');
1136 -- Structure of table `0_printers` --
1138 DROP TABLE IF EXISTS `0_printers`;
1140 CREATE TABLE `0_printers` (
1141 `id` tinyint(3) unsigned NOT NULL AUTO_INCREMENT,
1142 `name` varchar(20) NOT NULL,
1143 `description` varchar(60) NOT NULL,
1144 `queue` varchar(20) NOT NULL,
1145 `host` varchar(40) NOT NULL,
1146 `port` smallint(11) unsigned NOT NULL,
1147 `timeout` tinyint(3) unsigned NOT NULL,
1149 UNIQUE KEY `name` (`name`)
1150 ) ENGINE=InnoDB AUTO_INCREMENT=4 ;
1152 -- Data of table `0_printers` --
1154 INSERT INTO `0_printers` VALUES
1155 ('1', 'QL500', 'Label printer', 'QL500', 'server', '127', '20'),
1156 ('2', 'Samsung', 'Main network printer', 'scx4521F', 'server', '515', '5'),
1157 ('3', 'Local', 'Local print server at user IP', 'lp', '', '515', '10');
1159 -- Structure of table `0_purch_data` --
1161 DROP TABLE IF EXISTS `0_purch_data`;
1163 CREATE TABLE `0_purch_data` (
1164 `supplier_id` int(11) NOT NULL DEFAULT '0',
1165 `stock_id` char(20) NOT NULL DEFAULT '',
1166 `price` double NOT NULL DEFAULT '0',
1167 `suppliers_uom` char(50) NOT NULL DEFAULT '',
1168 `conversion_factor` double NOT NULL DEFAULT '1',
1169 `supplier_description` char(50) NOT NULL DEFAULT '',
1170 PRIMARY KEY (`supplier_id`,`stock_id`)
1173 -- Data of table `0_purch_data` --
1175 INSERT INTO `0_purch_data` VALUES
1176 ('1', '101', '200', '', '1', 'iPad Air 2 16GB'),
1177 ('1', '102', '150', '', '1', 'iPhone 6 64GB'),
1178 ('1', '103', '10', '', '1', 'iPhone Cover Case');
1180 -- Structure of table `0_purch_order_details` --
1182 DROP TABLE IF EXISTS `0_purch_order_details`;
1184 CREATE TABLE `0_purch_order_details` (
1185 `po_detail_item` int(11) NOT NULL AUTO_INCREMENT,
1186 `order_no` int(11) NOT NULL DEFAULT '0',
1187 `item_code` varchar(20) NOT NULL DEFAULT '',
1188 `description` tinytext,
1189 `delivery_date` date NOT NULL DEFAULT '0000-00-00',
1190 `qty_invoiced` double NOT NULL DEFAULT '0',
1191 `unit_price` double NOT NULL DEFAULT '0',
1192 `act_price` double NOT NULL DEFAULT '0',
1193 `std_cost_unit` double NOT NULL DEFAULT '0',
1194 `quantity_ordered` double NOT NULL DEFAULT '0',
1195 `quantity_received` double NOT NULL DEFAULT '0',
1196 PRIMARY KEY (`po_detail_item`),
1197 KEY `order` (`order_no`,`po_detail_item`),
1198 KEY `itemcode` (`item_code`)
1199 ) ENGINE=InnoDB AUTO_INCREMENT=6 ;
1201 -- Data of table `0_purch_order_details` --
1203 INSERT INTO `0_purch_order_details` VALUES
1204 ('1', '1', '101', 'iPad Air 2 16GB', '2019-05-15', '0', '200', '200', '200', '100', '100'),
1205 ('2', '1', '102', 'iPhone 6 64GB', '2019-05-15', '0', '150', '150', '150', '100', '100'),
1206 ('3', '1', '103', 'iPhone Cover Case', '2019-05-15', '0', '10', '10', '10', '100', '100'),
1207 ('4', '2', '101', 'iPad Air 2 16GB', '2019-05-05', '15', '200', '200', '200', '15', '15'),
1208 ('5', '3', '102', 'iPhone 6 64GB', '2020-01-21', '6', '150', '150', '150', '6', '6');
1210 -- Structure of table `0_purch_orders` --
1212 DROP TABLE IF EXISTS `0_purch_orders`;
1214 CREATE TABLE `0_purch_orders` (
1215 `order_no` int(11) NOT NULL AUTO_INCREMENT,
1216 `supplier_id` int(11) NOT NULL DEFAULT '0',
1217 `comments` tinytext,
1218 `ord_date` date NOT NULL DEFAULT '0000-00-00',
1219 `reference` tinytext NOT NULL,
1220 `requisition_no` tinytext,
1221 `into_stock_location` varchar(5) NOT NULL DEFAULT '',
1222 `delivery_address` tinytext NOT NULL,
1223 `total` double NOT NULL DEFAULT '0',
1224 `prep_amount` double NOT NULL DEFAULT '0',
1225 `alloc` double NOT NULL DEFAULT '0',
1226 `tax_included` tinyint(1) NOT NULL DEFAULT '0',
1227 PRIMARY KEY (`order_no`),
1228 KEY `ord_date` (`ord_date`)
1229 ) ENGINE=InnoDB AUTO_INCREMENT=4 ;
1231 -- Data of table `0_purch_orders` --
1233 INSERT INTO `0_purch_orders` VALUES
1234 ('1', '1', NULL, '2019-05-05', '001/2019', NULL, 'DEF', 'N/A', '37800', '0', '0', '0'),
1235 ('2', '1', NULL, '2019-05-05', 'auto', 'rr4', 'DEF', 'N/A', '3150', '0', '0', '0'),
1236 ('3', '1', NULL, '2020-01-21', 'auto', 'asd5', 'DEF', 'N/A', '945', '0', '0', '0');
1238 -- Structure of table `0_quick_entries` --
1240 DROP TABLE IF EXISTS `0_quick_entries`;
1242 CREATE TABLE `0_quick_entries` (
1243 `id` smallint(6) unsigned NOT NULL AUTO_INCREMENT,
1244 `type` tinyint(1) NOT NULL DEFAULT '0',
1245 `description` varchar(60) NOT NULL,
1246 `usage` varchar(120) DEFAULT NULL,
1247 `base_amount` double NOT NULL DEFAULT '0',
1248 `base_desc` varchar(60) DEFAULT NULL,
1249 `bal_type` tinyint(1) NOT NULL DEFAULT '0',
1251 KEY `description` (`description`)
1252 ) ENGINE=InnoDB AUTO_INCREMENT=4 ;
1254 -- Data of table `0_quick_entries` --
1256 INSERT INTO `0_quick_entries` VALUES
1257 ('1', '1', 'Maintenance', NULL, '0', 'Amount', '0'),
1258 ('2', '4', 'Phone', NULL, '0', 'Amount', '0'),
1259 ('3', '2', 'Cash Sales', 'Retail sales without invoice', '0', 'Amount', '0');
1261 -- Structure of table `0_quick_entry_lines` --
1263 DROP TABLE IF EXISTS `0_quick_entry_lines`;
1265 CREATE TABLE `0_quick_entry_lines` (
1266 `id` smallint(6) unsigned NOT NULL AUTO_INCREMENT,
1267 `qid` smallint(6) unsigned NOT NULL,
1268 `amount` double DEFAULT '0',
1269 `memo` tinytext NOT NULL,
1270 `action` varchar(2) NOT NULL,
1271 `dest_id` varchar(15) NOT NULL DEFAULT '',
1272 `dimension_id` smallint(6) unsigned DEFAULT NULL,
1273 `dimension2_id` smallint(6) unsigned DEFAULT NULL,
1276 ) ENGINE=InnoDB AUTO_INCREMENT=7 ;
1278 -- Data of table `0_quick_entry_lines` --
1280 INSERT INTO `0_quick_entry_lines` VALUES
1281 ('1', '1', '0', '', 't-', '1', '0', '0'),
1282 ('2', '2', '0', '', 't-', '1', '0', '0'),
1283 ('3', '3', '0', '', 't-', '1', '0', '0'),
1284 ('4', '3', '0', '', '=', '4010', '0', '0'),
1285 ('5', '1', '0', '', '=', '5765', '0', '0'),
1286 ('6', '2', '0', '', '=', '5780', '0', '0');
1288 -- Structure of table `0_recurrent_invoices` --
1290 DROP TABLE IF EXISTS `0_recurrent_invoices`;
1292 CREATE TABLE `0_recurrent_invoices` (
1293 `id` smallint(6) unsigned NOT NULL AUTO_INCREMENT,
1294 `description` varchar(60) NOT NULL DEFAULT '',
1295 `order_no` int(11) unsigned NOT NULL,
1296 `debtor_no` int(11) unsigned DEFAULT NULL,
1297 `group_no` smallint(6) unsigned DEFAULT NULL,
1298 `days` int(11) NOT NULL DEFAULT '0',
1299 `monthly` int(11) NOT NULL DEFAULT '0',
1300 `begin` date NOT NULL DEFAULT '0000-00-00',
1301 `end` date NOT NULL DEFAULT '0000-00-00',
1302 `last_sent` date NOT NULL DEFAULT '0000-00-00',
1304 UNIQUE KEY `description` (`description`)
1305 ) ENGINE=InnoDB AUTO_INCREMENT=2 ;
1307 -- Data of table `0_recurrent_invoices` --
1309 INSERT INTO `0_recurrent_invoices` VALUES
1310 ('1', 'Weekly Maintenance', '6', '1', '1', '7', '0', '2019-04-01', '2020-05-07', '2019-04-08');
1312 -- Structure of table `0_reflines` --
1314 DROP TABLE IF EXISTS `0_reflines`;
1316 CREATE TABLE `0_reflines` (
1317 `id` int(11) NOT NULL AUTO_INCREMENT,
1318 `trans_type` int(11) NOT NULL,
1319 `prefix` char(5) NOT NULL DEFAULT '',
1320 `pattern` varchar(35) NOT NULL DEFAULT '1',
1321 `description` varchar(60) NOT NULL DEFAULT '',
1322 `default` tinyint(1) NOT NULL DEFAULT '0',
1323 `inactive` tinyint(1) NOT NULL DEFAULT '0',
1325 UNIQUE KEY `prefix` (`trans_type`,`prefix`)
1326 ) ENGINE=InnoDB AUTO_INCREMENT=23 ;
1328 -- Data of table `0_reflines` --
1330 INSERT INTO `0_reflines` VALUES
1331 ('1', '0', '', '{001}/{YYYY}', '', '1', '0'),
1332 ('2', '1', '', '{001}/{YYYY}', '', '1', '0'),
1333 ('3', '2', '', '{001}/{YYYY}', '', '1', '0'),
1334 ('4', '4', '', '{001}/{YYYY}', '', '1', '0'),
1335 ('5', '10', '', '{001}/{YYYY}', '', '1', '0'),
1336 ('6', '11', '', '{001}/{YYYY}', '', '1', '0'),
1337 ('7', '12', '', '{001}/{YYYY}', '', '1', '0'),
1338 ('8', '13', '', '{001}/{YYYY}', '', '1', '0'),
1339 ('9', '16', '', '{001}/{YYYY}', '', '1', '0'),
1340 ('10', '17', '', '{001}/{YYYY}', '', '1', '0'),
1341 ('11', '18', '', '{001}/{YYYY}', '', '1', '0'),
1342 ('12', '20', '', '{001}/{YYYY}', '', '1', '0'),
1343 ('13', '21', '', '{001}/{YYYY}', '', '1', '0'),
1344 ('14', '22', '', '{001}/{YYYY}', '', '1', '0'),
1345 ('15', '25', '', '{001}/{YYYY}', '', '1', '0'),
1346 ('16', '26', '', '{001}/{YYYY}', '', '1', '0'),
1347 ('17', '28', '', '{001}/{YYYY}', '', '1', '0'),
1348 ('18', '29', '', '{001}/{YYYY}', '', '1', '0'),
1349 ('19', '30', '', '{001}/{YYYY}', '', '1', '0'),
1350 ('20', '32', '', '{001}/{YYYY}', '', '1', '0'),
1351 ('21', '35', '', '{001}/{YYYY}', '', '1', '0'),
1352 ('22', '40', '', '{001}/{YYYY}', '', '1', '0');
1354 -- Structure of table `0_refs` --
1356 DROP TABLE IF EXISTS `0_refs`;
1358 CREATE TABLE `0_refs` (
1359 `id` int(11) NOT NULL DEFAULT '0',
1360 `type` int(11) NOT NULL DEFAULT '0',
1361 `reference` varchar(100) NOT NULL DEFAULT '',
1362 PRIMARY KEY (`id`,`type`),
1363 KEY `Type_and_Reference` (`type`,`reference`)
1366 -- Data of table `0_refs` --
1368 INSERT INTO `0_refs` VALUES
1369 ('1', '1', '001/2019'),
1370 ('1', '10', '001/2019'),
1371 ('5', '10', '001/2020'),
1372 ('2', '10', '002/2019'),
1373 ('3', '10', '003/2019'),
1374 ('4', '10', '004/2019'),
1375 ('1', '12', '001/2019'),
1376 ('4', '12', '001/2020'),
1377 ('2', '12', '002/2019'),
1378 ('3', '12', '003/2019'),
1379 ('1', '18', '001/2019'),
1380 ('1', '20', '001/2019'),
1381 ('2', '20', '001/2020'),
1382 ('1', '25', '001/2019'),
1383 ('1', '26', '001/2019'),
1384 ('2', '26', '002/2019'),
1385 ('3', '26', '003/2019'),
1386 ('3', '30', '001/2019'),
1387 ('4', '30', '002/2019'),
1388 ('6', '30', '003/2019'),
1389 ('1', '40', '001/2019');
1391 -- Structure of table `0_sales_order_details` --
1393 DROP TABLE IF EXISTS `0_sales_order_details`;
1395 CREATE TABLE `0_sales_order_details` (
1396 `id` int(11) NOT NULL AUTO_INCREMENT,
1397 `order_no` int(11) NOT NULL DEFAULT '0',
1398 `trans_type` smallint(6) NOT NULL DEFAULT '30',
1399 `stk_code` varchar(20) NOT NULL DEFAULT '',
1400 `description` tinytext,
1401 `qty_sent` double NOT NULL DEFAULT '0',
1402 `unit_price` double NOT NULL DEFAULT '0',
1403 `quantity` double NOT NULL DEFAULT '0',
1404 `invoiced` double NOT NULL DEFAULT '0',
1405 `discount_percent` double NOT NULL DEFAULT '0',
1407 KEY `sorder` (`trans_type`,`order_no`),
1408 KEY `stkcode` (`stk_code`)
1409 ) ENGINE=InnoDB AUTO_INCREMENT=12 ;
1411 -- Data of table `0_sales_order_details` --
1413 INSERT INTO `0_sales_order_details` VALUES
1414 ('1', '1', '30', '101', 'iPad Air 2 16GB', '20', '300', '20', '0', '0'),
1415 ('2', '1', '30', '301', 'Support', '3', '80', '3', '0', '0'),
1416 ('3', '2', '30', '101', 'iPad Air 2 16GB', '1', '300', '1', '0', '0'),
1417 ('4', '3', '30', '102', 'iPhone 6 64GB', '0', '250', '1', '0', '0'),
1418 ('5', '3', '30', '103', 'iPhone Cover Case', '0', '50', '1', '0', '0'),
1419 ('6', '4', '30', '101', 'iPad Air 2 16GB', '0', '267.14', '1', '0', '0'),
1420 ('7', '5', '30', '102', 'iPhone 6 64GB', '1', '222.62', '1', '0', '0'),
1421 ('8', '5', '30', '103', 'iPhone Cover Case', '1', '44.52', '1', '0', '0'),
1422 ('9', '6', '30', '202', 'Maintenance', '0', '90', '5', '0', '0'),
1423 ('10', '7', '30', '202', 'Maintenance', '5', '0', '5', '0', '0'),
1424 ('11', '8', '30', '102', 'iPhone 6 64GB', '5', '250', '5', '0', '0');
1426 -- Structure of table `0_sales_orders` --
1428 DROP TABLE IF EXISTS `0_sales_orders`;
1430 CREATE TABLE `0_sales_orders` (
1431 `order_no` int(11) NOT NULL,
1432 `trans_type` smallint(6) NOT NULL DEFAULT '30',
1433 `version` tinyint(1) unsigned NOT NULL DEFAULT '0',
1434 `type` tinyint(1) NOT NULL DEFAULT '0',
1435 `debtor_no` int(11) NOT NULL DEFAULT '0',
1436 `branch_code` int(11) NOT NULL DEFAULT '0',
1437 `reference` varchar(100) NOT NULL DEFAULT '',
1438 `customer_ref` tinytext NOT NULL,
1439 `comments` tinytext,
1440 `ord_date` date NOT NULL DEFAULT '0000-00-00',
1441 `order_type` int(11) NOT NULL DEFAULT '0',
1442 `ship_via` int(11) NOT NULL DEFAULT '0',
1443 `delivery_address` tinytext NOT NULL,
1444 `contact_phone` varchar(30) DEFAULT NULL,
1445 `contact_email` varchar(100) DEFAULT NULL,
1446 `deliver_to` tinytext NOT NULL,
1447 `freight_cost` double NOT NULL DEFAULT '0',
1448 `from_stk_loc` varchar(5) NOT NULL DEFAULT '',
1449 `delivery_date` date NOT NULL DEFAULT '0000-00-00',
1450 `payment_terms` int(11) DEFAULT NULL,
1451 `total` double NOT NULL DEFAULT '0',
1452 `prep_amount` double NOT NULL DEFAULT '0',
1453 `alloc` double NOT NULL DEFAULT '0',
1454 PRIMARY KEY (`trans_type`,`order_no`)
1457 -- Data of table `0_sales_orders` --
1459 INSERT INTO `0_sales_orders` VALUES
1460 ('1', '30', '1', '0', '1', '1', 'auto', '', NULL, '2019-05-10', '1', '1', 'N/A', NULL, NULL, 'Donald Easter LLC', '0', 'DEF', '2019-05-05', '4', '6240', '0', '0'),
1461 ('2', '30', '1', '0', '1', '1', 'auto', '', NULL, '2019-05-07', '1', '1', 'N/A', NULL, NULL, 'Donald Easter LLC', '0', 'DEF', '2019-05-07', '4', '300', '0', '0'),
1462 ('3', '30', '0', '0', '1', '1', '001/2019', '', NULL, '2019-05-07', '1', '1', 'N/A', NULL, NULL, 'Donald Easter LLC', '0', 'DEF', '2019-05-08', '4', '300', '0', '0'),
1463 ('4', '30', '0', '0', '2', '2', '002/2019', '', NULL, '2019-05-07', '1', '1', 'N/A', NULL, NULL, 'MoneyMaker Ltd.', '0', 'DEF', '2019-05-08', '1', '267.14', '0', '0'),
1464 ('5', '30', '1', '0', '2', '2', 'auto', '', NULL, '2019-05-07', '1', '1', 'N/A', NULL, NULL, 'MoneyMaker Ltd.', '0', 'DEF', '2019-06-17', '1', '267.14', '0', '0'),
1465 ('6', '30', '0', '1', '1', '1', '003/2019', '', NULL, '2019-05-07', '1', '1', 'N/A', NULL, NULL, 'Donald Easter LLC', '0', 'DEF', '2019-05-08', '4', '450', '0', '0'),
1466 ('7', '30', '1', '0', '1', '1', 'auto', '', 'Recurrent Invoice covers period 04/01/2019 - 04/07/2019.', '2019-05-07', '1', '1', 'N/A', NULL, NULL, 'Donald Easter LLC', '0', 'DEF', '2019-05-07', '4', '0', '0', '0'),
1467 ('8', '30', '1', '0', '1', '1', 'auto', '', NULL, '2020-01-21', '1', '1', 'N/A', NULL, NULL, 'Donald Easter LLC', '0', 'DEF', '2020-01-21', '4', '1250', '0', '0');
1469 -- Structure of table `0_sales_pos` --
1471 DROP TABLE IF EXISTS `0_sales_pos`;
1473 CREATE TABLE `0_sales_pos` (
1474 `id` smallint(6) unsigned NOT NULL AUTO_INCREMENT,
1475 `pos_name` varchar(30) NOT NULL,
1476 `cash_sale` tinyint(1) NOT NULL,
1477 `credit_sale` tinyint(1) NOT NULL,
1478 `pos_location` varchar(5) NOT NULL,
1479 `pos_account` smallint(6) unsigned NOT NULL,
1480 `inactive` tinyint(1) NOT NULL DEFAULT '0',
1482 UNIQUE KEY `pos_name` (`pos_name`)
1483 ) ENGINE=InnoDB AUTO_INCREMENT=2 ;
1485 -- Data of table `0_sales_pos` --
1487 INSERT INTO `0_sales_pos` VALUES
1488 ('1', 'Default', '1', '1', 'DEF', '2', '0');
1490 -- Structure of table `0_sales_types` --
1492 DROP TABLE IF EXISTS `0_sales_types`;
1494 CREATE TABLE `0_sales_types` (
1495 `id` int(11) NOT NULL AUTO_INCREMENT,
1496 `sales_type` char(50) NOT NULL DEFAULT '',
1497 `tax_included` int(1) NOT NULL DEFAULT '0',
1498 `factor` double NOT NULL DEFAULT '1',
1499 `inactive` tinyint(1) NOT NULL DEFAULT '0',
1501 UNIQUE KEY `sales_type` (`sales_type`)
1502 ) ENGINE=InnoDB AUTO_INCREMENT=3 ;
1504 -- Data of table `0_sales_types` --
1506 INSERT INTO `0_sales_types` VALUES
1507 ('1', 'Retail', '1', '1', '0'),
1508 ('2', 'Wholesale', '0', '0.7', '0');
1510 -- Structure of table `0_salesman` --
1512 DROP TABLE IF EXISTS `0_salesman`;
1514 CREATE TABLE `0_salesman` (
1515 `salesman_code` int(11) NOT NULL AUTO_INCREMENT,
1516 `salesman_name` char(60) NOT NULL DEFAULT '',
1517 `salesman_phone` char(30) NOT NULL DEFAULT '',
1518 `salesman_fax` char(30) NOT NULL DEFAULT '',
1519 `salesman_email` varchar(100) NOT NULL DEFAULT '',
1520 `provision` double NOT NULL DEFAULT '0',
1521 `break_pt` double NOT NULL DEFAULT '0',
1522 `provision2` double NOT NULL DEFAULT '0',
1523 `inactive` tinyint(1) NOT NULL DEFAULT '0',
1524 PRIMARY KEY (`salesman_code`),
1525 UNIQUE KEY `salesman_name` (`salesman_name`)
1526 ) ENGINE=InnoDB AUTO_INCREMENT=2 ;
1528 -- Data of table `0_salesman` --
1530 INSERT INTO `0_salesman` VALUES
1531 ('1', 'Sales Person', '', '', '', '5', '1000', '4', '0');
1533 -- Structure of table `0_security_roles` --
1535 DROP TABLE IF EXISTS `0_security_roles`;
1537 CREATE TABLE `0_security_roles` (
1538 `id` int(11) NOT NULL AUTO_INCREMENT,
1539 `role` varchar(30) NOT NULL,
1540 `description` varchar(50) DEFAULT NULL,
1543 `inactive` tinyint(1) NOT NULL DEFAULT '0',
1545 UNIQUE KEY `role` (`role`)
1546 ) ENGINE=InnoDB AUTO_INCREMENT=11 ;
1548 -- Data of table `0_security_roles` --
1550 INSERT INTO `0_security_roles` VALUES
1551 ('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'),
1552 ('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'),
1553 ('3', 'Salesman', 'Salesman', '768;3072;5632;8192;15872', '773;774;3073;3075;3081;5633;8194;15873;775', '0'),
1554 ('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'),
1555 ('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'),
1556 ('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'),
1557 ('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'),
1558 ('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'),
1559 ('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'),
1560 ('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');
1562 -- Structure of table `0_shippers` --
1564 DROP TABLE IF EXISTS `0_shippers`;
1566 CREATE TABLE `0_shippers` (
1567 `shipper_id` int(11) NOT NULL AUTO_INCREMENT,
1568 `shipper_name` varchar(60) NOT NULL DEFAULT '',
1569 `phone` varchar(30) NOT NULL DEFAULT '',
1570 `phone2` varchar(30) NOT NULL DEFAULT '',
1571 `contact` tinytext NOT NULL,
1572 `address` tinytext NOT NULL,
1573 `inactive` tinyint(1) NOT NULL DEFAULT '0',
1574 PRIMARY KEY (`shipper_id`),
1575 UNIQUE KEY `name` (`shipper_name`)
1576 ) ENGINE=InnoDB AUTO_INCREMENT=2 ;
1578 -- Data of table `0_shippers` --
1580 INSERT INTO `0_shippers` VALUES
1581 ('1', 'Default', '', '', '', '', '0');
1583 -- Structure of table `0_sql_trail` --
1585 DROP TABLE IF EXISTS `0_sql_trail`;
1587 CREATE TABLE `0_sql_trail` (
1588 `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
1589 `sql` text NOT NULL,
1590 `result` tinyint(1) NOT NULL,
1591 `msg` varchar(255) NOT NULL,
1595 -- Data of table `0_sql_trail` --
1598 -- Structure of table `0_stock_category` --
1600 DROP TABLE IF EXISTS `0_stock_category`;
1602 CREATE TABLE `0_stock_category` (
1603 `category_id` int(11) NOT NULL AUTO_INCREMENT,
1604 `description` varchar(60) NOT NULL DEFAULT '',
1605 `dflt_tax_type` int(11) NOT NULL DEFAULT '1',
1606 `dflt_units` varchar(20) NOT NULL DEFAULT 'each',
1607 `dflt_mb_flag` char(1) NOT NULL DEFAULT 'B',
1608 `dflt_sales_act` varchar(15) NOT NULL DEFAULT '',
1609 `dflt_cogs_act` varchar(15) NOT NULL DEFAULT '',
1610 `dflt_inventory_act` varchar(15) NOT NULL DEFAULT '',
1611 `dflt_adjustment_act` varchar(15) NOT NULL DEFAULT '',
1612 `dflt_wip_act` varchar(15) NOT NULL DEFAULT '',
1613 `dflt_dim1` int(11) DEFAULT NULL,
1614 `dflt_dim2` int(11) DEFAULT NULL,
1615 `inactive` tinyint(1) NOT NULL DEFAULT '0',
1616 `dflt_no_sale` tinyint(1) NOT NULL DEFAULT '0',
1617 `dflt_no_purchase` tinyint(1) NOT NULL DEFAULT '0',
1618 PRIMARY KEY (`category_id`),
1619 UNIQUE KEY `description` (`description`)
1620 ) ENGINE=InnoDB AUTO_INCREMENT=5 ;
1622 -- Data of table `0_stock_category` --
1624 INSERT INTO `0_stock_category` VALUES
1625 ('1', 'Components', '1', 'each', 'B', '4010', '5010', '1510', '5040', '1530', '0', '0', '0', '0', '0'),
1626 ('2', 'Charges', '1', 'each', 'D', '4010', '5010', '1510', '5040', '1530', '0', '0', '0', '0', '0'),
1627 ('3', 'Systems', '1', 'each', 'M', '4010', '5010', '1510', '5040', '1530', '0', '0', '0', '0', '0'),
1628 ('4', 'Services', '1', 'hr', 'D', '4010', '5010', '1510', '5040', '1530', '0', '0', '0', '0', '0');
1630 -- Structure of table `0_stock_fa_class` --
1632 DROP TABLE IF EXISTS `0_stock_fa_class`;
1634 CREATE TABLE `0_stock_fa_class` (
1635 `fa_class_id` varchar(20) NOT NULL DEFAULT '',
1636 `parent_id` varchar(20) NOT NULL DEFAULT '',
1637 `description` varchar(200) NOT NULL DEFAULT '',
1638 `long_description` tinytext NOT NULL,
1639 `depreciation_rate` double NOT NULL DEFAULT '0',
1640 `inactive` tinyint(1) NOT NULL DEFAULT '0',
1641 PRIMARY KEY (`fa_class_id`)
1644 -- Data of table `0_stock_fa_class` --
1646 -- Structure of table `0_stock_master` --
1648 DROP TABLE IF EXISTS `0_stock_master`;
1650 CREATE TABLE `0_stock_master` (
1651 `stock_id` varchar(20) NOT NULL DEFAULT '',
1652 `category_id` int(11) NOT NULL DEFAULT '0',
1653 `tax_type_id` int(11) NOT NULL DEFAULT '0',
1654 `description` varchar(200) NOT NULL DEFAULT '',
1655 `long_description` tinytext NOT NULL,
1656 `units` varchar(20) NOT NULL DEFAULT 'each',
1657 `mb_flag` char(1) NOT NULL DEFAULT 'B',
1658 `sales_account` varchar(15) NOT NULL DEFAULT '',
1659 `cogs_account` varchar(15) NOT NULL DEFAULT '',
1660 `inventory_account` varchar(15) NOT NULL DEFAULT '',
1661 `adjustment_account` varchar(15) NOT NULL DEFAULT '',
1662 `wip_account` varchar(15) NOT NULL DEFAULT '',
1663 `dimension_id` int(11) DEFAULT NULL,
1664 `dimension2_id` int(11) DEFAULT NULL,
1665 `purchase_cost` double NOT NULL DEFAULT '0',
1666 `material_cost` double NOT NULL DEFAULT '0',
1667 `labour_cost` double NOT NULL DEFAULT '0',
1668 `overhead_cost` double NOT NULL DEFAULT '0',
1669 `inactive` tinyint(1) NOT NULL DEFAULT '0',
1670 `no_sale` tinyint(1) NOT NULL DEFAULT '0',
1671 `no_purchase` tinyint(1) NOT NULL DEFAULT '0',
1672 `editable` tinyint(1) NOT NULL DEFAULT '0',
1673 `depreciation_method` char(1) NOT NULL DEFAULT 'S',
1674 `depreciation_rate` double NOT NULL DEFAULT '0',
1675 `depreciation_factor` double NOT NULL DEFAULT '1',
1676 `depreciation_start` date NOT NULL DEFAULT '0000-00-00',
1677 `depreciation_date` date NOT NULL DEFAULT '0000-00-00',
1678 `fa_class_id` varchar(20) NOT NULL DEFAULT '',
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', ''),
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', ''),
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', ''),
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', ''),
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', ''),
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', '');
1692 -- Structure of table `0_stock_moves` --
1694 DROP TABLE IF EXISTS `0_stock_moves`;
1696 CREATE TABLE `0_stock_moves` (
1697 `trans_id` int(11) NOT NULL AUTO_INCREMENT,
1698 `trans_no` int(11) NOT NULL DEFAULT '0',
1699 `stock_id` char(20) NOT NULL DEFAULT '',
1700 `type` smallint(6) NOT NULL DEFAULT '0',
1701 `loc_code` char(5) NOT NULL DEFAULT '',
1702 `tran_date` date NOT NULL DEFAULT '0000-00-00',
1703 `price` double NOT NULL DEFAULT '0',
1704 `reference` char(40) NOT NULL DEFAULT '',
1705 `qty` double NOT NULL DEFAULT '1',
1706 `standard_cost` double NOT NULL DEFAULT '0',
1707 PRIMARY KEY (`trans_id`),
1708 KEY `type` (`type`,`trans_no`),
1709 KEY `Move` (`stock_id`,`loc_code`,`tran_date`)
1710 ) ENGINE=InnoDB AUTO_INCREMENT=18 ;
1712 -- Data of table `0_stock_moves` --
1714 INSERT INTO `0_stock_moves` VALUES
1715 ('1', '1', '101', '25', 'DEF', '2019-05-05', '200', '', '100', '200'),
1716 ('2', '1', '102', '25', 'DEF', '2019-05-05', '150', '', '100', '150'),
1717 ('3', '1', '103', '25', 'DEF', '2019-05-05', '10', '', '100', '10'),
1718 ('4', '1', '101', '13', 'DEF', '2019-05-10', '300', 'auto', '-20', '200'),
1719 ('5', '1', '301', '13', 'DEF', '2019-05-10', '80', 'auto', '-3', '0'),
1720 ('6', '1', '101', '29', 'DEF', '2019-05-05', '200', '001/2019', '-2', '200'),
1721 ('7', '1', '102', '29', 'DEF', '2019-05-05', '150', '001/2019', '-2', '150'),
1722 ('8', '1', '103', '29', 'DEF', '2019-05-05', '10', '001/2019', '-2', '10'),
1723 ('9', '1', '301', '29', 'DEF', '2019-05-05', '0', '001/2019', '-2', '0'),
1724 ('10', '1', '201', '26', 'DEF', '2019-05-05', '0', '001/2019', '2', '360'),
1725 ('11', '2', '101', '25', 'DEF', '2019-05-05', '200', '', '15', '200'),
1726 ('12', '2', '101', '13', 'DEF', '2019-05-07', '300', 'auto', '-1', '200'),
1727 ('13', '3', '102', '13', 'DEF', '2019-05-07', '222.62', 'auto', '-1', '150'),
1728 ('14', '3', '103', '13', 'DEF', '2019-05-07', '44.52', 'auto', '-1', '10'),
1729 ('15', '4', '202', '13', 'DEF', '2019-05-07', '0', 'auto', '-5', '0'),
1730 ('16', '5', '102', '13', 'DEF', '2020-01-21', '250', 'auto', '-5', '150'),
1731 ('17', '3', '102', '25', 'DEF', '2020-01-21', '150', '', '6', '150');
1733 -- Structure of table `0_supp_allocations` --
1735 DROP TABLE IF EXISTS `0_supp_allocations`;
1737 CREATE TABLE `0_supp_allocations` (
1738 `id` int(11) NOT NULL AUTO_INCREMENT,
1739 `person_id` int(11) DEFAULT NULL,
1740 `amt` double unsigned DEFAULT NULL,
1741 `date_alloc` date NOT NULL DEFAULT '0000-00-00',
1742 `trans_no_from` int(11) DEFAULT NULL,
1743 `trans_type_from` int(11) DEFAULT NULL,
1744 `trans_no_to` int(11) DEFAULT NULL,
1745 `trans_type_to` int(11) DEFAULT NULL,
1747 UNIQUE KEY `trans_type_from` (`person_id`,`trans_type_from`,`trans_no_from`,`trans_type_to`,`trans_no_to`),
1748 KEY `From` (`trans_type_from`,`trans_no_from`),
1749 KEY `To` (`trans_type_to`,`trans_no_to`)
1752 -- Data of table `0_supp_allocations` --
1754 -- Structure of table `0_supp_invoice_items` --
1756 DROP TABLE IF EXISTS `0_supp_invoice_items`;
1758 CREATE TABLE `0_supp_invoice_items` (
1759 `id` int(11) NOT NULL AUTO_INCREMENT,
1760 `supp_trans_no` int(11) DEFAULT NULL,
1761 `supp_trans_type` int(11) DEFAULT NULL,
1762 `gl_code` varchar(15) NOT NULL DEFAULT '',
1763 `grn_item_id` int(11) DEFAULT NULL,
1764 `po_detail_item_id` int(11) DEFAULT NULL,
1765 `stock_id` varchar(20) NOT NULL DEFAULT '',
1766 `description` tinytext,
1767 `quantity` double NOT NULL DEFAULT '0',
1768 `unit_price` double NOT NULL DEFAULT '0',
1769 `unit_tax` double NOT NULL DEFAULT '0',
1771 `dimension_id` int(11) NOT NULL DEFAULT '0',
1772 `dimension2_id` int(11) NOT NULL DEFAULT '0',
1774 KEY `Transaction` (`supp_trans_type`,`supp_trans_no`,`stock_id`)
1775 ) ENGINE=InnoDB AUTO_INCREMENT=3 ;
1777 -- Data of table `0_supp_invoice_items` --
1779 INSERT INTO `0_supp_invoice_items` VALUES
1780 ('1', '1', '20', '0', '4', '4', '101', 'iPad Air 2 16GB', '15', '200', '10', NULL, '0', '0'),
1781 ('2', '2', '20', '0', '5', '5', '102', 'iPhone 6 64GB', '6', '150', '7.5', NULL, '0', '0');
1783 -- Structure of table `0_supp_trans` --
1785 DROP TABLE IF EXISTS `0_supp_trans`;
1787 CREATE TABLE `0_supp_trans` (
1788 `trans_no` int(11) unsigned NOT NULL DEFAULT '0',
1789 `type` smallint(6) unsigned NOT NULL DEFAULT '0',
1790 `supplier_id` int(11) unsigned NOT NULL,
1791 `reference` tinytext NOT NULL,
1792 `supp_reference` varchar(60) NOT NULL DEFAULT '',
1793 `tran_date` date NOT NULL DEFAULT '0000-00-00',
1794 `due_date` date NOT NULL DEFAULT '0000-00-00',
1795 `ov_amount` double NOT NULL DEFAULT '0',
1796 `ov_discount` double NOT NULL DEFAULT '0',
1797 `ov_gst` double NOT NULL DEFAULT '0',
1798 `rate` double NOT NULL DEFAULT '1',
1799 `alloc` double NOT NULL DEFAULT '0',
1800 `tax_included` tinyint(1) NOT NULL DEFAULT '0',
1801 PRIMARY KEY (`type`,`trans_no`,`supplier_id`),
1802 KEY `supplier_id` (`supplier_id`),
1803 KEY `tran_date` (`tran_date`)
1806 -- Data of table `0_supp_trans` --
1808 INSERT INTO `0_supp_trans` VALUES
1809 ('1', '20', '1', '001/2019', 'rr4', '2019-05-05', '2019-05-15', '3000', '0', '150', '1', '0', '0'),
1810 ('2', '20', '1', '001/2020', 'asd5', '2020-01-21', '2020-01-31', '900', '0', '45', '1', '0', '0');
1812 -- Structure of table `0_suppliers` --
1814 DROP TABLE IF EXISTS `0_suppliers`;
1816 CREATE TABLE `0_suppliers` (
1817 `supplier_id` int(11) NOT NULL AUTO_INCREMENT,
1818 `supp_name` varchar(60) NOT NULL DEFAULT '',
1819 `supp_ref` varchar(30) NOT NULL DEFAULT '',
1820 `address` tinytext NOT NULL,
1821 `supp_address` tinytext NOT NULL,
1822 `gst_no` varchar(25) NOT NULL DEFAULT '',
1823 `contact` varchar(60) NOT NULL DEFAULT '',
1824 `supp_account_no` varchar(40) NOT NULL DEFAULT '',
1825 `website` varchar(100) NOT NULL DEFAULT '',
1826 `bank_account` varchar(60) NOT NULL DEFAULT '',
1827 `curr_code` char(3) DEFAULT NULL,
1828 `payment_terms` int(11) DEFAULT NULL,
1829 `tax_included` tinyint(1) NOT NULL DEFAULT '0',
1830 `dimension_id` int(11) DEFAULT '0',
1831 `dimension2_id` int(11) DEFAULT '0',
1832 `tax_group_id` int(11) DEFAULT NULL,
1833 `credit_limit` double NOT NULL DEFAULT '0',
1834 `purchase_account` varchar(15) NOT NULL DEFAULT '',
1835 `payable_account` varchar(15) NOT NULL DEFAULT '',
1836 `payment_discount_account` varchar(15) NOT NULL DEFAULT '',
1837 `notes` tinytext NOT NULL,
1838 `inactive` tinyint(1) NOT NULL DEFAULT '0',
1839 PRIMARY KEY (`supplier_id`),
1840 KEY `supp_ref` (`supp_ref`)
1841 ) ENGINE=InnoDB AUTO_INCREMENT=3 ;
1843 -- Data of table `0_suppliers` --
1845 INSERT INTO `0_suppliers` VALUES
1846 ('1', 'Dino Saurius Inc.', 'Dino Saurius', 'N/A', '', '987654321', '', '', '', '', 'USD', '3', '0', '0', '0', '1', '0', '', '2100', '5060', '', '0'),
1847 ('2', 'Beefeater Ltd.', 'Beefeater', 'N/A', '', '67565590', '', '', '', '', 'GBP', '4', '0', '0', '0', '1', '0', '', '2100', '5060', '', '0');
1849 -- Structure of table `0_sys_prefs` --
1851 DROP TABLE IF EXISTS `0_sys_prefs`;
1853 CREATE TABLE `0_sys_prefs` (
1854 `name` varchar(35) NOT NULL DEFAULT '',
1855 `category` varchar(30) DEFAULT NULL,
1856 `type` varchar(20) NOT NULL DEFAULT '',
1857 `length` smallint(6) DEFAULT NULL,
1858 `value` text NOT NULL,
1859 PRIMARY KEY (`name`),
1860 KEY `category` (`category`)
1863 -- Data of table `0_sys_prefs` --
1865 INSERT INTO `0_sys_prefs` VALUES
1866 ('coy_name', 'setup.company', 'varchar', 60, 'Company name'),
1867 ('gst_no', 'setup.company', 'varchar', 25, ''),
1868 ('coy_no', 'setup.company', 'varchar', 25, ''),
1869 ('tax_prd', 'setup.company', 'int', 11, '1'),
1870 ('tax_last', 'setup.company', 'int', 11, '1'),
1871 ('postal_address', 'setup.company', 'tinytext', 0, 'N/A'),
1872 ('phone', 'setup.company', 'varchar', 30, ''),
1873 ('fax', 'setup.company', 'varchar', 30, ''),
1874 ('email', 'setup.company', 'varchar', 100, ''),
1875 ('coy_logo', 'setup.company', 'varchar', 100, ''),
1876 ('domicile', 'setup.company', 'varchar', 55, ''),
1877 ('curr_default', 'setup.company', 'char', 3, 'USD'),
1878 ('use_dimension', 'setup.company', 'tinyint', 1, '1'),
1879 ('f_year', 'setup.company', 'int', 11, '2'),
1880 ('shortname_name_in_list','setup.company', 'tinyint', 1, '0'),
1881 ('no_item_list', 'setup.company', 'tinyint', 1, '0'),
1882 ('no_customer_list', 'setup.company', 'tinyint', 1, '0'),
1883 ('no_supplier_list', 'setup.company', 'tinyint', 1, '0'),
1884 ('base_sales', 'setup.company', 'int', 11, '1'),
1885 ('time_zone', 'setup.company', 'tinyint', 1, '0'),
1886 ('add_pct', 'setup.company', 'int', 5, '-1'),
1887 ('round_to', 'setup.company', 'int', 5, '1'),
1888 ('login_tout', 'setup.company', 'smallint', 6, '600'),
1889 ('past_due_days', 'glsetup.general', 'int', 11, '30'),
1890 ('profit_loss_year_act', 'glsetup.general', 'varchar', 15, '9990'),
1891 ('retained_earnings_act', 'glsetup.general', 'varchar', 15, '3590'),
1892 ('bank_charge_act', 'glsetup.general', 'varchar', 15, '5690'),
1893 ('exchange_diff_act', 'glsetup.general', 'varchar', 15, '4450'),
1894 ('tax_algorithm', 'glsetup.customer', 'tinyint', 1, '1'),
1895 ('default_credit_limit', 'glsetup.customer', 'int', 11, '1000'),
1896 ('accumulate_shipping', 'glsetup.customer', 'tinyint', 1, '0'),
1897 ('legal_text', 'glsetup.customer', 'tinytext', 0, ''),
1898 ('freight_act', 'glsetup.customer', 'varchar', 15, '4430'),
1899 ('debtors_act', 'glsetup.sales', 'varchar', 15, '1200'),
1900 ('default_sales_act', 'glsetup.sales', 'varchar', 15, '4010'),
1901 ('default_sales_discount_act', 'glsetup.sales', 'varchar', 15, '4510'),
1902 ('default_prompt_payment_act', 'glsetup.sales', 'varchar', 15, '4500'),
1903 ('default_delivery_required', 'glsetup.sales', 'smallint', 6, '1'),
1904 ('default_receival_required', 'glsetup.purchase', 'smallint', 6, '10'),
1905 ('default_quote_valid_days', 'glsetup.sales', 'smallint', 6, '30'),
1906 ('default_dim_required', 'glsetup.dims', 'int', 11, '20'),
1907 ('pyt_discount_act', 'glsetup.purchase', 'varchar', 15, '5060'),
1908 ('creditors_act', 'glsetup.purchase', 'varchar', 15, '2100'),
1909 ('po_over_receive', 'glsetup.purchase', 'int', 11, '10'),
1910 ('po_over_charge', 'glsetup.purchase', 'int', 11, '10'),
1911 ('allow_negative_stock', 'glsetup.inventory', 'tinyint', 1, '0'),
1912 ('default_inventory_act', 'glsetup.items', 'varchar', 15, '1510'),
1913 ('default_cogs_act', 'glsetup.items', 'varchar', 15, '5010'),
1914 ('default_adj_act', 'glsetup.items', 'varchar', 15, '5040'),
1915 ('default_inv_sales_act', 'glsetup.items', 'varchar', 15, '4010'),
1916 ('default_wip_act', 'glsetup.items', 'varchar', 15, '1530'),
1917 ('default_workorder_required', 'glsetup.manuf', 'int', 11, '20'),
1918 ('version_id', 'system', 'varchar', 11, '2.4.1'),
1919 ('auto_curr_reval', 'setup.company', 'smallint', 6, '1'),
1920 ('grn_clearing_act', 'glsetup.purchase', 'varchar', 15, '1550'),
1921 ('bcc_email', 'setup.company', 'varchar', 100, ''),
1922 ('deferred_income_act', 'glsetup.sales', 'varchar', '15', '2105'),
1923 ('gl_closing_date','setup.closing_date', 'date', 8, ''),
1924 ('alternative_tax_include_on_docs','setup.company', 'tinyint', 1, '0'),
1925 ('no_zero_lines_amount','glsetup.sales', 'tinyint', 1, '1'),
1926 ('show_po_item_codes','glsetup.purchase', 'tinyint', 1, '0'),
1927 ('accounts_alpha','glsetup.general', 'tinyint', 1, '0'),
1928 ('loc_notification','glsetup.inventory', 'tinyint', 1, '0'),
1929 ('print_invoice_no','glsetup.sales', 'tinyint', 1, '0'),
1930 ('allow_negative_prices','glsetup.inventory', 'tinyint', 1, '1'),
1931 ('print_item_images_on_quote','glsetup.inventory', 'tinyint', 1, '0'),
1932 ('suppress_tax_rates','setup.company', 'tinyint', 1, '0'),
1933 ('company_logo_report','setup.company', 'tinyint', 1, '0'),
1934 ('barcodes_on_stock','setup.company', 'tinyint', 1, '0'),
1935 ('print_dialog_direct','setup.company', 'tinyint', 1, '0'),
1936 ('ref_no_auto_increase','setup.company', 'tinyint', 1, '0'),
1937 ('default_loss_on_asset_disposal_act', 'glsetup.items', 'varchar', '15', '5660'),
1938 ('depreciation_period', 'glsetup.company', 'tinyint', '1', '1'),
1939 ('use_manufacturing','setup.company', 'tinyint', 1, '1'),
1940 ('dim_on_recurrent_invoice','setup.company', 'tinyint', 1, '0'),
1941 ('long_description_invoice','setup.company', 'tinyint', 1, '0'),
1942 ('use_fixed_assets','setup.company', 'tinyint', 1, '1');
1944 -- Structure of table `0_tag_associations` --
1946 DROP TABLE IF EXISTS `0_tag_associations`;
1948 CREATE TABLE `0_tag_associations` (
1949 `record_id` varchar(15) NOT NULL,
1950 `tag_id` int(11) NOT NULL,
1951 PRIMARY KEY (`record_id`,`tag_id`)
1954 -- Data of table `0_tag_associations` --
1956 -- Structure of table `0_tags` --
1958 DROP TABLE IF EXISTS `0_tags`;
1960 CREATE TABLE `0_tags` (
1961 `id` int(11) NOT NULL AUTO_INCREMENT,
1962 `type` smallint(6) NOT NULL,
1963 `name` varchar(30) NOT NULL,
1964 `description` varchar(60) DEFAULT NULL,
1965 `inactive` tinyint(1) NOT NULL DEFAULT '0',
1967 UNIQUE KEY `type` (`type`,`name`)
1970 -- Data of table `0_tags` --
1972 -- Structure of table `0_tax_group_items` --
1974 DROP TABLE IF EXISTS `0_tax_group_items`;
1976 CREATE TABLE `0_tax_group_items` (
1977 `tax_group_id` int(11) NOT NULL DEFAULT '0',
1978 `tax_type_id` int(11) NOT NULL DEFAULT '0',
1979 `tax_shipping` tinyint(1) NOT NULL DEFAULT '0',
1980 PRIMARY KEY (`tax_group_id`,`tax_type_id`)
1983 -- Data of table `0_tax_group_items` --
1985 INSERT INTO `0_tax_group_items` VALUES
1988 -- Structure of table `0_tax_groups` --
1990 DROP TABLE IF EXISTS `0_tax_groups`;
1992 CREATE TABLE `0_tax_groups` (
1993 `id` int(11) NOT NULL AUTO_INCREMENT,
1994 `name` varchar(60) NOT NULL DEFAULT '',
1995 `inactive` tinyint(1) NOT NULL DEFAULT '0',
1997 UNIQUE KEY `name` (`name`)
1998 ) ENGINE=InnoDB AUTO_INCREMENT=3 ;
2000 -- Data of table `0_tax_groups` --
2002 INSERT INTO `0_tax_groups` VALUES
2004 ('2', 'Tax Exempt', '0');
2006 -- Structure of table `0_tax_types` --
2008 DROP TABLE IF EXISTS `0_tax_types`;
2010 CREATE TABLE `0_tax_types` (
2011 `id` int(11) NOT NULL AUTO_INCREMENT,
2012 `rate` double NOT NULL DEFAULT '0',
2013 `sales_gl_code` varchar(15) NOT NULL DEFAULT '',
2014 `purchasing_gl_code` varchar(15) NOT NULL DEFAULT '',
2015 `name` varchar(60) NOT NULL DEFAULT '',
2016 `inactive` tinyint(1) NOT NULL DEFAULT '0',
2018 ) ENGINE=InnoDB AUTO_INCREMENT=2 ;
2020 -- Data of table `0_tax_types` --
2022 INSERT INTO `0_tax_types` VALUES
2023 ('1', '5', '2150', '2150', 'Tax', '0');
2025 -- Structure of table `0_trans_tax_details` --
2027 DROP TABLE IF EXISTS `0_trans_tax_details`;
2029 CREATE TABLE `0_trans_tax_details` (
2030 `id` int(11) NOT NULL AUTO_INCREMENT,
2031 `trans_type` smallint(6) DEFAULT NULL,
2032 `trans_no` int(11) DEFAULT NULL,
2033 `tran_date` date NOT NULL,
2034 `tax_type_id` int(11) NOT NULL DEFAULT '0',
2035 `rate` double NOT NULL DEFAULT '0',
2036 `ex_rate` double NOT NULL DEFAULT '1',
2037 `included_in_price` tinyint(1) NOT NULL DEFAULT '0',
2038 `net_amount` double NOT NULL DEFAULT '0',
2039 `amount` double NOT NULL DEFAULT '0',
2041 `reg_type` tinyint(1) DEFAULT NULL,
2043 KEY `Type_and_Number` (`trans_type`,`trans_no`),
2044 KEY `tran_date` (`tran_date`)
2045 ) ENGINE=InnoDB AUTO_INCREMENT=11 ;
2047 -- Data of table `0_trans_tax_details` --
2049 INSERT INTO `0_trans_tax_details` VALUES
2050 ('1', '13', '1', '2019-05-10', '1', '5', '1', '1', '5942.86', '297.14', 'auto', NULL),
2051 ('2', '10', '1', '2019-05-10', '1', '5', '1', '1', '5942.86', '297.14', '001/2019', '0'),
2052 ('3', '20', '1', '2019-05-05', '1', '5', '1', '0', '3000', '150', 'rr4', '1'),
2053 ('4', '13', '2', '2019-05-07', '1', '5', '1', '1', '285.71', '14.29', 'auto', NULL),
2054 ('5', '10', '2', '2019-05-07', '1', '5', '1', '1', '285.71', '14.29', '002/2019', '0'),
2055 ('6', '13', '3', '2019-05-07', '0', '0', '1.123', '1', '267.14', '0', 'auto', NULL),
2056 ('7', '10', '3', '2019-05-07', '0', '0', '1.123', '1', '267.14', '0', '003/2019', '0'),
2057 ('8', '13', '5', '2020-01-21', '1', '5', '1', '1', '1190.48', '59.52', 'auto', NULL),
2058 ('9', '10', '5', '2020-01-21', '1', '5', '1', '1', '1190.48', '59.52', '001/2020', '0'),
2059 ('10', '20', '2', '2020-01-21', '1', '5', '1', '0', '900', '45', 'asd5', '1');
2061 -- Structure of table `0_useronline` --
2063 DROP TABLE IF EXISTS `0_useronline`;
2065 CREATE TABLE `0_useronline` (
2066 `id` int(11) NOT NULL AUTO_INCREMENT,
2067 `timestamp` int(15) NOT NULL DEFAULT '0',
2068 `ip` varchar(40) NOT NULL DEFAULT '',
2069 `file` varchar(100) NOT NULL DEFAULT '',
2071 KEY `timestamp` (`timestamp`),
2075 -- Data of table `0_useronline` --
2078 -- Structure of table `0_users` --
2080 DROP TABLE IF EXISTS `0_users`;
2082 CREATE TABLE `0_users` (
2083 `id` smallint(6) NOT NULL AUTO_INCREMENT,
2084 `user_id` varchar(60) NOT NULL DEFAULT '',
2085 `password` varchar(100) NOT NULL DEFAULT '',
2086 `real_name` varchar(100) NOT NULL DEFAULT '',
2087 `role_id` int(11) NOT NULL DEFAULT '1',
2088 `phone` varchar(30) NOT NULL DEFAULT '',
2089 `email` varchar(100) DEFAULT NULL,
2090 `language` varchar(20) DEFAULT NULL,
2091 `date_format` tinyint(1) NOT NULL DEFAULT '0',
2092 `date_sep` tinyint(1) NOT NULL DEFAULT '0',
2093 `tho_sep` tinyint(1) NOT NULL DEFAULT '0',
2094 `dec_sep` tinyint(1) NOT NULL DEFAULT '0',
2095 `theme` varchar(20) NOT NULL DEFAULT 'default',
2096 `page_size` varchar(20) NOT NULL DEFAULT 'A4',
2097 `prices_dec` smallint(6) NOT NULL DEFAULT '2',
2098 `qty_dec` smallint(6) NOT NULL DEFAULT '2',
2099 `rates_dec` smallint(6) NOT NULL DEFAULT '4',
2100 `percent_dec` smallint(6) NOT NULL DEFAULT '1',
2101 `show_gl` tinyint(1) NOT NULL DEFAULT '1',
2102 `show_codes` tinyint(1) NOT NULL DEFAULT '0',
2103 `show_hints` tinyint(1) NOT NULL DEFAULT '0',
2104 `last_visit_date` datetime DEFAULT NULL,
2105 `query_size` tinyint(1) unsigned NOT NULL DEFAULT '10',
2106 `graphic_links` tinyint(1) DEFAULT '1',
2107 `pos` smallint(6) DEFAULT '1',
2108 `print_profile` varchar(30) NOT NULL DEFAULT '',
2109 `rep_popup` tinyint(1) DEFAULT '1',
2110 `sticky_doc_date` tinyint(1) DEFAULT '0',
2111 `startup_tab` varchar(20) NOT NULL DEFAULT '',
2112 `transaction_days` smallint(6) NOT NULL DEFAULT '30',
2113 `save_report_selections` smallint(6) NOT NULL DEFAULT '0',
2114 `use_date_picker` tinyint(1) NOT NULL DEFAULT '1',
2115 `def_print_destination` tinyint(1) NOT NULL DEFAULT '0',
2116 `def_print_orientation` tinyint(1) NOT NULL DEFAULT '0',
2117 `inactive` tinyint(1) NOT NULL DEFAULT '0',
2119 UNIQUE KEY `user_id` (`user_id`)
2120 ) ENGINE=InnoDB AUTO_INCREMENT=2 ;
2122 -- Data of table `0_users` --
2124 INSERT INTO `0_users` VALUES
2125 ('1', 'admin', '5f4dcc3b5aa765d61d8327deb882cf99', 'Administrator', '2', '', 'adm@example.com', 'C', '0', '0', '0', '0', 'default', 'Letter', '2', '2', '4', '1', '1', '0', '0', '2019-05-07 13:58:33', '10', '1', '1', '1', '1', '0', 'orders', '30', '0', '1', '0', '0', '0');
2127 -- Structure of table `0_voided` --
2129 DROP TABLE IF EXISTS `0_voided`;
2131 CREATE TABLE `0_voided` (
2132 `type` int(11) NOT NULL DEFAULT '0',
2133 `id` int(11) NOT NULL DEFAULT '0',
2134 `date_` date NOT NULL DEFAULT '0000-00-00',
2135 `memo_` tinytext NOT NULL,
2136 UNIQUE KEY `id` (`type`,`id`)
2139 -- Data of table `0_voided` --
2142 -- Structure of table `0_wo_costing` --
2144 DROP TABLE IF EXISTS `0_wo_costing`;
2146 CREATE TABLE `0_wo_costing` (
2147 `id` int(11) NOT NULL AUTO_INCREMENT,
2148 `workorder_id` int(11) NOT NULL DEFAULT '0',
2149 `cost_type` tinyint(1) NOT NULL DEFAULT '0',
2150 `trans_type` int(11) NOT NULL DEFAULT '0',
2151 `trans_no` int(11) NOT NULL DEFAULT '0',
2152 `factor` double NOT NULL DEFAULT '1',
2156 -- Data of table `0_wo_costing` --
2158 -- Structure of table `0_wo_issue_items` --
2160 DROP TABLE IF EXISTS `0_wo_issue_items`;
2162 CREATE TABLE `0_wo_issue_items` (
2163 `id` int(11) NOT NULL AUTO_INCREMENT,
2164 `stock_id` varchar(40) DEFAULT NULL,
2165 `issue_id` int(11) DEFAULT NULL,
2166 `qty_issued` double DEFAULT NULL,
2167 `unit_cost` double NOT NULL DEFAULT '0',
2171 -- Data of table `0_wo_issue_items` --
2174 -- Structure of table `0_wo_issues` --
2176 DROP TABLE IF EXISTS `0_wo_issues`;
2178 CREATE TABLE `0_wo_issues` (
2179 `issue_no` int(11) NOT NULL AUTO_INCREMENT,
2180 `workorder_id` int(11) NOT NULL DEFAULT '0',
2181 `reference` varchar(100) DEFAULT NULL,
2182 `issue_date` date DEFAULT NULL,
2183 `loc_code` varchar(5) DEFAULT NULL,
2184 `workcentre_id` int(11) DEFAULT NULL,
2185 PRIMARY KEY (`issue_no`),
2186 KEY `workorder_id` (`workorder_id`)
2189 -- Data of table `0_wo_issues` --
2191 -- Structure of table `0_wo_manufacture` --
2193 DROP TABLE IF EXISTS `0_wo_manufacture`;
2195 CREATE TABLE `0_wo_manufacture` (
2196 `id` int(11) NOT NULL AUTO_INCREMENT,
2197 `reference` varchar(100) DEFAULT NULL,
2198 `workorder_id` int(11) NOT NULL DEFAULT '0',
2199 `quantity` double NOT NULL DEFAULT '0',
2200 `date_` date NOT NULL DEFAULT '0000-00-00',
2202 KEY `workorder_id` (`workorder_id`)
2203 ) ENGINE=InnoDB AUTO_INCREMENT=2 ;
2205 -- Data of table `0_wo_manufacture` --
2207 INSERT INTO `0_wo_manufacture` VALUES
2208 ('1', '001/2019', '1', '2', '2019-05-05');
2210 -- Structure of table `0_wo_requirements` --
2212 DROP TABLE IF EXISTS `0_wo_requirements`;
2214 CREATE TABLE `0_wo_requirements` (
2215 `id` int(11) NOT NULL AUTO_INCREMENT,
2216 `workorder_id` int(11) NOT NULL DEFAULT '0',
2217 `stock_id` char(20) NOT NULL DEFAULT '',
2218 `workcentre` int(11) NOT NULL DEFAULT '0',
2219 `units_req` double NOT NULL DEFAULT '1',
2220 `unit_cost` double NOT NULL DEFAULT '0',
2221 `loc_code` char(5) NOT NULL DEFAULT '',
2222 `units_issued` double NOT NULL DEFAULT '0',
2224 KEY `workorder_id` (`workorder_id`)
2225 ) ENGINE=InnoDB AUTO_INCREMENT=9 ;
2227 -- Data of table `0_wo_requirements` --
2229 INSERT INTO `0_wo_requirements` VALUES
2230 ('1', '1', '101', '1', '1', '200', 'DEF', '2'),
2231 ('2', '1', '102', '1', '1', '150', 'DEF', '2'),
2232 ('3', '1', '103', '1', '1', '10', 'DEF', '2'),
2233 ('4', '1', '301', '1', '1', '0', 'DEF', '2'),
2234 ('5', '2', '101', '1', '1', '200', 'DEF', '0'),
2235 ('6', '2', '102', '1', '1', '150', 'DEF', '0'),
2236 ('7', '2', '103', '1', '1', '10', 'DEF', '0'),
2237 ('8', '2', '301', '1', '1', '0', 'DEF', '0');
2239 -- Structure of table `0_workcentres` --
2241 DROP TABLE IF EXISTS `0_workcentres`;
2243 CREATE TABLE `0_workcentres` (
2244 `id` int(11) NOT NULL AUTO_INCREMENT,
2245 `name` char(40) NOT NULL DEFAULT '',
2246 `description` char(50) NOT NULL DEFAULT '',
2247 `inactive` tinyint(1) NOT NULL DEFAULT '0',
2249 UNIQUE KEY `name` (`name`)
2250 ) ENGINE=InnoDB AUTO_INCREMENT=2 ;
2252 -- Data of table `0_workcentres` --
2254 INSERT INTO `0_workcentres` VALUES
2255 ('1', 'Work Centre', '', '0');
2257 -- Structure of table `0_workorders` --
2259 DROP TABLE IF EXISTS `0_workorders`;
2261 CREATE TABLE `0_workorders` (
2262 `id` int(11) NOT NULL AUTO_INCREMENT,
2263 `wo_ref` varchar(60) NOT NULL DEFAULT '',
2264 `loc_code` varchar(5) NOT NULL DEFAULT '',
2265 `units_reqd` double NOT NULL DEFAULT '1',
2266 `stock_id` varchar(20) NOT NULL DEFAULT '',
2267 `date_` date NOT NULL DEFAULT '0000-00-00',
2268 `type` tinyint(4) NOT NULL DEFAULT '0',
2269 `required_by` date NOT NULL DEFAULT '0000-00-00',
2270 `released_date` date NOT NULL DEFAULT '0000-00-00',
2271 `units_issued` double NOT NULL DEFAULT '0',
2272 `closed` tinyint(1) NOT NULL DEFAULT '0',
2273 `released` tinyint(1) NOT NULL DEFAULT '0',
2274 `additional_costs` double NOT NULL DEFAULT '0',
2276 UNIQUE 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/2019', 'DEF', '2', '201', '2019-05-05', '0', '2019-05-05', '2019-05-05', '2', '1', '1', '0'),
2283 ('2', '002/2019', 'DEF', '5', '201', '2019-05-07', '2', '2019-05-27', '2019-05-07', '0', '0', '1', '0'),
2284 ('3', '003/2019', 'DEF', '5', '201', '2019-05-07', '2', '2019-05-27', '0000-00-00', '0', '0', '0', '0');