aboutsummaryrefslogtreecommitdiff
path: root/sql/base/auth_database.sql
diff options
context:
space:
mode:
authorShauren <shauren.trinity@gmail.com>2018-05-13 20:43:44 +0200
committerShauren <shauren.trinity@gmail.com>2018-05-13 20:43:44 +0200
commitf05dbf814a42a8ea86b1ee532456dea2809a4d19 (patch)
tree6a267f130b921184f50032f576da974119fb64ab /sql/base/auth_database.sql
parentea4f343bd9c48883275ad1cc9a9aee4846c7a488 (diff)
Core/DataStores: Load Cfg_Regions and changed default realmlist region to US
Diffstat (limited to 'sql/base/auth_database.sql')
-rw-r--r--sql/base/auth_database.sql7
1 files changed, 4 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;