Query

MaiBot.db — online_time

SQL

CREATE TABLE "online_time"  (
  "id" INTEGER NOT NULL PRIMARY KEY,
  "timestamp" TEXT NOT NULL,
  "duration" INTEGER NOT NULL,
  "start_timestamp" DATETIME NOT NULL,
  "end_timestamp" DATETIME NOT NULL
)

+ Add column

Columns

Column Data type Allow null Primary key Actions
id INTEGER ✓ Rename | Drop
timestamp TEXT Rename | Drop
duration INTEGER Rename | Drop
start_timestamp DATETIME Rename | Drop
end_timestamp DATETIME Rename | Drop

+ Add index

Indexes

Name Columns Unique SQL Drop?
onlinetime_end_timestamp end_timestamp SQL 
CREATE INDEX "onlinetime_end_timestamp"
ON "online_time" ("end_timestamp")
Drop