Subversion Repositories eFlore/Applications.del

Rev

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

Rev 1379 Rev 1380
Line 19... Line 19...
19 
    FROM `BASECEL`.cel_obs AS o
 19 
    FROM `BASECEL`.cel_obs AS o
20 
    INNER JOIN `BASECEL`.cel_obs_images oi ON oi.id_observation = o.id_observation
 20 
    INNER JOIN `BASECEL`.cel_obs_images oi ON oi.id_observation = o.id_observation
21 
    INNER JOIN `BASECEL`.cel_images i ON i.id_image = oi.id_image
 21 
    INNER JOIN `BASECEL`.cel_images i ON i.id_image = oi.id_image
22 
    WHERE o.transmission = '1';
 22 
    WHERE o.transmission = '1';
Line 23... Line 23...
23 
 
 23 
 
24 
-- r1853 de CEL: ajout des INDEX
 24 
-- r1853 de CEL: ajout des INDEX (note: pas de commentaires sur les INDEX < MySQL 5.5)
25 
CREATE INDEX `date_transmission` ON `BASECEL`.`cel_obs` (`date_transmission` DESC) COMMENT "nécessaire à l'ORDER BY utilisé dans la liste d'observation de DEL";
 25 
CREATE INDEX `date_transmission` ON `BASECEL`.`cel_obs` (`date_transmission` DESC) /* COMMENT "nécessaire à l'ORDER BY utilisé dans la liste d'observation de DEL" */ ;