Function ensureInviteCodeTable

apps/host-selfhost/src/auth/invites.ts:61–76

(client: Client)

});

export const ensureInviteCodeTable = async (client: Client): Promise<void> => {
  await client.execute(`
    CREATE TABLE IF NOT EXISTS invite_code (
      id            TEXT PRIMARY KEY,
      code          TEXT NOT NULL UNIQUE,
      role          TEXT NOT NULL DEFAULT 'member',
      label         TEXT,
      created_by    TEXT NOT NULL,
      created_at    TEXT NOT NULL,
      expires_at    TEXT,
      used_by       TEXT,
      used_by_email TEXT,
      used_at       TEXT
    )
  `);
};

export interface CreateInviteCodeInput {
  readonly createdBy: string;