SQL
CREATE TABLE "oauth_refresh_tokens" (
"token" varchar(255) PRIMARY KEY NOT NULL,
"clientId" varchar NOT NULL,
"userId" varchar NOT NULL,
"expiresAt" bigint NOT NULL,
"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')),
"scope" text NOT NULL DEFAULT ('["tool:listWorkflows","tool:getWorkflowDetails"]'),
CONSTRAINT "FK_a699f3ed9fd0c1b19bc2608ac53" FOREIGN KEY ("userId") REFERENCES "user" ("id") ON DELETE CASCADE ON UPDATE NO ACTION,
CONSTRAINT "FK_b388696ce4d8be7ffbe8d3e4b69" FOREIGN KEY ("clientId") REFERENCES "oauth_clients" ("id") ON DELETE CASCADE ON UPDATE NO ACTION
)
Columns
| Column | Data type | Allow null | Primary key | Actions |
|---|---|---|---|---|
token |
varchar(255) |
✓ | Rename | Drop | |
clientId |
varchar |
Rename | Drop | ||
userId |
varchar |
Rename | Drop | ||
expiresAt |
bigint |
Rename | Drop | ||
createdAt |
datetime(3) |
Rename | Drop | ||
updatedAt |
datetime(3) |
Rename | Drop | ||
scope |
TEXT |
Rename | Drop |
Foreign Keys
| Column | Destination |
|---|---|
clientId |
oauth_clients.id |
userId |
user.id |
Indexes
| Name | Columns | Unique | SQL | Drop? |
|---|---|---|---|---|
| sqlite_autoindex_oauth_refresh_tokens_1 |
token
|
✓ | SQL | Drop |