File : scrub.sql - Ohloh Code Search

Project: MantisBT

Code Location: git://github.com/mantisbt/mantisbt-tools.gitmaster

Download File

scrub.sql

-- A SQL script that is used to remove sensitive data from a public database
-- For example, the database on http://www.mantisbt.org/bugs/
-- The assumption here is that the sensitive data includes:
-- Email addresses, passwords, cookies, and real names.

DELETE FROM mantis_email_table;
UPDATE mantis_user_table SET password = '63a9f0ea7bb98050796b649e85481845';
UPDATE mantis_user_table SET email = CONCAT(username, '@localhost');
UPDATE mantis_user_table SET cookie_string = CONCAT('cookie_', id);
UPDATE mantis_user_table SET realname = '';