/**
 * Basic table for all messages to be translated
 *
 */
DROP TABLE IF EXISTS wbnlsmsg;
CREATE TABLE wbnlsmsg (
  mid int(11) unsigned NOT NULL AUTO_INCREMENT,
  singular int(11) unsigned DEFAULT NULL,
  created datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  changed datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  domain char(32) NOT NULL,
  md5 char(32) NOT NULL,
  msg text NOT NULL,
  msg_org text NOT NULL,
  orphan tinyint(1) NOT NULL DEFAULT 0,
  urlid int(11) UNSIGNED NOT NULL DEFAULT 0,
  path varchar(255) NOT NULL DEFAULT '',
  xnamespace char(64) NOT NULL DEFAULT "",
  xid char(32) NOT NULL DEFAULT "",
  PRIMARY KEY (`mid`),
  KEY `md5` (`md5`),
  KEY `domain` (`domain`),
  KEY (xnamespace)
) AUTO_INCREMENT=1000 COMMENT='i18n messages';

-- add language: see nls-addLang.sql

/**
 * Some users may translate only defined languages
 * List languages that a use may translate
 */
DROP TABLE IF EXISTS wbnlslangtranslator;
CREATE TABLE `wbnlslangtranslator` (
  `uid` int(11) unsigned NOT NULL,
  `lang` char(5) NOT NULL,
  KEY `uid` (`uid`)
) COMMENT='i18n translators';

