PRAGMA foreign_keys=OFF;
BEGIN TRANSACTION;
CREATE TABLE settings (
            name TEXT UNIQUE,
            settings TEXT
    );
INSERT INTO settings VALUES('app','{}');
INSERT INTO settings VALUES('soundevents','{}');
INSERT INTO settings VALUES('status_presets','{"Sleeping": {"message": "ZZZZzzzzzZZZZZ", "activity": "inactive", "subactivity": "sleeping", "mood": "sleepy"}, "Back soon": {"message": "Back in some minutes."}, "Eating": {"message": "I\u2019m eating.", "activity": "eating", "subactivity": "other"}, "Movie": {"message": "I\u2019m watching a movie.", "activity": "relaxing", "subactivity": "watching_a_movie"}, "Working": {"message": "I\u2019m working.", "activity": "working", "subactivity": "other"}, "Out": {"message": "I\u2019m out enjoying life.", "activity": "relaxing", "subactivity": "going_out"}}');
INSERT INTO settings VALUES('proxies','{"Tor": {"type": "socks5", "host": "localhost", "port": 9050}}');
INSERT INTO settings VALUES('plugins','{"omemo": {"active": true}, "pgp": {"active": true}}');
CREATE TABLE account_settings (
            account TEXT UNIQUE,
            settings TEXT
    );
INSERT INTO account_settings VALUES('member.fsf.org','{"account": {"active": true, "name": "pehjota", "resource": "gajim.BPUIG4D6", "account_label": "pehjota@member.fsf.org", "account_color": "rgb(132,154,51)", "hostname": "member.fsf.org", "savepass": true, "anonymous_auth": false, "autoconnect": true, "sync_with_global_status": true, "use_custom_host": false, "password": "", "last_status": "online", "last_status_msg": ""}, "contact": {}, "group_chat": {}}');
COMMIT;