[Frontaccounting-cvs_updates] /hgroot/frontaccounting/frontaccounting: 0001161: Fix index on s...

[FrontAccounting <fro...@us...>]

details:   http://frontaccounting.hg.sourceforge.net:8000/hgroot/frontaccounting/frontaccounting/hgroot/frontaccounting/frontaccounting/rev/6ea4a445c0dc
changeset: 2974:6ea4a445c0dc
user:      Joe Hunt <joe...@gm...>
date:      Tue Feb 14 10:36:26 2012 +0100
description:
0001161: Fix index on stk_code in sales_order_details and item_code in purch_order_details.

diffstat:

 sql/alter2.4.sql   |  2 ++
 sql/en_US-demo.sql |  6 ++++--
 sql/en_US-new.sql  |  6 ++++--
 3 files changed, 10 insertions(+), 4 deletions(-)

diffs (55 lines):

diff -r a1109f259d78 -r 6ea4a445c0dc sql/alter2.4.sql
--- a/sql/alter2.4.sql	Tue Feb 14 10:17:57 2012 +0100
+++ b/sql/alter2.4.sql	Tue Feb 14 10:36:26 2012 +0100
@@ -34,3 +34,5 @@
 		WHERE tax_shipping=1 AND tgi.tax_group_id=0_tax_groups.id AND tgi.tax_type_id=0_tax_types.id);
 ALTER TABLE `0_tax_groups` DROP COLUMN `tax_shipping`;
 ALTER TABLE `0_tax_group_items` DROP COLUMN `rate`;
+ALTER TABLE 0_sales_order_details ADD KEY `stkcode` (`stk_code`);
+ALTER TABLE 0_purch_order_details ADD KEY `itemcode` (`item_code`);
diff -r a1109f259d78 -r 6ea4a445c0dc sql/en_US-demo.sql
--- a/sql/en_US-demo.sql	Tue Feb 14 10:17:57 2012 +0100
+++ b/sql/en_US-demo.sql	Tue Feb 14 10:36:26 2012 +0100
@@ -1366,7 +1366,8 @@
   `quantity_ordered` double NOT NULL default '0',
   `quantity_received` double NOT NULL default '0',
   PRIMARY KEY  (`po_detail_item`),
-  KEY `order` (`order_no`,`po_detail_item`)
+  KEY `order` (`order_no`,`po_detail_item`),
+  KEY `itemcode` (`item_code`)
 ) ENGINE=InnoDB  AUTO_INCREMENT=6 ;
 
 --
@@ -1571,7 +1572,8 @@
   `quantity` double NOT NULL default '0',
   `discount_percent` double NOT NULL default '0',
   PRIMARY KEY  (`id`),
-  KEY `sorder` (`trans_type`,`order_no`)
+  KEY `sorder` (`trans_type`,`order_no`),
+  KEY `stkcode` (`stk_code`)
 ) ENGINE=InnoDB  AUTO_INCREMENT=6 ;
 
 --
diff -r a1109f259d78 -r 6ea4a445c0dc sql/en_US-new.sql
--- a/sql/en_US-new.sql	Tue Feb 14 10:17:57 2012 +0100
+++ b/sql/en_US-new.sql	Tue Feb 14 10:36:26 2012 +0100
@@ -1195,7 +1195,8 @@
   `quantity_ordered` double NOT NULL default '0',
   `quantity_received` double NOT NULL default '0',
   PRIMARY KEY  (`po_detail_item`),
-  KEY `order` (`order_no`,`po_detail_item`)
+  KEY `order` (`order_no`,`po_detail_item`),
+  KEY `itemcode` (`item_code`)
 ) ENGINE=InnoDB AUTO_INCREMENT=1 ;
 
 --
@@ -1388,7 +1389,8 @@
   `quantity` double NOT NULL default '0',
   `discount_percent` double NOT NULL default '0',
   PRIMARY KEY  (`id`),
-  KEY `sorder` (`trans_type`,`order_no`)
+  KEY `sorder` (`trans_type`,`order_no`),
+  KEY `stkcode` (`stk_code`)
 ) ENGINE=InnoDB AUTO_INCREMENT=1 ;
 
 --