Posts: 123
Threads: 32
Joined: Jun 2024
HELLO everyone i was trying to sell it but no one is interested in it so here is it for free maybe someone can use it in a good way
[b]GGs.tv is UK streaming community[/b]
download link : https://cdn1.filehaus.su/files/171992791...tvuser.sql
For Educational Purposes
-- --------------------------------------------------------
-- Host: ggs-db-mysql-nyc1-23651-do-user-9204713-0.b.db.ondigitalocean.com
-- Server version: 8.0.27 - Source distribution
-- Server OS: Linux
-- HeidiSQL Version: 12.0.0.6468
-- --------------------------------------------------------
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET NAMES utf8 */;
/*!50503 SET NAMES utf8mb4 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
-- Dumping structure for table ggscore.users
CREATE TABLE IF NOT EXISTS `users` (
`user_id` int unsigned NOT NULL AUTO_INCREMENT,
`user_group` tinyint unsigned NOT NULL DEFAULT '3',
`user_name` varchar(64) NOT NULL,
`user_email` varchar(64) NOT NULL,
`user_email_verified` enum('0','1') NOT NULL DEFAULT '0',
`user_email_verification_code` varchar(64) DEFAULT NULL,
`user_phone` varchar(64) DEFAULT NULL,
`user_phone_verified` enum('0','1') NOT NULL DEFAULT '0',
`user_phone_verification_code` varchar(64) DEFAULT NULL,
`user_password` varchar(64) NOT NULL,
`user_two_factor_enabled` enum('0','1') NOT NULL DEFAULT '0',
`user_two_factor_type` enum('email','sms','google') DEFAULT NULL,
`user_two_factor_key` varchar(64) DEFAULT NULL,
`user_two_factor_gsecret` varchar(64) DEFAULT NULL,
`user_activated` enum('0','1') NOT NULL DEFAULT '0',
`user_reseted` enum('0','1') NOT NULL DEFAULT '0',
`user_reset_key` varchar(64) DEFAULT NULL,
`user_subscribed` enum('0','1') NOT NULL DEFAULT '0',
`user_staff` enum('0','1') NOT NULL DEFAULT '0',
`user_mod` enum('0','1') NOT NULL DEFAULT '0',
`user_sponsored` enum('0','1') NOT NULL DEFAULT '0',
`user_package` int unsigned DEFAULT NULL,
`user_rating` enum('1','2','3','4','5') DEFAULT NULL,
`user_subscription_date` datetime DEFAULT NULL,
`user_boosted_posts` int unsigned NOT NULL DEFAULT '0',
`user_boosted_pages` int unsigned NOT NULL DEFAULT '0',
`user_started` enum('0','1') NOT NULL DEFAULT '0',
`user_verified` enum('0','1') NOT NULL DEFAULT '0',
`user_banned` enum('0','1') NOT NULL DEFAULT '0',
`reason_ban` varchar(254) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`user_live_requests_counter` int unsigned NOT NULL DEFAULT '0',
`user_live_requests_lastid` int unsigned NOT NULL DEFAULT '0',
`user_live_messages_counter` int unsigned NOT NULL DEFAULT '0',
`user_live_messages_lastid` int unsigned NOT NULL DEFAULT '0',
`user_live_notifications_counter` int unsigned NOT NULL DEFAULT '0',
`user_live_notifications_lastid` int unsigned NOT NULL DEFAULT '0',
`user_latitude` varchar(256) NOT NULL DEFAULT '0',
`user_longitude` varchar(256) NOT NULL DEFAULT '0',
`user_location_updated` datetime DEFAULT NULL,
`user_firstname` varchar(256) DEFAULT NULL,
`user_lastname` varchar(256) DEFAULT NULL,
`user_gender` int unsigned DEFAULT NULL,
`user_picture` varchar(255) DEFAULT NULL,
`user_picture_id` int unsigned DEFAULT NULL,
`user_cover` varchar(256) DEFAULT NULL,
`user_cover_id` int unsigned DEFAULT NULL,
`user_cover_position` varchar(256) DEFAULT NULL,
`user_album_pictures` int unsigned DEFAULT NULL,
`user_album_covers` int unsigned DEFAULT NULL,
`user_album_timeline` int unsigned DEFAULT NULL,
`user_pinned_post` int unsigned DEFAULT NULL,
`user_registered` datetime DEFAULT NULL,
`user_last_seen` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
`user_first_failed_login` datetime DEFAULT NULL,
`user_failed_login_ip` varchar(64) DEFAULT NULL,
`user_failed_login_count` int unsigned NOT NULL DEFAULT '0',
`user_country` int unsigned DEFAULT NULL,
`user_birthdate` date DEFAULT NULL,
`user_relationship` varchar(256) DEFAULT NULL,
`user_biography` text,
`user_website` varchar(256) DEFAULT NULL,
`user_work_title` varchar(256) DEFAULT NULL,
`user_work_place` varchar(256) DEFAULT NULL,
`user_work_url` varchar(256) DEFAULT NULL,
`user_current_city` varchar(256) DEFAULT NULL,
`user_hometown` varchar(256) DEFAULT NULL,
`user_edu_major` varchar(256) DEFAULT NULL,
`user_edu_school` varchar(256) DEFAULT NULL,
`user_edu_class` varchar(256) DEFAULT NULL,
`user_social_facebook` varchar(256) DEFAULT NULL,
`user_social_twitter` varchar(256) DEFAULT NULL,
`user_social_steam` varchar(256) DEFAULT NULL,
`user_social_activision` varchar(256) DEFAULT NULL,
`user_social_switch` varchar(256) DEFAULT NULL,
`user_social_battle` varchar(265) DEFAULT NULL,
`user_social_origin` varchar(256) DEFAULT NULL,
`user_social_gog` varchar(265) DEFAULT NULL,
`user_social_youtube` varchar(256) DEFAULT NULL,
`user_social_instagram` varchar(256) DEFAULT NULL,
`user_social_linkedin` varchar(256) DEFAULT NULL,
`user_social_twitch` varchar(256) DEFAULT NULL,
`user_social_playstation` varchar(256) DEFAULT NULL,
`user_social_xbox` varchar(256) DEFAULT NULL,
`user_social_tiktok` varchar(256) DEFAULT NULL,
`user_profile_background` varchar(256) DEFAULT NULL,
`user_chat_enabled` enum('0','1') NOT NULL DEFAULT '1',
`user_privacy_newsletter` enum('0','1') NOT NULL DEFAULT '1',
`user_privacy_poke` enum('me','friends','public') NOT NULL DEFAULT 'public',
`user_privacy_gifts` enum('me','friends','public') NOT NULL DEFAULT 'public',
`user_privacy_wall` enum('me','friends','public') NOT NULL DEFAULT 'friends',
`user_privacy_gender` enum('me','friends','public') NOT NULL DEFAULT 'public',
`user_privacy_birthdate` enum('me','friends','public') NOT NULL DEFAULT 'public',
`user_privacy_relationship` enum('me','friends','public') NOT NULL DEFAULT 'public',
`user_privacy_basic` enum('me','friends','public') NOT NULL DEFAULT 'public',
`user_privacy_work` enum('me','friends','public') NOT NULL DEFAULT 'public',
`user_privacy_location` enum('me','friends','public') NOT NULL DEFAULT 'public',
`user_privacy_education` enum('me','friends','public') NOT NULL DEFAULT 'public',
`user_privacy_other` enum('me','friends','public') NOT NULL DEFAULT 'public',
`user_privacy_friends` enum('me','friends','public') NOT NULL DEFAULT 'public',
`user_privacy_photos` enum('me','friends','public') NOT NULL DEFAULT 'public',
`user_privacy_pages` enum('me','friends','public') NOT NULL DEFAULT 'public',
`user_privacy_groups` enum('me','friends','public') NOT NULL DEFAULT 'public',
`user_privacy_events` enum('me','friends','public') NOT NULL DEFAULT 'public',
`email_post_likes` enum('0','1') NOT NULL DEFAULT '1',
`email_post_comments` enum('0','1') NOT NULL DEFAULT '1',
`email_post_shares` enum('0','1') NOT NULL DEFAULT '1',
`email_wall_posts` enum('0','1') NOT NULL DEFAULT '1',
`email_mentions` enum('0','1') NOT NULL DEFAULT '1',
`email_profile_visits` enum('0','1') NOT NULL DEFAULT '1',
`email_friend_requests` enum('0','1') NOT NULL DEFAULT '1',
`facebook_connected` enum('0','1') NOT NULL DEFAULT '0',
`facebook_id` varchar(128) DEFAULT NULL,
`google_connected` enum('0','1') NOT NULL DEFAULT '0',
`google_id` varchar(128) DEFAULT NULL,
`twitter_connected` enum('0','1') NOT NULL DEFAULT '0',
`twitter_id` varchar(128) DEFAULT NULL,
`instagram_connected` enum('0','1') NOT NULL DEFAULT '0',
`instagram_id` varchar(128) DEFAULT NULL,
`linkedin_connected` enum('0','1') NOT NULL DEFAULT '0',
`apple_connected` enum('0','1') NOT NULL DEFAULT '0',
`linkedin_id` varchar(128) DEFAULT NULL,
`apple_id` varchar(128) DEFAULT NULL,
`vkontakte_connected` enum('0','1') NOT NULL DEFAULT '0',
`vkontakte_id` varchar(128) DEFAULT NULL,
`user_referrer_id` int DEFAULT NULL,
`user_affiliate_balance` varchar(64) NOT NULL DEFAULT '0',
`user_wallet_balance` decimal(4,0) NOT NULL DEFAULT '0',
`user_points` int NOT NULL DEFAULT '0',
`chat_sound` enum('0','1') NOT NULL DEFAULT '0',
`notifications_sound` enum('0','1') NOT NULL DEFAULT '0',
`onesignal_user_id` varchar(100) DEFAULT NULL,
`user_language` varchar(16) DEFAULT 'en_us',
`first` varchar(254) DEFAULT NULL,
`second` varchar(254) DEFAULT NULL,
`third` varchar(254) DEFAULT NULL,
`fourth` varchar(254) DEFAULT NULL,
`fifth` varchar(254) DEFAULT NULL,
`squad_name` varchar(254) NOT NULL DEFAULT 'The Squad',
`card_cover` varchar(254) NOT NULL DEFAULT 'disabled',
`spotify` varchar(453) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`total_xp` bigint NOT NULL DEFAULT '0',
`game1` varchar(254) DEFAULT NULL,
`game2` varchar(254) DEFAULT NULL,
`game3` varchar(254) DEFAULT NULL,
`exolved` enum('0','1') NOT NULL DEFAULT '0',
`valk` enum('0','1') NOT NULL DEFAULT '0',
`titus` enum('0','1') NOT NULL DEFAULT '0',
`poss` enum('0','1') NOT NULL DEFAULT '0',
`safe` enum('0','1') NOT NULL DEFAULT '0',
`firstresponder` enum('0','1') NOT NULL DEFAULT '0',
`firstresponder_badge` enum('0','1') NOT NULL DEFAULT '0',
`military_badge` enum('0','1') NOT NULL DEFAULT '0',
`military` enum('0','1') NOT NULL DEFAULT '0',
`gg_badge` enum('0','1') NOT NULL DEFAULT '0',
`gg` enum('0','1') NOT NULL DEFAULT '0',
`aero` enum('0','1') NOT NULL DEFAULT '0',
`zodiac` enum('0','1') NOT NULL DEFAULT '0',
`sway` enum('0','1') NOT NULL DEFAULT '0',
`partner_member` enum('0','1') NOT NULL DEFAULT '0',
`css` text,
`lfg` enum('0','1') NOT NULL DEFAULT '0',
`lfg_text` varchar(256) DEFAULT NULL,
`user_social_discord` varchar(45) DEFAULT NULL,
`user_social_epic` varchar(45) DEFAULT NULL,
`user_social_trovo` varchar(45) DEFAULT NULL,
`live` enum('0','1') NOT NULL DEFAULT '0',
`searching` enum('0','1') NOT NULL DEFAULT '0',
`layout` int NOT NULL DEFAULT '1',
`user_token` varchar(255) DEFAULT NULL,
`tickets` int DEFAULT '0',
`tag` varchar(45) DEFAULT NULL,
`grinding` int NOT NULL DEFAULT '0',
`referrals` int DEFAULT '0',
`code` enum('0','1') DEFAULT '0',
`monthly` int NOT NULL DEFAULT '0',
`cancel_sub` enum('0','1') DEFAULT '0',
PRIMARY KEY (`user_id`),
UNIQUE KEY `username` (`user_name`),
UNIQUE KEY `user_email` (`user_email`),
UNIQUE KEY `facebook_id` (`facebook_id`),
UNIQUE KEY `twitter_id` (`twitter_id`),
UNIQUE KEY `linkedin_id` (`linkedin_id`),
UNIQUE KEY `vkontakte_id` (`vkontakte_id`),
UNIQUE KEY `instagram_id` (`instagram_id`),
UNIQUE KEY `user_phone` (`user_phone`),
UNIQUE KEY `google_id` (`google_id`),
KEY `apple_id` (`apple_id`),
KEY `idx_last_seen_online` (`user_last_seen`) USING BTREE COMMENT 'Typically used for sorting'
) ENGINE=InnoDB AUTO_INCREMENT=6598 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
Posts: 230
Threads: 25
Joined: Jun 2023
(Jul 02, 2024, 01:18 PM)playstation Wrote: HELLO everyone i was trying to sell it but no one is interested in it so here is it for free maybe someone can use it in a good way
[b]GGs.tv is UK streaming community[/b]
download link : HERE
For Educational Purposes
-- --------------------------------------------------------
-- Host: ggs-db-mysql-nyc1-23651-do-user-9204713-0.b.db.ondigitalocean.com
-- Server version: 8.0.27 - Source distribution
-- Server OS: Linux
-- HeidiSQL Version: 12.0.0.6468
-- --------------------------------------------------------
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET NAMES utf8 */;
/*!50503 SET NAMES utf8mb4 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
-- Dumping structure for table ggscore.users
CREATE TABLE IF NOT EXISTS `users` (
`user_id` int unsigned NOT NULL AUTO_INCREMENT,
`user_group` tinyint unsigned NOT NULL DEFAULT '3',
`user_name` varchar(64) NOT NULL,
`user_email` varchar(64) NOT NULL,
`user_email_verified` enum('0','1') NOT NULL DEFAULT '0',
`user_email_verification_code` varchar(64) DEFAULT NULL,
`user_phone` varchar(64) DEFAULT NULL,
`user_phone_verified` enum('0','1') NOT NULL DEFAULT '0',
`user_phone_verification_code` varchar(64) DEFAULT NULL,
`user_password` varchar(64) NOT NULL,
`user_two_factor_enabled` enum('0','1') NOT NULL DEFAULT '0',
`user_two_factor_type` enum('email','sms','google') DEFAULT NULL,
`user_two_factor_key` varchar(64) DEFAULT NULL,
`user_two_factor_gsecret` varchar(64) DEFAULT NULL,
`user_activated` enum('0','1') NOT NULL DEFAULT '0',
`user_reseted` enum('0','1') NOT NULL DEFAULT '0',
`user_reset_key` varchar(64) DEFAULT NULL,
`user_subscribed` enum('0','1') NOT NULL DEFAULT '0',
`user_staff` enum('0','1') NOT NULL DEFAULT '0',
`user_mod` enum('0','1') NOT NULL DEFAULT '0',
`user_sponsored` enum('0','1') NOT NULL DEFAULT '0',
`user_package` int unsigned DEFAULT NULL,
`user_rating` enum('1','2','3','4','5') DEFAULT NULL,
`user_subscription_date` datetime DEFAULT NULL,
`user_boosted_posts` int unsigned NOT NULL DEFAULT '0',
`user_boosted_pages` int unsigned NOT NULL DEFAULT '0',
`user_started` enum('0','1') NOT NULL DEFAULT '0',
`user_verified` enum('0','1') NOT NULL DEFAULT '0',
`user_banned` enum('0','1') NOT NULL DEFAULT '0',
`reason_ban` varchar(254) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`user_live_requests_counter` int unsigned NOT NULL DEFAULT '0',
`user_live_requests_lastid` int unsigned NOT NULL DEFAULT '0',
`user_live_messages_counter` int unsigned NOT NULL DEFAULT '0',
`user_live_messages_lastid` int unsigned NOT NULL DEFAULT '0',
`user_live_notifications_counter` int unsigned NOT NULL DEFAULT '0',
`user_live_notifications_lastid` int unsigned NOT NULL DEFAULT '0',
`user_latitude` varchar(256) NOT NULL DEFAULT '0',
`user_longitude` varchar(256) NOT NULL DEFAULT '0',
`user_location_updated` datetime DEFAULT NULL,
`user_firstname` varchar(256) DEFAULT NULL,
`user_lastname` varchar(256) DEFAULT NULL,
`user_gender` int unsigned DEFAULT NULL,
`user_picture` varchar(255) DEFAULT NULL,
`user_picture_id` int unsigned DEFAULT NULL,
`user_cover` varchar(256) DEFAULT NULL,
`user_cover_id` int unsigned DEFAULT NULL,
`user_cover_position` varchar(256) DEFAULT NULL,
`user_album_pictures` int unsigned DEFAULT NULL,
`user_album_covers` int unsigned DEFAULT NULL,
`user_album_timeline` int unsigned DEFAULT NULL,
`user_pinned_post` int unsigned DEFAULT NULL,
`user_registered` datetime DEFAULT NULL,
`user_last_seen` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
`user_first_failed_login` datetime DEFAULT NULL,
`user_failed_login_ip` varchar(64) DEFAULT NULL,
`user_failed_login_count` int unsigned NOT NULL DEFAULT '0',
`user_country` int unsigned DEFAULT NULL,
`user_birthdate` date DEFAULT NULL,
`user_relationship` varchar(256) DEFAULT NULL,
`user_biography` text,
`user_website` varchar(256) DEFAULT NULL,
`user_work_title` varchar(256) DEFAULT NULL,
`user_work_place` varchar(256) DEFAULT NULL,
`user_work_url` varchar(256) DEFAULT NULL,
`user_current_city` varchar(256) DEFAULT NULL,
`user_hometown` varchar(256) DEFAULT NULL,
`user_edu_major` varchar(256) DEFAULT NULL,
`user_edu_school` varchar(256) DEFAULT NULL,
`user_edu_class` varchar(256) DEFAULT NULL,
`user_social_facebook` varchar(256) DEFAULT NULL,
`user_social_twitter` varchar(256) DEFAULT NULL,
`user_social_steam` varchar(256) DEFAULT NULL,
`user_social_activision` varchar(256) DEFAULT NULL,
`user_social_switch` varchar(256) DEFAULT NULL,
`user_social_battle` varchar(265) DEFAULT NULL,
`user_social_origin` varchar(256) DEFAULT NULL,
`user_social_gog` varchar(265) DEFAULT NULL,
`user_social_youtube` varchar(256) DEFAULT NULL,
`user_social_instagram` varchar(256) DEFAULT NULL,
`user_social_linkedin` varchar(256) DEFAULT NULL,
`user_social_twitch` varchar(256) DEFAULT NULL,
`user_social_playstation` varchar(256) DEFAULT NULL,
`user_social_xbox` varchar(256) DEFAULT NULL,
`user_social_tiktok` varchar(256) DEFAULT NULL,
`user_profile_background` varchar(256) DEFAULT NULL,
`user_chat_enabled` enum('0','1') NOT NULL DEFAULT '1',
`user_privacy_newsletter` enum('0','1') NOT NULL DEFAULT '1',
`user_privacy_poke` enum('me','friends','public') NOT NULL DEFAULT 'public',
`user_privacy_gifts` enum('me','friends','public') NOT NULL DEFAULT 'public',
`user_privacy_wall` enum('me','friends','public') NOT NULL DEFAULT 'friends',
`user_privacy_gender` enum('me','friends','public') NOT NULL DEFAULT 'public',
`user_privacy_birthdate` enum('me','friends','public') NOT NULL DEFAULT 'public',
`user_privacy_relationship` enum('me','friends','public') NOT NULL DEFAULT 'public',
`user_privacy_basic` enum('me','friends','public') NOT NULL DEFAULT 'public',
`user_privacy_work` enum('me','friends','public') NOT NULL DEFAULT 'public',
`user_privacy_location` enum('me','friends','public') NOT NULL DEFAULT 'public',
`user_privacy_education` enum('me','friends','public') NOT NULL DEFAULT 'public',
`user_privacy_other` enum('me','friends','public') NOT NULL DEFAULT 'public',
`user_privacy_friends` enum('me','friends','public') NOT NULL DEFAULT 'public',
`user_privacy_photos` enum('me','friends','public') NOT NULL DEFAULT 'public',
`user_privacy_pages` enum('me','friends','public') NOT NULL DEFAULT 'public',
`user_privacy_groups` enum('me','friends','public') NOT NULL DEFAULT 'public',
`user_privacy_events` enum('me','friends','public') NOT NULL DEFAULT 'public',
`email_post_likes` enum('0','1') NOT NULL DEFAULT '1',
`email_post_comments` enum('0','1') NOT NULL DEFAULT '1',
`email_post_shares` enum('0','1') NOT NULL DEFAULT '1',
`email_wall_posts` enum('0','1') NOT NULL DEFAULT '1',
`email_mentions` enum('0','1') NOT NULL DEFAULT '1',
`email_profile_visits` enum('0','1') NOT NULL DEFAULT '1',
`email_friend_requests` enum('0','1') NOT NULL DEFAULT '1',
`facebook_connected` enum('0','1') NOT NULL DEFAULT '0',
`facebook_id` varchar(128) DEFAULT NULL,
`google_connected` enum('0','1') NOT NULL DEFAULT '0',
`google_id` varchar(128) DEFAULT NULL,
`twitter_connected` enum('0','1') NOT NULL DEFAULT '0',
`twitter_id` varchar(128) DEFAULT NULL,
`instagram_connected` enum('0','1') NOT NULL DEFAULT '0',
`instagram_id` varchar(128) DEFAULT NULL,
`linkedin_connected` enum('0','1') NOT NULL DEFAULT '0',
`apple_connected` enum('0','1') NOT NULL DEFAULT '0',
`linkedin_id` varchar(128) DEFAULT NULL,
`apple_id` varchar(128) DEFAULT NULL,
`vkontakte_connected` enum('0','1') NOT NULL DEFAULT '0',
`vkontakte_id` varchar(128) DEFAULT NULL,
`user_referrer_id` int DEFAULT NULL,
`user_affiliate_balance` varchar(64) NOT NULL DEFAULT '0',
`user_wallet_balance` decimal(4,0) NOT NULL DEFAULT '0',
`user_points` int NOT NULL DEFAULT '0',
`chat_sound` enum('0','1') NOT NULL DEFAULT '0',
`notifications_sound` enum('0','1') NOT NULL DEFAULT '0',
`onesignal_user_id` varchar(100) DEFAULT NULL,
`user_language` varchar(16) DEFAULT 'en_us',
`first` varchar(254) DEFAULT NULL,
`second` varchar(254) DEFAULT NULL,
`third` varchar(254) DEFAULT NULL,
`fourth` varchar(254) DEFAULT NULL,
`fifth` varchar(254) DEFAULT NULL,
`squad_name` varchar(254) NOT NULL DEFAULT 'The Squad',
`card_cover` varchar(254) NOT NULL DEFAULT 'disabled',
`spotify` varchar(453) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`total_xp` bigint NOT NULL DEFAULT '0',
`game1` varchar(254) DEFAULT NULL,
`game2` varchar(254) DEFAULT NULL,
`game3` varchar(254) DEFAULT NULL,
`exolved` enum('0','1') NOT NULL DEFAULT '0',
`valk` enum('0','1') NOT NULL DEFAULT '0',
`titus` enum('0','1') NOT NULL DEFAULT '0',
`poss` enum('0','1') NOT NULL DEFAULT '0',
`safe` enum('0','1') NOT NULL DEFAULT '0',
`firstresponder` enum('0','1') NOT NULL DEFAULT '0',
`firstresponder_badge` enum('0','1') NOT NULL DEFAULT '0',
`military_badge` enum('0','1') NOT NULL DEFAULT '0',
`military` enum('0','1') NOT NULL DEFAULT '0',
`gg_badge` enum('0','1') NOT NULL DEFAULT '0',
`gg` enum('0','1') NOT NULL DEFAULT '0',
`aero` enum('0','1') NOT NULL DEFAULT '0',
`zodiac` enum('0','1') NOT NULL DEFAULT '0',
`sway` enum('0','1') NOT NULL DEFAULT '0',
`partner_member` enum('0','1') NOT NULL DEFAULT '0',
`css` text,
`lfg` enum('0','1') NOT NULL DEFAULT '0',
`lfg_text` varchar(256) DEFAULT NULL,
`user_social_discord` varchar(45) DEFAULT NULL,
`user_social_epic` varchar(45) DEFAULT NULL,
`user_social_trovo` varchar(45) DEFAULT NULL,
`live` enum('0','1') NOT NULL DEFAULT '0',
`searching` enum('0','1') NOT NULL DEFAULT '0',
`layout` int NOT NULL DEFAULT '1',
`user_token` varchar(255) DEFAULT NULL,
`tickets` int DEFAULT '0',
`tag` varchar(45) DEFAULT NULL,
`grinding` int NOT NULL DEFAULT '0',
`referrals` int DEFAULT '0',
`code` enum('0','1') DEFAULT '0',
`monthly` int NOT NULL DEFAULT '0',
`cancel_sub` enum('0','1') DEFAULT '0',
PRIMARY KEY (`user_id`),
UNIQUE KEY `username` (`user_name`),
UNIQUE KEY `user_email` (`user_email`),
UNIQUE KEY `facebook_id` (`facebook_id`),
UNIQUE KEY `twitter_id` (`twitter_id`),
UNIQUE KEY `linkedin_id` (`linkedin_id`),
UNIQUE KEY `vkontakte_id` (`vkontakte_id`),
UNIQUE KEY `instagram_id` (`instagram_id`),
UNIQUE KEY `user_phone` (`user_phone`),
UNIQUE KEY `google_id` (`google_id`),
KEY `apple_id` (`apple_id`),
KEY `idx_last_seen_online` (`user_last_seen`) USING BTREE COMMENT 'Typically used for sorting'
) ENGINE=InnoDB AUTO_INCREMENT=6598 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
good share dude,
just...
Deleted
The transfer you requested has been deleted.
Posts: 123
Threads: 32
Joined: Jun 2024
Posts: 19,939
Threads: 357
Joined: Jun 2023
Jul 10, 2024, 11:48 PM
(This post was last modified: Jul 11, 2024, 12:37 AM by Addka72424.)
The link in this thread is dead. Please reply to the PM you were sent to get your thread moved back to the Databases section.
Hello,
The link on this thread has been updated as of this post.
Posts: 741
Threads: 16
Joined: Mar 2024
Thank you for this free db!
Data seems to be from 2022-06.
Posts: 123
Threads: 32
Joined: Jun 2024
(Jul 11, 2024, 12:39 AM)jb75 Wrote: Thank you for this free db!
Data seems to be from 2022-06.
if it's free show me proof only me i have it
Posts: 741
Threads: 16
Joined: Mar 2024
(Jul 11, 2024, 12:41 AM)playstation Wrote: (Jul 11, 2024, 12:39 AM)jb75 Wrote: Thank you for this free db!
Data seems to be from 2022-06.
if it's free show me proof only me i have it
lol.
Let me rephrase: Thank YOU for posting this leak here for free.
Posts: 123
Threads: 32
Joined: Jun 2024
(Jul 11, 2024, 12:43 AM)jb75 Wrote: (Jul 11, 2024, 12:41 AM)playstation Wrote: (Jul 11, 2024, 12:39 AM)jb75 Wrote: Thank you for this free db!
Data seems to be from 2022-06.
if it's free show me proof only me i have it
lol.
Let me rephrase: Thank YOU for posting this leak here for free.
oh shit sorry :p
Posts: 4,572
Threads: 456
Joined: Jun 2023
The link in this thread is dead. Please reply to the PM you were sent to get your thread moved back to the Databases section.
Thanks @ zehq for ranks!!!
|