SQL

CREATE TABLE api_providers  (
  id TEXT PRIMARY KEY,
  name TEXT NOT NULL,
  provider TEXT NOT NULL,
  api_key TEXT NOT NULL DEFAULT '',
  base_url TEXT NOT NULL DEFAULT '',
  model_name TEXT NOT NULL DEFAULT '',
  is_active INTEGER NOT NULL DEFAULT 0,
  status TEXT NOT NULL DEFAULT 'not_configured',
  status_error TEXT NOT NULL DEFAULT '',
  created_at TEXT NOT NULL DEFAULT (datetime('now')),
  updated_at TEXT NOT NULL DEFAULT (datetime('now')),
  user_id TEXT NOT NULL DEFAULT '',
  models_fetched_at TEXT NOT NULL DEFAULT '',
  models_fetch_error TEXT NOT NULL DEFAULT ''
)

+ Add column

Columns

Column Data type Allow null Primary key Actions
id TEXT ✓ ✓ Rename | Drop
name TEXT Rename | Drop
provider TEXT Rename | Drop
api_key TEXT Rename | Drop
base_url TEXT Rename | Drop
model_name TEXT Rename | Drop
is_active INTEGER Rename | Drop
status TEXT Rename | Drop
status_error TEXT Rename | Drop
created_at TEXT Rename | Drop
updated_at TEXT Rename | Drop
user_id TEXT Rename | Drop
models_fetched_at TEXT Rename | Drop
models_fetch_error TEXT Rename | Drop

+ Add index

Indexes

Name Columns Unique SQL Drop?
sqlite_autoindex_api_providers_1 id ✓ SQL
-- no sql found --
 Drop