Hi - I answer from the OpenSmartRoute documentation: routing, the API, plans and quotas, self-hosting. Ask away, or open a support ticket if you need a person.
Grounded in the docs - follow a source before acting on it.
Use when editing SQL files, database updates, world/auth/characters changes, SAI data, or module SQL. Covers pending SQL placement, safe update patterns, and AzerothCore SQL conventions.
Instruction file imported from Old-Man-Warcraft/oldmanwarcraft (.github/instructions/sql.instructions.md). Copyright stays with the author.
SQL Guidelines
Start by placing each new SQL change in the correct pending update folder: data/sql/updates/pending_db_auth/, data/sql/updates/pending_db_characters/, or data/sql/updates/pending_db_world/.
Do not edit base SQL or merged SQL history unless the task explicitly requires it.
Keep each change scoped to the correct database: acore_auth, acore_characters, or acore_world.
Follow AzerothCore SQL conventions within that file: use backticks for identifiers, place DELETE before INSERT, and preserve the style already used in nearby update files.
When editing module SQL, use the module's standard SQL locations, such as paths documented by the module or its existing data/sql/ tree. Avoid optional or destructive helper SQL unless the task explicitly asks for it.
