0000_delivery_outbox_init.up.sql (1079B)
1 CREATE TABLE myc_delivery_outbox ( 2 job_id TEXT PRIMARY KEY, 3 kind TEXT NOT NULL, 4 status TEXT NOT NULL, 5 event_json TEXT NOT NULL, 6 relay_urls_json TEXT NOT NULL, 7 connection_id TEXT, 8 request_id TEXT, 9 attempt_id TEXT, 10 signer_publish_workflow_id TEXT, 11 publish_attempt_count INTEGER NOT NULL, 12 last_error TEXT, 13 created_at_unix INTEGER NOT NULL, 14 updated_at_unix INTEGER NOT NULL, 15 published_at_unix INTEGER, 16 finalized_at_unix INTEGER 17 ); 18 19 CREATE INDEX idx_myc_delivery_outbox_status 20 ON myc_delivery_outbox(status, created_at_unix, job_id); 21 22 CREATE INDEX idx_myc_delivery_outbox_connection_id 23 ON myc_delivery_outbox(connection_id, created_at_unix, job_id); 24 25 CREATE INDEX idx_myc_delivery_outbox_request_id 26 ON myc_delivery_outbox(request_id, created_at_unix, job_id); 27 28 CREATE INDEX idx_myc_delivery_outbox_attempt_id 29 ON myc_delivery_outbox(attempt_id, created_at_unix, job_id); 30 31 CREATE INDEX idx_myc_delivery_outbox_signer_workflow_id 32 ON myc_delivery_outbox(signer_publish_workflow_id, created_at_unix, job_id);