SQLite format 3@ - |~}}j} |i)indexprefs_idxprefsCREATE INDEX prefs_idx ON prefs (timestamp, groupID, settingID) \%indexsettings_idxsettingsCREATE INDEX settings_idx ON settings (name) S!{indexgroups_idxgroupsCREATE INDEX groups_idx ON groups (name) 7MtableprefsprefsCREATE TABLE prefs (id INTEGER PRIMARY KEY, groupID INTEGER REFERENCES groups(id), settingID INTEGER NOT NULL REFERENCES settings(id), value BLOB, timestamp INTEGER NOT NULL DEFAULT 0)[tablesettingssettingsCREATE TABLE settings (id INTEGER PRIMARY KEY, name TEXT NOT NULL)~WtablegroupsgroupsCREATE TABLE groups (id INTEGER PRIMARY KEY, name TEXT NOT NULL)