/*

ok juliana.santos@drogafonte.com.br = juliana@2018 $2y$10$RsqeXfx7ZWL3Xv39DZzw.u5vtUORbW3OkSb3.gd5O3OvsX71hVYmK
ok aurilene.freire@drogafonte.com.br = aurilene@2018 $2y$10$08g66bqa7u1X8./BV9/59.JhrrH4DRM2JwRUoLmYuyI/wIvLM1K5m
ok ademir.barbosa@drogafonte.com.br  = ademir@2018 $2y$10$PXO1bDKoc43oJKHksAci6u0zkLCEfQpct84Ga/NbYqAJDvZQB6WEy
ok felipe.bezerra@drogafonte.com.br = felipe@2018 $2y$10$hFBQsAGwqX5ybvM/eq5miOzraVBfaSNwdDENqNJzQDF56SPfmQkhm
ok deyse.cecilia@drogafonte.com.br = deyse@2018 $2y$10$4ZIMljaPxaZFN39FA/PCf.ba62YypUpmGFCeO3CJm8r1FURb/w5w6
ok clebson.dantas@drogafonte.com.br = clebson@2018 $2y$10$2svXgKqf9QHjMTUMWizMs.EIe5mVspByx8/5oNdSnih4gG7F5wwEO
ok millane.monteiro@drogafonte.com.br = m1ll@n3@2018  $2y$10$i3ZbbEfxdRRdY3dyr4dSeOXtUbfBQ5u7j8wr.8A.D7uWOmhdIQrh.

ok jessica.nascimento@drogafonte.com.br = j3ss1c@@123 $2y$10$37SLVibZ2NMn7PyK79DVVOIqUsGsyw2PYNlUEdGxIhGqPBTSKmvdK
ok ana.kesia@drogafonte.com.br = k3s1@123 $2y$10$EOmpVGPO270jKyynG1o3CuDoSKfNpSCbwiNGcKHXqS4DrSIXqjDpe
ok miria.fernandes@drogafonte.com.br = f3rn@nd3s@123 $2y$10$ODhQ6DXtHXYANP08P2ClGONmwZ5OviyklNvjxxygUTi2sE3.0PUuG
ok matheus.klinsmann@drogafonte.com.br = m@th3us@123 $2y$10$IwXTv0jT0QiLdCXSnxgcvOM45qz5pbeGZa6uOKV7jFTEujm2hUtru
ok lourival.gadelha@drogafonte.com.br = g@d3lh@123 


ok bruno.Monnerat bruno@drogafonte.com.br br.brun0@gt = $2y$10$GQ/tCiUljt6ygVTwSwbJxufbU3zqE9Hoq.4rL5wDE4/6hq/3jw7tG

ok jose.vinicios = v1n1c10s@123



-- cadastro de usuario
-- f@b10@2018

v1n1c10s@123


INSERT INTO `sgdvl`.`usuarios` 
			(`displayname`, `login`, `senha`, `email`, `status`, `idDepartamento`, `cod_vendedor`, `cod_funcionario`, `idfuncao`) 
            VALUES ('Bruno Monnerat', 'bruno.Monnerat', '$2y$10$GQ/tCiUljt6ygVTwSwbJxufbU3zqE9Hoq.4rL5wDE4/6hq/3jw7tG', 'bruno@drogafonte.com.br', 'a', '21', '0', '0', '13');

SELECT * FROM sgdvl.usuarios;


*/

SELECT * FROM sgdvl.departamento;

SELECT * FROM sgdvl.funcaousuario;

SELECT * FROM sgdvl.papeis;

SELECT * FROM sgdvl.modulos;

SELECT * 
FROM permisoes
where idpapel = 24;



SELECT * 
FROM sgdvl.usuariosxpapeis
where
idUsuario = 24;




