#  --- user_linkedin_auto_certification ---
# id
# created_at
# modified_at
# name
# authority
# number
# start_date
# end_date
# user_id

### TABLE EMPTY!!


#  --- user_linkedin_auto_course ---
# id
# created_at
# modified_at
# name
# number
# user_id

INSERT INTO user_linkedin_auto_course (created_at, modified_at, name, number, user_id)
    SELECT created_at, modified_at, name, number, user.id
    FROM linkedin_auto_course JOIN nerd ON linkedin_auto_course.nerd_id=nerd.id JOIN user ON nerd.user = user.id;


#  --- user_linkedin_auto_education---
# id
# activities
# degree
# focus
# began_at
# schoolName
# ended_at
# user

INSERT INTO user_linkedin_auto_education (activities, degree, focus, began_at, schoolName, ended_at, user)
    SELECT activities, degree, focus, began_at, schoolName, ended_at, user.id
    FROM linkedin_auto_education JOIN nerd ON linkedin_auto_education.nerd=nerd.id JOIN user ON nerd.user = user.id;


#  --- user_linkedin_auto_experience---
# id
# companyName
# description
# began_at
# location
# title
# ended_at
# linkedin_company_id
# user

INSERT INTO user_linkedin_auto_experience (companyName, description, began_at, location, title, ended_at, linkedin_company_id, user)
    SELECT companyName, description, began_at, location, title, ended_at, linkedin_company_id, user.id
    FROM linkedin_auto_experience JOIN nerd ON linkedin_auto_experience.nerd=nerd.id JOIN user ON nerd.user = user.id;


#  --- user_linkedin_auto_language ---
# user_id
# language_id

INSERT IGNORE INTO user_linkedin_auto_languages (user_id, language_id)
    SELECT user.id, language_id
    FROM linkedin_auto_languages JOIN nerd ON linkedin_auto_languages.nerd_id=nerd.id JOIN user ON nerd.user = user.id;


#  --- user_linkedin_auto_location ---
# id
# country_code
# location_name
# user_id

### Location already stored exclusively in user_linkedin table

#  --- user_linkedin_auto_publication ---
# id
# created_at
# modified_at
# title
# publisher
# authors
# date
# url
# summary
# nerd_id

INSERT INTO user_linkedin_auto_publication (created_at, modified_at, title, publisher, authors, date, url, summary, user_id)
    SELECT created_at, modified_at, title, publisher, authors, date, url, summary, user.id
    FROM linkedin_auto_publication JOIN nerd ON linkedin_auto_publication.nerd_id=nerd.id JOIN user ON nerd.user = user.id;


#  --- user_linkedin_skill ---
# id
# created_at
# modified_at
# name
# user_id

INSERT INTO user_linkedin_auto_skill (created_at, modified_at, name, user_id)
    SELECT created_at, modified_at, name, user.id
    FROM linkedin_auto_skill JOIN nerd ON linkedin_auto_skill.nerd_id=nerd.id JOIN user ON nerd.user = user.id;


#  --- user_linkedin_auto_volunteer ---
# id
# created_at
# modified_at
# role
# organization
# cause
# user_id

INSERT INTO user_linkedin_auto_volunteer (created_at, modified_at, role, organization, cause, user_id)
    SELECT created_at, modified_at, role, organization, cause, user.id
    FROM linkedin_auto_volunteer JOIN nerd ON linkedin_auto_volunteer.nerd_id=nerd.id JOIN user ON nerd.user = user.id;

# ------------------------- DONE UP TO THIS POINT -------------------------------------------

#  --- user_linkedin_auto_connection ---
# user_id
# connection_id

### Connection already stored exclusively in user_linkedin table