Npc text localized

From ArcEmu-Wiki
Jump to: navigation, search

SQL Structure

CREATE TABLE `npc_text_localized` (
  `entry` int(30) NOT NULL,
  `language_code` varchar(5) character set latin1 NOT NULL,
  `text0` varchar(200) character set latin1 NOT NULL,
  `text0_1` varchar(200) character set latin1 NOT NULL,
  `text1` varchar(200) character set latin1 NOT NULL,
  `text1_1` varchar(200) character set latin1 NOT NULL,
  `text2` varchar(200) character set latin1 NOT NULL,
  `text2_1` varchar(200) character set latin1 NOT NULL,
  `text3` varchar(200) character set latin1 NOT NULL,
  `text3_1` varchar(200) character set latin1 NOT NULL,
  `text4` varchar(200) character set latin1 NOT NULL,
  `text4_1` varchar(200) character set latin1 NOT NULL,
  `text5` varchar(200) character set latin1 NOT NULL,
  `text5_1` varchar(200) character set latin1 NOT NULL,
  `text6` varchar(200) character set latin1 NOT NULL,
  `text6_1` varchar(200) character set latin1 NOT NULL,
  `text7` varchar(200) character set latin1 NOT NULL,
  `text7_1` varchar(200) character set latin1 NOT NULL,
  PRIMARY KEY  (`entry`,`language_code`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
Personal tools