diff options
| author | Shauren <shauren.trinity@gmail.com> | 2018-05-13 20:43:44 +0200 |
|---|---|---|
| committer | Shauren <shauren.trinity@gmail.com> | 2018-05-13 20:43:44 +0200 |
| commit | f05dbf814a42a8ea86b1ee532456dea2809a4d19 (patch) | |
| tree | 6a267f130b921184f50032f576da974119fb64ab /sql | |
| parent | ea4f343bd9c48883275ad1cc9a9aee4846c7a488 (diff) | |
Core/DataStores: Load Cfg_Regions and changed default realmlist region to US
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/base/auth_database.sql | 7 | ||||
| -rw-r--r-- | sql/updates/auth/master/2018_05_13_00_auth.sql | 1 | ||||
| -rw-r--r-- | sql/updates/hotfixes/master/2018_05_13_00_hotfixes.sql | 14 |
3 files changed, 19 insertions, 3 deletions
diff --git a/sql/base/auth_database.sql b/sql/base/auth_database.sql index d935c3493ae..fb3792ddcf5 100644 --- a/sql/base/auth_database.sql +++ b/sql/base/auth_database.sql @@ -2077,7 +2077,7 @@ CREATE TABLE `realmlist` ( `allowedSecurityLevel` tinyint(3) unsigned NOT NULL DEFAULT '0', `population` float unsigned NOT NULL DEFAULT '0', `gamebuild` int(10) unsigned NOT NULL DEFAULT '26365', - `Region` tinyint(3) unsigned NOT NULL DEFAULT '2', + `Region` tinyint(3) unsigned NOT NULL DEFAULT '1', `Battlegroup` tinyint(3) unsigned NOT NULL DEFAULT '1', PRIMARY KEY (`id`), UNIQUE KEY `idx_name` (`name`) @@ -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,2,1); +(1,'Trinity','127.0.0.1','127.0.0.1','255.255.255.0',8085,0,0,1,0,0,26365,1,1); /*!40000 ALTER TABLE `realmlist` ENABLE KEYS */; UNLOCK TABLES; @@ -2237,7 +2237,8 @@ INSERT INTO `updates` VALUES ('2018_02_19_00_auth.sql','07CE658C5EF88693D3C047EF8E724F94ADA74C15','RELEASED','2018-02-19 22:33:32',233), ('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_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); /*!40000 ALTER TABLE `updates` ENABLE KEYS */; UNLOCK TABLES; diff --git a/sql/updates/auth/master/2018_05_13_00_auth.sql b/sql/updates/auth/master/2018_05_13_00_auth.sql new file mode 100644 index 00000000000..7df67812d21 --- /dev/null +++ b/sql/updates/auth/master/2018_05_13_00_auth.sql @@ -0,0 +1 @@ +ALTER TABLE `realmlist` MODIFY `Region` tinyint(3) unsigned NOT NULL DEFAULT '1' AFTER `gamebuild`; diff --git a/sql/updates/hotfixes/master/2018_05_13_00_hotfixes.sql b/sql/updates/hotfixes/master/2018_05_13_00_hotfixes.sql new file mode 100644 index 00000000000..bc42dc94f37 --- /dev/null +++ b/sql/updates/hotfixes/master/2018_05_13_00_hotfixes.sql @@ -0,0 +1,14 @@ +-- +-- Table structure for table `cfg_regions` +-- +DROP TABLE IF EXISTS `cfg_regions`; +CREATE TABLE `cfg_regions` ( + `ID` int(10) unsigned NOT NULL DEFAULT '0', + `Tag` text, + `Raidorigin` int(10) unsigned NOT NULL DEFAULT '0', + `ChallengeOrigin` int(10) unsigned NOT NULL DEFAULT '0', + `RegionID` smallint(5) unsigned NOT NULL DEFAULT '0', + `RegionGroupMask` tinyint(3) unsigned NOT NULL DEFAULT '0', + `VerifiedBuild` smallint(6) NOT NULL DEFAULT '0', + PRIMARY KEY (`ID`) +) ENGINE=MyISAM DEFAULT CHARSET=utf8; |