22-10-25, 04:45 PM
(This post was last modified: 29-10-25, 08:25 PM by alec3899.
Edit Reason: new link
)
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.
Databreach Date: 2023-05-26
Format: sql
Users: ~231000
Size (Uncompressed): 5.57GB
Data: Users,Transactions,Messages
Download:
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.
Databreach Date: 2023-05-26
Format: sql
Users: ~231000
Size (Uncompressed): 5.57GB
Data: Users,Transactions,Messages
Download:
Sample (users table)
Code:
--
-- 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', 'EAAGYkgRkoOUBALraYQFspbxuysMOZB9pvReoq6CpHtPG4YKW1QILeZBV2J2EI6vBs25ix171Xm8xXyE5g7HY0QDhipjcSze3lOAPRPDbV55TsjxlPXL06rBOtOjAAhUfEZAsYxZBpgaSu2aNDvUpuiLN2popIthAYuB9NhVqypSBFQDKTzdH0VFzwYBDXMJrJPZAaZCcWPAPF9hJLgKCzxI24zoyXumQg5KxxYfDjGFLvs7FVgLXDj', '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', 'EAAGYkgRkoOUBAJZBJSMQPAZA7xpatcLvTj8iho0DvYhUomZBr9Y7ZCvQdcmUk0zozAL0gVkb7LErJAb5E4RsxA9YtBMTMlhZAyUVZCDQvKlS37QNUlssfVWJo4ZCZBUBGwx6iV0tlRGTeZAIbkOrNaC2elP8K2yRuA5YDC2BpqBxSOseHoT7UjhlR2IJZCKirEPRmUZBb7vIeuJhgZDZD', '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);