Query

database.sqlite — oauth_authorization_codes

SQL

CREATE TABLE "oauth_authorization_codes"  (
  "code" varchar(255) PRIMARY KEY NOT NULL,
  "clientId" varchar NOT NULL,
  "userId" varchar NOT NULL,
  "redirectUri" varchar NOT NULL,
  "codeChallenge" varchar NOT NULL,
  "codeChallengeMethod" varchar(255) NOT NULL,
  "expiresAt" bigint NOT NULL,
  "state" varchar,
  "used" boolean NOT NULL DEFAULT (false),
  "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')),
  CONSTRAINT "FK_81de58036895ccabf2214c6d99e" FOREIGN KEY ("clientId") REFERENCES "oauth_clients" ("id") ON DELETE CASCADE,
  CONSTRAINT "FK_e829ca1240b877f73fd5fab14a2" FOREIGN KEY ("userId") REFERENCES "user" ("id") ON DELETE CASCADE
)

+ Add column

Columns

Column Data type Allow null Primary key Actions
code varchar(255) ✓ Rename | Drop
clientId varchar Rename | Drop
userId varchar Rename | Drop
redirectUri varchar Rename | Drop
codeChallenge varchar Rename | Drop
codeChallengeMethod varchar(255) Rename | Drop
expiresAt bigint Rename | Drop
state varchar ✓ Rename | Drop
used boolean Rename | Drop
createdAt datetime(3) Rename | Drop
updatedAt datetime(3) Rename | Drop

Foreign Keys

Column Destination
userId user.id
clientId oauth_clients.id

+ Add index

Indexes

Name Columns Unique SQL Drop?
sqlite_autoindex_oauth_authorization_codes_1 code ✓ SQL
-- no sql found --
 Drop