Query

db.sqlite3 — core_plugins

SQL

CREATE TABLE "core_plugins"  (
  "id" integer NOT NULL PRIMARY KEY AUTOINCREMENT,
  "name" varchar(100) NOT NULL UNIQUE,
  "friendly_name" varchar(100) NOT NULL,
  "version" varchar(20) NOT NULL,
  "manifest" text NOT NULL CHECK ((JSON_VALID("manifest") OR "manifest" IS NULL)),
  "enabled" bool 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
name varchar(100) Rename | Drop
friendly_name varchar(100) Rename | Drop
version varchar(20) Rename | Drop
manifest TEXT Rename | Drop
enabled bool Rename | Drop
created_at datetime Rename | Drop
updated_at datetime Rename | Drop

+ Add index

Indexes

Name Columns Unique SQL Drop?
sqlite_autoindex_core_plugins_1 name ✓ SQL
-- no sql found --
 Drop