[SQL] ~requete de migration : nouveau menu

diff --git a/scripts/v2-v3.sql b/scripts/v2-v3.sql
index 8806815..99befd2 100644 (file)
--- a/scripts/v2-v3.sql
+++ b/scripts/v2-v3.sql
@@ -1,3 +1,8 @@
+-- --------------------------------------------------------
+
+--
+-- Transfert des articles vers la nouvelle organisation
+--
 UPDATE spip_articles SET id_rubrique=2 WHERE id_article=109;
 UPDATE spip_articles SET id_rubrique=2 WHERE id_article=197;
 UPDATE spip_articles SET id_rubrique=2 WHERE id_article=228;
@@ -139,3 +144,216 @@ UPDATE spip_articles SET id_rubrique=83 WHERE id_article=98;
 UPDATE spip_articles SET id_rubrique=83 WHERE id_article=212;
 UPDATE spip_articles SET id_rubrique=83 WHERE id_article=103;
 UPDATE spip_articles SET id_rubrique=83 WHERE id_article=290;
+
+UPDATE spip_articles SET id_rubrique=2 WHERE id_article=109;
+UPDATE spip_articles SET id_rubrique=2 WHERE id_article=197;
+UPDATE spip_articles SET id_rubrique=2 WHERE id_article=228;
+UPDATE spip_articles SET id_rubrique=2 WHERE id_article=297;
+UPDATE spip_articles SET id_rubrique=2 WHERE id_article=53;
+UPDATE spip_articles SET id_rubrique=2 WHERE id_article=285;
+UPDATE spip_articles SET id_rubrique=5 WHERE id_article=11;
+UPDATE spip_articles SET id_rubrique=5 WHERE id_article=46;
+UPDATE spip_articles SET id_rubrique=5 WHERE id_article=187;
+UPDATE spip_articles SET id_rubrique=5 WHERE id_article=217;
+UPDATE spip_articles SET id_rubrique=5 WHERE id_article=247;
+UPDATE spip_articles SET id_rubrique=5 WHERE id_article=222;
+UPDATE spip_articles SET id_rubrique=5 WHERE id_article=166;
+UPDATE spip_articles SET id_rubrique=5 WHERE id_article=38;
+UPDATE spip_articles SET id_rubrique=5 WHERE id_article=39;
+UPDATE spip_articles SET id_rubrique=5 WHERE id_article=119;
+UPDATE spip_articles SET id_rubrique=5 WHERE id_article=171;
+UPDATE spip_articles SET id_rubrique=65 WHERE id_article=15;
+UPDATE spip_articles SET id_rubrique=65 WHERE id_article=45;
+UPDATE spip_articles SET id_rubrique=66 WHERE id_article=16;
+UPDATE spip_articles SET id_rubrique=66 WHERE id_article=183;
+UPDATE spip_articles SET id_rubrique=66 WHERE id_article=70;
+UPDATE spip_articles SET id_rubrique=66 WHERE id_article=42;
+UPDATE spip_articles SET id_rubrique=66 WHERE id_article=56;
+UPDATE spip_articles SET id_rubrique=66 WHERE id_article=190;
+UPDATE spip_articles SET id_rubrique=67 WHERE id_article=17;
+UPDATE spip_articles SET id_rubrique=67 WHERE id_article=141;
+UPDATE spip_articles SET id_rubrique=67 WHERE id_article=189;
+UPDATE spip_articles SET id_rubrique=67 WHERE id_article=223;
+UPDATE spip_articles SET id_rubrique=68 WHERE id_article=23;
+UPDATE spip_articles SET id_rubrique=68 WHERE id_article=29;
+UPDATE spip_articles SET id_rubrique=68 WHERE id_article=36;
+UPDATE spip_articles SET id_rubrique=68 WHERE id_article=37;
+UPDATE spip_articles SET id_rubrique=68 WHERE id_article=225;
+UPDATE spip_articles SET id_rubrique=69 WHERE id_article=24;
+UPDATE spip_articles SET id_rubrique=69 WHERE id_article=245;
+UPDATE spip_articles SET id_rubrique=70 WHERE id_article=50;
+UPDATE spip_articles SET id_rubrique=70 WHERE id_article=167;
+UPDATE spip_articles SET id_rubrique=70 WHERE id_article=49;
+UPDATE spip_articles SET id_rubrique=70 WHERE id_article=62;
+UPDATE spip_articles SET id_rubrique=70 WHERE id_article=63;
+UPDATE spip_articles SET id_rubrique=70 WHERE id_article=126;
+UPDATE spip_articles SET id_rubrique=70 WHERE id_article=44;
+UPDATE spip_articles SET id_rubrique=70 WHERE id_article=169;
+UPDATE spip_articles SET id_rubrique=70 WHERE id_article=179;
+UPDATE spip_articles SET id_rubrique=71 WHERE id_article=52;
+UPDATE spip_articles SET id_rubrique=71 WHERE id_article=76;
+UPDATE spip_articles SET id_rubrique=72 WHERE id_article=60;
+UPDATE spip_articles SET id_rubrique=72 WHERE id_article=170;
+UPDATE spip_articles SET id_rubrique=72 WHERE id_article=27;
+UPDATE spip_articles SET id_rubrique=72 WHERE id_article=18;
+UPDATE spip_articles SET id_rubrique=72 WHERE id_article=26;
+UPDATE spip_articles SET id_rubrique=72 WHERE id_article=28;
+UPDATE spip_articles SET id_rubrique=72 WHERE id_article=47;
+UPDATE spip_articles SET id_rubrique=72 WHERE id_article=48;
+UPDATE spip_articles SET id_rubrique=72 WHERE id_article=51;
+UPDATE spip_articles SET id_rubrique=72 WHERE id_article=55;
+UPDATE spip_articles SET id_rubrique=72 WHERE id_article=58;
+UPDATE spip_articles SET id_rubrique=72 WHERE id_article=66;
+UPDATE spip_articles SET id_rubrique=72 WHERE id_article=258;
+UPDATE spip_articles SET id_rubrique=72 WHERE id_article=110;
+UPDATE spip_articles SET id_rubrique=72 WHERE id_article=113;
+UPDATE spip_articles SET id_rubrique=72 WHERE id_article=123;
+UPDATE spip_articles SET id_rubrique=72 WHERE id_article=244;
+UPDATE spip_articles SET id_rubrique=72 WHERE id_article=249;
+UPDATE spip_articles SET id_rubrique=72 WHERE id_article=253;
+UPDATE spip_articles SET id_rubrique=72 WHERE id_article=161;
+UPDATE spip_articles SET id_rubrique=72 WHERE id_article=191;
+UPDATE spip_articles SET id_rubrique=72 WHERE id_article=213;
+UPDATE spip_articles SET id_rubrique=72 WHERE id_article=280;
+UPDATE spip_articles SET id_rubrique=72 WHERE id_article=201;
+UPDATE spip_articles SET id_rubrique=72 WHERE id_article=165;
+UPDATE spip_articles SET id_rubrique=72 WHERE id_article=122;
+UPDATE spip_articles SET id_rubrique=72 WHERE id_article=275;
+UPDATE spip_articles SET id_rubrique=73 WHERE id_article=282;
+UPDATE spip_articles SET id_rubrique=73 WHERE id_article=71;
+UPDATE spip_articles SET id_rubrique=73 WHERE id_article=100;
+UPDATE spip_articles SET id_rubrique=73 WHERE id_article=114;
+UPDATE spip_articles SET id_rubrique=73 WHERE id_article=248;
+UPDATE spip_articles SET id_rubrique=73 WHERE id_article=40;
+UPDATE spip_articles SET id_rubrique=74 WHERE id_article=41;
+UPDATE spip_articles SET id_rubrique=74 WHERE id_article=157;
+UPDATE spip_articles SET id_rubrique=74 WHERE id_article=283;
+UPDATE spip_articles SET id_rubrique=74 WHERE id_article=278;
+UPDATE spip_articles SET id_rubrique=74 WHERE id_article=293;
+UPDATE spip_articles SET id_rubrique=74 WHERE id_article=292;
+UPDATE spip_articles SET id_rubrique=74 WHERE id_article=1;
+UPDATE spip_articles SET id_rubrique=74 WHERE id_article=10;
+UPDATE spip_articles SET id_rubrique=74 WHERE id_article=6;
+UPDATE spip_articles SET id_rubrique=74 WHERE id_article=73;
+UPDATE spip_articles SET id_rubrique=74 WHERE id_article=74;
+UPDATE spip_articles SET id_rubrique=74 WHERE id_article=75;
+UPDATE spip_articles SET id_rubrique=74 WHERE id_article=145;
+UPDATE spip_articles SET id_rubrique=74 WHERE id_article=121;
+UPDATE spip_articles SET id_rubrique=74 WHERE id_article=124;
+UPDATE spip_articles SET id_rubrique=74 WHERE id_article=125;
+UPDATE spip_articles SET id_rubrique=74 WHERE id_article=160;
+UPDATE spip_articles SET id_rubrique=74 WHERE id_article=159;
+UPDATE spip_articles SET id_rubrique=74 WHERE id_article=174;
+UPDATE spip_articles SET id_rubrique=74 WHERE id_article=196;
+UPDATE spip_articles SET id_rubrique=74 WHERE id_article=194;
+UPDATE spip_articles SET id_rubrique=74 WHERE id_article=198;
+UPDATE spip_articles SET id_rubrique=74 WHERE id_article=207;
+UPDATE spip_articles SET id_rubrique=74 WHERE id_article=209;
+UPDATE spip_articles SET id_rubrique=74 WHERE id_article=232;
+UPDATE spip_articles SET id_rubrique=74 WHERE id_article=256;
+UPDATE spip_articles SET id_rubrique=74 WHERE id_article=257;
+UPDATE spip_articles SET id_rubrique=74 WHERE id_article=265;
+UPDATE spip_articles SET id_rubrique=74 WHERE id_article=267;
+UPDATE spip_articles SET id_rubrique=74 WHERE id_article=272;
+UPDATE spip_articles SET id_rubrique=74 WHERE id_article=276;
+UPDATE spip_articles SET id_rubrique=74 WHERE id_article=153;
+UPDATE spip_articles SET id_rubrique=74 WHERE id_article=277;
+UPDATE spip_articles SET id_rubrique=74 WHERE id_article=281;
+UPDATE spip_articles SET id_rubrique=74 WHERE id_article=286;
+UPDATE spip_articles SET id_rubrique=75 WHERE id_article=8;
+UPDATE spip_articles SET id_rubrique=75 WHERE id_article=54;
+UPDATE spip_articles SET id_rubrique=76 WHERE id_article=13;
+UPDATE spip_articles SET id_rubrique=77 WHERE id_article=19;
+UPDATE spip_articles SET id_rubrique=77 WHERE id_article=192;
+UPDATE spip_articles SET id_rubrique=78 WHERE id_article=35;
+UPDATE spip_articles SET id_rubrique=78 WHERE id_article=185;
+UPDATE spip_articles SET id_rubrique=79 WHERE id_article=31;
+UPDATE spip_articles SET id_rubrique=79 WHERE id_article=68;
+UPDATE spip_articles SET id_rubrique=79 WHERE id_article=69;
+UPDATE spip_articles SET id_rubrique=79 WHERE id_article=104;
+UPDATE spip_articles SET id_rubrique=79 WHERE id_article=263;
+UPDATE spip_articles SET id_rubrique=80 WHERE id_article=295;
+UPDATE spip_articles SET id_rubrique=81 WHERE id_article=77;
+UPDATE spip_articles SET id_rubrique=81 WHERE id_article=78;
+UPDATE spip_articles SET id_rubrique=81 WHERE id_article=162;
+UPDATE spip_articles SET id_rubrique=82 WHERE id_article=14;
+UPDATE spip_articles SET id_rubrique=82 WHERE id_article=43;
+UPDATE spip_articles SET id_rubrique=83 WHERE id_article=5;
+UPDATE spip_articles SET id_rubrique=83 WHERE id_article=20;
+UPDATE spip_articles SET id_rubrique=83 WHERE id_article=65;
+UPDATE spip_articles SET id_rubrique=83 WHERE id_article=72;
+UPDATE spip_articles SET id_rubrique=83 WHERE id_article=98;
+UPDATE spip_articles SET id_rubrique=83 WHERE id_article=212;
+UPDATE spip_articles SET id_rubrique=83 WHERE id_article=103;
+UPDATE spip_articles SET id_rubrique=83 WHERE id_article=290;
+
+-- --------------------------------------------------------
+
+--
+-- Structure de la table `spip_menus`
+--
+
+CREATE TABLE IF NOT EXISTS `spip_menus` (
+  `id_menu` bigint(21) NOT NULL AUTO_INCREMENT,
+  `id_menus_entree` bigint(21) NOT NULL DEFAULT '0',
+  `titre` text COLLATE utf8_bin NOT NULL,
+  `identifiant` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
+  `css` tinytext COLLATE utf8_bin NOT NULL,
+  PRIMARY KEY (`id_menu`),
+  KEY `id_menus_entree` (`id_menus_entree`)
+) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_bin AUTO_INCREMENT=6 ;
+
+--
+-- Contenu de la table `spip_menus`
+--
+
+INSERT INTO `spip_menus` (`id_menu`, `id_menus_entree`, `titre`, `identifiant`, `css`) VALUES
+(1, 0, 'Barre de navigation', 'menu', ''),
+(2, 1, '', '', ''),
+(3, 8, '', '', ''),
+(4, 9, '', '', ''),
+(5, 10, '', '', '');
+
+-- --------------------------------------------------------
+
+--
+-- Structure de la table `spip_menus_entrees`
+--
+
+CREATE TABLE IF NOT EXISTS `spip_menus_entrees` (
+  `id_menus_entree` bigint(21) NOT NULL AUTO_INCREMENT,
+  `id_menu` bigint(21) NOT NULL DEFAULT '0',
+  `rang` smallint(6) NOT NULL DEFAULT '1',
+  `type_entree` tinytext COLLATE utf8_bin NOT NULL,
+  `parametres` text COLLATE utf8_bin NOT NULL,
+  PRIMARY KEY (`id_menus_entree`),
+  KEY `id_menu` (`id_menu`)
+) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_bin AUTO_INCREMENT=23 ;
+
+--
+-- Contenu de la table `spip_menus_entrees`
+--
+
+INSERT INTO `spip_menus_entrees` (`id_menus_entree`, `id_menu`, `rang`, `type_entree`, `parametres`) VALUES
+(1, 1, 1, 'texte_libre', 'a:2:{s:7:"contenu";s:13:"L''association";s:3:"css";s:0:"";}'),
+(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:"";}'),
+(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:"";}'),
+(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:"";}'),
+(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:"";}'),
+(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:"";}'),
+(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:"";}'),
+(8, 1, 2, 'texte_libre', 'a:2:{s:7:"contenu";s:14:"Les activités";s:3:"css";s:0:"";}'),
+(9, 1, 3, 'texte_libre', 'a:2:{s:7:"contenu";s:14:"Rejoignez-nous";s:3:"css";s:0:"";}'),
+(10, 1, 4, 'texte_libre', 'a:2:{s:7:"contenu";s:8:"Réseaux";s:3:"css";s:0:"";}'),
+(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:"";}'),
+(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:"";}'),
+(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:"";}'),
+(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:"";}'),
+(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:"";}'),
+(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:"";}'),
+(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:"";}'),
+(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:"";}'),
+(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:"";}'),
+(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:"";}'),
+(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:"";}'),
+(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:"";}');