-- phpMyAdmin SQL Dump
-- version 4.6.4
-- https://www.phpmyadmin.net/
--
-- Client :  127.0.0.1
-- Généré le :  Ven 21 Avril 2017 à 13:22
-- Version du serveur :  5.7.14
-- Version de PHP :  5.6.25

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

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

--
-- Structure de la table `category`
--

CREATE TABLE `category` (
  `id_category` int(11) NOT NULL,
  `name_category` varchar(30) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Contenu de la table `category`
--

INSERT INTO `category` (`id_category`, `name_category`) VALUES
(1, 'Paninis'),
(2, 'Tortillas'),
(3, 'Hamburgers'),
(4, 'Pâtes'),
(5, 'Sandwichs'),
(6, 'Salades'),
(7, 'Desserts'),
(8, 'Boissons'),
(9, 'Boissons Chaudes'),
(10, 'Viennoiseries');

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

--
-- Structure de la table `products`
--

CREATE TABLE `products` (
  `id_product` int(11) NOT NULL,
  `name` varchar(30) NOT NULL,
  `price` float NOT NULL,
  `stock` int(11) NOT NULL,
  `category` int(11) NOT NULL,
  `add_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `up_date` timestamp NULL DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Contenu de la table `products`
--

INSERT INTO `products` (`id_product`, `name`, `price`, `stock`, `category`, `add_date`, `up_date`) VALUES
(1, 'Mozza', 3, 0, 1, '2017-03-05 17:42:51', NULL),
(2, 'Bacon', 3.5, 0, 1, '2017-03-05 17:44:44', NULL),
(3, 'Jambon', 3.5, 0, 1, '2017-03-05 17:45:19', NULL),
(4, 'Poulet', 3.5, 0, 1, '2017-03-05 17:45:40', NULL),
(5, 'Thon', 3.5, 0, 1, '2017-03-05 17:45:57', NULL),
(6, 'Saumon', 4, 0, 1, '2017-03-05 17:46:13', NULL),
(7, 'Serrano', 4, 0, 1, '2017-03-05 17:47:01', NULL),
(8, 'Burger', 4, 0, 1, '2017-03-05 17:47:21', NULL),
(9, 'Nutella', 3, 0, 1, '2017-03-05 17:47:34', NULL),
(10, 'Poulet', 3.5, 0, 2, '2017-03-05 17:47:52', NULL),
(11, 'Thon', 3.5, 0, 2, '2017-03-05 17:49:34', NULL),
(12, 'Burger', 4, 0, 2, '2017-03-05 17:49:51', NULL),
(13, 'Classic', 4, 0, 3, '2017-03-05 17:52:35', NULL),
(14, 'Cheeseburger', 5, 0, 3, '2017-03-05 17:53:04', NULL),
(15, 'Baconburger', 5.5, 0, 3, '2017-03-05 17:53:18', NULL),
(16, 'Carbonara', 4, 0, 4, '2017-03-05 17:53:38', NULL),
(17, 'Bolognaise', 4, 0, 4, '2017-03-05 17:53:55', NULL),
(18, 'Lasagnes', 4.2, 0, 4, '2017-03-05 17:54:26', NULL),
(19, 'Jambon Beurre', 3.1, 0, 5, '2017-03-05 17:54:50', NULL),
(20, 'Jambon Fromage', 3.3, 0, 5, '2017-03-05 17:55:08', NULL),
(21, 'Jambon Crudites', 3.5, 0, 5, '2017-03-05 17:55:38', NULL),
(22, 'Poulet Crudites', 3.5, 0, 5, '2017-03-05 17:56:03', NULL),
(23, 'Thon Crudites', 3.5, 0, 5, '2017-03-05 17:56:22', NULL),
(24, 'Saumon Crudites', 4.5, 0, 5, '2017-03-05 17:56:40', NULL),
(25, 'Mozzarella', 3.5, 0, 6, '2017-03-05 17:58:21', NULL),
(26, 'Thon', 3.5, 0, 6, '2017-03-05 17:58:42', NULL),
(27, 'Saumon', 4, 0, 6, '2017-03-05 17:58:58', NULL),
(28, 'Jambon', 4, 0, 6, '2017-03-05 17:59:10', NULL),
(29, 'Poulet', 4, 0, 6, '2017-03-05 18:01:23', NULL),
(30, 'Yaourt', 1, 0, 7, '2017-03-05 18:01:41', NULL),
(31, 'Fromage Blanc', 1.5, 0, 7, '2017-03-05 18:02:31', NULL),
(32, 'Brownie', 1.6, 0, 7, '2017-03-05 18:02:51', NULL),
(33, 'Cookie', 1.7, 0, 7, '2017-03-05 18:03:10', NULL),
(34, 'Salade de Fruits', 2, 0, 7, '2017-03-05 18:03:42', NULL),
(35, 'Tarte du Jour', 2, 0, 7, '2017-03-05 18:03:56', NULL),
(36, 'Coca Cola', 1, 0, 8, '2017-03-14 21:38:17', NULL),
(37, 'Fanta', 1, 0, 8, '2017-03-14 21:38:31', NULL),
(38, 'Sprite', 1, 0, 8, '2017-03-14 21:38:35', NULL),
(39, 'Ice Tea', 1, 0, 8, '2017-03-14 21:38:47', NULL),
(40, 'Jus d\'orange', 1, 0, 8, '2017-03-14 21:39:43', NULL),
(41, 'Jus de pomme', 1, 0, 8, '2017-03-14 21:39:57', NULL),
(42, 'Évian', 1, 0, 8, '2017-03-14 21:40:03', NULL),
(43, 'Café', 1, 0, 9, '2017-03-14 21:41:05', NULL),
(44, 'Chocolat chaud', 1, 0, 9, '2017-03-14 21:41:20', NULL),
(45, 'Croissant', 1, 0, 10, '2017-03-14 21:41:40', NULL),
(46, 'Pain au chocolat', 1, 0, 10, '2017-03-14 21:41:47', NULL);

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

--
-- Structure de la table `users`
--

CREATE TABLE `users` (
  `id_user` int(11) NOT NULL,
  `user` varchar(30) NOT NULL,
  `pwd` char(60) NOT NULL,
  `email` varchar(75) NOT NULL,
  `school` varchar(6) NOT NULL,
  `money_balance` float DEFAULT '0',
  `fidelity_point` int(11) NOT NULL DEFAULT '0',
  `admin_user` tinyint(1) NOT NULL DEFAULT '0',
  `is_deleted` tinyint(1) NOT NULL DEFAULT '0',
  `cle` varchar(32) NOT NULL,
  `token` char(32) DEFAULT NULL,
  `actif` tinyint(1) NOT NULL DEFAULT '0',
  `created_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_date` timestamp NULL DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Contenu de la table `users`
--

INSERT INTO `users` (`id_user`, `user`, `pwd`, `email`, `school`, `money_balance`, `fidelity_point`, `admin_user`, `is_deleted`, `cle`, `token`, `actif`, `created_date`, `updated_date`) VALUES
(1, 'hubert_g16', '$2y$10$pyUQC4kasQHjidkdkye2sORLv7W0yiBJ4sWLhYYrf8WjUE7a//y1G', 'hubertgauthier5@gmail.com', 'ESGI', 0, 0, 0, 0, '11e64fdc6fa255628a9df3283ce8d1d0', 'a464d8d8e94fdad3bb86f16042a39922', 1, '2017-03-05 14:47:03', NULL),
(2, 'bouffi_h16', '$2y$10$afnrSjJ98hV47OV3D1fauO1/4pAf0g8YteqwYTGqdaSOTbIymQWIa', 'hadrien.bouffier@gmail.com', 'ESGI', 0, 0, 0, 0, '1bd57d78ac76b277fe3001261485fcba', NULL, 0, '2017-03-06 19:01:36', NULL),
(3, 'admin', '$2y$10$dsp9go2GWfEHuOsu18z0Rek./tU6U1Iny79G9jo2acEjeI5cj3w.i', 'gescorner@gmail.com', '', 0, 0, 0, 0, '62bb33910101fee0714f2cc3d7988b9b', NULL, 0, '2017-03-06 19:09:34', NULL),
(4, 'test', '$2y$10$xHfAvQJa17JKzgJnmbbN7O613MnTkPGQG4dpZyLPHAns2DHT4.0mK', 'test@test.com', 'ESGI', 0, 0, 0, 0, 'a9e04d538f5bbc872dfe592cced8aadd', 'd7510e25c229485244eeefd18e502b93', 0, '2017-03-07 10:20:37', NULL),
(5, 'bebert_2020', '$2y$10$iD9iqnqoDTa.kQyZgj8DbeOiCb.5NbOObSwHcJRuPiWo5toHRrbsi', 'hubertgauthier5@gmail.com', 'ESGI', 0, 0, 0, 0, '34e1b907538fab82be1797588e424d58', NULL, 1, '2017-04-18 20:38:04', NULL);

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

--
-- Index pour la table `category`
--
ALTER TABLE `category`
  ADD PRIMARY KEY (`id_category`);

--
-- Index pour la table `products`
--
ALTER TABLE `products`
  ADD PRIMARY KEY (`id_product`),
  ADD KEY `category` (`category`);

--
-- Index pour la table `users`
--
ALTER TABLE `users`
  ADD PRIMARY KEY (`id_user`);

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

--
-- AUTO_INCREMENT pour la table `category`
--
ALTER TABLE `category`
  MODIFY `id_category` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=11;
--
-- AUTO_INCREMENT pour la table `products`
--
ALTER TABLE `products`
  MODIFY `id_product` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=47;
--
-- AUTO_INCREMENT pour la table `users`
--
ALTER TABLE `users`
  MODIFY `id_user` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;
/*!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 */;