contentpublishingsrv/contentpublishingserver/cpsqlitestorage/inc/cpssqlconstants.h
--- a/contentpublishingsrv/contentpublishingserver/cpsqlitestorage/inc/cpssqlconstants.h Mon May 03 12:48:45 2010 +0300
+++ /dev/null Thu Jan 01 00:00:00 1970 +0000
@@ -1,64 +0,0 @@
-/*
-* Copyright (c) 2008 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 C_CPSSQLCONSTS_H
-#define C_CPSSQLCONSTS_H
-#ifdef CONTENT_PUBLISHER_STORAGE_MT
-_LIT( KCPpathdatabase, "c:\\cpdatastorage.sq" );
-#endif
-
-_LIT( KCPdatabase, "[20016B7B]cpdatastorage.sq" );
-_LIT( KCPdatabaseDrive, "C:" );
-_LIT8( KMdsSqlDbaConfig,
- "cache_size=10000; page_size=4096; encoding=\"UTF-8\";" );
-
-//Create Tables
-_LIT( KSQLCreateMainTable,
- "CREATE TABLE CP_MAIN_TABLE( Id INTEGER PRIMARY KEY ,\
- Publisher TEXT NOT NULL,\
- Content_type TEXT NOT NULL,\
- Content_id TEXT NOT NULL,\
- Expiration_date BIGINT NOT NULL,\
- Access_List BLOB,\
- Data BLOB, \
- Action BLOB, \
- UNIQUE( Publisher, Content_type, Content_id ));" );
-
-_LIT( KSQLCreatePublisherTable,
- "CREATE TABLE CP_PUBLISHER_TABLE( Id INTEGER PRIMARY KEY ,\
- Publisher TEXT NOT NULL,\
- Content_type TEXT NOT NULL,\
- Content_id TEXT NOT NULL, \
- Flag INTEGER NOT NULL, \
- Access_List BLOB,\
- Data BLOB, \
- Action BLOB, \
- UNIQUE( Publisher, Content_type, Content_id ));" );
-
-//Create Indexes
-_LIT( KSQLIndexOnMain_Publisher,
- "CREATE INDEX Main_PublisherIndex ON CP_MAIN_TABLE(Publisher);" );
-_LIT( KSQLIndexOnMain_Content_type,
- "CREATE INDEX Main_Content_typeIndex ON CP_MAIN_TABLE(Content_type);" );
-
-_LIT( KSQLIndexOnPub_Content_type,
- "CREATE INDEX Pub_Content_typeIndex ON CP_PUBLISHER_TABLE(Content_type);" );
-_LIT( KSQLIndexOnPub_Content_type_Content_id,
- "CREATE INDEX Pub_Content_type_Content_Id_Index ON CP_PUBLISHER_TABLE(Content_type,Content_id);" );
-
-#endif //C_CPSSQLCONSTS_H