// Copyright (c) 1999-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:

//

#ifndef __HLPSQLCONSTS_H__

#define __HLPSQLCONSTS_H__

#include <e32std.h>

_LIT(KSQLTopicIdColumn,					"TopicId");

_LIT(KSQLIndexIdColumn,					"IndexId");

_LIT(KSQLTopicTitleColumn,				"TopicTitle");

_LIT(KSQLTopicTextColumn,				"TopicText");

_LIT(KSQLTopicMarkupColumn,				"TopicMarkup");

_LIT(KSQLCategoryColumn,				"Category");

_LIT(KSQLSynonymColumn,					"Synonym");

_LIT(KSQLIndexColumn,					"Index");

_LIT(KSQLContextColumn,					"Context");

_LIT(KSQLCategoryUidColumn,				"CategoryUID");

_LIT(KSQLImageCountColumn,				"ImageCount");

_LIT(KSQLImage0Column,					"Image0");

_LIT(KSQLImage1Column,					"Image1");

_LIT(KSQLImage2Column,					"Image2");

/**

* This next literal, corresponds to the name of the 

* image column in an old-format help file (2 columns). 

*/

_LIT(KSQLImageColumn,					"Image");

_LIT(KSQLTopicByCategoryUIDProlog,		"SELECT TOPICTITLE, TOPICID, CATEGORYUID FROM TOPIC WHERE CATEGORYUID=");

_LIT(KSQLTopicByCategoryProlog,			"SELECT TOPICTITLE, TOPICID, CATEGORYUID FROM TOPIC WHERE CATEGORY=");

_LIT(KSQLCategoryList,					"SELECT TOPICTITLE, TOPICID, CATEGORYUID FROM TOPIC");

_LIT(KSQLTopicSearchProlog,				"SELECT TOPICTITLE, TOPICID, CATEGORY, TOPICTEXT, TOPICMARKUP FROM TOPIC WHERE ");

_LIT(KSQLTopicIdSearchProlog,			"SELECT TOPICTITLE, TOPICID, CATEGORYUID FROM TOPIC WHERE ");

_LIT(KSQLIndexSearch,					"SELECT INDEXID FROM INDEX WHERE INDEX ='");

_LIT(KSQLIndexIdSearch,					"SELECT TOPICID, CATEGORYUID, TOPICTITLE FROM TOPICINDEX WHERE INDEXID=");

_LIT(KSQLContextSearch,					"SELECT CONTEXT, TOPICID, CATEGORYUID FROM CONTEXT WHERE CONTEXT='");

_LIT(KSQLIndexList,						"SELECT INDEX, INDEXID FROM INDEX");

_LIT(KSQLTopicOrderBy,					" ORDER BY TOPICTITLE ASC");

_LIT(KSQLTxtSrchCat,					"*' OR Category LIKE '*");

_LIT(KSQLTxtSrchTopicText,				"*' OR TopicText LIKE '*");

_LIT(KSQLTxtSrchTopicTitle,				"TopicTitle LIKE '*");

_LIT(KSQLTxtSrchSynonym,				"*' OR Synonym LIKE '*");

_LIT(KSQLSingleInvComma,				"'");

_LIT(KSQLLikeOpeningInvComma,			"'*");

_LIT(KSQLLikeClosingInvComma,			"*'");

_LIT(KSQLOrOperator,					" OR ");

_LIT(KSQLEqualOperator,					" = ");

_LIT(KSQLLikeOperator,					" LIKE ");

_LIT(KSQLAndOperator,					" AND ");

#endif