From f772018b9e88abb60a63bdc680ef086a45c792ff Mon Sep 17 00:00:00 2001 From: Moritz Bunkus Date: Tue, 11 Apr 2006 14:06:44 +0000 Subject: [PATCH] Die Sequenz "orderitemsid" sollte nicht zu frueh zu ende gehen. --- sql/Pg-upgrade/Pg-upgrade-2.2.0.1-2.2.0.2.sql | 1 + sql/lx-office.sql | 2 +- 2 files changed, 2 insertions(+), 1 deletion(-) create mode 100644 sql/Pg-upgrade/Pg-upgrade-2.2.0.1-2.2.0.2.sql diff --git a/sql/Pg-upgrade/Pg-upgrade-2.2.0.1-2.2.0.2.sql b/sql/Pg-upgrade/Pg-upgrade-2.2.0.1-2.2.0.2.sql new file mode 100644 index 000000000..19037f6b0 --- /dev/null +++ b/sql/Pg-upgrade/Pg-upgrade-2.2.0.1-2.2.0.2.sql @@ -0,0 +1 @@ +ALTER SEQUENCE orderitemsid MAXVALUE 9223372036854775807; diff --git a/sql/lx-office.sql b/sql/lx-office.sql index ffcf8ca36..3e0befb75 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 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, -- 2.20.1