I need to save the phones and then validate it by SMS and serve as a method of recovering your account.
According to my approach, I decided to use 3 fields in MySQL
phone BIGINT(20) // Guardar el # como tal code_phone VARCHAR(8) // Guardar el código a comprobar validated_phone TINYINT(3) // Si es 1 esta validado
But my question is about the country code. It will be that I insert an additional field, or instead of using
BIGINT(20) step everything to a
VARCHAR(n) that is more recommendable in your experience.