From 17fae63b1c50234c9ad84f7506ba18418b82d164 Mon Sep 17 00:00:00 2001 From: Jonas Smedegaard Date: Tue, 18 Apr 2006 02:32:23 +0000 Subject: Add pre-1.2 fixup script. --- horde/turba2/1.x_to_1.2.sql | 18 ++++++++++++++++++ 1 file changed, 18 insertions(+) create mode 100644 horde/turba2/1.x_to_1.2.sql 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= < 1.x_to_1.2.sql +-- +-- Or, for PostgreSQL: +-- +-- $ psql -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); -- cgit v1.2.3