Implements a url-shortener (Closes #1042).

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

diff --git a/upgrade/0.9.5/30_entreprises.sql b/upgrade/0.9.5/30_entreprises.sql
index ceb670d..09f4540 100644 (file)
--- 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