From f32cdb41522af0536afc5ae308a9c5e4ddc96189 Mon Sep 17 00:00:00 2001 From: Jan Schneider Date: Fri, 25 Sep 2009 17:19:59 +0200 Subject: [PATCH] Add upgrade script (Bug #8584). --- turba/docs/UPGRADING | 17 ++++++++++++++++- turba/scripts/upgrades/2.3_to_2.3.3.pgsql.sql | 4 ++++ 2 files changed, 20 insertions(+), 1 deletion(-) create mode 100644 turba/scripts/upgrades/2.3_to_2.3.3.pgsql.sql diff --git a/turba/docs/UPGRADING b/turba/docs/UPGRADING index 776a7fd33..6d356897a 100644 --- a/turba/docs/UPGRADING +++ b/turba/docs/UPGRADING @@ -10,6 +10,21 @@ your existing data before running any of the steps described below. You can't use the updated data with your old Turba version anymore. +Upgrading Turba from 2.3.x to 2.3.3 +=================================== + + +Share Table Updates +------------------- + +The SQL script for PostgreSQL used a wrong column type for the share +tables. If you have many users or shares, this could cause an overrun at some +point. Execute the provided SQL script to update your database if you are +using the native SQL share driver on PostgresSQL:: + + psql < scripts/upgrades/2.3_to_2.3.3.pgsql.sql + + Upgrading Turba from 2.2.1 to 2.3 ================================= @@ -19,7 +34,7 @@ Share Table Updates Some fields in the SQL share driver tables have been changed. Execute the provided SQL script to update your database if you are using the native SQL -share driver. +share driver:: mysql --user=root --password= < scripts/upgrades/2.2.1_to_2.3.sql diff --git a/turba/scripts/upgrades/2.3_to_2.3.3.pgsql.sql b/turba/scripts/upgrades/2.3_to_2.3.3.pgsql.sql new file mode 100644 index 000000000..bbbb3683c --- /dev/null +++ b/turba/scripts/upgrades/2.3_to_2.3.3.pgsql.sql @@ -0,0 +1,4 @@ +ALTER TABLE turba_shares_users ALTER share_id TYPE integer; +ALTER TABLE turba_shares_groups ALTER share_id TYPE integer; +ALTER TABLE turba_shares ALTER share_id TYPE integer; + -- 2.11.0