SQLite format 3@  iMsindexprefs_idxprefsCREATE INDEX prefs_idx ON prefs(groupID, settingID)K%cindexsettings_idxsettingsCREATE INDEX settings_idx ON settings(name)C![indexgroups_idxgroupsCREATE INDEX groups_idx ON groups(name){UtableprefsprefsCREATE TABLE prefs (id INTEGER PRIMARY KEY, groupID INTEGER REFERENCES groups(id), settingID INTEGER NOT NULL REFERENCES settings(id), value BLOB)[tablesettingssettingsCREATE TABLE settings (id INTEGER PRIMARY KEY, name TEXT NOT NULL)~WtablegroupsgroupsCREATE TABLE groups (id INTEGER PRIMARY KEY, name TEXT NOT NULL)