6 lines
324 B
SQL
6 lines
324 B
SQL
ALTER TABLE chat1_room_to_user ADD lastFetch INT(10) NOT NULL DEFAULT 0;
|
|
ALTER TABLE chat1_room_to_user ADD lastPush INT(10) NOT NULL DEFAULT 0;
|
|
ALTER TABLE chat1_room_to_user ADD active TINYINT(1) NOT NULL DEFAULT 0;
|
|
ALTER TABLE chat1_room_to_user ADD KEY (roomID, active);
|
|
ALTER TABLE chat1_room_to_user ADD KEY (active);
|