From c5e31a521b8d224a70aef1ff1c35a28b73f0e226 Mon Sep 17 00:00:00 2001 From: Moritz Bunkus Date: Wed, 29 Nov 2006 08:35:59 +0000 Subject: [PATCH] Einheiten duerfen 20 Zeichen lang sein. --- sql/Pg-upgrade/Pg-upgrade-2.2.0.24-2.2.0.25.sql | 4 ++++ 1 file changed, 4 insertions(+) create mode 100644 sql/Pg-upgrade/Pg-upgrade-2.2.0.24-2.2.0.25.sql diff --git a/sql/Pg-upgrade/Pg-upgrade-2.2.0.24-2.2.0.25.sql b/sql/Pg-upgrade/Pg-upgrade-2.2.0.24-2.2.0.25.sql new file mode 100644 index 000000000..daaebc366 --- /dev/null +++ b/sql/Pg-upgrade/Pg-upgrade-2.2.0.24-2.2.0.25.sql @@ -0,0 +1,4 @@ +ALTER TABLE rmaitems ADD COLUMN tmp varchar(20); +UPDATE rmaitems SET tmp = unit; +ALTER TABLE rmaitems DROP COLUMN unit; +ALTER TABLE rmaitems RENAME tmp TO unit; -- 2.20.1