Re: Query challengers table
SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;
-- ----------------------------
-- Table structure for users
-- ----------------------------
DROP TABLE IF EXISTS `users`;
CREATE TABLE `users` (
`user_id` bigint(20) NOT NULL AUTO_INCREMENT,
`user_uuid` varchar(255) DEFAULT NULL,
`first_name` varchar(255) DEFAULT NULL,
`last_name` varchar(255) DEFAULT NULL,
`email_address` varchar(255) NOT NULL,
PRIMARY KEY (`user_id`),
UNIQUE KEY `idx_users_email_address` (`email_address`)
) ENGINE=InnoDB AUTO_INCREMENT=1126 DEFAULT CHARSET=utf8mb4;
-- ----------------------------
-- Records of users
-- ----------------------------
BEGIN;
INSERT INTO `users` VALUES (1001, '5c9b83c2-d6b2-11eb-b3ce-008cfa12d1e1', 'Jassim', 'Al Rahma', 'email@domain.com');
INSERT INTO `users` VALUES (1102, '5c9b83c2-d6b2-11eb-b3ce-008cfa12d1e1', 'User1', 'Last1', 'email@domain.com');
INSERT INTO `users` VALUES (1103, '5c9b83c2-d6b2-11eb-b3ce-008cfa12d1e1', 'User2', 'Last2', 'email@domain.com');
INSERT INTO `users` VALUES (1100, '5c9b83c2-d6b2-11eb-b3ce-008cfa12d1e1', 'User3', 'Last3', '@domain.com');
INSERT INTO `users` VALUES (1082, '5c9b83c2-d6b2-11eb-b3ce-008cfa12d1e1', 'User4', 'Last4', 'email@domain.com');
INSERT INTO `users` VALUES (1051, '5c9b83c2-d6b2-11eb-b3ce-008cfa12d1e1', 'User5', 'Last5', 'email@domain.com');
INSERT INTO `users` VALUES (1049, '5c9b83c2-d6b2-11eb-b3ce-008cfa12d1e1', 'User6', 'Last6', 'email@domain.com');
INSERT INTO `users` VALUES (1045, '5c9b83c2-d6b2-11eb-b3ce-008cfa12d1e1', 'User7', 'Last7', 'email@domain.com');
INSERT INTO `users` VALUES (1042, '5c9b83c2-d6b2-11eb-b3ce-008cfa12d1e1', 'User8', 'Last8', 'email@domain.com');
COMMIT;
SET FOREIGN_KEY_CHECKS = 1;