From d2413b54b1621203e9a47fbde443e854f76a2bbf Mon Sep 17 00:00:00 2001 From: Janusz Dobrowolski Date: Mon, 22 Dec 2014 19:14:48 +0100 Subject: [PATCH] Removed redundant indexes on supp_trans and cust_branch tables. --- sql/en_US-demo.sql | 5 +---- sql/en_US-new.sql | 5 +---- 2 files changed, 2 insertions(+), 8 deletions(-) diff --git a/sql/en_US-demo.sql b/sql/en_US-demo.sql index 83477e70..99c98e88 100644 --- a/sql/en_US-demo.sql +++ b/sql/en_US-demo.sql @@ -611,7 +611,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=MyISAM AUTO_INCREMENT=4 ; @@ -1997,9 +1996,7 @@ CREATE TABLE IF NOT EXISTS `0_supp_trans` ( `tax_included` tinyint(1) NOT NULL default '0', `tax_algorithm` tinyint(1) NOT NULL default '1', PRIMARY KEY (`type`,`trans_no`), - KEY `supplier_id` (`supplier_id`), - KEY `SupplierID_2` (`supplier_id`,`supp_reference`), - KEY `type` (`type`), + KEY `supplier_id` (`supplier_id`,`supp_reference`), KEY `tran_date` (`tran_date`) ) ENGINE=InnoDB; diff --git a/sql/en_US-new.sql b/sql/en_US-new.sql index 5daaa8fa..ad688605 100644 --- a/sql/en_US-new.sql +++ b/sql/en_US-new.sql @@ -576,7 +576,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=MyISAM AUTO_INCREMENT=1 ; @@ -1759,9 +1758,7 @@ CREATE TABLE IF NOT EXISTS `0_supp_trans` ( `tax_included` tinyint(1) NOT NULL default '0', `tax_algorithm` tinyint(1) NOT NULL default '1', PRIMARY KEY (`type`,`trans_no`), - KEY `supplier_id` (`supplier_id`), - KEY `SupplierID_2` (`supplier_id`,`supp_reference`), - KEY `type` (`type`), + KEY `supplier_id` (`supplier_id`,`supp_reference`), KEY `tran_date` (`tran_date`) ) ENGINE=InnoDB; -- 2.30.2