brandarmy.com 2023 231k users sql dump
Brandarmy is a subscription-based fan-monetization platform where creators run paid "channels" (communities) to share exclusive posts, videos/livestreams, and message with subscribers.
Date: 2023-05-26
Format: sql
Users: ~231000
Size (Uncompressed): 5.57GB
Data: Users,Transactions,Messages
https://gofile.io/d/ORkWjS
Sample (users table)
Brandarmy is a subscription-based fan-monetization platform where creators run paid "channels" (communities) to share exclusive posts, videos/livestreams, and message with subscribers.
Date: 2023-05-26
Format: sql
Users: ~231000
Size (Uncompressed): 5.57GB
Data: Users,Transactions,Messages
https://gofile.io/d/ORkWjS
Sample (users table)
--
-- Table structure for table `BASystemUsers`
--
CREATE TABLE `BASystemUsers` (
`id` int NOT NULL,
`name` varchar(512) DEFAULT NULL,
`gender` varchar(512) DEFAULT NULL,
`birthDate` bigint DEFAULT NULL,
`phoneNumber` varchar(512) DEFAULT NULL,
`aboutMe` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
`username` varchar(512) DEFAULT NULL,
`customUsername` varchar(512) DEFAULT NULL,
`displayName` varchar(512) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`location` varchar(512) DEFAULT NULL,
`websiteUrl` varchar(512) DEFAULT NULL,
`amazonWishlistUrl` varchar(512) DEFAULT NULL,
`referralCode` varchar(512) DEFAULT NULL,
`referredBy` varchar(512) DEFAULT NULL,
`status` varchar(512) DEFAULT NULL,
`stripeCustomerId` varchar(512) DEFAULT NULL,
`stripeAccountId` varchar(512) DEFAULT NULL,
`createdDttm` bigint DEFAULT NULL,
`updatedDttm` bigint DEFAULT NULL,
`lastSeenDttm` bigint DEFAULT NULL,
`realm` varchar(512) DEFAULT NULL,
`password` varchar(512) NOT NULL,
`email` varchar(512) NOT NULL,
`emailVerified` tinyint(1) DEFAULT NULL,
`verificationToken` varchar(512) DEFAULT NULL,
`bucketId` varchar(512) DEFAULT NULL,
`coverImageId` int DEFAULT NULL,
`profileImageId` int DEFAULT NULL,
`bAWalletId` int DEFAULT NULL,
`role` enum('user','superadmin') DEFAULT 'user',
`fbAccessToken` varchar(512) DEFAULT NULL,
`fbUserId` varchar(512) DEFAULT NULL,
`appleIdToken` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci,
`appleTokenSubject` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci,
`isDeleted` tinyint(1) DEFAULT '0',
`isBlocked` tinyint(1) DEFAULT '0',
`isDiscoverable` tinyint(1) DEFAULT '1' COMMENT '0 - Not discoverable | 1 - Discoverable',
`isLiveEligible` tinyint(1) DEFAULT '0',
`ccApproval` tinyint(1) DEFAULT '0',
`ccApproved` tinyint(1) DEFAULT '0',
`mobileCoverImageId` int DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Dumping data for table `BASystemUsers`
--
INSERT INTO `BASystemUsers` (`id`, `name`, `gender`, `birthDate`,
`phoneNumber`, `aboutMe`, `username`, `customUsername`, `displayName`,
`location`, `websiteUrl`, `amazonWishlistUrl`, `referralCode`,
`referredBy`, `status`, `stripeCustomerId`, `stripeAccountId`,
`createdDttm`, `updatedDttm`, `lastSeenDttm`, `realm`, `password`,
`email`, `emailVerified`, `verificationToken`, `bucketId`,
`coverImageId`, `profileImageId`, `bAWalletId`, `role`, `fbAccessToken`,
`fbUserId`, `appleIdToken`, `appleTokenSubject`, `isDeleted`,
`isBlocked`, `isDiscoverable`, `isLiveEligible`, `ccApproval`,
`ccApproved`, `mobileCoverImageId`) VALUES
(1, 'Jeevan Betigeri Prod', NULL, NULL, '+1-2144496933', 'Two time
Granny award winning music artist. My granny said i am the best -
twice!', 'u31jdkoe524', 'jeevanmusic', 'Jeevan Music', '',
'https://www.jeevanmusic.com', '', 'jeevanmusic', 'bovmra', 'active',
'cus_I9W1Lqt1gzs4aZ', NULL, 1601841015955, 1684987309368, 1684987309368,
NULL, '$2a$10$J/K/I0GuZMGQhKPT4Hx3VesnC66xjkMMp49JxfJUn9CLAalyKsWse', 'genius_g1@yahoo.com',
1, NULL, 'byzjd47d5kn', 106, 15, 1, 'user',
'10224527117030690', NULL, NULL, 0, 0, 1, 1, 1, 0, NULL),
(2, 'Adam Paul', NULL, NULL, NULL, NULL, 'u456gl9g91l', 'u456gl9g91l',
'Adam Paul', NULL, NULL, NULL, 'rbejja', NULL, 'active', NULL, NULL,
1601841114928, 1648700789714, 1648700789714, NULL,
'$2a$10$LCATaC19EY3dMR37BnQBW.4iTnEDNZg6YdMAkEoXMSh/qZcuQeSYi', 'baadam@mailinator.com', 1, NULL, 'b9w5g5penkr', NULL, 2, 2, 'user', NULL, NULL, NULL, NULL, 0, 0, 1, 0, 0, 0, NULL),
(3, 'Paul James', NULL, NULL, NULL, NULL, 'uo9memje214', 'uo9memje214',
'Paul James', NULL, NULL, NULL, 'pagdpb', NULL, 'active', NULL, NULL,
1601872615394, 1601872615394, NULL, NULL,
'$2a$10$ocokU/.2AOhNV0pqiwfBg.CFazR0aPlA3p.INvmkkHApfLHn3uXP6', 'bapaul@mailinator.com', 1, NULL, 'b3wve6rep40', NULL, NULL, 3, 'user', NULL, NULL, NULL, NULL, 0, 0, 1, 0, 0, 0, NULL),
(4, 'Sachin Kulkarni', NULL, NULL, '+91-9823178430', '<p>Eat.
Sleep. Code. Repeat.</p>', 'uq1xdn0e037', 'TheRockstar', 'Sachin
Kulkarni ?', 'United States', 'www.brandarmy.com/TheRockstar', NULL,
'lajjoa', NULL, 'active', 'cus_I9BdgFcROLZXZA', 'acct_1JhYJYQYVpqpf1FV',
1601883029902, 1684892404506, 1684892404506, NULL,
'$2a$10$pm/pOECTg1zrVBA9pdlow.oJxohe2gJJf5Jy80jwTHpzT86HDNYLi', 'sachinkulkarni333@gmail.com',
1, NULL, 'byw4d7qeorx', 141399, 178623, 4, 'user',
'4121493134535611', NULL, NULL, 0, 0, 1, 1, 1, 0, NULL),
(5, 'Mynmar', NULL, NULL, NULL, 'Neymar da Silva Santos Júnior, known as
Neymar, is a Brazilian professional footballer who plays as a forward
for Ligue 1 club Paris Saint-Germain and the Brazil national team. He is
widely considered as one of the best players in the world. \nNeymar
came into prominence at Santos, where he made his professional debut
aged 17. He helped the club win two successive Campeonato Paulista
championships, a Copa do Brasil, and the 2011 Copa Libertadores; the
latter being Santos\' first since 1963. Neymar was twice named the South
American Footballer of the Year, in 2011 and 2012, and soon relocated
to Europe to join Barcelona. As part of Barcelona\'s attacking trio with
Lionel Messi and Luis Suárez, ', 'u01jgo5el24', 'u01jgo5el24',
'Neymar', 'Brazil', 'www.google.co.in', 'www.amazon.in', 'lakkpa', NULL,
'active', 'cus_I999rZed4tCUqJ', NULL, 1601883719586, 1637924356220,
1637924356220, NULL,
'$2a$10$Kz98QWpixaHYcwhogw2imudsZYLXoe41oxKf24IuBdm1K1gCRbAjC', 'ba_neymar@mailinator.com', 1, NULL, 'bok4g8je598', 5, 11, 5, 'user', NULL, NULL, NULL, NULL, 0, 0, 1, 0, 0, 0, NULL),
(6, 'omkar', NULL, NULL, NULL, '<p>Quality is everyone\'s
responsibility</p>', 'u631epjenrx', 'testdavid', 'David ?',
'kolhapur', NULL, NULL, 'qallga', NULL, 'active', NULL, NULL,
1601883804468, 1681908443564, 1681908443564, NULL,
'$2a$10$GdnFZi4sLtKv8671j2Viu.tg4Cihvrk8Cbq.m/34rrGmr5UEurpf6', 'omkar@fathomable.in', 1, NULL, 'b34qe9pg150', 3, 4, 6, 'user', NULL, NULL, NULL, NULL, 0, 0, 1, 0, 0, 0, NULL),
(7, 'Chris123!', NULL, NULL, NULL, NULL, 'u8q0dq9eo14', 'u8q0dq9eo14',
'Kia', NULL, NULL, NULL, 'pamdgb', 'lakkpa', 'active',
'cus_I9oMdfYprjwk30', NULL, 1601892141267, 1601892141267, NULL, NULL,
'$2a$10$DP5GBNrK8yLmSdlF2tkfyeNdpxXeRhmTuJ0bfptlXQwUi3Syxk8.u', 'ba_kia@mailinator.com', 1, NULL, 'b3pzg0ne9w1', NULL, NULL, 7, 'user', NULL, NULL, NULL, NULL, 0, 0, 1, 0, 0, 0, NULL),
(8, 'Doneric', NULL, NULL, NULL, NULL, 'u0pkgr4d6o3', 'u0pkgr4d6o3',
'Rick', NULL, NULL, NULL, 'panlya', NULL, 'active',
'cus_I9BMmBRTzRDX75', NULL, 1601893496276, 1648654625672, 1648654625672,
NULL, '$2a$10$uCH9iz11q/jh2ZJrkDZ95.eJNhq.ThAldgGkghuy0.gL9JQmfgsjy', 'ba_rick@mailinator.com', 1, NULL, 'boj3ejlwdp6', NULL, 17, 8, 'user', NULL, NULL, NULL, NULL, 0, 0, 1, 0, 0, 0, NULL),
(9, 'DEEPAK MADNAIK ', NULL, NULL, NULL, '<p>Life is
beautiful</p>', 'unzkev3d354', 'Tester1', 'BA Test dsm', 'Las
vegas', 'www.google.com', '', 'paolwb', NULL, 'active',
'cus_I9AWSVMMS5puTM', NULL, 1601896864887, 1685005890574, 1685005890574,
NULL, '$2a$10$TOy.IZzGpJnmYypmkwIJyeToh8qAWSKEXF226ti1M3yagUt6NGHFi', 'Dsmadnaik@gmail.com', 1, NULL, 'b31jdkooe52', 175810, 175811, 9, 'user', NULL, NULL, NULL, NULL, 0, 0, 1, 1, 1, 0, NULL),
(10, 'Doneric', NULL, NULL, NULL, 'Production user.', 'uw5ldwkdor0',
'Testers', 'Rahul', 'Las Vegas', 'www.fathomable.com', 'www.amazon.com',
'', NULL, 'active', 'cus_I9E8HDJtIxS52o', NULL, 1601911428223,
1601975047638, NULL, NULL,
'$2a$10$0696Kq7159by2qMak9zlfuwV5sVlH.JWJa4EnJXWndO19YIJD/rG6', 'ba_tester@mailinator.com', 1, NULL, 'boj3ej13ep6', NULL, 29, 10, 'user', NULL, NULL, NULL, NULL, 0, 0, 1, 0, 0, 0, NULL);