Core/Scripts: Implement script name reloading

* Authored by Seyden
* Co-authored by Naios
* We thank Shauren for your helpful feedback

2 files changed, 10 insertions, 0 deletions

diff --git a/sql/updates/auth/master/2021_10_22_00_auth.sql b/sql/updates/auth/master/2021_10_22_00_auth.sql
new file mode 100644
index 00000000000..1bd7830845f
--- /dev/null
+++ b/sql/updates/auth/master/2021_10_22_00_auth.sql
@@ -0,0 +1,7 @@
+DELETE FROM `rbac_permissions` WHERE `id` = 882;
+INSERT INTO `rbac_permissions` (`id`, `name`) VALUES
+(882, 'Command: reload spell_script_names');
+
+DELETE FROM `rbac_linked_permissions` WHERE `linkedId` = 882;
+INSERT INTO `rbac_linked_permissions` (`id`, `linkedId`) VALUES
+(196, 882);
diff --git a/sql/updates/world/master/2021_10_21_05_world.sql b/sql/updates/world/master/2021_10_21_05_world.sql
new file mode 100644
index 00000000000..ed62f4a765d
--- /dev/null
+++ b/sql/updates/world/master/2021_10_21_05_world.sql
@@ -0,0 +1,3 @@
+DELETE FROM `command` WHERE `permission` = 882;
+INSERT INTO `command` (`name`,`permission`,`help`) VALUES
+('reload spell_script_names', 882, 'Syntax: .reload spell_script_names\nReload spell_script_names table.');