1 -- MySQL dump of database 'en_US-demo' on host 'localhost'
2 -- Backup Date and Time: 2019-01-21 11:16
3 -- Built by FrontAccounting 2.5.0
4 -- http://frontaccounting.com
5 -- Company: Training Co.
8 -- Compatibility: 2.5.0
14 -- Structure of table `0_areas` --
16 DROP TABLE IF EXISTS `0_areas`;
18 CREATE TABLE `0_areas` (
19 `area_code` int(11) NOT NULL AUTO_INCREMENT,
20 `description` varchar(60) NOT NULL DEFAULT '',
21 `inactive` tinyint(1) NOT NULL DEFAULT '0',
22 PRIMARY KEY (`area_code`),
23 UNIQUE KEY `description` (`description`)
24 ) ENGINE=InnoDB AUTO_INCREMENT=2 ;
26 -- Data of table `0_areas` --
28 INSERT INTO `0_areas` VALUES
31 -- Structure of table `0_attachments` --
33 DROP TABLE IF EXISTS `0_attachments`;
35 CREATE TABLE `0_attachments` (
36 `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
37 `description` varchar(60) NOT NULL DEFAULT '',
38 `type_no` int(11) NOT NULL DEFAULT '0',
39 `trans_no` int(11) NOT NULL DEFAULT '0',
40 `unique_name` varchar(60) NOT NULL DEFAULT '',
41 `tran_date` date NOT NULL DEFAULT '0000-00-00',
42 `filename` varchar(60) NOT NULL DEFAULT '',
43 `filesize` int(11) NOT NULL DEFAULT '0',
44 `filetype` varchar(60) NOT NULL DEFAULT '',
46 KEY `type_no` (`type_no`,`trans_no`)
49 -- Data of table `0_attachments` --
51 -- Structure of table `0_audit_trail` --
53 DROP TABLE IF EXISTS `0_audit_trail`;
55 CREATE TABLE `0_audit_trail` (
56 `id` int(11) NOT NULL AUTO_INCREMENT,
57 `type` smallint(6) unsigned NOT NULL DEFAULT '0',
58 `trans_no` int(11) unsigned NOT NULL DEFAULT '0',
59 `user` smallint(6) unsigned NOT NULL DEFAULT '0',
60 `stamp` timestamp NOT NULL,
61 `description` varchar(60) DEFAULT NULL,
62 `fiscal_year` int(11) NOT NULL DEFAULT '0',
63 `gl_date` date NOT NULL DEFAULT '0000-00-00',
64 `gl_seq` int(11) unsigned DEFAULT NULL,
66 KEY `Seq` (`fiscal_year`,`gl_date`,`gl_seq`),
67 KEY `Type_and_Number` (`type`,`trans_no`)
68 ) ENGINE=InnoDB AUTO_INCREMENT=37 ;
70 -- Data of table `0_audit_trail` --
72 INSERT INTO `0_audit_trail` VALUES
73 ('1', '18', '1', '1', '2018-05-05 14:08:02', NULL, '1', '2018-05-05', '0'),
74 ('2', '25', '1', '1', '2018-05-05 14:08:14', NULL, '1', '2018-05-05', '1'),
75 ('3', '30', '1', '1', '2018-05-05 14:09:54', NULL, '1', '2018-05-10', '0'),
76 ('4', '13', '1', '1', '2018-05-05 14:09:55', NULL, '1', '2018-05-10', '13'),
77 ('5', '10', '1', '1', '2018-05-05 14:09:55', NULL, '1', '2018-05-10', '14'),
78 ('6', '12', '1', '1', '2018-05-05 14:09:55', NULL, '1', '2018-05-10', '15'),
79 ('7', '29', '1', '1', '2018-05-05 14:18:49', 'Quick production.', '1', '2018-05-05', '2'),
80 ('8', '18', '2', '1', '2018-05-05 14:22:32', NULL, '1', '2018-05-05', '0'),
81 ('9', '25', '2', '1', '2018-05-05 14:22:32', NULL, '1', '2018-05-05', '3'),
82 ('10', '20', '1', '1', '2018-05-05 14:22:32', NULL, '1', '2018-05-05', '4'),
83 ('11', '30', '2', '1', '2018-05-07 07:55:15', NULL, '1', '2018-05-07', '0'),
84 ('12', '13', '2', '1', '2018-05-07 07:55:16', NULL, '1', '2018-05-07', '7'),
85 ('13', '10', '2', '1', '2018-05-07 07:55:16', NULL, '1', '2018-05-07', '8'),
86 ('14', '12', '2', '1', '2018-05-07 07:55:16', NULL, '1', '2018-05-07', '9'),
87 ('15', '30', '3', '1', '2018-05-07 08:08:24', NULL, '1', '2018-05-07', '0'),
88 ('16', '30', '4', '1', '2018-05-07 09:18:44', NULL, '1', '2018-05-07', '0'),
89 ('17', '30', '5', '1', '2018-05-07 11:42:41', NULL, '1', '2018-05-07', '0'),
90 ('18', '13', '3', '1', '2018-05-07 11:42:41', NULL, '1', '2018-05-07', '10'),
91 ('19', '10', '3', '1', '2018-05-07 11:42:41', NULL, '1', '2018-05-07', '11'),
92 ('20', '30', '6', '1', '2018-05-07 14:02:35', NULL, '1', '2018-05-07', '0'),
93 ('21', '30', '7', '1', '2018-05-07 14:05:38', NULL, '1', '2018-05-07', '0'),
94 ('22', '13', '4', '1', '2018-05-07 14:05:38', NULL, '1', '2018-05-07', '0'),
95 ('23', '10', '4', '1', '2018-05-07 14:05:38', NULL, '1', '2018-05-07', '0'),
96 ('24', '12', '3', '1', '2018-05-07 14:05:38', NULL, '1', '2018-05-07', '0'),
97 ('25', '26', '1', '1', '2018-05-07 15:59:34', NULL, '1', '2018-05-07', NULL),
98 ('26', '29', '1', '1', '2018-05-07 15:59:01', 'Production.', '1', '2018-05-07', '5'),
99 ('27', '26', '1', '1', '2018-05-07 15:59:34', 'Released.', '1', '2018-05-07', '6'),
100 ('28', '1', '1', '1', '2018-05-07 16:01:00', NULL, '1', '2018-05-07', '12'),
101 ('29', '30', '8', '1', '2019-01-21 11:13:06', NULL, '2', '2019-01-21', '0'),
102 ('30', '13', '5', '1', '2019-01-21 11:13:06', NULL, '2', '2019-01-21', '0'),
103 ('31', '10', '5', '1', '2019-01-21 11:13:06', NULL, '2', '2019-01-21', '0'),
104 ('32', '12', '4', '1', '2019-01-21 11:13:06', NULL, '2', '2019-01-21', '0'),
105 ('33', '18', '3', '1', '2019-01-21 11:14:14', NULL, '2', '2019-01-21', '0'),
106 ('34', '25', '3', '1', '2019-01-21 11:14:14', NULL, '2', '2019-01-21', '0'),
107 ('35', '20', '2', '1', '2019-01-21 11:14:14', NULL, '2', '2019-01-21', '0'),
108 ('36', '0', '1', '1', '2019-01-21 11:15:35', NULL, '1', '2018-12-31', '16');
110 -- Structure of table `0_bank_accounts` --
112 DROP TABLE IF EXISTS `0_bank_accounts`;
114 CREATE TABLE `0_bank_accounts` (
115 `account_code` varchar(15) NOT NULL DEFAULT '',
116 `account_type` smallint(6) NOT NULL DEFAULT '0',
117 `bank_account_name` varchar(60) NOT NULL DEFAULT '',
118 `bank_account_number` varchar(100) NOT NULL DEFAULT '',
119 `bank_name` varchar(60) NOT NULL DEFAULT '',
120 `bank_address` tinytext,
121 `bank_curr_code` char(3) NOT NULL DEFAULT '',
122 `dflt_curr_act` tinyint(1) NOT NULL DEFAULT '0',
123 `id` smallint(6) NOT NULL AUTO_INCREMENT,
124 `bank_charge_act` varchar(15) NOT NULL DEFAULT '',
125 `last_reconciled_date` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
126 `ending_reconcile_balance` double NOT NULL DEFAULT '0',
127 `inactive` tinyint(1) NOT NULL DEFAULT '0',
129 KEY `bank_account_name` (`bank_account_name`),
130 KEY `bank_account_number` (`bank_account_number`),
131 KEY `account_code` (`account_code`)
132 ) ENGINE=InnoDB AUTO_INCREMENT=3 ;
134 -- Data of table `0_bank_accounts` --
136 INSERT INTO `0_bank_accounts` VALUES
137 ('1060', '0', 'Current account', 'N/A', 'N/A', NULL, 'USD', '1', '1', '5690', '0000-00-00 00:00:00', '0', '0'),
138 ('1065', '3', 'Petty Cash account', 'N/A', 'N/A', NULL, 'USD', '0', '2', '5690', '0000-00-00 00:00:00', '0', '0');
140 -- Structure of table `0_bank_trans` --
142 DROP TABLE IF EXISTS `0_bank_trans`;
144 CREATE TABLE `0_bank_trans` (
145 `id` int(11) NOT NULL AUTO_INCREMENT,
146 `type` smallint(6) DEFAULT NULL,
147 `trans_no` int(11) DEFAULT NULL,
148 `bank_act` varchar(15) NOT NULL DEFAULT '',
149 `ref` varchar(40) DEFAULT NULL,
150 `trans_date` date NOT NULL DEFAULT '0000-00-00',
151 `amount` double DEFAULT NULL,
152 `dimension_id` int(11) NOT NULL DEFAULT '0',
153 `dimension2_id` int(11) NOT NULL DEFAULT '0',
154 `person_type_id` int(11) NOT NULL DEFAULT '0',
155 `person_id` tinyblob,
156 `reconciled` date DEFAULT NULL,
158 KEY `bank_act` (`bank_act`,`ref`),
159 KEY `type` (`type`,`trans_no`),
160 KEY `bank_act_2` (`bank_act`,`reconciled`),
161 KEY `bank_act_3` (`bank_act`,`trans_date`)
162 ) ENGINE=InnoDB AUTO_INCREMENT=6 ;
164 -- Data of table `0_bank_trans` --
166 INSERT INTO `0_bank_trans` VALUES
167 ('1', '12', '1', '2', '001/2018', '2018-05-10', '6240', '0', '0', '2', '1', NULL),
168 ('2', '12', '2', '2', '002/2018', '2018-05-07', '300', '0', '0', '2', '1', NULL),
169 ('3', '12', '3', '2', '003/2018', '2018-05-07', '0', '0', '0', '2', '1', NULL),
170 ('4', '1', '1', '1', '001/2018', '2018-05-07', '-5', '0', '0', '0', 'Goods received', NULL),
171 ('5', '12', '4', '2', '001/2019', '2019-01-21', '1250', '0', '0', '2', '1', NULL);
173 -- Structure of table `0_bom` --
175 DROP TABLE IF EXISTS `0_bom`;
177 CREATE TABLE `0_bom` (
178 `id` int(11) NOT NULL AUTO_INCREMENT,
179 `parent` char(20) NOT NULL DEFAULT '',
180 `component` char(20) NOT NULL DEFAULT '',
181 `workcentre_added` int(11) NOT NULL DEFAULT '0',
182 `loc_code` char(5) NOT NULL DEFAULT '',
183 `quantity` double NOT NULL DEFAULT '1',
184 PRIMARY KEY (`parent`,`component`,`workcentre_added`,`loc_code`),
185 KEY `component` (`component`),
187 KEY `loc_code` (`loc_code`),
188 KEY `parent` (`parent`,`loc_code`),
189 KEY `workcentre_added` (`workcentre_added`)
190 ) ENGINE=InnoDB AUTO_INCREMENT=5 ;
192 -- Data of table `0_bom` --
194 INSERT INTO `0_bom` VALUES
195 ('1', '201', '101', '1', 'DEF', '1'),
196 ('2', '201', '102', '1', 'DEF', '1'),
197 ('3', '201', '103', '1', 'DEF', '1'),
198 ('4', '201', '301', '1', 'DEF', '1');
200 -- Structure of table `0_budget_trans` --
202 DROP TABLE IF EXISTS `0_budget_trans`;
204 CREATE TABLE `0_budget_trans` (
205 `id` int(11) NOT NULL AUTO_INCREMENT,
206 `tran_date` date NOT NULL DEFAULT '0000-00-00',
207 `account` varchar(15) NOT NULL DEFAULT '',
208 `memo_` tinytext NOT NULL,
209 `amount` double NOT NULL DEFAULT '0',
210 `dimension_id` int(11) DEFAULT '0',
211 `dimension2_id` int(11) DEFAULT '0',
213 KEY `Account` (`account`,`tran_date`,`dimension_id`,`dimension2_id`)
216 -- Data of table `0_budget_trans` --
218 -- Structure of table `0_chart_class` --
220 DROP TABLE IF EXISTS `0_chart_class`;
222 CREATE TABLE `0_chart_class` (
223 `cid` varchar(3) NOT NULL,
224 `class_name` varchar(60) NOT NULL DEFAULT '',
225 `ctype` tinyint(1) NOT NULL DEFAULT '0',
226 `inactive` tinyint(1) NOT NULL DEFAULT '0',
230 -- Data of table `0_chart_class` --
232 INSERT INTO `0_chart_class` VALUES
233 ('1', 'Assets', '1', '0'),
234 ('2', 'Liabilities', '2', '0'),
235 ('3', 'Income', '4', '0'),
236 ('4', 'Costs', '6', '0');
238 -- Structure of table `0_chart_master` --
240 DROP TABLE IF EXISTS `0_chart_master`;
242 CREATE TABLE `0_chart_master` (
243 `account_code` varchar(15) NOT NULL DEFAULT '',
244 `account_code2` varchar(15) NOT NULL DEFAULT '',
245 `account_name` varchar(60) NOT NULL DEFAULT '',
246 `account_type` varchar(10) NOT NULL DEFAULT '0',
247 `inactive` tinyint(1) NOT NULL DEFAULT '0',
248 PRIMARY KEY (`account_code`),
249 KEY `account_name` (`account_name`),
250 KEY `accounts_by_type` (`account_type`,`account_code`)
253 -- Data of table `0_chart_master` --
255 INSERT INTO `0_chart_master` VALUES
256 ('1060', '', 'Checking Account', '1', '0'),
257 ('1065', '', 'Petty Cash', '1', '0'),
258 ('1200', '', 'Accounts Receivables', '1', '0'),
259 ('1205', '', 'Allowance for doubtful accounts', '1', '0'),
260 ('1510', '', 'Inventory', '2', '0'),
261 ('1520', '', 'Stocks of Raw Materials', '2', '0'),
262 ('1530', '', 'Stocks of Work In Progress', '2', '0'),
263 ('1540', '', 'Stocks of Finished Goods', '2', '0'),
264 ('1550', '', 'Goods Received Clearing account', '2', '0'),
265 ('1820', '', 'Office Furniture & Equipment', '3', '0'),
266 ('1825', '', 'Accum. Amort. -Furn. & Equip.', '3', '0'),
267 ('1840', '', 'Vehicle', '3', '0'),
268 ('1845', '', 'Accum. Amort. -Vehicle', '3', '0'),
269 ('2100', '', 'Accounts Payable', '4', '0'),
270 ('2105', '', 'Deferred Income', '4', '0'),
271 ('2110', '', 'Accrued Income Tax - Federal', '4', '0'),
272 ('2120', '', 'Accrued Income Tax - State', '4', '0'),
273 ('2130', '', 'Accrued Franchise Tax', '4', '0'),
274 ('2140', '', 'Accrued Real & Personal Prop Tax', '4', '0'),
275 ('2150', '', 'Sales Tax', '4', '0'),
276 ('2160', '', 'Accrued Use Tax Payable', '4', '0'),
277 ('2210', '', 'Accrued Wages', '4', '0'),
278 ('2220', '', 'Accrued Comp Time', '4', '0'),
279 ('2230', '', 'Accrued Holiday Pay', '4', '0'),
280 ('2240', '', 'Accrued Vacation Pay', '4', '0'),
281 ('2310', '', 'Accr. Benefits - 401K', '4', '0'),
282 ('2320', '', 'Accr. Benefits - Stock Purchase', '4', '0'),
283 ('2330', '', 'Accr. Benefits - Med, Den', '4', '0'),
284 ('2340', '', 'Accr. Benefits - Payroll Taxes', '4', '0'),
285 ('2350', '', 'Accr. Benefits - Credit Union', '4', '0'),
286 ('2360', '', 'Accr. Benefits - Savings Bond', '4', '0'),
287 ('2370', '', 'Accr. Benefits - Garnish', '4', '0'),
288 ('2380', '', 'Accr. Benefits - Charity Cont.', '4', '0'),
289 ('2620', '', 'Bank Loans', '5', '0'),
290 ('2680', '', 'Loans from Shareholders', '5', '0'),
291 ('3350', '', 'Common Shares', '6', '0'),
292 ('3590', '', 'Retained Earnings - prior years', '7', '0'),
293 ('4010', '', 'Sales', '8', '0'),
294 ('4430', '', 'Shipping & Handling', '9', '0'),
295 ('4440', '', 'Interest', '9', '0'),
296 ('4450', '', 'Foreign Exchange Gain', '9', '0'),
297 ('4500', '', 'Prompt Payment Discounts', '9', '0'),
298 ('4510', '', 'Discounts Given', '9', '0'),
299 ('5010', '', 'Cost of Goods Sold - Retail', '10', '0'),
300 ('5020', '', 'Material Usage Varaiance', '10', '0'),
301 ('5030', '', 'Consumable Materials', '10', '0'),
302 ('5040', '', 'Purchase price Variance', '10', '0'),
303 ('5050', '', 'Purchases of materials', '10', '0'),
304 ('5060', '', 'Discounts Received', '10', '0'),
305 ('5100', '', 'Freight', '10', '0'),
306 ('5410', '', 'Wages & Salaries', '11', '0'),
307 ('5420', '', 'Wages - Overtime', '11', '0'),
308 ('5430', '', 'Benefits - Comp Time', '11', '0'),
309 ('5440', '', 'Benefits - Payroll Taxes', '11', '0'),
310 ('5450', '', 'Benefits - Workers Comp', '11', '0'),
311 ('5460', '', 'Benefits - Pension', '11', '0'),
312 ('5470', '', 'Benefits - General Benefits', '11', '0'),
313 ('5510', '', 'Inc Tax Exp - Federal', '11', '0'),
314 ('5520', '', 'Inc Tax Exp - State', '11', '0'),
315 ('5530', '', 'Taxes - Real Estate', '11', '0'),
316 ('5540', '', 'Taxes - Personal Property', '11', '0'),
317 ('5550', '', 'Taxes - Franchise', '11', '0'),
318 ('5560', '', 'Taxes - Foreign Withholding', '11', '0'),
319 ('5610', '', 'Accounting & Legal', '12', '0'),
320 ('5615', '', 'Advertising & Promotions', '12', '0'),
321 ('5620', '', 'Bad Debts', '12', '0'),
322 ('5660', '', 'Amortization Expense', '12', '0'),
323 ('5685', '', 'Insurance', '12', '0'),
324 ('5690', '', 'Interest & Bank Charges', '12', '0'),
325 ('5700', '', 'Office Supplies', '12', '0'),
326 ('5760', '', 'Rent', '12', '0'),
327 ('5765', '', 'Repair & Maintenance', '12', '0'),
328 ('5780', '', 'Telephone', '12', '0'),
329 ('5785', '', 'Travel & Entertainment', '12', '0'),
330 ('5790', '', 'Utilities', '12', '0'),
331 ('5795', '', 'Registrations', '12', '0'),
332 ('5800', '', 'Licenses', '12', '0'),
333 ('5810', '', 'Foreign Exchange Loss', '12', '0'),
334 ('9990', '', 'Year Profit/Loss', '12', '0');
336 -- Structure of table `0_chart_types` --
338 DROP TABLE IF EXISTS `0_chart_types`;
340 CREATE TABLE `0_chart_types` (
341 `id` varchar(10) NOT NULL,
342 `name` varchar(60) NOT NULL DEFAULT '',
343 `class_id` varchar(3) NOT NULL DEFAULT '',
344 `parent` varchar(10) NOT NULL DEFAULT '-1',
345 `inactive` tinyint(1) NOT NULL DEFAULT '0',
348 KEY `class_id` (`class_id`)
351 -- Data of table `0_chart_types` --
353 INSERT INTO `0_chart_types` VALUES
354 ('1', 'Current Assets', '1', '', '0'),
355 ('2', 'Inventory Assets', '1', '', '0'),
356 ('3', 'Capital Assets', '1', '', '0'),
357 ('4', 'Current Liabilities', '2', '', '0'),
358 ('5', 'Long Term Liabilities', '2', '', '0'),
359 ('6', 'Share Capital', '2', '', '0'),
360 ('7', 'Retained Earnings', '2', '', '0'),
361 ('8', 'Sales Revenue', '3', '', '0'),
362 ('9', 'Other Revenue', '3', '', '0'),
363 ('10', 'Cost of Goods Sold', '4', '', '0'),
364 ('11', 'Payroll Expenses', '4', '', '0'),
365 ('12', 'General & Administrative expenses', '4', '', '0');
367 -- Structure of table `0_comments` --
369 DROP TABLE IF EXISTS `0_comments`;
371 CREATE TABLE `0_comments` (
372 `type` int(11) NOT NULL DEFAULT '0',
373 `id` int(11) NOT NULL DEFAULT '0',
374 `date_` date DEFAULT '0000-00-00',
376 KEY `type_and_id` (`type`,`id`)
379 -- Data of table `0_comments` --
381 INSERT INTO `0_comments` VALUES
382 ('12', '1', '2018-05-10', 'Cash invoice 1'),
383 ('12', '2', '2018-05-07', 'Cash invoice 2'),
384 ('13', '4', '2018-05-07', 'Recurrent Invoice covers period 04/01/2018 - 04/07/2018.'),
385 ('10', '4', '2018-05-07', 'Recurrent Invoice covers period 04/01/2018 - 04/07/2018.'),
386 ('12', '3', '2018-05-07', 'Cash invoice 4'),
387 ('12', '4', '2019-01-21', 'Default #5'),
388 ('0', '1', '2018-12-31', 'Closing Year');
390 -- Structure of table `0_credit_status` --
392 DROP TABLE IF EXISTS `0_credit_status`;
394 CREATE TABLE `0_credit_status` (
395 `id` int(11) NOT NULL AUTO_INCREMENT,
396 `reason_description` char(100) NOT NULL DEFAULT '',
397 `dissallow_invoices` tinyint(1) NOT NULL DEFAULT '0',
398 `inactive` tinyint(1) NOT NULL DEFAULT '0',
400 UNIQUE KEY `reason_description` (`reason_description`)
401 ) ENGINE=InnoDB AUTO_INCREMENT=5 ;
403 -- Data of table `0_credit_status` --
405 INSERT INTO `0_credit_status` VALUES
406 ('1', 'Good History', '0', '0'),
407 ('3', 'No more work until payment received', '1', '0'),
408 ('4', 'In liquidation', '1', '0');
410 -- Structure of table `0_crm_categories` --
412 DROP TABLE IF EXISTS `0_crm_categories`;
414 CREATE TABLE `0_crm_categories` (
415 `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'pure technical key',
416 `type` varchar(20) NOT NULL COMMENT 'contact type e.g. customer',
417 `action` varchar(20) NOT NULL COMMENT 'detailed usage e.g. department',
418 `name` varchar(30) NOT NULL COMMENT 'for category selector',
419 `description` tinytext NOT NULL COMMENT 'usage description',
420 `system` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'nonzero for core system usage',
421 `inactive` tinyint(1) NOT NULL DEFAULT '0',
423 UNIQUE KEY `type` (`type`,`action`),
424 UNIQUE KEY `type_2` (`type`,`name`)
425 ) ENGINE=InnoDB AUTO_INCREMENT=13 ;
427 -- Data of table `0_crm_categories` --
429 INSERT INTO `0_crm_categories` VALUES
430 ('1', 'cust_branch', 'general', 'General', 'General contact data for customer branch (overrides company setting)', '1', '0'),
431 ('2', 'cust_branch', 'invoice', 'Invoices', 'Invoice posting (overrides company setting)', '1', '0'),
432 ('3', 'cust_branch', 'order', 'Orders', 'Order confirmation (overrides company setting)', '1', '0'),
433 ('4', 'cust_branch', 'delivery', 'Deliveries', 'Delivery coordination (overrides company setting)', '1', '0'),
434 ('5', 'customer', 'general', 'General', 'General contact data for customer', '1', '0'),
435 ('6', 'customer', 'order', 'Orders', 'Order confirmation', '1', '0'),
436 ('7', 'customer', 'delivery', 'Deliveries', 'Delivery coordination', '1', '0'),
437 ('8', 'customer', 'invoice', 'Invoices', 'Invoice posting', '1', '0'),
438 ('9', 'supplier', 'general', 'General', 'General contact data for supplier', '1', '0'),
439 ('10', 'supplier', 'order', 'Orders', 'Order confirmation', '1', '0'),
440 ('11', 'supplier', 'delivery', 'Deliveries', 'Delivery coordination', '1', '0'),
441 ('12', 'supplier', 'invoice', 'Invoices', 'Invoice posting', '1', '0');
443 -- Structure of table `0_crm_contacts` --
445 DROP TABLE IF EXISTS `0_crm_contacts`;
447 CREATE TABLE `0_crm_contacts` (
448 `id` int(11) NOT NULL AUTO_INCREMENT,
449 `person_id` int(11) NOT NULL DEFAULT '0' COMMENT 'foreign key to crm_persons',
450 `type` varchar(20) NOT NULL COMMENT 'foreign key to crm_categories',
451 `action` varchar(20) NOT NULL COMMENT 'foreign key to crm_categories',
452 `entity_id` varchar(11) DEFAULT NULL COMMENT 'entity id in related class table',
454 KEY `type` (`type`,`action`)
455 ) ENGINE=InnoDB AUTO_INCREMENT=11 ;
457 -- Data of table `0_crm_contacts` --
459 INSERT INTO `0_crm_contacts` VALUES
460 ('4', '2', 'supplier', 'general', '2'),
461 ('5', '3', 'cust_branch', 'general', '1'),
462 ('7', '3', 'customer', 'general', '1'),
463 ('8', '1', 'supplier', 'general', '1'),
464 ('9', '4', 'cust_branch', 'general', '2'),
465 ('10', '4', 'customer', 'general', '2');
467 -- Structure of table `0_crm_persons` --
469 DROP TABLE IF EXISTS `0_crm_persons`;
471 CREATE TABLE `0_crm_persons` (
472 `id` int(11) NOT NULL AUTO_INCREMENT,
473 `ref` varchar(30) NOT NULL,
474 `name` varchar(60) NOT NULL,
475 `name2` varchar(60) DEFAULT NULL,
477 `phone` varchar(30) DEFAULT NULL,
478 `phone2` varchar(30) DEFAULT NULL,
479 `fax` varchar(30) DEFAULT NULL,
480 `email` varchar(100) DEFAULT NULL,
481 `lang` char(5) DEFAULT NULL,
482 `notes` tinytext NOT NULL,
483 `inactive` tinyint(1) NOT NULL DEFAULT '0',
486 ) ENGINE=InnoDB AUTO_INCREMENT=5 ;
488 -- Data of table `0_crm_persons` --
490 INSERT INTO `0_crm_persons` VALUES
491 ('1', 'Dino Saurius', 'John Doe', NULL, 'N/A', NULL, NULL, NULL, NULL, NULL, '', '0'),
492 ('2', 'Beefeater', 'Joe Oversea', NULL, 'N/A', NULL, NULL, NULL, NULL, NULL, '', '0'),
493 ('3', 'Donald Easter', 'Donald Easter LLC', NULL, 'N/A', NULL, NULL, NULL, NULL, NULL, '', '0'),
494 ('4', 'MoneyMaker', 'MoneyMaker Ltd.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', '0');
496 -- Structure of table `0_currencies` --
498 DROP TABLE IF EXISTS `0_currencies`;
500 CREATE TABLE `0_currencies` (
501 `currency` varchar(60) NOT NULL DEFAULT '',
502 `curr_abrev` char(3) NOT NULL DEFAULT '',
503 `curr_symbol` varchar(10) NOT NULL DEFAULT '',
504 `country` varchar(100) NOT NULL DEFAULT '',
505 `hundreds_name` varchar(15) NOT NULL DEFAULT '',
506 `auto_update` tinyint(1) NOT NULL DEFAULT '1',
507 `inactive` tinyint(1) NOT NULL DEFAULT '0',
508 PRIMARY KEY (`curr_abrev`)
511 -- Data of table `0_currencies` --
513 INSERT INTO `0_currencies` VALUES
514 ('CA Dollars', 'CAD', '$', 'Canada', 'Cents', '1', '0'),
515 ('Euro', 'EUR', '€', 'Europe', 'Cents', '1', '0'),
516 ('Pounds', 'GBP', '£', 'England', 'Pence', '1', '0'),
517 ('US Dollars', 'USD', '$', 'United States', 'Cents', '1', '0');
519 -- Structure of table `0_cust_allocations` --
521 DROP TABLE IF EXISTS `0_cust_allocations`;
523 CREATE TABLE `0_cust_allocations` (
524 `id` int(11) NOT NULL AUTO_INCREMENT,
525 `person_id` int(11) DEFAULT NULL,
526 `amt` double unsigned DEFAULT NULL,
527 `date_alloc` date NOT NULL DEFAULT '0000-00-00',
528 `trans_no_from` int(11) DEFAULT NULL,
529 `trans_type_from` int(11) DEFAULT NULL,
530 `trans_no_to` int(11) DEFAULT NULL,
531 `trans_type_to` int(11) DEFAULT NULL,
533 UNIQUE KEY `trans_type_from` (`person_id`,`trans_type_from`,`trans_no_from`,`trans_type_to`,`trans_no_to`),
534 KEY `From` (`trans_type_from`,`trans_no_from`),
535 KEY `To` (`trans_type_to`,`trans_no_to`)
536 ) ENGINE=InnoDB AUTO_INCREMENT=5 ;
538 -- Data of table `0_cust_allocations` --
540 INSERT INTO `0_cust_allocations` VALUES
541 ('1', '1', '6240', '2018-05-10', '1', '12', '1', '10'),
542 ('2', '1', '300', '2018-05-07', '2', '12', '2', '10'),
543 ('3', '1', '0', '2018-05-07', '3', '12', '4', '10'),
544 ('4', '1', '1250', '2019-01-21', '4', '12', '5', '10');
546 -- Structure of table `0_cust_branch` --
548 DROP TABLE IF EXISTS `0_cust_branch`;
550 CREATE TABLE `0_cust_branch` (
551 `branch_code` int(11) NOT NULL AUTO_INCREMENT,
552 `debtor_no` int(11) NOT NULL DEFAULT '0',
553 `br_name` varchar(60) NOT NULL DEFAULT '',
554 `branch_ref` varchar(30) NOT NULL DEFAULT '',
555 `br_address` tinytext NOT NULL,
556 `area` int(11) DEFAULT NULL,
557 `salesman` int(11) NOT NULL DEFAULT '0',
558 `default_location` varchar(5) NOT NULL DEFAULT '',
559 `tax_group_id` int(11) DEFAULT NULL,
560 `sales_account` varchar(15) NOT NULL DEFAULT '',
561 `sales_discount_account` varchar(15) NOT NULL DEFAULT '',
562 `receivables_account` varchar(15) NOT NULL DEFAULT '',
563 `payment_discount_account` varchar(15) NOT NULL DEFAULT '',
564 `default_ship_via` 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', '2018-05-10', '2018-05-05', '001/2018', '1', '1', '6240', '0', '0', '0', '0', '6240', '0', '1', '1', '0', '0', '4', '1'),
619 ('2', '10', '0', '1', '1', '2018-05-07', '2018-05-07', '002/2018', '1', '2', '300', '0', '0', '0', '0', '300', '0', '1', '1', '0', '0', '4', '1'),
620 ('3', '10', '0', '2', '2', '2018-05-07', '2018-06-17', '003/2018', '1', '5', '267.14', '0', '0', '0', '0', '0', '0', '1.123', '1', '1', '0', '1', '1'),
621 ('4', '10', '0', '1', '1', '2018-05-07', '2018-05-07', '004/2018', '1', '7', '0', '0', '0', '0', '0', '0', '0', '1', '1', '0', '0', '4', '1'),
622 ('5', '10', '0', '1', '1', '2019-01-21', '2019-01-21', '001/2019', '1', '8', '1250', '0', '0', '0', '0', '1250', '0', '1', '1', '0', '0', '4', '1'),
623 ('1', '12', '0', '1', '1', '2018-05-10', '0000-00-00', '001/2018', '0', '0', '6240', '0', '0', '0', '0', '6240', '0', '1', '0', '0', '0', NULL, '0'),
624 ('2', '12', '0', '1', '1', '2018-05-07', '0000-00-00', '002/2018', '0', '0', '300', '0', '0', '0', '0', '300', '0', '1', '0', '0', '0', NULL, '0'),
625 ('3', '12', '0', '1', '1', '2018-05-07', '0000-00-00', '003/2018', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', NULL, '0'),
626 ('4', '12', '0', '1', '1', '2019-01-21', '0000-00-00', '001/2019', '0', '0', '1250', '0', '0', '0', '0', '1250', '0', '1', '0', '0', '0', NULL, '0'),
627 ('1', '13', '1', '1', '1', '2018-05-10', '2018-05-05', 'auto', '1', '1', '6240', '0', '0', '0', '0', '0', '0', '1', '1', '0', '0', '4', '1'),
628 ('2', '13', '1', '1', '1', '2018-05-07', '2018-05-07', 'auto', '1', '2', '300', '0', '0', '0', '0', '0', '0', '1', '1', '0', '0', '4', '1'),
629 ('3', '13', '1', '2', '2', '2018-05-07', '2018-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', '2018-05-07', '2018-05-07', 'auto', '1', '7', '0', '0', '0', '0', '0', '0', '0', '1', '1', '0', '0', '4', '1'),
631 ('5', '13', '1', '1', '1', '2019-01-21', '2019-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 `unit_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/2018', 'Cost Centre', '1', '0', '2018-05-05', '2018-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', '2018-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', '2018-01-01', '2018-12-31', '1'),
766 ('2', '2019-01-01', '2019-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', '2018-05-05', '1510', '101', '20000', '0', '0', NULL, NULL),
796 ('2', '25', '1', '2018-05-05', '1510', '102', '15000', '0', '0', NULL, NULL),
797 ('3', '25', '1', '2018-05-05', '1510', '103', '1000', '0', '0', NULL, NULL),
798 ('4', '25', '1', '2018-05-05', '1550', '', '-36000', '0', '0', NULL, NULL),
799 ('5', '13', '1', '2018-05-10', '5010', '', '4000', '0', '0', NULL, NULL),
800 ('6', '13', '1', '2018-05-10', '1510', '', '-4000', '0', '0', NULL, NULL),
801 ('7', '10', '1', '2018-05-10', '4010', '', '-5714.29', '0', '0', NULL, NULL),
802 ('8', '10', '1', '2018-05-10', '4010', '', '-228.57', '0', '0', NULL, NULL),
803 ('9', '10', '1', '2018-05-10', '1200', '', '6240', '0', '0', '2', '1'),
804 ('10', '10', '1', '2018-05-10', '2150', '', '-297.14', '0', '0', NULL, NULL),
805 ('11', '12', '1', '2018-05-10', '1065', '', '6240', '0', '0', NULL, NULL),
806 ('12', '12', '1', '2018-05-10', '1200', '', '-6240', '0', '0', '2', '1'),
807 ('13', '29', '1', '2018-05-05', '1510', '1 * iPad Air 2 16GB', '-400', '0', '0', NULL, NULL),
808 ('14', '29', '1', '2018-05-05', '1510', '1 * iPhone 6 64GB', '-300', '0', '0', NULL, NULL),
809 ('15', '29', '1', '2018-05-05', '1510', '1 * iPhone Cover Case', '-20', '0', '0', NULL, NULL),
810 ('16', '29', '1', '2018-05-05', '1530', '1 * Support', '720', '0', '0', NULL, NULL),
811 ('17', '26', '1', '2018-05-05', '1530', '', '-720', '0', '0', NULL, NULL),
812 ('18', '26', '1', '2018-05-05', '1510', '', '720', '0', '0', NULL, NULL),
813 ('19', '25', '2', '2018-05-05', '1510', '101', '3000', '0', '0', NULL, NULL),
814 ('20', '25', '2', '2018-05-05', '1550', '', '-3000', '0', '0', NULL, NULL),
815 ('21', '20', '1', '2018-05-05', '2150', '', '150', '0', '0', NULL, NULL),
816 ('22', '20', '1', '2018-05-05', '2100', '', '-3150', '0', '0', '3', '1'),
817 ('23', '20', '1', '2018-05-05', '1550', '', '3000', '0', '0', NULL, NULL),
818 ('24', '13', '2', '2018-05-07', '5010', '', '200', '0', '0', NULL, NULL),
819 ('25', '13', '2', '2018-05-07', '1510', '', '-200', '0', '0', NULL, NULL),
820 ('26', '10', '2', '2018-05-07', '4010', '', '-285.71', '0', '0', NULL, NULL),
821 ('27', '10', '2', '2018-05-07', '1200', '', '300', '0', '0', '2', '1'),
822 ('28', '10', '2', '2018-05-07', '2150', '', '-14.29', '0', '0', NULL, NULL),
823 ('29', '12', '2', '2018-05-07', '1065', '', '300', '0', '0', NULL, NULL),
824 ('30', '12', '2', '2018-05-07', '1200', '', '-300', '0', '0', '2', '1'),
825 ('31', '13', '3', '2018-05-07', '5010', '', '150', '1', '0', NULL, NULL),
826 ('32', '13', '3', '2018-05-07', '1510', '', '-150', '0', '0', NULL, NULL),
827 ('33', '13', '3', '2018-05-07', '5010', '', '10', '1', '0', NULL, NULL),
828 ('34', '13', '3', '2018-05-07', '1510', '', '-10', '0', '0', NULL, NULL),
829 ('35', '10', '3', '2018-05-07', '4010', '', '-250', '1', '0', NULL, NULL),
830 ('36', '10', '3', '2018-05-07', '4010', '', '-50', '1', '0', NULL, NULL),
831 ('37', '10', '3', '2018-05-07', '1200', '', '300', '0', '0', '2', '2'),
832 ('38', '12', '3', '2018-05-07', '1065', '', '0', '0', '0', NULL, NULL),
833 ('39', '1', '1', '2018-05-07', '5010', '', '5', '1', '0', NULL, NULL),
834 ('40', '1', '1', '2018-05-07', '1060', '', '-5', '0', '0', NULL, NULL),
835 ('41', '13', '5', '2019-01-21', '5010', '', '750', '0', '0', NULL, NULL),
836 ('42', '13', '5', '2019-01-21', '1510', '', '-750', '0', '0', NULL, NULL),
837 ('43', '10', '5', '2019-01-21', '4010', '', '-1190.48', '0', '0', NULL, NULL),
838 ('44', '10', '5', '2019-01-21', '1200', '', '1250', '0', '0', '2', '1'),
839 ('45', '10', '5', '2019-01-21', '2150', '', '-59.52', '0', '0', NULL, NULL),
840 ('46', '12', '4', '2019-01-21', '1065', '', '1250', '0', '0', NULL, NULL),
841 ('47', '12', '4', '2019-01-21', '1200', '', '-1250', '0', '0', '2', '1'),
842 ('48', '25', '3', '2019-01-21', '1510', '102', '900', '0', '0', NULL, NULL),
843 ('49', '25', '3', '2019-01-21', '1550', '', '-900', '0', '0', NULL, NULL),
844 ('50', '20', '2', '2019-01-21', '2150', '', '45', '0', '0', NULL, NULL),
845 ('51', '20', '2', '2019-01-21', '2100', '', '-945', '0', '0', '3', '1'),
846 ('52', '20', '2', '2019-01-21', '1550', '', '900', '0', '0', NULL, NULL),
847 ('53', '0', '1', '2018-12-31', '3590', 'Closing Year', '-2163.57', '0', '0', NULL, NULL),
848 ('54', '0', '1', '2018-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/2018', '2018-05-05', 'DEF', '1'),
871 ('2', '1', '2', 'auto', '2018-05-05', 'DEF', '1'),
872 ('3', '1', '3', 'auto', '2019-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', '2018-12-31', '001/2012', '', '2018-12-31', '2018-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', '2018-05-15', '0', '200', '200', '200', '100', '100'),
1205 ('2', '1', '102', 'iPhone 6 64GB', '2018-05-15', '0', '150', '150', '150', '100', '100'),
1206 ('3', '1', '103', 'iPhone Cover Case', '2018-05-15', '0', '10', '10', '10', '100', '100'),
1207 ('4', '2', '101', 'iPad Air 2 16GB', '2018-05-05', '15', '200', '200', '200', '15', '15'),
1208 ('5', '3', '102', 'iPhone 6 64GB', '2019-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 `supp_reference` 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, '2018-05-05', '001/2018', NULL, 'DEF', 'N/A', '37800', '0', '0', '0'),
1235 ('2', '1', NULL, '2018-05-05', 'auto', 'rr4', 'DEF', 'N/A', '3150', '0', '0', '0'),
1236 ('3', '1', NULL, '2019-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', '2018-04-01', '2020-05-07', '2018-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/2018'),
1370 ('1', '10', '001/2018'),
1371 ('5', '10', '001/2019'),
1372 ('2', '10', '002/2018'),
1373 ('3', '10', '003/2018'),
1374 ('4', '10', '004/2018'),
1375 ('1', '12', '001/2018'),
1376 ('4', '12', '001/2019'),
1377 ('2', '12', '002/2018'),
1378 ('3', '12', '003/2018'),
1379 ('1', '18', '001/2018'),
1380 ('1', '20', '001/2018'),
1381 ('2', '20', '001/2019'),
1382 ('1', '25', '001/2018'),
1383 ('1', '26', '001/2018'),
1384 ('2', '26', '002/2018'),
1385 ('3', '26', '003/2018'),
1386 ('3', '30', '001/2018'),
1387 ('4', '30', '002/2018'),
1388 ('6', '30', '003/2018'),
1389 ('1', '40', '001/2018');
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, '2018-05-10', '1', '1', 'N/A', NULL, NULL, 'Donald Easter LLC', '0', 'DEF', '2018-05-05', '4', '6240', '0', '0'),
1461 ('2', '30', '1', '0', '1', '1', 'auto', '', NULL, '2018-05-07', '1', '1', 'N/A', NULL, NULL, 'Donald Easter LLC', '0', 'DEF', '2018-05-07', '4', '300', '0', '0'),
1462 ('3', '30', '0', '0', '1', '1', '001/2018', '', NULL, '2018-05-07', '1', '1', 'N/A', NULL, NULL, 'Donald Easter LLC', '0', 'DEF', '2018-05-08', '4', '300', '0', '0'),
1463 ('4', '30', '0', '0', '2', '2', '002/2018', '', NULL, '2018-05-07', '1', '1', 'N/A', NULL, NULL, 'MoneyMaker Ltd.', '0', 'DEF', '2018-05-08', '1', '267.14', '0', '0'),
1464 ('5', '30', '1', '0', '2', '2', 'auto', '', NULL, '2018-05-07', '1', '1', 'N/A', NULL, NULL, 'MoneyMaker Ltd.', '0', 'DEF', '2018-06-17', '1', '267.14', '0', '0'),
1465 ('6', '30', '0', '1', '1', '1', '003/2018', '', NULL, '2018-05-07', '1', '1', 'N/A', NULL, NULL, 'Donald Easter LLC', '0', 'DEF', '2018-05-08', '4', '450', '0', '0'),
1466 ('7', '30', '1', '0', '1', '1', 'auto', '', 'Recurrent Invoice covers period 04/01/2018 - 04/07/2018.', '2018-05-07', '1', '1', 'N/A', NULL, NULL, 'Donald Easter LLC', '0', 'DEF', '2018-05-07', '4', '0', '0', '0'),
1467 ('8', '30', '1', '0', '1', '1', 'auto', '', NULL, '2019-01-21', '1', '1', 'N/A', NULL, NULL, 'Donald Easter LLC', '0', 'DEF', '2019-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 `vat_category` tinyint(1) NOT NULL DEFAULT '0',
1619 PRIMARY KEY (`category_id`),
1620 UNIQUE KEY `description` (`description`)
1621 ) ENGINE=InnoDB AUTO_INCREMENT=5 ;
1623 -- Data of table `0_stock_category` --
1625 INSERT INTO `0_stock_category` VALUES
1626 ('1', 'Components', '1', 'each', 'B', '4010', '5010', '1510', '5040', '1530', '0', '0', '0', '0', '0', '0'),
1627 ('2', 'Charges', '1', 'each', 'D', '4010', '5010', '1510', '5040', '1530', '0', '0', '0', '0', '0', '0'),
1628 ('3', 'Systems', '1', 'each', 'M', '4010', '5010', '1510', '5040', '1530', '0', '0', '0', '0', '0', '0'),
1629 ('4', 'Services', '1', 'hr', 'D', '4010', '5010', '1510', '5040', '1530', '0', '0', '0', '0', '0', '0');
1631 -- Structure of table `0_stock_fa_class` --
1633 DROP TABLE IF EXISTS `0_stock_fa_class`;
1635 CREATE TABLE `0_stock_fa_class` (
1636 `fa_class_id` varchar(20) NOT NULL DEFAULT '',
1637 `parent_id` varchar(20) NOT NULL DEFAULT '',
1638 `description` varchar(200) NOT NULL DEFAULT '',
1639 `long_description` tinytext NOT NULL,
1640 `depreciation_rate` double NOT NULL DEFAULT '0',
1641 `inactive` tinyint(1) NOT NULL DEFAULT '0',
1642 PRIMARY KEY (`fa_class_id`)
1645 -- Data of table `0_stock_fa_class` --
1647 -- Structure of table `0_stock_master` --
1649 DROP TABLE IF EXISTS `0_stock_master`;
1651 CREATE TABLE `0_stock_master` (
1652 `stock_id` varchar(20) NOT NULL DEFAULT '',
1653 `category_id` int(11) NOT NULL DEFAULT '0',
1654 `tax_type_id` int(11) NOT NULL DEFAULT '0',
1655 `description` varchar(200) NOT NULL DEFAULT '',
1656 `long_description` tinytext NOT NULL,
1657 `units` varchar(20) NOT NULL DEFAULT 'each',
1658 `mb_flag` char(1) NOT NULL DEFAULT 'B',
1659 `sales_account` varchar(15) NOT NULL DEFAULT '',
1660 `cogs_account` varchar(15) NOT NULL DEFAULT '',
1661 `inventory_account` varchar(15) NOT NULL DEFAULT '',
1662 `adjustment_account` varchar(15) NOT NULL DEFAULT '',
1663 `wip_account` varchar(15) NOT NULL DEFAULT '',
1664 `dimension_id` int(11) DEFAULT NULL,
1665 `dimension2_id` int(11) DEFAULT NULL,
1666 `purchase_cost` double NOT NULL DEFAULT '0',
1667 `material_cost` double NOT NULL DEFAULT '0',
1668 `labour_cost` double NOT NULL DEFAULT '0',
1669 `overhead_cost` double NOT NULL DEFAULT '0',
1670 `inactive` tinyint(1) NOT NULL DEFAULT '0',
1671 `no_sale` tinyint(1) NOT NULL DEFAULT '0',
1672 `no_purchase` tinyint(1) NOT NULL DEFAULT '0',
1673 `editable` tinyint(1) NOT NULL DEFAULT '0',
1674 `depreciation_method` char(1) NOT NULL DEFAULT 'S',
1675 `depreciation_rate` double NOT NULL DEFAULT '0',
1676 `depreciation_factor` double NOT NULL DEFAULT '1',
1677 `depreciation_start` date NOT NULL DEFAULT '0000-00-00',
1678 `depreciation_date` date NOT NULL DEFAULT '0000-00-00',
1679 `fa_class_id` varchar(20) NOT NULL DEFAULT '',
1680 `vat_category` tinyint(1) NOT NULL DEFAULT '0',
1681 PRIMARY KEY (`stock_id`)
1684 -- Data of table `0_stock_master` --
1686 INSERT INTO `0_stock_master` VALUES
1687 ('101', '1', '1', 'iPad Air 2 16GB', '', 'each', 'B', '4010', '5010', '1510', '5040', '1530', '0', '0', '0', '200', '0', '0', '0', '0', '0', '0', 'S', '0', '1', '0000-00-00', '0000-00-00', '', '0'),
1688 ('102', '1', '1', 'iPhone 6 64GB', '', 'each', 'B', '4010', '5010', '1510', '5040', '1530', '0', '0', '150', '150', '0', '0', '0', '0', '0', '0', 'S', '0', '1', '0000-00-00', '0000-00-00', '', '0'),
1689 ('103', '1', '1', 'iPhone Cover Case', '', 'each', 'B', '4010', '5010', '1510', '5040', '1530', '0', '0', '0', '10', '0', '0', '0', '0', '0', '0', 'S', '0', '1', '0000-00-00', '0000-00-00', '', '0'),
1690 ('201', '3', '1', 'AP Surf Set', '', 'each', 'M', '4010', '5010', '1510', '5040', '1530', '0', '0', '0', '360', '0', '0', '0', '0', '0', '0', 'S', '0', '1', '0000-00-00', '0000-00-00', '', '0'),
1691 ('202', '4', '1', 'Maintenance', '', 'hr', 'D', '4010', '5010', '1510', '5040', '1530', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', 'S', '0', '1', '0000-00-00', '0000-00-00', '', '0'),
1692 ('301', '4', '1', 'Support', '', 'hr', 'D', '4010', '5010', '1510', '5040', '1530', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', 'S', '0', '1', '0000-00-00', '0000-00-00', '', '0');
1694 -- Structure of table `0_stock_moves` --
1696 DROP TABLE IF EXISTS `0_stock_moves`;
1698 CREATE TABLE `0_stock_moves` (
1699 `trans_id` int(11) NOT NULL AUTO_INCREMENT,
1700 `trans_no` int(11) NOT NULL DEFAULT '0',
1701 `stock_id` char(20) NOT NULL DEFAULT '',
1702 `type` smallint(6) NOT NULL DEFAULT '0',
1703 `loc_code` char(5) NOT NULL DEFAULT '',
1704 `tran_date` date NOT NULL DEFAULT '0000-00-00',
1705 `price` double NOT NULL DEFAULT '0',
1706 `reference` char(40) NOT NULL DEFAULT '',
1707 `qty` double NOT NULL DEFAULT '1',
1708 `unit_cost` double NOT NULL DEFAULT '0',
1709 PRIMARY KEY (`trans_id`),
1710 KEY `type` (`type`,`trans_no`),
1711 KEY `Move` (`stock_id`,`loc_code`,`tran_date`)
1712 ) ENGINE=InnoDB AUTO_INCREMENT=18 ;
1714 -- Data of table `0_stock_moves` --
1716 INSERT INTO `0_stock_moves` VALUES
1717 ('1', '1', '101', '25', 'DEF', '2018-05-05', '200', '', '100', '200'),
1718 ('2', '1', '102', '25', 'DEF', '2018-05-05', '150', '', '100', '150'),
1719 ('3', '1', '103', '25', 'DEF', '2018-05-05', '10', '', '100', '10'),
1720 ('4', '1', '101', '13', 'DEF', '2018-05-10', '300', 'auto', '-20', '200'),
1721 ('5', '1', '301', '13', 'DEF', '2018-05-10', '80', 'auto', '-3', '0'),
1722 ('6', '1', '101', '29', 'DEF', '2018-05-05', '200', '001/2018', '-2', '200'),
1723 ('7', '1', '102', '29', 'DEF', '2018-05-05', '150', '001/2018', '-2', '150'),
1724 ('8', '1', '103', '29', 'DEF', '2018-05-05', '10', '001/2018', '-2', '10'),
1725 ('9', '1', '301', '29', 'DEF', '2018-05-05', '0', '001/2018', '-2', '0'),
1726 ('10', '1', '201', '26', 'DEF', '2018-05-05', '0', '001/2018', '2', '360'),
1727 ('11', '2', '101', '25', 'DEF', '2018-05-05', '200', '', '15', '200'),
1728 ('12', '2', '101', '13', 'DEF', '2018-05-07', '300', 'auto', '-1', '200'),
1729 ('13', '3', '102', '13', 'DEF', '2018-05-07', '222.62', 'auto', '-1', '150'),
1730 ('14', '3', '103', '13', 'DEF', '2018-05-07', '44.52', 'auto', '-1', '10'),
1731 ('15', '4', '202', '13', 'DEF', '2018-05-07', '0', 'auto', '-5', '0'),
1732 ('16', '5', '102', '13', 'DEF', '2019-01-21', '250', 'auto', '-5', '150'),
1733 ('17', '3', '102', '25', 'DEF', '2019-01-21', '150', '', '6', '150');
1735 -- Structure of table `0_supp_allocations` --
1737 DROP TABLE IF EXISTS `0_supp_allocations`;
1739 CREATE TABLE `0_supp_allocations` (
1740 `id` int(11) NOT NULL AUTO_INCREMENT,
1741 `person_id` int(11) DEFAULT NULL,
1742 `amt` double unsigned DEFAULT NULL,
1743 `date_alloc` date NOT NULL DEFAULT '0000-00-00',
1744 `trans_no_from` int(11) DEFAULT NULL,
1745 `trans_type_from` int(11) DEFAULT NULL,
1746 `trans_no_to` int(11) DEFAULT NULL,
1747 `trans_type_to` int(11) DEFAULT NULL,
1749 UNIQUE KEY `trans_type_from` (`person_id`,`trans_type_from`,`trans_no_from`,`trans_type_to`,`trans_no_to`),
1750 KEY `From` (`trans_type_from`,`trans_no_from`),
1751 KEY `To` (`trans_type_to`,`trans_no_to`)
1754 -- Data of table `0_supp_allocations` --
1756 -- Structure of table `0_supp_invoice_items` --
1758 DROP TABLE IF EXISTS `0_supp_invoice_items`;
1760 CREATE TABLE `0_supp_invoice_items` (
1761 `id` int(11) NOT NULL AUTO_INCREMENT,
1762 `supp_trans_no` int(11) DEFAULT NULL,
1763 `supp_trans_type` int(11) DEFAULT NULL,
1764 `gl_code` varchar(15) NOT NULL DEFAULT '',
1765 `grn_item_id` int(11) DEFAULT NULL,
1766 `po_detail_item_id` int(11) DEFAULT NULL,
1767 `stock_id` varchar(20) NOT NULL DEFAULT '',
1768 `description` tinytext,
1769 `quantity` double NOT NULL DEFAULT '0',
1770 `unit_price` double NOT NULL DEFAULT '0',
1771 `unit_tax` double NOT NULL DEFAULT '0',
1773 `dimension_id` int(11) NOT NULL DEFAULT '0',
1774 `dimension2_id` int(11) NOT NULL DEFAULT '0',
1776 KEY `Transaction` (`supp_trans_type`,`supp_trans_no`,`stock_id`)
1777 ) ENGINE=InnoDB AUTO_INCREMENT=3 ;
1779 -- Data of table `0_supp_invoice_items` --
1781 INSERT INTO `0_supp_invoice_items` VALUES
1782 ('1', '1', '20', '0', '4', '4', '101', 'iPad Air 2 16GB', '15', '200', '10', NULL, '0', '0'),
1783 ('2', '2', '20', '0', '5', '5', '102', 'iPhone 6 64GB', '6', '150', '7.5', NULL, '0', '0');
1785 -- Structure of table `0_supp_trans` --
1787 DROP TABLE IF EXISTS `0_supp_trans`;
1789 CREATE TABLE `0_supp_trans` (
1790 `trans_no` int(11) unsigned NOT NULL DEFAULT '0',
1791 `type` smallint(6) unsigned NOT NULL DEFAULT '0',
1792 `supplier_id` int(11) unsigned NOT NULL,
1793 `reference` tinytext NOT NULL,
1794 `supp_reference` varchar(60) NOT NULL DEFAULT '',
1795 `tran_date` date NOT NULL DEFAULT '0000-00-00',
1796 `due_date` date NOT NULL DEFAULT '0000-00-00',
1797 `ov_amount` double NOT NULL DEFAULT '0',
1798 `ov_discount` double NOT NULL DEFAULT '0',
1799 `ov_gst` double NOT NULL DEFAULT '0',
1800 `rate` double NOT NULL DEFAULT '1',
1801 `alloc` double NOT NULL DEFAULT '0',
1802 `tax_included` tinyint(1) NOT NULL DEFAULT '0',
1803 PRIMARY KEY (`type`,`trans_no`,`supplier_id`),
1804 KEY `supplier_id` (`supplier_id`),
1805 KEY `tran_date` (`tran_date`)
1808 -- Data of table `0_supp_trans` --
1810 INSERT INTO `0_supp_trans` VALUES
1811 ('1', '20', '1', '001/2018', 'rr4', '2018-05-05', '2018-05-15', '3000', '0', '150', '1', '0', '0'),
1812 ('2', '20', '1', '001/2019', 'asd5', '2019-01-21', '2019-01-31', '900', '0', '45', '1', '0', '0');
1814 -- Structure of table `0_suppliers` --
1816 DROP TABLE IF EXISTS `0_suppliers`;
1818 CREATE TABLE `0_suppliers` (
1819 `supplier_id` int(11) NOT NULL AUTO_INCREMENT,
1820 `supp_name` varchar(60) NOT NULL DEFAULT '',
1821 `supp_ref` varchar(30) NOT NULL DEFAULT '',
1822 `address` tinytext NOT NULL,
1823 `supp_address` tinytext NOT NULL,
1824 `gst_no` varchar(25) NOT NULL DEFAULT '',
1825 `contact` varchar(60) NOT NULL DEFAULT '',
1826 `supp_account_no` varchar(40) NOT NULL DEFAULT '',
1827 `website` varchar(100) NOT NULL DEFAULT '',
1828 `bank_account` varchar(60) NOT NULL DEFAULT '',
1829 `curr_code` char(3) DEFAULT NULL,
1830 `payment_terms` int(11) DEFAULT NULL,
1831 `tax_included` tinyint(1) NOT NULL DEFAULT '0',
1832 `dimension_id` int(11) DEFAULT '0',
1833 `dimension2_id` int(11) DEFAULT '0',
1834 `tax_group_id` int(11) DEFAULT NULL,
1835 `credit_limit` double NOT NULL DEFAULT '0',
1836 `purchase_account` varchar(15) NOT NULL DEFAULT '',
1837 `payable_account` varchar(15) NOT NULL DEFAULT '',
1838 `payment_discount_account` varchar(15) NOT NULL DEFAULT '',
1839 `notes` tinytext NOT NULL,
1840 `inactive` tinyint(1) NOT NULL DEFAULT '0',
1841 PRIMARY KEY (`supplier_id`),
1842 KEY `supp_ref` (`supp_ref`)
1843 ) ENGINE=InnoDB AUTO_INCREMENT=3 ;
1845 -- Data of table `0_suppliers` --
1847 INSERT INTO `0_suppliers` VALUES
1848 ('1', 'Dino Saurius Inc.', 'Dino Saurius', 'N/A', '', '987654321', '', '', '', '', 'USD', '3', '0', '0', '0', '1', '0', '', '2100', '5060', '', '0'),
1849 ('2', 'Beefeater Ltd.', 'Beefeater', 'N/A', '', '67565590', '', '', '', '', 'GBP', '4', '0', '0', '0', '1', '0', '', '2100', '5060', '', '0');
1851 -- Structure of table `0_sys_prefs` --
1853 DROP TABLE IF EXISTS `0_sys_prefs`;
1855 CREATE TABLE `0_sys_prefs` (
1856 `name` varchar(35) NOT NULL DEFAULT '',
1857 `category` varchar(30) DEFAULT NULL,
1858 `type` varchar(20) NOT NULL DEFAULT '',
1859 `length` smallint(6) DEFAULT NULL,
1860 `value` text NOT NULL,
1861 PRIMARY KEY (`name`),
1862 KEY `category` (`category`)
1865 -- Data of table `0_sys_prefs` --
1867 INSERT INTO `0_sys_prefs` VALUES
1868 ('coy_name', 'setup.company', 'varchar', 60, 'Company name'),
1869 ('gst_no', 'setup.company', 'varchar', 25, ''),
1870 ('coy_no', 'setup.company', 'varchar', 25, ''),
1871 ('tax_prd', 'setup.company', 'int', 11, '1'),
1872 ('tax_last', 'setup.company', 'int', 11, '1'),
1873 ('postal_address', 'setup.company', 'tinytext', 0, 'N/A'),
1874 ('phone', 'setup.company', 'varchar', 30, ''),
1875 ('fax', 'setup.company', 'varchar', 30, ''),
1876 ('email', 'setup.company', 'varchar', 100, ''),
1877 ('coy_logo', 'setup.company', 'varchar', 100, ''),
1878 ('domicile', 'setup.company', 'varchar', 55, ''),
1879 ('curr_default', 'setup.company', 'char', 3, 'USD'),
1880 ('use_dimension', 'setup.company', 'tinyint', 1, '1'),
1881 ('f_year', 'setup.company', 'int', 11, '2'),
1882 ('shortname_name_in_list','setup.company', 'tinyint', 1, '0'),
1883 ('no_item_list', 'setup.company', 'tinyint', 1, '0'),
1884 ('no_customer_list', 'setup.company', 'tinyint', 1, '0'),
1885 ('no_supplier_list', 'setup.company', 'tinyint', 1, '0'),
1886 ('base_sales', 'setup.company', 'int', 11, '1'),
1887 ('time_zone', 'setup.company', 'tinyint', 1, '0'),
1888 ('add_pct', 'setup.company', 'int', 5, '-1'),
1889 ('round_to', 'setup.company', 'int', 5, '1'),
1890 ('login_tout', 'setup.company', 'smallint', 6, '600'),
1891 ('past_due_days', 'glsetup.general', 'int', 11, '30'),
1892 ('profit_loss_year_act', 'glsetup.general', 'varchar', 15, '9990'),
1893 ('retained_earnings_act', 'glsetup.general', 'varchar', 15, '3590'),
1894 ('bank_charge_act', 'glsetup.general', 'varchar', 15, '5690'),
1895 ('exchange_diff_act', 'glsetup.general', 'varchar', 15, '4450'),
1896 ('tax_algorithm', 'glsetup.customer', 'tinyint', 1, '1'),
1897 ('default_credit_limit', 'glsetup.customer', 'int', 11, '1000'),
1898 ('accumulate_shipping', 'glsetup.customer', 'tinyint', 1, '0'),
1899 ('legal_text', 'glsetup.customer', 'tinytext', 0, ''),
1900 ('freight_act', 'glsetup.customer', 'varchar', 15, '4430'),
1901 ('debtors_act', 'glsetup.sales', 'varchar', 15, '1200'),
1902 ('default_sales_act', 'glsetup.sales', 'varchar', 15, '4010'),
1903 ('default_sales_discount_act', 'glsetup.sales', 'varchar', 15, '4510'),
1904 ('default_prompt_payment_act', 'glsetup.sales', 'varchar', 15, '4500'),
1905 ('default_delivery_required', 'glsetup.sales', 'smallint', 6, '1'),
1906 ('default_receival_required', 'glsetup.purchase', 'smallint', 6, '10'),
1907 ('default_quote_valid_days', 'glsetup.sales', 'smallint', 6, '30'),
1908 ('default_dim_required', 'glsetup.dims', 'int', 11, '20'),
1909 ('pyt_discount_act', 'glsetup.purchase', 'varchar', 15, '5060'),
1910 ('creditors_act', 'glsetup.purchase', 'varchar', 15, '2100'),
1911 ('po_over_receive', 'glsetup.purchase', 'int', 11, '10'),
1912 ('po_over_charge', 'glsetup.purchase', 'int', 11, '10'),
1913 ('allow_negative_stock', 'glsetup.inventory', 'tinyint', 1, '0'),
1914 ('default_inventory_act', 'glsetup.items', 'varchar', 15, '1510'),
1915 ('default_cogs_act', 'glsetup.items', 'varchar', 15, '5010'),
1916 ('default_adj_act', 'glsetup.items', 'varchar', 15, '5040'),
1917 ('default_inv_sales_act', 'glsetup.items', 'varchar', 15, '4010'),
1918 ('default_wip_act', 'glsetup.items', 'varchar', 15, '1530'),
1919 ('default_workorder_required', 'glsetup.manuf', 'int', 11, '20'),
1920 ('version_id', 'system', 'varchar', 11, '2.5.0'),
1921 ('auto_curr_reval', 'setup.company', 'smallint', 6, '1'),
1922 ('grn_clearing_act', 'glsetup.purchase', 'varchar', 15, '1550'),
1923 ('bcc_email', 'setup.company', 'varchar', 100, ''),
1924 ('deferred_income_act', 'glsetup.sales', 'varchar', '15', '2105'),
1925 ('gl_closing_date','setup.closing_date', 'date', 8, ''),
1926 ('alternative_tax_include_on_docs','setup.company', 'tinyint', 1, '0'),
1927 ('no_zero_lines_amount','glsetup.sales', 'tinyint', 1, '1'),
1928 ('show_po_item_codes','glsetup.purchase', 'tinyint', 1, '0'),
1929 ('accounts_alpha','glsetup.general', 'tinyint', 1, '0'),
1930 ('loc_notification','glsetup.inventory', 'tinyint', 1, '0'),
1931 ('print_invoice_no','glsetup.sales', 'tinyint', 1, '0'),
1932 ('allow_negative_prices','glsetup.inventory', 'tinyint', 1, '1'),
1933 ('print_item_images_on_quote','glsetup.inventory', 'tinyint', 1, '0'),
1934 ('suppress_tax_rates','setup.company', 'tinyint', 1, '0'),
1935 ('company_logo_report','setup.company', 'tinyint', 1, '0'),
1936 ('barcodes_on_stock','setup.company', 'tinyint', 1, '0'),
1937 ('print_dialog_direct','setup.company', 'tinyint', 1, '0'),
1938 ('ref_no_auto_increase','setup.company', 'tinyint', 1, '0'),
1939 ('default_loss_on_asset_disposal_act', 'glsetup.items', 'varchar', '15', '5660'),
1940 ('depreciation_period', 'glsetup.company', 'tinyint', '1', '1'),
1941 ('use_manufacturing','setup.company', 'tinyint', 1, '1'),
1942 ('use_fixed_assets','setup.company', 'tinyint', 1, '1');
1944 -- Structure of table `0_tag_associations` --
1946 DROP TABLE IF EXISTS `0_tag_associations`;
1948 CREATE TABLE `0_tag_associations` (
1949 `record_id` varchar(15) NOT NULL,
1950 `tag_id` int(11) NOT NULL,
1951 PRIMARY KEY (`record_id`,`tag_id`)
1954 -- Data of table `0_tag_associations` --
1956 -- Structure of table `0_tags` --
1958 DROP TABLE IF EXISTS `0_tags`;
1960 CREATE TABLE `0_tags` (
1961 `id` int(11) NOT NULL AUTO_INCREMENT,
1962 `type` smallint(6) NOT NULL,
1963 `name` varchar(30) NOT NULL,
1964 `description` varchar(60) DEFAULT NULL,
1965 `inactive` tinyint(1) NOT NULL DEFAULT '0',
1967 UNIQUE KEY `type` (`type`,`name`)
1970 -- Data of table `0_tags` --
1972 -- Structure of table `0_tax_group_items` --
1974 DROP TABLE IF EXISTS `0_tax_group_items`;
1976 CREATE TABLE `0_tax_group_items` (
1977 `tax_group_id` int(11) NOT NULL DEFAULT '0',
1978 `tax_type_id` int(11) NOT NULL DEFAULT '0',
1979 `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 `tax_area` tinyint(1) NOT NULL DEFAULT '0',
1996 `inactive` tinyint(1) NOT NULL DEFAULT '0',
1998 UNIQUE KEY `name` (`name`)
1999 ) ENGINE=InnoDB AUTO_INCREMENT=3 ;
2001 -- Data of table `0_tax_groups` --
2003 INSERT INTO `0_tax_groups` VALUES
2004 ('1', 'Tax', '0', '0'),
2005 ('2', 'Export/Import', '1', '0');
2007 -- Structure of table `0_tax_types` --
2009 DROP TABLE IF EXISTS `0_tax_types`;
2011 CREATE TABLE `0_tax_types` (
2012 `id` int(11) NOT NULL AUTO_INCREMENT,
2013 `rate` double NOT NULL DEFAULT '0',
2014 `sales_gl_code` varchar(15) NOT NULL DEFAULT '',
2015 `purchasing_gl_code` varchar(15) NOT NULL DEFAULT '',
2016 `name` varchar(60) NOT NULL DEFAULT '',
2017 `inactive` tinyint(1) NOT NULL DEFAULT '0',
2019 ) ENGINE=InnoDB AUTO_INCREMENT=2 ;
2021 -- Data of table `0_tax_types` --
2023 INSERT INTO `0_tax_types` VALUES
2024 ('1', '5', '2150', '2150', 'Tax', '0');
2026 -- Structure of table `0_trans_tax_details` --
2028 DROP TABLE IF EXISTS `0_trans_tax_details`;
2030 CREATE TABLE `0_trans_tax_details` (
2031 `id` int(11) NOT NULL AUTO_INCREMENT,
2032 `trans_type` smallint(6) DEFAULT NULL,
2033 `trans_no` int(11) DEFAULT NULL,
2034 `tran_date` date NOT NULL,
2035 `tax_type_id` int(11) NOT NULL DEFAULT '0',
2036 `rate` double NOT NULL DEFAULT '0',
2037 `ex_rate` double NOT NULL DEFAULT '1',
2038 `included_in_price` tinyint(1) NOT NULL DEFAULT '0',
2039 `net_amount` double NOT NULL DEFAULT '0',
2040 `amount` double NOT NULL DEFAULT '0',
2042 `reg_type` tinyint(1) DEFAULT NULL,
2043 `vat_category` int(11) NOT NULL DEFAULT '0',
2044 `tax_group_id` tinyint(2) DEFAULT NULL,
2046 KEY `Type_and_Number` (`trans_type`,`trans_no`),
2047 KEY `tran_date` (`tran_date`)
2048 ) ENGINE=InnoDB AUTO_INCREMENT=11 ;
2050 -- Data of table `0_trans_tax_details` --
2052 INSERT INTO `0_trans_tax_details` VALUES
2053 ('1', '13', '1', '2018-05-10', '1', '5', '1', '1', '5942.86', '297.14', 'auto', NULL, '0', '1'),
2054 ('2', '10', '1', '2018-05-10', '1', '5', '1', '1', '5942.86', '297.14', '001/2018', '0', '0', '1'),
2055 ('3', '20', '1', '2018-05-05', '1', '5', '1', '0', '3000', '150', 'rr4', '1', '0', '1'),
2056 ('4', '13', '2', '2018-05-07', '1', '5', '1', '1', '285.71', '14.29', 'auto', NULL, '0', '1'),
2057 ('5', '10', '2', '2018-05-07', '1', '5', '1', '1', '285.71', '14.29', '002/2018', '0', '0', '1'),
2058 ('6', '13', '3', '2018-05-07', '0', '0', '1.123', '1', '267.14', '0', 'auto', NULL, '0', '1'),
2059 ('7', '10', '3', '2018-05-07', '0', '0', '1.123', '1', '267.14', '0', '003/2018', '0', '0', '1'),
2060 ('8', '13', '5', '2019-01-21', '1', '5', '1', '1', '1190.48', '59.52', 'auto', NULL, '0', '1'),
2061 ('9', '10', '5', '2019-01-21', '1', '5', '1', '1', '1190.48', '59.52', '001/2019', '0', '0', '1'),
2062 ('10', '20', '2', '2019-01-21', '1', '5', '1', '0', '900', '45', 'asd5', '1', '0', '1');
2064 -- Structure of table `0_useronline` --
2066 DROP TABLE IF EXISTS `0_useronline`;
2068 CREATE TABLE `0_useronline` (
2069 `id` int(11) NOT NULL AUTO_INCREMENT,
2070 `timestamp` int(15) NOT NULL DEFAULT '0',
2071 `ip` varchar(40) NOT NULL DEFAULT '',
2072 `file` varchar(100) NOT NULL DEFAULT '',
2074 KEY `timestamp` (`timestamp`),
2078 -- Data of table `0_useronline` --
2081 -- Structure of table `0_users` --
2083 DROP TABLE IF EXISTS `0_users`;
2085 CREATE TABLE `0_users` (
2086 `id` smallint(6) NOT NULL AUTO_INCREMENT,
2087 `user_id` varchar(60) NOT NULL DEFAULT '',
2088 `password` varchar(100) NOT NULL DEFAULT '',
2089 `real_name` varchar(100) NOT NULL DEFAULT '',
2090 `role_id` int(11) NOT NULL DEFAULT '1',
2091 `phone` varchar(30) NOT NULL DEFAULT '',
2092 `email` varchar(100) DEFAULT NULL,
2093 `language` varchar(20) DEFAULT NULL,
2094 `date_format` tinyint(1) NOT NULL DEFAULT '0',
2095 `date_sep` tinyint(1) NOT NULL DEFAULT '0',
2096 `tho_sep` tinyint(1) NOT NULL DEFAULT '0',
2097 `dec_sep` tinyint(1) NOT NULL DEFAULT '0',
2098 `theme` varchar(20) NOT NULL DEFAULT 'default',
2099 `page_size` varchar(20) NOT NULL DEFAULT 'A4',
2100 `prices_dec` smallint(6) NOT NULL DEFAULT '2',
2101 `qty_dec` smallint(6) NOT NULL DEFAULT '2',
2102 `rates_dec` smallint(6) NOT NULL DEFAULT '4',
2103 `percent_dec` smallint(6) NOT NULL DEFAULT '1',
2104 `show_gl` tinyint(1) NOT NULL DEFAULT '1',
2105 `show_codes` tinyint(1) NOT NULL DEFAULT '0',
2106 `show_hints` tinyint(1) NOT NULL DEFAULT '0',
2107 `last_visit_date` datetime DEFAULT NULL,
2108 `query_size` tinyint(1) unsigned NOT NULL DEFAULT '10',
2109 `graphic_links` tinyint(1) DEFAULT '1',
2110 `pos` smallint(6) DEFAULT '1',
2111 `print_profile` varchar(30) NOT NULL DEFAULT '',
2112 `rep_popup` tinyint(1) DEFAULT '1',
2113 `sticky_doc_date` tinyint(1) DEFAULT '0',
2114 `startup_tab` varchar(20) NOT NULL DEFAULT '',
2115 `transaction_days` smallint(6) NOT NULL DEFAULT '30',
2116 `save_report_selections` smallint(6) NOT NULL DEFAULT '0',
2117 `use_date_picker` tinyint(1) NOT NULL DEFAULT '1',
2118 `def_print_destination` tinyint(1) NOT NULL DEFAULT '0',
2119 `def_print_orientation` tinyint(1) NOT NULL DEFAULT '0',
2120 `inactive` tinyint(1) NOT NULL DEFAULT '0',
2122 UNIQUE KEY `user_id` (`user_id`)
2123 ) ENGINE=InnoDB AUTO_INCREMENT=2 ;
2125 -- Data of table `0_users` --
2127 INSERT INTO `0_users` VALUES
2128 ('1', 'admin', '5f4dcc3b5aa765d61d8327deb882cf99', 'Administrator', '2', '', 'adm@example.com', 'C', '0', '0', '0', '0', 'default', 'Letter', '2', '2', '4', '1', '1', '0', '0', '2018-05-07 13:58:33', '10', '1', '1', '1', '1', '0', 'orders', '30', '0', '1', '0', '0', '0');
2130 -- Structure of table `0_voided` --
2132 DROP TABLE IF EXISTS `0_voided`;
2134 CREATE TABLE `0_voided` (
2135 `type` int(11) NOT NULL DEFAULT '0',
2136 `id` int(11) NOT NULL DEFAULT '0',
2137 `date_` date NOT NULL DEFAULT '0000-00-00',
2138 `memo_` tinytext NOT NULL,
2139 UNIQUE KEY `id` (`type`,`id`)
2142 -- Data of table `0_voided` --
2145 -- Structure of table `0_wo_costing` --
2147 DROP TABLE IF EXISTS `0_wo_costing`;
2149 CREATE TABLE `0_wo_costing` (
2150 `id` int(11) NOT NULL AUTO_INCREMENT,
2151 `workorder_id` int(11) NOT NULL DEFAULT '0',
2152 `cost_type` tinyint(1) NOT NULL DEFAULT '0',
2153 `trans_type` int(11) NOT NULL DEFAULT '0',
2154 `trans_no` int(11) NOT NULL DEFAULT '0',
2155 `factor` double NOT NULL DEFAULT '1',
2159 -- Data of table `0_wo_costing` --
2161 -- Structure of table `0_wo_issue_items` --
2163 DROP TABLE IF EXISTS `0_wo_issue_items`;
2165 CREATE TABLE `0_wo_issue_items` (
2166 `id` int(11) NOT NULL AUTO_INCREMENT,
2167 `stock_id` varchar(40) DEFAULT NULL,
2168 `issue_id` int(11) DEFAULT NULL,
2169 `qty_issued` double DEFAULT NULL,
2170 `unit_cost` double NOT NULL DEFAULT '0',
2174 -- Data of table `0_wo_issue_items` --
2177 -- Structure of table `0_wo_issues` --
2179 DROP TABLE IF EXISTS `0_wo_issues`;
2181 CREATE TABLE `0_wo_issues` (
2182 `issue_no` int(11) NOT NULL AUTO_INCREMENT,
2183 `workorder_id` int(11) NOT NULL DEFAULT '0',
2184 `reference` varchar(100) DEFAULT NULL,
2185 `issue_date` date DEFAULT NULL,
2186 `loc_code` varchar(5) DEFAULT NULL,
2187 `workcentre_id` int(11) DEFAULT NULL,
2188 PRIMARY KEY (`issue_no`),
2189 KEY `workorder_id` (`workorder_id`)
2192 -- Data of table `0_wo_issues` --
2194 -- Structure of table `0_wo_manufacture` --
2196 DROP TABLE IF EXISTS `0_wo_manufacture`;
2198 CREATE TABLE `0_wo_manufacture` (
2199 `id` int(11) NOT NULL AUTO_INCREMENT,
2200 `reference` varchar(100) DEFAULT NULL,
2201 `workorder_id` int(11) NOT NULL DEFAULT '0',
2202 `quantity` double NOT NULL DEFAULT '0',
2203 `date_` date NOT NULL DEFAULT '0000-00-00',
2205 KEY `workorder_id` (`workorder_id`)
2206 ) ENGINE=InnoDB AUTO_INCREMENT=2 ;
2208 -- Data of table `0_wo_manufacture` --
2210 INSERT INTO `0_wo_manufacture` VALUES
2211 ('1', '001/2018', '1', '2', '2018-05-05');
2213 -- Structure of table `0_wo_requirements` --
2215 DROP TABLE IF EXISTS `0_wo_requirements`;
2217 CREATE TABLE `0_wo_requirements` (
2218 `id` int(11) NOT NULL AUTO_INCREMENT,
2219 `workorder_id` int(11) NOT NULL DEFAULT '0',
2220 `stock_id` char(20) NOT NULL DEFAULT '',
2221 `workcentre` int(11) NOT NULL DEFAULT '0',
2222 `units_req` double NOT NULL DEFAULT '1',
2223 `unit_cost` double NOT NULL DEFAULT '0',
2224 `loc_code` char(5) NOT NULL DEFAULT '',
2225 `units_issued` double NOT NULL DEFAULT '0',
2227 KEY `workorder_id` (`workorder_id`)
2228 ) ENGINE=InnoDB AUTO_INCREMENT=9 ;
2230 -- Data of table `0_wo_requirements` --
2232 INSERT INTO `0_wo_requirements` VALUES
2233 ('1', '1', '101', '1', '1', '200', 'DEF', '2'),
2234 ('2', '1', '102', '1', '1', '150', 'DEF', '2'),
2235 ('3', '1', '103', '1', '1', '10', 'DEF', '2'),
2236 ('4', '1', '301', '1', '1', '0', 'DEF', '2'),
2237 ('5', '2', '101', '1', '1', '200', 'DEF', '0'),
2238 ('6', '2', '102', '1', '1', '150', 'DEF', '0'),
2239 ('7', '2', '103', '1', '1', '10', 'DEF', '0'),
2240 ('8', '2', '301', '1', '1', '0', 'DEF', '0');
2242 -- Structure of table `0_workcentres` --
2244 DROP TABLE IF EXISTS `0_workcentres`;
2246 CREATE TABLE `0_workcentres` (
2247 `id` int(11) NOT NULL AUTO_INCREMENT,
2248 `name` char(40) NOT NULL DEFAULT '',
2249 `description` char(50) NOT NULL DEFAULT '',
2250 `inactive` tinyint(1) NOT NULL DEFAULT '0',
2252 UNIQUE KEY `name` (`name`)
2253 ) ENGINE=InnoDB AUTO_INCREMENT=2 ;
2255 -- Data of table `0_workcentres` --
2257 INSERT INTO `0_workcentres` VALUES
2258 ('1', 'Work Centre', '', '0');
2260 -- Structure of table `0_workorders` --
2262 DROP TABLE IF EXISTS `0_workorders`;
2264 CREATE TABLE `0_workorders` (
2265 `id` int(11) NOT NULL AUTO_INCREMENT,
2266 `wo_ref` varchar(60) NOT NULL DEFAULT '',
2267 `loc_code` varchar(5) NOT NULL DEFAULT '',
2268 `units_reqd` double NOT NULL DEFAULT '1',
2269 `stock_id` varchar(20) NOT NULL DEFAULT '',
2270 `date_` date NOT NULL DEFAULT '0000-00-00',
2271 `type` tinyint(4) NOT NULL DEFAULT '0',
2272 `required_by` date NOT NULL DEFAULT '0000-00-00',
2273 `released_date` date NOT NULL DEFAULT '0000-00-00',
2274 `units_issued` double NOT NULL DEFAULT '0',
2275 `closed` tinyint(1) NOT NULL DEFAULT '0',
2276 `released` tinyint(1) NOT NULL DEFAULT '0',
2278 KEY `wo_ref` (`wo_ref`)
2279 ) ENGINE=InnoDB AUTO_INCREMENT=4 ;
2281 -- Data of table `0_workorders` --
2283 INSERT INTO `0_workorders` VALUES
2284 ('1', '001/2018', 'DEF', '2', '201', '2018-05-05', '0', '2018-05-05', '2018-05-05', '2', '1', '1'),
2285 ('2', '002/2018', 'DEF', '5', '201', '2018-05-07', '2', '2018-05-27', '2018-05-07', '0', '0', '1'),
2286 ('3', '003/2018', 'DEF', '5', '201', '2018-05-07', '2', '2018-05-27', '0000-00-00', '0', '0', '0');