165.sql (672B)
1 -- +migrate Up 2 CREATE TABLE IF NOT EXISTS user_last_known_messages ( 3 user_id INTEGER NOT NULL, 4 room_id INTEGER NOT NULL, 5 last_known_timestamp DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, 6 created_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, 7 PRIMARY KEY (user_id, room_id), 8 CONSTRAINT user_last_known_messages_room_id_fk 9 FOREIGN KEY (room_id) 10 REFERENCES chat_rooms (id) 11 ON DELETE CASCADE 12 ON UPDATE CASCADE, 13 CONSTRAINT user_last_known_messages_user_id_fk 14 FOREIGN KEY (user_id) 15 REFERENCES users (id) 16 ON DELETE CASCADE 17 ON UPDATE CASCADE 18 ); 19 20 -- +migrate Down