6.sql (706B)
1 -- +migrate Up 2 3 CREATE TABLE IF NOT EXISTS chat_rooms_tmp ( 4 id INTEGER NOT NULL PRIMARY KEY, 5 name VARCHAR(255) UNIQUE NOT NULL, 6 owner_user_id INTEGER NULL, 7 password VARCHAR(255) NOT NULL DEFAULT '', 8 created_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, 9 CONSTRAINT chat_rooms_owner_user_id_fk 10 FOREIGN KEY (owner_user_id) 11 REFERENCES users (id) 12 ON DELETE CASCADE 13 ON UPDATE CASCADE); 14 15 INSERT INTO chat_rooms_tmp (id, name, created_at) 16 SELECT id, name, created_at FROM chat_rooms; 17 18 DROP TABLE chat_rooms; 19 20 ALTER TABLE chat_rooms_tmp RENAME TO chat_rooms; 21 22 CREATE INDEX chat_rooms_created_at_idx ON chat_rooms (created_at); 23 24 -- +migrate Down