aboutsummaryrefslogtreecommitdiff
path: root/sql/init.sql
blob: 46d001b2ed2cec3f2587824a3355bc116da08dfe (plain)
1
2
3
4
5
6
7
8
CREATE TABLE reminders (
	id SERIAL NOT NULL,
	subject VARCHAR NOT NULL,
	created_by VARCHAR NOT NULL,
	created_in VARCHAR,
	trigger_at TIMESTAMP NOT NULL,
	created_at TIMESTAMP NOT NULL DEFAULT (NOW() AT TIME ZONE 'utc')
);