-- phpMyAdmin SQL Dump
-- version 5.0.2
-- https://www.phpmyadmin.net/
--
-- Host: 127.0.0.1:3306
-- Generation Time: Jun 13, 2022 at 04:12 PM
-- Server version: 5.7.31
-- PHP Version: 7.1.33

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
START TRANSACTION;
SET time_zone = "+00:00";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;

--
-- Database: `supmti_db_reinscription`
--

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

--
-- Table structure for table `admin`
--

DROP TABLE IF EXISTS `admin`;
CREATE TABLE IF NOT EXISTS `admin` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `nom` varchar(40) NOT NULL,
  `prenom` varchar(40) NOT NULL,
  `tel` varchar(30) NOT NULL,
  `principale` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `admin`
--

INSERT INTO `admin` (`id`, `nom`, `prenom`, `tel`, `principale`) VALUES
(1, 'elaoula', 'hicham', '0643637158', 1);

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

--
-- Table structure for table `anneescolaire`
--

DROP TABLE IF EXISTS `anneescolaire`;
CREATE TABLE IF NOT EXISTS `anneescolaire` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `nom` varchar(15) NOT NULL,
  `actuel` tinyint(1) DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

--
-- Table structure for table `bac`
--

DROP TABLE IF EXISTS `bac`;
CREATE TABLE IF NOT EXISTS `bac` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `nom` varchar(40) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `bac`
--

INSERT INTO `bac` (`id`, `nom`) VALUES
(1, 'Baccalauréat Scientifique'),
(2, 'Baccalauréat Économique'),
(3, 'Baccalauréat Littéraire'),
(4, 'Autre Baccalauréat');

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

--
-- Table structure for table `branche`
--

DROP TABLE IF EXISTS `branche`;
CREATE TABLE IF NOT EXISTS `branche` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `nom` varchar(40) NOT NULL,
  `ordre` tinyint(4) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `branche`
--

INSERT INTO `branche` (`id`, `nom`, `ordre`) VALUES
(1, 'Licence', 1),
(2, 'Master', 2),
(3, 'Classes Préparatoires', 3),
(4, 'Cycle d\'Ingénieur', 4);

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

--
-- Table structure for table `centre`
--

DROP TABLE IF EXISTS `centre`;
CREATE TABLE IF NOT EXISTS `centre` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `nom` varchar(80) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `centre`
--

INSERT INTO `centre` (`id`, `nom`) VALUES
(1, 'SupMTI Rabat'),
(2, 'SupMTI Beni Mellal'),
(3, 'SupMTI Meknes'),
(4, 'SupMTI Oujda');

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

--
-- Table structure for table `classe`
--

DROP TABLE IF EXISTS `classe`;
CREATE TABLE IF NOT EXISTS `classe` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `nom` varchar(100) NOT NULL,
  `branche_id` int(11) DEFAULT NULL,
  `filiere_id` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=43 DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `classe`
--

INSERT INTO `classe` (`id`, `nom`, `branche_id`, `filiere_id`) VALUES
(1, '1ère Année Ingénierie des Systèmes Informatiques', 1, 1),
(2, '2ème Année Ingénierie des Systèmes Informatiques', 1, 1),
(3, '3ème Année Ingénierie des Systèmes Informatiques', 1, 1),
(4, '4ème Année Ingénierie des Systèmes d\'Information', 2, 1),
(5, '5ème Année Ingénierie des Systèmes d\'Information', 2, 1),
(6, '4ème Année Ingénierie des Systèmes Réseaux et Télécoms', 2, 1),
(7, '5ème Année Ingénierie des Systèmes Réseaux et Télécoms', 2, 1),
(8, '1ère Année Management des Entreprises', 1, 2),
(9, '2ème Année Management des Entreprises', 1, 2),
(10, '3ème Année Management des Entreprises', 1, 2),
(11, '4ème Année Management des Systèmes et Technologies de l\'Information et de Communication', 2, 2),
(12, '5ème Année Management des Systèmes et Technologies de l\'Information et de Communication', 2, 2),
(13, '4ème Année Ingénierie en Finance Internationale', 2, 2),
(14, '5ème Année Ingénierie en Finance Internationale', 2, 2),
(15, '4ème Année Audit et Contrôle de Gestion', 2, 2),
(16, '5ème Année Audit et Contrôle de Gestion', 2, 2),
(17, '4ème Année Marketing Stratégique et Opérationnel', 2, 2),
(18, '5ème Année Marketing Stratégique et Opérationnel', 2, 2),
(19, '1ère Année Management Industriel et Logistique', 1, 3),
(20, '2ème Année Management Industriel et Logistique', 1, 3),
(21, '3ème Année Management Industriel et Logistique', 2, 3),
(22, '4ème Année Ingénierie Industrielle et Logistique', 2, 3),
(23, '5ème Année Ingénierie Industrielle et Logistique', 2, 3),
(24, '4ème Année Ingénierie des Systèmes Embarqués Mobiles', 2, 1),
(25, '5ème Année Ingénierie des Systèmes Embarqués Mobiles', 2, 1),
(26, '1ère Année Classes Préparatoires des Technologies de l\'Information', 3, 1),
(27, '2ème Année Classes Préparatoires des Technologies de l\'Information', 3, 1),
(28, '1ère Année Classes Préparatoires en Transformation Digitale de l\'Industrie', 3, 3),
(29, '2ème Année Classes Préparatoires en Transformation Digitale de l\'Industrie', 3, 3),
(30, '1ère Année Cycle d\'Ingénieur Génie Informatique', 4, 1),
(31, '2ème Année Cycle d\'Ingénieur Génie Informatique', 4, 1),
(32, '3ème Année Cycle d\'Ingénieur - Ingénierie des Systèmes d\'Information', 4, 1),
(33, '3ème Année Cycle d\'Ingénieur - Ingénierie de la Data Science', 4, 1),
(34, '3ème Année Cycle d\'Ingénieur - Cloud, IoT et Mobile', 4, 1),
(35, '3ème Année Cycle d\'Ingénieur - Ingénierie des Réseaux et Télécom', 4, 1),
(36, '3ème Année Cycle d\'Ingénieur - Ingénierie des Systèmes d\'Information Géographique', 4, 1),
(37, '1ère Année Cycle d\'Ingénieur - Transformation Digitale de l\'Industrie', 4, 3),
(38, '2ème Année Cycle d\'Ingénieur - Transformation Digitale de l\'Industrie', 4, 3),
(39, '3ème Année Cycle d\'Ingénieur - Transformation Digitale Energétique et Renouvelable', 4, 3),
(40, '3ème Année Cycle d\'Ingénieur - Transformation Digitale Industrielle et Logistique', 4, 3),
(41, '1st Year Computer Science', 1, 1),
(42, '2nd Year Computer Science', 1, 1);

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

--
-- Table structure for table `classe_groupe`
--

DROP TABLE IF EXISTS `classe_groupe`;
CREATE TABLE IF NOT EXISTS `classe_groupe` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `classe_id` int(11) NOT NULL,
  `groupe_id` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=43 DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `classe_groupe`
--

INSERT INTO `classe_groupe` (`id`, `classe_id`, `groupe_id`) VALUES
(1, 1, 1),
(2, 2, 2),
(3, 3, 3),
(4, 4, 4),
(5, 5, 5),
(6, 6, 4),
(7, 7, 5),
(8, 8, 1),
(9, 9, 2),
(10, 10, 3),
(11, 11, 4),
(12, 12, 5),
(13, 13, 4),
(14, 14, 5),
(15, 15, 4),
(16, 16, 5),
(17, 17, 4),
(18, 18, 5),
(19, 19, 1),
(20, 20, 2),
(21, 21, 3),
(22, 22, 4),
(23, 23, 5),
(24, 24, 4),
(25, 25, 5),
(26, 26, 6),
(27, 27, 7),
(28, 28, 6),
(29, 29, 7),
(30, 30, 8),
(31, 31, 9),
(32, 32, 10),
(33, 33, 10),
(34, 34, 10),
(35, 35, 10),
(36, 36, 10),
(37, 37, 8),
(38, 38, 9),
(39, 39, 10),
(40, 40, 10),
(41, 41, 1),
(42, 42, 2);

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

--
-- Table structure for table `classe_nationalite_document`
--

DROP TABLE IF EXISTS `classe_nationalite_document`;
CREATE TABLE IF NOT EXISTS `classe_nationalite_document` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `groupe_classe_id` int(11) NOT NULL,
  `nat_id` varchar(50) DEFAULT '',
  `doc_id` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=110 DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `classe_nationalite_document`
--

