From 3d772413a194c5b33d4202285d46b285920c475b Mon Sep 17 00:00:00 2001
From: Alexander Sulfrian <alexander@sulfrian.net>
Date: Wed, 7 Dec 2011 19:08:06 +0100
Subject: modified sql statements to work with postgresql

---
 sql/perm_delete_by_serverid.sql | 6 +++---
 1 file changed, 3 insertions(+), 3 deletions(-)

(limited to 'sql/perm_delete_by_serverid.sql')

diff --git a/sql/perm_delete_by_serverid.sql b/sql/perm_delete_by_serverid.sql
index 49ffaed..ae52b55 100644
--- a/sql/perm_delete_by_serverid.sql
+++ b/sql/perm_delete_by_serverid.sql
@@ -8,6 +8,6 @@ delete from group_server_to_client where server_id = :server_id:;
 delete from groups_channel where server_id = :server_id:;
 delete from groups_server where server_id = :server_id:;
 delete from tokens where server_id = :server_id:;
-update client_properties set value = 0 where ident= "client_icon_id" and server_id= :server_id:;
-update channel_properties set value = 0 where ident= "channel_icon_id" and server_id= :server_id:;
-update server_properties set value = 0 where ident= "virtualserver_icon_id" and server_id= :server_id:;
\ No newline at end of file
+update client_properties set value = 0 where ident= 'client_icon_id' and server_id= :server_id:;
+update channel_properties set value = 0 where ident= 'channel_icon_id' and server_id= :server_id:;
+update server_properties set value = 0 where ident= 'virtualserver_icon_id' and server_id= :server_id:;
\ No newline at end of file
-- 
cgit v1.2.3

