Redump sql databases to unify formatting

[newsbot]

Автор: stfx

Redump sql databases to unify formatting



The main reason for this was because classic has updated the sql formatting and manually syncing would be a pain so redumping from master->tbc->classic->cata is easier.



Only the formatting was changed. The values were not changed at all.



mysqldump was used however manual modifications had to be done.



Dump the database:

C:/mysql/bin/mysqldump.exe mangos > sql/mangos.sql



Split insert values into multiple rows:

Replace "),(" with "),\n("

Replace "VALUES (" with "VALUES\n("



Remove the character sets by replacing them with an empty string





Custom formatting of mangos.sql:

Move db_version to the very top

Create all dbscripts_on_* tables based on dbscripts_on_creature_movement

Preserve our custom insert formatting of spell_affect (tbc/classic), spell_bonus_data, spell_chain, spell_elixir, spell_proc_event, spell_proc_item_enchant, spell_template, spell_threat

Remove autoincrement values from insert values of pet_name_generation and remove AUTO_INCREMENT=261 value from its table structure



Custom formatting of characters.sql:

Move character_db_version to the very top



Custom formatting of realmd.sql:

Move realmd_db_version to the very top



[ci skip]

Подробнее...