mattermost/server/channels/db/migrations/postgres/000091_create_post_reminder.up.sql

8 lines
No EOL
254 B
SQL

CREATE TABLE IF NOT EXISTS postreminders (
postid varchar(26) NOT NULL,
userid varchar(26) NOT NULL,
targettime bigint,
PRIMARY KEY (postid, userid)
);
CREATE INDEX IF NOT EXISTS idx_postreminders_targettime ON postreminders(targettime);