DROP TABLE `db_usupplyit`.`tb_b_mconcepto`, `db_usupplyit`.`tb_b_menviado`, `db_usupplyit`.`tb_b_oadelanto`, `db_usupplyit`.`tb_b_oadelanto_dcuota`, `db_usupplyit`.`tb_b_obalance_dtimesheet`, `db_usupplyit`.`tb_b_omovimiento`, `db_usupplyit`.`tb_b_omovimiento_dpersonal`, `db_usupplyit`.`tb_b_opago`, `db_usupplyit`.`tb_b_opago_dpersonal`;
DROP TABLE `db_usupplyit`.`tb_f_mdias_festivos`, `db_usupplyit`.`tb_f_mforma_pago`, `db_usupplyit`.`tb_f_mfrecuencia`, `db_usupplyit`.`tb_f_mgrupo`, `db_usupplyit`.`tb_f_mincidencia`, `db_usupplyit`.`tb_f_mindicencia_nivel`, `db_usupplyit`.`tb_f_mpersonal`, `db_usupplyit`.`tb_f_mpersonal_drole`, `db_usupplyit`.`tb_f_mpersonal_galeria`, `db_usupplyit`.`tb_f_mplantilla`, `db_usupplyit`.`tb_f_mplantilla_dpersonal`, `db_usupplyit`.`tb_f_mplantilla_dpersonal_role`, `db_usupplyit`.`tb_f_mproyecto`, `db_usupplyit`.`tb_f_mrole`, `db_usupplyit`.`tb_f_msupervisor`, `db_usupplyit`.`tb_f_oincidencia`, `db_usupplyit`.`tb_f_oincidencia_dpersonal`, `db_usupplyit`.`tb_f_oincidencia_dpersonal_role`, `db_usupplyit`.`tb_f_otimesheet`, `db_usupplyit`.`tb_f_otimesheet_dcalculo`, `db_usupplyit`.`tb_f_otimesheet_dgaleria`, `db_usupplyit`.`tb_f_otimesheet_dpersonal_evento`, `db_usupplyit`.`tb_f_otimesheet_dpersonal_role`, `db_usupplyit`.`tb_f_otimesheet_dpersonal_role_fecha`, `db_usupplyit`.`tb_f_otimesheet_galeria`;
DROP TABLE `db_usupplyit`.`tb_g_msexo`, `db_usupplyit`.`temp_ventas`;

