AppFlowy-Cloud/migrations/20250403021559_workspace_invite_code.sql
2025-04-03 22:12:38 +08:00

8 lines
333 B
SQL

CREATE TABLE IF NOT EXISTS af_workspace_invite_code (
id UUID PRIMARY KEY DEFAULT UUID_GENERATE_V4 (),
invite_code TEXT NOT NULL,
expires_at TIMESTAMP,
workspace_id UUID NOT NULL REFERENCES af_workspace (workspace_id) ON DELETE CASCADE
);
CREATE INDEX idx_af_workspace_invite_code ON af_workspace_invite_code (invite_code);