Merge "Move SQL schema and schema changes to new sql/ top-level directory"

1 files changed, 33 insertions, 0 deletions

diff --git a/sql/mysql/patch-testrun.sql b/sql/mysql/patch-testrun.sql
new file mode 100644
index 000000000000..a2bb05ae5db8
--- /dev/null
+++ b/sql/mysql/patch-testrun.sql
@@ -0,0 +1,33 @@
+--
+-- Optional tables for parserTests recording mode
+-- With --record option, success data will be saved to these tables,
+-- and comparisons of what's changed from the previous run will be
+-- displayed at the end of each run.
+--
+
+drop table if exists /*$wgDBprefix*/testitem;
+drop table if exists /*$wgDBprefix*/testrun;
+
+create table /*$wgDBprefix*/testrun (
+  tr_id int not null auto_increment,
+
+  tr_date char(14) binary,
+  tr_mw_version blob,
+  tr_php_version blob,
+  tr_db_version blob,
+  tr_uname blob,
+
+  primary key (tr_id)
+) engine=InnoDB;
+
+create table /*$wgDBprefix*/testitem (
+  ti_run int not null,
+  ti_name varchar(255),
+  ti_success bool,
+
+  unique key (ti_run, ti_name),
+  key (ti_run, ti_success),
+
+  foreign key (ti_run) references /*$wgDBprefix*/testrun(tr_id)
+    on delete cascade
+) engine=InnoDB;