From 52a86950e1c4fb6c7f0eb1fbb5afcf8a08b6e18b Mon Sep 17 00:00:00 2001 From: Vincent_Michael Date: Sun, 28 Apr 2013 00:07:59 +0200 Subject: SQL: Add missing renames for merge --- sql/updates/world/2013_04_16_01_world_misc.sql | 10 ---------- sql/updates/world/2013_04_25_00_world_misc.sql | 1 - sql/updates/world/2013_04_27_00_world_misc.sql | 10 ++++++++++ sql/updates/world/2013_04_27_01_world_misc.sql | 1 + 4 files changed, 11 insertions(+), 11 deletions(-) delete mode 100644 sql/updates/world/2013_04_16_01_world_misc.sql delete mode 100644 sql/updates/world/2013_04_25_00_world_misc.sql create mode 100644 sql/updates/world/2013_04_27_00_world_misc.sql create mode 100644 sql/updates/world/2013_04_27_01_world_misc.sql (limited to 'sql') diff --git a/sql/updates/world/2013_04_16_01_world_misc.sql b/sql/updates/world/2013_04_16_01_world_misc.sql deleted file mode 100644 index 4c7561a0e69..00000000000 --- a/sql/updates/world/2013_04_16_01_world_misc.sql +++ /dev/null @@ -1,10 +0,0 @@ -DELETE FROM `command` WHERE `name` = 'guild rename'; -INSERT INTO `command` (`name`, `security`, `help`) VALUES -('guild rename', 3, 'Syntax: .guild rename "$GuildName" "$NewGuildName" \n\n Rename a guild named $GuildName with $NewGuildName. Guild name and new guild name must in quotes.'); - -SET @ENTRY1 := 96; -SET @ENTRY2 := 97; -DELETE FROM `trinity_string` WHERE `entry` IN (@ENTRY1, @ENTRY2); -INSERT INTO `trinity_string` (`entry`, `content_default`) VALUES -(@ENTRY1, 'The guild name \'%s\' is already taken'), -(@ENTRY2, 'Changed guild name \'%s\' to \'%s\''); diff --git a/sql/updates/world/2013_04_25_00_world_misc.sql b/sql/updates/world/2013_04_25_00_world_misc.sql deleted file mode 100644 index c07a3f76b5f..00000000000 --- a/sql/updates/world/2013_04_25_00_world_misc.sql +++ /dev/null @@ -1 +0,0 @@ -DROP TABLE IF EXISTS `autobroadcast`; diff --git a/sql/updates/world/2013_04_27_00_world_misc.sql b/sql/updates/world/2013_04_27_00_world_misc.sql new file mode 100644 index 00000000000..4c7561a0e69 --- /dev/null +++ b/sql/updates/world/2013_04_27_00_world_misc.sql @@ -0,0 +1,10 @@ +DELETE FROM `command` WHERE `name` = 'guild rename'; +INSERT INTO `command` (`name`, `security`, `help`) VALUES +('guild rename', 3, 'Syntax: .guild rename "$GuildName" "$NewGuildName" \n\n Rename a guild named $GuildName with $NewGuildName. Guild name and new guild name must in quotes.'); + +SET @ENTRY1 := 96; +SET @ENTRY2 := 97; +DELETE FROM `trinity_string` WHERE `entry` IN (@ENTRY1, @ENTRY2); +INSERT INTO `trinity_string` (`entry`, `content_default`) VALUES +(@ENTRY1, 'The guild name \'%s\' is already taken'), +(@ENTRY2, 'Changed guild name \'%s\' to \'%s\''); diff --git a/sql/updates/world/2013_04_27_01_world_misc.sql b/sql/updates/world/2013_04_27_01_world_misc.sql new file mode 100644 index 00000000000..c07a3f76b5f --- /dev/null +++ b/sql/updates/world/2013_04_27_01_world_misc.sql @@ -0,0 +1 @@ +DROP TABLE IF EXISTS `autobroadcast`; -- cgit v1.2.3