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
8 lines
377 B
SQL
8 lines
377 B
SQL
DROP TABLE IF EXISTS `dbc_spell`;
|
|
|
|
ALTER TABLE `aowow_spell`
|
|
ADD COLUMN `targets` MEDIUMINT UNSIGNED NOT NULL AFTER `stanceMaskNot`,
|
|
CHANGE COLUMN `castTime` `castTime` FLOAT UNSIGNED NOT NULL AFTER `spellFocusObject`,
|
|
CHANGE COLUMN `powerType` `powerType` SMALLINT NOT NULL AFTER `duration`;
|
|
|
|
UPDATE `aowow_dbversion` SET `sql` = CONCAT(IFNULL(`sql`, ''), ' spell');
|