Commit | Line | Data |
---|---|---|
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 | |
aab2ffdd SJ |
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')), | |
0337d704 | 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; |