INSERT INTO `classe_nationalite_document` (`id`, `groupe_classe_id`, `nat_id`, `doc_id`) VALUES
(1, 1, '110', 1),
(2, 1, '110', 2),
(3, 2, '110', 1),
(4, 2, '110', 2),
(5, 2, '110', 5),
(6, 2, '110', 6),
(7, 2, '110', 20),
(8, 3, '110', 1),
(9, 3, '110', 2),
(10, 3, '110', 10),
(11, 4, '110', 1),
(12, 4, '110', 2),
(13, 4, '110', 11),
(14, 6, '110', 1),
(15, 6, '110', 2),
(16, 6, '110', 21),
(17, 6, '110', 22),
(18, 7, '110', 1),
(19, 7, '110', 2),
(20, 7, '110', 5),
(21, 7, '110', 6),
(22, 7, '110', 20),
(23, 8, '110', 1),
(24, 8, '110', 2),
(25, 8, '110', 10),
(26, 9, '110', 1),
(27, 9, '110', 2),
(28, 9, '110', 5),
(29, 9, '110', 6),
(30, 9, '110', 20),
(31, 10, '110', 1),
(32, 10, '110', 2),
(33, 10, '110', 7),
(34, 10, '110', 8),
(35, 10, '110', 20),
(36, 1, '*', 1),
(37, 1, '*', 4),
(38, 1, '*', 14),
(39, 1, '*', 17),
(40, 2, '*', 1),
(41, 2, '*', 4),
(42, 2, '*', 5),
(43, 2, '*', 6),
(44, 2, '*', 14),
(45, 2, '*', 17),
(46, 2, '*', 20),
(47, 3, '*', 1),
(48, 3, '*', 4),
(49, 3, '*', 10),
(50, 3, '*', 14),
(51, 3, '*', 15),
(52, 3, '*', 17),
(53, 3, '*', 18),
(54, 4, '*', 1),
(55, 4, '*', 4),
(56, 4, '*', 11),
(57, 4, '*', 14),
(58, 4, '*', 16),
(59, 4, '*', 17),
(60, 4, '*', 19),
(61, 5, '*', 1),
(62, 5, '*', 4),
(63, 5, '*', 11),
(64, 5, '*', 12),
(65, 5, '*', 13),
(66, 5, '*', 14),
(67, 5, '*', 16),
(68, 5, '*', 17),
(69, 5, '*', 19),
(70, 5, '*', 20),
(71, 6, '*', 1),
(72, 6, '*', 4),
(73, 6, '*', 14),
(74, 6, '*', 17),
(75, 6, '*', 21),
(76, 6, '*', 22),
(77, 7, '*', 1),
(78, 7, '*', 4),
(79, 7, '*', 5),
(80, 7, '*', 6),
(81, 7, '*', 14),
(82, 7, '*', 17),
(83, 8, '*', 1),
(84, 8, '*', 4),
(85, 8, '*', 10),
(86, 8, '*', 14),
(87, 8, '*', 15),
(88, 8, '*', 17),
(89, 8, '*', 18),
(90, 9, '*', 1),
(91, 9, '*', 4),
(92, 9, '*', 5),
(93, 9, '*', 6),
(94, 9, '*', 10),
(95, 9, '*', 14),
(96, 9, '*', 15),
(97, 9, '*', 17),
(98, 9, '*', 18),
(99, 9, '*', 20),
(100, 10, '*', 1),
(101, 10, '*', 4),
(102, 10, '*', 7),
(103, 10, '*', 8),
(104, 10, '*', 10),
(105, 10, '*', 14),
(106, 10, '*', 15),
(107, 10, '*', 17),
(108, 10, '*', 18),
(109, 10, '*', 20);

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

--
-- Table structure for table `collaborateur`
--

DROP TABLE IF EXISTS `collaborateur`;
CREATE TABLE IF NOT EXISTS `collaborateur` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `nom` varchar(40) NOT NULL,
  `prenom` varchar(40) NOT NULL,
  `tel` varchar(30) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

--
-- Table structure for table `condition`
--

DROP TABLE IF EXISTS `condition`;
CREATE TABLE IF NOT EXISTS `condition` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `nom` varchar(100) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

--
-- Table structure for table `diplome`
--

DROP TABLE IF EXISTS `diplome`;
CREATE TABLE IF NOT EXISTS `diplome` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `nom` varchar(10) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `diplome`
--

INSERT INTO `diplome` (`id`, `nom`) VALUES
(1, 'Bac'),
(2, 'Bac+1'),
(3, 'Bac+2'),
(4, 'DTS'),
(5, 'DUT'),
(6, 'DUEG'),
(7, 'Licence'),
(8, 'Master');

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

--
-- Table structure for table `diplome_acces`
--

DROP TABLE IF EXISTS `diplome_acces`;
CREATE TABLE IF NOT EXISTS `diplome_acces` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `ins_id` int(11) NOT NULL,
  `diplome_id` int(11) NOT NULL,
  `specialite` mediumtext,
  `mention` varchar(20) DEFAULT NULL,
  `ville` varchar(50) DEFAULT NULL,
  `type_etablissement` varchar(15) DEFAULT NULL,
  `annee` varchar(15) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `diplome_acces`
--

INSERT INTO `diplome_acces` (`id`, `ins_id`, `diplome_id`, `specialite`, `mention`, `ville`, `type_etablissement`, `annee`) VALUES
(1, 1, 7, 'developement informatique', 'Passable', 'kenitra', 'Etatique', '2021 - 2022');

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

--
-- Table structure for table `document`
--

DROP TABLE IF EXISTS `document`;
CREATE TABLE IF NOT EXISTS `document` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `nom` varchar(100) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=23 DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `document`
--

INSERT INTO `document` (`id`, `nom`) VALUES
(1, 'Copie légalisée du baccalauréat'),
(2, 'Copie légalisée du CIN'),
(3, 'Copier légalisée du Carte de séjour'),
(4, 'Copier légalisée du Passport'),
(5, 'Copier légalisée de Relevé de Notes de la 1ère Année - Semestre 1'),
(6, 'Copier légalisée de Relevé de Notes de la 1ère Année - Semestre 2'),
(7, 'Copier légalisée de Relevé de Notes de la 2ème Année - Semestre 3'),
(8, 'Copier légalisée de Relevé de Notes de la 2ème Année - Semestre 4'),
(9, 'Copier légalisée de Relevé de Notes global (1ère Annéé + 2ème Année)'),
(10, 'Copier légalisée de Diplôme Bac+2'),
(11, 'Copier légalisée de Diplome Bac+3'),
(12, 'Copier légalisée de Relevé de Notes de la 4ème Année - Semestre 7'),
(13, 'Copier légalisée de Relevé de Notes de la 4ème Année - Semestre 8'),
(14, 'Attestation d\'authentification du BAC avec le Bac Marocain'),
(15, 'Attestation d\'authentification du BAC+2'),
(16, 'Attestation d\'authentification du BAC+3'),
(17, 'Equivalence du BAC'),
(18, 'Equivalence du BAC+2'),
(19, 'Equivalence du BAC+3'),
(20, 'Copier légalisée de l\'Attestation de Réuissit'),
(21, 'Copier légalisée de Rélevé de Notes de la 2ème Année du baccalauréat - Semestre 1'),
(22, 'Copier légalisée de Rélevé de Notes de la 2ème Année du baccalauréat - Semestre 2');

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

--
-- Table structure for table `filiere`
--

DROP TABLE IF EXISTS `filiere`;
CREATE TABLE IF NOT EXISTS `filiere` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `nom` varchar(100) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `filiere`
--

INSERT INTO `filiere` (`id`, `nom`) VALUES
(1, 'Informatique et Réseau'),
(2, 'Management des entreprises'),
(3, 'Management Industriel');

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

--
-- Table structure for table `filiere_bac`
--

DROP TABLE IF EXISTS `filiere_bac`;
CREATE TABLE IF NOT EXISTS `filiere_bac` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `bac_id` int(11) DEFAULT NULL,
  `filiere_id` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `filiere_bac`
--

INSERT INTO `filiere_bac` (`id`, `bac_id`, `filiere_id`) VALUES
(1, 1, 1),
(2, 1, 2),
(3, 1, 3),
(4, 2, 2),
(5, 2, 3),
(6, 3, 2),
(7, 3, 3),
(8, 4, 1),
(9, 4, 2),
(10, 4, 3);

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

--
-- Table structure for table `garant_financiere`
--

DROP TABLE IF EXISTS `garant_financiere`;
CREATE TABLE IF NOT EXISTS `garant_financiere` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `nom` varchar(60) DEFAULT NULL,
  `tel` varchar(30) DEFAULT NULL,
  `visiteur_id` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `garant_financiere`
--

INSERT INTO `garant_financiere` (`id`, `nom`, `tel`, `visiteur_id`) VALUES
(1, 'hicham elaoula', '0643637158', 1);

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

--
-- Table structure for table `groupe`
--

DROP TABLE IF EXISTS `groupe`;
CREATE TABLE IF NOT EXISTS `groupe` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `nom` varchar(20) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=11 DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `groupe`
--

