From 3a77dec6e6fac47fedeb0aeddd09dfe12c3817a2 Mon Sep 17 00:00:00 2001 From: Shauren Date: Tue, 19 Jul 2016 09:03:43 +0200 Subject: Rename 9999_99_99_99_world.sql to sql/updates/world/3.3.5/2016_07_19_00_world.sql --- sql/updates/world/3.3.5/2016_07_19_00_world.sql | 20 ++++++++++++++++++++ sql/updates/world/3.3.5/9999_99_99_99_world.sql | 20 -------------------- 2 files changed, 20 insertions(+), 20 deletions(-) create mode 100644 sql/updates/world/3.3.5/2016_07_19_00_world.sql delete mode 100644 sql/updates/world/3.3.5/9999_99_99_99_world.sql (limited to 'sql') diff --git a/sql/updates/world/3.3.5/2016_07_19_00_world.sql b/sql/updates/world/3.3.5/2016_07_19_00_world.sql new file mode 100644 index 00000000000..ae623f25db0 --- /dev/null +++ b/sql/updates/world/3.3.5/2016_07_19_00_world.sql @@ -0,0 +1,20 @@ +-- +DROP TABLE IF EXISTS `quest_mail_sender`; +CREATE TABLE `quest_mail_sender` +( + `QuestId` INT(5) UNSIGNED NOT NULL DEFAULT 0, + `RewardMailSenderEntry` INT(5) UNSIGNED NOT NULL DEFAULT 0, + PRIMARY KEY (`QuestId`) +); + +INSERT INTO `quest_mail_sender` (`QuestId`, `RewardMailSenderEntry`) VALUES +(8729, 11811), -- Quest The Wrath of Neptulon sends mail from Narain Soothfancy +(10588, 18166), -- Quest The Cipher of Damnation sends mail from Archmage Khadgar +(12085, 5885), -- Quest A Letter for Home (Horde) sends mail from Deino +(12067, 2708), -- Quest A Letter for Home (Alliance) sends mail from Archmage Malin +(12422, 27102), -- Quest Tactical Clemency sends mail from Gorgonna +(12711, 28930), -- Quest Abandoned Mail sends mail from Dansel Adams +(22817, 10967), -- Quest Back to the Orphanage (Blood Elf) sends mail from Blood Elf Orphan +(22818, 10966), -- Quest Back to the Orphanage (Draenei) sends mail from Draenei Orphan +(28879, 33533), -- Quest Back To The Orphanage (Oracle) sends mail from Oracle Orphan +(28880, 33532); -- Quest Back To The Orphanage (Wolvar) sends mail from Wolvar Orphan diff --git a/sql/updates/world/3.3.5/9999_99_99_99_world.sql b/sql/updates/world/3.3.5/9999_99_99_99_world.sql deleted file mode 100644 index ae623f25db0..00000000000 --- a/sql/updates/world/3.3.5/9999_99_99_99_world.sql +++ /dev/null @@ -1,20 +0,0 @@ --- -DROP TABLE IF EXISTS `quest_mail_sender`; -CREATE TABLE `quest_mail_sender` -( - `QuestId` INT(5) UNSIGNED NOT NULL DEFAULT 0, - `RewardMailSenderEntry` INT(5) UNSIGNED NOT NULL DEFAULT 0, - PRIMARY KEY (`QuestId`) -); - -INSERT INTO `quest_mail_sender` (`QuestId`, `RewardMailSenderEntry`) VALUES -(8729, 11811), -- Quest The Wrath of Neptulon sends mail from Narain Soothfancy -(10588, 18166), -- Quest The Cipher of Damnation sends mail from Archmage Khadgar -(12085, 5885), -- Quest A Letter for Home (Horde) sends mail from Deino -(12067, 2708), -- Quest A Letter for Home (Alliance) sends mail from Archmage Malin -(12422, 27102), -- Quest Tactical Clemency sends mail from Gorgonna -(12711, 28930), -- Quest Abandoned Mail sends mail from Dansel Adams -(22817, 10967), -- Quest Back to the Orphanage (Blood Elf) sends mail from Blood Elf Orphan -(22818, 10966), -- Quest Back to the Orphanage (Draenei) sends mail from Draenei Orphan -(28879, 33533), -- Quest Back To The Orphanage (Oracle) sends mail from Oracle Orphan -(28880, 33532); -- Quest Back To The Orphanage (Wolvar) sends mail from Wolvar Orphan -- cgit v1.2.3