coren has uploaded a new change for review.
https://gerrit.wikimedia.org/r/92337
Change subject: Labs DB: add recentchanges_userindex view
......................................................................
Labs DB: add recentchanges_userindex view
To allow efficient indexing over rc_user and rc_user_text
Change-Id: Id540bf743a65cad98d7dd3bcab68ce9af2435b40
---
M maintain-replicas/maintain-replicas.pl
1 file changed, 9 insertions(+), 0 deletions(-)
git pull ssh://gerrit.wikimedia.org:29418/operations/software
refs/changes/37/92337/1
diff --git a/maintain-replicas/maintain-replicas.pl
b/maintain-replicas/maintain-replicas.pl
index 9d40a31..6187e7e 100755
--- a/maintain-replicas/maintain-replicas.pl
+++ b/maintain-replicas/maintain-replicas.pl
@@ -208,6 +208,15 @@
rc_this_oldid, rc_last_oldid, rc_type, rc_patrolled, null
as rc_ip, rc_old_len,
rc_new_len, rc_deleted, rc_logid, rc_log_type,
rc_log_action, rc_params' },
+ 'recentchanges_userindex' => {
+ 'source' => 'recentchanges',
+ 'view' => 'select rc_id, rc_timestamp, rc_cur_time, rc_user,
+ rc_user_text, rc_namespace, rc_title,
+ if(rc_deleted&2,null,rc_comment) as rc_comment, rc_minor,
rc_bot, rc_new, rc_cur_id,
+ rc_this_oldid, rc_last_oldid, rc_type, rc_patrolled, null
as rc_ip, rc_old_len,
+ rc_new_len, rc_deleted, rc_logid, rc_log_type,
rc_log_action, rc_params',
+ 'where' => '(rc_deleted&4)==0' },
+
'revision' => {
'source' => 'revision',
'view' => 'select rev_id, rev_page, if(rev_deleted&1,null,rev_text_id)
as rev_text_id,
--
To view, visit https://gerrit.wikimedia.org/r/92337
To unsubscribe, visit https://gerrit.wikimedia.org/r/settings
Gerrit-MessageType: newchange
Gerrit-Change-Id: Id540bf743a65cad98d7dd3bcab68ce9af2435b40
Gerrit-PatchSet: 1
Gerrit-Project: operations/software
Gerrit-Branch: master
Gerrit-Owner: coren <[email protected]>
_______________________________________________
MediaWiki-commits mailing list
[email protected]
https://lists.wikimedia.org/mailman/listinfo/mediawiki-commits
