98.sql (342B)
1 -- +migrate Up 2 CREATE TABLE IF NOT EXISTS snippets ( 3 name VARCHAR(20) NOT NULL, 4 user_id INTEGER NOT NULL, 5 text TEXT NOT NULL, 6 PRIMARY KEY (user_id, name), 7 CONSTRAINT snippets_user_id_fk 8 FOREIGN KEY (user_id) 9 REFERENCES users (id) 10 ON DELETE CASCADE 11 ON UPDATE CASCADE); 12 13 -- +migrate Down