INSERT INTO `groupe` (`id`, `nom`) VALUES
(1, 'Licence - 1ère Année'),
(2, 'Licence - 2ème Année'),
(3, 'Licence - 3ème Année'),
(4, 'Licence - 4ème Année'),
(5, 'Licence - 5ème Année'),
(6, 'CP - 1ère Année'),
(7, 'CP - 2ème Année'),
(8, 'CI - 1ère Année'),
(9, 'CI - 2ème Année'),
(10, 'CI - 3ème Année');

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

--
-- Table structure for table `inscription`
--

DROP TABLE IF EXISTS `inscription`;
CREATE TABLE IF NOT EXISTS `inscription` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `date_ins` bigint(10) NOT NULL,
  `attest_fourni` tinyint(1) DEFAULT '0',
  `visiteur_id` int(11) NOT NULL,
  `nat_id` int(11) DEFAULT NULL,
  `classe_id` int(11) NOT NULL,
  `centre_id` int(11) NOT NULL,
  `mode` varchar(20) DEFAULT NULL,
  `phase_id` int(11) DEFAULT NULL,
  `date_derniere_changement` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=202 DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `inscription`
--

INSERT INTO `inscription` (`id`, `date_ins`, `attest_fourni`, `visiteur_id`, `nat_id`, `classe_id`, `centre_id`, `mode`, `phase_id`, `date_derniere_changement`) VALUES
(1, 1654613429, 1, 1, 110, 2, 1, 'Présentiel', 2, 1654706640),
(2, 1654791600, 0, 2, 37, 26, 1, NULL, 5, NULL),
(3, 1654791601, 0, 3, 144, 24, 1, NULL, 3, NULL),
(4, 1654791601, 0, 4, 153, 12, 1, NULL, 5, NULL),
(5, 1654791601, 0, 5, 3, 19, 1, NULL, 3, NULL),
(6, 1654791602, 0, 6, 35, 36, 1, NULL, 1, NULL),
(7, 1654791602, 0, 7, 177, 41, 1, NULL, 1, NULL),
(8, 1654791602, 0, 8, 25, 40, 1, NULL, 4, NULL),
(9, 1654791602, 0, 9, 107, 11, 1, NULL, 2, NULL),
(10, 1654791602, 0, 10, 158, 18, 1, NULL, 1, NULL),
(11, 1654791603, 0, 11, 9, 26, 1, NULL, 5, NULL),
(12, 1654791603, 0, 12, 108, 35, 1, NULL, 4, NULL),
(13, 1654791603, 0, 13, 49, 37, 1, NULL, 4, NULL),
(14, 1654791603, 0, 14, 102, 4, 1, NULL, 4, NULL),
(15, 1654791603, 0, 15, 140, 26, 1, NULL, 2, NULL),
(16, 1654791603, 0, 16, 153, 4, 1, NULL, 4, NULL),
(17, 1654791603, 0, 17, 110, 21, 1, NULL, 4, NULL),
(18, 1654791604, 0, 18, 184, 32, 1, NULL, 4, NULL),
(19, 1654791604, 0, 19, 59, 15, 1, NULL, 3, NULL),
(20, 1654791604, 0, 20, 190, 23, 1, NULL, 1, NULL),
(21, 1654791604, 0, 21, 4, 41, 1, NULL, 1, NULL),
(22, 1654791604, 0, 22, 99, 3, 1, NULL, 4, NULL),
(23, 1654791604, 0, 23, 85, 25, 1, NULL, 3, NULL),
(24, 1654791604, 0, 24, 85, 3, 1, NULL, 5, NULL),
(25, 1654791604, 0, 25, 146, 42, 1, NULL, 5, NULL),
(26, 1654791605, 0, 26, 59, 33, 1, NULL, 4, NULL),
(27, 1654791605, 0, 27, 117, 20, 1, NULL, 1, NULL),
(28, 1654791605, 0, 28, 91, 19, 1, NULL, 2, NULL),
(29, 1654791605, 0, 29, 65, 22, 1, NULL, 5, NULL),
(30, 1654791605, 0, 30, 38, 18, 1, NULL, 5, NULL),
(31, 1654791605, 0, 31, 29, 6, 1, NULL, 2, NULL),
(32, 1654791605, 0, 32, 142, 41, 1, NULL, 4, NULL),
(33, 1654791606, 0, 33, 74, 23, 1, NULL, 2, NULL),
(34, 1654791606, 0, 34, 37, 23, 1, NULL, 5, NULL),
(35, 1654791606, 0, 35, 26, 6, 1, NULL, 2, NULL),
(36, 1654791606, 0, 36, 54, 8, 1, NULL, 1, NULL),
(37, 1654791606, 0, 37, 54, 8, 1, NULL, 5, NULL),
(38, 1654791606, 0, 38, 85, 22, 1, NULL, 3, NULL),
(39, 1654791607, 0, 39, 117, 19, 1, NULL, 1, NULL),
(40, 1654791607, 0, 40, 14, 7, 1, NULL, 1, NULL),
(41, 1654791607, 0, 41, 118, 41, 1, NULL, 3, NULL),
(42, 1654791607, 0, 42, 28, 28, 1, NULL, 4, NULL),
(43, 1654791607, 0, 43, 85, 31, 1, NULL, 5, NULL),
(44, 1654791607, 0, 44, 132, 23, 1, NULL, 5, NULL),
(45, 1654791607, 0, 45, 179, 20, 1, NULL, 3, NULL),
(46, 1654791607, 0, 46, 91, 19, 1, NULL, 2, NULL),
(47, 1654791608, 0, 47, 101, 32, 1, NULL, 4, NULL),
(48, 1654791608, 0, 48, 189, 9, 1, NULL, 4, NULL),
(49, 1654791608, 0, 49, 42, 7, 1, NULL, 1, NULL),
(50, 1654791608, 0, 50, 30, 32, 1, NULL, 1, NULL),
(51, 1654791608, 0, 51, 29, 1, 1, NULL, 1, NULL),
(52, 1654791608, 0, 52, 179, 12, 1, NULL, 5, NULL),
(53, 1654791608, 0, 53, 74, 24, 1, NULL, 5, NULL),
(54, 1654791608, 0, 54, 146, 5, 1, NULL, 3, NULL),
(55, 1654791608, 0, 55, 16, 24, 1, NULL, 3, NULL),
(56, 1654791609, 0, 56, 62, 19, 1, NULL, 3, NULL),
(57, 1654791609, 0, 57, 176, 11, 1, NULL, 5, NULL),
(58, 1654791609, 0, 58, 137, 40, 1, NULL, 4, NULL),
(59, 1654791609, 0, 59, 75, 12, 1, NULL, 4, NULL),
(60, 1654791609, 0, 60, 52, 30, 1, NULL, 5, NULL),
(61, 1654791609, 0, 61, 187, 22, 1, NULL, 5, NULL),
(62, 1654791609, 0, 62, 125, 30, 1, NULL, 3, NULL),
(63, 1654791609, 0, 63, 153, 42, 1, NULL, 2, NULL),
(64, 1654791609, 0, 64, 68, 36, 1, NULL, 3, NULL),
(65, 1654791609, 0, 65, 49, 6, 1, NULL, 2, NULL),
(66, 1654791609, 0, 66, 12, 26, 1, NULL, 1, NULL),
(67, 1654791609, 0, 67, 80, 39, 1, NULL, 3, NULL),
(68, 1654791610, 0, 68, 8, 37, 1, NULL, 4, NULL),
(69, 1654791610, 0, 69, 11, 7, 1, NULL, 5, NULL),
(70, 1654791610, 0, 70, 154, 16, 1, NULL, 1, NULL),
(71, 1654791610, 0, 71, 91, 3, 1, NULL, 1, NULL),
(72, 1654791610, 0, 72, 68, 21, 1, NULL, 5, NULL),
(73, 1654791610, 0, 73, 27, 26, 1, NULL, 3, NULL),
(74, 1654791610, 0, 74, 95, 22, 1, NULL, 2, NULL),
(75, 1654791610, 0, 75, 20, 3, 1, NULL, 2, NULL),
(76, 1654791610, 0, 76, 164, 5, 1, NULL, 4, NULL),
(77, 1654791610, 0, 77, 118, 1, 1, NULL, 1, NULL),
(78, 1654791610, 0, 78, 191, 9, 1, NULL, 4, NULL),
(79, 1654791610, 0, 79, 141, 14, 1, NULL, 5, NULL),
(80, 1654791610, 0, 80, 86, 39, 1, NULL, 3, NULL),
(81, 1654791610, 0, 81, 192, 31, 1, NULL, 1, NULL),
(82, 1654791610, 0, 82, 128, 34, 1, NULL, 1, NULL),
(83, 1654791610, 0, 83, 37, 5, 1, NULL, 4, NULL),
(84, 1654791610, 0, 84, 24, 24, 1, NULL, 1, NULL),
(85, 1654791610, 0, 85, 121, 39, 1, NULL, 2, NULL),
(86, 1654791611, 0, 86, 182, 35, 1, NULL, 3, NULL),
(87, 1654791611, 0, 87, 22, 8, 1, NULL, 5, NULL),
(88, 1654791611, 0, 88, 20, 17, 1, NULL, 4, NULL),
(89, 1654791611, 0, 89, 151, 3, 1, NULL, 3, NULL),
(90, 1654791611, 0, 90, 177, 6, 1, NULL, 3, NULL),
(91, 1654791611, 0, 91, 142, 14, 1, NULL, 4, NULL),
(92, 1654791611, 0, 92, 141, 33, 1, NULL, 1, NULL),
(93, 1654791611, 0, 93, 173, 18, 1, NULL, 4, NULL),
(94, 1654791611, 0, 94, 122, 34, 1, NULL, 1, NULL),
(95, 1654791612, 0, 95, 176, 42, 1, NULL, 4, NULL),
(96, 1654791612, 0, 96, 16, 7, 1, NULL, 3, NULL),
(97, 1654791612, 0, 97, 35, 26, 1, NULL, 1, NULL),
(98, 1654791612, 0, 98, 126, 24, 1, NULL, 4, NULL),
(99, 1654791612, 0, 99, 13, 10, 1, NULL, 3, NULL),
(100, 1654791612, 0, 100, 97, 29, 1, NULL, 1, NULL),
(101, 1654791612, 0, 101, 1, 29, 1, NULL, 4, NULL),
(102, 1654791612, 0, 102, 80, 10, 1, NULL, 5, NULL),
(103, 1654791612, 0, 103, 71, 21, 1, NULL, 4, NULL),
(104, 1654791612, 0, 104, 37, 40, 1, NULL, 4, NULL),
(105, 1654791613, 0, 105, 78, 31, 1, NULL, 4, NULL),
(106, 1654791613, 0, 106, 138, 29, 1, NULL, 3, NULL),
(107, 1654791613, 0, 107, 131, 17, 1, NULL, 2, NULL),
(108, 1654791613, 0, 108, 180, 26, 1, NULL, 4, NULL),
(109, 1654791613, 0, 109, 79, 29, 1, NULL, 5, NULL),
(110, 1654791613, 0, 110, 191, 39, 1, NULL, 3, NULL),
(111, 1654791613, 0, 111, 93, 16, 1, NULL, 4, NULL),
(112, 1654791613, 0, 112, 101, 36, 1, NULL, 2, NULL),
(113, 1654791613, 0, 113, 73, 25, 1, NULL, 4, NULL),
(114, 1654791613, 0, 114, 179, 24, 1, NULL, 1, NULL),
(115, 1654791613, 0, 115, 22, 37, 1, NULL, 5, NULL),
(116, 1654791613, 0, 116, 70, 31, 1, NULL, 2, NULL),
(117, 1654791613, 0, 117, 5, 16, 1, NULL, 4, NULL),
(118, 1654791614, 0, 118, 114, 21, 1, NULL, 1, NULL),
(119, 1654791614, 0, 119, 88, 16, 1, NULL, 5, NULL),
(120, 1654791614, 0, 120, 121, 8, 1, NULL, 2, NULL),
(121, 1654791614, 0, 121, 152, 42, 1, NULL, 4, NULL),
(122, 1654791614, 0, 122, 63, 3, 1, NULL, 4, NULL),
(123, 1654791614, 0, 123, 4, 7, 1, NULL, 1, NULL),
(124, 1654791614, 0, 124, 98, 5, 1, NULL, 5, NULL),
(125, 1654791614, 0, 125, 66, 11, 1, NULL, 3, NULL),
(126, 1654791614, 0, 126, 113, 37, 1, NULL, 4, NULL),
(127, 1654791614, 0, 127, 15, 1, 1, NULL, 5, NULL),
(128, 1654791614, 0, 128, 178, 19, 1, NULL, 5, NULL),
(129, 1654791614, 0, 129, 19, 27, 1, NULL, 5, NULL),
(130, 1654791614, 0, 130, 115, 10, 1, NULL, 1, NULL),
(131, 1654791614, 0, 131, 190, 29, 1, NULL, 3, NULL),
(132, 1654791614, 0, 132, 51, 5, 1, NULL, 5, NULL),
(133, 1654791614, 0, 133, 123, 36, 1, NULL, 4, NULL),
(134, 1654791614, 0, 134, 65, 2, 1, NULL, 1, NULL),
(135, 1654791614, 0, 135, 83, 22, 1, NULL, 5, NULL),
(136, 1654791614, 0, 136, 169, 2, 1, NULL, 4, NULL),
(137, 1654791614, 0, 137, 176, 2, 1, NULL, 5, NULL),
(138, 1654791614, 0, 138, 117, 1, 1, NULL, 4, NULL),
(139, 1654791614, 0, 139, 159, 8, 1, NULL, 3, NULL),
(140, 1654791614, 0, 140, 146, 31, 1, NULL, 1, NULL),
(141, 1654791615, 0, 141, 47, 37, 1, NULL, 3, NULL),
(142, 1654791615, 0, 142, 174, 37, 1, NULL, 1, NULL),
(143, 1654791615, 0, 143, 23, 35, 1, NULL, 2, NULL),
(144, 1654791615, 0, 144, 33, 26, 1, NULL, 1, NULL),
(145, 1654791615, 0, 145, 122, 23, 1, NULL, 5, NULL),
(146, 1654791615, 0, 146, 93, 7, 1, NULL, 4, NULL),
(147, 1654791615, 0, 147, 124, 16, 1, NULL, 4, NULL),
(148, 1654791615, 0, 148, 149, 38, 1, NULL, 1, NULL),
(149, 1654791615, 0, 149, 168, 32, 1, NULL, 5, NULL),
(150, 1654791615, 0, 150, 157, 17, 1, NULL, 5, NULL),
(151, 1654791615, 0, 151, 120, 17, 1, NULL, 2, NULL),
(152, 1654791615, 0, 152, 30, 35, 1, NULL, 5, NULL),
(153, 1654791615, 0, 153, 91, 4, 1, NULL, 4, NULL),
(154, 1654791615, 0, 154, 1, 32, 1, NULL, 4, NULL),
(155, 1654791615, 0, 155, 182, 23, 1, NULL, 1, NULL),
(156, 1654791615, 0, 156, 142, 3, 1, NULL, 1, NULL),
(157, 1654791615, 0, 157, 66, 8, 1, NULL, 5, NULL),
(158, 1654791615, 0, 158, 50, 26, 1, NULL, 5, NULL),
(159, 1654791615, 0, 159, 93, 28, 1, NULL, 4, NULL),
(160, 1654791615, 0, 160, 63, 37, 1, NULL, 4, NULL),
(161, 1654791615, 0, 161, 41, 24, 1, NULL, 2, NULL),
(162, 1654791615, 0, 162, 52, 5, 1, NULL, 5, NULL),
(163, 1654791615, 0, 163, 183, 8, 1, NULL, 4, NULL),
(164, 1654791616, 0, 164, 53, 19, 1, NULL, 5, NULL),
(165, 1654791616, 0, 165, 46, 34, 1, NULL, 4, NULL),
(166, 1654791616, 0, 166, 113, 2, 1, NULL, 3, NULL),
(167, 1654791616, 0, 167, 121, 12, 1, NULL, 4, NULL),
(168, 1654791616, 0, 168, 185, 10, 1, NULL, 4, NULL),
(169, 1654791616, 0, 169, 116, 20, 1, NULL, 1, NULL),
(170, 1654791616, 0, 170, 118, 26, 1, NULL, 4, NULL),
(171, 1654791616, 0, 171, 30, 25, 1, NULL, 1, NULL),
(172, 1654791616, 0, 172, 18, 34, 1, NULL, 4, NULL),
(173, 1654791616, 0, 173, 59, 13, 1, NULL, 2, NULL),
(174, 1654791616, 0, 174, 31, 6, 1, NULL, 3, NULL),
(175, 1654791616, 0, 175, 72, 22, 1, NULL, 2, NULL),
(176, 1654791616, 0, 176, 168, 10, 1, NULL, 4, NULL),
(177, 1654791616, 0, 177, 140, 14, 1, NULL, 5, NULL),
(178, 1654791616, 0, 178, 16, 7, 1, NULL, 3, NULL),
(179, 1654791616, 0, 179, 130, 2, 1, NULL, 3, NULL),
(180, 1654791616, 0, 180, 121, 5, 1, NULL, 5, NULL),
(181, 1654791616, 0, 181, 124, 10, 1, NULL, 2, NULL),
(182, 1654791616, 0, 182, 37, 17, 1, NULL, 3, NULL),
(183, 1654791617, 0, 183, 47, 14, 1, NULL, 3, NULL),
(184, 1654791617, 0, 184, 125, 30, 1, NULL, 5, NULL),
(185, 1654791617, 0, 185, 141, 32, 1, NULL, 1, NULL),
(186, 1654791617, 0, 186, 166, 16, 1, NULL, 1, NULL),
(187, 1654791617, 0, 187, 6, 20, 1, NULL, 4, NULL),
(188, 1654791617, 0, 188, 19, 15, 1, NULL, 3, NULL),
(189, 1654791617, 0, 189, 98, 37, 1, NULL, 1, NULL),
(190, 1654791617, 0, 190, 50, 15, 1, NULL, 3, NULL),
(191, 1654791617, 0, 191, 81, 8, 1, NULL, 1, NULL),
(192, 1654791617, 0, 192, 74, 33, 1, NULL, 1, NULL),
(193, 1654791617, 0, 193, 41, 2, 1, NULL, 2, NULL),
(194, 1654791617, 0, 194, 137, 14, 1, NULL, 3, NULL),
(195, 1654791617, 0, 195, 100, 34, 1, NULL, 4, NULL),
(196, 1654791617, 0, 196, 153, 28, 1, NULL, 1, NULL),
(197, 1654791617, 0, 197, 124, 25, 1, NULL, 1, NULL),
(198, 1654791617, 0, 198, 12, 21, 1, NULL, 2, NULL),
(199, 1654791617, 0, 199, 99, 37, 1, NULL, 5, NULL),
(200, 1654791617, 0, 200, 175, 21, 1, NULL, 3, NULL),
(201, 1654791617, 0, 201, 157, 6, 1, NULL, 3, NULL);

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

