Skip to content

HTTPS clone URL

Subversion checkout URL

You can clone with
or
.
Download ZIP
Fetching contributors…

Cannot retrieve contributors at this time

38 lines (26 sloc) 1.035 kB
-- Does a quick anonymization of a SUMO database. Note that this does
-- not necessarily clear out all confidential information and should
-- not be considered approval to distribute this SUMO database.
-- Talk to jsocol if you have questions.
UPDATE auth_user SET
email = CONCAT('user',id,'@example.com'),
password = 'sha256$f538347e82$5098e89186fd307d4bb6fe29ac476e72cf96175617fa933a9bd6b3d89a8b0946'; -- 'testpass'
SET SESSION FOREIGN_KEY_CHECKS = 0;
TRUNCATE tidings_watchfilter;
TRUNCATE tidings_watch;
TRUNCATE django_session;
TRUNCATE messages_inboxmessage;
TRUNCATE messages_outboxmessage_to;
TRUNCATE messages_outboxmessage;
SET SESSION FOREIGN_KEY_CHECKS = 1;
UPDATE django_site SET
domain = 'support-local.allizom.org',
name = 'support-local.allizom.org';
-- We don't pull images from production, clearing out the fields
-- let's us see the default placeholders.
UPDATE products_topic SET
image = NULL;
UPDATE products_product SET
image = NULL;
UPDATE products_topic SET
image = NULL;
Jump to Line
Something went wrong with that request. Please try again.