Commit | Line | Data |
1a1d7b64 |
1 | CREATE TABLE buckets ( |
2 | slug TEXT NOT NULL PRIMARY KEY, |
3 | name TEXT NOT NULL |
4 | ); |
5 | |
6 | CREATE TABLE announcements ( |
7 | id INTEGER NOT NULL PRIMARY KEY, |
8 | made_at DATETIME NOT NULL, |
9 | bucket_slug TEXT REFERENCES buckets(slug) |
10 | ); |
11 | |
12 | CREATE TABLE videos ( |
13 | slug TEXT NOT NULL, |
14 | bucket_slug TEXT NOT NULL REFERENCES buckets(slug), |
15 | name TEXT NOT NULL, |
16 | author TEXT NOT NULL, |
17 | details TEXT NOT NULL DEFAULT '', |
18 | width INTEGER NOT NULL DEFAULT 640, |
19 | height INTEGER NOT NULL DEFAULT 480, |
20 | announcement_id INTEGER NOT NULL, |
21 | PRIMARY KEY (slug, bucket_slug), |
22 | FOREIGN KEY (announcement_id, bucket_slug) |
23 | REFERENCES announcements(id, bucket_slug) |
24 | ); |