X-Git-Url: http://git.polytechnique.org/?a=blobdiff_plain;f=upgrade%2F1.1.0%2F02_new_mail_insertion.sql;h=a51987c7b7bde5c66d93419f30cbb949479a1f06;hb=2b13c66c646c46b57037bc6b1ff0adf84988b3fc;hp=8edc6f819a236c8680a0b96271f02ea8e06ba49c;hpb=eaf67a5fe21577b4995c7894d430de7c86db45f9;p=platal.git

diff --git a/upgrade/1.1.0/02_new_mail_insertion.sql b/upgrade/1.1.0/02_new_mail_insertion.sql
index 8edc6f8..a51987c 100644
--- a/upgrade/1.1.0/02_new_mail_insertion.sql
+++ b/upgrade/1.1.0/02_new_mail_insertion.sql
@@ -40,13 +40,35 @@ INSERT INTO  email_virtual_domains (name, aliasing)
        FROM  email_virtual_domains
       WHERE  name = 'x-consult.polytechnique.org';
 
+INSERT INTO  email_virtual_domains (name, aliasing)
+     VALUES  ('alumni.polytechnique.org', @p_domain_id), ('alumni.m4x.org', @p_domain_id),
+             ('master.polytechnique.org', 1), ('doc.polytechnique.org', 1);
+SET @master_domain_id = 0;
+SET @doc_domain_id = 0;
+SELECT  @master_domain_id := id
+  FROM  email_virtual_domains
+ WHERE  name = 'master.polytechnique.org';
+SELECT  @doc_domain_id := id
+  FROM  email_virtual_domains
+ WHERE  name = 'doc.polytechnique.org';
+UPDATE  email_virtual_domains
+   SET  aliasing = @master_domain_id
+ WHERE  name = 'master.polytechnique.org';
+UPDATE  email_virtual_domains
+   SET  aliasing = @doc_domain_id
+ WHERE  name = 'doc.polytechnique.org';
+INSERT INTO  email_virtual_domains (name, aliasing)
+     VALUES  ('alumni.polytechnique.org', @master_domain_id), ('alumni.m4x.org', @master_domain_id),
+             ('alumni.polytechnique.org', @doc_domain_id), ('alumni.m4x.org', @doc_domain_id),
+             ('master.m4x.org', @master_domain_id), ('doc.m4x.org', @doc_domain_id);
+
 -- 2/ Feeds email_source_account
 INSERT INTO  email_source_account (uid, domain, email, type, flags, expire)
      SELECT  uid, @p_domain_id, alias, IF(type = 'a_vie', 'forlife', 'alias'), REPLACE(flags, 'epouse', 'marital'), expire
        FROM  aliases
       WHERE  type = 'a_vie' OR type = 'alias';
 INSERT INTO  email_source_account (uid, domain, email, type)
-     SELECT  a.uid, @m_domain_id, SUBSTRING_INDEX(v.alias, '@', 1), 'alias'
+     SELECT  a.uid, @m_domain_id, SUBSTRING_INDEX(v.alias, '@', 1), 'alias_aux'
        FROM  virtual          AS v
   LEFT JOIN  virtual_redirect AS vr ON (v.vid = vr.vid)
   LEFT JOIN  accounts         AS a  ON (a.hruid = LEFT(vr.redirect, LOCATE('@', vr.redirect) - 1))
@@ -145,7 +167,7 @@ INSERT INTO  email_virtual (email, type, domain, redirect)
       WHERE  type = 'liste';
 
 INSERT INTO  email_virtual (email, redirect, domain, type)
-     SELECT  SUBSTRING_INDEX(v.alias, '@', 1), vr.redirect, @m_domain_id, 'user'
+     SELECT  SUBSTRING_INDEX(v.alias, '@', 1), vr.redirect, @m_domain_id, 'alias'
        FROM  virtual          AS v
   LEFT JOIN  virtual_redirect AS vr ON (v.vid = vr.vid)
   LEFT JOIN  accounts         AS a  ON (a.hruid = LEFT(vr.redirect, LOCATE('@', vr.redirect) - 1))
@@ -208,4 +230,12 @@ INSERT INTO  email_virtual (domain, email, redirect, type)
 -- Drop renamed list
 DELETE FROM email_virtual WHERE email LIKE 'tech-email%';
 
+-- Deletes erroneous domains
+DELETE FROM  email_virtual_domains
+      WHERE  name IN ('fanfarix.polytechnique.net', 'asd', 'x-russie', 'formation', 'groupetest', 'x-sursaut');
+
+-- Deletes unused domains
+DELETE FROM  email_virtual_domains
+      WHERE  name LIKE 'manageurs.%';
+
 -- vim:set syntax=mysql: