From 84590be26d6b3c56b95a804cbe889826186dd8a2 Mon Sep 17 00:00:00 2001 From: Treeston Date: Fri, 4 Aug 2017 00:23:40 +0200 Subject: Scripts/InstanceScript: Implement database framework for managing spawn groups based on boss state. (#20103) --- sql/updates/world/3.3.5/2017_08_04_00_world.sql | 10 ++++++++++ 1 file changed, 10 insertions(+) create mode 100644 sql/updates/world/3.3.5/2017_08_04_00_world.sql (limited to 'sql') diff --git a/sql/updates/world/3.3.5/2017_08_04_00_world.sql b/sql/updates/world/3.3.5/2017_08_04_00_world.sql new file mode 100644 index 00000000000..d70076f042e --- /dev/null +++ b/sql/updates/world/3.3.5/2017_08_04_00_world.sql @@ -0,0 +1,10 @@ +-- +DROP TABLE IF EXISTS `instance_spawn_groups`; +CREATE TABLE `instance_spawn_groups` ( + `instanceMapId` smallint(5) unsigned not null, + `bossStateId` tinyint unsigned not null, + `bossStates` tinyint unsigned not null, + `spawnGroupId` int unsigned not null, + `flags` tinyint unsigned not null, + PRIMARY KEY (`instanceMapId`,`bossStateId`,`spawnGroupId`,`bossStates`) +) ENGINE=MyISAM DEFAULT CHARSET=utf8; -- cgit v1.2.3