DB/Account: update account_access table (#24788)

* DB/Account: update account_access table:

- rename fields id -> AccountID, gmlevel -> SecurityLevel
- add Comment field
- rename command .acc set gmlevel to .acc set seclevel

* Update auth database

* Fix primary key

* Temporary restore old command account set gmlevel with same handler as account set seclevel

Use Optional  for realmID - if not set, use -1 (for all realms)

* Rename 2020_XX_XX_00_auth.sql to 2020_06_20_00_auth.sql

* Update auth_database.sql

* Rename 2020_XX_XX_00_world.sql to 2020_06_20_06_world.sql

Co-authored-by: Giacomo Pozzoni <giacomopoz@gmail.com>

2 files changed, 25 insertions, 0 deletions

diff --git a/sql/updates/auth/3.3.5/2020_06_20_00_auth.sql b/sql/updates/auth/3.3.5/2020_06_20_00_auth.sql
new file mode 100644
index 00000000000..fdb95bfe335
--- /dev/null
+++ b/sql/updates/auth/3.3.5/2020_06_20_00_auth.sql
@@ -0,0 +1,6 @@
+ALTER TABLE `account_access`
+  CHANGE COLUMN `id` `AccountID` INT(10) UNSIGNED NOT NULL,
+  CHANGE COLUMN `gmlevel` `SecurityLevel` TINYINT(3) UNSIGNED NOT NULL,
+  ADD COLUMN `Comment` VARCHAR(255) DEFAULT NULL AFTER `RealmID`;
+
+UPDATE `rbac_permissions` SET `name` = 'Command: account set seclevel' WHERE `id` = 228;
diff --git a/sql/updates/world/3.3.5/2020_06_20_06_world.sql b/sql/updates/world/3.3.5/2020_06_20_06_world.sql
new file mode 100644
index 00000000000..f0b8a157160
--- /dev/null
+++ b/sql/updates/world/3.3.5/2020_06_20_06_world.sql
@@ -0,0 +1,19 @@
+DELETE FROM `command` WHERE `name` IN ('account set gmlevel','account set seclevel');
+INSERT INTO `command` (`name`,`permission`,`help`) VALUES
+('account set gmlevel', 228, 'Syntax: .account set gmlevel [$accountName] #level [#realmID]
+
+Set the security level for targeted player (can\'t be used at self) or for account $accountName to a level of #level on the realm #realmID.
+
+#level may range from 0 to 3.
+
+#realmID - Default: -1 for all realms.
+
+Note: this command will be removed soon. Use \'account set seclevel\' instead.'),
+
+('account set seclevel', 228, 'Syntax: .account set seclevel [$accountName] #level [#realmID]
+
+Set the security level for targeted player (can\'t be used at self) or for account $accountName to a level of #level on the realm #realmID.
+
+#level may range from 0 to 3.
+
+#realmID - Default: -1 for all realms.');