Query

db.sqlite3 — core_message_queue

SQL

CREATE TABLE "core_message_queue"  (
  "id" integer NOT NULL PRIMARY KEY AUTOINCREMENT,
  "raingull_id" char(32) NOT NULL,
  "priority" integer NOT NULL,
  "status" varchar(20) NOT NULL,
  "retry_count" integer NOT NULL,
  "last_retry_at" datetime NULL,
  "error_message" text NULL,
  "created_at" datetime NOT NULL,
  "updated_at" datetime NOT NULL,
  "completed_at" datetime NULL,
  "formatted_message_id" bigint NOT NULL REFERENCES "core_formatted_messages" ("id") DEFERRABLE INITIALLY DEFERRED,
  "user_id" varchar(8) NOT NULL REFERENCES "core_users" ("uuid") DEFERRABLE INITIALLY DEFERRED,
  "service_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
raingull_id char(32) Rename | Drop
priority INTEGER Rename | Drop
status varchar(20) Rename | Drop
retry_count INTEGER Rename | Drop
last_retry_at datetime ✓ Rename | Drop
error_message TEXT ✓ Rename | Drop
created_at datetime Rename | Drop
updated_at datetime Rename | Drop
completed_at datetime ✓ Rename | Drop
formatted_message_id bigint Rename | Drop
user_id varchar(8) Rename | Drop
service_id bigint Rename | Drop

Foreign Keys

Column Destination
service_id core_services.id
user_id core_users.uuid
formatted_message_id core_formatted_messages.id

+ Add index

Indexes

Name Columns Unique SQL Drop?
core_messag_raingul_787603_idx
  • raingull_id
  • user_id
  • service_id
 SQL 
CREATE INDEX "core_messag_raingul_787603_idx"
ON "core_message_queue" ("raingull_id", "user_id", "service_id")
Drop
core_messag_status_da4b56_idx
  • status
  • priority
  • created_at
 SQL 
CREATE INDEX "core_messag_status_da4b56_idx"
ON "core_message_queue" ("status", "priority", "created_at")
Drop
core_message_queue_formatted_message_id_8f6a9880 formatted_message_id SQL 
CREATE INDEX "core_message_queue_formatted_message_id_8f6a9880"
ON "core_message_queue" ("formatted_message_id")
Drop
core_message_queue_raingull_id_0971cae9 raingull_id SQL 
CREATE INDEX "core_message_queue_raingull_id_0971cae9"
ON "core_message_queue" ("raingull_id")
Drop
core_message_queue_service_id_94e742db service_id SQL 
CREATE INDEX "core_message_queue_service_id_94e742db"
ON "core_message_queue" ("service_id")
Drop
core_message_queue_user_id_d774d873 user_id SQL 
CREATE INDEX "core_message_queue_user_id_d774d873"
ON "core_message_queue" ("user_id")
Drop