upgrade/0.9.5/20_adresses.sql

   1 ALTER TABLE adresses
   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;