Query

MaiBot.db — expression

SQL

CREATE TABLE "expression"  (
  "id" INTEGER NOT NULL PRIMARY KEY,
  "situation" TEXT NOT NULL,
  "style" TEXT NOT NULL,
  "count" REAL NOT NULL,
  "last_active_time" REAL NOT NULL,
  "chat_id" TEXT NOT NULL,
  "type" TEXT NOT NULL,
  "create_date" REAL
)

+ Add column

Columns

Column Data type Allow null Primary key Actions
id INTEGER ✓ Rename | Drop
situation TEXT Rename | Drop
style TEXT Rename | Drop
count REAL Rename | Drop
last_active_time REAL Rename | Drop
chat_id TEXT Rename | Drop
type TEXT Rename | Drop
create_date REAL ✓ Rename | Drop

+ Add index

Indexes

Name Columns Unique SQL Drop?
expression_chat_id chat_id SQL 
CREATE INDEX "expression_chat_id"
ON "expression" ("chat_id")
Drop