/**
 * basic table for all messages to be translated
 *
 * This table contains translation culumns for "de"
 */

CREATE TABLE `wbnlsmsg` (
  `mid` int(11) NOT NULL AUTO_INCREMENT,
  `singular` int(11) 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,
  `trans_de_DE` text,
  `changed_de_DE` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `min_de_DE` int(11) DEFAULT '0',
  `msg_org` text NOT NULL,
  PRIMARY KEY (`mid`),
  KEY `md5` (`md5`),
  KEY `domain` (`domain`)
) ENGINE=MyISAM AUTO_INCREMENT=1017 DEFAULT CHARSET=utf8 COMMENT='i18n messages';

/**
 * To add another language, simply add three columns:
 * language "fr_FR"
 */
ALTER TABLE wbnlsmsg ADD COLUMN (
    `trans_en_US` text,
    `changed_en_US` datetime NOT NULL default '0000-00-00 00:00:00',
    `min_en_US` int(11) default 0
);

