From 03f5a717dccb6e614d9a73a63131af3ec9632203 Mon Sep 17 00:00:00 2001 From: x2000habouzit Date: Sun, 7 Nov 2004 20:28:27 +0000 Subject: [PATCH] comments + @melix.org -> @melix.net --- scripts/migration/0.9.2/99_virtual.sql | 21 ++++++++++++++++++++- 1 file changed, 20 insertions(+), 1 deletion(-) diff --git a/scripts/migration/0.9.2/99_virtual.sql b/scripts/migration/0.9.2/99_virtual.sql index 3b18d4d..c8a63fc 100644 --- a/scripts/migration/0.9.2/99_virtual.sql +++ b/scripts/migration/0.9.2/99_virtual.sql @@ -1,9 +1,16 @@ +-------------------------------------------------------------------------------- +-- alters +-------------------------------------------------------------------------------- alter table virtual change column vid vid int not null auto_increment; alter table virtual change column alias alias varchar(255) not null; +alter table virtual change column type type enum('user','list','dom') not null default 'user'; alter table virtual add unique (alias) ; alter table virtual_redirect change column vid vid int not null auto_increment; alter table virtual_redirect add index (redirect); +-------------------------------------------------------------------------------- +-- copies melix.net +-------------------------------------------------------------------------------- insert into virtual select null,domain,'user' from groupex.aliases @@ -14,4 +21,16 @@ insert into virtual_redirect from virtual AS v inner join groupex.aliases as d ON(v.alias=d.domain); -delete from groupex.aliases where domain like '%@melix.net'; +delete from groupex.aliases where domain like '%@melix.net'; + +-------------------------------------------------------------------------------- +-- establish @melix.org -> @melix.net +-------------------------------------------------------------------------------- +insert into virtual (alias,type) VALUES('@melix.org','dom'); +insert into virtual_redirect + select vid,'@melix.net' + from virtual + where alias='@melix.org'; + +delete from groupex.aliases where domain = '@melix.org'; + -- 2.1.4