X-Git-Url: https://delta.frontaccounting.com/gitweb/?a=blobdiff_plain;f=sql%2Fen_US-new.sql;h=dd43d66f0a045675e2b663bc4a653cb1102f68ab;hb=86b4fb041e5eb3963d40b55387a77198e3fd6844;hp=c5115a40fbc0b2d49d9109059dd49c9319af5beb;hpb=8ff3a9e9e88ecab8767b2bc6f06680f90743802f;p=fa-stable.git 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; --