From 53de849f82c8d29e76982e24099cd8b5607f8ba0 Mon Sep 17 00:00:00 2001 From: Janusz Dobrowolski Date: Sun, 27 Jun 2010 13:03:25 +0000 Subject: [PATCH] Added key for debtor_trans_details.src_id --- 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 30338b72..54da3fc8 100644 --- a/sql/en_US-demo.sql +++ b/sql/en_US-demo.sql @@ -731,7 +731,8 @@ CREATE TABLE IF NOT EXISTS `0_debtor_trans_details` ( `qty_done` double NOT NULL default '0', `src_id` int(11) NOT NULL, PRIMARY KEY (`id`), - KEY `Transaction` (`debtor_trans_type`,`debtor_trans_no`) + KEY `Transaction` (`debtor_trans_type`,`debtor_trans_no`), + KEY (`src_id`) ) TYPE=InnoDB AUTO_INCREMENT=9 ; -- diff --git a/sql/en_US-new.sql b/sql/en_US-new.sql index 9f9a4f01..ec72638c 100644 --- a/sql/en_US-new.sql +++ b/sql/en_US-new.sql @@ -682,7 +682,8 @@ CREATE TABLE IF NOT EXISTS `0_debtor_trans_details` ( `qty_done` double NOT NULL default '0', `src_id` int(11) NOT NULL, PRIMARY KEY (`id`), - KEY `Transaction` (`debtor_trans_type`,`debtor_trans_no`) + KEY `Transaction` (`debtor_trans_type`,`debtor_trans_no`), + KEY (`src_id`) ) TYPE=InnoDB AUTO_INCREMENT=1 ; -- -- 2.30.2