SQL
CREATE TABLE "auth_provider_sync_history" (
"id" INTEGER PRIMARY KEY AUTOINCREMENT,
"providerType" VARCHAR(32) NOT NULL,
"runMode" TEXT NOT NULL,
"status" TEXT NOT NULL,
"startedAt" DATETIME NOT NULL,
"endedAt" DATETIME NOT NULL,
"scanned" INTEGER NOT NULL,
"created" INTEGER NOT NULL,
"updated" INTEGER NOT NULL,
"disabled" INTEGER NOT NULL,
"error" TEXT
)
Columns
| Column | Data type | Allow null | Primary key | Actions |
|---|---|---|---|---|
id |
INTEGER |
✓ | ✓ | Rename | Drop |
providerType |
VARCHAR(32) |
Rename | Drop | ||
runMode |
TEXT |
Rename | Drop | ||
status |
TEXT |
Rename | Drop | ||
startedAt |
DATETIME |
Rename | Drop | ||
endedAt |
DATETIME |
Rename | Drop | ||
scanned |
INTEGER |
Rename | Drop | ||
created |
INTEGER |
Rename | Drop | ||
updated |
INTEGER |
Rename | Drop | ||
disabled |
INTEGER |
Rename | Drop | ||
error |
TEXT |
✓ | Rename | Drop |
Indexes
| Name | Columns | Unique | SQL | Drop? |
|---|