X-Git-Url: http://wagnertech.de/gitweb/gitweb.cgi/mfinanz.git/blobdiff_plain/f772018b9e88abb60a63bdc680ef086a45c792ff..b08a61d7381fd830fdb7fd0c343ce1dcf60776bf:/sql/lx-office.sql diff --git a/sql/lx-office.sql b/sql/lx-office.sql index 3e0befb75..6807f217f 100644 --- a/sql/lx-office.sql +++ b/sql/lx-office.sql @@ -488,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 9223372036854775807 minvalue 1 cache 1 cycle; +CREATE SEQUENCE "orderitemsid" start 1 increment 1 maxvalue 100000 minvalue 1 cache 1 cycle; CREATE TABLE "warehouse" ( "id" integer DEFAULT nextval('id'::text) PRIMARY KEY, @@ -534,6 +534,7 @@ CREATE TABLE "business" ( "mtime" timestamp ); + CREATE TABLE "sic" ( "code" text, "sictype" character(1),