sql-drupal-rinse.sql

-- Remove all email addresses.
UPDATE users SET mail=CONCAT('user', uid, '@example.com'), init=CONCAT('user', uid, '@example.com') WHERE uid != 0;

UPDATE emf_subscription SET mail=CONCAT('user', uid, '@example.com'), init=CONCAT('user', uid, '@example.com') WHERE uid != 0;


-- Clear production acquia network settings.
UPDATE variable SET value='' WHERE name LIKE 'acquia%';

-- Clear variables.
DELETE FROM cache WHERE cid = 'variables';

-- Clear webform email adresses.
UPDATE webform_emails set email = 'example@example.com'