172 lines
4.0 KiB
SQL
172 lines
4.0 KiB
SQL
INSERT INTO joueur (nomJoueur, estVivant, estImposteur) VALUES
|
|
("Alexandre", 0, 0),
|
|
("Hugo", 0, 0),
|
|
("Lisa", 0, 0),
|
|
("Manon", 0, 0),
|
|
("Mathieu", 0, 0),
|
|
("Nicolas", 0, 0),
|
|
("Pauline", 0, 1),
|
|
("Seb", 0, 1),
|
|
("Yannick", 0, 0),
|
|
("Syska", 0 , 0);
|
|
|
|
INSERT INTO meteoville (temperatureMeteoVille, ventMeteoVille) VALUES
|
|
(2,10),
|
|
(30,1),
|
|
(15,3),
|
|
(21,5),
|
|
(18,10),
|
|
(8,8);
|
|
|
|
INSERT INTO meteoSpot (houleMeteoSpot, mareeMeteoSpot, ventMeteoSpot) VALUES
|
|
(51,12,23),
|
|
(77,22,53),
|
|
(37,24,73),
|
|
(69,86,12),
|
|
(49,00,27),
|
|
(86,53,16),
|
|
(86,81,48),
|
|
(90,32,51),
|
|
(61,11,59),
|
|
(44,89,08),
|
|
(65,46,65),
|
|
(37,72,83),
|
|
(62,79,42),
|
|
(30,49,12),
|
|
(24,69,97),
|
|
(61,93,41),
|
|
(53,18,79),
|
|
(54,86,57),
|
|
(24,28,68),
|
|
(48,48,74);
|
|
|
|
INSERT INTO ville (nomVille, cpVille, meteoVille) VALUES
|
|
("Paris",07887,1),
|
|
("Marseille",78630,2),
|
|
("Lyon",44555,3),
|
|
("Toulouse",11684,4),
|
|
("Nice",42113,5),
|
|
("Nantes",54239,6),
|
|
("Montpellier",61211,6),
|
|
("Strasbourg",80180,5),
|
|
("Bordeaux",02490,4),
|
|
("Lille",12469,3),
|
|
("Rennes",81504,2),
|
|
("Reims",96409,1);
|
|
|
|
INSERT INTO produits (estCremeSolaire, estParfum, estCremeHydratante, estMaquillage, estEssence, estCigarette, EstEngrais, EstPeinture) VALUES
|
|
(1,1,1,0,0,0,0,1),
|
|
(1,1,1,0,1,1,0,1),
|
|
(1,0,0,0,0,0,1,0),
|
|
(1,0,0,1,0,0,1,1),
|
|
(1,1,1,1,0,0,1,0),
|
|
(0,0,0,1,1,0,1,1),
|
|
(0,0,0,0,1,1,1,1),
|
|
(1,1,1,0,0,1,0,1),
|
|
(1,1,1,0,1,1,1,1),
|
|
(1,0,0,1,0,1,0,0),
|
|
(1,0,0,0,1,1,1,1),
|
|
(1,1,1,1,1,1,1,1),
|
|
(0,1,1,1,0,0,1,1),
|
|
(0,1,1,1,1,1,1,0),
|
|
(1,0,0,1,1,1,1,1),
|
|
(1,0,0,0,0,0,0,1),
|
|
(0,0,0,1,1,1,0,0),
|
|
(1,0,0,0,1,1,0,1),
|
|
(0,0,0,0,0,1,0,1),
|
|
(0,0,0,1,1,0,1,1);
|
|
|
|
INSERT INTO pointage (nbBaigneur, nbPratiquant, nbBateauPeche, nbBateauLoisir, nbBateauVoile, produits) VALUES
|
|
(09,59,44,18,97,1),
|
|
(50,74,91,32,15,1),
|
|
(49,50,30,69,73,9),
|
|
(41,53,24,49,30,8),
|
|
(94,13,02,31,79,4),
|
|
(06,62,65,91,26,6),
|
|
(45,83,57,25,60,1),
|
|
(69,71,18,59,72,8),
|
|
(52,44,36,89,49,5),
|
|
(80,54,95,14,57,7),
|
|
(89,86,52,75,23,0),
|
|
(90,19,67,68,60,6),
|
|
(46,17,00,95,95,5),
|
|
(92,64,23,12,79,3),
|
|
(48,40,72,21,78,0),
|
|
(13,99,18,37,53,6),
|
|
(72,13,93,71,82,0),
|
|
(58,19,78,87,51,8),
|
|
(08,32,82,41,90,1),
|
|
(75,70,29,25,11,4);
|
|
|
|
INSERT INTO pollution (niveauPollution, descriptionPollution) VALUES
|
|
(0,"aucune pollution"),
|
|
(1,"faible pollution"),
|
|
(2,"pollution moyenne"),
|
|
(3,"forte pollution");
|
|
|
|
INSERT INTO spot (nomSpot, villeSpot, meteoSpot, pollutionSpot) VALUES
|
|
("fe",1,0,2),
|
|
("tesvoscij",6,0,7),
|
|
("bul",4,0,0),
|
|
("jirimoz",4,5,1),
|
|
("ufomi",3,0,4),
|
|
("ca",1,5,2),
|
|
("gi",3,0,6),
|
|
("emsebluf",6,1,1),
|
|
("piwocav",8,3,5),
|
|
("bifhovno",5,0,0),
|
|
("to",7,7,1),
|
|
("de",9,4,1),
|
|
("ac",2,4,9),
|
|
("ola",0,9,8),
|
|
("me",5,5,4),
|
|
("ro",3,2,6),
|
|
("ko",8,2,1),
|
|
("vofjo",9,8,8),
|
|
("ocvagi",2,7,5),
|
|
("papzo",6,8,7),
|
|
("miih",4,1,0),
|
|
("go",6,9,6),
|
|
("ricuwjul",3,4,5),
|
|
("depfaj",5,0,3),
|
|
("fi",1,9,0),
|
|
("fadbew",1,9,6),
|
|
("catol",6,9,0),
|
|
("ko",4,3,8),
|
|
("vugi",2,8,1),
|
|
("pi",6,6,4),
|
|
("hu",3,4,8),
|
|
("bab",7,2,6),
|
|
("hot",6,3,6),
|
|
("hopekmis",8,4,7),
|
|
("linozam",5,3,7),
|
|
("redfo",5,5,6),
|
|
("cenisa",2,8,3),
|
|
("rev",9,5,2),
|
|
("haj",5,4,4),
|
|
("verezi",8,3,6),
|
|
("kehus",0,8,9),
|
|
("owi",6,2,9),
|
|
("adzaub",2,9,2),
|
|
("tojtoepa",4,5,9),
|
|
("buj",5,0,5),
|
|
("ciwcowos",9,0,0),
|
|
("obipezow",7,2,9),
|
|
("lefocew",9,6,2),
|
|
("pozukoeno",5,1,0),
|
|
("ojlotvu",2,1,8);
|
|
|
|
INSERT INTO utilisateur (nomUtilisateur, prenomUtilisateur, mailUtilisateur, pseudoUtilisateur , passwordUtilisateur) VALUES
|
|
("Connor","Thomas","egidu@we.nl","go",MD5('4aeKHP8aaa')),
|
|
("Richard","Garcia","es@hupegas.ng","tag",MD5('ZIELWa6avf')),
|
|
("Warren","Byrd","genebcu@do.hu","senlez",MD5('Bi7EMaUaT')),
|
|
("Maggie","Brooks","ehjiw@vokibonu.pm","wogiv",MD5('WaaOXWKyaU')),
|
|
("Beatrice","Fox","zufuwren@cewrin.tj","go",MD5('Vna3ihflCQ')),
|
|
("Billy","Maxwell","suz@pecak.by","kadef",MD5('CMsjeaRpWo')),
|
|
("Essie","Olson","luglar@jik.az","ihe",MD5('tmtTTMQLGb')),
|
|
("Madge","Dawson","wi@cogzer.qa","mirono",MD5('AaLkaac8kX')),
|
|
("Johnny","Byrd","fodem@talpehge.mq","ecame",MD5('7Glkm7Py9a')),
|
|
("Nettie","Burton","ukaropa@awo.st","ipuona",MD5('KaUqaYKOUU'));
|
|
|
|
|