katnisseverdeen_older.sql

-- phpMyAdmin SQL Dump
-- version 4.2.7.1
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Nov 15, 2015 at 10:17 PM
-- Server version: 5.6.20-log
-- PHP Version: 5.4.31

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


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;

--
-- Database: `katnisseverdeen`
--

-- --------------------------------------------------------

--
-- Table structure for table `bachelor`
--

CREATE TABLE IF NOT EXISTS `bachelor` (
`id` int(11) NOT NULL,
  `username` varchar(100) COLLATE latin1_bin NOT NULL,
  `password` varchar(100) COLLATE latin1_bin NOT NULL,
  `email` varchar(100) COLLATE latin1_bin NOT NULL,
  `numberOfLikes` int(11) NOT NULL,
  `idbookgenres` int(11) NOT NULL,
  `idbrands` int(11) NOT NULL,
  `idhobbies` int(11) NOT NULL,
  `idmoviegenres` int(11) NOT NULL,
  `idmusicgenres` int(11) NOT NULL,
  `idsports` int(11) NOT NULL
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 COLLATE=latin1_bin AUTO_INCREMENT=506 ;

--
-- Dumping data for table `bachelor`
--

INSERT INTO `bachelor` (`id`, `username`, `password`, `email`, `numberOfLikes`, `idbookgenres`, `idbrands`, `idhobbies`, `idmoviegenres`, `idmusicgenres`, `idsports`) VALUES
(1, 'samnang', 'suon', 'samnangsuon@admin.com', 999999999, 1, 2, 3, 4, 5, 6),
(2, 'kismony', 'ladouceur', 'kismonyladouceur@admin.com', 999999999, 7, 8, 9, 10, 1, 2),
(3, 'miranda', 'kerr', 'mirandakerr@victoriasecret.com', 864205, 5, 6, 7, 8, 9, 10),
(4, 'candice', 'swanepoel', 'candiceswanepoel@victoriasecret.com', 1086420, 9, 10, 1, 2, 3, 4),
(5, 'michelle', 'keagan', 'michellekeagan@beauty.com', 6804213, 3, 4, 5, 6, 7, 8),
(99, 'Jaquelyn', 'Brynn', 'tempor.lorem.eget@amet.ca', 936528, 5, 7, 7, 2, 2, 6),
(98, 'Hamish', 'Serina', 'sit.amet@telluseu.edu', 285368, 4, 1, 9, 8, 1, 8),
(97, 'Matthew', 'Oleg', 'blandit@felisorci.co.uk', 224330, 3, 3, 8, 2, 4, 6),
(96, 'Desirae', 'Velma', 'neque.pellentesque@ipsum.co.uk', 510795, 10, 1, 3, 7, 9, 3),
(95, 'Candice', 'Mufutau', 'lectus.ante.dictum@pharetrasedhendrerit.net', 949348, 2, 7, 4, 6, 9, 6),
(94, 'Hanna', 'Rose', 'enim@neceuismod.edu', 680321, 9, 4, 5, 4, 8, 7),
(93, 'Lee', 'Jessica', 'Class@purusgravida.com', 583734, 1, 4, 1, 10, 10, 1),
(92, 'Kadeem', 'Ayanna', 'velit.Quisque@aliquetmetus.edu', 540458, 3, 10, 8, 1, 3, 6),
(91, 'Chaney', 'Sonia', 'eget@libero.ca', 956410, 10, 6, 1, 6, 7, 6),
(90, 'Ramona', 'Audra', 'nec@sapienmolestie.edu', 393645, 9, 8, 8, 8, 9, 1),
(89, 'Vera', 'Sara', 'urna.suscipit.nonummy@risusNulla.net', 978243, 10, 2, 7, 10, 3, 3),
(88, 'Logan', 'Uriah', 'dui.augue.eu@lacinia.co.uk', 547519, 3, 4, 4, 10, 4, 7),
(87, 'MacKensie', 'Aretha', 'vel.sapien@augueid.com', 836397, 1, 10, 4, 4, 7, 1),
(86, 'Madison', 'Zephania', 'eu@In.co.uk', 236042, 8, 8, 8, 9, 8, 9),
(85, 'Chava', 'Georgia', 'augue@aliquam.co.uk', 643452, 7, 3, 4, 3, 3, 10),
(84, 'Vivien', 'Eliana', 'viverra.Maecenas@ipsumdolor.co.uk', 283621, 7, 5, 1, 5, 1, 2),
(83, 'Jade', 'Cain', 'posuere.vulputate.lacus@ornare.ca', 648832, 10, 6, 7, 8, 9, 8),
(82, 'Shellie', 'Melinda', 'facilisis.magna.tellus@libero.net', 470801, 3, 4, 6, 3, 5, 9),
(81, 'Cassady', 'Wade', 'mattis@Vestibulumut.net', 283894, 5, 2, 10, 1, 5, 2),
(80, 'Cole', 'Caldwell', 'nunc.sed.libero@Pellentesquehabitant.edu', 52274, 6, 10, 5, 4, 9, 5),
(79, 'Denton', 'Mollie', 'semper.egestas.urna@Cumsociisnatoque.com', 971460, 9, 1, 2, 6, 6, 2),
(78, 'Otto', 'Nolan', 'mauris.sit.amet@facilisisfacilisismagna.ca', 88348, 1, 5, 2, 4, 1, 2),
(77, 'Neville', 'Kellie', 'vulputate@laoreetposuereenim.com', 468846, 4, 7, 6, 1, 10, 8),
(76, 'Kyla', 'Brent', 'sit.amet@faucibusorciluctus.co.uk', 464649, 9, 3, 1, 10, 4, 8),
(75, 'Patrick', 'Ezra', 'nec.eleifend.non@dapibusidblandit.com', 678539, 1, 4, 5, 4, 9, 2),
(74, 'Shannon', 'Reuben', 'facilisis@metusvitaevelit.edu', 365810, 4, 5, 4, 9, 7, 6),
(73, 'Paloma', 'Carolyn', 'massa.Quisque@egetlaoreetposuere.net', 381347, 10, 2, 3, 5, 6, 8),
(72, 'Jenette', 'Carlos', 'ligula.tortor.dictum@etarcu.co.uk', 642128, 7, 5, 7, 3, 1, 4),
(71, 'Tanner', 'Aimee', 'facilisis.lorem@Aeneangravidanunc.co.uk', 623342, 5, 6, 8, 8, 8, 8),
(70, 'Zephania', 'Alexander', 'vel@enimdiamvel.org', 75882, 7, 8, 10, 9, 6, 2),
(69, 'Elvis', 'Merrill', 'nec.mauris.blandit@necmauris.net', 315942, 10, 6, 1, 1, 6, 5),
(68, 'Warren', 'Stacey', 'mus@quisarcuvel.co.uk', 351851, 2, 6, 7, 1, 4, 4),
(67, 'Ria', 'Matthew', 'malesuada@a.net', 599910, 1, 3, 3, 5, 4, 10),
(66, 'Rama', 'Carlos', 'risus.varius@quispedePraesent.edu', 222562, 10, 8, 8, 3, 2, 4),
(65, 'Beverly', 'Dane', 'magna.Nam@eu.edu', 998619, 2, 3, 2, 3, 4, 3),
(64, 'Ferdinand', 'Aurelia', 'cursus.et@ipsumnonarcu.co.uk', 73273, 10, 1, 4, 9, 2, 7),
(63, 'Haviva', 'Dante', 'Donec.non.justo@Nullamvelitdui.net', 831185, 1, 6, 10, 8, 6, 9),
(62, 'Jana', 'Finn', 'a@ad.net', 801723, 7, 8, 8, 7, 8, 4),
(61, 'Lucius', 'Jorden', 'neque@ullamcorpereu.net', 514136, 2, 10, 1, 1, 9, 5),
(60, 'Hammett', 'Keelie', 'mauris.aliquam.eu@necimperdietnec.co.uk', 338044, 9, 10, 6, 4, 3, 7),
(59, 'Debra', 'Darius', 'Nunc.mauris@est.edu', 380177, 4, 10, 9, 4, 10, 5),
(58, 'Maisie', 'Catherine', 'iaculis@egestasrhoncusProin.edu', 640224, 4, 4, 10, 1, 2, 2),
(57, 'Ruby', 'Ashton', 'Curae.Phasellus.ornare@metuseu.co.uk', 409141, 3, 10, 5, 4, 8, 8),
(56, 'Nola', 'Caldwell', 'nonummy.ultricies@nec.ca', 843288, 9, 2, 10, 9, 3, 6),
(55, 'Rudyard', 'Zorita', 'fringilla@Suspendisse.net', 135377, 2, 7, 10, 5, 3, 2),
(54, 'Mari', 'Carissa', 'hendrerit.consectetuer@sedsemegestas.com', 237400, 7, 6, 5, 7, 10, 10),
(53, 'Mollie', 'Dana', 'eu.metus@loremloremluctus.org', 704380, 10, 2, 1, 4, 1, 4),
(52, 'Deacon', 'Britanni', 'consectetuer.ipsum@temporarcuVestibulum.ca', 717559, 9, 4, 4, 10, 6, 7),
(51, 'Ursa', 'Abel', 'malesuada.Integer.id@Nullasemper.org', 547281, 4, 10, 6, 4, 10, 6),
(50, 'Miranda', 'Burke', 'euismod.est@Morbimetus.ca', 85187, 8, 10, 2, 6, 4, 9),
(49, 'Hasad', 'Justine', 'Sed.et@augueporttitorinterdum.net', 371617, 5, 8, 6, 10, 5, 4),
(48, 'Asher', 'Constance', 'sem@et.co.uk', 972501, 1, 6, 3, 3, 8, 1),
(47, 'Darrel', 'Gillian', 'nulla@et.edu', 447488, 8, 8, 4, 4, 4, 3),
(46, 'August', 'Melissa', 'lorem.vitae@sedorci.com', 177113, 4, 7, 3, 4, 10, 1),
(45, 'Jade', 'Dacey', 'facilisis.magna@molestie.edu', 612591, 10, 6, 10, 5, 5, 1),
(44, 'William', 'Joshua', 'Nullam@lectusa.com', 563969, 7, 4, 6, 7, 5, 2),
(43, 'Amela', 'Bevis', 'rhoncus.Proin.nisl@Proinvel.co.uk', 583476, 4, 2, 3, 10, 10, 1),
(42, 'Azalia', 'Deanna', 'sagittis.felis@Namligulaelit.com', 17660, 8, 2, 9, 7, 9, 7),
(41, 'Lev', 'Cameran', 'erat.vitae@In.net', 145518, 7, 3, 6, 8, 4, 5),
(40, 'Flynn', 'Montana', 'Mauris.non.dui@Phaselluselit.org', 38841, 8, 8, 4, 7, 6, 5),
(39, 'Sylvia', 'Basia', 'Praesent.eu@convallis.org', 231102, 6, 9, 2, 3, 3, 10),
(38, 'Ivor', 'Erasmus', 'est@gravidamolestie.net', 80926, 8, 8, 2, 4, 7, 9),
(37, 'Lester', 'Anika', 'penatibus.et@Sed.net', 579836, 7, 7, 6, 4, 10, 7),
(36, 'Quinlan', 'Savannah', 'ullamcorper.Duis@turpisegestasFusce.net', 377279, 5, 8, 1, 10, 1, 10),
(35, 'Conan', 'Gay', 'facilisis.vitae.orci@non.ca', 905088, 1, 8, 5, 3, 6, 1),
(34, 'Grant', 'Ainsley', 'natoque@vitaeerat.com', 362547, 4, 1, 6, 3, 7, 2),
(33, 'Alfonso', 'Nola', 'ullamcorper@pedesagittisaugue.com', 885544, 9, 6, 7, 4, 10, 6),
(32, 'Ivory', 'Xerxes', 'molestie.pharetra@bibendum.net', 222885, 5, 6, 5, 8, 1, 10),
(31, 'Harrison', 'Ryan', 'feugiat@necquamCurabitur.ca', 818651, 6, 7, 5, 5, 10, 9),
(30, 'Emi', 'Hamilton', 'purus@sagittisplaceratCras.com', 746407, 10, 10, 1, 1, 4, 1),
(29, 'Kimberly', 'Stacy', 'tincidunt.nibh@auctor.net', 350845, 8, 6, 3, 3, 5, 1),
(28, 'Azalia', 'Amanda', 'viverra.Maecenas@sagittis.org', 730707, 8, 3, 10, 5, 10, 3),
(27, 'Anika', 'Regina', 'facilisis.facilisis.magna@ultricessitamet.net', 308195, 6, 1, 3, 9, 6, 9),
(26, 'Iliana', 'Fiona', 'erat.neque@ultricesDuisvolutpat.ca', 150949, 10, 8, 6, 8, 7, 6),
(25, 'Quon', 'Imani', 'convallis.convallis@purusMaecenaslibero.org', 192515, 1, 1, 9, 9, 8, 5),
(24, 'Hiram', 'Blair', 'Cras@vel.ca', 47217, 5, 9, 7, 4, 6, 8),
(23, 'Kermit', 'Arden', 'tincidunt.adipiscing.Mauris@lobortisnisinibh.com', 375996, 7, 3, 4, 5, 8, 10),
(22, 'Dane', 'Ivan', 'laoreet@tellusjusto.ca', 597333, 4, 10, 4, 10, 9, 3),
(21, 'Kelsey', 'Judith', 'at.risus.Nunc@pedemalesuadavel.org', 611148, 7, 1, 1, 4, 10, 3),
(20, 'Brynn', 'Ramona', 'a.felis@ridiculus.ca', 516838, 6, 5, 3, 7, 3, 3),
(19, 'Edan', 'Knox', 'ipsum.non.arcu@scelerisquenequesed.org', 287428, 8, 4, 8, 7, 7, 10),
(18, 'Quincy', 'Alisa', 'Cras.lorem@Aliquam.co.uk', 990021, 4, 8, 3, 10, 5, 10),
(17, 'Hunter', 'Fitzgerald', 'ipsum.dolor@sagittisNullamvitae.co.uk', 394817, 8, 6, 1, 9, 1, 8),
(16, 'Oren', 'Noelle', 'tortor.at.risus@Donecestmauris.co.uk', 636657, 4, 2, 6, 2, 1, 10),
(15, 'Carl', 'Henry', 'ultrices@euerat.co.uk', 459806, 10, 7, 1, 9, 2, 4),
(14, 'Judah', 'Regan', 'Quisque.libero@Duiselementumdui.ca', 986736, 4, 8, 3, 9, 2, 9),
(13, 'Cora', 'Sheila', 'mi.ac@orci.co.uk', 712644, 2, 9, 10, 9, 5, 2),
(12, 'Cleo', 'Blair', 'magna.Suspendisse@vehicularisus.edu', 58506, 8, 4, 5, 1, 3, 10),
(11, 'Jesse', 'Cameron', 'lectus.Cum@nibhsit.net', 96462, 1, 10, 7, 3, 6, 1),
(10, 'Marsden', 'Leo', 'Aliquam@temporbibendumDonec.net', 325847, 3, 3, 9, 10, 2, 1),
(9, 'Britanni', 'Priscilla', 'varius.ultrices@blanditviverra.org', 16562, 10, 2, 9, 6, 1, 1),
(8, 'Demetria', 'Kathleen', 'arcu.vel@a.ca', 672981, 4, 5, 3, 2, 1, 2),
(7, 'Ferdinand', 'Erich', 'eu.arcu@liberomaurisaliquam.org', 84476, 2, 3, 1, 7, 6, 6),
(6, 'Katelyn', 'Herman', 'dignissim.lacus.Aliquam@sempererat.com', 426221, 3, 8, 8, 5, 9, 5),
(100, 'Stone', 'Zena', 'eget.metus@ullamcorpereu.co.uk', 965349, 3, 9, 1, 6, 8, 4),
(101, 'Francis', 'Quincy', 'Nunc.pulvinar.arcu@nisimagnased.net', 631907, 9, 5, 7, 4, 10, 7),
(102, 'Leonard', 'Ria', 'vitae.risus@SeddictumProin.edu', 114526, 1, 10, 4, 2, 2, 6),
(103, 'Macaulay', 'Clark', 'commodo.auctor.velit@vehicula.ca', 953294, 2, 3, 10, 10, 5, 2),
(104, 'Hope', 'Murphy', 'sit@vulputatelacusCras.ca', 151077, 5, 4, 3, 6, 8, 6),
(105, 'Veda', 'Mannix', 'vitae@elementumategestas.com', 760279, 2, 10, 5, 2, 7, 6),
(106, 'Tanya', 'Sharon', 'consequat.auctor.nunc@Pellentesque.ca', 158083, 10, 2, 6, 10, 10, 5),
(107, 'Alfreda', 'Virginia', 'Aliquam.tincidunt@odioEtiam.org', 325134, 9, 3, 1, 4, 6, 3),
(108, 'Genevieve', 'Karina', 'ligula@montes.co.uk', 62230, 4, 4, 6, 10, 2, 1),
(109, 'Zelda', 'Dennis', 'eu.ultrices.sit@mollisdui.com', 937448, 6, 4, 2, 9, 7, 9),
(110, 'Kylynn', 'Jasper', 'tortor@enimCurabitur.co.uk', 484016, 1, 5, 5, 5, 2, 8),
(111, 'Davis', 'Mikayla', 'cursus.diam.at@cursus.co.uk', 926226, 8, 5, 2, 4, 8, 2),
(112, 'Dean', 'Ryder', 'pharetra@ametmetus.edu', 434272, 4, 8, 4, 5, 6, 8),
(113, 'Lavinia', 'Cain', 'sit.amet@sitametultricies.ca', 731741, 3, 9, 7, 1, 10, 4),
(114, 'Jarrod', 'Risa', 'odio.vel.est@duinec.co.uk', 843521, 5, 5, 5, 5, 8, 2),
(115, 'Elliott', 'Louis', 'egestas@cubilia.ca', 781356, 5, 3, 5, 7, 9, 6),
(116, 'Zenaida', 'Oleg', 'aliquam.iaculis.lacus@elementum.co.uk', 800792, 6, 3, 10, 10, 4, 7),
(117, 'Natalie', 'Emery', 'bibendum@lectuspede.org', 406903, 1, 4, 9, 4, 6, 7),
(118, 'Ivy', 'Flynn', 'ut.cursus@quis.org', 281638, 5, 3, 9, 7, 9, 6),
(119, 'Caleb', 'Thor', 'cursus.et.eros@ipsumcursusvestibulum.net', 759257, 5, 5, 6, 10, 4, 5),
(120, 'Mona', 'Bertha', 'amet.ultricies@magna.org', 232061, 7, 2, 6, 1, 10, 5),
(121, 'Aline', 'Zenaida', 'et.magna@consectetuerrhoncus.com', 620078, 9, 8, 5, 1, 7, 6),
(122, 'Melyssa', 'Wesley', 'volutpat.nunc.sit@lectus.net', 91151, 7, 2, 6, 1, 7, 3),
(123, 'Shelly', 'Maia', 'vitae.purus.gravida@disparturient.ca', 764529, 2, 6, 6, 3, 7, 2),
(124, 'Breanna', 'Charity', 'rhoncus.Proin.nisl@adipiscing.net', 698125, 6, 6, 2, 7, 4, 4),
(125, 'Madison', 'Violet', 'luctus@acurnaUt.edu', 427965, 8, 3, 5, 5, 8, 6),
(126, 'Nerea', 'Brianna', 'et.magnis.dis@malesuadaid.org', 903623, 2, 6, 4, 4, 3, 4),
(127, 'Cain', 'Stacey', 'pellentesque@molestieintempus.org', 670420, 10, 10, 3, 6, 3, 4),
(128, 'Iliana', 'Walker', 'mauris.sagittis.placerat@aliquameu.net', 343897, 9, 7, 4, 7, 8, 2),
(129, 'Yolanda', 'Hakeem', 'egestas.Aliquam@Nullamenim.com', 226623, 5, 4, 6, 4, 4, 8),
(130, 'Owen', 'Nayda', 'Cras.eget@inaliquet.com', 867515, 10, 5, 1, 4, 2, 10),
(131, 'Fitzgerald', 'Ray', 'Donec.feugiat.metus@Cumsociis.co.uk', 840517, 9, 10, 1, 2, 3, 2),
(132, 'Oliver', 'Deacon', 'enim.condimentum@laoreet.org', 833842, 4, 5, 2, 8, 6, 2),
(133, 'Melanie', 'Daryl', 'imperdiet.non@purus.com', 939161, 6, 6, 1, 3, 1, 10),
(134, 'Medge', 'Austin', 'orci.Ut.sagittis@lectus.com', 897649, 6, 3, 5, 3, 4, 8),
(135, 'Rosalyn', 'Carl', 'dui@fermentum.edu', 202932, 8, 6, 1, 5, 1, 7),
(136, 'Kendall', 'MacKensie', 'purus@ut.edu', 585295, 6, 9, 6, 1, 10, 9),
(137, 'Althea', 'Ora', 'quis@Vivamusnibh.org', 886880, 5, 5, 4, 1, 7, 1),
(138, 'Wynter', 'Meghan', 'et@etcommodo.co.uk', 466479, 8, 2, 3, 8, 1, 4),
(139, 'Eugenia', 'Caldwell', 'tincidunt.nunc.ac@Sed.com', 933876, 5, 4, 8, 6, 1, 1),
(140, 'Palmer', 'Ashton', 'Vestibulum.accumsan.neque@apurus.org', 834173, 10, 1, 8, 9, 7, 3),
(141, 'Elvis', 'Carl', 'magna.a.tortor@elita.com', 140329, 4, 2, 1, 2, 5, 7),
(142, 'Tanek', 'Kuame', 'ac.orci.Ut@convallisligula.org', 894502, 1, 8, 3, 9, 5, 4),
(143, 'Kimberly', 'May', 'Suspendisse.eleifend.Cras@laoreetposuere.org', 183235, 1, 8, 8, 3, 2, 9),
(144, 'Baxter', 'Rebecca', 'ante.ipsum@velarcuCurabitur.org', 205302, 4, 7, 4, 9, 7, 2),
(145, 'Diana', 'Ayanna', 'nibh.Quisque.nonummy@convallisconvallisdolor.co.uk', 318493, 3, 9, 5, 9, 4, 6),
(146, 'Winter', 'Hoyt', 'neque.pellentesque@musAenean.edu', 234797, 7, 9, 2, 4, 5, 2),
(147, 'Axel', 'Lacy', 'scelerisque.neque@magna.org', 422644, 5, 8, 7, 8, 6, 6),
(148, 'Lydia', 'Bianca', 'nostra.per@quispedePraesent.com', 798332, 2, 4, 9, 9, 8, 7),
(149, 'Liberty', 'Isaac', 'egestas.a@Utnecurna.edu', 814283, 10, 6, 10, 1, 9, 9),
(150, 'Stephanie', 'Quemby', 'vitae@semPellentesque.co.uk', 846164, 10, 9, 2, 2, 2, 7),
(151, 'Kimberly', 'Jerry', 'Sed@lectus.edu', 712645, 9, 1, 9, 10, 8, 9),
(152, 'Hermione', 'Abel', 'dolor.dolor.tempus@magnaa.net', 321400, 2, 3, 6, 9, 5, 8),
(153, 'Simon', 'Quemby', 'nec.orci@atlibero.ca', 634614, 1, 8, 6, 10, 7, 6),
(154, 'Dieter', 'Sonia', 'non.arcu.Vivamus@nisl.com', 970875, 1, 7, 8, 4, 8, 9),
(155, 'Axel', 'Scott', 'urna.Nullam.lobortis@scelerisqueneque.edu', 597158, 10, 8, 9, 10, 9, 4),
(156, 'Susan', 'Deacon', 'metus.Aenean.sed@Sed.co.uk', 602419, 10, 6, 1, 1, 2, 8),
(157, 'Brett', 'Janna', 'turpis.In.condimentum@Proin.co.uk', 734339, 5, 10, 5, 4, 2, 10),
(158, 'Stone', 'Destiny', 'Nam.ligula.elit@metus.ca', 603441, 7, 5, 3, 10, 1, 3),
(159, 'Maisie', 'Cheyenne', 'auctor.velit@maurisa.com', 238329, 5, 3, 8, 2, 1, 9),
(160, 'Leo', 'Blossom', 'odio.sagittis@vehicula.ca', 444427, 9, 5, 5, 7, 10, 6),
(161, 'Vivien', 'Ira', 'aliquet@nonummyultricies.co.uk', 373934, 6, 6, 4, 3, 3, 10),
(162, 'Chaim', 'Raven', 'Nullam.enim@magnaSedeu.co.uk', 455256, 10, 6, 2, 6, 8, 7),
(163, 'Quail', 'Kitra', 'pede@Donecnibh.co.uk', 790442, 9, 9, 10, 1, 9, 7),
(164, 'Ian', 'Rigel', 'vitae.sodales@duiquisaccumsan.com', 369467, 4, 7, 6, 10, 6, 5),
(165, 'Laith', 'Shafira', 'lacinia.Sed.congue@feugiatmetus.com', 540866, 9, 8, 10, 1, 3, 9),
(166, 'Seth', 'Ebony', 'purus.gravida.sagittis@purus.com', 875873, 9, 4, 10, 6, 1, 8),
(167, 'Donovan', 'Glenna', 'vel.pede.blandit@ornaretortor.co.uk', 456273, 6, 6, 10, 5, 3, 4),
(168, 'Deirdre', 'Kieran', 'sed@justosit.ca', 841706, 10, 2, 2, 10, 5, 10),
(169, 'Clayton', 'Rose', 'a.enim.Suspendisse@Curabitur.com', 137025, 1, 4, 3, 10, 1, 10),
(170, 'Lance', 'Lawrence', 'felis.adipiscing.fringilla@ullamcorpernisl.net', 907792, 9, 7, 10, 9, 9, 1),
(171, 'Robin', 'Karyn', 'dolor@purusDuis.com', 810559, 2, 1, 6, 4, 5, 7),
(172, 'Hedwig', 'Blaze', 'varius@vitae.edu', 280173, 5, 8, 5, 2, 10, 2),
(173, 'Xandra', 'Randall', 'non.enim@nisl.com', 306364, 3, 8, 3, 3, 5, 3),
(174, 'Jayme', 'Susan', 'tempor.augue.ac@leo.ca', 176987, 7, 10, 4, 5, 2, 8),
(175, 'Colton', 'Fatima', 'Quisque.libero.lacus@Nunc.ca', 68795, 3, 9, 2, 7, 3, 7),
(176, 'Hop', 'Karly', 'et.rutrum.non@lobortis.ca', 749877, 4, 3, 3, 4, 10, 5),
(177, 'Garth', 'Hanna', 'dui.lectus.rutrum@commodotincidunt.co.uk', 47898, 9, 10, 2, 9, 3, 3),
(178, 'Emmanuel', 'Colton', 'molestie.tortor.nibh@maurisrhoncusid.co.uk', 111994, 4, 10, 10, 9, 5, 7),
(179, 'Hedwig', 'Elizabeth', 'vitae.odio@inconsectetueripsum.edu', 575503, 8, 6, 8, 9, 10, 4),
(180, 'Fletcher', 'Cally', 'mattis@nonantebibendum.co.uk', 511645, 6, 7, 6, 4, 2, 2),
(181, 'Seth', 'Kenneth', 'nulla.at@Nam.edu', 118802, 8, 9, 7, 3, 8, 6),
(182, 'Olivia', 'Echo', 'Phasellus.ornare.Fusce@sitamet.org', 141384, 8, 9, 10, 3, 6, 6),
(183, 'Fallon', 'Karen', 'Duis@auctornuncnulla.edu', 681951, 1, 10, 5, 10, 7, 10),
(184, 'Nigel', 'Hedwig', 'mauris@auctornon.com', 810165, 8, 1, 8, 7, 9, 7),
(185, 'Daquan', 'Audra', 'luctus.lobortis@scelerisquemollisPhasellus.org', 932387, 1, 2, 10, 1, 10, 4),
(186, 'Blaze', 'Lucas', 'justo@Donec.net', 844100, 2, 1, 6, 2, 8, 8),
(187, 'Zachery', 'Aline', 'habitant.morbi.tristique@Integermollis.org', 898418, 10, 2, 8, 8, 9, 4),
(188, 'Sophia', 'Regan', 'nisl@Phasellus.edu', 563878, 3, 7, 2, 8, 8, 7),
(189, 'Dacey', 'Yoko', 'adipiscing.fringilla@Duisdignissim.org', 340826, 3, 6, 3, 3, 9, 6),
(190, 'Jermaine', 'Zorita', 'nonummy.ultricies.ornare@Nunc.edu', 703030, 2, 7, 10, 5, 4, 3),
(191, 'Denise', 'Ferdinand', 'dolor@netusetmalesuada.ca', 632400, 3, 2, 2, 1, 8, 3),
(192, 'Norman', 'Sigourney', 'habitant.morbi.tristique@Integer.edu', 276552, 4, 1, 9, 6, 5, 4),
(193, 'Ramona', 'Keith', 'sapien@sedpedeCum.net', 436125, 5, 2, 6, 2, 5, 8),
(194, 'Reece', 'Audra', 'nascetur.ridiculus.mus@suscipitnonummyFusce.edu', 618795, 10, 9, 1, 2, 5, 1),
(195, 'Oprah', 'Abdul', 'pede.blandit.congue@felisDonec.net', 764024, 10, 3, 10, 9, 2, 5),
(196, 'Rina', 'Patrick', 'sit.amet@diamnuncullamcorper.ca', 871226, 1, 6, 4, 10, 6, 3),
(197, 'Charlotte', 'Thane', 'a@nisisem.ca', 791849, 6, 10, 7, 1, 2, 8),
(198, 'Shad', 'Shoshana', 'tincidunt@dolor.edu', 851345, 5, 6, 5, 4, 5, 2),
(199, 'Cailin', 'Hadassah', 'sapien.gravida.non@aliquetlibero.co.uk', 948673, 8, 1, 7, 8, 2, 6),
(200, 'Sloane', 'Dennis', 'euismod.et.commodo@magnis.co.uk', 877779, 1, 8, 5, 3, 3, 9),
(201, 'Candace', 'TaShya', 'ligula@MaurisnullaInteger.org', 660274, 1, 8, 6, 10, 3, 7),
(202, 'Beau', 'Chloe', 'neque.vitae@tempusmauriserat.ca', 915284, 2, 10, 1, 1, 3, 7),
(203, 'Silas', 'Vincent', 'cursus.luctus@ornareegestasligula.edu', 16592, 6, 5, 8, 8, 7, 6),
(204, 'Mechelle', 'Dana', 'dolor@dapibusrutrum.edu', 436325, 10, 5, 7, 5, 4, 2),
(205, 'Blake', 'Jorden', 'fermentum.risus.at@gravidasitamet.org', 58737, 1, 7, 4, 1, 3, 2),
(206, 'Oren', 'Portia', 'Sed@dolor.ca', 402233, 9, 10, 1, 1, 4, 2),
(207, 'Declan', 'Candice', 'luctus.sit.amet@dis.co.uk', 497486, 8, 8, 1, 5, 1, 2),
(208, 'Emi', 'Lewis', 'ac.mattis@Duissit.co.uk', 753891, 1, 6, 5, 8, 9, 7),
(209, 'Reece', 'Violet', 'vestibulum.lorem@dui.co.uk', 368227, 4, 6, 2, 4, 1, 3),
(210, 'May', 'Aileen', 'hymenaeos.Mauris.ut@mattisCraseget.net', 734920, 1, 10, 9, 5, 10, 6),
(211, 'Chloe', 'Fredericka', 'ut@felisNullatempor.edu', 738853, 3, 4, 10, 4, 6, 1),
(212, 'Tanisha', 'Jorden', 'Integer.id@nondui.com', 977296, 9, 6, 5, 2, 10, 1),
(213, 'Dara', 'Zia', 'Donec.egestas.Duis@posuerevulputatelacus.co.uk', 596739, 5, 4, 8, 6, 4, 1),
(214, 'Indigo', 'Noelani', 'Phasellus.fermentum@Pellentesque.net', 546340, 9, 5, 4, 1, 10, 8),
(215, 'Elizabeth', 'Gwendolyn', 'eu@metusVivamuseuismod.net', 952311, 2, 7, 5, 5, 4, 4),
(216, 'Clio', 'Roanna', 'vulputate.posuere.vulputate@eueratsemper.co.uk', 801216, 10, 3, 2, 4, 4, 8),
(217, 'Quamar', 'Mira', 'lacus.Mauris.non@Pellentesque.net', 647510, 8, 6, 7, 7, 5, 2),
(218, 'Chloe', 'Stella', 'malesuada@sempercursus.net', 609774, 5, 8, 9, 2, 5, 10),
(219, 'Griffith', 'Ferris', 'ante@porttitor.edu', 818897, 3, 1, 7, 5, 5, 4),
(220, 'Camden', 'Minerva', 'at.sem@nasceturridiculus.net', 385359, 8, 7, 6, 5, 3, 7),
(221, 'Hector', 'Ulric', 'dui@in.org', 376445, 1, 2, 2, 7, 7, 2),
(222, 'Angela', 'Quincy', 'enim.consequat.purus@inconsequatenim.edu', 929860, 7, 2, 2, 2, 7, 9),
(223, 'Simon', 'Aileen', 'gravida.sagittis@feugiatnonlobortis.ca', 317686, 4, 4, 1, 10, 3, 9),
(224, 'Aline', 'Nigel', 'placerat@et.org', 348255, 6, 8, 5, 6, 1, 8),
(225, 'Justine', 'Colt', 'Quisque.fringilla@semut.net', 301167, 10, 2, 2, 6, 4, 9),
(226, 'Armando', 'Jessica', 'lobortis.augue@sed.org', 835881, 8, 9, 1, 4, 9, 8),
(227, 'Quamar', 'Eleanor', 'dolor@nunc.org', 516220, 3, 9, 3, 6, 3, 5),
(228, 'Nelle', 'Aline', 'sapien.cursus@estMauriseu.net', 390634, 10, 7, 3, 8, 7, 6),
(229, 'Cassidy', 'Thor', 'Duis.volutpat@acnulla.net', 470987, 4, 8, 2, 7, 9, 7),
(230, 'Cassandra', 'Benedict', 'nulla@dapibusgravida.ca', 663198, 8, 8, 1, 6, 4, 6),
(231, 'Vincent', 'Gwendolyn', 'felis.ullamcorper@odio.ca', 638166, 4, 5, 4, 6, 2, 1),
(232, 'Willa', 'Adele', 'lectus.rutrum@nullaIntegerurna.org', 815101, 6, 3, 3, 4, 7, 1),
(233, 'Cheryl', 'Uriah', 'nibh.vulputate.mauris@Nunc.com', 249266, 9, 8, 7, 4, 3, 5),
(234, 'Felix', 'Nevada', 'libero.et@hendreritaarcu.ca', 631591, 5, 7, 8, 1, 5, 8),
(235, 'Russell', 'Gray', 'interdum@in.co.uk', 215365, 6, 10, 4, 6, 1, 9),
(236, 'Nerea', 'Nevada', 'facilisis.magna@milorem.ca', 975543, 8, 1, 4, 3, 5, 10),
(237, 'Maile', 'Lyle', 'sem.elit@utipsum.org', 696571, 10, 9, 2, 10, 10, 7),
(238, 'Vladimir', 'Jescie', 'Ut.tincidunt@gravidaAliquam.ca', 694853, 4, 6, 2, 6, 9, 9),
(239, 'Vaughan', 'Oren', 'vel.mauris@Integermollis.co.uk', 745633, 2, 9, 9, 5, 8, 4),
(240, 'Wylie', 'Chester', 'nunc.interdum@atliberoMorbi.com', 393162, 3, 10, 8, 8, 10, 3),
(241, 'Sybil', 'Hop', 'lorem@ipsum.edu', 269865, 10, 10, 6, 2, 9, 3),
(242, 'Samantha', 'Stacy', 'scelerisque.neque@adlitoratorquent.co.uk', 41637, 7, 3, 3, 2, 8, 7),
(243, 'Ethan', 'Autumn', 'non.justo@semper.ca', 988638, 5, 1, 2, 1, 7, 10),
(244, 'Cally', 'Bertha', 'vel.arcu.Curabitur@Proin.org', 23943, 5, 4, 5, 2, 7, 10),
(245, 'Todd', 'Vielka', 'velit.Sed@atpretiumaliquet.ca', 275167, 8, 2, 2, 4, 1, 5),
(246, 'Odette', 'Heidi', 'accumsan.interdum.libero@auctorvitae.com', 50495, 8, 1, 9, 4, 10, 9),
(247, 'Slade', 'Steven', 'erat.nonummy@erosnectellus.edu', 92128, 4, 10, 6, 4, 6, 6),
(248, 'Hayfa', 'Ashton', 'eu.odio@nisi.edu', 459235, 9, 1, 10, 6, 4, 2),
(249, 'Lester', 'Micah', 'velit.justo.nec@liberoatauctor.co.uk', 736973, 1, 7, 6, 2, 7, 2),
(250, 'Chester', 'Mechelle', 'risus.varius@congueInscelerisque.org', 100756, 4, 3, 1, 4, 4, 8),
(251, 'Hanae', 'Chaney', 'fringilla@etmalesuadafames.ca', 925241, 4, 3, 3, 2, 6, 2),
(252, 'Thor', 'Tad', 'scelerisque.neque@Integeraliquamadipiscing.org', 93245, 7, 6, 8, 2, 6, 8),
(253, 'Ora', 'Jesse', 'auctor@Proinultrices.edu', 315046, 10, 6, 5, 9, 8, 10),
(254, 'Cynthia', 'Xaviera', 'aptent.taciti@loremsemperauctor.org', 571724, 8, 9, 8, 7, 8, 7),
(255, 'Oren', 'Evan', 'Aliquam@iderat.org', 788153, 1, 5, 1, 8, 8, 5),
(256, 'Lila', 'Cole', 'lectus.pede.ultrices@cursusvestibulumMauris.com', 691496, 6, 10, 8, 5, 7, 3),
(257, 'Byron', 'Aphrodite', 'Sed.auctor.odio@nascetur.co.uk', 63503, 3, 2, 2, 5, 4, 3),
(258, 'Xander', 'Barrett', 'Fusce@nunc.edu', 24401, 9, 7, 8, 1, 1, 6),
(259, 'Hilel', 'Castor', 'ante@diam.com', 18990, 6, 3, 1, 1, 10, 7),
(260, 'Blythe', 'Zephr', 'lobortis.quis@mi.com', 400385, 10, 3, 2, 4, 8, 5),
(261, 'Curran', 'Alexis', 'Lorem.ipsum@Maecenas.net', 664340, 8, 4, 2, 5, 9, 1),
(262, 'Neville', 'Nissim', 'massa.non.ante@ornareInfaucibus.ca', 42950, 10, 10, 7, 2, 1, 2),
(263, 'Tanner', 'Kay', 'eu.augue.porttitor@molestietellus.edu', 597231, 3, 7, 5, 4, 9, 4),
(264, 'Tanek', 'Richard', 'eu@ipsumnunc.org', 581249, 5, 7, 1, 6, 8, 9),
(265, 'Alexander', 'Maggy', 'eu.nulla@pharetra.com', 475245, 9, 8, 9, 10, 3, 6),
(266, 'Beverly', 'Kristen', 'id.blandit.at@maurisipsumporta.net', 271193, 2, 3, 10, 3, 7, 7),
(267, 'Casey', 'Orlando', 'a@massaQuisqueporttitor.ca', 617864, 8, 1, 6, 8, 3, 7),
(268, 'Bo', 'Philip', 'commodo.tincidunt.nibh@sempererat.com', 783464, 6, 7, 9, 9, 8, 6),
(269, 'Nita', 'Byron', 'at.pede@netus.edu', 560617, 8, 2, 6, 8, 8, 2),
(270, 'Uta', 'Serina', 'convallis@sitamet.com', 743628, 6, 10, 1, 4, 1, 1),
(271, 'Drake', 'Adele', 'arcu.Sed.et@penatibusetmagnis.net', 675213, 9, 1, 6, 1, 9, 3),
(272, 'Kieran', 'Stone', 'aliquam@estNuncullamcorper.edu', 657047, 8, 10, 5, 6, 10, 2),
(273, 'Nehru', 'Savannah', 'malesuada@vel.org', 290224, 4, 9, 2, 8, 9, 1),
(274, 'Rooney', 'Tatum', 'ultrices.Vivamus.rhoncus@consequatdolor.edu', 194973, 9, 9, 6, 6, 1, 2),
(275, 'Winter', 'Wyatt', 'ac.mi@sodales.edu', 86981, 4, 6, 7, 4, 6, 1),
(276, 'Eve', 'Hedda', 'ultricies@nec.edu', 489282, 8, 10, 8, 1, 3, 3),
(277, 'Breanna', 'Jonas', 'volutpat.ornare@etnetus.co.uk', 523633, 1, 5, 6, 7, 7, 1),
(278, 'Holmes', 'Gisela', 'molestie.tortor@inmolestietortor.ca', 441840, 9, 10, 3, 5, 2, 3),
(279, 'Mikayla', 'Francesca', 'magna@tempusscelerisquelorem.net', 822339, 9, 8, 3, 1, 7, 9),
(280, 'Quon', 'Martena', 'sagittis.Nullam.vitae@feugiatplacerat.co.uk', 32093, 2, 3, 3, 2, 4, 1),
(281, 'Winifred', 'Genevieve', 'Mauris.vestibulum.neque@temporloremeget.edu', 504847, 7, 8, 10, 3, 4, 1),
(282, 'Brianna', 'Danielle', 'ante.ipsum.primis@pretium.ca', 687406, 3, 8, 4, 5, 3, 5),
(283, 'Alexandra', 'Ali', 'quam.a.felis@Donec.co.uk', 364107, 1, 3, 3, 1, 6, 6),
(284, 'Bruno', 'Xerxes', 'cursus@cursus.org', 734267, 9, 3, 9, 8, 9, 3),
(285, 'Pearl', 'Neve', 'amet.risus@Phasellus.org', 459292, 10, 4, 2, 10, 9, 10),
(286, 'Stone', 'Dexter', 'a@nonummy.com', 474944, 9, 4, 8, 4, 6, 5),
(287, 'Sarah', 'Richard', 'nisl@elitelitfermentum.ca', 893288, 4, 7, 10, 1, 3, 3),
(288, 'Emma', 'Oleg', 'amet.consectetuer.adipiscing@habitantmorbi.org', 127230, 3, 10, 5, 9, 5, 2),
(289, 'Tyrone', 'Lyle', 'diam.nunc@NullamnislMaecenas.com', 438819, 4, 7, 10, 6, 4, 1),
(290, 'Jada', 'Irene', 'hendrerit.Donec@eu.com', 200992, 10, 7, 3, 8, 5, 8),
(291, 'Emmanuel', 'Otto', 'sit.amet@accumsanconvallis.co.uk', 535783, 6, 3, 8, 5, 9, 8),
(292, 'Jakeem', 'Basia', 'mauris@penatibusetmagnis.ca', 739613, 7, 1, 5, 4, 7, 1),
(293, 'Bell', 'Jacqueline', 'vulputate@Vivamuseuismodurna.com', 915242, 5, 10, 2, 7, 9, 10),
(294, 'Octavius', 'Blake', 'eget@risus.co.uk', 275645, 3, 8, 1, 9, 2, 10),
(295, 'Lareina', 'Geraldine', 'dolor@atortor.ca', 47621, 3, 3, 5, 4, 5, 6),
(296, 'Angela', 'Portia', 'Fusce.diam@velmaurisInteger.ca', 541064, 8, 1, 2, 8, 4, 4),
(297, 'Rosalyn', 'Olivia', 'habitant.morbi@Sedcongue.net', 190502, 10, 5, 10, 10, 10, 1),
(298, 'Jayme', 'Virginia', 'risus.Donec@fermentumrisusat.com', 26110, 5, 9, 6, 1, 4, 9),
(299, 'Alec', 'Fiona', 'pharetra.nibh@odioauctor.org', 66295, 6, 2, 3, 2, 2, 7),
(300, 'Hollee', 'Bert', 'odio.auctor@massaQuisqueporttitor.com', 508384, 3, 2, 7, 7, 8, 3),
(301, 'Unity', 'Avye', 'Proin.dolor.Nulla@Curabiturut.net', 401305, 8, 2, 2, 1, 5, 4),
(302, 'Colt', 'Curran', 'egestas.Fusce@parturientmontesnascetur.edu', 536879, 4, 6, 6, 3, 3, 6),
(303, 'Sydnee', 'MacKensie', 'Cras.eget.nisi@massaVestibulumaccumsan.ca', 347252, 7, 9, 8, 2, 8, 6),
(304, 'Claudia', 'Addison', 'in.tempus.eu@orcilobortisaugue.net', 347208, 3, 7, 6, 6, 1, 7),
(305, 'Jeremy', 'Brian', 'cursus@semper.edu', 153877, 6, 6, 2, 5, 7, 10),
(306, 'Herrod', 'Scarlet', 'nulla.magna@diamPellentesquehabitant.edu', 220463, 1, 5, 7, 4, 2, 4),
(307, 'Cruz', 'Tamekah', 'at.fringilla.purus@dui.edu', 263005, 1, 2, 8, 1, 7, 7),
(308, 'James', 'Seth', 'vitae@Sedetlibero.ca', 368717, 1, 7, 9, 3, 8, 1),
(309, 'Elton', 'Brynne', 'egestas@tellus.ca', 552629, 8, 1, 2, 5, 9, 2),
(310, 'Lance', 'Dylan', 'aliquam@necdiamDuis.org', 62166, 7, 3, 3, 2, 4, 9),
(311, 'Alexis', 'Dustin', 'Phasellus.dapibus@afeugiat.co.uk', 389609, 5, 3, 8, 7, 5, 2),
(312, 'Thomas', 'Ariana', 'metus.sit@enimdiam.org', 824363, 7, 10, 10, 1, 7, 6),
(313, 'Cyrus', 'Baker', 'nonummy.ipsum.non@Proinvel.edu', 578276, 4, 8, 4, 3, 6, 1),
(314, 'Cameron', 'Riley', 'consequat@enimSednulla.org', 959835, 2, 7, 4, 8, 2, 7),
(315, 'Vladimir', 'Ronan', 'et.risus@variusultricesmauris.co.uk', 358104, 9, 2, 3, 4, 4, 3),
(316, 'Vera', 'Kirby', 'risus@necligula.org', 580088, 10, 9, 8, 10, 8, 6),
(317, 'May', 'Dahlia', 'dui.Cum@justo.edu', 739178, 4, 6, 5, 1, 7, 1),
(318, 'Maris', 'Germane', 'at.auctor.ullamcorper@ipsumporta.edu', 524657, 6, 7, 4, 4, 1, 9),
(319, 'Igor', 'Lucas', 'Nulla@ridiculusmusProin.org', 721799, 3, 6, 2, 4, 1, 8),
(320, 'Josephine', 'Bertha', 'non.massa@Duis.edu', 266833, 4, 4, 9, 10, 8, 8),
(321, 'Stephen', 'Hadassah', 'nascetur@ornaretortor.org', 424703, 3, 9, 3, 7, 9, 3),
(322, 'Dalton', 'Forrest', 'tempus.mauris@et.edu', 486137, 5, 2, 7, 6, 4, 5),
(323, 'Chastity', 'Malcolm', 'enim.Suspendisse@Duisa.edu', 883553, 10, 3, 1, 8, 2, 5),
(324, 'Chester', 'Quincy', 'sodales@bibendumsed.org', 813529, 8, 9, 4, 4, 6, 2),
(325, 'Linus', 'Oprah', 'non.quam.Pellentesque@liberoProinsed.co.uk', 602459, 9, 3, 3, 3, 1, 9),
(326, 'Kaden', 'Tamekah', 'odio.Aliquam@nec.ca', 521571, 4, 7, 1, 2, 1, 6),
(327, 'Jael', 'Dana', 'cursus.et.magna@fringillaDonecfeugiat.co.uk', 878204, 1, 7, 4, 2, 9, 9),
(328, 'Wyatt', 'Stephen', 'aliquet.sem.ut@idlibero.org', 878728, 5, 7, 10, 2, 6, 9),
(329, 'Berk', 'Yardley', 'urna.Vivamus.molestie@Curabiturut.ca', 636474, 7, 1, 7, 3, 2, 1),
(330, 'Kalia', 'Deacon', 'natoque.penatibus.et@arcuimperdiet.com', 993818, 2, 6, 2, 3, 4, 7),
(331, 'Harrison', 'Laith', 'tristique.senectus@eleifendegestas.net', 613077, 6, 5, 4, 9, 4, 6),
(332, 'Upton', 'Molly', 'quam@aliquetlobortisnisi.edu', 181179, 10, 4, 3, 4, 8, 1),
(333, 'Amaya', 'Adrienne', 'Phasellus@Vivamussitamet.net', 226480, 6, 9, 10, 8, 9, 4),
(334, 'Anne', 'Britanney', 'amet@eget.net', 244266, 5, 3, 9, 1, 4, 4),
(335, 'Sade', 'Cooper', 'nec.tempus.mauris@natoque.ca', 601822, 7, 10, 2, 6, 10, 5),
(336, 'Maxwell', 'Tashya', 'morbi@malesuadafringilla.com', 601924, 7, 4, 1, 6, 3, 2),
(337, 'Marcia', 'Sade', 'morbi@Fusce.ca', 770577, 5, 9, 6, 4, 6, 4),
(338, 'Raven', 'Jason', 'sem.egestas.blandit@senectuset.edu', 856357, 9, 4, 9, 2, 6, 3),
(339, 'Wilma', 'Mikayla', 'vitae@ametdiam.edu', 797255, 1, 4, 6, 6, 3, 6),
(340, 'Griffin', 'Miriam', 'lobortis.quam@dignissimlacusAliquam.ca', 337128, 2, 2, 3, 2, 1, 9),
(341, 'Quemby', 'Herman', 'Morbi.non@non.com', 245595, 1, 5, 5, 1, 2, 9),
(342, 'Regina', 'Emerald', 'Quisque.fringilla@nequeNullam.org', 852431, 10, 8, 7, 1, 4, 4),
(343, 'James', 'Kieran', 'fermentum@IntegerurnaVivamus.org', 643631, 1, 9, 3, 3, 4, 8),
(344, 'Glenna', 'Aiko', 'euismod.enim.Etiam@purusinmolestie.com', 963993, 3, 4, 7, 5, 3, 2),
(345, 'Phelan', 'Britanni', 'Quisque@incursus.com', 15570, 2, 10, 10, 1, 10, 6),
(346, 'Lev', 'Chantale', 'pede.nec@metussit.ca', 646594, 5, 1, 6, 4, 1, 9),
(347, 'Hall', 'Yvonne', 'non.vestibulum.nec@malesuada.net', 132328, 3, 6, 3, 10, 7, 8),
(348, 'Ezekiel', 'Hilel', 'aliquet@duiCumsociis.com', 443314, 5, 2, 2, 2, 5, 10),
(349, 'Talon', 'Kelly', 'Integer.sem.elit@nibhvulputatemauris.net', 704915, 10, 9, 6, 6, 4, 6),
(350, 'Gray', 'James', 'id.ante@sitamet.org', 534000, 7, 2, 8, 7, 6, 9),
(351, 'Hyacinth', 'Quin', 'orci.Ut@nectempusmauris.com', 23994, 3, 2, 9, 3, 2, 2),
(352, 'Cruz', 'Joy', 'ac.eleifend.vitae@dolor.co.uk', 397819, 9, 2, 10, 2, 9, 1),
(353, 'Athena', 'Adrian', 'eu@elementumlorem.net', 955599, 4, 10, 1, 6, 8, 5),
(354, 'Xyla', 'Nathaniel', 'Duis.elementum.dui@primis.ca', 573456, 10, 5, 6, 10, 8, 2),
(355, 'Audra', 'Indira', 'nec.ante@loremauctorquis.co.uk', 400707, 5, 9, 2, 5, 7, 10),
(356, 'Avram', 'Carissa', 'elit@Maecenas.co.uk', 100196, 1, 4, 6, 4, 7, 4),
(357, 'Erin', 'Irma', 'luctus@morbitristique.co.uk', 749345, 9, 2, 3, 4, 3, 7),
(358, 'Daquan', 'Seth', 'libero@erat.org', 933471, 4, 3, 9, 1, 9, 7),
(359, 'Colette', 'Linda', 'dolor.quam@at.net', 88268, 7, 10, 3, 8, 9, 7),
(360, 'Alea', 'Barry', 'adipiscing.ligula.Aenean@semut.net', 622461, 6, 10, 1, 4, 10, 3),
(361, 'Rhona', 'Aiko', 'neque.venenatis.lacus@faucibusleoin.com', 571683, 2, 8, 4, 6, 5, 10),
(362, 'Angela', 'Jocelyn', 'libero.et@rutrum.net', 970764, 10, 5, 8, 4, 5, 1),
(363, 'Warren', 'Zenaida', 'auctor.odio@dolor.org', 153511, 9, 3, 8, 5, 7, 7),
(364, 'Melanie', 'Pearl', 'malesuada.vel.venenatis@aliquet.net', 498902, 5, 1, 7, 8, 1, 7),
(365, 'Robin', 'Morgan', 'ultricies@acliberonec.net', 216873, 9, 5, 10, 1, 3, 9),
(366, 'Kylee', 'Myles', 'eu.ultrices@vitaeorciPhasellus.co.uk', 703458, 4, 9, 4, 6, 8, 8),
(367, 'Maxine', 'Maris', 'ante@tempuseu.ca', 808238, 6, 6, 6, 6, 6, 10),
(368, 'Nolan', 'August', 'sed@ultricesposuerecubilia.ca', 307086, 8, 10, 10, 4, 1, 6),
(369, 'Phelan', 'Garrett', 'et@odiotristique.co.uk', 144121, 9, 3, 5, 8, 4, 8),
(370, 'Bree', 'Joelle', 'fringilla.mi@porttitortellusnon.com', 211787, 7, 4, 3, 4, 6, 3),
(371, 'Lani', 'Montana', 'nisl.Maecenas@purus.net', 101564, 5, 5, 3, 2, 6, 1),
(372, 'Thaddeus', 'Yael', 'enim.condimentum@Quisqueimperdiet.co.uk', 184059, 1, 3, 6, 5, 2, 4),
(373, 'Tarik', 'Inga', 'eu.tempor.erat@risusIn.com', 952140, 9, 4, 7, 6, 4, 6),
(374, 'Leila', 'Harrison', 'orci.sem.eget@ridiculus.ca', 710654, 10, 1, 9, 1, 10, 9),
(375, 'Fay', 'Jade', 'inceptos.hymenaeos@vulputateposuerevulputate.org', 746019, 6, 4, 3, 8, 10, 4),
(376, 'Hayes', 'Rhoda', 'commodo.hendrerit@estacfacilisis.com', 213366, 6, 8, 3, 10, 1, 10),
(377, 'Alexandra', 'Cecilia', 'consequat.dolor@faucibusleoin.com', 262718, 9, 2, 2, 1, 5, 4),
(378, 'Callum', 'Armando', 'ridiculus.mus@quislectusNullam.net', 854938, 9, 4, 10, 3, 1, 2),
(379, 'Ashely', 'Kasper', 'Lorem.ipsum@magnanecquam.net', 989962, 3, 7, 3, 1, 1, 7),
(380, 'Maggie', 'Malachi', 'sodales@ligulaNullamfeugiat.org', 123762, 4, 7, 7, 4, 6, 1),
(381, 'Germaine', 'Signe', 'tristique@elitfermentum.co.uk', 988437, 9, 7, 7, 7, 4, 3),
(382, 'Bethany', 'Ann', 'ridiculus@vel.co.uk', 741973, 10, 10, 6, 5, 7, 6),
(383, 'Brennan', 'Ezra', 'vitae.erat.Vivamus@metusAeneansed.org', 388191, 6, 6, 3, 1, 7, 10),
(384, 'Kelly', 'Amber', 'non.leo.Vivamus@indolorFusce.co.uk', 854607, 3, 2, 9, 5, 3, 5),
(385, 'Debra', 'Briar', 'odio.Phasellus@doloregestasrhoncus.net', 131502, 8, 1, 5, 3, 6, 7),
(386, 'Aphrodite', 'Constance', 'Donec.felis.orci@Donecegestas.org', 108472, 7, 9, 7, 7, 4, 8),
(387, 'Amethyst', 'Demetria', 'quam@sociis.net', 664854, 8, 2, 6, 7, 4, 8),
(388, 'Bo', 'Hiroko', 'magnis.dis.parturient@ametconsectetueradipiscing.org', 209840, 2, 4, 6, 7, 5, 1),
(389, 'Rudyard', 'Asher', 'ligula@Nunc.com', 372364, 6, 8, 7, 8, 6, 5),
(390, 'Jordan', 'Audra', 'senectus@Crasdictumultricies.edu', 986071, 8, 4, 5, 10, 4, 8),
(391, 'Graham', 'Jeanette', 'ipsum@Crasdolor.com', 834899, 9, 1, 2, 10, 1, 8),
(392, 'Ethan', 'Diana', 'erat.semper.rutrum@pede.edu', 244511, 10, 3, 3, 2, 5, 3),
(393, 'Iona', 'Demetria', 'tincidunt@inlobortis.net', 455357, 3, 8, 10, 9, 3, 10),
(394, 'Emery', 'Quamar', 'Ut.semper@cursusa.ca', 924490, 8, 8, 2, 9, 9, 5),
(395, 'Stuart', 'Roth', 'auctor.Mauris.vel@augueeutellus.edu', 662850, 6, 8, 2, 1, 8, 10),
(396, 'Alexis', 'Prescott', 'est.Mauris@Morbiquisurna.co.uk', 306161, 1, 1, 1, 2, 3, 4),
(397, 'Lila', 'Leigh', 'justo@luctusvulputatenisi.ca', 405409, 4, 4, 1, 7, 2, 7),
(398, 'Lewis', 'Tatiana', 'Suspendisse.aliquet@auctorvelit.com', 744648, 8, 4, 4, 5, 4, 4),
(399, 'Lareina', 'Erica', 'tincidunt.aliquam@Maurisquisturpis.org', 998090, 1, 6, 1, 3, 7, 4),
(400, 'Carol', 'Olga', 'a.felis.ullamcorper@Maecenas.ca', 309682, 8, 10, 9, 8, 4, 3),
(401, 'Basil', 'Michelle', 'eu.tellus.eu@arcuAliquam.ca', 278587, 3, 3, 8, 10, 10, 3),
(402, 'Eliana', 'Colt', 'Class.aptent@liberonec.co.uk', 307119, 6, 3, 9, 2, 6, 3),
(403, 'Cathleen', 'Tashya', 'Donec.felis@duilectus.com', 759833, 10, 8, 9, 8, 7, 1),
(404, 'Abra', 'Gemma', 'malesuada@nislsemconsequat.org', 733588, 1, 7, 2, 10, 9, 7),
(405, 'Vance', 'Ivory', 'porttitor.eros.nec@dapibus.net', 795137, 8, 3, 8, 9, 1, 1),
(406, 'Camden', 'Salvador', 'neque.In@libero.edu', 383169, 5, 1, 3, 2, 10, 10),
(407, 'Virginia', 'Jacqueline', 'erat.Vivamus@diamnunc.com', 736451, 4, 7, 7, 10, 5, 6),
(408, 'Ila', 'Brielle', 'nonummy.ultricies@aaliquet.net', 258894, 2, 4, 2, 9, 2, 1),
(409, 'Evangeline', 'Imelda', 'ornare.In@Proin.net', 218521, 7, 3, 9, 9, 3, 1),
(410, 'Edan', 'Cairo', 'magna.nec@Curabituregestasnunc.co.uk', 65058, 4, 7, 6, 3, 7, 7),
(411, 'Breanna', 'Gillian', 'dignissim.magna@Pellentesquehabitantmorbi.com', 358083, 4, 7, 1, 5, 2, 3),
(412, 'Victor', 'Macon', 'elit.elit@Maurisut.edu', 706640, 7, 5, 7, 8, 2, 8),
(413, 'Pearl', 'Cheyenne', 'posuere@nec.com', 220060, 4, 2, 5, 7, 4, 1),
(414, 'Baxter', 'Yen', 'elementum.sem@ornare.edu', 503622, 7, 1, 4, 4, 6, 7),
(415, 'Kiayada', 'Wade', 'dignissim.tempor@et.edu', 212695, 2, 4, 6, 5, 1, 3),
(416, 'Ariel', 'Germane', 'Mauris@ametluctusvulputate.org', 846856, 8, 3, 5, 3, 1, 8),
(417, 'Tana', 'Shea', 'Suspendisse.commodo@molestie.edu', 908568, 10, 2, 7, 6, 6, 3),
(418, 'Aladdin', 'Heidi', 'neque.non.quam@parturientmontesnascetur.edu', 216574, 3, 6, 3, 10, 2, 3),
(419, 'Byron', 'Zorita', 'et.magnis@morbitristique.net', 38099, 8, 5, 1, 5, 6, 9),
(420, 'Remedios', 'Kay', 'augue@Mauris.com', 572771, 7, 7, 3, 7, 4, 10),
(421, 'Indigo', 'Lesley', 'aliquet.nec@utpellentesqueeget.co.uk', 869186, 3, 2, 7, 2, 5, 3),
(422, 'Hall', 'Grace', 'mi@metusVivamuseuismod.ca', 288054, 7, 1, 3, 5, 7, 9),
(423, 'Shelley', 'Freya', 'faucibus.orci@utnulla.edu', 469617, 2, 6, 8, 2, 5, 5),
(424, 'Rhonda', 'Julie', 'gravida.non.sollicitudin@non.edu', 109931, 8, 9, 5, 9, 8, 1),
(425, 'Melissa', 'Alisa', 'a@veliteget.org', 386214, 8, 5, 1, 2, 5, 5),
(426, 'Reece', 'Kasper', 'tristique.senectus@Aliquamauctor.ca', 580549, 9, 7, 5, 9, 5, 2),
(427, 'Taylor', 'Cameron', 'a.dui.Cras@gravidamolestie.edu', 898647, 2, 2, 4, 6, 6, 2),
(428, 'Drew', 'Freya', 'sit.amet@pedesagittisaugue.net', 416417, 1, 1, 6, 10, 5, 4),
(429, 'Sylvia', 'Claire', 'lorem.ac.risus@nunc.com', 98779, 5, 6, 2, 3, 4, 10),
(430, 'Colette', 'Ralph', 'ipsum.dolor@amet.co.uk', 832978, 2, 8, 5, 10, 1, 8),
(431, 'Brenna', 'Keelie', 'Vestibulum@volutpatNulla.com', 153894, 9, 9, 3, 8, 7, 4),
(432, 'Darryl', 'Morgan', 'sapien@Proin.edu', 917054, 4, 10, 7, 9, 10, 7),
(433, 'Ramona', 'Geraldine', 'varius.Nam.porttitor@nonummyipsum.ca', 626461, 8, 4, 8, 5, 7, 8),
(434, 'Ruth', 'Olga', 'turpis@disparturientmontes.org', 749793, 2, 9, 3, 4, 6, 8),
(435, 'Faith', 'Rana', 'nunc.sed.libero@ullamcorper.org', 877319, 8, 6, 3, 4, 4, 6),
(436, 'Mona', 'Kitra', 'a.purus@bibendum.org', 65633, 3, 7, 5, 2, 5, 10),
(437, 'McKenzie', 'Hillary', 'Nunc@molestiesodalesMauris.edu', 950056, 9, 9, 1, 5, 10, 1),
(438, 'Teegan', 'Graiden', 'enim.Suspendisse.aliquet@Aliquam.edu', 854480, 2, 4, 7, 6, 10, 1),
(439, 'Addison', 'Hayfa', 'non.dui@dui.ca', 237092, 3, 8, 3, 9, 10, 4),
(440, 'Silas', 'Caldwell', 'diam.Proin.dolor@orciquis.net', 845707, 3, 4, 8, 9, 7, 9),
(441, 'Blake', 'Riley', 'Donec@Nullamlobortisquam.com', 951082, 2, 8, 6, 4, 2, 4),
(442, 'Maya', 'Tanner', 'Aliquam.nisl.Nulla@sagittisNullamvitae.edu', 804024, 4, 5, 9, 4, 4, 7),
(443, 'Audra', 'Ruby', 'auctor.quis.tristique@lobortis.co.uk', 678459, 10, 8, 8, 9, 10, 4),
(444, 'Octavia', 'Donna', 'enim.Suspendisse.aliquet@rutrumeu.net', 34355, 8, 1, 2, 1, 2, 10),
(445, 'Oliver', 'Ann', 'eget.tincidunt.dui@nulla.com', 39842, 8, 3, 9, 8, 7, 2),
(446, 'Aspen', 'Melvin', 'nunc@Curae.org', 465358, 9, 10, 4, 8, 6, 6),
(447, 'Glenna', 'Ethan', 'fringilla@ligulaDonecluctus.co.uk', 760854, 10, 9, 8, 10, 9, 2),
(448, 'Charity', 'Hope', 'Maecenas@odioNam.edu', 759449, 7, 5, 10, 2, 6, 3),
(449, 'Fritz', 'Curran', 'Aliquam.gravida@Mauris.com', 750876, 7, 3, 3, 7, 6, 9),
(450, 'Dora', 'Alexis', 'volutpat.Nulla@mienim.edu', 533095, 7, 8, 3, 10, 8, 9),
(451, 'Blair', 'Seth', 'egestas.Fusce.aliquet@nec.co.uk', 430261, 9, 8, 9, 1, 4, 1),
(452, 'Kay', 'Jena', 'Proin@sem.net', 898744, 3, 1, 5, 2, 6, 2),
(453, 'Elizabeth', 'Wang', 'lobortis.nisi.nibh@nuncsedpede.org', 727099, 5, 2, 2, 7, 5, 9),
(454, 'Ezra', 'August', 'sagittis@Fusce.edu', 105890, 9, 7, 6, 6, 4, 3),
(455, 'Kevyn', 'Mechelle', 'mauris.sagittis@Fuscemollis.edu', 213454, 10, 7, 1, 6, 1, 10),
(456, 'Casey', 'Courtney', 'ac.mattis.semper@nequetellus.net', 729822, 5, 8, 10, 1, 6, 9),
(457, 'Iliana', 'Roth', 'nunc.Quisque@infelisNulla.com', 21306, 6, 4, 4, 8, 7, 4),
(458, 'Dalton', 'Chava', 'Suspendisse.ac.metus@congueIn.net', 739064, 2, 8, 4, 10, 10, 10),
(459, 'Troy', 'Guinevere', 'purus.Duis.elementum@convallisin.net', 601717, 8, 2, 4, 6, 1, 8),
(460, 'Ivana', 'Libby', 'eu.neque@vestibulummassa.com', 965001, 10, 8, 4, 4, 9, 4),
(461, 'Echo', 'Matthew', 'fringilla.euismod.enim@Phasellus.co.uk', 756067, 3, 5, 5, 1, 2, 3),
(462, 'Denise', 'Julie', 'augue.scelerisque.mollis@tincidunt.ca', 269915, 8, 5, 2, 10, 8, 1),
(463, 'Erasmus', 'Odessa', 'tellus@eumetus.co.uk', 414081, 2, 8, 10, 10, 1, 8),
(464, 'Noel', 'Herman', 'egestas@Curabitur.edu', 48121, 10, 6, 10, 9, 10, 7),
(465, 'Guy', 'Ina', 'a@dictummiac.edu', 769266, 4, 4, 4, 5, 9, 8),
(466, 'Lenore', 'Leilani', 'dictum.augue.malesuada@Donecvitaeerat.com', 801791, 5, 6, 3, 3, 7, 7),
(467, 'Julie', 'Jordan', 'Sed.eu.eros@aliquetdiamSed.net', 342017, 3, 1, 10, 5, 2, 1),
(468, 'Burke', 'Murphy', 'ut.lacus.Nulla@molestie.net', 827665, 5, 7, 8, 7, 4, 8),
(469, 'Mannix', 'Hall', 'dictum.eu.placerat@ligulaAeneaneuismod.co.uk', 345923, 10, 7, 4, 4, 8, 8),
(470, 'Ella', 'Thomas', 'at.velit@liberomauris.com', 258689, 8, 6, 7, 4, 4, 4),
(471, 'Mira', 'Rina', 'Nunc.mauris.sapien@eteros.com', 972572, 9, 7, 10, 9, 7, 5),
(472, 'Charity', 'Dane', 'penatibus.et.magnis@miDuisrisus.co.uk', 385276, 2, 4, 8, 4, 8, 2),
(473, 'Indira', 'Ignacia', 'enim.Etiam@a.ca', 542722, 3, 4, 3, 1, 9, 6),
(474, 'Hector', 'Adele', 'Cras@commodotincidunt.net', 934157, 4, 5, 5, 6, 7, 8),
(475, 'Jelani', 'Maggy', 'et@dictumeueleifend.co.uk', 948281, 9, 2, 7, 10, 3, 10),
(476, 'Tanya', 'Maite', 'mollis.non.cursus@adipiscingnon.edu', 77636, 1, 9, 2, 4, 3, 8),
(477, 'Ursula', 'Ruth', 'metus.Vivamus.euismod@dolor.ca', 641568, 2, 1, 10, 5, 7, 3),
(478, 'Russell', 'Amethyst', 'Donec.vitae@tinciduntneque.ca', 431478, 2, 2, 2, 2, 5, 8),
(479, 'Sacha', 'Guinevere', 'ligula.Nullam@ipsum.net', 131777, 1, 1, 5, 5, 4, 6),
(480, 'Hammett', 'Denise', 'fames.ac@imperdiet.ca', 616560, 9, 3, 8, 8, 7, 9),
(481, 'Tamara', 'Sopoline', 'Pellentesque@hendrerit.ca', 417268, 3, 1, 6, 3, 2, 10),
(482, 'Jaden', 'Stacey', 'imperdiet.nec.leo@faucibusMorbi.ca', 823757, 7, 4, 2, 10, 1, 1),
(483, 'Cora', 'Lewis', 'lacinia.at.iaculis@risusaultricies.co.uk', 188449, 10, 3, 5, 7, 8, 9),
(484, 'Hashim', 'Yvette', 'dis.parturient.montes@Donec.com', 654380, 3, 10, 8, 10, 2, 5),
(485, 'Hayfa', 'Janna', 'interdum.ligula@velvulputateeu.org', 139687, 7, 6, 4, 5, 1, 6),
(486, 'Suki', 'Noble', 'odio.Phasellus.at@Proinnisl.co.uk', 774276, 1, 8, 3, 10, 9, 6),
(487, 'Gisela', 'Mia', 'dui@cursusInteger.net', 523727, 8, 7, 2, 6, 7, 7),
(488, 'Octavia', 'Gwendolyn', 'fringilla.euismod@etultrices.com', 928645, 8, 3, 5, 1, 8, 2),
(489, 'Brandon', 'Anthony', 'orci@elitpellentesquea.co.uk', 247784, 3, 7, 6, 10, 3, 7),
(490, 'Kalia', 'Helen', 'sem.eget@tristiquepharetra.edu', 493260, 5, 4, 3, 4, 10, 4),
(491, 'Griffin', 'Felicia', 'gravida.nunc.sed@ultriciesadipiscingenim.com', 406601, 8, 5, 2, 5, 7, 5),
(492, 'Cedric', 'Zelda', 'Donec.nibh@tellus.ca', 60077, 7, 2, 10, 9, 5, 6),
(493, 'Ryan', 'Hilel', 'vehicula.risus.Nulla@dolor.com', 386739, 7, 10, 2, 9, 4, 8),
(494, 'Jackson', 'Pascale', 'egestas.Duis@necurna.org', 321003, 4, 5, 3, 7, 2, 2),
(495, 'Hammett', 'Samuel', 'vitae.odio.sagittis@non.co.uk', 678938, 4, 4, 6, 10, 9, 8),
(496, 'Carl', 'Haviva', 'nascetur.ridiculus@Donec.org', 862706, 1, 1, 8, 1, 4, 6),
(497, 'Adam', 'Wilma', 'risus@Vestibulumante.org', 779562, 6, 7, 7, 8, 10, 3),
(498, 'Salvador', 'Hermione', 'eleifend.non@Inlorem.net', 168483, 9, 8, 6, 4, 7, 4),
(499, 'Tasha', 'Tamekah', 'auctor@atarcu.org', 893879, 1, 8, 1, 8, 10, 4),
(500, 'Channing', 'Cameron', 'Ut.tincidunt.orci@sapienAenean.edu', 361117, 9, 2, 9, 5, 7, 1),
(501, 'Daria', 'Leilani', 'dolor.sit@consequat.net', 983305, 10, 2, 7, 8, 8, 2),
(502, 'Gillian', 'Aurelia', 'sagittis@actellusSuspendisse.edu', 909775, 10, 9, 4, 10, 3, 7),
(503, 'Emma', 'Joelle', 'at.egestas@ultricesmaurisipsum.org', 451972, 4, 7, 1, 7, 7, 10),
(504, 'Aubrey', 'Anjolie', 'cubilia.Curae.Phasellus@loremut.org', 739082, 9, 10, 10, 6, 7, 6),
(505, 'Cade', 'Wang', 'Vestibulum.ut@cursusnon.co.uk', 302073, 3, 3, 6, 3, 7, 10);

-- --------------------------------------------------------

--
-- Table structure for table `bookgenres`
--

CREATE TABLE IF NOT EXISTS `bookgenres` (
`id` int(11) NOT NULL,
  `nom` varchar(100) COLLATE latin1_bin NOT NULL
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 COLLATE=latin1_bin AUTO_INCREMENT=11 ;

--
-- Dumping data for table `bookgenres`
--

INSERT INTO `bookgenres` (`id`, `nom`) VALUES
(1, 'roman'),
(2, 'myths'),
(3, 'comedie'),
(4, 'tragedie'),
(5, 'romance'),
(6, 'fable'),
(7, 'science-fiction'),
(8, 'legende'),
(9, 'thriller'),
(10, 'biographie');

-- --------------------------------------------------------

--
-- Table structure for table `brands`
--

CREATE TABLE IF NOT EXISTS `brands` (
`id` int(11) NOT NULL,
  `nom` varchar(100) COLLATE latin1_bin NOT NULL
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 COLLATE=latin1_bin AUTO_INCREMENT=11 ;

--
-- Dumping data for table `brands`
--

INSERT INTO `brands` (`id`, `nom`) VALUES
(1, 'Apple'),
(2, 'Microsoft'),
(3, 'Google'),
(4, 'Coca-Cola'),
(5, 'McDonald'),
(6, 'Samsung'),
(7, 'intel'),
(8, 'Nike'),
(9, 'Budweiser'),
(10, 'BMW');

-- --------------------------------------------------------

--
-- Table structure for table `hobbies`
--

CREATE TABLE IF NOT EXISTS `hobbies` (
`id` int(11) NOT NULL,
  `nom` varchar(100) COLLATE latin1_bin NOT NULL
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 COLLATE=latin1_bin AUTO_INCREMENT=11 ;

--
-- Dumping data for table `hobbies`
--

INSERT INTO `hobbies` (`id`, `nom`) VALUES
(1, 'lecture'),
(2, 'television'),
(3, 'shopping'),
(4, 'velo'),
(5, 'camping'),
(6, 'natation'),
(7, 'peinture'),
(8, 'cuisiner'),
(9, 'peche'),
(10, 'programmation');

-- --------------------------------------------------------

--
-- Table structure for table `moviegenres`
--

CREATE TABLE IF NOT EXISTS `moviegenres` (
`id` int(11) NOT NULL,
  `nom` varchar(100) COLLATE latin1_bin NOT NULL
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 COLLATE=latin1_bin AUTO_INCREMENT=11 ;

--
-- Dumping data for table `moviegenres`
--

INSERT INTO `moviegenres` (`id`, `nom`) VALUES
(1, 'action'),
(2, 'aventure'),
(3, 'animation'),
(4, 'cgi'),
(5, 'comedie'),
(6, 'policier'),
(7, 'horreur'),
(8, 'romantique'),
(9, 'science-fiction'),
(10, 'espion');

-- --------------------------------------------------------

--
-- Table structure for table `musicgenres`
--

CREATE TABLE IF NOT EXISTS `musicgenres` (
`id` int(11) NOT NULL,
  `nom` varchar(100) COLLATE latin1_bin NOT NULL
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 COLLATE=latin1_bin AUTO_INCREMENT=11 ;

--
-- Dumping data for table `musicgenres`
--

INSERT INTO `musicgenres` (`id`, `nom`) VALUES
(1, 'rock'),
(2, 'blues'),
(3, 'country'),
(4, 'hip hop'),
(5, 'jazz'),
(6, 'reggae'),
(7, 'classique'),
(8, 'techno'),
(9, 'salsa'),
(10, 'pop');

-- --------------------------------------------------------

--
-- Table structure for table `sports`
--

CREATE TABLE IF NOT EXISTS `sports` (
`id` int(11) NOT NULL,
  `nom` varchar(100) COLLATE latin1_bin NOT NULL
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 COLLATE=latin1_bin AUTO_INCREMENT=11 ;

--
-- Dumping data for table `sports`
--

INSERT INTO `sports` (`id`, `nom`) VALUES
(1, 'soccer'),
(2, 'volleyball'),
(3, 'basketball'),
(4, 'hockey'),
(5, 'badminton'),
(6, 'boxe'),
(7, 'rugby'),
(8, 'patinage'),
(9, 'golf'),
(10, 'judo');

--
-- Indexes for dumped tables
--

--
-- Indexes for table `bachelor`
--
ALTER TABLE `bachelor`
 ADD PRIMARY KEY (`id`,`username`);

--
-- Indexes for table `bookgenres`
--
ALTER TABLE `bookgenres`
 ADD PRIMARY KEY (`id`);

--
-- Indexes for table `brands`
--
ALTER TABLE `brands`
 ADD PRIMARY KEY (`id`);

--
-- Indexes for table `hobbies`
--
ALTER TABLE `hobbies`
 ADD PRIMARY KEY (`id`);

--
-- Indexes for table `moviegenres`
--
ALTER TABLE `moviegenres`
 ADD PRIMARY KEY (`id`);

--
-- Indexes for table `musicgenres`
--
ALTER TABLE `musicgenres`
 ADD PRIMARY KEY (`id`);

--
-- Indexes for table `sports`
--
ALTER TABLE `sports`
 ADD PRIMARY KEY (`id`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `bachelor`
--
ALTER TABLE `bachelor`
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=506;
--
-- AUTO_INCREMENT for table `bookgenres`
--
ALTER TABLE `bookgenres`
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=11;
--
-- AUTO_INCREMENT for table `brands`
--
ALTER TABLE `brands`
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=11;
--
-- AUTO_INCREMENT for table `hobbies`
--
ALTER TABLE `hobbies`
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=11;
--
-- AUTO_INCREMENT for table `moviegenres`
--
ALTER TABLE `moviegenres`
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=11;
--
-- AUTO_INCREMENT for table `musicgenres`
--
ALTER TABLE `musicgenres`
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=11;
--
-- AUTO_INCREMENT for table `sports`
--
ALTER TABLE `sports`
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=11;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;