Subversion Repositories eFlore/Applications.del

Rev

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

Rev 1030 Rev 1031
Line 35... Line 35...
35 
 
 35 
 
36 
-- -----------------------------------------------------
 36 
-- -----------------------------------------------------
37 
-- View `del_observations`
 37 
-- View `del_observations`
38 
-- -----------------------------------------------------
 38 
-- -----------------------------------------------------
39 
DROP VIEW IF EXISTS `del_observation` ;
 39 
DROP VIEW IF EXISTS `del_observation` ;
- 
 
 40 
DROP TABLE IF EXISTS `del_observation`
40 
DROP TABLE IF EXISTS `del_observation`;
 41 
 
41 
DELIMITER $$
 42 
DELIMITER $$
42 
CREATE  OR REPLACE VIEW del_observation AS
43 
CREATE  OR REPLACE VIEW del_observation AS
43 
    SELECT id_observation, ce_utilisateur, nom_sel, nom_sel_nn, nom_ret, nom_ret_nn, nt, famille,
44 
    SELECT o.id_observation, ce_utilisateur, nom_sel, nom_sel_nn, nom_ret, nom_ret_nn, nt, famille,
44 
        ce_zone_geo, zone_geo, lieudit, station, milieu,
45 
        ce_zone_geo, zone_geo, lieudit, station, milieu,
45 
        date_observation, mots_cles_texte, commentaire,
46 
        date_observation, mots_cles_texte, commentaire,
46 
        date_creation, date_modification, date_transmission
47 
        date_creation, date_modification, date_transmission
47 
    FROM tb_cel.cel_obs AS o
 48 
    FROM tb_cel.cel_obs AS o
48 
        INNER JOIN tb_cel.cel_utilisateurs_infos AS u ON (o.ce_utilisateur = u.id_utilisateur)
 49 
        INNER JOIN tb_cel.cel_utilisateurs_infos AS u ON (o.ce_utilisateur = u.id_utilisateur)
49 
	INNER JOIN tb_cel.cel_obs_images AS coi ON o.id_observation = doi.id_observation
 50 
	INNER JOIN tb_cel.cel_obs_images AS coi ON o.id_observation = coi.id_observation
50 
    WHERE transmission = '1'
 51 
    WHERE transmission = '1'
- 
 
 52 
$$
51 
$$
 53 
 
Line 52... Line 54...
52 
DELIMITER ;
 54 
DELIMITER ;
Line 53... Line 55...
53 
 
 55