SQLite format 3@ .(k |~}}z}-|Y indexprefs_idxprefsCREATE INDEX prefs_idx ON prefs(timestamp, groupID, settingID)K%cindexsettings_idxsettingsCREATE INDEX settings_idx ON settings(name)C![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)   B&