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.