-- generated by export_tables.php on 2025-12-02 16:02:03
-- source: ip.sysfar.com.br/gtsyscon_gtsys -> table: gtsys_logusuario

create table gtsys_logusuario
(
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `id_usuario` int(11) NOT NULL,
  `id_categoria` int(50) NOT NULL,
  `data` date NOT NULL,
  `hora` time NOT NULL,
  PRIMARY KEY (`id`,`id_usuario`,`id_categoria`),
  CONSTRAINT `gtsys_logusuario_ibfk_1` FOREIGN KEY (`id_usuario`) REFERENCES `gtsys_usuarios` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
)ENGINE=InnoDB AUTO_INCREMENT=1706 DEFAULT CHARSET=latin1;

create index codigo_usuario_pk1
    on gtsys_logusuario (id_usuario);

