10 lines
461 B
SQL
10 lines
461 B
SQL
-- Migration: Add 'flagged' status to relay_event_queue
|
|
-- Fixes infinite re-review loop (#27): AI-flagged events now transition to
|
|
-- status='flagged' instead of staying 'pending', so processPending() skips them.
|
|
--
|
|
-- The status column is plain TEXT (not a Postgres enum), so no ALTER TYPE is
|
|
-- needed. This migration adds an index for admin queries on flagged events.
|
|
|
|
CREATE INDEX IF NOT EXISTS idx_relay_event_queue_status
|
|
ON relay_event_queue(status);
|