Query

avatarai.db — ProviderUsage

SQL

CREATE TABLE "ProviderUsage"  (
  "Provider" TEXT NOT NULL,
  "Model" TEXT NOT NULL,
  "Date" TEXT NOT NULL,
  "TokensUsed" INTEGER NOT NULL,
  "RequestsCount" INTEGER NOT NULL,
  CONSTRAINT "PK_ProviderUsage" PRIMARY KEY ("Provider", "Model", "Date")
)

+ Add column

Columns

Column Data type Allow null Primary key Actions
Provider TEXT ✓ Rename | Drop
Model TEXT ✓ Rename | Drop
Date TEXT ✓ Rename | Drop
TokensUsed INTEGER Rename | Drop
RequestsCount INTEGER Rename | Drop

+ Add index

Indexes

Name Columns Unique SQL Drop?
sqlite_autoindex_ProviderUsage_1
  • Provider
  • Model
  • Date
 ✓ SQL
-- no sql found --
 Drop