mirror of
https://github.com/hanzoai/team.git
synced 2026-10-30 14:49:35 +00:00
Doug LauderandGitHub
f09396b63b
Combines the following repositories into one: https://github.com/mattermost/mattermost-server https://github.com/mattermost/mattermost-webapp https://github.com/mattermost/focalboard https://github.com/mattermost/mattermost-plugin-playbooks
7 lines
401 B
SQL
7 lines
401 B
SQL
ALTER TABLE channelmembers ALTER COLUMN notifyprops TYPE jsonb USING notifyprops::jsonb;
|
|
|
|
CREATE INDEX IF NOT EXISTS idx_channelmembers_user_id_channel_id_last_viewed_at ON channelmembers(userid, channelid, lastviewedat);
|
|
CREATE INDEX IF NOT EXISTS idx_channelmembers_channel_id_scheme_guest_user_id ON channelmembers(channelid, schemeguest, userid);
|
|
|
|
DROP INDEX IF EXISTS idx_channelmembers_user_id;
|