Query

MaiBot.db — jargon

SQL

CREATE TABLE "jargon"  (
  "id" INTEGER NOT NULL PRIMARY KEY,
  "content" TEXT NOT NULL,
  "raw_content" TEXT,
  "meaning" TEXT,
  "chat_id" TEXT NOT NULL,
  "is_global" INTEGER NOT NULL,
  "count" INTEGER NOT NULL,
  "is_jargon" INTEGER,
  "last_inference_count" INTEGER,
  "is_complete" INTEGER NOT NULL,
  "inference_with_context" TEXT,
  "inference_content_only" TEXT
)

+ Add column

Columns

Column Data type Allow null Primary key Actions
id INTEGER ✓ Rename | Drop
content TEXT Rename | Drop
raw_content TEXT ✓ Rename | Drop
meaning TEXT ✓ Rename | Drop
chat_id TEXT Rename | Drop
is_global INTEGER Rename | Drop
count INTEGER Rename | Drop
is_jargon INTEGER ✓ Rename | Drop
last_inference_count INTEGER ✓ Rename | Drop
is_complete INTEGER Rename | Drop
inference_with_context TEXT ✓ Rename | Drop
inference_content_only TEXT ✓ Rename | Drop

+ Add index

Indexes

Name Columns Unique SQL Drop?
jargon_chat_id chat_id SQL 
CREATE INDEX "jargon_chat_id"
ON "jargon" ("chat_id")
Drop