aboutsummaryrefslogtreecommitdiff
path: root/sql/updates
diff options
context:
space:
mode:
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;