* 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
11 lines
506 B
SQL
11 lines
506 B
SQL
CREATE TABLE `aowow_spelloverride` (
|
|
`id` SMALLINT(5) UNSIGNED NOT NULL,
|
|
`spellId1` MEDIUMINT(8) UNSIGNED NULL DEFAULT NULL,
|
|
`spellId2` MEDIUMINT(8) UNSIGNED NULL DEFAULT NULL,
|
|
`spellId3` MEDIUMINT(8) UNSIGNED NULL DEFAULT NULL,
|
|
`spellId4` MEDIUMINT(8) UNSIGNED NULL DEFAULT NULL,
|
|
`spellId5` MEDIUMINT(8) UNSIGNED NULL DEFAULT NULL,
|
|
PRIMARY KEY (`id`)
|
|
) COLLATE='utf8_general_ci' ENGINE=InnoDB;
|
|
|
|
UPDATE `aowow_dbversion` SET `sql` = CONCAT(IFNULL(`sql`, ''), ' spelloverride');
|