Subversion Repositories eFlore/Archives.herbiers

Rev

Details | Last modification | View Log | RSS feed

Rev Author Line No. Line
2 jp_milcent 1 
#+---------------------------------------------------------------------------------------------------------+
2 
#| Copyright (C) 2005 Tela Botanica (accueil@tela-botanica.org)                                            |
3 
#+---------------------------------------------------------------------------------------------------------+
4 
#| This file is part of Herbier.                                                                           |
5 
#|                                                                                                         |
6 
#| Foobar is free software; you can redistribute it and/or modify it under the terms of the GNU General    |
7 
#| Public License as published by the Free Software Foundation; either version 2 of the License, or        |
8 
#| (at your option) any later version.                                                                     |
9 
#|                                                                                                         |
10 
#| Foobar is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY; without even the    |
11 
#| implied warranty of MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the GNU General Public    |
12 
#| License for more details.                                                                               |
13 
#|                                                                                                         |
14 
#| You should have received a copy of the GNU General Public License along with Foobar; if not, write to   |
15 
#| the Free Software Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA  02111-1307  USA             |
16 
#+---------------------------------------------------------------------------------------------------------+
17 
# CVS : $Id: herbiers.sql,v 1.1 2005-11-23 10:32:32 jp_milcent Exp $
18 
#
19 
# Base de données Herbier
20 
#
21 
# Script de création de la structure de la base de données Herbier.
22 
#
23 
#@package Herbier
24 
#@subpackage Sql
25 
# Auteur original :
26 
#@author        Alexandre GRANIER <alexandre@tela-botanica.org>
27 
#Autres auteurs :
28 
#@author        Aucun
29 
#@copyright     Tela-Botanica 2000-2005
30 
#@version       $Revision: 1.1 $ $Date: 2005-11-23 10:32:32 $
31 
# +------------------------------------------------------------------------------------------------------+
32 
 
33 
#
34 
# Structure de la table `EFLORE_DROIT`
35 
#
36 
 
