1 2 3 4 5 6 7 8 9 10
CREATE TABLE cases ( id SERIAL, user_id BIGINT, guild_id BIGINT, casetype TEXT NOT NULL, reason TEXT NOT NULL DEFAULT '', moderator BIGINT NOT NULL, timestamp TIMESTAMP WITH TIME ZONE NOT NULL DEFAULT now(), PRIMARY KEY(id, user_id, guild_id) )