aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorShauren <shauren.trinity@gmail.com>2017-12-30 00:29:32 +0100
committerShauren <shauren.trinity@gmail.com>2017-12-30 00:29:32 +0100
commit69a4ad408fc4b5b19037aa790ec6c0dc1f809461 (patch)
tree8f3c584c3e40131772bd48418caf753a2ceb22e4
parent76a90df12fa17a8deb4e6d83761f92e5cdb922b6 (diff)
Core: Updated allowed build to 7.3.2.25549
-rw-r--r--sql/base/auth_database.sql5
-rw-r--r--sql/updates/auth/master/2017_12_30_00_auth.sql5
2 files changed, 8 insertions, 2 deletions
diff --git a/sql/base/auth_database.sql b/sql/base/auth_database.sql
index 38b67fdb93b..c54e44581ac 100644
--- a/sql/base/auth_database.sql
+++ b/sql/base/auth_database.sql
@@ -2072,7 +2072,7 @@ CREATE TABLE `realmlist` (
`timezone` tinyint(3) unsigned NOT NULL DEFAULT '0',
`allowedSecurityLevel` tinyint(3) unsigned NOT NULL DEFAULT '0',
`population` float unsigned NOT NULL DEFAULT '0',
- `gamebuild` int(10) unsigned NOT NULL DEFAULT '24742',
+ `gamebuild` int(10) unsigned NOT NULL DEFAULT '25549',
`Region` tinyint(3) unsigned NOT NULL DEFAULT '2',
`Battlegroup` tinyint(3) unsigned NOT NULL DEFAULT '1',
PRIMARY KEY (`id`),
@@ -2086,7 +2086,7 @@ CREATE TABLE `realmlist` (
LOCK TABLES `realmlist` WRITE;
/*!40000 ALTER TABLE `realmlist` DISABLE KEYS */;
-INSERT INTO `realmlist` VALUES (1,'Trinity','127.0.0.1','127.0.0.1','255.255.255.0',8085,0,2,1,0,0,24742,2,1);
+INSERT INTO `realmlist` VALUES (1,'Trinity','127.0.0.1','127.0.0.1','255.255.255.0',8085,0,2,1,0,0,25549,2,1);
/*!40000 ALTER TABLE `realmlist` ENABLE KEYS */;
UNLOCK TABLES;
@@ -2224,6 +2224,7 @@ INSERT INTO `updates` VALUES
('2017_08_13_00_auth_2016_09_22_00_auth.sql','70047954E3556BFA430ADD5680EF8797F74A4B9E','RELEASED','2017-08-13 12:00:00',0),
('2017_09_22_00_auth.sql','9313CCE80A18212E6F0C78D83316DE8582AE8084','RELEASED','2017-09-22 18:05:17',0),
('2017_11_11_01_auth.sql','0D6EDB6B2FC8B9FBDF11ECD79B4B8E943328B6A9','RELEASED','2017-11-11 18:49:45',0);
+('2017_12_30_00_auth.sql','F360E9555AC68E28834E3FF807E4E37A090EF363','RELEASED','2017-12-30 00:23:32',0);
/*!40000 ALTER TABLE `updates` ENABLE KEYS */;
UNLOCK TABLES;
diff --git a/sql/updates/auth/master/2017_12_30_00_auth.sql b/sql/updates/auth/master/2017_12_30_00_auth.sql
new file mode 100644
index 00000000000..5939777034f
--- /dev/null
+++ b/sql/updates/auth/master/2017_12_30_00_auth.sql
@@ -0,0 +1,5 @@
+ALTER TABLE `account` CHANGE `sessionkey` `sessionkey` varchar(128) NOT NULL DEFAULT '';
+
+UPDATE `realmlist` SET `gamebuild`=25549 WHERE `gamebuild`=24742;
+
+ALTER TABLE `realmlist` CHANGE `gamebuild` `gamebuild` int(10) unsigned NOT NULL DEFAULT '25549';