jam-cloud/db/up/chat_channel.sql

4 lines
308 B
MySQL
Raw Permalink Normal View History

2016-01-30 22:08:54 +00:00
ALTER TABLE chat_messages ADD COLUMN channel VARCHAR(128) NOT NULL DEFAULT 'session';
2016-02-01 20:14:06 +00:00
CREATE INDEX chat_messages_idx_channels ON chat_messages(channel);
CREATE INDEX chat_messages_idx_created_at ON chat_messages(created_at);
CREATE INDEX chat_messages_idx_music_session_id ON chat_messages(music_session_id);