From f571440c7fa2e33958f5b9d22a9c057e42ed66ee Mon Sep 17 00:00:00 2001 From: Ludovic CHEVALIER Date: Wed, 5 Jun 2013 12:06:59 +0200 Subject: [PATCH] [SQL] ~requete de migration : nouveau menu --- scripts/v2-v3.sql | 218 ++++++++++++++++++++++++++++++++++++++++++++++ 1 file changed, 218 insertions(+) diff --git a/scripts/v2-v3.sql b/scripts/v2-v3.sql index 8806815..99befd2 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,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:"";}'); -- 2.20.1