X-Git-Url: http://wagnertech.de/gitweb/gitweb.cgi/mfinanz.git/blobdiff_plain/614534b99bf5ae2d63e5e2af5f15c1aca84f68d5..b3721e4e65d62ea30b68b00ac77b4495b1f17337:/sql/lx-office.sql

diff --git a/sql/lx-office.sql b/sql/lx-office.sql
index 439b119bb..9caa7bd04 100644
--- a/sql/lx-office.sql
+++ b/sql/lx-office.sql
@@ -243,7 +243,7 @@ CREATE TABLE "customer" (
         "obsolete" boolean DEFAULT 'f',
         "ustid" varchar(12),
         "username" varchar(50),
-        "user_password" varchar(12),
+        "user_password" text,
         "salesman_id" integer,
         "c_vendor_id" text,
         "klass" integer DEFAULT 0
@@ -285,6 +285,7 @@ CREATE TABLE "ar" (
 	"paid" numeric (15,5),
 	"datepaid" date,
 	"duedate" date,
+	"deliverydate" date,
 	"invoice" boolean DEFAULT 'f',
 	"shippingpoint" text,
 	"terms" smallint DEFAULT 0,
@@ -453,7 +454,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