diff options
Diffstat (limited to 'sql/updates/6412_characters_declinedname.sql')
| -rw-r--r-- | sql/updates/6412_characters_declinedname.sql | 24 |
1 files changed, 24 insertions, 0 deletions
diff --git a/sql/updates/6412_characters_declinedname.sql b/sql/updates/6412_characters_declinedname.sql new file mode 100644 index 00000000000..50bf21f452d --- /dev/null +++ b/sql/updates/6412_characters_declinedname.sql @@ -0,0 +1,24 @@ +DROP TABLE IF EXISTS `character_declinedname`; +CREATE TABLE `character_declinedname` ( + `guid` int(11) unsigned NOT NULL default '0' COMMENT 'Global Unique Identifier', + `genitive` varchar(12) NOT NULL default '', + `dative` varchar(12) NOT NULL default '', + `accusative` varchar(12) NOT NULL default '', + `instrumental` varchar(12) NOT NULL default '', + `prepositional` varchar(12) NOT NULL default '', + PRIMARY KEY (`guid`) +) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC; + +DROP TABLE IF EXISTS `character_pet_declinedname`; +CREATE TABLE `character_pet_declinedname` ( + `id` int(11) unsigned NOT NULL default '0', + `owner` int(11) unsigned NOT NULL default '0', + `genitive` varchar(12) NOT NULL default '', + `dative` varchar(12) NOT NULL default '', + `accusative` varchar(12) NOT NULL default '', + `instrumental` varchar(12) NOT NULL default '', + `prepositional` varchar(12) NOT NULL default '', + PRIMARY KEY (`id`), + KEY owner_key (`owner`) +) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC; + |