Awight has uploaded a new change for review. https://gerrit.wikimedia.org/r/171977
Change subject: add indexes for is_XXXX_donor -BUNT columns ...................................................................... add indexes for is_XXXX_donor -BUNT columns Change-Id: I349e0fdcc669ab4a63fa911b4e25a32a215c1ce7 --- M silverpop_export/update_table.sql 1 file changed, 9 insertions(+), 0 deletions(-) git pull ssh://gerrit.wikimedia.org:29418/wikimedia/fundraising/tools refs/changes/77/171977/1 diff --git a/silverpop_export/update_table.sql b/silverpop_export/update_table.sql index 7709b5a..1a06133 100755 --- a/silverpop_export/update_table.sql +++ b/silverpop_export/update_table.sql @@ -55,6 +55,15 @@ INDEX spex_country (country), INDEX spex_postal (postal_code), INDEX spex_opted_out (opted_out) + INDEX spex_is_2006_donor (is_2006_donor), + INDEX spex_is_2007_donor (is_2007_donor), + INDEX spex_is_2008_donor (is_2008_donor), + INDEX spex_is_2009_donor (is_2009_donor), + INDEX spex_is_2010_donor (is_2010_donor), + INDEX spex_is_2011_donor (is_2011_donor), + INDEX spex_is_2012_donor (is_2012_donor), + INDEX spex_is_2013_donor (is_2013_donor), + INDEX spex_is_2014_donor (is_2014_donor), ) COLLATE 'utf8_unicode_ci'; -- Populate, or append to, the storage table all contacts that -- To view, visit https://gerrit.wikimedia.org/r/171977 To unsubscribe, visit https://gerrit.wikimedia.org/r/settings Gerrit-MessageType: newchange Gerrit-Change-Id: I349e0fdcc669ab4a63fa911b4e25a32a215c1ce7 Gerrit-PatchSet: 1 Gerrit-Project: wikimedia/fundraising/tools Gerrit-Branch: master Gerrit-Owner: Awight <[email protected]> _______________________________________________ MediaWiki-commits mailing list [email protected] https://lists.wikimedia.org/mailman/listinfo/mediawiki-commits
