From 6533de31005fc9680d9f2b61a4d8ea4958fc8edc Mon Sep 17 00:00:00 2001 From: Shauren Date: Sat, 13 Jun 2020 00:30:32 +0200 Subject: Core/Items: Implemented corruption and corruption resistance stats --- sql/updates/hotfixes/master/2020_06_13_00_hotfixes.sql | 13 +++++++++++++ 1 file changed, 13 insertions(+) create mode 100644 sql/updates/hotfixes/master/2020_06_13_00_hotfixes.sql (limited to 'sql/updates') 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; -- cgit v1.2.3