drupal 6x - moving back from image cck to userpic

If you ever used image cck for user pictures and need to move back to the default built-in user pictures functionality, use this to migrate your data

update users u, content_type_profile c, node n, files f
set u.picture = f.filepath
where f.fid=c.field_profpic_fid
and c.nid = n.nid
and n.uid = u.uid