DROP TABLE IF EXISTS `admin_login`;
CREATE TABLE `admin_login` (
  `id` int NOT NULL AUTO_INCREMENT,
  `time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `ip` varchar(16) COLLATE utf8_unicode_ci NOT NULL,
  `success` enum('Y','N') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'N',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;


DROP TABLE IF EXISTS `admin_replier`;
CREATE TABLE `admin_replier` (
  `id` int NOT NULL AUTO_INCREMENT,
  `username` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  `password` varchar(32) COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`id`),
  KEY `name` (`username`),
  KEY `password` (`password`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;


DROP TABLE IF EXISTS `adv_cars`;
CREATE TABLE `adv_cars` (
  `id` int NOT NULL AUTO_INCREMENT,
  `subject` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `body` text COLLATE utf8_unicode_ci NOT NULL,
  `user_id` int NOT NULL DEFAULT '0',
  `razd_id` int NOT NULL DEFAULT '0',
  `created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `cat_id` int NOT NULL DEFAULT '0',
  `price` decimal(13,2) NOT NULL DEFAULT '0.00',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;


DROP TABLE IF EXISTS `adv_casting`;
CREATE TABLE `adv_casting` (
  `id` int NOT NULL AUTO_INCREMENT,
  `subject` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `body` text COLLATE utf8_unicode_ci NOT NULL,
  `user_id` int NOT NULL DEFAULT '0',
  `razd_id` int NOT NULL DEFAULT '0',
  `created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `cat_id` int NOT NULL DEFAULT '0',
  `age` int NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;


DROP TABLE IF EXISTS `adv_cats`;
CREATE TABLE `adv_cats` (
  `id` int NOT NULL AUTO_INCREMENT,
  `name` varchar(100) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `eng` varchar(10) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `rank` int NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;


DROP TABLE IF EXISTS `adv_film`;
CREATE TABLE `adv_film` (
  `id` int NOT NULL AUTO_INCREMENT,
  `subject` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `body` text COLLATE utf8_unicode_ci NOT NULL,
  `user_id` int NOT NULL DEFAULT '0',
  `razd_id` int NOT NULL DEFAULT '0',
  `created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `cat_id` int NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;


DROP TABLE IF EXISTS `adv_housting`;
CREATE TABLE `adv_housting` (
  `id` int NOT NULL AUTO_INCREMENT,
  `subject` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `body` text COLLATE utf8_unicode_ci NOT NULL,
  `user_id` int NOT NULL DEFAULT '0',
  `razd_id` int NOT NULL DEFAULT '0',
  `created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `cat_id` int NOT NULL DEFAULT '0',
  `rent` decimal(13,2) NOT NULL DEFAULT '0.00',
  `br` int NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;


DROP TABLE IF EXISTS `adv_images`;
CREATE TABLE `adv_images` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `adv_cat_id` bigint NOT NULL DEFAULT '0',
  `adv_id` bigint NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `adv_cat_id` (`adv_cat_id`,`adv_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;


DROP TABLE IF EXISTS `adv_items`;
CREATE TABLE `adv_items` (
  `id` int NOT NULL AUTO_INCREMENT,
  `subject` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `body` text COLLATE utf8_unicode_ci NOT NULL,
  `user_id` int NOT NULL DEFAULT '0',
  `razd_id` int NOT NULL DEFAULT '0',
  `created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `cat_id` int NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;


DROP TABLE IF EXISTS `adv_jobs`;
CREATE TABLE `adv_jobs` (
  `id` int NOT NULL AUTO_INCREMENT,
  `subject` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `body` text COLLATE utf8_unicode_ci NOT NULL,
  `user_id` int NOT NULL DEFAULT '0',
  `razd_id` int NOT NULL DEFAULT '0',
  `created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `cat_id` int NOT NULL DEFAULT '0',
  `telecommute` tinyint NOT NULL DEFAULT '0',
  `contract` tinyint NOT NULL DEFAULT '0',
  `internship` tinyint NOT NULL DEFAULT '0',
  `part_time` tinyint NOT NULL DEFAULT '0',
  `non_profit` tinyint NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;


DROP TABLE IF EXISTS `adv_music`;
CREATE TABLE `adv_music` (
  `id` int NOT NULL AUTO_INCREMENT,
  `subject` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `body` text COLLATE utf8_unicode_ci NOT NULL,
  `user_id` int NOT NULL DEFAULT '0',
  `razd_id` int NOT NULL DEFAULT '0',
  `created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `cat_id` int NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;


DROP TABLE IF EXISTS `adv_myspace`;
CREATE TABLE `adv_myspace` (
  `id` int NOT NULL AUTO_INCREMENT,
  `subject` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `body` text COLLATE utf8_unicode_ci NOT NULL,
  `user_id` int NOT NULL DEFAULT '0',
  `razd_id` int NOT NULL DEFAULT '0',
  `created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `cat_id` int NOT NULL DEFAULT '0',
  `age` int NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;


DROP TABLE IF EXISTS `adv_personals`;
CREATE TABLE `adv_personals` (
  `id` int NOT NULL AUTO_INCREMENT,
  `subject` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `body` text COLLATE utf8_unicode_ci NOT NULL,
  `user_id` int NOT NULL DEFAULT '0',
  `razd_id` int NOT NULL DEFAULT '0',
  `created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `cat_id` int NOT NULL DEFAULT '0',
  `age` int NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;


DROP TABLE IF EXISTS `adv_razd`;
CREATE TABLE `adv_razd` (
  `id` int NOT NULL AUTO_INCREMENT,
  `name` varchar(100) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `cat_id` int NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;


DROP TABLE IF EXISTS `adv_sale`;
CREATE TABLE `adv_sale` (
  `id` int NOT NULL AUTO_INCREMENT,
  `subject` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `body` text COLLATE utf8_unicode_ci NOT NULL,
  `user_id` int NOT NULL DEFAULT '0',
  `razd_id` int NOT NULL DEFAULT '0',
  `created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `cat_id` int NOT NULL DEFAULT '0',
  `price` decimal(13,2) NOT NULL DEFAULT '0.00',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;


DROP TABLE IF EXISTS `adv_services`;
CREATE TABLE `adv_services` (
  `id` int NOT NULL AUTO_INCREMENT,
  `subject` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `body` text COLLATE utf8_unicode_ci NOT NULL,
  `user_id` int NOT NULL DEFAULT '0',
  `razd_id` int NOT NULL DEFAULT '0',
  `created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `cat_id` int NOT NULL DEFAULT '0',
  `price` decimal(13,2) NOT NULL DEFAULT '0.00',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;


DROP TABLE IF EXISTS `app_push_tokens`;
CREATE TABLE `app_push_tokens` (
  `user_id` bigint NOT NULL,
  `operation_system` enum('android','ios') COLLATE utf8_unicode_ci NOT NULL,
  `token` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `last_update` int NOT NULL,
  UNIQUE KEY `token` (`token`),
  KEY `user_id` (`user_id`),
  KEY `last_update` (`last_update`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;


DROP TABLE IF EXISTS `audio_greeting`;
CREATE TABLE `audio_greeting` (
  `user_id` bigint NOT NULL,
  `hash` varchar(32) COLLATE utf8_unicode_ci NOT NULL,
  KEY `user_id` (`user_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;


DROP TABLE IF EXISTS `audio_invite`;
CREATE TABLE `audio_invite` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `from_user` int unsigned NOT NULL DEFAULT '0',
  `to_user` int unsigned NOT NULL DEFAULT '0',
  `group_id` bigint NOT NULL DEFAULT '0',
  `city` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;


DROP TABLE IF EXISTS `audio_reject`;
CREATE TABLE `audio_reject` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `from_user` int unsigned NOT NULL DEFAULT '0',
  `to_user` int unsigned NOT NULL DEFAULT '0',
  `go` enum('Y','N') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'Y',
  `group_id` bigint NOT NULL DEFAULT '0',
  `city` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;


DROP TABLE IF EXISTS `aux_embed_vids`;
CREATE TABLE `aux_embed_vids` (
  `id` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `info` text COLLATE utf8_unicode_ci NOT NULL,
  UNIQUE KEY `id` (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;


DROP TABLE IF EXISTS `banners`;
CREATE TABLE `banners` (
  `id` int NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `place` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `type` enum('flash','graph','code') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'flash',
  `filename` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `alt` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `url` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `code` text COLLATE utf8_unicode_ci NOT NULL,
  `width` int NOT NULL,
  `height` int NOT NULL,
  `langs` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `active` enum('1','0') COLLATE utf8_unicode_ci NOT NULL DEFAULT '1',
  `templates` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  PRIMARY KEY (`id`),
  KEY `place` (`place`),
  KEY `active` (`active`),
  FULLTEXT KEY `templates` (`templates`),
  FULLTEXT KEY `langs` (`langs`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;


DROP TABLE IF EXISTS `banners_places`;
CREATE TABLE `banners_places` (
  `id` int NOT NULL AUTO_INCREMENT,
  `place` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `type` enum('static','random') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'static',
  `active` enum('1','0') COLLATE utf8_unicode_ci NOT NULL DEFAULT '1',
  PRIMARY KEY (`id`),
  KEY `place` (`place`),
  KEY `active` (`active`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;


DROP TABLE IF EXISTS `blogs_comment`;
CREATE TABLE `blogs_comment` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `post_id` int unsigned NOT NULL DEFAULT '0',
  `post_user_id` int NOT NULL DEFAULT '0',
  `user_id` int unsigned NOT NULL DEFAULT '0',
  `parent_id` int DEFAULT '0',
  `parent_user_id` int DEFAULT '0',
  `text` text COLLATE utf8_unicode_ci NOT NULL,
  `dt` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `send` bigint unsigned NOT NULL DEFAULT '0',
  `replies` int DEFAULT '0',
  `likes` int NOT NULL DEFAULT '0',
  `last_action_like` datetime NOT NULL,
  `is_new` tinyint(1) NOT NULL DEFAULT '0',
  `is_new_like` tinyint(1) NOT NULL DEFAULT '0',
  `audio_message_id` bigint unsigned NOT NULL,
  PRIMARY KEY (`id`),
  KEY `parent_id` (`parent_id`),
  KEY `parent_user_id` (`parent_user_id`),
  KEY `id_parent_id` (`id`,`parent_id`),
  KEY `blog_id_parent_id` (`post_id`,`parent_id`),
  KEY `is_new` (`is_new`),
  KEY `is_new_like` (`is_new_like`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;


DROP TABLE IF EXISTS `blogs_comments_likes`;
CREATE TABLE `blogs_comments_likes` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `post_id` int NOT NULL,
  `post_user_id` int NOT NULL,
  `user_id` int NOT NULL,
  `cid` int NOT NULL,
  `comment_user_id` int NOT NULL,
  `date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `is_new` tinyint(1) NOT NULL DEFAULT '0',
  `group_id` bigint NOT NULL DEFAULT '0',
  `group_user_id` int NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `user_id_cid` (`user_id`,`cid`,`post_id`),
  KEY `date` (`date`),
  KEY `is_new` (`is_new`),
  KEY `cid_id` (`cid`,`id`),
  KEY `group_id` (`group_id`),
  KEY `group_user_id` (`group_user_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;


DROP TABLE IF EXISTS `blogs_hotsearch`;
CREATE TABLE `blogs_hotsearch` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `text` text COLLATE utf8_unicode_ci NOT NULL,
  `count` int unsigned NOT NULL DEFAULT '0',
  `dt` datetime NOT NULL,
  PRIMARY KEY (`id`),
  KEY `count` (`count`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;


DROP TABLE IF EXISTS `blogs_post`;
CREATE TABLE `blogs_post` (
  `id` int NOT NULL AUTO_INCREMENT,
  `user_id` int NOT NULL DEFAULT '0',
  `dt` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `count_views` int unsigned NOT NULL DEFAULT '0',
  `subject` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `name_seo` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `text` text COLLATE utf8_unicode_ci NOT NULL,
  `word_count` bigint NOT NULL DEFAULT '0',
  `search_index` text COLLATE utf8_unicode_ci NOT NULL,
  `images` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `comments_enabled` tinyint(1) NOT NULL DEFAULT '1',
  `count_comments_all` int unsigned NOT NULL DEFAULT '0',
  `count_comments` int unsigned NOT NULL DEFAULT '0',
  `count_comments_replies` int unsigned NOT NULL DEFAULT '0',
  `likes` int NOT NULL,
  `last_action_like` datetime NOT NULL,
  `last_action_comment_like` datetime NOT NULL,
  PRIMARY KEY (`id`),
  KEY `user_id` (`user_id`),
  KEY `dt` (`dt`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;


DROP TABLE IF EXISTS `blogs_post_likes`;
CREATE TABLE `blogs_post_likes` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `user_id` int NOT NULL,
  `blog_id` int NOT NULL,
  `date` datetime NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `user_id` (`user_id`,`blog_id`),
  KEY `blog_id_id` (`blog_id`,`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;


DROP TABLE IF EXISTS `blogs_post_tags`;
CREATE TABLE `blogs_post_tags` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `tag` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `counter` int NOT NULL,
  PRIMARY KEY (`id`),
  KEY `tag` (`tag`),
  KEY `counter` (`counter`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;


DROP TABLE IF EXISTS `blogs_post_tags_relations`;
CREATE TABLE `blogs_post_tags_relations` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `blog_id` int NOT NULL,
  `tag_id` bigint NOT NULL,
  PRIMARY KEY (`id`),
  KEY `blog_id` (`blog_id`),
  KEY `tag_id` (`tag_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;


DROP TABLE IF EXISTS `blogs_subscribe`;
CREATE TABLE `blogs_subscribe` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `subscriber_user_id` int unsigned NOT NULL DEFAULT '0',
  `blogger_user_id` int unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;


DROP TABLE IF EXISTS `chat_chair`;
CREATE TABLE `chat_chair` (
  `id` int NOT NULL AUTO_INCREMENT,
  `position` tinyint NOT NULL DEFAULT '0',
  `joined` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `avatar` smallint NOT NULL DEFAULT '0',
  `nick` varchar(20) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `lastbreath` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `bot` tinyint NOT NULL DEFAULT '0',
  `asked` int NOT NULL DEFAULT '0',
  `room` int NOT NULL DEFAULT '1',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;


DROP TABLE IF EXISTS `chat_line`;
CREATE TABLE `chat_line` (
  `id` int NOT NULL AUTO_INCREMENT,
  `nick` varchar(20) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `fingerprint` varchar(15) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `line` varchar(150) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `timesaid` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `suborder` tinyint NOT NULL DEFAULT '1',
  `room` int NOT NULL DEFAULT '1',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;


DROP TABLE IF EXISTS `chat_room`;
CREATE TABLE `chat_room` (
  `id` int NOT NULL AUTO_INCREMENT,
  `name` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '',
  `tag` varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '',
  `password` varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '''''',
  `status` tinyint(1) NOT NULL DEFAULT '1',
  `position` int NOT NULL,
  KEY `id` (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;


DROP TABLE IF EXISTS `city_avatar_face`;
CREATE TABLE `city_avatar_face` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `photo_id` int unsigned NOT NULL DEFAULT '0',
  `user_id` int unsigned NOT NULL DEFAULT '0',
  `head_color` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `params` text COLLATE utf8_unicode_ci NOT NULL,
  `hash` int NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `id` (`photo_id`,`user_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;


DROP TABLE IF EXISTS `city_avatar_face_default`;
CREATE TABLE `city_avatar_face_default` (
  `id` int NOT NULL AUTO_INCREMENT,
  `gender` enum('M','F') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'M',
  `head_color` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `position` int NOT NULL DEFAULT '0',
  `hash` int NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;


DROP TABLE IF EXISTS `city_custom_data`;
CREATE TABLE `city_custom_data` (
  `data_id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `location` tinyint NOT NULL DEFAULT '0',
  `pos_map` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `type` varchar(32) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `uid` bigint NOT NULL DEFAULT '0',
  `counter` bigint unsigned NOT NULL DEFAULT '0',
  `data` longtext COLLATE utf8_unicode_ci NOT NULL,
  `created` bigint unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`data_id`),
  UNIQUE KEY `type_data` (`location`,`pos_map`,`type`),
  KEY `location` (`location`),
  KEY `pos_map` (`pos_map`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;


DROP TABLE IF EXISTS `city_invite`;
CREATE TABLE `city_invite` (
  `id` int NOT NULL AUTO_INCREMENT,
  `from_user` int NOT NULL DEFAULT '0',
  `to_user` int NOT NULL DEFAULT '0',
  `data` text COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;


DROP TABLE IF EXISTS `city_link`;
CREATE TABLE `city_link` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `hash` varchar(32) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `location` tinyint unsigned NOT NULL DEFAULT '0',
  `pos_map` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `platform` smallint NOT NULL DEFAULT '0',
  `water_loc` smallint NOT NULL DEFAULT '0',
  `created` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `temp` tinyint(1) NOT NULL DEFAULT '0',
  `system` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `location` (`location`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;


DROP TABLE IF EXISTS `city_live_streaming`;
CREATE TABLE `city_live_streaming` (
  `id` int NOT NULL AUTO_INCREMENT,
  `user_id` int NOT NULL DEFAULT '0',
  `video_id` int NOT NULL DEFAULT '0',
  `hash` varchar(64) COLLATE utf8_unicode_ci NOT NULL,
  `date_start` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `date_stop` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `status` int NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `user_id` (`user_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;


DROP TABLE IF EXISTS `city_moving`;
CREATE TABLE `city_moving` (
  `step` bigint unsigned NOT NULL AUTO_INCREMENT,
  `id` bigint unsigned NOT NULL DEFAULT '0',
  `location` tinyint NOT NULL DEFAULT '0',
  `move` longtext COLLATE utf8_unicode_ci NOT NULL,
  `created` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`step`),
  KEY `id` (`id`,`location`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;


DROP TABLE IF EXISTS `city_msg`;
CREATE TABLE `city_msg` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `from_user` int unsigned NOT NULL DEFAULT '0',
  `to_user` int unsigned NOT NULL DEFAULT '0',
  `room` tinyint NOT NULL DEFAULT '0',
  `send` bigint unsigned NOT NULL DEFAULT '0',
  `born` timestamp NULL DEFAULT '0000-00-00 00:00:00',
  `msg` text COLLATE utf8_unicode_ci NOT NULL,
  `is_new` tinyint(1) NOT NULL DEFAULT '1',
  `from_user_deleted` tinyint(1) NOT NULL DEFAULT '0',
  `to_user_deleted` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `to` (`to_user`),
  KEY `from` (`from_user`),
  KEY `born` (`born`),
  KEY `is_new` (`is_new`),
  KEY `to_user_from_user_from_user_deleted_id` (`to_user`,`from_user`,`from_user_deleted`,`id`),
  KEY `to_user_from_user_to_user_deleted_id` (`to_user`,`from_user`,`to_user_deleted`,`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;


DROP TABLE IF EXISTS `city_msg_backup`;
CREATE TABLE `city_msg_backup` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `from_user` int unsigned NOT NULL DEFAULT '0',
  `to_user` int unsigned NOT NULL DEFAULT '0',
  `room` tinyint NOT NULL DEFAULT '0',
  `born` timestamp NULL DEFAULT '0000-00-00 00:00:00',
  `msg` text COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`id`),
  KEY `to` (`to_user`),
  KEY `from` (`from_user`),
  KEY `born` (`born`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;


DROP TABLE IF EXISTS `city_open`;
CREATE TABLE `city_open` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `from_user` int unsigned NOT NULL DEFAULT '0',
  `to_user` int unsigned NOT NULL DEFAULT '0',
  `last_visit` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `room` tinyint NOT NULL DEFAULT '0',
  `mid` int unsigned NOT NULL DEFAULT '0',
  `z` int unsigned NOT NULL DEFAULT '0',
  `session` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `session_date` datetime NOT NULL,
  `last_writing` int NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `from` (`from_user`),
  KEY `to` (`to_user`),
  KEY `mid` (`mid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;


DROP TABLE IF EXISTS `city_photo`;
CREATE TABLE `city_photo` (
  `photo_id` int unsigned NOT NULL AUTO_INCREMENT,
  `user_id` int unsigned NOT NULL DEFAULT '0',
  `group_id` bigint NOT NULL DEFAULT '0',
  `photo_name` varchar(25) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `description` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `visible` enum('Y','N','P','Nudity') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'N',
  `default` enum('Y','N') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'N',
  `private` enum('Y','N') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'N',
  `votes` int NOT NULL DEFAULT '0',
  `rating` int NOT NULL DEFAULT '0',
  `average` float NOT NULL DEFAULT '0',
  `wall_id` bigint NOT NULL,
  `published` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `users_reports` text COLLATE utf8_unicode_ci NOT NULL,
  `hash` varchar(12) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  PRIMARY KEY (`photo_id`),
  KEY `user_id_2` (`user_id`,`visible`),
  KEY `photo_id` (`photo_id`,`user_id`),
  KEY `visible` (`visible`),
  KEY `user_id` (`user_id`),
  KEY `wall_id` (`wall_id`),
  KEY `private` (`private`),
  KEY `default` (`default`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;


DROP TABLE IF EXISTS `city_reject`;
CREATE TABLE `city_reject` (
  `id` int NOT NULL AUTO_INCREMENT,
  `from_user` int NOT NULL DEFAULT '0',
  `to_user` int NOT NULL DEFAULT '0',
  `data` text COLLATE utf8_unicode_ci NOT NULL,
  `go` char(1) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;


DROP TABLE IF EXISTS `city_rooms`;
CREATE TABLE `city_rooms` (
  `id` int NOT NULL AUTO_INCREMENT,
  `name` varchar(225) COLLATE utf8_unicode_ci NOT NULL,
  `status` tinyint(1) NOT NULL DEFAULT '1',
  `video` tinyint(1) NOT NULL DEFAULT '0',
  `position` int NOT NULL,
  `game` tinyint(1) NOT NULL DEFAULT '0',
  `hide` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;


DROP TABLE IF EXISTS `city_temp`;
CREATE TABLE `city_temp` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `params` longtext COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;


DROP TABLE IF EXISTS `city_users`;
CREATE TABLE `city_users` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `user_id` bigint unsigned NOT NULL DEFAULT '0',
  `type` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `face` int NOT NULL DEFAULT '1',
  `default` tinyint(1) NOT NULL DEFAULT '1',
  `cap` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `last_visit` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `demo_last_step` bigint NOT NULL DEFAULT '0',
  `sound` tinyint(1) NOT NULL DEFAULT '1',
  `gender` enum('M','F','') COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `city` varchar(100) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `hash` varchar(32) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `invite` tinyint(1) NOT NULL DEFAULT '0',
  `demo` tinyint(1) NOT NULL DEFAULT '0',
  `not_open_chats` text COLLATE utf8_unicode_ci NOT NULL,
  `manager` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `user_id` (`user_id`),
  KEY `last_visit` (`last_visit`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;


DROP TABLE IF EXISTS `city_users_in_rooms`;
CREATE TABLE `city_users_in_rooms` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `cuid` bigint unsigned NOT NULL DEFAULT '0',
  `location` tinyint unsigned NOT NULL DEFAULT '0',
  `pos` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `pos_map` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `platform` smallint NOT NULL DEFAULT '0',
  `water_loc` smallint NOT NULL DEFAULT '0',
  `house` smallint NOT NULL DEFAULT '0',
  `rot` smallint NOT NULL DEFAULT '0',
  `floor` smallint NOT NULL DEFAULT '1',
  `last_visit` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `demo_last_step` bigint NOT NULL DEFAULT '0',
  `manager` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `luid` (`cuid`,`location`,`pos_map`,`house`),
  KEY `cuid` (`cuid`),
  KEY `location` (`location`),
  KEY `pos_map` (`pos_map`),
  KEY `last_visit` (`last_visit`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;


DROP TABLE IF EXISTS `col_order`;
CREATE TABLE `col_order` (
  `id` int NOT NULL AUTO_INCREMENT,
  `name` varchar(225) COLLATE utf8_unicode_ci NOT NULL,
  `section` varchar(40) COLLATE utf8_unicode_ci NOT NULL,
  `status` enum('Y','N') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'Y',
  `additional` tinyint(1) NOT NULL DEFAULT '0',
  `position` int NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;


DROP TABLE IF EXISTS `config`;
CREATE TABLE `config` (
  `id` int NOT NULL AUTO_INCREMENT,
  `module` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `option` text COLLATE utf8_unicode_ci NOT NULL,
  `value` text COLLATE utf8_unicode_ci NOT NULL,
  `show_in_admin` tinyint(1) NOT NULL,
  `type` enum('text','checkbox','selectbox','password','separator','radio','textarea','section','color','file','label','select_multiple','number') COLLATE utf8_unicode_ci NOT NULL,
  `options` text COLLATE utf8_unicode_ci NOT NULL,
  `position` int NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;


DROP TABLE IF EXISTS `const_horoscope`;
CREATE TABLE `const_horoscope` (
  `id` int NOT NULL AUTO_INCREMENT,
  `title` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;


DROP TABLE IF EXISTS `const_i_am_here_to`;
CREATE TABLE `const_i_am_here_to` (
  `id` int NOT NULL AUTO_INCREMENT,
  `title` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;


DROP TABLE IF EXISTS `const_interests`;
CREATE TABLE `const_interests` (
  `id` int NOT NULL AUTO_INCREMENT,
  `title` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;


DROP TABLE IF EXISTS `const_lms_user_type`;
CREATE TABLE `const_lms_user_type` (
  `id` int NOT NULL AUTO_INCREMENT,
  `title` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `free` enum('none','super') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'none',
  `default` tinyint(1) NOT NULL DEFAULT '0',
  `type` enum('teacher','student') COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;


DROP TABLE IF EXISTS `const_looking`;
CREATE TABLE `const_looking` (
  `id` int NOT NULL AUTO_INCREMENT,
  `title` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `search` int NOT NULL DEFAULT '0',
  `gender` enum('B','M','F') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'B',
  `free` enum('none','silver','gold','platinum') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'none',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;


DROP TABLE IF EXISTS `const_orientation`;
CREATE TABLE `const_orientation` (
  `id` int NOT NULL AUTO_INCREMENT,
  `title` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `search` int NOT NULL DEFAULT '0',
  `gender` enum('M','F') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'M',
  `free` enum('none','silver','gold','platinum','super') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'none',
  `default` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;


DROP TABLE IF EXISTS `const_relation`;
CREATE TABLE `const_relation` (
  `id` int NOT NULL AUTO_INCREMENT,
  `title` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;


DROP TABLE IF EXISTS `contact`;
CREATE TABLE `contact` (
  `id` int NOT NULL AUTO_INCREMENT,
  `user_id` int NOT NULL DEFAULT '0',
  `name` varchar(25) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `mail` varchar(100) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `comment` text COLLATE utf8_unicode_ci NOT NULL,
  `date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;


DROP TABLE IF EXISTS `contact_partner`;
CREATE TABLE `contact_partner` (
  `id` int NOT NULL AUTO_INCREMENT,
  `name` varchar(25) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `company` varchar(100) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `real_name` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `phone` varchar(100) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `mail` varchar(100) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `comment` text COLLATE utf8_unicode_ci NOT NULL,
  `date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;


DROP TABLE IF EXISTS `email`;
CREATE TABLE `email` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `mail` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  PRIMARY KEY (`id`),
  UNIQUE KEY `mail` (`mail`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;


DROP TABLE IF EXISTS `email_auto`;
CREATE TABLE `email_auto` (
  `id` int NOT NULL AUTO_INCREMENT,
  `note` varchar(100) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `subject` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `header` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `button` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `text` text COLLATE utf8_unicode_ci NOT NULL,
  `lang` varchar(100) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  PRIMARY KEY (`id`),
  UNIQUE KEY `note_lang` (`note`,`lang`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;


DROP TABLE IF EXISTS `email_auto_settings`;
CREATE TABLE `email_auto_settings` (
  `id` int NOT NULL AUTO_INCREMENT,
  `option` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `value` text COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `option` (`option`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;


DROP TABLE IF EXISTS `email_queue`;
CREATE TABLE `email_queue` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `from` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `to` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `subject` text COLLATE utf8_unicode_ci NOT NULL,
  `message` text COLLATE utf8_unicode_ci NOT NULL,
  `added_at` datetime NOT NULL,
  `sending_time` int NOT NULL,
  PRIMARY KEY (`id`),
  KEY `added_at` (`added_at`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;


DROP TABLE IF EXISTS `encounters`;
CREATE TABLE `encounters` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `user_from` int NOT NULL DEFAULT '0',
  `user_to` int NOT NULL DEFAULT '0',
  `from_reply` enum('P','Y','N','M') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'P',
  `to_reply` enum('P','Y','N','M') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'P',
  `new` char(1) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'Y',
  `new_to` char(1) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'Y',
  PRIMARY KEY (`id`),
  KEY `user_from` (`user_from`),
  KEY `user_to` (`user_to`),
  KEY `new` (`new`),
  KEY `new_to` (`new_to`),
  KEY `user_to_from_reply_to_reply_id` (`user_to`,`from_reply`,`to_reply`,`id`),
  KEY `user_from_id` (`user_from`,`id`),
  KEY `user_to_id` (`user_to`,`id`),
  KEY `user_from_from_reply_to_reply_id` (`user_from`,`from_reply`,`to_reply`,`id`),
  KEY `user_from_from_reply_id` (`user_from`,`from_reply`,`id`),
  KEY `user_to_to_reply_id` (`user_to`,`to_reply`,`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;


DROP TABLE IF EXISTS `events_category`;
CREATE TABLE `events_category` (
  `category_id` bigint NOT NULL AUTO_INCREMENT,
  `category_title` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `position` int NOT NULL,
  PRIMARY KEY (`category_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;


DROP TABLE IF EXISTS `events_event`;
CREATE TABLE `events_event` (
  `event_id` bigint NOT NULL AUTO_INCREMENT,
  `user_id` int NOT NULL,
  `user_to` int NOT NULL DEFAULT '0',
  `event_private` tinyint NOT NULL DEFAULT '0',
  `category_id` bigint NOT NULL,
  `event_title` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `event_description` text COLLATE utf8_unicode_ci,
  `city_id` bigint NOT NULL,
  `event_datetime` datetime NOT NULL,
  `event_address` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `event_place` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `event_site` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `event_phone` varchar(64) COLLATE utf8_unicode_ci DEFAULT NULL,
  `event_n_comments` bigint NOT NULL DEFAULT '0',
  `event_n_guests` bigint NOT NULL DEFAULT '0',
  `event_has_images` tinyint NOT NULL DEFAULT '0',
  `created_at` datetime NOT NULL,
  `updated_at` datetime NOT NULL,
  `done_user` int NOT NULL DEFAULT '0',
  `done_new` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`event_id`),
  KEY `category_id` (`category_id`),
  KEY `user_id` (`user_id`),
  KEY `user_to` (`user_to`),
  KEY `event_private` (`event_private`),
  KEY `city_id` (`city_id`),
  KEY `event_datetime` (`event_datetime`),
  KEY `event_n_comments` (`event_n_comments`),
  KEY `event_n_guests` (`event_n_guests`),
  KEY `event_has_images` (`event_has_images`),
  KEY `done_user` (`done_user`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;


DROP TABLE IF EXISTS `events_event_comment`;
CREATE TABLE `events_event_comment` (
  `comment_id` bigint NOT NULL AUTO_INCREMENT,
  `event_id` bigint NOT NULL DEFAULT '0',
  `user_id` bigint NOT NULL DEFAULT '0',
  `comment_text` text COLLATE utf8_unicode_ci NOT NULL,
  `created_at` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`comment_id`),
  KEY `event_id` (`event_id`),
  KEY `created_at` (`created_at`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;


DROP TABLE IF EXISTS `events_event_comment_comment`;
CREATE TABLE `events_event_comment_comment` (
  `comment_id` bigint NOT NULL AUTO_INCREMENT,
  `parent_comment_id` bigint NOT NULL DEFAULT '0',
  `user_id` bigint NOT NULL DEFAULT '0',
  `comment_text` text COLLATE utf8_unicode_ci NOT NULL,
  `created_at` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`comment_id`),
  KEY `parent_comment_id` (`parent_comment_id`),
  KEY `created_at` (`created_at`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;


DROP TABLE IF EXISTS `events_event_guest`;
CREATE TABLE `events_event_guest` (
  `guest_id` bigint NOT NULL AUTO_INCREMENT,
  `event_id` bigint NOT NULL DEFAULT '0',
  `user_id` bigint NOT NULL DEFAULT '0',
  `guest_n_friends` bigint NOT NULL DEFAULT '0',
  `created_at` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`guest_id`),
  KEY `event_id` (`event_id`),
  KEY `created_at` (`created_at`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;


DROP TABLE IF EXISTS `events_event_image`;
CREATE TABLE `events_event_image` (
  `image_id` bigint NOT NULL AUTO_INCREMENT,
  `event_id` bigint NOT NULL DEFAULT '0',
  `user_id` bigint NOT NULL DEFAULT '0',
  `created_at` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`image_id`),
  KEY `event_id` (`event_id`),
  KEY `created_at` (`created_at`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;


DROP TABLE IF EXISTS `events_setting`;
CREATE TABLE `events_setting` (
  `setting_id` bigint NOT NULL AUTO_INCREMENT,
  `user_id` bigint NOT NULL,
  `category_id` bigint NOT NULL DEFAULT '0',
  PRIMARY KEY (`setting_id`),
  KEY `user_id` (`user_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;


DROP TABLE IF EXISTS `flashchat_messages`;
CREATE TABLE `flashchat_messages` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `time` int NOT NULL,
  `status` enum('system','mess') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'mess',
  `msgtext` text COLLATE utf8_unicode_ci NOT NULL,
  `user` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `room` int NOT NULL DEFAULT '0',
  `user_id` int NOT NULL DEFAULT '0',
  `send` bigint unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;


DROP TABLE IF EXISTS `flashchat_rooms`;
CREATE TABLE `flashchat_rooms` (
  `id` int NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `status` tinyint(1) NOT NULL DEFAULT '1',
  `position` int NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;


DROP TABLE IF EXISTS `flashchat_users`;
CREATE TABLE `flashchat_users` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `login` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `mess_color` varchar(6) COLLATE utf8_unicode_ci NOT NULL DEFAULT '0',
  `time_out` int NOT NULL,
  `status` int NOT NULL DEFAULT '0',
  `sys_color` varchar(6) COLLATE utf8_unicode_ci NOT NULL DEFAULT '000099',
  `room` int NOT NULL,
  `gender` enum('m','f') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'm',
  `user_id` int NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `time_out` (`time_out`),
  KEY `user_id` (`user_id`),
  KEY `room_time_out` (`room`,`time_out`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;


DROP TABLE IF EXISTS `forum_category`;
CREATE TABLE `forum_category` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `title` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `sort_rank` bigint NOT NULL DEFAULT '0',
  `created_at` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `updated_at` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`id`),
  KEY `sort_rank` (`sort_rank`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;


DROP TABLE IF EXISTS `forum_forum`;
CREATE TABLE `forum_forum` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `category_id` bigint NOT NULL DEFAULT '0',
  `parent_forum_id` bigint NOT NULL DEFAULT '0',
  `title` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `description` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `n_topics` bigint NOT NULL DEFAULT '0',
  `n_messages` bigint NOT NULL DEFAULT '0',
  `sort_rank` bigint NOT NULL DEFAULT '0',
  `created_at` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `updated_at` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`id`),
  KEY `category_id` (`category_id`,`sort_rank`),
  KEY `parent_forum_id` (`parent_forum_id`),
  KEY `updated_at` (`updated_at`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;


DROP TABLE IF EXISTS `forum_message`;
CREATE TABLE `forum_message` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `topic_id` bigint NOT NULL DEFAULT '0',
  `user_id` bigint NOT NULL DEFAULT '0',
  `title` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `message` text COLLATE utf8_unicode_ci,
  `created_at` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `updated_at` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`id`),
  KEY `updated_at` (`updated_at`),
  KEY `topic_id` (`topic_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;


DROP TABLE IF EXISTS `forum_read_marker`;
CREATE TABLE `forum_read_marker` (
  `id` bigint NOT NULL DEFAULT '0',
  `user_id` bigint NOT NULL DEFAULT '0',
  `forum_id` bigint NOT NULL DEFAULT '0',
  `topics_read` text COLLATE utf8_unicode_ci,
  `read_until` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `created_at` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `updated_at` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`id`),
  KEY `user_id` (`user_id`,`forum_id`,`read_until`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;


DROP TABLE IF EXISTS `forum_setting`;
CREATE TABLE `forum_setting` (
  `setting_id` bigint NOT NULL AUTO_INCREMENT,
  `user_id` bigint NOT NULL,
  `sort_by` enum('last_post','thread','thread_starter','replies','views') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'last_post',
  `sort_by_dir` enum('asc','desc') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'desc',
  PRIMARY KEY (`setting_id`),
  KEY `user_id` (`user_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;


DROP TABLE IF EXISTS `forum_topic`;
CREATE TABLE `forum_topic` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `forum_id` bigint NOT NULL DEFAULT '0',
  `user_id` bigint NOT NULL DEFAULT '0',
  `title` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `message` text COLLATE utf8_unicode_ci,
  `n_messages` bigint NOT NULL DEFAULT '0',
  `n_views` bigint NOT NULL DEFAULT '0',
  `created_at` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `updated_at` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`id`),
  KEY `forum_id` (`forum_id`,`user_id`),
  KEY `updated_at` (`updated_at`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;


DROP TABLE IF EXISTS `friends`;
CREATE TABLE `friends` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `user_id` int NOT NULL DEFAULT '0',
  `fr_user_id` int NOT NULL DEFAULT '0',
  `bookmark` varchar(10) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `visible_bookmark` varchar(10) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `DATA` date NOT NULL DEFAULT '0000-00-00',
  `featured` varchar(10) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  PRIMARY KEY (`id`),
  KEY `user_id` (`user_id`),
  KEY `fr_user_id` (`fr_user_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;


DROP TABLE IF EXISTS `friends_requests`;
CREATE TABLE `friends_requests` (
  `user_id` bigint NOT NULL DEFAULT '0',
  `friend_id` bigint NOT NULL DEFAULT '0',
  `message` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `accepted` tinyint(1) NOT NULL DEFAULT '0',
  `featured` bigint NOT NULL DEFAULT '0',
  `friend_featured` bigint NOT NULL DEFAULT '0',
  `created_at` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `activity` bigint NOT NULL DEFAULT '0',
  UNIQUE KEY `user_id` (`user_id`,`friend_id`),
  KEY `accepted` (`accepted`),
  KEY `featured` (`featured`),
  KEY `friend_featured` (`friend_featured`),
  KEY `user_id_2` (`user_id`),
  KEY `friend_id` (`friend_id`),
  KEY `accepted_user_id_friend_id` (`accepted`,`user_id`,`friend_id`),
  KEY `friend_id_accepted` (`friend_id`,`accepted`),
  KEY `user_id_accepted` (`user_id`,`accepted`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;


DROP TABLE IF EXISTS `gallery_albums`;
CREATE TABLE `gallery_albums` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `user_id` int unsigned NOT NULL DEFAULT '0',
  `parentid` int unsigned DEFAULT NULL,
  `folder` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `title` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `desc` text COLLATE utf8_unicode_ci,
  `date` datetime DEFAULT NULL,
  `place` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `show` int unsigned NOT NULL DEFAULT '1',
  `thumb` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `sort_type` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL,
  `sort_order` int unsigned DEFAULT NULL,
  `views` int unsigned DEFAULT '0',
  `access` enum('public','friends','private') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'public',
  PRIMARY KEY (`id`),
  KEY `folder` (`folder`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;


DROP TABLE IF EXISTS `gallery_comments`;
CREATE TABLE `gallery_comments` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `user_id` int NOT NULL DEFAULT '0',
  `imageid` int unsigned NOT NULL DEFAULT '0',
  `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `email` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `website` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `date` datetime DEFAULT NULL,
  `comment` text COLLATE utf8_unicode_ci NOT NULL,
  `inmoderation` int unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `imageid` (`imageid`),
  KEY `date` (`date`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;


DROP TABLE IF EXISTS `gallery_images`;
CREATE TABLE `gallery_images` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `user_id` int NOT NULL DEFAULT '0',
  `albumid` int unsigned NOT NULL DEFAULT '0',
  `filename` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `title` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `desc` text COLLATE utf8_unicode_ci,
  `commentson` int NOT NULL DEFAULT '1',
  `show` int NOT NULL DEFAULT '1',
  `sort_order` int unsigned DEFAULT NULL,
  `height` int unsigned DEFAULT NULL,
  `width` int unsigned DEFAULT NULL,
  `datetime` datetime NOT NULL,
  PRIMARY KEY (`id`),
  KEY `filename` (`filename`,`albumid`),
  KEY `albumid` (`albumid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;


DROP TABLE IF EXISTS `game_chess`;
CREATE TABLE `game_chess` (
  `id` int NOT NULL AUTO_INCREMENT,
  `login` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `enemy` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `ingame` enum('yes','no') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'no',
  `time_in` bigint DEFAULT NULL,
  `active` enum('yes','no') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'no',
  `hod_data` text COLLATE utf8_unicode_ci,
  `now_hod` enum('login','enemy') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'login',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;


DROP TABLE IF EXISTS `game_invite`;
CREATE TABLE `game_invite` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `from_user` int unsigned NOT NULL DEFAULT '0',
  `to_user` int unsigned NOT NULL DEFAULT '0',
  `game` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;


DROP TABLE IF EXISTS `game_morboy`;
CREATE TABLE `game_morboy` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `login` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `enemy` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `nowX` smallint DEFAULT NULL,
  `nowY` smallint DEFAULT NULL,
  `ingame` enum('yes','no') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'no',
  `time_in` bigint DEFAULT NULL,
  `active` enum('yes','no') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'no',
  `massiv` text COLLATE utf8_unicode_ci,
  `popal` varchar(5) COLLATE utf8_unicode_ci DEFAULT NULL,
  `shodil` enum('y','n') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'n',
  `pokazal` enum('y','n') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'n',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;


DROP TABLE IF EXISTS `game_reject`;
CREATE TABLE `game_reject` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `from_user` int unsigned NOT NULL DEFAULT '0',
  `to_user` int unsigned NOT NULL DEFAULT '0',
  `game` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `go` enum('Y','N') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'Y',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;


DROP TABLE IF EXISTS `game_shashki`;
CREATE TABLE `game_shashki` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `login` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `enemy` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `nowX` smallint DEFAULT NULL,
  `nowY` smallint DEFAULT NULL,
  `ingame` enum('yes','no') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'no',
  `time_in` bigint DEFAULT NULL,
  `active` enum('yes','no') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'no',
  `srubil` text COLLATE utf8_unicode_ci,
  `num_shashka` smallint DEFAULT NULL,
  `damka` enum('true','false') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'false',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;


DROP TABLE IF EXISTS `gifts`;
CREATE TABLE `gifts` (
  `id` int NOT NULL AUTO_INCREMENT,
  `sent` int NOT NULL DEFAULT '0',
  `credits` int NOT NULL DEFAULT '0',
  `position` int NOT NULL DEFAULT '0',
  `hash` int NOT NULL DEFAULT '0',
  `set` tinyint NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;


DROP TABLE IF EXISTS `gifts_set`;
CREATE TABLE `gifts_set` (
  `id` int NOT NULL AUTO_INCREMENT,
  `alias` varchar(30) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `active` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;


DROP TABLE IF EXISTS `groups_category`;
CREATE TABLE `groups_category` (
  `category_id` bigint NOT NULL AUTO_INCREMENT,
  `category_title` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `position` int NOT NULL,
  PRIMARY KEY (`category_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;


DROP TABLE IF EXISTS `groups_forum`;
CREATE TABLE `groups_forum` (
  `forum_id` bigint NOT NULL AUTO_INCREMENT,
  `group_id` bigint NOT NULL,
  `user_id` bigint NOT NULL,
  `forum_title` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `forum_description` text COLLATE utf8_unicode_ci,
  `forum_n_comments` bigint NOT NULL DEFAULT '0',
  `forum_n_views` bigint NOT NULL DEFAULT '0',
  `created_at` datetime NOT NULL,
  `updated_at` datetime NOT NULL,
  PRIMARY KEY (`forum_id`),
  KEY `group_id` (`group_id`),
  KEY `user_id` (`user_id`),
  KEY `forum_n_comments` (`forum_n_comments`),
  KEY `forum_n_views` (`forum_n_views`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;


DROP TABLE IF EXISTS `groups_forum_comment`;
CREATE TABLE `groups_forum_comment` (
  `comment_id` bigint NOT NULL AUTO_INCREMENT,
  `forum_id` bigint NOT NULL DEFAULT '0',
  `user_id` bigint NOT NULL DEFAULT '0',
  `comment_text` text COLLATE utf8_unicode_ci NOT NULL,
  `created_at` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`comment_id`),
  KEY `forum_id` (`forum_id`),
  KEY `created_at` (`created_at`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;


DROP TABLE IF EXISTS `groups_forum_comment_comment`;
CREATE TABLE `groups_forum_comment_comment` (
  `comment_id` bigint NOT NULL AUTO_INCREMENT,
  `parent_comment_id` bigint NOT NULL DEFAULT '0',
  `user_id` bigint NOT NULL DEFAULT '0',
  `comment_text` text COLLATE utf8_unicode_ci NOT NULL,
  `created_at` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`comment_id`),
  KEY `parent_comment_id` (`parent_comment_id`),
  KEY `created_at` (`created_at`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;


DROP TABLE IF EXISTS `groups_group`;
CREATE TABLE `groups_group` (
  `group_id` bigint NOT NULL AUTO_INCREMENT,
  `user_id` bigint NOT NULL,
  `group_private` tinyint NOT NULL DEFAULT '0',
  `category_id` bigint NOT NULL,
  `group_title` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `group_description` text COLLATE utf8_unicode_ci,
  `group_n_posts` bigint NOT NULL DEFAULT '0',
  `group_n_comments` bigint NOT NULL DEFAULT '0',
  `group_n_members` bigint NOT NULL DEFAULT '0',
  `group_has_images` tinyint NOT NULL DEFAULT '0',
  `created_at` datetime NOT NULL,
  `updated_at` datetime NOT NULL,
  PRIMARY KEY (`group_id`),
  KEY `category_id` (`category_id`),
  KEY `user_id` (`user_id`),
  KEY `group_private` (`group_private`),
  KEY `group_n_posts` (`group_n_posts`),
  KEY `group_n_comments` (`group_n_comments`),
  KEY `group_n_members` (`group_n_members`),
  KEY `group_has_images` (`group_has_images`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;


DROP TABLE IF EXISTS `groups_group_comment`;
CREATE TABLE `groups_group_comment` (
  `comment_id` bigint NOT NULL AUTO_INCREMENT,
  `group_id` bigint NOT NULL DEFAULT '0',
  `user_id` bigint NOT NULL DEFAULT '0',
  `comment_text` text COLLATE utf8_unicode_ci NOT NULL,
  `created_at` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`comment_id`),
  KEY `group_id` (`group_id`),
  KEY `created_at` (`created_at`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;


DROP TABLE IF EXISTS `groups_group_comment_comment`;
CREATE TABLE `groups_group_comment_comment` (
  `comment_id` bigint NOT NULL AUTO_INCREMENT,
  `parent_comment_id` bigint NOT NULL DEFAULT '0',
  `user_id` bigint NOT NULL DEFAULT '0',
  `comment_text` text COLLATE utf8_unicode_ci NOT NULL,
  `created_at` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`comment_id`),
  KEY `parent_comment_id` (`parent_comment_id`),
  KEY `created_at` (`created_at`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;


DROP TABLE IF EXISTS `groups_group_image`;
CREATE TABLE `groups_group_image` (
  `image_id` bigint NOT NULL AUTO_INCREMENT,
  `group_id` bigint NOT NULL DEFAULT '0',
  `user_id` bigint NOT NULL DEFAULT '0',
  `created_at` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`image_id`),
  KEY `group_id` (`group_id`),
  KEY `created_at` (`created_at`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;


DROP TABLE IF EXISTS `groups_group_member`;
CREATE TABLE `groups_group_member` (
  `member_id` bigint NOT NULL AUTO_INCREMENT,
  `group_id` bigint NOT NULL DEFAULT '0',
  `user_id` bigint NOT NULL DEFAULT '0',
  `created_at` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`member_id`),
  KEY `group_id` (`group_id`),
  KEY `created_at` (`created_at`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;


DROP TABLE IF EXISTS `groups_invite`;
CREATE TABLE `groups_invite` (
  `invite_id` bigint NOT NULL AUTO_INCREMENT,
  `group_id` bigint NOT NULL DEFAULT '0',
  `user_id` bigint NOT NULL DEFAULT '0',
  `invite_key` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `created_at` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`invite_id`),
  KEY `group_id` (`group_id`),
  KEY `user_id` (`user_id`),
  KEY `invite_key` (`invite_key`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;


DROP TABLE IF EXISTS `groups_setting`;
CREATE TABLE `groups_setting` (
  `setting_id` bigint NOT NULL AUTO_INCREMENT,
  `user_id` bigint NOT NULL,
  `category_id` bigint NOT NULL DEFAULT '0',
  PRIMARY KEY (`setting_id`),
  KEY `user_id` (`user_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;


DROP TABLE IF EXISTS `groups_social`;
CREATE TABLE `groups_social` (
  `group_id` bigint NOT NULL AUTO_INCREMENT,
  `user_id` int NOT NULL,
  `name_seo` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `page` tinyint(1) NOT NULL DEFAULT '0',
  `private` enum('Y','N') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'N',
  `date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `title` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `description` text COLLATE utf8_unicode_ci,
  `country_id` int unsigned NOT NULL DEFAULT '0',
  `state_id` int unsigned NOT NULL DEFAULT '0',
  `city_id` int unsigned NOT NULL DEFAULT '0',
  `country` varchar(100) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `state` varchar(100) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `city` varchar(100) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `count_posts` bigint NOT NULL DEFAULT '0',
  `count_comments` bigint NOT NULL DEFAULT '0',
  `count_members` bigint NOT NULL DEFAULT '0',
  `users_reports` text COLLATE utf8_unicode_ci NOT NULL,
  `ban_global` tinyint(1) NOT NULL DEFAULT '0',
  `profile_bg_cover` tinyint(1) NOT NULL DEFAULT '0',
  `profile_bg_cover_param` varchar(510) COLLATE utf8_unicode_ci DEFAULT '',
  PRIMARY KEY (`group_id`),
  UNIQUE KEY `name_seo` (`name_seo`),
  KEY `user_id` (`user_id`),
  KEY `page` (`page`),
  KEY `private` (`private`),
  KEY `date` (`date`),
  KEY `count_posts` (`count_posts`),
  KEY `count_comments` (`count_comments`),
  KEY `count_members` (`count_members`),
  KEY `country_id` (`country_id`),
  KEY `state_id` (`state_id`),
  KEY `city_id` (`city_id`),
  KEY `ban_global` (`ban_global`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;


DROP TABLE IF EXISTS `groups_social_subscribers`;
CREATE TABLE `groups_social_subscribers` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `user_id` int NOT NULL DEFAULT '0',
  `group_id` bigint NOT NULL DEFAULT '0',
  `group_user_id` int NOT NULL DEFAULT '0',
  `group_private` enum('Y','N') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'N',
  `page` tinyint(1) NOT NULL DEFAULT '0',
  `accepted` tinyint(1) NOT NULL DEFAULT '0',
  `created_at` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `approve_at` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `is_new` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `user_id` (`user_id`,`group_id`),
  KEY `accepted` (`accepted`),
  KEY `group_id` (`group_id`),
  KEY `accepted_user_id_group_id` (`accepted`,`user_id`,`group_id`),
  KEY `group_id_accepted` (`group_id`,`accepted`),
  KEY `user_id_accepted` (`user_id`,`accepted`),
  KEY `group_user_id` (`group_user_id`),
  KEY `group_private` (`group_private`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;


DROP TABLE IF EXISTS `groups_social_tags`;
CREATE TABLE `groups_social_tags` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `tag` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `counter` int NOT NULL,
  PRIMARY KEY (`id`),
  KEY `tag` (`tag`),
  KEY `counter` (`counter`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;


DROP TABLE IF EXISTS `groups_social_tags_relations`;
CREATE TABLE `groups_social_tags_relations` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `group_id` int NOT NULL,
  `tag_id` bigint NOT NULL,
  PRIMARY KEY (`id`),
  KEY `group_id` (`group_id`),
  KEY `tag_id` (`tag_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;


DROP TABLE IF EXISTS `groups_user_block_list`;
CREATE TABLE `groups_user_block_list` (
  `id` int NOT NULL AUTO_INCREMENT,
  `group_id` bigint NOT NULL DEFAULT '0',
  `group_user_id` int NOT NULL DEFAULT '0',
  `user_id` int NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `group_id` (`group_id`,`user_id`),
  KEY `user_id_group_id` (`group_id`,`group_user_id`,`user_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;


DROP TABLE IF EXISTS `help_answer`;
CREATE TABLE `help_answer` (
  `id` int NOT NULL AUTO_INCREMENT,
  `topic_id` int NOT NULL DEFAULT '0',
  `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `text` text COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`id`),
  KEY `topic_id` (`topic_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;


DROP TABLE IF EXISTS `help_topic`;
CREATE TABLE `help_topic` (
  `id` int NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `lang` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;


DROP TABLE IF EXISTS `im_audio_message`;
CREATE TABLE `im_audio_message` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `user_id` bigint NOT NULL,
  `hash` varchar(32) COLLATE utf8_unicode_ci NOT NULL,
  `date` int NOT NULL,
  `im_msg_id` bigint NOT NULL,
  `wall_comment_id` bigint NOT NULL,
  `photo_comment_id` bigint NOT NULL,
  `video_comment_id` bigint NOT NULL,
  `blog_comment_id` bigint NOT NULL,
  `comment_id` bigint NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;


DROP TABLE IF EXISTS `im_contact_replied`;
CREATE TABLE `im_contact_replied` (
  `user_id` bigint NOT NULL,
  `user_to` bigint NOT NULL,
  `replied` tinyint(1) NOT NULL,
  UNIQUE KEY `user_id` (`user_id`,`user_to`),
  KEY `user_id_replied` (`user_id`,`replied`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;


DROP TABLE IF EXISTS `im_msg`;
CREATE TABLE `im_msg` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `from_user` int unsigned NOT NULL DEFAULT '0',
  `from_group_id` bigint NOT NULL DEFAULT '0',
  `to_user` int unsigned NOT NULL DEFAULT '0',
  `to_group_id` bigint NOT NULL DEFAULT '0',
  `group_id` bigint NOT NULL DEFAULT '0',
  `born` timestamp NULL DEFAULT '0000-00-00 00:00:00',
  `name` varchar(50) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `msg` text COLLATE utf8_unicode_ci NOT NULL,
  `ip` varchar(39) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `is_new` tinyint(1) NOT NULL DEFAULT '1',
  `system` tinyint(1) NOT NULL DEFAULT '0',
  `system_type` tinyint(1) NOT NULL DEFAULT '0',
  `from_user_deleted` tinyint(1) NOT NULL DEFAULT '0',
  `to_user_deleted` tinyint(1) NOT NULL DEFAULT '0',
  `msg_translation` text COLLATE utf8_unicode_ci NOT NULL,
  `send` bigint unsigned NOT NULL DEFAULT '0',
  `audio_message_id` bigint unsigned NOT NULL,
  `msg_hash` varchar(32) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  PRIMARY KEY (`id`),
  KEY `to` (`to_user`),
  KEY `to_group` (`to_group_id`),
  KEY `from` (`from_user`),
  KEY `from_group` (`from_group_id`),
  KEY `born` (`born`),
  KEY `is_new` (`is_new`),
  KEY `to_user_from_user_from_user_deleted_id` (`to_user`,`from_user`,`from_user_deleted`,`id`),
  KEY `to_user_from_user_to_user_deleted_id` (`to_user`,`from_user`,`to_user_deleted`,`id`),
  KEY `to_user_to_user_deleted_from_user_is_new` (`to_user`,`to_user_deleted`,`from_user`,`is_new`),
  KEY `from_user_to_user_is_new` (`from_user`,`to_user`,`is_new`),
  KEY `is_new_to_user_to_user_deleted_id` (`is_new`,`to_user`,`to_user_deleted`,`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;


DROP TABLE IF EXISTS `im_open`;
CREATE TABLE `im_open` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `from_user` int unsigned NOT NULL DEFAULT '0',
  `from_group_id` bigint NOT NULL DEFAULT '0',
  `to_user` int unsigned NOT NULL DEFAULT '0',
  `to_group_id` bigint NOT NULL DEFAULT '0',
  `group_id` bigint NOT NULL DEFAULT '0',
  `mid` int unsigned NOT NULL DEFAULT '0',
  `im_open_visible` enum('Y','N','C') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'C',
  `is_new_msg` tinyint(1) NOT NULL DEFAULT '0',
  `x` int unsigned NOT NULL DEFAULT '0',
  `y` int unsigned NOT NULL DEFAULT '0',
  `z` int unsigned NOT NULL DEFAULT '0',
  `session` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `session_date` datetime NOT NULL,
  `last_writing` int NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `from` (`from_user`,`from_group_id`,`to_user`,`to_group_id`),
  KEY `to` (`to_user`),
  KEY `mid` (`mid`),
  KEY `from_user_z` (`from_user`,`z`),
  KEY `from_user_is_new_msg_z_mid` (`from_user`,`is_new_msg`,`z`,`mid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;


DROP TABLE IF EXISTS `info`;
CREATE TABLE `info` (
  `page` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `title` text COLLATE utf8_unicode_ci NOT NULL,
  `text` longtext COLLATE utf8_unicode_ci NOT NULL,
  `lang` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  UNIQUE KEY `page` (`page`,`lang`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;


DROP TABLE IF EXISTS `interests`;
CREATE TABLE `interests` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `user_id` int NOT NULL,
  `category` int NOT NULL,
  `interest` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `counter` int NOT NULL,
  `lang` varchar(100) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  PRIMARY KEY (`id`),
  KEY `user_id` (`user_id`),
  KEY `category` (`category`),
  KEY `interest` (`interest`),
  KEY `counter` (`counter`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;


DROP TABLE IF EXISTS `invites`;
CREATE TABLE `invites` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `user_id` int NOT NULL,
  `invite_key` varchar(32) COLLATE utf8_unicode_ci NOT NULL,
  `date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;


DROP TABLE IF EXISTS `ip_block`;
CREATE TABLE `ip_block` (
  `id` int NOT NULL AUTO_INCREMENT,
  `ip` varchar(39) COLLATE utf8_unicode_ci NOT NULL,
  `description` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`id`),
  KEY `ip` (`ip`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;


DROP TABLE IF EXISTS `live_streaming`;
CREATE TABLE `live_streaming` (
  `id` int NOT NULL AUTO_INCREMENT,
  `user_id` int NOT NULL DEFAULT '0',
  `video_id` int NOT NULL DEFAULT '0',
  `hash` varchar(64) COLLATE utf8_unicode_ci NOT NULL,
  `date_start` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `date_stop` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `status` int NOT NULL DEFAULT '0',
  `is_upload_photo` tinyint(1) NOT NULL DEFAULT '0',
  `is_upload_video` tinyint(1) NOT NULL DEFAULT '0',
  `count_viewers` int unsigned NOT NULL DEFAULT '0',
  `count_comments` int unsigned NOT NULL DEFAULT '0',
  `count_comments_replies` int unsigned NOT NULL DEFAULT '0',
  `wall_id` bigint NOT NULL DEFAULT '0',
  `demo` tinyint(1) NOT NULL DEFAULT '0',
  `demo_session` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  PRIMARY KEY (`id`),
  KEY `user_id` (`user_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;


DROP TABLE IF EXISTS `live_streaming_viewers`;
CREATE TABLE `live_streaming_viewers` (
  `id` int NOT NULL AUTO_INCREMENT,
  `live_id` int NOT NULL,
  `user_id` int NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `live_data` (`live_id`,`user_id`),
  KEY `live_id` (`live_id`),
  KEY `user_id` (`user_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;


DROP TABLE IF EXISTS `mail_folder`;
CREATE TABLE `mail_folder` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(50) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `user_id` int NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `user_id` (`user_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;


DROP TABLE IF EXISTS `mail_msg`;
CREATE TABLE `mail_msg` (
  `id` int NOT NULL AUTO_INCREMENT,
  `user_id` int NOT NULL DEFAULT '0',
  `user_from` int NOT NULL DEFAULT '0',
  `user_to` int NOT NULL DEFAULT '0',
  `folder` int NOT NULL DEFAULT '1',
  `new` char(1) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'Y',
  `subject` varchar(100) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `text` text COLLATE utf8_unicode_ci NOT NULL,
  `date_sent` int NOT NULL DEFAULT '0',
  `type` enum('plain','postcard') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'plain',
  `sent_id` bigint NOT NULL DEFAULT '0',
  `receiver_read` char(1) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `text_hash` varchar(32) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `system` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `from_user` (`user_from`),
  KEY `to_user` (`user_to`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;


DROP TABLE IF EXISTS `massmail`;
CREATE TABLE `massmail` (
  `id` int NOT NULL AUTO_INCREMENT,
  `subject` text COLLATE utf8_unicode_ci NOT NULL,
  `text` longtext COLLATE utf8_unicode_ci NOT NULL,
  `users` tinyint(1) NOT NULL,
  `other` tinyint(1) NOT NULL,
  `partners` tinyint(1) NOT NULL,
  `languages` text COLLATE utf8_unicode_ci NOT NULL,
  `last_id` int NOT NULL,
  `status` tinyint(1) NOT NULL,
  `date` int NOT NULL,
  `send_partner` tinyint(1) NOT NULL,
  `users_filter` text COLLATE utf8_unicode_ci NOT NULL,
  `emails_sent` bigint NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;


DROP TABLE IF EXISTS `meta_link_info`;
CREATE TABLE `meta_link_info` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `user_id` bigint NOT NULL DEFAULT '0',
  `links_number` bigint NOT NULL DEFAULT '1',
  `created_at` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `url` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `canonical` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `title` text COLLATE utf8_unicode_ci NOT NULL,
  `description` text COLLATE utf8_unicode_ci NOT NULL,
  `image_id` bigint NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `url` (`url`),
  KEY `created_at` (`created_at`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;


DROP TABLE IF EXISTS `music_category`;
CREATE TABLE `music_category` (
  `category_id` bigint NOT NULL AUTO_INCREMENT,
  `category_title` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `position` int NOT NULL,
  PRIMARY KEY (`category_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;


DROP TABLE IF EXISTS `music_musician`;
CREATE TABLE `music_musician` (
  `musician_id` bigint NOT NULL AUTO_INCREMENT,
  `category_id` bigint NOT NULL DEFAULT '0',
  `user_id` bigint NOT NULL DEFAULT '0',
  `musician_name` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `musician_leader` varchar(64) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `musician_about` text COLLATE utf8_unicode_ci NOT NULL,
  `musician_founded` year NOT NULL DEFAULT '0000',
  `country_id` bigint NOT NULL DEFAULT '0',
  `musician_rating` int NOT NULL DEFAULT '0',
  `musician_n_votes` bigint NOT NULL DEFAULT '0',
  `musician_has_images` tinyint NOT NULL DEFAULT '0',
  `created_at` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `updated_at` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`musician_id`),
  KEY `category_id` (`category_id`),
  KEY `country_id` (`country_id`),
  KEY `user_id` (`user_id`),
  KEY `musician_rating` (`musician_rating`),
  KEY `musician_has_images` (`musician_has_images`),
  KEY `created_at` (`created_at`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;


DROP TABLE IF EXISTS `music_musician_comment`;
CREATE TABLE `music_musician_comment` (
  `comment_id` bigint NOT NULL AUTO_INCREMENT,
  `musician_id` bigint NOT NULL DEFAULT '0',
  `user_id` bigint NOT NULL DEFAULT '0',
  `comment_text` text COLLATE utf8_unicode_ci NOT NULL,
  `created_at` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`comment_id`),
  KEY `musician_id` (`musician_id`),
  KEY `created_at` (`created_at`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;


DROP TABLE IF EXISTS `music_musician_image`;
CREATE TABLE `music_musician_image` (
  `image_id` bigint NOT NULL AUTO_INCREMENT,
  `musician_id` bigint NOT NULL DEFAULT '0',
  `user_id` bigint NOT NULL DEFAULT '0',
  `created_at` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`image_id`),
  KEY `musician_id` (`musician_id`),
  KEY `created_at` (`created_at`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;


DROP TABLE IF EXISTS `music_musician_vote`;
CREATE TABLE `music_musician_vote` (
  `vote_id` bigint NOT NULL AUTO_INCREMENT,
  `musician_id` bigint NOT NULL DEFAULT '0',
  `user_id` bigint NOT NULL DEFAULT '0',
  `vote_rating` int NOT NULL DEFAULT '0',
  `created_at` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `updated_at` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`vote_id`),
  KEY `musician_id` (`musician_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;


DROP TABLE IF EXISTS `music_setting`;
CREATE TABLE `music_setting` (
  `setting_id` bigint NOT NULL AUTO_INCREMENT,
  `user_id` bigint NOT NULL,
  `category_id` bigint NOT NULL DEFAULT '0',
  `setting_limit` enum('all','today','week','month') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'all',
  PRIMARY KEY (`setting_id`),
  KEY `user_id` (`user_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;


DROP TABLE IF EXISTS `music_song`;
CREATE TABLE `music_song` (
  `song_id` bigint NOT NULL AUTO_INCREMENT,
  `musician_id` bigint NOT NULL DEFAULT '0',
  `user_id` bigint NOT NULL DEFAULT '0',
  `group_id` bigint NOT NULL DEFAULT '0',
  `group_page` tinyint(1) NOT NULL DEFAULT '0',
  `group_private` enum('Y','N') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'N',
  `song_title` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `song_about` text COLLATE utf8_unicode_ci NOT NULL,
  `song_year` year NOT NULL DEFAULT '0000',
  `song_n_plays` bigint NOT NULL DEFAULT '0',
  `song_n_comments` bigint NOT NULL DEFAULT '0',
  `song_rating` int NOT NULL DEFAULT '0',
  `song_length` int NOT NULL DEFAULT '0',
  `song_n_votes` bigint NOT NULL DEFAULT '0',
  `song_has_images` tinyint NOT NULL DEFAULT '0',
  `created_at` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `updated_at` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`song_id`),
  KEY `musician_id` (`musician_id`),
  KEY `user_id` (`user_id`),
  KEY `rating` (`song_rating`),
  KEY `has_images` (`song_has_images`),
  KEY `n_comments` (`song_n_comments`),
  KEY `n_plays` (`song_n_plays`),
  KEY `created_at` (`created_at`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;


DROP TABLE IF EXISTS `music_song_comment`;
CREATE TABLE `music_song_comment` (
  `comment_id` bigint NOT NULL AUTO_INCREMENT,
  `song_id` bigint NOT NULL DEFAULT '0',
  `user_id` bigint NOT NULL DEFAULT '0',
  `comment_text` text COLLATE utf8_unicode_ci NOT NULL,
  `created_at` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`comment_id`),
  KEY `song_id` (`song_id`),
  KEY `created_at` (`created_at`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;


DROP TABLE IF EXISTS `music_song_image`;
CREATE TABLE `music_song_image` (
  `image_id` bigint NOT NULL AUTO_INCREMENT,
  `song_id` bigint NOT NULL DEFAULT '0',
  `user_id` bigint NOT NULL DEFAULT '0',
  `created_at` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`image_id`),
  KEY `song_id` (`song_id`),
  KEY `created_at` (`created_at`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;


DROP TABLE IF EXISTS `music_song_vote`;
CREATE TABLE `music_song_vote` (
  `vote_id` bigint NOT NULL AUTO_INCREMENT,
  `song_id` bigint NOT NULL DEFAULT '0',
  `user_id` bigint NOT NULL DEFAULT '0',
  `vote_rating` int NOT NULL DEFAULT '0',
  `created_at` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `updated_at` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`vote_id`),
  KEY `song_id` (`song_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;


DROP TABLE IF EXISTS `news`;
CREATE TABLE `news` (
  `id` int NOT NULL AUTO_INCREMENT,
  `cat` int NOT NULL DEFAULT '0',
  `visible` char(1) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'N',
  `title` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `news_short` text COLLATE utf8_unicode_ci NOT NULL,
  `news_long` text COLLATE utf8_unicode_ci NOT NULL,
  `dt` int NOT NULL DEFAULT '0',
  `lang` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `root` tinyint(1) NOT NULL,
  `root_id` int NOT NULL,
  PRIMARY KEY (`id`),
  KEY `cat` (`cat`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;


DROP TABLE IF EXISTS `news_cats`;
CREATE TABLE `news_cats` (
  `id` int NOT NULL AUTO_INCREMENT,
  `title` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `lang` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `root` tinyint(1) NOT NULL,
  `root_id` int NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;


DROP TABLE IF EXISTS `object`;
CREATE TABLE `object` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `location` tinyint unsigned NOT NULL DEFAULT '0',
  `object_id` int NOT NULL DEFAULT '0',
  `title` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `description` text COLLATE utf8_unicode_ci NOT NULL,
  `button_text` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `button_url` text COLLATE utf8_unicode_ci NOT NULL,
  `big_image_url` text COLLATE utf8_unicode_ci NOT NULL,
  `image_url` text COLLATE utf8_unicode_ci NOT NULL,
  `video_url` text COLLATE utf8_unicode_ci NOT NULL,
  `size` float NOT NULL DEFAULT '0',
  `pos_x` int NOT NULL DEFAULT '0',
  `pos_y` int NOT NULL DEFAULT '0',
  `pos_z` int NOT NULL DEFAULT '0',
  `rot_x` int NOT NULL DEFAULT '0',
  `rot_y` int NOT NULL DEFAULT '0',
  `rot_z` int NOT NULL DEFAULT '0',
  `rotation_speed` int NOT NULL DEFAULT '0',
  `cursor_rotation` tinyint(1) NOT NULL DEFAULT '1',
  `info_on_hover` tinyint(1) NOT NULL DEFAULT '0',
  `enabled` tinyint(1) NOT NULL DEFAULT '1',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;


DROP TABLE IF EXISTS `object_type`;
CREATE TABLE `object_type` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `texture` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `obj` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `default` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;


DROP TABLE IF EXISTS `outside_image`;
CREATE TABLE `outside_image` (
  `image_id` bigint NOT NULL AUTO_INCREMENT,
  `user_id` bigint NOT NULL DEFAULT '0',
  `image_n_links` bigint NOT NULL DEFAULT '1',
  `outside_url` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `created_at` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `width` int NOT NULL DEFAULT '0',
  `height` int NOT NULL DEFAULT '0',
  `meta_id` bigint NOT NULL DEFAULT '0',
  `gif` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`image_id`),
  KEY `outside_url` (`outside_url`),
  KEY `created_at` (`created_at`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;


DROP TABLE IF EXISTS `pages`;
CREATE TABLE `pages` (
  `id` int NOT NULL AUTO_INCREMENT,
  `menu_title` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `menu_style` tinyint(1) NOT NULL DEFAULT '0',
  `title` text COLLATE utf8_unicode_ci NOT NULL,
  `content` longtext COLLATE utf8_unicode_ci NOT NULL,
  `section` varchar(40) COLLATE utf8_unicode_ci NOT NULL,
  `position` int NOT NULL,
  `status` tinyint(1) NOT NULL DEFAULT '1',
  `hide_from_guests` tinyint(1) NOT NULL DEFAULT '0',
  `parent` int NOT NULL DEFAULT '0',
  `system` tinyint(1) NOT NULL DEFAULT '0',
  `lang` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `set` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`id`),
  KEY `menu_title` (`menu_title`),
  KEY `lang` (`lang`),
  KEY `status` (`status`),
  KEY `section` (`section`),
  KEY `lang_2` (`lang`),
  KEY `position` (`position`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;


DROP TABLE IF EXISTS `partner`;
CREATE TABLE `partner` (
  `partner_id` int NOT NULL AUTO_INCREMENT,
  `p_partner` int NOT NULL DEFAULT '0',
  `summary` decimal(7,2) NOT NULL DEFAULT '0.00',
  `account` decimal(7,2) NOT NULL DEFAULT '0.00',
  `payment` decimal(7,2) NOT NULL DEFAULT '0.00',
  `payment_last` decimal(7,2) NOT NULL DEFAULT '0.00',
  `payment_last_date` datetime NOT NULL,
  `count_users` int NOT NULL DEFAULT '0',
  `count_refs` int NOT NULL DEFAULT '0',
  `count_golds` int NOT NULL DEFAULT '0',
  `name` varchar(25) COLLATE utf8_unicode_ci NOT NULL,
  `password` varchar(60) COLLATE utf8_unicode_ci NOT NULL,
  `company` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `domain` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `real_name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `phone` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `mail` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `adress` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `adress2` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `country_id` int NOT NULL DEFAULT '0',
  `state_id` int NOT NULL DEFAULT '0',
  `city_id` int NOT NULL DEFAULT '0',
  `zip` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `tax` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `other` text COLLATE utf8_unicode_ci NOT NULL,
  `bank_name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `bank_phone` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `bank_adress1` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `bank_adress2` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `bank_city` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `bank_state` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `bank_zip` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `bank_country` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `bank_account` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `bank_aba` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `bank_swift` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `bank_type` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `bank_to` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `paypal` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `lang` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`partner_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;


DROP TABLE IF EXISTS `partner_banners`;
CREATE TABLE `partner_banners` (
  `id` int NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `code` text COLLATE utf8_unicode_ci NOT NULL,
  `size` varchar(50) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `file` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `langs` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;


DROP TABLE IF EXISTS `partner_faq`;
CREATE TABLE `partner_faq` (
  `id` int NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `text` text COLLATE utf8_unicode_ci NOT NULL,
  `lang` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;


DROP TABLE IF EXISTS `partner_main`;
CREATE TABLE `partner_main` (
  `id` int NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `text` text COLLATE utf8_unicode_ci NOT NULL,
  `lang` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;


DROP TABLE IF EXISTS `partner_terms`;
CREATE TABLE `partner_terms` (
  `id` int NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `text` text COLLATE utf8_unicode_ci NOT NULL,
  `lang` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;


DROP TABLE IF EXISTS `partner_tips`;
CREATE TABLE `partner_tips` (
  `id` int NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `text` text COLLATE utf8_unicode_ci NOT NULL,
  `lang` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;


DROP TABLE IF EXISTS `payment_after`;
CREATE TABLE `payment_after` (
  `id` int NOT NULL AUTO_INCREMENT,
  `dt` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `data` text COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;


DROP TABLE IF EXISTS `payment_before`;
CREATE TABLE `payment_before` (
  `id` int NOT NULL AUTO_INCREMENT,
  `user_id` int NOT NULL DEFAULT '0',
  `dt` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `item` int NOT NULL DEFAULT '0',
  `system` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `type` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `code` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `request_uri` text COLLATE utf8_unicode_ci NOT NULL,
  `subscription_id` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `subscription_expiry_time` int NOT NULL,
  `app_package_name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `app_product_id` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`id`),
  KEY `code` (`code`),
  KEY `system` (`system`),
  KEY `subscription_id` (`subscription_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;


DROP TABLE IF EXISTS `payment_cat`;
CREATE TABLE `payment_cat` (
  `id` int NOT NULL AUTO_INCREMENT,
  `name` varchar(50) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `code` varchar(50) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;


DROP TABLE IF EXISTS `payment_features`;
CREATE TABLE `payment_features` (
  `id` int NOT NULL AUTO_INCREMENT,
  `title` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `alias` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `status` tinyint(1) NOT NULL DEFAULT '1',
  `type` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  KEY `id` (`id`),
  KEY `alias` (`alias`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;


DROP TABLE IF EXISTS `payment_log`;
CREATE TABLE `payment_log` (
  `id` int NOT NULL AUTO_INCREMENT,
  `user_id` int NOT NULL DEFAULT '0',
  `amount` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `system` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `ip` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `referer` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `dt` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;


DROP TABLE IF EXISTS `payment_plan`;
CREATE TABLE `payment_plan` (
  `item` int NOT NULL AUTO_INCREMENT,
  `item_name` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `amount` decimal(7,2) NOT NULL DEFAULT '0.00',
  `amount_old` decimal(7,2) NOT NULL DEFAULT '0.00',
  `gold_days` int NOT NULL DEFAULT '0',
  `type` enum('none','gold','silver','platinum','membership','credits') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'none',
  `co_id` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `default` tinyint(1) NOT NULL DEFAULT '0',
  `set` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `payment_modules_off` text COLLATE utf8_unicode_ci NOT NULL,
  `fortumo_service_id` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `fortumo_secret` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `zombaio_pricing_id` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `iapgoogle_product_id` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `iapapple_product_id` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`item`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;


DROP TABLE IF EXISTS `payment_price`;
CREATE TABLE `payment_price` (
  `id` int NOT NULL AUTO_INCREMENT,
  `title` text COLLATE utf8_unicode_ci NOT NULL,
  `alias` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `credits` int NOT NULL DEFAULT '0',
  `set` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;


DROP TABLE IF EXISTS `payment_type`;
CREATE TABLE `payment_type` (
  `type` varchar(10) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `code` varchar(50) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  PRIMARY KEY (`type`,`code`),
  KEY `type` (`type`),
  KEY `code` (`code`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;


DROP TABLE IF EXISTS `photo`;
CREATE TABLE `photo` (
  `photo_id` int unsigned NOT NULL AUTO_INCREMENT,
  `user_id` int unsigned NOT NULL DEFAULT '0',
  `group_id` bigint NOT NULL DEFAULT '0',
  `group_page` tinyint(1) NOT NULL DEFAULT '0',
  `group_private` enum('Y','N') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'N',
  `date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `photo_name` varchar(25) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `description` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `visible` enum('Y','N','P','Nudity') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'N',
  `nudity` tinyint(1) NOT NULL DEFAULT '0',
  `default` enum('Y','N') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'N',
  `default_group` enum('Y','N') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'N',
  `private` enum('Y','N') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'N',
  `votes` int NOT NULL DEFAULT '0',
  `rating` int NOT NULL DEFAULT '0',
  `average` float NOT NULL DEFAULT '0',
  `wall_id` bigint NOT NULL,
  `published` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `users_reports` text COLLATE utf8_unicode_ci NOT NULL,
  `version` int NOT NULL DEFAULT '0',
  `width` int NOT NULL DEFAULT '0',
  `height` int NOT NULL DEFAULT '0',
  `count_comments_all` int unsigned NOT NULL DEFAULT '0',
  `count_comments` int unsigned NOT NULL DEFAULT '0',
  `count_comments_replies` int unsigned NOT NULL DEFAULT '0',
  `count_views` int unsigned NOT NULL DEFAULT '0',
  `hide_header` tinyint(1) NOT NULL DEFAULT '0',
  `like` int NOT NULL DEFAULT '0',
  `dislike` int NOT NULL DEFAULT '0',
  `restore` tinyint(1) NOT NULL DEFAULT '0',
  `face_detect_data` text COLLATE utf8_unicode_ci NOT NULL,
  `set_admin_default` tinyint(1) NOT NULL DEFAULT '0',
  `gif` tinyint(1) NOT NULL DEFAULT '0',
  `hash` varchar(12) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  PRIMARY KEY (`photo_id`),
  KEY `user_id_2` (`user_id`,`visible`),
  KEY `photo_id` (`photo_id`,`user_id`),
  KEY `visible` (`visible`),
  KEY `user_id` (`user_id`),
  KEY `wall_id` (`wall_id`),
  KEY `private` (`private`),
  KEY `default` (`default`),
  KEY `default_group` (`default_group`),
  KEY `date` (`date`),
  KEY `hide_header` (`hide_header`),
  KEY `group_id` (`group_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;


DROP TABLE IF EXISTS `photo_comments`;
CREATE TABLE `photo_comments` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `photo_id` int unsigned NOT NULL DEFAULT '0',
  `photo_user_id` int NOT NULL DEFAULT '0',
  `group_id` bigint NOT NULL DEFAULT '0',
  `group_user_id` int NOT NULL DEFAULT '0',
  `user_id` int NOT NULL DEFAULT '0',
  `date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `send` bigint unsigned NOT NULL DEFAULT '0',
  `comment` text COLLATE utf8_unicode_ci NOT NULL,
  `parent_id` int DEFAULT '0',
  `parent_user_id` int DEFAULT '0',
  `replies` int DEFAULT '0',
  `likes` int NOT NULL DEFAULT '0',
  `last_action_like` datetime NOT NULL,
  `system` tinyint(1) NOT NULL DEFAULT '0',
  `is_new` tinyint(1) NOT NULL DEFAULT '0',
  `audio_message_id` bigint unsigned NOT NULL,
  `users_reports_comment` text COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`id`),
  KEY `photo_id` (`photo_id`),
  KEY `date` (`date`),
  KEY `is_new` (`is_new`),
  KEY `parent_id` (`parent_id`),
  KEY `parent_user_id` (`parent_user_id`),
  KEY `id_parent_id` (`id`,`parent_id`),
  KEY `photo_id_parent_id` (`photo_id`,`parent_id`),
  KEY `group_id` (`group_id`),
  KEY `group_user_id` (`group_user_id`),
  KEY `photo_user_id_parent_user_id_user_id` (`photo_user_id`,`parent_user_id`,`user_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;


DROP TABLE IF EXISTS `photo_comments_likes`;
CREATE TABLE `photo_comments_likes` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `photo_id` int NOT NULL,
  `photo_user_id` int NOT NULL,
  `group_id` bigint NOT NULL DEFAULT '0',
  `group_user_id` int NOT NULL DEFAULT '0',
  `user_id` int NOT NULL,
  `cid` int NOT NULL,
  `comment_user_id` int NOT NULL,
  `date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `is_new` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `user_id_cid` (`user_id`,`cid`,`photo_id`),
  KEY `date` (`date`),
  KEY `is_new` (`is_new`),
  KEY `cid_id` (`cid`,`id`),
  KEY `group_id` (`group_id`),
  KEY `group_user_id` (`group_user_id`),
  KEY `comment_user_id_user_id` (`comment_user_id`,`user_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;


DROP TABLE IF EXISTS `photo_face_user_relation`;
CREATE TABLE `photo_face_user_relation` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `photo_id` int unsigned NOT NULL DEFAULT '0',
  `user_photo_id` int unsigned NOT NULL DEFAULT '0',
  `user_id` int unsigned NOT NULL DEFAULT '0',
  `box_id` tinyint NOT NULL DEFAULT '0',
  `date` datetime NOT NULL,
  `is_new` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `user_relation` (`photo_id`,`user_id`),
  KEY `photo_id` (`photo_id`,`user_id`),
  KEY `user_id` (`user_id`),
  KEY `new` (`is_new`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;


DROP TABLE IF EXISTS `photo_likes`;
CREATE TABLE `photo_likes` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `photo_id` int NOT NULL,
  `group_id` bigint unsigned NOT NULL DEFAULT '0',
  `group_user_id` int NOT NULL DEFAULT '0',
  `photo_user_id` int NOT NULL,
  `user_id` int NOT NULL,
  `like` tinyint(1) NOT NULL DEFAULT '0',
  `date` datetime NOT NULL,
  `is_new` tinyint(1) NOT NULL DEFAULT '1',
  PRIMARY KEY (`id`),
  UNIQUE KEY `user_id` (`user_id`,`photo_id`),
  KEY `is_new` (`is_new`),
  KEY `photo_id` (`photo_id`,`id`),
  KEY `photo_user_id_user_id` (`photo_user_id`,`user_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;


DROP TABLE IF EXISTS `photo_rate`;
CREATE TABLE `photo_rate` (
  `id` int NOT NULL AUTO_INCREMENT,
  `photo_id` int NOT NULL DEFAULT '0',
  `photo_user_id` int NOT NULL DEFAULT '0',
  `user_id` int NOT NULL DEFAULT '0',
  `rating` tinyint(1) NOT NULL DEFAULT '0',
  `visible` tinyint(1) NOT NULL DEFAULT '1',
  `is_new` tinyint(1) NOT NULL DEFAULT '1',
  PRIMARY KEY (`id`),
  KEY `photo_id` (`photo_id`),
  KEY `photo_user_id` (`photo_user_id`,`visible`,`is_new`),
  KEY `user_id` (`user_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;


DROP TABLE IF EXISTS `photo_tags`;
CREATE TABLE `photo_tags` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `tag` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `counter` int NOT NULL,
  PRIMARY KEY (`id`),
  KEY `tag` (`tag`),
  KEY `counter` (`counter`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;


DROP TABLE IF EXISTS `photo_tags_relations`;
CREATE TABLE `photo_tags_relations` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `photo_id` int NOT NULL,
  `tag_id` bigint NOT NULL,
  PRIMARY KEY (`id`),
  KEY `photo_id` (`photo_id`),
  KEY `tag_id` (`tag_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;


DROP TABLE IF EXISTS `places_category`;
CREATE TABLE `places_category` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `title` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `position` int NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;


DROP TABLE IF EXISTS `places_place`;
CREATE TABLE `places_place` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `category_id` bigint NOT NULL DEFAULT '0',
  `user_id` bigint NOT NULL DEFAULT '0',
  `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `phone` varchar(64) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `site` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `about` text COLLATE utf8_unicode_ci NOT NULL,
  `address` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `city_id` bigint NOT NULL DEFAULT '0',
  `rating` int NOT NULL DEFAULT '0',
  `n_votes` bigint NOT NULL DEFAULT '0',
  `has_images` tinyint NOT NULL DEFAULT '0',
  `n_reviews` bigint NOT NULL DEFAULT '0',
  `reviews_rating` bigint NOT NULL DEFAULT '0',
  `created_at` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `updated_at` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`id`),
  KEY `category_id` (`category_id`),
  KEY `city_id` (`city_id`),
  KEY `user_id` (`user_id`),
  KEY `rating` (`rating`),
  KEY `has_images` (`has_images`),
  KEY `n_reviews` (`n_reviews`),
  KEY `reviews_rating` (`reviews_rating`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;


DROP TABLE IF EXISTS `places_place_image`;
CREATE TABLE `places_place_image` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `place_id` bigint NOT NULL DEFAULT '0',
  `user_id` bigint NOT NULL DEFAULT '0',
  `created_at` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`id`),
  KEY `place_id` (`place_id`),
  KEY `created_at` (`created_at`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;


DROP TABLE IF EXISTS `places_place_vote`;
CREATE TABLE `places_place_vote` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `place_id` bigint NOT NULL DEFAULT '0',
  `user_id` bigint NOT NULL DEFAULT '0',
  `rating` int NOT NULL DEFAULT '0',
  `created_at` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `updated_at` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`id`),
  KEY `place_id` (`place_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;


DROP TABLE IF EXISTS `places_review`;
CREATE TABLE `places_review` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `place_id` bigint NOT NULL DEFAULT '0',
  `user_id` bigint NOT NULL DEFAULT '0',
  `title` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `text` text COLLATE utf8_unicode_ci NOT NULL,
  `n_votes` bigint NOT NULL DEFAULT '0',
  `created_at` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `updated_at` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`id`),
  KEY `place_id` (`place_id`,`user_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;


DROP TABLE IF EXISTS `places_review_vote`;
CREATE TABLE `places_review_vote` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `review_id` bigint NOT NULL DEFAULT '0',
  `user_id` bigint NOT NULL DEFAULT '0',
  `created_at` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`id`),
  KEY `review_id` (`review_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;


DROP TABLE IF EXISTS `profile_status`;
CREATE TABLE `profile_status` (
  `user_id` int NOT NULL DEFAULT '0',
  `status` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  KEY `user_id` (`user_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;


DROP TABLE IF EXISTS `search_save`;
CREATE TABLE `search_save` (
  `id` int NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `user_id` int NOT NULL DEFAULT '0',
  `query` text COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`id`),
  KEY `user_id` (`user_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;


DROP TABLE IF EXISTS `seo`;
CREATE TABLE `seo` (
  `id` int NOT NULL AUTO_INCREMENT,
  `url` text COLLATE utf8_unicode_ci NOT NULL,
  `title` text COLLATE utf8_unicode_ci NOT NULL,
  `description` text COLLATE utf8_unicode_ci NOT NULL,
  `keywords` text COLLATE utf8_unicode_ci NOT NULL,
  `lang` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `default` tinyint(1) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `lang` (`lang`,`default`),
  FULLTEXT KEY `url` (`url`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;


DROP TABLE IF EXISTS `spotlight`;
CREATE TABLE `spotlight` (
  `id` int NOT NULL AUTO_INCREMENT,
  `user_id` int NOT NULL,
  PRIMARY KEY (`id`),
  KEY `user_id` (`user_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;


DROP TABLE IF EXISTS `stats`;
CREATE TABLE `stats` (
  `date` date NOT NULL,
  `orientation` smallint unsigned NOT NULL,
  `logins` int unsigned NOT NULL,
  `registrations` int unsigned NOT NULL,
  `mail_messages_sent` int unsigned NOT NULL,
  `postcards_sent` int unsigned NOT NULL,
  `videos_uploaded` int unsigned NOT NULL,
  `videos_viewed` int unsigned NOT NULL,
  `videos_comments` int unsigned NOT NULL,
  `profiles_viewved` int unsigned NOT NULL,
  `3d_city_started` int unsigned NOT NULL,
  `hot_or_not_votes` int unsigned NOT NULL,
  `pics_uploaded` int unsigned NOT NULL,
  `photos_uploaded` int unsigned NOT NULL,
  `added_to_friends` int unsigned NOT NULL,
  `3d_chat_opened` int unsigned NOT NULL,
  `flash_chat_opened` int unsigned NOT NULL,
  `new_blogs` int unsigned NOT NULL,
  `events_created` int unsigned NOT NULL,
  `new_forum_posts` int unsigned NOT NULL,
  `groups_created` int unsigned NOT NULL,
  `winks_sent` int unsigned NOT NULL,
  `gold_memberships` int unsigned NOT NULL,
  `ads_published` int unsigned NOT NULL,
  `replies_to_ads` int unsigned NOT NULL,
  `mp3_uploaded` int unsigned NOT NULL,
  `user_blocks` int unsigned NOT NULL,
  `games_started` int unsigned NOT NULL,
  `im_started` int unsigned NOT NULL,
  `im_messages` int unsigned NOT NULL,
  `added_to_favourites` int unsigned NOT NULL,
  `blog_search_used` int unsigned NOT NULL,
  `user_search_used` int unsigned NOT NULL,
  `gifts_sent` int unsigned NOT NULL,
  PRIMARY KEY (`date`,`orientation`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;


DROP TABLE IF EXISTS `stats_country`;
CREATE TABLE `stats_country` (
  `date` date NOT NULL,
  `orientation` smallint unsigned NOT NULL,
  `country_id` int unsigned NOT NULL,
  `count` int unsigned NOT NULL,
  PRIMARY KEY (`date`,`orientation`,`country_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;


DROP TABLE IF EXISTS `stickers`;
CREATE TABLE `stickers` (
  `id` int NOT NULL AUTO_INCREMENT,
  `sticker` int NOT NULL DEFAULT '0',
  `collection` int NOT NULL DEFAULT '0',
  `type` varchar(3) COLLATE utf8_unicode_ci DEFAULT '',
  `animate` tinyint(1) NOT NULL DEFAULT '0',
  `active` tinyint(1) NOT NULL DEFAULT '1',
  `position` int NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `sticker_collection` (`sticker`,`collection`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;


DROP TABLE IF EXISTS `stickers_collections`;
CREATE TABLE `stickers_collections` (
  `id` int NOT NULL AUTO_INCREMENT,
  `position` int NOT NULL DEFAULT '0',
  `active` tinyint(1) NOT NULL DEFAULT '1',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;


DROP TABLE IF EXISTS `stickers_popularity_users`;
CREATE TABLE `stickers_popularity_users` (
  `id` int NOT NULL AUTO_INCREMENT,
  `user_id` int NOT NULL DEFAULT '0',
  `collection` int NOT NULL DEFAULT '0',
  `sticker` int NOT NULL DEFAULT '0',
  `count` int NOT NULL DEFAULT '0',
  `date_send` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`id`),
  UNIQUE KEY `sticker_user_id` (`user_id`,`sticker`,`collection`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;


DROP TABLE IF EXISTS `texts`;
CREATE TABLE `texts` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `user_id` int unsigned NOT NULL DEFAULT '0',
  `headline` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `essay` text COLLATE utf8_unicode_ci NOT NULL,
  `about_me` text COLLATE utf8_unicode_ci NOT NULL,
  `interested_in` text COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;


DROP TABLE IF EXISTS `user`;
CREATE TABLE `user` (
  `user_id` int unsigned NOT NULL AUTO_INCREMENT,
  `partner` int unsigned NOT NULL DEFAULT '0',
  `gold_days` int unsigned NOT NULL DEFAULT '0',
  `role` enum('user','admin','demo_admin') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'user',
  `name` varchar(50) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `name_seo` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `gender` enum('M','F') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'M',
  `orientation` int unsigned NOT NULL DEFAULT '0',
  `p_orientation` int unsigned NOT NULL DEFAULT '0',
  `relation` int unsigned NOT NULL DEFAULT '0',
  `couple` enum('Y','N','A') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'N',
  `couple_id` int NOT NULL DEFAULT '0',
  `mail` varchar(100) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `change_mail` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `password` varchar(60) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `avatar` int unsigned NOT NULL DEFAULT '0',
  `is_photo` enum('N','Y') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'N',
  `is_photo_public` enum('Y','N') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'N',
  `record` enum('Y','N') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'N',
  `record_id` int NOT NULL DEFAULT '0',
  `country_id` int unsigned NOT NULL DEFAULT '0',
  `state_id` int unsigned NOT NULL DEFAULT '0',
  `city_id` int unsigned NOT NULL DEFAULT '0',
  `country` varchar(100) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `state` varchar(100) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `city` varchar(100) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `zip` int unsigned NOT NULL DEFAULT '0',
  `birth` date NOT NULL DEFAULT '0000-00-00',
  `p_age_from` int unsigned NOT NULL DEFAULT '0',
  `p_age_to` int unsigned NOT NULL DEFAULT '0',
  `horoscope` int unsigned NOT NULL DEFAULT '0',
  `p_horoscope` bigint unsigned NOT NULL DEFAULT '0',
  `active` tinyint(1) NOT NULL DEFAULT '1',
  `active_code` varchar(40) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `hide_time` int unsigned NOT NULL DEFAULT '0',
  `register` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `last_visit` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `rating` int unsigned NOT NULL DEFAULT '0',
  `new_mails` int unsigned NOT NULL DEFAULT '0',
  `new_interests` int unsigned NOT NULL DEFAULT '0',
  `new_views` int unsigned NOT NULL DEFAULT '0',
  `total_views` int unsigned NOT NULL DEFAULT '0',
  `last_ip` varchar(39) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `set_email_mail` int unsigned NOT NULL DEFAULT '2',
  `set_email_interest` int unsigned NOT NULL DEFAULT '2',
  `type` enum('none','gold','silver','platinum','membership','credits') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'none',
  `city_money` mediumint unsigned NOT NULL DEFAULT '0',
  `forum_n_messages` bigint NOT NULL DEFAULT '0',
  `sound` tinyint(1) NOT NULL DEFAULT '1',
  `blog_visits` int unsigned NOT NULL,
  `blog_comments` int unsigned NOT NULL,
  `blog_posts` int unsigned NOT NULL,
  `vid_visits` int unsigned NOT NULL,
  `vid_comments` int unsigned NOT NULL,
  `vid_videos` int unsigned NOT NULL,
  `vid_videos_pages` int unsigned NOT NULL,
  `vid_videos_groups` int unsigned NOT NULL,
  `moderator_photo` tinyint unsigned NOT NULL,
  `moderator_vids_video` tinyint unsigned NOT NULL,
  `moderator_texts` tinyint unsigned NOT NULL,
  `moderator_profiles` tinyint unsigned NOT NULL,
  `facebook_id` bigint unsigned NOT NULL,
  `google_plus_id` varchar(30) COLLATE utf8_unicode_ci NOT NULL,
  `linkedin_id` varchar(25) COLLATE utf8_unicode_ci NOT NULL,
  `twitter_id` varchar(25) COLLATE utf8_unicode_ci NOT NULL,
  `vk_id` varchar(25) COLLATE utf8_unicode_ci NOT NULL,
  `default_online_view` enum('B','M','F') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'B',
  `albums_to_see` enum('users','friends') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'users',
  `wall_like_comment_alert` tinyint(1) NOT NULL,
  `use_as_online` tinyint(1) NOT NULL,
  `isMobile` enum('true','false') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'false',
  `couple_from` int DEFAULT NULL,
  `couple_to` int DEFAULT NULL,
  `state_narrow_box` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `match_mail` tinyint(1) NOT NULL DEFAULT '0',
  `lang` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `smart_profile` tinyint(1) NOT NULL DEFAULT '1',
  `wall_only_post` tinyint(1) NOT NULL DEFAULT '2',
  `review_link` varchar(10) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'info',
  `color_scheme` varchar(100) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `ban_mails` tinyint(1) NOT NULL DEFAULT '0',
  `is_online_users_im` tinyint(1) NOT NULL DEFAULT '2',
  `ban_time` datetime NOT NULL,
  `ban_time_release` int NOT NULL DEFAULT '0',
  `i_am_here_to` tinyint NOT NULL DEFAULT '1',
  `profile_bg` varchar(10) COLLATE utf8_unicode_ci DEFAULT '',
  `set_who_view_profile` enum('anyone','members') COLLATE utf8_unicode_ci DEFAULT 'anyone',
  `set_can_comment_photos` enum('anyone','members') COLLATE utf8_unicode_ci DEFAULT 'anyone',
  `set_notif_profile_visitors` tinyint(1) DEFAULT '1',
  `set_notif_gifts` tinyint(1) DEFAULT '1',
  `set_notif_voted_photos` tinyint(1) DEFAULT '1',
  `set_notif_push_notifications` tinyint(1) DEFAULT '1',
  `set_hide_my_presence` tinyint(1) DEFAULT '2',
  `set_do_not_show_me_visitors` tinyint(1) DEFAULT '2',
  `rated_photos` tinyint(1) NOT NULL DEFAULT '0',
  `last_photo_visible_rated` int NOT NULL DEFAULT '0',
  `popularity` int NOT NULL DEFAULT '0',
  `credits` int NOT NULL DEFAULT '0',
  `date_search` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `date_encounters` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `sp_sending_messages_per_day` int NOT NULL DEFAULT '0',
  `profile_bg_video` varchar(510) COLLATE utf8_unicode_ci DEFAULT '{}',
  `set_notif_mutual_attraction` tinyint(1) DEFAULT '1',
  `set_notif_want_to_meet_you` tinyint(1) DEFAULT '1',
  `set_notif_new_msg` tinyint(1) DEFAULT '1',
  `set_notif_new_comments` tinyint(1) DEFAULT '1',
  `ban_global` tinyint(1) NOT NULL DEFAULT '0',
  `password_reminder` varchar(32) COLLATE utf8_unicode_ci DEFAULT NULL,
  `payment_day` date NOT NULL,
  `payment_hour` int NOT NULL,
  `wall_mode` enum('all','friends') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'all',
  `users_reports` text COLLATE utf8_unicode_ci NOT NULL,
  `translation_off` text COLLATE utf8_unicode_ci NOT NULL,
  `timezone` varchar(40) COLLATE utf8_unicode_ci DEFAULT '',
  `video_greeting` int NOT NULL DEFAULT '0',
  `admin` tinyint(1) NOT NULL DEFAULT '0',
  `auth_key` varchar(32) COLLATE utf8_unicode_ci NOT NULL,
  `last_broadcast` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `hide_ads` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `im_reply_new_contact_rate` tinyint unsigned NOT NULL DEFAULT '100',
  `welcoming_message_notify` tinyint unsigned NOT NULL DEFAULT '0',
  `geo_position_lat` bigint NOT NULL DEFAULT '0',
  `geo_position_long` bigint NOT NULL DEFAULT '0',
  `geo_position_age` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `geo_position_city_id` int NOT NULL DEFAULT '0',
  `geo_position_state_id` int NOT NULL DEFAULT '0',
  `geo_position_country_id` int NOT NULL DEFAULT '0',
  `geo_position_city` varchar(100) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `geo_position_state` varchar(100) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `geo_position_country` varchar(100) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `set_notif_show_my_age` tinyint(1) DEFAULT '1',
  `wall_post_access` varchar(100) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `live_now_id` int NOT NULL DEFAULT '0',
  `live_now_status` int NOT NULL DEFAULT '0',
  `profile_bg_cover` tinyint(1) NOT NULL DEFAULT '0',
  `profile_bg_cover_param` varchar(510) COLLATE utf8_unicode_ci DEFAULT '',
  `lms_user_type` int NOT NULL DEFAULT '0',
  PRIMARY KEY (`user_id`),
  UNIQUE KEY `mail` (`mail`),
  KEY `country_id` (`country_id`),
  KEY `state_id` (`state_id`),
  KEY `city_id` (`city_id`),
  KEY `hide_time` (`hide_time`),
  KEY `register` (`register`),
  KEY `orientation` (`orientation`),
  KEY `orientation_2` (`orientation`,`last_visit`),
  KEY `is_photo` (`is_photo`),
  KEY `name` (`name`),
  KEY `orientation_3` (`orientation`,`city_id`,`register`),
  KEY `city_id_2` (`city_id`,`register`),
  KEY `is_photo_2` (`is_photo`,`register`),
  KEY `blog_fields` (`blog_visits`,`blog_comments`,`blog_posts`),
  KEY `last_visit` (`last_visit`),
  KEY `popularity` (`popularity`),
  KEY `date_search` (`date_search`),
  KEY `date_encounters` (`date_encounters`),
  KEY `i_am_here_to` (`i_am_here_to`),
  KEY `ban_global` (`ban_global`),
  KEY `gold_days` (`gold_days`),
  KEY `payment_day` (`payment_day`),
  KEY `payment_hour` (`payment_hour`),
  KEY `facebook_id` (`facebook_id`),
  KEY `google_plus_id` (`google_plus_id`),
  KEY `twitter_id` (`twitter_id`),
  KEY `linkedin_id` (`linkedin_id`),
  KEY `vk_id` (`vk_id`),
  KEY `name_seo` (`name_seo`),
  KEY `hide_time_2` (`hide_time`,`user_id`,`last_visit`),
  KEY `city_id_popularity` (`city_id`,`popularity`),
  KEY `birth` (`birth`),
  KEY `is_photo_date_search_user_id` (`is_photo`,`date_search`,`user_id`),
  KEY `is_photo_date_encounters_user_id` (`is_photo`,`date_encounters`,`user_id`),
  KEY `is_photo_user_id` (`is_photo`,`user_id`),
  KEY `hide_time_use_as_online` (`hide_time`,`use_as_online`),
  KEY `active_code` (`active_code`),
  KEY `country_id_set_hide_my_presence` (`country_id`,`set_hide_my_presence`),
  KEY `geo_position_lat` (`geo_position_lat`),
  KEY `geo_position_long` (`geo_position_long`),
  KEY `geo_position_point` (`geo_position_lat`,`geo_position_long`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;


DROP TABLE IF EXISTS `user_block_list`;
CREATE TABLE `user_block_list` (
  `id` int NOT NULL AUTO_INCREMENT,
  `user_from` int NOT NULL DEFAULT '0',
  `user_to` int NOT NULL DEFAULT '0',
  `mail` tinyint(1) NOT NULL,
  `im` tinyint(1) NOT NULL DEFAULT '0',
  `audiochat` tinyint(1) NOT NULL DEFAULT '0',
  `videochat` tinyint(1) NOT NULL DEFAULT '0',
  `games` tinyint(1) NOT NULL DEFAULT '0',
  `wall` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `user_from` (`user_from`,`user_to`),
  KEY `user_from_2` (`user_from`),
  KEY `user_to` (`user_to`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;


DROP TABLE IF EXISTS `user_chart_random_value`;
CREATE TABLE `user_chart_random_value` (
  `id` int NOT NULL AUTO_INCREMENT,
  `user_from` int NOT NULL DEFAULT '0',
  `user_to` int NOT NULL DEFAULT '0',
  `chart` tinyint(1) NOT NULL DEFAULT '0',
  `value` tinyint(1) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `user_from` (`user_from`),
  KEY `user_to` (`user_to`),
  KEY `chart` (`chart`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;


DROP TABLE IF EXISTS `user_gift`;
CREATE TABLE `user_gift` (
  `id` int NOT NULL AUTO_INCREMENT,
  `user_from` int NOT NULL DEFAULT '0',
  `user_to` int NOT NULL DEFAULT '0',
  `gift` int NOT NULL DEFAULT '0',
  `text` text COLLATE utf8_unicode_ci NOT NULL,
  `visibility` tinyint(1) NOT NULL DEFAULT '0',
  `date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `gifts_credits` int NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `from_user` (`user_from`),
  KEY `to_user` (`user_to`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;


DROP TABLE IF EXISTS `user_interests`;
CREATE TABLE `user_interests` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `user_id` int NOT NULL,
  `interest` int NOT NULL,
  `wall_id` bigint NOT NULL,
  KEY `user_id` (`user_id`),
  KEY `interest` (`interest`),
  KEY `wall_id` (`wall_id`),
  KEY `id` (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;


DROP TABLE IF EXISTS `userinfo`;
CREATE TABLE `userinfo` (
  `user_id` int unsigned NOT NULL AUTO_INCREMENT,
  `headline` varchar(100) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `essay` text COLLATE utf8_unicode_ci NOT NULL,
  `height` int unsigned NOT NULL DEFAULT '0',
  `weight` int unsigned NOT NULL DEFAULT '0',
  `body` int unsigned NOT NULL DEFAULT '0',
  `drinking` int unsigned NOT NULL DEFAULT '0',
  `ethnicity` int unsigned NOT NULL DEFAULT '0',
  `eye` int unsigned NOT NULL DEFAULT '0',
  `religion` int unsigned NOT NULL DEFAULT '0',
  `family` int unsigned NOT NULL DEFAULT '0',
  `hair` int unsigned NOT NULL DEFAULT '0',
  `income` int unsigned NOT NULL DEFAULT '0',
  `career` int unsigned NOT NULL DEFAULT '0',
  `smoking` int unsigned NOT NULL DEFAULT '0',
  `status` int unsigned NOT NULL DEFAULT '0',
  `age_preference` int unsigned NOT NULL DEFAULT '0',
  `appearance` int unsigned NOT NULL DEFAULT '0',
  `first_date` int unsigned NOT NULL DEFAULT '0',
  `humor` int unsigned NOT NULL DEFAULT '0',
  `level_of_faith` int unsigned NOT NULL DEFAULT '0',
  `live_where` int unsigned NOT NULL DEFAULT '0',
  `living_with` int unsigned NOT NULL DEFAULT '0',
  `spending_habits` int unsigned NOT NULL DEFAULT '0',
  `user_editor_xml` text COLLATE utf8_unicode_ci NOT NULL,
  `about_me` text COLLATE utf8_unicode_ci NOT NULL,
  `interested_in` text COLLATE utf8_unicode_ci NOT NULL,
  `interests` int unsigned NOT NULL DEFAULT '0',
  `sexuality` int NOT NULL,
  `star_sign` int NOT NULL,
  `education` int NOT NULL,
  `user_search_filters` text COLLATE utf8_unicode_ci NOT NULL,
  `state_filter_search` tinyint(1) NOT NULL DEFAULT '0',
  `user_search_filters_mobile` text COLLATE utf8_unicode_ci NOT NULL,
  `your_private_note` text COLLATE utf8_unicode_ci NOT NULL,
  `blogs_filters` text COLLATE utf8_unicode_ci NOT NULL,
  `videos_filters` text COLLATE utf8_unicode_ci NOT NULL,
  `videos_pages_filters` text COLLATE utf8_unicode_ci NOT NULL,
  `videos_groups_filters` text COLLATE utf8_unicode_ci NOT NULL,
  `photos_filters` text COLLATE utf8_unicode_ci NOT NULL,
  `photos_pages_filters` text COLLATE utf8_unicode_ci NOT NULL,
  `photos_groups_filters` text COLLATE utf8_unicode_ci NOT NULL,
  `groups_filters` text COLLATE utf8_unicode_ci NOT NULL,
  `pages_filters` text COLLATE utf8_unicode_ci NOT NULL,
  `live_filters` text COLLATE utf8_unicode_ci NOT NULL,
  `songs_filters` text COLLATE utf8_unicode_ci NOT NULL,
  `songs_pages_filters` text COLLATE utf8_unicode_ci NOT NULL,
  `songs_groups_filters` text COLLATE utf8_unicode_ci NOT NULL,
  `create_task_user_id` int NOT NULL DEFAULT '0',
  PRIMARY KEY (`user_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;


DROP TABLE IF EXISTS `userpartner`;
CREATE TABLE `userpartner` (
  `user_id` int unsigned NOT NULL AUTO_INCREMENT,
  `p_height_from` int unsigned NOT NULL DEFAULT '0',
  `p_height_to` int unsigned NOT NULL DEFAULT '0',
  `p_weight_from` int unsigned NOT NULL DEFAULT '0',
  `p_weight_to` int unsigned NOT NULL DEFAULT '0',
  `p_relation` bigint unsigned NOT NULL DEFAULT '0',
  `p_body` bigint unsigned NOT NULL DEFAULT '0',
  `p_drinking` bigint unsigned NOT NULL DEFAULT '0',
  `p_ethnicity` bigint unsigned NOT NULL DEFAULT '0',
  `p_eye` bigint unsigned NOT NULL DEFAULT '0',
  `p_religion` bigint unsigned NOT NULL DEFAULT '0',
  `p_family` bigint unsigned NOT NULL DEFAULT '0',
  `p_hair` bigint unsigned NOT NULL DEFAULT '0',
  `p_income` bigint unsigned NOT NULL DEFAULT '0',
  `p_career` bigint unsigned NOT NULL DEFAULT '0',
  `p_smoking` bigint unsigned NOT NULL DEFAULT '0',
  `p_status` bigint unsigned NOT NULL DEFAULT '0',
  `p_education` bigint unsigned NOT NULL DEFAULT '0',
  `p_sexuality` bigint unsigned NOT NULL DEFAULT '0',
  `p_star_sign` bigint unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`user_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;


DROP TABLE IF EXISTS `users`;
CREATE TABLE `users` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `login` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `enemy` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `nowX` smallint DEFAULT NULL,
  `x0` smallint DEFAULT NULL,
  `ingame` enum('yes','no') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'no',
  `time_in` bigint DEFAULT NULL,
  `gender` enum('m','f') COLLATE utf8_unicode_ci DEFAULT NULL,
  `angle` smallint DEFAULT NULL,
  `sila` smallint DEFAULT NULL,
  `upal` enum('yes','no') COLLATE utf8_unicode_ci DEFAULT NULL,
  `popal` enum('yes','no') COLLATE utf8_unicode_ci DEFAULT NULL,
  `active` enum('yes','no') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'no',
  `zernoX` varchar(10) COLLATE utf8_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;


DROP TABLE IF EXISTS `users_block`;
CREATE TABLE `users_block` (
  `id` int NOT NULL AUTO_INCREMENT,
  `user_from` int NOT NULL DEFAULT '0',
  `user_to` int NOT NULL DEFAULT '0',
  `comment` varchar(100) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  PRIMARY KEY (`id`),
  KEY `user_from` (`user_from`),
  KEY `user_to` (`user_to`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;


DROP TABLE IF EXISTS `users_checkbox`;
CREATE TABLE `users_checkbox` (
  `field` int NOT NULL,
  `user_id` int DEFAULT NULL,
  `value` int DEFAULT NULL,
  UNIQUE KEY `field_user_id_value` (`field`,`user_id`,`value`),
  KEY `field` (`field`,`value`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;


DROP TABLE IF EXISTS `users_comments`;
CREATE TABLE `users_comments` (
  `id` mediumint NOT NULL AUTO_INCREMENT,
  `user_id` mediumint NOT NULL DEFAULT '0',
  `from_user_id` mediumint NOT NULL DEFAULT '0',
  `comment` text COLLATE utf8_unicode_ci NOT NULL,
  `date` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;


DROP TABLE IF EXISTS `users_favorite`;
CREATE TABLE `users_favorite` (
  `id` int NOT NULL AUTO_INCREMENT,
  `user_from` int NOT NULL DEFAULT '0',
  `user_to` int NOT NULL DEFAULT '0',
  `comment` varchar(100) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  PRIMARY KEY (`id`),
  KEY `user_from` (`user_from`),
  KEY `user_to` (`user_to`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;


DROP TABLE IF EXISTS `users_flash`;
CREATE TABLE `users_flash` (
  `user_id` int NOT NULL DEFAULT '0' COMMENT 'id of user',
  `backgrounds` text COLLATE utf8_unicode_ci COMMENT 'names upload background',
  PRIMARY KEY (`user_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;


DROP TABLE IF EXISTS `users_interest`;
CREATE TABLE `users_interest` (
  `id` int NOT NULL AUTO_INCREMENT,
  `user_from` int NOT NULL DEFAULT '0',
  `user_to` int NOT NULL DEFAULT '0',
  `new` char(1) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'Y',
  `date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`id`),
  KEY `user_from` (`user_from`),
  KEY `user_to` (`user_to`),
  KEY `user_to_id` (`user_to`,`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;


DROP TABLE IF EXISTS `users_private_note`;
CREATE TABLE `users_private_note` (
  `id` int NOT NULL AUTO_INCREMENT,
  `user_id` int NOT NULL DEFAULT '0',
  `from_user_id` int NOT NULL DEFAULT '0',
  `comment` text COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;


DROP TABLE IF EXISTS `users_reports`;
CREATE TABLE `users_reports` (
  `id` int NOT NULL AUTO_INCREMENT,
  `user_from` int NOT NULL DEFAULT '0',
  `user_to` int NOT NULL DEFAULT '0',
  `msg` text COLLATE utf8_unicode_ci NOT NULL,
  `photo_id` int NOT NULL DEFAULT '0',
  `video` tinyint(1) NOT NULL,
  `wall_id` bigint NOT NULL DEFAULT '0',
  `comment_id` bigint NOT NULL DEFAULT '0',
  `comment_type` enum('photo','video','wall','') COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `group_id` bigint NOT NULL DEFAULT '0',
  `date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  KEY `from_user` (`user_from`),
  KEY `to_user` (`user_to`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;


DROP TABLE IF EXISTS `users_view`;
CREATE TABLE `users_view` (
  `id` int NOT NULL AUTO_INCREMENT,
  `user_from` int NOT NULL DEFAULT '0',
  `user_to` int NOT NULL DEFAULT '0',
  `new` char(1) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'Y',
  `visited` tinyint(1) NOT NULL DEFAULT '0',
  `ref` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `created_at` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `last_email_notification` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`id`),
  KEY `user_from` (`user_from`),
  KEY `user_to` (`user_to`),
  KEY `user_to_id` (`user_to`,`id`),
  KEY `user_from_user_to` (`user_from`,`user_to`),
  KEY `user_from_id` (`user_from`,`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;


DROP TABLE IF EXISTS `users_visitors`;
CREATE TABLE `users_visitors` (
  `id` int NOT NULL AUTO_INCREMENT,
  `user_from` int NOT NULL DEFAULT '0',
  `user_to` int NOT NULL DEFAULT '0',
  `last_visit` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`id`),
  KEY `user_from` (`user_from`),
  KEY `user_to` (`user_to`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;


DROP TABLE IF EXISTS `var_age_preference`;
CREATE TABLE `var_age_preference` (
  `id` int NOT NULL AUTO_INCREMENT,
  `title` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;


DROP TABLE IF EXISTS `var_appearance`;
CREATE TABLE `var_appearance` (
  `id` int NOT NULL AUTO_INCREMENT,
  `title` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;


DROP TABLE IF EXISTS `var_body`;
CREATE TABLE `var_body` (
  `id` int NOT NULL AUTO_INCREMENT,
  `title` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;


DROP TABLE IF EXISTS `var_career`;
CREATE TABLE `var_career` (
  `id` int NOT NULL AUTO_INCREMENT,
  `title` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;


DROP TABLE IF EXISTS `var_drinking`;
CREATE TABLE `var_drinking` (
  `id` int NOT NULL AUTO_INCREMENT,
  `title` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;


DROP TABLE IF EXISTS `var_education`;
CREATE TABLE `var_education` (
  `id` int NOT NULL AUTO_INCREMENT,
  `title` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;


DROP TABLE IF EXISTS `var_ethnicity`;
CREATE TABLE `var_ethnicity` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `title` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;


DROP TABLE IF EXISTS `var_eye`;
CREATE TABLE `var_eye` (
  `id` int NOT NULL AUTO_INCREMENT,
  `title` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;


DROP TABLE IF EXISTS `var_family`;
CREATE TABLE `var_family` (
  `id` int NOT NULL AUTO_INCREMENT,
  `title` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;


DROP TABLE IF EXISTS `var_first_date`;
CREATE TABLE `var_first_date` (
  `id` int NOT NULL AUTO_INCREMENT,
  `title` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;


DROP TABLE IF EXISTS `var_hair`;
CREATE TABLE `var_hair` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;


DROP TABLE IF EXISTS `var_height`;
CREATE TABLE `var_height` (
  `id` int NOT NULL AUTO_INCREMENT,
  `title` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `value_cm` int NOT NULL DEFAULT '0',
  `value_f` float NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;


DROP TABLE IF EXISTS `var_hobbies`;
CREATE TABLE `var_hobbies` (
  `id` int NOT NULL AUTO_INCREMENT,
  `title` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;


DROP TABLE IF EXISTS `var_humor`;
CREATE TABLE `var_humor` (
  `id` int NOT NULL AUTO_INCREMENT,
  `title` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;


DROP TABLE IF EXISTS `var_income`;
CREATE TABLE `var_income` (
  `id` int NOT NULL AUTO_INCREMENT,
  `title` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;


DROP TABLE IF EXISTS `var_language`;
CREATE TABLE `var_language` (
  `id` int NOT NULL AUTO_INCREMENT,
  `title` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;


DROP TABLE IF EXISTS `var_level_of_faith`;
CREATE TABLE `var_level_of_faith` (
  `id` int NOT NULL AUTO_INCREMENT,
  `title` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;


DROP TABLE IF EXISTS `var_live_where`;
CREATE TABLE `var_live_where` (
  `id` int NOT NULL AUTO_INCREMENT,
  `title` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;


DROP TABLE IF EXISTS `var_living_with`;
CREATE TABLE `var_living_with` (
  `id` int NOT NULL AUTO_INCREMENT,
  `title` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;


DROP TABLE IF EXISTS `var_religion`;
CREATE TABLE `var_religion` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `title` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;


DROP TABLE IF EXISTS `var_sexuality`;
CREATE TABLE `var_sexuality` (
  `id` int NOT NULL AUTO_INCREMENT,
  `title` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `default` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;


DROP TABLE IF EXISTS `var_smoking`;
CREATE TABLE `var_smoking` (
  `id` int NOT NULL AUTO_INCREMENT,
  `title` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;


DROP TABLE IF EXISTS `var_spending_habits`;
CREATE TABLE `var_spending_habits` (
  `id` int NOT NULL AUTO_INCREMENT,
  `title` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;


DROP TABLE IF EXISTS `var_star_sign`;
CREATE TABLE `var_star_sign` (
  `id` int NOT NULL AUTO_INCREMENT,
  `title` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;


DROP TABLE IF EXISTS `var_status`;
CREATE TABLE `var_status` (
  `id` int NOT NULL AUTO_INCREMENT,
  `title` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;


DROP TABLE IF EXISTS `var_weight`;
CREATE TABLE `var_weight` (
  `id` int NOT NULL AUTO_INCREMENT,
  `title` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `value_kg` int NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;


DROP TABLE IF EXISTS `video_invite`;
CREATE TABLE `video_invite` (
  `id` int NOT NULL AUTO_INCREMENT,
  `from_user` int NOT NULL DEFAULT '0',
  `to_user` int NOT NULL DEFAULT '0',
  `group_id` bigint NOT NULL DEFAULT '0',
  `city` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;


DROP TABLE IF EXISTS `video_reject`;
CREATE TABLE `video_reject` (
  `id` int NOT NULL AUTO_INCREMENT,
  `from_user` int NOT NULL DEFAULT '0',
  `to_user` int NOT NULL DEFAULT '0',
  `group_id` bigint NOT NULL DEFAULT '0',
  `go` char(1) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `city` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;


DROP TABLE IF EXISTS `vids_category`;
CREATE TABLE `vids_category` (
  `category_id` bigint NOT NULL AUTO_INCREMENT,
  `category_title` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `position` int NOT NULL,
  `check` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`category_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;


DROP TABLE IF EXISTS `vids_comment`;
CREATE TABLE `vids_comment` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `video_id` int unsigned NOT NULL DEFAULT '0',
  `video_user_id` int unsigned NOT NULL DEFAULT '0',
  `group_id` bigint NOT NULL DEFAULT '0',
  `group_user_id` int NOT NULL DEFAULT '0',
  `user_id` int unsigned NOT NULL DEFAULT '0',
  `text` text COLLATE utf8_unicode_ci NOT NULL,
  `dt` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `send` bigint unsigned NOT NULL DEFAULT '0',
  `parent_id` int DEFAULT '0',
  `parent_user_id` int DEFAULT '0',
  `replies` int DEFAULT '0',
  `likes` int NOT NULL DEFAULT '0',
  `last_action_like` datetime NOT NULL,
  `is_new` tinyint(1) NOT NULL DEFAULT '0',
  `is_new_like` tinyint(1) NOT NULL DEFAULT '0',
  `audio_message_id` bigint unsigned NOT NULL,
  `users_reports_comment` text COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`id`),
  KEY `dt` (`dt`),
  KEY `is_new` (`is_new`),
  KEY `parent_id` (`parent_id`),
  KEY `parent_user_id` (`parent_user_id`),
  KEY `video_id_parent_id` (`video_id`,`parent_id`),
  KEY `group_id` (`group_id`),
  KEY `group_user_id` (`group_user_id`),
  KEY `is_new_like` (`is_new_like`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;


DROP TABLE IF EXISTS `vids_comments_likes`;
CREATE TABLE `vids_comments_likes` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `video_id` int NOT NULL,
  `video_user_id` int NOT NULL,
  `group_id` bigint NOT NULL DEFAULT '0',
  `group_user_id` int NOT NULL DEFAULT '0',
  `user_id` int NOT NULL,
  `cid` int NOT NULL,
  `comment_user_id` int NOT NULL,
  `date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `is_new` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `user_id_cid` (`user_id`,`cid`,`video_id`),
  KEY `date` (`date`),
  KEY `is_new` (`is_new`),
  KEY `cid_id` (`cid`,`id`),
  KEY `group_id` (`group_id`),
  KEY `group_user_id` (`group_user_id`),
  KEY `comment_user_id_user_id` (`comment_user_id`,`user_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;


DROP TABLE IF EXISTS `vids_likes`;
CREATE TABLE `vids_likes` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `video_id` int NOT NULL,
  `group_id` bigint unsigned NOT NULL DEFAULT '0',
  `group_user_id` int NOT NULL DEFAULT '0',
  `video_user_id` int NOT NULL,
  `user_id` int NOT NULL,
  `like` tinyint(1) NOT NULL DEFAULT '0',
  `date` datetime NOT NULL,
  `is_new` tinyint(1) NOT NULL DEFAULT '1',
  PRIMARY KEY (`id`),
  UNIQUE KEY `user_id` (`user_id`,`video_id`),
  KEY `is_new` (`is_new`),
  KEY `video_id` (`video_id`,`id`),
  KEY `video_user_id` (`video_user_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;


DROP TABLE IF EXISTS `vids_rate`;
CREATE TABLE `vids_rate` (
  `video_id` int unsigned NOT NULL DEFAULT '0',
  `user_id` mediumint unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`video_id`,`user_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;


DROP TABLE IF EXISTS `vids_subscribe`;
CREATE TABLE `vids_subscribe` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `subscriber_user_id` int unsigned NOT NULL DEFAULT '0',
  `uploader_user_id` int unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;


DROP TABLE IF EXISTS `vids_tags`;
CREATE TABLE `vids_tags` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `tag` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `counter` int NOT NULL,
  PRIMARY KEY (`id`),
  KEY `tag` (`tag`),
  KEY `counter` (`counter`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;


DROP TABLE IF EXISTS `vids_tags_relations`;
CREATE TABLE `vids_tags_relations` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `video_id` int NOT NULL,
  `tag_id` bigint NOT NULL,
  `live_id` int NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `video_id` (`video_id`),
  KEY `tag_id` (`tag_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;


DROP TABLE IF EXISTS `vids_video`;
CREATE TABLE `vids_video` (
  `id` int NOT NULL AUTO_INCREMENT,
  `user_id` int unsigned NOT NULL DEFAULT '0',
  `group_id` bigint NOT NULL DEFAULT '0',
  `group_page` tinyint(1) NOT NULL DEFAULT '0',
  `group_private` enum('Y','N') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'N',
  `dt` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `count_comments` int unsigned NOT NULL DEFAULT '0',
  `count_comments_replies` int unsigned NOT NULL DEFAULT '0',
  `count_views` int unsigned NOT NULL DEFAULT '0',
  `count_rates` int unsigned NOT NULL DEFAULT '0',
  `subject` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `text` text COLLATE utf8_unicode_ci NOT NULL,
  `search_index` text COLLATE utf8_unicode_ci NOT NULL,
  `tags` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `code` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `rating` float NOT NULL DEFAULT '0',
  `active` tinyint unsigned NOT NULL DEFAULT '0',
  `private` tinyint unsigned NOT NULL DEFAULT '0',
  `cat` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `is_uploaded` tinyint(1) NOT NULL DEFAULT '0',
  `users_reports` text COLLATE utf8_unicode_ci NOT NULL,
  `version` int NOT NULL,
  `hide_header` tinyint(1) NOT NULL DEFAULT '0',
  `like` int NOT NULL DEFAULT '0',
  `dislike` int NOT NULL DEFAULT '0',
  `last_action_like` datetime NOT NULL,
  `last_action_comment` datetime NOT NULL,
  `last_action_comment_like` datetime NOT NULL,
  `live_id` int NOT NULL DEFAULT '0',
  `wall_id` bigint NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `hide_header` (`hide_header`),
  KEY `group_id` (`group_id`),
  KEY `live_id` (`live_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;


DROP TABLE IF EXISTS `wall`;
CREATE TABLE `wall` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `date` datetime NOT NULL,
  `user_id` int NOT NULL,
  `group_id` bigint unsigned NOT NULL DEFAULT '0',
  `section` enum('comment','status','friends','pics','pics_comment','photo','photo_comment','photo_default','vids','vids_comment','music','music_photo','music_comment','musician','musician_photo','musician_comment','event_added','event_member','event_comment','event_comment_comment','event_photo','places_review','places_photo','group_join','group_wall','group_wall_comment','group_forum_post','group_forum_post_comment','3dcity','blog_post','blog_comment','forum_thread','forum_post','field_status','share','birthday','interests','group_social_created') COLLATE utf8_unicode_ci NOT NULL,
  `access` enum('public','friends','private') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'public',
  `item_id` int NOT NULL,
  `parent_user_id` int NOT NULL,
  `params_section` text COLLATE utf8_unicode_ci NOT NULL,
  `params` text COLLATE utf8_unicode_ci NOT NULL,
  `comments` int NOT NULL,
  `comments_item` int NOT NULL,
  `likes` int NOT NULL,
  `likes_media` int NOT NULL,
  `hide_from_user` int NOT NULL,
  `comment_user_id` int NOT NULL,
  `site_section` enum('','blog','event','forum','group','music','musician','pics','photo','places','vids','group_social') COLLATE utf8_unicode_ci NOT NULL,
  `site_section_item_id` bigint NOT NULL,
  `last_action_like` datetime NOT NULL,
  `last_action_like_media` datetime NOT NULL,
  `last_action_comment` datetime NOT NULL,
  `last_action_comment_like` datetime NOT NULL,
  `shares_count` int NOT NULL,
  `last_action_shares` datetime NOT NULL,
  `send` bigint unsigned NOT NULL DEFAULT '0',
  `vids_no_load` tinyint(1) NOT NULL DEFAULT '0',
  `users_reports` text COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`id`),
  KEY `user_id` (`user_id`),
  KEY `section_item_id` (`section`,`item_id`),
  KEY `section` (`section`),
  KEY `item_id_section` (`item_id`,`section`),
  KEY `id_section` (`id`,`section`),
  KEY `group_id` (`group_id`),
  KEY `access` (`access`),
  KEY `comment_user_id` (`comment_user_id`),
  KEY `item_id` (`item_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;


DROP TABLE IF EXISTS `wall_comments`;
CREATE TABLE `wall_comments` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `wall_item_id` bigint NOT NULL,
  `wall_item_user_id` int NOT NULL DEFAULT '0',
  `group_id` bigint NOT NULL DEFAULT '0',
  `group_user_id` int NOT NULL DEFAULT '0',
  `user_id` bigint NOT NULL,
  `date` datetime NOT NULL,
  `send` bigint unsigned NOT NULL DEFAULT '0',
  `comment` text COLLATE utf8_unicode_ci NOT NULL,
  `parent_id` bigint DEFAULT '0',
  `parent_user_id` int DEFAULT '0',
  `replies` int DEFAULT '0',
  `likes` int NOT NULL DEFAULT '0',
  `last_action_like` datetime NOT NULL,
  `is_new` tinyint(1) NOT NULL DEFAULT '0',
  `is_new_like` tinyint(1) NOT NULL DEFAULT '0',
  `audio_message_id` bigint unsigned NOT NULL,
  `users_reports_comment` text COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`id`),
  KEY `date` (`date`),
  KEY `is_new` (`is_new`),
  KEY `parent_id` (`parent_id`),
  KEY `parent_user_id` (`parent_user_id`),
  KEY `id_parent_id` (`id`,`parent_id`),
  KEY `wall_item_id_user_id_id` (`wall_item_id`,`user_id`,`id`),
  KEY `group_id` (`group_id`),
  KEY `group_user_id` (`group_user_id`),
  KEY `wall_item_user_id` (`wall_item_user_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;


DROP TABLE IF EXISTS `wall_comments_likes`;
CREATE TABLE `wall_comments_likes` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `wall_item_id` bigint NOT NULL,
  `wall_item_user_id` int NOT NULL,
  `group_id` bigint NOT NULL DEFAULT '0',
  `group_user_id` int NOT NULL DEFAULT '0',
  `user_id` bigint NOT NULL,
  `cid` bigint NOT NULL,
  `parent_id` bigint DEFAULT '0',
  `comment_user_id` int NOT NULL,
  `date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `is_new` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `user_id_cid` (`user_id`,`cid`),
  KEY `date` (`date`),
  KEY `is_new` (`is_new`),
  KEY `cid_id` (`cid`,`id`),
  KEY `group_id` (`group_id`),
  KEY `group_user_id` (`group_user_id`),
  KEY `comment_user_id_user_id` (`comment_user_id`,`user_id`),
  KEY `user_id_wall_item_id_cid` (`user_id`,`wall_item_id`,`cid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;


DROP TABLE IF EXISTS `wall_comments_viewed`;
CREATE TABLE `wall_comments_viewed` (
  `user_id` int DEFAULT NULL,
  `item_id` bigint DEFAULT NULL,
  `id` bigint DEFAULT NULL,
  KEY `user_id` (`user_id`),
  KEY `item_id` (`item_id`),
  KEY `user_id_item_id_id` (`user_id`,`item_id`,`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;


DROP TABLE IF EXISTS `wall_items_for_user`;
CREATE TABLE `wall_items_for_user` (
  `user_id` int NOT NULL,
  `group_id` bigint unsigned NOT NULL DEFAULT '0',
  `item_id` bigint NOT NULL,
  `section` enum('blog','event','forum','group','music','musician','pics','photo','places','vids','group_social') COLLATE utf8_unicode_ci NOT NULL,
  `created_at` datetime NOT NULL,
  UNIQUE KEY `user_id` (`user_id`,`item_id`,`section`),
  KEY `item_id` (`item_id`,`section`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;


DROP TABLE IF EXISTS `wall_likes`;
CREATE TABLE `wall_likes` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `group_id` bigint unsigned NOT NULL DEFAULT '0',
  `user_id` int NOT NULL,
  `wall_item_id` int NOT NULL,
  `wall_item_user_id` int NOT NULL,
  `date` datetime NOT NULL,
  `is_new` tinyint(1) NOT NULL DEFAULT '1',
  PRIMARY KEY (`id`),
  UNIQUE KEY `user_id` (`user_id`,`wall_item_id`),
  KEY `wall_item_id_id` (`wall_item_id`,`id`),
  KEY `is_new` (`is_new`),
  KEY `wall_item_user_id_user_id` (`wall_item_user_id`,`user_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;


DROP TABLE IF EXISTS `wall_stats`;
CREATE TABLE `wall_stats` (
  `id` int NOT NULL AUTO_INCREMENT,
  `user_id` int NOT NULL,
  `wall_posts` int NOT NULL DEFAULT '0',
  `shared_posts` int NOT NULL DEFAULT '0',
  `comments` int NOT NULL DEFAULT '0',
  `date` date NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;


DROP TABLE IF EXISTS `widgets`;
CREATE TABLE `widgets` (
  `user_id` int NOT NULL DEFAULT '0',
  `widget` int NOT NULL DEFAULT '0',
  `status` tinyint(1) NOT NULL DEFAULT '0',
  `open` tinyint(1) NOT NULL DEFAULT '0',
  `x` int NOT NULL DEFAULT '0',
  `y` int NOT NULL DEFAULT '0',
  `z` int NOT NULL DEFAULT '0',
  `settings` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `session` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `session_date` datetime NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;