28.sql (518B)
1 -- +migrate Up 2 CREATE TABLE IF NOT EXISTS captcha_requests ( 3 id INTEGER NOT NULL PRIMARY KEY, 4 user_id INTEGER NOT NULL, 5 captcha_img TEXT NOT NULL, 6 answer VARCHAR(50) NOT NULL, 7 created_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, 8 CONSTRAINT captcha_requests_user_id_fk 9 FOREIGN KEY (user_id) 10 REFERENCES users (id) 11 ON DELETE CASCADE 12 ON UPDATE CASCADE); 13 CREATE INDEX captcha_requests_created_at_idx ON captcha_requests (created_at); 14 15 -- +migrate Down