aboutsummaryrefslogtreecommitdiff
path: root/sql/updates/characters
diff options
context:
space:
mode:
authorShauren <shauren.trinity@gmail.com>2016-08-25 19:12:00 +0200
committerShauren <shauren.trinity@gmail.com>2016-08-25 19:12:00 +0200
commita727a99e34a1a50b4b7589ab549751caa63282b0 (patch)
tree65c60c621ee2a8452acc03292c28e296897fbea9 /sql/updates/characters
parente2f133902f8a37984e462a807a30a6663448d01e (diff)
Core/Players: Implemented new glyph system
Diffstat (limited to 'sql/updates/characters')
-rw-r--r--sql/updates/characters/6.x/2016_08_25_00_characters.sql10
1 files changed, 10 insertions, 0 deletions
diff --git a/sql/updates/characters/6.x/2016_08_25_00_characters.sql b/sql/updates/characters/6.x/2016_08_25_00_characters.sql
new file mode 100644
index 00000000000..ce9ac4f01c3
--- /dev/null
+++ b/sql/updates/characters/6.x/2016_08_25_00_characters.sql
@@ -0,0 +1,10 @@
+--
+-- Table structure for table `character_glyphs`
+--
+DROP TABLE IF EXISTS `character_glyphs`;
+CREATE TABLE `character_glyphs` (
+ `guid` bigint(20) NOT NULL,
+ `talentGroup` tinyint(3) unsigned NOT NULL DEFAULT '0',
+ `glyphId` smallint(5) unsigned NOT NULL DEFAULT '0',
+ PRIMARY KEY (`guid`,`talentGroup`,`glyphId`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8;