INSERT INTO `tbl_etudiant_cours_es` (`id_etd_cours_es`, `id_etudiant_es`, `id_seance_es`, `presence_etd_es`, `com_sur_etd_es`, `credit_cours_es`, `info_abs_etd_es`, `autoris_abs_etd_es`, `justif_abs_etd_es`) VALUES
(6937, 36, 330, NULL, NULL, NULL, NULL, NULL, NULL),
(6938, 37, 330, NULL, NULL, NULL, NULL, NULL, NULL),
(6939, 38, 330, NULL, NULL, NULL, NULL, NULL, NULL),
(6940, 39, 330, NULL, NULL, NULL, NULL, NULL, NULL),
(6941, 40, 330, NULL, NULL, NULL, NULL, NULL, NULL),
(6942, 41, 330, NULL, NULL, NULL, NULL, NULL, NULL),
(6943, 45, 330, NULL, NULL, NULL, NULL, NULL, NULL),
(6944, 46, 330, NULL, NULL, NULL, NULL, NULL, NULL),
(6945, 47, 330, NULL, NULL, NULL, NULL, NULL, NULL),
(6946, 48, 330, NULL, NULL, NULL, NULL, NULL, NULL),
(6947, 49, 330, NULL, NULL, NULL, NULL, NULL, NULL),
(6948, 50, 330, NULL, NULL, NULL, NULL, NULL, NULL),
(6949, 51, 330, NULL, NULL, NULL, NULL, NULL, NULL),
(6950, 26, 331, NULL, NULL, NULL, NULL, NULL, NULL),
(6951, 27, 331, NULL, NULL, NULL, NULL, NULL, NULL),
(6952, 28, 331, NULL, NULL, NULL, NULL, NULL, NULL),
(6953, 29, 331, NULL, NULL, NULL, NULL, NULL, NULL),
(6954, 30, 331, NULL, NULL, NULL, NULL, NULL, NULL),
(6955, 31, 331, NULL, NULL, NULL, NULL, NULL, NULL),
(6956, 32, 331, NULL, NULL, NULL, NULL, NULL, NULL),
(6957, 33, 331, NULL, NULL, NULL, NULL, NULL, NULL),
(6958, 34, 331, NULL, NULL, NULL, NULL, NULL, NULL),
(6959, 35, 331, NULL, NULL, NULL, NULL, NULL, NULL),
(6960, 36, 331, NULL, NULL, NULL, NULL, NULL, NULL),
(6961, 37, 331, NULL, NULL, NULL, NULL, NULL, NULL),
(6962, 38, 331, NULL, NULL, NULL, NULL, NULL, NULL),
(6963, 39, 331, NULL, NULL, NULL, NULL, NULL, NULL),
(6964, 40, 331, NULL, NULL, NULL, NULL, NULL, NULL),
(6965, 41, 331, NULL, NULL, NULL, NULL, NULL, NULL),
(6966, 45, 331, NULL, NULL, NULL, NULL, NULL, NULL),
(6967, 46, 331, NULL, NULL, NULL, NULL, NULL, NULL),
(6968, 47, 331, NULL, NULL, NULL, NULL, NULL, NULL),
(6969, 48, 331, NULL, NULL, NULL, NULL, NULL, NULL),
(6970, 49, 331, NULL, NULL, NULL, NULL, NULL, NULL),
(6971, 50, 331, NULL, NULL, NULL, NULL, NULL, NULL),
(6972, 51, 331, NULL, NULL, NULL, NULL, NULL, NULL),
(6973, 26, 332, 'Présent(e)', NULL, NULL, NULL, NULL, NULL),
(6974, 27, 332, 'Présent(e)', NULL, NULL, NULL, NULL, NULL),
(6975, 28, 332, 'Absent(e)', NULL, NULL, NULL, NULL, NULL),
(6976, 29, 332, 'Présent(e)', NULL, NULL, NULL, NULL, NULL),
(6977, 30, 332, 'Absent(e)', NULL, NULL, NULL, NULL, NULL),
(6978, 31, 332, 'Présent(e)', NULL, NULL, NULL, NULL, NULL),
(6979, 32, 332, 'Présent(e)', NULL, NULL, NULL, NULL, NULL),
(6980, 33, 332, 'Présent(e)', NULL, NULL, NULL, NULL, NULL),
(6981, 34, 332, 'Présent(e)', NULL, NULL, NULL, NULL, NULL),
(6982, 35, 332, 'Présent(e)', NULL, NULL, NULL, NULL, NULL),
(6983, 36, 332, 'Absent(e)', NULL, NULL, NULL, NULL, NULL),
(6984, 37, 332, 'Présent(e)', NULL, NULL, NULL, NULL, NULL),
(6985, 38, 332, 'Présent(e)', NULL, NULL, NULL, NULL, NULL),
(6986, 39, 332, 'Absent(e)', NULL, NULL, NULL, NULL, NULL),
(6987, 40, 332, 'Absent(e)', NULL, NULL, NULL, NULL, NULL),
(6988, 41, 332, 'Absent(e)', NULL, NULL, NULL, NULL, NULL),
(6989, 45, 332, 'Absent(e)', NULL, NULL, NULL, NULL, NULL),
(6990, 46, 332, 'Présent(e)', NULL, NULL, NULL, NULL, NULL),
(6991, 47, 332, 'Absent(e)', NULL, NULL, NULL, NULL, NULL),
(6992, 48, 332, 'Présent(e)', NULL, NULL, NULL, NULL, NULL),
(6993, 49, 332, 'Présent(e)', NULL, NULL, NULL, NULL, NULL),
(6994, 50, 332, 'Présent(e)', NULL, NULL, NULL, NULL, NULL),
(6995, 51, 332, 'Présent(e)', NULL, NULL, NULL, NULL, NULL),
(6996, 26, 333, NULL, NULL, NULL, NULL, NULL, NULL),
(6997, 27, 333, NULL, NULL, NULL, NULL, NULL, NULL),
(6998, 28, 333, NULL, NULL, NULL, NULL, NULL, NULL),
(6999, 29, 333, NULL, NULL, NULL, NULL, NULL, NULL),
(7000, 30, 333, NULL, NULL, NULL, NULL, NULL, NULL),
(7001, 31, 333, NULL, NULL, NULL, NULL, NULL, NULL),
(7002, 32, 333, NULL, NULL, NULL, NULL, NULL, NULL),
(7003, 33, 333, NULL, NULL, NULL, NULL, NULL, NULL),
(7004, 34, 333, NULL, NULL, NULL, NULL, NULL, NULL),
(7005, 35, 333, NULL, NULL, NULL, NULL, NULL, NULL),
(7006, 36, 333, NULL, NULL, NULL, NULL, NULL, NULL),
(7007, 37, 333, NULL, NULL, NULL, NULL, NULL, NULL),
(7008, 38, 333, NULL, NULL, NULL, NULL, NULL, NULL),
(7009, 39, 333, NULL, NULL, NULL, NULL, NULL, NULL),
(7010, 40, 333, NULL, NULL, NULL, NULL, NULL, NULL),
(7011, 41, 333, NULL, NULL, NULL, NULL, NULL, NULL),
(7012, 45, 333, NULL, NULL, NULL, NULL, NULL, NULL),
(7013, 46, 333, NULL, NULL, NULL, NULL, NULL, NULL),
(7014, 47, 333, NULL, NULL, NULL, NULL, NULL, NULL),
(7015, 48, 333, NULL, NULL, NULL, NULL, NULL, NULL),
(7016, 49, 333, NULL, NULL, NULL, NULL, NULL, NULL),
(7017, 50, 333, NULL, NULL, NULL, NULL, NULL, NULL),
(7018, 51, 333, NULL, NULL, NULL, NULL, NULL, NULL),
(7019, 26, 334, NULL, NULL, NULL, NULL, NULL, NULL),
(7020, 27, 334, NULL, NULL, NULL, NULL, NULL, NULL),
(7021, 28, 334, NULL, NULL, NULL, NULL, NULL, NULL),
(7022, 29, 334, NULL, NULL, NULL, NULL, NULL, NULL),
(7023, 30, 334, NULL, NULL, NULL, NULL, NULL, NULL),
(7024, 31, 334, NULL, NULL, NULL, NULL, NULL, NULL),
(7025, 32, 334, NULL, NULL, NULL, NULL, NULL, NULL),
(7026, 33, 334, NULL, NULL, NULL, NULL, NULL, NULL),
(7027, 34, 334, NULL, NULL, NULL, NULL, NULL, NULL),
(7028, 35, 334, NULL, NULL, NULL, NULL, NULL, NULL),
(7029, 36, 334, NULL, NULL, NULL, NULL, NULL, NULL),
(7030, 37, 334, NULL, NULL, NULL, NULL, NULL, NULL),
(7031, 38, 334, NULL, NULL, NULL, NULL, NULL, NULL),
(7032, 39, 334, NULL, NULL, NULL, NULL, NULL, NULL),
(7033, 40, 334, NULL, NULL, NULL, NULL, NULL, NULL),
(7034, 41, 334, NULL, NULL, NULL, NULL, NULL, NULL),
(7035, 45, 334, NULL, NULL, NULL, NULL, NULL, NULL),
(7036, 46, 334, NULL, NULL, NULL, NULL, NULL, NULL),
(7037, 47, 334, NULL, NULL, NULL, NULL, NULL, NULL),
(7038, 48, 334, NULL, NULL, NULL, NULL, NULL, NULL),
(7039, 49, 334, NULL, NULL, NULL, NULL, NULL, NULL),
(7040, 50, 334, NULL, NULL, NULL, NULL, NULL, NULL),
(7041, 51, 334, NULL, NULL, NULL, NULL, NULL, NULL),
(7042, 26, 335, NULL, NULL, NULL, NULL, NULL, NULL),
(7043, 27, 335, NULL, NULL, NULL, NULL, NULL, NULL),
(7044, 28, 335, NULL, NULL, NULL, NULL, NULL, NULL),
(7045, 29, 335, NULL, NULL, NULL, NULL, NULL, NULL),
(7046, 30, 335, NULL, NULL, NULL, NULL, NULL, NULL),
(7047, 31, 335, NULL, NULL, NULL, NULL, NULL, NULL),
(7048, 32, 335, NULL, NULL, NULL, NULL, NULL, NULL),
(7049, 33, 335, NULL, NULL, NULL, NULL, NULL, NULL),
(7050, 34, 335, NULL, NULL, NULL, NULL, NULL, NULL),
(7051, 35, 335, NULL, NULL, NULL, NULL, NULL, NULL),
(7052, 36, 335, NULL, NULL, NULL, NULL, NULL, NULL),
(7053, 37, 335, NULL, NULL, NULL, NULL, NULL, NULL),
(7054, 38, 335, NULL, NULL, NULL, NULL, NULL, NULL),
(7055, 39, 335, NULL, NULL, NULL, NULL, NULL, NULL),
(7056, 40, 335, NULL, NULL, NULL, NULL, NULL, NULL),
(7057, 41, 335, NULL, NULL, NULL, NULL, NULL, NULL),
(7058, 45, 335, NULL, NULL, NULL, NULL, NULL, NULL),
(7059, 46, 335, NULL, NULL, NULL, NULL, NULL, NULL),
(7060, 47, 335, NULL, NULL, NULL, NULL, NULL, NULL),
(7061, 48, 335, NULL, NULL, NULL, NULL, NULL, NULL),
(7062, 49, 335, NULL, NULL, NULL, NULL, NULL, NULL),
(7063, 50, 335, NULL, NULL, NULL, NULL, NULL, NULL),
(7064, 51, 335, NULL, NULL, NULL, NULL, NULL, NULL),
(7065, 26, 336, NULL, NULL, NULL, NULL, NULL, NULL),
(7066, 27, 336, NULL, NULL, NULL, NULL, NULL, NULL),
(7067, 28, 336, NULL, NULL, NULL, NULL, NULL, NULL),
(7068, 29, 336, NULL, NULL, NULL, NULL, NULL, NULL),
(7069, 30, 336, NULL, NULL, NULL, NULL, NULL, NULL),
(7070, 31, 336, NULL, NULL, NULL, NULL, NULL, NULL),
(7071, 32, 336, NULL, NULL, NULL, NULL, NULL, NULL),
(7072, 33, 336, NULL, NULL, NULL, NULL, NULL, NULL),
(7073, 34, 336, NULL, NULL, NULL, NULL, NULL, NULL),
(7074, 35, 336, NULL, NULL, NULL, NULL, NULL, NULL),
(7075, 36, 336, NULL, NULL, NULL, NULL, NULL, NULL),
(7076, 37, 336, NULL, NULL, NULL, NULL, NULL, NULL),
(7077, 38, 336, NULL, NULL, NULL, NULL, NULL, NULL),
(7078, 39, 336, NULL, NULL, NULL, NULL, NULL, NULL),
(7079, 40, 336, NULL, NULL, NULL, NULL, NULL, NULL),
(7080, 41, 336, NULL, NULL, NULL, NULL, NULL, NULL),
(7081, 45, 336, NULL, NULL, NULL, NULL, NULL, NULL),
(7082, 46, 336, NULL, NULL, NULL, NULL, NULL, NULL),
(7083, 47, 336, NULL, NULL, NULL, NULL, NULL, NULL),
(7084, 48, 336, NULL, NULL, NULL, NULL, NULL, NULL),
(7085, 49, 336, NULL, NULL, NULL, NULL, NULL, NULL),
(7086, 50, 336, NULL, NULL, NULL, NULL, NULL, NULL),
(7087, 51, 336, NULL, NULL, NULL, NULL, NULL, NULL),
(7088, 26, 337, NULL, NULL, NULL, NULL, NULL, NULL),
(7089, 27, 337, NULL, NULL, NULL, NULL, NULL, NULL),
(7090, 28, 337, NULL, NULL, NULL, NULL, NULL, NULL),
(7091, 29, 337, NULL, NULL, NULL, NULL, NULL, NULL),
(7092, 30, 337, NULL, NULL, NULL, NULL, NULL, NULL),
(7093, 31, 337, NULL, NULL, NULL, NULL, NULL, NULL),
(7094, 32, 337, NULL, NULL, NULL, NULL, NULL, NULL),
(7095, 33, 337, NULL, NULL, NULL, NULL, NULL, NULL),
(7096, 34, 337, NULL, NULL, NULL, NULL, NULL, NULL),
(7097, 35, 337, NULL, NULL, NULL, NULL, NULL, NULL),
(7098, 36, 337, NULL, NULL, NULL, NULL, NULL, NULL),
(7099, 37, 337, NULL, NULL, NULL, NULL, NULL, NULL),
(7100, 38, 337, NULL, NULL, NULL, NULL, NULL, NULL),
(7101, 39, 337, NULL, NULL, NULL, NULL, NULL, NULL),
(7102, 40, 337, NULL, NULL, NULL, NULL, NULL, NULL),
(7103, 41, 337, NULL, NULL, NULL, NULL, NULL, NULL),
(7104, 45, 337, NULL, NULL, NULL, NULL, NULL, NULL),
(7105, 46, 337, NULL, NULL, NULL, NULL, NULL, NULL),
(7106, 47, 337, NULL, NULL, NULL, NULL, NULL, NULL),
(7107, 48, 337, NULL, NULL, NULL, NULL, NULL, NULL),
(7108, 49, 337, NULL, NULL, NULL, NULL, NULL, NULL),
(7109, 50, 337, NULL, NULL, NULL, NULL, NULL, NULL),
(7110, 51, 337, NULL, NULL, NULL, NULL, NULL, NULL),
(7111, 26, 338, NULL, NULL, NULL, NULL, NULL, NULL),
(7112, 27, 338, NULL, NULL, NULL, NULL, NULL, NULL),
(7113, 28, 338, NULL, NULL, NULL, NULL, NULL, NULL),
(7114, 29, 338, NULL, NULL, NULL, NULL, NULL, NULL),
(7115, 30, 338, NULL, NULL, NULL, NULL, NULL, NULL),
(7116, 31, 338, NULL, NULL, NULL, NULL, NULL, NULL),
(7117, 32, 338, NULL, NULL, NULL, NULL, NULL, NULL),
(7118, 33, 338, NULL, NULL, NULL, NULL, NULL, NULL),
(7119, 34, 338, NULL, NULL, NULL, NULL, NULL, NULL),
(7120, 35, 338, NULL, NULL, NULL, NULL, NULL, NULL),
(7121, 36, 338, NULL, NULL, NULL, NULL, NULL, NULL),
(7122, 37, 338, NULL, NULL, NULL, NULL, NULL, NULL),
(7123, 38, 338, NULL, NULL, NULL, NULL, NULL, NULL),
(7124, 39, 338, NULL, NULL, NULL, NULL, NULL, NULL),
(7125, 40, 338, NULL, NULL, NULL, NULL, NULL, NULL),
(7126, 41, 338, NULL, NULL, NULL, NULL, NULL, NULL),
(7127, 45, 338, NULL, NULL, NULL, NULL, NULL, NULL),
(7128, 46, 338, NULL, NULL, NULL, NULL, NULL, NULL),
(7129, 47, 338, NULL, NULL, NULL, NULL, NULL, NULL),
(7130, 48, 338, NULL, NULL, NULL, NULL, NULL, NULL),
(7131, 49, 338, NULL, NULL, NULL, NULL, NULL, NULL),
(7132, 50, 338, NULL, NULL, NULL, NULL, NULL, NULL),
(7133, 51, 338, NULL, NULL, NULL, NULL, NULL, NULL),
(7134, 26, 339, NULL, NULL, NULL, NULL, NULL, NULL),
(7135, 27, 339, NULL, NULL, NULL, NULL, NULL, NULL),
(7136, 28, 339, NULL, NULL, NULL, NULL, NULL, NULL),
(7137, 29, 339, NULL, NULL, NULL, NULL, NULL, NULL),
(7138, 30, 339, NULL, NULL, NULL, NULL, NULL, NULL),
(7139, 31, 339, NULL, NULL, NULL, NULL, NULL, NULL),
(7140, 32, 339, NULL, NULL, NULL, NULL, NULL, NULL),
(7141, 33, 339, NULL, NULL, NULL, NULL, NULL, NULL),
(7142, 34, 339, NULL, NULL, NULL, NULL, NULL, NULL),
(7143, 35, 339, NULL, NULL, NULL, NULL, NULL, NULL),
(7144, 36, 339, NULL, NULL, NULL, NULL, NULL, NULL),
(7145, 37, 339, NULL, NULL, NULL, NULL, NULL, NULL),
(7146, 38, 339, NULL, NULL, NULL, NULL, NULL, NULL),
(7147, 39, 339, NULL, NULL, NULL, NULL, NULL, NULL),
(7148, 40, 339, NULL, NULL, NULL, NULL, NULL, NULL),
(7149, 41, 339, NULL, NULL, NULL, NULL, NULL, NULL),
(7150, 45, 339, NULL, NULL, NULL, NULL, NULL, NULL),
(7151, 46, 339, NULL, NULL, NULL, NULL, NULL, NULL),
(7152, 47, 339, NULL, NULL, NULL, NULL, NULL, NULL),
(7153, 48, 339, NULL, NULL, NULL, NULL, NULL, NULL),
(7154, 49, 339, NULL, NULL, NULL, NULL, NULL, NULL),
(7155, 50, 339, NULL, NULL, NULL, NULL, NULL, NULL),
(7156, 51, 339, NULL, NULL, NULL, NULL, NULL, NULL);

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

--
-- Structure de la table `tbl_etudiant_es`
--

CREATE TABLE IF NOT EXISTS `tbl_etudiant_es` (
  `id_etudiant_es` int(11) NOT NULL AUTO_INCREMENT,
  `nom_etd_es` varchar(30) DEFAULT NULL,
  `pren_etd_es` varchar(30) DEFAULT NULL,
  `sexe_etd_es` varchar(1) DEFAULT NULL,
  `datence_etd_es` date DEFAULT NULL,
  `nationalite_etd_es` varchar(30) DEFAULT NULL,
  `adress_etd_es` varchar(30) DEFAULT NULL,
  `tel_etd_es` varchar(20) DEFAULT NULL,
  `email_etd_es` varchar(40) DEFAULT NULL,
  `lieunce_etd_es` varchar(30) DEFAULT NULL,
  `pere_etd_es` varchar(40) DEFAULT NULL,
  `mere_etd_es` varchar(40) DEFAULT NULL,
  `photo_etd_es` varchar(60) DEFAULT NULL,
  `tuteur_etd_es` varchar(50) NOT NULL,
  `id_user_es` int(11) NOT NULL,
  PRIMARY KEY (`id_etudiant_es`),
  KEY `id_user_es` (`id_user_es`)
) ENGINE=InnoDB AUTO_INCREMENT=53 DEFAULT CHARSET=utf8;

