From c2d61e05cf3dc555608e6b2a06772c27d207548c Mon Sep 17 00:00:00 2001 From: Shauren Date: Fri, 29 Jun 2018 22:38:38 +0200 Subject: Core: Updated allowed build to 7.3.5.26972 --- sql/base/auth_database.sql | 7 ++++--- sql/updates/auth/master/2018_06_29_00_auth.sql | 3 +++ 2 files changed, 7 insertions(+), 3 deletions(-) create mode 100644 sql/updates/auth/master/2018_06_29_00_auth.sql (limited to 'sql') diff --git a/sql/base/auth_database.sql b/sql/base/auth_database.sql index ae14c8a2744..211d7baaa29 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 '26899', + `gamebuild` int(10) unsigned NOT NULL DEFAULT '26972', `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,26899,1,1); +(1,'Trinity','127.0.0.1','127.0.0.1','255.255.255.0',8085,0,0,1,0,0,26972,1,1); /*!40000 ALTER TABLE `realmlist` ENABLE KEYS */; UNLOCK TABLES; @@ -2241,7 +2241,8 @@ INSERT INTO `updates` VALUES ('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), ('2018_06_14_00_auth.sql','67EAB915BF0C7F2D410BE45F885A1A39D42C8C14','RELEASED','2018-06-14 23:06:59',0), -('2018_06_22_00_auth.sql','9DA24F70B8A365AFDEF58A9B578255CDEDFCA47C','RELEASED','2018-06-22 17:45:45',0); +('2018_06_22_00_auth.sql','9DA24F70B8A365AFDEF58A9B578255CDEDFCA47C','RELEASED','2018-06-22 17:45:45',0), +('2018_06_29_00_auth.sql','03AAEA7E52848FA5522C3F0C6D9C38B988407480','RELEASED','2018-06-29 22:34:04',0); /*!40000 ALTER TABLE `updates` ENABLE KEYS */; UNLOCK TABLES; diff --git a/sql/updates/auth/master/2018_06_29_00_auth.sql b/sql/updates/auth/master/2018_06_29_00_auth.sql new file mode 100644 index 00000000000..821431dde38 --- /dev/null +++ b/sql/updates/auth/master/2018_06_29_00_auth.sql @@ -0,0 +1,3 @@ +UPDATE `realmlist` SET `gamebuild`=26972 WHERE `gamebuild`=26899; + +ALTER TABLE `realmlist` CHANGE `gamebuild` `gamebuild` int(10) unsigned NOT NULL DEFAULT '26972'; -- cgit v1.2.3