Added debtor_trans key on order_ field.

diff --git a/sql/en_US-demo.sql b/sql/en_US-demo.sql
index 9f0d63397383dd419454e942bd8bc3751b62e0d1..abd195d707ea50a3d8d947856133e42ef1145cff 100644 (file)
--- a/sql/en_US-demo.sql
+++ b/sql/en_US-demo.sql
@@ -694,7 +694,8 @@ CREATE TABLE IF NOT EXISTS `0_debtor_trans` (
   `payment_terms` int(11) default NULL,
   PRIMARY KEY  (`type`,`trans_no`),
   KEY `debtor_no` (`debtor_no`,`branch_code`),
-  KEY `tran_date` (`tran_date`)
+  KEY `tran_date` (`tran_date`),
+  KEY `order_` (`order_`)
 ) ENGINE=InnoDB;
 
 --

diff --git a/sql/en_US-new.sql b/sql/en_US-new.sql
index c5115a40fbc0b2d49d9109059dd49c9319af5beb..dd43d66f0a045675e2b663bc4a653cb1102f68ab 100644 (file)
--- a/sql/en_US-new.sql
+++ b/sql/en_US-new.sql
@@ -653,7 +653,8 @@ CREATE TABLE IF NOT EXISTS `0_debtor_trans` (
   `payment_terms` int(11) default NULL,
   PRIMARY KEY  (`type`,`trans_no`),
   KEY `debtor_no` (`debtor_no`,`branch_code`),
-  KEY `tran_date` (`tran_date`)
+  KEY `tran_date` (`tran_date`),
+  KEY `order_` (`order_`)
 ) ENGINE=InnoDB;
 
 --