SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
START TRANSACTION;
SET time_zone = "+00:00";

CREATE TABLE `users` (
    `id` int NOT NULL AUTO_INCREMENT,
    `first_name` varchar(14) CHARACTER SET utf8 COLLATE utf8_spanish_ci NOT NULL,
    `last_name` varchar(14) CHARACTER SET utf8 COLLATE utf8_spanish_ci NOT NULL,
    `gender` enum('M','F') CHARACTER SET utf8 COLLATE utf8_spanish_ci NOT NULL,
    `reg_date` date NOT NULL,
    PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_spanish_ci;

INSERT INTO `users` (`id`, `first_name`, `last_name`, `gender`, `reg_date`) VALUES
(1, 'Georgi', 'Facello', 'M', '1986-06-26'),
(2, 'Bezalel', 'Simmel', 'F', '1985-11-21'),
(3, 'Parto', 'Bamford', 'M', '1986-08-28'),
(4, 'Chirstian', 'Koblick', 'M', '1986-12-01'),
(5, 'Kyoichi', 'Maliniak', 'M', '1989-09-12'),
(6, 'Anneke', 'Preusig', 'F', '1989-06-02'),
(7, 'Tzvetan', 'Zielinski', 'F', '1989-02-10'),
(8, 'Saniya', 'Kalloufi', 'M', '1994-09-15'),
(9, 'Sumant', 'Peac', 'F', '1985-02-18'),
(10, 'Duangkaew', 'Piveteau', 'F', '1989-08-24'),
(11, 'Mary', 'Sluis', 'F', '1990-01-22'),
(12, 'Patricio', 'Bridgland', 'M', '1992-12-18'),
(13, 'Eberhardt', 'Terkki', 'M', '1985-10-20'),
(14, 'Berni', 'Genin', 'M', '1987-03-11'),
(15, 'Guoxiang', 'Nooteboom', 'M', '1987-07-02'),
(16, 'Kazuhito', 'Cappelletti', 'M', '1995-01-27'),
(17, 'Cristinel', 'Bouloucos', 'F', '1993-08-03'),
(18, 'Kazuhide', 'Peha', 'F', '1987-04-03'),
(19, 'Lillian', 'Haddadi', 'M', '1999-04-30'),
(20, 'Mayuko', 'Warwick', 'M', '1991-01-26'),
(21, 'Ramzi', 'Erde', 'M', '1988-02-10'),
(22, 'Shahaf', 'Famili', 'M', '1995-08-22'),
(23, 'Bojan', 'Montemayor', 'F', '1989-12-17'),
(24, 'Suzette', 'Pettey', 'F', '1997-05-19'),
(25, 'Prasadram', 'Heyers', 'M', '1987-08-17'),
(26, 'Yongqiao', 'Berztiss', 'M', '1995-03-20'),
(27, 'Divier', 'Reistad', 'F', '1989-07-07'),
(28, 'Domenick', 'Tempesti', 'M', '1991-10-22'),
(29, 'Otmar', 'Herbst', 'M', '1985-11-20'),
(30, 'Elvis', 'Demeyer', 'M', '1994-02-17');
