Miscellany

DROP TABLE IF EXISTS `creature_names_localized`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `creature_names_localized` (
   `id` int(30) unsigned NOT NULL,
   `language_code` varchar(5) NOT NULL,
   `name` varchar(100) NOT NULL,
   `subname` varchar(100) NOT NULL,
   PRIMARY KEY (`id`,`language_code`),
   KEY `lol` (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
SET character_set_client = @saved_cs_client;
DROP TABLE IF EXISTS `gameobject_names_localized`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `gameobject_names_localized` (
   `entry` int(30) NOT NULL,
   `language_code` varchar(5) NOT NULL,
   `name` varchar(100) NOT NULL,
   PRIMARY KEY (`entry`,`language_code`),
   KEY `lol` (`entry`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
SET character_set_client = @saved_cs_client;
DROP TABLE IF EXISTS `itempages_localized`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `itempages_localized` (
   `entry` int(30) NOT NULL,
   `language_code` varchar(5) NOT NULL,
   `text` text NOT NULL,
   PRIMARY KEY (`entry`,`language_code`),
   KEY `a` (`entry`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
SET character_set_client = @saved_cs_client;
DROP TABLE IF EXISTS `items_localized`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `items_localized` (
   `entry` int(30) NOT NULL,
   `language_code` varchar(5) NOT NULL,
   `name` varchar(100) NOT NULL,
   `description` varchar(100) NOT NULL,
   PRIMARY KEY (`entry`,`language_code`),
   KEY `lol` (`entry`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
SET character_set_client = @saved_cs_client;
DROP TABLE IF EXISTS `quests_localized`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `quests_localized` (
   `entry` int(30) NOT NULL,
   `language_code` varchar(5) NOT NULL,
   `Title` text NOT NULL,
   `Details` text NOT NULL,
   `Objectives` text NOT NULL,
   `CompletionText` text NOT NULL,
   `IncompleteText` text NOT NULL,
   `EndText` text NOT NULL,
   `ObjectiveText1` text NOT NULL,
   `ObjectiveText2` text NOT NULL,
   `ObjectiveText3` text NOT NULL,
   `ObjectiveText4` text NOT NULL,
   PRIMARY KEY (`entry`,`language_code`),
   KEY `lol` (`entry`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
SET character_set_client = @saved_cs_client;
DROP TABLE IF EXISTS `npc_text_localized`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `npc_text_localized` (
   `entry` int(30) NOT NULL,
   `language_code` varchar(5) NOT NULL,
   `text0` varchar(200) NOT NULL,
   `text0_1` varchar(200) NOT NULL,
   `text1` varchar(200) NOT NULL,
   `text1_1` varchar(200) NOT NULL,
   `text2` varchar(200) NOT NULL,
   `text2_1` varchar(200) NOT NULL,
   `text3` varchar(200) NOT NULL,
   `text3_1` varchar(200) NOT NULL,
   `text4` varchar(200) NOT NULL,
   `text4_1` varchar(200) NOT NULL,
   `text5` varchar(200) NOT NULL,
   `text5_1` varchar(200) NOT NULL,
   `text6` varchar(200) NOT NULL,
   `text6_1` varchar(200) NOT NULL,
   `text7` varchar(200) NOT NULL,
   `text7_1` varchar(200) NOT NULL,
   PRIMARY KEY (`entry`,`language_code`),
   KEY `lol` (`entry`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;