| 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 | |