Yuvipanda has uploaded a new change for review.
https://gerrit.wikimedia.org/r/80783
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, 9 insertions(+), 0 deletions(-)
git pull ssh://gerrit.wikimedia.org:29418/mediawiki/extensions/UploadWizard
refs/changes/83/80783/1
diff --git a/UploadWizard.sql b/UploadWizard.sql
index cb1f13f..883a3ad 100644
--- a/UploadWizard.sql
+++ b/UploadWizard.sql
@@ -13,3 +13,4 @@
) /*$wgDBTableOptions*/;
CREATE UNIQUE INDEX /*i*/uw_campaigns_name ON /*_*/uw_campaigns
(campaign_name);
+CREATE INDEX /*i*/uw_campaigns_enabled ON /*_*/uw_campaigns (campaign_enabled);
diff --git a/UploadWizardHooks.php b/UploadWizardHooks.php
index 83e4b65..7f567b4 100644
--- a/UploadWizardHooks.php
+++ b/UploadWizardHooks.php
@@ -516,6 +516,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..c3984f7
--- /dev/null
+++ b/sql/UW_IndexCampaignsEnabled.sql
@@ -0,0 +1 @@
+CREATE INDEX /*i*/uw_campaigns_enabled ON /*_*/uw_campaigns
(campaigns_enabled);
--
To view, visit https://gerrit.wikimedia.org/r/80783
To unsubscribe, visit https://gerrit.wikimedia.org/r/settings
Gerrit-MessageType: newchange
Gerrit-Change-Id: Ie34bb6f27f758b9b340232abe93907c6f63e47c2
Gerrit-PatchSet: 1
Gerrit-Project: mediawiki/extensions/UploadWizard
Gerrit-Branch: master
Gerrit-Owner: Yuvipanda <[email protected]>
_______________________________________________
MediaWiki-commits mailing list
[email protected]
https://lists.wikimedia.org/mailman/listinfo/mediawiki-commits
