Query

db.sqlite3 — core_services

SQL

CREATE TABLE "core_services"  (
  "id" integer NOT NULL PRIMARY KEY AUTOINCREMENT,
  "name" varchar(100) NOT NULL,
  "incoming_enabled" bool NOT NULL,
  "outgoing_enabled" bool NOT NULL,
  "sender_filter" varchar(20) NOT NULL,
  "config" text NOT NULL CHECK ((JSON_VALID("config") OR "config" IS NULL)),
  "app_config" varchar(255) NOT NULL,
  "created_at" datetime NOT NULL,
  "updated_at" datetime NOT NULL,
  "plugin_id" bigint NOT NULL REFERENCES "core_plugins" ("id") DEFERRABLE INITIALLY DEFERRED
)

+ Add column

Columns

Column Data type Allow null Primary key Actions
id INTEGER ✓ Rename | Drop
name varchar(100) Rename | Drop
incoming_enabled bool Rename | Drop
outgoing_enabled bool Rename | Drop
sender_filter varchar(20) Rename | Drop
config TEXT Rename | Drop
app_config varchar(255) Rename | Drop
created_at datetime Rename | Drop
updated_at datetime Rename | Drop
plugin_id bigint Rename | Drop

Foreign Keys

Column Destination
plugin_id core_plugins.id

+ Add index

Indexes

Name Columns Unique SQL Drop?
core_services_plugin_id_e2069291 plugin_id SQL 
CREATE INDEX "core_services_plugin_id_e2069291"
ON "core_services" ("plugin_id")
Drop