Файл: hashtag.io-2629a1a4ea078149b002e45e2e12bb946062c2b8/hashtag.sql
Строк: 1183
-- phpMyAdmin SQL Dump
-- version 4.5.1
-- http://www.phpmyadmin.net
--
--
Host: 127.0.0.1
-- Generation Time: Jul 31, 2017 at 02:02 PM
-- Server
version: 10.1.19-MariaDB
-- PHP Version: 5.6.28
SET SQL_MODE =
"NO_AUTO_VALUE_ON_ZERO";
SET time_zone =
"+00:00";
/*!40101 SET
@OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET
@OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET
@OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES
utf8mb4 */;
--
-- Database: `instagram`
--
--
--------------------------------------------------------
--
-- Table
structure for table `audio_post`
--
CREATE TABLE `audio_post` (
`audio_post_Id` int(11) NOT NULL,
`post_id` int(11) NOT NULL,
`audio`
varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`about` varchar(255)
COLLATE utf8mb4_unicode_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4
COLLATE=utf8mb4_unicode_ci;
--
--------------------------------------------------------
--
-- Table
structure for table `block`
--
CREATE TABLE `block` (
`block_id` int(11)
NOT NULL,
`block_by` int(11) NOT NULL,
`block_to` int(11) NOT NULL,
`time` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4
COLLATE=utf8mb4_unicode_ci;
--
--------------------------------------------------------
--
-- Table
structure for table `bookmarks`
--
CREATE TABLE `bookmarks` (
`bkmrk_id`
int(11) NOT NULL,
`post_id` int(11) NOT NULL,
`user_id` int(11) NOT
NULL,
`bookmark_time` datetime NOT NULL
) ENGINE=InnoDB DEFAULT
CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
--
-- Dumping data for table
`bookmarks`
--
INSERT INTO `bookmarks` (`bkmrk_id`, `post_id`, `user_id`,
`bookmark_time`) VALUES
(5, 11, 139, '2017-07-30 01:14:40'),
(7, 10, 139,
'2017-07-30 01:37:57');
--
--------------------------------------------------------
--
-- Table
structure for table `comment_likes`
--
CREATE TABLE `comment_likes` (
`comment_like_id` int(11) NOT NULL,
`like_by` int(11) NOT NULL,
`comment_id` int(11) NOT NULL,
`time` datetime NOT NULL
) ENGINE=InnoDB
DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
--
-- Dumping data for
table `comment_likes`
--
INSERT INTO `comment_likes` (`comment_like_id`,
`like_by`, `comment_id`, `time`) VALUES
(4, 139, 5, '2017-07-30
00:51:34');
--
--------------------------------------------------------
--
-- Table
structure for table `conversations`
--
CREATE TABLE `conversations` (
`con_id` int(11) NOT NULL,
`name` varchar(255) COLLATE utf8mb4_unicode_ci
NOT NULL,
`user_one` int(11) NOT NULL,
`user_two` int(11) NOT NULL,
`comb_users` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`time`
datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4
COLLATE=utf8mb4_unicode_ci;
--
-- Dumping data for table
`conversations`
--
INSERT INTO `conversations` (`con_id`, `name`,
`user_one`, `user_two`, `comb_users`, `time`) VALUES
(1, 'aa', 139, 224,
'139,224', '2017-07-30 00:58:07'),
(2, 'my con name', 139, 144, '139,144',
'2017-07-30 00:58:25');
--
--------------------------------------------------------
--
-- Table
structure for table `doc_post`
--
CREATE TABLE `doc_post` (
`doc_post_id` int(11) NOT NULL,
`post_id` int(11) NOT NULL,
`doc`
varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`about` longtext
COLLATE utf8mb4_unicode_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4
COLLATE=utf8mb4_unicode_ci;
--
--------------------------------------------------------
--
-- Table
structure for table `email_private`
--
CREATE TABLE `email_private` (
`e_p_id` int(11) NOT NULL,
`user_id` int(11) NOT NULL,
`options`
enum('public','private') COLLATE utf8mb4_unicode_ci NOT NULL
)
ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
--
--
Dumping data for table `email_private`
--
INSERT INTO `email_private`
(`e_p_id`, `user_id`, `options`) VALUES
(24, 139, 'public'),
(25, 140,
'public'),
(26, 141, 'public'),
(27, 142, 'public'),
(28, 143,
'public'),
(29, 144, 'public'),
(30, 145, 'public'),
(31, 146,
'public'),
(32, 147, 'public'),
(33, 148, 'public'),
(34, 149,
'public'),
(35, 150, 'public'),
(36, 151, 'public'),
(37, 152,
'public'),
(38, 153, 'public'),
(39, 154, 'public'),
(40, 155,
'public'),
(41, 156, 'public'),
(42, 157, 'public'),
(43, 158,
'public'),
(44, 159, 'public'),
(45, 160, 'public'),
(46, 161,
'public'),
(47, 162, 'public'),
(48, 163, 'public'),
(49, 164,
'public'),
(50, 165, 'public'),
(51, 166, 'public'),
(52, 167,
'public'),
(53, 168, 'public'),
(54, 169, 'public'),
(55, 170,
'public'),
(56, 171, 'public'),
(57, 172, 'public'),
(58, 173,
'public'),
(59, 174, 'public'),
(60, 175, 'public'),
(61, 176,
'public'),
(62, 177, 'public'),
(63, 178, 'public'),
(64, 179,
'public'),
(65, 180, 'public'),
(66, 181, 'public'),
(67, 182,
'public'),
(68, 183, 'public'),
(69, 184, 'public'),
(70, 185,
'public'),
(71, 186, 'public'),
(72, 187, 'public'),
(73, 188,
'public'),
(74, 189, 'public'),
(75, 190, 'public'),
(76, 191,
'public'),
(77, 192, 'public'),
(78, 193, 'public'),
(79, 194,
'public'),
(80, 195, 'public'),
(81, 196, 'public'),
(82, 197,
'public'),
(83, 198, 'public'),
(84, 199, 'public'),
(87, 206,
'public'),
(88, 207, 'public'),
(89, 208, 'public'),
(90, 209,
'public'),
(91, 210, 'public'),
(92, 211, 'public'),
(93, 212,
'public'),
(94, 213, 'public'),
(95, 214, 'public'),
(96, 215,
'public'),
(97, 216, 'public'),
(98, 217, 'public'),
(99, 218,
'public'),
(100, 219, 'public'),
(101, 220, 'public'),
(102, 221,
'public'),
(103, 222, 'public'),
(104, 223, 'public'),
(105, 224,
'public'),
(106, 227, 'public'),
(107, 228, 'public'),
(108, 230,
'public'),
(109, 232, 'public');
--
--------------------------------------------------------
--
-- Table
structure for table `favourites`
--
CREATE TABLE `favourites` (
`fav_id`
int(11) NOT NULL,
`fav_by` int(11) NOT NULL,
`user` int(11) NOT NULL,
`time` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4
COLLATE=utf8mb4_unicode_ci;
--
-- Dumping data for table
`favourites`
--
INSERT INTO `favourites` (`fav_id`, `fav_by`, `user`,
`time`) VALUES
(1, 139, 187, '2017-07-30 01:19:45'),
(2, 139, 144,
'2017-07-30 01:40:37');
--
--------------------------------------------------------
--
-- Table
structure for table `follow_system`
--
CREATE TABLE `follow_system` (
`follow_id` int(11) NOT NULL,
`follow_by` int(11) NOT NULL,
`follow_by_u` varchar(255) NOT NULL,
`follow_to` int(11) NOT NULL,
`follow_to_u` varchar(255) NOT NULL,
`time` datetime NOT NULL
)
ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Dumping data for table
`follow_system`
--
INSERT INTO `follow_system` (`follow_id`, `follow_by`,
`follow_by_u`, `follow_to`, `follow_to_u`, `time`) VALUES
(1, 139,
'takkar', 224, 'coldplay', '2017-07-03 01:54:41'),
(3, 139, 'takkar', 141,
'modi', '2017-07-03 01:54:50'),
(5, 139, 'takkar', 143, 'selenagomez',
'2017-07-03 16:10:47'),
(6, 139, 'takkar', 145, 'nfak', '2017-07-03
16:10:53'),
(8, 139, 'takkar', 166, 'pikachu', '2017-07-03 16:57:52'),
(9,
139, 'takkar', 195, 'snape', '2017-07-03 17:14:10'),
(10, 139, 'takkar',
175, 'looney_tunes', '2017-07-03 17:14:12'),
(11, 139, 'takkar', 182,
'oswald', '2017-07-03 17:14:14'),
(12, 182, 'oswald', 139, 'takkar',
'2017-07-03 17:16:46'),
(13, 139, 'takkar', 227, 'Netherlands', '2017-07-03
19:54:17'),
(14, 227, 'Netherlands', 139, 'takkar', '2017-07-03
19:54:32'),
(15, 227, 'Netherlands', 186, 'harrypotter', '2017-07-03
21:18:32'),
(16, 227, 'Netherlands', 145, 'nfak', '2017-07-03
21:18:38'),
(17, 227, 'Netherlands', 154, 'voldemort', '2017-07-03
21:18:40'),
(18, 227, 'Netherlands', 140, 'zayn', '2017-07-03
21:18:45'),
(19, 139, 'takkar', 187, 'harmoine', '2017-07-30
00:56:11'),
(21, 139, 'takkar', 206, 'ISRO', '2017-07-30 01:05:28'),
(22,
187, 'harmoine', 139, 'takkar', '2017-07-30 01:06:05'),
(23, 139, 'takkar',
151, 'shaktiman', '2017-07-30 01:16:39'),
(24, 139, 'takkar', 186,
'harrypotter', '2017-07-30 01:16:41'),
(25, 144, 'ghalib', 142,
'taylor_swift', '2017-07-30 01:20:52'),
(28, 139, 'takkar', 144, 'ghalib',
'2017-07-30 03:47:15'),
(39, 144, 'ghalib', 187, 'harmoine', '2017-07-30
03:52:56');
--
--------------------------------------------------------
--
-- Table
structure for table `groups`
--
CREATE TABLE `groups` (
`group_id`
int(11) NOT NULL,
`grp_name` varchar(255) COLLATE utf8mb4_unicode_ci NOT
NULL,
`grp_bio` varchar(1000) COLLATE utf8mb4_unicode_ci NOT NULL,
`grp_avatar` text COLLATE utf8mb4_unicode_ci NOT NULL,
`grp_admin`
int(11) NOT NULL,
`grp_privacy` enum('public','private') COLLATE
utf8mb4_unicode_ci NOT NULL DEFAULT 'public',
`grp_time` datetime NOT
NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4
COLLATE=utf8mb4_unicode_ci;
--
-- Dumping data for table
`groups`
--
INSERT INTO `groups` (`group_id`, `grp_name`, `grp_bio`,
`grp_avatar`, `grp_admin`, `grp_privacy`, `grp_time`) VALUES
(3, 'Hello',
'India and the world!!', '1501356405.jpg', 139, 'private', '2017-07-30
00:56:39'),
(4, 'Hello', 'Bio of group!!', '1501357704.jpg', 139, 'public',
'2017-07-30 01:17:33'),
(5, 'Hello', 'ww', '1501359072.jpg', 139, 'public',
'2017-07-30 01:41:04');
--
--------------------------------------------------------
--
-- Table
structure for table `group_con`
--
CREATE TABLE `group_con` (
`grp_con_id` int(11) NOT NULL,
`name` varchar(255) COLLATE
utf8mb4_unicode_ci NOT NULL,
`avatar` text COLLATE utf8mb4_unicode_ci NOT
NULL,
`time` datetime NOT NULL,
`admin` int(11) NOT NULL
)
ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
--
--
Dumping data for table `group_con`
--
INSERT INTO `group_con`
(`grp_con_id`, `name`, `avatar`, `time`, `admin`) VALUES
(5, 'my group',
'1501356566.jpg', '2017-07-30 00:59:08', 144);
--
--------------------------------------------------------
--
-- Table
structure for table `group_con_members`
--
CREATE TABLE
`group_con_members` (
`grp_con_mem_id` int(11) NOT NULL,
`grp_con_id`
int(11) NOT NULL,
`members` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT
CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
--
-- Dumping data for table
`group_con_members`
--
INSERT INTO `group_con_members` (`grp_con_mem_id`,
`grp_con_id`, `members`) VALUES
(9, 5, 139),
(10, 5, 143),
(11, 5,
224),
(12, 5, 144),
(13, 5, 145),
(14, 5, 166),
(15, 5, 195);
--
--------------------------------------------------------
--
-- Table
structure for table `group_members`
--
CREATE TABLE `group_members` (
`group_mem_id` int(11) NOT NULL,
`group_id` int(11) NOT NULL,
`group_member` int(11) NOT NULL,
`added_by` int(11) NOT NULL,
`time`
datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4
COLLATE=utf8mb4_unicode_ci;
--
-- Dumping data for table
`group_members`
--
INSERT INTO `group_members` (`group_mem_id`,
`group_id`, `group_member`, `added_by`, `time`) VALUES
(7, 3, 139, 139,
'2017-07-30 00:56:39'),
(10, 3, 143, 139, '2017-07-30 00:56:53'),
(11, 3,
144, 144, '2017-07-30 01:01:35'),
(12, 4, 139, 139, '2017-07-30
01:17:33'),
(13, 4, 144, 139, '2017-07-30 01:17:39'),
(15, 4, 143, 139,
'2017-07-30 01:17:43'),
(16, 5, 139, 139, '2017-07-30 01:41:04'),
(17, 5,
144, 139, '2017-07-30 01:41:16'),
(18, 5, 224, 139, '2017-07-30
01:41:18'),
(19, 5, 143, 139, '2017-07-30 01:41:21');
--
--------------------------------------------------------
--
-- Table
structure for table `grpconunreads`
--
CREATE TABLE `grpconunreads` (
`gru_id` int(11) NOT NULL,
`grp_con_id` int(11) NOT NULL,
`gcu_by`
int(11) NOT NULL,
`member` int(11) NOT NULL,
`gcu_mssg` int(11) NOT
NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4
COLLATE=utf8mb4_unicode_ci;
--
-- Dumping data for table
`grpconunreads`
--
INSERT INTO `grpconunreads` (`gru_id`, `grp_con_id`,
`gcu_by`, `member`, `gcu_mssg`) VALUES
(5, 5, 139, 143, 15),
(6, 5, 139,
143, 16),
(7, 5, 139, 143, 17),
(8, 5, 139, 224, 17),
(9, 5, 139, 143,
18),
(10, 5, 139, 224, 18),
(12, 5, 139, 143, 19),
(13, 5, 139, 224,
19),
(15, 5, 139, 145, 19),
(16, 5, 139, 143, 20),
(17, 5, 139, 224,
20),
(19, 5, 139, 145, 20),
(20, 5, 139, 166, 20),
(21, 5, 139, 143,
21),
(22, 5, 139, 224, 21),
(24, 5, 139, 145, 21),
(25, 5, 139, 166,
21),
(26, 5, 139, 195, 21),
(27, 5, 139, 143, 22),
(28, 5, 139, 224,
22),
(30, 5, 139, 145, 22),
(31, 5, 139, 166, 22),
(32, 5, 139, 195,
22),
(33, 5, 139, 143, 23),
(34, 5, 139, 224, 23),
(36, 5, 139, 145,
23),
(37, 5, 139, 166, 23),
(38, 5, 139, 195, 23),
(39, 5, 139, 143,
24),
(40, 5, 139, 224, 24),
(42, 5, 139, 145, 24),
(43, 5, 139, 166,
24),
(44, 5, 139, 195, 24),
(45, 5, 139, 143, 25),
(46, 5, 139, 224,
25),
(48, 5, 139, 145, 25),
(49, 5, 139, 166, 25),
(50, 5, 139, 195,
25),
(51, 5, 139, 143, 26),
(52, 5, 139, 224, 26),
(54, 5, 139, 145,
26),
(55, 5, 139, 166, 26),
(56, 5, 139, 195, 26),
(58, 5, 144, 143,
27),
(59, 5, 144, 224, 27),
(60, 5, 144, 145, 27),
(61, 5, 144, 166,
27),
(62, 5, 144, 195, 27),
(63, 5, 139, 143, 28),
(64, 5, 139, 224,
28),
(66, 5, 139, 145, 28),
(67, 5, 139, 166, 28),
(68, 5, 139, 195,
28),
(69, 5, 139, 143, 29),
(70, 5, 139, 224, 29),
(72, 5, 139, 145,
29),
(73, 5, 139, 166, 29),
(74, 5, 139, 195, 29),
(75, 5, 139, 143,
30),
(76, 5, 139, 224, 30),
(78, 5, 139, 145, 30),
(79, 5, 139, 166,
30),
(80, 5, 139, 195, 30);
--
--------------------------------------------------------
--
-- Table
structure for table `hashtag`
--
CREATE TABLE `hashtag` (
`hashtag_id`
int(11) NOT NULL,
`hashtag` varchar(255) COLLATE utf8mb4_unicode_ci NOT
NULL,
`src` enum('post','post_comment') COLLATE utf8mb4_unicode_ci NOT
NULL,
`post_id` int(11) NOT NULL,
`comment_id` int(11) NOT NULL,
`user_id` int(11) NOT NULL,
`time` datetime NOT NULL
) ENGINE=InnoDB
DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
--
--------------------------------------------------------
--
-- Table
structure for table `image_post`
--
CREATE TABLE `image_post` (
`image_post_id` int(11) NOT NULL,
`post_id` int(11) NOT NULL,
`image`
varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`about` longtext
COLLATE utf8mb4_unicode_ci NOT NULL,
`filter` varchar(100) COLLATE
utf8mb4_unicode_ci NOT NULL DEFAULT 'normal'
) ENGINE=InnoDB DEFAULT
CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
--
-- Dumping data for table
`image_post`
--
INSERT INTO `image_post` (`image_post_id`, `post_id`,
`image`, `about`, `filter`) VALUES
(4, 9, '1499101610.jpg', '', ''),
(5,
11, '1501356005.png', '', ''),
(6, 17, '1501356770.jpg', '', '');
--
--------------------------------------------------------
--
-- Table
structure for table `invitegrp`
--
CREATE TABLE `invitegrp` (
`inviteGrpId` int(11) NOT NULL,
`inviteGrp` int(11) NOT NULL,
`inviteGrpBy` int(11) NOT NULL,
`inviteGrpTo` int(11) NOT NULL,
`inviteGrpTime` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4
COLLATE=utf8mb4_unicode_ci;
--
--------------------------------------------------------
--
-- Table
structure for table `link_post`
--
CREATE TABLE `link_post` (
`link_post_id` int(11) NOT NULL,
`post_id` int(11) NOT NULL,
`text`
longtext COLLATE utf8mb4_unicode_ci NOT NULL,
`link_url` varchar(1000)
COLLATE utf8mb4_unicode_ci NOT NULL,
`link_title` varchar(255) COLLATE
utf8mb4_unicode_ci NOT NULL,
`link_src` varchar(255) COLLATE
utf8mb4_unicode_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4
COLLATE=utf8mb4_unicode_ci;
--
--------------------------------------------------------
--
-- Table
structure for table `loc_post`
--
CREATE TABLE `loc_post` (
`loc_post_id` int(11) NOT NULL,
`post_id` int(11) NOT NULL,
`loc`
varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`about` longtext
COLLATE utf8mb4_unicode_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4
COLLATE=utf8mb4_unicode_ci;
--
--------------------------------------------------------
--
-- Table
structure for table `login`
--
CREATE TABLE `login` (
`login_id` int(11)
NOT NULL,
`user_id` int(11) NOT NULL,
`ip` varchar(255) COLLATE
utf8mb4_unicode_ci NOT NULL,
`time` datetime NOT NULL,
`os`
varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`browser` varchar(255)
COLLATE utf8mb4_unicode_ci NOT NULL,
`logout` datetime NOT NULL
)
ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
--
--
Dumping data for table `login`
--
INSERT INTO `login` (`login_id`,
`user_id`, `ip`, `time`, `os`, `browser`, `logout`) VALUES
(1, 139, '1',
'2017-07-03 01:50:46', 'Windows 10', 'Chrome', '2017-07-03 16:11:08'),
(2,
144, '1', '2017-07-03 16:11:19', 'Windows 10', 'Chrome', '2017-07-03
16:46:39'),
(3, 139, '1', '2017-07-03 16:53:37', 'Windows 10', 'Chrome',
'2017-07-03 17:16:18'),
(4, 182, '1', '2017-07-03 17:16:41', 'Windows 10',
'Chrome', '2017-07-03 17:19:32'),
(5, 139, '1', '2017-07-03 19:52:42',
'Windows 10', 'Chrome', '2017-07-03 19:54:22'),
(6, 227, '1', '2017-07-03
19:54:27', 'Windows 10', 'Chrome', '2017-07-03 22:36:13'),
(7, 149, '1',
'2017-07-03 22:36:25', 'Windows 10', 'Chrome', '2017-07-30 00:35:34'),
(8,
139, '1', '2017-07-03 22:36:58', 'Windows 10', 'Chrome', '2017-07-03
23:06:50'),
(9, 139, '1', '2017-07-05 16:28:18', 'Windows 10', 'Chrome',
'0000-00-00 00:00:00'),
(10, 139, '1', '2017-07-23 21:49:50', 'Windows 10',
'Chrome', '0000-00-00 00:00:00'),
(11, 139, '1', '2017-07-25 22:54:35',
'Windows 10', 'Chrome', '0000-00-00 00:00:00'),
(12, 139, '1', '2017-07-29
01:15:14', 'Windows 10', 'Firefox', '0000-00-00 00:00:00'),
(13, 144, '1',
'2017-07-30 00:35:43', 'Windows 10', 'Chrome', '2017-07-30 00:38:56'),
(14,
139, '1', '2017-07-30 00:39:04', 'Windows 10', 'Chrome', '2017-07-30
00:39:52'),
(15, 139, '1', '2017-07-30 00:42:11', 'Windows 10', 'Chrome',
'2017-07-30 00:49:07'),
(16, 144, '1', '2017-07-30 00:49:12', 'Windows 10',
'Chrome', '2017-07-30 00:50:50'),
(17, 139, '1', '2017-07-30 00:51:09',
'Windows 10', 'Chrome', '2017-07-30 01:00:39'),
(18, 144, '1', '2017-07-30
01:00:44', 'Windows 10', 'Chrome', '2017-07-30 01:02:01'),
(19, 139, '1',
'2017-07-30 01:02:23', 'Windows 10', 'Chrome', '2017-07-30 01:03:18'),
(20,
139, '1', '2017-07-30 01:03:24', 'Windows 10', 'Chrome', '2017-07-30
01:05:49'),
(21, 187, '1', '2017-07-30 01:05:58', 'Windows 10', 'Chrome',
'2017-07-30 01:06:12'),
(22, 139, '1', '2017-07-30 01:14:33', 'Windows 10',
'Chrome', '2017-07-30 01:19:59'),
(23, 144, '1', '2017-07-30 01:20:04',
'Windows 10', 'Chrome', '2017-07-30 01:21:20'),
(24, 139, '1', '2017-07-30
01:24:42', 'Windows 10', 'Chrome', '2017-07-30 01:27:16'),
(25, 139, '1',
'2017-07-30 01:27:22', 'Windows 10', 'Chrome', '2017-07-30 01:28:13'),
(26,
144, '1', '2017-07-30 01:28:18', 'Windows 10', 'Chrome', '2017-07-30
01:30:05'),
(27, 139, '1', '2017-07-30 01:30:10', 'Windows 10', 'Chrome',
'2017-07-30 01:37:24'),
(28, 139, '1', '2017-07-30 01:37:29', 'Windows 10',
'Chrome', '2017-07-30 01:41:57'),
(29, 144, '1', '2017-07-30 01:42:01',
'Windows 10', 'Chrome', '2017-07-30 01:42:16'),
(30, 187, '1', '2017-07-30
01:42:22', 'Windows 10', 'Chrome', '2017-07-30 01:42:39'),
(31, 144, '1',
'2017-07-30 01:42:44', 'Windows 10', 'Chrome', '2017-07-30 01:43:40'),
(32,
144, '1', '2017-07-30 01:43:45', 'Windows 10', 'Chrome', '2017-07-30
01:44:30'),
(33, 139, '1', '2017-07-30 01:44:34', 'Windows 10', 'Chrome',
'2017-07-30 01:44:44'),
(34, 144, '1', '2017-07-30 01:44:49', 'Windows 10',
'Chrome', '2017-07-30 01:45:02'),
(35, 144, '1', '2017-07-30 01:45:16',
'Windows 10', 'Chrome', '2017-07-30 01:45:24'),
(36, 139, '1', '2017-07-30
03:47:04', 'Windows 10', 'Chrome', '2017-07-30 03:47:25'),
(37, 144, '1',
'2017-07-30 03:47:31', 'Windows 10', 'Chrome', '2017-07-31 02:26:22'),
(38,
139, '1', '2017-07-31 02:26:29', 'Windows 10', 'Chrome', '0000-00-00
00:00:00'),
(39, 235, '1', '2017-07-31 14:55:12', 'Windows 10', 'Chrome',
'2017-07-31 14:58:45'),
(40, 236, '1', '2017-07-31 15:19:54', 'Windows 10',
'Chrome', '2017-07-31 15:20:06');
--
--------------------------------------------------------
--
-- Table
structure for table `message`
--
CREATE TABLE `message` (
`message_id`
int(11) NOT NULL,
`con_id` int(11) NOT NULL,
`grp_con_id` int(11) NOT
NULL,
`mssg_by` int(11) NOT NULL,
`mssg_to` int(11) NOT NULL,
`message` text COLLATE utf8mb4_unicode_ci NOT NULL,
`type`
enum('text','image','sticker','name_change','avatar_change','member_add','leave_grp_con','removed_grp_con','admin_change')
COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'text',
`mssg_of`
enum('user','group') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'user',
`time` datetime NOT NULL,
`status` enum('read','unread') COLLATE
utf8mb4_unicode_ci NOT NULL DEFAULT 'unread'
) ENGINE=InnoDB DEFAULT
CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
--
-- Dumping data for table
`message`
--
INSERT INTO `message` (`message_id`, `con_id`, `grp_con_id`,
`mssg_by`, `mssg_to`, `message`, `type`, `mssg_of`, `time`, `status`)
VALUES
(1, 0, 0, 139, 0, '', 'avatar_change', 'user', '2017-07-03
01:55:19', 'unread'),
(9, 1, 0, 139, 224, 'aaa', 'text', 'user',
'2017-07-30 00:58:07', 'unread'),
(10, 2, 0, 139, 144, 'nmnmnm', 'text',
'user', '2017-07-30 00:58:25', 'read'),
(11, 2, 0, 139, 144,
'😴😴😴😴😴', 'text', 'user', '2017-07-30 00:58:34',
'read'),
(12, 2, 0, 139, 144, '1501356527.jpg', 'image', 'user',
'2017-07-30 00:58:47', 'read'),
(13, 2, 0, 139, 0, '1501356532.png',
'sticker', 'user', '2017-07-30 00:58:52', 'unread'),
(14, 0, 5, 139, 0, '',
'avatar_change', 'user', '2017-07-30 00:59:08', 'unread'),
(15, 0, 5, 139,
0, '1501356556.png', 'sticker', 'group', '2017-07-30 00:59:16',
'unread'),
(16, 0, 5, 139, 0, '', 'avatar_change', 'user', '2017-07-30
00:59:26', 'unread'),
(17, 0, 5, 139, 0, '224', 'member_add', 'user',
'2017-07-30 00:59:33', 'unread'),
(18, 0, 5, 139, 0, '144', 'member_add',
'user', '2017-07-30 00:59:36', 'unread'),
(19, 0, 5, 139, 0, '145',
'member_add', 'user', '2017-07-30 00:59:38', 'unread'),
(20, 0, 5, 139, 0,
'166', 'member_add', 'user', '2017-07-30 00:59:41', 'unread'),
(21, 0, 5,
139, 0, '195', 'member_add', 'user', '2017-07-30 00:59:43', 'unread'),
(22,
0, 5, 139, 0, '144', 'admin_change', 'user', '2017-07-30 00:59:51',
'unread'),
(23, 0, 5, 139, 0, 'jkjk', 'text', 'group', '2017-07-30
01:00:01', 'unread'),
(24, 0, 5, 139, 0, '1501357717.png', 'sticker',
'group', '2017-07-30 01:18:37', 'unread'),
(25, 0, 5, 139, 0, 'jkjkjk',
'text', 'group', '2017-07-30 01:18:43', 'unread'),
(26, 0, 5, 139, 0,
'1501357730.gif', 'image', 'group', '2017-07-30 01:18:50', 'unread'),
(27,
0, 5, 144, 0, 'Wo', 'text', 'group', '2017-07-30 01:20:42', 'unread'),
(28,
0, 5, 139, 0, 'tessspopo', 'text', 'group', '2017-07-30 01:37:38',
'unread'),
(29, 0, 5, 139, 0, '1501358864.jpg', 'image', 'group',
'2017-07-30 01:37:44', 'unread'),
(30, 0, 5, 139, 0, '1501358869.png',
'sticker', 'group', '2017-07-30 01:37:49', 'unread');
--
--------------------------------------------------------
--
-- Table
structure for table `mobile_private`
--
CREATE TABLE `mobile_private` (
`m_p_id` int(11) NOT NULL,
`user_id` int(11) NOT NULL,
`options`
enum('private','public') COLLATE utf8mb4_unicode_ci NOT NULL
)
ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
--
--
Dumping data for table `mobile_private`
--
INSERT INTO `mobile_private`
(`m_p_id`, `user_id`, `options`) VALUES
(24, 139, 'public'),
(25, 140,
'public'),
(26, 141, 'public'),
(27, 142, 'public'),
(28, 143,
'public'),
(29, 144, 'public'),
(30, 145, 'public'),
(31, 146,
'public'),
(32, 147, 'public'),
(33, 148, 'public'),
(34, 149,
'public'),
(35, 150, 'public'),
(36, 151, 'public'),
(37, 152,
'public'),
(38, 153, 'public'),
(39, 154, 'public'),
(40, 155,
'public'),
(41, 156, 'public'),
(42, 157, 'public'),
(43, 158,
'public'),
(44, 159, 'public'),
(45, 160, 'public'),
(46, 161,
'public'),
(47, 162, 'public'),
(48, 163, 'public'),
(49, 164,
'public'),
(50, 165, 'public'),
(51, 166, 'public'),
(52, 167,
'public'),
(53, 168, 'public'),
(54, 169, 'public'),
(55, 170,
'public'),
(56, 171, 'public'),
(57, 172, 'public'),
(58, 173,
'public'),
(59, 174, 'public'),
(60, 175, 'public'),
(61, 176,
'public'),
(62, 177, 'public'),
(63, 178, 'public'),
(64, 179,
'public'),
(65, 180, 'public'),
(66, 181, 'public'),
(67, 182,
'public'),
(68, 183, 'public'),
(69, 184, 'public'),
(70, 185,
'public'),
(71, 186, 'public'),
(72, 187, 'public'),
(73, 188,
'public'),
(74, 189, 'public'),
(75, 190, 'public'),
(76, 191,
'public'),
(77, 192, 'public'),
(78, 193, 'public'),
(79, 194,
'public'),
(80, 195, 'public'),
(81, 196, 'public'),
(82, 197,
'public'),
(83, 198, 'public'),
(84, 199, 'public'),
(87, 206,
'public'),
(88, 207, 'public'),
(89, 208, 'public'),
(90, 209,
'public'),
(91, 210, 'public'),
(92, 211, 'public'),
(93, 212,
'public'),
(94, 213, 'public'),
(95, 214, 'public'),
(96, 215,
'public'),
(97, 216, 'public'),
(98, 217, 'public'),
(99, 218,
'public'),
(100, 219, 'public'),
(101, 220, 'public'),
(102, 221,
'public'),
(103, 222, 'public'),
(104, 223, 'public'),
(105, 224,
'public'),
(106, 227, 'public'),
(107, 228, 'public'),
(108, 230,
'public'),
(109, 232, 'public');
--
--------------------------------------------------------
--
-- Table
structure for table `notifications`
--
CREATE TABLE `notifications` (
`noti_id` int(11) NOT NULL,
`notify_by` int(11) NOT NULL,
`type`
varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`notify_to` int(11) NOT
NULL,
`notify_of` int(11) NOT NULL,
`post_id` int(11) NOT NULL,
`comment_id` int(11) NOT NULL,
`time` datetime NOT NULL,
`status`
enum('read','unread') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT
'unread'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4
COLLATE=utf8mb4_unicode_ci;
--
-- Dumping data for table
`notifications`
--
INSERT INTO `notifications` (`noti_id`, `notify_by`,
`type`, `notify_to`, `notify_of`, `post_id`, `comment_id`, `time`,
`status`) VALUES
(1, 139, 'follow', 224, 0, 0, 0, '2017-07-03 01:54:41',
'unread'),
(3, 139, 'follow', 141, 0, 0, 0, '2017-07-03 01:54:50',
'unread'),
(10, 139, 'follow', 143, 0, 0, 0, '2017-07-03 16:10:47',
'unread'),
(11, 139, 'follow', 145, 0, 0, 0, '2017-07-03 16:10:53',
'unread'),
(15, 139, 'follow', 166, 0, 0, 0, '2017-07-03 16:57:52',
'unread'),
(18, 139, 'follow', 195, 0, 0, 0, '2017-07-03 17:14:10',
'unread'),
(19, 139, 'follow', 175, 0, 0, 0, '2017-07-03 17:14:12',
'unread'),
(20, 139, 'follow', 182, 0, 0, 0, '2017-07-03 17:14:14',
'read'),
(30, 227, 'follow', 186, 0, 0, 0, '2017-07-03 21:18:32',
'unread'),
(31, 227, 'follow', 145, 0, 0, 0, '2017-07-03 21:18:39',
'unread'),
(32, 227, 'follow', 154, 0, 0, 0, '2017-07-03 21:18:40',
'unread'),
(33, 227, 'follow', 140, 0, 0, 0, '2017-07-03 21:18:45',
'unread'),
(44, 139, 'shareto', 166, 0, 11, 0, '2017-07-30 00:51:38',
'unread'),
(61, 139, 'grp_add', 224, 0, 3, 0, '2017-07-30 00:56:51',
'unread'),
(62, 139, 'grp_add', 143, 0, 3, 0, '2017-07-30 00:56:54',
'unread'),
(70, 139, 'follow', 206, 0, 0, 0, '2017-07-30 01:05:29',
'unread'),
(72, 139, 'like', 144, 0, 11, 0, '2017-07-30 01:14:39',
'read'),
(73, 139, 'shareto', 187, 0, 11, 0, '2017-07-30 01:14:45',
'read'),
(74, 139, 'shareyour', 144, 0, 11, 0, '2017-07-30 01:14:45',
'read'),
(77, 139, 'follow', 151, 0, 0, 0, '2017-07-30 01:16:39',
'unread'),
(78, 139, 'follow', 186, 0, 0, 0, '2017-07-30 01:16:41',
'unread'),
(79, 139, 'grp_add', 144, 0, 4, 0, '2017-07-30 01:17:39',
'read'),
(80, 139, 'grp_add', 224, 0, 4, 0, '2017-07-30 01:17:41',
'unread'),
(81, 139, 'grp_add', 143, 0, 4, 0, '2017-07-30 01:17:43',
'unread'),
(82, 139, 'recommend', 144, 187, 0, 0, '2017-07-30 01:19:56',
'read'),
(87, 144, 'follow', 142, 0, 0, 0, '2017-07-30 01:20:52',
'unread'),
(88, 139, 'like', 144, 0, 11, 0, '2017-07-30 01:37:55',
'read'),
(89, 139, 'shareto', 227, 0, 11, 0, '2017-07-30 01:38:00',
'unread'),
(90, 139, 'shareyour', 144, 0, 11, 0, '2017-07-30 01:38:00',
'read'),
(95, 139, 'recommend', 187, 144, 0, 0, '2017-07-30 01:40:44',
'read'),
(99, 144, 'follow', 187, 0, 0, 0, '2017-07-30 01:43:03',
'unread'),
(101, 139, 'follow', 144, 0, 0, 0, '2017-07-30 03:47:15',
'read'),
(103, 144, 'follow', 187, 0, 0, 0, '2017-07-30 03:49:59',
'unread'),
(104, 144, 'follow', 187, 0, 0, 0, '2017-07-30 03:50:08',
'unread'),
(112, 144, 'follow', 187, 0, 0, 0, '2017-07-30 03:52:57',
'unread'),
(114, 144, 'follow', 160, 0, 0, 0, '2017-07-30 04:21:45',
'unread'),
(115, 144, 'follow', 219, 0, 0, 0, '2017-07-30 04:22:06',
'unread'),
(117, 144, 'follow', 213, 0, 0, 0, '2017-07-30 04:22:08',
'unread'),
(118, 144, 'follow', 161, 0, 0, 0, '2017-07-30 04:22:09',
'unread'),
(119, 144, 'follow', 169, 0, 0, 0, '2017-07-30 04:22:12',
'unread');
--
--------------------------------------------------------
--
-- Table
structure for table `post`
--
CREATE TABLE `post` (
`post_id` int(11)
NOT NULL,
`user_id` int(11) NOT NULL,
`type`
enum('text','image','video','audio','link','document','location') COLLATE
utf8mb4_unicode_ci NOT NULL,
`post_of` enum('user','group') COLLATE
utf8mb4_unicode_ci NOT NULL DEFAULT 'user',
`grp_id` int(11) NOT NULL,
`time` datetime NOT NULL,
`font_size` varchar(15) COLLATE
utf8mb4_unicode_ci NOT NULL,
`address` text COLLATE utf8mb4_unicode_ci
NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4
COLLATE=utf8mb4_unicode_ci;
--
-- Dumping data for table `post`
--
INSERT
INTO `post` (`post_id`, `user_id`, `type`, `post_of`, `grp_id`, `time`,
`font_size`, `address`) VALUES
(9, 149, 'image', 'user', 0, '2017-07-03
22:36:50', '14', ''),
(10, 144, 'text', 'user', 0, '2017-07-30 00:49:38',
'19', 'Shammi Nagar, Dharavi, Mumbai'),
(11, 144, 'image', 'user', 0,
'2017-07-30 00:50:05', '14', 'Shammi Nagar, Dharavi, Mumbai'),
(16, 139,
'text', 'group', 3, '2017-07-30 01:02:37', '14', ''),
(17, 139, 'image',
'group', 3, '2017-07-30 01:02:50', '14', ''),
(30, 139, 'text', 'user', 0,
'2017-07-31 02:39:10', '14', '');
--
--------------------------------------------------------
--
-- Table
structure for table `post_comments`
--
CREATE TABLE `post_comments` (
`post_comments_id` int(11) NOT NULL,
`post_id` int(11) NOT NULL,
`user_id` int(11) NOT NULL,
`data` mediumtext COLLATE utf8mb4_unicode_ci
NOT NULL,
`type`
enum('text','image','video','audio','link','document','location','sticker')
COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'text',
`time` datetime NOT
NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4
COLLATE=utf8mb4_unicode_ci;
--
-- Dumping data for table
`post_comments`
--
INSERT INTO `post_comments` (`post_comments_id`,
`post_id`, `user_id`, `data`, `type`, `time`) VALUES
(5, 11, 139,
'1501356089.png', 'sticker', '2017-07-30 00:51:29');
--
--------------------------------------------------------
--
-- Table
structure for table `post_likes`
--
CREATE TABLE `post_likes` (
`post_likes_id` int(11) NOT NULL,
`post_like_by` int(11) NOT NULL,
`post_id` int(11) NOT NULL,
`time` datetime NOT NULL
) ENGINE=InnoDB
DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
--
-- Dumping data for
table `post_likes`
--
INSERT INTO `post_likes` (`post_likes_id`,
`post_like_by`, `post_id`, `time`) VALUES
(12, 139, 10, '2017-07-30
00:51:45'),
(19, 139, 11, '2017-07-30 01:37:55');
--
--------------------------------------------------------
--
-- Table
structure for table `profile_views`
--
CREATE TABLE `profile_views` (
`view_id` int(11) NOT NULL,
`view_from` int(11) NOT NULL,
`view_to`
int(11) NOT NULL,
`time` datetime NOT NULL
) ENGINE=InnoDB DEFAULT
CHARSET=latin1;
--
-- Dumping data for table `profile_views`
--
INSERT
INTO `profile_views` (`view_id`, `view_from`, `view_to`, `time`) VALUES
(1,
139, 141, '2017-07-03 01:54:48'),
(2, 139, 144, '2017-07-03 01:54:53'),
(3,
227, 139, '2017-07-03 19:50:58'),
(4, 227, 139, '2017-07-03 19:52:31'),
(5,
139, 227, '2017-07-03 19:54:14'),
(6, 139, 224, '2017-07-30 00:55:59'),
(7,
139, 187, '2017-07-30 00:56:07'),
(8, 144, 139, '2017-07-30 01:01:06'),
(9,
144, 139, '2017-07-30 01:01:10'),
(10, 144, 139, '2017-07-30
01:01:17'),
(11, 144, 139, '2017-07-30 01:01:21'),
(12, 139, 206,
'2017-07-30 01:05:25'),
(13, 139, 187, '2017-07-30 01:19:42'),
(14, 144,
142, '2017-07-30 01:20:50'),
(15, 144, 142, '2017-07-30 01:20:54'),
(16,
144, 139, '2017-07-30 01:21:00'),
(17, 144, 139, '2017-07-30
01:21:02'),
(18, 144, 139, '2017-07-30 01:28:21'),
(19, 144, 139,
'2017-07-30 01:28:24'),
(20, 139, 144, '2017-07-30 01:40:33'),
(21, 144,
187, '2017-07-30 01:43:00'),
(22, 144, 187, '2017-07-30 01:43:07'),
(23,
144, 139, '2017-07-30 01:44:23'),
(24, 144, 139, '2017-07-30
01:44:55'),
(25, 144, 139, '2017-07-30 01:44:59'),
(26, 144, 139,
'2017-07-30 01:45:17'),
(27, 144, 187, '2017-07-30 03:49:53'),
(28, 144,
187, '2017-07-30 03:49:56'),
(29, 144, 187, '2017-07-30 03:51:15'),
(30,
144, 187, '2017-07-30 03:51:22'),
(31, 144, 187, '2017-07-30
03:52:35'),
(32, 144, 187, '2017-07-30 03:52:38'),
(33, 144, 187,
'2017-07-30 03:52:54'),
(34, 144, 187, '2017-07-30 03:52:58'),
(35, 144,
139, '2017-07-30 03:53:21'),
(36, 144, 139, '2017-07-30 03:53:25'),
(37,
144, 160, '2017-07-30 04:21:42');
--
--------------------------------------------------------
--
-- Table
structure for table `recommends`
--
CREATE TABLE `recommends` (
`recommend_id` int(11) NOT NULL,
`recommend_by` int(11) NOT NULL,
`recommend_to` int(11) NOT NULL,
`recommend_of` int(11) NOT NULL,
`time` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4
COLLATE=utf8mb4_unicode_ci;
--
-- Dumping data for table
`recommends`
--
INSERT INTO `recommends` (`recommend_id`, `recommend_by`,
`recommend_to`, `recommend_of`, `time`) VALUES
(1, 139, 144, 187,
'2017-07-30 01:19:56'),
(2, 139, 187, 144, '2017-07-30 01:40:44');
--
--------------------------------------------------------
--
-- Table
structure for table `shares`
--
CREATE TABLE `shares` (
`share_id`
int(11) NOT NULL,
`share_by` int(11) NOT NULL,
`share_to` int(11) NOT
NULL,
`post_id` int(11) NOT NULL,
`share_time` datetime NOT NULL
)
ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
--
--
Dumping data for table `shares`
--
INSERT INTO `shares` (`share_id`,
`share_by`, `share_to`, `post_id`, `share_time`) VALUES
(3, 139, 166, 11,
'2017-07-30 00:51:38'),
(4, 139, 187, 11, '2017-07-30 01:14:45'),
(5, 139,
227, 11, '2017-07-30 01:38:00');
--
--------------------------------------------------------
--
-- Table
structure for table `taggings`
--
CREATE TABLE `taggings` (
`tagging_id`
int(11) NOT NULL,
`post_id` int(11) NOT NULL,
`taggings` varchar(255)
COLLATE utf8mb4_unicode_ci NOT NULL,
`taggings_id` int(11) NOT NULL,
`taggings_time` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4
COLLATE=utf8mb4_unicode_ci;
--
-- Dumping data for table
`taggings`
--
INSERT INTO `taggings` (`tagging_id`, `post_id`, `taggings`,
`taggings_id`, `taggings_time`) VALUES
(5, 10, 'takkar', 139, '2017-07-30
00:49:38'),
(6, 11, 'takkar', 139, '2017-07-30 00:50:06');
--
--------------------------------------------------------
--
-- Table
structure for table `tags`
--
CREATE TABLE `tags` (
`tag_id` int(11) NOT
NULL,
`user_id` int(11) NOT NULL,
`tags` varchar(255) COLLATE
utf8mb4_unicode_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4
COLLATE=utf8mb4_unicode_ci;
--
-- Dumping data for table `tags`
--
INSERT
INTO `tags` (`tag_id`, `user_id`, `tags`) VALUES
(65, 139,
'programmer');
--
--------------------------------------------------------
--
-- Table
structure for table `text_post`
--
CREATE TABLE `text_post` (
`text_post_id` int(11) NOT NULL,
`post_id` int(11) NOT NULL,
`text`
longtext COLLATE utf8mb4_unicode_ci NOT NULL
) ENGINE=InnoDB DEFAULT
CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
--
-- Dumping data for table
`text_post`
--
INSERT INTO `text_post` (`text_post_id`, `post_id`, `text`)
VALUES
(3, 10, 'Hello😨😨😨😨😨😨'),
(5, 16, 'hjhj'),
(7, 30,
'hjhj');
--
--------------------------------------------------------
--
-- Table
structure for table `users`
--
CREATE TABLE `users` (
`id` int(11) NOT
NULL,
`username` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`firstname` varchar(155) COLLATE utf8mb4_unicode_ci NOT NULL,
`surname`
varchar(155) COLLATE utf8mb4_unicode_ci NOT NULL,
`email` varchar(255)
COLLATE utf8mb4_unicode_ci NOT NULL,
`password` varchar(255) COLLATE
utf8mb4_unicode_ci NOT NULL,
`facebook` varchar(255) COLLATE
utf8mb4_unicode_ci DEFAULT NULL,
`instagram` varchar(255) COLLATE
utf8mb4_unicode_ci DEFAULT NULL,
`twitter` varchar(255) COLLATE
utf8mb4_unicode_ci DEFAULT NULL,
`youtube` varchar(255) COLLATE
utf8mb4_unicode_ci DEFAULT NULL,
`website` varchar(255) COLLATE
utf8mb4_unicode_ci DEFAULT NULL,
`mobile` varchar(255) COLLATE
utf8mb4_unicode_ci DEFAULT NULL,
`bio` varchar(600) COLLATE
utf8mb4_unicode_ci DEFAULT NULL,
`type` enum('public','private') COLLATE
utf8mb4_unicode_ci NOT NULL DEFAULT 'public',
`signup` datetime NOT
NULL,
`email_activated` enum('yes','no') COLLATE utf8mb4_unicode_ci NOT
NULL DEFAULT 'no',
`last_login` datetime NOT NULL,
`pri_ip`
varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`pri_os` varchar(255)
COLLATE utf8mb4_unicode_ci NOT NULL,
`pri_browser` varchar(255) COLLATE
utf8mb4_unicode_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4
COLLATE=utf8mb4_unicode_ci;
--
-- Dumping data for table
`users`
--
INSERT INTO `users` (`id`, `username`, `firstname`, `surname`,
`email`, `password`, `facebook`, `instagram`, `twitter`, `youtube`,
`website`, `mobile`, `bio`, `type`, `signup`, `email_activated`,
`last_login`, `pri_ip`, `pri_os`, `pri_browser`) VALUES
(139, 'takkar',
'iam_', 'takkar', 'takkar@gmail.com',
'$2y$10$5b.0oJ5L7TCcd.Ybmn8ojeUjcFH7RoavvQstJCcuMhrd21DRBkT.C',
'https://www.facebook.com/profile.php?id=100009110960262',
'https://www.instagram.com/_faiyaz_shaikh/',
'https://twitter.com/shtakkar', '', '', '', '😮Developer of Instagram.',
'private', '2017-03-17 19:38:20', 'yes', '2017-03-17 19:38:20', '1',
'Windows 10', 'Chrome'),
(140, 'zayn', 'the_', 'zayn', 'zayn@hotmail.com',
'$2y$10$XEeVWGcxz7Yy72rotBHog.MMP/I2e1QYkubkeag3AdMzWOjjgV6j6', NULL, NULL,
NULL, NULL, NULL, NULL, NULL, 'private', '2017-03-18 14:04:15', 'yes',
'2017-03-18 14:04:15', '1', 'Windows 10', 'Chrome'),
(141, 'modi',
'narendra', 'modi', 'modi@gmail.com',
'$2y$10$9Q.ZQuHqDSAawwyDyDeo6uVnl/bcHFY4XKE/XonzYrnFM3biUkHxa',
'https://www.facebook.com/narendramodi',
'https://www.instagram.com/narendramodi/',
'https://twitter.com/narendramodi',
'https://www.youtube.com/user/narendramodi', 'http://www.narendramodi.in/',
'', '🌞🌞🌞🌞', 'public', '2017-03-18 16:38:49', 'yes', '2017-03-18
16:38:49', '1', 'Windows 10', 'Chrome'),
(142, 'taylor_swift', 'taylor',
'__swift', 'taylor@gmail.com',
'$2y$10$vgBSgVn1SoOafAw1QJy20u8oLYN3NdP45iXS.g6EesfJG1dPyOUD6',
'https://www.facebook.com/TaylorSwift/',
'https://www.instagram.com/taylorswift/',
'https://twitter.com/taylorswift13',
'https://www.youtube.com/user/TaylorSwiftVEVO', 'https://taylorswift.com/',
'', 'singer', 'public', '2017-03-18 17:13:23', 'yes', '2017-03-18
17:13:23', '1', 'Windows 10', 'Chrome'),
(143, 'selenagomez', 'selena',
'gomez', 'selena@gmail.com',
'$2y$10$IktQRVd262bp0Ihv2A06ferDhWAW/R0LhDwKxXWjPb3ycGDRx4ccC',
'https://www.facebook.com/Selena/',
'https://www.instagram.com/selenagomez/',
'https://twitter.com/selenagomez?ref_srctwsrc5Egoogle7Ctwcamp5Eserp7Ctwgr5Eauthor',
'https://www.youtube.com/user/SelenaGomezVEVO',
'https://www.selenagomez.com/', '', 'Get ''It Ain''t Me'' with Kygo, out
now. Enjoy!!😛😛', 'private', '2017-03-21 19:36:54', 'yes', '2017-03-21
19:36:54', '1', 'Windows 10', 'Chrome'),
(144, 'ghalib', 'mirza', 'ghalib',
'ghalib@gmail.com',
'$2y$10$jOJJJTFANBTOtW4b8m.ci.22KLhZClVeEkIhM9DVkLyP3pELFVeku', '', '', '',
'',
'https://www.google.co.in/webhp?sourceidchrome-instant&ion1&espv2&ieUTF-8qghalib&#q=ghalib&*',
'', 'Urdu Poet.', 'private', '2017-03-21 19:45:50', 'yes', '2017-03-21
19:45:50', '1', 'Windows 10', 'Chrome'),
(145, 'nfak', 'Nusratfateh',
'alikhan', 'nfak@gmail.com',
'$2y$10$rfMPxbC76Msi4w1yxO5YpeiYHtzdI56AU1BqOezEnfpm/D02UVXXW', '', '', '',
'', '', '', 'A sufi singer.', 'public', '2017-03-21 21:43:38', 'yes',
'2017-03-21 21:43:38', '1', 'Windows 10', 'Chrome'),
(146, 'apj', 'apj',
'kalam', 'apj@gmail.com',
'$2y$10$zhGjq.7AxTtAVU4Lrm/dIu8K8p0rYvo3SU496S1ptC/3lgL73qs6m', NULL, NULL,
NULL, NULL, NULL, NULL, NULL, 'public', '2017-03-21 21:54:22', 'yes',
'2017-03-21 21:54:22', '1', 'Windows 10', 'Chrome'),
(147, 'vkohli',
'virat', 'kohli', 'vkohli@gmail.com',
'$2y$10$R8kQtN1AVY9x1SnyNLspQeh9sjbyOy55z3WpmaquVnowDhBfYgYaC',
'https://www.facebook.com/virat.kohli/',
'https://www.instagram.com/virat.kohli/',
'https://twitter.com/imVkohli?ref_srctwsrc5Egoogle7Ctwcamp5Eserp7Ctwgr5Eauthor',
'', 'https://en.wikipedia.org/wiki/Virat_Kohli', '', 'Captain of indian
cricket team.', 'public', '2017-03-21 21:58:49', 'yes', '2017-03-21
21:58:49', '1', 'Windows 10', 'Chrome'),
(148, 'doraemon', 'dorae_', 'mon',
'doraemon@gmail.com',
'$2y$10$j4CVaE70Tu.VDMSyhNHKtu7FGL2wrHeTC15JdNf5UQEnQkC8LEo8y', '', '', '',
'', '', '', 'Looking for Michain and Nobita.', 'public', '2017-03-21
22:07:37', 'yes', '2017-03-21 22:07:37', '1', 'Windows 10',
'Chrome'),
(149, 'nobita', 'nobita', 'nobi', 'nobita@gmail.com',
'$2y$10$9kM9TpO9kjfTn.R2jnEia.3tz7F38QKiKifyfWDjW5al6aQUOeimu', '', '', '',
'', '', '', 'Shh... I''m sleeping right now.', 'public', '2017-03-21
22:11:22', 'yes', '2017-03-21 22:11:22', '1', 'Windows 10',
'Chrome'),
(150, 'steve_jobs', 'steve', 'jobs', 'steve@gmail.com',
'$2y$10$/DpfUzQvet0u7BVtW3mI9.LD0DmVOl53FHEPs67VP.mYR.FqOLSgi', '', '', '',
'', '', '', 'Apple', 'public', '2017-03-21 22:16:20', 'yes', '2017-03-21
22:16:20', '1', 'Windows 10', 'Chrome'),
(151, 'shaktiman', 'shakti',
'__man', 'shaktiman@gmail.com',
'$2y$10$PUq7RxYNFzeLhBJrFpNCVeF3zYAQ/wtp/hf8henj0JrxNyi0gpsNe', '', '', '',
'', '', '', 'Spinning right now.', 'public', '2017-03-21 22:25:28', 'yes',
'2017-03-21 22:25:28', '1', 'Windows 10', 'Chrome'),
(152, 'mj', 'michael',
'jackson', 'mj@gmail.com',
'$2y$10$AWOumiYts02rtbI6GG/0Le/z7hUjCtBJwNS6.z/opDAMaSCErf/Ci', '', '', '',
'', '', '', 'KING OF POP.', 'public', '2017-03-21 22:27:07', 'yes',
'2017-03-21 22:27:07', '1', 'Windows 10', 'Chrome'),
(153, 'tendulkar',
'sachin', 'tendulkar', 'sachin@gmail.com',
'$2y$10$p0pCtnoxrdQFTnx9YsARKO1UxZCnLs/KqxK5NEb.rWRgZGuJwJ4eq', '', '', '',
'', '', '', 'LORD OR CRICKET.', 'public', '2017-03-21 22:30:49', 'yes',
'2017-03-21 22:30:49', '1', 'Windows 10', 'Chrome'),
(154, 'voldemort',
'lord', 'voldemort', 'lord@gmail.com',
'$2y$10$cSpyMlCfMlCScH9r2/DYmuu42QPO9iDaV3j.vUua.M1ohdBqWhaMG', NULL, NULL,
NULL, NULL, NULL, NULL, NULL, 'public', '2017-03-21 22:33:57', 'yes',
'2017-03-21 22:33:57', '1', 'Windows 10', 'Chrome'),
(155, 'mohammedAli',
'mohammed', 'ali', 'ali@gmail.com',
'$2y$10$AQ9GhiL/luvcDH6Av7x/Q.gpO5mspsr4iaOFTsbR/8aEnQdvSYQ5G', '', '', '',
'', '', '', 'boxer', 'public', '2017-03-21 22:55:23', 'yes', '2017-03-21
22:55:23', '1', 'Windows 10', 'Chrome'),
(156, 'iamsrk', 'shahrukh',
'khan', 'srk@gmail.com',
'$2y$10$Szvt0julM5mPkSS.JRL4kOIuiVve2G/Lq7oz.A3EdmCqiI/dPr9HS', '', '', '',
'', '', '', 'badshah of bollywood', 'public', '2017-03-21 22:58:29', 'yes',
'2017-03-21 22:58:29', '1', 'Windows 10', 'Chrome'),
(157, 'gendalf',
'iam_', 'gendalf', 'gendalf@gmail.com',
'$2y$10$vmwRUWncCgb/3.IPhNMIfub/xdYlsB.sqWMfnpcRogb0v62sq7R3i', '', '', '',
'', '', '', '', 'public', '2017-03-21 23:00:20', 'yes', '2017-03-21
23:00:20', '1', 'Windows 10', 'Chrome'),
(158, 'shinchan', 'shinchan', '.',
'shinchan@gmail.com',
'$2y$10$lvs0Nj1bjbCA9Nbvk60tGematwB3KPJCWU9gx48K7qPXkLH61YisS', '', '', '',
'', '', '', '.', 'public', '2017-03-21 23:03:28', 'yes', '2017-03-21
23:03:28', '1', 'Windows 10', 'Chrome'),
(159, 'earth', '.', 'earth',
'universe@gmail.com',
'$2y$10$klwcM2.Zu5Fa2WJAh3m61..sckiuJOa2LlNXKb9EMZ4QzTOtp1EV6', '', '', '',
'', '', '', '', 'public', '2017-03-21 23:05:54', 'yes', '2017-03-21
23:05:54', '1', 'Windows 10', 'Chrome'),
(160, 'undertaker', 'dead', 'man',
'undertaker@gmail.com',
'$2y$10$oNH5j.RrdkrjNGRQXXUQt.QejXfDCS0DnaaIEnPqGNKNotw39Rc82', NULL, NULL,
NULL, NULL, NULL, NULL, NULL, 'public', '2017-03-21 23:07:32', 'yes',
'2017-03-21 23:07:32', '1', 'Windows 10', 'Chrome'),
(161, 'arrahman',
'ar', 'rahman', 'arrahman@gmail.com',
'$2y$10$MqjyRDsrDdOUnex6HioMxODKsk7FpGbybbbJFk0qhCt4yKCKiI5nS', '', '', '',
'', '', '', 'You know about me.', 'public', '2017-03-21 23:43:42', 'yes',
'2017-03-21 23:43:42', '1', 'Windows 10', 'Chrome'),
(162, '1D', '1',
'direction', '1d@gmail.com',
'$2y$10$UHrC/R6FfM7TJnChT08h0OZJSMrA.wmB1QpARND5sXrUdPCMFv6/O', '', '', '',
'', '', '', '', 'public', '2017-03-22 14:32:14', 'yes', '2017-03-22
14:32:14', '1', 'Windows 10', 'Chrome'),
(163, 'tajmahal', 'taj', 'mahal',
'tajmahal@gmail.com',
'$2y$10$yinUubQ3Gl1ImSeO61y87.n9vjUbqxJ73H1INtPJfpYNm0YfVyD4O', NULL, NULL,
NULL, NULL, NULL, NULL, NULL, 'public', '2017-03-22 14:33:54', 'yes',
'2017-03-22 14:33:54', '1', 'Windows 10', 'Chrome'),
(164, 'suniyo',
'suniyo', 'honekawa', 'suniyo@gmail.com',
'$2y$10$ZO6aID8aSONyqwW0hWYk5ejkYS3xUQHD02qIB3f1k7FNMq5/Qc5Jy', '', '', '',
'', '', '', '', 'public', '2017-03-22 14:39:27', 'yes', '2017-03-22
14:39:27', '1', 'Windows 10', 'Chrome'),
(165, 'gian', 'gian', 'takeshi',
'gian@gmail.com',
'$2y$10$VLXCFETiLoTiZyRzm9PeluKNA6cKjK78e0OKJKiShCx.8E53CO/nO', NULL, NULL,
NULL, NULL, NULL, NULL, NULL, 'public', '2017-03-22 15:27:56', 'yes',
'2017-03-22 15:27:56', '1', 'Windows 10', 'Chrome'),
(166, 'pikachu', 'pi',
'kachu', 'pikachu@gmail.com',
'$2y$10$Kd.q/TtAdyh.h12UWfdyg.GGdkMsLR3IL.I3eTml8SUxyyAugLPIG', NULL, NULL,
NULL, NULL, NULL, NULL, NULL, 'public', '2017-03-22 15:36:46', 'yes',
'2017-03-22 15:36:46', '1', 'Windows 10', 'Chrome'),
(167, 'hagemaru',
'Tsurupika', 'Hagemaru', 'hagemaru@gmail.com',
'$2y$10$L7XMcsHj4Bh0FozXmHivTuNVTQ5rDXaZy4zKEhifWbwYNUtNF0Qbi', NULL, NULL,
NULL, NULL, NULL, NULL, NULL, 'public', '2017-03-22 16:49:11', 'yes',
'2017-03-22 16:49:11', '1', 'Windows 10', 'Chrome'),
(168, 'aladdin',
'ald', 'din', 'aladdin@gmail.com',
'$2y$10$kmm2n2MQ7le4a90Z1oITFu887oQb8MoDtAX9i7xzAOCIJAA4K275W', NULL, NULL,
NULL, NULL, NULL, NULL, NULL, 'public', '2017-03-22 16:55:10', 'yes',
'2017-03-22 16:55:10', '1', 'Windows 10', 'Chrome'),
(169, 'richie',
'richie', 'rich', 'richie@gmail.com',
'$2y$10$btrTXi/EMu/c1l7I.AKXh.fX1eFcEv9YtzT0GWIMB/hDKNkLtrp2u', NULL, NULL,
NULL, NULL, NULL, NULL, NULL, 'public', '2017-03-22 16:57:38', 'yes',
'2017-03-22 16:57:38', '1', 'Windows 10', 'Chrome'),
(170, 'gulzar', '.',
'.', 'gulzar@gmail.com',
'$2y$10$t0NhXEnfuljz29LGyg7hTORK8P4sE/CC/f0U7p8UcCOUJv/jqdjPq', '', '', '',
'', '', '', '', 'public', '2017-03-22 17:00:52', 'yes', '2017-03-22
17:00:52', '1', 'Windows 10', 'Chrome'),
(171, 'kumarVishwas', 'kumar',
'vishwas', 'vishwas@gmail.com',
'$2y$10$G4YJhe6Fe/sTm7gE53Hnl.ehOQ3vgWa1pz/BoEZ.QevB9bvouEgtG', '', '', '',
'', '', '', 'A hindi poet.', 'public', '2017-03-22 17:04:00', 'yes',
'2017-03-22 17:04:00', '1', 'Windows 10', 'Chrome'),
(172, 'spongebob',
'spongebob', 'squarepants', 'spongebob@gmail.com',
'$2y$10$7Ia6AdnU.d1Rkqm/O89Oj.pgpqLVJTCaOoQS08XkMJEKrl7I68.fe', NULL, NULL,
NULL, NULL, NULL, NULL, NULL, 'public', '2017-03-23 00:28:29', 'yes',
'2017-03-23 00:28:29', '1', 'Windows 10', 'Chrome'),
(173, 'bobbuilder',
'bob', 'thebuilder', 'bob@gmail.com',
'$2y$10$lEQnOCIrua8N7Ogd8Fg7D.58TkJqbgYeXBF2DdJSVEvC03qMUdOhW', NULL, NULL,
NULL, NULL, NULL, NULL, NULL, 'public', '2017-03-23 00:35:42', 'yes',
'2017-03-23 00:35:42', '1', 'Windows 10', 'Chrome'),
(174, 'ededdeddy',
'gang', 'ededdeddy', 'ed@gmail.com',
'$2y$10$qE6gz7MHQF6y3z9R5vI5LOnHOZDePb1uaoVCGlD2rS6.0.p0Egvhm', NULL, NULL,
NULL, NULL, NULL, NULL, NULL, 'public', '2017-03-23 00:48:29', 'yes',
'2017-03-23 00:48:29', '1', 'Windows 10', 'Chrome'),
(175, 'looney_tunes',
'looney', 'tunes', 'looney@gmail.com',
'$2y$10$5MYKfq3GoJ/qYjZgr01Nw.D5B6okl5VyO317YZ8XQGbB0s1GqFUda', NULL, NULL,
NULL, NULL, NULL, NULL, NULL, 'public', '2017-03-23 00:52:07', 'yes',
'2017-03-23 00:52:07', '1', 'Windows 10', 'Chrome'),
(176, 'dexter',
'dexters', 'laboratory', 'dexter@gmail.com',
'$2y$10$bDARJPwkI3.eowdUjK4KGuHxkBfuOoywZ5667yquwRqWDn56Ql4BG', NULL, NULL,
NULL, NULL, NULL, NULL, NULL, 'public', '2017-03-23 00:56:56', 'yes',
'2017-03-23 00:56:56', '1', 'Windows 10', 'Chrome'),
(177, 'johnny',
'johnny', 'bravo', 'johnny@gmail.com',
'$2y$10$ajibDZ5HMuhmNtU.GtgO1.pL4UMpv9a.6VQScUmfZl9gijs9YCtc2', NULL, NULL,
NULL, NULL, NULL, NULL, NULL, 'public', '2017-03-23 00:58:55', 'yes',
'2017-03-23 00:58:55', '1', 'Windows 10', 'Chrome'),
(178, 'courage',
'the', 'cowardly_dog', 'courage@gmail.com',
'$2y$10$iiy74eMF8MkskXsO.QLmZeVObJIvR10QxnkvdAIXE/SVJ3r2qySEO', NULL, NULL,
NULL, NULL, NULL, NULL, NULL, 'public', '2017-03-23 01:03:11', 'yes',
'2017-03-23 01:03:11', '1', 'Windows 10', 'Chrome'),
(179, 'oggy',
'andthe', 'cockroaches', 'oggy@gmail.com',
'$2y$10$D.oLq...EFHuaTuRIhxUkeJ7FcIvfd15ELNPwVPnf.Ju.2ft7Ctwy', NULL, NULL,
NULL, NULL, NULL, NULL, NULL, 'public', '2017-03-23 01:05:18', 'yes',
'2017-03-23 01:05:18', '1', 'Windows 10', 'Chrome'),
(180, 'tomandjerry',
'cartoon', 'network', 'tomandjerry@gmail.com',
'$2y$10$.7TI0qjuPleXvH7c6ZVriObS.CCFIgqXBZ6A9M8XGc6tJFSsdyPm2', NULL, NULL,
NULL, NULL, NULL, NULL, NULL, 'public', '2017-03-23 01:08:15', 'yes',
'2017-03-23 01:08:15', '1', 'Windows 10', 'Chrome'),
(181, 'pooh',
'winnie', 'thepooh', 'pooh@gmail.com',
'$2y$10$5K7pIqPkwSbLbUKvUMhpTOo18UAYFT6UqpTGUP4Sz10W9me/dA4xy', NULL, NULL,
NULL, NULL, NULL, NULL, NULL, 'public', '2017-03-23 01:10:10', 'yes',
'2017-03-23 01:10:10', '1', 'Windows 10', 'Chrome'),
(182, 'oswald',
'british', 'cartoon', 'oswald@gmail.com',
'$2y$10$VcrAFj7OusvwnEseXmWgIOPhrNCHzWmK4tQg0XGiM1MYPYgoA1kT6', NULL, NULL,
NULL, NULL, NULL, NULL, NULL, 'public', '2017-03-23 01:12:49', 'yes',
'2017-03-23 01:12:49', '1', 'Windows 10', 'Chrome'),
(183, 'popeye', 'the',
'sailorman', 'popeye@gmail.com',
'$2y$10$UzTSydQ11doVjc4O75T0FeQYokPUpjmZM4CYohn.p6h6e/g0pgo4G', NULL, NULL,
NULL, NULL, NULL, NULL, NULL, 'public', '2017-03-23 01:16:07', 'yes',
'2017-03-23 01:16:07', '1', 'Windows 10', 'Chrome'),
(184, 'noddy',
'takkars', 'favourite', 'noddy@gmail.com',
'$2y$10$Jq/W6uzJeX3aBNNixBMtK.VJhsRSThg94KUe/JBTVCBEPMZ19NQq.', NULL, NULL,
NULL, NULL, NULL, NULL, NULL, 'public', '2017-03-23 01:18:53', 'yes',
'2017-03-23 01:18:53', '1', 'Windows 10', 'Chrome'),
(185, 'pingu',
'pingu', '.', 'pingu@gmail.com',
'$2y$10$3xwLy3TeMZgfkkQ1JjMfTOwz6czADSAkTumblha2PaYOhyE5NFDcG', NULL, NULL,
NULL, NULL, NULL, NULL, NULL, 'public', '2017-03-23 01:28:40', 'yes',
'2017-03-23 01:28:40', '1', 'Windows 10', 'Chrome'),
(186, 'harrypotter',
'harry', 'potter', 'harrypotter@gmail.com',
'$2y$10$k.SR4rUcw9ABiw6zCgYg3emamtHZa499L5nszPTPAo/cSp55J1.c6', '', '', '',
'', '', '', '', 'public', '2017-03-23 01:33:35', 'yes', '2017-03-23
01:33:35', '1', 'Windows 10', 'Chrome'),
(187, 'harmoine', 'harmoine',
'granger', 'harmoine@gmail.com',
'$2y$10$VH4je2DWNHdJTdD6WYI9Aeu9XbdH4BlD8pd2vUQxXT8zB8LyBg1ge', NULL, NULL,
NULL, NULL, NULL, NULL, NULL, 'public', '2017-03-23 01:38:29', 'yes',
'2017-03-23 01:38:29', '1', 'Windows 10', 'Chrome'),
(188, 'ron', 'ron',
'weasley', 'ron@gmail.com',
'$2y$10$hymaVLBlzOaYvORWCKa4QebaLdoFRPQBtu9Y7y5YGxqLYME86DoFW', NULL, NULL,
NULL, NULL, NULL, NULL, NULL, 'public', '2017-03-23 01:41:25', 'yes',
'2017-03-23 01:41:25', '1', 'Windows 10', 'Chrome'),
(189,
'naseeruddinshah', 'naseeruddin', 'shah', 'naseeruddin@gmail.com',
'$2y$10$7GtJkLMJ8i9HTrYgyVK/kOYYf3VpqoWU.AeUT77tpSKauLxyfdqNO', NULL, NULL,
NULL, NULL, NULL, NULL, NULL, 'public', '2017-03-23 17:17:16', 'yes',
'2017-03-23 17:17:16', '1', 'Windows 10', 'Chrome'),
(190, 'nawaz',
'nawazuddin', 'siddiqui', 'nawaz@gmail.com',
'$2y$10$sdSbhOpDXtIT.BaHxFhJW.6prdgAhNH5t4tqAZpMvm9SHy6XIPzX6', NULL, NULL,
NULL, NULL, NULL, NULL, NULL, 'public', '2017-03-23 17:20:27', 'yes',
'2017-03-23 17:20:27', '1', 'Windows 10', 'Chrome'),
(191, 'irfan',
'irfan', 'khan', 'irfan@gmail.com',
'$2y$10$WELsNYJQ3CAeTO9DP3BpQuAlTi7ihZT3s5m7fsPMsndQPKSJ1ntX2', NULL, NULL,
NULL, NULL, NULL, NULL, NULL, 'public', '2017-03-23 17:22:13', 'yes',
'2017-03-23 17:22:13', '1', 'Windows 10', 'Chrome'),
(192, 'instagram',
'instagram', 'official', 'instagram@gmail.com',
'$2y$10$jR.NwcgfN6n6E4sChguvl.zCVrAzsQMpw5KK5vTVR6LK9FqCkhR1S', NULL, NULL,
NULL, NULL, NULL, NULL, NULL, 'public', '2017-03-23 17:24:04', 'yes',
'2017-03-23 17:24:04', '1', 'Windows 10', 'Chrome'),
(193, 'bismillah',
'Ustad-bismillah', 'khan', 'amitabh@gmail.com',
'$2y$10$o3ah03FXoM6MFquNGXXMX.5T.G2NnGn4N6u/CPVvjC/4Q68GARvo.', '', '', '',
'', '', '', 'Indian musician credited with popularizing the shehnai.',
'public', '2017-03-25 20:01:46', 'yes', '2017-03-25 20:01:46', '1',
'Windows 10', 'Chrome'),
(194, 'shizuka', 'shizuka', 'minamoto',
'shizuka@gmail.com',
'$2y$10$dcsmNtMIOAQFi6a9IjKF7OzbWMCuuUkiIy9uao.MFiJTKvZQ7Gxv6', NULL, NULL,
NULL, NULL, NULL, NULL, NULL, 'public', '2017-03-27 23:05:09', 'yes',
'2017-03-27 23:05:09', '1', 'Windows 10', 'Chrome'),
(195, 'snape',
'severus', 'snape', 'snape@gmail.com',
'$2y$10$yMIgIAf2.WlOYJFw/HstJuU3ItAN2DjNWzi6XtDe0u5GN/YnY68Cu', NULL, NULL,
NULL, NULL, NULL, NULL, NULL, 'public', '2017-03-27 23:56:53', 'yes',
'2017-03-27 23:56:53', '1', 'Windows 10', 'Chrome'),
(196, 'draco',
'draco', 'malfoy', 'draco@gmail.com',
'$2y$10$.qOPiIDPBWXZJGJZ9g6j3O1IwJ8zhAyptZtDasHkPjpOF1yIdvZqG', NULL, NULL,
NULL, NULL, NULL, NULL, NULL, 'public', '2017-03-27 23:59:04', 'yes',
'2017-03-27 23:59:04', '1', 'Windows 10', 'Chrome'),
(197, 'dumbledore',
'albus', 'dumbledore', 'albus@gmail.com',
'$2y$10$D74VnnC30GNLGHYfmIfc5O2K9O/N83BjkM500i6vkLwyy7Zq1yuyS', NULL, NULL,
NULL, NULL, NULL, NULL, NULL, 'public', '2017-03-28 00:02:46', 'yes',
'2017-03-28 00:02:46', '1', 'Windows 10', 'Chrome'),
(198, 'ginny',
'ginny', 'weasley', 'ginny@gmail.com',
'$2y$10$mpJRx9FL9UYV4.Xsd9TMiuvgmch0A7krPUb1nnyLMLt/CqJqUZPDa', NULL, NULL,
NULL, NULL, NULL, NULL, NULL, 'public', '2017-03-28 00:07:05', 'yes',
'2017-03-28 00:07:05', '1', 'Windows 10', 'Chrome'),
(199, 'hagrid',
'rubeus', 'hagrid', 'hagrid@gmail.com',
'$2y$10$j2sCTTy6lkmSnhUPWSyH2eWfh9s4kS3rkoCKzUZgZvFE0jPynhp3W', NULL, NULL,
NULL, NULL, NULL, NULL, NULL, 'public', '2017-03-28 00:09:38', 'yes',
'2017-03-28 00:09:38', '1', 'Windows 10', 'Chrome'),
(206, 'ISRO',
'Indianspace', 'researchorganization', 'google@gmail.com',
'$2y$10$omBO76fdKKGEdoVYS4R//ueuEDstdvO6oeYsfr2M66nKq2xyELMdW', '', '', '',
'', '', '', 'The Indian Space Research Organisation is the space agency of
the Government of India.', 'public', '2017-03-29 21:21:03', 'yes',
'2017-03-29 21:21:03', '1', 'Windows 10', 'Chrome'),
(207, 'azzu', 'azhar',
'farooqui', 'azhar@gmail.com',
'$2y$10$5M5p6fM1iW6PxWndIzeWme6mR1LVXNEsZbJe6309CRGYRA06ud82.', NULL, NULL,
NULL, NULL, NULL, NULL, NULL, 'public', '2017-03-31 17:24:24', 'yes',
'2017-03-31 17:24:24', '1', 'Windows 10', 'Chrome'),
(208, 'Zakir-hussain',
'zakir', 'hussain', 'zakir@gmail.com',
'$2y$10$AUAS5SdcP3nv4DQadwxAJetawTu47UYCwd88D1JLxfbUSe8J5sj0S', '', '',
'www.zakirhussain.com/', '', '', '', 'Zakir Hussain is an Indian tabla
player in Hindustani classical music.', 'public', '2017-03-31 21:44:01',
'yes', '2017-03-31 21:44:01', '1', 'Windows 10', 'Chrome'),
(209, 'manjul',
'manjul', 'bhargava', 'manjul@gmail.com',
'$2y$10$Rlhum8JCsx2pIbx88NdWkuVeWG4n38J09.Z6bGo8RRgkddvb9qWly', '', '', '',
'', '', '', '', 'public', '2017-03-31 22:06:42', 'yes', '2017-03-31
22:06:42', '1', 'Windows 10', 'Chrome'),
(210, 'ramanujan', 'srinivas',
'ramanujan', 'ramanujan@gmail.com',
'$2y$10$j/oIZIznF8G95epUsB1veumMQVATjns6Lauw40TShCQ1vdhOOKbwW', NULL, NULL,
NULL, NULL, NULL, NULL, NULL, 'public', '2017-03-31 22:12:53', 'yes',
'2017-03-31 22:12:53', '1', 'Windows 10', 'Chrome'),
(211, 'saladin',
'salah-ud-din', 'yusuf-ibn-ayyub', 'saladin@gmail.com',
'$2y$10$AjFQKrdF7.kW8MY7lFAa3u.qTHfCACDnrPy3Ydw1auaJkBlAGBVTG', '', '', '',
'', '', '', '', 'public', '2017-03-31 22:20:39', 'yes', '2017-03-31
22:20:39', '1', 'Windows 10', 'Chrome'),
(212, 'Baldwin', 'king',
'baldwin', 'baldwin@gmail.com',
'$2y$10$yn/Sc13MY/uf39SkrEsV3O6ydI1nZQGJucN/AV9SsAho.j6eynaAy', NULL, NULL,
NULL, NULL, NULL, NULL, NULL, 'public', '2017-03-31 22:27:23', 'yes',
'2017-03-31 22:27:23', '1', 'Windows 10', 'Chrome'),
(213, 'sauron',
'sauron', '.', 'sauron@gmail.com',
'$2y$10$C9tZ8KH77E1JqRJOVO6ECuGC4ps6njOFaP2Fag5gQEcTDrItaD4Te', NULL, NULL,
NULL, NULL, NULL, NULL, NULL, 'public', '2017-03-31 22:51:48', 'yes',
'2017-03-31 22:51:48', '1', 'Windows 10', 'Chrome'),
(214, 'thenewboston',
'bucky', 'roberts', 'thenewboston@gmail.com',
'$2y$10$hDBMMFFdRMyInPMOR/BbKuo7aoDXNsq1bjz8K8vcvgYH2HCj.W8GW', '', '', '',
'https://www.youtube.com/user/thenewboston', 'https://thenewboston.com/',
'', 'I first tought the developer of this website HTML, CSS on YouTube.',
'public', '2017-04-01 00:57:33', 'yes', '2017-04-01 00:57:33', '1',
'Windows 10', 'Chrome'),
(215, 'devtips', 'travis', 'neilson',
'devtips@gmail.com',
'$2y$10$E.SgsSo5rjRzVessaRmc6ubnXPj4xAxWHshjD9XqFFf.GjXyrPhJC', '', '', '',
'https://www.youtube.com/user/DevTipsForDesigners', '', '', 'I first
thought developer of this website how to use css for fun and do magic with
it.', 'public', '2017-04-01 01:05:19', 'yes', '2017-04-01 01:05:19', '1',
'Windows 10', 'Chrome'),
(216, 'codecourse', 'alex', 'garrett',
'codecourse@gmail.com',
'$2y$10$gzNWb5Mh3wST/NtCQA0ip.Viu5H6oa7GCgayZYcC6AfTywlIZ6yJ2', '', '', '',
'https://www.youtube.com/user/phpacademy', '', '', 'I first thought the
developer of this website jQuery, PHP and doing fun with pure JavaScript.',
'public', '2017-04-01 01:10:39', 'yes', '2017-04-01 01:10:39', '1',
'Windows 10', 'Chrome'),
(217, 'TED', 'ted', 'talks', 'ted@gmail.com',
'$2y$10$7qYFYmAyE62NLSIwtvU9G.MzBJIPwrpEyagiihKfPn.5kAb3g5JQu', '', '', '',
'', '', '', 'Ideas worth sharing.', 'public', '2017-04-01 01:14:13', 'yes',
'2017-04-01 01:14:13', '1', 'Windows 10', 'Chrome'),
(218, 'Johnny-depp',
'johnny', 'depp', 'johnnydepp@gmail.com',
'$2y$10$sJfxVvxanZMn9WBmG4q5.exZU15h/DeM60Y4xwS0EAM/SSs8syD0G', NULL, NULL,
NULL, NULL, NULL, NULL, NULL, 'public', '2017-04-01 16:13:13', 'yes',
'2017-04-01 16:13:13', '1', 'Windows 10', 'Chrome'),
(219, 'flipkart',
'flipkart', '??', 'flipkart@gmail.com',
'$2y$10$D7C3sBKCE1HmdongzS5.cuw2bUnLI6ZlIz11ZMMUa2EadE5ilCtc.', '', '', '',
'', 'https://www.flipkart.com', '', '', 'public', '2017-04-07 22:21:35',
'yes', '2017-04-07 22:21:35', '1', 'Windows 10', 'Chrome'),
(220, 'Jinn',
'Jinnat', '.', 'jinn@gmail.com',
'$2y$10$xeYesu2hwoW5VGmAZRiW5eZAi35btiaqxXc.TvzC8wege5E5ejwza', NULL, NULL,
NULL, NULL, NULL, NULL, NULL, 'public', '2017-04-08 01:20:29', 'yes',
'2017-04-08 01:20:29', '1', 'Windows 10', 'Chrome'),
(221, 'Kinkade',
'thomas', 'kinkade', 'kinkade@gmail.com',
'$2y$10$lTWGPnCt7mChTKAvsZDD/eLnM6B07x3YDPNClsKVJEGnXtPa/snja', '', '', '',
'', '', '', 'Master of light.', 'public', '2017-04-08 15:08:39', 'yes',
'2017-04-08 15:08:39', '1', 'Windows 10', 'Chrome'),
(222,
'Programminglanguages', 'jk', 'op', 'shtakkar@gmail.com',
'$2y$10$eteuORPGoiM.02jhYozVhOeG.n27Y2pdfmyDWaNPtt/tauVFrRTu2', '', '', '',
'', '', '', 'We make an individual a magician.', 'public', '2017-04-08
17:16:42', 'yes', '2017-04-08 17:16:42', '1', 'Windows 10',
'Chrome'),
(223, 'Van-gogh', 'Vincent', 'van-gogh', 'van-gogh@gmail.com',
'$2y$10$Y4s8K56yWGScgd4WpU5zjObPo77YzdLP8Twje5PmKd5gu1FR6Mzx6', '', '', '',
'', '', '', ' A painter.', 'public', '2017-04-10 00:33:01', 'yes',
'2017-04-10 00:33:01', '1', 'Windows 10', 'Chrome'),
(224, 'coldplay',
'cold', 'play', 'coldplay@gmail.com',
'$2y$10$jqHQsPVpdITeMyDOrkKFXO6zuRb0v9ke1drNUNhrIIx1L4kmMktqK', '', '', '',
'', '', '', '', 'public', '2017-04-17 15:15:53', 'yes', '2017-04-17
15:15:53', '1', 'Windows 10', 'Chrome'),
(227, 'Netherlands', 'we_',
'dutch', 'netherlands@gmail.com',
'$2y$10$wbff2nM46T164HjOOF2kmO8o4gbLjk4htxhq6uv3sdv91dPBOn3CS', '', '', '',
'', '', '', '', 'public', '2017-07-03 17:49:08', 'yes', '2017-07-03
17:49:08', '1', 'Windows 10', 'Chrome'),
(230, 'India', 'we_', 'india',
'shaikhfai@yahoo.com',
'$2y$10$KMgJUawGJ6G.G7ty3CCMauktb4hVoKI6DxUrdb/rgz4arIGyhgsQq', NULL, NULL,
NULL, NULL, NULL, NULL, NULL, 'public', '2017-07-03 23:12:06', 'yes',
'2017-07-03 23:12:06', '1', 'Windows 10', 'Chrome'),
(232, 'saftt', 's',
'saftt', 'safttmail@gmail.com',
'$2y$10$9Vyr6Do1AC84upnPSsmwZ.d0.hu3HrCtqkCbZ7Za70JDX.bQq5Am6', NULL, NULL,
NULL, NULL, NULL, NULL, NULL, 'public', '2017-07-17 17:36:12', 'yes',
'2017-07-17 17:36:12', '1', 'Windows 10', 'Chrome');
--
--------------------------------------------------------
--
-- Table
structure for table `video_post`
--
CREATE TABLE `video_post` (
`video_post_id` int(11) NOT NULL,
`post_id` int(11) NOT NULL,
`video`
varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`about` longtext
COLLATE utf8mb4_unicode_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4
COLLATE=utf8mb4_unicode_ci;
--
-- Indexes for dumped tables
--
--
--
Indexes for table `audio_post`
--
ALTER TABLE `audio_post`
ADD PRIMARY
KEY (`audio_post_Id`);
--
-- Indexes for table `block`
--
ALTER TABLE
`block`
ADD PRIMARY KEY (`block_id`);
--
-- Indexes for table
`bookmarks`
--
ALTER TABLE `bookmarks`
ADD PRIMARY KEY
(`bkmrk_id`);
--
-- Indexes for table `comment_likes`
--
ALTER TABLE
`comment_likes`
ADD PRIMARY KEY (`comment_like_id`);
--
-- Indexes for
table `conversations`
--
ALTER TABLE `conversations`
ADD PRIMARY KEY
(`con_id`);
--
-- Indexes for table `doc_post`
--
ALTER TABLE `doc_post`
ADD PRIMARY KEY (`doc_post_id`);
--
-- Indexes for table
`email_private`
--
ALTER TABLE `email_private`
ADD PRIMARY KEY
(`e_p_id`);
--
-- Indexes for table `favourites`
--
ALTER TABLE
`favourites`
ADD PRIMARY KEY (`fav_id`);
--
-- Indexes for table
`follow_system`
--
ALTER TABLE `follow_system`
ADD PRIMARY KEY
(`follow_id`);
--
-- Indexes for table `groups`
--
ALTER TABLE `groups`
ADD PRIMARY KEY (`group_id`);
--
-- Indexes for table `group_con`
--
ALTER
TABLE `group_con`
ADD PRIMARY KEY (`grp_con_id`);
--
-- Indexes for
table `group_con_members`
--
ALTER TABLE `group_con_members`
ADD PRIMARY
KEY (`grp_con_mem_id`);
--
-- Indexes for table `group_members`
--
ALTER
TABLE `group_members`
ADD PRIMARY KEY (`group_mem_id`);
--
-- Indexes
for table `grpconunreads`
--
ALTER TABLE `grpconunreads`
ADD PRIMARY KEY
(`gru_id`);
--
-- Indexes for table `hashtag`
--
ALTER TABLE `hashtag`
ADD PRIMARY KEY (`hashtag_id`);
--
-- Indexes for table
`image_post`
--
ALTER TABLE `image_post`
ADD PRIMARY KEY
(`image_post_id`);
--
-- Indexes for table `invitegrp`
--
ALTER TABLE
`invitegrp`
ADD PRIMARY KEY (`inviteGrpId`);
--
-- Indexes for table
`link_post`
--
ALTER TABLE `link_post`
ADD PRIMARY KEY
(`link_post_id`);
--
-- Indexes for table `loc_post`
--
ALTER TABLE
`loc_post`
ADD PRIMARY KEY (`loc_post_id`);
--
-- Indexes for table
`login`
--
ALTER TABLE `login`
ADD PRIMARY KEY (`login_id`);
--
--
Indexes for table `message`
--
ALTER TABLE `message`
ADD PRIMARY KEY
(`message_id`);
--
-- Indexes for table `mobile_private`
--
ALTER TABLE
`mobile_private`
ADD PRIMARY KEY (`m_p_id`);
--
-- Indexes for table
`notifications`
--
ALTER TABLE `notifications`
ADD PRIMARY KEY
(`noti_id`);
--
-- Indexes for table `post`
--
ALTER TABLE `post`
ADD
PRIMARY KEY (`post_id`);
--
-- Indexes for table `post_comments`
--
ALTER
TABLE `post_comments`
ADD PRIMARY KEY (`post_comments_id`);
--
--
Indexes for table `post_likes`
--
ALTER TABLE `post_likes`
ADD PRIMARY
KEY (`post_likes_id`);
--
-- Indexes for table `profile_views`
--
ALTER
TABLE `profile_views`
ADD PRIMARY KEY (`view_id`);
--
-- Indexes for
table `recommends`
--
ALTER TABLE `recommends`
ADD PRIMARY KEY
(`recommend_id`);
--
-- Indexes for table `shares`
--
ALTER TABLE
`shares`
ADD PRIMARY KEY (`share_id`);
--
-- Indexes for table
`taggings`
--
ALTER TABLE `taggings`
ADD PRIMARY KEY
(`tagging_id`);
--
-- Indexes for table `tags`
--
ALTER TABLE `tags`
ADD
PRIMARY KEY (`tag_id`);
--
-- Indexes for table `text_post`
--
ALTER TABLE
`text_post`
ADD PRIMARY KEY (`text_post_id`);
--
-- Indexes for table
`users`
--
ALTER TABLE `users`
ADD PRIMARY KEY (`id`);
--
-- Indexes for
table `video_post`
--
ALTER TABLE `video_post`
ADD PRIMARY KEY
(`video_post_id`);
--
-- AUTO_INCREMENT for dumped tables
--
--
--
AUTO_INCREMENT for table `audio_post`
--
ALTER TABLE `audio_post`
MODIFY
`audio_post_Id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;
--
--
AUTO_INCREMENT for table `block`
--
ALTER TABLE `block`
MODIFY `block_id`
int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;
--
-- AUTO_INCREMENT for
table `bookmarks`
--
ALTER TABLE `bookmarks`
MODIFY `bkmrk_id` int(11)
NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;
--
-- AUTO_INCREMENT for table
`comment_likes`
--
ALTER TABLE `comment_likes`
MODIFY `comment_like_id`
int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;
--
-- AUTO_INCREMENT for
table `conversations`
--
ALTER TABLE `conversations`
MODIFY `con_id`
int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;
--
-- AUTO_INCREMENT for
table `doc_post`
--
ALTER TABLE `doc_post`
MODIFY `doc_post_id` int(11)
NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table
`email_private`
--
ALTER TABLE `email_private`
MODIFY `e_p_id` int(11)
NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=121;
--
-- AUTO_INCREMENT for table
`favourites`
--
ALTER TABLE `favourites`
MODIFY `fav_id` int(11) NOT NULL
AUTO_INCREMENT, AUTO_INCREMENT=3;
--
-- AUTO_INCREMENT for table
`follow_system`
--
ALTER TABLE `follow_system`
MODIFY `follow_id` int(11)
NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=47;
--
-- AUTO_INCREMENT for table
`groups`
--
ALTER TABLE `groups`
MODIFY `group_id` int(11) NOT NULL
AUTO_INCREMENT, AUTO_INCREMENT=6;
--
-- AUTO_INCREMENT for table
`group_con`
--
ALTER TABLE `group_con`
MODIFY `grp_con_id` int(11) NOT
NULL AUTO_INCREMENT, AUTO_INCREMENT=6;
--
-- AUTO_INCREMENT for table
`group_con_members`
--
ALTER TABLE `group_con_members`
MODIFY
`grp_con_mem_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=16;
--
--
AUTO_INCREMENT for table `group_members`
--
ALTER TABLE `group_members`
MODIFY `group_mem_id` int(11) NOT NULL AUTO_INCREMENT,
AUTO_INCREMENT=20;
--
-- AUTO_INCREMENT for table `grpconunreads`
--
ALTER
TABLE `grpconunreads`
MODIFY `gru_id` int(11) NOT NULL AUTO_INCREMENT,
AUTO_INCREMENT=81;
--
-- AUTO_INCREMENT for table `hashtag`
--
ALTER TABLE
`hashtag`
MODIFY `hashtag_id` int(11) NOT NULL AUTO_INCREMENT,
AUTO_INCREMENT=6;
--
-- AUTO_INCREMENT for table `image_post`
--
ALTER
TABLE `image_post`
MODIFY `image_post_id` int(11) NOT NULL
AUTO_INCREMENT, AUTO_INCREMENT=9;
--
-- AUTO_INCREMENT for table
`invitegrp`
--
ALTER TABLE `invitegrp`
MODIFY `inviteGrpId` int(11) NOT
NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `link_post`
--
ALTER
TABLE `link_post`
MODIFY `link_post_id` int(11) NOT NULL AUTO_INCREMENT,
AUTO_INCREMENT=5;
--
-- AUTO_INCREMENT for table `loc_post`
--
ALTER TABLE
`loc_post`
MODIFY `loc_post_id` int(11) NOT NULL AUTO_INCREMENT,
AUTO_INCREMENT=4;
--
-- AUTO_INCREMENT for table `login`
--
ALTER TABLE
`login`
MODIFY `login_id` int(11) NOT NULL AUTO_INCREMENT,
AUTO_INCREMENT=41;
--
-- AUTO_INCREMENT for table `message`
--
ALTER TABLE
`message`
MODIFY `message_id` int(11) NOT NULL AUTO_INCREMENT,
AUTO_INCREMENT=31;
--
-- AUTO_INCREMENT for table `mobile_private`
--
ALTER
TABLE `mobile_private`
MODIFY `m_p_id` int(11) NOT NULL AUTO_INCREMENT,
AUTO_INCREMENT=121;
--
-- AUTO_INCREMENT for table `notifications`
--
ALTER
TABLE `notifications`
MODIFY `noti_id` int(11) NOT NULL AUTO_INCREMENT,
AUTO_INCREMENT=120;
--
-- AUTO_INCREMENT for table `post`
--
ALTER TABLE
`post`
MODIFY `post_id` int(11) NOT NULL AUTO_INCREMENT,
AUTO_INCREMENT=31;
--
-- AUTO_INCREMENT for table `post_comments`
--
ALTER
TABLE `post_comments`
MODIFY `post_comments_id` int(11) NOT NULL
AUTO_INCREMENT, AUTO_INCREMENT=8;
--
-- AUTO_INCREMENT for table
`post_likes`
--
ALTER TABLE `post_likes`
MODIFY `post_likes_id` int(11)
NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=23;
--
-- AUTO_INCREMENT for table
`profile_views`
--
ALTER TABLE `profile_views`
MODIFY `view_id` int(11)
NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=38;
--
-- AUTO_INCREMENT for table
`recommends`
--
ALTER TABLE `recommends`
MODIFY `recommend_id` int(11)
NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;
--
-- AUTO_INCREMENT for table
`shares`
--
ALTER TABLE `shares`
MODIFY `share_id` int(11) NOT NULL
AUTO_INCREMENT, AUTO_INCREMENT=7;
--
-- AUTO_INCREMENT for table
`taggings`
--
ALTER TABLE `taggings`
MODIFY `tagging_id` int(11) NOT NULL
AUTO_INCREMENT, AUTO_INCREMENT=22;
--
-- AUTO_INCREMENT for table
`tags`
--
ALTER TABLE `tags`
MODIFY `tag_id` int(11) NOT NULL
AUTO_INCREMENT, AUTO_INCREMENT=70;
--
-- AUTO_INCREMENT for table
`text_post`
--
ALTER TABLE `text_post`
MODIFY `text_post_id` int(11) NOT
NULL AUTO_INCREMENT, AUTO_INCREMENT=8;
--
-- AUTO_INCREMENT for table
`users`
--
ALTER TABLE `users`
MODIFY `id` int(11) NOT NULL
AUTO_INCREMENT, AUTO_INCREMENT=250;
--
-- AUTO_INCREMENT for table
`video_post`
--
ALTER TABLE `video_post`
MODIFY `video_post_id` int(11)
NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;
/*!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 */;