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;
147 UPDATE spip_articles
SET id_rubrique
=2 WHERE id_article
=109;
148 UPDATE spip_articles
SET id_rubrique
=2 WHERE id_article
=197;
149 UPDATE spip_articles
SET id_rubrique
=2 WHERE id_article
=228;
150 UPDATE spip_articles
SET id_rubrique
=2 WHERE id_article
=297;
151 UPDATE spip_articles
SET id_rubrique
=2 WHERE id_article
=53;
152 UPDATE spip_articles
SET id_rubrique
=2 WHERE id_article
=285;
153 UPDATE spip_articles
SET id_rubrique
=5 WHERE id_article
=11;
154 UPDATE spip_articles
SET id_rubrique
=5 WHERE id_article
=46;
155 UPDATE spip_articles
SET id_rubrique
=5 WHERE id_article
=187;
156 UPDATE spip_articles
SET id_rubrique
=5 WHERE id_article
=217;
157 UPDATE spip_articles
SET id_rubrique
=5 WHERE id_article
=247;
158 UPDATE spip_articles
SET id_rubrique
=5 WHERE id_article
=222;
159 UPDATE spip_articles
SET id_rubrique
=5 WHERE id_article
=166;
160 UPDATE spip_articles
SET id_rubrique
=5 WHERE id_article
=38;
161 UPDATE spip_articles
SET id_rubrique
=5 WHERE id_article
=39;
162 UPDATE spip_articles
SET id_rubrique
=5 WHERE id_article
=119;
163 UPDATE spip_articles
SET id_rubrique
=5 WHERE id_article
=171;
164 UPDATE spip_articles
SET id_rubrique
=65 WHERE id_article
=15;
165 UPDATE spip_articles
SET id_rubrique
=65 WHERE id_article
=45;
166 UPDATE spip_articles
SET id_rubrique
=66 WHERE id_article
=16;
167 UPDATE spip_articles
SET id_rubrique
=66 WHERE id_article
=183;
168 UPDATE spip_articles
SET id_rubrique
=66 WHERE id_article
=70;
169 UPDATE spip_articles
SET id_rubrique
=66 WHERE id_article
=42;
170 UPDATE spip_articles
SET id_rubrique
=66 WHERE id_article
=56;
171 UPDATE spip_articles
SET id_rubrique
=66 WHERE id_article
=190;
172 UPDATE spip_articles
SET id_rubrique
=67 WHERE id_article
=17;
173 UPDATE spip_articles
SET id_rubrique
=67 WHERE id_article
=141;
174 UPDATE spip_articles
SET id_rubrique
=67 WHERE id_article
=189;
175 UPDATE spip_articles
SET id_rubrique
=67 WHERE id_article
=223;
176 UPDATE spip_articles
SET id_rubrique
=68 WHERE id_article
=23;
177 UPDATE spip_articles
SET id_rubrique
=68 WHERE id_article
=29;
178 UPDATE spip_articles
SET id_rubrique
=68 WHERE id_article
=36;
179 UPDATE spip_articles
SET id_rubrique
=68 WHERE id_article
=37;
180 UPDATE spip_articles
SET id_rubrique
=68 WHERE id_article
=225;
181 UPDATE spip_articles
SET id_rubrique
=69 WHERE id_article
=24;
182 UPDATE spip_articles
SET id_rubrique
=69 WHERE id_article
=245;
183 UPDATE spip_articles
SET id_rubrique
=70 WHERE id_article
=50;
184 UPDATE spip_articles
SET id_rubrique
=70 WHERE id_article
=167;
185 UPDATE spip_articles
SET id_rubrique
=70 WHERE id_article
=49;
186 UPDATE spip_articles
SET id_rubrique
=70 WHERE id_article
=62;
187 UPDATE spip_articles
SET id_rubrique
=70 WHERE id_article
=63;
188 UPDATE spip_articles
SET id_rubrique
=70 WHERE id_article
=126;
189 UPDATE spip_articles
SET id_rubrique
=70 WHERE id_article
=44;
190 UPDATE spip_articles
SET id_rubrique
=70 WHERE id_article
=169;
191 UPDATE spip_articles
SET id_rubrique
=70 WHERE id_article
=179;
192 UPDATE spip_articles
SET id_rubrique
=71 WHERE id_article
=52;
193 UPDATE spip_articles
SET id_rubrique
=71 WHERE id_article
=76;
194 UPDATE spip_articles
SET id_rubrique
=72 WHERE id_article
=60;
195 UPDATE spip_articles
SET id_rubrique
=72 WHERE id_article
=170;
196 UPDATE spip_articles
SET id_rubrique
=72 WHERE id_article
=27;
197 UPDATE spip_articles
SET id_rubrique
=72 WHERE id_article
=18;
198 UPDATE spip_articles
SET id_rubrique
=72 WHERE id_article
=26;
199 UPDATE spip_articles
SET id_rubrique
=72 WHERE id_article
=28;
200 UPDATE spip_articles
SET id_rubrique
=72 WHERE id_article
=47;
201 UPDATE spip_articles
SET id_rubrique
=72 WHERE id_article
=48;
202 UPDATE spip_articles
SET id_rubrique
=72 WHERE id_article
=51;
203 UPDATE spip_articles
SET id_rubrique
=72 WHERE id_article
=55;
204 UPDATE spip_articles
SET id_rubrique
=72 WHERE id_article
=58;
205 UPDATE spip_articles
SET id_rubrique
=72 WHERE id_article
=66;
206 UPDATE spip_articles
SET id_rubrique
=72 WHERE id_article
=258;
207 UPDATE spip_articles
SET id_rubrique
=72 WHERE id_article
=110;
208 UPDATE spip_articles
SET id_rubrique
=72 WHERE id_article
=113;
209 UPDATE spip_articles
SET id_rubrique
=72 WHERE id_article
=123;
210 UPDATE spip_articles
SET id_rubrique
=72 WHERE id_article
=244;
211 UPDATE spip_articles
SET id_rubrique
=72 WHERE id_article
=249;
212 UPDATE spip_articles
SET id_rubrique
=72 WHERE id_article
=253;
213 UPDATE spip_articles
SET id_rubrique
=72 WHERE id_article
=161;
214 UPDATE spip_articles
SET id_rubrique
=72 WHERE id_article
=191;
215 UPDATE spip_articles
SET id_rubrique
=72 WHERE id_article
=213;
216 UPDATE spip_articles
SET id_rubrique
=72 WHERE id_article
=280;
217 UPDATE spip_articles
SET id_rubrique
=72 WHERE id_article
=201;
218 UPDATE spip_articles
SET id_rubrique
=72 WHERE id_article
=165;
219 UPDATE spip_articles
SET id_rubrique
=72 WHERE id_article
=122;
220 UPDATE spip_articles
SET id_rubrique
=72 WHERE id_article
=275;
221 UPDATE spip_articles
SET id_rubrique
=73 WHERE id_article
=282;
222 UPDATE spip_articles
SET id_rubrique
=73 WHERE id_article
=71;
223 UPDATE spip_articles
SET id_rubrique
=73 WHERE id_article
=100;
224 UPDATE spip_articles
SET id_rubrique
=73 WHERE id_article
=114;
225 UPDATE spip_articles
SET id_rubrique
=73 WHERE id_article
=248;
226 UPDATE spip_articles
SET id_rubrique
=73 WHERE id_article
=40;
227 UPDATE spip_articles
SET id_rubrique
=74 WHERE id_article
=41;
228 UPDATE spip_articles
SET id_rubrique
=74 WHERE id_article
=157;
229 UPDATE spip_articles
SET id_rubrique
=74 WHERE id_article
=283;
230 UPDATE spip_articles
SET id_rubrique
=74 WHERE id_article
=278;
231 UPDATE spip_articles
SET id_rubrique
=74 WHERE id_article
=293;
232 UPDATE spip_articles
SET id_rubrique
=74 WHERE id_article
=292;
233 UPDATE spip_articles
SET id_rubrique
=74 WHERE id_article
=1;
234 UPDATE spip_articles
SET id_rubrique
=74 WHERE id_article
=10;
235 UPDATE spip_articles
SET id_rubrique
=74 WHERE id_article
=6;
236 UPDATE spip_articles
SET id_rubrique
=74 WHERE id_article
=73;
237 UPDATE spip_articles
SET id_rubrique
=74 WHERE id_article
=74;
238 UPDATE spip_articles
SET id_rubrique
=74 WHERE id_article
=75;
239 UPDATE spip_articles
SET id_rubrique
=74 WHERE id_article
=145;
240 UPDATE spip_articles
SET id_rubrique
=74 WHERE id_article
=121;
241 UPDATE spip_articles
SET id_rubrique
=74 WHERE id_article
=124;
242 UPDATE spip_articles
SET id_rubrique
=74 WHERE id_article
=125;
243 UPDATE spip_articles
SET id_rubrique
=74 WHERE id_article
=160;
244 UPDATE spip_articles
SET id_rubrique
=74 WHERE id_article
=159;
245 UPDATE spip_articles
SET id_rubrique
=74 WHERE id_article
=174;
246 UPDATE spip_articles
SET id_rubrique
=74 WHERE id_article
=196;
247 UPDATE spip_articles
SET id_rubrique
=74 WHERE id_article
=194;
248 UPDATE spip_articles
SET id_rubrique
=74 WHERE id_article
=198;
249 UPDATE spip_articles
SET id_rubrique
=74 WHERE id_article
=207;
250 UPDATE spip_articles
SET id_rubrique
=74 WHERE id_article
=209;
251 UPDATE spip_articles
SET id_rubrique
=74 WHERE id_article
=232;
252 UPDATE spip_articles
SET id_rubrique
=74 WHERE id_article
=256;
253 UPDATE spip_articles
SET id_rubrique
=74 WHERE id_article
=257;
254 UPDATE spip_articles
SET id_rubrique
=74 WHERE id_article
=265;
255 UPDATE spip_articles
SET id_rubrique
=74 WHERE id_article
=267;
256 UPDATE spip_articles
SET id_rubrique
=74 WHERE id_article
=272;
257 UPDATE spip_articles
SET id_rubrique
=74 WHERE id_article
=276;
258 UPDATE spip_articles
SET id_rubrique
=74 WHERE id_article
=153;
259 UPDATE spip_articles
SET id_rubrique
=74 WHERE id_article
=277;
260 UPDATE spip_articles
SET id_rubrique
=74 WHERE id_article
=281;
261 UPDATE spip_articles
SET id_rubrique
=74 WHERE id_article
=286;
262 UPDATE spip_articles
SET id_rubrique
=75 WHERE id_article
=8;
263 UPDATE spip_articles
SET id_rubrique
=75 WHERE id_article
=54;
264 UPDATE spip_articles
SET id_rubrique
=76 WHERE id_article
=13;
265 UPDATE spip_articles
SET id_rubrique
=77 WHERE id_article
=19;
266 UPDATE spip_articles
SET id_rubrique
=77 WHERE id_article
=192;
267 UPDATE spip_articles
SET id_rubrique
=78 WHERE id_article
=35;
268 UPDATE spip_articles
SET id_rubrique
=78 WHERE id_article
=185;
269 UPDATE spip_articles
SET id_rubrique
=79 WHERE id_article
=31;
270 UPDATE spip_articles
SET id_rubrique
=79 WHERE id_article
=68;
271 UPDATE spip_articles
SET id_rubrique
=79 WHERE id_article
=69;
272 UPDATE spip_articles
SET id_rubrique
=79 WHERE id_article
=104;
273 UPDATE spip_articles
SET id_rubrique
=79 WHERE id_article
=263;
274 UPDATE spip_articles
SET id_rubrique
=80 WHERE id_article
=295;
275 UPDATE spip_articles
SET id_rubrique
=81 WHERE id_article
=77;
276 UPDATE spip_articles
SET id_rubrique
=81 WHERE id_article
=78;
277 UPDATE spip_articles
SET id_rubrique
=81 WHERE id_article
=162;
278 UPDATE spip_articles
SET id_rubrique
=82 WHERE id_article
=14;
279 UPDATE spip_articles
SET id_rubrique
=82 WHERE id_article
=43;
280 UPDATE spip_articles
SET id_rubrique
=83 WHERE id_article
=5;
281 UPDATE spip_articles
SET id_rubrique
=83 WHERE id_article
=20;
282 UPDATE spip_articles
SET id_rubrique
=83 WHERE id_article
=65;
283 UPDATE spip_articles
SET id_rubrique
=83 WHERE id_article
=72;
284 UPDATE spip_articles
SET id_rubrique
=83 WHERE id_article
=98;
285 UPDATE spip_articles
SET id_rubrique
=83 WHERE id_article
=212;
286 UPDATE spip_articles
SET id_rubrique
=83 WHERE id_article
=103;
287 UPDATE spip_articles
SET id_rubrique
=83 WHERE id_article
=290;
290 -- --------------------------------------------------------
293 -- Publication des nouvelles rubriques
296 UPDATE spip_rubriques
SET statut
='publie' WHERE id_rubrique
IN (65,66,67,68,69,70,71,72,73,74,75,76,77,78,79,80,81,82,83,84,85);
298 -- --------------------------------------------------------
301 -- Structure de la table `spip_menus`
304 CREATE TABLE IF NOT EXISTS `spip_menus`
(
305 `id_menu`
bigint(21) NOT NULL AUTO_INCREMENT
,
306 `id_menus_entree`
bigint(21) NOT NULL DEFAULT '0',
307 `titre`
text COLLATE utf8_bin
NOT NULL,
308 `identifiant`
varchar(255) COLLATE utf8_bin
NOT NULL DEFAULT '',
309 `css` tinytext
COLLATE utf8_bin
NOT NULL,
310 PRIMARY KEY (`id_menu`
),
311 KEY `id_menus_entree`
(`id_menus_entree`
)
312 ) ENGINE
=InnoDB
DEFAULT CHARSET
=utf8
COLLATE=utf8_bin AUTO_INCREMENT
=6 ;
315 -- Contenu de la table `spip_menus`
318 INSERT INTO `spip_menus`
(`id_menu`
, `id_menus_entree`
, `titre`
, `identifiant`
, `css`
) VALUES
319 (1, 0, 'Barre de navigation', 'menu', ''),
325 -- --------------------------------------------------------
328 -- Structure de la table `spip_menus_entrees`
331 CREATE TABLE IF NOT EXISTS `spip_menus_entrees`
(
332 `id_menus_entree`
bigint(21) NOT NULL AUTO_INCREMENT
,
333 `id_menu`
bigint(21) NOT NULL DEFAULT '0',
334 `rang`
smallint(6) NOT NULL DEFAULT '1',
335 `type_entree` tinytext
COLLATE utf8_bin
NOT NULL,
336 `parametres`
text COLLATE utf8_bin
NOT NULL,
337 PRIMARY KEY (`id_menus_entree`
),
338 KEY `id_menu`
(`id_menu`
)
339 ) ENGINE
=InnoDB
DEFAULT CHARSET
=utf8
COLLATE=utf8_bin AUTO_INCREMENT
=23 ;
342 -- Contenu de la table `spip_menus_entrees`
345 INSERT INTO `spip_menus_entrees`
(`id_menus_entree`
, `id_menu`
, `rang`
, `type_entree`
, `parametres`
) VALUES
346 (1, 1, 1, 'texte_libre', 'a:2:{s:7:"contenu";s:13:"L''association";s:3:"css";s:0:"";}'),
347 (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:"";}'),
348 (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:"";}'),
349 (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:"";}'),
350 (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:"";}'),
351 (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:"";}'),
352 (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:"";}'),
353 (8, 1, 2, 'texte_libre', 'a:2:{s:7:"contenu";s:14:"Les activités";s:3:"css";s:0:"";}'),
354 (9, 1, 3, 'texte_libre', 'a:2:{s:7:"contenu";s:14:"Rejoignez-nous";s:3:"css";s:0:"";}'),
355 (10, 1, 4, 'texte_libre', 'a:2:{s:7:"contenu";s:8:"Réseaux";s:3:"css";s:0:"";}'),
356 (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:"";}'),
357 (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:"";}'),
358 (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:"";}'),
359 (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:"";}'),
360 (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:"";}'),
361 (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:"";}'),
362 (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:"";}'),
363 (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:"";}'),
364 (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:"";}'),
365 (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:"";}'),
366 (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:"";}'),
367 (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:"";}');
369 UPDATE spip_meta
SET valeur
= 'a:5:{s:13:"configuration";a:11:{s:12:"page_accueil";s:6:"slide2";s:8:"intranet";s:3:"non";s:17:"calendrier_public";s:3:"oui";s:8:"fils_rss";s:3:"non";s:7:"version";s:9:"2.0 [551]";s:14:"nb_article_une";s:1:"6";s:16:"nb_ligne_sousune";s:1:"1";s:21:"nb_article_col_droite";s:1:"1";s:15:"autres_articles";s:3:"oui";s:19:"articles_populaires";s:3:"oui";s:20:"nb_evenement_accueil";s:1:"5";}s:9:"affichage";a:22:{s:11:"fond_entete";s:18:"pixel_couleur1.gif";s:4:"logo";s:10:"transp.gif";s:12:"logo_largeur";s:3:"600";s:12:"logo_hauteur";s:3:"135";s:10:"site_ombre";s:3:"oui";s:18:"cartouche_services";s:3:"non";s:19:"affichage_portfolio";s:5:"menug";s:16:"emplacement_date";s:6:"entete";s:21:"emplacement_recherche";s:4:"haut";s:14:"dates_articles";s:3:"non";s:12:"dates_breves";s:3:"non";s:16:"auteurs_articles";s:3:"non";s:25:"derniere_date_publication";s:3:"non";s:8:"nom_site";s:3:"oui";s:14:"hauteur_entete";s:3:"150";s:12:"hauteur_menu";s:2:"45";s:13:"nb_items_menu";s:1:"5";s:10:"menu_debut";s:3:"oui";s:18:"largeur_items_menu";s:1:"0";s:16:"taille_typo_menu";s:3:"1.1";s:24:"libelle_rubrique_article";s:3:"oui";s:17:"modele_pagination";s:0:"";}s:4:"menu";a:14:{s:13:"menu_vertical";s:3:"oui";s:26:"menu_liens_deplier_replier";s:3:"non";s:13:"menu_articles";s:3:"oui";s:15:"menu_horizontal";s:3:"oui";s:11:"lien_agenda";s:3:"oui";s:14:"lien_reactions";s:3:"non";s:12:"lien_usagers";s:3:"oui";s:13:"lien_actu_web";s:3:"oui";s:15:"lien_newsletter";s:3:"non";s:13:"lien_annuaire";s:3:"non";s:14:"lien_portfolio";s:3:"non";s:15:"index_mots_cles";s:3:"non";s:9:"lien_plan";s:3:"oui";s:21:"lien_espace_redacteur";s:3:"non";}s:6:"themes";a:1:{s:5:"theme";s:6:"perso1";}s:7:"couleur";a:18:{s:18:"couleur_principale";s:7:"#e76e06";s:25:"couleur_secondaire_foncee";s:7:"#9f5d00";s:25:"couleur_secondaire_claire";s:7:"#eb7b1b";s:24:"couleur_principale_texte";s:7:"#666666";s:22:"beespip_couleur_titres";s:7:"#444444";s:13:"couleur_liens";s:7:"#6b2b01";s:17:"couleur_fond_page";s:7:"#ffffff";s:17:"couleur_menu_fond";s:7:"#f5f4f3";s:18:"couleur_menu_liens";s:7:"#666666";s:25:"couleur_menu_liens_survol";s:7:"#000000";s:21:"couleur_filets_titres";s:7:"#ebebeb";s:23:"couleur_filets_colonnes";s:7:"#e8e8e8";s:14:"couleur_cadres";s:7:"#ebebeb";s:20:"couleur_liens_survol";s:7:"#0094d3";s:24:"couleur_fond_formulaires";s:7:"#f8f8f8";s:14:"couleur_titres";s:7:"#444444";s:15:"typo_titre_lien";s:0:"";s:10:"typo_titre";s:0:"";}}' WHERE nom
= 'Beespip';