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 announcement_id INTEGER NOT NULL,
19 PRIMARY KEY (slug, bucket_slug),
20 FOREIGN KEY (announcement_id, bucket_slug)
21 REFERENCES announcements(id, bucket_slug)