[platal.git] / upgrade / 0.9.5 / 30_entreprises.sql

ALTER TABLE entreprises
ADD pub ENUM('private', 'ax', 'public') DEFAULT 'private' NOT NULL,
ADD adr_pub ENUM('private', 'ax', 'public') DEFAULT 'private' NOT NULL,
ADD tel_pub ENUM('private', 'ax', 'public') DEFAULT 'private' NOT NULL;
UPDATE entreprises SET
pub = IF(FIND_IN_SET('entreprise_public', visibilite), 'public', IF(FIND_IN_SET('entreprise_ax', visibilite), 'ax', 'private')),
adr_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 entreprises DROP visibilite;
ALTER TABLE entreprises
ADD email VARCHAR(60) NOT NULL AFTER mobile,
ADD web VARCHAR(255) NOT NULL AFTER email,
ADD email_pub ENUM('private', 'ax', 'public') DEFAULT 'private' NOT NULL;
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')),
aab2ffdd SJ	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;