table structure:
================
    `host` TEXT NULL,
    `user` TEXT NULL,
    `store` TEXT NULL,
    `key` TEXT NULL,
    `type` TEXT NULL,
    `value` MEDIUMTEXT NULL,

$sql = "INSERT INTO prosody (host, user, store, key, type, value) VALUES ('mydomain.tld', $user, 'accounts', 'password', 'string', $pass)";