0337d704 |
1 | -------------------------------------------------------------------------------- |
2 | -- alters |
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); |
10 | |
11 | -------------------------------------------------------------------------------- |
12 | -- copies melix.net |
13 | -------------------------------------------------------------------------------- |
14 | insert into virtual |
15 | select null,domain,'user' |
16 | from groupex.aliases |
17 | where domain like '%@melix.net'; |
18 | |
19 | insert into virtual_redirect |
20 | select vid,CONCAT(email,'@m4x.org') |
21 | from virtual AS v |
22 | inner join groupex.aliases as d ON(v.alias=d.domain); |
23 | |
24 | delete from groupex.aliases where domain like '%@melix.net'; |
25 | |
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' |
32 | from virtual |
33 | where alias='@melix.org'; |
34 | |
35 | delete from groupex.aliases where domain = '@melix.org'; |
36 | |