diff options
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/base/characters_database.sql | 2 | ||||
| -rw-r--r-- | sql/updates/characters/master/2016_11_06_00_characters.sql | 11 | ||||
| -rw-r--r-- | sql/updates/hotfixes/master/2016_11_06_02_hotfixes.sql | 57 | ||||
| -rw-r--r-- | sql/updates/world/master/2016_11_06_00_world.sql | 233 |
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; |