647be4a946
* move sql files into its own folder. * move outdated updates out of the update folder, sorted by github tags * split up the db dump so my editor doesn't try to hang itself if i dare to touch that file
6 lines
290 B
SQL
6 lines
290 B
SQL
ALTER TABLE `aowow_creature`
|
|
CHANGE COLUMN `trainerSpell` `trainerRequirement` SMALLINT UNSIGNED NOT NULL DEFAULT '0' AFTER `trainerType`,
|
|
DROP COLUMN `trainerClass`,
|
|
DROP COLUMN `trainerRace`;
|
|
|
|
UPDATE `aowow_dbversion` SET `sql` = CONCAT(IFNULL(`sql`, ''), ' spell, source, creature');
|