DROP PROCEDURE `db_usupplyit`.`sp_cbusqueda_b_oadelanto`;
DROP PROCEDURE `db_usupplyit`.`sp_cbusqueda_b_omovimiento`;
DROP PROCEDURE `db_usupplyit`.`sp_cbusqueda_b_omovimiento_dpersonal_b`;
DROP PROCEDURE `db_usupplyit`.`sp_cbusqueda_b_opago`;
DROP PROCEDURE `db_usupplyit`.`sp_cbusqueda_f_mpersonal`;
DROP PROCEDURE `db_usupplyit`.`sp_cbusqueda_f_mplantilla`;
DROP PROCEDURE `db_usupplyit`.`sp_cbusqueda_f_mplantilla_dpersonal_role_b`;
DROP PROCEDURE `db_usupplyit`.`sp_cbusqueda_f_oincidencia`;
DROP PROCEDURE `db_usupplyit`.`sp_cbusqueda_f_oincidencia_dpersonal_b`;
DROP PROCEDURE `db_usupplyit`.`sp_cbusqueda_f_oincidencia_dpersonal_role_b`;
DROP PROCEDURE `db_usupplyit`.`sp_cbusqueda_f_otimesheet`;
DROP PROCEDURE `db_usupplyit`.`sp_cbusqueda_f_otimesheet_dpersonal_role_b`;
DROP PROCEDURE `db_usupplyit`.`sp_cbusqueda_f_otimesheet_dpersonal_role_cargar`;
DROP PROCEDURE `db_usupplyit`.`sp_cbusqueda_f_otimesheet_dpersonal_role_cargar_extra`;
DROP PROCEDURE `db_usupplyit`.`sp_cbusqueda_f_otimesheet_supervisor`;
DROP PROCEDURE `db_usupplyit`.`sp_cbusqueda_f_otimesheetf_dpersonal_role_b`;
DROP PROCEDURE `db_usupplyit`.`sp_cbusqueda_g_otasa`;
DROP PROCEDURE `db_usupplyit`.`sp_form_b_mconcepto_u`;
DROP PROCEDURE `db_usupplyit`.`sp_form_b_menviado_u`;
DROP PROCEDURE `db_usupplyit`.`sp_form_b_oadelanto_anular_u`;
DROP PROCEDURE `db_usupplyit`.`sp_form_b_oadelanto_aprobar_u`;
DROP PROCEDURE `db_usupplyit`.`sp_form_b_oadelanto_c`;
DROP PROCEDURE `db_usupplyit`.`sp_form_b_oadelanto_dcuota_c`;
DROP PROCEDURE `db_usupplyit`.`sp_form_b_oadelanto_dcuota_u`;
DROP PROCEDURE `db_usupplyit`.`sp_form_b_oadelanto_dcuotas_u`;
DROP PROCEDURE `db_usupplyit`.`sp_form_b_oadelanto_u`;
DROP PROCEDURE `db_usupplyit`.`sp_form_b_omovimiento_anular_u`;
DROP PROCEDURE `db_usupplyit`.`sp_form_b_omovimiento_aprobar_u`;
DROP PROCEDURE `db_usupplyit`.`sp_form_b_omovimiento_c`;
DROP PROCEDURE `db_usupplyit`.`sp_form_b_omovimiento_cr_u`;
DROP PROCEDURE `db_usupplyit`.`sp_form_b_omovimiento_db_u`;
DROP PROCEDURE `db_usupplyit`.`sp_form_b_omovimiento_dpersonal_c`;
DROP PROCEDURE `db_usupplyit`.`sp_form_b_omovimiento_dpersonal_u`;
DROP PROCEDURE `db_usupplyit`.`sp_form_b_omovimiento_dpersonal_u_cr`;
DROP PROCEDURE `db_usupplyit`.`sp_form_b_omovimiento_dpersonal_u_db`;
DROP PROCEDURE `db_usupplyit`.`sp_form_b_omovimiento_i`;
DROP PROCEDURE `db_usupplyit`.`sp_form_b_omovimiento_nc_u`;
DROP PROCEDURE `db_usupplyit`.`sp_form_b_omovimiento_nd_u`;
DROP PROCEDURE `db_usupplyit`.`sp_form_b_omovimiento_u`;
DROP PROCEDURE `db_usupplyit`.`sp_form_b_opago_anular_u`;
DROP PROCEDURE `db_usupplyit`.`sp_form_b_opago_dpersonal_c`;
DROP PROCEDURE `db_usupplyit`.`sp_form_b_opago_dpersonal_c_cargar`;
DROP PROCEDURE `db_usupplyit`.`sp_form_b_opago_dpersonal_u`;
DROP PROCEDURE `db_usupplyit`.`sp_form_b_opago_estatus_u`;
DROP PROCEDURE `db_usupplyit`.`sp_form_b_opago_i`;
DROP PROCEDURE `db_usupplyit`.`sp_form_b_opago_u`;
DROP PROCEDURE `db_usupplyit`.`sp_form_b_opago_numero_c`;
DROP PROCEDURE `db_usupplyit`.`sp_form_f_mdias_festivos_c`;
DROP PROCEDURE `db_usupplyit`.`sp_form_f_mdias_festivos_u`;
DROP PROCEDURE `db_usupplyit`.`sp_form_f_mforma_pago_u`;
DROP PROCEDURE `db_usupplyit`.`sp_form_f_mfrecuencia_c_cargar`;
DROP PROCEDURE `db_usupplyit`.`sp_form_f_mfrecuencia_u`;
DROP PROCEDURE `db_usupplyit`.`sp_form_f_mgrupo_u`;
DROP PROCEDURE `db_usupplyit`.`sp_form_f_mincidencia_nivel_u`;
DROP PROCEDURE `db_usupplyit`.`sp_form_f_mincidencia_u`;
DROP PROCEDURE `db_usupplyit`.`sp_form_f_mpersonal_c`;
DROP PROCEDURE `db_usupplyit`.`sp_form_f_mpersonal_dincidencia_c`;
DROP PROCEDURE `db_usupplyit`.`sp_form_f_mpersonal_drole_c`;
DROP PROCEDURE `db_usupplyit`.`sp_form_f_mpersonal_drole_u`;
DROP PROCEDURE `db_usupplyit`.`sp_form_f_mpersonal_drole_u_sinmargen`;
DROP PROCEDURE `db_usupplyit`.`sp_form_f_mpersonal_drole_u_sinrate`;
DROP PROCEDURE `db_usupplyit`.`sp_form_f_mpersonal_u`;
DROP PROCEDURE `db_usupplyit`.`sp_form_f_mplantilla_c`;
DROP PROCEDURE `db_usupplyit`.`sp_form_f_mplantilla_c_cargar`;
DROP PROCEDURE `db_usupplyit`.`sp_form_f_mplantilla_dpersonal_c`;
DROP PROCEDURE `db_usupplyit`.`sp_form_f_mplantilla_dpersonal_cargar_c`;
DROP PROCEDURE `db_usupplyit`.`sp_form_f_mplantilla_dpersonal_role_c`;
DROP PROCEDURE `db_usupplyit`.`sp_form_f_mplantilla_dpersonal_role_c_cargar`;
DROP PROCEDURE `db_usupplyit`.`sp_form_f_mplantilla_dpersonal_role_u`;
DROP PROCEDURE `db_usupplyit`.`sp_form_f_mplantilla_dpersonal_role_u_log`;
DROP PROCEDURE `db_usupplyit`.`sp_form_f_mplantilla_dpersonal_role_u_sinmargen`;
DROP PROCEDURE `db_usupplyit`.`sp_form_f_mplantilla_dpersonal_role_u_timesheet`;
DROP PROCEDURE `db_usupplyit`.`sp_form_f_mplantilla_dpersonal_u`;
DROP PROCEDURE `db_usupplyit`.`sp_form_f_mplantilla_horas_ds`;
DROP PROCEDURE `db_usupplyit`.`sp_form_f_mplantilla_i`;
DROP PROCEDURE `db_usupplyit`.`sp_form_f_mplantilla_u`;
DROP PROCEDURE `db_usupplyit`.`sp_form_f_mproyecto_u`;
DROP PROCEDURE `db_usupplyit`.`sp_form_f_mrole_c`;
DROP PROCEDURE `db_usupplyit`.`sp_form_f_mrole_u`;
DROP PROCEDURE `db_usupplyit`.`sp_form_f_mrole_u_general`;
DROP PROCEDURE `db_usupplyit`.`sp_form_f_msupervisor_u`;
DROP PROCEDURE `db_usupplyit`.`sp_form_f_oincidencia_dpersonal_c`;
DROP PROCEDURE `db_usupplyit`.`sp_form_f_oincidencia_dpersonal_u`;
DROP PROCEDURE `db_usupplyit`.`sp_form_f_oincidencia_numero_c`;
DROP PROCEDURE `db_usupplyit`.`sp_form_f_oincidencia_u`;
DROP PROCEDURE `db_usupplyit`.`sp_form_f_omovimiento_dpersonal_cargar_c`;
DROP PROCEDURE `db_usupplyit`.`sp_form_f_otimesheed_numero_c`;
DROP PROCEDURE `db_usupplyit`.`sp_form_f_otimesheet_anular_u`;
DROP PROCEDURE `db_usupplyit`.`sp_form_f_otimesheet_aprobar_u`;
DROP PROCEDURE `db_usupplyit`.`sp_form_f_otimesheet_c_cliente_fecha`;
DROP PROCEDURE `db_usupplyit`.`sp_form_f_otimesheet_dgaleria_c`;
DROP PROCEDURE `db_usupplyit`.`sp_form_f_otimesheet_dgaleria_u`;
DROP PROCEDURE `db_usupplyit`.`sp_form_f_otimesheet_dpersonal_role_c`;
DROP PROCEDURE `db_usupplyit`.`sp_form_f_otimesheet_dpersonal_role_c_cargar`;
DROP PROCEDURE `db_usupplyit`.`sp_form_f_otimesheet_dpersonal_role_fecha_c`;
DROP PROCEDURE `db_usupplyit`.`sp_form_f_otimesheet_dpersonal_role_fecha_i`;
DROP PROCEDURE `db_usupplyit`.`sp_form_f_otimesheet_dpersonal_role_fecha_u`;
DROP PROCEDURE `db_usupplyit`.`sp_form_f_otimesheet_dpersonal_role_i`;
DROP PROCEDURE `db_usupplyit`.`sp_form_f_otimesheet_dpersonal_role_u`;
DROP PROCEDURE `db_usupplyit`.`sp_form_f_otimesheet_drole_total_c`;
DROP PROCEDURE `db_usupplyit`.`sp_form_f_otimesheet_estatus_u`;
DROP PROCEDURE `db_usupplyit`.`sp_form_f_otimesheet_fecha_siguiente_c`;
DROP PROCEDURE `db_usupplyit`.`sp_form_f_otimesheet_fecha_siguiente_y_OT_c`;
DROP PROCEDURE `db_usupplyit`.`sp_form_f_otimesheet_i`;
DROP PROCEDURE `db_usupplyit`.`sp_form_f_otimesheet_numero_c`;
DROP PROCEDURE `db_usupplyit`.`sp_form_f_otimesheet_plantilla_cliente_OT_c`;
DROP PROCEDURE `db_usupplyit`.`sp_form_f_otimesheet_u`;
DROP PROCEDURE `db_usupplyit`.`sp_form_f_otimesheetp_dpersonal_role_c`;
DROP PROCEDURE `db_usupplyit`.`sp_form_f_otimesheetp_dpersonal_role_c_cargar`;
DROP PROCEDURE `db_usupplyit`.`sp_form_f_otimesheetp_dpersonal_role_fecha_c`;
DROP PROCEDURE `db_usupplyit`.`sp_form_f_otimesheetp_dpersonal_role_fecha_i`;
DROP PROCEDURE `db_usupplyit`.`sp_form_f_otimesheetp_dpersonal_role_i`;
DROP PROCEDURE `db_usupplyit`.`sp_form_f_otimesheetp_drole_total_c`;
DROP PROCEDURE `db_usupplyit`.`sp_form_g_mdivisa_dtasa_u`;
DROP PROCEDURE `db_usupplyit`.`sp_form_g_mdivisa_u`;
DROP PROCEDURE `db_usupplyit`.`sp_form_g_mmoneda_u`;
DROP PROCEDURE `db_usupplyit`.`sp_form_g_mtipo_documento_u`;
DROP PROCEDURE `db_usupplyit`.`sp_form_g_otasa_c`;
DROP PROCEDURE `db_usupplyit`.`sp_form_g_otasa_dhistorial_c`;
DROP PROCEDURE `db_usupplyit`.`sp_form_g_otasa_hoy_c`;
DROP PROCEDURE `db_usupplyit`.`sp_form_g_otasa_u`;
DROP PROCEDURE `db_usupplyit`.`sp_gra_f_otimesheet_cliente_neto`;
DROP PROCEDURE `db_usupplyit`.`sp_gra_f_otimesheet_dia`;
DROP PROCEDURE `db_usupplyit`.`sp_gra_f_otimesheet_drole`;
DROP PROCEDURE `db_usupplyit`.`sp_gra_f_otimesheet_factura`;
DROP PROCEDURE `db_usupplyit`.`sp_lista_b_mcliente`;
DROP PROCEDURE `db_usupplyit`.`sp_lista_b_mcliente_filtrada`;
DROP PROCEDURE `db_usupplyit`.`sp_lista_b_mconcepto`;
DROP PROCEDURE `db_usupplyit`.`sp_lista_b_menviado`;
DROP PROCEDURE `db_usupplyit`.`sp_lista_b_opago`;
DROP PROCEDURE `db_usupplyit`.`sp_lista_b_opago_timesheet`;
DROP PROCEDURE `db_usupplyit`.`sp_lista_f_mciudad_carga_c`;
DROP PROCEDURE `db_usupplyit`.`sp_lista_f_mgrupo`;
DROP PROCEDURE `db_usupplyit`.`sp_lista_f_mincidencia`;
DROP PROCEDURE `db_usupplyit`.`sp_lista_f_mincidencia_nivel`;
DROP PROCEDURE `db_usupplyit`.`sp_lista_f_mpersonal`;
DROP PROCEDURE `db_usupplyit`.`sp_lista_f_mpersonal_ciudad_carga_c`;
DROP PROCEDURE `db_usupplyit`.`sp_lista_f_mplantilla`;
DROP PROCEDURE `db_usupplyit`.`sp_lista_f_mplantilla_filtrada`;
DROP PROCEDURE `db_usupplyit`.`sp_lista_f_mproyecto`;
DROP PROCEDURE `db_usupplyit`.`sp_lista_f_mrole`;
DROP PROCEDURE `db_usupplyit`.`sp_lista_f_msupervisor`;
DROP PROCEDURE `db_usupplyit`.`sp_lista_f_msupervisor_filtrada`;
DROP PROCEDURE `db_usupplyit`.`sp_rep_b_opago_dpersonal_c`;
DROP PROCEDURE `db_usupplyit`.`sp_rep_f_otimesheet_analisis_cliente_c`;
DROP PROCEDURE `db_usupplyit`.`sp_rep_f_otimesheet_cliente_resumen_c`;
DROP PROCEDURE `db_usupplyit`.`sp_rep_f_otimesheet_cliente_resumen_neto_c`;
DROP PROCEDURE `db_usupplyit`.`sp_rep_f_otimesheet_cliente_role_c`;
DROP PROCEDURE `db_usupplyit`.`sp_rep_f_otimesheet_dpersonal_c`;
DROP PROCEDURE `db_usupplyit`.`sp_rep_f_otimesheet_estado_ciudad_cliente_resumen_c`;
DROP PROCEDURE `db_usupplyit`.`sp_rep_f_otimesheet_estado_ciudad_cliente_resumen_neto_c`;
DROP PROCEDURE `db_usupplyit`.`sp_rep_f_otimesheet_estado_ciudad_role_resumen_c`;
DROP PROCEDURE `db_usupplyit`.`sp_rep_f_otimesheet_estado_ciudad_role_resumen_neto_c`;
DROP PROCEDURE `db_usupplyit`.`sp_rep_f_otimesheet_state_customer_staff_c`;
DROP PROCEDURE `db_usupplyit`.`sp_rep_f_otimesheet_total_ciudad_c_cliente`;
DROP PROCEDURE `db_usupplyit`.`sp_rep_f_otimesheet_total_ciudad_c_role`;
DROP PROCEDURE `db_usupplyit`.`sp_rep_f_otimesheet_total_cliente_c`;
DROP PROCEDURE `db_usupplyit`.`sp_rep_f_otimesheet_total_neto_c_cliente`;
DROP PROCEDURE `db_usupplyit`.`sp_rep_f_otimesheet_total_neto_c_role`;
DROP PROCEDURE `db_usupplyit`.`sp_rep_f_otimesheet_total_personal_c`;
DROP PROCEDURE `db_usupplyit`.`sp_rep_f_otimesheet_total_personal_resumen_c`;
DROP PROCEDURE `db_usupplyit`.`sp_rep_f_otimesheet_total_profit_c_cliente`;
DROP PROCEDURE `db_usupplyit`.`sp_rep_f_otimesheet_total_profit_c_role`;
DROP PROCEDURE `db_usupplyit`.`sp_rep_f_otimeshhet_dpersonal_c`;
