CREATE TABLE IF NOT EXISTS `foo` (
  `OXID` char(32) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL COMMENT 'Item id',
  `FOOTITLE` varchar(128) NOT NULL DEFAULT '' COMMENT 'Title (multilanguage)',
  `FOOTITLE_1` varchar(128) NOT NULL DEFAULT '',
  `FOOTITLE_2` varchar(128) NOT NULL DEFAULT '',
  `FOOTITLE_3` varchar(128) NOT NULL DEFAULT '',
  `FOOTITLE_4` varchar(128) NOT NULL DEFAULT '',
  `FOOTITLE_5` varchar(128) NOT NULL DEFAULT '',
  `FOOTITLE_6` varchar(128) NOT NULL DEFAULT '',
  `FOOTITLE_7` varchar(128) NOT NULL DEFAULT '',
  PRIMARY KEY (`OXID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='foo';