-- MySQL dump 10.13  Distrib 8.0.18, for Win64 (x86_64)
--
-- Host: localhost    Database: exercice_trigger
-- ------------------------------------------------------
-- Server version	8.0.18

/*!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 */;
/*!50503 SET NAMES utf8mb4 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

DROP DATABASE IF EXISTS bd2_ex07;
CREATE DATABASE bd2_ex07;

USE bd2_ex07;

--
-- Table structure for table `athletes`
--

DROP TABLE IF EXISTS `athletes`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `athletes` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `nom` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `prenom` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `date_naissance` date NOT NULL,
  `adresse` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `ville` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `province` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `pays` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `courriel` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=501 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `athletes`
--

LOCK TABLES `athletes` WRITE;
/*!40000 ALTER TABLE `athletes` DISABLE KEYS */;
INSERT INTO `athletes` VALUES (1,'Millward','Marie-françoise','1925-11-04','2712 Vernon Park','Bedford','Québec','Canada','gmillward0@bbb.org'),(2,'Castelin','Ruì','1993-01-20','2712 Vernon Park','Bedford','Québec','Canada','gmillward0@bbb.org'),(3,'Tiron','Marylène','2000-05-22','8 Sachs Drive','Parrsboro','Nova Scotia','Canada','atiron2@drupal.org'),(4,'Donnel','Maï','1923-09-08','8117 Surrey Alley','Sainte-Martine','Québec','Canada','wdonnel3@google.com.au'),(5,'Flowers','Gaétane','1939-03-08','66 Village Pass','Cabano','Québec','Canada','rflowers4@aol.com'),(6,'Buckie','Görel','1965-08-26','7427 Hovde Alley','Oshawa','Ontario','Canada','ebuckie5@drupal.org'),(7,'Scane','Irène','1957-09-24','71 Almo Lane','Cache Creek','British Columbia','Canada','ascane6@columbia.edu'),(8,'Yanov','Thérèsa','1984-09-14','88 East Alley','Oxford','Nova Scotia','Canada','gyanov7@printfriendly.com'),(9,'Brain','Dafnée','1985-03-15','4107 Ohio Avenue','Saint-Lambert-de-Lauzon','Québec','Canada','kbrain8@360.cn'),(10,'Delany','Lucrèce','1943-12-25','188 Ohio Crossing','Ottawa','Ontario','Canada','ndelany9@microsoft.com'),(11,'Mathiasen','Maëlle','2003-01-15','8557 Thompson Way','Saint-Augustin','Québec','Canada','bmathiasena@diigo.com'),(12,'Ping','Andrée','1989-08-07','7744 Fieldstone Place','Montréal-Est','Québec','Canada','hpingb@ca.gov'),(13,'Murty','Thérèse','2000-11-06','09794 Packers Alley','Dalmeny','Saskatchewan','Canada','wmurtyc@usa.gov'),(14,'Bernier','Kévina','1925-05-03','83 Northridge Road','Little Current','Ontario','Canada','cbernierd@joomla.org'),(15,'Jeanequin','Maëlla','1954-11-23','4 Carioca Terrace','Wingham','Ontario','Canada','mjeanequine@devhub.com'),(16,'Harbage','Néhémie','1986-03-15','66954 Randy Terrace','Lévis','Québec','Canada','bharbagef@freewebs.com'),(17,'Sotham','Méng','1929-01-20','0 Maywood Lane','Richmond','British Columbia','Canada','rsothamg@ca.gov'),(18,'Franceschi','Crééz','1954-11-22','32717 Artisan Circle','St. Thomas','Ontario','Canada','sfranceschih@blogs.com'),(19,'Maytom','Bérénice','1975-02-28','434 School Terrace','Carleton-sur-Mer','Québec','Canada','lmaytomi@marketwatch.com'),(20,'Rosenkrantz','Ráo','1950-03-22','7 Garrison Lane','Athabasca','Alberta','Canada','grosenkrantzj@discovery.com'),(21,'Mulles','André','1988-08-20','8357 Veith Avenue','Lumby','British Columbia','Canada','jmullesk@yale.edu'),(22,'Shark','Léonie','1944-05-26','4854 Esker Drive','High River','Alberta','Canada','dsharkl@kickstarter.com'),(23,'Simoneschi','Sélène','1994-02-11','0 Gerald Street','Sainte-Marthe-sur-le-Lac','Québec','Canada','csimoneschim@drupal.org'),(24,'Sangar','Léonore','1944-12-25','36226 Maryland Trail','Melfort','Saskatchewan','Canada','ssangarn@booking.com'),(25,'Davidek','Åke','1954-04-27','03 Fulton Lane','Grande Prairie','Alberta','Canada','jdavideko@pen.io'),(26,'Tunnicliffe','Gaétane','1995-07-03','301 Hooker Hill','Kelowna','British Columbia','Canada','ttunnicliffep@xinhuanet.com'),(27,'Walczak','Michèle','1967-12-20','7909 Mccormick Lane','Jonquière','Québec','Canada','nwalczakq@pbs.org'),(28,'Cleatherow','Börje','1947-10-13','6 Laurel Plaza','Lac du Bonnet','Manitoba','Canada','mcleatherowr@unesco.org'),(29,'McCamish','Marie-thérèse','1979-12-19','7305 Comanche Road','Ponoka','Alberta','Canada','dmccamishs@reddit.com'),(30,'Dady','Méng','1958-02-16','24586 Acker Parkway','Grande Prairie','Alberta','Canada','mdadyt@cdbaby.com'),(31,'Neylon','Médiamass','1991-02-04','70 Doe Crossing Road','Coaticook','Québec','Canada','jneylonu@bbb.org'),(32,'Dusting','Thérèse','1940-04-23','533 Glacier Hill Hill','Whistler','British Columbia','Canada','bdustingv@youtube.com'),(33,'Nerval','Aí','1991-12-01','175 Spaight Pass','Pont-Rouge','Québec','Canada','snervalw@plala.or.jp'),(34,'Iseton','Cléopatre','1936-07-18','638 Esch Road','Hudson','Québec','Canada','bisetonx@ftc.gov'),(35,'Vertigan','Stéphanie','1948-03-25','51280 Truax Trail','Pierreville','Québec','Canada','jvertigany@xrea.com'),(36,'Mankor','Amélie','1930-05-30','227 Jenna Junction','Oshawa','Ontario','Canada','emankorz@e-recht24.de'),(37,'Firmager','Célia','2002-03-30','89 Katie Terrace','Beloeil','Québec','Canada','mfirmager10@soup.io'),(38,'Aitken','Gwenaëlle','1927-07-20','4844 Waubesa Court','Belleville','Ontario','Canada','gaitken11@nps.gov'),(39,'Zelner','Audréanne','1968-07-27','80628 Carpenter Park','Houston','British Columbia','Canada','pzelner12@omniture.com'),(40,'Lorenzini','Maëlla','1980-03-26','370 Mcbride Pass','Weyburn','Saskatchewan','Canada','slorenzini13@kickstarter.com'),(41,'McGillecole','Clémentine','1941-06-17','7 Butternut Plaza','Thompson','Manitoba','Canada','jmcgillecole14@redcross.org'),(42,'Schuelcke','Zhì','1988-07-14','8 Grasskamp Terrace','Sherbrooke','Québec','Canada','cschuelcke15@newsvine.com'),(43,'Chilton','Gérald','1993-11-25','1923 Vera Park','Nakusp','British Columbia','Canada','kchilton16@state.tx.us'),(44,'Rainer','Loïc','1983-04-26','053 Fallview Way','Baie-Comeau','Québec','Canada','prainer17@vistaprint.com'),(45,'Korfmann','Léone','1983-11-27','4755 Florence Alley','Grand Bank','Newfoundland and Labrador','Canada','lkorfmann18@infoseek.co.jp'),(46,'Grover','Zoé','1968-09-03','2 Clyde Gallagher Court','La Tuque','Québec','Canada','kgrover19@stanford.edu'),(47,'Banasiak','Intéressant','1932-03-06','1 1st Drive','Hearst','Ontario','Canada','gbanasiak1a@homestead.com'),(48,'Luce','Ruò','1927-11-29','406 Donald Park','Saint-Augustin','Québec','Canada','rluce1b@cam.ac.uk'),(49,'Scotchmore','Lyséa','1992-11-22','278 Graceland Lane','Richibucto','New Brunswick','Canada','cscotchmore1c@dyndns.org'),(50,'Tydd','Marie-françoise','1934-05-13','276 Barnett Alley','Flin Flon','Manitoba','Canada','ctydd1d@hatena.ne.jp'),(51,'Fley','Mélys','1976-10-15','8534 Vahlen Plaza','Bonavista','Newfoundland and Labrador','Canada','pfley1e@stanford.edu'),(52,'Jardine','Esbjörn','1982-02-19','43936 Miller Way','Lac du Bonnet','Manitoba','Canada','rjardine1f@mapy.cz'),(53,'Burnage','Eléa','1987-03-22','7 Doe Crossing Trail','Wolfville','Nova Scotia','Canada','fburnage1g@flickr.com'),(54,'Bukac','Pénélope','1982-09-30','23 Butternut Place','Killam','Alberta','Canada','gbukac1h@yellowbook.com'),(55,'Abrams','Annotée','1958-07-14','1 Manley Street','Willowdale','Ontario','Canada','fabrams1i@squarespace.com'),(56,'Canwell','Maïly','1999-08-16','1943 Kipling Road','Sainte-Thérèse','Québec','Canada','scanwell1j@liveinternet.ru'),(57,'Hadingham','Yénora','1952-07-13','2 Truax Plaza','Edson','Alberta','Canada','jhadingham1k@huffingtonpost.com'),(58,'Stoves','Maëly','1990-09-05','408 Grasskamp Parkway','Château-Richer','Québec','Canada','astoves1l@ted.com'),(59,'Ruppel','Måns','1972-03-08','4 Monica Circle','Hudson','Québec','Canada','eruppel1m@over-blog.com'),(60,'Larter','Intéressant','1991-07-31','0767 Cottonwood Lane','Alberton','Prince Edward Island','Canada','llarter1n@cnet.com'),(61,'Divis','Réservés','1968-05-05','6 Westridge Circle','Kimberley','British Columbia','Canada','gdivis1o@intel.com'),(62,'Ormond','Marie-ève','1996-05-23','471 Bunting Way','Minnedosa','Manitoba','Canada','rormond1p@scribd.com'),(63,'Brimman','Véronique','1975-06-18','53134 Fair Oaks Place','Summerland','British Columbia','Canada','dbrimman1q@skyrock.com'),(64,'Hicken','Ruì','1988-10-17','97 Becker Trail','Repentigny','Québec','Canada','khicken1r@4shared.com'),(65,'Leeke','Méghane','1993-01-17','646 Old Gate Place','Leduc','Alberta','Canada','kleeke1s@yahoo.co.jp'),(66,'Skerm','Réjane','1968-03-08','634 Golf View Alley','Les Cèdres','Québec','Canada','cskerm1t@plala.or.jp'),(67,'Antao','Mélodie','1931-03-09','6289 Pepper Wood Hill','Stratford','Ontario','Canada','mantao1u@pcworld.com'),(68,'Kilborn','Vénus','2004-02-18','93 Morrow Parkway','Napanee Downtown','Ontario','Canada','jkilborn1v@cargocollective.com'),(69,'Dunlop','Styrbjörn','1994-02-27','028 Graceland Hill','Fairview','Alberta','Canada','rdunlop1w@imdb.com'),(70,'Hunstone','Märta','1959-01-20','83 Kinsman Trail','Cache Creek','British Columbia','Canada','jhunstone1x@amazon.co.jp'),(71,'Chinery','Aloïs','1966-05-06','0386 Summer Ridge Road','Richmond','Québec','Canada','echinery1y@hexun.com'),(72,'Flounders','Fèi','1926-11-22','563 Paget Terrace','Nakusp','British Columbia','Canada','mflounders1z@freewebs.com'),(73,'Tomankowski','Noëlla','1951-04-22','6 Oxford Center','Hearst','Ontario','Canada','stomankowski20@cloudflare.com'),(74,'Westwater','Thérèse','1978-10-22','253 Hayes Drive','Barraute','Québec','Canada','dwestwater21@google.nl'),(75,'Ranking','Ophélie','1954-12-13','168 Emmet Junction','Peace River','Alberta','Canada','vranking22@google.com.hk'),(76,'Scibsey','Camélia','1927-03-26','31 Tony Trail','La Sarre','Québec','Canada','yscibsey23@example.com'),(77,'Colchett','Néhémie','1991-06-30','2 Londonderry Junction','Aldergrove','British Columbia','Canada','mcolchett24@icq.com'),(78,'Consadine','Sòng','1942-04-23','97 Nobel Place','Barrhead','Alberta','Canada','rconsadine25@cocolog-nifty.com'),(79,'Slobom','Hélèna','1949-07-12','644 Dunning Trail','Saint Andrews','New Brunswick','Canada','jslobom26@sciencedirect.com'),(80,'Vanacci','Andréa','1921-12-21','25744 Hudson Terrace','Kingsey Falls','Québec','Canada','evanacci27@deliciousdays.com'),(81,'Yakobowitch','Thérèse','1965-03-03','792 Sage Parkway','Ucluelet','British Columbia','Canada','myakobowitch28@uol.com.br'),(82,'Yeaman','Réjane','1950-03-15','973 Sauthoff Avenue','Skatepark','Ontario','Canada','myeaman29@geocities.com'),(83,'Caulfield','Méryl','2004-11-19','64 Montana Parkway','Rayside-Balfour','Ontario','Canada','dcaulfield2a@blogtalkradio.com'),(84,'Giottini','Miléna','2000-12-09','815 Gerald Plaza','Saint John','New Brunswick','Canada','lgiottini2b@hugedomains.com'),(85,'Cosser','Mårten','2004-03-24','6 Arkansas Lane','Bowen Island','British Columbia','Canada','jcosser2c@npr.org'),(86,'Kyberd','Laïla','1934-01-28','6400 Nancy Alley','Timmins','Ontario','Canada','jkyberd2d@taobao.com'),(87,'Spawell','Örjan','1944-01-06','088 Hovde Center','Wingham','Ontario','Canada','bspawell2e@intel.com'),(88,'Duckels','Célestine','1977-12-13','78394 Spohn Trail','Delson','Québec','Canada','sduckels2f@wikipedia.org'),(89,'Stoneley','Aurélie','1995-08-11','618 Gina Way','Saint-Ambroise','Québec','Canada','fstoneley2g@harvard.edu'),(90,'Capes','Yú','1957-04-20','05 Ilene Point','Ucluelet','British Columbia','Canada','acapes2h@fotki.com'),(91,'Mathey','Réservés','1999-03-01','73833 Veith Court','Bonnyville','Alberta','Canada','smathey2i@twitpic.com'),(92,'Carl','Léandre','1949-10-18','3105 American Crossing','Virden','Manitoba','Canada','scarl2j@gov.uk'),(93,'Feighry','Frédérique','2003-06-15','1 Northview Lane','Wingham','Ontario','Canada','dfeighry2k@ted.com'),(94,'Ciobotaro','Tán','1946-04-28','2714 Glendale Terrace','Mercier','Québec','Canada','mciobotaro2l@example.com'),(95,'Sansbury','Gaïa','1933-04-12','74 Little Fleur Parkway','Laval','Québec','Canada','ssansbury2m@zdnet.com'),(96,'Yare','Mahélie','2003-02-17','6 Lerdahl Parkway','Arnprior','Ontario','Canada','eyare2n@loc.gov'),(97,'Fowley','Joséphine','1925-07-16','0 Riverside Street','Chester','Nova Scotia','Canada','sfowley2o@dmoz.org'),(98,'Morton','Léandre','1942-03-23','829 Buhler Alley','Morris','Manitoba','Canada','amorton2p@princeton.edu'),(99,'Wissby','Anaé','1981-08-14','1027 Butterfield Hill','Repentigny','Québec','Canada','jwissby2q@wiley.com'),(100,'McIlwraith','Inès','1972-06-26','7 2nd Circle','Lanigan','Saskatchewan','Canada','wmcilwraith2r@twitpic.com'),(101,'Sloley','Görel','2002-11-29','45600 Myrtle Hill','Vulcan','Alberta','Canada','esloley2s@a8.net'),(102,'Iacapucci','Cunégonde','1937-10-14','68 Burrows Way','Trois-Rivières','Québec','Canada','hiacapucci2t@geocities.jp'),(103,'Mazzei','Cléa','2003-01-03','49 Ronald Regan Way','Sicamous','British Columbia','Canada','amazzei2u@angelfire.com'),(104,'Kalberer','Yè','1935-08-17','51010 Anniversary Terrace','Brampton','Ontario','Canada','mkalberer2v@illinois.edu'),(105,'Caulcutt','Yáo','1936-10-25','4559 Johnson Road','St. Thomas','Ontario','Canada','hcaulcutt2w@geocities.jp'),(106,'Lubbock','Michèle','1978-02-09','385 Judy Crossing','Bells Corners','Ontario','Canada','slubbock2x@marriott.com'),(107,'Connolly','Maïly','1996-11-14','99860 Debra Way','Agassiz','British Columbia','Canada','iconnolly2y@a8.net'),(108,'Enevoldsen','Ophélie','1948-09-05','17960 Eagle Crest Pass','Penhold','Alberta','Canada','genevoldsen2z@imageshack.us'),(109,'Kelwick','Mélanie','1973-12-23','10763 Straubel Trail','Warwick','Québec','Canada','bkelwick30@printfriendly.com'),(110,'Duhig','Styrbjörn','1933-06-23','877 School Trail','Okanagan','British Columbia','Canada','gduhig31@virginia.edu'),(111,'Orgee','Lyséa','1973-01-01','10 Continental Circle','Omemee','Ontario','Canada','sorgee32@joomla.org'),(112,'Loyley','Valérie','1923-11-01','9 Shopko Drive','Gjoa Haven','Nunavut','Canada','mloyley33@nasa.gov'),(113,'MacConnell','Thérèsa','1935-06-07','664 New Castle Junction','Ucluelet','British Columbia','Canada','vmacconnell34@about.me'),(114,'Vida','Lauréna','2000-12-04','6 Shoshone Parkway','Saint John','New Brunswick','Canada','cvida35@topsy.com'),(115,'Huyhton','Görel','1980-10-06','85510 Fisk Way','Chambly','Québec','Canada','bhuyhton36@icq.com'),(116,'Nanelli','Lyséa','1962-12-01','05815 Kipling Plaza','Sherbrooke','Québec','Canada','cnanelli37@ox.ac.uk'),(117,'Seago','Andrée','1976-09-14','6115 Di Loreto Way','Sussex','New Brunswick','Canada','dseago38@theguardian.com'),(118,'Dixon','Cléa','1956-02-20','6 Oriole Trail','Moncton','New Brunswick','Canada','udixon39@uiuc.edu'),(119,'Geator','Marie-thérèse','1964-09-13','0080 Kensington Drive','Sainte-Adèle','Québec','Canada','ggeator3a@gov.uk'),(120,'Dionisetti','Loïca','1968-01-11','72 Sutteridge Avenue','Kensington','Prince Edward Island','Canada','sdionisetti3b@china.com.cn'),(121,'Tupie','Mélia','1950-11-21','27296 Prairieview Place','Saint-Lambert-de-Lauzon','Québec','Canada','ktupie3c@spotify.com'),(122,'Paur','Örjan','2002-11-24','19 Hintze Trail','Swift Current','Saskatchewan','Canada','apaur3d@ed.gov'),(123,'Carmel','Thérèse','1963-07-18','09677 7th Park','Berthierville','Québec','Canada','scarmel3e@cnbc.com'),(124,'Marton','Maïwenn','1971-08-24','5 Lake View Parkway','Biggar','Saskatchewan','Canada','vmarton3f@paypal.com'),(125,'Hodgets','Maëline','1926-09-27','51 Grover Center','Louiseville','Québec','Canada','ehodgets3g@unesco.org'),(126,'Roskelley','Aí','1989-04-29','2 Duke Center','Marathon','Ontario','Canada','lroskelley3h@nyu.edu'),(127,'Clapson','Clémence','1971-11-05','49 Butternut Circle','Mont-Laurier','Québec','Canada','aclapson3i@opensource.org'),(128,'Ezzell','Clémence','1938-03-25','18908 Cascade Circle','Langenburg','Saskatchewan','Canada','bezzell3j@nps.gov'),(129,'Engall','Léonore','1972-08-02','4 Kings Parkway','Minnedosa','Manitoba','Canada','lengall3k@google.com'),(130,'Gianninotti','Pélagie','1975-11-07','2 Forster Lane','New Westminster','British Columbia','Canada','hgianninotti3l@engadget.com'),(131,'Banaszczyk','Vénus','1934-01-25','382 Warbler Parkway','Kingsey Falls','Québec','Canada','bbanaszczyk3m@weather.com'),(132,'Starking','Ruì','1921-05-19','9 Dayton Road','Two Hills','Alberta','Canada','lstarking3n@fotki.com'),(133,'Armall','Mélissandre','1967-03-11','88 Scofield Way','Kitchener','Ontario','Canada','oarmall3o@marriott.com'),(134,'Bygrave','Kuí','1995-06-11','843 Manufacturers Pass','Saint-Joseph-de-Coleraine','Québec','Canada','hbygrave3p@dmoz.org'),(135,'Yurlov','Pélagie','1975-04-27','44896 Harper Drive','Smithers','British Columbia','Canada','hyurlov3q@upenn.edu'),(136,'Enriques','Bérangère','1963-01-18','63 Maple Junction','Raymond','Alberta','Canada','aenriques3r@gnu.org'),(137,'Kerridge','Cécile','1928-05-29','6574 Weeping Birch Junction','Pembroke','Ontario','Canada','mkerridge3s@psu.edu'),(138,'Mitkcov','Dafnée','1970-04-27','5 Hanover Lane','Fredericton','New Brunswick','Canada','rmitkcov3t@dailymail.co.uk'),(139,'Ayshford','Zoé','1924-08-20','40203 Graceland Plaza','Notre-Dame-de-l\'Île-Perrot','Québec','Canada','jayshford3u@networksolutions.com'),(140,'Drake','Lyséa','2002-04-15','8235 New Castle Court','Sainte-Thérèse','Québec','Canada','pdrake3v@chicagotribune.com'),(141,'Clover','Léonie','1970-07-29','7 Moland Parkway','Lachute','Québec','Canada','iclover3w@yahoo.com'),(142,'Stuchbery','Anaël','1952-12-11','6593 Clyde Gallagher Plaza','Norman Wells','Northwest Territories','Canada','cstuchbery3x@merriam-webster.com'),(143,'Kagan','Åslög','1923-06-18','47 Canary Park','Mont-Saint-Hilaire','Québec','Canada','bkagan3y@bloglovin.com'),(144,'Dehmel','Crééz','1974-05-18','9 Macpherson Avenue','Ottawa','Ontario','Canada','rdehmel3z@moonfruit.com'),(145,'Connop','Marie-thérèse','1976-05-26','74077 Texas Place','Matagami','Québec','Canada','mconnop40@youku.com'),(146,'Peare','Annotée','1971-07-22','51 Becker Circle','Minnedosa','Manitoba','Canada','kpeare41@wix.com'),(147,'Stonman','Stéphanie','1958-01-30','768 Bay Plaza','Lambton Shores','Ontario','Canada','sstonman42@usatoday.com'),(148,'Allner','Táng','1977-04-28','2867 Memorial Alley','Saguenay','Québec','Canada','callner43@sciencedirect.com'),(149,'Pirie','Irène','1944-08-20','651 Green Drive','Drayton Valley','Alberta','Canada','dpirie44@shareasale.com'),(150,'Clinkard','Ruò','1996-10-20','781 Kinsman Terrace','Baie-D\'Urfé','Québec','Canada','pclinkard45@economist.com'),(151,'Moylane','Maïlys','1946-09-08','7 Fordem Terrace','Mirabel','Québec','Canada','amoylane46@eepurl.com'),(152,'Pacheco','Eloïse','1932-07-16','988 Cherokee Crossing','Anmore','British Columbia','Canada','rpacheco47@free.fr'),(153,'Sebrook','Béatrice','1991-05-22','221 Heffernan Alley','Sylvan Lake','Alberta','Canada','csebrook48@mozilla.com'),(154,'Prout','Måns','1958-05-23','2527 Fulton Plaza','Brampton','Ontario','Canada','oprout49@t.co'),(155,'Ledwidge','Yóu','1928-04-22','6571 Shasta Hill','L\'Île-Perrot','Québec','Canada','qledwidge4a@cnn.com'),(156,'MacAiline','Alizée','1996-10-25','72 Havey Hill','Saint-Augustin-de-Desmaures','Québec','Canada','hmacailine4b@soup.io'),(157,'Minshull','Maéna','1934-08-21','33594 East Court','Metchosin','British Columbia','Canada','sminshull4c@icq.com'),(158,'Behn','Maëlys','1965-02-20','10 Elmside Junction','Assiniboia','Saskatchewan','Canada','gbehn4d@myspace.com'),(159,'Licciardi','Cloé','1977-06-05','470 Russell Alley','Roberval','Québec','Canada','olicciardi4e@symantec.com'),(160,'Law','Yè','1933-12-28','02 Bonner Center','Lac-Brome','Québec','Canada','mlaw4f@harvard.edu'),(161,'de Bullion','Faîtes','1946-03-08','19 Ryan Park','Amqui','Québec','Canada','adebullion4g@ted.com'),(162,'Kann','Marlène','1962-07-21','7034 Carpenter Parkway','Clarence-Rockland','Ontario','Canada','zkann4h@loc.gov'),(163,'Kineton','Loïca','1937-05-31','9 Memorial Terrace','Hantsport','Nova Scotia','Canada','akineton4i@deliciousdays.com'),(164,'Bertelsen','Séverine','1940-12-31','84 Badeau Avenue','Athabasca','Alberta','Canada','hbertelsen4j@hp.com'),(165,'Jost','Athéna','1988-11-08','15840 Fairview Trail','Greenwood','Nova Scotia','Canada','cjost4k@ameblo.jp'),(166,'Cuniffe','Örjan','1933-07-02','6204 Green Ridge Pass','Watrous','Saskatchewan','Canada','tcuniffe4l@about.me'),(167,'Kopfer','Marie-noël','1933-09-30','380 Ridge Oak Court','Smoky Lake','Alberta','Canada','ckopfer4m@state.tx.us'),(168,'Gemson','Rébecca','1979-08-04','6 Colorado Crossing','Oshawa','Ontario','Canada','wgemson4n@de.vu'),(169,'Collett','Josée','2003-01-22','69 New Castle Way','Atikokan','Ontario','Canada','bcollett4o@nih.gov'),(170,'Clifforth','Angèle','2001-04-14','916 Grayhawk Pass','Aylmer','Ontario','Canada','lclifforth4p@ucsd.edu'),(171,'Braganca','Kù','1924-08-25','653 Parkside Place','Antigonish','Nova Scotia','Canada','abraganca4q@yandex.ru'),(172,'Godleman','Maïté','1946-10-01','4 Thompson Crossing','Québec','Québec','Canada','wgodleman4r@multiply.com'),(173,'Humfrey','Maïté','1959-05-23','71765 Badeau Hill','St. Catharines','Ontario','Canada','bhumfrey4s@apache.org'),(174,'Dragonette','Crééz','1994-09-10','0901 Haas Street','Kirkland Lake','Ontario','Canada','tdragonette4t@engadget.com'),(175,'Ashlin','Göran','1955-11-09','2 Killdeer Circle','Niverville','Manitoba','Canada','tashlin4u@squarespace.com'),(176,'Gower','Lèi','1999-10-27','24533 Golf View Crossing','Ottawa','Ontario','Canada','dgower4v@webeden.co.uk'),(177,'Dominelli','Marie-hélène','1929-01-11','77732 Pennsylvania Parkway','Nanton','Alberta','Canada','kdominelli4w@netvibes.com'),(178,'Wyne','Marie-françoise','1923-12-14','3543 Delaware Way','Thompson','Manitoba','Canada','kwyne4x@wordpress.com'),(179,'Challin','Amélie','1971-08-15','44530 Springs Center','Brampton','Ontario','Canada','mchallin4y@bloglovin.com'),(180,'Cay','Marie-ève','1993-07-10','9471 Pennsylvania Pass','Mercier','Québec','Canada','tcay4z@netvibes.com'),(181,'Pepler','Mélodie','1970-10-05','18201 Eagle Crest Court','Chambly','Québec','Canada','apepler50@drupal.org'),(182,'Mordy','Yè','1976-07-20','77 Moland Avenue','Hearst','Ontario','Canada','mmordy51@typepad.com'),(183,'Barkus','Aí','1955-06-03','8 Bartelt Center','Saint-Joseph-de-Coleraine','Québec','Canada','fbarkus52@barnesandnoble.com'),(184,'Grimsdike','Lauréna','1937-12-07','772 Lien Point','Willowdale','Ontario','Canada','ngrimsdike53@blinklist.com'),(185,'Hulks','Adèle','1957-01-30','810 School Pass','Morinville','Alberta','Canada','chulks54@nhs.uk'),(186,'Heamus','Adèle','1950-10-21','85 Amoth Point','Labelle','Québec','Canada','iheamus55@ezinearticles.com'),(187,'Stoffers','Céline','1962-08-12','0756 Bonner Crossing','Petrolia','Ontario','Canada','tstoffers56@miibeian.gov.cn'),(188,'Gwinn','Bérénice','1952-05-08','3753 Garrison Point','Gravelbourg','Saskatchewan','Canada','mgwinn57@deliciousdays.com'),(189,'Fretson','Marie-hélène','1977-08-24','4717 Mccormick Drive','Lac du Bonnet','Manitoba','Canada','kfretson58@addtoany.com'),(190,'Chooter','Publicité','1967-09-06','88 Merchant Court','Killarney','Manitoba','Canada','kchooter59@biblegateway.com'),(191,'Le Teve','Anaëlle','1954-11-18','8522 Bunting Plaza','Rivière-du-Loup','Québec','Canada','mleteve5a@amazon.co.jp'),(192,'Cescotti','Örjan','1939-12-07','39 Michigan Plaza','Golden','British Columbia','Canada','ncescotti5b@twitpic.com'),(193,'Theaker','Vénus','1975-06-23','332 Blackbird Court','Oxford','Nova Scotia','Canada','mtheaker5c@mozilla.org'),(194,'Ardy','Séverine','1937-06-07','59 Oakridge Crossing','Outlook','Saskatchewan','Canada','iardy5d@marriott.com'),(195,'Poff','Maëlle','1959-05-07','5 Moland Terrace','Claresholm','Alberta','Canada','lpoff5e@youku.com'),(196,'Ilive','Crééz','1925-11-16','71 Oxford Parkway','Longueuil','Québec','Canada','jilive5f@ed.gov'),(197,'Spiers','Adèle','1985-03-18','27074 Randy Place','Saint-Joseph-de-Coleraine','Québec','Canada','gspiers5g@washington.edu'),(198,'Abbotts','Lóng','1986-11-05','1380 Eliot Way','Warwick','Québec','Canada','cabbotts5h@bloglines.com'),(199,'Caine','Estève','2003-12-14','97 Victoria Park','St. Thomas','Ontario','Canada','mcaine5i@php.net'),(200,'Bayston','Séverine','1954-08-22','8 Drewry Crossing','Moncton','New Brunswick','Canada','ebayston5j@usnews.com'),(201,'Fellow','Liè','1935-09-08','01 Russell Terrace','Longueuil','Québec','Canada','mfellow5k@topsy.com'),(202,'Muzzillo','Marie-noël','1928-09-17','21 Truax Point','Duncan','British Columbia','Canada','lmuzzillo5l@a8.net'),(203,'Kernock','Garçon','1942-01-22','07822 Holmberg Hill','Oshawa','Ontario','Canada','bkernock5m@npr.org'),(204,'Januszkiewicz','Marie-thérèse','1967-07-31','31489 Pepper Wood Trail','Norman Wells','Northwest Territories','Canada','jjanuszkiewicz5n@facebook.com'),(205,'Yurenev','Anaïs','1954-05-20','06 Butterfield Park','Assiniboia','Saskatchewan','Canada','syurenev5o@sbwire.com'),(206,'Argent','Cinéma','1991-05-02','4 Jana Junction','Morden','Manitoba','Canada','rargent5p@miibeian.gov.cn'),(207,'Bendell','Michèle','1990-12-10','6384 Ronald Regan Trail','Cabano','Québec','Canada','ebendell5q@hp.com'),(208,'Albon','Fèi','2002-12-26','398 Banding Trail','Windsor','Québec','Canada','walbon5r@apache.org'),(209,'Forri','Cléa','1980-11-07','27 Montana Lane','Oakville','Ontario','Canada','uforri5s@huffingtonpost.com'),(210,'Finnis','Anaïs','1946-09-06','30 Springview Drive','Antigonish','Nova Scotia','Canada','cfinnis5t@a8.net'),(211,'Hilldrup','Lucrèce','1941-11-12','10 Twin Pines Junction','Otterburn Park','Québec','Canada','khilldrup5u@redcross.org'),(212,'Scholling','Béatrice','1977-05-05','4534 Holy Cross Terrace','Metchosin','British Columbia','Canada','ascholling5v@mac.com'),(213,'Camlin','Léa','1980-03-18','6075 Farmco Junction','Drummondville','Québec','Canada','wcamlin5w@mapy.cz'),(214,'Popov','Ruò','1943-04-18','8 Schlimgen Terrace','Forestville','Québec','Canada','lpopov5x@biglobe.ne.jp'),(215,'Dahlberg','Félicie','1985-06-03','5 Mifflin Trail','Richmond','British Columbia','Canada','adahlberg5y@princeton.edu'),(216,'Balston','Gaëlle','1921-05-15','5868 Florence Drive','Farnham','Québec','Canada','sbalston5z@craigslist.org'),(217,'Bogie','Kuí','1990-10-15','14 Brown Junction','Saint-Sauveur','Québec','Canada','obogie60@bluehost.com'),(218,'Fenner','Renée','1946-12-23','65 Hanson Road','Boissevain','Manitoba','Canada','afenner61@cmu.edu'),(219,'Madre','Joséphine','1997-03-07','09517 Knutson Point','Lorraine','Québec','Canada','dmadre62@businessweek.com'),(220,'Williment','Méng','1925-01-05','4904 Fallview Street','Ladysmith','British Columbia','Canada','cwilliment63@studiopress.com'),(221,'Emmet','Joséphine','1962-10-05','46 Continental Pass','Middleton','Nova Scotia','Canada','remmet64@g.co'),(222,'Quincee','Andréa','1970-12-21','214 Dapin Plaza','Kerrobert','Saskatchewan','Canada','bquincee65@cdc.gov'),(223,'Thacke','Loïs','1929-05-01','2122 Mallory Junction','Saint-Tite','Québec','Canada','cthacke66@eventbrite.com'),(224,'Bellino','Marie-françoise','1971-03-28','76 Reinke Place','Kitimat','British Columbia','Canada','lbellino67@dyndns.org'),(225,'Carillo','Mélia','1968-07-25','6 Sherman Court','Trois-Rivières','Québec','Canada','dcarillo68@cocolog-nifty.com'),(226,'Martindale','Östen','1958-05-15','32 Kenwood Avenue','Langenburg','Saskatchewan','Canada','amartindale69@technorati.com'),(227,'O\'Cullen','Stéphanie','1947-04-18','77 Veith Junction','Killam','Alberta','Canada','pocullen6a@ca.gov'),(228,'Lacase','Méthode','1976-07-23','586 Homewood Point','Kirkland','Québec','Canada','tlacase6b@disqus.com'),(229,'Shoebottom','Nuó','1964-11-15','09 Hayes Pass','Skatepark','Ontario','Canada','rshoebottom6c@nbcnews.com'),(230,'Fasey','Naéva','1932-10-07','4308 Boyd Terrace','Carleton-sur-Mer','Québec','Canada','tfasey6d@wikipedia.org'),(231,'Serrels','Kuí','1932-09-18','18662 Warner Parkway','Lillooet','British Columbia','Canada','mserrels6e@answers.com'),(232,'Ruben','Yú','1959-03-03','04277 Forster Parkway','Anmore','British Columbia','Canada','lruben6f@senate.gov'),(233,'Pruvost','Noémie','1931-06-19','06 Green Pass','Stratford','Ontario','Canada','mpruvost6g@xrea.com'),(234,'Sainsbury-Brown','Publicité','1941-07-28','5 Lighthouse Bay Hill','Rimouski','Québec','Canada','xsainsburybrown6h@nih.gov'),(235,'Valerius','Gösta','1960-05-02','520 Banding Drive','Jonquière','Québec','Canada','tvalerius6i@gov.uk'),(236,'Foister','Maëlys','1996-12-02','7 Karstens Street','Alma','Québec','Canada','gfoister6j@cargocollective.com'),(237,'Pedracci','Pénélope','1959-09-21','3977 Grayhawk Drive','Kirkland Lake','Ontario','Canada','apedracci6k@weebly.com'),(238,'Lyptrit','Mårten','1932-09-30','17819 Di Loreto Pass','Fredericton','New Brunswick','Canada','tlyptrit6l@topsy.com'),(239,'Kmiec','Maïly','1959-01-13','4265 Trailsway Circle','La Tuque','Québec','Canada','skmiec6m@multiply.com'),(240,'Grishanin','Cinéma','1993-05-20','7 Manufacturers Place','Fairview','Alberta','Canada','cgrishanin6n@homestead.com'),(241,'Crunkhurn','Séverine','1979-02-09','6 Mandrake Center','Lunenburg','Nova Scotia','Canada','rcrunkhurn6o@issuu.com'),(242,'Grishunin','Maïté','1994-01-01','55638 Buell Lane','Belfast','Prince Edward Island','Canada','tgrishunin6p@acquirethisname.com'),(243,'Wodeland','Cinéma','1993-12-27','21 Linden Junction','Bowen Island','British Columbia','Canada','twodeland6q@lulu.com'),(244,'Domerque','Åsa','1928-05-23','09 Almo Center','Langenburg','Saskatchewan','Canada','adomerque6r@buzzfeed.com'),(245,'Philips','Bérénice','1954-03-26','54604 Mayer Hill','Saint-Sauveur','Québec','Canada','cphilips6s@about.com'),(246,'Casazza','Loïc','1985-01-12','0352 Mariners Cove Hill','Saint-Bruno-de-Guigues','Québec','Canada','ccasazza6t@moonfruit.com'),(247,'Cargenven','Kallisté','1999-12-09','68 Maryland Place','Kimberley','British Columbia','Canada','bcargenven6u@is.gd'),(248,'Boustred','Mylène','1957-08-04','869 Lillian Hill','Raymond','Alberta','Canada','oboustred6v@amazon.de'),(249,'Puvia','Anaé','1992-12-07','4537 Canary Park','Vaudreuil-Dorion','Québec','Canada','mpuvia6w@altervista.org'),(250,'Deek','Almérinda','2003-04-15','84 Roxbury Crossing','Kamsack','Saskatchewan','Canada','tdeek6x@1und1.de'),(251,'Fellman','Tán','1978-03-30','90335 Fulton Avenue','Lethbridge','Alberta','Canada','dfellman6y@ibm.com'),(252,'Mattinson','Geneviève','1923-03-20','44 Meadow Vale Court','Saint-Jérôme','Québec','Canada','jmattinson6z@posterous.com'),(253,'Garmon','Médiamass','1980-11-13','085 Arrowood Park','Maple Ridge','British Columbia','Canada','sgarmon70@csmonitor.com'),(254,'Writer','Marie-françoise','1961-10-11','4118 Buena Vista Center','Belleville','Ontario','Canada','bwriter71@timesonline.co.uk'),(255,'Nardi','Mén','1934-12-25','0 Miller Avenue','Saint-Augustin-de-Desmaures','Québec','Canada','nnardi72@baidu.com'),(256,'Gever','Méthode','1921-08-09','8 Gina Road','Mississauga','Ontario','Canada','igever73@chronoengine.com'),(257,'Pic','Wá','2001-10-18','8 Darwin Center','Barrie','Ontario','Canada','gpic74@time.com'),(258,'Wooler','Edmée','1949-06-16','83955 Northfield Center','Baie-Comeau','Québec','Canada','awooler75@google.it'),(259,'Gockelen','Hélèna','1939-04-14','6624 Manufacturers Parkway','Thetford-Mines','Québec','Canada','pgockelen76@infoseek.co.jp'),(260,'Jachimak','Marie-noël','1924-12-21','1 Twin Pines Point','Labelle','Québec','Canada','bjachimak77@si.edu'),(261,'Swaden','Félicie','1923-11-06','9367 Homewood Lane','Kingston','Ontario','Canada','dswaden78@networksolutions.com'),(262,'Thatcham','Inès','1983-03-31','33524 Forest Run Crossing','Biggar','Saskatchewan','Canada','athatcham79@liveinternet.ru'),(263,'Culpan','Ophélie','2004-09-22','2 Northport Lane','Alberton','Prince Edward Island','Canada','rculpan7a@ibm.com'),(264,'Babin','Gösta','1967-01-05','8 Swallow Place','Pont-Rouge','Québec','Canada','rbabin7b@nba.com'),(265,'Lawey','Maëlle','1975-05-27','4 Randy Alley','Banff','Alberta','Canada','rlawey7c@house.gov'),(266,'Eckly','Loïc','1935-01-29','07766 Kropf Road','Daveluyville','Québec','Canada','geckly7d@google.ru'),(267,'Tolemache','Åsa','1975-10-02','245 Prairieview Center','Rosthern','Saskatchewan','Canada','ctolemache7e@mit.edu'),(268,'Bogeys','Lyséa','1950-09-22','182 Bunker Hill Park','Bromont','Québec','Canada','hbogeys7f@uiuc.edu'),(269,'Readwing','Maëlle','1975-10-11','56504 Colorado Junction','Chester','Nova Scotia','Canada','treadwing7g@infoseek.co.jp'),(270,'Palatino','Léa','2003-06-29','42742 Surrey Pass','Rosthern','Saskatchewan','Canada','cpalatino7h@columbia.edu'),(271,'Fullalove','Marie-françoise','1986-11-30','56573 Springview Trail','Orillia','Ontario','Canada','bfullalove7i@baidu.com'),(272,'Iskowicz','Maëlle','1957-02-04','040 American Ash Way','Matagami','Québec','Canada','riskowicz7j@about.com'),(273,'Hedney','Adélie','1992-05-01','571 Sycamore Street','Torbay','Newfoundland and Labrador','Canada','ahedney7k@cbc.ca'),(274,'Rowden','Camélia','1934-12-07','725 Green Road','Montréal','Québec','Canada','nrowden7l@irs.gov'),(275,'Halfhide','Magdalène','1993-04-02','46726 Blaine Circle','Drummondville','Québec','Canada','lhalfhide7m@nps.gov'),(276,'Fishpoole','Léandre','1952-09-09','0 Kedzie Circle','Sarnia','Ontario','Canada','lfishpoole7n@nifty.com'),(277,'Hattigan','Yáo','1997-02-23','15 Dexter Street','Casselman','Ontario','Canada','mhattigan7o@prweb.com'),(278,'Stallion','Léane','1925-03-29','2668 Stone Corner Circle','Labelle','Québec','Canada','gstallion7p@bizjournals.com'),(279,'Mussalli','Laurélie','1925-08-16','1496 Debra Plaza','Metchosin','British Columbia','Canada','emussalli7q@friendfeed.com'),(280,'Carpenter','Maï','1923-02-20','2 Monument Place','Toronto','Ontario','Canada','kcarpenter7r@networksolutions.com'),(281,'McGragh','Loïca','1956-10-18','47114 Sauthoff Avenue','Melfort','Saskatchewan','Canada','rmcgragh7s@fda.gov'),(282,'Ivamy','Lorène','1937-06-01','98 Hovde Drive','Greater Napanee','Ontario','Canada','livamy7t@dailymotion.com'),(283,'Taffie','Mahélie','1992-11-23','3951 Cordelia Alley','Daveluyville','Québec','Canada','ntaffie7u@friendfeed.com'),(284,'Chipman','Gösta','1972-07-30','3 Eagle Crest Court','Pasadena','Newfoundland and Labrador','Canada','gchipman7v@japanpost.jp'),(285,'Torrejon','Méghane','1959-02-27','6 Merrick Park','Saint-Lambert-de-Lauzon','Québec','Canada','rtorrejon7w@ucsd.edu'),(286,'Dingate','Judicaël','1976-04-18','505 Thierer Circle','Peterborough','Ontario','Canada','adingate7x@gravatar.com'),(287,'Juden','Méthode','1963-08-23','0128 Tennyson Terrace','Pemberton','British Columbia','Canada','kjuden7y@lycos.com'),(288,'Burtenshaw','Josée','2003-09-04','7494 Sage Avenue','New-Richmond','Québec','Canada','dburtenshaw7z@sitemeter.com'),(289,'Weddeburn','Véronique','1930-06-20','38584 Gerald Court','Port-Cartier','Québec','Canada','dweddeburn80@nationalgeographic.com'),(290,'Grassot','Torbjörn','1943-09-17','74 Del Mar Way','Stettler','Alberta','Canada','ggrassot81@vistaprint.com'),(291,'Crichmer','Irène','1979-03-13','9706 Thierer Crossing','Fort Erie','Ontario','Canada','ecrichmer82@vistaprint.com'),(292,'Lahiff','Marie-noël','1976-07-23','13 Fair Oaks Circle','Albanel','Québec','Canada','slahiff83@nba.com'),(293,'Latus','Véronique','1928-06-18','21 Tennessee Street','Powassan','Ontario','Canada','dlatus84@mysql.com'),(294,'Bardell','Östen','1946-05-10','94 Shasta Point','Delaware','Ontario','Canada','pbardell85@adobe.com'),(295,'Heffernon','Eugénie','1972-06-25','4 Donald Street','Vaudreuil-Dorion','Québec','Canada','kheffernon86@telegraph.co.uk'),(296,'Riley','Måns','1928-01-13','62988 Brentwood Pass','Okotoks','Alberta','Canada','ariley87@spiegel.de'),(297,'Robe','Görel','1922-06-26','30396 North Road','Windsor','Québec','Canada','wrobe88@jugem.jp'),(298,'Elt','Marie-josée','2002-05-04','49894 Old Shore Plaza','Mercier','Québec','Canada','nelt89@icq.com'),(299,'Ipsly','Kallisté','1937-12-05','5 Hermina Hill','Kitimat','British Columbia','Canada','mipsly8a@mashable.com'),(300,'Truett','Marie-hélène','1947-10-25','9966 Novick Circle','Duncan','British Columbia','Canada','struett8b@toplist.cz'),(301,'Lang','Léane','1921-04-24','6490 Fallview Lane','Lac La Biche','Alberta','Canada','ulang8c@angelfire.com'),(302,'Elger','Audréanne','1981-07-26','490 Sachs Plaza','Sparwood','British Columbia','Canada','telger8d@nsw.gov.au'),(303,'Ianniello','Daphnée','1986-02-17','994 Gina Junction','Houston','British Columbia','Canada','vianniello8e@dagondesign.com'),(304,'Hamilton','Styrbjörn','1935-06-05','8 Merry Parkway','Beauceville','Québec','Canada','shamilton8f@soup.io'),(305,'Claybourne','Sélène','1936-03-24','1824 Russell Road','Penhold','Alberta','Canada','jclaybourne8g@behance.net'),(306,'Debenham','Esbjörn','1957-09-18','3 Briar Crest Plaza','Blainville','Québec','Canada','cdebenham8h@deliciousdays.com'),(307,'De Goey','Angèle','1963-11-24','2 Dorton Place','Trail','British Columbia','Canada','kdegoey8i@mozilla.org'),(308,'McQuilliam','Rébecca','1963-11-06','26 Iowa Hill','Lorraine','Québec','Canada','cmcquilliam8j@google.cn'),(309,'Brambell','Torbjörn','1939-10-12','42 Toban Court','Midland','Ontario','Canada','abrambell8k@ebay.com'),(310,'Ride','Åslög','1928-02-01','9 Eagan Hill','Pilot Butte','Saskatchewan','Canada','aride8l@webs.com'),(311,'Ghidoli','Maïté','1937-01-09','36892 Mallory Road','Labelle','Québec','Canada','cghidoli8m@sakura.ne.jp'),(312,'McSkin','Bénédicte','1926-01-11','0 Lighthouse Bay Pass','Smiths Falls','Ontario','Canada','lmcskin8n@japanpost.jp'),(313,'Errichiello','Félicie','1982-03-03','46743 Old Gate Hill','Hope','British Columbia','Canada','cerrichiello8o@skyrock.com'),(314,'Greep','Estée','1937-04-14','35373 Mayer Junction','Aldergrove','British Columbia','Canada','sgreep8p@github.io'),(315,'July','Lén','1933-07-24','346 Prairieview Drive','Windsor','Québec','Canada','rjuly8q@moonfruit.com'),(316,'Father','Åsa','1941-09-24','2445 Mccormick Plaza','Lumby','British Columbia','Canada','hfather8r@addtoany.com'),(317,'Pettyfer','Célestine','1950-02-11','1957 Burrows Road','Manning','Alberta','Canada','spettyfer8s@jiathis.com'),(318,'Cheater','Cinéma','1996-06-12','4054 Merrick Road','Norfolk County','Ontario','Canada','bcheater8t@cloudflare.com'),(319,'Springett','Stéphanie','1936-09-01','132 Mifflin Parkway','Oromocto','New Brunswick','Canada','aspringett8u@webmd.com'),(320,'Trudgian','Stéphanie','1983-07-12','866 Lindbergh Road','Cowansville','Québec','Canada','ctrudgian8v@google.com.br'),(321,'Bellow','Maïlys','1954-03-25','87 Canary Crossing','Richmond','British Columbia','Canada','rbellow8w@alibaba.com'),(322,'Grills','Stévina','1966-07-06','8904 Monica Hill','Nackawic','New Brunswick','Canada','cgrills8x@usda.gov'),(323,'Horstead','Vénus','1941-12-20','1878 West Trail','Whitehorse','Yukon Territory','Canada','mhorstead8y@discuz.net'),(324,'Crame','Mahélie','1987-10-06','79 Dahle Place','La Ronge','Saskatchewan','Canada','gcrame8z@spotify.com'),(325,'Pauncefoot','Mélia','1954-11-07','500 Toban Point','West Kelowna','British Columbia','Canada','mpauncefoot90@dmoz.org'),(326,'McAless','Néhémie','1969-09-19','40735 Fair Oaks Point','Kamloops','British Columbia','Canada','amcaless91@histats.com'),(327,'Pasley','Loïs','1979-12-11','1 Morning Drive','Bécancour','Québec','Canada','mpasley92@google.com'),(328,'Scrace','Lèi','1947-01-11','60 Blaine Drive','Coquitlam','British Columbia','Canada','jscrace93@jiathis.com'),(329,'Downey','Solène','1929-02-12','51491 Lakewood Parkway','Côte-Saint-Luc','Québec','Canada','gdowney94@symantec.com'),(330,'Yukhnev','Åslög','1965-11-23','61071 Prentice Pass','Bay Roberts','Newfoundland and Labrador','Canada','wyukhnev95@1und1.de'),(331,'Fried','Dorothée','1929-08-31','5 Artisan Street','Chilliwack','British Columbia','Canada','cfried96@wisc.edu'),(332,'Griston','Erwéi','1974-10-10','46 Warner Alley','Pilot Butte','Saskatchewan','Canada','bgriston97@msn.com'),(333,'Milburn','Cloé','2001-01-29','76509 Buhler Road','Richibucto','New Brunswick','Canada','nmilburn98@squidoo.com'),(334,'Luggar','Kù','1966-10-27','97373 Sycamore Drive','Adstock','Québec','Canada','fluggar99@nbcnews.com'),(335,'Stirrip','Örjan','1985-03-24','35695 Steensland Street','Lac du Bonnet','Manitoba','Canada','jstirrip9a@opera.com'),(336,'Yates','Almérinda','1999-04-09','02837 Lunder Circle','Raymond','Alberta','Canada','kyates9b@zimbio.com'),(337,'Limprecht','Marlène','1941-05-25','4 Gateway Drive','Roberval','Québec','Canada','tlimprecht9c@nifty.com'),(338,'Briers','Lèi','1946-01-09','200 Crowley Road','Manning','Alberta','Canada','ibriers9d@census.gov'),(339,'Waller-Bridge','Kù','1944-02-10','03 Coolidge Center','Québec','Québec','Canada','lwallerbridge9e@squidoo.com'),(340,'Stood','Nuó','1945-07-29','001 Porter Park','Saskatoon','Saskatchewan','Canada','pstood9f@google.de'),(341,'Lafuente','Yú','1976-07-21','80116 Northland Center','Morris','Manitoba','Canada','clafuente9g@topsy.com'),(342,'Rosoni','Dù','1968-08-10','75216 Mccormick Road','Fox Creek','Alberta','Canada','arosoni9h@edublogs.org'),(343,'Boldecke','Eléa','1966-03-31','1948 Clove Way','Montréal-Ouest','Québec','Canada','oboldecke9i@netscape.com'),(344,'Fowler','Yáo','1923-01-18','28 Golf Terrace','Saint-Félicien','Québec','Canada','tfowler9j@who.int'),(345,'Lean','Danièle','1987-05-20','00642 Larry Lane','Langenburg','Saskatchewan','Canada','wlean9k@printfriendly.com'),(346,'Nutkin','Maï','1947-01-27','4733 Delladonna Avenue','Fort Erie','Ontario','Canada','bnutkin9l@dyndns.org'),(347,'Blaydes','Gaëlle','1990-12-07','80 Mccormick Place','Devon','Alberta','Canada','mblaydes9m@feedburner.com'),(348,'Shulver','Nélie','1998-08-26','1 Bonner Plaza','Pictou','Nova Scotia','Canada','lshulver9n@npr.org'),(349,'Achromov','Nélie','1963-08-23','72350 Jenifer Road','Gibsons','British Columbia','Canada','dachromov9o@w3.org'),(350,'Barrett','Célestine','1985-10-16','3 Crownhardt Junction','Sainte-Anne-des-Plaines','Québec','Canada','hbarrett9p@yandex.ru'),(351,'Wehnerr','Laïla','1948-07-22','1 Forest Run Center','Fairview','Alberta','Canada','twehnerr9q@qq.com'),(352,'Leipoldt','Andrée','1996-07-11','452 Golf Course Place','Jonquière','Québec','Canada','dleipoldt9r@reddit.com'),(353,'Duxbury','Géraldine','1933-10-24','0 Kings Terrace','Golden','British Columbia','Canada','tduxbury9s@w3.org'),(354,'Zarfai','Torbjörn','1971-03-11','92 La Follette Center','Woodstock','Ontario','Canada','mzarfai9t@wikispaces.com'),(355,'Siggens','Lyséa','1964-08-10','984 Ramsey Place','Amherst','Nova Scotia','Canada','dsiggens9u@java.com'),(356,'D\'Acth','Bénédicte','1942-12-05','57614 Kropf Road','La Broquerie','Manitoba','Canada','bdacth9v@ihg.com'),(357,'Gerrelts','Josée','1995-09-14','88455 Arrowood Place','Mississauga','Ontario','Canada','cgerrelts9w@myspace.com'),(358,'Grew','Pål','1964-07-14','22 Lake View Junction','Sainte-Anne-des-Monts','Québec','Canada','mgrew9x@bravesites.com'),(359,'Brydell','Gisèle','1939-03-14','6421 Hallows Point','Longueuil','Québec','Canada','lbrydell9y@yandex.ru'),(360,'Stammirs','Torbjörn','1990-10-13','8174 Westend Park','Devon','Alberta','Canada','rstammirs9z@ocn.ne.jp'),(361,'MacAne','Ophélie','1942-05-17','9887 Packers Lane','Lachute','Québec','Canada','bmacanea0@reference.com'),(362,'Meighan','Mélissandre','1945-02-09','010 Namekagon Hill','Bells Corners','Ontario','Canada','smeighana1@huffingtonpost.com'),(363,'Gouda','Pélagie','1983-03-12','2736 Dorton Park','Calgary','Alberta','Canada','mgoudaa2@fda.gov'),(364,'Ginley','Néhémie','1975-09-08','77332 Upham Junction','Minnedosa','Manitoba','Canada','bginleya3@xrea.com'),(365,'Polet','Aurélie','1985-05-24','22619 Glendale Avenue','Duncan','British Columbia','Canada','bpoleta4@paginegialle.it'),(366,'Cranshaw','Tán','1982-04-14','62 Sherman Street','Chambly','Québec','Canada','vcranshawa5@bbb.org'),(367,'Mariaud','Laurène','1997-10-25','85 Donald Point','Lumby','British Columbia','Canada','bmariauda6@cbslocal.com'),(368,'Gostall','Personnalisée','1925-09-19','2514 Straubel Plaza','Beaconsfield','Québec','Canada','tgostalla7@auda.org.au'),(369,'Buckenhill','Simplifiés','1981-04-07','57280 Golf View Road','Charlottetown','Prince Edward Island','Canada','mbuckenhilla8@senate.gov'),(370,'Kings','Aloïs','1943-11-04','9583 Carpenter Terrace','Duncan','British Columbia','Canada','tkingsa9@ft.com'),(371,'Tinn','Mà','1956-09-28','0336 Summerview Lane','Morris','Manitoba','Canada','ltinnaa@netvibes.com'),(372,'Culbert','Léana','1929-06-21','9232 Susan Terrace','Dauphin','Manitoba','Canada','pculbertab@topsy.com'),(373,'Sparway','Görel','1968-03-26','721 Kennedy Junction','Crossfield','Alberta','Canada','lsparwayac@earthlink.net'),(374,'Saladino','Aurélie','1933-02-11','13 Killdeer Street','Owen Sound','Ontario','Canada','gsaladinoad@nsw.gov.au'),(375,'de Villier','Alizée','1921-09-14','7 Straubel Avenue','Revelstoke','British Columbia','Canada','mdevillierae@ucoz.ru'),(376,'Cuniffe','Håkan','1956-05-21','91053 Aberg Trail','Sicamous','British Columbia','Canada','bcuniffeaf@desdev.cn'),(377,'O\'Hallihane','Angèle','1936-11-30','09038 Dottie Street','Brampton','Ontario','Canada','eohallihaneag@bandcamp.com'),(378,'Mayler','Lóng','1937-04-20','47129 Sutherland Lane','Metchosin','British Columbia','Canada','cmaylerah@nhs.uk'),(379,'Morehall','Noëlla','1994-01-30','9039 Meadow Valley Center','Matagami','Québec','Canada','emorehallai@bluehost.com'),(380,'Dollard','Eléa','1977-12-03','588 Sundown Road','Mont-Laurier','Québec','Canada','tdollardaj@businessinsider.com'),(381,'Lockart','Annotés','1953-08-27','38 Reinke Parkway','Omemee','Ontario','Canada','jlockartak@zdnet.com'),(382,'Rawstorne','Maïlys','1952-06-17','65666 Kipling Crossing','Joliette','Québec','Canada','irawstorneal@skype.com'),(383,'Shawl','Eléa','1975-07-18','5389 Mayer Plaza','Salaberry-de-Valleyfield','Québec','Canada','fshawlam@zdnet.com'),(384,'Pow','Estée','1994-07-24','43639 8th Place','Amqui','Québec','Canada','jpowan@hibu.com'),(385,'Matschke','Zoé','1951-08-09','234 Darwin Way','Pincher Creek','Alberta','Canada','mmatschkeao@indiatimes.com'),(386,'Trevna','Thérèse','1998-01-11','66618 Orin Park','Canmore','Alberta','Canada','ptrevnaap@dmoz.org'),(387,'Kierans','Léane','1947-04-26','76104 Cherokee Hill','Olds','Alberta','Canada','gkieransaq@nasa.gov'),(388,'Verson','Dorothée','1954-07-07','2 Arrowood Pass','Casselman','Ontario','Canada','vversonar@dot.gov'),(389,'Knowlson','Hélèna','1960-05-30','17332 Carey Trail','Norman Wells','Northwest Territories','Canada','gknowlsonas@google.ru'),(390,'Gatward','Göran','1968-05-09','741 Grim Place','Labelle','Québec','Canada','agatwardat@topsy.com'),(391,'Lambard','Eléa','1958-09-14','0134 Browning Avenue','Asbestos','Québec','Canada','glambardau@wordpress.org'),(392,'Standeven','Maéna','1979-08-13','2 Hoffman Hill','Sainte-Anne-des-Plaines','Québec','Canada','sstandevenav@smh.com.au'),(393,'Storror','Mélia','1983-05-25','5 Old Shore Plaza','Saint-Constant','Québec','Canada','sstorroraw@netvibes.com'),(394,'Manifould','Magdalène','1978-08-03','75 Morrow Point','North Battleford','Saskatchewan','Canada','dmanifouldax@g.co'),(395,'Ashford','Salomé','1945-09-23','1 Gale Way','Sherwood Park','Alberta','Canada','pashforday@qq.com'),(396,'Cox','Méghane','1978-06-15','0 Gina Trail','Meadow Lake','Saskatchewan','Canada','scoxaz@chronoengine.com'),(397,'Whitebrook','Françoise','2000-09-10','7427 Tennessee Way','Beloeil','Québec','Canada','kwhitebrookb0@unblog.fr'),(398,'Rollin','Lóng','1991-03-23','582 Hallows Terrace','Toronto','Ontario','Canada','hrollinb1@mac.com'),(399,'Bachman','Mélia','1939-07-26','129 Hauk Avenue','Saint-Eustache','Québec','Canada','jbachmanb2@fc2.com'),(400,'Ballance','Eliès','2001-07-15','6 Moland Crossing','Lunenburg','Nova Scotia','Canada','nballanceb3@unc.edu'),(401,'Polon','Cinéma','1949-07-25','8246 Hooker Circle','Delson','Québec','Canada','gpolonb4@nationalgeographic.com'),(402,'Nattriss','Méghane','1991-10-23','203 Onsgard Street','Lacolle','Québec','Canada','lnattrissb5@mtv.com'),(403,'Tremblot','Agnès','1921-11-23','64311 Kingsford Center','Cabano','Québec','Canada','itremblotb6@eventbrite.com'),(404,'Petcher','Åke','1947-03-31','20498 Mccormick Alley','Duncan','British Columbia','Canada','jpetcherb7@earthlink.net'),(405,'Sertin','Laïla','1939-04-14','48 Dottie Road','Keswick','Ontario','Canada','csertinb8@globo.com'),(406,'Du Fray','Wá','1981-06-03','01 Rusk Lane','Waterloo','Ontario','Canada','kdufrayb9@samsung.com'),(407,'Halliberton','Loïs','1964-02-19','832 Stephen Point','Saint-André-Avellin','Québec','Canada','khallibertonba@squarespace.com'),(408,'Pummery','Marie-hélène','1925-06-28','41 Paget Street','Langenburg','Saskatchewan','Canada','vpummerybb@ovh.net'),(409,'Feather','Léone','1981-08-12','470 Meadow Valley Park','Sainte-Marthe-sur-le-Lac','Québec','Canada','jfeatherbc@mozilla.com'),(410,'De Cruz','Yóu','1981-07-19','36 Summit Place','Carleton-sur-Mer','Québec','Canada','kdecruzbd@shareasale.com'),(411,'Teather','Björn','1979-09-02','439 Arapahoe Circle','Mont-Saint-Hilaire','Québec','Canada','rteatherbe@dailymotion.com'),(412,'Bream','Anaël','1961-12-18','0 Magdeline Plaza','Outlook','Saskatchewan','Canada','sbreambf@paginegialle.it'),(413,'Reppaport','Ophélie','1948-10-26','6304 Tennyson Point','Pierreville','Québec','Canada','kreppaportbg@dropbox.com'),(414,'Aloshkin','Régine','1968-02-12','920 Clove Parkway','Penhold','Alberta','Canada','laloshkinbh@elegantthemes.com'),(415,'Juckes','Léane','1954-02-04','57 Cardinal Junction','Québec','Québec','Canada','kjuckesbi@statcounter.com'),(416,'Seaward','Estève','1931-04-13','518 Union Court','Kamloops','British Columbia','Canada','kseawardbj@linkedin.com'),(417,'Oakenford','Anaïs','1989-05-13','76 Morrow Drive','Montague','Prince Edward Island','Canada','moakenfordbk@xinhuanet.com'),(418,'Bartoszinski','Eloïse','1997-07-11','82911 Buena Vista Road','Acton Vale','Québec','Canada','sbartoszinskibl@harvard.edu'),(419,'Liepins','Sòng','1963-02-01','8999 Rutledge Parkway','Sherwood Park','Alberta','Canada','gliepinsbm@nps.gov'),(420,'Snaddon','Géraldine','1951-06-30','06247 High Crossing Crossing','Lumby','British Columbia','Canada','tsnaddonbn@phpbb.com'),(421,'Ferencowicz','Athéna','2000-06-09','09883 Golf Road','Bromont','Québec','Canada','xferencowiczbo@ted.com'),(422,'Macrae','Lài','1948-12-01','8 Rowland Alley','Manning','Alberta','Canada','bmacraebp@imgur.com'),(423,'O\'Scandall','Andréanne','1995-01-27','121 Russell Terrace','Drayton Valley','Alberta','Canada','foscandallbq@nhs.uk'),(424,'Bottleson','Méghane','1973-11-07','2 Lake View Lane','Kirkland','Québec','Canada','abottlesonbr@ehow.com'),(425,'Attwooll','Régine','1968-10-31','17 Coleman Road','High River','Alberta','Canada','jattwoollbs@ebay.com'),(426,'Rosenvasser','Clélia','1965-03-19','9 Prairieview Park','Ferme-Neuve','Québec','Canada','grosenvasserbt@google.co.uk'),(427,'Jorissen','Joséphine','1983-08-18','08251 North Lane','Baie-Comeau','Québec','Canada','bjorissenbu@utexas.edu'),(428,'LeEstut','Desirée','1925-01-13','187 Lukken Junction','Mattawa','Ontario','Canada','vleestutbv@disqus.com'),(429,'Muris','Andréa','1952-11-20','22 Merchant Court','Les Coteaux','Québec','Canada','tmurisbw@blogspot.com'),(430,'Minigo','Cinéma','1932-12-02','5 Monterey Parkway','Winnipeg','Manitoba','Canada','cminigobx@gravatar.com'),(431,'Philpault','Ruò','1967-08-29','1 Bowman Junction','Carman','Manitoba','Canada','mphilpaultby@loc.gov'),(432,'Lochet','Thérèse','1957-02-14','262 Gerald Terrace','Lloydminster','Saskatchewan','Canada','plochetbz@usnews.com'),(433,'Janacek','Méryl','1984-03-10','95474 Drewry Terrace','Meadow Lake','Saskatchewan','Canada','djanacekc0@blogs.com'),(434,'Petford','Personnalisée','1930-03-05','9 Golf Terrace','St. Thomas','Ontario','Canada','ppetfordc1@cargocollective.com'),(435,'Alliberton','Styrbjörn','1954-01-17','4820 Ridgeview Plaza','Summerside','Prince Edward Island','Canada','gallibertonc2@linkedin.com'),(436,'Morley','Maëlys','1937-07-31','0 Helena Court','Harbour Breton','Newfoundland and Labrador','Canada','mmorleyc3@edublogs.org'),(437,'Murfett','Mårten','1938-10-21','98 Forest Run Circle','Mississauga','Ontario','Canada','jmurfettc4@fc2.com'),(438,'Knappe','Dù','2001-03-12','46171 Manitowish Parkway','Peachland','British Columbia','Canada','lknappec5@google.com.au'),(439,'Sommerlie','Maëlla','2002-09-25','5696 Donald Place','Bowen Island','British Columbia','Canada','asommerliec6@godaddy.com'),(440,'Kingswood','Laïla','1976-05-25','09 3rd Crossing','Lambton Shores','Ontario','Canada','tkingswoodc7@bbb.org'),(441,'Reams','Cléa','1987-10-19','5 Rusk Street','Marystown','Newfoundland and Labrador','Canada','ereamsc8@ted.com'),(442,'Attew','Åsa','1997-07-16','69933 Lerdahl Crossing','Assiniboia','Saskatchewan','Canada','nattewc9@gravatar.com'),(443,'Filippucci','Jú','1954-12-06','301 Miller Park','Pemberton','British Columbia','Canada','afilippuccica@slashdot.org'),(444,'Frays','Thérèsa','1931-04-15','118 6th Street','North Bay','Ontario','Canada','hfrayscb@edublogs.org'),(445,'Tingly','Chloé','1952-11-06','11031 Welch Way','La Ronge','Saskatchewan','Canada','ktinglycc@twitpic.com'),(446,'Kikke','Loïs','1952-05-30','57561 Sunfield Parkway','Vanderhoof','British Columbia','Canada','gkikkecd@stumbleupon.com'),(447,'Earles','Crééz','1973-11-06','47 Bunting Center','Kamsack','Saskatchewan','Canada','kearlesce@zdnet.com'),(448,'Sumpter','Jú','1961-12-03','4 Claremont Trail','Shediac','New Brunswick','Canada','dsumptercf@whitehouse.gov'),(449,'Bowring','Maïlis','1932-09-29','112 Florence Pass','Dauphin','Manitoba','Canada','dbowringcg@webs.com'),(450,'Scaife','Almérinda','1931-06-22','62574 Mockingbird Plaza','Farnham','Québec','Canada','tscaifech@sitemeter.com'),(451,'Jenno','Fèi','1975-05-17','918 Eggendart Trail','Port-Cartier','Québec','Canada','jjennoci@technorati.com'),(452,'Frantz','Salomé','1973-03-08','9 Hauk Place','Lanigan','Saskatchewan','Canada','afrantzcj@wsj.com'),(453,'Blessed','Zoé','1977-06-22','5196 Bluejay Drive','Arnprior','Ontario','Canada','gblessedck@infoseek.co.jp'),(454,'McGerr','Táng','1986-03-13','7024 Kedzie Circle','Beloeil','Québec','Canada','bmcgerrcl@cnbc.com'),(455,'Snarr','Marylène','1925-07-24','21450 Kim Terrace','Pembroke','Ontario','Canada','jsnarrcm@dion.ne.jp'),(456,'Vasilyev','Simplifiés','1992-09-05','392 Pepper Wood Plaza','Camrose','Alberta','Canada','tvasilyevcn@lulu.com'),(457,'Stendell','Eléonore','1922-03-29','8454 Sheridan Trail','Killam','Alberta','Canada','rstendellco@mediafire.com'),(458,'Derrington','Rachèle','1934-09-05','3330 Randy Way','Wabana','Newfoundland and Labrador','Canada','bderringtoncp@psu.edu'),(459,'Mille','André','1925-07-10','59733 Troy Parkway','Airdrie','Alberta','Canada','jmillecq@artisteer.com'),(460,'Loakes','Estée','1999-09-18','74 Dottie Road','Kapuskasing','Ontario','Canada','mloakescr@techcrunch.com'),(461,'Jardine','Célestine','2000-08-27','23121 Lakeland Hill','Catalina','Newfoundland and Labrador','Canada','gjardinecs@comcast.net'),(462,'McIlmorow','Laurène','1942-02-21','625 Orin Avenue','Fredericton','New Brunswick','Canada','kmcilmorowct@howstuffworks.com'),(463,'Zorro','Bérangère','1964-01-31','438 Redwing Plaza','Kugluktuk','Nunavut','Canada','gzorrocu@java.com'),(464,'Jervois','Maïlys','1942-01-04','211 Carioca Hill','Mont-Saint-Hilaire','Québec','Canada','zjervoiscv@nature.com'),(465,'Nisen','Loïca','1991-09-24','198 Sherman Point','Pont-Rouge','Québec','Canada','cnisencw@amazon.co.uk'),(466,'Hegarty','Åslög','1927-07-12','46 Arkansas Drive','Sicamous','British Columbia','Canada','bhegartycx@state.gov'),(467,'Pirie','Lorène','1996-03-09','8577 Waywood Trail','Clarence-Rockland','Ontario','Canada','lpiriecy@auda.org.au'),(468,'Wandrich','Gaétane','2003-08-31','91 Clemons Avenue','Albanel','Québec','Canada','rwandrichcz@uiuc.edu'),(469,'Matz','Eléonore','1963-10-09','4889 Clarendon Terrace','Aylmer','Ontario','Canada','amatzd0@newyorker.com'),(470,'Hakonsen','Judicaël','1927-03-28','9 Schmedeman Circle','Camlachie','Ontario','Canada','ahakonsend1@meetup.com'),(471,'Twells','Kù','1978-09-20','64 Florence Way','Melita','Manitoba','Canada','ltwellsd2@fc2.com'),(472,'Kezor','Björn','1928-07-22','0748 Kipling Avenue','Kingston','Ontario','Canada','mkezord3@thetimes.co.uk'),(473,'Doggart','Clémentine','1976-06-04','1482 Division Alley','Nanton','Alberta','Canada','wdoggartd4@hao123.com'),(474,'Danskine','Judicaël','2003-03-26','25064 Rockefeller Drive','Brampton','Ontario','Canada','gdanskined5@ucla.edu'),(475,'Lundon','Irène','1982-07-20','19 Clemons Plaza','Powassan','Ontario','Canada','alundond6@blogger.com'),(476,'Mulrooney','Noëlla','1968-05-27','824 Schlimgen Avenue','Prince Edward','Ontario','Canada','mmulrooneyd7@usgs.gov'),(477,'Binch','Lucrèce','1952-09-16','579 Maywood Center','Penticton','British Columbia','Canada','obinchd8@ca.gov'),(478,'Cardow','Faîtes','1999-10-20','330 Cardinal Alley','Beaverlodge','Alberta','Canada','kcardowd9@narod.ru'),(479,'Welchman','Publicité','1983-03-30','458 Evergreen Street','Mont-Laurier','Québec','Canada','awelchmanda@dailymail.co.uk'),(480,'Mackney','Dafnée','1931-07-18','81651 Sunfield Place','Armstrong','British Columbia','Canada','imackneydb@google.cn'),(481,'Rummings','Léone','1924-02-22','2 Dexter Pass','Milton','Ontario','Canada','srummingsdc@dion.ne.jp'),(482,'Jefford','Bérengère','1959-05-10','0 Bunting Plaza','Sechelt','British Columbia','Canada','gjefforddd@shutterfly.com'),(483,'Lauder','Lài','1983-04-05','7 Carioca Pass','Farnham','Québec','Canada','elauderde@gmpg.org'),(484,'Skitteral','Nélie','1940-04-26','9 Talmadge Circle','Bonnyville','Alberta','Canada','sskitteraldf@prlog.org'),(485,'Patton','Danièle','1990-03-30','3709 Doe Crossing Trail','Marystown','Newfoundland and Labrador','Canada','hpattondg@mozilla.com'),(486,'Everitt','Lucrèce','1970-08-12','6609 Main Court','Lamont','Alberta','Canada','meverittdh@chron.com'),(487,'Wortman','Erwéi','1984-12-24','68275 Lien Pass','Kingston','Ontario','Canada','gwortmandi@yellowpages.com'),(488,'Goodere','Mélissandre','1986-06-04','1076 Spenser Terrace','Dorchester','Ontario','Canada','ngooderedj@mac.com'),(489,'Georg','Styrbjörn','1944-12-29','194 Hudson Place','Langenburg','Saskatchewan','Canada','dgeorgdk@amazonaws.com'),(490,'Whartonby','Lóng','1928-01-26','887 Barby Court','Jasper Park Lodge','Alberta','Canada','dwhartonbydl@hatena.ne.jp'),(491,'Rameaux','Célia','1975-03-31','37193 Everett Center','Olds','Alberta','Canada','vrameauxdm@quantcast.com'),(492,'Arbuckle','Thérèsa','1928-09-16','166 Sommers Park','Beaumont','Alberta','Canada','larbuckledn@ow.ly'),(493,'Sykora','Personnalisée','1929-08-21','0 Superior Drive','Petawawa','Ontario','Canada','asykorado@noaa.gov'),(494,'Cowlam','Fèi','1931-09-10','1 Lakeland Road','Princeton','British Columbia','Canada','rcowlamdp@t.co'),(495,'Crewther','Célestine','1997-03-14','743 Sheridan Trail','Invermere','British Columbia','Canada','pcrewtherdq@yandex.ru'),(496,'Gautrey','Styrbjörn','1988-05-24','2 Del Mar Hill','Adstock','Québec','Canada','lgautreydr@ibm.com'),(497,'Tolan','Rachèle','1937-12-01','684 Center Court','Crossfield','Alberta','Canada','htolands@cpanel.net'),(498,'Connaughton','Rachèle','1949-02-01','66419 Texas Parkway','Roberval','Québec','Canada','pconnaughtondt@bbc.co.uk'),(499,'Lenaghen','Pò','1937-06-02','77705 Farmco Avenue','Saint-Félicien','Québec','Canada','klenaghendu@photobucket.com'),(500,'Peirce','Lucrèce','1991-09-19','78 Duke Drive','Lac-Brome','Québec','Canada','gpeircedv@oaic.gov.au');
/*!40000 ALTER TABLE `athletes` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `epreuves_types`
--

DROP TABLE IF EXISTS `epreuves_types`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `epreuves_types` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `description` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `epreuves_types`
--

LOCK TABLES `epreuves_types` WRITE;
/*!40000 ALTER TABLE `epreuves_types` DISABLE KEYS */;
INSERT INTO `epreuves_types` VALUES (1,'5 kilomètres'),(2,'10 kilomètres'),(3,'Demi-marathon'),(4,'Marathon');
/*!40000 ALTER TABLE `epreuves_types` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `evenements`
--

DROP TABLE IF EXISTS `evenements`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `evenements` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `nom` varchar(100) COLLATE utf8mb4_general_ci NOT NULL,
  `date_debut` date DEFAULT NULL,
  `date_fin` date DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `evenements`
--

LOCK TABLES `evenements` WRITE;
/*!40000 ALTER TABLE `evenements` DISABLE KEYS */;
INSERT INTO `evenements` VALUES (1,'Marathon des forêts 2020','2020-07-21','2020-07-21'),(2,'Courses des micro-brasseries','2019-07-14','2019-07-14'),(3,'Courses des micro-brasseries','2020-07-20','2020-07-20'),(4,'Demi-marathon des glaces','2021-03-11','2021-03-16');
/*!40000 ALTER TABLE `evenements` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `resultats`
--

DROP TABLE IF EXISTS `resultats`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `resultats` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `athlete_id` int(11) NOT NULL,
  `epreuve_type_id` int(11) NOT NULL,
  `date_resultat` date NOT NULL,
  `resultat_ms` int(11) NOT NULL,
  `evenement_id` int(11) NOT NULL,
  `cree_par` int(11) DEFAULT NULL,
  `modifie_par` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=913 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `resultats`
--

LOCK TABLES `resultats` WRITE;
/*!40000 ALTER TABLE `resultats` DISABLE KEYS */;
INSERT INTO `resultats` VALUES (1,475,1,'2020-07-21',2411456,1,NULL,NULL),(2,16,1,'2020-07-21',2393323,1,NULL,NULL),(3,58,1,'2020-07-21',816167,1,NULL,NULL),(4,128,1,'2020-07-21',2979586,1,NULL,NULL),(5,103,1,'2020-07-21',2038545,1,NULL,NULL),(6,260,1,'2020-07-21',922303,1,NULL,NULL),(7,107,1,'2020-07-21',1580882,1,NULL,NULL),(8,125,1,'2020-07-21',2501148,1,NULL,NULL),(9,170,1,'2020-07-21',913244,1,NULL,NULL),(10,377,1,'2020-07-21',1529499,1,NULL,NULL),(11,107,1,'2020-07-21',878106,1,NULL,NULL),(12,267,1,'2020-07-21',1995742,1,NULL,NULL),(13,198,1,'2020-07-21',2428164,1,NULL,NULL),(14,317,1,'2020-07-21',1106199,1,NULL,NULL),(15,213,1,'2020-07-21',2191564,1,NULL,NULL),(16,167,1,'2020-07-21',2247922,1,NULL,NULL),(17,429,1,'2020-07-21',2195755,1,NULL,NULL),(18,43,1,'2020-07-21',2360302,1,NULL,NULL),(19,276,1,'2020-07-21',2696037,1,NULL,NULL),(20,123,1,'2020-07-21',2037179,1,NULL,NULL),(21,268,1,'2020-07-21',3031051,1,NULL,NULL),(22,11,1,'2020-07-21',2334417,1,NULL,NULL),(23,283,1,'2020-07-21',1128539,1,NULL,NULL),(24,315,1,'2020-07-21',1151107,1,NULL,NULL),(25,92,1,'2020-07-21',2399562,1,NULL,NULL),(26,60,1,'2020-07-21',2535144,1,NULL,NULL),(27,170,1,'2020-07-21',849911,1,NULL,NULL),(28,47,1,'2020-07-21',1231465,1,NULL,NULL),(29,494,1,'2020-07-21',2063797,1,NULL,NULL),(30,277,1,'2020-07-21',1555802,1,NULL,NULL),(31,125,1,'2020-07-21',1397039,1,NULL,NULL),(32,469,1,'2020-07-21',3232904,1,NULL,NULL),(33,54,1,'2020-07-21',1164450,1,NULL,NULL),(34,415,1,'2020-07-21',3164138,1,NULL,NULL),(35,325,1,'2020-07-21',2631208,1,NULL,NULL),(36,414,1,'2020-07-21',2600221,1,NULL,NULL),(37,394,1,'2020-07-21',3164272,1,NULL,NULL),(38,80,1,'2020-07-21',2894588,1,NULL,NULL),(39,485,1,'2020-07-21',1826053,1,NULL,NULL),(40,415,1,'2020-07-21',2709377,1,NULL,NULL),(41,193,1,'2020-07-21',1757270,1,NULL,NULL),(42,44,1,'2020-07-21',1576050,1,NULL,NULL),(43,279,1,'2020-07-21',1703198,1,NULL,NULL),(44,379,1,'2020-07-21',1949584,1,NULL,NULL),(45,270,1,'2020-07-21',1271178,1,NULL,NULL),(46,466,1,'2020-07-21',2148692,1,NULL,NULL),(47,71,1,'2020-07-21',1096175,1,NULL,NULL),(48,394,1,'2020-07-21',1361664,1,NULL,NULL),(49,310,1,'2020-07-21',1073503,1,NULL,NULL),(50,206,1,'2020-07-21',1770047,1,NULL,NULL),(51,418,1,'2020-07-21',2574389,1,NULL,NULL),(52,87,1,'2020-07-21',2854399,1,NULL,NULL),(53,174,1,'2020-07-21',2175878,1,NULL,NULL),(54,43,1,'2020-07-21',2725704,1,NULL,NULL),(55,388,1,'2020-07-21',2201475,1,NULL,NULL),(56,404,1,'2020-07-21',1036469,1,NULL,NULL),(57,283,1,'2020-07-21',1669686,1,NULL,NULL),(58,179,1,'2020-07-21',1786540,1,NULL,NULL),(59,110,1,'2020-07-21',909881,1,NULL,NULL),(60,25,1,'2020-07-21',2255011,1,NULL,NULL),(61,387,1,'2020-07-21',840583,1,NULL,NULL),(62,382,1,'2020-07-21',923002,1,NULL,NULL),(63,11,1,'2020-07-21',1523908,1,NULL,NULL),(64,485,1,'2020-07-21',1822322,1,NULL,NULL),(65,389,1,'2020-07-21',1312227,1,NULL,NULL),(66,40,1,'2020-07-21',1839834,1,NULL,NULL),(67,204,1,'2020-07-21',2985312,1,NULL,NULL),(68,66,1,'2020-07-21',1798092,1,NULL,NULL),(69,65,1,'2020-07-21',2438826,1,NULL,NULL),(70,482,1,'2020-07-21',2399479,1,NULL,NULL),(71,100,1,'2020-07-21',2110897,1,NULL,NULL),(72,142,1,'2020-07-21',1350405,1,NULL,NULL),(73,444,1,'2020-07-21',2651175,1,NULL,NULL),(74,213,1,'2020-07-21',1842423,1,NULL,NULL),(75,414,1,'2020-07-21',1220379,1,NULL,NULL),(76,46,1,'2020-07-21',1686198,1,NULL,NULL),(77,124,1,'2020-07-21',1852365,1,NULL,NULL),(78,59,1,'2020-07-21',3111977,1,NULL,NULL),(79,206,1,'2020-07-21',912733,1,NULL,NULL),(80,454,1,'2020-07-21',3207102,1,NULL,NULL),(81,450,1,'2020-07-21',1911499,1,NULL,NULL),(82,368,1,'2020-07-21',2214732,1,NULL,NULL),(83,215,1,'2020-07-21',2093588,1,NULL,NULL),(84,220,1,'2020-07-21',1744454,1,NULL,NULL),(85,63,1,'2020-07-21',3039772,1,NULL,NULL),(86,396,1,'2020-07-21',1367890,1,NULL,NULL),(87,78,1,'2020-07-21',2003282,1,NULL,NULL),(88,56,1,'2020-07-21',2707294,1,NULL,NULL),(89,274,1,'2020-07-21',1976665,1,NULL,NULL),(90,7,1,'2020-07-21',1943490,1,NULL,NULL),(91,22,1,'2020-07-21',1078724,1,NULL,NULL),(92,435,1,'2020-07-21',2559798,1,NULL,NULL),(93,101,1,'2020-07-21',2754124,1,NULL,NULL),(94,119,1,'2020-07-21',1425540,1,NULL,NULL),(95,436,1,'2020-07-21',3228950,1,NULL,NULL),(96,183,1,'2020-07-21',2663489,1,NULL,NULL),(97,156,1,'2020-07-21',1902179,1,NULL,NULL),(98,142,1,'2020-07-21',1619576,1,NULL,NULL),(99,387,1,'2020-07-21',3196657,1,NULL,NULL),(100,90,1,'2020-07-21',2348869,1,NULL,NULL),(101,13,1,'2020-07-21',788757,1,NULL,NULL),(102,103,1,'2020-07-21',3166815,1,NULL,NULL),(103,341,1,'2020-07-21',3115082,1,NULL,NULL),(104,430,1,'2020-07-21',1872835,1,NULL,NULL),(105,68,1,'2020-07-21',1899583,1,NULL,NULL),(106,379,1,'2020-07-21',2570684,1,NULL,NULL),(107,233,1,'2020-07-21',2252021,1,NULL,NULL),(108,444,1,'2020-07-21',2284545,1,NULL,NULL),(109,180,1,'2020-07-21',2247315,1,NULL,NULL),(110,167,1,'2020-07-21',1358318,1,NULL,NULL),(111,218,1,'2020-07-21',2459616,1,NULL,NULL),(112,457,1,'2020-07-21',1110682,1,NULL,NULL),(113,347,1,'2020-07-21',2962840,1,NULL,NULL),(114,302,1,'2020-07-21',967407,1,NULL,NULL),(115,256,1,'2020-07-21',2401923,1,NULL,NULL),(116,239,1,'2020-07-21',1403659,1,NULL,NULL),(117,326,1,'2020-07-21',1290224,1,NULL,NULL),(118,384,1,'2020-07-21',956528,1,NULL,NULL),(119,61,1,'2020-07-21',3248855,1,NULL,NULL),(120,316,1,'2020-07-21',1938795,1,NULL,NULL),(121,481,1,'2020-07-21',1816684,1,NULL,NULL),(122,497,1,'2020-07-21',2729822,1,NULL,NULL),(123,360,1,'2020-07-21',1581276,1,NULL,NULL),(124,124,1,'2020-07-21',3063274,1,NULL,NULL),(125,11,1,'2020-07-21',1565998,1,NULL,NULL),(126,393,1,'2020-07-21',2785334,1,NULL,NULL),(127,221,1,'2020-07-21',2866646,1,NULL,NULL),(128,242,1,'2020-07-21',2434272,1,NULL,NULL),(129,355,1,'2020-07-21',1692649,1,NULL,NULL),(130,63,1,'2020-07-21',3273494,1,NULL,NULL),(131,25,1,'2020-07-21',1546798,1,NULL,NULL),(132,338,1,'2020-07-21',2793452,1,NULL,NULL),(133,97,1,'2020-07-21',1834536,1,NULL,NULL),(134,257,1,'2020-07-21',2236384,1,NULL,NULL),(135,336,1,'2020-07-21',2485385,1,NULL,NULL),(136,359,1,'2020-07-21',2132205,1,NULL,NULL),(137,43,1,'2020-07-21',2178585,1,NULL,NULL),(138,173,1,'2020-07-21',2497992,1,NULL,NULL),(139,35,1,'2020-07-21',1689749,1,NULL,NULL),(140,278,1,'2020-07-21',1266216,1,NULL,NULL),(141,6,1,'2020-07-21',2313027,1,NULL,NULL),(142,23,1,'2020-07-21',1218412,1,NULL,NULL),(143,23,1,'2020-07-21',2030790,1,NULL,NULL),(144,390,1,'2020-07-21',3007920,1,NULL,NULL),(145,483,1,'2020-07-21',929407,1,NULL,NULL),(146,347,1,'2020-07-21',2015939,1,NULL,NULL),(147,12,1,'2020-07-21',1281976,1,NULL,NULL),(148,393,1,'2020-07-21',1160389,1,NULL,NULL),(149,207,1,'2020-07-21',1117345,1,NULL,NULL),(150,148,1,'2020-07-21',2634337,1,NULL,NULL),(151,320,1,'2020-07-21',2189129,1,NULL,NULL),(152,468,1,'2020-07-21',1979362,1,NULL,NULL),(153,143,1,'2020-07-21',2258143,1,NULL,NULL),(154,446,1,'2020-07-21',2110550,1,NULL,NULL),(155,220,1,'2020-07-21',2033065,1,NULL,NULL),(156,433,1,'2020-07-21',2452019,1,NULL,NULL),(157,111,1,'2020-07-21',2515857,1,NULL,NULL),(158,85,1,'2020-07-21',1731191,1,NULL,NULL),(159,419,1,'2020-07-21',1230371,1,NULL,NULL),(160,384,1,'2020-07-21',2057660,1,NULL,NULL),(161,169,1,'2020-07-21',2799107,1,NULL,NULL),(162,322,1,'2020-07-21',2585782,1,NULL,NULL),(163,203,1,'2020-07-21',2394711,1,NULL,NULL),(164,52,1,'2020-07-21',1508222,1,NULL,NULL),(165,67,1,'2020-07-21',2896523,1,NULL,NULL),(166,39,1,'2020-07-21',828352,1,NULL,NULL),(167,40,1,'2020-07-21',2674638,1,NULL,NULL),(168,446,1,'2020-07-21',3189875,1,NULL,NULL),(169,425,1,'2020-07-21',3259456,1,NULL,NULL),(170,56,1,'2020-07-21',2275825,1,NULL,NULL),(171,154,1,'2020-07-21',1342553,1,NULL,NULL),(172,404,1,'2020-07-21',1025147,1,NULL,NULL),(173,154,1,'2020-07-21',2343044,1,NULL,NULL),(174,463,1,'2020-07-21',3135602,1,NULL,NULL),(175,309,1,'2020-07-21',857194,1,NULL,NULL),(176,310,1,'2020-07-21',2727857,1,NULL,NULL),(177,115,1,'2020-07-21',1622439,1,NULL,NULL),(178,154,1,'2020-07-21',1093097,1,NULL,NULL),(179,446,1,'2020-07-21',2362584,1,NULL,NULL),(180,341,1,'2020-07-21',2658920,1,NULL,NULL),(181,467,1,'2020-07-21',2647065,1,NULL,NULL),(182,367,1,'2020-07-21',3137062,1,NULL,NULL),(183,207,1,'2020-07-21',1654632,1,NULL,NULL),(184,239,1,'2020-07-21',2143773,1,NULL,NULL),(185,139,1,'2020-07-21',1439220,1,NULL,NULL),(186,445,1,'2020-07-21',1657989,1,NULL,NULL),(187,348,1,'2020-07-21',2242243,1,NULL,NULL),(188,493,1,'2020-07-21',1115417,1,NULL,NULL),(189,163,1,'2020-07-21',2784366,1,NULL,NULL),(190,428,1,'2020-07-21',2218968,1,NULL,NULL),(191,91,1,'2020-07-21',3094253,1,NULL,NULL),(192,193,1,'2020-07-21',2493634,1,NULL,NULL),(193,91,1,'2020-07-21',3125703,1,NULL,NULL),(194,316,1,'2020-07-21',2743953,1,NULL,NULL),(195,266,1,'2020-07-21',1137284,1,NULL,NULL),(196,37,1,'2020-07-21',3201117,1,NULL,NULL),(197,403,1,'2020-07-21',1413523,1,NULL,NULL),(198,452,1,'2020-07-21',2826082,1,NULL,NULL),(199,367,1,'2020-07-21',2457517,1,NULL,NULL),(200,62,1,'2020-07-21',2803044,1,NULL,NULL),(201,47,1,'2019-07-14',1299459,2,NULL,NULL),(202,266,1,'2019-07-14',1093115,2,NULL,NULL),(203,484,1,'2019-07-14',954091,2,NULL,NULL),(204,152,1,'2019-07-14',1039266,2,NULL,NULL),(205,442,1,'2019-07-14',1184365,2,NULL,NULL),(206,387,1,'2019-07-14',1971314,2,NULL,NULL),(207,11,1,'2019-07-14',1499285,2,NULL,NULL),(208,481,1,'2019-07-14',2385105,2,NULL,NULL),(209,77,1,'2019-07-14',868185,2,NULL,NULL),(210,311,1,'2019-07-14',2778485,2,NULL,NULL),(211,266,1,'2019-07-14',1639109,2,NULL,NULL),(212,376,1,'2019-07-14',1966349,2,NULL,NULL),(213,330,1,'2019-07-14',3060080,2,NULL,NULL),(214,219,1,'2019-07-14',2971702,2,NULL,NULL),(215,276,1,'2019-07-14',3205515,2,NULL,NULL),(216,276,1,'2019-07-14',1234523,2,NULL,NULL),(217,273,1,'2019-07-14',1039342,2,NULL,NULL),(218,145,1,'2019-07-14',837156,2,NULL,NULL),(219,124,1,'2019-07-14',2645860,2,NULL,NULL),(220,91,1,'2019-07-14',1383945,2,NULL,NULL),(221,119,1,'2019-07-14',3226353,2,NULL,NULL),(222,353,1,'2019-07-14',3057991,2,NULL,NULL),(223,179,1,'2019-07-14',1821471,2,NULL,NULL),(224,230,1,'2019-07-14',2700371,2,NULL,NULL),(225,279,1,'2019-07-14',1813447,2,NULL,NULL),(226,124,1,'2019-07-14',2870422,2,NULL,NULL),(227,309,1,'2019-07-14',1495976,2,NULL,NULL),(228,90,1,'2019-07-14',1299706,2,NULL,NULL),(229,425,1,'2019-07-14',2616069,2,NULL,NULL),(230,71,1,'2019-07-14',2439115,2,NULL,NULL),(231,206,1,'2019-07-14',1283672,2,NULL,NULL),(232,127,1,'2019-07-14',1166498,2,NULL,NULL),(233,139,1,'2019-07-14',2230244,2,NULL,NULL),(234,388,1,'2019-07-14',1849654,2,NULL,NULL),(235,451,1,'2019-07-14',2853195,2,NULL,NULL),(236,240,1,'2019-07-14',1745603,2,NULL,NULL),(237,7,1,'2019-07-14',1815493,2,NULL,NULL),(238,374,1,'2019-07-14',2722650,2,NULL,NULL),(239,179,1,'2019-07-14',2676780,2,NULL,NULL),(240,137,1,'2019-07-14',2402144,2,NULL,NULL),(241,366,1,'2019-07-14',3207772,2,NULL,NULL),(242,382,1,'2019-07-14',1097079,2,NULL,NULL),(243,467,1,'2019-07-14',2492471,2,NULL,NULL),(244,481,1,'2019-07-14',1166981,2,NULL,NULL),(245,11,1,'2019-07-14',2087615,2,NULL,NULL),(246,121,1,'2019-07-14',2452011,2,NULL,NULL),(247,205,1,'2019-07-14',1169230,2,NULL,NULL),(248,393,1,'2019-07-14',1228331,2,NULL,NULL),(249,274,1,'2019-07-14',2241710,2,NULL,NULL),(250,454,1,'2019-07-14',1467429,2,NULL,NULL),(251,358,1,'2019-07-14',1661915,2,NULL,NULL),(252,299,1,'2019-07-14',3109038,2,NULL,NULL),(253,422,1,'2019-07-14',2416208,2,NULL,NULL),(254,128,1,'2019-07-14',3293476,2,NULL,NULL),(255,140,1,'2019-07-14',2835887,2,NULL,NULL),(256,303,1,'2019-07-14',1779892,2,NULL,NULL),(257,310,1,'2019-07-14',3078628,2,NULL,NULL),(258,421,1,'2019-07-14',2697384,2,NULL,NULL),(259,19,1,'2019-07-14',3122723,2,NULL,NULL),(260,177,1,'2019-07-14',2239827,2,NULL,NULL),(261,61,1,'2019-07-14',1874128,2,NULL,NULL),(262,356,1,'2019-07-14',3237684,2,NULL,NULL),(263,168,1,'2019-07-14',1340954,2,NULL,NULL),(264,389,1,'2019-07-14',927285,2,NULL,NULL),(265,344,1,'2019-07-14',3296251,2,NULL,NULL),(266,155,1,'2019-07-14',2405352,2,NULL,NULL),(267,20,1,'2019-07-14',1890356,2,NULL,NULL),(268,299,1,'2019-07-14',1035387,2,NULL,NULL),(269,199,1,'2019-07-14',1579495,2,NULL,NULL),(270,39,1,'2019-07-14',2468806,2,NULL,NULL),(271,472,1,'2019-07-14',1241587,2,NULL,NULL),(272,391,1,'2019-07-14',1887253,2,NULL,NULL),(273,446,1,'2019-07-14',2375979,2,NULL,NULL),(274,355,1,'2019-07-14',1515232,2,NULL,NULL),(275,107,1,'2019-07-14',1885909,2,NULL,NULL),(276,473,1,'2019-07-14',2603082,2,NULL,NULL),(277,128,1,'2019-07-14',1511501,2,NULL,NULL),(278,400,1,'2019-07-14',982875,2,NULL,NULL),(279,336,1,'2019-07-14',1716377,2,NULL,NULL),(280,333,1,'2019-07-14',2978317,2,NULL,NULL),(281,38,1,'2019-07-14',1276522,2,NULL,NULL),(282,244,1,'2019-07-14',3156887,2,NULL,NULL),(283,420,1,'2019-07-14',2662553,2,NULL,NULL),(284,341,1,'2019-07-14',2185773,2,NULL,NULL),(285,226,1,'2019-07-14',2931139,2,NULL,NULL),(286,128,1,'2019-07-14',2622920,2,NULL,NULL),(287,458,1,'2019-07-14',1061094,2,NULL,NULL),(288,29,1,'2019-07-14',1736413,2,NULL,NULL),(289,243,1,'2019-07-14',3298866,2,NULL,NULL),(290,462,1,'2019-07-14',2535820,2,NULL,NULL),(291,102,1,'2019-07-14',1306224,2,NULL,NULL),(292,416,1,'2019-07-14',1030834,2,NULL,NULL),(293,206,1,'2019-07-14',1885702,2,NULL,NULL),(294,72,1,'2019-07-14',2543335,2,NULL,NULL),(295,1,1,'2019-07-14',1705524,2,NULL,NULL),(296,286,1,'2019-07-14',2206381,2,NULL,NULL),(297,450,1,'2019-07-14',2891558,2,NULL,NULL),(298,53,1,'2019-07-14',2211935,2,NULL,NULL),(299,337,1,'2019-07-14',1709406,2,NULL,NULL),(300,67,1,'2019-07-14',1809362,2,NULL,NULL),(301,379,1,'2019-07-14',1038871,2,NULL,NULL),(302,91,1,'2019-07-14',2109030,2,NULL,NULL),(303,164,1,'2019-07-14',2968913,2,NULL,NULL),(304,180,1,'2019-07-14',2999168,2,NULL,NULL),(305,41,1,'2019-07-14',1364730,2,NULL,NULL),(306,142,1,'2019-07-14',3299737,2,NULL,NULL),(307,314,1,'2019-07-14',2319295,2,NULL,NULL),(308,30,1,'2019-07-14',905585,2,NULL,NULL),(309,17,1,'2019-07-14',1565903,2,NULL,NULL),(310,271,1,'2019-07-14',2426455,2,NULL,NULL),(311,173,1,'2019-07-14',3026494,2,NULL,NULL),(312,296,1,'2019-07-14',2514392,2,NULL,NULL),(313,314,1,'2019-07-14',2981809,2,NULL,NULL),(314,496,1,'2019-07-14',2478418,2,NULL,NULL),(315,437,1,'2019-07-14',1276770,2,NULL,NULL),(316,133,1,'2019-07-14',2158999,2,NULL,NULL),(317,270,1,'2019-07-14',2779742,2,NULL,NULL),(318,16,1,'2019-07-14',2832059,2,NULL,NULL),(319,11,1,'2019-07-14',1500312,2,NULL,NULL),(320,367,1,'2019-07-14',1858382,2,NULL,NULL),(321,263,1,'2019-07-14',2794702,2,NULL,NULL),(322,304,1,'2019-07-14',1623379,2,NULL,NULL),(323,280,1,'2019-07-14',3004088,2,NULL,NULL),(324,419,1,'2019-07-14',2422384,2,NULL,NULL),(325,360,1,'2019-07-14',1094459,2,NULL,NULL),(326,255,1,'2019-07-14',2046712,2,NULL,NULL),(327,393,1,'2019-07-14',1484295,2,NULL,NULL),(328,380,1,'2019-07-14',1232523,2,NULL,NULL),(329,228,1,'2019-07-14',1700751,2,NULL,NULL),(330,35,1,'2019-07-14',1159191,2,NULL,NULL),(331,440,1,'2019-07-14',1678558,2,NULL,NULL),(332,45,1,'2019-07-14',1157110,2,NULL,NULL),(333,181,1,'2019-07-14',1857245,2,NULL,NULL),(334,215,1,'2019-07-14',1108936,2,NULL,NULL),(335,307,1,'2019-07-14',2349715,2,NULL,NULL),(336,76,1,'2019-07-14',2815024,2,NULL,NULL),(337,18,1,'2019-07-14',1740326,2,NULL,NULL),(338,105,1,'2019-07-14',981871,2,NULL,NULL),(339,405,1,'2019-07-14',1434355,2,NULL,NULL),(340,384,1,'2019-07-14',2584759,2,NULL,NULL),(341,425,1,'2019-07-14',1070972,2,NULL,NULL),(342,173,1,'2019-07-14',2427622,2,NULL,NULL),(343,462,1,'2019-07-14',2221185,2,NULL,NULL),(344,426,1,'2019-07-14',1618272,2,NULL,NULL),(345,355,1,'2019-07-14',1021388,2,NULL,NULL),(346,418,1,'2019-07-14',1084395,2,NULL,NULL),(347,17,1,'2019-07-14',2475072,2,NULL,NULL),(348,205,1,'2019-07-14',882882,2,NULL,NULL),(349,475,1,'2019-07-14',1861144,2,NULL,NULL),(350,212,1,'2019-07-14',2056774,2,NULL,NULL),(351,109,1,'2019-07-14',960073,2,NULL,NULL),(352,331,1,'2019-07-14',1733993,2,NULL,NULL),(353,133,1,'2019-07-14',1668545,2,NULL,NULL),(354,342,1,'2019-07-14',2847590,2,NULL,NULL),(355,218,1,'2019-07-14',2168267,2,NULL,NULL),(356,104,1,'2019-07-14',3297467,2,NULL,NULL),(357,408,1,'2019-07-14',1703898,2,NULL,NULL),(358,407,1,'2019-07-14',1986923,2,NULL,NULL),(359,131,1,'2019-07-14',3076727,2,NULL,NULL),(360,202,1,'2019-07-14',2587739,2,NULL,NULL),(361,408,1,'2019-07-14',1694697,2,NULL,NULL),(362,490,1,'2019-07-14',2008601,2,NULL,NULL),(363,231,1,'2019-07-14',1320636,2,NULL,NULL),(364,305,1,'2019-07-14',2647604,2,NULL,NULL),(365,135,1,'2019-07-14',1451622,2,NULL,NULL),(366,128,1,'2019-07-14',1022794,2,NULL,NULL),(367,155,1,'2019-07-14',2185376,2,NULL,NULL),(368,54,1,'2019-07-14',1448500,2,NULL,NULL),(369,33,1,'2019-07-14',1917949,2,NULL,NULL),(370,352,1,'2019-07-14',3249374,2,NULL,NULL),(371,349,1,'2019-07-14',1875292,2,NULL,NULL),(372,355,1,'2019-07-14',1106602,2,NULL,NULL),(373,28,1,'2019-07-14',3058738,2,NULL,NULL),(374,282,1,'2019-07-14',1095085,2,NULL,NULL),(375,304,1,'2019-07-14',2054188,2,NULL,NULL),(376,75,1,'2019-07-14',2032347,2,NULL,NULL),(377,12,1,'2019-07-14',3051930,2,NULL,NULL),(378,393,1,'2019-07-14',2596521,2,NULL,NULL),(379,177,1,'2019-07-14',1349054,2,NULL,NULL),(380,230,1,'2019-07-14',1526804,2,NULL,NULL),(381,75,1,'2019-07-14',2893243,2,NULL,NULL),(382,211,1,'2019-07-14',2153879,2,NULL,NULL),(383,289,1,'2019-07-14',933695,2,NULL,NULL),(384,205,1,'2019-07-14',1180528,2,NULL,NULL),(385,478,1,'2019-07-14',2493231,2,NULL,NULL),(386,132,1,'2019-07-14',2684455,2,NULL,NULL),(387,43,1,'2019-07-14',1063221,2,NULL,NULL),(388,14,1,'2019-07-14',1852575,2,NULL,NULL),(389,430,1,'2019-07-14',1604748,2,NULL,NULL),(390,96,1,'2019-07-14',1500851,2,NULL,NULL),(391,392,1,'2019-07-14',2968590,2,NULL,NULL),(392,281,1,'2019-07-14',1807697,2,NULL,NULL),(393,27,1,'2019-07-14',3163734,2,NULL,NULL),(394,206,1,'2019-07-14',2464188,2,NULL,NULL),(395,272,1,'2019-07-14',2899634,2,NULL,NULL),(396,72,1,'2019-07-14',1529537,2,NULL,NULL),(397,493,1,'2019-07-14',2352579,2,NULL,NULL),(398,154,1,'2019-07-14',2762056,2,NULL,NULL),(399,44,1,'2019-07-14',1428529,2,NULL,NULL),(400,276,1,'2019-07-14',1745530,2,NULL,NULL),(401,66,2,'2019-07-14',2505980,2,NULL,NULL),(402,178,2,'2019-07-14',2314448,2,NULL,NULL),(403,130,2,'2019-07-14',4363363,2,NULL,NULL),(404,114,2,'2019-07-14',3289322,2,NULL,NULL),(405,22,2,'2019-07-14',3110766,2,NULL,NULL),(406,69,2,'2019-07-14',3557945,2,NULL,NULL),(407,262,2,'2019-07-14',2897365,2,NULL,NULL),(408,311,2,'2019-07-14',4224619,2,NULL,NULL),(409,363,2,'2019-07-14',6527889,2,NULL,NULL),(410,72,2,'2019-07-14',5591629,2,NULL,NULL),(411,329,2,'2019-07-14',6126280,2,NULL,NULL),(412,151,2,'2019-07-14',1959922,2,NULL,NULL),(413,355,2,'2019-07-14',6451089,2,NULL,NULL),(414,202,2,'2019-07-14',2498857,2,NULL,NULL),(415,287,2,'2019-07-14',4094703,2,NULL,NULL),(416,209,2,'2019-07-14',4250090,2,NULL,NULL),(417,31,2,'2019-07-14',5574659,2,NULL,NULL),(418,407,2,'2019-07-14',5092170,2,NULL,NULL),(419,218,2,'2019-07-14',5332541,2,NULL,NULL),(420,286,2,'2019-07-14',3310891,2,NULL,NULL),(421,299,2,'2019-07-14',5264235,2,NULL,NULL),(422,370,2,'2019-07-14',2636239,2,NULL,NULL),(423,174,2,'2019-07-14',2739242,2,NULL,NULL),(424,175,2,'2019-07-14',2514254,2,NULL,NULL),(425,70,2,'2019-07-14',5565802,2,NULL,NULL),(426,118,2,'2019-07-14',7154164,2,NULL,NULL),(427,2,2,'2019-07-14',5689399,2,NULL,NULL),(428,382,2,'2019-07-14',4050449,2,NULL,NULL),(429,432,2,'2019-07-14',5518233,2,NULL,NULL),(430,200,2,'2019-07-14',7081975,2,NULL,NULL),(431,191,2,'2019-07-14',6724986,2,NULL,NULL),(432,313,2,'2019-07-14',4894030,2,NULL,NULL),(433,24,2,'2019-07-14',4245671,2,NULL,NULL),(434,93,2,'2019-07-14',3574234,2,NULL,NULL),(435,460,2,'2019-07-14',6191295,2,NULL,NULL),(436,440,2,'2019-07-14',3595776,2,NULL,NULL),(437,316,2,'2019-07-14',5705380,2,NULL,NULL),(438,351,2,'2019-07-14',5947141,2,NULL,NULL),(439,267,2,'2019-07-14',6466140,2,NULL,NULL),(440,73,2,'2019-07-14',5451637,2,NULL,NULL),(441,334,2,'2019-07-14',3768749,2,NULL,NULL),(442,375,2,'2019-07-14',4197468,2,NULL,NULL),(443,197,2,'2019-07-14',5999347,2,NULL,NULL),(444,27,2,'2019-07-14',4096354,2,NULL,NULL),(445,199,2,'2019-07-14',2749948,2,NULL,NULL),(446,239,2,'2019-07-14',6604293,2,NULL,NULL),(447,70,2,'2019-07-14',6047742,2,NULL,NULL),(448,479,2,'2019-07-14',4007089,2,NULL,NULL),(449,93,2,'2019-07-14',2185817,2,NULL,NULL),(450,224,2,'2019-07-14',4784064,2,NULL,NULL),(451,187,2,'2019-07-14',2697010,2,NULL,NULL),(452,256,2,'2019-07-14',3741175,2,NULL,NULL),(453,60,2,'2019-07-14',3893826,2,NULL,NULL),(454,136,2,'2019-07-14',2942255,2,NULL,NULL),(455,438,2,'2019-07-14',6181883,2,NULL,NULL),(456,478,2,'2019-07-14',2558143,2,NULL,NULL),(457,206,2,'2019-07-14',3133672,2,NULL,NULL),(458,62,2,'2019-07-14',6384938,2,NULL,NULL),(459,291,2,'2019-07-14',4142317,2,NULL,NULL),(460,2,2,'2019-07-14',2245465,2,NULL,NULL),(461,371,2,'2019-07-14',2497632,2,NULL,NULL),(462,79,2,'2019-07-14',2665944,2,NULL,NULL),(463,326,2,'2019-07-14',6326244,2,NULL,NULL),(464,267,2,'2019-07-14',4844845,2,NULL,NULL),(465,254,2,'2019-07-14',2580526,2,NULL,NULL),(466,276,2,'2019-07-14',7162621,2,NULL,NULL),(467,472,2,'2019-07-14',4799789,2,NULL,NULL),(468,493,2,'2019-07-14',4511347,2,NULL,NULL),(469,167,2,'2019-07-14',2328661,2,NULL,NULL),(470,281,2,'2019-07-14',5023227,2,NULL,NULL),(471,110,2,'2019-07-14',4961865,2,NULL,NULL),(472,334,2,'2019-07-14',5498989,2,NULL,NULL),(473,284,2,'2019-07-14',3728201,2,NULL,NULL),(474,249,2,'2019-07-14',5375402,2,NULL,NULL),(475,278,2,'2019-07-14',5408269,2,NULL,NULL),(476,254,2,'2019-07-14',6917420,2,NULL,NULL),(477,5,2,'2019-07-14',4195143,2,NULL,NULL),(478,125,2,'2019-07-14',3766440,2,NULL,NULL),(479,132,2,'2019-07-14',3404834,2,NULL,NULL),(480,244,2,'2019-07-14',4302016,2,NULL,NULL),(481,435,2,'2019-07-14',2616308,2,NULL,NULL),(482,130,2,'2019-07-14',2212701,2,NULL,NULL),(483,276,2,'2019-07-14',5363835,2,NULL,NULL),(484,92,2,'2019-07-14',3841376,2,NULL,NULL),(485,494,2,'2019-07-14',3826244,2,NULL,NULL),(486,407,2,'2019-07-14',4362018,2,NULL,NULL),(487,497,2,'2019-07-14',3364684,2,NULL,NULL),(488,168,2,'2019-07-14',2515788,2,NULL,NULL),(489,4,2,'2019-07-14',4551972,2,NULL,NULL),(490,352,2,'2019-07-14',2809137,2,NULL,NULL),(491,344,2,'2019-07-14',6642582,2,NULL,NULL),(492,495,2,'2019-07-14',4446843,2,NULL,NULL),(493,375,2,'2019-07-14',5995109,2,NULL,NULL),(494,365,2,'2019-07-14',6339648,2,NULL,NULL),(495,146,2,'2019-07-14',3082577,2,NULL,NULL),(496,406,2,'2019-07-14',3041142,2,NULL,NULL),(497,267,2,'2019-07-14',4727209,2,NULL,NULL),(498,192,2,'2019-07-14',4699766,2,NULL,NULL),(499,199,2,'2019-07-14',1821767,2,NULL,NULL),(500,196,2,'2019-07-14',4579894,2,NULL,NULL),(501,73,2,'2019-07-14',4202613,2,NULL,NULL),(502,265,2,'2019-07-14',4212847,2,NULL,NULL),(503,322,2,'2019-07-14',1933729,2,NULL,NULL),(504,396,2,'2019-07-14',3068092,2,NULL,NULL),(505,228,2,'2019-07-14',6217787,2,NULL,NULL),(506,406,2,'2019-07-14',3578247,2,NULL,NULL),(507,246,2,'2019-07-14',2439950,2,NULL,NULL),(508,445,2,'2019-07-14',2423980,2,NULL,NULL),(509,77,2,'2019-07-14',6150559,2,NULL,NULL),(510,458,2,'2019-07-14',6568084,2,NULL,NULL),(511,9,2,'2019-07-14',5575787,2,NULL,NULL),(512,117,2,'2019-07-14',4420576,2,NULL,NULL),(513,244,2,'2019-07-14',5871251,2,NULL,NULL),(514,471,2,'2019-07-14',7197684,2,NULL,NULL),(515,278,2,'2019-07-14',3904529,2,NULL,NULL),(516,16,2,'2019-07-14',4743251,2,NULL,NULL),(517,302,2,'2019-07-14',2810608,2,NULL,NULL),(518,111,2,'2019-07-14',5540117,2,NULL,NULL),(519,313,2,'2019-07-14',4925899,2,NULL,NULL),(520,76,2,'2019-07-14',2126281,2,NULL,NULL),(521,408,2,'2019-07-14',1908316,2,NULL,NULL),(522,324,2,'2019-07-14',5681765,2,NULL,NULL),(523,31,2,'2019-07-14',3794267,2,NULL,NULL),(524,318,2,'2019-07-14',3687245,2,NULL,NULL),(525,192,2,'2019-07-14',2587451,2,NULL,NULL),(526,274,2,'2019-07-14',6355475,2,NULL,NULL),(527,60,2,'2019-07-14',3814164,2,NULL,NULL),(528,72,2,'2019-07-14',6152587,2,NULL,NULL),(529,180,2,'2019-07-14',3263597,2,NULL,NULL),(530,147,2,'2019-07-14',6999970,2,NULL,NULL),(531,101,2,'2019-07-14',4671251,2,NULL,NULL),(532,106,2,'2019-07-14',3909604,2,NULL,NULL),(533,249,2,'2019-07-14',4497108,2,NULL,NULL),(534,310,2,'2019-07-14',5430017,2,NULL,NULL),(535,137,2,'2019-07-14',6982972,2,NULL,NULL),(536,146,2,'2019-07-14',4475764,2,NULL,NULL),(537,100,2,'2019-07-14',4254798,2,NULL,NULL),(538,460,2,'2019-07-14',3470999,2,NULL,NULL),(539,482,2,'2019-07-14',4380873,2,NULL,NULL),(540,131,2,'2019-07-14',5447453,2,NULL,NULL),(541,232,2,'2019-07-14',3661404,2,NULL,NULL),(542,54,2,'2019-07-14',7107155,2,NULL,NULL),(543,293,2,'2019-07-14',3021073,2,NULL,NULL),(544,187,2,'2019-07-14',4594652,2,NULL,NULL),(545,320,2,'2019-07-14',6870498,2,NULL,NULL),(546,227,2,'2019-07-14',3028099,2,NULL,NULL),(547,231,2,'2019-07-14',4013716,2,NULL,NULL),(548,401,2,'2019-07-14',6129387,2,NULL,NULL),(549,229,2,'2019-07-14',2467752,2,NULL,NULL),(550,91,2,'2019-07-14',6239017,2,NULL,NULL),(551,139,2,'2020-07-20',6987632,3,NULL,NULL),(552,130,2,'2020-07-20',2379341,3,NULL,NULL),(553,117,2,'2020-07-20',2841041,3,NULL,NULL),(554,125,2,'2020-07-20',5847505,3,NULL,NULL),(555,99,2,'2020-07-20',6660632,3,NULL,NULL),(556,292,2,'2020-07-20',4555234,3,NULL,NULL),(557,493,2,'2020-07-20',3167024,3,NULL,NULL),(558,285,2,'2020-07-20',4887560,3,NULL,NULL),(559,58,2,'2020-07-20',3744172,3,NULL,NULL),(560,161,2,'2020-07-20',5027100,3,NULL,NULL),(561,263,2,'2020-07-20',2440659,3,NULL,NULL),(562,359,2,'2020-07-20',6691339,3,NULL,NULL),(563,106,2,'2020-07-20',6267058,3,NULL,NULL),(564,15,2,'2020-07-20',5482762,3,NULL,NULL),(565,246,2,'2020-07-20',1990119,3,NULL,NULL),(566,258,2,'2020-07-20',3914006,3,NULL,NULL),(567,490,2,'2020-07-20',3533471,3,NULL,NULL),(568,357,2,'2020-07-20',2232979,3,NULL,NULL),(569,80,2,'2020-07-20',2152710,3,NULL,NULL),(570,426,2,'2020-07-20',1959875,3,NULL,NULL),(571,38,2,'2020-07-20',2169779,3,NULL,NULL),(572,344,2,'2020-07-20',3971007,3,NULL,NULL),(573,485,2,'2020-07-20',6826255,3,NULL,NULL),(574,299,2,'2020-07-20',3172783,3,NULL,NULL),(575,148,2,'2020-07-20',2792241,3,NULL,NULL),(576,195,2,'2020-07-20',4568126,3,NULL,NULL),(577,40,2,'2020-07-20',7006447,3,NULL,NULL),(578,278,2,'2020-07-20',3790351,3,NULL,NULL),(579,364,2,'2020-07-20',3579551,3,NULL,NULL),(580,195,2,'2020-07-20',6897324,3,NULL,NULL),(581,275,2,'2020-07-20',6160658,3,NULL,NULL),(582,463,2,'2020-07-20',2272766,3,NULL,NULL),(583,284,2,'2020-07-20',3859351,3,NULL,NULL),(584,193,2,'2020-07-20',4958916,3,NULL,NULL),(585,186,2,'2020-07-20',5825270,3,NULL,NULL),(586,50,2,'2020-07-20',4394296,3,NULL,NULL),(587,341,2,'2020-07-20',3489046,3,NULL,NULL),(588,417,2,'2020-07-20',6652869,3,NULL,NULL),(589,279,2,'2020-07-20',7097640,3,NULL,NULL),(590,204,2,'2020-07-20',6306880,3,NULL,NULL),(591,370,2,'2020-07-20',6052084,3,NULL,NULL),(592,451,2,'2020-07-20',5050056,3,NULL,NULL),(593,87,2,'2020-07-20',3419478,3,NULL,NULL),(594,385,2,'2020-07-20',2694350,3,NULL,NULL),(595,326,2,'2020-07-20',6581235,3,NULL,NULL),(596,301,2,'2020-07-20',2266121,3,NULL,NULL),(597,159,2,'2020-07-20',5025568,3,NULL,NULL),(598,131,2,'2020-07-20',5111390,3,NULL,NULL),(599,254,2,'2020-07-20',2225073,3,NULL,NULL),(600,129,2,'2020-07-20',6182280,3,NULL,NULL),(601,479,2,'2020-07-20',2831399,3,NULL,NULL),(602,372,2,'2020-07-20',1958654,3,NULL,NULL),(603,22,2,'2020-07-20',3576566,3,NULL,NULL),(604,254,2,'2020-07-20',7038538,3,NULL,NULL),(605,94,2,'2020-07-20',4287153,3,NULL,NULL),(606,361,2,'2020-07-20',4318350,3,NULL,NULL),(607,159,2,'2020-07-20',3521074,3,NULL,NULL),(608,313,2,'2020-07-20',6497763,3,NULL,NULL),(609,307,2,'2020-07-20',3101690,3,NULL,NULL),(610,38,2,'2020-07-20',3040614,3,NULL,NULL),(611,39,2,'2020-07-20',4776240,3,NULL,NULL),(612,231,2,'2020-07-20',2553627,3,NULL,NULL),(613,319,2,'2020-07-20',6524507,3,NULL,NULL),(614,84,2,'2020-07-20',6915370,3,NULL,NULL),(615,165,2,'2020-07-20',3733763,3,NULL,NULL),(616,52,2,'2020-07-20',5941183,3,NULL,NULL),(617,479,2,'2020-07-20',6018322,3,NULL,NULL),(618,448,2,'2020-07-20',1867819,3,NULL,NULL),(619,209,2,'2020-07-20',4264370,3,NULL,NULL),(620,78,2,'2020-07-20',5318785,3,NULL,NULL),(621,82,2,'2020-07-20',4480826,3,NULL,NULL),(622,407,2,'2020-07-20',6234969,3,NULL,NULL),(623,481,2,'2020-07-20',5040577,3,NULL,NULL),(624,349,2,'2020-07-20',6570258,3,NULL,NULL),(625,97,2,'2020-07-20',5801376,3,NULL,NULL),(626,397,2,'2020-07-20',6109633,3,NULL,NULL),(627,43,2,'2020-07-20',5515239,3,NULL,NULL),(628,318,2,'2020-07-20',6591072,3,NULL,NULL),(629,165,2,'2020-07-20',4653990,3,NULL,NULL),(630,476,2,'2020-07-20',1875763,3,NULL,NULL),(631,351,2,'2020-07-20',2812587,3,NULL,NULL),(632,330,2,'2020-07-20',2202481,3,NULL,NULL),(633,411,2,'2020-07-20',6897290,3,NULL,NULL),(634,144,2,'2020-07-20',6004483,3,NULL,NULL),(635,309,2,'2020-07-20',2296173,3,NULL,NULL),(636,153,2,'2020-07-20',2743252,3,NULL,NULL),(637,469,2,'2020-07-20',4878893,3,NULL,NULL),(638,499,2,'2020-07-20',2365691,3,NULL,NULL),(639,368,2,'2020-07-20',6989410,3,NULL,NULL),(640,225,2,'2020-07-20',5405796,3,NULL,NULL),(641,365,2,'2020-07-20',3954810,3,NULL,NULL),(642,246,2,'2020-07-20',5232462,3,NULL,NULL),(643,276,2,'2020-07-20',3471344,3,NULL,NULL),(644,120,2,'2020-07-20',4568687,3,NULL,NULL),(645,463,2,'2020-07-20',4930109,3,NULL,NULL),(646,444,2,'2020-07-20',3271386,3,NULL,NULL),(647,96,2,'2020-07-20',3892396,3,NULL,NULL),(648,39,2,'2020-07-20',6327667,3,NULL,NULL),(649,47,2,'2020-07-20',2464088,3,NULL,NULL),(650,299,2,'2020-07-20',2890869,3,NULL,NULL),(651,201,2,'2020-07-20',5093941,3,NULL,NULL),(652,429,2,'2020-07-20',4077196,3,NULL,NULL),(653,29,2,'2020-07-20',3620981,3,NULL,NULL),(654,20,2,'2020-07-20',3735157,3,NULL,NULL),(655,490,2,'2020-07-20',3289359,3,NULL,NULL),(656,277,2,'2020-07-20',3255763,3,NULL,NULL),(657,370,2,'2020-07-20',4311992,3,NULL,NULL),(658,336,2,'2020-07-20',6164904,3,NULL,NULL),(659,61,2,'2020-07-20',4102717,3,NULL,NULL),(660,127,2,'2020-07-20',3370318,3,NULL,NULL),(661,243,2,'2020-07-20',6994636,3,NULL,NULL),(662,306,2,'2020-07-20',3125266,3,NULL,NULL),(663,78,2,'2020-07-20',5598954,3,NULL,NULL),(664,465,2,'2020-07-20',6728935,3,NULL,NULL),(665,312,2,'2020-07-20',1984752,3,NULL,NULL),(666,450,2,'2020-07-20',5709234,3,NULL,NULL),(667,499,2,'2020-07-20',3397108,3,NULL,NULL),(668,313,2,'2020-07-20',5106227,3,NULL,NULL),(669,141,2,'2020-07-20',7039441,3,NULL,NULL),(670,150,2,'2020-07-20',6334573,3,NULL,NULL),(671,89,2,'2020-07-20',5169789,3,NULL,NULL),(672,106,2,'2020-07-20',4400608,3,NULL,NULL),(673,472,2,'2020-07-20',6766330,3,NULL,NULL),(674,350,2,'2020-07-20',2930535,3,NULL,NULL),(675,28,2,'2020-07-20',5670060,3,NULL,NULL),(676,424,2,'2020-07-20',2817377,3,NULL,NULL),(677,216,2,'2020-07-20',3762909,3,NULL,NULL),(678,104,2,'2020-07-20',5394167,3,NULL,NULL),(679,124,2,'2020-07-20',4268727,3,NULL,NULL),(680,472,2,'2020-07-20',6843214,3,NULL,NULL),(681,113,2,'2020-07-20',6595542,3,NULL,NULL),(682,463,2,'2020-07-20',2898727,3,NULL,NULL),(683,351,2,'2020-07-20',3413677,3,NULL,NULL),(684,245,2,'2020-07-20',4599159,3,NULL,NULL),(685,166,2,'2020-07-20',3468719,3,NULL,NULL),(686,196,2,'2020-07-20',5510172,3,NULL,NULL),(687,394,2,'2020-07-20',6188784,3,NULL,NULL),(688,18,2,'2020-07-20',7096777,3,NULL,NULL),(689,55,2,'2020-07-20',4794127,3,NULL,NULL),(690,329,2,'2020-07-20',5295291,3,NULL,NULL),(691,179,2,'2020-07-20',6679129,3,NULL,NULL),(692,230,2,'2020-07-20',6353580,3,NULL,NULL),(693,77,2,'2020-07-20',5143848,3,NULL,NULL),(694,437,2,'2020-07-20',2883612,3,NULL,NULL),(695,214,2,'2020-07-20',6421683,3,NULL,NULL),(696,411,2,'2020-07-20',3933459,3,NULL,NULL),(697,306,2,'2020-07-20',4335381,3,NULL,NULL),(698,247,2,'2020-07-20',5278628,3,NULL,NULL),(699,438,2,'2020-07-20',2905036,3,NULL,NULL),(700,122,2,'2020-07-20',2515698,3,NULL,NULL),(701,347,3,'2020-07-20',4208865,3,NULL,NULL),(702,13,3,'2020-07-20',8473662,3,NULL,NULL),(703,402,3,'2020-07-20',10757235,3,NULL,NULL),(704,176,3,'2020-07-20',12443108,3,NULL,NULL),(705,221,3,'2020-07-20',12068292,3,NULL,NULL),(706,36,3,'2020-07-20',7005077,3,NULL,NULL),(707,336,3,'2020-07-20',11924512,3,NULL,NULL),(708,45,3,'2020-07-20',12149232,3,NULL,NULL),(709,164,3,'2020-07-20',11498928,3,NULL,NULL),(710,1,3,'2020-07-20',9556527,3,NULL,NULL),(711,463,3,'2020-07-20',6450148,3,NULL,NULL),(712,422,3,'2020-07-20',9721914,3,NULL,NULL),(713,101,3,'2020-07-20',13195248,3,NULL,NULL),(714,244,3,'2020-07-20',7261427,3,NULL,NULL),(715,121,3,'2020-07-20',4541552,3,NULL,NULL),(716,333,3,'2020-07-20',4450808,3,NULL,NULL),(717,113,3,'2020-07-20',13212502,3,NULL,NULL),(718,105,3,'2020-07-20',7682562,3,NULL,NULL),(719,301,3,'2020-07-20',13598774,3,NULL,NULL),(720,493,3,'2020-07-20',6724137,3,NULL,NULL),(721,444,3,'2020-07-20',6462203,3,NULL,NULL),(722,12,3,'2020-07-20',4365385,3,NULL,NULL),(723,56,3,'2020-07-20',8652403,3,NULL,NULL),(724,381,3,'2020-07-20',10026015,3,NULL,NULL),(725,334,3,'2020-07-20',6831069,3,NULL,NULL),(726,297,3,'2020-07-20',5429894,3,NULL,NULL),(727,487,3,'2020-07-20',9701424,3,NULL,NULL),(728,311,3,'2020-07-20',3799483,3,NULL,NULL),(729,184,3,'2020-07-20',4994997,3,NULL,NULL),(730,449,3,'2020-07-20',3789586,3,NULL,NULL),(731,221,3,'2020-07-20',13889429,3,NULL,NULL),(732,219,3,'2020-07-20',11034590,3,NULL,NULL),(733,435,3,'2020-07-20',12312150,3,NULL,NULL),(734,132,3,'2020-07-20',7920990,3,NULL,NULL),(735,404,3,'2020-07-20',7616151,3,NULL,NULL),(736,416,3,'2020-07-20',9057650,3,NULL,NULL),(737,16,3,'2020-07-20',10165124,3,NULL,NULL),(738,256,3,'2020-07-20',6160389,3,NULL,NULL),(739,338,3,'2020-07-20',6419014,3,NULL,NULL),(740,234,3,'2020-07-20',11920245,3,NULL,NULL),(741,451,3,'2020-07-20',10946095,3,NULL,NULL),(742,89,3,'2020-07-20',9359358,3,NULL,NULL),(743,65,3,'2020-07-20',4469025,3,NULL,NULL),(744,378,3,'2020-07-20',8401670,3,NULL,NULL),(745,376,3,'2020-07-20',3748881,3,NULL,NULL),(746,12,3,'2020-07-20',4675265,3,NULL,NULL),(747,299,3,'2020-07-20',6215301,3,NULL,NULL),(748,298,3,'2020-07-20',13170950,3,NULL,NULL),(749,432,3,'2020-07-20',9673369,3,NULL,NULL),(750,125,3,'2020-07-20',12945644,3,NULL,NULL),(751,335,3,'2020-07-20',6994970,3,NULL,NULL),(752,406,3,'2020-07-20',14356395,3,NULL,NULL),(753,428,3,'2020-07-20',11129649,3,NULL,NULL),(754,457,3,'2020-07-20',8436295,3,NULL,NULL),(755,134,3,'2020-07-20',5963532,3,NULL,NULL),(756,15,3,'2020-07-20',13725552,3,NULL,NULL),(757,392,3,'2020-07-20',7537379,3,NULL,NULL),(758,361,3,'2020-07-20',4423151,3,NULL,NULL),(759,487,3,'2020-07-20',7712907,3,NULL,NULL),(760,500,3,'2020-07-20',10041110,3,NULL,NULL),(761,299,3,'2020-07-20',12718662,3,NULL,NULL),(762,16,3,'2020-07-20',5466441,3,NULL,NULL),(763,314,3,'2020-07-20',4971247,3,NULL,NULL),(764,301,3,'2020-07-20',7428649,3,NULL,NULL),(765,393,3,'2020-07-20',8554171,3,NULL,NULL),(766,129,3,'2020-07-20',12956269,3,NULL,NULL),(767,377,3,'2020-07-20',3836475,3,NULL,NULL),(768,269,3,'2020-07-20',6531757,3,NULL,NULL),(769,322,3,'2020-07-20',10102508,3,NULL,NULL),(770,326,3,'2020-07-20',5967426,3,NULL,NULL),(771,296,3,'2020-07-20',6797701,3,NULL,NULL),(772,132,3,'2020-07-20',6127907,3,NULL,NULL),(773,63,3,'2020-07-20',5996588,3,NULL,NULL),(774,428,3,'2020-07-20',10172655,3,NULL,NULL),(775,135,3,'2020-07-20',14020153,3,NULL,NULL),(776,219,3,'2020-07-20',12220504,3,NULL,NULL),(777,138,3,'2020-07-20',11973718,3,NULL,NULL),(778,134,3,'2020-07-20',6432761,3,NULL,NULL),(779,214,3,'2020-07-20',4028396,3,NULL,NULL),(780,315,3,'2020-07-20',5653638,3,NULL,NULL),(781,279,3,'2020-07-20',7022165,3,NULL,NULL),(782,253,3,'2020-07-20',7766307,3,NULL,NULL),(783,50,3,'2020-07-20',12184196,3,NULL,NULL),(784,199,3,'2020-07-20',7434049,3,NULL,NULL),(785,498,3,'2020-07-20',7186964,3,NULL,NULL),(786,20,3,'2020-07-20',7781709,3,NULL,NULL),(787,20,3,'2020-07-20',6379822,3,NULL,NULL),(788,493,3,'2020-07-20',9578857,3,NULL,NULL),(789,418,3,'2020-07-20',5051953,3,NULL,NULL),(790,190,3,'2020-07-20',8255252,3,NULL,NULL),(791,194,3,'2020-07-20',9131038,3,NULL,NULL),(792,280,3,'2020-07-20',4857614,3,NULL,NULL),(793,427,3,'2020-07-20',13488387,3,NULL,NULL),(794,46,3,'2020-07-20',9611598,3,NULL,NULL),(795,291,3,'2020-07-20',6332059,3,NULL,NULL),(796,71,3,'2020-07-20',12802834,3,NULL,NULL),(797,183,3,'2020-07-20',11751345,3,NULL,NULL),(798,204,3,'2020-07-20',10413604,3,NULL,NULL),(799,116,3,'2020-07-20',4903345,3,NULL,NULL),(800,186,3,'2020-07-20',11318267,3,NULL,NULL),(801,130,3,'2020-07-20',10995672,3,NULL,NULL),(802,288,3,'2020-07-20',4590407,3,NULL,NULL),(803,259,3,'2020-07-20',11485932,3,NULL,NULL),(804,497,3,'2020-07-20',7419769,3,NULL,NULL),(805,233,3,'2020-07-20',3809128,3,NULL,NULL),(806,40,3,'2020-07-20',8442094,3,NULL,NULL),(807,469,3,'2020-07-20',12636411,3,NULL,NULL),(808,308,3,'2020-07-20',13204232,3,NULL,NULL),(809,209,3,'2020-07-20',10203684,3,NULL,NULL),(810,126,3,'2020-07-20',13499908,3,NULL,NULL),(811,44,3,'2020-07-20',8263554,3,NULL,NULL),(812,141,3,'2020-07-20',4305106,3,NULL,NULL),(813,124,3,'2020-07-20',10083071,3,NULL,NULL),(814,426,3,'2020-07-20',6997846,3,NULL,NULL),(815,103,3,'2020-07-20',5834805,3,NULL,NULL),(816,447,3,'2020-07-20',7459408,3,NULL,NULL),(817,421,3,'2020-07-20',6443711,3,NULL,NULL),(818,392,3,'2020-07-20',6827995,3,NULL,NULL),(819,94,3,'2020-07-20',6227866,3,NULL,NULL),(820,3,3,'2020-07-20',7897055,3,NULL,NULL),(821,179,3,'2020-07-20',13336227,3,NULL,NULL),(822,473,3,'2020-07-20',8217811,3,NULL,NULL),(823,290,3,'2020-07-20',10310121,3,NULL,NULL),(824,109,3,'2020-07-20',12811282,3,NULL,NULL),(825,272,3,'2020-07-20',7933032,3,NULL,NULL),(826,175,3,'2020-07-20',8495971,3,NULL,NULL),(827,127,3,'2020-07-20',6987794,3,NULL,NULL),(828,238,3,'2020-07-20',5194812,3,NULL,NULL),(829,496,3,'2020-07-20',12311950,3,NULL,NULL),(830,411,3,'2020-07-20',6406603,3,NULL,NULL),(831,81,3,'2020-07-20',9934445,3,NULL,NULL),(832,41,3,'2020-07-20',7659102,3,NULL,NULL),(833,297,3,'2020-07-20',10297001,3,NULL,NULL),(834,60,3,'2020-07-20',4021788,3,NULL,NULL),(835,325,3,'2020-07-20',6558744,3,NULL,NULL),(836,445,3,'2020-07-20',6882401,3,NULL,NULL),(837,122,3,'2020-07-20',9756527,3,NULL,NULL),(838,485,3,'2020-07-20',5197429,3,NULL,NULL),(839,136,3,'2020-07-20',10513869,3,NULL,NULL),(840,255,3,'2020-07-20',7844443,3,NULL,NULL),(841,221,3,'2020-07-20',7946017,3,NULL,NULL),(842,419,3,'2020-07-20',6195389,3,NULL,NULL),(843,488,3,'2020-07-20',12653412,3,NULL,NULL),(844,242,3,'2020-07-20',10327211,3,NULL,NULL),(845,133,3,'2020-07-20',7900813,3,NULL,NULL),(846,498,3,'2020-07-20',13822011,3,NULL,NULL),(847,420,3,'2020-07-20',10853704,3,NULL,NULL),(848,312,3,'2020-07-20',7557411,3,NULL,NULL),(849,29,3,'2020-07-20',7697368,3,NULL,NULL),(850,465,3,'2020-07-20',10693606,3,NULL,NULL),(851,335,4,'2020-07-20',9676017,3,NULL,NULL),(852,297,4,'2020-07-20',26152604,3,NULL,NULL),(853,189,4,'2020-07-20',26553135,3,NULL,NULL),(854,309,4,'2020-07-20',16760107,3,NULL,NULL),(855,291,4,'2020-07-20',12366710,3,NULL,NULL),(856,374,4,'2020-07-20',25305678,3,NULL,NULL),(857,16,4,'2020-07-20',23399269,3,NULL,NULL),(858,191,4,'2020-07-20',16600049,3,NULL,NULL),(859,304,4,'2020-07-20',19997961,3,NULL,NULL),(860,474,4,'2020-07-20',25764200,3,NULL,NULL),(861,42,4,'2020-07-20',14544687,3,NULL,NULL),(862,161,4,'2020-07-20',26730118,3,NULL,NULL),(863,40,4,'2020-07-20',17479394,3,NULL,NULL),(864,353,4,'2020-07-20',10948020,3,NULL,NULL),(865,38,4,'2020-07-20',11716790,3,NULL,NULL),(866,198,4,'2020-07-20',17498824,3,NULL,NULL),(867,389,4,'2020-07-20',28329653,3,NULL,NULL),(868,306,4,'2020-07-20',18785851,3,NULL,NULL),(869,392,4,'2020-07-20',11431072,3,NULL,NULL),(870,32,4,'2020-07-20',23121724,3,NULL,NULL),(871,307,4,'2020-07-20',18255584,3,NULL,NULL),(872,187,4,'2020-07-20',18884604,3,NULL,NULL),(873,266,4,'2020-07-20',27116747,3,NULL,NULL),(874,270,4,'2020-07-20',25775072,3,NULL,NULL),(875,200,4,'2020-07-20',24999158,3,NULL,NULL),(876,97,4,'2020-07-20',25701232,3,NULL,NULL),(877,487,4,'2020-07-20',9066775,3,NULL,NULL),(878,376,4,'2020-07-20',19032755,3,NULL,NULL),(879,335,4,'2020-07-20',17207421,3,NULL,NULL),(880,180,4,'2020-07-20',22928612,3,NULL,NULL),(881,137,4,'2020-07-20',21660193,3,NULL,NULL),(882,125,4,'2020-07-20',18180983,3,NULL,NULL),(883,117,4,'2020-07-20',18101741,3,NULL,NULL),(884,244,4,'2020-07-20',19572871,3,NULL,NULL),(885,147,4,'2020-07-20',15189207,3,NULL,NULL),(886,375,4,'2020-07-20',22516833,3,NULL,NULL),(887,91,4,'2020-07-20',17124712,3,NULL,NULL),(888,360,4,'2020-07-20',28029000,3,NULL,NULL),(889,40,4,'2020-07-20',16457325,3,NULL,NULL),(890,17,4,'2020-07-20',17413646,3,NULL,NULL),(891,313,4,'2020-07-20',22175652,3,NULL,NULL),(892,75,4,'2020-07-20',18330739,3,NULL,NULL),(893,61,4,'2020-07-20',24590059,3,NULL,NULL),(894,28,4,'2020-07-20',19412033,3,NULL,NULL),(895,107,4,'2020-07-20',12257832,3,NULL,NULL),(896,374,4,'2020-07-20',18058430,3,NULL,NULL),(897,472,4,'2020-07-20',20226338,3,NULL,NULL),(898,413,4,'2020-07-20',27252124,3,NULL,NULL),(899,223,4,'2020-07-20',13994007,3,NULL,NULL),(900,424,4,'2020-07-20',13666447,3,NULL,NULL),(901,1,1,'2021-03-11',2393323,4,NULL,NULL),(902,1,1,'2021-03-16',2393323,4,NULL,NULL),(903,1,1,'2021-03-16',2393323,4,NULL,NULL),(904,1,1,'2021-03-16',2393323,4,NULL,NULL),(905,1,1,'2021-03-16',2393323,4,NULL,NULL),(906,1,1,'2021-03-16',2393323,4,NULL,NULL),(907,1,1,'2021-03-16',2393323,4,NULL,NULL),(908,1,1,'2021-03-16',2393323,4,NULL,NULL),(909,1,1,'2021-03-16',2393323,4,NULL,NULL),(910,1,1,'2021-03-16',2393323,4,NULL,NULL),(911,1,1,'2021-03-16',2393323,4,NULL,NULL),(912,1,1,'2021-03-16',2393323,4,NULL,NULL);
/*!40000 ALTER TABLE `resultats` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `resultat_log`
--

DROP TABLE IF EXISTS `resultats_logs`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `resultats_logs` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `operation` varchar(100) COLLATE utf8mb4_general_ci NOT NULL,
  `ancien_resultat` int(11) DEFAULT NULL,
  `nouveau_resultat` int(11) DEFAULT NULL,
  `resultat_id` int(11) DEFAULT NULL,
  `date_operation` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `resultats_logs`
--

LOCK TABLES `resultats_logs` WRITE;
/*!40000 ALTER TABLE `resultats_logs` DISABLE KEYS */;
/*!40000 ALTER TABLE `resultats_logs` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `resultats_statistiques`
--

DROP TABLE IF EXISTS `resultats_statistiques`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `resultats_statistiques` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `epreuve_id` int(11) NOT NULL,
  `evenement_id` int(11) NOT NULL,
  `premier_id` int(11) DEFAULT NULL,
  `deuxieme_id` int(11) DEFAULT NULL,
  `troisieme_id` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `resultats_statistiques`
--

LOCK TABLES `resultats_statistiques` WRITE;
/*!40000 ALTER TABLE `resultats_statistiques` DISABLE KEYS */;
/*!40000 ALTER TABLE `resultats_statistiques` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `usagers`
--

DROP TABLE IF EXISTS `usagers`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `usagers` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `nom` varchar(50) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `prenom` varchar(50) COLLATE utf8mb4_general_ci DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `usagers`
--

LOCK TABLES `usagers` WRITE;
/*!40000 ALTER TABLE `usagers` DISABLE KEYS */;
INSERT INTO `usagers` VALUES (1,'Landry','Marc'),(2,'Roberge','Lucie'),(3,'Pinard','Frida'),(4,'Tremblay','Jean'),(5,'Gagné','Pierre'),(6,'Nadeau','Rita'),(7,'Warren','Joe');
/*!40000 ALTER TABLE `usagers` ENABLE KEYS */;
UNLOCK TABLES;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!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 */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

-- Dump completed on 2021-10-25  3:36:28
