Removed redundant indexes on cust_branch & supp_trans tables

[fa-stable.git] / sql / en_US-new.sql

diff --git a/sql/en_US-new.sql b/sql/en_US-new.sql
index 1b9526b891afc815ac08f968da0985ad23522389..34b11c006b001a5a2dfdd6a8872c083355234361 100644 (file)
--- a/sql/en_US-new.sql
+++ b/sql/en_US-new.sql
@@ -521,8 +521,8 @@ CREATE TABLE IF NOT EXISTS `0_currencies` (
 
 INSERT INTO `0_currencies` VALUES('US Dollars', 'USD', '$', 'United States', 'Cents', 1, 0);
 INSERT INTO `0_currencies` VALUES('CA Dollars', 'CAD', '$', 'Canada', 'Cents', 1, 0);
-INSERT INTO `0_currencies` VALUES('Euro', 'EUR', '\80', 'Europe', 'Cents', 1, 0);
-INSERT INTO `0_currencies` VALUES('Pounds', 'GBP', '£', 'England', 'Pence', 1, 0);
+INSERT INTO `0_currencies` VALUES('Euro', 'EUR', '?', 'Europe', 'Cents', 1, 0);
+INSERT INTO `0_currencies` VALUES('Pounds', 'GBP', '?', 'England', 'Pence', 1, 0);
 
 -- --------------------------------------------------------
 
@@ -578,7 +578,6 @@ 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 ;
@@ -1743,8 +1742,7 @@ 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`),
-  KEY `SupplierID_2` (`supplier_id`,`supp_reference`),
+  KEY `supplier_id` (`supplier_id`,`supp_reference`),
   KEY `type` (`type`),
   KEY `tran_date` (`tran_date`)
 ) ENGINE=InnoDB;