DROP TABLE `person`;

CREATE TABLE `person` (
  `id` mediumint(8) unsigned NOT NULL auto_increment,
  `ID` mediumint,
  `email` varchar(255) default NULL,
  `vorname` varchar(255) default NULL,
  `nachname` varchar(255) default NULL,
  PRIMARY KEY (`id`)
) AUTO_INCREMENT=1;

INSERT INTO `person` (`ID`,`email`,`vorname`,`nachname`) VALUES (1,"dapibus@scelerisqueloremipsum.org","Nadine","Rivera"),(2,"urna.Ut@blandit.edu","Nolan","Welch"),(3,"sagittis.semper@etultricesposuere.edu","Shafira","Colon"),(4,"tortor.at@sodales.ca","Yvette","Burks"),(5,"non@aauctornon.org","Maya","Douglas"),(6,"hendrerit.consectetuer@eleifendegestas.org","Tanya","Haley"),(7,"Vivamus.non.lorem@erategettincidunt.com","Raja","Eaton"),(8,"aliquet.odio@ut.com","Adara","Cherry"),(9,"sem.semper.erat@nonmagna.co.uk","Rae","Strickland"),(10,"ante.Maecenas@ProinultricesDuis.org","Deborah","Hyde");
INSERT INTO `person` (`ID`,`email`,`vorname`,`nachname`) VALUES (11,"sapien.molestie.orci@enimnislelementum.edu","Bryar","Pacheco"),(12,"Vestibulum.ante@vel.org","Amity","Stafford"),(13,"Curabitur@orciDonecnibh.co.uk","Kane","Mullen"),(14,"turpis@vulputaterisus.org","Uriah","Burch"),(15,"adipiscing.enim.mi@cursuseteros.ca","Kameko","Cruz"),(16,"Aenean.massa.Integer@ultrices.edu","Ali","Mason"),(17,"ipsum.cursus@nibhenim.net","Nadine","Hale"),(18,"Quisque.fringilla@arcuVestibulum.org","Maite","Gutierrez"),(19,"gravida.molestie.arcu@Praesenteudui.com","Elmo","Wade"),(20,"laoreet@inceptoshymenaeosMauris.org","Amaya","Riggs");
INSERT INTO `person` (`ID`,`email`,`vorname`,`nachname`) VALUES (21,"odio.Phasellus@enimdiamvel.ca","Abbot","Richard"),(22,"Etiam.laoreet.libero@laciniamattis.co.uk","Aileen","Sawyer"),(23,"adipiscing@indolor.edu","Naomi","Chen"),(24,"enim.diam@Pellentesquehabitantmorbi.org","Avye","Reid"),(25,"Integer@Vivamus.com","Ella","Browning"),(26,"nibh.enim@sedhendrerit.co.uk","Cheyenne","Bridges"),(27,"consequat.purus@vulputateposuerevulputate.edu","Madeson","Hancock"),(28,"amet.risus@lacinia.edu","Nita","Key"),(29,"nisi.Aenean@magnisdisparturient.edu","Hadley","Kane"),(30,"Proin.mi.Aliquam@varius.com","Jasper","Mullen");
INSERT INTO `person` (`ID`,`email`,`vorname`,`nachname`) VALUES (31,"mauris@elit.edu","Amaya","Gilliam"),(32,"In.tincidunt@Suspendisse.co.uk","Fritz","Dominguez"),(33,"tellus.imperdiet.non@sapienNuncpulvinar.org","Beck","Vincent"),(34,"nisl.Quisque@magnisdis.co.uk","Lydia","Browning"),(35,"egestas.Aliquam.nec@primisin.co.uk","Zane","Wiggins"),(36,"vel.arcu@commodoipsumSuspendisse.net","Perry","Dyer"),(37,"ipsum@telluslorem.net","Michael","Wallace"),(38,"rutrum.lorem@amet.ca","Yardley","Coffey"),(39,"Sed.molestie.Sed@Nulla.ca","Illana","Slater"),(40,"dui.Cum@Nunc.co.uk","Kenneth","Vazquez");
INSERT INTO `person` (`ID`,`email`,`vorname`,`nachname`) VALUES (41,"et.arcu.imperdiet@sem.org","Nola","Dominguez"),(42,"nunc.nulla@lectusante.edu","Dara","Mosley"),(43,"massa@fermentum.edu","Mollie","Carpenter"),(44,"ac.fermentum@Fusce.com","Juliet","Morales"),(45,"justo@magnatellus.com","Cadman","Richardson"),(46,"dolor.sit@diam.org","Harriet","Rosa"),(47,"nunc.ullamcorper.eu@Morbiaccumsan.com","Kai","Rasmussen"),(48,"lectus@scelerisqueneque.ca","Bo","Merrill"),(49,"aliquet.molestie@temporbibendum.ca","Genevieve","Best"),(50,"Pellentesque@elitfermentumrisus.edu","Cullen","Mcmahon");
INSERT INTO `person` (`ID`,`email`,`vorname`,`nachname`) VALUES (51,"sed@nonarcu.com","Naomi","Marks"),(52,"sollicitudin.a.malesuada@ipsumprimis.com","Beverly","Vazquez"),(53,"nunc.interdum.feugiat@rutrum.net","Jason","Acosta"),(54,"semper@molestietortor.ca","Cheryl","Poole"),(55,"Integer@cursusNuncmauris.net","Vivien","Wilkins"),(56,"egestas.a.dui@sollicitudincommodoipsum.net","Brent","Espinoza"),(57,"sit.amet.ultricies@feugiattellus.org","Rooney","Fuentes"),(58,"in@tellusloremeu.com","Xander","Terrell"),(59,"amet.massa.Quisque@ametultricies.edu","Isabelle","Bridges"),(60,"litora.torquent@mieleifendegestas.org","Ocean","Ray");
INSERT INTO `person` (`ID`,`email`,`vorname`,`nachname`) VALUES (61,"eget@musProinvel.com","Mira","Campbell"),(62,"metus.sit.amet@Donecporttitor.edu","Kelsey","Galloway"),(63,"purus.Duis@ametrisus.ca","Eagan","Manning"),(64,"metus.urna@Etiamvestibulummassa.edu","Guinevere","Harmon"),(65,"Mauris@amet.net","Felix","Huffman"),(66,"tellus@Donecest.com","Lester","Warner"),(67,"Fusce.dolor.quam@estcongue.ca","Amos","Bowers"),(68,"in@Pellentesquetincidunttempus.edu","Iona","Sweeney"),(69,"suscipit@magnisdisparturient.ca","Gail","Murphy"),(70,"ut.sem.Nulla@neceuismodin.ca","Lois","Byers");
INSERT INTO `person` (`ID`,`email`,`vorname`,`nachname`) VALUES (71,"magna.a.neque@erateget.org","Shea","Mejia"),(72,"Aliquam.auctor@feugiatmetussit.ca","Shad","Mclaughlin"),(73,"vitae.dolor@Quisque.co.uk","Taylor","Sanders"),(74,"sem.semper@commodo.org","Indigo","Small"),(75,"Duis.volutpat.nunc@euplacerat.net","Dane","Todd"),(76,"scelerisque.mollis@fringillacursus.edu","Thane","Long"),(77,"arcu.Sed.eu@insodaleselit.net","Lars","Ruiz"),(78,"Integer.urna@pellentesquemassa.com","Helen","Sanders"),(79,"a.mi@tinciduntDonec.ca","Bruno","Lyons"),(80,"est.mollis@metuseu.org","Grant","Mckee");
INSERT INTO `person` (`ID`,`email`,`vorname`,`nachname`) VALUES (81,"Morbi.non@loremtristiquealiquet.co.uk","Gary","Oconnor"),(82,"porttitor.vulputate.posuere@etultricesposuere.org","Rebecca","Thornton"),(83,"diam@vel.edu","Judith","Valdez"),(84,"Vivamus.rhoncus@massaInteger.ca","Victoria","Lynch"),(85,"luctus.ipsum@urna.org","Callum","Burton"),(86,"luctus.ipsum.leo@utlacus.org","Hayley","Mcfadden"),(87,"mauris.ipsum@malesuada.org","Preston","Morse"),(88,"mi.tempor@Namligulaelit.ca","Octavia","Conner"),(89,"fermentum.arcu@ultrices.net","Quintessa","Justice"),(90,"Fusce.feugiat@Donec.ca","Gemma","Oneill");
INSERT INTO `person` (`ID`,`email`,`vorname`,`nachname`) VALUES (91,"varius@semNullainterdum.co.uk","Yuli","Tate"),(92,"In.mi@acmattissemper.org","Tatyana","Ashley"),(93,"lacinia@Suspendisse.edu","Basia","Anderson"),(94,"Aenean.sed@consectetuercursuset.org","Eugenia","Simmons"),(95,"risus.a@aliquamenim.co.uk","Quincy","Bishop"),(96,"luctus@sagittissemperNam.com","Brynne","Holloway"),(97,"egestas.ligula@dolorFusce.com","Arthur","Park"),(98,"ligula.Nullam.feugiat@Donectempus.edu","Prescott","Burton"),(99,"semper.auctor@nonmagna.co.uk","Steel","Middleton"),(100,"turpis.Nulla@sempertellus.org","Luke","Farrell");