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 @@
+
+
+
+