X-Git-Url: http://wagnertech.de/git?a=blobdiff_plain;f=sql%2FPg-upgrade-2.1.1-2.1.2.sql;fp=sql%2FPg-upgrade-2.1.1-2.1.2.sql;h=5887b357ccf8b147f5310eefe7435371ce47cf26;hb=921adf5b31fe273406ef57fc411aa680be4544e7;hp=8a1b97a89e58c9038cfcb1fb37b8170ef5d2a506;hpb=b8ceafbfb9d18b4edcb527114bdab98202e2178d;p=kivitendo-erp.git

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 8a1b97a89..5887b357c 100644
--- a/sql/Pg-upgrade-2.1.1-2.1.2.sql
+++ b/sql/Pg-upgrade-2.1.1-2.1.2.sql
@@ -253,4 +253,8 @@ alter table invoice add column transdate text;
 alter table invoice add column cusordnumber text;
 --
 
+--
+-- add unqiue constraint to project
+ALTER TABLE project ADD constraint project_projectnumber_key UNIQUE(projectnumber);
+
 update defaults set version = '2.1.2';