WebSVN – eFlore/Applications.del – Diff – /trunk/doc/bdd/sql/del.sql


SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0;
SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0;
SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='TRADITIONAL';
 
CREATE SCHEMA IF NOT EXISTS `del` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci ;
USE `del` ;
 
-- -----------------------------------------------------
-- Table `del`.`del_utilisateur`
-- -----------------------------------------------------
DROP TABLE IF EXISTS `del`.`del_utilisateur` ;
 
CREATE  TABLE IF NOT EXISTS `del`.`del_utilisateur` (
  `id_utilisateur` INT NOT NULL COMMENT '	' ,
  `prenom` VARCHAR(45) NULL ,
  `nom` VARCHAR(45) NULL ,
  `courriel` VARCHAR(45) NULL ,
  `mot_de_passe` VARCHAR(45) NULL ,
  `licence_acceptee` VARCHAR(45) NULL ,
  PRIMARY KEY (`id_utilisateur`) )
ENGINE = MyISAM
DEFAULT CHARACTER SET = utf8
COLLATE = utf8_general_ci;
 
 
-- -----------------------------------------------------
-- Table `del`.`del_image`
-- -----------------------------------------------------
DROP TABLE IF EXISTS `del`.`del_image` ;
 
CREATE  TABLE IF NOT EXISTS `del`.`del_image` (
  `id_image` BIGINT NOT NULL ,
  `ce_utilisateur` VARCHAR(32) NOT NULL ,
  `hauteur` INT NULL ,
  `largeur` INT NULL ,
  `date_prise_de_vue` DATETIME NULL ,
  `mots_cles_texte` LONGTEXT NULL ,
  `commentaire` LONGTEXT NULL ,
  `nom_original` VARCHAR(255) NULL ,
  `date_modification` DATETIME NULL ,
  `date_creation` DATETIME NULL ,
  `publiable_eflore` TINYINT(1) NULL ,
  PRIMARY KEY (`id_image`) ,
  UNIQUE INDEX `id_image_UNIQUE` (`id_image` ASC) )
 
ENGINE = MyISAM
DEFAULT CHARACTER SET = utf8
COLLATE = utf8_general_ci;
 
 
-- -----------------------------------------------------
-- Table `del`.`del_observation`
-- -----------------------------------------------------
DROP TABLE IF EXISTS `del`.`del_observation` ;
 
CREATE  TABLE IF NOT EXISTS `del`.`del_observation` (
  `id_observation` INT NOT NULL ,
  `ce_utilisateur` INT NULL ,
  `nom_sel` VARCHAR(255) NULL ,
  `nom_sel_nn` INT(11) NULL ,
  `nom_ret` VARCHAR(255) NULL ,
  `nom_ret_nn` INT(11) NULL ,
  `nt` INT(11) NULL ,
  `famille` VARCHAR(255) NULL ,
  `ce_zone_geo` VARCHAR(50) NULL ,
  `zone_geo` VARCHAR(255) NULL ,
  `lieudit` VARCHAR(255) NULL ,
  `station` VARCHAR(255) NULL ,
  `milieu` VARCHAR(255) NULL ,
  `date_observation` DATETIME NULL ,
  `mots_cles_texte` LONGTEXT NULL ,
  `commentaire` TEXT NULL ,
  `transmission` TINYINT(1) NULL ,
  `date_creation` DATETIME NULL ,
  `date_modification` DATETIME NULL ,
  `date_transmission` DATETIME NULL ,
  PRIMARY KEY (`id_observation`) )
 
ENGINE = MyISAM
DEFAULT CHARACTER SET = utf8
COLLATE = utf8_general_ci;
 
 
-- -----------------------------------------------------
-- Table `del`.`del_protocole`
-- -----------------------------------------------------
DROP TABLE IF EXISTS `del`.`del_protocole` ;
 
CREATE  TABLE IF NOT EXISTS `del`.`del_protocole` (
  `id_protocole` INT NOT NULL ,
  `intitule` VARCHAR(255) NULL ,
  `descriptif` VARCHAR(255) NULL ,
  PRIMARY KEY (`id_protocole`) )
