1 --------------------------------------------------------------------------------
3 --------------------------------------------------------------------------------
4 alter table virtual change
column vid vid
int not null auto_increment
;
5 alter table virtual change
column alias alias varchar(255) not null;
6 alter table virtual change
column type type enum('user','list','dom') not null default 'user';
7 alter table virtual
add unique (alias) ;
8 alter table virtual_redirect change
column vid vid
int not null auto_increment
;
9 alter table virtual_redirect
add index (redirect
);
11 --------------------------------------------------------------------------------
13 --------------------------------------------------------------------------------
15 select null,domain,'user'
17 where domain like '%@melix.net';
19 insert into virtual_redirect
20 select vid
,CONCAT(email
,'@m4x.org')
22 inner join groupex.aliases
as d
ON(v.
alias=d.
domain);
24 delete from groupex.aliases
where domain like '%@melix.net';
26 --------------------------------------------------------------------------------
27 -- establish @melix.org -> @melix.net
28 --------------------------------------------------------------------------------
29 insert into virtual (alias,type) VALUES('@melix.org','dom');
30 insert into virtual_redirect
31 select vid
,'@melix.net'
33 where alias='@melix.org';
35 delete from groupex.aliases
where domain = '@melix.org';