-- phpMyAdmin SQL Dump
-- version 3.3.2deb1ubuntu1
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Jul 22, 2020 at 10:46 AM
-- Server version: 5.1.73
-- PHP Version: 5.3.2-1ubuntu4.30

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";


/*!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 utf8 */;

--
-- Database: `resultats90-91`
--

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

--
-- Table structure for table `h1f1`
--

CREATE TABLE IF NOT EXISTS `h1f1` (
  `NoExamen` varchar(40) COLLATE utf8_unicode_ci NOT NULL,
  `NoDossier` varchar(40) COLLATE utf8_unicode_ci NOT NULL,
  `Nom` varchar(200) COLLATE utf8_unicode_ci NOT NULL,
  `h1m15` varchar(40) COLLATE utf8_unicode_ci NOT NULL,
  `h1m17` varchar(40) COLLATE utf8_unicode_ci NOT NULL,
  `h1m20` varchar(40) COLLATE utf8_unicode_ci NOT NULL,
  `JuryEc` varchar(40) COLLATE utf8_unicode_ci NOT NULL,
  `TotEcritFinal` varchar(40) COLLATE utf8_unicode_ci NOT NULL,
  `h1m16` varchar(40) COLLATE utf8_unicode_ci NOT NULL,
  `h1m19` varchar(40) COLLATE utf8_unicode_ci NOT NULL,
  `h1m18` varchar(40) COLLATE utf8_unicode_ci NOT NULL,
  `h1m21` varchar(40) COLLATE utf8_unicode_ci NOT NULL,
  `h1m22` varchar(40) COLLATE utf8_unicode_ci NOT NULL,
  `TotOral` varchar(40) COLLATE utf8_unicode_ci NOT NULL,
  `JuryOr` varchar(40) COLLATE utf8_unicode_ci NOT NULL,
  `Total` varchar(40) COLLATE utf8_unicode_ci NOT NULL,
  `Resultat` varchar(40) COLLATE utf8_unicode_ci NOT NULL,
  `Degre` varchar(40) COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`NoDossier`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `h1f1`
--


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

--
-- Table structure for table `h1f2`
--

CREATE TABLE IF NOT EXISTS `h1f2` (
  `NoExamen` varchar(40) COLLATE utf8_unicode_ci NOT NULL,
  `NoDossier` varchar(40) COLLATE utf8_unicode_ci NOT NULL,
  `Nom` varchar(200) COLLATE utf8_unicode_ci NOT NULL,
  `h1m15` varchar(40) COLLATE utf8_unicode_ci NOT NULL,
  `h1m17` varchar(40) COLLATE utf8_unicode_ci NOT NULL,
  `h1m20` varchar(40) COLLATE utf8_unicode_ci NOT NULL,
  `JuryEc` varchar(40) COLLATE utf8_unicode_ci NOT NULL,
  `TotEcritFinal` varchar(40) COLLATE utf8_unicode_ci NOT NULL,
  `h1m16` varchar(40) COLLATE utf8_unicode_ci NOT NULL,
  `h1m19` varchar(40) COLLATE utf8_unicode_ci NOT NULL,
  `h1m18` varchar(40) COLLATE utf8_unicode_ci NOT NULL,
  `h1m21` varchar(40) COLLATE utf8_unicode_ci NOT NULL,
  `h1m22` varchar(40) COLLATE utf8_unicode_ci NOT NULL,
  `TotOral` varchar(40) COLLATE utf8_unicode_ci NOT NULL,
  `JuryOr` varchar(40) COLLATE utf8_unicode_ci NOT NULL,
  `Total` varchar(40) COLLATE utf8_unicode_ci NOT NULL,
  `Resultat` varchar(40) COLLATE utf8_unicode_ci NOT NULL,
  `Degre` varchar(40) COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`NoDossier`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `h1f2`
--


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

--
-- Table structure for table `h2f1`
--

CREATE TABLE IF NOT EXISTS `h2f1` (
  `NoExamen` varchar(40) COLLATE utf8_unicode_ci NOT NULL,
  `NoDossier` varchar(40) COLLATE utf8_unicode_ci NOT NULL,
  `Nom` varchar(200) COLLATE utf8_unicode_ci NOT NULL,
  `h2m18` varchar(40) COLLATE utf8_unicode_ci NOT NULL,
  `h2m20` varchar(40) COLLATE utf8_unicode_ci NOT NULL,
  `h2m23` varchar(40) COLLATE utf8_unicode_ci NOT NULL,
  `JuryEc` varchar(40) COLLATE utf8_unicode_ci NOT NULL,
  `TotEcritFinal` varchar(40) COLLATE utf8_unicode_ci NOT NULL,
  `h2m19` varchar(40) COLLATE utf8_unicode_ci NOT NULL,
  `h2m21` varchar(40) COLLATE utf8_unicode_ci NOT NULL,
  `h2m22` varchar(40) COLLATE utf8_unicode_ci NOT NULL,
  `h2m27` varchar(40) COLLATE utf8_unicode_ci NOT NULL,
  `h2m26` varchar(40) COLLATE utf8_unicode_ci NOT NULL,
  `TotOral` varchar(40) COLLATE utf8_unicode_ci NOT NULL,
  `JuryOr` varchar(40) COLLATE utf8_unicode_ci NOT NULL,
  `Total` varchar(40) COLLATE utf8_unicode_ci NOT NULL,
  `Resultat` varchar(40) COLLATE utf8_unicode_ci NOT NULL,
  `Degre` varchar(40) COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`NoDossier`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `h2f1`
--


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

--
-- Table structure for table `h2f2`
--

CREATE TABLE IF NOT EXISTS `h2f2` (
  `NoExamen` varchar(40) COLLATE utf8_unicode_ci NOT NULL,
  `NoDossier` varchar(40) COLLATE utf8_unicode_ci NOT NULL,
  `Nom` varchar(200) COLLATE utf8_unicode_ci NOT NULL,
  `h2m18` varchar(40) COLLATE utf8_unicode_ci NOT NULL,
  `h2m20` varchar(40) COLLATE utf8_unicode_ci NOT NULL,
  `h2m23` varchar(40) COLLATE utf8_unicode_ci NOT NULL,
  `JuryEc` varchar(40) COLLATE utf8_unicode_ci NOT NULL,
  `TotEcritFinal` varchar(40) COLLATE utf8_unicode_ci NOT NULL,
  `h2m19` varchar(40) COLLATE utf8_unicode_ci NOT NULL,
  `h2m21` varchar(40) COLLATE utf8_unicode_ci NOT NULL,
  `h2m22` varchar(40) COLLATE utf8_unicode_ci NOT NULL,
  `h2m27` varchar(40) COLLATE utf8_unicode_ci NOT NULL,
  `h2m26` varchar(40) COLLATE utf8_unicode_ci NOT NULL,
  `TotOral` varchar(40) COLLATE utf8_unicode_ci NOT NULL,
  `JuryOr` varchar(40) COLLATE utf8_unicode_ci NOT NULL,
  `Total` varchar(40) COLLATE utf8_unicode_ci NOT NULL,
  `Resultat` varchar(40) COLLATE utf8_unicode_ci NOT NULL,
  `Degre` varchar(40) COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`NoDossier`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `h2f2`
--


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

--
-- Table structure for table `h3f1`
--

CREATE TABLE IF NOT EXISTS `h3f1` (
  `NoExamen` varchar(40) COLLATE utf8_unicode_ci NOT NULL,
  `NoDossier` varchar(40) COLLATE utf8_unicode_ci NOT NULL,
  `Nom` varchar(200) COLLATE utf8_unicode_ci NOT NULL,
  `h3m18` varchar(40) COLLATE utf8_unicode_ci NOT NULL,
  `h3m22` varchar(40) COLLATE utf8_unicode_ci NOT NULL,
  `h3m21` varchar(40) COLLATE utf8_unicode_ci NOT NULL,
  `JuryEc` varchar(40) COLLATE utf8_unicode_ci NOT NULL,
  `TotEcritFinal` varchar(40) COLLATE utf8_unicode_ci NOT NULL,
  `h3m19` varchar(40) COLLATE utf8_unicode_ci NOT NULL,
  `h3m20` varchar(40) COLLATE utf8_unicode_ci NOT NULL,
  `h3m23` varchar(40) COLLATE utf8_unicode_ci NOT NULL,
  `h3m26` varchar(40) COLLATE utf8_unicode_ci NOT NULL,
  `h3m25` varchar(40) COLLATE utf8_unicode_ci NOT NULL,
  `TotOral` varchar(40) COLLATE utf8_unicode_ci NOT NULL,
  `JuryOr` varchar(40) COLLATE utf8_unicode_ci NOT NULL,
  `Total` varchar(40) COLLATE utf8_unicode_ci NOT NULL,
  `Resultat` varchar(40) COLLATE utf8_unicode_ci NOT NULL,
  `Degre` varchar(40) COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`NoDossier`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `h3f1`
--


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

--
-- Table structure for table `h3f2`
--

CREATE TABLE IF NOT EXISTS `h3f2` (
  `NoExamen` varchar(40) COLLATE utf8_unicode_ci NOT NULL,
  `NoDossier` varchar(40) COLLATE utf8_unicode_ci NOT NULL,
  `Nom` varchar(200) COLLATE utf8_unicode_ci NOT NULL,
  `h3m18` varchar(40) COLLATE utf8_unicode_ci NOT NULL,
  `h3m22` varchar(40) COLLATE utf8_unicode_ci NOT NULL,
  `h3m21` varchar(40) COLLATE utf8_unicode_ci NOT NULL,
  `JuryEc` varchar(40) COLLATE utf8_unicode_ci NOT NULL,
  `TotEcritFinal` varchar(40) COLLATE utf8_unicode_ci NOT NULL,
  `h3m19` varchar(40) COLLATE utf8_unicode_ci NOT NULL,
  `h3m20` varchar(40) COLLATE utf8_unicode_ci NOT NULL,
  `h3m23` varchar(40) COLLATE utf8_unicode_ci NOT NULL,
  `h3m26` varchar(40) COLLATE utf8_unicode_ci NOT NULL,
  `h3m25` varchar(40) COLLATE utf8_unicode_ci NOT NULL,
  `TotOral` varchar(40) COLLATE utf8_unicode_ci NOT NULL,
  `JuryOr` varchar(40) COLLATE utf8_unicode_ci NOT NULL,
  `Total` varchar(40) COLLATE utf8_unicode_ci NOT NULL,
  `Resultat` varchar(40) COLLATE utf8_unicode_ci NOT NULL,
  `Degre` varchar(40) COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`NoDossier`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `h3f2`
--


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

--
-- Table structure for table `h4f1`
--

CREATE TABLE IF NOT EXISTS `h4f1` (
  `NoExamen` varchar(40) COLLATE utf8_unicode_ci NOT NULL,
  `NoDossier` varchar(40) COLLATE utf8_unicode_ci NOT NULL,
  `Nom` varchar(200) COLLATE utf8_unicode_ci NOT NULL,
  `h4m19` varchar(40) COLLATE utf8_unicode_ci NOT NULL,
  `h4m23` varchar(40) COLLATE utf8_unicode_ci NOT NULL,
  `h4m25` varchar(40) COLLATE utf8_unicode_ci NOT NULL,
  `JuryEc` varchar(40) COLLATE utf8_unicode_ci NOT NULL,
  `TotEcritFinal` varchar(40) COLLATE utf8_unicode_ci NOT NULL,
  `h4m20` varchar(40) COLLATE utf8_unicode_ci NOT NULL,
  `h4m28` varchar(40) COLLATE utf8_unicode_ci NOT NULL,
  `h4m27` varchar(40) COLLATE utf8_unicode_ci NOT NULL,
  `h4m24` varchar(40) COLLATE utf8_unicode_ci NOT NULL,
  `h4m26` varchar(40) COLLATE utf8_unicode_ci NOT NULL,
  `TotOral` varchar(40) COLLATE utf8_unicode_ci NOT NULL,
  `JuryOr` varchar(40) COLLATE utf8_unicode_ci NOT NULL,
  `Total` varchar(40) COLLATE utf8_unicode_ci NOT NULL,
  `Resultat` varchar(40) COLLATE utf8_unicode_ci NOT NULL,
  `Degre` varchar(40) COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`NoDossier`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `h4f1`
--


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

--
-- Table structure for table `h4f2`
--

CREATE TABLE IF NOT EXISTS `h4f2` (
  `NoExamen` varchar(40) COLLATE utf8_unicode_ci NOT NULL,
  `NoDossier` varchar(40) COLLATE utf8_unicode_ci NOT NULL,
  `Nom` varchar(200) COLLATE utf8_unicode_ci NOT NULL,
  `h4m19` varchar(40) COLLATE utf8_unicode_ci NOT NULL,
  `h4m23` varchar(40) COLLATE utf8_unicode_ci NOT NULL,
  `h4m25` varchar(40) COLLATE utf8_unicode_ci NOT NULL,
  `JuryEc` varchar(40) COLLATE utf8_unicode_ci NOT NULL,
  `TotEcritFinal` varchar(40) COLLATE utf8_unicode_ci NOT NULL,
  `h4m20` varchar(40) COLLATE utf8_unicode_ci NOT NULL,
  `h4m28` varchar(40) COLLATE utf8_unicode_ci NOT NULL,
  `h4m27` varchar(40) COLLATE utf8_unicode_ci NOT NULL,
  `h4m24` varchar(40) COLLATE utf8_unicode_ci NOT NULL,
  `h4m26` varchar(40) COLLATE utf8_unicode_ci NOT NULL,
  `TotOral` varchar(40) COLLATE utf8_unicode_ci NOT NULL,
  `JuryOr` varchar(40) COLLATE utf8_unicode_ci NOT NULL,
  `Total` varchar(40) COLLATE utf8_unicode_ci NOT NULL,
  `Resultat` varchar(40) COLLATE utf8_unicode_ci NOT NULL,
  `Degre` varchar(40) COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`NoDossier`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `h4f2`
--


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

--
-- Table structure for table `s1f1`
--

CREATE TABLE IF NOT EXISTS `s1f1` (
  `NoExamen` varchar(40) COLLATE utf8_unicode_ci NOT NULL,
  `NoDossier` varchar(40) COLLATE utf8_unicode_ci NOT NULL,
  `Nom` varchar(200) COLLATE utf8_unicode_ci NOT NULL,
  `s1m18` varchar(40) COLLATE utf8_unicode_ci NOT NULL,
  `s1m22` varchar(40) COLLATE utf8_unicode_ci NOT NULL,
  `s1m23` varchar(40) COLLATE utf8_unicode_ci NOT NULL,
  `JuryEc` varchar(40) COLLATE utf8_unicode_ci NOT NULL,
  `TotEcritFinal` varchar(40) COLLATE utf8_unicode_ci NOT NULL,
  `s1m21` varchar(40) COLLATE utf8_unicode_ci NOT NULL,
  `s1m20` varchar(40) COLLATE utf8_unicode_ci NOT NULL,
  `s1m19` varchar(40) COLLATE utf8_unicode_ci NOT NULL,
  `s1m24` varchar(40) COLLATE utf8_unicode_ci NOT NULL,
  `TotOral` varchar(40) COLLATE utf8_unicode_ci NOT NULL,
  `JuryOr` varchar(40) COLLATE utf8_unicode_ci NOT NULL,
  `Total` varchar(40) COLLATE utf8_unicode_ci NOT NULL,
  `Resultat` varchar(40) COLLATE utf8_unicode_ci NOT NULL,
  `Degre` varchar(40) COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`NoDossier`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `s1f1`
--


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

--
-- Table structure for table `s1f2`
--

CREATE TABLE IF NOT EXISTS `s1f2` (
  `NoExamen` varchar(40) COLLATE utf8_unicode_ci NOT NULL,
  `NoDossier` varchar(40) COLLATE utf8_unicode_ci NOT NULL,
  `Nom` varchar(200) COLLATE utf8_unicode_ci NOT NULL,
  `s1m18` varchar(40) COLLATE utf8_unicode_ci NOT NULL,
  `s1m22` varchar(40) COLLATE utf8_unicode_ci NOT NULL,
  `s1m23` varchar(40) COLLATE utf8_unicode_ci NOT NULL,
  `JuryEc` varchar(40) COLLATE utf8_unicode_ci NOT NULL,
  `TotEcritFinal` varchar(40) COLLATE utf8_unicode_ci NOT NULL,
  `s1m21` varchar(40) COLLATE utf8_unicode_ci NOT NULL,
  `s1m20` varchar(40) COLLATE utf8_unicode_ci NOT NULL,
  `s1m19` varchar(40) COLLATE utf8_unicode_ci NOT NULL,
  `s1m24` varchar(40) COLLATE utf8_unicode_ci NOT NULL,
  `TotOral` varchar(40) COLLATE utf8_unicode_ci NOT NULL,
  `JuryOr` varchar(40) COLLATE utf8_unicode_ci NOT NULL,
  `Total` varchar(40) COLLATE utf8_unicode_ci NOT NULL,
  `Resultat` varchar(40) COLLATE utf8_unicode_ci NOT NULL,
  `Degre` varchar(40) COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`NoDossier`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `s1f2`
--


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

--
-- Table structure for table `s2f1`
--

CREATE TABLE IF NOT EXISTS `s2f1` (
  `NoExamen` varchar(40) COLLATE utf8_unicode_ci NOT NULL,
  `NoDossier` varchar(40) COLLATE utf8_unicode_ci NOT NULL,
  `Nom` varchar(200) COLLATE utf8_unicode_ci NOT NULL,
  `s2m27` varchar(40) COLLATE utf8_unicode_ci NOT NULL,
  `s2m30` varchar(40) COLLATE utf8_unicode_ci NOT NULL,
  `s2m28` varchar(40) COLLATE utf8_unicode_ci NOT NULL,
  `JuryEc` varchar(40) COLLATE utf8_unicode_ci NOT NULL,
  `TotEcritFinal` varchar(40) COLLATE utf8_unicode_ci NOT NULL,
  `s2m36` varchar(40) COLLATE utf8_unicode_ci NOT NULL,
  `s2m34` varchar(40) COLLATE utf8_unicode_ci NOT NULL,
  `s2m32` varchar(40) COLLATE utf8_unicode_ci NOT NULL,
  `s2m33` varchar(40) COLLATE utf8_unicode_ci NOT NULL,
  `TotOral` varchar(40) COLLATE utf8_unicode_ci NOT NULL,
  `JuryOr` varchar(40) COLLATE utf8_unicode_ci NOT NULL,
  `Total` varchar(40) COLLATE utf8_unicode_ci NOT NULL,
  `Resultat` varchar(40) COLLATE utf8_unicode_ci NOT NULL,
  `Degre` varchar(40) COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`NoDossier`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `s2f1`
--


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

--
-- Table structure for table `s2f2`
--

CREATE TABLE IF NOT EXISTS `s2f2` (
  `NoExamen` varchar(40) COLLATE utf8_unicode_ci NOT NULL,
  `NoDossier` varchar(40) COLLATE utf8_unicode_ci NOT NULL,
  `Nom` varchar(200) COLLATE utf8_unicode_ci NOT NULL,
  `s2m27` varchar(40) COLLATE utf8_unicode_ci NOT NULL,
  `s2m30` varchar(40) COLLATE utf8_unicode_ci NOT NULL,
  `s2m28` varchar(40) COLLATE utf8_unicode_ci NOT NULL,
  `JuryEc` varchar(40) COLLATE utf8_unicode_ci NOT NULL,
  `TotEcritFinal` varchar(40) COLLATE utf8_unicode_ci NOT NULL,
  `s2m36` varchar(40) COLLATE utf8_unicode_ci NOT NULL,
  `s2m34` varchar(40) COLLATE utf8_unicode_ci NOT NULL,
  `s2m32` varchar(40) COLLATE utf8_unicode_ci NOT NULL,
  `s2m33` varchar(40) COLLATE utf8_unicode_ci NOT NULL,
  `TotOral` varchar(40) COLLATE utf8_unicode_ci NOT NULL,
  `JuryOr` varchar(40) COLLATE utf8_unicode_ci NOT NULL,
  `Total` varchar(40) COLLATE utf8_unicode_ci NOT NULL,
  `Resultat` varchar(40) COLLATE utf8_unicode_ci NOT NULL,
  `Degre` varchar(40) COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`NoDossier`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `s2f2`
--


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

--
-- Table structure for table `s3f1`
--

CREATE TABLE IF NOT EXISTS `s3f1` (
  `NoExamen` varchar(40) COLLATE utf8_unicode_ci NOT NULL,
  `NoDossier` varchar(40) COLLATE utf8_unicode_ci NOT NULL,
  `Nom` varchar(200) COLLATE utf8_unicode_ci NOT NULL,
  `s3m24` varchar(40) COLLATE utf8_unicode_ci NOT NULL,
  `s3m25` varchar(40) COLLATE utf8_unicode_ci NOT NULL,
  `s3m30` varchar(40) COLLATE utf8_unicode_ci NOT NULL,
  `JuryEc` varchar(40) COLLATE utf8_unicode_ci NOT NULL,
  `TotEcritFinal` varchar(40) COLLATE utf8_unicode_ci NOT NULL,
  `s3m27` varchar(40) COLLATE utf8_unicode_ci NOT NULL,
  `s3m28` varchar(40) COLLATE utf8_unicode_ci NOT NULL,
  `s3m29` varchar(40) COLLATE utf8_unicode_ci NOT NULL,
  `s3m26` varchar(40) COLLATE utf8_unicode_ci NOT NULL,
  `s3m31` varchar(40) COLLATE utf8_unicode_ci NOT NULL,
  `TotOral` varchar(40) COLLATE utf8_unicode_ci NOT NULL,
  `JuryOr` varchar(40) COLLATE utf8_unicode_ci NOT NULL,
  `Total` varchar(40) COLLATE utf8_unicode_ci NOT NULL,
  `Resultat` varchar(40) COLLATE utf8_unicode_ci NOT NULL,
  `Degre` varchar(40) COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`NoDossier`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `s3f1`
--


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

--
-- Table structure for table `s3f2`
--

CREATE TABLE IF NOT EXISTS `s3f2` (
  `NoExamen` varchar(40) COLLATE utf8_unicode_ci NOT NULL,
  `NoDossier` varchar(40) COLLATE utf8_unicode_ci NOT NULL,
  `Nom` varchar(200) COLLATE utf8_unicode_ci NOT NULL,
  `s3m24` varchar(40) COLLATE utf8_unicode_ci NOT NULL,
  `s3m25` varchar(40) COLLATE utf8_unicode_ci NOT NULL,
  `s3m30` varchar(40) COLLATE utf8_unicode_ci NOT NULL,
  `JuryEc` varchar(40) COLLATE utf8_unicode_ci NOT NULL,
  `TotEcritFinal` varchar(40) COLLATE utf8_unicode_ci NOT NULL,
  `s3m27` varchar(40) COLLATE utf8_unicode_ci NOT NULL,
  `s3m28` varchar(40) COLLATE utf8_unicode_ci NOT NULL,
  `s3m29` varchar(40) COLLATE utf8_unicode_ci NOT NULL,
  `s3m26` varchar(40) COLLATE utf8_unicode_ci NOT NULL,
  `s3m31` varchar(40) COLLATE utf8_unicode_ci NOT NULL,
  `TotOral` varchar(40) COLLATE utf8_unicode_ci NOT NULL,
  `JuryOr` varchar(40) COLLATE utf8_unicode_ci NOT NULL,
  `Total` varchar(40) COLLATE utf8_unicode_ci NOT NULL,
  `Resultat` varchar(40) COLLATE utf8_unicode_ci NOT NULL,
  `Degre` varchar(40) COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`NoDossier`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `s3f2`
--


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

--
-- Table structure for table `s4f1`
--

CREATE TABLE IF NOT EXISTS `s4f1` (
  `NoExamen` varchar(40) COLLATE utf8_unicode_ci NOT NULL,
  `NoDossier` varchar(40) COLLATE utf8_unicode_ci NOT NULL,
  `Nom` varchar(200) COLLATE utf8_unicode_ci NOT NULL,
  `s4m20` varchar(40) COLLATE utf8_unicode_ci NOT NULL,
  `s4m21` varchar(40) COLLATE utf8_unicode_ci NOT NULL,
  `s4m29` varchar(40) COLLATE utf8_unicode_ci NOT NULL,
  `JuryEc` varchar(40) COLLATE utf8_unicode_ci NOT NULL,
  `TotEcritFinal` varchar(40) COLLATE utf8_unicode_ci NOT NULL,
  `s4m25` varchar(40) COLLATE utf8_unicode_ci NOT NULL,
  `s4m28` varchar(40) COLLATE utf8_unicode_ci NOT NULL,
  `s4m24` varchar(40) COLLATE utf8_unicode_ci NOT NULL,
  `s4m26` varchar(40) COLLATE utf8_unicode_ci NOT NULL,
  `s4m27` varchar(40) COLLATE utf8_unicode_ci NOT NULL,
  `TotOral` varchar(40) COLLATE utf8_unicode_ci NOT NULL,
  `JuryOr` varchar(40) COLLATE utf8_unicode_ci NOT NULL,
  `Total` varchar(40) COLLATE utf8_unicode_ci NOT NULL,
  `Resultat` varchar(40) COLLATE utf8_unicode_ci NOT NULL,
  `Degre` varchar(40) COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`NoDossier`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `s4f1`
--


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

--
-- Table structure for table `s4f2`
--

CREATE TABLE IF NOT EXISTS `s4f2` (
  `NoExamen` varchar(40) COLLATE utf8_unicode_ci NOT NULL,
  `NoDossier` varchar(40) COLLATE utf8_unicode_ci NOT NULL,
  `Nom` varchar(200) COLLATE utf8_unicode_ci NOT NULL,
  `s4m20` varchar(40) COLLATE utf8_unicode_ci NOT NULL,
  `s4m21` varchar(40) COLLATE utf8_unicode_ci NOT NULL,
  `s4m29` varchar(40) COLLATE utf8_unicode_ci NOT NULL,
  `JuryEc` varchar(40) COLLATE utf8_unicode_ci NOT NULL,
  `TotEcritFinal` varchar(40) COLLATE utf8_unicode_ci NOT NULL,
  `s4m25` varchar(40) COLLATE utf8_unicode_ci NOT NULL,
  `s4m28` varchar(40) COLLATE utf8_unicode_ci NOT NULL,
  `s4m24` varchar(40) COLLATE utf8_unicode_ci NOT NULL,
  `s4m26` varchar(40) COLLATE utf8_unicode_ci NOT NULL,
  `s4m27` varchar(40) COLLATE utf8_unicode_ci NOT NULL,
  `TotOral` varchar(40) COLLATE utf8_unicode_ci NOT NULL,
  `JuryOr` varchar(40) COLLATE utf8_unicode_ci NOT NULL,
  `Total` varchar(40) COLLATE utf8_unicode_ci NOT NULL,
  `Resultat` varchar(40) COLLATE utf8_unicode_ci NOT NULL,
  `Degre` varchar(40) COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`NoDossier`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `s4f2`
--


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

--
-- Table structure for table `titre`
--

CREATE TABLE IF NOT EXISTS `titre` (
  `IDtitre` varchar(40) NOT NULL,
  `AFFICHEtitre` varchar(200) NOT NULL,
  `TITRE` varchar(50) NOT NULL,
  `NOTEeliminatoire` varchar(40) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `titre`
--


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

--
-- Table structure for table `yearfieldnames`
--

CREATE TABLE IF NOT EXISTS `yearfieldnames` (
  `annee` varchar(15) COLLATE utf8_unicode_ci NOT NULL,
  `i1` varchar(15) COLLATE utf8_unicode_ci NOT NULL,
  `i2` varchar(15) COLLATE utf8_unicode_ci NOT NULL,
  `i3` varchar(5) COLLATE utf8_unicode_ci NOT NULL,
  `i4` varchar(20) COLLATE utf8_unicode_ci NOT NULL,
  `i5` varchar(20) COLLATE utf8_unicode_ci NOT NULL,
  `i6` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL,
  `i7` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL,
  `i8` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL,
  `i9` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL,
  `i10` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL,
  `i11` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL,
  `i12` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL,
  `i13` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL,
  `i14` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL,
  `i15` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL,
  `i16` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL,
  `i17` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL,
  `i18` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL,
  `i19` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL,
  `i20` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL,
  `i21` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL,
  `i22` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL,
  `i23` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL,
  `i24` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`annee`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `yearfieldnames`
--

