X-Git-Url: http://wagnertech.de/git?a=blobdiff_plain;f=sql%2Flx-office.sql;h=6807f217fa72244257c9d8d33c46448d67a2ec41;hb=0e50c3d80f4705a01cea9d664e0edaa2f8d0cdfa;hp=3e0befb75e92359ae8738d4662633628438125f3;hpb=f772018b9e88abb60a63bdc680ef086a45c792ff;p=kivitendo-erp.git 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),