24.sql (848B)
1 -- +migrate Up 2 CREATE TABLE IF NOT EXISTS badges ( 3 id INTEGER PRIMARY KEY, 4 name VARCHAR(255) UNIQUE NOT NULL, 5 created_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP); 6 7 INSERT INTO badges (name) VALUES ('RE challenge 1'); 8 INSERT INTO badges (name) VALUES ('ByteRoad captcha challenge'); 9 10 CREATE TABLE IF NOT EXISTS user_badges ( 11 user_id INTEGER NOT NULL, 12 badge_id INTEGER NOT NULL, 13 created_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, 14 PRIMARY KEY (user_id, badge_id), 15 CONSTRAINT users_badges_user_id_fk 16 FOREIGN KEY (user_id) 17 REFERENCES users (id) 18 ON DELETE CASCADE 19 ON UPDATE CASCADE, 20 CONSTRAINT users_badges_badge_id_fk 21 FOREIGN KEY (badge_id) 22 REFERENCES badges (id) 23 ON DELETE CASCADE 24 ON UPDATE CASCADE); 25 26 -- +migrate Down