mirror of
https://github.com/lobehub/lobe-chat.git
synced 2026-06-14 03:30:19 +00:00
Arvin Xu
ee6a74ba06
🗃️ feat(db): delivery-checker schema + ai_providers/ai_models surrogate `_id` The DB layer, split out so it merges ahead of its callers (services / TRPC / store / UI ship in a follow-up stacked PR). One consolidated, idempotent migration (0110_add_verify_tables_and_ai_infra_id): - verify delivery-checker: verify_criteria / verify_rubrics (+ config) / verify_rubric_criteria / verify_check_results tables + verify_status / verify_plan / verify_plan_confirmed_at columns on agent_operations; plus the verify domain types/vocab/config in @lobechat/types the schema imports. All four verify tables carry a workspace_id FK + index (cascade on workspace delete), matching documents / agent_operations. verify_check_results has a UNIQUE (operation_id, check_item_id) index — one lifecycle row per plan item per run, so a retry / concurrent worker can't create conflicting duplicates. - ai-infra (LOBE-10072): nullable `_id uuid DEFAULT gen_random_uuid()` on ai_providers / ai_models, written as the safe two-step form (ADD nullable, then SET DEFAULT) to avoid a full-table rewrite + ACCESS EXCLUSIVE lock; backfill + NOT NULL are later manual steps (LOBE-10073 / LOBE-10074) Co-authored-by: Claude Opus 4.8 <noreply@anthropic.com>