api/migrations/010_oauth_clients.sql at main

danabra.mov / slices

forked from slices.network/slices

fork atom

Highly ambitious ATProtocol AppView service and sdks

fork atom

slices / api / migrations / 010_oauth_clients.sql

at main 13 lines 456 B view raw

wrap content

chadtmiller.com oauth client management almost there, still some tidying up to do 6mo ago

c34a10d9

 1-- Create oauth_clients table
 2CREATE TABLE oauth_clients (
 3    id SERIAL PRIMARY KEY,
 4    slice_uri TEXT NOT NULL,
 5    client_id TEXT UNIQUE NOT NULL,
 6    registration_access_token TEXT,
 7    created_at TIMESTAMPTZ NOT NULL DEFAULT NOW(),
 8    created_by_did TEXT NOT NULL
 9);
10
11-- Create indexes for efficient lookups
12CREATE INDEX idx_oauth_clients_slice_uri ON oauth_clients (slice_uri);
13CREATE INDEX idx_oauth_clients_client_id ON oauth_clients (client_id);