superidou
5759c1862e
M0-M7 已完成:核心网关(身份/RBAC/TOTP/OIDC/SAML/Provider/配额/路由/内容策略/审计/定价)+ 资源市场(MCP/Skills/数字员工)。 含 22 个 PostgreSQL 迁移、管理端/门户端前端源码、OpenAPI 契约、部署 compose。 Co-Authored-By: Claude <noreply@anthropic.com>
15 lines
635 B
SQL
15 lines
635 B
SQL
ALTER TABLE gateway.outbox_events
|
|
ADD COLUMN IF NOT EXISTS dead_lettered_at timestamptz,
|
|
ADD COLUMN IF NOT EXISTS published_stream_id text;
|
|
|
|
CREATE INDEX IF NOT EXISTS outbox_events_claimable_idx
|
|
ON gateway.outbox_events (available_at, occurred_at)
|
|
WHERE processed_at IS NULL AND dead_lettered_at IS NULL;
|
|
|
|
CREATE INDEX IF NOT EXISTS outbox_events_dead_letter_idx
|
|
ON gateway.outbox_events (dead_lettered_at DESC)
|
|
WHERE dead_lettered_at IS NOT NULL;
|
|
|
|
COMMENT ON COLUMN gateway.outbox_events.published_stream_id IS
|
|
'Redis Stream entry ID, or duplicate when the event marker proved it was already published.';
|