aboutsummaryrefslogtreecommitdiff
path: root/sql
diff options
context:
space:
mode:
Diffstat (limited to 'sql')
-rw-r--r--sql/base/characters_database.sql3
-rw-r--r--sql/updates/characters/2012_07_10_00_characters_character_glyphs.sql4
2 files changed, 7 insertions, 0 deletions
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`;