Task: Remove the migration scripts

Table of Contents

This page documents a task in the Model the ORE report configuration as entities story. It captures the goal, current status, acceptance, and any notes or results.

1. Goal

No migration scripts and no policy that invites them: a schema change edits the create scripts and is verified by recreating the database.

2. Status

Field Value
State DONE
Parent story Model the ORE report configuration as entities
Now Nothing.
Waiting on Nothing.
Next Nothing.
Last touched 2026-10-03

3. Acceptance

  • projects/ores.sql/migration holds no scripts.
  • The ores.sql schema upgrade policy says the database is recreated, never migrated.

4. Plan

(Implementation strategy. Written when work starts; key decisions are distilled into the parent story's * Decisions at close, but the plan itself stays — it is the historical record of what we did.)

5. Measurements

Every number this task claims about a tree, with the command that produced it and the commit it was measured at. A number without both is not a measurement, because a clean-up record describes a tree and trunk moves under a branch: a consumer count, a gate's component count and a suite's size all change with no code changing, and the reader of a bare number cannot tell which tree it came from. Where the raw output matters, put it in an evidence/ file beside the task and name that file in the Command column.

What Value Command Commit
       

6. Notes

7. Test Scenarios

Manual QA scenarios (scaffolded via compass add test_scenario) that verify this task. Link new ones here as they're created; the scenario doc itself links back via its "Verifies task" field.

Scenario State Notes
     

8. PRs

PR Title
#2572 [sql] Remove the migration scripts

9. Review

Comment summary File Decision Notes
       

10. Result

On the operator's instruction (2026-10-03: no migrations, trash and recreate, no backwards compatibility code), the twenty-seven migration scripts other work had left under projects/ores.sql/migration are deleted. The thirteen this story had added went with Rename the curve configuration tables with a _config suffix, so the directory is gone. No tool executed those files; a database recreate reads only the create and populate scripts.

The schema upgrade policy in projects/ores.sql/modeling/component_overview.org no longer allows one-shot scripts: a schema change edits the create/ scripts and the database is recreated. The rule is also a project memory, doc/llm/memory/no_migrations_trash_and_recreate.org.

Emacs 29.3 (Org mode 9.6.15)