4 files changed, 87 insertions, 0 deletions
diff --git a/sql/updates/auth/2015_04_11_00_auth.sql b/sql/updates/auth/2015_04_11_00_auth.sql
new file mode 100644
index 00000000000..495dc12df97
--- /dev/null
+++ b/sql/updates/auth/2015_04_11_00_auth.sql
@@ -0,0 +1 @@
+UPDATE `rbac_permissions` SET `name`='Command: reload quest_greeting' WHERE `id`=664;
diff --git a/sql/updates/world/2015_04_11_00_world.sql b/sql/updates/world/2015_04_11_00_world.sql
new file mode 100644
index 00000000000..c6cef3599a5
--- /dev/null
+++ b/sql/updates/world/2015_04_11_00_world.sql
@@ -0,0 +1,81 @@
+ALTER TABLE `npc_text`
+  DROP `text0_0`,
+  DROP `text0_1`,
+  DROP `lang0`,
+  DROP `em0_0`,
+  DROP `em0_1`,
+  DROP `em0_2`,
+  DROP `em0_3`,
+  DROP `em0_4`,
+  DROP `em0_5`,
+  CHANGE `prob0` `Probability0` FLOAT NOT NULL DEFAULT '0',
+  DROP `text1_0`,
+  DROP `text1_1`,
+  DROP `lang1`,
+  DROP `em1_0`,
+  DROP `em1_1`,
+  DROP `em1_2`,
+  DROP `em1_3`,
+  DROP `em1_4`,
+  DROP `em1_5`,
+  CHANGE `prob1` `Probability1` FLOAT NOT NULL DEFAULT '0',
+  DROP `text2_0`,
+  DROP `text2_1`,
+  DROP `lang2`,
+  DROP `em2_0`,
+  DROP `em2_1`,
+  DROP `em2_2`,
+  DROP `em2_3`,
+  DROP `em2_4`,
+  DROP `em2_5`,
+  CHANGE `prob2` `Probability2` FLOAT NOT NULL DEFAULT '0',
+  DROP `text3_0`,
+  DROP `text3_1`,
+  DROP `lang3`,
+  DROP `em3_0`,
+  DROP `em3_1`,
+  DROP `em3_2`,
+  DROP `em3_3`,
+  DROP `em3_4`,
+  DROP `em3_5`,
+  CHANGE `prob3` `Probability3` FLOAT NOT NULL DEFAULT '0',
+  DROP `text4_0`,
+  DROP `text4_1`,
+  DROP `lang4`,
+  DROP `em4_0`,
+  DROP `em4_1`,
+  DROP `em4_2`,
+  DROP `em4_3`,
+  DROP `em4_4`,
+  DROP `em4_5`,
+  CHANGE `prob4` `Probability4` FLOAT NOT NULL DEFAULT '0',
+  DROP `text5_0`,
+  DROP `text5_1`,
+  DROP `lang5`,
+  DROP `em5_0`,
+  DROP `em5_1`,
+  DROP `em5_2`,
+  DROP `em5_3`,
+  DROP `em5_4`,
+  DROP `em5_5`,
+  CHANGE `prob5` `Probability5` FLOAT NOT NULL DEFAULT '0',
+  DROP `text6_0`,
+  DROP `text6_1`,
+  DROP `lang6`,
+  DROP `em6_0`,
+  DROP `em6_1`,
+  DROP `em6_2`,
+  DROP `em6_3`,
+  DROP `em6_4`,
+  DROP `em6_5`,
+  CHANGE `prob6` `Probability6` FLOAT NOT NULL DEFAULT '0',
+  DROP `text7_0`,
+  DROP `text7_1`,
+  DROP `lang7`,
+  DROP `em7_0`,
+  DROP `em7_1`,
+  DROP `em7_2`,
+  DROP `em7_3`,
+  DROP `em7_4`,
+  DROP `em7_5`,
+  CHANGE `prob7` `Probability7` FLOAT NOT NULL DEFAULT '0';
diff --git a/sql/updates/world/2015_04_11_01_world.sql b/sql/updates/world/2015_04_11_01_world.sql
new file mode 100644
index 00000000000..d560b4462ff
--- /dev/null
+++ b/sql/updates/world/2015_04_11_01_world.sql
@@ -0,0 +1 @@
+DROP TABLE locales_npc_text;
diff --git a/sql/updates/world/2015_04_11_02_world.sql b/sql/updates/world/2015_04_11_02_world.sql
new file mode 100644
index 00000000000..04faf55bf15
--- /dev/null
+++ b/sql/updates/world/2015_04_11_02_world.sql
@@ -0,0 +1,4 @@
+DELETE FROM `command` WHERE `name`='reload locales_npc_text';
+DELETE FROM `command` WHERE `name`='reload quest_greeting';
+INSERT INTO `command` (`name`, `permission`, `help`) VALUES
+('reload quest_greeting', 664, 'Syntax: .reload quest_greeting\nReload quest_greeting table.');