Ignore:
Timestamp:
May 14, 2012, 12:35:57 AM (9 years ago)
Author:
teymour
Message:

Ajout des présences pour l'APF, l'UIP et les groupes d'amitiés

File:
1 edited

Legend:

Unmodified
Added
Removed
  • cpc/trunk/project/bin/updateDB5.sh

    r2674 r2707  
    77echo 'select a.id, count(tg.id) FROM tagging tg LEFT JOIN amendement a ON a.id = tg.taggable_id LEFT JOIN tag t ON t.id = tg.tag_id  WHERE a.sort <> "Rectifié" AND t.triple_key = "amendement" AND taggable_model = "Amendement" group by a.id' |  mysql $MYSQLID $DBNAME | grep ^[0-9]  | awk '{print "UPDATE amendement SET nb_multiples = "$2" WHERE id = "$1";"}'  | mysql $MYSQLID $DBNAME
    88
     9echo 'ALTER TABLE seance CHANGE moment moment VARCHAR( 255 ) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL' | mysql $MYSQLID $DBNAME
     10
    911php symfony doctrine:build-model
Note: See TracChangeset for help on using the changeset viewer.