this repo has no description
lewis.moe
1CREATE TABLE oauth_scope_preference (
2 id UUID PRIMARY KEY DEFAULT gen_random_uuid(),
3 did TEXT NOT NULL REFERENCES users(did) ON DELETE CASCADE,
4 client_id TEXT NOT NULL,
5 scope TEXT NOT NULL,
6 granted BOOLEAN NOT NULL DEFAULT TRUE,
7 created_at TIMESTAMPTZ NOT NULL DEFAULT NOW(),
8 updated_at TIMESTAMPTZ NOT NULL DEFAULT NOW(),
9 UNIQUE(did, client_id, scope)
10);
11
12CREATE INDEX idx_oauth_scope_pref_lookup ON oauth_scope_preference(did, client_id);