| 1 | ALTER TABLE entreprises |
| 2 | ADD pub ENUM('private', 'ax', 'public') DEFAULT 'private' NOT NULL, |
| 3 | ADD adr_pub ENUM('private', 'ax', 'public') DEFAULT 'private' NOT NULL, |
| 4 | ADD tel_pub ENUM('private', 'ax', 'public') DEFAULT 'private' NOT NULL; |
| 5 | UPDATE entreprises SET |
| 6 | pub = IF(FIND_IN_SET('entreprise_public', visibilite), 'public', IF(FIND_IN_SET('entreprise_ax', visibilite), 'ax', 'private')), |
| 7 | adr_pub = IF(FIND_IN_SET('adr_public', visibilite), 'public', IF(FIND_IN_SET('adr_ax', visibilite), 'ax', 'private')), |
| 8 | tel_pub = IF(FIND_IN_SET('tel_public', visibilite), 'public', IF(FIND_IN_SET('tel_ax', visibilite),'ax', 'private')); |
| 9 | ALTER TABLE entreprises DROP visibilite; |
| 10 | ALTER TABLE entreprises |
| 11 | ADD email VARCHAR(60) NOT NULL AFTER mobile, |
| 12 | ADD web VARCHAR(255) NOT NULL AFTER email, |
| 13 | ADD email_pub ENUM('private', 'ax', 'public') DEFAULT 'private' NOT NULL; |