· 8 years ago · Apr 09, 2018, 09:02 PM
1-- MySQL dump 10.13 Distrib 5.5.15, for Win32 (x86)
2--
3-- Host: localhost Database: db_horens
4-- ------------------------------------------------------
5-- Server version 5.5.16
6
7/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
8/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
9/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
10/*!40101 SET NAMES utf8 */;
11/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
12/*!40103 SET TIME_ZONE='+00:00' */;
13/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
14/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
15/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
16/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
17
18--
19-- Current Database: `db_horens`
20--
21
22CREATE DATABASE /*!32312 IF NOT EXISTS*/ `db_horens` /*!40100 DEFAULT CHARACTER SET utf8 */;
23
24USE `db_horens`;
25
26--
27-- Table structure for table `auth_compte`
28--
29
30DROP TABLE IF EXISTS `auth_compte`;
31/*!40101 SET @saved_cs_client = @@character_set_client */;
32/*!40101 SET character_set_client = utf8 */;
33CREATE TABLE `auth_compte` (
34 `nomUtilisateur` varchar(255) COLLATE latin1_general_ci NOT NULL,
35 `motDePasse` varchar(255) COLLATE latin1_general_ci NOT NULL,
36 `eMail` varchar(255) COLLATE latin1_general_ci DEFAULT NULL,
37 `idGroupeLie` int(11) NOT NULL,
38 `nom` varchar(255) COLLATE latin1_general_ci NOT NULL,
39 `prenom` varchar(45) COLLATE latin1_general_ci NOT NULL,
40 `derniereConnexion` varchar(45) COLLATE latin1_general_ci DEFAULT NULL,
41 `idCompte` int(11) NOT NULL,
42 PRIMARY KEY (`idCompte`),
43 KEY `fk_groupe` (`idGroupeLie`),
44 CONSTRAINT `fk_groupe` FOREIGN KEY (`idGroupeLie`) REFERENCES `auth_groupe` (`idGroupe`) ON DELETE NO ACTION ON UPDATE NO ACTION
45) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;
46/*!40101 SET character_set_client = @saved_cs_client */;
47
48--
49-- Dumping data for table `auth_compte`
50--
51
52LOCK TABLES `auth_compte` WRITE;
53/*!40000 ALTER TABLE `auth_compte` DISABLE KEYS */;
54/*!40000 ALTER TABLE `auth_compte` ENABLE KEYS */;
55UNLOCK TABLES;
56
57--
58-- Table structure for table `auth_groupe`
59--
60
61DROP TABLE IF EXISTS `auth_groupe`;
62/*!40101 SET @saved_cs_client = @@character_set_client */;
63/*!40101 SET character_set_client = utf8 */;
64CREATE TABLE `auth_groupe` (
65 `idGroupe` int(11) NOT NULL,
66 `nom` varchar(255) NOT NULL,
67 `idGroupePermissionLie` int(11) DEFAULT NULL,
68 PRIMARY KEY (`idGroupe`),
69 KEY `fk_groupePermission` (`idGroupePermissionLie`),
70 CONSTRAINT `fk_groupePermission` FOREIGN KEY (`idGroupePermissionLie`) REFERENCES `auth_groupepermission` (`idGroupePermission`) ON DELETE NO ACTION ON UPDATE NO ACTION
71) ENGINE=InnoDB DEFAULT CHARSET=utf8;
72/*!40101 SET character_set_client = @saved_cs_client */;
73
74--
75-- Dumping data for table `auth_groupe`
76--
77
78LOCK TABLES `auth_groupe` WRITE;
79/*!40000 ALTER TABLE `auth_groupe` DISABLE KEYS */;
80/*!40000 ALTER TABLE `auth_groupe` ENABLE KEYS */;
81UNLOCK TABLES;
82
83--
84-- Table structure for table `auth_groupepermission`
85--
86
87DROP TABLE IF EXISTS `auth_groupepermission`;
88/*!40101 SET @saved_cs_client = @@character_set_client */;
89/*!40101 SET character_set_client = utf8 */;
90CREATE TABLE `auth_groupepermission` (
91 `idGroupePermission` int(11) NOT NULL,
92 `permissionLiee` int(11) DEFAULT NULL,
93 PRIMARY KEY (`idGroupePermission`),
94 KEY `fk_permission` (`idGroupePermission`),
95 CONSTRAINT `fk_permission` FOREIGN KEY (`idGroupePermission`) REFERENCES `auth_permission` (`idPermission`) ON DELETE NO ACTION ON UPDATE NO ACTION
96) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;
97/*!40101 SET character_set_client = @saved_cs_client */;
98
99--
100-- Dumping data for table `auth_groupepermission`
101--
102
103LOCK TABLES `auth_groupepermission` WRITE;
104/*!40000 ALTER TABLE `auth_groupepermission` DISABLE KEYS */;
105/*!40000 ALTER TABLE `auth_groupepermission` ENABLE KEYS */;
106UNLOCK TABLES;
107
108--
109-- Table structure for table `auth_permission`
110--
111
112DROP TABLE IF EXISTS `auth_permission`;
113/*!40101 SET @saved_cs_client = @@character_set_client */;
114/*!40101 SET character_set_client = utf8 */;
115CREATE TABLE `auth_permission` (
116 `idPermission` int(11) NOT NULL,
117 `intitule` varchar(255) COLLATE latin1_general_ci NOT NULL,
118 PRIMARY KEY (`idPermission`)
119) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;
120/*!40101 SET character_set_client = @saved_cs_client */;
121
122--
123-- Dumping data for table `auth_permission`
124--
125
126LOCK TABLES `auth_permission` WRITE;
127/*!40000 ALTER TABLE `auth_permission` DISABLE KEYS */;
128/*!40000 ALTER TABLE `auth_permission` ENABLE KEYS */;
129UNLOCK TABLES;
130
131--
132-- Table structure for table `ens_composante`
133--
134
135DROP TABLE IF EXISTS `ens_composante`;
136/*!40101 SET @saved_cs_client = @@character_set_client */;
137/*!40101 SET character_set_client = utf8 */;
138CREATE TABLE `ens_composante` (
139 `idcomposante` int(11) NOT NULL,
140 `nom` varchar(255) NOT NULL,
141 `formationLie` int(11) NOT NULL,
142 PRIMARY KEY (`idcomposante`),
143 KEY `fk_formation` (`formationLie`),
144 CONSTRAINT `fk_formation` FOREIGN KEY (`formationLie`) REFERENCES `ens_formation` (`idformation`) ON DELETE NO ACTION ON UPDATE NO ACTION
145) ENGINE=InnoDB DEFAULT CHARSET=ascii;
146/*!40101 SET character_set_client = @saved_cs_client */;
147
148--
149-- Dumping data for table `ens_composante`
150--
151
152LOCK TABLES `ens_composante` WRITE;
153/*!40000 ALTER TABLE `ens_composante` DISABLE KEYS */;
154/*!40000 ALTER TABLE `ens_composante` ENABLE KEYS */;
155UNLOCK TABLES;
156
157--
158-- Table structure for table `ens_cours`
159--
160
161DROP TABLE IF EXISTS `ens_cours`;
162/*!40101 SET @saved_cs_client = @@character_set_client */;
163/*!40101 SET character_set_client = utf8 */;
164CREATE TABLE `ens_cours` (
165 `idcours` int(11) NOT NULL,
166 `moduleLie` int(11) NOT NULL,
167 `enseignantLie` int(11) NOT NULL,
168 `typeCours` int(11) NOT NULL,
169 `numeroSemaine` int(11) NOT NULL,
170 `promotion` int(11) NOT NULL,
171 `valide` int(11) DEFAULT NULL,
172 PRIMARY KEY (`idcours`),
173 KEY `fk_enseignantCours` (`enseignantLie`),
174 KEY `fk_typeCours` (`typeCours`),
175 KEY `fk_module` (`moduleLie`),
176 CONSTRAINT `fk_enseignantCours` FOREIGN KEY (`enseignantLie`) REFERENCES `prof_enseignant` (`idenseignant`) ON DELETE NO ACTION ON UPDATE NO ACTION,
177 CONSTRAINT `fk_typeCours` FOREIGN KEY (`typeCours`) REFERENCES `ens_typecours` (`idTypeCours`) ON DELETE NO ACTION ON UPDATE NO ACTION,
178 CONSTRAINT `fk_module` FOREIGN KEY (`moduleLie`) REFERENCES `ens_module` (`idmodule`) ON DELETE NO ACTION ON UPDATE NO ACTION
179) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;
180/*!40101 SET character_set_client = @saved_cs_client */;
181
182--
183-- Dumping data for table `ens_cours`
184--
185
186LOCK TABLES `ens_cours` WRITE;
187/*!40000 ALTER TABLE `ens_cours` DISABLE KEYS */;
188/*!40000 ALTER TABLE `ens_cours` ENABLE KEYS */;
189UNLOCK TABLES;
190
191--
192-- Table structure for table `ens_departement`
193--
194
195DROP TABLE IF EXISTS `ens_departement`;
196/*!40101 SET @saved_cs_client = @@character_set_client */;
197/*!40101 SET character_set_client = utf8 */;
198CREATE TABLE `ens_departement` (
199 `iddepartement` int(11) NOT NULL,
200 `nom` varchar(255) NOT NULL,
201 `chefDepartement` int(11) NOT NULL,
202 PRIMARY KEY (`iddepartement`),
203 KEY `fk_chefDepartement` (`chefDepartement`),
204 CONSTRAINT `fk_chefDepartement` FOREIGN KEY (`chefDepartement`) REFERENCES `prof_enseignant` (`idenseignant`) ON DELETE NO ACTION ON UPDATE NO ACTION
205) ENGINE=InnoDB DEFAULT CHARSET=utf8;
206/*!40101 SET character_set_client = @saved_cs_client */;
207
208--
209-- Dumping data for table `ens_departement`
210--
211
212LOCK TABLES `ens_departement` WRITE;
213/*!40000 ALTER TABLE `ens_departement` DISABLE KEYS */;
214/*!40000 ALTER TABLE `ens_departement` ENABLE KEYS */;
215UNLOCK TABLES;
216
217--
218-- Table structure for table `ens_elementsuivit`
219--
220
221DROP TABLE IF EXISTS `ens_elementsuivit`;
222/*!40101 SET @saved_cs_client = @@character_set_client */;
223/*!40101 SET character_set_client = utf8 */;
224CREATE TABLE `ens_elementsuivit` (
225 `nom` varchar(255) COLLATE latin1_general_ci NOT NULL,
226 `idSuivit` int(11) NOT NULL,
227 PRIMARY KEY (`idSuivit`)
228) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;
229/*!40101 SET character_set_client = @saved_cs_client */;
230
231--
232-- Dumping data for table `ens_elementsuivit`
233--
234
235LOCK TABLES `ens_elementsuivit` WRITE;
236/*!40000 ALTER TABLE `ens_elementsuivit` DISABLE KEYS */;
237/*!40000 ALTER TABLE `ens_elementsuivit` ENABLE KEYS */;
238UNLOCK TABLES;
239
240--
241-- Table structure for table `ens_formation`
242--
243
244DROP TABLE IF EXISTS `ens_formation`;
245/*!40101 SET @saved_cs_client = @@character_set_client */;
246/*!40101 SET character_set_client = utf8 */;
247CREATE TABLE `ens_formation` (
248 `idformation` int(11) NOT NULL,
249 `nom` varchar(255) COLLATE latin1_general_ci NOT NULL,
250 `departementLie` int(11) NOT NULL,
251 `niveau` int(11) NOT NULL,
252 PRIMARY KEY (`idformation`),
253 KEY `fk_departementFormation` (`departementLie`),
254 CONSTRAINT `fk_departementFormation` FOREIGN KEY (`departementLie`) REFERENCES `ens_departement` (`iddepartement`) ON DELETE NO ACTION ON UPDATE NO ACTION
255) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;
256/*!40101 SET character_set_client = @saved_cs_client */;
257
258--
259-- Dumping data for table `ens_formation`
260--
261
262LOCK TABLES `ens_formation` WRITE;
263/*!40000 ALTER TABLE `ens_formation` DISABLE KEYS */;
264/*!40000 ALTER TABLE `ens_formation` ENABLE KEYS */;
265UNLOCK TABLES;
266
267--
268-- Table structure for table `ens_module`
269--
270
271DROP TABLE IF EXISTS `ens_module`;
272/*!40101 SET @saved_cs_client = @@character_set_client */;
273/*!40101 SET character_set_client = utf8 */;
274CREATE TABLE `ens_module` (
275 `idmodule` int(11) NOT NULL,
276 `nom` varchar(255) COLLATE latin1_general_ci NOT NULL,
277 `codeApogee` varchar(10) COLLATE latin1_general_ci NOT NULL,
278 `composanteLie` int(11) NOT NULL,
279 PRIMARY KEY (`idmodule`),
280 KEY `fk_composante` (`composanteLie`),
281 CONSTRAINT `fk_composante` FOREIGN KEY (`composanteLie`) REFERENCES `ens_composante` (`idcomposante`) ON DELETE NO ACTION ON UPDATE NO ACTION
282) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;
283/*!40101 SET character_set_client = @saved_cs_client */;
284
285--
286-- Dumping data for table `ens_module`
287--
288
289LOCK TABLES `ens_module` WRITE;
290/*!40000 ALTER TABLE `ens_module` DISABLE KEYS */;
291/*!40000 ALTER TABLE `ens_module` ENABLE KEYS */;
292UNLOCK TABLES;
293
294--
295-- Table structure for table `ens_prp`
296--
297
298DROP TABLE IF EXISTS `ens_prp`;
299/*!40101 SET @saved_cs_client = @@character_set_client */;
300/*!40101 SET character_set_client = utf8 */;
301CREATE TABLE `ens_prp` (
302 `idprp` int(11) NOT NULL,
303 `titre` varchar(255) CHARACTER SET utf8 NOT NULL,
304 `nombreHeures` int(11) DEFAULT NULL,
305 PRIMARY KEY (`idprp`)
306) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;
307/*!40101 SET character_set_client = @saved_cs_client */;
308
309--
310-- Dumping data for table `ens_prp`
311--
312
313LOCK TABLES `ens_prp` WRITE;
314/*!40000 ALTER TABLE `ens_prp` DISABLE KEYS */;
315/*!40000 ALTER TABLE `ens_prp` ENABLE KEYS */;
316UNLOCK TABLES;
317
318--
319-- Table structure for table `ens_prpobtenu`
320--
321
322DROP TABLE IF EXISTS `ens_prpobtenu`;
323/*!40101 SET @saved_cs_client = @@character_set_client */;
324/*!40101 SET character_set_client = utf8 */;
325CREATE TABLE `ens_prpobtenu` (
326 `prpLie` int(11) NOT NULL,
327 `enseignantLie` int(11) NOT NULL,
328 `promotion` int(11) NOT NULL,
329 PRIMARY KEY (`prpLie`,`enseignantLie`,`promotion`),
330 KEY `fk_prp` (`prpLie`),
331 KEY `fk_enseignantprp` (`enseignantLie`),
332 CONSTRAINT `fk_enseignantprp` FOREIGN KEY (`enseignantLie`) REFERENCES `prof_enseignant` (`idenseignant`) ON DELETE NO ACTION ON UPDATE NO ACTION,
333 CONSTRAINT `fk_prp` FOREIGN KEY (`prpLie`) REFERENCES `ens_prp` (`idprp`) ON DELETE NO ACTION ON UPDATE NO ACTION
334) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;
335/*!40101 SET character_set_client = @saved_cs_client */;
336
337--
338-- Dumping data for table `ens_prpobtenu`
339--
340
341LOCK TABLES `ens_prpobtenu` WRITE;
342/*!40000 ALTER TABLE `ens_prpobtenu` DISABLE KEYS */;
343/*!40000 ALTER TABLE `ens_prpobtenu` ENABLE KEYS */;
344UNLOCK TABLES;
345
346--
347-- Table structure for table `ens_suit`
348--
349
350DROP TABLE IF EXISTS `ens_suit`;
351/*!40101 SET @saved_cs_client = @@character_set_client */;
352/*!40101 SET character_set_client = utf8 */;
353CREATE TABLE `ens_suit` (
354 `enseignantLie` int(11) NOT NULL,
355 `suivitLie` int(11) NOT NULL,
356 `nombreHeures` int(11) NOT NULL,
357 `promotion` int(11) NOT NULL,
358 PRIMARY KEY (`enseignantLie`,`promotion`,`nombreHeures`,`suivitLie`),
359 KEY `fk_enseignantSuivit` (`suivitLie`),
360 CONSTRAINT `fk_enseignantSuivit` FOREIGN KEY (`suivitLie`) REFERENCES `ens_elementsuivit` (`idSuivit`) ON DELETE NO ACTION ON UPDATE NO ACTION
361) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;
362/*!40101 SET character_set_client = @saved_cs_client */;
363
364--
365-- Dumping data for table `ens_suit`
366--
367
368LOCK TABLES `ens_suit` WRITE;
369/*!40000 ALTER TABLE `ens_suit` DISABLE KEYS */;
370/*!40000 ALTER TABLE `ens_suit` ENABLE KEYS */;
371UNLOCK TABLES;
372
373--
374-- Table structure for table `ens_typecours`
375--
376
377DROP TABLE IF EXISTS `ens_typecours`;
378/*!40101 SET @saved_cs_client = @@character_set_client */;
379/*!40101 SET character_set_client = utf8 */;
380CREATE TABLE `ens_typecours` (
381 `idTypeCours` int(11) NOT NULL,
382 `nomType` varchar(255) COLLATE latin1_general_ci NOT NULL,
383 PRIMARY KEY (`idTypeCours`)
384) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;
385/*!40101 SET character_set_client = @saved_cs_client */;
386
387--
388-- Dumping data for table `ens_typecours`
389--
390
391LOCK TABLES `ens_typecours` WRITE;
392/*!40000 ALTER TABLE `ens_typecours` DISABLE KEYS */;
393/*!40000 ALTER TABLE `ens_typecours` ENABLE KEYS */;
394UNLOCK TABLES;
395
396--
397-- Table structure for table `prof_contrat`
398--
399
400DROP TABLE IF EXISTS `prof_contrat`;
401/*!40101 SET @saved_cs_client = @@character_set_client */;
402/*!40101 SET character_set_client = utf8 */;
403CREATE TABLE `prof_contrat` (
404 `idcontrat` int(11) NOT NULL,
405 `enseignantLie` int(11) NOT NULL,
406 `duree` int(11) NOT NULL,
407 `dateDebut` datetime NOT NULL,
408 `dateFin` datetime NOT NULL,
409 PRIMARY KEY (`idcontrat`),
410 KEY `fk_enseignant` (`enseignantLie`),
411 CONSTRAINT `fk_enseignant` FOREIGN KEY (`enseignantLie`) REFERENCES `prof_enseignant` (`idenseignant`) ON DELETE NO ACTION ON UPDATE NO ACTION
412) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;
413/*!40101 SET character_set_client = @saved_cs_client */;
414
415--
416-- Dumping data for table `prof_contrat`
417--
418
419LOCK TABLES `prof_contrat` WRITE;
420/*!40000 ALTER TABLE `prof_contrat` DISABLE KEYS */;
421/*!40000 ALTER TABLE `prof_contrat` ENABLE KEYS */;
422UNLOCK TABLES;
423
424--
425-- Table structure for table `prof_enseignant`
426--
427
428DROP TABLE IF EXISTS `prof_enseignant`;
429/*!40101 SET @saved_cs_client = @@character_set_client */;
430/*!40101 SET character_set_client = utf8 */;
431CREATE TABLE `prof_enseignant` (
432 `idenseignant` int(11) NOT NULL,
433 `statutLie` int(11) NOT NULL,
434 `compteLie` int(11) NOT NULL,
435 `departement` int(11) DEFAULT NULL,
436 PRIMARY KEY (`idenseignant`),
437 KEY `fk_compte` (`compteLie`),
438 KEY `fk_statut` (`statutLie`),
439 KEY `fk_departement` (`departement`),
440 CONSTRAINT `fk_departement` FOREIGN KEY (`departement`) REFERENCES `ens_departement` (`iddepartement`) ON DELETE NO ACTION ON UPDATE NO ACTION,
441 CONSTRAINT `fk_compte` FOREIGN KEY (`compteLie`) REFERENCES `auth_compte` (`idCompte`) ON DELETE NO ACTION ON UPDATE NO ACTION,
442 CONSTRAINT `fk_statut` FOREIGN KEY (`statutLie`) REFERENCES `prof_statutprofesseur` (`Code`) ON DELETE NO ACTION ON UPDATE NO ACTION
443) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;
444/*!40101 SET character_set_client = @saved_cs_client */;
445
446--
447-- Dumping data for table `prof_enseignant`
448--
449
450LOCK TABLES `prof_enseignant` WRITE;
451/*!40000 ALTER TABLE `prof_enseignant` DISABLE KEYS */;
452/*!40000 ALTER TABLE `prof_enseignant` ENABLE KEYS */;
453UNLOCK TABLES;
454
455--
456-- Table structure for table `prof_statutprofesseur`
457--
458
459DROP TABLE IF EXISTS `prof_statutprofesseur`;
460/*!40101 SET @saved_cs_client = @@character_set_client */;
461/*!40101 SET character_set_client = utf8 */;
462CREATE TABLE `prof_statutprofesseur` (
463 `code` int(11) NOT NULL,
464 `coefficient` int(11) NOT NULL,
465 `heureDue` int(11) NOT NULL,
466 PRIMARY KEY (`code`)
467) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;
468/*!40101 SET character_set_client = @saved_cs_client */;
469
470--
471-- Dumping data for table `prof_statutprofesseur`
472--
473
474LOCK TABLES `prof_statutprofesseur` WRITE;
475/*!40000 ALTER TABLE `prof_statutprofesseur` DISABLE KEYS */;
476/*!40000 ALTER TABLE `prof_statutprofesseur` ENABLE KEYS */;
477UNLOCK TABLES;
478/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
479
480/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
481/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
482/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
483/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
484/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
485/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
486/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
487
488-- Dump completed on 2011-11-23 15:14:07