-- Mellah Mouloud
-- 
-- phpMyAdmin SQL Dump
-- version 4.1.4
-- http://www.phpmyadmin.net
--
-- Client :  127.0.0.1
-- Généré le :  Jeu 28 Novembre 2019 à 15:29
-- 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 :  `gtr2020`
--

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

--
-- Structure de la table `bultein`
--

CREATE TABLE IF NOT EXISTS `bultein` (
  `numb` int(3) NOT NULL,
  `dateb` date NOT NULL,
  `matricule` int(12) NOT NULL,
  PRIMARY KEY (`numb`),
  KEY `matricule` (`matricule`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Structure de la table `enfenf`
--

CREATE TABLE IF NOT EXISTS `enfenf` (
  `numb` int(3) NOT NULL,
  `numm` int(2) NOT NULL,
  KEY `numb` (`numb`,`numm`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- 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;

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

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

CREATE TABLE IF NOT EXISTS `module` (
  `numm` int(2) NOT NULL,
  `libeltin` int(20) NOT NULL,
  `coef` int(1) NOT NULL,
  `credit` int(1) NOT NULL,
  PRIMARY KEY (`numm`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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