Skip to content

Instantly share code, notes, and snippets.

@pavelk2
Last active April 4, 2016 12:16
Show Gist options
  • Save pavelk2/f666de9b3659fb7e6f25 to your computer and use it in GitHub Desktop.
Save pavelk2/f666de9b3659fb7e6f25 to your computer and use it in GitHub Desktop.
drop table socialaccount_socialaccount;
drop table socialaccount_socialapp;
drop table socialaccount_socialapp_sites;
drop table socialaccount_socialtoken;
drop table account_emailaddress;
drop table account_emailconfirmation;
drop table auth_token;
drop table django_admin_log;
drop table corsheaders_corsmodel;
update auth_user
set
username = CONCAT("hidden",id),
email = CONCAT("hidden",id),
password = CONCAT("password",id),
last_name= CONCAT("hidden",id)
update co_accounts_folder set email = md5(email)
update co_accounts_profile set extra = "hidden" where extra is not null
update co_accounts_profile set avatar_url = md5(avatar_url)
update co_boards_boardcode set code = MD5(code)
update co_boards_imageversion set image = md5(image), thumbnail = md5(thumbnail)
update co_discussions_attachment set content = md5(content)
update co_history_eventvalue set value=CONCAT("hidden",id)
where
field in ("user","email") and
value like "%@%"
update co_history_eventvalue set value = md5(value)
update co_boards_posturl set url = md5(url)
update co_integrations_integration set service_key = md5(service_key)
update django_session set session_key = md5(session_key), session_data = "hidden"
drop table easy_thumbnails_thumbnail;
drop table easy_thumbnails_thumbnaildimensions;
drop table easy_thumbnails_source;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment