X-Git-Url: http://wagnertech.de/git?a=blobdiff_plain;f=sql%2Flx-office.sql;h=76267264b6042be3d0117ace01ac65c7dc5001b2;hb=b8008d65d75998d30cfb038de5f00892d39fd9c3;hp=ca5b1d35e52c605fb279f7cd58d95bc23e3b2ca2;hpb=6349623b40ef4b94a6905d96b3b0fa8daaefd178;p=kivitendo-erp.git

diff --git a/sql/lx-office.sql b/sql/lx-office.sql
index ca5b1d35e..76267264b 100644
--- a/sql/lx-office.sql
+++ b/sql/lx-office.sql
@@ -453,7 +453,7 @@ CREATE TABLE "shipto" (
 
 CREATE TABLE "project" (
 	"id" integer DEFAULT nextval('id'::text) PRIMARY KEY,
-	"projectnumber" text,
+	"projectnumber" text UNIQUE,
 	"description" text,
         "itime" timestamp DEFAULT now(),
         "mtime" timestamp