Query

db.sqlite3 — core_servicemessagete...

SQL

CREATE TABLE "core_servicemessagetemplate"  (
  "id" integer NOT NULL PRIMARY KEY AUTOINCREMENT,
  "message_type" varchar(20) NOT NULL,
  "subject" varchar(200) NOT NULL,
  "message" text NOT NULL,
  "activation_url" varchar(200) NULL,
  "created_at" datetime NOT NULL,
  "updated_at" datetime NOT NULL,
  "service_instance_id" bigint NOT NULL REFERENCES "core_services" ("id") DEFERRABLE INITIALLY DEFERRED
)

+ 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
activation_url varchar(200) ✓ Rename | Drop
created_at datetime Rename | Drop
updated_at datetime Rename | Drop
service_instance_id bigint Rename | Drop

Foreign Keys

Column Destination
service_instance_id core_services.id

+ Add index

Indexes

Name Columns Unique SQL Drop?
core_servicemessagetemplate_service_instance_id_95c045ce service_instance_id SQL 
CREATE INDEX "core_servicemessagetemplate_service_instance_id_95c045ce"
ON "core_servicemessagetemplate" ("service_instance_id")
Drop
core_servicemessagetemplate_service_instance_id_message_type_2f1913d2_uniq
  • service_instance_id
  • message_type
 ✓ SQL 
CREATE UNIQUE INDEX "core_servicemessagetemplate_service_instance_id_message_type_2f1913d2_uniq"
ON "core_servicemessagetemplate" ("service_instance_id", "message_type")
Drop