jenkins-bot has submitted this change and it was merged.
Change subject: Add an index to the campaign_enabled field
......................................................................
Add an index to the campaign_enabled field
Change-Id: Ie34bb6f27f758b9b340232abe93907c6f63e47c2
---
M UploadWizard.sql
M UploadWizardHooks.php
A sql/UW_IndexCampaignsEnabled.sql
3 files changed, 11 insertions(+), 0 deletions(-)
Approvals:
Brion VIBBER: Looks good to me, approved
jenkins-bot: Verified
diff --git a/UploadWizard.sql b/UploadWizard.sql
index cb1f13f..c1c2133 100644
--- a/UploadWizard.sql
+++ b/UploadWizard.sql
@@ -13,3 +13,5 @@
) /*$wgDBTableOptions*/;
CREATE UNIQUE INDEX /*i*/uw_campaigns_name ON /*_*/uw_campaigns
(campaign_name);
+-- Since we sort on campaign_id for pagination
+CREATE INDEX /*i*/uw_campaigns_enabled ON /*_*/uw_campaigns (campaign_enabled,
campaign_id);
diff --git a/UploadWizardHooks.php b/UploadWizardHooks.php
index 6f72cfa..d2a3608 100644
--- a/UploadWizardHooks.php
+++ b/UploadWizardHooks.php
@@ -518,6 +518,13 @@
dirname( __FILE__ ) . '/sql/UW_IndexCampaignsName.sql',
true
) );
+ $updater->addExtensionUpdate( array(
+ 'addIndex',
+ 'uw_campaigns',
+ 'uw_campaigns_enabled',
+ dirname( __FILE__ ) .
'/sql/UW_IndexCampaignsEnabled.sql',
+ true
+ ) );
return true;
}
diff --git a/sql/UW_IndexCampaignsEnabled.sql b/sql/UW_IndexCampaignsEnabled.sql
new file mode 100644
index 0000000..6bd7a25
--- /dev/null
+++ b/sql/UW_IndexCampaignsEnabled.sql
@@ -0,0 +1,2 @@
+-- Since we sort on campaign_id for pagination
+CREATE INDEX /*i*/uw_campaigns_enabled ON /*_*/uw_campaigns (campaign_enabled,
campaign_id);
--
To view, visit https://gerrit.wikimedia.org/r/80783
To unsubscribe, visit https://gerrit.wikimedia.org/r/settings
Gerrit-MessageType: merged
Gerrit-Change-Id: Ie34bb6f27f758b9b340232abe93907c6f63e47c2
Gerrit-PatchSet: 9
Gerrit-Project: mediawiki/extensions/UploadWizard
Gerrit-Branch: master
Gerrit-Owner: Yuvipanda <[email protected]>
Gerrit-Reviewer: Brian Wolff <[email protected]>
Gerrit-Reviewer: Brion VIBBER <[email protected]>
Gerrit-Reviewer: MarkTraceur <[email protected]>
Gerrit-Reviewer: jenkins-bot
_______________________________________________
MediaWiki-commits mailing list
[email protected]
https://lists.wikimedia.org/mailman/listinfo/mediawiki-commits
