-- 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: `resultats91-92` -- -- -------------------------------------------------------- -- -- 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` --