dépôts
/
ptitvelo
/
web
/
www.git
/ blobdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
|
commitdiff
|
tree
raw
|
inline
| side by side
[SQL] +statut 'publie' pour les nouvelles rubriques
[ptitvelo/web/www.git]
/
scripts
/
v2-v3.sql
diff --git
a/scripts/v2-v3.sql
b/scripts/v2-v3.sql
index
99befd2
..
9509059
100644
(file)
--- a/
scripts/v2-v3.sql
+++ b/
scripts/v2-v3.sql
@@
-144,7
+144,6
@@
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=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=109;
UPDATE spip_articles SET id_rubrique=2 WHERE id_article=197;
UPDATE spip_articles SET id_rubrique=2 WHERE id_article=228;
@@
-287,6
+286,15
@@
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=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);
+
-- --------------------------------------------------------
--
-- --------------------------------------------------------
--