mirror of
https://github.com/mattermost/mattermost.git
synced 2026-04-15 22:12:19 -04:00
16 lines
441 B
MySQL
16 lines
441 B
MySQL
|
CREATE TABLE IF NOT EXISTS status (
|
||
|
|
userid VARCHAR(26) PRIMARY KEY,
|
||
|
|
status VARCHAR(32),
|
||
|
|
manual boolean,
|
||
|
|
lastactivityat bigint
|
||
|
|
);
|
||
|
|
|
||
|
|
ALTER TABLE status DROP COLUMN IF EXISTS activechannel;
|
||
|
|
|
||
|
|
CREATE INDEX IF NOT EXISTS idx_status_status ON status(status);
|
||
|
|
|
||
|
|
ALTER TABLE status ADD COLUMN IF NOT EXISTS dndendtime bigint;
|
||
|
|
ALTER TABLE status ADD COLUMN IF NOT EXISTS prevstatus VARCHAR(32);
|
||
|
|
|
||
|
|
DROP INDEX IF EXISTS idx_status_user_id;
|