From 872859ce399348e85e7da8c69357525a50d2464f Mon Sep 17 00:00:00 2001 From: Shocker Date: Wed, 4 Jan 2012 23:13:31 +0200 Subject: SQL: Correct SQL naming/locations for recent pull --- ...0_characters_character_queststatus_seasonal.sql | 8 + .../2011_12_13_02_creature_template_addon.sql | 2 - ...2011_12_13_02_world_creature_template_addon.sql | 2 + ..._00_world_game_event_seasonal_questrelation.sql | 387 --------------------- ...1_characters_character_queststatus_seasonal.sql | 8 - ..._01_world_game_event_seasonal_questrelation.sql | 386 ++++++++++++++++++++ 6 files changed, 396 insertions(+), 397 deletions(-) create mode 100644 sql/updates/characters/2012_01_04_00_characters_character_queststatus_seasonal.sql delete mode 100644 sql/updates/world/2011_12_13_02_creature_template_addon.sql create mode 100644 sql/updates/world/2011_12_13_02_world_creature_template_addon.sql delete mode 100644 sql/updates/world/2012_01_03_00_world_game_event_seasonal_questrelation.sql delete mode 100644 sql/updates/world/2012_01_03_01_characters_character_queststatus_seasonal.sql create mode 100644 sql/updates/world/2012_01_04_01_world_game_event_seasonal_questrelation.sql (limited to 'sql') diff --git a/sql/updates/characters/2012_01_04_00_characters_character_queststatus_seasonal.sql b/sql/updates/characters/2012_01_04_00_characters_character_queststatus_seasonal.sql new file mode 100644 index 00000000000..f9ae71b65a7 --- /dev/null +++ b/sql/updates/characters/2012_01_04_00_characters_character_queststatus_seasonal.sql @@ -0,0 +1,8 @@ +DROP TABLE IF EXISTS `character_queststatus_seasonal`; +CREATE TABLE `character_queststatus_seasonal` ( + `guid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Global Unique Identifier', + `quest` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Quest Identifier', + `event` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Event Identifier', + PRIMARY KEY (`guid`,`quest`), + KEY `idx_guid` (`guid`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Player System'; diff --git a/sql/updates/world/2011_12_13_02_creature_template_addon.sql b/sql/updates/world/2011_12_13_02_creature_template_addon.sql deleted file mode 100644 index f1dc473bdd7..00000000000 --- a/sql/updates/world/2011_12_13_02_creature_template_addon.sql +++ /dev/null @@ -1,2 +0,0 @@ --- Fix speed of oculus drakes -UPDATE `creature_template_addon` SET `auras`='50325' WHERE `entry` IN (27755,27692,27756); diff --git a/sql/updates/world/2011_12_13_02_world_creature_template_addon.sql b/sql/updates/world/2011_12_13_02_world_creature_template_addon.sql new file mode 100644 index 00000000000..f1dc473bdd7 --- /dev/null +++ b/sql/updates/world/2011_12_13_02_world_creature_template_addon.sql @@ -0,0 +1,2 @@ +-- Fix speed of oculus drakes +UPDATE `creature_template_addon` SET `auras`='50325' WHERE `entry` IN (27755,27692,27756); diff --git a/sql/updates/world/2012_01_03_00_world_game_event_seasonal_questrelation.sql b/sql/updates/world/2012_01_03_00_world_game_event_seasonal_questrelation.sql deleted file mode 100644 index b4ff9c1da5e..00000000000 --- a/sql/updates/world/2012_01_03_00_world_game_event_seasonal_questrelation.sql +++ /dev/null @@ -1,387 +0,0 @@ -DROP TABLE IF EXISTS `game_event_seasonal_questrelation`; -CREATE TABLE `game_event_seasonal_questrelation` ( - `quest` mediumint(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Global Unique Identifier', - `event` mediumint(10) NOT NULL DEFAULT '0' COMMENT 'Quest Identifier', - PRIMARY KEY (`quest`,`event`), - KEY `idx_quest` (`quest`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Player System'; - -INSERT INTO `game_event_seasonal_questrelation` (`quest`,`event`) VALUES - (1657, 12), - (1658, 12), - (6961, 2), - (6962, 2), - (6963, 2), - (6964, 2), - (6983, 3), - (6984, 3), - (7021, 2), - (7022, 2), - (7023, 2), - (7024, 2), - (7025, 2), - (7042, 2), - (7043, 2), - (7045, 2), - (7061, 2), - (7062, 2), - (7063, 2), - (8149, 11), - (8150, 11), - (8311, 12), - (8312, 12), - (8322, 12), - (8353, 12), - (8354, 12), - (8355, 12), - (8356, 12), - (8357, 12), - (8358, 12), - (8359, 12), - (8360, 12), - (8373, 12), - (8409, 12), - (8744, 52), - (8746, 2), - (8762, 2), - (8763, 2), - (8767, 52), - (8768, 52), - (8769, 52), - (8788, 52), - (8799, 2), - (8803, 52), - (8827, 2), - (8828, 2), - (8860, 6), - (8861, 6), - (8868, 7), - (8897, 8), - (8898, 8), - (8899, 8), - (8900, 8), - (8901, 8), - (8902, 8), - (8903, 8), - (8904, 8), - (8971, -1), - (8972, -1), - (8973, -1), - (8974, -1), - (8975, -1), - (8976, -1), - (8979, 8), - (8980, 8), - (8981, 8), - (8982, 8), - (8983, 8), - (8984, 8), - (8993, 8), - (9024, 8), - (9025, 8), - (9026, 8), - (9027, 8), - (9028, 8), - (11131, 12), - (11135, 12), - (11219, 12), - (11220, 12), - (11242, 12), - (11356, 12), - (11357, 12), - (11360, 12), - (11361, 12), - (11392, 12), - (11401, 12), - (11403, 12), - (11404, 12), - (11405, 12), - (11435, 12), - (11439, 12), - (11440, 12), - (11449, 12), - (11450, 12), - (11528, 52), - (11558, 8), - (11580, 1), - (11581, 1), - (11583, 1), - (11584, 1), - (11696, 1), - (11732, 1), - (11734, 1), - (11735, 1), - (11736, 1), - (11737, 1), - (11738, 1), - (11739, 1), - (11740, 1), - (11741, 1), - (11742, 1), - (11743, 1), - (11744, 1), - (11745, 1), - (11746, 1), - (11747, 1), - (11748, 1), - (11749, 1), - (11750, 1), - (11751, 1), - (11752, 1), - (11753, 1), - (11754, 1), - (11755, 1), - (11756, 1), - (11757, 1), - (11758, 1), - (11759, 1), - (11760, 1), - (11761, 1), - (11762, 1), - (11763, 1), - (11764, 1), - (11765, 1), - (11766, 1), - (11767, 1), - (11768, 1), - (11769, 1), - (11770, 1), - (11771, 1), - (11772, 1), - (11773, 1), - (11774, 1), - (11775, 1), - (11776, 1), - (11777, 1), - (11778, 1), - (11779, 1), - (11780, 1), - (11781, 1), - (11782, 1), - (11783, 1), - (11784, 1), - (11785, 1), - (11786, 1), - (11787, 1), - (11799, 1), - (11800, 1), - (11801, 1), - (11802, 1), - (11803, 1), - (11804, 1), - (11805, 1), - (11806, 1), - (11807, 1), - (11808, 1), - (11809, 1), - (11810, 1), - (11811, 1), - (11812, 1), - (11813, 1), - (11814, 1), - (11815, 1), - (11816, 1), - (11817, 1), - (11818, 1), - (11819, 1), - (11820, 1), - (11821, 1), - (11822, 1), - (11823, 1), - (11824, 1), - (11825, 1), - (11826, 1), - (11827, 1), - (11828, 1), - (11829, 1), - (11830, 1), - (11831, 1), - (11832, 1), - (11833, 1), - (11834, 1), - (11835, 1), - (11836, 1), - (11837, 1), - (11838, 1), - (11839, 1), - (11840, 1), - (11841, 1), - (11842, 1), - (11843, 1), - (11844, 1), - (11845, 1), - (11846, 1), - (11847, 1), - (11848, 1), - (11849, 1), - (11850, 1), - (11851, 1), - (11852, 1), - (11853, 1), - (11854, 1), - (11855, 1), - (11856, 1), - (11857, 1), - (11858, 1), - (11859, 1), - (11860, 1), - (11861, 1), - (11862, 1), - (11863, 1), - (11937, 1), - (11976, 1), - (12133, 12), - (12135, 12), - (12139, 12), - (12155, 12), - (12286, -1), - (12313, 24), - (12331, 12), - (12332, 12), - (12333, 12), - (12334, 12), - (12335, 12), - (12336, 12), - (12337, 12), - (12338, 12), - (12339, 12), - (12340, 12), - (12341, 12), - (12342, 12), - (12343, 12), - (12344, 12), - (12345, 12), - (12346, 12), - (12347, 12), - (12348, 12), - (12349, 12), - (12350, 12), - (12351, 12), - (12352, 12), - (12353, 12), - (12354, 12), - (12355, 12), - (12356, 12), - (12357, 12), - (12358, 12), - (12359, 12), - (12360, 12), - (12361, 12), - (12362, 12), - (12363, 12), - (12364, 12), - (12365, 12), - (12366, 12), - (12367, 12), - (12368, 12), - (12369, 12), - (12370, 12), - (12371, 12), - (12373, 12), - (12374, 12), - (12375, 12), - (12376, 12), - (12377, 12), - (12378, 12), - (12379, 12), - (12380, 12), - (12381, 12), - (12382, 12), - (12383, 12), - (12384, 12), - (12385, 12), - (12386, 12), - (12387, 12), - (12388, 12), - (12389, 12), - (12390, 12), - (12391, 12), - (12392, 12), - (12393, 12), - (12394, 12), - (12395, 12), - (12396, 12), - (12397, 12), - (12398, 12), - (12399, 12), - (12400, 12), - (12401, 12), - (12402, 12), - (12403, 12), - (12404, 12), - (12405, 12), - (12406, 12), - (12407, 12), - (12408, 12), - (12409, 12), - (12410, 12), - (12940, 12), - (12941, 12), - (12944, 12), - (12945, 12), - (12946, 12), - (12947, 12), - (12950, 12), - (13203, 52), - (13433, 12), - (13434, 12), - (13435, 12), - (13436, 12), - (13437, 12), - (13438, 12), - (13439, 12), - (13440, 12), - (13441, 12), - (13442, 12), - (13443, 12), - (13444, 12), - (13445, 12), - (13446, 12), - (13447, 12), - (13448, 12), - (13449, 12), - (13450, 12), - (13451, 12), - (13452, 12), - (13453, 12), - (13454, 12), - (13455, 12), - (13456, 12), - (13457, 12), - (13458, 12), - (13459, 12), - (13460, 12), - (13461, 12), - (13462, 12), - (13463, 12), - (13464, 12), - (13465, 12), - (13466, 12), - (13467, 12), - (13468, 12), - (13469, 12), - (13470, 12), - (13471, 12), - (13472, 12), - (13473, 12), - (13474, 12), - (13485, 1), - (13486, 1), - (13487, 1), - (13488, 1), - (13489, 1), - (13490, 1), - (13491, 1), - (13492, 1), - (13493, 1), - (13494, 1), - (13495, 1), - (13496, 1), - (13497, 1), - (13498, 1), - (13499, 1), - (13500, 1), - (13501, 12), - (13548, 12), - (13966, 52); - diff --git a/sql/updates/world/2012_01_03_01_characters_character_queststatus_seasonal.sql b/sql/updates/world/2012_01_03_01_characters_character_queststatus_seasonal.sql deleted file mode 100644 index 88264c424cc..00000000000 --- a/sql/updates/world/2012_01_03_01_characters_character_queststatus_seasonal.sql +++ /dev/null @@ -1,8 +0,0 @@ -DROP TABLE IF EXISTS `character_queststatus_seasonal`; -CREATE TABLE `character_queststatus_seasonal` ( - `guid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Global Unique Identifier', - `quest` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Quest Identifier', - `event` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Event Identifier', - PRIMARY KEY (`guid`,`quest`), - KEY `idx_guid` (`guid`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Player System'; \ No newline at end of file diff --git a/sql/updates/world/2012_01_04_01_world_game_event_seasonal_questrelation.sql b/sql/updates/world/2012_01_04_01_world_game_event_seasonal_questrelation.sql new file mode 100644 index 00000000000..9746a358e8a --- /dev/null +++ b/sql/updates/world/2012_01_04_01_world_game_event_seasonal_questrelation.sql @@ -0,0 +1,386 @@ +DROP TABLE IF EXISTS `game_event_seasonal_questrelation`; +CREATE TABLE `game_event_seasonal_questrelation` ( + `quest` mediumint(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Global Unique Identifier', + `event` mediumint(10) NOT NULL DEFAULT '0' COMMENT 'Quest Identifier', + PRIMARY KEY (`quest`,`event`), + KEY `idx_quest` (`quest`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Player System'; + +INSERT INTO `game_event_seasonal_questrelation` (`quest`,`event`) VALUES + (1657, 12), + (1658, 12), + (6961, 2), + (6962, 2), + (6963, 2), + (6964, 2), + (6983, 3), + (6984, 3), + (7021, 2), + (7022, 2), + (7023, 2), + (7024, 2), + (7025, 2), + (7042, 2), + (7043, 2), + (7045, 2), + (7061, 2), + (7062, 2), + (7063, 2), + (8149, 11), + (8150, 11), + (8311, 12), + (8312, 12), + (8322, 12), + (8353, 12), + (8354, 12), + (8355, 12), + (8356, 12), + (8357, 12), + (8358, 12), + (8359, 12), + (8360, 12), + (8373, 12), + (8409, 12), + (8744, 52), + (8746, 2), + (8762, 2), + (8763, 2), + (8767, 52), + (8768, 52), + (8769, 52), + (8788, 52), + (8799, 2), + (8803, 52), + (8827, 2), + (8828, 2), + (8860, 6), + (8861, 6), + (8868, 7), + (8897, 8), + (8898, 8), + (8899, 8), + (8900, 8), + (8901, 8), + (8902, 8), + (8903, 8), + (8904, 8), + (8971, -1), + (8972, -1), + (8973, -1), + (8974, -1), + (8975, -1), + (8976, -1), + (8979, 8), + (8980, 8), + (8981, 8), + (8982, 8), + (8983, 8), + (8984, 8), + (8993, 8), + (9024, 8), + (9025, 8), + (9026, 8), + (9027, 8), + (9028, 8), + (11131, 12), + (11135, 12), + (11219, 12), + (11220, 12), + (11242, 12), + (11356, 12), + (11357, 12), + (11360, 12), + (11361, 12), + (11392, 12), + (11401, 12), + (11403, 12), + (11404, 12), + (11405, 12), + (11435, 12), + (11439, 12), + (11440, 12), + (11449, 12), + (11450, 12), + (11528, 52), + (11558, 8), + (11580, 1), + (11581, 1), + (11583, 1), + (11584, 1), + (11696, 1), + (11732, 1), + (11734, 1), + (11735, 1), + (11736, 1), + (11737, 1), + (11738, 1), + (11739, 1), + (11740, 1), + (11741, 1), + (11742, 1), + (11743, 1), + (11744, 1), + (11745, 1), + (11746, 1), + (11747, 1), + (11748, 1), + (11749, 1), + (11750, 1), + (11751, 1), + (11752, 1), + (11753, 1), + (11754, 1), + (11755, 1), + (11756, 1), + (11757, 1), + (11758, 1), + (11759, 1), + (11760, 1), + (11761, 1), + (11762, 1), + (11763, 1), + (11764, 1), + (11765, 1), + (11766, 1), + (11767, 1), + (11768, 1), + (11769, 1), + (11770, 1), + (11771, 1), + (11772, 1), + (11773, 1), + (11774, 1), + (11775, 1), + (11776, 1), + (11777, 1), + (11778, 1), + (11779, 1), + (11780, 1), + (11781, 1), + (11782, 1), + (11783, 1), + (11784, 1), + (11785, 1), + (11786, 1), + (11787, 1), + (11799, 1), + (11800, 1), + (11801, 1), + (11802, 1), + (11803, 1), + (11804, 1), + (11805, 1), + (11806, 1), + (11807, 1), + (11808, 1), + (11809, 1), + (11810, 1), + (11811, 1), + (11812, 1), + (11813, 1), + (11814, 1), + (11815, 1), + (11816, 1), + (11817, 1), + (11818, 1), + (11819, 1), + (11820, 1), + (11821, 1), + (11822, 1), + (11823, 1), + (11824, 1), + (11825, 1), + (11826, 1), + (11827, 1), + (11828, 1), + (11829, 1), + (11830, 1), + (11831, 1), + (11832, 1), + (11833, 1), + (11834, 1), + (11835, 1), + (11836, 1), + (11837, 1), + (11838, 1), + (11839, 1), + (11840, 1), + (11841, 1), + (11842, 1), + (11843, 1), + (11844, 1), + (11845, 1), + (11846, 1), + (11847, 1), + (11848, 1), + (11849, 1), + (11850, 1), + (11851, 1), + (11852, 1), + (11853, 1), + (11854, 1), + (11855, 1), + (11856, 1), + (11857, 1), + (11858, 1), + (11859, 1), + (11860, 1), + (11861, 1), + (11862, 1), + (11863, 1), + (11937, 1), + (11976, 1), + (12133, 12), + (12135, 12), + (12139, 12), + (12155, 12), + (12286, -1), + (12313, 24), + (12331, 12), + (12332, 12), + (12333, 12), + (12334, 12), + (12335, 12), + (12336, 12), + (12337, 12), + (12338, 12), + (12339, 12), + (12340, 12), + (12341, 12), + (12342, 12), + (12343, 12), + (12344, 12), + (12345, 12), + (12346, 12), + (12347, 12), + (12348, 12), + (12349, 12), + (12350, 12), + (12351, 12), + (12352, 12), + (12353, 12), + (12354, 12), + (12355, 12), + (12356, 12), + (12357, 12), + (12358, 12), + (12359, 12), + (12360, 12), + (12361, 12), + (12362, 12), + (12363, 12), + (12364, 12), + (12365, 12), + (12366, 12), + (12367, 12), + (12368, 12), + (12369, 12), + (12370, 12), + (12371, 12), + (12373, 12), + (12374, 12), + (12375, 12), + (12376, 12), + (12377, 12), + (12378, 12), + (12379, 12), + (12380, 12), + (12381, 12), + (12382, 12), + (12383, 12), + (12384, 12), + (12385, 12), + (12386, 12), + (12387, 12), + (12388, 12), + (12389, 12), + (12390, 12), + (12391, 12), + (12392, 12), + (12393, 12), + (12394, 12), + (12395, 12), + (12396, 12), + (12397, 12), + (12398, 12), + (12399, 12), + (12400, 12), + (12401, 12), + (12402, 12), + (12403, 12), + (12404, 12), + (12405, 12), + (12406, 12), + (12407, 12), + (12408, 12), + (12409, 12), + (12410, 12), + (12940, 12), + (12941, 12), + (12944, 12), + (12945, 12), + (12946, 12), + (12947, 12), + (12950, 12), + (13203, 52), + (13433, 12), + (13434, 12), + (13435, 12), + (13436, 12), + (13437, 12), + (13438, 12), + (13439, 12), + (13440, 12), + (13441, 12), + (13442, 12), + (13443, 12), + (13444, 12), + (13445, 12), + (13446, 12), + (13447, 12), + (13448, 12), + (13449, 12), + (13450, 12), + (13451, 12), + (13452, 12), + (13453, 12), + (13454, 12), + (13455, 12), + (13456, 12), + (13457, 12), + (13458, 12), + (13459, 12), + (13460, 12), + (13461, 12), + (13462, 12), + (13463, 12), + (13464, 12), + (13465, 12), + (13466, 12), + (13467, 12), + (13468, 12), + (13469, 12), + (13470, 12), + (13471, 12), + (13472, 12), + (13473, 12), + (13474, 12), + (13485, 1), + (13486, 1), + (13487, 1), + (13488, 1), + (13489, 1), + (13490, 1), + (13491, 1), + (13492, 1), + (13493, 1), + (13494, 1), + (13495, 1), + (13496, 1), + (13497, 1), + (13498, 1), + (13499, 1), + (13500, 1), + (13501, 12), + (13548, 12), + (13966, 52); -- cgit v1.2.3