## Purpose

This bundle started as the clean production-facing subset of the earlier
pack-apply repair work. After the first reset-branch and follow-up reruns, the
remaining blocker set proved that the verify-convergence SQL from the earlier
bundle is still required to drive the branch-backed workflow to green, so the
verified `001`-`007` followups are restored here as well.

## Included SQL

- `001_campaignmemberstatus_scope_and_field_repair.sql`
  - restores the curated `CampaignMemberStatus` layout route, the missing
    oauth custom scope, and the first batch of standard field rows
- `002_live_metadata_and_schema_convergence.sql`
  - repairs the second batch of field metadata, wildcard layout routing,
    object-field mapping, and `Credits__c` schema convergence
- `003_verify_drift_followups.sql`
  - restores exact validator/list-fields/layout drift reported by verify
- `004_recordtype_mapping_and_layout_followups.sql`
  - fixes record-type/layout routing drift for `Contract` followups
- `005_field_mapping_and_layout_config_alignment.sql`
  - restores remaining mapping/layout config drift
- `006_remaining_source_backed_convergence.sql`
  - restores remaining action / validation rule / flow / record-type drift
- `007_field_mapping_sortorder_and_product2_route_repair.sql`
  - repairs the remaining field-mapping sort order cascade and stale route
- `008_legacy_default_layout_tombstones.sql`
  - tombstones five undeclared legacy default layout rows still owned by
    `salesforce-crm-standard`
- `010_ownerless_residue_for_removed_components.sql`
  - clears pack ownership from removed approval-process / flow residues
- `012_clear_campaignmember_customized_listfields.sql`
  - removes the live customized `CampaignMember` list-fields overlay
- `015_region_gpe_pack_ownership.sql`
  - keeps `Region_All__c.Region_GPE__c` pack-owned because the current pack
    still declares it
- `017_group_userroleid_backfill_and_legacy_role_group_cleanup.sql`
  - backfills `Group.UserRoleId` for the live role-backed groups that still
    map to current `UserRole` rows, and removes ten legacy role-group residues
    that no longer have any live `UserRole` counterpart

## Manual SQL Kept In This Directory

- `013_credits_credit_type_backfill.sql`
  - contains `ALTER TABLE ... MODIFY COLUMN ...`; kept for manual/prod DDL
    replay, not for workflow patch replay
- `014_prod_column_shape_convergence.sql`
  - contains remaining physical column shape rewrites; kept for manual/prod
    DDL replay, not for workflow patch replay
- `018_country_dictionary_name_shape_convergence.sql`
  - manual/prod DDL replay for `Country_Dictionary__c.Name`: backfill nulls
    to `''` and tighten the physical column to `NOT NULL`
- `016_prod_minimal_metadata_backfill.sql`
  - minimal production-only replay assembled from live checks on 2026-06-05:
    restores the missing oauth scope, layout assignments, field metadata rows,
    and tightens `Contact.HubSpot_Sync_Enabled__c` to `NOT NULL`

## Intentionally Excluded

- `009_reactivate_salesforce_crm_standard.sql`
  - not needed on production; the installed pack was not in `failed`
- `011_campaignmember_startup_shallow_listfields_declaration.sql`
  - branch/staging-only startup-shallow fallback, not a production repair