One Hat Cyber Team
  • Dir : ~/www/wwwroot/welcome.nuttybe.com/
  • View File Name : database.sql
     
     
     
    '); -- -------------------------------------------------------- -- -- Table structure for table `pxp_store` -- CREATE TABLE `pxp_store` ( `id` int(11) NOT NULL, `user_id` int(11) UNSIGNED DEFAULT NULL, `title` varchar(250) DEFAULT '', `category` int(11) UNSIGNED DEFAULT NULL, `price` int(11) UNSIGNED DEFAULT NULL, `license` varchar(50) DEFAULT '', `tags` text, `small_file` varchar(250) DEFAULT '', `full_file` varchar(255) DEFAULT '', `sells` int(11) UNSIGNED DEFAULT '0', `views` int(11) UNSIGNED DEFAULT '0', `downloads` int(11) UNSIGNED DEFAULT '0', `created_date` int(11) UNSIGNED NOT NULL, `license_options` text ) ENGINE=InnoDB COMMENT='moc.ebyttun.emoclew|1d8d0463|28ohej' DEFAULT CHARSET=utf8mb4; -- -------------------------------------------------------- -- -- Table structure for table `pxp_story` -- CREATE TABLE `pxp_story` ( `id` int(11) NOT NULL, `user_id` int(11) NOT NULL DEFAULT '0', `caption` varchar(500) NOT NULL DEFAULT '', `time` varchar(50) NOT NULL DEFAULT '0', `media_file` varchar(3000) NOT NULL DEFAULT '', `type` enum('1','2') NOT NULL DEFAULT '1', `duration` varchar(50) NOT NULL DEFAULT '0' ) ENGINE=InnoDB COMMENT='moc.ebyttun.emoclew|1d8d0463|28ohej' DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Table structure for table `pxp_story_views` -- CREATE TABLE `pxp_story_views` ( `id` int(11) NOT NULL, `story_id` int(11) NOT NULL DEFAULT '0', `user_id` int(11) NOT NULL DEFAULT '0', `time` varchar(50) NOT NULL DEFAULT '' ) ENGINE=InnoDB COMMENT='moc.ebyttun.emoclew|1d8d0463|28ohej' DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Table structure for table `pxp_subscribers` -- CREATE TABLE `pxp_subscribers` ( `id` int(11) NOT NULL, `user_id` int(11) NOT NULL DEFAULT '0', `subscriber_id` int(11) NOT NULL DEFAULT '0', `time` int(11) NOT NULL DEFAULT '0' ) ENGINE=InnoDB COMMENT='moc.ebyttun.emoclew|1d8d0463|28ohej' DEFAULT CHARSET=utf8mb4; -- -------------------------------------------------------- -- -- Table structure for table `pxp_transactions` -- CREATE TABLE `pxp_transactions` ( `id` int(11) NOT NULL, `user_id` int(11) NOT NULL DEFAULT '0', `post_id` int(11) NOT NULL DEFAULT '0', `subscription_id` int(11) NOT NULL DEFAULT '0', `amount` varchar(50) NOT NULL DEFAULT '0', `admin_com` varchar(50) NOT NULL DEFAULT '0', `type` varchar(100) NOT NULL DEFAULT '', `item_store_id` int(11) UNSIGNED DEFAULT '0', `item_license` varchar(200) CHARACTER SET utf8mb4 NOT NULL DEFAULT '', `time` varchar(100) NOT NULL DEFAULT '' ) ENGINE=InnoDB COMMENT='moc.ebyttun.emoclew|1d8d0463|28ohej' DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Table structure for table `pxp_userads` -- CREATE TABLE `pxp_userads` ( `id` int(11) NOT NULL, `name` varchar(100) NOT NULL DEFAULT '', `url` varchar(3000) CHARACTER SET utf8mb4 NOT NULL DEFAULT '', `headline` varchar(200) NOT NULL DEFAULT '', `description` text, `location` varchar(1000) NOT NULL DEFAULT 'us', `audience` longtext, `ad_media` varchar(3000) CHARACTER SET utf8mb4 NOT NULL DEFAULT '', `gender` varchar(15) CHARACTER SET utf8 COLLATE utf8_danish_ci NOT NULL DEFAULT 'all', `bidding` varchar(15) CHARACTER SET utf8mb4 NOT NULL DEFAULT '', `clicks` int(15) NOT NULL DEFAULT '0', `views` int(15) NOT NULL DEFAULT '0', `posted` varchar(15) NOT NULL DEFAULT '', `status` int(1) NOT NULL DEFAULT '1', `appears` varchar(10) NOT NULL DEFAULT 'post', `user_id` int(11) NOT NULL DEFAULT '0' ) ENGINE=InnoDB COMMENT='moc.ebyttun.emoclew|1d8d0463|28ohej' DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Table structure for table `pxp_users` -- CREATE TABLE `pxp_users` ( `user_id` int(11) NOT NULL, `username` varchar(32) CHARACTER SET latin1 NOT NULL DEFAULT '', `email` varchar(50) CHARACTER SET latin1 NOT NULL DEFAULT '', `ip_address` varchar(150) CHARACTER SET utf8 NOT NULL DEFAULT '', `password` varchar(61) CHARACTER SET latin1 NOT NULL DEFAULT '', `fname` varchar(50) COLLATE utf8_unicode_ci NOT NULL DEFAULT '', `lname` varchar(50) COLLATE utf8_unicode_ci NOT NULL DEFAULT '', `gender` varchar(10) CHARACTER SET latin1 NOT NULL DEFAULT 'male', `email_code` varchar(50) CHARACTER SET latin1 NOT NULL DEFAULT '', `language` varchar(22) CHARACTER SET latin1 NOT NULL DEFAULT 'english', `avatar` varchar(1000) CHARACTER SET latin1 NOT NULL DEFAULT 'media/img/d-avatar.jpg', `cover` varchar(3000) CHARACTER SET utf8 NOT NULL DEFAULT 'media/img/d-cover.jpg', `country_id` int(11) NOT NULL DEFAULT '0', `about` text COLLATE utf8_unicode_ci, `google` varchar(50) CHARACTER SET latin1 NOT NULL DEFAULT '', `facebook` varchar(50) CHARACTER SET latin1 NOT NULL DEFAULT '', `twitter` varchar(50) CHARACTER SET latin1 NOT NULL DEFAULT '', `website` varchar(300) CHARACTER SET utf8 NOT NULL DEFAULT '', `active` int(11) NOT NULL DEFAULT '0', `admin` int(11) NOT NULL DEFAULT '0', `verified` int(11) NOT NULL DEFAULT '0', `last_seen` varchar(50) COLLATE utf8_unicode_ci NOT NULL DEFAULT '0', `registered` varchar(40) CHARACTER SET latin1 NOT NULL DEFAULT '0000/0', `time` int(11) NOT NULL DEFAULT '0', `is_pro` int(11) NOT NULL DEFAULT '0', `posts` int(11) NOT NULL DEFAULT '0', `p_privacy` enum('2','1','0') COLLATE utf8_unicode_ci NOT NULL DEFAULT '2', `c_privacy` enum('1','2') COLLATE utf8_unicode_ci NOT NULL DEFAULT '1', `n_on_like` enum('1','0') CHARACTER SET utf8 NOT NULL DEFAULT '1', `n_on_mention` enum('1','0') COLLATE utf8_unicode_ci NOT NULL DEFAULT '1', `n_on_comment` enum('1','0') COLLATE utf8_unicode_ci NOT NULL DEFAULT '1', `n_on_follow` enum('1','0') COLLATE utf8_unicode_ci NOT NULL DEFAULT '1', `n_on_comment_like` enum('0','1') COLLATE utf8_unicode_ci NOT NULL DEFAULT '1', `n_on_comment_reply` enum('0','1') COLLATE utf8_unicode_ci NOT NULL DEFAULT '1', `startup_avatar` int(11) NOT NULL DEFAULT '0', `startup_info` int(11) NOT NULL DEFAULT '0', `startup_follow` int(11) NOT NULL DEFAULT '0', `src` varchar(100) COLLATE utf8_unicode_ci NOT NULL DEFAULT '', `login_token` char(32) COLLATE utf8_unicode_ci DEFAULT '', `search_engines` enum('0','1') CHARACTER SET utf8 NOT NULL DEFAULT '1', `show_subscribers` int(2) NOT NULL DEFAULT '0', `mode` varchar(11) CHARACTER SET utf8 NOT NULL DEFAULT 'day', `device_id` varchar(100) CHARACTER SET utf8 NOT NULL DEFAULT '', `balance` varchar(100) CHARACTER SET utf8 NOT NULL DEFAULT '0', `wallet` varchar(20) CHARACTER SET utf8 NOT NULL DEFAULT '0.00', `conversation_id` varchar(250) CHARACTER SET utf8mb4 DEFAULT '', `referrer` int(11) NOT NULL DEFAULT '0', `profile` int(11) NOT NULL DEFAULT '1', `business_account` int(11) NOT NULL DEFAULT '0', `paypal_email` varchar(100) CHARACTER SET utf8 NOT NULL DEFAULT '', `b_name` varchar(100) CHARACTER SET utf8 NOT NULL DEFAULT '', `b_email` varchar(100) CHARACTER SET utf8 NOT NULL DEFAULT '', `b_phone` varchar(50) CHARACTER SET utf8 NOT NULL DEFAULT '', `b_site` varchar(300) CHARACTER SET utf8 NOT NULL DEFAULT '', `b_site_action` varchar(11) CHARACTER SET utf8 NOT NULL DEFAULT '', `uploads` int(11) UNSIGNED DEFAULT '0', `address` varchar(200) CHARACTER SET utf8mb4 DEFAULT '', `city` varchar(50) CHARACTER SET utf8mb4 DEFAULT '', `state` varchar(50) CHARACTER SET utf8mb4 DEFAULT '', `zip` int(11) UNSIGNED DEFAULT '0', `phone_number` varchar(50) CHARACTER SET utf8mb4 DEFAULT '', `StripeSessionId` varchar(200) CHARACTER SET utf8 NOT NULL DEFAULT '', `paystack_ref` varchar(100) CHARACTER SET utf8 NOT NULL DEFAULT '', `securionpay_key` int(30) NOT NULL DEFAULT '0', `coinbase_hash` varchar(20) CHARACTER SET utf8 NOT NULL DEFAULT '', `coinbase_code` varchar(20) CHARACTER SET utf8 NOT NULL DEFAULT '', `subscribe_price` int(11) NOT NULL DEFAULT '0', `two_factor` int(11) NOT NULL DEFAULT '0' ) ENGINE=InnoDB COMMENT='moc.ebyttun.emoclew|1d8d0463|28ohej' DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci ROW_FORMAT=DYNAMIC; -- -------------------------------------------------------- -- -- Table structure for table `pxp_user_reports` -- CREATE TABLE `pxp_user_reports` ( `id` int(11) NOT NULL, `user_id` int(15) NOT NULL DEFAULT '0', `profile_id` int(15) NOT NULL DEFAULT '0', `type` int(5) NOT NULL DEFAULT '0', `time` varchar(50) NOT NULL DEFAULT '0' ) ENGINE=InnoDB COMMENT='moc.ebyttun.emoclew|1d8d0463|28ohej' DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Table structure for table `pxp_verification_requests` -- CREATE TABLE `pxp_verification_requests` ( `id` int(11) NOT NULL, `user_id` int(11) NOT NULL DEFAULT '0', `name` varchar(50) NOT NULL DEFAULT '', `passport` text, `photo` text, `message` varchar(200) NOT NULL DEFAULT '', `status` int(11) NOT NULL DEFAULT '0', `time` int(50) NOT NULL DEFAULT '0' ) ENGINE=InnoDB COMMENT='moc.ebyttun.emoclew|1d8d0463|28ohej' DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Table structure for table `pxp_withdrawal_requests` -- CREATE TABLE `pxp_withdrawal_requests` ( `id` int(20) NOT NULL, `user_id` int(11) NOT NULL DEFAULT '0', `email` varchar(200) NOT NULL DEFAULT '', `amount` varchar(100) NOT NULL DEFAULT '0', `currency` varchar(20) NOT NULL DEFAULT '', `iban` varchar(250) NOT NULL DEFAULT '', `country` varchar(100) NOT NULL DEFAULT '', `full_name` varchar(150) NOT NULL DEFAULT '', `swift_code` varchar(200) NOT NULL DEFAULT '', `address` varchar(600) NOT NULL DEFAULT '', `type` varchar(100) NOT NULL DEFAULT '', `transfer_info` varchar(600) NOT NULL DEFAULT '', `requested` varchar(100) NOT NULL DEFAULT '', `status` int(5) NOT NULL DEFAULT '0' ) ENGINE=InnoDB COMMENT='moc.ebyttun.emoclew|1d8d0463|28ohej' DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Table structure for table `videocalles` -- CREATE TABLE `videocalles` ( `id` int(11) NOT NULL, `access_token` text, `access_token_2` text, `from_id` int(11) NOT NULL DEFAULT '0', `to_id` int(11) NOT NULL DEFAULT '0', `room_name` varchar(50) NOT NULL DEFAULT '', `active` int(11) NOT NULL DEFAULT '0', `called` int(11) NOT NULL DEFAULT '0', `time` int(11) NOT NULL DEFAULT '0', `declined` int(11) NOT NULL DEFAULT '0' ) ENGINE=InnoDB COMMENT='moc.ebyttun.emoclew|1d8d0463|28ohej' DEFAULT CHARSET=latin1; -- -- Indexes for dumped tables -- -- -- Indexes for table `live_sub_users` -- ALTER TABLE `live_sub_users` ADD PRIMARY KEY (`id`), ADD KEY `time` (`time`), ADD KEY `is_watching` (`is_watching`), ADD KEY `post_id` (`post_id`), ADD KEY `user_id` (`user_id`); -- -- Indexes for table `pending_payments` -- ALTER TABLE `pending_payments` ADD PRIMARY KEY (`id`), ADD KEY `user_id` (`user_id`), ADD KEY `payment_data` (`payment_data`), ADD KEY `method_name` (`method_name`), ADD KEY `time` (`time`); -- -- Indexes for table `pxp_activities` -- ALTER TABLE `pxp_activities` ADD PRIMARY KEY (`id`); -- -- Indexes for table `pxp_agoravideocall` -- ALTER TABLE `pxp_agoravideocall` ADD PRIMARY KEY (`id`), ADD KEY `from_id` (`from_id`), ADD KEY `to_id` (`to_id`), ADD KEY `type` (`type`), ADD KEY `room_name` (`room_name`), ADD KEY `time` (`time`), ADD KEY `status` (`status`); -- -- Indexes for table `pxp_audiocalls` -- ALTER TABLE `pxp_audiocalls` ADD PRIMARY KEY (`id`), ADD KEY `to_id` (`to_id`), ADD KEY `from_id` (`from_id`), ADD KEY `call_id` (`call_id`), ADD KEY `called` (`called`), ADD KEY `declined` (`declined`); -- -- Indexes for table `pxp_bank_receipts` -- ALTER TABLE `pxp_bank_receipts` ADD PRIMARY KEY (`id`); -- -- Indexes for table `pxp_blacklist` -- ALTER TABLE `pxp_blacklist` ADD PRIMARY KEY (`id`); -- -- Indexes for table `pxp_blocks` -- ALTER TABLE `pxp_blocks` ADD PRIMARY KEY (`id`), ADD KEY `user_id` (`user_id`), ADD KEY `profile_id` (`profile_id`); -- -- Indexes for table `pxp_blog` -- ALTER TABLE `pxp_blog` ADD PRIMARY KEY (`id`), ADD KEY `title` (`title`), ADD KEY `category` (`category`); -- -- Indexes for table `pxp_blog_comments` -- ALTER TABLE `pxp_blog_comments` ADD PRIMARY KEY (`id`), ADD KEY `user_id` (`user_id`), ADD KEY `post_id` (`post_id`); -- -- Indexes for table `pxp_blog_likes` -- ALTER TABLE `pxp_blog_likes` ADD PRIMARY KEY (`id`), ADD KEY `post_id` (`post_id`), ADD KEY `user_id` (`user_id`), ADD KEY `type` (`type`); -- -- Indexes for table `pxp_business_requests` -- ALTER TABLE `pxp_business_requests` ADD PRIMARY KEY (`id`); -- -- Indexes for table `pxp_chats` -- ALTER TABLE `pxp_chats` ADD PRIMARY KEY (`id`), ADD KEY `from_id` (`from_id`), ADD KEY `to_id` (`to_id`), ADD KEY `time` (`time`); -- -- Indexes for table `pxp_comments_likes` -- ALTER TABLE `pxp_comments_likes` ADD PRIMARY KEY (`id`), ADD KEY `user_id` (`user_id`), ADD KEY `comment_id` (`comment_id`); -- -- Indexes for table `pxp_comments_reply` -- ALTER TABLE `pxp_comments_reply` ADD PRIMARY KEY (`id`), ADD KEY `comment_id` (`comment_id`), ADD KEY `user_id` (`user_id`); -- -- Indexes for table `pxp_comments_reply_likes` -- ALTER TABLE `pxp_comments_reply_likes` ADD PRIMARY KEY (`id`), ADD KEY `user_id` (`user_id`), ADD KEY `reply_id` (`reply_id`); -- -- Indexes for table `pxp_config` -- ALTER TABLE `pxp_config` ADD PRIMARY KEY (`id`), ADD KEY `name` (`name`); -- -- Indexes for table `pxp_connectivities` -- ALTER TABLE `pxp_connectivities` ADD PRIMARY KEY (`id`), ADD KEY `follower_id` (`follower_id`), ADD KEY `following_id` (`following_id`), ADD KEY `active` (`active`); -- -- Indexes for table `pxp_funding` -- ALTER TABLE `pxp_funding` ADD PRIMARY KEY (`id`), ADD KEY `hashed_id` (`hashed_id`); -- -- Indexes for table `pxp_funding_raise` -- ALTER TABLE `pxp_funding_raise` ADD PRIMARY KEY (`id`), ADD KEY `user_id` (`user_id`), ADD KEY `funding_id` (`funding_id`); -- -- Indexes for table `pxp_fund_reports` -- ALTER TABLE `pxp_fund_reports` ADD PRIMARY KEY (`id`), ADD KEY `post_id` (`fund_id`), ADD KEY `user_id` (`user_id`); -- -- Indexes for table `pxp_hashtags` -- ALTER TABLE `pxp_hashtags` ADD PRIMARY KEY (`id`), ADD KEY `hash` (`hash`), ADD KEY `tag` (`tag`), ADD KEY `last_trend_time` (`last_trend_time`); -- -- Indexes for table `pxp_langs` -- ALTER TABLE `pxp_langs` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `idx_name` (`lang_key`); -- -- Indexes for table `pxp_media_files` -- ALTER TABLE `pxp_media_files` ADD PRIMARY KEY (`id`), ADD KEY `post_id` (`post_id`), ADD KEY `user_id` (`user_id`); -- -- Indexes for table `pxp_messages` -- ALTER TABLE `pxp_messages` ADD PRIMARY KEY (`id`), ADD KEY `seen` (`seen`), ADD KEY `from_id` (`from_id`), ADD KEY `to_id` (`to_id`), ADD KEY `reply_id` (`reply_id`), ADD KEY `story_id` (`story_id`); -- -- Indexes for table `pxp_notifications` -- ALTER TABLE `pxp_notifications` ADD PRIMARY KEY (`id`), ADD KEY `recipient_id` (`recipient_id`), ADD KEY `type` (`type`), ADD KEY `notifier_id` (`notifier_id`), ADD KEY `admin` (`admin`); -- -- Indexes for table `pxp_payments` -- ALTER TABLE `pxp_payments` ADD PRIMARY KEY (`id`), ADD KEY `user_id` (`user_id`); -- -- Indexes for table `pxp_posts` -- ALTER TABLE `pxp_posts` ADD PRIMARY KEY (`post_id`), ADD KEY `user_id` (`user_id`), ADD KEY `registered` (`registered`), ADD KEY `video_type` (`video_type`), ADD KEY `price` (`price`), ADD KEY `parent_id` (`parent_id`), ADD KEY `agora_token` (`agora_token`); -- -- Indexes for table `pxp_post_comments` -- ALTER TABLE `pxp_post_comments` ADD PRIMARY KEY (`id`), ADD KEY `user_id` (`user_id`), ADD KEY `post_id` (`post_id`); -- -- Indexes for table `pxp_post_likes` -- ALTER TABLE `pxp_post_likes` ADD PRIMARY KEY (`id`), ADD KEY `post_id` (`post_id`), ADD KEY `user_id` (`user_id`), ADD KEY `type` (`type`); -- -- Indexes for table `pxp_post_reports` -- ALTER TABLE `pxp_post_reports` ADD PRIMARY KEY (`id`), ADD KEY `post_id` (`post_id`), ADD KEY `user_id` (`user_id`); -- -- Indexes for table `pxp_saved_posts` -- ALTER TABLE `pxp_saved_posts` ADD PRIMARY KEY (`id`), ADD KEY `user_id` (`user_id`), ADD KEY `post_id` (`post_id`); -- -- Indexes for table `pxp_sessions` -- ALTER TABLE `pxp_sessions` ADD PRIMARY KEY (`id`), ADD KEY `session_id` (`session_id`), ADD KEY `user_id` (`user_id`), ADD KEY `platform` (`platform`), ADD KEY `time` (`time`); -- -- Indexes for table `pxp_static_pages` -- ALTER TABLE `pxp_static_pages` ADD PRIMARY KEY (`id`); -- -- Indexes for table `pxp_store` -- ALTER TABLE `pxp_store` ADD PRIMARY KEY (`id`); -- -- Indexes for table `pxp_story` -- ALTER TABLE `pxp_story` ADD PRIMARY KEY (`id`), ADD KEY `user_id` (`user_id`), ADD KEY `time` (`time`); -- -- Indexes for table `pxp_story_views` -- ALTER TABLE `pxp_story_views` ADD PRIMARY KEY (`id`), ADD KEY `story_id` (`story_id`), ADD KEY `user_id` (`user_id`); -- -- Indexes for table `pxp_subscribers` -- ALTER TABLE `pxp_subscribers` ADD PRIMARY KEY (`id`), ADD KEY `user_id` (`user_id`), ADD KEY `subscriber_id` (`subscriber_id`), ADD KEY `time` (`time`); -- -- Indexes for table `pxp_transactions` -- ALTER TABLE `pxp_transactions` ADD PRIMARY KEY (`id`), ADD KEY `admin_com` (`admin_com`), ADD KEY `amount` (`amount`), ADD KEY `post_id` (`post_id`), ADD KEY `subscription_id` (`subscription_id`); -- -- Indexes for table `pxp_userads` -- ALTER TABLE `pxp_userads` ADD PRIMARY KEY (`id`), ADD KEY `appears` (`appears`), ADD KEY `user_id` (`user_id`), ADD KEY `location` (`location`(255)), ADD KEY `gender` (`gender`), ADD KEY `status` (`status`); -- -- Indexes for table `pxp_users` -- ALTER TABLE `pxp_users` ADD PRIMARY KEY (`user_id`), ADD KEY `username` (`username`), ADD KEY `email` (`email`), ADD KEY `password` (`password`), ADD KEY `last_active` (`last_seen`), ADD KEY `admin` (`admin`), ADD KEY `active` (`active`), ADD KEY `registered` (`registered`), ADD KEY `p_privacy` (`p_privacy`), ADD KEY `c_privacy` (`c_privacy`), ADD KEY `n_on_like` (`n_on_like`), ADD KEY `n_on_mention` (`n_on_mention`), ADD KEY `n_on_comment` (`n_on_comment`), ADD KEY `n_on_follow` (`n_on_follow`), ADD KEY `src` (`src`), ADD KEY `n_on_comment_like` (`n_on_comment_like`), ADD KEY `n_on_comment_reply` (`n_on_comment_reply`), ADD KEY `time` (`time`), ADD KEY `StripeSessionId` (`StripeSessionId`), ADD KEY `paystack_ref` (`paystack_ref`), ADD KEY `securionpay_key` (`securionpay_key`), ADD KEY `coinbase_hash` (`coinbase_hash`), ADD KEY `coinbase_code` (`coinbase_code`), ADD KEY `subscribe_price` (`subscribe_price`), ADD KEY `show_subscribers` (`show_subscribers`), ADD KEY `two_factor` (`two_factor`); -- -- Indexes for table `pxp_user_reports` -- ALTER TABLE `pxp_user_reports` ADD PRIMARY KEY (`id`), ADD KEY `user_id` (`user_id`), ADD KEY `profile_id` (`profile_id`), ADD KEY `type` (`type`); -- -- Indexes for table `pxp_verification_requests` -- ALTER TABLE `pxp_verification_requests` ADD PRIMARY KEY (`id`); -- -- Indexes for table `pxp_withdrawal_requests` -- ALTER TABLE `pxp_withdrawal_requests` ADD PRIMARY KEY (`id`), ADD KEY `iban` (`iban`), ADD KEY `country` (`country`), ADD KEY `full_name` (`full_name`), ADD KEY `swift_code` (`swift_code`), ADD KEY `address` (`address`), ADD KEY `type` (`type`), ADD KEY `transfer_info` (`transfer_info`); -- -- Indexes for table `videocalles` -- ALTER TABLE `videocalles` ADD PRIMARY KEY (`id`), ADD KEY `to_id` (`to_id`), ADD KEY `from_id` (`from_id`), ADD KEY `called` (`called`), ADD KEY `declined` (`declined`); -- -- AUTO_INCREMENT for dumped tables -- -- -- AUTO_INCREMENT for table `live_sub_users` -- ALTER TABLE `live_sub_users` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `pending_payments` -- ALTER TABLE `pending_payments` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `pxp_activities` -- ALTER TABLE `pxp_activities` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `pxp_agoravideocall` -- ALTER TABLE `pxp_agoravideocall` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `pxp_audiocalls` -- ALTER TABLE `pxp_audiocalls` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `pxp_bank_receipts` -- ALTER TABLE `pxp_bank_receipts` MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `pxp_blacklist` -- ALTER TABLE `pxp_blacklist` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `pxp_blocks` -- ALTER TABLE `pxp_blocks` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `pxp_blog` -- ALTER TABLE `pxp_blog` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `pxp_blog_comments` -- ALTER TABLE `pxp_blog_comments` MODIFY `id` int(30) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `pxp_blog_likes` -- ALTER TABLE `pxp_blog_likes` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `pxp_business_requests` -- ALTER TABLE `pxp_business_requests` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `pxp_chats` -- ALTER TABLE `pxp_chats` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `pxp_comments_likes` -- ALTER TABLE `pxp_comments_likes` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `pxp_comments_reply` -- ALTER TABLE `pxp_comments_reply` MODIFY `id` int(30) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `pxp_comments_reply_likes` -- ALTER TABLE `pxp_comments_reply_likes` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `pxp_config` -- ALTER TABLE `pxp_config` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=311; -- -- AUTO_INCREMENT for table `pxp_connectivities` -- ALTER TABLE `pxp_connectivities` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `pxp_funding` -- ALTER TABLE `pxp_funding` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `pxp_funding_raise` -- ALTER TABLE `pxp_funding_raise` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `pxp_fund_reports` -- ALTER TABLE `pxp_fund_reports` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `pxp_hashtags` -- ALTER TABLE `pxp_hashtags` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `pxp_langs` -- ALTER TABLE `pxp_langs` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=725; -- -- AUTO_INCREMENT for table `pxp_media_files` -- ALTER TABLE `pxp_media_files` MODIFY `id` int(30) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `pxp_messages` -- ALTER TABLE `pxp_messages` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `pxp_notifications` -- ALTER TABLE `pxp_notifications` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `pxp_payments` -- ALTER TABLE `pxp_payments` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `pxp_posts` -- ALTER TABLE `pxp_posts` MODIFY `post_id` int(30) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `pxp_post_comments` -- ALTER TABLE `pxp_post_comments` MODIFY `id` int(30) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `pxp_post_likes` -- ALTER TABLE `pxp_post_likes` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `pxp_post_reports` -- ALTER TABLE `pxp_post_reports` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `pxp_saved_posts` -- ALTER TABLE `pxp_saved_posts` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `pxp_sessions` -- ALTER TABLE `pxp_sessions` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `pxp_static_pages` -- ALTER TABLE `pxp_static_pages` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5; -- -- AUTO_INCREMENT for table `pxp_store` -- ALTER TABLE `pxp_store` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `pxp_story` -- ALTER TABLE `pxp_story` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `pxp_story_views` -- ALTER TABLE `pxp_story_views` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `pxp_subscribers` -- ALTER TABLE `pxp_subscribers` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `pxp_transactions` -- ALTER TABLE `pxp_transactions` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `pxp_userads` -- ALTER TABLE `pxp_userads` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `pxp_users` -- ALTER TABLE `pxp_users` MODIFY `user_id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `pxp_user_reports` -- ALTER TABLE `pxp_user_reports` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `pxp_verification_requests` -- ALTER TABLE `pxp_verification_requests` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `pxp_withdrawal_requests` -- ALTER TABLE `pxp_withdrawal_requests` MODIFY `id` int(20) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `videocalles` -- ALTER TABLE `videocalles` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- Constraints for dumped tables -- -- -- Constraints for table `pxp_blog_comments` -- ALTER TABLE `pxp_blog_comments` ADD CONSTRAINT `pxp_blog_comments_ibfk_1` FOREIGN KEY (`post_id`) REFERENCES `pxp_blog` (`id`) ON DELETE CASCADE ON UPDATE NO ACTION; -- -- Constraints for table `pxp_blog_likes` -- ALTER TABLE `pxp_blog_likes` ADD CONSTRAINT `pxp_blog_likes_ibfk_1` FOREIGN KEY (`post_id`) REFERENCES `pxp_blog` (`id`) ON DELETE CASCADE ON UPDATE NO ACTION, ADD CONSTRAINT `pxp_blog_likes_ibfk_2` FOREIGN KEY (`user_id`) REFERENCES `pxp_users` (`user_id`) ON DELETE CASCADE ON UPDATE NO ACTION; -- -- Constraints for table `pxp_connectivities` -- ALTER TABLE `pxp_connectivities` ADD CONSTRAINT `pxp_connectivities_ibfk_1` FOREIGN KEY (`follower_id`) REFERENCES `pxp_users` (`user_id`) ON DELETE CASCADE ON UPDATE NO ACTION, ADD CONSTRAINT `pxp_connectivities_ibfk_2` FOREIGN KEY (`following_id`) REFERENCES `pxp_users` (`user_id`) ON DELETE CASCADE ON UPDATE NO ACTION; -- -- Constraints for table `pxp_fund_reports` -- ALTER TABLE `pxp_fund_reports` ADD CONSTRAINT `pxp_fund_reports_ibfk_1` FOREIGN KEY (`fund_id`) REFERENCES `pxp_funding` (`id`) ON DELETE CASCADE ON UPDATE NO ACTION, ADD CONSTRAINT `pxp_fund_reports_ibfk_2` FOREIGN KEY (`user_id`) REFERENCES `pxp_users` (`user_id`) ON DELETE CASCADE ON UPDATE NO ACTION; -- -- Constraints for table `pxp_media_files` -- ALTER TABLE `pxp_media_files` ADD CONSTRAINT `pxp_media_files_ibfk_1` FOREIGN KEY (`post_id`) REFERENCES `pxp_posts` (`post_id`) ON DELETE CASCADE ON UPDATE NO ACTION; -- -- Constraints for table `pxp_notifications` -- ALTER TABLE `pxp_notifications` ADD CONSTRAINT `pxp_notifications_ibfk_1` FOREIGN KEY (`notifier_id`) REFERENCES `pxp_users` (`user_id`) ON DELETE CASCADE ON UPDATE NO ACTION, ADD CONSTRAINT `pxp_notifications_ibfk_2` FOREIGN KEY (`recipient_id`) REFERENCES `pxp_users` (`user_id`) ON DELETE CASCADE ON UPDATE NO ACTION; -- -- Constraints for table `pxp_posts` -- ALTER TABLE `pxp_posts` ADD CONSTRAINT `pxp_posts_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `pxp_users` (`user_id`) ON DELETE CASCADE ON UPDATE NO ACTION; -- -- Constraints for table `pxp_post_comments` -- ALTER TABLE `pxp_post_comments` ADD CONSTRAINT `pxp_post_comments_ibfk_1` FOREIGN KEY (`post_id`) REFERENCES `pxp_posts` (`post_id`) ON DELETE CASCADE ON UPDATE NO ACTION; -- -- Constraints for table `pxp_post_likes` -- ALTER TABLE `pxp_post_likes` ADD CONSTRAINT `pxp_post_likes_ibfk_1` FOREIGN KEY (`post_id`) REFERENCES `pxp_posts` (`post_id`) ON DELETE CASCADE ON UPDATE NO ACTION, ADD CONSTRAINT `pxp_post_likes_ibfk_2` FOREIGN KEY (`user_id`) REFERENCES `pxp_users` (`user_id`) ON DELETE CASCADE ON UPDATE NO ACTION; -- -- Constraints for table `pxp_post_reports` -- ALTER TABLE `pxp_post_reports` ADD CONSTRAINT `pxp_post_reports_ibfk_1` FOREIGN KEY (`post_id`) REFERENCES `pxp_posts` (`post_id`) ON DELETE CASCADE ON UPDATE NO ACTION, ADD CONSTRAINT `pxp_post_reports_ibfk_2` FOREIGN KEY (`user_id`) REFERENCES `pxp_users` (`user_id`) ON DELETE CASCADE ON UPDATE NO ACTION; -- -- Constraints for table `pxp_saved_posts` -- ALTER TABLE `pxp_saved_posts` ADD CONSTRAINT `pxp_saved_posts_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `pxp_users` (`user_id`) ON DELETE CASCADE ON UPDATE NO ACTION, ADD CONSTRAINT `pxp_saved_posts_ibfk_2` FOREIGN KEY (`post_id`) REFERENCES `pxp_posts` (`post_id`) ON DELETE CASCADE ON UPDATE NO ACTION; -- -- Constraints for table `pxp_sessions` -- ALTER TABLE `pxp_sessions` ADD CONSTRAINT `pxp_sessions_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `pxp_users` (`user_id`) ON DELETE CASCADE ON UPDATE NO ACTION; -- -- Constraints for table `pxp_story` -- ALTER TABLE `pxp_story` ADD CONSTRAINT `pxp_story_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `pxp_users` (`user_id`) ON DELETE CASCADE ON UPDATE NO ACTION; -- -- Constraints for table `pxp_story_views` -- ALTER TABLE `pxp_story_views` ADD CONSTRAINT `pxp_story_views_ibfk_1` FOREIGN KEY (`story_id`) REFERENCES `pxp_story` (`id`) ON DELETE CASCADE ON UPDATE NO ACTION; 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 */;