\c gazelle-webservice-tester

DELETE FROM gwt_custom_property_used;
SELECT setval('gwt_custom_property_used_id_seq', 1);
DELETE FROM gwt_soapui_messages;
DELETE FROM gwt_test_step_result_gwt_validation_result;
DELETE FROM gwt_validation_result;
SELECT setval('gwt_validation_result_id_seq', 1);
DELETE FROM gwt_test_step_result_attachment_response;
DELETE FROM gwt_test_step_result_attachment_request;
DELETE FROM gwt_test_step_result;
SELECT setval('gwt_test_step_result_id_seq', 1);

alter table gwt_execution DROP CONSTRAINT fk_8nus684yiech8v4yypm29nqys;
alter table gwt_test_instance_result DROP CONSTRAINT fk_tdnm9dlf6e38lgc7okaywpq7b;


DELETE FROM gwt_test_instance_result;
SELECT setval('gwt_test_instance_result_id_seq', 1);
DELETE FROM gwt_execution;
SELECT setval('gwt_execution_id_seq', 1);

alter table gwt_execution ADD CONSTRAINT fk_8nus684yiech8v4yypm29nqys FOREIGN KEY (execution) REFERENCES gwt_test_instance_result(id);
alter table gwt_test_instance_result ADD CONSTRAINT fk_tdnm9dlf6e38lgc7okaywpq7b FOREIGN KEY (test_execution_id) REFERENCES gwt_execution(id);
