1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
|
-- $Horde: kronolith/scripts/upgrades/1.1_to_2.0.mysql.sql,v 1.4.2.1 2007/12/20 14:12:58 jan Exp $
--
-- You can simply execute this file in your database.
--
-- Run as:
--
-- $ mysql --user=root --password=<MySQL-root-password> <db name> < 1.1_to_2.0.mysql.sql
ALTER TABLE kronolith_events CHANGE COLUMN event_id event_id VARCHAR(32) NOT NULL;
ALTER TABLE kronolith_events CHANGE COLUMN event_title event_title VARCHAR(255);
ALTER TABLE kronolith_events ADD COLUMN event_uid VARCHAR(255) NOT NULL;
ALTER TABLE kronolith_events ADD COLUMN event_creator_id VARCHAR(255) NOT NULL;
ALTER TABLE kronolith_events ADD COLUMN event_status INT DEFAULT 0;
ALTER TABLE kronolith_events ADD COLUMN event_attendees TEXT;
CREATE INDEX kronolith_uid_idx ON kronolith_events (event_uid);
CREATE TABLE kronolith_storage (
vfb_owner VARCHAR(255) DEFAULT NULL,
vfb_email VARCHAR(255) DEFAULT '' NOT NULL,
vfb_serialized TEXT NOT NULL
);
CREATE INDEX kronolith_vfb_owner_idx ON kronolith_storage (vfb_owner);
CREATE INDEX kronolith_vfb_email_idx ON kronolith_storage (vfb_email);
|
