1 -- --------------------------------------------------------
4 -- Transfert des articles vers la nouvelle organisation
6 UPDATE spip_articles
SET id_rubrique
=2 WHERE id_article
=109;
7 UPDATE spip_articles
SET id_rubrique
=2 WHERE id_article
=197;
8 UPDATE spip_articles
SET id_rubrique
=2 WHERE id_article
=228;
9 UPDATE spip_articles
SET id_rubrique
=2 WHERE id_article
=297;
10 UPDATE spip_articles
SET id_rubrique
=2 WHERE id_article
=53;
11 UPDATE spip_articles
SET id_rubrique
=2 WHERE id_article
=285;
12 UPDATE spip_articles
SET id_rubrique
=5 WHERE id_article
=11;
13 UPDATE spip_articles
SET id_rubrique
=5 WHERE id_article
=46;
14 UPDATE spip_articles
SET id_rubrique
=5 WHERE id_article
=187;
15 UPDATE spip_articles
SET id_rubrique
=5 WHERE id_article
=217;
16 UPDATE spip_articles
SET id_rubrique
=5 WHERE id_article
=247;
17 UPDATE spip_articles
SET id_rubrique
=5 WHERE id_article
=222;
18 UPDATE spip_articles
SET id_rubrique
=5 WHERE id_article
=166;
19 UPDATE spip_articles
SET id_rubrique
=5 WHERE id_article
=38;
20 UPDATE spip_articles
SET id_rubrique
=5 WHERE id_article
=39;
21 UPDATE spip_articles
SET id_rubrique
=5 WHERE id_article
=119;
22 UPDATE spip_articles
SET id_rubrique
=5 WHERE id_article
=171;
23 UPDATE spip_articles
SET id_rubrique
=65 WHERE id_article
=15;
24 UPDATE spip_articles
SET id_rubrique
=65 WHERE id_article
=45;
25 UPDATE spip_articles
SET id_rubrique
=66 WHERE id_article
=16;
26 UPDATE spip_articles
SET id_rubrique
=66 WHERE id_article
=183;
27 UPDATE spip_articles
SET id_rubrique
=66 WHERE id_article
=70;
28 UPDATE spip_articles
SET id_rubrique
=66 WHERE id_article
=42;
29 UPDATE spip_articles
SET id_rubrique
=66 WHERE id_article
=56;
30 UPDATE spip_articles
SET id_rubrique
=66 WHERE id_article
=190;
31 UPDATE spip_articles
SET id_rubrique
=67 WHERE id_article
=17;
32 UPDATE spip_articles
SET id_rubrique
=67 WHERE id_article
=141;
33 UPDATE spip_articles
SET id_rubrique
=67 WHERE id_article
=189;
34 UPDATE spip_articles
SET id_rubrique
=67 WHERE id_article
=223;
35 UPDATE spip_articles
SET id_rubrique
=68 WHERE id_article
=23;
36 UPDATE spip_articles
SET id_rubrique
=68 WHERE id_article
=29;
37 UPDATE spip_articles
SET id_rubrique
=68 WHERE id_article
=36;
38 UPDATE spip_articles
SET id_rubrique
=68 WHERE id_article
=37;
39 UPDATE spip_articles
SET id_rubrique
=68 WHERE id_article
=225;
40 UPDATE spip_articles
SET id_rubrique
=69 WHERE id_article
=24;
41 UPDATE spip_articles
SET id_rubrique
=69 WHERE id_article
=245;
42 UPDATE spip_articles
SET id_rubrique
=70 WHERE id_article
=50;
43 UPDATE spip_articles
SET id_rubrique
=70 WHERE id_article
=167;
44 UPDATE spip_articles
SET id_rubrique
=70 WHERE id_article
=49;
45 UPDATE spip_articles
SET id_rubrique
=70 WHERE id_article
=62;
46 UPDATE spip_articles
SET id_rubrique
=70 WHERE id_article
=63;
47 UPDATE spip_articles
SET id_rubrique
=70 WHERE id_article
=126;
48 UPDATE spip_articles
SET id_rubrique
=70 WHERE id_article
=44;
49 UPDATE spip_articles
SET id_rubrique
=70 WHERE id_article
=169;
50 UPDATE spip_articles
SET id_rubrique
=70 WHERE id_article
=179;
51 UPDATE spip_articles
SET id_rubrique
=71 WHERE id_article
=52;
52 UPDATE spip_articles
SET id_rubrique
=71 WHERE id_article
=76;
53 UPDATE spip_articles
SET id_rubrique
=72 WHERE id_article
=60;
54 UPDATE spip_articles
SET id_rubrique
=72 WHERE id_article
=170;
55 UPDATE spip_articles
SET id_rubrique
=72 WHERE id_article
=27;
56 UPDATE spip_articles
SET id_rubrique
=72 WHERE id_article
=18;
57 UPDATE spip_articles
SET id_rubrique
=72 WHERE id_article
=26;
58 UPDATE spip_articles
SET id_rubrique
=72 WHERE id_article
=28;
59 UPDATE spip_articles
SET id_rubrique
=72 WHERE id_article
=47;
60 UPDATE spip_articles
SET id_rubrique
=72 WHERE id_article
=48;
61 UPDATE spip_articles
SET id_rubrique
=72 WHERE id_article
=51;
62 UPDATE spip_articles
SET id_rubrique
=72 WHERE id_article
=55;
63 UPDATE spip_articles
SET id_rubrique
=72 WHERE id_article
=58;
64 UPDATE spip_articles
SET id_rubrique
=72 WHERE id_article
=66;
65 UPDATE spip_articles
SET id_rubrique
=72 WHERE id_article
=258;
66 UPDATE spip_articles
SET id_rubrique
=72 WHERE id_article
=110;
67 UPDATE spip_articles
SET id_rubrique
=72 WHERE id_article
=113;
68 UPDATE spip_articles
SET id_rubrique
=72 WHERE id_article
=123;
69 UPDATE spip_articles
SET id_rubrique
=72 WHERE id_article
=244;
70 UPDATE spip_articles
SET id_rubrique
=72 WHERE id_article
=249;
71 UPDATE spip_articles
SET id_rubrique
=72 WHERE id_article
=253;
72 UPDATE spip_articles
SET id_rubrique
=72 WHERE id_article
=161;
73 UPDATE spip_articles
SET id_rubrique
=72 WHERE id_article
=191;
74 UPDATE spip_articles
SET id_rubrique
=72 WHERE id_article
=213;
75 UPDATE spip_articles
SET id_rubrique
=72 WHERE id_article
=280;
76 UPDATE spip_articles
SET id_rubrique
=72 WHERE id_article
=201;
77 UPDATE spip_articles
SET id_rubrique
=72 WHERE id_article
=165;
78 UPDATE spip_articles
SET id_rubrique
=72 WHERE id_article
=122;
79 UPDATE spip_articles
SET id_rubrique
=72 WHERE id_article
=275;
80 UPDATE spip_articles
SET id_rubrique
=73 WHERE id_article
=282;
81 UPDATE spip_articles
SET id_rubrique
=73 WHERE id_article
=71;
82 UPDATE spip_articles
SET id_rubrique
=73 WHERE id_article
=100;
83 UPDATE spip_articles
SET id_rubrique
=73 WHERE id_article
=114;
84 UPDATE spip_articles
SET id_rubrique
=73 WHERE id_article
=248;
85 UPDATE spip_articles
SET id_rubrique
=73 WHERE id_article
=40;
86 UPDATE spip_articles
SET id_rubrique
=74 WHERE id_article
=41;
87 UPDATE spip_articles
SET id_rubrique
=74 WHERE id_article
=157;
88 UPDATE spip_articles
SET id_rubrique
=74 WHERE id_article
=283;
89 UPDATE spip_articles
SET id_rubrique
=74 WHERE id_article
=278;
90 UPDATE spip_articles
SET id_rubrique
=74 WHERE id_article
=293;
91 UPDATE spip_articles
SET id_rubrique
=74 WHERE id_article
=292;
92 UPDATE spip_articles
SET id_rubrique
=74 WHERE id_article
=1;
93 UPDATE spip_articles
SET id_rubrique
=74 WHERE id_article
=10;
94 UPDATE spip_articles
SET id_rubrique
=74 WHERE id_article
=6;
95 UPDATE spip_articles
SET id_rubrique
=74 WHERE id_article
=73;
96 UPDATE spip_articles
SET id_rubrique
=74 WHERE id_article
=74;
97 UPDATE spip_articles
SET id_rubrique
=74 WHERE id_article
=75;
98 UPDATE spip_articles
SET id_rubrique
=74 WHERE id_article
=145;
99 UPDATE spip_articles
SET id_rubrique
=74 WHERE id_article
=121;
100 UPDATE spip_articles
SET id_rubrique
=74 WHERE id_article
=124;
101 UPDATE spip_articles
SET id_rubrique
=74 WHERE id_article
=125;
102 UPDATE spip_articles
SET id_rubrique
=74 WHERE id_article
=160;
103 UPDATE spip_articles
SET id_rubrique
=74 WHERE id_article
=159;
104 UPDATE spip_articles
SET id_rubrique
=74 WHERE id_article
=174;
105 UPDATE spip_articles
SET id_rubrique
=74 WHERE id_article
=196;
106 UPDATE spip_articles
SET id_rubrique
=74 WHERE id_article
=194;
107 UPDATE spip_articles
SET id_rubrique
=74 WHERE id_article
=198;
108 UPDATE spip_articles
SET id_rubrique
=74 WHERE id_article
=207;
109 UPDATE spip_articles
SET id_rubrique
=74 WHERE id_article
=209;
110 UPDATE spip_articles
SET id_rubrique
=74 WHERE id_article
=232;
111 UPDATE spip_articles
SET id_rubrique
=74 WHERE id_article
=256;
112 UPDATE spip_articles
SET id_rubrique
=74 WHERE id_article
=257;
113 UPDATE spip_articles
SET id_rubrique
=74 WHERE id_article
=265;
114 UPDATE spip_articles
SET id_rubrique
=74 WHERE id_article
=267;
115 UPDATE spip_articles
SET id_rubrique
=74 WHERE id_article
=272;
116 UPDATE spip_articles
SET id_rubrique
=74 WHERE id_article
=276;
117 UPDATE spip_articles
SET id_rubrique
=74 WHERE id_article
=153;
118 UPDATE spip_articles
SET id_rubrique
=74 WHERE id_article
=277;
119 UPDATE spip_articles
SET id_rubrique
=74 WHERE id_article
=281;
120 UPDATE spip_articles
SET id_rubrique
=74 WHERE id_article
=286;
121 UPDATE spip_articles
SET id_rubrique
=75 WHERE id_article
=8;
122 UPDATE spip_articles
SET id_rubrique
=75 WHERE id_article
=54;
123 UPDATE spip_articles
SET id_rubrique
=76 WHERE id_article
=13;
124 UPDATE spip_articles
SET id_rubrique
=77 WHERE id_article
=19;
125 UPDATE spip_articles
SET id_rubrique
=77 WHERE id_article
=192;
126 UPDATE spip_articles
SET id_rubrique
=78 WHERE id_article
=35;
127 UPDATE spip_articles
SET id_rubrique
=78 WHERE id_article
=185;
128 UPDATE spip_articles
SET id_rubrique
=79 WHERE id_article
=31;
129 UPDATE spip_articles
SET id_rubrique
=79 WHERE id_article
=68;
130 UPDATE spip_articles
SET id_rubrique
=79 WHERE id_article
=69;
131 UPDATE spip_articles
SET id_rubrique
=79 WHERE id_article
=104;
132 UPDATE spip_articles
SET id_rubrique
=79 WHERE id_article
=263;
133 UPDATE spip_articles
SET id_rubrique
=80 WHERE id_article
=295;
134 UPDATE spip_articles
SET id_rubrique
=81 WHERE id_article
=77;
135 UPDATE spip_articles
SET id_rubrique
=81 WHERE id_article
=78;
136 UPDATE spip_articles
SET id_rubrique
=81 WHERE id_article
=162;
137 UPDATE spip_articles
SET id_rubrique
=82 WHERE id_article
=14;
138 UPDATE spip_articles
SET id_rubrique
=82 WHERE id_article
=43;
139 UPDATE spip_articles
SET id_rubrique
=83 WHERE id_article
=5;
140 UPDATE spip_articles
SET id_rubrique
=83 WHERE id_article
=20;
141 UPDATE spip_articles
SET id_rubrique
=83 WHERE id_article
=65;
142 UPDATE spip_articles
SET id_rubrique
=83 WHERE id_article
=72;
143 UPDATE spip_articles
SET id_rubrique
=83 WHERE id_article
=98;
144 UPDATE spip_articles
SET id_rubrique
=83 WHERE id_article
=212;
145 UPDATE spip_articles
SET id_rubrique
=83 WHERE id_article
=103;
146 UPDATE spip_articles
SET id_rubrique
=83 WHERE id_article
=290;
148 UPDATE spip_articles
SET id_rubrique
=2 WHERE id_article
=109;
149 UPDATE spip_articles
SET id_rubrique
=2 WHERE id_article
=197;
150 UPDATE spip_articles
SET id_rubrique
=2 WHERE id_article
=228;
151 UPDATE spip_articles
SET id_rubrique
=2 WHERE id_article
=297;
152 UPDATE spip_articles
SET id_rubrique
=2 WHERE id_article
=53;
153 UPDATE spip_articles
SET id_rubrique
=2 WHERE id_article
=285;
154 UPDATE spip_articles
SET id_rubrique
=5 WHERE id_article
=11;
155 UPDATE spip_articles
SET id_rubrique
=5 WHERE id_article
=46;
156 UPDATE spip_articles
SET id_rubrique
=5 WHERE id_article
=187;
157 UPDATE spip_articles
SET id_rubrique
=5 WHERE id_article
=217;
158 UPDATE spip_articles
SET id_rubrique
=5 WHERE id_article
=247;
159 UPDATE spip_articles
SET id_rubrique
=5 WHERE id_article
=222;
160 UPDATE spip_articles
SET id_rubrique
=5 WHERE id_article
=166;
161 UPDATE spip_articles
SET id_rubrique
=5 WHERE id_article
=38;
162 UPDATE spip_articles
SET id_rubrique
=5 WHERE id_article
=39;
163 UPDATE spip_articles
SET id_rubrique
=5 WHERE id_article
=119;
164 UPDATE spip_articles
SET id_rubrique
=5 WHERE id_article
=171;
165 UPDATE spip_articles
SET id_rubrique
=65 WHERE id_article
=15;
166 UPDATE spip_articles
SET id_rubrique
=65 WHERE id_article
=45;
167 UPDATE spip_articles
SET id_rubrique
=66 WHERE id_article
=16;
168 UPDATE spip_articles
SET id_rubrique
=66 WHERE id_article
=183;
169 UPDATE spip_articles
SET id_rubrique
=66 WHERE id_article
=70;
170 UPDATE spip_articles
SET id_rubrique
=66 WHERE id_article
=42;
171 UPDATE spip_articles
SET id_rubrique
=66 WHERE id_article
=56;
172 UPDATE spip_articles
SET id_rubrique
=66 WHERE id_article
=190;
173 UPDATE spip_articles
SET id_rubrique
=67 WHERE id_article
=17;
174 UPDATE spip_articles
SET id_rubrique
=67 WHERE id_article
=141;
175 UPDATE spip_articles
SET id_rubrique
=67 WHERE id_article
=189;
176 UPDATE spip_articles
SET id_rubrique
=67 WHERE id_article
=223;
177 UPDATE spip_articles
SET id_rubrique
=68 WHERE id_article
=23;
178 UPDATE spip_articles
SET id_rubrique
=68 WHERE id_article
=29;
179 UPDATE spip_articles
SET id_rubrique
=68 WHERE id_article
=36;
180 UPDATE spip_articles
SET id_rubrique
=68 WHERE id_article
=37;
181 UPDATE spip_articles
SET id_rubrique
=68 WHERE id_article
=225;
182 UPDATE spip_articles
SET id_rubrique
=69 WHERE id_article
=24;
183 UPDATE spip_articles
SET id_rubrique
=69 WHERE id_article
=245;
184 UPDATE spip_articles
SET id_rubrique
=70 WHERE id_article
=50;
185 UPDATE spip_articles
SET id_rubrique
=70 WHERE id_article
=167;
186 UPDATE spip_articles
SET id_rubrique
=70 WHERE id_article
=49;
187 UPDATE spip_articles
SET id_rubrique
=70 WHERE id_article
=62;
188 UPDATE spip_articles
SET id_rubrique
=70 WHERE id_article
=63;
189 UPDATE spip_articles
SET id_rubrique
=70 WHERE id_article
=126;
190 UPDATE spip_articles
SET id_rubrique
=70 WHERE id_article
=44;
191 UPDATE spip_articles
SET id_rubrique
=70 WHERE id_article
=169;
192 UPDATE spip_articles
SET id_rubrique
=70 WHERE id_article
=179;
193 UPDATE spip_articles
SET id_rubrique
=71 WHERE id_article
=52;
194 UPDATE spip_articles
SET id_rubrique
=71 WHERE id_article
=76;
195 UPDATE spip_articles
SET id_rubrique
=72 WHERE id_article
=60;
196 UPDATE spip_articles
SET id_rubrique
=72 WHERE id_article
=170;
197 UPDATE spip_articles
SET id_rubrique
=72 WHERE id_article
=27;
198 UPDATE spip_articles
SET id_rubrique
=72 WHERE id_article
=18;
199 UPDATE spip_articles
SET id_rubrique
=72 WHERE id_article
=26;
200 UPDATE spip_articles
SET id_rubrique
=72 WHERE id_article
=28;
201 UPDATE spip_articles
SET id_rubrique
=72 WHERE id_article
=47;
202 UPDATE spip_articles
SET id_rubrique
=72 WHERE id_article
=48;
203 UPDATE spip_articles
SET id_rubrique
=72 WHERE id_article
=51;
204 UPDATE spip_articles
SET id_rubrique
=72 WHERE id_article
=55;
205 UPDATE spip_articles
SET id_rubrique
=72 WHERE id_article
=58;
206 UPDATE spip_articles
SET id_rubrique
=72 WHERE id_article
=66;
207 UPDATE spip_articles
SET id_rubrique
=72 WHERE id_article
=258;
208 UPDATE spip_articles
SET id_rubrique
=72 WHERE id_article
=110;
209 UPDATE spip_articles
SET id_rubrique
=72 WHERE id_article
=113;
210 UPDATE spip_articles
SET id_rubrique
=72 WHERE id_article
=123;
211 UPDATE spip_articles
SET id_rubrique
=72 WHERE id_article
=244;
212 UPDATE spip_articles
SET id_rubrique
=72 WHERE id_article
=249;
213 UPDATE spip_articles
SET id_rubrique
=72 WHERE id_article
=253;
214 UPDATE spip_articles
SET id_rubrique
=72 WHERE id_article
=161;
215 UPDATE spip_articles
SET id_rubrique
=72 WHERE id_article
=191;
216 UPDATE spip_articles
SET id_rubrique
=72 WHERE id_article
=213;
217 UPDATE spip_articles
SET id_rubrique
=72 WHERE id_article
=280;
218 UPDATE spip_articles
SET id_rubrique
=72 WHERE id_article
=201;
219 UPDATE spip_articles
SET id_rubrique
=72 WHERE id_article
=165;
220 UPDATE spip_articles
SET id_rubrique
=72 WHERE id_article
=122;
221 UPDATE spip_articles
SET id_rubrique
=72 WHERE id_article
=275;
222 UPDATE spip_articles
SET id_rubrique
=73 WHERE id_article
=282;
223 UPDATE spip_articles
SET id_rubrique
=73 WHERE id_article
=71;
224 UPDATE spip_articles
SET id_rubrique
=73 WHERE id_article
=100;
225 UPDATE spip_articles
SET id_rubrique
=73 WHERE id_article
=114;
226 UPDATE spip_articles
SET id_rubrique
=73 WHERE id_article
=248;
227 UPDATE spip_articles
SET id_rubrique
=73 WHERE id_article
=40;
228 UPDATE spip_articles
SET id_rubrique
=74 WHERE id_article
=41;
229 UPDATE spip_articles
SET id_rubrique
=74 WHERE id_article
=157;
230 UPDATE spip_articles
SET id_rubrique
=74 WHERE id_article
=283;
231 UPDATE spip_articles
SET id_rubrique
=74 WHERE id_article
=278;
232 UPDATE spip_articles
SET id_rubrique
=74 WHERE id_article
=293;
233 UPDATE spip_articles
SET id_rubrique
=74 WHERE id_article
=292;
234 UPDATE spip_articles
SET id_rubrique
=74 WHERE id_article
=1;
235 UPDATE spip_articles
SET id_rubrique
=74 WHERE id_article
=10;
236 UPDATE spip_articles
SET id_rubrique
=74 WHERE id_article
=6;
237 UPDATE spip_articles
SET id_rubrique
=74 WHERE id_article
=73;
238 UPDATE spip_articles
SET id_rubrique
=74 WHERE id_article
=74;
239 UPDATE spip_articles
SET id_rubrique
=74 WHERE id_article
=75;
240 UPDATE spip_articles
SET id_rubrique
=74 WHERE id_article
=145;
241 UPDATE spip_articles
SET id_rubrique
=74 WHERE id_article
=121;
242 UPDATE spip_articles
SET id_rubrique
=74 WHERE id_article
=124;
243 UPDATE spip_articles
SET id_rubrique
=74 WHERE id_article
=125;
244 UPDATE spip_articles
SET id_rubrique
=74 WHERE id_article
=160;
245 UPDATE spip_articles
SET id_rubrique
=74 WHERE id_article
=159;
246 UPDATE spip_articles
SET id_rubrique
=74 WHERE id_article
=174;
247 UPDATE spip_articles
SET id_rubrique
=74 WHERE id_article
=196;
248 UPDATE spip_articles
SET id_rubrique
=74 WHERE id_article
=194;
249 UPDATE spip_articles
SET id_rubrique
=74 WHERE id_article
=198;
250 UPDATE spip_articles
SET id_rubrique
=74 WHERE id_article
=207;
251 UPDATE spip_articles
SET id_rubrique
=74 WHERE id_article
=209;
252 UPDATE spip_articles
SET id_rubrique
=74 WHERE id_article
=232;
253 UPDATE spip_articles
SET id_rubrique
=74 WHERE id_article
=256;
254 UPDATE spip_articles
SET id_rubrique
=74 WHERE id_article
=257;
255 UPDATE spip_articles
SET id_rubrique
=74 WHERE id_article
=265;
256 UPDATE spip_articles
SET id_rubrique
=74 WHERE id_article
=267;
257 UPDATE spip_articles
SET id_rubrique
=74 WHERE id_article
=272;
258 UPDATE spip_articles
SET id_rubrique
=74 WHERE id_article
=276;
259 UPDATE spip_articles
SET id_rubrique
=74 WHERE id_article
=153;
260 UPDATE spip_articles
SET id_rubrique
=74 WHERE id_article
=277;
261 UPDATE spip_articles
SET id_rubrique
=74 WHERE id_article
=281;
262 UPDATE spip_articles
SET id_rubrique
=74 WHERE id_article
=286;
263 UPDATE spip_articles
SET id_rubrique
=75 WHERE id_article
=8;
264 UPDATE spip_articles
SET id_rubrique
=75 WHERE id_article
=54;
265 UPDATE spip_articles
SET id_rubrique
=76 WHERE id_article
=13;
266 UPDATE spip_articles
SET id_rubrique
=77 WHERE id_article
=19;
267 UPDATE spip_articles
SET id_rubrique
=77 WHERE id_article
=192;
268 UPDATE spip_articles
SET id_rubrique
=78 WHERE id_article
=35;
269 UPDATE spip_articles
SET id_rubrique
=78 WHERE id_article
=185;
270 UPDATE spip_articles
SET id_rubrique
=79 WHERE id_article
=31;
271 UPDATE spip_articles
SET id_rubrique
=79 WHERE id_article
=68;
272 UPDATE spip_articles
SET id_rubrique
=79 WHERE id_article
=69;
273 UPDATE spip_articles
SET id_rubrique
=79 WHERE id_article
=104;
274 UPDATE spip_articles
SET id_rubrique
=79 WHERE id_article
=263;
275 UPDATE spip_articles
SET id_rubrique
=80 WHERE id_article
=295;
276 UPDATE spip_articles
SET id_rubrique
=81 WHERE id_article
=77;
277 UPDATE spip_articles
SET id_rubrique
=81 WHERE id_article
=78;
278 UPDATE spip_articles
SET id_rubrique
=81 WHERE id_article
=162;
279 UPDATE spip_articles
SET id_rubrique
=82 WHERE id_article
=14;
280 UPDATE spip_articles
SET id_rubrique
=82 WHERE id_article
=43;
281 UPDATE spip_articles
SET id_rubrique
=83 WHERE id_article
=5;
282 UPDATE spip_articles
SET id_rubrique
=83 WHERE id_article
=20;
283 UPDATE spip_articles
SET id_rubrique
=83 WHERE id_article
=65;
284 UPDATE spip_articles
SET id_rubrique
=83 WHERE id_article
=72;
285 UPDATE spip_articles
SET id_rubrique
=83 WHERE id_article
=98;
286 UPDATE spip_articles
SET id_rubrique
=83 WHERE id_article
=212;
287 UPDATE spip_articles
SET id_rubrique
=83 WHERE id_article
=103;
288 UPDATE spip_articles
SET id_rubrique
=83 WHERE id_article
=290;
290 -- --------------------------------------------------------
293 -- Structure de la table `spip_menus`
296 CREATE TABLE IF NOT EXISTS `spip_menus`
(
297 `id_menu`
bigint(21) NOT NULL AUTO_INCREMENT
,
298 `id_menus_entree`
bigint(21) NOT NULL DEFAULT '0',
299 `titre`
text COLLATE utf8_bin
NOT NULL,
300 `identifiant`
varchar(255) COLLATE utf8_bin
NOT NULL DEFAULT '',
301 `css` tinytext
COLLATE utf8_bin
NOT NULL,
302 PRIMARY KEY (`id_menu`
),
303 KEY `id_menus_entree`
(`id_menus_entree`
)
304 ) ENGINE
=InnoDB
DEFAULT CHARSET
=utf8
COLLATE=utf8_bin AUTO_INCREMENT
=6 ;
307 -- Contenu de la table `spip_menus`
310 INSERT INTO `spip_menus`
(`id_menu`
, `id_menus_entree`
, `titre`
, `identifiant`
, `css`
) VALUES
311 (1, 0, 'Barre de navigation', 'menu', ''),
317 -- --------------------------------------------------------
320 -- Structure de la table `spip_menus_entrees`
323 CREATE TABLE IF NOT EXISTS `spip_menus_entrees`
(
324 `id_menus_entree`
bigint(21) NOT NULL AUTO_INCREMENT
,
325 `id_menu`
bigint(21) NOT NULL DEFAULT '0',
326 `rang`
smallint(6) NOT NULL DEFAULT '1',
327 `type_entree` tinytext
COLLATE utf8_bin
NOT NULL,
328 `parametres`
text COLLATE utf8_bin
NOT NULL,
329 PRIMARY KEY (`id_menus_entree`
),
330 KEY `id_menu`
(`id_menu`
)
331 ) ENGINE
=InnoDB
DEFAULT CHARSET
=utf8
COLLATE=utf8_bin AUTO_INCREMENT
=23 ;
334 -- Contenu de la table `spip_menus_entrees`
337 INSERT INTO `spip_menus_entrees`
(`id_menus_entree`
, `id_menu`
, `rang`
, `type_entree`
, `parametres`
) VALUES
338 (1, 1, 1, 'texte_libre', 'a:2:{s:7:"contenu";s:13:"L''association";s:3:"css";s:0:"";}'),
339 (2, 2, 1, 'objet', 'a:6:{s:10:"type_objet";s:8:"rubrique";s:8:"id_objet";s:2:"79";s:5:"titre";s:0:"";s:3:"css";s:0:"";s:9:"connexion";s:0:"";s:4:"trad";s:0:"";}'),
340 (3, 2, 2, 'objet', 'a:6:{s:10:"type_objet";s:8:"rubrique";s:8:"id_objet";s:2:"75";s:5:"titre";s:0:"";s:3:"css";s:0:"";s:9:"connexion";s:0:"";s:4:"trad";s:0:"";}'),
341 (4, 2, 3, 'objet', 'a:6:{s:10:"type_objet";s:8:"rubrique";s:8:"id_objet";s:2:"77";s:5:"titre";s:0:"";s:3:"css";s:0:"";s:9:"connexion";s:0:"";s:4:"trad";s:0:"";}'),
342 (5, 2, 4, 'objet', 'a:6:{s:10:"type_objet";s:8:"rubrique";s:8:"id_objet";s:2:"76";s:5:"titre";s:0:"";s:3:"css";s:0:"";s:9:"connexion";s:0:"";s:4:"trad";s:0:"";}'),
343 (6, 2, 5, 'objet', 'a:6:{s:10:"type_objet";s:8:"rubrique";s:8:"id_objet";s:2:"70";s:5:"titre";s:0:"";s:3:"css";s:0:"";s:9:"connexion";s:0:"";s:4:"trad";s:0:"";}'),
344 (7, 2, 6, 'objet', 'a:6:{s:10:"type_objet";s:8:"rubrique";s:8:"id_objet";s:1:"5";s:5:"titre";s:0:"";s:3:"css";s:0:"";s:9:"connexion";s:0:"";s:4:"trad";s:0:"";}'),
345 (8, 1, 2, 'texte_libre', 'a:2:{s:7:"contenu";s:14:"Les activités";s:3:"css";s:0:"";}'),
346 (9, 1, 3, 'texte_libre', 'a:2:{s:7:"contenu";s:14:"Rejoignez-nous";s:3:"css";s:0:"";}'),
347 (10, 1, 4, 'texte_libre', 'a:2:{s:7:"contenu";s:8:"Réseaux";s:3:"css";s:0:"";}'),
348 (11, 1, 5, 'objet', 'a:6:{s:10:"type_objet";s:8:"rubrique";s:8:"id_objet";s:2:"78";s:5:"titre";s:0:"";s:3:"css";s:0:"";s:9:"connexion";s:0:"";s:4:"trad";s:0:"";}'),
349 (12, 3, 1, 'objet', 'a:6:{s:10:"type_objet";s:8:"rubrique";s:8:"id_objet";s:2:"73";s:5:"titre";s:0:"";s:3:"css";s:0:"";s:9:"connexion";s:0:"";s:4:"trad";s:0:"";}'),
350 (13, 3, 2, 'objet', 'a:6:{s:10:"type_objet";s:8:"rubrique";s:8:"id_objet";s:1:"2";s:5:"titre";s:0:"";s:3:"css";s:0:"";s:9:"connexion";s:0:"";s:4:"trad";s:0:"";}'),
351 (14, 3, 3, 'objet', 'a:6:{s:10:"type_objet";s:8:"rubrique";s:8:"id_objet";s:2:"80";s:5:"titre";s:0:"";s:3:"css";s:0:"";s:9:"connexion";s:0:"";s:4:"trad";s:0:"";}'),
352 (15, 4, 1, 'objet', 'a:6:{s:10:"type_objet";s:8:"rubrique";s:8:"id_objet";s:2:"66";s:5:"titre";s:0:"";s:3:"css";s:0:"";s:9:"connexion";s:0:"";s:4:"trad";s:0:"";}'),
353 (16, 4, 2, 'objet', 'a:6:{s:10:"type_objet";s:8:"rubrique";s:8:"id_objet";s:2:"67";s:5:"titre";s:0:"";s:3:"css";s:0:"";s:9:"connexion";s:0:"";s:4:"trad";s:0:"";}'),
354 (17, 4, 3, 'objet', 'a:6:{s:10:"type_objet";s:8:"rubrique";s:8:"id_objet";s:2:"82";s:5:"titre";s:0:"";s:3:"css";s:0:"";s:9:"connexion";s:0:"";s:4:"trad";s:0:"";}'),
355 (18, 4, 4, 'objet', 'a:6:{s:10:"type_objet";s:8:"rubrique";s:8:"id_objet";s:2:"65";s:5:"titre";s:0:"";s:3:"css";s:0:"";s:9:"connexion";s:0:"";s:4:"trad";s:0:"";}'),
356 (19, 5, 1, 'objet', 'a:6:{s:10:"type_objet";s:8:"rubrique";s:8:"id_objet";s:2:"68";s:5:"titre";s:0:"";s:3:"css";s:0:"";s:9:"connexion";s:0:"";s:4:"trad";s:0:"";}'),
357 (20, 5, 2, 'objet', 'a:6:{s:10:"type_objet";s:8:"rubrique";s:8:"id_objet";s:2:"71";s:5:"titre";s:0:"";s:3:"css";s:0:"";s:9:"connexion";s:0:"";s:4:"trad";s:0:"";}'),
358 (21, 5, 3, 'objet', 'a:6:{s:10:"type_objet";s:8:"rubrique";s:8:"id_objet";s:2:"81";s:5:"titre";s:0:"";s:3:"css";s:0:"";s:9:"connexion";s:0:"";s:4:"trad";s:0:"";}'),
359 (22, 5, 4, 'objet', 'a:6:{s:10:"type_objet";s:8:"rubrique";s:8:"id_objet";s:2:"69";s:5:"titre";s:0:"";s:3:"css";s:0:"";s:9:"connexion";s:0:"";s:4:"trad";s:0:"";}');