"`uin` varchar(255) collate utf8_bin NOT NULL,"

							"`subscription` enum('to','from','both','ask','none') collate utf8_bin NOT NULL,"

							"`nickname` varchar(255) collate utf8_bin NOT NULL,"

							"`groups` varchar(255) collate utf8_bin NOT NULL,"

							"`flags` smallint(4) NOT NULL DEFAULT '0',"

							"PRIMARY KEY (`id`),"

							"UNIQUE KEY `user_id` (`user_id`,`uin`)"

						") ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;");

	if (not_exist) {

		exec("CREATE TABLE IF NOT EXISTS `" + m_prefix + "buddies_settings` ("

				"`user_id` int(10) unsigned NOT NULL,"

				"`buddy_id` int(10) unsigned NOT NULL,"

				"`var` varchar(50) collate utf8_bin NOT NULL,"

				"`type` smallint(4) unsigned NOT NULL,"

				"`value` varchar(255) collate utf8_bin NOT NULL,"

				"PRIMARY KEY (`buddy_id`,`var`),"

				"KEY `user_id` (`user_id`)"

			") ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;");

		exec("CREATE TABLE IF NOT EXISTS `" + m_prefix + "users` ("

				"`id` int(10) unsigned NOT NULL auto_increment,"

				"`jid` varchar(255) collate utf8_bin NOT NULL,"

				"`uin` varchar(4095) collate utf8_bin NOT NULL,"

				"`password` varchar(255) collate utf8_bin NOT NULL,"

				"`language` varchar(25) collate utf8_bin NOT NULL,"

				"`encoding` varchar(50) collate utf8_bin NOT NULL default 'utf8',"

				"`last_login` datetime,"

				"`vip` tinyint(1) NOT NULL  default '0',"

				"`online` tinyint(1) NOT NULL  default '0',"

				"PRIMARY KEY (`id`),"

				"UNIQUE KEY `jid` (`jid`)"

			") ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;");

		exec("CREATE TABLE IF NOT EXISTS `" + m_prefix + "users_settings` ("

				"`user_id` int(10) unsigned NOT NULL,"

				"`var` varchar(50) collate utf8_bin NOT NULL,"

				"`type` smallint(4) unsigned NOT NULL,"

				"`value` varchar(255) collate utf8_bin NOT NULL,"

				"PRIMARY KEY (`user_id`,`var`),"

				"KEY `user_id` (`user_id`)"

			") ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;");

		exec("CREATE TABLE IF NOT EXISTS `" + m_prefix + "db_version` ("

				"`ver` int(10) unsigned NOT NULL default '1',"

				"UNIQUE KEY `ver` (`ver`)"

			") ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;");

	}

	return true;

}

bool MySQLBackend::exec(const std::string &query) {

	if (mysql_query(&m_conn, query.c_str())) {

		LOG4CXX_ERROR(logger, query << " " << mysql_error(&m_conn));

		return false;

	}

	return true;

}

void MySQLBackend::setUser(const UserInfo &user) {

	std::string encrypted = user.password;

	if (!CONFIG_STRING(m_config, "database.encryption_key").empty()) {

		encrypted = StorageBackend::encryptPassword(encrypted, CONFIG_STRING(m_config, "database.encryption_key"));

	}

	*m_setUser << user.jid << user.uin << encrypted << user.language << user.encoding << user.vip << user.uin << encrypted;

	EXEC(m_setUser, setUser(user));

}

bool MySQLBackend::getUser(const std::string &barejid, UserInfo &user) {

	*m_getUser << barejid;

	EXEC(m_getUser, getUser(barejid, user));

	if (!exec_ok)

		return false;

	int ret = false;

	while (m_getUser->fetch() == 0) {

		ret = true;

		*m_getUser >> user.id >> user.jid >> user.uin >> user.password >> user.encoding >> user.language >> user.vip;

		if (!CONFIG_STRING(m_config, "database.encryption_key").empty()) {

			user.password = StorageBackend::decryptPassword(user.password, CONFIG_STRING(m_config, "database.encryption_key"));

		}

	}

	if (!CONFIG_STRING(m_config, "database.vip_statement").empty()) {

		std::string query = CONFIG_STRING(m_config, "database.vip_statement");

		boost::replace_all(query, "$barejid", barejid);

		LOG4CXX_INFO(logger, "Executing '" << query << "' to find out if user " << barejid << " is VIP");

		if (exec(query)) {

			MYSQL_RES *result = mysql_store_result(&m_conn);

			if (result && mysql_num_rows(result) > 0) {

				LOG4CXX_INFO(logger, "User " << barejid << " is VIP");

				user.vip = 1;

			}