[][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.