--
-- Table structure for table `inscription_document`
--

DROP TABLE IF EXISTS `inscription_document`;
CREATE TABLE IF NOT EXISTS `inscription_document` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `ins_id` int(11) NOT NULL,
  `doc_id` int(11) NOT NULL,
  `doc_date_submit` bigint(20) DEFAULT NULL,
  `doc_source` varchar(200) DEFAULT NULL,
  `doc_notice` mediumtext,
  `doc_accept` tinyint(1) DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=23 DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `inscription_document`
--

INSERT INTO `inscription_document` (`id`, `ins_id`, `doc_id`, `doc_date_submit`, `doc_source`, `doc_notice`, `doc_accept`) VALUES
(1, 1, 1, NULL, './uploads/1/1/example1.pdf', NULL, 1),
(2, 1, 2, 1654705157, './uploads/1/2/Examen_DotNet (1).pdf', NULL, NULL),
(20, 1, 5, NULL, './uploads/1/5/cv fadoua 2.docx', NULL, NULL),
(21, 1, 6, NULL, './uploads/1/6/cv fadoua 2.docx', NULL, NULL),
(22, 1, 20, NULL, NULL, NULL, 0);

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

--
-- Table structure for table `langue_niveau`
--

DROP TABLE IF EXISTS `langue_niveau`;
CREATE TABLE IF NOT EXISTS `langue_niveau` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `langue_nom` varchar(20) NOT NULL,
  `niveau` varchar(30) NOT NULL,
  `ins_id` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=20 DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `langue_niveau`
