X-Git-Url: http://git.cyclocoop.org/?p=ptitvelo%2Fweb%2Fwww.git;a=blobdiff_plain;f=scripts%2Fv2-v3.sql;h=aa7c6b430faeb7053694845f395556ab7048d976;hp=8806815441446b1705804128d6ed9f0feaec9adf;hb=a0983633f8ccaeb0514beef5a9348a5f6abc37df;hpb=fe9dce5835edd4aff91f187ec833f2ea9301b3d0

diff --git a/scripts/v2-v3.sql b/scripts/v2-v3.sql
index 8806815..aa7c6b4 100644
--- 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,227 @@ 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;
+
+
+-- --------------------------------------------------------
+
+--
+-- Publication des nouvelles rubriques
+--
+
+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);
+
+-- --------------------------------------------------------
+
+--
+-- 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:"";}');
+
+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';
+