Revision control
Copy as Markdown
SQLite format 3 @
.↩ø h É H8 ¬)hì ))=tableloginsSyncMetaloginsSyncMeta CREATE TABLE loginsSyncMeta (
key TEXT PRIMARY KEY,
value NOT NULL
); O) indexsqlite_autoindex_loginsSyncMeta_1loginsSyncMeta
G+indexidx_loginsL_is_deleted_originloginsLCREATE INDEX idx_loginsL_is_deleted_origin
ON loginsL (is_deleted, origin)
M7indexidx_loginsM_is_overridden_originloginsMCREATE INDEX idx_loginsM_is_overridden_origin
ON loginsM (is_overridden, origin)
^tableloginsMloginsMCREATE TABLE loginsM (
id INTEGER PRIMARY KEY AUTOINCREMENT,
origin TEXT NOT NULL,
-- Exactly one of httpRealm or formActionOrigin should be set
httpRealm TEXT,
formActionOrigin TEXT,
usernameField TEXT,
passwordField TEXT,
timesUsed INTEGER NOT NULL DEFAULT 0,
timeCreated INTEGER NOT NULL,
timeLastUsed INTEGER,
timePasswordChanged INTEGER NOT NULL,
secFields TEXT,
guid TEXT NOT NULL UNIQUE
,
-- Milliseconds (a sync15::ServerTimestamp multiplied by
-- 1000 and truncated)
server_modified INTEGER NOT NULL,
is_overridden TINYINT NOT NULL DEFAULT 0,
-- fields on incoming records we don't know about and roundtrip.
-- a serde_json::Value::Object as an encrypted string.
enc_unknown_fields TEXT
)-A indexsqlite_autoindex_loginsM_1loginsMP++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq),/tableloginsLloginsLCREATE TABLE loginsL (
id INTEGER PRIMARY KEY AUTOINCREMENT,
origin TEXT NOT NULL,
-- Exactly one of httpRealm or formActionOrigin should be set
httpRealm TEXT,
formActionOrigin TEXT,
usernameField TEXT,
passwordField TEXT,
timesUsed INTEGER NOT NULL DEFAULT 0,
timeCreated INTEGER NOT NULL,
timeLastUsed INTEGER,
timePasswordChanged INTEGER NOT NULL,
secFields TEXT,
guid TEXT NOT NULL UNIQUE
,
-- Milliseconds, or NULL if never modified locally.
local_modified INTEGER,
is_deleted TINYINT NOT NULL DEFAULT 0,
sync_status TINYINT NOT NULL DEFAULT 0
)-A indexsqlite_autoindex_loginsL_1loginsL ↩ d ; ; m%https://www.example.comhttps://www.example.comusernamepasswordññ ññ ññ eyJhbGciOiJkaXIiLCJlbmMiOiJBMjU2R0NNIn0.._4jC4_1ZgkVLeCzZ._N-HAaCrpvjQYeEtYILBFrlRY7yp-6o.HhvuwNYzjmX2RHoJUVow_wsDvTVvE8vtz9ññ
ð ð % sDvTVvE8vtz9↩ ô ô
loginsL↩