Subversion Repositories eFlore/Applications.del

Rev

Rev 1444 | Show entire file | Ignore whitespace | Details | Blame | Last modification | View Log | RSS feed

Rev 1444 Rev 1447
Line 17... Line 17...
17 
        SELECT id_commentaire, ce_observation, ce_proposition, texte, nom_sel, nom_sel_nn, proposition_retenue FROM `BASEDEL`.`del_commentaire` WHERE ce_observation = _s1;
 17 
        SELECT id_commentaire, ce_observation, ce_proposition, texte, nom_sel, nom_sel_nn, proposition_retenue FROM `BASEDEL`.`del_commentaire` WHERE ce_observation = _s1;
18 
  END;
 18 
  END;
19 
|
 19 
|
Line 20... Line 20...
20 
 
 20 
 
21 
-- procédure créant des tables temporaires permettant de faciliter le processus de MAJ
 21 
-- procédure créant des tables temporaires permettant de faciliter le processus de MAJ
22 
DROP PROCEDURE rebuild_retenues;
 22 
DROP PROCEDURE IF EXISTS rebuild_retenues;
23 
CREATE PROCEDURE rebuild_retenues()
 23 
CREATE PROCEDURE rebuild_retenues()
24 
  BEGIN
 24 
  BEGIN
Line 25... Line 25...
25 
  DROP TEMPORARY TABLE IF EXISTS _temp_having_retenue, _temp_multi_prop, _temp_mono_prop;
 25 
  DROP TEMPORARY TABLE IF EXISTS _temp_having_retenue, _temp_multi_prop, _temp_mono_prop;