migrations/2018-06-04-193138_create_notes/up.sql


1
2
3
4
5
6
7
8
9

CREATE TABLE notes (
	id SERIAL NOT NULL,
	user_id BIGINT NOT NULL,
	guild_id BIGINT NOT NULL,
	note TEXT NOT NULL,
	moderator BIGINT NOT NULL,
	timestamp TIMESTAMP WITH TIME ZONE NOT NULL DEFAULT now(),
	PRIMARY KEY(id, user_id, guild_id)
)