X-Git-Url: http://wagnertech.de/gitweb/gitweb.cgi/mfinanz.git/blobdiff_plain/a4330713de4346db9c62044a1219fa2c6f0f69c3..2d72b516f1fe724cff4efd8fe23c1629c98f36ac:/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 0f6d7f425..53b7fe077 100644
--- 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);