Core/DataStores: Load Cfg_Regions and changed default realmlist region to US

2 files changed, 15 insertions, 0 deletions

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;