SQL

CREATE TABLE provider_models  (
  id TEXT PRIMARY KEY,
  provider_id TEXT NOT NULL,
  user_id TEXT NOT NULL DEFAULT '',
  model_id TEXT NOT NULL,
  label TEXT NOT NULL,
  capabilities TEXT NOT NULL DEFAULT '{}',
  aliases TEXT NOT NULL DEFAULT '[]',
  source TEXT NOT NULL DEFAULT 'dynamic',
  status TEXT NOT NULL DEFAULT 'available',
  fetched_at TEXT NOT NULL DEFAULT (datetime('now')),
  created_at TEXT NOT NULL DEFAULT (datetime('now')),
  updated_at TEXT NOT NULL DEFAULT (datetime('now'))
)

+ Add column

Columns

Column Data type Allow null Primary key Actions
id TEXT ✓ ✓ Rename | Drop
provider_id TEXT Rename | Drop
user_id TEXT Rename | Drop
model_id TEXT Rename | Drop
label TEXT Rename | Drop
capabilities TEXT Rename | Drop
aliases TEXT Rename | Drop
source TEXT Rename | Drop
status TEXT Rename | Drop
fetched_at TEXT Rename | Drop
created_at TEXT Rename | Drop
updated_at TEXT Rename | Drop

+ Add index

Indexes

Name Columns Unique SQL Drop?
idx_provider_models_model model_id SQL 
CREATE INDEX idx_provider_models_model
ON provider_models(model_id)
Drop
idx_provider_models_provider_user
  • provider_id
  • user_id
 SQL 
CREATE INDEX idx_provider_models_provider_user
ON provider_models(provider_id, user_id)
Drop
sqlite_autoindex_provider_models_1 id ✓ SQL
-- no sql found --
 Drop