8.sql (388B)
1 -- +migrate Up 2 3 CREATE TABLE IF NOT EXISTS downloads ( 4 id INTEGER NOT NULL PRIMARY KEY, 5 user_id INTEGER NOT NULL, 6 filename VARCHAR(255) NOT NULL, 7 created_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, 8 CONSTRAINT user_id_fk 9 FOREIGN KEY (user_id) 10 REFERENCES users (id) 11 ON DELETE CASCADE 12 ON UPDATE CASCADE); 13 14 -- +migrate Down