aboutsummaryrefslogtreecommitdiff
path: root/sql
diff options
context:
space:
mode:
Diffstat (limited to 'sql')
-rw-r--r--sql/realmd.sql2
-rw-r--r--sql/updates/6712_realmd_account_access.sql1
2 files changed, 2 insertions, 1 deletions
diff --git a/sql/realmd.sql b/sql/realmd.sql
index 41a1946cb1d..af983e72d30 100644
--- a/sql/realmd.sql
+++ b/sql/realmd.sql
@@ -20,7 +20,7 @@
--
CREATE TABLE `account_access` (
- `id` bigint(20) unsigned NOT NULL,
+ `id` int(11) unsigned NOT NULL,
`gmlevel` tinyint(3) unsigned NOT NULL,
`RealmID` int(11) NOT NULL,
PRIMARY KEY (`id`,`RealmID`)
diff --git a/sql/updates/6712_realmd_account_access.sql b/sql/updates/6712_realmd_account_access.sql
new file mode 100644
index 00000000000..0ada6f615b9
--- /dev/null
+++ b/sql/updates/6712_realmd_account_access.sql
@@ -0,0 +1 @@
+ALTER TABLE `account_access` CHANGE `id` `id` int(11) UNSIGNED NOT NULL; \ No newline at end of file