Core/Instances: Implemented base scenario system and objectives in dungeons

Closes #17905
Closes #18034

4 files changed, 302 insertions, 1 deletions

diff --git a/sql/base/characters_database.sql b/sql/base/characters_database.sql
index 6c7aef6c65f..b6c209edd06 100644
--- a/sql/base/characters_database.sql
+++ b/sql/base/characters_database.sql
@@ -3245,7 +3245,7 @@ CREATE TABLE `updates` (
 
 LOCK TABLES `updates` WRITE;
 /*!40000 ALTER TABLE `updates` DISABLE KEYS */;
-INSERT INTO `updates` VALUES ('2014_10_20_00_characters.sql','A5882DA0979CF4DAE33DA011EBAA006C24BE7230','ARCHIVED','2015-03-21 15:55:55',0),('2014_10_23_00_characters.sql','E2AC4758133EE19B7F08464A445802154D1261C8','ARCHIVED','2015-03-21 15:55:55',0),('2014_10_23_01_characters.sql','20029E6323D9773B32C34D84FFED1711CC60F09F','ARCHIVED','2015-03-21 15:55:55',0),('2014_10_23_02_characters.sql','8A7A16886EE71E7ACDDB3DDA6D0ECAC2FD2FDCA8','ARCHIVED','2015-03-21 15:55:55',0),('2014_10_24_00_characters.sql','D008FE81AE844FCA686439D6ECC5108FB0DD1EB9','ARCHIVED','2015-03-21 15:55:55',0),('2014_10_25_00_characters.sql','A39C7BE46686B54776BDAB9D7A882D91EDEC51A4','ARCHIVED','2015-03-21 15:55:55',0),('2014_10_26_00_characters.sql','C787954CC35FE34B4101FDE6527F14C027F4947C','ARCHIVED','2015-03-21 15:55:55',0),('2014_11_12_00_characters.sql','B160BB2313F1BD5F3B076A5A9279DC10D4796E34','ARCHIVED','2015-03-21 15:55:55',0),('2014_12_23_00_characters.sql','3D9D648B2387B357F4BD090B33F80682F7924882','ARCHIVED','2015-03-21 15:55:55',0),('2014_12_28_00_characters.sql','5362922FF4483A336311D73082A5727309CD9219','ARCHIVED','2015-03-21 15:55:55',0),('2014_12_31_00_characters.sql','498DDF2DD936CF156D74A8208DC93DCE9FCAB5AA','ARCHIVED','2015-03-21 15:55:55',0),('2015_01_02_00_characters.sql','E5940BE836F253982E07930120422E598D08BDE1','ARCHIVED','2015-03-21 15:55:55',0),('2015_01_10_00_characters.sql','30796056C8623699B2FE1BF626A19D38262E9284','ARCHIVED','2015-03-21 15:55:55',0),('2015_01_16_00_characters.sql','96642760A54C8D799AAFE438049A63AA521656F2','ARCHIVED','2015-03-21 15:55:55',0),('2015_01_27_00_characters.sql','EB710E3EB9F2CAFD84AB62CDC84E898403A80A4F','ARCHIVED','2015-03-21 15:55:55',0),('2015_02_13_00_characters.sql','405BEB4ED207DC6076442A37EE2AFB1F21E274A0','ARCHIVED','2015-03-21 15:55:55',0),('2015_02_13_01_characters.sql','35F582D4F33BF55D1685A1BA89273ED895FD09C5','ARCHIVED','2015-03-21 15:55:55',0),('2015_02_17_00_characters.sql','8D21FC5A55BF8B55D6DCDCE5F02CF2B640230E94','ARCHIVED','2015-03-21 15:55:55',0),('2015_03_10_00_characters.sql','E565B89B145C340067742DFF2DEF1B74F5F1BD4E','ARCHIVED','2015-03-21 15:55:55',0),('2015_03_20_00_characters.sql','B761760804EA73BD297F296C5C1919687DF7191C','ARCHIVED','2015-03-21 15:55:55',0),('2015_03_20_01_characters.sql','20BD68468C57FCF7E665B4DA185DCD52FACE8B3F','ARCHIVED','2015-03-21 15:55:55',0),('2015_03_20_02_characters.sql','0296995DCD3676BA9AE6024CA7C91C5F39D927A3','ARCHIVED','2015-03-21 15:56:46',0),('2015_03_29_00_characters.sql','95D6A46BB746A8BD3EE3FE2086DF1A07F7C33B92','ARCHIVED','2015-05-02 15:43:06',0),('2015_04_21_00_characters.sql','F2032B9BF4EDA7EDE5065554724ED392FD91657D','ARCHIVED','2015-05-02 15:43:06',0),('2015_04_28_00_characters.sql','949F62DB3A3461D420A1230ECF7A6A3ED6435703','ARCHIVED','2015-05-02 15:43:06',0),('2015_05_08_00_characters.sql','0F14B7821618D1C872625B6EDDAA9A667B211167','ARCHIVED','2015-07-10 19:32:17',0),('2015_05_22_00_characters.sql','65B82152413FAB23BE413656E59A486A74447FF7','ARCHIVED','2015-07-10 19:32:17',0),('2015_07_08_00_characters.sql','DAB25360ACB5244C8F8E6214CF6BD97160588A5B','ARCHIVED','2015-07-10 19:32:17',0),('2015_07_11_00_characters.sql','B421B6C0E57BD0FD587071358863D9DABF4BA849','ARCHIVED','2015-07-13 21:50:02',0),('2015_07_12_00_characters.sql','E98E7FD61EF6426E7EDE8ED9AD8C15D8D7132589','ARCHIVED','2015-07-13 21:50:02',0),('2015_07_28_00_characters.sql','0711BC3A658D189EF71B0CB68DCFF2E9B781C4A0','ARCHIVED','2015-07-29 16:23:56',0),('2015_08_08_00_characters.sql','EA12BB2DC24FAF2300A96D0888A45BBEA158D5DC','ARCHIVED','2015-08-08 16:34:07',0),('2015_08_12_00_characters.sql','4FD7F89FE5DA51D4E0C33E520719986AA3EBD31B','ARCHIVED','2015-08-12 12:35:20',0),('2015_09_05_00_characters.sql','4C22BB29365BE4B6B95E64DAD84B63CA002304EA','ARCHIVED','2015-09-05 12:35:20',0),('2015_09_09_00_characters.sql','AFC32E693BC17CFD9A17919FE5317B8FE337ACAD','ARCHIVED','2015-09-09 12:35:20',0),('2015_09_10_00_characters.sql','4555A7F35C107E54C13D74D20F141039ED42943E','ARCHIVED','2015-09-10 22:50:42',0),('2015_10_16_00_characters.sql','E3A3FFF0CB42F04A8DCF0CE4362143C16E2083AF','ARCHIVED','2015-10-15 21:54:11',0),('2015_11_06_00_characters_2015_10_12_00.sql','D6F9927BDED72AD0A81D6EC2C6500CBC34A39FA2','ARCHIVED','2015-11-06 23:43:27',0),('2015_11_08_00_characters.sql','0ACDD35EC9745231BCFA701B78056DEF94D0CC53','ARCHIVED','2015-11-08 00:51:45',15),('2015_11_23_00_characters.sql','9FC828E9E48E8E2E9B99A5A0073D6614C5BFC6B5','ARCHIVED','2015-11-22 23:27:34',0),('2016_01_05_00_characters.sql','0EAD24977F40DE2476B4567DA2B477867CC0DA1A','ARCHIVED','2016-01-04 23:07:40',0),('2016_04_05_00_characters_2016_02_10_00_characters.sql','F1B4DA202819CABC7319A4470A2D224A34609E97','ARCHIVED','2016-04-05 20:34:41',0),('2016_04_11_00_characters.sql','0ACDD35EC9745231BCFA701B78056DEF94D0CC53','ARCHIVED','2016-04-11 02:24:14',30),('2016_04_11_01_characters.sql','CA90F6D99C1EEA7B25BD58BC8368A8D78234BBEF','ARCHIVED','2016-04-11 18:14:18',0),('2016_05_07_00_characters.sql','D1DB5557B21A552C935564D829B4E98B98149077','ARCHIVED','2016-05-07 00:00:00',0),('2016_05_26_00_characters.sql','4179ADC32B96FD8D7D4CF5509A470B1ACE00BE85','ARCHIVED','2016-05-26 17:06:16',0),('2016_07_16_00_characters.sql','EF267FCB92B383FFB33C700508EAF3FBC1F8AC23','ARCHIVED','2016-07-16 14:45:12',0),('2016_07_19_00_characters.sql','AA2C516FA81B451071EA82F58F447E9D13E5D1BD','ARCHIVED','2016-07-19 14:36:25',0),('2016_07_19_01_characters.sql','E9AF46AF4C7CC2E2779E44254AEEDF880D020166','ARCHIVED','2016-07-19 14:36:25',0),('2016_07_19_02_characters.sql','5B1B334449996F3639C9226F587129E03DC4BF6D','ARCHIVED','2016-07-19 14:36:26',0),('2016_07_19_03_characters.sql','7787C8A67D720492FED4BF60ADB22D3CDE1C536D','ARCHIVED','2016-07-19 14:36:26',0),('2016_07_19_04_characters.sql','6D4B536094367AC9EF7CDFF41A4F96EB00B25EE5','ARCHIVED','2016-07-19 14:36:26',0),('2016_07_19_05_characters.sql','12639268DC5F78CE900B59D5C646B10D70842928','ARCHIVED','2016-07-19 14:36:27',0),('2016_07_19_06_characters.sql','9F5A4B533E6BFBAA718DE5160E1FDCB8471A88BF','ARCHIVED','2016-07-19 14:36:28',0),('2016_07_19_07_characters.sql','1E8273FFD4340CBD7BB71D2406E23E9EF7230CFA','ARCHIVED','2016-07-19 14:36:29',0),('2016_07_19_08_characters.sql','FB41FD2F8A7114FEE154021A9D47488C4B12E2A9','ARCHIVED','2016-07-19 14:36:29',0),('2016_08_15_00_characters.sql','BF0B5F453384210CD77C54E262A19B888AAA4095','ARCHIVED','2016-08-14 18:14:32',0),('2016_08_25_00_characters.sql','4AD506C3FCE54238EF452AC07EC562BD41A9D50C','ARCHIVED','2016-08-25 22:54:11',0),('2016_10_17_00_characters.sql','A0EF594CD73690D46A46031137DB0E895F079235','RELEASED','2016-10-16 16:33:05',25),('2016_10_25_00_characters.sql','CC894484561CE138C10B69D34F7831CEDFAF496B','RELEASED','2016-10-25 17:19:35',0);
+INSERT INTO `updates` VALUES ('2014_10_20_00_characters.sql','A5882DA0979CF4DAE33DA011EBAA006C24BE7230','ARCHIVED','2015-03-21 15:55:55',0),('2014_10_23_00_characters.sql','E2AC4758133EE19B7F08464A445802154D1261C8','ARCHIVED','2015-03-21 15:55:55',0),('2014_10_23_01_characters.sql','20029E6323D9773B32C34D84FFED1711CC60F09F','ARCHIVED','2015-03-21 15:55:55',0),('2014_10_23_02_characters.sql','8A7A16886EE71E7ACDDB3DDA6D0ECAC2FD2FDCA8','ARCHIVED','2015-03-21 15:55:55',0),('2014_10_24_00_characters.sql','D008FE81AE844FCA686439D6ECC5108FB0DD1EB9','ARCHIVED','2015-03-21 15:55:55',0),('2014_10_25_00_characters.sql','A39C7BE46686B54776BDAB9D7A882D91EDEC51A4','ARCHIVED','2015-03-21 15:55:55',0),('2014_10_26_00_characters.sql','C787954CC35FE34B4101FDE6527F14C027F4947C','ARCHIVED','2015-03-21 15:55:55',0),('2014_11_12_00_characters.sql','B160BB2313F1BD5F3B076A5A9279DC10D4796E34','ARCHIVED','2015-03-21 15:55:55',0),('2014_12_23_00_characters.sql','3D9D648B2387B357F4BD090B33F80682F7924882','ARCHIVED','2015-03-21 15:55:55',0),('2014_12_28_00_characters.sql','5362922FF4483A336311D73082A5727309CD9219','ARCHIVED','2015-03-21 15:55:55',0),('2014_12_31_00_characters.sql','498DDF2DD936CF156D74A8208DC93DCE9FCAB5AA','ARCHIVED','2015-03-21 15:55:55',0),('2015_01_02_00_characters.sql','E5940BE836F253982E07930120422E598D08BDE1','ARCHIVED','2015-03-21 15:55:55',0),('2015_01_10_00_characters.sql','30796056C8623699B2FE1BF626A19D38262E9284','ARCHIVED','2015-03-21 15:55:55',0),('2015_01_16_00_characters.sql','96642760A54C8D799AAFE438049A63AA521656F2','ARCHIVED','2015-03-21 15:55:55',0),('2015_01_27_00_characters.sql','EB710E3EB9F2CAFD84AB62CDC84E898403A80A4F','ARCHIVED','2015-03-21 15:55:55',0),('2015_02_13_00_characters.sql','405BEB4ED207DC6076442A37EE2AFB1F21E274A0','ARCHIVED','2015-03-21 15:55:55',0),('2015_02_13_01_characters.sql','35F582D4F33BF55D1685A1BA89273ED895FD09C5','ARCHIVED','2015-03-21 15:55:55',0),('2015_02_17_00_characters.sql','8D21FC5A55BF8B55D6DCDCE5F02CF2B640230E94','ARCHIVED','2015-03-21 15:55:55',0),('2015_03_10_00_characters.sql','E565B89B145C340067742DFF2DEF1B74F5F1BD4E','ARCHIVED','2015-03-21 15:55:55',0),('2015_03_20_00_characters.sql','B761760804EA73BD297F296C5C1919687DF7191C','ARCHIVED','2015-03-21 15:55:55',0),('2015_03_20_01_characters.sql','20BD68468C57FCF7E665B4DA185DCD52FACE8B3F','ARCHIVED','2015-03-21 15:55:55',0),('2015_03_20_02_characters.sql','0296995DCD3676BA9AE6024CA7C91C5F39D927A3','ARCHIVED','2015-03-21 15:56:46',0),('2015_03_29_00_characters.sql','95D6A46BB746A8BD3EE3FE2086DF1A07F7C33B92','ARCHIVED','2015-05-02 15:43:06',0),('2015_04_21_00_characters.sql','F2032B9BF4EDA7EDE5065554724ED392FD91657D','ARCHIVED','2015-05-02 15:43:06',0),('2015_04_28_00_characters.sql','949F62DB3A3461D420A1230ECF7A6A3ED6435703','ARCHIVED','2015-05-02 15:43:06',0),('2015_05_08_00_characters.sql','0F14B7821618D1C872625B6EDDAA9A667B211167','ARCHIVED','2015-07-10 19:32:17',0),('2015_05_22_00_characters.sql','65B82152413FAB23BE413656E59A486A74447FF7','ARCHIVED','2015-07-10 19:32:17',0),('2015_07_08_00_characters.sql','DAB25360ACB5244C8F8E6214CF6BD97160588A5B','ARCHIVED','2015-07-10 19:32:17',0),('2015_07_11_00_characters.sql','B421B6C0E57BD0FD587071358863D9DABF4BA849','ARCHIVED','2015-07-13 21:50:02',0),('2015_07_12_00_characters.sql','E98E7FD61EF6426E7EDE8ED9AD8C15D8D7132589','ARCHIVED','2015-07-13 21:50:02',0),('2015_07_28_00_characters.sql','0711BC3A658D189EF71B0CB68DCFF2E9B781C4A0','ARCHIVED','2015-07-29 16:23:56',0),('2015_08_08_00_characters.sql','EA12BB2DC24FAF2300A96D0888A45BBEA158D5DC','ARCHIVED','2015-08-08 16:34:07',0),('2015_08_12_00_characters.sql','4FD7F89FE5DA51D4E0C33E520719986AA3EBD31B','ARCHIVED','2015-08-12 12:35:20',0),('2015_09_05_00_characters.sql','4C22BB29365BE4B6B95E64DAD84B63CA002304EA','ARCHIVED','2015-09-05 12:35:20',0),('2015_09_09_00_characters.sql','AFC32E693BC17CFD9A17919FE5317B8FE337ACAD','ARCHIVED','2015-09-09 12:35:20',0),('2015_09_10_00_characters.sql','4555A7F35C107E54C13D74D20F141039ED42943E','ARCHIVED','2015-09-10 22:50:42',0),('2015_10_16_00_characters.sql','E3A3FFF0CB42F04A8DCF0CE4362143C16E2083AF','ARCHIVED','2015-10-15 21:54:11',0),('2015_11_06_00_characters_2015_10_12_00.sql','D6F9927BDED72AD0A81D6EC2C6500CBC34A39FA2','ARCHIVED','2015-11-06 23:43:27',0),('2015_11_08_00_characters.sql','0ACDD35EC9745231BCFA701B78056DEF94D0CC53','ARCHIVED','2015-11-08 00:51:45',15),('2015_11_23_00_characters.sql','9FC828E9E48E8E2E9B99A5A0073D6614C5BFC6B5','ARCHIVED','2015-11-22 23:27:34',0),('2016_01_05_00_characters.sql','0EAD24977F40DE2476B4567DA2B477867CC0DA1A','ARCHIVED','2016-01-04 23:07:40',0),('2016_04_05_00_characters_2016_02_10_00_characters.sql','F1B4DA202819CABC7319A4470A2D224A34609E97','ARCHIVED','2016-04-05 20:34:41',0),('2016_04_11_00_characters.sql','0ACDD35EC9745231BCFA701B78056DEF94D0CC53','ARCHIVED','2016-04-11 02:24:14',30),('2016_04_11_01_characters.sql','CA90F6D99C1EEA7B25BD58BC8368A8D78234BBEF','ARCHIVED','2016-04-11 18:14:18',0),('2016_05_07_00_characters.sql','D1DB5557B21A552C935564D829B4E98B98149077','ARCHIVED','2016-05-07 00:00:00',0),('2016_05_26_00_characters.sql','4179ADC32B96FD8D7D4CF5509A470B1ACE00BE85','ARCHIVED','2016-05-26 17:06:16',0),('2016_07_16_00_characters.sql','EF267FCB92B383FFB33C700508EAF3FBC1F8AC23','ARCHIVED','2016-07-16 14:45:12',0),('2016_07_19_00_characters.sql','AA2C516FA81B451071EA82F58F447E9D13E5D1BD','ARCHIVED','2016-07-19 14:36:25',0),('2016_07_19_01_characters.sql','E9AF46AF4C7CC2E2779E44254AEEDF880D020166','ARCHIVED','2016-07-19 14:36:25',0),('2016_07_19_02_characters.sql','5B1B334449996F3639C9226F587129E03DC4BF6D','ARCHIVED','2016-07-19 14:36:26',0),('2016_07_19_03_characters.sql','7787C8A67D720492FED4BF60ADB22D3CDE1C536D','ARCHIVED','2016-07-19 14:36:26',0),('2016_07_19_04_characters.sql','6D4B536094367AC9EF7CDFF41A4F96EB00B25EE5','ARCHIVED','2016-07-19 14:36:26',0),('2016_07_19_05_characters.sql','12639268DC5F78CE900B59D5C646B10D70842928','ARCHIVED','2016-07-19 14:36:27',0),('2016_07_19_06_characters.sql','9F5A4B533E6BFBAA718DE5160E1FDCB8471A88BF','ARCHIVED','2016-07-19 14:36:28',0),('2016_07_19_07_characters.sql','1E8273FFD4340CBD7BB71D2406E23E9EF7230CFA','ARCHIVED','2016-07-19 14:36:29',0),('2016_07_19_08_characters.sql','FB41FD2F8A7114FEE154021A9D47488C4B12E2A9','ARCHIVED','2016-07-19 14:36:29',0),('2016_08_15_00_characters.sql','BF0B5F453384210CD77C54E262A19B888AAA4095','ARCHIVED','2016-08-14 18:14:32',0),('2016_08_25_00_characters.sql','4AD506C3FCE54238EF452AC07EC562BD41A9D50C','ARCHIVED','2016-08-25 22:54:11',0),('2016_10_17_00_characters.sql','A0EF594CD73690D46A46031137DB0E895F079235','RELEASED','2016-10-16 16:33:05',25),('2016_10_25_00_characters.sql','CC894484561CE138C10B69D34F7831CEDFAF496B','RELEASED','2016-10-25 17:19:35',0),('2016_11_06_00_characters.sql','C7EC8B65C1BE7722C53BAB79C52C1549054178C0','RELEASED','2016-11-06 23:05:44',0);
 /*!40000 ALTER TABLE `updates` ENABLE KEYS */;
 UNLOCK TABLES;
 
diff --git a/sql/updates/characters/master/2016_11_06_00_characters.sql b/sql/updates/characters/master/2016_11_06_00_characters.sql
new file mode 100644
index 00000000000..1b4f22e24e7
--- /dev/null
+++ b/sql/updates/characters/master/2016_11_06_00_characters.sql
@@ -0,0 +1,11 @@
+--
+-- Table structure for table `instance_scenario_progress`
+--
+DROP TABLE IF EXISTS `instance_scenario_progress`;
+CREATE TABLE `instance_scenario_progress` (
+  `id` int(10) unsigned NOT NULL,
+  `criteria` int(10) unsigned NOT NULL,
+  `counter` bigint(20) unsigned NOT NULL,
+  `date` int(10) unsigned NOT NULL DEFAULT '0',
+  PRIMARY KEY (`id`,`criteria`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8;
diff --git a/sql/updates/hotfixes/master/2016_11_06_02_hotfixes.sql b/sql/updates/hotfixes/master/2016_11_06_02_hotfixes.sql
new file mode 100644
index 00000000000..fae5062d5fc
--- /dev/null
+++ b/sql/updates/hotfixes/master/2016_11_06_02_hotfixes.sql
@@ -0,0 +1,57 @@
+--
+-- Table structure for table `scenario`
+--
+DROP TABLE IF EXISTS `scenario`;
+CREATE TABLE `scenario` (
+  `ID` int(10) unsigned NOT NULL DEFAULT '0',
+  `Name` text,
+  `Data` smallint(5) unsigned NOT NULL DEFAULT '0',
+  `Flags` tinyint(3) unsigned NOT NULL DEFAULT '0',
+  `Type` tinyint(3) unsigned NOT NULL DEFAULT '0',
+  `VerifiedBuild` smallint(6) NOT NULL DEFAULT '0',
+  PRIMARY KEY (`ID`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
+
+--
+-- Table structure for table `scenario_locale`
+--
+DROP TABLE IF EXISTS `scenario_locale`;
+CREATE TABLE `scenario_locale` (
+  `ID` int(10) unsigned NOT NULL DEFAULT '0',
+  `locale` varchar(4) NOT NULL,
+  `Name_lang` text,
+  `VerifiedBuild` smallint(6) NOT NULL DEFAULT '0',
+  PRIMARY KEY (`ID`,`locale`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
+
+--
+-- Table structure for table `scenario_step`
+--
+DROP TABLE IF EXISTS `scenario_step`;
+CREATE TABLE `scenario_step` (
+  `ID` int(10) unsigned NOT NULL DEFAULT '0',
+  `Description` text,
+  `Name` text,
+  `CriteriaTreeID` smallint(5) unsigned NOT NULL DEFAULT '0',
+  `ScenarioID` smallint(5) unsigned NOT NULL DEFAULT '0',
+  `PreviousStepID` smallint(5) unsigned NOT NULL DEFAULT '0',
+  `QuestRewardID` smallint(5) unsigned NOT NULL DEFAULT '0',
+  `Step` tinyint(3) unsigned NOT NULL DEFAULT '0',
+  `Flags` tinyint(3) unsigned NOT NULL DEFAULT '0',
+  `BonusRequiredStepID` int(10) unsigned NOT NULL DEFAULT '0',
+  `VerifiedBuild` smallint(6) NOT NULL DEFAULT '0',
+  PRIMARY KEY (`ID`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
+
+--
+-- Table structure for table `scenario_step_locale`
+--
+DROP TABLE IF EXISTS `scenario_step_locale`;
+CREATE TABLE `scenario_step_locale` (
+  `ID` int(10) unsigned NOT NULL DEFAULT '0',
+  `locale` varchar(4) NOT NULL,
+  `Description_lang` text,
+  `Name_lang` text,
+  `VerifiedBuild` smallint(6) NOT NULL DEFAULT '0',
+  PRIMARY KEY (`ID`,`locale`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
diff --git a/sql/updates/world/master/2016_11_06_00_world.sql b/sql/updates/world/master/2016_11_06_00_world.sql
new file mode 100644
index 00000000000..4fab752d9e2
--- /dev/null
+++ b/sql/updates/world/master/2016_11_06_00_world.sql
@@ -0,0 +1,233 @@
+DROP TABLE IF EXISTS `scenarios`;
+CREATE TABLE `scenarios` (
+  `map` int(10) unsigned NOT NULL DEFAULT '0',
+  `difficulty` tinyint(3) unsigned NOT NULL DEFAULT '0',
+  `scenario_A` int(10) unsigned NOT NULL DEFAULT '0',
+  `scenario_H` int(10) unsigned NOT NULL DEFAULT '0',
+  PRIMARY KEY (`map`,`difficulty`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
+
+INSERT INTO `scenarios` (`map`, `difficulty`, `scenario_A`, `scenario_H`) VALUES
+(33, 1, 516, 516),
+(33, 2, 523, 523),
+(34, 1, 510, 0),
+(36, 1, 641, 641),
+(36, 2, 643, 643),
+(43, 1, 515, 515),
+(47, 1, 654, 654),
+(48, 1, 333, 333),
+(70, 1, 648, 648),
+(90, 1, 649, 649),
+(109, 1, 640, 640),
+(129, 1, 647, 647),
+(209, 1, 644, 644),
+(230, 1, 671, 671),
+(269, 1, 610, 610),
+(269, 2, 611, 611),
+(349, 1, 664, 664),
+(389, 1, 511, 511),
+(429, 1, 668, 668),
+(540, 1, 607, 607),
+(540, 2, 608, 608),
+(542, 1, 634, 634),
+(542, 2, 635, 635),
+(543, 1, 638, 638),
+(543, 2, 639, 639),
+(545, 1, 618, 618),
+(545, 2, 619, 619),
+(546, 1, 630, 630),
+(546, 2, 631, 631),
+(547, 1, 632, 632),
+(547, 2, 633, 633),
+(552, 1, 620, 620),
+(552, 2, 621, 621),
+(553, 1, 612, 612),
+(553, 2, 613, 613),
+(554, 1, 614, 614),
+(554, 2, 615, 615),
+(555, 1, 606, 606),
+(555, 2, 609, 609),
+(556, 1, 622, 622),
+(556, 2, 623, 623),
+(557, 1, 628, 628),
+(557, 2, 629, 629),
+(558, 1, 626, 626),
+(558, 2, 627, 627),
+(560, 1, 624, 624),
+(560, 2, 625, 625),
+(568, 2, 574, 574),
+(574, 1, 596, 596),
+(574, 2, 597, 597),
+(575, 1, 577, 577),
+(575, 2, 579, 579),
+(576, 1, 598, 598),
+(576, 2, 605, 599),
+(578, 1, 575, 575),
+(578, 2, 576, 576),
+(585, 1, 616, 616),
+(585, 2, 617, 617),
+(595, 1, 583, 583),
+(595, 2, 585, 585),
+(599, 1, 582, 582),
+(599, 2, 584, 584),
+(600, 1, 590, 590),
+(600, 2, 591, 591),
+(601, 1, 594, 594),
+(601, 2, 595, 595),
+(602, 1, 580, 580),
+(602, 2, 581, 581),
+(604, 1, 586, 586),
+(604, 2, 587, 587),
+(608, 1, 588, 588),
+(608, 2, 589, 589),
+(619, 1, 592, 592),
+(619, 2, 593, 593),
+(632, 1, 566, 566),
+(632, 2, 568, 568),
+(643, 1, 548, 548),
+(643, 2, 550, 550),
+(644, 1, 558, 558),
+(644, 2, 565, 565),
+(645, 1, 542, 542),
+(645, 2, 545, 545),
+(650, 1, 676, 676),
+(650, 2, 677, 677),
+(657, 1, 551, 551),
+(657, 2, 552, 552),
+(658, 1, 569, 569),
+(658, 2, 571, 571),
+(668, 1, 572, 572),
+(668, 2, 573, 573),
+(670, 1, 553, 553),
+(670, 2, 554, 554),
+(725, 1, 674, 674),
+(725, 2, 675, 675),
+(755, 1, 555, 555),
+(755, 2, 557, 557),
+(859, 2, 556, 556),
+(938, 2, 547, 547),
+(939, 2, 567, 567),
+(940, 2, 570, 570),
+(959, 1, 531, 531),
+(959, 2, 535, 535),
+(959, 8, 46, 46),
+(960, 1, 539, 539),
+(960, 2, 540, 540),
+(960, 8, 44, 44),
+(961, 1, 537, 537),
+(961, 2, 538, 538),
+(961, 8, 45, 45),
+(962, 1, 526, 526),
+(962, 2, 527, 527),
+(962, 8, 48, 48),
+(994, 1, 528, 528),
+(994, 2, 536, 536),
+(994, 8, 50, 50),
+(999, 12, 71, 0),
+(1000, 12, 0, 72),
+(1001, 1, 650, 650),
+(1001, 2, 651, 651),
+(1001, 8, 52, 52),
+(1004, 1, 652, 652),
+(1004, 2, 653, 653),
+(1004, 8, 53, 53),
+(1005, 11, 65, 65),
+(1005, 12, 65, 65),
+(1007, 1, 645, 645),
+(1007, 2, 646, 646),
+(1007, 8, 51, 51),
+(1011, 1, 524, 524),
+(1011, 2, 525, 525),
+(1011, 8, 49, 49),
+(1024, 12, 40, 40),
+(1030, 11, 39, 39),
+(1030, 12, 39, 39),
+(1031, 11, 58, 58),
+(1031, 12, 58, 58),
+(1048, 12, 15, 15),
+(1051, 12, 63, 63),
+(1095, 12, 179, 179),
+(1099, 11, 182, 239),
+(1099, 12, 182, 239),
+(1102, 12, 0, 201),
+(1103, 12, 184, 184),
+(1104, 12, 183, 183),
+(1112, 12, 200, 200),
+(1126, 12, 205, 205),
+(1130, 11, 210, 210),
+(1130, 12, 210, 210),
+(1131, 11, 219, 219),
+(1131, 12, 219, 219),
+(1135, 12, 215, 215),
+(1144, 11, 216, 216),
+(1144, 12, 216, 216),
+(1148, 1, 237, 237),
+(1148, 12, 237, 237),
+(1161, 12, 257, 257),
+(1168, 12, 275, 275),
+(1175, 1, 680, 680),
+(1175, 2, 681, 681),
+(1175, 8, 425, 425),
+(1176, 1, 686, 686),
+(1176, 2, 687, 687),
+(1176, 8, 428, 428),
+(1176, 23, 687, 687),
+(1182, 1, 678, 678),
+(1182, 2, 679, 679),
+(1182, 8, 427, 427),
+(1182, 23, 679, 679),
+(1195, 1, 684, 684),
+(1195, 2, 685, 685),
+(1195, 8, 426, 426),
+(1195, 23, 685, 685),
+(1203, 12, 324, 324),
+(1207, 12, 331, 331),
+(1208, 1, 682, 682),
+(1208, 2, 683, 683),
+(1208, 8, 429, 429),
+(1208, 23, 683, 683),
+(1209, 1, 688, 688),
+(1209, 2, 689, 689),
+(1209, 8, 423, 423),
+(1209, 23, 689, 689),
+(1277, 12, 449, 449),
+(1279, 1, 708, 708),
+(1279, 2, 709, 709),
+(1279, 8, 430, 430),
+(1279, 23, 709, 709),
+(1358, 1, 744, 744),
+(1358, 2, 329, 329),
+(1358, 8, 432, 432),
+(1358, 19, 731, 731),
+(1402, 12, 320, 320),
+(1431, 1, 736, 736),
+(1455, 12, 776, 776);
+
+DROP TABLE IF EXISTS `scenario_poi`;
+CREATE TABLE `scenario_poi` (
+  `CriteriaTreeID` INT(11) NOT NULL DEFAULT '0',
+  `BlobIndex` INT(11) NOT NULL DEFAULT '0',
+  `Idx1` INT(11) NOT NULL DEFAULT '0',
+  `MapID` INT(11) NOT NULL DEFAULT '0',
+  `WorldMapAreaId` INT(11) NOT NULL DEFAULT '0',
+  `Floor` INT(11) NOT NULL DEFAULT '0',
+  `Priority` INT(11) NOT NULL DEFAULT '0',
+  `Flags` INT(11) NOT NULL DEFAULT '0',
+  `WorldEffectID` INT(11) NOT NULL DEFAULT '0',
+  `PlayerConditionID` INT(11) NOT NULL DEFAULT '0',
+  `VerifiedBuild` SMALLINT(5) NULL DEFAULT '0',
+  PRIMARY KEY (`CriteriaTreeID`, `BlobIndex`, `Idx1`),
+  INDEX `idx` (`CriteriaTreeID`, `BlobIndex`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
+
+DROP TABLE IF EXISTS `scenario_poi_points`;
+CREATE TABLE `scenario_poi_points` (
+  `CriteriaTreeID` INT(11) NOT NULL DEFAULT '0',
+  `Idx1` INT(11) NOT NULL DEFAULT '0',
+  `Idx2` INT(11) NOT NULL DEFAULT '0',
+  `X` INT(11) NOT NULL DEFAULT '0',
+  `Y` INT(11) NOT NULL DEFAULT '0',
+  `VerifiedBuild` SMALLINT(5) NULL DEFAULT '0',
+  PRIMARY KEY (`CriteriaTreeID`, `Idx1`, `Idx2`),
+  INDEX `questId_id` (`CriteriaTreeID`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;