Something went wrong. Try again.
A lexicon-driven AppView for ATProto.
Something went wrong. Try again.
339 B · 8 lines
SQL
at main
123456789CREATE TABLE IF NOT EXISTS account_delegates ( account_did TEXT NOT NULL REFERENCES delegated_accounts(account_did) ON DELETE CASCADE, user_did TEXT NOT NULL, role TEXT NOT NULL CHECK (role IN ('owner', 'admin', 'member')), granted_by TEXT NOT NULL, created_at TEXT NOT NULL, PRIMARY KEY (account_did, user_did));