YPC7QBws

1-- phpMyAdmin SQL Dump
2-- version 4.7.4
3-- https://www.phpmyadmin.net/
4--
5-- Hôte : 127.0.0.1:3306
6-- Généré le :  mar. 15 jan. 2019 à 12:44
7-- Version du serveur :  5.7.19
8-- Version de PHP :  5.6.31
9
10SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
11SET AUTOCOMMIT = 0;
12START TRANSACTION;
13SET time_zone = "+00:00";
14
15
16/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
17/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
18/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
19/*!40101 SET NAMES utf8mb4 */;
20
21--
22-- Base de données :  `project`
23--
24CREATE DATABASE IF NOT EXISTS `project` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;
25USE `project`;
26
27-- --------------------------------------------------------
28
29--
30-- Structure de la table `restaurants`
31--
32
33DROP TABLE IF EXISTS `restaurants`;
34CREATE TABLE IF NOT EXISTS `restaurants` (
35  `name` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
36  `price` int(11) NOT NULL,
37  `type` text CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
38  PRIMARY KEY (`name`)
39) ENGINE=MyISAM DEFAULT CHARSET=latin1;
40
41-- --------------------------------------------------------
42
43--
44-- Structure de la table `types`
45--
46
47DROP TABLE IF EXISTS `types`;
48CREATE TABLE IF NOT EXISTS `types` (
49  `type` varchar(255) NOT NULL,
50  `value` int(11) NOT NULL,
51  PRIMARY KEY (`type`)
52) ENGINE=MyISAM DEFAULT CHARSET=latin1;
53
54--
55-- Déchargement des données de la table `types`
56--
57
58INSERT INTO `types` (`type`, `value`) VALUES
59('100% VÃgÃtarien', 720),
60('Africain', 762),
61('Ailes de poulets', 821),
62('AmÃricain', 870),
63('Argentin', 817),
64('Asiatique (Fusion)', 750),
65('Asiatique', 750),
66('Barbecue', 800),
67('Belge', 693),
68('Boulangerie', 580),
69('CafÃ', 250),
70('Cajun', 675),
71('Chinois', 736),
72('Canadien', 935),
73('Casher', 765),
74('CorÃen', 774),
75('Desserts', 466),
76('EuropÃen (Nouvelle cuisine)', 715),
77('EuropÃen', 715),
78('Fast Food', 1016),
79('Fish  Chips', 994),
80('FranÃais', 768),
81('Friterie', 950),
82('Fruit de mer', 650),
83('Glace et yaourt glacÃ', 320),
84('Espagnol', 720),
85('Halal', 895),
86('Healthy', 563),
87('Indien (Ouest)', 790),
88('Grec', 723),
89('Indien', 790),
90('Iranien', 831),
91('IndonÃsien', 766),
92('Italien', 723),
93('Japonais', 857),
94('Latino-amÃricain', 700),
95('Libanais', 781),
96('Marocain', 852),
97('Mexicain', 847),
98('MÃditerranÃen', 835),
99('Juice and smoothies', 418),
100('Nouvelle cuisine mexicaine', 850),
101('Portugais', 750),
102('Pizza', 750),
103('PÃruvien', 670),
104('PÃtisseries', 380),
105('Salads', 531),
106('Sandwich', 588),
107('Sans gluten', 668),
108('Street food', 1100),
109('Thai', 730),
110('Sushi', 710),
111('Turc', 895),
112('Vietnamien', 790),
113('VÃgÃtarien', 733),
114('Syrien', 814),
115('VÃgÃtarien (sur demande)', 733),
116('Ãpicerie', 740);
117
118-- --------------------------------------------------------
119
120--
121-- Structure de la table `users`
122--
123
124DROP TABLE IF EXISTS `users`;
125CREATE TABLE IF NOT EXISTS `users` (
126  `login` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
127  `password` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
128  `config` text CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
129  PRIMARY KEY (`login`)
130) ENGINE=MyISAM DEFAULT CHARSET=latin1;
131COMMIT;
132
133/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
134/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
135/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;