19.sql (1031B)
1 -- +migrate Up 2 CREATE TABLE IF NOT EXISTS chat_inbox_messages ( 3 id INTEGER NOT NULL PRIMARY KEY, 4 message TEXT NOT NULL, 5 room_id INTEGER NOT NULL, 6 user_id INTEGER NOT NULL, 7 to_user_id INTEGER NOT NULL, 8 is_read TINYINT(1) NOT NULL DEFAULT 0, 9 created_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, 10 CONSTRAINT chat_inbox_messages_room_id_fk 11 FOREIGN KEY (room_id) 12 REFERENCES chat_rooms (id) 13 ON DELETE CASCADE 14 ON UPDATE CASCADE, 15 CONSTRAINT chat_inbox_messages_user_id_fk 16 FOREIGN KEY (user_id) 17 REFERENCES users (id) 18 ON DELETE CASCADE 19 ON UPDATE CASCADE, 20 CONSTRAINT chat_inbox_messages_to_user_id_fk 21 FOREIGN KEY (to_user_id) 22 REFERENCES users (id) 23 ON DELETE CASCADE 24 ON UPDATE CASCADE); 25 CREATE INDEX chat_inbox_messages_to_user_id_idx ON chat_inbox_messages (to_user_id); 26 CREATE INDEX chat_inbox_messages_is_read_idx ON chat_inbox_messages (is_read); 27 28 -- +migrate Down