Jcrespo has uploaded a new change for review. https://gerrit.wikimedia.org/r/323809
Change subject: redactatron: Integrate centralauth redaction into cols.txt ...................................................................... redactatron: Integrate centralauth redaction into cols.txt Bug: T103011 Change-Id: I4eb399fc13c09454dbae1ac9aacd06b2cf960463 --- M scripts/cols.txt D scripts/redact_centralauth.sql 2 files changed, 13 insertions(+), 25 deletions(-) git pull ssh://gerrit.wikimedia.org:29418/operations/software/redactatron refs/changes/09/323809/1 diff --git a/scripts/cols.txt b/scripts/cols.txt index 856519e..0021c2f 100644 --- a/scripts/cols.txt +++ b/scripts/cols.txt @@ -367,6 +367,19 @@ global_block_whitelist,gbw_by_text,K global_block_whitelist,gbw_reason,K global_block_whitelist,gbw_expiry,K +globaluser,gu_id,K +globaluser,gu_name,K +globaluser,gu_enabled,K +globaluser,gu_enabled_method,K +globaluser,gu_home_db,K +globaluser,gu_email,F +globaluser,gu_email_authenticated,F +globaluser,gu_salt,F +globaluser,gu_password,F +globaluser,gu_password_reset_key,F +globaluser,gu_password_reset_expiration,F +globaluser,gu_auth_token,F +globaluser,gu_cas_token,F hashs,hs_nstitle,K hashs,hs_timestamp,K hashs,hs_old_id,K diff --git a/scripts/redact_centralauth.sql b/scripts/redact_centralauth.sql deleted file mode 100644 index ee3acd4..0000000 --- a/scripts/redact_centralauth.sql +++ /dev/null @@ -1,25 +0,0 @@ -CREATE TRIGGER centralauth.globaluser_insert -BEFORE INSERT ON centralauth.globaluser -FOR EACH ROW SET -NEW.gu_email = '', -NEW.gu_email_authenticated = '', -NEW.gu_salt = '', -NEW.gu_password = '', -NEW.gu_password_reset_key = '', -NEW.gu_password_reset_expiration = '', -NEW.gu_auth_token = '', -NEW.gu_cas_token = 1; - -CREATE TRIGGER centralauth.globaluser_update -BEFORE UPDATE ON centralauth.globaluser -FOR EACH ROW SET -NEW.gu_email = '', -NEW.gu_email_authenticated = '', -NEW.gu_salt = '', -NEW.gu_password = '', -NEW.gu_password_reset_key = '', -NEW.gu_password_reset_expiration = '', -NEW.gu_auth_token = '', -NEW.gu_cas_token = 1; - --- then UPDATE all records the first time -- To view, visit https://gerrit.wikimedia.org/r/323809 To unsubscribe, visit https://gerrit.wikimedia.org/r/settings Gerrit-MessageType: newchange Gerrit-Change-Id: I4eb399fc13c09454dbae1ac9aacd06b2cf960463 Gerrit-PatchSet: 1 Gerrit-Project: operations/software/redactatron Gerrit-Branch: master Gerrit-Owner: Jcrespo <[email protected]> _______________________________________________ MediaWiki-commits mailing list [email protected] https://lists.wikimedia.org/mailman/listinfo/mediawiki-commits
