1 # Built by FrontAccounting 2.1.2
2 # http://frontaccounting.net
3 # Company: Training Co.
8 ### Structure of table `0_areas` ###
10 DROP TABLE IF EXISTS `0_areas`;
12 CREATE TABLE `0_areas` (
13 `area_code` int(11) NOT NULL auto_increment,
14 `description` varchar(60) NOT NULL default '',
15 `inactive` tinyint(1) NOT NULL default '0',
16 PRIMARY KEY (`area_code`),
17 UNIQUE KEY `description` (`description`)
18 ) TYPE=MyISAM AUTO_INCREMENT=2 ;
21 ### Data of table `0_areas` ###
23 INSERT INTO `0_areas` VALUES ('1', 'Global', '0');
26 ### Structure of table `0_attachments` ###
28 DROP TABLE IF EXISTS `0_attachments`;
30 CREATE TABLE `0_attachments` (
31 `id` int(11) unsigned NOT NULL auto_increment,
32 `description` varchar(60) NOT NULL default '',
33 `type_no` int(11) NOT NULL default '0',
34 `trans_no` int(11) NOT NULL default '0',
35 `unique_name` varchar(60) NOT NULL default '',
36 `tran_date` date NOT NULL default '0000-00-00',
37 `filename` varchar(60) NOT NULL default '',
38 `filesize` int(11) NOT NULL default '0',
39 `filetype` varchar(60) NOT NULL default '',
41 KEY `type_no` (`type_no`,`trans_no`)
42 ) TYPE=MyISAM AUTO_INCREMENT=1 ;
45 ### Data of table `0_attachments` ###
47 ### Structure of table `0_audit_trail` ###
49 DROP TABLE IF EXISTS `0_audit_trail`;
51 CREATE TABLE `0_audit_trail` (
52 `id` int(11) NOT NULL AUTO_INCREMENT,
53 `type` smallint(6) unsigned NOT NULL default '0',
54 `trans_no` int(11) unsigned NOT NULL default '0',
55 `user` smallint(6) unsigned NOT NULL default '0',
56 `stamp` timestamp NOT NULL,
57 `description` varchar(60) default NULL,
58 `fiscal_year` int(11) NOT NULL,
59 `gl_date` date NOT NULL default '0000-00-00',
60 `gl_seq` int(11) unsigned default NULL,
62 KEY (`fiscal_year`, `gl_seq`)
65 ### Data of table `0_audit_trail` ###
71 ### Structure of table `0_bank_accounts` ###
73 DROP TABLE IF EXISTS `0_bank_accounts`;
75 CREATE TABLE `0_bank_accounts` (
76 `account_code` varchar(11) NOT NULL default '',
77 `account_type` smallint(6) NOT NULL default '0',
78 `bank_account_name` varchar(60) NOT NULL default '',
79 `bank_account_number` varchar(100) NOT NULL default '',
80 `bank_name` varchar(60) NOT NULL default '',
81 `bank_address` tinytext,
82 `bank_curr_code` char(3) NOT NULL default '',
83 `dflt_curr_act` TINYINT(1) NOT NULL default '0',
84 `id` smallint(6) NOT NULL auto_increment,
85 `last_reconciled_date` timestamp NOT NULL default '0000-00-00 00:00:00',
86 `ending_reconcile_balance` double NOT NULL default '0',
87 `inactive` tinyint(1) NOT NULL default '0',
89 KEY `bank_account_name` (`bank_account_name`),
90 KEY `bank_account_number` (`bank_account_number`)
91 ) TYPE=MyISAM AUTO_INCREMENT=3 ;
94 ### Data of table `0_bank_accounts` ###
96 INSERT INTO `0_bank_accounts` VALUES ('1060', '0', 'Current account', '9999999999', 'Wachovia Bank', '', 'USD', '1', '1', '0000-00-00 00:00:00', '0', '0');
97 INSERT INTO `0_bank_accounts` VALUES ('1065', '3', 'Petty Cash account', 'N/A', 'N/A', '', 'USD', '0', '2', '0000-00-00 00:00:00', '0', '0');
100 ### Structure of table `0_bank_trans` ###
102 DROP TABLE IF EXISTS `0_bank_trans`;
104 CREATE TABLE `0_bank_trans` (
105 `id` int(11) NOT NULL auto_increment,
106 `type` smallint(6) default NULL,
107 `trans_no` int(11) default NULL,
108 `bank_act` varchar(11) default NULL,
109 `ref` varchar(40) default NULL,
110 `trans_date` date NOT NULL default '0000-00-00',
111 `amount` double default NULL,
112 `dimension_id` int(11) NOT NULL default '0',
113 `dimension2_id` int(11) NOT NULL default '0',
114 `person_type_id` int(11) NOT NULL default '0',
115 `person_id` tinyblob,
116 `reconciled` date default NULL,
118 KEY `bank_act` (`bank_act`,`ref`),
119 KEY `type` (`type`,`trans_no`)
120 ) TYPE=InnoDB AUTO_INCREMENT=12 ;
123 ### Data of table `0_bank_trans` ###
125 INSERT INTO `0_bank_trans` VALUES ('1', '22', '4', '1', '1', '2009-06-21', '-3465', '0', '0', '3', '2', '');
126 INSERT INTO `0_bank_trans` VALUES ('2', '26', '1', '1', '', '2009-06-21', '-10', '0', '0', '1', '1', '');
127 INSERT INTO `0_bank_trans` VALUES ('3', '26', '1', '1', '', '2009-06-21', '-20', '0', '0', '1', '0', '');
128 INSERT INTO `0_bank_trans` VALUES ('4', '0', '18', '1', '1', '2009-02-20', '1000', '0', '0', '0', '', '');
129 INSERT INTO `0_bank_trans` VALUES ('5', '0', '19', '1', '2', '2009-02-21', '4000', '0', '0', '0', '', '');
130 INSERT INTO `0_bank_trans` VALUES ('6', '2', '5', '1', '1', '2009-06-21', '100', '0', '0', '4', '3', '');
131 INSERT INTO `0_bank_trans` VALUES ('7', '1', '8', '1', '1', '2009-06-21', '-50', '0', '0', '4', '1', '');
132 INSERT INTO `0_bank_trans` VALUES ('8', '26', '5', '1', '', '2009-06-21', '-10', '0', '0', '1', '1', '');
133 INSERT INTO `0_bank_trans` VALUES ('9', '26', '5', '1', '', '2009-06-21', '-20', '0', '0', '1', '0', '');
134 INSERT INTO `0_bank_trans` VALUES ('10', '26', '7', '1', '', '2009-06-21', '-10', '0', '0', '1', '1', '');
135 INSERT INTO `0_bank_trans` VALUES ('11', '26', '7', '1', '', '2009-06-21', '-20', '0', '0', '1', '0', '');
138 ### Structure of table `0_bom` ###
140 DROP TABLE IF EXISTS `0_bom`;
142 CREATE TABLE `0_bom` (
143 `id` int(11) NOT NULL auto_increment,
144 `parent` char(20) NOT NULL default '',
145 `component` char(20) NOT NULL default '',
146 `workcentre_added` int(11) NOT NULL default '0',
147 `loc_code` char(5) NOT NULL default '',
148 `quantity` double NOT NULL default '1',
149 PRIMARY KEY (`parent`,`component`,`workcentre_added`,`loc_code`),
150 KEY `component` (`component`),
152 KEY `loc_code` (`loc_code`),
153 KEY `parent` (`parent`,`loc_code`),
154 KEY `Parent_2` (`parent`),
155 KEY `workcentre_added` (`workcentre_added`)
156 ) TYPE=MyISAM AUTO_INCREMENT=4 ;
159 ### Data of table `0_bom` ###
161 INSERT INTO `0_bom` VALUES ('1', '3400', '102', '1', 'DEF', '1');
162 INSERT INTO `0_bom` VALUES ('2', '3400', '103', '1', 'DEF', '1');
163 INSERT INTO `0_bom` VALUES ('3', '3400', '104', '1', 'DEF', '1');
166 ### Structure of table `0_budget_trans` ###
168 DROP TABLE IF EXISTS `0_budget_trans`;
170 CREATE TABLE `0_budget_trans` (
171 `counter` int(11) NOT NULL auto_increment,
172 `type` smallint(6) NOT NULL default '0',
173 `type_no` bigint(16) NOT NULL default '1',
174 `tran_date` date NOT NULL default '0000-00-00',
175 `account` varchar(11) NOT NULL default '',
176 `memo_` tinytext NOT NULL,
177 `amount` double NOT NULL default '0',
178 `dimension_id` int(11) default '0',
179 `dimension2_id` int(11) default '0',
180 `person_type_id` int(11) default NULL,
181 `person_id` tinyblob,
182 PRIMARY KEY (`counter`),
183 KEY `Type_and_Number` (`type`,`type_no`)
184 ) TYPE=InnoDB AUTO_INCREMENT=1 ;
187 ### Data of table `0_budget_trans` ###
191 ### Structure of table `0_chart_class` ###
193 DROP TABLE IF EXISTS `0_chart_class`;
195 CREATE TABLE `0_chart_class` (
196 `cid` int(11) NOT NULL default '0',
197 `class_name` varchar(60) NOT NULL default '',
198 `ctype` tinyint(1) NOT NULL default '0',
199 `inactive` tinyint(1) NOT NULL default '0',
204 ### Data of table `0_chart_class` ###
206 INSERT INTO `0_chart_class` VALUES ('1', 'Assets', '1', '0');
207 INSERT INTO `0_chart_class` VALUES ('2', 'Liabilities', '2', '0');
208 INSERT INTO `0_chart_class` VALUES ('3', 'Income', '4', '0');
209 INSERT INTO `0_chart_class` VALUES ('4', 'Costs', '6', '0');
212 ### Structure of table `0_chart_master` ###
214 DROP TABLE IF EXISTS `0_chart_master`;
216 CREATE TABLE `0_chart_master` (
217 `account_code` varchar(11) NOT NULL default '',
218 `account_code2` varchar(11) default '',
219 `account_name` varchar(60) NOT NULL default '',
220 `account_type` int(11) NOT NULL default '0',
221 `inactive` tinyint(1) NOT NULL default '0',
222 PRIMARY KEY (`account_code`),
223 KEY `account_code` (`account_code`),
224 KEY `account_name` (`account_name`)
228 ### Data of table `0_chart_master` ###
230 INSERT INTO `0_chart_master` VALUES ('1060', '', 'Checking Account', '1', '0');
231 INSERT INTO `0_chart_master` VALUES ('1065', '', 'Petty Cash', '1', '0');
232 INSERT INTO `0_chart_master` VALUES ('1200', '', 'Accounts Receivables', '1', '0');
233 INSERT INTO `0_chart_master` VALUES ('1205', '', 'Allowance for doubtful accounts', '1', '0');
234 INSERT INTO `0_chart_master` VALUES ('1510', '', 'Inventory', '2', '0');
235 INSERT INTO `0_chart_master` VALUES ('1520', '', 'Stocks of Raw Materials', '2', '0');
236 INSERT INTO `0_chart_master` VALUES ('1530', '', 'Stocks of Work In Progress', '2', '0');
237 INSERT INTO `0_chart_master` VALUES ('1540', '', 'Stocks of Finsihed Goods', '2', '0');
238 INSERT INTO `0_chart_master` VALUES ('1550', '', 'Goods Received Clearing account', '2', '0');
239 INSERT INTO `0_chart_master` VALUES ('1820', '', 'Office Furniture & Equipment', '3', '0');
240 INSERT INTO `0_chart_master` VALUES ('1825', '', 'Accum. Amort. -Furn. & Equip.', '3', '0');
241 INSERT INTO `0_chart_master` VALUES ('1840', '', 'Vehicle', '3', '0');
242 INSERT INTO `0_chart_master` VALUES ('1845', '', 'Accum. Amort. -Vehicle', '3', '0');
243 INSERT INTO `0_chart_master` VALUES ('2100', '', 'Accounts Payable', '4', '0');
244 INSERT INTO `0_chart_master` VALUES ('2110', '', 'Accrued Income Tax - Federal', '4', '0');
245 INSERT INTO `0_chart_master` VALUES ('2120', '', 'Accrued Income Tax - State', '4', '0');
246 INSERT INTO `0_chart_master` VALUES ('2130', '', 'Accrued Franchise Tax', '4', '0');
247 INSERT INTO `0_chart_master` VALUES ('2140', '', 'Accrued Real & Personal Prop Tax', '4', '0');
248 INSERT INTO `0_chart_master` VALUES ('2150', '', 'Sales Tax', '4', '0');
249 INSERT INTO `0_chart_master` VALUES ('2160', '', 'Accrued Use Tax Payable', '4', '0');
250 INSERT INTO `0_chart_master` VALUES ('2210', '', 'Accrued Wages', '4', '0');
251 INSERT INTO `0_chart_master` VALUES ('2220', '', 'Accrued Comp Time', '4', '0');
252 INSERT INTO `0_chart_master` VALUES ('2230', '', 'Accrued Holiday Pay', '4', '0');
253 INSERT INTO `0_chart_master` VALUES ('2240', '', 'Accrued Vacation Pay', '4', '0');
254 INSERT INTO `0_chart_master` VALUES ('2310', '', 'Accr. Benefits - 401K', '4', '0');
255 INSERT INTO `0_chart_master` VALUES ('2320', '', 'Accr. Benefits - Stock Purchase', '4', '0');
256 INSERT INTO `0_chart_master` VALUES ('2330', '', 'Accr. Benefits - Med, Den', '4', '0');
257 INSERT INTO `0_chart_master` VALUES ('2340', '', 'Accr. Benefits - Payroll Taxes', '4', '0');
258 INSERT INTO `0_chart_master` VALUES ('2350', '', 'Accr. Benefits - Credit Union', '4', '0');
259 INSERT INTO `0_chart_master` VALUES ('2360', '', 'Accr. Benefits - Savings Bond', '4', '0');
260 INSERT INTO `0_chart_master` VALUES ('2370', '', 'Accr. Benefits - Garnish', '4', '0');
261 INSERT INTO `0_chart_master` VALUES ('2380', '', 'Accr. Benefits - Charity Cont.', '4', '0');
262 INSERT INTO `0_chart_master` VALUES ('2620', '', 'Bank Loans', '5', '0');
263 INSERT INTO `0_chart_master` VALUES ('2680', '', 'Loans from Shareholders', '5', '0');
264 INSERT INTO `0_chart_master` VALUES ('3350', '', 'Common Shares', '6', '0');
265 INSERT INTO `0_chart_master` VALUES ('3590', '', 'Retained Earnings - prior years', '7', '0');
266 INSERT INTO `0_chart_master` VALUES ('4010', '', 'Sales', '8', '0');
267 INSERT INTO `0_chart_master` VALUES ('4430', '', 'Shipping & Handling', '9', '0');
268 INSERT INTO `0_chart_master` VALUES ('4440', '', 'Interest', '9', '0');
269 INSERT INTO `0_chart_master` VALUES ('4450', '', 'Foreign Exchange Gain', '9', '0');
270 INSERT INTO `0_chart_master` VALUES ('4500', '', 'Prompt Payment Discounts', '9', '0');
271 INSERT INTO `0_chart_master` VALUES ('4510', '', 'Discounts Given', '9', '0');
272 INSERT INTO `0_chart_master` VALUES ('5010', '', 'Cost of Goods Sold - Retail', '10', '0');
273 INSERT INTO `0_chart_master` VALUES ('5020', '', 'Material Usage Varaiance', '10', '0');
274 INSERT INTO `0_chart_master` VALUES ('5030', '', 'Consumable Materials', '10', '0');
275 INSERT INTO `0_chart_master` VALUES ('5040', '', 'Purchase price Variance', '10', '0');
276 INSERT INTO `0_chart_master` VALUES ('5050', '', 'Purchases of materials', '10', '0');
277 INSERT INTO `0_chart_master` VALUES ('5060', '', 'Discounts Received', '10', '0');
278 INSERT INTO `0_chart_master` VALUES ('5100', '', 'Freight', '10', '0');
279 INSERT INTO `0_chart_master` VALUES ('5410', '', 'Wages & Salaries', '11', '0');
280 INSERT INTO `0_chart_master` VALUES ('5420', '', 'Wages - Overtime', '11', '0');
281 INSERT INTO `0_chart_master` VALUES ('5430', '', 'Benefits - Comp Time', '11', '0');
282 INSERT INTO `0_chart_master` VALUES ('5440', '', 'Benefits - Payroll Taxes', '11', '0');
283 INSERT INTO `0_chart_master` VALUES ('5450', '', 'Benefits - Workers Comp', '11', '0');
284 INSERT INTO `0_chart_master` VALUES ('5460', '', 'Benefits - Pension', '11', '0');
285 INSERT INTO `0_chart_master` VALUES ('5470', '', 'Benefits - General Benefits', '11', '0');
286 INSERT INTO `0_chart_master` VALUES ('5510', '', 'Inc Tax Exp - Federal', '11', '0');
287 INSERT INTO `0_chart_master` VALUES ('5520', '', 'Inc Tax Exp - State', '11', '0');
288 INSERT INTO `0_chart_master` VALUES ('5530', '', 'Taxes - Real Estate', '11', '0');
289 INSERT INTO `0_chart_master` VALUES ('5540', '', 'Taxes - Personal Property', '11', '0');
290 INSERT INTO `0_chart_master` VALUES ('5550', '', 'Taxes - Franchise', '11', '0');
291 INSERT INTO `0_chart_master` VALUES ('5560', '', 'Taxes - Foreign Withholding', '11', '0');
292 INSERT INTO `0_chart_master` VALUES ('5610', '', 'Accounting & Legal', '12', '0');
293 INSERT INTO `0_chart_master` VALUES ('5615', '', 'Advertising & Promotions', '12', '0');
294 INSERT INTO `0_chart_master` VALUES ('5620', '', 'Bad Debts', '12', '0');
295 INSERT INTO `0_chart_master` VALUES ('5660', '', 'Amortization Expense', '12', '0');
296 INSERT INTO `0_chart_master` VALUES ('5685', '', 'Insurance', '12', '0');
297 INSERT INTO `0_chart_master` VALUES ('5690', '', 'Interest & Bank Charges', '12', '0');
298 INSERT INTO `0_chart_master` VALUES ('5700', '', 'Office Supplies', '12', '0');
299 INSERT INTO `0_chart_master` VALUES ('5760', '', 'Rent', '12', '0');
300 INSERT INTO `0_chart_master` VALUES ('5765', '', 'Repair & Maintenance', '12', '0');
301 INSERT INTO `0_chart_master` VALUES ('5780', '', 'Telephone', '12', '0');
302 INSERT INTO `0_chart_master` VALUES ('5785', '', 'Travel & Entertainment', '12', '0');
303 INSERT INTO `0_chart_master` VALUES ('5790', '', 'Utilities', '12', '0');
304 INSERT INTO `0_chart_master` VALUES ('5795', '', 'Registrations', '12', '0');
305 INSERT INTO `0_chart_master` VALUES ('5800', '', 'Licenses', '12', '0');
306 INSERT INTO `0_chart_master` VALUES ('5810', '', 'Foreign Exchange Loss', '12', '0');
307 INSERT INTO `0_chart_master` VALUES ('9990', '', 'Year Profit/Loss', '12', '0');
309 ### Structure of table `0_chart_types` ###
311 DROP TABLE IF EXISTS `0_chart_types`;
313 CREATE TABLE `0_chart_types` (
314 `id` int(11) NOT NULL auto_increment,
315 `name` varchar(60) NOT NULL default '',
316 `class_id` tinyint(1) NOT NULL default '0',
317 `parent` int(11) NOT NULL default '-1',
318 `inactive` tinyint(1) NOT NULL default '0',
321 ) TYPE=MyISAM AUTO_INCREMENT=13 ;
324 ### Data of table `0_chart_types` ###
326 INSERT INTO `0_chart_types` VALUES ('1', 'Current Assets', '1', '-1', '0');
327 INSERT INTO `0_chart_types` VALUES ('2', 'Inventory Assets', '1', '-1', '0');
328 INSERT INTO `0_chart_types` VALUES ('3', 'Capital Assets', '1', '-1', '0');
329 INSERT INTO `0_chart_types` VALUES ('4', 'Current Liabilities', '2', '-1', '0');
330 INSERT INTO `0_chart_types` VALUES ('5', 'Long Term Liabilities', '2', '-1', '0');
331 INSERT INTO `0_chart_types` VALUES ('6', 'Share Capital', '2', '-1', '0');
332 INSERT INTO `0_chart_types` VALUES ('7', 'Retained Earnings', '2', '-1', '0');
333 INSERT INTO `0_chart_types` VALUES ('8', 'Sales Revenue', '3', '-1', '0');
334 INSERT INTO `0_chart_types` VALUES ('9', 'Other Revenue', '3', '-1', '0');
335 INSERT INTO `0_chart_types` VALUES ('10', 'Cost of Goods Sold', '4', '-1', '0');
336 INSERT INTO `0_chart_types` VALUES ('11', 'Payroll Expenses', '4', '-1', '0');
337 INSERT INTO `0_chart_types` VALUES ('12', 'General & Administrative expenses', '4', '-1', '0');
340 ### Structure of table `0_comments` ###
342 DROP TABLE IF EXISTS `0_comments`;
344 CREATE TABLE `0_comments` (
345 `type` int(11) NOT NULL default '0',
346 `id` int(11) NOT NULL default '0',
347 `date_` date default '0000-00-00',
352 ### Data of table `0_comments` ###
356 ### Structure of table `0_company` ###
358 DROP TABLE IF EXISTS `0_company`;
360 CREATE TABLE `0_company` (
361 `coy_code` int(11) NOT NULL default '1',
362 `coy_name` varchar(60) NOT NULL default '',
363 `gst_no` varchar(25) NOT NULL default '',
364 `coy_no` varchar(25) NOT NULL default '0',
365 `tax_prd` int(11) NOT NULL default '1',
366 `tax_last` int(11) NOT NULL default '1',
367 `postal_address` tinytext NOT NULL,
368 `phone` varchar(30) NOT NULL default '',
369 `fax` varchar(30) NOT NULL default '',
370 `email` varchar(100) NOT NULL default '',
371 `coy_logo` varchar(100) NOT NULL default '',
372 `domicile` varchar(55) NOT NULL default '',
373 `curr_default` char(3) NOT NULL default '',
374 `debtors_act` varchar(11) NOT NULL default '',
375 `pyt_discount_act` varchar(11) NOT NULL default '',
376 `creditors_act` varchar(11) NOT NULL default '',
377 `bank_charge_act` varchar(11) NOT NULL default '',
378 `exchange_diff_act` varchar(11) NOT NULL default '',
379 `profit_loss_year_act` varchar(11) NOT NULL default '',
380 `retained_earnings_act` varchar(11) NOT NULL default '',
381 `freight_act` varchar(11) NOT NULL default '',
382 `default_sales_act` varchar(11) NOT NULL default '',
383 `default_sales_discount_act` varchar(11) NOT NULL default '',
384 `default_prompt_payment_act` varchar(11) NOT NULL default '',
385 `default_inventory_act` varchar(11) NOT NULL default '',
386 `default_cogs_act` varchar(11) NOT NULL default '',
387 `default_adj_act` varchar(11) NOT NULL default '',
388 `default_inv_sales_act` varchar(11) NOT NULL default '',
389 `default_assembly_act` varchar(11) NOT NULL default '',
390 `payroll_act` varchar(11) NOT NULL default '',
391 `allow_negative_stock` tinyint(1) NOT NULL default '0',
392 `po_over_receive` int(11) NOT NULL default '10',
393 `po_over_charge` int(11) NOT NULL default '10',
394 `default_credit_limit` int(11) NOT NULL default '1000',
395 `default_workorder_required` int(11) NOT NULL default '20',
396 `default_dim_required` int(11) NOT NULL default '20',
397 `past_due_days` int(11) NOT NULL default '30',
398 `use_dimension` tinyint(1) default '0',
399 `f_year` int(11) NOT NULL default '1',
400 `no_item_list` tinyint(1) NOT NULL default '0',
401 `no_customer_list` tinyint(1) NOT NULL default '0',
402 `no_supplier_list` tinyint(1) NOT NULL default '0',
403 `base_sales` int(11) NOT NULL default '-1',
404 `foreign_codes` tinyint(1) NOT NULL default '0',
405 `accumulate_shipping` tinyint(1) NOT NULL default '0',
406 `legal_text` tinytext NOT NULL,
407 `default_delivery_required` smallint(6) NOT NULL default '1',
408 `version_id` varchar(11) NOT NULL default '',
409 `time_zone` tinyint(1) NOT NULL default '0',
410 `add_pct` int(5) NOT NULL default '-1',
411 `round_to` int(5) NOT NULL default '1',
412 `login_tout` SMALLINT(6) NOT NULL DEFAULT '600',
413 PRIMARY KEY (`coy_code`)
416 ### Data of table `0_company` ###
418 INSERT INTO `0_company` VALUES ('1', 'Training Co.', '9876543', '123456789', '1', '1', 'Address 1\r\nAddress 2\r\nAddress 3', '(222) 111.222.333', '', 'delta@delta.com', 'logo_frontaccounting.jpg', '', 'USD', '1200', '5060', '2100', '5690', '4450', '9990', '3590', '4430', '4010', '4510', '4500', '1510', '5010', '5040', '4010', '1530', '5000', '0', '10', '10', '1000', '20', '20', '30', '1', '2', '0', '0', '0', '1', '0', '0', '', '1', '2.2', '0', '-1', '1', '600');
420 ### Structure of table `0_credit_status` ###
422 DROP TABLE IF EXISTS `0_credit_status`;
424 CREATE TABLE `0_credit_status` (
425 `id` int(11) NOT NULL auto_increment,
426 `reason_description` char(100) NOT NULL default '',
427 `dissallow_invoices` tinyint(1) NOT NULL default '0',
428 `inactive` tinyint(1) NOT NULL default '0',
430 UNIQUE KEY `reason_description` (`reason_description`)
431 ) TYPE=MyISAM AUTO_INCREMENT=5 ;
434 ### Data of table `0_credit_status` ###
436 INSERT INTO `0_credit_status` VALUES ('1', 'Good History', '0', '0');
437 INSERT INTO `0_credit_status` VALUES ('3', 'No more work until payment received', '1', '0');
438 INSERT INTO `0_credit_status` VALUES ('4', 'In liquidation', '1', '0');
441 ### Structure of table `0_currencies` ###
443 DROP TABLE IF EXISTS `0_currencies`;
445 CREATE TABLE `0_currencies` (
446 `currency` varchar(60) NOT NULL default '',
447 `curr_abrev` char(3) NOT NULL default '',
448 `curr_symbol` varchar(10) NOT NULL default '',
449 `country` varchar(100) NOT NULL default '',
450 `hundreds_name` varchar(15) NOT NULL default '',
451 `auto_update` tinyint(1) NOT NULL default '1',
452 `inactive` tinyint(1) NOT NULL default '0',
453 PRIMARY KEY (`curr_abrev`)
457 ### Data of table `0_currencies` ###
459 INSERT INTO `0_currencies` VALUES ('US Dollars', 'USD', '$', 'United States', 'Cents', '1', '0');
460 INSERT INTO `0_currencies` VALUES ('CA Dollars', 'CAD', '$', 'Canada', 'Cents', '1', '0');
461 INSERT INTO `0_currencies` VALUES ('Euro', 'EUR', '?', 'Europe', 'Cents', '1', '0');
462 INSERT INTO `0_currencies` VALUES ('Pounds', 'GBP', '?', 'England', 'Pence', '1', '0');
463 INSERT INTO `0_currencies` VALUES ('DK Kroner', 'DKK', '?', 'Denmark', 'Ore', '1', '0');
465 ### Structure of table `0_cust_allocations` ###
467 DROP TABLE IF EXISTS `0_cust_allocations`;
469 CREATE TABLE `0_cust_allocations` (
470 `id` int(11) NOT NULL auto_increment,
471 `amt` double unsigned default NULL,
472 `date_alloc` date NOT NULL default '0000-00-00',
473 `trans_no_from` int(11) default NULL,
474 `trans_type_from` int(11) default NULL,
475 `trans_no_to` int(11) default NULL,
476 `trans_type_to` int(11) default NULL,
478 ) TYPE=InnoDB AUTO_INCREMENT=2 ;
481 ### Data of table `0_cust_allocations` ###
483 INSERT INTO `0_cust_allocations` VALUES ('1', '37.68', '2009-06-21', '3', '11', '18', '10');
486 ### Structure of table `0_cust_branch` ###
488 DROP TABLE IF EXISTS `0_cust_branch`;
490 CREATE TABLE `0_cust_branch` (
491 `branch_code` int(11) NOT NULL auto_increment,
492 `debtor_no` int(11) NOT NULL default '0',
493 `br_name` varchar(60) NOT NULL default '',
494 `branch_ref` varchar(30) NOT NULL default '',
495 `br_address` tinytext NOT NULL,
496 `area` int(11) default NULL,
497 `salesman` int(11) NOT NULL default '0',
498 `phone` varchar(30) NOT NULL default '',
499 `phone2` varchar(30) NOT NULL default '',
500 `fax` varchar(30) NOT NULL default '',
501 `contact_name` varchar(60) NOT NULL default '',
502 `email` varchar(100) NOT NULL default '',
503 `default_location` varchar(5) NOT NULL default '',
504 `tax_group_id` int(11) default NULL,
505 `sales_account` varchar(11) default NULL,
506 `sales_discount_account` varchar(11) default NULL,
507 `receivables_account` varchar(11) default NULL,
508 `payment_discount_account` varchar(11) default NULL,
509 `default_ship_via` int(11) NOT NULL default '1',
510 `disable_trans` tinyint(4) NOT NULL default '0',
511 `br_post_address` tinytext NOT NULL,
512 `group_no` int(11) NOT NULL default '0',
513 `notes` tinytext NOT NULL,
514 `inactive` tinyint(1) NOT NULL default '0',
515 PRIMARY KEY (`branch_code`,`debtor_no`),
516 KEY `branch_code` (`branch_code`),
517 KEY `br_name` (`br_name`)
518 ) TYPE=MyISAM AUTO_INCREMENT=4 ;
521 ### Data of table `0_cust_branch` ###
523 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');
524 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');
525 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');
528 ### Structure of table `0_debtor_trans` ###
530 DROP TABLE IF EXISTS `0_debtor_trans`;
532 CREATE TABLE `0_debtor_trans` (
533 `trans_no` int(11) unsigned NOT NULL default '0',
534 `type` smallint(6) unsigned NOT NULL default '0',
535 `version` tinyint(1) unsigned NOT NULL default '0',
536 `debtor_no` int(11) unsigned default NULL,
537 `branch_code` int(11) NOT NULL default '-1',
538 `tran_date` date NOT NULL default '0000-00-00',
539 `due_date` date NOT NULL default '0000-00-00',
540 `reference` varchar(60) NOT NULL default '',
541 `tpe` int(11) NOT NULL default '0',
542 `order_` int(11) NOT NULL default '0',
543 `ov_amount` double NOT NULL default '0',
544 `ov_gst` double NOT NULL default '0',
545 `ov_freight` double NOT NULL default '0',
546 `ov_freight_tax` double NOT NULL default '0',
547 `ov_discount` double NOT NULL default '0',
548 `alloc` double NOT NULL default '0',
549 `rate` double NOT NULL default '1',
550 `ship_via` int(11) default NULL,
551 `trans_link` int(11) NOT NULL default '0',
552 `dimension_id` int(11) NOT NULL default '0',
553 `dimension2_id` int(11) NOT NULL default '0',
554 PRIMARY KEY (`trans_no`,`type`),
555 KEY `debtor_no` (`debtor_no`,`branch_code`)
559 ### Data of table `0_debtor_trans` ###
561 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');
562 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');
563 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');
564 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');
565 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');
566 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');
567 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');
568 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');
571 ### Structure of table `0_debtor_trans_details` ###
573 DROP TABLE IF EXISTS `0_debtor_trans_details`;
575 CREATE TABLE `0_debtor_trans_details` (
576 `id` int(11) NOT NULL auto_increment,
577 `debtor_trans_no` int(11) default NULL,
578 `debtor_trans_type` int(11) default NULL,
579 `stock_id` varchar(20) NOT NULL default '',
580 `description` tinytext,
581 `unit_price` double NOT NULL default '0',
582 `unit_tax` double NOT NULL default '0',
583 `quantity` double NOT NULL default '0',
584 `discount_percent` double NOT NULL default '0',
585 `standard_cost` double NOT NULL default '0',
586 `qty_done` double NOT NULL default '0',
588 ) TYPE=InnoDB AUTO_INCREMENT=9 ;
591 ### Data of table `0_debtor_trans_details` ###
593 INSERT INTO `0_debtor_trans_details` VALUES ('1', '2', '13', '102', '17inch VGA Monitor', '30.4', '0', '2', '0', '10', '0');
594 INSERT INTO `0_debtor_trans_details` VALUES ('2', '3', '13', '102', '17inch VGA Monitor', '50', '2.5', '1', '0', '10', '1');
595 INSERT INTO `0_debtor_trans_details` VALUES ('3', '17', '10', '102', '17inch VGA Monitor', '50', '2.5', '1', '0', '10', '0');
596 INSERT INTO `0_debtor_trans_details` VALUES ('4', '4', '13', '102', '17inch VGA Monitor', '35.89', '1.79', '1', '0', '10', '1');
597 INSERT INTO `0_debtor_trans_details` VALUES ('5', '18', '10', '102', '17inch VGA Monitor', '35.89', '1.79', '1', '0', '10', '1');
598 INSERT INTO `0_debtor_trans_details` VALUES ('6', '5', '13', '102', '17inch VGA Monitor', '50', '2.38', '1', '0', '10', '1');
599 INSERT INTO `0_debtor_trans_details` VALUES ('7', '19', '10', '102', '17inch VGA Monitor', '50', '2.38', '1', '0', '10', '0');
600 INSERT INTO `0_debtor_trans_details` VALUES ('8', '3', '11', '102', '17inch VGA Monitor', '35.89', '1.79', '1', '0', '10', '0');
603 ### Structure of table `0_debtors_master` ###
605 DROP TABLE IF EXISTS `0_debtors_master`;
607 CREATE TABLE `0_debtors_master` (
608 `debtor_no` int(11) NOT NULL auto_increment,
609 `name` varchar(100) NOT NULL default '',
610 `debtor_ref` varchar(30) NOT NULL,
612 `email` varchar(100) NOT NULL default '',
613 `tax_id` varchar(55) NOT NULL default '',
614 `curr_code` char(3) NOT NULL default '',
615 `sales_type` int(11) NOT NULL default '1',
616 `dimension_id` int(11) NOT NULL default '0',
617 `dimension2_id` int(11) NOT NULL default '0',
618 `credit_status` int(11) NOT NULL default '0',
619 `payment_terms` int(11) default NULL,
620 `discount` double NOT NULL default '0',
621 `pymt_discount` double NOT NULL default '0',
622 `credit_limit` float NOT NULL default '1000',
623 `notes` tinytext NOT NULL,
624 `inactive` tinyint(1) NOT NULL default '0',
625 PRIMARY KEY (`debtor_no`),
626 UNIQUE KEY `name` (`name`)
627 ) TYPE=MyISAM AUTO_INCREMENT=4 ;
630 ### Data of table `0_debtors_master` ###
632 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');
633 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');
634 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');
637 ### Structure of table `0_dimensions` ###
639 DROP TABLE IF EXISTS `0_dimensions`;
641 CREATE TABLE `0_dimensions` (
642 `id` int(11) NOT NULL auto_increment,
643 `reference` varchar(60) NOT NULL default '',
644 `name` varchar(60) NOT NULL default '',
645 `type_` tinyint(1) NOT NULL default '1',
646 `closed` tinyint(1) NOT NULL default '0',
647 `date_` date NOT NULL default '0000-00-00',
648 `due_date` date NOT NULL default '0000-00-00',
650 UNIQUE KEY `reference` (`reference`)
651 ) TYPE=InnoDB AUTO_INCREMENT=3 ;
654 ### Data of table `0_dimensions` ###
656 INSERT INTO `0_dimensions` VALUES ('1', '1', 'Support', '1', '0', '2009-06-21', '2015-07-11');
657 INSERT INTO `0_dimensions` VALUES ('2', '2', 'Development', '1', '0', '2009-06-21', '2015-07-11');
660 ### Structure of table `0_exchange_rates` ###
662 DROP TABLE IF EXISTS `0_exchange_rates`;
664 CREATE TABLE `0_exchange_rates` (
665 `id` int(11) NOT NULL auto_increment,
666 `curr_code` char(3) NOT NULL default '',
667 `rate_buy` double NOT NULL default '0',
668 `rate_sell` double NOT NULL default '0',
669 `date_` date NOT NULL default '0000-00-00',
671 UNIQUE KEY `curr_code` (`curr_code`,`date_`)
672 ) TYPE=MyISAM AUTO_INCREMENT=4 ;
675 ### Data of table `0_exchange_rates` ###
677 INSERT INTO `0_exchange_rates` VALUES ('1', 'DKK', '0.18717252868313', '0.18717252868313', '2009-06-21');
678 INSERT INTO `0_exchange_rates` VALUES ('2', 'GBP', '1.6445729799917', '1.6445729799917', '2009-06-21');
679 INSERT INTO `0_exchange_rates` VALUES ('3', 'EUR', '1.3932', '1.3932', '2009-06-21');
682 ### Structure of table `0_fiscal_year` ###
684 DROP TABLE IF EXISTS `0_fiscal_year`;
686 CREATE TABLE `0_fiscal_year` (
687 `id` int(11) NOT NULL auto_increment,
688 `begin` date default '0000-00-00',
689 `end` date default '0000-00-00',
690 `closed` tinyint(1) NOT NULL default '0',
692 ) TYPE=InnoDB AUTO_INCREMENT=3 ;
695 ### Data of table `0_fiscal_year` ###
697 INSERT INTO `0_fiscal_year` VALUES ('1', '2008-01-01', '2008-12-31', '0');
698 INSERT INTO `0_fiscal_year` VALUES ('2', '2009-01-01', '2009-12-31', '0');
701 ### Structure of table `0_gl_trans` ###
703 DROP TABLE IF EXISTS `0_gl_trans`;
705 CREATE TABLE `0_gl_trans` (
706 `counter` int(11) NOT NULL auto_increment,
707 `type` smallint(6) NOT NULL default '0',
708 `type_no` bigint(16) NOT NULL default '1',
709 `tran_date` date NOT NULL default '0000-00-00',
710 `account` varchar(11) NOT NULL default '',
711 `memo_` tinytext NOT NULL,
712 `amount` double NOT NULL default '0',
713 `dimension_id` int(11) NOT NULL default '0',
714 `dimension2_id` int(11) NOT NULL default '0',
715 `person_type_id` int(11) default NULL,
716 `person_id` tinyblob,
717 PRIMARY KEY (`counter`),
718 KEY `Type_and_Number` (`type`,`type_no`)
719 ) TYPE=InnoDB AUTO_INCREMENT=84 ;
722 ### Data of table `0_gl_trans` ###
724 INSERT INTO `0_gl_trans` VALUES ('1', '20', '7', '2009-06-21', '2100', '', '-3465', '0', '0', '3', '2');
725 INSERT INTO `0_gl_trans` VALUES ('2', '20', '7', '2009-06-21', '1510', '', '1000', '0', '0', '3', '2');
726 INSERT INTO `0_gl_trans` VALUES ('3', '20', '7', '2009-06-21', '1510', '', '1100', '0', '0', '3', '2');
727 INSERT INTO `0_gl_trans` VALUES ('4', '20', '7', '2009-06-21', '1510', '', '1200', '0', '0', '3', '2');
728 INSERT INTO `0_gl_trans` VALUES ('5', '20', '7', '2009-06-21', '2150', '', '165', '0', '0', '3', '2');
729 INSERT INTO `0_gl_trans` VALUES ('6', '22', '4', '2009-06-21', '2100', '', '3465', '0', '0', '3', '2');
730 INSERT INTO `0_gl_trans` VALUES ('7', '22', '4', '2009-06-21', '1060', '', '-3465', '0', '0', '3', '2');
731 INSERT INTO `0_gl_trans` VALUES ('8', '26', '1', '2009-06-21', '1510', '', '-100', '0', '0', '', '');
732 INSERT INTO `0_gl_trans` VALUES ('9', '26', '1', '2009-06-21', '1510', '', '-110', '0', '0', '', '');
733 INSERT INTO `0_gl_trans` VALUES ('10', '26', '1', '2009-06-21', '1510', '', '-120', '0', '0', '', '');
734 INSERT INTO `0_gl_trans` VALUES ('11', '26', '1', '2009-06-21', '1060', 'Overhead Cost', '-10', '0', '0', '1', '1');
735 INSERT INTO `0_gl_trans` VALUES ('12', '26', '1', '2009-06-21', '1530', 'Overhead Cost', '10', '0', '0', '1', '1');
736 INSERT INTO `0_gl_trans` VALUES ('13', '26', '1', '2009-06-21', '1060', 'Labour Cost', '-20', '0', '0', '1', '0');
737 INSERT INTO `0_gl_trans` VALUES ('14', '26', '1', '2009-06-21', '1530', 'Labour Cost', '20', '0', '0', '1', '0');
738 INSERT INTO `0_gl_trans` VALUES ('15', '26', '1', '2009-06-21', '1510', '', '330', '0', '0', '', '');
739 INSERT INTO `0_gl_trans` VALUES ('16', '13', '2', '2009-06-21', '5010', '', '20', '0', '0', '2', '1');
740 INSERT INTO `0_gl_trans` VALUES ('17', '13', '2', '2009-06-21', '1510', '', '-20', '0', '0', '2', '1');
741 INSERT INTO `0_gl_trans` VALUES ('18', '13', '3', '2009-06-21', '5010', '', '10', '0', '0', '2', '2');
742 INSERT INTO `0_gl_trans` VALUES ('19', '13', '3', '2009-06-21', '1510', '', '-10', '0', '0', '2', '2');
743 INSERT INTO `0_gl_trans` VALUES ('20', '10', '17', '2009-06-21', '4010', '', '-50', '0', '0', '2', '2');
744 INSERT INTO `0_gl_trans` VALUES ('21', '10', '17', '2009-06-21', '1200', '', '52.5', '0', '0', '2', '2');
745 INSERT INTO `0_gl_trans` VALUES ('22', '10', '17', '2009-06-21', '2150', '', '-2.5', '0', '0', '2', '2');
746 INSERT INTO `0_gl_trans` VALUES ('23', '13', '4', '2009-06-21', '5010', '', '10', '2', '0', '2', '3');
747 INSERT INTO `0_gl_trans` VALUES ('24', '13', '4', '2009-06-21', '1510', '', '-10', '0', '0', '2', '3');
748 INSERT INTO `0_gl_trans` VALUES ('25', '10', '18', '2009-06-21', '4010', '', '-50', '2', '0', '2', '3');
749 INSERT INTO `0_gl_trans` VALUES ('26', '10', '18', '2009-06-21', '1200', '', '52.5', '0', '0', '2', '3');
750 INSERT INTO `0_gl_trans` VALUES ('27', '10', '18', '2009-06-21', '2150', '', '-2.5', '0', '0', '2', '3');
751 INSERT INTO `0_gl_trans` VALUES ('28', '0', '18', '2009-02-20', '1060', '', '1000', '0', '0', '', '');
752 INSERT INTO `0_gl_trans` VALUES ('29', '0', '18', '2009-02-20', '3350', '', '-1000', '0', '0', '', '');
753 INSERT INTO `0_gl_trans` VALUES ('30', '0', '19', '2009-02-21', '1060', '', '4000', '0', '0', '', '');
754 INSERT INTO `0_gl_trans` VALUES ('31', '0', '19', '2009-02-21', '3350', '', '-4000', '0', '0', '', '');
755 INSERT INTO `0_gl_trans` VALUES ('32', '26', '3', '2009-06-21', '1510', '', '-20', '0', '0', '', '');
756 INSERT INTO `0_gl_trans` VALUES ('33', '26', '3', '2009-06-21', '1510', '', '-22', '0', '0', '', '');
757 INSERT INTO `0_gl_trans` VALUES ('34', '26', '3', '2009-06-21', '1510', '', '-24', '0', '0', '', '');
758 INSERT INTO `0_gl_trans` VALUES ('35', '26', '3', '2009-06-21', '1540', '', '66', '0', '0', '', '');
759 INSERT INTO `0_gl_trans` VALUES ('36', '2', '5', '2009-06-21', '2150', 'Cash Sales', '-4.76', '0', '0', '4', '3');
760 INSERT INTO `0_gl_trans` VALUES ('37', '2', '5', '2009-06-21', '4010', 'Cash Sales', '-95.24', '0', '0', '4', '3');
761 INSERT INTO `0_gl_trans` VALUES ('38', '2', '5', '2009-06-21', '1060', '', '100', '0', '0', '4', '3');
762 INSERT INTO `0_gl_trans` VALUES ('39', '1', '8', '2009-06-21', '2150', 'Maintenance', '2.38', '0', '0', '4', '1');
763 INSERT INTO `0_gl_trans` VALUES ('40', '1', '8', '2009-06-21', '5765', 'Maintenance', '47.62', '0', '0', '4', '1');
764 INSERT INTO `0_gl_trans` VALUES ('41', '1', '8', '2009-06-21', '1060', '', '-50', '0', '0', '4', '1');
765 INSERT INTO `0_gl_trans` VALUES ('42', '20', '8', '2009-06-21', '2100', '', '-20', '0', '0', '3', '2');
766 INSERT INTO `0_gl_trans` VALUES ('43', '20', '8', '2009-06-21', '2150', '', '0.95', '0', '0', '3', '2');
767 INSERT INTO `0_gl_trans` VALUES ('44', '20', '8', '2009-06-21', '5780', '', '19.05', '0', '0', '3', '2');
768 INSERT INTO `0_gl_trans` VALUES ('45', '26', '4', '2009-06-21', '1510', '', '-40', '0', '0', '', '');
769 INSERT INTO `0_gl_trans` VALUES ('46', '26', '4', '2009-06-21', '1510', '', '-44', '0', '0', '', '');
770 INSERT INTO `0_gl_trans` VALUES ('47', '26', '4', '2009-06-21', '1510', '', '-48', '0', '0', '', '');
771 INSERT INTO `0_gl_trans` VALUES ('48', '26', '4', '2009-06-21', '1540', '', '132', '0', '0', '', '');
772 INSERT INTO `0_gl_trans` VALUES ('49', '26', '2', '2009-06-21', '1510', '', '-20', '0', '0', '', '');
773 INSERT INTO `0_gl_trans` VALUES ('50', '26', '2', '2009-06-21', '1510', '', '-22', '0', '0', '', '');
774 INSERT INTO `0_gl_trans` VALUES ('51', '26', '2', '2009-06-21', '1510', '', '-24', '0', '0', '', '');
775 INSERT INTO `0_gl_trans` VALUES ('52', '26', '2', '2009-06-21', '1540', '', '66', '0', '0', '', '');
776 INSERT INTO `0_gl_trans` VALUES ('53', '26', '5', '2009-06-21', '1510', '', '-50', '0', '0', '', '');
777 INSERT INTO `0_gl_trans` VALUES ('54', '26', '5', '2009-06-21', '1510', '', '-55', '0', '0', '', '');
778 INSERT INTO `0_gl_trans` VALUES ('55', '26', '5', '2009-06-21', '1510', '', '-60', '0', '0', '', '');
779 INSERT INTO `0_gl_trans` VALUES ('56', '26', '5', '2009-06-21', '1060', 'Overhead Cost', '-10', '0', '0', '1', '1');
780 INSERT INTO `0_gl_trans` VALUES ('57', '26', '5', '2009-06-21', '1530', 'Overhead Cost', '10', '0', '0', '1', '1');
781 INSERT INTO `0_gl_trans` VALUES ('58', '26', '5', '2009-06-21', '1060', 'Labour Cost', '-20', '0', '0', '1', '0');
782 INSERT INTO `0_gl_trans` VALUES ('59', '26', '5', '2009-06-21', '1530', 'Labour Cost', '20', '0', '0', '1', '0');
783 INSERT INTO `0_gl_trans` VALUES ('60', '26', '5', '2009-06-21', '1540', '', '165', '0', '0', '', '');
784 INSERT INTO `0_gl_trans` VALUES ('61', '26', '6', '2009-06-21', '1510', '', '50', '0', '0', '', '');
785 INSERT INTO `0_gl_trans` VALUES ('62', '26', '6', '2009-06-21', '1510', '', '55', '0', '0', '', '');
786 INSERT INTO `0_gl_trans` VALUES ('63', '26', '6', '2009-06-21', '1510', '', '60', '0', '0', '', '');
787 INSERT INTO `0_gl_trans` VALUES ('64', '26', '6', '2009-06-21', '1540', '', '-165', '0', '0', '', '');
788 INSERT INTO `0_gl_trans` VALUES ('65', '26', '7', '2009-06-21', '1510', '', '20', '0', '0', '', '');
789 INSERT INTO `0_gl_trans` VALUES ('66', '26', '7', '2009-06-21', '1510', '', '22', '0', '0', '', '');
790 INSERT INTO `0_gl_trans` VALUES ('67', '26', '7', '2009-06-21', '1510', '', '24', '0', '0', '', '');
791 INSERT INTO `0_gl_trans` VALUES ('68', '26', '7', '2009-06-21', '1060', 'Overhead Cost', '-10', '0', '0', '1', '1');
792 INSERT INTO `0_gl_trans` VALUES ('69', '26', '7', '2009-06-21', '1530', 'Overhead Cost', '10', '0', '0', '1', '1');
793 INSERT INTO `0_gl_trans` VALUES ('70', '26', '7', '2009-06-21', '1060', 'Labour Cost', '-20', '0', '0', '1', '0');
794 INSERT INTO `0_gl_trans` VALUES ('71', '26', '7', '2009-06-21', '1530', 'Labour Cost', '20', '0', '0', '1', '0');
795 INSERT INTO `0_gl_trans` VALUES ('72', '26', '7', '2009-06-21', '1540', '', '-66', '0', '0', '', '');
796 INSERT INTO `0_gl_trans` VALUES ('73', '13', '5', '2009-06-21', '5010', '', '10', '0', '0', '2', '2');
797 INSERT INTO `0_gl_trans` VALUES ('74', '13', '5', '2009-06-21', '1510', '', '-10', '0', '0', '2', '2');
798 INSERT INTO `0_gl_trans` VALUES ('75', '10', '19', '2009-06-21', '4010', '', '-47.62', '0', '0', '2', '2');
799 INSERT INTO `0_gl_trans` VALUES ('76', '10', '19', '2009-06-21', '1200', '', '55', '0', '0', '2', '2');
800 INSERT INTO `0_gl_trans` VALUES ('77', '10', '19', '2009-06-21', '4430', '', '-5', '0', '0', '2', '2');
801 INSERT INTO `0_gl_trans` VALUES ('78', '10', '19', '2009-06-21', '2150', '', '-2.38', '0', '0', '2', '2');
802 INSERT INTO `0_gl_trans` VALUES ('79', '11', '3', '2009-06-21', '5010', '', '-10', '2', '0', '2', '3');
803 INSERT INTO `0_gl_trans` VALUES ('80', '11', '3', '2009-06-21', '1510', '', '10', '0', '0', '2', '3');
804 INSERT INTO `0_gl_trans` VALUES ('81', '11', '3', '2009-06-21', '4010', '', '50', '2', '0', '2', '3');
805 INSERT INTO `0_gl_trans` VALUES ('82', '11', '3', '2009-06-21', '1200', '', '-52.5', '0', '0', '2', '3');
806 INSERT INTO `0_gl_trans` VALUES ('83', '11', '3', '2009-06-21', '2150', '', '2.5', '0', '0', '2', '3');
809 ### Structure of table `0_grn_batch` ###
811 DROP TABLE IF EXISTS `0_grn_batch`;
813 CREATE TABLE `0_grn_batch` (
814 `id` int(11) NOT NULL auto_increment,
815 `supplier_id` int(11) NOT NULL default '0',
816 `purch_order_no` int(11) default NULL,
817 `reference` varchar(60) NOT NULL default '',
818 `delivery_date` date NOT NULL default '0000-00-00',
819 `loc_code` varchar(5) default NULL,
821 ) TYPE=InnoDB AUTO_INCREMENT=2 ;
824 ### Data of table `0_grn_batch` ###
826 INSERT INTO `0_grn_batch` VALUES ('1', '2', '1', '1', '2009-06-21', 'DEF');
829 ### Structure of table `0_grn_items` ###
831 DROP TABLE IF EXISTS `0_grn_items`;
833 CREATE TABLE `0_grn_items` (
834 `id` int(11) NOT NULL auto_increment,
835 `grn_batch_id` int(11) default NULL,
836 `po_detail_item` int(11) NOT NULL default '0',
837 `item_code` varchar(20) NOT NULL default '',
838 `description` tinytext,
839 `qty_recd` double NOT NULL default '0',
840 `quantity_inv` double NOT NULL default '0',
842 ) TYPE=InnoDB AUTO_INCREMENT=4 ;
845 ### Data of table `0_grn_items` ###
847 INSERT INTO `0_grn_items` VALUES ('1', '1', '1', '102', '17inch VGA Monitor', '100', '100');
848 INSERT INTO `0_grn_items` VALUES ('2', '1', '2', '103', '32MB VGA Card', '100', '100');
849 INSERT INTO `0_grn_items` VALUES ('3', '1', '3', '104', '52x CD Drive', '100', '100');
852 ### Structure of table `0_groups` ###
854 DROP TABLE IF EXISTS `0_groups`;
856 CREATE TABLE `0_groups` (
857 `id` smallint(6) unsigned NOT NULL auto_increment,
858 `description` varchar(60) NOT NULL default '',
859 `inactive` tinyint(1) NOT NULL default '0',
861 UNIQUE KEY `description` (`description`)
862 ) TYPE=MyISAM AUTO_INCREMENT=4 AUTO_INCREMENT=4 ;
865 ### Data of table `0_groups` ###
867 INSERT INTO `0_groups` VALUES ('1', 'Small', '0');
868 INSERT INTO `0_groups` VALUES ('2', 'Medium', '0');
869 INSERT INTO `0_groups` VALUES ('3', 'Large', '0');
872 ### Structure of table `0_item_codes` ###
874 DROP TABLE IF EXISTS `0_item_codes`;
876 CREATE TABLE `0_item_codes` (
877 `id` int(11) unsigned NOT NULL auto_increment,
878 `item_code` varchar(20) NOT NULL,
879 `stock_id` varchar(20) NOT NULL,
880 `description` varchar(200) NOT NULL default '',
881 `category_id` smallint(6) unsigned NOT NULL,
882 `quantity` double NOT NULL default '1',
883 `is_foreign` tinyint(1) NOT NULL default '0',
884 `inactive` tinyint(1) NOT NULL default '0',
886 UNIQUE KEY `stock_id` (`stock_id`,`item_code`)
887 ) TYPE=MyISAM AUTO_INCREMENT=6 ;
890 ### Data of table `0_item_codes` ###
892 INSERT INTO `0_item_codes` VALUES ('1', '102', '102', '17inch VGA Monitor', '1', '1', '0', '0');
893 INSERT INTO `0_item_codes` VALUES ('2', '103', '103', '32MB VGA Card', '1', '1', '0', '0');
894 INSERT INTO `0_item_codes` VALUES ('3', '104', '104', '52x CD Drive', '1', '1', '0', '0');
895 INSERT INTO `0_item_codes` VALUES ('4', '3400', '3400', 'P4 Business System', '3', '1', '0', '0');
896 INSERT INTO `0_item_codes` VALUES ('5', '201', '201', 'Assembly Labour', '4', '1', '0', '0');
899 ### Structure of table `0_item_tax_type_exemptions` ###
901 DROP TABLE IF EXISTS `0_item_tax_type_exemptions`;
903 CREATE TABLE `0_item_tax_type_exemptions` (
904 `item_tax_type_id` int(11) NOT NULL default '0',
905 `tax_type_id` int(11) NOT NULL default '0',
906 PRIMARY KEY (`item_tax_type_id`,`tax_type_id`)
910 ### Data of table `0_item_tax_type_exemptions` ###
914 ### Structure of table `0_item_tax_types` ###
916 DROP TABLE IF EXISTS `0_item_tax_types`;
918 CREATE TABLE `0_item_tax_types` (
919 `id` int(11) NOT NULL auto_increment,
920 `name` varchar(60) NOT NULL default '',
921 `exempt` tinyint(1) NOT NULL default '0',
922 `inactive` tinyint(1) NOT NULL default '0',
924 UNIQUE KEY `name` (`name`)
925 ) TYPE=InnoDB AUTO_INCREMENT=2 ;
928 ### Data of table `0_item_tax_types` ###
930 INSERT INTO `0_item_tax_types` VALUES ('1', 'Regular', '0', '0');
932 ### Structure of table `0_item_units` ###
934 DROP TABLE IF EXISTS `0_item_units`;
936 CREATE TABLE `0_item_units` (
937 `abbr` varchar(20) NOT NULL,
938 `name` varchar(40) NOT NULL,
939 `decimals` tinyint(2) NOT NULL,
940 `inactive` tinyint(1) NOT NULL default '0',
941 PRIMARY KEY (`abbr`),
942 UNIQUE KEY `name` (`name`)
946 ### Data of table `0_item_units` ###
948 INSERT INTO `0_item_units` VALUES ('ea.', 'Each', '0', '0');
949 INSERT INTO `0_item_units` VALUES ('hrs', 'Hours', '1', '0');
952 ### Structure of table `0_loc_stock` ###
954 DROP TABLE IF EXISTS `0_loc_stock`;
956 CREATE TABLE `0_loc_stock` (
957 `loc_code` char(5) NOT NULL default '',
958 `stock_id` char(20) NOT NULL default '',
959 `reorder_level` bigint(20) NOT NULL default '0',
960 PRIMARY KEY (`loc_code`,`stock_id`),
961 KEY `stock_id` (`stock_id`)
965 ### Data of table `0_loc_stock` ###
967 INSERT INTO `0_loc_stock` VALUES ('DEF', '102', '0');
968 INSERT INTO `0_loc_stock` VALUES ('DEF', '103', '0');
969 INSERT INTO `0_loc_stock` VALUES ('DEF', '104', '0');
970 INSERT INTO `0_loc_stock` VALUES ('DEF', '201', '0');
971 INSERT INTO `0_loc_stock` VALUES ('DEF', '3400', '0');
974 ### Structure of table `0_locations` ###
976 DROP TABLE IF EXISTS `0_locations`;
978 CREATE TABLE `0_locations` (
979 `loc_code` varchar(5) NOT NULL default '',
980 `location_name` varchar(60) NOT NULL default '',
981 `delivery_address` tinytext NOT NULL,
982 `phone` varchar(30) NOT NULL default '',
983 `phone2` varchar(30) NOT NULL default '',
984 `fax` varchar(30) NOT NULL default '',
985 `email` varchar(100) NOT NULL default '',
986 `contact` varchar(30) NOT NULL default '',
987 `inactive` tinyint(1) NOT NULL default '0',
988 PRIMARY KEY (`loc_code`)
992 ### Data of table `0_locations` ###
994 INSERT INTO `0_locations` VALUES ('DEF', 'Default', 'Delivery 1\r\nDelivery 2\r\nDelivery 3', '', '', '', '', '', '0');
997 ### Structure of table `0_movement_types` ###
999 DROP TABLE IF EXISTS `0_movement_types`;
1001 CREATE TABLE `0_movement_types` (
1002 `id` int(11) NOT NULL auto_increment,
1003 `name` varchar(60) NOT NULL default '',
1004 `inactive` tinyint(1) NOT NULL default '0',
1006 UNIQUE KEY `name` (`name`)
1007 ) TYPE=MyISAM AUTO_INCREMENT=2 ;
1010 ### Data of table `0_movement_types` ###
1012 INSERT INTO `0_movement_types` VALUES ('1', 'Adjustment', '0');
1015 ### Structure of table `0_payment_terms` ###
1017 DROP TABLE IF EXISTS `0_payment_terms`;
1019 CREATE TABLE `0_payment_terms` (
1020 `terms_indicator` int(11) NOT NULL auto_increment,
1021 `terms` char(80) NOT NULL default '',
1022 `days_before_due` smallint(6) NOT NULL default '0',
1023 `day_in_following_month` smallint(6) NOT NULL default '0',
1024 `inactive` tinyint(1) NOT NULL default '0',
1025 PRIMARY KEY (`terms_indicator`),
1026 UNIQUE KEY `terms` (`terms`)
1027 ) TYPE=MyISAM AUTO_INCREMENT=5 ;
1030 ### Data of table `0_payment_terms` ###
1032 INSERT INTO `0_payment_terms` VALUES ('1', 'Due 15th Of the Following Month', '0', '17', '0');
1033 INSERT INTO `0_payment_terms` VALUES ('2', 'Due By End Of The Following Month', '0', '30', '0');
1034 INSERT INTO `0_payment_terms` VALUES ('3', 'Payment due within 10 days', '10', '0', '0');
1035 INSERT INTO `0_payment_terms` VALUES ('4', 'Cash Only', '1', '0', '0');
1038 ### Structure of table `0_prices` ###
1040 DROP TABLE IF EXISTS `0_prices`;
1042 CREATE TABLE `0_prices` (
1043 `id` int(11) NOT NULL auto_increment,
1044 `stock_id` varchar(20) NOT NULL default '',
1045 `sales_type_id` int(11) NOT NULL default '0',
1046 `curr_abrev` char(3) NOT NULL default '',
1047 `price` double NOT NULL default '0',
1049 UNIQUE KEY `price` (`stock_id`,`sales_type_id`,`curr_abrev`)
1050 ) TYPE=MyISAM AUTO_INCREMENT=5 ;
1053 ### Data of table `0_prices` ###
1055 INSERT INTO `0_prices` VALUES ('1', '3400', '1', 'USD', '100');
1056 INSERT INTO `0_prices` VALUES ('2', '102', '1', 'USD', '50');
1057 INSERT INTO `0_prices` VALUES ('3', '103', '1', 'USD', '55');
1058 INSERT INTO `0_prices` VALUES ('4', '104', '1', 'USD', '60');
1061 ### Structure of table `0_print_profiles` ###
1063 DROP TABLE IF EXISTS `0_print_profiles`;
1065 CREATE TABLE `0_print_profiles` (
1066 `id` smallint(6) unsigned NOT NULL auto_increment,
1067 `profile` varchar(30) NOT NULL,
1068 `report` varchar(5) default NULL,
1069 `printer` tinyint(3) unsigned default NULL,
1071 UNIQUE KEY `profile` (`profile`,`report`)
1072 ) TYPE=MyISAM AUTO_INCREMENT=10 ;
1075 ### Data of table `0_print_profiles` ###
1077 INSERT INTO `0_print_profiles` VALUES ('1', 'Out of office', '', '0');
1078 INSERT INTO `0_print_profiles` VALUES ('2', 'Sales Department', '', '0');
1079 INSERT INTO `0_print_profiles` VALUES ('3', 'Central', '', '2');
1080 INSERT INTO `0_print_profiles` VALUES ('4', 'Sales Department', '104', '2');
1081 INSERT INTO `0_print_profiles` VALUES ('5', 'Sales Department', '105', '2');
1082 INSERT INTO `0_print_profiles` VALUES ('6', 'Sales Department', '107', '2');
1083 INSERT INTO `0_print_profiles` VALUES ('7', 'Sales Department', '109', '2');
1084 INSERT INTO `0_print_profiles` VALUES ('8', 'Sales Department', '110', '2');
1085 INSERT INTO `0_print_profiles` VALUES ('9', 'Sales Department', '201', '2');
1088 ### Structure of table `0_printers` ###
1090 DROP TABLE IF EXISTS `0_printers`;
1092 CREATE TABLE `0_printers` (
1093 `id` tinyint(3) unsigned NOT NULL auto_increment,
1094 `name` varchar(20) NOT NULL,
1095 `description` varchar(60) NOT NULL,
1096 `queue` varchar(20) NOT NULL,
1097 `host` varchar(40) NOT NULL,
1098 `port` smallint(11) unsigned NOT NULL,
1099 `timeout` tinyint(3) unsigned NOT NULL,
1101 UNIQUE KEY `name` (`name`)
1102 ) TYPE=MyISAM AUTO_INCREMENT=4 ;
1105 ### Data of table `0_printers` ###
1107 INSERT INTO `0_printers` VALUES ('1', 'QL500', 'Label printer', 'QL500', 'server', '127', '20');
1108 INSERT INTO `0_printers` VALUES ('2', 'Samsung', 'Main network printer', 'scx4521F', 'server', '515', '5');
1109 INSERT INTO `0_printers` VALUES ('3', 'Local', 'Local print server at user IP', 'lp', '', '515', '10');
1112 ### Structure of table `0_purch_data` ###
1114 DROP TABLE IF EXISTS `0_purch_data`;
1116 CREATE TABLE `0_purch_data` (
1117 `supplier_id` int(11) NOT NULL default '0',
1118 `stock_id` char(20) NOT NULL default '',
1119 `price` double NOT NULL default '0',
1120 `suppliers_uom` char(50) NOT NULL default '',
1121 `conversion_factor` double NOT NULL default '1',
1122 `supplier_description` char(50) NOT NULL default '',
1123 PRIMARY KEY (`supplier_id`,`stock_id`)
1127 ### Data of table `0_purch_data` ###
1129 INSERT INTO `0_purch_data` VALUES ('2', '102', '10', '', '1', '17inch VGA Monitor');
1130 INSERT INTO `0_purch_data` VALUES ('2', '103', '11', '', '1', '32MB VGA Card');
1131 INSERT INTO `0_purch_data` VALUES ('2', '104', '12', '', '1', '52x CD Drive');
1134 ### Structure of table `0_purch_order_details` ###
1136 DROP TABLE IF EXISTS `0_purch_order_details`;
1138 CREATE TABLE `0_purch_order_details` (
1139 `po_detail_item` int(11) NOT NULL auto_increment,
1140 `order_no` int(11) NOT NULL default '0',
1141 `item_code` varchar(20) NOT NULL default '',
1142 `description` tinytext,
1143 `delivery_date` date NOT NULL default '0000-00-00',
1144 `qty_invoiced` double NOT NULL default '0',
1145 `unit_price` double NOT NULL default '0',
1146 `act_price` double NOT NULL default '0',
1147 `std_cost_unit` double NOT NULL default '0',
1148 `quantity_ordered` double NOT NULL default '0',
1149 `quantity_received` double NOT NULL default '0',
1150 PRIMARY KEY (`po_detail_item`)
1151 ) TYPE=InnoDB AUTO_INCREMENT=6 ;
1154 ### Data of table `0_purch_order_details` ###
1156 INSERT INTO `0_purch_order_details` VALUES ('1', '1', '102', '17inch VGA Monitor', '2009-07-01', '100', '10', '10', '10', '100', '100');
1157 INSERT INTO `0_purch_order_details` VALUES ('2', '1', '103', '32MB VGA Card', '2009-07-01', '100', '11', '11', '11', '100', '100');
1158 INSERT INTO `0_purch_order_details` VALUES ('3', '1', '104', '52x CD Drive', '2009-07-01', '100', '12', '12', '12', '100', '100');
1159 INSERT INTO `0_purch_order_details` VALUES ('4', '2', '102', '17inch VGA Monitor', '2009-07-01', '0', '5', '0', '0', '1', '0');
1160 INSERT INTO `0_purch_order_details` VALUES ('5', '2', '103', '32MB VGA Card', '2009-07-01', '0', '5', '0', '0', '1', '0');
1163 ### Structure of table `0_purch_orders` ###
1165 DROP TABLE IF EXISTS `0_purch_orders`;
1167 CREATE TABLE `0_purch_orders` (
1168 `order_no` int(11) NOT NULL auto_increment,
1169 `supplier_id` int(11) NOT NULL default '0',
1170 `comments` tinytext,
1171 `ord_date` date NOT NULL default '0000-00-00',
1172 `reference` tinytext NOT NULL,
1173 `requisition_no` tinytext,
1174 `into_stock_location` varchar(5) NOT NULL default '',
1175 `delivery_address` tinytext NOT NULL,
1176 PRIMARY KEY (`order_no`)
1177 ) TYPE=InnoDB AUTO_INCREMENT=3 ;
1180 ### Data of table `0_purch_orders` ###
1182 INSERT INTO `0_purch_orders` VALUES ('1', '2', '', '2009-06-01', '1', '', 'DEF', 'Delivery 1\r\nDelivery 2\r\nDelivery 3');
1183 INSERT INTO `0_purch_orders` VALUES ('2', '3', '', '2009-06-21', '2', '', 'DEF', 'Delivery 1\r\nDelivery 2\r\nDelivery 3');
1186 ### Structure of table `0_quick_entries` ###
1188 DROP TABLE IF EXISTS `0_quick_entries`;
1190 CREATE TABLE `0_quick_entries` (
1191 `id` smallint(6) unsigned NOT NULL auto_increment,
1192 `type` tinyint(1) NOT NULL default '0',
1193 `description` varchar(60) NOT NULL,
1194 `base_amount` double NOT NULL default '0',
1195 `base_desc` varchar(60) default NULL,
1197 KEY `description` (`description`)
1198 ) TYPE=MyISAM AUTO_INCREMENT=4 ;
1201 ### Data of table `0_quick_entries` ###
1203 INSERT INTO `0_quick_entries` VALUES ('1', '1', 'Maintenance', '0', 'Amount');
1204 INSERT INTO `0_quick_entries` VALUES ('2', '4', 'Phone', '0', 'Amount');
1205 INSERT INTO `0_quick_entries` VALUES ('3', '2', 'Cash Sales', '0', 'Amount');
1208 ### Structure of table `0_quick_entry_lines` ###
1210 DROP TABLE IF EXISTS `0_quick_entry_lines`;
1212 CREATE TABLE `0_quick_entry_lines` (
1213 `id` smallint(6) unsigned NOT NULL auto_increment,
1214 `qid` smallint(6) unsigned NOT NULL,
1215 `amount` double default '0',
1216 `action` varchar(2) NOT NULL,
1217 `dest_id` varchar(11) NOT NULL,
1218 `dimension_id` smallint(6) unsigned default NULL,
1219 `dimension2_id` smallint(6) unsigned default NULL,
1222 ) TYPE=MyISAM AUTO_INCREMENT=8 ;
1225 ### Data of table `0_quick_entry_lines` ###
1227 INSERT INTO `0_quick_entry_lines` VALUES ('1', '1', '0', 't-', '1', '0', '0');
1228 INSERT INTO `0_quick_entry_lines` VALUES ('2', '2', '0', 't-', '1', '0', '0');
1229 INSERT INTO `0_quick_entry_lines` VALUES ('3', '3', '0', 't-', '1', '0', '0');
1230 INSERT INTO `0_quick_entry_lines` VALUES ('4', '3', '0', '=', '4010', '0', '0');
1231 INSERT INTO `0_quick_entry_lines` VALUES ('5', '1', '0', '=', '5765', '0', '0');
1232 INSERT INTO `0_quick_entry_lines` VALUES ('6', '2', '0', '=', '5780', '0', '0');
1235 ### Structure of table `0_recurrent_invoices` ###
1237 DROP TABLE IF EXISTS `0_recurrent_invoices`;
1239 CREATE TABLE `0_recurrent_invoices` (
1240 `id` smallint(6) unsigned NOT NULL auto_increment,
1241 `description` varchar(60) NOT NULL default '',
1242 `order_no` int(11) unsigned NOT NULL,
1243 `debtor_no` int(11) unsigned default NULL,
1244 `group_no` smallint(6) unsigned default NULL,
1245 `days` int(11) NOT NULL default '0',
1246 `monthly` int(11) NOT NULL default '0',
1247 `begin` date NOT NULL default '0000-00-00',
1248 `end` date NOT NULL default '0000-00-00',
1249 `last_sent` date NOT NULL default '0000-00-00',
1251 UNIQUE KEY `description` (`description`)
1252 ) TYPE=InnoDB AUTO_INCREMENT=1 ;
1255 ### Data of table `0_recurrent_invoices` ###
1259 ### Structure of table `0_refs` ###
1261 DROP TABLE IF EXISTS `0_refs`;
1263 CREATE TABLE `0_refs` (
1264 `id` int(11) NOT NULL default '0',
1265 `type` int(11) NOT NULL default '0',
1266 `reference` varchar(100) NOT NULL default '',
1267 PRIMARY KEY (`id`,`type`)
1271 ### Data of table `0_refs` ###
1273 INSERT INTO `0_refs` VALUES ('18', '0', '1');
1274 INSERT INTO `0_refs` VALUES ('19', '0', '2');
1277 ### Structure of table `0_sales_order_details` ###
1279 DROP TABLE IF EXISTS `0_sales_order_details`;
1281 CREATE TABLE `0_sales_order_details` (
1282 `id` int(11) NOT NULL auto_increment,
1283 `order_no` int(11) NOT NULL default '0',
1284 `trans_type` smallint(6) NOT NULL default '30',
1285 `stk_code` varchar(20) NOT NULL default '',
1286 `description` tinytext,
1287 `qty_sent` double NOT NULL default '0',
1288 `unit_price` double NOT NULL default '0',
1289 `quantity` double NOT NULL default '0',
1290 `discount_percent` double NOT NULL default '0',
1292 ) TYPE=InnoDB AUTO_INCREMENT=6 ;
1295 ### Data of table `0_sales_order_details` ###
1297 INSERT INTO `0_sales_order_details` VALUES ('1', '1', '30', '102', '17inch VGA Monitor', '2', '30.4', '2', '0');
1298 INSERT INTO `0_sales_order_details` VALUES ('2', '2', '30', '102', '17inch VGA Monitor', '1', '50', '1', '0');
1299 INSERT INTO `0_sales_order_details` VALUES ('3', '3', '30', '102', '17inch VGA Monitor', '1', '35.89', '1', '0');
1300 INSERT INTO `0_sales_order_details` VALUES ('4', '4', '30', '102', '17inch VGA Monitor', '0', '21.28', '2', '0');
1301 INSERT INTO `0_sales_order_details` VALUES ('5', '5', '30', '102', '17inch VGA Monitor', '1', '50', '1', '0');
1304 ### Structure of table `0_sales_orders` ###
1306 DROP TABLE IF EXISTS `0_sales_orders`;
1308 CREATE TABLE `0_sales_orders` (
1309 `order_no` int(11) NOT NULL,
1310 `trans_type` smallint(6) NOT NULL default '30',
1311 `version` tinyint(1) unsigned NOT NULL default '0',
1312 `type` tinyint(1) NOT NULL default '0',
1313 `debtor_no` int(11) NOT NULL default '0',
1314 `branch_code` int(11) NOT NULL default '0',
1315 `reference` varchar(100) NOT NULL default '',
1316 `customer_ref` tinytext NOT NULL,
1317 `comments` tinytext,
1318 `ord_date` date NOT NULL default '0000-00-00',
1319 `order_type` int(11) NOT NULL default '0',
1320 `ship_via` int(11) NOT NULL default '0',
1321 `delivery_address` tinytext NOT NULL,
1322 `contact_phone` varchar(30) default NULL,
1323 `contact_email` varchar(100) default NULL,
1324 `deliver_to` tinytext NOT NULL,
1325 `freight_cost` double NOT NULL default '0',
1326 `from_stk_loc` varchar(5) NOT NULL default '',
1327 `delivery_date` date NOT NULL default '0000-00-00',
1328 PRIMARY KEY (`trans_type`, `order_no`)
1331 ### Data of table `0_sales_orders` ###
1333 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');
1334 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');
1335 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');
1336 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');
1337 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');
1340 ### Structure of table `0_sales_pos` ###
1342 DROP TABLE IF EXISTS `0_sales_pos`;
1344 CREATE TABLE `0_sales_pos` (
1345 `id` smallint(6) unsigned NOT NULL auto_increment,
1346 `pos_name` varchar(30) NOT NULL,
1347 `cash_sale` tinyint(1) NOT NULL,
1348 `credit_sale` tinyint(1) NOT NULL,
1349 `pos_location` varchar(5) NOT NULL,
1350 `pos_account` smallint(6) unsigned NOT NULL,
1351 `inactive` tinyint(1) NOT NULL default '0',
1353 UNIQUE KEY `pos_name` (`pos_name`)
1354 ) TYPE=MyISAM AUTO_INCREMENT=2 ;
1357 ### Data of table `0_sales_pos` ###
1359 INSERT INTO `0_sales_pos` VALUES ('1', 'Default', '1', '1', 'DEF', '2', '0');
1362 ### Structure of table `0_sales_types` ###
1364 DROP TABLE IF EXISTS `0_sales_types`;
1366 CREATE TABLE `0_sales_types` (
1367 `id` int(11) NOT NULL auto_increment,
1368 `sales_type` char(50) NOT NULL default '',
1369 `tax_included` int(1) NOT NULL default '0',
1370 `factor` double NOT NULL default '1',
1371 `inactive` tinyint(1) NOT NULL default '0',
1373 UNIQUE KEY `sales_type` (`sales_type`)
1374 ) TYPE=MyISAM AUTO_INCREMENT=3 ;
1377 ### Data of table `0_sales_types` ###
1379 INSERT INTO `0_sales_types` VALUES ('1', 'Retail', '1', '1', '0');
1380 INSERT INTO `0_sales_types` VALUES ('2', 'Wholesale', '0', '0.7', '0');
1383 ### Structure of table `0_salesman` ###
1385 DROP TABLE IF EXISTS `0_salesman`;
1387 CREATE TABLE `0_salesman` (
1388 `salesman_code` int(11) NOT NULL auto_increment,
1389 `salesman_name` char(60) NOT NULL default '',
1390 `salesman_phone` char(30) NOT NULL default '',
1391 `salesman_fax` char(30) NOT NULL default '',
1392 `salesman_email` varchar(100) NOT NULL default '',
1393 `provision` double NOT NULL default '0',
1394 `break_pt` double NOT NULL default '0',
1395 `provision2` double NOT NULL default '0',
1396 `inactive` tinyint(1) NOT NULL default '0',
1397 PRIMARY KEY (`salesman_code`),
1398 UNIQUE KEY `salesman_name` (`salesman_name`)
1399 ) TYPE=MyISAM AUTO_INCREMENT=2 ;
1402 ### Data of table `0_salesman` ###
1404 INSERT INTO `0_salesman` VALUES ('1', 'Sales Person', '', '', '', '5', '1000', '4', '0');
1406 ### Structure of table `0_security_roles` ###
1408 DROP TABLE IF EXISTS `0_security_roles`;
1409 CREATE TABLE IF NOT EXISTS `0_security_roles` (
1410 `id` int(11) NOT NULL auto_increment,
1411 `role` varchar(30) NOT NULL,
1412 `description` varchar(50) default NULL,
1415 `inactive` tinyint(1) NOT NULL default '0',
1417 UNIQUE KEY `role` (`role`)
1418 ) TYPE=MyISAM AUTO_INCREMENT=11 ;
1421 -- Data of table `0_security_roles`
1424 INSERT INTO `0_security_roles` VALUES(1, 'Inquiries', 'Inquiries', '768;2816;3072;3328;5632;5888;8192;8448;10752;11008;13312;15872;16128', '257;258;259;260;513;514;515;516;517;518;519;520;521;522;523;524;525;773;774;2822;3073;3075;3076;3077;3329;3330;3331;3332;3333;3334;3335;5377;5633;5640;5889;5891;7937;7938;7939;7940;8193;8194;8450;8451;10497;10753;11009;11010;11012;13313;13315;15617;15618;15619;15620;15621;15622;15623;15624;15625;15626;15873;15882;16129;16130;16131;16132', 0);
1425 INSERT INTO `0_security_roles` VALUES(2, 'System Administrator', 'System Administrator', '256;512;768;2816;3072;3328;5376;5632;5888;7936;8192;8448;10496;10752;11008;13312;15616;15872;16128', '257;258;259;260;513;514;515;516;517;518;519;520;521;522;523;524;525;769;770;771;772;773;774;2817;2818;2819;2820;2821;2822;2823;3073;3074;3075;3076;3077;3078;3079;3080;3081;3329;3330;3331;3332;3333;3334;3335;5377;5633;5634;5635;5636;5637;5638;5639;5640;5641;5889;5891;7937;7938;7939;7940;8193;8194;8195;8196;8197;8449;8450;8451;10497;10753;10754;10755;10756;10757;11009;11010;11012;13313;13314;13315;15617;15618;15619;15620;15621;15622;15623;15624;15625;15626;15873;15874;15875;15876;15877;15878;15879;15880;15881;15882;15883;16129;16130;16131;16132', 0);
1426 INSERT INTO `0_security_roles` VALUES(3, 'Salesman', 'Salesman', '768;3072;5632;8192;15872', '773;774;3073;3075;3081;5633;8194;15873', 0);
1427 INSERT INTO `0_security_roles` VALUES(4, 'Stock Manager', 'Stock Manager', '2816;3072;3328;5632;5888;8192;8448;10752;11008;13312;15872;16128', '2818;2822;3073;3076;3077;3329;3330;3330;3330;3331;3331;3332;3333;3334;3335;5633;5640;5889;5891;8193;8194;8450;8451;10753;11009;11010;11012;13313;13315;15882;16129;16130;16131;16132', 0);
1428 INSERT INTO `0_security_roles` VALUES(5, 'Production Manager', 'Production Manager', '512;2816;3072;3328;5632;5888;8192;8448;10752;11008;13312;15616;15872;16128', '521;523;524;2818;2819;2820;2821;2822;2823;3073;3074;3076;3077;3078;3079;3080;3081;3329;3330;3330;3330;3331;3331;3332;3333;3334;3335;5633;5640;5640;5889;5891;8193;8194;8196;8197;8450;8451;10753;10755;11009;11010;11012;13313;13315;15617;15619;15620;15621;15624;15624;15876;15877;15880;15882;16129;16130;16131;16132', 0);
1429 INSERT INTO `0_security_roles` VALUES(6, 'Purchase Officer', 'Purchase Officer', '512;2816;3072;3328;5376;5632;5888;8192;8448;10752;11008;13312;15616;15872;16128', '521;523;524;2818;2819;2820;2821;2822;2823;3073;3074;3076;3077;3078;3079;3080;3081;3329;3330;3330;3330;3331;3331;3332;3333;3334;3335;5377;5633;5635;5640;5640;5889;5891;8193;8194;8196;8197;8449;8450;8451;10753;10755;11009;11010;11012;13313;13315;15617;15619;15620;15621;15624;15624;15876;15877;15880;15882;16129;16130;16131;16132', 0);
1430 INSERT INTO `0_security_roles` VALUES(7, 'AR Officer', 'AR Officer', '512;768;2816;3072;3328;5632;5888;8192;8448;10752;11008;13312;15616;15872;16128', '521;523;524;771;773;774;2818;2819;2820;2821;2822;2823;3073;3073;3074;3075;3076;3077;3078;3079;3080;3081;3081;3329;3330;3330;3330;3331;3331;3332;3333;3334;3335;5633;5633;5634;5637;5638;5639;5640;5640;5889;5891;8193;8194;8194;8196;8197;8450;8451;10753;10755;11009;11010;11012;13313;13315;15617;15619;15620;15621;15624;15624;15873;15876;15877;15878;15880;15882;16129;16130;16131;16132', 0);
1431 INSERT INTO `0_security_roles` VALUES(8, 'AP Officer', 'AP Officer', '512;2816;3072;3328;5376;5632;5888;8192;8448;10752;11008;13312;15616;15872;16128', '521;523;524;2818;2819;2820;2821;2822;2823;3073;3074;3076;3077;3078;3079;3080;3081;3329;3330;3330;3330;3331;3331;3332;3333;3334;3335;5377;5633;5635;5640;5640;5889;5891;8193;8194;8196;8197;8449;8450;8451;10753;10755;11009;11010;11012;13313;13315;15617;15619;15620;15621;15624;15624;15876;15877;15880;15882;16129;16130;16131;16132', 0);
1432 INSERT INTO `0_security_roles` VALUES(9, 'Accountant', 'New Accountant', '512;768;2816;3072;3328;5376;5632;5888;8192;8448;10752;11008;13312;15616;15872;16128', '257;258;259;260;521;523;524;771;772;773;774;2818;2819;2820;2821;2822;2823;3073;3074;3075;3076;3077;3078;3079;3080;3081;3329;3330;3331;3332;3333;3334;3335;5377;5633;5634;5635;5637;5638;5639;5640;5889;5891;7937;7938;7939;7940;8193;8194;8196;8197;8449;8450;8451;10497;10753;10755;11009;11010;11012;13313;13315;15617;15618;15619;15620;15621;15624;15873;15876;15877;15878;15880;15882;16129;16130;16131;16132', 0);
1433 INSERT INTO `0_security_roles` VALUES(10, 'Sub Admin', 'Sub Admin', '512;768;2816;3072;3328;5376;5632;5888;8192;8448;10752;11008;13312;15616;15872;16128', '521;523;524;771;772;773;774;2818;2819;2820;2821;2822;2823;3073;3073;3074;3075;3076;3077;3078;3079;3080;3081;3081;3329;3330;3330;3330;3331;3331;3332;3333;3334;3335;5377;5633;5633;5634;5635;5637;5638;5639;5640;5640;5889;5891;8193;8194;8194;8196;8197;8449;8450;8451;10753;10755;11009;11010;11012;13313;13315;15617;15619;15620;15621;15624;15624;15873;15873;15874;15876;15877;15878;15879;15880;15882;16129;16129;16130;16130;16131;16132', 0);
1435 ### Structure of table `0_shippers` ###
1437 DROP TABLE IF EXISTS `0_shippers`;
1439 CREATE TABLE `0_shippers` (
1440 `shipper_id` int(11) NOT NULL auto_increment,
1441 `shipper_name` varchar(60) NOT NULL default '',
1442 `phone` varchar(30) NOT NULL default '',
1443 `phone2` varchar(30) NOT NULL default '',
1444 `contact` tinytext NOT NULL,
1445 `address` tinytext NOT NULL,
1446 `inactive` tinyint(1) NOT NULL default '0',
1447 PRIMARY KEY (`shipper_id`),
1448 UNIQUE KEY `name` (`shipper_name`)
1449 ) TYPE=MyISAM AUTO_INCREMENT=2 ;
1452 ### Data of table `0_shippers` ###
1454 INSERT INTO `0_shippers` VALUES ('1', 'Default', '', '', '', '', '0');
1457 ### Structure of table `0_sql_trail` ###
1459 DROP TABLE IF EXISTS `0_sql_trail`;
1461 CREATE TABLE `0_sql_trail` (
1462 `id` int(11) unsigned NOT NULL auto_increment,
1463 `sql` text NOT NULL,
1464 `result` tinyint(1) NOT NULL,
1465 `msg` varchar(255) NOT NULL,
1467 ) TYPE=MyISAM AUTO_INCREMENT=1 ;
1470 ### Data of table `0_sql_trail` ###
1474 ### Structure of table `0_stock_category` ###
1476 DROP TABLE IF EXISTS `0_stock_category`;
1478 CREATE TABLE `0_stock_category` (
1479 `category_id` int(11) NOT NULL auto_increment,
1480 `description` varchar(60) NOT NULL default '',
1481 `dflt_tax_type` int(11) NOT NULL default '1',
1482 `dflt_units` varchar(20) NOT NULL default 'each',
1483 `dflt_mb_flag` char(1) NOT NULL default 'B',
1484 `dflt_sales_act` varchar(11) NOT NULL default '',
1485 `dflt_cogs_act` varchar(11) NOT NULL default '',
1486 `dflt_inventory_act` varchar(11) NOT NULL default '',
1487 `dflt_adjustment_act` varchar(11) NOT NULL default '',
1488 `dflt_assembly_act` varchar(11) NOT NULL default '',
1489 `dflt_dim1` int(11) default NULL,
1490 `dflt_dim2` int(11) default NULL,
1491 `inactive` tinyint(1) NOT NULL default '0',
1492 `dflt_no_sale` tinyint(1) NOT NULL default '0',
1493 PRIMARY KEY (`category_id`),
1494 UNIQUE KEY `description` (`description`)
1495 ) TYPE=MyISAM AUTO_INCREMENT=5 ;
1497 ### Data of table `0_stock_category` ###
1499 INSERT INTO `0_stock_category` VALUES ('1', 'Components', '1', 'each', 'B', '4010', '5010', '1510', '5040', '1530', '0', '0', '0', '0');
1500 INSERT INTO `0_stock_category` VALUES ('2', 'Charges', '1', 'each', 'D', '4010', '5010', '1510', '5040', '1530', '0', '0', '0', '0');
1501 INSERT INTO `0_stock_category` VALUES ('3', 'Systems', '1', 'each', 'M', '4010', '5010', '1510', '5040', '1530', '0', '0', '0', '0');
1502 INSERT INTO `0_stock_category` VALUES ('4', 'Services', '1', 'hrs', 'D', '4010', '5010', '1510', '5040', '1530', '0', '0', '0', '0');
1505 ### Structure of table `0_stock_master` ###
1507 DROP TABLE IF EXISTS `0_stock_master`;
1509 CREATE TABLE `0_stock_master` (
1510 `stock_id` varchar(20) NOT NULL default '',
1511 `category_id` int(11) NOT NULL default '0',
1512 `tax_type_id` int(11) NOT NULL default '0',
1513 `description` varchar(200) NOT NULL default '',
1514 `long_description` tinytext NOT NULL,
1515 `units` varchar(20) NOT NULL default 'each',
1516 `mb_flag` char(1) NOT NULL default 'B',
1517 `sales_account` varchar(11) NOT NULL default '',
1518 `cogs_account` varchar(11) NOT NULL default '',
1519 `inventory_account` varchar(11) NOT NULL default '',
1520 `adjustment_account` varchar(11) NOT NULL default '',
1521 `assembly_account` varchar(11) NOT NULL default '',
1522 `dimension_id` int(11) default NULL,
1523 `dimension2_id` int(11) default NULL,
1524 `actual_cost` double NOT NULL default '0',
1525 `last_cost` double NOT NULL default '0',
1526 `material_cost` double NOT NULL default '0',
1527 `labour_cost` double NOT NULL default '0',
1528 `overhead_cost` double NOT NULL default '0',
1529 `inactive` tinyint(1) NOT NULL default '0',
1530 `no_sale` tinyint(1) NOT NULL default '0',
1531 PRIMARY KEY (`stock_id`)
1535 ### Data of table `0_stock_master` ###
1537 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');
1538 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');
1539 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');
1540 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');
1541 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');
1544 ### Structure of table `0_stock_moves` ###
1546 DROP TABLE IF EXISTS `0_stock_moves`;
1548 CREATE TABLE `0_stock_moves` (
1549 `trans_id` int(11) NOT NULL auto_increment,
1550 `trans_no` int(11) NOT NULL default '0',
1551 `stock_id` char(20) NOT NULL default '',
1552 `type` smallint(6) NOT NULL default '0',
1553 `loc_code` char(5) NOT NULL default '',
1554 `tran_date` date NOT NULL default '0000-00-00',
1555 `person_id` int(11) default NULL,
1556 `price` double NOT NULL default '0',
1557 `reference` char(40) NOT NULL default '',
1558 `qty` double NOT NULL default '1',
1559 `discount_percent` double NOT NULL default '0',
1560 `standard_cost` double NOT NULL default '0',
1561 `visible` tinyint(1) NOT NULL default '1',
1562 PRIMARY KEY (`trans_id`),
1563 KEY `type` (`type`,`trans_no`)
1564 ) TYPE=InnoDB AUTO_INCREMENT=37 ;
1567 ### Data of table `0_stock_moves` ###
1569 INSERT INTO `0_stock_moves` VALUES ('1', '1', '102', '25', 'DEF', '2009-06-21', '2', '10', '', '100', '0', '10', '1');
1570 INSERT INTO `0_stock_moves` VALUES ('2', '1', '103', '25', 'DEF', '2009-06-21', '2', '11', '', '100', '0', '11', '1');
1571 INSERT INTO `0_stock_moves` VALUES ('3', '1', '104', '25', 'DEF', '2009-06-21', '2', '12', '', '100', '0', '12', '1');
1572 INSERT INTO `0_stock_moves` VALUES ('4', '1', '102', '26', 'DEF', '2009-06-21', '0', '0', '1', '-10', '0', '0', '1');
1573 INSERT INTO `0_stock_moves` VALUES ('5', '1', '103', '26', 'DEF', '2009-06-21', '0', '0', '1', '-10', '0', '0', '1');
1574 INSERT INTO `0_stock_moves` VALUES ('6', '1', '104', '26', 'DEF', '2009-06-21', '0', '0', '1', '-10', '0', '0', '1');
1575 INSERT INTO `0_stock_moves` VALUES ('7', '1', '3400', '26', 'DEF', '2009-06-21', '0', '0', '1', '10', '0', '0', '1');
1576 INSERT INTO `0_stock_moves` VALUES ('8', '2', '102', '13', 'DEF', '2009-06-21', '0', '30.4', '1', '-2', '0', '10', '1');
1577 INSERT INTO `0_stock_moves` VALUES ('9', '3', '102', '13', 'DEF', '2009-06-21', '0', '50', 'auto', '-1', '0', '10', '1');
1578 INSERT INTO `0_stock_moves` VALUES ('10', '4', '102', '13', 'DEF', '2009-06-21', '0', '35.89', 'auto', '-1', '0', '10', '1');
1579 INSERT INTO `0_stock_moves` VALUES ('11', '3', '102', '26', 'DEF', '2009-06-21', '0', '0', '3', '-2', '0', '0', '1');
1580 INSERT INTO `0_stock_moves` VALUES ('12', '3', '103', '26', 'DEF', '2009-06-21', '0', '0', '3', '-2', '0', '0', '1');
1581 INSERT INTO `0_stock_moves` VALUES ('13', '3', '104', '26', 'DEF', '2009-06-21', '0', '0', '3', '-2', '0', '0', '1');
1582 INSERT INTO `0_stock_moves` VALUES ('14', '3', '3400', '26', 'DEF', '2009-06-21', '0', '0', '3', '2', '0', '0', '1');
1583 INSERT INTO `0_stock_moves` VALUES ('15', '4', '102', '26', 'DEF', '2009-06-21', '0', '0', '4', '-4', '0', '0', '1');
1584 INSERT INTO `0_stock_moves` VALUES ('16', '4', '103', '26', 'DEF', '2009-06-21', '0', '0', '4', '-4', '0', '0', '1');
1585 INSERT INTO `0_stock_moves` VALUES ('17', '4', '104', '26', 'DEF', '2009-06-21', '0', '0', '4', '-4', '0', '0', '1');
1586 INSERT INTO `0_stock_moves` VALUES ('18', '4', '3400', '26', 'DEF', '2009-06-21', '0', '0', '4', '4', '0', '0', '1');
1587 INSERT INTO `0_stock_moves` VALUES ('19', '2', '102', '26', 'DEF', '2009-06-21', '0', '0', '', '-2', '0', '0', '1');
1588 INSERT INTO `0_stock_moves` VALUES ('20', '2', '103', '26', 'DEF', '2009-06-21', '0', '0', '', '-2', '0', '0', '1');
1589 INSERT INTO `0_stock_moves` VALUES ('21', '2', '104', '26', 'DEF', '2009-06-21', '0', '0', '', '-2', '0', '0', '1');
1590 INSERT INTO `0_stock_moves` VALUES ('22', '1', '3400', '29', 'DEF', '2009-06-21', '0', '0', '', '2', '0', '0', '1');
1591 INSERT INTO `0_stock_moves` VALUES ('23', '5', '102', '26', 'DEF', '2009-06-21', '0', '0', '5', '-5', '0', '0', '1');
1592 INSERT INTO `0_stock_moves` VALUES ('24', '5', '103', '26', 'DEF', '2009-06-21', '0', '0', '5', '-5', '0', '0', '1');
1593 INSERT INTO `0_stock_moves` VALUES ('25', '5', '104', '26', 'DEF', '2009-06-21', '0', '0', '5', '-5', '0', '0', '1');
1594 INSERT INTO `0_stock_moves` VALUES ('26', '5', '3400', '26', 'DEF', '2009-06-21', '0', '0', '5', '5', '0', '0', '1');
1595 INSERT INTO `0_stock_moves` VALUES ('27', '6', '102', '26', 'DEF', '2009-06-21', '0', '0', '6', '5', '0', '0', '1');
1596 INSERT INTO `0_stock_moves` VALUES ('28', '6', '103', '26', 'DEF', '2009-06-21', '0', '0', '6', '5', '0', '0', '1');
1597 INSERT INTO `0_stock_moves` VALUES ('29', '6', '104', '26', 'DEF', '2009-06-21', '0', '0', '6', '5', '0', '0', '1');
1598 INSERT INTO `0_stock_moves` VALUES ('30', '6', '3400', '26', 'DEF', '2009-06-21', '0', '0', '6', '-5', '0', '0', '1');
1599 INSERT INTO `0_stock_moves` VALUES ('31', '7', '102', '26', 'DEF', '2009-06-21', '0', '0', '7', '2', '0', '0', '1');
1600 INSERT INTO `0_stock_moves` VALUES ('32', '7', '103', '26', 'DEF', '2009-06-21', '0', '0', '7', '2', '0', '0', '1');
1601 INSERT INTO `0_stock_moves` VALUES ('33', '7', '104', '26', 'DEF', '2009-06-21', '0', '0', '7', '2', '0', '0', '1');
1602 INSERT INTO `0_stock_moves` VALUES ('34', '7', '3400', '26', 'DEF', '2009-06-21', '0', '0', '7', '-2', '0', '0', '1');
1603 INSERT INTO `0_stock_moves` VALUES ('35', '5', '102', '13', 'DEF', '2009-06-21', '0', '50', 'auto', '-1', '0', '10', '1');
1604 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');
1607 ### Structure of table `0_supp_allocations` ###
1609 DROP TABLE IF EXISTS `0_supp_allocations`;
1611 CREATE TABLE `0_supp_allocations` (
1612 `id` int(11) NOT NULL auto_increment,
1613 `amt` double unsigned default NULL,
1614 `date_alloc` date NOT NULL default '0000-00-00',
1615 `trans_no_from` int(11) default NULL,
1616 `trans_type_from` int(11) default NULL,
1617 `trans_no_to` int(11) default NULL,
1618 `trans_type_to` int(11) default NULL,
1620 ) TYPE=InnoDB AUTO_INCREMENT=2 ;
1623 ### Data of table `0_supp_allocations` ###
1625 INSERT INTO `0_supp_allocations` VALUES ('1', '3465', '2009-06-21', '4', '22', '7', '20');
1628 ### Structure of table `0_supp_invoice_items` ###
1630 DROP TABLE IF EXISTS `0_supp_invoice_items`;
1632 CREATE TABLE `0_supp_invoice_items` (
1633 `id` int(11) NOT NULL auto_increment,
1634 `supp_trans_no` int(11) default NULL,
1635 `supp_trans_type` int(11) default NULL,
1636 `gl_code` varchar(11) NOT NULL default '0',
1637 `grn_item_id` int(11) default NULL,
1638 `po_detail_item_id` int(11) default NULL,
1639 `stock_id` varchar(20) NOT NULL default '',
1640 `description` tinytext,
1641 `quantity` double NOT NULL default '0',
1642 `unit_price` double NOT NULL default '0',
1643 `unit_tax` double NOT NULL default '0',
1646 ) TYPE=InnoDB AUTO_INCREMENT=6 ;
1649 ### Data of table `0_supp_invoice_items` ###
1651 INSERT INTO `0_supp_invoice_items` VALUES ('1', '7', '20', '0', '1', '1', '102', '17inch VGA Monitor', '100', '10', '0.5', '');
1652 INSERT INTO `0_supp_invoice_items` VALUES ('2', '7', '20', '0', '2', '2', '103', '32MB VGA Card', '100', '11', '0.55', '');
1653 INSERT INTO `0_supp_invoice_items` VALUES ('3', '7', '20', '0', '3', '3', '104', '52x CD Drive', '100', '12', '0.6', '');
1654 INSERT INTO `0_supp_invoice_items` VALUES ('4', '8', '20', '2150', '0', '0', '', '', '0', '0.95', '0', 'Phone');
1655 INSERT INTO `0_supp_invoice_items` VALUES ('5', '8', '20', '5780', '0', '0', '', '', '0', '19.05', '0', 'Phone');
1658 ### Structure of table `0_supp_trans` ###
1660 DROP TABLE IF EXISTS `0_supp_trans`;
1662 CREATE TABLE `0_supp_trans` (
1663 `trans_no` int(11) unsigned NOT NULL default '0',
1664 `type` smallint(6) unsigned NOT NULL default '0',
1665 `supplier_id` int(11) unsigned default NULL,
1666 `reference` tinytext NOT NULL,
1667 `supp_reference` varchar(60) NOT NULL default '',
1668 `tran_date` date NOT NULL default '0000-00-00',
1669 `due_date` date NOT NULL default '0000-00-00',
1670 `ov_amount` double NOT NULL default '0',
1671 `ov_discount` double NOT NULL default '0',
1672 `ov_gst` double NOT NULL default '0',
1673 `rate` double NOT NULL default '1',
1674 `alloc` double NOT NULL default '0',
1675 PRIMARY KEY (`trans_no`,`type`),
1676 KEY `supplier_id` (`supplier_id`),
1677 KEY `SupplierID_2` (`supplier_id`,`supp_reference`),
1682 ### Data of table `0_supp_trans` ###
1684 INSERT INTO `0_supp_trans` VALUES ('4', '22', '2', '1', '', '2009-06-21', '2009-06-21', '-3465', '0', '0', '1', '3465');
1685 INSERT INTO `0_supp_trans` VALUES ('7', '20', '2', '1', '5t', '2009-06-21', '2009-07-01', '3300', '0', '165', '1', '3465');
1686 INSERT INTO `0_supp_trans` VALUES ('8', '20', '2', '2', 'cc', '2009-06-21', '2009-07-01', '20', '0', '0', '1', '0');
1689 ### Structure of table `0_suppliers` ###
1691 DROP TABLE IF EXISTS `0_suppliers`;
1693 CREATE TABLE `0_suppliers` (
1694 `supplier_id` int(11) NOT NULL auto_increment,
1695 `supp_name` varchar(60) NOT NULL default '',
1696 `supp_ref` varchar(30) NOT NULL default '',
1697 `address` tinytext NOT NULL,
1698 `supp_address` tinytext NOT NULL,
1699 `phone` varchar(30) NOT NULL default '',
1700 `phone2` varchar(30) NOT NULL default '',
1701 `fax` varchar(30) NOT NULL default '',
1702 `gst_no` varchar(25) NOT NULL default '',
1703 `contact` varchar(60) NOT NULL default '',
1704 `supp_account_no` varchar(40) NOT NULL default '',
1705 `email` varchar(100) NOT NULL default '',
1706 `website` varchar(100) NOT NULL default '',
1707 `bank_account` varchar(60) NOT NULL default '',
1708 `curr_code` char(3) default NULL,
1709 `payment_terms` int(11) default NULL,
1710 `dimension_id` int(11) default '0',
1711 `dimension2_id` int(11) default '0',
1712 `tax_group_id` int(11) default NULL,
1713 `credit_limit` double NOT NULL default '0',
1714 `purchase_account` varchar(11) default NULL,
1715 `payable_account` varchar(11) default NULL,
1716 `payment_discount_account` varchar(11) default NULL,
1717 `notes` tinytext NOT NULL,
1718 `inactive` tinyint(1) NOT NULL default '0',
1719 PRIMARY KEY (`supplier_id`)
1720 ) TYPE=MyISAM AUTO_INCREMENT=4 ;
1723 ### Data of table `0_suppliers` ###
1725 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');
1726 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');
1727 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');
1730 ### Structure of table `0_sys_types` ###
1732 DROP TABLE IF EXISTS `0_sys_types`;
1734 CREATE TABLE `0_sys_types` (
1735 `type_id` smallint(6) NOT NULL default '0',
1736 `type_no` int(11) NOT NULL default '1',
1737 `next_reference` varchar(100) NOT NULL default '',
1738 PRIMARY KEY (`type_id`)
1742 ### Data of table `0_sys_types` ###
1744 INSERT INTO `0_sys_types` VALUES ('0', '19', '3');
1745 INSERT INTO `0_sys_types` VALUES ('1', '8', '2');
1746 INSERT INTO `0_sys_types` VALUES ('2', '5', '2');
1747 INSERT INTO `0_sys_types` VALUES ('4', '3', '1');
1748 INSERT INTO `0_sys_types` VALUES ('10', '19', '4');
1749 INSERT INTO `0_sys_types` VALUES ('11', '3', '2');
1750 INSERT INTO `0_sys_types` VALUES ('12', '6', '1');
1751 INSERT INTO `0_sys_types` VALUES ('13', '5', '2');
1752 INSERT INTO `0_sys_types` VALUES ('16', '2', '1');
1753 INSERT INTO `0_sys_types` VALUES ('17', '2', '1');
1754 INSERT INTO `0_sys_types` VALUES ('18', '1', '3');
1755 INSERT INTO `0_sys_types` VALUES ('20', '8', '3');
1756 INSERT INTO `0_sys_types` VALUES ('21', '1', '1');
1757 INSERT INTO `0_sys_types` VALUES ('22', '4', '2');
1758 INSERT INTO `0_sys_types` VALUES ('25', '1', '2');
1759 INSERT INTO `0_sys_types` VALUES ('26', '1', '8');
1760 INSERT INTO `0_sys_types` VALUES ('28', '1', '1');
1761 INSERT INTO `0_sys_types` VALUES ('29', '1', '2');
1762 INSERT INTO `0_sys_types` VALUES ('30', '5', '6');
1763 INSERT INTO `0_sys_types` VALUES ('32', '0', '1');
1764 INSERT INTO `0_sys_types` VALUES ('35', '1', '1');
1765 INSERT INTO `0_sys_types` VALUES ('40', '1', '3');
1768 ### Structure of table `0_tax_group_items` ###
1770 DROP TABLE IF EXISTS `0_tax_group_items`;
1772 CREATE TABLE `0_tax_group_items` (
1773 `tax_group_id` int(11) NOT NULL default '0',
1774 `tax_type_id` int(11) NOT NULL default '0',
1775 `rate` double NOT NULL default '0',
1776 PRIMARY KEY (`tax_group_id`,`tax_type_id`)
1780 ### Data of table `0_tax_group_items` ###
1782 INSERT INTO `0_tax_group_items` VALUES ('1', '1', '5');
1785 ### Structure of table `0_tax_groups` ###
1787 DROP TABLE IF EXISTS `0_tax_groups`;
1789 CREATE TABLE `0_tax_groups` (
1790 `id` int(11) NOT NULL auto_increment,
1791 `name` varchar(60) NOT NULL default '',
1792 `tax_shipping` tinyint(1) NOT NULL default '0',
1793 `inactive` tinyint(1) NOT NULL default '0',
1795 UNIQUE KEY `name` (`name`)
1796 ) TYPE=InnoDB AUTO_INCREMENT=3 ;
1799 ### Data of table `0_tax_groups` ###
1801 INSERT INTO `0_tax_groups` VALUES ('1', 'Tax', '0', '0');
1802 INSERT INTO `0_tax_groups` VALUES ('2', 'Tax Exempt', '0', '0');
1804 ### Structure of table `0_tax_types` ###
1806 DROP TABLE IF EXISTS `0_tax_types`;
1808 CREATE TABLE `0_tax_types` (
1809 `id` int(11) NOT NULL auto_increment,
1810 `rate` double NOT NULL default '0',
1811 `sales_gl_code` varchar(11) NOT NULL default '',
1812 `purchasing_gl_code` varchar(11) NOT NULL default '',
1813 `name` varchar(60) NOT NULL default '',
1814 `inactive` tinyint(1) NOT NULL default '0',
1816 ) TYPE=InnoDB AUTO_INCREMENT=5 AUTO_INCREMENT=5 ;
1819 ### Data of table `0_tax_types` ###
1821 INSERT INTO `0_tax_types` VALUES ('1', '5', '2150', '2150', 'Tax', '0');
1823 ### Structure of table `0_trans_tax_details` ###
1825 DROP TABLE IF EXISTS `0_trans_tax_details`;
1827 CREATE TABLE `0_trans_tax_details` (
1828 `id` int(11) NOT NULL auto_increment,
1829 `trans_type` smallint(6) default NULL,
1830 `trans_no` int(11) default NULL,
1831 `tran_date` date NOT NULL,
1832 `tax_type_id` int(11) NOT NULL default '0',
1833 `rate` double NOT NULL default '0',
1834 `ex_rate` double NOT NULL default '1',
1835 `included_in_price` tinyint(1) NOT NULL default '0',
1836 `net_amount` double NOT NULL default '0',
1837 `amount` double NOT NULL default '0',
1840 ) TYPE=InnoDB AUTO_INCREMENT=12 ;
1843 ### Data of table `0_trans_tax_details` ###
1845 INSERT INTO `0_trans_tax_details` VALUES ('1', '20', '7', '2009-06-21', '1', '5', '1', '0', '3300', '165', '5t');
1846 INSERT INTO `0_trans_tax_details` VALUES ('2', '13', '3', '2009-06-21', '1', '5', '1', '0', '50', '2.5', 'auto');
1847 INSERT INTO `0_trans_tax_details` VALUES ('3', '10', '17', '2009-06-21', '1', '5', '1', '0', '50', '2.5', '1');
1848 INSERT INTO `0_trans_tax_details` VALUES ('4', '13', '4', '2009-06-21', '1', '5', '1.3932', '0', '35.89', '1.7945', 'auto');
1849 INSERT INTO `0_trans_tax_details` VALUES ('5', '10', '18', '2009-06-21', '1', '5', '1.3932', '0', '35.89', '1.7945', '2');
1850 INSERT INTO `0_trans_tax_details` VALUES ('6', '2', '5', '2009-06-21', '1', '5', '1', '0', '95.2', '4.76', '');
1851 INSERT INTO `0_trans_tax_details` VALUES ('7', '1', '8', '2009-06-21', '1', '5', '1', '0', '-47.6', '-2.38', '');
1852 INSERT INTO `0_trans_tax_details` VALUES ('8', '20', '8', '2009-06-21', '1', '5', '1', '0', '-19', '-0.95', 'cc');
1853 INSERT INTO `0_trans_tax_details` VALUES ('9', '13', '5', '2009-06-21', '1', '5', '1', '1', '47.619047619048', '2.3809523809524', 'auto');
1854 INSERT INTO `0_trans_tax_details` VALUES ('10', '10', '19', '2009-06-21', '1', '5', '1', '1', '47.619047619048', '2.3809523809524', '3');
1855 INSERT INTO `0_trans_tax_details` VALUES ('11', '11', '3', '2009-06-21', '1', '5', '1.3932', '0', '35.89', '1.7945', '1');
1857 ### Structure of table `0_users` ###
1859 DROP TABLE IF EXISTS `0_users`;
1861 CREATE TABLE `0_users` (
1862 `id` SMALLINT(6) AUTO_INCREMENT,
1863 `user_id` varchar(60) NOT NULL default '',
1864 `password` varchar(100) NOT NULL default '',
1865 `real_name` varchar(100) NOT NULL default '',
1866 `role_id` int(11) NOT NULL default '1',
1867 `phone` varchar(30) NOT NULL default '',
1868 `email` varchar(100) default NULL,
1869 `language` varchar(20) default NULL,
1870 `date_format` tinyint(1) NOT NULL default '0',
1871 `date_sep` tinyint(1) NOT NULL default '0',
1872 `tho_sep` tinyint(1) NOT NULL default '0',
1873 `dec_sep` tinyint(1) NOT NULL default '0',
1874 `theme` varchar(20) NOT NULL default 'default',
1875 `page_size` varchar(20) NOT NULL default 'A4',
1876 `prices_dec` smallint(6) NOT NULL default '2',
1877 `qty_dec` smallint(6) NOT NULL default '2',
1878 `rates_dec` smallint(6) NOT NULL default '4',
1879 `percent_dec` smallint(6) NOT NULL default '1',
1880 `show_gl` tinyint(1) NOT NULL default '1',
1881 `show_codes` tinyint(1) NOT NULL default '0',
1882 `show_hints` tinyint(1) NOT NULL default '0',
1883 `last_visit_date` datetime default NULL,
1884 `query_size` tinyint(1) default '10',
1885 `graphic_links` tinyint(1) default '1',
1886 `pos` smallint(6) default '1',
1887 `print_profile` varchar(30) NOT NULL default '1',
1888 `rep_popup` tinyint(1) default '1',
1889 `sticky_doc_date` tinyint(1) default '0',
1890 `startup_tab` varchar(20) NOT NULL default '',
1891 `inactive` tinyint(1) NOT NULL default '0',
1893 UNIQUE KEY (`user_id`)
1894 ) TYPE=MyISAM AUTO_INCREMENT=2;
1897 ### Data of table `0_users` ###
1899 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');
1900 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');
1902 ### Structure of table `0_voided` ###
1904 DROP TABLE IF EXISTS `0_voided`;
1906 CREATE TABLE `0_voided` (
1907 `type` int(11) NOT NULL default '0',
1908 `id` int(11) NOT NULL default '0',
1909 `date_` date NOT NULL default '0000-00-00',
1910 `memo_` tinytext NOT NULL,
1911 UNIQUE KEY `id` (`type`,`id`)
1915 ### Data of table `0_voided` ###
1919 ### Structure of table `0_wo_issue_items` ###
1921 DROP TABLE IF EXISTS `0_wo_issue_items`;
1923 CREATE TABLE `0_wo_issue_items` (
1924 `id` int(11) NOT NULL auto_increment,
1925 `stock_id` varchar(40) default NULL,
1926 `issue_id` int(11) default NULL,
1927 `qty_issued` double default NULL,
1929 ) TYPE=InnoDB AUTO_INCREMENT=1 ;
1932 ### Data of table `0_wo_issue_items` ###
1936 ### Structure of table `0_wo_issues` ###
1938 DROP TABLE IF EXISTS `0_wo_issues`;
1940 CREATE TABLE `0_wo_issues` (
1941 `issue_no` int(11) NOT NULL auto_increment,
1942 `workorder_id` int(11) NOT NULL default '0',
1943 `reference` varchar(100) default NULL,
1944 `issue_date` date default NULL,
1945 `loc_code` varchar(5) default NULL,
1946 `workcentre_id` int(11) default NULL,
1947 PRIMARY KEY (`issue_no`)
1948 ) TYPE=InnoDB AUTO_INCREMENT=1 ;
1951 ### Data of table `0_wo_issues` ###
1955 ### Structure of table `0_wo_manufacture` ###
1957 DROP TABLE IF EXISTS `0_wo_manufacture`;
1959 CREATE TABLE `0_wo_manufacture` (
1960 `id` int(11) NOT NULL auto_increment,
1961 `reference` varchar(100) default NULL,
1962 `workorder_id` int(11) NOT NULL default '0',
1963 `quantity` double NOT NULL default '0',
1964 `date_` date NOT NULL default '0000-00-00',
1966 ) TYPE=InnoDB AUTO_INCREMENT=2 ;
1969 ### Data of table `0_wo_manufacture` ###
1971 INSERT INTO `0_wo_manufacture` VALUES ('1', '1', '2', '2', '2009-06-21');
1974 ### Structure of table `0_wo_requirements` ###
1976 DROP TABLE IF EXISTS `0_wo_requirements`;
1978 CREATE TABLE `0_wo_requirements` (
1979 `id` int(11) NOT NULL auto_increment,
1980 `workorder_id` int(11) NOT NULL default '0',
1981 `stock_id` char(20) NOT NULL default '',
1982 `workcentre` int(11) NOT NULL default '0',
1983 `units_req` double NOT NULL default '1',
1984 `std_cost` double NOT NULL default '0',
1985 `loc_code` char(5) NOT NULL default '',
1986 `units_issued` double NOT NULL default '0',
1988 ) TYPE=InnoDB AUTO_INCREMENT=22 ;
1991 ### Data of table `0_wo_requirements` ###
1993 INSERT INTO `0_wo_requirements` VALUES ('1', '1', '102', '1', '1', '0', 'DEF', '10');
1994 INSERT INTO `0_wo_requirements` VALUES ('2', '1', '103', '1', '1', '0', 'DEF', '10');
1995 INSERT INTO `0_wo_requirements` VALUES ('3', '1', '104', '1', '1', '0', 'DEF', '10');
1996 INSERT INTO `0_wo_requirements` VALUES ('4', '2', '102', '1', '1', '0', 'DEF', '0');
1997 INSERT INTO `0_wo_requirements` VALUES ('5', '2', '103', '1', '1', '0', 'DEF', '0');
1998 INSERT INTO `0_wo_requirements` VALUES ('6', '2', '104', '1', '1', '0', 'DEF', '0');
1999 INSERT INTO `0_wo_requirements` VALUES ('7', '3', '102', '1', '1', '0', 'DEF', '2');
2000 INSERT INTO `0_wo_requirements` VALUES ('8', '3', '103', '1', '1', '0', 'DEF', '2');
2001 INSERT INTO `0_wo_requirements` VALUES ('9', '3', '104', '1', '1', '0', 'DEF', '2');
2002 INSERT INTO `0_wo_requirements` VALUES ('10', '4', '102', '1', '1', '0', 'DEF', '4');
2003 INSERT INTO `0_wo_requirements` VALUES ('11', '4', '103', '1', '1', '0', 'DEF', '4');
2004 INSERT INTO `0_wo_requirements` VALUES ('12', '4', '104', '1', '1', '0', 'DEF', '4');
2005 INSERT INTO `0_wo_requirements` VALUES ('13', '5', '102', '1', '1', '0', 'DEF', '5');
2006 INSERT INTO `0_wo_requirements` VALUES ('14', '5', '103', '1', '1', '0', 'DEF', '5');
2007 INSERT INTO `0_wo_requirements` VALUES ('15', '5', '104', '1', '1', '0', 'DEF', '5');
2008 INSERT INTO `0_wo_requirements` VALUES ('16', '6', '102', '1', '1', '0', 'DEF', '-5');
2009 INSERT INTO `0_wo_requirements` VALUES ('17', '6', '103', '1', '1', '0', 'DEF', '-5');
2010 INSERT INTO `0_wo_requirements` VALUES ('18', '6', '104', '1', '1', '0', 'DEF', '-5');
2011 INSERT INTO `0_wo_requirements` VALUES ('19', '7', '102', '1', '1', '0', 'DEF', '-2');
2012 INSERT INTO `0_wo_requirements` VALUES ('20', '7', '103', '1', '1', '0', 'DEF', '-2');
2013 INSERT INTO `0_wo_requirements` VALUES ('21', '7', '104', '1', '1', '0', 'DEF', '-2');
2016 ### Structure of table `0_workcentres` ###
2018 DROP TABLE IF EXISTS `0_workcentres`;
2020 CREATE TABLE `0_workcentres` (
2021 `id` int(11) NOT NULL auto_increment,
2022 `name` char(40) NOT NULL default '',
2023 `description` char(50) NOT NULL default '',
2024 `inactive` tinyint(1) NOT NULL default '0',
2026 UNIQUE KEY `name` (`name`)
2027 ) TYPE=MyISAM AUTO_INCREMENT=2 ;
2030 ### Data of table `0_workcentres` ###
2032 INSERT INTO `0_workcentres` VALUES ('1', 'Workshop', 'Workshop in Alabama', '0');
2035 ### Structure of table `0_workorders` ###
2037 DROP TABLE IF EXISTS `0_workorders`;
2039 CREATE TABLE `0_workorders` (
2040 `id` int(11) NOT NULL auto_increment,
2041 `wo_ref` varchar(60) NOT NULL default '',
2042 `loc_code` varchar(5) NOT NULL default '',
2043 `units_reqd` double NOT NULL default '1',
2044 `stock_id` varchar(20) NOT NULL default '',
2045 `date_` date NOT NULL default '0000-00-00',
2046 `type` tinyint(4) NOT NULL default '0',
2047 `required_by` date NOT NULL default '0000-00-00',
2048 `released_date` date NOT NULL default '0000-00-00',
2049 `units_issued` double NOT NULL default '0',
2050 `closed` tinyint(1) NOT NULL default '0',
2051 `released` tinyint(1) NOT NULL default '0',
2052 `additional_costs` double NOT NULL default '0',
2054 UNIQUE KEY `wo_ref` (`wo_ref`)
2055 ) TYPE=InnoDB AUTO_INCREMENT=8 ;
2058 ### Data of table `0_workorders` ###
2060 INSERT INTO `0_workorders` VALUES ('1', '1', 'DEF', '10', '3400', '2009-06-21', '0', '2009-06-21', '2009-06-21', '10', '1', '1', '10');
2061 INSERT INTO `0_workorders` VALUES ('2', '2', 'DEF', '3', '3400', '2009-06-21', '2', '2009-07-11', '2009-06-21', '2', '0', '1', '0');
2062 INSERT INTO `0_workorders` VALUES ('3', '3', 'DEF', '2', '3400', '2009-06-21', '0', '2009-06-21', '2009-06-21', '2', '1', '1', '0');
2063 INSERT INTO `0_workorders` VALUES ('4', '4', 'DEF', '4', '3400', '2009-06-21', '0', '2009-06-21', '2009-06-21', '4', '1', '1', '0');
2064 INSERT INTO `0_workorders` VALUES ('5', '5', 'DEF', '5', '3400', '2009-06-21', '0', '2009-06-21', '2009-06-21', '5', '1', '1', '10');
2065 INSERT INTO `0_workorders` VALUES ('6', '6', 'DEF', '-5', '3400', '2009-06-21', '1', '2009-06-21', '2009-06-21', '-5', '1', '1', '0');
2066 INSERT INTO `0_workorders` VALUES ('7', '7', 'DEF', '-2', '3400', '2009-06-21', '1', '2009-06-21', '2009-06-21', '-2', '1', '1', '10');
2069 ### Structure of table `0_tags` ###
2071 DROP TABLE IF EXISTS `0_tags`;
2073 CREATE TABLE `0_tags` (
2074 `id` int(11) NOT NULL auto_increment,
2075 `type` smallint(6) NOT NULL,
2076 `name` varchar(30) NOT NULL,
2077 `description` varchar(60) default NULL,
2078 `inactive` tinyint(1) NOT NULL default '0',
2080 UNIQUE KEY(`type`,`name`)
2081 ) TYPE=MyISAM AUTO_INCREMENT=1;
2084 ### Data of table `0_chart_tags` ###
2088 ### Structure of table `0_tag_associations` ###
2090 DROP TABLE IF EXISTS `0_tag_associations`;
2092 CREATE TABLE `0_tag_associations` (
2093 `record_id` varchar(11) NOT NULL,
2094 `tag_id` int(11) NOT NULL,
2095 UNIQUE KEY(`record_id`,`tag_id`)
2099 ### Data of table `0_tag_associations` ###