[Summary view] [Print] [Text view]

   1  --
   2  -- Optional tables for parserTests recording mode
   3  -- With --record option, success data will be saved to these tables,
   4  -- and comparisons of what's changed from the previous run will be
   5  -- displayed at the end of each run.
   6  --
   7  -- These tables currently require MySQL 5 (or maybe 4.1?) for subselects.
   8  --
   9  
  10  drop table if exists /*$wgDBprefix*/testitem;
  11  drop table if exists /*$wgDBprefix*/testrun;
  12  
  13  create table /*$wgDBprefix*/testrun (
  14    tr_id int not null auto_increment,
  15  
  16    tr_date char(14) binary,
  17    tr_mw_version blob,
  18    tr_php_version blob,
  19    tr_db_version blob,
  20    tr_uname blob,
  21  
  22    primary key (tr_id)
  23  ) engine=InnoDB;
  24  
  25  create table /*$wgDBprefix*/testitem (
  26    ti_run int not null,
  27    ti_name varchar(255),
  28    ti_success bool,
  29  
  30    unique key (ti_run, ti_name),
  31    key (ti_run, ti_success),
  32  
  33    foreign key (ti_run) references /*$wgDBprefix*/testrun(tr_id)
  34      on delete cascade
  35  ) engine=InnoDB;