Adding Leads through MySQL

[cornella]

I imported my Leads records directly into the Leads table through phpmyadmin. Then I added/connected emails into the Email_Addresses table. But my emails aren't connected yet because of the email bean.

Is there an SQL query that would add records to the email_email_addr_bean_rel table? Or is there another way to map or bring those 2 records together?

[kuske]

You only have to create one record for each lead-email relation in
email_addr_bean_rel:

id = any new uuid()
email_address_id = id of email_addresses record
bean_id = id of Leads record
bean_module = 'Leads'
primary_address = 1 if email is primary address, 0 else
reply_to_address = 1 if email replyto address, 0 else
date_created = now()
date_modified = now()
deleted = 0