diff options
Diffstat (limited to 'sql/updates')
| -rw-r--r-- | sql/updates/characters/6.x/2016_08_25_00_characters.sql | 10 | ||||
| -rw-r--r-- | sql/updates/hotfixes/6.x/2016_08_25_00_hotfixes.sql | 23 |
2 files changed, 33 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; diff --git a/sql/updates/hotfixes/6.x/2016_08_25_00_hotfixes.sql b/sql/updates/hotfixes/6.x/2016_08_25_00_hotfixes.sql new file mode 100644 index 00000000000..5ce42a281cd --- /dev/null +++ b/sql/updates/hotfixes/6.x/2016_08_25_00_hotfixes.sql @@ -0,0 +1,23 @@ +-- +-- Table structure for table `glyph_bindable_spell` +-- +DROP TABLE IF EXISTS `glyph_bindable_spell`; +CREATE TABLE `glyph_bindable_spell` ( + `ID` int(10) unsigned NOT NULL DEFAULT '0', + `SpellID` int(10) unsigned NOT NULL DEFAULT '0', + `GlyphPropertiesID` smallint(5) unsigned NOT NULL DEFAULT '0', + `VerifiedBuild` smallint(6) NOT NULL DEFAULT '0', + PRIMARY KEY (`ID`) +) ENGINE=MyISAM DEFAULT CHARSET=utf8; + +-- +-- Table structure for table `glyph_required_spec` +-- +DROP TABLE IF EXISTS `glyph_required_spec`; +CREATE TABLE `glyph_required_spec` ( + `ID` int(10) unsigned NOT NULL DEFAULT '0', + `GlyphPropertiesID` smallint(5) unsigned NOT NULL DEFAULT '0', + `ChrSpecializationID` smallint(5) unsigned NOT NULL DEFAULT '0', + `VerifiedBuild` smallint(6) NOT NULL DEFAULT '0', + PRIMARY KEY (`ID`) +) ENGINE=MyISAM DEFAULT CHARSET=utf8; |