Core/Artifact Handle Artifact tiers + Artifact unlock (3rd relic bonus) (#21593)

2 files changed, 30 insertions, 0 deletions

diff --git a/sql/updates/characters/master/2018_07_31_00_characters.sql b/sql/updates/characters/master/2018_07_31_00_characters.sql
new file mode 100644
index 00000000000..fed2be26b77
--- /dev/null
+++ b/sql/updates/characters/master/2018_07_31_00_characters.sql
@@ -0,0 +1 @@
+ALTER TABLE `item_instance_artifact` ADD `artifactTierId` int(10) unsigned NOT NULL DEFAULT '0' AFTER `artifactAppearanceId`;
diff --git a/sql/updates/hotfixes/master/2018_03_18_00_hotfixes.sql b/sql/updates/hotfixes/master/2018_03_18_00_hotfixes.sql
new file mode 100644
index 00000000000..d4271bb2523
--- /dev/null
+++ b/sql/updates/hotfixes/master/2018_03_18_00_hotfixes.sql
@@ -0,0 +1,29 @@
+--
+-- Table structure for table `artifact_tier`
+--
+DROP TABLE IF EXISTS `artifact_tier`;
+CREATE TABLE `artifact_tier` (
+  `ID` int(10) unsigned NOT NULL DEFAULT '0',
+  `ArtifactTier` int(10) unsigned NOT NULL DEFAULT '0',
+  `MaxNumTraits` int(10) unsigned NOT NULL DEFAULT '0',
+  `MaxArtifactKnowledge` int(10) unsigned NOT NULL DEFAULT '0',
+  `KnowledgePlayerCondition` int(10) unsigned NOT NULL DEFAULT '0',
+  `MinimumEmpowerKnowledge` int(10) unsigned NOT NULL DEFAULT '0',
+  `VerifiedBuild` smallint(6) NOT NULL DEFAULT '0',
+  PRIMARY KEY (`ID`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
+
+--
+-- Table structure for table `artifact_unlock`
+--
+DROP TABLE IF EXISTS `artifact_unlock`;
+CREATE TABLE `artifact_unlock` (
+  `ID` int(10) unsigned NOT NULL DEFAULT '0',
+  `ItemBonusListID` smallint(5) unsigned NOT NULL DEFAULT '0',
+  `PowerRank` tinyint(3) unsigned NOT NULL DEFAULT '0',
+  `PowerID` int(10) unsigned NOT NULL DEFAULT '0',
+  `PlayerConditionID` int(10) unsigned NOT NULL DEFAULT '0',
+  `ArtifactID` tinyint(3) unsigned NOT NULL DEFAULT '0',
+  `VerifiedBuild` smallint(6) NOT NULL DEFAULT '0',
+  PRIMARY KEY (`ID`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;