Matthias Mullie has submitted this change and it was merged.
Change subject: Add flow_workflow_update_timestamp index
......................................................................
Add flow_workflow_update_timestamp index
Bug: T102871
Change-Id: I6ea8981a295bae2776133959e7414a053cbd6e2d
---
M Hooks.php
A db_patches/patch-flow_workflow_update_timestamp_idx.sql
M flow.sql
3 files changed, 4 insertions(+), 0 deletions(-)
Approvals:
Chad: Looks good to me, but someone else must approve
Catrope: Looks good to me, but someone else must approve
Matthias Mullie: Looks good to me, approved
Springle: Looks good to me, but someone else must approve
EBernhardson: Looks good to me, but someone else must approve
jenkins-bot: Verified
diff --git a/Hooks.php b/Hooks.php
index a21f8f9..3a7b954 100644
--- a/Hooks.php
+++ b/Hooks.php
@@ -198,6 +198,7 @@
$updater->dropExtensionField( 'flow_workflow',
'workflow_user_ip', "$dir/db_patches/patch-drop_workflow_user.sql" );
$updater->addExtensionField( 'flow_revision',
'rev_content_length', "$dir/db_patches/patch-add-revision-content-length.sql" );
$updater->addExtensionIndex( 'flow_ext_ref',
'flow_ext_ref_idx', "$dir/db_patches/patch-remove_unique_ref_indices.sql" );
+ $updater->addExtensionIndex( 'flow_workflow',
'flow_workflow_update_timestamp',
"$dir/db_patches/patch-flow_workflow_update_timestamp_idx.sql" );
require_once __DIR__.'/maintenance/FlowUpdateRecentChanges.php';
$updater->addPostDatabaseUpdateMaintenance(
'FlowUpdateRecentChanges' );
diff --git a/db_patches/patch-flow_workflow_update_timestamp_idx.sql
b/db_patches/patch-flow_workflow_update_timestamp_idx.sql
new file mode 100644
index 0000000..b274f80
--- /dev/null
+++ b/db_patches/patch-flow_workflow_update_timestamp_idx.sql
@@ -0,0 +1,2 @@
+-- FlowForceSearchIndex.php maintenance script will request workflows between
timestamps
+CREATE INDEX /*i*/flow_workflow_update_timestamp ON /*_*/flow_workflow
(workflow_last_update_timestamp);
diff --git a/flow.sql b/flow.sql
index 2ba529e..37b4696 100644
--- a/flow.sql
+++ b/flow.sql
@@ -17,6 +17,7 @@
) /*$wgDBTableOptions*/;
CREATE INDEX /*i*/flow_workflow_lookup ON /*_*/flow_workflow (workflow_wiki,
workflow_namespace, workflow_title_text);
+CREATE INDEX /*i*/flow_workflow_update_timestamp ON /*_*/flow_workflow
(workflow_last_update_timestamp);
CREATE TABLE /*_*/flow_subscription (
subscription_workflow_id int unsigned not null,
--
To view, visit https://gerrit.wikimedia.org/r/195888
To unsubscribe, visit https://gerrit.wikimedia.org/r/settings
Gerrit-MessageType: merged
Gerrit-Change-Id: I6ea8981a295bae2776133959e7414a053cbd6e2d
Gerrit-PatchSet: 6
Gerrit-Project: mediawiki/extensions/Flow
Gerrit-Branch: master
Gerrit-Owner: Matthias Mullie <mmul...@wikimedia.org>
Gerrit-Reviewer: Catrope <roan.katt...@gmail.com>
Gerrit-Reviewer: Chad <ch...@wikimedia.org>
Gerrit-Reviewer: EBernhardson <ebernhard...@wikimedia.org>
Gerrit-Reviewer: Jcrespo <jcre...@wikimedia.org>
Gerrit-Reviewer: Matthias Mullie <mmul...@wikimedia.org>
Gerrit-Reviewer: SG <shah...@gmail.com>
Gerrit-Reviewer: Springle <sprin...@wikimedia.org>
Gerrit-Reviewer: jenkins-bot <>
_______________________________________________
MediaWiki-commits mailing list
MediaWiki-commits@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/mediawiki-commits
