Changeset 1341


Ignore:
Timestamp:
Sep 10, 2010, 11:55:14 AM (10 years ago)
Author:
goya
Message:

correction script mise a jour base pour ajout fusion 5 dossiers et correction blob -> text dans variable globale

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

Legend:

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

    r1333 r1341  
     1
     2ALTER TABLE `variable_globale3` CHANGE `value` `value` TEXT NULL DEFAULT NULL;
    13
    24UPDATE intervention SET section_id = 1 WHERE id IN (395528,395529,395530);
     
    46UPDATE intervention SET section_id = 1 WHERE id IN (21725,21726);
    57UPDATE intervention SET section_id = 1 WHERE id IN (161761,161762,161763);
     8UPDATE intervention SET section_id = 1 WHERE id IN (457894,457895,457896);
    69
    710
  • cpc/trunk/project/bin/updateDB3.2.sql

    r1333 r1341  
    55UPDATE intervention SET section_id = 621 WHERE id IN (21725,21726);
    66UPDATE intervention SET section_id = 4185 WHERE id IN (161761,161762,161763);
     7UPDATE intervention SET section_id = 10334 WHERE id IN (457894,457895,457896);
    78
    8 DELETE s FROM `section` s where id = 3362;
     9
     10DELETE s FROM `section` s where id in (3362,7751);
    911
    1012DELETE 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 = 1;
  • cpc/trunk/project/bin/updateDB3.sh

    r1333 r1341  
    77#cat bin/updateDB3.model.sql | mysql $MYSQLID $DBNAME
    88php symfony doctrine:build --all --no-confirmation
    9 zcat data/sql/dumps/nosdeputes_prod.100906.sql.gz | mysql --default-character-set=utf8 $MYSQLID $DBNAME
     9zcat ../prod/data/sql/dumps/nosdeputes_prod.100910.sql.gz | mysql --default-character-set=utf8 $MYSQLID $DBNAME
    1010
    1111cat bin/updateDB3.1.sql | mysql $MYSQLID $DBNAME
     
    4545php symfony move:Seance 48 621 1380
    4646php symfony move:Seance 348 4185 2
     47php symfony move:Seance 2903 7751 7573
     48php symfony move:Seance 3639 10334 2
    4749
    4850cat bin/updateDB3.2.sql | mysql $MYSQLID $DBNAME
     
    9193php symfony fuse:Dossiers 265 16
    9294php symfony fuse:Dossiers 2348 6376
     95php symfony fuse:Dossiers 9485 10874
     96php symfony fuse:Dossiers 3955 3953
    9397
    9498cat bin/updateDB3.3.sql | mysql $MYSQLID $DBNAME
Note: See TracChangeset for help on using the changeset viewer.