scripts/v2-v3.sql

   1 -- --------------------------------------------------------
   2
   3 --
   4 -- Transfert des articles vers la nouvelle organisation
   5 --
   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;
 288
 289
 290 -- --------------------------------------------------------
 291
 292 --
 293 -- Publication des nouvelles rubriques
 294 --
 295
 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);
 297
 298 -- --------------------------------------------------------
 299
 300 --
 301 -- Structure de la table `spip_menus`
 302 --
 303
 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 ;
 313
 314 --
 315 -- Contenu de la table `spip_menus`
 316 --
 317
 318 INSERT INTO `spip_menus` (`id_menu`, `id_menus_entree`, `titre`, `identifiant`, `css`) VALUES
 319 (1, 0, 'Barre de navigation', 'menu', ''),
 320 (2, 1, '', '', ''),
 321 (3, 8, '', '', ''),
 322 (4, 9, '', '', ''),
 323 (5, 10, '', '', '');
 324
 325 -- --------------------------------------------------------
 326
 327 --
 328 -- Structure de la table `spip_menus_entrees`
 329 --
 330
 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 ;
 340
 341 --
 342 -- Contenu de la table `spip_menus_entrees`
 343 --
 344
 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:"";}');