2 slug TEXT NOT NULL PRIMARY KEY,
7 CREATE TABLE announcements (
8 id INTEGER NOT NULL PRIMARY KEY,
9 made_at DATETIME NOT NULL,
10 bucket_slug TEXT REFERENCES buckets(slug)
15 bucket_slug TEXT NOT NULL REFERENCES buckets(slug),
19 details TEXT NOT NULL DEFAULT '',
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)