From bba7b6a554c3be59edc2a9b520e5ba132b0efc52 Mon Sep 17 00:00:00 2001 From: Shauren Date: Tue, 20 Sep 2016 23:09:10 +0200 Subject: Core/Player: Set max power values from PowerType.db2 --- sql/updates/hotfixes/6.x/2016_09_20_00_hotfixes.sql | 21 +++++++++++++++++++++ 1 file changed, 21 insertions(+) create mode 100644 sql/updates/hotfixes/6.x/2016_09_20_00_hotfixes.sql (limited to 'sql') diff --git a/sql/updates/hotfixes/6.x/2016_09_20_00_hotfixes.sql b/sql/updates/hotfixes/6.x/2016_09_20_00_hotfixes.sql new file mode 100644 index 00000000000..7e216121dfd --- /dev/null +++ b/sql/updates/hotfixes/6.x/2016_09_20_00_hotfixes.sql @@ -0,0 +1,21 @@ +-- +-- Table structure for table `power_type` +-- +DROP TABLE IF EXISTS `power_type`; +CREATE TABLE `power_type` ( + `ID` int(10) unsigned NOT NULL DEFAULT '0', + `PowerTypeToken` text, + `PowerCostToken` text, + `RegenerationPeace` float NOT NULL DEFAULT '0', + `RegenerationCombat` float NOT NULL DEFAULT '0', + `MaxPower` smallint(6) NOT NULL DEFAULT '0', + `RegenerationDelay` smallint(5) unsigned NOT NULL DEFAULT '0', + `Flags` smallint(5) unsigned NOT NULL DEFAULT '0', + `PowerTypeEnum` tinyint(3) unsigned NOT NULL DEFAULT '0', + `RegenerationMin` tinyint(4) NOT NULL DEFAULT '0', + `RegenerationCenter` tinyint(4) NOT NULL DEFAULT '0', + `RegenerationMax` tinyint(4) NOT NULL DEFAULT '0', + `UIModifier` tinyint(3) unsigned NOT NULL DEFAULT '0', + `VerifiedBuild` smallint(6) NOT NULL DEFAULT '0', + PRIMARY KEY (`ID`) +) ENGINE=MyISAM DEFAULT CHARSET=utf8; -- cgit v1.2.3