| Line 222... |
Line 251... |
| 222 |
DROP TABLE IF EXISTS `del_observation`;
|
251 |
DROP TABLE IF EXISTS `del_observation`;
|
| - |
|
252 |
DELIMITER $$
|
| - |
|
253 |
CREATE OR REPLACE VIEW del_observation AS
|
| - |
|
254 |
SELECT id_observation, ce_utilisateur, nom_sel, nom_sel_nn, nom_ret, nom_ret_nn, nt, famille,
|
| - |
|
255 |
ce_zone_geo, zone_geo, lieudit, station, milieu,
|
| - |
|
256 |
date_observation, mots_cles_texte, commentaire,
|
| - |
|
257 |
date_creation, date_modification, date_transmission
|
| - |
|
258 |
FROM tb_cel.cel_obs AS o
|
| - |
|
259 |
INNER JOIN tb_cel.cel_utilisateurs_infos AS u ON (o.ce_utilisateur = u.id_utilisateur)
|
| - |
|
260 |
WHERE transmission = '1'
|
| - |
|
261 |
$$
|
| - |
|
262 |
DELIMITER ;
|
| 223 |
|
263 |
|
| 224 |
CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `del_observation` AS select `o`.`id_observation` AS `id_observation`,`o`.`ce_utilisateur` AS `ce_utilisateur`,`o`.`nom_sel` AS `nom_sel`,`o`.`nom_sel_nn` AS `nom_sel_nn`,`o`.`nom_ret` AS `nom_ret`,`o`.`nom_ret_nn` AS `nom_ret_nn`,`o`.`nt` AS `nt`,`o`.`famille` AS `famille`,`o`.`ce_zone_geo` AS `ce_zone_geo`,`o`.`zone_geo` AS `zone_geo`,`o`.`lieudit` AS `lieudit`,`o`.`station` AS `station`,`o`.`milieu` AS `milieu`,`o`.`date_observation` AS `date_observation`,`o`.`mots_cles_texte` AS `mots_cles_texte`,`o`.`commentaire` AS `commentaire`,`o`.`date_creation` AS `date_creation`,`o`.`date_modification` AS `date_modification`,`o`.`date_transmission` AS `date_transmission` from ((`tb_cel`.`cel_obs` `o` join `tb_cel`.`cel_utilisateurs_infos` `u` on((`o`.`ce_utilisateur` = `u`.`id_utilisateur`))) join `tb_cel`.`cel_obs_images` `coi` on((`o`.`id_observation` = `coi`.`id_observation`))) where (`o`.`transmission` = '1');
|
264 |
;
|
| 225 |
|
265 |
|
| - |
|
266 |
-- -----------------------------------------------------
|
| - |
|
267 |
-- View `del_images`
|
| 226 |
-- --------------------------------------------------------
|
268 |
-- -----------------------------------------------------
|
| - |
|
269 |
DROP VIEW IF EXISTS `del_image` ;
|
| - |
|
270 |
DROP TABLE IF EXISTS `del_image`;
|
| - |
|
271 |
DELIMITER $$
|
| - |
|
272 |
CREATE OR REPLACE VIEW del_image AS
|
| - |
|
273 |
SELECT i.id_image, i.ce_utilisateur, i.hauteur, i.largeur, i.date_prise_de_vue, i.mots_cles_texte,
|
| - |
|
274 |
i.commentaire, i.nom_original, i.date_modification, i.date_creation, i.publiable_eflore
|
| - |
|
275 |
FROM tb_cel.cel_images AS i
|
| - |
|
276 |
INNER JOIN tb_cel.cel_obs_images AS oi ON (i.id_image = oi.id_image)
|
| - |
|
277 |
INNER JOIN tb_cel.cel_obs AS o ON (oi.id_observation = o.id_observation)
|
| - |
|
278 |
INNER JOIN tb_cel.cel_utilisateurs_infos AS u ON (i.ce_utilisateur = u.id_utilisateur)
|
| - |
|
279 |
WHERE o.transmission = '1'
|
| - |
|
280 |
$$
|
| - |
|
281 |
DELIMITER ;
|
| 227 |
|
282 |
|
| 228 |
--
|
283 |
;
|
| - |
|
284 |
|
| - |
|
285 |
-- -----------------------------------------------------
|
| 229 |
-- Structure de la vue `del_obs_image`
|
286 |
-- View `del_obs_image`
|
| 230 |
--
|
- |
|
| - |
|
287 |
-- -----------------------------------------------------
|
| - |
|
288 |
DROP VIEW IF EXISTS `del_obs_image` ;
|
| 231 |
DROP TABLE IF EXISTS `del_obs_image`;
|
289 |
DROP TABLE IF EXISTS `del_obs_image`;
|
| 232 |
|
290 |
DELIMITER $$
|
| 233 |
CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `del_obs_image` AS select `oi`.`id_image` AS `id_image`,`oi`.`id_observation` AS `id_observation`,`oi`.`date_liaison` AS `date_liaison` from ((`tb_cel`.`cel_obs_images` `oi` join `tb_cel`.`cel_obs` `o` on((`oi`.`id_observation` = `o`.`id_observation`))) join `tb_cel`.`cel_utilisateurs_infos` `u` on((`o`.`ce_utilisateur` = `u`.`id_utilisateur`))) where (`o`.`transmission` = '1');
|
291 |
CREATE OR REPLACE VIEW del_obs_image AS
|
| 234 |
|
- |
|
| 235 |
-- --------------------------------------------------------
|
292 |
SELECT oi.id_image, oi.id_observation, oi.date_liaison
|
| 236 |
|
- |
|
| 237 |
--
|
- |
|
| 238 |
-- Structure de la vue `del_utilisateur`
|
293 |
FROM tb_cel.cel_obs_images AS oi
|
| - |
|
294 |
INNER JOIN tb_cel.cel_obs AS o ON (oi.id_observation = o.id_observation)
|
| - |
|
295 |
INNER JOIN tb_cel.cel_utilisateurs_infos AS u ON (o.ce_utilisateur = u.id_utilisateur)
|
| - |
|
296 |
WHERE o.transmission = '1'
|
| 239 |
--
|
297 |
$$
|
| 240 |
DROP TABLE IF EXISTS `del_utilisateur`;
|
298 |
DELIMITER ;
|
| 241 |
|
299 |
|
| - |
|
300 |
;
|
| 242 |
CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `del_utilisateur` AS select `at`.`U_ID` AS `id_utilisateur`,`at`.`U_SURNAME` AS `prenom`,`at`.`U_NAME` AS `nom`,`at`.`U_MAIL` AS `courriel`,`at`.`U_PASSWD` AS `mot_de_passe` from (`tb_cel`.`cel_utilisateurs_infos` `ui` left join `tela_prod`.`annuaire_tela` `at` on((`ui`.`id_utilisateur` = `at`.`U_ID`)));
|
301 |
|
| 243 |
|
302 |
|
| 244 |
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
|
303 |
SET SQL_MODE=@OLD_SQL_MODE;
|
| 245 |
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
|
304 |
SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;
|
| 246 |
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
|
305 |
SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS;
|
| 247 |
|
306 |
|