New data

[nicolar]

Hi,
I'm going to import data from an ETL process to test EspoCRM but I can't figure out how I can generate new IDs, for example, account emails are connected by entity_email_address, I need a way to generate unique IDs for that table, anyone have similar situation?
It can be an hint to use 36 chars UUID instead of 24 chars strings

[nicolar]

An interesting approach can be generate them starting from the UUID taking the first part of the UUID that is sequential and then replace hyphens this way in MySQL:

SELECT LEFT(REPLACE(UUID(), '-', ''), 16);