Bugfix 165: Projektnummern muessen jetzt eindeutig sein.

[kivitendo-erp.git] / sql / Pg-upgrade-2.1.1-2.1.2.sql

diff --git a/sql/Pg-upgrade-2.1.1-2.1.2.sql b/sql/Pg-upgrade-2.1.1-2.1.2.sql
index 0f6d7f4..53b7fe0 100644 (file)
--- a/sql/Pg-upgrade-2.1.1-2.1.2.sql
+++ b/sql/Pg-upgrade-2.1.1-2.1.2.sql
@@ -320,4 +320,6 @@ INSERT INTO tax VALUES ((SELECT id FROM chart WHERE accno = '1572'),'0.16','1573
 
 update defaults set version = '2.1.2';
 
-
+--
+-- add unqiue constraint to project
+ALTER TABLE project ADD constraint project_projectnumber_key UNIQUE(projectnumber);