From 2071984a9447c94fdf42d91f7b27e87d535a3a37 Mon Sep 17 00:00:00 2001 From: Holger Lindemann Date: Fri, 24 Nov 2006 16:43:33 +0000 Subject: [PATCH] Spalte id in shipto_id umbenannt --- sql/Pg-upgrade/Pg-upgrade-2.2.0.15-2.2.0.16.sql | 8 ++++---- 1 file changed, 4 insertions(+), 4 deletions(-) diff --git a/sql/Pg-upgrade/Pg-upgrade-2.2.0.15-2.2.0.16.sql b/sql/Pg-upgrade/Pg-upgrade-2.2.0.15-2.2.0.16.sql index 5494886ce..296976900 100644 --- a/sql/Pg-upgrade/Pg-upgrade-2.2.0.15-2.2.0.16.sql +++ b/sql/Pg-upgrade/Pg-upgrade-2.2.0.15-2.2.0.16.sql @@ -6,9 +6,9 @@ CREATE TABLE "adr" ( ALTER TABLE parts add column adr_id integer; -alter table shipto add column id integer; -alter table shipto alter column id set default nextval('id'::text); -update shipto set id=nextval('id'::text); +alter table shipto add column shipto_id integer; +alter table shipto alter column shipto_id set default nextval('id'::text); +update shipto set shipto_id=nextval('id'::text); alter table oe add column shipto_id integer; -alter table ar add column shipto_id integer; \ No newline at end of file +alter table ar add column shipto_id integer; -- 2.20.1