blob: 467e4811f8201d1d7c2cfe8d5f8bbf3ce1d522cc (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
|
CREATE TABLE IF NOT EXISTS "events" (
"id" TEXT PRIMARY KEY, /* UUID */
"date" TEXT NOT NULL, /* DATE */
"start" TEXT NULL, /* TIME */
"end" TEXT NULL, /* TIME */
"name" TEXT NOT NULL,
"repetition" TEXT NULL, /* JSON */
"created" TEXT NOT NULL, /* DATETIME */
"updated" TEXT NOT NULL /* DATETIME */
);
CREATE INDEX events_date_index on events (date);
CREATE INDEX events_repetition_index on events (repetition);
|
