--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/upnpsharing/upnpsecurity/inc/server/upnpsecuritysqlclausedef.h	Thu Dec 17 08:52:00 2009 +0200
@@ -0,0 +1,102 @@
+/** @file
+ * Copyright (c) 2009 Nokia Corporation and/or its subsidiary(-ies). 
+ * All rights reserved.
+ * This component and the accompanying materials are made available
+ * under the terms of "Eclipse Public License v1.0"
+ * which accompanies  this distribution, and is available 
+ * at the URL "http://www.eclipse.org/legal/epl-v10.html".
+ *
+ * Initial Contributors:
+ * Nokia Corporation - initial contribution.
+ *
+ * Contributors:
+ *
+ *  Description : SQL clause definitions
+ *
+ */
+
+#ifndef __UPNPSECSQLCLAUSEDEF_H__
+#define __UPNPSECSQLCLAUSEDEF_H__
+
+// CONSTANTS
+
+///////////////////////////////////////////////////////////////////
+// DROP CLAUSES
+///////////////////////////////////////////////////////////////////
+_LIT8( KUpnpSecSqlDropAddressList, "DROP TABLE IF EXISTS AddressList;");
+_LIT8( KUpnpSecSqlDropFileList, "DROP TABLE IF EXISTS FileList;" );
+
+///////////////////////////////////////////////////////////////////
+// CREATE CLAUSES FOR TABLES
+///////////////////////////////////////////////////////////////////
+_LIT8( KUpnpSecSqlCreateAddressList, 
+    "CREATE TABLE IF NOT EXISTS AddressList("
+        "Ip                 INTEGER PRIMARY KEY);"
+        );
+
+_LIT8( KUpnpSecSqlCreateFileList, 
+    "CREATE TABLE IF NOT EXISTS FileList("
+        "Filename          TEXT PRIMARY KEY);"
+        );
+
+///////////////////////////////////////////////////////////////////
+// INSERT STATEMENTS
+///////////////////////////////////////////////////////////////////
+//
+// Inserting ip address into AddressList table
+_LIT8( KUpnpSecSqlInsertIpAddress,
+    "INSERT INTO AddressList( " 
+    "Ip ) "
+    "VALUES( ? );"
+    );
+// Inserting filename into FileList table
+_LIT8( KUpnpSecSqlInsertFile,
+    "INSERT INTO FileList( " 
+    "Filename ) "
+    "VALUES( ? );"
+    );
+
+///////////////////////////////////////////////////////////////////
+// SELECT STATEMENTS
+///////////////////////////////////////////////////////////////////
+//
+// Select all ip addresses from AddressList table
+_LIT8( KUpnpSecSqlSelectAllIpAddresses,
+    "SELECT Ip FROM AddressList "
+    );
+
+// Select all filenames from FileList table
+_LIT8( KUpnpSecSqlSelectAllFiles, "SELECT Filename FROM FileList " 
+    );
+
+_LIT8( KUpnpSecSqlValidateTableExistence, "SELECT count(*) FROM AddressList, FileList;" );
+
+// ---------------------------------------------------------------------------
+// DELETE STATEMENTS
+// ---------------------------------------------------------------------------
+//
+_LIT8( KUpnpSecSqlDeleteIpAddress, 
+    "DELETE FROM AddressList "
+    "WHERE Ip = ? ;"
+    );
+_LIT8( KUpnpSecSqlDeleteAllIpAddresses, 
+    "DELETE FROM AddressList;"
+    );
+    
+_LIT8( KUpnpSecSqlDeleteFile, 
+    "DELETE FROM FileList "
+    "WHERE Filename = ? ;"
+    );
+_LIT8( KUpnpSecSqlDeleteAllFiles, 
+    "DELETE FROM FileList;"
+    );
+
+///////////////////////////////////////////////////////////////////
+// MISC DEFINITIONS
+///////////////////////////////////////////////////////////////////
+//
+_LIT16( KUpnpSecSqlIp, "Ip" );
+_LIT16( KUpnpSecSqlFilename, "Filename" );
+
+#endif // __UPNPSECSQLCLAUSEDEF_H__
+// End of File