SQL
CREATE TABLE "mcp_registry_server" (
"slug" varchar(255) PRIMARY KEY NOT NULL,
"status" varchar(50) NOT NULL,
"version" varchar(50) NOT NULL,
"registryUpdatedAt" datetime(3) NOT NULL,
"data" text NOT NULL DEFAULT ('{}'),
"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 "CHK_tmp_mcp_registry_server_status" CHECK ("status" IN ('active', 'deprecated'))
)
Columns
| Column | Data type | Allow null | Primary key | Actions |
|---|---|---|---|---|
slug |
varchar(255) |
✓ | Rename | Drop | |
status |
varchar(50) |
Rename | Drop | ||
version |
varchar(50) |
Rename | Drop | ||
registryUpdatedAt |
datetime(3) |
Rename | Drop | ||
data |
TEXT |
Rename | Drop | ||
createdAt |
datetime(3) |
Rename | Drop | ||
updatedAt |
datetime(3) |
Rename | Drop |
Indexes
| Name | Columns | Unique | SQL | Drop? |
|---|---|---|---|---|
| sqlite_autoindex_mcp_registry_server_1 |
slug
|
✓ | SQL | Drop |