[catagits/App-IdiotBox.git] / share / sql / idiotbox-1.0-sqlite.sql

CREATE TABLE buckets (
  slug TEXT NOT NULL PRIMARY KEY,
  name TEXT NOT NULL
);

CREATE TABLE announcements (
  id INTEGER NOT NULL PRIMARY KEY,
  made_at DATETIME NOT NULL,
  bucket_slug TEXT REFERENCES buckets(slug)
);

CREATE TABLE videos (
  slug TEXT NOT NULL,
  bucket_slug TEXT NOT NULL REFERENCES buckets(slug),
  name TEXT NOT NULL,
  author TEXT NOT NULL,
  details TEXT NOT NULL DEFAULT '',
  announcement_id INTEGER NOT NULL,
  PRIMARY KEY (slug, bucket_slug),
  FOREIGN KEY (announcement_id, bucket_slug)
    REFERENCES announcements(id, bucket_slug)
);
Commit	Line	Data
d6485458	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 '',
6c3eb3eb	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)
d6485458	22	);