16 lines
560 B
PL/PgSQL
16 lines
560 B
PL/PgSQL
|
BEGIN;
|
||
|
|
|
||
|
|
ALTER TABLE outbox_event
|
||
|
|
ADD COLUMN public_id uuid NOT NULL DEFAULT gen_random_uuid(),
|
||
|
|
ADD COLUMN manual_retry_count integer NOT NULL DEFAULT 0,
|
||
|
|
ADD COLUMN last_manual_retry_at timestamptz,
|
||
|
|
ADD COLUMN last_manual_retry_by uuid REFERENCES user_account(id),
|
||
|
|
ADD CONSTRAINT outbox_event_manual_retry_count_check CHECK (manual_retry_count >= 0),
|
||
|
|
ADD CONSTRAINT outbox_event_public_id_key UNIQUE (public_id);
|
||
|
|
|
||
|
|
CREATE INDEX outbox_event_tenant_dead_idx
|
||
|
|
ON outbox_event(tenant_id,created_at DESC)
|
||
|
|
WHERE status='dead';
|
||
|
|
|
||
|
|
COMMIT;
|