2 ADD pub
ENUM('private', 'ax', 'public') DEFAULT 'private' NOT NULL,
3 ADD tel_pub
ENUM('private', 'ax', 'public') DEFAULT 'private' NOT NULL;
4 UPDATE adresses
SET pub
= IF(FIND_IN_SET('adr_public', visibilite
), 'public', IF(FIND_IN_SET('adr_ax', visibilite
), 'ax', 'private')), tel_pub
= IF(FIND_IN_SET('tel_public', visibilite
), 'public', IF(FIND_IN_SET('tel_ax', visibilite
),'ax', 'private'));
5 ALTER TABLE adresses
DROP visibilite
;