CREATE TABLE IF NOT EXISTS `facets` (
  `idFacet` int(11) NOT NULL AUTO_INCREMENT,
  `marcflavour` varchar(50) COLLATE utf8_unicode_ci DEFAULT '',
  `idx` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL,
  `label` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL,
  `authorised_value` varchar(10) COLLATE utf8_unicode_ci DEFAULT NULL,
  `tags` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `position` int(11) DEFAULT NULL,
  `vlength` int(11) DEFAULT NULL,
  `expanded` tinyint(1) DEFAULT NULL,
  `singleBranchMode` tinyint(1) DEFAULT '0',
  `active` tinyint(1) DEFAULT '0',
  `category` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `sep` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`idFacet`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;