Query

db.sqlite3 — core_systemmessagetemplate

SQL

CREATE TABLE "core_systemmessagetemplate"  (
  "id" integer NOT NULL PRIMARY KEY AUTOINCREMENT,
  "message_type" varchar(20) NOT NULL UNIQUE,
  "subject" varchar(200) NOT NULL,
  "message" text 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
message_type varchar(20) Rename | Drop
subject varchar(200) Rename | Drop
message TEXT Rename | Drop
created_at datetime Rename | Drop
updated_at datetime Rename | Drop

+ Add index

Indexes

Name Columns Unique SQL Drop?
sqlite_autoindex_core_systemmessagetemplate_1 message_type ✓ SQL
-- no sql found --
 Drop