CREATE TABLE `app` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `is_public` tinyint(4) NOT NULL DEFAULT '0',
  `name` varchar(255) CHARACTER SET latin1 NOT NULL,
  `slug` varchar(255) CHARACTER SET latin1 NOT NULL,
  `subtitle` varchar(255) CHARACTER SET latin1 NOT NULL,
  `excerpt` text CHARACTER SET latin1 NOT NULL,
  `description` text CHARACTER SET latin1 NOT NULL,
  `facebook_create` varchar(255) CHARACTER SET latin1 NOT NULL,
  `facebook_view` varchar(255) CHARACTER SET latin1 NOT NULL,
  `main_image` varchar(255) CHARACTER SET latin1 NOT NULL,
  `main_video` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
  `lead_image` varchar(255) CHARACTER SET latin1 NOT NULL,
  `index_page_image` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
  `skybox_image` text COLLATE utf8_hungarian_ci NOT NULL,
  `background_image` text COLLATE utf8_hungarian_ci NOT NULL,
  `background_color` text COLLATE utf8_hungarian_ci NOT NULL,
  `background_property` text COLLATE utf8_hungarian_ci NOT NULL,
  `fixedPlaneRot` tinyint(4) DEFAULT NULL,
  `ground` tinyint(4) NOT NULL DEFAULT '1',
  `type` varchar(255) CHARACTER SET latin1 NOT NULL DEFAULT 'standard',
  `is_slider` tinyint(4) NOT NULL DEFAULT '0',
  `place` int(11) NOT NULL DEFAULT '0',
  `on_app_page` tinyint(4) NOT NULL DEFAULT '1',
  `on_edu` tinyint(4) NOT NULL DEFAULT '1',
  `category_id` int(9) NOT NULL DEFAULT '-1',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_hungarian_ci