0337d704 |
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; |