YxhBAgDu

1-- phpMyAdmin SQL Dump
2-- version 4.1.4
3-- http://www.phpmyadmin.net
4--
5-- Client :  127.0.0.1
6-- Généré le :  Mar 17 Avril 2018 à 13:23
7-- Version du serveur :  5.6.15-log
8-- Version de PHP :  5.4.24
9
10SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
11SET time_zone = "+00:00";
12
13
14/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
15/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
16/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
17/*!40101 SET NAMES utf8 */;
18
19--
20-- Base de données :  `gsb_frais`
21--
22
23-- --------------------------------------------------------
24
25--
26-- Structure de la table `etat`
27--
28
29CREATE TABLE IF NOT EXISTS `etat` (
30  `id` char(2) NOT NULL,
31  `libelle` varchar(30) DEFAULT NULL,
32  PRIMARY KEY (`id`)
33) ENGINE=InnoDB DEFAULT CHARSET=utf8;
34
35--
36-- Contenu de la table `etat`
37--
38
39INSERT INTO `etat` (`id`, `libelle`) VALUES
40('CL', 'Fiche Signée, saisie clôturée'),
41('CR', 'Fiche créée, saisie en cours'),
42('MP', 'Mise en paiement'),
43('RB', 'Remboursée'),
44('VA', 'Validée');
45
46-- --------------------------------------------------------
47
48--
49-- Structure de la table `fichefrais`
50--
51
52CREATE TABLE IF NOT EXISTS `fichefrais` (
53  `idVisiteur` char(4) NOT NULL,
54  `mois` char(6) NOT NULL,
55  `nbJustificatifs` int(11) DEFAULT NULL,
56  `montantValide` decimal(10,2) DEFAULT NULL,
57  `dateModif` date DEFAULT NULL,
58  `idEtat` char(2) DEFAULT 'CR',
59  PRIMARY KEY (`idVisiteur`,`mois`),
60  KEY `idEtat` (`idEtat`)
61) ENGINE=InnoDB DEFAULT CHARSET=utf8;
62
63--
64-- Contenu de la table `fichefrais`
65--
66
67INSERT INTO `fichefrais` (`idVisiteur`, `mois`, `nbJustificatifs`, `montantValide`, `dateModif`, `idEtat`) VALUES
68('123', '201705', 0, '0.00', '2017-10-04', 'CR'),
69('123', '201706', 0, '0.00', '2017-10-04', 'CR'),
70('123', '201707', 0, '0.00', '2017-10-04', 'CR'),
71('123', '201708', 0, '0.00', '2017-10-04', 'CR'),
72('123', '201709', 0, '0.00', '2017-10-04', 'CR'),
73('123', '201710', 0, '1778031.30', '2017-10-04', 'CR'),
74('123', '201711', 0, '0.00', '2017-11-14', 'CR'),
75('a17', '201706', 0, '0.00', '2017-11-07', 'CR'),
76('a17', '201707', 0, '0.00', '2017-11-07', 'CR'),
77('a17', '201708', 0, '0.00', '2017-11-07', 'CR'),
78('a17', '201709', 0, '0.00', '2017-11-07', 'CR'),
79('a17', '201710', 0, '0.00', '2017-11-07', 'CR'),
80('a17', '201711', 0, '0.00', '2017-11-07', 'CR'),
81('a213', '201709', 0, '0.00', '2018-02-14', 'CR'),
82('a213', '201710', 0, '0.00', '2018-02-14', 'CR'),
83('a213', '201711', 0, '0.00', '2018-02-14', 'CR'),
84('a213', '201712', 0, '0.00', '2018-02-14', 'CR'),
85('a213', '201801', 0, '0.00', '2018-02-14', 'CR'),
86('a213', '201802', 0, '5425.90', '2018-02-14', 'CR'),
87('a55', '201704', 0, '0.00', '2017-09-27', 'CR'),
88('a55', '201705', 0, '0.00', '2017-09-27', 'CR'),
89('a55', '201706', 0, '0.00', '2017-09-27', 'CR'),
90('a55', '201707', 0, '0.00', '2017-09-27', 'CR'),
91('a55', '201708', 0, '3433.10', '2017-09-27', 'CR'),
92('a55', '201709', 0, '2524.30', '2017-09-27', 'CL'),
93('a55', '201710', 0, '0.00', '2017-11-07', 'CR'),
94('a55', '201711', 0, '0.00', '2017-11-07', 'CR'),
95('a55', '201712', 0, '0.00', '2018-02-14', 'CR'),
96('a55', '201801', 0, '0.00', '2018-02-14', 'CR'),
97('a55', '201802', 0, '0.00', '2018-02-14', 'CR'),
98('b13', '201705', 0, '0.00', '2017-10-17', 'CR'),
99('b13', '201706', 0, '0.00', '2017-10-17', 'CR'),
100('b13', '201707', 0, '0.00', '2017-10-17', 'CR'),
101('b13', '201708', 0, '0.00', '2017-10-17', 'CR'),
102('b13', '201709', 0, '0.00', '2017-10-17', 'CR'),
103('b13', '201710', 0, '0.00', '2017-10-17', 'CR'),
104('c3', '201705', 0, '0.00', '2017-10-03', 'CR'),
105('c3', '201706', 0, '0.00', '2017-10-03', 'CR'),
106('c3', '201707', 0, '0.00', '2017-10-03', 'CR'),
107('c3', '201708', 0, '0.00', '2017-10-03', 'CR'),
108('c3', '201709', 0, '0.00', '2017-10-03', 'CR'),
109('c3', '201710', 0, '2417.00', '2017-10-03', 'CR');
110
111-- --------------------------------------------------------
112
113--
114-- Structure de la table `fraisforfait`
115--
116
117CREATE TABLE IF NOT EXISTS `fraisforfait` (
118  `id` char(3) NOT NULL,
119  `libelle` char(20) DEFAULT NULL,
120  `montant` decimal(5,2) DEFAULT NULL,
121  PRIMARY KEY (`id`)
122) ENGINE=InnoDB DEFAULT CHARSET=utf8;
123
124--
125-- Contenu de la table `fraisforfait`
126--
127
128INSERT INTO `fraisforfait` (`id`, `libelle`, `montant`) VALUES
129('ETP', 'Forfait Etape', '110.00'),
130('KM', 'Frais Kilométrique', '0.62'),
131('NUI', 'Nuitée Hôtel', '80.00'),
132('REP', 'Repas Restaurant', '25.00');
133
134-- --------------------------------------------------------
135
136--
137-- Structure de la table `lignefraisforfait`
138--
139
140CREATE TABLE IF NOT EXISTS `lignefraisforfait` (
141  `idVisiteur` char(4) NOT NULL,
142  `mois` char(6) NOT NULL,
143  `idFraisForfait` char(3) NOT NULL,
144  `quantite` int(11) DEFAULT NULL,
145  `montantApplique` decimal(5,2) NOT NULL,
146  PRIMARY KEY (`idVisiteur`,`mois`,`idFraisForfait`),
147  KEY `idFraisForfait` (`idFraisForfait`)
148) ENGINE=InnoDB DEFAULT CHARSET=utf8;
149
150--
151-- Contenu de la table `lignefraisforfait`
152--
153
154INSERT INTO `lignefraisforfait` (`idVisiteur`, `mois`, `idFraisForfait`, `quantite`, `montantApplique`) VALUES
155('123', '201705', 'ETP', 0, '110.00'),
156('123', '201705', 'KM', 0, '0.62'),
157('123', '201705', 'NUI', 0, '80.00'),
158('123', '201705', 'REP', 0, '25.00'),
159('123', '201706', 'ETP', 0, '110.00'),
160('123', '201706', 'KM', 0, '0.62'),
161('123', '201706', 'NUI', 0, '80.00'),
162('123', '201706', 'REP', 0, '25.00'),
163('123', '201707', 'ETP', 0, '110.00'),
164('123', '201707', 'KM', 0, '0.62'),
165('123', '201707', 'NUI', 0, '80.00'),
166('123', '201707', 'REP', 0, '25.00'),
167('123', '201708', 'ETP', 0, '110.00'),
168('123', '201708', 'KM', 0, '0.62'),
169('123', '201708', 'NUI', 0, '80.00'),
170('123', '201708', 'REP', 0, '25.00'),
171('123', '201709', 'ETP', 0, '110.00'),
172('123', '201709', 'KM', 0, '0.62'),
173('123', '201709', 'NUI', 0, '80.00'),
174('123', '201709', 'REP', 0, '25.00'),
175('123', '201710', 'ETP', 20, '110.00'),
176('123', '201710', 'KM', 15115, '0.62'),
177('123', '201710', 'NUI', 22032, '80.00'),
178('123', '201710', 'REP', 156, '25.00'),
179('123', '201711', 'ETP', 0, '110.00'),
180('123', '201711', 'KM', 0, '0.62'),
181('123', '201711', 'NUI', 0, '80.00'),
182('123', '201711', 'REP', 0, '25.00'),
183('a17', '201706', 'ETP', 0, '110.00'),
184('a17', '201706', 'KM', 0, '0.62'),
185('a17', '201706', 'NUI', 0, '80.00'),
186('a17', '201706', 'REP', 0, '25.00'),
187('a17', '201707', 'ETP', 0, '110.00'),
188('a17', '201707', 'KM', 0, '0.62'),
189('a17', '201707', 'NUI', 0, '80.00'),
190('a17', '201707', 'REP', 0, '25.00'),
191('a17', '201708', 'ETP', 0, '110.00'),
192('a17', '201708', 'KM', 0, '0.62'),
193('a17', '201708', 'NUI', 0, '80.00'),
194('a17', '201708', 'REP', 0, '25.00'),
195('a17', '201709', 'ETP', 0, '110.00'),
196('a17', '201709', 'KM', 0, '0.62'),
197('a17', '201709', 'NUI', 0, '80.00'),
198('a17', '201709', 'REP', 0, '25.00'),
199('a17', '201710', 'ETP', 0, '110.00'),
200('a17', '201710', 'KM', 0, '0.62'),
201('a17', '201710', 'NUI', 0, '80.00'),
202('a17', '201710', 'REP', 0, '25.00'),
203('a17', '201711', 'ETP', 0, '110.00'),
204('a17', '201711', 'KM', 0, '0.62'),
205('a17', '201711', 'NUI', 0, '80.00'),
206('a17', '201711', 'REP', 0, '25.00'),
207('a213', '201709', 'ETP', 0, '110.00'),
208('a213', '201709', 'KM', 0, '0.62'),
209('a213', '201709', 'NUI', 0, '80.00'),
210('a213', '201709', 'REP', 0, '25.00'),
211('a213', '201710', 'ETP', 0, '110.00'),
212('a213', '201710', 'KM', 0, '0.62'),
213('a213', '201710', 'NUI', 0, '80.00'),
214('a213', '201710', 'REP', 0, '25.00'),
215('a213', '201711', 'ETP', 0, '110.00'),
216('a213', '201711', 'KM', 0, '0.62'),
217('a213', '201711', 'NUI', 0, '80.00'),
218('a213', '201711', 'REP', 0, '25.00'),
219('a213', '201712', 'ETP', 0, '110.00'),
220('a213', '201712', 'KM', 0, '0.62'),
221('a213', '201712', 'NUI', 0, '80.00'),
222('a213', '201712', 'REP', 0, '25.00'),
223('a213', '201801', 'ETP', 0, '110.00'),
224('a213', '201801', 'KM', 0, '0.62'),
225('a213', '201801', 'NUI', 0, '80.00'),
226('a213', '201801', 'REP', 0, '25.00'),
227('a213', '201802', 'ETP', 0, '110.00'),
228('a213', '201802', 'KM', 5445, '0.62'),
229('a213', '201802', 'NUI', 25, '80.00'),
230('a213', '201802', 'REP', 2, '25.00'),
231('a55', '201704', 'ETP', 0, '110.00'),
232('a55', '201704', 'KM', 0, '0.62'),
233('a55', '201704', 'NUI', 0, '80.00'),
234('a55', '201704', 'REP', 0, '25.00'),
235('a55', '201705', 'ETP', 0, '110.00'),
236('a55', '201705', 'KM', 0, '0.62'),
237('a55', '201705', 'NUI', 0, '80.00'),
238('a55', '201705', 'REP', 0, '25.00'),
239('a55', '201706', 'ETP', 0, '110.00'),
240('a55', '201706', 'KM', 0, '0.62'),
241('a55', '201706', 'NUI', 0, '80.00'),
242('a55', '201706', 'REP', 0, '25.00'),
243('a55', '201707', 'ETP', 0, '110.00'),
244('a55', '201707', 'KM', 0, '0.62'),
245('a55', '201707', 'NUI', 0, '80.00'),
246('a55', '201707', 'REP', 0, '25.00'),
247('a55', '201708', 'ETP', 30, '110.00'),
248('a55', '201708', 'KM', 5, '0.62'),
249('a55', '201708', 'NUI', 1, '80.00'),
250('a55', '201708', 'REP', 2, '25.00'),
251('a55', '201709', 'ETP', 20, '110.00'),
252('a55', '201709', 'KM', 15, '0.62'),
253('a55', '201709', 'NUI', 3, '80.00'),
254('a55', '201709', 'REP', 3, '25.00'),
255('a55', '201710', 'ETP', 0, '110.00'),
256('a55', '201710', 'KM', 0, '0.62'),
257('a55', '201710', 'NUI', 0, '80.00'),
258('a55', '201710', 'REP', 0, '25.00'),
259('a55', '201711', 'ETP', 0, '110.00'),
260('a55', '201711', 'KM', 0, '0.62'),
261('a55', '201711', 'NUI', 0, '80.00'),
262('a55', '201711', 'REP', 0, '25.00'),
263('a55', '201712', 'ETP', 0, '110.00'),
264('a55', '201712', 'KM', 0, '0.62'),
265('a55', '201712', 'NUI', 0, '80.00'),
266('a55', '201712', 'REP', 0, '25.00'),
267('a55', '201801', 'ETP', 0, '110.00'),
268('a55', '201801', 'KM', 0, '0.62'),
269('a55', '201801', 'NUI', 0, '80.00'),
270('a55', '201801', 'REP', 0, '25.00'),
271('a55', '201802', 'ETP', 0, '110.00'),
272('a55', '201802', 'KM', 0, '0.62'),
273('a55', '201802', 'NUI', 0, '80.00'),
274('a55', '201802', 'REP', 0, '25.00'),
275('b13', '201705', 'ETP', 0, '110.00'),
276('b13', '201705', 'KM', 0, '0.62'),
277('b13', '201705', 'NUI', 0, '80.00'),
278('b13', '201705', 'REP', 0, '25.00'),
279('b13', '201706', 'ETP', 0, '110.00'),
280('b13', '201706', 'KM', 0, '0.62'),
281('b13', '201706', 'NUI', 0, '80.00'),
282('b13', '201706', 'REP', 0, '25.00'),
283('b13', '201707', 'ETP', 0, '110.00'),
284('b13', '201707', 'KM', 0, '0.62'),
285('b13', '201707', 'NUI', 0, '80.00'),
286('b13', '201707', 'REP', 0, '25.00'),
287('b13', '201708', 'ETP', 0, '110.00'),
288('b13', '201708', 'KM', 0, '0.62'),
289('b13', '201708', 'NUI', 0, '80.00'),
290('b13', '201708', 'REP', 0, '25.00'),
291('b13', '201709', 'ETP', 0, '110.00'),
292('b13', '201709', 'KM', 0, '0.62'),
293('b13', '201709', 'NUI', 0, '80.00'),
294('b13', '201709', 'REP', 0, '25.00'),
295('b13', '201710', 'ETP', 0, '110.00'),
296('b13', '201710', 'KM', 0, '0.62'),
297('b13', '201710', 'NUI', 0, '80.00'),
298('b13', '201710', 'REP', 0, '25.00'),
299('c3', '201705', 'ETP', 0, '110.00'),
300('c3', '201705', 'KM', 0, '0.62'),
301('c3', '201705', 'NUI', 0, '80.00'),
302('c3', '201705', 'REP', 0, '25.00'),
303('c3', '201706', 'ETP', 0, '110.00'),
304('c3', '201706', 'KM', 0, '0.62'),
305('c3', '201706', 'NUI', 0, '80.00'),
306('c3', '201706', 'REP', 0, '25.00'),
307('c3', '201707', 'ETP', 0, '110.00'),
308('c3', '201707', 'KM', 0, '0.62'),
309('c3', '201707', 'NUI', 0, '80.00'),
310('c3', '201707', 'REP', 0, '25.00'),
311('c3', '201708', 'ETP', 0, '110.00'),
312('c3', '201708', 'KM', 0, '0.62'),
313('c3', '201708', 'NUI', 0, '80.00'),
314('c3', '201708', 'REP', 0, '25.00'),
315('c3', '201709', 'ETP', 0, '110.00'),
316('c3', '201709', 'KM', 0, '0.62'),
317('c3', '201709', 'NUI', 0, '80.00'),
318('c3', '201709', 'REP', 0, '25.00'),
319('c3', '201710', 'ETP', 20, '110.00'),
320('c3', '201710', 'KM', 100, '0.62'),
321('c3', '201710', 'NUI', 1, '80.00'),
322('c3', '201710', 'REP', 3, '25.00');
323
324-- --------------------------------------------------------
325
326--
327-- Structure de la table `lignefraishorsforfait`
328--
329
330CREATE TABLE IF NOT EXISTS `lignefraishorsforfait` (
331  `id` int(11) NOT NULL AUTO_INCREMENT,
332  `idVisiteur` char(4) NOT NULL,
333  `mois` char(6) NOT NULL,
334  `libelle` varchar(100) DEFAULT NULL,
335  `date` date DEFAULT NULL,
336  `montant` decimal(10,2) DEFAULT NULL,
337  PRIMARY KEY (`id`),
338  KEY `idVisiteur` (`idVisiteur`,`mois`)
339) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=6 ;
340
341--
342-- Contenu de la table `lignefraishorsforfait`
343--
344
345INSERT INTO `lignefraishorsforfait` (`id`, `idVisiteur`, `mois`, `libelle`, `date`, `montant`) VALUES
346(2, 'a55', '201708', '', '1999-01-01', '20.00'),
347(3, 'a55', '201708', 'ullu', '1970-01-01', '0.00'),
348(4, 'a55', '201708', '', '1970-01-01', '88.00'),
349(5, 'a55', '201708', '', '1970-01-01', '0.00');
350
351-- --------------------------------------------------------
352
353--
354-- Structure de la table `utilisateur`
355--
356
357CREATE TABLE IF NOT EXISTS `utilisateur` (
358  `id` char(4) NOT NULL,
359  `nom` char(30) DEFAULT NULL,
360  `prenom` char(30) DEFAULT NULL,
361  `login` char(20) DEFAULT NULL,
362  `mdp` char(20) DEFAULT NULL,
363  `adresse` char(30) DEFAULT NULL,
364  `cp` char(5) DEFAULT NULL,
365  `ville` char(30) DEFAULT NULL,
366  `dateEmbauche` date DEFAULT NULL,
367  `metier` varchar(30) DEFAULT NULL,
368  PRIMARY KEY (`id`)
369) ENGINE=InnoDB DEFAULT CHARSET=utf8;
370
371--
372-- Contenu de la table `utilisateur`
373--
374
375INSERT INTO `utilisateur` (`id`, `nom`, `prenom`, `login`, `mdp`, `adresse`, `cp`, `ville`, `dateEmbauche`, `metier`) VALUES
376('123', 'KB', 'Quentin', 'qkb', '0000', '12 rue du Charmes', '56000', 'Rouen', '2003-12-21', 'comptable'),
377('a131', 'Villachane', 'Louis', 'lvillachane', 'jux7g', '8 rue des Charmes', '46000', 'Cahors', '2005-12-21', 'visiteur'),
378('a17', 'Andre', 'David', 'dandre', 'oppg5', '1 rue Petit', '46200', 'Lalbenque', '1998-11-23', 'visiteur'),
379('a213', 'Georges', 'Mac', 'mac', '1234', '12 allée du francolin', '13000', 'fois', '2018-02-04', 'visiteur'),
380('a55', 'Bedos', 'Christian', 'cbedos', 'gmhxd', '1 rue Peranud', '46250', 'Montcuq', '1995-01-12', 'visiteur'),
381('a93', 'Tusseau', 'Louis', 'ltusseau', 'ktp3s', '22 rue des Ternes', '46123', 'Gramat', '2000-05-01', 'visiteur'),
382('b13', 'Bentot', 'Pascal', 'pbentot', 'doyw1', '11 allée des Cerises', '46512', 'Bessines', '1992-07-09', 'visiteur'),
383('b16', 'Bioret', 'Luc', 'lbioret', 'hrjfs', '1 Avenue gambetta', '46000', 'Cahors', '1998-05-11', 'visiteur'),
384('b19', 'Bunisset', 'Francis', 'fbunisset', '4vbnd', '10 rue des Perles', '93100', 'Montreuil', '1987-10-21', 'visiteur'),
385('b25', 'Bunisset', 'Denise', 'dbunisset', 's1y1r', '23 rue Manin', '75019', 'paris', '2010-12-05', 'visiteur'),
386('b28', 'Cacheux', 'Bernard', 'bcacheux', 'uf7r3', '114 rue Blanche', '75017', 'Paris', '2009-11-12', 'visiteur'),
387('b34', 'Cadic', 'Eric', 'ecadic', '6u8dc', '123 avenue de la République', '75011', 'Paris', '2008-09-23', 'visiteur'),
388('b4', 'Charoze', 'Catherine', 'ccharoze', 'u817o', '100 rue Petit', '75019', 'Paris', '2005-11-12', 'visiteur'),
389('b50', 'Clepkens', 'Christophe', 'cclepkens', 'bw1us', '12 allée des Anges', '93230', 'Romainville', '2003-08-11', 'visiteur'),
390('b59', 'Cottin', 'Vincenne', 'vcottin', '2hoh9', '36 rue Des Roches', '93100', 'Monteuil', '2001-11-18', 'visiteur'),
391('c14', 'Daburon', 'François', 'fdaburon', '7oqpv', '13 rue de Chanzy', '94000', 'Créteil', '2002-02-11', 'visiteur'),
392('c3', 'De', 'Philippe', 'pde', 'gk9kx', '13 rue Barthes', '94000', 'Créteil', '2010-12-14', 'visiteur'),
393('c54', 'Debelle', 'Michel', 'mdebelle', 'od5rt', '181 avenue Barbusse', '93210', 'Rosny', '2006-11-23', 'visiteur'),
394('d13', 'Debelle', 'Jeanne', 'jdebelle', 'nvwqq', '134 allée des Joncs', '44000', 'Nantes', '2000-05-11', 'visiteur'),
395('d51', 'Debroise', 'Michel', 'mdebroise', 'sghkb', '2 Bld Jourdain', '44000', 'Nantes', '2001-04-17', 'visiteur'),
396('e22', 'Desmarquest', 'Nathalie', 'ndesmarquest', 'f1fob', '14 Place d Arc', '45000', 'Orléans', '2005-11-12', 'visiteur'),
397('e24', 'Desnost', 'Pierre', 'pdesnost', '4k2o5', '16 avenue des Cèdres', '23200', 'Guéret', '2001-02-05', 'visiteur'),
398('e39', 'Dudouit', 'Frédéric', 'fdudouit', '44im8', '18 rue de l église', '23120', 'GrandBourg', '2000-08-01', 'visiteur'),
399('e49', 'Duncombe', 'Claude', 'cduncombe', 'qf77j', '19 rue de la tour', '23100', 'La souteraine', '1987-10-10', 'visiteur'),
400('e5', 'Enault-Pascreau', 'Céline', 'cenault', 'y2qdu', '25 place de la gare', '23200', 'Gueret', '1995-09-01', 'visiteur'),
401('e52', 'Eynde', 'Valérie', 'veynde', 'i7sn3', '3 Grand Place', '13015', 'Marseille', '1999-11-01', 'visiteur'),
402('f21', 'Finck', 'Jacques', 'jfinck', 'mpb3t', '10 avenue du Prado', '13002', 'Marseille', '2001-11-10', 'visiteur'),
403('f39', 'Frémont', 'Fernande', 'ffremont', 'xs5tq', '4 route de la mer', '13012', 'Allauh', '1998-10-01', 'visiteur'),
404('f4', 'Gest', 'Alain', 'agest', 'dywvt', '30 avenue de la mer', '13025', 'Berre', '1985-11-01', 'visiteur');
405
406--
407-- Contraintes pour les tables exportées
408--
409
410--
411-- Contraintes pour la table `fichefrais`
412--
413ALTER TABLE `fichefrais`
414  ADD CONSTRAINT `fichefrais_ibfk_1` FOREIGN KEY (`idEtat`) REFERENCES `etat` (`id`),
415  ADD CONSTRAINT `fichefrais_ibfk_2` FOREIGN KEY (`idVisiteur`) REFERENCES `utilisateur` (`id`);
416
417--
418-- Contraintes pour la table `lignefraisforfait`
419--
420ALTER TABLE `lignefraisforfait`
421  ADD CONSTRAINT `lignefraisforfait_ibfk_1` FOREIGN KEY (`idVisiteur`, `mois`) REFERENCES `fichefrais` (`idVisiteur`, `mois`),
422  ADD CONSTRAINT `lignefraisforfait_ibfk_2` FOREIGN KEY (`idFraisForfait`) REFERENCES `fraisforfait` (`id`);
423
424--
425-- Contraintes pour la table `lignefraishorsforfait`
426--
427ALTER TABLE `lignefraishorsforfait`
428  ADD CONSTRAINT `lignefraishorsforfait_ibfk_1` FOREIGN KEY (`idVisiteur`, `mois`) REFERENCES `fichefrais` (`idVisiteur`, `mois`);
429
430/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
431/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
432/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;