"  id INTEGER PRIMARY KEY NOT NULL,"

					"  jid varchar(255) NOT NULL,"

					"  uin varchar(4095) NOT NULL,"

					"  password varchar(255) NOT NULL,"

					"  language varchar(25) NOT NULL,"

					"  encoding varchar(50) NOT NULL DEFAULT 'utf8',"

					"  last_login datetime,"

					"  vip int(1) NOT NULL DEFAULT '0',"

					"  online int(1) NOT NULL DEFAULT '0'"

					");");

		exec("CREATE UNIQUE INDEX IF NOT EXISTS jid ON " + m_prefix + "users (jid);");

		exec("CREATE TABLE " + m_prefix + "users_settings ("

					"  user_id int(10) NOT NULL,"

					"  var varchar(50) NOT NULL,"

					"  type int(4) NOT NULL,"

					"  value varchar(4095) NOT NULL,"

					"  PRIMARY KEY (user_id, var)"

					");");

		exec("CREATE INDEX IF NOT EXISTS user_id03 ON " + m_prefix + "users_settings (user_id);");

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

			"  ver INTEGER NOT NULL DEFAULT '3'"

			");");

		exec("REPLACE INTO " + m_prefix + "db_version (ver) values(3)");

	}

	return true;

}

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

	char *errMsg = 0;

	int rc = sqlite3_exec(m_db, query.c_str(), NULL, 0, &errMsg);

	if (rc != SQLITE_OK) {

		// This error is OK, because we try to create buddies table every time

		// to detect if DB is created properly.

		if (errMsg && std::string(errMsg).find("table buddies already exists") == std::string::npos) {

			LOG4CXX_ERROR(logger, errMsg << " during statement " << query);

		}

		sqlite3_free(errMsg);

		return false;

	}

	return true;

}

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

	sqlite3_reset(m_setUser);

	sqlite3_bind_text(m_setUser, 2, user.jid.c_str(), -1, SQLITE_STATIC);

	sqlite3_bind_text(m_setUser, 3, user.uin.c_str(), -1, SQLITE_STATIC);

	sqlite3_bind_text(m_setUser, 4, user.password.c_str(), -1, SQLITE_STATIC);

	sqlite3_bind_text(m_setUser, 5, user.language.c_str(), -1, SQLITE_STATIC);

	sqlite3_bind_text(m_setUser, 6, user.encoding.c_str(), -1, SQLITE_STATIC);

	sqlite3_bind_int (m_setUser, 7, user.vip);

	if(sqlite3_step(m_setUser) != SQLITE_DONE) {

		LOG4CXX_ERROR(logger, "setUser query"<< (sqlite3_errmsg(m_db) == NULL ? "" : sqlite3_errmsg(m_db)));

	}

}

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

// 	SELECT id, jid, uin, password, encoding, language, vip FROM " + m_prefix + "users WHERE jid=?

	sqlite3_reset(m_getUser);

	sqlite3_bind_text(m_getUser, 1, barejid.c_str(), -1, SQLITE_TRANSIENT);

	int ret;

	while((ret = sqlite3_step(m_getUser)) == SQLITE_ROW) {

		user.id = sqlite3_column_int(m_getUser, 0);

		user.jid = (const char *) sqlite3_column_text(m_getUser, 1);

		user.uin = (const char *) sqlite3_column_text(m_getUser, 2);

		user.password = (const char *) sqlite3_column_text(m_getUser, 3);

		user.encoding = (const char *) sqlite3_column_text(m_getUser, 4);

		user.language = (const char *) sqlite3_column_text(m_getUser, 5);

		user.vip = sqlite3_column_int(m_getUser, 6) != 0;

		while((ret = sqlite3_step(m_getUser)) == SQLITE_ROW) {

		}

		return true;

	}

	if (ret != SQLITE_DONE) {

		LOG4CXX_ERROR(logger, "getUser query"<< (sqlite3_errmsg(m_db) == NULL ? "" : sqlite3_errmsg(m_db)));

	}

	return false;

}

void SQLite3Backend::setUserOnline(long id, bool online) {

	BEGIN(m_setUserOnline);

	BIND_INT(m_setUserOnline, (int)online);

	BIND_INT(m_setUserOnline, id);

	EXECUTE_STATEMENT(m_setUserOnline, "setUserOnline query");

}

bool SQLite3Backend::getOnlineUsers(std::vector<std::string> &users) {

	sqlite3_reset(m_getOnlineUsers);