--

INSERT INTO `langue_niveau` (`id`, `langue_nom`, `niveau`, `ins_id`) VALUES
(1, 'français', 'Intermediare', 1),
(2, 'français', 'Intermediare', 1),
(3, 'français', 'Intermediare', 1),
(4, 'français', 'Intermediare', 1),
(5, 'français', 'Intermediare', 1),
(6, 'français', 'Intermediare', 1),
(7, 'français', 'Intermediare', 1),
(8, 'français', 'Intermediare', 1),
(9, 'français', 'Intermediare', 1),
(10, 'français', 'Intermediare', 1),
(11, 'français', 'Intermediare', 1),
(12, 'français', 'Intermediare', 1),
(13, 'français', 'Intermediare', 1),
(14, 'français', 'Intermediare', 1),
(15, 'français', 'Intermediare', 1),
(16, 'français', 'Intermediare', 1),
(17, 'français', 'Intermediare', 1),
(18, 'français', 'Intermediare', 1),
(19, 'anglais', 'Intermediare', 1);

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

--
-- Table structure for table `nationalite`
--

DROP TABLE IF EXISTS `nationalite`;
CREATE TABLE IF NOT EXISTS `nationalite` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `nom` varchar(40) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=195 DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `nationalite`
--

INSERT INTO `nationalite` (`id`, `nom`) VALUES
(1, 'Afghane'),
(2, 'Albanaise'),
(3, 'Algerienne'),
(4, 'Allemande'),
(5, 'Americaine'),
(6, 'Andorrane'),
(7, 'Angolaise'),
(8, 'Antiguaise et barbudienne'),
(9, 'Argentine'),
(10, 'Armenienne'),
(11, 'Australienne'),
(12, 'Autrichienne'),
(13, 'Azerbaïdjanaise'),
(14, 'Bahamienne'),
(15, 'Bahreinienne'),
(16, 'Bangladaise'),
(17, 'Barbadienne'),
(18, 'Belge'),
(19, 'Belizienne'),
(20, 'Beninoise'),
(21, 'Bhoutanaise'),
(22, 'Bielorusse'),
(23, 'Birmane'),
(24, 'Bissau-Guinéenne'),
(25, 'Bolivienne'),
(26, 'Bosnienne'),
(27, 'Botswanaise'),
(28, 'Bresilienne'),
(29, 'Britannique'),
(30, 'Bruneienne'),
(31, 'Bulgare'),
(32, 'Burkinabe'),
(33, 'Burundaise'),
(34, 'Cambodgienne'),
(35, 'Camerounaise'),
(36, 'Canadienne'),
(37, 'Cap-verdienne'),
(38, 'Centrafricaine'),
(39, 'Chilienne'),
(40, 'Chinoise'),
(41, 'Chypriote'),
(42, 'Colombienne'),
(43, 'Comorienne'),
(44, 'Congolaise'),
(45, 'Costaricaine'),
(46, 'Croate'),
(47, 'Cubaine'),
(48, 'Danoise'),
(49, 'Djiboutienne'),
(50, 'Dominicaine'),
(51, 'Dominiquaise'),
(52, 'Egyptienne'),
(53, 'Emirienne'),
(54, 'Equato-guineenne'),
(55, 'Equatorienne'),
(56, 'Erythreenne'),
(57, 'Espagnole'),
(58, 'Est-timoraise'),
(59, 'Estonienne'),
(60, 'Ethiopienne'),
(61, 'Fidjienne'),
(62, 'Finlandaise'),
(63, 'Française'),
(64, 'Gabonaise'),
(65, 'Gambienne'),
(66, 'Georgienne'),
(67, 'Ghaneenne'),
(68, 'Grenadienne'),
(69, 'Guatemalteque'),
(70, 'Guineenne'),
(71, 'Guyanienne'),
(72, 'Haïtienne'),
(73, 'Hellenique'),
(74, 'Hondurienne'),
(75, 'Hongroise'),
(76, 'Indienne'),
(77, 'Indonesienne'),
(78, 'Irakienne'),
(79, 'Irlandaise'),
(80, 'Islandaise'),
(82, 'Italienne'),
(83, 'Ivoirienne'),
(84, 'Jamaïcaine'),
(85, 'Japonaise'),
(86, 'Jordanienne'),
(87, 'Kazakhstanaise'),
(88, 'Kenyane'),
(89, 'Kirghize'),
(90, 'Kiribatienne'),
(91, 'Kittitienne-et-nevicienne'),
(92, 'Kossovienne'),
(93, 'Koweitienne'),
(94, 'Laotienne'),
(95, 'Lesothane'),
(96, 'Lettone'),
(97, 'Libanaise'),
(98, 'Liberienne'),
(99, 'Libyenne'),
(100, 'Liechtensteinoise'),
(101, 'Lituanienne'),
(102, 'Luxembourgeoise'),
(103, 'Macedonienne'),
(104, 'Malaisienne'),
(105, 'Malawienne'),
(106, 'Maldivienne'),
(107, 'Malgache'),
(108, 'Malienne'),
(109, 'Maltaise'),
(110, 'Marocaine'),
(111, 'Marshallaise'),
(112, 'Mauricienne'),
(113, 'Mauritanienne'),
(114, 'Mexicaine'),
(115, 'Micronesienne'),
(116, 'Moldave'),
(117, 'Monegasque'),
(118, 'Mongole'),
(119, 'Montenegrine'),
(120, 'Mozambicaine'),
(121, 'Namibienne'),
(122, 'Nauruane'),
(123, 'Neerlandaise'),
(124, 'Neo-zelandaise'),
(125, 'Nepalaise'),
(126, 'Nicaraguayenne'),
(127, 'Nigeriane'),
(128, 'Nigerienne'),
(129, 'Nord-coréenne'),
(130, 'Norvegienne'),
(131, 'Omanaise'),
(132, 'Ougandaise'),
(133, 'Ouzbeke'),
(134, 'Pakistanaise'),
(135, 'Palau'),
(136, 'Palestinienne'),
(137, 'Panameenne'),
(138, 'Papouane-neoguineenne'),
(139, 'Paraguayenne'),
(140, 'Peruvienne'),
(141, 'Philippine'),
(142, 'Polonaise'),
(143, 'Portoricaine'),
(144, 'Portugaise'),
(145, 'Qatarienne'),
(146, 'Roumaine'),
(147, 'Russe'),
(148, 'Rwandaise'),
(149, 'Saint-lucienne'),
(150, 'Saint-marinaise'),
(151, 'Saint-vincentaise-et-grenadine'),
(152, 'Salomonaise'),
(153, 'Salvadorienne'),
(154, 'Samoane'),
(155, 'Santomeenne'),
(156, 'Saoudienne'),
(157, 'Senegalaise'),
(158, 'Serbe'),
(159, 'Seychelloise'),
(160, 'Sierra-leonaise'),
(161, 'Singapourienne'),
(162, 'Slovaque'),
(163, 'Slovene'),
(164, 'Somalienne'),
(165, 'Soudanaise'),
(166, 'Sri-lankaise'),
(167, 'Sud-africaine'),
(168, 'Sud-coréenne'),
(169, 'Suedoise'),
(170, 'Suisse'),
(171, 'Surinamaise'),
(172, 'Swazie'),
(173, 'Syrienne'),
(174, 'Tadjike'),
(175, 'Taiwanaise'),
(176, 'Tanzanienne'),
(177, 'Tchadienne'),
(178, 'Tcheque'),
(179, 'Thaïlandaise'),
(180, 'Togolaise'),
(181, 'Tonguienne'),
(182, 'Trinidadienne'),
(183, 'Tunisienne'),
(184, 'Turkmene'),
(185, 'Turque'),
(186, 'Tuvaluane'),
(187, 'Ukrainienne'),
(188, 'Uruguayenne'),
(189, 'Vanuatuane'),
(190, 'Venezuelienne'),
(191, 'Vietnamienne'),
(192, 'Yemenite'),
(193, 'Zambienne'),
(194, 'Zimbabweenne');

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

