-- phpMyAdmin SQL Dump
-- version 4.2.12
-- http://www.phpmyadmin.net
--
-- Client :  localhost
-- Généré le :  Dim 27 Mars 2016 à 16:40
-- Version du serveur :  5.6.21
-- Version de PHP :  7.0.2

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 :  `CoursPHP`
--

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

--
-- Structure de la table `identification_clients`
--

CREATE TABLE IF NOT EXISTS `identification_clients` (
`ID` int(10) unsigned NOT NULL,
  `Login` varchar(10) NOT NULL,
  `MotdePasse` varchar(50) NOT NULL,
  `ID_Clt` int(10) unsigned NOT NULL
) ENGINE=InnoDB AUTO_INCREMENT=18 DEFAULT CHARSET=utf8;

--
-- Contenu de la table `identification_clients`
--

INSERT INTO `identification_clients` (`ID`, `Login`, `MotdePasse`, `ID_Clt`) VALUES
(1, 'dupontje', '*444982C909BCC73A65A4E6CBE7DA19191EDC7621', 1),
(2, 'jacqueje', '*01E5AB5BB4690DF950823079776525408FDF143A', 2),
(3, 'murciaca', '*2B42FC0DB092BF79CB8050B2392EC22F5FEBEBAC', 3),
(4, 'leryje', '*70828A978420F0614DEBA7174BF3808354E431DF', 4),
(5, 'delaruje', '*A8060574241516300A2B15400D006295ECDFE710', 5),
(6, 'martinpa', '*B95D965DE4E050AF1DBB944C091B0C8E528E23D9', 6),
(7, 'martinpi', '*4B21262AF3D0328DE0DCFAD57058A946D4E95705', 7),
(8, 'jacquefr', '*976FBEF6D0BC996772CDB8608596D2815D10BC9A', 8),
(9, 'jacquela', '*68C48AFBA0133670B10E0EC4E8FA253495D1D655', 9),
(10, 'dumoulje', '*55D5BA3821979B350F83A0CEDE4A5F29211B54F1', 10),
(11, 'labonnol', '*27119B75EFB31E18CA6A1D06DD252143E21C5A40', 11),
(12, 'delafoje', '*7B049A043EC0DF8346812BEB2A5D6C74121D56CA', 12),
(13, 'levysa', '*4D552B2A95D75C17AD99E3E05AC6B075934844A8', 13),
(14, 'delarula', '*0AB8103E6C02C61A8D349EB6A0FC7B7CA0262392', 14),
(15, 'dupontjea', '*808A6159FCE9549667B4B69FC16B296E1C7B5881', 15),
(16, 'martinal', '*280529F24FA10BE74E8600031A950F997B4FE835', 16),
(17, 'rousseja', '*1BEC6234827272BD5D0EDEBD67DEADEB5811B543', 17);

--
-- Index pour les tables exportées
--

--
-- Index pour la table `identification_clients`
--
ALTER TABLE `identification_clients`
 ADD PRIMARY KEY (`ID`), ADD UNIQUE KEY `Login` (`Login`,`ID_Clt`);

--
-- AUTO_INCREMENT pour les tables exportées
--

--
-- AUTO_INCREMENT pour la table `identification_clients`
--
ALTER TABLE `identification_clients`
MODIFY `ID` int(10) unsigned NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=18;
/*!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 */;
