migrations/2018-06-06-183246_create_cases/up.sql


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)
)