SQLite format 3@ <B0<-$ >?S-indexsqlite_autoindex_preconditiontype_1preconditiontype:%%7tablepreconditionpreconditionCREATE TABLE precondition ( id INTEGER PRIMARY KEY NOT NULL, shortname VARCHAR(255) NOT NULL DEFAULT '', precondition TEXT, timeout INT(10) )tableownerownerCREATE TABLE owner ( id INTEGER PRIMARY KEY NOT NULL, name VARCHAR(255), login VARCHAR(255) NOT NULL, password VARCHAR(255) )Q+qindexconstraint_namehostCREATE UNIQUE INDEX constraint_name ON host (name).?tablehosthostCREATE TABLE host ( id INTEGER PRIMARY KEY NOT NULL, name VARCHAR(255) DEFAULT '', comment VARCHAR(255) DEFAULT '', free TINYINT DEFAULT 0, active TINYINT DEFAULT 0, is_deleted TINYINT DEFAULT 0, created_at TIMES:.6-0)+%%!         33dV/.?tablehosthostCREATE TABLE host ( id INTEGER PRIMARY KEY NOT NULL, name VARCHAR(255) DEFAULT '', comment VARCHAR(255) DEFAULT '', free TINYINT DEFAULT 0, active TINYINT DEFAULT 0, is_deleted TINYINT DEFAULT 0, created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP, updated_at DATETIME )Q+qindexconstraint_namehostCREATE UNIQUE INDEX constraint_name ON host (name)tableownerownerCREATE TABLE owner ( id INTEGER PRIMARY KEY NOT NULL, name VARCHAR(255), login VARCHAR(255) NOT NULL, password VARCHAR(255) ):%%7tablepreconditionpreconditionCREATE TABLE precondition ( id INTEGER PRIMARY KEY NOT NULL, shortname VARCHAR(255) NOT NULL DEFAULT '', precondition TEXT, timeout INT(10) ))--tablepreconditiontypepreconditiontypeCREATE TABLE preconditiontype ( name VARCHAR(255) NOT NULL, description TEXT NOT NULL DEFAULT '', PRIMARY KEY (name) )?S-indexsqlite_autoindex_preconditiontype_1preconditiontype  //sPuJJAatablequeuequeue CREATE TABLE queue ( id INTEGER PRIMARY KEY NOT NULL, name VARCHAR(255) DEFAULT '', priority INT(10) NOT NULL DEFAULT 0, runcount INT(10) NOT NULL DEFAULT 0, active INT(1) DEFAULT 0, is_deleted TINYINT DEFAULT 0, created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP, updated_at DATETIME )W/windexunique_queue_namequeue CREATE UNIQUE INDEX unique_queue_name ON queue (name) Utablescenarioscenario CREATE TABLE scenario ( id INTEGER PRIMARY KEY NOT NULL, type VARCHAR(255) NOT NULL DEFAULT '' )" //stabletestplan_instancetestplan_instance 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 ) otabletopictopicCREATE TABLE topic ( name VARCHAR(255) NOT NULL, description TEXT NOT NULL DEFAULT '', PRIMARY KEY (name) )      ::e.\?S-indexsqlite_autoindex_pre_p) =indexsqlite_autoindex_topic_1topicT %%ktablehost_featurehost_featureCREATE 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, FOREIGN KEY (host_id) REFERENCES host(id) ON DELETE CASCADE ON UPDATE CASCADE )p=% indexhost_feature_idx_host_idhost_featureCREATE INDEX host_feature_idx_host_id ON host_feature (host_id)O--Qtablepre_preconditionpre_preconditionCREATE TABLE pre_precondition ( parent_precondition_id INT(11) NOT NULL, child_precondition_id INT(11) NOT NULL, succession INT(10) NOT NULL, PRIMARY KEY (parent_precondition_id, child_precondition_id), FOREIGN KEY (child_precondition_id) REFERENCES precondition(id) ON DELETE CASCADE ON UPDATE CASCADE, FOREIGN KEY (parent_precondition_id) REFERENCES precondition(id) ON DELETE CASCADE ON UPDATE CASCADE )     QB>o=# indexdenied_host_idx_queue_iddenied_hostCREATE INDEX denied_host_idx_queue_id ON denied_host (queue_id)?S-indexsqlite_autoindex_pre_precondition_1pre_precondition*a-Sindexpre_precondition_idx_child_precondition_idpre_preconditionCREATE INDEX pre_precondition_idx_child_precondition_id ON pre_precondition (child_precondition_id)-c-Windexpre_precondition_idx_parent_precondition_idpre_preconditionCREATE INDEX pre_precondition_idx_parent_precondition_id ON pre_precondition (parent_precondition_id)>##Ctabledenied_hostdenied_hostCREATE TABLE denied_host ( id INTEGER PRIMARY KEY NOT NULL, queue_id INT(11) NOT NULL, host_id INT(11) NOT NULL, FOREIGN KEY (host_id) REFERENCES host(id) ON DELETE CASCADE ON UPDATE CASCADE, FOREIGN KEY (queue_id) REFERENCES queue(id) ON DELETE CASCADE ON UPDATE CASCADE )l;#indexdenied_host_idx_host_iddenied_hostCREATE INDEX denied_host_idx_host_id ON denied_host (host_id)       zz) k;!indexqueue_host_idx_queue_idqueue_hostCREATE INDEX queue_host_idx_queue_id ON queue_host (queue_id)ho=# indexdenied_host_idx_queue_iddenied_hostCREATE INDEX denied_host_idx_queue_id ON denied_host (queue_id);!!Atablequeue_hostqueue_hostCREATE TABLE queue_host ( id INTEGER PRIMARY KEY NOT NULL, queue_id INT(11) NOT NULL, host_id INT(11) NOT NULL, FOREIGN KEY (host_id) REFERENCES host(id) ON DELETE CASCADE ON UPDATE CASCADE, FOREIGN KEY (queue_id) REFERENCES queue(id) ON DELETE CASCADE ON UPDATE CASCADE )h9!indexqueue_host_idx_host_idqueue_hostCREATE INDEX queue_host_idx_host_id ON queue_host (host_id)k;!indexqueue_host_idx_queue_idqueue_hostCREATE INDEX queue_host_idx_queue_id ON queue_host (queue_id)    DD/@gtabletestruntestrunCREATE 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_id INT(11), testplan_id INT(11), wait_after_tests INT(1) DEFAULT 0, rerun_on_error INT(11) DEFAULT 0, created_at TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP, updated_at DATETIME, FOREIGN KEY (owner_id) REFERENCES owner(id), FOREIGN KEY (testplan_id) REFERENCES testplan_instance(id) ON UPDATE CASCADE )^5{indextestrun_idx_owner_idtestrun!CREATE INDEX testrun_idx_owner_id ON testrun (owner_id)h;indextestrun_idx_testplan_idtestrun"CREATE INDEX testrun_idx_testplan_id ON testrun (testplan_id)e9indextestrun_idx_created_attestrun#CREATE INDEX testrun_idx_created_at ON testrun (created_at)     +Btablestatestate'CREATE TABLE state ( id INTEGER PRIMARY KEY NOT NULL, testrun_id INT(11) NOT NULL:Ktablemessagemessage$CREATE TABLE message ( id INTEGER PRIMARY KEY NOT NULL, testrun_id INT(11), message VARCHAR(65000), type VARCHAR(255), created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP, updated_at DATETIME, FOREIGN KEY (testrun_id) REFERENCES testrun(id) ON DELETE CASCADE ON UPDATE CASCADE )e9indexmessage_idx_testrun_idmessage&CREATE INDEX message_idx_testrun_id ON message (testrun_id)tablestatestate'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, FOREIGN KEY (testrun_id) REFERENCES testrun(id) ON DELETE CASCADE )\ 5{indexstate_idx_testrun_idstate(CREATE INDEX state_idx_testrun_id ON state (testrun_id)^!/indexunique_testrun_idstate)CREATE UNIQUE INDEX unique_testrun_id ON state (testrun_id)      GGJqt$--tablescenario_elementscenario_element"??tabletestrun_requested_featuretestrun_requested_feature*CREATE TABLE testrun_requested_feature ( id INTEGER PRIMARY KEY NOT NULL, testrun_id INT(11) NOT NULL, feature VARCHAR(255) DEFAULT '', FOREIGN KEY (testrun_id) REFERENCES testrun(id) )-#]?Kindextestrun_requested_feature_idx_testrun_idtestrun_requested_feature,CREATE INDEX testrun_requested_feature_idx_testrun_id ON testrun_requested_feature (testrun_id)t$--tablescenario_elementscenario_element-CREATE TABLE scenario_element ( id INTEGER PRIMARY KEY NOT NULL, testrun_id INT(11) NOT NULL, scenario_id INT(11) NOT NULL, is_fitted INT(1) NOT NULL DEFAULT 0, FOREIGN KEY (scenario_id) REFERENCES scenario(id) ON DELETE CASCADE ON UPDATE CASCADE, FOREIGN KEY (testrun_id) REFERENCES testrun(id) ON DELETE CASCADE ) %M-+indexscenario_element_idx_scenario_idscenario_element.CREATE INDEX scenario_element_idx_scenario_id ON scenario_element (scenario_id)     r UdF &K-'indexscenario_element_idx_testrun_idscenario_element/CREATE INDEX scenario_element_idx_testrun_id ON scenario_element (testrun_id)'55Qtablet &K-'indexscenario_element_idx_testrun_idscenario_element/CREATE INDEX scenario_element_idx_testrun_id ON scenario_element (testrun_id)'55Qtabletestrun_preconditiontestrun_precondition1CREATE TABLE testrun_precondition ( testrun_id INT(11) NOT NULL, precondition_id INT(11) NOT NULL, succession INT(10), PRIMARY KEY (testrun_id, precondition_id), FOREIGN KEY (precondition_id) REFERENCES precondition(id) ON DELETE CASCADE ON UPDATE CASCADE, FOREIGN KEY (testrun_id) REFERENCES testrun(id) ON DELETE CASCADE ON UPDATE CASCADE )G([5indexsqlite_autoindex_testrun_precondition_1testrun_precondition2()]5Kindextestrun_precondition_idx_precondition_idtestrun_precondition3CREATE INDEX testrun_precondition_idx_precondition_id ON testrun_precondition (precondition_id)      \ZV!-W9?indextestrun_requested_host_idx_testrun_idtestrun_requested_host8CREATE INDEX testrun_requested_host_idx_testrun_id ON testrun_requested_host (testrun_id),Q9*S57indextestrun_precondition_idx_testrun_idtestrun_precondition4CREATE INDEX testrun_precondition_idx_testrun_id ON testrun_precondition (testrun_id)+99Utabletestrun_requested_hosttestrun_requested_host5CREATE TABLE testrun_requested_host ( id INTEGER PRIMARY KEY NOT NULL, testrun_id INT(11) NOT NULL, host_id INT(11) NOT NULL, FOREIGN KEY (host_id) REFERENCES host(id), FOREIGN KEY (testrun_id) REFERENCES testrun(id) ),Q93indextestrun_requested_host_idx_host_idtestrun_requested_host7CREATE INDEX testrun_requested_host_idx_host_id ON testrun_requested_host (host_id)!-W9?indextestrun_requested_host_idx_testrun_idtestrun_requested_host8CREATE INDEX testrun_requested_host_idx_testrun_id ON testrun_requested_host (testrun_id)     0K1'indextestrun_scheduling_idx_queue_idtestrun_scheduling