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
235 B
SQL
6 lines
235 B
SQL
ALTER TABLE `aowow_spawns`
|
|
ALTER `type` DROP DEFAULT;
|
|
ALTER TABLE `aowow_spawns`
|
|
CHANGE COLUMN `type` `type` SMALLINT UNSIGNED NOT NULL AFTER `guid`;
|
|
|
|
UPDATE `aowow_dbversion` SET `sql` = CONCAT(IFNULL(`sql`, ''), ' spawns');
|