CREATE TABLE `wbkeyvaluepairkey` (
  `mandatorid` int(11) unsigned NOT NULL DEFAULT 0,
  `keyid` int(11) unsigned NOT NULL DEFAULT 0,
  `domain` varchar(128) NOT NULL DEFAULT '',
  `word` varchar(128) NOT NULL DEFAULT '',
  `orderpos` int(11) unsigned NOT NULL DEFAULT 0,
  PRIMARY KEY (`mandatorid`,`keyid`),
  KEY `word` (`domain`,`word`),
  KEY `mandatorid` (`mandatorid`),
  KEY `orderpos` (`orderpos`)
) ENGINE=MyISAM AUTO_INCREMENT=1000 DEFAULT CHARSET=utf8 COMMENT='Key Value Pair Key';

CREATE TABLE `wbkeyvaluepairvalue` (
  `mandatorid` int(11) unsigned NOT NULL DEFAULT 0,
  `valueid` int(11) unsigned NOT NULL DEFAULT 0,
  `word` text NOT NULL DEFAULT '',
  PRIMARY KEY (`mandatorid`,`valueid`),
  KEY `mandatorid` (`mandatorid`)
) ENGINE=MyISAM AUTO_INCREMENT=1000 DEFAULT CHARSET=utf8 COMMENT='Key Value Pair Value';

CREATE TABLE `wbkeyvaluepairkeyvalueid` (
  `mandatorid` int(11) unsigned NOT NULL DEFAULT 0,
  `keyvalueid` int(11) unsigned NOT NULL DEFAULT 0,
  `created` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`mandatorid`,`keyvalueid`),
  KEY `mandatorid` (`mandatorid`)
) ENGINE=MyISAM AUTO_INCREMENT=1000 DEFAULT CHARSET=utf8 COMMENT='Key Value Pair Key/Value Pair';

CREATE TABLE `wbkeyvaluepairkeyvalue` (
  `keyvalueid` int(11) unsigned NOT NULL,
  `keyid` int(11) unsigned NOT NULL,
  `valueid` int(11) unsigned NOT NULL,
  `mandatorid` int(11) unsigned NOT NULL DEFAULT 0,
  KEY `keyvalueid` (`keyvalueid`),
  KEY `mandatorid` (`mandatorid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Key Value Pair Key/Value relation';

