2014 spell catalog: transcribe the PHB'14 Sorcerer spell list (levels 0-9)

[Sandersland]

Content slice of epic #1517. Depends on F1 #1710 + F2 #1711. Parallel with the other content slices.

Why

Transcribe the 2014 (PHB'14) Sorcerer spell list, levels 0–9, so a 2014 Sorcerer is offered its own edition's spells with correct text and mechanics — not 2024 content. Full PHB'14 breadth (owner direction), not the SRD subset.

Scope

• Author EDITION_2014 Spell rows for every PHB'14 Sorcerer spell this slice owns per the epic's row-ownership rule: owner-class = highest-priority class on the spell's PHB'14 list (Wizard > Cleric > Druid > Bard > Sorcerer > Warlock > Paladin > Ranger); spells on 3+ lists belong to the shared slice, not here. Full PHB'14 text + a PHB'14 p.NN citation on each.
• Add SpellClass rows tagging Sorcerer on every PHB'14 Sorcerer spell — including rows owned by the shared slice or another class that Sorcerer also gets (membership only; do NOT re-author those rows).
• Structured mechanics where the engine acts (effectKind / dice / save / concentration / upcast) per PHB'14.
• Extend the seed guards / spell-fork-reseed coverage for the new rows; seed helper fns cyclomatic ≤4.

Acceptance criteria

• Every PHB'14 Sorcerer spell (0–9) resolves for a 2014 Sorcerer via GET /api/spells?class=sorcerer&edition=EDITION_2014; each owned row cites PHB'14 p.NN.
• No 2024-only spell appears on the 2014 Sorcerer list; no row authored twice (owner-rule respected — shared/2+-list spells owned elsewhere carry only a Sorcerer membership row here).
• Both suites + seed guards green.

Relevant code

backend/prisma/seed/spells.ts, SpellClass (F2 #1711), backend/src/routes/catalog/spells.ts, the PHB'14 Sorcerer spell list.

Dependencies

Part of #1517. Depends on F1 #1710 + F2 #1711. Owns rows per the epic's row-ownership rule; 3+-list spells live in the shared slice (CS), not here.

[Sandersland]

Execution decision (2026-08-04): no on-disk PHB'14 source exists, so 2014 spell text is transcribed from the builder model's PHB'14 knowledge — and every content PR gets a mandatory Opus rules-accuracy verify pass cross-checking each spell's level / school / casting time / range / duration / components / concentration / damage / save against PHB'14 before merge. CI-green is necessary but NOT sufficient. Each row carries a PHB'14 p.NN citation. Author into this slice's own per-class seed module (F1 #1710 layout). Content slices run one at a time (owner direction), not fanned out.