source: cpc/trunk/project/bin/updateDB3.3.sql @ 2686

Last change on this file since 2686 was 1333, checked in by roux, 11 years ago

premier morceau de l'intégrationd es rapports/pjl

File size: 1.0 KB
Line 
1
2DELETE ta FROM `tagging` ta where taggable_model = "Section" and taggable_id in (784,785,1043,7003,7004);
3
4DELETE co FROM `commentaire_object` co where object_type = "Section" and object_id in (784,785,1043,7003,7004);
5
6DELETE s FROM `section` s where id in (784,785,1043,7003,7004);
7
8DELETE ta FROM `tagging` ta join tag t on t.id = ta.tag_id where taggable_model = "Section" and t.triple_key = "amendement";
9
10DELETE 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 = 4450 and t.triple_value in (1360,1479);
11DELETE 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 = 2832 and t.triple_value in (1101);
12DELETE 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 = 2834 and t.triple_value in (1160);
Note: See TracBrowser for help on using the repository browser.