sql.sql

-- phpMyAdmin SQL Dump
-- version 4.6.6deb5
-- https://www.phpmyadmin.net/
--
-- Client :  localhost:3306
-- Généré le :  Mer 10 Octobre 2018 à 10:16
-- Version du serveur :  5.7.23-0ubuntu0.18.04.1
-- Version de PHP :  7.2.10-0ubuntu0.18.04.1

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

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

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

--
-- Structure de la table `lb_clients`
--

CREATE TABLE `lb_clients` (
  `id_cli` int(2) NOT NULL,
  `nom_cli` varchar(20) NOT NULL,
  `prenom_cli` varchar(30) NOT NULL,
  `reg_cli` varchar(20) NOT NULL,
  `classe_cli` varchar(15) NOT NULL,
  `lun_cli` int(1) NOT NULL,
  `mar_cli` int(1) NOT NULL,
  `merc_cli` int(1) NOT NULL,
  `jeu_cli` int(1) NOT NULL,
  `ven_cli` int(1) NOT NULL,
  `solde_cli` int(5) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Contenu de la table `lb_clients`
--

INSERT INTO `lb_clients` (`id_cli`, `nom_cli`, `prenom_cli`, `reg_cli`, `classe_cli`, `lun_cli`, `mar_cli`, `merc_cli`, `jeu_cli`, `ven_cli`, `solde_cli`) VALUES
(411001, 'Chaud', 'François-Emile', '2', 'TS2SIO', 1, 1, 1, 1, 1, -10),
(411002, 'Norris', 'Chuck', '3', 'TS2SIO', 1, 0, 1, 0, 0, 58),
(411003, 'Robuchon', 'Joël', '3', 'TS2SIO', 0, 0, 0, 0, 0, 792),
(411004, 'Durand', 'Jeanne', '1', 'TS1ASG', 0, 0, 0, 0, 0, 224),
(411005, 'Dupont', 'Bertrand', '2', 'TL1', 0, 0, 0, 0, 0, 37),
(411006, 'Dupuis', 'Jean-Luc', '4', '', 0, 0, 0, 0, 0, 1497),
(411007, 'Fort', 'Juliette', '1', 'TL2', 0, 0, 0, 0, 0, 360),
(411008, 'Lahaye', 'Brigitte', '1', 'TS1TOUR', 0, 0, 0, 0, 0, 702),
(411009, 'Belhani', 'Saoud', '2', 'TS1SIO', 1, 1, 1, 1, 1, 152);

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

--
-- Structure de la table `lb_connect`
--

CREATE TABLE `lb_connect` (
  `id_connect` int(11) NOT NULL,
  `nom_connect` varchar(30) NOT NULL,
  `prenom_connect` varchar(30) NOT NULL,
  `type_connect` varchar(30) NOT NULL,
  `log_connect` varchar(30) NOT NULL,
  `mdp_connect` varchar(30) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Contenu de la table `lb_connect`
--

INSERT INTO `lb_connect` (`id_connect`, `nom_connect`, `prenom_connect`, `type_connect`, `log_connect`, `mdp_connect`) VALUES
(1, 'Sageau', 'Pierre', 'superadmin', 'superadmin', 'superadmin'),
(2, 'Comptable', 'Comptable', 'comptabilite', 'compta', 'compta'),
(3, 'Surveillant', 'Surveillant', 'surveillant', 'surveillant', 'surveillant');

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

--
-- Structure de la table `lb_credit`
--

CREATE TABLE `lb_credit` (
  `id_cred` int(2) NOT NULL,
  `date_cred` date NOT NULL,
  `montant_cred` int(5) NOT NULL,
  `type_cred` int(1) NOT NULL,
  `id_cli` int(2) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Contenu de la table `lb_credit`
--

INSERT INTO `lb_credit` (`id_cred`, `date_cred`, `montant_cred`, `type_cred`, `id_cli`) VALUES
(1, '2015-04-16', 15, 1, 411001),
(2, '2015-04-16', 150, 2, 411002),
(3, '2015-05-19', 50, 1, 411009),
(4, '2015-05-26', 100, 1, 411009),
(5, '2016-01-20', 45, 1, 411005),
(6, '2018-08-09', 55, 2, 411002);

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

--
-- Structure de la table `lb_passage`
--

CREATE TABLE `lb_passage` (
  `id_passage` int(2) NOT NULL,
  `date_passage` date NOT NULL,
  `serv_passage` varchar(10) NOT NULL,
  `mont_repas` int(2) NOT NULL,
  `id_repas` int(2) NOT NULL,
  `id_client` int(2) NOT NULL,
  `note` varchar(2) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Contenu de la table `lb_passage`
--

INSERT INTO `lb_passage` (`id_passage`, `date_passage`, `serv_passage`, `mont_repas`, `id_repas`, `id_client`, `note`) VALUES
(2, '2015-05-19', 'Midi', 8, 0, 411006, ''),
(3, '2015-05-19', 'Midi', 8, 0, 411001, ''),
(4, '2015-05-19', 'Midi', 8, 0, 411008, ''),
(5, '2015-05-19', 'Midi', 8, 0, 411008, ''),
(6, '2015-05-19', 'Midi', 8, 0, 411008, ''),
(7, '2015-06-01', 'Midi', 8, 0, 411003, '6'),
(8, '2015-06-01', 'Midi', 8, 0, 411005, '4'),
(9, '2015-06-30', 'Soir', 24, 0, 411008, ''),
(10, '2016-01-20', 'Soir', 5, 0, 411005, ''),
(11, '2016-01-20', 'Soir', 5, 0, 411005, ''),
(12, '2016-07-22', 'Midi', 0, 0, 411001, ''),
(13, '2016-07-22', 'Midi', 5, 0, 411001, ''),
(14, '2018-08-09', 'Soir', 5, 0, 411002, '');

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

--
-- Structure de la table `lb_regime`
--

CREATE TABLE `lb_regime` (
  `id_regime` int(2) NOT NULL,
  `nom_regime` varchar(20) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Contenu de la table `lb_regime`
--

INSERT INTO `lb_regime` (`id_regime`, `nom_regime`) VALUES
(1, 'externe'),
(2, 'interne'),
(3, 'demi-pensionnaire'),
(4, 'personnel');

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

--
-- Structure de la table `lb_repas`
--

CREATE TABLE `lb_repas` (
  `id_repas` int(2) NOT NULL,
  `lib_repas` varchar(40) NOT NULL,
  `tarif_repas` int(5) NOT NULL,
  `valide_repas` varchar(3) NOT NULL DEFAULT 'oui'
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Contenu de la table `lb_repas`
--

INSERT INTO `lb_repas` (`id_repas`, `lib_repas`, `tarif_repas`, `valide_repas`) VALUES
(1, 'Repas', 5, 'oui'),
(2, 'cafe', 2, 'non'),
(3, 'Petit Dejeuner', 4, 'oui');

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

--
-- Structure de la table `lb_service`
--

CREATE TABLE `lb_service` (
  `id_service` int(1) NOT NULL,
  `nom_service` varchar(15) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Contenu de la table `lb_service`
--

INSERT INTO `lb_service` (`id_service`, `nom_service`) VALUES
(1, 'Matin'),
(2, 'Midi'),
(3, 'Soir');

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

--
-- Structure de la table `lb_typereglement`
--

CREATE TABLE `lb_typereglement` (
  `id_typereglement` int(1) NOT NULL,
  `libelle_typereglement` varchar(15) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Contenu de la table `lb_typereglement`
--

INSERT INTO `lb_typereglement` (`id_typereglement`, `libelle_typereglement`) VALUES
(1, 'Espèce'),
(2, 'Chèque');

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

--
-- Index pour la table `lb_clients`
--
ALTER TABLE `lb_clients`
  ADD PRIMARY KEY (`id_cli`);

--
-- Index pour la table `lb_connect`
--
ALTER TABLE `lb_connect`
  ADD PRIMARY KEY (`id_connect`);

--
-- Index pour la table `lb_credit`
--
ALTER TABLE `lb_credit`
  ADD PRIMARY KEY (`id_cred`);

--
-- Index pour la table `lb_passage`
--
ALTER TABLE `lb_passage`
  ADD PRIMARY KEY (`id_passage`);

--
-- Index pour la table `lb_repas`
--
ALTER TABLE `lb_repas`
  ADD PRIMARY KEY (`id_repas`);

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

--
-- AUTO_INCREMENT pour la table `lb_clients`
--
ALTER TABLE `lb_clients`
  MODIFY `id_cli` int(2) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=411010;
--
-- AUTO_INCREMENT pour la table `lb_connect`
--
ALTER TABLE `lb_connect`
  MODIFY `id_connect` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;
--
-- AUTO_INCREMENT pour la table `lb_credit`
--
ALTER TABLE `lb_credit`
  MODIFY `id_cred` int(2) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;
--
-- AUTO_INCREMENT pour la table `lb_passage`
--
ALTER TABLE `lb_passage`
  MODIFY `id_passage` int(2) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=15;
/*!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 */;