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 (`fiscal_year`, `gl_seq`)
65 ### Data of table `0_audit_trail` ###
71 ### Structure of table `0_bank_accounts` ###
73 DROP TABLE IF EXISTS `0_bank_accounts`;
75 CREATE TABLE `0_bank_accounts` (
76 `account_code` varchar(11) NOT NULL default '',
77 `account_type` smallint(6) NOT NULL default '0',
78 `bank_account_name` varchar(60) NOT NULL default '',
79 `bank_account_number` varchar(100) NOT NULL default '',
80 `bank_name` varchar(60) NOT NULL default '',
81 `bank_address` tinytext,
82 `bank_curr_code` char(3) NOT NULL default '',
83 `id` smallint(6) NOT NULL auto_increment,
84 `last_reconciled_date` timestamp NOT NULL default '0000-00-00 00:00:00',
85 `ending_reconcile_balance` double NOT NULL default '0',
86 `inactive` tinyint(1) NOT NULL default '0',
88 KEY `bank_account_name` (`bank_account_name`),
89 KEY `bank_account_number` (`bank_account_number`)
90 ) TYPE=MyISAM AUTO_INCREMENT=3 ;
93 ### Data of table `0_bank_accounts` ###
95 INSERT INTO `0_bank_accounts` VALUES ('1060', '0', 'Current account', '9999999999', 'Wachovia Bank', '', 'USD', '1', '0000-00-00 00:00:00', '0', '0');
96 INSERT INTO `0_bank_accounts` VALUES ('1065', '3', 'Petty Cash account', 'N/A', 'N/A', '', 'USD', '2', '0000-00-00 00:00:00', '0', '0');
99 ### Structure of table `0_bank_trans` ###
101 DROP TABLE IF EXISTS `0_bank_trans`;
103 CREATE TABLE `0_bank_trans` (
104 `id` int(11) NOT NULL auto_increment,
105 `type` smallint(6) default NULL,
106 `trans_no` int(11) default NULL,
107 `bank_act` varchar(11) default NULL,
108 `ref` varchar(40) default NULL,
109 `trans_date` date NOT NULL default '0000-00-00',
110 `amount` double default NULL,
111 `dimension_id` int(11) NOT NULL default '0',
112 `dimension2_id` int(11) NOT NULL default '0',
113 `person_type_id` int(11) NOT NULL default '0',
114 `person_id` tinyblob,
115 `reconciled` date default NULL,
117 KEY `bank_act` (`bank_act`,`ref`),
118 KEY `type` (`type`,`trans_no`)
119 ) TYPE=InnoDB AUTO_INCREMENT=12 ;
122 ### Data of table `0_bank_trans` ###
124 INSERT INTO `0_bank_trans` VALUES ('1', '22', '4', '1', '1', '2009-06-21', '-3465', '0', '0', '3', '2', '');
125 INSERT INTO `0_bank_trans` VALUES ('2', '26', '1', '1', '', '2009-06-21', '-10', '0', '0', '1', '1', '');
126 INSERT INTO `0_bank_trans` VALUES ('3', '26', '1', '1', '', '2009-06-21', '-20', '0', '0', '1', '0', '');
127 INSERT INTO `0_bank_trans` VALUES ('4', '0', '18', '1', '1', '2009-02-20', '1000', '0', '0', '0', '', '');
128 INSERT INTO `0_bank_trans` VALUES ('5', '0', '19', '1', '2', '2009-02-21', '4000', '0', '0', '0', '', '');
129 INSERT INTO `0_bank_trans` VALUES ('6', '2', '5', '1', '1', '2009-06-21', '100', '0', '0', '4', '3', '');
130 INSERT INTO `0_bank_trans` VALUES ('7', '1', '8', '1', '1', '2009-06-21', '-50', '0', '0', '4', '1', '');
131 INSERT INTO `0_bank_trans` VALUES ('8', '26', '5', '1', '', '2009-06-21', '-10', '0', '0', '1', '1', '');
132 INSERT INTO `0_bank_trans` VALUES ('9', '26', '5', '1', '', '2009-06-21', '-20', '0', '0', '1', '0', '');
133 INSERT INTO `0_bank_trans` VALUES ('10', '26', '7', '1', '', '2009-06-21', '-10', '0', '0', '1', '1', '');
134 INSERT INTO `0_bank_trans` VALUES ('11', '26', '7', '1', '', '2009-06-21', '-20', '0', '0', '1', '0', '');
137 ### Structure of table `0_bom` ###
139 DROP TABLE IF EXISTS `0_bom`;
141 CREATE TABLE `0_bom` (
142 `id` int(11) NOT NULL auto_increment,
143 `parent` char(20) NOT NULL default '',
144 `component` char(20) NOT NULL default '',
145 `workcentre_added` int(11) NOT NULL default '0',
146 `loc_code` char(5) NOT NULL default '',
147 `quantity` double NOT NULL default '1',
148 PRIMARY KEY (`parent`,`component`,`workcentre_added`,`loc_code`),
149 KEY `component` (`component`),
151 KEY `loc_code` (`loc_code`),
152 KEY `parent` (`parent`,`loc_code`),
153 KEY `Parent_2` (`parent`),
154 KEY `workcentre_added` (`workcentre_added`)
155 ) TYPE=MyISAM AUTO_INCREMENT=4 ;
158 ### Data of table `0_bom` ###
160 INSERT INTO `0_bom` VALUES ('1', '3400', '102', '1', 'DEF', '1');
161 INSERT INTO `0_bom` VALUES ('2', '3400', '103', '1', 'DEF', '1');
162 INSERT INTO `0_bom` VALUES ('3', '3400', '104', '1', 'DEF', '1');
165 ### Structure of table `0_budget_trans` ###
167 DROP TABLE IF EXISTS `0_budget_trans`;
169 CREATE TABLE `0_budget_trans` (
170 `counter` int(11) NOT NULL auto_increment,
171 `type` smallint(6) NOT NULL default '0',
172 `type_no` bigint(16) NOT NULL default '1',
173 `tran_date` date NOT NULL default '0000-00-00',
174 `account` varchar(11) NOT NULL default '',
175 `memo_` tinytext NOT NULL,
176 `amount` double NOT NULL default '0',
177 `dimension_id` int(11) default '0',
178 `dimension2_id` int(11) default '0',
179 `person_type_id` int(11) default NULL,
180 `person_id` tinyblob,
181 PRIMARY KEY (`counter`),
182 KEY `Type_and_Number` (`type`,`type_no`)
183 ) TYPE=InnoDB AUTO_INCREMENT=1 ;
186 ### Data of table `0_budget_trans` ###
190 ### Structure of table `0_chart_class` ###
192 DROP TABLE IF EXISTS `0_chart_class`;
194 CREATE TABLE `0_chart_class` (
195 `cid` int(11) NOT NULL default '0',
196 `class_name` varchar(60) NOT NULL default '',
197 `ctype` tinyint(1) NOT NULL default '0',
198 `inactive` tinyint(1) NOT NULL default '0',
203 ### Data of table `0_chart_class` ###
205 INSERT INTO `0_chart_class` VALUES ('1', 'Assets', '1', '0');
206 INSERT INTO `0_chart_class` VALUES ('2', 'Liabilities', '2', '0');
207 INSERT INTO `0_chart_class` VALUES ('3', 'Income', '4', '0');
208 INSERT INTO `0_chart_class` VALUES ('4', 'Costs', '6', '0');
211 ### Structure of table `0_chart_master` ###
213 DROP TABLE IF EXISTS `0_chart_master`;
215 CREATE TABLE `0_chart_master` (
216 `account_code` varchar(11) NOT NULL default '',
217 `account_code2` varchar(11) default '',
218 `account_name` varchar(60) NOT NULL default '',
219 `account_type` int(11) NOT NULL default '0',
220 `inactive` tinyint(1) NOT NULL default '0',
221 PRIMARY KEY (`account_code`),
222 KEY `account_code` (`account_code`),
223 KEY `account_name` (`account_name`)
227 ### Data of table `0_chart_master` ###
229 INSERT INTO `0_chart_master` VALUES ('1060', '', 'Checking Account', '1', '0');
230 INSERT INTO `0_chart_master` VALUES ('1065', '', 'Petty Cash', '1', '0');
231 INSERT INTO `0_chart_master` VALUES ('1200', '', 'Accounts Receivables', '1', '0');
232 INSERT INTO `0_chart_master` VALUES ('1205', '', 'Allowance for doubtful accounts', '1', '0');
233 INSERT INTO `0_chart_master` VALUES ('1510', '', 'Inventory', '2', '0');
234 INSERT INTO `0_chart_master` VALUES ('1520', '', 'Stocks of Raw Materials', '2', '0');
235 INSERT INTO `0_chart_master` VALUES ('1530', '', 'Stocks of Work In Progress', '2', '0');
236 INSERT INTO `0_chart_master` VALUES ('1540', '', 'Stocks of Finsihed Goods', '2', '0');
237 INSERT INTO `0_chart_master` VALUES ('1550', '', 'Goods Received Clearing account', '2', '0');
238 INSERT INTO `0_chart_master` VALUES ('1820', '', 'Office Furniture & Equipment', '3', '0');
239 INSERT INTO `0_chart_master` VALUES ('1825', '', 'Accum. Amort. -Furn. & Equip.', '3', '0');
240 INSERT INTO `0_chart_master` VALUES ('1840', '', 'Vehicle', '3', '0');
241 INSERT INTO `0_chart_master` VALUES ('1845', '', 'Accum. Amort. -Vehicle', '3', '0');
242 INSERT INTO `0_chart_master` VALUES ('2100', '', 'Accounts Payable', '4', '0');
243 INSERT INTO `0_chart_master` VALUES ('2110', '', 'Accrued Income Tax - Federal', '4', '0');
244 INSERT INTO `0_chart_master` VALUES ('2120', '', 'Accrued Income Tax - State', '4', '0');
245 INSERT INTO `0_chart_master` VALUES ('2130', '', 'Accrued Franchise Tax', '4', '0');
246 INSERT INTO `0_chart_master` VALUES ('2140', '', 'Accrued Real & Personal Prop Tax', '4', '0');
247 INSERT INTO `0_chart_master` VALUES ('2150', '', 'Sales Tax', '4', '0');
248 INSERT INTO `0_chart_master` VALUES ('2160', '', 'Accrued Use Tax Payable', '4', '0');
249 INSERT INTO `0_chart_master` VALUES ('2210', '', 'Accrued Wages', '4', '0');
250 INSERT INTO `0_chart_master` VALUES ('2220', '', 'Accrued Comp Time', '4', '0');
251 INSERT INTO `0_chart_master` VALUES ('2230', '', 'Accrued Holiday Pay', '4', '0');
252 INSERT INTO `0_chart_master` VALUES ('2240', '', 'Accrued Vacation Pay', '4', '0');
253 INSERT INTO `0_chart_master` VALUES ('2310', '', 'Accr. Benefits - 401K', '4', '0');
254 INSERT INTO `0_chart_master` VALUES ('2320', '', 'Accr. Benefits - Stock Purchase', '4', '0');
255 INSERT INTO `0_chart_master` VALUES ('2330', '', 'Accr. Benefits - Med, Den', '4', '0');
256 INSERT INTO `0_chart_master` VALUES ('2340', '', 'Accr. Benefits - Payroll Taxes', '4', '0');
257 INSERT INTO `0_chart_master` VALUES ('2350', '', 'Accr. Benefits - Credit Union', '4', '0');
258 INSERT INTO `0_chart_master` VALUES ('2360', '', 'Accr. Benefits - Savings Bond', '4', '0');
259 INSERT INTO `0_chart_master` VALUES ('2370', '', 'Accr. Benefits - Garnish', '4', '0');
260 INSERT INTO `0_chart_master` VALUES ('2380', '', 'Accr. Benefits - Charity Cont.', '4', '0');
261 INSERT INTO `0_chart_master` VALUES ('2620', '', 'Bank Loans', '5', '0');
262 INSERT INTO `0_chart_master` VALUES ('2680', '', 'Loans from Shareholders', '5', '0');
263 INSERT INTO `0_chart_master` VALUES ('3350', '', 'Common Shares', '6', '0');
264 INSERT INTO `0_chart_master` VALUES ('3590', '', 'Retained Earnings - prior years', '7', '0');
265 INSERT INTO `0_chart_master` VALUES ('4010', '', 'Sales', '8', '0');
266 INSERT INTO `0_chart_master` VALUES ('4430', '', 'Shipping & Handling', '9', '0');
267 INSERT INTO `0_chart_master` VALUES ('4440', '', 'Interest', '9', '0');
268 INSERT INTO `0_chart_master` VALUES ('4450', '', 'Foreign Exchange Gain', '9', '0');
269 INSERT INTO `0_chart_master` VALUES ('4500', '', 'Prompt Payment Discounts', '9', '0');
270 INSERT INTO `0_chart_master` VALUES ('4510', '', 'Discounts Given', '9', '0');
271 INSERT INTO `0_chart_master` VALUES ('5010', '', 'Cost of Goods Sold - Retail', '10', '0');
272 INSERT INTO `0_chart_master` VALUES ('5020', '', 'Material Usage Varaiance', '10', '0');
273 INSERT INTO `0_chart_master` VALUES ('5030', '', 'Consumable Materials', '10', '0');
274 INSERT INTO `0_chart_master` VALUES ('5040', '', 'Purchase price Variance', '10', '0');
275 INSERT INTO `0_chart_master` VALUES ('5050', '', 'Purchases of materials', '10', '0');
276 INSERT INTO `0_chart_master` VALUES ('5060', '', 'Discounts Received', '10', '0');
277 INSERT INTO `0_chart_master` VALUES ('5100', '', 'Freight', '10', '0');
278 INSERT INTO `0_chart_master` VALUES ('5410', '', 'Wages & Salaries', '11', '0');
279 INSERT INTO `0_chart_master` VALUES ('5420', '', 'Wages - Overtime', '11', '0');
280 INSERT INTO `0_chart_master` VALUES ('5430', '', 'Benefits - Comp Time', '11', '0');
281 INSERT INTO `0_chart_master` VALUES ('5440', '', 'Benefits - Payroll Taxes', '11', '0');
282 INSERT INTO `0_chart_master` VALUES ('5450', '', 'Benefits - Workers Comp', '11', '0');
283 INSERT INTO `0_chart_master` VALUES ('5460', '', 'Benefits - Pension', '11', '0');
284 INSERT INTO `0_chart_master` VALUES ('5470', '', 'Benefits - General Benefits', '11', '0');
285 INSERT INTO `0_chart_master` VALUES ('5510', '', 'Inc Tax Exp - Federal', '11', '0');
286 INSERT INTO `0_chart_master` VALUES ('5520', '', 'Inc Tax Exp - State', '11', '0');
287 INSERT INTO `0_chart_master` VALUES ('5530', '', 'Taxes - Real Estate', '11', '0');
288 INSERT INTO `0_chart_master` VALUES ('5540', '', 'Taxes - Personal Property', '11', '0');
289 INSERT INTO `0_chart_master` VALUES ('5550', '', 'Taxes - Franchise', '11', '0');
290 INSERT INTO `0_chart_master` VALUES ('5560', '', 'Taxes - Foreign Withholding', '11', '0');
291 INSERT INTO `0_chart_master` VALUES ('5610', '', 'Accounting & Legal', '12', '0');
292 INSERT INTO `0_chart_master` VALUES ('5615', '', 'Advertising & Promotions', '12', '0');
293 INSERT INTO `0_chart_master` VALUES ('5620', '', 'Bad Debts', '12', '0');
294 INSERT INTO `0_chart_master` VALUES ('5660', '', 'Amortization Expense', '12', '0');
295 INSERT INTO `0_chart_master` VALUES ('5685', '', 'Insurance', '12', '0');
296 INSERT INTO `0_chart_master` VALUES ('5690', '', 'Interest & Bank Charges', '12', '0');
297 INSERT INTO `0_chart_master` VALUES ('5700', '', 'Office Supplies', '12', '0');
298 INSERT INTO `0_chart_master` VALUES ('5760', '', 'Rent', '12', '0');
299 INSERT INTO `0_chart_master` VALUES ('5765', '', 'Repair & Maintenance', '12', '0');
300 INSERT INTO `0_chart_master` VALUES ('5780', '', 'Telephone', '12', '0');
301 INSERT INTO `0_chart_master` VALUES ('5785', '', 'Travel & Entertainment', '12', '0');
302 INSERT INTO `0_chart_master` VALUES ('5790', '', 'Utilities', '12', '0');
303 INSERT INTO `0_chart_master` VALUES ('5795', '', 'Registrations', '12', '0');
304 INSERT INTO `0_chart_master` VALUES ('5800', '', 'Licenses', '12', '0');
305 INSERT INTO `0_chart_master` VALUES ('5810', '', 'Foreign Exchange Loss', '12', '0');
306 INSERT INTO `0_chart_master` VALUES ('9990', '', 'Year Profit/Loss', '12', '0');
308 ### Structure of table `0_chart_types` ###
310 DROP TABLE IF EXISTS `0_chart_types`;
312 CREATE TABLE `0_chart_types` (
313 `id` int(11) NOT NULL auto_increment,
314 `name` varchar(60) NOT NULL default '',
315 `class_id` tinyint(1) NOT NULL default '0',
316 `parent` int(11) NOT NULL default '-1',
317 `inactive` tinyint(1) NOT NULL default '0',
320 ) TYPE=MyISAM AUTO_INCREMENT=13 ;
323 ### Data of table `0_chart_types` ###
325 INSERT INTO `0_chart_types` VALUES ('1', 'Current Assets', '1', '-1', '0');
326 INSERT INTO `0_chart_types` VALUES ('2', 'Inventory Assets', '1', '-1', '0');
327 INSERT INTO `0_chart_types` VALUES ('3', 'Capital Assets', '1', '-1', '0');
328 INSERT INTO `0_chart_types` VALUES ('4', 'Current Liabilities', '2', '-1', '0');
329 INSERT INTO `0_chart_types` VALUES ('5', 'Long Term Liabilities', '2', '-1', '0');
330 INSERT INTO `0_chart_types` VALUES ('6', 'Share Capital', '2', '-1', '0');
331 INSERT INTO `0_chart_types` VALUES ('7', 'Retained Earnings', '2', '-1', '0');
332 INSERT INTO `0_chart_types` VALUES ('8', 'Sales Revenue', '3', '-1', '0');
333 INSERT INTO `0_chart_types` VALUES ('9', 'Other Revenue', '3', '-1', '0');
334 INSERT INTO `0_chart_types` VALUES ('10', 'Cost of Goods Sold', '4', '-1', '0');
335 INSERT INTO `0_chart_types` VALUES ('11', 'Payroll Expenses', '4', '-1', '0');
336 INSERT INTO `0_chart_types` VALUES ('12', 'General & Administrative expenses', '4', '-1', '0');
339 ### Structure of table `0_comments` ###
341 DROP TABLE IF EXISTS `0_comments`;
343 CREATE TABLE `0_comments` (
344 `type` int(11) NOT NULL default '0',
345 `id` int(11) NOT NULL default '0',
346 `date_` date default '0000-00-00',
351 ### Data of table `0_comments` ###
355 ### Structure of table `0_company` ###
357 DROP TABLE IF EXISTS `0_company`;
359 CREATE TABLE `0_company` (
360 `coy_code` int(11) NOT NULL default '1',
361 `coy_name` varchar(60) NOT NULL default '',
362 `gst_no` varchar(25) NOT NULL default '',
363 `coy_no` varchar(25) NOT NULL default '0',
364 `tax_prd` int(11) NOT NULL default '1',
365 `tax_last` int(11) NOT NULL default '1',
366 `postal_address` tinytext NOT NULL,
367 `phone` varchar(30) NOT NULL default '',
368 `fax` varchar(30) NOT NULL default '',
369 `email` varchar(100) NOT NULL default '',
370 `coy_logo` varchar(100) NOT NULL default '',
371 `domicile` varchar(55) NOT NULL default '',
372 `curr_default` char(3) NOT NULL default '',
373 `debtors_act` varchar(11) NOT NULL default '',
374 `pyt_discount_act` varchar(11) NOT NULL default '',
375 `creditors_act` varchar(11) NOT NULL default '',
376 `bank_charge_act` varchar(11) NOT NULL default '',
377 `exchange_diff_act` varchar(11) NOT NULL default '',
378 `profit_loss_year_act` varchar(11) NOT NULL default '',
379 `retained_earnings_act` varchar(11) NOT NULL default '',
380 `freight_act` varchar(11) NOT NULL default '',
381 `default_sales_act` varchar(11) NOT NULL default '',
382 `default_sales_discount_act` varchar(11) NOT NULL default '',
383 `default_prompt_payment_act` varchar(11) NOT NULL default '',
384 `default_inventory_act` varchar(11) NOT NULL default '',
385 `default_cogs_act` varchar(11) NOT NULL default '',
386 `default_adj_act` varchar(11) NOT NULL default '',
387 `default_inv_sales_act` varchar(11) NOT NULL default '',
388 `default_assembly_act` varchar(11) NOT NULL default '',
389 `payroll_act` varchar(11) NOT NULL default '',
390 `allow_negative_stock` tinyint(1) NOT NULL default '0',
391 `po_over_receive` int(11) NOT NULL default '10',
392 `po_over_charge` int(11) NOT NULL default '10',
393 `default_credit_limit` int(11) NOT NULL default '1000',
394 `default_workorder_required` int(11) NOT NULL default '20',
395 `default_dim_required` int(11) NOT NULL default '20',
396 `past_due_days` int(11) NOT NULL default '30',
397 `use_dimension` tinyint(1) default '0',
398 `f_year` int(11) NOT NULL default '1',
399 `no_item_list` tinyint(1) NOT NULL default '0',
400 `no_customer_list` tinyint(1) NOT NULL default '0',
401 `no_supplier_list` tinyint(1) NOT NULL default '0',
402 `base_sales` int(11) NOT NULL default '-1',
403 `foreign_codes` tinyint(1) NOT NULL default '0',
404 `accumulate_shipping` tinyint(1) NOT NULL default '0',
405 `legal_text` tinytext NOT NULL,
406 `default_delivery_required` smallint(6) NOT NULL default '1',
407 `version_id` varchar(11) NOT NULL default '',
408 `time_zone` tinyint(1) NOT NULL default '0',
409 `add_pct` int(5) NOT NULL default '-1',
410 `round_to` int(5) NOT NULL default '1',
411 `login_tout` SMALLINT(6) NOT NULL DEFAULT '600',
412 PRIMARY KEY (`coy_code`)
415 ### Data of table `0_company` ###
417 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');
419 ### Structure of table `0_credit_status` ###
421 DROP TABLE IF EXISTS `0_credit_status`;
423 CREATE TABLE `0_credit_status` (
424 `id` int(11) NOT NULL auto_increment,
425 `reason_description` char(100) NOT NULL default '',
426 `dissallow_invoices` tinyint(1) NOT NULL default '0',
427 `inactive` tinyint(1) NOT NULL default '0',
429 UNIQUE KEY `reason_description` (`reason_description`)
430 ) TYPE=MyISAM AUTO_INCREMENT=5 ;
433 ### Data of table `0_credit_status` ###
435 INSERT INTO `0_credit_status` VALUES ('1', 'Good History', '0', '0');
436 INSERT INTO `0_credit_status` VALUES ('3', 'No more work until payment received', '1', '0');
437 INSERT INTO `0_credit_status` VALUES ('4', 'In liquidation', '1', '0');
440 ### Structure of table `0_currencies` ###
442 DROP TABLE IF EXISTS `0_currencies`;
444 CREATE TABLE `0_currencies` (
445 `currency` varchar(60) NOT NULL default '',
446 `curr_abrev` char(3) NOT NULL default '',
447 `curr_symbol` varchar(10) NOT NULL default '',
448 `country` varchar(100) NOT NULL default '',
449 `hundreds_name` varchar(15) NOT NULL default '',
450 `auto_update` tinyint(1) NOT NULL default '1',
451 `inactive` tinyint(1) NOT NULL default '0',
452 PRIMARY KEY (`curr_abrev`)
456 ### Data of table `0_currencies` ###
458 INSERT INTO `0_currencies` VALUES ('US Dollars', 'USD', '$', 'United States', 'Cents', '1', '0');
459 INSERT INTO `0_currencies` VALUES ('CA Dollars', 'CAD', '$', 'Canada', 'Cents', '1', '0');
460 INSERT INTO `0_currencies` VALUES ('Euro', 'EUR', '?', 'Europe', 'Cents', '1', '0');
461 INSERT INTO `0_currencies` VALUES ('Pounds', 'GBP', '?', 'England', 'Pence', '1', '0');
462 INSERT INTO `0_currencies` VALUES ('DK Kroner', 'DKK', '?', 'Denmark', 'Ore', '1', '0');
464 ### Structure of table `0_cust_allocations` ###
466 DROP TABLE IF EXISTS `0_cust_allocations`;
468 CREATE TABLE `0_cust_allocations` (
469 `id` int(11) NOT NULL auto_increment,
470 `amt` double unsigned default NULL,
471 `date_alloc` date NOT NULL default '0000-00-00',
472 `trans_no_from` int(11) default NULL,
473 `trans_type_from` int(11) default NULL,
474 `trans_no_to` int(11) default NULL,
475 `trans_type_to` int(11) default NULL,
477 ) TYPE=InnoDB AUTO_INCREMENT=2 ;
480 ### Data of table `0_cust_allocations` ###
482 INSERT INTO `0_cust_allocations` VALUES ('1', '37.68', '2009-06-21', '3', '11', '18', '10');
485 ### Structure of table `0_cust_branch` ###
487 DROP TABLE IF EXISTS `0_cust_branch`;
489 CREATE TABLE `0_cust_branch` (
490 `branch_code` int(11) NOT NULL auto_increment,
491 `debtor_no` int(11) NOT NULL default '0',
492 `br_name` varchar(60) NOT NULL default '',
493 `branch_ref` varchar(30) NOT NULL default '',
494 `br_address` tinytext NOT NULL,
495 `area` int(11) default NULL,
496 `salesman` int(11) NOT NULL default '0',
497 `phone` varchar(30) NOT NULL default '',
498 `fax` varchar(30) NOT NULL default '',
499 `contact_name` varchar(60) NOT NULL default '',
500 `email` varchar(100) NOT NULL default '',
501 `default_location` varchar(5) NOT NULL default '',
502 `tax_group_id` int(11) default NULL,
503 `sales_account` varchar(11) default NULL,
504 `sales_discount_account` varchar(11) default NULL,
505 `receivables_account` varchar(11) default NULL,
506 `payment_discount_account` varchar(11) default NULL,
507 `default_ship_via` int(11) NOT NULL default '1',
508 `disable_trans` tinyint(4) NOT NULL default '0',
509 `br_post_address` tinytext NOT NULL,
510 `group_no` int(11) NOT NULL default '0',
511 `inactive` tinyint(1) NOT NULL default '0',
512 PRIMARY KEY (`branch_code`,`debtor_no`),
513 KEY `branch_code` (`branch_code`),
514 KEY `br_name` (`br_name`)
515 ) TYPE=MyISAM AUTO_INCREMENT=4 ;
518 ### Data of table `0_cust_branch` ###
520 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');
521 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');
522 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');
525 ### Structure of table `0_debtor_trans` ###
527 DROP TABLE IF EXISTS `0_debtor_trans`;
529 CREATE TABLE `0_debtor_trans` (
530 `trans_no` int(11) unsigned NOT NULL default '0',
531 `type` smallint(6) unsigned NOT NULL default '0',
532 `version` tinyint(1) unsigned NOT NULL default '0',
533 `debtor_no` int(11) unsigned default NULL,
534 `branch_code` int(11) NOT NULL default '-1',
535 `tran_date` date NOT NULL default '0000-00-00',
536 `due_date` date NOT NULL default '0000-00-00',
537 `reference` varchar(60) NOT NULL default '',
538 `tpe` int(11) NOT NULL default '0',
539 `order_` int(11) NOT NULL default '0',
540 `ov_amount` double NOT NULL default '0',
541 `ov_gst` double NOT NULL default '0',
542 `ov_freight` double NOT NULL default '0',
543 `ov_freight_tax` double NOT NULL default '0',
544 `ov_discount` double NOT NULL default '0',
545 `alloc` double NOT NULL default '0',
546 `rate` double NOT NULL default '1',
547 `ship_via` int(11) default NULL,
548 `trans_link` int(11) NOT NULL default '0',
549 `dimension_id` int(11) NOT NULL default '0',
550 `dimension2_id` int(11) NOT NULL default '0',
551 PRIMARY KEY (`trans_no`,`type`),
552 KEY `debtor_no` (`debtor_no`,`branch_code`)
556 ### Data of table `0_debtor_trans` ###
558 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');
559 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');
560 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');
561 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');
562 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');
563 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');
564 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');
565 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');
568 ### Structure of table `0_debtor_trans_details` ###
570 DROP TABLE IF EXISTS `0_debtor_trans_details`;
572 CREATE TABLE `0_debtor_trans_details` (
573 `id` int(11) NOT NULL auto_increment,
574 `debtor_trans_no` int(11) default NULL,
575 `debtor_trans_type` int(11) default NULL,
576 `stock_id` varchar(20) NOT NULL default '',
577 `description` tinytext,
578 `unit_price` double NOT NULL default '0',
579 `unit_tax` double NOT NULL default '0',
580 `quantity` double NOT NULL default '0',
581 `discount_percent` double NOT NULL default '0',
582 `standard_cost` double NOT NULL default '0',
583 `qty_done` double NOT NULL default '0',
585 ) TYPE=InnoDB AUTO_INCREMENT=9 ;
588 ### Data of table `0_debtor_trans_details` ###
590 INSERT INTO `0_debtor_trans_details` VALUES ('1', '2', '13', '102', '17inch VGA Monitor', '30.4', '0', '2', '0', '10', '0');
591 INSERT INTO `0_debtor_trans_details` VALUES ('2', '3', '13', '102', '17inch VGA Monitor', '50', '2.5', '1', '0', '10', '1');
592 INSERT INTO `0_debtor_trans_details` VALUES ('3', '17', '10', '102', '17inch VGA Monitor', '50', '2.5', '1', '0', '10', '0');
593 INSERT INTO `0_debtor_trans_details` VALUES ('4', '4', '13', '102', '17inch VGA Monitor', '35.89', '1.79', '1', '0', '10', '1');
594 INSERT INTO `0_debtor_trans_details` VALUES ('5', '18', '10', '102', '17inch VGA Monitor', '35.89', '1.79', '1', '0', '10', '1');
595 INSERT INTO `0_debtor_trans_details` VALUES ('6', '5', '13', '102', '17inch VGA Monitor', '50', '2.38', '1', '0', '10', '1');
596 INSERT INTO `0_debtor_trans_details` VALUES ('7', '19', '10', '102', '17inch VGA Monitor', '50', '2.38', '1', '0', '10', '0');
597 INSERT INTO `0_debtor_trans_details` VALUES ('8', '3', '11', '102', '17inch VGA Monitor', '35.89', '1.79', '1', '0', '10', '0');
600 ### Structure of table `0_debtors_master` ###
602 DROP TABLE IF EXISTS `0_debtors_master`;
604 CREATE TABLE `0_debtors_master` (
605 `debtor_no` int(11) NOT NULL auto_increment,
606 `name` varchar(80) NOT NULL default '',
607 `debtor_ref` varchar(30) NOT NULL,
609 `email` varchar(100) NOT NULL default '',
610 `tax_id` varchar(55) NOT NULL default '',
611 `curr_code` char(3) NOT NULL default '',
612 `sales_type` int(11) NOT NULL default '1',
613 `dimension_id` int(11) NOT NULL default '0',
614 `dimension2_id` int(11) NOT NULL default '0',
615 `credit_status` int(11) NOT NULL default '0',
616 `payment_terms` int(11) default NULL,
617 `discount` double NOT NULL default '0',
618 `pymt_discount` double NOT NULL default '0',
619 `credit_limit` float NOT NULL default '1000',
620 `inactive` tinyint(1) NOT NULL default '0',
621 PRIMARY KEY (`debtor_no`),
622 UNIQUE KEY `name` (`name`)
623 ) TYPE=MyISAM AUTO_INCREMENT=4 ;
626 ### Data of table `0_debtors_master` ###
628 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');
629 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');
630 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');
633 ### Structure of table `0_dimensions` ###
635 DROP TABLE IF EXISTS `0_dimensions`;
637 CREATE TABLE `0_dimensions` (
638 `id` int(11) NOT NULL auto_increment,
639 `reference` varchar(60) NOT NULL default '',
640 `name` varchar(60) NOT NULL default '',
641 `type_` tinyint(1) NOT NULL default '1',
642 `closed` tinyint(1) NOT NULL default '0',
643 `date_` date NOT NULL default '0000-00-00',
644 `due_date` date NOT NULL default '0000-00-00',
646 UNIQUE KEY `reference` (`reference`)
647 ) TYPE=InnoDB AUTO_INCREMENT=3 ;
650 ### Data of table `0_dimensions` ###
652 INSERT INTO `0_dimensions` VALUES ('1', '1', 'Support', '1', '0', '2009-06-21', '2015-07-11');
653 INSERT INTO `0_dimensions` VALUES ('2', '2', 'Development', '1', '0', '2009-06-21', '2015-07-11');
656 ### Structure of table `0_exchange_rates` ###
658 DROP TABLE IF EXISTS `0_exchange_rates`;
660 CREATE TABLE `0_exchange_rates` (
661 `id` int(11) NOT NULL auto_increment,
662 `curr_code` char(3) NOT NULL default '',
663 `rate_buy` double NOT NULL default '0',
664 `rate_sell` double NOT NULL default '0',
665 `date_` date NOT NULL default '0000-00-00',
667 UNIQUE KEY `curr_code` (`curr_code`,`date_`)
668 ) TYPE=MyISAM AUTO_INCREMENT=4 ;
671 ### Data of table `0_exchange_rates` ###
673 INSERT INTO `0_exchange_rates` VALUES ('1', 'DKK', '0.18717252868313', '0.18717252868313', '2009-06-21');
674 INSERT INTO `0_exchange_rates` VALUES ('2', 'GBP', '1.6445729799917', '1.6445729799917', '2009-06-21');
675 INSERT INTO `0_exchange_rates` VALUES ('3', 'EUR', '1.3932', '1.3932', '2009-06-21');
678 ### Structure of table `0_fiscal_year` ###
680 DROP TABLE IF EXISTS `0_fiscal_year`;
682 CREATE TABLE `0_fiscal_year` (
683 `id` int(11) NOT NULL auto_increment,
684 `begin` date default '0000-00-00',
685 `end` date default '0000-00-00',
686 `closed` tinyint(1) NOT NULL default '0',
688 ) TYPE=InnoDB AUTO_INCREMENT=3 ;
691 ### Data of table `0_fiscal_year` ###
693 INSERT INTO `0_fiscal_year` VALUES ('1', '2008-01-01', '2008-12-31', '0');
694 INSERT INTO `0_fiscal_year` VALUES ('2', '2009-01-01', '2009-12-31', '0');
697 ### Structure of table `0_gl_trans` ###
699 DROP TABLE IF EXISTS `0_gl_trans`;
701 CREATE TABLE `0_gl_trans` (
702 `counter` int(11) NOT NULL auto_increment,
703 `type` smallint(6) NOT NULL default '0',
704 `type_no` bigint(16) NOT NULL default '1',
705 `tran_date` date NOT NULL default '0000-00-00',
706 `account` varchar(11) NOT NULL default '',
707 `memo_` tinytext NOT NULL,
708 `amount` double NOT NULL default '0',
709 `dimension_id` int(11) NOT NULL default '0',
710 `dimension2_id` int(11) NOT NULL default '0',
711 `person_type_id` int(11) default NULL,
712 `person_id` tinyblob,
713 PRIMARY KEY (`counter`),
714 KEY `Type_and_Number` (`type`,`type_no`)
715 ) TYPE=InnoDB AUTO_INCREMENT=84 ;
718 ### Data of table `0_gl_trans` ###
720 INSERT INTO `0_gl_trans` VALUES ('1', '20', '7', '2009-06-21', '2100', '', '-3465', '0', '0', '3', '2');
721 INSERT INTO `0_gl_trans` VALUES ('2', '20', '7', '2009-06-21', '1510', '', '1000', '0', '0', '3', '2');
722 INSERT INTO `0_gl_trans` VALUES ('3', '20', '7', '2009-06-21', '1510', '', '1100', '0', '0', '3', '2');
723 INSERT INTO `0_gl_trans` VALUES ('4', '20', '7', '2009-06-21', '1510', '', '1200', '0', '0', '3', '2');
724 INSERT INTO `0_gl_trans` VALUES ('5', '20', '7', '2009-06-21', '2150', '', '165', '0', '0', '3', '2');
725 INSERT INTO `0_gl_trans` VALUES ('6', '22', '4', '2009-06-21', '2100', '', '3465', '0', '0', '3', '2');
726 INSERT INTO `0_gl_trans` VALUES ('7', '22', '4', '2009-06-21', '1060', '', '-3465', '0', '0', '3', '2');
727 INSERT INTO `0_gl_trans` VALUES ('8', '26', '1', '2009-06-21', '1510', '', '-100', '0', '0', '', '');
728 INSERT INTO `0_gl_trans` VALUES ('9', '26', '1', '2009-06-21', '1510', '', '-110', '0', '0', '', '');
729 INSERT INTO `0_gl_trans` VALUES ('10', '26', '1', '2009-06-21', '1510', '', '-120', '0', '0', '', '');
730 INSERT INTO `0_gl_trans` VALUES ('11', '26', '1', '2009-06-21', '1060', 'Overhead Cost', '-10', '0', '0', '1', '1');
731 INSERT INTO `0_gl_trans` VALUES ('12', '26', '1', '2009-06-21', '1530', 'Overhead Cost', '10', '0', '0', '1', '1');
732 INSERT INTO `0_gl_trans` VALUES ('13', '26', '1', '2009-06-21', '1060', 'Labour Cost', '-20', '0', '0', '1', '0');
733 INSERT INTO `0_gl_trans` VALUES ('14', '26', '1', '2009-06-21', '1530', 'Labour Cost', '20', '0', '0', '1', '0');
734 INSERT INTO `0_gl_trans` VALUES ('15', '26', '1', '2009-06-21', '1510', '', '330', '0', '0', '', '');
735 INSERT INTO `0_gl_trans` VALUES ('16', '13', '2', '2009-06-21', '5010', '', '20', '0', '0', '2', '1');
736 INSERT INTO `0_gl_trans` VALUES ('17', '13', '2', '2009-06-21', '1510', '', '-20', '0', '0', '2', '1');
737 INSERT INTO `0_gl_trans` VALUES ('18', '13', '3', '2009-06-21', '5010', '', '10', '0', '0', '2', '2');
738 INSERT INTO `0_gl_trans` VALUES ('19', '13', '3', '2009-06-21', '1510', '', '-10', '0', '0', '2', '2');
739 INSERT INTO `0_gl_trans` VALUES ('20', '10', '17', '2009-06-21', '4010', '', '-50', '0', '0', '2', '2');
740 INSERT INTO `0_gl_trans` VALUES ('21', '10', '17', '2009-06-21', '1200', '', '52.5', '0', '0', '2', '2');
741 INSERT INTO `0_gl_trans` VALUES ('22', '10', '17', '2009-06-21', '2150', '', '-2.5', '0', '0', '2', '2');
742 INSERT INTO `0_gl_trans` VALUES ('23', '13', '4', '2009-06-21', '5010', '', '10', '2', '0', '2', '3');
743 INSERT INTO `0_gl_trans` VALUES ('24', '13', '4', '2009-06-21', '1510', '', '-10', '0', '0', '2', '3');
744 INSERT INTO `0_gl_trans` VALUES ('25', '10', '18', '2009-06-21', '4010', '', '-50', '2', '0', '2', '3');
745 INSERT INTO `0_gl_trans` VALUES ('26', '10', '18', '2009-06-21', '1200', '', '52.5', '0', '0', '2', '3');
746 INSERT INTO `0_gl_trans` VALUES ('27', '10', '18', '2009-06-21', '2150', '', '-2.5', '0', '0', '2', '3');
747 INSERT INTO `0_gl_trans` VALUES ('28', '0', '18', '2009-02-20', '1060', '', '1000', '0', '0', '', '');
748 INSERT INTO `0_gl_trans` VALUES ('29', '0', '18', '2009-02-20', '3350', '', '-1000', '0', '0', '', '');
749 INSERT INTO `0_gl_trans` VALUES ('30', '0', '19', '2009-02-21', '1060', '', '4000', '0', '0', '', '');
750 INSERT INTO `0_gl_trans` VALUES ('31', '0', '19', '2009-02-21', '3350', '', '-4000', '0', '0', '', '');
751 INSERT INTO `0_gl_trans` VALUES ('32', '26', '3', '2009-06-21', '1510', '', '-20', '0', '0', '', '');
752 INSERT INTO `0_gl_trans` VALUES ('33', '26', '3', '2009-06-21', '1510', '', '-22', '0', '0', '', '');
753 INSERT INTO `0_gl_trans` VALUES ('34', '26', '3', '2009-06-21', '1510', '', '-24', '0', '0', '', '');
754 INSERT INTO `0_gl_trans` VALUES ('35', '26', '3', '2009-06-21', '1540', '', '66', '0', '0', '', '');
755 INSERT INTO `0_gl_trans` VALUES ('36', '2', '5', '2009-06-21', '2150', 'Cash Sales', '-4.76', '0', '0', '4', '3');
756 INSERT INTO `0_gl_trans` VALUES ('37', '2', '5', '2009-06-21', '4010', 'Cash Sales', '-95.24', '0', '0', '4', '3');
757 INSERT INTO `0_gl_trans` VALUES ('38', '2', '5', '2009-06-21', '1060', '', '100', '0', '0', '4', '3');
758 INSERT INTO `0_gl_trans` VALUES ('39', '1', '8', '2009-06-21', '2150', 'Maintenance', '2.38', '0', '0', '4', '1');
759 INSERT INTO `0_gl_trans` VALUES ('40', '1', '8', '2009-06-21', '5765', 'Maintenance', '47.62', '0', '0', '4', '1');
760 INSERT INTO `0_gl_trans` VALUES ('41', '1', '8', '2009-06-21', '1060', '', '-50', '0', '0', '4', '1');
761 INSERT INTO `0_gl_trans` VALUES ('42', '20', '8', '2009-06-21', '2100', '', '-20', '0', '0', '3', '2');
762 INSERT INTO `0_gl_trans` VALUES ('43', '20', '8', '2009-06-21', '2150', '', '0.95', '0', '0', '3', '2');
763 INSERT INTO `0_gl_trans` VALUES ('44', '20', '8', '2009-06-21', '5780', '', '19.05', '0', '0', '3', '2');
764 INSERT INTO `0_gl_trans` VALUES ('45', '26', '4', '2009-06-21', '1510', '', '-40', '0', '0', '', '');
765 INSERT INTO `0_gl_trans` VALUES ('46', '26', '4', '2009-06-21', '1510', '', '-44', '0', '0', '', '');
766 INSERT INTO `0_gl_trans` VALUES ('47', '26', '4', '2009-06-21', '1510', '', '-48', '0', '0', '', '');
767 INSERT INTO `0_gl_trans` VALUES ('48', '26', '4', '2009-06-21', '1540', '', '132', '0', '0', '', '');
768 INSERT INTO `0_gl_trans` VALUES ('49', '26', '2', '2009-06-21', '1510', '', '-20', '0', '0', '', '');
769 INSERT INTO `0_gl_trans` VALUES ('50', '26', '2', '2009-06-21', '1510', '', '-22', '0', '0', '', '');
770 INSERT INTO `0_gl_trans` VALUES ('51', '26', '2', '2009-06-21', '1510', '', '-24', '0', '0', '', '');
771 INSERT INTO `0_gl_trans` VALUES ('52', '26', '2', '2009-06-21', '1540', '', '66', '0', '0', '', '');
772 INSERT INTO `0_gl_trans` VALUES ('53', '26', '5', '2009-06-21', '1510', '', '-50', '0', '0', '', '');
773 INSERT INTO `0_gl_trans` VALUES ('54', '26', '5', '2009-06-21', '1510', '', '-55', '0', '0', '', '');
774 INSERT INTO `0_gl_trans` VALUES ('55', '26', '5', '2009-06-21', '1510', '', '-60', '0', '0', '', '');
775 INSERT INTO `0_gl_trans` VALUES ('56', '26', '5', '2009-06-21', '1060', 'Overhead Cost', '-10', '0', '0', '1', '1');
776 INSERT INTO `0_gl_trans` VALUES ('57', '26', '5', '2009-06-21', '1530', 'Overhead Cost', '10', '0', '0', '1', '1');
777 INSERT INTO `0_gl_trans` VALUES ('58', '26', '5', '2009-06-21', '1060', 'Labour Cost', '-20', '0', '0', '1', '0');
778 INSERT INTO `0_gl_trans` VALUES ('59', '26', '5', '2009-06-21', '1530', 'Labour Cost', '20', '0', '0', '1', '0');
779 INSERT INTO `0_gl_trans` VALUES ('60', '26', '5', '2009-06-21', '1540', '', '165', '0', '0', '', '');
780 INSERT INTO `0_gl_trans` VALUES ('61', '26', '6', '2009-06-21', '1510', '', '50', '0', '0', '', '');
781 INSERT INTO `0_gl_trans` VALUES ('62', '26', '6', '2009-06-21', '1510', '', '55', '0', '0', '', '');
782 INSERT INTO `0_gl_trans` VALUES ('63', '26', '6', '2009-06-21', '1510', '', '60', '0', '0', '', '');
783 INSERT INTO `0_gl_trans` VALUES ('64', '26', '6', '2009-06-21', '1540', '', '-165', '0', '0', '', '');
784 INSERT INTO `0_gl_trans` VALUES ('65', '26', '7', '2009-06-21', '1510', '', '20', '0', '0', '', '');
785 INSERT INTO `0_gl_trans` VALUES ('66', '26', '7', '2009-06-21', '1510', '', '22', '0', '0', '', '');
786 INSERT INTO `0_gl_trans` VALUES ('67', '26', '7', '2009-06-21', '1510', '', '24', '0', '0', '', '');
787 INSERT INTO `0_gl_trans` VALUES ('68', '26', '7', '2009-06-21', '1060', 'Overhead Cost', '-10', '0', '0', '1', '1');
788 INSERT INTO `0_gl_trans` VALUES ('69', '26', '7', '2009-06-21', '1530', 'Overhead Cost', '10', '0', '0', '1', '1');
789 INSERT INTO `0_gl_trans` VALUES ('70', '26', '7', '2009-06-21', '1060', 'Labour Cost', '-20', '0', '0', '1', '0');
790 INSERT INTO `0_gl_trans` VALUES ('71', '26', '7', '2009-06-21', '1530', 'Labour Cost', '20', '0', '0', '1', '0');
791 INSERT INTO `0_gl_trans` VALUES ('72', '26', '7', '2009-06-21', '1540', '', '-66', '0', '0', '', '');
792 INSERT INTO `0_gl_trans` VALUES ('73', '13', '5', '2009-06-21', '5010', '', '10', '0', '0', '2', '2');
793 INSERT INTO `0_gl_trans` VALUES ('74', '13', '5', '2009-06-21', '1510', '', '-10', '0', '0', '2', '2');
794 INSERT INTO `0_gl_trans` VALUES ('75', '10', '19', '2009-06-21', '4010', '', '-47.62', '0', '0', '2', '2');
795 INSERT INTO `0_gl_trans` VALUES ('76', '10', '19', '2009-06-21', '1200', '', '55', '0', '0', '2', '2');
796 INSERT INTO `0_gl_trans` VALUES ('77', '10', '19', '2009-06-21', '4430', '', '-5', '0', '0', '2', '2');
797 INSERT INTO `0_gl_trans` VALUES ('78', '10', '19', '2009-06-21', '2150', '', '-2.38', '0', '0', '2', '2');
798 INSERT INTO `0_gl_trans` VALUES ('79', '11', '3', '2009-06-21', '5010', '', '-10', '2', '0', '2', '3');
799 INSERT INTO `0_gl_trans` VALUES ('80', '11', '3', '2009-06-21', '1510', '', '10', '0', '0', '2', '3');
800 INSERT INTO `0_gl_trans` VALUES ('81', '11', '3', '2009-06-21', '4010', '', '50', '2', '0', '2', '3');
801 INSERT INTO `0_gl_trans` VALUES ('82', '11', '3', '2009-06-21', '1200', '', '-52.5', '0', '0', '2', '3');
802 INSERT INTO `0_gl_trans` VALUES ('83', '11', '3', '2009-06-21', '2150', '', '2.5', '0', '0', '2', '3');
805 ### Structure of table `0_grn_batch` ###
807 DROP TABLE IF EXISTS `0_grn_batch`;
809 CREATE TABLE `0_grn_batch` (
810 `id` int(11) NOT NULL auto_increment,
811 `supplier_id` int(11) NOT NULL default '0',
812 `purch_order_no` int(11) default NULL,
813 `reference` varchar(60) NOT NULL default '',
814 `delivery_date` date NOT NULL default '0000-00-00',
815 `loc_code` varchar(5) default NULL,
817 ) TYPE=InnoDB AUTO_INCREMENT=2 ;
820 ### Data of table `0_grn_batch` ###
822 INSERT INTO `0_grn_batch` VALUES ('1', '2', '1', '1', '2009-06-21', 'DEF');
825 ### Structure of table `0_grn_items` ###
827 DROP TABLE IF EXISTS `0_grn_items`;
829 CREATE TABLE `0_grn_items` (
830 `id` int(11) NOT NULL auto_increment,
831 `grn_batch_id` int(11) default NULL,
832 `po_detail_item` int(11) NOT NULL default '0',
833 `item_code` varchar(20) NOT NULL default '',
834 `description` tinytext,
835 `qty_recd` double NOT NULL default '0',
836 `quantity_inv` double NOT NULL default '0',
838 ) TYPE=InnoDB AUTO_INCREMENT=4 ;
841 ### Data of table `0_grn_items` ###
843 INSERT INTO `0_grn_items` VALUES ('1', '1', '1', '102', '17inch VGA Monitor', '100', '100');
844 INSERT INTO `0_grn_items` VALUES ('2', '1', '2', '103', '32MB VGA Card', '100', '100');
845 INSERT INTO `0_grn_items` VALUES ('3', '1', '3', '104', '52x CD Drive', '100', '100');
848 ### Structure of table `0_groups` ###
850 DROP TABLE IF EXISTS `0_groups`;
852 CREATE TABLE `0_groups` (
853 `id` smallint(6) unsigned NOT NULL auto_increment,
854 `description` varchar(60) NOT NULL default '',
855 `inactive` tinyint(1) NOT NULL default '0',
857 UNIQUE KEY `description` (`description`)
858 ) TYPE=MyISAM AUTO_INCREMENT=4 AUTO_INCREMENT=4 ;
861 ### Data of table `0_groups` ###
863 INSERT INTO `0_groups` VALUES ('1', 'Small', '0');
864 INSERT INTO `0_groups` VALUES ('2', 'Medium', '0');
865 INSERT INTO `0_groups` VALUES ('3', 'Large', '0');
868 ### Structure of table `0_item_codes` ###
870 DROP TABLE IF EXISTS `0_item_codes`;
872 CREATE TABLE `0_item_codes` (
873 `id` int(11) unsigned NOT NULL auto_increment,
874 `item_code` varchar(20) NOT NULL,
875 `stock_id` varchar(20) NOT NULL,
876 `description` varchar(200) NOT NULL default '',
877 `category_id` smallint(6) unsigned NOT NULL,
878 `quantity` double NOT NULL default '1',
879 `is_foreign` tinyint(1) NOT NULL default '0',
880 `inactive` tinyint(1) NOT NULL default '0',
882 UNIQUE KEY `stock_id` (`stock_id`,`item_code`)
883 ) TYPE=MyISAM AUTO_INCREMENT=6 ;
886 ### Data of table `0_item_codes` ###
888 INSERT INTO `0_item_codes` VALUES ('1', '102', '102', '17inch VGA Monitor', '1', '1', '0', '0');
889 INSERT INTO `0_item_codes` VALUES ('2', '103', '103', '32MB VGA Card', '1', '1', '0', '0');
890 INSERT INTO `0_item_codes` VALUES ('3', '104', '104', '52x CD Drive', '1', '1', '0', '0');
891 INSERT INTO `0_item_codes` VALUES ('4', '3400', '3400', 'P4 Business System', '3', '1', '0', '0');
892 INSERT INTO `0_item_codes` VALUES ('5', '201', '201', 'Assembly Labour', '4', '1', '0', '0');
895 ### Structure of table `0_item_tax_type_exemptions` ###
897 DROP TABLE IF EXISTS `0_item_tax_type_exemptions`;
899 CREATE TABLE `0_item_tax_type_exemptions` (
900 `item_tax_type_id` int(11) NOT NULL default '0',
901 `tax_type_id` int(11) NOT NULL default '0',
902 PRIMARY KEY (`item_tax_type_id`,`tax_type_id`)
906 ### Data of table `0_item_tax_type_exemptions` ###
910 ### Structure of table `0_item_tax_types` ###
912 DROP TABLE IF EXISTS `0_item_tax_types`;
914 CREATE TABLE `0_item_tax_types` (
915 `id` int(11) NOT NULL auto_increment,
916 `name` varchar(60) NOT NULL default '',
917 `exempt` tinyint(1) NOT NULL default '0',
918 `inactive` tinyint(1) NOT NULL default '0',
920 UNIQUE KEY `name` (`name`)
921 ) TYPE=InnoDB AUTO_INCREMENT=2 ;
924 ### Data of table `0_item_tax_types` ###
926 INSERT INTO `0_item_tax_types` VALUES ('1', 'Regular', '0', '0');
928 ### Structure of table `0_item_units` ###
930 DROP TABLE IF EXISTS `0_item_units`;
932 CREATE TABLE `0_item_units` (
933 `abbr` varchar(20) NOT NULL,
934 `name` varchar(40) NOT NULL,
935 `decimals` tinyint(2) NOT NULL,
936 `inactive` tinyint(1) NOT NULL default '0',
937 PRIMARY KEY (`abbr`),
938 UNIQUE KEY `name` (`name`)
942 ### Data of table `0_item_units` ###
944 INSERT INTO `0_item_units` VALUES ('ea.', 'Each', '0', '0');
945 INSERT INTO `0_item_units` VALUES ('hrs', 'Hours', '1', '0');
948 ### Structure of table `0_loc_stock` ###
950 DROP TABLE IF EXISTS `0_loc_stock`;
952 CREATE TABLE `0_loc_stock` (
953 `loc_code` char(5) NOT NULL default '',
954 `stock_id` char(20) NOT NULL default '',
955 `reorder_level` bigint(20) NOT NULL default '0',
956 PRIMARY KEY (`loc_code`,`stock_id`),
957 KEY `stock_id` (`stock_id`)
961 ### Data of table `0_loc_stock` ###
963 INSERT INTO `0_loc_stock` VALUES ('DEF', '102', '0');
964 INSERT INTO `0_loc_stock` VALUES ('DEF', '103', '0');
965 INSERT INTO `0_loc_stock` VALUES ('DEF', '104', '0');
966 INSERT INTO `0_loc_stock` VALUES ('DEF', '201', '0');
967 INSERT INTO `0_loc_stock` VALUES ('DEF', '3400', '0');
970 ### Structure of table `0_locations` ###
972 DROP TABLE IF EXISTS `0_locations`;
974 CREATE TABLE `0_locations` (
975 `loc_code` varchar(5) NOT NULL default '',
976 `location_name` varchar(60) NOT NULL default '',
977 `delivery_address` tinytext NOT NULL,
978 `phone` varchar(30) NOT NULL default '',
979 `fax` varchar(30) NOT NULL default '',
980 `email` varchar(100) NOT NULL default '',
981 `contact` varchar(30) NOT NULL default '',
982 `inactive` tinyint(1) NOT NULL default '0',
983 PRIMARY KEY (`loc_code`)
987 ### Data of table `0_locations` ###
989 INSERT INTO `0_locations` VALUES ('DEF', 'Default', 'Delivery 1\r\nDelivery 2\r\nDelivery 3', '', '', '', '', '0');
992 ### Structure of table `0_movement_types` ###
994 DROP TABLE IF EXISTS `0_movement_types`;
996 CREATE TABLE `0_movement_types` (
997 `id` int(11) NOT NULL auto_increment,
998 `name` varchar(60) NOT NULL default '',
999 `inactive` tinyint(1) NOT NULL default '0',
1001 UNIQUE KEY `name` (`name`)
1002 ) TYPE=MyISAM AUTO_INCREMENT=2 ;
1005 ### Data of table `0_movement_types` ###
1007 INSERT INTO `0_movement_types` VALUES ('1', 'Adjustment', '0');
1010 ### Structure of table `0_payment_terms` ###
1012 DROP TABLE IF EXISTS `0_payment_terms`;
1014 CREATE TABLE `0_payment_terms` (
1015 `terms_indicator` int(11) NOT NULL auto_increment,
1016 `terms` char(80) NOT NULL default '',
1017 `days_before_due` smallint(6) NOT NULL default '0',
1018 `day_in_following_month` smallint(6) NOT NULL default '0',
1019 `inactive` tinyint(1) NOT NULL default '0',
1020 PRIMARY KEY (`terms_indicator`),
1021 UNIQUE KEY `terms` (`terms`)
1022 ) TYPE=MyISAM AUTO_INCREMENT=5 ;
1025 ### Data of table `0_payment_terms` ###
1027 INSERT INTO `0_payment_terms` VALUES ('1', 'Due 15th Of the Following Month', '0', '17', '0');
1028 INSERT INTO `0_payment_terms` VALUES ('2', 'Due By End Of The Following Month', '0', '30', '0');
1029 INSERT INTO `0_payment_terms` VALUES ('3', 'Payment due within 10 days', '10', '0', '0');
1030 INSERT INTO `0_payment_terms` VALUES ('4', 'Cash Only', '1', '0', '0');
1033 ### Structure of table `0_prices` ###
1035 DROP TABLE IF EXISTS `0_prices`;
1037 CREATE TABLE `0_prices` (
1038 `id` int(11) NOT NULL auto_increment,
1039 `stock_id` varchar(20) NOT NULL default '',
1040 `sales_type_id` int(11) NOT NULL default '0',
1041 `curr_abrev` char(3) NOT NULL default '',
1042 `price` double NOT NULL default '0',
1044 UNIQUE KEY `price` (`stock_id`,`sales_type_id`,`curr_abrev`)
1045 ) TYPE=MyISAM AUTO_INCREMENT=5 ;
1048 ### Data of table `0_prices` ###
1050 INSERT INTO `0_prices` VALUES ('1', '3400', '1', 'USD', '100');
1051 INSERT INTO `0_prices` VALUES ('2', '102', '1', 'USD', '50');
1052 INSERT INTO `0_prices` VALUES ('3', '103', '1', 'USD', '55');
1053 INSERT INTO `0_prices` VALUES ('4', '104', '1', 'USD', '60');
1056 ### Structure of table `0_print_profiles` ###
1058 DROP TABLE IF EXISTS `0_print_profiles`;
1060 CREATE TABLE `0_print_profiles` (
1061 `id` smallint(6) unsigned NOT NULL auto_increment,
1062 `profile` varchar(30) NOT NULL,
1063 `report` varchar(5) default NULL,
1064 `printer` tinyint(3) unsigned default NULL,
1066 UNIQUE KEY `profile` (`profile`,`report`)
1067 ) TYPE=MyISAM AUTO_INCREMENT=10 ;
1070 ### Data of table `0_print_profiles` ###
1072 INSERT INTO `0_print_profiles` VALUES ('1', 'Out of office', '', '0');
1073 INSERT INTO `0_print_profiles` VALUES ('2', 'Sales Department', '', '0');
1074 INSERT INTO `0_print_profiles` VALUES ('3', 'Central', '', '2');
1075 INSERT INTO `0_print_profiles` VALUES ('4', 'Sales Department', '104', '2');
1076 INSERT INTO `0_print_profiles` VALUES ('5', 'Sales Department', '105', '2');
1077 INSERT INTO `0_print_profiles` VALUES ('6', 'Sales Department', '107', '2');
1078 INSERT INTO `0_print_profiles` VALUES ('7', 'Sales Department', '109', '2');
1079 INSERT INTO `0_print_profiles` VALUES ('8', 'Sales Department', '110', '2');
1080 INSERT INTO `0_print_profiles` VALUES ('9', 'Sales Department', '201', '2');
1083 ### Structure of table `0_printers` ###
1085 DROP TABLE IF EXISTS `0_printers`;
1087 CREATE TABLE `0_printers` (
1088 `id` tinyint(3) unsigned NOT NULL auto_increment,
1089 `name` varchar(20) NOT NULL,
1090 `description` varchar(60) NOT NULL,
1091 `queue` varchar(20) NOT NULL,
1092 `host` varchar(40) NOT NULL,
1093 `port` smallint(11) unsigned NOT NULL,
1094 `timeout` tinyint(3) unsigned NOT NULL,
1096 UNIQUE KEY `name` (`name`)
1097 ) TYPE=MyISAM AUTO_INCREMENT=4 ;
1100 ### Data of table `0_printers` ###
1102 INSERT INTO `0_printers` VALUES ('1', 'QL500', 'Label printer', 'QL500', 'server', '127', '20');
1103 INSERT INTO `0_printers` VALUES ('2', 'Samsung', 'Main network printer', 'scx4521F', 'server', '515', '5');
1104 INSERT INTO `0_printers` VALUES ('3', 'Local', 'Local print server at user IP', 'lp', '', '515', '10');
1107 ### Structure of table `0_purch_data` ###
1109 DROP TABLE IF EXISTS `0_purch_data`;
1111 CREATE TABLE `0_purch_data` (
1112 `supplier_id` int(11) NOT NULL default '0',
1113 `stock_id` char(20) NOT NULL default '',
1114 `price` double NOT NULL default '0',
1115 `suppliers_uom` char(50) NOT NULL default '',
1116 `conversion_factor` double NOT NULL default '1',
1117 `supplier_description` char(50) NOT NULL default '',
1118 PRIMARY KEY (`supplier_id`,`stock_id`)
1122 ### Data of table `0_purch_data` ###
1124 INSERT INTO `0_purch_data` VALUES ('2', '102', '10', '', '1', '17inch VGA Monitor');
1125 INSERT INTO `0_purch_data` VALUES ('2', '103', '11', '', '1', '32MB VGA Card');
1126 INSERT INTO `0_purch_data` VALUES ('2', '104', '12', '', '1', '52x CD Drive');
1129 ### Structure of table `0_purch_order_details` ###
1131 DROP TABLE IF EXISTS `0_purch_order_details`;
1133 CREATE TABLE `0_purch_order_details` (
1134 `po_detail_item` int(11) NOT NULL auto_increment,
1135 `order_no` int(11) NOT NULL default '0',
1136 `item_code` varchar(20) NOT NULL default '',
1137 `description` tinytext,
1138 `delivery_date` date NOT NULL default '0000-00-00',
1139 `qty_invoiced` double NOT NULL default '0',
1140 `unit_price` double NOT NULL default '0',
1141 `act_price` double NOT NULL default '0',
1142 `std_cost_unit` double NOT NULL default '0',
1143 `quantity_ordered` double NOT NULL default '0',
1144 `quantity_received` double NOT NULL default '0',
1145 PRIMARY KEY (`po_detail_item`)
1146 ) TYPE=InnoDB AUTO_INCREMENT=6 ;
1149 ### Data of table `0_purch_order_details` ###
1151 INSERT INTO `0_purch_order_details` VALUES ('1', '1', '102', '17inch VGA Monitor', '2009-07-01', '100', '10', '10', '10', '100', '100');
1152 INSERT INTO `0_purch_order_details` VALUES ('2', '1', '103', '32MB VGA Card', '2009-07-01', '100', '11', '11', '11', '100', '100');
1153 INSERT INTO `0_purch_order_details` VALUES ('3', '1', '104', '52x CD Drive', '2009-07-01', '100', '12', '12', '12', '100', '100');
1154 INSERT INTO `0_purch_order_details` VALUES ('4', '2', '102', '17inch VGA Monitor', '2009-07-01', '0', '5', '0', '0', '1', '0');
1155 INSERT INTO `0_purch_order_details` VALUES ('5', '2', '103', '32MB VGA Card', '2009-07-01', '0', '5', '0', '0', '1', '0');
1158 ### Structure of table `0_purch_orders` ###
1160 DROP TABLE IF EXISTS `0_purch_orders`;
1162 CREATE TABLE `0_purch_orders` (
1163 `order_no` int(11) NOT NULL auto_increment,
1164 `supplier_id` int(11) NOT NULL default '0',
1165 `comments` tinytext,
1166 `ord_date` date NOT NULL default '0000-00-00',
1167 `reference` tinytext NOT NULL,
1168 `requisition_no` tinytext,
1169 `into_stock_location` varchar(5) NOT NULL default '',
1170 `delivery_address` tinytext NOT NULL,
1171 PRIMARY KEY (`order_no`)
1172 ) TYPE=InnoDB AUTO_INCREMENT=3 ;
1175 ### Data of table `0_purch_orders` ###
1177 INSERT INTO `0_purch_orders` VALUES ('1', '2', '', '2009-06-01', '1', '', 'DEF', 'Delivery 1\r\nDelivery 2\r\nDelivery 3');
1178 INSERT INTO `0_purch_orders` VALUES ('2', '3', '', '2009-06-21', '2', '', 'DEF', 'Delivery 1\r\nDelivery 2\r\nDelivery 3');
1181 ### Structure of table `0_quick_entries` ###
1183 DROP TABLE IF EXISTS `0_quick_entries`;
1185 CREATE TABLE `0_quick_entries` (
1186 `id` smallint(6) unsigned NOT NULL auto_increment,
1187 `type` tinyint(1) NOT NULL default '0',
1188 `description` varchar(60) NOT NULL,
1189 `base_amount` double NOT NULL default '0',
1190 `base_desc` varchar(60) default NULL,
1192 KEY `description` (`description`)
1193 ) TYPE=MyISAM AUTO_INCREMENT=4 ;
1196 ### Data of table `0_quick_entries` ###
1198 INSERT INTO `0_quick_entries` VALUES ('1', '1', 'Maintenance', '0', 'Amount');
1199 INSERT INTO `0_quick_entries` VALUES ('2', '4', 'Phone', '0', 'Amount');
1200 INSERT INTO `0_quick_entries` VALUES ('3', '2', 'Cash Sales', '0', 'Amount');
1203 ### Structure of table `0_quick_entry_lines` ###
1205 DROP TABLE IF EXISTS `0_quick_entry_lines`;
1207 CREATE TABLE `0_quick_entry_lines` (
1208 `id` smallint(6) unsigned NOT NULL auto_increment,
1209 `qid` smallint(6) unsigned NOT NULL,
1210 `amount` double default '0',
1211 `action` varchar(2) NOT NULL,
1212 `dest_id` varchar(11) NOT NULL,
1213 `dimension_id` smallint(6) unsigned default NULL,
1214 `dimension2_id` smallint(6) unsigned default NULL,
1217 ) TYPE=MyISAM AUTO_INCREMENT=8 ;
1220 ### Data of table `0_quick_entry_lines` ###
1222 INSERT INTO `0_quick_entry_lines` VALUES ('1', '1', '0', 't-', '1', '0', '0');
1223 INSERT INTO `0_quick_entry_lines` VALUES ('2', '2', '0', 't-', '1', '0', '0');
1224 INSERT INTO `0_quick_entry_lines` VALUES ('3', '3', '0', 't-', '1', '0', '0');
1225 INSERT INTO `0_quick_entry_lines` VALUES ('4', '3', '0', '=', '4010', '0', '0');
1226 INSERT INTO `0_quick_entry_lines` VALUES ('5', '1', '0', '=', '5765', '0', '0');
1227 INSERT INTO `0_quick_entry_lines` VALUES ('6', '2', '0', '=', '5780', '0', '0');
1230 ### Structure of table `0_recurrent_invoices` ###
1232 DROP TABLE IF EXISTS `0_recurrent_invoices`;
1234 CREATE TABLE `0_recurrent_invoices` (
1235 `id` smallint(6) unsigned NOT NULL auto_increment,
1236 `description` varchar(60) NOT NULL default '',
1237 `order_no` int(11) unsigned NOT NULL,
1238 `debtor_no` int(11) unsigned default NULL,
1239 `group_no` smallint(6) unsigned default NULL,
1240 `days` int(11) NOT NULL default '0',
1241 `monthly` int(11) NOT NULL default '0',
1242 `begin` date NOT NULL default '0000-00-00',
1243 `end` date NOT NULL default '0000-00-00',
1244 `last_sent` date NOT NULL default '0000-00-00',
1246 UNIQUE KEY `description` (`description`)
1247 ) TYPE=InnoDB AUTO_INCREMENT=1 ;
1250 ### Data of table `0_recurrent_invoices` ###
1254 ### Structure of table `0_refs` ###
1256 DROP TABLE IF EXISTS `0_refs`;
1258 CREATE TABLE `0_refs` (
1259 `id` int(11) NOT NULL default '0',
1260 `type` int(11) NOT NULL default '0',
1261 `reference` varchar(100) NOT NULL default '',
1262 PRIMARY KEY (`id`,`type`)
1266 ### Data of table `0_refs` ###
1268 INSERT INTO `0_refs` VALUES ('18', '0', '1');
1269 INSERT INTO `0_refs` VALUES ('19', '0', '2');
1272 ### Structure of table `0_sales_order_details` ###
1274 DROP TABLE IF EXISTS `0_sales_order_details`;
1276 CREATE TABLE `0_sales_order_details` (
1277 `id` int(11) NOT NULL auto_increment,
1278 `order_no` int(11) NOT NULL default '0',
1279 `trans_type` smallint(6) NOT NULL default '30',
1280 `stk_code` varchar(20) NOT NULL default '',
1281 `description` tinytext,
1282 `qty_sent` double NOT NULL default '0',
1283 `unit_price` double NOT NULL default '0',
1284 `quantity` double NOT NULL default '0',
1285 `discount_percent` double NOT NULL default '0',
1287 ) TYPE=InnoDB AUTO_INCREMENT=6 ;
1290 ### Data of table `0_sales_order_details` ###
1292 INSERT INTO `0_sales_order_details` VALUES ('1', '1', '30', '102', '17inch VGA Monitor', '2', '30.4', '2', '0');
1293 INSERT INTO `0_sales_order_details` VALUES ('2', '2', '30', '102', '17inch VGA Monitor', '1', '50', '1', '0');
1294 INSERT INTO `0_sales_order_details` VALUES ('3', '3', '30', '102', '17inch VGA Monitor', '1', '35.89', '1', '0');
1295 INSERT INTO `0_sales_order_details` VALUES ('4', '4', '30', '102', '17inch VGA Monitor', '0', '21.28', '2', '0');
1296 INSERT INTO `0_sales_order_details` VALUES ('5', '5', '30', '102', '17inch VGA Monitor', '1', '50', '1', '0');
1299 ### Structure of table `0_sales_orders` ###
1301 DROP TABLE IF EXISTS `0_sales_orders`;
1303 CREATE TABLE `0_sales_orders` (
1304 `order_no` int(11) NOT NULL auto_increment,
1305 `trans_type` smallint(6) NOT NULL default '30',
1306 `version` tinyint(1) unsigned NOT NULL default '0',
1307 `type` tinyint(1) NOT NULL default '0',
1308 `debtor_no` int(11) NOT NULL default '0',
1309 `branch_code` int(11) NOT NULL default '0',
1310 `reference` varchar(100) NOT NULL default '',
1311 `customer_ref` tinytext NOT NULL,
1312 `comments` tinytext,
1313 `ord_date` date NOT NULL default '0000-00-00',
1314 `order_type` int(11) NOT NULL default '0',
1315 `ship_via` int(11) NOT NULL default '0',
1316 `delivery_address` tinytext NOT NULL,
1317 `contact_phone` varchar(30) default NULL,
1318 `contact_email` varchar(100) default NULL,
1319 `deliver_to` tinytext NOT NULL,
1320 `freight_cost` double NOT NULL default '0',
1321 `from_stk_loc` varchar(5) NOT NULL default '',
1322 `delivery_date` date NOT NULL default '0000-00-00',
1323 PRIMARY KEY (`trans_type`, `order_no`)
1326 ### Data of table `0_sales_orders` ###
1328 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');
1329 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');
1330 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');
1331 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');
1332 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');
1335 ### Structure of table `0_sales_pos` ###
1337 DROP TABLE IF EXISTS `0_sales_pos`;
1339 CREATE TABLE `0_sales_pos` (
1340 `id` smallint(6) unsigned NOT NULL auto_increment,
1341 `pos_name` varchar(30) NOT NULL,
1342 `cash_sale` tinyint(1) NOT NULL,
1343 `credit_sale` tinyint(1) NOT NULL,
1344 `pos_location` varchar(5) NOT NULL,
1345 `pos_account` smallint(6) unsigned NOT NULL,
1346 `inactive` tinyint(1) NOT NULL default '0',
1348 UNIQUE KEY `pos_name` (`pos_name`)
1349 ) TYPE=MyISAM AUTO_INCREMENT=2 ;
1352 ### Data of table `0_sales_pos` ###
1354 INSERT INTO `0_sales_pos` VALUES ('1', 'Default', '1', '1', 'DEF', '2', '0');
1357 ### Structure of table `0_sales_types` ###
1359 DROP TABLE IF EXISTS `0_sales_types`;
1361 CREATE TABLE `0_sales_types` (
1362 `id` int(11) NOT NULL auto_increment,
1363 `sales_type` char(50) NOT NULL default '',
1364 `tax_included` int(1) NOT NULL default '0',
1365 `factor` double NOT NULL default '1',
1366 `inactive` tinyint(1) NOT NULL default '0',
1368 UNIQUE KEY `sales_type` (`sales_type`)
1369 ) TYPE=MyISAM AUTO_INCREMENT=3 ;
1372 ### Data of table `0_sales_types` ###
1374 INSERT INTO `0_sales_types` VALUES ('1', 'Retail', '1', '1', '0');
1375 INSERT INTO `0_sales_types` VALUES ('2', 'Wholesale', '0', '0.7', '0');
1378 ### Structure of table `0_salesman` ###
1380 DROP TABLE IF EXISTS `0_salesman`;
1382 CREATE TABLE `0_salesman` (
1383 `salesman_code` int(11) NOT NULL auto_increment,
1384 `salesman_name` char(60) NOT NULL default '',
1385 `salesman_phone` char(30) NOT NULL default '',
1386 `salesman_fax` char(30) NOT NULL default '',
1387 `salesman_email` varchar(100) NOT NULL default '',
1388 `provision` double NOT NULL default '0',
1389 `break_pt` double NOT NULL default '0',
1390 `provision2` double NOT NULL default '0',
1391 `inactive` tinyint(1) NOT NULL default '0',
1392 PRIMARY KEY (`salesman_code`),
1393 UNIQUE KEY `salesman_name` (`salesman_name`)
1394 ) TYPE=MyISAM AUTO_INCREMENT=2 ;
1397 ### Data of table `0_salesman` ###
1399 INSERT INTO `0_salesman` VALUES ('1', 'Sales Person', '', '', '', '5', '1000', '4', '0');
1401 ### Structure of table `0_security_roles` ###
1403 DROP TABLE IF EXISTS `0_security_roles`;
1404 CREATE TABLE IF NOT EXISTS `0_security_roles` (
1405 `id` int(11) NOT NULL auto_increment,
1406 `role` varchar(30) NOT NULL,
1407 `description` varchar(50) default NULL,
1410 `inactive` tinyint(1) NOT NULL default '0',
1412 UNIQUE KEY `role` (`role`)
1413 ) TYPE=MyISAM AUTO_INCREMENT=11 ;
1416 -- Data of table `0_security_roles`
1419 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;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);
1420 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;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;3075;3076;3077;3078;3079;3080;3081;3329;3330;3331;3332;3333;3334;3335;5377;5633;5634;5635;5636;5637;5638;5639;5640;5641;5889;5891;7937;7938;7939;7940;8193;8194;8195;8196;8197;8449;8450;8451;10497;10753;10754;10755;10756;10757;11009;11010;11012;13313;13314;13315;15617;15618;15619;15620;15621;15622;15623;15624;15625;15626;15873;15874;15875;15876;15877;15878;15879;15880;15881;15882;15883;16129;16130;16131;16132', 0);
1421 INSERT INTO `0_security_roles` VALUES(3, 'Salesman', 'Salesman', '768;3072;5632;8192;15872', '773;774;3073;3075;3081;5633;8194;15873', 0);
1422 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;5891;8193;8194;8450;8451;10753;11009;11010;11012;13313;13315;15882;16129;16130;16131;16132', 0);
1423 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;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);
1424 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;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);
1425 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;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);
1426 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', '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;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);
1427 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;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);
1428 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', '521;523;524;771;772;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;5377;5633;5633;5634;5635;5637;5638;5639;5640;5640;5889;5891;8193;8194;8194;8196;8197;8449;8450;8451;10753;10755;11009;11010;11012;13313;13315;15617;15619;15620;15621;15624;15624;15873;15873;15874;15876;15877;15878;15879;15880;15882;16129;16129;16130;16130;16131;16132', 0);
1430 ### Structure of table `0_shippers` ###
1432 DROP TABLE IF EXISTS `0_shippers`;
1434 CREATE TABLE `0_shippers` (
1435 `shipper_id` int(11) NOT NULL auto_increment,
1436 `shipper_name` varchar(60) NOT NULL default '',
1437 `phone` varchar(30) NOT NULL default '',
1438 `contact` tinytext NOT NULL,
1439 `address` tinytext NOT NULL,
1440 `inactive` tinyint(1) NOT NULL default '0',
1441 PRIMARY KEY (`shipper_id`),
1442 UNIQUE KEY `name` (`shipper_name`)
1443 ) TYPE=MyISAM AUTO_INCREMENT=2 ;
1446 ### Data of table `0_shippers` ###
1448 INSERT INTO `0_shippers` VALUES ('1', 'Default', '', '', '', '0');
1451 ### Structure of table `0_sql_trail` ###
1453 DROP TABLE IF EXISTS `0_sql_trail`;
1455 CREATE TABLE `0_sql_trail` (
1456 `id` int(11) unsigned NOT NULL auto_increment,
1457 `sql` text NOT NULL,
1458 `result` tinyint(1) NOT NULL,
1459 `msg` varchar(255) NOT NULL,
1461 ) TYPE=MyISAM AUTO_INCREMENT=1 ;
1464 ### Data of table `0_sql_trail` ###
1468 ### Structure of table `0_stock_category` ###
1470 DROP TABLE IF EXISTS `0_stock_category`;
1472 CREATE TABLE `0_stock_category` (
1473 `category_id` int(11) NOT NULL auto_increment,
1474 `description` varchar(60) NOT NULL default '',
1475 `dflt_tax_type` int(11) NOT NULL default '1',
1476 `dflt_units` varchar(20) NOT NULL default 'each',
1477 `dflt_mb_flag` char(1) NOT NULL default 'B',
1478 `dflt_sales_act` varchar(11) NOT NULL default '',
1479 `dflt_cogs_act` varchar(11) NOT NULL default '',
1480 `dflt_inventory_act` varchar(11) NOT NULL default '',
1481 `dflt_adjustment_act` varchar(11) NOT NULL default '',
1482 `dflt_assembly_act` varchar(11) NOT NULL default '',
1483 `dflt_dim1` int(11) default NULL,
1484 `dflt_dim2` int(11) default NULL,
1485 `inactive` tinyint(1) NOT NULL default '0',
1486 `dflt_no_sale` tinyint(1) NOT NULL default '0',
1487 PRIMARY KEY (`category_id`),
1488 UNIQUE KEY `description` (`description`)
1489 ) TYPE=MyISAM AUTO_INCREMENT=5 ;
1491 ### Data of table `0_stock_category` ###
1493 INSERT INTO `0_stock_category` VALUES ('1', 'Components', '1', 'each', 'B', '4010', '5010', '1510', '5040', '1530', '0', '0', '0', '0');
1494 INSERT INTO `0_stock_category` VALUES ('2', 'Charges', '1', 'each', 'D', '4010', '5010', '1510', '5040', '1530', '0', '0', '0', '0');
1495 INSERT INTO `0_stock_category` VALUES ('3', 'Systems', '1', 'each', 'M', '4010', '5010', '1510', '5040', '1530', '0', '0', '0', '0');
1496 INSERT INTO `0_stock_category` VALUES ('4', 'Services', '1', 'hrs', 'D', '4010', '5010', '1510', '5040', '1530', '0', '0', '0', '0');
1499 ### Structure of table `0_stock_master` ###
1501 DROP TABLE IF EXISTS `0_stock_master`;
1503 CREATE TABLE `0_stock_master` (
1504 `stock_id` varchar(20) NOT NULL default '',
1505 `category_id` int(11) NOT NULL default '0',
1506 `tax_type_id` int(11) NOT NULL default '0',
1507 `description` varchar(200) NOT NULL default '',
1508 `long_description` tinytext NOT NULL,
1509 `units` varchar(20) NOT NULL default 'each',
1510 `mb_flag` char(1) NOT NULL default 'B',
1511 `sales_account` varchar(11) NOT NULL default '',
1512 `cogs_account` varchar(11) NOT NULL default '',
1513 `inventory_account` varchar(11) NOT NULL default '',
1514 `adjustment_account` varchar(11) NOT NULL default '',
1515 `assembly_account` varchar(11) NOT NULL default '',
1516 `dimension_id` int(11) default NULL,
1517 `dimension2_id` int(11) default NULL,
1518 `actual_cost` double NOT NULL default '0',
1519 `last_cost` double NOT NULL default '0',
1520 `material_cost` double NOT NULL default '0',
1521 `labour_cost` double NOT NULL default '0',
1522 `overhead_cost` double NOT NULL default '0',
1523 `inactive` tinyint(1) NOT NULL default '0',
1524 `no_sale` tinyint(1) NOT NULL default '0',
1525 PRIMARY KEY (`stock_id`)
1529 ### Data of table `0_stock_master` ###
1531 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');
1532 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');
1533 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');
1534 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');
1535 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');
1538 ### Structure of table `0_stock_moves` ###
1540 DROP TABLE IF EXISTS `0_stock_moves`;
1542 CREATE TABLE `0_stock_moves` (
1543 `trans_id` int(11) NOT NULL auto_increment,
1544 `trans_no` int(11) NOT NULL default '0',
1545 `stock_id` char(20) NOT NULL default '',
1546 `type` smallint(6) NOT NULL default '0',
1547 `loc_code` char(5) NOT NULL default '',
1548 `tran_date` date NOT NULL default '0000-00-00',
1549 `person_id` int(11) default NULL,
1550 `price` double NOT NULL default '0',
1551 `reference` char(40) NOT NULL default '',
1552 `qty` double NOT NULL default '1',
1553 `discount_percent` double NOT NULL default '0',
1554 `standard_cost` double NOT NULL default '0',
1555 `visible` tinyint(1) NOT NULL default '1',
1556 PRIMARY KEY (`trans_id`),
1557 KEY `type` (`type`,`trans_no`)
1558 ) TYPE=InnoDB AUTO_INCREMENT=37 ;
1561 ### Data of table `0_stock_moves` ###
1563 INSERT INTO `0_stock_moves` VALUES ('1', '1', '102', '25', 'DEF', '2009-06-21', '2', '10', '', '100', '0', '10', '1');
1564 INSERT INTO `0_stock_moves` VALUES ('2', '1', '103', '25', 'DEF', '2009-06-21', '2', '11', '', '100', '0', '11', '1');
1565 INSERT INTO `0_stock_moves` VALUES ('3', '1', '104', '25', 'DEF', '2009-06-21', '2', '12', '', '100', '0', '12', '1');
1566 INSERT INTO `0_stock_moves` VALUES ('4', '1', '102', '26', 'DEF', '2009-06-21', '0', '0', '1', '-10', '0', '0', '1');
1567 INSERT INTO `0_stock_moves` VALUES ('5', '1', '103', '26', 'DEF', '2009-06-21', '0', '0', '1', '-10', '0', '0', '1');
1568 INSERT INTO `0_stock_moves` VALUES ('6', '1', '104', '26', 'DEF', '2009-06-21', '0', '0', '1', '-10', '0', '0', '1');
1569 INSERT INTO `0_stock_moves` VALUES ('7', '1', '3400', '26', 'DEF', '2009-06-21', '0', '0', '1', '10', '0', '0', '1');
1570 INSERT INTO `0_stock_moves` VALUES ('8', '2', '102', '13', 'DEF', '2009-06-21', '0', '30.4', '1', '-2', '0', '10', '1');
1571 INSERT INTO `0_stock_moves` VALUES ('9', '3', '102', '13', 'DEF', '2009-06-21', '0', '50', 'auto', '-1', '0', '10', '1');
1572 INSERT INTO `0_stock_moves` VALUES ('10', '4', '102', '13', 'DEF', '2009-06-21', '0', '35.89', 'auto', '-1', '0', '10', '1');
1573 INSERT INTO `0_stock_moves` VALUES ('11', '3', '102', '26', 'DEF', '2009-06-21', '0', '0', '3', '-2', '0', '0', '1');
1574 INSERT INTO `0_stock_moves` VALUES ('12', '3', '103', '26', 'DEF', '2009-06-21', '0', '0', '3', '-2', '0', '0', '1');
1575 INSERT INTO `0_stock_moves` VALUES ('13', '3', '104', '26', 'DEF', '2009-06-21', '0', '0', '3', '-2', '0', '0', '1');
1576 INSERT INTO `0_stock_moves` VALUES ('14', '3', '3400', '26', 'DEF', '2009-06-21', '0', '0', '3', '2', '0', '0', '1');
1577 INSERT INTO `0_stock_moves` VALUES ('15', '4', '102', '26', 'DEF', '2009-06-21', '0', '0', '4', '-4', '0', '0', '1');
1578 INSERT INTO `0_stock_moves` VALUES ('16', '4', '103', '26', 'DEF', '2009-06-21', '0', '0', '4', '-4', '0', '0', '1');
1579 INSERT INTO `0_stock_moves` VALUES ('17', '4', '104', '26', 'DEF', '2009-06-21', '0', '0', '4', '-4', '0', '0', '1');
1580 INSERT INTO `0_stock_moves` VALUES ('18', '4', '3400', '26', 'DEF', '2009-06-21', '0', '0', '4', '4', '0', '0', '1');
1581 INSERT INTO `0_stock_moves` VALUES ('19', '2', '102', '26', 'DEF', '2009-06-21', '0', '0', '', '-2', '0', '0', '1');
1582 INSERT INTO `0_stock_moves` VALUES ('20', '2', '103', '26', 'DEF', '2009-06-21', '0', '0', '', '-2', '0', '0', '1');
1583 INSERT INTO `0_stock_moves` VALUES ('21', '2', '104', '26', 'DEF', '2009-06-21', '0', '0', '', '-2', '0', '0', '1');
1584 INSERT INTO `0_stock_moves` VALUES ('22', '1', '3400', '29', 'DEF', '2009-06-21', '0', '0', '', '2', '0', '0', '1');
1585 INSERT INTO `0_stock_moves` VALUES ('23', '5', '102', '26', 'DEF', '2009-06-21', '0', '0', '5', '-5', '0', '0', '1');
1586 INSERT INTO `0_stock_moves` VALUES ('24', '5', '103', '26', 'DEF', '2009-06-21', '0', '0', '5', '-5', '0', '0', '1');
1587 INSERT INTO `0_stock_moves` VALUES ('25', '5', '104', '26', 'DEF', '2009-06-21', '0', '0', '5', '-5', '0', '0', '1');
1588 INSERT INTO `0_stock_moves` VALUES ('26', '5', '3400', '26', 'DEF', '2009-06-21', '0', '0', '5', '5', '0', '0', '1');
1589 INSERT INTO `0_stock_moves` VALUES ('27', '6', '102', '26', 'DEF', '2009-06-21', '0', '0', '6', '5', '0', '0', '1');
1590 INSERT INTO `0_stock_moves` VALUES ('28', '6', '103', '26', 'DEF', '2009-06-21', '0', '0', '6', '5', '0', '0', '1');
1591 INSERT INTO `0_stock_moves` VALUES ('29', '6', '104', '26', 'DEF', '2009-06-21', '0', '0', '6', '5', '0', '0', '1');
1592 INSERT INTO `0_stock_moves` VALUES ('30', '6', '3400', '26', 'DEF', '2009-06-21', '0', '0', '6', '-5', '0', '0', '1');
1593 INSERT INTO `0_stock_moves` VALUES ('31', '7', '102', '26', 'DEF', '2009-06-21', '0', '0', '7', '2', '0', '0', '1');
1594 INSERT INTO `0_stock_moves` VALUES ('32', '7', '103', '26', 'DEF', '2009-06-21', '0', '0', '7', '2', '0', '0', '1');
1595 INSERT INTO `0_stock_moves` VALUES ('33', '7', '104', '26', 'DEF', '2009-06-21', '0', '0', '7', '2', '0', '0', '1');
1596 INSERT INTO `0_stock_moves` VALUES ('34', '7', '3400', '26', 'DEF', '2009-06-21', '0', '0', '7', '-2', '0', '0', '1');
1597 INSERT INTO `0_stock_moves` VALUES ('35', '5', '102', '13', 'DEF', '2009-06-21', '0', '50', 'auto', '-1', '0', '10', '1');
1598 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');
1601 ### Structure of table `0_supp_allocations` ###
1603 DROP TABLE IF EXISTS `0_supp_allocations`;
1605 CREATE TABLE `0_supp_allocations` (
1606 `id` int(11) NOT NULL auto_increment,
1607 `amt` double unsigned default NULL,
1608 `date_alloc` date NOT NULL default '0000-00-00',
1609 `trans_no_from` int(11) default NULL,
1610 `trans_type_from` int(11) default NULL,
1611 `trans_no_to` int(11) default NULL,
1612 `trans_type_to` int(11) default NULL,
1614 ) TYPE=InnoDB AUTO_INCREMENT=2 ;
1617 ### Data of table `0_supp_allocations` ###
1619 INSERT INTO `0_supp_allocations` VALUES ('1', '3465', '2009-06-21', '4', '22', '7', '20');
1622 ### Structure of table `0_supp_invoice_items` ###
1624 DROP TABLE IF EXISTS `0_supp_invoice_items`;
1626 CREATE TABLE `0_supp_invoice_items` (
1627 `id` int(11) NOT NULL auto_increment,
1628 `supp_trans_no` int(11) default NULL,
1629 `supp_trans_type` int(11) default NULL,
1630 `gl_code` varchar(11) NOT NULL default '0',
1631 `grn_item_id` int(11) default NULL,
1632 `po_detail_item_id` int(11) default NULL,
1633 `stock_id` varchar(20) NOT NULL default '',
1634 `description` tinytext,
1635 `quantity` double NOT NULL default '0',
1636 `unit_price` double NOT NULL default '0',
1637 `unit_tax` double NOT NULL default '0',
1640 ) TYPE=InnoDB AUTO_INCREMENT=6 ;
1643 ### Data of table `0_supp_invoice_items` ###
1645 INSERT INTO `0_supp_invoice_items` VALUES ('1', '7', '20', '0', '1', '1', '102', '17inch VGA Monitor', '100', '10', '0.5', '');
1646 INSERT INTO `0_supp_invoice_items` VALUES ('2', '7', '20', '0', '2', '2', '103', '32MB VGA Card', '100', '11', '0.55', '');
1647 INSERT INTO `0_supp_invoice_items` VALUES ('3', '7', '20', '0', '3', '3', '104', '52x CD Drive', '100', '12', '0.6', '');
1648 INSERT INTO `0_supp_invoice_items` VALUES ('4', '8', '20', '2150', '0', '0', '', '', '0', '0.95', '0', 'Phone');
1649 INSERT INTO `0_supp_invoice_items` VALUES ('5', '8', '20', '5780', '0', '0', '', '', '0', '19.05', '0', 'Phone');
1652 ### Structure of table `0_supp_trans` ###
1654 DROP TABLE IF EXISTS `0_supp_trans`;
1656 CREATE TABLE `0_supp_trans` (
1657 `trans_no` int(11) unsigned NOT NULL default '0',
1658 `type` smallint(6) unsigned NOT NULL default '0',
1659 `supplier_id` int(11) unsigned default NULL,
1660 `reference` tinytext NOT NULL,
1661 `supp_reference` varchar(60) NOT NULL default '',
1662 `tran_date` date NOT NULL default '0000-00-00',
1663 `due_date` date NOT NULL default '0000-00-00',
1664 `ov_amount` double NOT NULL default '0',
1665 `ov_discount` double NOT NULL default '0',
1666 `ov_gst` double NOT NULL default '0',
1667 `rate` double NOT NULL default '1',
1668 `alloc` double NOT NULL default '0',
1669 PRIMARY KEY (`trans_no`,`type`),
1670 KEY `supplier_id` (`supplier_id`),
1671 KEY `SupplierID_2` (`supplier_id`,`supp_reference`),
1676 ### Data of table `0_supp_trans` ###
1678 INSERT INTO `0_supp_trans` VALUES ('4', '22', '2', '1', '', '2009-06-21', '2009-06-21', '-3465', '0', '0', '1', '3465');
1679 INSERT INTO `0_supp_trans` VALUES ('7', '20', '2', '1', '5t', '2009-06-21', '2009-07-01', '3300', '0', '165', '1', '3465');
1680 INSERT INTO `0_supp_trans` VALUES ('8', '20', '2', '2', 'cc', '2009-06-21', '2009-07-01', '20', '0', '0', '1', '0');
1683 ### Structure of table `0_suppliers` ###
1685 DROP TABLE IF EXISTS `0_suppliers`;
1687 CREATE TABLE `0_suppliers` (
1688 `supplier_id` int(11) NOT NULL auto_increment,
1689 `supp_name` varchar(60) NOT NULL default '',
1690 `supp_ref` varchar(30) NOT NULL default '',
1691 `address` tinytext NOT NULL,
1692 `supp_address` tinytext NOT NULL,
1693 `phone` varchar(30) NOT NULL default '',
1694 `fax` varchar(30) NOT NULL default '',
1695 `gst_no` varchar(25) NOT NULL default '',
1696 `contact` varchar(60) NOT NULL default '',
1697 `supp_account_no` varchar(40) NOT NULL default '',
1698 `email` varchar(100) NOT NULL default '',
1699 `website` varchar(100) NOT NULL default '',
1700 `bank_account` varchar(60) NOT NULL default '',
1701 `curr_code` char(3) default NULL,
1702 `payment_terms` int(11) default NULL,
1703 `dimension_id` int(11) default '0',
1704 `dimension2_id` int(11) default '0',
1705 `tax_group_id` int(11) default NULL,
1706 `credit_limit` double NOT NULL default '0',
1707 `purchase_account` varchar(11) default NULL,
1708 `payable_account` varchar(11) default NULL,
1709 `payment_discount_account` varchar(11) default NULL,
1710 `notes` tinytext NOT NULL,
1711 `inactive` tinyint(1) NOT NULL default '0',
1712 PRIMARY KEY (`supplier_id`)
1713 ) TYPE=MyISAM AUTO_INCREMENT=4 ;
1716 ### Data of table `0_suppliers` ###
1718 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');
1719 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');
1720 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');
1723 ### Structure of table `0_sys_types` ###
1725 DROP TABLE IF EXISTS `0_sys_types`;
1727 CREATE TABLE `0_sys_types` (
1728 `type_id` smallint(6) NOT NULL default '0',
1729 `type_no` int(11) NOT NULL default '1',
1730 `next_reference` varchar(100) NOT NULL default '',
1731 PRIMARY KEY (`type_id`)
1735 ### Data of table `0_sys_types` ###
1737 INSERT INTO `0_sys_types` VALUES ('0', '19', '3');
1738 INSERT INTO `0_sys_types` VALUES ('1', '8', '2');
1739 INSERT INTO `0_sys_types` VALUES ('2', '5', '2');
1740 INSERT INTO `0_sys_types` VALUES ('4', '3', '1');
1741 INSERT INTO `0_sys_types` VALUES ('10', '19', '4');
1742 INSERT INTO `0_sys_types` VALUES ('11', '3', '2');
1743 INSERT INTO `0_sys_types` VALUES ('12', '6', '1');
1744 INSERT INTO `0_sys_types` VALUES ('13', '5', '2');
1745 INSERT INTO `0_sys_types` VALUES ('16', '2', '1');
1746 INSERT INTO `0_sys_types` VALUES ('17', '2', '1');
1747 INSERT INTO `0_sys_types` VALUES ('18', '1', '3');
1748 INSERT INTO `0_sys_types` VALUES ('20', '8', '3');
1749 INSERT INTO `0_sys_types` VALUES ('21', '1', '1');
1750 INSERT INTO `0_sys_types` VALUES ('22', '4', '2');
1751 INSERT INTO `0_sys_types` VALUES ('25', '1', '2');
1752 INSERT INTO `0_sys_types` VALUES ('26', '1', '8');
1753 INSERT INTO `0_sys_types` VALUES ('28', '1', '1');
1754 INSERT INTO `0_sys_types` VALUES ('29', '1', '2');
1755 INSERT INTO `0_sys_types` VALUES ('30', '5', '6');
1756 INSERT INTO `0_sys_types` VALUES ('32', '0', '1');
1757 INSERT INTO `0_sys_types` VALUES ('35', '1', '1');
1758 INSERT INTO `0_sys_types` VALUES ('40', '1', '3');
1761 ### Structure of table `0_tax_group_items` ###
1763 DROP TABLE IF EXISTS `0_tax_group_items`;
1765 CREATE TABLE `0_tax_group_items` (
1766 `tax_group_id` int(11) NOT NULL default '0',
1767 `tax_type_id` int(11) NOT NULL default '0',
1768 `rate` double NOT NULL default '0',
1769 PRIMARY KEY (`tax_group_id`,`tax_type_id`)
1773 ### Data of table `0_tax_group_items` ###
1775 INSERT INTO `0_tax_group_items` VALUES ('1', '1', '5');
1778 ### Structure of table `0_tax_groups` ###
1780 DROP TABLE IF EXISTS `0_tax_groups`;
1782 CREATE TABLE `0_tax_groups` (
1783 `id` int(11) NOT NULL auto_increment,
1784 `name` varchar(60) NOT NULL default '',
1785 `tax_shipping` tinyint(1) NOT NULL default '0',
1786 `inactive` tinyint(1) NOT NULL default '0',
1788 UNIQUE KEY `name` (`name`)
1789 ) TYPE=InnoDB AUTO_INCREMENT=3 ;
1792 ### Data of table `0_tax_groups` ###
1794 INSERT INTO `0_tax_groups` VALUES ('1', 'Tax', '0', '0');
1795 INSERT INTO `0_tax_groups` VALUES ('2', 'Tax Exempt', '0', '0');
1797 ### Structure of table `0_tax_types` ###
1799 DROP TABLE IF EXISTS `0_tax_types`;
1801 CREATE TABLE `0_tax_types` (
1802 `id` int(11) NOT NULL auto_increment,
1803 `rate` double NOT NULL default '0',
1804 `sales_gl_code` varchar(11) NOT NULL default '',
1805 `purchasing_gl_code` varchar(11) NOT NULL default '',
1806 `name` varchar(60) NOT NULL default '',
1807 `inactive` tinyint(1) NOT NULL default '0',
1809 ) TYPE=InnoDB AUTO_INCREMENT=5 AUTO_INCREMENT=5 ;
1812 ### Data of table `0_tax_types` ###
1814 INSERT INTO `0_tax_types` VALUES ('1', '5', '2150', '2150', 'Tax', '0');
1816 ### Structure of table `0_trans_tax_details` ###
1818 DROP TABLE IF EXISTS `0_trans_tax_details`;
1820 CREATE TABLE `0_trans_tax_details` (
1821 `id` int(11) NOT NULL auto_increment,
1822 `trans_type` smallint(6) default NULL,
1823 `trans_no` int(11) default NULL,
1824 `tran_date` date NOT NULL,
1825 `tax_type_id` int(11) NOT NULL default '0',
1826 `rate` double NOT NULL default '0',
1827 `ex_rate` double NOT NULL default '1',
1828 `included_in_price` tinyint(1) NOT NULL default '0',
1829 `net_amount` double NOT NULL default '0',
1830 `amount` double NOT NULL default '0',
1833 ) TYPE=InnoDB AUTO_INCREMENT=12 ;
1836 ### Data of table `0_trans_tax_details` ###
1838 INSERT INTO `0_trans_tax_details` VALUES ('1', '20', '7', '2009-06-21', '1', '5', '1', '0', '3300', '165', '5t');
1839 INSERT INTO `0_trans_tax_details` VALUES ('2', '13', '3', '2009-06-21', '1', '5', '1', '0', '50', '2.5', 'auto');
1840 INSERT INTO `0_trans_tax_details` VALUES ('3', '10', '17', '2009-06-21', '1', '5', '1', '0', '50', '2.5', '1');
1841 INSERT INTO `0_trans_tax_details` VALUES ('4', '13', '4', '2009-06-21', '1', '5', '1.3932', '0', '35.89', '1.7945', 'auto');
1842 INSERT INTO `0_trans_tax_details` VALUES ('5', '10', '18', '2009-06-21', '1', '5', '1.3932', '0', '35.89', '1.7945', '2');
1843 INSERT INTO `0_trans_tax_details` VALUES ('6', '2', '5', '2009-06-21', '1', '5', '1', '0', '95.2', '4.76', '');
1844 INSERT INTO `0_trans_tax_details` VALUES ('7', '1', '8', '2009-06-21', '1', '5', '1', '0', '-47.6', '-2.38', '');
1845 INSERT INTO `0_trans_tax_details` VALUES ('8', '20', '8', '2009-06-21', '1', '5', '1', '0', '-19', '-0.95', 'cc');
1846 INSERT INTO `0_trans_tax_details` VALUES ('9', '13', '5', '2009-06-21', '1', '5', '1', '1', '47.619047619048', '2.3809523809524', 'auto');
1847 INSERT INTO `0_trans_tax_details` VALUES ('10', '10', '19', '2009-06-21', '1', '5', '1', '1', '47.619047619048', '2.3809523809524', '3');
1848 INSERT INTO `0_trans_tax_details` VALUES ('11', '11', '3', '2009-06-21', '1', '5', '1.3932', '0', '35.89', '1.7945', '1');
1850 ### Structure of table `0_users` ###
1852 DROP TABLE IF EXISTS `0_users`;
1854 CREATE TABLE `0_users` (
1855 `id` SMALLINT(6) AUTO_INCREMENT,
1856 `user_id` varchar(60) NOT NULL default '',
1857 `password` varchar(100) NOT NULL default '',
1858 `real_name` varchar(100) NOT NULL default '',
1859 `role_id` int(11) NOT NULL default '1',
1860 `phone` varchar(30) NOT NULL default '',
1861 `email` varchar(100) default NULL,
1862 `language` varchar(20) default NULL,
1863 `date_format` tinyint(1) NOT NULL default '0',
1864 `date_sep` tinyint(1) NOT NULL default '0',
1865 `tho_sep` tinyint(1) NOT NULL default '0',
1866 `dec_sep` tinyint(1) NOT NULL default '0',
1867 `theme` varchar(20) NOT NULL default 'default',
1868 `page_size` varchar(20) NOT NULL default 'A4',
1869 `prices_dec` smallint(6) NOT NULL default '2',
1870 `qty_dec` smallint(6) NOT NULL default '2',
1871 `rates_dec` smallint(6) NOT NULL default '4',
1872 `percent_dec` smallint(6) NOT NULL default '1',
1873 `show_gl` tinyint(1) NOT NULL default '1',
1874 `show_codes` tinyint(1) NOT NULL default '0',
1875 `show_hints` tinyint(1) NOT NULL default '0',
1876 `last_visit_date` datetime default NULL,
1877 `query_size` tinyint(1) default '10',
1878 `graphic_links` tinyint(1) default '1',
1879 `pos` smallint(6) default '1',
1880 `print_profile` varchar(30) NOT NULL default '1',
1881 `rep_popup` tinyint(1) default '1',
1882 `sticky_doc_date` tinyint(1) default '0',
1883 `startup_tab` varchar(20) NOT NULL default '',
1884 `inactive` tinyint(1) NOT NULL default '0',
1886 UNIQUE KEY (`user_id`)
1887 ) TYPE=MyISAM AUTO_INCREMENT=2;
1890 ### Data of table `0_users` ###
1892 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');
1893 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');
1895 ### Structure of table `0_voided` ###
1897 DROP TABLE IF EXISTS `0_voided`;
1899 CREATE TABLE `0_voided` (
1900 `type` int(11) NOT NULL default '0',
1901 `id` int(11) NOT NULL default '0',
1902 `date_` date NOT NULL default '0000-00-00',
1903 `memo_` tinytext NOT NULL,
1904 UNIQUE KEY `id` (`type`,`id`)
1908 ### Data of table `0_voided` ###
1912 ### Structure of table `0_wo_issue_items` ###
1914 DROP TABLE IF EXISTS `0_wo_issue_items`;
1916 CREATE TABLE `0_wo_issue_items` (
1917 `id` int(11) NOT NULL auto_increment,
1918 `stock_id` varchar(40) default NULL,
1919 `issue_id` int(11) default NULL,
1920 `qty_issued` double default NULL,
1922 ) TYPE=InnoDB AUTO_INCREMENT=1 ;
1925 ### Data of table `0_wo_issue_items` ###
1929 ### Structure of table `0_wo_issues` ###
1931 DROP TABLE IF EXISTS `0_wo_issues`;
1933 CREATE TABLE `0_wo_issues` (
1934 `issue_no` int(11) NOT NULL auto_increment,
1935 `workorder_id` int(11) NOT NULL default '0',
1936 `reference` varchar(100) default NULL,
1937 `issue_date` date default NULL,
1938 `loc_code` varchar(5) default NULL,
1939 `workcentre_id` int(11) default NULL,
1940 PRIMARY KEY (`issue_no`)
1941 ) TYPE=InnoDB AUTO_INCREMENT=1 ;
1944 ### Data of table `0_wo_issues` ###
1948 ### Structure of table `0_wo_manufacture` ###
1950 DROP TABLE IF EXISTS `0_wo_manufacture`;
1952 CREATE TABLE `0_wo_manufacture` (
1953 `id` int(11) NOT NULL auto_increment,
1954 `reference` varchar(100) default NULL,
1955 `workorder_id` int(11) NOT NULL default '0',
1956 `quantity` double NOT NULL default '0',
1957 `date_` date NOT NULL default '0000-00-00',
1959 ) TYPE=InnoDB AUTO_INCREMENT=2 ;
1962 ### Data of table `0_wo_manufacture` ###
1964 INSERT INTO `0_wo_manufacture` VALUES ('1', '1', '2', '2', '2009-06-21');
1967 ### Structure of table `0_wo_requirements` ###
1969 DROP TABLE IF EXISTS `0_wo_requirements`;
1971 CREATE TABLE `0_wo_requirements` (
1972 `id` int(11) NOT NULL auto_increment,
1973 `workorder_id` int(11) NOT NULL default '0',
1974 `stock_id` char(20) NOT NULL default '',
1975 `workcentre` int(11) NOT NULL default '0',
1976 `units_req` double NOT NULL default '1',
1977 `std_cost` double NOT NULL default '0',
1978 `loc_code` char(5) NOT NULL default '',
1979 `units_issued` double NOT NULL default '0',
1981 ) TYPE=InnoDB AUTO_INCREMENT=22 ;
1984 ### Data of table `0_wo_requirements` ###
1986 INSERT INTO `0_wo_requirements` VALUES ('1', '1', '102', '1', '1', '0', 'DEF', '10');
1987 INSERT INTO `0_wo_requirements` VALUES ('2', '1', '103', '1', '1', '0', 'DEF', '10');
1988 INSERT INTO `0_wo_requirements` VALUES ('3', '1', '104', '1', '1', '0', 'DEF', '10');
1989 INSERT INTO `0_wo_requirements` VALUES ('4', '2', '102', '1', '1', '0', 'DEF', '0');
1990 INSERT INTO `0_wo_requirements` VALUES ('5', '2', '103', '1', '1', '0', 'DEF', '0');
1991 INSERT INTO `0_wo_requirements` VALUES ('6', '2', '104', '1', '1', '0', 'DEF', '0');
1992 INSERT INTO `0_wo_requirements` VALUES ('7', '3', '102', '1', '1', '0', 'DEF', '2');
1993 INSERT INTO `0_wo_requirements` VALUES ('8', '3', '103', '1', '1', '0', 'DEF', '2');
1994 INSERT INTO `0_wo_requirements` VALUES ('9', '3', '104', '1', '1', '0', 'DEF', '2');
1995 INSERT INTO `0_wo_requirements` VALUES ('10', '4', '102', '1', '1', '0', 'DEF', '4');
1996 INSERT INTO `0_wo_requirements` VALUES ('11', '4', '103', '1', '1', '0', 'DEF', '4');
1997 INSERT INTO `0_wo_requirements` VALUES ('12', '4', '104', '1', '1', '0', 'DEF', '4');
1998 INSERT INTO `0_wo_requirements` VALUES ('13', '5', '102', '1', '1', '0', 'DEF', '5');
1999 INSERT INTO `0_wo_requirements` VALUES ('14', '5', '103', '1', '1', '0', 'DEF', '5');
2000 INSERT INTO `0_wo_requirements` VALUES ('15', '5', '104', '1', '1', '0', 'DEF', '5');
2001 INSERT INTO `0_wo_requirements` VALUES ('16', '6', '102', '1', '1', '0', 'DEF', '-5');
2002 INSERT INTO `0_wo_requirements` VALUES ('17', '6', '103', '1', '1', '0', 'DEF', '-5');
2003 INSERT INTO `0_wo_requirements` VALUES ('18', '6', '104', '1', '1', '0', 'DEF', '-5');
2004 INSERT INTO `0_wo_requirements` VALUES ('19', '7', '102', '1', '1', '0', 'DEF', '-2');
2005 INSERT INTO `0_wo_requirements` VALUES ('20', '7', '103', '1', '1', '0', 'DEF', '-2');
2006 INSERT INTO `0_wo_requirements` VALUES ('21', '7', '104', '1', '1', '0', 'DEF', '-2');
2009 ### Structure of table `0_workcentres` ###
2011 DROP TABLE IF EXISTS `0_workcentres`;
2013 CREATE TABLE `0_workcentres` (
2014 `id` int(11) NOT NULL auto_increment,
2015 `name` char(40) NOT NULL default '',
2016 `description` char(50) NOT NULL default '',
2017 `inactive` tinyint(1) NOT NULL default '0',
2019 UNIQUE KEY `name` (`name`)
2020 ) TYPE=MyISAM AUTO_INCREMENT=2 ;
2023 ### Data of table `0_workcentres` ###
2025 INSERT INTO `0_workcentres` VALUES ('1', 'Workshop', 'Workshop in Alabama', '0');
2028 ### Structure of table `0_workorders` ###
2030 DROP TABLE IF EXISTS `0_workorders`;
2032 CREATE TABLE `0_workorders` (
2033 `id` int(11) NOT NULL auto_increment,
2034 `wo_ref` varchar(60) NOT NULL default '',
2035 `loc_code` varchar(5) NOT NULL default '',
2036 `units_reqd` double NOT NULL default '1',
2037 `stock_id` varchar(20) NOT NULL default '',
2038 `date_` date NOT NULL default '0000-00-00',
2039 `type` tinyint(4) NOT NULL default '0',
2040 `required_by` date NOT NULL default '0000-00-00',
2041 `released_date` date NOT NULL default '0000-00-00',
2042 `units_issued` double NOT NULL default '0',
2043 `closed` tinyint(1) NOT NULL default '0',
2044 `released` tinyint(1) NOT NULL default '0',
2045 `additional_costs` double NOT NULL default '0',
2047 UNIQUE KEY `wo_ref` (`wo_ref`)
2048 ) TYPE=InnoDB AUTO_INCREMENT=8 ;
2051 ### Data of table `0_workorders` ###
2053 INSERT INTO `0_workorders` VALUES ('1', '1', 'DEF', '10', '3400', '2009-06-21', '0', '2009-06-21', '2009-06-21', '10', '1', '1', '10');
2054 INSERT INTO `0_workorders` VALUES ('2', '2', 'DEF', '3', '3400', '2009-06-21', '2', '2009-07-11', '2009-06-21', '2', '0', '1', '0');
2055 INSERT INTO `0_workorders` VALUES ('3', '3', 'DEF', '2', '3400', '2009-06-21', '0', '2009-06-21', '2009-06-21', '2', '1', '1', '0');
2056 INSERT INTO `0_workorders` VALUES ('4', '4', 'DEF', '4', '3400', '2009-06-21', '0', '2009-06-21', '2009-06-21', '4', '1', '1', '0');
2057 INSERT INTO `0_workorders` VALUES ('5', '5', 'DEF', '5', '3400', '2009-06-21', '0', '2009-06-21', '2009-06-21', '5', '1', '1', '10');
2058 INSERT INTO `0_workorders` VALUES ('6', '6', 'DEF', '-5', '3400', '2009-06-21', '1', '2009-06-21', '2009-06-21', '-5', '1', '1', '0');
2059 INSERT INTO `0_workorders` VALUES ('7', '7', 'DEF', '-2', '3400', '2009-06-21', '1', '2009-06-21', '2009-06-21', '-2', '1', '1', '10');