death_by_sql.sql

INSERT IGNORE INTO phpbb.phpbb_profile_fields_data(user_id) SELECT user_id FROM phpbb.phpbb_users;

UPDATE phpbb.phpbb_profile_fields_data a
  LEFT OUTER JOIN mt_ars.mt_author_meta ars_opt_in ON (a.user_id = ars_opt_in.author_meta_author_id + 999 AND ars_opt_in.author_meta_type = 'field.ars_opt_in')
  LEFT OUTER JOIN mt_ars.mt_author_meta partner_opt_in ON (a.user_id = partner_opt_in.author_meta_author_id + 999 AND partner_opt_in.author_meta_type = 'field.partner_opt_in')
  LEFT OUTER JOIN mt_ars.mt_author_meta beerology_url ON (a.user_id = beerology_url.author_meta_author_id + 999 AND beerology_url.author_meta_type = 'field.beerology_url')
  LEFT OUTER JOIN mt_ars.mt_author_meta bio ON (a.user_id = bio.author_meta_author_id + 999 AND bio.author_meta_type = 'field.bio')
  LEFT OUTER JOIN mt_ars.mt_author_meta display_email ON (a.user_id = display_email.author_meta_author_id + 999 AND display_email.author_meta_type = 'field.display_email')
  LEFT OUTER JOIN mt_ars.mt_author_meta gender ON (a.user_id = gender.author_meta_author_id + 999 AND gender.author_meta_type = 'field.gender')
  LEFT OUTER JOIN mt_ars.mt_author_meta join_reason ON (a.user_id = join_reason.author_meta_author_id + 999 AND join_reason.author_meta_type = 'field.join_reason')
  LEFT OUTER JOIN mt_ars.mt_author_meta location ON (a.user_id = location.author_meta_author_id + 999 AND location.author_meta_type = 'field.location')
  LEFT OUTER JOIN mt_ars.mt_author_meta nick_meaning ON (a.user_id = nick_meaning.author_meta_author_id + 999 AND nick_meaning.author_meta_type = 'field.nick_meaning')
  LEFT OUTER JOIN mt_ars.mt_author_meta os_choice ON (a.user_id = os_choice.author_meta_author_id + 999 AND os_choice.author_meta_type = 'field.os_choice')
  LEFT OUTER JOIN mt_ars.mt_author_meta spreedly_expires ON (a.user_id = spreedly_expires.author_meta_author_id + 999 AND spreedly_expires.author_meta_type = 'field.spreedly_expires')
  LEFT OUTER JOIN mt_ars.mt_author_meta spreedly_token ON (a.user_id = spreedly_token.author_meta_author_id + 999 AND spreedly_token.author_meta_type = 'field.spreedly_token')
  LEFT OUTER JOIN mt_ars.mt_author_meta title ON (a.user_id = title.author_meta_author_id + 999 AND title.author_meta_type = 'field.title')
  LEFT OUTER JOIN mt_ars.mt_author_meta groupee_id ON (a.user_id = groupee_id.author_meta_author_id + 999 AND groupee_id.author_meta_type = 'groupee_id')
SET
  a.pf_ars_opt_in = ars_opt_in.author_meta_vchar_idx,
  a.pf_partner_opt_in = partner_opt_in.author_meta_vchar_idx,
  a.pf_beerology_url = beerology_url.author_meta_vchar_idx,
  a.pf_bio = bio.author_meta_vclob,
  a.pf_display_email = display_email.author_meta_vchar_idx,
  a.pf_gender = gender.author_meta_vchar_idx,
  a.pf_join_reason = join_reason.author_meta_vclob,
  a.pf_location = location.author_meta_vchar_idx,
  a.pf_nick_meaning = nick_meaning.author_meta_vclob,
  a.pf_os_choice = os_choice.author_meta_vclob,
  a.pf_spreedly_expires = UNIX_TIMESTAMP(spreedly_expires.author_meta_vdatetime_idx),
  a.pf_spreedly_token = spreedly_token.author_meta_vchar_idx,
  a.pf_title = title.author_meta_vclob,
  a.pf_groupee_id = groupee_id.author_meta_vchar_idx
;