+CREATE TABLE validation_test_result
+(
+ id bigint not NULL AUTO_INCREMENT,
+ blueprint_instance_id bigint not NULL,
+ all_layers boolean,
+ lab_id bigint not NULL,
+ timestamp varchar(255),
+ optional boolean,
+ result boolean,
+ submission_id bigint,
+ date_of_storage text,
+ CONSTRAINT id_pk PRIMARY KEY (id),
+ CONSTRAINT lab_id_fk2 FOREIGN KEY (lab_id)
+ REFERENCES lab (id) MATCH SIMPLE
+ ON UPDATE NO ACTION ON DELETE NO ACTION,
+ CONSTRAINT submission_id_fk FOREIGN KEY (submission_id)
+ REFERENCES submission (id) MATCH SIMPLE
+ ON UPDATE NO ACTION ON DELETE NO ACTION,
+ CONSTRAINT blueprint_instance_id_fk FOREIGN KEY (blueprint_instance_id)
+ REFERENCES blueprint_instance (id) MATCH SIMPLE
+ ON UPDATE NO ACTION ON DELETE NO ACTION,
+ unique (timestamp, lab_id)
+);
+
+CREATE TABLE w_robot_test_result
+(
+ id bigint not NULL AUTO_INCREMENT,
+ layer varchar(255) not NULL,
+ validation_test_result_id bigint not NULL,
+ robot_test_results LONGTEXT,
+ CONSTRAINT id_pk PRIMARY KEY (id),
+ CONSTRAINT validation_test_result_id_fk FOREIGN KEY (validation_test_result_id)
+ REFERENCES validation_test_result (id) MATCH SIMPLE
+ ON UPDATE NO ACTION ON DELETE NO ACTION,
+ unique (layer, validation_test_result_id)
+);
+