Skip to content

Change log — July 2026

DateSurfaceEventProvenance
2026-07-01SCHEMAnew migration 20260628180855_id131_predebris_wipe.sql — feat(id-131): land OKF id-131..135 umbrella + restore Platform migration integrity (#110)40d3f24
2026-07-01SCHEMAnew migration 20260628190000_id131_record_lifecycle_facet.sql — feat(id-131): land OKF id-131..135 umbrella + restore Platform migration integrity (#110)40d3f24
2026-07-01SCHEMAnew migration 20260628190001_id131_record_embeddings_store.sql — feat(id-131): land OKF id-131..135 umbrella + restore Platform migration integrity (#110)40d3f24
2026-07-01SCHEMAnew migration 20260628191700_id131_sd_classification_cols.sql — feat(id-131): land OKF id-131..135 umbrella + restore Platform migration integrity (#110)40d3f24
2026-07-01SCHEMAnew migration 20260628191701_id131_record_lifecycle_domain_sync.sql — feat(id-131): land OKF id-131..135 umbrella + restore Platform migration integrity (#110)40d3f24
2026-07-01SCHEMAnew migration 20260628191702_id131_cite_enum_values.sql — feat(id-131): land OKF id-131..135 umbrella + restore Platform migration integrity (#110)40d3f24
2026-07-01SCHEMAnew migration 20260628191703_id131_cite_ext_winrate_fix.sql — feat(id-131): land OKF id-131..135 umbrella + restore Platform migration integrity (#110)40d3f24
2026-07-01SCHEMAnew migration 20260628191704_id131_sd_content_type_nullable.sql — feat(id-131): land OKF id-131..135 umbrella + restore Platform migration integrity (#110)40d3f24
2026-07-01SCHEMAnew migration 20260628200000_id131_extract_reparent.sql — feat(id-131): land OKF id-131..135 umbrella + restore Platform migration integrity (#110)40d3f24
2026-07-01SCHEMAnew migration 20260628200001_id131_extract_reparent_api_regen.sql — feat(id-131): land OKF id-131..135 umbrella + restore Platform migration integrity (#110)40d3f24
2026-07-01SCHEMAnew migration 20260628200002_id131_fix_orphan_entity_rels_rpc.sql — feat(id-131): land OKF id-131..135 umbrella + restore Platform migration integrity (#110)40d3f24
2026-07-02SCHEMAnew migration 20260702120000_id131_search_rpcs.sql — feat(id-131.11): G-SEARCH M5 search RPCs — polymorphic hybrid_search + typed re-homes266c8d6
2026-07-02SCHEMAnew migration 20260702120001_id131_drop_inline_vector_cols.sql — feat(id-131.11): G-SEARCH M5 search RPCs — polymorphic hybrid_search + typed re-homes266c8d6
2026-07-03SCHEMAnew migration 20260703150000_id131_form_response_rpc.sql — feat(id-131.16): G-FORMS — forms matching onto q_a_pairs/RI/SD (BI-29/30/31)0358eca
2026-07-03SCHEMAnew migration 20260703140000_id131_company_embedding_migrate.sql — feat(id-131.11): company_embedding EMB-STORE completeness (T4-OQ-1 MIGRATE)e4ffbf5
2026-07-03SCHEMAnew migration 20260702130000_id131_freshness_rpcs.sql — feat(id-131.12): G-GOV-FACET-A — freshness/review RPCs over record_lifecycle6b20dda
2026-07-04SCHEMAnew migration 20260704120000_id138_writer_fence_lease.sql — fix(id-138.9): replace writer-fence advisory lock with pooling-safe lease (S445)86c2019
2026-07-04SCHEMAnew migration 20260704120000_id131_drop_dedup_family.sql — fix(id-131.15): G-DEDUP — retire the legacy content_items dedup family end-to-end8691f42
2026-07-04SCHEMAnew migration 20260704130000_id131_verification_history_reparent.sql — fix(id-131.29): verification_history RE-PARENT + companion api regen + consumer re-point4ce1243
2026-07-04SCHEMAnew migration 20260703210000_id138_api_rpc_wrappers.sql — fix(id-138): api RPC wrappers for corpus writer-fence, erasure cascade, identity resolver1cc9c01
2026-07-04SCHEMAnew migration 20260703200000_id138_sd_source_binding_api_regen.sql — fix(id-138.5): companion api.source_documents regen for source-binding cols2276036
2026-07-04SCHEMAnew migration 20260703190000_id131_preapply_api_view_addcol_regen.sql — fix(id-131.34): G-API-HOTFIX — regen api views stale from un-projected ADD COLUMNs0ef7cb0
2026-07-04SCHEMAnew migration 20260703180000_id131_preapply_iql_fn_readers.sql — fix(id-131.32): G-PRE-APPLY-131.13 — residual ingestion_quality_log.content_item_id SQL+Python readers4867f76
2026-07-04SCHEMAnew migration 20260703160400_id138_writer_fence.sql — feat(id-138.9): cross-language writer-fence (advisory-lock RPC + TS/Python helpers)756cf8c
2026-07-04SCHEMAnew migration 20260703160200_id138_erasure_cascade_fn.sql — feat(id-138.7): M3/M4 tombstone cascade + orphan reaper + citations preflight (GDPR-coherent)313970d
2026-07-04SCHEMAnew migration 20260703160300_id138_orphan_reaper_fn.sql — feat(id-138.7): M3/M4 tombstone cascade + orphan reaper + citations preflight (GDPR-coherent)313970d
2026-07-04SCHEMAnew migration 20260703160100_id138_admission_identity_fn.sql — feat(id-138.6): M2 resolve_or_mint_source_identity fn (content_hash-first, uuid5 SEED-CONTRACT)8fd0370
2026-07-04SCHEMAnew migration 20260703160000_id138_sd_source_binding_cols.sql — feat(id-138.5): M1 source-binding register + admission lifecycle schema456b7ad
2026-07-04SCHEMAnew migration 20260703160000_id131_govfacet_b_rpcs.sql — fix(id-131.13): G-GOV-FACET-B — SQL RPC re-points + DR-012 derived-pairs route261664a
2026-07-04SCHEMAnew migration 20260703170000_id131_entity_fns.sql — fix(id-131.14): G-GOV-FACET-C — entity fns + dashboard counts re-point (SQL-only)b83cad3
2026-07-05SCHEMAnew migration 20260706180000_id131_revoke_anon_promotion_candidates.sql — fix(id-131.19): restore anon-EXECUTE denial on promotion_candidates ({59.21} P-4)97d4e00
2026-07-05SCHEMAnew migration 20260706170000_id131_qa_fns_record_embeddings_repoint.sql — fix(id-131.19): re-point q_a_search/promotion_candidates/match_recompute onto record_embeddingsd895674
2026-07-05SCHEMAnew migration 20260706160000_bl398_governance_tombstone_filter.sql — fix(bl-398): exclude tombstoned source_documents from governance/review reads7504fa1
2026-07-05SCHEMAnew migration 20260706140000_id131_drop_legacy_hybrid_search.sql — fix(id-131.19): drop legacy 6-param hybrid_search overload (PGRST203)ad74726
2026-07-05SCHEMAnew migration 20260706150000_id131_api_views_regen2.sql — fix(id-131.19): drop legacy 6-param hybrid_search overload (PGRST203)ad74726
2026-07-05SCHEMAnew migration 20260706125000_id131_drop_find_related_items_wrapper.sql — feat(id-131.19): M6 GO tail — apply fixes, wrapper reap, M-API regen, types7abf709
2026-07-05SCHEMAnew migration 20260706130000_id131_api_views_regen.sql — feat(id-131.19): M6 GO tail — apply fixes, wrapper reap, M-API regen, types7abf709
2026-07-05SCHEMAnew migration 20260706103000_id131_attention_counts_rewrite.sql — chore(id-131.19): un-quarantine GO migrations for the M6 apply sequencec5f3afd
2026-07-05SCHEMAnew migration 20260706104000_id131_coverage_retire.sql — chore(id-131.19): un-quarantine GO migrations for the M6 apply sequencec5f3afd
2026-07-05SCHEMAnew migration 20260706110000_id131_drops.sql — chore(id-131.19): un-quarantine GO migrations for the M6 apply sequencec5f3afd
2026-07-05SCHEMAnew migration 20260706120000_id131_drop_inline_vector_cols.sql — chore(id-131.19): un-quarantine GO migrations for the M6 apply sequencec5f3afd
2026-07-05SCHEMAnew migration 20260706110000_id131_drops.sql — feat(id-131.19): GO-PREP — re-sequence facet-mint, author M6 drops, generator edits7b13f64
2026-07-05SCHEMAnew migration 20260706120000_id131_drop_inline_vector_cols.sql — feat(id-131.19): GO-PREP — re-sequence facet-mint, author M6 drops, generator edits7b13f64
2026-07-05SCHEMAnew migration 20260705100000_id131_facet_mint.sql — feat(id-131.38): author FACET-MINT — backfill + forward-mint record_lifecycle rows8d44103
2026-07-05SCHEMAnew migration 20260705110000_id138_corpus_bucket_rls.sql — feat(id-138.18): author storage.objects RLS for the corpus bucket862f7af
2026-07-05SCHEMAnew migration 20260704220000_id131_merge_item_metadata_sd.sql — fix(id-131.17): re-point SD-metadata writer KEEP-list onto source_documents + merge_item_metadata SD rewrite21895f1
2026-07-05SCHEMAnew migration 20260704221000_id131_drop_ims_fns.sql — feat(id-131.17): delete deprecated IMS browse/item surface + author id131_drop_ims_fns migration16a6794
2026-07-07SCHEMAnew migration 20260707210000_fix_get_guide_content_content_items_residue.sql — fix(guides): strip content_items residue from get_guide_content (live P0)6ab55cc
2026-07-07SCHEMAnew migration 20260707200000_id130_form_requirement_embedding_migrate.sql — feat(id-130.24): migrate form_template_requirements.requirement_embedding into record_embeddings92be9cb
2026-07-07SCHEMAnew migration 20260707190600_id61_dr035_set_config_signature_match.sql — fix(id-61.14): harden set_config exemption to exact signature match + unit-test anon filtere462242
2026-07-07SCHEMAnew migration 20260707190000_id61_dr035_revoke_sweep.sql — feat(id-61.14): DR-035 anon-EXECUTE hardening — default privileges + audit/REVOKE sweepf8827ad
2026-07-07SCHEMAnew migration 20260707190500_id61_dr035_default_privileges.sql — feat(id-61.14): DR-035 anon-EXECUTE hardening — default privileges + audit/REVOKE sweepf8827ad
2026-07-07SCHEMAnew migration 20260707140000_id138_promotion_candidates_published_diff.sql — feat(id-138.17): promotion-candidates re-selection surfaces published-pair re-walk diffs as proposals9cc7789
2026-07-08SCHEMAnew migration 20260708170000_id130_rename_history_source_content_ids.sql — feat(id-130.30): rename form_response_history.source_content_ids to source_record_idsb068562
2026-07-08SCHEMAnew migration 20260708150000_id130_extraction_method_allow_mcp_create.sql — fix(id-130.23): FC-60/65 idempotency + extraction_method allowlist (B1) + fixtures.ts content_items re-point (B2)269bf81
2026-07-08SCHEMAnew migration 20260708140000_id130_procurement_rollup_api_rpc.sql — fix(id-130.29): api.get_procurement_rollup read path + route re-point + 130.20 rollup coverage1e633e2
2026-07-08SCHEMAnew migration 20260708160000_id139_reference_ingest_record_embeddings_repoint.sql — fix(id-139.10): re-point reference_ingest off dropped embedding column0013b67
2026-07-08SCHEMAnew migration 20260708130000_id130_rename_content_ids_columns.sql — refactor(id-130.28): rename matched_content_ids/source_content_ids to matched_record_ids/source_record_idsa2cdf09
2026-07-08SCHEMAnew migration 20260708120000_id130_form_template_id_backfill_guard.sql — fix(id-130.27): stamp form_template_id at form_questions creation sites + backfill + harden093ec5b
2026-07-10SCHEMAnew migration 20260710221255_id144_hybrid_search_projection_filters.sql — feat(id-144.5): complete hybrid_search 24-col/12-arg + api wrapper + type regenb868964
2026-07-10SCHEMAnew migration 20260710221734_id144_hybrid_search_api_wrapper.sql — feat(id-144.5): complete hybrid_search 24-col/12-arg + api wrapper + type regenb868964
2026-07-10SCHEMAnew migration 20260710190000_bl431_obs3_hybrid_search_tiebreak.sql — fix(bl-431): hybrid_search deterministic pagination tie-breaker (OBS-3)ce19bf6
2026-07-10SCHEMAnew migration 20260709234230_id57_clamp_question_match_embedding_score.sql — fix(id-57.9): clamp embedding_score in question_match_recompute (+q_a_search audit)92382de
2026-07-10SCHEMAnew migration 20260709222755_id135_api_get_document_version_chain.sql — fix(id-135.24): api-schema wrapper for get_document_version_chain (PGRST202 -> 500)dc9d133
2026-07-12SCHEMAnew migration 20260712065000_id145_bi8_retire_bid_creation_label.sql — fix(id-145.27): retire the ‘bid’ form_type CV creation label (BI-8/BI-12)df703a4
2026-07-12SCHEMAnew migration 20260712060000_id145_w1a_qa_pairs_lineage_migrate.sql — feat(id-145.6): author the W1 migration batch (M1-M6) — form-first rename/reshape36abc68
2026-07-12SCHEMAnew migration 20260712061000_id145_w1b_purge_null_ftid_questions.sql — feat(id-145.6): author the W1 migration batch (M1-M6) — form-first rename/reshape36abc68
2026-07-12SCHEMAnew migration 20260712062000_id145_w1c_rename_reshape.sql — feat(id-145.6): author the W1 migration batch (M1-M6) — form-first rename/reshape36abc68
2026-07-12SCHEMAnew migration 20260712063000_id145_w1d_api_regen.sql — feat(id-145.6): author the W1 migration batch (M1-M6) — form-first rename/reshape36abc68
2026-07-12SCHEMAnew migration 20260712064000_id145_w1e_drop_workspace_stratum.sql — feat(id-145.6): author the W1 migration batch (M1-M6) — form-first rename/reshape36abc68
2026-07-15SCHEMAnew migration 20260715182216_id145_w2_fix_qa_pairs_history_trigger_dropped_column.sql — fix(id-145.23): round-2 column re-key sweep to tsc-zero + workspaces-table runtime re-pointsca5fe06
2026-07-15SCHEMAnew migration 20260715182736_id145_w2_fix_qa_get_verbatim_dropped_column.sql — fix(id-145.23): round-2 column re-key sweep to tsc-zero + workspaces-table runtime re-pointsca5fe06
2026-07-15SCHEMAnew migration 20260712066000_id145_form_question_embedding_owner_kind.sql — feat(id-145.29): persist question embeddings under record_embeddings.owner_kind=form_questionb11bde8
2026-07-16SCHEMAnew migration 20260716150000_id132_entity_updated_at.sql — chore(id-145.35): adopt id-132.40 migration file from main (staging parity)2c4a6ec
2026-07-16SCHEMAnew migration 20260716150000_id145_35_api_views_engagement_groups.sql — fix(id-145.35): expose engagement_group tables via api views (S481 live-500 fix)73b7b58
2026-07-16SCHEMAnew migration 20260716130000_id147_form_instance_fields_geometry.sql — feat(id-147.10): geometry migration + analyse_form writer persistencecb68260
2026-07-16SCHEMAnew migration 20260716125000_id145_34_api_promotion_dispositions.sql — chore(id-145.34): hand-author api.promotion_dispositions companion view (regen2 predates table)614e7be
2026-07-16SCHEMAnew migration 20260716130000_id145_35_engagement_group_content.sql — feat(id-145.35): engagement_group_content link table + group-side batch assign + rewire bulk toolbarea56563
2026-07-16SCHEMAnew migration 20260716111053_id145_145_34_promotion_dispositions.sql — feat(id-145.34): append-only promotion disposition audit + reject suppression2dff2af
2026-07-16SCHEMAnew migration 20260716113306_id147_form_attachments.sql — feat(id-147.7): author form_attachments migration (DDL only, not pushed)efe1f75
2026-07-16SCHEMAnew migration 20260716120000_id152_verification_history_polymorphic.sql — fix(id-152): owner-aware /api/review/action existence lookup — un-404 /library Bulk Verify2770b15
2026-07-16SCHEMAnew migration 20260716120000_id145_37_repoint_search_rpcs_to_form_instances.sql — fix(id-145.37): re-point search RPC family off dropped form_templates onto form_instances9b77115
2026-07-17SCHEMAnew migration 20260717164512_id142_bl496_ingest_source_drop_default.sql — fix(s485): drop invalid form_instances.ingest_source DEFAULT (bl-496 -> id-142)23a06bc
2026-07-17SCHEMAnew migration 20260717150000_id128_writer_fence_test_isolation.sql — fix(128.20): isolate id138-writer-fence integration test from prod fence8111cff
2026-07-17SCHEMAnew migration 20260717112347_id145_api_views_regen3.sql — feat(145.23): regen api-views surface post-W1 — re-point generator to 20260717112347_id145_api_views_regen3.sql8c9b7ab
2026-07-25SCHEMAnew migration 20260725143717_id128_claim_next_job_test_isolation.sql — fix(queue): scope claim_next_job so tests cannot claim live jobs (128.21)66751ff
2026-07-25SCHEMAnew migration 20260724233500_id347_anon_lockdown.sql — fix(security): close unauthenticated Data API reads (id-347)708fa8c
2026-07-26REGISTER57 register mutations in bulk — feat(decisions): split the register into one file per decision + generated indexbee5bb7
2026-07-26REGISTER54 register mutations in bulk — fix(decisions): tombstone 42 swept ids; apply the S498 audit evictions + correctionsffe18ce
2026-07-26SCHEMAnew migration 20260726120000_ensure_rls_event_trigger.sql — feat(db): carry Supabase’s ensure_rls event trigger in the migration chain8290560
2026-07-27REGISTERDR-003 status retired → supersededd8866a9
2026-07-27REGISTERDR-024 status retired → supersededd8866a9
2026-07-27REGISTER10 register mutations in bulk — docs(decisions): apply the S499 owner rulings — five re-accepts, DR-098, re-homes, DR-085 amendmentf75199f
2026-07-27REGISTERDR-099 added (accepted) — Every processing_queue consumer passes an explicit type scope to claim_next_job (include list for special-purpose workers, exclude list for the general cron consumer); an unscoped global claim is a defect, not a default0d65f10
2026-07-27REGISTERDR-100 added (accepted) — ast-dataflow’s warm path is a long-lived MCP server process holding the ts-morph Project; the LMDB facts-cache design is rejected by measurement, and .mcp.json registration waits for the extraction phase4903ed0
2026-07-27REGISTERDR-101 added (accepted) — ledgers/initiatives/.md numbered records are THE initiative record and the only home of task placement; initiatives// docs are published theme documentation carrying no task links and needing no substrate_doc pointer to be correctly filed01d2bcc
2026-07-27SCHEMAnew migration 20260726231847_id372_claim_next_job_type_scoping.sql — fix(queue): type-scoped claims for both queue consumers (id-372 {372.2})4641bd4
2026-07-28REGISTER9 register mutations in bulk — docs(register): S504 register sweep applied — 9 tombstones, escalations ruled, F1/F2/F9’ patchedd31fac0
2026-07-29REGISTERDR-102 added (accepted) — Cross-surface wiring verdicts join through a versioned evidence-sidecar contract (v1) rather than in-process integration, and declared-as-data schema declarations (TableSchema et al.) can only ever be indirect evidence — declared-but-never-written columns verdict undecid…11a4397
2026-07-29SCHEMAnew migration 20260729185524_id370_promotion_candidates_answered_predicate.sql — feat(census)+fix(pipeline): id-399 census protocol + id-370 unanswered-question routing (S511) (#153)369edcd
2026-07-29SCHEMAnew migration 20260729210500_id398_emer_registry_keyed_reseed.sql — feat(pipeline): id-398 F4 — re-seed engine-path em:/er: PKs on source_document_id (#155)b0b72a0
2026-07-29WORKFLOWcontinuation prompts now record parallel-lane shared state (foreign docs-site changes, mempalace health, live peer writers)ac74b21
2026-07-30REGISTERDR-103 added (accepted) — Any script that deletes or rewrites database rows refuses to run unless its target is positively confirmed against an explicitly-supplied expected identifier; absence of a guard input is a refusal, never a pass, and denylist-only guards (refuse prod) are insufficient on …d2e3eb9
2026-07-30REGISTERDR-104 added (accepted) — In rebase-class work, the ratified reference set is the authority; existing code is evidence of what exists, never of what is correct0a9be68
2026-07-30REGISTERDR-105 added (accepted) — The admin-merge pin is one jsonb marker on entity_mentions, matched on effective entity type, honoured by every walk-side consumer0a9be68
2026-07-30SCHEMAnew migration 20260730150743_id405_pin_entity_mentions_rpc.sql — feat(entities): id-405 — jsonb_set RPC for merge-route curation pinning (+ effective-type pin fix) (#157)5028f6e
2026-07-30WORKFLOWthe start-sessio… (truncated)#160, cbf1b66
2026-07-30REGISTERDR-106 added (accepted) — DR-104 says ratified docs outrank code; this names the doc families that are NOT ratified authority, and the two citation failures that follow from assuming they areac52d20
2026-07-30REGISTERDR-107 added (accepted) — An unauthenticated endpoint that returns an exception message substitutes the live values of known-sensitive env vars; pattern-matching credential shapes is a backstop, never the controlac52d20
2026-07-30REGISTERDR-108 added (accepted) — Re-ingest history lives on a separate append-only register-history table, generalising the DR-076 verification_history shape; source_documents.parent_id chaining is not adoptedac52d20
2026-07-30REGISTERDR-109 added (accepted) — pipeline_runs counter columns are not decided in isolation; the deferred ledger-api spec is revived as v1.1 and settles the rollup shape with the per-stage detail surfaceac52d20
2026-07-31REGISTERDR-110 added (accepted) — hnsw:sync_threshold is pinned to 1000 (tolerance 2000) in collection_metadata; repair —mode from-sqlite resets it to 2 (tolerance 4) and silently re-arms the vector-search outage6ec059c