Removed redundant index on supp_trans.type.
authorJanusz Dobrowolski <janusz@frontaccounting.eu>
Sun, 21 Dec 2014 16:32:41 +0000 (17:32 +0100)
committerJanusz Dobrowolski <janusz@frontaccounting.eu>
Sun, 21 Dec 2014 16:32:41 +0000 (17:32 +0100)
sql/en_US-new.sql

index 34b11c006b001a5a2dfdd6a8872c083355234361..3420a95c3896359a19c3f75a67fb769a830c2975 100644 (file)
@@ -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;