Changeset 1675 for cpc/trunk/project/bin


Ignore:
Timestamp:
Oct 5, 2010, 3:26:55 PM (11 years ago)
Author:
goya
Message:

oups commit malheureux corrigé

Location:
cpc/trunk/project/bin
Files:
3 edited

Legend:

Unmodified
Added
Removed
  • cpc/trunk/project/bin/load_amdmts_loi

    r1674 r1675  
    33loi=$1
    44
    5 cd /home/nosdeputes/project
     5cd /home/nosdeputes/prod
    66
    77# Récupération et création des JSON
  • cpc/trunk/project/bin/loadsql

    r1674 r1675  
    1313#cat /tmp/delete.sql | mysql $MYSQLID $DBNAME
    1414#rm /tmp/tables.sql /tmp/drop.sql /tmp/create.sql /tmp/delete.sql
    15 zcat data/sql/data.sql.gz | grep -v 'rate_commentaire' | mysql $MYSQLID $DBNAME
     15zcat data/sql/data.sql.gz | mysql $MYSQLID $DBNAME
    1616#php symfony set:Vacances
  • cpc/trunk/project/bin/updateDB3.sh

    r1674 r1675  
    1010echo "ALTER TABLE parlementaire ADD photo LONGBLOB NULL AFTER profession" | mysql $MYSQLID $DBNAME
    1111
    12 zcat ../prod/data/sql/dumps/nosdeputes_prod.100927.sql.gz | mysql --default-character-set=utf8 $MYSQLID $DBNAME
     12zcat data/sql/dumps/nosdeputes_prod.100925.sql.gz | mysql --default-character-set=utf8 $MYSQLID $DBNAME
    1313
    1414echo "ALTER TABLE parlementaire DROP photo" | mysql $MYSQLID $DBNAME
Note: See TracChangeset for help on using the changeset viewer.