Android Set all Ringtones for Contacts

#as root
cd /data/data/com.android.providers.contacts/databases/

#list all contacts with custom ringtones
sqlite3 contacts2.db "SELECT custom_ringtone FROM raw_contacts"
sqlite3 contacts2.db "SELECT custom_ringtone FROM raw_contacts"|sort -u

#set all contacts to ringtone
update raw_contacts set custom_ringtone='content://media/external/audio/media/1000021093?title=ring&canonical=1';