ENGINE = MyISAM
DEFAULT CHARACTER SET = utf8
COLLATE = utf8_general_ci;
 
 
-- -----------------------------------------------------
-- Table `del`.`del_vote_image`
-- -----------------------------------------------------
DROP TABLE IF EXISTS `del`.`del_vote_image` ;
 
CREATE  TABLE IF NOT EXISTS `del`.`del_vote_image` (
  `id_vote_image` INT NOT NULL ,
  `ce_image` INT NOT NULL ,
  `ce_utilisateur` INT NOT NULL ,
  `ce_protocole` INT NOT NULL ,
  `valeur_vote` TINYINT(1) NULL ,
  `date_vote_image` DATETIME NULL ,
  PRIMARY KEY (`id_vote_image`) ,
  UNIQUE INDEX `ID_UNIQUE` (`id_vote_image` ASC) )
 
 
 
ENGINE = MyISAM
DEFAULT CHARACTER SET = utf8
COLLATE = utf8_general_ci;
 
 
-- -----------------------------------------------------
-- Table `del`.`del_tag`
-- -----------------------------------------------------
DROP TABLE IF EXISTS `del`.`del_tag` ;
 
CREATE  TABLE IF NOT EXISTS `del`.`del_tag` (
  `id_tag` INT NOT NULL ,
  `tag` VARCHAR(45) NULL ,
  `ce_image` INT NULL ,
  `ce_utilisateur` INT NULL ,
  `md5` VARCHAR(32) NULL ,
  PRIMARY KEY (`id_tag`) )
 
 
ENGINE = MyISAM
DEFAULT CHARACTER SET = utf8
COLLATE = utf8_general_ci;
 
 
-- -----------------------------------------------------
-- Table `del`.`del_proposition`
-- -----------------------------------------------------
DROP TABLE IF EXISTS `del`.`del_proposition` ;
 
CREATE  TABLE IF NOT EXISTS `del`.`del_proposition` (
  `id_proposition` INT NOT NULL ,
  `nom_sel` VARCHAR(255) NULL COMMENT 'Nom scientifique sélectionné\n' ,
  `nom_sel_nn` INT NULL COMMENT 'Numéro nomenclatural du nom scientifique selectionné\n' ,
  `nom_ret` VARCHAR(255) NULL COMMENT 'Nom scientifique retenu\n' ,
  `nom_ret_nn` INT NULL COMMENT 'Numéro nomenclatural du nom scientifique retenu\n' ,
  `nt` INT NULL COMMENT 'Numéro taxonomique\n' ,
  `nom_referentiel` VARCHAR(45) NULL COMMENT 'Nom du référentiel utilisé (ex bdtfx_v1)\n' ,
  `ce_utilisateur` VARCHAR(45) NULL COMMENT 'identifiant numérique de l\'utilisateur\n' ,
  `ce_observation` INT NOT NULL ,
  PRIMARY KEY (`id_proposition`) )
 
ENGINE = MyISAM
DEFAULT CHARACTER SET = utf8
COLLATE = utf8_general_ci;
 
 
-- -----------------------------------------------------
-- Table `del`.`del_commentaire`
-- -----------------------------------------------------
DROP TABLE IF EXISTS `del`.`del_commentaire` ;
 
CREATE  TABLE IF NOT EXISTS `del`.`del_commentaire` (
  `id_commentaire` INT NOT NULL ,
  `texte` VARCHAR(45) NULL ,
  `ce_utilisateur` INT NULL ,
  `ce_proposition` INT NOT NULL ,
  `ce_commentaire` INT NULL ,
  `utilisateur_nom` VARCHAR(45) NULL ,
  `utilisateur_prenom` VARCHAR(45) NULL ,
  `utilisateur_mail` VARCHAR(45) NULL ,
  `ce_observation` INT NULL ,
  PRIMARY KEY (`id_commentaire`, `ce_proposition`) )
 
 
 
 
