[−][src]Constant logins::schema::COMMON_COLS
pub const COMMON_COLS: &str = " guid, username, password, hostname, httpRealm, formSubmitURL, usernameField, passwordField, timeCreated, timeLastUsed, timePasswordChanged, timesUsed ";
Every column shared by both tables except for id
Note: timeCreated
, timeLastUsed
, and timePasswordChanged
are in
milliseconds. This is in line with how the server and Desktop handle it, but
counter to how firefox-ios handles it (hence needing to fix them up
firefox-ios on schema upgrade from 3, the last firefox-ios password schema
version).
The reason for breaking from how firefox-ios does things is just because it complicates the code to have multiple kinds of timestamps, for very little benefit. It also makes it unclear what's stored on the server, leading to further confusion.
However, note that the local_modified
(of loginsL
) and server_modified
(of loginsM
) are stored as milliseconds as well both on firefox-ios and
here (and so they do not need to be updated with the timeLastUsed
/
timePasswordChanged
/timeCreated
timestamps.