Query

MaiBot.db — expression

SQL

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

+ Add column

Columns

Column Data type Allow null Primary key Actions
id INTEGER ✓ Rename | Drop
situation TEXT Rename | Drop
style TEXT Rename | Drop
content_list TEXT ✓ Rename | Drop
count INTEGER Rename | Drop
last_active_time REAL Rename | Drop
chat_id TEXT Rename | Drop
create_date REAL ✓ Rename | Drop
checked INTEGER Rename | Drop
rejected INTEGER Rename | Drop
modified_by TEXT ✓ 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