86.sql (765B)
1 -- +migrate Up 2 CREATE TABLE IF NOT EXISTS links_pgps ( 3 id INTEGER NOT NULL PRIMARY KEY, 4 idx INTEGER NOT NULL, 5 link_id INTEGER NOT NULL, 6 title VARCHAR(255) NOT NULL, 7 description TEXT NOT NULL, 8 pgp_public_key TEXT NOT NULL, 9 CONSTRAINT links_pgps_link_id_fk 10 FOREIGN KEY (link_id) 11 REFERENCES links (id) 12 ON DELETE CASCADE 13 ON UPDATE CASCADE); 14 15 CREATE TABLE IF NOT EXISTS links_mirrors ( 16 id INTEGER NOT NULL PRIMARY KEY, 17 link_id INTEGER NOT NULL, 18 idx INTEGER NOT NULL, 19 mirror_url VARCHAR(255) NOT NULL, 20 CONSTRAINT links_pgps_link_id_fk 21 FOREIGN KEY (link_id) 22 REFERENCES links (id) 23 ON DELETE CASCADE 24 ON UPDATE CASCADE); 25 26 -- +migrate Down