-- Airouche
-- 
-- phpMyAdmin SQL Dump
-- version 4.1.4
-- http://www.phpmyadmin.net
--
-- Client :  127.0.0.1
-- Généré le :  Jeu 28 Novembre 2019 à 10:44
-- Version du serveur :  5.6.15-log
-- Version de PHP :  5.4.24

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
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 utf8 */;

--
-- Base de données :  `g12020`
--

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

--
-- Structure de la table `bulletin`
--

CREATE TABLE IF NOT EXISTS `bulletin` (
  `numB` int(3) NOT NULL,
  `dateB` date NOT NULL,
  `matricule` varchar(12) NOT NULL,
  PRIMARY KEY (`numB`),
  KEY `matricule` (`matricule`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Contenu de la table `bulletin`
--

INSERT INTO `bulletin` (`numB`, `dateB`, `matricule`) VALUES
(1, '2019-11-25', '171731087970'),
(3, '2013-02-22', '171731084970');

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

--
-- Structure de la table `detail`
--

CREATE TABLE IF NOT EXISTS `detail` (
  `numB` int(3) NOT NULL,
  `nomM` int(2) NOT NULL,
  KEY `numB` (`numB`,`nomM`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Contenu de la table `detail`
--

INSERT INTO `detail` (`numB`, `nomM`) VALUES
(1, 1),
(3, 1),
(3, 2);

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

--
-- Structure de la table `etudiant`
--

CREATE TABLE IF NOT EXISTS `etudiant` (
  `matricule` varchar(12) NOT NULL,
  `nom` varchar(20) NOT NULL,
  `adresse` varchar(40) NOT NULL,
  PRIMARY KEY (`matricule`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Contenu de la table `etudiant`
--

INSERT INTO `etudiant` (`matricule`, `nom`, `adresse`) VALUES
('171731087970', 'Airouche', 'Akbou'),
('171731084970', 'Silem', 'Bouira');

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

--
-- Structure de la table `module`
--

CREATE TABLE IF NOT EXISTS `module` (
  `numM` int(2) NOT NULL,
  `libelleM` varchar(20) NOT NULL,
  `coeff` int(1) NOT NULL,
  `credit` int(1) NOT NULL,
  PRIMARY KEY (`numM`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Contenu de la table `module`
--

INSERT INTO `module` (`numM`, `libelleM`, `coeff`, `credit`) VALUES
(1, 'ProgWEB', 3, 6),
(2, 'TICT', 3, 4),
(3, 'Anglais', 1, 1);

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