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