-- phpMyAdmin SQL Dump
-- version 4.8.5
-- https://www.phpmyadmin.net/
--
-- Host: localhost:8889
-- Generation Time: Jul 18, 2019 at 07:09 PM
-- Server version: 5.7.25
-- PHP Version: 7.3.1

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";

--
-- Database: `coiffure`
--

--
-- Table structure for table `coiffeurs`
--

CREATE TABLE `coiffeurs` (
  `id` int(11) NOT NULL,
  `nom` varchar(50) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `coiffeurs`
--

INSERT INTO `coiffeurs` (`id`, `nom`) VALUES
(6, 'Frank'),
(9, 'Lulu'),
(10, 'Sebastien'),
(12, 'Toto'),
(13, 'Floriane');

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

--
-- Table structure for table `reservation`
--

CREATE TABLE `reservation` (
  `id` int(10) NOT NULL,
  `dateResa` date NOT NULL,
  `id-client` int(10) DEFAULT NULL,
  `id-prestation` int(10) DEFAULT NULL,
  `id_coiffeur` int(10) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `reservation`
--

INSERT INTO `reservation` (`id`, `dateResa`, `id-client`, `id-prestation`, `id_coiffeur`) VALUES
(2, '2019-07-19', NULL, NULL, 9),
(3, '2019-07-19', NULL, NULL, 6),
(4, '2019-07-19', NULL, NULL, 13),
(5, '2019-07-20', NULL, NULL, 9);

--
-- Indexes for dumped tables
--

--
-- Indexes for table `coiffeurs`
--
ALTER TABLE `coiffeurs`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `reservation`
--
ALTER TABLE `reservation`
  ADD PRIMARY KEY (`id`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `coiffeurs`
--
ALTER TABLE `coiffeurs`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=14;

--
-- AUTO_INCREMENT for table `reservation`
--
ALTER TABLE `reservation`
  MODIFY `id` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;
