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
)