CREATE TABLE `system` (
  `id` int(1) NOT NULL AUTO_INCREMENT,
  `name` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  `site` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `address` varchar(150) COLLATE utf8_unicode_ci NOT NULL,
  `phone` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  `fax` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  `description` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `url` varchar(200) COLLATE utf8_unicode_ci NOT NULL,
  `email` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `is_multilanguage` tinyint(1) NOT NULL,
  `language_id` tinyint(3) NOT NULL,
  `content_id` int(5) NOT NULL,
  `skype` varchar(70) COLLATE utf8_unicode_ci NOT NULL,
  `static_element_version_number` int(11) NOT NULL,
  `they_like_us_type` enum('carousel','list') COLLATE utf8_unicode_ci NOT NULL,
  `microsite_id` int(11) NOT NULL,
  `namespace` varchar(20) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'Index',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci