X-Git-Url: https://git.llucax.com/mecon/samurai.git/blobdiff_plain/1fce1689d24ee6eed11644946bfa777a06d2ef8e..09dba8cedfb5642bb1d85935dff4dec2773c0b9e:/lib/SAMURAI/Perfil/consultas.ini?ds=sidebyside diff --git a/lib/SAMURAI/Perfil/consultas.ini b/lib/SAMURAI/Perfil/consultas.ini index fba4c77..7e28e3a 100644 --- a/lib/SAMURAI/Perfil/consultas.ini +++ b/lib/SAMURAI/Perfil/consultas.ini @@ -16,7 +16,7 @@ borrar_perfil_sist = " DELETE FROM samurai.perfil_sist WHERE id_perfil = ? A borrar_perfil = " DELETE FROM samurai.perfil WHERE id_perfil = ?" ;VERIFICACIONES -verificar_asociacion = " SELECT ps.id_perfil, ps.tipo_perfil FROM samurai.perfil_sist as ps WHERE ps.id_perfil = ? AND ps.id_sistema = ?" +verificar_asociacion = " SELECT ps.id_perfil FROM samurai.perfil_sist as ps WHERE ps.id_perfil = ? AND ps.id_sistema = ?" verif_perfil_sist_usuario = "SELECT IF(0,0,count(*)) as cuenta FROM samurai.perfil_sist_usuario WHERE id_perfil = ? AND id_sistema = ? " verif_perfil_sist = "SELECT IF(0,0,count(*)) as cuenta FROM samurai.perfil_sist WHERE id_perfil = ? "