gfxJehrt

1/*
2 Navicat Premium Data Transfer
3
4 Source Server         : localhost
5 Source Server Type    : MySQL
6 Source Server Version : 50723
7 Source Host           : localhost:3306
8 Source Schema         : sig
9
10 Target Server Type    : MySQL
11 Target Server Version : 50723
12 File Encoding         : 65001
13
14 Date: 05/12/2018 10:43:25
15*/
16
17SET NAMES utf8mb4;
18SET FOREIGN_KEY_CHECKS = 0;
19
20-- ----------------------------
21-- Table structure for chambres
22-- ----------------------------
23DROP TABLE IF EXISTS `chambres`;
24CREATE TABLE `chambres` (
25  `numeroChambre` char(2) NOT NULL DEFAULT '',
26  `capacite` int(11) NOT NULL DEFAULT '0',
27  `exposition` varchar(7) DEFAULT NULL,
28  `douche` int(11) NOT NULL DEFAULT '0',
29  `wc` int(11) NOT NULL DEFAULT '0',
30  `bain` int(11) NOT NULL DEFAULT '0',
31  `etage` int(11) NOT NULL DEFAULT '0',
32  `tarif` char(1) DEFAULT NULL,
33  PRIMARY KEY (`numeroChambre`),
34  KEY `tarif` (`tarif`),
35  CONSTRAINT `chambres_ibfk_1` FOREIGN KEY (`tarif`) REFERENCES `tarifs` (`codeTarif`)
36) ENGINE=InnoDB DEFAULT CHARSET=latin1;
37
38-- ----------------------------
39-- Records of chambres
40-- ----------------------------
41BEGIN;
42INSERT INTO `chambres` VALUES ('1', 2, 'port', -1, -1, 0, 1, '2');
43INSERT INTO `chambres` VALUES ('10', 2, 'rempart', -1, -1, 0, 3, '2');
44INSERT INTO `chambres` VALUES ('11', 2, 'port', -1, -1, 0, 3, '2');
45INSERT INTO `chambres` VALUES ('12', 4, 'port', -1, -1, 0, 3, '5');
46INSERT INTO `chambres` VALUES ('2', 4, 'rempart', -1, -1, 0, 1, '5');
47INSERT INTO `chambres` VALUES ('3', 2, 'port', -1, -1, 0, 1, '2');
48INSERT INTO `chambres` VALUES ('4', 2, 'rempart', 0, 0, 0, 1, '1');
49INSERT INTO `chambres` VALUES ('5', 2, 'port', 0, -1, -1, 2, '3');
50INSERT INTO `chambres` VALUES ('6', 3, 'rempart', -1, -1, 0, 2, '4');
51INSERT INTO `chambres` VALUES ('7', 3, 'port', -1, -1, 0, 2, '4');
52INSERT INTO `chambres` VALUES ('8', 2, 'rempart', 0, -1, -1, 2, '3');
53INSERT INTO `chambres` VALUES ('9', 2, 'port', 0, 0, 0, 3, '1');
54COMMIT;
55
56-- ----------------------------
57-- Table structure for clients
58-- ----------------------------
59DROP TABLE IF EXISTS `clients`;
60CREATE TABLE `clients` (
61  `numeroClient` double NOT NULL,
62  `civil` varchar(12) NOT NULL DEFAULT '',
63  `nom` varchar(20) NOT NULL DEFAULT '',
64  `prenom` varchar(20) NOT NULL DEFAULT '',
65  `adresse` varchar(40) NOT NULL DEFAULT '',
66  `codePostal` varchar(7) NOT NULL DEFAULT '',
67  `ville` varchar(30) NOT NULL DEFAULT '',
68  `pays` varchar(20) DEFAULT NULL,
69  PRIMARY KEY (`numeroClient`)
70) ENGINE=InnoDB DEFAULT CHARSET=latin1;
71
72-- ----------------------------
73-- Records of clients
74-- ----------------------------
75BEGIN;
76INSERT INTO `clients` VALUES (1, 'Mademoiselle', 'DUMAS', 'Sandrine', '5 allée des Tilleuls', '75010', 'PARIS', 'France');
77INSERT INTO `clients` VALUES (2, 'Monsieur', 'MORIN', 'Herv', 'North avenue 44', 'TW9 3', 'KEW', 'Grande-Bretagne');
78INSERT INTO `clients` VALUES (3, 'Madame', 'MORIN', 'Joëlle', '34 rue Saint Denis', '67000', 'STRASBOURG', 'France');
79INSERT INTO `clients` VALUES (4, 'Mademoiselle', 'GAGNERON', 'Aurélie', '4 rue Laénnec', '01200', 'MONTANGES', 'France');
80INSERT INTO `clients` VALUES (5, 'Madame', 'DULLAC', 'Martine', '4 allée André Malraux', '14100', 'LISIEUX', 'France');
81INSERT INTO `clients` VALUES (6, 'Madame', 'DUPRE', 'Stéphanie', '87 rue Ernest Renan', '35480', 'GUIPRY', 'France');
82INSERT INTO `clients` VALUES (7, 'Monsieur', 'BRIGAND', 'Maurice', '2 rue Louis Bl?riot', '35360', 'MONTAUBAN DE BRETAGNE', 'France');
83INSERT INTO `clients` VALUES (8, 'Monsieur', 'VAN ELIT', 'Gérard', '27 rue Ambroise', '1000', 'BRUXELLES', 'Belgique');
84INSERT INTO `clients` VALUES (9, 'Monsieur', 'DESROSIERS', 'Antoine', '2 allée Antoinette', '53200', 'AZE', 'France');
85INSERT INTO `clients` VALUES (10, 'Mademoiselle', 'DULLAC', 'Martine', '17 avenue Albert Camus', '35200', 'MARSEILLE', 'France');
86INSERT INTO `clients` VALUES (11, 'Monsieur', 'LELONG', 'Magloire', '11 rue Paul Bert', '1000', 'BRUXELLES', 'Belgique');
87INSERT INTO `clients` VALUES (12, 'Monsieur', 'MALPAS', 'Julien', '16 rue Gambetta', '29000', 'BREST', 'France');
88INSERT INTO `clients` VALUES (13, 'Monsieur', 'BRIGAND', 'Maurice', '46 rue Emile Zola', '30000', 'NIMES', 'France');
89INSERT INTO `clients` VALUES (14, 'Madame', 'DESBOIS', 'Delphine', '8 Square des Ormeaux', '36000', 'CHATEAUROUX', 'France');
90INSERT INTO `clients` VALUES (15, 'Mademoiselle', 'DUMARC', 'Sandrine', '31 rue André Desilles', '33000', 'BORDEAUX', 'France');
91INSERT INTO `clients` VALUES (16, 'Monsieur', 'TAILLARD', 'Julien', 'La Chesnaie', '5570', 'WANCENNES', 'Belgique');
92INSERT INTO `clients` VALUES (17, 'Madame', 'LEGOFF', 'Françoise', '11 rue des Peupliers', '29000', 'BREST', 'France');
93INSERT INTO `clients` VALUES (18, 'Monsieur', 'BOURGE', 'Nicolas', 'Le Chêne Tord', '92340', 'BOURG LA REINE', 'France');
94INSERT INTO `clients` VALUES (19, 'Madame', 'FRALIN', 'Emmanuelle', '4 rue Rabelais', '78650', 'BEYNES', 'France');
95INSERT INTO `clients` VALUES (20, 'Mademoiselle', 'GARCIA', 'Mary', 'New road east 22', 'PO2 7', 'PORTSMOUTH', 'Grande-Bretagne');
96INSERT INTO `clients` VALUES (21, 'Monsieur', 'FOULON', 'Yann', '7 Allée de Bréquigny', '72000', 'LE MANS', 'France');
97INSERT INTO `clients` VALUES (22, 'Monsieur', 'FOURET', 'Samuel', '45 rue de lIse', '22000', 'SAINT BRIEUC', 'France');
98INSERT INTO `clients` VALUES (23, 'Mademoiselle', 'GARRET', 'Guénola', '8 Square de Londres', '53000', 'LAVAL', 'France');
99INSERT INTO `clients` VALUES (24, 'Madame', 'JAMOTEAU', 'Fabienne', '2 rue Saint Michel', '44000', 'NANTES', 'France');
100INSERT INTO `clients` VALUES (25, 'Monsieur', 'ROUSSEAU', 'Damien', '1 Square du Douro', '02400', 'NOGENTEL', 'France');
101INSERT INTO `clients` VALUES (26, 'Monsieur', 'AUBIER', 'Barnab', 'Les Ruelles', '35235', 'THORIGNE FOUILLARD', 'France');
102INSERT INTO `clients` VALUES (27, 'Monsieur', 'HILARY', 'Lionel', '18 rue des Camélias', '54300', 'LUNEVILLE', 'France');
103INSERT INTO `clients` VALUES (28, 'Madame', 'COIGNE', 'Katell', '11 rue de la Mare', '01100', 'APREMONT', 'France');
104INSERT INTO `clients` VALUES (29, 'Monsieur', 'LINIZAN', 'Gérald', '19 rue Mozart', '35830', 'BETTON', 'France');
105INSERT INTO `clients` VALUES (30, 'Monsieur', 'AUDUREAU', 'Manuel', '34 rue de Verdun', '34000', 'MONTPELLIER', 'France');
106INSERT INTO `clients` VALUES (31, 'Monsieur', 'HERFROY', 'Sylvain', '2 rue Launay', '12200', 'SAVIGNAC', 'France');
107INSERT INTO `clients` VALUES (32, 'Monsieur', 'COUPPE', 'Maxime', '42 rue C?sar', '06000', 'NICE', 'France');
108INSERT INTO `clients` VALUES (33, 'Monsieur', 'COULAIN', 'John', 'Porstmouth Street 23', 'SW1X', 'LONDON', 'Grande-Bretagne');
109INSERT INTO `clients` VALUES (34, 'Madame', 'LEDUC', 'Christine', 'Villa des R?s?das', '75003', 'PARIS', 'France');
110INSERT INTO `clients` VALUES (35, 'Monsieur', 'MOREAU', 'Ludovic', '11 rue du H?tre', '35480', 'GUIPRY', 'France');
111INSERT INTO `clients` VALUES (36, 'Mademoiselle', 'RACAPE', 'Sylvie', '8 Square du Douro', '02100', 'GRICOURT', 'France');
112INSERT INTO `clients` VALUES (37, 'Monsieur', 'MALOUIN', 'Herv', '33 all?e du Lac On?ga', '35200', 'MARSEILLE', 'France');
113INSERT INTO `clients` VALUES (38, 'Madame', 'QUERE', 'Maryvonne', '28 rue de vern', '02000', 'URCEL', 'France');
114INSERT INTO `clients` VALUES (39, 'Monsieur', 'ROULIER', 'Jean Paul', '6 avenue du Canada', '35200', 'RENNES', 'France');
115INSERT INTO `clients` VALUES (40, 'Mademoiselle', 'SEVEZAN', 'Michelle', 'Albert road north 6', 'S0145', 'SOUTHAMPTON', 'Grande-Bretagne');
116INSERT INTO `clients` VALUES (41, 'Monsieur', 'LESTER', 'Ted', 'Beechin wood lane 6', 'TN158', 'PLATT', 'Grande-Bretagne');
117INSERT INTO `clients` VALUES (42, 'Madame', 'MONTEREL', 'Sonia', 'Castle Road 3', 'SW1B', 'LONDON', 'Grande-Bretagne');
118INSERT INTO `clients` VALUES (43, 'Monsieur', 'GICQUEL', 'Bruno', '64 rue Albert Camus', '25230', 'DASLE', 'France');
119INSERT INTO `clients` VALUES (44, 'Mademoiselle', 'COUPPEY', 'Corinne', 'Roding lane north 54', 'IG88', 'LONDON', 'Grande-Bretagne');
120INSERT INTO `clients` VALUES (45, 'Madame', 'CADOREL', 'Louise', '23 route de Lorient', '03500', 'MONTORD', 'France');
121INSERT INTO `clients` VALUES (46, 'Monsieur', 'VIGNER', 'Jean Luc', '43 rue Etienne Pinault', '13000', 'MARSEILLE', 'France');
122INSERT INTO `clients` VALUES (47, 'Madame', 'COUSTOM', 'Colleen', 'Dapholdils Street 4', 'BD1', 'MARSH', 'Grande-Bretagne');
123INSERT INTO `clients` VALUES (48, 'Mademoiselle', 'LEBLE', 'S?verine', '65 rue des Foss', '75012', 'PARIS', 'France');
124INSERT INTO `clients` VALUES (49, 'Monsieur', 'LEGOFF', 'Pierre', 'Gand Platze 4', '8000', 'ZURICH', 'Suisse');
125INSERT INTO `clients` VALUES (50, 'Monsieur', 'LESCOUARN', 'Claude', '22 all?e de Varsovie', '35200', 'RENNES', 'France');
126INSERT INTO `clients` VALUES (51, 'Monsieur', 'AUDUREAU', 'Gildas', 'Les Ruelles', '04500', 'RIEZ', 'France');
127INSERT INTO `clients` VALUES (52, 'Monsieur', 'BOURGE', 'Manuel', '34 rue de Verdun', '92500', 'RUEIL MALMAISON', 'France');
128INSERT INTO `clients` VALUES (53, 'Monsieur', 'BRIGAND', 'Nicolas', 'Le Ch?ne Tord', '1000', 'LAUSANNE', 'Suisse');
129INSERT INTO `clients` VALUES (54, 'Monsieur', 'BRIGAND', 'Maurice', '2 rue Louis Bl?riot', '59000', 'LILLE', 'France');
130INSERT INTO `clients` VALUES (55, 'Monsieur', 'CADOREL', 'Maurice', 'Emilian Strasse 67', '8000', 'ZURICH', 'Suisse');
131INSERT INTO `clients` VALUES (56, 'Monsieur', 'COIGNE', 'Ludovic', '23 route de Lorient', '35700', 'RENNES', 'France');
132INSERT INTO `clients` VALUES (57, 'Monsieur', 'COULARON', 'Killian', '11 rue de la Mare', '35250', 'ST MEDARD/ILLE', 'France');
133INSERT INTO `clients` VALUES (58, 'Monsieur', 'MARTIN', 'Peter', 'Upper new road 56', 'SO303', 'SOUTHAMPTON', 'Grande-Bretagne');
134INSERT INTO `clients` VALUES (59, 'Monsieur', 'COUPPEY', 'Maxime', '42 rue C?sar', '01000', 'BOURG EN BRESSE', 'France');
135INSERT INTO `clients` VALUES (60, 'Monsieur', 'COUSSOT', 'Corentin', 'New george street 1', 'PL11', 'PLYMOUTH', 'Grande-Bretagne');
136INSERT INTO `clients` VALUES (61, 'Monsieur', 'DAUMAS', 'Colin', '4 all?e du Dauphin', '35000', 'RENNES', 'France');
137INSERT INTO `clients` VALUES (62, 'Monsieur', 'DESBOIS', 'St?phane', '5 all?e des Tilleuls', '75005', 'PARIS', 'France');
138INSERT INTO `clients` VALUES (63, 'Monsieur', 'DESROSIERS', 'Didier', '8 Square des Ormeaux', '91100', 'CORBEIL ESSONNES', 'France');
139INSERT INTO `clients` VALUES (64, 'Monsieur', 'DULLAC', 'Antoine', '2 all?e Antoinette', '35520', 'GUICHEN', 'France');
140INSERT INTO `clients` VALUES (65, 'Monsieur', 'DULLAC', 'Martin', '4 all?e Andr? Malraux', '35150', 'CORPS NUDS', 'France');
141INSERT INTO `clients` VALUES (66, 'Monsieur', 'DUMARC', 'Martin', '17 avenue Albert Camus', '37220', 'TROGUES', 'France');
142INSERT INTO `clients` VALUES (67, 'Monsieur', 'DUMAS', 'St?phane', '31 rue Andr? Desilles', '35000', 'RENNES', 'France');
143INSERT INTO `clients` VALUES (68, 'Monsieur', 'LOUMAS', 'Geoffroy', '5 all?e des Tilleuls', '75001', 'PARIS', 'France');
144INSERT INTO `clients` VALUES (69, 'Monsieur', 'DESPRE', 'St?phane', '87 rue Ernest Renan', '14400', 'CUSSY', 'France');
145INSERT INTO `clients` VALUES (70, 'Monsieur', 'COULON', 'Yann', '7 All?e de Br?quigny', '92400', 'COURBEVOIE', 'France');
146INSERT INTO `clients` VALUES (71, 'Monsieur', 'LOURET', 'Samuel', '45 rue de lIse', '14000', 'CAEN', 'France');
147INSERT INTO `clients` VALUES (72, 'Monsieur', 'GRALIN', 'Emmanuel', '4 rue Rabelais', '35250', 'ST MEDARD/ILLE', 'France');
148INSERT INTO `clients` VALUES (73, 'Monsieur', 'SAGER', 'Aur?lien', '4 rue La?nnec', '37150', 'CHENONCEAUX', 'France');
149INSERT INTO `clients` VALUES (74, 'Monsieur', 'GRANDOLE', 'Paul', 'North down crescent 9', 'PL22', 'PLYMOUTH', 'Grande-Bretagne');
150INSERT INTO `clients` VALUES (75, 'Monsieur', 'BARRET', 'Gweltaz', '8 Square de Londres', '33000', 'BORDEAUX', 'France');
151INSERT INTO `clients` VALUES (76, 'Monsieur', 'PIGEON', 'Bruno', '64 rue Albert Camus', '35230', 'CREVIN', 'France');
152INSERT INTO `clients` VALUES (77, 'Monsieur', 'GEFFROY', 'Laurent', '2 rue Launay', '35850', 'GEVEZE', 'France');
153INSERT INTO `clients` VALUES (78, 'Monsieur', 'JULIEN', 'Lionel', '18 rue des Cam?lias', '43000', 'POLIGNAC', 'France');
154INSERT INTO `clients` VALUES (79, 'Monsieur', 'FRAME', 'Charly', 'Pine view 10', 'TN158', 'PLATT', 'Grande-Bretagne');
155INSERT INTO `clients` VALUES (80, 'Monsieur', 'LEGORGE', 'S?bastien', '65 rue des Foss', '35850', 'GEVEZE', 'France');
156INSERT INTO `clients` VALUES (81, 'Monsieur', 'DURAND', 'Christian', 'Villa des R?s?das', '35830', 'PARIS', 'France');
157INSERT INTO `clients` VALUES (82, 'Monsieur', 'FERNIER', 'Thierry', '23 rue Barthou', '8957', 'MESSINES', 'Belgique');
158INSERT INTO `clients` VALUES (83, 'Monsieur', 'DEGOUIS', 'Fran?ois', '11 rue des Peupliers', '75001', 'PARIS', 'France');
159INSERT INTO `clients` VALUES (84, 'Monsieur', 'SERFE', 'Pierre', '11 lot des Peupliers', '1000', 'LAUSANNE', 'Suisse');
160INSERT INTO `clients` VALUES (85, 'Monsieur', 'DULONG', 'Magloire', '11 rue Paul Bert', '27000', 'EVREUX', 'France');
161INSERT INTO `clients` VALUES (86, 'Monsieur', 'MESCOUARN', 'Claude', '22 all?e de Varsovie', '27100', 'VAL DE REUIL', 'France');
162INSERT INTO `clients` VALUES (87, 'Monsieur', 'INIZAN', 'G?rald', '19 rue Mozart', '75001', 'PARIS', 'France');
163INSERT INTO `clients` VALUES (88, 'Monsieur', 'FALOUIN', 'Herv', '33 all?e du Lac On?ga', '27200', 'VERNON', 'France');
164INSERT INTO `clients` VALUES (89, 'Monsieur', 'MOBAL', 'Jude', 'Row lane 23', 'PL52', 'PLYMOUTH', 'Grande-Bretagne');
165INSERT INTO `clients` VALUES (90, 'Monsieur', 'MONTHUREL', 'Simon', '3 Quai Chateaubriand', '67500', 'HAGUENAU', 'France');
166INSERT INTO `clients` VALUES (91, 'Monsieur', 'POREL', 'Ludovic', '11 rue du H?tre', '14250', 'BROUAY', 'France');
167INSERT INTO `clients` VALUES (92, 'Monsieur', 'NOUE', 'Herv', '44 rue Saint Denis', '27300', 'BERNAY', 'France');
168INSERT INTO `clients` VALUES (93, 'Monsieur', 'CHARLES', 'Julien', '44 rue Saint Denis', '35000', 'RENNES', 'France');
169INSERT INTO `clients` VALUES (94, 'Monsieur', 'BERDIER', 'Marc', '28 rue de vern', '35000', 'RENNES', 'France');
170INSERT INTO `clients` VALUES (95, 'Monsieur', 'BADELOIS', 'Sylvain', '8 Square du Douro', '35200', 'RENNES', 'France');
171INSERT INTO `clients` VALUES (96, 'Monsieur', 'ROULLER', 'Jean Paul', '6 avenue du Canada', '35200', 'RENNES', 'France');
172INSERT INTO `clients` VALUES (97, 'Monsieur', 'MONTVOL', 'Damien', '1 Square du Douro', '35200', 'RENNES', 'France');
173INSERT INTO `clients` VALUES (98, 'Monsieur', 'VERSER', 'Martin', 'Clare hill 8', 'KT109', 'LONDON', 'Grande-Bretagne');
174INSERT INTO `clients` VALUES (99, 'Monsieur', 'MAILLARD', 'Julien', 'La Chesnaie', '33150', 'CENON', 'France');
175INSERT INTO `clients` VALUES (100, 'Monsieur', 'BANELIER', 'G?rard', '27 rue Ambroise', '6978', 'GANDRIA', 'Suisse');
176INSERT INTO `clients` VALUES (101, 'Monsieur', 'BIHAN', 'Martin', 'Eastend avenue 43', 'OX2', 'TUSMORE', 'Grande-Bretagne');
177INSERT INTO `clients` VALUES (102, 'Monsieur', 'AUDUREAU', 'Barnab', 'Les Ruelles', '35235', 'THORIGNE FOUILLARD', 'France');
178INSERT INTO `clients` VALUES (103, 'Monsieur', 'BOURGE', 'Manuel', '34 rue de Verdun', '72150', 'COURDEMANCHE', 'France');
179INSERT INTO `clients` VALUES (104, 'Monsieur', 'BRIGAND', 'Nicolas', 'Les M?l?zes', '1875', 'MORGINS', 'Suisse');
180INSERT INTO `clients` VALUES (105, 'Monsieur', 'BRIGAND', 'Maurice', '2 rue Louis Bl?riot', '35360', 'MONTAUBAN DE BRETAGNE', 'France');
181INSERT INTO `clients` VALUES (106, 'Monsieur', 'CADOREL', 'Maurice', '46 rue Emile Zola', '35170', 'BRUZ', 'France');
182INSERT INTO `clients` VALUES (107, 'Monsieur', 'COIGNE', 'Louis', '23 route de Lorient', '78250', 'MEULAN', 'France');
183INSERT INTO `clients` VALUES (108, 'Monsieur', 'COULARON', 'Killian', '11 rue de la Mare', '54000', 'NANCY', 'France');
184INSERT INTO `clients` VALUES (109, 'Monsieur', 'COUPPLE', 'John', 'Sunnyside road north 23', 'N99', 'LONDON', 'Grande-Bretagne');
185INSERT INTO `clients` VALUES (110, 'Monsieur', 'COUPPEY', 'Maxime', '42 rue C?sar', '92300', 'LEVALLOIS PERRET', 'France');
186INSERT INTO `clients` VALUES (111, 'Monsieur', 'BOURN', 'Peter', 'Lichfield drive 5', 'LE84', 'BLABY', 'Grande-Bretagne');
187INSERT INTO `clients` VALUES (112, 'Monsieur', 'DAUMAS', 'Pol', '4 all?e du Dauphin', '29100', 'DOUARNENEZ', 'France');
188INSERT INTO `clients` VALUES (113, 'Monsieur', 'DESBOIS', 'St?phane', '5 all?e des Tilleuls', '1200', 'GENEVE', 'Suisse');
189INSERT INTO `clients` VALUES (114, 'Monsieur', 'DESROSIERS', 'Donatien', '8 Square des Ormeaux', '44150', 'ANCENIS', 'France');
190INSERT INTO `clients` VALUES (115, 'Monsieur', 'DULLAC', 'Antoine', '2 all?e Antoinette', '66150', 'ARLES SUR TECH', 'France');
191INSERT INTO `clients` VALUES (116, 'Monsieur', 'DULLAC', 'Karim', '4 all?e Andr? Malraux', '14200', 'HEROUVILLE SAINT CLAIR', 'France');
192INSERT INTO `clients` VALUES (117, 'Monsieur', 'DUMARC', 'Martin', '17 avenue Albert Camus', '92200', 'NEUILLY SUR SEINE', 'France');
193INSERT INTO `clients` VALUES (118, 'Monsieur', 'DUMMORE', 'Sam', 'Albert road north 7', 'SO303', 'SOUTHAMPTON', 'Grande-Bretagne');
194INSERT INTO `clients` VALUES (119, 'Monsieur', 'LOUMAS', 'Erwann', '5 all?e des Tilleuls', '75001', 'PARIS', 'France');
195INSERT INTO `clients` VALUES (120, 'Monsieur', 'DESPRE', 'St?phane', '87 rue Ernest Renan', '22100', 'LANVALLAY', 'France');
196INSERT INTO `clients` VALUES (121, 'Monsieur', 'COULON', 'Yann', '7 All?e de Br?quigny', '78350', 'JOUY EN JOSAS', 'France');
197INSERT INTO `clients` VALUES (122, 'Monsieur', 'LOURET', 'Samuel', '45 rue de lIse', '35150', 'CORPS NUDS', 'France');
198INSERT INTO `clients` VALUES (123, 'Monsieur', 'GRALIN', 'Emmanuel', '4 rue Rabelais', '72150', 'BRIVES', 'France');
199INSERT INTO `clients` VALUES (124, 'Monsieur', 'SAGER', 'Aur?lien', '4 rue La?nnec', '85100', 'LES SABLES DOLONNE', 'France');
200INSERT INTO `clients` VALUES (125, 'Monsieur', 'GRADOLE', 'Aston', 'Little town square 22', 'BD1', 'MARSH', 'Grande-Bretagne');
201INSERT INTO `clients` VALUES (126, 'Monsieur', 'BARRET', 'Gurvan', '8 Square de Londres', '26000', 'VALENCE', 'France');
202INSERT INTO `clients` VALUES (127, 'Monsieur', 'PIGEON', 'Bruno', '64 rue Albert Camus', '35510', 'CHATEAUGIRON', 'France');
203INSERT INTO `clients` VALUES (128, 'Monsieur', 'GEFFROY', 'Lillian', '2 rue Launay', '11000', 'CARCASSONNE', 'France');
204INSERT INTO `clients` VALUES (129, 'Monsieur', 'JULIEN', 'Lionel', '18 rue des Cam?lias', '63000', 'CLERMONT FERRAND', 'France');
205INSERT INTO `clients` VALUES (130, 'Monsieur', 'FOSTER', 'Michael', 'Tudor Court north 2', 'NW10', 'LONDON', 'Grande-Bretagne');
206INSERT INTO `clients` VALUES (131, 'Monsieur', 'LEGORGE', 'Steven', '65 rue des Foss', '35400', 'PARAME', 'France');
207INSERT INTO `clients` VALUES (132, 'Monsieur', 'DURAND', 'Christian', 'Villa des R?s?das', '35830', 'BETTON', 'France');
208INSERT INTO `clients` VALUES (133, 'Monsieur', 'FERNER', 'Tod', 'North avenue 4', 'PO29', 'PORTSMOUTH', 'Grande-Bretagne');
209INSERT INTO `clients` VALUES (134, 'Monsieur', 'DEGOUIS', 'Fran?ois', '11 rue des Peupliers', '75001', 'PARIS', 'France');
210INSERT INTO `clients` VALUES (135, 'Monsieur', 'SCIONS', 'Pierre', '23 lot des Peupliers', '1200', 'GENEVE', 'Suisse');
211INSERT INTO `clients` VALUES (136, 'Monsieur', 'DULONG', 'Florent', '11 rue Paul Bert', '26100', 'ROMANS SUR ISERE', 'France');
212INSERT INTO `clients` VALUES (137, 'Monsieur', 'MESCOUARN', 'Claude', '22 all?e de Varsovie', '27400', 'CANAPPEVILLE', 'France');
213INSERT INTO `clients` VALUES (138, 'Monsieur', 'INIZAN', 'G?rald', '19 rue Mozart', '750016', 'PARIS', 'France');
214INSERT INTO `clients` VALUES (139, 'Monsieur', 'FALOUIN', 'Herv', '33 all?e du Lac On?ga', '03100', 'MONTLUCON', 'France');
215INSERT INTO `clients` VALUES (140, 'Monsieur', 'MOBAL', 'Justin', 'All Road south 12', 'SO303', 'SOUTHAMPTON', 'Grande-Bretagne');
216INSERT INTO `clients` VALUES (141, 'Madame', 'MONTHUREL', 'Simone', '3 Quai Chateaubriand', '37000', 'TOURS', 'France');
217INSERT INTO `clients` VALUES (142, 'Madame', 'POREL', 'Lucie', '11 rue du H?tre', '85000', 'LA ROCHE SUR YON', 'France');
218INSERT INTO `clients` VALUES (143, 'Mademoiselle', 'NOUE', 'Hermine', '44 rue Saint Denis', '10300', 'SAINTE SAVINE', 'France');
219INSERT INTO `clients` VALUES (144, 'Mademoiselle', 'CHARLES', 'Jo?lle', '44 rue Saint Denis', '10200', 'DOLANCOURT', 'France');
220INSERT INTO `clients` VALUES (145, 'Mademoiselle', 'BERDIER', 'Maryvonne', '28 rue de vern', '10100', 'CRANCEY', 'France');
221INSERT INTO `clients` VALUES (146, 'Mademoiselle', 'BADELOIS', 'Sylvie', '8 Square du Douro', '35200', 'RENNES', 'France');
222INSERT INTO `clients` VALUES (147, 'Mademoiselle', 'ROULLER', 'Jeannette', '6 avenue du Canada', '35200', 'RENNES', 'France');
223INSERT INTO `clients` VALUES (148, 'Mademoiselle', 'MONTVOL', 'Doris', '1 Square du Douro', '35200', 'RENNES', 'France');
224INSERT INTO `clients` VALUES (149, 'Mademoiselle', 'VOUCHER', 'Martine', 'Queen Mary Road 43', 'PL11', 'PLYMOUTH', 'Grande-Bretagne');
225INSERT INTO `clients` VALUES (150, 'Mademoiselle', 'MAILLARD', 'Julie', 'La Chesnaie', '06000', 'NICE', 'France');
226INSERT INTO `clients` VALUES (151, 'Mademoiselle', 'BANELIER', 'G?raldine', '27 rue Ambroise', '35170', 'BRUZ', 'France');
227INSERT INTO `clients` VALUES (152, 'Mademoiselle', 'BIHAN', 'Juliette', '43 rue Etienne Pinault', '35000', 'RENNES', 'France');
228INSERT INTO `clients` VALUES (153, 'Mademoiselle', 'BADELOIS', 'Sylvie', '9 Square du Douro', '35200', 'RENNES', 'France');
229INSERT INTO `clients` VALUES (154, 'Mademoiselle', 'ROULLER', 'Judith', '7 avenue du Canada', '35200', 'RENNES', 'France');
230INSERT INTO `clients` VALUES (155, 'Mademoiselle', 'MONTVOL', 'Damiana', '2 Square du Douro', '35200', 'RENNES', 'France');
231INSERT INTO `clients` VALUES (156, 'Mademoiselle', 'VYRSER', 'Julia', 'Queen Street 9', 'OX2', 'TUSMORE', 'Grande-Bretagne');
232INSERT INTO `clients` VALUES (157, 'Mademoiselle', 'MAILLARD', 'Julie', 'La Chesnaie', '35235', 'THORIGNE FOUILLARD', 'France');
233INSERT INTO `clients` VALUES (158, 'Mademoiselle', 'BANELIER', 'Garance', '28 rue Ambroise', '1200', 'GENEVE', 'Suisse');
234INSERT INTO `clients` VALUES (159, 'Monsieur', 'Joël', 'BREILLOT', '12 rue des Aubépines', '74000', 'ANNECY', 'FRANCE');
235COMMIT;
236
237-- ----------------------------
238-- Table structure for planning
239-- ----------------------------
240DROP TABLE IF EXISTS `planning`;
241CREATE TABLE `planning` (
242  `numeroChambre` char(2) NOT NULL DEFAULT '',
243  `jour` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
244  `reservation` int(11) NOT NULL DEFAULT '0',
245  `occupee` int(11) NOT NULL DEFAULT '0',
246  `paye` int(11) NOT NULL DEFAULT '0',
247  `numeroClient` double NOT NULL,
248  PRIMARY KEY (`numeroChambre`,`jour`),
249  KEY `numeroClient` (`numeroClient`),
250  CONSTRAINT `planning_ibfk_1` FOREIGN KEY (`numeroChambre`) REFERENCES `chambres` (`numeroChambre`),
251  CONSTRAINT `planning_ibfk_2` FOREIGN KEY (`numeroClient`) REFERENCES `clients` (`numeroClient`)
252) ENGINE=InnoDB DEFAULT CHARSET=latin1;
253
254-- ----------------------------
255-- Records of planning
256-- ----------------------------
257BEGIN;
258INSERT INTO `planning` VALUES ('1', '2017-10-01 00:00:00', -1, -1, -1, 13);
259INSERT INTO `planning` VALUES ('1', '2017-10-02 00:00:00', -1, -1, -1, 21);
260INSERT INTO `planning` VALUES ('1', '2017-10-04 00:00:00', -1, -1, -1, 30);
261INSERT INTO `planning` VALUES ('1', '2017-10-05 00:00:00', -1, -1, -1, 34);
262INSERT INTO `planning` VALUES ('1', '2017-10-06 00:00:00', -1, -1, -1, 34);
263INSERT INTO `planning` VALUES ('1', '2017-10-07 00:00:00', -1, -1, -1, 34);
264INSERT INTO `planning` VALUES ('1', '2017-10-08 00:00:00', -1, -1, -1, 46);
265INSERT INTO `planning` VALUES ('1', '2017-10-09 00:00:00', 0, -1, -1, 43);
266INSERT INTO `planning` VALUES ('1', '2017-10-11 00:00:00', -1, -1, -1, 53);
267INSERT INTO `planning` VALUES ('1', '2017-10-12 00:00:00', -1, -1, -1, 53);
268INSERT INTO `planning` VALUES ('1', '2017-10-18 00:00:00', -1, -1, -1, 92);
269INSERT INTO `planning` VALUES ('1', '2017-10-19 00:00:00', -1, -1, -1, 92);
270INSERT INTO `planning` VALUES ('1', '2017-10-20 00:00:00', -1, -1, -1, 106);
271INSERT INTO `planning` VALUES ('1', '2017-10-21 00:00:00', 0, -1, -1, 103);
272INSERT INTO `planning` VALUES ('1', '2017-10-23 00:00:00', -1, -1, -1, 113);
273INSERT INTO `planning` VALUES ('1', '2017-10-24 00:00:00', -1, -1, -1, 113);
274INSERT INTO `planning` VALUES ('1', '2017-10-25 00:00:00', 0, -1, -1, 59);
275INSERT INTO `planning` VALUES ('1', '2017-10-26 00:00:00', -1, -1, -1, 71);
276INSERT INTO `planning` VALUES ('1', '2017-10-27 00:00:00', -1, -1, -1, 79);
277INSERT INTO `planning` VALUES ('1', '2017-10-28 00:00:00', -1, -1, -1, 88);
278INSERT INTO `planning` VALUES ('1', '2017-10-29 00:00:00', -1, -1, -1, 92);
279INSERT INTO `planning` VALUES ('1', '2017-11-01 00:00:00', 0, -1, -1, 119);
280INSERT INTO `planning` VALUES ('1', '2017-11-02 00:00:00', -1, -1, -1, 138);
281INSERT INTO `planning` VALUES ('1', '2017-11-03 00:00:00', -1, 0, 0, 130);
282INSERT INTO `planning` VALUES ('1', '2017-11-04 00:00:00', -1, -1, -1, 147);
283INSERT INTO `planning` VALUES ('1', '2017-11-05 00:00:00', -1, -1, -1, 151);
284INSERT INTO `planning` VALUES ('1', '2017-11-06 00:00:00', -1, -1, -1, 152);
285INSERT INTO `planning` VALUES ('1', '2017-11-07 00:00:00', -1, -1, -1, 152);
286INSERT INTO `planning` VALUES ('1', '2017-11-20 00:00:00', -1, 0, 0, 106);
287INSERT INTO `planning` VALUES ('1', '2017-11-21 00:00:00', -1, 0, 0, 103);
288INSERT INTO `planning` VALUES ('1', '2017-11-29 00:00:00', 0, -1, -1, 1);
289INSERT INTO `planning` VALUES ('10', '2017-10-01 00:00:00', -1, -1, -1, 10);
290INSERT INTO `planning` VALUES ('10', '2017-10-02 00:00:00', 0, -1, -1, 27);
291INSERT INTO `planning` VALUES ('10', '2017-10-03 00:00:00', -1, -1, -1, 10);
292INSERT INTO `planning` VALUES ('10', '2017-10-08 00:00:00', -1, -1, -1, 54);
293INSERT INTO `planning` VALUES ('10', '2017-10-09 00:00:00', 0, -1, -1, 52);
294INSERT INTO `planning` VALUES ('10', '2017-10-20 00:00:00', -1, -1, -1, 114);
295INSERT INTO `planning` VALUES ('10', '2017-10-21 00:00:00', 0, -1, -1, 112);
296INSERT INTO `planning` VALUES ('10', '2017-10-25 00:00:00', -1, -1, -1, 68);
297INSERT INTO `planning` VALUES ('10', '2017-10-26 00:00:00', -1, -1, -1, 68);
298INSERT INTO `planning` VALUES ('10', '2017-10-27 00:00:00', 0, -1, -1, 85);
299INSERT INTO `planning` VALUES ('10', '2017-11-01 00:00:00', -1, -1, -1, 128);
300INSERT INTO `planning` VALUES ('10', '2017-11-02 00:00:00', 0, -1, -1, 144);
301INSERT INTO `planning` VALUES ('10', '2017-11-03 00:00:00', -1, -1, -1, 128);
302INSERT INTO `planning` VALUES ('10', '2017-11-21 00:00:00', -1, 0, 0, 112);
303INSERT INTO `planning` VALUES ('11', '2017-10-01 00:00:00', -1, -1, -1, 20);
304INSERT INTO `planning` VALUES ('11', '2017-10-02 00:00:00', -1, -1, -1, 28);
305INSERT INTO `planning` VALUES ('11', '2017-10-08 00:00:00', 0, -1, -1, 55);
306INSERT INTO `planning` VALUES ('11', '2017-10-20 00:00:00', 0, -1, -1, 115);
307INSERT INTO `planning` VALUES ('11', '2017-10-25 00:00:00', 0, -1, -1, 69);
308INSERT INTO `planning` VALUES ('11', '2017-10-26 00:00:00', -1, -1, -1, 78);
309INSERT INTO `planning` VALUES ('11', '2017-10-27 00:00:00', -1, -1, -1, 86);
310INSERT INTO `planning` VALUES ('11', '2017-11-01 00:00:00', 0, -1, -1, 129);
311INSERT INTO `planning` VALUES ('11', '2017-11-02 00:00:00', -1, -1, -1, 145);
312INSERT INTO `planning` VALUES ('11', '2017-11-03 00:00:00', 0, -1, -1, 11);
313INSERT INTO `planning` VALUES ('11', '2017-11-04 00:00:00', -1, -1, -1, 137);
314INSERT INTO `planning` VALUES ('11', '2017-11-20 00:00:00', -1, 0, 0, 159);
315INSERT INTO `planning` VALUES ('12', '2017-10-01 00:00:00', 0, -1, -1, 12);
316INSERT INTO `planning` VALUES ('12', '2017-10-02 00:00:00', 0, -1, -1, 29);
317INSERT INTO `planning` VALUES ('12', '2017-10-08 00:00:00', -1, -1, -1, 42);
318INSERT INTO `planning` VALUES ('12', '2017-10-09 00:00:00', -1, -1, -1, 42);
319INSERT INTO `planning` VALUES ('12', '2017-10-10 00:00:00', -1, -1, -1, 42);
320INSERT INTO `planning` VALUES ('12', '2017-10-20 00:00:00', -1, -1, -1, 101);
321INSERT INTO `planning` VALUES ('12', '2017-10-21 00:00:00', -1, -1, -1, 101);
322INSERT INTO `planning` VALUES ('12', '2017-10-22 00:00:00', -1, -1, -1, 101);
323INSERT INTO `planning` VALUES ('12', '2017-10-25 00:00:00', -1, -1, -1, 70);
324INSERT INTO `planning` VALUES ('12', '2017-10-27 00:00:00', 0, -1, -1, 87);
325INSERT INTO `planning` VALUES ('12', '2017-11-01 00:00:00', 0, -1, -1, 129);
326INSERT INTO `planning` VALUES ('12', '2017-11-02 00:00:00', 0, -1, -1, 146);
327INSERT INTO `planning` VALUES ('12', '2017-11-20 00:00:00', -1, 0, 0, 101);
328INSERT INTO `planning` VALUES ('12', '2017-11-21 00:00:00', -1, 0, 0, 101);
329INSERT INTO `planning` VALUES ('12', '2017-11-22 00:00:00', -1, 0, 0, 101);
330INSERT INTO `planning` VALUES ('2', '2017-10-01 00:00:00', -1, -1, -1, 14);
331INSERT INTO `planning` VALUES ('2', '2017-10-02 00:00:00', 0, -1, -1, 22);
332INSERT INTO `planning` VALUES ('2', '2017-10-03 00:00:00', -1, -1, -1, 2);
333INSERT INTO `planning` VALUES ('2', '2017-10-04 00:00:00', 0, -1, -1, 31);
334INSERT INTO `planning` VALUES ('2', '2017-10-08 00:00:00', 0, -1, -1, 47);
335INSERT INTO `planning` VALUES ('2', '2017-10-09 00:00:00', 0, -1, -1, 44);
336INSERT INTO `planning` VALUES ('2', '2017-10-12 00:00:00', -1, -1, -1, 58);
337INSERT INTO `planning` VALUES ('2', '2017-10-20 00:00:00', 0, -1, -1, 107);
338INSERT INTO `planning` VALUES ('2', '2017-10-21 00:00:00', 0, -1, -1, 104);
339INSERT INTO `planning` VALUES ('2', '2017-10-24 00:00:00', -1, -1, -1, 118);
340INSERT INTO `planning` VALUES ('2', '2017-10-25 00:00:00', -1, -1, -1, 60);
341INSERT INTO `planning` VALUES ('2', '2017-10-26 00:00:00', -1, -1, -1, 72);
342INSERT INTO `planning` VALUES ('2', '2017-10-27 00:00:00', 0, -1, -1, 80);
343INSERT INTO `planning` VALUES ('2', '2017-10-28 00:00:00', 0, -1, -1, 89);
344INSERT INTO `planning` VALUES ('2', '2017-11-01 00:00:00', -1, -1, -1, 120);
345INSERT INTO `planning` VALUES ('2', '2017-11-02 00:00:00', 0, -1, -1, 139);
346INSERT INTO `planning` VALUES ('2', '2017-11-04 00:00:00', 0, -1, -1, 148);
347INSERT INTO `planning` VALUES ('2', '2017-11-05 00:00:00', -1, -1, -1, 131);
348INSERT INTO `planning` VALUES ('2', '2017-11-20 00:00:00', -1, 0, 0, 107);
349INSERT INTO `planning` VALUES ('2', '2017-11-21 00:00:00', -1, 0, 0, 104);
350INSERT INTO `planning` VALUES ('3', '2017-10-01 00:00:00', 0, -1, -1, 15);
351INSERT INTO `planning` VALUES ('3', '2017-10-02 00:00:00', -1, -1, -1, 23);
352INSERT INTO `planning` VALUES ('3', '2017-10-03 00:00:00', 0, -1, -1, 3);
353INSERT INTO `planning` VALUES ('3', '2017-10-04 00:00:00', 0, -1, -1, 32);
354INSERT INTO `planning` VALUES ('3', '2017-10-05 00:00:00', 0, -1, -1, 35);
355INSERT INTO `planning` VALUES ('3', '2017-10-06 00:00:00', 0, -1, -1, 40);
356INSERT INTO `planning` VALUES ('3', '2017-10-07 00:00:00', 0, -1, -1, 41);
357INSERT INTO `planning` VALUES ('3', '2017-10-08 00:00:00', 0, -1, -1, 41);
358INSERT INTO `planning` VALUES ('3', '2017-10-09 00:00:00', 0, -1, -1, 45);
359INSERT INTO `planning` VALUES ('3', '2017-10-11 00:00:00', -1, -1, -1, 54);
360INSERT INTO `planning` VALUES ('3', '2017-10-12 00:00:00', -1, -1, -1, 54);
361INSERT INTO `planning` VALUES ('3', '2017-10-18 00:00:00', 0, -1, -1, 99);
362INSERT INTO `planning` VALUES ('3', '2017-10-19 00:00:00', 0, -1, -1, 100);
363INSERT INTO `planning` VALUES ('3', '2017-10-20 00:00:00', 0, -1, -1, 100);
364INSERT INTO `planning` VALUES ('3', '2017-10-21 00:00:00', 0, -1, -1, 105);
365INSERT INTO `planning` VALUES ('3', '2017-10-23 00:00:00', -1, -1, -1, 114);
366INSERT INTO `planning` VALUES ('3', '2017-10-24 00:00:00', -1, -1, -1, 114);
367INSERT INTO `planning` VALUES ('3', '2017-10-25 00:00:00', 0, -1, -1, 61);
368INSERT INTO `planning` VALUES ('3', '2017-10-26 00:00:00', 0, -1, -1, 73);
369INSERT INTO `planning` VALUES ('3', '2017-10-27 00:00:00', -1, -1, -1, 81);
370INSERT INTO `planning` VALUES ('3', '2017-10-28 00:00:00', 0, -1, -1, 90);
371INSERT INTO `planning` VALUES ('3', '2017-10-29 00:00:00', 0, -1, -1, 93);
372INSERT INTO `planning` VALUES ('3', '2017-11-01 00:00:00', 0, -1, -1, 121);
373INSERT INTO `planning` VALUES ('3', '2017-11-02 00:00:00', -1, -1, -1, 140);
374INSERT INTO `planning` VALUES ('3', '2017-11-03 00:00:00', 0, -1, -1, 132);
375INSERT INTO `planning` VALUES ('3', '2017-11-04 00:00:00', 0, -1, -1, 149);
376INSERT INTO `planning` VALUES ('3', '2017-11-05 00:00:00', 0, -1, -1, 153);
377INSERT INTO `planning` VALUES ('3', '2017-11-06 00:00:00', 0, -1, -1, 158);
378INSERT INTO `planning` VALUES ('3', '2017-11-18 00:00:00', 0, -1, -1, 99);
379INSERT INTO `planning` VALUES ('3', '2017-11-19 00:00:00', -1, 0, 0, 100);
380INSERT INTO `planning` VALUES ('3', '2017-11-20 00:00:00', -1, 0, 0, 100);
381INSERT INTO `planning` VALUES ('3', '2017-11-21 00:00:00', -1, 0, 0, 105);
382INSERT INTO `planning` VALUES ('3', '2017-11-29 00:00:00', -1, 0, 0, 93);
383INSERT INTO `planning` VALUES ('4', '2017-10-01 00:00:00', -1, -1, -1, 4);
384INSERT INTO `planning` VALUES ('4', '2017-10-02 00:00:00', -1, -1, -1, 4);
385INSERT INTO `planning` VALUES ('4', '2017-10-03 00:00:00', -1, -1, -1, 4);
386INSERT INTO `planning` VALUES ('4', '2017-10-05 00:00:00', 0, -1, -1, 36);
387INSERT INTO `planning` VALUES ('4', '2017-10-07 00:00:00', 0, -1, -1, 43);
388INSERT INTO `planning` VALUES ('4', '2017-10-08 00:00:00', -1, -1, -1, 48);
389INSERT INTO `planning` VALUES ('4', '2017-10-09 00:00:00', 0, -1, -1, 46);
390INSERT INTO `planning` VALUES ('4', '2017-10-11 00:00:00', -1, -1, -1, 55);
391INSERT INTO `planning` VALUES ('4', '2017-10-12 00:00:00', -1, -1, -1, 55);
392INSERT INTO `planning` VALUES ('4', '2017-10-19 00:00:00', 0, -1, -1, 102);
393INSERT INTO `planning` VALUES ('4', '2017-10-20 00:00:00', -1, -1, -1, 108);
394INSERT INTO `planning` VALUES ('4', '2017-10-21 00:00:00', 0, -1, -1, 106);
395INSERT INTO `planning` VALUES ('4', '2017-10-23 00:00:00', -1, -1, -1, 115);
396INSERT INTO `planning` VALUES ('4', '2017-10-24 00:00:00', -1, -1, -1, 115);
397INSERT INTO `planning` VALUES ('4', '2017-10-25 00:00:00', -1, -1, -1, 62);
398INSERT INTO `planning` VALUES ('4', '2017-10-26 00:00:00', -1, -1, -1, 62);
399INSERT INTO `planning` VALUES ('4', '2017-10-27 00:00:00', -1, -1, -1, 62);
400INSERT INTO `planning` VALUES ('4', '2017-10-28 00:00:00', -1, -1, -1, 74);
401INSERT INTO `planning` VALUES ('4', '2017-10-29 00:00:00', 0, -1, -1, 94);
402INSERT INTO `planning` VALUES ('4', '2017-11-01 00:00:00', -1, -1, -1, 122);
403INSERT INTO `planning` VALUES ('4', '2017-11-02 00:00:00', -1, -1, -1, 122);
404INSERT INTO `planning` VALUES ('4', '2017-11-03 00:00:00', -1, -1, -1, 122);
405INSERT INTO `planning` VALUES ('4', '2017-11-05 00:00:00', 0, -1, -1, 154);
406INSERT INTO `planning` VALUES ('4', '2017-11-19 00:00:00', -1, 0, 0, 102);
407INSERT INTO `planning` VALUES ('4', '2017-11-20 00:00:00', -1, 0, 0, 108);
408INSERT INTO `planning` VALUES ('4', '2017-11-21 00:00:00', -1, 0, 0, 106);
409INSERT INTO `planning` VALUES ('4', '2017-11-29 00:00:00', -1, 0, 0, 94);
410INSERT INTO `planning` VALUES ('5', '2017-10-01 00:00:00', -1, -1, -1, 16);
411INSERT INTO `planning` VALUES ('5', '2017-10-02 00:00:00', -1, -1, -1, 16);
412INSERT INTO `planning` VALUES ('5', '2017-10-03 00:00:00', -1, -1, -1, 16);
413INSERT INTO `planning` VALUES ('5', '2017-10-04 00:00:00', -1, -1, -1, 16);
414INSERT INTO `planning` VALUES ('5', '2017-10-05 00:00:00', -1, -1, -1, 37);
415INSERT INTO `planning` VALUES ('5', '2017-10-06 00:00:00', -1, -1, -1, 37);
416INSERT INTO `planning` VALUES ('5', '2017-10-07 00:00:00', 0, -1, -1, 44);
417INSERT INTO `planning` VALUES ('5', '2017-10-08 00:00:00', 0, -1, -1, 49);
418INSERT INTO `planning` VALUES ('5', '2017-10-09 00:00:00', 0, -1, -1, 47);
419INSERT INTO `planning` VALUES ('5', '2017-10-10 00:00:00', 0, -1, -1, 5);
420INSERT INTO `planning` VALUES ('5', '2017-10-11 00:00:00', -1, -1, -1, 56);
421INSERT INTO `planning` VALUES ('5', '2017-10-18 00:00:00', -1, -1, -1, 96);
422INSERT INTO `planning` VALUES ('5', '2017-10-19 00:00:00', 0, -1, -1, 104);
423INSERT INTO `planning` VALUES ('5', '2017-10-20 00:00:00', 0, -1, -1, 109);
424INSERT INTO `planning` VALUES ('5', '2017-10-21 00:00:00', 0, -1, -1, 107);
425INSERT INTO `planning` VALUES ('5', '2017-10-23 00:00:00', -1, -1, -1, 116);
426INSERT INTO `planning` VALUES ('5', '2017-10-25 00:00:00', 0, -1, -1, 63);
427INSERT INTO `planning` VALUES ('5', '2017-10-26 00:00:00', -1, -1, -1, 74);
428INSERT INTO `planning` VALUES ('5', '2017-10-27 00:00:00', -1, -1, -1, 74);
429INSERT INTO `planning` VALUES ('5', '2017-10-28 00:00:00', -1, -1, -1, 74);
430INSERT INTO `planning` VALUES ('5', '2017-10-29 00:00:00', -1, -1, -1, 95);
431INSERT INTO `planning` VALUES ('5', '2017-11-01 00:00:00', 0, -1, -1, 123);
432INSERT INTO `planning` VALUES ('5', '2017-11-02 00:00:00', -1, -1, -1, 133);
433INSERT INTO `planning` VALUES ('5', '2017-11-03 00:00:00', -1, -1, -1, 133);
434INSERT INTO `planning` VALUES ('5', '2017-11-04 00:00:00', -1, -1, -1, 133);
435INSERT INTO `planning` VALUES ('5', '2017-11-05 00:00:00', -1, -1, -1, 155);
436INSERT INTO `planning` VALUES ('5', '2017-11-06 00:00:00', -1, -1, -1, 155);
437INSERT INTO `planning` VALUES ('5', '2017-11-07 00:00:00', -1, -1, -1, 133);
438INSERT INTO `planning` VALUES ('5', '2017-11-18 00:00:00', -1, -1, -1, 96);
439INSERT INTO `planning` VALUES ('5', '2017-11-19 00:00:00', -1, 0, 0, 104);
440INSERT INTO `planning` VALUES ('5', '2017-11-20 00:00:00', -1, 0, 0, 109);
441INSERT INTO `planning` VALUES ('5', '2017-11-21 00:00:00', -1, 0, 0, 107);
442INSERT INTO `planning` VALUES ('5', '2017-11-29 00:00:00', -1, 0, 0, 95);
443INSERT INTO `planning` VALUES ('6', '2017-10-01 00:00:00', 0, -1, -1, 6);
444INSERT INTO `planning` VALUES ('6', '2017-10-02 00:00:00', 0, -1, -1, 24);
445INSERT INTO `planning` VALUES ('6', '2017-10-08 00:00:00', -1, -1, -1, 50);
446INSERT INTO `planning` VALUES ('6', '2017-10-09 00:00:00', 0, -1, -1, 48);
447INSERT INTO `planning` VALUES ('6', '2017-10-20 00:00:00', -1, -1, -1, 110);
448INSERT INTO `planning` VALUES ('6', '2017-10-21 00:00:00', 0, -1, -1, 18);
449INSERT INTO `planning` VALUES ('6', '2017-10-25 00:00:00', 0, -1, -1, 64);
450INSERT INTO `planning` VALUES ('6', '2017-10-27 00:00:00', 0, -1, -1, 82);
451INSERT INTO `planning` VALUES ('6', '2017-11-01 00:00:00', 0, -1, -1, 124);
452INSERT INTO `planning` VALUES ('6', '2017-11-02 00:00:00', 0, -1, -1, 141);
453INSERT INTO `planning` VALUES ('6', '2017-11-20 00:00:00', -1, 0, 0, 110);
454INSERT INTO `planning` VALUES ('6', '2017-11-21 00:00:00', -1, 0, 0, 135);
455INSERT INTO `planning` VALUES ('7', '2017-10-01 00:00:00', 0, -1, -1, 18);
456INSERT INTO `planning` VALUES ('7', '2017-10-02 00:00:00', 0, -1, -1, 18);
457INSERT INTO `planning` VALUES ('7', '2017-10-03 00:00:00', -1, -1, -1, 7);
458INSERT INTO `planning` VALUES ('7', '2017-10-07 00:00:00', 0, -1, -1, 45);
459INSERT INTO `planning` VALUES ('7', '2017-10-08 00:00:00', 0, -1, -1, 51);
460INSERT INTO `planning` VALUES ('7', '2017-10-09 00:00:00', 0, -1, -1, 49);
461INSERT INTO `planning` VALUES ('7', '2017-10-19 00:00:00', 0, -1, -1, 105);
462INSERT INTO `planning` VALUES ('7', '2017-10-20 00:00:00', 0, -1, -1, 111);
463INSERT INTO `planning` VALUES ('7', '2017-10-21 00:00:00', 0, -1, -1, 109);
464INSERT INTO `planning` VALUES ('7', '2017-10-25 00:00:00', -1, -1, -1, 65);
465INSERT INTO `planning` VALUES ('7', '2017-10-26 00:00:00', 0, -1, -1, 76);
466INSERT INTO `planning` VALUES ('7', '2017-10-27 00:00:00', 0, -1, -1, 76);
467INSERT INTO `planning` VALUES ('7', '2017-11-01 00:00:00', -1, -1, -1, 125);
468INSERT INTO `planning` VALUES ('7', '2017-11-02 00:00:00', 0, -1, -1, 135);
469INSERT INTO `planning` VALUES ('7', '2017-11-03 00:00:00', 0, -1, -1, 135);
470INSERT INTO `planning` VALUES ('7', '2017-11-19 00:00:00', -1, 0, 0, 105);
471INSERT INTO `planning` VALUES ('7', '2017-11-20 00:00:00', -1, 0, 0, 111);
472INSERT INTO `planning` VALUES ('7', '2017-11-21 00:00:00', -1, 0, 0, 109);
473INSERT INTO `planning` VALUES ('8', '2017-10-01 00:00:00', -1, -1, -1, 19);
474INSERT INTO `planning` VALUES ('8', '2017-10-02 00:00:00', 0, -1, -1, 25);
475INSERT INTO `planning` VALUES ('8', '2017-10-03 00:00:00', -1, -1, -1, 8);
476INSERT INTO `planning` VALUES ('8', '2017-10-04 00:00:00', 0, -1, -1, 17);
477INSERT INTO `planning` VALUES ('8', '2017-10-05 00:00:00', -1, -1, -1, 39);
478INSERT INTO `planning` VALUES ('8', '2017-10-06 00:00:00', -1, -1, -1, 39);
479INSERT INTO `planning` VALUES ('8', '2017-10-07 00:00:00', -1, -1, -1, 39);
480INSERT INTO `planning` VALUES ('8', '2017-10-08 00:00:00', -1, -1, -1, 52);
481INSERT INTO `planning` VALUES ('8', '2017-10-09 00:00:00', 0, -1, -1, 50);
482INSERT INTO `planning` VALUES ('8', '2017-10-11 00:00:00', -1, -1, -1, 57);
483INSERT INTO `planning` VALUES ('8', '2017-10-18 00:00:00', -1, -1, -1, 98);
484INSERT INTO `planning` VALUES ('8', '2017-10-19 00:00:00', -1, -1, -1, 98);
485INSERT INTO `planning` VALUES ('8', '2017-10-20 00:00:00', -1, -1, -1, 112);
486INSERT INTO `planning` VALUES ('8', '2017-10-21 00:00:00', 0, -1, -1, 110);
487INSERT INTO `planning` VALUES ('8', '2017-10-23 00:00:00', -1, -1, -1, 117);
488INSERT INTO `planning` VALUES ('8', '2017-10-25 00:00:00', -1, -1, -1, 66);
489INSERT INTO `planning` VALUES ('8', '2017-10-26 00:00:00', -1, -1, -1, 77);
490INSERT INTO `planning` VALUES ('8', '2017-10-27 00:00:00', 0, -1, -1, 83);
491INSERT INTO `planning` VALUES ('8', '2017-10-28 00:00:00', 0, -1, -1, 75);
492INSERT INTO `planning` VALUES ('8', '2017-10-29 00:00:00', -1, -1, -1, 98);
493INSERT INTO `planning` VALUES ('8', '2017-11-01 00:00:00', -1, -1, -1, 126);
494INSERT INTO `planning` VALUES ('8', '2017-11-02 00:00:00', 0, -1, -1, 142);
495INSERT INTO `planning` VALUES ('8', '2017-11-03 00:00:00', -1, -1, -1, 136);
496INSERT INTO `planning` VALUES ('8', '2017-11-04 00:00:00', 0, -1, -1, 134);
497INSERT INTO `planning` VALUES ('8', '2017-11-05 00:00:00', -1, -1, -1, 157);
498INSERT INTO `planning` VALUES ('8', '2017-11-06 00:00:00', -1, -1, -1, 157);
499INSERT INTO `planning` VALUES ('8', '2017-11-07 00:00:00', -1, -1, -1, 157);
500INSERT INTO `planning` VALUES ('8', '2017-11-18 00:00:00', -1, -1, -1, 98);
501INSERT INTO `planning` VALUES ('8', '2017-11-19 00:00:00', -1, 0, 0, 98);
502INSERT INTO `planning` VALUES ('8', '2017-11-21 00:00:00', -1, 0, 0, 110);
503INSERT INTO `planning` VALUES ('8', '2017-11-29 00:00:00', -1, 0, 0, 98);
504INSERT INTO `planning` VALUES ('9', '2017-10-01 00:00:00', 0, -1, -1, 19);
505INSERT INTO `planning` VALUES ('9', '2017-10-02 00:00:00', -1, -1, -1, 26);
506INSERT INTO `planning` VALUES ('9', '2017-10-04 00:00:00', -1, -1, -1, 33);
507INSERT INTO `planning` VALUES ('9', '2017-10-05 00:00:00', 0, -1, -1, 38);
508INSERT INTO `planning` VALUES ('9', '2017-10-06 00:00:00', 0, -1, -1, 38);
509INSERT INTO `planning` VALUES ('9', '2017-10-08 00:00:00', 0, -1, -1, 53);
510INSERT INTO `planning` VALUES ('9', '2017-10-09 00:00:00', 0, -1, -1, 51);
511INSERT INTO `planning` VALUES ('9', '2017-10-18 00:00:00', 0, -1, -1, 97);
512INSERT INTO `planning` VALUES ('9', '2017-10-20 00:00:00', 0, -1, -1, 113);
513INSERT INTO `planning` VALUES ('9', '2017-10-21 00:00:00', 0, -1, -1, 111);
514INSERT INTO `planning` VALUES ('9', '2017-10-25 00:00:00', 0, -1, -1, 67);
515INSERT INTO `planning` VALUES ('9', '2017-10-26 00:00:00', 0, -1, -1, 77);
516INSERT INTO `planning` VALUES ('9', '2017-10-27 00:00:00', -1, -1, -1, 84);
517INSERT INTO `planning` VALUES ('9', '2017-10-28 00:00:00', -1, -1, -1, 91);
518INSERT INTO `planning` VALUES ('9', '2017-10-29 00:00:00', 0, -1, -1, 97);
519INSERT INTO `planning` VALUES ('9', '2017-11-01 00:00:00', 0, -1, -1, 127);
520INSERT INTO `planning` VALUES ('9', '2017-11-02 00:00:00', -1, -1, -1, 143);
521INSERT INTO `planning` VALUES ('9', '2017-11-03 00:00:00', 0, 0, 0, 136);
522INSERT INTO `planning` VALUES ('9', '2017-11-04 00:00:00', -1, -1, -1, 150);
523INSERT INTO `planning` VALUES ('9', '2017-11-05 00:00:00', 0, -1, -1, 156);
524INSERT INTO `planning` VALUES ('9', '2017-11-06 00:00:00', 0, -1, -1, 156);
525INSERT INTO `planning` VALUES ('9', '2017-11-18 00:00:00', 0, -1, -1, 97);
526INSERT INTO `planning` VALUES ('9', '2017-11-21 00:00:00', -1, 0, 0, 111);
527INSERT INTO `planning` VALUES ('9', '2017-11-29 00:00:00', 0, 0, 0, 97);
528COMMIT;
529
530-- ----------------------------
531-- Table structure for tarifs
532-- ----------------------------
533DROP TABLE IF EXISTS `tarifs`;
534CREATE TABLE `tarifs` (
535  `codeTarif` char(2) NOT NULL DEFAULT '',
536  `prix` double NOT NULL DEFAULT '0',
537  PRIMARY KEY (`codeTarif`)
538) ENGINE=InnoDB DEFAULT CHARSET=latin1;
539
540-- ----------------------------
541-- Records of tarifs
542-- ----------------------------
543BEGIN;
544INSERT INTO `tarifs` VALUES ('1', 38);
545INSERT INTO `tarifs` VALUES ('2', 49);
546INSERT INTO `tarifs` VALUES ('3', 53);
547INSERT INTO `tarifs` VALUES ('4', 58);
548INSERT INTO `tarifs` VALUES ('5', 68);
549COMMIT;
550
551SET FOREIGN_KEY_CHECKS = 1;