aowow/setup/sql/updates/v1.1/1490912249_01.sql
Sarjuuk 647be4a946 Setup/SQL
* 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
2025-09-25 18:44:48 +02:00

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');