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
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
|
-- $Horde: kronolith/scripts/sql/kronolith.oci8.sql,v 1.4.2.4 2006/08/21 06:03:33 selsky Exp $
CREATE TABLE kronolith_events (
event_id VARCHAR2(32) NOT NULL,
event_uid VARCHAR2(255) NOT NULL,
calendar_id VARCHAR2(255) NOT NULL,
event_creator_id VARCHAR2(255) NOT NULL,
event_description VARCHAR2(4000),
event_location VARCHAR2(4000),
event_status INT DEFAULT 0,
event_attendees VARCHAR2(4000),
event_keywords VARCHAR2(4000),
event_exceptions VARCHAR2(4000),
event_title VARCHAR2(255),
event_category VARCHAR2(80),
event_recurtype INT DEFAULT 0,
event_recurinterval INT,
event_recurdays INT,
event_recurenddate DATE,
event_start DATE,
event_end DATE,
event_alarm INT DEFAULT 0,
event_modified INT NOT NULL,
--
PRIMARY KEY (event_id)
);
CREATE INDEX kronolith_calendar_idx ON kronolith_events (calendar_id);
CREATE INDEX kronolith_uid_idx ON kronolith_events (event_uid);
GRANT SELECT, INSERT, UPDATE, DELETE ON kronolith_events TO horde;
CREATE TABLE kronolith_storage (
vfb_owner VARCHAR2(255) DEFAULT NULL,
vfb_email VARCHAR2(255) DEFAULT '' NOT NULL,
vfb_serialized VARCHAR2(4000) NOT NULL
);
CREATE INDEX kronolith_vfb_owner_idx ON kronolith_storage (vfb_owner);
CREATE INDEX kronolith_vfb_email_idx ON kronolith_storage (vfb_email);
GRANT SELECT, INSERT, UPDATE, DELETE ON kronolith_storage TO horde;
|
