auth

Main authentication module for my projects
git clone git://git.finwo.net/app/auth
Log | Files | Refs

002_client_hosts.sql (254B)


      1 CREATE TABLE oidc_client_hosts (
      2   host TEXT PRIMARY KEY,
      3   realm_id TEXT NOT NULL REFERENCES realms(id) ON DELETE CASCADE,
      4   client_id TEXT NOT NULL,
      5   created_at INTEGER NOT NULL
      6 );
      7 
      8 CREATE INDEX oidc_client_hosts_realm ON oidc_client_hosts(realm_id);