Query

rollpix.db — gemini_models

SQL

CREATE TABLE gemini_models  (
  id INTEGER PRIMARY KEY AUTOINCREMENT,
  model_key TEXT UNIQUE NOT NULL,
  model_id TEXT NOT NULL,
  display_name TEXT NOT NULL,
  cost_per_1m_input REAL NOT NULL,
  cost_per_1m_output REAL NOT NULL,
  cost_per_image REAL NOT NULL,
  active INTEGER NOT NULL DEFAULT 1,
  created_at TEXT DEFAULT (datetime('now')),
  updated_at TEXT DEFAULT (datetime('now'))
)

+ Add column

Columns

Column Data type Allow null Primary key Actions
id INTEGER ✓ ✓ Rename | Drop
model_key TEXT Rename | Drop
model_id TEXT Rename | Drop
display_name TEXT Rename | Drop
cost_per_1m_input REAL Rename | Drop
cost_per_1m_output REAL Rename | Drop
cost_per_image REAL Rename | Drop
active INTEGER Rename | Drop
created_at TEXT ✓ Rename | Drop
updated_at TEXT ✓ Rename | Drop

+ Add index

Indexes

Name Columns Unique SQL Drop?
sqlite_autoindex_gemini_models_1 model_key ✓ SQL
-- no sql found --
 Drop