diff options
Diffstat (limited to 'sql/old/4.3.4')
46 files changed, 390 insertions, 0 deletions
diff --git a/sql/old/4.3.4/2012_07_03_00_world_item_template_addon_434.sql b/sql/old/4.3.4/2012_07_03_00_world_item_template_addon_434.sql new file mode 100644 index 00000000000..6cc5b547867 --- /dev/null +++ b/sql/old/4.3.4/2012_07_03_00_world_item_template_addon_434.sql @@ -0,0 +1 @@ +ALTER TABLE `item_template_addon` DROP `BuyCount`; diff --git a/sql/old/4.3.4/2012_07_05_00_world_item_template_addon_434.sql b/sql/old/4.3.4/2012_07_05_00_world_item_template_addon_434.sql new file mode 100644 index 00000000000..140fc3a9940 --- /dev/null +++ b/sql/old/4.3.4/2012_07_05_00_world_item_template_addon_434.sql @@ -0,0 +1 @@ +ALTER TABLE `item_template_addon` ADD `FlagsCu` INT(10) UNSIGNED NOT NULL DEFAULT 0 AFTER `Id`; diff --git a/sql/old/4.3.4/2012_07_10_00_characters_character_glyphs_434.sql b/sql/old/4.3.4/2012_07_10_00_characters_character_glyphs_434.sql new file mode 100644 index 00000000000..b8aba4d7798 --- /dev/null +++ b/sql/old/4.3.4/2012_07_10_00_characters_character_glyphs_434.sql @@ -0,0 +1,4 @@ +ALTER TABLE `character_glyphs` + ADD `glyph7` smallint(5) unsigned DEFAULT '0' AFTER `glyph6`, + ADD `glyph8` smallint(5) unsigned DEFAULT '0' AFTER `glyph7`, + ADD `glyph9` smallint(5) unsigned DEFAULT '0' AFTER `glyph8`; diff --git a/sql/old/4.3.4/2012_07_18_00_characters_characters_434.sql b/sql/old/4.3.4/2012_07_18_00_characters_characters_434.sql new file mode 100644 index 00000000000..159c3d85703 --- /dev/null +++ b/sql/old/4.3.4/2012_07_18_00_characters_characters_434.sql @@ -0,0 +1 @@ +ALTER TABLE `characters` DROP `guildId`; diff --git a/sql/old/4.3.4/2012_07_23_00_auth_realmlist_434.sql b/sql/old/4.3.4/2012_07_23_00_auth_realmlist_434.sql new file mode 100644 index 00000000000..121e97f5837 --- /dev/null +++ b/sql/old/4.3.4/2012_07_23_00_auth_realmlist_434.sql @@ -0,0 +1 @@ +UPDATE `realmlist` SET `gamebuild`=15595 WHERE `id`=1; diff --git a/sql/old/4.3.4/2012_07_24_00_characters_various_434.sql b/sql/old/4.3.4/2012_07_24_00_characters_various_434.sql new file mode 100644 index 00000000000..8b2bfd4f131 --- /dev/null +++ b/sql/old/4.3.4/2012_07_24_00_characters_various_434.sql @@ -0,0 +1,3 @@ +ALTER TABLE `characters` CHANGE `money` `money` bigint(20) unsigned NOT NULL DEFAULT '0'; +ALTER TABLE `mail` CHANGE `money` `money` bigint(20) unsigned NOT NULL DEFAULT '0'; +ALTER TABLE `mail` CHANGE `cod` `cod` bigint(20) unsigned NOT NULL DEFAULT '0'; diff --git a/sql/old/4.3.4/2012_07_30_00_characters_void_storage_434.sql b/sql/old/4.3.4/2012_07_30_00_characters_void_storage_434.sql new file mode 100644 index 00000000000..e8a47c5f91c --- /dev/null +++ b/sql/old/4.3.4/2012_07_30_00_characters_void_storage_434.sql @@ -0,0 +1,11 @@ +DROP TABLE IF EXISTS `void_storage`; +CREATE TABLE IF NOT EXISTS `void_storage` ( + `itemId` bigint(20) unsigned NOT NULL, + `playerGuid` int(10) unsigned NOT NULL, + `itemEntry` mediumint(8) unsigned NOT NULL, + `slot` tinyint(3) unsigned NOT NULL, + `creatorGuid` int(10) unsigned NOT NULL DEFAULT '0', + PRIMARY KEY (`itemId`), + UNIQUE KEY `idx_player_slot` (`playerGuid`,`slot`), + KEY `idx_player` (`playerGuid`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8; diff --git a/sql/old/4.3.4/2012_07_30_01_characters_void_storage_434.sql b/sql/old/4.3.4/2012_07_30_01_characters_void_storage_434.sql new file mode 100644 index 00000000000..cd2cb0f0b9e --- /dev/null +++ b/sql/old/4.3.4/2012_07_30_01_characters_void_storage_434.sql @@ -0,0 +1,2 @@ +ALTER TABLE `void_storage` ADD `randomProperty` int(10) unsigned NOT NULL DEFAULT '0'; +ALTER TABLE `void_storage` ADD `suffixFactor` int(10) unsigned NOT NULL DEFAULT '0'; diff --git a/sql/old/4.3.4/2012_08_01_00_characters_item_instance_434.sql b/sql/old/4.3.4/2012_08_01_00_characters_item_instance_434.sql new file mode 100644 index 00000000000..b87b781e293 --- /dev/null +++ b/sql/old/4.3.4/2012_08_01_00_characters_item_instance_434.sql @@ -0,0 +1,11 @@ +UPDATE `item_instance` SET `enchantments` = REPLACE(`enchantments`,' ',' '); +UPDATE `item_instance` SET `enchantments` = CONCAT(TRIM(`enchantments`),' '); + +UPDATE `item_instance` SET `enchantments` = CONCAT( + SUBSTRING_INDEX(`enchantments`, ' ', 7*3), + ' 0 0 0 0 0 0 0 0 0 ', + SUBSTRING_INDEX(`enchantments`, ' ', -(12-7)*3 - 1)) +WHERE (LENGTH(`enchantments`) - LENGTH(REPLACE(`enchantments`, ' ', ''))) = 12*3; + +UPDATE `item_instance` SET `enchantments` = REPLACE(`enchantments`,' ',' '); +UPDATE `item_instance` SET `enchantments` = CONCAT(TRIM(`enchantments`),' '); diff --git a/sql/old/4.3.4/2012_08_04_01_world_player_classlevelstats_434.sql b/sql/old/4.3.4/2012_08_04_01_world_player_classlevelstats_434.sql new file mode 100644 index 00000000000..9b2bcb6d6ca --- /dev/null +++ b/sql/old/4.3.4/2012_08_04_01_world_player_classlevelstats_434.sql @@ -0,0 +1 @@ +DROP TABLE IF EXISTS `player_classlevelstats`;
\ No newline at end of file diff --git a/sql/old/4.3.4/2012_08_05_01_world_item_set_names_434.sql b/sql/old/4.3.4/2012_08_05_01_world_item_set_names_434.sql new file mode 100644 index 00000000000..6e7cd5dbc61 --- /dev/null +++ b/sql/old/4.3.4/2012_08_05_01_world_item_set_names_434.sql @@ -0,0 +1,2 @@ +DROP TABLE IF EXISTS `locales_item_set_names`; +DROP TABLE IF EXISTS `item_set_names`; diff --git a/sql/old/4.3.4/2012_08_05_02_world_command_434.sql b/sql/old/4.3.4/2012_08_05_02_world_command_434.sql new file mode 100644 index 00000000000..69fd621c457 --- /dev/null +++ b/sql/old/4.3.4/2012_08_05_02_world_command_434.sql @@ -0,0 +1,2 @@ +DELETE FROM `command` WHERE `name` = 'reload locales_item_set_name'; +DELETE FROM `command` WHERE `name` = 'reload item_set_names'; diff --git a/sql/old/4.3.4/2012_08_06_00_world_classlevelstats_434.sql b/sql/old/4.3.4/2012_08_06_00_world_classlevelstats_434.sql new file mode 100644 index 00000000000..e6038374508 --- /dev/null +++ b/sql/old/4.3.4/2012_08_06_00_world_classlevelstats_434.sql @@ -0,0 +1,7 @@ +ALTER TABLE `creature_classlevelstats` ADD `basehp3` smallint(6) NOT NULL DEFAULT '1' AFTER `basehp2`; + +ALTER TABLE `creature_classlevelstats` CHANGE `basehp0` `basehp0` smallint(6) NOT NULL DEFAULT '1'; +ALTER TABLE `creature_classlevelstats` CHANGE `basehp1` `basehp1` smallint(6) NOT NULL DEFAULT '1'; +ALTER TABLE `creature_classlevelstats` CHANGE `basehp2` `basehp2` smallint(6) NOT NULL DEFAULT '1'; +ALTER TABLE `creature_classlevelstats` CHANGE `basemana` `basemana` smallint(6) NOT NULL DEFAULT '1'; +ALTER TABLE `creature_classlevelstats` CHANGE `basearmor` `basearmor` smallint(6) NOT NULL DEFAULT '1'; diff --git a/sql/old/4.3.4/2012_08_06_00_world_command_434.sql b/sql/old/4.3.4/2012_08_06_00_world_command_434.sql new file mode 100644 index 00000000000..50628aaa589 --- /dev/null +++ b/sql/old/4.3.4/2012_08_06_00_world_command_434.sql @@ -0,0 +1,4 @@ +DELETE FROM `command` WHERE `name` IN ('server togglequerylog', 'server set loglevel'); + +INSERT INTO `command` (`name`,`security`,`help`) VALUES +('server set loglevel',4,'Syntax: .server set loglevel $facility $name $loglevel. $facility can take the values: appender (a) or logger (l). $loglevel can take the values: disabled (0), trace (1), debug (2), info (3), warn (4), error (5) or fatal (6)'); diff --git a/sql/old/4.3.4/2012_08_06_01_world_classlevelstats_434.sql b/sql/old/4.3.4/2012_08_06_01_world_classlevelstats_434.sql new file mode 100644 index 00000000000..6fe7ad67994 --- /dev/null +++ b/sql/old/4.3.4/2012_08_06_01_world_classlevelstats_434.sql @@ -0,0 +1,6 @@ +ALTER TABLE `creature_classlevelstats` CHANGE `basehp0` `basehp0` mediumint(8) unsigned NOT NULL DEFAULT '1'; +ALTER TABLE `creature_classlevelstats` CHANGE `basehp1` `basehp1` mediumint(8) unsigned NOT NULL DEFAULT '1'; +ALTER TABLE `creature_classlevelstats` CHANGE `basehp2` `basehp2` mediumint(8) unsigned NOT NULL DEFAULT '1'; +ALTER TABLE `creature_classlevelstats` CHANGE `basehp3` `basehp3` mediumint(8) unsigned NOT NULL DEFAULT '1'; +ALTER TABLE `creature_classlevelstats` CHANGE `basemana` `basemana` mediumint(8) unsigned NOT NULL DEFAULT '1'; +ALTER TABLE `creature_classlevelstats` CHANGE `basearmor` `basearmor` mediumint(8) unsigned NOT NULL DEFAULT '1'; diff --git a/sql/old/4.3.4/2012_08_07_00_characters_characters_434.sql b/sql/old/4.3.4/2012_08_07_00_characters_characters_434.sql new file mode 100644 index 00000000000..e9bea82ad4b --- /dev/null +++ b/sql/old/4.3.4/2012_08_07_00_characters_characters_434.sql @@ -0,0 +1,2 @@ +UPDATE characters SET drunk = (drunk / 256) & 0xFF; +ALTER TABLE characters CHANGE drunk drunk tinyint(3) unsigned NOT NULL DEFAULT '0'; diff --git a/sql/old/4.3.4/2012_08_07_01_characters_void_storage_434.sql b/sql/old/4.3.4/2012_08_07_01_characters_void_storage_434.sql new file mode 100644 index 00000000000..8a68ba3740d --- /dev/null +++ b/sql/old/4.3.4/2012_08_07_01_characters_void_storage_434.sql @@ -0,0 +1 @@ +RENAME TABLE `void_storage` TO `character_void_storage`; diff --git a/sql/old/4.3.4/2012_08_08_00_world_creature_template_434.sql b/sql/old/4.3.4/2012_08_08_00_world_creature_template_434.sql new file mode 100644 index 00000000000..1e934b9f612 --- /dev/null +++ b/sql/old/4.3.4/2012_08_08_00_world_creature_template_434.sql @@ -0,0 +1 @@ +ALTER TABLE `creature_template` ADD `Mana_mod_extra` float NOT NULL DEFAULT '1' AFTER `Mana_mod`; diff --git a/sql/old/4.3.4/2012_08_12_00_world_misc_434.sql b/sql/old/4.3.4/2012_08_12_00_world_misc_434.sql new file mode 100644 index 00000000000..740b9c3582c --- /dev/null +++ b/sql/old/4.3.4/2012_08_12_00_world_misc_434.sql @@ -0,0 +1,59 @@ +UPDATE `creature_template` SET `ScriptName`='' WHERE `ScriptName` IN ( +'mobs_spitelashes', +'npc_loramus_thalipedes', +'mob_rizzle_sprysprocket', +'mob_depth_charge', +'npc_geezle', +'boss_azuregos', +'npc_kerlonian', +'npc_prospector_remtravel', +'npc_threshwackonator', +'go_iruxos', +'npc_dalinda', +'npc_tiger_matriarch_credit', +'npc_tiger_matriarch', +'npc_troll_volunteer', +'mobs_risen_husk_spirit', +'npc_lady_jaina_proudmoore', +'npc_nat_pagle', +'npc_private_hendel', +'npc_zelfrax', +'npc_theramore_guard', +'npcs_riverbreeze_and_silversky', +'npc_gregan_brewspewer', +'npc_oox22fe', +'npc_screecher_spirit', +'npc_bunthen_plainswind', +'npc_great_bear_spirit', +'npc_silva_filnaveth', +'npc_clintar_dreamwalker', +'npc_clintar_spirit', +'npc_plains_vision', +'npc_shenthul', +'npc_thrall_warchief', +'go_crystalline_tear', +'npc_anachronos_quest_trigger', +'npc_anachronos_the_ancient', +'mob_qiraj_war_spawn', +'npc_braug_dimspirit', +'npc_kaya_flathoof', +'mob_aquementas', +'npc_marin_noggenfogger', +'npc_stone_watcher_of_norgannon', +'npc_tooga', +'npc_beaten_corpse', +'npc_gilthares', +'npc_sputtervalve', +'npc_taskmaster_fizzule', +'npc_twiggy_flathead', +'npc_kanati', +'npc_lakota_windsong', +'npc_paoka_swiftmountain', +'npc_plucky', +'npc_enraged_panther', +'go_panther_cage', +'npc_ame', +'npc_ringo' +); + +DELETE FROM `spell_script_names` WHERE `ScriptName` IN ('spell_mount_check','spell_voljin_war_drums'); diff --git a/sql/old/4.3.4/2012_08_12_03_world_misc_434.sql b/sql/old/4.3.4/2012_08_12_03_world_misc_434.sql new file mode 100644 index 00000000000..aa6c11ee1f8 --- /dev/null +++ b/sql/old/4.3.4/2012_08_12_03_world_misc_434.sql @@ -0,0 +1,38 @@ +DELETE FROM `creature_text` WHERE `entry`=2768; +INSERT INTO `creature_text` (`entry`, `groupid`, `id`, `text`, `type`, `language`, `probability`, `emote`, `duration`, `sound`, `comment`) VALUES +(2768,0,0,'Ok, $N. Follow me to the cave where I''ll attempt to harness the power of the rune stone into these goggles.',12,0,100,0,0,0,'Professor Phizzlethorpe - SAY_PROGRESS_1'), +(2768,1,0,'I discovered this cave on our first day here. I believe the energy in the stone can be used to our advantage.',12,0,100,0,0,0,'Professor Phizzlethorpe - SAY_PROGRESS_2'), +(2768,2,0,'I''ll begin drawing energy from the stone. Your job, $N, is to defend me. This place is cursed... trust me.',12,0,100,0,0,0,'Professor Phizzlethorpe - SAY_PROGRESS_3'), +(2768,3,0,'%s begins tinkering with the goggles before the stone.',16,0,100,0,0,0,'Professor Phizzlethorpe - EMOTE_PROGRESS_4'), +(2768,4,0,'Help!!! Get these things off me so I can get my work done!',12,0,100,0,0,0,'Professor Phizzlethorpe - SAY_AGGRO'), +(2768,5,0,'Almost done! Just a little longer!',12,0,100,0,0,0,'Professor Phizzlethorpe - SAY_PROGRESS_5'), +(2768,6,0,'I''ve done it! I have harnessed the power of the stone into the goggles! Let''s get out of here!',12,0,100,0,0,0,'Professor Phizzlethorpe - SAY_PROGRESS_6'), +(2768,7,0,'Phew! Glad to be back from that creepy cave.',12,0,100,0,0,0,'Professor Phizzlethorpe - SAY_PROGRESS_7'), +(2768,8,0,'%s hands one glowing goggles over to Doctor Draxlegauge.',16,0,100,0,0,0,'Professor Phizzlethorpe - EMOTE_PROGRESS_8'), +(2768,9,0,'Doctor Draxlegauge will give you further instructions, $N. Many thanks for your help!',12,0,100,0,0,0,'Professor Phizzlethorpe - SAY_PROGRESS_9'); + +DELETE FROM `script_waypoint` WHERE `entry`=2768; +INSERT INTO `script_waypoint` (`entry`, `pointid`, `location_x`, `location_y`, `location_z`, `waittime`, `point_comment`) VALUES +(2768,1,-2072.32,-2089.59,9.14603,0,''), +(2768,2,-2078.18,-2096.31,10.8916,0,''), +(2768,3,-2079.21,-2105.22,13.3174,0,''), +(2768,4,-2074.81,-2108.72,14.1485,0,''), +(2768,5,-2076,-2116.21,16.3934,0,''), +(2768,6,-2073.31,-2123.92,18.6202,4000,''), +(2768,7,-2064.41,-2133.33,21.5776,0,''), +(2768,8,-2044.08,-2153.12,20.121,18000,''), +(2768,9,-2044.08,-2153.12,20.121,3000,''), +(2768,10,-2044.08,-2153.12,20.121,0,''), +(2768,11,-2044.08,-2153.12,20.121,14000,''), +(2768,12,-2063.89,-2133.33,21.5648,0,''), +(2768,13,-2075,-2121.98,17.8443,0,''), +(2768,14,-2074.83,-2108.53,14.1036,0,''), +(2768,15,-2079.59,-2091.61,9.80862,0,''), +(2768,16,-2071.29,-2086.44,8.5181,0,''), +(2768,17,-2066.46,-2085.97,8.9241,7000,''); + +DELETE FROM `creature_questrelation` WHERE `id`=2768 AND `quest`=26050; +INSERT INTO `creature_questrelation` (`id`, `quest`) +VALUES (2768, 26050); + +UPDATE `creature_template` SET `ScriptName`='npc_professor_phizzlethorpe' WHERE `entry`=2768;
\ No newline at end of file diff --git a/sql/old/4.3.4/2012_08_13_00_world_quest_template_434.sql b/sql/old/4.3.4/2012_08_13_00_world_quest_template_434.sql new file mode 100644 index 00000000000..d4a0960e044 --- /dev/null +++ b/sql/old/4.3.4/2012_08_13_00_world_quest_template_434.sql @@ -0,0 +1,2 @@ +-- ALTER TABLE `quest_template` CHANGE `MinLevel` `MinLevel` tinyint(4) NOT NULL DEFAULT '0'; +-- Properly fixed in 53a2b8622812f365ca7d31fdbf75fe9a1707ac7 diff --git a/sql/old/4.3.4/2012_08_14_00_world_event_ai_434.sql b/sql/old/4.3.4/2012_08_14_00_world_event_ai_434.sql new file mode 100644 index 00000000000..3fe49aa4059 --- /dev/null +++ b/sql/old/4.3.4/2012_08_14_00_world_event_ai_434.sql @@ -0,0 +1,3 @@ +DROP TABLE `creature_ai_scripts`; +DROP TABLE `creature_ai_summons`; +DROP TABLE `creature_ai_texts`; diff --git a/sql/old/4.3.4/2012_08_14_00_world_reputation_spillover_template_434.sql b/sql/old/4.3.4/2012_08_14_00_world_reputation_spillover_template_434.sql new file mode 100644 index 00000000000..afce8209afa --- /dev/null +++ b/sql/old/4.3.4/2012_08_14_00_world_reputation_spillover_template_434.sql @@ -0,0 +1,13 @@ +ALTER TABLE `reputation_spillover_template` +ADD COLUMN `faction5` SMALLINT(6) UNSIGNED DEFAULT '0' NOT NULL AFTER `rank_4`, +ADD COLUMN `rate_5` FLOAT DEFAULT '0' NOT NULL AFTER `faction5`, +ADD COLUMN `rank_5` TINYINT(3) UNSIGNED DEFAULT '0' NOT NULL AFTER `rate_5`; + +UPDATE `reputation_spillover_template` SET `faction5`=1134,`rate_5`=0.25,`rank_5`=7 WHERE `faction` IN (72,47,54,930,69); +UPDATE `reputation_spillover_template` SET `faction5`=1133,`rate_5`=0.25,`rank_5`=7 WHERE `faction` IN (76,530,911,81,68); + +DELETE FROM `reputation_spillover_template` WHERE `faction` IN (1134,1133); +INSERT INTO `reputation_spillover_template`(`faction`,`faction1`,`rate_1`,`rank_1`,`faction2`,`rate_2`,`rank_2`,`faction3`,`rate_3`,`rank_3`,`faction4`,`rate_4`,`rank_4`,`faction5`,`rate_5`,`rank_5`) VALUES +(1134,72,0.25,7,47,0.27,7,54,0.25,7,930,0.25,7,69,0.25,7), +(1133,76,0.25,7,530,0.27,7,911,0.25,7,81,0.25,7,68,0.25,7); + diff --git a/sql/old/4.3.4/2012_08_14_01_world_commands_434.sql b/sql/old/4.3.4/2012_08_14_01_world_commands_434.sql new file mode 100644 index 00000000000..aa030e01adb --- /dev/null +++ b/sql/old/4.3.4/2012_08_14_01_world_commands_434.sql @@ -0,0 +1 @@ +DELETE FROM `command` WHERE `name`='reload all eventai'; diff --git a/sql/old/4.3.4/2012_08_14_02_world_npc_vendor_434.sql b/sql/old/4.3.4/2012_08_14_02_world_npc_vendor_434.sql new file mode 100644 index 00000000000..de00be694fc --- /dev/null +++ b/sql/old/4.3.4/2012_08_14_02_world_npc_vendor_434.sql @@ -0,0 +1,6 @@ +ALTER TABLE `npc_vendor` ADD `type` tinyint(3) unsigned NOT NULL DEFAULT '1'; +ALTER TABLE `game_event_npc_vendor` ADD `type` tinyint(3) unsigned NOT NULL DEFAULT '1'; +ALTER TABLE `npc_vendor` CHANGE `maxcount` `maxcount` mediumint(8) unsigned NOT NULL DEFAULT '0'; +ALTER TABLE `game_event_npc_vendor` CHANGE `maxcount` `maxcount` mediumint(8) unsigned NOT NULL DEFAULT '0'; +UPDATE `trinity_string` SET `content_default` = 'Item \'%u\' (type %u) not found in database.' WHERE `entry`=207; +UPDATE `trinity_string` SET `content_default` = 'Item \'%u\' (with extended cost %u, type %u) already in vendor list' WHERE `entry`=210; diff --git a/sql/old/4.3.4/2012_08_15_00_world_quest_template_434.sql b/sql/old/4.3.4/2012_08_15_00_world_quest_template_434.sql new file mode 100644 index 00000000000..423edb1c77b --- /dev/null +++ b/sql/old/4.3.4/2012_08_15_00_world_quest_template_434.sql @@ -0,0 +1,2 @@ +ALTER TABLE `quest_template` CHANGE `MinLevel` `MinLevel` smallint(6) NOT NULL DEFAULT '0'; +ALTER TABLE `quest_template` CHANGE `MaxLevel` `MaxLevel` smallint(6) NOT NULL DEFAULT '0'; diff --git a/sql/old/4.3.4/2012_08_15_01_world_misc_434.sql b/sql/old/4.3.4/2012_08_15_01_world_misc_434.sql new file mode 100644 index 00000000000..dae8500479b --- /dev/null +++ b/sql/old/4.3.4/2012_08_15_01_world_misc_434.sql @@ -0,0 +1,3 @@ +ALTER TABLE `quest_poi` DROP INDEX `idx`; +ALTER TABLE `game_event_npc_vendor` DROP INDEX `PRIMARY`, ADD PRIMARY KEY (`guid`, `item`, `ExtendedCost`, `type`); +ALTER TABLE `npc_vendor` DROP INDEX `PRIMARY`, ADD PRIMARY KEY (`entry`, `item`, `ExtendedCost`, `type`); diff --git a/sql/old/4.3.4/2012_08_15_01_world_spell_script_names_434.sql b/sql/old/4.3.4/2012_08_15_01_world_spell_script_names_434.sql new file mode 100644 index 00000000000..b280367c811 --- /dev/null +++ b/sql/old/4.3.4/2012_08_15_01_world_spell_script_names_434.sql @@ -0,0 +1,5 @@ +DELETE FROM `spell_script_names` WHERE `spell_id` IN (2912,5176,78674); +INSERT INTO `spell_script_names` (`spell_id`,`ScriptName`) VALUES +(2912, 'spell_dru_eclipse_energize'), +(5176, 'spell_dru_eclipse_energize'), +(78674, 'spell_dru_eclipse_energize'); diff --git a/sql/old/4.3.4/2012_08_15_02_world_quest_template_434.sql b/sql/old/4.3.4/2012_08_15_02_world_quest_template_434.sql new file mode 100644 index 00000000000..a435f54e639 --- /dev/null +++ b/sql/old/4.3.4/2012_08_15_02_world_quest_template_434.sql @@ -0,0 +1,5 @@ +ALTER TABLE `quest_template` CHANGE `RewardFactionValueIdOverride1` `RewardFactionValueIdOverride1` int(11) NOT NULL DEFAULT '0'; +ALTER TABLE `quest_template` CHANGE `RewardFactionValueIdOverride2` `RewardFactionValueIdOverride2` int(11) NOT NULL DEFAULT '0'; +ALTER TABLE `quest_template` CHANGE `RewardFactionValueIdOverride3` `RewardFactionValueIdOverride3` int(11) NOT NULL DEFAULT '0'; +ALTER TABLE `quest_template` CHANGE `RewardFactionValueIdOverride4` `RewardFactionValueIdOverride4` int(11) NOT NULL DEFAULT '0'; +ALTER TABLE `quest_template` CHANGE `RewardFactionValueIdOverride5` `RewardFactionValueIdOverride5` int(11) NOT NULL DEFAULT '0'; diff --git a/sql/old/4.3.4/2012_08_15_03_world_rep_spillover_template_434.sql b/sql/old/4.3.4/2012_08_15_03_world_rep_spillover_template_434.sql new file mode 100644 index 00000000000..08469f1b59e --- /dev/null +++ b/sql/old/4.3.4/2012_08_15_03_world_rep_spillover_template_434.sql @@ -0,0 +1 @@ +ALTER TABLE `reputation_spillover_template` CHANGE `faction5` `faction5` smallint(5) unsigned NOT NULL DEFAULT '0'; diff --git a/sql/old/4.3.4/2012_08_20_00_world_quest_template_434.sql b/sql/old/4.3.4/2012_08_20_00_world_quest_template_434.sql new file mode 100644 index 00000000000..ddd447acc50 --- /dev/null +++ b/sql/old/4.3.4/2012_08_20_00_world_quest_template_434.sql @@ -0,0 +1 @@ +ALTER TABLE `quest_template` CHANGE `RequiredRaces` `RequiredRaces` mediumint(8) unsigned NOT NULL DEFAULT '0'; diff --git a/sql/old/4.3.4/2012_08_22_00_characters_characters_434.sql b/sql/old/4.3.4/2012_08_22_00_characters_characters_434.sql new file mode 100644 index 00000000000..087f6f894eb --- /dev/null +++ b/sql/old/4.3.4/2012_08_22_00_characters_characters_434.sql @@ -0,0 +1 @@ +ALTER TABLE `characters` ADD `slot` TINYINT UNSIGNED NOT NULL DEFAULT '0' AFTER `name`; diff --git a/sql/old/4.3.4/2012_08_23_00_characters_guild_member434.sql b/sql/old/4.3.4/2012_08_23_00_characters_guild_member434.sql new file mode 100644 index 00000000000..cdd4781c0c0 --- /dev/null +++ b/sql/old/4.3.4/2012_08_23_00_characters_guild_member434.sql @@ -0,0 +1,4 @@ +ALTER TABLE guild_member ADD BankResetTimeTab6 INT(10) unsigned DEFAULT '0' AFTER BankRemSlotsTab5; +ALTER TABLE guild_member ADD BankRemSlotsTab6 INT(10) unsigned DEFAULT '0' AFTER BankResetTimeTab6; +ALTER TABLE guild_member ADD BankResetTimeTab7 INT(10) unsigned DEFAULT '0' AFTER BankRemSlotsTab6; +ALTER TABLE guild_member ADD BankRemSlotsTab7 INT(10) unsigned DEFAULT '0' AFTER BankResetTimeTab7; diff --git a/sql/old/4.3.4/2012_08_26_00_world_spell_script_names_434.sql b/sql/old/4.3.4/2012_08_26_00_world_spell_script_names_434.sql new file mode 100644 index 00000000000..d9bb921bf8a --- /dev/null +++ b/sql/old/4.3.4/2012_08_26_00_world_spell_script_names_434.sql @@ -0,0 +1,3 @@ +DELETE FROM `spell_script_names` WHERE `spell_id`=15473; +INSERT INTO `spell_script_names` (`spell_id`,`ScriptName`) VALUES +(15473,'spell_pri_shadowform'); diff --git a/sql/old/4.3.4/2012_08_27_00_characters_guild_bank_eventlog.sql b/sql/old/4.3.4/2012_08_27_00_characters_guild_bank_eventlog.sql new file mode 100644 index 00000000000..c019bc81504 --- /dev/null +++ b/sql/old/4.3.4/2012_08_27_00_characters_guild_bank_eventlog.sql @@ -0,0 +1 @@ +DELETE FROM `guild_bank_eventlog` WHERE `EventType` IN (3,7) AND `TabId`=`DestTabId`; -- delete log entries of item moves within one tab diff --git a/sql/old/4.3.4/2012_09_03_00_characters_currency_434.sql b/sql/old/4.3.4/2012_09_03_00_characters_currency_434.sql new file mode 100644 index 00000000000..fd6b3aaff10 --- /dev/null +++ b/sql/old/4.3.4/2012_09_03_00_characters_currency_434.sql @@ -0,0 +1,8 @@ +DROP TABLE IF EXISTS `character_currency`; +CREATE TABLE `character_currency` ( + `guid` int(10) unsigned NOT NULL, + `currency` smallint(5) unsigned NOT NULL, + `total_count` int(10) unsigned NOT NULL, + `week_count` int(10) unsigned NOT NULL, + PRIMARY KEY (`guid`,`currency`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8; diff --git a/sql/old/4.3.4/2012_09_03_01_characters_currency_434.sql b/sql/old/4.3.4/2012_09_03_01_characters_currency_434.sql new file mode 100644 index 00000000000..8b44fa43bd3 --- /dev/null +++ b/sql/old/4.3.4/2012_09_03_01_characters_currency_434.sql @@ -0,0 +1,3 @@ +-- porting from characters table +INSERT INTO `character_currency` (`guid`, `currency`, `total_count`, `week_count`) SELECT `characters`.`guid`, 392, `characters`.`totalHonorPoints`, 0 FROM `characters` WHERE `characters`.`totalHonorPoints` > 0; +INSERT INTO `character_currency` (`guid`, `currency`, `total_count`, `week_count`) SELECT `characters`.`guid`, 390, `characters`.`conquestPoints`, 0 FROM `characters` WHERE `characters`.`conquestPoints` > 0; diff --git a/sql/old/4.3.4/2012_09_03_02_characters_characters_434.sql b/sql/old/4.3.4/2012_09_03_02_characters_characters_434.sql new file mode 100644 index 00000000000..db61cbb1c88 --- /dev/null +++ b/sql/old/4.3.4/2012_09_03_02_characters_characters_434.sql @@ -0,0 +1,2 @@ +ALTER TABLE `characters` DROP `conquestPoints`; +ALTER TABLE `characters` DROP `totalHonorPoints`; diff --git a/sql/old/4.3.4/2012_09_04_00_characters_character_cuf_profiles_434.sql b/sql/old/4.3.4/2012_09_04_00_characters_character_cuf_profiles_434.sql new file mode 100644 index 00000000000..394c0912601 --- /dev/null +++ b/sql/old/4.3.4/2012_09_04_00_characters_character_cuf_profiles_434.sql @@ -0,0 +1,19 @@ +DROP TABLE IF EXISTS `character_cuf_profiles`; +CREATE TABLE IF NOT EXISTS `character_cuf_profiles` ( + `guid` int(10) unsigned NOT NULL COMMENT 'Character Guid', + `id` tinyint(3) unsigned NOT NULL COMMENT 'Profile Id (0-4)', + `name` varchar(12) NOT NULL COMMENT 'Profile Name', + `frameHeight` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Profile Frame Height', + `frameWidth` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Profile Frame Width', + `sortBy` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT 'Frame Sort By', + `healthText` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT 'Frame Health Text', + `boolOptions` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Many Configurable Bool Options', + `unk146` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT 'Profile Unk Int8', + `unk147` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT 'Profile Unk Int8', + `unk148` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT 'Profile Unk Int8', + `unk150` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Profile Unk Int16', + `unk152` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Profile Unk Int16', + `unk154` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Profile Unk Int16', + PRIMARY KEY (`guid`,`id`), + KEY `index` (`id`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8; diff --git a/sql/old/4.3.4/2012_09_07_00_characters_guild_434.sql b/sql/old/4.3.4/2012_09_07_00_characters_guild_434.sql new file mode 100644 index 00000000000..31695bab93f --- /dev/null +++ b/sql/old/4.3.4/2012_09_07_00_characters_guild_434.sql @@ -0,0 +1,3 @@ +ALTER TABLE guild ADD `level` INT(10) unsigned DEFAULT '1' AFTER `BankMoney`; +ALTER TABLE guild ADD `experience` BIGINT(20) unsigned DEFAULT '0' AFTER `level`; +ALTER TABLE guild ADD `todayExperience` BIGINT(20) unsigned DEFAULT '0' AFTER `experience`; diff --git a/sql/old/4.3.4/2012_09_09_00_characters_guild_news_434.sql b/sql/old/4.3.4/2012_09_09_00_characters_guild_news_434.sql new file mode 100644 index 00000000000..78fa817678b --- /dev/null +++ b/sql/old/4.3.4/2012_09_09_00_characters_guild_news_434.sql @@ -0,0 +1,11 @@ +DROP TABLE IF EXISTS `guild_news_log`; +CREATE TABLE `guild_news_log` ( + `guild` int(10) unsigned NOT NULL, + `id` int(10) unsigned NOT NULL, + `eventType` int(10) unsigned NOT NULL, + `playerGuid` bigint(20) unsigned NOT NULL, + `data` int(10) unsigned NOT NULL, + `flags` int(10) unsigned NOT NULL, + `date` int(10) unsigned NOT NULL DEFAULT '0', + PRIMARY KEY (`guild`,`id`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8; diff --git a/sql/old/4.3.4/2012_09_09_00_world_guild_xp_for_level.sql b/sql/old/4.3.4/2012_09_09_00_world_guild_xp_for_level.sql new file mode 100644 index 00000000000..aa2ee143d53 --- /dev/null +++ b/sql/old/4.3.4/2012_09_09_00_world_guild_xp_for_level.sql @@ -0,0 +1,33 @@ +DROP TABLE IF EXISTS `guild_xp_for_level`; +CREATE TABLE `guild_xp_for_level` ( + `lvl` int(11) unsigned NOT NULL, + `xp_for_next_level` bigint(20) unsigned NOT NULL DEFAULT '0', + PRIMARY KEY (`lvl`) +) ENGINE=MyISAM DEFAULT CHARSET=utf8; + +INSERT INTO `guild_xp_for_level` VALUES +(1,16580000), +(2,18240000), +(3,19900000), +(4,21550000), +(5,23220000), +(6,24880000), +(7,26530000), +(8,28190000), +(9,29850000), +(10,31510000), +(11,33170000), +(12,34820000), +(13,36490000), +(14,38140000), +(15,39800000), +(16,41450000), +(17,43120000), +(18,44780000), +(19,46430000), +(20,48090000), +(21,49750000), +(22,51410000), +(23,53060000), +(24,54730000), +(25,56390000); diff --git a/sql/old/4.3.4/2012_09_09_01_world_spell_script_names.sql b/sql/old/4.3.4/2012_09_09_01_world_spell_script_names.sql new file mode 100644 index 00000000000..5c1701e45bd --- /dev/null +++ b/sql/old/4.3.4/2012_09_09_01_world_spell_script_names.sql @@ -0,0 +1,5 @@ +DELETE FROM `spell_script_names` WHERE `ScriptName` IN ('spell_warr_improved_spell_reflection', 'spell_warr_vigilance', 'spell_warr_charge', 'spell_warr_slam', 'spell_warr_execute', 'spell_warr_overpower'); +INSERT INTO `spell_script_names`(`spell_id`,`ScriptName`) VALUES +(100,'spell_warr_charge'), +(1464,'spell_warr_slam'), +(5308,'spell_warr_execute'); diff --git a/sql/old/4.3.4/2012_09_09_02_world_spell_script_names_434.sql b/sql/old/4.3.4/2012_09_09_02_world_spell_script_names_434.sql new file mode 100644 index 00000000000..a4304663d9c --- /dev/null +++ b/sql/old/4.3.4/2012_09_09_02_world_spell_script_names_434.sql @@ -0,0 +1,4 @@ +DELETE FROM `spell_script_names` WHERE `ScriptName` IN ('spell_warl_banish','spell_warl_create_healthstone','spell_warl_ritual_of_doom_effect'); +INSERT INTO `spell_script_names`(`spell_id`,`ScriptName`) VALUES +(710,'spell_warl_banish'), +(6201,'spell_warl_create_healthstone'); diff --git a/sql/old/4.3.4/2012_09_09_05_world_guild_rewards_434.sql b/sql/old/4.3.4/2012_09_09_05_world_guild_rewards_434.sql new file mode 100644 index 00000000000..b05b9d959c7 --- /dev/null +++ b/sql/old/4.3.4/2012_09_09_05_world_guild_rewards_434.sql @@ -0,0 +1,53 @@ +DROP TABLE IF EXISTS `guild_rewards`; +CREATE TABLE `guild_rewards` ( + `entry` int(10) unsigned NOT NULL DEFAULT '0', + `standing` tinyint(3) unsigned DEFAULT '0', + `racemask` int(11) DEFAULT '0', + `price` bigint(20) unsigned DEFAULT '0', + `achievement` int(10) unsigned DEFAULT '0', + PRIMARY KEY (`entry`) +) engine=MyISAM DEFAULT CHARSET=utf8; + +INSERT INTO `guild_rewards` values +(69209, 4, -1, 1250000, 0), +(69210, 5, -1, 2500000, 0), +(63353, 5, 946, 1500000, 4989), +(63352, 5, 2098253, 1500000, 4989), +(63207, 5, 946, 3000000, 4945), +(63206, 5, 2098253, 3000000, 4945), +(65274, 6, 946, 5000000, 5035), +(65360, 6, 2098253, 5000000, 5035), +(65362, 5, 946, 3000000, 5179), +(65364, 6, 946, 5000000, 5201), +(65361, 5, 2098253, 3000000, 5031), +(65363, 6, 2098253, 5000000, 5201), +(63138, 7, -1, 3000000, 5812), +(63398, 6, 0, 3000000, 5144), +(63359, 5, 2098253, 1500000, 4860), +(64398, 5, 2098253, 2000000, 5143), +(64399, 5, 2098253, 3000000, 5422), +(64400, 5, 946, 1500000, 4860), +(64401, 5, 946, 2000000, 5143), +(64402, 5, 946, 3000000, 5422), +(62800, 5, 0, 1500000, 5036), +(62799, 5, 0, 1500000, 5467), +(65435, 5, 0, 1500000, 5465), +(65498, 5, 0, 1500000, 5024), +(62286, 4, 0, 100000000, 4943), +(68136, 6, 2098253, 200000000, 5152), +(62287, 6, 946, 200000000, 5158), +(69892, 5, 0, 12000000, 4944), +(62038, 5, 0, 12000000, 4944), +(62039, 5, 0, 12000000, 4944), +(62040, 5, 0, 12000000, 4944), +(69887, 5, 0, 15000000, 4946), +(61958, 5, 0, 15000000, 4946), +(61942, 5, 0, 15000000, 4946), +(61937, 5, 0, 15000000, 4946), +(61936, 5, 0, 15000000, 4946), +(61935, 5, 0, 15000000, 4946), +(61931, 5, 0, 15000000, 4946), +(67107, 7, 946, 15000000, 5492), +(62298, 7, 2098253, 15000000, 4912), +(63125, 7, 0, 30000000, 4988), +(71033, 7, 0, 15000000, 5840); diff --git a/sql/old/4.3.4/2012_09_10_00_characters_guild_finder_434.sql b/sql/old/4.3.4/2012_09_10_00_characters_guild_finder_434.sql new file mode 100644 index 00000000000..d4d524e0bef --- /dev/null +++ b/sql/old/4.3.4/2012_09_10_00_characters_guild_finder_434.sql @@ -0,0 +1,40 @@ +/*!40101 SET NAMES utf8 */; + +/*!40101 SET SQL_MODE=''*/; + +/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */; +/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; +/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; +/* Table structure for table `guild_finder_applicant` */ + +DROP TABLE IF EXISTS `guild_finder_applicant`; + +CREATE TABLE `guild_finder_applicant` ( + `guildId` int(10) unsigned DEFAULT NULL, + `playerGuid` int(10) unsigned DEFAULT NULL, + `availability` tinyint(3) unsigned DEFAULT '0', + `classRole` tinyint(3) unsigned DEFAULT '0', + `interests` tinyint(3) unsigned DEFAULT '0', + `comment` varchar(255) DEFAULT NULL, + `submitTime` int(10) unsigned DEFAULT NULL, + UNIQUE KEY `guildId` (`guildId`,`playerGuid`) +) ENGINE=InnoDB DEFAULT CHARSET=latin1; + +/* Table structure for table `guild_finder_guild_settings` */ + +DROP TABLE IF EXISTS `guild_finder_guild_settings`; + +CREATE TABLE `guild_finder_guild_settings` ( + `guildId` int(10) unsigned NOT NULL, + `availability` tinyint(3) unsigned NOT NULL DEFAULT '0', + `classRoles` tinyint(3) unsigned NOT NULL DEFAULT '0', + `interests` tinyint(3) unsigned NOT NULL DEFAULT '0', + `level` tinyint(3) unsigned NOT NULL DEFAULT '1', + `listed` tinyint(3) unsigned NOT NULL DEFAULT '0', + `comment` varchar(255) DEFAULT NULL, + PRIMARY KEY (`guildId`) +) ENGINE=InnoDB DEFAULT CHARSET=latin1; + +/*!40101 SET SQL_MODE=@OLD_SQL_MODE */; +/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */; +/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; |