KQDrDP9x

1-- work in progress, for postgres 12
2
3CREATE TABLE IF NOT EXISTS warns
4(
5    warnID BIGSERIAL PRIMARY KEY,
6    userID BIGINT,
7    authorID BIGINT,
8    guildID BIGINT,
9    reason TEXT
10);
11
12CREATE TABLE IF NOT EXISTS roles
13(
14    guildID BIGINT PRIMARY KEY,
15    modRole BIGINT,
16    adminRole BIGINT,
17    ownerRole BIGINT,
18    botdevRole BIGINT,
19    approvedRole BIGINT
20);
21
22CREATE TABLE IF NOT EXISTS mutes
23(
24    muteID BIGSERIAL PRIMARY KEY,
25    userID BIGINT,
26    authorID BIGINT,
27    guildID BIGINT,
28    reason TEXT
29);
30
31CREATE INDEX IF NOT EXISTS warns_idx ON warns (userID, authorID);
32CREATE INDEX IF NOT EXISTS mutes_idx ON mutes (userID, authorID);
33CREATE INDEX IF NOT EXISTS role_idx ON roles (guildID);