--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/searchsrv_plat/cpix_utility_api/inc/contentinfodbcommon.h	Tue Oct 05 13:15:12 2010 +0530
@@ -0,0 +1,111 @@
+/*
+ * 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 queries, tagname,macros.
+ *
+ */
+
+#ifndef CONTENTINFODBCOMMON_H_
+#define CONTENTINFODBCOMMON_H_
+
+#ifndef CONTENTINFODB_UNITTESTING
+#define CONTENTINFODB_CLASS(aClassName)
+#else
+#define CONTENTINFODB_CLASS(aClassName) class aClassName;
+#endif 
+
+#ifndef CONTENTINFODB_UNITTESTING
+#define CONTENTINFODB_FRIEND_CLASS(aClassName)
+#else
+#define CONTENTINFODB_FRIEND_CLASS(aClassName) friend class aClassName;
+#endif 
+
+#ifdef BUILD_CONTENTINFODB
+#define DECL_CONTENTINFODB Q_DECL_EXPORT
+#else
+#define DECL_CONTENTINFODB Q_DECL_IMPORT
+#endif
+
+//sql queries
+// sql query to create a master table
+#define QUERYCREATEMAINTABLE "create table maintable (name varchar(50) primary key,ins int default '0', bls int default '0',actionuri varchar(20),licon varchar(50),baseapp varchar(50),lname varchar(50),displayorder varchar(10),exceptionstring varchar(50),tsfile varchar(50),fieldmap varchar(20),indexcontentsize varchar(5),relevancy varchar(20),policy varchar(50),resultfirstline varchar(20))"
+
+// sql query to insert row into the mentioned table
+#define QUERYINSERTROW "INSERT INTO %1 (%2) values('%3')"
+
+//sql query to update the value on mentioned table and field
+#define QUERYUPDATEDATA "UPDATE %1 SET %2='%3' WHERE %4='%5'"
+
+//sql query to create activity uri table
+#define QUERYCREATEACTIONURITABLE "create table %1 (uristring varchar(300) primary key,licon varchar(50),lname varchar(50),uriref varchar(20),action varchar(20))"
+
+//sql query to create field map table
+#define QUERYCREATEFIELDMAPTABLE "create table %1 (field varchar(300) primary key,urilist varchar(50))"
+
+//sql query to create a table for field map values
+#define QUERYCREATEFIELDMAPSUBTABLE "create table %1 (auri varchar(20) primary key)"
+
+//sql query to create a table for firstline information
+#define QUERYCREATEFIRSTLINETABLE "create table %1 (field varchar(50) primary key)"
+
+//sql query to create a table for relevancy information
+#define QUERYCREATERELEVANCYTABLE "create table %1 (field varchar(50) primary key,boostvalue varchar(20))"
+
+#define QUERYDATARETRIVAL "SELECT %1 FROM %2 WHERE %3 ='%4'"
+
+#define QUERYPRIMARYKEYS "SELECT DISTINCT %1 FROM %2"
+
+#define QUERYFILTERDATA "SELECT %1 FROM %2 WHERE %3 LIKE '%%4%'"
+
+#define QUERYSORT "SELECT name FROM maintable ORDER BY displayorder"
+
+#define QUERYDELETE "DELETE FROM maintable WHERE name ='%1'"
+
+#define QUERYCOUNT "SELECT COUNT(*) FROM maintable"
+
+// Database info
+// master table name
+#define MAINTABLENAME "maintable"
+
+// connection name 
+#define CONNECTIONNAME "contentinfodb"
+
+//database type
+#define DATABASETYPE "QSQLITE"
+
+//path of contentinfo db
+#define DBNAME "c:\\private\\2001f6fb\\contentinfo.sq"
+
+//dynamic table creation
+#define DYNAMICTABLE "table%1"
+
+// xml tag name
+#define TAGPRIMARYKEY "name"
+#define TAGACTIONURI "actionuri"
+#define TAGACTIONURISTRING "uristring"
+#define TAGFIELDMAP "fieldmap"
+#define TAGRELEVANCY "relevancy"
+#define TAGFIELD "field"
+#define TAGURILIST "urilist"
+#define TAGAURI "auri" 
+#define TAGRESULTFIRSTLINE "resultfirstline"
+#define TAGBOOSTVALUE "boostvalue"
+#define TAGACTION "action"
+#define TAGLNAME "lname"
+#define TAGLICON "licon"
+#define TAGURIREF "uriref"
+
+#define PRIMARYVALUE "primary"
+#define SECONDARYVALUE "secondary"
+
+#endif /* CONTENTINFODBCOMMON_H_ */