Files
team/server/channels/db/migrations/postgres/000008_create_group_members.up.sql

10 lines
252 B
SQL

CREATE TABLE IF NOT EXISTS groupmembers (
groupid VARCHAR(26),
userid VARCHAR(26),
createat bigint,
deleteat bigint,
PRIMARY KEY(groupid, userid)
);
CREATE INDEX IF NOT EXISTS idx_groupmembers_create_at ON groupmembers (createat);