package siprp.update.updates;

import com.evolute.module.updater.AbstractUpdate;
import com.evolute.utils.db.Executer;

public class V10_4_To_V10_5 extends AbstractUpdate
{
	
	public V10_4_To_V10_5()
	{
		super(10.4,10.5,"Remocao dos dados de teste dos relatorio de higiene e seguranca");
	}
	
	@Override
	public void doUpdate() throws Exception
	{
		Executer executer = getExecuter();
		com.evolute.utils.sql.Update update = 
			new com.evolute.utils.sql.Update(
				"delete from hs_relatorio_posto_risco; " +
				"delete from hs_relatorio_posto_medida; " +
				"delete from hs_relatorio_posto; " +
				"delete from hs_relatorio_medida; " +
				"delete from hs_relatorio_area; " +
				"delete from hs_relatorio_risco; " +
				"delete from hs_relatorio_risco_valor_qualitativo; " +
				"delete from hs_relatorio_normalizacao; " +
				"delete from hs_relatorio_legislacao; " +
				"delete from hs_relatorio_equipamento; " +
				"delete from hs_relatorio; " +
				"delete from hs_email_estabelecimento; " +
				"delete from hs_email_empresa; " +
				"delete from hs_email; " +
				"delete from hs_equipamento; " +
				"delete from hs_posto_risco; " +
				"delete from hs_posto_medida; " +
				"delete from hs_posto_estabelecimento; " +
				"delete from hs_posto; " +
				"delete from hs_area; " +
				"delete from hs_legislacao_estabelecimento; " +
				"delete from hs_legislacao_empresa; " +
				"delete from hs_legislacao; " +
				"delete from hs_legislacao_categoria; " +
				"delete from hs_risco_empresa; " +
				"delete from hs_risco_medida; " +
				"delete from hs_medida; " +
				"delete from hs_risco; " +
				"delete from hs_risco_tema; " +
				"delete from hs_normalizacao_estabelecimento; " +
				"delete from hs_normalizacao_empresa; " +
				"delete from hs_normalizacao; "
		);
		executer.executeQuery( update );
	}
	
}
