2 slug TEXT NOT NULL PRIMARY KEY,
6 CREATE TABLE announcements (
7 id INTEGER NOT NULL PRIMARY KEY,
8 made_at DATETIME NOT NULL,
9 bucket_slug TEXT REFERENCES buckets(slug)
14 bucket_slug TEXT NOT NULL REFERENCES buckets(slug),
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)