AoC WORLD SCHEMA REDESIGN — COMPLETE PACKAGE
It’s done. A production-safe, fully documented world schema upgrade for Ashes of Creation content: 27 new tables, 3 modified tables, 40+ building types seeded, and a 4-week implementation roadmap with validation and rollback guides.
What’s Inside
- ✅ 15 systems covered (seasons, sieges, trade, freeholds, POI/dungeons/bosses…)
- ✅ 775 lines migration SQL + 2,000+ lines docs
- ✅ Stage gating (0–6), content locking, admin governance
- ✅ Non-destructive + idempotent migration
What This Unlocks Next
- 🚀 Admin tools for buildings, freeholds, dungeons, sieges
- 🗺️ Interactive maps tied to real regions/settlements
- 🏛️ Node evolution tracking (Stage 0 → 6)
- 📜 Quest builder + story arc designer
- ⛏️ Seasonal gathering, trade routes, commerce upgrades
Why This Matters
- 🔥 Stronger world simulation for future features
- 🌎 AoC-true hierarchy (realms → regions → zones → nodes)
- 🏗️ Base for freeholds, dungeons, bosses, sieges, trade routes
- ⚙️ Content-ready systems for crafting, gathering, seasons
- 🚧 Future-proof core for Crimson Night tools/dashboards
Major Highlights
- ✅ 27 new world-building tables added
- ✅ 40+ AoC building types seeded
- ✅ Realms, regions, underrealm, naval zones structured
- ✅ Quest + story arc foundations
- ✅ Siege & seasonal systems ready for UI
Navigation Redesign: Live in Admin
Domain-scoped menus (Admin, Public, Game, Guild) with blocks, role/path visibility, priority ordering, and soft-delete Recycle Bin. Delete safety prompts included.
- Naming: <Scope> — <Area> Navigation
- Blocks per menu, grouped & ordered
- Unified “Guild Leader Dashboard” menu template
Admin UI: Separate Views Per Domain
Website Admin, Guild Admin, and Game Admin each get isolated UIs. Collapse state persists, spacing tightened, and right-rail widgets consolidated into Tools & Tips.
- Context-aware dashboards
- Optional domain switcher for Website Admin
- Guild leaders see only their guild
Phase 1 Foundations: Locked
Finalized Races, Archetypes (8), Classes (64), and Stat Types for seeding. Stable IDs/slugs, unique (primary, secondary) class index, and archetype skills reserved for expansion.
- Core/combat/elemental/utility stats
- Official class naming map
- Seed order + validation guards
Guild Professions Tracker (AoC)
Dashboard for Gathering, Processing, and Crafting counts, gap analysis, targets, and matrix view by member × profession. Built single-guild today, multi-everything ready.
- Needs analysis & recommendations
- Role-based visibility
- Future: automation hooks
Public Theme Refresh + Hero Banner
Dark theme with gold accents, cinematic hero, crimson bands refined darker, white text enforced inside feature cards, and gold divider above footer.
- Per-page hero sizes (full/compact)
- Card hover depth & clarity
- Consistent typography
Automated E2E Test Harness
Initial Playwright tests for quest builder flows, filters, and toasts.
Next: add data-test selectors, success messages, and CI hooks.
- Green path & error path coverage
- Stabilized selectors
- HTML report serving locally