Adamw has uploaded a new change for review.
https://gerrit.wikimedia.org/r/133181
Change subject: opt_out preferences apply to email addresses separately
......................................................................
opt_out preferences apply to email addresses separately
Change-Id: Ied46cb0605683cf57cee450f07417e05f82b0688
---
M silverpop_export/update_table.sql
1 file changed, 0 insertions(+), 5 deletions(-)
git pull ssh://gerrit.wikimedia.org:29418/wikimedia/fundraising/tools
refs/changes/81/133181/1
diff --git a/silverpop_export/update_table.sql
b/silverpop_export/update_table.sql
index bb63f04..2d22fa4 100755
--- a/silverpop_export/update_table.sql
+++ b/silverpop_export/update_table.sql
@@ -173,11 +173,6 @@
silverpop_export.contact_id = silverpop_export_dedupe_contact.contact_id
AND
silverpop_export.id != silverpop_export_dedupe_contact.maxid;
-UPDATE silverpop_export ex, silverpop_export_dedupe_contact dc
- SET ex.opted_out = 1
- WHERE
- dc.opted_out = 1 AND dc.maxid = ex.id;
-
-- Create an aggregate table from a full contribution table scan
CREATE TABLE silverpop_export_stat (
id INT PRIMARY KEY AUTO_INCREMENT,
--
To view, visit https://gerrit.wikimedia.org/r/133181
To unsubscribe, visit https://gerrit.wikimedia.org/r/settings
Gerrit-MessageType: newchange
Gerrit-Change-Id: Ied46cb0605683cf57cee450f07417e05f82b0688
Gerrit-PatchSet: 1
Gerrit-Project: wikimedia/fundraising/tools
Gerrit-Branch: master
Gerrit-Owner: Adamw <awi...@wikimedia.org>
_______________________________________________
MediaWiki-commits mailing list
MediaWiki-commits@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/mediawiki-commits
