From 0e7fc8b62377662daec8a81746bef2c3a599463e Mon Sep 17 00:00:00 2001 From: =?utf8?q?Stephan=20K=C3=B6hler?= Date: Mon, 20 Feb 2006 18:23:48 +0000 Subject: [PATCH] Table-Fehler im Pg-Upgrade-Skript beseitigt und Skript umgenannt, hatte den falschen Namen, was ebenfalls zu Fehlern fuehrte (Bugfix 288,290,296,297) --- ...{Pg-upgrade-2.1.2-2.2.0.sql => Pg-upgrade-2.1.1-2.2.0.sql} | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) rename sql/{Pg-upgrade-2.1.2-2.2.0.sql => Pg-upgrade-2.1.1-2.2.0.sql} (99%) diff --git a/sql/Pg-upgrade-2.1.2-2.2.0.sql b/sql/Pg-upgrade-2.1.1-2.2.0.sql similarity index 99% rename from sql/Pg-upgrade-2.1.2-2.2.0.sql rename to sql/Pg-upgrade-2.1.1-2.2.0.sql index e6928bc73..a0a970cd4 100644 --- a/sql/Pg-upgrade-2.1.2-2.2.0.sql +++ b/sql/Pg-upgrade-2.1.1-2.2.0.sql @@ -116,10 +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'; +update 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'; +update customer set obsolete='false'; alter table customer add column ustid varchar(12); alter table vendor add column ustid varchar(12); -- 2.20.1