Add pre-1.2 fixup script.

1 files changed, 18 insertions, 0 deletions

diff --git a/horde/turba2/1.x_to_1.2.sql b/horde/turba2/1.x_to_1.2.sql
new file mode 100644
index 0000000..e10b4a3
--- /dev/null
+++ b/horde/turba2/1.x_to_1.2.sql
@@ -0,0 +1,18 @@
+-- You can simply execute this file in your database.
+--
+-- For MySQL run:
+--
+-- $ mysql --user=root --password=<MySQL-root-password> <db name> < 1.x_to_1.2.sql
+--
+-- Or, for PostgreSQL:
+--
+-- $ psql <db name> -f 1.x_to_1.2.sql
+
+
+ALTER TABLE turba_objects ADD COLUMN object_type VARCHAR(255) NOT NULL DEFAULT 'Object';
+ALTER TABLE turba_objects ADD COLUMN object_members BLOB;
+ALTER TABLE turba_objects CHANGE object_homeAddress object_homeaddress VARCHAR(255);
+ALTER TABLE turba_objects CHANGE object_workAddress object_workaddress VARCHAR(255);
+ALTER TABLE turba_objects CHANGE object_homePhone object_homephone VARCHAR(25);
+ALTER TABLE turba_objects CHANGE object_workPhone object_workphone VARCHAR(25);
+ALTER TABLE turba_objects CHANGE object_cellPhone object_cellphone VARCHAR(25);