ENGINE = MyISAM
DEFAULT CHARACTER SET = utf8
COLLATE = utf8_general_ci;
 
 
-- -----------------------------------------------------
-- Table `del`.`del_vote_observation`
-- -----------------------------------------------------
DROP TABLE IF EXISTS `del`.`del_vote_observation` ;
 
CREATE  TABLE IF NOT EXISTS `del`.`del_vote_observation` (
  `id_vote_observations` INT NOT NULL ,
  `ce_proposition` INT NOT NULL ,
  `ce_utilisateur` INT NOT NULL ,
  `valeur_vote` TINYINT(1) NULL ,
  `date_vote_observation` DATETIME NULL ,
  PRIMARY KEY (`id_vote_observations`) ,
  UNIQUE INDEX `ID_UNIQUE` (`id_vote_observations` ASC) )
 
 
ENGINE = MyISAM
DEFAULT CHARACTER SET = utf8
COLLATE = utf8_general_ci;
 
 
-- -----------------------------------------------------
-- Table `del`.`del_obs_image`
-- -----------------------------------------------------
DROP TABLE IF EXISTS `del`.`del_obs_image` ;
 
CREATE  TABLE IF NOT EXISTS `del`.`del_obs_image` (
  `ce_image` INT NOT NULL ,
  `ce_utilisateur` INT NOT NULL ,
  `ce_observation` INT NOT NULL ,
  `date_liaison` DATETIME NULL ,
  PRIMARY KEY (`ce_image`, `ce_observation`, `ce_utilisateur`) )
 
 
 
ENGINE = MyISAM
DEFAULT CHARACTER SET = utf8
COLLATE = utf8_general_ci;
 
 
 
SET SQL_MODE=@OLD_SQL_MODE;
SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;
SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS;
 

Subversion Repositories eFlore/Applications.del

(root)/trunk/doc/bdd/sql/del.sql @ 714 – Rev 698 → 707

