mirror of
https://github.com/hanzoai/team.git
synced 2026-09-30 01:57: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
16 lines
475 B
SQL
16 lines
475 B
SQL
CREATE TABLE IF NOT EXISTS groupteams (
|
|
groupid VARCHAR(26),
|
|
autoadd boolean,
|
|
schemeadmin boolean,
|
|
createat bigint,
|
|
deleteat bigint,
|
|
updateat bigint,
|
|
teamid VARCHAR(26),
|
|
PRIMARY KEY(groupid, teamid)
|
|
);
|
|
|
|
ALTER TABLE groupteams ADD COLUMN IF NOT EXISTS schemeadmin boolean default false;
|
|
|
|
CREATE INDEX IF NOT EXISTS idx_groupteams_schemeadmin ON groupteams (schemeadmin);
|
|
CREATE INDEX IF NOT EXISTS idx_groupteams_teamid ON groupteams (teamid);
|