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', NULL);
126 INSERT INTO `0_bank_trans` VALUES ('2', '26', '1', '1', '', '2009-06-21', '-10', '0', '0', '1', '1', NULL);
127 INSERT INTO `0_bank_trans` VALUES ('3', '26', '1', '1', '', '2009-06-21', '-20', '0', '0', '1', '0', NULL);
128 INSERT INTO `0_bank_trans` VALUES ('4', '0', '18', '1', '1', '2009-02-20', '1000', '0', '0', '0', '', NULL);
129 INSERT INTO `0_bank_trans` VALUES ('5', '0', '19', '1', '2', '2009-02-21', '4000', '0', '0', '0', '', NULL);
130 INSERT INTO `0_bank_trans` VALUES ('6', '2', '5', '1', '1', '2009-06-21', '100', '0', '0', '4', '3', NULL);
131 INSERT INTO `0_bank_trans` VALUES ('7', '1', '8', '1', '1', '2009-06-21', '-50', '0', '0', '4', '1', NULL);
132 INSERT INTO `0_bank_trans` VALUES ('8', '26', '5', '1', '', '2009-06-21', '-10', '0', '0', '1', '1', NULL);
133 INSERT INTO `0_bank_trans` VALUES ('9', '26', '5', '1', '', '2009-06-21', '-20', '0', '0', '1', '0', NULL);
134 INSERT INTO `0_bank_trans` VALUES ('10', '26', '7', '1', '', '2009-06-21', '-10', '0', '0', '1', '1', NULL);
135 INSERT INTO `0_bank_trans` VALUES ('11', '26', '7', '1', '', '2009-06-21', '-20', '0', '0', '1', '0', NULL);
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 ('2145', '', 'Purchase Tax', '4', '0');
249 INSERT INTO `0_chart_master` VALUES ('2150', '', 'Sales Tax', '4', '0');
250 INSERT INTO `0_chart_master` VALUES ('2160', '', 'Accrued Use Tax Payable', '4', '0');
251 INSERT INTO `0_chart_master` VALUES ('2210', '', 'Accrued Wages', '4', '0');
252 INSERT INTO `0_chart_master` VALUES ('2220', '', 'Accrued Comp Time', '4', '0');
253 INSERT INTO `0_chart_master` VALUES ('2230', '', 'Accrued Holiday Pay', '4', '0');
254 INSERT INTO `0_chart_master` VALUES ('2240', '', 'Accrued Vacation Pay', '4', '0');
255 INSERT INTO `0_chart_master` VALUES ('2310', '', 'Accr. Benefits - 401K', '4', '0');
256 INSERT INTO `0_chart_master` VALUES ('2320', '', 'Accr. Benefits - Stock Purchase', '4', '0');
257 INSERT INTO `0_chart_master` VALUES ('2330', '', 'Accr. Benefits - Med, Den', '4', '0');
258 INSERT INTO `0_chart_master` VALUES ('2340', '', 'Accr. Benefits - Payroll Taxes', '4', '0');
259 INSERT INTO `0_chart_master` VALUES ('2350', '', 'Accr. Benefits - Credit Union', '4', '0');
260 INSERT INTO `0_chart_master` VALUES ('2360', '', 'Accr. Benefits - Savings Bond', '4', '0');
261 INSERT INTO `0_chart_master` VALUES ('2370', '', 'Accr. Benefits - Garnish', '4', '0');
262 INSERT INTO `0_chart_master` VALUES ('2380', '', 'Accr. Benefits - Charity Cont.', '4', '0');
263 INSERT INTO `0_chart_master` VALUES ('2620', '', 'Bank Loans', '5', '0');
264 INSERT INTO `0_chart_master` VALUES ('2680', '', 'Loans from Shareholders', '5', '0');
265 INSERT INTO `0_chart_master` VALUES ('3350', '', 'Common Shares', '6', '0');
266 INSERT INTO `0_chart_master` VALUES ('3590', '', 'Retained Earnings - prior years', '7', '0');
267 INSERT INTO `0_chart_master` VALUES ('4010', '', 'Sales', '8', '0');
268 INSERT INTO `0_chart_master` VALUES ('4430', '', 'Shipping & Handling', '9', '0');
269 INSERT INTO `0_chart_master` VALUES ('4440', '', 'Interest', '9', '0');
270 INSERT INTO `0_chart_master` VALUES ('4450', '', 'Foreign Exchange Gain', '9', '0');
271 INSERT INTO `0_chart_master` VALUES ('4500', '', 'Prompt Payment Discounts', '9', '0');
272 INSERT INTO `0_chart_master` VALUES ('4510', '', 'Discounts Given', '9', '0');
273 INSERT INTO `0_chart_master` VALUES ('5010', '', 'Cost of Goods Sold - Retail', '10', '0');
274 INSERT INTO `0_chart_master` VALUES ('5020', '', 'Material Usage Varaiance', '10', '0');
275 INSERT INTO `0_chart_master` VALUES ('5030', '', 'Consumable Materials', '10', '0');
276 INSERT INTO `0_chart_master` VALUES ('5040', '', 'Purchase price Variance', '10', '0');
277 INSERT INTO `0_chart_master` VALUES ('5050', '', 'Purchases of materials', '10', '0');
278 INSERT INTO `0_chart_master` VALUES ('5060', '', 'Discounts Received', '10', '0');
279 INSERT INTO `0_chart_master` VALUES ('5100', '', 'Freight', '10', '0');
280 INSERT INTO `0_chart_master` VALUES ('5410', '', 'Wages & Salaries', '11', '0');
281 INSERT INTO `0_chart_master` VALUES ('5420', '', 'Wages - Overtime', '11', '0');
282 INSERT INTO `0_chart_master` VALUES ('5430', '', 'Benefits - Comp Time', '11', '0');
283 INSERT INTO `0_chart_master` VALUES ('5440', '', 'Benefits - Payroll Taxes', '11', '0');
284 INSERT INTO `0_chart_master` VALUES ('5450', '', 'Benefits - Workers Comp', '11', '0');
285 INSERT INTO `0_chart_master` VALUES ('5460', '', 'Benefits - Pension', '11', '0');
286 INSERT INTO `0_chart_master` VALUES ('5470', '', 'Benefits - General Benefits', '11', '0');
287 INSERT INTO `0_chart_master` VALUES ('5510', '', 'Inc Tax Exp - Federal', '11', '0');
288 INSERT INTO `0_chart_master` VALUES ('5520', '', 'Inc Tax Exp - State', '11', '0');
289 INSERT INTO `0_chart_master` VALUES ('5530', '', 'Taxes - Real Estate', '11', '0');
290 INSERT INTO `0_chart_master` VALUES ('5540', '', 'Taxes - Personal Property', '11', '0');
291 INSERT INTO `0_chart_master` VALUES ('5550', '', 'Taxes - Franchise', '11', '0');
292 INSERT INTO `0_chart_master` VALUES ('5560', '', 'Taxes - Foreign Withholding', '11', '0');
293 INSERT INTO `0_chart_master` VALUES ('5610', '', 'Accounting & Legal', '12', '0');
294 INSERT INTO `0_chart_master` VALUES ('5615', '', 'Advertising & Promotions', '12', '0');
295 INSERT INTO `0_chart_master` VALUES ('5620', '', 'Bad Debts', '12', '0');
296 INSERT INTO `0_chart_master` VALUES ('5660', '', 'Amortization Expense', '12', '0');
297 INSERT INTO `0_chart_master` VALUES ('5685', '', 'Insurance', '12', '0');
298 INSERT INTO `0_chart_master` VALUES ('5690', '', 'Interest & Bank Charges', '12', '0');
299 INSERT INTO `0_chart_master` VALUES ('5700', '', 'Office Supplies', '12', '0');
300 INSERT INTO `0_chart_master` VALUES ('5760', '', 'Rent', '12', '0');
301 INSERT INTO `0_chart_master` VALUES ('5765', '', 'Repair & Maintenance', '12', '0');
302 INSERT INTO `0_chart_master` VALUES ('5780', '', 'Telephone', '12', '0');
303 INSERT INTO `0_chart_master` VALUES ('5785', '', 'Travel & Entertainment', '12', '0');
304 INSERT INTO `0_chart_master` VALUES ('5790', '', 'Utilities', '12', '0');
305 INSERT INTO `0_chart_master` VALUES ('5795', '', 'Registrations', '12', '0');
306 INSERT INTO `0_chart_master` VALUES ('5800', '', 'Licenses', '12', '0');
307 INSERT INTO `0_chart_master` VALUES ('5810', '', 'Foreign Exchange Loss', '12', '0');
308 INSERT INTO `0_chart_master` VALUES ('9990', '', 'Year Profit/Loss', '12', '0');
310 ### Structure of table `0_chart_types` ###
312 DROP TABLE IF EXISTS `0_chart_types`;
314 CREATE TABLE `0_chart_types` (
315 `id` int(11) NOT NULL auto_increment,
316 `name` varchar(60) NOT NULL default '',
317 `class_id` tinyint(1) NOT NULL default '0',
318 `parent` int(11) NOT NULL default '-1',
319 `inactive` tinyint(1) NOT NULL default '0',
322 ) TYPE=MyISAM AUTO_INCREMENT=13 ;
325 ### Data of table `0_chart_types` ###
327 INSERT INTO `0_chart_types` VALUES ('1', 'Current Assets', '1', '-1', '0');
328 INSERT INTO `0_chart_types` VALUES ('2', 'Inventory Assets', '1', '-1', '0');
329 INSERT INTO `0_chart_types` VALUES ('3', 'Capital Assets', '1', '-1', '0');
330 INSERT INTO `0_chart_types` VALUES ('4', 'Current Liabilities', '2', '-1', '0');
331 INSERT INTO `0_chart_types` VALUES ('5', 'Long Term Liabilities', '2', '-1', '0');
332 INSERT INTO `0_chart_types` VALUES ('6', 'Share Capital', '2', '-1', '0');
333 INSERT INTO `0_chart_types` VALUES ('7', 'Retained Earnings', '2', '-1', '0');
334 INSERT INTO `0_chart_types` VALUES ('8', 'Sales Revenue', '3', '-1', '0');
335 INSERT INTO `0_chart_types` VALUES ('9', 'Other Revenue', '3', '-1', '0');
336 INSERT INTO `0_chart_types` VALUES ('10', 'Cost of Goods Sold', '4', '-1', '0');
337 INSERT INTO `0_chart_types` VALUES ('11', 'Payroll Expenses', '4', '-1', '0');
338 INSERT INTO `0_chart_types` VALUES ('12', 'General & Administrative expenses', '4', '-1', '0');
341 ### Structure of table `0_comments` ###
343 DROP TABLE IF EXISTS `0_comments`;
345 CREATE TABLE `0_comments` (
346 `type` int(11) NOT NULL default '0',
347 `id` int(11) NOT NULL default '0',
348 `date_` date default '0000-00-00',
353 ### Data of table `0_comments` ###
357 ### Structure of table `0_company` ###
359 DROP TABLE IF EXISTS `0_company`;
361 CREATE TABLE `0_company` (
362 `coy_code` int(11) NOT NULL default '1',
363 `coy_name` varchar(60) NOT NULL default '',
364 `gst_no` varchar(25) NOT NULL default '',
365 `coy_no` varchar(25) NOT NULL default '0',
366 `tax_prd` int(11) NOT NULL default '1',
367 `tax_last` int(11) NOT NULL default '1',
368 `postal_address` tinytext NOT NULL,
369 `phone` varchar(30) NOT NULL default '',
370 `fax` varchar(30) NOT NULL default '',
371 `email` varchar(100) NOT NULL default '',
372 `coy_logo` varchar(100) NOT NULL default '',
373 `domicile` varchar(55) NOT NULL default '',
374 `curr_default` char(3) NOT NULL default '',
375 `debtors_act` varchar(11) NOT NULL default '',
376 `pyt_discount_act` varchar(11) NOT NULL default '',
377 `creditors_act` varchar(11) NOT NULL default '',
378 `bank_charge_act` varchar(11) NOT NULL default '',
379 `exchange_diff_act` varchar(11) NOT NULL default '',
380 `profit_loss_year_act` varchar(11) NOT NULL default '',
381 `retained_earnings_act` varchar(11) NOT NULL default '',
382 `freight_act` varchar(11) NOT NULL default '',
383 `default_sales_act` varchar(11) NOT NULL default '',
384 `default_sales_discount_act` varchar(11) NOT NULL default '',
385 `default_prompt_payment_act` varchar(11) NOT NULL default '',
386 `default_inventory_act` varchar(11) NOT NULL default '',
387 `default_cogs_act` varchar(11) NOT NULL default '',
388 `default_adj_act` varchar(11) NOT NULL default '',
389 `default_inv_sales_act` varchar(11) NOT NULL default '',
390 `default_assembly_act` varchar(11) NOT NULL default '',
391 `payroll_act` varchar(11) NOT NULL default '',
392 `allow_negative_stock` tinyint(1) NOT NULL default '0',
393 `po_over_receive` int(11) NOT NULL default '10',
394 `po_over_charge` int(11) NOT NULL default '10',
395 `default_credit_limit` int(11) NOT NULL default '1000',
396 `default_workorder_required` int(11) NOT NULL default '20',
397 `default_dim_required` int(11) NOT NULL default '20',
398 `past_due_days` int(11) NOT NULL default '30',
399 `use_dimension` tinyint(1) default '0',
400 `f_year` int(11) NOT NULL default '1',
401 `no_item_list` tinyint(1) NOT NULL default '0',
402 `no_customer_list` tinyint(1) NOT NULL default '0',
403 `no_supplier_list` tinyint(1) NOT NULL default '0',
404 `base_sales` int(11) NOT NULL default '-1',
405 `foreign_codes` tinyint(1) NOT NULL default '0',
406 `accumulate_shipping` tinyint(1) NOT NULL default '0',
407 `legal_text` tinytext NOT NULL,
408 `default_delivery_required` smallint(6) NOT NULL default '1',
409 `version_id` varchar(11) NOT NULL default '',
410 `time_zone` tinyint(1) NOT NULL default '0',
411 `add_pct` int(5) NOT NULL default '-1',
412 `round_to` int(5) NOT NULL default '1',
413 `login_tout` SMALLINT(6) NOT NULL DEFAULT '600',
414 PRIMARY KEY (`coy_code`)
417 ### Data of table `0_company` ###
419 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');
421 ### Structure of table `0_credit_status` ###
423 DROP TABLE IF EXISTS `0_credit_status`;
425 CREATE TABLE `0_credit_status` (
426 `id` int(11) NOT NULL auto_increment,
427 `reason_description` char(100) NOT NULL default '',
428 `dissallow_invoices` tinyint(1) NOT NULL default '0',
429 `inactive` tinyint(1) NOT NULL default '0',
431 UNIQUE KEY `reason_description` (`reason_description`)
432 ) TYPE=MyISAM AUTO_INCREMENT=5 ;
435 ### Data of table `0_credit_status` ###
437 INSERT INTO `0_credit_status` VALUES ('1', 'Good History', '0', '0');
438 INSERT INTO `0_credit_status` VALUES ('3', 'No more work until payment received', '1', '0');
439 INSERT INTO `0_credit_status` VALUES ('4', 'In liquidation', '1', '0');
442 ### Structure of table `0_currencies` ###
444 DROP TABLE IF EXISTS `0_currencies`;
446 CREATE TABLE `0_currencies` (
447 `currency` varchar(60) NOT NULL default '',
448 `curr_abrev` char(3) NOT NULL default '',
449 `curr_symbol` varchar(10) NOT NULL default '',
450 `country` varchar(100) NOT NULL default '',
451 `hundreds_name` varchar(15) NOT NULL default '',
452 `auto_update` tinyint(1) NOT NULL default '1',
453 `inactive` tinyint(1) NOT NULL default '0',
454 PRIMARY KEY (`curr_abrev`)
458 ### Data of table `0_currencies` ###
460 INSERT INTO `0_currencies` VALUES ('US Dollars', 'USD', '$', 'United States', 'Cents', '1', '0');
461 INSERT INTO `0_currencies` VALUES ('CA Dollars', 'CAD', '$', 'Canada', 'Cents', '1', '0');
462 INSERT INTO `0_currencies` VALUES ('Euro', 'EUR', '?', 'Europe', 'Cents', '1', '0');
463 INSERT INTO `0_currencies` VALUES ('Pounds', 'GBP', '?', 'England', 'Pence', '1', '0');
464 INSERT INTO `0_currencies` VALUES ('DK Kroner', 'DKK', '?', 'Denmark', 'Ore', '1', '0');
466 ### Structure of table `0_cust_allocations` ###
468 DROP TABLE IF EXISTS `0_cust_allocations`;
470 CREATE TABLE `0_cust_allocations` (
471 `id` int(11) NOT NULL auto_increment,
472 `amt` double unsigned default NULL,
473 `date_alloc` date NOT NULL default '0000-00-00',
474 `trans_no_from` int(11) default NULL,
475 `trans_type_from` int(11) default NULL,
476 `trans_no_to` int(11) default NULL,
477 `trans_type_to` int(11) default NULL,
479 ) TYPE=InnoDB AUTO_INCREMENT=2 ;
482 ### Data of table `0_cust_allocations` ###
484 INSERT INTO `0_cust_allocations` VALUES ('1', '37.68', '2009-06-21', '3', '11', '18', '10');
487 ### Structure of table `0_cust_branch` ###
489 DROP TABLE IF EXISTS `0_cust_branch`;
491 CREATE TABLE `0_cust_branch` (
492 `branch_code` int(11) NOT NULL auto_increment,
493 `debtor_no` int(11) NOT NULL default '0',
494 `br_name` varchar(60) NOT NULL default '',
495 `branch_ref` varchar(30) NOT NULL default '',
496 `br_address` tinytext NOT NULL,
497 `area` int(11) default NULL,
498 `salesman` int(11) NOT NULL default '0',
499 `phone` varchar(30) NOT NULL default '',
500 `phone2` varchar(30) NOT NULL default '',
501 `fax` varchar(30) NOT NULL default '',
502 `contact_name` varchar(60) NOT NULL default '',
503 `email` varchar(100) NOT NULL default '',
504 `default_location` varchar(5) NOT NULL default '',
505 `tax_group_id` int(11) default NULL,
506 `sales_account` varchar(11) default NULL,
507 `sales_discount_account` varchar(11) default NULL,
508 `receivables_account` varchar(11) default NULL,
509 `payment_discount_account` varchar(11) default NULL,
510 `default_ship_via` int(11) NOT NULL default '1',
511 `disable_trans` tinyint(4) NOT NULL default '0',
512 `br_post_address` tinytext NOT NULL,
513 `group_no` int(11) NOT NULL default '0',
514 `notes` tinytext NOT NULL,
515 `inactive` tinyint(1) NOT NULL default '0',
516 PRIMARY KEY (`branch_code`,`debtor_no`),
517 KEY `branch_code` (`branch_code`),
518 KEY `br_name` (`br_name`)
519 ) TYPE=MyISAM AUTO_INCREMENT=4 ;
522 ### Data of table `0_cust_branch` ###
524 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');
525 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');
526 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');
529 ### Structure of table `0_debtor_trans` ###
531 DROP TABLE IF EXISTS `0_debtor_trans`;
533 CREATE TABLE `0_debtor_trans` (
534 `trans_no` int(11) unsigned NOT NULL default '0',
535 `type` smallint(6) unsigned NOT NULL default '0',
536 `version` tinyint(1) unsigned NOT NULL default '0',
537 `debtor_no` int(11) unsigned default NULL,
538 `branch_code` int(11) NOT NULL default '-1',
539 `tran_date` date NOT NULL default '0000-00-00',
540 `due_date` date NOT NULL default '0000-00-00',
541 `reference` varchar(60) NOT NULL default '',
542 `tpe` int(11) NOT NULL default '0',
543 `order_` int(11) NOT NULL default '0',
544 `ov_amount` double NOT NULL default '0',
545 `ov_gst` double NOT NULL default '0',
546 `ov_freight` double NOT NULL default '0',
547 `ov_freight_tax` double NOT NULL default '0',
548 `ov_discount` double NOT NULL default '0',
549 `alloc` double NOT NULL default '0',
550 `rate` double NOT NULL default '1',
551 `ship_via` int(11) default NULL,
552 `trans_link` int(11) NOT NULL default '0',
553 `dimension_id` int(11) NOT NULL default '0',
554 `dimension2_id` int(11) NOT NULL default '0',
555 PRIMARY KEY (`trans_no`,`type`),
556 KEY `debtor_no` (`debtor_no`,`branch_code`)
560 ### Data of table `0_debtor_trans` ###
562 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');
563 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');
564 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');
565 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');
566 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');
567 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');
568 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');
569 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');
572 ### Structure of table `0_debtor_trans_details` ###
574 DROP TABLE IF EXISTS `0_debtor_trans_details`;
576 CREATE TABLE `0_debtor_trans_details` (
577 `id` int(11) NOT NULL auto_increment,
578 `debtor_trans_no` int(11) default NULL,
579 `debtor_trans_type` int(11) default NULL,
580 `stock_id` varchar(20) NOT NULL default '',
581 `description` tinytext,
582 `unit_price` double NOT NULL default '0',
583 `unit_tax` double NOT NULL default '0',
584 `quantity` double NOT NULL default '0',
585 `discount_percent` double NOT NULL default '0',
586 `standard_cost` double NOT NULL default '0',
587 `qty_done` double NOT NULL default '0',
589 ) TYPE=InnoDB AUTO_INCREMENT=9 ;
592 ### Data of table `0_debtor_trans_details` ###
594 INSERT INTO `0_debtor_trans_details` VALUES ('1', '2', '13', '102', '17inch VGA Monitor', '30.4', '0', '2', '0', '10', '0');
595 INSERT INTO `0_debtor_trans_details` VALUES ('2', '3', '13', '102', '17inch VGA Monitor', '50', '2.5', '1', '0', '10', '1');
596 INSERT INTO `0_debtor_trans_details` VALUES ('3', '17', '10', '102', '17inch VGA Monitor', '50', '2.5', '1', '0', '10', '0');
597 INSERT INTO `0_debtor_trans_details` VALUES ('4', '4', '13', '102', '17inch VGA Monitor', '35.89', '1.79', '1', '0', '10', '1');
598 INSERT INTO `0_debtor_trans_details` VALUES ('5', '18', '10', '102', '17inch VGA Monitor', '35.89', '1.79', '1', '0', '10', '1');
599 INSERT INTO `0_debtor_trans_details` VALUES ('6', '5', '13', '102', '17inch VGA Monitor', '50', '2.38', '1', '0', '10', '1');
600 INSERT INTO `0_debtor_trans_details` VALUES ('7', '19', '10', '102', '17inch VGA Monitor', '50', '2.38', '1', '0', '10', '0');
601 INSERT INTO `0_debtor_trans_details` VALUES ('8', '3', '11', '102', '17inch VGA Monitor', '35.89', '1.79', '1', '0', '10', '0');
604 ### Structure of table `0_debtors_master` ###
606 DROP TABLE IF EXISTS `0_debtors_master`;
608 CREATE TABLE `0_debtors_master` (
609 `debtor_no` int(11) NOT NULL auto_increment,
610 `name` varchar(100) NOT NULL default '',
611 `debtor_ref` varchar(30) NOT NULL,
613 `email` varchar(100) NOT NULL default '',
614 `tax_id` varchar(55) NOT NULL default '',
615 `curr_code` char(3) NOT NULL default '',
616 `sales_type` int(11) NOT NULL default '1',
617 `dimension_id` int(11) NOT NULL default '0',
618 `dimension2_id` int(11) NOT NULL default '0',
619 `credit_status` int(11) NOT NULL default '0',
620 `payment_terms` int(11) default NULL,
621 `discount` double NOT NULL default '0',
622 `pymt_discount` double NOT NULL default '0',
623 `credit_limit` float NOT NULL default '1000',
624 `notes` tinytext NOT NULL,
625 `inactive` tinyint(1) NOT NULL default '0',
626 PRIMARY KEY (`debtor_no`),
627 UNIQUE KEY `name` (`name`)
628 ) TYPE=MyISAM AUTO_INCREMENT=4 ;
631 ### Data of table `0_debtors_master` ###
633 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');
634 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');
635 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');
638 ### Structure of table `0_dimensions` ###
640 DROP TABLE IF EXISTS `0_dimensions`;
642 CREATE TABLE `0_dimensions` (
643 `id` int(11) NOT NULL auto_increment,
644 `reference` varchar(60) NOT NULL default '',
645 `name` varchar(60) NOT NULL default '',
646 `type_` tinyint(1) NOT NULL default '1',
647 `closed` tinyint(1) NOT NULL default '0',
648 `date_` date NOT NULL default '0000-00-00',
649 `due_date` date NOT NULL default '0000-00-00',
651 UNIQUE KEY `reference` (`reference`)
652 ) TYPE=InnoDB AUTO_INCREMENT=3 ;
655 ### Data of table `0_dimensions` ###
657 INSERT INTO `0_dimensions` VALUES ('1', '1', 'Support', '1', '0', '2009-06-21', '2015-07-11');
658 INSERT INTO `0_dimensions` VALUES ('2', '2', 'Development', '1', '0', '2009-06-21', '2015-07-11');
661 ### Structure of table `0_exchange_rates` ###
663 DROP TABLE IF EXISTS `0_exchange_rates`;
665 CREATE TABLE `0_exchange_rates` (
666 `id` int(11) NOT NULL auto_increment,
667 `curr_code` char(3) NOT NULL default '',
668 `rate_buy` double NOT NULL default '0',
669 `rate_sell` double NOT NULL default '0',
670 `date_` date NOT NULL default '0000-00-00',
672 UNIQUE KEY `curr_code` (`curr_code`,`date_`)
673 ) TYPE=MyISAM AUTO_INCREMENT=4 ;
676 ### Data of table `0_exchange_rates` ###
678 INSERT INTO `0_exchange_rates` VALUES ('1', 'DKK', '0.18717252868313', '0.18717252868313', '2009-06-21');
679 INSERT INTO `0_exchange_rates` VALUES ('2', 'GBP', '1.6445729799917', '1.6445729799917', '2009-06-21');
680 INSERT INTO `0_exchange_rates` VALUES ('3', 'EUR', '1.3932', '1.3932', '2009-06-21');
683 ### Structure of table `0_fiscal_year` ###
685 DROP TABLE IF EXISTS `0_fiscal_year`;
687 CREATE TABLE `0_fiscal_year` (
688 `id` int(11) NOT NULL auto_increment,
689 `begin` date default '0000-00-00',
690 `end` date default '0000-00-00',
691 `closed` tinyint(1) NOT NULL default '0',
693 ) TYPE=InnoDB AUTO_INCREMENT=3 ;
696 ### Data of table `0_fiscal_year` ###
698 INSERT INTO `0_fiscal_year` VALUES ('1', '2008-01-01', '2008-12-31', '0');
699 INSERT INTO `0_fiscal_year` VALUES ('2', '2009-01-01', '2009-12-31', '0');
702 ### Structure of table `0_gl_trans` ###
704 DROP TABLE IF EXISTS `0_gl_trans`;
706 CREATE TABLE `0_gl_trans` (
707 `counter` int(11) NOT NULL auto_increment,
708 `type` smallint(6) NOT NULL default '0',
709 `type_no` bigint(16) NOT NULL default '1',
710 `tran_date` date NOT NULL default '0000-00-00',
711 `account` varchar(11) NOT NULL default '',
712 `memo_` tinytext NOT NULL,
713 `amount` double NOT NULL default '0',
714 `dimension_id` int(11) NOT NULL default '0',
715 `dimension2_id` int(11) NOT NULL default '0',
716 `person_type_id` int(11) default NULL,
717 `person_id` tinyblob,
718 PRIMARY KEY (`counter`),
719 KEY `Type_and_Number` (`type`,`type_no`)
720 ) TYPE=InnoDB AUTO_INCREMENT=84 ;
723 ### Data of table `0_gl_trans` ###
725 INSERT INTO `0_gl_trans` VALUES ('1', '20', '7', '2009-06-21', '2100', '', '-3465', '0', '0', '3', '2');
726 INSERT INTO `0_gl_trans` VALUES ('2', '20', '7', '2009-06-21', '1510', '', '1000', '0', '0', '3', '2');
727 INSERT INTO `0_gl_trans` VALUES ('3', '20', '7', '2009-06-21', '1510', '', '1100', '0', '0', '3', '2');
728 INSERT INTO `0_gl_trans` VALUES ('4', '20', '7', '2009-06-21', '1510', '', '1200', '0', '0', '3', '2');
729 INSERT INTO `0_gl_trans` VALUES ('5', '20', '7', '2009-06-21', '2150', '', '165', '0', '0', '3', '2');
730 INSERT INTO `0_gl_trans` VALUES ('6', '22', '4', '2009-06-21', '2100', '', '3465', '0', '0', '3', '2');
731 INSERT INTO `0_gl_trans` VALUES ('7', '22', '4', '2009-06-21', '1060', '', '-3465', '0', '0', '3', '2');
732 INSERT INTO `0_gl_trans` VALUES ('8', '26', '1', '2009-06-21', '1510', '', '-100', '0', '0', NULL, '');
733 INSERT INTO `0_gl_trans` VALUES ('9', '26', '1', '2009-06-21', '1510', '', '-110', '0', '0', NULL, '');
734 INSERT INTO `0_gl_trans` VALUES ('10', '26', '1', '2009-06-21', '1510', '', '-120', '0', '0', NULL, '');
735 INSERT INTO `0_gl_trans` VALUES ('11', '26', '1', '2009-06-21', '1060', 'Overhead Cost', '-10', '0', '0', '1', '1');
736 INSERT INTO `0_gl_trans` VALUES ('12', '26', '1', '2009-06-21', '1530', 'Overhead Cost', '10', '0', '0', '1', '1');
737 INSERT INTO `0_gl_trans` VALUES ('13', '26', '1', '2009-06-21', '1060', 'Labour Cost', '-20', '0', '0', '1', '0');
738 INSERT INTO `0_gl_trans` VALUES ('14', '26', '1', '2009-06-21', '1530', 'Labour Cost', '20', '0', '0', '1', '0');
739 INSERT INTO `0_gl_trans` VALUES ('15', '26', '1', '2009-06-21', '1510', '', '330', '0', '0', NULL, '');
740 INSERT INTO `0_gl_trans` VALUES ('16', '13', '2', '2009-06-21', '5010', '', '20', '0', '0', '2', '1');
741 INSERT INTO `0_gl_trans` VALUES ('17', '13', '2', '2009-06-21', '1510', '', '-20', '0', '0', '2', '1');
742 INSERT INTO `0_gl_trans` VALUES ('18', '13', '3', '2009-06-21', '5010', '', '10', '0', '0', '2', '2');
743 INSERT INTO `0_gl_trans` VALUES ('19', '13', '3', '2009-06-21', '1510', '', '-10', '0', '0', '2', '2');
744 INSERT INTO `0_gl_trans` VALUES ('20', '10', '17', '2009-06-21', '4010', '', '-50', '0', '0', '2', '2');
745 INSERT INTO `0_gl_trans` VALUES ('21', '10', '17', '2009-06-21', '1200', '', '52.5', '0', '0', '2', '2');
746 INSERT INTO `0_gl_trans` VALUES ('22', '10', '17', '2009-06-21', '2150', '', '-2.5', '0', '0', '2', '2');
747 INSERT INTO `0_gl_trans` VALUES ('23', '13', '4', '2009-06-21', '5010', '', '10', '2', '0', '2', '3');
748 INSERT INTO `0_gl_trans` VALUES ('24', '13', '4', '2009-06-21', '1510', '', '-10', '0', '0', '2', '3');
749 INSERT INTO `0_gl_trans` VALUES ('25', '10', '18', '2009-06-21', '4010', '', '-50', '2', '0', '2', '3');
750 INSERT INTO `0_gl_trans` VALUES ('26', '10', '18', '2009-06-21', '1200', '', '52.5', '0', '0', '2', '3');
751 INSERT INTO `0_gl_trans` VALUES ('27', '10', '18', '2009-06-21', '2150', '', '-2.5', '0', '0', '2', '3');
752 INSERT INTO `0_gl_trans` VALUES ('28', '0', '18', '2009-02-20', '1060', '', '1000', '0', '0', NULL, '');
753 INSERT INTO `0_gl_trans` VALUES ('29', '0', '18', '2009-02-20', '3350', '', '-1000', '0', '0', NULL, '');
754 INSERT INTO `0_gl_trans` VALUES ('30', '0', '19', '2009-02-21', '1060', '', '4000', '0', '0', NULL, '');
755 INSERT INTO `0_gl_trans` VALUES ('31', '0', '19', '2009-02-21', '3350', '', '-4000', '0', '0', NULL, '');
756 INSERT INTO `0_gl_trans` VALUES ('32', '26', '3', '2009-06-21', '1510', '', '-20', '0', '0', NULL, '');
757 INSERT INTO `0_gl_trans` VALUES ('33', '26', '3', '2009-06-21', '1510', '', '-22', '0', '0', NULL, '');
758 INSERT INTO `0_gl_trans` VALUES ('34', '26', '3', '2009-06-21', '1510', '', '-24', '0', '0', NULL, '');
759 INSERT INTO `0_gl_trans` VALUES ('35', '26', '3', '2009-06-21', '1540', '', '66', '0', '0', NULL, '');
760 INSERT INTO `0_gl_trans` VALUES ('36', '2', '5', '2009-06-21', '2150', 'Cash Sales', '-4.76', '0', '0', '4', '3');
761 INSERT INTO `0_gl_trans` VALUES ('37', '2', '5', '2009-06-21', '4010', 'Cash Sales', '-95.24', '0', '0', '4', '3');
762 INSERT INTO `0_gl_trans` VALUES ('38', '2', '5', '2009-06-21', '1060', '', '100', '0', '0', '4', '3');
763 INSERT INTO `0_gl_trans` VALUES ('39', '1', '8', '2009-06-21', '2150', 'Maintenance', '2.38', '0', '0', '4', '1');
764 INSERT INTO `0_gl_trans` VALUES ('40', '1', '8', '2009-06-21', '5765', 'Maintenance', '47.62', '0', '0', '4', '1');
765 INSERT INTO `0_gl_trans` VALUES ('41', '1', '8', '2009-06-21', '1060', '', '-50', '0', '0', '4', '1');
766 INSERT INTO `0_gl_trans` VALUES ('42', '20', '8', '2009-06-21', '2100', '', '-20', '0', '0', '3', '2');
767 INSERT INTO `0_gl_trans` VALUES ('43', '20', '8', '2009-06-21', '2150', '', '0.95', '0', '0', '3', '2');
768 INSERT INTO `0_gl_trans` VALUES ('44', '20', '8', '2009-06-21', '5780', '', '19.05', '0', '0', '3', '2');
769 INSERT INTO `0_gl_trans` VALUES ('45', '26', '4', '2009-06-21', '1510', '', '-40', '0', '0', NULL, '');
770 INSERT INTO `0_gl_trans` VALUES ('46', '26', '4', '2009-06-21', '1510', '', '-44', '0', '0', NULL, '');
771 INSERT INTO `0_gl_trans` VALUES ('47', '26', '4', '2009-06-21', '1510', '', '-48', '0', '0', NULL, '');
772 INSERT INTO `0_gl_trans` VALUES ('48', '26', '4', '2009-06-21', '1540', '', '132', '0', '0', NULL, '');
773 INSERT INTO `0_gl_trans` VALUES ('49', '26', '2', '2009-06-21', '1510', '', '-20', '0', '0', NULL, '');
774 INSERT INTO `0_gl_trans` VALUES ('50', '26', '2', '2009-06-21', '1510', '', '-22', '0', '0', NULL, '');
775 INSERT INTO `0_gl_trans` VALUES ('51', '26', '2', '2009-06-21', '1510', '', '-24', '0', '0', NULL, '');
776 INSERT INTO `0_gl_trans` VALUES ('52', '26', '2', '2009-06-21', '1540', '', '66', '0', '0', NULL, '');
777 INSERT INTO `0_gl_trans` VALUES ('53', '26', '5', '2009-06-21', '1510', '', '-50', '0', '0', NULL, '');
778 INSERT INTO `0_gl_trans` VALUES ('54', '26', '5', '2009-06-21', '1510', '', '-55', '0', '0', NULL, '');
779 INSERT INTO `0_gl_trans` VALUES ('55', '26', '5', '2009-06-21', '1510', '', '-60', '0', '0', NULL, '');
780 INSERT INTO `0_gl_trans` VALUES ('56', '26', '5', '2009-06-21', '1060', 'Overhead Cost', '-10', '0', '0', '1', '1');
781 INSERT INTO `0_gl_trans` VALUES ('57', '26', '5', '2009-06-21', '1530', 'Overhead Cost', '10', '0', '0', '1', '1');
782 INSERT INTO `0_gl_trans` VALUES ('58', '26', '5', '2009-06-21', '1060', 'Labour Cost', '-20', '0', '0', '1', '0');
783 INSERT INTO `0_gl_trans` VALUES ('59', '26', '5', '2009-06-21', '1530', 'Labour Cost', '20', '0', '0', '1', '0');
784 INSERT INTO `0_gl_trans` VALUES ('60', '26', '5', '2009-06-21', '1540', '', '165', '0', '0', NULL, '');
785 INSERT INTO `0_gl_trans` VALUES ('61', '26', '6', '2009-06-21', '1510', '', '50', '0', '0', NULL, '');
786 INSERT INTO `0_gl_trans` VALUES ('62', '26', '6', '2009-06-21', '1510', '', '55', '0', '0', NULL, '');
787 INSERT INTO `0_gl_trans` VALUES ('63', '26', '6', '2009-06-21', '1510', '', '60', '0', '0', NULL, '');
788 INSERT INTO `0_gl_trans` VALUES ('64', '26', '6', '2009-06-21', '1540', '', '-165', '0', '0', NULL, '');
789 INSERT INTO `0_gl_trans` VALUES ('65', '26', '7', '2009-06-21', '1510', '', '20', '0', '0', NULL, '');
790 INSERT INTO `0_gl_trans` VALUES ('66', '26', '7', '2009-06-21', '1510', '', '22', '0', '0', NULL, '');
791 INSERT INTO `0_gl_trans` VALUES ('67', '26', '7', '2009-06-21', '1510', '', '24', '0', '0', NULL, '');
792 INSERT INTO `0_gl_trans` VALUES ('68', '26', '7', '2009-06-21', '1060', 'Overhead Cost', '-10', '0', '0', '1', '1');
793 INSERT INTO `0_gl_trans` VALUES ('69', '26', '7', '2009-06-21', '1530', 'Overhead Cost', '10', '0', '0', '1', '1');
794 INSERT INTO `0_gl_trans` VALUES ('70', '26', '7', '2009-06-21', '1060', 'Labour Cost', '-20', '0', '0', '1', '0');
795 INSERT INTO `0_gl_trans` VALUES ('71', '26', '7', '2009-06-21', '1530', 'Labour Cost', '20', '0', '0', '1', '0');
796 INSERT INTO `0_gl_trans` VALUES ('72', '26', '7', '2009-06-21', '1540', '', '-66', '0', '0', NULL, '');
797 INSERT INTO `0_gl_trans` VALUES ('73', '13', '5', '2009-06-21', '5010', '', '10', '0', '0', '2', '2');
798 INSERT INTO `0_gl_trans` VALUES ('74', '13', '5', '2009-06-21', '1510', '', '-10', '0', '0', '2', '2');
799 INSERT INTO `0_gl_trans` VALUES ('75', '10', '19', '2009-06-21', '4010', '', '-47.62', '0', '0', '2', '2');
800 INSERT INTO `0_gl_trans` VALUES ('76', '10', '19', '2009-06-21', '1200', '', '55', '0', '0', '2', '2');
801 INSERT INTO `0_gl_trans` VALUES ('77', '10', '19', '2009-06-21', '4430', '', '-5', '0', '0', '2', '2');
802 INSERT INTO `0_gl_trans` VALUES ('78', '10', '19', '2009-06-21', '2150', '', '-2.38', '0', '0', '2', '2');
803 INSERT INTO `0_gl_trans` VALUES ('79', '11', '3', '2009-06-21', '5010', '', '-10', '2', '0', '2', '3');
804 INSERT INTO `0_gl_trans` VALUES ('80', '11', '3', '2009-06-21', '1510', '', '10', '0', '0', '2', '3');
805 INSERT INTO `0_gl_trans` VALUES ('81', '11', '3', '2009-06-21', '4010', '', '50', '2', '0', '2', '3');
806 INSERT INTO `0_gl_trans` VALUES ('82', '11', '3', '2009-06-21', '1200', '', '-52.5', '0', '0', '2', '3');
807 INSERT INTO `0_gl_trans` VALUES ('83', '11', '3', '2009-06-21', '2150', '', '2.5', '0', '0', '2', '3');
810 ### Structure of table `0_grn_batch` ###
812 DROP TABLE IF EXISTS `0_grn_batch`;
814 CREATE TABLE `0_grn_batch` (
815 `id` int(11) NOT NULL auto_increment,
816 `supplier_id` int(11) NOT NULL default '0',
817 `purch_order_no` int(11) default NULL,
818 `reference` varchar(60) NOT NULL default '',
819 `delivery_date` date NOT NULL default '0000-00-00',
820 `loc_code` varchar(5) default NULL,
822 ) TYPE=InnoDB AUTO_INCREMENT=2 ;
825 ### Data of table `0_grn_batch` ###
827 INSERT INTO `0_grn_batch` VALUES ('1', '2', '1', '1', '2009-06-21', 'DEF');
830 ### Structure of table `0_grn_items` ###
832 DROP TABLE IF EXISTS `0_grn_items`;
834 CREATE TABLE `0_grn_items` (
835 `id` int(11) NOT NULL auto_increment,
836 `grn_batch_id` int(11) default NULL,
837 `po_detail_item` int(11) NOT NULL default '0',
838 `item_code` varchar(20) NOT NULL default '',
839 `description` tinytext,
840 `qty_recd` double NOT NULL default '0',
841 `quantity_inv` double NOT NULL default '0',
843 ) TYPE=InnoDB AUTO_INCREMENT=4 ;
846 ### Data of table `0_grn_items` ###
848 INSERT INTO `0_grn_items` VALUES ('1', '1', '1', '102', '17inch VGA Monitor', '100', '100');
849 INSERT INTO `0_grn_items` VALUES ('2', '1', '2', '103', '32MB VGA Card', '100', '100');
850 INSERT INTO `0_grn_items` VALUES ('3', '1', '3', '104', '52x CD Drive', '100', '100');
853 ### Structure of table `0_groups` ###
855 DROP TABLE IF EXISTS `0_groups`;
857 CREATE TABLE `0_groups` (
858 `id` smallint(6) unsigned NOT NULL auto_increment,
859 `description` varchar(60) NOT NULL default '',
860 `inactive` tinyint(1) NOT NULL default '0',
862 UNIQUE KEY `description` (`description`)
863 ) TYPE=MyISAM AUTO_INCREMENT=4 AUTO_INCREMENT=4 ;
866 ### Data of table `0_groups` ###
868 INSERT INTO `0_groups` VALUES ('1', 'Small', '0');
869 INSERT INTO `0_groups` VALUES ('2', 'Medium', '0');
870 INSERT INTO `0_groups` VALUES ('3', 'Large', '0');
873 ### Structure of table `0_item_codes` ###
875 DROP TABLE IF EXISTS `0_item_codes`;
877 CREATE TABLE `0_item_codes` (
878 `id` int(11) unsigned NOT NULL auto_increment,
879 `item_code` varchar(20) NOT NULL,
880 `stock_id` varchar(20) NOT NULL,
881 `description` varchar(200) NOT NULL default '',
882 `category_id` smallint(6) unsigned NOT NULL,
883 `quantity` double NOT NULL default '1',
884 `is_foreign` tinyint(1) NOT NULL default '0',
885 `inactive` tinyint(1) NOT NULL default '0',
887 UNIQUE KEY `stock_id` (`stock_id`,`item_code`)
888 ) TYPE=MyISAM AUTO_INCREMENT=6 ;
891 ### Data of table `0_item_codes` ###
893 INSERT INTO `0_item_codes` VALUES ('1', '102', '102', '17inch VGA Monitor', '1', '1', '0', '0');
894 INSERT INTO `0_item_codes` VALUES ('2', '103', '103', '32MB VGA Card', '1', '1', '0', '0');
895 INSERT INTO `0_item_codes` VALUES ('3', '104', '104', '52x CD Drive', '1', '1', '0', '0');
896 INSERT INTO `0_item_codes` VALUES ('4', '3400', '3400', 'P4 Business System', '3', '1', '0', '0');
897 INSERT INTO `0_item_codes` VALUES ('5', '201', '201', 'Assembly Labour', '4', '1', '0', '0');
900 ### Structure of table `0_item_tax_type_exemptions` ###
902 DROP TABLE IF EXISTS `0_item_tax_type_exemptions`;
904 CREATE TABLE `0_item_tax_type_exemptions` (
905 `item_tax_type_id` int(11) NOT NULL default '0',
906 `tax_type_id` int(11) NOT NULL default '0',
907 PRIMARY KEY (`item_tax_type_id`,`tax_type_id`)
911 ### Data of table `0_item_tax_type_exemptions` ###
915 ### Structure of table `0_item_tax_types` ###
917 DROP TABLE IF EXISTS `0_item_tax_types`;
919 CREATE TABLE `0_item_tax_types` (
920 `id` int(11) NOT NULL auto_increment,
921 `name` varchar(60) NOT NULL default '',
922 `exempt` tinyint(1) NOT NULL default '0',
923 `inactive` tinyint(1) NOT NULL default '0',
925 UNIQUE KEY `name` (`name`)
926 ) TYPE=InnoDB AUTO_INCREMENT=2 ;
929 ### Data of table `0_item_tax_types` ###
931 INSERT INTO `0_item_tax_types` VALUES ('1', 'Regular', '0', '0');
933 ### Structure of table `0_item_units` ###
935 DROP TABLE IF EXISTS `0_item_units`;
937 CREATE TABLE `0_item_units` (
938 `abbr` varchar(20) NOT NULL,
939 `name` varchar(40) NOT NULL,
940 `decimals` tinyint(2) NOT NULL,
941 `inactive` tinyint(1) NOT NULL default '0',
942 PRIMARY KEY (`abbr`),
943 UNIQUE KEY `name` (`name`)
947 ### Data of table `0_item_units` ###
949 INSERT INTO `0_item_units` VALUES ('ea.', 'Each', '0', '0');
950 INSERT INTO `0_item_units` VALUES ('hrs', 'Hours', '1', '0');
953 ### Structure of table `0_loc_stock` ###
955 DROP TABLE IF EXISTS `0_loc_stock`;
957 CREATE TABLE `0_loc_stock` (
958 `loc_code` char(5) NOT NULL default '',
959 `stock_id` char(20) NOT NULL default '',
960 `reorder_level` bigint(20) NOT NULL default '0',
961 PRIMARY KEY (`loc_code`,`stock_id`),
962 KEY `stock_id` (`stock_id`)
966 ### Data of table `0_loc_stock` ###
968 INSERT INTO `0_loc_stock` VALUES ('DEF', '102', '0');
969 INSERT INTO `0_loc_stock` VALUES ('DEF', '103', '0');
970 INSERT INTO `0_loc_stock` VALUES ('DEF', '104', '0');
971 INSERT INTO `0_loc_stock` VALUES ('DEF', '201', '0');
972 INSERT INTO `0_loc_stock` VALUES ('DEF', '3400', '0');
975 ### Structure of table `0_locations` ###
977 DROP TABLE IF EXISTS `0_locations`;
979 CREATE TABLE `0_locations` (
980 `loc_code` varchar(5) NOT NULL default '',
981 `location_name` varchar(60) NOT NULL default '',
982 `delivery_address` tinytext NOT NULL,
983 `phone` varchar(30) NOT NULL default '',
984 `phone2` varchar(30) NOT NULL default '',
985 `fax` varchar(30) NOT NULL default '',
986 `email` varchar(100) NOT NULL default '',
987 `contact` varchar(30) NOT NULL default '',
988 `inactive` tinyint(1) NOT NULL default '0',
989 PRIMARY KEY (`loc_code`)
993 ### Data of table `0_locations` ###
995 INSERT INTO `0_locations` VALUES ('DEF', 'Default', 'Delivery 1\r\nDelivery 2\r\nDelivery 3', '', '', '', '', '', '0');
998 ### Structure of table `0_movement_types` ###
1000 DROP TABLE IF EXISTS `0_movement_types`;
1002 CREATE TABLE `0_movement_types` (
1003 `id` int(11) NOT NULL auto_increment,
1004 `name` varchar(60) NOT NULL default '',
1005 `inactive` tinyint(1) NOT NULL default '0',
1007 UNIQUE KEY `name` (`name`)
1008 ) TYPE=MyISAM AUTO_INCREMENT=2 ;
1011 ### Data of table `0_movement_types` ###
1013 INSERT INTO `0_movement_types` VALUES ('1', 'Adjustment', '0');
1016 ### Structure of table `0_payment_terms` ###
1018 DROP TABLE IF EXISTS `0_payment_terms`;
1020 CREATE TABLE `0_payment_terms` (
1021 `terms_indicator` int(11) NOT NULL auto_increment,
1022 `terms` char(80) NOT NULL default '',
1023 `days_before_due` smallint(6) NOT NULL default '0',
1024 `day_in_following_month` smallint(6) NOT NULL default '0',
1025 `inactive` tinyint(1) NOT NULL default '0',
1026 PRIMARY KEY (`terms_indicator`),
1027 UNIQUE KEY `terms` (`terms`)
1028 ) TYPE=MyISAM AUTO_INCREMENT=5 ;
1031 ### Data of table `0_payment_terms` ###
1033 INSERT INTO `0_payment_terms` VALUES ('1', 'Due 15th Of the Following Month', '0', '17', '0');
1034 INSERT INTO `0_payment_terms` VALUES ('2', 'Due By End Of The Following Month', '0', '30', '0');
1035 INSERT INTO `0_payment_terms` VALUES ('3', 'Payment due within 10 days', '10', '0', '0');
1036 INSERT INTO `0_payment_terms` VALUES ('4', 'Cash Only', '1', '0', '0');
1039 ### Structure of table `0_prices` ###
1041 DROP TABLE IF EXISTS `0_prices`;
1043 CREATE TABLE `0_prices` (
1044 `id` int(11) NOT NULL auto_increment,
1045 `stock_id` varchar(20) NOT NULL default '',
1046 `sales_type_id` int(11) NOT NULL default '0',
1047 `curr_abrev` char(3) NOT NULL default '',
1048 `price` double NOT NULL default '0',
1050 UNIQUE KEY `price` (`stock_id`,`sales_type_id`,`curr_abrev`)
1051 ) TYPE=MyISAM AUTO_INCREMENT=5 ;
1054 ### Data of table `0_prices` ###
1056 INSERT INTO `0_prices` VALUES ('1', '3400', '1', 'USD', '100');
1057 INSERT INTO `0_prices` VALUES ('2', '102', '1', 'USD', '50');
1058 INSERT INTO `0_prices` VALUES ('3', '103', '1', 'USD', '55');
1059 INSERT INTO `0_prices` VALUES ('4', '104', '1', 'USD', '60');
1062 ### Structure of table `0_print_profiles` ###
1064 DROP TABLE IF EXISTS `0_print_profiles`;
1066 CREATE TABLE `0_print_profiles` (
1067 `id` smallint(6) unsigned NOT NULL auto_increment,
1068 `profile` varchar(30) NOT NULL,
1069 `report` varchar(5) default NULL,
1070 `printer` tinyint(3) unsigned default NULL,
1072 UNIQUE KEY `profile` (`profile`,`report`)
1073 ) TYPE=MyISAM AUTO_INCREMENT=10 ;
1076 ### Data of table `0_print_profiles` ###
1078 INSERT INTO `0_print_profiles` VALUES ('1', 'Out of office', '', '0');
1079 INSERT INTO `0_print_profiles` VALUES ('2', 'Sales Department', '', '0');
1080 INSERT INTO `0_print_profiles` VALUES ('3', 'Central', '', '2');
1081 INSERT INTO `0_print_profiles` VALUES ('4', 'Sales Department', '104', '2');
1082 INSERT INTO `0_print_profiles` VALUES ('5', 'Sales Department', '105', '2');
1083 INSERT INTO `0_print_profiles` VALUES ('6', 'Sales Department', '107', '2');
1084 INSERT INTO `0_print_profiles` VALUES ('7', 'Sales Department', '109', '2');
1085 INSERT INTO `0_print_profiles` VALUES ('8', 'Sales Department', '110', '2');
1086 INSERT INTO `0_print_profiles` VALUES ('9', 'Sales Department', '201', '2');
1089 ### Structure of table `0_printers` ###
1091 DROP TABLE IF EXISTS `0_printers`;
1093 CREATE TABLE `0_printers` (
1094 `id` tinyint(3) unsigned NOT NULL auto_increment,
1095 `name` varchar(20) NOT NULL,
1096 `description` varchar(60) NOT NULL,
1097 `queue` varchar(20) NOT NULL,
1098 `host` varchar(40) NOT NULL,
1099 `port` smallint(11) unsigned NOT NULL,
1100 `timeout` tinyint(3) unsigned NOT NULL,
1102 UNIQUE KEY `name` (`name`)
1103 ) TYPE=MyISAM AUTO_INCREMENT=4 ;
1106 ### Data of table `0_printers` ###
1108 INSERT INTO `0_printers` VALUES ('1', 'QL500', 'Label printer', 'QL500', 'server', '127', '20');
1109 INSERT INTO `0_printers` VALUES ('2', 'Samsung', 'Main network printer', 'scx4521F', 'server', '515', '5');
1110 INSERT INTO `0_printers` VALUES ('3', 'Local', 'Local print server at user IP', 'lp', '', '515', '10');
1113 ### Structure of table `0_purch_data` ###
1115 DROP TABLE IF EXISTS `0_purch_data`;
1117 CREATE TABLE `0_purch_data` (
1118 `supplier_id` int(11) NOT NULL default '0',
1119 `stock_id` char(20) NOT NULL default '',
1120 `price` double NOT NULL default '0',
1121 `suppliers_uom` char(50) NOT NULL default '',
1122 `conversion_factor` double NOT NULL default '1',
1123 `supplier_description` char(50) NOT NULL default '',
1124 PRIMARY KEY (`supplier_id`,`stock_id`)
1128 ### Data of table `0_purch_data` ###
1130 INSERT INTO `0_purch_data` VALUES ('2', '102', '10', '', '1', '17inch VGA Monitor');
1131 INSERT INTO `0_purch_data` VALUES ('2', '103', '11', '', '1', '32MB VGA Card');
1132 INSERT INTO `0_purch_data` VALUES ('2', '104', '12', '', '1', '52x CD Drive');
1135 ### Structure of table `0_purch_order_details` ###
1137 DROP TABLE IF EXISTS `0_purch_order_details`;
1139 CREATE TABLE `0_purch_order_details` (
1140 `po_detail_item` int(11) NOT NULL auto_increment,
1141 `order_no` int(11) NOT NULL default '0',
1142 `item_code` varchar(20) NOT NULL default '',
1143 `description` tinytext,
1144 `delivery_date` date NOT NULL default '0000-00-00',
1145 `qty_invoiced` double NOT NULL default '0',
1146 `unit_price` double NOT NULL default '0',
1147 `act_price` double NOT NULL default '0',
1148 `std_cost_unit` double NOT NULL default '0',
1149 `quantity_ordered` double NOT NULL default '0',
1150 `quantity_received` double NOT NULL default '0',
1151 PRIMARY KEY (`po_detail_item`)
1152 ) TYPE=InnoDB AUTO_INCREMENT=6 ;
1155 ### Data of table `0_purch_order_details` ###
1157 INSERT INTO `0_purch_order_details` VALUES ('1', '1', '102', '17inch VGA Monitor', '2009-07-01', '100', '10', '10', '10', '100', '100');
1158 INSERT INTO `0_purch_order_details` VALUES ('2', '1', '103', '32MB VGA Card', '2009-07-01', '100', '11', '11', '11', '100', '100');
1159 INSERT INTO `0_purch_order_details` VALUES ('3', '1', '104', '52x CD Drive', '2009-07-01', '100', '12', '12', '12', '100', '100');
1160 INSERT INTO `0_purch_order_details` VALUES ('4', '2', '102', '17inch VGA Monitor', '2009-07-01', '0', '5', '0', '0', '1', '0');
1161 INSERT INTO `0_purch_order_details` VALUES ('5', '2', '103', '32MB VGA Card', '2009-07-01', '0', '5', '0', '0', '1', '0');
1164 ### Structure of table `0_purch_orders` ###
1166 DROP TABLE IF EXISTS `0_purch_orders`;
1168 CREATE TABLE `0_purch_orders` (
1169 `order_no` int(11) NOT NULL auto_increment,
1170 `supplier_id` int(11) NOT NULL default '0',
1171 `comments` tinytext,
1172 `ord_date` date NOT NULL default '0000-00-00',
1173 `reference` tinytext NOT NULL,
1174 `requisition_no` tinytext,
1175 `into_stock_location` varchar(5) NOT NULL default '',
1176 `delivery_address` tinytext NOT NULL,
1177 PRIMARY KEY (`order_no`)
1178 ) TYPE=InnoDB AUTO_INCREMENT=3 ;
1181 ### Data of table `0_purch_orders` ###
1183 INSERT INTO `0_purch_orders` VALUES ('1', '2', '', '2009-06-01', '1', '', 'DEF', 'Delivery 1\r\nDelivery 2\r\nDelivery 3');
1184 INSERT INTO `0_purch_orders` VALUES ('2', '3', '', '2009-06-21', '2', '', 'DEF', 'Delivery 1\r\nDelivery 2\r\nDelivery 3');
1187 ### Structure of table `0_quick_entries` ###
1189 DROP TABLE IF EXISTS `0_quick_entries`;
1191 CREATE TABLE `0_quick_entries` (
1192 `id` smallint(6) unsigned NOT NULL auto_increment,
1193 `type` tinyint(1) NOT NULL default '0',
1194 `description` varchar(60) NOT NULL,
1195 `base_amount` double NOT NULL default '0',
1196 `base_desc` varchar(60) default NULL,
1198 KEY `description` (`description`)
1199 ) TYPE=MyISAM AUTO_INCREMENT=4 ;
1202 ### Data of table `0_quick_entries` ###
1204 INSERT INTO `0_quick_entries` VALUES ('1', '1', 'Maintenance', '0', 'Amount');
1205 INSERT INTO `0_quick_entries` VALUES ('2', '4', 'Phone', '0', 'Amount');
1206 INSERT INTO `0_quick_entries` VALUES ('3', '2', 'Cash Sales', '0', 'Amount');
1209 ### Structure of table `0_quick_entry_lines` ###
1211 DROP TABLE IF EXISTS `0_quick_entry_lines`;
1213 CREATE TABLE `0_quick_entry_lines` (
1214 `id` smallint(6) unsigned NOT NULL auto_increment,
1215 `qid` smallint(6) unsigned NOT NULL,
1216 `amount` double default '0',
1217 `action` varchar(2) NOT NULL,
1218 `dest_id` varchar(11) NOT NULL,
1219 `dimension_id` smallint(6) unsigned default NULL,
1220 `dimension2_id` smallint(6) unsigned default NULL,
1223 ) TYPE=MyISAM AUTO_INCREMENT=8 ;
1226 ### Data of table `0_quick_entry_lines` ###
1228 INSERT INTO `0_quick_entry_lines` VALUES ('1', '1', '0', 't-', '1', '0', '0');
1229 INSERT INTO `0_quick_entry_lines` VALUES ('2', '2', '0', 't-', '1', '0', '0');
1230 INSERT INTO `0_quick_entry_lines` VALUES ('3', '3', '0', 't-', '1', '0', '0');
1231 INSERT INTO `0_quick_entry_lines` VALUES ('4', '3', '0', '=', '4010', '0', '0');
1232 INSERT INTO `0_quick_entry_lines` VALUES ('5', '1', '0', '=', '5765', '0', '0');
1233 INSERT INTO `0_quick_entry_lines` VALUES ('6', '2', '0', '=', '5780', '0', '0');
1236 ### Structure of table `0_recurrent_invoices` ###
1238 DROP TABLE IF EXISTS `0_recurrent_invoices`;
1240 CREATE TABLE `0_recurrent_invoices` (
1241 `id` smallint(6) unsigned NOT NULL auto_increment,
1242 `description` varchar(60) NOT NULL default '',
1243 `order_no` int(11) unsigned NOT NULL,
1244 `debtor_no` int(11) unsigned default NULL,
1245 `group_no` smallint(6) unsigned default NULL,
1246 `days` int(11) NOT NULL default '0',
1247 `monthly` int(11) NOT NULL default '0',
1248 `begin` date NOT NULL default '0000-00-00',
1249 `end` date NOT NULL default '0000-00-00',
1250 `last_sent` date NOT NULL default '0000-00-00',
1252 UNIQUE KEY `description` (`description`)
1253 ) TYPE=InnoDB AUTO_INCREMENT=1 ;
1256 ### Data of table `0_recurrent_invoices` ###
1260 ### Structure of table `0_refs` ###
1262 DROP TABLE IF EXISTS `0_refs`;
1264 CREATE TABLE `0_refs` (
1265 `id` int(11) NOT NULL default '0',
1266 `type` int(11) NOT NULL default '0',
1267 `reference` varchar(100) NOT NULL default '',
1268 PRIMARY KEY (`id`,`type`)
1272 ### Data of table `0_refs` ###
1274 INSERT INTO `0_refs` VALUES ('18', '0', '1');
1275 INSERT INTO `0_refs` VALUES ('19', '0', '2');
1278 ### Structure of table `0_sales_order_details` ###
1280 DROP TABLE IF EXISTS `0_sales_order_details`;
1282 CREATE TABLE `0_sales_order_details` (
1283 `id` int(11) NOT NULL auto_increment,
1284 `order_no` int(11) NOT NULL default '0',
1285 `trans_type` smallint(6) NOT NULL default '30',
1286 `stk_code` varchar(20) NOT NULL default '',
1287 `description` tinytext,
1288 `qty_sent` double NOT NULL default '0',
1289 `unit_price` double NOT NULL default '0',
1290 `quantity` double NOT NULL default '0',
1291 `discount_percent` double NOT NULL default '0',
1293 ) TYPE=InnoDB AUTO_INCREMENT=6 ;
1296 ### Data of table `0_sales_order_details` ###
1298 INSERT INTO `0_sales_order_details` VALUES ('1', '1', '30', '102', '17inch VGA Monitor', '2', '30.4', '2', '0');
1299 INSERT INTO `0_sales_order_details` VALUES ('2', '2', '30', '102', '17inch VGA Monitor', '1', '50', '1', '0');
1300 INSERT INTO `0_sales_order_details` VALUES ('3', '3', '30', '102', '17inch VGA Monitor', '1', '35.89', '1', '0');
1301 INSERT INTO `0_sales_order_details` VALUES ('4', '4', '30', '102', '17inch VGA Monitor', '0', '21.28', '2', '0');
1302 INSERT INTO `0_sales_order_details` VALUES ('5', '5', '30', '102', '17inch VGA Monitor', '1', '50', '1', '0');
1305 ### Structure of table `0_sales_orders` ###
1307 DROP TABLE IF EXISTS `0_sales_orders`;
1309 CREATE TABLE `0_sales_orders` (
1310 `order_no` int(11) NOT NULL,
1311 `trans_type` smallint(6) NOT NULL default '30',
1312 `version` tinyint(1) unsigned NOT NULL default '0',
1313 `type` tinyint(1) NOT NULL default '0',
1314 `debtor_no` int(11) NOT NULL default '0',
1315 `branch_code` int(11) NOT NULL default '0',
1316 `reference` varchar(100) NOT NULL default '',
1317 `customer_ref` tinytext NOT NULL,
1318 `comments` tinytext,
1319 `ord_date` date NOT NULL default '0000-00-00',
1320 `order_type` int(11) NOT NULL default '0',
1321 `ship_via` int(11) NOT NULL default '0',
1322 `delivery_address` tinytext NOT NULL,
1323 `contact_phone` varchar(30) default NULL,
1324 `contact_email` varchar(100) default NULL,
1325 `deliver_to` tinytext NOT NULL,
1326 `freight_cost` double NOT NULL default '0',
1327 `from_stk_loc` varchar(5) NOT NULL default '',
1328 `delivery_date` date NOT NULL default '0000-00-00',
1329 PRIMARY KEY (`trans_type`, `order_no`)
1332 ### Data of table `0_sales_orders` ###
1334 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');
1335 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');
1336 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');
1337 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');
1338 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');
1341 ### Structure of table `0_sales_pos` ###
1343 DROP TABLE IF EXISTS `0_sales_pos`;
1345 CREATE TABLE `0_sales_pos` (
1346 `id` smallint(6) unsigned NOT NULL auto_increment,
1347 `pos_name` varchar(30) NOT NULL,
1348 `cash_sale` tinyint(1) NOT NULL,
1349 `credit_sale` tinyint(1) NOT NULL,
1350 `pos_location` varchar(5) NOT NULL,
1351 `pos_account` smallint(6) unsigned NOT NULL,
1352 `inactive` tinyint(1) NOT NULL default '0',
1354 UNIQUE KEY `pos_name` (`pos_name`)
1355 ) TYPE=MyISAM AUTO_INCREMENT=2 ;
1358 ### Data of table `0_sales_pos` ###
1360 INSERT INTO `0_sales_pos` VALUES ('1', 'Default', '1', '1', 'DEF', '2', '0');
1363 ### Structure of table `0_sales_types` ###
1365 DROP TABLE IF EXISTS `0_sales_types`;
1367 CREATE TABLE `0_sales_types` (
1368 `id` int(11) NOT NULL auto_increment,
1369 `sales_type` char(50) NOT NULL default '',
1370 `tax_included` int(1) NOT NULL default '0',
1371 `factor` double NOT NULL default '1',
1372 `inactive` tinyint(1) NOT NULL default '0',
1374 UNIQUE KEY `sales_type` (`sales_type`)
1375 ) TYPE=MyISAM AUTO_INCREMENT=3 ;
1378 ### Data of table `0_sales_types` ###
1380 INSERT INTO `0_sales_types` VALUES ('1', 'Retail', '1', '1', '0');
1381 INSERT INTO `0_sales_types` VALUES ('2', 'Wholesale', '0', '0.7', '0');
1384 ### Structure of table `0_salesman` ###
1386 DROP TABLE IF EXISTS `0_salesman`;
1388 CREATE TABLE `0_salesman` (
1389 `salesman_code` int(11) NOT NULL auto_increment,
1390 `salesman_name` char(60) NOT NULL default '',
1391 `salesman_phone` char(30) NOT NULL default '',
1392 `salesman_fax` char(30) NOT NULL default '',
1393 `salesman_email` varchar(100) NOT NULL default '',
1394 `provision` double NOT NULL default '0',
1395 `break_pt` double NOT NULL default '0',
1396 `provision2` double NOT NULL default '0',
1397 `inactive` tinyint(1) NOT NULL default '0',
1398 PRIMARY KEY (`salesman_code`),
1399 UNIQUE KEY `salesman_name` (`salesman_name`)
1400 ) TYPE=MyISAM AUTO_INCREMENT=2 ;
1403 ### Data of table `0_salesman` ###
1405 INSERT INTO `0_salesman` VALUES ('1', 'Sales Person', '', '', '', '5', '1000', '4', '0');
1407 ### Structure of table `0_security_roles` ###
1409 DROP TABLE IF EXISTS `0_security_roles`;
1410 CREATE TABLE IF NOT EXISTS `0_security_roles` (
1411 `id` int(11) NOT NULL auto_increment,
1412 `role` varchar(30) NOT NULL,
1413 `description` varchar(50) default NULL,
1416 `inactive` tinyint(1) NOT NULL default '0',
1418 UNIQUE KEY `role` (`role`)
1419 ) TYPE=MyISAM AUTO_INCREMENT=11 ;
1422 -- Data of table `0_security_roles`
1425 INSERT INTO `0_security_roles` VALUES (1, 'Inquiries', 'Inquiries', '768;2816;3072;3328;5632;5888;8192;8448;10752;11008;13312;15872;16128', '257;258;259;260;513;514;515;516;517;518;519;520;521;522;523;524;525;773;774;2822;3073;3075;3076;3077;3329;3330;3331;3332;3333;3334;3335;5377;5633;5640;5889;5890;5891;7937;7938;7939;7940;8193;8194;8450;8451;10497;10753;11009;11010;11012;13313;13315;15617;15618;15619;15620;15621;15622;15623;15624;15625;15626;15873;15882;16129;16130;16131;16132', 0);
1426 INSERT INTO `0_security_roles` VALUES (2, 'System Administrator', 'System Administrator', '256;512;768;2816;3072;3328;5376;5632;5888;7936;8192;8448;10496;10752;11008;13056;13312;15616;15872;16128', '257;258;259;260;513;514;515;516;517;518;519;520;521;522;523;524;525;769;770;771;772;773;774;2817;2818;2819;2820;2821;2822;2823;3073;3074;3082;3075;3076;3077;3078;3079;3080;3081;3329;3330;3331;3332;3333;3334;3335;5377;5633;5634;5635;5636;5637;5641;5638;5639;5640;5889;5890;5891;7937;7938;7939;7940;8193;8194;8195;8196;8197;8449;8450;8451;10497;10753;10754;10755;10756;10757;11009;11010;11012;13057;13313;13314;13315;15617;15618;15619;15620;15621;15622;15623;15624;15625;15626;15627;15873;15874;15875;15876;15877;15878;15879;15880;15883;15881;15882;16129;16130;16131;16132', 0);
1427 INSERT INTO `0_security_roles` VALUES (3, 'Salesman', 'Salesman', '768;3072;5632;8192;15872', '773;774;3073;3075;3081;5633;8194;15873', 0);
1428 INSERT INTO `0_security_roles` VALUES (4, 'Stock Manager', 'Stock Manager', '2816;3072;3328;5632;5888;8192;8448;10752;11008;13312;15872;16128', '2818;2822;3073;3076;3077;3329;3330;3330;3330;3331;3331;3332;3333;3334;3335;5633;5640;5889;5890;5891;8193;8194;8450;8451;10753;11009;11010;11012;13313;13315;15882;16129;16130;16131;16132', 0);
1429 INSERT INTO `0_security_roles` VALUES (5, 'Production Manager', 'Production Manager', '512;2816;3072;3328;5632;5888;8192;8448;10752;11008;13312;15616;15872;16128', '521;523;524;2818;2819;2820;2821;2822;2823;3073;3074;3076;3077;3078;3079;3080;3081;3329;3330;3330;3330;3331;3331;3332;3333;3334;3335;5633;5640;5640;5889;5890;5891;8193;8194;8196;8197;8450;8451;10753;10755;11009;11010;11012;13313;13315;15617;15619;15620;15621;15624;15624;15876;15877;15880;15882;16129;16130;16131;16132', 0);
1430 INSERT INTO `0_security_roles` VALUES (6, 'Purchase Officer', 'Purchase Officer', '512;2816;3072;3328;5376;5632;5888;8192;8448;10752;11008;13312;15616;15872;16128', '521;523;524;2818;2819;2820;2821;2822;2823;3073;3074;3076;3077;3078;3079;3080;3081;3329;3330;3330;3330;3331;3331;3332;3333;3334;3335;5377;5633;5635;5640;5640;5889;5890;5891;8193;8194;8196;8197;8449;8450;8451;10753;10755;11009;11010;11012;13313;13315;15617;15619;15620;15621;15624;15624;15876;15877;15880;15882;16129;16130;16131;16132', 0);
1431 INSERT INTO `0_security_roles` VALUES (7, 'AR Officer', 'AR Officer', '512;768;2816;3072;3328;5632;5888;8192;8448;10752;11008;13312;15616;15872;16128', '521;523;524;771;773;774;2818;2819;2820;2821;2822;2823;3073;3073;3074;3075;3076;3077;3078;3079;3080;3081;3081;3329;3330;3330;3330;3331;3331;3332;3333;3334;3335;5633;5633;5634;5637;5638;5639;5640;5640;5889;5890;5891;8193;8194;8194;8196;8197;8450;8451;10753;10755;11009;11010;11012;13313;13315;15617;15619;15620;15621;15624;15624;15873;15876;15877;15878;15880;15882;16129;16130;16131;16132', 0);
1432 INSERT INTO `0_security_roles` VALUES (8, 'AP Officer', 'AP Officer', '512;2816;3072;3328;5376;5632;5888;8192;8448;10752;11008;13312;15616;15872;16128', '257;258;259;260;521;523;524;769;770;771;772;773;774;2818;2819;2820;2821;2822;2823;3073;3074;3082;3076;3077;3078;3079;3080;3081;3329;3330;3331;3332;3333;3334;3335;5377;5633;5635;5640;5889;5890;5891;7937;7938;7939;7940;8193;8194;8196;8197;8449;8450;8451;10497;10753;10755;11009;11010;11012;13057;13313;13315;15617;15619;15620;15621;15624;15876;15877;15880;15882;16129;16130;16131;16132', 0);
1433 INSERT INTO `0_security_roles` VALUES (9, 'Accountant', 'New Accountant', '512;768;2816;3072;3328;5376;5632;5888;8192;8448;10752;11008;13312;15616;15872;16128', '257;258;259;260;521;523;524;771;772;773;774;2818;2819;2820;2821;2822;2823;3073;3074;3075;3076;3077;3078;3079;3080;3081;3329;3330;3331;3332;3333;3334;3335;5377;5633;5634;5635;5637;5638;5639;5640;5889;5890;5891;7937;7938;7939;7940;8193;8194;8196;8197;8449;8450;8451;10497;10753;10755;11009;11010;11012;13313;13315;15617;15618;15619;15620;15621;15624;15873;15876;15877;15878;15880;15882;16129;16130;16131;16132', 0);
1434 INSERT INTO `0_security_roles` VALUES (10, 'Sub Admin', 'Sub Admin', '512;768;2816;3072;3328;5376;5632;5888;8192;8448;10752;11008;13312;15616;15872;16128', '257;258;259;260;521;523;524;771;772;773;774;2818;2819;2820;2821;2822;2823;3073;3074;3082;3075;3076;3077;3078;3079;3080;3081;3329;3330;3331;3332;3333;3334;3335;5377;5633;5634;5635;5637;5638;5639;5640;5889;5890;5891;7937;7938;7939;7940;8193;8194;8196;8197;8449;8450;8451;10497;10753;10755;11009;11010;11012;13057;13313;13315;15617;15619;15620;15621;15624;15873;15874;15876;15877;15878;15879;15880;15882;16129;16130;16131;16132', 0);
1436 ### Structure of table `0_shippers` ###
1438 DROP TABLE IF EXISTS `0_shippers`;
1440 CREATE TABLE `0_shippers` (
1441 `shipper_id` int(11) NOT NULL auto_increment,
1442 `shipper_name` varchar(60) NOT NULL default '',
1443 `phone` varchar(30) NOT NULL default '',
1444 `phone2` varchar(30) NOT NULL default '',
1445 `contact` tinytext NOT NULL,
1446 `address` tinytext NOT NULL,
1447 `inactive` tinyint(1) NOT NULL default '0',
1448 PRIMARY KEY (`shipper_id`),
1449 UNIQUE KEY `name` (`shipper_name`)
1450 ) TYPE=MyISAM AUTO_INCREMENT=2 ;
1453 ### Data of table `0_shippers` ###
1455 INSERT INTO `0_shippers` VALUES ('1', 'Default', '', '', '', '', '0');
1458 ### Structure of table `0_sql_trail` ###
1460 DROP TABLE IF EXISTS `0_sql_trail`;
1462 CREATE TABLE `0_sql_trail` (
1463 `id` int(11) unsigned NOT NULL auto_increment,
1464 `sql` text NOT NULL,
1465 `result` tinyint(1) NOT NULL,
1466 `msg` varchar(255) NOT NULL,
1468 ) TYPE=MyISAM AUTO_INCREMENT=1 ;
1471 ### Data of table `0_sql_trail` ###
1475 ### Structure of table `0_stock_category` ###
1477 DROP TABLE IF EXISTS `0_stock_category`;
1479 CREATE TABLE `0_stock_category` (
1480 `category_id` int(11) NOT NULL auto_increment,
1481 `description` varchar(60) NOT NULL default '',
1482 `dflt_tax_type` int(11) NOT NULL default '1',
1483 `dflt_units` varchar(20) NOT NULL default 'each',
1484 `dflt_mb_flag` char(1) NOT NULL default 'B',
1485 `dflt_sales_act` varchar(11) NOT NULL default '',
1486 `dflt_cogs_act` varchar(11) NOT NULL default '',
1487 `dflt_inventory_act` varchar(11) NOT NULL default '',
1488 `dflt_adjustment_act` varchar(11) NOT NULL default '',
1489 `dflt_assembly_act` varchar(11) NOT NULL default '',
1490 `dflt_dim1` int(11) default NULL,
1491 `dflt_dim2` int(11) default NULL,
1492 `inactive` tinyint(1) NOT NULL default '0',
1493 `dflt_no_sale` tinyint(1) NOT NULL default '0',
1494 PRIMARY KEY (`category_id`),
1495 UNIQUE KEY `description` (`description`)
1496 ) TYPE=MyISAM AUTO_INCREMENT=5 ;
1498 ### Data of table `0_stock_category` ###
1500 INSERT INTO `0_stock_category` VALUES ('1', 'Components', '1', 'each', 'B', '4010', '5010', '1510', '5040', '1530', '0', '0', '0', '0');
1501 INSERT INTO `0_stock_category` VALUES ('2', 'Charges', '1', 'each', 'D', '4010', '5010', '1510', '5040', '1530', '0', '0', '0', '0');
1502 INSERT INTO `0_stock_category` VALUES ('3', 'Systems', '1', 'each', 'M', '4010', '5010', '1510', '5040', '1530', '0', '0', '0', '0');
1503 INSERT INTO `0_stock_category` VALUES ('4', 'Services', '1', 'hrs', 'D', '4010', '5010', '1510', '5040', '1530', '0', '0', '0', '0');
1506 ### Structure of table `0_stock_master` ###
1508 DROP TABLE IF EXISTS `0_stock_master`;
1510 CREATE TABLE `0_stock_master` (
1511 `stock_id` varchar(20) NOT NULL default '',
1512 `category_id` int(11) NOT NULL default '0',
1513 `tax_type_id` int(11) NOT NULL default '0',
1514 `description` varchar(200) NOT NULL default '',
1515 `long_description` tinytext NOT NULL,
1516 `units` varchar(20) NOT NULL default 'each',
1517 `mb_flag` char(1) NOT NULL default 'B',
1518 `sales_account` varchar(11) NOT NULL default '',
1519 `cogs_account` varchar(11) NOT NULL default '',
1520 `inventory_account` varchar(11) NOT NULL default '',
1521 `adjustment_account` varchar(11) NOT NULL default '',
1522 `assembly_account` varchar(11) NOT NULL default '',
1523 `dimension_id` int(11) default NULL,
1524 `dimension2_id` int(11) default NULL,
1525 `actual_cost` double NOT NULL default '0',
1526 `last_cost` double NOT NULL default '0',
1527 `material_cost` double NOT NULL default '0',
1528 `labour_cost` double NOT NULL default '0',
1529 `overhead_cost` double NOT NULL default '0',
1530 `inactive` tinyint(1) NOT NULL default '0',
1531 `no_sale` tinyint(1) NOT NULL default '0',
1532 PRIMARY KEY (`stock_id`)
1536 ### Data of table `0_stock_master` ###
1538 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');
1539 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');
1540 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');
1541 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');
1542 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');
1545 ### Structure of table `0_stock_moves` ###
1547 DROP TABLE IF EXISTS `0_stock_moves`;
1549 CREATE TABLE `0_stock_moves` (
1550 `trans_id` int(11) NOT NULL auto_increment,
1551 `trans_no` int(11) NOT NULL default '0',
1552 `stock_id` char(20) NOT NULL default '',
1553 `type` smallint(6) NOT NULL default '0',
1554 `loc_code` char(5) NOT NULL default '',
1555 `tran_date` date NOT NULL default '0000-00-00',
1556 `person_id` int(11) default NULL,
1557 `price` double NOT NULL default '0',
1558 `reference` char(40) NOT NULL default '',
1559 `qty` double NOT NULL default '1',
1560 `discount_percent` double NOT NULL default '0',
1561 `standard_cost` double NOT NULL default '0',
1562 `visible` tinyint(1) NOT NULL default '1',
1563 PRIMARY KEY (`trans_id`),
1564 KEY `type` (`type`,`trans_no`)
1565 ) TYPE=InnoDB AUTO_INCREMENT=37 ;
1568 ### Data of table `0_stock_moves` ###
1570 INSERT INTO `0_stock_moves` VALUES ('1', '1', '102', '25', 'DEF', '2009-06-21', '2', '10', '', '100', '0', '10', '1');
1571 INSERT INTO `0_stock_moves` VALUES ('2', '1', '103', '25', 'DEF', '2009-06-21', '2', '11', '', '100', '0', '11', '1');
1572 INSERT INTO `0_stock_moves` VALUES ('3', '1', '104', '25', 'DEF', '2009-06-21', '2', '12', '', '100', '0', '12', '1');
1573 INSERT INTO `0_stock_moves` VALUES ('4', '1', '102', '26', 'DEF', '2009-06-21', '0', '0', '1', '-10', '0', '0', '1');
1574 INSERT INTO `0_stock_moves` VALUES ('5', '1', '103', '26', 'DEF', '2009-06-21', '0', '0', '1', '-10', '0', '0', '1');
1575 INSERT INTO `0_stock_moves` VALUES ('6', '1', '104', '26', 'DEF', '2009-06-21', '0', '0', '1', '-10', '0', '0', '1');
1576 INSERT INTO `0_stock_moves` VALUES ('7', '1', '3400', '26', 'DEF', '2009-06-21', '0', '0', '1', '10', '0', '0', '1');
1577 INSERT INTO `0_stock_moves` VALUES ('8', '2', '102', '13', 'DEF', '2009-06-21', '0', '30.4', '1', '-2', '0', '10', '1');
1578 INSERT INTO `0_stock_moves` VALUES ('9', '3', '102', '13', 'DEF', '2009-06-21', '0', '50', 'auto', '-1', '0', '10', '1');
1579 INSERT INTO `0_stock_moves` VALUES ('10', '4', '102', '13', 'DEF', '2009-06-21', '0', '35.89', 'auto', '-1', '0', '10', '1');
1580 INSERT INTO `0_stock_moves` VALUES ('11', '3', '102', '26', 'DEF', '2009-06-21', '0', '0', '3', '-2', '0', '0', '1');
1581 INSERT INTO `0_stock_moves` VALUES ('12', '3', '103', '26', 'DEF', '2009-06-21', '0', '0', '3', '-2', '0', '0', '1');
1582 INSERT INTO `0_stock_moves` VALUES ('13', '3', '104', '26', 'DEF', '2009-06-21', '0', '0', '3', '-2', '0', '0', '1');
1583 INSERT INTO `0_stock_moves` VALUES ('14', '3', '3400', '26', 'DEF', '2009-06-21', '0', '0', '3', '2', '0', '0', '1');
1584 INSERT INTO `0_stock_moves` VALUES ('15', '4', '102', '26', 'DEF', '2009-06-21', '0', '0', '4', '-4', '0', '0', '1');
1585 INSERT INTO `0_stock_moves` VALUES ('16', '4', '103', '26', 'DEF', '2009-06-21', '0', '0', '4', '-4', '0', '0', '1');
1586 INSERT INTO `0_stock_moves` VALUES ('17', '4', '104', '26', 'DEF', '2009-06-21', '0', '0', '4', '-4', '0', '0', '1');
1587 INSERT INTO `0_stock_moves` VALUES ('18', '4', '3400', '26', 'DEF', '2009-06-21', '0', '0', '4', '4', '0', '0', '1');
1588 INSERT INTO `0_stock_moves` VALUES ('19', '2', '102', '26', 'DEF', '2009-06-21', '0', '0', '', '-2', '0', '0', '1');
1589 INSERT INTO `0_stock_moves` VALUES ('20', '2', '103', '26', 'DEF', '2009-06-21', '0', '0', '', '-2', '0', '0', '1');
1590 INSERT INTO `0_stock_moves` VALUES ('21', '2', '104', '26', 'DEF', '2009-06-21', '0', '0', '', '-2', '0', '0', '1');
1591 INSERT INTO `0_stock_moves` VALUES ('22', '1', '3400', '29', 'DEF', '2009-06-21', '0', '0', '', '2', '0', '0', '1');
1592 INSERT INTO `0_stock_moves` VALUES ('23', '5', '102', '26', 'DEF', '2009-06-21', '0', '0', '5', '-5', '0', '0', '1');
1593 INSERT INTO `0_stock_moves` VALUES ('24', '5', '103', '26', 'DEF', '2009-06-21', '0', '0', '5', '-5', '0', '0', '1');
1594 INSERT INTO `0_stock_moves` VALUES ('25', '5', '104', '26', 'DEF', '2009-06-21', '0', '0', '5', '-5', '0', '0', '1');
1595 INSERT INTO `0_stock_moves` VALUES ('26', '5', '3400', '26', 'DEF', '2009-06-21', '0', '0', '5', '5', '0', '0', '1');
1596 INSERT INTO `0_stock_moves` VALUES ('27', '6', '102', '26', 'DEF', '2009-06-21', '0', '0', '6', '5', '0', '0', '1');
1597 INSERT INTO `0_stock_moves` VALUES ('28', '6', '103', '26', 'DEF', '2009-06-21', '0', '0', '6', '5', '0', '0', '1');
1598 INSERT INTO `0_stock_moves` VALUES ('29', '6', '104', '26', 'DEF', '2009-06-21', '0', '0', '6', '5', '0', '0', '1');
1599 INSERT INTO `0_stock_moves` VALUES ('30', '6', '3400', '26', 'DEF', '2009-06-21', '0', '0', '6', '-5', '0', '0', '1');
1600 INSERT INTO `0_stock_moves` VALUES ('31', '7', '102', '26', 'DEF', '2009-06-21', '0', '0', '7', '2', '0', '0', '1');
1601 INSERT INTO `0_stock_moves` VALUES ('32', '7', '103', '26', 'DEF', '2009-06-21', '0', '0', '7', '2', '0', '0', '1');
1602 INSERT INTO `0_stock_moves` VALUES ('33', '7', '104', '26', 'DEF', '2009-06-21', '0', '0', '7', '2', '0', '0', '1');
1603 INSERT INTO `0_stock_moves` VALUES ('34', '7', '3400', '26', 'DEF', '2009-06-21', '0', '0', '7', '-2', '0', '0', '1');
1604 INSERT INTO `0_stock_moves` VALUES ('35', '5', '102', '13', 'DEF', '2009-06-21', '0', '50', 'auto', '-1', '0', '10', '1');
1605 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');
1608 ### Structure of table `0_supp_allocations` ###
1610 DROP TABLE IF EXISTS `0_supp_allocations`;
1612 CREATE TABLE `0_supp_allocations` (
1613 `id` int(11) NOT NULL auto_increment,
1614 `amt` double unsigned default NULL,
1615 `date_alloc` date NOT NULL default '0000-00-00',
1616 `trans_no_from` int(11) default NULL,
1617 `trans_type_from` int(11) default NULL,
1618 `trans_no_to` int(11) default NULL,
1619 `trans_type_to` int(11) default NULL,
1621 ) TYPE=InnoDB AUTO_INCREMENT=2 ;
1624 ### Data of table `0_supp_allocations` ###
1626 INSERT INTO `0_supp_allocations` VALUES ('1', '3465', '2009-06-21', '4', '22', '7', '20');
1629 ### Structure of table `0_supp_invoice_items` ###
1631 DROP TABLE IF EXISTS `0_supp_invoice_items`;
1633 CREATE TABLE `0_supp_invoice_items` (
1634 `id` int(11) NOT NULL auto_increment,
1635 `supp_trans_no` int(11) default NULL,
1636 `supp_trans_type` int(11) default NULL,
1637 `gl_code` varchar(11) NOT NULL default '0',
1638 `grn_item_id` int(11) default NULL,
1639 `po_detail_item_id` int(11) default NULL,
1640 `stock_id` varchar(20) NOT NULL default '',
1641 `description` tinytext,
1642 `quantity` double NOT NULL default '0',
1643 `unit_price` double NOT NULL default '0',
1644 `unit_tax` double NOT NULL default '0',
1647 ) TYPE=InnoDB AUTO_INCREMENT=6 ;
1650 ### Data of table `0_supp_invoice_items` ###
1652 INSERT INTO `0_supp_invoice_items` VALUES ('1', '7', '20', '0', '1', '1', '102', '17inch VGA Monitor', '100', '10', '0.5', '');
1653 INSERT INTO `0_supp_invoice_items` VALUES ('2', '7', '20', '0', '2', '2', '103', '32MB VGA Card', '100', '11', '0.55', '');
1654 INSERT INTO `0_supp_invoice_items` VALUES ('3', '7', '20', '0', '3', '3', '104', '52x CD Drive', '100', '12', '0.6', '');
1655 INSERT INTO `0_supp_invoice_items` VALUES ('4', '8', '20', '2150', '0', '0', '', '', '0', '0.95', '0', 'Phone');
1656 INSERT INTO `0_supp_invoice_items` VALUES ('5', '8', '20', '5780', '0', '0', '', '', '0', '19.05', '0', 'Phone');
1659 ### Structure of table `0_supp_trans` ###
1661 DROP TABLE IF EXISTS `0_supp_trans`;
1663 CREATE TABLE `0_supp_trans` (
1664 `trans_no` int(11) unsigned NOT NULL default '0',
1665 `type` smallint(6) unsigned NOT NULL default '0',
1666 `supplier_id` int(11) unsigned default NULL,
1667 `reference` tinytext NOT NULL,
1668 `supp_reference` varchar(60) NOT NULL default '',
1669 `tran_date` date NOT NULL default '0000-00-00',
1670 `due_date` date NOT NULL default '0000-00-00',
1671 `ov_amount` double NOT NULL default '0',
1672 `ov_discount` double NOT NULL default '0',
1673 `ov_gst` double NOT NULL default '0',
1674 `rate` double NOT NULL default '1',
1675 `alloc` double NOT NULL default '0',
1676 PRIMARY KEY (`trans_no`,`type`),
1677 KEY `supplier_id` (`supplier_id`),
1678 KEY `SupplierID_2` (`supplier_id`,`supp_reference`),
1683 ### Data of table `0_supp_trans` ###
1685 INSERT INTO `0_supp_trans` VALUES ('4', '22', '2', '1', '', '2009-06-21', '2009-06-21', '-3465', '0', '0', '1', '3465');
1686 INSERT INTO `0_supp_trans` VALUES ('7', '20', '2', '1', '5t', '2009-06-21', '2009-07-01', '3300', '0', '165', '1', '3465');
1687 INSERT INTO `0_supp_trans` VALUES ('8', '20', '2', '2', 'cc', '2009-06-21', '2009-07-01', '20', '0', '0', '1', '0');
1690 ### Structure of table `0_suppliers` ###
1692 DROP TABLE IF EXISTS `0_suppliers`;
1694 CREATE TABLE `0_suppliers` (
1695 `supplier_id` int(11) NOT NULL auto_increment,
1696 `supp_name` varchar(60) NOT NULL default '',
1697 `supp_ref` varchar(30) NOT NULL default '',
1698 `address` tinytext NOT NULL,
1699 `supp_address` tinytext NOT NULL,
1700 `phone` varchar(30) NOT NULL default '',
1701 `phone2` varchar(30) NOT NULL default '',
1702 `fax` varchar(30) NOT NULL default '',
1703 `gst_no` varchar(25) NOT NULL default '',
1704 `contact` varchar(60) NOT NULL default '',
1705 `supp_account_no` varchar(40) NOT NULL default '',
1706 `email` varchar(100) NOT NULL default '',
1707 `website` varchar(100) NOT NULL default '',
1708 `bank_account` varchar(60) NOT NULL default '',
1709 `curr_code` char(3) default NULL,
1710 `payment_terms` int(11) default NULL,
1711 `dimension_id` int(11) default '0',
1712 `dimension2_id` int(11) default '0',
1713 `tax_group_id` int(11) default NULL,
1714 `credit_limit` double NOT NULL default '0',
1715 `purchase_account` varchar(11) default NULL,
1716 `payable_account` varchar(11) default NULL,
1717 `payment_discount_account` varchar(11) default NULL,
1718 `notes` tinytext NOT NULL,
1719 `inactive` tinyint(1) NOT NULL default '0',
1720 PRIMARY KEY (`supplier_id`)
1721 ) TYPE=MyISAM AUTO_INCREMENT=4 ;
1724 ### Data of table `0_suppliers` ###
1726 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');
1727 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');
1728 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');
1731 ### Structure of table `0_sys_types` ###
1733 DROP TABLE IF EXISTS `0_sys_types`;
1735 CREATE TABLE `0_sys_types` (
1736 `type_id` smallint(6) NOT NULL default '0',
1737 `type_no` int(11) NOT NULL default '1',
1738 `next_reference` varchar(100) NOT NULL default '',
1739 PRIMARY KEY (`type_id`)
1743 ### Data of table `0_sys_types` ###
1745 INSERT INTO `0_sys_types` VALUES ('0', '19', '3');
1746 INSERT INTO `0_sys_types` VALUES ('1', '8', '2');
1747 INSERT INTO `0_sys_types` VALUES ('2', '5', '2');
1748 INSERT INTO `0_sys_types` VALUES ('4', '3', '1');
1749 INSERT INTO `0_sys_types` VALUES ('10', '19', '4');
1750 INSERT INTO `0_sys_types` VALUES ('11', '3', '2');
1751 INSERT INTO `0_sys_types` VALUES ('12', '6', '1');
1752 INSERT INTO `0_sys_types` VALUES ('13', '5', '2');
1753 INSERT INTO `0_sys_types` VALUES ('16', '2', '1');
1754 INSERT INTO `0_sys_types` VALUES ('17', '2', '1');
1755 INSERT INTO `0_sys_types` VALUES ('18', '1', '3');
1756 INSERT INTO `0_sys_types` VALUES ('20', '8', '3');
1757 INSERT INTO `0_sys_types` VALUES ('21', '1', '1');
1758 INSERT INTO `0_sys_types` VALUES ('22', '4', '2');
1759 INSERT INTO `0_sys_types` VALUES ('25', '1', '2');
1760 INSERT INTO `0_sys_types` VALUES ('26', '1', '8');
1761 INSERT INTO `0_sys_types` VALUES ('28', '1', '1');
1762 INSERT INTO `0_sys_types` VALUES ('29', '1', '2');
1763 INSERT INTO `0_sys_types` VALUES ('30', '5', '6');
1764 INSERT INTO `0_sys_types` VALUES ('32', '0', '1');
1765 INSERT INTO `0_sys_types` VALUES ('35', '1', '1');
1766 INSERT INTO `0_sys_types` VALUES ('40', '1', '3');
1769 ### Structure of table `0_tax_group_items` ###
1771 DROP TABLE IF EXISTS `0_tax_group_items`;
1773 CREATE TABLE `0_tax_group_items` (
1774 `tax_group_id` int(11) NOT NULL default '0',
1775 `tax_type_id` int(11) NOT NULL default '0',
1776 `rate` double NOT NULL default '0',
1777 PRIMARY KEY (`tax_group_id`,`tax_type_id`)
1781 ### Data of table `0_tax_group_items` ###
1783 INSERT INTO `0_tax_group_items` VALUES ('1', '1', '5');
1786 ### Structure of table `0_tax_groups` ###
1788 DROP TABLE IF EXISTS `0_tax_groups`;
1790 CREATE TABLE `0_tax_groups` (
1791 `id` int(11) NOT NULL auto_increment,
1792 `name` varchar(60) NOT NULL default '',
1793 `tax_shipping` tinyint(1) NOT NULL default '0',
1794 `inactive` tinyint(1) NOT NULL default '0',
1796 UNIQUE KEY `name` (`name`)
1797 ) TYPE=InnoDB AUTO_INCREMENT=3 ;
1800 ### Data of table `0_tax_groups` ###
1802 INSERT INTO `0_tax_groups` VALUES ('1', 'Tax', '0', '0');
1803 INSERT INTO `0_tax_groups` VALUES ('2', 'Tax Exempt', '0', '0');
1805 ### Structure of table `0_tax_types` ###
1807 DROP TABLE IF EXISTS `0_tax_types`;
1809 CREATE TABLE `0_tax_types` (
1810 `id` int(11) NOT NULL auto_increment,
1811 `rate` double NOT NULL default '0',
1812 `sales_gl_code` varchar(11) NOT NULL default '',
1813 `purchasing_gl_code` varchar(11) NOT NULL default '',
1814 `name` varchar(60) NOT NULL default '',
1815 `inactive` tinyint(1) NOT NULL default '0',
1817 ) TYPE=InnoDB AUTO_INCREMENT=5 AUTO_INCREMENT=5 ;
1820 ### Data of table `0_tax_types` ###
1822 INSERT INTO `0_tax_types` VALUES ('1', '5', '2150', '2145', 'Tax', '0');
1824 ### Structure of table `0_trans_tax_details` ###
1826 DROP TABLE IF EXISTS `0_trans_tax_details`;
1828 CREATE TABLE `0_trans_tax_details` (
1829 `id` int(11) NOT NULL auto_increment,
1830 `trans_type` smallint(6) default NULL,
1831 `trans_no` int(11) default NULL,
1832 `tran_date` date NOT NULL,
1833 `tax_type_id` int(11) NOT NULL default '0',
1834 `rate` double NOT NULL default '0',
1835 `ex_rate` double NOT NULL default '1',
1836 `included_in_price` tinyint(1) NOT NULL default '0',
1837 `net_amount` double NOT NULL default '0',
1838 `amount` double NOT NULL default '0',
1841 ) TYPE=InnoDB AUTO_INCREMENT=12 ;
1844 ### Data of table `0_trans_tax_details` ###
1846 INSERT INTO `0_trans_tax_details` VALUES ('1', '20', '7', '2009-06-21', '1', '5', '1', '0', '3300', '165', '5t');
1847 INSERT INTO `0_trans_tax_details` VALUES ('2', '13', '3', '2009-06-21', '1', '5', '1', '0', '50', '2.5', 'auto');
1848 INSERT INTO `0_trans_tax_details` VALUES ('3', '10', '17', '2009-06-21', '1', '5', '1', '0', '50', '2.5', '1');
1849 INSERT INTO `0_trans_tax_details` VALUES ('4', '13', '4', '2009-06-21', '1', '5', '1.3932', '0', '35.89', '1.7945', 'auto');
1850 INSERT INTO `0_trans_tax_details` VALUES ('5', '10', '18', '2009-06-21', '1', '5', '1.3932', '0', '35.89', '1.7945', '2');
1851 INSERT INTO `0_trans_tax_details` VALUES ('6', '2', '5', '2009-06-21', '1', '5', '1', '0', '95.2', '4.76', '');
1852 INSERT INTO `0_trans_tax_details` VALUES ('7', '1', '8', '2009-06-21', '1', '5', '1', '0', '-47.6', '-2.38', '');
1853 INSERT INTO `0_trans_tax_details` VALUES ('8', '20', '8', '2009-06-21', '1', '5', '1', '0', '-19', '-0.95', 'cc');
1854 INSERT INTO `0_trans_tax_details` VALUES ('9', '13', '5', '2009-06-21', '1', '5', '1', '1', '47.619047619048', '2.3809523809524', 'auto');
1855 INSERT INTO `0_trans_tax_details` VALUES ('10', '10', '19', '2009-06-21', '1', '5', '1', '1', '47.619047619048', '2.3809523809524', '3');
1856 INSERT INTO `0_trans_tax_details` VALUES ('11', '11', '3', '2009-06-21', '1', '5', '1.3932', '0', '35.89', '1.7945', '1');
1858 ### Structure of table `0_users` ###
1860 DROP TABLE IF EXISTS `0_users`;
1862 CREATE TABLE `0_users` (
1863 `id` SMALLINT(6) AUTO_INCREMENT,
1864 `user_id` varchar(60) NOT NULL default '',
1865 `password` varchar(100) NOT NULL default '',
1866 `real_name` varchar(100) NOT NULL default '',
1867 `role_id` int(11) NOT NULL default '1',
1868 `phone` varchar(30) NOT NULL default '',
1869 `email` varchar(100) default NULL,
1870 `language` varchar(20) default NULL,
1871 `date_format` tinyint(1) NOT NULL default '0',
1872 `date_sep` tinyint(1) NOT NULL default '0',
1873 `tho_sep` tinyint(1) NOT NULL default '0',
1874 `dec_sep` tinyint(1) NOT NULL default '0',
1875 `theme` varchar(20) NOT NULL default 'default',
1876 `page_size` varchar(20) NOT NULL default 'A4',
1877 `prices_dec` smallint(6) NOT NULL default '2',
1878 `qty_dec` smallint(6) NOT NULL default '2',
1879 `rates_dec` smallint(6) NOT NULL default '4',
1880 `percent_dec` smallint(6) NOT NULL default '1',
1881 `show_gl` tinyint(1) NOT NULL default '1',
1882 `show_codes` tinyint(1) NOT NULL default '0',
1883 `show_hints` tinyint(1) NOT NULL default '0',
1884 `last_visit_date` datetime default NULL,
1885 `query_size` tinyint(1) default '10',
1886 `graphic_links` tinyint(1) default '1',
1887 `pos` smallint(6) default '1',
1888 `print_profile` varchar(30) NOT NULL default '1',
1889 `rep_popup` tinyint(1) default '1',
1890 `sticky_doc_date` tinyint(1) default '0',
1891 `startup_tab` varchar(20) NOT NULL default '',
1892 `inactive` tinyint(1) NOT NULL default '0',
1894 UNIQUE KEY (`user_id`)
1895 ) TYPE=MyISAM AUTO_INCREMENT=2;
1898 ### Data of table `0_users` ###
1900 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');
1901 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');
1903 ### Structure of table `0_voided` ###
1905 DROP TABLE IF EXISTS `0_voided`;
1907 CREATE TABLE `0_voided` (
1908 `type` int(11) NOT NULL default '0',
1909 `id` int(11) NOT NULL default '0',
1910 `date_` date NOT NULL default '0000-00-00',
1911 `memo_` tinytext NOT NULL,
1912 UNIQUE KEY `id` (`type`,`id`)
1916 ### Data of table `0_voided` ###
1920 ### Structure of table `0_wo_issue_items` ###
1922 DROP TABLE IF EXISTS `0_wo_issue_items`;
1924 CREATE TABLE `0_wo_issue_items` (
1925 `id` int(11) NOT NULL auto_increment,
1926 `stock_id` varchar(40) default NULL,
1927 `issue_id` int(11) default NULL,
1928 `qty_issued` double default NULL,
1930 ) TYPE=InnoDB AUTO_INCREMENT=1 ;
1933 ### Data of table `0_wo_issue_items` ###
1937 ### Structure of table `0_wo_issues` ###
1939 DROP TABLE IF EXISTS `0_wo_issues`;
1941 CREATE TABLE `0_wo_issues` (
1942 `issue_no` int(11) NOT NULL auto_increment,
1943 `workorder_id` int(11) NOT NULL default '0',
1944 `reference` varchar(100) default NULL,
1945 `issue_date` date default NULL,
1946 `loc_code` varchar(5) default NULL,
1947 `workcentre_id` int(11) default NULL,
1948 PRIMARY KEY (`issue_no`)
1949 ) TYPE=InnoDB AUTO_INCREMENT=1 ;
1952 ### Data of table `0_wo_issues` ###
1956 ### Structure of table `0_wo_manufacture` ###
1958 DROP TABLE IF EXISTS `0_wo_manufacture`;
1960 CREATE TABLE `0_wo_manufacture` (
1961 `id` int(11) NOT NULL auto_increment,
1962 `reference` varchar(100) default NULL,
1963 `workorder_id` int(11) NOT NULL default '0',
1964 `quantity` double NOT NULL default '0',
1965 `date_` date NOT NULL default '0000-00-00',
1967 ) TYPE=InnoDB AUTO_INCREMENT=2 ;
1970 ### Data of table `0_wo_manufacture` ###
1972 INSERT INTO `0_wo_manufacture` VALUES ('1', '1', '2', '2', '2009-06-21');
1975 ### Structure of table `0_wo_requirements` ###
1977 DROP TABLE IF EXISTS `0_wo_requirements`;
1979 CREATE TABLE `0_wo_requirements` (
1980 `id` int(11) NOT NULL auto_increment,
1981 `workorder_id` int(11) NOT NULL default '0',
1982 `stock_id` char(20) NOT NULL default '',
1983 `workcentre` int(11) NOT NULL default '0',
1984 `units_req` double NOT NULL default '1',
1985 `std_cost` double NOT NULL default '0',
1986 `loc_code` char(5) NOT NULL default '',
1987 `units_issued` double NOT NULL default '0',
1989 ) TYPE=InnoDB AUTO_INCREMENT=22 ;
1992 ### Data of table `0_wo_requirements` ###
1994 INSERT INTO `0_wo_requirements` VALUES ('1', '1', '102', '1', '1', '0', 'DEF', '10');
1995 INSERT INTO `0_wo_requirements` VALUES ('2', '1', '103', '1', '1', '0', 'DEF', '10');
1996 INSERT INTO `0_wo_requirements` VALUES ('3', '1', '104', '1', '1', '0', 'DEF', '10');
1997 INSERT INTO `0_wo_requirements` VALUES ('4', '2', '102', '1', '1', '0', 'DEF', '0');
1998 INSERT INTO `0_wo_requirements` VALUES ('5', '2', '103', '1', '1', '0', 'DEF', '0');
1999 INSERT INTO `0_wo_requirements` VALUES ('6', '2', '104', '1', '1', '0', 'DEF', '0');
2000 INSERT INTO `0_wo_requirements` VALUES ('7', '3', '102', '1', '1', '0', 'DEF', '2');
2001 INSERT INTO `0_wo_requirements` VALUES ('8', '3', '103', '1', '1', '0', 'DEF', '2');
2002 INSERT INTO `0_wo_requirements` VALUES ('9', '3', '104', '1', '1', '0', 'DEF', '2');
2003 INSERT INTO `0_wo_requirements` VALUES ('10', '4', '102', '1', '1', '0', 'DEF', '4');
2004 INSERT INTO `0_wo_requirements` VALUES ('11', '4', '103', '1', '1', '0', 'DEF', '4');
2005 INSERT INTO `0_wo_requirements` VALUES ('12', '4', '104', '1', '1', '0', 'DEF', '4');
2006 INSERT INTO `0_wo_requirements` VALUES ('13', '5', '102', '1', '1', '0', 'DEF', '5');
2007 INSERT INTO `0_wo_requirements` VALUES ('14', '5', '103', '1', '1', '0', 'DEF', '5');
2008 INSERT INTO `0_wo_requirements` VALUES ('15', '5', '104', '1', '1', '0', 'DEF', '5');
2009 INSERT INTO `0_wo_requirements` VALUES ('16', '6', '102', '1', '1', '0', 'DEF', '-5');
2010 INSERT INTO `0_wo_requirements` VALUES ('17', '6', '103', '1', '1', '0', 'DEF', '-5');
2011 INSERT INTO `0_wo_requirements` VALUES ('18', '6', '104', '1', '1', '0', 'DEF', '-5');
2012 INSERT INTO `0_wo_requirements` VALUES ('19', '7', '102', '1', '1', '0', 'DEF', '-2');
2013 INSERT INTO `0_wo_requirements` VALUES ('20', '7', '103', '1', '1', '0', 'DEF', '-2');
2014 INSERT INTO `0_wo_requirements` VALUES ('21', '7', '104', '1', '1', '0', 'DEF', '-2');
2017 ### Structure of table `0_workcentres` ###
2019 DROP TABLE IF EXISTS `0_workcentres`;
2021 CREATE TABLE `0_workcentres` (
2022 `id` int(11) NOT NULL auto_increment,
2023 `name` char(40) NOT NULL default '',
2024 `description` char(50) NOT NULL default '',
2025 `inactive` tinyint(1) NOT NULL default '0',
2027 UNIQUE KEY `name` (`name`)
2028 ) TYPE=MyISAM AUTO_INCREMENT=2 ;
2031 ### Data of table `0_workcentres` ###
2033 INSERT INTO `0_workcentres` VALUES ('1', 'Workshop', 'Workshop in Alabama', '0');
2036 ### Structure of table `0_workorders` ###
2038 DROP TABLE IF EXISTS `0_workorders`;
2040 CREATE TABLE `0_workorders` (
2041 `id` int(11) NOT NULL auto_increment,
2042 `wo_ref` varchar(60) NOT NULL default '',
2043 `loc_code` varchar(5) NOT NULL default '',
2044 `units_reqd` double NOT NULL default '1',
2045 `stock_id` varchar(20) NOT NULL default '',
2046 `date_` date NOT NULL default '0000-00-00',
2047 `type` tinyint(4) NOT NULL default '0',
2048 `required_by` date NOT NULL default '0000-00-00',
2049 `released_date` date NOT NULL default '0000-00-00',
2050 `units_issued` double NOT NULL default '0',
2051 `closed` tinyint(1) NOT NULL default '0',
2052 `released` tinyint(1) NOT NULL default '0',
2053 `additional_costs` double NOT NULL default '0',
2055 UNIQUE KEY `wo_ref` (`wo_ref`)
2056 ) TYPE=InnoDB AUTO_INCREMENT=8 ;
2059 ### Data of table `0_workorders` ###
2061 INSERT INTO `0_workorders` VALUES ('1', '1', 'DEF', '10', '3400', '2009-06-21', '0', '2009-06-21', '2009-06-21', '10', '1', '1', '10');
2062 INSERT INTO `0_workorders` VALUES ('2', '2', 'DEF', '3', '3400', '2009-06-21', '2', '2009-07-11', '2009-06-21', '2', '0', '1', '0');
2063 INSERT INTO `0_workorders` VALUES ('3', '3', 'DEF', '2', '3400', '2009-06-21', '0', '2009-06-21', '2009-06-21', '2', '1', '1', '0');
2064 INSERT INTO `0_workorders` VALUES ('4', '4', 'DEF', '4', '3400', '2009-06-21', '0', '2009-06-21', '2009-06-21', '4', '1', '1', '0');
2065 INSERT INTO `0_workorders` VALUES ('5', '5', 'DEF', '5', '3400', '2009-06-21', '0', '2009-06-21', '2009-06-21', '5', '1', '1', '10');
2066 INSERT INTO `0_workorders` VALUES ('6', '6', 'DEF', '-5', '3400', '2009-06-21', '1', '2009-06-21', '2009-06-21', '-5', '1', '1', '0');
2067 INSERT INTO `0_workorders` VALUES ('7', '7', 'DEF', '-2', '3400', '2009-06-21', '1', '2009-06-21', '2009-06-21', '-2', '1', '1', '10');
2070 ### Structure of table `0_tags` ###
2072 DROP TABLE IF EXISTS `0_tags`;
2074 CREATE TABLE `0_tags` (
2075 `id` int(11) NOT NULL auto_increment,
2076 `type` smallint(6) NOT NULL,
2077 `name` varchar(30) NOT NULL,
2078 `description` varchar(60) default NULL,
2079 `inactive` tinyint(1) NOT NULL default '0',
2081 UNIQUE KEY(`type`,`name`)
2082 ) TYPE=MyISAM AUTO_INCREMENT=1;
2085 ### Data of table `0_chart_tags` ###
2089 ### Structure of table `0_tag_associations` ###
2091 DROP TABLE IF EXISTS `0_tag_associations`;
2093 CREATE TABLE `0_tag_associations` (
2094 `record_id` varchar(11) NOT NULL,
2095 `tag_id` int(11) NOT NULL,
2096 UNIQUE KEY(`record_id`,`tag_id`)
2100 ### Data of table `0_tag_associations` ###
2102 DROP TABLE IF EXISTS `0_useronline` ;
2104 CREATE TABLE `0_useronline` (
2105 `id` int(11) NOT NULL AUTO_INCREMENT ,
2106 `timestamp` int(15) NOT NULL default '0',
2107 `ip` varchar(40) NOT NULL default '',
2108 `file` varchar(100) NOT NULL default '',
2109 PRIMARY KEY `id` (`id`) ,
2111 ) TYPE=MYISAM AUTO_INCREMENT=1;