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
|
CREATE TABLE IF NOT EXISTS "tags"(
"id" INTEGER PRIMARY KEY,
"tag" TEXT UNIQUE
);
CREATE TABLE IF NOT EXISTS "pomodoro"(
"tag_id" INTEGER NOT NULL,
"start_date" TEXT NOT NULL,
"start_time" TEXT NOT NULL,
"duration" INTEGER NOT NULL,
"description" TEXT,
FOREIGN KEY("tag_id") REFERENCES "tags"("id")
);
CREATE TABLE IF NOT EXISTS "statistics"(
"name" TEXT NOT NULL,
"start_date" TEXT NOT NULL,
"start_time" TEXT,
"execution_time" INTEGER NOT NULL
);
CREATE TABLE IF NOT EXISTS "fake_table" (
"id" INTEGER NOT NULL UNIQUE,
"name" TEXT NOT NULL UNIQUE,
"attribute1" TEXT,
"attribute2" TEXT,
"rank" INTEGER NOT NULL,
PRIMARY KEY("id")
);
|
