[SQL] +requete de migration de la structure du site de la v2-->v3

diff --git a/scripts/v2-v3.sql b/scripts/v2-v3.sql
new file mode 100644 (file)
index 0000000..8806815
--- /dev/null
+++ b/scripts/v2-v3.sql
@@ -0,0 +1,141 @@
+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;