Create db tables to support the stress testing

[Russell Taylor]

Now done. The SQL for the creation of the tables is below

CREATE DATABASE MantidStressTests;

CREATE TABLE TestRuns
(test_id SERIAL,
 test_date DATETIME NOT NULL,
 test_name VARCHAR(30) NOT NULL,
 host_name VARCHAR(30) NOT NULL,
 environment ENUM('win32','win64','macOSX','redhat','fedora') NOT NULL,
 status ENUM('success','crashed','hung') NOT NULL,
 PRIMARY KEY (test_id),
 UNIQUE(test_date,test_name,host_name)
);

CREATE TABLE IterationTimings
(test_id BIGINT UNSIGNED NOT NULL,
 iteration SMALLINT UNSIGNED NOT NULL,
 time_taken FLOAT DEFAULT NULL,
 PRIMARY KEY (test_id, iteration),
 FOREIGN KEY (test_id) REFERENCES TestRuns (test_id)
   ON DELETE CASCADE
);

[Stuart Campbell]

This ticket has been transferred to github issue ​1684