aboutsummaryrefslogtreecommitdiff
path: root/sql/updates
diff options
context:
space:
mode:
authorShauren <shauren.trinity@gmail.com>2019-06-03 20:40:34 +0200
committerShauren <shauren.trinity@gmail.com>2019-06-08 17:06:57 +0200
commit455959c6064af6f7863a6b4b57cb0ef1646bd8ef (patch)
tree7d7a7cdd3a44643ee5fc7d19521ced1c8b815c66 /sql/updates
parent31fda79556e55375962a3c9e46f6dbdbf6e90d18 (diff)
Core/PacketIO: Rewrite updatefield handling
Diffstat (limited to 'sql/updates')
-rw-r--r--sql/updates/auth/master/2019_06_08_01_auth.sql2
-rw-r--r--sql/updates/characters/master/2019_06_08_00_characters.sql2
-rw-r--r--sql/updates/world/master/2019_06_08_01_world.sql1
3 files changed, 5 insertions, 0 deletions
diff --git a/sql/updates/auth/master/2019_06_08_01_auth.sql b/sql/updates/auth/master/2019_06_08_01_auth.sql
new file mode 100644
index 00000000000..1c4f66a2567
--- /dev/null
+++ b/sql/updates/auth/master/2019_06_08_01_auth.sql
@@ -0,0 +1,2 @@
+DELETE FROM `rbac_linked_permissions` WHERE `linkedId` IN (307,308,313,332,333,334,338,546);
+DELETE FROM `rbac_permissions` WHERE `id` IN (307,308,313,332,333,334,338,546);
diff --git a/sql/updates/characters/master/2019_06_08_00_characters.sql b/sql/updates/characters/master/2019_06_08_00_characters.sql
new file mode 100644
index 00000000000..c7ef28d4e34
--- /dev/null
+++ b/sql/updates/characters/master/2019_06_08_00_characters.sql
@@ -0,0 +1,2 @@
+ALTER TABLE `character_void_storage` DROP `suffixFactor`;
+ALTER TABLE `item_loot_items` DROP `rnd_suffix`;
diff --git a/sql/updates/world/master/2019_06_08_01_world.sql b/sql/updates/world/master/2019_06_08_01_world.sql
new file mode 100644
index 00000000000..8a37ec2737f
--- /dev/null
+++ b/sql/updates/world/master/2019_06_08_01_world.sql
@@ -0,0 +1 @@
+DELETE FROM `command` WHERE `name` IN ('debug setbit','debug getvalue','debug getitemvalue','debug Mod32Value','debug setitemvalue','debug setvalue','debug update','modify bit');