Changeset 1355 for cpc/trunk/project/bin

Timestamp:

Sep 11, 2010, 8:52:54 PM (11 years ago)

Author:

roux

Message:

corrections mineures

Location:

cpc/trunk/project/bin

Files:

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

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

@@ -5 +5 @@
 UPDATE intervention SET section_id = 1 WHERE id IN (161761,161762,161763);
 UPDATE intervention SET section_id = 1 WHERE id IN (457894,457895,457896);
+UPDATE intervention SET section_id = 1 WHERE id IN (436326,436327,436328);
 
 
@@ -27 +28 @@
 DELETE 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;
 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 in (2626);
+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 in (11343,11349);
 
 

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

@@ -6 +6 @@
 UPDATE intervention SET section_id = 4185 WHERE id IN (161761,161762,161763);
 UPDATE intervention SET section_id = 10334 WHERE id IN (457894,457895,457896);
+UPDATE intervention SET section_id = 1213 WHERE id IN (436326,436327,436328);
 
 

cpc/trunk/project/bin/updateDB3.sh

@@ -7 +7 @@
 #cat bin/updateDB3.model.sql | mysql $MYSQLID $DBNAME
 php symfony doctrine:build --all --no-confirmation
-zcat ../prod/data/sql/dumps/nosdeputes_prod.100910.sql.gz | mysql --default-character-set=utf8 $MYSQLID $DBNAME
+zcat data/sql/dumps/nosdeputes_prod.100910.sql.gz | mysql --default-character-set=utf8 $MYSQLID $DBNAME
 
 cat bin/updateDB3.1.sql | mysql $MYSQLID $DBNAME
@@ -47 +47 @@
 php symfony move:Seance 2903 7751 7573
 php symfony move:Seance 3639 10334 2
+php symfony move:Seance 3473 1213 2
 
 cat bin/updateDB3.2.sql | mysql $MYSQLID $DBNAME