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

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

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,
  act_talk_id INTEGER,
  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
7b33909b	1	CREATE TABLE buckets (
	2	slug TEXT NOT NULL PRIMARY KEY,
	3	name TEXT NOT NULL,
	4	act_url TEXT
	5	);
	6
	7	CREATE TABLE announcements (
	8	id INTEGER NOT NULL PRIMARY KEY,
	9	made_at DATETIME NOT NULL,
	10	bucket_slug TEXT REFERENCES buckets(slug)
	11	);
	12
	13	CREATE TABLE videos (
	14	slug TEXT NOT NULL,
	15	bucket_slug TEXT NOT NULL REFERENCES buckets(slug),
	16	name TEXT NOT NULL,
	17	author TEXT NOT NULL,
	18	act_talk_id INTEGER,
	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)
	24	);