Changeset 1341 for cpc/trunk/project/bin

Timestamp:

Sep 10, 2010, 11:55:14 AM (11 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:

• updateDB3.1.sql (modified) (2 diffs)
• updateDB3.2.sql (modified) (1 diff)
• updateDB3.sh (modified) (3 diffs)

cpc/trunk/project/bin/updateDB3.1.sql

@@ +1 @@
+
+ALTER TABLE `variable_globale3` CHANGE `value` `value` TEXT NULL DEFAULT NULL;
 
 UPDATE intervention SET section_id = 1 WHERE id IN (395528,395529,395530);
@@ -4 +6 @@
 UPDATE intervention SET section_id = 1 WHERE id IN (21725,21726);
 UPDATE intervention SET section_id = 1 WHERE id IN (161761,161762,161763);
+UPDATE intervention SET section_id = 1 WHERE id IN (457894,457895,457896);
 
 

cpc/trunk/project/bin/updateDB3.2.sql

@@ -5 +5 @@
 UPDATE intervention SET section_id = 621 WHERE id IN (21725,21726);
 UPDATE intervention SET section_id = 4185 WHERE id IN (161761,161762,161763);
+UPDATE intervention SET section_id = 10334 WHERE id IN (457894,457895,457896);
 
-DELETE s FROM `section` s where id = 3362;
+
+DELETE s FROM `section` s where id in (3362,7751);
 
 DELETE 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

@@ -7 +7 @@
 #cat bin/updateDB3.model.sql | mysql $MYSQLID $DBNAME
 php symfony doctrine:build --all --no-confirmation
-zcat data/sql/dumps/nosdeputes_prod.100906.sql.gz | mysql --default-character-set=utf8 $MYSQLID $DBNAME
+zcat ../prod/data/sql/dumps/nosdeputes_prod.100910.sql.gz | mysql --default-character-set=utf8 $MYSQLID $DBNAME
 
 cat bin/updateDB3.1.sql | mysql $MYSQLID $DBNAME
@@ -45 +45 @@
 php symfony move:Seance 48 621 1380
 php symfony move:Seance 348 4185 2
+php symfony move:Seance 2903 7751 7573
+php symfony move:Seance 3639 10334 2
 
 cat bin/updateDB3.2.sql | mysql $MYSQLID $DBNAME
@@ -91 +93 @@
 php symfony fuse:Dossiers 265 16
 php symfony fuse:Dossiers 2348 6376
+php symfony fuse:Dossiers 9485 10874
+php symfony fuse:Dossiers 3955 3953
 
 cat bin/updateDB3.3.sql | mysql $MYSQLID $DBNAME