1 ALTER TABLE db_version CHANGE COLUMN required_8521_01_mangos_spell_proc_event required_8548_01_mangos_creature_battleground bit;
3 DROP TABLE IF EXISTS `creature_battleground`;
4 CREATE TABLE `creature_battleground` (
5 `guid` int(10) unsigned NOT NULL COMMENT 'Creature\'s GUID',
6 `event1` tinyint(3) unsigned NOT NULL COMMENT 'main event',
7 `event2` tinyint(3) unsigned NOT NULL COMMENT 'sub event',
9 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Creature battleground indexing system';