From 4caa9aaaceccb1327589aa296e032ac50cdcb1b2 Mon Sep 17 00:00:00 2001 From: Jan Schneider Date: Thu, 12 Nov 2009 14:43:16 +0100 Subject: [PATCH] MFB: Add upgrade script for PostgreSQL. --- .../2006-08-20_fix_recur_int_fields.pgsql.sql | 20 ++++++++++++++++++++ 1 file changed, 20 insertions(+) create mode 100644 kronolith/scripts/upgrades/2006-08-20_fix_recur_int_fields.pgsql.sql diff --git a/kronolith/scripts/upgrades/2006-08-20_fix_recur_int_fields.pgsql.sql b/kronolith/scripts/upgrades/2006-08-20_fix_recur_int_fields.pgsql.sql new file mode 100644 index 000000000..4845abc46 --- /dev/null +++ b/kronolith/scripts/upgrades/2006-08-20_fix_recur_int_fields.pgsql.sql @@ -0,0 +1,20 @@ +BEGIN; +ALTER TABLE kronolith_events ADD COLUMN event_recurtype_new SMALLINT DEFAULT 0; +UPDATE kronolith_events SET event_recurtype_new = CAST (event_recurtype AS SMALLINT); +ALTER TABLE kronolith_events DROP event_recurtype; +ALTER TABLE kronolith_events RENAME event_recurtype_new TO event_recurtype; +COMMIT; + +BEGIN; +ALTER TABLE kronolith_events ADD COLUMN event_recurinterval_new SMALLINT; +UPDATE kronolith_events SET event_recurinterval_new = CAST (event_recurinterval AS SMALLINT); +ALTER TABLE kronolith_events DROP event_recurinterval; +ALTER TABLE kronolith_events RENAME event_recurinterval_new TO event_recurinterval; +COMMIT; + +BEGIN; +ALTER TABLE kronolith_events ADD COLUMN event_recurdays_new SMALLINT; +UPDATE kronolith_events SET event_recurdays_new = CAST (event_recurdays AS SMALLINT); +ALTER TABLE kronolith_events DROP event_recurdays; +ALTER TABLE kronolith_events RENAME event_recurdays_new TO event_recurdays; +COMMIT; -- 2.11.0