upgrade/0.9.3/85_bounces_proxy.sql

   1 create table emails_bounces_re (
   2     id   int not null auto_increment,
   3     pos  smallint unsigned not null default 0,
   4     lvl  tinyint unsigned not null default 0,
   5     re   text not null,
   6     text varchar(255) not null,
   7     primary key (id),
   8     index (lvl),
   9     index (pos)
  10 );
  11
  12 insert into admin_a values(1,'Regexps Bounces', 'admin/emails_bounces_re.php', 30);
  13
  14 alter table emails add column last date not null after panne;
  15
  16 create table emails_broken (
  17     uid int not null,
  18     email varchar(255) not null,
  19     primary key (uid,email)
  20 );