https://www.mediawiki.org/wiki/Special:Code/MediaWiki/113383
Revision: 113383
Author: emsmith
Date: 2012-03-08 19:25:12 +0000 (Thu, 08 Mar 2012)
Log Message:
-----------
bug 34090 - not entirely necessary, but keeps $2 from showing up in hiders
panels in production on old data
Modified Paths:
--------------
trunk/extensions/ArticleFeedbackv5/sql/alter.sql
Modified: trunk/extensions/ArticleFeedbackv5/sql/alter.sql
===================================================================
--- trunk/extensions/ArticleFeedbackv5/sql/alter.sql 2012-03-08 19:22:13 UTC
(rev 113382)
+++ trunk/extensions/ArticleFeedbackv5/sql/alter.sql 2012-03-08 19:25:12 UTC
(rev 113383)
@@ -143,4 +143,8 @@
-- Added 3/5 (emsmith)\
DROP INDEX /*_*/af_net_helpfulness_af_id;
-CREATE INDEX /*_*/af_net_helpfulness_af_id ON /*_*/aft_article_feedback
(af_net_helpfulness, af_id);
\ No newline at end of file
+CREATE INDEX /*_*/af_net_helpfulness_af_id ON /*_*/aft_article_feedback
(af_net_helpfulness, af_id);
+
+-- make sure all old feedback has dates, even if they're wrong
+UPDATE aft_article_feedback SET af_hide_timestamp = NOW() WHERE af_is_hidden
IS TRUE AND af_hide_timestamp = '';
+UPDATE aft_article_feedback SET af_oversight_timestamp = NOW() WHERE
af_is_deleted IS TRUE AND af_oversight_timestamp = '';
_______________________________________________
MediaWiki-CVS mailing list
[email protected]
https://lists.wikimedia.org/mailman/listinfo/mediawiki-cvs
