Skip to content
Permalink
Branch: master
Find file Copy path
Find file Copy path
Fetching contributors…
Cannot retrieve contributors at this time
24 lines (19 sloc) 448 Bytes
CREATE TABLE boards (
id text PRIMARY KEY,
token text NOT NULL,
email text NOT NULL,
webhook_id text NOT NULL,
CHECK (id != ''),
CHECK (token != ''),
CHECK (email != ''),
CHECK (webhook_id != '')
);
CREATE TABLE backups (
id text PRIMARY KEY,
board text REFERENCES boards (id) ON DELETE CASCADE,
data jsonb NOT NULL,
CHECK (id != ''),
CHECK (board != '')
);
table boards;
select id, board from backups order by board;
You can’t perform that action at this time.