use [000002HLDDB];
delete from DMTestePagamento;
delete from DMTeste;
delete from DMTesteCT;
delete from DMVoucher;

use [000002EXAMDB];
delete from DMTeste;
delete from DMTesteCT;
delete from DataProgramacaoDMTeste;
delete from DataProgramacaoDMTesteCT;
delete from CentroTeste;

update DataProgramacaoDMTeste set IdSituacao = 1;
update DataProgramacaoDMTesteCT set IdSituacao = 1;

use [000002MYTESTDB];
delete from DMTestePagamento;
delete from DMTeste;
delete from DMTesteCT;
delete from DataProgramacaoDMTeste;
delete from DataProgramacaoDMTesteCT;
delete from DataProgramacaoDMTestePagamento;

update DataProgramacaoDMTeste set IdSituacao = 1;
update DataProgramacaoDMTesteCT set IdSituacao = 1;
update DataProgramacaoDMTestePagamento set IdSituacao = 1;

use [000002HLDDB];
delete from DMCandidato;

use [000002MYTESTDB];
delete from DMCandidato;
update DataProgramacaoDMCandidato set IdSituacao = 1;


use [000002HLDDB];
delete from DMVoucher;

use [000002SYSTEMDB];
delete from DMVoucher;
update DataProgramacaoDMVoucher set IdSituacao = 1;


update Agendamento set DataAgendamentoConfirmado = cast (substring(dataprogramada, 1, 4) + '-' + substring(dataprogramada, 5, 2) + '-' + substring(dataprogramada, 7, 2) as datetime);
update Prova set DataAgendamentoConfirmado = DataProgramada;


use [000006MYTESTDB];
delete from InscricaoVoucher;
delete from InscricaoTeste;
delete from Inscricao;

use [000006HISTDB];
delete from Agendamento;
delete from ProvaGerada;
delete from Prova;
delete from InscricaoTeste;
delete from Inscricao;


use [000006SYSTEMDB];
delete from InscricaoAutomatica;
delete from Voucher;
delete from PedidoVoucher;
delete from UsuarioEntidadeFinanciadora;
delete from EntidadeFinanciadora;

use [000006EXAMDB];
delete from Agendamento;
delete from ProvaGerada;
delete from Prova;
delete from InscricaoTeste;
delete from Inscricao;
delete from RespostaItemProva;
delete from ItemProva;
delete from LogProva;
delete from RespostaQuestaoProva;
delete from QuestaoProva;
update BundleTeste set Uso = 0;

use [000006HLDDB];
delete from EntidadeFinanciadora;
delete from CentroTeste;