Data in login info looks spurious
This page is a capture in the next bucket of the product backlog — a pre-sprint idea, not yet pulled into a sprint as a story.
We see stuff like this:
oresdb=> select * from login_info;
account_id | last_ip | last_attempt_ip | failed_logins | locked | last_login | online
--------------------------------------+-----------------+-----------------+---------------+--------+------------------------+--------
019a4439-be9e-798e-bf2f-927ca236f84c | 0.0.0.0 | 0.0.0.0 | 0 | 0 | 1969-12-31 23:00:00+01 | 0
019a3ba6-bd11-709b-b93d-fea9403d3d39 | 127.0.0.1 | 127.0.0.1 | 0 | 0 | 2025-10-31 19:03:48+00 | 1
019a4431-98f8-79ae-9fc8-f6a6e77a0490 | 192.168.1.100 | 192.168.1.100 | 0 | 0 | 2025-11-02 10:51:32+00 | 1
019a4431-9a7d-7b3d-a1cb-b9e02d44c804 | 0.0.0.0 | 192.168.1.100 | 1 | 0 | 1969-12-31 23:00:00+01 | 0
Also, we need a login timestamp and a logout timestamp so we can measure session duration.