v1_passwords

CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v1_passwords`  AS  select `passwords`.`id` AS `id`,`passwords`.`idUser` AS `idUser`,`passwords`.`pass` AS `pass` from `passwords` where `passwords`.`id` in (select max(`passwords`.`id`) from `passwords` group by `passwords`.`idUser`) ;