From 608c9aaabfcdbaf09edd11cdf268c243b3e69478 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) (cherry picked from commit 84590be26d6b3c56b95a804cbe889826186dd8a2) --- .../world/master/2020_08_22_02_world_2017_08_04_00_world.sql | 10 ++++++++++ 1 file changed, 10 insertions(+) create mode 100644 sql/updates/world/master/2020_08_22_02_world_2017_08_04_00_world.sql (limited to 'sql') diff --git a/sql/updates/world/master/2020_08_22_02_world_2017_08_04_00_world.sql b/sql/updates/world/master/2020_08_22_02_world_2017_08_04_00_world.sql new file mode 100644 index 00000000000..2506288f344 --- /dev/null +++ b/sql/updates/world/master/2020_08_22_02_world_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(3) unsigned not null, + `bossStates` tinyint(3) unsigned not null, + `spawnGroupId` int(10) unsigned not null, + `flags` tinyint(3) unsigned not null, + PRIMARY KEY (`instanceMapId`,`bossStateId`,`spawnGroupId`,`bossStates`) +) ENGINE=MyISAM DEFAULT CHARSET=utf8; -- cgit v1.2.3