Query

database.sqlite — oauth_clients

SQL

CREATE TABLE "oauth_clients"  (
  "id" varchar PRIMARY KEY NOT NULL,
  "name" varchar(255) NOT NULL,
  "redirectUris" text NOT NULL,
  "grantTypes" text NOT NULL,
  "clientSecret" varchar(255),
  "clientSecretExpiresAt" bigint,
  "tokenEndpointAuthMethod" varchar(255) NOT NULL DEFAULT ('none'),
  "createdAt" datetime(3) NOT NULL DEFAULT (STRFTIME('%Y-%m-%d %H:%M:%f', 'NOW')),
  "updatedAt" datetime(3) NOT NULL DEFAULT (STRFTIME('%Y-%m-%d %H:%M:%f', 'NOW'))
)

+ Add column

Columns

Column Data type Allow null Primary key Actions
id varchar ✓ Rename | Drop
name varchar(255) Rename | Drop
redirectUris TEXT Rename | Drop
grantTypes TEXT Rename | Drop
clientSecret varchar(255) ✓ Rename | Drop
clientSecretExpiresAt bigint ✓ Rename | Drop
tokenEndpointAuthMethod varchar(255) Rename | Drop
createdAt datetime(3) Rename | Drop
updatedAt datetime(3) Rename | Drop

+ Add index

Indexes

Name Columns Unique SQL Drop?
sqlite_autoindex_oauth_clients_1 id ✓ SQL
-- no sql found --
 Drop