diff options
| author | Traesh <Traesh@users.noreply.github.com> | 2018-07-31 23:31:44 +0200 |
|---|---|---|
| committer | Shauren <shauren.trinity@gmail.com> | 2018-07-31 23:31:44 +0200 |
| commit | 55a0a2d3f6146ace93d5558ce16469d3cca28bdc (patch) | |
| tree | d1b61e149fcb44c0c153c3ed614e42640a81df28 /sql | |
| parent | 394f9775a7c6d597c9744db37783985b2e228572 (diff) | |
Core/Artifact Handle Artifact tiers + Artifact unlock (3rd relic bonus) (#21593)
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/base/characters_database.sql | 4 | ||||
| -rw-r--r-- | sql/updates/characters/master/2018_07_31_00_characters.sql | 1 | ||||
| -rw-r--r-- | sql/updates/hotfixes/master/2018_03_18_00_hotfixes.sql | 29 |
3 files changed, 33 insertions, 1 deletions
diff --git a/sql/base/characters_database.sql b/sql/base/characters_database.sql index ef73caef3aa..687f66af959 100644 --- a/sql/base/characters_database.sql +++ b/sql/base/characters_database.sql @@ -2821,6 +2821,7 @@ CREATE TABLE `item_instance_artifact` ( `itemGuid` bigint(20) unsigned NOT NULL, `xp` bigint(20) unsigned NOT NULL DEFAULT '0', `artifactAppearanceId` int(10) unsigned NOT NULL DEFAULT '0', + `artifactTierId` int(10) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`itemGuid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; @@ -3564,7 +3565,8 @@ INSERT INTO `updates` VALUES ('2018_02_19_00_characters.sql','75A0FFAFD0633921708DB0F72F9CC9796ACB960B','RELEASED','2018-02-19 22:33:32',117), ('2018_03_04_00_characters.sql','2A4CD2EE2547E718490706FADC78BF36F0DED8D6','RELEASED','2018-03-04 18:15:24',0), ('2018_04_28_00_characters.sql','CBD0FDC0F32DE3F456F7CE3D9CAD6933CD6A50F5','RELEASED','2018-04-28 12:44:09',0), -('2018_07_28_00_characters.sql','31F66AE7831251A8915625EC7F10FA138AB8B654','RELEASED','2018-07-28 18:30:19',0); +('2018_07_28_00_characters.sql','31F66AE7831251A8915625EC7F10FA138AB8B654','RELEASED','2018-07-28 18:30:19',0), +('2018_07_31_00_characters.sql','7DA8D4A4534520B23E6F5BBD5B8EE205B799C798','RELEASED','2018-07-31 20:54:39',0); /*!40000 ALTER TABLE `updates` ENABLE KEYS */; UNLOCK TABLES; 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; |