X-Git-Url: https://git.llucax.com/mecon/samurai.git/blobdiff_plain/d0ae155a8be2168110755cce58865068b34bfe91..22d1ae1aa6bfee6df20dfa9544e14feaecc9fbf4:/lib/SAMURAI/Sistema/consultas.php?ds=inline diff --git a/lib/SAMURAI/Sistema/consultas.php b/lib/SAMURAI/Sistema/consultas.php index 142340b..c1e0ec4 100644 --- a/lib/SAMURAI/Sistema/consultas.php +++ b/lib/SAMURAI/Sistema/consultas.php @@ -25,15 +25,15 @@ // return array ( //OBTENER DATOS - 'obtener_datos_sistema' => 'SELECT id_sistema, nombre_sistema, desc_sistema, fecha_inicio, fecha_fin, fecha_implementacion, contacto,responsable FROM sistema ', + 'obtener_datos_sistema' => 'SELECT id_sistema, nombre_sistema, desc_sistema, fecha_inicio, fecha_fin, fecha_implementacion, contacto,responsable FROM samurai.sistema ', 'obtener_datos_sistema2' => ' WHERE id_sistema = ? ', - 'obtener_permisos' => 'SELECT id_permiso, observaciones FROM perm_sist WHERE id_sistema = ?', + 'obtener_permisos' => 'SELECT id_permiso, observaciones FROM samurai.perm_sist WHERE id_sistema = ?', 'obtener_permisos2' => ' ORDER BY id_permiso', 'obtener_permisos3' => ' AND id_permiso = ?', 'obtener_permisos4' => ' AND observaciones = ?', - 'obtener_max_id_sistemas' => 'SELECT IFNULL(max(id_sistema), 1) as id_sistema FROM sistema', + 'obtener_max_id_sistemas' => 'SELECT IFNULL(max(id_sistema), 1) as id_sistema FROM samurai.sistema', //BORRAR DATOS - 'borrar_permisos' => 'DELETE FROM perm_sist WHERE id_sistema = ? ', + 'borrar_permisos' => 'DELETE FROM samurai.perm_sist WHERE id_sistema = ? ', 'borrar_permisos2' => ' AND observaciones = ?', 'borrar_permisos3' => ' AND id_permiso = ?', );