From 7720cefaf25fe1470b3a993a4cc853a35b9ad92c Mon Sep 17 00:00:00 2001 From: =?utf8?q?Stephan=20K=C3=B6hler?= Date: Mon, 23 Jan 2006 14:44:47 +0000 Subject: [PATCH] Merge von 815 aus unstable: Bugfix Upgradeskript Fehler im Upgrade-Skript: Kunden wurden nicht auf nicht ungueltig gesetzt und Fehlerhaftes Constraint verhindert Anlage von table prices --- sql/Pg-upgrade-2.1.1-2.1.2.sql | 4 +++- 1 file changed, 3 insertions(+), 1 deletion(-) 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 876c6af83..8a1b97a89 100644 --- a/sql/Pg-upgrade-2.1.1-2.1.2.sql +++ b/sql/Pg-upgrade-2.1.1-2.1.2.sql @@ -116,8 +116,10 @@ alter table vendor drop column creditlimitold; --New Fields for customer and vendor alter table vendor add column obsolete boolean; alter table vendor alter column obsolete set default 'false'; +update table vendor set obsolete='false'; alter table customer add column obsolete boolean; alter table customer alter column obsolete set default 'false'; +update table customer set obsolete='false'; alter table customer add column ustid varchar(12); alter table vendor add column ustid varchar(12); @@ -222,7 +224,7 @@ CREATE TABLE "pricegroup" ( CREATE TABLE "prices" ( "parts_id" integer REFERENCES parts(id), - "pricegroup_id" integer REFERENCES pricegroup(id), + "pricegroup_id" integer, "price" numeric(15,5) ); -- 2.20.1