DB/Hotfixes: Added chr_upgrade_* table

1 files changed, 33 insertions, 0 deletions

diff --git a/sql/updates/hotfixes/2015_04_06_03_hotfixes.sql b/sql/updates/hotfixes/2015_04_06_03_hotfixes.sql
new file mode 100644
index 00000000000..936a600f885
--- /dev/null
+++ b/sql/updates/hotfixes/2015_04_06_03_hotfixes.sql
@@ -0,0 +1,33 @@
+DROP TABLE IF EXISTS `chr_upgrade_tier`;
+CREATE TABLE IF NOT EXISTS `chr_upgrade_tier` (
+  `ID` INT(10) UNSIGNED NOT NULL DEFAULT '0',
+  `TierIndex` INT(10) UNSIGNED NOT NULL DEFAULT '0',
+  `Name` TEXT,
+  `TalentTier` INT(10) UNSIGNED NOT NULL DEFAULT '0',
+  `VerifiedBuild` SMALLINT(6) NOT NULL DEFAULT '0'
+) ENGINE=MYISAM DEFAULT CHARSET=utf8;
+
+ALTER TABLE `chr_upgrade_tier`
+ ADD PRIMARY KEY (`ID`);
+
+DROP TABLE IF EXISTS `chr_upgrade_bucket`;
+CREATE TABLE IF NOT EXISTS `chr_upgrade_bucket` (
+  `ID` INT(10) UNSIGNED NOT NULL DEFAULT '0',
+  `TierID` INT(10) UNSIGNED NOT NULL DEFAULT '0',
+  `SpecializationID` INT(10) UNSIGNED NOT NULL DEFAULT '0',
+  `VerifiedBuild` SMALLINT(6) NOT NULL DEFAULT '0'
+) ENGINE=MYISAM DEFAULT CHARSET=utf8;
+
+ALTER TABLE `chr_upgrade_bucket`
+ ADD PRIMARY KEY (`ID`);
+
+DROP TABLE IF EXISTS `chr_upgrade_bucket_spell`;
+CREATE TABLE IF NOT EXISTS `chr_upgrade_bucket_spell` (
+  `ID` INT(10) UNSIGNED NOT NULL DEFAULT '0',
+  `BucketID` INT(10) UNSIGNED NOT NULL DEFAULT '0',
+  `SpellID` INT(10) UNSIGNED NOT NULL DEFAULT '0',
+  `VerifiedBuild` SMALLINT(6) NOT NULL DEFAULT '0'
+) ENGINE=MYISAM DEFAULT CHARSET=utf8;
+
+ALTER TABLE `chr_upgrade_bucket_spell`
+ ADD PRIMARY KEY (`ID`);