diff -u -r -N ojs-2.3.4-stock/dbscripts/xml/upgrade/2.3.5_update.xml ojs-2.3.4/dbscripts/xml/upgrade/2.3.5_update.xml --- ojs-2.3.4-stock/dbscripts/xml/upgrade/2.3.5_update.xml 1969-12-31 16:00:00.000000000 -0800 +++ ojs-2.3.4/dbscripts/xml/upgrade/2.3.5_update.xml 2011-03-08 15:00:44.000000000 -0800 @@ -0,0 +1,33 @@ + + + + + + + + + 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, articles a SET pa.date_published = NULL WHERE a.article_id = pa.article_id AND UNIX_TIMESTAMP(pa.date_published) - UNIX_TIMESTAMP(a.date_submitted) < 300 AND UNIX_TIMESTAMP(pa.date_published) - UNIX_TIMESTAMP(a.date_submitted) >= 0 + UPDATE published_articles SET date_published = NULL WHERE article_id IN (SELECT a.article_id FROM published_articles pa, articles a WHERE a.article_id = pa.article_id AND EXTRACT(EPOCH FROM pa.date_published) - EXTRACT(EPOCH FROM a.date_submitted) < 300 AND EXTRACT(EPOCH FROM pa.date_published) - EXTRACT(EPOCH FROM a.date_submitted) >= 0) + + diff -u -r -N ojs-2.3.4-stock/dbscripts/xml/upgrade.xml ojs-2.3.4/dbscripts/xml/upgrade.xml --- ojs-2.3.4-stock/dbscripts/xml/upgrade.xml 2011-02-01 14:20:03.000000000 -0800 +++ ojs-2.3.4/dbscripts/xml/upgrade.xml 2011-03-08 10:38:58.000000000 -0800 @@ -253,6 +253,10 @@ + + + +