SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
START TRANSACTION;
SET time_zone = "+00:00";


CREATE TABLE `users` (
  `id` int(10) UNSIGNED NOT NULL,
  `gcm_regid` text DEFAULT NULL,
  `ios_fcm_regid` text DEFAULT NULL,
  `android_msg_fcm_regid` text DEFAULT NULL,
  `ios_msg_fcm_regid` text DEFAULT NULL,
  `referrer` int(10) UNSIGNED DEFAULT 0,
  `purchases_count` int(10) UNSIGNED DEFAULT 0,
  `referrals_count` int(10) UNSIGNED DEFAULT 0,
  `mood` int(10) UNSIGNED DEFAULT 0,
  `admob` int(10) UNSIGNED DEFAULT 1,
  `ghost` int(10) UNSIGNED DEFAULT 0,
  `pro` int(10) UNSIGNED DEFAULT 0,
  `pro_create_at` int(10) UNSIGNED DEFAULT 0,
  `gcm` int(10) UNSIGNED DEFAULT 1,
  `state` int(10) UNSIGNED DEFAULT 0,
  `access_level` int(10) UNSIGNED DEFAULT 0,
  `account_type` int(10) UNSIGNED DEFAULT 0,
  `account_category` int(10) UNSIGNED DEFAULT 0,
  `account_author` int(10) UNSIGNED DEFAULT 0,
  `surname` varchar(75) NOT NULL DEFAULT '',
  `fullname` varchar(150) NOT NULL DEFAULT '',
  `salt` char(3) NOT NULL DEFAULT '',
  `passw` varchar(32) NOT NULL DEFAULT '',
  `login` varchar(50) NOT NULL DEFAULT '',
  `email` varchar(64) NOT NULL DEFAULT '',
  `lang` char(10) DEFAULT 'en',
  `language` char(10) DEFAULT 'en',
  `bYear` smallint(6) UNSIGNED DEFAULT 2000,
  `bMonth` smallint(6) UNSIGNED DEFAULT 0,
  `bDay` smallint(6) UNSIGNED DEFAULT 1,
  `status` varchar(500) NOT NULL DEFAULT '',
  `country` varchar(30) NOT NULL DEFAULT '',
  `country_id` int(10) UNSIGNED DEFAULT 0,
  `city` varchar(50) NOT NULL DEFAULT '',
  `city_id` int(10) UNSIGNED DEFAULT 0,
  `lat` float(10,6) DEFAULT 0.000000,
  `lng` float(10,6) DEFAULT 0.000000,
  `vk_page` varchar(150) NOT NULL DEFAULT '',
  `fb_page` varchar(150) NOT NULL DEFAULT '',
  `tw_page` varchar(150) NOT NULL DEFAULT '',
  `my_page` varchar(150) NOT NULL DEFAULT '',
  `phone` varchar(30) NOT NULL DEFAULT '',
  `verify` smallint(6) UNSIGNED DEFAULT 0,
  `removed` smallint(6) UNSIGNED DEFAULT 0,
  `vk_id` varchar(40) DEFAULT '0',
  `fb_id` varchar(40) DEFAULT '0',
  `gl_id` varchar(40) DEFAULT '0',
  `tw_id` varchar(40) DEFAULT '0',
  `regtime` int(10) UNSIGNED DEFAULT 0,
  `lasttime` int(10) UNSIGNED DEFAULT 0,
  `posts_count` int(11) UNSIGNED DEFAULT 0,
  `likes_count` int(11) UNSIGNED DEFAULT 0,
  `photos_count` int(11) UNSIGNED DEFAULT 0,
  `gallery_items_count` int(11) UNSIGNED DEFAULT 0,
  `videos_count` int(11) UNSIGNED DEFAULT 0,
  `gifts_count` int(11) UNSIGNED DEFAULT 0,
  `followers_count` int(11) UNSIGNED DEFAULT 0,
  `following_count` int(11) UNSIGNED DEFAULT 0,
  `friends_count` int(11) UNSIGNED DEFAULT 0,
  `rating` int(11) UNSIGNED DEFAULT 0,
  `balance` int(11) UNSIGNED DEFAULT 0,
  `sex` smallint(6) UNSIGNED DEFAULT 0,
  `age` smallint(6) UNSIGNED DEFAULT 18,
  `last_notify_view` int(10) UNSIGNED DEFAULT 0,
  `last_friends_view` int(10) UNSIGNED DEFAULT 0,
  `last_feed_view` int(10) UNSIGNED DEFAULT 0,
  `last_guests_view` int(10) UNSIGNED DEFAULT 0,
  `last_authorize` int(10) UNSIGNED DEFAULT 0,
  `ip_addr` char(32) NOT NULL DEFAULT '',
  `allowComments` smallint(6) UNSIGNED DEFAULT 1,
  `allowPhotosComments` smallint(6) UNSIGNED DEFAULT 1,
  `allowVideoComments` smallint(6) UNSIGNED DEFAULT 1,
  `allowGalleryComments` smallint(6) UNSIGNED DEFAULT 1,
  `allowMessages` smallint(6) UNSIGNED DEFAULT 1,
  `allowPosts` smallint(6) UNSIGNED DEFAULT 1,
  `allowShowOnline` smallint(6) UNSIGNED DEFAULT 1,
  `allowLikesGCM` smallint(6) UNSIGNED DEFAULT 1,
  `allowCommentsGCM` smallint(6) UNSIGNED DEFAULT 1,
  `allowFollowersGCM` smallint(6) UNSIGNED DEFAULT 1,
  `allowMessagesGCM` smallint(6) UNSIGNED DEFAULT 1,
  `allowCommentReplyGCM` smallint(6) UNSIGNED DEFAULT 1,
  `allowGiftsGCM` smallint(6) UNSIGNED DEFAULT 1,
  `allowShowMyInfo` smallint(6) UNSIGNED DEFAULT 0,
  `allowShowMyPhotos` smallint(6) UNSIGNED DEFAULT 0,
  `allowShowMyVideos` smallint(6) UNSIGNED DEFAULT 0,
  `allowShowMyGallery` smallint(6) UNSIGNED DEFAULT 0,
  `allowShowMyFriends` smallint(6) UNSIGNED DEFAULT 0,
  `allowShowMyGifts` smallint(6) UNSIGNED DEFAULT 0,
  `allowShowMyAgeAndGender` smallint(6) UNSIGNED DEFAULT 0,
  `lowPhotoUrl` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT '',
  `originPhotoUrl` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT '',
  `normalPhotoUrl` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT '',
  `bigPhotoUrl` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT '',
  `originCoverUrl` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT '',
  `normalCoverUrl` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT '',
  `coverPosition` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT '0px 0px',
  `photoModerateAt` int(11) UNSIGNED DEFAULT 0,
  `photoModerateUrl` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT '',
  `photoPostModerateAt` int(11) UNSIGNED DEFAULT 0,
  `coverModerateAt` int(11) UNSIGNED DEFAULT 0,
  `coverModerateUrl` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT '',
  `coverPostModerateAt` int(11) UNSIGNED DEFAULT 0,
  `code` int(11) NOT NULL,
  `date` text NOT NULL,
  `school` text NOT NULL,
  `fatherjob` text NOT NULL,
  `major` text NOT NULL,
  `motherjob` text NOT NULL,
  `sisterjob` text NOT NULL,
  `brotherjob` text NOT NULL,
  `paye` text NOT NULL,
  `fathertahsil` text NOT NULL,
  `mothertahsil` text NOT NULL,
  `iq` text NOT NULL,
  `rank` text NOT NULL,
  `teaching` text NOT NULL,
  `scientificclasses` text NOT NULL,
  `computergames` text NOT NULL,
  `mobilegames` text NOT NULL,
  `classes` text NOT NULL,
  `socialnets` text NOT NULL,
  `music` text NOT NULL,
  `book` text NOT NULL,
  `film` text NOT NULL,
  `job` text NOT NULL,
  `friend1` text NOT NULL,
  `friend2` text NOT NULL,
  `friend3` text NOT NULL,
  `writebook` text NOT NULL,
  `migration` text NOT NULL,
  `olgoo` text NOT NULL,
  `shahid` text NOT NULL,
  `describemeeting` text NOT NULL,
  `readlesson` text NOT NULL,
  `readnolesson` text NOT NULL,
  `mobileusage` text NOT NULL,
  `target` text NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;


--
-- Indexes for table `users`
--
ALTER TABLE `users`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `login` (`login`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `users`
--
ALTER TABLE `users`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=11;
COMMIT;

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;