Ruud Koot has uploaded a new change for review.
https://gerrit.wikimedia.org/r/65309
Change subject: Add an option to show related changes to associated pages (1/2)
......................................................................
Add an option to show related changes to associated pages (1/2)
Add a new option to the related changes special
pages, making it possible to also show changes to
the associated page of this pages linked to (i.e.
the talk page associated with a content page or
vice versa.)
Part 1 of 2: Add an additional field to the recent
changes table caching the associated page of the
changed page, so we can avoid a join query in the
second patch.
Change-Id: Iea44f4a5cdbd972259457c3dde2acba0b4cc662e
---
M includes/installer/MysqlUpdater.php
M includes/installer/SqliteUpdater.php
A maintenance/archives/patch-rc_cur_id_assoc.sql
3 files changed, 4 insertions(+), 0 deletions(-)
git pull ssh://gerrit.wikimedia.org:29418/mediawiki/core
refs/changes/09/65309/1
diff --git a/includes/installer/MysqlUpdater.php
b/includes/installer/MysqlUpdater.php
index 1c22afb..00beced 100644
--- a/includes/installer/MysqlUpdater.php
+++ b/includes/installer/MysqlUpdater.php
@@ -231,6 +231,7 @@
// 1.22
array( 'doIwlinksIndexNonUnique' ),
array( 'addIndex', 'iwlinks', 'iwl_prefix_from_title',
'patch-iwlinks-from-title-index.sql' ),
+ array( 'addField', 'recentchanges', 'rc_cur_id_assoc',
'patch-rc_cur_id_assoc.sql' ),
);
}
diff --git a/includes/installer/SqliteUpdater.php
b/includes/installer/SqliteUpdater.php
index 28d8d66..3c8a4e3 100644
--- a/includes/installer/SqliteUpdater.php
+++ b/includes/installer/SqliteUpdater.php
@@ -109,6 +109,7 @@
array( 'addIndex', 'page_props', 'pp_propname_page',
'patch-page_props-propname-page-index.sql' ),
array( 'addIndex', 'image', 'img_media_mime',
'patch-img_media_mime-index.sql' ),
array( 'addIndex', 'iwlinks', 'iwl_prefix_from_title',
'patch-iwlinks-from-title-index.sql' ),
+ array( 'addField', 'recentchanges', 'rc_cur_id_assoc',
'patch-rc_cur_id_assoc.sql' ),
);
}
diff --git a/maintenance/archives/patch-rc_cur_id_assoc.sql
b/maintenance/archives/patch-rc_cur_id_assoc.sql
new file mode 100644
index 0000000..6915971
--- /dev/null
+++ b/maintenance/archives/patch-rc_cur_id_assoc.sql
@@ -0,0 +1,2 @@
+ALTER TABLE /*_*/recentchanges
+ ADD COLUMN rc_cur_id_assoc int UNSIGNED NULL AFTER rc_cur_id;
--
To view, visit https://gerrit.wikimedia.org/r/65309
To unsubscribe, visit https://gerrit.wikimedia.org/r/settings
Gerrit-MessageType: newchange
Gerrit-Change-Id: Iea44f4a5cdbd972259457c3dde2acba0b4cc662e
Gerrit-PatchSet: 1
Gerrit-Project: mediawiki/core
Gerrit-Branch: master
Gerrit-Owner: Ruud Koot <[email protected]>
_______________________________________________
MediaWiki-commits mailing list
[email protected]
https://lists.wikimedia.org/mailman/listinfo/mediawiki-commits
