Commit | Line | Data |
---|---|---|
0337d704 | 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; |