SQL: Move all world sql updates to /old/ directory. Base DB is available in https://github.com/TrinityCore/TrinityCore_4.3.4_DB_Alpha

From now on, this repository should only contain core related sqls
Aforementioned repository will be synced with this one from time to time and will include DB related content

20 files changed, 158 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_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_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_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';