upgrade/0.9.2/99_virtual.sql

   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