From 89602a464810b9c63c1523d9739c7c54ba2438a6 2013-03-22 10:28:03
From: Jan Kaluza <hanzz.k@gmail.com>
Date: 2013-03-22 10:28:03
Subject: [PATCH] Merge pull request #28 from madsl/master

Fix PostgreSQL backend for spectrum
---

diff --git a/src/pqxxbackend.cpp b/src/pqxxbackend.cpp
index 0f76ced98a92fc32ad2c0b6aaa0fefa639523396..73748d0866012e8269e42c1cf95d4b1a217f7abc 100644
--- a/src/pqxxbackend.cpp
+++ b/src/pqxxbackend.cpp
@@ -141,7 +141,7 @@ bool PQXXBackend::createDatabase() {
 				"UNIQUE (ver)"
 			");");
 
- 		exec("INSERT INTO db_version (ver) VALUES ('1');");
+ 		exec("INSERT INTO " + m_prefix + "db_version (ver) VALUES ('1');");
 	}
 
 	return true;
@@ -353,10 +353,10 @@ bool PQXXBackend::getBuddies(long id, std::list<BuddyInfo> &roster) {
 bool PQXXBackend::removeUser(long id) {
 	try {
 		pqxx::nontransaction txn(*m_conn);
-		txn.exec("DELETE FROM " + m_prefix + "users SET id=" + pqxx::to_string(id));
-		txn.exec("DELETE FROM " + m_prefix + "buddies SET user_id=" + pqxx::to_string(id));
-		txn.exec("DELETE FROM " + m_prefix + "user_settings SET user_id=" + pqxx::to_string(id));
-		txn.exec("DELETE FROM " + m_prefix + "buddies_settings SET user_id=" + pqxx::to_string(id));
+		txn.exec("DELETE FROM " + m_prefix + "users WHERE id=" + pqxx::to_string(id));
+		txn.exec("DELETE FROM " + m_prefix + "buddies WHERE user_id=" + pqxx::to_string(id));
+		txn.exec("DELETE FROM " + m_prefix + "users_settings WHERE user_id=" + pqxx::to_string(id));
+		txn.exec("DELETE FROM " + m_prefix + "buddies_settings WHERE user_id=" + pqxx::to_string(id));
 
 		return true;
 	}