Query

MaiBot.db — person_info

SQL

CREATE TABLE "person_info"  (
  "id" INTEGER NOT NULL PRIMARY KEY,
  "is_known" INTEGER NOT NULL,
  "person_id" TEXT NOT NULL,
  "person_name" TEXT,
  "name_reason" TEXT,
  "platform" TEXT NOT NULL,
  "user_id" TEXT NOT NULL,
  "nickname" TEXT,
  "memory_points" TEXT,
  "know_times" REAL,
  "know_since" REAL,
  "last_know" REAL
)

+ Add column

Columns

Column Data type Allow null Primary key Actions
id INTEGER ✓ Rename | Drop
is_known INTEGER Rename | Drop
person_id TEXT Rename | Drop
person_name TEXT ✓ Rename | Drop
name_reason TEXT ✓ Rename | Drop
platform TEXT Rename | Drop
user_id TEXT Rename | Drop
nickname TEXT ✓ Rename | Drop
memory_points TEXT ✓ Rename | Drop
know_times REAL ✓ Rename | Drop
know_since REAL ✓ Rename | Drop
last_know REAL ✓ Rename | Drop

+ Add index

Indexes

Name Columns Unique SQL Drop?
personinfo_person_id person_id ✓ SQL 
CREATE UNIQUE INDEX "personinfo_person_id"
ON "person_info" ("person_id")
Drop
personinfo_user_id user_id SQL 
CREATE INDEX "personinfo_user_id"
ON "person_info" ("user_id")
Drop