From: Janusz Dobrowolski <janusz@frontaccounting.eu>
Date: Sun, 21 Dec 2014 16:32:41 +0000 (+0100)
Subject: Removed redundant index on supp_trans.type.
X-Git-Tag: 2.3-final~79
X-Git-Url: https://delta.frontaccounting.com/gitweb/?p=fa-stable.git;a=commitdiff_plain;h=f7405f00e090326b631322c77a398826ac8115d9

Removed redundant index on supp_trans.type.
---

diff --git a/sql/en_US-new.sql b/sql/en_US-new.sql
index 34b11c00..3420a95c 100644
--- a/sql/en_US-new.sql
+++ b/sql/en_US-new.sql
@@ -1743,7 +1743,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`,`supp_reference`),
-  KEY `type` (`type`),
   KEY `tran_date` (`tran_date`)
 ) ENGINE=InnoDB;