[SQL] +requete de migration de la structure du site de la v2-->v3
[ptitvelo/web/www.git] / scripts / v2-v3.sql
1 UPDATE spip_articles SET id_rubrique=2 WHERE id_article=109;
2 UPDATE spip_articles SET id_rubrique=2 WHERE id_article=197;
3 UPDATE spip_articles SET id_rubrique=2 WHERE id_article=228;
4 UPDATE spip_articles SET id_rubrique=2 WHERE id_article=297;
5 UPDATE spip_articles SET id_rubrique=2 WHERE id_article=53;
6 UPDATE spip_articles SET id_rubrique=2 WHERE id_article=285;
7 UPDATE spip_articles SET id_rubrique=5 WHERE id_article=11;
8 UPDATE spip_articles SET id_rubrique=5 WHERE id_article=46;
9 UPDATE spip_articles SET id_rubrique=5 WHERE id_article=187;
10 UPDATE spip_articles SET id_rubrique=5 WHERE id_article=217;
11 UPDATE spip_articles SET id_rubrique=5 WHERE id_article=247;
12 UPDATE spip_articles SET id_rubrique=5 WHERE id_article=222;
13 UPDATE spip_articles SET id_rubrique=5 WHERE id_article=166;
14 UPDATE spip_articles SET id_rubrique=5 WHERE id_article=38;
15 UPDATE spip_articles SET id_rubrique=5 WHERE id_article=39;
16 UPDATE spip_articles SET id_rubrique=5 WHERE id_article=119;
17 UPDATE spip_articles SET id_rubrique=5 WHERE id_article=171;
18 UPDATE spip_articles SET id_rubrique=65 WHERE id_article=15;
19 UPDATE spip_articles SET id_rubrique=65 WHERE id_article=45;
20 UPDATE spip_articles SET id_rubrique=66 WHERE id_article=16;
21 UPDATE spip_articles SET id_rubrique=66 WHERE id_article=183;
22 UPDATE spip_articles SET id_rubrique=66 WHERE id_article=70;
23 UPDATE spip_articles SET id_rubrique=66 WHERE id_article=42;
24 UPDATE spip_articles SET id_rubrique=66 WHERE id_article=56;
25 UPDATE spip_articles SET id_rubrique=66 WHERE id_article=190;
26 UPDATE spip_articles SET id_rubrique=67 WHERE id_article=17;
27 UPDATE spip_articles SET id_rubrique=67 WHERE id_article=141;
28 UPDATE spip_articles SET id_rubrique=67 WHERE id_article=189;
29 UPDATE spip_articles SET id_rubrique=67 WHERE id_article=223;
30 UPDATE spip_articles SET id_rubrique=68 WHERE id_article=23;
31 UPDATE spip_articles SET id_rubrique=68 WHERE id_article=29;
32 UPDATE spip_articles SET id_rubrique=68 WHERE id_article=36;
33 UPDATE spip_articles SET id_rubrique=68 WHERE id_article=37;
34 UPDATE spip_articles SET id_rubrique=68 WHERE id_article=225;
35 UPDATE spip_articles SET id_rubrique=69 WHERE id_article=24;
36 UPDATE spip_articles SET id_rubrique=69 WHERE id_article=245;
37 UPDATE spip_articles SET id_rubrique=70 WHERE id_article=50;
38 UPDATE spip_articles SET id_rubrique=70 WHERE id_article=167;
39 UPDATE spip_articles SET id_rubrique=70 WHERE id_article=49;
40 UPDATE spip_articles SET id_rubrique=70 WHERE id_article=62;
41 UPDATE spip_articles SET id_rubrique=70 WHERE id_article=63;
42 UPDATE spip_articles SET id_rubrique=70 WHERE id_article=126;
43 UPDATE spip_articles SET id_rubrique=70 WHERE id_article=44;
44 UPDATE spip_articles SET id_rubrique=70 WHERE id_article=169;
45 UPDATE spip_articles SET id_rubrique=70 WHERE id_article=179;
46 UPDATE spip_articles SET id_rubrique=71 WHERE id_article=52;
47 UPDATE spip_articles SET id_rubrique=71 WHERE id_article=76;
48 UPDATE spip_articles SET id_rubrique=72 WHERE id_article=60;
49 UPDATE spip_articles SET id_rubrique=72 WHERE id_article=170;
50 UPDATE spip_articles SET id_rubrique=72 WHERE id_article=27;
51 UPDATE spip_articles SET id_rubrique=72 WHERE id_article=18;
52 UPDATE spip_articles SET id_rubrique=72 WHERE id_article=26;
53 UPDATE spip_articles SET id_rubrique=72 WHERE id_article=28;
54 UPDATE spip_articles SET id_rubrique=72 WHERE id_article=47;
55 UPDATE spip_articles SET id_rubrique=72 WHERE id_article=48;
56 UPDATE spip_articles SET id_rubrique=72 WHERE id_article=51;
57 UPDATE spip_articles SET id_rubrique=72 WHERE id_article=55;
58 UPDATE spip_articles SET id_rubrique=72 WHERE id_article=58;
59 UPDATE spip_articles SET id_rubrique=72 WHERE id_article=66;
60 UPDATE spip_articles SET id_rubrique=72 WHERE id_article=258;
61 UPDATE spip_articles SET id_rubrique=72 WHERE id_article=110;
62 UPDATE spip_articles SET id_rubrique=72 WHERE id_article=113;
63 UPDATE spip_articles SET id_rubrique=72 WHERE id_article=123;
64 UPDATE spip_articles SET id_rubrique=72 WHERE id_article=244;
65 UPDATE spip_articles SET id_rubrique=72 WHERE id_article=249;
66 UPDATE spip_articles SET id_rubrique=72 WHERE id_article=253;
67 UPDATE spip_articles SET id_rubrique=72 WHERE id_article=161;
68 UPDATE spip_articles SET id_rubrique=72 WHERE id_article=191;
69 UPDATE spip_articles SET id_rubrique=72 WHERE id_article=213;
70 UPDATE spip_articles SET id_rubrique=72 WHERE id_article=280;
71 UPDATE spip_articles SET id_rubrique=72 WHERE id_article=201;
72 UPDATE spip_articles SET id_rubrique=72 WHERE id_article=165;
73 UPDATE spip_articles SET id_rubrique=72 WHERE id_article=122;
74 UPDATE spip_articles SET id_rubrique=72 WHERE id_article=275;
75 UPDATE spip_articles SET id_rubrique=73 WHERE id_article=282;
76 UPDATE spip_articles SET id_rubrique=73 WHERE id_article=71;
77 UPDATE spip_articles SET id_rubrique=73 WHERE id_article=100;
78 UPDATE spip_articles SET id_rubrique=73 WHERE id_article=114;
79 UPDATE spip_articles SET id_rubrique=73 WHERE id_article=248;
80 UPDATE spip_articles SET id_rubrique=73 WHERE id_article=40;
81 UPDATE spip_articles SET id_rubrique=74 WHERE id_article=41;
82 UPDATE spip_articles SET id_rubrique=74 WHERE id_article=157;
83 UPDATE spip_articles SET id_rubrique=74 WHERE id_article=283;
84 UPDATE spip_articles SET id_rubrique=74 WHERE id_article=278;
85 UPDATE spip_articles SET id_rubrique=74 WHERE id_article=293;
86 UPDATE spip_articles SET id_rubrique=74 WHERE id_article=292;
87 UPDATE spip_articles SET id_rubrique=74 WHERE id_article=1;
88 UPDATE spip_articles SET id_rubrique=74 WHERE id_article=10;
89 UPDATE spip_articles SET id_rubrique=74 WHERE id_article=6;
90 UPDATE spip_articles SET id_rubrique=74 WHERE id_article=73;
91 UPDATE spip_articles SET id_rubrique=74 WHERE id_article=74;
92 UPDATE spip_articles SET id_rubrique=74 WHERE id_article=75;
93 UPDATE spip_articles SET id_rubrique=74 WHERE id_article=145;
94 UPDATE spip_articles SET id_rubrique=74 WHERE id_article=121;
95 UPDATE spip_articles SET id_rubrique=74 WHERE id_article=124;
96 UPDATE spip_articles SET id_rubrique=74 WHERE id_article=125;
97 UPDATE spip_articles SET id_rubrique=74 WHERE id_article=160;
98 UPDATE spip_articles SET id_rubrique=74 WHERE id_article=159;
99 UPDATE spip_articles SET id_rubrique=74 WHERE id_article=174;
100 UPDATE spip_articles SET id_rubrique=74 WHERE id_article=196;
101 UPDATE spip_articles SET id_rubrique=74 WHERE id_article=194;
102 UPDATE spip_articles SET id_rubrique=74 WHERE id_article=198;
103 UPDATE spip_articles SET id_rubrique=74 WHERE id_article=207;
104 UPDATE spip_articles SET id_rubrique=74 WHERE id_article=209;
105 UPDATE spip_articles SET id_rubrique=74 WHERE id_article=232;
106 UPDATE spip_articles SET id_rubrique=74 WHERE id_article=256;
107 UPDATE spip_articles SET id_rubrique=74 WHERE id_article=257;
108 UPDATE spip_articles SET id_rubrique=74 WHERE id_article=265;
109 UPDATE spip_articles SET id_rubrique=74 WHERE id_article=267;
110 UPDATE spip_articles SET id_rubrique=74 WHERE id_article=272;
111 UPDATE spip_articles SET id_rubrique=74 WHERE id_article=276;
112 UPDATE spip_articles SET id_rubrique=74 WHERE id_article=153;
113 UPDATE spip_articles SET id_rubrique=74 WHERE id_article=277;
114 UPDATE spip_articles SET id_rubrique=74 WHERE id_article=281;
115 UPDATE spip_articles SET id_rubrique=74 WHERE id_article=286;
116 UPDATE spip_articles SET id_rubrique=75 WHERE id_article=8;
117 UPDATE spip_articles SET id_rubrique=75 WHERE id_article=54;
118 UPDATE spip_articles SET id_rubrique=76 WHERE id_article=13;
119 UPDATE spip_articles SET id_rubrique=77 WHERE id_article=19;
120 UPDATE spip_articles SET id_rubrique=77 WHERE id_article=192;
121 UPDATE spip_articles SET id_rubrique=78 WHERE id_article=35;
122 UPDATE spip_articles SET id_rubrique=78 WHERE id_article=185;
123 UPDATE spip_articles SET id_rubrique=79 WHERE id_article=31;
124 UPDATE spip_articles SET id_rubrique=79 WHERE id_article=68;
125 UPDATE spip_articles SET id_rubrique=79 WHERE id_article=69;
126 UPDATE spip_articles SET id_rubrique=79 WHERE id_article=104;
127 UPDATE spip_articles SET id_rubrique=79 WHERE id_article=263;
128 UPDATE spip_articles SET id_rubrique=80 WHERE id_article=295;
129 UPDATE spip_articles SET id_rubrique=81 WHERE id_article=77;
130 UPDATE spip_articles SET id_rubrique=81 WHERE id_article=78;
131 UPDATE spip_articles SET id_rubrique=81 WHERE id_article=162;
132 UPDATE spip_articles SET id_rubrique=82 WHERE id_article=14;
133 UPDATE spip_articles SET id_rubrique=82 WHERE id_article=43;
134 UPDATE spip_articles SET id_rubrique=83 WHERE id_article=5;
135 UPDATE spip_articles SET id_rubrique=83 WHERE id_article=20;
136 UPDATE spip_articles SET id_rubrique=83 WHERE id_article=65;
137 UPDATE spip_articles SET id_rubrique=83 WHERE id_article=72;
138 UPDATE spip_articles SET id_rubrique=83 WHERE id_article=98;
139 UPDATE spip_articles SET id_rubrique=83 WHERE id_article=212;
140 UPDATE spip_articles SET id_rubrique=83 WHERE id_article=103;
141 UPDATE spip_articles SET id_rubrique=83 WHERE id_article=290;