-
Notifications
You must be signed in to change notification settings - Fork 1.3k
/
full-db-v3.sqlite.sql
63 lines (59 loc) · 2.44 KB
/
full-db-v3.sqlite.sql
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
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
CREATE TABLE IF NOT EXISTS `owners` (
`id` INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
`name` VARCHAR(25) NOT NULL,
`url` VARCHAR(255) NOT NULL,
`revision` INTEGER DEFAULT '1',
`last_updated` DATETIME DEFAULT NULL,
`summary` VARCHAR(255) NOT NULL DEFAULT '',
`html` INTEGER DEFAULT '0',
`css` INTEGER DEFAULT '0',
`javascript` INTEGER DEFAULT '0',
`archive` INTEGER DEFAULT '0',
`visibility` VARCHAR(255) DEFAULT 'public' NOT NULL
);
CREATE TABLE IF NOT EXISTS `ownership` (
`name` VARCHAR(50) PRIMARY KEY NOT NULL,
`key` VARCHAR(255) NOT NULL,
`email` VARCHAR(255) NOT NULL DEFAULT '',
`api_key` VARCHAR(255) NULL,
`github_token` VARCHAR(255) NULL,
`github_id` INTEGER NULL,
`last_login` DATETIME NOT NULL,
`created` DATETIME NOT NULL,
`updated` DATETIME NOT NULL
);
CREATE TABLE IF NOT EXISTS `sandbox` (
`id` INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
`html` TEXT NOT NULL DEFAULT "",
`css` TEXT NOT NULL DEFAULT "",
`javascript` TEXT NOT NULL DEFAULT "",
`created` DATETIME DEFAULT NULL,
`last_viewed` DATETIME DEFAULT NULL,
`url` VARCHAR(255) DEFAULT NULL,
`active` VARCHAR(1) DEFAULT 'y',
`reported` DATETIME DEFAULT NULL,
`streaming` VARCHAR(1) DEFAULT 'n',
`streaming_key` VARCHAR(32),
`streaming_read_key` VARCHAR(32),
`active_tab` VARCHAR(10),
`active_cursor` INTEGER,
`revision` INTEGER DEFAULT '1',
`settings` TEXT NOT NULL DEFAULT ''
);
CREATE TABLE IF NOT EXISTS `forgot_tokens` (
`owner_name` VARCHAR(255) NOT NULL,
`token` VARCHAR(255) NOT NULL,
`expires` DATETIME NOT NULL,
`created` DATETIME NOT NULL
);
CREATE INDEX IF NOT EXISTS "sandbox_viewed" ON "sandbox" (`last_viewed`);
CREATE INDEX IF NOT EXISTS "sandbox_url" ON "sandbox" (`url`);
CREATE INDEX IF NOT EXISTS "sandbox_streaming_key" ON "sandbox" (`streaming_key`);
CREATE INDEX IF NOT EXISTS "sandbox_spam" ON "sandbox" (`created`,`last_viewed`);
CREATE INDEX IF NOT EXISTS "sandbox_revision" ON "sandbox" (`url`,`revision`);
CREATE INDEX IF NOT EXISTS "ownership_name_key" ON "ownership" (`name`,`key`);
CREATE INDEX IF NOT EXISTS "ownership_api_key" ON "ownership" (`api_key`);
CREATE INDEX IF NOT EXISTS "owners_name_url" ON "owners" (`name`,`url`,`revision`);
CREATE INDEX IF NOT EXISTS "index_owners_last_updated" ON "owners" (`name`, `last_updated`);
CREATE INDEX IF NOT EXISTS "index_expires" ON "forgot_tokens" (`expires`);
CREATE INDEX IF NOT EXISTS "index_token_expires" ON "forgot_tokens" (`token`,`created`,`expires`);