Removed obsolete keys on supp_trans and cust_branch tables.

diff --git a/sql/alter2.4.sql b/sql/alter2.4.sql
index 2e765bfb9916b8129bd09b33ad8ce9a02b219abb..0a88229b58435b0c3517056360854e4f0809c6b7 100644 (file)
--- a/sql/alter2.4.sql
+++ b/sql/alter2.4.sql
@@ -257,3 +257,7 @@ CREATE TABLE `0_reflines` (
 INSERT INTO `0_reflines` (`trans_type`, `pattern`, `default`) SELECT `type_id`, `next_reference`, 1 FROM `0_sys_types`;
 
 DROP TABLE `0_sys_types`;
+
+ALTER TABLE `0_cust_branch` DROP KEY `branch_code`;
+ALTER TABLE `0_supp_trans` DROP KEY `SupplierID_2`;
+ALTER TABLE `0_supp_trans` DROP KEY `type`;

diff --git a/sql/en_US-demo.sql b/sql/en_US-demo.sql
index ba10cf959db174d8ff7d287e6a68be197b493fee..75f96b4dcb344ddd09a8b12c2e963d448186779e 100644 (file)
--- a/sql/en_US-demo.sql
+++ b/sql/en_US-demo.sql
@@ -610,7 +610,6 @@ CREATE TABLE IF NOT EXISTS `0_cust_branch` (
   `bank_account` varchar(60) DEFAULT NULL,
   `inactive` tinyint(1) NOT NULL default '0',
   PRIMARY KEY  (`branch_code`,`debtor_no`),
-  KEY `branch_code` (`branch_code`),
   KEY `branch_ref` (`branch_ref`),
   KEY `group_no` (`group_no`)
 ) ENGINE=InnoDB  AUTO_INCREMENT=4 ;
@@ -2036,8 +2035,6 @@ CREATE TABLE IF NOT EXISTS `0_supp_trans` (
   `tax_included` tinyint(1) NOT NULL default '0',
   PRIMARY KEY  (`type`,`trans_no`),
   KEY `supplier_id` (`supplier_id`),
-  KEY `SupplierID_2` (`supplier_id`,`supp_reference`),
-  KEY `type` (`type`),
   KEY `tran_date` (`tran_date`)
 ) ENGINE=InnoDB;
 

diff --git a/sql/en_US-new.sql b/sql/en_US-new.sql
index 1c21bd9cb024ca66f735bd756fcba78b8b2cc1ed..a17d8b5f84196adccac1c3d931e419c6fd412cf6 100644 (file)
--- a/sql/en_US-new.sql
+++ b/sql/en_US-new.sql
@@ -575,7 +575,6 @@ CREATE TABLE IF NOT EXISTS `0_cust_branch` (
   `bank_account` varchar(60) DEFAULT NULL,
   `inactive` tinyint(1) NOT NULL default '0',
   PRIMARY KEY  (`branch_code`,`debtor_no`),
-  KEY `branch_code` (`branch_code`),
   KEY `branch_ref` (`branch_ref`),
   KEY `group_no` (`group_no`)
 ) ENGINE=InnoDB AUTO_INCREMENT=1 ;
@@ -1794,8 +1793,6 @@ CREATE TABLE IF NOT EXISTS `0_supp_trans` (
   `tax_included` tinyint(1) NOT NULL default '0',
   PRIMARY KEY  (`type`,`trans_no`),
   KEY `supplier_id` (`supplier_id`),
-  KEY `SupplierID_2` (`supplier_id`,`supp_reference`),
-  KEY `type` (`type`),
   KEY `tran_date` (`tran_date`)
 ) ENGINE=InnoDB;