From 0cd83d52c31b47126f2fe60d76961780d7daaecf Mon Sep 17 00:00:00 2001 From: Janusz Dobrowolski Date: Sat, 11 Sep 2010 07:01:52 +0000 Subject: [PATCH] Changed keys in debtors_master --- CHANGELOG.txt | 5 +++++ sql/en_US-demo.sql | 4 ++-- sql/en_US-new.sql | 4 ++-- 3 files changed, 9 insertions(+), 4 deletions(-) diff --git a/CHANGELOG.txt b/CHANGELOG.txt index e09b4252..59db3b01 100644 --- a/CHANGELOG.txt +++ b/CHANGELOG.txt @@ -19,6 +19,11 @@ Legend: ! -> Note $ -> Affected files +11-Sep-2010 Janusz Dobrowolski +# Uniqueness moved from name to debtor_ref key in debtors_master +$ /sql/en_US-demo.sql + /sql/en_US-new.sql + 10-Sep-2010 Joe Hunt ! Layout improvements $ /gl/inquiry/gl_account_inquiry.php diff --git a/sql/en_US-demo.sql b/sql/en_US-demo.sql index a80a7b7e..5ff18bdf 100644 --- a/sql/en_US-demo.sql +++ b/sql/en_US-demo.sql @@ -651,8 +651,8 @@ CREATE TABLE IF NOT EXISTS `0_debtors_master` ( `notes` tinytext NOT NULL, `inactive` tinyint(1) NOT NULL default '0', PRIMARY KEY (`debtor_no`), - UNIQUE KEY `name` (`name`), - KEY `debtor_ref` (`debtor_ref`) + KEY `name` (`name`), + UNIQUE KEY `debtor_ref` (`debtor_ref`) ) TYPE=MyISAM AUTO_INCREMENT=4 ; -- diff --git a/sql/en_US-new.sql b/sql/en_US-new.sql index 4ebea90f..ee9a6f4f 100644 --- a/sql/en_US-new.sql +++ b/sql/en_US-new.sql @@ -613,8 +613,8 @@ CREATE TABLE IF NOT EXISTS `0_debtors_master` ( `notes` tinytext NOT NULL, `inactive` tinyint(1) NOT NULL default '0', PRIMARY KEY (`debtor_no`), - UNIQUE KEY `name` (`name`), - KEY `debtor_ref` (`debtor_ref`) + KEY `name` (`name`), + UNIQUE KEY `debtor_ref` (`debtor_ref`) ) TYPE=MyISAM AUTO_INCREMENT=1 ; -- -- 2.30.2