From aad4fa262f9fddcd093b0c50994396d967ae7067 Mon Sep 17 00:00:00 2001 From: Janusz Dobrowolski Date: Sat, 28 Dec 2013 21:04:23 +0100 Subject: [PATCH] Added debtor_trans key on order_ field. --- sql/en_US-demo.sql | 3 ++- sql/en_US-new.sql | 3 ++- 2 files changed, 4 insertions(+), 2 deletions(-) diff --git a/sql/en_US-demo.sql b/sql/en_US-demo.sql index 9f0d6339..abd195d7 100644 --- 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 c5115a40..dd43d66f 100644 --- 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; -- -- 2.30.2