"uin varchar(4095) NOT NULL,"

				"password varchar(255) NOT NULL,"

				"language varchar(25) NOT NULL,"

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

				"last_login timestamp,"

				"vip boolean NOT NULL  default 'false',"

				"online boolean NOT NULL  default 'false',"

				"PRIMARY KEY (id),"

				"UNIQUE (jid)"

			");");

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

				"user_id integer NOT NULL,"

				"var varchar(50) NOT NULL,"

				"type smallint NOT NULL,"

				"value varchar(255) NOT NULL,"

				"PRIMARY KEY (user_id,var)"

			");");

		exec("CREATE TABLE " + m_prefix + "db_version ("

				"ver integer NOT NULL default '1',"

				"UNIQUE (ver)"

			");");

	}

	return true;

}

template<typename T>

std::string PQXXBackend::quote(pqxx::nontransaction &txn, const T &t) {

	return "'" + txn.esc(pqxx::to_string(t)) + "'";

}

bool PQXXBackend::exec(const std::string &query, bool show_error) {

	pqxx::nontransaction txn(*m_conn);

	return exec(txn, query, show_error);

}

bool PQXXBackend::exec(pqxx::nontransaction &txn, const std::string &query, bool show_error) {

	try {

		txn.exec(query);

		txn.commit();

	}

	catch (std::exception& e) {

		if (show_error)

			LOG4CXX_ERROR(logger, e.what());

		return false;