From: Janusz Dobrowolski <janusz@frontaccounting.eu>
Date: Tue, 21 Apr 2015 07:53:47 +0000 (+0200)
Subject: Removed obsolete keys on supp_trans and cust_branch tables.
X-Git-Tag: v2.4.2~19^2~189
X-Git-Url: https://delta.frontaccounting.com/gitweb/?p=fa-stable.git;a=commitdiff_plain;h=c2aed11d0b33a70d83d82d4d278e1a328c15b356

Removed obsolete keys on supp_trans and cust_branch tables.
---

diff --git a/sql/alter2.4.sql b/sql/alter2.4.sql
index 2e765bfb..0a88229b 100644
--- 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 ba10cf95..75f96b4d 100644
--- 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 1c21bd9c..a17d8b5f 100644
--- 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;