Vistas para login

 CREATE VIEW v_psw_atual AS

SELECT * FROM psw WHERE idPsw IN(SELECT MAX(idPsw) FROM psw GROUP BY idUsername);

CREATE VIEW v_username_privilegio_atual AS

SELECT * FROM username_privilegio WHERE idUsernamePrivilegio IN(

SELECT MAX(idUsernamePrivilegio) FROM psw GROUP BY idUsername);

CREATE VIEW v_status_username_atual AS

SELECT * FROM status_username WHERE idStatusUsername IN(

 SELECT MAX(idStatusUsername) FROM status_username WHERE status_username=2 GROUP BY idUsername);

CREATE VIEW  v_login AS

SELECT idUsername, psw, idPrivilegio, username FROM username

JOIN v_psw_atual USING (idUsername)

JOIN v_username_privilegio_atual USING (idUsername)

JOIN v_status_username_atual USING (idUsername);