CREATE TABLE `translation` (
  `id` int(10) NOT NULL auto_increment,
  `section_id` int(11) NOT NULL,
  `language_id` char(4) NOT NULL,
  `translator_id` int(11) default NULL COMMENT 'Translator to blame for this translation',
  `version` int(10) unsigned default NULL,
  `value` text,
  `validation_count` tinyint(3) unsigned default '0',
  PRIMARY KEY  (`id`),
  UNIQUE KEY `natural_key` (`section_id`,`language_id`,`version`),
  KEY `index_language` (`language_id`),
  KEY `index_section` (`section_id`),
  KEY `index_version` (`version`),
  KEY `index_translator` (`translator_id`),
  FULLTEXT KEY `fulltext_value` (`value`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC