Core/Items: Implemented corruption and corruption resistance stats

1 files changed, 13 insertions, 0 deletions

diff --git a/sql/updates/hotfixes/master/2020_06_13_00_hotfixes.sql b/sql/updates/hotfixes/master/2020_06_13_00_hotfixes.sql
new file mode 100644
index 00000000000..9b75a7a6984
--- /dev/null
+++ b/sql/updates/hotfixes/master/2020_06_13_00_hotfixes.sql
@@ -0,0 +1,13 @@
+--
+-- Table structure for table `corruption_effects`
+--
+DROP TABLE IF EXISTS `corruption_effects`;
+CREATE TABLE `corruption_effects` (
+  `ID` int(10) unsigned NOT NULL DEFAULT '0',
+  `MinCorruption` float NOT NULL DEFAULT '0',
+  `Aura` int(11) NOT NULL DEFAULT '0',
+  `PlayerConditionID` int(11) NOT NULL DEFAULT '0',
+  `Flags` int(11) NOT NULL DEFAULT '0',
+  `VerifiedBuild` int(11) NOT NULL DEFAULT '0',
+  PRIMARY KEY (`ID`,`VerifiedBuild`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;