aboutsummaryrefslogtreecommitdiff
path: root/sql/updates
diff options
context:
space:
mode:
authorSnapperRy <snapperryen@gmail.com>2016-09-13 04:16:05 +0200
committerjoschiwald <joschiwald.trinity@gmail.com>2017-02-26 19:59:07 +0100
commitcab4ce3a532b15f95144ef17ff2bf752c56495d6 (patch)
tree2f4e0cd0dbf81dabd431475b96c39dd09e5c55ba /sql/updates
parent29ce69b3ad489be67c229aef5aa7f2208a0bd00d (diff)
Core/Fishing: implement retail-like fishing skill-up functionality (#17528)
Follow-up to 6f1e823. Forgot to update base characters database. Sorry.
Diffstat (limited to 'sql/updates')
-rw-r--r--sql/updates/characters/master/2017_02_26_00_characters_2016_09_13_00_characters.sql6
1 files changed, 6 insertions, 0 deletions
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;