From fe9dce5835edd4aff91f187ec833f2ea9301b3d0 Mon Sep 17 00:00:00 2001 From: Ludovic CHEVALIER Date: Wed, 5 Jun 2013 11:59:30 +0200 Subject: [PATCH] [SQL] +requete de migration de la structure du site de la v2-->v3 --- scripts/v2-v3.sql | 141 ++++++++++++++++++++++++++++++++++++++++++++++ 1 file changed, 141 insertions(+) create mode 100644 scripts/v2-v3.sql diff --git a/scripts/v2-v3.sql b/scripts/v2-v3.sql new file mode 100644 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; -- 2.20.1