Rev 698		Rev 707
1	`SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0;`	1	`SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0;`
2	`SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0;`	2	`SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0;`
3	`SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='TRADITIONAL';`	3	`SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='TRADITIONAL';`
4		4
5	CREATE SCHEMA IF NOT EXISTS `del` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci ;	5	CREATE SCHEMA IF NOT EXISTS `del` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci ;
6	USE `del` ;	6	USE `del` ;
7		7
8	`-- -----------------------------------------------------`	8	`-- -----------------------------------------------------`
9	-- Table `del`.`del_utilisateur`	9	-- Table `del`.`del_utilisateur`
10	`-- -----------------------------------------------------`	10	`-- -----------------------------------------------------`
11	DROP TABLE IF EXISTS `del`.`del_utilisateur` ;	11	DROP TABLE IF EXISTS `del`.`del_utilisateur` ;
12		12
13	CREATE TABLE IF NOT EXISTS `del`.`del_utilisateur` (	13	CREATE TABLE IF NOT EXISTS `del`.`del_utilisateur` (
14	`id_utilisateur` INT NOT NULL COMMENT ' ' ,	14	`id_utilisateur` INT NOT NULL COMMENT ' ' ,
15	`prenom` VARCHAR(45) NULL ,	15	`prenom` VARCHAR(45) NULL ,
16	`nom` VARCHAR(45) NULL ,	16	`nom` VARCHAR(45) NULL ,
17	`courriel` VARCHAR(45) NULL ,	17	`courriel` VARCHAR(45) NULL ,
18	`mot_de_passe` VARCHAR(45) NULL ,	18	`mot_de_passe` VARCHAR(45) NULL ,
19	`licence_acceptee` VARCHAR(45) NULL ,	19	`licence_acceptee` VARCHAR(45) NULL ,
20	PRIMARY KEY (`id_utilisateur`) )	20	PRIMARY KEY (`id_utilisateur`) )
21	`ENGINE = MyISAM`	21	`ENGINE = MyISAM`
22	`DEFAULT CHARACTER SET = utf8`	22	`DEFAULT CHARACTER SET = utf8`
23	`COLLATE = utf8_general_ci;`	23	`COLLATE = utf8_general_ci;`
24		24
25		25
26	`-- -----------------------------------------------------`	26	`-- -----------------------------------------------------`
27	-- Table `del`.`del_image`	27	-- Table `del`.`del_image`
28	`-- -----------------------------------------------------`	28	`-- -----------------------------------------------------`
29	DROP TABLE IF EXISTS `del`.`del_image` ;	29	DROP TABLE IF EXISTS `del`.`del_image` ;
30		30
31	CREATE TABLE IF NOT EXISTS `del`.`del_image` (	31	CREATE TABLE IF NOT EXISTS `del`.`del_image` (
32	`id_image` BIGINT NOT NULL ,	32	`id_image` BIGINT NOT NULL ,
33	`ce_utilisateur` VARCHAR(32) NOT NULL ,	33	`ce_utilisateur` VARCHAR(32) NOT NULL ,
34	`hauteur` INT NULL ,	34	`hauteur` INT NULL ,
35	`largeur` INT NULL ,	35	`largeur` INT NULL ,
36	`date_prise_de_vue` DATETIME NULL ,	36	`date_prise_de_vue` DATETIME NULL ,
37	`mots_cles_texte` LONGTEXT NULL ,	37	`mots_cles_texte` LONGTEXT NULL ,
38	`commentaire` LONGTEXT NULL ,	38	`commentaire` LONGTEXT NULL ,
39	`nom_original` VARCHAR(255) NULL ,	39	`nom_original` VARCHAR(255) NULL ,
40	`date_modification` DATETIME NULL ,	40	`date_modification` DATETIME NULL ,
41	`date_creation` DATETIME NULL ,	41	`date_creation` DATETIME NULL ,
42	`publiable_eflore` TINYINT(1) NULL ,	42	`publiable_eflore` TINYINT(1) NULL ,
43	PRIMARY KEY (`id_image`) ,	43	PRIMARY KEY (`id_image`) ,
44	UNIQUE INDEX `id_image_UNIQUE` (`id_image` ASC) ,	44	UNIQUE INDEX `id_image_UNIQUE` (`id_image` ASC) )
45	INDEX `fk_Images_Utilisateurs1` (`ce_utilisateur` ASC) )	-
46	`ENGINE = MyISAM`	45	`ENGINE = MyISAM`
47	`DEFAULT CHARACTER SET = utf8`	46	`DEFAULT CHARACTER SET = utf8`
48	`COLLATE = utf8_general_ci;`	47	`COLLATE = utf8_general_ci;`
49		48
50		49
51	`-- -----------------------------------------------------`	50	`-- -----------------------------------------------------`
52	-- Table `del`.`del_observation`	51	-- Table `del`.`del_observation`
53	`-- -----------------------------------------------------`	52	`-- -----------------------------------------------------`
54	DROP TABLE IF EXISTS `del`.`del_observation` ;	53	DROP TABLE IF EXISTS `del`.`del_observation` ;
55		54
56	CREATE TABLE IF NOT EXISTS `del`.`del_observation` (	55	CREATE TABLE IF NOT EXISTS `del`.`del_observation` (
57	`id_observation` INT NOT NULL ,	56	`id_observation` INT NOT NULL ,
58	`ce_utilisateur` INT NULL ,	57	`ce_utilisateur` INT NULL ,
59	`nom_sel` VARCHAR(255) NULL ,	58	`nom_sel` VARCHAR(255) NULL ,
60	`nom_sel_nn` INT(11) NULL ,	59	`nom_sel_nn` INT(11) NULL ,
61	`nom_ret` VARCHAR(255) NULL ,	60	`nom_ret` VARCHAR(255) NULL ,
62	`nom_ret_nn` INT(11) NULL ,	61	`nom_ret_nn` INT(11) NULL ,
63	`nt` INT(11) NULL ,	62	`nt` INT(11) NULL ,
64	`famille` VARCHAR(255) NULL ,	63	`famille` VARCHAR(255) NULL ,
65	`ce_zone_geo` VARCHAR(50) NULL ,	64	`ce_zone_geo` VARCHAR(50) NULL ,
66	`zone_geo` VARCHAR(255) NULL ,	65	`zone_geo` VARCHAR(255) NULL ,
67	`lieudit` VARCHAR(255) NULL ,	66	`lieudit` VARCHAR(255) NULL ,
68	`station` VARCHAR(255) NULL ,	67	`station` VARCHAR(255) NULL ,
69	`milieu` VARCHAR(255) NULL ,	68	`milieu` VARCHAR(255) NULL ,
70	`date_observation` DATETIME NULL ,	69	`date_observation` DATETIME NULL ,
71	`mots_cles_texte` LONGTEXT NULL ,	70	`mots_cles_texte` LONGTEXT NULL ,
72	`commentaire` TEXT NULL ,	71	`commentaire` TEXT NULL ,
73	`transmission` TINYINT(1) NULL ,	72	`transmission` TINYINT(1) NULL ,
74	`date_creation` DATETIME NULL ,	73	`date_creation` DATETIME NULL ,
75	`date_modification` DATETIME NULL ,	74	`date_modification` DATETIME NULL ,
76	`date_transmission` DATETIME NULL ,	75	`date_transmission` DATETIME NULL ,
77	PRIMARY KEY (`id_observation`) ,	76	PRIMARY KEY (`id_observation`) )
78	INDEX `fk_Observations_Utilisateurs1` (`ce_utilisateur` ASC) )	-
79	`ENGINE = MyISAM`	77	`ENGINE = MyISAM`
80	`DEFAULT CHARACTER SET = utf8`	78	`DEFAULT CHARACTER SET = utf8`
81	`COLLATE = utf8_general_ci;`	79	`COLLATE = utf8_general_ci;`
82		80
83		81
84	`-- -----------------------------------------------------`	82	`-- -----------------------------------------------------`
85	-- Table `del`.`del_protocole`	83	-- Table `del`.`del_protocole`
86	`-- -----------------------------------------------------`	84	`-- -----------------------------------------------------`
87	DROP TABLE IF EXISTS `del`.`del_protocole` ;	85	DROP TABLE IF EXISTS `del`.`del_protocole` ;
88		86
89	CREATE TABLE IF NOT EXISTS `del`.`del_protocole` (	87	CREATE TABLE IF NOT EXISTS `del`.`del_protocole` (
90	`id_protocole` INT NOT NULL ,	88	`id_protocole` INT NOT NULL ,
91	`intitule` VARCHAR(255) NULL ,	89	`intitule` VARCHAR(255) NULL ,
92	`descriptif` VARCHAR(255) NULL ,	90	`descriptif` VARCHAR(255) NULL ,
93	PRIMARY KEY (`id_protocole`) )	91	PRIMARY KEY (`id_protocole`) )
94	`ENGINE = MyISAM`	92	`ENGINE = MyISAM`
95	`DEFAULT CHARACTER SET = utf8`	93	`DEFAULT CHARACTER SET = utf8`
96	`COLLATE = utf8_general_ci;`	94	`COLLATE = utf8_general_ci;`
97		95
98		96
99	`-- -----------------------------------------------------`	97	`-- -----------------------------------------------------`
100	-- Table `del`.`del_vote_image`	98	-- Table `del`.`del_vote_image`
101	`-- -----------------------------------------------------`	99	`-- -----------------------------------------------------`
102	DROP TABLE IF EXISTS `del`.`del_vote_image` ;	100	DROP TABLE IF EXISTS `del`.`del_vote_image` ;
103		101
104	CREATE TABLE IF NOT EXISTS `del`.`del_vote_image` (	102	CREATE TABLE IF NOT EXISTS `del`.`del_vote_image` (
105	`id_vote_image` INT NOT NULL ,	103	`id_vote_image` INT NOT NULL ,
106	`ce_image` INT NOT NULL ,	104	`ce_image` INT NOT NULL ,
107	`ce_utilisateur` INT NOT NULL ,	105	`ce_utilisateur` INT NOT NULL ,
108	`ce_protocole` INT NOT NULL ,	106	`ce_protocole` INT NOT NULL ,
109	`valeur_vote` TINYINT(1) NULL ,	107	`valeur_vote` TINYINT(1) NULL ,
-		108	`date_vote_image` DATETIME NULL ,
110	PRIMARY KEY (`id_vote_image`) ,	109	PRIMARY KEY (`id_vote_image`) ,
111	UNIQUE INDEX `ID_UNIQUE` (`id_vote_image` ASC) ,	110	UNIQUE INDEX `ID_UNIQUE` (`id_vote_image` ASC) )
112	INDEX `fk_Vote_images_Protocoles` (`ce_protocole` ASC) ,	-
113	INDEX `fk_Vote_images_Images1` (`ce_image` ASC) ,	-
114	INDEX `fk_Vote_images_Utilisateurs1` (`ce_utilisateur` ASC) )	-
115	`ENGINE = MyISAM`	111	`ENGINE = MyISAM`
116	`DEFAULT CHARACTER SET = utf8`	112	`DEFAULT CHARACTER SET = utf8`
117	`COLLATE = utf8_general_ci;`	113	`COLLATE = utf8_general_ci;`
118		114
119		115
120	`-- -----------------------------------------------------`	116	`-- -----------------------------------------------------`
121	-- Table `del`.`del_tag`	117	-- Table `del`.`del_tag`
122	`-- -----------------------------------------------------`	118	`-- -----------------------------------------------------`
123	DROP TABLE IF EXISTS `del`.`del_tag` ;	119	DROP TABLE IF EXISTS `del`.`del_tag` ;
124		120
125	CREATE TABLE IF NOT EXISTS `del`.`del_tag` (	121	CREATE TABLE IF NOT EXISTS `del`.`del_tag` (
126	`id_tag` INT NOT NULL ,	122	`id_tag` INT NOT NULL ,
127	`tag` VARCHAR(45) NULL ,	123	`tag` VARCHAR(45) NULL ,
128	`ce_image` INT NULL ,	124	`ce_image` INT NULL ,
129	`ce_utilisateur` INT NULL ,	125	`ce_utilisateur` INT NULL ,
130	`md5` VARCHAR(32) NULL ,	126	`md5` VARCHAR(32) NULL ,
131	PRIMARY KEY (`id_tag`) ,	127	PRIMARY KEY (`id_tag`) )
132	INDEX `fk_Tags_Vote_images1` (`ce_image` ASC) ,	-
133	INDEX `fk_Tags_Utilisateurs1` (`ce_utilisateur` ASC) )	-
134	`ENGINE = MyISAM`	128	`ENGINE = MyISAM`
135	`DEFAULT CHARACTER SET = utf8`	129	`DEFAULT CHARACTER SET = utf8`
136	`COLLATE = utf8_general_ci;`	130	`COLLATE = utf8_general_ci;`
137		131
138		132
139	`-- -----------------------------------------------------`	133	`-- -----------------------------------------------------`
140	-- Table `del`.`del_proposition`	134	-- Table `del`.`del_proposition`
141	`-- -----------------------------------------------------`	135	`-- -----------------------------------------------------`
142	DROP TABLE IF EXISTS `del`.`del_proposition` ;	136	DROP TABLE IF EXISTS `del`.`del_proposition` ;
143		137
144	CREATE TABLE IF NOT EXISTS `del`.`del_proposition` (	138	CREATE TABLE IF NOT EXISTS `del`.`del_proposition` (
145	`id_proposition` INT NOT NULL ,	139	`id_proposition` INT NOT NULL ,
146	`nom_sel` VARCHAR(255) NULL COMMENT 'Nom scientifique sélectionné\n' ,	140	`nom_sel` VARCHAR(255) NULL COMMENT 'Nom scientifique sélectionné\n' ,
147	`nom_sel_nn` INT NULL COMMENT 'Numéro nomenclatural du nom scientifique selectionné\n' ,	141	`nom_sel_nn` INT NULL COMMENT 'Numéro nomenclatural du nom scientifique selectionné\n' ,
148	`nom_ret` VARCHAR(255) NULL COMMENT 'Nom scientifique retenu\n' ,	142	`nom_ret` VARCHAR(255) NULL COMMENT 'Nom scientifique retenu\n' ,
149	`nom_ret_nn` INT NULL COMMENT 'Numéro nomenclatural du nom scientifique retenu\n' ,	143	`nom_ret_nn` INT NULL COMMENT 'Numéro nomenclatural du nom scientifique retenu\n' ,
150	`nt` INT NULL COMMENT 'Numéro taxonomique\n' ,	144	`nt` INT NULL COMMENT 'Numéro taxonomique\n' ,
151	`nom_referentiel` VARCHAR(45) NULL COMMENT 'Nom du référentiel utilisé (ex bdtfx_v1)\n' ,	145	`nom_referentiel` VARCHAR(45) NULL COMMENT 'Nom du référentiel utilisé (ex bdtfx_v1)\n' ,
152	`ce_utilisateur` VARCHAR(45) NULL COMMENT 'identifiant numérique de l\'utilisateur\n' ,	146	`ce_utilisateur` VARCHAR(45) NULL COMMENT 'identifiant numérique de l\'utilisateur\n' ,
153	`ce_observation` INT NOT NULL ,	147	`ce_observation` INT NOT NULL ,
154	PRIMARY KEY (`id_proposition`) ,	148	PRIMARY KEY (`id_proposition`) )
155	INDEX `fk_Propositions_Observations1` (`ce_observation` ASC) )	-
156	`ENGINE = MyISAM`	149	`ENGINE = MyISAM`
157	`DEFAULT CHARACTER SET = utf8`	150	`DEFAULT CHARACTER SET = utf8`
158	`COLLATE = utf8_general_ci;`	151	`COLLATE = utf8_general_ci;`
159		152
160		153
161	`-- -----------------------------------------------------`	154	`-- -----------------------------------------------------`
162	-- Table `del`.`del_commentaire`	155	-- Table `del`.`del_commentaire`
163	`-- -----------------------------------------------------`	156	`-- -----------------------------------------------------`
164	DROP TABLE IF EXISTS `del`.`del_commentaire` ;	157	DROP TABLE IF EXISTS `del`.`del_commentaire` ;
165		158
166	CREATE TABLE IF NOT EXISTS `del`.`del_commentaire` (	159	CREATE TABLE IF NOT EXISTS `del`.`del_commentaire` (
167	`id_commentaire` INT NOT NULL ,	160	`id_commentaire` INT NOT NULL ,
168	`texte` VARCHAR(45) NULL ,	161	`texte` VARCHAR(45) NULL ,
169	`ce_utilisateur` INT NULL ,	162	`ce_utilisateur` INT NULL ,
170	`ce_proposition` INT NOT NULL ,	163	`ce_proposition` INT NOT NULL ,
171	`ce_commentaire` INT NULL ,	164	`ce_commentaire` INT NULL ,
172	`utilisateur_nom` VARCHAR(45) NULL ,	165	`utilisateur_nom` VARCHAR(45) NULL ,
173	`utilisateur_prenom` VARCHAR(45) NULL ,	166	`utilisateur_prenom` VARCHAR(45) NULL ,
174	`utilisateur_mail` VARCHAR(45) NULL ,	167	`utilisateur_mail` VARCHAR(45) NULL ,
175	`ce_observation` INT NULL ,	168	`ce_observation` INT NULL ,
176	PRIMARY KEY (`id_commentaire`, `ce_proposition`) ,	169	PRIMARY KEY (`id_commentaire`, `ce_proposition`) )
177	INDEX `fk_Commentaires_Propositions1` (`ce_proposition` ASC) ,	-
178	INDEX `fk_Commentaires_Commentaires1` (`ce_commentaire` ASC) ,	-
179	INDEX `fk_Commentaires_Utilisateurs1` (`ce_utilisateur` ASC) ,	-
180	INDEX `fk_Commentaires_Observations1` (`ce_observation` ASC) )	-
181	`ENGINE = MyISAM`	170	`ENGINE = MyISAM`
182	`DEFAULT CHARACTER SET = utf8`	171	`DEFAULT CHARACTER SET = utf8`
183	`COLLATE = utf8_general_ci;`	172	`COLLATE = utf8_general_ci;`
184		173
185		174
186	`-- -----------------------------------------------------`	175	`-- -----------------------------------------------------`
187	-- Table `del`.`del_vote_observation`	176	-- Table `del`.`del_vote_observation`
188	`-- -----------------------------------------------------`	177	`-- -----------------------------------------------------`
189	DROP TABLE IF EXISTS `del`.`del_vote_observation` ;	178	DROP TABLE IF EXISTS `del`.`del_vote_observation` ;
190		179
191	CREATE TABLE IF NOT EXISTS `del`.`del_vote_observation` (	180	CREATE TABLE IF NOT EXISTS `del`.`del_vote_observation` (
192	`id_vote_observations` INT NOT NULL ,	181	`id_vote_observations` INT NOT NULL ,
193	`ce_proposition` INT NOT NULL ,	182	`ce_proposition` INT NOT NULL ,
194	`ce_utilisateur` INT NOT NULL ,	183	`ce_utilisateur` INT NOT NULL ,
195	`valeur_vote` TINYINT(1) NULL ,	184	`valeur_vote` TINYINT(1) NULL ,
-		185	`date_vote_observation` DATETIME NULL ,
196	PRIMARY KEY (`id_vote_observations`) ,	186	PRIMARY KEY (`id_vote_observations`) ,
197	UNIQUE INDEX `ID_UNIQUE` (`id_vote_observations` ASC) ,	187	UNIQUE INDEX `ID_UNIQUE` (`id_vote_observations` ASC) )
198	INDEX `fk_Vote_observations_Utilisateurs1` (`ce_utilisateur` ASC) ,	-
199	INDEX `fk_Vote_observations_Propositions1` (`ce_proposition` ASC) )	-
200	`ENGINE = MyISAM`	188	`ENGINE = MyISAM`
201	`DEFAULT CHARACTER SET = utf8`	189	`DEFAULT CHARACTER SET = utf8`
202	`COLLATE = utf8_general_ci;`	190	`COLLATE = utf8_general_ci;`
203		191
204		192
205	`-- -----------------------------------------------------`	193	`-- -----------------------------------------------------`
206	-- Table `del`.`del_obs_image`	194	-- Table `del`.`del_obs_image`
207	`-- -----------------------------------------------------`	195	`-- -----------------------------------------------------`
208	DROP TABLE IF EXISTS `del`.`del_obs_image` ;	196	DROP TABLE IF EXISTS `del`.`del_obs_image` ;
209		197
210	CREATE TABLE IF NOT EXISTS `del`.`del_obs_image` (	198	CREATE TABLE IF NOT EXISTS `del`.`del_obs_image` (
211	`ce_image` INT NOT NULL ,	199	`ce_image` INT NOT NULL ,
212	`ce_utilisateur` INT NOT NULL ,	200	`ce_utilisateur` INT NOT NULL ,
213	`ce_observation` INT NOT NULL ,	201	`ce_observation` INT NOT NULL ,
214	`date_liaison` DATETIME NULL ,	202	`date_liaison` DATETIME NULL ,
215	PRIMARY KEY (`ce_image`, `ce_observation`, `ce_utilisateur`) ,	203	PRIMARY KEY (`ce_image`, `ce_observation`, `ce_utilisateur`) )
216	INDEX `fk_Obs_images_Images1` (`ce_image` ASC) ,	-
217	INDEX `fk_Obs_images_Utilisateurs1` (`ce_utilisateur` ASC) ,	-
218	INDEX `fk_Obs_images_Observations1` (`ce_observation` ASC) )	-
219	`ENGINE = MyISAM`	204	`ENGINE = MyISAM`
220	`DEFAULT CHARACTER SET = utf8`	205	`DEFAULT CHARACTER SET = utf8`
221	`COLLATE = utf8_general_ci;`	206	`COLLATE = utf8_general_ci;`
222		207
223		208
224		209
225	`SET SQL_MODE=@OLD_SQL_MODE;`	210	`SET SQL_MODE=@OLD_SQL_MODE;`
226	`SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;`	211	`SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;`
227	`SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS;`	212	`SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS;`
-		213