fun/tvldb/migrations/20181209140247_initial/up.sql


1
2
3
4
5
6
7
8
9
10
11
12
13
14
15

CREATE TABLE keywords (
	id SERIAL PRIMARY KEY,
	name VARCHAR UNIQUE NOT NULL,
	chan VARCHAR NOT NULL,
	UNIQUE(name, chan)
);

CREATE TABLE entries (
	id SERIAL PRIMARY KEY,
	keyword_id INT NOT NULL REFERENCES keywords ON DELETE CASCADE,
	idx INT NOT NULL,
	text VARCHAR NOT NULL,
	creation_ts TIMESTAMP NOT NULL,
	created_by VARCHAR NOT NULL
);