X-Git-Url: http://wagnertech.de/gitweb/gitweb.cgi/mfinanz.git/blobdiff_plain/028a47070f1c96c07828b9c8e802be253224df4f..f257623461bda92a232a238a322f207b8964faab:/sql/lx-office.sql diff --git a/sql/lx-office.sql b/sql/lx-office.sql index 240803396..ca5b1d35e 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 @@ -397,7 +397,7 @@ 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,