CREATE TABLE IF NOT EXISTS user_metadata
(
    username            TEXT NOT NULL,
    name            TEXT NOT NULL,
    value           TEXT NOT NULL
);

CREATE UNIQUE INDEX unique_per_user_metadata ON user_metadata (username, name);

CREATE TABLE IF NOT EXISTS user_settings
(
    username            TEXT NOT NULL,
    name            TEXT NOT NULL,
    value           TEXT NOT NULL
);

CREATE UNIQUE INDEX unique_per_user_settings ON user_settings (username, name);