diff options
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/base/auth_database.sql | 7 | ||||
| -rw-r--r-- | sql/updates/auth/master/2018_05_24_00_auth.sql | 3 |
2 files changed, 7 insertions, 3 deletions
diff --git a/sql/base/auth_database.sql b/sql/base/auth_database.sql index fb3792ddcf5..2b14f77cfd8 100644 --- a/sql/base/auth_database.sql +++ b/sql/base/auth_database.sql @@ -2076,7 +2076,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 '26365', + `gamebuild` int(10) unsigned NOT NULL DEFAULT '26654', `Region` tinyint(3) unsigned NOT NULL DEFAULT '1', `Battlegroup` tinyint(3) unsigned NOT NULL DEFAULT '1', PRIMARY KEY (`id`), @@ -2091,7 +2091,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,0,1,0,0,26365,1,1); +(1,'Trinity','127.0.0.1','127.0.0.1','255.255.255.0',8085,0,0,1,0,0,26654,1,1); /*!40000 ALTER TABLE `realmlist` ENABLE KEYS */; UNLOCK TABLES; @@ -2238,7 +2238,8 @@ INSERT INTO `updates` VALUES ('2018_02_28_00_auth.sql','E92EF4ABF7FA0C66649E1633DD0459F44C09EB83','RELEASED','2018-02-28 23:07:59',0), ('2018_03_14_00_auth.sql','2D71E93DF7419A30D0D21D8A80CF05698302575A','RELEASED','2018-03-14 23:07:59',0), ('2018_04_06_00_auth.sql','D8416F0C4751763202B1997C81423F6EE2FCF9A6','RELEASED','2018-04-06 18:00:32',0), -('2018_05_13_00_auth.sql','A9E20F2EB1E2FDBB982DB6B00DB7301852B27CD4','RELEASED','2018-05-13 20:22:32',0); +('2018_05_13_00_auth.sql','A9E20F2EB1E2FDBB982DB6B00DB7301852B27CD4','RELEASED','2018-05-13 20:22:32',0), +('2018_05_24_00_auth.sql','B98FD71AAA13810856729E034E6B8C9F8D5D4F6B','RELEASED','2018-05-24 22:32:49',0); /*!40000 ALTER TABLE `updates` ENABLE KEYS */; UNLOCK TABLES; diff --git a/sql/updates/auth/master/2018_05_24_00_auth.sql b/sql/updates/auth/master/2018_05_24_00_auth.sql new file mode 100644 index 00000000000..6dd771b0afd --- /dev/null +++ b/sql/updates/auth/master/2018_05_24_00_auth.sql @@ -0,0 +1,3 @@ +UPDATE `realmlist` SET `gamebuild`=26654 WHERE `gamebuild`=26365; + +ALTER TABLE `realmlist` CHANGE `gamebuild` `gamebuild` int(10) unsigned NOT NULL DEFAULT '26654'; |