aboutsummaryrefslogtreecommitdiff
path: root/sql/updates/characters
diff options
context:
space:
mode:
Diffstat (limited to 'sql/updates/characters')
-rw-r--r--sql/updates/characters/master/2024_07_31_00_characters.sql5
1 files changed, 5 insertions, 0 deletions
diff --git a/sql/updates/characters/master/2024_07_31_00_characters.sql b/sql/updates/characters/master/2024_07_31_00_characters.sql
new file mode 100644
index 00000000000..1411b4697dc
--- /dev/null
+++ b/sql/updates/characters/master/2024_07_31_00_characters.sql
@@ -0,0 +1,5 @@
+ALTER TABLE `groups` ADD `pingRestriction` tinyint AFTER `masterLooterGuid`;
+
+UPDATE `groups` SET `pingRestriction`=0;
+
+ALTER TABLE `groups` MODIFY `pingRestriction` tinyint NOT NULL;