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 `dflt_curr_act` TINYINT(1) NOT NULL default '0',
84 `id` smallint(6) NOT NULL auto_increment,
85 `last_reconciled_date` timestamp NOT NULL default '0000-00-00 00:00:00',
86 `ending_reconcile_balance` double NOT NULL default '0',
87 `inactive` tinyint(1) NOT NULL default '0',
89 KEY `bank_account_name` (`bank_account_name`),
90 KEY `bank_account_number` (`bank_account_number`)
91 ) TYPE=MyISAM AUTO_INCREMENT=3 ;
94 ### Data of table `0_bank_accounts` ###
96 INSERT INTO `0_bank_accounts` VALUES ('1060', '0', 'Current account', '9999999999', 'Wachovia Bank', '', 'USD', '1', '1', '0000-00-00 00:00:00', '0', '0');
97 INSERT INTO `0_bank_accounts` VALUES ('1065', '3', 'Petty Cash account', 'N/A', 'N/A', '', 'USD', '0', '2', '0000-00-00 00:00:00', '0', '0');
100 ### Structure of table `0_bank_trans` ###
102 DROP TABLE IF EXISTS `0_bank_trans`;
104 CREATE TABLE `0_bank_trans` (
105 `id` int(11) NOT NULL auto_increment,
106 `type` smallint(6) default NULL,
107 `trans_no` int(11) default NULL,
108 `bank_act` varchar(11) default NULL,
109 `ref` varchar(40) default NULL,
110 `trans_date` date NOT NULL default '0000-00-00',
111 `amount` double default NULL,
112 `dimension_id` int(11) NOT NULL default '0',
113 `dimension2_id` int(11) NOT NULL default '0',
114 `person_type_id` int(11) NOT NULL default '0',
115 `person_id` tinyblob,
116 `reconciled` date default NULL,
118 KEY `bank_act` (`bank_act`,`ref`),
119 KEY `type` (`type`,`trans_no`)
120 ) TYPE=InnoDB AUTO_INCREMENT=12 ;
123 ### Data of table `0_bank_trans` ###
125 INSERT INTO `0_bank_trans` VALUES ('1', '22', '4', '1', '1', '2009-06-21', '-3465', '0', '0', '3', '2', '');
126 INSERT INTO `0_bank_trans` VALUES ('2', '26', '1', '1', '', '2009-06-21', '-10', '0', '0', '1', '1', '');
127 INSERT INTO `0_bank_trans` VALUES ('3', '26', '1', '1', '', '2009-06-21', '-20', '0', '0', '1', '0', '');
128 INSERT INTO `0_bank_trans` VALUES ('4', '0', '18', '1', '1', '2009-02-20', '1000', '0', '0', '0', '', '');
129 INSERT INTO `0_bank_trans` VALUES ('5', '0', '19', '1', '2', '2009-02-21', '4000', '0', '0', '0', '', '');
130 INSERT INTO `0_bank_trans` VALUES ('6', '2', '5', '1', '1', '2009-06-21', '100', '0', '0', '4', '3', '');
131 INSERT INTO `0_bank_trans` VALUES ('7', '1', '8', '1', '1', '2009-06-21', '-50', '0', '0', '4', '1', '');
132 INSERT INTO `0_bank_trans` VALUES ('8', '26', '5', '1', '', '2009-06-21', '-10', '0', '0', '1', '1', '');
133 INSERT INTO `0_bank_trans` VALUES ('9', '26', '5', '1', '', '2009-06-21', '-20', '0', '0', '1', '0', '');
134 INSERT INTO `0_bank_trans` VALUES ('10', '26', '7', '1', '', '2009-06-21', '-10', '0', '0', '1', '1', '');
135 INSERT INTO `0_bank_trans` VALUES ('11', '26', '7', '1', '', '2009-06-21', '-20', '0', '0', '1', '0', '');
138 ### Structure of table `0_bom` ###
140 DROP TABLE IF EXISTS `0_bom`;
142 CREATE TABLE `0_bom` (
143 `id` int(11) NOT NULL auto_increment,
144 `parent` char(20) NOT NULL default '',
145 `component` char(20) NOT NULL default '',
146 `workcentre_added` int(11) NOT NULL default '0',
147 `loc_code` char(5) NOT NULL default '',
148 `quantity` double NOT NULL default '1',
149 PRIMARY KEY (`parent`,`component`,`workcentre_added`,`loc_code`),
150 KEY `component` (`component`),
152 KEY `loc_code` (`loc_code`),
153 KEY `parent` (`parent`,`loc_code`),
154 KEY `Parent_2` (`parent`),
155 KEY `workcentre_added` (`workcentre_added`)
156 ) TYPE=MyISAM AUTO_INCREMENT=4 ;
159 ### Data of table `0_bom` ###
161 INSERT INTO `0_bom` VALUES ('1', '3400', '102', '1', 'DEF', '1');
162 INSERT INTO `0_bom` VALUES ('2', '3400', '103', '1', 'DEF', '1');
163 INSERT INTO `0_bom` VALUES ('3', '3400', '104', '1', 'DEF', '1');
166 ### Structure of table `0_budget_trans` ###
168 DROP TABLE IF EXISTS `0_budget_trans`;
170 CREATE TABLE `0_budget_trans` (
171 `counter` int(11) NOT NULL auto_increment,
172 `type` smallint(6) NOT NULL default '0',
173 `type_no` bigint(16) NOT NULL default '1',
174 `tran_date` date NOT NULL default '0000-00-00',
175 `account` varchar(11) NOT NULL default '',
176 `memo_` tinytext NOT NULL,
177 `amount` double NOT NULL default '0',
178 `dimension_id` int(11) default '0',
179 `dimension2_id` int(11) default '0',
180 `person_type_id` int(11) default NULL,
181 `person_id` tinyblob,
182 PRIMARY KEY (`counter`),
183 KEY `Type_and_Number` (`type`,`type_no`)
184 ) TYPE=InnoDB AUTO_INCREMENT=1 ;
187 ### Data of table `0_budget_trans` ###
191 ### Structure of table `0_chart_class` ###
193 DROP TABLE IF EXISTS `0_chart_class`;
195 CREATE TABLE `0_chart_class` (
196 `cid` int(11) NOT NULL default '0',
197 `class_name` varchar(60) NOT NULL default '',
198 `ctype` tinyint(1) NOT NULL default '0',
199 `inactive` tinyint(1) NOT NULL default '0',
204 ### Data of table `0_chart_class` ###
206 INSERT INTO `0_chart_class` VALUES ('1', 'Assets', '1', '0');
207 INSERT INTO `0_chart_class` VALUES ('2', 'Liabilities', '2', '0');
208 INSERT INTO `0_chart_class` VALUES ('3', 'Income', '4', '0');
209 INSERT INTO `0_chart_class` VALUES ('4', 'Costs', '6', '0');
212 ### Structure of table `0_chart_master` ###
214 DROP TABLE IF EXISTS `0_chart_master`;
216 CREATE TABLE `0_chart_master` (
217 `account_code` varchar(11) NOT NULL default '',
218 `account_code2` varchar(11) default '',
219 `account_name` varchar(60) NOT NULL default '',
220 `account_type` int(11) NOT NULL default '0',
221 `inactive` tinyint(1) NOT NULL default '0',
222 PRIMARY KEY (`account_code`),
223 KEY `account_code` (`account_code`),
224 KEY `account_name` (`account_name`)
228 ### Data of table `0_chart_master` ###
230 INSERT INTO `0_chart_master` VALUES ('1060', '', 'Checking Account', '1', '0');
231 INSERT INTO `0_chart_master` VALUES ('1065', '', 'Petty Cash', '1', '0');
232 INSERT INTO `0_chart_master` VALUES ('1200', '', 'Accounts Receivables', '1', '0');
233 INSERT INTO `0_chart_master` VALUES ('1205', '', 'Allowance for doubtful accounts', '1', '0');
234 INSERT INTO `0_chart_master` VALUES ('1510', '', 'Inventory', '2', '0');
235 INSERT INTO `0_chart_master` VALUES ('1520', '', 'Stocks of Raw Materials', '2', '0');
236 INSERT INTO `0_chart_master` VALUES ('1530', '', 'Stocks of Work In Progress', '2', '0');
237 INSERT INTO `0_chart_master` VALUES ('1540', '', 'Stocks of Finsihed Goods', '2', '0');
238 INSERT INTO `0_chart_master` VALUES ('1550', '', 'Goods Received Clearing account', '2', '0');
239 INSERT INTO `0_chart_master` VALUES ('1820', '', 'Office Furniture & Equipment', '3', '0');
240 INSERT INTO `0_chart_master` VALUES ('1825', '', 'Accum. Amort. -Furn. & Equip.', '3', '0');
241 INSERT INTO `0_chart_master` VALUES ('1840', '', 'Vehicle', '3', '0');
242 INSERT INTO `0_chart_master` VALUES ('1845', '', 'Accum. Amort. -Vehicle', '3', '0');
243 INSERT INTO `0_chart_master` VALUES ('2100', '', 'Accounts Payable', '4', '0');
244 INSERT INTO `0_chart_master` VALUES ('2110', '', 'Accrued Income Tax - Federal', '4', '0');
245 INSERT INTO `0_chart_master` VALUES ('2120', '', 'Accrued Income Tax - State', '4', '0');
246 INSERT INTO `0_chart_master` VALUES ('2130', '', 'Accrued Franchise Tax', '4', '0');
247 INSERT INTO `0_chart_master` VALUES ('2140', '', 'Accrued Real & Personal Prop Tax', '4', '0');
248 INSERT INTO `0_chart_master` VALUES ('2150', '', 'Sales Tax', '4', '0');
249 INSERT INTO `0_chart_master` VALUES ('2160', '', 'Accrued Use Tax Payable', '4', '0');
250 INSERT INTO `0_chart_master` VALUES ('2210', '', 'Accrued Wages', '4', '0');
251 INSERT INTO `0_chart_master` VALUES ('2220', '', 'Accrued Comp Time', '4', '0');
252 INSERT INTO `0_chart_master` VALUES ('2230', '', 'Accrued Holiday Pay', '4', '0');
253 INSERT INTO `0_chart_master` VALUES ('2240', '', 'Accrued Vacation Pay', '4', '0');
254 INSERT INTO `0_chart_master` VALUES ('2310', '', 'Accr. Benefits - 401K', '4', '0');
255 INSERT INTO `0_chart_master` VALUES ('2320', '', 'Accr. Benefits - Stock Purchase', '4', '0');
256 INSERT INTO `0_chart_master` VALUES ('2330', '', 'Accr. Benefits - Med, Den', '4', '0');
257 INSERT INTO `0_chart_master` VALUES ('2340', '', 'Accr. Benefits - Payroll Taxes', '4', '0');
258 INSERT INTO `0_chart_master` VALUES ('2350', '', 'Accr. Benefits - Credit Union', '4', '0');
259 INSERT INTO `0_chart_master` VALUES ('2360', '', 'Accr. Benefits - Savings Bond', '4', '0');
260 INSERT INTO `0_chart_master` VALUES ('2370', '', 'Accr. Benefits - Garnish', '4', '0');
261 INSERT INTO `0_chart_master` VALUES ('2380', '', 'Accr. Benefits - Charity Cont.', '4', '0');
262 INSERT INTO `0_chart_master` VALUES ('2620', '', 'Bank Loans', '5', '0');
263 INSERT INTO `0_chart_master` VALUES ('2680', '', 'Loans from Shareholders', '5', '0');
264 INSERT INTO `0_chart_master` VALUES ('3350', '', 'Common Shares', '6', '0');
265 INSERT INTO `0_chart_master` VALUES ('3590', '', 'Retained Earnings - prior years', '7', '0');
266 INSERT INTO `0_chart_master` VALUES ('4010', '', 'Sales', '8', '0');
267 INSERT INTO `0_chart_master` VALUES ('4430', '', 'Shipping & Handling', '9', '0');
268 INSERT INTO `0_chart_master` VALUES ('4440', '', 'Interest', '9', '0');
269 INSERT INTO `0_chart_master` VALUES ('4450', '', 'Foreign Exchange Gain', '9', '0');
270 INSERT INTO `0_chart_master` VALUES ('4500', '', 'Prompt Payment Discounts', '9', '0');
271 INSERT INTO `0_chart_master` VALUES ('4510', '', 'Discounts Given', '9', '0');
272 INSERT INTO `0_chart_master` VALUES ('5010', '', 'Cost of Goods Sold - Retail', '10', '0');
273 INSERT INTO `0_chart_master` VALUES ('5020', '', 'Material Usage Varaiance', '10', '0');
274 INSERT INTO `0_chart_master` VALUES ('5030', '', 'Consumable Materials', '10', '0');
275 INSERT INTO `0_chart_master` VALUES ('5040', '', 'Purchase price Variance', '10', '0');
276 INSERT INTO `0_chart_master` VALUES ('5050', '', 'Purchases of materials', '10', '0');
277 INSERT INTO `0_chart_master` VALUES ('5060', '', 'Discounts Received', '10', '0');
278 INSERT INTO `0_chart_master` VALUES ('5100', '', 'Freight', '10', '0');
279 INSERT INTO `0_chart_master` VALUES ('5410', '', 'Wages & Salaries', '11', '0');
280 INSERT INTO `0_chart_master` VALUES ('5420', '', 'Wages - Overtime', '11', '0');
281 INSERT INTO `0_chart_master` VALUES ('5430', '', 'Benefits - Comp Time', '11', '0');
282 INSERT INTO `0_chart_master` VALUES ('5440', '', 'Benefits - Payroll Taxes', '11', '0');
283 INSERT INTO `0_chart_master` VALUES ('5450', '', 'Benefits - Workers Comp', '11', '0');
284 INSERT INTO `0_chart_master` VALUES ('5460', '', 'Benefits - Pension', '11', '0');
285 INSERT INTO `0_chart_master` VALUES ('5470', '', 'Benefits - General Benefits', '11', '0');
286 INSERT INTO `0_chart_master` VALUES ('5510', '', 'Inc Tax Exp - Federal', '11', '0');
287 INSERT INTO `0_chart_master` VALUES ('5520', '', 'Inc Tax Exp - State', '11', '0');
288 INSERT INTO `0_chart_master` VALUES ('5530', '', 'Taxes - Real Estate', '11', '0');
289 INSERT INTO `0_chart_master` VALUES ('5540', '', 'Taxes - Personal Property', '11', '0');
290 INSERT INTO `0_chart_master` VALUES ('5550', '', 'Taxes - Franchise', '11', '0');
291 INSERT INTO `0_chart_master` VALUES ('5560', '', 'Taxes - Foreign Withholding', '11', '0');
292 INSERT INTO `0_chart_master` VALUES ('5610', '', 'Accounting & Legal', '12', '0');
293 INSERT INTO `0_chart_master` VALUES ('5615', '', 'Advertising & Promotions', '12', '0');
294 INSERT INTO `0_chart_master` VALUES ('5620', '', 'Bad Debts', '12', '0');
295 INSERT INTO `0_chart_master` VALUES ('5660', '', 'Amortization Expense', '12', '0');
296 INSERT INTO `0_chart_master` VALUES ('5685', '', 'Insurance', '12', '0');
297 INSERT INTO `0_chart_master` VALUES ('5690', '', 'Interest & Bank Charges', '12', '0');
298 INSERT INTO `0_chart_master` VALUES ('5700', '', 'Office Supplies', '12', '0');
299 INSERT INTO `0_chart_master` VALUES ('5760', '', 'Rent', '12', '0');
300 INSERT INTO `0_chart_master` VALUES ('5765', '', 'Repair & Maintenance', '12', '0');
301 INSERT INTO `0_chart_master` VALUES ('5780', '', 'Telephone', '12', '0');
302 INSERT INTO `0_chart_master` VALUES ('5785', '', 'Travel & Entertainment', '12', '0');
303 INSERT INTO `0_chart_master` VALUES ('5790', '', 'Utilities', '12', '0');
304 INSERT INTO `0_chart_master` VALUES ('5795', '', 'Registrations', '12', '0');
305 INSERT INTO `0_chart_master` VALUES ('5800', '', 'Licenses', '12', '0');
306 INSERT INTO `0_chart_master` VALUES ('5810', '', 'Foreign Exchange Loss', '12', '0');
307 INSERT INTO `0_chart_master` VALUES ('9990', '', 'Year Profit/Loss', '12', '0');
309 ### Structure of table `0_chart_types` ###
311 DROP TABLE IF EXISTS `0_chart_types`;
313 CREATE TABLE `0_chart_types` (
314 `id` int(11) NOT NULL auto_increment,
315 `name` varchar(60) NOT NULL default '',
316 `class_id` tinyint(1) NOT NULL default '0',
317 `parent` int(11) NOT NULL default '-1',
318 `inactive` tinyint(1) NOT NULL default '0',
321 ) TYPE=MyISAM AUTO_INCREMENT=13 ;
324 ### Data of table `0_chart_types` ###
326 INSERT INTO `0_chart_types` VALUES ('1', 'Current Assets', '1', '-1', '0');
327 INSERT INTO `0_chart_types` VALUES ('2', 'Inventory Assets', '1', '-1', '0');
328 INSERT INTO `0_chart_types` VALUES ('3', 'Capital Assets', '1', '-1', '0');
329 INSERT INTO `0_chart_types` VALUES ('4', 'Current Liabilities', '2', '-1', '0');
330 INSERT INTO `0_chart_types` VALUES ('5', 'Long Term Liabilities', '2', '-1', '0');
331 INSERT INTO `0_chart_types` VALUES ('6', 'Share Capital', '2', '-1', '0');
332 INSERT INTO `0_chart_types` VALUES ('7', 'Retained Earnings', '2', '-1', '0');
333 INSERT INTO `0_chart_types` VALUES ('8', 'Sales Revenue', '3', '-1', '0');
334 INSERT INTO `0_chart_types` VALUES ('9', 'Other Revenue', '3', '-1', '0');
335 INSERT INTO `0_chart_types` VALUES ('10', 'Cost of Goods Sold', '4', '-1', '0');
336 INSERT INTO `0_chart_types` VALUES ('11', 'Payroll Expenses', '4', '-1', '0');
337 INSERT INTO `0_chart_types` VALUES ('12', 'General & Administrative expenses', '4', '-1', '0');
340 ### Structure of table `0_comments` ###
342 DROP TABLE IF EXISTS `0_comments`;
344 CREATE TABLE `0_comments` (
345 `type` int(11) NOT NULL default '0',
346 `id` int(11) NOT NULL default '0',
347 `date_` date default '0000-00-00',
352 ### Data of table `0_comments` ###
356 ### Structure of table `0_company` ###
358 DROP TABLE IF EXISTS `0_company`;
360 CREATE TABLE `0_company` (
361 `coy_code` int(11) NOT NULL default '1',
362 `coy_name` varchar(60) NOT NULL default '',
363 `gst_no` varchar(25) NOT NULL default '',
364 `coy_no` varchar(25) NOT NULL default '0',
365 `tax_prd` int(11) NOT NULL default '1',
366 `tax_last` int(11) NOT NULL default '1',
367 `postal_address` tinytext NOT NULL,
368 `phone` varchar(30) NOT NULL default '',
369 `fax` varchar(30) NOT NULL default '',
370 `email` varchar(100) NOT NULL default '',
371 `coy_logo` varchar(100) NOT NULL default '',
372 `domicile` varchar(55) NOT NULL default '',
373 `curr_default` char(3) NOT NULL default '',
374 `debtors_act` varchar(11) NOT NULL default '',
375 `pyt_discount_act` varchar(11) NOT NULL default '',
376 `creditors_act` varchar(11) NOT NULL default '',
377 `bank_charge_act` varchar(11) NOT NULL default '',
378 `exchange_diff_act` varchar(11) NOT NULL default '',
379 `profit_loss_year_act` varchar(11) NOT NULL default '',
380 `retained_earnings_act` varchar(11) NOT NULL default '',
381 `freight_act` varchar(11) NOT NULL default '',
382 `default_sales_act` varchar(11) NOT NULL default '',
383 `default_sales_discount_act` varchar(11) NOT NULL default '',
384 `default_prompt_payment_act` varchar(11) NOT NULL default '',
385 `default_inventory_act` varchar(11) NOT NULL default '',
386 `default_cogs_act` varchar(11) NOT NULL default '',
387 `default_adj_act` varchar(11) NOT NULL default '',
388 `default_inv_sales_act` varchar(11) NOT NULL default '',
389 `default_assembly_act` varchar(11) NOT NULL default '',
390 `payroll_act` varchar(11) NOT NULL default '',
391 `allow_negative_stock` tinyint(1) NOT NULL default '0',
392 `po_over_receive` int(11) NOT NULL default '10',
393 `po_over_charge` int(11) NOT NULL default '10',
394 `default_credit_limit` int(11) NOT NULL default '1000',
395 `default_workorder_required` int(11) NOT NULL default '20',
396 `default_dim_required` int(11) NOT NULL default '20',
397 `past_due_days` int(11) NOT NULL default '30',
398 `use_dimension` tinyint(1) default '0',
399 `f_year` int(11) NOT NULL default '1',
400 `no_item_list` tinyint(1) NOT NULL default '0',
401 `no_customer_list` tinyint(1) NOT NULL default '0',
402 `no_supplier_list` tinyint(1) NOT NULL default '0',
403 `base_sales` int(11) NOT NULL default '-1',
404 `foreign_codes` tinyint(1) NOT NULL default '0',
405 `accumulate_shipping` tinyint(1) NOT NULL default '0',
406 `legal_text` tinytext NOT NULL,
407 `default_delivery_required` smallint(6) NOT NULL default '1',
408 `version_id` varchar(11) NOT NULL default '',
409 `time_zone` tinyint(1) NOT NULL default '0',
410 `add_pct` int(5) NOT NULL default '-1',
411 `round_to` int(5) NOT NULL default '1',
412 `login_tout` SMALLINT(6) NOT NULL DEFAULT '600',
413 PRIMARY KEY (`coy_code`)
416 ### Data of table `0_company` ###
418 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');
420 ### Structure of table `0_credit_status` ###
422 DROP TABLE IF EXISTS `0_credit_status`;
424 CREATE TABLE `0_credit_status` (
425 `id` int(11) NOT NULL auto_increment,
426 `reason_description` char(100) NOT NULL default '',
427 `dissallow_invoices` tinyint(1) NOT NULL default '0',
428 `inactive` tinyint(1) NOT NULL default '0',
430 UNIQUE KEY `reason_description` (`reason_description`)
431 ) TYPE=MyISAM AUTO_INCREMENT=5 ;
434 ### Data of table `0_credit_status` ###
436 INSERT INTO `0_credit_status` VALUES ('1', 'Good History', '0', '0');
437 INSERT INTO `0_credit_status` VALUES ('3', 'No more work until payment received', '1', '0');
438 INSERT INTO `0_credit_status` VALUES ('4', 'In liquidation', '1', '0');
441 ### Structure of table `0_currencies` ###
443 DROP TABLE IF EXISTS `0_currencies`;
445 CREATE TABLE `0_currencies` (
446 `currency` varchar(60) NOT NULL default '',
447 `curr_abrev` char(3) NOT NULL default '',
448 `curr_symbol` varchar(10) NOT NULL default '',
449 `country` varchar(100) NOT NULL default '',
450 `hundreds_name` varchar(15) NOT NULL default '',
451 `auto_update` tinyint(1) NOT NULL default '1',
452 `inactive` tinyint(1) NOT NULL default '0',
453 PRIMARY KEY (`curr_abrev`)
457 ### Data of table `0_currencies` ###
459 INSERT INTO `0_currencies` VALUES ('US Dollars', 'USD', '$', 'United States', 'Cents', '1', '0');
460 INSERT INTO `0_currencies` VALUES ('CA Dollars', 'CAD', '$', 'Canada', 'Cents', '1', '0');
461 INSERT INTO `0_currencies` VALUES ('Euro', 'EUR', '?', 'Europe', 'Cents', '1', '0');
462 INSERT INTO `0_currencies` VALUES ('Pounds', 'GBP', '?', 'England', 'Pence', '1', '0');
463 INSERT INTO `0_currencies` VALUES ('DK Kroner', 'DKK', '?', 'Denmark', 'Ore', '1', '0');
465 ### Structure of table `0_cust_allocations` ###
467 DROP TABLE IF EXISTS `0_cust_allocations`;
469 CREATE TABLE `0_cust_allocations` (
470 `id` int(11) NOT NULL auto_increment,
471 `amt` double unsigned default NULL,
472 `date_alloc` date NOT NULL default '0000-00-00',
473 `trans_no_from` int(11) default NULL,
474 `trans_type_from` int(11) default NULL,
475 `trans_no_to` int(11) default NULL,
476 `trans_type_to` int(11) default NULL,
478 ) TYPE=InnoDB AUTO_INCREMENT=2 ;
481 ### Data of table `0_cust_allocations` ###
483 INSERT INTO `0_cust_allocations` VALUES ('1', '37.68', '2009-06-21', '3', '11', '18', '10');
486 ### Structure of table `0_cust_branch` ###
488 DROP TABLE IF EXISTS `0_cust_branch`;
490 CREATE TABLE `0_cust_branch` (
491 `branch_code` int(11) NOT NULL auto_increment,
492 `debtor_no` int(11) NOT NULL default '0',
493 `br_name` varchar(60) NOT NULL default '',
494 `branch_ref` varchar(30) NOT NULL default '',
495 `br_address` tinytext NOT NULL,
496 `area` int(11) default NULL,
497 `salesman` int(11) NOT NULL default '0',
498 `phone` varchar(30) NOT NULL default '',
499 `fax` varchar(30) NOT NULL default '',
500 `contact_name` varchar(60) NOT NULL default '',
501 `email` varchar(100) NOT NULL default '',
502 `default_location` varchar(5) NOT NULL default '',
503 `tax_group_id` int(11) default NULL,
504 `sales_account` varchar(11) default NULL,
505 `sales_discount_account` varchar(11) default NULL,
506 `receivables_account` varchar(11) default NULL,
507 `payment_discount_account` varchar(11) default NULL,
508 `default_ship_via` int(11) NOT NULL default '1',
509 `disable_trans` tinyint(4) NOT NULL default '0',
510 `br_post_address` tinytext NOT NULL,
511 `group_no` int(11) NOT NULL default '0',
512 `inactive` tinyint(1) NOT NULL default '0',
513 PRIMARY KEY (`branch_code`,`debtor_no`),
514 KEY `branch_code` (`branch_code`),
515 KEY `br_name` (`br_name`)
516 ) TYPE=MyISAM AUTO_INCREMENT=4 ;
519 ### Data of table `0_cust_branch` ###
521 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');
522 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');
523 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');
526 ### Structure of table `0_debtor_trans` ###
528 DROP TABLE IF EXISTS `0_debtor_trans`;
530 CREATE TABLE `0_debtor_trans` (
531 `trans_no` int(11) unsigned NOT NULL default '0',
532 `type` smallint(6) unsigned NOT NULL default '0',
533 `version` tinyint(1) unsigned NOT NULL default '0',
534 `debtor_no` int(11) unsigned default NULL,
535 `branch_code` int(11) NOT NULL default '-1',
536 `tran_date` date NOT NULL default '0000-00-00',
537 `due_date` date NOT NULL default '0000-00-00',
538 `reference` varchar(60) NOT NULL default '',
539 `tpe` int(11) NOT NULL default '0',
540 `order_` int(11) NOT NULL default '0',
541 `ov_amount` double NOT NULL default '0',
542 `ov_gst` double NOT NULL default '0',
543 `ov_freight` double NOT NULL default '0',
544 `ov_freight_tax` double NOT NULL default '0',
545 `ov_discount` double NOT NULL default '0',
546 `alloc` double NOT NULL default '0',
547 `rate` double NOT NULL default '1',
548 `ship_via` int(11) default NULL,
549 `trans_link` int(11) NOT NULL default '0',
550 `dimension_id` int(11) NOT NULL default '0',
551 `dimension2_id` int(11) NOT NULL default '0',
552 PRIMARY KEY (`trans_no`,`type`),
553 KEY `debtor_no` (`debtor_no`,`branch_code`)
557 ### Data of table `0_debtor_trans` ###
559 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');
560 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');
561 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');
562 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');
563 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');
564 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');
565 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');
566 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');
569 ### Structure of table `0_debtor_trans_details` ###
571 DROP TABLE IF EXISTS `0_debtor_trans_details`;
573 CREATE TABLE `0_debtor_trans_details` (
574 `id` int(11) NOT NULL auto_increment,
575 `debtor_trans_no` int(11) default NULL,
576 `debtor_trans_type` int(11) default NULL,
577 `stock_id` varchar(20) NOT NULL default '',
578 `description` tinytext,
579 `unit_price` double NOT NULL default '0',
580 `unit_tax` double NOT NULL default '0',
581 `quantity` double NOT NULL default '0',
582 `discount_percent` double NOT NULL default '0',
583 `standard_cost` double NOT NULL default '0',
584 `qty_done` double NOT NULL default '0',
586 ) TYPE=InnoDB AUTO_INCREMENT=9 ;
589 ### Data of table `0_debtor_trans_details` ###
591 INSERT INTO `0_debtor_trans_details` VALUES ('1', '2', '13', '102', '17inch VGA Monitor', '30.4', '0', '2', '0', '10', '0');
592 INSERT INTO `0_debtor_trans_details` VALUES ('2', '3', '13', '102', '17inch VGA Monitor', '50', '2.5', '1', '0', '10', '1');
593 INSERT INTO `0_debtor_trans_details` VALUES ('3', '17', '10', '102', '17inch VGA Monitor', '50', '2.5', '1', '0', '10', '0');
594 INSERT INTO `0_debtor_trans_details` VALUES ('4', '4', '13', '102', '17inch VGA Monitor', '35.89', '1.79', '1', '0', '10', '1');
595 INSERT INTO `0_debtor_trans_details` VALUES ('5', '18', '10', '102', '17inch VGA Monitor', '35.89', '1.79', '1', '0', '10', '1');
596 INSERT INTO `0_debtor_trans_details` VALUES ('6', '5', '13', '102', '17inch VGA Monitor', '50', '2.38', '1', '0', '10', '1');
597 INSERT INTO `0_debtor_trans_details` VALUES ('7', '19', '10', '102', '17inch VGA Monitor', '50', '2.38', '1', '0', '10', '0');
598 INSERT INTO `0_debtor_trans_details` VALUES ('8', '3', '11', '102', '17inch VGA Monitor', '35.89', '1.79', '1', '0', '10', '0');
601 ### Structure of table `0_debtors_master` ###
603 DROP TABLE IF EXISTS `0_debtors_master`;
605 CREATE TABLE `0_debtors_master` (
606 `debtor_no` int(11) NOT NULL auto_increment,
607 `name` varchar(80) NOT NULL default '',
608 `debtor_ref` varchar(30) NOT NULL,
610 `email` varchar(100) NOT NULL default '',
611 `tax_id` varchar(55) NOT NULL default '',
612 `curr_code` char(3) NOT NULL default '',
613 `sales_type` int(11) NOT NULL default '1',
614 `dimension_id` int(11) NOT NULL default '0',
615 `dimension2_id` int(11) NOT NULL default '0',
616 `credit_status` int(11) NOT NULL default '0',
617 `payment_terms` int(11) default NULL,
618 `discount` double NOT NULL default '0',
619 `pymt_discount` double NOT NULL default '0',
620 `credit_limit` float NOT NULL default '1000',
621 `inactive` tinyint(1) NOT NULL default '0',
622 PRIMARY KEY (`debtor_no`),
623 UNIQUE KEY `name` (`name`)
624 ) TYPE=MyISAM AUTO_INCREMENT=4 ;
627 ### Data of table `0_debtors_master` ###
629 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');
630 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');
631 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');
634 ### Structure of table `0_dimensions` ###
636 DROP TABLE IF EXISTS `0_dimensions`;
638 CREATE TABLE `0_dimensions` (
639 `id` int(11) NOT NULL auto_increment,
640 `reference` varchar(60) NOT NULL default '',
641 `name` varchar(60) NOT NULL default '',
642 `type_` tinyint(1) NOT NULL default '1',
643 `closed` tinyint(1) NOT NULL default '0',
644 `date_` date NOT NULL default '0000-00-00',
645 `due_date` date NOT NULL default '0000-00-00',
647 UNIQUE KEY `reference` (`reference`)
648 ) TYPE=InnoDB AUTO_INCREMENT=3 ;
651 ### Data of table `0_dimensions` ###
653 INSERT INTO `0_dimensions` VALUES ('1', '1', 'Support', '1', '0', '2009-06-21', '2015-07-11');
654 INSERT INTO `0_dimensions` VALUES ('2', '2', 'Development', '1', '0', '2009-06-21', '2015-07-11');
657 ### Structure of table `0_exchange_rates` ###
659 DROP TABLE IF EXISTS `0_exchange_rates`;
661 CREATE TABLE `0_exchange_rates` (
662 `id` int(11) NOT NULL auto_increment,
663 `curr_code` char(3) NOT NULL default '',
664 `rate_buy` double NOT NULL default '0',
665 `rate_sell` double NOT NULL default '0',
666 `date_` date NOT NULL default '0000-00-00',
668 UNIQUE KEY `curr_code` (`curr_code`,`date_`)
669 ) TYPE=MyISAM AUTO_INCREMENT=4 ;
672 ### Data of table `0_exchange_rates` ###
674 INSERT INTO `0_exchange_rates` VALUES ('1', 'DKK', '0.18717252868313', '0.18717252868313', '2009-06-21');
675 INSERT INTO `0_exchange_rates` VALUES ('2', 'GBP', '1.6445729799917', '1.6445729799917', '2009-06-21');
676 INSERT INTO `0_exchange_rates` VALUES ('3', 'EUR', '1.3932', '1.3932', '2009-06-21');
679 ### Structure of table `0_fiscal_year` ###
681 DROP TABLE IF EXISTS `0_fiscal_year`;
683 CREATE TABLE `0_fiscal_year` (
684 `id` int(11) NOT NULL auto_increment,
685 `begin` date default '0000-00-00',
686 `end` date default '0000-00-00',
687 `closed` tinyint(1) NOT NULL default '0',
689 ) TYPE=InnoDB AUTO_INCREMENT=3 ;
692 ### Data of table `0_fiscal_year` ###
694 INSERT INTO `0_fiscal_year` VALUES ('1', '2008-01-01', '2008-12-31', '0');
695 INSERT INTO `0_fiscal_year` VALUES ('2', '2009-01-01', '2009-12-31', '0');
698 ### Structure of table `0_gl_trans` ###
700 DROP TABLE IF EXISTS `0_gl_trans`;
702 CREATE TABLE `0_gl_trans` (
703 `counter` int(11) NOT NULL auto_increment,
704 `type` smallint(6) NOT NULL default '0',
705 `type_no` bigint(16) NOT NULL default '1',
706 `tran_date` date NOT NULL default '0000-00-00',
707 `account` varchar(11) NOT NULL default '',
708 `memo_` tinytext NOT NULL,
709 `amount` double NOT NULL default '0',
710 `dimension_id` int(11) NOT NULL default '0',
711 `dimension2_id` int(11) NOT NULL default '0',
712 `person_type_id` int(11) default NULL,
713 `person_id` tinyblob,
714 PRIMARY KEY (`counter`),
715 KEY `Type_and_Number` (`type`,`type_no`)
716 ) TYPE=InnoDB AUTO_INCREMENT=84 ;
719 ### Data of table `0_gl_trans` ###
721 INSERT INTO `0_gl_trans` VALUES ('1', '20', '7', '2009-06-21', '2100', '', '-3465', '0', '0', '3', '2');
722 INSERT INTO `0_gl_trans` VALUES ('2', '20', '7', '2009-06-21', '1510', '', '1000', '0', '0', '3', '2');
723 INSERT INTO `0_gl_trans` VALUES ('3', '20', '7', '2009-06-21', '1510', '', '1100', '0', '0', '3', '2');
724 INSERT INTO `0_gl_trans` VALUES ('4', '20', '7', '2009-06-21', '1510', '', '1200', '0', '0', '3', '2');
725 INSERT INTO `0_gl_trans` VALUES ('5', '20', '7', '2009-06-21', '2150', '', '165', '0', '0', '3', '2');
726 INSERT INTO `0_gl_trans` VALUES ('6', '22', '4', '2009-06-21', '2100', '', '3465', '0', '0', '3', '2');
727 INSERT INTO `0_gl_trans` VALUES ('7', '22', '4', '2009-06-21', '1060', '', '-3465', '0', '0', '3', '2');
728 INSERT INTO `0_gl_trans` VALUES ('8', '26', '1', '2009-06-21', '1510', '', '-100', '0', '0', '', '');
729 INSERT INTO `0_gl_trans` VALUES ('9', '26', '1', '2009-06-21', '1510', '', '-110', '0', '0', '', '');
730 INSERT INTO `0_gl_trans` VALUES ('10', '26', '1', '2009-06-21', '1510', '', '-120', '0', '0', '', '');
731 INSERT INTO `0_gl_trans` VALUES ('11', '26', '1', '2009-06-21', '1060', 'Overhead Cost', '-10', '0', '0', '1', '1');
732 INSERT INTO `0_gl_trans` VALUES ('12', '26', '1', '2009-06-21', '1530', 'Overhead Cost', '10', '0', '0', '1', '1');
733 INSERT INTO `0_gl_trans` VALUES ('13', '26', '1', '2009-06-21', '1060', 'Labour Cost', '-20', '0', '0', '1', '0');
734 INSERT INTO `0_gl_trans` VALUES ('14', '26', '1', '2009-06-21', '1530', 'Labour Cost', '20', '0', '0', '1', '0');
735 INSERT INTO `0_gl_trans` VALUES ('15', '26', '1', '2009-06-21', '1510', '', '330', '0', '0', '', '');
736 INSERT INTO `0_gl_trans` VALUES ('16', '13', '2', '2009-06-21', '5010', '', '20', '0', '0', '2', '1');
737 INSERT INTO `0_gl_trans` VALUES ('17', '13', '2', '2009-06-21', '1510', '', '-20', '0', '0', '2', '1');
738 INSERT INTO `0_gl_trans` VALUES ('18', '13', '3', '2009-06-21', '5010', '', '10', '0', '0', '2', '2');
739 INSERT INTO `0_gl_trans` VALUES ('19', '13', '3', '2009-06-21', '1510', '', '-10', '0', '0', '2', '2');
740 INSERT INTO `0_gl_trans` VALUES ('20', '10', '17', '2009-06-21', '4010', '', '-50', '0', '0', '2', '2');
741 INSERT INTO `0_gl_trans` VALUES ('21', '10', '17', '2009-06-21', '1200', '', '52.5', '0', '0', '2', '2');
742 INSERT INTO `0_gl_trans` VALUES ('22', '10', '17', '2009-06-21', '2150', '', '-2.5', '0', '0', '2', '2');
743 INSERT INTO `0_gl_trans` VALUES ('23', '13', '4', '2009-06-21', '5010', '', '10', '2', '0', '2', '3');
744 INSERT INTO `0_gl_trans` VALUES ('24', '13', '4', '2009-06-21', '1510', '', '-10', '0', '0', '2', '3');
745 INSERT INTO `0_gl_trans` VALUES ('25', '10', '18', '2009-06-21', '4010', '', '-50', '2', '0', '2', '3');
746 INSERT INTO `0_gl_trans` VALUES ('26', '10', '18', '2009-06-21', '1200', '', '52.5', '0', '0', '2', '3');
747 INSERT INTO `0_gl_trans` VALUES ('27', '10', '18', '2009-06-21', '2150', '', '-2.5', '0', '0', '2', '3');
748 INSERT INTO `0_gl_trans` VALUES ('28', '0', '18', '2009-02-20', '1060', '', '1000', '0', '0', '', '');
749 INSERT INTO `0_gl_trans` VALUES ('29', '0', '18', '2009-02-20', '3350', '', '-1000', '0', '0', '', '');
750 INSERT INTO `0_gl_trans` VALUES ('30', '0', '19', '2009-02-21', '1060', '', '4000', '0', '0', '', '');
751 INSERT INTO `0_gl_trans` VALUES ('31', '0', '19', '2009-02-21', '3350', '', '-4000', '0', '0', '', '');
752 INSERT INTO `0_gl_trans` VALUES ('32', '26', '3', '2009-06-21', '1510', '', '-20', '0', '0', '', '');
753 INSERT INTO `0_gl_trans` VALUES ('33', '26', '3', '2009-06-21', '1510', '', '-22', '0', '0', '', '');
754 INSERT INTO `0_gl_trans` VALUES ('34', '26', '3', '2009-06-21', '1510', '', '-24', '0', '0', '', '');
755 INSERT INTO `0_gl_trans` VALUES ('35', '26', '3', '2009-06-21', '1540', '', '66', '0', '0', '', '');
756 INSERT INTO `0_gl_trans` VALUES ('36', '2', '5', '2009-06-21', '2150', 'Cash Sales', '-4.76', '0', '0', '4', '3');
757 INSERT INTO `0_gl_trans` VALUES ('37', '2', '5', '2009-06-21', '4010', 'Cash Sales', '-95.24', '0', '0', '4', '3');
758 INSERT INTO `0_gl_trans` VALUES ('38', '2', '5', '2009-06-21', '1060', '', '100', '0', '0', '4', '3');
759 INSERT INTO `0_gl_trans` VALUES ('39', '1', '8', '2009-06-21', '2150', 'Maintenance', '2.38', '0', '0', '4', '1');
760 INSERT INTO `0_gl_trans` VALUES ('40', '1', '8', '2009-06-21', '5765', 'Maintenance', '47.62', '0', '0', '4', '1');
761 INSERT INTO `0_gl_trans` VALUES ('41', '1', '8', '2009-06-21', '1060', '', '-50', '0', '0', '4', '1');
762 INSERT INTO `0_gl_trans` VALUES ('42', '20', '8', '2009-06-21', '2100', '', '-20', '0', '0', '3', '2');
763 INSERT INTO `0_gl_trans` VALUES ('43', '20', '8', '2009-06-21', '2150', '', '0.95', '0', '0', '3', '2');
764 INSERT INTO `0_gl_trans` VALUES ('44', '20', '8', '2009-06-21', '5780', '', '19.05', '0', '0', '3', '2');
765 INSERT INTO `0_gl_trans` VALUES ('45', '26', '4', '2009-06-21', '1510', '', '-40', '0', '0', '', '');
766 INSERT INTO `0_gl_trans` VALUES ('46', '26', '4', '2009-06-21', '1510', '', '-44', '0', '0', '', '');
767 INSERT INTO `0_gl_trans` VALUES ('47', '26', '4', '2009-06-21', '1510', '', '-48', '0', '0', '', '');
768 INSERT INTO `0_gl_trans` VALUES ('48', '26', '4', '2009-06-21', '1540', '', '132', '0', '0', '', '');
769 INSERT INTO `0_gl_trans` VALUES ('49', '26', '2', '2009-06-21', '1510', '', '-20', '0', '0', '', '');
770 INSERT INTO `0_gl_trans` VALUES ('50', '26', '2', '2009-06-21', '1510', '', '-22', '0', '0', '', '');
771 INSERT INTO `0_gl_trans` VALUES ('51', '26', '2', '2009-06-21', '1510', '', '-24', '0', '0', '', '');
772 INSERT INTO `0_gl_trans` VALUES ('52', '26', '2', '2009-06-21', '1540', '', '66', '0', '0', '', '');
773 INSERT INTO `0_gl_trans` VALUES ('53', '26', '5', '2009-06-21', '1510', '', '-50', '0', '0', '', '');
774 INSERT INTO `0_gl_trans` VALUES ('54', '26', '5', '2009-06-21', '1510', '', '-55', '0', '0', '', '');
775 INSERT INTO `0_gl_trans` VALUES ('55', '26', '5', '2009-06-21', '1510', '', '-60', '0', '0', '', '');
776 INSERT INTO `0_gl_trans` VALUES ('56', '26', '5', '2009-06-21', '1060', 'Overhead Cost', '-10', '0', '0', '1', '1');
777 INSERT INTO `0_gl_trans` VALUES ('57', '26', '5', '2009-06-21', '1530', 'Overhead Cost', '10', '0', '0', '1', '1');
778 INSERT INTO `0_gl_trans` VALUES ('58', '26', '5', '2009-06-21', '1060', 'Labour Cost', '-20', '0', '0', '1', '0');
779 INSERT INTO `0_gl_trans` VALUES ('59', '26', '5', '2009-06-21', '1530', 'Labour Cost', '20', '0', '0', '1', '0');
780 INSERT INTO `0_gl_trans` VALUES ('60', '26', '5', '2009-06-21', '1540', '', '165', '0', '0', '', '');
781 INSERT INTO `0_gl_trans` VALUES ('61', '26', '6', '2009-06-21', '1510', '', '50', '0', '0', '', '');
782 INSERT INTO `0_gl_trans` VALUES ('62', '26', '6', '2009-06-21', '1510', '', '55', '0', '0', '', '');
783 INSERT INTO `0_gl_trans` VALUES ('63', '26', '6', '2009-06-21', '1510', '', '60', '0', '0', '', '');
784 INSERT INTO `0_gl_trans` VALUES ('64', '26', '6', '2009-06-21', '1540', '', '-165', '0', '0', '', '');
785 INSERT INTO `0_gl_trans` VALUES ('65', '26', '7', '2009-06-21', '1510', '', '20', '0', '0', '', '');
786 INSERT INTO `0_gl_trans` VALUES ('66', '26', '7', '2009-06-21', '1510', '', '22', '0', '0', '', '');
787 INSERT INTO `0_gl_trans` VALUES ('67', '26', '7', '2009-06-21', '1510', '', '24', '0', '0', '', '');
788 INSERT INTO `0_gl_trans` VALUES ('68', '26', '7', '2009-06-21', '1060', 'Overhead Cost', '-10', '0', '0', '1', '1');
789 INSERT INTO `0_gl_trans` VALUES ('69', '26', '7', '2009-06-21', '1530', 'Overhead Cost', '10', '0', '0', '1', '1');
790 INSERT INTO `0_gl_trans` VALUES ('70', '26', '7', '2009-06-21', '1060', 'Labour Cost', '-20', '0', '0', '1', '0');
791 INSERT INTO `0_gl_trans` VALUES ('71', '26', '7', '2009-06-21', '1530', 'Labour Cost', '20', '0', '0', '1', '0');
792 INSERT INTO `0_gl_trans` VALUES ('72', '26', '7', '2009-06-21', '1540', '', '-66', '0', '0', '', '');
793 INSERT INTO `0_gl_trans` VALUES ('73', '13', '5', '2009-06-21', '5010', '', '10', '0', '0', '2', '2');
794 INSERT INTO `0_gl_trans` VALUES ('74', '13', '5', '2009-06-21', '1510', '', '-10', '0', '0', '2', '2');
795 INSERT INTO `0_gl_trans` VALUES ('75', '10', '19', '2009-06-21', '4010', '', '-47.62', '0', '0', '2', '2');
796 INSERT INTO `0_gl_trans` VALUES ('76', '10', '19', '2009-06-21', '1200', '', '55', '0', '0', '2', '2');
797 INSERT INTO `0_gl_trans` VALUES ('77', '10', '19', '2009-06-21', '4430', '', '-5', '0', '0', '2', '2');
798 INSERT INTO `0_gl_trans` VALUES ('78', '10', '19', '2009-06-21', '2150', '', '-2.38', '0', '0', '2', '2');
799 INSERT INTO `0_gl_trans` VALUES ('79', '11', '3', '2009-06-21', '5010', '', '-10', '2', '0', '2', '3');
800 INSERT INTO `0_gl_trans` VALUES ('80', '11', '3', '2009-06-21', '1510', '', '10', '0', '0', '2', '3');
801 INSERT INTO `0_gl_trans` VALUES ('81', '11', '3', '2009-06-21', '4010', '', '50', '2', '0', '2', '3');
802 INSERT INTO `0_gl_trans` VALUES ('82', '11', '3', '2009-06-21', '1200', '', '-52.5', '0', '0', '2', '3');
803 INSERT INTO `0_gl_trans` VALUES ('83', '11', '3', '2009-06-21', '2150', '', '2.5', '0', '0', '2', '3');
806 ### Structure of table `0_grn_batch` ###
808 DROP TABLE IF EXISTS `0_grn_batch`;
810 CREATE TABLE `0_grn_batch` (
811 `id` int(11) NOT NULL auto_increment,
812 `supplier_id` int(11) NOT NULL default '0',
813 `purch_order_no` int(11) default NULL,
814 `reference` varchar(60) NOT NULL default '',
815 `delivery_date` date NOT NULL default '0000-00-00',
816 `loc_code` varchar(5) default NULL,
818 ) TYPE=InnoDB AUTO_INCREMENT=2 ;
821 ### Data of table `0_grn_batch` ###
823 INSERT INTO `0_grn_batch` VALUES ('1', '2', '1', '1', '2009-06-21', 'DEF');
826 ### Structure of table `0_grn_items` ###
828 DROP TABLE IF EXISTS `0_grn_items`;
830 CREATE TABLE `0_grn_items` (
831 `id` int(11) NOT NULL auto_increment,
832 `grn_batch_id` int(11) default NULL,
833 `po_detail_item` int(11) NOT NULL default '0',
834 `item_code` varchar(20) NOT NULL default '',
835 `description` tinytext,
836 `qty_recd` double NOT NULL default '0',
837 `quantity_inv` double NOT NULL default '0',
839 ) TYPE=InnoDB AUTO_INCREMENT=4 ;
842 ### Data of table `0_grn_items` ###
844 INSERT INTO `0_grn_items` VALUES ('1', '1', '1', '102', '17inch VGA Monitor', '100', '100');
845 INSERT INTO `0_grn_items` VALUES ('2', '1', '2', '103', '32MB VGA Card', '100', '100');
846 INSERT INTO `0_grn_items` VALUES ('3', '1', '3', '104', '52x CD Drive', '100', '100');
849 ### Structure of table `0_groups` ###
851 DROP TABLE IF EXISTS `0_groups`;
853 CREATE TABLE `0_groups` (
854 `id` smallint(6) unsigned NOT NULL auto_increment,
855 `description` varchar(60) NOT NULL default '',
856 `inactive` tinyint(1) NOT NULL default '0',
858 UNIQUE KEY `description` (`description`)
859 ) TYPE=MyISAM AUTO_INCREMENT=4 AUTO_INCREMENT=4 ;
862 ### Data of table `0_groups` ###
864 INSERT INTO `0_groups` VALUES ('1', 'Small', '0');
865 INSERT INTO `0_groups` VALUES ('2', 'Medium', '0');
866 INSERT INTO `0_groups` VALUES ('3', 'Large', '0');
869 ### Structure of table `0_item_codes` ###
871 DROP TABLE IF EXISTS `0_item_codes`;
873 CREATE TABLE `0_item_codes` (
874 `id` int(11) unsigned NOT NULL auto_increment,
875 `item_code` varchar(20) NOT NULL,
876 `stock_id` varchar(20) NOT NULL,
877 `description` varchar(200) NOT NULL default '',
878 `category_id` smallint(6) unsigned NOT NULL,
879 `quantity` double NOT NULL default '1',
880 `is_foreign` tinyint(1) NOT NULL default '0',
881 `inactive` tinyint(1) NOT NULL default '0',
883 UNIQUE KEY `stock_id` (`stock_id`,`item_code`)
884 ) TYPE=MyISAM AUTO_INCREMENT=6 ;
887 ### Data of table `0_item_codes` ###
889 INSERT INTO `0_item_codes` VALUES ('1', '102', '102', '17inch VGA Monitor', '1', '1', '0', '0');
890 INSERT INTO `0_item_codes` VALUES ('2', '103', '103', '32MB VGA Card', '1', '1', '0', '0');
891 INSERT INTO `0_item_codes` VALUES ('3', '104', '104', '52x CD Drive', '1', '1', '0', '0');
892 INSERT INTO `0_item_codes` VALUES ('4', '3400', '3400', 'P4 Business System', '3', '1', '0', '0');
893 INSERT INTO `0_item_codes` VALUES ('5', '201', '201', 'Assembly Labour', '4', '1', '0', '0');
896 ### Structure of table `0_item_tax_type_exemptions` ###
898 DROP TABLE IF EXISTS `0_item_tax_type_exemptions`;
900 CREATE TABLE `0_item_tax_type_exemptions` (
901 `item_tax_type_id` int(11) NOT NULL default '0',
902 `tax_type_id` int(11) NOT NULL default '0',
903 PRIMARY KEY (`item_tax_type_id`,`tax_type_id`)
907 ### Data of table `0_item_tax_type_exemptions` ###
911 ### Structure of table `0_item_tax_types` ###
913 DROP TABLE IF EXISTS `0_item_tax_types`;
915 CREATE TABLE `0_item_tax_types` (
916 `id` int(11) NOT NULL auto_increment,
917 `name` varchar(60) NOT NULL default '',
918 `exempt` tinyint(1) NOT NULL default '0',
919 `inactive` tinyint(1) NOT NULL default '0',
921 UNIQUE KEY `name` (`name`)
922 ) TYPE=InnoDB AUTO_INCREMENT=2 ;
925 ### Data of table `0_item_tax_types` ###
927 INSERT INTO `0_item_tax_types` VALUES ('1', 'Regular', '0', '0');
929 ### Structure of table `0_item_units` ###
931 DROP TABLE IF EXISTS `0_item_units`;
933 CREATE TABLE `0_item_units` (
934 `abbr` varchar(20) NOT NULL,
935 `name` varchar(40) NOT NULL,
936 `decimals` tinyint(2) NOT NULL,
937 `inactive` tinyint(1) NOT NULL default '0',
938 PRIMARY KEY (`abbr`),
939 UNIQUE KEY `name` (`name`)
943 ### Data of table `0_item_units` ###
945 INSERT INTO `0_item_units` VALUES ('ea.', 'Each', '0', '0');
946 INSERT INTO `0_item_units` VALUES ('hrs', 'Hours', '1', '0');
949 ### Structure of table `0_loc_stock` ###
951 DROP TABLE IF EXISTS `0_loc_stock`;
953 CREATE TABLE `0_loc_stock` (
954 `loc_code` char(5) NOT NULL default '',
955 `stock_id` char(20) NOT NULL default '',
956 `reorder_level` bigint(20) NOT NULL default '0',
957 PRIMARY KEY (`loc_code`,`stock_id`),
958 KEY `stock_id` (`stock_id`)
962 ### Data of table `0_loc_stock` ###
964 INSERT INTO `0_loc_stock` VALUES ('DEF', '102', '0');
965 INSERT INTO `0_loc_stock` VALUES ('DEF', '103', '0');
966 INSERT INTO `0_loc_stock` VALUES ('DEF', '104', '0');
967 INSERT INTO `0_loc_stock` VALUES ('DEF', '201', '0');
968 INSERT INTO `0_loc_stock` VALUES ('DEF', '3400', '0');
971 ### Structure of table `0_locations` ###
973 DROP TABLE IF EXISTS `0_locations`;
975 CREATE TABLE `0_locations` (
976 `loc_code` varchar(5) NOT NULL default '',
977 `location_name` varchar(60) NOT NULL default '',
978 `delivery_address` tinytext NOT NULL,
979 `phone` varchar(30) NOT NULL default '',
980 `fax` varchar(30) NOT NULL default '',
981 `email` varchar(100) NOT NULL default '',
982 `contact` varchar(30) NOT NULL default '',
983 `inactive` tinyint(1) NOT NULL default '0',
984 PRIMARY KEY (`loc_code`)
988 ### Data of table `0_locations` ###
990 INSERT INTO `0_locations` VALUES ('DEF', 'Default', 'Delivery 1\r\nDelivery 2\r\nDelivery 3', '', '', '', '', '0');
993 ### Structure of table `0_movement_types` ###
995 DROP TABLE IF EXISTS `0_movement_types`;
997 CREATE TABLE `0_movement_types` (
998 `id` int(11) NOT NULL auto_increment,
999 `name` varchar(60) NOT NULL default '',
1000 `inactive` tinyint(1) NOT NULL default '0',
1002 UNIQUE KEY `name` (`name`)
1003 ) TYPE=MyISAM AUTO_INCREMENT=2 ;
1006 ### Data of table `0_movement_types` ###
1008 INSERT INTO `0_movement_types` VALUES ('1', 'Adjustment', '0');
1011 ### Structure of table `0_payment_terms` ###
1013 DROP TABLE IF EXISTS `0_payment_terms`;
1015 CREATE TABLE `0_payment_terms` (
1016 `terms_indicator` int(11) NOT NULL auto_increment,
1017 `terms` char(80) NOT NULL default '',
1018 `days_before_due` smallint(6) NOT NULL default '0',
1019 `day_in_following_month` smallint(6) NOT NULL default '0',
1020 `inactive` tinyint(1) NOT NULL default '0',
1021 PRIMARY KEY (`terms_indicator`),
1022 UNIQUE KEY `terms` (`terms`)
1023 ) TYPE=MyISAM AUTO_INCREMENT=5 ;
1026 ### Data of table `0_payment_terms` ###
1028 INSERT INTO `0_payment_terms` VALUES ('1', 'Due 15th Of the Following Month', '0', '17', '0');
1029 INSERT INTO `0_payment_terms` VALUES ('2', 'Due By End Of The Following Month', '0', '30', '0');
1030 INSERT INTO `0_payment_terms` VALUES ('3', 'Payment due within 10 days', '10', '0', '0');
1031 INSERT INTO `0_payment_terms` VALUES ('4', 'Cash Only', '1', '0', '0');
1034 ### Structure of table `0_prices` ###
1036 DROP TABLE IF EXISTS `0_prices`;
1038 CREATE TABLE `0_prices` (
1039 `id` int(11) NOT NULL auto_increment,
1040 `stock_id` varchar(20) NOT NULL default '',
1041 `sales_type_id` int(11) NOT NULL default '0',
1042 `curr_abrev` char(3) NOT NULL default '',
1043 `price` double NOT NULL default '0',
1045 UNIQUE KEY `price` (`stock_id`,`sales_type_id`,`curr_abrev`)
1046 ) TYPE=MyISAM AUTO_INCREMENT=5 ;
1049 ### Data of table `0_prices` ###
1051 INSERT INTO `0_prices` VALUES ('1', '3400', '1', 'USD', '100');
1052 INSERT INTO `0_prices` VALUES ('2', '102', '1', 'USD', '50');
1053 INSERT INTO `0_prices` VALUES ('3', '103', '1', 'USD', '55');
1054 INSERT INTO `0_prices` VALUES ('4', '104', '1', 'USD', '60');
1057 ### Structure of table `0_print_profiles` ###
1059 DROP TABLE IF EXISTS `0_print_profiles`;
1061 CREATE TABLE `0_print_profiles` (
1062 `id` smallint(6) unsigned NOT NULL auto_increment,
1063 `profile` varchar(30) NOT NULL,
1064 `report` varchar(5) default NULL,
1065 `printer` tinyint(3) unsigned default NULL,
1067 UNIQUE KEY `profile` (`profile`,`report`)
1068 ) TYPE=MyISAM AUTO_INCREMENT=10 ;
1071 ### Data of table `0_print_profiles` ###
1073 INSERT INTO `0_print_profiles` VALUES ('1', 'Out of office', '', '0');
1074 INSERT INTO `0_print_profiles` VALUES ('2', 'Sales Department', '', '0');
1075 INSERT INTO `0_print_profiles` VALUES ('3', 'Central', '', '2');
1076 INSERT INTO `0_print_profiles` VALUES ('4', 'Sales Department', '104', '2');
1077 INSERT INTO `0_print_profiles` VALUES ('5', 'Sales Department', '105', '2');
1078 INSERT INTO `0_print_profiles` VALUES ('6', 'Sales Department', '107', '2');
1079 INSERT INTO `0_print_profiles` VALUES ('7', 'Sales Department', '109', '2');
1080 INSERT INTO `0_print_profiles` VALUES ('8', 'Sales Department', '110', '2');
1081 INSERT INTO `0_print_profiles` VALUES ('9', 'Sales Department', '201', '2');
1084 ### Structure of table `0_printers` ###
1086 DROP TABLE IF EXISTS `0_printers`;
1088 CREATE TABLE `0_printers` (
1089 `id` tinyint(3) unsigned NOT NULL auto_increment,
1090 `name` varchar(20) NOT NULL,
1091 `description` varchar(60) NOT NULL,
1092 `queue` varchar(20) NOT NULL,
1093 `host` varchar(40) NOT NULL,
1094 `port` smallint(11) unsigned NOT NULL,
1095 `timeout` tinyint(3) unsigned NOT NULL,
1097 UNIQUE KEY `name` (`name`)
1098 ) TYPE=MyISAM AUTO_INCREMENT=4 ;
1101 ### Data of table `0_printers` ###
1103 INSERT INTO `0_printers` VALUES ('1', 'QL500', 'Label printer', 'QL500', 'server', '127', '20');
1104 INSERT INTO `0_printers` VALUES ('2', 'Samsung', 'Main network printer', 'scx4521F', 'server', '515', '5');
1105 INSERT INTO `0_printers` VALUES ('3', 'Local', 'Local print server at user IP', 'lp', '', '515', '10');
1108 ### Structure of table `0_purch_data` ###
1110 DROP TABLE IF EXISTS `0_purch_data`;
1112 CREATE TABLE `0_purch_data` (
1113 `supplier_id` int(11) NOT NULL default '0',
1114 `stock_id` char(20) NOT NULL default '',
1115 `price` double NOT NULL default '0',
1116 `suppliers_uom` char(50) NOT NULL default '',
1117 `conversion_factor` double NOT NULL default '1',
1118 `supplier_description` char(50) NOT NULL default '',
1119 PRIMARY KEY (`supplier_id`,`stock_id`)
1123 ### Data of table `0_purch_data` ###
1125 INSERT INTO `0_purch_data` VALUES ('2', '102', '10', '', '1', '17inch VGA Monitor');
1126 INSERT INTO `0_purch_data` VALUES ('2', '103', '11', '', '1', '32MB VGA Card');
1127 INSERT INTO `0_purch_data` VALUES ('2', '104', '12', '', '1', '52x CD Drive');
1130 ### Structure of table `0_purch_order_details` ###
1132 DROP TABLE IF EXISTS `0_purch_order_details`;
1134 CREATE TABLE `0_purch_order_details` (
1135 `po_detail_item` int(11) NOT NULL auto_increment,
1136 `order_no` int(11) NOT NULL default '0',
1137 `item_code` varchar(20) NOT NULL default '',
1138 `description` tinytext,
1139 `delivery_date` date NOT NULL default '0000-00-00',
1140 `qty_invoiced` double NOT NULL default '0',
1141 `unit_price` double NOT NULL default '0',
1142 `act_price` double NOT NULL default '0',
1143 `std_cost_unit` double NOT NULL default '0',
1144 `quantity_ordered` double NOT NULL default '0',
1145 `quantity_received` double NOT NULL default '0',
1146 PRIMARY KEY (`po_detail_item`)
1147 ) TYPE=InnoDB AUTO_INCREMENT=6 ;
1150 ### Data of table `0_purch_order_details` ###
1152 INSERT INTO `0_purch_order_details` VALUES ('1', '1', '102', '17inch VGA Monitor', '2009-07-01', '100', '10', '10', '10', '100', '100');
1153 INSERT INTO `0_purch_order_details` VALUES ('2', '1', '103', '32MB VGA Card', '2009-07-01', '100', '11', '11', '11', '100', '100');
1154 INSERT INTO `0_purch_order_details` VALUES ('3', '1', '104', '52x CD Drive', '2009-07-01', '100', '12', '12', '12', '100', '100');
1155 INSERT INTO `0_purch_order_details` VALUES ('4', '2', '102', '17inch VGA Monitor', '2009-07-01', '0', '5', '0', '0', '1', '0');
1156 INSERT INTO `0_purch_order_details` VALUES ('5', '2', '103', '32MB VGA Card', '2009-07-01', '0', '5', '0', '0', '1', '0');
1159 ### Structure of table `0_purch_orders` ###
1161 DROP TABLE IF EXISTS `0_purch_orders`;
1163 CREATE TABLE `0_purch_orders` (
1164 `order_no` int(11) NOT NULL auto_increment,
1165 `supplier_id` int(11) NOT NULL default '0',
1166 `comments` tinytext,
1167 `ord_date` date NOT NULL default '0000-00-00',
1168 `reference` tinytext NOT NULL,
1169 `requisition_no` tinytext,
1170 `into_stock_location` varchar(5) NOT NULL default '',
1171 `delivery_address` tinytext NOT NULL,
1172 PRIMARY KEY (`order_no`)
1173 ) TYPE=InnoDB AUTO_INCREMENT=3 ;
1176 ### Data of table `0_purch_orders` ###
1178 INSERT INTO `0_purch_orders` VALUES ('1', '2', '', '2009-06-01', '1', '', 'DEF', 'Delivery 1\r\nDelivery 2\r\nDelivery 3');
1179 INSERT INTO `0_purch_orders` VALUES ('2', '3', '', '2009-06-21', '2', '', 'DEF', 'Delivery 1\r\nDelivery 2\r\nDelivery 3');
1182 ### Structure of table `0_quick_entries` ###
1184 DROP TABLE IF EXISTS `0_quick_entries`;
1186 CREATE TABLE `0_quick_entries` (
1187 `id` smallint(6) unsigned NOT NULL auto_increment,
1188 `type` tinyint(1) NOT NULL default '0',
1189 `description` varchar(60) NOT NULL,
1190 `base_amount` double NOT NULL default '0',
1191 `base_desc` varchar(60) default NULL,
1193 KEY `description` (`description`)
1194 ) TYPE=MyISAM AUTO_INCREMENT=4 ;
1197 ### Data of table `0_quick_entries` ###
1199 INSERT INTO `0_quick_entries` VALUES ('1', '1', 'Maintenance', '0', 'Amount');
1200 INSERT INTO `0_quick_entries` VALUES ('2', '4', 'Phone', '0', 'Amount');
1201 INSERT INTO `0_quick_entries` VALUES ('3', '2', 'Cash Sales', '0', 'Amount');
1204 ### Structure of table `0_quick_entry_lines` ###
1206 DROP TABLE IF EXISTS `0_quick_entry_lines`;
1208 CREATE TABLE `0_quick_entry_lines` (
1209 `id` smallint(6) unsigned NOT NULL auto_increment,
1210 `qid` smallint(6) unsigned NOT NULL,
1211 `amount` double default '0',
1212 `action` varchar(2) NOT NULL,
1213 `dest_id` varchar(11) NOT NULL,
1214 `dimension_id` smallint(6) unsigned default NULL,
1215 `dimension2_id` smallint(6) unsigned default NULL,
1218 ) TYPE=MyISAM AUTO_INCREMENT=8 ;
1221 ### Data of table `0_quick_entry_lines` ###
1223 INSERT INTO `0_quick_entry_lines` VALUES ('1', '1', '0', 't-', '1', '0', '0');
1224 INSERT INTO `0_quick_entry_lines` VALUES ('2', '2', '0', 't-', '1', '0', '0');
1225 INSERT INTO `0_quick_entry_lines` VALUES ('3', '3', '0', 't-', '1', '0', '0');
1226 INSERT INTO `0_quick_entry_lines` VALUES ('4', '3', '0', '=', '4010', '0', '0');
1227 INSERT INTO `0_quick_entry_lines` VALUES ('5', '1', '0', '=', '5765', '0', '0');
1228 INSERT INTO `0_quick_entry_lines` VALUES ('6', '2', '0', '=', '5780', '0', '0');
1231 ### Structure of table `0_recurrent_invoices` ###
1233 DROP TABLE IF EXISTS `0_recurrent_invoices`;
1235 CREATE TABLE `0_recurrent_invoices` (
1236 `id` smallint(6) unsigned NOT NULL auto_increment,
1237 `description` varchar(60) NOT NULL default '',
1238 `order_no` int(11) unsigned NOT NULL,
1239 `debtor_no` int(11) unsigned default NULL,
1240 `group_no` smallint(6) unsigned default NULL,
1241 `days` int(11) NOT NULL default '0',
1242 `monthly` int(11) NOT NULL default '0',
1243 `begin` date NOT NULL default '0000-00-00',
1244 `end` date NOT NULL default '0000-00-00',
1245 `last_sent` date NOT NULL default '0000-00-00',
1247 UNIQUE KEY `description` (`description`)
1248 ) TYPE=InnoDB AUTO_INCREMENT=1 ;
1251 ### Data of table `0_recurrent_invoices` ###
1255 ### Structure of table `0_refs` ###
1257 DROP TABLE IF EXISTS `0_refs`;
1259 CREATE TABLE `0_refs` (
1260 `id` int(11) NOT NULL default '0',
1261 `type` int(11) NOT NULL default '0',
1262 `reference` varchar(100) NOT NULL default '',
1263 PRIMARY KEY (`id`,`type`)
1267 ### Data of table `0_refs` ###
1269 INSERT INTO `0_refs` VALUES ('18', '0', '1');
1270 INSERT INTO `0_refs` VALUES ('19', '0', '2');
1273 ### Structure of table `0_sales_order_details` ###
1275 DROP TABLE IF EXISTS `0_sales_order_details`;
1277 CREATE TABLE `0_sales_order_details` (
1278 `id` int(11) NOT NULL auto_increment,
1279 `order_no` int(11) NOT NULL default '0',
1280 `trans_type` smallint(6) NOT NULL default '30',
1281 `stk_code` varchar(20) NOT NULL default '',
1282 `description` tinytext,
1283 `qty_sent` double NOT NULL default '0',
1284 `unit_price` double NOT NULL default '0',
1285 `quantity` double NOT NULL default '0',
1286 `discount_percent` double NOT NULL default '0',
1288 ) TYPE=InnoDB AUTO_INCREMENT=6 ;
1291 ### Data of table `0_sales_order_details` ###
1293 INSERT INTO `0_sales_order_details` VALUES ('1', '1', '30', '102', '17inch VGA Monitor', '2', '30.4', '2', '0');
1294 INSERT INTO `0_sales_order_details` VALUES ('2', '2', '30', '102', '17inch VGA Monitor', '1', '50', '1', '0');
1295 INSERT INTO `0_sales_order_details` VALUES ('3', '3', '30', '102', '17inch VGA Monitor', '1', '35.89', '1', '0');
1296 INSERT INTO `0_sales_order_details` VALUES ('4', '4', '30', '102', '17inch VGA Monitor', '0', '21.28', '2', '0');
1297 INSERT INTO `0_sales_order_details` VALUES ('5', '5', '30', '102', '17inch VGA Monitor', '1', '50', '1', '0');
1300 ### Structure of table `0_sales_orders` ###
1302 DROP TABLE IF EXISTS `0_sales_orders`;
1304 CREATE TABLE `0_sales_orders` (
1305 `order_no` int(11) NOT NULL auto_increment,
1306 `trans_type` smallint(6) NOT NULL default '30',
1307 `version` tinyint(1) unsigned NOT NULL default '0',
1308 `type` tinyint(1) NOT NULL default '0',
1309 `debtor_no` int(11) NOT NULL default '0',
1310 `branch_code` int(11) NOT NULL default '0',
1311 `reference` varchar(100) NOT NULL default '',
1312 `customer_ref` tinytext NOT NULL,
1313 `comments` tinytext,
1314 `ord_date` date NOT NULL default '0000-00-00',
1315 `order_type` int(11) NOT NULL default '0',
1316 `ship_via` int(11) NOT NULL default '0',
1317 `delivery_address` tinytext NOT NULL,
1318 `contact_phone` varchar(30) default NULL,
1319 `contact_email` varchar(100) default NULL,
1320 `deliver_to` tinytext NOT NULL,
1321 `freight_cost` double NOT NULL default '0',
1322 `from_stk_loc` varchar(5) NOT NULL default '',
1323 `delivery_date` date NOT NULL default '0000-00-00',
1324 PRIMARY KEY (`trans_type`, `order_no`)
1327 ### Data of table `0_sales_orders` ###
1329 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');
1330 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');
1331 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');
1332 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');
1333 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');
1336 ### Structure of table `0_sales_pos` ###
1338 DROP TABLE IF EXISTS `0_sales_pos`;
1340 CREATE TABLE `0_sales_pos` (
1341 `id` smallint(6) unsigned NOT NULL auto_increment,
1342 `pos_name` varchar(30) NOT NULL,
1343 `cash_sale` tinyint(1) NOT NULL,
1344 `credit_sale` tinyint(1) NOT NULL,
1345 `pos_location` varchar(5) NOT NULL,
1346 `pos_account` smallint(6) unsigned NOT NULL,
1347 `inactive` tinyint(1) NOT NULL default '0',
1349 UNIQUE KEY `pos_name` (`pos_name`)
1350 ) TYPE=MyISAM AUTO_INCREMENT=2 ;
1353 ### Data of table `0_sales_pos` ###
1355 INSERT INTO `0_sales_pos` VALUES ('1', 'Default', '1', '1', 'DEF', '2', '0');
1358 ### Structure of table `0_sales_types` ###
1360 DROP TABLE IF EXISTS `0_sales_types`;
1362 CREATE TABLE `0_sales_types` (
1363 `id` int(11) NOT NULL auto_increment,
1364 `sales_type` char(50) NOT NULL default '',
1365 `tax_included` int(1) NOT NULL default '0',
1366 `factor` double NOT NULL default '1',
1367 `inactive` tinyint(1) NOT NULL default '0',
1369 UNIQUE KEY `sales_type` (`sales_type`)
1370 ) TYPE=MyISAM AUTO_INCREMENT=3 ;
1373 ### Data of table `0_sales_types` ###
1375 INSERT INTO `0_sales_types` VALUES ('1', 'Retail', '1', '1', '0');
1376 INSERT INTO `0_sales_types` VALUES ('2', 'Wholesale', '0', '0.7', '0');
1379 ### Structure of table `0_salesman` ###
1381 DROP TABLE IF EXISTS `0_salesman`;
1383 CREATE TABLE `0_salesman` (
1384 `salesman_code` int(11) NOT NULL auto_increment,
1385 `salesman_name` char(60) NOT NULL default '',
1386 `salesman_phone` char(30) NOT NULL default '',
1387 `salesman_fax` char(30) NOT NULL default '',
1388 `salesman_email` varchar(100) NOT NULL default '',
1389 `provision` double NOT NULL default '0',
1390 `break_pt` double NOT NULL default '0',
1391 `provision2` double NOT NULL default '0',
1392 `inactive` tinyint(1) NOT NULL default '0',
1393 PRIMARY KEY (`salesman_code`),
1394 UNIQUE KEY `salesman_name` (`salesman_name`)
1395 ) TYPE=MyISAM AUTO_INCREMENT=2 ;
1398 ### Data of table `0_salesman` ###
1400 INSERT INTO `0_salesman` VALUES ('1', 'Sales Person', '', '', '', '5', '1000', '4', '0');
1402 ### Structure of table `0_security_roles` ###
1404 DROP TABLE IF EXISTS `0_security_roles`;
1405 CREATE TABLE IF NOT EXISTS `0_security_roles` (
1406 `id` int(11) NOT NULL auto_increment,
1407 `role` varchar(30) NOT NULL,
1408 `description` varchar(50) default NULL,
1411 `inactive` tinyint(1) NOT NULL default '0',
1413 UNIQUE KEY `role` (`role`)
1414 ) TYPE=MyISAM AUTO_INCREMENT=11 ;
1417 -- Data of table `0_security_roles`
1420 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);
1421 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);
1422 INSERT INTO `0_security_roles` VALUES(3, 'Salesman', 'Salesman', '768;3072;5632;8192;15872', '773;774;3073;3075;3081;5633;8194;15873', 0);
1423 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);
1424 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);
1425 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);
1426 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);
1427 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);
1428 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);
1429 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);
1431 ### Structure of table `0_shippers` ###
1433 DROP TABLE IF EXISTS `0_shippers`;
1435 CREATE TABLE `0_shippers` (
1436 `shipper_id` int(11) NOT NULL auto_increment,
1437 `shipper_name` varchar(60) NOT NULL default '',
1438 `phone` varchar(30) NOT NULL default '',
1439 `contact` tinytext NOT NULL,
1440 `address` tinytext NOT NULL,
1441 `inactive` tinyint(1) NOT NULL default '0',
1442 PRIMARY KEY (`shipper_id`),
1443 UNIQUE KEY `name` (`shipper_name`)
1444 ) TYPE=MyISAM AUTO_INCREMENT=2 ;
1447 ### Data of table `0_shippers` ###
1449 INSERT INTO `0_shippers` VALUES ('1', 'Default', '', '', '', '0');
1452 ### Structure of table `0_sql_trail` ###
1454 DROP TABLE IF EXISTS `0_sql_trail`;
1456 CREATE TABLE `0_sql_trail` (
1457 `id` int(11) unsigned NOT NULL auto_increment,
1458 `sql` text NOT NULL,
1459 `result` tinyint(1) NOT NULL,
1460 `msg` varchar(255) NOT NULL,
1462 ) TYPE=MyISAM AUTO_INCREMENT=1 ;
1465 ### Data of table `0_sql_trail` ###
1469 ### Structure of table `0_stock_category` ###
1471 DROP TABLE IF EXISTS `0_stock_category`;
1473 CREATE TABLE `0_stock_category` (
1474 `category_id` int(11) NOT NULL auto_increment,
1475 `description` varchar(60) NOT NULL default '',
1476 `dflt_tax_type` int(11) NOT NULL default '1',
1477 `dflt_units` varchar(20) NOT NULL default 'each',
1478 `dflt_mb_flag` char(1) NOT NULL default 'B',
1479 `dflt_sales_act` varchar(11) NOT NULL default '',
1480 `dflt_cogs_act` varchar(11) NOT NULL default '',
1481 `dflt_inventory_act` varchar(11) NOT NULL default '',
1482 `dflt_adjustment_act` varchar(11) NOT NULL default '',
1483 `dflt_assembly_act` varchar(11) NOT NULL default '',
1484 `dflt_dim1` int(11) default NULL,
1485 `dflt_dim2` int(11) default NULL,
1486 `inactive` tinyint(1) NOT NULL default '0',
1487 `dflt_no_sale` tinyint(1) NOT NULL default '0',
1488 PRIMARY KEY (`category_id`),
1489 UNIQUE KEY `description` (`description`)
1490 ) TYPE=MyISAM AUTO_INCREMENT=5 ;
1492 ### Data of table `0_stock_category` ###
1494 INSERT INTO `0_stock_category` VALUES ('1', 'Components', '1', 'each', 'B', '4010', '5010', '1510', '5040', '1530', '0', '0', '0', '0');
1495 INSERT INTO `0_stock_category` VALUES ('2', 'Charges', '1', 'each', 'D', '4010', '5010', '1510', '5040', '1530', '0', '0', '0', '0');
1496 INSERT INTO `0_stock_category` VALUES ('3', 'Systems', '1', 'each', 'M', '4010', '5010', '1510', '5040', '1530', '0', '0', '0', '0');
1497 INSERT INTO `0_stock_category` VALUES ('4', 'Services', '1', 'hrs', 'D', '4010', '5010', '1510', '5040', '1530', '0', '0', '0', '0');
1500 ### Structure of table `0_stock_master` ###
1502 DROP TABLE IF EXISTS `0_stock_master`;
1504 CREATE TABLE `0_stock_master` (
1505 `stock_id` varchar(20) NOT NULL default '',
1506 `category_id` int(11) NOT NULL default '0',
1507 `tax_type_id` int(11) NOT NULL default '0',
1508 `description` varchar(200) NOT NULL default '',
1509 `long_description` tinytext NOT NULL,
1510 `units` varchar(20) NOT NULL default 'each',
1511 `mb_flag` char(1) NOT NULL default 'B',
1512 `sales_account` varchar(11) NOT NULL default '',
1513 `cogs_account` varchar(11) NOT NULL default '',
1514 `inventory_account` varchar(11) NOT NULL default '',
1515 `adjustment_account` varchar(11) NOT NULL default '',
1516 `assembly_account` varchar(11) NOT NULL default '',
1517 `dimension_id` int(11) default NULL,
1518 `dimension2_id` int(11) default NULL,
1519 `actual_cost` double NOT NULL default '0',
1520 `last_cost` double NOT NULL default '0',
1521 `material_cost` double NOT NULL default '0',
1522 `labour_cost` double NOT NULL default '0',
1523 `overhead_cost` double NOT NULL default '0',
1524 `inactive` tinyint(1) NOT NULL default '0',
1525 `no_sale` tinyint(1) NOT NULL default '0',
1526 PRIMARY KEY (`stock_id`)
1530 ### Data of table `0_stock_master` ###
1532 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');
1533 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');
1534 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');
1535 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');
1536 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');
1539 ### Structure of table `0_stock_moves` ###
1541 DROP TABLE IF EXISTS `0_stock_moves`;
1543 CREATE TABLE `0_stock_moves` (
1544 `trans_id` int(11) NOT NULL auto_increment,
1545 `trans_no` int(11) NOT NULL default '0',
1546 `stock_id` char(20) NOT NULL default '',
1547 `type` smallint(6) NOT NULL default '0',
1548 `loc_code` char(5) NOT NULL default '',
1549 `tran_date` date NOT NULL default '0000-00-00',
1550 `person_id` int(11) default NULL,
1551 `price` double NOT NULL default '0',
1552 `reference` char(40) NOT NULL default '',
1553 `qty` double NOT NULL default '1',
1554 `discount_percent` double NOT NULL default '0',
1555 `standard_cost` double NOT NULL default '0',
1556 `visible` tinyint(1) NOT NULL default '1',
1557 PRIMARY KEY (`trans_id`),
1558 KEY `type` (`type`,`trans_no`)
1559 ) TYPE=InnoDB AUTO_INCREMENT=37 ;
1562 ### Data of table `0_stock_moves` ###
1564 INSERT INTO `0_stock_moves` VALUES ('1', '1', '102', '25', 'DEF', '2009-06-21', '2', '10', '', '100', '0', '10', '1');
1565 INSERT INTO `0_stock_moves` VALUES ('2', '1', '103', '25', 'DEF', '2009-06-21', '2', '11', '', '100', '0', '11', '1');
1566 INSERT INTO `0_stock_moves` VALUES ('3', '1', '104', '25', 'DEF', '2009-06-21', '2', '12', '', '100', '0', '12', '1');
1567 INSERT INTO `0_stock_moves` VALUES ('4', '1', '102', '26', 'DEF', '2009-06-21', '0', '0', '1', '-10', '0', '0', '1');
1568 INSERT INTO `0_stock_moves` VALUES ('5', '1', '103', '26', 'DEF', '2009-06-21', '0', '0', '1', '-10', '0', '0', '1');
1569 INSERT INTO `0_stock_moves` VALUES ('6', '1', '104', '26', 'DEF', '2009-06-21', '0', '0', '1', '-10', '0', '0', '1');
1570 INSERT INTO `0_stock_moves` VALUES ('7', '1', '3400', '26', 'DEF', '2009-06-21', '0', '0', '1', '10', '0', '0', '1');
1571 INSERT INTO `0_stock_moves` VALUES ('8', '2', '102', '13', 'DEF', '2009-06-21', '0', '30.4', '1', '-2', '0', '10', '1');
1572 INSERT INTO `0_stock_moves` VALUES ('9', '3', '102', '13', 'DEF', '2009-06-21', '0', '50', 'auto', '-1', '0', '10', '1');
1573 INSERT INTO `0_stock_moves` VALUES ('10', '4', '102', '13', 'DEF', '2009-06-21', '0', '35.89', 'auto', '-1', '0', '10', '1');
1574 INSERT INTO `0_stock_moves` VALUES ('11', '3', '102', '26', 'DEF', '2009-06-21', '0', '0', '3', '-2', '0', '0', '1');
1575 INSERT INTO `0_stock_moves` VALUES ('12', '3', '103', '26', 'DEF', '2009-06-21', '0', '0', '3', '-2', '0', '0', '1');
1576 INSERT INTO `0_stock_moves` VALUES ('13', '3', '104', '26', 'DEF', '2009-06-21', '0', '0', '3', '-2', '0', '0', '1');
1577 INSERT INTO `0_stock_moves` VALUES ('14', '3', '3400', '26', 'DEF', '2009-06-21', '0', '0', '3', '2', '0', '0', '1');
1578 INSERT INTO `0_stock_moves` VALUES ('15', '4', '102', '26', 'DEF', '2009-06-21', '0', '0', '4', '-4', '0', '0', '1');
1579 INSERT INTO `0_stock_moves` VALUES ('16', '4', '103', '26', 'DEF', '2009-06-21', '0', '0', '4', '-4', '0', '0', '1');
1580 INSERT INTO `0_stock_moves` VALUES ('17', '4', '104', '26', 'DEF', '2009-06-21', '0', '0', '4', '-4', '0', '0', '1');
1581 INSERT INTO `0_stock_moves` VALUES ('18', '4', '3400', '26', 'DEF', '2009-06-21', '0', '0', '4', '4', '0', '0', '1');
1582 INSERT INTO `0_stock_moves` VALUES ('19', '2', '102', '26', 'DEF', '2009-06-21', '0', '0', '', '-2', '0', '0', '1');
1583 INSERT INTO `0_stock_moves` VALUES ('20', '2', '103', '26', 'DEF', '2009-06-21', '0', '0', '', '-2', '0', '0', '1');
1584 INSERT INTO `0_stock_moves` VALUES ('21', '2', '104', '26', 'DEF', '2009-06-21', '0', '0', '', '-2', '0', '0', '1');
1585 INSERT INTO `0_stock_moves` VALUES ('22', '1', '3400', '29', 'DEF', '2009-06-21', '0', '0', '', '2', '0', '0', '1');
1586 INSERT INTO `0_stock_moves` VALUES ('23', '5', '102', '26', 'DEF', '2009-06-21', '0', '0', '5', '-5', '0', '0', '1');
1587 INSERT INTO `0_stock_moves` VALUES ('24', '5', '103', '26', 'DEF', '2009-06-21', '0', '0', '5', '-5', '0', '0', '1');
1588 INSERT INTO `0_stock_moves` VALUES ('25', '5', '104', '26', 'DEF', '2009-06-21', '0', '0', '5', '-5', '0', '0', '1');
1589 INSERT INTO `0_stock_moves` VALUES ('26', '5', '3400', '26', 'DEF', '2009-06-21', '0', '0', '5', '5', '0', '0', '1');
1590 INSERT INTO `0_stock_moves` VALUES ('27', '6', '102', '26', 'DEF', '2009-06-21', '0', '0', '6', '5', '0', '0', '1');
1591 INSERT INTO `0_stock_moves` VALUES ('28', '6', '103', '26', 'DEF', '2009-06-21', '0', '0', '6', '5', '0', '0', '1');
1592 INSERT INTO `0_stock_moves` VALUES ('29', '6', '104', '26', 'DEF', '2009-06-21', '0', '0', '6', '5', '0', '0', '1');
1593 INSERT INTO `0_stock_moves` VALUES ('30', '6', '3400', '26', 'DEF', '2009-06-21', '0', '0', '6', '-5', '0', '0', '1');
1594 INSERT INTO `0_stock_moves` VALUES ('31', '7', '102', '26', 'DEF', '2009-06-21', '0', '0', '7', '2', '0', '0', '1');
1595 INSERT INTO `0_stock_moves` VALUES ('32', '7', '103', '26', 'DEF', '2009-06-21', '0', '0', '7', '2', '0', '0', '1');
1596 INSERT INTO `0_stock_moves` VALUES ('33', '7', '104', '26', 'DEF', '2009-06-21', '0', '0', '7', '2', '0', '0', '1');
1597 INSERT INTO `0_stock_moves` VALUES ('34', '7', '3400', '26', 'DEF', '2009-06-21', '0', '0', '7', '-2', '0', '0', '1');
1598 INSERT INTO `0_stock_moves` VALUES ('35', '5', '102', '13', 'DEF', '2009-06-21', '0', '50', 'auto', '-1', '0', '10', '1');
1599 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');
1602 ### Structure of table `0_supp_allocations` ###
1604 DROP TABLE IF EXISTS `0_supp_allocations`;
1606 CREATE TABLE `0_supp_allocations` (
1607 `id` int(11) NOT NULL auto_increment,
1608 `amt` double unsigned default NULL,
1609 `date_alloc` date NOT NULL default '0000-00-00',
1610 `trans_no_from` int(11) default NULL,
1611 `trans_type_from` int(11) default NULL,
1612 `trans_no_to` int(11) default NULL,
1613 `trans_type_to` int(11) default NULL,
1615 ) TYPE=InnoDB AUTO_INCREMENT=2 ;
1618 ### Data of table `0_supp_allocations` ###
1620 INSERT INTO `0_supp_allocations` VALUES ('1', '3465', '2009-06-21', '4', '22', '7', '20');
1623 ### Structure of table `0_supp_invoice_items` ###
1625 DROP TABLE IF EXISTS `0_supp_invoice_items`;
1627 CREATE TABLE `0_supp_invoice_items` (
1628 `id` int(11) NOT NULL auto_increment,
1629 `supp_trans_no` int(11) default NULL,
1630 `supp_trans_type` int(11) default NULL,
1631 `gl_code` varchar(11) NOT NULL default '0',
1632 `grn_item_id` int(11) default NULL,
1633 `po_detail_item_id` int(11) default NULL,
1634 `stock_id` varchar(20) NOT NULL default '',
1635 `description` tinytext,
1636 `quantity` double NOT NULL default '0',
1637 `unit_price` double NOT NULL default '0',
1638 `unit_tax` double NOT NULL default '0',
1641 ) TYPE=InnoDB AUTO_INCREMENT=6 ;
1644 ### Data of table `0_supp_invoice_items` ###
1646 INSERT INTO `0_supp_invoice_items` VALUES ('1', '7', '20', '0', '1', '1', '102', '17inch VGA Monitor', '100', '10', '0.5', '');
1647 INSERT INTO `0_supp_invoice_items` VALUES ('2', '7', '20', '0', '2', '2', '103', '32MB VGA Card', '100', '11', '0.55', '');
1648 INSERT INTO `0_supp_invoice_items` VALUES ('3', '7', '20', '0', '3', '3', '104', '52x CD Drive', '100', '12', '0.6', '');
1649 INSERT INTO `0_supp_invoice_items` VALUES ('4', '8', '20', '2150', '0', '0', '', '', '0', '0.95', '0', 'Phone');
1650 INSERT INTO `0_supp_invoice_items` VALUES ('5', '8', '20', '5780', '0', '0', '', '', '0', '19.05', '0', 'Phone');
1653 ### Structure of table `0_supp_trans` ###
1655 DROP TABLE IF EXISTS `0_supp_trans`;
1657 CREATE TABLE `0_supp_trans` (
1658 `trans_no` int(11) unsigned NOT NULL default '0',
1659 `type` smallint(6) unsigned NOT NULL default '0',
1660 `supplier_id` int(11) unsigned default NULL,
1661 `reference` tinytext NOT NULL,
1662 `supp_reference` varchar(60) NOT NULL default '',
1663 `tran_date` date NOT NULL default '0000-00-00',
1664 `due_date` date NOT NULL default '0000-00-00',
1665 `ov_amount` double NOT NULL default '0',
1666 `ov_discount` double NOT NULL default '0',
1667 `ov_gst` double NOT NULL default '0',
1668 `rate` double NOT NULL default '1',
1669 `alloc` double NOT NULL default '0',
1670 PRIMARY KEY (`trans_no`,`type`),
1671 KEY `supplier_id` (`supplier_id`),
1672 KEY `SupplierID_2` (`supplier_id`,`supp_reference`),
1677 ### Data of table `0_supp_trans` ###
1679 INSERT INTO `0_supp_trans` VALUES ('4', '22', '2', '1', '', '2009-06-21', '2009-06-21', '-3465', '0', '0', '1', '3465');
1680 INSERT INTO `0_supp_trans` VALUES ('7', '20', '2', '1', '5t', '2009-06-21', '2009-07-01', '3300', '0', '165', '1', '3465');
1681 INSERT INTO `0_supp_trans` VALUES ('8', '20', '2', '2', 'cc', '2009-06-21', '2009-07-01', '20', '0', '0', '1', '0');
1684 ### Structure of table `0_suppliers` ###
1686 DROP TABLE IF EXISTS `0_suppliers`;
1688 CREATE TABLE `0_suppliers` (
1689 `supplier_id` int(11) NOT NULL auto_increment,
1690 `supp_name` varchar(60) NOT NULL default '',
1691 `supp_ref` varchar(30) NOT NULL default '',
1692 `address` tinytext NOT NULL,
1693 `supp_address` tinytext NOT NULL,
1694 `phone` varchar(30) NOT NULL default '',
1695 `fax` varchar(30) NOT NULL default '',
1696 `gst_no` varchar(25) NOT NULL default '',
1697 `contact` varchar(60) NOT NULL default '',
1698 `supp_account_no` varchar(40) NOT NULL default '',
1699 `email` varchar(100) NOT NULL default '',
1700 `website` varchar(100) NOT NULL default '',
1701 `bank_account` varchar(60) NOT NULL default '',
1702 `curr_code` char(3) default NULL,
1703 `payment_terms` int(11) default NULL,
1704 `dimension_id` int(11) default '0',
1705 `dimension2_id` int(11) default '0',
1706 `tax_group_id` int(11) default NULL,
1707 `credit_limit` double NOT NULL default '0',
1708 `purchase_account` varchar(11) default NULL,
1709 `payable_account` varchar(11) default NULL,
1710 `payment_discount_account` varchar(11) default NULL,
1711 `notes` tinytext NOT NULL,
1712 `inactive` tinyint(1) NOT NULL default '0',
1713 PRIMARY KEY (`supplier_id`)
1714 ) TYPE=MyISAM AUTO_INCREMENT=4 ;
1717 ### Data of table `0_suppliers` ###
1719 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');
1720 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');
1721 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');
1724 ### Structure of table `0_sys_types` ###
1726 DROP TABLE IF EXISTS `0_sys_types`;
1728 CREATE TABLE `0_sys_types` (
1729 `type_id` smallint(6) NOT NULL default '0',
1730 `type_no` int(11) NOT NULL default '1',
1731 `next_reference` varchar(100) NOT NULL default '',
1732 PRIMARY KEY (`type_id`)
1736 ### Data of table `0_sys_types` ###
1738 INSERT INTO `0_sys_types` VALUES ('0', '19', '3');
1739 INSERT INTO `0_sys_types` VALUES ('1', '8', '2');
1740 INSERT INTO `0_sys_types` VALUES ('2', '5', '2');
1741 INSERT INTO `0_sys_types` VALUES ('4', '3', '1');
1742 INSERT INTO `0_sys_types` VALUES ('10', '19', '4');
1743 INSERT INTO `0_sys_types` VALUES ('11', '3', '2');
1744 INSERT INTO `0_sys_types` VALUES ('12', '6', '1');
1745 INSERT INTO `0_sys_types` VALUES ('13', '5', '2');
1746 INSERT INTO `0_sys_types` VALUES ('16', '2', '1');
1747 INSERT INTO `0_sys_types` VALUES ('17', '2', '1');
1748 INSERT INTO `0_sys_types` VALUES ('18', '1', '3');
1749 INSERT INTO `0_sys_types` VALUES ('20', '8', '3');
1750 INSERT INTO `0_sys_types` VALUES ('21', '1', '1');
1751 INSERT INTO `0_sys_types` VALUES ('22', '4', '2');
1752 INSERT INTO `0_sys_types` VALUES ('25', '1', '2');
1753 INSERT INTO `0_sys_types` VALUES ('26', '1', '8');
1754 INSERT INTO `0_sys_types` VALUES ('28', '1', '1');
1755 INSERT INTO `0_sys_types` VALUES ('29', '1', '2');
1756 INSERT INTO `0_sys_types` VALUES ('30', '5', '6');
1757 INSERT INTO `0_sys_types` VALUES ('32', '0', '1');
1758 INSERT INTO `0_sys_types` VALUES ('35', '1', '1');
1759 INSERT INTO `0_sys_types` VALUES ('40', '1', '3');
1762 ### Structure of table `0_tax_group_items` ###
1764 DROP TABLE IF EXISTS `0_tax_group_items`;
1766 CREATE TABLE `0_tax_group_items` (
1767 `tax_group_id` int(11) NOT NULL default '0',
1768 `tax_type_id` int(11) NOT NULL default '0',
1769 `rate` double NOT NULL default '0',
1770 PRIMARY KEY (`tax_group_id`,`tax_type_id`)
1774 ### Data of table `0_tax_group_items` ###
1776 INSERT INTO `0_tax_group_items` VALUES ('1', '1', '5');
1779 ### Structure of table `0_tax_groups` ###
1781 DROP TABLE IF EXISTS `0_tax_groups`;
1783 CREATE TABLE `0_tax_groups` (
1784 `id` int(11) NOT NULL auto_increment,
1785 `name` varchar(60) NOT NULL default '',
1786 `tax_shipping` tinyint(1) NOT NULL default '0',
1787 `inactive` tinyint(1) NOT NULL default '0',
1789 UNIQUE KEY `name` (`name`)
1790 ) TYPE=InnoDB AUTO_INCREMENT=3 ;
1793 ### Data of table `0_tax_groups` ###
1795 INSERT INTO `0_tax_groups` VALUES ('1', 'Tax', '0', '0');
1796 INSERT INTO `0_tax_groups` VALUES ('2', 'Tax Exempt', '0', '0');
1798 ### Structure of table `0_tax_types` ###
1800 DROP TABLE IF EXISTS `0_tax_types`;
1802 CREATE TABLE `0_tax_types` (
1803 `id` int(11) NOT NULL auto_increment,
1804 `rate` double NOT NULL default '0',
1805 `sales_gl_code` varchar(11) NOT NULL default '',
1806 `purchasing_gl_code` varchar(11) NOT NULL default '',
1807 `name` varchar(60) NOT NULL default '',
1808 `inactive` tinyint(1) NOT NULL default '0',
1810 ) TYPE=InnoDB AUTO_INCREMENT=5 AUTO_INCREMENT=5 ;
1813 ### Data of table `0_tax_types` ###
1815 INSERT INTO `0_tax_types` VALUES ('1', '5', '2150', '2150', 'Tax', '0');
1817 ### Structure of table `0_trans_tax_details` ###
1819 DROP TABLE IF EXISTS `0_trans_tax_details`;
1821 CREATE TABLE `0_trans_tax_details` (
1822 `id` int(11) NOT NULL auto_increment,
1823 `trans_type` smallint(6) default NULL,
1824 `trans_no` int(11) default NULL,
1825 `tran_date` date NOT NULL,
1826 `tax_type_id` int(11) NOT NULL default '0',
1827 `rate` double NOT NULL default '0',
1828 `ex_rate` double NOT NULL default '1',
1829 `included_in_price` tinyint(1) NOT NULL default '0',
1830 `net_amount` double NOT NULL default '0',
1831 `amount` double NOT NULL default '0',
1834 ) TYPE=InnoDB AUTO_INCREMENT=12 ;
1837 ### Data of table `0_trans_tax_details` ###
1839 INSERT INTO `0_trans_tax_details` VALUES ('1', '20', '7', '2009-06-21', '1', '5', '1', '0', '3300', '165', '5t');
1840 INSERT INTO `0_trans_tax_details` VALUES ('2', '13', '3', '2009-06-21', '1', '5', '1', '0', '50', '2.5', 'auto');
1841 INSERT INTO `0_trans_tax_details` VALUES ('3', '10', '17', '2009-06-21', '1', '5', '1', '0', '50', '2.5', '1');
1842 INSERT INTO `0_trans_tax_details` VALUES ('4', '13', '4', '2009-06-21', '1', '5', '1.3932', '0', '35.89', '1.7945', 'auto');
1843 INSERT INTO `0_trans_tax_details` VALUES ('5', '10', '18', '2009-06-21', '1', '5', '1.3932', '0', '35.89', '1.7945', '2');
1844 INSERT INTO `0_trans_tax_details` VALUES ('6', '2', '5', '2009-06-21', '1', '5', '1', '0', '95.2', '4.76', '');
1845 INSERT INTO `0_trans_tax_details` VALUES ('7', '1', '8', '2009-06-21', '1', '5', '1', '0', '-47.6', '-2.38', '');
1846 INSERT INTO `0_trans_tax_details` VALUES ('8', '20', '8', '2009-06-21', '1', '5', '1', '0', '-19', '-0.95', 'cc');
1847 INSERT INTO `0_trans_tax_details` VALUES ('9', '13', '5', '2009-06-21', '1', '5', '1', '1', '47.619047619048', '2.3809523809524', 'auto');
1848 INSERT INTO `0_trans_tax_details` VALUES ('10', '10', '19', '2009-06-21', '1', '5', '1', '1', '47.619047619048', '2.3809523809524', '3');
1849 INSERT INTO `0_trans_tax_details` VALUES ('11', '11', '3', '2009-06-21', '1', '5', '1.3932', '0', '35.89', '1.7945', '1');
1851 ### Structure of table `0_users` ###
1853 DROP TABLE IF EXISTS `0_users`;
1855 CREATE TABLE `0_users` (
1856 `id` SMALLINT(6) AUTO_INCREMENT,
1857 `user_id` varchar(60) NOT NULL default '',
1858 `password` varchar(100) NOT NULL default '',
1859 `real_name` varchar(100) NOT NULL default '',
1860 `role_id` int(11) NOT NULL default '1',
1861 `phone` varchar(30) NOT NULL default '',
1862 `email` varchar(100) default NULL,
1863 `language` varchar(20) default NULL,
1864 `date_format` tinyint(1) NOT NULL default '0',
1865 `date_sep` tinyint(1) NOT NULL default '0',
1866 `tho_sep` tinyint(1) NOT NULL default '0',
1867 `dec_sep` tinyint(1) NOT NULL default '0',
1868 `theme` varchar(20) NOT NULL default 'default',
1869 `page_size` varchar(20) NOT NULL default 'A4',
1870 `prices_dec` smallint(6) NOT NULL default '2',
1871 `qty_dec` smallint(6) NOT NULL default '2',
1872 `rates_dec` smallint(6) NOT NULL default '4',
1873 `percent_dec` smallint(6) NOT NULL default '1',
1874 `show_gl` tinyint(1) NOT NULL default '1',
1875 `show_codes` tinyint(1) NOT NULL default '0',
1876 `show_hints` tinyint(1) NOT NULL default '0',
1877 `last_visit_date` datetime default NULL,
1878 `query_size` tinyint(1) default '10',
1879 `graphic_links` tinyint(1) default '1',
1880 `pos` smallint(6) default '1',
1881 `print_profile` varchar(30) NOT NULL default '1',
1882 `rep_popup` tinyint(1) default '1',
1883 `sticky_doc_date` tinyint(1) default '0',
1884 `startup_tab` varchar(20) NOT NULL default '',
1885 `inactive` tinyint(1) NOT NULL default '0',
1887 UNIQUE KEY (`user_id`)
1888 ) TYPE=MyISAM AUTO_INCREMENT=2;
1891 ### Data of table `0_users` ###
1893 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');
1894 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');
1896 ### Structure of table `0_voided` ###
1898 DROP TABLE IF EXISTS `0_voided`;
1900 CREATE TABLE `0_voided` (
1901 `type` int(11) NOT NULL default '0',
1902 `id` int(11) NOT NULL default '0',
1903 `date_` date NOT NULL default '0000-00-00',
1904 `memo_` tinytext NOT NULL,
1905 UNIQUE KEY `id` (`type`,`id`)
1909 ### Data of table `0_voided` ###
1913 ### Structure of table `0_wo_issue_items` ###
1915 DROP TABLE IF EXISTS `0_wo_issue_items`;
1917 CREATE TABLE `0_wo_issue_items` (
1918 `id` int(11) NOT NULL auto_increment,
1919 `stock_id` varchar(40) default NULL,
1920 `issue_id` int(11) default NULL,
1921 `qty_issued` double default NULL,
1923 ) TYPE=InnoDB AUTO_INCREMENT=1 ;
1926 ### Data of table `0_wo_issue_items` ###
1930 ### Structure of table `0_wo_issues` ###
1932 DROP TABLE IF EXISTS `0_wo_issues`;
1934 CREATE TABLE `0_wo_issues` (
1935 `issue_no` int(11) NOT NULL auto_increment,
1936 `workorder_id` int(11) NOT NULL default '0',
1937 `reference` varchar(100) default NULL,
1938 `issue_date` date default NULL,
1939 `loc_code` varchar(5) default NULL,
1940 `workcentre_id` int(11) default NULL,
1941 PRIMARY KEY (`issue_no`)
1942 ) TYPE=InnoDB AUTO_INCREMENT=1 ;
1945 ### Data of table `0_wo_issues` ###
1949 ### Structure of table `0_wo_manufacture` ###
1951 DROP TABLE IF EXISTS `0_wo_manufacture`;
1953 CREATE TABLE `0_wo_manufacture` (
1954 `id` int(11) NOT NULL auto_increment,
1955 `reference` varchar(100) default NULL,
1956 `workorder_id` int(11) NOT NULL default '0',
1957 `quantity` double NOT NULL default '0',
1958 `date_` date NOT NULL default '0000-00-00',
1960 ) TYPE=InnoDB AUTO_INCREMENT=2 ;
1963 ### Data of table `0_wo_manufacture` ###
1965 INSERT INTO `0_wo_manufacture` VALUES ('1', '1', '2', '2', '2009-06-21');
1968 ### Structure of table `0_wo_requirements` ###
1970 DROP TABLE IF EXISTS `0_wo_requirements`;
1972 CREATE TABLE `0_wo_requirements` (
1973 `id` int(11) NOT NULL auto_increment,
1974 `workorder_id` int(11) NOT NULL default '0',
1975 `stock_id` char(20) NOT NULL default '',
1976 `workcentre` int(11) NOT NULL default '0',
1977 `units_req` double NOT NULL default '1',
1978 `std_cost` double NOT NULL default '0',
1979 `loc_code` char(5) NOT NULL default '',
1980 `units_issued` double NOT NULL default '0',
1982 ) TYPE=InnoDB AUTO_INCREMENT=22 ;
1985 ### Data of table `0_wo_requirements` ###
1987 INSERT INTO `0_wo_requirements` VALUES ('1', '1', '102', '1', '1', '0', 'DEF', '10');
1988 INSERT INTO `0_wo_requirements` VALUES ('2', '1', '103', '1', '1', '0', 'DEF', '10');
1989 INSERT INTO `0_wo_requirements` VALUES ('3', '1', '104', '1', '1', '0', 'DEF', '10');
1990 INSERT INTO `0_wo_requirements` VALUES ('4', '2', '102', '1', '1', '0', 'DEF', '0');
1991 INSERT INTO `0_wo_requirements` VALUES ('5', '2', '103', '1', '1', '0', 'DEF', '0');
1992 INSERT INTO `0_wo_requirements` VALUES ('6', '2', '104', '1', '1', '0', 'DEF', '0');
1993 INSERT INTO `0_wo_requirements` VALUES ('7', '3', '102', '1', '1', '0', 'DEF', '2');
1994 INSERT INTO `0_wo_requirements` VALUES ('8', '3', '103', '1', '1', '0', 'DEF', '2');
1995 INSERT INTO `0_wo_requirements` VALUES ('9', '3', '104', '1', '1', '0', 'DEF', '2');
1996 INSERT INTO `0_wo_requirements` VALUES ('10', '4', '102', '1', '1', '0', 'DEF', '4');
1997 INSERT INTO `0_wo_requirements` VALUES ('11', '4', '103', '1', '1', '0', 'DEF', '4');
1998 INSERT INTO `0_wo_requirements` VALUES ('12', '4', '104', '1', '1', '0', 'DEF', '4');
1999 INSERT INTO `0_wo_requirements` VALUES ('13', '5', '102', '1', '1', '0', 'DEF', '5');
2000 INSERT INTO `0_wo_requirements` VALUES ('14', '5', '103', '1', '1', '0', 'DEF', '5');
2001 INSERT INTO `0_wo_requirements` VALUES ('15', '5', '104', '1', '1', '0', 'DEF', '5');
2002 INSERT INTO `0_wo_requirements` VALUES ('16', '6', '102', '1', '1', '0', 'DEF', '-5');
2003 INSERT INTO `0_wo_requirements` VALUES ('17', '6', '103', '1', '1', '0', 'DEF', '-5');
2004 INSERT INTO `0_wo_requirements` VALUES ('18', '6', '104', '1', '1', '0', 'DEF', '-5');
2005 INSERT INTO `0_wo_requirements` VALUES ('19', '7', '102', '1', '1', '0', 'DEF', '-2');
2006 INSERT INTO `0_wo_requirements` VALUES ('20', '7', '103', '1', '1', '0', 'DEF', '-2');
2007 INSERT INTO `0_wo_requirements` VALUES ('21', '7', '104', '1', '1', '0', 'DEF', '-2');
2010 ### Structure of table `0_workcentres` ###
2012 DROP TABLE IF EXISTS `0_workcentres`;
2014 CREATE TABLE `0_workcentres` (
2015 `id` int(11) NOT NULL auto_increment,
2016 `name` char(40) NOT NULL default '',
2017 `description` char(50) NOT NULL default '',
2018 `inactive` tinyint(1) NOT NULL default '0',
2020 UNIQUE KEY `name` (`name`)
2021 ) TYPE=MyISAM AUTO_INCREMENT=2 ;
2024 ### Data of table `0_workcentres` ###
2026 INSERT INTO `0_workcentres` VALUES ('1', 'Workshop', 'Workshop in Alabama', '0');
2029 ### Structure of table `0_workorders` ###
2031 DROP TABLE IF EXISTS `0_workorders`;
2033 CREATE TABLE `0_workorders` (
2034 `id` int(11) NOT NULL auto_increment,
2035 `wo_ref` varchar(60) NOT NULL default '',
2036 `loc_code` varchar(5) NOT NULL default '',
2037 `units_reqd` double NOT NULL default '1',
2038 `stock_id` varchar(20) NOT NULL default '',
2039 `date_` date NOT NULL default '0000-00-00',
2040 `type` tinyint(4) NOT NULL default '0',
2041 `required_by` date NOT NULL default '0000-00-00',
2042 `released_date` date NOT NULL default '0000-00-00',
2043 `units_issued` double NOT NULL default '0',
2044 `closed` tinyint(1) NOT NULL default '0',
2045 `released` tinyint(1) NOT NULL default '0',
2046 `additional_costs` double NOT NULL default '0',
2048 UNIQUE KEY `wo_ref` (`wo_ref`)
2049 ) TYPE=InnoDB AUTO_INCREMENT=8 ;
2052 ### Data of table `0_workorders` ###
2054 INSERT INTO `0_workorders` VALUES ('1', '1', 'DEF', '10', '3400', '2009-06-21', '0', '2009-06-21', '2009-06-21', '10', '1', '1', '10');
2055 INSERT INTO `0_workorders` VALUES ('2', '2', 'DEF', '3', '3400', '2009-06-21', '2', '2009-07-11', '2009-06-21', '2', '0', '1', '0');
2056 INSERT INTO `0_workorders` VALUES ('3', '3', 'DEF', '2', '3400', '2009-06-21', '0', '2009-06-21', '2009-06-21', '2', '1', '1', '0');
2057 INSERT INTO `0_workorders` VALUES ('4', '4', 'DEF', '4', '3400', '2009-06-21', '0', '2009-06-21', '2009-06-21', '4', '1', '1', '0');
2058 INSERT INTO `0_workorders` VALUES ('5', '5', 'DEF', '5', '3400', '2009-06-21', '0', '2009-06-21', '2009-06-21', '5', '1', '1', '10');
2059 INSERT INTO `0_workorders` VALUES ('6', '6', 'DEF', '-5', '3400', '2009-06-21', '1', '2009-06-21', '2009-06-21', '-5', '1', '1', '0');
2060 INSERT INTO `0_workorders` VALUES ('7', '7', 'DEF', '-2', '3400', '2009-06-21', '1', '2009-06-21', '2009-06-21', '-2', '1', '1', '10');