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')),
  "resource" varchar,
  "scope" text NOT NULL DEFAULT ('["tool:listWorkflows","tool:getWorkflowDetails"]'),
  CONSTRAINT "FK_e829ca1240b877f73fd5fab14a2" FOREIGN KEY ("userId") REFERENCES "user" ("id") ON DELETE CASCADE ON UPDATE NO ACTION,
  CONSTRAINT "FK_81de58036895ccabf2214c6d99e" FOREIGN KEY ("clientId") REFERENCES "oauth_clients" ("id") ON DELETE CASCADE ON UPDATE NO ACTION
)

+ 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
resource varchar ✓ Rename | Drop
scope TEXT Rename | Drop

Foreign Keys

Column Destination
clientId oauth_clients.id
userId user.id

+ Add index

Indexes

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