CREATE TABLE `microsite` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `subdomain` varchar(100) COLLATE utf8_hungarian_ci NOT NULL,
  `blog_id` int(11) NOT NULL,
  `name` varchar(255) COLLATE utf8_hungarian_ci NOT NULL,
  `namespace` varchar(25) COLLATE utf8_hungarian_ci NOT NULL,
  `subtitle` varchar(255) COLLATE utf8_hungarian_ci NOT NULL,
  `main_image` varchar(255) COLLATE utf8_hungarian_ci NOT NULL,
  `editor_image` text COLLATE utf8_hungarian_ci NOT NULL,
  `color_background` varchar(20) COLLATE utf8_hungarian_ci NOT NULL,
  `color_secondary` varchar(20) COLLATE utf8_hungarian_ci NOT NULL,
  `color_text` varchar(20) COLLATE utf8_hungarian_ci NOT NULL,
  `facebook` varchar(255) COLLATE utf8_hungarian_ci NOT NULL,
  `twitter` varchar(255) COLLATE utf8_hungarian_ci NOT NULL,
  `pinterest` varchar(255) COLLATE utf8_hungarian_ci NOT NULL,
  `google_plus` varchar(255) COLLATE utf8_hungarian_ci NOT NULL,
  `description` text COLLATE utf8_hungarian_ci NOT NULL,
  `terms_and_conditions` text COLLATE utf8_hungarian_ci NOT NULL,
  `contact_email` varchar(255) COLLATE utf8_hungarian_ci NOT NULL,
  `contact_text` text COLLATE utf8_hungarian_ci NOT NULL,
  `contact_phone` varchar(255) COLLATE utf8_hungarian_ci NOT NULL,
  `home_page_box` int(1) NOT NULL DEFAULT '4',
  `homepage_config` text COLLATE utf8_hungarian_ci NOT NULL,
  `featured_product_config` text COLLATE utf8_hungarian_ci NOT NULL,
  `grid` varchar(20) COLLATE utf8_hungarian_ci NOT NULL,
  `color_scheme` varchar(20) COLLATE utf8_hungarian_ci NOT NULL,
  `sh_templates` varchar(1) COLLATE utf8_hungarian_ci NOT NULL,
  `sh_contact` varchar(1) COLLATE utf8_hungarian_ci NOT NULL,
  `sh_gallery` varchar(1) COLLATE utf8_hungarian_ci NOT NULL,
  `sh_about` varchar(1) COLLATE utf8_hungarian_ci NOT NULL,
  `css` text COLLATE utf8_hungarian_ci NOT NULL,
  `cssvisible` varchar(1) COLLATE utf8_hungarian_ci NOT NULL,
  `3dservice_enabled` tinyint(1) NOT NULL DEFAULT '0',
  `3dservice_email` varchar(255) COLLATE utf8_hungarian_ci NOT NULL DEFAULT '',
  `3dservice_button_text` varchar(255) COLLATE utf8_hungarian_ci NOT NULL DEFAULT '',
  `3dservice_format` varchar(50) COLLATE utf8_hungarian_ci NOT NULL DEFAULT 'obj',
  `3dservice_materials` text COLLATE utf8_hungarian_ci NOT NULL,
  `meta_description` varchar(255) COLLATE utf8_hungarian_ci NOT NULL,
  `meta_key` varchar(100) COLLATE utf8_hungarian_ci NOT NULL,
  `languages` varchar(40) COLLATE utf8_hungarian_ci NOT NULL,
  `language_id` tinyint(4) NOT NULL DEFAULT '1',
  `is_import` tinyint(1) NOT NULL,
  `is_active` tinyint(1) NOT NULL DEFAULT '1',
  PRIMARY KEY (`id`),
  UNIQUE KEY `subdomain` (`subdomain`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_hungarian_ci