Query

MaiBot.db — llm_usage

SQL

CREATE TABLE "llm_usage"  (
  "id" INTEGER NOT NULL PRIMARY KEY,
  "model_name" TEXT NOT NULL,
  "user_id" TEXT NOT NULL,
  "request_type" TEXT NOT NULL,
  "endpoint" TEXT NOT NULL,
  "prompt_tokens" INTEGER NOT NULL,
  "completion_tokens" INTEGER NOT NULL,
  "total_tokens" INTEGER NOT NULL,
  "cost" REAL NOT NULL,
  "status" TEXT NOT NULL,
  "timestamp" DATETIME NOT NULL,
  model_assign_name TEXT NULL,
  model_api_provider TEXT NULL,
  time_cost DOUBLE NULL
)

+ Add column

Columns

Column Data type Allow null Primary key Actions
id INTEGER ✓ Rename | Drop
model_name TEXT Rename | Drop
user_id TEXT Rename | Drop
request_type TEXT Rename | Drop
endpoint TEXT Rename | Drop
prompt_tokens INTEGER Rename | Drop
completion_tokens INTEGER Rename | Drop
total_tokens INTEGER Rename | Drop
cost REAL Rename | Drop
status TEXT Rename | Drop
timestamp DATETIME Rename | Drop
model_assign_name TEXT ✓ Rename | Drop
model_api_provider TEXT ✓ Rename | Drop
time_cost DOUBLE ✓ Rename | Drop

+ Add index

Indexes

Name Columns Unique SQL Drop?
llmusage_model_name model_name SQL 
CREATE INDEX "llmusage_model_name"
ON "llm_usage" ("model_name")
Drop
llmusage_request_type request_type SQL 
CREATE INDEX "llmusage_request_type"
ON "llm_usage" ("request_type")
Drop
llmusage_timestamp timestamp SQL 
CREATE INDEX "llmusage_timestamp"
ON "llm_usage" ("timestamp")
Drop
llmusage_user_id user_id SQL 
CREATE INDEX "llmusage_user_id"
ON "llm_usage" ("user_id")
Drop