From 865d8774fae4917eb6e94dce6fe7fc2025646060 Mon Sep 17 00:00:00 2001 From: =?utf8?q?Jo=C3=A3o=20Pedro=20Athayde=20Marcondes=20de=20Andr=C3=A9?= =?utf8?q?=20=28JP=29?= Date: Sat, 30 Oct 2010 21:50:03 +0200 Subject: [PATCH] Change position of email_virtual_domains following organization from previous commit --- upgrade/1.1.0/01_new_mail.sql | 9 +++++---- 1 file changed, 5 insertions(+), 4 deletions(-) diff --git a/upgrade/1.1.0/01_new_mail.sql b/upgrade/1.1.0/01_new_mail.sql index c363e2a..a9a0d16 100644 --- a/upgrade/1.1.0/01_new_mail.sql +++ b/upgrade/1.1.0/01_new_mail.sql @@ -3,6 +3,7 @@ DROP TABLE IF EXISTS email_nonaccount_emails; DROP TABLE IF EXISTS homonyms_list; DROP TABLE IF EXISTS email_redirect; DROP TABLE IF EXISTS email_virtual; +DROP TABLE IF EXISTS email_virtual_domains; CREATE TABLE email_account_emails ( email VARCHAR(255) NOT NULL PRIMARY KEY, @@ -58,6 +59,10 @@ CREATE TABLE email_virtual ( KEY (alias) ) ENGINE=InnoDB, CHARSET=utf8 ; +CREATE TABLE email_virtual_domains ( + domain VARCHAR(255) NOT NULL PRIMARY KEY +) ENGINE=InnoDB, CHARSET=utf8 ; + INSERT INTO email_account_emails (uid,email,type,flags,expire) SELECT a.uid,CONCAT(a.alias,'@polytechnique.org'),a.type,a.flags,a.expire @@ -232,10 +237,6 @@ Note: There are some adresses on virtual that have no match on the virtual_redir in this situation are dropped. */ -CREATE TABLE email_virtual_domains ( - domain VARCHAR(255) NOT NULL PRIMARY KEY -) ENGINE=InnoDB, CHARSET=utf8 ; - INSERT INTO email_virtual_domains (domain) VALUES ("polytechnique.org"), ("m4x.org"), -- 2.1.4