DashBot/db/migrations/20170918122903_reminders.sql
2017-09-18 15:37:24 +02:00

14 lines
268 B
SQL

-- +micrate Up
CREATE TABLE reminders (
id SERIAL PRIMARY KEY,
author TEXT NOT NULL,
remind_time TIMESTAMP NOT NULL,
content TEXT NOT NULL,
created_at TIMESTAMP NOT NULL,
checked_at TIMESTAMP,
read_at TIMESTAMP
);
-- +micrate Down
DROP TABLE reminders;