X-Git-Url: http://git.polytechnique.org/?a=blobdiff_plain;f=upgrade%2F0.9.5%2F30_entreprises.sql;h=09f454037e81ac8d600338d138498f9e9cf33569;hb=5c11ce3d14becb0799434db3f1c6cc37eab3ca0f;hp=ceb670dd00250ca55309e430404fdf389934cbed;hpb=0337d704b62718d7c77106c0e4c4e26fb02beacf;p=platal.git

diff --git a/upgrade/0.9.5/30_entreprises.sql b/upgrade/0.9.5/30_entreprises.sql
index ceb670d..09f4540 100644
--- a/upgrade/0.9.5/30_entreprises.sql
+++ b/upgrade/0.9.5/30_entreprises.sql
@@ -3,8 +3,8 @@ 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')), 
+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