X-Git-Url: http://wagnertech.de/gitweb/gitweb.cgi/mfinanz.git/blobdiff_plain/041a8bb77df72193d039f511707a58eef62e31c3..ecbb5ab171fa8cc38a3575c77401782aada88945:/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,