--
-- Table structure for table `permission`
--

DROP TABLE IF EXISTS `permission`;
CREATE TABLE IF NOT EXISTS `permission` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `nom` varchar(60) NOT NULL,
  `url` varchar(70) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

--
-- Table structure for table `phase`
--

DROP TABLE IF EXISTS `phase`;
CREATE TABLE IF NOT EXISTS `phase` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `nom` varchar(50) NOT NULL,
  `url` varchar(50) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `phase`
--

INSERT INTO `phase` (`id`, `nom`, `url`) VALUES
(1, 'Completement des informations', NULL),
(2, 'Prise en contact', NULL),
(3, 'Pré-Inscription', NULL),
(4, 'Inscripiton - Dossier Incomplet', NULL),
(5, 'Inscription - Dossier Complet', NULL);

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

--
-- Table structure for table `phase_condition`
--

DROP TABLE IF EXISTS `phase_condition`;
CREATE TABLE IF NOT EXISTS `phase_condition` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `phase_id` int(11) NOT NULL,
  `condition_id` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

--
-- Table structure for table `remarque`
--

DROP TABLE IF EXISTS `remarque`;
CREATE TABLE IF NOT EXISTS `remarque` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `text` mediumtext NOT NULL,
  `date` bigint(10) NOT NULL,
  `ins_id` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

--
-- Table structure for table `utilisateur`
--

DROP TABLE IF EXISTS `utilisateur`;
CREATE TABLE IF NOT EXISTS `utilisateur` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `nom_utilisateur` varchar(50) NOT NULL,
  `email` varchar(60) NOT NULL,
  `motdepasse` varchar(100) NOT NULL,
  `premiere_acces` bigint(10) DEFAULT NULL,
  `derniere_acces` bigint(10) DEFAULT NULL,
  `actif` tinyint(1) DEFAULT '1',
  `collaborateur_id` int(11) DEFAULT NULL,
  `utilisateur_type` varchar(30) NOT NULL,
  `utilisateur_ref_id` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `utilisateur`
--

INSERT INTO `utilisateur` (`id`, `nom_utilisateur`, `email`, `motdepasse`, `premiere_acces`, `derniere_acces`, `actif`, `collaborateur_id`, `utilisateur_type`, `utilisateur_ref_id`) VALUES
(1, 'aoulhicham', 'aoul.hicham@gmail.com', '$2y$10$ncO8a17saBQ2PeydOGDJLe9pL4Sx6UdTz6iLvf5YYq4TTfmciC8cS', 1654774467, 1654777743, 1, NULL, 'Visiteur', 1),
(2, 'aoul.hicham', 'elaoula.hicham@gmail.com', '$2y$10$ncO8a17saBQ2PeydOGDJLe9pL4Sx6UdTz6iLvf5YYq4TTfmciC8cS', 1654774478, 1654795866, 1, NULL, 'Admin', 1);

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

--
-- Table structure for table `visiteur`
--

DROP TABLE IF EXISTS `visiteur`;
CREATE TABLE IF NOT EXISTS `visiteur` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `nom` varchar(40) NOT NULL,
  `prenom` varchar(40) NOT NULL,
  `nom_ar` varchar(40) DEFAULT NULL,
  `prenom_ar` varchar(40) DEFAULT NULL,
  `sexe` char(1) DEFAULT NULL,
  `date_naissance` date DEFAULT NULL,
  `ville_naissance` varchar(30) DEFAULT NULL,
  `ville_naissance_ar` varchar(30) DEFAULT NULL,
  `tel` varchar(30) NOT NULL,
  `adresse` varchar(200) DEFAULT NULL,
  `ville` varchar(20) DEFAULT NULL,
  `cin` varchar(15) DEFAULT NULL,
  `code_massar` varchar(20) DEFAULT NULL,
  `handicape` tinyint(1) DEFAULT NULL,
  `salarie` tinyint(1) DEFAULT NULL,
  `pere_cnss` tinyint(1) DEFAULT NULL,
  `comment_connu_ecole` mediumtext,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=202 DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `visiteur`
--

