X-Git-Url: http://wagnertech.de/gitweb/gitweb.cgi/mfinanz.git/blobdiff_plain/b3721e4e65d62ea30b68b00ac77b4495b1f17337..b38bf0551f996051e7c34946fb4efaee68663fbb:/sql/lx-office.sql diff --git a/sql/lx-office.sql b/sql/lx-office.sql index 9caa7bd04..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, @@ -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 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,