From 105d982022969831ab4e85599b38db36f07ef6c4 Mon Sep 17 00:00:00 2001 From: =?utf8?q?Stephan=20K=C3=B6hler?= Date: Sat, 26 Nov 2005 15:08:43 +0000 Subject: [PATCH] Merge von 633 aus unstable: Spalten die Primarykey werden sollen vorher auf not null gesetzt werden --- sql/Pg-upgrade-2.1.1-2.1.2.sql | 16 ++++++++++++++++ 1 file changed, 16 insertions(+) diff --git a/sql/Pg-upgrade-2.1.1-2.1.2.sql b/sql/Pg-upgrade-2.1.1-2.1.2.sql index 6cfb12be7..534a25580 100644 --- a/sql/Pg-upgrade-2.1.1-2.1.2.sql +++ b/sql/Pg-upgrade-2.1.1-2.1.2.sql @@ -152,6 +152,22 @@ alter table ar alter invnumber set NOT NULL; alter table ap alter invnumber set NOT NULL; alter table oe alter ordnumber set NOT NULL; +alter table gl alter id set NOT NULL; +alter table chart alter id set NOT NULL; +alter table parts alter id set NOT NULL; +alter table invoice alter id set NOT NULL; +alter table vendor alter id set NOT NULL; +alter table customer alter id set NOT NULL; +alter table contacts alter cp_id set NOT NULL; +alter table ar alter id set NOT NULL; +alter table ap alter id set NOT NULL; +alter table oe alter id set NOT NULL; +alter table employee alter id set NOT NULL; +alter table warehouse alter id set NOT NULL; +alter table business alter id set NOT NULL; +alter table license alter id set NOT NULL; +alter table orderitems alter id set NOT NULL; + alter table gl add primary key (id); alter table chart add primary key (id); alter table parts add primary key (id); -- 2.20.1