1 # Built by FrontAccounting 2.1.2
2 # http://frontaccounting.net
3 # Company: Training Co.
8 ### Structure of table `0_areas` ###
10 DROP TABLE IF EXISTS `0_areas`;
12 CREATE TABLE `0_areas` (
13 `area_code` int(11) NOT NULL auto_increment,
14 `description` varchar(60) NOT NULL default '',
15 `inactive` tinyint(1) NOT NULL default '0',
16 PRIMARY KEY (`area_code`),
17 UNIQUE KEY `description` (`description`)
18 ) TYPE=MyISAM AUTO_INCREMENT=2 ;
21 ### Data of table `0_areas` ###
23 INSERT INTO `0_areas` VALUES ('1', 'Global', '0');
26 ### Structure of table `0_attachments` ###
28 DROP TABLE IF EXISTS `0_attachments`;
30 CREATE TABLE `0_attachments` (
31 `id` int(11) unsigned NOT NULL auto_increment,
32 `description` varchar(60) NOT NULL default '',
33 `type_no` int(11) NOT NULL default '0',
34 `trans_no` int(11) NOT NULL default '0',
35 `unique_name` varchar(60) NOT NULL default '',
36 `tran_date` date NOT NULL default '0000-00-00',
37 `filename` varchar(60) NOT NULL default '',
38 `filesize` int(11) NOT NULL default '0',
39 `filetype` varchar(60) NOT NULL default '',
41 KEY `type_no` (`type_no`,`trans_no`)
42 ) TYPE=MyISAM AUTO_INCREMENT=1 ;
45 ### Data of table `0_attachments` ###
47 ### Structure of table `0_audit_trail` ###
49 DROP TABLE IF EXISTS `0_audit_trail`;
51 CREATE TABLE `0_audit_trail` (
52 `id` int(11) NOT NULL AUTO_INCREMENT,
53 `type` smallint(6) unsigned NOT NULL default '0',
54 `trans_no` int(11) unsigned NOT NULL default '0',
55 `user` smallint(6) unsigned NOT NULL default '0',
56 `stamp` timestamp NOT NULL,
57 `description` varchar(60) default NULL,
58 `fiscal_year` int(11) NOT NULL,
59 `gl_date` date NOT NULL default '0000-00-00',
60 `gl_seq` int(11) unsigned default NULL,
62 KEY `Seq` (`fiscal_year`, `gl_date`, `gl_seq`),
63 KEY `Type_and_Number` (`type`,`trans_no`)
66 ### Data of table `0_audit_trail` ###
72 ### Structure of table `0_bank_accounts` ###
74 DROP TABLE IF EXISTS `0_bank_accounts`;
76 CREATE TABLE `0_bank_accounts` (
77 `account_code` varchar(15) NOT NULL default '',
78 `account_type` smallint(6) NOT NULL default '0',
79 `bank_account_name` varchar(60) NOT NULL default '',
80 `bank_account_number` varchar(100) NOT NULL default '',
81 `bank_name` varchar(60) NOT NULL default '',
82 `bank_address` tinytext,
83 `bank_curr_code` char(3) NOT NULL default '',
84 `dflt_curr_act` TINYINT(1) NOT NULL default '0',
85 `id` smallint(6) NOT NULL auto_increment,
86 `last_reconciled_date` timestamp NOT NULL default '0000-00-00 00:00:00',
87 `ending_reconcile_balance` double NOT NULL default '0',
88 `inactive` tinyint(1) NOT NULL default '0',
90 KEY `bank_account_name` (`bank_account_name`),
91 KEY `bank_account_number` (`bank_account_number`),
93 ) TYPE=MyISAM AUTO_INCREMENT=3 ;
96 ### Data of table `0_bank_accounts` ###
98 INSERT INTO `0_bank_accounts` VALUES ('1060', '0', 'Current account', '9999999999', 'Wachovia Bank', '', 'USD', '1', '1', '0000-00-00 00:00:00', '0', '0');
99 INSERT INTO `0_bank_accounts` VALUES ('1065', '3', 'Petty Cash account', 'N/A', 'N/A', '', 'USD', '0', '2', '0000-00-00 00:00:00', '0', '0');
102 ### Structure of table `0_bank_trans` ###
104 DROP TABLE IF EXISTS `0_bank_trans`;
106 CREATE TABLE `0_bank_trans` (
107 `id` int(11) NOT NULL auto_increment,
108 `type` smallint(6) default NULL,
109 `trans_no` int(11) default NULL,
110 `bank_act` varchar(15) default NULL,
111 `ref` varchar(40) default NULL,
112 `trans_date` date NOT NULL default '0000-00-00',
113 `amount` double default NULL,
114 `dimension_id` int(11) NOT NULL default '0',
115 `dimension2_id` int(11) NOT NULL default '0',
116 `person_type_id` int(11) NOT NULL default '0',
117 `person_id` tinyblob,
118 `reconciled` date default NULL,
120 KEY `bank_act` (`bank_act`,`ref`),
121 KEY `type` (`type`,`trans_no`),
122 KEY (`bank_act`,`reconciled`),
123 KEY (`bank_act`,`trans_date`)
124 ) TYPE=InnoDB AUTO_INCREMENT=12 ;
127 ### Data of table `0_bank_trans` ###
129 INSERT INTO `0_bank_trans` VALUES ('1', '22', '4', '1', '1', '2009-06-21', '-3465', '0', '0', '3', '2', NULL);
130 INSERT INTO `0_bank_trans` VALUES ('2', '26', '1', '1', '', '2009-06-21', '-10', '0', '0', '1', '1', NULL);
131 INSERT INTO `0_bank_trans` VALUES ('3', '26', '1', '1', '', '2009-06-21', '-20', '0', '0', '1', '0', NULL);
132 INSERT INTO `0_bank_trans` VALUES ('4', '0', '18', '1', '1', '2009-02-20', '1000', '0', '0', '0', '', NULL);
133 INSERT INTO `0_bank_trans` VALUES ('5', '0', '19', '1', '2', '2009-02-21', '4000', '0', '0', '0', '', NULL);
134 INSERT INTO `0_bank_trans` VALUES ('6', '2', '5', '1', '1', '2009-06-21', '100', '0', '0', '4', '3', NULL);
135 INSERT INTO `0_bank_trans` VALUES ('7', '1', '8', '1', '1', '2009-06-21', '-50', '0', '0', '4', '1', NULL);
136 INSERT INTO `0_bank_trans` VALUES ('8', '26', '5', '1', '', '2009-06-21', '-10', '0', '0', '1', '1', NULL);
137 INSERT INTO `0_bank_trans` VALUES ('9', '26', '5', '1', '', '2009-06-21', '-20', '0', '0', '1', '0', NULL);
138 INSERT INTO `0_bank_trans` VALUES ('10', '26', '7', '1', '', '2009-06-21', '-10', '0', '0', '1', '1', NULL);
139 INSERT INTO `0_bank_trans` VALUES ('11', '26', '7', '1', '', '2009-06-21', '-20', '0', '0', '1', '0', NULL);
142 ### Structure of table `0_bom` ###
144 DROP TABLE IF EXISTS `0_bom`;
146 CREATE TABLE `0_bom` (
147 `id` int(11) NOT NULL auto_increment,
148 `parent` char(20) NOT NULL default '',
149 `component` char(20) NOT NULL default '',
150 `workcentre_added` int(11) NOT NULL default '0',
151 `loc_code` char(5) NOT NULL default '',
152 `quantity` double NOT NULL default '1',
153 PRIMARY KEY (`parent`,`component`,`workcentre_added`,`loc_code`),
154 KEY `component` (`component`),
156 KEY `loc_code` (`loc_code`),
157 KEY `parent` (`parent`,`loc_code`),
158 KEY `workcentre_added` (`workcentre_added`)
159 ) TYPE=MyISAM AUTO_INCREMENT=4 ;
162 ### Data of table `0_bom` ###
164 INSERT INTO `0_bom` VALUES ('1', '3400', '102', '1', 'DEF', '1');
165 INSERT INTO `0_bom` VALUES ('2', '3400', '103', '1', 'DEF', '1');
166 INSERT INTO `0_bom` VALUES ('3', '3400', '104', '1', 'DEF', '1');
169 ### Structure of table `0_budget_trans` ###
171 DROP TABLE IF EXISTS `0_budget_trans`;
173 CREATE TABLE `0_budget_trans` (
174 `counter` int(11) NOT NULL auto_increment,
175 `type` smallint(6) NOT NULL default '0',
176 `type_no` bigint(16) NOT NULL default '1',
177 `tran_date` date NOT NULL default '0000-00-00',
178 `account` varchar(15) NOT NULL default '',
179 `memo_` tinytext NOT NULL,
180 `amount` double NOT NULL default '0',
181 `dimension_id` int(11) default '0',
182 `dimension2_id` int(11) default '0',
183 `person_type_id` int(11) default NULL,
184 `person_id` tinyblob,
185 PRIMARY KEY (`counter`),
186 KEY `Type_and_Number` (`type`,`type_no`),
187 KEY `Account` (`account`, `tran_date`, `dimension_id`, `dimension2_id`)
188 ) TYPE=InnoDB AUTO_INCREMENT=1 ;
191 ### Data of table `0_budget_trans` ###
195 ### Structure of table `0_chart_class` ###
197 DROP TABLE IF EXISTS `0_chart_class`;
199 CREATE TABLE `0_chart_class` (
200 `cid` varchar(3) NOT NULL,
201 `class_name` varchar(60) NOT NULL default '',
202 `ctype` tinyint(1) NOT NULL default '0',
203 `inactive` tinyint(1) NOT NULL default '0',
208 ### Data of table `0_chart_class` ###
210 INSERT INTO `0_chart_class` VALUES ('1', 'Assets', '1', '0');
211 INSERT INTO `0_chart_class` VALUES ('2', 'Liabilities', '2', '0');
212 INSERT INTO `0_chart_class` VALUES ('3', 'Income', '4', '0');
213 INSERT INTO `0_chart_class` VALUES ('4', 'Costs', '6', '0');
216 ### Structure of table `0_chart_master` ###
218 DROP TABLE IF EXISTS `0_chart_master`;
220 CREATE TABLE `0_chart_master` (
221 `account_code` varchar(15) NOT NULL default '',
222 `account_code2` varchar(15) default '',
223 `account_name` varchar(60) NOT NULL default '',
224 `account_type` varchar(10) NOT NULL default '0',
225 `inactive` tinyint(1) NOT NULL default '0',
226 PRIMARY KEY (`account_code`),
227 KEY `account_name` (`account_name`),
228 KEY `accounts_by_type` (`account_type`, `account_code`)
232 ### Data of table `0_chart_master` ###
234 INSERT INTO `0_chart_master` VALUES ('1060', '', 'Checking Account', '1', '0');
235 INSERT INTO `0_chart_master` VALUES ('1065', '', 'Petty Cash', '1', '0');
236 INSERT INTO `0_chart_master` VALUES ('1200', '', 'Accounts Receivables', '1', '0');
237 INSERT INTO `0_chart_master` VALUES ('1205', '', 'Allowance for doubtful accounts', '1', '0');
238 INSERT INTO `0_chart_master` VALUES ('1510', '', 'Inventory', '2', '0');
239 INSERT INTO `0_chart_master` VALUES ('1520', '', 'Stocks of Raw Materials', '2', '0');
240 INSERT INTO `0_chart_master` VALUES ('1530', '', 'Stocks of Work In Progress', '2', '0');
241 INSERT INTO `0_chart_master` VALUES ('1540', '', 'Stocks of Finsihed Goods', '2', '0');
242 INSERT INTO `0_chart_master` VALUES ('1550', '', 'Goods Received Clearing account', '2', '0');
243 INSERT INTO `0_chart_master` VALUES ('1820', '', 'Office Furniture & Equipment', '3', '0');
244 INSERT INTO `0_chart_master` VALUES ('1825', '', 'Accum. Amort. -Furn. & Equip.', '3', '0');
245 INSERT INTO `0_chart_master` VALUES ('1840', '', 'Vehicle', '3', '0');
246 INSERT INTO `0_chart_master` VALUES ('1845', '', 'Accum. Amort. -Vehicle', '3', '0');
247 INSERT INTO `0_chart_master` VALUES ('2100', '', 'Accounts Payable', '4', '0');
248 INSERT INTO `0_chart_master` VALUES ('2110', '', 'Accrued Income Tax - Federal', '4', '0');
249 INSERT INTO `0_chart_master` VALUES ('2120', '', 'Accrued Income Tax - State', '4', '0');
250 INSERT INTO `0_chart_master` VALUES ('2130', '', 'Accrued Franchise Tax', '4', '0');
251 INSERT INTO `0_chart_master` VALUES ('2140', '', 'Accrued Real & Personal Prop Tax', '4', '0');
252 INSERT INTO `0_chart_master` VALUES ('2145', '', 'Purchase Tax', '4', '0');
253 INSERT INTO `0_chart_master` VALUES ('2150', '', 'Sales Tax', '4', '0');
254 INSERT INTO `0_chart_master` VALUES ('2160', '', 'Accrued Use Tax Payable', '4', '0');
255 INSERT INTO `0_chart_master` VALUES ('2210', '', 'Accrued Wages', '4', '0');
256 INSERT INTO `0_chart_master` VALUES ('2220', '', 'Accrued Comp Time', '4', '0');
257 INSERT INTO `0_chart_master` VALUES ('2230', '', 'Accrued Holiday Pay', '4', '0');
258 INSERT INTO `0_chart_master` VALUES ('2240', '', 'Accrued Vacation Pay', '4', '0');
259 INSERT INTO `0_chart_master` VALUES ('2310', '', 'Accr. Benefits - 401K', '4', '0');
260 INSERT INTO `0_chart_master` VALUES ('2320', '', 'Accr. Benefits - Stock Purchase', '4', '0');
261 INSERT INTO `0_chart_master` VALUES ('2330', '', 'Accr. Benefits - Med, Den', '4', '0');
262 INSERT INTO `0_chart_master` VALUES ('2340', '', 'Accr. Benefits - Payroll Taxes', '4', '0');
263 INSERT INTO `0_chart_master` VALUES ('2350', '', 'Accr. Benefits - Credit Union', '4', '0');
264 INSERT INTO `0_chart_master` VALUES ('2360', '', 'Accr. Benefits - Savings Bond', '4', '0');
265 INSERT INTO `0_chart_master` VALUES ('2370', '', 'Accr. Benefits - Garnish', '4', '0');
266 INSERT INTO `0_chart_master` VALUES ('2380', '', 'Accr. Benefits - Charity Cont.', '4', '0');
267 INSERT INTO `0_chart_master` VALUES ('2620', '', 'Bank Loans', '5', '0');
268 INSERT INTO `0_chart_master` VALUES ('2680', '', 'Loans from Shareholders', '5', '0');
269 INSERT INTO `0_chart_master` VALUES ('3350', '', 'Common Shares', '6', '0');
270 INSERT INTO `0_chart_master` VALUES ('3590', '', 'Retained Earnings - prior years', '7', '0');
271 INSERT INTO `0_chart_master` VALUES ('4010', '', 'Sales', '8', '0');
272 INSERT INTO `0_chart_master` VALUES ('4430', '', 'Shipping & Handling', '9', '0');
273 INSERT INTO `0_chart_master` VALUES ('4440', '', 'Interest', '9', '0');
274 INSERT INTO `0_chart_master` VALUES ('4450', '', 'Foreign Exchange Gain', '9', '0');
275 INSERT INTO `0_chart_master` VALUES ('4500', '', 'Prompt Payment Discounts', '9', '0');
276 INSERT INTO `0_chart_master` VALUES ('4510', '', 'Discounts Given', '9', '0');
277 INSERT INTO `0_chart_master` VALUES ('5010', '', 'Cost of Goods Sold - Retail', '10', '0');
278 INSERT INTO `0_chart_master` VALUES ('5020', '', 'Material Usage Varaiance', '10', '0');
279 INSERT INTO `0_chart_master` VALUES ('5030', '', 'Consumable Materials', '10', '0');
280 INSERT INTO `0_chart_master` VALUES ('5040', '', 'Purchase price Variance', '10', '0');
281 INSERT INTO `0_chart_master` VALUES ('5050', '', 'Purchases of materials', '10', '0');
282 INSERT INTO `0_chart_master` VALUES ('5060', '', 'Discounts Received', '10', '0');
283 INSERT INTO `0_chart_master` VALUES ('5100', '', 'Freight', '10', '0');
284 INSERT INTO `0_chart_master` VALUES ('5410', '', 'Wages & Salaries', '11', '0');
285 INSERT INTO `0_chart_master` VALUES ('5420', '', 'Wages - Overtime', '11', '0');
286 INSERT INTO `0_chart_master` VALUES ('5430', '', 'Benefits - Comp Time', '11', '0');
287 INSERT INTO `0_chart_master` VALUES ('5440', '', 'Benefits - Payroll Taxes', '11', '0');
288 INSERT INTO `0_chart_master` VALUES ('5450', '', 'Benefits - Workers Comp', '11', '0');
289 INSERT INTO `0_chart_master` VALUES ('5460', '', 'Benefits - Pension', '11', '0');
290 INSERT INTO `0_chart_master` VALUES ('5470', '', 'Benefits - General Benefits', '11', '0');
291 INSERT INTO `0_chart_master` VALUES ('5510', '', 'Inc Tax Exp - Federal', '11', '0');
292 INSERT INTO `0_chart_master` VALUES ('5520', '', 'Inc Tax Exp - State', '11', '0');
293 INSERT INTO `0_chart_master` VALUES ('5530', '', 'Taxes - Real Estate', '11', '0');
294 INSERT INTO `0_chart_master` VALUES ('5540', '', 'Taxes - Personal Property', '11', '0');
295 INSERT INTO `0_chart_master` VALUES ('5550', '', 'Taxes - Franchise', '11', '0');
296 INSERT INTO `0_chart_master` VALUES ('5560', '', 'Taxes - Foreign Withholding', '11', '0');
297 INSERT INTO `0_chart_master` VALUES ('5610', '', 'Accounting & Legal', '12', '0');
298 INSERT INTO `0_chart_master` VALUES ('5615', '', 'Advertising & Promotions', '12', '0');
299 INSERT INTO `0_chart_master` VALUES ('5620', '', 'Bad Debts', '12', '0');
300 INSERT INTO `0_chart_master` VALUES ('5660', '', 'Amortization Expense', '12', '0');
301 INSERT INTO `0_chart_master` VALUES ('5685', '', 'Insurance', '12', '0');
302 INSERT INTO `0_chart_master` VALUES ('5690', '', 'Interest & Bank Charges', '12', '0');
303 INSERT INTO `0_chart_master` VALUES ('5700', '', 'Office Supplies', '12', '0');
304 INSERT INTO `0_chart_master` VALUES ('5760', '', 'Rent', '12', '0');
305 INSERT INTO `0_chart_master` VALUES ('5765', '', 'Repair & Maintenance', '12', '0');
306 INSERT INTO `0_chart_master` VALUES ('5780', '', 'Telephone', '12', '0');
307 INSERT INTO `0_chart_master` VALUES ('5785', '', 'Travel & Entertainment', '12', '0');
308 INSERT INTO `0_chart_master` VALUES ('5790', '', 'Utilities', '12', '0');
309 INSERT INTO `0_chart_master` VALUES ('5795', '', 'Registrations', '12', '0');
310 INSERT INTO `0_chart_master` VALUES ('5800', '', 'Licenses', '12', '0');
311 INSERT INTO `0_chart_master` VALUES ('5810', '', 'Foreign Exchange Loss', '12', '0');
312 INSERT INTO `0_chart_master` VALUES ('9990', '', 'Year Profit/Loss', '12', '0');
314 ### Structure of table `0_chart_types` ###
316 DROP TABLE IF EXISTS `0_chart_types`;
318 CREATE TABLE `0_chart_types` (
319 `id` varchar(10) NOT NULL,
320 `name` varchar(60) NOT NULL default '',
321 `class_id` varchar(3) NOT NULL default '',
322 `parent` varchar(10) NOT NULL default '-1',
323 `inactive` tinyint(1) NOT NULL default '0',
330 ### Data of table `0_chart_types` ###
332 INSERT INTO `0_chart_types` VALUES ('1', 'Current Assets', '1', '-1', '0');
333 INSERT INTO `0_chart_types` VALUES ('2', 'Inventory Assets', '1', '-1', '0');
334 INSERT INTO `0_chart_types` VALUES ('3', 'Capital Assets', '1', '-1', '0');
335 INSERT INTO `0_chart_types` VALUES ('4', 'Current Liabilities', '2', '-1', '0');
336 INSERT INTO `0_chart_types` VALUES ('5', 'Long Term Liabilities', '2', '-1', '0');
337 INSERT INTO `0_chart_types` VALUES ('6', 'Share Capital', '2', '-1', '0');
338 INSERT INTO `0_chart_types` VALUES ('7', 'Retained Earnings', '2', '-1', '0');
339 INSERT INTO `0_chart_types` VALUES ('8', 'Sales Revenue', '3', '-1', '0');
340 INSERT INTO `0_chart_types` VALUES ('9', 'Other Revenue', '3', '-1', '0');
341 INSERT INTO `0_chart_types` VALUES ('10', 'Cost of Goods Sold', '4', '-1', '0');
342 INSERT INTO `0_chart_types` VALUES ('11', 'Payroll Expenses', '4', '-1', '0');
343 INSERT INTO `0_chart_types` VALUES ('12', 'General & Administrative expenses', '4', '-1', '0');
346 ### Structure of table `0_comments` ###
348 DROP TABLE IF EXISTS `0_comments`;
350 CREATE TABLE `0_comments` (
351 `type` int(11) NOT NULL default '0',
352 `id` int(11) NOT NULL default '0',
353 `date_` date default '0000-00-00',
355 KEY `type_and_id` (`type`, `id`)
359 ### Data of table `0_comments` ###
363 ### Structure of table `0_company` ###
365 DROP TABLE IF EXISTS `0_company`;
367 CREATE TABLE `0_company` (
368 `coy_code` int(11) NOT NULL default '1',
369 `coy_name` varchar(60) NOT NULL default '',
370 `gst_no` varchar(25) NOT NULL default '',
371 `coy_no` varchar(25) NOT NULL default '0',
372 `tax_prd` int(11) NOT NULL default '1',
373 `tax_last` int(11) NOT NULL default '1',
374 `postal_address` tinytext NOT NULL,
375 `phone` varchar(30) NOT NULL default '',
376 `fax` varchar(30) NOT NULL default '',
377 `email` varchar(100) NOT NULL default '',
378 `coy_logo` varchar(100) NOT NULL default '',
379 `domicile` varchar(55) NOT NULL default '',
380 `curr_default` char(3) NOT NULL default '',
381 `debtors_act` varchar(15) NOT NULL default '',
382 `pyt_discount_act` varchar(15) NOT NULL default '',
383 `creditors_act` varchar(15) NOT NULL default '',
384 `bank_charge_act` varchar(15) NOT NULL default '',
385 `exchange_diff_act` varchar(15) NOT NULL default '',
386 `profit_loss_year_act` varchar(15) NOT NULL default '',
387 `retained_earnings_act` varchar(15) NOT NULL default '',
388 `freight_act` varchar(15) NOT NULL default '',
389 `default_sales_act` varchar(15) NOT NULL default '',
390 `default_sales_discount_act` varchar(15) NOT NULL default '',
391 `default_prompt_payment_act` varchar(15) NOT NULL default '',
392 `default_inventory_act` varchar(15) NOT NULL default '',
393 `default_cogs_act` varchar(15) NOT NULL default '',
394 `default_adj_act` varchar(15) NOT NULL default '',
395 `default_inv_sales_act` varchar(15) NOT NULL default '',
396 `default_assembly_act` varchar(15) NOT NULL default '',
397 `payroll_act` varchar(15) NOT NULL default '',
398 `allow_negative_stock` tinyint(1) NOT NULL default '0',
399 `po_over_receive` int(11) NOT NULL default '10',
400 `po_over_charge` int(11) NOT NULL default '10',
401 `default_credit_limit` int(11) NOT NULL default '1000',
402 `default_workorder_required` int(11) NOT NULL default '20',
403 `default_dim_required` int(11) NOT NULL default '20',
404 `past_due_days` int(11) NOT NULL default '30',
405 `use_dimension` tinyint(1) default '0',
406 `f_year` int(11) NOT NULL default '1',
407 `no_item_list` tinyint(1) NOT NULL default '0',
408 `no_customer_list` tinyint(1) NOT NULL default '0',
409 `no_supplier_list` tinyint(1) NOT NULL default '0',
410 `base_sales` int(11) NOT NULL default '-1',
411 `foreign_codes` tinyint(1) NOT NULL default '0',
412 `accumulate_shipping` tinyint(1) NOT NULL default '0',
413 `legal_text` tinytext NOT NULL,
414 `default_delivery_required` smallint(6) NOT NULL default '1',
415 `version_id` varchar(11) NOT NULL default '',
416 `time_zone` tinyint(1) NOT NULL default '0',
417 `add_pct` int(5) NOT NULL default '-1',
418 `round_to` int(5) NOT NULL default '1',
419 `login_tout` SMALLINT(6) NOT NULL DEFAULT '600',
420 PRIMARY KEY (`coy_code`)
423 ### Data of table `0_company` ###
425 INSERT INTO `0_company` VALUES ('1', 'Training Co.', '9876543', '123456789', '1', '1', 'Address 1\r\nAddress 2\r\nAddress 3', '(222) 111.222.333', '', 'delta@delta.com', 'logo_frontaccounting.jpg', '', 'USD', '1200', '5060', '2100', '5690', '4450', '9990', '3590', '4430', '4010', '4510', '4500', '1510', '5010', '5040', '4010', '1530', '5000', '0', '10', '10', '1000', '20', '20', '30', '1', '2', '0', '0', '0', '1', '0', '0', '', '1', '2.2', '0', '-1', '1', '600');
427 ### Structure of table `0_credit_status` ###
429 DROP TABLE IF EXISTS `0_credit_status`;
431 CREATE TABLE `0_credit_status` (
432 `id` int(11) NOT NULL auto_increment,
433 `reason_description` char(100) NOT NULL default '',
434 `dissallow_invoices` tinyint(1) NOT NULL default '0',
435 `inactive` tinyint(1) NOT NULL default '0',
437 UNIQUE KEY `reason_description` (`reason_description`)
438 ) TYPE=MyISAM AUTO_INCREMENT=5 ;
441 ### Data of table `0_credit_status` ###
443 INSERT INTO `0_credit_status` VALUES ('1', 'Good History', '0', '0');
444 INSERT INTO `0_credit_status` VALUES ('3', 'No more work until payment received', '1', '0');
445 INSERT INTO `0_credit_status` VALUES ('4', 'In liquidation', '1', '0');
448 ### Structure of table `0_currencies` ###
450 DROP TABLE IF EXISTS `0_currencies`;
452 CREATE TABLE `0_currencies` (
453 `currency` varchar(60) NOT NULL default '',
454 `curr_abrev` char(3) NOT NULL default '',
455 `curr_symbol` varchar(10) NOT NULL default '',
456 `country` varchar(100) NOT NULL default '',
457 `hundreds_name` varchar(15) NOT NULL default '',
458 `auto_update` tinyint(1) NOT NULL default '1',
459 `inactive` tinyint(1) NOT NULL default '0',
460 PRIMARY KEY (`curr_abrev`)
464 ### Data of table `0_currencies` ###
466 INSERT INTO `0_currencies` VALUES ('US Dollars', 'USD', '$', 'United States', 'Cents', '1', '0');
467 INSERT INTO `0_currencies` VALUES ('CA Dollars', 'CAD', '$', 'Canada', 'Cents', '1', '0');
468 INSERT INTO `0_currencies` VALUES ('Euro', 'EUR', '?', 'Europe', 'Cents', '1', '0');
469 INSERT INTO `0_currencies` VALUES ('Pounds', 'GBP', '?', 'England', 'Pence', '1', '0');
470 INSERT INTO `0_currencies` VALUES ('DK Kroner', 'DKK', '?', 'Denmark', 'Ore', '1', '0');
472 ### Structure of table `0_cust_allocations` ###
474 DROP TABLE IF EXISTS `0_cust_allocations`;
476 CREATE TABLE `0_cust_allocations` (
477 `id` int(11) NOT NULL auto_increment,
478 `amt` double unsigned default NULL,
479 `date_alloc` date NOT NULL default '0000-00-00',
480 `trans_no_from` int(11) default NULL,
481 `trans_type_from` int(11) default NULL,
482 `trans_no_to` int(11) default NULL,
483 `trans_type_to` int(11) default NULL,
485 KEY `From` (`trans_type_from`, `trans_no_from`),
486 KEY `To` (`trans_type_to`, `trans_no_to`)
487 ) TYPE=InnoDB AUTO_INCREMENT=2 ;
490 ### Data of table `0_cust_allocations` ###
492 INSERT INTO `0_cust_allocations` VALUES ('1', '37.68', '2009-06-21', '3', '11', '18', '10');
495 ### Structure of table `0_cust_branch` ###
497 DROP TABLE IF EXISTS `0_cust_branch`;
499 CREATE TABLE `0_cust_branch` (
500 `branch_code` int(11) NOT NULL auto_increment,
501 `debtor_no` int(11) NOT NULL default '0',
502 `br_name` varchar(60) NOT NULL default '',
503 `branch_ref` varchar(30) NOT NULL default '',
504 `br_address` tinytext NOT NULL,
505 `area` int(11) default NULL,
506 `salesman` int(11) NOT NULL default '0',
507 `phone` varchar(30) NOT NULL default '',
508 `phone2` varchar(30) NOT NULL default '',
509 `fax` varchar(30) NOT NULL default '',
510 `contact_name` varchar(60) NOT NULL default '',
511 `email` varchar(100) NOT NULL default '',
512 `default_location` varchar(5) NOT NULL default '',
513 `tax_group_id` int(11) default NULL,
514 `sales_account` varchar(15) default NULL,
515 `sales_discount_account` varchar(15) default NULL,
516 `receivables_account` varchar(15) default NULL,
517 `payment_discount_account` varchar(15) default NULL,
518 `default_ship_via` int(11) NOT NULL default '1',
519 `disable_trans` tinyint(4) NOT NULL default '0',
520 `br_post_address` tinytext NOT NULL,
521 `group_no` int(11) NOT NULL default '0',
522 `notes` tinytext NOT NULL,
523 `rep_lang` char(5) default NULL,
524 `inactive` tinyint(1) NOT NULL default '0',
525 PRIMARY KEY (`branch_code`,`debtor_no`),
526 KEY `branch_code` (`branch_code`),
529 ) TYPE=MyISAM AUTO_INCREMENT=4 ;
532 ### Data of table `0_cust_branch` ###
534 INSERT INTO `0_cust_branch` VALUES ('1', '1', 'Beefeater Ltd.', 'Beefeater', '', '1', '1', '', '', '', 'Main Branch', '', 'DEF', '2', '', '4510', '1200', '4500', '1', '0', 'Address 1\r\nAddress 2\r\nAddress 3', '0', '', '', '0');
535 INSERT INTO `0_cust_branch` VALUES ('2', '2', 'Ghostbusters Corp.', 'Ghostbusters', 'Address 1\r\nAddress 2\r\nAddress 3', '1', '1', '', '', '', 'Main Branch', '', 'DEF', '1', '', '4510', '1200', '4500', '1', '0', 'Address 1\r\nAddress 2\r\nAddress 3', '0', '', '', '0');
536 INSERT INTO `0_cust_branch` VALUES ('3', '3', 'Brezan', 'Brezan', 'Address 1\r\nAddress 2\r\nAddress 3', '1', '1', '', '', '', 'Main Branch', '', 'DEF', '1', '', '4510', '1200', '4500', '1', '0', 'Address 1\r\nAddress 2\r\nAddress 3', '0', '', '', '0');
539 ### Structure of table `0_debtor_trans` ###
541 DROP TABLE IF EXISTS `0_debtor_trans`;
543 CREATE TABLE `0_debtor_trans` (
544 `trans_no` int(11) unsigned NOT NULL default '0',
545 `type` smallint(6) unsigned NOT NULL default '0',
546 `version` tinyint(1) unsigned NOT NULL default '0',
547 `debtor_no` int(11) unsigned default NULL,
548 `branch_code` int(11) NOT NULL default '-1',
549 `tran_date` date NOT NULL default '0000-00-00',
550 `due_date` date NOT NULL default '0000-00-00',
551 `reference` varchar(60) NOT NULL default '',
552 `tpe` int(11) NOT NULL default '0',
553 `order_` int(11) NOT NULL default '0',
554 `ov_amount` double NOT NULL default '0',
555 `ov_gst` double NOT NULL default '0',
556 `ov_freight` double NOT NULL default '0',
557 `ov_freight_tax` double NOT NULL default '0',
558 `ov_discount` double NOT NULL default '0',
559 `alloc` double NOT NULL default '0',
560 `rate` double NOT NULL default '1',
561 `ship_via` int(11) default NULL,
562 `trans_link` int(11) NOT NULL default '0',
563 `dimension_id` int(11) NOT NULL default '0',
564 `dimension2_id` int(11) NOT NULL default '0',
565 `payment_terms` int(11) default NULL,
566 PRIMARY KEY (`type`, `trans_no`),
567 KEY `debtor_no` (`debtor_no`,`branch_code`),
572 ### Data of table `0_debtor_trans` ###
574 INSERT INTO `0_debtor_trans` VALUES ('2', '13', '0', '1', '1', '2009-06-21', '2009-06-22', '1', '2', '1', '60.8', '0', '10', '0', '0', '0', '1.6445729799917', '1', '0', '0', '0','3');
575 INSERT INTO `0_debtor_trans` VALUES ('3', '11', '0', '3', '3', '2009-06-21', '0000-00-00', '1', '2', '3', '35.89', '1.79', '0', '0', '0', '37.68', '1.3932', '1', '18', '2', '0','3');
576 INSERT INTO `0_debtor_trans` VALUES ('3', '13', '1', '2', '2', '2009-06-21', '2009-06-22', 'auto', '1', '2', '50', '2.5', '0', '0', '0', '0', '1', '1', '17', '0', '0','');
577 INSERT INTO `0_debtor_trans` VALUES ('4', '13', '1', '3', '3', '2009-06-21', '2009-07-01', 'auto', '2', '3', '35.89', '1.79', '0', '0', '0', '0', '1.3932', '1', '18', '2', '0','3');
578 INSERT INTO `0_debtor_trans` VALUES ('5', '13', '1', '2', '2', '2009-06-21', '2009-06-22', 'auto', '1', '5', '50', '0', '5', '0', '0', '0', '1', '1', '19', '0', '0','4');
579 INSERT INTO `0_debtor_trans` VALUES ('17', '10', '0', '2', '2', '2009-06-21', '2009-06-22', '1', '1', '2', '50', '2.5', '0', '0', '0', '0', '1', '1', '3', '0', '0','4');
580 INSERT INTO `0_debtor_trans` VALUES ('18', '10', '1', '3', '3', '2009-06-21', '2009-07-01', '2', '2', '3', '35.89', '1.79', '0', '0', '0', '37.68', '1.3932', '1', '4', '2', '0','3');
581 INSERT INTO `0_debtor_trans` VALUES ('19', '10', '0', '2', '2', '2009-06-21', '2009-06-22', '3', '1', '5', '50', '0', '5', '0', '0', '0', '1', '1', '5', '0', '0','4');
584 ### Structure of table `0_debtor_trans_details` ###
586 DROP TABLE IF EXISTS `0_debtor_trans_details`;
588 CREATE TABLE `0_debtor_trans_details` (
589 `id` int(11) NOT NULL auto_increment,
590 `debtor_trans_no` int(11) default NULL,
591 `debtor_trans_type` int(11) default NULL,
592 `stock_id` varchar(20) NOT NULL default '',
593 `description` tinytext,
594 `unit_price` double NOT NULL default '0',
595 `unit_tax` double NOT NULL default '0',
596 `quantity` double NOT NULL default '0',
597 `discount_percent` double NOT NULL default '0',
598 `standard_cost` double NOT NULL default '0',
599 `qty_done` double NOT NULL default '0',
601 KEY `Transaction` (`debtor_trans_type`, `debtor_trans_no`)
602 ) TYPE=InnoDB AUTO_INCREMENT=9 ;
605 ### Data of table `0_debtor_trans_details` ###
607 INSERT INTO `0_debtor_trans_details` VALUES ('1', '2', '13', '102', '17inch VGA Monitor', '30.4', '0', '2', '0', '10', '0');
608 INSERT INTO `0_debtor_trans_details` VALUES ('2', '3', '13', '102', '17inch VGA Monitor', '50', '2.5', '1', '0', '10', '1');
609 INSERT INTO `0_debtor_trans_details` VALUES ('3', '17', '10', '102', '17inch VGA Monitor', '50', '2.5', '1', '0', '10', '0');
610 INSERT INTO `0_debtor_trans_details` VALUES ('4', '4', '13', '102', '17inch VGA Monitor', '35.89', '1.79', '1', '0', '10', '1');
611 INSERT INTO `0_debtor_trans_details` VALUES ('5', '18', '10', '102', '17inch VGA Monitor', '35.89', '1.79', '1', '0', '10', '1');
612 INSERT INTO `0_debtor_trans_details` VALUES ('6', '5', '13', '102', '17inch VGA Monitor', '50', '2.38', '1', '0', '10', '1');
613 INSERT INTO `0_debtor_trans_details` VALUES ('7', '19', '10', '102', '17inch VGA Monitor', '50', '2.38', '1', '0', '10', '0');
614 INSERT INTO `0_debtor_trans_details` VALUES ('8', '3', '11', '102', '17inch VGA Monitor', '35.89', '1.79', '1', '0', '10', '0');
617 ### Structure of table `0_debtors_master` ###
619 DROP TABLE IF EXISTS `0_debtors_master`;
621 CREATE TABLE `0_debtors_master` (
622 `debtor_no` int(11) NOT NULL auto_increment,
623 `name` varchar(100) NOT NULL default '',
624 `debtor_ref` varchar(30) NOT NULL,
626 `email` varchar(100) NOT NULL default '',
627 `tax_id` varchar(55) NOT NULL default '',
628 `curr_code` char(3) NOT NULL default '',
629 `rep_lang` char(5) default NULL,
630 `sales_type` int(11) NOT NULL default '1',
631 `dimension_id` int(11) NOT NULL default '0',
632 `dimension2_id` int(11) NOT NULL default '0',
633 `credit_status` int(11) NOT NULL default '0',
634 `payment_terms` int(11) default NULL,
635 `discount` double NOT NULL default '0',
636 `pymt_discount` double NOT NULL default '0',
637 `credit_limit` float NOT NULL default '1000',
638 `notes` tinytext NOT NULL,
639 `inactive` tinyint(1) NOT NULL default '0',
640 PRIMARY KEY (`debtor_no`),
641 UNIQUE KEY `name` (`name`),
643 ) TYPE=MyISAM AUTO_INCREMENT=4 ;
646 ### Data of table `0_debtors_master` ###
648 INSERT INTO `0_debtors_master` VALUES ('1', 'Beefeater Ltd.', 'Beefeater', 'Addr 1\r\nAddr 2\r\nAddr 3', '', '345678', 'GBP', '', '2', '0', '0', '1', '3', '0', '0', '1000', '', '0');
649 INSERT INTO `0_debtors_master` VALUES ('2', 'Ghostbusters Corp.', 'Ghostbusters', 'Address 1\r\nAddress 2\r\nAddress 3', '', '2222222', 'USD', '', '1', '0', '0', '1', '4', '0', '0', '1000', '', '0');
650 INSERT INTO `0_debtors_master` VALUES ('3', 'Brezan', 'Brezan', 'Address 1\r\nAddress 2\r\nAddress 3', '', '7777777', 'EUR', '', '2', '0', '0', '1', '3', '0', '0', '1000', '', '0');
653 ### Structure of table `0_dimensions` ###
655 DROP TABLE IF EXISTS `0_dimensions`;
657 CREATE TABLE `0_dimensions` (
658 `id` int(11) NOT NULL auto_increment,
659 `reference` varchar(60) NOT NULL default '',
660 `name` varchar(60) NOT NULL default '',
661 `type_` tinyint(1) NOT NULL default '1',
662 `closed` tinyint(1) NOT NULL default '0',
663 `date_` date NOT NULL default '0000-00-00',
664 `due_date` date NOT NULL default '0000-00-00',
666 UNIQUE KEY `reference` (`reference`),
670 ) TYPE=InnoDB AUTO_INCREMENT=3 ;
673 ### Data of table `0_dimensions` ###
675 INSERT INTO `0_dimensions` VALUES ('1', '1', 'Support', '1', '0', '2009-06-21', '2015-07-11');
676 INSERT INTO `0_dimensions` VALUES ('2', '2', 'Development', '1', '0', '2009-06-21', '2015-07-11');
679 ### Structure of table `0_exchange_rates` ###
681 DROP TABLE IF EXISTS `0_exchange_rates`;
683 CREATE TABLE `0_exchange_rates` (
684 `id` int(11) NOT NULL auto_increment,
685 `curr_code` char(3) NOT NULL default '',
686 `rate_buy` double NOT NULL default '0',
687 `rate_sell` double NOT NULL default '0',
688 `date_` date NOT NULL default '0000-00-00',
690 UNIQUE KEY `curr_code` (`curr_code`,`date_`)
691 ) TYPE=MyISAM AUTO_INCREMENT=4 ;
694 ### Data of table `0_exchange_rates` ###
696 INSERT INTO `0_exchange_rates` VALUES ('1', 'DKK', '0.18717252868313', '0.18717252868313', '2009-06-21');
697 INSERT INTO `0_exchange_rates` VALUES ('2', 'GBP', '1.6445729799917', '1.6445729799917', '2009-06-21');
698 INSERT INTO `0_exchange_rates` VALUES ('3', 'EUR', '1.3932', '1.3932', '2009-06-21');
701 ### Structure of table `0_fiscal_year` ###
703 DROP TABLE IF EXISTS `0_fiscal_year`;
705 CREATE TABLE `0_fiscal_year` (
706 `id` int(11) NOT NULL auto_increment,
707 `begin` date default '0000-00-00',
708 `end` date default '0000-00-00',
709 `closed` tinyint(1) NOT NULL default '0',
713 ) TYPE=InnoDB AUTO_INCREMENT=4 ;
716 ### Data of table `0_fiscal_year` ###
718 INSERT INTO `0_fiscal_year` VALUES ('1', '2008-01-01', '2008-12-31', '0');
719 INSERT INTO `0_fiscal_year` VALUES ('2', '2009-01-01', '2009-12-31', '0');
720 INSERT INTO `0_fiscal_year` VALUES ('3', '2010-01-01', '2010-12-31', '0');
723 ### Structure of table `0_gl_trans` ###
725 DROP TABLE IF EXISTS `0_gl_trans`;
727 CREATE TABLE `0_gl_trans` (
728 `counter` int(11) NOT NULL auto_increment,
729 `type` smallint(6) NOT NULL default '0',
730 `type_no` bigint(16) NOT NULL default '1',
731 `tran_date` date NOT NULL default '0000-00-00',
732 `account` varchar(15) NOT NULL default '',
733 `memo_` tinytext NOT NULL,
734 `amount` double NOT NULL default '0',
735 `dimension_id` int(11) NOT NULL default '0',
736 `dimension2_id` int(11) NOT NULL default '0',
737 `person_type_id` int(11) default NULL,
738 `person_id` tinyblob,
739 PRIMARY KEY (`counter`),
740 KEY `Type_and_Number` (`type`,`type_no`),
741 KEY (`dimension_id`),
742 KEY (`dimension2_id`),
744 KEY `account_and_tran_date` (`account`, `tran_date`)
745 ) TYPE=InnoDB AUTO_INCREMENT=84 ;
748 ### Data of table `0_gl_trans` ###
750 INSERT INTO `0_gl_trans` VALUES ('1', '20', '7', '2009-06-21', '2100', '', '-3465', '0', '0', '3', '2');
751 INSERT INTO `0_gl_trans` VALUES ('2', '20', '7', '2009-06-21', '1510', '', '1000', '0', '0', '3', '2');
752 INSERT INTO `0_gl_trans` VALUES ('3', '20', '7', '2009-06-21', '1510', '', '1100', '0', '0', '3', '2');
753 INSERT INTO `0_gl_trans` VALUES ('4', '20', '7', '2009-06-21', '1510', '', '1200', '0', '0', '3', '2');
754 INSERT INTO `0_gl_trans` VALUES ('5', '20', '7', '2009-06-21', '2150', '', '165', '0', '0', '3', '2');
755 INSERT INTO `0_gl_trans` VALUES ('6', '22', '4', '2009-06-21', '2100', '', '3465', '0', '0', '3', '2');
756 INSERT INTO `0_gl_trans` VALUES ('7', '22', '4', '2009-06-21', '1060', '', '-3465', '0', '0', '3', '2');
757 INSERT INTO `0_gl_trans` VALUES ('8', '26', '1', '2009-06-21', '1510', '', '-100', '0', '0', NULL, '');
758 INSERT INTO `0_gl_trans` VALUES ('9', '26', '1', '2009-06-21', '1510', '', '-110', '0', '0', NULL, '');
759 INSERT INTO `0_gl_trans` VALUES ('10', '26', '1', '2009-06-21', '1510', '', '-120', '0', '0', NULL, '');
760 INSERT INTO `0_gl_trans` VALUES ('11', '26', '1', '2009-06-21', '1060', 'Overhead Cost', '-10', '0', '0', '1', '1');
761 INSERT INTO `0_gl_trans` VALUES ('12', '26', '1', '2009-06-21', '1530', 'Overhead Cost', '10', '0', '0', '1', '1');
762 INSERT INTO `0_gl_trans` VALUES ('13', '26', '1', '2009-06-21', '1060', 'Labour Cost', '-20', '0', '0', '1', '0');
763 INSERT INTO `0_gl_trans` VALUES ('14', '26', '1', '2009-06-21', '1530', 'Labour Cost', '20', '0', '0', '1', '0');
764 INSERT INTO `0_gl_trans` VALUES ('15', '26', '1', '2009-06-21', '1510', '', '330', '0', '0', NULL, '');
765 INSERT INTO `0_gl_trans` VALUES ('16', '13', '2', '2009-06-21', '5010', '', '20', '0', '0', '2', '1');
766 INSERT INTO `0_gl_trans` VALUES ('17', '13', '2', '2009-06-21', '1510', '', '-20', '0', '0', '2', '1');
767 INSERT INTO `0_gl_trans` VALUES ('18', '13', '3', '2009-06-21', '5010', '', '10', '0', '0', '2', '2');
768 INSERT INTO `0_gl_trans` VALUES ('19', '13', '3', '2009-06-21', '1510', '', '-10', '0', '0', '2', '2');
769 INSERT INTO `0_gl_trans` VALUES ('20', '10', '17', '2009-06-21', '4010', '', '-50', '0', '0', '2', '2');
770 INSERT INTO `0_gl_trans` VALUES ('21', '10', '17', '2009-06-21', '1200', '', '52.5', '0', '0', '2', '2');
771 INSERT INTO `0_gl_trans` VALUES ('22', '10', '17', '2009-06-21', '2150', '', '-2.5', '0', '0', '2', '2');
772 INSERT INTO `0_gl_trans` VALUES ('23', '13', '4', '2009-06-21', '5010', '', '10', '2', '0', '2', '3');
773 INSERT INTO `0_gl_trans` VALUES ('24', '13', '4', '2009-06-21', '1510', '', '-10', '0', '0', '2', '3');
774 INSERT INTO `0_gl_trans` VALUES ('25', '10', '18', '2009-06-21', '4010', '', '-50', '2', '0', '2', '3');
775 INSERT INTO `0_gl_trans` VALUES ('26', '10', '18', '2009-06-21', '1200', '', '52.5', '0', '0', '2', '3');
776 INSERT INTO `0_gl_trans` VALUES ('27', '10', '18', '2009-06-21', '2150', '', '-2.5', '0', '0', '2', '3');
777 INSERT INTO `0_gl_trans` VALUES ('28', '0', '18', '2009-02-20', '1060', '', '1000', '0', '0', NULL, '');
778 INSERT INTO `0_gl_trans` VALUES ('29', '0', '18', '2009-02-20', '3350', '', '-1000', '0', '0', NULL, '');
779 INSERT INTO `0_gl_trans` VALUES ('30', '0', '19', '2009-02-21', '1060', '', '4000', '0', '0', NULL, '');
780 INSERT INTO `0_gl_trans` VALUES ('31', '0', '19', '2009-02-21', '3350', '', '-4000', '0', '0', NULL, '');
781 INSERT INTO `0_gl_trans` VALUES ('32', '26', '3', '2009-06-21', '1510', '', '-20', '0', '0', NULL, '');
782 INSERT INTO `0_gl_trans` VALUES ('33', '26', '3', '2009-06-21', '1510', '', '-22', '0', '0', NULL, '');
783 INSERT INTO `0_gl_trans` VALUES ('34', '26', '3', '2009-06-21', '1510', '', '-24', '0', '0', NULL, '');
784 INSERT INTO `0_gl_trans` VALUES ('35', '26', '3', '2009-06-21', '1540', '', '66', '0', '0', NULL, '');
785 INSERT INTO `0_gl_trans` VALUES ('36', '2', '5', '2009-06-21', '2150', 'Cash Sales', '-4.76', '0', '0', '4', '3');
786 INSERT INTO `0_gl_trans` VALUES ('37', '2', '5', '2009-06-21', '4010', 'Cash Sales', '-95.24', '0', '0', '4', '3');
787 INSERT INTO `0_gl_trans` VALUES ('38', '2', '5', '2009-06-21', '1060', '', '100', '0', '0', '4', '3');
788 INSERT INTO `0_gl_trans` VALUES ('39', '1', '8', '2009-06-21', '2150', 'Maintenance', '2.38', '0', '0', '4', '1');
789 INSERT INTO `0_gl_trans` VALUES ('40', '1', '8', '2009-06-21', '5765', 'Maintenance', '47.62', '0', '0', '4', '1');
790 INSERT INTO `0_gl_trans` VALUES ('41', '1', '8', '2009-06-21', '1060', '', '-50', '0', '0', '4', '1');
791 INSERT INTO `0_gl_trans` VALUES ('42', '20', '8', '2009-06-21', '2100', '', '-20', '0', '0', '3', '2');
792 INSERT INTO `0_gl_trans` VALUES ('43', '20', '8', '2009-06-21', '2150', '', '0.95', '0', '0', '3', '2');
793 INSERT INTO `0_gl_trans` VALUES ('44', '20', '8', '2009-06-21', '5780', '', '19.05', '0', '0', '3', '2');
794 INSERT INTO `0_gl_trans` VALUES ('45', '26', '4', '2009-06-21', '1510', '', '-40', '0', '0', NULL, '');
795 INSERT INTO `0_gl_trans` VALUES ('46', '26', '4', '2009-06-21', '1510', '', '-44', '0', '0', NULL, '');
796 INSERT INTO `0_gl_trans` VALUES ('47', '26', '4', '2009-06-21', '1510', '', '-48', '0', '0', NULL, '');
797 INSERT INTO `0_gl_trans` VALUES ('48', '26', '4', '2009-06-21', '1540', '', '132', '0', '0', NULL, '');
798 INSERT INTO `0_gl_trans` VALUES ('49', '26', '2', '2009-06-21', '1510', '', '-20', '0', '0', NULL, '');
799 INSERT INTO `0_gl_trans` VALUES ('50', '26', '2', '2009-06-21', '1510', '', '-22', '0', '0', NULL, '');
800 INSERT INTO `0_gl_trans` VALUES ('51', '26', '2', '2009-06-21', '1510', '', '-24', '0', '0', NULL, '');
801 INSERT INTO `0_gl_trans` VALUES ('52', '26', '2', '2009-06-21', '1540', '', '66', '0', '0', NULL, '');
802 INSERT INTO `0_gl_trans` VALUES ('53', '26', '5', '2009-06-21', '1510', '', '-50', '0', '0', NULL, '');
803 INSERT INTO `0_gl_trans` VALUES ('54', '26', '5', '2009-06-21', '1510', '', '-55', '0', '0', NULL, '');
804 INSERT INTO `0_gl_trans` VALUES ('55', '26', '5', '2009-06-21', '1510', '', '-60', '0', '0', NULL, '');
805 INSERT INTO `0_gl_trans` VALUES ('56', '26', '5', '2009-06-21', '1060', 'Overhead Cost', '-10', '0', '0', '1', '1');
806 INSERT INTO `0_gl_trans` VALUES ('57', '26', '5', '2009-06-21', '1530', 'Overhead Cost', '10', '0', '0', '1', '1');
807 INSERT INTO `0_gl_trans` VALUES ('58', '26', '5', '2009-06-21', '1060', 'Labour Cost', '-20', '0', '0', '1', '0');
808 INSERT INTO `0_gl_trans` VALUES ('59', '26', '5', '2009-06-21', '1530', 'Labour Cost', '20', '0', '0', '1', '0');
809 INSERT INTO `0_gl_trans` VALUES ('60', '26', '5', '2009-06-21', '1540', '', '165', '0', '0', NULL, '');
810 INSERT INTO `0_gl_trans` VALUES ('61', '26', '6', '2009-06-21', '1510', '', '50', '0', '0', NULL, '');
811 INSERT INTO `0_gl_trans` VALUES ('62', '26', '6', '2009-06-21', '1510', '', '55', '0', '0', NULL, '');
812 INSERT INTO `0_gl_trans` VALUES ('63', '26', '6', '2009-06-21', '1510', '', '60', '0', '0', NULL, '');
813 INSERT INTO `0_gl_trans` VALUES ('64', '26', '6', '2009-06-21', '1540', '', '-165', '0', '0', NULL, '');
814 INSERT INTO `0_gl_trans` VALUES ('65', '26', '7', '2009-06-21', '1510', '', '20', '0', '0', NULL, '');
815 INSERT INTO `0_gl_trans` VALUES ('66', '26', '7', '2009-06-21', '1510', '', '22', '0', '0', NULL, '');
816 INSERT INTO `0_gl_trans` VALUES ('67', '26', '7', '2009-06-21', '1510', '', '24', '0', '0', NULL, '');
817 INSERT INTO `0_gl_trans` VALUES ('68', '26', '7', '2009-06-21', '1060', 'Overhead Cost', '-10', '0', '0', '1', '1');
818 INSERT INTO `0_gl_trans` VALUES ('69', '26', '7', '2009-06-21', '1530', 'Overhead Cost', '10', '0', '0', '1', '1');
819 INSERT INTO `0_gl_trans` VALUES ('70', '26', '7', '2009-06-21', '1060', 'Labour Cost', '-20', '0', '0', '1', '0');
820 INSERT INTO `0_gl_trans` VALUES ('71', '26', '7', '2009-06-21', '1530', 'Labour Cost', '20', '0', '0', '1', '0');
821 INSERT INTO `0_gl_trans` VALUES ('72', '26', '7', '2009-06-21', '1540', '', '-66', '0', '0', NULL, '');
822 INSERT INTO `0_gl_trans` VALUES ('73', '13', '5', '2009-06-21', '5010', '', '10', '0', '0', '2', '2');
823 INSERT INTO `0_gl_trans` VALUES ('74', '13', '5', '2009-06-21', '1510', '', '-10', '0', '0', '2', '2');
824 INSERT INTO `0_gl_trans` VALUES ('75', '10', '19', '2009-06-21', '4010', '', '-47.62', '0', '0', '2', '2');
825 INSERT INTO `0_gl_trans` VALUES ('76', '10', '19', '2009-06-21', '1200', '', '55', '0', '0', '2', '2');
826 INSERT INTO `0_gl_trans` VALUES ('77', '10', '19', '2009-06-21', '4430', '', '-5', '0', '0', '2', '2');
827 INSERT INTO `0_gl_trans` VALUES ('78', '10', '19', '2009-06-21', '2150', '', '-2.38', '0', '0', '2', '2');
828 INSERT INTO `0_gl_trans` VALUES ('79', '11', '3', '2009-06-21', '5010', '', '-10', '2', '0', '2', '3');
829 INSERT INTO `0_gl_trans` VALUES ('80', '11', '3', '2009-06-21', '1510', '', '10', '0', '0', '2', '3');
830 INSERT INTO `0_gl_trans` VALUES ('81', '11', '3', '2009-06-21', '4010', '', '50', '2', '0', '2', '3');
831 INSERT INTO `0_gl_trans` VALUES ('82', '11', '3', '2009-06-21', '1200', '', '-52.5', '0', '0', '2', '3');
832 INSERT INTO `0_gl_trans` VALUES ('83', '11', '3', '2009-06-21', '2150', '', '2.5', '0', '0', '2', '3');
835 ### Structure of table `0_grn_batch` ###
837 DROP TABLE IF EXISTS `0_grn_batch`;
839 CREATE TABLE `0_grn_batch` (
840 `id` int(11) NOT NULL auto_increment,
841 `supplier_id` int(11) NOT NULL default '0',
842 `purch_order_no` int(11) default NULL,
843 `reference` varchar(60) NOT NULL default '',
844 `delivery_date` date NOT NULL default '0000-00-00',
845 `loc_code` varchar(5) default NULL,
847 KEY(`delivery_date`),
848 KEY(`purch_order_no`)
849 ) TYPE=InnoDB AUTO_INCREMENT=2 ;
852 ### Data of table `0_grn_batch` ###
854 INSERT INTO `0_grn_batch` VALUES ('1', '2', '1', '1', '2009-06-21', 'DEF');
857 ### Structure of table `0_grn_items` ###
859 DROP TABLE IF EXISTS `0_grn_items`;
861 CREATE TABLE `0_grn_items` (
862 `id` int(11) NOT NULL auto_increment,
863 `grn_batch_id` int(11) default NULL,
864 `po_detail_item` int(11) NOT NULL default '0',
865 `item_code` varchar(20) NOT NULL default '',
866 `description` tinytext,
867 `qty_recd` double NOT NULL default '0',
868 `quantity_inv` double NOT NULL default '0',
871 ) TYPE=InnoDB AUTO_INCREMENT=4 ;
874 ### Data of table `0_grn_items` ###
876 INSERT INTO `0_grn_items` VALUES ('1', '1', '1', '102', '17inch VGA Monitor', '100', '100');
877 INSERT INTO `0_grn_items` VALUES ('2', '1', '2', '103', '32MB VGA Card', '100', '100');
878 INSERT INTO `0_grn_items` VALUES ('3', '1', '3', '104', '52x CD Drive', '100', '100');
881 ### Structure of table `0_groups` ###
883 DROP TABLE IF EXISTS `0_groups`;
885 CREATE TABLE `0_groups` (
886 `id` smallint(6) unsigned NOT NULL auto_increment,
887 `description` varchar(60) NOT NULL default '',
888 `inactive` tinyint(1) NOT NULL default '0',
890 UNIQUE KEY `description` (`description`)
891 ) TYPE=MyISAM AUTO_INCREMENT=4 AUTO_INCREMENT=4 ;
894 ### Data of table `0_groups` ###
896 INSERT INTO `0_groups` VALUES ('1', 'Small', '0');
897 INSERT INTO `0_groups` VALUES ('2', 'Medium', '0');
898 INSERT INTO `0_groups` VALUES ('3', 'Large', '0');
901 ### Structure of table `0_item_codes` ###
903 DROP TABLE IF EXISTS `0_item_codes`;
905 CREATE TABLE `0_item_codes` (
906 `id` int(11) unsigned NOT NULL auto_increment,
907 `item_code` varchar(20) NOT NULL,
908 `stock_id` varchar(20) NOT NULL,
909 `description` varchar(200) NOT NULL default '',
910 `category_id` smallint(6) unsigned NOT NULL,
911 `quantity` double NOT NULL default '1',
912 `is_foreign` tinyint(1) NOT NULL default '0',
913 `inactive` tinyint(1) NOT NULL default '0',
915 UNIQUE KEY `stock_id` (`stock_id`,`item_code`),
917 ) TYPE=MyISAM AUTO_INCREMENT=6 ;
920 ### Data of table `0_item_codes` ###
922 INSERT INTO `0_item_codes` VALUES ('1', '102', '102', '17inch VGA Monitor', '1', '1', '0', '0');
923 INSERT INTO `0_item_codes` VALUES ('2', '103', '103', '32MB VGA Card', '1', '1', '0', '0');
924 INSERT INTO `0_item_codes` VALUES ('3', '104', '104', '52x CD Drive', '1', '1', '0', '0');
925 INSERT INTO `0_item_codes` VALUES ('4', '3400', '3400', 'P4 Business System', '3', '1', '0', '0');
926 INSERT INTO `0_item_codes` VALUES ('5', '201', '201', 'Assembly Labour', '4', '1', '0', '0');
929 ### Structure of table `0_item_tax_type_exemptions` ###
931 DROP TABLE IF EXISTS `0_item_tax_type_exemptions`;
933 CREATE TABLE `0_item_tax_type_exemptions` (
934 `item_tax_type_id` int(11) NOT NULL default '0',
935 `tax_type_id` int(11) NOT NULL default '0',
936 PRIMARY KEY (`item_tax_type_id`,`tax_type_id`)
940 ### Data of table `0_item_tax_type_exemptions` ###
944 ### Structure of table `0_item_tax_types` ###
946 DROP TABLE IF EXISTS `0_item_tax_types`;
948 CREATE TABLE `0_item_tax_types` (
949 `id` int(11) NOT NULL auto_increment,
950 `name` varchar(60) NOT NULL default '',
951 `exempt` tinyint(1) NOT NULL default '0',
952 `inactive` tinyint(1) NOT NULL default '0',
954 UNIQUE KEY `name` (`name`)
955 ) TYPE=InnoDB AUTO_INCREMENT=2 ;
958 ### Data of table `0_item_tax_types` ###
960 INSERT INTO `0_item_tax_types` VALUES ('1', 'Regular', '0', '0');
962 ### Structure of table `0_item_units` ###
964 DROP TABLE IF EXISTS `0_item_units`;
966 CREATE TABLE `0_item_units` (
967 `abbr` varchar(20) NOT NULL,
968 `name` varchar(40) NOT NULL,
969 `decimals` tinyint(2) NOT NULL,
970 `inactive` tinyint(1) NOT NULL default '0',
971 PRIMARY KEY (`abbr`),
972 UNIQUE KEY `name` (`name`)
976 ### Data of table `0_item_units` ###
978 INSERT INTO `0_item_units` VALUES ('ea.', 'Each', '0', '0');
979 INSERT INTO `0_item_units` VALUES ('hrs', 'Hours', '1', '0');
982 ### Structure of table `0_loc_stock` ###
984 DROP TABLE IF EXISTS `0_loc_stock`;
986 CREATE TABLE `0_loc_stock` (
987 `loc_code` char(5) NOT NULL default '',
988 `stock_id` char(20) NOT NULL default '',
989 `reorder_level` bigint(20) NOT NULL default '0',
990 PRIMARY KEY (`loc_code`,`stock_id`),
991 KEY `stock_id` (`stock_id`)
995 ### Data of table `0_loc_stock` ###
997 INSERT INTO `0_loc_stock` VALUES ('DEF', '102', '0');
998 INSERT INTO `0_loc_stock` VALUES ('DEF', '103', '0');
999 INSERT INTO `0_loc_stock` VALUES ('DEF', '104', '0');
1000 INSERT INTO `0_loc_stock` VALUES ('DEF', '201', '0');
1001 INSERT INTO `0_loc_stock` VALUES ('DEF', '3400', '0');
1004 ### Structure of table `0_locations` ###
1006 DROP TABLE IF EXISTS `0_locations`;
1008 CREATE TABLE `0_locations` (
1009 `loc_code` varchar(5) NOT NULL default '',
1010 `location_name` varchar(60) NOT NULL default '',
1011 `delivery_address` tinytext NOT NULL,
1012 `phone` varchar(30) NOT NULL default '',
1013 `phone2` varchar(30) NOT NULL default '',
1014 `fax` varchar(30) NOT NULL default '',
1015 `email` varchar(100) NOT NULL default '',
1016 `contact` varchar(30) NOT NULL default '',
1017 `inactive` tinyint(1) NOT NULL default '0',
1018 PRIMARY KEY (`loc_code`)
1022 ### Data of table `0_locations` ###
1024 INSERT INTO `0_locations` VALUES ('DEF', 'Default', 'Delivery 1\r\nDelivery 2\r\nDelivery 3', '', '', '', '', '', '0');
1027 ### Structure of table `0_movement_types` ###
1029 DROP TABLE IF EXISTS `0_movement_types`;
1031 CREATE TABLE `0_movement_types` (
1032 `id` int(11) NOT NULL auto_increment,
1033 `name` varchar(60) NOT NULL default '',
1034 `inactive` tinyint(1) NOT NULL default '0',
1036 UNIQUE KEY `name` (`name`)
1037 ) TYPE=MyISAM AUTO_INCREMENT=2 ;
1040 ### Data of table `0_movement_types` ###
1042 INSERT INTO `0_movement_types` VALUES ('1', 'Adjustment', '0');
1045 ### Structure of table `0_payment_terms` ###
1047 DROP TABLE IF EXISTS `0_payment_terms`;
1049 CREATE TABLE `0_payment_terms` (
1050 `terms_indicator` int(11) NOT NULL auto_increment,
1051 `terms` char(80) NOT NULL default '',
1052 `days_before_due` smallint(6) NOT NULL default '0',
1053 `day_in_following_month` smallint(6) NOT NULL default '0',
1054 `inactive` tinyint(1) NOT NULL default '0',
1055 PRIMARY KEY (`terms_indicator`),
1056 UNIQUE KEY `terms` (`terms`)
1057 ) TYPE=MyISAM AUTO_INCREMENT=5 ;
1060 ### Data of table `0_payment_terms` ###
1062 INSERT INTO `0_payment_terms` VALUES ('1', 'Due 15th Of the Following Month', '0', '17', '0');
1063 INSERT INTO `0_payment_terms` VALUES ('2', 'Due By End Of The Following Month', '0', '30', '0');
1064 INSERT INTO `0_payment_terms` VALUES ('3', 'Payment due within 10 days', '10', '0', '0');
1065 INSERT INTO `0_payment_terms` VALUES ('4', 'Cash Only', '0', '0', '0');
1068 ### Structure of table `0_prices` ###
1070 DROP TABLE IF EXISTS `0_prices`;
1072 CREATE TABLE `0_prices` (
1073 `id` int(11) NOT NULL auto_increment,
1074 `stock_id` varchar(20) NOT NULL default '',
1075 `sales_type_id` int(11) NOT NULL default '0',
1076 `curr_abrev` char(3) NOT NULL default '',
1077 `price` double NOT NULL default '0',
1079 UNIQUE KEY `price` (`stock_id`,`sales_type_id`,`curr_abrev`)
1080 ) TYPE=MyISAM AUTO_INCREMENT=5 ;
1083 ### Data of table `0_prices` ###
1085 INSERT INTO `0_prices` VALUES ('1', '3400', '1', 'USD', '100');
1086 INSERT INTO `0_prices` VALUES ('2', '102', '1', 'USD', '50');
1087 INSERT INTO `0_prices` VALUES ('3', '103', '1', 'USD', '55');
1088 INSERT INTO `0_prices` VALUES ('4', '104', '1', 'USD', '60');
1091 ### Structure of table `0_print_profiles` ###
1093 DROP TABLE IF EXISTS `0_print_profiles`;
1095 CREATE TABLE `0_print_profiles` (
1096 `id` smallint(6) unsigned NOT NULL auto_increment,
1097 `profile` varchar(30) NOT NULL,
1098 `report` varchar(5) default NULL,
1099 `printer` tinyint(3) unsigned default NULL,
1101 UNIQUE KEY `profile` (`profile`,`report`)
1102 ) TYPE=MyISAM AUTO_INCREMENT=10 ;
1105 ### Data of table `0_print_profiles` ###
1107 INSERT INTO `0_print_profiles` VALUES ('1', 'Out of office', '', '0');
1108 INSERT INTO `0_print_profiles` VALUES ('2', 'Sales Department', '', '0');
1109 INSERT INTO `0_print_profiles` VALUES ('3', 'Central', '', '2');
1110 INSERT INTO `0_print_profiles` VALUES ('4', 'Sales Department', '104', '2');
1111 INSERT INTO `0_print_profiles` VALUES ('5', 'Sales Department', '105', '2');
1112 INSERT INTO `0_print_profiles` VALUES ('6', 'Sales Department', '107', '2');
1113 INSERT INTO `0_print_profiles` VALUES ('7', 'Sales Department', '109', '2');
1114 INSERT INTO `0_print_profiles` VALUES ('8', 'Sales Department', '110', '2');
1115 INSERT INTO `0_print_profiles` VALUES ('9', 'Sales Department', '201', '2');
1118 ### Structure of table `0_printers` ###
1120 DROP TABLE IF EXISTS `0_printers`;
1122 CREATE TABLE `0_printers` (
1123 `id` tinyint(3) unsigned NOT NULL auto_increment,
1124 `name` varchar(20) NOT NULL,
1125 `description` varchar(60) NOT NULL,
1126 `queue` varchar(20) NOT NULL,
1127 `host` varchar(40) NOT NULL,
1128 `port` smallint(11) unsigned NOT NULL,
1129 `timeout` tinyint(3) unsigned NOT NULL,
1131 UNIQUE KEY `name` (`name`)
1132 ) TYPE=MyISAM AUTO_INCREMENT=4 ;
1135 ### Data of table `0_printers` ###
1137 INSERT INTO `0_printers` VALUES ('1', 'QL500', 'Label printer', 'QL500', 'server', '127', '20');
1138 INSERT INTO `0_printers` VALUES ('2', 'Samsung', 'Main network printer', 'scx4521F', 'server', '515', '5');
1139 INSERT INTO `0_printers` VALUES ('3', 'Local', 'Local print server at user IP', 'lp', '', '515', '10');
1142 ### Structure of table `0_purch_data` ###
1144 DROP TABLE IF EXISTS `0_purch_data`;
1146 CREATE TABLE `0_purch_data` (
1147 `supplier_id` int(11) NOT NULL default '0',
1148 `stock_id` char(20) NOT NULL default '',
1149 `price` double NOT NULL default '0',
1150 `suppliers_uom` char(50) NOT NULL default '',
1151 `conversion_factor` double NOT NULL default '1',
1152 `supplier_description` char(50) NOT NULL default '',
1153 PRIMARY KEY (`supplier_id`,`stock_id`)
1157 ### Data of table `0_purch_data` ###
1159 INSERT INTO `0_purch_data` VALUES ('2', '102', '10', '', '1', '17inch VGA Monitor');
1160 INSERT INTO `0_purch_data` VALUES ('2', '103', '11', '', '1', '32MB VGA Card');
1161 INSERT INTO `0_purch_data` VALUES ('2', '104', '12', '', '1', '52x CD Drive');
1164 ### Structure of table `0_purch_order_details` ###
1166 DROP TABLE IF EXISTS `0_purch_order_details`;
1168 CREATE TABLE `0_purch_order_details` (
1169 `po_detail_item` int(11) NOT NULL auto_increment,
1170 `order_no` int(11) NOT NULL default '0',
1171 `item_code` varchar(20) NOT NULL default '',
1172 `description` tinytext,
1173 `delivery_date` date NOT NULL default '0000-00-00',
1174 `qty_invoiced` double NOT NULL default '0',
1175 `unit_price` double NOT NULL default '0',
1176 `act_price` double NOT NULL default '0',
1177 `std_cost_unit` double NOT NULL default '0',
1178 `quantity_ordered` double NOT NULL default '0',
1179 `quantity_received` double NOT NULL default '0',
1180 PRIMARY KEY (`po_detail_item`),
1181 KEY `order` (`order_no`, `po_detail_item`)
1182 ) TYPE=InnoDB AUTO_INCREMENT=6 ;
1185 ### Data of table `0_purch_order_details` ###
1187 INSERT INTO `0_purch_order_details` VALUES ('1', '1', '102', '17inch VGA Monitor', '2009-07-01', '100', '10', '10', '10', '100', '100');
1188 INSERT INTO `0_purch_order_details` VALUES ('2', '1', '103', '32MB VGA Card', '2009-07-01', '100', '11', '11', '11', '100', '100');
1189 INSERT INTO `0_purch_order_details` VALUES ('3', '1', '104', '52x CD Drive', '2009-07-01', '100', '12', '12', '12', '100', '100');
1190 INSERT INTO `0_purch_order_details` VALUES ('4', '2', '102', '17inch VGA Monitor', '2009-07-01', '0', '5', '0', '0', '1', '0');
1191 INSERT INTO `0_purch_order_details` VALUES ('5', '2', '103', '32MB VGA Card', '2009-07-01', '0', '5', '0', '0', '1', '0');
1194 ### Structure of table `0_purch_orders` ###
1196 DROP TABLE IF EXISTS `0_purch_orders`;
1198 CREATE TABLE `0_purch_orders` (
1199 `order_no` int(11) NOT NULL auto_increment,
1200 `supplier_id` int(11) NOT NULL default '0',
1201 `comments` tinytext,
1202 `ord_date` date NOT NULL default '0000-00-00',
1203 `reference` tinytext NOT NULL,
1204 `requisition_no` tinytext,
1205 `into_stock_location` varchar(5) NOT NULL default '',
1206 `delivery_address` tinytext NOT NULL,
1207 PRIMARY KEY (`order_no`),
1209 ) TYPE=InnoDB AUTO_INCREMENT=3 ;
1212 ### Data of table `0_purch_orders` ###
1214 INSERT INTO `0_purch_orders` VALUES ('1', '2', '', '2009-06-01', '1', '', 'DEF', 'Delivery 1\r\nDelivery 2\r\nDelivery 3');
1215 INSERT INTO `0_purch_orders` VALUES ('2', '3', '', '2009-06-21', '2', '', 'DEF', 'Delivery 1\r\nDelivery 2\r\nDelivery 3');
1218 ### Structure of table `0_quick_entries` ###
1220 DROP TABLE IF EXISTS `0_quick_entries`;
1222 CREATE TABLE `0_quick_entries` (
1223 `id` smallint(6) unsigned NOT NULL auto_increment,
1224 `type` tinyint(1) NOT NULL default '0',
1225 `description` varchar(60) NOT NULL,
1226 `base_amount` double NOT NULL default '0',
1227 `base_desc` varchar(60) default NULL,
1228 `bal_type` tinyint(1) NOT NULL default '0',
1230 KEY `description` (`description`)
1231 ) TYPE=MyISAM AUTO_INCREMENT=4 ;
1234 ### Data of table `0_quick_entries` ###
1236 INSERT INTO `0_quick_entries` VALUES ('1', '1', 'Maintenance', '0', 'Amount', '0');
1237 INSERT INTO `0_quick_entries` VALUES ('2', '4', 'Phone', '0', 'Amount', '0');
1238 INSERT INTO `0_quick_entries` VALUES ('3', '2', 'Cash Sales', '0', 'Amount', '0');
1241 ### Structure of table `0_quick_entry_lines` ###
1243 DROP TABLE IF EXISTS `0_quick_entry_lines`;
1245 CREATE TABLE `0_quick_entry_lines` (
1246 `id` smallint(6) unsigned NOT NULL auto_increment,
1247 `qid` smallint(6) unsigned NOT NULL,
1248 `amount` double default '0',
1249 `action` varchar(2) NOT NULL,
1250 `dest_id` varchar(15) NOT NULL,
1251 `dimension_id` smallint(6) unsigned default NULL,
1252 `dimension2_id` smallint(6) unsigned default NULL,
1255 ) TYPE=MyISAM AUTO_INCREMENT=8 ;
1258 ### Data of table `0_quick_entry_lines` ###
1260 INSERT INTO `0_quick_entry_lines` VALUES ('1', '1', '0', 't-', '1', '0', '0');
1261 INSERT INTO `0_quick_entry_lines` VALUES ('2', '2', '0', 't-', '1', '0', '0');
1262 INSERT INTO `0_quick_entry_lines` VALUES ('3', '3', '0', 't-', '1', '0', '0');
1263 INSERT INTO `0_quick_entry_lines` VALUES ('4', '3', '0', '=', '4010', '0', '0');
1264 INSERT INTO `0_quick_entry_lines` VALUES ('5', '1', '0', '=', '5765', '0', '0');
1265 INSERT INTO `0_quick_entry_lines` VALUES ('6', '2', '0', '=', '5780', '0', '0');
1268 ### Structure of table `0_recurrent_invoices` ###
1270 DROP TABLE IF EXISTS `0_recurrent_invoices`;
1272 CREATE TABLE `0_recurrent_invoices` (
1273 `id` smallint(6) unsigned NOT NULL auto_increment,
1274 `description` varchar(60) NOT NULL default '',
1275 `order_no` int(11) unsigned NOT NULL,
1276 `debtor_no` int(11) unsigned default NULL,
1277 `group_no` smallint(6) unsigned default NULL,
1278 `days` int(11) NOT NULL default '0',
1279 `monthly` int(11) NOT NULL default '0',
1280 `begin` date NOT NULL default '0000-00-00',
1281 `end` date NOT NULL default '0000-00-00',
1282 `last_sent` date NOT NULL default '0000-00-00',
1284 UNIQUE KEY `description` (`description`)
1285 ) TYPE=InnoDB AUTO_INCREMENT=1 ;
1288 ### Data of table `0_recurrent_invoices` ###
1292 ### Structure of table `0_refs` ###
1294 DROP TABLE IF EXISTS `0_refs`;
1296 CREATE TABLE `0_refs` (
1297 `id` int(11) NOT NULL default '0',
1298 `type` int(11) NOT NULL default '0',
1299 `reference` varchar(100) NOT NULL default '',
1300 PRIMARY KEY (`id`,`type`),
1301 KEY `Type_and_Reference` (`type`,`reference`)
1305 ### Data of table `0_refs` ###
1307 INSERT INTO `0_refs` VALUES ('18', '0', '1');
1308 INSERT INTO `0_refs` VALUES ('19', '0', '2');
1311 ### Structure of table `0_sales_order_details` ###
1313 DROP TABLE IF EXISTS `0_sales_order_details`;
1315 CREATE TABLE `0_sales_order_details` (
1316 `id` int(11) NOT NULL auto_increment,
1317 `order_no` int(11) NOT NULL default '0',
1318 `trans_type` smallint(6) NOT NULL default '30',
1319 `stk_code` varchar(20) NOT NULL default '',
1320 `description` tinytext,
1321 `qty_sent` double NOT NULL default '0',
1322 `unit_price` double NOT NULL default '0',
1323 `quantity` double NOT NULL default '0',
1324 `discount_percent` double NOT NULL default '0',
1326 KEY `sorder` (`trans_type`, `order_no`)
1327 ) TYPE=InnoDB AUTO_INCREMENT=6 ;
1330 ### Data of table `0_sales_order_details` ###
1332 INSERT INTO `0_sales_order_details` VALUES ('1', '1', '30', '102', '17inch VGA Monitor', '2', '30.4', '2', '0');
1333 INSERT INTO `0_sales_order_details` VALUES ('2', '2', '30', '102', '17inch VGA Monitor', '1', '50', '1', '0');
1334 INSERT INTO `0_sales_order_details` VALUES ('3', '3', '30', '102', '17inch VGA Monitor', '1', '35.89', '1', '0');
1335 INSERT INTO `0_sales_order_details` VALUES ('4', '4', '30', '102', '17inch VGA Monitor', '0', '21.28', '2', '0');
1336 INSERT INTO `0_sales_order_details` VALUES ('5', '5', '30', '102', '17inch VGA Monitor', '1', '50', '1', '0');
1339 ### Structure of table `0_sales_orders` ###
1341 DROP TABLE IF EXISTS `0_sales_orders`;
1343 CREATE TABLE `0_sales_orders` (
1344 `order_no` int(11) NOT NULL,
1345 `trans_type` smallint(6) NOT NULL default '30',
1346 `version` tinyint(1) unsigned NOT NULL default '0',
1347 `type` tinyint(1) NOT NULL default '0',
1348 `debtor_no` int(11) NOT NULL default '0',
1349 `branch_code` int(11) NOT NULL default '0',
1350 `reference` varchar(100) NOT NULL default '',
1351 `customer_ref` tinytext NOT NULL,
1352 `comments` tinytext,
1353 `ord_date` date NOT NULL default '0000-00-00',
1354 `order_type` int(11) NOT NULL default '0',
1355 `ship_via` int(11) NOT NULL default '0',
1356 `delivery_address` tinytext NOT NULL,
1357 `contact_phone` varchar(30) default NULL,
1358 `contact_email` varchar(100) default NULL,
1359 `deliver_to` tinytext NOT NULL,
1360 `freight_cost` double NOT NULL default '0',
1361 `from_stk_loc` varchar(5) NOT NULL default '',
1362 `delivery_date` date NOT NULL default '0000-00-00',
1363 `payment_terms` int(11) default NULL,
1364 PRIMARY KEY (`trans_type`, `order_no`)
1367 ### Data of table `0_sales_orders` ###
1369 INSERT INTO `0_sales_orders` VALUES ('1', '30', '1', '0', '1', '1', '1', '', '', '2009-06-21', '2', '1', 'Address 1\r\nAddress 2\r\nAddress 3', '', '', 'Beefeater Ltd.', '10', 'DEF', '2009-06-22','3');
1370 INSERT INTO `0_sales_orders` VALUES ('2', '30', '1', '0', '2', '2', '2', '', '', '2009-06-21', '1', '1', 'Address 1\r\nAddress 2\r\nAddress 3', '', '', 'Ghostbusters Corp.', '0', 'DEF', '2009-06-22','4');
1371 INSERT INTO `0_sales_orders` VALUES ('3', '30', '1', '0', '3', '3', '3', '', '', '2009-06-21', '2', '1', 'Address 1\r\nAddress 2\r\nAddress 3', '', '', 'Brezan', '0', 'DEF', '2009-07-01','3');
1372 INSERT INTO `0_sales_orders` VALUES ('4', '30', '0', '0', '1', '1', '4', '', '', '2009-06-21', '2', '1', 'Address 1\r\nAddress 2\r\nAddress 3', '', '', 'Beefeater Ltd.', '0', 'DEF', '2009-06-22','3');
1373 INSERT INTO `0_sales_orders` VALUES ('5', '30', '1', '0', '2', '2', '5', '', '', '2009-06-21', '1', '1', 'Address 1\r\nAddress 2\r\nAddress 3', '', '', 'Ghostbusters Corp.', '5', 'DEF', '2009-06-22','4');
1376 ### Structure of table `0_sales_pos` ###
1378 DROP TABLE IF EXISTS `0_sales_pos`;
1380 CREATE TABLE `0_sales_pos` (
1381 `id` smallint(6) unsigned NOT NULL auto_increment,
1382 `pos_name` varchar(30) NOT NULL,
1383 `cash_sale` tinyint(1) NOT NULL,
1384 `credit_sale` tinyint(1) NOT NULL,
1385 `pos_location` varchar(5) NOT NULL,
1386 `pos_account` smallint(6) unsigned NOT NULL,
1387 `inactive` tinyint(1) NOT NULL default '0',
1389 UNIQUE KEY `pos_name` (`pos_name`)
1390 ) TYPE=MyISAM AUTO_INCREMENT=2 ;
1393 ### Data of table `0_sales_pos` ###
1395 INSERT INTO `0_sales_pos` VALUES ('1', 'Default', '1', '1', 'DEF', '2', '0');
1398 ### Structure of table `0_sales_types` ###
1400 DROP TABLE IF EXISTS `0_sales_types`;
1402 CREATE TABLE `0_sales_types` (
1403 `id` int(11) NOT NULL auto_increment,
1404 `sales_type` char(50) NOT NULL default '',
1405 `tax_included` int(1) NOT NULL default '0',
1406 `factor` double NOT NULL default '1',
1407 `inactive` tinyint(1) NOT NULL default '0',
1409 UNIQUE KEY `sales_type` (`sales_type`)
1410 ) TYPE=MyISAM AUTO_INCREMENT=3 ;
1413 ### Data of table `0_sales_types` ###
1415 INSERT INTO `0_sales_types` VALUES ('1', 'Retail', '1', '1', '0');
1416 INSERT INTO `0_sales_types` VALUES ('2', 'Wholesale', '0', '0.7', '0');
1419 ### Structure of table `0_salesman` ###
1421 DROP TABLE IF EXISTS `0_salesman`;
1423 CREATE TABLE `0_salesman` (
1424 `salesman_code` int(11) NOT NULL auto_increment,
1425 `salesman_name` char(60) NOT NULL default '',
1426 `salesman_phone` char(30) NOT NULL default '',
1427 `salesman_fax` char(30) NOT NULL default '',
1428 `salesman_email` varchar(100) NOT NULL default '',
1429 `provision` double NOT NULL default '0',
1430 `break_pt` double NOT NULL default '0',
1431 `provision2` double NOT NULL default '0',
1432 `inactive` tinyint(1) NOT NULL default '0',
1433 PRIMARY KEY (`salesman_code`),
1434 UNIQUE KEY `salesman_name` (`salesman_name`)
1435 ) TYPE=MyISAM AUTO_INCREMENT=2 ;
1438 ### Data of table `0_salesman` ###
1440 INSERT INTO `0_salesman` VALUES ('1', 'Sales Person', '', '', '', '5', '1000', '4', '0');
1442 ### Structure of table `0_security_roles` ###
1444 DROP TABLE IF EXISTS `0_security_roles`;
1445 CREATE TABLE IF NOT EXISTS `0_security_roles` (
1446 `id` int(11) NOT NULL auto_increment,
1447 `role` varchar(30) NOT NULL,
1448 `description` varchar(50) default NULL,
1451 `inactive` tinyint(1) NOT NULL default '0',
1453 UNIQUE KEY `role` (`role`)
1454 ) TYPE=MyISAM AUTO_INCREMENT=11 ;
1457 -- Data of table `0_security_roles`
1460 INSERT INTO `0_security_roles` VALUES (1, 'Inquiries', 'Inquiries', '768;2816;3072;3328;5632;5888;8192;8448;10752;11008;13312;15872;16128', '257;258;259;260;513;514;515;516;517;518;519;520;521;522;523;524;525;773;774;2822;3073;3075;3076;3077;3329;3330;3331;3332;3333;3334;3335;5377;5633;5640;5889;5890;5891;7937;7938;7939;7940;8193;8194;8450;8451;10497;10753;11009;11010;11012;13313;13315;15617;15618;15619;15620;15621;15622;15623;15624;15625;15626;15873;15882;16129;16130;16131;16132', 0);
1461 INSERT INTO `0_security_roles` VALUES (2, 'System Administrator', 'System Administrator', '256;512;768;2816;3072;3328;5376;5632;5888;7936;8192;8448;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;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;10497;10753;10754;10755;10756;10757;11009;11010;11012;13057;13313;13314;13315;15617;15618;15619;15620;15621;15622;15623;15624;15625;15626;15627;15873;15874;15875;15876;15877;15878;15879;15880;15883;15881;15882;16129;16130;16131;16132', 0);
1462 INSERT INTO `0_security_roles` VALUES (3, 'Salesman', 'Salesman', '768;3072;5632;8192;15872', '773;774;3073;3075;3081;5633;8194;15873', 0);
1463 INSERT INTO `0_security_roles` VALUES (4, 'Stock Manager', 'Stock Manager', '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', 0);
1464 INSERT INTO `0_security_roles` VALUES (5, 'Production Manager', 'Production Manager', '512;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', 0);
1465 INSERT INTO `0_security_roles` VALUES (6, 'Purchase Officer', 'Purchase Officer', '512;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', 0);
1466 INSERT INTO `0_security_roles` VALUES (7, 'AR Officer', 'AR Officer', '512;768;2816;3072;3328;5632;5888;8192;8448;10752;11008;13312;15616;15872;16128', '521;523;524;771;773;774;2818;2819;2820;2821;2822;2823;3073;3073;3074;3075;3076;3077;3078;3079;3080;3081;3081;3329;3330;3330;3330;3331;3331;3332;3333;3334;3335;5633;5633;5634;5637;5638;5639;5640;5640;5889;5890;5891;8193;8194;8194;8196;8197;8450;8451;10753;10755;11009;11010;11012;13313;13315;15617;15619;15620;15621;15624;15624;15873;15876;15877;15878;15880;15882;16129;16130;16131;16132', 0);
1467 INSERT INTO `0_security_roles` VALUES (8, 'AP Officer', 'AP Officer', '512;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', 0);
1468 INSERT INTO `0_security_roles` VALUES (9, 'Accountant', 'New Accountant', '512;768;2816;3072;3328;5376;5632;5888;8192;8448;10752;11008;13312;15616;15872;16128', '257;258;259;260;521;523;524;771;772;773;774;2818;2819;2820;2821;2822;2823;3073;3074;3075;3076;3077;3078;3079;3080;3081;3329;3330;3331;3332;3333;3334;3335;5377;5633;5634;5635;5637;5638;5639;5640;5889;5890;5891;7937;7938;7939;7940;8193;8194;8196;8197;8449;8450;8451;10497;10753;10755;11009;11010;11012;13313;13315;15617;15618;15619;15620;15621;15624;15873;15876;15877;15878;15880;15882;16129;16130;16131;16132', 0);
1469 INSERT INTO `0_security_roles` VALUES (10, 'Sub Admin', 'Sub Admin', '512;768;2816;3072;3328;5376;5632;5888;8192;8448;10752;11008;13312;15616;15872;16128', '257;258;259;260;521;523;524;771;772;773;774;2818;2819;2820;2821;2822;2823;3073;3074;3082;3075;3076;3077;3078;3079;3080;3081;3329;3330;3331;3332;3333;3334;3335;5377;5633;5634;5635;5637;5638;5639;5640;5889;5890;5891;7937;7938;7939;7940;8193;8194;8196;8197;8449;8450;8451;10497;10753;10755;11009;11010;11012;13057;13313;13315;15617;15619;15620;15621;15624;15873;15874;15876;15877;15878;15879;15880;15882;16129;16130;16131;16132', 0);
1471 ### Structure of table `0_shippers` ###
1473 DROP TABLE IF EXISTS `0_shippers`;
1475 CREATE TABLE `0_shippers` (
1476 `shipper_id` int(11) NOT NULL auto_increment,
1477 `shipper_name` varchar(60) NOT NULL default '',
1478 `phone` varchar(30) NOT NULL default '',
1479 `phone2` varchar(30) NOT NULL default '',
1480 `contact` tinytext NOT NULL,
1481 `address` tinytext NOT NULL,
1482 `inactive` tinyint(1) NOT NULL default '0',
1483 PRIMARY KEY (`shipper_id`),
1484 UNIQUE KEY `name` (`shipper_name`)
1485 ) TYPE=MyISAM AUTO_INCREMENT=2 ;
1488 ### Data of table `0_shippers` ###
1490 INSERT INTO `0_shippers` VALUES ('1', 'Default', '', '', '', '', '0');
1493 ### Structure of table `0_sql_trail` ###
1495 DROP TABLE IF EXISTS `0_sql_trail`;
1497 CREATE TABLE `0_sql_trail` (
1498 `id` int(11) unsigned NOT NULL auto_increment,
1499 `sql` text NOT NULL,
1500 `result` tinyint(1) NOT NULL,
1501 `msg` varchar(255) NOT NULL,
1503 ) TYPE=MyISAM AUTO_INCREMENT=1 ;
1506 ### Data of table `0_sql_trail` ###
1510 ### Structure of table `0_stock_category` ###
1512 DROP TABLE IF EXISTS `0_stock_category`;
1514 CREATE TABLE `0_stock_category` (
1515 `category_id` int(11) NOT NULL auto_increment,
1516 `description` varchar(60) NOT NULL default '',
1517 `dflt_tax_type` int(11) NOT NULL default '1',
1518 `dflt_units` varchar(20) NOT NULL default 'each',
1519 `dflt_mb_flag` char(1) NOT NULL default 'B',
1520 `dflt_sales_act` varchar(15) NOT NULL default '',
1521 `dflt_cogs_act` varchar(15) NOT NULL default '',
1522 `dflt_inventory_act` varchar(15) NOT NULL default '',
1523 `dflt_adjustment_act` varchar(15) NOT NULL default '',
1524 `dflt_assembly_act` varchar(15) NOT NULL default '',
1525 `dflt_dim1` int(11) default NULL,
1526 `dflt_dim2` int(11) default NULL,
1527 `inactive` tinyint(1) NOT NULL default '0',
1528 `dflt_no_sale` tinyint(1) NOT NULL default '0',
1529 PRIMARY KEY (`category_id`),
1530 UNIQUE KEY `description` (`description`)
1531 ) TYPE=MyISAM AUTO_INCREMENT=5 ;
1533 ### Data of table `0_stock_category` ###
1535 INSERT INTO `0_stock_category` VALUES ('1', 'Components', '1', 'each', 'B', '4010', '5010', '1510', '5040', '1530', '0', '0', '0', '0');
1536 INSERT INTO `0_stock_category` VALUES ('2', 'Charges', '1', 'each', 'D', '4010', '5010', '1510', '5040', '1530', '0', '0', '0', '0');
1537 INSERT INTO `0_stock_category` VALUES ('3', 'Systems', '1', 'each', 'M', '4010', '5010', '1510', '5040', '1530', '0', '0', '0', '0');
1538 INSERT INTO `0_stock_category` VALUES ('4', 'Services', '1', 'hrs', 'D', '4010', '5010', '1510', '5040', '1530', '0', '0', '0', '0');
1541 ### Structure of table `0_stock_master` ###
1543 DROP TABLE IF EXISTS `0_stock_master`;
1545 CREATE TABLE `0_stock_master` (
1546 `stock_id` varchar(20) NOT NULL default '',
1547 `category_id` int(11) NOT NULL default '0',
1548 `tax_type_id` int(11) NOT NULL default '0',
1549 `description` varchar(200) NOT NULL default '',
1550 `long_description` tinytext NOT NULL,
1551 `units` varchar(20) NOT NULL default 'each',
1552 `mb_flag` char(1) NOT NULL default 'B',
1553 `sales_account` varchar(15) NOT NULL default '',
1554 `cogs_account` varchar(15) NOT NULL default '',
1555 `inventory_account` varchar(15) NOT NULL default '',
1556 `adjustment_account` varchar(15) NOT NULL default '',
1557 `assembly_account` varchar(15) NOT NULL default '',
1558 `dimension_id` int(11) default NULL,
1559 `dimension2_id` int(11) default NULL,
1560 `actual_cost` double NOT NULL default '0',
1561 `last_cost` double NOT NULL default '0',
1562 `material_cost` double NOT NULL default '0',
1563 `labour_cost` double NOT NULL default '0',
1564 `overhead_cost` double NOT NULL default '0',
1565 `inactive` tinyint(1) NOT NULL default '0',
1566 `no_sale` tinyint(1) NOT NULL default '0',
1567 `editable` tinyint(1) NOT NULL default '0',
1568 PRIMARY KEY (`stock_id`)
1572 ### Data of table `0_stock_master` ###
1574 INSERT INTO `0_stock_master` VALUES ('102', '1', '1', '17inch VGA Monitor', '', 'ea.', 'B', '4010', '5010', '1510', '5040', '1530', '0', '0', '0', '0', '10', '0', '0', '0', '0', '0');
1575 INSERT INTO `0_stock_master` VALUES ('103', '1', '1', '32MB VGA Card', '', 'ea.', 'B', '4010', '5010', '1510', '5040', '1530', '0', '0', '0', '0', '11', '0', '0', '0', '0', '0');
1576 INSERT INTO `0_stock_master` VALUES ('104', '1', '1', '52x CD Drive', '', 'ea.', 'B', '4010', '5010', '1510', '5040', '1530', '0', '0', '0', '0', '12', '0', '0', '0', '0', '0');
1577 INSERT INTO `0_stock_master` VALUES ('201', '4', '1', 'Assembly Labour', '', 'hrs', 'D', '4010', '5010', '5010', '5040', '1530', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');
1578 INSERT INTO `0_stock_master` VALUES ('3400', '3', '1', 'P4 Business System', '', 'ea.', 'M', '4010', '5010', '1540', '5040', '1530', '0', '0', '0', '0', '33', '3.9999999999999', '2', '0', '0', '0');
1581 ### Structure of table `0_stock_moves` ###
1583 DROP TABLE IF EXISTS `0_stock_moves`;
1585 CREATE TABLE `0_stock_moves` (
1586 `trans_id` int(11) NOT NULL auto_increment,
1587 `trans_no` int(11) NOT NULL default '0',
1588 `stock_id` char(20) NOT NULL default '',
1589 `type` smallint(6) NOT NULL default '0',
1590 `loc_code` char(5) NOT NULL default '',
1591 `tran_date` date NOT NULL default '0000-00-00',
1592 `person_id` int(11) default NULL,
1593 `price` double NOT NULL default '0',
1594 `reference` char(40) NOT NULL default '',
1595 `qty` double NOT NULL default '1',
1596 `discount_percent` double NOT NULL default '0',
1597 `standard_cost` double NOT NULL default '0',
1598 `visible` tinyint(1) NOT NULL default '1',
1599 PRIMARY KEY (`trans_id`),
1600 KEY `type` (`type`,`trans_no`),
1601 KEY `Move` (`stock_id`,`loc_code`, `tran_date`)
1602 ) TYPE=InnoDB AUTO_INCREMENT=37 ;
1605 ### Data of table `0_stock_moves` ###
1607 INSERT INTO `0_stock_moves` VALUES ('1', '1', '102', '25', 'DEF', '2009-06-21', '2', '10', '', '100', '0', '10', '1');
1608 INSERT INTO `0_stock_moves` VALUES ('2', '1', '103', '25', 'DEF', '2009-06-21', '2', '11', '', '100', '0', '11', '1');
1609 INSERT INTO `0_stock_moves` VALUES ('3', '1', '104', '25', 'DEF', '2009-06-21', '2', '12', '', '100', '0', '12', '1');
1610 INSERT INTO `0_stock_moves` VALUES ('4', '1', '102', '26', 'DEF', '2009-06-21', '0', '0', '1', '-10', '0', '0', '1');
1611 INSERT INTO `0_stock_moves` VALUES ('5', '1', '103', '26', 'DEF', '2009-06-21', '0', '0', '1', '-10', '0', '0', '1');
1612 INSERT INTO `0_stock_moves` VALUES ('6', '1', '104', '26', 'DEF', '2009-06-21', '0', '0', '1', '-10', '0', '0', '1');
1613 INSERT INTO `0_stock_moves` VALUES ('7', '1', '3400', '26', 'DEF', '2009-06-21', '0', '0', '1', '10', '0', '0', '1');
1614 INSERT INTO `0_stock_moves` VALUES ('8', '2', '102', '13', 'DEF', '2009-06-21', '0', '30.4', '1', '-2', '0', '10', '1');
1615 INSERT INTO `0_stock_moves` VALUES ('9', '3', '102', '13', 'DEF', '2009-06-21', '0', '50', 'auto', '-1', '0', '10', '1');
1616 INSERT INTO `0_stock_moves` VALUES ('10', '4', '102', '13', 'DEF', '2009-06-21', '0', '35.89', 'auto', '-1', '0', '10', '1');
1617 INSERT INTO `0_stock_moves` VALUES ('11', '3', '102', '26', 'DEF', '2009-06-21', '0', '0', '3', '-2', '0', '0', '1');
1618 INSERT INTO `0_stock_moves` VALUES ('12', '3', '103', '26', 'DEF', '2009-06-21', '0', '0', '3', '-2', '0', '0', '1');
1619 INSERT INTO `0_stock_moves` VALUES ('13', '3', '104', '26', 'DEF', '2009-06-21', '0', '0', '3', '-2', '0', '0', '1');
1620 INSERT INTO `0_stock_moves` VALUES ('14', '3', '3400', '26', 'DEF', '2009-06-21', '0', '0', '3', '2', '0', '0', '1');
1621 INSERT INTO `0_stock_moves` VALUES ('15', '4', '102', '26', 'DEF', '2009-06-21', '0', '0', '4', '-4', '0', '0', '1');
1622 INSERT INTO `0_stock_moves` VALUES ('16', '4', '103', '26', 'DEF', '2009-06-21', '0', '0', '4', '-4', '0', '0', '1');
1623 INSERT INTO `0_stock_moves` VALUES ('17', '4', '104', '26', 'DEF', '2009-06-21', '0', '0', '4', '-4', '0', '0', '1');
1624 INSERT INTO `0_stock_moves` VALUES ('18', '4', '3400', '26', 'DEF', '2009-06-21', '0', '0', '4', '4', '0', '0', '1');
1625 INSERT INTO `0_stock_moves` VALUES ('19', '2', '102', '26', 'DEF', '2009-06-21', '0', '0', '', '-2', '0', '0', '1');
1626 INSERT INTO `0_stock_moves` VALUES ('20', '2', '103', '26', 'DEF', '2009-06-21', '0', '0', '', '-2', '0', '0', '1');
1627 INSERT INTO `0_stock_moves` VALUES ('21', '2', '104', '26', 'DEF', '2009-06-21', '0', '0', '', '-2', '0', '0', '1');
1628 INSERT INTO `0_stock_moves` VALUES ('22', '1', '3400', '29', 'DEF', '2009-06-21', '0', '0', '', '2', '0', '0', '1');
1629 INSERT INTO `0_stock_moves` VALUES ('23', '5', '102', '26', 'DEF', '2009-06-21', '0', '0', '5', '-5', '0', '0', '1');
1630 INSERT INTO `0_stock_moves` VALUES ('24', '5', '103', '26', 'DEF', '2009-06-21', '0', '0', '5', '-5', '0', '0', '1');
1631 INSERT INTO `0_stock_moves` VALUES ('25', '5', '104', '26', 'DEF', '2009-06-21', '0', '0', '5', '-5', '0', '0', '1');
1632 INSERT INTO `0_stock_moves` VALUES ('26', '5', '3400', '26', 'DEF', '2009-06-21', '0', '0', '5', '5', '0', '0', '1');
1633 INSERT INTO `0_stock_moves` VALUES ('27', '6', '102', '26', 'DEF', '2009-06-21', '0', '0', '6', '5', '0', '0', '1');
1634 INSERT INTO `0_stock_moves` VALUES ('28', '6', '103', '26', 'DEF', '2009-06-21', '0', '0', '6', '5', '0', '0', '1');
1635 INSERT INTO `0_stock_moves` VALUES ('29', '6', '104', '26', 'DEF', '2009-06-21', '0', '0', '6', '5', '0', '0', '1');
1636 INSERT INTO `0_stock_moves` VALUES ('30', '6', '3400', '26', 'DEF', '2009-06-21', '0', '0', '6', '-5', '0', '0', '1');
1637 INSERT INTO `0_stock_moves` VALUES ('31', '7', '102', '26', 'DEF', '2009-06-21', '0', '0', '7', '2', '0', '0', '1');
1638 INSERT INTO `0_stock_moves` VALUES ('32', '7', '103', '26', 'DEF', '2009-06-21', '0', '0', '7', '2', '0', '0', '1');
1639 INSERT INTO `0_stock_moves` VALUES ('33', '7', '104', '26', 'DEF', '2009-06-21', '0', '0', '7', '2', '0', '0', '1');
1640 INSERT INTO `0_stock_moves` VALUES ('34', '7', '3400', '26', 'DEF', '2009-06-21', '0', '0', '7', '-2', '0', '0', '1');
1641 INSERT INTO `0_stock_moves` VALUES ('35', '5', '102', '13', 'DEF', '2009-06-21', '0', '50', 'auto', '-1', '0', '10', '1');
1642 INSERT INTO `0_stock_moves` VALUES ('36', '3', '102', '11', 'DEF', '2009-06-21', '0', '37.68', 'Return Ex Inv: 18', '1', '0', '10', '0');
1645 ### Structure of table `0_supp_allocations` ###
1647 DROP TABLE IF EXISTS `0_supp_allocations`;
1649 CREATE TABLE `0_supp_allocations` (
1650 `id` int(11) NOT NULL auto_increment,
1651 `amt` double unsigned default NULL,
1652 `date_alloc` date NOT NULL default '0000-00-00',
1653 `trans_no_from` int(11) default NULL,
1654 `trans_type_from` int(11) default NULL,
1655 `trans_no_to` int(11) default NULL,
1656 `trans_type_to` int(11) default NULL,
1658 KEY `From` (`trans_type_from`, `trans_no_from`),
1659 KEY `To` (`trans_type_to`, `trans_no_to`)
1660 ) TYPE=InnoDB AUTO_INCREMENT=2 ;
1663 ### Data of table `0_supp_allocations` ###
1665 INSERT INTO `0_supp_allocations` VALUES ('1', '3465', '2009-06-21', '4', '22', '7', '20');
1668 ### Structure of table `0_supp_invoice_items` ###
1670 DROP TABLE IF EXISTS `0_supp_invoice_items`;
1672 CREATE TABLE `0_supp_invoice_items` (
1673 `id` int(11) NOT NULL auto_increment,
1674 `supp_trans_no` int(11) default NULL,
1675 `supp_trans_type` int(11) default NULL,
1676 `gl_code` varchar(15) NOT NULL default '0',
1677 `grn_item_id` int(11) default NULL,
1678 `po_detail_item_id` int(11) default NULL,
1679 `stock_id` varchar(20) NOT NULL default '',
1680 `description` tinytext,
1681 `quantity` double NOT NULL default '0',
1682 `unit_price` double NOT NULL default '0',
1683 `unit_tax` double NOT NULL default '0',
1686 KEY `Transaction` (`supp_trans_type`, `supp_trans_no`, `stock_id`)
1687 ) TYPE=InnoDB AUTO_INCREMENT=6 ;
1690 ### Data of table `0_supp_invoice_items` ###
1692 INSERT INTO `0_supp_invoice_items` VALUES ('1', '7', '20', '0', '1', '1', '102', '17inch VGA Monitor', '100', '10', '0.5', '');
1693 INSERT INTO `0_supp_invoice_items` VALUES ('2', '7', '20', '0', '2', '2', '103', '32MB VGA Card', '100', '11', '0.55', '');
1694 INSERT INTO `0_supp_invoice_items` VALUES ('3', '7', '20', '0', '3', '3', '104', '52x CD Drive', '100', '12', '0.6', '');
1695 INSERT INTO `0_supp_invoice_items` VALUES ('4', '8', '20', '2150', '0', '0', '', '', '0', '0.95', '0', 'Phone');
1696 INSERT INTO `0_supp_invoice_items` VALUES ('5', '8', '20', '5780', '0', '0', '', '', '0', '19.05', '0', 'Phone');
1699 ### Structure of table `0_supp_trans` ###
1701 DROP TABLE IF EXISTS `0_supp_trans`;
1703 CREATE TABLE `0_supp_trans` (
1704 `trans_no` int(11) unsigned NOT NULL default '0',
1705 `type` smallint(6) unsigned NOT NULL default '0',
1706 `supplier_id` int(11) unsigned default NULL,
1707 `reference` tinytext NOT NULL,
1708 `supp_reference` varchar(60) NOT NULL default '',
1709 `tran_date` date NOT NULL default '0000-00-00',
1710 `due_date` date NOT NULL default '0000-00-00',
1711 `ov_amount` double NOT NULL default '0',
1712 `ov_discount` double NOT NULL default '0',
1713 `ov_gst` double NOT NULL default '0',
1714 `rate` double NOT NULL default '1',
1715 `alloc` double NOT NULL default '0',
1716 PRIMARY KEY (`type`, `trans_no`),
1717 KEY `supplier_id` (`supplier_id`),
1718 KEY `SupplierID_2` (`supplier_id`,`supp_reference`),
1719 KEY `type` (`type`),
1724 ### Data of table `0_supp_trans` ###
1726 INSERT INTO `0_supp_trans` VALUES ('4', '22', '2', '1', '', '2009-06-21', '2009-06-21', '-3465', '0', '0', '1', '3465');
1727 INSERT INTO `0_supp_trans` VALUES ('7', '20', '2', '1', '5t', '2009-06-21', '2009-07-01', '3300', '0', '165', '1', '3465');
1728 INSERT INTO `0_supp_trans` VALUES ('8', '20', '2', '2', 'cc', '2009-06-21', '2009-07-01', '20', '0', '0', '1', '0');
1731 ### Structure of table `0_suppliers` ###
1733 DROP TABLE IF EXISTS `0_suppliers`;
1735 CREATE TABLE `0_suppliers` (
1736 `supplier_id` int(11) NOT NULL auto_increment,
1737 `supp_name` varchar(60) NOT NULL default '',
1738 `supp_ref` varchar(30) NOT NULL default '',
1739 `address` tinytext NOT NULL,
1740 `supp_address` tinytext NOT NULL,
1741 `phone` varchar(30) NOT NULL default '',
1742 `phone2` varchar(30) NOT NULL default '',
1743 `fax` varchar(30) NOT NULL default '',
1744 `gst_no` varchar(25) NOT NULL default '',
1745 `contact` varchar(60) NOT NULL default '',
1746 `supp_account_no` varchar(40) NOT NULL default '',
1747 `email` varchar(100) NOT NULL default '',
1748 `website` varchar(100) NOT NULL default '',
1749 `bank_account` varchar(60) NOT NULL default '',
1750 `curr_code` char(3) default NULL,
1751 `rep_lang` char(5) default NULL,
1752 `payment_terms` int(11) default NULL,
1753 `dimension_id` int(11) default '0',
1754 `dimension2_id` int(11) default '0',
1755 `tax_group_id` int(11) default NULL,
1756 `credit_limit` double NOT NULL default '0',
1757 `purchase_account` varchar(15) default NULL,
1758 `payable_account` varchar(15) default NULL,
1759 `payment_discount_account` varchar(15) default NULL,
1760 `notes` tinytext NOT NULL,
1761 `inactive` tinyint(1) NOT NULL default '0',
1762 PRIMARY KEY (`supplier_id`),
1764 ) TYPE=MyISAM AUTO_INCREMENT=4 ;
1767 ### Data of table `0_suppliers` ###
1769 INSERT INTO `0_suppliers` VALUES ('1', 'Junk Beer ApS', 'Junk Beer', 'Mailing 1\r\nMailing 2\r\nMailing 3', 'Address 1\r\nAddress 2\r\nAddress 3', '+45 55667788', '', '', '123456', 'Contact', '111', '', '', '', 'DKK', '', '3', '1', '0', '2', '1', '5010', '2100', '5060', 'A supplier with junk beers.', '0');
1770 INSERT INTO `0_suppliers` VALUES ('2', 'Lucky Luke Inc.', 'Lucky Luke', 'Mailing 1\r\nMailing 2\r\nMailing 3', 'Address 1\r\nAddress 2\r\nAddress 3', '(111) 222.333.444', '', '', '654321', 'Luke', '333', '', '', '', 'USD', '', '3', '0', '0', '1', '1', '5010', '2100', '5060', '', '0');
1771 INSERT INTO `0_suppliers` VALUES ('3', 'Money Makers Ltd.', 'Money Makers', 'Mailing 1\r\nMailing 2\r\nMailing 3', 'Address 1\r\nAddress 2\r\nAddress 3', '+44 444 555 666', '', '', '987654', 'Makers', '222', '', '', '', 'GBP', '', '3', '0', '0', '2', '1', '5010', '2100', '5060', '', '0');
1773 ### Structure of table `0_sys_prefs` ###
1775 DROP TABLE IF EXISTS `0_sys_prefs`;
1777 CREATE TABLE `0_sys_prefs` (
1778 `name` varchar(35) NOT NULL default '',
1779 `category` varchar(30) default NULL,
1780 `type` varchar(20) NOT NULL default 'varchar',
1781 `length` smallint(6) default NULL,
1783 PRIMARY KEY (`name`),
1784 KEY `category` (`category`)
1788 ### Data of table `0_sys_prefs` ###
1790 INSERT INTO `0_sys_prefs` VALUES ('coy_name', 'setup.company', 'varchar', '60', 'Training Co.');
1791 INSERT INTO `0_sys_prefs` VALUES ('gst_no', 'setup.company', 'varchar', '25', '9876543');
1792 INSERT INTO `0_sys_prefs` VALUES ('coy_no', 'setup.company', 'varchar', '25', '123456789');
1793 INSERT INTO `0_sys_prefs` VALUES ('tax_prd', 'setup.company', 'int', '11', '1');
1794 INSERT INTO `0_sys_prefs` VALUES ('tax_last', 'setup.company', 'int', '11', '1');
1795 INSERT INTO `0_sys_prefs` VALUES ('postal_address', 'setup.company', 'tinytext', '0', 'Address 1\r\nAddress 2\r\nAddress 3');
1796 INSERT INTO `0_sys_prefs` VALUES ('phone', 'setup.company', 'varchar', '30', '(222) 111.222.333');
1797 INSERT INTO `0_sys_prefs` VALUES ('fax', 'setup.company', 'varchar', '30', NULL);
1798 INSERT INTO `0_sys_prefs` VALUES ('email', 'setup.company', 'varchar', '100', 'delta@delta.com');
1799 INSERT INTO `0_sys_prefs` VALUES ('coy_logo', 'setup.company', 'varchar', '100', 'logo_frontaccounting.jpg');
1800 INSERT INTO `0_sys_prefs` VALUES ('domicile', 'setup.company', 'varchar', '55', NULL);
1801 INSERT INTO `0_sys_prefs` VALUES ('curr_default', 'setup.company', 'char', '3', 'USD');
1802 INSERT INTO `0_sys_prefs` VALUES ('use_dimension', 'setup.company', 'tinyint', '1', '1');
1803 INSERT INTO `0_sys_prefs` VALUES ('f_year', 'setup.company', 'int', '11', '2');
1804 INSERT INTO `0_sys_prefs` VALUES ('no_item_list', 'setup.company', 'tinyint', '1', '0');
1805 INSERT INTO `0_sys_prefs` VALUES ('no_customer_list', 'setup.company', 'tinyint', '1', '0');
1806 INSERT INTO `0_sys_prefs` VALUES ('no_supplier_list', 'setup.company', 'tinyint', '1', '0');
1807 INSERT INTO `0_sys_prefs` VALUES ('base_sales', 'setup.company', 'int', '11', '1');
1808 INSERT INTO `0_sys_prefs` VALUES ('time_zone', 'setup.company', 'tinyint', '1', '0');
1809 INSERT INTO `0_sys_prefs` VALUES ('add_pct', 'setup.company', 'int', '5', '-1');
1810 INSERT INTO `0_sys_prefs` VALUES ('round_to', 'setup.company', 'int', '5', '1');
1811 INSERT INTO `0_sys_prefs` VALUES ('login_tout', 'setup.company', 'smallint', '6', '600');
1812 INSERT INTO `0_sys_prefs` VALUES ('auto_curr_reval','setup.company', 'smallint','6', '1');
1813 INSERT INTO `0_sys_prefs` VALUES ('past_due_days', 'glsetup.general', 'int', '11', '30');
1814 INSERT INTO `0_sys_prefs` VALUES ('profit_loss_year_act', 'glsetup.general', 'varchar', '15', '9990');
1815 INSERT INTO `0_sys_prefs` VALUES ('retained_earnings_act', 'glsetup.general', 'varchar', '15', '3590');
1816 INSERT INTO `0_sys_prefs` VALUES ('bank_charge_act', 'glsetup.general', 'varchar', '15', '5690');
1817 INSERT INTO `0_sys_prefs` VALUES ('exchange_diff_act', 'glsetup.general', 'varchar', '15', '4450');
1818 INSERT INTO `0_sys_prefs` VALUES ('default_credit_limit', 'glsetup.customer', 'int', '15', '1000');
1819 INSERT INTO `0_sys_prefs` VALUES ('accumulate_shipping', 'glsetup.customer', 'tinyint', '1', '0');
1820 INSERT INTO `0_sys_prefs` VALUES ('legal_text', 'glsetup.customer', 'tinytext', '0', NULL);
1821 INSERT INTO `0_sys_prefs` VALUES ('freight_act', 'glsetup.customer', 'varchar', '15', '4430');
1822 INSERT INTO `0_sys_prefs` VALUES ('debtors_act', 'glsetup.sales', 'varchar', '15', '1200');
1823 INSERT INTO `0_sys_prefs` VALUES ('default_sales_act', 'glsetup.sales', 'varchar', '15', '4010');
1824 INSERT INTO `0_sys_prefs` VALUES ('default_sales_discount_act', 'glsetup.sales', 'varchar', '15', '4510');
1825 INSERT INTO `0_sys_prefs` VALUES ('default_prompt_payment_act', 'glsetup.sales', 'varchar', '15', '4500');
1826 INSERT INTO `0_sys_prefs` VALUES ('default_delivery_required', 'glsetup.sales', 'smallint', '6', '1');
1827 INSERT INTO `0_sys_prefs` VALUES ('default_dim_required', 'glsetup.dims', 'int', '11', '20');
1828 INSERT INTO `0_sys_prefs` VALUES ('pyt_discount_act', 'glsetup.purchase', 'varchar', '15', '5060');
1829 INSERT INTO `0_sys_prefs` VALUES ('creditors_act', 'glsetup.purchase', 'varchar', '15', '2100');
1830 INSERT INTO `0_sys_prefs` VALUES ('po_over_receive', 'glsetup.purchase', 'int', '11', '10');
1831 INSERT INTO `0_sys_prefs` VALUES ('po_over_charge', 'glsetup.purchase', 'int', '11', '10');
1832 INSERT INTO `0_sys_prefs` VALUES ('allow_negative_stock', 'glsetup.inventory', 'tinyint', '1', '0');
1833 INSERT INTO `0_sys_prefs` VALUES ('default_inventory_act', 'glsetup.items', 'varchar', '15', '1510');
1834 INSERT INTO `0_sys_prefs` VALUES ('default_cogs_act', 'glsetup.items', 'varchar', '15', '5010');
1835 INSERT INTO `0_sys_prefs` VALUES ('default_adj_act', 'glsetup.items', 'varchar', '15', '5040');
1836 INSERT INTO `0_sys_prefs` VALUES ('default_inv_sales_act', 'glsetup.items', 'varchar', '15', '4010');
1837 INSERT INTO `0_sys_prefs` VALUES ('default_assembly_act', 'glsetup.items', 'varchar', '15', '1530');
1838 INSERT INTO `0_sys_prefs` VALUES ('default_workorder_required', 'glsetup.manuf', 'int', '11', '20');
1839 INSERT INTO `0_sys_prefs` VALUES ('version_id', 'system', 'varchar', '11', '2.3');
1843 ### Structure of table `0_sys_types` ###
1845 DROP TABLE IF EXISTS `0_sys_types`;
1847 CREATE TABLE `0_sys_types` (
1848 `type_id` smallint(6) NOT NULL default '0',
1849 `type_no` int(11) NOT NULL default '1',
1850 `next_reference` varchar(100) NOT NULL default '',
1851 PRIMARY KEY (`type_id`)
1855 ### Data of table `0_sys_types` ###
1857 INSERT INTO `0_sys_types` VALUES ('0', '19', '3');
1858 INSERT INTO `0_sys_types` VALUES ('1', '8', '2');
1859 INSERT INTO `0_sys_types` VALUES ('2', '5', '2');
1860 INSERT INTO `0_sys_types` VALUES ('4', '3', '1');
1861 INSERT INTO `0_sys_types` VALUES ('10', '19', '4');
1862 INSERT INTO `0_sys_types` VALUES ('11', '3', '2');
1863 INSERT INTO `0_sys_types` VALUES ('12', '6', '1');
1864 INSERT INTO `0_sys_types` VALUES ('13', '5', '2');
1865 INSERT INTO `0_sys_types` VALUES ('16', '2', '1');
1866 INSERT INTO `0_sys_types` VALUES ('17', '2', '1');
1867 INSERT INTO `0_sys_types` VALUES ('18', '1', '3');
1868 INSERT INTO `0_sys_types` VALUES ('20', '8', '3');
1869 INSERT INTO `0_sys_types` VALUES ('21', '1', '1');
1870 INSERT INTO `0_sys_types` VALUES ('22', '4', '2');
1871 INSERT INTO `0_sys_types` VALUES ('25', '1', '2');
1872 INSERT INTO `0_sys_types` VALUES ('26', '1', '8');
1873 INSERT INTO `0_sys_types` VALUES ('28', '1', '1');
1874 INSERT INTO `0_sys_types` VALUES ('29', '1', '2');
1875 INSERT INTO `0_sys_types` VALUES ('30', '5', '6');
1876 INSERT INTO `0_sys_types` VALUES ('32', '0', '1');
1877 INSERT INTO `0_sys_types` VALUES ('35', '1', '1');
1878 INSERT INTO `0_sys_types` VALUES ('40', '1', '3');
1881 ### Structure of table `0_tax_group_items` ###
1883 DROP TABLE IF EXISTS `0_tax_group_items`;
1885 CREATE TABLE `0_tax_group_items` (
1886 `tax_group_id` int(11) NOT NULL default '0',
1887 `tax_type_id` int(11) NOT NULL default '0',
1888 `rate` double NOT NULL default '0',
1889 PRIMARY KEY (`tax_group_id`,`tax_type_id`)
1893 ### Data of table `0_tax_group_items` ###
1895 INSERT INTO `0_tax_group_items` VALUES ('1', '1', '5');
1898 ### Structure of table `0_tax_groups` ###
1900 DROP TABLE IF EXISTS `0_tax_groups`;
1902 CREATE TABLE `0_tax_groups` (
1903 `id` int(11) NOT NULL auto_increment,
1904 `name` varchar(60) NOT NULL default '',
1905 `tax_shipping` tinyint(1) NOT NULL default '0',
1906 `inactive` tinyint(1) NOT NULL default '0',
1908 UNIQUE KEY `name` (`name`)
1909 ) TYPE=InnoDB AUTO_INCREMENT=3 ;
1912 ### Data of table `0_tax_groups` ###
1914 INSERT INTO `0_tax_groups` VALUES ('1', 'Tax', '0', '0');
1915 INSERT INTO `0_tax_groups` VALUES ('2', 'Tax Exempt', '0', '0');
1917 ### Structure of table `0_tax_types` ###
1919 DROP TABLE IF EXISTS `0_tax_types`;
1921 CREATE TABLE `0_tax_types` (
1922 `id` int(11) NOT NULL auto_increment,
1923 `rate` double NOT NULL default '0',
1924 `sales_gl_code` varchar(15) NOT NULL default '',
1925 `purchasing_gl_code` varchar(15) NOT NULL default '',
1926 `name` varchar(60) NOT NULL default '',
1927 `inactive` tinyint(1) NOT NULL default '0',
1929 ) TYPE=InnoDB AUTO_INCREMENT=5 AUTO_INCREMENT=5 ;
1932 ### Data of table `0_tax_types` ###
1934 INSERT INTO `0_tax_types` VALUES ('1', '5', '2150', '2145', 'Tax', '0');
1936 ### Structure of table `0_trans_tax_details` ###
1938 DROP TABLE IF EXISTS `0_trans_tax_details`;
1940 CREATE TABLE `0_trans_tax_details` (
1941 `id` int(11) NOT NULL auto_increment,
1942 `trans_type` smallint(6) default NULL,
1943 `trans_no` int(11) default NULL,
1944 `tran_date` date NOT NULL,
1945 `tax_type_id` int(11) NOT NULL default '0',
1946 `rate` double NOT NULL default '0',
1947 `ex_rate` double NOT NULL default '1',
1948 `included_in_price` tinyint(1) NOT NULL default '0',
1949 `net_amount` double NOT NULL default '0',
1950 `amount` double NOT NULL default '0',
1953 KEY `Type_and_Number` (`trans_type`,`trans_no`),
1955 ) TYPE=InnoDB AUTO_INCREMENT=12 ;
1958 ### Data of table `0_trans_tax_details` ###
1960 INSERT INTO `0_trans_tax_details` VALUES ('1', '20', '7', '2009-06-21', '1', '5', '1', '0', '3300', '165', '5t');
1961 INSERT INTO `0_trans_tax_details` VALUES ('2', '13', '3', '2009-06-21', '1', '5', '1', '0', '50', '2.5', 'auto');
1962 INSERT INTO `0_trans_tax_details` VALUES ('3', '10', '17', '2009-06-21', '1', '5', '1', '0', '50', '2.5', '1');
1963 INSERT INTO `0_trans_tax_details` VALUES ('4', '13', '4', '2009-06-21', '1', '5', '1.3932', '0', '35.89', '1.7945', 'auto');
1964 INSERT INTO `0_trans_tax_details` VALUES ('5', '10', '18', '2009-06-21', '1', '5', '1.3932', '0', '35.89', '1.7945', '2');
1965 INSERT INTO `0_trans_tax_details` VALUES ('6', '2', '5', '2009-06-21', '1', '5', '1', '0', '95.2', '4.76', '');
1966 INSERT INTO `0_trans_tax_details` VALUES ('7', '1', '8', '2009-06-21', '1', '5', '1', '0', '-47.6', '-2.38', '');
1967 INSERT INTO `0_trans_tax_details` VALUES ('8', '20', '8', '2009-06-21', '1', '5', '1', '0', '-19', '-0.95', 'cc');
1968 INSERT INTO `0_trans_tax_details` VALUES ('9', '13', '5', '2009-06-21', '1', '5', '1', '1', '47.619047619048', '2.3809523809524', 'auto');
1969 INSERT INTO `0_trans_tax_details` VALUES ('10', '10', '19', '2009-06-21', '1', '5', '1', '1', '47.619047619048', '2.3809523809524', '3');
1970 INSERT INTO `0_trans_tax_details` VALUES ('11', '11', '3', '2009-06-21', '1', '5', '1.3932', '0', '35.89', '1.7945', '1');
1972 ### Structure of table `0_users` ###
1974 DROP TABLE IF EXISTS `0_users`;
1976 CREATE TABLE `0_users` (
1977 `id` SMALLINT(6) AUTO_INCREMENT,
1978 `user_id` varchar(60) NOT NULL default '',
1979 `password` varchar(100) NOT NULL default '',
1980 `real_name` varchar(100) NOT NULL default '',
1981 `role_id` int(11) NOT NULL default '1',
1982 `phone` varchar(30) NOT NULL default '',
1983 `email` varchar(100) default NULL,
1984 `language` varchar(20) default NULL,
1985 `date_format` tinyint(1) NOT NULL default '0',
1986 `date_sep` tinyint(1) NOT NULL default '0',
1987 `tho_sep` tinyint(1) NOT NULL default '0',
1988 `dec_sep` tinyint(1) NOT NULL default '0',
1989 `theme` varchar(20) NOT NULL default 'default',
1990 `page_size` varchar(20) NOT NULL default 'A4',
1991 `prices_dec` smallint(6) NOT NULL default '2',
1992 `qty_dec` smallint(6) NOT NULL default '2',
1993 `rates_dec` smallint(6) NOT NULL default '4',
1994 `percent_dec` smallint(6) NOT NULL default '1',
1995 `show_gl` tinyint(1) NOT NULL default '1',
1996 `show_codes` tinyint(1) NOT NULL default '0',
1997 `show_hints` tinyint(1) NOT NULL default '0',
1998 `last_visit_date` datetime default NULL,
1999 `query_size` tinyint(1) default '10',
2000 `graphic_links` tinyint(1) default '1',
2001 `pos` smallint(6) default '1',
2002 `print_profile` varchar(30) NOT NULL default '1',
2003 `rep_popup` tinyint(1) default '1',
2004 `sticky_doc_date` tinyint(1) default '0',
2005 `startup_tab` varchar(20) NOT NULL default '',
2006 `inactive` tinyint(1) NOT NULL default '0',
2008 UNIQUE KEY (`user_id`)
2009 ) TYPE=MyISAM AUTO_INCREMENT=2;
2012 ### Data of table `0_users` ###
2014 INSERT INTO `0_users` VALUES ('1', 'admin', '5f4dcc3b5aa765d61d8327deb882cf99', 'Administrator', '2', '', 'adm@adm.com', 'en_US', '0', '0', '0', '0', 'default', 'Letter', '2', '2', '4', '1', '1', '0', '0', '2009-01-30 09:39:03', '10', '1', '1', '1', '1', '0', 'orders', '0');
2015 INSERT INTO `0_users` VALUES ('2', 'demouser', '5f4dcc3b5aa765d61d8327deb882cf99', 'Demo User', '9', '999-999-999', 'demo@demo.nu', 'en_US', '0', '0', '0', '0', 'default', 'Letter', '2', '2', '3', '1', '1', '0', '0', '2008-02-06 19:02:35', '10', '1', '1', '1', '1', '0', 'orders', '0');
2017 ### Structure of table `0_voided` ###
2019 DROP TABLE IF EXISTS `0_voided`;
2021 CREATE TABLE `0_voided` (
2022 `type` int(11) NOT NULL default '0',
2023 `id` int(11) NOT NULL default '0',
2024 `date_` date NOT NULL default '0000-00-00',
2025 `memo_` tinytext NOT NULL,
2026 UNIQUE KEY `id` (`type`,`id`)
2030 ### Data of table `0_voided` ###
2034 ### Structure of table `0_wo_issue_items` ###
2036 DROP TABLE IF EXISTS `0_wo_issue_items`;
2038 CREATE TABLE `0_wo_issue_items` (
2039 `id` int(11) NOT NULL auto_increment,
2040 `stock_id` varchar(40) default NULL,
2041 `issue_id` int(11) default NULL,
2042 `qty_issued` double default NULL,
2044 ) TYPE=InnoDB AUTO_INCREMENT=1 ;
2047 ### Data of table `0_wo_issue_items` ###
2051 ### Structure of table `0_wo_issues` ###
2053 DROP TABLE IF EXISTS `0_wo_issues`;
2055 CREATE TABLE `0_wo_issues` (
2056 `issue_no` int(11) NOT NULL auto_increment,
2057 `workorder_id` int(11) NOT NULL default '0',
2058 `reference` varchar(100) default NULL,
2059 `issue_date` date default NULL,
2060 `loc_code` varchar(5) default NULL,
2061 `workcentre_id` int(11) default NULL,
2062 PRIMARY KEY (`issue_no`),
2063 KEY (`workorder_id`)
2064 ) TYPE=InnoDB AUTO_INCREMENT=1 ;
2067 ### Data of table `0_wo_issues` ###
2071 ### Structure of table `0_wo_manufacture` ###
2073 DROP TABLE IF EXISTS `0_wo_manufacture`;
2075 CREATE TABLE `0_wo_manufacture` (
2076 `id` int(11) NOT NULL auto_increment,
2077 `reference` varchar(100) default NULL,
2078 `workorder_id` int(11) NOT NULL default '0',
2079 `quantity` double NOT NULL default '0',
2080 `date_` date NOT NULL default '0000-00-00',
2082 KEY (`workorder_id`)
2083 ) TYPE=InnoDB AUTO_INCREMENT=2 ;
2086 ### Data of table `0_wo_manufacture` ###
2088 INSERT INTO `0_wo_manufacture` VALUES ('1', '1', '2', '2', '2009-06-21');
2091 ### Structure of table `0_wo_requirements` ###
2093 DROP TABLE IF EXISTS `0_wo_requirements`;
2095 CREATE TABLE `0_wo_requirements` (
2096 `id` int(11) NOT NULL auto_increment,
2097 `workorder_id` int(11) NOT NULL default '0',
2098 `stock_id` char(20) NOT NULL default '',
2099 `workcentre` int(11) NOT NULL default '0',
2100 `units_req` double NOT NULL default '1',
2101 `std_cost` double NOT NULL default '0',
2102 `loc_code` char(5) NOT NULL default '',
2103 `units_issued` double NOT NULL default '0',
2105 KEY (`workorder_id`)
2106 ) TYPE=InnoDB AUTO_INCREMENT=22 ;
2109 ### Data of table `0_wo_requirements` ###
2111 INSERT INTO `0_wo_requirements` VALUES ('1', '1', '102', '1', '1', '0', 'DEF', '10');
2112 INSERT INTO `0_wo_requirements` VALUES ('2', '1', '103', '1', '1', '0', 'DEF', '10');
2113 INSERT INTO `0_wo_requirements` VALUES ('3', '1', '104', '1', '1', '0', 'DEF', '10');
2114 INSERT INTO `0_wo_requirements` VALUES ('4', '2', '102', '1', '1', '0', 'DEF', '0');
2115 INSERT INTO `0_wo_requirements` VALUES ('5', '2', '103', '1', '1', '0', 'DEF', '0');
2116 INSERT INTO `0_wo_requirements` VALUES ('6', '2', '104', '1', '1', '0', 'DEF', '0');
2117 INSERT INTO `0_wo_requirements` VALUES ('7', '3', '102', '1', '1', '0', 'DEF', '2');
2118 INSERT INTO `0_wo_requirements` VALUES ('8', '3', '103', '1', '1', '0', 'DEF', '2');
2119 INSERT INTO `0_wo_requirements` VALUES ('9', '3', '104', '1', '1', '0', 'DEF', '2');
2120 INSERT INTO `0_wo_requirements` VALUES ('10', '4', '102', '1', '1', '0', 'DEF', '4');
2121 INSERT INTO `0_wo_requirements` VALUES ('11', '4', '103', '1', '1', '0', 'DEF', '4');
2122 INSERT INTO `0_wo_requirements` VALUES ('12', '4', '104', '1', '1', '0', 'DEF', '4');
2123 INSERT INTO `0_wo_requirements` VALUES ('13', '5', '102', '1', '1', '0', 'DEF', '5');
2124 INSERT INTO `0_wo_requirements` VALUES ('14', '5', '103', '1', '1', '0', 'DEF', '5');
2125 INSERT INTO `0_wo_requirements` VALUES ('15', '5', '104', '1', '1', '0', 'DEF', '5');
2126 INSERT INTO `0_wo_requirements` VALUES ('16', '6', '102', '1', '1', '0', 'DEF', '-5');
2127 INSERT INTO `0_wo_requirements` VALUES ('17', '6', '103', '1', '1', '0', 'DEF', '-5');
2128 INSERT INTO `0_wo_requirements` VALUES ('18', '6', '104', '1', '1', '0', 'DEF', '-5');
2129 INSERT INTO `0_wo_requirements` VALUES ('19', '7', '102', '1', '1', '0', 'DEF', '-2');
2130 INSERT INTO `0_wo_requirements` VALUES ('20', '7', '103', '1', '1', '0', 'DEF', '-2');
2131 INSERT INTO `0_wo_requirements` VALUES ('21', '7', '104', '1', '1', '0', 'DEF', '-2');
2134 ### Structure of table `0_workcentres` ###
2136 DROP TABLE IF EXISTS `0_workcentres`;
2138 CREATE TABLE `0_workcentres` (
2139 `id` int(11) NOT NULL auto_increment,
2140 `name` char(40) NOT NULL default '',
2141 `description` char(50) NOT NULL default '',
2142 `inactive` tinyint(1) NOT NULL default '0',
2144 UNIQUE KEY `name` (`name`)
2145 ) TYPE=MyISAM AUTO_INCREMENT=2 ;
2148 ### Data of table `0_workcentres` ###
2150 INSERT INTO `0_workcentres` VALUES ('1', 'Workshop', 'Workshop in Alabama', '0');
2153 ### Structure of table `0_workorders` ###
2155 DROP TABLE IF EXISTS `0_workorders`;
2157 CREATE TABLE `0_workorders` (
2158 `id` int(11) NOT NULL auto_increment,
2159 `wo_ref` varchar(60) NOT NULL default '',
2160 `loc_code` varchar(5) NOT NULL default '',
2161 `units_reqd` double NOT NULL default '1',
2162 `stock_id` varchar(20) NOT NULL default '',
2163 `date_` date NOT NULL default '0000-00-00',
2164 `type` tinyint(4) NOT NULL default '0',
2165 `required_by` date NOT NULL default '0000-00-00',
2166 `released_date` date NOT NULL default '0000-00-00',
2167 `units_issued` double NOT NULL default '0',
2168 `closed` tinyint(1) NOT NULL default '0',
2169 `released` tinyint(1) NOT NULL default '0',
2170 `additional_costs` double NOT NULL default '0',
2172 UNIQUE KEY `wo_ref` (`wo_ref`)
2173 ) TYPE=InnoDB AUTO_INCREMENT=8 ;
2176 ### Data of table `0_workorders` ###
2178 INSERT INTO `0_workorders` VALUES ('1', '1', 'DEF', '10', '3400', '2009-06-21', '0', '2009-06-21', '2009-06-21', '10', '1', '1', '10');
2179 INSERT INTO `0_workorders` VALUES ('2', '2', 'DEF', '3', '3400', '2009-06-21', '2', '2009-07-11', '2009-06-21', '2', '0', '1', '0');
2180 INSERT INTO `0_workorders` VALUES ('3', '3', 'DEF', '2', '3400', '2009-06-21', '0', '2009-06-21', '2009-06-21', '2', '1', '1', '0');
2181 INSERT INTO `0_workorders` VALUES ('4', '4', 'DEF', '4', '3400', '2009-06-21', '0', '2009-06-21', '2009-06-21', '4', '1', '1', '0');
2182 INSERT INTO `0_workorders` VALUES ('5', '5', 'DEF', '5', '3400', '2009-06-21', '0', '2009-06-21', '2009-06-21', '5', '1', '1', '10');
2183 INSERT INTO `0_workorders` VALUES ('6', '6', 'DEF', '-5', '3400', '2009-06-21', '1', '2009-06-21', '2009-06-21', '-5', '1', '1', '0');
2184 INSERT INTO `0_workorders` VALUES ('7', '7', 'DEF', '-2', '3400', '2009-06-21', '1', '2009-06-21', '2009-06-21', '-2', '1', '1', '10');
2187 ### Structure of table `0_tags` ###
2189 DROP TABLE IF EXISTS `0_tags`;
2191 CREATE TABLE `0_tags` (
2192 `id` int(11) NOT NULL auto_increment,
2193 `type` smallint(6) NOT NULL,
2194 `name` varchar(30) NOT NULL,
2195 `description` varchar(60) default NULL,
2196 `inactive` tinyint(1) NOT NULL default '0',
2198 UNIQUE KEY(`type`,`name`)
2199 ) TYPE=MyISAM AUTO_INCREMENT=1;
2202 ### Data of table `0_chart_tags` ###
2206 ### Structure of table `0_tag_associations` ###
2208 DROP TABLE IF EXISTS `0_tag_associations`;
2210 CREATE TABLE `0_tag_associations` (
2211 `record_id` varchar(15) NOT NULL,
2212 `tag_id` int(11) NOT NULL,
2213 UNIQUE KEY(`record_id`,`tag_id`)
2217 ### Data of table `0_tag_associations` ###
2219 DROP TABLE IF EXISTS `0_useronline` ;
2221 CREATE TABLE `0_useronline` (
2222 `id` int(11) NOT NULL AUTO_INCREMENT ,
2223 `timestamp` int(15) NOT NULL default '0',
2224 `ip` varchar(40) NOT NULL default '',
2225 `file` varchar(100) NOT NULL default '',
2226 PRIMARY KEY `id` (`id`) ,
2229 ) TYPE=MYISAM AUTO_INCREMENT=1;