mirror of
https://github.com/mattermost/mattermost.git
synced 2026-02-13 15:55:34 -05:00
c943ed6859
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
15 lines
488 B
SQL
15 lines
488 B
SQL
CREATE TABLE IF NOT EXISTS groupchannels (
|
|
groupid VARCHAR(26),
|
|
autoadd boolean,
|
|
schemeadmin boolean,
|
|
createat bigint,
|
|
deleteat bigint,
|
|
updateat bigint,
|
|
channelid VARCHAR(26),
|
|
PRIMARY KEY(groupid, channelid)
|
|
);
|
|
|
|
ALTER TABLE groupchannels ADD COLUMN IF NOT EXISTS schemeadmin boolean;
|
|
|
|
CREATE INDEX IF NOT EXISTS idx_groupteams_schemeadmin ON groupchannels (schemeadmin);
|
|
CREATE INDEX IF NOT EXISTS idx_groupchannels_channelid ON groupchannels (channelid);
|