A few fixes on upgrade scripts.

[platal.git] / upgrade / 1.0.1 / 08_profile_foreign_keys.sql

diff --git a/upgrade/1.0.1/08_profile_foreign_keys.sql b/upgrade/1.0.1/08_profile_foreign_keys.sql
index 5b2cd06..b44ffc2 100644 (file)
--- a/upgrade/1.0.1/08_profile_foreign_keys.sql
+++ b/upgrade/1.0.1/08_profile_foreign_keys.sql
@@ -29,6 +29,7 @@ UPDATE profile_education SET fieldid = NULL WHERE fieldid = 0;
 UPDATE profile_education_enum SET country = NULL WHERE country = '';
 UPDATE profile_job SET jobid = NULL WHERE jobid = 0;
 UPDATE profile_job_enum SET holdingid = NULL WHERE holdingid = 0;
+UPDATE profiles SET section = NULL WHERE section = 0;
 
 -- Adds missing data in foreign tables.
 INSERT INTO  geoloc_countries (iso_3166_1_a2, iso_3166_1_a3, iso_3166_1_num, worldRegion, country,