From d23ae07f643200202829acaae2b28d79d25bceec Mon Sep 17 00:00:00 2001 From: Shauren Date: Wed, 11 Jul 2012 00:13:41 +0200 Subject: Core/Players: Fixed saving/loading glyphs --- sql/base/characters_database.sql | 3 +++ sql/updates/characters/2012_07_10_00_characters_character_glyphs.sql | 4 ++++ 2 files changed, 7 insertions(+) create mode 100644 sql/updates/characters/2012_07_10_00_characters_character_glyphs.sql (limited to 'sql') diff --git a/sql/base/characters_database.sql b/sql/base/characters_database.sql index 3016614cd0e..93c5ee59cf1 100644 --- a/sql/base/characters_database.sql +++ b/sql/base/characters_database.sql @@ -623,6 +623,9 @@ CREATE TABLE `character_glyphs` ( `glyph4` smallint(5) unsigned DEFAULT '0', `glyph5` smallint(5) unsigned DEFAULT '0', `glyph6` smallint(5) unsigned DEFAULT '0', + `glyph7` smallint(5) unsigned DEFAULT '0', + `glyph8` smallint(5) unsigned DEFAULT '0', + `glyph9` smallint(5) unsigned DEFAULT '0', PRIMARY KEY (`guid`,`spec`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; diff --git a/sql/updates/characters/2012_07_10_00_characters_character_glyphs.sql b/sql/updates/characters/2012_07_10_00_characters_character_glyphs.sql new file mode 100644 index 00000000000..b8aba4d7798 --- /dev/null +++ b/sql/updates/characters/2012_07_10_00_characters_character_glyphs.sql @@ -0,0 +1,4 @@ +ALTER TABLE `character_glyphs` + ADD `glyph7` smallint(5) unsigned DEFAULT '0' AFTER `glyph6`, + ADD `glyph8` smallint(5) unsigned DEFAULT '0' AFTER `glyph7`, + ADD `glyph9` smallint(5) unsigned DEFAULT '0' AFTER `glyph8`; -- cgit v1.2.3