Changeset 1355 for cpc/trunk/project/bin


Ignore:
Timestamp:
Sep 11, 2010, 8:52:54 PM (11 years ago)
Author:
roux
Message:

corrections mineures

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

Legend:

Unmodified
Added
Removed
  • cpc/trunk/project/bin/updateDB3.1.sql

    r1348 r1355  
    55UPDATE intervention SET section_id = 1 WHERE id IN (161761,161762,161763);
    66UPDATE intervention SET section_id = 1 WHERE id IN (457894,457895,457896);
     7UPDATE intervention SET section_id = 1 WHERE id IN (436326,436327,436328);
    78
    89
     
    2728DELETE ta FROM `tagging` ta join tag t on t.id = ta.tag_id join intervention i on i.id = ta.taggable_id where taggable_model = "Intervention" and t.triple_key = "numero" and i.seance_id = 206;
    2829DELETE ta FROM `tagging` ta join tag t on t.id = ta.tag_id join section s on s.id = ta.taggable_id where taggable_model = "Section" and t.triple_key = "numero" and s.section_id in (2626);
     30DELETE ta FROM `tagging` ta join tag t on t.id = ta.tag_id join section s on s.id = ta.taggable_id where taggable_model = "Section" and t.triple_key = "numero" and s.section_id in (11343,11349);
    2931
    3032
  • cpc/trunk/project/bin/updateDB3.2.sql

    r1341 r1355  
    66UPDATE intervention SET section_id = 4185 WHERE id IN (161761,161762,161763);
    77UPDATE intervention SET section_id = 10334 WHERE id IN (457894,457895,457896);
     8UPDATE intervention SET section_id = 1213 WHERE id IN (436326,436327,436328);
    89
    910
  • cpc/trunk/project/bin/updateDB3.sh

    r1341 r1355  
    77#cat bin/updateDB3.model.sql | mysql $MYSQLID $DBNAME
    88php symfony doctrine:build --all --no-confirmation
    9 zcat ../prod/data/sql/dumps/nosdeputes_prod.100910.sql.gz | mysql --default-character-set=utf8 $MYSQLID $DBNAME
     9zcat data/sql/dumps/nosdeputes_prod.100910.sql.gz | mysql --default-character-set=utf8 $MYSQLID $DBNAME
    1010
    1111cat bin/updateDB3.1.sql | mysql $MYSQLID $DBNAME
     
    4747php symfony move:Seance 2903 7751 7573
    4848php symfony move:Seance 3639 10334 2
     49php symfony move:Seance 3473 1213 2
    4950
    5051cat bin/updateDB3.2.sql | mysql $MYSQLID $DBNAME
Note: See TracChangeset for help on using the changeset viewer.