X-Git-Url: http://wagnertech.de/gitweb/gitweb.cgi/mfinanz.git/blobdiff_plain/195883fdfd3b10f329036767f027baa6e7c402b9..b38bf0551f996051e7c34946fb4efaee68663fbb:/sql/lx-office.sql

diff --git a/sql/lx-office.sql b/sql/lx-office.sql
index 4b1606c7f..3e0befb75 100644
--- a/sql/lx-office.sql
+++ b/sql/lx-office.sql
@@ -115,7 +115,7 @@ CREATE TABLE "defaults" (
         "itime" timestamp DEFAULT now(),
         "mtime" timestamp
 );
-INSERT INTO defaults (version,audittrail) VALUES ('2.1.2', 't');
+INSERT INTO defaults (version,audittrail) VALUES ('2.2.0', 't');
 
 CREATE TABLE audittrail (
         "trans_id" int,
@@ -161,7 +161,10 @@ CREATE TABLE "invoice" (
 	"serialnumber" text,
         "itime" timestamp DEFAULT now(),
         "mtime" timestamp,
-        "pricegroup_id" integer
+        "pricegroup_id" integer,
+        "ordnumber" text,
+        "transdate" text,
+        "cusordnumber" text
 );
 
 CREATE TABLE "vendor" (
@@ -240,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
@@ -282,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,
@@ -394,10 +398,13 @@ CREATE TABLE "orderitems" (
 	"reqdate" date,
 	"ship" real,
 	"serialnumber" text,
-	"id" integer DEFAULT nextval('orderitemsid'::text) PRIMARY KEY,
+	"id" integer DEFAULT nextval('orderitemsid'::text),
         "itime" timestamp DEFAULT now(),
         "mtime" timestamp,
-        "pricegroup_id" integer
+        "pricegroup_id" integer,
+        "ordnumber" text,
+        "transdate" text,
+        "cusordnumber" text
 );
 
 CREATE TABLE "exchangerate" (
@@ -447,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
@@ -481,7 +488,7 @@ CREATE TABLE "status" (
 
 CREATE SEQUENCE "invoiceid" start 1 increment 1 maxvalue 9223372036854775807 minvalue 1 cache 1;
 
-CREATE SEQUENCE "orderitemsid" start 1 increment 1 maxvalue 100000 minvalue 1 cache 1 cycle;
+CREATE SEQUENCE "orderitemsid" start 1 increment 1 maxvalue 9223372036854775807 minvalue 1 cache 1 cycle;
 
 CREATE TABLE "warehouse" (
 	"id" integer DEFAULT nextval('id'::text) PRIMARY KEY,