Verify bots table has scope_uuid for all rows

Type: sql Component: rpe-context-assembler Tags: bots,scope-uuid,p1.7,migration-016 Assertion: contains Last result:
Validates

Confirms migration 016_bots_scope_uuid.sql has run and all bots have stable UUIDs for relationship_members identity. Required for Layer 2 of P1.7 block.

Assertion Value
OK
Expected Output
All rows show status=OK. Zoey row has scope_uuid = 7fdb25fe-3546-11f1-9125-9eff0c6a0301. No NULL scope_uuid rows.
Script
SELECT id, bot_name, scope_uuid, CASE WHEN scope_uuid IS NULL THEN 'MISSING' ELSE 'OK' END AS status FROM zoey_core.bots ORDER BY id;
Run Tool

Run History

No runs yet