Mercurial > hg > rc1

comparison plugins/calendar/drivers/kolab/SQL/oracle.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 Aleksander Machniak
5 * @licence GNU AGPL
6 **/
7
8 CREATE TABLE "kolab_alarms" (
9 "alarm_id" varchar(255) NOT NULL PRIMARY KEY,
10 "user_id" integer NOT NULL
11 REFERENCES "users" ("user_id") ON DELETE CASCADE,
12 "notifyat" timestamp DEFAULT NULL,
13 "dismissed" smallint DEFAULT 0 NOT NULL
14 );
15
16 CREATE INDEX "kolab_alarms_user_id_idx" ON "kolab_alarms" ("user_id");
17
18
19 CREATE TABLE "itipinvitations" (
20 "token" varchar(64) NOT NULL PRIMARY KEY,
21 "event_uid" varchar(255) NOT NULL,
22 "user_id" integer NOT NULL
23 REFERENCES "users" ("user_id") ON DELETE CASCADE,
24 "event" long NOT NULL,
25 "expires" timestamp DEFAULT NULL,
26 "cancelled" smallint DEFAULT 0 NOT NULL
27 );
28
29 CREATE INDEX "itipinvitations_user_id_idx" ON "itipinvitations" ("user_id", "event_uid");
30
31 INSERT INTO "system" ("name", "value") VALUES ('calendar-kolab-version', '2014041700');