37 
CREATE TABLE `EFLORE_DROIT` (
38 
  `ED_ID_DROIT` int(11) NOT NULL default '0',
39 
  `ED_INTITULE_DROIT` varchar(50) NOT NULL default '',
40 
  `ED_DESCRIPTION_DROIT` varchar(255) NOT NULL default '',
41 
  PRIMARY KEY  (`ED_ID_DROIT`),
42 
  UNIQUE KEY `EFLORE_DROIT_PK` (`ED_ID_DROIT`)
43 
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
44 
 
45 
#
46 
# Contenu de la table `EFLORE_DROIT`
47 
#
48 
 
49 
INSERT INTO `EFLORE_DROIT` VALUES (1, 'Super-administrateur', 'Droits :  gestion, validation, modification, ajout & consultation. Appliqué par défaut à : tous les projets.');
50 
INSERT INTO `EFLORE_DROIT` VALUES (2, 'Administrateur', 'Droits :  gestion, validation, modification, ajout & consultation. Appliqué par défaut à : un projet donné.');
51 
INSERT INTO `EFLORE_DROIT` VALUES (3, 'Modérateur', 'Droits : validation  & consultation. Appliqué par défaut à : l\'ensemble du contenu d\'un projet.');
52 
INSERT INTO `EFLORE_DROIT` VALUES (4, 'Contributeur', 'Droits : modification, ajout & consultation. Appliqué par défaut à : l\'ensemble du contenu d\'un projet.');
53 
INSERT INTO `EFLORE_DROIT` VALUES (5, 'Utilisateur', 'Droits : consultation. Appliqué par défaut à : l\'ensemble du contenu d\'un projet.');
54 
 
55 
# --------------------------------------------------------
56 
 
57 
#
58 
# Structure de la table `EFLORE_DROIT_POSSEDER`
59 
#
60 
 
61 
CREATE TABLE `EFLORE_DROIT_POSSEDER` (
62 
  `EDP_ID_UTILISATEUR` int(11) NOT NULL default '0',
63 
  `EDP_ID_PROJET` int(11) NOT NULL default '0',
64 
  `EDP_ID_DROIT` int(11) NOT NULL default '0',
65 
  PRIMARY KEY  (`EDP_ID_UTILISATEUR`,`EDP_ID_DROIT`,`EDP_ID_PROJET`)
66 
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
67 
 
68 
#
69 
# Contenu de la table `EFLORE_DROIT_POSSEDER`
70 
#
71 
 
72 
INSERT INTO `EFLORE_DROIT_POSSEDER` VALUES (5, 1, 2);
73 
INSERT INTO `EFLORE_DROIT_POSSEDER` VALUES (18, 1, 1);
74 
INSERT INTO `EFLORE_DROIT_POSSEDER` VALUES (19, 1, 1);
75 
INSERT INTO `EFLORE_DROIT_POSSEDER` VALUES (29, 1, 2);
76 
INSERT INTO `EFLORE_DROIT_POSSEDER` VALUES (68, 1, 1);
77 
INSERT INTO `EFLORE_DROIT_POSSEDER` VALUES (97, 1, 1);
78 
INSERT INTO `EFLORE_DROIT_POSSEDER` VALUES (210, 1, 2);
79 
INSERT INTO `EFLORE_DROIT_POSSEDER` VALUES (253, 1, 2);
80 
INSERT INTO `EFLORE_DROIT_POSSEDER` VALUES (415, 1, 2);
81 
INSERT INTO `EFLORE_DROIT_POSSEDER` VALUES (423, 1, 1);
82 
INSERT INTO `EFLORE_DROIT_POSSEDER` VALUES (551, 1, 2);
83 
INSERT INTO `EFLORE_DROIT_POSSEDER` VALUES (871, 1, 2);
84 
INSERT INTO `EFLORE_DROIT_POSSEDER` VALUES (920, 1, 2);
85 
INSERT INTO `EFLORE_DROIT_POSSEDER` VALUES (937, 1, 2);
86 
INSERT INTO `EFLORE_DROIT_POSSEDER` VALUES (1084, 1, 2);
87 
INSERT INTO `EFLORE_DROIT_POSSEDER` VALUES (1237, 1, 2);
88 
INSERT INTO `EFLORE_DROIT_POSSEDER` VALUES (1815, 1, 2);
89 
INSERT INTO `EFLORE_DROIT_POSSEDER` VALUES (3036, 1, 2);
90 
INSERT INTO `EFLORE_DROIT_POSSEDER` VALUES (3567, 1, 1);
91 
INSERT INTO `EFLORE_DROIT_POSSEDER` VALUES (4077, 1, 2);
92 
 
93 
# --------------------------------------------------------
94 
 
95 
#
96 
# Structure de la table `EFLORE_PROJET`
97 
#
98 
 
99 
CREATE TABLE `EFLORE_PROJET` (
100 
  `EPR_ID_PROJET` int(11) NOT NULL default '0',
101 
  `EPR_CE_TYPE_PROJET_ORIGINE` int(11) NOT NULL default '0',
102 
  `EPR_CE_OUVRAGE_SOURCE` int(11) default NULL,
103 
  `EPR_INTITULE_PROJET` varchar(255) NOT NULL default '',
104 
  `EPR_ABREVIATION_PROJET` varchar(40) default NULL,
105 
  `EPR_DESCRIPTION_PROJET` varchar(255) default NULL,
106 
  `EPR_LIEN_WEB` varchar(255) default NULL,
107 
  `EPR_NOTES_PROJET` text,
108 
  PRIMARY KEY  (`EPR_ID_PROJET`),
109 
  UNIQUE KEY `EFLORE_PROJET_PK` (`EPR_ID_PROJET`),
110 
  KEY `POSSEDER_TYPE_PROJET_FK` (`EPR_CE_TYPE_PROJET_ORIGINE`),
111 
  KEY `ETRE_BASE_SUR_OUVRAGE_FK` (`EPR_CE_OUVRAGE_SOURCE`)
112 
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
113 
 
114 
#
115 
# Contenu de la table `EFLORE_PROJET`
116 
#
117 
 
118 
INSERT INTO `EFLORE_PROJET` VALUES (1, 0, NULL, 'Inventaire des herbiers de France', 'IHF', 'Réalisation d\'un inventaire de toutes les collections d\'herbiers présentes sur le territoire.', NULL, NULL);
119 
 
120 
#
121 
# Structure de la table `HERBIERS_ADMINISTRER`
122 
#
123 
 
124 
CREATE TABLE `HERBIERS_ADMINISTRER` (
125 
  `HA_ID_ANNUAIRE` int(10) unsigned default NULL,
126 
  `HA_ID_ORG` int(10) unsigned default NULL
127 
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
128 
 
129 
# --------------------------------------------------------
130 
 
131 
#
132 
# Structure de la table `HERBIERS_A_UN_TYPE`
133 
#
134 
 
135 
CREATE TABLE `HERBIERS_A_UN_TYPE` (
136 
  `ID_INDIC` int(11) NOT NULL default '0',
137 
  `ID_TYPE` int(11) NOT NULL default '0',
138 
  PRIMARY KEY  (`ID_INDIC`,`ID_TYPE`)
139 
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
140 
 
141 
# --------------------------------------------------------
142 
 
143 
#
144 
# Structure de la table `HERBIERS_COLLECTION`
145 
#
146 
 
147 
CREATE TABLE `HERBIERS_COLLECTION` (
148 
  `ID` int(11) NOT NULL auto_increment,
149 
  `PARENT_ID` int(11) default NULL,
150 
  `LEVEL` varchar(255) default NULL,
151 
  `COLLECTION_CODE` varchar(64) default NULL,
152 
  `NOM_COLLECTION` varchar(255) NOT NULL default '',
153 
  `DESCRIPTION` text,
154 
  `STATUT` tinyint(3) unsigned NOT NULL default '1',
155 
  `URL` varchar(255) default NULL,
156 
  `INCLUDED_TYPE` tinyint(4) default '0',
157 
  `STRENGTH` text,
158 
  `PURPOSE` text,
159 
  `NUM_ORGANISATION` int(11) default NULL,
160 
  `NUM_SPECIMENS` int(11) default NULL,
161 
  `NUM_SPECIES` int(11) default NULL,
162 
  `DOC_STATE` text,
163 
  `PERCENT_DATABASED` smallint(6) default NULL,
164 
  `BIOCASE_URL` varchar(255) default NULL,
165 
  `ACCESS_RESTRICTION` text,
166 
  `USAGE_RESTRICTION` text,
167 
  `COLLECTION_ACTIVITY` varchar(255) default NULL,
168 
  `COLLECTION_FOCUS` varchar(255) default NULL,
169 
  `NOTES` text,
170 
  `COLLECTION_CLASS` tinyint(3) unsigned NOT NULL default '1',
171 
  `COLLECTEURS` text,
172 
  `DATE_DEBUT` date default '0000-00-00',
173 
  `DATE_FIN` date default '0000-00-00',
174 
  `DATE_DEBUT_CARAC` tinyint(3) unsigned NOT NULL default '1',
175 
  `DATE_FIN_CARAC` tinyint(3) unsigned NOT NULL default '1',
176 
  `PREC_SPECIMENS` tinyint(3) unsigned NOT NULL default '3',
177 
  `PREC_SPECIES` tinyint(3) unsigned NOT NULL default '3',
178 
  `ETAT_SPECIMENS` enum('1','2','3','4') NOT NULL default '1',
179 
  `ETAT_CLASSEMENT` enum('1','2','3','4') NOT NULL default '1',
180 
  `ETAT_PRESENTATION` enum('1','2','3','4') NOT NULL default '1',
181 
  `MODE_CLASSEMENT` text,
182 
  PRIMARY KEY  (`ID`)
183 
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
184 
 
185 
# --------------------------------------------------------
186 
 
187 
#
188 
# Structure de la table `HERBIERS_COLLECTIONS`
189 
#
190 
 
191 
CREATE TABLE `HERBIERS_COLLECTIONS` (
192 
  `ID_COLLECTIONS` int(11) NOT NULL default '0',
193 
  `ID` int(11) NOT NULL default '0',
194 
  `NAME` varchar(255) default NULL,
195 
  PRIMARY KEY  (`ID_COLLECTIONS`)
196 
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
197 
 
198 
# --------------------------------------------------------
199 
 
200 
#
201 
# Structure de la table `HERBIERS_COLLECTION_CLASS`
202 
#
203 
 
204 
CREATE TABLE `HERBIERS_COLLECTION_CLASS` (
205 
  `HCC_ID` tinyint(3) unsigned NOT NULL default '0',
206 
  `HCC_LABEL` varchar(255) default NULL,
207 
  PRIMARY KEY  (`HCC_ID`)
208 
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
209 
 
210 
# --------------------------------------------------------
211 
 
212 
#
213 
# Structure de la table `HERBIERS_COLL_STATUT`
214 
#
215 
 
216 
CREATE TABLE `HERBIERS_COLL_STATUT` (
217 
  `ID_COLL_STATUT` tinyint(3) unsigned NOT NULL auto_increment,
218 
  `LABEL` varchar(255) NOT NULL default '',
219 
  PRIMARY KEY  (`ID_COLL_STATUT`)
220 
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
221 
 
222 
# --------------------------------------------------------
223 
 
224 
#
225 
# Structure de la table `HERBIERS_COMMON_NAME`
226 
#
227 
 
228 
CREATE TABLE `HERBIERS_COMMON_NAME` (
229 
  `ID_COMMON_NAME` int(11) NOT NULL default '0',
230 
  `ID` int(11) NOT NULL default '0',
231 
  `NAME` varchar(255) default NULL,
232 
  `SOURCE` varchar(255) default NULL,
233 
  PRIMARY KEY  (`ID_COMMON_NAME`)
234 
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
235 
 
236 
# --------------------------------------------------------
237 
 
238 
#
239 
# Structure de la table `HERBIERS_COORDONNE`
240 
#
241 
 
242 
CREATE TABLE `HERBIERS_COORDONNE` (
243 
  `HC_ID_COORDINATEUR` int(10) unsigned NOT NULL default '0',
244 
  `HC_ID_REDACTEUR` int(10) unsigned NOT NULL default '0',
245 
  PRIMARY KEY  (`HC_ID_COORDINATEUR`,`HC_ID_REDACTEUR`)
246 
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
247 
 
248 
# --------------------------------------------------------
249 
 
250 
#
251 
# Structure de la table `HERBIERS_DATE_DEBUT_CARAC`
252 
#
253 
 
254 
CREATE TABLE `HERBIERS_DATE_DEBUT_CARAC` (
255 
  `ID_DATE_CARAC` tinyint(3) unsigned NOT NULL default '0',
256 
  `LABEL_DATE_DEBUT_CARAC` varchar(255) default NULL,
257 
  PRIMARY KEY  (`ID_DATE_CARAC`)
258 
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
259 
 
260 
# --------------------------------------------------------
261 
 
262 
#
263 
# Structure de la table `HERBIERS_DATE_FIN_CARAC`
264 
#
265 
 
266 
CREATE TABLE `HERBIERS_DATE_FIN_CARAC` (
267 
  `ID_DATE_CARAC` tinyint(3) unsigned NOT NULL default '0',
268 
  `LABEL_DATE_FIN_CARAC` varchar(255) default NULL,
269 
  PRIMARY KEY  (`ID_DATE_CARAC`)
270 
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
271 
 
272 
# --------------------------------------------------------
273 
 
274 
#
275 
# Structure de la table `HERBIERS_DENOMBREMENT_CARAC_SC`
276 
#
277 
 
278 
CREATE TABLE `HERBIERS_DENOMBREMENT_CARAC_SC` (
279 
  `HDC_ID` tinyint(3) unsigned NOT NULL default '0',
280 
  `HDC_LABEL` varchar(255) default NULL,
281 
  PRIMARY KEY  (`HDC_ID`)
282 
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
283 
 
284 
# --------------------------------------------------------
285 
 
286 
#
287 
# Structure de la table `HERBIERS_DENOMBREMENT_CARAC_SP`
288 
#
289 
 
290 
CREATE TABLE `HERBIERS_DENOMBREMENT_CARAC_SP` (
291 
  `HDC_ID` tinyint(3) unsigned NOT NULL default '0',
292 
  `HDC_LABEL` varchar(255) default NULL,
293 
  PRIMARY KEY  (`HDC_ID`)
294 
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
295 
 
296 
# --------------------------------------------------------
297 
 
298 
#
299 
# Structure de la table `HERBIERS_ETAT_LABEL`
300 
#
301 
 
302 
CREATE TABLE `HERBIERS_ETAT_LABEL` (
303 
  `HEL_ID` tinyint(3) unsigned NOT NULL default '0',
304 
  `HEL_LABEL` varchar(255) default NULL,
305 
  PRIMARY KEY  (`HEL_ID`)
306 
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
307 
 
308 
# --------------------------------------------------------
309 
 
310 
#
311 
# Structure de la table `HERBIERS_INDIC`
312 
#
313 
 
314 
CREATE TABLE `HERBIERS_INDIC` (
315 
  `ID_INDIC` int(11) NOT NULL auto_increment,
316 
  `ID` int(11) NOT NULL default '0',
317 
  `REM_INDIC` text,
318 
  `MAJ_INDIC` int(11) default NULL,
319 
  `TXT_INDIC` text,
320 
  PRIMARY KEY  (`ID_INDIC`)
321 
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
322 
 
323 
# --------------------------------------------------------
324 
 
325 
#
326 
# Structure de la table `HERBIERS_INDIC_HISTORIQUE`
327 
#
328 
 
329 
CREATE TABLE `HERBIERS_INDIC_HISTORIQUE` (
330 
  `ID_INDIC_HIST` int(10) unsigned NOT NULL auto_increment,
331 
  `ID_INDIC` int(10) unsigned NOT NULL default '0',
332 
  `DATE_INDIC` int(10) unsigned NOT NULL default '0',
333 
  `ID_INDICATEUR` int(10) unsigned NOT NULL default '0',
334 
  PRIMARY KEY  (`ID_INDIC_HIST`)
335 
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
336 
 
337 
# --------------------------------------------------------
338 
 
339 
#
340 
# Structure de la table `HERBIERS_ONT_COLLECTEURS`
341 
#
342 
 
343 
CREATE TABLE `HERBIERS_ONT_COLLECTEURS` (
344 
  `HOC_ID_COLL` int(10) unsigned default NULL,
345 
  `HOC_ID_IBN` int(10) unsigned default NULL
346 
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
347 
 
348 
# --------------------------------------------------------
349 
 
350 
#
351 
# Structure de la table `HERBIERS_ORGANISATION`
352 
#
353 
 
354 
CREATE TABLE `HERBIERS_ORGANISATION` (
355 
  `ID_ORG` int(11) NOT NULL auto_increment,
356 
  `NUM_COLLECTION` int(11) default NULL,
357 
  `ADRESS_TEXT` text,
358 
  `INSTITUTION_NAME` text,
359 
  `ADRESS_LINE` text,
360 
  `TOWN` varchar(255) default NULL,
361 
  `REGION` varchar(255) default NULL,
362 
  `COUNTRY_CODE` char(3) default NULL,
363 
  `ZIP` varchar(16) default NULL,
364 
  `TEL` varchar(64) default NULL,
365 
  `FAX` varchar(64) default NULL,
366 
  `EMAIL` varchar(255) default NULL,
367 
  `HO_URL` varchar(255) default 'http://',
368 
  `LOGO` varchar(255) default NULL,
369 
  `TIME_ZONE` varchar(255) default NULL,
370 
  `ORGANISATION_CLASS` enum('Botanic_Garden','Zoo','Hoticultural','Museum','Herbarium','Laboratory','Other') NOT NULL default 'Botanic_Garden',
371 
  `COLLECTION_CLASS` enum('living','dormant','culture','preserved','observations','photography','fossil','other') NOT NULL default 'living',
372 
  `INDEX_HERB` varchar(16) default NULL,
373 
  `ACCESS_RESTRICTION` text,
374 
  `STATUT_PUBLICATION` tinyint(3) unsigned NOT NULL default '0',
375 
  `SOURCE_DES_DONNEES` varchar(255) NOT NULL default 'IH - Index Herbariorum',
376 
  PRIMARY KEY  (`ID_ORG`)
377 
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
378 
 
379 
# --------------------------------------------------------
380 
 
381 
#
382 
# Structure de la table `HERBIERS_PERSON_NAME`
383 
#
384 
 
385 
CREATE TABLE `HERBIERS_PERSON_NAME` (
386 
  `ID_PERSON_NAME` int(11) NOT NULL default '0',
387 
  `ID` int(11) NOT NULL default '0',
388 
  `PERSON` varchar(255) default NULL,
389 
  `ROLE` varchar(255) default NULL,
390 
  PRIMARY KEY  (`ID_PERSON_NAME`)
391 
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
392 
 
393 
# --------------------------------------------------------
394 
 
395 
#
396 
# Structure de la table `HERBIERS_PRES`
397 
#
398 
 
399 
CREATE TABLE `HERBIERS_PRES` (
400 
  `ID_PRES` int(10) unsigned NOT NULL auto_increment,
401 
  `LABEL` varchar(255) NOT NULL default '',
402 
  `LABEL_ANG` varchar(255) NOT NULL default '',
403 
  PRIMARY KEY  (`ID_PRES`)
404 
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
405 
 
406 
# --------------------------------------------------------
407 
 
408 
#
409 
# Structure de la table `HERBIERS_PUBLICATIONS`
410 
#
411 
 
412 
CREATE TABLE `HERBIERS_PUBLICATIONS` (
413 
  `ID_PUBLICATIONS` int(11) NOT NULL default '0',
414 
  `ID` int(11) NOT NULL default '0',
415 
  `PUBLICATIONS` varchar(255) default NULL,
416 
  PRIMARY KEY  (`ID_PUBLICATIONS`)
417 
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
418 
 
419 
# --------------------------------------------------------
420 
 
421 
#
422 
# Structure de la table `HERBIERS_STAFF`
423 
#
424 
 
425 
CREATE TABLE `HERBIERS_STAFF` (
426 
  `ID_STAFF` int(11) NOT NULL auto_increment,
427 
  `NOM` varchar(255) default NULL,
428 
  `PRENOM` varchar(255) default NULL,
429 
  `ADRESSE1` varchar(255) default NULL,
430 
  `ADRESSE2` varchar(255) default NULL,
431 
  `CP` varchar(10) default NULL,
432 
  `VILLE` varchar(255) default NULL,
433 
  `MAIL` varchar(255) default NULL,
434 
  `TEL` varchar(64) NOT NULL default '',
435 
  `FAX` varchar(64) NOT NULL default '',
436 
  `ID_TELA_BOTANICA` int(11) default NULL,
437 
  `FONCTION` varchar(255) default NULL,
438 
  `CONTACT` enum('non','oui') NOT NULL default 'non',
439 
  PRIMARY KEY  (`ID_STAFF`)
440 
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
441 
 
442 
# --------------------------------------------------------
443 
 
444 
#
445 
# Structure de la table `HERBIERS_STATUT_PUBLICATION`
446 
#
447 
 
448 
CREATE TABLE `HERBIERS_STATUT_PUBLICATION` (
449 
  `HSP_ID` tinyint(3) unsigned NOT NULL default '0',
450 
  `HSP_LABEL` varchar(255) default NULL,
451 
  PRIMARY KEY  (`HSP_ID`)
452 
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
453 
 
454 
# --------------------------------------------------------
455 
 
456 
#
457 
# Structure de la table `HERBIERS_TYPE`
458 
#
459 
 
460 
CREATE TABLE `HERBIERS_TYPE` (
461 
  `ID_TYPE` int(11) NOT NULL auto_increment,
462 
  `LABEL_TYPE` varchar(255) default NULL,
463 
  PRIMARY KEY  (`ID_TYPE`)
464 
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
465 
 
466 
# --------------------------------------------------------
467 
 
468 
#
469 
# Structure de la table `HERBIERS_WEBSITES`
470 
#
471 
 
472 
CREATE TABLE `HERBIERS_WEBSITES` (
473 
  `ID_WEBSITES` int(11) NOT NULL default '0',
474 
  `URL` varchar(255) default NULL,
475 
  PRIMARY KEY  (`ID_WEBSITES`)
476 
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
477 
 
478 
# --------------------------------------------------------
479 
 
480 
#
481 
# Structure de la table `HERBIERS_ont_pres`
482 
#
483 
 
484 
CREATE TABLE `HERBIERS_ont_pres` (
485 
  `ID` int(10) unsigned NOT NULL default '0',
486 
  `ID_PRES` int(10) unsigned NOT NULL default '0',
487 
  PRIMARY KEY  (`ID`,`ID_PRES`)
488 
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
489 
 
490 
# --------------------------------------------------------
491 
 
492 
#
493 
# Structure de la table `HERBIERS_ont_un_staff`
494 
#
495 
 
496 
CREATE TABLE `HERBIERS_ont_un_staff` (
497 
  `ID_ORG` int(11) NOT NULL default '0',
498 
  `ID_STAFF` int(11) NOT NULL default '0',
499 
  PRIMARY KEY  (`ID_ORG`,`ID_STAFF`)
500 
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
501 
 
502 
# --------------------------------------------------------
503 
 
504 
#
505 
# Structure de la table `gen_COUNTRY`
506 
#
507 
 
508 
CREATE TABLE `gen_COUNTRY` (
509 
  `GC_ID` varchar(5) NOT NULL default '',
510 
  `GC_LOCALE` varchar(5) NOT NULL default '',
511 
  `GC_NAME` varchar(80) NOT NULL default '',
512 
  `GC_CAPITAL` varchar(80) NOT NULL default '',
513 
  `GC_CONTINENT_ID` int(11) NOT NULL default '0',
514 
  PRIMARY KEY  (`GC_ID`,`GC_LOCALE`)
515 
) ENGINE=MyISAM DEFAULT CHARSET=latin1;