Adapts homonyms issues to new mail chain.

[platal.git] / upgrade / 1.1.0 / 02_new_mail_insertion.sql

diff --git a/upgrade/1.1.0/02_new_mail_insertion.sql b/upgrade/1.1.0/02_new_mail_insertion.sql
index fa60db8..2229789 100644 (file)
--- a/upgrade/1.1.0/02_new_mail_insertion.sql
+++ b/upgrade/1.1.0/02_new_mail_insertion.sql
@@ -56,8 +56,8 @@ INSERT INTO  email_source_account (uid, domain, email, type)
       WHERE  v.type = 'user' AND v.alias LIKE '%@melix.net' AND a.uid IS NOT NULL;
 
 -- 3/ Feeds email_source_other
-INSERT INTO  email_source_other (hrmid, email, domain, type)
-     SELECT  CONCAT(CONCAT('h.', alias), '.polytechnique.org'), alias, @p_domain_id, 'homonym'
+INSERT INTO  email_source_other (hrmid, email, domain, type, expire)
+     SELECT  CONCAT(CONCAT('h.', alias), '.polytechnique.org'), alias, @p_domain_id, 'homonym', IF(expire IS NULL, '0000-00-00', expire)
        FROM  aliases
       WHERE  type = 'homonyme'
    GROUP BY  alias;