-- phpMyAdmin SQL Dump
-- version 4.1.11
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Apr 24, 2015 at 11:47 AM
-- Server version: 5.6.17
-- PHP Version: 5.4.27

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

--
-- Database: `etugpe`
--

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

--
-- Table structure for table `etudiant`
--

CREATE TABLE IF NOT EXISTS `etudiant` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `nom` varchar(32) NOT NULL,
  `prenom` varchar(32) NOT NULL,
  `age` int(11) DEFAULT '0',
  `adresse` varchar(256) DEFAULT NULL,
  `ville` varchar(64) DEFAULT NULL,
  `code_postal` varchar(6) DEFAULT NULL,
  `mail` varchar(128) DEFAULT NULL,
  `telephone` varchar(16) DEFAULT NULL,
  `date_insc` date DEFAULT NULL,
  `moyenne` decimal(6,2) DEFAULT NULL,
  `id_gpe` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=7 ;

--
-- Dumping data for table `etudiant`
--

INSERT INTO `etudiant` (`id`, `nom`, `prenom`, `age`, `adresse`, `ville`, `code_postal`, `mail`, `telephone`, `date_insc`, `moyenne`, `id_gpe`) VALUES
(1, 'BOND', 'James', 27, '23 rue de la côte qui monte', 'Paris', '75000', 'james.bond.007@gmal.com', '06007', '2015-04-01', '20.00', 1),
(2, 'Balboa', 'Rocky', 23, '23 rue de la côte qui descend', 'Philadelphia', '19149', 'rocky.balboa@boxing.net', '00123456789', '2015-04-02', '6.45', 1),
(3, 'Einstein', 'Albert', 15, '32 rue de la côte en pente', 'Berne', '3003', 'bebert.0515@relative.org', '0619051521', '2015-04-03', '16.50', 1),
(4, 'Tarly', 'Samwell', 22, '12, le mur', 'Nord-city', '01345', 'sam.tarly@mur.net', '01000234', '2015-04-09', '9.99', 2),
(5, 'Snow', 'Jon', 26, '12bis, le mur', 'Nord-City   ', '01345', 'jon.snow54@mur.net', '01000128', '2015-04-10', '15.25', 2),
(6, 'Stark', 'Arya', 12, '1, chateau de winterfell', 'wintercity', '01666', 'ary.stark@westmail.com', '01345566549999', '2015-04-02', '18.33', 2);

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

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

CREATE TABLE IF NOT EXISTS `groupe` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `code_grpe` varchar(16) NOT NULL,
  `ref_formation` varchar(32) NOT NULL,
  `no_semestre` int(11) NOT NULL,
  `nb_membres` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=8 ;

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

INSERT INTO `groupe` (`id`, `code_grpe`, `ref_formation`, `no_semestre`, `nb_membres`) VALUES
(1, 'S1A', 'X23.DUT-INF', 1, NULL),
(2, 'S1B', 'X23.DUT-INF', 1, NULL),
(3, 'S1C', 'X23.DUT-INF', 1, NULL),
(4, 'S1C', 'X23.DUT-INF', 1, NULL),
(5, 'S1C', 'X23.DUT-INF', 1, NULL),
(6, 'S1C', 'X23.DUT-INF', 1, NULL),
(7, 'S1C', 'X23.DUT-INF', 1, NULL);

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