mirror of
https://github.com/mattermost/mattermost.git
synced 2026-04-29 01:49:20 -04:00
19 lines
569 B
MySQL
19 lines
569 B
MySQL
|
CREATE TABLE IF NOT EXISTS usergroups (
|
||
|
|
id VARCHAR(26) PRIMARY KEY,
|
||
|
|
name VARCHAR(64),
|
||
|
|
displayname VARCHAR(128),
|
||
|
|
description VARCHAR(1024),
|
||
|
|
source VARCHAR(64),
|
||
|
|
remoteid VARCHAR(48),
|
||
|
|
createat bigint,
|
||
|
|
updateat bigint,
|
||
|
|
deleteat bigint,
|
||
|
|
allowreference bool,
|
||
|
|
UNIQUE(name),
|
||
|
|
UNIQUE(source, remoteid)
|
||
|
|
);
|
||
|
|
|
||
|
|
ALTER TABLE usergroups ADD COLUMN IF NOT EXISTS allowreference bool;
|
||
|
|
CREATE INDEX IF NOT EXISTS idx_usergroups_remote_id ON usergroups (remoteid);
|
||
|
|
CREATE INDEX IF NOT EXISTS idx_usergroups_delete_at ON usergroups (deleteat);
|