aboutsummaryrefslogtreecommitdiff
path: root/sql/updates
diff options
context:
space:
mode:
Diffstat (limited to 'sql/updates')
-rw-r--r--sql/updates/auth/master/2024_11_12_00_auth.sql5
1 files changed, 5 insertions, 0 deletions
diff --git a/sql/updates/auth/master/2024_11_12_00_auth.sql b/sql/updates/auth/master/2024_11_12_00_auth.sql
new file mode 100644
index 00000000000..3eb0af6c898
--- /dev/null
+++ b/sql/updates/auth/master/2024_11_12_00_auth.sql
@@ -0,0 +1,5 @@
+ALTER TABLE `realmlist`
+ MODIFY `address` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT '127.0.0.1' AFTER `name`,
+ MODIFY `localAddress` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT '127.0.0.1' AFTER `address`,
+ ADD `address3` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL AFTER `localAddress`,
+ ADD `address4` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL AFTER `address3`;