aboutsummaryrefslogtreecommitdiff
path: root/sql/updates
diff options
context:
space:
mode:
authorSnapperRy <snapperryen@gmail.com>2016-09-13 04:16:05 +0200
committerGitHub <noreply@github.com>2016-09-13 04:16:05 +0200
commit6f1e823cac8050780afb11f2befb3fb829200418 (patch)
treec3c7d992c2888da9f2d6778317b90410b2b4688e /sql/updates
parentb125a3fd2c969f70a73d9128cfd05dc223203079 (diff)
Core/Fishing: implement retail-like fishing skill-up functionality (#17528)
Diffstat (limited to 'sql/updates')
-rw-r--r--sql/updates/characters/3.3.5/2016_09_13_00_characters.sql6
1 files changed, 6 insertions, 0 deletions
diff --git a/sql/updates/characters/3.3.5/2016_09_13_00_characters.sql b/sql/updates/characters/3.3.5/2016_09_13_00_characters.sql
new file mode 100644
index 00000000000..9fa61d633ce
--- /dev/null
+++ b/sql/updates/characters/3.3.5/2016_09_13_00_characters.sql
@@ -0,0 +1,6 @@
+DROP TABLE IF EXISTS `character_fishingsteps`;
+CREATE TABLE `character_fishingsteps` (
+ `guid` INT(10) 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;