Mercurial > hg > rc1

comparison plugins/calendar/drivers/kolab/SQL/postgres.initial.sql @ 3:f6fe4b6ae66a

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
calendar plugin nearly as distributed
author Charlie Root
date Sat, 13 Jan 2018 08:56:12 -0500
parents
children
comparison
equal deleted inserted replaced
2:c828b0fd4a6e 3:f6fe4b6ae66a
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');