Query

db.sqlite3 — core_audit_log

SQL

CREATE TABLE "core_audit_log"  (
  "id" integer NOT NULL PRIMARY KEY AUTOINCREMENT,
  "event_type" varchar(50) NOT NULL,
  "service_name" varchar(100) NULL,
  "status" varchar(20) NOT NULL,
  "details" text NOT NULL,
  "created_at" datetime NOT NULL
)

+ Add column

Columns

Column Data type Allow null Primary key Actions
id INTEGER ✓ Rename | Drop
event_type varchar(50) Rename | Drop
service_name varchar(100) ✓ Rename | Drop
status varchar(20) Rename | Drop
details TEXT Rename | Drop
created_at datetime Rename | Drop

+ Add index

Indexes

Name Columns Unique SQL Drop?