full_to_public.sql

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;