From cab4ce3a532b15f95144ef17ff2bf752c56495d6 Mon Sep 17 00:00:00 2001 From: SnapperRy Date: Tue, 13 Sep 2016 04:16:05 +0200 Subject: Core/Fishing: implement retail-like fishing skill-up functionality (#17528) Follow-up to 6f1e823. Forgot to update base characters database. Sorry. --- .../master/2017_02_26_00_characters_2016_09_13_00_characters.sql | 6 ++++++ 1 file changed, 6 insertions(+) create mode 100644 sql/updates/characters/master/2017_02_26_00_characters_2016_09_13_00_characters.sql (limited to 'sql/updates') diff --git a/sql/updates/characters/master/2017_02_26_00_characters_2016_09_13_00_characters.sql b/sql/updates/characters/master/2017_02_26_00_characters_2016_09_13_00_characters.sql new file mode 100644 index 00000000000..f165cc76d26 --- /dev/null +++ b/sql/updates/characters/master/2017_02_26_00_characters_2016_09_13_00_characters.sql @@ -0,0 +1,6 @@ +DROP TABLE IF EXISTS `character_fishingsteps`; +CREATE TABLE `character_fishingsteps` ( + `guid` BIGINT(20) UNSIGNED NOT NULL DEFAULT '0' COMMENT 'Global Unique Identifier', + `fishingSteps` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0', + PRIMARY KEY (`guid`) +) ENGINE=INNODB DEFAULT CHARSET=utf8; -- cgit v1.2.3