--
-- Déchargement des données de la table `tbl_etudiant_es`
--

INSERT INTO `tbl_etudiant_es` (`id_etudiant_es`, `nom_etd_es`, `pren_etd_es`, `sexe_etd_es`, `datence_etd_es`, `nationalite_etd_es`, `adress_etd_es`, `tel_etd_es`, `email_etd_es`, `lieunce_etd_es`, `pere_etd_es`, `mere_etd_es`, `photo_etd_es`, `tuteur_etd_es`, `id_user_es`) VALUES
(26, 'NDOMBINA', 'Christine Ketsia', 'F', '1995-07-10', 'Gabonaise', 'Cocotier (Libreville)', '07522977', 'ndombinak@gmail.com', 'Port-gentil (Gabon)', 'NDOMBINA Benjamin', 'AMBOUROUET Yvonne épouse NDOMBINA', 'photo-Christine-Ketsia.jpg', 'NDOMBINA Benjamin', 103),
(27, 'NTCHEGUE EVOUONI', 'Eugénie Aurélie Jessica', 'F', '1999-01-07', 'Gabonaise', 'Ambowe', '04520473', 'evouonijessica@gmail.com', 'Libreville', 'EVOUONI Gregoire ', 'AGNAMBIEPA OWANGA Delphine Hélène', 'photo-Eugy-nie-Aury-lie-Jessica.jpg', 'Père', 108),
(28, 'NZOGHE MAKANGA', 'Yhann Chrismard Maixant', 'H', '1991-06-04', 'Gabonaise', 'Akanda', '04964227', 'yank04@hotmail.fr', 'Libreville', 'MAKANGA Jean-Christophe', 'N\'NOH Dominique', '', 'père', 109),
(29, 'IVAZZA', 'Jean-Marie Wilfried', 'H', '1996-10-16', 'Gabonaise', 'Angondjé', '02862744 / 07951537', 'ivazzawilfried@gmail.com', 'Libreville', 'IVAZZA OTANDO Gustave', 'fauster ', 'photo-Jean-Marie-Wilfried.jpg', 'père', 110),
(30, 'vignac', 'Robert', 'H', '1996-06-21', 'Gabonaise', 'libreville', '+24106936966', 'davidvignac3@gmail.com', 'Libreville', 'VIGNAC Ferdinand', 'VIGNAC Patricia', 'photo-Robert.jpg', 'Père', 111),
(31, 'MOULONGOU NGOMA', 'Synthyche Magalie France', 'F', '1998-07-11', 'Gabonaise', 'Libreville', '02761334 / 04909222', 'maguie0798@gmail.com', 'Libreville', 'NGOMA LOANGA Franck Joseph', 'ZINGAKA GNANHOUI Francesca', 'photo-Synthyche-Magalie-France.jpg', 'Père', 112),
(32, 'ZAKOU', 'Kokou Noagbenakpoe', 'H', '1995-06-14', 'Togolaise', 'Angodje Chateau', '06721100 / 07369881', 'heusserdany4@gmail.com', 'AMOUSSOUKOPE (Dpt KLOTO)', 'ZAKOU KODJOVI Agbéyéyé', 'ADZANADO Adzo', 'photo-ZAKOU.png', 'père', 115),
(33, 'MEDZOGHE NTOUTOUME', 'Fabienne', 'F', '1993-07-13', 'Gabonaise', 'Akanda/ Okala', '06936539', 'medzoghefabienne@gmail.com', 'LIBREVILLE', 'Aucun', 'NDONG ETOGO Carole', 'photo-Fabienne.JPG', 'Mère', 116),
(34, 'KATSOGUI OBALA', 'CYBRINA ORLIE', 'F', '1997-07-09', 'Gabonaise', 'Libreville', '02841702 / 04452598', 'cybrinakatsogui@gmail.com', 'Franceville', 'MAPAGA KOMBILA', 'OYOUGUI ONGAYE ANNICK', 'photo-KATSOGUI-OBALA.png', 'Père', 122),
(35, 'NGUIMBI NZAMBA', 'JOEL INONCENT JOVIAL', 'H', '1998-12-21', 'Gabonaise', '4 ième cité Akanda', '07174613', 'tenjovial@gmail.com', 'Libreville', 'BOUTET THIERRY LAURENT', 'DIMBOU BLANDINE', 'photo-JOEL-INONCENT-JOVIAL.jpg', 'père', 124),
(36, 'YOUMINI YOUMINI', 'ANDY VIRGIL', 'H', '1992-04-14', 'Gabonaise', 'Owendo', '06261605 / 04576614', 'andyyoumini4@gmail.com', 'Koulamoutou', 'LIWAKA WADA ARNOLD', 'BOUANGA CELINE', 'photo-YOUMINI-YOUMINI.png', 'Père', 125),
(37, 'NZUE', 'LIONEL HENDRIX', 'H', '1990-04-05', 'Gabonaise', 'LIBREVILLE', '06044698', 'anguealbertine3@gmail.com', 'BITAM', 'MENYE BIBANG VICTORIEN', 'ANGUE NZUE ALBERTINE', 'photo-NZUE.png', 'Père', 126),
(38, 'NLEND', 'ALBERT GUY KUNZ', 'H', '1998-09-05', 'Camerounaise', 'Angondje derrière le stade', '06609514', 'guynlend15@gmail.com', 'Cameroun', 'NLEND CHRISTIAN CLAUDE', 'KOHO PLISCA RAYMONDA', 'photo-NLEND.png', 'Père', 130),
(39, 'AKE MVOULA', 'Sullivan Alvigno', 'H', '1999-06-20', 'Gabonaise', 'Libreville', '04 28 78 82 / 02 96 ', 'alvignoake@gmail.com', 'Libreville', 'AKE Maxime ', 'ABONZOGO  MINKO Huguette Flore  ', 'photo-Sullivan-Alvigno.jpg', 'père', 134),
(40, 'AWORET RENGUILA', 'Andy Jacob-Didier', 'H', '1995-07-31', 'Gabonaise', 'Mindoub', '06750217 / 04225035', 'renguiladidier@gmail.com', 'Gabon', 'RENGOLA RENGUILA Henrie', 'RENGOLA Nanette', 'photo-AWORET-RENGUILA.png', 'Père', 135),
(41, 'EYEBE LENDOYE', 'Ken Cemich ', 'H', '1994-06-09', 'Gabonaise', 'Agoungou', '06261744 / 05626740', 'lendoye2008@hotmail.fr', 'Libreville', 'EYEBE LENDOYE Jean Paul', 'BOUSSOUKA Clémentine', 'photo-EYEBE-LENDOYE.png', 'Père', 136),
(45, 'DINZAMBOUH JOEL MBOUMBA', 'Kaiser O\'neal', 'H', '1993-08-12', 'Gabonaise', 'Libreville', '06254424/04806451', 'jkaiser238@gmail.com', 'Libreville', 'DIZAMBOU JOEL Patrick', 'INBINGA Salome', 'photo-DINZAMBOUH-JOEL-MBOUMBA.png', 'Père', 141),
(46, 'KOUMBA AGNOSSI', 'Marcella Juan Christie', 'F', '1992-03-19', 'Gabonaise', 'OKALA', '06624722/07792603', 'juankoumba1992@gmail.com', 'Port-Gentil', 'OKOUONI AGNOSSI SAMUEL', 'MOULOUNGOU MOUSSADY DANIELLE', 'photo-KOUMBA-AGNOSSI.png', 'Père', 142),
(47, 'SIRRANOT MBA', 'Bryan Ivan', 'H', '1994-06-03', 'Gabonaise', 'Libreville', '02 95 11 87', 'sirranot@gmail.com', 'Libreville', 'MBA SIRRANOT Jean Pierre', 'BOUKOUMABONDI Jeanne', 'photo-SIRRANOT-MBA.png', 'SIRRANOT MBA', 143),
(48, 'NKOA PONCE ', 'Arnaud', 'H', '1995-05-16', 'Gabonaise', 'Libreville', '07 07 98 18', 'nkoaponce@gmail.com', 'Libreville', 'NKOA Alain Armand', 'OSSONEMANE Virginie', 'photo-NKOA-PONCE-.png', 'Père', 144),
(49, 'WORA MBOUROU', 'Ozvane Larry', 'H', '1991-07-06', 'Gabonaise', 'Baraka', '07 89 93 11 / 02 44 ', 'larrywora@gmail.com', 'Port-Gentil', 'WORA AKOUETE Jean', 'BAYONNE AMBOUROUET Jeanne Pauline', 'photo-WORA-MBOUROU.png', 'père', 145),
(50, 'KABU NOMEZANG', 'Darsy Helly', 'H', '1997-03-20', 'Gabonaise', 'Libreville', '02 42 20 52 / 02 42 ', 'treydarsy1@gmail.com', 'Libreville', 'NOMEZANG ELLA Samy', 'MOUSSAVOU MAVOUNGOU Lydie', 'photo-KABU-NOMEZANG.png', 'mère', 146),
(51, 'NTSONO OKANHA', 'Grâce Jeannette Jellynah', 'F', '1998-01-27', 'Gabonaise', '', '05 15 98 90 / 07 53 ', 'ntsonolynah@gmail.com', 'Mounana', '', '', 'photo-NTSONO-OKANHA.png', 'tante', 147);

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

--
-- Structure de la table `tbl_evaluation_es`
--

CREATE TABLE IF NOT EXISTS `tbl_evaluation_es` (
  `id_eval_es` int(11) NOT NULL AUTO_INCREMENT,
  `date_eval_es` date NOT NULL,
  `heureD_eval_es` time NOT NULL,
  `HeureF_eval_es` time NOT NULL,
  `annotation_es` varchar(10) NOT NULL,
  `support_eval_es` varchar(50) NOT NULL,
  `etat_eval_es` int(2) DEFAULT NULL,
  `surveil_eval_es` varchar(30) NOT NULL,
  `etat_surveil_es` int(2) DEFAULT NULL,
  `dateEval_program_es` date NOT NULL,
  `id_aff_class_es` int(11) NOT NULL,
  PRIMARY KEY (`id_eval_es`),
  KEY `id_aff_class_es` (`id_aff_class_es`)
) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=utf8;

--
-- Déchargement des données de la table `tbl_evaluation_es`
--

INSERT INTO `tbl_evaluation_es` (`id_eval_es`, `date_eval_es`, `heureD_eval_es`, `HeureF_eval_es`, `annotation_es`, `support_eval_es`, `etat_eval_es`, `surveil_eval_es`, `etat_surveil_es`, `dateEval_program_es`, `id_aff_class_es`) VALUES
(4, '2019-01-14', '08:00:00', '10:00:00', '20', '', 0, 'BIVIGA Ep. MOUKALA Marinette', 0, '2019-01-14', 31),
(5, '2019-01-17', '15:00:00', '17:00:00', '20', '', 0, 'BIVIGA Ep. MOUKALA Marinette', 0, '2019-01-14', 152),
(6, '2018-12-14', '08:00:00', '10:00:00', '20', '', 1, 'NDONG NANG Gildas Borrys', 0, '2019-01-18', 37),
(7, '2019-01-21', '17:15:00', '18:45:00', '20', 'Evaluation-Programmation-Web-N.1.pdf', 1, 'HOMBESSA THessia Hrubech', 0, '2019-01-22', 181),
(11, '2019-02-08', '08:00:00', '10:00:00', '20', '', 0, 'ODJIRE KOUMOUE Aziz Julien', 0, '2019-02-07', 210),
(12, '2019-02-20', '17:00:00', '19:00:00', '20', '', 0, 'BIYIE KARENE', 0, '2019-02-13', 34),
(13, '2019-03-08', '10:00:00', '12:00:00', '40', '', 0, 'YAMBA Saint-Quentin Adonis', 0, '2019-03-07', 255),
(14, '2019-07-10', '15:00:00', '17:00:00', '20', 'Evaluation-Word-N.1.docx', 0, 'NGABOLO  Reine-Sandra', 0, '2019-07-01', 265),
(15, '2019-08-14', '16:00:00', '18:00:00', '20', '', 0, 'ONDIAS SOUNA Luck', 0, '2019-08-12', 271);

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

--
-- Structure de la table `tbl_events_cours_es`
--

