|
3
|
1 /**
|
|
|
2 * Roundcube Calendar Kolab backend
|
|
|
3 *
|
|
|
4 * @author Sergey Sidlyarenko
|
|
|
5 * @licence GNU AGPL
|
|
|
6 **/
|
|
|
7
|
|
|
8 CREATE TABLE IF NOT EXISTS kolab_alarms (
|
|
|
9 alarm_id character varying(255) NOT NULL,
|
|
|
10 user_id integer NOT NULL
|
|
|
11 REFERENCES users (user_id) ON DELETE CASCADE ON UPDATE CASCADE,
|
|
|
12 notifyat timestamp without time zone DEFAULT NULL,
|
|
|
13 dismissed smallint NOT NULL DEFAULT 0,
|
|
|
14 PRIMARY KEY(alarm_id)
|
|
|
15 );
|
|
|
16
|
|
|
17 CREATE INDEX kolab_alarms_user_id_idx ON kolab_alarms (user_id);
|
|
|
18
|
|
|
19 CREATE TABLE IF NOT EXISTS itipinvitations (
|
|
|
20 token character varying(64) NOT NULL,
|
|
|
21 event_uid character varying(255) NOT NULL,
|
|
|
22 user_id integer NOT NULL
|
|
|
23 REFERENCES users (user_id) ON DELETE CASCADE ON UPDATE CASCADE,
|
|
|
24 event text NOT NULL,
|
|
|
25 expires timestamp without time zone DEFAULT NULL,
|
|
|
26 cancelled smallint NOT NULL DEFAULT 0,
|
|
|
27 PRIMARY KEY(token)
|
|
|
28 );
|
|
|
29
|
|
|
30 CREATE INDEX itipinvitations_user_id_event_uid_idx ON itipinvitations (user_id, event_uid);
|
|
|
31
|
|
|
32 INSERT INTO system (name, value) VALUES ('calendar-kolab-version', '2014041700');
|
