X-Git-Url: https://delta.frontaccounting.com/gitweb/?a=blobdiff_plain;f=sql%2Fen_US-new.sql;h=9864121a9fb4f0b821acf9debf497e435bf552ca;hb=40048ce06ec19e91186a38b841b03038ddd6107f;hp=90a44aa5318d57771fe614dee8191ac70370cae3;hpb=a5953f4c442fb44f1e60eb1e15eb7066dca95420;p=fa-stable.git diff --git a/sql/en_US-new.sql b/sql/en_US-new.sql index 90a44aa5..9864121a 100644 --- a/sql/en_US-new.sql +++ b/sql/en_US-new.sql @@ -104,7 +104,6 @@ CREATE TABLE `0_bank_trans` ( `bank_act` varchar(11) default NULL, `ref` varchar(40) default NULL, `trans_date` date NOT NULL default '0000-00-00', - `bank_trans_type_id` int(10) unsigned default NULL, `amount` double default NULL, `dimension_id` int(11) NOT NULL default '0', `dimension2_id` int(11) NOT NULL default '0', @@ -392,13 +391,14 @@ CREATE TABLE `0_company` ( `time_zone` tinyint(1) NOT NULL default '0', `add_pct` int(5) NOT NULL default '-1', `round_to` int(5) NOT NULL default '1', + `login_tout` SMALLINT(6) NOT NULL DEFAULT '600', PRIMARY KEY (`coy_code`) ) TYPE=MyISAM ; ### Data of table `0_company` ### -INSERT INTO `0_company` VALUES ('1', 'Company name', '', '', '1', '1', 'N/A', '', '', '', '', '', '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', '1', '0', '0', '0', '1', '0', '0', '', '1', '2.2', '0', '-1', '1'); +INSERT INTO `0_company` VALUES ('1', 'Company name', '', '', '1', '1', 'N/A', '', '', '', '', '', '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', '1', '0', '0', '0', '1', '0', '0', '', '1', '2.2', '0', '-1', '1', '600'); ### Structure of table `0_credit_status` ### @@ -472,6 +472,7 @@ CREATE TABLE `0_cust_branch` ( `branch_code` int(11) NOT NULL auto_increment, `debtor_no` int(11) NOT NULL default '0', `br_name` varchar(60) NOT NULL default '', + `branch_ref` varchar(30) NOT NULL default '', `br_address` tinytext NOT NULL, `area` int(11) default NULL, `salesman` int(11) NOT NULL default '0', @@ -566,6 +567,7 @@ DROP TABLE IF EXISTS `0_debtors_master`; CREATE TABLE `0_debtors_master` ( `debtor_no` int(11) NOT NULL auto_increment, `name` varchar(80) NOT NULL default '', + `debtor_ref` varchar(30) NOT NULL, `address` tinytext, `email` varchar(100) NOT NULL default '', `tax_id` varchar(55) NOT NULL default '', @@ -1115,6 +1117,7 @@ DROP TABLE IF EXISTS `0_sales_order_details`; CREATE TABLE `0_sales_order_details` ( `id` int(11) NOT NULL auto_increment, `order_no` int(11) NOT NULL default '0', + `trans_type` smallint(6) NOT NULL default '30', `stk_code` varchar(20) NOT NULL default '', `description` tinytext, `qty_sent` double NOT NULL default '0', @@ -1135,10 +1138,12 @@ DROP TABLE IF EXISTS `0_sales_orders`; CREATE TABLE `0_sales_orders` ( `order_no` int(11) NOT NULL auto_increment, + `trans_type` smallint(6) NOT NULL default '30', `version` tinyint(1) unsigned NOT NULL default '0', `type` tinyint(1) NOT NULL default '0', `debtor_no` int(11) NOT NULL default '0', `branch_code` int(11) NOT NULL default '0', + `reference` varchar(100) NOT NULL default '', `customer_ref` tinytext NOT NULL, `comments` tinytext, `ord_date` date NOT NULL default '0000-00-00', @@ -1151,8 +1156,8 @@ CREATE TABLE `0_sales_orders` ( `freight_cost` double NOT NULL default '0', `from_stk_loc` varchar(5) NOT NULL default '', `delivery_date` date NOT NULL default '0000-00-00', - PRIMARY KEY (`order_no`) -) TYPE=InnoDB AUTO_INCREMENT=1 ; + PRIMARY KEY (`trans_type`, `order_no`) +) TYPE=InnoDB; ### Data of table `0_sales_orders` ### @@ -1437,6 +1442,7 @@ DROP TABLE IF EXISTS `0_suppliers`; CREATE TABLE `0_suppliers` ( `supplier_id` int(11) NOT NULL auto_increment, `supp_name` varchar(60) NOT NULL default '', + `supp_ref` varchar(30) NOT NULL default '', `address` tinytext NOT NULL, `supp_address` tinytext NOT NULL, `phone` varchar(30) NOT NULL default '', @@ -1472,7 +1478,6 @@ DROP TABLE IF EXISTS `0_sys_types`; CREATE TABLE `0_sys_types` ( `type_id` smallint(6) NOT NULL default '0', - `type_name` varchar(60) NOT NULL default '', `type_no` int(11) NOT NULL default '1', `next_reference` varchar(100) NOT NULL default '', PRIMARY KEY (`type_id`) @@ -1481,27 +1486,28 @@ CREATE TABLE `0_sys_types` ( ### Data of table `0_sys_types` ### -INSERT INTO `0_sys_types` VALUES ('0', 'Journal - GL', '17', '1'); -INSERT INTO `0_sys_types` VALUES ('1', 'Payment - GL', '7', '1'); -INSERT INTO `0_sys_types` VALUES ('2', 'Receipt - GL', '4', '1'); -INSERT INTO `0_sys_types` VALUES ('4', 'Funds Transfer', '3', '1'); -INSERT INTO `0_sys_types` VALUES ('10', 'Sales Invoice', '16', '1'); -INSERT INTO `0_sys_types` VALUES ('11', 'Credit Note', '2', '1'); -INSERT INTO `0_sys_types` VALUES ('12', 'Receipt', '6', '1'); -INSERT INTO `0_sys_types` VALUES ('13', 'Delivery', '1', '1'); -INSERT INTO `0_sys_types` VALUES ('16', 'Location Transfer', '2', '1'); -INSERT INTO `0_sys_types` VALUES ('17', 'Inventory Adjustment', '2', '1'); -INSERT INTO `0_sys_types` VALUES ('18', 'Purchase Order', '1', '1'); -INSERT INTO `0_sys_types` VALUES ('20', 'Supplier Invoice', '6', '1'); -INSERT INTO `0_sys_types` VALUES ('21', 'Supplier Credit Note', '1', '1'); -INSERT INTO `0_sys_types` VALUES ('22', 'Supplier Payment', '3', '1'); -INSERT INTO `0_sys_types` VALUES ('25', 'Purchase Order Delivery', '1', '1'); -INSERT INTO `0_sys_types` VALUES ('26', 'Work Order', '1', '1'); -INSERT INTO `0_sys_types` VALUES ('28', 'Work Order Issue', '1', '1'); -INSERT INTO `0_sys_types` VALUES ('29', 'Work Order Production', '1', '1'); -INSERT INTO `0_sys_types` VALUES ('30', 'Sales Order', '1', '1'); -INSERT INTO `0_sys_types` VALUES ('35', 'Cost Update', '1', '1'); -INSERT INTO `0_sys_types` VALUES ('40', 'Dimension', '1', '1'); +INSERT INTO `0_sys_types` VALUES ('0', '17', '1'); +INSERT INTO `0_sys_types` VALUES ('1', '7', '1'); +INSERT INTO `0_sys_types` VALUES ('2', '4', '1'); +INSERT INTO `0_sys_types` VALUES ('4', '3', '1'); +INSERT INTO `0_sys_types` VALUES ('10', '16', '1'); +INSERT INTO `0_sys_types` VALUES ('11', '2', '1'); +INSERT INTO `0_sys_types` VALUES ('12', '6', '1'); +INSERT INTO `0_sys_types` VALUES ('13', '1', '1'); +INSERT INTO `0_sys_types` VALUES ('16', '2', '1'); +INSERT INTO `0_sys_types` VALUES ('17', '2', '1'); +INSERT INTO `0_sys_types` VALUES ('18', '1', '1'); +INSERT INTO `0_sys_types` VALUES ('20', '6', '1'); +INSERT INTO `0_sys_types` VALUES ('21', '1', '1'); +INSERT INTO `0_sys_types` VALUES ('22', '3', '1'); +INSERT INTO `0_sys_types` VALUES ('25', '1', '1'); +INSERT INTO `0_sys_types` VALUES ('26', '1', '1'); +INSERT INTO `0_sys_types` VALUES ('28', '1', '1'); +INSERT INTO `0_sys_types` VALUES ('29', '1', '1'); +INSERT INTO `0_sys_types` VALUES ('30', '0', '1'); +INSERT INTO `0_sys_types` VALUES ('32', '0', '1'); +INSERT INTO `0_sys_types` VALUES ('35', '1', '1'); +INSERT INTO `0_sys_types` VALUES ('40', '1', '1'); ### Structure of table `0_tax_group_items` ### @@ -1595,7 +1601,7 @@ CREATE TABLE `0_users` ( `user_id` varchar(60) NOT NULL default '', `password` varchar(100) NOT NULL default '', `real_name` varchar(100) NOT NULL default '', - `full_access` int(11) NOT NULL default '1', + `role_id` int(11) NOT NULL default '1', `phone` varchar(30) NOT NULL default '', `email` varchar(100) default NULL, `language` varchar(20) default NULL, @@ -1619,6 +1625,7 @@ CREATE TABLE `0_users` ( `print_profile` varchar(30) NOT NULL default '1', `rep_popup` tinyint(1) default '1', `sticky_doc_date` tinyint(1) default '0', + `startup_tab` varchar(20) NOT NULL default '', `inactive` tinyint(1) NOT NULL default '0', PRIMARY KEY (`id`), UNIQUE KEY (`user_id`) @@ -1627,7 +1634,7 @@ CREATE TABLE `0_users` ( ### Data of table `0_users` ### -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', '2008-04-04 12:34:29', '10', '1', '1', '1', '1', '0', '0'); +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', '2008-04-04 12:34:29', '10', '1', '1', '1', '1', '0', 'orders', '0'); ### Structure of table `0_voided` ###