Query

db.sqlite3 — core_system_configuration

SQL

CREATE TABLE "core_system_configuration"  (
  "id" integer NOT NULL PRIMARY KEY AUTOINCREMENT,
  "server_name" varchar(100) NOT NULL,
  "default_header_template" text NOT NULL,
  "use_header_by_default" bool NOT NULL,
  "default_fetch_interval" integer NOT NULL,
  "created_at" datetime NOT NULL,
  "updated_at" datetime NOT NULL
)

+ Add column

Columns

Column Data type Allow null Primary key Actions
id INTEGER ✓ Rename | Drop
server_name varchar(100) Rename | Drop
default_header_template TEXT Rename | Drop
use_header_by_default bool Rename | Drop
default_fetch_interval INTEGER Rename | Drop
created_at datetime Rename | Drop
updated_at datetime Rename | Drop

+ Add index

Indexes

Name Columns Unique SQL Drop?