forked from mtusi2026/mtusi2026lab5
8 lines
299 B
SQL
8 lines
299 B
SQL
CREATE TABLE IF NOT EXISTS outbox (
|
|
id UUID PRIMARY KEY,
|
|
job_id UUID NOT NULL,
|
|
payload JSONB NOT NULL,
|
|
created_at TIMESTAMPTZ NOT NULL DEFAULT now(),
|
|
published_at TIMESTAMPTZ
|
|
);
|
|
CREATE INDEX IF NOT EXISTS idx_outbox_unpublished ON outbox(published_at) WHERE published_at IS NULL; |