From 53a2b8622812f365ca7d31fdbf75fe9a1707ac75 Mon Sep 17 00:00:00 2001 From: Nay Date: Wed, 15 Aug 2012 18:00:11 +0100 Subject: Core&DB: Increase the size of MinLevel and MaxLevel to int16 --- sql/updates/world/2012_08_13_00_world_quest_template.sql | 1 - .../world/2012_08_13_00_world_quest_template_434.sql | 1 + .../world/2012_08_14_00_reputation_spillover_template.sql | 13 ------------- .../2012_08_14_00_reputation_spillover_template_434.sql | 13 +++++++++++++ sql/updates/world/2012_08_14_00_world_event_ai.sql | 3 --- sql/updates/world/2012_08_14_00_world_event_ai_434.sql | 3 +++ sql/updates/world/2012_08_14_01_world_commands.sql | 1 - sql/updates/world/2012_08_14_01_world_commands_434.sql | 1 + sql/updates/world/2012_08_14_02_world_npc_vendor.sql | 6 ------ sql/updates/world/2012_08_14_02_world_npc_vendor_434.sql | 6 ++++++ .../world/2012_08_15_00_world_quest_template_434.sql | 2 ++ 11 files changed, 26 insertions(+), 24 deletions(-) delete mode 100644 sql/updates/world/2012_08_13_00_world_quest_template.sql create mode 100644 sql/updates/world/2012_08_13_00_world_quest_template_434.sql delete mode 100644 sql/updates/world/2012_08_14_00_reputation_spillover_template.sql create mode 100644 sql/updates/world/2012_08_14_00_reputation_spillover_template_434.sql delete mode 100644 sql/updates/world/2012_08_14_00_world_event_ai.sql create mode 100644 sql/updates/world/2012_08_14_00_world_event_ai_434.sql delete mode 100644 sql/updates/world/2012_08_14_01_world_commands.sql create mode 100644 sql/updates/world/2012_08_14_01_world_commands_434.sql delete mode 100644 sql/updates/world/2012_08_14_02_world_npc_vendor.sql create mode 100644 sql/updates/world/2012_08_14_02_world_npc_vendor_434.sql create mode 100644 sql/updates/world/2012_08_15_00_world_quest_template_434.sql (limited to 'sql') diff --git a/sql/updates/world/2012_08_13_00_world_quest_template.sql b/sql/updates/world/2012_08_13_00_world_quest_template.sql deleted file mode 100644 index b3c5a45a668..00000000000 --- a/sql/updates/world/2012_08_13_00_world_quest_template.sql +++ /dev/null @@ -1 +0,0 @@ -ALTER TABLE `quest_template` CHANGE `MinLevel` `MinLevel` tinyint(4) NOT NULL DEFAULT '0'; diff --git a/sql/updates/world/2012_08_13_00_world_quest_template_434.sql b/sql/updates/world/2012_08_13_00_world_quest_template_434.sql new file mode 100644 index 00000000000..b3c5a45a668 --- /dev/null +++ b/sql/updates/world/2012_08_13_00_world_quest_template_434.sql @@ -0,0 +1 @@ +ALTER TABLE `quest_template` CHANGE `MinLevel` `MinLevel` tinyint(4) NOT NULL DEFAULT '0'; diff --git a/sql/updates/world/2012_08_14_00_reputation_spillover_template.sql b/sql/updates/world/2012_08_14_00_reputation_spillover_template.sql deleted file mode 100644 index afce8209afa..00000000000 --- a/sql/updates/world/2012_08_14_00_reputation_spillover_template.sql +++ /dev/null @@ -1,13 +0,0 @@ -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/updates/world/2012_08_14_00_reputation_spillover_template_434.sql b/sql/updates/world/2012_08_14_00_reputation_spillover_template_434.sql new file mode 100644 index 00000000000..afce8209afa --- /dev/null +++ b/sql/updates/world/2012_08_14_00_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/updates/world/2012_08_14_00_world_event_ai.sql b/sql/updates/world/2012_08_14_00_world_event_ai.sql deleted file mode 100644 index 3fe49aa4059..00000000000 --- a/sql/updates/world/2012_08_14_00_world_event_ai.sql +++ /dev/null @@ -1,3 +0,0 @@ -DROP TABLE `creature_ai_scripts`; -DROP TABLE `creature_ai_summons`; -DROP TABLE `creature_ai_texts`; diff --git a/sql/updates/world/2012_08_14_00_world_event_ai_434.sql b/sql/updates/world/2012_08_14_00_world_event_ai_434.sql new file mode 100644 index 00000000000..3fe49aa4059 --- /dev/null +++ b/sql/updates/world/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/updates/world/2012_08_14_01_world_commands.sql b/sql/updates/world/2012_08_14_01_world_commands.sql deleted file mode 100644 index aa030e01adb..00000000000 --- a/sql/updates/world/2012_08_14_01_world_commands.sql +++ /dev/null @@ -1 +0,0 @@ -DELETE FROM `command` WHERE `name`='reload all eventai'; diff --git a/sql/updates/world/2012_08_14_01_world_commands_434.sql b/sql/updates/world/2012_08_14_01_world_commands_434.sql new file mode 100644 index 00000000000..aa030e01adb --- /dev/null +++ b/sql/updates/world/2012_08_14_01_world_commands_434.sql @@ -0,0 +1 @@ +DELETE FROM `command` WHERE `name`='reload all eventai'; diff --git a/sql/updates/world/2012_08_14_02_world_npc_vendor.sql b/sql/updates/world/2012_08_14_02_world_npc_vendor.sql deleted file mode 100644 index de00be694fc..00000000000 --- a/sql/updates/world/2012_08_14_02_world_npc_vendor.sql +++ /dev/null @@ -1,6 +0,0 @@ -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/updates/world/2012_08_14_02_world_npc_vendor_434.sql b/sql/updates/world/2012_08_14_02_world_npc_vendor_434.sql new file mode 100644 index 00000000000..de00be694fc --- /dev/null +++ b/sql/updates/world/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/updates/world/2012_08_15_00_world_quest_template_434.sql b/sql/updates/world/2012_08_15_00_world_quest_template_434.sql new file mode 100644 index 00000000000..423edb1c77b --- /dev/null +++ b/sql/updates/world/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'; -- cgit v1.2.3