projects
/
fa-stable.git
/ blobdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
|
commitdiff
|
tree
raw
|
inline
| side by side
Removed file update_db.php (obsolete). Finetuning en_US-demo.sql
[fa-stable.git]
/
sql
/
en_US-new.sql
diff --git
a/sql/en_US-new.sql
b/sql/en_US-new.sql
index a9407dc5a1ac011b3ab0aea1fa3fb0bbef32a0ff..8f46898a3bd60a504c906cdae8a3a509b51039b5 100644
(file)
--- a/
sql/en_US-new.sql
+++ b/
sql/en_US-new.sql
@@
-4,7
+4,7
@@
# http://frontaccounting.net
# Company: Company name
# User: Administrator
# http://frontaccounting.net
# Company: Company name
# User: Administrator
-
+# Database: en_US-new.sql release 2.1
### Structure of table `0_areas` ###
### Structure of table `0_areas` ###
@@
-17,7
+17,7
@@
CREATE TABLE `0_areas` (
`inactive` tinyint(1) NOT NULL default '0',
PRIMARY KEY (`area_code`),
UNIQUE KEY `description` (`description`)
`inactive` tinyint(1) NOT NULL default '0',
PRIMARY KEY (`area_code`),
UNIQUE KEY `description` (`description`)
-)
ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=latin1
AUTO_INCREMENT=2 ;
+)
TYPE=MyISAM AUTO_INCREMENT=2
AUTO_INCREMENT=2 ;
### Data of table `0_areas` ###
### Data of table `0_areas` ###
@@
-41,7
+41,7
@@
CREATE TABLE `0_attachments` (
`filetype` varchar(60) NOT NULL default '',
PRIMARY KEY (`id`),
KEY `type_no` (`type_no`,`trans_no`)
`filetype` varchar(60) NOT NULL default '',
PRIMARY KEY (`id`),
KEY `type_no` (`type_no`,`trans_no`)
-)
ENGINE=MyISAM DEFAULT CHARSET=latin1
AUTO_INCREMENT=1 ;
+)
TYPE=MyISAM
AUTO_INCREMENT=1 ;
### Data of table `0_attachments` ###
### Data of table `0_attachments` ###
@@
-67,7
+67,7
@@
CREATE TABLE `0_bank_accounts` (
PRIMARY KEY (`id`),
KEY `bank_account_name` (`bank_account_name`),
KEY `bank_account_number` (`bank_account_number`)
PRIMARY KEY (`id`),
KEY `bank_account_name` (`bank_account_name`),
KEY `bank_account_number` (`bank_account_number`)
-)
ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=latin1
AUTO_INCREMENT=3 ;
+)
TYPE=MyISAM AUTO_INCREMENT=3
AUTO_INCREMENT=3 ;
### Data of table `0_bank_accounts` ###
### Data of table `0_bank_accounts` ###
@@
-97,7
+97,7
@@
CREATE TABLE `0_bank_trans` (
PRIMARY KEY (`id`),
KEY `bank_act` (`bank_act`,`ref`),
KEY `type` (`type`,`trans_no`)
PRIMARY KEY (`id`),
KEY `bank_act` (`bank_act`,`ref`),
KEY `type` (`type`,`trans_no`)
-)
ENGINE=InnoDB DEFAULT CHARSET=latin1
AUTO_INCREMENT=1 ;
+)
TYPE=InnoDB
AUTO_INCREMENT=1 ;
### Data of table `0_bank_trans` ###
### Data of table `0_bank_trans` ###
@@
-122,7
+122,7
@@
CREATE TABLE `0_bom` (
KEY `parent` (`parent`,`loc_code`),
KEY `Parent_2` (`parent`),
KEY `workcentre_added` (`workcentre_added`)
KEY `parent` (`parent`,`loc_code`),
KEY `Parent_2` (`parent`),
KEY `workcentre_added` (`workcentre_added`)
-)
ENGINE=MyISAM DEFAULT CHARSET=latin1
AUTO_INCREMENT=1 ;
+)
TYPE=MyISAM
AUTO_INCREMENT=1 ;
### Data of table `0_bom` ###
### Data of table `0_bom` ###
@@
-147,7
+147,7
@@
CREATE TABLE `0_budget_trans` (
`person_id` tinyblob,
PRIMARY KEY (`counter`),
KEY `Type_and_Number` (`type`,`type_no`)
`person_id` tinyblob,
PRIMARY KEY (`counter`),
KEY `Type_and_Number` (`type`,`type_no`)
-)
ENGINE=InnoDB DEFAULT CHARSET=latin1
AUTO_INCREMENT=1 ;
+)
TYPE=InnoDB
AUTO_INCREMENT=1 ;
### Data of table `0_budget_trans` ###
### Data of table `0_budget_trans` ###
@@
-163,7
+163,7
@@
CREATE TABLE `0_chart_class` (
`class_name` varchar(60) NOT NULL default '',
`balance_sheet` tinyint(1) NOT NULL default '0',
PRIMARY KEY (`cid`)
`class_name` varchar(60) NOT NULL default '',
`balance_sheet` tinyint(1) NOT NULL default '0',
PRIMARY KEY (`cid`)
-)
ENGINE=MyISAM DEFAULT CHARSET=latin1
;
+)
TYPE=MyISAM
;
### Data of table `0_chart_class` ###
### Data of table `0_chart_class` ###
@@
-188,7
+188,7
@@
CREATE TABLE `0_chart_master` (
PRIMARY KEY (`account_code`),
KEY `account_code` (`account_code`),
KEY `account_name` (`account_name`)
PRIMARY KEY (`account_code`),
KEY `account_code` (`account_code`),
KEY `account_name` (`account_name`)
-)
ENGINE=MyISAM DEFAULT CHARSET=latin1
;
+)
TYPE=MyISAM
;
### Data of table `0_chart_master` ###
### Data of table `0_chart_master` ###
@@
-251,7
+251,7
@@
CREATE TABLE `0_chart_types` (
`parent` int(11) NOT NULL default '-1',
PRIMARY KEY (`id`),
KEY `name` (`name`)
`parent` int(11) NOT NULL default '-1',
PRIMARY KEY (`id`),
KEY `name` (`name`)
-)
ENGINE=MyISAM AUTO_INCREMENT=53 DEFAULT CHARSET=latin1
AUTO_INCREMENT=53 ;
+)
TYPE=MyISAM AUTO_INCREMENT=53
AUTO_INCREMENT=53 ;
### Data of table `0_chart_types` ###
### Data of table `0_chart_types` ###
@@
-278,7
+278,7
@@
CREATE TABLE `0_comments` (
`id` int(11) NOT NULL default '0',
`date_` date default '0000-00-00',
`memo_` tinytext
`id` int(11) NOT NULL default '0',
`date_` date default '0000-00-00',
`memo_` tinytext
-)
ENGINE=InnoDB DEFAULT CHARSET=latin1
;
+)
TYPE=InnoDB
;
### Data of table `0_comments` ###
### Data of table `0_comments` ###
@@
-343,7
+343,7
@@
CREATE TABLE `0_company` (
`accumulate_shipping` tinyint(1) NOT NULL default '0',
`legal_text` tinytext NOT NULL,
PRIMARY KEY (`coy_code`)
`accumulate_shipping` tinyint(1) NOT NULL default '0',
`legal_text` tinytext NOT NULL,
PRIMARY KEY (`coy_code`)
-)
ENGINE=MyISAM DEFAULT CHARSET=latin1
;
+)
TYPE=MyISAM
;
### Data of table `0_company` ###
### Data of table `0_company` ###
@@
-362,7
+362,7
@@
CREATE TABLE `0_credit_status` (
`inactive` tinyint(1) NOT NULL default '0',
PRIMARY KEY (`id`),
UNIQUE KEY `reason_description` (`reason_description`)
`inactive` tinyint(1) NOT NULL default '0',
PRIMARY KEY (`id`),
UNIQUE KEY `reason_description` (`reason_description`)
-)
ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=latin1
AUTO_INCREMENT=5 ;
+)
TYPE=MyISAM AUTO_INCREMENT=5
AUTO_INCREMENT=5 ;
### Data of table `0_credit_status` ###
### Data of table `0_credit_status` ###
@@
-384,7
+384,7
@@
CREATE TABLE `0_currencies` (
`hundreds_name` varchar(15) NOT NULL default '',
`inactive` tinyint(1) NOT NULL default '0',
PRIMARY KEY (`curr_abrev`)
`hundreds_name` varchar(15) NOT NULL default '',
`inactive` tinyint(1) NOT NULL default '0',
PRIMARY KEY (`curr_abrev`)
-)
ENGINE=MyISAM DEFAULT CHARSET=latin1
;
+)
TYPE=MyISAM
;
### Data of table `0_currencies` ###
### Data of table `0_currencies` ###
@@
-407,7
+407,7
@@
CREATE TABLE `0_cust_allocations` (
`trans_no_to` int(11) default NULL,
`trans_type_to` int(11) default NULL,
PRIMARY KEY (`id`)
`trans_no_to` int(11) default NULL,
`trans_type_to` int(11) default NULL,
PRIMARY KEY (`id`)
-)
ENGINE=InnoDB DEFAULT CHARSET=latin1
AUTO_INCREMENT=1 ;
+)
TYPE=InnoDB
AUTO_INCREMENT=1 ;
### Data of table `0_cust_allocations` ###
### Data of table `0_cust_allocations` ###
@@
-442,7
+442,7
@@
CREATE TABLE `0_cust_branch` (
PRIMARY KEY (`branch_code`,`debtor_no`),
KEY `branch_code` (`branch_code`),
KEY `br_name` (`br_name`)
PRIMARY KEY (`branch_code`,`debtor_no`),
KEY `branch_code` (`branch_code`),
KEY `br_name` (`br_name`)
-)
ENGINE=MyISAM DEFAULT CHARSET=latin1
AUTO_INCREMENT=1 ;
+)
TYPE=MyISAM
AUTO_INCREMENT=1 ;
### Data of table `0_cust_branch` ###
### Data of table `0_cust_branch` ###
@@
-477,7
+477,7
@@
CREATE TABLE `0_debtor_trans` (
`dimension2_id` int(11) NOT NULL default '0',
PRIMARY KEY (`trans_no`,`type`),
KEY `debtor_no` (`debtor_no`,`branch_code`)
`dimension2_id` int(11) NOT NULL default '0',
PRIMARY KEY (`trans_no`,`type`),
KEY `debtor_no` (`debtor_no`,`branch_code`)
-)
ENGINE=InnoDB DEFAULT CHARSET=latin1
;
+)
TYPE=InnoDB
;
### Data of table `0_debtor_trans` ###
### Data of table `0_debtor_trans` ###
@@
-501,7
+501,7
@@
CREATE TABLE `0_debtor_trans_details` (
`standard_cost` double NOT NULL default '0',
`qty_done` double NOT NULL default '0',
PRIMARY KEY (`id`)
`standard_cost` double NOT NULL default '0',
`qty_done` double NOT NULL default '0',
PRIMARY KEY (`id`)
-)
ENGINE=InnoDB DEFAULT CHARSET=latin1
AUTO_INCREMENT=1 ;
+)
TYPE=InnoDB
AUTO_INCREMENT=1 ;
### Data of table `0_debtor_trans_details` ###
### Data of table `0_debtor_trans_details` ###
@@
-522,7
+522,7
@@
CREATE TABLE `0_debtor_trans_tax_details` (
`included_in_price` tinyint(1) NOT NULL default '0',
`amount` double NOT NULL default '0',
PRIMARY KEY (`id`)
`included_in_price` tinyint(1) NOT NULL default '0',
`amount` double NOT NULL default '0',
PRIMARY KEY (`id`)
-)
ENGINE=InnoDB DEFAULT CHARSET=latin1
AUTO_INCREMENT=1 ;
+)
TYPE=InnoDB
AUTO_INCREMENT=1 ;
### Data of table `0_debtor_trans_tax_details` ###
### Data of table `0_debtor_trans_tax_details` ###
@@
-551,7
+551,7
@@
CREATE TABLE `0_debtors_master` (
`inactive` tinyint(1) NOT NULL default '0',
PRIMARY KEY (`debtor_no`),
UNIQUE KEY `name` (`name`)
`inactive` tinyint(1) NOT NULL default '0',
PRIMARY KEY (`debtor_no`),
UNIQUE KEY `name` (`name`)
-)
ENGINE=MyISAM DEFAULT CHARSET=latin1
AUTO_INCREMENT=1 ;
+)
TYPE=MyISAM
AUTO_INCREMENT=1 ;
### Data of table `0_debtors_master` ###
### Data of table `0_debtors_master` ###
@@
-572,7
+572,7
@@
CREATE TABLE `0_dimensions` (
`due_date` date NOT NULL default '0000-00-00',
PRIMARY KEY (`id`),
UNIQUE KEY `reference` (`reference`)
`due_date` date NOT NULL default '0000-00-00',
PRIMARY KEY (`id`),
UNIQUE KEY `reference` (`reference`)
-)
ENGINE=InnoDB DEFAULT CHARSET=latin1
AUTO_INCREMENT=1 ;
+)
TYPE=InnoDB
AUTO_INCREMENT=1 ;
### Data of table `0_dimensions` ###
### Data of table `0_dimensions` ###
@@
-591,7
+591,7
@@
CREATE TABLE `0_exchange_rates` (
`date_` date NOT NULL default '0000-00-00',
PRIMARY KEY (`id`),
UNIQUE KEY `curr_code` (`curr_code`,`date_`)
`date_` date NOT NULL default '0000-00-00',
PRIMARY KEY (`id`),
UNIQUE KEY `curr_code` (`curr_code`,`date_`)
-)
ENGINE=MyISAM DEFAULT CHARSET=latin1
AUTO_INCREMENT=1 ;
+)
TYPE=MyISAM
AUTO_INCREMENT=1 ;
### Data of table `0_exchange_rates` ###
### Data of table `0_exchange_rates` ###
@@
-608,7
+608,7
@@
CREATE TABLE `0_fiscal_year` (
`end` date default '0000-00-00',
`closed` tinyint(1) NOT NULL default '0',
PRIMARY KEY (`id`)
`end` date default '0000-00-00',
`closed` tinyint(1) NOT NULL default '0',
PRIMARY KEY (`id`)
-)
ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1
AUTO_INCREMENT=3 ;
+)
TYPE=InnoDB AUTO_INCREMENT=3
AUTO_INCREMENT=3 ;
### Data of table `0_fiscal_year` ###
### Data of table `0_fiscal_year` ###
@@
-634,7
+634,7
@@
CREATE TABLE `0_gl_trans` (
`person_id` tinyblob,
PRIMARY KEY (`counter`),
KEY `Type_and_Number` (`type`,`type_no`)
`person_id` tinyblob,
PRIMARY KEY (`counter`),
KEY `Type_and_Number` (`type`,`type_no`)
-)
ENGINE=InnoDB DEFAULT CHARSET=latin1
AUTO_INCREMENT=1 ;
+)
TYPE=InnoDB
AUTO_INCREMENT=1 ;
### Data of table `0_gl_trans` ###
### Data of table `0_gl_trans` ###
@@
-653,7
+653,7
@@
CREATE TABLE `0_grn_batch` (
`delivery_date` date NOT NULL default '0000-00-00',
`loc_code` varchar(5) default NULL,
PRIMARY KEY (`id`)
`delivery_date` date NOT NULL default '0000-00-00',
`loc_code` varchar(5) default NULL,
PRIMARY KEY (`id`)
-)
ENGINE=InnoDB DEFAULT CHARSET=latin1
AUTO_INCREMENT=1 ;
+)
TYPE=InnoDB
AUTO_INCREMENT=1 ;
### Data of table `0_grn_batch` ###
### Data of table `0_grn_batch` ###
@@
-673,7
+673,7
@@
CREATE TABLE `0_grn_items` (
`qty_recd` double NOT NULL default '0',
`quantity_inv` double NOT NULL default '0',
PRIMARY KEY (`id`)
`qty_recd` double NOT NULL default '0',
`quantity_inv` double NOT NULL default '0',
PRIMARY KEY (`id`)
-)
ENGINE=InnoDB DEFAULT CHARSET=latin1
AUTO_INCREMENT=1 ;
+)
TYPE=InnoDB
AUTO_INCREMENT=1 ;
### Data of table `0_grn_items` ###
### Data of table `0_grn_items` ###
@@
-690,7
+690,7
@@
CREATE TABLE `0_groups` (
`inactive` tinyint(1) NOT NULL default '0',
PRIMARY KEY (`id`),
UNIQUE KEY `description` (`description`)
`inactive` tinyint(1) NOT NULL default '0',
PRIMARY KEY (`id`),
UNIQUE KEY `description` (`description`)
-)
ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=latin1
AUTO_INCREMENT=4 ;
+)
TYPE=MyISAM AUTO_INCREMENT=4
AUTO_INCREMENT=4 ;
### Data of table `0_groups` ###
### Data of table `0_groups` ###
@@
-715,7
+715,7
@@
CREATE TABLE `0_item_codes` (
`inactive` tinyint(1) NOT NULL default '0',
PRIMARY KEY (`id`),
UNIQUE KEY `stock_id` (`stock_id`,`item_code`)
`inactive` tinyint(1) NOT NULL default '0',
PRIMARY KEY (`id`),
UNIQUE KEY `stock_id` (`stock_id`,`item_code`)
-)
ENGINE=MyISAM DEFAULT CHARSET=latin1
AUTO_INCREMENT=1 ;
+)
TYPE=MyISAM
AUTO_INCREMENT=1 ;
### Data of table `0_item_codes` ###
### Data of table `0_item_codes` ###
@@
-730,7
+730,7
@@
CREATE TABLE `0_item_tax_type_exemptions` (
`item_tax_type_id` int(11) NOT NULL default '0',
`tax_type_id` int(11) NOT NULL default '0',
PRIMARY KEY (`item_tax_type_id`,`tax_type_id`)
`item_tax_type_id` int(11) NOT NULL default '0',
`tax_type_id` int(11) NOT NULL default '0',
PRIMARY KEY (`item_tax_type_id`,`tax_type_id`)
-)
ENGINE=InnoDB DEFAULT CHARSET=latin1
;
+)
TYPE=InnoDB
;
### Data of table `0_item_tax_type_exemptions` ###
### Data of table `0_item_tax_type_exemptions` ###
@@
-747,7
+747,7
@@
CREATE TABLE `0_item_tax_types` (
`exempt` tinyint(1) NOT NULL default '0',
PRIMARY KEY (`id`),
UNIQUE KEY `name` (`name`)
`exempt` tinyint(1) NOT NULL default '0',
PRIMARY KEY (`id`),
UNIQUE KEY `name` (`name`)
-)
ENGINE=InnoDB DEFAULT CHARSET=latin1
AUTO_INCREMENT=1 ;
+)
TYPE=InnoDB
AUTO_INCREMENT=1 ;
### Data of table `0_item_tax_types` ###
### Data of table `0_item_tax_types` ###
@@
-765,7
+765,7
@@
CREATE TABLE `0_item_units` (
`inactive` tinyint(1) NOT NULL default '0',
PRIMARY KEY (`abbr`),
UNIQUE KEY `name` (`name`)
`inactive` tinyint(1) NOT NULL default '0',
PRIMARY KEY (`abbr`),
UNIQUE KEY `name` (`name`)
-)
ENGINE=MyISAM DEFAULT CHARSET=latin1
;
+)
TYPE=MyISAM
;
### Data of table `0_item_units` ###
### Data of table `0_item_units` ###
@@
-783,7
+783,7
@@
CREATE TABLE `0_loc_stock` (
`reorder_level` bigint(20) NOT NULL default '0',
PRIMARY KEY (`loc_code`,`stock_id`),
KEY `stock_id` (`stock_id`)
`reorder_level` bigint(20) NOT NULL default '0',
PRIMARY KEY (`loc_code`,`stock_id`),
KEY `stock_id` (`stock_id`)
-)
ENGINE=InnoDB DEFAULT CHARSET=latin1
;
+)
TYPE=InnoDB
;
### Data of table `0_loc_stock` ###
### Data of table `0_loc_stock` ###
@@
-804,7
+804,7
@@
CREATE TABLE `0_locations` (
`contact` varchar(30) NOT NULL default '',
`inactive` tinyint(1) NOT NULL default '0',
PRIMARY KEY (`loc_code`)
`contact` varchar(30) NOT NULL default '',
`inactive` tinyint(1) NOT NULL default '0',
PRIMARY KEY (`loc_code`)
-)
ENGINE=MyISAM DEFAULT CHARSET=latin1
;
+)
TYPE=MyISAM
;
### Data of table `0_locations` ###
### Data of table `0_locations` ###
@@
-821,7
+821,7
@@
CREATE TABLE `0_movement_types` (
`name` varchar(60) NOT NULL default '',
PRIMARY KEY (`id`),
UNIQUE KEY `name` (`name`)
`name` varchar(60) NOT NULL default '',
PRIMARY KEY (`id`),
UNIQUE KEY `name` (`name`)
-)
ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=latin1
AUTO_INCREMENT=2 ;
+)
TYPE=MyISAM AUTO_INCREMENT=2
AUTO_INCREMENT=2 ;
### Data of table `0_movement_types` ###
### Data of table `0_movement_types` ###
@@
-841,7
+841,7
@@
CREATE TABLE `0_payment_terms` (
`inactive` tinyint(1) NOT NULL default '0',
PRIMARY KEY (`terms_indicator`),
UNIQUE KEY `terms` (`terms`)
`inactive` tinyint(1) NOT NULL default '0',
PRIMARY KEY (`terms_indicator`),
UNIQUE KEY `terms` (`terms`)
-)
ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=latin1
AUTO_INCREMENT=5 ;
+)
TYPE=MyISAM AUTO_INCREMENT=5
AUTO_INCREMENT=5 ;
### Data of table `0_payment_terms` ###
### Data of table `0_payment_terms` ###
@@
-864,7
+864,7
@@
CREATE TABLE `0_prices` (
`price` double NOT NULL default '0',
PRIMARY KEY (`id`),
UNIQUE KEY `price` (`stock_id`,`sales_type_id`,`curr_abrev`)
`price` double NOT NULL default '0',
PRIMARY KEY (`id`),
UNIQUE KEY `price` (`stock_id`,`sales_type_id`,`curr_abrev`)
-)
ENGINE=MyISAM DEFAULT CHARSET=latin1
AUTO_INCREMENT=1 ;
+)
TYPE=MyISAM
AUTO_INCREMENT=1 ;
### Data of table `0_prices` ###
### Data of table `0_prices` ###
@@
-882,7
+882,7
@@
CREATE TABLE `0_print_profiles` (
`printer` tinyint(3) unsigned default NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `profile` (`profile`,`report`)
`printer` tinyint(3) unsigned default NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `profile` (`profile`,`report`)
-)
ENGINE=MyISAM AUTO_INCREMENT=10 DEFAULT CHARSET=latin1
AUTO_INCREMENT=10 ;
+)
TYPE=MyISAM AUTO_INCREMENT=10
AUTO_INCREMENT=10 ;
### Data of table `0_print_profiles` ###
### Data of table `0_print_profiles` ###
@@
-912,7
+912,7
@@
CREATE TABLE `0_printers` (
`timeout` tinyint(3) unsigned NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `name` (`name`)
`timeout` tinyint(3) unsigned NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `name` (`name`)
-)
ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=latin1
AUTO_INCREMENT=4 ;
+)
TYPE=MyISAM AUTO_INCREMENT=4
AUTO_INCREMENT=4 ;
### Data of table `0_printers` ###
### Data of table `0_printers` ###
@@
-934,7
+934,7
@@
CREATE TABLE `0_purch_data` (
`conversion_factor` double NOT NULL default '1',
`supplier_description` char(50) NOT NULL default '',
PRIMARY KEY (`supplier_id`,`stock_id`)
`conversion_factor` double NOT NULL default '1',
`supplier_description` char(50) NOT NULL default '',
PRIMARY KEY (`supplier_id`,`stock_id`)
-)
ENGINE=MyISAM DEFAULT CHARSET=latin1
;
+)
TYPE=MyISAM
;
### Data of table `0_purch_data` ###
### Data of table `0_purch_data` ###
@@
-958,7
+958,7
@@
CREATE TABLE `0_purch_order_details` (
`quantity_ordered` double NOT NULL default '0',
`quantity_received` double NOT NULL default '0',
PRIMARY KEY (`po_detail_item`)
`quantity_ordered` double NOT NULL default '0',
`quantity_received` double NOT NULL default '0',
PRIMARY KEY (`po_detail_item`)
-)
ENGINE=InnoDB DEFAULT CHARSET=latin1
AUTO_INCREMENT=1 ;
+)
TYPE=InnoDB
AUTO_INCREMENT=1 ;
### Data of table `0_purch_order_details` ###
### Data of table `0_purch_order_details` ###
@@
-979,7
+979,7
@@
CREATE TABLE `0_purch_orders` (
`into_stock_location` varchar(5) NOT NULL default '',
`delivery_address` tinytext NOT NULL,
PRIMARY KEY (`order_no`)
`into_stock_location` varchar(5) NOT NULL default '',
`delivery_address` tinytext NOT NULL,
PRIMARY KEY (`order_no`)
-)
ENGINE=InnoDB DEFAULT CHARSET=latin1
AUTO_INCREMENT=1 ;
+)
TYPE=InnoDB
AUTO_INCREMENT=1 ;
### Data of table `0_purch_orders` ###
### Data of table `0_purch_orders` ###
@@
-998,7
+998,7
@@
CREATE TABLE `0_quick_entries` (
`base_desc` varchar(60) default NULL,
PRIMARY KEY (`id`),
KEY `description` (`description`)
`base_desc` varchar(60) default NULL,
PRIMARY KEY (`id`),
KEY `description` (`description`)
-)
ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=latin1
AUTO_INCREMENT=4 ;
+)
TYPE=MyISAM AUTO_INCREMENT=4
AUTO_INCREMENT=4 ;
### Data of table `0_quick_entries` ###
### Data of table `0_quick_entries` ###
@@
-1022,7
+1022,7
@@
CREATE TABLE `0_quick_entry_lines` (
`dimension2_id` smallint(6) unsigned default NULL,
PRIMARY KEY (`id`),
KEY `qid` (`qid`)
`dimension2_id` smallint(6) unsigned default NULL,
PRIMARY KEY (`id`),
KEY `qid` (`qid`)
-)
ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=latin1
AUTO_INCREMENT=4 ;
+)
TYPE=MyISAM AUTO_INCREMENT=4
AUTO_INCREMENT=4 ;
### Data of table `0_quick_entry_lines` ###
### Data of table `0_quick_entry_lines` ###
@@
-1049,7
+1049,7
@@
CREATE TABLE `0_recurrent_invoices` (
`last_sent` date NOT NULL default '0000-00-00',
PRIMARY KEY (`id`),
UNIQUE KEY `description` (`description`)
`last_sent` date NOT NULL default '0000-00-00',
PRIMARY KEY (`id`),
UNIQUE KEY `description` (`description`)
-)
ENGINE=InnoDB DEFAULT CHARSET=latin1
AUTO_INCREMENT=1 ;
+)
TYPE=InnoDB
AUTO_INCREMENT=1 ;
### Data of table `0_recurrent_invoices` ###
### Data of table `0_recurrent_invoices` ###
@@
-1065,7
+1065,7
@@
CREATE TABLE `0_refs` (
`type` int(11) NOT NULL default '0',
`reference` varchar(100) NOT NULL default '',
PRIMARY KEY (`id`,`type`)
`type` int(11) NOT NULL default '0',
`reference` varchar(100) NOT NULL default '',
PRIMARY KEY (`id`,`type`)
-)
ENGINE=InnoDB DEFAULT CHARSET=latin1
;
+)
TYPE=InnoDB
;
### Data of table `0_refs` ###
### Data of table `0_refs` ###
@@
-1086,7
+1086,7
@@
CREATE TABLE `0_sales_order_details` (
`quantity` double NOT NULL default '0',
`discount_percent` double NOT NULL default '0',
PRIMARY KEY (`id`)
`quantity` double NOT NULL default '0',
`discount_percent` double NOT NULL default '0',
PRIMARY KEY (`id`)
-)
ENGINE=InnoDB DEFAULT CHARSET=latin1
AUTO_INCREMENT=1 ;
+)
TYPE=InnoDB
AUTO_INCREMENT=1 ;
### Data of table `0_sales_order_details` ###
### Data of table `0_sales_order_details` ###
@@
-1116,7
+1116,7
@@
CREATE TABLE `0_sales_orders` (
`from_stk_loc` varchar(5) NOT NULL default '',
`delivery_date` date NOT NULL default '0000-00-00',
PRIMARY KEY (`order_no`)
`from_stk_loc` varchar(5) NOT NULL default '',
`delivery_date` date NOT NULL default '0000-00-00',
PRIMARY KEY (`order_no`)
-)
ENGINE=InnoDB DEFAULT CHARSET=latin1
AUTO_INCREMENT=1 ;
+)
TYPE=InnoDB
AUTO_INCREMENT=1 ;
### Data of table `0_sales_orders` ###
### Data of table `0_sales_orders` ###
@@
-1137,7
+1137,7
@@
CREATE TABLE `0_sales_pos` (
`inactive` tinyint(1) NOT NULL default '0',
PRIMARY KEY (`id`),
UNIQUE KEY `pos_name` (`pos_name`)
`inactive` tinyint(1) NOT NULL default '0',
PRIMARY KEY (`id`),
UNIQUE KEY `pos_name` (`pos_name`)
-)
ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=latin1
AUTO_INCREMENT=2 ;
+)
TYPE=MyISAM AUTO_INCREMENT=2
AUTO_INCREMENT=2 ;
### Data of table `0_sales_pos` ###
### Data of table `0_sales_pos` ###
@@
-1157,7
+1157,7
@@
CREATE TABLE `0_sales_types` (
`inactive` tinyint(1) NOT NULL default '0',
PRIMARY KEY (`id`),
UNIQUE KEY `sales_type` (`sales_type`)
`inactive` tinyint(1) NOT NULL default '0',
PRIMARY KEY (`id`),
UNIQUE KEY `sales_type` (`sales_type`)
-)
ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=latin1
AUTO_INCREMENT=3 ;
+)
TYPE=MyISAM AUTO_INCREMENT=3
AUTO_INCREMENT=3 ;
### Data of table `0_sales_types` ###
### Data of table `0_sales_types` ###
@@
-1182,7
+1182,7
@@
CREATE TABLE `0_salesman` (
`inactive` tinyint(1) NOT NULL default '0',
PRIMARY KEY (`salesman_code`),
UNIQUE KEY `salesman_name` (`salesman_name`)
`inactive` tinyint(1) NOT NULL default '0',
PRIMARY KEY (`salesman_code`),
UNIQUE KEY `salesman_name` (`salesman_name`)
-)
ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=latin1
AUTO_INCREMENT=2 ;
+)
TYPE=MyISAM AUTO_INCREMENT=2
AUTO_INCREMENT=2 ;
### Data of table `0_salesman` ###
### Data of table `0_salesman` ###
@@
-1203,7
+1203,7
@@
CREATE TABLE `0_shippers` (
`inactive` tinyint(1) NOT NULL default '0',
PRIMARY KEY (`shipper_id`),
UNIQUE KEY `name` (`shipper_name`)
`inactive` tinyint(1) NOT NULL default '0',
PRIMARY KEY (`shipper_id`),
UNIQUE KEY `name` (`shipper_name`)
-)
ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=latin1
AUTO_INCREMENT=2 ;
+)
TYPE=MyISAM AUTO_INCREMENT=2
AUTO_INCREMENT=2 ;
### Data of table `0_shippers` ###
### Data of table `0_shippers` ###
@@
-1221,7
+1221,7
@@
CREATE TABLE `0_sql_trail` (
`result` tinyint(1) NOT NULL,
`msg` varchar(255) NOT NULL,
PRIMARY KEY (`id`)
`result` tinyint(1) NOT NULL,
`msg` varchar(255) NOT NULL,
PRIMARY KEY (`id`)
-)
ENGINE=MyISAM DEFAULT CHARSET=latin1
AUTO_INCREMENT=1 ;
+)
TYPE=MyISAM
AUTO_INCREMENT=1 ;
### Data of table `0_sql_trail` ###
### Data of table `0_sql_trail` ###
@@
-1242,7
+1242,7
@@
CREATE TABLE `0_stock_category` (
`inactive` tinyint(1) NOT NULL default '0',
PRIMARY KEY (`category_id`),
UNIQUE KEY `description` (`description`)
`inactive` tinyint(1) NOT NULL default '0',
PRIMARY KEY (`category_id`),
UNIQUE KEY `description` (`description`)
-)
ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=latin1
AUTO_INCREMENT=5 ;
+)
TYPE=MyISAM AUTO_INCREMENT=5
AUTO_INCREMENT=5 ;
### Data of table `0_stock_category` ###
### Data of table `0_stock_category` ###
@@
-1279,7
+1279,7
@@
CREATE TABLE `0_stock_master` (
`overhead_cost` double NOT NULL default '0',
`inactive` tinyint(1) NOT NULL default '0',
PRIMARY KEY (`stock_id`)
`overhead_cost` double NOT NULL default '0',
`inactive` tinyint(1) NOT NULL default '0',
PRIMARY KEY (`stock_id`)
-)
ENGINE=InnoDB DEFAULT CHARSET=latin1
;
+)
TYPE=InnoDB
;
### Data of table `0_stock_master` ###
### Data of table `0_stock_master` ###
@@
-1306,7
+1306,7
@@
CREATE TABLE `0_stock_moves` (
`visible` tinyint(1) NOT NULL default '1',
PRIMARY KEY (`trans_id`),
KEY `type` (`type`,`trans_no`)
`visible` tinyint(1) NOT NULL default '1',
PRIMARY KEY (`trans_id`),
KEY `type` (`type`,`trans_no`)
-)
ENGINE=InnoDB DEFAULT CHARSET=latin1
AUTO_INCREMENT=1 ;
+)
TYPE=InnoDB
AUTO_INCREMENT=1 ;
### Data of table `0_stock_moves` ###
### Data of table `0_stock_moves` ###
@@
-1326,7
+1326,7
@@
CREATE TABLE `0_supp_allocations` (
`trans_no_to` int(11) default NULL,
`trans_type_to` int(11) default NULL,
PRIMARY KEY (`id`)
`trans_no_to` int(11) default NULL,
`trans_type_to` int(11) default NULL,
PRIMARY KEY (`id`)
-)
ENGINE=InnoDB DEFAULT CHARSET=latin1
AUTO_INCREMENT=1 ;
+)
TYPE=InnoDB
AUTO_INCREMENT=1 ;
### Data of table `0_supp_allocations` ###
### Data of table `0_supp_allocations` ###
@@
-1351,7
+1351,7
@@
CREATE TABLE `0_supp_invoice_items` (
`unit_tax` double NOT NULL default '0',
`memo_` tinytext,
PRIMARY KEY (`id`)
`unit_tax` double NOT NULL default '0',
`memo_` tinytext,
PRIMARY KEY (`id`)
-)
ENGINE=InnoDB DEFAULT CHARSET=latin1
AUTO_INCREMENT=1 ;
+)
TYPE=InnoDB
AUTO_INCREMENT=1 ;
### Data of table `0_supp_invoice_items` ###
### Data of table `0_supp_invoice_items` ###
@@
-1372,7
+1372,7
@@
CREATE TABLE `0_supp_invoice_tax_items` (
`included_in_price` tinyint(1) NOT NULL default '0',
`amount` double NOT NULL default '0',
PRIMARY KEY (`id`)
`included_in_price` tinyint(1) NOT NULL default '0',
`amount` double NOT NULL default '0',
PRIMARY KEY (`id`)
-)
ENGINE=InnoDB DEFAULT CHARSET=latin1
AUTO_INCREMENT=1 ;
+)
TYPE=InnoDB
AUTO_INCREMENT=1 ;
### Data of table `0_supp_invoice_tax_items` ###
### Data of table `0_supp_invoice_tax_items` ###
@@
-1400,7
+1400,7
@@
CREATE TABLE `0_supp_trans` (
KEY `supplier_id` (`supplier_id`),
KEY `SupplierID_2` (`supplier_id`,`supp_reference`),
KEY `type` (`type`)
KEY `supplier_id` (`supplier_id`),
KEY `SupplierID_2` (`supplier_id`,`supp_reference`),
KEY `type` (`type`)
-)
ENGINE=InnoDB DEFAULT CHARSET=latin1
;
+)
TYPE=InnoDB
;
### Data of table `0_supp_trans` ###
### Data of table `0_supp_trans` ###
@@
-1436,7
+1436,7
@@
CREATE TABLE `0_suppliers` (
`notes` tinytext NOT NULL,
`inactive` tinyint(1) NOT NULL default '0',
PRIMARY KEY (`supplier_id`)
`notes` tinytext NOT NULL,
`inactive` tinyint(1) NOT NULL default '0',
PRIMARY KEY (`supplier_id`)
-)
ENGINE=MyISAM DEFAULT CHARSET=latin1
AUTO_INCREMENT=1 ;
+)
TYPE=MyISAM
AUTO_INCREMENT=1 ;
### Data of table `0_suppliers` ###
### Data of table `0_suppliers` ###
@@
-1453,7
+1453,7
@@
CREATE TABLE `0_sys_types` (
`type_no` int(11) NOT NULL default '1',
`next_reference` varchar(100) NOT NULL default '',
PRIMARY KEY (`type_id`)
`type_no` int(11) NOT NULL default '1',
`next_reference` varchar(100) NOT NULL default '',
PRIMARY KEY (`type_id`)
-)
ENGINE=InnoDB DEFAULT CHARSET=latin1
;
+)
TYPE=InnoDB
;
### Data of table `0_sys_types` ###
### Data of table `0_sys_types` ###
@@
-1490,7
+1490,7
@@
CREATE TABLE `0_tax_group_items` (
`tax_type_id` int(11) NOT NULL default '0',
`rate` double NOT NULL default '0',
PRIMARY KEY (`tax_group_id`,`tax_type_id`)
`tax_type_id` int(11) NOT NULL default '0',
`rate` double NOT NULL default '0',
PRIMARY KEY (`tax_group_id`,`tax_type_id`)
-)
ENGINE=InnoDB DEFAULT CHARSET=latin1
;
+)
TYPE=InnoDB
;
### Data of table `0_tax_group_items` ###
### Data of table `0_tax_group_items` ###
@@
-1507,7
+1507,7
@@
CREATE TABLE `0_tax_groups` (
`tax_shipping` tinyint(1) NOT NULL default '0',
PRIMARY KEY (`id`),
UNIQUE KEY `name` (`name`)
`tax_shipping` tinyint(1) NOT NULL default '0',
PRIMARY KEY (`id`),
UNIQUE KEY `name` (`name`)
-)
ENGINE=InnoDB DEFAULT CHARSET=latin1
AUTO_INCREMENT=1 ;
+)
TYPE=InnoDB
AUTO_INCREMENT=1 ;
### Data of table `0_tax_groups` ###
### Data of table `0_tax_groups` ###
@@
-1526,7
+1526,7
@@
CREATE TABLE `0_tax_types` (
`name` varchar(60) NOT NULL default '',
PRIMARY KEY (`id`),
UNIQUE KEY `name` (`name`,`rate`)
`name` varchar(60) NOT NULL default '',
PRIMARY KEY (`id`),
UNIQUE KEY `name` (`name`,`rate`)
-)
ENGINE=InnoDB DEFAULT CHARSET=latin1
AUTO_INCREMENT=1 ;
+)
TYPE=InnoDB
AUTO_INCREMENT=1 ;
### Data of table `0_tax_types` ###
### Data of table `0_tax_types` ###
@@
-1565,7
+1565,7
@@
CREATE TABLE `0_users` (
`print_profile` varchar(30) NOT NULL default '1',
`rep_popup` tinyint(1) default '1',
PRIMARY KEY (`user_id`)
`print_profile` varchar(30) NOT NULL default '1',
`rep_popup` tinyint(1) default '1',
PRIMARY KEY (`user_id`)
-)
ENGINE=MyISAM DEFAULT CHARSET=latin1
;
+)
TYPE=MyISAM
;
### Data of table `0_users` ###
### Data of table `0_users` ###
@@
-1583,7
+1583,7
@@
CREATE TABLE `0_voided` (
`date_` date NOT NULL default '0000-00-00',
`memo_` tinytext NOT NULL,
UNIQUE KEY `id` (`type`,`id`)
`date_` date NOT NULL default '0000-00-00',
`memo_` tinytext NOT NULL,
UNIQUE KEY `id` (`type`,`id`)
-)
ENGINE=InnoDB DEFAULT CHARSET=latin1
;
+)
TYPE=InnoDB
;
### Data of table `0_voided` ###
### Data of table `0_voided` ###
@@
-1600,7
+1600,7
@@
CREATE TABLE `0_wo_issue_items` (
`issue_id` int(11) default NULL,
`qty_issued` double default NULL,
PRIMARY KEY (`id`)
`issue_id` int(11) default NULL,
`qty_issued` double default NULL,
PRIMARY KEY (`id`)
-)
ENGINE=InnoDB DEFAULT CHARSET=latin1
AUTO_INCREMENT=1 ;
+)
TYPE=InnoDB
AUTO_INCREMENT=1 ;
### Data of table `0_wo_issue_items` ###
### Data of table `0_wo_issue_items` ###
@@
-1619,7
+1619,7
@@
CREATE TABLE `0_wo_issues` (
`loc_code` varchar(5) default NULL,
`workcentre_id` int(11) default NULL,
PRIMARY KEY (`issue_no`)
`loc_code` varchar(5) default NULL,
`workcentre_id` int(11) default NULL,
PRIMARY KEY (`issue_no`)
-)
ENGINE=InnoDB DEFAULT CHARSET=latin1
AUTO_INCREMENT=1 ;
+)
TYPE=InnoDB
AUTO_INCREMENT=1 ;
### Data of table `0_wo_issues` ###
### Data of table `0_wo_issues` ###
@@
-1637,7
+1637,7
@@
CREATE TABLE `0_wo_manufacture` (
`quantity` double NOT NULL default '0',
`date_` date NOT NULL default '0000-00-00',
PRIMARY KEY (`id`)
`quantity` double NOT NULL default '0',
`date_` date NOT NULL default '0000-00-00',
PRIMARY KEY (`id`)
-)
ENGINE=InnoDB DEFAULT CHARSET=latin1
AUTO_INCREMENT=1 ;
+)
TYPE=InnoDB
AUTO_INCREMENT=1 ;
### Data of table `0_wo_manufacture` ###
### Data of table `0_wo_manufacture` ###
@@
-1658,7
+1658,7
@@
CREATE TABLE `0_wo_requirements` (
`loc_code` char(5) NOT NULL default '',
`units_issued` double NOT NULL default '0',
PRIMARY KEY (`id`)
`loc_code` char(5) NOT NULL default '',
`units_issued` double NOT NULL default '0',
PRIMARY KEY (`id`)
-)
ENGINE=InnoDB DEFAULT CHARSET=latin1
AUTO_INCREMENT=1 ;
+)
TYPE=InnoDB
AUTO_INCREMENT=1 ;
### Data of table `0_wo_requirements` ###
### Data of table `0_wo_requirements` ###
@@
-1676,7
+1676,7
@@
CREATE TABLE `0_workcentres` (
`inactive` tinyint(1) NOT NULL default '0',
PRIMARY KEY (`id`),
UNIQUE KEY `name` (`name`)
`inactive` tinyint(1) NOT NULL default '0',
PRIMARY KEY (`id`),
UNIQUE KEY `name` (`name`)
-)
ENGINE=MyISAM DEFAULT CHARSET=latin1
AUTO_INCREMENT=1 ;
+)
TYPE=MyISAM
AUTO_INCREMENT=1 ;
### Data of table `0_workcentres` ###
### Data of table `0_workcentres` ###
@@
-1703,7
+1703,7
@@
CREATE TABLE `0_workorders` (
`additional_costs` double NOT NULL default '0',
PRIMARY KEY (`id`),
UNIQUE KEY `wo_ref` (`wo_ref`)
`additional_costs` double NOT NULL default '0',
PRIMARY KEY (`id`),
UNIQUE KEY `wo_ref` (`wo_ref`)
-)
ENGINE=InnoDB DEFAULT CHARSET=latin1
AUTO_INCREMENT=1 ;
+)
TYPE=InnoDB
AUTO_INCREMENT=1 ;
### Data of table `0_workorders` ###
### Data of table `0_workorders` ###