remindrs/migrations/2023-01-18-102900_create_reminder/up.sql

10 lines
272 B
MySQL
Raw Permalink Normal View History

CREATE TABLE reminders (
id SERIAL NOT NULL PRIMARY KEY,
created TIMESTAMPTZ NOT NULL DEFAULT now(),
planned TIMESTAMPTZ NOT NULL,
executed TIMESTAMPTZ,
title TEXT NOT NULL,
message TEXT NOT NULL,
receiver TEXT NOT NULL
);