23.sql (513B)
1 -- +migrate Up 2 CREATE TABLE IF NOT EXISTS uploads ( 3 id INTEGER PRIMARY KEY, 4 user_id INTEGER NOT NULL, 5 file_name VARCHAR(255) UNIQUE NOT NULL, 6 orig_file_name VARCHAR(255) NOT NULL, 7 password VARCHAR(255) NOT NULL DEFAULT '', 8 file_size INTEGER NOT NULL, 9 created_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, 10 CONSTRAINT uploads_user_id_fk 11 FOREIGN KEY (user_id) 12 REFERENCES users (id) 13 ON DELETE CASCADE 14 ON UPDATE CASCADE); 15 16 -- +migrate Down