[platal.git] / upgrade / 0.9.5 / 20_adresses.sql

ALTER TABLE adresses
ADD pub ENUM('private', 'ax', 'public') DEFAULT 'private' NOT NULL,
ADD tel_pub ENUM('private', 'ax', 'public') DEFAULT 'private' NOT NULL;
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'));
ALTER TABLE adresses DROP visibilite;
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;