-- Convert schema 'upgrades/Tapper-Schema-TestrunDB-2.010032-SQLite.sql' to 'upgrades/Tapper-Schema-TestrunDB-2.010036-SQLite.sql':;
BEGIN;
CREATE TABLE host_feature (
id INTEGER PRIMARY KEY NOT NULL,
host_id INT NOT NULL,
entry VARCHAR(255) NOT NULL,
value VARCHAR(255) NOT NULL,
created_at TIMESTAMP DEFAULT 'CURRENT_TIMESTAMP',
updated_at DATETIME
);
CREATE INDEX host_feature_idx_host_id ON host_feature (host_id);
CREATE TABLE message (
id INTEGER PRIMARY KEY NOT NULL,
testrun_id INT(11) NOT NULL,
message VARCHAR(65000),
created_at TIMESTAMP DEFAULT 'CURRENT_TIMESTAMP',
updated_at DATETIME
);
CREATE INDEX message_idx_testrun_id ON message (testrun_id);
CREATE TABLE state (
id INTEGER PRIMARY KEY NOT NULL,
testrun_id INT(11) NOT NULL,
state VARCHAR(65000),
created_at TIMESTAMP DEFAULT 'CURRENT_TIMESTAMP',
updated_at DATETIME
);
CREATE INDEX state_idx_testrun_id ON state (testrun_id);
CREATE UNIQUE INDEX unique_testrun_id ON state (testrun_id);
CREATE TABLE testplan_instance (
id INTEGER PRIMARY KEY NOT NULL,
path VARCHAR(255) DEFAULT '',
name VARCHAR(255) DEFAULT '',
evaluated_testplan TEXT DEFAULT '',
created_at TIMESTAMP DEFAULT 'CURRENT_TIMESTAMP',
updated_at DATETIME
);
CREATE TEMPORARY TABLE testrun_temp_alter (
id INTEGER PRIMARY KEY NOT NULL,
shortname VARCHAR(255) DEFAULT '',
notes TEXT DEFAULT '',
topic_name VARCHAR(255) NOT NULL DEFAULT '',
starttime_earliest DATETIME,
starttime_testrun DATETIME,
starttime_test_program DATETIME,
endtime_test_program DATETIME,
owner_user_id INT(11),
testplan_id INT(11),
wait_after_tests INT(1) DEFAULT 0,
rerun_on_error INT(11) DEFAULT 0,
created_at TIMESTAMP DEFAULT 'CURRENT_TIMESTAMP',
updated_at DATETIME
);
INSERT INTO testrun_temp_alter SELECT id, shortname, notes, topic_name, starttime_earliest, starttime_testrun, starttime_test_program, endtime_test_program, owner_user_id, testplan_id, wait_after_tests, rerun_on_error, created_at, updated_at FROM testrun;
DROP TABLE testrun;
CREATE TABLE testrun (
id INTEGER PRIMARY KEY NOT NULL,
shortname VARCHAR(255) DEFAULT '',
notes TEXT DEFAULT '',
topic_name VARCHAR(255) NOT NULL DEFAULT '',
starttime_earliest DATETIME,
starttime_testrun DATETIME,
starttime_test_program DATETIME,
endtime_test_program DATETIME,
owner_user_id INT(11),
testplan_id INT(11),
wait_after_tests INT(1) DEFAULT 0,
rerun_on_error INT(11) DEFAULT 0,
created_at TIMESTAMP DEFAULT 'CURRENT_TIMESTAMP',
updated_at DATETIME
);
CREATE INDEX testrun_idx_owner_user_id03 ON testrun (owner_user_id);
CREATE INDEX testrun_idx_testplan_id03 ON testrun (testplan_id);
INSERT INTO testrun SELECT id, shortname, notes, topic_name, starttime_earliest, starttime_testrun, starttime_test_program, endtime_test_program, owner_user_id, testplan_id, wait_after_tests, rerun_on_error, created_at, updated_at FROM testrun_temp_alter;
DROP TABLE testrun_temp_alter;
COMMIT;