Subversion Repositories eFlore/Applications.del

Rev

Rev 698 | Rev 712 | Go to most recent revision | Show entire file | Ignore whitespace | Details | Blame | Last modification | View Log | RSS feed

Rev 698 Rev 707
Line 39... Line 39...
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;
Line 72... Line 71...
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;
Line 105... Line 103...
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;
Line 126... Line 122...
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;
Line 149... Line 143...
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;
Line 171... Line 164...
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;
Line 191... Line 180...
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;
Line 210... Line 198...
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;
Line 222... Line 207...
222 
 
 207 
 
223 
 
 208 
 
224 
 
 209 
 
- 
 
 210 
SET SQL_MODE=@OLD_SQL_MODE;