X-Git-Url: http://wagnertech.de/gitweb/gitweb.cgi/mfinanz.git/blobdiff_plain/a4330713de4346db9c62044a1219fa2c6f0f69c3..2d72b516f1fe724cff4efd8fe23c1629c98f36ac:/sql/lx-office.sql

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
