1 # Built by FrontAccounting 2.1.2
2 # http://frontaccounting.net
3 # Company: Training Co.
8 ### Structure of table `0_areas` ###
10 DROP TABLE IF EXISTS `0_areas`;
12 CREATE TABLE `0_areas` (
13 `area_code` int(11) NOT NULL auto_increment,
14 `description` varchar(60) NOT NULL default '',
15 `inactive` tinyint(1) NOT NULL default '0',
16 PRIMARY KEY (`area_code`),
17 UNIQUE KEY `description` (`description`)
18 ) TYPE=MyISAM AUTO_INCREMENT=2 ;
21 ### Data of table `0_areas` ###
23 INSERT INTO `0_areas` VALUES ('1', 'Global', '0');
26 ### Structure of table `0_attachments` ###
28 DROP TABLE IF EXISTS `0_attachments`;
30 CREATE TABLE `0_attachments` (
31 `id` int(11) unsigned NOT NULL auto_increment,
32 `description` varchar(60) NOT NULL default '',
33 `type_no` int(11) NOT NULL default '0',
34 `trans_no` int(11) NOT NULL default '0',
35 `unique_name` varchar(60) NOT NULL default '',
36 `tran_date` date NOT NULL default '0000-00-00',
37 `filename` varchar(60) NOT NULL default '',
38 `filesize` int(11) NOT NULL default '0',
39 `filetype` varchar(60) NOT NULL default '',
41 KEY `type_no` (`type_no`,`trans_no`)
42 ) TYPE=MyISAM AUTO_INCREMENT=1 ;
45 ### Data of table `0_attachments` ###
47 ### Structure of table `0_audit_trail` ###
49 DROP TABLE IF EXISTS `0_audit_trail`;
51 CREATE TABLE `0_audit_trail` (
52 `id` int(11) NOT NULL AUTO_INCREMENT,
53 `type` smallint(6) unsigned NOT NULL default '0',
54 `trans_no` int(11) unsigned NOT NULL default '0',
55 `user` smallint(6) unsigned NOT NULL default '0',
56 `stamp` timestamp NOT NULL,
57 `description` varchar(60) default NULL,
58 `fiscal_year` int(11) NOT NULL,
59 `gl_date` date NOT NULL default '0000-00-00',
60 `gl_seq` int(11) unsigned default NULL,
62 KEY `Seq` (`fiscal_year`, `gl_date`, `gl_seq`),
63 KEY `Type_and_Number` (`type`,`trans_no`)
66 ### Data of table `0_audit_trail` ###
72 ### Structure of table `0_bank_accounts` ###
74 DROP TABLE IF EXISTS `0_bank_accounts`;
76 CREATE TABLE `0_bank_accounts` (
77 `account_code` varchar(11) NOT NULL default '',
78 `account_type` smallint(6) NOT NULL default '0',
79 `bank_account_name` varchar(60) NOT NULL default '',
80 `bank_account_number` varchar(100) NOT NULL default '',
81 `bank_name` varchar(60) NOT NULL default '',
82 `bank_address` tinytext,
83 `bank_curr_code` char(3) NOT NULL default '',
84 `dflt_curr_act` TINYINT(1) NOT NULL default '0',
85 `id` smallint(6) NOT NULL auto_increment,
86 `last_reconciled_date` timestamp NOT NULL default '0000-00-00 00:00:00',
87 `ending_reconcile_balance` double NOT NULL default '0',
88 `inactive` tinyint(1) NOT NULL default '0',
90 KEY `bank_account_name` (`bank_account_name`),
91 KEY `bank_account_number` (`bank_account_number`),
93 ) TYPE=MyISAM AUTO_INCREMENT=3 ;
96 ### Data of table `0_bank_accounts` ###
98 INSERT INTO `0_bank_accounts` VALUES ('1060', '0', 'Current account', '9999999999', 'Wachovia Bank', '', 'USD', '1', '1', '0000-00-00 00:00:00', '0', '0');
99 INSERT INTO `0_bank_accounts` VALUES ('1065', '3', 'Petty Cash account', 'N/A', 'N/A', '', 'USD', '0', '2', '0000-00-00 00:00:00', '0', '0');
102 ### Structure of table `0_bank_trans` ###
104 DROP TABLE IF EXISTS `0_bank_trans`;
106 CREATE TABLE `0_bank_trans` (
107 `id` int(11) NOT NULL auto_increment,
108 `type` smallint(6) default NULL,
109 `trans_no` int(11) default NULL,
110 `bank_act` varchar(11) default NULL,
111 `ref` varchar(40) default NULL,
112 `trans_date` date NOT NULL default '0000-00-00',
113 `amount` double default NULL,
114 `dimension_id` int(11) NOT NULL default '0',
115 `dimension2_id` int(11) NOT NULL default '0',
116 `person_type_id` int(11) NOT NULL default '0',
117 `person_id` tinyblob,
118 `reconciled` date default NULL,
120 KEY `bank_act` (`bank_act`,`ref`),
121 KEY `type` (`type`,`trans_no`),
122 KEY (`bank_act`,`reconciled`),
123 KEY (`bank_act`,`trans_date`)
124 ) TYPE=InnoDB AUTO_INCREMENT=12 ;
127 ### Data of table `0_bank_trans` ###
129 INSERT INTO `0_bank_trans` VALUES ('1', '22', '4', '1', '1', '2009-06-21', '-3465', '0', '0', '3', '2', NULL);
130 INSERT INTO `0_bank_trans` VALUES ('2', '26', '1', '1', '', '2009-06-21', '-10', '0', '0', '1', '1', NULL);
131 INSERT INTO `0_bank_trans` VALUES ('3', '26', '1', '1', '', '2009-06-21', '-20', '0', '0', '1', '0', NULL);
132 INSERT INTO `0_bank_trans` VALUES ('4', '0', '18', '1', '1', '2009-02-20', '1000', '0', '0', '0', '', NULL);
133 INSERT INTO `0_bank_trans` VALUES ('5', '0', '19', '1', '2', '2009-02-21', '4000', '0', '0', '0', '', NULL);
134 INSERT INTO `0_bank_trans` VALUES ('6', '2', '5', '1', '1', '2009-06-21', '100', '0', '0', '4', '3', NULL);
135 INSERT INTO `0_bank_trans` VALUES ('7', '1', '8', '1', '1', '2009-06-21', '-50', '0', '0', '4', '1', NULL);
136 INSERT INTO `0_bank_trans` VALUES ('8', '26', '5', '1', '', '2009-06-21', '-10', '0', '0', '1', '1', NULL);
137 INSERT INTO `0_bank_trans` VALUES ('9', '26', '5', '1', '', '2009-06-21', '-20', '0', '0', '1', '0', NULL);
138 INSERT INTO `0_bank_trans` VALUES ('10', '26', '7', '1', '', '2009-06-21', '-10', '0', '0', '1', '1', NULL);
139 INSERT INTO `0_bank_trans` VALUES ('11', '26', '7', '1', '', '2009-06-21', '-20', '0', '0', '1', '0', NULL);
142 ### Structure of table `0_bom` ###
144 DROP TABLE IF EXISTS `0_bom`;
146 CREATE TABLE `0_bom` (
147 `id` int(11) NOT NULL auto_increment,
148 `parent` char(20) NOT NULL default '',
149 `component` char(20) NOT NULL default '',
150 `workcentre_added` int(11) NOT NULL default '0',
151 `loc_code` char(5) NOT NULL default '',
152 `quantity` double NOT NULL default '1',
153 PRIMARY KEY (`parent`,`component`,`workcentre_added`,`loc_code`),
154 KEY `component` (`component`),
156 KEY `loc_code` (`loc_code`),
157 KEY `parent` (`parent`,`loc_code`),
158 KEY `workcentre_added` (`workcentre_added`)
159 ) TYPE=MyISAM AUTO_INCREMENT=4 ;
162 ### Data of table `0_bom` ###
164 INSERT INTO `0_bom` VALUES ('1', '3400', '102', '1', 'DEF', '1');
165 INSERT INTO `0_bom` VALUES ('2', '3400', '103', '1', 'DEF', '1');
166 INSERT INTO `0_bom` VALUES ('3', '3400', '104', '1', 'DEF', '1');
169 ### Structure of table `0_budget_trans` ###
171 DROP TABLE IF EXISTS `0_budget_trans`;
173 CREATE TABLE `0_budget_trans` (
174 `counter` int(11) NOT NULL auto_increment,
175 `type` smallint(6) NOT NULL default '0',
176 `type_no` bigint(16) NOT NULL default '1',
177 `tran_date` date NOT NULL default '0000-00-00',
178 `account` varchar(11) NOT NULL default '',
179 `memo_` tinytext NOT NULL,
180 `amount` double NOT NULL default '0',
181 `dimension_id` int(11) default '0',
182 `dimension2_id` int(11) default '0',
183 `person_type_id` int(11) default NULL,
184 `person_id` tinyblob,
185 PRIMARY KEY (`counter`),
186 KEY `Type_and_Number` (`type`,`type_no`),
187 KEY `Account` (`account`, `tran_date`, `dimension_id`, `dimension2_id`)
188 ) TYPE=InnoDB AUTO_INCREMENT=1 ;
191 ### Data of table `0_budget_trans` ###
195 ### Structure of table `0_chart_class` ###
197 DROP TABLE IF EXISTS `0_chart_class`;
199 CREATE TABLE `0_chart_class` (
200 `cid` int(11) NOT NULL default '0',
201 `class_name` varchar(60) NOT NULL default '',
202 `ctype` tinyint(1) NOT NULL default '0',
203 `inactive` tinyint(1) NOT NULL default '0',
208 ### Data of table `0_chart_class` ###
210 INSERT INTO `0_chart_class` VALUES ('1', 'Assets', '1', '0');
211 INSERT INTO `0_chart_class` VALUES ('2', 'Liabilities', '2', '0');
212 INSERT INTO `0_chart_class` VALUES ('3', 'Income', '4', '0');
213 INSERT INTO `0_chart_class` VALUES ('4', 'Costs', '6', '0');
216 ### Structure of table `0_chart_master` ###
218 DROP TABLE IF EXISTS `0_chart_master`;
220 CREATE TABLE `0_chart_master` (
221 `account_code` varchar(11) NOT NULL default '',
222 `account_code2` varchar(11) default '',
223 `account_name` varchar(60) NOT NULL default '',
224 `account_type` int(11) NOT NULL default '0',
225 `inactive` tinyint(1) NOT NULL default '0',
226 PRIMARY KEY (`account_code`),
227 KEY `account_name` (`account_name`),
228 KEY `accounts_by_type` (`account_type`, `account_code`)
232 ### Data of table `0_chart_master` ###
234 INSERT INTO `0_chart_master` VALUES ('1060', '', 'Checking Account', '1', '0');
235 INSERT INTO `0_chart_master` VALUES ('1065', '', 'Petty Cash', '1', '0');
236 INSERT INTO `0_chart_master` VALUES ('1200', '', 'Accounts Receivables', '1', '0');
237 INSERT INTO `0_chart_master` VALUES ('1205', '', 'Allowance for doubtful accounts', '1', '0');
238 INSERT INTO `0_chart_master` VALUES ('1510', '', 'Inventory', '2', '0');
239 INSERT INTO `0_chart_master` VALUES ('1520', '', 'Stocks of Raw Materials', '2', '0');
240 INSERT INTO `0_chart_master` VALUES ('1530', '', 'Stocks of Work In Progress', '2', '0');
241 INSERT INTO `0_chart_master` VALUES ('1540', '', 'Stocks of Finsihed Goods', '2', '0');
242 INSERT INTO `0_chart_master` VALUES ('1550', '', 'Goods Received Clearing account', '2', '0');
243 INSERT INTO `0_chart_master` VALUES ('1820', '', 'Office Furniture & Equipment', '3', '0');
244 INSERT INTO `0_chart_master` VALUES ('1825', '', 'Accum. Amort. -Furn. & Equip.', '3', '0');
245 INSERT INTO `0_chart_master` VALUES ('1840', '', 'Vehicle', '3', '0');
246 INSERT INTO `0_chart_master` VALUES ('1845', '', 'Accum. Amort. -Vehicle', '3', '0');
247 INSERT INTO `0_chart_master` VALUES ('2100', '', 'Accounts Payable', '4', '0');
248 INSERT INTO `0_chart_master` VALUES ('2110', '', 'Accrued Income Tax - Federal', '4', '0');
249 INSERT INTO `0_chart_master` VALUES ('2120', '', 'Accrued Income Tax - State', '4', '0');
250 INSERT INTO `0_chart_master` VALUES ('2130', '', 'Accrued Franchise Tax', '4', '0');
251 INSERT INTO `0_chart_master` VALUES ('2140', '', 'Accrued Real & Personal Prop Tax', '4', '0');
252 INSERT INTO `0_chart_master` VALUES ('2150', '', 'Sales Tax', '4', '0');
253 INSERT INTO `0_chart_master` VALUES ('2160', '', 'Accrued Use Tax Payable', '4', '0');
254 INSERT INTO `0_chart_master` VALUES ('2210', '', 'Accrued Wages', '4', '0');
255 INSERT INTO `0_chart_master` VALUES ('2220', '', 'Accrued Comp Time', '4', '0');
256 INSERT INTO `0_chart_master` VALUES ('2230', '', 'Accrued Holiday Pay', '4', '0');
257 INSERT INTO `0_chart_master` VALUES ('2240', '', 'Accrued Vacation Pay', '4', '0');
258 INSERT INTO `0_chart_master` VALUES ('2310', '', 'Accr. Benefits - 401K', '4', '0');
259 INSERT INTO `0_chart_master` VALUES ('2320', '', 'Accr. Benefits - Stock Purchase', '4', '0');
260 INSERT INTO `0_chart_master` VALUES ('2330', '', 'Accr. Benefits - Med, Den', '4', '0');
261 INSERT INTO `0_chart_master` VALUES ('2340', '', 'Accr. Benefits - Payroll Taxes', '4', '0');
262 INSERT INTO `0_chart_master` VALUES ('2350', '', 'Accr. Benefits - Credit Union', '4', '0');
263 INSERT INTO `0_chart_master` VALUES ('2360', '', 'Accr. Benefits - Savings Bond', '4', '0');
264 INSERT INTO `0_chart_master` VALUES ('2370', '', 'Accr. Benefits - Garnish', '4', '0');
265 INSERT INTO `0_chart_master` VALUES ('2380', '', 'Accr. Benefits - Charity Cont.', '4', '0');
266 INSERT INTO `0_chart_master` VALUES ('2620', '', 'Bank Loans', '5', '0');
267 INSERT INTO `0_chart_master` VALUES ('2680', '', 'Loans from Shareholders', '5', '0');
268 INSERT INTO `0_chart_master` VALUES ('3350', '', 'Common Shares', '6', '0');
269 INSERT INTO `0_chart_master` VALUES ('3590', '', 'Retained Earnings - prior years', '7', '0');
270 INSERT INTO `0_chart_master` VALUES ('4010', '', 'Sales', '8', '0');
271 INSERT INTO `0_chart_master` VALUES ('4430', '', 'Shipping & Handling', '9', '0');
272 INSERT INTO `0_chart_master` VALUES ('4440', '', 'Interest', '9', '0');
273 INSERT INTO `0_chart_master` VALUES ('4450', '', 'Foreign Exchange Gain', '9', '0');
274 INSERT INTO `0_chart_master` VALUES ('4500', '', 'Prompt Payment Discounts', '9', '0');
275 INSERT INTO `0_chart_master` VALUES ('4510', '', 'Discounts Given', '9', '0');
276 INSERT INTO `0_chart_master` VALUES ('5010', '', 'Cost of Goods Sold - Retail', '10', '0');
277 INSERT INTO `0_chart_master` VALUES ('5020', '', 'Material Usage Varaiance', '10', '0');
278 INSERT INTO `0_chart_master` VALUES ('5030', '', 'Consumable Materials', '10', '0');
279 INSERT INTO `0_chart_master` VALUES ('5040', '', 'Purchase price Variance', '10', '0');
280 INSERT INTO `0_chart_master` VALUES ('5050', '', 'Purchases of materials', '10', '0');
281 INSERT INTO `0_chart_master` VALUES ('5060', '', 'Discounts Received', '10', '0');
282 INSERT INTO `0_chart_master` VALUES ('5100', '', 'Freight', '10', '0');
283 INSERT INTO `0_chart_master` VALUES ('5410', '', 'Wages & Salaries', '11', '0');
284 INSERT INTO `0_chart_master` VALUES ('5420', '', 'Wages - Overtime', '11', '0');
285 INSERT INTO `0_chart_master` VALUES ('5430', '', 'Benefits - Comp Time', '11', '0');
286 INSERT INTO `0_chart_master` VALUES ('5440', '', 'Benefits - Payroll Taxes', '11', '0');
287 INSERT INTO `0_chart_master` VALUES ('5450', '', 'Benefits - Workers Comp', '11', '0');
288 INSERT INTO `0_chart_master` VALUES ('5460', '', 'Benefits - Pension', '11', '0');
289 INSERT INTO `0_chart_master` VALUES ('5470', '', 'Benefits - General Benefits', '11', '0');
290 INSERT INTO `0_chart_master` VALUES ('5510', '', 'Inc Tax Exp - Federal', '11', '0');
291 INSERT INTO `0_chart_master` VALUES ('5520', '', 'Inc Tax Exp - State', '11', '0');
292 INSERT INTO `0_chart_master` VALUES ('5530', '', 'Taxes - Real Estate', '11', '0');
293 INSERT INTO `0_chart_master` VALUES ('5540', '', 'Taxes - Personal Property', '11', '0');
294 INSERT INTO `0_chart_master` VALUES ('5550', '', 'Taxes - Franchise', '11', '0');
295 INSERT INTO `0_chart_master` VALUES ('5560', '', 'Taxes - Foreign Withholding', '11', '0');
296 INSERT INTO `0_chart_master` VALUES ('5610', '', 'Accounting & Legal', '12', '0');
297 INSERT INTO `0_chart_master` VALUES ('5615', '', 'Advertising & Promotions', '12', '0');
298 INSERT INTO `0_chart_master` VALUES ('5620', '', 'Bad Debts', '12', '0');
299 INSERT INTO `0_chart_master` VALUES ('5660', '', 'Amortization Expense', '12', '0');
300 INSERT INTO `0_chart_master` VALUES ('5685', '', 'Insurance', '12', '0');
301 INSERT INTO `0_chart_master` VALUES ('5690', '', 'Interest & Bank Charges', '12', '0');
302 INSERT INTO `0_chart_master` VALUES ('5700', '', 'Office Supplies', '12', '0');
303 INSERT INTO `0_chart_master` VALUES ('5760', '', 'Rent', '12', '0');
304 INSERT INTO `0_chart_master` VALUES ('5765', '', 'Repair & Maintenance', '12', '0');
305 INSERT INTO `0_chart_master` VALUES ('5780', '', 'Telephone', '12', '0');
306 INSERT INTO `0_chart_master` VALUES ('5785', '', 'Travel & Entertainment', '12', '0');
307 INSERT INTO `0_chart_master` VALUES ('5790', '', 'Utilities', '12', '0');
308 INSERT INTO `0_chart_master` VALUES ('5795', '', 'Registrations', '12', '0');
309 INSERT INTO `0_chart_master` VALUES ('5800', '', 'Licenses', '12', '0');
310 INSERT INTO `0_chart_master` VALUES ('5810', '', 'Foreign Exchange Loss', '12', '0');
311 INSERT INTO `0_chart_master` VALUES ('9990', '', 'Year Profit/Loss', '12', '0');
313 ### Structure of table `0_chart_types` ###
315 DROP TABLE IF EXISTS `0_chart_types`;
317 CREATE TABLE `0_chart_types` (
318 `id` int(11) NOT NULL auto_increment,
319 `name` varchar(60) NOT NULL default '',
320 `class_id` tinyint(1) NOT NULL default '0',
321 `parent` int(11) NOT NULL default '-1',
322 `inactive` tinyint(1) NOT NULL default '0',
326 ) TYPE=MyISAM AUTO_INCREMENT=13 ;
329 ### Data of table `0_chart_types` ###
331 INSERT INTO `0_chart_types` VALUES ('1', 'Current Assets', '1', '-1', '0');
332 INSERT INTO `0_chart_types` VALUES ('2', 'Inventory Assets', '1', '-1', '0');
333 INSERT INTO `0_chart_types` VALUES ('3', 'Capital Assets', '1', '-1', '0');
334 INSERT INTO `0_chart_types` VALUES ('4', 'Current Liabilities', '2', '-1', '0');
335 INSERT INTO `0_chart_types` VALUES ('5', 'Long Term Liabilities', '2', '-1', '0');
336 INSERT INTO `0_chart_types` VALUES ('6', 'Share Capital', '2', '-1', '0');
337 INSERT INTO `0_chart_types` VALUES ('7', 'Retained Earnings', '2', '-1', '0');
338 INSERT INTO `0_chart_types` VALUES ('8', 'Sales Revenue', '3', '-1', '0');
339 INSERT INTO `0_chart_types` VALUES ('9', 'Other Revenue', '3', '-1', '0');
340 INSERT INTO `0_chart_types` VALUES ('10', 'Cost of Goods Sold', '4', '-1', '0');
341 INSERT INTO `0_chart_types` VALUES ('11', 'Payroll Expenses', '4', '-1', '0');
342 INSERT INTO `0_chart_types` VALUES ('12', 'General & Administrative expenses', '4', '-1', '0');
345 ### Structure of table `0_comments` ###
347 DROP TABLE IF EXISTS `0_comments`;
349 CREATE TABLE `0_comments` (
350 `type` int(11) NOT NULL default '0',
351 `id` int(11) NOT NULL default '0',
352 `date_` date default '0000-00-00',
354 KEY `type_and_id` (`type`, `id`)
358 ### Data of table `0_comments` ###
362 ### Structure of table `0_company` ###
364 DROP TABLE IF EXISTS `0_company`;
366 CREATE TABLE `0_company` (
367 `coy_code` int(11) NOT NULL default '1',
368 `coy_name` varchar(60) NOT NULL default '',
369 `gst_no` varchar(25) NOT NULL default '',
370 `coy_no` varchar(25) NOT NULL default '0',
371 `tax_prd` int(11) NOT NULL default '1',
372 `tax_last` int(11) NOT NULL default '1',
373 `postal_address` tinytext NOT NULL,
374 `phone` varchar(30) NOT NULL default '',
375 `fax` varchar(30) NOT NULL default '',
376 `email` varchar(100) NOT NULL default '',
377 `coy_logo` varchar(100) NOT NULL default '',
378 `domicile` varchar(55) NOT NULL default '',
379 `curr_default` char(3) NOT NULL default '',
380 `debtors_act` varchar(11) NOT NULL default '',
381 `pyt_discount_act` varchar(11) NOT NULL default '',
382 `creditors_act` varchar(11) NOT NULL default '',
383 `bank_charge_act` varchar(11) NOT NULL default '',
384 `exchange_diff_act` varchar(11) NOT NULL default '',
385 `profit_loss_year_act` varchar(11) NOT NULL default '',
386 `retained_earnings_act` varchar(11) NOT NULL default '',
387 `freight_act` varchar(11) NOT NULL default '',
388 `default_sales_act` varchar(11) NOT NULL default '',
389 `default_sales_discount_act` varchar(11) NOT NULL default '',
390 `default_prompt_payment_act` varchar(11) NOT NULL default '',
391 `default_inventory_act` varchar(11) NOT NULL default '',
392 `default_cogs_act` varchar(11) NOT NULL default '',
393 `default_adj_act` varchar(11) NOT NULL default '',
394 `default_inv_sales_act` varchar(11) NOT NULL default '',
395 `default_assembly_act` varchar(11) NOT NULL default '',
396 `payroll_act` varchar(11) NOT NULL default '',
397 `allow_negative_stock` tinyint(1) NOT NULL default '0',
398 `po_over_receive` int(11) NOT NULL default '10',
399 `po_over_charge` int(11) NOT NULL default '10',
400 `default_credit_limit` int(11) NOT NULL default '1000',
401 `default_workorder_required` int(11) NOT NULL default '20',
402 `default_dim_required` int(11) NOT NULL default '20',
403 `past_due_days` int(11) NOT NULL default '30',
404 `use_dimension` tinyint(1) default '0',
405 `f_year` int(11) NOT NULL default '1',
406 `no_item_list` tinyint(1) NOT NULL default '0',
407 `no_customer_list` tinyint(1) NOT NULL default '0',
408 `no_supplier_list` tinyint(1) NOT NULL default '0',
409 `base_sales` int(11) NOT NULL default '-1',
410 `foreign_codes` tinyint(1) NOT NULL default '0',
411 `accumulate_shipping` tinyint(1) NOT NULL default '0',
412 `legal_text` tinytext NOT NULL,
413 `default_delivery_required` smallint(6) NOT NULL default '1',
414 `version_id` varchar(11) NOT NULL default '',
415 `time_zone` tinyint(1) NOT NULL default '0',
416 `add_pct` int(5) NOT NULL default '-1',
417 `round_to` int(5) NOT NULL default '1',
418 `login_tout` SMALLINT(6) NOT NULL DEFAULT '600',
419 PRIMARY KEY (`coy_code`)
422 ### Data of table `0_company` ###
424 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');
426 ### Structure of table `0_credit_status` ###
428 DROP TABLE IF EXISTS `0_credit_status`;
430 CREATE TABLE `0_credit_status` (
431 `id` int(11) NOT NULL auto_increment,
432 `reason_description` char(100) NOT NULL default '',
433 `dissallow_invoices` tinyint(1) NOT NULL default '0',
434 `inactive` tinyint(1) NOT NULL default '0',
436 UNIQUE KEY `reason_description` (`reason_description`)
437 ) TYPE=MyISAM AUTO_INCREMENT=5 ;
440 ### Data of table `0_credit_status` ###
442 INSERT INTO `0_credit_status` VALUES ('1', 'Good History', '0', '0');
443 INSERT INTO `0_credit_status` VALUES ('3', 'No more work until payment received', '1', '0');
444 INSERT INTO `0_credit_status` VALUES ('4', 'In liquidation', '1', '0');
447 ### Structure of table `0_currencies` ###
449 DROP TABLE IF EXISTS `0_currencies`;
451 CREATE TABLE `0_currencies` (
452 `currency` varchar(60) NOT NULL default '',
453 `curr_abrev` char(3) NOT NULL default '',
454 `curr_symbol` varchar(10) NOT NULL default '',
455 `country` varchar(100) NOT NULL default '',
456 `hundreds_name` varchar(15) NOT NULL default '',
457 `auto_update` tinyint(1) NOT NULL default '1',
458 `inactive` tinyint(1) NOT NULL default '0',
459 PRIMARY KEY (`curr_abrev`)
463 ### Data of table `0_currencies` ###
465 INSERT INTO `0_currencies` VALUES ('US Dollars', 'USD', '$', 'United States', 'Cents', '1', '0');
466 INSERT INTO `0_currencies` VALUES ('CA Dollars', 'CAD', '$', 'Canada', 'Cents', '1', '0');
467 INSERT INTO `0_currencies` VALUES ('Euro', 'EUR', '?', 'Europe', 'Cents', '1', '0');
468 INSERT INTO `0_currencies` VALUES ('Pounds', 'GBP', '?', 'England', 'Pence', '1', '0');
469 INSERT INTO `0_currencies` VALUES ('DK Kroner', 'DKK', '?', 'Denmark', 'Ore', '1', '0');
471 ### Structure of table `0_cust_allocations` ###
473 DROP TABLE IF EXISTS `0_cust_allocations`;
475 CREATE TABLE `0_cust_allocations` (
476 `id` int(11) NOT NULL auto_increment,
477 `amt` double unsigned default NULL,
478 `date_alloc` date NOT NULL default '0000-00-00',
479 `trans_no_from` int(11) default NULL,
480 `trans_type_from` int(11) default NULL,
481 `trans_no_to` int(11) default NULL,
482 `trans_type_to` int(11) default NULL,
484 KEY `From` (`trans_type_from`, `trans_no_from`),
485 KEY `To` (`trans_type_to`, `trans_no_to`)
486 ) TYPE=InnoDB AUTO_INCREMENT=2 ;
489 ### Data of table `0_cust_allocations` ###
491 INSERT INTO `0_cust_allocations` VALUES ('1', '37.68', '2009-06-21', '3', '11', '18', '10');
494 ### Structure of table `0_cust_branch` ###
496 DROP TABLE IF EXISTS `0_cust_branch`;
498 CREATE TABLE `0_cust_branch` (
499 `branch_code` int(11) NOT NULL auto_increment,
500 `debtor_no` int(11) NOT NULL default '0',
501 `br_name` varchar(60) NOT NULL default '',
502 `branch_ref` varchar(30) NOT NULL default '',
503 `br_address` tinytext NOT NULL,
504 `area` int(11) default NULL,
505 `salesman` int(11) NOT NULL default '0',
506 `phone` varchar(30) NOT NULL default '',
507 `phone2` varchar(30) NOT NULL default '',
508 `fax` varchar(30) NOT NULL default '',
509 `contact_name` varchar(60) NOT NULL default '',
510 `email` varchar(100) NOT NULL default '',
511 `default_location` varchar(5) NOT NULL default '',
512 `tax_group_id` int(11) default NULL,
513 `sales_account` varchar(11) default NULL,
514 `sales_discount_account` varchar(11) default NULL,
515 `receivables_account` varchar(11) default NULL,
516 `payment_discount_account` varchar(11) default NULL,
517 `default_ship_via` int(11) NOT NULL default '1',
518 `disable_trans` tinyint(4) NOT NULL default '0',
519 `br_post_address` tinytext NOT NULL,
520 `group_no` int(11) NOT NULL default '0',
521 `notes` tinytext NOT NULL,
522 `inactive` tinyint(1) NOT NULL default '0',
523 PRIMARY KEY (`branch_code`,`debtor_no`),
524 KEY `branch_code` (`branch_code`),
527 ) TYPE=MyISAM AUTO_INCREMENT=4 ;
530 ### Data of table `0_cust_branch` ###
532 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');
533 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');
534 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');
537 ### Structure of table `0_debtor_trans` ###
539 DROP TABLE IF EXISTS `0_debtor_trans`;
541 CREATE TABLE `0_debtor_trans` (
542 `trans_no` int(11) unsigned NOT NULL default '0',
543 `type` smallint(6) unsigned NOT NULL default '0',
544 `version` tinyint(1) unsigned NOT NULL default '0',
545 `debtor_no` int(11) unsigned default NULL,
546 `branch_code` int(11) NOT NULL default '-1',
547 `tran_date` date NOT NULL default '0000-00-00',
548 `due_date` date NOT NULL default '0000-00-00',
549 `reference` varchar(60) NOT NULL default '',
550 `tpe` int(11) NOT NULL default '0',
551 `order_` int(11) NOT NULL default '0',
552 `ov_amount` double NOT NULL default '0',
553 `ov_gst` double NOT NULL default '0',
554 `ov_freight` double NOT NULL default '0',
555 `ov_freight_tax` double NOT NULL default '0',
556 `ov_discount` double NOT NULL default '0',
557 `alloc` double NOT NULL default '0',
558 `rate` double NOT NULL default '1',
559 `ship_via` int(11) default NULL,
560 `trans_link` int(11) NOT NULL default '0',
561 `dimension_id` int(11) NOT NULL default '0',
562 `dimension2_id` int(11) NOT NULL default '0',
563 PRIMARY KEY (`type`, `trans_no`),
564 KEY `debtor_no` (`debtor_no`,`branch_code`),
569 ### Data of table `0_debtor_trans` ###
571 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');
572 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');
573 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');
574 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');
575 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');
576 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');
577 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');
578 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');
581 ### Structure of table `0_debtor_trans_details` ###
583 DROP TABLE IF EXISTS `0_debtor_trans_details`;
585 CREATE TABLE `0_debtor_trans_details` (
586 `id` int(11) NOT NULL auto_increment,
587 `debtor_trans_no` int(11) default NULL,
588 `debtor_trans_type` int(11) default NULL,
589 `stock_id` varchar(20) NOT NULL default '',
590 `description` tinytext,
591 `unit_price` double NOT NULL default '0',
592 `unit_tax` double NOT NULL default '0',
593 `quantity` double NOT NULL default '0',
594 `discount_percent` double NOT NULL default '0',
595 `standard_cost` double NOT NULL default '0',
596 `qty_done` double NOT NULL default '0',
598 KEY `Transaction` (`debtor_trans_type`, `debtor_trans_no`)
599 ) TYPE=InnoDB AUTO_INCREMENT=9 ;
602 ### Data of table `0_debtor_trans_details` ###
604 INSERT INTO `0_debtor_trans_details` VALUES ('1', '2', '13', '102', '17inch VGA Monitor', '30.4', '0', '2', '0', '10', '0');
605 INSERT INTO `0_debtor_trans_details` VALUES ('2', '3', '13', '102', '17inch VGA Monitor', '50', '2.5', '1', '0', '10', '1');
606 INSERT INTO `0_debtor_trans_details` VALUES ('3', '17', '10', '102', '17inch VGA Monitor', '50', '2.5', '1', '0', '10', '0');
607 INSERT INTO `0_debtor_trans_details` VALUES ('4', '4', '13', '102', '17inch VGA Monitor', '35.89', '1.79', '1', '0', '10', '1');
608 INSERT INTO `0_debtor_trans_details` VALUES ('5', '18', '10', '102', '17inch VGA Monitor', '35.89', '1.79', '1', '0', '10', '1');
609 INSERT INTO `0_debtor_trans_details` VALUES ('6', '5', '13', '102', '17inch VGA Monitor', '50', '2.38', '1', '0', '10', '1');
610 INSERT INTO `0_debtor_trans_details` VALUES ('7', '19', '10', '102', '17inch VGA Monitor', '50', '2.38', '1', '0', '10', '0');
611 INSERT INTO `0_debtor_trans_details` VALUES ('8', '3', '11', '102', '17inch VGA Monitor', '35.89', '1.79', '1', '0', '10', '0');
614 ### Structure of table `0_debtors_master` ###
616 DROP TABLE IF EXISTS `0_debtors_master`;
618 CREATE TABLE `0_debtors_master` (
619 `debtor_no` int(11) NOT NULL auto_increment,
620 `name` varchar(100) NOT NULL default '',
621 `debtor_ref` varchar(30) NOT NULL,
623 `email` varchar(100) NOT NULL default '',
624 `tax_id` varchar(55) NOT NULL default '',
625 `curr_code` char(3) NOT NULL default '',
626 `sales_type` int(11) NOT NULL default '1',
627 `dimension_id` int(11) NOT NULL default '0',
628 `dimension2_id` int(11) NOT NULL default '0',
629 `credit_status` int(11) NOT NULL default '0',
630 `payment_terms` int(11) default NULL,
631 `discount` double NOT NULL default '0',
632 `pymt_discount` double NOT NULL default '0',
633 `credit_limit` float NOT NULL default '1000',
634 `notes` tinytext NOT NULL,
635 `inactive` tinyint(1) NOT NULL default '0',
636 PRIMARY KEY (`debtor_no`),
637 UNIQUE KEY `name` (`name`),
639 ) TYPE=MyISAM AUTO_INCREMENT=4 ;
642 ### Data of table `0_debtors_master` ###
644 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');
645 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');
646 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');
649 ### Structure of table `0_dimensions` ###
651 DROP TABLE IF EXISTS `0_dimensions`;
653 CREATE TABLE `0_dimensions` (
654 `id` int(11) NOT NULL auto_increment,
655 `reference` varchar(60) NOT NULL default '',
656 `name` varchar(60) NOT NULL default '',
657 `type_` tinyint(1) NOT NULL default '1',
658 `closed` tinyint(1) NOT NULL default '0',
659 `date_` date NOT NULL default '0000-00-00',
660 `due_date` date NOT NULL default '0000-00-00',
662 UNIQUE KEY `reference` (`reference`),
666 ) TYPE=InnoDB AUTO_INCREMENT=3 ;
669 ### Data of table `0_dimensions` ###
671 INSERT INTO `0_dimensions` VALUES ('1', '1', 'Support', '1', '0', '2009-06-21', '2015-07-11');
672 INSERT INTO `0_dimensions` VALUES ('2', '2', 'Development', '1', '0', '2009-06-21', '2015-07-11');
675 ### Structure of table `0_exchange_rates` ###
677 DROP TABLE IF EXISTS `0_exchange_rates`;
679 CREATE TABLE `0_exchange_rates` (
680 `id` int(11) NOT NULL auto_increment,
681 `curr_code` char(3) NOT NULL default '',
682 `rate_buy` double NOT NULL default '0',
683 `rate_sell` double NOT NULL default '0',
684 `date_` date NOT NULL default '0000-00-00',
686 UNIQUE KEY `curr_code` (`curr_code`,`date_`)
687 ) TYPE=MyISAM AUTO_INCREMENT=4 ;
690 ### Data of table `0_exchange_rates` ###
692 INSERT INTO `0_exchange_rates` VALUES ('1', 'DKK', '0.18717252868313', '0.18717252868313', '2009-06-21');
693 INSERT INTO `0_exchange_rates` VALUES ('2', 'GBP', '1.6445729799917', '1.6445729799917', '2009-06-21');
694 INSERT INTO `0_exchange_rates` VALUES ('3', 'EUR', '1.3932', '1.3932', '2009-06-21');
697 ### Structure of table `0_fiscal_year` ###
699 DROP TABLE IF EXISTS `0_fiscal_year`;
701 CREATE TABLE `0_fiscal_year` (
702 `id` int(11) NOT NULL auto_increment,
703 `begin` date default '0000-00-00',
704 `end` date default '0000-00-00',
705 `closed` tinyint(1) NOT NULL default '0',
709 ) TYPE=InnoDB AUTO_INCREMENT=3 ;
712 ### Data of table `0_fiscal_year` ###
714 INSERT INTO `0_fiscal_year` VALUES ('1', '2008-01-01', '2008-12-31', '0');
715 INSERT INTO `0_fiscal_year` VALUES ('2', '2009-01-01', '2009-12-31', '0');
718 ### Structure of table `0_gl_trans` ###
720 DROP TABLE IF EXISTS `0_gl_trans`;
722 CREATE TABLE `0_gl_trans` (
723 `counter` int(11) NOT NULL auto_increment,
724 `type` smallint(6) NOT NULL default '0',
725 `type_no` bigint(16) NOT NULL default '1',
726 `tran_date` date NOT NULL default '0000-00-00',
727 `account` varchar(11) NOT NULL default '',
728 `memo_` tinytext NOT NULL,
729 `amount` double NOT NULL default '0',
730 `dimension_id` int(11) NOT NULL default '0',
731 `dimension2_id` int(11) NOT NULL default '0',
732 `person_type_id` int(11) default NULL,
733 `person_id` tinyblob,
734 PRIMARY KEY (`counter`),
735 KEY `Type_and_Number` (`type`,`type_no`),
736 KEY (`dimension_id`),
737 KEY (`dimension2_id`),
739 KEY `account_and_tran_date` (`account`, `tran_date`)
740 ) TYPE=InnoDB AUTO_INCREMENT=84 ;
743 ### Data of table `0_gl_trans` ###
745 INSERT INTO `0_gl_trans` VALUES ('1', '20', '7', '2009-06-21', '2100', '', '-3465', '0', '0', '3', '2');
746 INSERT INTO `0_gl_trans` VALUES ('2', '20', '7', '2009-06-21', '1510', '', '1000', '0', '0', '3', '2');
747 INSERT INTO `0_gl_trans` VALUES ('3', '20', '7', '2009-06-21', '1510', '', '1100', '0', '0', '3', '2');
748 INSERT INTO `0_gl_trans` VALUES ('4', '20', '7', '2009-06-21', '1510', '', '1200', '0', '0', '3', '2');
749 INSERT INTO `0_gl_trans` VALUES ('5', '20', '7', '2009-06-21', '2150', '', '165', '0', '0', '3', '2');
750 INSERT INTO `0_gl_trans` VALUES ('6', '22', '4', '2009-06-21', '2100', '', '3465', '0', '0', '3', '2');
751 INSERT INTO `0_gl_trans` VALUES ('7', '22', '4', '2009-06-21', '1060', '', '-3465', '0', '0', '3', '2');
752 INSERT INTO `0_gl_trans` VALUES ('8', '26', '1', '2009-06-21', '1510', '', '-100', '0', '0', NULL, '');
753 INSERT INTO `0_gl_trans` VALUES ('9', '26', '1', '2009-06-21', '1510', '', '-110', '0', '0', NULL, '');
754 INSERT INTO `0_gl_trans` VALUES ('10', '26', '1', '2009-06-21', '1510', '', '-120', '0', '0', NULL, '');
755 INSERT INTO `0_gl_trans` VALUES ('11', '26', '1', '2009-06-21', '1060', 'Overhead Cost', '-10', '0', '0', '1', '1');
756 INSERT INTO `0_gl_trans` VALUES ('12', '26', '1', '2009-06-21', '1530', 'Overhead Cost', '10', '0', '0', '1', '1');
757 INSERT INTO `0_gl_trans` VALUES ('13', '26', '1', '2009-06-21', '1060', 'Labour Cost', '-20', '0', '0', '1', '0');
758 INSERT INTO `0_gl_trans` VALUES ('14', '26', '1', '2009-06-21', '1530', 'Labour Cost', '20', '0', '0', '1', '0');
759 INSERT INTO `0_gl_trans` VALUES ('15', '26', '1', '2009-06-21', '1510', '', '330', '0', '0', NULL, '');
760 INSERT INTO `0_gl_trans` VALUES ('16', '13', '2', '2009-06-21', '5010', '', '20', '0', '0', '2', '1');
761 INSERT INTO `0_gl_trans` VALUES ('17', '13', '2', '2009-06-21', '1510', '', '-20', '0', '0', '2', '1');
762 INSERT INTO `0_gl_trans` VALUES ('18', '13', '3', '2009-06-21', '5010', '', '10', '0', '0', '2', '2');
763 INSERT INTO `0_gl_trans` VALUES ('19', '13', '3', '2009-06-21', '1510', '', '-10', '0', '0', '2', '2');
764 INSERT INTO `0_gl_trans` VALUES ('20', '10', '17', '2009-06-21', '4010', '', '-50', '0', '0', '2', '2');
765 INSERT INTO `0_gl_trans` VALUES ('21', '10', '17', '2009-06-21', '1200', '', '52.5', '0', '0', '2', '2');
766 INSERT INTO `0_gl_trans` VALUES ('22', '10', '17', '2009-06-21', '2150', '', '-2.5', '0', '0', '2', '2');
767 INSERT INTO `0_gl_trans` VALUES ('23', '13', '4', '2009-06-21', '5010', '', '10', '2', '0', '2', '3');
768 INSERT INTO `0_gl_trans` VALUES ('24', '13', '4', '2009-06-21', '1510', '', '-10', '0', '0', '2', '3');
769 INSERT INTO `0_gl_trans` VALUES ('25', '10', '18', '2009-06-21', '4010', '', '-50', '2', '0', '2', '3');
770 INSERT INTO `0_gl_trans` VALUES ('26', '10', '18', '2009-06-21', '1200', '', '52.5', '0', '0', '2', '3');
771 INSERT INTO `0_gl_trans` VALUES ('27', '10', '18', '2009-06-21', '2150', '', '-2.5', '0', '0', '2', '3');
772 INSERT INTO `0_gl_trans` VALUES ('28', '0', '18', '2009-02-20', '1060', '', '1000', '0', '0', NULL, '');
773 INSERT INTO `0_gl_trans` VALUES ('29', '0', '18', '2009-02-20', '3350', '', '-1000', '0', '0', NULL, '');
774 INSERT INTO `0_gl_trans` VALUES ('30', '0', '19', '2009-02-21', '1060', '', '4000', '0', '0', NULL, '');
775 INSERT INTO `0_gl_trans` VALUES ('31', '0', '19', '2009-02-21', '3350', '', '-4000', '0', '0', NULL, '');
776 INSERT INTO `0_gl_trans` VALUES ('32', '26', '3', '2009-06-21', '1510', '', '-20', '0', '0', NULL, '');
777 INSERT INTO `0_gl_trans` VALUES ('33', '26', '3', '2009-06-21', '1510', '', '-22', '0', '0', NULL, '');
778 INSERT INTO `0_gl_trans` VALUES ('34', '26', '3', '2009-06-21', '1510', '', '-24', '0', '0', NULL, '');
779 INSERT INTO `0_gl_trans` VALUES ('35', '26', '3', '2009-06-21', '1540', '', '66', '0', '0', NULL, '');
780 INSERT INTO `0_gl_trans` VALUES ('36', '2', '5', '2009-06-21', '2150', 'Cash Sales', '-4.76', '0', '0', '4', '3');
781 INSERT INTO `0_gl_trans` VALUES ('37', '2', '5', '2009-06-21', '4010', 'Cash Sales', '-95.24', '0', '0', '4', '3');
782 INSERT INTO `0_gl_trans` VALUES ('38', '2', '5', '2009-06-21', '1060', '', '100', '0', '0', '4', '3');
783 INSERT INTO `0_gl_trans` VALUES ('39', '1', '8', '2009-06-21', '2150', 'Maintenance', '2.38', '0', '0', '4', '1');
784 INSERT INTO `0_gl_trans` VALUES ('40', '1', '8', '2009-06-21', '5765', 'Maintenance', '47.62', '0', '0', '4', '1');
785 INSERT INTO `0_gl_trans` VALUES ('41', '1', '8', '2009-06-21', '1060', '', '-50', '0', '0', '4', '1');
786 INSERT INTO `0_gl_trans` VALUES ('42', '20', '8', '2009-06-21', '2100', '', '-20', '0', '0', '3', '2');
787 INSERT INTO `0_gl_trans` VALUES ('43', '20', '8', '2009-06-21', '2150', '', '0.95', '0', '0', '3', '2');
788 INSERT INTO `0_gl_trans` VALUES ('44', '20', '8', '2009-06-21', '5780', '', '19.05', '0', '0', '3', '2');
789 INSERT INTO `0_gl_trans` VALUES ('45', '26', '4', '2009-06-21', '1510', '', '-40', '0', '0', NULL, '');
790 INSERT INTO `0_gl_trans` VALUES ('46', '26', '4', '2009-06-21', '1510', '', '-44', '0', '0', NULL, '');
791 INSERT INTO `0_gl_trans` VALUES ('47', '26', '4', '2009-06-21', '1510', '', '-48', '0', '0', NULL, '');
792 INSERT INTO `0_gl_trans` VALUES ('48', '26', '4', '2009-06-21', '1540', '', '132', '0', '0', NULL, '');
793 INSERT INTO `0_gl_trans` VALUES ('49', '26', '2', '2009-06-21', '1510', '', '-20', '0', '0', NULL, '');
794 INSERT INTO `0_gl_trans` VALUES ('50', '26', '2', '2009-06-21', '1510', '', '-22', '0', '0', NULL, '');
795 INSERT INTO `0_gl_trans` VALUES ('51', '26', '2', '2009-06-21', '1510', '', '-24', '0', '0', NULL, '');
796 INSERT INTO `0_gl_trans` VALUES ('52', '26', '2', '2009-06-21', '1540', '', '66', '0', '0', NULL, '');
797 INSERT INTO `0_gl_trans` VALUES ('53', '26', '5', '2009-06-21', '1510', '', '-50', '0', '0', NULL, '');
798 INSERT INTO `0_gl_trans` VALUES ('54', '26', '5', '2009-06-21', '1510', '', '-55', '0', '0', NULL, '');
799 INSERT INTO `0_gl_trans` VALUES ('55', '26', '5', '2009-06-21', '1510', '', '-60', '0', '0', NULL, '');
800 INSERT INTO `0_gl_trans` VALUES ('56', '26', '5', '2009-06-21', '1060', 'Overhead Cost', '-10', '0', '0', '1', '1');
801 INSERT INTO `0_gl_trans` VALUES ('57', '26', '5', '2009-06-21', '1530', 'Overhead Cost', '10', '0', '0', '1', '1');
802 INSERT INTO `0_gl_trans` VALUES ('58', '26', '5', '2009-06-21', '1060', 'Labour Cost', '-20', '0', '0', '1', '0');
803 INSERT INTO `0_gl_trans` VALUES ('59', '26', '5', '2009-06-21', '1530', 'Labour Cost', '20', '0', '0', '1', '0');
804 INSERT INTO `0_gl_trans` VALUES ('60', '26', '5', '2009-06-21', '1540', '', '165', '0', '0', NULL, '');
805 INSERT INTO `0_gl_trans` VALUES ('61', '26', '6', '2009-06-21', '1510', '', '50', '0', '0', NULL, '');
806 INSERT INTO `0_gl_trans` VALUES ('62', '26', '6', '2009-06-21', '1510', '', '55', '0', '0', NULL, '');
807 INSERT INTO `0_gl_trans` VALUES ('63', '26', '6', '2009-06-21', '1510', '', '60', '0', '0', NULL, '');
808 INSERT INTO `0_gl_trans` VALUES ('64', '26', '6', '2009-06-21', '1540', '', '-165', '0', '0', NULL, '');
809 INSERT INTO `0_gl_trans` VALUES ('65', '26', '7', '2009-06-21', '1510', '', '20', '0', '0', NULL, '');
810 INSERT INTO `0_gl_trans` VALUES ('66', '26', '7', '2009-06-21', '1510', '', '22', '0', '0', NULL, '');
811 INSERT INTO `0_gl_trans` VALUES ('67', '26', '7', '2009-06-21', '1510', '', '24', '0', '0', NULL, '');
812 INSERT INTO `0_gl_trans` VALUES ('68', '26', '7', '2009-06-21', '1060', 'Overhead Cost', '-10', '0', '0', '1', '1');
813 INSERT INTO `0_gl_trans` VALUES ('69', '26', '7', '2009-06-21', '1530', 'Overhead Cost', '10', '0', '0', '1', '1');
814 INSERT INTO `0_gl_trans` VALUES ('70', '26', '7', '2009-06-21', '1060', 'Labour Cost', '-20', '0', '0', '1', '0');
815 INSERT INTO `0_gl_trans` VALUES ('71', '26', '7', '2009-06-21', '1530', 'Labour Cost', '20', '0', '0', '1', '0');
816 INSERT INTO `0_gl_trans` VALUES ('72', '26', '7', '2009-06-21', '1540', '', '-66', '0', '0', NULL, '');
817 INSERT INTO `0_gl_trans` VALUES ('73', '13', '5', '2009-06-21', '5010', '', '10', '0', '0', '2', '2');
818 INSERT INTO `0_gl_trans` VALUES ('74', '13', '5', '2009-06-21', '1510', '', '-10', '0', '0', '2', '2');
819 INSERT INTO `0_gl_trans` VALUES ('75', '10', '19', '2009-06-21', '4010', '', '-47.62', '0', '0', '2', '2');
820 INSERT INTO `0_gl_trans` VALUES ('76', '10', '19', '2009-06-21', '1200', '', '55', '0', '0', '2', '2');
821 INSERT INTO `0_gl_trans` VALUES ('77', '10', '19', '2009-06-21', '4430', '', '-5', '0', '0', '2', '2');
822 INSERT INTO `0_gl_trans` VALUES ('78', '10', '19', '2009-06-21', '2150', '', '-2.38', '0', '0', '2', '2');
823 INSERT INTO `0_gl_trans` VALUES ('79', '11', '3', '2009-06-21', '5010', '', '-10', '2', '0', '2', '3');
824 INSERT INTO `0_gl_trans` VALUES ('80', '11', '3', '2009-06-21', '1510', '', '10', '0', '0', '2', '3');
825 INSERT INTO `0_gl_trans` VALUES ('81', '11', '3', '2009-06-21', '4010', '', '50', '2', '0', '2', '3');
826 INSERT INTO `0_gl_trans` VALUES ('82', '11', '3', '2009-06-21', '1200', '', '-52.5', '0', '0', '2', '3');
827 INSERT INTO `0_gl_trans` VALUES ('83', '11', '3', '2009-06-21', '2150', '', '2.5', '0', '0', '2', '3');
830 ### Structure of table `0_grn_batch` ###
832 DROP TABLE IF EXISTS `0_grn_batch`;
834 CREATE TABLE `0_grn_batch` (
835 `id` int(11) NOT NULL auto_increment,
836 `supplier_id` int(11) NOT NULL default '0',
837 `purch_order_no` int(11) default NULL,
838 `reference` varchar(60) NOT NULL default '',
839 `delivery_date` date NOT NULL default '0000-00-00',
840 `loc_code` varchar(5) default NULL,
842 KEY(`delivery_date`),
843 KEY(`purch_order_no`)
844 ) TYPE=InnoDB AUTO_INCREMENT=2 ;
847 ### Data of table `0_grn_batch` ###
849 INSERT INTO `0_grn_batch` VALUES ('1', '2', '1', '1', '2009-06-21', 'DEF');
852 ### Structure of table `0_grn_items` ###
854 DROP TABLE IF EXISTS `0_grn_items`;
856 CREATE TABLE `0_grn_items` (
857 `id` int(11) NOT NULL auto_increment,
858 `grn_batch_id` int(11) default NULL,
859 `po_detail_item` int(11) NOT NULL default '0',
860 `item_code` varchar(20) NOT NULL default '',
861 `description` tinytext,
862 `qty_recd` double NOT NULL default '0',
863 `quantity_inv` double NOT NULL default '0',
866 ) TYPE=InnoDB AUTO_INCREMENT=4 ;
869 ### Data of table `0_grn_items` ###
871 INSERT INTO `0_grn_items` VALUES ('1', '1', '1', '102', '17inch VGA Monitor', '100', '100');
872 INSERT INTO `0_grn_items` VALUES ('2', '1', '2', '103', '32MB VGA Card', '100', '100');
873 INSERT INTO `0_grn_items` VALUES ('3', '1', '3', '104', '52x CD Drive', '100', '100');
876 ### Structure of table `0_groups` ###
878 DROP TABLE IF EXISTS `0_groups`;
880 CREATE TABLE `0_groups` (
881 `id` smallint(6) unsigned NOT NULL auto_increment,
882 `description` varchar(60) NOT NULL default '',
883 `inactive` tinyint(1) NOT NULL default '0',
885 UNIQUE KEY `description` (`description`)
886 ) TYPE=MyISAM AUTO_INCREMENT=4 AUTO_INCREMENT=4 ;
889 ### Data of table `0_groups` ###
891 INSERT INTO `0_groups` VALUES ('1', 'Small', '0');
892 INSERT INTO `0_groups` VALUES ('2', 'Medium', '0');
893 INSERT INTO `0_groups` VALUES ('3', 'Large', '0');
896 ### Structure of table `0_item_codes` ###
898 DROP TABLE IF EXISTS `0_item_codes`;
900 CREATE TABLE `0_item_codes` (
901 `id` int(11) unsigned NOT NULL auto_increment,
902 `item_code` varchar(20) NOT NULL,
903 `stock_id` varchar(20) NOT NULL,
904 `description` varchar(200) NOT NULL default '',
905 `category_id` smallint(6) unsigned NOT NULL,
906 `quantity` double NOT NULL default '1',
907 `is_foreign` tinyint(1) NOT NULL default '0',
908 `inactive` tinyint(1) NOT NULL default '0',
910 UNIQUE KEY `stock_id` (`stock_id`,`item_code`),
912 ) TYPE=MyISAM AUTO_INCREMENT=6 ;
915 ### Data of table `0_item_codes` ###
917 INSERT INTO `0_item_codes` VALUES ('1', '102', '102', '17inch VGA Monitor', '1', '1', '0', '0');
918 INSERT INTO `0_item_codes` VALUES ('2', '103', '103', '32MB VGA Card', '1', '1', '0', '0');
919 INSERT INTO `0_item_codes` VALUES ('3', '104', '104', '52x CD Drive', '1', '1', '0', '0');
920 INSERT INTO `0_item_codes` VALUES ('4', '3400', '3400', 'P4 Business System', '3', '1', '0', '0');
921 INSERT INTO `0_item_codes` VALUES ('5', '201', '201', 'Assembly Labour', '4', '1', '0', '0');
924 ### Structure of table `0_item_tax_type_exemptions` ###
926 DROP TABLE IF EXISTS `0_item_tax_type_exemptions`;
928 CREATE TABLE `0_item_tax_type_exemptions` (
929 `item_tax_type_id` int(11) NOT NULL default '0',
930 `tax_type_id` int(11) NOT NULL default '0',
931 PRIMARY KEY (`item_tax_type_id`,`tax_type_id`)
935 ### Data of table `0_item_tax_type_exemptions` ###
939 ### Structure of table `0_item_tax_types` ###
941 DROP TABLE IF EXISTS `0_item_tax_types`;
943 CREATE TABLE `0_item_tax_types` (
944 `id` int(11) NOT NULL auto_increment,
945 `name` varchar(60) NOT NULL default '',
946 `exempt` tinyint(1) NOT NULL default '0',
947 `inactive` tinyint(1) NOT NULL default '0',
949 UNIQUE KEY `name` (`name`)
950 ) TYPE=InnoDB AUTO_INCREMENT=2 ;
953 ### Data of table `0_item_tax_types` ###
955 INSERT INTO `0_item_tax_types` VALUES ('1', 'Regular', '0', '0');
957 ### Structure of table `0_item_units` ###
959 DROP TABLE IF EXISTS `0_item_units`;
961 CREATE TABLE `0_item_units` (
962 `abbr` varchar(20) NOT NULL,
963 `name` varchar(40) NOT NULL,
964 `decimals` tinyint(2) NOT NULL,
965 `inactive` tinyint(1) NOT NULL default '0',
966 PRIMARY KEY (`abbr`),
967 UNIQUE KEY `name` (`name`)
971 ### Data of table `0_item_units` ###
973 INSERT INTO `0_item_units` VALUES ('ea.', 'Each', '0', '0');
974 INSERT INTO `0_item_units` VALUES ('hrs', 'Hours', '1', '0');
977 ### Structure of table `0_loc_stock` ###
979 DROP TABLE IF EXISTS `0_loc_stock`;
981 CREATE TABLE `0_loc_stock` (
982 `loc_code` char(5) NOT NULL default '',
983 `stock_id` char(20) NOT NULL default '',
984 `reorder_level` bigint(20) NOT NULL default '0',
985 PRIMARY KEY (`loc_code`,`stock_id`),
986 KEY `stock_id` (`stock_id`)
990 ### Data of table `0_loc_stock` ###
992 INSERT INTO `0_loc_stock` VALUES ('DEF', '102', '0');
993 INSERT INTO `0_loc_stock` VALUES ('DEF', '103', '0');
994 INSERT INTO `0_loc_stock` VALUES ('DEF', '104', '0');
995 INSERT INTO `0_loc_stock` VALUES ('DEF', '201', '0');
996 INSERT INTO `0_loc_stock` VALUES ('DEF', '3400', '0');
999 ### Structure of table `0_locations` ###
1001 DROP TABLE IF EXISTS `0_locations`;
1003 CREATE TABLE `0_locations` (
1004 `loc_code` varchar(5) NOT NULL default '',
1005 `location_name` varchar(60) NOT NULL default '',
1006 `delivery_address` tinytext NOT NULL,
1007 `phone` varchar(30) NOT NULL default '',
1008 `phone2` varchar(30) NOT NULL default '',
1009 `fax` varchar(30) NOT NULL default '',
1010 `email` varchar(100) NOT NULL default '',
1011 `contact` varchar(30) NOT NULL default '',
1012 `inactive` tinyint(1) NOT NULL default '0',
1013 PRIMARY KEY (`loc_code`)
1017 ### Data of table `0_locations` ###
1019 INSERT INTO `0_locations` VALUES ('DEF', 'Default', 'Delivery 1\r\nDelivery 2\r\nDelivery 3', '', '', '', '', '', '0');
1022 ### Structure of table `0_movement_types` ###
1024 DROP TABLE IF EXISTS `0_movement_types`;
1026 CREATE TABLE `0_movement_types` (
1027 `id` int(11) NOT NULL auto_increment,
1028 `name` varchar(60) NOT NULL default '',
1029 `inactive` tinyint(1) NOT NULL default '0',
1031 UNIQUE KEY `name` (`name`)
1032 ) TYPE=MyISAM AUTO_INCREMENT=2 ;
1035 ### Data of table `0_movement_types` ###
1037 INSERT INTO `0_movement_types` VALUES ('1', 'Adjustment', '0');
1040 ### Structure of table `0_payment_terms` ###
1042 DROP TABLE IF EXISTS `0_payment_terms`;
1044 CREATE TABLE `0_payment_terms` (
1045 `terms_indicator` int(11) NOT NULL auto_increment,
1046 `terms` char(80) NOT NULL default '',
1047 `days_before_due` smallint(6) NOT NULL default '0',
1048 `day_in_following_month` smallint(6) NOT NULL default '0',
1049 `inactive` tinyint(1) NOT NULL default '0',
1050 PRIMARY KEY (`terms_indicator`),
1051 UNIQUE KEY `terms` (`terms`)
1052 ) TYPE=MyISAM AUTO_INCREMENT=5 ;
1055 ### Data of table `0_payment_terms` ###
1057 INSERT INTO `0_payment_terms` VALUES ('1', 'Due 15th Of the Following Month', '0', '17', '0');
1058 INSERT INTO `0_payment_terms` VALUES ('2', 'Due By End Of The Following Month', '0', '30', '0');
1059 INSERT INTO `0_payment_terms` VALUES ('3', 'Payment due within 10 days', '10', '0', '0');
1060 INSERT INTO `0_payment_terms` VALUES ('4', 'Cash Only', '1', '0', '0');
1063 ### Structure of table `0_prices` ###
1065 DROP TABLE IF EXISTS `0_prices`;
1067 CREATE TABLE `0_prices` (
1068 `id` int(11) NOT NULL auto_increment,
1069 `stock_id` varchar(20) NOT NULL default '',
1070 `sales_type_id` int(11) NOT NULL default '0',
1071 `curr_abrev` char(3) NOT NULL default '',
1072 `price` double NOT NULL default '0',
1074 UNIQUE KEY `price` (`stock_id`,`sales_type_id`,`curr_abrev`)
1075 ) TYPE=MyISAM AUTO_INCREMENT=5 ;
1078 ### Data of table `0_prices` ###
1080 INSERT INTO `0_prices` VALUES ('1', '3400', '1', 'USD', '100');
1081 INSERT INTO `0_prices` VALUES ('2', '102', '1', 'USD', '50');
1082 INSERT INTO `0_prices` VALUES ('3', '103', '1', 'USD', '55');
1083 INSERT INTO `0_prices` VALUES ('4', '104', '1', 'USD', '60');
1086 ### Structure of table `0_print_profiles` ###
1088 DROP TABLE IF EXISTS `0_print_profiles`;
1090 CREATE TABLE `0_print_profiles` (
1091 `id` smallint(6) unsigned NOT NULL auto_increment,
1092 `profile` varchar(30) NOT NULL,
1093 `report` varchar(5) default NULL,
1094 `printer` tinyint(3) unsigned default NULL,
1096 UNIQUE KEY `profile` (`profile`,`report`)
1097 ) TYPE=MyISAM AUTO_INCREMENT=10 ;
1100 ### Data of table `0_print_profiles` ###
1102 INSERT INTO `0_print_profiles` VALUES ('1', 'Out of office', '', '0');
1103 INSERT INTO `0_print_profiles` VALUES ('2', 'Sales Department', '', '0');
1104 INSERT INTO `0_print_profiles` VALUES ('3', 'Central', '', '2');
1105 INSERT INTO `0_print_profiles` VALUES ('4', 'Sales Department', '104', '2');
1106 INSERT INTO `0_print_profiles` VALUES ('5', 'Sales Department', '105', '2');
1107 INSERT INTO `0_print_profiles` VALUES ('6', 'Sales Department', '107', '2');
1108 INSERT INTO `0_print_profiles` VALUES ('7', 'Sales Department', '109', '2');
1109 INSERT INTO `0_print_profiles` VALUES ('8', 'Sales Department', '110', '2');
1110 INSERT INTO `0_print_profiles` VALUES ('9', 'Sales Department', '201', '2');
1113 ### Structure of table `0_printers` ###
1115 DROP TABLE IF EXISTS `0_printers`;
1117 CREATE TABLE `0_printers` (
1118 `id` tinyint(3) unsigned NOT NULL auto_increment,
1119 `name` varchar(20) NOT NULL,
1120 `description` varchar(60) NOT NULL,
1121 `queue` varchar(20) NOT NULL,
1122 `host` varchar(40) NOT NULL,
1123 `port` smallint(11) unsigned NOT NULL,
1124 `timeout` tinyint(3) unsigned NOT NULL,
1126 UNIQUE KEY `name` (`name`)
1127 ) TYPE=MyISAM AUTO_INCREMENT=4 ;
1130 ### Data of table `0_printers` ###
1132 INSERT INTO `0_printers` VALUES ('1', 'QL500', 'Label printer', 'QL500', 'server', '127', '20');
1133 INSERT INTO `0_printers` VALUES ('2', 'Samsung', 'Main network printer', 'scx4521F', 'server', '515', '5');
1134 INSERT INTO `0_printers` VALUES ('3', 'Local', 'Local print server at user IP', 'lp', '', '515', '10');
1137 ### Structure of table `0_purch_data` ###
1139 DROP TABLE IF EXISTS `0_purch_data`;
1141 CREATE TABLE `0_purch_data` (
1142 `supplier_id` int(11) NOT NULL default '0',
1143 `stock_id` char(20) NOT NULL default '',
1144 `price` double NOT NULL default '0',
1145 `suppliers_uom` char(50) NOT NULL default '',
1146 `conversion_factor` double NOT NULL default '1',
1147 `supplier_description` char(50) NOT NULL default '',
1148 PRIMARY KEY (`supplier_id`,`stock_id`)
1152 ### Data of table `0_purch_data` ###
1154 INSERT INTO `0_purch_data` VALUES ('2', '102', '10', '', '1', '17inch VGA Monitor');
1155 INSERT INTO `0_purch_data` VALUES ('2', '103', '11', '', '1', '32MB VGA Card');
1156 INSERT INTO `0_purch_data` VALUES ('2', '104', '12', '', '1', '52x CD Drive');
1159 ### Structure of table `0_purch_order_details` ###
1161 DROP TABLE IF EXISTS `0_purch_order_details`;
1163 CREATE TABLE `0_purch_order_details` (
1164 `po_detail_item` int(11) NOT NULL auto_increment,
1165 `order_no` int(11) NOT NULL default '0',
1166 `item_code` varchar(20) NOT NULL default '',
1167 `description` tinytext,
1168 `delivery_date` date NOT NULL default '0000-00-00',
1169 `qty_invoiced` double NOT NULL default '0',
1170 `unit_price` double NOT NULL default '0',
1171 `act_price` double NOT NULL default '0',
1172 `std_cost_unit` double NOT NULL default '0',
1173 `quantity_ordered` double NOT NULL default '0',
1174 `quantity_received` double NOT NULL default '0',
1175 PRIMARY KEY (`po_detail_item`),
1176 KEY `order` (`order_no`, `po_detail_item`)
1177 ) TYPE=InnoDB AUTO_INCREMENT=6 ;
1180 ### Data of table `0_purch_order_details` ###
1182 INSERT INTO `0_purch_order_details` VALUES ('1', '1', '102', '17inch VGA Monitor', '2009-07-01', '100', '10', '10', '10', '100', '100');
1183 INSERT INTO `0_purch_order_details` VALUES ('2', '1', '103', '32MB VGA Card', '2009-07-01', '100', '11', '11', '11', '100', '100');
1184 INSERT INTO `0_purch_order_details` VALUES ('3', '1', '104', '52x CD Drive', '2009-07-01', '100', '12', '12', '12', '100', '100');
1185 INSERT INTO `0_purch_order_details` VALUES ('4', '2', '102', '17inch VGA Monitor', '2009-07-01', '0', '5', '0', '0', '1', '0');
1186 INSERT INTO `0_purch_order_details` VALUES ('5', '2', '103', '32MB VGA Card', '2009-07-01', '0', '5', '0', '0', '1', '0');
1189 ### Structure of table `0_purch_orders` ###
1191 DROP TABLE IF EXISTS `0_purch_orders`;
1193 CREATE TABLE `0_purch_orders` (
1194 `order_no` int(11) NOT NULL auto_increment,
1195 `supplier_id` int(11) NOT NULL default '0',
1196 `comments` tinytext,
1197 `ord_date` date NOT NULL default '0000-00-00',
1198 `reference` tinytext NOT NULL,
1199 `requisition_no` tinytext,
1200 `into_stock_location` varchar(5) NOT NULL default '',
1201 `delivery_address` tinytext NOT NULL,
1202 PRIMARY KEY (`order_no`),
1204 ) TYPE=InnoDB AUTO_INCREMENT=3 ;
1207 ### Data of table `0_purch_orders` ###
1209 INSERT INTO `0_purch_orders` VALUES ('1', '2', '', '2009-06-01', '1', '', 'DEF', 'Delivery 1\r\nDelivery 2\r\nDelivery 3');
1210 INSERT INTO `0_purch_orders` VALUES ('2', '3', '', '2009-06-21', '2', '', 'DEF', 'Delivery 1\r\nDelivery 2\r\nDelivery 3');
1213 ### Structure of table `0_quick_entries` ###
1215 DROP TABLE IF EXISTS `0_quick_entries`;
1217 CREATE TABLE `0_quick_entries` (
1218 `id` smallint(6) unsigned NOT NULL auto_increment,
1219 `type` tinyint(1) NOT NULL default '0',
1220 `description` varchar(60) NOT NULL,
1221 `base_amount` double NOT NULL default '0',
1222 `base_desc` varchar(60) default NULL,
1223 `bal_type` tinyint(1) NOT NULL default '0',
1225 KEY `description` (`description`)
1226 ) TYPE=MyISAM AUTO_INCREMENT=4 ;
1229 ### Data of table `0_quick_entries` ###
1231 INSERT INTO `0_quick_entries` VALUES ('1', '1', 'Maintenance', '0', 'Amount', '0');
1232 INSERT INTO `0_quick_entries` VALUES ('2', '4', 'Phone', '0', 'Amount', '0');
1233 INSERT INTO `0_quick_entries` VALUES ('3', '2', 'Cash Sales', '0', 'Amount', '0');
1236 ### Structure of table `0_quick_entry_lines` ###
1238 DROP TABLE IF EXISTS `0_quick_entry_lines`;
1240 CREATE TABLE `0_quick_entry_lines` (
1241 `id` smallint(6) unsigned NOT NULL auto_increment,
1242 `qid` smallint(6) unsigned NOT NULL,
1243 `amount` double default '0',
1244 `action` varchar(2) NOT NULL,
1245 `dest_id` varchar(11) NOT NULL,
1246 `dimension_id` smallint(6) unsigned default NULL,
1247 `dimension2_id` smallint(6) unsigned default NULL,
1250 ) TYPE=MyISAM AUTO_INCREMENT=8 ;
1253 ### Data of table `0_quick_entry_lines` ###
1255 INSERT INTO `0_quick_entry_lines` VALUES ('1', '1', '0', 't-', '1', '0', '0');
1256 INSERT INTO `0_quick_entry_lines` VALUES ('2', '2', '0', 't-', '1', '0', '0');
1257 INSERT INTO `0_quick_entry_lines` VALUES ('3', '3', '0', 't-', '1', '0', '0');
1258 INSERT INTO `0_quick_entry_lines` VALUES ('4', '3', '0', '=', '4010', '0', '0');
1259 INSERT INTO `0_quick_entry_lines` VALUES ('5', '1', '0', '=', '5765', '0', '0');
1260 INSERT INTO `0_quick_entry_lines` VALUES ('6', '2', '0', '=', '5780', '0', '0');
1263 ### Structure of table `0_recurrent_invoices` ###
1265 DROP TABLE IF EXISTS `0_recurrent_invoices`;
1267 CREATE TABLE `0_recurrent_invoices` (
1268 `id` smallint(6) unsigned NOT NULL auto_increment,
1269 `description` varchar(60) NOT NULL default '',
1270 `order_no` int(11) unsigned NOT NULL,
1271 `debtor_no` int(11) unsigned default NULL,
1272 `group_no` smallint(6) unsigned default NULL,
1273 `days` int(11) NOT NULL default '0',
1274 `monthly` int(11) NOT NULL default '0',
1275 `begin` date NOT NULL default '0000-00-00',
1276 `end` date NOT NULL default '0000-00-00',
1277 `last_sent` date NOT NULL default '0000-00-00',
1279 UNIQUE KEY `description` (`description`)
1280 ) TYPE=InnoDB AUTO_INCREMENT=1 ;
1283 ### Data of table `0_recurrent_invoices` ###
1287 ### Structure of table `0_refs` ###
1289 DROP TABLE IF EXISTS `0_refs`;
1291 CREATE TABLE `0_refs` (
1292 `id` int(11) NOT NULL default '0',
1293 `type` int(11) NOT NULL default '0',
1294 `reference` varchar(100) NOT NULL default '',
1295 PRIMARY KEY (`id`,`type`),
1296 KEY `Type_and_Reference` (`type`,`reference`)
1300 ### Data of table `0_refs` ###
1302 INSERT INTO `0_refs` VALUES ('18', '0', '1');
1303 INSERT INTO `0_refs` VALUES ('19', '0', '2');
1306 ### Structure of table `0_sales_order_details` ###
1308 DROP TABLE IF EXISTS `0_sales_order_details`;
1310 CREATE TABLE `0_sales_order_details` (
1311 `id` int(11) NOT NULL auto_increment,
1312 `order_no` int(11) NOT NULL default '0',
1313 `trans_type` smallint(6) NOT NULL default '30',
1314 `stk_code` varchar(20) NOT NULL default '',
1315 `description` tinytext,
1316 `qty_sent` double NOT NULL default '0',
1317 `unit_price` double NOT NULL default '0',
1318 `quantity` double NOT NULL default '0',
1319 `discount_percent` double NOT NULL default '0',
1321 KEY `sorder` (`trans_type`, `order_no`)
1322 ) TYPE=InnoDB AUTO_INCREMENT=6 ;
1325 ### Data of table `0_sales_order_details` ###
1327 INSERT INTO `0_sales_order_details` VALUES ('1', '1', '30', '102', '17inch VGA Monitor', '2', '30.4', '2', '0');
1328 INSERT INTO `0_sales_order_details` VALUES ('2', '2', '30', '102', '17inch VGA Monitor', '1', '50', '1', '0');
1329 INSERT INTO `0_sales_order_details` VALUES ('3', '3', '30', '102', '17inch VGA Monitor', '1', '35.89', '1', '0');
1330 INSERT INTO `0_sales_order_details` VALUES ('4', '4', '30', '102', '17inch VGA Monitor', '0', '21.28', '2', '0');
1331 INSERT INTO `0_sales_order_details` VALUES ('5', '5', '30', '102', '17inch VGA Monitor', '1', '50', '1', '0');
1334 ### Structure of table `0_sales_orders` ###
1336 DROP TABLE IF EXISTS `0_sales_orders`;
1338 CREATE TABLE `0_sales_orders` (
1339 `order_no` int(11) NOT NULL,
1340 `trans_type` smallint(6) NOT NULL default '30',
1341 `version` tinyint(1) unsigned NOT NULL default '0',
1342 `type` tinyint(1) NOT NULL default '0',
1343 `debtor_no` int(11) NOT NULL default '0',
1344 `branch_code` int(11) NOT NULL default '0',
1345 `reference` varchar(100) NOT NULL default '',
1346 `customer_ref` tinytext NOT NULL,
1347 `comments` tinytext,
1348 `ord_date` date NOT NULL default '0000-00-00',
1349 `order_type` int(11) NOT NULL default '0',
1350 `ship_via` int(11) NOT NULL default '0',
1351 `delivery_address` tinytext NOT NULL,
1352 `contact_phone` varchar(30) default NULL,
1353 `contact_email` varchar(100) default NULL,
1354 `deliver_to` tinytext NOT NULL,
1355 `freight_cost` double NOT NULL default '0',
1356 `from_stk_loc` varchar(5) NOT NULL default '',
1357 `delivery_date` date NOT NULL default '0000-00-00',
1358 PRIMARY KEY (`trans_type`, `order_no`)
1361 ### Data of table `0_sales_orders` ###
1363 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');
1364 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');
1365 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');
1366 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');
1367 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');
1370 ### Structure of table `0_sales_pos` ###
1372 DROP TABLE IF EXISTS `0_sales_pos`;
1374 CREATE TABLE `0_sales_pos` (
1375 `id` smallint(6) unsigned NOT NULL auto_increment,
1376 `pos_name` varchar(30) NOT NULL,
1377 `cash_sale` tinyint(1) NOT NULL,
1378 `credit_sale` tinyint(1) NOT NULL,
1379 `pos_location` varchar(5) NOT NULL,
1380 `pos_account` smallint(6) unsigned NOT NULL,
1381 `inactive` tinyint(1) NOT NULL default '0',
1383 UNIQUE KEY `pos_name` (`pos_name`)
1384 ) TYPE=MyISAM AUTO_INCREMENT=2 ;
1387 ### Data of table `0_sales_pos` ###
1389 INSERT INTO `0_sales_pos` VALUES ('1', 'Default', '1', '1', 'DEF', '2', '0');
1392 ### Structure of table `0_sales_types` ###
1394 DROP TABLE IF EXISTS `0_sales_types`;
1396 CREATE TABLE `0_sales_types` (
1397 `id` int(11) NOT NULL auto_increment,
1398 `sales_type` char(50) NOT NULL default '',
1399 `tax_included` int(1) NOT NULL default '0',
1400 `factor` double NOT NULL default '1',
1401 `inactive` tinyint(1) NOT NULL default '0',
1403 UNIQUE KEY `sales_type` (`sales_type`)
1404 ) TYPE=MyISAM AUTO_INCREMENT=3 ;
1407 ### Data of table `0_sales_types` ###
1409 INSERT INTO `0_sales_types` VALUES ('1', 'Retail', '1', '1', '0');
1410 INSERT INTO `0_sales_types` VALUES ('2', 'Wholesale', '0', '0.7', '0');
1413 ### Structure of table `0_salesman` ###
1415 DROP TABLE IF EXISTS `0_salesman`;
1417 CREATE TABLE `0_salesman` (
1418 `salesman_code` int(11) NOT NULL auto_increment,
1419 `salesman_name` char(60) NOT NULL default '',
1420 `salesman_phone` char(30) NOT NULL default '',
1421 `salesman_fax` char(30) NOT NULL default '',
1422 `salesman_email` varchar(100) NOT NULL default '',
1423 `provision` double NOT NULL default '0',
1424 `break_pt` double NOT NULL default '0',
1425 `provision2` double NOT NULL default '0',
1426 `inactive` tinyint(1) NOT NULL default '0',
1427 PRIMARY KEY (`salesman_code`),
1428 UNIQUE KEY `salesman_name` (`salesman_name`)
1429 ) TYPE=MyISAM AUTO_INCREMENT=2 ;
1432 ### Data of table `0_salesman` ###
1434 INSERT INTO `0_salesman` VALUES ('1', 'Sales Person', '', '', '', '5', '1000', '4', '0');
1436 ### Structure of table `0_security_roles` ###
1438 DROP TABLE IF EXISTS `0_security_roles`;
1439 CREATE TABLE IF NOT EXISTS `0_security_roles` (
1440 `id` int(11) NOT NULL auto_increment,
1441 `role` varchar(30) NOT NULL,
1442 `description` varchar(50) default NULL,
1445 `inactive` tinyint(1) NOT NULL default '0',
1447 UNIQUE KEY `role` (`role`)
1448 ) TYPE=MyISAM AUTO_INCREMENT=11 ;
1451 -- Data of table `0_security_roles`
1454 INSERT INTO `0_security_roles` VALUES (1, 'Inquiries', 'Inquiries', '768;2816;3072;3328;5632;5888;8192;8448;10752;11008;13312;15872;16128', '257;258;259;260;513;514;515;516;517;518;519;520;521;522;523;524;525;773;774;2822;3073;3075;3076;3077;3329;3330;3331;3332;3333;3334;3335;5377;5633;5640;5889;5890;5891;7937;7938;7939;7940;8193;8194;8450;8451;10497;10753;11009;11010;11012;13313;13315;15617;15618;15619;15620;15621;15622;15623;15624;15625;15626;15873;15882;16129;16130;16131;16132', 0);
1455 INSERT INTO `0_security_roles` VALUES (2, 'System Administrator', 'System Administrator', '256;512;768;2816;3072;3328;5376;5632;5888;7936;8192;8448;10496;10752;11008;13056;13312;15616;15872;16128', '257;258;259;260;513;514;515;516;517;518;519;520;521;522;523;524;525;769;770;771;772;773;774;2817;2818;2819;2820;2821;2822;2823;3073;3074;3082;3075;3076;3077;3078;3079;3080;3081;3329;3330;3331;3332;3333;3334;3335;5377;5633;5634;5635;5636;5637;5641;5638;5639;5640;5889;5890;5891;7937;7938;7939;7940;8193;8194;8195;8196;8197;8449;8450;8451;10497;10753;10754;10755;10756;10757;11009;11010;11012;13057;13313;13314;13315;15617;15618;15619;15620;15621;15622;15623;15624;15625;15626;15627;15873;15874;15875;15876;15877;15878;15879;15880;15883;15881;15882;16129;16130;16131;16132', 0);
1456 INSERT INTO `0_security_roles` VALUES (3, 'Salesman', 'Salesman', '768;3072;5632;8192;15872', '773;774;3073;3075;3081;5633;8194;15873', 0);
1457 INSERT INTO `0_security_roles` VALUES (4, 'Stock Manager', 'Stock Manager', '2816;3072;3328;5632;5888;8192;8448;10752;11008;13312;15872;16128', '2818;2822;3073;3076;3077;3329;3330;3330;3330;3331;3331;3332;3333;3334;3335;5633;5640;5889;5890;5891;8193;8194;8450;8451;10753;11009;11010;11012;13313;13315;15882;16129;16130;16131;16132', 0);
1458 INSERT INTO `0_security_roles` VALUES (5, 'Production Manager', 'Production Manager', '512;2816;3072;3328;5632;5888;8192;8448;10752;11008;13312;15616;15872;16128', '521;523;524;2818;2819;2820;2821;2822;2823;3073;3074;3076;3077;3078;3079;3080;3081;3329;3330;3330;3330;3331;3331;3332;3333;3334;3335;5633;5640;5640;5889;5890;5891;8193;8194;8196;8197;8450;8451;10753;10755;11009;11010;11012;13313;13315;15617;15619;15620;15621;15624;15624;15876;15877;15880;15882;16129;16130;16131;16132', 0);
1459 INSERT INTO `0_security_roles` VALUES (6, 'Purchase Officer', 'Purchase Officer', '512;2816;3072;3328;5376;5632;5888;8192;8448;10752;11008;13312;15616;15872;16128', '521;523;524;2818;2819;2820;2821;2822;2823;3073;3074;3076;3077;3078;3079;3080;3081;3329;3330;3330;3330;3331;3331;3332;3333;3334;3335;5377;5633;5635;5640;5640;5889;5890;5891;8193;8194;8196;8197;8449;8450;8451;10753;10755;11009;11010;11012;13313;13315;15617;15619;15620;15621;15624;15624;15876;15877;15880;15882;16129;16130;16131;16132', 0);
1460 INSERT INTO `0_security_roles` VALUES (7, 'AR Officer', 'AR Officer', '512;768;2816;3072;3328;5632;5888;8192;8448;10752;11008;13312;15616;15872;16128', '521;523;524;771;773;774;2818;2819;2820;2821;2822;2823;3073;3073;3074;3075;3076;3077;3078;3079;3080;3081;3081;3329;3330;3330;3330;3331;3331;3332;3333;3334;3335;5633;5633;5634;5637;5638;5639;5640;5640;5889;5890;5891;8193;8194;8194;8196;8197;8450;8451;10753;10755;11009;11010;11012;13313;13315;15617;15619;15620;15621;15624;15624;15873;15876;15877;15878;15880;15882;16129;16130;16131;16132', 0);
1461 INSERT INTO `0_security_roles` VALUES (8, 'AP Officer', 'AP Officer', '512;2816;3072;3328;5376;5632;5888;8192;8448;10752;11008;13312;15616;15872;16128', '257;258;259;260;521;523;524;769;770;771;772;773;774;2818;2819;2820;2821;2822;2823;3073;3074;3082;3076;3077;3078;3079;3080;3081;3329;3330;3331;3332;3333;3334;3335;5377;5633;5635;5640;5889;5890;5891;7937;7938;7939;7940;8193;8194;8196;8197;8449;8450;8451;10497;10753;10755;11009;11010;11012;13057;13313;13315;15617;15619;15620;15621;15624;15876;15877;15880;15882;16129;16130;16131;16132', 0);
1462 INSERT INTO `0_security_roles` VALUES (9, 'Accountant', 'New Accountant', '512;768;2816;3072;3328;5376;5632;5888;8192;8448;10752;11008;13312;15616;15872;16128', '257;258;259;260;521;523;524;771;772;773;774;2818;2819;2820;2821;2822;2823;3073;3074;3075;3076;3077;3078;3079;3080;3081;3329;3330;3331;3332;3333;3334;3335;5377;5633;5634;5635;5637;5638;5639;5640;5889;5890;5891;7937;7938;7939;7940;8193;8194;8196;8197;8449;8450;8451;10497;10753;10755;11009;11010;11012;13313;13315;15617;15618;15619;15620;15621;15624;15873;15876;15877;15878;15880;15882;16129;16130;16131;16132', 0);
1463 INSERT INTO `0_security_roles` VALUES (10, 'Sub Admin', 'Sub Admin', '512;768;2816;3072;3328;5376;5632;5888;8192;8448;10752;11008;13312;15616;15872;16128', '257;258;259;260;521;523;524;771;772;773;774;2818;2819;2820;2821;2822;2823;3073;3074;3082;3075;3076;3077;3078;3079;3080;3081;3329;3330;3331;3332;3333;3334;3335;5377;5633;5634;5635;5637;5638;5639;5640;5889;5890;5891;7937;7938;7939;7940;8193;8194;8196;8197;8449;8450;8451;10497;10753;10755;11009;11010;11012;13057;13313;13315;15617;15619;15620;15621;15624;15873;15874;15876;15877;15878;15879;15880;15882;16129;16130;16131;16132', 0);
1465 ### Structure of table `0_shippers` ###
1467 DROP TABLE IF EXISTS `0_shippers`;
1469 CREATE TABLE `0_shippers` (
1470 `shipper_id` int(11) NOT NULL auto_increment,
1471 `shipper_name` varchar(60) NOT NULL default '',
1472 `phone` varchar(30) NOT NULL default '',
1473 `phone2` varchar(30) NOT NULL default '',
1474 `contact` tinytext NOT NULL,
1475 `address` tinytext NOT NULL,
1476 `inactive` tinyint(1) NOT NULL default '0',
1477 PRIMARY KEY (`shipper_id`),
1478 UNIQUE KEY `name` (`shipper_name`)
1479 ) TYPE=MyISAM AUTO_INCREMENT=2 ;
1482 ### Data of table `0_shippers` ###
1484 INSERT INTO `0_shippers` VALUES ('1', 'Default', '', '', '', '', '0');
1487 ### Structure of table `0_sql_trail` ###
1489 DROP TABLE IF EXISTS `0_sql_trail`;
1491 CREATE TABLE `0_sql_trail` (
1492 `id` int(11) unsigned NOT NULL auto_increment,
1493 `sql` text NOT NULL,
1494 `result` tinyint(1) NOT NULL,
1495 `msg` varchar(255) NOT NULL,
1497 ) TYPE=MyISAM AUTO_INCREMENT=1 ;
1500 ### Data of table `0_sql_trail` ###
1504 ### Structure of table `0_stock_category` ###
1506 DROP TABLE IF EXISTS `0_stock_category`;
1508 CREATE TABLE `0_stock_category` (
1509 `category_id` int(11) NOT NULL auto_increment,
1510 `description` varchar(60) NOT NULL default '',
1511 `dflt_tax_type` int(11) NOT NULL default '1',
1512 `dflt_units` varchar(20) NOT NULL default 'each',
1513 `dflt_mb_flag` char(1) NOT NULL default 'B',
1514 `dflt_sales_act` varchar(11) NOT NULL default '',
1515 `dflt_cogs_act` varchar(11) NOT NULL default '',
1516 `dflt_inventory_act` varchar(11) NOT NULL default '',
1517 `dflt_adjustment_act` varchar(11) NOT NULL default '',
1518 `dflt_assembly_act` varchar(11) NOT NULL default '',
1519 `dflt_dim1` int(11) default NULL,
1520 `dflt_dim2` int(11) default NULL,
1521 `inactive` tinyint(1) NOT NULL default '0',
1522 `dflt_no_sale` tinyint(1) NOT NULL default '0',
1523 PRIMARY KEY (`category_id`),
1524 UNIQUE KEY `description` (`description`)
1525 ) TYPE=MyISAM AUTO_INCREMENT=5 ;
1527 ### Data of table `0_stock_category` ###
1529 INSERT INTO `0_stock_category` VALUES ('1', 'Components', '1', 'each', 'B', '4010', '5010', '1510', '5040', '1530', '0', '0', '0', '0');
1530 INSERT INTO `0_stock_category` VALUES ('2', 'Charges', '1', 'each', 'D', '4010', '5010', '1510', '5040', '1530', '0', '0', '0', '0');
1531 INSERT INTO `0_stock_category` VALUES ('3', 'Systems', '1', 'each', 'M', '4010', '5010', '1510', '5040', '1530', '0', '0', '0', '0');
1532 INSERT INTO `0_stock_category` VALUES ('4', 'Services', '1', 'hrs', 'D', '4010', '5010', '1510', '5040', '1530', '0', '0', '0', '0');
1535 ### Structure of table `0_stock_master` ###
1537 DROP TABLE IF EXISTS `0_stock_master`;
1539 CREATE TABLE `0_stock_master` (
1540 `stock_id` varchar(20) NOT NULL default '',
1541 `category_id` int(11) NOT NULL default '0',
1542 `tax_type_id` int(11) NOT NULL default '0',
1543 `description` varchar(200) NOT NULL default '',
1544 `long_description` tinytext NOT NULL,
1545 `units` varchar(20) NOT NULL default 'each',
1546 `mb_flag` char(1) NOT NULL default 'B',
1547 `sales_account` varchar(11) NOT NULL default '',
1548 `cogs_account` varchar(11) NOT NULL default '',
1549 `inventory_account` varchar(11) NOT NULL default '',
1550 `adjustment_account` varchar(11) NOT NULL default '',
1551 `assembly_account` varchar(11) NOT NULL default '',
1552 `dimension_id` int(11) default NULL,
1553 `dimension2_id` int(11) default NULL,
1554 `actual_cost` double NOT NULL default '0',
1555 `last_cost` double NOT NULL default '0',
1556 `material_cost` double NOT NULL default '0',
1557 `labour_cost` double NOT NULL default '0',
1558 `overhead_cost` double NOT NULL default '0',
1559 `inactive` tinyint(1) NOT NULL default '0',
1560 `no_sale` tinyint(1) NOT NULL default '0',
1561 `editable` tinyint(1) NOT NULL default '0',
1562 PRIMARY KEY (`stock_id`)
1566 ### Data of table `0_stock_master` ###
1568 INSERT INTO `0_stock_master` VALUES ('102', '1', '1', '17inch VGA Monitor', '', 'ea.', 'B', '4010', '5010', '1510', '5040', '1530', '0', '0', '0', '0', '10', '0', '0', '0', '0', '0');
1569 INSERT INTO `0_stock_master` VALUES ('103', '1', '1', '32MB VGA Card', '', 'ea.', 'B', '4010', '5010', '1510', '5040', '1530', '0', '0', '0', '0', '11', '0', '0', '0', '0', '0');
1570 INSERT INTO `0_stock_master` VALUES ('104', '1', '1', '52x CD Drive', '', 'ea.', 'B', '4010', '5010', '1510', '5040', '1530', '0', '0', '0', '0', '12', '0', '0', '0', '0', '0');
1571 INSERT INTO `0_stock_master` VALUES ('201', '4', '1', 'Assembly Labour', '', 'hrs', 'D', '4010', '5010', '5010', '5040', '1530', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');
1572 INSERT INTO `0_stock_master` VALUES ('3400', '3', '1', 'P4 Business System', '', 'ea.', 'M', '4010', '5010', '1540', '5040', '1530', '0', '0', '0', '0', '33', '3.9999999999999', '2', '0', '0', '0');
1575 ### Structure of table `0_stock_moves` ###
1577 DROP TABLE IF EXISTS `0_stock_moves`;
1579 CREATE TABLE `0_stock_moves` (
1580 `trans_id` int(11) NOT NULL auto_increment,
1581 `trans_no` int(11) NOT NULL default '0',
1582 `stock_id` char(20) NOT NULL default '',
1583 `type` smallint(6) NOT NULL default '0',
1584 `loc_code` char(5) NOT NULL default '',
1585 `tran_date` date NOT NULL default '0000-00-00',
1586 `person_id` int(11) default NULL,
1587 `price` double NOT NULL default '0',
1588 `reference` char(40) NOT NULL default '',
1589 `qty` double NOT NULL default '1',
1590 `discount_percent` double NOT NULL default '0',
1591 `standard_cost` double NOT NULL default '0',
1592 `visible` tinyint(1) NOT NULL default '1',
1593 PRIMARY KEY (`trans_id`),
1594 KEY `type` (`type`,`trans_no`),
1595 KEY `Move` (`stock_id`,`loc_code`, `tran_date`)
1596 ) TYPE=InnoDB AUTO_INCREMENT=37 ;
1599 ### Data of table `0_stock_moves` ###
1601 INSERT INTO `0_stock_moves` VALUES ('1', '1', '102', '25', 'DEF', '2009-06-21', '2', '10', '', '100', '0', '10', '1');
1602 INSERT INTO `0_stock_moves` VALUES ('2', '1', '103', '25', 'DEF', '2009-06-21', '2', '11', '', '100', '0', '11', '1');
1603 INSERT INTO `0_stock_moves` VALUES ('3', '1', '104', '25', 'DEF', '2009-06-21', '2', '12', '', '100', '0', '12', '1');
1604 INSERT INTO `0_stock_moves` VALUES ('4', '1', '102', '26', 'DEF', '2009-06-21', '0', '0', '1', '-10', '0', '0', '1');
1605 INSERT INTO `0_stock_moves` VALUES ('5', '1', '103', '26', 'DEF', '2009-06-21', '0', '0', '1', '-10', '0', '0', '1');
1606 INSERT INTO `0_stock_moves` VALUES ('6', '1', '104', '26', 'DEF', '2009-06-21', '0', '0', '1', '-10', '0', '0', '1');
1607 INSERT INTO `0_stock_moves` VALUES ('7', '1', '3400', '26', 'DEF', '2009-06-21', '0', '0', '1', '10', '0', '0', '1');
1608 INSERT INTO `0_stock_moves` VALUES ('8', '2', '102', '13', 'DEF', '2009-06-21', '0', '30.4', '1', '-2', '0', '10', '1');
1609 INSERT INTO `0_stock_moves` VALUES ('9', '3', '102', '13', 'DEF', '2009-06-21', '0', '50', 'auto', '-1', '0', '10', '1');
1610 INSERT INTO `0_stock_moves` VALUES ('10', '4', '102', '13', 'DEF', '2009-06-21', '0', '35.89', 'auto', '-1', '0', '10', '1');
1611 INSERT INTO `0_stock_moves` VALUES ('11', '3', '102', '26', 'DEF', '2009-06-21', '0', '0', '3', '-2', '0', '0', '1');
1612 INSERT INTO `0_stock_moves` VALUES ('12', '3', '103', '26', 'DEF', '2009-06-21', '0', '0', '3', '-2', '0', '0', '1');
1613 INSERT INTO `0_stock_moves` VALUES ('13', '3', '104', '26', 'DEF', '2009-06-21', '0', '0', '3', '-2', '0', '0', '1');
1614 INSERT INTO `0_stock_moves` VALUES ('14', '3', '3400', '26', 'DEF', '2009-06-21', '0', '0', '3', '2', '0', '0', '1');
1615 INSERT INTO `0_stock_moves` VALUES ('15', '4', '102', '26', 'DEF', '2009-06-21', '0', '0', '4', '-4', '0', '0', '1');
1616 INSERT INTO `0_stock_moves` VALUES ('16', '4', '103', '26', 'DEF', '2009-06-21', '0', '0', '4', '-4', '0', '0', '1');
1617 INSERT INTO `0_stock_moves` VALUES ('17', '4', '104', '26', 'DEF', '2009-06-21', '0', '0', '4', '-4', '0', '0', '1');
1618 INSERT INTO `0_stock_moves` VALUES ('18', '4', '3400', '26', 'DEF', '2009-06-21', '0', '0', '4', '4', '0', '0', '1');
1619 INSERT INTO `0_stock_moves` VALUES ('19', '2', '102', '26', 'DEF', '2009-06-21', '0', '0', '', '-2', '0', '0', '1');
1620 INSERT INTO `0_stock_moves` VALUES ('20', '2', '103', '26', 'DEF', '2009-06-21', '0', '0', '', '-2', '0', '0', '1');
1621 INSERT INTO `0_stock_moves` VALUES ('21', '2', '104', '26', 'DEF', '2009-06-21', '0', '0', '', '-2', '0', '0', '1');
1622 INSERT INTO `0_stock_moves` VALUES ('22', '1', '3400', '29', 'DEF', '2009-06-21', '0', '0', '', '2', '0', '0', '1');
1623 INSERT INTO `0_stock_moves` VALUES ('23', '5', '102', '26', 'DEF', '2009-06-21', '0', '0', '5', '-5', '0', '0', '1');
1624 INSERT INTO `0_stock_moves` VALUES ('24', '5', '103', '26', 'DEF', '2009-06-21', '0', '0', '5', '-5', '0', '0', '1');
1625 INSERT INTO `0_stock_moves` VALUES ('25', '5', '104', '26', 'DEF', '2009-06-21', '0', '0', '5', '-5', '0', '0', '1');
1626 INSERT INTO `0_stock_moves` VALUES ('26', '5', '3400', '26', 'DEF', '2009-06-21', '0', '0', '5', '5', '0', '0', '1');
1627 INSERT INTO `0_stock_moves` VALUES ('27', '6', '102', '26', 'DEF', '2009-06-21', '0', '0', '6', '5', '0', '0', '1');
1628 INSERT INTO `0_stock_moves` VALUES ('28', '6', '103', '26', 'DEF', '2009-06-21', '0', '0', '6', '5', '0', '0', '1');
1629 INSERT INTO `0_stock_moves` VALUES ('29', '6', '104', '26', 'DEF', '2009-06-21', '0', '0', '6', '5', '0', '0', '1');
1630 INSERT INTO `0_stock_moves` VALUES ('30', '6', '3400', '26', 'DEF', '2009-06-21', '0', '0', '6', '-5', '0', '0', '1');
1631 INSERT INTO `0_stock_moves` VALUES ('31', '7', '102', '26', 'DEF', '2009-06-21', '0', '0', '7', '2', '0', '0', '1');
1632 INSERT INTO `0_stock_moves` VALUES ('32', '7', '103', '26', 'DEF', '2009-06-21', '0', '0', '7', '2', '0', '0', '1');
1633 INSERT INTO `0_stock_moves` VALUES ('33', '7', '104', '26', 'DEF', '2009-06-21', '0', '0', '7', '2', '0', '0', '1');
1634 INSERT INTO `0_stock_moves` VALUES ('34', '7', '3400', '26', 'DEF', '2009-06-21', '0', '0', '7', '-2', '0', '0', '1');
1635 INSERT INTO `0_stock_moves` VALUES ('35', '5', '102', '13', 'DEF', '2009-06-21', '0', '50', 'auto', '-1', '0', '10', '1');
1636 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');
1639 ### Structure of table `0_supp_allocations` ###
1641 DROP TABLE IF EXISTS `0_supp_allocations`;
1643 CREATE TABLE `0_supp_allocations` (
1644 `id` int(11) NOT NULL auto_increment,
1645 `amt` double unsigned default NULL,
1646 `date_alloc` date NOT NULL default '0000-00-00',
1647 `trans_no_from` int(11) default NULL,
1648 `trans_type_from` int(11) default NULL,
1649 `trans_no_to` int(11) default NULL,
1650 `trans_type_to` int(11) default NULL,
1652 KEY `From` (`trans_type_from`, `trans_no_from`),
1653 KEY `To` (`trans_type_to`, `trans_no_to`)
1654 ) TYPE=InnoDB AUTO_INCREMENT=2 ;
1657 ### Data of table `0_supp_allocations` ###
1659 INSERT INTO `0_supp_allocations` VALUES ('1', '3465', '2009-06-21', '4', '22', '7', '20');
1662 ### Structure of table `0_supp_invoice_items` ###
1664 DROP TABLE IF EXISTS `0_supp_invoice_items`;
1666 CREATE TABLE `0_supp_invoice_items` (
1667 `id` int(11) NOT NULL auto_increment,
1668 `supp_trans_no` int(11) default NULL,
1669 `supp_trans_type` int(11) default NULL,
1670 `gl_code` varchar(11) NOT NULL default '0',
1671 `grn_item_id` int(11) default NULL,
1672 `po_detail_item_id` int(11) default NULL,
1673 `stock_id` varchar(20) NOT NULL default '',
1674 `description` tinytext,
1675 `quantity` double NOT NULL default '0',
1676 `unit_price` double NOT NULL default '0',
1677 `unit_tax` double NOT NULL default '0',
1680 KEY `Transaction` (`supp_trans_type`, `supp_trans_no`, `stock_id`)
1681 ) TYPE=InnoDB AUTO_INCREMENT=6 ;
1684 ### Data of table `0_supp_invoice_items` ###
1686 INSERT INTO `0_supp_invoice_items` VALUES ('1', '7', '20', '0', '1', '1', '102', '17inch VGA Monitor', '100', '10', '0.5', '');
1687 INSERT INTO `0_supp_invoice_items` VALUES ('2', '7', '20', '0', '2', '2', '103', '32MB VGA Card', '100', '11', '0.55', '');
1688 INSERT INTO `0_supp_invoice_items` VALUES ('3', '7', '20', '0', '3', '3', '104', '52x CD Drive', '100', '12', '0.6', '');
1689 INSERT INTO `0_supp_invoice_items` VALUES ('4', '8', '20', '2150', '0', '0', '', '', '0', '0.95', '0', 'Phone');
1690 INSERT INTO `0_supp_invoice_items` VALUES ('5', '8', '20', '5780', '0', '0', '', '', '0', '19.05', '0', 'Phone');
1693 ### Structure of table `0_supp_trans` ###
1695 DROP TABLE IF EXISTS `0_supp_trans`;
1697 CREATE TABLE `0_supp_trans` (
1698 `trans_no` int(11) unsigned NOT NULL default '0',
1699 `type` smallint(6) unsigned NOT NULL default '0',
1700 `supplier_id` int(11) unsigned default NULL,
1701 `reference` tinytext NOT NULL,
1702 `supp_reference` varchar(60) NOT NULL default '',
1703 `tran_date` date NOT NULL default '0000-00-00',
1704 `due_date` date NOT NULL default '0000-00-00',
1705 `ov_amount` double NOT NULL default '0',
1706 `ov_discount` double NOT NULL default '0',
1707 `ov_gst` double NOT NULL default '0',
1708 `rate` double NOT NULL default '1',
1709 `alloc` double NOT NULL default '0',
1710 PRIMARY KEY (`type`, `trans_no`),
1711 KEY `supplier_id` (`supplier_id`),
1712 KEY `SupplierID_2` (`supplier_id`,`supp_reference`),
1713 KEY `type` (`type`),
1718 ### Data of table `0_supp_trans` ###
1720 INSERT INTO `0_supp_trans` VALUES ('4', '22', '2', '1', '', '2009-06-21', '2009-06-21', '-3465', '0', '0', '1', '3465');
1721 INSERT INTO `0_supp_trans` VALUES ('7', '20', '2', '1', '5t', '2009-06-21', '2009-07-01', '3300', '0', '165', '1', '3465');
1722 INSERT INTO `0_supp_trans` VALUES ('8', '20', '2', '2', 'cc', '2009-06-21', '2009-07-01', '20', '0', '0', '1', '0');
1725 ### Structure of table `0_suppliers` ###
1727 DROP TABLE IF EXISTS `0_suppliers`;
1729 CREATE TABLE `0_suppliers` (
1730 `supplier_id` int(11) NOT NULL auto_increment,
1731 `supp_name` varchar(60) NOT NULL default '',
1732 `supp_ref` varchar(30) NOT NULL default '',
1733 `address` tinytext NOT NULL,
1734 `supp_address` tinytext NOT NULL,
1735 `phone` varchar(30) NOT NULL default '',
1736 `phone2` varchar(30) NOT NULL default '',
1737 `fax` varchar(30) NOT NULL default '',
1738 `gst_no` varchar(25) NOT NULL default '',
1739 `contact` varchar(60) NOT NULL default '',
1740 `supp_account_no` varchar(40) NOT NULL default '',
1741 `email` varchar(100) NOT NULL default '',
1742 `website` varchar(100) NOT NULL default '',
1743 `bank_account` varchar(60) NOT NULL default '',
1744 `curr_code` char(3) default NULL,
1745 `payment_terms` int(11) default NULL,
1746 `dimension_id` int(11) default '0',
1747 `dimension2_id` int(11) default '0',
1748 `tax_group_id` int(11) default NULL,
1749 `credit_limit` double NOT NULL default '0',
1750 `purchase_account` varchar(11) default NULL,
1751 `payable_account` varchar(11) default NULL,
1752 `payment_discount_account` varchar(11) default NULL,
1753 `notes` tinytext NOT NULL,
1754 `inactive` tinyint(1) NOT NULL default '0',
1755 PRIMARY KEY (`supplier_id`),
1757 ) TYPE=MyISAM AUTO_INCREMENT=4 ;
1760 ### Data of table `0_suppliers` ###
1762 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');
1763 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');
1764 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');
1766 ### Structure of table `0_sys_prefs` ###
1768 DROP TABLE IF EXISTS `0_sys_prefs`;
1770 CREATE TABLE `0_sys_prefs` (
1771 `name` varchar(35) NOT NULL default '',
1772 `category` varchar(30) default NULL,
1773 `type` varchar(20) NOT NULL default 'varchar',
1774 `length` smallint(6) default NULL,
1776 PRIMARY KEY (`name`),
1777 KEY `category` (`category`)
1781 ### Data of table `0_sys_prefs` ###
1783 INSERT INTO `0_sys_prefs` VALUES ('coy_name', 'setup.company', 'varchar', '60', 'Training Co.');
1784 INSERT INTO `0_sys_prefs` VALUES ('gst_no', 'setup.company', 'varchar', '25', '9876543');
1785 INSERT INTO `0_sys_prefs` VALUES ('coy_no', 'setup.company', 'varchar', '25', '123456789');
1786 INSERT INTO `0_sys_prefs` VALUES ('tax_prd', 'setup.company', 'int', '11', '1');
1787 INSERT INTO `0_sys_prefs` VALUES ('tax_last', 'setup.company', 'int', '11', '1');
1788 INSERT INTO `0_sys_prefs` VALUES ('postal_address', 'setup.company', 'tinytext', '0', 'Address 1\r\nAddress 2\r\nAddress 3');
1789 INSERT INTO `0_sys_prefs` VALUES ('phone', 'setup.company', 'varchar', '30', '(222) 111.222.333');
1790 INSERT INTO `0_sys_prefs` VALUES ('fax', 'setup.company', 'varchar', '30', NULL);
1791 INSERT INTO `0_sys_prefs` VALUES ('email', 'setup.company', 'varchar', '100', 'delta@delta.com');
1792 INSERT INTO `0_sys_prefs` VALUES ('coy_logo', 'setup.company', 'varchar', '100', 'logo_frontaccounting.jpg');
1793 INSERT INTO `0_sys_prefs` VALUES ('domicile', 'setup.company', 'varchar', '55', NULL);
1794 INSERT INTO `0_sys_prefs` VALUES ('curr_default', 'setup.company', 'char', '3', 'USD');
1795 INSERT INTO `0_sys_prefs` VALUES ('use_dimension', 'setup.company', 'tinyint', '1', '1');
1796 INSERT INTO `0_sys_prefs` VALUES ('f_year', 'setup.company', 'int', '11', '2');
1797 INSERT INTO `0_sys_prefs` VALUES ('no_item_list', 'setup.company', 'tinyint', '1', '0');
1798 INSERT INTO `0_sys_prefs` VALUES ('no_customer_list', 'setup.company', 'tinyint', '1', '0');
1799 INSERT INTO `0_sys_prefs` VALUES ('no_supplier_list', 'setup.company', 'tinyint', '1', '0');
1800 INSERT INTO `0_sys_prefs` VALUES ('base_sales', 'setup.company', 'int', '11', '1');
1801 INSERT INTO `0_sys_prefs` VALUES ('time_zone', 'setup.company', 'tinyint', '1', '0');
1802 INSERT INTO `0_sys_prefs` VALUES ('add_pct', 'setup.company', 'int', '5', '-1');
1803 INSERT INTO `0_sys_prefs` VALUES ('round_to', 'setup.company', 'int', '5', '1');
1804 INSERT INTO `0_sys_prefs` VALUES ('login_tout', 'setup.company', 'smallint', '6', '600');
1805 INSERT INTO `0_sys_prefs` VALUES ('past_due_days', 'glsetup.general', 'int', '11', '30');
1806 INSERT INTO `0_sys_prefs` VALUES ('profit_loss_year_act', 'glsetup.general', 'varchar', '11', '9990');
1807 INSERT INTO `0_sys_prefs` VALUES ('retained_earnings_act', 'glsetup.general', 'varchar', '11', '3590');
1808 INSERT INTO `0_sys_prefs` VALUES ('bank_charge_act', 'glsetup.general', 'varchar', '11', '5690');
1809 INSERT INTO `0_sys_prefs` VALUES ('exchange_diff_act', 'glsetup.general', 'varchar', '11', '4450');
1810 INSERT INTO `0_sys_prefs` VALUES ('default_credit_limit', 'glsetup.customer', 'int', '11', '1000');
1811 INSERT INTO `0_sys_prefs` VALUES ('accumulate_shipping', 'glsetup.customer', 'tinyint', '1', '0');
1812 INSERT INTO `0_sys_prefs` VALUES ('legal_text', 'glsetup.customer', 'tinytext', '0', NULL);
1813 INSERT INTO `0_sys_prefs` VALUES ('freight_act', 'glsetup.customer', 'varchar', '11', '4430');
1814 INSERT INTO `0_sys_prefs` VALUES ('debtors_act', 'glsetup.sales', 'varchar', '11', '1200');
1815 INSERT INTO `0_sys_prefs` VALUES ('default_sales_act', 'glsetup.sales', 'varchar', '11', '4010');
1816 INSERT INTO `0_sys_prefs` VALUES ('default_sales_discount_act', 'glsetup.sales', 'varchar', '11', '4510');
1817 INSERT INTO `0_sys_prefs` VALUES ('default_prompt_payment_act', 'glsetup.sales', 'varchar', '11', '4500');
1818 INSERT INTO `0_sys_prefs` VALUES ('default_delivery_required', 'glsetup.sales', 'smallint', '6', '1');
1819 INSERT INTO `0_sys_prefs` VALUES ('default_dim_required', 'glsetup.dims', 'int', '11', '20');
1820 INSERT INTO `0_sys_prefs` VALUES ('pyt_discount_act', 'glsetup.purchase', 'varchar', '11', '5060');
1821 INSERT INTO `0_sys_prefs` VALUES ('creditors_act', 'glsetup.purchase', 'varchar', '11', '2100');
1822 INSERT INTO `0_sys_prefs` VALUES ('po_over_receive', 'glsetup.purchase', 'int', '11', '10');
1823 INSERT INTO `0_sys_prefs` VALUES ('po_over_charge', 'glsetup.purchase', 'int', '11', '10');
1824 INSERT INTO `0_sys_prefs` VALUES ('allow_negative_stock', 'glsetup.inventory', 'tinyint', '1', '0');
1825 INSERT INTO `0_sys_prefs` VALUES ('default_inventory_act', 'glsetup.items', 'varchar', '11', '1510');
1826 INSERT INTO `0_sys_prefs` VALUES ('default_cogs_act', 'glsetup.items', 'varchar', '11', '5010');
1827 INSERT INTO `0_sys_prefs` VALUES ('default_adj_act', 'glsetup.items', 'varchar', '11', '5040');
1828 INSERT INTO `0_sys_prefs` VALUES ('default_inv_sales_act', 'glsetup.items', 'varchar', '11', '4010');
1829 INSERT INTO `0_sys_prefs` VALUES ('default_assembly_act', 'glsetup.items', 'varchar', '11', '1530');
1830 INSERT INTO `0_sys_prefs` VALUES ('default_workorder_required', 'glsetup.manuf', 'int', '11', '20');
1831 INSERT INTO `0_sys_prefs` VALUES ('version_id', 'system', 'varchar', '11', '2.3');
1835 ### Structure of table `0_sys_types` ###
1837 DROP TABLE IF EXISTS `0_sys_types`;
1839 CREATE TABLE `0_sys_types` (
1840 `type_id` smallint(6) NOT NULL default '0',
1841 `type_no` int(11) NOT NULL default '1',
1842 `next_reference` varchar(100) NOT NULL default '',
1843 PRIMARY KEY (`type_id`)
1847 ### Data of table `0_sys_types` ###
1849 INSERT INTO `0_sys_types` VALUES ('0', '19', '3');
1850 INSERT INTO `0_sys_types` VALUES ('1', '8', '2');
1851 INSERT INTO `0_sys_types` VALUES ('2', '5', '2');
1852 INSERT INTO `0_sys_types` VALUES ('4', '3', '1');
1853 INSERT INTO `0_sys_types` VALUES ('10', '19', '4');
1854 INSERT INTO `0_sys_types` VALUES ('11', '3', '2');
1855 INSERT INTO `0_sys_types` VALUES ('12', '6', '1');
1856 INSERT INTO `0_sys_types` VALUES ('13', '5', '2');
1857 INSERT INTO `0_sys_types` VALUES ('16', '2', '1');
1858 INSERT INTO `0_sys_types` VALUES ('17', '2', '1');
1859 INSERT INTO `0_sys_types` VALUES ('18', '1', '3');
1860 INSERT INTO `0_sys_types` VALUES ('20', '8', '3');
1861 INSERT INTO `0_sys_types` VALUES ('21', '1', '1');
1862 INSERT INTO `0_sys_types` VALUES ('22', '4', '2');
1863 INSERT INTO `0_sys_types` VALUES ('25', '1', '2');
1864 INSERT INTO `0_sys_types` VALUES ('26', '1', '8');
1865 INSERT INTO `0_sys_types` VALUES ('28', '1', '1');
1866 INSERT INTO `0_sys_types` VALUES ('29', '1', '2');
1867 INSERT INTO `0_sys_types` VALUES ('30', '5', '6');
1868 INSERT INTO `0_sys_types` VALUES ('32', '0', '1');
1869 INSERT INTO `0_sys_types` VALUES ('35', '1', '1');
1870 INSERT INTO `0_sys_types` VALUES ('40', '1', '3');
1873 ### Structure of table `0_tax_group_items` ###
1875 DROP TABLE IF EXISTS `0_tax_group_items`;
1877 CREATE TABLE `0_tax_group_items` (
1878 `tax_group_id` int(11) NOT NULL default '0',
1879 `tax_type_id` int(11) NOT NULL default '0',
1880 `rate` double NOT NULL default '0',
1881 PRIMARY KEY (`tax_group_id`,`tax_type_id`)
1885 ### Data of table `0_tax_group_items` ###
1887 INSERT INTO `0_tax_group_items` VALUES ('1', '1', '5');
1890 ### Structure of table `0_tax_groups` ###
1892 DROP TABLE IF EXISTS `0_tax_groups`;
1894 CREATE TABLE `0_tax_groups` (
1895 `id` int(11) NOT NULL auto_increment,
1896 `name` varchar(60) NOT NULL default '',
1897 `tax_shipping` tinyint(1) NOT NULL default '0',
1898 `inactive` tinyint(1) NOT NULL default '0',
1900 UNIQUE KEY `name` (`name`)
1901 ) TYPE=InnoDB AUTO_INCREMENT=3 ;
1904 ### Data of table `0_tax_groups` ###
1906 INSERT INTO `0_tax_groups` VALUES ('1', 'Tax', '0', '0');
1907 INSERT INTO `0_tax_groups` VALUES ('2', 'Tax Exempt', '0', '0');
1909 ### Structure of table `0_tax_types` ###
1911 DROP TABLE IF EXISTS `0_tax_types`;
1913 CREATE TABLE `0_tax_types` (
1914 `id` int(11) NOT NULL auto_increment,
1915 `rate` double NOT NULL default '0',
1916 `sales_gl_code` varchar(11) NOT NULL default '',
1917 `purchasing_gl_code` varchar(11) NOT NULL default '',
1918 `name` varchar(60) NOT NULL default '',
1919 `inactive` tinyint(1) NOT NULL default '0',
1921 ) TYPE=InnoDB AUTO_INCREMENT=5 AUTO_INCREMENT=5 ;
1924 ### Data of table `0_tax_types` ###
1926 INSERT INTO `0_tax_types` VALUES ('1', '5', '2150', '2150', 'Tax', '0');
1928 ### Structure of table `0_trans_tax_details` ###
1930 DROP TABLE IF EXISTS `0_trans_tax_details`;
1932 CREATE TABLE `0_trans_tax_details` (
1933 `id` int(11) NOT NULL auto_increment,
1934 `trans_type` smallint(6) default NULL,
1935 `trans_no` int(11) default NULL,
1936 `tran_date` date NOT NULL,
1937 `tax_type_id` int(11) NOT NULL default '0',
1938 `rate` double NOT NULL default '0',
1939 `ex_rate` double NOT NULL default '1',
1940 `included_in_price` tinyint(1) NOT NULL default '0',
1941 `net_amount` double NOT NULL default '0',
1942 `amount` double NOT NULL default '0',
1945 KEY `Type_and_Number` (`trans_type`,`trans_no`),
1947 ) TYPE=InnoDB AUTO_INCREMENT=12 ;
1950 ### Data of table `0_trans_tax_details` ###
1952 INSERT INTO `0_trans_tax_details` VALUES ('1', '20', '7', '2009-06-21', '1', '5', '1', '0', '3300', '165', '5t');
1953 INSERT INTO `0_trans_tax_details` VALUES ('2', '13', '3', '2009-06-21', '1', '5', '1', '0', '50', '2.5', 'auto');
1954 INSERT INTO `0_trans_tax_details` VALUES ('3', '10', '17', '2009-06-21', '1', '5', '1', '0', '50', '2.5', '1');
1955 INSERT INTO `0_trans_tax_details` VALUES ('4', '13', '4', '2009-06-21', '1', '5', '1.3932', '0', '35.89', '1.7945', 'auto');
1956 INSERT INTO `0_trans_tax_details` VALUES ('5', '10', '18', '2009-06-21', '1', '5', '1.3932', '0', '35.89', '1.7945', '2');
1957 INSERT INTO `0_trans_tax_details` VALUES ('6', '2', '5', '2009-06-21', '1', '5', '1', '0', '95.2', '4.76', '');
1958 INSERT INTO `0_trans_tax_details` VALUES ('7', '1', '8', '2009-06-21', '1', '5', '1', '0', '-47.6', '-2.38', '');
1959 INSERT INTO `0_trans_tax_details` VALUES ('8', '20', '8', '2009-06-21', '1', '5', '1', '0', '-19', '-0.95', 'cc');
1960 INSERT INTO `0_trans_tax_details` VALUES ('9', '13', '5', '2009-06-21', '1', '5', '1', '1', '47.619047619048', '2.3809523809524', 'auto');
1961 INSERT INTO `0_trans_tax_details` VALUES ('10', '10', '19', '2009-06-21', '1', '5', '1', '1', '47.619047619048', '2.3809523809524', '3');
1962 INSERT INTO `0_trans_tax_details` VALUES ('11', '11', '3', '2009-06-21', '1', '5', '1.3932', '0', '35.89', '1.7945', '1');
1964 ### Structure of table `0_users` ###
1966 DROP TABLE IF EXISTS `0_users`;
1968 CREATE TABLE `0_users` (
1969 `id` SMALLINT(6) AUTO_INCREMENT,
1970 `user_id` varchar(60) NOT NULL default '',
1971 `password` varchar(100) NOT NULL default '',
1972 `real_name` varchar(100) NOT NULL default '',
1973 `role_id` int(11) NOT NULL default '1',
1974 `phone` varchar(30) NOT NULL default '',
1975 `email` varchar(100) default NULL,
1976 `language` varchar(20) default NULL,
1977 `date_format` tinyint(1) NOT NULL default '0',
1978 `date_sep` tinyint(1) NOT NULL default '0',
1979 `tho_sep` tinyint(1) NOT NULL default '0',
1980 `dec_sep` tinyint(1) NOT NULL default '0',
1981 `theme` varchar(20) NOT NULL default 'default',
1982 `page_size` varchar(20) NOT NULL default 'A4',
1983 `prices_dec` smallint(6) NOT NULL default '2',
1984 `qty_dec` smallint(6) NOT NULL default '2',
1985 `rates_dec` smallint(6) NOT NULL default '4',
1986 `percent_dec` smallint(6) NOT NULL default '1',
1987 `show_gl` tinyint(1) NOT NULL default '1',
1988 `show_codes` tinyint(1) NOT NULL default '0',
1989 `show_hints` tinyint(1) NOT NULL default '0',
1990 `last_visit_date` datetime default NULL,
1991 `query_size` tinyint(1) default '10',
1992 `graphic_links` tinyint(1) default '1',
1993 `pos` smallint(6) default '1',
1994 `print_profile` varchar(30) NOT NULL default '1',
1995 `rep_popup` tinyint(1) default '1',
1996 `sticky_doc_date` tinyint(1) default '0',
1997 `startup_tab` varchar(20) NOT NULL default '',
1998 `inactive` tinyint(1) NOT NULL default '0',
2000 UNIQUE KEY (`user_id`)
2001 ) TYPE=MyISAM AUTO_INCREMENT=2;
2004 ### Data of table `0_users` ###
2006 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');
2007 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');
2009 ### Structure of table `0_voided` ###
2011 DROP TABLE IF EXISTS `0_voided`;
2013 CREATE TABLE `0_voided` (
2014 `type` int(11) NOT NULL default '0',
2015 `id` int(11) NOT NULL default '0',
2016 `date_` date NOT NULL default '0000-00-00',
2017 `memo_` tinytext NOT NULL,
2018 UNIQUE KEY `id` (`type`,`id`)
2022 ### Data of table `0_voided` ###
2026 ### Structure of table `0_wo_issue_items` ###
2028 DROP TABLE IF EXISTS `0_wo_issue_items`;
2030 CREATE TABLE `0_wo_issue_items` (
2031 `id` int(11) NOT NULL auto_increment,
2032 `stock_id` varchar(40) default NULL,
2033 `issue_id` int(11) default NULL,
2034 `qty_issued` double default NULL,
2036 ) TYPE=InnoDB AUTO_INCREMENT=1 ;
2039 ### Data of table `0_wo_issue_items` ###
2043 ### Structure of table `0_wo_issues` ###
2045 DROP TABLE IF EXISTS `0_wo_issues`;
2047 CREATE TABLE `0_wo_issues` (
2048 `issue_no` int(11) NOT NULL auto_increment,
2049 `workorder_id` int(11) NOT NULL default '0',
2050 `reference` varchar(100) default NULL,
2051 `issue_date` date default NULL,
2052 `loc_code` varchar(5) default NULL,
2053 `workcentre_id` int(11) default NULL,
2054 PRIMARY KEY (`issue_no`),
2055 KEY (`workorder_id`)
2056 ) TYPE=InnoDB AUTO_INCREMENT=1 ;
2059 ### Data of table `0_wo_issues` ###
2063 ### Structure of table `0_wo_manufacture` ###
2065 DROP TABLE IF EXISTS `0_wo_manufacture`;
2067 CREATE TABLE `0_wo_manufacture` (
2068 `id` int(11) NOT NULL auto_increment,
2069 `reference` varchar(100) default NULL,
2070 `workorder_id` int(11) NOT NULL default '0',
2071 `quantity` double NOT NULL default '0',
2072 `date_` date NOT NULL default '0000-00-00',
2074 KEY (`workorder_id`)
2075 ) TYPE=InnoDB AUTO_INCREMENT=2 ;
2078 ### Data of table `0_wo_manufacture` ###
2080 INSERT INTO `0_wo_manufacture` VALUES ('1', '1', '2', '2', '2009-06-21');
2083 ### Structure of table `0_wo_requirements` ###
2085 DROP TABLE IF EXISTS `0_wo_requirements`;
2087 CREATE TABLE `0_wo_requirements` (
2088 `id` int(11) NOT NULL auto_increment,
2089 `workorder_id` int(11) NOT NULL default '0',
2090 `stock_id` char(20) NOT NULL default '',
2091 `workcentre` int(11) NOT NULL default '0',
2092 `units_req` double NOT NULL default '1',
2093 `std_cost` double NOT NULL default '0',
2094 `loc_code` char(5) NOT NULL default '',
2095 `units_issued` double NOT NULL default '0',
2097 KEY (`workorder_id`)
2098 ) TYPE=InnoDB AUTO_INCREMENT=22 ;
2101 ### Data of table `0_wo_requirements` ###
2103 INSERT INTO `0_wo_requirements` VALUES ('1', '1', '102', '1', '1', '0', 'DEF', '10');
2104 INSERT INTO `0_wo_requirements` VALUES ('2', '1', '103', '1', '1', '0', 'DEF', '10');
2105 INSERT INTO `0_wo_requirements` VALUES ('3', '1', '104', '1', '1', '0', 'DEF', '10');
2106 INSERT INTO `0_wo_requirements` VALUES ('4', '2', '102', '1', '1', '0', 'DEF', '0');
2107 INSERT INTO `0_wo_requirements` VALUES ('5', '2', '103', '1', '1', '0', 'DEF', '0');
2108 INSERT INTO `0_wo_requirements` VALUES ('6', '2', '104', '1', '1', '0', 'DEF', '0');
2109 INSERT INTO `0_wo_requirements` VALUES ('7', '3', '102', '1', '1', '0', 'DEF', '2');
2110 INSERT INTO `0_wo_requirements` VALUES ('8', '3', '103', '1', '1', '0', 'DEF', '2');
2111 INSERT INTO `0_wo_requirements` VALUES ('9', '3', '104', '1', '1', '0', 'DEF', '2');
2112 INSERT INTO `0_wo_requirements` VALUES ('10', '4', '102', '1', '1', '0', 'DEF', '4');
2113 INSERT INTO `0_wo_requirements` VALUES ('11', '4', '103', '1', '1', '0', 'DEF', '4');
2114 INSERT INTO `0_wo_requirements` VALUES ('12', '4', '104', '1', '1', '0', 'DEF', '4');
2115 INSERT INTO `0_wo_requirements` VALUES ('13', '5', '102', '1', '1', '0', 'DEF', '5');
2116 INSERT INTO `0_wo_requirements` VALUES ('14', '5', '103', '1', '1', '0', 'DEF', '5');
2117 INSERT INTO `0_wo_requirements` VALUES ('15', '5', '104', '1', '1', '0', 'DEF', '5');
2118 INSERT INTO `0_wo_requirements` VALUES ('16', '6', '102', '1', '1', '0', 'DEF', '-5');
2119 INSERT INTO `0_wo_requirements` VALUES ('17', '6', '103', '1', '1', '0', 'DEF', '-5');
2120 INSERT INTO `0_wo_requirements` VALUES ('18', '6', '104', '1', '1', '0', 'DEF', '-5');
2121 INSERT INTO `0_wo_requirements` VALUES ('19', '7', '102', '1', '1', '0', 'DEF', '-2');
2122 INSERT INTO `0_wo_requirements` VALUES ('20', '7', '103', '1', '1', '0', 'DEF', '-2');
2123 INSERT INTO `0_wo_requirements` VALUES ('21', '7', '104', '1', '1', '0', 'DEF', '-2');
2126 ### Structure of table `0_workcentres` ###
2128 DROP TABLE IF EXISTS `0_workcentres`;
2130 CREATE TABLE `0_workcentres` (
2131 `id` int(11) NOT NULL auto_increment,
2132 `name` char(40) NOT NULL default '',
2133 `description` char(50) NOT NULL default '',
2134 `inactive` tinyint(1) NOT NULL default '0',
2136 UNIQUE KEY `name` (`name`)
2137 ) TYPE=MyISAM AUTO_INCREMENT=2 ;
2140 ### Data of table `0_workcentres` ###
2142 INSERT INTO `0_workcentres` VALUES ('1', 'Workshop', 'Workshop in Alabama', '0');
2145 ### Structure of table `0_workorders` ###
2147 DROP TABLE IF EXISTS `0_workorders`;
2149 CREATE TABLE `0_workorders` (
2150 `id` int(11) NOT NULL auto_increment,
2151 `wo_ref` varchar(60) NOT NULL default '',
2152 `loc_code` varchar(5) NOT NULL default '',
2153 `units_reqd` double NOT NULL default '1',
2154 `stock_id` varchar(20) NOT NULL default '',
2155 `date_` date NOT NULL default '0000-00-00',
2156 `type` tinyint(4) NOT NULL default '0',
2157 `required_by` date NOT NULL default '0000-00-00',
2158 `released_date` date NOT NULL default '0000-00-00',
2159 `units_issued` double NOT NULL default '0',
2160 `closed` tinyint(1) NOT NULL default '0',
2161 `released` tinyint(1) NOT NULL default '0',
2162 `additional_costs` double NOT NULL default '0',
2164 UNIQUE KEY `wo_ref` (`wo_ref`)
2165 ) TYPE=InnoDB AUTO_INCREMENT=8 ;
2168 ### Data of table `0_workorders` ###
2170 INSERT INTO `0_workorders` VALUES ('1', '1', 'DEF', '10', '3400', '2009-06-21', '0', '2009-06-21', '2009-06-21', '10', '1', '1', '10');
2171 INSERT INTO `0_workorders` VALUES ('2', '2', 'DEF', '3', '3400', '2009-06-21', '2', '2009-07-11', '2009-06-21', '2', '0', '1', '0');
2172 INSERT INTO `0_workorders` VALUES ('3', '3', 'DEF', '2', '3400', '2009-06-21', '0', '2009-06-21', '2009-06-21', '2', '1', '1', '0');
2173 INSERT INTO `0_workorders` VALUES ('4', '4', 'DEF', '4', '3400', '2009-06-21', '0', '2009-06-21', '2009-06-21', '4', '1', '1', '0');
2174 INSERT INTO `0_workorders` VALUES ('5', '5', 'DEF', '5', '3400', '2009-06-21', '0', '2009-06-21', '2009-06-21', '5', '1', '1', '10');
2175 INSERT INTO `0_workorders` VALUES ('6', '6', 'DEF', '-5', '3400', '2009-06-21', '1', '2009-06-21', '2009-06-21', '-5', '1', '1', '0');
2176 INSERT INTO `0_workorders` VALUES ('7', '7', 'DEF', '-2', '3400', '2009-06-21', '1', '2009-06-21', '2009-06-21', '-2', '1', '1', '10');
2179 ### Structure of table `0_tags` ###
2181 DROP TABLE IF EXISTS `0_tags`;
2183 CREATE TABLE `0_tags` (
2184 `id` int(11) NOT NULL auto_increment,
2185 `type` smallint(6) NOT NULL,
2186 `name` varchar(30) NOT NULL,
2187 `description` varchar(60) default NULL,
2188 `inactive` tinyint(1) NOT NULL default '0',
2190 UNIQUE KEY(`type`,`name`)
2191 ) TYPE=MyISAM AUTO_INCREMENT=1;
2194 ### Data of table `0_chart_tags` ###
2198 ### Structure of table `0_tag_associations` ###
2200 DROP TABLE IF EXISTS `0_tag_associations`;
2202 CREATE TABLE `0_tag_associations` (
2203 `record_id` varchar(11) NOT NULL,
2204 `tag_id` int(11) NOT NULL,
2205 UNIQUE KEY(`record_id`,`tag_id`)
2209 ### Data of table `0_tag_associations` ###
2211 DROP TABLE IF EXISTS `0_useronline` ;
2213 CREATE TABLE `0_useronline` (
2214 `id` int(11) NOT NULL AUTO_INCREMENT ,
2215 `timestamp` int(15) NOT NULL default '0',
2216 `ip` varchar(40) NOT NULL default '',
2217 `file` varchar(100) NOT NULL default '',
2218 PRIMARY KEY `id` (`id`) ,
2221 ) TYPE=MYISAM AUTO_INCREMENT=1;