Files
team/server/channels/db/migrations/postgres/000098_create_post_acknowledgements.up.sql

7 lines
178 B
SQL

CREATE TABLE IF NOT EXISTS postacknowledgements(
postid VARCHAR(26) NOT NULL,
userid VARCHAR(26) NOT NULL,
acknowledgedat bigint,
PRIMARY KEY (postid, userid)
);