about summary refs log blame commit diff
path: root/fun/paroxysm/migrations/20181209140247_initial/up.sql
blob: e8b52d5a9b91bfb0c182c37f52c196e3da7ae422 (plain) (tree)
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
);