Public feed #723125

Full localization by Neo2003

public sql v1 · immutable
Raw Edit
·published 2007-10-02 15:20 UTC
rendered paste body
DROP TABLE IF EXISTS `locales_creature`;CREATE TABLE `locales_creature` (  `entry` int(11) unsigned NOT NULL default '0',  `name_loc1` varchar(100) NOT NULL default '',  `name_loc2` varchar(100) NOT NULL default '',  `name_loc3` varchar(100) NOT NULL default '',  `name_loc4` varchar(100) NOT NULL default '',  `name_loc5` varchar(100) NOT NULL default '',  `name_loc6` varchar(100) NOT NULL default '',  `name_loc7` varchar(100) NOT NULL default '',  `subname_loc1` varchar(100) default NULL,  `subname_loc2` varchar(100) default NULL,  `subname_loc3` varchar(100) default NULL,  `subname_loc4` varchar(100) default NULL,  `subname_loc5` varchar(100) default NULL,  `subname_loc6` varchar(100) default NULL,  `subname_loc7` varchar(100) default NULL,  `subname_loc8` varchar(100) default NULL,  PRIMARY KEY  (`entry`)) ENGINE=MyISAM DEFAULT CHARSET=utf8;DROP TABLE IF EXISTS `locales_gameobject`;CREATE TABLE `locales_gameobject` (  `entry` int(11) unsigned NOT NULL default '0',  `name_loc1` varchar(100) NOT NULL default '',  `name_loc2` varchar(100) NOT NULL default '',  `name_loc3` varchar(100) NOT NULL default '',  `name_loc4` varchar(100) NOT NULL default '',  `name_loc5` varchar(100) NOT NULL default '',  `name_loc6` varchar(100) NOT NULL default '',  `name_loc7` varchar(100) NOT NULL default '',  PRIMARY KEY  (`entry`)) ENGINE=MyISAM DEFAULT CHARSET=utf8;DROP TABLE IF EXISTS `locales_item`;CREATE TABLE `locales_item` (  `entry` int(11) unsigned NOT NULL default '0',  `name_loc1` varchar(100) NOT NULL default '',  `name_loc2` varchar(100) NOT NULL default '',  `name_loc3` varchar(100) NOT NULL default '',  `name_loc4` varchar(100) NOT NULL default '',  `name_loc5` varchar(100) NOT NULL default '',  `name_loc6` varchar(100) NOT NULL default '',  `name_loc7` varchar(100) NOT NULL default '',  `description_loc1` varchar(255) default NULL,  `description_loc2` varchar(255) default NULL,  `description_loc3` varchar(255) default NULL,  `description_loc4` varchar(255) default NULL,  `description_loc5` varchar(255) default NULL,  `description_loc6` varchar(255) default NULL,  `description_loc7` varchar(255) default NULL,  PRIMARY KEY  (`entry`)) ENGINE=MyISAM DEFAULT CHARSET=utf8;DROP TABLE IF EXISTS `locales_quest`;CREATE TABLE `locales_quest` (  `entry` int(11) unsigned NOT NULL default '0',  `Title_loc1` text,  `Title_loc2` text,  `Title_loc3` text,  `Title_loc4` text,  `Title_loc5` text,  `Title_loc6` text,  `Title_loc7` text,  `Details_loc1` text,  `Details_loc2` text,  `Details_loc3` text,  `Details_loc4` text,  `Details_loc5` text,  `Details_loc6` text,  `Details_loc7` text,  `Objectives_loc1` text,  `Objectives_loc2` text,  `Objectives_loc3` text,  `Objectives_loc4` text,  `Objectives_loc5` text,  `Objectives_loc6` text,  `Objectives_loc7` text,  `OfferRewardText_loc1` text,  `OfferRewardText_loc2` text,  `OfferRewardText_loc3` text,  `OfferRewardText_loc4` text,  `OfferRewardText_loc5` text,  `OfferRewardText_loc6` text,  `OfferRewardText_loc7` text,  `RequestItemsText_loc1` text,  `RequestItemsText_loc2` text,  `RequestItemsText_loc3` text,  `RequestItemsText_loc4` text,  `RequestItemsText_loc5` text,  `RequestItemsText_loc6` text,  `RequestItemsText_loc7` text,  `EndText_loc1` text,  `EndText_loc2` text,  `EndText_loc3` text,  `EndText_loc4` text,  `EndText_loc5` text,  `EndText_loc6` text,  `EndText_loc7` text,  `ObjectiveText1_loc1` text,  `ObjectiveText1_loc2` text,  `ObjectiveText1_loc3` text,  `ObjectiveText1_loc4` text,  `ObjectiveText1_loc5` text,  `ObjectiveText1_loc6` text,  `ObjectiveText1_loc7` text,  `ObjectiveText2_loc1` text,  `ObjectiveText2_loc2` text,  `ObjectiveText2_loc3` text,  `ObjectiveText2_loc4` text,  `ObjectiveText2_loc5` text,  `ObjectiveText2_loc6` text,  `ObjectiveText2_loc7` text,  `ObjectiveText3_loc1` text,  `ObjectiveText3_loc2` text,  `ObjectiveText3_loc3` text,  `ObjectiveText3_loc4` text,  `ObjectiveText3_loc5` text,  `ObjectiveText3_loc6` text,  `ObjectiveText3_loc7` text,  `ObjectiveText4_loc1` text,  `ObjectiveText4_loc2` text,  `ObjectiveText4_loc3` text,  `ObjectiveText4_loc4` text,  `ObjectiveText4_loc5` text,  `ObjectiveText4_loc6` text,  `ObjectiveText4_loc7` text,  PRIMARY KEY  (`entry`)) ENGINE=MyISAM DEFAULT CHARSET=utf8;DROP TABLE IF EXISTS `locales_npc_text`;CREATE TABLE `locales_npc_text` (  `entry` int(11) unsigned NOT NULL default '0',  `Text0_0_loc1` longtext,  `Text0_0_loc2` longtext,  `Text0_0_loc3` longtext,  `Text0_0_loc4` longtext,  `Text0_0_loc5` longtext,  `Text0_0_loc6` longtext,  `Text0_0_loc7` longtext,  `Text0_1_loc1` longtext,  `Text0_1_loc2` longtext,  `Text0_1_loc3` longtext,  `Text0_1_loc4` longtext,  `Text0_1_loc5` longtext,  `Text0_1_loc6` longtext,  `Text0_1_loc7` longtext,  `Text1_0_loc1` longtext,  `Text1_0_loc2` longtext,  `Text1_0_loc3` longtext,  `Text1_0_loc4` longtext,  `Text1_0_loc5` longtext,  `Text1_0_loc6` longtext,  `Text1_0_loc7` longtext,  `Text1_1_loc1` longtext,  `Text1_1_loc2` longtext,  `Text1_1_loc3` longtext,  `Text1_1_loc4` longtext,  `Text1_1_loc5` longtext,  `Text1_1_loc6` longtext,  `Text1_1_loc7` longtext,  `Text2_0_loc1` longtext,  `Text2_0_loc2` longtext,  `Text2_0_loc3` longtext,  `Text2_0_loc4` longtext,  `Text2_0_loc5` longtext,  `Text2_0_loc6` longtext,  `Text2_0_loc7` longtext,  `Text2_1_loc1` longtext,  `Text2_1_loc2` longtext,  `Text2_1_loc3` longtext,  `Text2_1_loc4` longtext,  `Text2_1_loc5` longtext,  `Text2_1_loc6` longtext,  `Text2_1_loc7` longtext,  `Text3_0_loc1` longtext,  `Text3_0_loc2` longtext,  `Text3_0_loc3` longtext,  `Text3_0_loc4` longtext,  `Text3_0_loc5` longtext,  `Text3_0_loc6` longtext,  `Text3_0_loc7` longtext,  `Text3_1_loc1` longtext,  `Text3_1_loc2` longtext,  `Text3_1_loc3` longtext,  `Text3_1_loc4` longtext,  `Text3_1_loc5` longtext,  `Text3_1_loc6` longtext,  `Text3_1_loc7` longtext,  `Text4_0_loc1` longtext,  `Text4_0_loc2` longtext,  `Text4_0_loc3` longtext,  `Text4_0_loc4` longtext,  `Text4_0_loc5` longtext,  `Text4_0_loc6` longtext,  `Text4_0_loc7` longtext,  `Text4_1_loc1` longtext,  `Text4_1_loc2` longtext,  `Text4_1_loc3` longtext,  `Text4_1_loc4` longtext,  `Text4_1_loc5` longtext,  `Text4_1_loc6` longtext,  `Text4_1_loc7` longtext,  `Text5_0_loc1` longtext,  `Text5_0_loc2` longtext,  `Text5_0_loc3` longtext,  `Text5_0_loc4` longtext,  `Text5_0_loc5` longtext,  `Text5_0_loc6` longtext,  `Text5_0_loc7` longtext,  `Text5_1_loc1` longtext,  `Text5_1_loc2` longtext,  `Text5_1_loc3` longtext,  `Text5_1_loc4` longtext,  `Text5_1_loc5` longtext,  `Text5_1_loc6` longtext,  `Text5_1_loc7` longtext,  `Text6_0_loc1` longtext,  `Text6_0_loc2` longtext,  `Text6_0_loc3` longtext,  `Text6_0_loc4` longtext,  `Text6_0_loc5` longtext,  `Text6_0_loc6` longtext,  `Text6_0_loc7` longtext,  `Text6_1_loc1` longtext,  `Text6_1_loc2` longtext,  `Text6_1_loc3` longtext,  `Text6_1_loc4` longtext,  `Text6_1_loc5` longtext,  `Text6_1_loc6` longtext,  `Text6_1_loc7` longtext,  `Text7_0_loc1` longtext,  `Text7_0_loc2` longtext,  `Text7_0_loc3` longtext,  `Text7_0_loc4` longtext,  `Text7_0_loc5` longtext,  `Text7_0_loc6` longtext,  `Text7_0_loc7` longtext,  `Text7_1_loc1` longtext,  `Text7_1_loc2` longtext,  `Text7_1_loc3` longtext,  `Text7_1_loc4` longtext,  `Text7_1_loc5` longtext,  `Text7_1_loc6` longtext,  `Text7_1_loc7` longtext,  PRIMARY KEY  (`entry`)) ENGINE=MyISAM DEFAULT CHARSET=utf8;DROP TABLE IF EXISTS `locales_page_text`;CREATE TABLE `locales_page_text` (  `entry` int(11) unsigned NOT NULL default '0',  `Text_loc1` longtext,  `Text_loc2` longtext,  `Text_loc3` longtext,  `Text_loc4` longtext,  `Text_loc5` longtext,  `Text_loc6` longtext,  `Text_loc7` longtext,  PRIMARY KEY  (`entry`)) ENGINE=MyISAM DEFAULT CHARSET=utf8;DROP TABLE IF EXISTS `realmd`.`localization`;CREATE TABLE `realmd`.`localization` (  `locale` tinyint(3) unsigned NOT NULL default '0',  `string` char(2) NOT NULL DEFAULT '',  PRIMARY KEY (`locale`)) ENGINE=MyISAM DEFAULT CHARSET=utf8;INSERT INTO `realmd`.`localization` VALUES    (0,'en'),    (2,'fr'),    (3,'de');