diff --git a/dbscripts/xml/upgrade/2.3.5_update.xml b/dbscripts/xml/upgrade/2.3.5_update.xml new file mode 100644 index 0000000..e7804a9 --- /dev/null +++ b/dbscripts/xml/upgrade/2.3.5_update.xml @@ -0,0 +1,34 @@ + + + + + + + + + ALTER TABLE published_articles CHANGE COLUMN date_published date_published DATETIME + ALTER TABLE published_articles ALTER COLUMN date_published DROP NOT NULL + + + + + UPDATE published_articles pa, edit_decisions e1, edit_decisions e2, articles a SET pa.date_published = NULL WHERE pa.article_id = a.article_id AND e1.article_id = a.article_id AND e2.article_id = a.article_id AND e1.edit_decision_id <> e2.edit_decision_id AND e1.date_decided = e2.date_decided AND pa.date_published >= a.date_submitted + UPDATE published_articles SET date_published = NULL WHERE article_id IN (SELECT DISTINCT a.article_id FROM articles a, published_articles pa, edit_decisions e1, edit_decisions e2 WHERE pa.article_id = a.article_id AND e1.article_id = a.article_id AND e2.article_id = a.article_id AND e1.edit_decision_id <> e2.edit_decision_id AND e1.date_decided = e2.date_decided AND pa.date_published >= a.date_submitted) + +