• Home
• im.actor.server
• actor-persist
• 1.0.133
• source code
• V20150526031815__CreateGroupInviteToken.sql

×

Project download

Many resources are needed to download a project. Please understand that we have to compensate our server costs. Thank you in advance.
Project price only 1 $

You can buy this project and download/modify it how often you want.

sql.migration.V20150526031815__CreateGroupInviteToken.sql Maven / Gradle / Ivy

CREATE TABLE group_invite_tokens (
  group_id INT NOT NULL,
  creator_id INT NOT NULL,
  token VARCHAR(255) NOT NULL,
  revoked_at timestamp,
  PRIMARY KEY(group_id, creator_id, token)
);
CREATE UNIQUE INDEX ON group_invite_tokens (revoked_at);
CREATE UNIQUE INDEX ON group_invite_tokens (token);