CREATE TABLE IF NOT EXISTS `tbl_events_cours_es` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(255) NOT NULL,
  `color` varchar(7) DEFAULT NULL,
  `start` datetime NOT NULL,
  `end` datetime DEFAULT NULL,
  `id_cours_ens_es` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `id_cours_ens_es` (`id_cours_ens_es`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

--
-- Déchargement des données de la table `tbl_events_cours_es`
--

INSERT INTO `tbl_events_cours_es` (`id`, `title`, `color`, `start`, `end`, `id_cours_ens_es`) VALUES
(1, 'Word', '#FFD700', '2019-08-14 10:00:00', '2019-08-14 10:00:00', 339);

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

--
-- Structure de la table `tbl_examen_es`
--

CREATE TABLE IF NOT EXISTS `tbl_examen_es` (
  `id_exam_es` int(11) NOT NULL AUTO_INCREMENT,
  `libel_exam_es` varchar(30) NOT NULL,
  `date_exam_es` date NOT NULL,
  `dateD_exam_es` date NOT NULL,
  `dateF_exam_es` date NOT NULL,
  `id_an_acad_es` int(11) NOT NULL,
  `etat_exam_es` int(2) NOT NULL,
  PRIMARY KEY (`id_exam_es`),
  KEY `id_an_acad_es` (`id_an_acad_es`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;

--
-- Déchargement des données de la table `tbl_examen_es`
--

INSERT INTO `tbl_examen_es` (`id_exam_es`, `libel_exam_es`, `date_exam_es`, `dateD_exam_es`, `dateF_exam_es`, `id_an_acad_es`, `etat_exam_es`) VALUES
(2, 'Fin de semestre', '2019-01-25', '2019-01-28', '2019-01-29', 8, 0);

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

--
-- Structure de la table `tbl_fonction_es`
--

CREATE TABLE IF NOT EXISTS `tbl_fonction_es` (
  `id_fonct_es` int(11) NOT NULL AUTO_INCREMENT,
  `libel_fonct_es` varchar(50) NOT NULL,
  `id_etbl_es` int(11) NOT NULL,
  PRIMARY KEY (`id_fonct_es`),
  KEY `id_etbl_es` (`id_etbl_es`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8;

--
-- Déchargement des données de la table `tbl_fonction_es`
--

INSERT INTO `tbl_fonction_es` (`id_fonct_es`, `libel_fonct_es`, `id_etbl_es`) VALUES
(3, 'Directeur des études', 1),
(4, 'Directeur Pédagogique', 1),
(5, 'Directeur général', 1),
(6, 'Encadrant Vacataire', 1),
(7, 'Assistant de direction', 1),
(8, 'Encadrant Permanent', 1);

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

--
-- Structure de la table `tbl_fondateur_es`
--

CREATE TABLE IF NOT EXISTS `tbl_fondateur_es` (
  `id_fondt_es` int(11) NOT NULL AUTO_INCREMENT,
  `photo_fondt_es` varchar(40) NOT NULL,
  `nom_fondt_es` varchar(30) NOT NULL,
  `pren_fondt_es` varchar(30) NOT NULL,
  `sexe_fondt_es` varchar(1) NOT NULL,
  `email_fondt_es` varchar(40) NOT NULL,
  `tel_fondt_es` varchar(30) NOT NULL,
  PRIMARY KEY (`id_fondt_es`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

--
-- Déchargement des données de la table `tbl_fondateur_es`
--

INSERT INTO `tbl_fondateur_es` (`id_fondt_es`, `photo_fondt_es`, `nom_fondt_es`, `pren_fondt_es`, `sexe_fondt_es`, `email_fondt_es`, `tel_fondt_es`) VALUES
(1, 'fondt_dbs.JPG', 'ONDIAS', 'Luck', 'H', 'luckondias@gmail.com', '+241 02 05 55 01');

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

--
-- Structure de la table `tbl_fraie_inscri_es`
--

CREATE TABLE IF NOT EXISTS `tbl_fraie_inscri_es` (
  `id_fraie_inscri_es` int(11) NOT NULL AUTO_INCREMENT,
  `mode_paie_es` varchar(30) DEFAULT NULL,
  `montant_ap_es` varchar(50) DEFAULT NULL,
  `montant_p_es` varchar(50) DEFAULT NULL,
  `avance_p_es` varchar(50) DEFAULT NULL,
  `reste_p_es` varchar(50) DEFAULT NULL,
  `numcompt_es` varchar(30) DEFAULT NULL,
  `numcheq_es` varchar(30) DEFAULT NULL,
  `tel_airtel_money_es` varchar(20) DEFAULT NULL,
  `etat_paie_es` int(1) NOT NULL,
  `date_paie_es` date DEFAULT NULL,
  PRIMARY KEY (`id_fraie_inscri_es`)
) ENGINE=InnoDB AUTO_INCREMENT=69 DEFAULT CHARSET=utf8;

--
-- Déchargement des données de la table `tbl_fraie_inscri_es`
--

INSERT INTO `tbl_fraie_inscri_es` (`id_fraie_inscri_es`, `mode_paie_es`, `montant_ap_es`, `montant_p_es`, `avance_p_es`, `reste_p_es`, `numcompt_es`, `numcheq_es`, `tel_airtel_money_es`, `etat_paie_es`, `date_paie_es`) VALUES
(42, 'espèce', '100.000', '100.000', '0', '0', '', '', '', 1, '2018-09-26'),
(43, 'espèce', '100000', '100000', '', '', '', '', '', 1, '2018-10-08'),
(44, 'espèce', '100000', '100000', '', '', '', '', '', 1, '2018-10-08'),
(45, 'Espèce', '100000', '100000', '', '', '', '', '', 1, '2018-10-08'),
(46, 'Espèce', '100000', '100000', '', '', '', '', '', 1, '2018-10-08'),
(47, 'Espèce', '100000', '100000', '', '', '', '', '', 1, '2018-10-11'),
(48, 'Espèce', '100000', '100000', '', '', '', '', '', 1, '2018-11-09'),
(49, 'Espèce', '100000', '100000', '', '', '', '', '', 1, '2018-10-11'),
(50, 'Espèce', '100000', '100000', '', '', '', '', '', 1, '2018-11-09'),
(51, 'Espèce', '100000', '100000', '', '', '', '', '', 1, '2018-11-09'),
(52, 'Espèce', '100000', '100000', '', '', '', '', '', 1, '2018-11-09'),
(53, 'Espèce', '100000', '100000', '', '', '', '', '', 1, '2018-11-09'),
(54, 'Espèce', '100000', '100000', '150000', '950000', '', '', '', 1, '2018-11-09'),
(55, 'Espèce', '100000', '100000', '', '', '', '', '', 1, '2018-11-09'),
(56, 'Espèce', '100000', '100000', '', '', '', '', '', 1, '2018-11-09'),
(57, 'Espèce', '100000', '100000', '275000', '825000', '', '', '', 1, '2018-11-14'),
(61, 'Espèce', '100000', '100000', '', '', '', '', '', 1, '2018-11-21'),
(62, 'Espèce', '100000', '100000', '', '', '', '', '', 1, '2018-11-22'),
(63, 'Espèce', '100000', '100000', '', '', '', '', '', 1, '2018-12-03'),
(64, 'Espèce', '100000', '100000', '', '', '', '', '', 1, '2018-12-03'),
(65, 'Espèce', '100000', '100000', '', '', '', '', '', 1, '2018-12-03'),
(66, 'Espèce', '100000', '100000', '', '', '', '', '', 1, '2018-12-12'),
(67, 'Espèce', '100000', '100000', '0', '0', '', '', '', 1, '2019-07-10');

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

--
-- Structure de la table `tbl_fraie_scola_es`
--

CREATE TABLE IF NOT EXISTS `tbl_fraie_scola_es` (
  `id_sco_es` int(11) NOT NULL AUTO_INCREMENT,
  `id_etudiant_es` int(11) NOT NULL,
  `mode_paie_es` varchar(40) NOT NULL,
  `montant_ap_es` varchar(50) NOT NULL,
  `montant_p_es` varchar(50) NOT NULL,
  `reste_p_es` varchar(50) NOT NULL,
  `numcompt_es` varchar(40) NOT NULL,
  `numcheq_es` varchar(40) NOT NULL,
  `tel_airtel_money_es` varchar(30) NOT NULL,
  `etat_paie_es` int(2) NOT NULL,
  `date_paie_es` date NOT NULL,
  `mois_sco_es` varchar(30) NOT NULL,
  `modalite_paie_es` varchar(30) NOT NULL,
  `nbr_tranche_es` varchar(10) NOT NULL,
  `id_an_acad_es` int(11) NOT NULL,
  PRIMARY KEY (`id_sco_es`),
  KEY `id_etd_es` (`id_etudiant_es`),
  KEY `id_an_acad_es` (`id_an_acad_es`)
) ENGINE=InnoDB AUTO_INCREMENT=61 DEFAULT CHARSET=utf8;

--
-- Déchargement des données de la table `tbl_fraie_scola_es`
--

INSERT INTO `tbl_fraie_scola_es` (`id_sco_es`, `id_etudiant_es`, `mode_paie_es`, `montant_ap_es`, `montant_p_es`, `reste_p_es`, `numcompt_es`, `numcheq_es`, `tel_airtel_money_es`, `etat_paie_es`, `date_paie_es`, `mois_sco_es`, `modalite_paie_es`, `nbr_tranche_es`, `id_an_acad_es`) VALUES
(5, 26, 'espèce', '275 000', '275000', '0', '', '', '', 1, '2018-10-30', '', 'Tranche', '4', 8),
(6, 31, 'espèce', '125000', '125000', '0', '', '', '', 1, '2019-01-10', 'Novembre', 'Mensuelle', '', 8),
(8, 36, 'espèce', '125000', '125000', '0', '', '', '', 1, '2019-01-10', 'Novembre', 'Mensuelle', '', 8),
(11, 40, 'espèce', '275 000', '275000', '0', '', '', '', 1, '2018-10-30', '', 'Tranche', '4', 8),
(12, 38, 'espèce', '1100000', '150000', '950000', '', '', '', 1, '2018-11-15', '', 'Totalité', '', 8),
(21, 50, 'espèce', '125000', '125000', '0', '', '', '', 1, '2019-01-10', 'Novembre', 'Mensuelle', '', 8),
(28, 29, 'espèce', '125000', '125000', '0', '', '', '', 1, '2019-01-10', 'Novembre', 'Mensuelle', '', 8),
(29, 28, 'espèce', '125000', '125000', '0', '', '', '', 1, '2019-01-10', 'Novembre', 'Mensuelle', '', 8),
(30, 28, 'espèce', '125000', '125000', '0', '', '', '', 1, '2019-01-10', 'Décembre', 'Mensuelle', '', 8),
(31, 33, 'espèce', '125000', '125000', '0', '', '', '', 1, '2019-01-10', 'Novembre', 'Mensuelle', '', 8),
(32, 33, 'espèce', '125000', '125000', '0', '', '', '', 1, '2019-01-10', 'Décembre', 'Mensuelle', '', 8),
(33, 32, 'espèce', '125000', '125000', '0', '', '', '', 1, '2019-01-10', 'Novembre', 'Mensuelle', '', 8),
(34, 34, 'espèce', '125000', '125000', '0', '', '', '', 1, '2019-01-10', 'Novembre', 'Mensuelle', '', 8),
(35, 34, 'espèce', '125000', '125000', '0', '', '', '', 1, '2019-01-10', 'Décembre', 'Mensuelle', '', 8),
(36, 35, 'espèce', '125000', '125000', '0', '', '', '', 1, '2019-01-10', 'Novembre', 'Mensuelle', '', 8),
(37, 37, 'espèce', '125000', '125000', '0', '', '', '', 1, '2019-01-10', 'Novembre', 'Mensuelle', '', 8),
(39, 36, 'espèce', '125000', '125000', '0', '', '', '', 1, '2019-01-10', 'Décembre', 'Mensuelle', '', 8),
(41, 47, 'espèce', '125000', '125000', '0', '', '', '', 1, '2019-01-10', 'Novembre', 'Mensuelle', '', 8),
(42, 48, 'espèce', '125000', '125000', '0', '', '', '', 1, '2019-01-10', 'Novembre', 'Mensuelle', '', 8),
(45, 30, 'espèce', '275 000', '275000', '0', '', '', '', 1, '2018-10-30', '', 'Tranche', '4', 8),
(46, 50, 'espèce', '125000', '125000', '0', '', '', '', 1, '2019-01-10', 'Décembre', 'Mensuelle', '', 8),
(48, 41, 'espèce', '275 000', '275000', '0', '', '', '', 1, '2018-10-30', '', 'Tranche', '4', 8),
(49, 45, 'espèce', '125000', '125000', '0', '', '', '', 1, '2019-01-10', 'Novembre', 'Mensuelle', '', 8),
(50, 45, 'espèce', '125000', '125000', '0', '', '', '', 1, '2019-01-10', 'Décembre', 'Mensuelle', '', 8),
(51, 27, 'espèce', '275 000', '275000', '0', '', '', '', 1, '2018-10-30', '', 'Tranche', '4', 8),
(52, 27, 'espèce', '275 000', '275000', '0', '', '', '', 1, '2019-01-08', '', 'Tranche', '4', 8),
(53, 26, 'espèce', '275 000', '275000', '0', '', '', '', 1, '2019-01-15', '', 'Tranche', '4', 8),
(54, 31, 'espèce', '125000', '125000', '0', '', '', '', 1, '2019-01-10', 'Décembre', 'Mensuelle', '', 8),
(55, 31, 'espèce', '125000', '125000', '0', '', '', '', 1, '2019-01-10', 'janvier', 'Mensuelle', '', 8),
(56, 32, 'espèce', '125000', '125000', '0', '', '', '', 1, '2019-01-10', 'Décembre', 'Mensuelle', '', 8),
(57, 34, 'espèce', '125000', '125000', '0', '', '', '', 1, '2019-01-10', 'janvier', 'Mensuelle', '', 8),
(58, 49, 'espèce', '125000', '125000', '0', '', '', '', 1, '2019-01-10', 'Novembre', 'Mensuelle', '', 8),
(60, 48, 'espèce', '125000', '125000', '0', '', '', '', 1, '2019-01-11', 'Décembre', 'Mensuelle', '', 8);

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

--
-- Structure de la table `tbl_histuser_es`
--

CREATE TABLE IF NOT EXISTS `tbl_histuser_es` (
  `id_hist_es` int(11) NOT NULL AUTO_INCREMENT,
  `role_hist_es` varchar(30) DEFAULT NULL,
  `date_hist_es` date NOT NULL,
  `heure_hist_es` time NOT NULL,
  `lieu_hist_es` varchar(30) DEFAULT NULL,
  `ip_hist_es` varchar(30) DEFAULT NULL,
  `terminal_hist_es` varchar(40) DEFAULT NULL,
  `etat_hist_es` varchar(1) NOT NULL,
  `permission_es` varchar(30) DEFAULT NULL,
  `page_hist_es` varchar(50) NOT NULL,
  `region_hist_es` varchar(40) DEFAULT NULL,
  `id_user_es` int(11) NOT NULL,
  PRIMARY KEY (`id_hist_es`),
  KEY `id_user_es` (`id_user_es`),
  KEY `id_user_es_2` (`id_user_es`),
  KEY `id_user_es_3` (`id_user_es`)
) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=utf8;

--
-- Déchargement des données de la table `tbl_histuser_es`
--

INSERT INTO `tbl_histuser_es` (`id_hist_es`, `role_hist_es`, `date_hist_es`, `heure_hist_es`, `lieu_hist_es`, `ip_hist_es`, `terminal_hist_es`, `etat_hist_es`, `permission_es`, `page_hist_es`, `region_hist_es`, `id_user_es`) VALUES
(13, NULL, '2019-03-14', '10:21:17', NULL, NULL, NULL, '0', NULL, 'Ajout_user', NULL, 105),
(14, NULL, '2019-08-02', '12:24:28', NULL, NULL, NULL, '0', NULL, 'Ajout_inscription', NULL, 105);

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

--
-- Structure de la table `tbl_horplanning_es`
--

CREATE TABLE IF NOT EXISTS `tbl_horplanning_es` (
  `id_horplan_es` int(11) NOT NULL AUTO_INCREMENT,
  `heureD_horplan_es` time NOT NULL,
  `heureF_horplan_es` time NOT NULL,
  `type_horplan_es` varchar(30) NOT NULL,
  `id_etbl_es` int(11) NOT NULL,
  PRIMARY KEY (`id_horplan_es`),
  KEY `id_etbl_es` (`id_etbl_es`)
) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8;

--
-- Déchargement des données de la table `tbl_horplanning_es`
--

INSERT INTO `tbl_horplanning_es` (`id_horplan_es`, `heureD_horplan_es`, `heureF_horplan_es`, `type_horplan_es`, `id_etbl_es`) VALUES
(2, '08:00:00', '09:00:00', 'Cours', 1),
(3, '09:00:00', '10:00:00', 'Cours', 1),
(4, '10:00:00', '11:00:00', 'Cours', 1),
(5, '11:00:00', '12:00:00', 'Cours', 1),
(6, '12:00:00', '13:00:00', 'Cours', 1),
(7, '13:00:00', '14:00:00', 'Cours', 1),
(8, '14:00:00', '15:00:00', 'Cours', 1),
(9, '15:00:00', '16:00:00', 'Cours', 1),
(10, '16:00:00', '17:00:00', 'Cours', 1),
(11, '17:00:00', '18:00:00', 'Cours', 1),
(12, '18:00:00', '19:00:00', 'Cours', 1);

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

--
-- Structure de la table `tbl_horplan_exam_es`
--

CREATE TABLE IF NOT EXISTS `tbl_horplan_exam_es` (
  `id_horplan_exam_es` int(11) NOT NULL AUTO_INCREMENT,
  `id_prog_examen` int(11) NOT NULL,
  `id_horplan_es` int(11) NOT NULL,
  PRIMARY KEY (`id_horplan_exam_es`),
  KEY `id_prog_examen` (`id_prog_examen`),
  KEY `id_horplan_es` (`id_horplan_es`)
) ENGINE=InnoDB AUTO_INCREMENT=32 DEFAULT CHARSET=utf8;

--
-- Déchargement des données de la table `tbl_horplan_exam_es`
--

INSERT INTO `tbl_horplan_exam_es` (`id_horplan_exam_es`, `id_prog_examen`, `id_horplan_es`) VALUES
(25, 8, 2),
(27, 8, 3),
(28, 9, 4),
(29, 9, 5),
(30, 10, 7),
(31, 10, 8);

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

--
-- Structure de la table `tbl_horplan_seance_es`
--

CREATE TABLE IF NOT EXISTS `tbl_horplan_seance_es` (
  `id_horplan_seance_es` int(11) NOT NULL AUTO_INCREMENT,
  `id_seance_es` int(11) NOT NULL,
  `id_horplan_es` int(11) NOT NULL,
  PRIMARY KEY (`id_horplan_seance_es`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- Structure de la table `tbl_inscription_es`
--

CREATE TABLE IF NOT EXISTS `tbl_inscription_es` (
  `id_ins_es` int(11) NOT NULL AUTO_INCREMENT,
  `id_etudiant_es` int(11) NOT NULL,
  `id_an_acad_es` int(11) NOT NULL,
  `id_fraie_inscri_es` int(11) NOT NULL,
  `id_classe_es` int(11) NOT NULL,
  `id_niveau_es` int(11) NOT NULL,
  `id_option_es` int(11) NOT NULL,
  `cv_inscri_es` varchar(70) DEFAULT NULL,
  `dernier_dipl_es` varchar(40) DEFAULT NULL,
  `etatdernier_dipl_es` varchar(10) DEFAULT NULL,
  `nivetude_es` varchar(20) DEFAULT NULL,
  `nivfrancais_es` varchar(10) DEFAULT NULL,
  `nivanglais_es` varchar(10) DEFAULT NULL,
  `langetrangere_es` varchar(20) DEFAULT NULL,
  `nivetrangere_es` varchar(10) DEFAULT NULL,
  `serie_etd_es` int(11) DEFAULT NULL,
  `etabli_actu_es` varchar(70) DEFAULT NULL,
  `etat_inscrip_es` varchar(1) NOT NULL,
  `date_inscrip_es` date DEFAULT NULL,
  `reinscrit_es` int(11) NOT NULL,
  PRIMARY KEY (`id_ins_es`),
  KEY `id_etudiant_es` (`id_etudiant_es`),
  KEY `id_an_acad_es` (`id_an_acad_es`),
  KEY `id_fraie_es` (`id_fraie_inscri_es`),
  KEY `id_classe_es` (`id_classe_es`),
  KEY `id_niveau_es` (`id_niveau_es`),
  KEY `id_option_es` (`id_option_es`),
  KEY `serie_etd_es` (`serie_etd_es`)
) ENGINE=InnoDB AUTO_INCREMENT=50 DEFAULT CHARSET=utf8;

--
-- Déchargement des données de la table `tbl_inscription_es`
--

INSERT INTO `tbl_inscription_es` (`id_ins_es`, `id_etudiant_es`, `id_an_acad_es`, `id_fraie_inscri_es`, `id_classe_es`, `id_niveau_es`, `id_option_es`, `cv_inscri_es`, `dernier_dipl_es`, `etatdernier_dipl_es`, `nivetude_es`, `nivfrancais_es`, `nivanglais_es`, `langetrangere_es`, `nivetrangere_es`, `serie_etd_es`, `etabli_actu_es`, `etat_inscrip_es`, `date_inscrip_es`, `reinscrit_es`) VALUES
(23, 26, 8, 42, 8, 2, 23, '', 'Terminale D', 'Obtenu', '1ère Année après BAC', 'Moyen', 'Aucun', 'Aucun', 'Aucun', 5, 'Université des Sciences de la Santé', '1', '2018-09-26', 0),
(24, 27, 8, 43, 8, 2, 23, NULL, 'Baccalauréat', 'Obtenu', 'Terminale', 'Bon', 'Aucun', 'Aucun', 'Aucun', 6, 'Lycée Georges Mabignath', '1', '2018-10-08', 0),
(25, 28, 8, 44, 8, 2, 23, NULL, 'CAP', 'Obtenu', 'Troisième', 'Bon', 'Aucun', 'Aucun', 'Aucun', 2, 'Kenco', '1', '2018-10-08', 0),
(26, 29, 8, 45, 8, 2, 23, NULL, 'Baccalauréat', 'Non obtenu', 'Terminale', 'Bon', 'Bon', 'Espagnol', 'Moyen', 6, 'YESSI-YAMI', '1', '2018-10-08', 0),
(27, 30, 8, 46, 8, 2, 23, NULL, 'BTS AES', 'Non obtenu', '2ère Année après BAC', 'Bon', 'Bon', 'Espagnol', 'Bon', 2, 'ESARC EVOLUTION', '1', '2018-10-08', 0),
(28, 31, 8, 47, 8, 2, 23, NULL, 'Baccalauréat', 'Obtenu', 'Terminale', 'Bon', 'Bon', 'Aucun', 'Aucun', 7, 'Lycée Sainte-Marie', '1', '2018-10-08', 0),
(29, 32, 8, 48, 8, 2, 23, NULL, 'Baccalauréat', 'Obtenu', 'Terminale', 'Moyen', 'Moyen', 'Allemand', 'Moyen', 6, 'Eglise Catholique Saint Christophe d\'Avo', '1', '2018-10-11', 0),
(30, 33, 8, 49, 8, 2, 23, NULL, '3ère Année Bachelor Commerce Internation', 'En cours', '3ère Année après BAC', 'Moyen', 'Moyen', 'Aucun', 'Aucun', 6, 'AFRAM', '1', '2018-10-11', 0),
(31, 34, 8, 50, 8, 2, 23, NULL, 'Baccalauréat', 'Non obtenu', 'Terminale', 'Bon', 'Moyen', 'Aucun', 'Aucun', 2, 'Lycée Technique Omar Bongo', '1', '2018-10-18', 0),
(32, 35, 8, 51, 8, 2, 23, NULL, 'aucun', 'Non obtenu', '2ère Année après BAC', 'Bon', 'Moyen', 'Aucun', 'Aucun', 4, 'Institut National des Sciences de Gestio', '1', '2018-10-25', 0),
(33, 36, 8, 52, 8, 2, 23, NULL, 'CAP', 'Obtenu', 'CAP', 'Bon', 'Aucun', 'Aucun', 'Aucun', 2, 'Centre Interafricain pour le Développeme', '1', '2018-10-26', 0),
(34, 37, 8, 53, 8, 2, 23, NULL, 'CAP', 'Obtenu', 'CAP', 'Bon', 'Moyen', 'Aucun', 'Aucun', 2, 'Centre de Formation Professionnelle et d', '1', '2018-10-29', 0),
(35, 38, 8, 54, 8, 2, 23, NULL, 'Baccalauréat', 'Obtenu', 'Terminale', 'Bon', 'Aucun', 'Aucun', 'Aucun', 6, 'Lycée Privé Awassi', '1', '2018-11-05', 0),
(36, 39, 8, 55, 8, 2, 23, NULL, 'Baccalauéat', 'Non obtenu', 'Terminale', 'Bon', 'Moyen', 'Aucun', 'Aucun', 2, 'AWASSI', '1', '2018-11-06', 0),
(37, 40, 8, 56, 8, 2, 23, NULL, 'BACCALAUTEAT', 'Non obtenu', 'Aucun', 'Maternelle', 'Moyen', 'Aucun', 'Aucun', 5, 'ITA', '1', '2018-11-08', 0),
(38, 41, 8, 57, 8, 2, 23, NULL, 'Baccalauréat', 'Obtenu', 'Terminale', 'Bon', 'Moyen', 'Espagnol', 'Moyen', 6, 'Lycée Georges Mabignath', '1', '2018-11-12', 0),
(42, 45, 8, 61, 8, 2, 23, NULL, 'Baccalauréat', 'Non obtenu', 'Aucun', 'Moyen', 'Moyen', 'Aucun', 'Aucun', 2, 'Awassi', '1', '2018-11-21', 0),
(43, 46, 8, 62, 8, 2, 23, NULL, 'aucun', 'Non obtenu', 'Aucun', 'Bon', 'Aucun', 'Aucun', 'Aucun', 2, 'UPSA', '1', '2018-11-21', 0),
(44, 47, 8, 63, 8, 2, 23, NULL, 'Baccalauréat', 'Obtenu', 'Terminale', 'Bon', 'Moyen', 'Aucun', 'Aucun', 6, 'EPI', '1', '2018-11-26', 0),
(45, 48, 8, 64, 8, 2, 23, NULL, 'Baccalauréat', 'Non obtenu', 'Terminale', 'Bon', 'Moyen', 'Aucun', 'Aucun', 2, 'Jean-Baptiste Ossiéssie', '1', '2018-11-27', 0),
(46, 49, 8, 65, 8, 2, 23, NULL, 'Baccalauréat', 'Obtenu', 'Terminale', 'Bon', 'Moyen', 'Espagnol', 'Moyen', 3, 'EPI', '1', '2018-11-28', 0),
(47, 50, 8, 66, 8, 2, 23, NULL, 'Baccalauréat', 'Obtenu', 'Terminale', 'Bon', 'Moyen', 'Aucun', 'Aucun', 8, 'Lycée Technique de Ntoum', '1', '2018-12-11', 0),
(48, 51, 8, 67, 8, 2, 23, NULL, 'Baccalauréat', 'Obtenu', 'Terminale', 'Bon', 'Moyen', 'Espagnol', 'Faible', 3, 'C S Ambourouet', '1', '2019-01-10', 0);

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

--
-- Structure de la table `tbl_matiere_es`
--

CREATE TABLE IF NOT EXISTS `tbl_matiere_es` (
  `id_mat_es` int(11) NOT NULL AUTO_INCREMENT,
  `libel_mat_es` varchar(30) NOT NULL,
  `coef_mat_es` int(11) DEFAULT NULL,
  `credit_mat_es` int(11) DEFAULT NULL,
  `id_option_es` int(11) NOT NULL,
  PRIMARY KEY (`id_mat_es`),
  KEY `id_option_es` (`id_option_es`)
) ENGINE=InnoDB AUTO_INCREMENT=64 DEFAULT CHARSET=utf8;

--
-- Déchargement des données de la table `tbl_matiere_es`
--

INSERT INTO `tbl_matiere_es` (`id_mat_es`, `libel_mat_es`, `coef_mat_es`, `credit_mat_es`, `id_option_es`) VALUES
(21, 'Aucun', NULL, NULL, 23),
(22, 'Photoshop Niv I', NULL, NULL, 24),
(23, 'Illustrator 3', NULL, NULL, 24),
(24, 'Fondamentaux 1 & 2', NULL, NULL, 25),
(27, 'E-commerce', NULL, NULL, 26),
(28, 'InDesign', NULL, NULL, 24),
(29, 'Histoire de l\'art', NULL, NULL, 24),
(30, 'Communication médias', NULL, NULL, 25),
(31, 'Comprendre les 4P de la commun', NULL, NULL, 25),
(32, 'Adobe Première Pro', NULL, NULL, 27),
(33, 'Final Cut studio', NULL, NULL, 27),
(34, 'Cubase studio', NULL, NULL, 27),
(35, 'Logic Pro Studio', NULL, NULL, 27),
(36, 'Culture Digitale', NULL, NULL, 28),
(37, 'Anglais', NULL, NULL, 29),
(38, 'Comptabilité Générale', NULL, NULL, 30),
(39, 'Word', NULL, NULL, 31),
(40, 'Excell', NULL, NULL, 31),
(41, 'Organisation d\'entreprise', NULL, NULL, 32),
(42, 'Marketing DIgital', NULL, NULL, 33),
(43, 'Marketing Mobile', NULL, NULL, 33),
(44, 'Marketing', NULL, NULL, 33),
(45, 'Informatique', NULL, NULL, 34),
(46, 'CMS', NULL, NULL, 35),
(47, 'HTML5', NULL, NULL, 35),
(48, 'CSS3', NULL, NULL, 35),
(49, 'Web design', NULL, NULL, 38),
(50, 'Histoire de l\'art', NULL, NULL, 38),
(52, 'Médias et Réseaux sociaux', NULL, NULL, 36),
(53, 'Infographie et graphisme', NULL, NULL, 39),
(54, 'E-reputation et Personal Brand', NULL, NULL, 40),
(55, 'Création de contenu', NULL, NULL, 41),
(56, 'Développement personnel', NULL, NULL, 42),
(57, 'Powepoint', NULL, NULL, 31),
(58, 'Programmation Web', NULL, NULL, 43),
(59, 'E- commerce', NULL, NULL, 44),
(60, 'Marketing Mobile', NULL, NULL, 45),
(61, 'Droit numérique', NULL, NULL, 46),
(62, 'Multimedia ( vidéo & son)', NULL, NULL, 47),
(63, 'Vie et Orientation', NULL, NULL, 49);

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

--
-- Structure de la table `tbl_mention_veille_es`
--

CREATE TABLE IF NOT EXISTS `tbl_mention_veille_es` (
  `id_ment_veil_es` int(11) NOT NULL AUTO_INCREMENT,
  `id_sem_es` int(11) NOT NULL,
  `id_etudiant_es` int(11) NOT NULL,
  `mention_etd_es` varchar(50) DEFAULT NULL,
  `veille_etd_es` int(11) DEFAULT NULL,
  PRIMARY KEY (`id_ment_veil_es`),
  KEY `id_sem_es` (`id_sem_es`),
  KEY `id_etudiant_es` (`id_etudiant_es`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- Structure de la table `tbl_niveau_es`
--

CREATE TABLE IF NOT EXISTS `tbl_niveau_es` (
  `id_niveau_es` int(11) NOT NULL AUTO_INCREMENT,
  `libel_niveau_es` varchar(30) NOT NULL,
  `id_etbl_es` int(11) NOT NULL,
  PRIMARY KEY (`id_niveau_es`),
  KEY `id_etbl_es` (`id_etbl_es`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;

--
-- Déchargement des données de la table `tbl_niveau_es`
--

INSERT INTO `tbl_niveau_es` (`id_niveau_es`, `libel_niveau_es`, `id_etbl_es`) VALUES
(2, '1ère Année', 1),
(3, '2eme Année', 1);

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

--
-- Structure de la table `tbl_note_semestre_es`
--

CREATE TABLE IF NOT EXISTS `tbl_note_semestre_es` (
  `id_note_sem_es` int(11) NOT NULL AUTO_INCREMENT,
  `note_prem_sem_es` varchar(11) NOT NULL,
  `note_deu_sem_es` varchar(11) NOT NULL,
  `moy_gen_es` varchar(11) NOT NULL,
  `id_etudiant_es` int(11) NOT NULL,
  PRIMARY KEY (`id_note_sem_es`),
  KEY `id_etudiant_es` (`id_etudiant_es`)
) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8;

--
-- Déchargement des données de la table `tbl_note_semestre_es`
--

INSERT INTO `tbl_note_semestre_es` (`id_note_sem_es`, `note_prem_sem_es`, `note_deu_sem_es`, `moy_gen_es`, `id_etudiant_es`) VALUES
(1, '10,60', '12,32', '11,46', 29),
(2, '8,20', '12,83', '10,51', 41),
(3, '11,10', '11,80', '11,45', 34),
(4, '13,23', '15,22', '14,23', 33),
(5, '10,77', '14,03', '12,40', 31),
(6, '13,66', '14,31', '13,99', 26),
(7, '14,11', '15,02', '14,57', 27),
(8, '9,51', '12,76', '11,14', 36),
(9, '10,11', '13,79', '11,95', 32),
(10, '12,26', '13,48', '12,87', 35),
(11, '11,81', '14,15', '12,98', 51);

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

--
-- Structure de la table `tbl_notification_es`
--

CREATE TABLE IF NOT EXISTS `tbl_notification_es` (
  `id_notif_es` int(11) NOT NULL AUTO_INCREMENT,
  `date_notif_es` date DEFAULT NULL,
  `heure_notif_es` time DEFAULT NULL,
  `type_notif_es` varchar(50) NOT NULL,
  `status_notif_es` int(2) NOT NULL,
  `id_hist_es` int(11) NOT NULL,
  `id_user_es` int(11) NOT NULL,
  PRIMARY KEY (`id_notif_es`),
  KEY `id_histuser_es` (`id_hist_es`),
  KEY `id_user_es` (`id_user_es`)
) ENGINE=InnoDB AUTO_INCREMENT=48 DEFAULT CHARSET=utf8;

--
-- Déchargement des données de la table `tbl_notification_es`
--

INSERT INTO `tbl_notification_es` (`id_notif_es`, `date_notif_es`, `heure_notif_es`, `type_notif_es`, `status_notif_es`, `id_hist_es`, `id_user_es`) VALUES
(42, '2019-08-12', '12:29:52', 'Ajout_user', 1, 13, 13),
(43, '2019-07-02', '10:17:47', 'Ajout_user', 1, 13, 105),
(44, '2019-03-14', '10:32:28', 'Ajout_user', 1, 13, 153),
(45, '2019-08-14', '14:21:45', 'Ajout_inscription', 1, 14, 13),
(46, '2019-08-02', '12:28:23', 'Ajout_inscription', 1, 14, 105),
(47, NULL, NULL, 'Ajout_inscription', 0, 14, 153);

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

--
-- Structure de la table `tbl_option_es`
--

CREATE TABLE IF NOT EXISTS `tbl_option_es` (
  `id_option_es` int(11) NOT NULL AUTO_INCREMENT,
  `libel_option_es` varchar(40) NOT NULL,
  `unite_option_es` varchar(60) DEFAULT NULL,
  `id_etbl_es` int(11) NOT NULL,
  PRIMARY KEY (`id_option_es`),
  KEY `id_etbl_es` (`id_etbl_es`)
) ENGINE=InnoDB AUTO_INCREMENT=50 DEFAULT CHARSET=utf8;

--
-- Déchargement des données de la table `tbl_option_es`
--

INSERT INTO `tbl_option_es` (`id_option_es`, `libel_option_es`, `unite_option_es`, `id_etbl_es`) VALUES
(23, 'TRONC COMMUN', '', 1),
(24, 'INFOGRAPHIE & WEB DESIGN', '', 1),
(25, 'COMMUNICATION', '', 1),
(27, 'MULTIMÉDIA', '', 1),
(28, 'CULTURE DIGITALE', '', 1),
(29, 'ANGLAIS', '', 1),
(30, 'COMPTABILITE GESTION', '', 1),
(31, 'BUREAUTIQUE', '', 1),
(32, 'MANAGEMENT', '', 1),
(33, 'MARKETING', '', 1),
(34, 'ENVIRONNEMENT INFORMATIQUE', '', 1),
(35, 'DÉVELOPPEMENT WEB', '', 1),
(36, 'SOCIAL MEDIA', '', 1),
(38, 'WEB DESIGN', '', 1),
(39, 'INFOGRAPHIE', '', 1),
(40, 'E-REPUTATION', '', 1),
(41, 'CREATION DE CONTENU', '', 1),
(42, 'LEADERSHIP', '', 1),
(43, 'PROGRAMMATION WEB', 'UNITES FONDAMENALES', 1),
(44, 'E- COMMERCE', '', 1),
(45, 'MARKETING MOBILE', '', 1),
(46, 'DROIT NUMERIQUE', '', 1),
(47, 'MULTIMEDIA (vidéo & son)', '', 1),
(49, 'VIE ET ORIENTATION', '', 1);

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

--
-- Structure de la table `tbl_optmat_prof_es`
--

CREATE TABLE IF NOT EXISTS `tbl_optmat_prof_es` (
  `id_optmat_prof_es` int(11) NOT NULL AUTO_INCREMENT,
  `id_option_es` int(11) NOT NULL,
  `id_mat_es` int(11) NOT NULL,
  `id_emp_es` int(11) NOT NULL,
  `syllabus_matprof_es` varchar(70) DEFAULT NULL,
  `date_optmat_es` date NOT NULL,
  PRIMARY KEY (`id_optmat_prof_es`),
  KEY `id_option_es` (`id_option_es`),
  KEY `id_mat_es` (`id_mat_es`),
  KEY `id_emp_es` (`id_emp_es`)
) ENGINE=InnoDB AUTO_INCREMENT=71 DEFAULT CHARSET=utf8;

--
-- Déchargement des données de la table `tbl_optmat_prof_es`
--

INSERT INTO `tbl_optmat_prof_es` (`id_optmat_prof_es`, `id_option_es`, `id_mat_es`, `id_emp_es`, `syllabus_matprof_es`, `date_optmat_es`) VALUES
(40, 25, 24, 16, NULL, '2018-10-11'),
(41, 25, 30, 16, NULL, '2018-10-11'),
(42, 25, 31, 16, NULL, '2018-10-11'),
(43, 33, 44, 16, NULL, '2018-10-11'),
(44, 36, 52, 17, NULL, '2018-10-11'),
(45, 28, 36, 17, NULL, '2018-10-11'),
(46, 46, 61, 20, NULL, '2018-10-16'),
(47, 29, 37, 21, NULL, '2018-10-16'),
(48, 34, 45, 22, NULL, '2018-10-24'),
(49, 43, 58, 23, NULL, '2018-11-05'),
(50, 38, 49, 24, NULL, '2018-11-05'),
(51, 38, 50, 24, NULL, '2018-11-05'),
(52, 30, 38, 25, NULL, '2018-11-05'),
(53, 32, 41, 25, NULL, '2018-11-05'),
(54, 25, 24, 26, NULL, '2018-11-05'),
(55, 25, 30, 26, NULL, '2018-11-05'),
(56, 25, 31, 26, NULL, '2018-11-05'),
(57, 26, 27, 15, NULL, '2018-11-05'),
(58, 28, 36, 15, NULL, '2018-11-05'),
(59, 33, 42, 15, NULL, '2018-11-05'),
(60, 33, 43, 15, NULL, '2018-11-05'),
(61, 33, 44, 15, NULL, '2018-11-05'),
(63, 38, 49, 27, NULL, '2018-11-05'),
(64, 38, 50, 27, NULL, '2018-11-05'),
(65, 31, 39, 28, NULL, '2018-11-06'),
(66, 31, 40, 28, NULL, '2018-11-06'),
(67, 31, 57, 28, NULL, '2018-11-06'),
(68, 47, 62, 28, NULL, '2018-11-06'),
(69, 47, 62, 29, NULL, '2019-01-15'),
(70, 49, 63, 30, NULL, '2019-03-11');

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

--
-- Structure de la table `tbl_outil_es`
--

CREATE TABLE IF NOT EXISTS `tbl_outil_es` (
  `id_outil_es` int(11) NOT NULL AUTO_INCREMENT,
  `libel_outil_es` varchar(50) NOT NULL,
  `id_etbl_es` int(11) NOT NULL,
  PRIMARY KEY (`id_outil_es`),
  KEY `id_etbl_es` (`id_etbl_es`)
) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=utf8;

--
-- Déchargement des données de la table `tbl_outil_es`
--

INSERT INTO `tbl_outil_es` (`id_outil_es`, `libel_outil_es`, `id_etbl_es`) VALUES
(12, 'Vidéo-projecteur', 1),
(13, 'Ecran plasma', 1);

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

--
-- Structure de la table `tbl_outil_seance_es`
--

CREATE TABLE IF NOT EXISTS `tbl_outil_seance_es` (
  `id_outil_sce_es` int(11) NOT NULL AUTO_INCREMENT,
  `id_seance_es` int(11) NOT NULL,
  `id_outil_es` int(11) DEFAULT NULL,
  PRIMARY KEY (`id_outil_sce_es`),
  KEY `id_seance` (`id_seance_es`),
  KEY `id_outil_es` (`id_outil_es`)
) ENGINE=InnoDB AUTO_INCREMENT=341 DEFAULT CHARSET=utf8;

--
-- Déchargement des données de la table `tbl_outil_seance_es`
--

INSERT INTO `tbl_outil_seance_es` (`id_outil_sce_es`, `id_seance_es`, `id_outil_es`) VALUES
(1, 1, 12),
(2, 2, 13),
(3, 3, 13),
(4, 4, 12),
(5, 5, 12),
(6, 6, 13),
(7, 7, 13),
(8, 8, 13),
(9, 9, 13),
(10, 10, 13),
(11, 11, 13),
(12, 12, 13),
(13, 13, 13),
(14, 14, 13),
(15, 15, 13),
(17, 17, 13),
(18, 18, 12),
(19, 19, 13),
(20, 20, 13),
(21, 21, 13),
(22, 22, 13),
(23, 23, 12),
(24, 24, 12),
(25, 24, 13),
(26, 25, 12),
(27, 26, 13),
(28, 27, 13),
(32, 31, 13),
(33, 32, 13),
(34, 33, 13),
(35, 34, 12),
(36, 35, 13),
(37, 36, 13),
(38, 37, 13),
(39, 38, 13),
(40, 39, 13),
(41, 40, 13),
(42, 41, 13),
(43, 42, 13),
(44, 43, 13),
(45, 44, 12),
(46, 45, 12),
(47, 46, 13),
(52, 51, 12),
(53, 52, 12),
(54, 53, 13),
(55, 54, 13),
(56, 55, 12),
(57, 56, 13),
(58, 57, 13),
(59, 58, 13),
(60, 59, 13),
(61, 60, 13),
(62, 61, 13),
(63, 62, 13),
(64, 63, 13),
(65, 64, 13),
(66, 65, 13),
(67, 66, 13),
(69, 68, 13),
(70, 69, 13),
(71, 70, 13),
(72, 71, 13),
(73, 72, 13),
(74, 73, 13),
(75, 74, 13),
(76, 75, 13),
(77, 76, 13),
(78, 77, 13),
(79, 78, 13),
(80, 79, 13),
(81, 80, 13),
(82, 81, 13),
(83, 82, 13),
(84, 83, 12),
(85, 84, 13),
(86, 85, 13),
(87, 86, 13),
(88, 87, 13),
(89, 88, 13),
(90, 89, 13),
(91, 90, 13),
(92, 91, 13),
(93, 92, 13),
(94, 93, 13),
(95, 94, 12),
(96, 95, 12),
(97, 96, 12),
(98, 97, 12),
(99, 98, 13),
(100, 99, 13),
(101, 100, 13),
(102, 101, 13),
(103, 102, 13),
(104, 103, 13),
(105, 104, 13),
(106, 105, 13),
(107, 106, 13),
(108, 107, 13),
(109, 108, 12),
(110, 109, 12),
(111, 110, 13),
(112, 111, 13),
(113, 112, 13),
(114, 113, 13),
(115, 114, 13),
(116, 115, 13),
(117, 116, 13),
(118, 117, 13),
(119, 118, 13),
(120, 119, 13),
(121, 120, 13),
(122, 121, 13),
(123, 122, 13),
(124, 123, 13),
(125, 124, 13),
(126, 125, 13),
(127, 126, 13),
(128, 127, 13),
(129, 128, 13),
(130, 129, 13),
(131, 130, 13),
(132, 131, 13),
(133, 132, 13),
(134, 133, 13),
(135, 134, 13),
(136, 135, 13),
(137, 136, 13),
(138, 137, 13),
(139, 138, 12),
(140, 139, 12),
(142, 141, 13),
(143, 142, 13),
(144, 143, 13),
(145, 144, 13),
(146, 145, 13),
(147, 146, 13),
(148, 147, 13),
(149, 148, 13),
(150, 149, 13),
(151, 150, 13),
(152, 151, 13),
(153, 152, 13),
(154, 153, 13),
(155, 154, 13),
(156, 155, 13),
(157, 156, 13),
(158, 157, 13),
(159, 158, 13),
(160, 159, 13),
(161, 160, 13),
(162, 161, 12),
(163, 162, 12),
(164, 163, 12),
(169, 168, 13),
(170, 169, 13),
(171, 170, 13),
(172, 171, 13),
(173, 172, 13),
(174, 173, 13),
(175, 174, 13),
(176, 175, 13),
(177, 176, 13),
(178, 177, 13),
(179, 178, 13),
(180, 179, 13),
(181, 180, 13),
(182, 181, 13),
(183, 182, 13),
(184, 183, 13),
(185, 184, 13),
(186, 185, 13),
(187, 186, 12),
(188, 187, 12),
(189, 188, 12),
(190, 189, 13),
(193, 192, 13),
(194, 193, 13),
(195, 194, 13),
(196, 195, 13),
(197, 196, 13),
(199, 198, 13),
(200, 199, 13),
(201, 200, 13),
(202, 201, 13),
(203, 202, 13),
(204, 203, 13),
(205, 204, 13),
(206, 205, 13),
(207, 206, 13),
(208, 207, 12),
(209, 208, 12),
(210, 209, 12),
(211, 210, 12),
(212, 211, 12),
(213, 212, 12),
(214, 213, 13),
(215, 214, 13),
(217, 216, 13),
(218, 217, 13),
(219, 218, 13),
(220, 219, 13),
(221, 220, 13),
(222, 221, 12),
(223, 222, 12),
(224, 223, 12),
(225, 224, 12),
(226, 225, 13),
(227, 226, 13),
(228, 227, 13),
(229, 228, 12),
(230, 229, 12),
(231, 230, 12),
(232, 231, 13),
(234, 233, 13),
(235, 234, 13),
(236, 235, 13),
(237, 236, 13),
(240, 239, 13),
(241, 240, 13),
(242, 241, 12),
(243, 242, 12),
(244, 243, 13),
(245, 244, 13),
(246, 245, 12),
(247, 246, 12),
(248, 247, 12),
(249, 248, 12),
(250, 249, 13),
(251, 250, 13),
(252, 251, 13),
(253, 252, 13),
(254, 253, 13),
(255, 254, 12),
(256, 255, 12),
(257, 256, 13),
(258, 257, 13),
(259, 258, 13),
(260, 259, 13),
(261, 260, 13),
(262, 261, 13),
(263, 262, 13),
(264, 263, 13),
(265, 264, 12),
(266, 265, 12),
(267, 266, 12),
(268, 267, 12),
(269, 268, 12),
(270, 269, 12),
(271, 270, 12),
(272, 271, 12),
(273, 272, 13),
(274, 273, 13),
(275, 274, 12),
(276, 275, 12),
(277, 276, 13),
(278, 277, 13),
(279, 278, 13),
(280, 279, 13),
(281, 280, 13),
(282, 281, 12),
(283, 282, 12),
(284, 283, 12),
(285, 284, 12),
(286, 285, 13),
(287, 286, 13),
(288, 287, 13),
(289, 288, 13),
(290, 289, 13),
(291, 290, 12),
(292, 291, 12),
(293, 292, 13),
(294, 293, 13),
(295, 294, 12),
(296, 295, 13),
(297, 296, 13),
(298, 297, 13),
(299, 298, 12),
(300, 299, 12),
(301, 300, 13),
(302, 301, 13),
(303, 302, 13),
(304, 303, 13),
(305, 304, 13),
(306, 305, 13),
(307, 306, 13),
(308, 307, 13),
(309, 308, 13),
(310, 309, 13),
(311, 310, 13),
(312, 311, 12),
(313, 312, 12),
(314, 313, 12),
(315, 314, 12),
(316, 315, 13),
(317, 316, 13),
(318, 317, 13),
(319, 318, 13),
(320, 319, 12),
(321, 320, 12),
(322, 321, 13),
(323, 322, 13),
(324, 323, 13),
(325, 324, 13),
(326, 325, 12),
(327, 326, 12),
(328, 327, 12),
(329, 328, 13),
(330, 329, 13),
(331, 330, 13),
(332, 331, 13),
(333, 332, 13),
(334, 333, 13),
(335, 334, 13),
(336, 335, 13),
(337, 336, 12),
(338, 337, 12),
(339, 338, 13),
(340, 339, 13);

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

--
-- Structure de la table `tbl_partenaire_es`
--

CREATE TABLE IF NOT EXISTS `tbl_partenaire_es` (
  `id_part_es` int(11) NOT NULL AUTO_INCREMENT,
  `libel_part_es` varchar(30) NOT NULL,
  `nation_part_es` varchar(30) NOT NULL,
  `activite_part_es` varchar(40) NOT NULL,
  `tel_part_es` varchar(30) NOT NULL,
  `email_part_es` varchar(30) NOT NULL,
  `adress_part_es` varchar(30) NOT NULL,
  `bp_part_es` varchar(10) NOT NULL,
  `contrat_part_es` varchar(30) NOT NULL,
  `apport_part_es` varchar(50) NOT NULL,
  `date_part_es` date NOT NULL,
  `id_etbl_es` int(11) NOT NULL,
  PRIMARY KEY (`id_part_es`),
  KEY `id_etbl_es` (`id_etbl_es`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- Structure de la table `tbl_permission_es`
--

CREATE TABLE IF NOT EXISTS `tbl_permission_es` (
  `id_permission_es` int(11) NOT NULL AUTO_INCREMENT,
  `libel_permission_es` varchar(30) NOT NULL,
  `id_role_es` int(11) NOT NULL,
  PRIMARY KEY (`id_permission_es`),
  KEY `id_role_es` (`id_role_es`)
) ENGINE=InnoDB AUTO_INCREMENT=22 DEFAULT CHARSET=utf8;

--
-- Déchargement des données de la table `tbl_permission_es`
--

INSERT INTO `tbl_permission_es` (`id_permission_es`, `libel_permission_es`, `id_role_es`) VALUES
(17, 'Consulter utilisateur', 1),
(18, 'Modifier utilisateur', 1),
(19, 'creer utilisateur', 1),
(20, 'Creer droit', 1),
(21, 'Affecter droit', 1);

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

--
-- Structure de la table `tbl_profil_es`
--

CREATE TABLE IF NOT EXISTS `tbl_profil_es` (
  `id_profil_es` int(11) NOT NULL AUTO_INCREMENT,
  `libel_profil_es` varchar(40) NOT NULL,
  PRIMARY KEY (`id_profil_es`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;

--
-- Déchargement des données de la table `tbl_profil_es`
--

INSERT INTO `tbl_profil_es` (`id_profil_es`, `libel_profil_es`) VALUES
(1, 'Administration'),
(2, 'Professeur'),
(3, 'Etudiant');

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

--
-- Structure de la table `tbl_programme_examen_es`
--

CREATE TABLE IF NOT EXISTS `tbl_programme_examen_es` (
  `id_prog_examen` int(11) NOT NULL AUTO_INCREMENT,
  `id_exam_es` int(11) NOT NULL,
  `id_mat_es` int(11) NOT NULL,
  `id_classe_es` int(11) NOT NULL,
  `date_prog_exam` date NOT NULL,
  `jour_prog_exam` varchar(10) NOT NULL,
  `doc_prog_exam` varchar(60) DEFAULT NULL,
  `surveillant_prog_exam` varchar(50) DEFAULT NULL,
  `presence_prog_exam` varchar(30) DEFAULT NULL,
  `etat_prog_exam` int(2) NOT NULL,
  `type_exam_es` varchar(20) NOT NULL,
  `exam_annot_es` int(11) DEFAULT NULL,
  PRIMARY KEY (`id_prog_examen`),
  KEY `id_examen_es` (`id_exam_es`),
  KEY `id_mat_es` (`id_mat_es`),
  KEY `id_classe_es` (`id_classe_es`)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8;

--
-- Déchargement des données de la table `tbl_programme_examen_es`
--

INSERT INTO `tbl_programme_examen_es` (`id_prog_examen`, `id_exam_es`, `id_mat_es`, `id_classe_es`, `date_prog_exam`, `jour_prog_exam`, `doc_prog_exam`, `surveillant_prog_exam`, `presence_prog_exam`, `etat_prog_exam`, `type_exam_es`, `exam_annot_es`) VALUES
(8, 2, 44, 8, '2019-01-28', 'lundi', '', NULL, NULL, 0, 'Écrit', 20),
(9, 2, 44, 8, '2019-01-29', 'mardi', '', NULL, NULL, 0, 'Oral', 20),
(10, 2, 44, 8, '2019-01-29', 'mardi', '', NULL, NULL, 0, 'Oral', 20);

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

--
-- Structure de la table `tbl_reinscription_es`
--

CREATE TABLE IF NOT EXISTS `tbl_reinscription_es` (
  `id_reinscri_es` int(11) NOT NULL AUTO_INCREMENT,
  `id_classe_es` int(11) NOT NULL,
  `id_etudiant_es` int(11) NOT NULL,
  `id_an_aca_es` int(11) NOT NULL,
  `etat_reinsc_es` int(1) NOT NULL,
  `date_reinsc_es` date NOT NULL,
  `date_reinsc_p_es` date NOT NULL,
  PRIMARY KEY (`id_reinscri_es`),
  KEY `id_classe_es` (`id_classe_es`),
  KEY `id_etudiant_es` (`id_etudiant_es`),
  KEY `id_an_aca_es` (`id_an_aca_es`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- Structure de la table `tbl_respclasse_es`
--

CREATE TABLE IF NOT EXISTS `tbl_respclasse_es` (
  `id_respclasse_es` int(11) NOT NULL AUTO_INCREMENT,
  `id_classe_es` int(11) NOT NULL,
  `id_emp_es` int(11) NOT NULL,
  `date_resp_es` date NOT NULL,
  `annee_resp_es` varchar(5) NOT NULL,
  PRIMARY KEY (`id_respclasse_es`),
  KEY `id_classe_es` (`id_classe_es`),
  KEY `id_employe_es` (`id_emp_es`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- Structure de la table `tbl_role_es`
--

CREATE TABLE IF NOT EXISTS `tbl_role_es` (
  `id_role_es` int(11) NOT NULL AUTO_INCREMENT,
  `libel_role_es` varchar(30) NOT NULL,
  PRIMARY KEY (`id_role_es`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

--
-- Déchargement des données de la table `tbl_role_es`
--

INSERT INTO `tbl_role_es` (`id_role_es`, `libel_role_es`) VALUES
(1, 'Gestion des utilisateurs');

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

--
-- Structure de la table `tbl_salaire_es`
--

CREATE TABLE IF NOT EXISTS `tbl_salaire_es` (
  `id_salaire_es` int(11) NOT NULL AUTO_INCREMENT,
  `montant_sal_es` int(11) NOT NULL,
  `montant_salp_es` int(11) NOT NULL,
  `avance_sal_es` int(11) NOT NULL,
  `reste_sal_es` int(11) NOT NULL,
  `numcompt_sal_es` varchar(40) NOT NULL,
  `numcheq_sal_es` varchar(40) NOT NULL,
  `tel_money_sal_es` varchar(30) NOT NULL,
  `mois_sal_es` varchar(30) NOT NULL,
  `mode_paiesal_es` varchar(30) NOT NULL,
  `date_sal_es` date NOT NULL,
  `etat_sal_es` int(1) NOT NULL,
  `id_emp_es` int(11) NOT NULL,
  PRIMARY KEY (`id_salaire_es`),
  KEY `id_emp_es` (`id_emp_es`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- Structure de la table `tbl_scolarite_es`
--

CREATE TABLE IF NOT EXISTS `tbl_scolarite_es` (
  `id_param_scola_es` int(11) NOT NULL AUTO_INCREMENT,
  `id_classe_es` int(11) NOT NULL,
  `parcours_classe_es` varchar(40) NOT NULL,
  `montant_scola_es` int(11) NOT NULL,
  PRIMARY KEY (`id_param_scola_es`),
  KEY `id_classe_es` (`id_classe_es`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;

--
-- Déchargement des données de la table `tbl_scolarite_es`
--

INSERT INTO `tbl_scolarite_es` (`id_param_scola_es`, `id_classe_es`, `parcours_classe_es`, `montant_scola_es`) VALUES
(3, 8, 'Bachelor', 1100000);

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

--
-- Structure de la table `tbl_seance_cours_es`
--

CREATE TABLE IF NOT EXISTS `tbl_seance_cours_es` (
  `id_seance_es` int(11) NOT NULL AUTO_INCREMENT,
  `jour_seance_es` varchar(10) NOT NULL,
  `heures_d_es` time NOT NULL,
  `heures_f_es` time NOT NULL,
  `coms_prof_es` varchar(40) DEFAULT NULL,
  `coms_etd_es` varchar(40) DEFAULT NULL,
  `type_seance_es` varchar(40) NOT NULL,
  `date_cours_es` date NOT NULL,
  `mois_cours_es` int(3) NOT NULL,
  `etat_validseance_es` int(2) NOT NULL,
  PRIMARY KEY (`id_seance_es`)
) ENGINE=InnoDB AUTO_INCREMENT=340 DEFAULT CHARSET=utf8;

--
-- Déchargement des données de la table `tbl_seance_cours_es`
--

INSERT INTO `tbl_seance_cours_es` (`id_seance_es`, `jour_seance_es`, `heures_d_es`, `heures_f_es`, `coms_prof_es`, `coms_etd_es`, `type_seance_es`, `date_cours_es`, `mois_cours_es`, `etat_validseance_es`) VALUES
(1, 'lundi ', '08:00:00', '10:00:00', NULL, NULL, 'Cours simple', '2018-11-12', 11, 1),
(2, 'mardi ', '17:00:00', '19:00:00', NULL, NULL, 'Cours simple', '2018-11-06', 11, 1),
(3, 'vendredi ', '17:00:00', '19:00:00', NULL, NULL, 'Cours simple', '2018-11-09', 11, 1),
(4, 'mercredi ', '13:00:00', '15:00:00', NULL, NULL, 'Cours vidéo', '2018-11-07', 11, 1),
(5, 'lundi ', '13:00:00', '15:00:00', NULL, NULL, 'Cours vidéo', '2018-11-12', 11, 1),
(6, 'mercredi ', '17:00:00', '19:00:00', NULL, NULL, 'Cours simple', '2018-11-07', 11, 1),
(7, 'jeudi ', '10:00:00', '12:00:00', NULL, NULL, 'Cours simple', '2018-11-08', 11, 1),
(8, 'jeudi ', '08:00:00', '10:00:00', NULL, NULL, 'Cours simple', '2018-11-08', 11, 1),
(9, 'vendredi ', '08:00:00', '10:00:00', NULL, NULL, 'Cours simple', '2018-11-09', 11, 1),
(10, 'samedi ', '08:00:00', '10:00:00', NULL, NULL, 'Cours simple', '2018-11-10', 11, 1),
(11, 'jeudi ', '17:00:00', '19:00:00', NULL, NULL, 'Cours simple', '2018-11-08', 11, 1),
(12, 'lundi ', '17:00:00', '19:00:00', NULL, NULL, 'Cours simple', '2018-11-12', 11, 1),
(13, 'samedi ', '10:00:00', '12:00:00', NULL, NULL, 'Cours simple', '2018-11-10', 11, 1),
(14, 'mardi ', '10:00:00', '12:00:00', NULL, NULL, 'Cours simple', '2018-11-06', 11, 1),
(15, 'vendredi ', '10:00:00', '12:00:00', NULL, NULL, 'Cours simple', '2018-11-09', 11, 1),
(17, 'mardi ', '08:00:00', '10:00:00', NULL, NULL, 'Cours simple', '2018-11-06', 11, 1),
(18, 'mercredi ', '08:00:00', '12:00:00', NULL, NULL, 'Cours vidéo', '2018-11-07', 11, 1),
(19, 'jeudi ', '15:00:00', '17:00:00', NULL, NULL, 'Cours simple', '2018-11-08', 11, 1),
(20, 'mardi ', '13:00:00', '15:00:00', NULL, NULL, 'Cours simple', '2018-11-06', 11, 1),
(21, 'jeudi ', '13:00:00', '15:00:00', NULL, NULL, 'Cours simple', '2018-11-08', 11, 1),
(22, 'lundi ', '10:00:00', '12:00:00', NULL, NULL, 'Cours simple', '2018-11-12', 11, 1),
(23, 'mardi ', '15:00:00', '17:00:00', NULL, NULL, 'Cours vidéo', '2018-11-06', 11, 1),
(24, 'vendredi ', '15:00:00', '17:00:00', NULL, NULL, 'Cours vidéo', '2018-11-09', 11, 1),
(25, 'vendredi ', '13:00:00', '15:00:00', NULL, NULL, 'Cours vidéo', '2018-11-09', 11, 1),
(26, 'mercredi ', '15:00:00', '17:00:00', NULL, NULL, 'TD', '2018-11-07', 11, 1),
(27, 'lundi ', '15:00:00', '17:00:00', NULL, NULL, 'TD', '2018-11-12', 11, 1),
(31, 'samedi ', '08:00:00', '10:00:00', NULL, NULL, 'Cours simple', '2018-11-17', 11, 1),
(32, 'samedi ', '10:00:00', '12:00:00', NULL, NULL, 'Cours simple', '2018-11-17', 11, 1),
(33, 'vendredi ', '15:00:00', '17:00:00', NULL, NULL, 'Cours simple', '2018-11-16', 11, 1),
(34, 'mercredi ', '13:00:00', '15:00:00', NULL, NULL, 'Cours vidéo', '2018-11-14', 11, 1),
(35, 'vendredi ', '17:00:00', '19:00:00', NULL, NULL, 'Cours simple', '2018-11-16', 11, 1),
(36, 'jeudi ', '08:00:00', '10:00:00', NULL, NULL, 'Cours simple', '2018-11-15', 11, 1),
(37, 'vendredi ', '08:00:00', '10:00:00', NULL, NULL, 'Cours simple', '2018-11-16', 11, 1),
(38, 'mercredi ', '17:00:00', '19:00:00', NULL, NULL, 'Cours simple', '2018-11-14', 11, 1),
(39, 'jeudi ', '10:00:00', '12:00:00', NULL, NULL, 'Cours simple', '2018-11-15', 11, 1),
(40, 'jeudi ', '17:00:00', '19:00:00', NULL, NULL, 'Cours simple', '2018-11-15', 11, 1),
(41, 'mercredi ', '15:00:00', '17:00:00', NULL, NULL, 'Cours simple', '2018-11-14', 11, 1),
(42, 'jeudi ', '13:00:00', '15:00:00', NULL, NULL, 'Cours simple', '2018-11-15', 11, 1),
(43, 'jeudi ', '15:00:00', '17:00:00', NULL, NULL, 'Cours simple', '2018-11-15', 11, 1),
(44, 'vendredi ', '13:00:00', '15:00:00', NULL, NULL, 'Cours vidéo', '2018-11-16', 11, 1),
(45, 'mercredi ', '08:00:00', '12:00:00', NULL, NULL, 'Cours vidéo', '2018-11-14', 11, 1),
(46, 'lundi ', '08:00:00', '10:00:00', NULL, NULL, 'Cours simple', '2018-11-19', 11, 1),
(51, 'lundi ', '13:00:00', '15:00:00', NULL, NULL, 'Cours vidéo', '2018-11-19', 11, 1),
(52, 'mercredi ', '13:00:00', '15:00:00', NULL, NULL, 'Cours vidéo', '2018-11-21', 11, 1),
(53, 'lundi ', '17:00:00', '19:00:00', NULL, NULL, 'Cours simple', '2018-11-19', 11, 1),
(54, 'jeudi ', '17:00:00', '19:00:00', NULL, NULL, 'Cours simple', '2018-11-22', 11, 1),
(55, 'mercredi ', '08:00:00', '12:00:00', NULL, NULL, 'Cours vidéo', '2018-11-21', 11, 1),
(56, 'mardi ', '08:00:00', '10:00:00', NULL, NULL, 'Cours simple', '2018-11-20', 11, 1),
(57, 'lundi ', '13:00:00', '15:00:00', NULL, NULL, 'Cours simple', '2018-11-19', 11, 1),
(58, 'mardi ', '10:00:00', '12:00:00', NULL, NULL, 'Cours simple', '2018-11-20', 11, 1),
(59, 'vendredi ', '13:00:00', '15:00:00', NULL, NULL, 'Cours simple', '2018-11-23', 11, 1),
(60, 'mardi ', '17:00:00', '19:00:00', NULL, NULL, 'Cours simple', '2018-11-20', 11, 1),
(61, 'vendredi ', '17:00:00', '19:00:00', NULL, NULL, 'Cours simple', '2018-11-23', 11, 1),
(62, 'mercredi ', '17:00:00', '19:00:00', NULL, NULL, 'Cours simple', '2018-11-21', 1, 1),
(63, 'jeudi ', '10:00:00', '12:00:00', NULL, NULL, 'Cours simple', '2018-11-22', 11, 1),
(64, 'jeudi ', '08:00:00', '10:00:00', NULL, NULL, 'Cours simple', '2018-11-22', 11, 1),
(65, 'vendredi ', '08:00:00', '10:00:00', NULL, NULL, 'Cours simple', '2018-11-23', 11, 1),
(66, 'samedi ', '10:00:00', '12:00:00', NULL, NULL, 'Cours simple', '2018-11-24', 11, 1),
(68, 'lundi ', '15:00:00', '17:00:00', NULL, NULL, 'Cours simple', '2018-11-19', 11, 1),
(69, 'mercredi ', '15:00:00', '17:00:00', NULL, NULL, 'Cours simple', '2018-11-21', 11, 1),
(70, 'lundi ', '10:00:00', '12:00:00', NULL, NULL, 'Cours simple', '2018-11-19', 11, 1),
(71, 'jeudi ', '13:00:00', '15:00:00', NULL, NULL, 'Cours simple', '2018-11-22', 11, 1),
(72, 'samedi ', '08:00:00', '10:00:00', NULL, NULL, 'Cours simple', '2018-11-24', 11, 1),
(73, 'lundi ', '08:00:00', '10:00:00', NULL, NULL, 'Cours simple', '2018-11-26', 11, 1),
(74, 'jeudi ', '15:00:00', '17:00:00', NULL, NULL, 'Cours simple', '2018-11-29', 11, 1),
(75, 'lundi ', '10:00:00', '12:00:00', NULL, NULL, 'Cours simple', '2018-11-26', 11, 1),
(76, 'jeudi ', '13:00:00', '15:00:00', NULL, NULL, 'Cours simple', '2018-11-29', 11, 1),
(77, 'lundi ', '15:00:00', '17:00:00', NULL, NULL, 'Cours simple', '2018-11-26', 11, 1),
(78, 'mercredi ', '15:00:00', '17:00:00', NULL, NULL, 'Cours simple', '2018-11-28', 11, 1),
(79, 'lundi ', '17:00:00', '19:00:00', NULL, NULL, 'Cours simple', '2018-11-26', 11, 1),
(80, 'jeudi ', '17:00:00', '19:00:00', NULL, NULL, 'Cours simple', '2018-11-29', 11, 1),
(81, 'mardi ', '08:00:00', '10:00:00', NULL, NULL, 'Cours simple', '2018-11-27', 11, 1),
(82, 'mardi ', '13:00:00', '15:00:00', NULL, NULL, 'Cours simple', '2018-11-27', 11, 1),
(83, 'mercredi ', '08:00:00', '12:00:00', NULL, NULL, 'Cours vidéo', '2018-11-28', 11, 1),
(84, 'mercredi ', '17:00:00', '19:00:00', NULL, NULL, 'Cours simple', '2018-11-28', 11, 1),
(85, 'jeudi ', '10:00:00', '12:00:00', NULL, NULL, 'Cours simple', '2018-11-29', 11, 1),
(86, 'mardi ', '17:00:00', '19:00:00', NULL, NULL, 'Cours simple', '2018-11-27', 11, 1),
(87, 'vendredi ', '17:00:00', '19:00:00', NULL, NULL, 'Cours simple', '2018-11-30', 11, 1),
(88, 'mardi ', '10:00:00', '12:00:00', NULL, NULL, 'Cours simple', '2018-11-27', 11, 1),
(89, 'vendredi ', '15:00:00', '17:00:00', NULL, NULL, 'Cours simple', '2018-11-30', 11, 1),
(90, 'samedi ', '10:00:00', '12:00:00', NULL, NULL, 'Cours simple', '2018-12-01', 12, 1),
(91, 'samedi ', '08:00:00', '10:00:00', NULL, NULL, 'Cours simple', '2018-12-01', 12, 1),
(92, 'jeudi ', '08:00:00', '10:00:00', NULL, NULL, 'Cours simple', '2018-11-29', 11, 1),
(93, 'dimanche ', '08:00:00', '10:00:00', NULL, NULL, 'Cours simple', '2018-12-30', 12, 1),
(94, 'lundi ', '13:00:00', '15:00:00', NULL, NULL, 'Cours vidéo', '2018-11-26', 11, 1),
(95, 'mercredi ', '13:00:00', '15:00:00', NULL, NULL, 'Cours vidéo', '2018-11-28', 11, 1),
(96, 'vendredi ', '10:00:00', '12:00:00', NULL, NULL, 'Cours vidéo', '2018-11-30', 11, 1),
(97, 'vendredi ', '10:00:00', '12:00:00', NULL, NULL, 'Cours vidéo', '2018-12-07', 12, 1),
(98, 'mardi ', '08:00:00', '10:00:00', NULL, NULL, 'Cours simple', '2018-12-04', 12, 1),
(99, 'mardi ', '13:00:00', '15:00:00', NULL, NULL, 'Cours simple', '2018-12-04', 12, 1),
(100, 'jeudi ', '15:00:00', '17:00:00', NULL, NULL, 'Cours simple', '2018-12-06', 12, 1),
(101, 'lundi ', '08:00:00', '10:00:00', NULL, NULL, 'Cours simple', '2018-12-03', 12, 1),
(102, 'mardi ', '10:00:00', '12:00:00', NULL, NULL, 'Cours simple', '2018-12-04', 12, 1),
(103, 'vendredi ', '15:00:00', '17:00:00', NULL, NULL, 'Cours simple', '2018-12-07', 12, 1),
(104, 'lundi ', '15:00:00', '17:00:00', NULL, NULL, 'Cours simple', '2018-12-03', 12, 1),
(105, 'mercredi ', '15:00:00', '17:00:00', NULL, NULL, 'Cours simple', '2018-12-05', 12, 1),
(106, 'lundi ', '10:00:00', '12:00:00', NULL, NULL, 'Cours simple', '2018-12-03', 12, 1),
(107, 'jeudi ', '13:00:00', '15:00:00', NULL, NULL, 'Cours simple', '2018-12-06', 12, 1),
(108, 'lundi ', '13:00:00', '15:00:00', NULL, NULL, 'Cours vidéo', '2018-12-03', 12, 1),
(109, 'mercredi ', '13:00:00', '15:00:00', NULL, NULL, 'Cours vidéo', '2018-12-05', 12, 1),
(110, 'lundi ', '17:00:00', '19:00:00', NULL, NULL, 'Cours simple', '2018-12-03', 12, 1),
(111, 'jeudi ', '17:00:00', '19:00:00', NULL, NULL, 'Cours simple', '2018-12-06', 12, 1),
(112, 'mardi ', '17:00:00', '19:00:00', NULL, NULL, 'Cours simple', '2018-12-04', 12, 0),
(113, 'vendredi ', '17:00:00', '19:00:00', NULL, NULL, 'Cours simple', '2018-12-07', 12, 0),
(114, 'mercredi ', '17:00:00', '19:00:00', NULL, NULL, 'Cours simple', '2018-12-05', 12, 1),
(115, 'jeudi ', '10:00:00', '12:00:00', NULL, NULL, 'Cours simple', '2018-12-06', 12, 1),
(116, 'jeudi ', '08:00:00', '10:00:00', NULL, NULL, 'Cours simple', '2018-12-06', 12, 1),
(117, 'vendredi ', '08:00:00', '10:00:00', NULL, NULL, 'Cours simple', '2018-12-07', 12, 1),
(118, 'samedi ', '08:00:00', '10:00:00', NULL, NULL, 'Cours simple', '2018-12-08', 12, 1),
(119, 'samedi ', '10:00:00', '12:00:00', NULL, NULL, 'Cours simple', '2018-12-08', 12, 1),
(120, 'samedi ', '10:00:00', '12:00:00', NULL, NULL, 'Cours simple', '2018-12-15', 12, 1),
(121, 'lundi ', '15:00:00', '17:00:00', NULL, NULL, 'Cours simple', '2018-12-10', 12, 1),
(122, 'mercredi ', '15:00:00', '17:00:00', NULL, NULL, 'Cours simple', '2018-12-12', 12, 1),
(123, 'lundi ', '10:00:00', '12:00:00', NULL, NULL, 'Cours simple', '2018-12-10', 12, 1),
(124, 'jeudi ', '13:00:00', '15:00:00', NULL, NULL, 'Cours simple', '2018-12-13', 12, 1),
(125, 'mardi ', '16:00:00', '18:00:00', NULL, NULL, 'Cours simple', '2018-12-11', 12, 1),
(126, 'vendredi ', '16:00:00', '18:00:00', NULL, NULL, 'Cours simple', '2018-12-14', 12, 1),
(127, 'jeudi ', '08:00:00', '10:00:00', NULL, NULL, 'Cours simple', '2018-12-13', 12, 1),
(128, 'vendredi ', '08:00:00', '10:00:00', NULL, NULL, 'Cours simple', '2018-12-14', 12, 1),
(129, 'samedi ', '08:00:00', '10:00:00', NULL, NULL, 'Cours simple', '2018-12-15', 12, 1),
(130, 'lundi ', '08:00:00', '10:00:00', NULL, NULL, 'Cours simple', '2018-12-10', 12, 1),
(131, 'jeudi ', '15:00:00', '17:00:00', NULL, NULL, 'Cours simple', '2018-12-13', 12, 1),
(132, 'mardi ', '10:00:00', '12:00:00', NULL, NULL, 'Cours simple', '2018-12-11', 12, 1),
(133, 'jeudi ', '10:00:00', '12:00:00', NULL, NULL, 'Cours simple', '2018-12-13', 12, 1),
(134, 'lundi ', '17:00:00', '19:00:00', NULL, NULL, 'Cours simple', '2018-12-10', 12, 1),
(135, 'jeudi ', '17:00:00', '19:00:00', NULL, NULL, 'Cours simple', '2018-12-13', 12, 1),
(136, 'mardi ', '13:00:00', '15:00:00', NULL, NULL, 'Cours simple', '2018-12-11', 12, 1),
(137, 'vendredi ', '13:00:00', '15:00:00', NULL, NULL, 'Cours simple', '2018-12-14', 12, 1),
(138, 'vendredi ', '15:00:00', '16:00:00', NULL, NULL, 'Cours simple', '2018-12-14', 12, 1),
(139, 'mardi ', '15:00:00', '16:00:00', NULL, NULL, 'Cours simple', '2018-12-11', 12, 1),
(141, 'samedi ', '10:00:00', '13:00:00', NULL, NULL, 'Cours simple', '2018-12-22', 12, 1),
(142, 'lundi ', '15:00:00', '17:00:00', NULL, NULL, 'Cours simple', '2018-12-17', 12, 1),
(143, 'mercredi ', '15:00:00', '17:00:00', NULL, NULL, 'Cours simple', '2018-12-19', 12, 1),
(144, 'lundi ', '10:00:00', '12:00:00', NULL, NULL, 'Cours simple', '2018-12-17', 12, 1),
(145, 'jeudi ', '13:00:00', '15:00:00', NULL, NULL, 'Cours simple', '2018-12-20', 12, 1),
(146, 'lundi ', '13:00:00', '15:00:00', NULL, NULL, 'Cours simple', '2018-12-17', 12, 1),
(147, 'mercredi ', '13:00:00', '15:00:00', NULL, NULL, 'Cours simple', '2018-12-19', 12, 1),
(148, 'mardi ', '16:00:00', '18:00:00', NULL, NULL, 'Cours simple', '2018-12-18', 12, 1),
(149, 'vendredi ', '16:00:00', '18:00:00', NULL, NULL, 'Cours simple', '2018-12-21', 12, 1),
(150, 'jeudi ', '08:00:00', '10:00:00', NULL, NULL, 'Cours simple', '2018-12-20', 12, 1),
(151, 'vendredi ', '08:00:00', '10:00:00', NULL, NULL, 'Cours simple', '2018-12-21', 12, 1),
(152, 'samedi ', '08:00:00', '10:00:00', NULL, NULL, 'Cours simple', '2018-12-22', 12, 1),
(153, 'lundi ', '08:00:00', '10:00:00', NULL, NULL, 'Cours simple', '2018-12-17', 12, 1),
(154, 'jeudi ', '15:00:00', '17:00:00', NULL, NULL, 'Cours simple', '2018-12-20', 12, 1),
(155, 'mardi ', '10:00:00', '12:00:00', NULL, NULL, 'Cours simple', '2018-12-18', 12, 0),
(156, 'jeudi ', '10:00:00', '12:00:00', NULL, NULL, 'Cours simple', '2018-12-20', 12, 0),
(157, 'lundi ', '17:00:00', '19:00:00', NULL, NULL, 'Cours simple', '2018-12-17', 12, 1),
(158, 'mercredi ', '17:00:00', '19:00:00', NULL, NULL, 'Cours simple', '2018-12-19', 12, 1),
(159, 'mardi ', '13:00:00', '15:00:00', NULL, NULL, 'Cours simple', '2018-12-18', 12, 1),
(160, 'vendredi ', '13:00:00', '15:00:00', NULL, NULL, 'Cours simple', '2018-12-21', 12, 1),
(161, 'mardi ', '15:00:00', '17:00:00', NULL, NULL, 'Cours vidéo', '2018-12-18', 12, 1),
(162, 'vendredi ', '15:00:00', '17:00:00', NULL, NULL, 'Cours vidéo', '2018-12-21', 12, 1),
(163, 'mercredi ', '08:00:00', '12:00:00', NULL, NULL, 'Cours vidéo', '2018-12-19', 12, 1),
(168, 'jeudi ', '08:00:00', '10:00:00', NULL, NULL, 'Cours simple', '2019-01-10', 1, 1),
(169, 'vendredi ', '08:00:00', '10:00:00', NULL, NULL, 'Cours simple', '2019-01-11', 1, 1),
(170, 'samedi ', '08:00:00', '10:00:00', NULL, NULL, 'Cours simple', '2019-01-12', 1, 1),
(171, 'samedi ', '10:00:00', '12:00:00', NULL, NULL, 'Cours simple', '2019-01-12', 1, 1),
(172, 'lundi ', '15:00:00', '17:00:00', NULL, NULL, 'Cours simple', '2019-01-07', 1, 1),
(173, 'mercredi ', '15:00:00', '17:00:00', NULL, NULL, 'Cours simple', '2019-01-09', 1, 1),
(174, 'lundi ', '10:00:00', '12:00:00', NULL, NULL, 'Cours simple', '2019-01-07', 1, 1),
(175, 'jeudi ', '13:00:00', '15:00:00', NULL, NULL, 'Cours simple', '2019-01-10', 1, 1),
(176, 'mardi ', '13:00:00', '15:00:00', NULL, NULL, 'Cours simple', '2019-01-08', 1, 1),
(177, 'vendredi ', '13:00:00', '15:00:00', NULL, NULL, 'Cours simple', '2019-01-11', 1, 1),
(178, 'lundi ', '13:00:00', '15:00:00', NULL, NULL, 'Cours simple', '2019-01-07', 1, 1),
(179, 'mercredi ', '13:00:00', '15:00:00', NULL, NULL, 'Cours simple', '2019-01-09', 1, 1),
(180, 'mardi ', '16:00:00', '18:00:00', NULL, NULL, 'Cours simple', '2019-01-08', 1, 1),
(181, 'vendredi ', '16:00:00', '18:00:00', NULL, NULL, 'Cours simple', '2019-01-11', 1, 1),
(182, 'lundi ', '17:00:00', '19:00:00', NULL, NULL, 'Cours simple', '2019-01-07', 1, 1),
(183, 'mercredi ', '17:00:00', '19:00:00', NULL, NULL, 'Cours simple', '2019-01-09', 1, 1),
(184, 'lundi ', '08:00:00', '10:00:00', NULL, NULL, 'Cours simple', '2019-01-07', 1, 1),
(185, 'jeudi ', '15:00:00', '17:00:00', NULL, NULL, 'Cours simple', '2019-01-10', 1, 1),
(186, 'mardi ', '15:00:00', '16:00:00', NULL, NULL, 'Cours vidéo', '2019-01-08', 1, 1),
(187, 'vendredi ', '15:00:00', '16:00:00', NULL, NULL, 'Cours vidéo', '2019-01-11', 1, 1),
(188, 'mercredi ', '08:00:00', '12:00:00', NULL, NULL, 'Cours vidéo', '2019-01-09', 1, 1),
(189, 'samedi ', '10:00:00', '12:00:00', NULL, NULL, 'Cours simple', '2019-01-19', 1, 1),
(192, 'samedi ', '08:00:00', '10:00:00', NULL, NULL, 'Cours simple', '2019-01-19', 1, 1),
(193, 'lundi ', '17:00:00', '19:00:00', NULL, NULL, 'Cours simple', '2019-01-14', 1, 1),
(194, 'mercredi ', '17:00:00', '19:00:00', NULL, NULL, 'Cours simple', '2019-01-16', 1, 1),
(195, 'lundi ', '08:00:00', '10:00:00', NULL, NULL, 'Cours simple', '2019-01-14', 1, 1),
(196, 'jeudi ', '15:00:00', '17:00:00', NULL, NULL, 'Cours simple', '2019-01-17', 1, 1),
(198, 'lundi ', '13:00:00', '15:00:00', NULL, NULL, 'Cours simple', '2019-01-14', 1, 1),
(199, 'vendredi ', '13:00:00', '15:00:00', NULL, NULL, 'Cours simple', '2019-01-18', 1, 1),
(200, 'jeudi ', '08:00:00', '10:00:00', NULL, NULL, 'Cours simple', '2019-01-17', 1, 1),
(201, 'vendredi ', '08:00:00', '10:00:00', NULL, NULL, 'Cours simple', '2019-01-18', 1, 1),
(202, 'lundi ', '15:00:00', '17:00:00', NULL, NULL, 'Cours simple', '2019-01-14', 1, 1),
(203, 'mercredi ', '15:00:00', '17:00:00', NULL, NULL, 'Cours simple', '2019-01-16', 1, 1),
(204, 'lundi ', '10:00:00', '12:00:00', NULL, NULL, 'Cours simple', '2019-01-14', 1, 1),
(205, 'jeudi ', '13:00:00', '15:00:00', NULL, NULL, 'Cours simple', '2019-01-17', 1, 1),
(206, 'vendredi ', '15:00:00', '16:00:00', NULL, NULL, 'Cours vidéo', '2019-01-18', 1, 1),
(207, 'mardi ', '08:00:00', '10:00:00', NULL, NULL, 'Cours vidéo', '2019-01-15', 1, 1),
(208, 'vendredi ', '10:00:00', '12:00:00', NULL, NULL, 'Cours vidéo', '2019-01-18', 1, 1),
(209, 'mardi ', '15:00:00', '16:00:00', NULL, NULL, 'Cours vidéo', '2019-01-15', 1, 0),
(210, 'lundi ', '13:00:00', '15:00:00', NULL, NULL, 'Cours vidéo', '2019-01-14', 1, 1),
(211, 'mercredi ', '13:00:00', '15:00:00', NULL, NULL, 'Cours vidéo', '2019-01-16', 1, 1),
(212, 'mercredi ', '08:00:00', '12:00:00', NULL, NULL, 'Cours vidéo', '2019-01-16', 1, 1),
(213, 'samedi ', '10:00:00', '12:00:00', NULL, NULL, 'Cours simple', '2019-01-26', 1, 1),
(214, 'samedi ', '08:00:00', '10:00:00', NULL, NULL, 'Cours simple', '2019-01-26', 1, 1),
(216, 'jeudi ', '15:00:00', '17:00:00', NULL, NULL, 'Cours simple', '2019-01-24', 1, 1),
(217, 'lundi ', '15:00:00', '17:00:00', NULL, NULL, 'Cours simple', '2019-01-21', 1, 1),
(218, 'mercredi ', '15:00:00', '17:00:00', NULL, NULL, 'Cours simple', '2019-01-23', 1, 1),
(219, 'lundi ', '10:00:00', '12:00:00', NULL, NULL, 'Cours simple', '2019-01-21', 1, 1),
(220, 'jeudi ', '13:00:00', '15:00:00', NULL, NULL, 'Cours simple', '2019-01-24', 1, 1),
(221, 'mardi ', '08:00:00', '10:00:00', NULL, NULL, 'Cours vidéo', '2019-01-22', 1, 1),
(222, 'vendredi ', '10:00:00', '12:00:00', NULL, NULL, 'Cours vidéo', '2019-01-25', 1, 1),
(223, 'lundi ', '13:00:00', '15:00:00', NULL, NULL, 'Cours vidéo', '2019-01-21', 1, 1),
(224, 'mercredi ', '13:00:00', '15:00:00', NULL, NULL, 'Cours vidéo', '2019-01-23', 1, 1),
(225, 'jeudi ', '08:00:00', '11:00:00', NULL, NULL, 'Cours simple', '2019-01-24', 1, 1),
(226, 'lundi ', '17:00:00', '19:00:00', NULL, NULL, 'Cours simple', '2019-01-21', 1, 1),
(227, 'mercredi ', '17:00:00', '19:00:00', NULL, NULL, 'Cours simple', '2019-01-23', 1, 1),
(228, 'mercredi ', '08:00:00', '12:00:00', NULL, NULL, 'Cours vidéo', '2019-01-23', 1, 1),
(229, 'mardi ', '15:00:00', '16:00:00', NULL, NULL, 'Cours vidéo', '2019-01-22', 1, 1),
(230, 'vendredi ', '15:00:00', '16:00:00', NULL, NULL, 'Cours vidéo', '2019-01-25', 1, 1),
(231, 'mardi ', '13:00:00', '15:00:00', NULL, NULL, 'Cours simple', '2019-01-22', 1, 1),
(233, 'lundi ', '15:00:00', '17:00:00', NULL, NULL, 'Cours simple', '2019-01-28', 1, 1),
(234, 'mercredi ', '15:00:00', '17:00:00', NULL, NULL, 'Cours simple', '2019-01-30', 1, 1),
(235, 'lundi ', '10:00:00', '12:00:00', NULL, NULL, 'Cours simple', '2019-01-28', 1, 1),
(236, 'jeudi ', '13:00:00', '15:00:00', NULL, NULL, 'Cours simple', '2019-01-31', 1, 1),
(239, 'mercredi ', '10:00:00', '12:00:00', NULL, NULL, 'Cours simple', '2019-01-30', 1, 1),
(240, 'vendredi ', '13:00:00', '15:00:00', NULL, NULL, 'Cours simple', '2019-02-01', 2, 1),
(241, 'mardi ', '08:00:00', '10:00:00', NULL, NULL, 'Cours vidéo', '2019-01-29', 1, 1),
(242, 'vendredi ', '10:00:00', '12:00:00', NULL, NULL, 'Cours vidéo', '2019-02-01', 2, 1),
(243, 'lundi ', '17:00:00', '19:00:00', NULL, NULL, 'Cours simple', '2019-01-28', 1, 1),
(244, 'mercredi ', '17:00:00', '19:00:00', NULL, NULL, 'Cours simple', '2019-01-30', 1, 1),
(245, 'lundi ', '13:00:00', '15:00:00', NULL, NULL, 'Cours vidéo', '2019-01-28', 1, 1),
(246, 'mercredi ', '13:00:00', '15:00:00', NULL, NULL, 'Cours vidéo', '2019-01-30', 1, 1),
(247, 'mardi ', '15:00:00', '16:00:00', NULL, NULL, 'Cours vidéo', '2019-01-29', 1, 1),
(248, 'vendredi ', '15:00:00', '16:00:00', NULL, NULL, 'Cours vidéo', '2019-02-01', 2, 1),
(249, 'mercredi ', '08:00:00', '10:00:00', NULL, NULL, 'Cours simple', '2019-01-30', 1, 1),
(250, 'jeudi ', '15:00:00', '17:00:00', NULL, NULL, 'Cours simple', '2019-01-31', 1, 1),
(251, 'jeudi ', '17:00:00', '19:00:00', NULL, NULL, 'Cours simple', '2019-01-31', 1, 1),
(252, 'mercredi ', '17:00:00', '19:00:00', NULL, NULL, 'Cours simple', '2019-02-06', 2, 1),
(253, 'mercredi ', '08:00:00', '12:00:00', NULL, NULL, 'Cours simple', '2019-02-06', 2, 1),
(254, 'lundi ', '13:00:00', '15:00:00', NULL, NULL, 'Cours vidéo', '2019-02-04', 2, 1),
(255, 'mercredi ', '13:00:00', '15:00:00', NULL, NULL, 'Cours vidéo', '2019-02-06', 2, 1),
(256, 'lundi ', '17:00:00', '19:00:00', NULL, NULL, 'Cours simple', '2019-02-04', 2, 1),
(257, 'mardi ', '17:00:00', '19:00:00', NULL, NULL, 'Cours simple', '2019-02-05', 2, 1),
(258, 'vendredi ', '17:00:00', '19:00:00', NULL, NULL, 'Cours simple', '2019-02-08', 2, 1),
(259, 'lundi ', '15:00:00', '17:00:00', NULL, NULL, 'Cours simple', '2019-02-04', 2, 1),
(260, 'mercredi ', '15:00:00', '17:00:00', NULL, NULL, 'Cours simple', '2019-02-06', 2, 1),
(261, 'lundi ', '10:00:00', '12:00:00', NULL, NULL, 'Cours simple', '2019-02-04', 2, 1),
(262, 'jeudi ', '13:00:00', '15:00:00', NULL, NULL, 'Cours simple', '2019-02-07', 2, 1),
(263, 'jeudi ', '17:00:00', '19:00:00', NULL, NULL, 'Cours simple', '2019-02-07', 2, 1),
(264, 'mardi ', '08:00:00', '10:00:00', NULL, NULL, 'Cours vidéo', '2019-02-05', 2, 1),
(265, 'vendredi ', '10:00:00', '12:00:00', NULL, NULL, 'Cours vidéo', '2019-02-08', 2, 1),
(266, 'mardi ', '15:00:00', '16:00:00', NULL, NULL, 'Cours vidéo', '2019-02-05', 2, 0),
(267, 'vendredi ', '15:00:00', '16:00:00', NULL, NULL, 'Cours vidéo', '2019-02-08', 2, 1),
(268, 'lundi ', '08:00:00', '10:00:00', NULL, NULL, 'Cours vidéo', '2019-02-04', 2, 1),
(269, 'jeudi ', '08:00:00', '10:00:00', NULL, NULL, 'Cours vidéo', '2019-02-07', 2, 1),
(270, 'lundi ', '08:00:00', '10:00:00', NULL, NULL, 'Cours vidéo', '2019-02-11', 2, 1),
(271, 'jeudi ', '08:00:00', '10:00:00', NULL, NULL, 'Cours vidéo', '2019-02-14', 2, 1),
(272, 'mardi ', '10:00:00', '12:00:00', NULL, NULL, 'Cours simple', '2019-02-12', 2, 1),
(273, 'mercredi ', '17:00:00', '19:00:00', NULL, NULL, 'Cours simple', '2019-02-13', 2, 1),
(274, 'lundi ', '13:00:00', '15:00:00', NULL, NULL, 'Cours vidéo', '2019-02-11', 2, 1),
(275, 'mercredi ', '13:00:00', '15:00:00', NULL, NULL, 'Cours vidéo', '2019-02-13', 2, 1),
(276, 'mercredi ', '08:00:00', '12:00:00', NULL, NULL, 'Cours simple', '2019-02-13', 2, 1),
(277, 'mardi ', '16:00:00', '18:30:00', NULL, NULL, 'Cours simple', '2019-02-12', 2, 1),
(278, 'vendredi ', '16:00:00', '18:30:00', NULL, NULL, 'Cours simple', '2019-02-15', 2, 1),
(279, 'mardi ', '13:00:00', '15:00:00', NULL, NULL, 'Cours simple', '2019-02-12', 2, 1),
(280, 'jeudi ', '13:00:00', '15:00:00', NULL, NULL, 'Cours simple', '2019-02-14', 2, 1),
(281, 'mardi ', '08:00:00', '12:00:00', NULL, NULL, 'Cours vidéo', '2019-02-12', 2, 1),
(282, 'vendredi ', '13:00:00', '15:00:00', NULL, NULL, 'Cours vidéo', '2019-02-15', 2, 1),
(283, 'mardi ', '15:00:00', '16:00:00', NULL, NULL, 'Cours vidéo', '2019-02-12', 2, 1),
(284, 'vendredi ', '15:00:00', '16:00:00', NULL, NULL, 'Cours vidéo', '2019-02-15', 2, 1),
(285, 'jeudi ', '17:00:00', '19:00:00', NULL, NULL, 'Cours simple', '2019-02-14', 2, 1),
(286, 'lundi ', '10:00:00', '12:00:00', NULL, NULL, 'Cours simple', '2019-02-11', 2, 1),
(287, 'vendredi ', '08:00:00', '12:00:00', NULL, NULL, 'Cours simple', '2019-02-15', 2, 1),
(288, 'jeudi ', '15:00:00', '17:00:00', NULL, NULL, 'Cours simple', '2019-02-14', 2, 1),
(289, 'vendredi ', '13:00:00', '15:00:00', NULL, NULL, 'Cours simple', '2019-02-15', 2, 1),
(290, 'lundi ', '08:00:00', '10:00:00', NULL, NULL, 'Cours vidéo', '2019-02-18', 2, 1),
(291, 'jeudi ', '08:00:00', '10:00:00', NULL, NULL, 'Cours vidéo', '2019-02-21', 2, 1),
(292, 'lundi ', '10:00:00', '12:00:00', NULL, NULL, 'Cours simple', '2019-02-18', 2, 1),
(293, 'vendredi ', '08:00:00', '10:00:00', NULL, NULL, 'Cours simple', '2019-02-22', 2, 1),
(294, 'lundi ', '13:00:00', '15:00:00', NULL, NULL, 'Cours vidéo', '2019-02-18', 2, 1),
(295, 'mercredi ', '13:00:00', '15:00:00', NULL, NULL, 'Cours vidéo', '2019-02-20', 2, 1),
(296, 'lundi ', '10:00:00', '12:00:00', NULL, NULL, 'Cours simple', '2019-03-18', 3, 1),
(297, 'vendredi ', '08:00:00', '10:00:00', NULL, NULL, 'Cours simple', '2019-03-22', 3, 1),
(298, 'lundi ', '13:00:00', '15:00:00', NULL, NULL, 'Cours vidéo', '2019-03-18', 3, 0),
(299, 'vendredi ', '13:00:00', '15:00:00', NULL, NULL, 'Cours vidéo', '2019-02-22', 2, 0),
(300, 'mercredi ', '17:00:00', '19:00:00', NULL, NULL, 'Cours simple', '2019-02-20', 2, 1),
(301, 'jeudi ', '08:00:00', '10:00:00', NULL, NULL, 'Cours simple', '2019-02-28', 2, 1),
(302, 'jeudi ', '08:00:00', '10:00:00', NULL, NULL, 'Cours simple', '2019-03-07', 3, 1),
(303, 'mercredi ', '08:00:00', '12:00:00', NULL, NULL, 'Cours simple', '2019-03-06', 3, 1),
(304, 'mardi ', '13:00:00', '15:00:00', NULL, NULL, 'Cours simple', '2019-03-05', 3, 1),
(305, 'jeudi ', '13:00:00', '15:00:00', NULL, NULL, 'Cours simple', '2019-03-07', 3, 1),
(306, 'mardi ', '16:00:00', '18:30:00', NULL, NULL, 'Cours simple', '2019-03-05', 3, 1),
(307, 'vendredi ', '16:00:00', '18:30:00', NULL, NULL, 'Cours simple', '2019-03-08', 3, 1),
(308, 'jeudi ', '15:00:00', '17:00:00', NULL, NULL, 'Cours simple', '2019-03-07', 3, 1),
(309, 'vendredi ', '13:00:00', '15:00:00', NULL, NULL, 'Cours simple', '2019-03-08', 3, 1),
(310, 'mardi ', '10:00:00', '12:00:00', NULL, NULL, 'Cours simple', '2019-03-05', 3, 1),
(311, 'mardi ', '15:00:00', '16:00:00', NULL, NULL, 'Cours vidéo', '2019-03-05', 3, 1),
(312, 'vendredi ', '15:00:00', '16:00:00', NULL, NULL, 'Cours vidéo', '2019-03-08', 3, 1),
(313, 'lundi ', '13:00:00', '15:00:00', NULL, NULL, 'Cours vidéo', '2019-03-04', 3, 1),
(314, 'mercredi ', '13:00:00', '15:00:00', NULL, NULL, 'Cours vidéo', '2019-03-06', 3, 1),
(315, 'lundi ', '10:00:00', '12:00:00', NULL, NULL, 'Cours simple', '2019-03-04', 3, 1),
(316, 'vendredi ', '08:00:00', '10:00:00', NULL, NULL, 'Cours simple', '2019-03-08', 3, 1),
(317, 'lundi ', '15:00:00', '17:00:00', NULL, NULL, 'Cours simple', '2019-03-04', 3, 1),
(318, 'mercredi ', '15:00:00', '17:00:00', NULL, NULL, 'Cours simple', '2019-03-06', 3, 1),
(319, 'mardi ', '08:00:00', '10:00:00', NULL, NULL, 'Cours vidéo', '2019-03-05', 3, 1),
(320, 'vendredi ', '10:00:00', '12:00:00', NULL, NULL, 'Cours vidéo', '2019-03-08', 3, 1),
(321, 'lundi ', '10:00:00', '12:00:00', NULL, NULL, 'Cours simple', '2019-03-11', 3, 1),
(322, 'vendredi ', '08:00:00', '10:00:00', NULL, NULL, 'Cours simple', '2019-03-15', 3, 1),
(323, 'lundi ', '15:00:00', '17:00:00', NULL, NULL, 'Cours simple', '2019-03-11', 3, 1),
(324, 'mercredi ', '15:00:00', '17:00:00', NULL, NULL, 'Cours simple', '2019-03-13', 3, 1),
(325, 'lundi ', '13:00:00', '15:00:00', NULL, NULL, 'Cours vidéo', '2019-03-11', 3, 1),
(326, 'mercredi ', '13:00:00', '15:00:00', NULL, NULL, 'Cours vidéo', '2019-03-13', 3, 1),
(327, 'mardi ', '10:00:00', '12:00:00', NULL, NULL, 'Cours vidéo', '2019-03-12', 3, 1),
(328, 'mardi ', '13:00:00', '15:00:00', NULL, NULL, 'Cours simple', '2019-03-12', 3, 1),
(329, 'jeudi ', '13:00:00', '15:00:00', NULL, NULL, 'Cours simple', '2019-03-14', 3, 1),
(330, 'mardi ', '16:00:00', '18:30:00', NULL, NULL, 'Cours simple', '2019-03-12', 3, 1),
(331, 'vendredi ', '16:00:00', '18:30:00', NULL, NULL, 'Cours simple', '2019-03-15', 3, 1),
(332, 'mercredi ', '08:00:00', '12:00:00', NULL, NULL, 'Cours simple', '2019-03-13', 3, 1),
(333, 'jeudi ', '08:00:00', '10:00:00', NULL, NULL, 'Cours simple', '2019-03-14', 3, 1),
(334, 'jeudi ', '15:00:00', '17:00:00', NULL, NULL, 'Cours simple', '2019-03-14', 3, 1),
(335, 'vendredi ', '13:00:00', '15:00:00', NULL, NULL, 'Cours simple', '2019-03-15', 3, 1),
(336, 'mardi ', '15:00:00', '16:00:00', NULL, NULL, 'Cours simple', '2019-03-12', 3, 0),
(337, 'vendredi ', '15:00:00', '16:00:00', NULL, NULL, 'Cours vidéo', '2019-03-15', 3, 1),
(338, 'jeudi ', '10:00:00', '12:00:00', NULL, NULL, 'Cours simple', '2019-03-14', 3, 1),
(339, 'mercredi ', '10:00:00', '12:00:00', NULL, NULL, 'Cours simple', '2019-08-14', 8, 0);

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

--
-- Structure de la table `tbl_semestre_es`
--

CREATE TABLE IF NOT EXISTS `tbl_semestre_es` (
  `id_sem_es` int(11) NOT NULL AUTO_INCREMENT,
  `id_an_acad_es` int(11) NOT NULL,
  `libelle_sem_es` varchar(10) NOT NULL,
  `DateD_sem_es` date NOT NULL,
  `DateF_sem_es` date NOT NULL,
  PRIMARY KEY (`id_sem_es`),
  KEY `id_an_acad_es` (`id_an_acad_es`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=latin1;

--
-- Déchargement des données de la table `tbl_semestre_es`
--

INSERT INTO `tbl_semestre_es` (`id_sem_es`, `id_an_acad_es`, `libelle_sem_es`, `DateD_sem_es`, `DateF_sem_es`) VALUES
(5, 8, 'semestre 1', '2018-11-06', '2019-03-31'),
(6, 8, 'semestre 2', '2019-04-01', '2019-07-31');

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

--
-- Structure de la table `tbl_serie_es`
--

CREATE TABLE IF NOT EXISTS `tbl_serie_es` (
  `id_serie_es` int(11) NOT NULL AUTO_INCREMENT,
  `libel_serie_es` varchar(10) NOT NULL,
  PRIMARY KEY (`id_serie_es`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8;

--
-- Déchargement des données de la table `tbl_serie_es`
--

INSERT INTO `tbl_serie_es` (`id_serie_es`, `libel_serie_es`) VALUES
(2, 'Aucune'),
(3, 'B'),
(4, 'C'),
(5, 'D'),
(6, 'A1'),
(7, 'A2'),
(8, 'ACA');

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

--
-- Structure de la table `tbl_support_seance_es`
--

CREATE TABLE IF NOT EXISTS `tbl_support_seance_es` (
  `id_sup_sce_es` int(11) NOT NULL AUTO_INCREMENT,
  `id_seance_es` int(11) NOT NULL,
  `support_cours_es` varchar(50) DEFAULT NULL,
  PRIMARY KEY (`id_sup_sce_es`),
  KEY `id_seance_es` (`id_seance_es`)
) ENGINE=InnoDB AUTO_INCREMENT=354 DEFAULT CHARSET=utf8;

--
-- Déchargement des données de la table `tbl_support_seance_es`
--

INSERT INTO `tbl_support_seance_es` (`id_sup_sce_es`, `id_seance_es`, `support_cours_es`) VALUES
(1, 1, NULL),
(2, 2, NULL),
(3, 3, NULL),
(4, 4, NULL),
(5, 5, NULL),
(6, 6, NULL),
(7, 7, NULL),
(8, 8, NULL),
(9, 9, NULL),
(10, 10, NULL),
(11, 11, NULL),
(12, 12, NULL),
(13, 13, NULL),
(14, 14, NULL),
(15, 15, NULL),
(17, 17, NULL),
(18, 18, NULL),
(19, 19, NULL),
(20, 20, NULL),
(21, 21, NULL),
(22, 22, NULL),
(23, 23, NULL),
(24, 24, NULL),
(25, 25, NULL),
(26, 26, NULL),
(27, 27, NULL),
(28, 12, 'Exercices1-Programmation-Web.docx'),
(32, 31, NULL),
(33, 32, NULL),
(34, 33, NULL),
(35, 34, NULL),
(36, 35, NULL),
(37, 36, NULL),
(38, 37, NULL),
(39, 38, NULL),
(40, 39, NULL),
(41, 40, NULL),
(42, 41, NULL),
(43, 42, NULL),
(44, 43, NULL),
(45, 44, NULL),
(46, 45, NULL),
(47, 11, 'Cours 1 - Introduction à la programmation web.pdf'),
(48, 46, NULL),
(53, 51, NULL),
(54, 52, NULL),
(55, 53, NULL),
(56, 54, NULL),
(57, 55, NULL),
(58, 56, NULL),
(59, 57, NULL),
(60, 58, NULL),
(61, 59, NULL),
(62, 60, NULL),
(63, 61, NULL),
(64, 62, NULL),
(65, 63, NULL),
(66, 64, NULL),
(67, 65, NULL),
(68, 66, NULL),
(70, 68, NULL),
(71, 69, NULL),
(72, 70, NULL),
(73, 71, NULL),
(74, 72, NULL),
(75, 40, 'Cours2-Programmation-Web.pdf'),
(76, 53, 'Exercices2-Programmation-Web.pdf'),
(78, 54, 'Cours3-Programmation-Web.pdf'),
(79, 73, NULL),
(80, 74, NULL),
(81, 75, NULL),
(82, 76, NULL),
(83, 77, NULL),
(84, 78, NULL),
(85, 79, NULL),
(86, 80, NULL),
(87, 81, NULL),
(88, 82, NULL),
(89, 83, NULL),
(90, 84, NULL),
(91, 85, NULL),
(92, 86, NULL),
(93, 87, NULL),
(94, 88, NULL),
(95, 89, NULL),
(96, 90, NULL),
(97, 91, NULL),
(98, 92, NULL),
(99, 93, NULL),
(100, 94, NULL),
(101, 95, NULL),
(102, 96, NULL),
(103, 97, NULL),
(104, 79, 'Cours2-Programmation-Web.pdf'),
(105, 81, 'Cours2-Marketing.pdf'),
(106, 98, NULL),
(107, 99, NULL),
(108, 100, NULL),
(109, 101, NULL),
(110, 102, NULL),
(111, 103, NULL),
(112, 104, NULL),
(113, 105, NULL),
(114, 106, NULL),
(115, 107, NULL),
(116, 108, NULL),
(117, 109, NULL),
(118, 110, NULL),
(119, 111, NULL),
(120, 112, NULL),
(121, 113, NULL),
(122, 114, NULL),
(123, 115, NULL),
(124, 116, NULL),
(125, 117, NULL),
(126, 118, NULL),
(127, 119, NULL),
(128, 120, NULL),
(129, 121, NULL),
(130, 122, NULL),
(131, 123, NULL),
(132, 124, NULL),
(133, 125, NULL),
(134, 126, NULL),
(135, 127, NULL),
(136, 128, NULL),
(137, 129, NULL),
(138, 130, NULL),
(139, 131, NULL),
(140, 132, NULL),
(141, 133, NULL),
(142, 134, NULL),
(143, 135, NULL),
(144, 136, NULL),
(145, 137, NULL),
(146, 138, NULL),
(147, 139, NULL),
(148, 135, 'Cours2-Programmation-Web.pdf'),
(149, 111, 'Exercices2-Programmation-Web.pdf'),
(151, 141, NULL),
(152, 142, NULL),
(153, 143, NULL),
(154, 144, NULL),
(155, 145, NULL),
(156, 146, NULL),
(157, 147, NULL),
(158, 148, NULL),
(159, 149, NULL),
(160, 150, NULL),
(161, 151, NULL),
(162, 152, NULL),
(163, 153, NULL),
(164, 154, NULL),
(165, 155, NULL),
(166, 156, NULL),
(167, 157, NULL),
(168, 158, NULL),
(169, 159, NULL),
(170, 160, NULL),
(171, 161, NULL),
(172, 162, NULL),
(173, 163, NULL),
(174, 158, 'Cours2-Programmation-Web.pdf'),
(179, 168, NULL),
(180, 169, NULL),
(181, 170, NULL),
(182, 171, NULL),
(183, 172, NULL),
(184, 173, NULL),
(185, 174, NULL),
(186, 175, NULL),
(187, 176, NULL),
(188, 177, NULL),
(189, 178, NULL),
(190, 179, NULL),
(191, 180, NULL),
(192, 181, NULL),
(193, 182, NULL),
(194, 183, NULL),
(195, 184, NULL),
(196, 185, NULL),
(197, 186, NULL),
(198, 187, NULL),
(199, 188, NULL),
(200, 189, NULL),
(203, 192, NULL),
(204, 193, NULL),
(205, 194, NULL),
(206, 195, NULL),
(207, 196, NULL),
(209, 198, NULL),
(210, 199, NULL),
(211, 200, NULL),
(212, 201, NULL),
(213, 202, NULL),
(214, 203, NULL),
(215, 204, NULL),
(216, 205, NULL),
(217, 206, NULL),
(218, 207, NULL),
(219, 208, NULL),
(220, 209, NULL),
(221, 210, NULL),
(222, 211, NULL),
(223, 212, NULL),
(224, 193, 'Cours2-Programmation-Web.pdf'),
(225, 213, NULL),
(226, 214, NULL),
(228, 216, NULL),
(229, 217, NULL),
(230, 218, NULL),
(231, 219, NULL),
(232, 220, NULL),
(233, 221, NULL),
(234, 222, NULL),
(235, 223, NULL),
(236, 224, NULL),
(237, 225, NULL),
(238, 226, NULL),
(239, 227, NULL),
(240, 228, NULL),
(241, 229, NULL),
(242, 230, NULL),
(243, 231, NULL),
(245, 198, 'Choisir-...2-Informatique.pdf'),
(246, 233, NULL),
(247, 234, NULL),
(248, 235, NULL),
(249, 236, NULL),
(252, 239, NULL),
(253, 240, NULL),
(254, 241, NULL),
(255, 242, NULL),
(256, 243, NULL),
(257, 244, NULL),
(258, 245, NULL),
(259, 246, NULL),
(260, 247, NULL),
(261, 248, NULL),
(262, 249, NULL),
(263, 250, NULL),
(264, 251, NULL),
(265, 252, NULL),
(266, 253, NULL),
(267, 254, NULL),
(268, 255, NULL),
(269, 256, NULL),
(270, 257, NULL),
(271, 258, NULL),
(272, 259, NULL),
(273, 260, NULL),
(274, 261, NULL),
(275, 262, NULL),
(276, 263, NULL),
(277, 264, NULL),
(278, 265, NULL),
(279, 266, NULL),
(280, 267, NULL),
(281, 268, NULL),
(282, 269, NULL),
(283, 270, NULL),
(284, 271, NULL),
(285, 272, NULL),
(286, 273, NULL),
(287, 274, NULL),
(288, 275, NULL),
(289, 276, NULL),
(290, 277, NULL),
(291, 278, NULL),
(292, 279, NULL),
(293, 280, NULL),
(294, 281, NULL),
(295, 282, NULL),
(296, 283, NULL),
(297, 284, NULL),
(298, 285, NULL),
(299, 286, NULL),
(300, 287, NULL),
(301, 288, NULL),
(302, 289, NULL),
(303, 276, 'Cours2-Communication-my-dias.docx'),
(304, 290, NULL),
(305, 291, NULL),
(306, 292, NULL),
(307, 293, NULL),
(308, 294, NULL),
(309, 295, NULL),
(310, 296, NULL),
(311, 297, NULL),
(312, 298, NULL),
(313, 299, NULL),
(314, 300, NULL),
(315, 301, NULL),
(316, 302, NULL),
(317, 303, NULL),
(318, 304, NULL),
(319, 305, NULL),
(320, 306, NULL),
(321, 307, NULL),
(322, 308, NULL),
(323, 309, NULL),
(324, 310, NULL),
(325, 311, NULL),
(326, 312, NULL),
(327, 313, NULL),
(328, 314, NULL),
(329, 315, NULL),
(330, 316, NULL),
(331, 317, NULL),
(332, 318, NULL),
(333, 319, NULL),
(334, 320, NULL),
(335, 321, NULL),
(336, 322, NULL),
(337, 323, NULL),
(338, 324, NULL),
(339, 325, NULL),
(340, 326, NULL),
(341, 327, NULL),
(342, 328, NULL),
(343, 329, NULL),
(344, 330, NULL),
(345, 331, NULL),
(346, 332, NULL),
(347, 333, NULL),
(348, 334, NULL),
(349, 335, NULL),
(350, 336, NULL),
(351, 337, NULL),
(352, 338, NULL),
(353, 339, '');

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

--
-- Structure de la table `userrole`
--

CREATE TABLE IF NOT EXISTS `userrole` (
  `id_profil_es` int(11) NOT NULL,
  `id_role_es` int(11) NOT NULL,
  `dateAffectDroit` date NOT NULL,
  `dateRetraitDroit` date NOT NULL,
  KEY `id_profil_es` (`id_profil_es`),
  KEY `id_role_es` (`id_role_es`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Contraintes pour les tables déchargées
--

--
-- Contraintes pour la table `tbl_affect_class_es`
--
ALTER TABLE `tbl_affect_class_es`
  ADD CONSTRAINT `tbl_affect_class_es_ibfk_1` FOREIGN KEY (`id_an_acad_es`) REFERENCES `tbl_annee_acad_es` (`id_an_acad_es`) ON UPDATE CASCADE,
  ADD CONSTRAINT `tbl_affect_class_es_ibfk_2` FOREIGN KEY (`id_emp_es`) REFERENCES `tbl_employe_es` (`id_emp_es`) ON UPDATE CASCADE,
  ADD CONSTRAINT `tbl_affect_class_es_ibfk_3` FOREIGN KEY (`id_classe_es`) REFERENCES `tbl_classe_es` (`id_classe_es`) ON UPDATE CASCADE,
  ADD CONSTRAINT `tbl_affect_class_es_ibfk_4` FOREIGN KEY (`id_mat_es`) REFERENCES `tbl_matiere_es` (`id_mat_es`) ON UPDATE CASCADE;

--
-- Contraintes pour la table `tbl_annee_acad_es`
--
ALTER TABLE `tbl_annee_acad_es`
  ADD CONSTRAINT `tbl_annee_acad_es_ibfk_1` FOREIGN KEY (`id_etbl_es`) REFERENCES `tbl_etablissement_es` (`id_etbl_es`) ON UPDATE CASCADE;

--
-- Contraintes pour la table `tbl_chefclasse_es`
--
ALTER TABLE `tbl_chefclasse_es`
  ADD CONSTRAINT `tbl_chefclasse_es_ibfk_1` FOREIGN KEY (`id_classe_es`) REFERENCES `tbl_classe_es` (`id_classe_es`) ON UPDATE CASCADE,
  ADD CONSTRAINT `tbl_chefclasse_es_ibfk_2` FOREIGN KEY (`id_etudiant_es`) REFERENCES `tbl_etudiant_es` (`id_etudiant_es`) ON UPDATE CASCADE;

--
-- Contraintes pour la table `tbl_contrat_es`
--
ALTER TABLE `tbl_contrat_es`
  ADD CONSTRAINT `tbl_contrat_es_ibfk_1` FOREIGN KEY (`id_emp_es`) REFERENCES `tbl_employe_es` (`id_emp_es`) ON UPDATE CASCADE;

--
-- Contraintes pour la table `tbl_corriger_evaluation_es`
--
ALTER TABLE `tbl_corriger_evaluation_es`
  ADD CONSTRAINT `tbl_corriger_evaluation_es_ibfk_1` FOREIGN KEY (`id_etudiant_es`) REFERENCES `tbl_etudiant_es` (`id_etudiant_es`) ON UPDATE CASCADE,
  ADD CONSTRAINT `tbl_corriger_evaluation_es_ibfk_2` FOREIGN KEY (`id_emp_es`) REFERENCES `tbl_employe_es` (`id_emp_es`) ON UPDATE CASCADE,
  ADD CONSTRAINT `tbl_corriger_evaluation_es_ibfk_3` FOREIGN KEY (`id_eval_es`) REFERENCES `tbl_evaluation_es` (`id_eval_es`) ON UPDATE CASCADE;

--
-- Contraintes pour la table `tbl_corriger_examen_es`
--
ALTER TABLE `tbl_corriger_examen_es`
  ADD CONSTRAINT `tbl_corriger_examen_es_ibfk_1` FOREIGN KEY (`id_etudiant_es`) REFERENCES `tbl_etudiant_es` (`id_etudiant_es`) ON UPDATE CASCADE,
  ADD CONSTRAINT `tbl_corriger_examen_es_ibfk_2` FOREIGN KEY (`id_emp_es`) REFERENCES `tbl_employe_es` (`id_emp_es`) ON UPDATE CASCADE,
  ADD CONSTRAINT `tbl_corriger_examen_es_ibfk_3` FOREIGN KEY (`id_prog_examen`) REFERENCES `tbl_programme_examen_es` (`id_prog_examen`) ON UPDATE CASCADE;

--
-- Contraintes pour la table `tbl_creeretabl_es`
--
ALTER TABLE `tbl_creeretabl_es`
  ADD CONSTRAINT `tbl_creeretabl_es_ibfk_1` FOREIGN KEY (`id_etbl_es`) REFERENCES `tbl_etablissement_es` (`id_etbl_es`) ON UPDATE CASCADE,
  ADD CONSTRAINT `tbl_creeretabl_es_ibfk_2` FOREIGN KEY (`id_fondt_es`) REFERENCES `tbl_fondateur_es` (`id_fondt_es`) ON UPDATE CASCADE;

--
-- Contraintes pour la table `tbl_employe_es`
--
ALTER TABLE `tbl_employe_es`
  ADD CONSTRAINT `tbl_employe_es_ibfk_1` FOREIGN KEY (`id_etbl_es`) REFERENCES `tbl_etablissement_es` (`id_etbl_es`) ON UPDATE CASCADE,
  ADD CONSTRAINT `tbl_employe_es_ibfk_2` FOREIGN KEY (`id_user_es`) REFERENCES `tbl_user_es` (`id_user_es`) ON UPDATE CASCADE,
  ADD CONSTRAINT `tbl_employe_es_ibfk_3` FOREIGN KEY (`id_fonct_es`) REFERENCES `tbl_fonction_es` (`id_fonct_es`) ON UPDATE CASCADE;

--
-- Contraintes pour la table `tbl_etudiant_cours_es`
--
ALTER TABLE `tbl_etudiant_cours_es`
  ADD CONSTRAINT `tbl_etudiant_cours_es_ibfk_1` FOREIGN KEY (`id_etudiant_es`) REFERENCES `tbl_etudiant_es` (`id_etudiant_es`) ON DELETE CASCADE,
  ADD CONSTRAINT `tbl_etudiant_cours_es_ibfk_2` FOREIGN KEY (`id_seance_es`) REFERENCES `tbl_seance_cours_es` (`id_seance_es`) ON UPDATE CASCADE;

--
-- Contraintes pour la table `tbl_etudiant_es`
--
ALTER TABLE `tbl_etudiant_es`
  ADD CONSTRAINT `tbl_etudiant_es_ibfk_1` FOREIGN KEY (`id_user_es`) REFERENCES `tbl_user_es` (`id_user_es`) ON UPDATE CASCADE;

--
-- Contraintes pour la table `tbl_evaluation_es`
--
ALTER TABLE `tbl_evaluation_es`
  ADD CONSTRAINT `tbl_evaluation_es_ibfk_1` FOREIGN KEY (`id_aff_class_es`) REFERENCES `tbl_affect_class_es` (`id_aff_class_es`) ON UPDATE CASCADE;

--
-- Contraintes pour la table `tbl_events_cours_es`
--
ALTER TABLE `tbl_events_cours_es`
  ADD CONSTRAINT `tbl_events_cours_es_ibfk_1` FOREIGN KEY (`id_cours_ens_es`) REFERENCES `tbl_cours_enseigner_es` (`id_cours_ens_es`) ON UPDATE CASCADE;

--
-- Contraintes pour la table `tbl_examen_es`
--
ALTER TABLE `tbl_examen_es`
  ADD CONSTRAINT `tbl_examen_es_ibfk_1` FOREIGN KEY (`id_an_acad_es`) REFERENCES `tbl_annee_acad_es` (`id_an_acad_es`) ON UPDATE CASCADE;

--
-- Contraintes pour la table `tbl_fonction_es`
--
ALTER TABLE `tbl_fonction_es`
  ADD CONSTRAINT `tbl_fonction_es_ibfk_1` FOREIGN KEY (`id_etbl_es`) REFERENCES `tbl_etablissement_es` (`id_etbl_es`);

--
-- Contraintes pour la table `tbl_fraie_scola_es`
--
ALTER TABLE `tbl_fraie_scola_es`
  ADD CONSTRAINT `tbl_fraie_scola_es_ibfk_1` FOREIGN KEY (`id_etudiant_es`) REFERENCES `tbl_etudiant_es` (`id_etudiant_es`) ON UPDATE CASCADE,
  ADD CONSTRAINT `tbl_fraie_scola_es_ibfk_2` FOREIGN KEY (`id_an_acad_es`) REFERENCES `tbl_annee_acad_es` (`id_an_acad_es`) ON UPDATE CASCADE;

--
-- Contraintes pour la table `tbl_horplanning_es`
--
ALTER TABLE `tbl_horplanning_es`
  ADD CONSTRAINT `tbl_horplanning_es_ibfk_1` FOREIGN KEY (`id_etbl_es`) REFERENCES `tbl_etablissement_es` (`id_etbl_es`) ON UPDATE CASCADE;

--
-- Contraintes pour la table `tbl_horplan_exam_es`
--
ALTER TABLE `tbl_horplan_exam_es`
  ADD CONSTRAINT `tbl_horplan_exam_es_ibfk_1` FOREIGN KEY (`id_prog_examen`) REFERENCES `tbl_programme_examen_es` (`id_prog_examen`) ON UPDATE CASCADE,
  ADD CONSTRAINT `tbl_horplan_exam_es_ibfk_2` FOREIGN KEY (`id_horplan_es`) REFERENCES `tbl_horplanning_es` (`id_horplan_es`) ON UPDATE CASCADE;

--
-- Contraintes pour la table `tbl_inscription_es`
--
ALTER TABLE `tbl_inscription_es`
  ADD CONSTRAINT `tbl_inscription_es_ibfk_1` FOREIGN KEY (`serie_etd_es`) REFERENCES `tbl_serie_es` (`id_serie_es`) ON UPDATE CASCADE;

--
-- Contraintes pour la table `tbl_mention_veille_es`
--
ALTER TABLE `tbl_mention_veille_es`
  ADD CONSTRAINT `tbl_mention_veille_es_ibfk_1` FOREIGN KEY (`id_sem_es`) REFERENCES `tbl_semestre_es` (`id_sem_es`) ON UPDATE CASCADE,
  ADD CONSTRAINT `tbl_mention_veille_es_ibfk_2` FOREIGN KEY (`id_etudiant_es`) REFERENCES `tbl_etudiant_es` (`id_etudiant_es`) ON UPDATE CASCADE;

--
-- Contraintes pour la table `tbl_note_semestre_es`
--
ALTER TABLE `tbl_note_semestre_es`
  ADD CONSTRAINT `tbl_note_semestre_es_ibfk_1` FOREIGN KEY (`id_etudiant_es`) REFERENCES `tbl_etudiant_es` (`id_etudiant_es`) ON UPDATE CASCADE;

--
-- Contraintes pour la table `tbl_notification_es`
--
ALTER TABLE `tbl_notification_es`
  ADD CONSTRAINT `tbl_notification_es_ibfk_1` FOREIGN KEY (`id_hist_es`) REFERENCES `tbl_histuser_es` (`id_hist_es`) ON UPDATE CASCADE,
  ADD CONSTRAINT `tbl_notification_es_ibfk_2` FOREIGN KEY (`id_user_es`) REFERENCES `tbl_user_es` (`id_user_es`) ON UPDATE CASCADE;

--
-- Contraintes pour la table `tbl_outil_es`
--
ALTER TABLE `tbl_outil_es`
  ADD CONSTRAINT `tbl_outil_es_ibfk_1` FOREIGN KEY (`id_etbl_es`) REFERENCES `tbl_etablissement_es` (`id_etbl_es`) ON UPDATE CASCADE;

--
-- Contraintes pour la table `tbl_outil_seance_es`
--
ALTER TABLE `tbl_outil_seance_es`
  ADD CONSTRAINT `tbl_outil_seance_es_ibfk_1` FOREIGN KEY (`id_seance_es`) REFERENCES `tbl_seance_cours_es` (`id_seance_es`) ON UPDATE CASCADE,
  ADD CONSTRAINT `tbl_outil_seance_es_ibfk_2` FOREIGN KEY (`id_outil_es`) REFERENCES `tbl_outil_es` (`id_outil_es`) ON UPDATE CASCADE;

--
-- Contraintes pour la table `tbl_programme_examen_es`
--
ALTER TABLE `tbl_programme_examen_es`
  ADD CONSTRAINT `tbl_programme_examen_es_ibfk_1` FOREIGN KEY (`id_exam_es`) REFERENCES `tbl_examen_es` (`id_exam_es`) ON UPDATE CASCADE,
  ADD CONSTRAINT `tbl_programme_examen_es_ibfk_2` FOREIGN KEY (`id_mat_es`) REFERENCES `tbl_matiere_es` (`id_mat_es`) ON UPDATE CASCADE,
  ADD CONSTRAINT `tbl_programme_examen_es_ibfk_3` FOREIGN KEY (`id_classe_es`) REFERENCES `tbl_classe_es` (`id_classe_es`) ON UPDATE CASCADE;

--
-- Contraintes pour la table `tbl_semestre_es`
--
ALTER TABLE `tbl_semestre_es`
  ADD CONSTRAINT `tbl_semestre_es_ibfk_1` FOREIGN KEY (`id_an_acad_es`) REFERENCES `tbl_annee_acad_es` (`id_an_acad_es`) ON UPDATE CASCADE;
COMMIT;

