upgrade/0.9.5/30_entreprises.sql

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