/* Création de la base de données Gymnase2000 dans uWamp */ /* nsi.gecif.net */ /* Janvier 2025 */ BEGIN TRANSACTION; /* création des 7 tables : */ CREATE TABLE Sportifs( IdSportif INT NOT NULL PRIMARY KEY, Nom VARCHAR2(30), Prenom VARCHAR2(30), Sexe VARCHAR2(30), Age INT, IdSportifConseiller INT ); CREATE TABLE Sports( IdSport INT NOT NULL PRIMARY KEY, Libelle VARCHAR2(30) ); CREATE TABLE Gymnases( IdGymnase INT NOT NULL PRIMARY KEY, NomGymnase VARCHAR2(30), Adresse VARCHAR2(30), Ville VARCHAR2(30), Surface INT ); CREATE TABLE Arbitrer( IdSportif INT NOT NULL REFERENCES Sportifs, IdSport INT NOT NULL REFERENCES Sports, PRIMARY KEY (IdSportif, IdSport) ); CREATE TABLE Entrainer( IdSportifEntraineur INT NOT NULL REFERENCES Sportifs (IdSportif), IdSport INT NOT NULL REFERENCES Sports, PRIMARY KEY (IdSportifEntraineur, IdSport) ); CREATE TABLE Jouer( IdSportif INT NOT NULL REFERENCES Sportifs, IdSport INT NOT NULL REFERENCES Sports, PRIMARY KEY (IdSportif, IdSport) ); CREATE TABLE Seances( IdGymnase INT NOT NULL REFERENCES Gymnases, IdSport INT NOT NULL REFERENCES Sports, IdSportifEntraineur INT NOT NULL REFERENCES Entrainer, Jour VARCHAR2(30) NOT NULL, Horaire DOUBLE NOT NULL, Duree INT, PRIMARY KEY (IdGymnase, IdSport, IdSportifEntraineur, Jour, Horaire) ); /* importation des données dans chacune des 7 tables : */ /* TABLE Sportifs : */ INSERT INTO Sportifs VALUES(1,'BOUTAHAR','Abderahim','m',30,''); INSERT INTO Sportifs VALUES(2,'KERVADEC','Yann','M',28,1); INSERT INTO Sportifs VALUES(3,'HUE','Pascale','F',25,1); INSERT INTO Sportifs VALUES(4,'DORLEANS','Jean-michel','M',32,1); INSERT INTO Sportifs VALUES(5,'COMES','Sylvie','F',22,1); INSERT INTO Sportifs VALUES(6,'RETALDI','Sophie','F',30,3); INSERT INTO Sportifs VALUES(7,'GOMEZ','Diego','M',25,2); INSERT INTO Sportifs VALUES(9,'ANTUNES','Gaêlle','F',23,4); INSERT INTO Sportifs VALUES(10,'BLANDET','Arnaud','M',23,2); INSERT INTO Sportifs VALUES(11,'BONNET','Christophe','M',24,6); INSERT INTO Sportifs VALUES(12,'BORREL','Benoît','M',24,8); INSERT INTO Sportifs VALUES(13,'BOYON','Julien','M',22,4); INSERT INTO Sportifs VALUES(14,'CAILLIOT','Stéphanie','F',24,1); INSERT INTO Sportifs VALUES(15,'CHAMPENOIS','Cédric','M',25,3); INSERT INTO Sportifs VALUES(16,'COLAS','Michaël','M',24,8); INSERT INTO Sportifs VALUES(17,'COLOMB','Michaël','M',22,7); INSERT INTO Sportifs VALUES(18,'HOSNI','Leila','F',25,5); INSERT INTO Sportifs VALUES(19,'TESTEMONT','Laurent','M',25,1); INSERT INTO Sportifs VALUES(20,'TIENER','Thomas','M',25,2); INSERT INTO Sportifs VALUES(21,'LE BOUCHER','Denis','M',22,2); INSERT INTO Sportifs VALUES(22,'LEDUFAUD','Pierre','M',25,3); INSERT INTO Sportifs VALUES(23,'LEGRAND','David','M',24,2); INSERT INTO Sportifs VALUES(24,'LEJEUNE','Sylvaine','F',23,7); INSERT INTO Sportifs VALUES(25,'MARTORA','Fabrice','M',23,9); INSERT INTO Sportifs VALUES(26,'MICHEL','Frédérique','F',23,3); INSERT INTO Sportifs VALUES(27,'NIELLEZ','Christophe','M',23,7); INSERT INTO Sportifs VALUES(28,'RABAHI','Rabah','M',40,4); INSERT INTO Sportifs VALUES(29,'ROUSSEL','Nadège','F',22,5); INSERT INTO Sportifs VALUES(30,'SCHINK','Nicolas','M',24,4); INSERT INTO Sportifs VALUES(31,'STEMPUT','Mathieu','M',22,2); INSERT INTO Sportifs VALUES(32,'VAN CAUTER','Vincent','M',23,3); INSERT INTO Sportifs VALUES(33,'RAMPNOUX','Jean françois','M',23,1); INSERT INTO Sportifs VALUES(34,'LHERPINIERE','Olivier','M',24,3); INSERT INTO Sportifs VALUES(35,'TANQUE','Yann','M',24,4); INSERT INTO Sportifs VALUES(36,'DJELOUDANE','Zinedine','M',28,1); INSERT INTO Sportifs VALUES(37,'LAZZARI','Magali','F',25,44); INSERT INTO Sportifs VALUES(38,'VASSEMON','Laurent','M',24,1); INSERT INTO Sportifs VALUES(39,'MOREL','Mathieu','M',24,8); INSERT INTO Sportifs VALUES(40,'VALIN','Yann','M',23,2); INSERT INTO Sportifs VALUES(41,'DELOVINA','Elina','F',22,7); INSERT INTO Sportifs VALUES(42,'LEHOUX','Bruno','M',23,5); INSERT INTO Sportifs VALUES(43,'MATHIEU','Denise','F',23,6); INSERT INTO Sportifs VALUES(44,'ADIBO','Senamé','M',28,21); INSERT INTO Sportifs VALUES(45,'CHAVANT','Christophe','M',25,''); INSERT INTO Sportifs VALUES(46,'DAUXIAN','Cédric','M',24,4); INSERT INTO Sportifs VALUES(47,'GROEN','Céline','F',25,2); INSERT INTO Sportifs VALUES(48,'HEDDI','Zohra','F',23,2); INSERT INTO Sportifs VALUES(49,'JOUVE','Sandra','F',24,5); INSERT INTO Sportifs VALUES(50,'KALOMBO','Yannick','M',22,2); INSERT INTO Sportifs VALUES(51,'LOPEZ','Thibaud','M',24,5); INSERT INTO Sportifs VALUES(52,'DANDOIS','Régis','M',22,5); INSERT INTO Sportifs VALUES(53,'DEMMER','Thomas','M',22,1); INSERT INTO Sportifs VALUES(54,'ELKABBADJ','Mohammed','M',23,2); INSERT INTO Sportifs VALUES(55,'FEROLDI','Olivier','M',23,2); INSERT INTO Sportifs VALUES(56,'GUERRAOUI','Zohra','F',25,1); INSERT INTO Sportifs VALUES(57,'BOISSEAU','Eric','M',25,1); INSERT INTO Sportifs VALUES(58,'GUIGUI','Vincent','M',23,4); INSERT INTO Sportifs VALUES(59,'CLERICE','Stéphanie','F',23,''); INSERT INTO Sportifs VALUES(60,'TIZEGHAT','Benamar','M',32,3); INSERT INTO Sportifs VALUES(61,'LAZARRE','Jean','M',27,7); INSERT INTO Sportifs VALUES(62,'BAZOUD','Jérôme','M',32,3); INSERT INTO Sportifs VALUES(63,'AMAND','Patrick','M',30,1); INSERT INTO Sportifs VALUES(64,'LANOE','Françoise','F',30,2); INSERT INTO Sportifs VALUES(65,'CHESNIER','Marc','M',30,''); INSERT INTO Sportifs VALUES(66,'DURIEU','Loïc','M',30,2); INSERT INTO Sportifs VALUES(67,'VONTHRON','Dominique','F',26,2); INSERT INTO Sportifs VALUES(68,'REGNAULD','Jeanne','F',30,2); INSERT INTO Sportifs VALUES(69,'MARIE','Paule','F',25,7); INSERT INTO Sportifs VALUES(70,'BELLAMY','Norbert','M',30,9); INSERT INTO Sportifs VALUES(71,'DELAROCHE','Bertrand','M',30,8); INSERT INTO Sportifs VALUES(72,'MARTEL','Bernard','M',22,8); INSERT INTO Sportifs VALUES(73,'DALLIER','Didier','M',30,6); INSERT INTO Sportifs VALUES(74,'AUVRAY','Alain','M',30,5); INSERT INTO Sportifs VALUES(75,'SARRAZIN','Noëlle','F',39,1); INSERT INTO Sportifs VALUES(76,'HALGATTE','Claude','F',30,21); INSERT INTO Sportifs VALUES(77,'HEON','Philippe','M',30,1); INSERT INTO Sportifs VALUES(78,'CHAUVIN','Julien','M',30,''); INSERT INTO Sportifs VALUES(79,'HENRY','Jacky','M',30,2); INSERT INTO Sportifs VALUES(80,'HOCHET','Pierre','M',30,1); INSERT INTO Sportifs VALUES(81,'DROULLON','Joëlle','F',30,1); INSERT INTO Sportifs VALUES(82,'HOUEL','Jean-louis','M',40,14); INSERT INTO Sportifs VALUES(83,'LEROUX','André','M',30,4); INSERT INTO Sportifs VALUES(84,'SALLAÏ','Miloud','M',28,2); INSERT INTO Sportifs VALUES(85,'HAMARD','Romain','M',30,2); INSERT INTO Sportifs VALUES(86,'GALLOT','Bernard','M',30,2); INSERT INTO Sportifs VALUES(87,'COUESBOT','Daniel','M',30,2); INSERT INTO Sportifs VALUES(88,'LEJEUNE','Richard','M',30,8); INSERT INTO Sportifs VALUES(89,'RIQUIER','Jean-pierre','M',30,''); INSERT INTO Sportifs VALUES(90,'DUREL','Eric','M',30,2); INSERT INTO Sportifs VALUES(91,'LECHEVALIER','Patrick','M',30,98); INSERT INTO Sportifs VALUES(92,'HERVIEU','Jean-François','M',22,5); INSERT INTO Sportifs VALUES(93,'CAUCHARD','Georges','M',30,2); INSERT INTO Sportifs VALUES(94,'LEROUX','Paule','M',36,4); INSERT INTO Sportifs VALUES(95,'EUSTACHE','Marcel','M',30,2); INSERT INTO Sportifs VALUES(96,'JANY','Claude','M',30,2); INSERT INTO Sportifs VALUES(97,'BONHOMME','Bruno','M',30,''); INSERT INTO Sportifs VALUES(98,'RICHARD','William','M',30,2); INSERT INTO Sportifs VALUES(99,'BONE','Guy','M',32,''); INSERT INTO Sportifs VALUES(100,'LESOIF','Jacques','M',30,9); INSERT INTO Sportifs VALUES(101,'SWERTVAEGER','Eric','M',30,5); INSERT INTO Sportifs VALUES(102,'DUVAL','Alain','M',30,2); INSERT INTO Sportifs VALUES(103,'LEMENOREL','Claude','M',30,4); INSERT INTO Sportifs VALUES(104,'SEHIER','Dominique','F',30,1); INSERT INTO Sportifs VALUES(105,'STILO','Philippe','M',30,3); INSERT INTO Sportifs VALUES(106,'LE BANNARD','Gérard','M',30,1); INSERT INTO Sportifs VALUES(107,'BORNE','Jean-Yves','M',30,9); INSERT INTO Sportifs VALUES(108,'LAURENCE','Serge','M',30,4); INSERT INTO Sportifs VALUES(109,'SAUVAGE','Patrick','M',30,5); INSERT INTO Sportifs VALUES(110,'ROULLAND','Christian','M',30,4); INSERT INTO Sportifs VALUES(111,'LESIEUR','Michel','M',30,8); INSERT INTO Sportifs VALUES(112,'LUYCKX','Gérard','M',30,2); INSERT INTO Sportifs VALUES(113,'AVICE','Benoît','M',30,2); INSERT INTO Sportifs VALUES(114,'MICHEL','Danielle','F',22,5); INSERT INTO Sportifs VALUES(115,'LEMOUSSU','Laurent','M',30,1); INSERT INTO Sportifs VALUES(116,'BELUAU','Gilberte','F',30,8); INSERT INTO Sportifs VALUES(117,'FERREIRA','Martine','F',30,2); INSERT INTO Sportifs VALUES(118,'FROMENT','Philippe','M',30,2); INSERT INTO Sportifs VALUES(119,'GUITON','Jean-paul','M',30,1); INSERT INTO Sportifs VALUES(120,'LECOMTE','Christian','M',30,6); INSERT INTO Sportifs VALUES(121,'HUET','Loïc','M',30,5); INSERT INTO Sportifs VALUES(122,'BECQUET','Erika','F',30,6); INSERT INTO Sportifs VALUES(123,'LETHIMONNIER','Victor','M',30,6); INSERT INTO Sportifs VALUES(124,'SWERTVAEGER','Michelle','F',30,2); INSERT INTO Sportifs VALUES(125,'JALON','Patrick','M',30,2); INSERT INTO Sportifs VALUES(126,'DEBOUT','Eric','M',30,5); INSERT INTO Sportifs VALUES(127,'GASTELLIER','Charles','M',30,2); INSERT INTO Sportifs VALUES(128,'GIRONIE','André','M',30,1); INSERT INTO Sportifs VALUES(129,'DABON','Richard','M',30,3); INSERT INTO Sportifs VALUES(130,'LECHAUVE','Jean-Claude','M',30,5); INSERT INTO Sportifs VALUES(131,'GALLOIS','Michelle','F',30,2); INSERT INTO Sportifs VALUES(132,'DORON','Yannick','M',30,1); INSERT INTO Sportifs VALUES(133,'LENEVEU','Julien','M',30,2); INSERT INTO Sportifs VALUES(134,'LERICHE','Harry','M',30,5); INSERT INTO Sportifs VALUES(135,'MANCEL','Jean-luc','M',30,4); INSERT INTO Sportifs VALUES(136,'LABOULAIS','Chloé','F',26,2); INSERT INTO Sportifs VALUES(137,'DUDOUIT','Chloé','F',26,2); INSERT INTO Sportifs VALUES(138,'MADELAINE','Chloé','F',26,1); INSERT INTO Sportifs VALUES(139,'BESNARD','Chloé','F',26,4); INSERT INTO Sportifs VALUES(140,'BELZ','Chloé','F',26,7); INSERT INTO Sportifs VALUES(141,'BONNET','Chloé','F',26,5); INSERT INTO Sportifs VALUES(142,'CORNET','Chloé','F',26,1); INSERT INTO Sportifs VALUES(143,'BEUZELIN','Chloé','F',26,5); INSERT INTO Sportifs VALUES(144,'GRANDIDIER','Chloé','F',26,2); INSERT INTO Sportifs VALUES(145,'LENEVEU','Marie','F',25,2); INSERT INTO Sportifs VALUES(146,'DABON','Rick','M',25,3); INSERT INTO Sportifs VALUES(147,'CLERICE','Alice','F',25,2); INSERT INTO Sportifs VALUES(148,'COMES','Marie','F',27,1); INSERT INTO Sportifs VALUES(149,'BELZ','Sylvianne','F',27,7); INSERT INTO Sportifs VALUES(150,'BELZ','Paul','M',25,2); /* TABLE Sports : */ INSERT INTO Sports VALUES(1,'Basket ball'); INSERT INTO Sports VALUES(2,'Volley ball'); INSERT INTO Sports VALUES(3,'Hand ball'); INSERT INTO Sports VALUES(4,'Tennis'); INSERT INTO Sports VALUES(5,'Hockey'); INSERT INTO Sports VALUES(6,'Badmington'); INSERT INTO Sports VALUES(7,'Ping pong'); INSERT INTO Sports VALUES(8,'Football'); /* TABLE Gymnases : */ INSERT INTO Gymnases VALUES(1,'PAUL ELUARD','2 rue des pépines','STAINS',200); INSERT INTO Gymnases VALUES(2,'ARAGON','Place du Chartres','MONTMORENCY',450); INSERT INTO Gymnases VALUES(3,'SAINT EXUPERY','47 bvd des brumes','PIERREFITTE',400); INSERT INTO Gymnases VALUES(4,'PAUL ELUARD','Allée J.B. Lulli','SARCELLES',500); INSERT INTO Gymnases VALUES(5,'BRASSENS','153 square Loliot','SARCELLES',620); INSERT INTO Gymnases VALUES(6,'VERLAINE','14 bvd Serrault','STAINS',400); INSERT INTO Gymnases VALUES(7,'JULES FERRY','45 rue de la gare','PIERREFITTE',360); INSERT INTO Gymnases VALUES(8,'PREVERT','12 rue des collines','MONTMORENCY',420); INSERT INTO Gymnases VALUES(9,'CAMUS','3 esplanade des quatrans','SARCELLES',620); INSERT INTO Gymnases VALUES(10,'RIMBAUD','140 bvd Diderot','STAINS',400); INSERT INTO Gymnases VALUES(11,'LAMARTINE','7 rue de la souris verte','PIERREFITTE',300); INSERT INTO Gymnases VALUES(12,'MOZART','6 Allée Rosana','MONTMORENCY',480); INSERT INTO Gymnases VALUES(13,'RAVEL','Place aux pommes','STAINS',200); INSERT INTO Gymnases VALUES(14,'CHOPIN','23 rue Carafelli','MONTMORENCY',500); INSERT INTO Gymnases VALUES(15,'BREL','4 rue de la miséricorde','PIERREFITTE',400); INSERT INTO Gymnases VALUES(16,'SAMOURAI','4 Allée des pendules','SARCELLES',600); INSERT INTO Gymnases VALUES(17,'GARCIA LORCA','45 bvd des Comes','STAINS',400); INSERT INTO Gymnases VALUES(18,'PABLO NERUDA','6 rue saint Jean','PIERREFITTE',450); INSERT INTO Gymnases VALUES(19,'COCTEAU','45 bis rue du moulin rouge','MONTMORENCY',500); INSERT INTO Gymnases VALUES(20,'LUMIERES','78 rue Vendôme','SARCELLES',400); INSERT INTO Gymnases VALUES(21,'SIMON','8 bvd général de Gaulle','STAINS',400); INSERT INTO Gymnases VALUES(22,'BARBARA','45 rue du bossu','SAINT DENIS',500); INSERT INTO Gymnases VALUES(23,'ARAGON','10 Bvd Lenoir','SAINT DENIS',520); INSERT INTO Gymnases VALUES(24,'BELFEGOR','Place de Gaulle','SAINT DENIS',450); INSERT INTO Gymnases VALUES(25,'DOLTO','3 square Plaisir','VILLETANEUSE',620); INSERT INTO Gymnases VALUES(26,'MERMOZ','41 rue des ponts','VILLETANEUSE',600); INSERT INTO Gymnases VALUES(27,'PASCAL','20 rue de la pirogue','VILLETANEUSE',350); /* TABLE Arbitrer : */ INSERT INTO Arbitrer VALUES(1,1); INSERT INTO Arbitrer VALUES(1,2); INSERT INTO Arbitrer VALUES(1,5); INSERT INTO Arbitrer VALUES(2,5); INSERT INTO Arbitrer VALUES(2,8); INSERT INTO Arbitrer VALUES(3,2); INSERT INTO Arbitrer VALUES(3,6); INSERT INTO Arbitrer VALUES(3,7); INSERT INTO Arbitrer VALUES(4,1); INSERT INTO Arbitrer VALUES(4,2); INSERT INTO Arbitrer VALUES(4,7); INSERT INTO Arbitrer VALUES(4,9); INSERT INTO Arbitrer VALUES(5,7); INSERT INTO Arbitrer VALUES(6,1); INSERT INTO Arbitrer VALUES(6,5); INSERT INTO Arbitrer VALUES(6,7); INSERT INTO Arbitrer VALUES(7,2); INSERT INTO Arbitrer VALUES(7,3); INSERT INTO Arbitrer VALUES(7,5); INSERT INTO Arbitrer VALUES(19,2); INSERT INTO Arbitrer VALUES(20,2); INSERT INTO Arbitrer VALUES(29,7); INSERT INTO Arbitrer VALUES(32,7); INSERT INTO Arbitrer VALUES(35,6); INSERT INTO Arbitrer VALUES(59,4); INSERT INTO Arbitrer VALUES(60,2); INSERT INTO Arbitrer VALUES(94,1); INSERT INTO Arbitrer VALUES(98,1); INSERT INTO Arbitrer VALUES(105,1); INSERT INTO Arbitrer VALUES(149,1); INSERT INTO Arbitrer VALUES(151,1); /* TABLE Entrainer : */ INSERT INTO Entrainer VALUES(1,1); INSERT INTO Entrainer VALUES(1,2); INSERT INTO Entrainer VALUES(1,3); INSERT INTO Entrainer VALUES(1,5); INSERT INTO Entrainer VALUES(1,6); INSERT INTO Entrainer VALUES(2,1); INSERT INTO Entrainer VALUES(2,2); INSERT INTO Entrainer VALUES(2,3); INSERT INTO Entrainer VALUES(2,4); INSERT INTO Entrainer VALUES(2,5); INSERT INTO Entrainer VALUES(2,6); INSERT INTO Entrainer VALUES(2,7); INSERT INTO Entrainer VALUES(2,9); INSERT INTO Entrainer VALUES(3,1); INSERT INTO Entrainer VALUES(3,2); INSERT INTO Entrainer VALUES(3,3); INSERT INTO Entrainer VALUES(3,6); INSERT INTO Entrainer VALUES(4,1); INSERT INTO Entrainer VALUES(4,7); INSERT INTO Entrainer VALUES(4,9); INSERT INTO Entrainer VALUES(6,5); INSERT INTO Entrainer VALUES(6,7); INSERT INTO Entrainer VALUES(6,9); INSERT INTO Entrainer VALUES(7,2); INSERT INTO Entrainer VALUES(7,3); INSERT INTO Entrainer VALUES(7,5); INSERT INTO Entrainer VALUES(7,6); INSERT INTO Entrainer VALUES(29,7); INSERT INTO Entrainer VALUES(30,7); INSERT INTO Entrainer VALUES(31,7); INSERT INTO Entrainer VALUES(32,7); INSERT INTO Entrainer VALUES(35,6); INSERT INTO Entrainer VALUES(35,7); INSERT INTO Entrainer VALUES(36,6); INSERT INTO Entrainer VALUES(38,7); INSERT INTO Entrainer VALUES(40,6); INSERT INTO Entrainer VALUES(40,7); INSERT INTO Entrainer VALUES(48,6); INSERT INTO Entrainer VALUES(50,6); INSERT INTO Entrainer VALUES(56,6); INSERT INTO Entrainer VALUES(57,2); INSERT INTO Entrainer VALUES(57,4); INSERT INTO Entrainer VALUES(58,2); INSERT INTO Entrainer VALUES(58,4); INSERT INTO Entrainer VALUES(59,2); INSERT INTO Entrainer VALUES(59,4); INSERT INTO Entrainer VALUES(60,2); INSERT INTO Entrainer VALUES(60,4); INSERT INTO Entrainer VALUES(60,7); INSERT INTO Entrainer VALUES(61,2); INSERT INTO Entrainer VALUES(61,4); INSERT INTO Entrainer VALUES(149,1); INSERT INTO Entrainer VALUES(151,1); /* TABLE Jouer : */ INSERT INTO Jouer VALUES(1,2); INSERT INTO Jouer VALUES(1,4); INSERT INTO Jouer VALUES(1,8); INSERT INTO Jouer VALUES(2,1); INSERT INTO Jouer VALUES(2,2); INSERT INTO Jouer VALUES(2,7); INSERT INTO Jouer VALUES(2,8); INSERT INTO Jouer VALUES(3,2); INSERT INTO Jouer VALUES(3,7); INSERT INTO Jouer VALUES(4,2); INSERT INTO Jouer VALUES(4,8); INSERT INTO Jouer VALUES(5,1); INSERT INTO Jouer VALUES(5,2); INSERT INTO Jouer VALUES(5,6); INSERT INTO Jouer VALUES(5,7); INSERT INTO Jouer VALUES(6,1); INSERT INTO Jouer VALUES(6,2); INSERT INTO Jouer VALUES(6,3); INSERT INTO Jouer VALUES(6,7); INSERT INTO Jouer VALUES(7,2); INSERT INTO Jouer VALUES(7,4); INSERT INTO Jouer VALUES(7,8); INSERT INTO Jouer VALUES(9,2); INSERT INTO Jouer VALUES(9,4); INSERT INTO Jouer VALUES(9,6); INSERT INTO Jouer VALUES(10,2); INSERT INTO Jouer VALUES(10,4); INSERT INTO Jouer VALUES(10,6); INSERT INTO Jouer VALUES(10,8); INSERT INTO Jouer VALUES(11,2); INSERT INTO Jouer VALUES(11,4); INSERT INTO Jouer VALUES(11,8); INSERT INTO Jouer VALUES(12,2); INSERT INTO Jouer VALUES(12,4); INSERT INTO Jouer VALUES(12,8); INSERT INTO Jouer VALUES(13,2); INSERT INTO Jouer VALUES(13,6); INSERT INTO Jouer VALUES(13,8); INSERT INTO Jouer VALUES(14,1); INSERT INTO Jouer VALUES(14,2); INSERT INTO Jouer VALUES(14,7); INSERT INTO Jouer VALUES(15,2); INSERT INTO Jouer VALUES(15,4); INSERT INTO Jouer VALUES(15,8); INSERT INTO Jouer VALUES(16,2); INSERT INTO Jouer VALUES(16,8); INSERT INTO Jouer VALUES(17,2); INSERT INTO Jouer VALUES(17,6); INSERT INTO Jouer VALUES(17,8); INSERT INTO Jouer VALUES(18,2); INSERT INTO Jouer VALUES(19,2); INSERT INTO Jouer VALUES(19,3); INSERT INTO Jouer VALUES(19,8); INSERT INTO Jouer VALUES(20,1); INSERT INTO Jouer VALUES(20,2); INSERT INTO Jouer VALUES(20,3); INSERT INTO Jouer VALUES(20,7); INSERT INTO Jouer VALUES(20,8); INSERT INTO Jouer VALUES(21,2); INSERT INTO Jouer VALUES(21,4); INSERT INTO Jouer VALUES(21,6); INSERT INTO Jouer VALUES(21,8); INSERT INTO Jouer VALUES(22,1); INSERT INTO Jouer VALUES(22,2); INSERT INTO Jouer VALUES(22,7); INSERT INTO Jouer VALUES(22,8); INSERT INTO Jouer VALUES(23,2); INSERT INTO Jouer VALUES(23,4); INSERT INTO Jouer VALUES(23,8); INSERT INTO Jouer VALUES(24,1); INSERT INTO Jouer VALUES(24,2); INSERT INTO Jouer VALUES(24,6); INSERT INTO Jouer VALUES(24,7); INSERT INTO Jouer VALUES(25,2); INSERT INTO Jouer VALUES(25,3); INSERT INTO Jouer VALUES(25,4); INSERT INTO Jouer VALUES(25,6); INSERT INTO Jouer VALUES(25,8); INSERT INTO Jouer VALUES(26,2); INSERT INTO Jouer VALUES(26,3); INSERT INTO Jouer VALUES(26,4); INSERT INTO Jouer VALUES(26,6); INSERT INTO Jouer VALUES(27,2); INSERT INTO Jouer VALUES(27,3); INSERT INTO Jouer VALUES(27,4); INSERT INTO Jouer VALUES(27,6); INSERT INTO Jouer VALUES(27,8); INSERT INTO Jouer VALUES(28,1); INSERT INTO Jouer VALUES(28,2); INSERT INTO Jouer VALUES(28,3); INSERT INTO Jouer VALUES(28,7); INSERT INTO Jouer VALUES(28,8); INSERT INTO Jouer VALUES(29,2); INSERT INTO Jouer VALUES(29,3); INSERT INTO Jouer VALUES(29,6); INSERT INTO Jouer VALUES(29,7); INSERT INTO Jouer VALUES(30,2); INSERT INTO Jouer VALUES(30,3); INSERT INTO Jouer VALUES(30,7); INSERT INTO Jouer VALUES(30,8); INSERT INTO Jouer VALUES(31,2); INSERT INTO Jouer VALUES(31,3); INSERT INTO Jouer VALUES(31,6); INSERT INTO Jouer VALUES(31,8); INSERT INTO Jouer VALUES(32,1); INSERT INTO Jouer VALUES(32,2); INSERT INTO Jouer VALUES(32,3); INSERT INTO Jouer VALUES(32,6); INSERT INTO Jouer VALUES(32,7); INSERT INTO Jouer VALUES(32,8); INSERT INTO Jouer VALUES(33,2); INSERT INTO Jouer VALUES(33,3); INSERT INTO Jouer VALUES(33,6); INSERT INTO Jouer VALUES(33,8); INSERT INTO Jouer VALUES(34,2); INSERT INTO Jouer VALUES(34,3); INSERT INTO Jouer VALUES(34,7); INSERT INTO Jouer VALUES(34,8); INSERT INTO Jouer VALUES(35,1); INSERT INTO Jouer VALUES(35,2); INSERT INTO Jouer VALUES(35,3); INSERT INTO Jouer VALUES(35,7); INSERT INTO Jouer VALUES(35,8); INSERT INTO Jouer VALUES(36,1); INSERT INTO Jouer VALUES(36,2); INSERT INTO Jouer VALUES(36,7); INSERT INTO Jouer VALUES(36,8); INSERT INTO Jouer VALUES(37,2); INSERT INTO Jouer VALUES(38,3); INSERT INTO Jouer VALUES(38,6); INSERT INTO Jouer VALUES(38,8); INSERT INTO Jouer VALUES(39,3); INSERT INTO Jouer VALUES(39,8); INSERT INTO Jouer VALUES(40,1); INSERT INTO Jouer VALUES(40,3); INSERT INTO Jouer VALUES(40,6); INSERT INTO Jouer VALUES(40,7); INSERT INTO Jouer VALUES(40,8); INSERT INTO Jouer VALUES(41,4); INSERT INTO Jouer VALUES(41,6); INSERT INTO Jouer VALUES(42,4); INSERT INTO Jouer VALUES(42,6); INSERT INTO Jouer VALUES(42,8); INSERT INTO Jouer VALUES(43,3); INSERT INTO Jouer VALUES(43,4); INSERT INTO Jouer VALUES(43,6); INSERT INTO Jouer VALUES(44,1); INSERT INTO Jouer VALUES(44,7); INSERT INTO Jouer VALUES(44,8); INSERT INTO Jouer VALUES(45,4); INSERT INTO Jouer VALUES(45,8); INSERT INTO Jouer VALUES(46,4); INSERT INTO Jouer VALUES(46,8); INSERT INTO Jouer VALUES(47,4); INSERT INTO Jouer VALUES(48,1); INSERT INTO Jouer VALUES(48,6); INSERT INTO Jouer VALUES(48,7); INSERT INTO Jouer VALUES(49,1); INSERT INTO Jouer VALUES(49,7); INSERT INTO Jouer VALUES(50,1); INSERT INTO Jouer VALUES(50,6); INSERT INTO Jouer VALUES(50,7); INSERT INTO Jouer VALUES(50,8); INSERT INTO Jouer VALUES(51,1); INSERT INTO Jouer VALUES(51,3); INSERT INTO Jouer VALUES(51,7); INSERT INTO Jouer VALUES(51,8); INSERT INTO Jouer VALUES(52,1); INSERT INTO Jouer VALUES(52,6); INSERT INTO Jouer VALUES(52,7); INSERT INTO Jouer VALUES(52,8); INSERT INTO Jouer VALUES(53,1); INSERT INTO Jouer VALUES(53,6); INSERT INTO Jouer VALUES(53,7); INSERT INTO Jouer VALUES(53,8); INSERT INTO Jouer VALUES(54,6); INSERT INTO Jouer VALUES(54,7); INSERT INTO Jouer VALUES(54,8); INSERT INTO Jouer VALUES(55,6); INSERT INTO Jouer VALUES(55,7); INSERT INTO Jouer VALUES(55,8); INSERT INTO Jouer VALUES(56,1); INSERT INTO Jouer VALUES(56,7); INSERT INTO Jouer VALUES(57,4); INSERT INTO Jouer VALUES(57,8); INSERT INTO Jouer VALUES(58,1); INSERT INTO Jouer VALUES(58,6); INSERT INTO Jouer VALUES(58,7); INSERT INTO Jouer VALUES(58,8); INSERT INTO Jouer VALUES(59,1); INSERT INTO Jouer VALUES(59,6); INSERT INTO Jouer VALUES(59,7); INSERT INTO Jouer VALUES(60,3); INSERT INTO Jouer VALUES(60,4); INSERT INTO Jouer VALUES(60,8); INSERT INTO Jouer VALUES(61,8); INSERT INTO Jouer VALUES(62,8); INSERT INTO Jouer VALUES(63,1); INSERT INTO Jouer VALUES(63,7); INSERT INTO Jouer VALUES(63,8); INSERT INTO Jouer VALUES(64,4); INSERT INTO Jouer VALUES(65,8); INSERT INTO Jouer VALUES(66,8); INSERT INTO Jouer VALUES(67,3); INSERT INTO Jouer VALUES(67,4); INSERT INTO Jouer VALUES(68,3); INSERT INTO Jouer VALUES(69,1); INSERT INTO Jouer VALUES(69,3); INSERT INTO Jouer VALUES(69,7); INSERT INTO Jouer VALUES(70,7); INSERT INTO Jouer VALUES(70,8); INSERT INTO Jouer VALUES(71,4); INSERT INTO Jouer VALUES(71,8); INSERT INTO Jouer VALUES(72,3); INSERT INTO Jouer VALUES(72,4); INSERT INTO Jouer VALUES(72,6); INSERT INTO Jouer VALUES(72,8); INSERT INTO Jouer VALUES(73,4); INSERT INTO Jouer VALUES(73,8); INSERT INTO Jouer VALUES(74,4); INSERT INTO Jouer VALUES(74,8); INSERT INTO Jouer VALUES(75,3); INSERT INTO Jouer VALUES(75,7); INSERT INTO Jouer VALUES(76,4); INSERT INTO Jouer VALUES(77,1); INSERT INTO Jouer VALUES(77,7); INSERT INTO Jouer VALUES(77,8); INSERT INTO Jouer VALUES(78,8); INSERT INTO Jouer VALUES(79,8); INSERT INTO Jouer VALUES(80,1); INSERT INTO Jouer VALUES(80,7); INSERT INTO Jouer VALUES(80,8); INSERT INTO Jouer VALUES(82,8); INSERT INTO Jouer VALUES(83,3); INSERT INTO Jouer VALUES(83,4); INSERT INTO Jouer VALUES(83,8); INSERT INTO Jouer VALUES(84,3); INSERT INTO Jouer VALUES(84,8); INSERT INTO Jouer VALUES(85,1); INSERT INTO Jouer VALUES(85,7); INSERT INTO Jouer VALUES(85,8); INSERT INTO Jouer VALUES(86,4); INSERT INTO Jouer VALUES(86,8); INSERT INTO Jouer VALUES(87,4); INSERT INTO Jouer VALUES(87,8); INSERT INTO Jouer VALUES(88,1); INSERT INTO Jouer VALUES(88,7); INSERT INTO Jouer VALUES(88,8); INSERT INTO Jouer VALUES(89,3); INSERT INTO Jouer VALUES(89,8); INSERT INTO Jouer VALUES(90,4); INSERT INTO Jouer VALUES(90,8); INSERT INTO Jouer VALUES(91,1); INSERT INTO Jouer VALUES(91,7); INSERT INTO Jouer VALUES(91,8); INSERT INTO Jouer VALUES(92,6); INSERT INTO Jouer VALUES(92,8); INSERT INTO Jouer VALUES(93,8); INSERT INTO Jouer VALUES(94,1); INSERT INTO Jouer VALUES(94,3); INSERT INTO Jouer VALUES(94,7); INSERT INTO Jouer VALUES(94,8); INSERT INTO Jouer VALUES(95,8); INSERT INTO Jouer VALUES(96,4); INSERT INTO Jouer VALUES(96,8); INSERT INTO Jouer VALUES(97,4); INSERT INTO Jouer VALUES(97,8); INSERT INTO Jouer VALUES(98,1); INSERT INTO Jouer VALUES(98,3); INSERT INTO Jouer VALUES(98,7); INSERT INTO Jouer VALUES(98,8); INSERT INTO Jouer VALUES(99,8); INSERT INTO Jouer VALUES(100,3); INSERT INTO Jouer VALUES(100,8); INSERT INTO Jouer VALUES(101,3); INSERT INTO Jouer VALUES(101,4); INSERT INTO Jouer VALUES(101,8); INSERT INTO Jouer VALUES(102,4); INSERT INTO Jouer VALUES(102,8); INSERT INTO Jouer VALUES(103,4); INSERT INTO Jouer VALUES(103,8); INSERT INTO Jouer VALUES(104,3); INSERT INTO Jouer VALUES(104,4); INSERT INTO Jouer VALUES(105,1); INSERT INTO Jouer VALUES(105,3); INSERT INTO Jouer VALUES(105,7); INSERT INTO Jouer VALUES(105,8); INSERT INTO Jouer VALUES(106,8); INSERT INTO Jouer VALUES(107,8); INSERT INTO Jouer VALUES(108,1); INSERT INTO Jouer VALUES(108,7); INSERT INTO Jouer VALUES(108,8); INSERT INTO Jouer VALUES(109,1); INSERT INTO Jouer VALUES(109,3); INSERT INTO Jouer VALUES(109,7); INSERT INTO Jouer VALUES(109,8); INSERT INTO Jouer VALUES(110,3); INSERT INTO Jouer VALUES(110,4); INSERT INTO Jouer VALUES(110,8); INSERT INTO Jouer VALUES(111,3); INSERT INTO Jouer VALUES(111,8); INSERT INTO Jouer VALUES(112,3); INSERT INTO Jouer VALUES(112,8); INSERT INTO Jouer VALUES(113,4); INSERT INTO Jouer VALUES(113,8); INSERT INTO Jouer VALUES(114,3); INSERT INTO Jouer VALUES(114,4); INSERT INTO Jouer VALUES(114,6); INSERT INTO Jouer VALUES(115,8); INSERT INTO Jouer VALUES(118,1); INSERT INTO Jouer VALUES(118,7); INSERT INTO Jouer VALUES(118,8); INSERT INTO Jouer VALUES(119,8); INSERT INTO Jouer VALUES(120,4); INSERT INTO Jouer VALUES(120,8); INSERT INTO Jouer VALUES(121,8); INSERT INTO Jouer VALUES(122,4); INSERT INTO Jouer VALUES(123,1); INSERT INTO Jouer VALUES(123,3); INSERT INTO Jouer VALUES(123,7); INSERT INTO Jouer VALUES(123,8); INSERT INTO Jouer VALUES(124,3); INSERT INTO Jouer VALUES(125,1); INSERT INTO Jouer VALUES(125,7); INSERT INTO Jouer VALUES(125,8); INSERT INTO Jouer VALUES(126,4); INSERT INTO Jouer VALUES(126,8); INSERT INTO Jouer VALUES(127,4); INSERT INTO Jouer VALUES(127,8); INSERT INTO Jouer VALUES(128,4); INSERT INTO Jouer VALUES(128,8); INSERT INTO Jouer VALUES(129,1); INSERT INTO Jouer VALUES(129,7); INSERT INTO Jouer VALUES(129,8); INSERT INTO Jouer VALUES(130,8); INSERT INTO Jouer VALUES(132,1); INSERT INTO Jouer VALUES(132,7); INSERT INTO Jouer VALUES(132,8); INSERT INTO Jouer VALUES(133,8); INSERT INTO Jouer VALUES(134,8); INSERT INTO Jouer VALUES(135,3); INSERT INTO Jouer VALUES(135,8); INSERT INTO Jouer VALUES(136,4); INSERT INTO Jouer VALUES(137,4); INSERT INTO Jouer VALUES(138,3); INSERT INTO Jouer VALUES(138,4); INSERT INTO Jouer VALUES(139,4); INSERT INTO Jouer VALUES(140,4); INSERT INTO Jouer VALUES(141,4); INSERT INTO Jouer VALUES(142,4); INSERT INTO Jouer VALUES(143,4); INSERT INTO Jouer VALUES(144,4); INSERT INTO Jouer VALUES(149,1); INSERT INTO Jouer VALUES(151,1); /* TABLE Seances : */ INSERT INTO Seances VALUES(1,1,149,'Samedi',9,60); INSERT INTO Seances VALUES(1,3,1,'Lundi',9,60); INSERT INTO Seances VALUES(1,3,1,'Lundi',10,60); INSERT INTO Seances VALUES(1,3,1,'Lundi',11.3,60); INSERT INTO Seances VALUES(1,3,1,'Lundi',14,90); INSERT INTO Seances VALUES(1,3,1,'lundi',17.3,120); INSERT INTO Seances VALUES(1,3,1,'Lundi',19.3,120); INSERT INTO Seances VALUES(1,3,2,'Dimanche',17.3,120); INSERT INTO Seances VALUES(1,3,2,'Dimanche',19.3,120); INSERT INTO Seances VALUES(1,3,2,'mardi',17.3,120); INSERT INTO Seances VALUES(1,3,2,'mercredi',17.3,120); INSERT INTO Seances VALUES(1,3,2,'Samedi',15.3,60); INSERT INTO Seances VALUES(1,3,2,'Samedi',16.3,60); INSERT INTO Seances VALUES(1,3,2,'Samedi',17.3,120); INSERT INTO Seances VALUES(1,3,3,'jeudi',20,30); INSERT INTO Seances VALUES(1,3,3,'lundi',14,60); INSERT INTO Seances VALUES(1,3,3,'lundi',18,30); INSERT INTO Seances VALUES(1,3,3,'lundi',19,30); INSERT INTO Seances VALUES(1,3,3,'lundi',20,30); INSERT INTO Seances VALUES(1,5,7,'mercredi',17,90); INSERT INTO Seances VALUES(2,2,57,'dimanche',17,60); INSERT INTO Seances VALUES(3,1,149,'Mercredi',11,30); INSERT INTO Seances VALUES(3,2,57,'lundi',16.3,90); INSERT INTO Seances VALUES(3,2,60,'jeudi',19,60); INSERT INTO Seances VALUES(4,1,149,'Vendredi',10,30); INSERT INTO Seances VALUES(4,5,6,'mercredi',19,60); INSERT INTO Seances VALUES(5,2,57,'lundi',16.3,90); INSERT INTO Seances VALUES(5,5,6,'jeudi',19,60); INSERT INTO Seances VALUES(6,5,6,'vendredi',19,60); INSERT INTO Seances VALUES(6,5,7,'jeudi',17,90); INSERT INTO Seances VALUES(8,2,57,'dimanche',17,60); INSERT INTO Seances VALUES(8,2,57,'lundi',16.3,90); INSERT INTO Seances VALUES(8,2,60,'vendredi',19,60); INSERT INTO Seances VALUES(8,5,7,'samedi',17,90); INSERT INTO Seances VALUES(8,5,7,'vendredi',14,120); INSERT INTO Seances VALUES(9,5,6,'samedi',19,60); INSERT INTO Seances VALUES(10,2,60,'samedi',19,60); INSERT INTO Seances VALUES(10,5,6,'dimanche',19,60); INSERT INTO Seances VALUES(10,5,7,'dimanche',17,90); INSERT INTO Seances VALUES(12,2,57,'dimanche',17,60); INSERT INTO Seances VALUES(13,2,60,'dimanche',19,60); INSERT INTO Seances VALUES(13,5,6,'mercredi',20,60); INSERT INTO Seances VALUES(13,5,7,'lundi',17,90); INSERT INTO Seances VALUES(14,1,149,'Mardi',10,60); INSERT INTO Seances VALUES(14,2,57,'dimanche',17,60); INSERT INTO Seances VALUES(15,2,57,'lundi',16.3,90); INSERT INTO Seances VALUES(16,2,57,'lundi',16.3,90); INSERT INTO Seances VALUES(16,2,60,'Lundi',17,60); INSERT INTO Seances VALUES(16,2,60,'Lundi',18,60); INSERT INTO Seances VALUES(16,2,60,'lundi',19,60); INSERT INTO Seances VALUES(16,2,60,'Lundi',20,60); INSERT INTO Seances VALUES(16,5,6,'mercredi',19,60); INSERT INTO Seances VALUES(17,2,3,'samedi',17.3,120); INSERT INTO Seances VALUES(17,2,3,'vendredi',17.3,120); INSERT INTO Seances VALUES(17,2,57,'dimanche',17,60); INSERT INTO Seances VALUES(17,3,3,'dimanche',18,30); INSERT INTO Seances VALUES(17,3,3,'mardi',20,30); INSERT INTO Seances VALUES(17,5,7,'mardi',17,90); INSERT INTO Seances VALUES(18,2,57,'lundi',16.3,90); INSERT INTO Seances VALUES(18,2,60,'mardi',19,60); INSERT INTO Seances VALUES(18,5,7,'mercredi',14,120); INSERT INTO Seances VALUES(18,5,7,'mercredi',16,90); INSERT INTO Seances VALUES(19,2,57,'dimanche',17,60); INSERT INTO Seances VALUES(20,5,6,'mercredi',19,60); INSERT INTO Seances VALUES(21,2,57,'lundi',16.3,30); INSERT INTO Seances VALUES(21,2,60,'mardi',19,60); INSERT INTO Seances VALUES(21,5,7,'mercredi',17,30); INSERT INTO Seances VALUES(22,2,57,'mardi',10,30); INSERT INTO Seances VALUES(24,1,149,'Jeudi',9,90); INSERT INTO Seances VALUES(24,2,57,'mercredi',10,90); INSERT INTO Seances VALUES(25,1,149,'Dimanche',18,60); INSERT INTO Seances VALUES(27,2,57,'jeudi',10,90); INSERT INTO Seances VALUES(27,5,7,'mercredi',14,120); INSERT INTO Seances VALUES(27,5,7,'mercredi',17,90); INSERT INTO Seances VALUES(28,1,149,'Lundi',9,30); INSERT INTO Seances VALUES(28,5,6,'dimanche',14,60); INSERT INTO Seances VALUES(28,5,6,'dimanche',15,60); INSERT INTO Seances VALUES(28,5,6,'dimanche',16,60); INSERT INTO Seances VALUES(28,5,6,'dimanche',17,60); INSERT INTO Seances VALUES(28,5,7,'mardi',18,90); INSERT INTO Seances VALUES(28,5,7,'samedi',18,90); COMMIT;