this one is in the readme
mangos/sql/updates/README
=== File name descriptin ===
File names are divided into two parts. First part is the date+counter
that show commit apply date that will be compatible with database after apply update.
The second part of the name, is the table that needs and update or has been added.
See an example below:
2008_10_17_01_characters_character_spell.sql
| | | |
| | | |
| | | The table character_spell
| | | will need an update.
| | |
| | Name of affected DB (default recommended name)
| | Can be: characters, mangos, realmd
| |
| Counter show number of sql update in updates list for provided data
| and set proper order for sql updates for some date
|
MaNGOS commit date related to sql update. For related commit
you can see [url]http://github.com/mangos/mangos/commits/master[/url]
Expected commit will be in commits list for provided date and it will have
sql update file name (2008_10_17_01_characters_character_spell.sql in our case) in list
changed files, After appling this update DB compatiable with found commit.
and this for smart people?
MaNGOS_08101701_ScriptDev2...
MaNGOS_08101702_ScriptDev2...
MaNGOS_08101703_ScriptDev2...
...