Changed keys in debtors_master

diff --git a/CHANGELOG.txt b/CHANGELOG.txt
index e09b4252ebcba50332a5c8675b5260fe56ffdb84..59db3b0180d475edb1625fde6f9bb11628f498c9 100644 (file)
--- 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 a80a7b7e85615b08d69e3eb9f4be68a05dd4d3f8..5ff18bdfb8641da24f6ac0a380e99d5eaf1b96e6 100644 (file)
--- 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 4ebea90fafbe2633595c7ec391cfc0a0ea79eb05..ee9a6f4fbf6798b69b3ccc6a7786d0aba7f452a4 100644 (file)
--- 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 ;
 
 --