From 630bee4b67f6c6a417137ed300b8c1f1a28b0acf 2011-12-22 16:28:45
From: HanzZ <hanzz.k@gmail.com>
Date: 2011-12-22 16:28:45
Subject: [PATCH] Removed IF NOT EXISTS clausule

---

diff --git a/src/pqxxbackend.cpp b/src/pqxxbackend.cpp
index 426b8eb9ec027ba572f6124b18aeab9d34734c25..bc28772b4d15ab71fa181c1d8f47206352551819 100644
--- a/src/pqxxbackend.cpp
+++ b/src/pqxxbackend.cpp
@@ -79,7 +79,7 @@ bool PQXXBackend::createDatabase() {
 			");");
 		
 		exec("CREATE TYPE Subscription AS ENUM ('to','from','both','ask','none');");
-		exec("CREATE TABLE IF NOT EXISTS " + m_prefix + "buddies ("
+		exec("CREATE TABLE " + m_prefix + "buddies ("
 							"id SERIAL,"
 							"user_id integer NOT NULL,"
 							"uin varchar(255) NOT NULL,"
@@ -91,7 +91,7 @@ bool PQXXBackend::createDatabase() {
 							"UNIQUE (user_id,uin)"
 						");");
  
-		exec("CREATE TABLE IF NOT EXISTS " + m_prefix + "users ("
+		exec("CREATE TABLE " + m_prefix + "users ("
 				"id SERIAL,"
 				"jid varchar(255) NOT NULL,"
 				"uin varchar(4095) NOT NULL,"
@@ -105,7 +105,7 @@ bool PQXXBackend::createDatabase() {
 				"UNIQUE (jid)"
 			");");
 
-		exec("CREATE TABLE IF NOT EXISTS " + m_prefix + "users_settings ("
+		exec("CREATE TABLE " + m_prefix + "users_settings ("
 				"user_id integer NOT NULL,"
 				"var varchar(50) NOT NULL,"
 				"type smallint NOT NULL,"
@@ -113,7 +113,7 @@ bool PQXXBackend::createDatabase() {
 				"PRIMARY KEY (user_id,var)"
 			");");
 
-		exec("CREATE TABLE IF NOT EXISTS " + m_prefix + "db_version ("
+		exec("CREATE TABLE " + m_prefix + "db_version ("
 				"ver integer NOT NULL default '1',"
 				"UNIQUE (ver)"
 			");");