Joal has uploaded a new change for review. (
https://gerrit.wikimedia.org/r/337793 )
Change subject: Add new fields to archive_p view in labsdb
......................................................................
Add new fields to archive_p view in labsdb
content_model and content_format fields have been added to the revision
and archive table a wile ago. They are reflected in revision_p view in labs
but not yet in archive_p view.
This patch makes them available in archive_p.
Bug: T155658
Change-Id: Id8d741a732f2fec5b85b3efbcf2d7608e84db26f
---
M modules/role/templates/labs/db/views/maintain-views.yaml
1 file changed, 2 insertions(+), 2 deletions(-)
git pull ssh://gerrit.wikimedia.org:29418/operations/puppet
refs/changes/93/337793/1
diff --git a/modules/role/templates/labs/db/views/maintain-views.yaml
b/modules/role/templates/labs/db/views/maintain-views.yaml
index d70af82..991328b 100644
--- a/modules/role/templates/labs/db/views/maintain-views.yaml
+++ b/modules/role/templates/labs/db/views/maintain-views.yaml
@@ -205,14 +205,14 @@
if(ar_deleted&4,null,ar_user) as ar_user,
if(ar_deleted&4,null,ar_user_text) as
ar_user_text, ar_timestamp, ar_minor_edit, ar_flags, ar_rev_id,
if(ar_deleted&1,null,ar_text_id)
as ar_text_id, ar_deleted, if(ar_deleted&1,null,ar_len) as ar_len,
ar_page_id, ar_parent_id,
- if(ar_deleted&1,null,ar_sha1) as ar_sha1
+ if(ar_deleted&1,null,ar_sha1) as ar_sha1, ar_content_model,
ar_content_format
archive_userindex:
source: archive
view: >
select ar_id, ar_namespace, ar_title, NULL as ar_text, NULL as
ar_comment, ar_user,
ar_user_text, ar_timestamp, ar_minor_edit, ar_flags, ar_rev_id,
if(ar_deleted&1,null,ar_text_id)
as ar_text_id, ar_deleted, if(ar_deleted&1,null,ar_len) as ar_len,
ar_page_id, ar_parent_id,
- if(ar_deleted&1,null,ar_sha1) as ar_sha1
+ if(ar_deleted&1,null,ar_sha1) as ar_sha1, ar_content_model,
ar_content_format
where: (ar_deleted&4)=0
filearchive:
source: filearchive
--
To view, visit https://gerrit.wikimedia.org/r/337793
To unsubscribe, visit https://gerrit.wikimedia.org/r/settings
Gerrit-MessageType: newchange
Gerrit-Change-Id: Id8d741a732f2fec5b85b3efbcf2d7608e84db26f
Gerrit-PatchSet: 1
Gerrit-Project: operations/puppet
Gerrit-Branch: production
Gerrit-Owner: Joal <[email protected]>
_______________________________________________
MediaWiki-commits mailing list
[email protected]
https://lists.wikimedia.org/mailman/listinfo/mediawiki-commits
