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;