INSERT INTO `visiteur` (`id`, `nom`, `prenom`, `nom_ar`, `prenom_ar`, `sexe`, `date_naissance`, `ville_naissance`, `ville_naissance_ar`, `tel`, `adresse`, `ville`, `cin`, `code_massar`, `handicape`, `salarie`, `pere_cnss`, `comment_connu_ecole`) VALUES
(1, 'elaoula', 'hicham', 'العولة', 'هشام', 'M', '1991-09-23', 'kenitra', 'القنيطرة', '0643637158', '', '', 'G633394', 'E14525656', 0, 1, 0, ''),
(2, '1', '1', NULL, NULL, NULL, NULL, NULL, NULL, '40229690', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(3, '2', '2', NULL, NULL, NULL, NULL, NULL, NULL, '81694499', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(4, '3', '3', NULL, NULL, NULL, NULL, NULL, NULL, '16951645', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(5, '4', '4', NULL, NULL, NULL, NULL, NULL, NULL, '59456897', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(6, '5', '5', NULL, NULL, NULL, NULL, NULL, NULL, '23411556', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(7, '6', '6', NULL, NULL, NULL, NULL, NULL, NULL, '40691261', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(8, '7', '7', NULL, NULL, NULL, NULL, NULL, NULL, '69312579', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(9, '8', '8', NULL, NULL, NULL, NULL, NULL, NULL, '91747820', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(10, '9', '9', NULL, NULL, NULL, NULL, NULL, NULL, '84110513', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(11, '10', '10', NULL, NULL, NULL, NULL, NULL, NULL, '13278150', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(12, '11', '11', NULL, NULL, NULL, NULL, NULL, NULL, '88408055', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(13, '12', '12', NULL, NULL, NULL, NULL, NULL, NULL, '14452353', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(14, '13', '13', NULL, NULL, NULL, NULL, NULL, NULL, '36183655', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(15, '14', '14', NULL, NULL, NULL, NULL, NULL, NULL, '9878479', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(16, '15', '15', NULL, NULL, NULL, NULL, NULL, NULL, '77622962', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(17, '16', '16', NULL, NULL, NULL, NULL, NULL, NULL, '72386118', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(18, '17', '17', NULL, NULL, NULL, NULL, NULL, NULL, '36897510', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(19, '18', '18', NULL, NULL, NULL, NULL, NULL, NULL, '31587730', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(20, '19', '19', NULL, NULL, NULL, NULL, NULL, NULL, '29744617', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(21, '20', '20', NULL, NULL, NULL, NULL, NULL, NULL, '40838020', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(22, '21', '21', NULL, NULL, NULL, NULL, NULL, NULL, '82512206', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(23, '22', '22', NULL, NULL, NULL, NULL, NULL, NULL, '54417293', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(24, '23', '23', NULL, NULL, NULL, NULL, NULL, NULL, '84640246', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(25, '24', '24', NULL, NULL, NULL, NULL, NULL, NULL, '4371894', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(26, '25', '25', NULL, NULL, NULL, NULL, NULL, NULL, '56369543', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(27, '26', '26', NULL, NULL, NULL, NULL, NULL, NULL, '65874877', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(28, '27', '27', NULL, NULL, NULL, NULL, NULL, NULL, '87287720', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(29, '28', '28', NULL, NULL, NULL, NULL, NULL, NULL, '87354664', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(30, '29', '29', NULL, NULL, NULL, NULL, NULL, NULL, '98115328', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(31, '30', '30', NULL, NULL, NULL, NULL, NULL, NULL, '43655779', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(32, '31', '31', NULL, NULL, NULL, NULL, NULL, NULL, '90478566', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(33, '32', '32', NULL, NULL, NULL, NULL, NULL, NULL, '96200838', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(34, '33', '33', NULL, NULL, NULL, NULL, NULL, NULL, '62306949', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(35, '34', '34', NULL, NULL, NULL, NULL, NULL, NULL, '48859650', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(36, '35', '35', NULL, NULL, NULL, NULL, NULL, NULL, '30243451', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(37, '36', '36', NULL, NULL, NULL, NULL, NULL, NULL, '52729118', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(38, '37', '37', NULL, NULL, NULL, NULL, NULL, NULL, '61850144', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(39, '38', '38', NULL, NULL, NULL, NULL, NULL, NULL, '32922846', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(40, '39', '39', NULL, NULL, NULL, NULL, NULL, NULL, '21944293', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(41, '40', '40', NULL, NULL, NULL, NULL, NULL, NULL, '88719392', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(42, '41', '41', NULL, NULL, NULL, NULL, NULL, NULL, '26357244', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(43, '42', '42', NULL, NULL, NULL, NULL, NULL, NULL, '4247400', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(44, '43', '43', NULL, NULL, NULL, NULL, NULL, NULL, '8524208', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(45, '44', '44', NULL, NULL, NULL, NULL, NULL, NULL, '87843791', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(46, '45', '45', NULL, NULL, NULL, NULL, NULL, NULL, '13649831', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(47, '46', '46', NULL, NULL, NULL, NULL, NULL, NULL, '90588302', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(48, '47', '47', NULL, NULL, NULL, NULL, NULL, NULL, '49037218', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(49, '48', '48', NULL, NULL, NULL, NULL, NULL, NULL, '72088871', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(50, '49', '49', NULL, NULL, NULL, NULL, NULL, NULL, '96063656', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(51, '50', '50', NULL, NULL, NULL, NULL, NULL, NULL, '29826633', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(52, '51', '51', NULL, NULL, NULL, NULL, NULL, NULL, '65849864', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(53, '52', '52', NULL, NULL, NULL, NULL, NULL, NULL, '70603053', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(54, '53', '53', NULL, NULL, NULL, NULL, NULL, NULL, '49947271', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(55, '54', '54', NULL, NULL, NULL, NULL, NULL, NULL, '71433795', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(56, '55', '55', NULL, NULL, NULL, NULL, NULL, NULL, '1062731', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(57, '56', '56', NULL, NULL, NULL, NULL, NULL, NULL, '14360841', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(58, '57', '57', NULL, NULL, NULL, NULL, NULL, NULL, '61662052', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(59, '58', '58', NULL, NULL, NULL, NULL, NULL, NULL, '59031375', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(60, '59', '59', NULL, NULL, NULL, NULL, NULL, NULL, '58265695', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(61, '60', '60', NULL, NULL, NULL, NULL, NULL, NULL, '22951636', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(62, '61', '61', NULL, NULL, NULL, NULL, NULL, NULL, '94964614', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(63, '62', '62', NULL, NULL, NULL, NULL, NULL, NULL, '77186677', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(64, '63', '63', NULL, NULL, NULL, NULL, NULL, NULL, '58789658', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(65, '64', '64', NULL, NULL, NULL, NULL, NULL, NULL, '95087914', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(66, '65', '65', NULL, NULL, NULL, NULL, NULL, NULL, '41544722', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(67, '66', '66', NULL, NULL, NULL, NULL, NULL, NULL, '5545507', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(68, '67', '67', NULL, NULL, NULL, NULL, NULL, NULL, '41417203', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(69, '68', '68', NULL, NULL, NULL, NULL, NULL, NULL, '57303345', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(70, '69', '69', NULL, NULL, NULL, NULL, NULL, NULL, '48108390', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(71, '70', '70', NULL, NULL, NULL, NULL, NULL, NULL, '20984081', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(72, '71', '71', NULL, NULL, NULL, NULL, NULL, NULL, '47625635', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(73, '72', '72', NULL, NULL, NULL, NULL, NULL, NULL, '4882848', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(74, '73', '73', NULL, NULL, NULL, NULL, NULL, NULL, '98918488', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(75, '74', '74', NULL, NULL, NULL, NULL, NULL, NULL, '72984890', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(76, '75', '75', NULL, NULL, NULL, NULL, NULL, NULL, '3203122', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(77, '76', '76', NULL, NULL, NULL, NULL, NULL, NULL, '28790342', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(78, '77', '77', NULL, NULL, NULL, NULL, NULL, NULL, '58848658', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(79, '78', '78', NULL, NULL, NULL, NULL, NULL, NULL, '9377484', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(80, '79', '79', NULL, NULL, NULL, NULL, NULL, NULL, '40432389', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(81, '80', '80', NULL, NULL, NULL, NULL, NULL, NULL, '86069352', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(82, '81', '81', NULL, NULL, NULL, NULL, NULL, NULL, '41714433', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(83, '82', '82', NULL, NULL, NULL, NULL, NULL, NULL, '1287326', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(84, '83', '83', NULL, NULL, NULL, NULL, NULL, NULL, '7213175', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(85, '84', '84', NULL, NULL, NULL, NULL, NULL, NULL, '25127702', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(86, '85', '85', NULL, NULL, NULL, NULL, NULL, NULL, '1278379', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(87, '86', '86', NULL, NULL, NULL, NULL, NULL, NULL, '56972097', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(88, '87', '87', NULL, NULL, NULL, NULL, NULL, NULL, '7779033', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(89, '88', '88', NULL, NULL, NULL, NULL, NULL, NULL, '99037895', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(90, '89', '89', NULL, NULL, NULL, NULL, NULL, NULL, '68590331', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(91, '90', '90', NULL, NULL, NULL, NULL, NULL, NULL, '31092803', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(92, '91', '91', NULL, NULL, NULL, NULL, NULL, NULL, '19774028', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(93, '92', '92', NULL, NULL, NULL, NULL, NULL, NULL, '66838369', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(94, '93', '93', NULL, NULL, NULL, NULL, NULL, NULL, '38506247', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(95, '94', '94', NULL, NULL, NULL, NULL, NULL, NULL, '61437417', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(96, '95', '95', NULL, NULL, NULL, NULL, NULL, NULL, '6788845', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(97, '96', '96', NULL, NULL, NULL, NULL, NULL, NULL, '84466102', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(98, '97', '97', NULL, NULL, NULL, NULL, NULL, NULL, '70188709', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(99, '98', '98', NULL, NULL, NULL, NULL, NULL, NULL, '54995290', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(100, '99', '99', NULL, NULL, NULL, NULL, NULL, NULL, '33652081', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(101, '100', '100', NULL, NULL, NULL, NULL, NULL, NULL, '98727378', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(102, '101', '101', NULL, NULL, NULL, NULL, NULL, NULL, '43007393', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(103, '102', '102', NULL, NULL, NULL, NULL, NULL, NULL, '72654646', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(104, '103', '103', NULL, NULL, NULL, NULL, NULL, NULL, '70749215', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(105, '104', '104', NULL, NULL, NULL, NULL, NULL, NULL, '367390', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(106, '105', '105', NULL, NULL, NULL, NULL, NULL, NULL, '90755047', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(107, '106', '106', NULL, NULL, NULL, NULL, NULL, NULL, '214403', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(108, '107', '107', NULL, NULL, NULL, NULL, NULL, NULL, '2489760', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(109, '108', '108', NULL, NULL, NULL, NULL, NULL, NULL, '40714726', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(110, '109', '109', NULL, NULL, NULL, NULL, NULL, NULL, '4897637', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(111, '110', '110', NULL, NULL, NULL, NULL, NULL, NULL, '22268112', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(112, '111', '111', NULL, NULL, NULL, NULL, NULL, NULL, '14539295', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(113, '112', '112', NULL, NULL, NULL, NULL, NULL, NULL, '63365072', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(114, '113', '113', NULL, NULL, NULL, NULL, NULL, NULL, '26199154', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(115, '114', '114', NULL, NULL, NULL, NULL, NULL, NULL, '45049886', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(116, '115', '115', NULL, NULL, NULL, NULL, NULL, NULL, '65356557', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(117, '116', '116', NULL, NULL, NULL, NULL, NULL, NULL, '8939618', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(118, '117', '117', NULL, NULL, NULL, NULL, NULL, NULL, '90954456', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(119, '118', '118', NULL, NULL, NULL, NULL, NULL, NULL, '9913182', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(120, '119', '119', NULL, NULL, NULL, NULL, NULL, NULL, '16092105', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(121, '120', '120', NULL, NULL, NULL, NULL, NULL, NULL, '56945561', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(122, '121', '121', NULL, NULL, NULL, NULL, NULL, NULL, '52523794', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(123, '122', '122', NULL, NULL, NULL, NULL, NULL, NULL, '82905163', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(124, '123', '123', NULL, NULL, NULL, NULL, NULL, NULL, '13057704', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(125, '124', '124', NULL, NULL, NULL, NULL, NULL, NULL, '29256478', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(126, '125', '125', NULL, NULL, NULL, NULL, NULL, NULL, '19084161', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(127, '126', '126', NULL, NULL, NULL, NULL, NULL, NULL, '61612207', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(128, '127', '127', NULL, NULL, NULL, NULL, NULL, NULL, '1660303', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(129, '128', '128', NULL, NULL, NULL, NULL, NULL, NULL, '32316067', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(130, '129', '129', NULL, NULL, NULL, NULL, NULL, NULL, '12348008', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(131, '130', '130', NULL, NULL, NULL, NULL, NULL, NULL, '84563661', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(132, '131', '131', NULL, NULL, NULL, NULL, NULL, NULL, '92285541', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(133, '132', '132', NULL, NULL, NULL, NULL, NULL, NULL, '66329124', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(134, '133', '133', NULL, NULL, NULL, NULL, NULL, NULL, '44994641', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(135, '134', '134', NULL, NULL, NULL, NULL, NULL, NULL, '50685941', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(136, '135', '135', NULL, NULL, NULL, NULL, NULL, NULL, '74299439', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(137, '136', '136', NULL, NULL, NULL, NULL, NULL, NULL, '31403206', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(138, '137', '137', NULL, NULL, NULL, NULL, NULL, NULL, '52943854', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(139, '138', '138', NULL, NULL, NULL, NULL, NULL, NULL, '8776574', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(140, '139', '139', NULL, NULL, NULL, NULL, NULL, NULL, '17162727', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(141, '140', '140', NULL, NULL, NULL, NULL, NULL, NULL, '70071323', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(142, '141', '141', NULL, NULL, NULL, NULL, NULL, NULL, '1369602', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(143, '142', '142', NULL, NULL, NULL, NULL, NULL, NULL, '56377989', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(144, '143', '143', NULL, NULL, NULL, NULL, NULL, NULL, '91794040', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(145, '144', '144', NULL, NULL, NULL, NULL, NULL, NULL, '35687870', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(146, '145', '145', NULL, NULL, NULL, NULL, NULL, NULL, '59459075', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(147, '146', '146', NULL, NULL, NULL, NULL, NULL, NULL, '93230936', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(148, '147', '147', NULL, NULL, NULL, NULL, NULL, NULL, '91592825', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(149, '148', '148', NULL, NULL, NULL, NULL, NULL, NULL, '12606926', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(150, '149', '149', NULL, NULL, NULL, NULL, NULL, NULL, '74707850', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(151, '150', '150', NULL, NULL, NULL, NULL, NULL, NULL, '94841311', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(152, '151', '151', NULL, NULL, NULL, NULL, NULL, NULL, '47366211', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(153, '152', '152', NULL, NULL, NULL, NULL, NULL, NULL, '14493275', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(154, '153', '153', NULL, NULL, NULL, NULL, NULL, NULL, '72730935', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(155, '154', '154', NULL, NULL, NULL, NULL, NULL, NULL, '16115604', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(156, '155', '155', NULL, NULL, NULL, NULL, NULL, NULL, '51369583', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(157, '156', '156', NULL, NULL, NULL, NULL, NULL, NULL, '34734211', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(158, '157', '157', NULL, NULL, NULL, NULL, NULL, NULL, '49113626', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(159, '158', '158', NULL, NULL, NULL, NULL, NULL, NULL, '82346492', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(160, '159', '159', NULL, NULL, NULL, NULL, NULL, NULL, '66548537', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(161, '160', '160', NULL, NULL, NULL, NULL, NULL, NULL, '90784943', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(162, '161', '161', NULL, NULL, NULL, NULL, NULL, NULL, '46273692', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(163, '162', '162', NULL, NULL, NULL, NULL, NULL, NULL, '75833868', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(164, '163', '163', NULL, NULL, NULL, NULL, NULL, NULL, '4859313', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(165, '164', '164', NULL, NULL, NULL, NULL, NULL, NULL, '20655706', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(166, '165', '165', NULL, NULL, NULL, NULL, NULL, NULL, '56410828', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(167, '166', '166', NULL, NULL, NULL, NULL, NULL, NULL, '96769854', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(168, '167', '167', NULL, NULL, NULL, NULL, NULL, NULL, '78296802', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(169, '168', '168', NULL, NULL, NULL, NULL, NULL, NULL, '44431133', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(170, '169', '169', NULL, NULL, NULL, NULL, NULL, NULL, '17273393', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(171, '170', '170', NULL, NULL, NULL, NULL, NULL, NULL, '90831923', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(172, '171', '171', NULL, NULL, NULL, NULL, NULL, NULL, '52221883', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(173, '172', '172', NULL, NULL, NULL, NULL, NULL, NULL, '59965420', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(174, '173', '173', NULL, NULL, NULL, NULL, NULL, NULL, '80355548', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(175, '174', '174', NULL, NULL, NULL, NULL, NULL, NULL, '82866686', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(176, '175', '175', NULL, NULL, NULL, NULL, NULL, NULL, '16063356', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(177, '176', '176', NULL, NULL, NULL, NULL, NULL, NULL, '65665804', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(178, '177', '177', NULL, NULL, NULL, NULL, NULL, NULL, '17834937', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(179, '178', '178', NULL, NULL, NULL, NULL, NULL, NULL, '6310290', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(180, '179', '179', NULL, NULL, NULL, NULL, NULL, NULL, '52925997', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(181, '180', '180', NULL, NULL, NULL, NULL, NULL, NULL, '56294331', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(182, '181', '181', NULL, NULL, NULL, NULL, NULL, NULL, '89561250', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(183, '182', '182', NULL, NULL, NULL, NULL, NULL, NULL, '48598517', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(184, '183', '183', NULL, NULL, NULL, NULL, NULL, NULL, '5557043', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(185, '184', '184', NULL, NULL, NULL, NULL, NULL, NULL, '54023271', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(186, '185', '185', NULL, NULL, NULL, NULL, NULL, NULL, '96300208', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(187, '186', '186', NULL, NULL, NULL, NULL, NULL, NULL, '84631576', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(188, '187', '187', NULL, NULL, NULL, NULL, NULL, NULL, '43812204', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(189, '188', '188', NULL, NULL, NULL, NULL, NULL, NULL, '35666413', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(190, '189', '189', NULL, NULL, NULL, NULL, NULL, NULL, '35399108', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(191, '190', '190', NULL, NULL, NULL, NULL, NULL, NULL, '23413002', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(192, '191', '191', NULL, NULL, NULL, NULL, NULL, NULL, '17647635', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(193, '192', '192', NULL, NULL, NULL, NULL, NULL, NULL, '72683206', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(194, '193', '193', NULL, NULL, NULL, NULL, NULL, NULL, '72926414', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(195, '194', '194', NULL, NULL, NULL, NULL, NULL, NULL, '64174918', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(196, '195', '195', NULL, NULL, NULL, NULL, NULL, NULL, '66308339', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(197, '196', '196', NULL, NULL, NULL, NULL, NULL, NULL, '95253048', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(198, '197', '197', NULL, NULL, NULL, NULL, NULL, NULL, '34560649', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(199, '198', '198', NULL, NULL, NULL, NULL, NULL, NULL, '86906828', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(200, '199', '199', NULL, NULL, NULL, NULL, NULL, NULL, '23805471', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(201, '200', '200', NULL, NULL, NULL, NULL, NULL, NULL, '81996951', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);

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

--
-- Table structure for table `visiteur_bac`
--

DROP TABLE IF EXISTS `visiteur_bac`;
CREATE TABLE IF NOT EXISTS `visiteur_bac` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `visiteur_id` int(11) NOT NULL,
  `bac_id` int(11) NOT NULL,
  `serie` varchar(100) DEFAULT NULL,
  `autre_serie` varchar(149) DEFAULT NULL,
  `annee` varchar(15) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `visiteur_bac`
--

INSERT INTO `visiteur_bac` (`id`, `visiteur_id`, `bac_id`, `serie`, `autre_serie`, `annee`) VALUES
(1, 1, 1, 'Sciences physiques', '', '2020 - 2021');
COMMIT;

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;