ALTER TABLE `tbl_user` ADD `slug` VARCHAR(200) NULL AFTER `username`; CREATE TABLE `tbl_backend_user` ( `id` int(11) NOT NULL, `username` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `password` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `salt` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `password_strategy` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `email` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `phone` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL, `login_attempts` int(11) DEFAULT NULL, `login_time` timestamp NULL DEFAULT NULL, `login_ip` varchar(64) COLLATE utf8_unicode_ci DEFAULT NULL, `validation_key` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `create_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP, `update_time` datetime DEFAULT NULL, `status` smallint(4) NOT NULL DEFAULT '1' COMMENT '0->inactive,1->active,2->deleted' ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- Table structure for table `tbl_social`-- CREATE TABLE `tbl_social` ( `id` int(10) NOT NULL, `user_id` int(11) NOT NULL COMMENT 'user id foregin key', `social_id` varchar(45) NOT NULL, `type` tinyint(1) DEFAULT NULL COMMENT '1->fb, 2->li', `status` tinyint(1) NOT NULL DEFAULT '0' COMMENT '0->non-verified, 1->verified, 2->delete' ) ENGINE=InnoDB DEFAULT CHARSET=utf8; <-- Table structure for table `tbl_user`--> CREATE TABLE `tbl_user` ( `id` int(11) NOT NULL, `fname` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL, `lname` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL, `fullname` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL, `username` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `password` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `salt` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `email` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `phone` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL, `password_strategy` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL, `creation_ip` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL, `login_attempts` int(11) DEFAULT NULL, `login_time` timestamp NULL DEFAULT NULL, `login_ip` varchar(64) COLLATE utf8_unicode_ci DEFAULT NULL, `verification_code` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `password_reset_token` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL, `type` int(10) DEFAULT NULL, `mobile_verification_code` varchar(10) COLLATE utf8_unicode_ci DEFAULT NULL, `createdOn` datetime DEFAULT NULL, `modifiedOn` datetime DEFAULT NULL, `auth_key` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL, `status` tinyint(4) DEFAULT NULL COMMENT '0->inactive,1->active,2->deleted' ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; ALTER TABLE `tbl_backend_user` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `username` (`username`), ADD UNIQUE KEY `email` (`email`); ALTER TABLE `tbl_social` ADD PRIMARY KEY (`id`), ADD KEY `tbl_social_ibfk_1` (`user_id`); ALTER TABLE `tbl_user` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `email` (`email`), ADD UNIQUE KEY `username` (`username`); ALTER TABLE `tbl_backend_user` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2; ALTER TABLE `tbl_social` MODIFY `id` int(10) NOT NULL AUTO_INCREMENT; ALTER TABLE `tbl_user` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2; CREATE TABLE IF NOT EXISTS `tbl_feeds` ( `id` int(11) NOT NULL AUTO_INCREMENT, `feed_from` varchar(20) DEFAULT NULL, `user_id` int(11) NOT NULL, `group_id` int(11) DEFAULT NULL, `parent_feed` int(11) DEFAULT NULL, `feed_type` int(4) NOT NULL COMMENT '1->textonly,2->image,3->link,4->album', `feed_for` tinyint(4) NOT NULL DEFAULT '0' COMMENT '0->general,1->birthday,2->work_anniversary', `feed_source` mediumtext, `message` text, `at_place` varchar(255) DEFAULT NULL, `link_type` tinyint(4) DEFAULT NULL COMMENT 'link of video or any website, 1->video,2->website', `url_title` varchar(255) DEFAULT NULL, `url_description` text, `url_image` varchar(255) DEFAULT NULL, `at_lat` varchar(255) DEFAULT NULL, `at_long` varchar(255) DEFAULT NULL, `created` datetime DEFAULT NULL, `updated` datetime DEFAULT NULL, `status` int(1) DEFAULT NULL, `announcement_id` int(11) DEFAULT NULL, PRIMARY KEY (`id`), KEY `user_id` (`user_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=839 ; CREATE TABLE `tbl_group` ( `id` int(11) NOT NULL, `name` varchar(255) NOT NULL, `description` mediumtext, `banner` varchar(255) DEFAULT NULL, `privacy` tinyint(4) NOT NULL, `created_by` int(11) DEFAULT NULL, `created` datetime DEFAULT NULL, `updated_by` int(11) DEFAULT NULL, `updated` datetime DEFAULT NULL, `status` tinyint(4) NOT NULL DEFAULT '1' ) ENGINE=InnoDB DEFAULT CHARSET=utf8; ALTER TABLE `tbl_group` ADD PRIMARY KEY (`id`); ALTER TABLE `tbl_group` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; CREATE TABLE `tbl_group_members` ( `id` int(11) NOT NULL, `group_id` int(11) NOT NULL, `user_id` int(11) DEFAULT NULL, `user_email` varchar(255) DEFAULT NULL, `user_type` tinyint(4) DEFAULT NULL, `join_date` datetime DEFAULT NULL, `left_date` datetime DEFAULT NULL, `invited_on` datetime DEFAULT NULL, `notification` int(11) NOT NULL DEFAULT '1', `status` int(1) NOT NULL DEFAULT '0' ) ENGINE=InnoDB DEFAULT CHARSET=utf8; ALTER TABLE `tbl_group_members` ADD PRIMARY KEY (`id`); ALTER TABLE `tbl_group_members` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; CREATE TABLE IF NOT EXISTS `tbl_comments` ( `id` int(11) NOT NULL AUTO_INCREMENT, `user_id` int(11) NOT NULL, `feed_id` int(11) NOT NULL, `type` int(4) NOT NULL, `source` varchar(255) DEFAULT NULL, `message` text, `created` datetime DEFAULT NULL, `updated` datetime DEFAULT NULL, `status` int(1) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=939 ; CREATE TABLE IF NOT EXISTS `tbl_feed_share_with` ( `id` int(11) NOT NULL AUTO_INCREMENT, `feed_id` int(11) NOT NULL, `share_with` int(11) DEFAULT NULL, `group_id` int(11) DEFAULT NULL, `share_type` int(11) NOT NULL DEFAULT '1' COMMENT '1->check_in_with,2->tag_with,3->share_with,4->post_on_timeline,5->public_share,6->share_on_timeline,7->share_in_group', `message` text, `created_by` int(11) NOT NULL COMMENT 'tag_share_checkin_by', `is_send_notification` tinyint(4) NOT NULL DEFAULT '1', `created` datetime DEFAULT NULL, `updated` datetime DEFAULT NULL, `updated_by` int(11) DEFAULT NULL, `status` tinyint(4) NOT NULL DEFAULT '1', PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1108 ; ALTER TABLE `tbl_user` ADD `profile_pic` VARCHAR(200) NULL AFTER `phone`; CREATE TABLE `tbl_likes` ( `id` int(11) NOT NULL, `user_id` int(11) NOT NULL, `feed_id` int(11) NOT NULL, `created` datetime DEFAULT NULL, `updated` datetime DEFAULT NULL, `status` int(1) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8; ALTER TABLE `tbl_likes` ADD PRIMARY KEY (`id`); ALTER TABLE `tbl_likes` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=42; ALTER TABLE `tbl_user` ADD `description` TEXT NULL AFTER `type`; CREATE TABLE `tbl_follow` ( `id` int(11) NOT NULL, `user_id` int(11) NOT NULL, `followed_by` int(11) NOT NULL, `created` datetime DEFAULT NULL, `updated` datetime DEFAULT NULL, `status` int(1) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8; ALTER TABLE `tbl_follow` ADD PRIMARY KEY (`id`); ALTER TABLE `tbl_follow` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=42; ALTER TABLE `tbl_group_members` CHANGE `status` `status` INT(1) NOT NULL DEFAULT '0' COMMENT '0->invited,1->accepted,2->left'; ALTER TABLE `tbl_group` CHANGE `privacy` `privacy` TINYINT(4) NOT NULL COMMENT '1->public,2->private'; ALTER TABLE `tbl_group` ADD `type` TINYINT(4) NULL AFTER `privacy`; ALTER TABLE `tbl_group_members` CHANGE `user_type` `user_type` TINYINT(4) NULL DEFAULT NULL COMMENT '1->groupAdmin,2->byEmail,3->member'; ALTER TABLE `tbl_group_members` ADD `email_token` VARCHAR(255) NULL AFTER `user_email`; CREATE TABLE `tbl_notification` ( `id` int(11) NOT NULL, `user_id` int(11) NOT NULL, `notify_to` int(11) NOT NULL, `message` text, `link_url` varchar(255) NOT NULL DEFAULT 'javascript:void(0)', `link_name` varchar(255) DEFAULT NULL, `notification_type` tinyint(4) NOT NULL COMMENT '1->post,2->comment,3->like', `post_id` int(11) DEFAULT NULL, `event_id` int(11) DEFAULT NULL, `group_id` int(11) DEFAULT NULL, `forum_id` int(11) DEFAULT NULL, `comment_id` int(11) DEFAULT NULL, `likes_id` int(11) DEFAULT NULL, `unread` tinyint(1) DEFAULT '1', `status` tinyint(4) NOT NULL, `deleted` tinyint(4) NOT NULL DEFAULT '0', `created` datetime DEFAULT NULL, `read_time` datetime DEFAULT NULL, `key` varchar(255) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8; ALTER TABLE `tbl_notification` ADD PRIMARY KEY (`id`), ADD KEY `post_id` (`post_id`), ADD KEY `comment_id` (`comment_id`), ADD KEY `likes_id` (`likes_id`), ADD KEY `user_id` (`user_id`), ADD KEY `notify_to` (`notify_to`); ALTER TABLE `tbl_notification` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=1; ALTER TABLE `tbl_notification` ADD CONSTRAINT `tbl_notification_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `tbl_user` (`id`), ADD CONSTRAINT `tbl_notification_ibfk_2` FOREIGN KEY (`notify_to`) REFERENCES `tbl_user` (`id`); CREATE TABLE `tbl_session` ( `id` int(10) NOT NULL, `user_id` int(10) NOT NULL, `session_id` varchar(50) NOT NULL, `auth_token` varchar(255) DEFAULT NULL, `status` tinyint(1) NOT NULL DEFAULT '1', `time_login` datetime NOT NULL, `time_logout` datetime DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8; ALTER TABLE `tbl_session` ADD PRIMARY KEY (`id`), ADD KEY `SESSION_ID` (`session_id`), ADD KEY `USER_ID` (`user_id`), ADD KEY `user_id_2` (`user_id`); ALTER TABLE `tbl_session` MODIFY `id` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=858; ALTER TABLE `tbl_session` ADD CONSTRAINT `tbl_session_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `tbl_user` (`id`); CREATE TABLE `tbl_pitch_request` ( `id` int(11) NOT NULL, `user_id` int(11) NOT NULL, `request_from` int(11) NOT NULL, `description` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `requested_on` datetime DEFAULT NULL, `status` int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; ALTER TABLE `tbl_pitch_request` ADD PRIMARY KEY (`id`); ALTER TABLE `tbl_pitch_request` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; ALTER TABLE `tbl_company_detail` ADD `email` VARCHAR(255) NULL DEFAULT NULL AFTER `name`; ALTER TABLE `tbl_pitch_request` ADD `user_type` TINYINT(4) NULL AFTER `user_id`; ALTER TABLE `tbl_pitch_request` CHANGE `status` `status` TINYINT(4) NOT NULL DEFAULT '0' COMMENT '0->requested,1->granted,2->declined'; ALTER TABLE `tbl_pitch_request` CHANGE `user_type` `user_type` TINYINT(4) NULL DEFAULT NULL COMMENT '1->user,2->company'; ALTER TABLE `tbl_pitch_request` CHANGE `user_id` `request_to` INT(11) NOT NULL; ALTER TABLE `tbl_feeds` ADD `event_id` INT(11) NOT NULL AFTER `group_id`; ALTER TABLE `tbl_company_detail` ADD `user_type` TINYINT(4) NULL AFTER `end_time`; ALTER TABLE `tbl_follow` ADD `user_type` TINYINT(4) NOT NULL COMMENT '1->user,2->company' AFTER `created`; ALTER TABLE `tbl_companies` CHANGE `user_id` `user_id` INT(11) NULL; ALTER TABLE `tbl_user_profile` CHANGE `email` `email` VARCHAR(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL, CHANGE `location` `location` VARCHAR(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL, CHANGE `bio` `bio` TEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL, CHANGE `basic_info` `basic_info` VARCHAR(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL, CHANGE `intro` `intro` VARCHAR(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL, CHANGE `created_time` `created_time` DATETIME NULL, CHANGE `updated_time` `updated_time` DATETIME NULL; ALTER TABLE `tbl_company_detail` CHANGE `user_type` `user_type` TINYINT(4) NULL DEFAULT NULL COMMENT '''0->seed1,1->seed2,2->seed3'''; CREATE TABLE `tbl_reported_post` ( `id` int(11) NOT NULL, `post_id` int(11) NOT NULL, `reported_by` int(11) NOT NULL, `created` datetime DEFAULT NULL, `updated` datetime DEFAULT NULL, `updated_by` int(11) DEFAULT NULL, `status` tinyint(4) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8; ALTER TABLE `tbl_reported_post` ADD PRIMARY KEY (`id`), ADD KEY `post_id` (`post_id`), ADD KEY `reported_by` (`reported_by`); ALTER TABLE `tbl_reported_post` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; ALTER TABLE `tbl_reported_post` ADD CONSTRAINT `tbl_reported_post_ibfk_1` FOREIGN KEY (`post_id`) REFERENCES `tbl_feeds` (`id`), ADD CONSTRAINT `tbl_reported_post_ibfk_2` FOREIGN KEY (`reported_by`) REFERENCES `tbl_user` (`id`); ALTER TABLE `tbl_companies` ADD `profile_pic` VARCHAR(200) NOT NULL AFTER `presentation`; ALTER TABLE `tbl_feeds` CHANGE `event_id` `event_id` INT(11) NULL; ALTER TABLE `tbl_company_detail` CHANGE `user_type` `user_type` TINYINT(4) NOT NULL COMMENT '0->Angel,1->Seed,2->Pre Series A,3->Series A,4->Series B,5->Series C,6->Series D,7->Series E'; ALTER TABLE `tbl_company_detail` CHANGE `user_type` `user_type` TINYINT(4) NULL COMMENT '0->Angel,1->Seed,2->Pre Series A,3->Series A,4->Series B,5->Series C,6->Series D,7->Series E'; CREATE TABLE `tbl_mentorship` ( `id` int(11) NOT NULL, `user_id` int(11) NOT NULL, `requested_mentor_id` int(11) NOT NULL, `mentor_type` tinyint(4) NOT NULL COMMENT '1->user,2->company', `description` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `meeting_datetime` datetime DEFAULT NULL, `requested_on` datetime NOT NULL, `status` tinyint(4) NOT NULL DEFAULT '0' COMMENT '0->requested,1->accepted,2->declined' ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; ALTER TABLE `tbl_mentorship` ADD PRIMARY KEY (`id`); ALTER TABLE `tbl_mentorship` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; ALTER TABLE `tbl_user_profile` ADD `mentor_ship` VARCHAR( 255 ) NULL AFTER `primary_role` ; ALTER TABLE `tbl_message` CHANGE `user_id` `unread` TINYINT(4) NOT NULL DEFAULT '1'; // added by Rishabh for message flow ALTER TABLE `tbl_message` ADD `thread_id` int(10) NOT NULL AFTER `status` ; ALTER TABLE `tbl_companies` ADD `description` TEXT NULL AFTER `profile_pic`; ALTER TABLE `tbl_presentation` ADD `type` TINYINT(4) NULL COMMENT 'type-1 =>presentation , type-2 => pitch deck' AFTER `status`; ALTER TABLE `tbl_presentation` ADD `img_upload` VARCHAR(100) NULL AFTER `fileupload`; ALTER TABLE `tbl_companies` ADD `highlight` VARCHAR(500) NULL AFTER `description`; ALTER TABLE `tbl_pitch_request` ADD `company_id` INT(11) NULL AFTER `request_to`; ALTER TABLE `tbl_notification` CHANGE `notification_type` `notification_type` TINYINT(4) NOT NULL COMMENT '1->post,2->comment,3->like,4->report,5->follow,6->mentorship,7->pitch'; ALTER TABLE `tbl_backend_user` ADD `type` TINYINT(4) NULL DEFAULT '1' COMMENT '1->root' AFTER `password_strategy`;