mattermost/server/channels/db/migrations/postgres/000027_create_status.up.sql

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;