Subversion Repositories eFlore/Applications.del

Rev

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

Rev 1428 Rev 1432
Line 67... Line 67...
67 
       ON ci.id_image = divo.ce_image \
 67 
       ON ci.id_image = divo.ce_image \
68 
       LEFT JOIN \
 68 
       LEFT JOIN \
69 
            ( SELECT ce_image, COUNT(id_tag) as ctags FROM del_image_tag \
 69 
            ( SELECT ce_image, COUNT(id_tag) as ctags FROM del_image_tag \
70 
              GROUP BY ce_image ) AS dit \
 70 
              GROUP BY ce_image ) AS dit \
71 
       ON ci.id_image = dit.ce_image );
 71 
       ON ci.id_image = dit.ce_image );
- 
 
 72 
 
- 
 
 73 
ALTER TABLE `BASEDEL`.`del_image_protocole` ADD `mots_cles` VARCHAR(600) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL;