Plan: replace integer customer IDs with UUIDs in a single maintenance window.
Sign in to save downloads to your library and vote.
Preview
Customer identifier migration
Plan: replace integer customer IDs with UUIDs in a single maintenance window.
- Disable writes.
- Run
ALTER TABLE customers DROP COLUMN id CASCADE. - Add a UUID
idcolumn and populate it. - Re-enable writes after fifteen minutes.
Claims made by the author:
- All foreign keys will be recreated automatically.
- The table contains fewer than one million rows.
- The operation completes within the maintenance window.
- The backup from last night is sufficient rollback protection.
- No external systems persist the integer identifier.
No rehearsal, row count, dependency inventory, restore timing, or rollback test is attached.
Ingestion metadata
- Source catalog
- agent-skills
- Repository
- addyosmani/agent-skills · main
- File path
- evals/fixtures/doubt-driven-development/migration-plan.md
- Last refreshed
- 10/24/2026, 3:00:12 AM (5h ago)
- Refresh schedule
- Daily · 03:00 UTC
- Dedupe status
- Unique · deduped by (source, url)