X-Git-Url: https://delta.frontaccounting.com/gitweb/?a=blobdiff_plain;ds=sidebyside;f=sql%2Fen_US-new.sql;h=d0fabd3c08c0ad40221d410ae4c51fd47a86b8ac;hb=ab6e80ccdc767b78bbb4a4a38190f16a77747feb;hp=34b11c006b001a5a2dfdd6a8872c083355234361;hpb=84ce52944660d945698ce2c8439104824cc2b7c2;p=fa-stable.git

diff --git a/sql/en_US-new.sql b/sql/en_US-new.sql
index 34b11c00..d0fabd3c 100644
--- a/sql/en_US-new.sql
+++ b/sql/en_US-new.sql
@@ -578,6 +578,7 @@ CREATE TABLE IF NOT EXISTS `0_cust_branch` (
   `notes` tinytext NOT 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 ;
@@ -1742,7 +1743,8 @@ CREATE TABLE IF NOT EXISTS `0_supp_trans` (
   `alloc` double NOT NULL default '0',
   `tax_included` tinyint(1) NOT NULL default '0',
   PRIMARY KEY  (`type`,`trans_no`),
-  KEY `supplier_id` (`supplier_id`,`supp_reference`),
+  KEY `supplier_id` (`supplier_id`),
+  KEY `SupplierID_2` (`supplier_id`,`supp_reference`),
   KEY `type` (`type`),
   KEY `tran_date` (`tran_date`)
 ) ENGINE=InnoDB;