diff -r 6369bfd1b60d -r 08b5eae9f9ff upnpharvester/common/cmsqlwrapper/inc/cmsqlmaintenanceclauses.h
--- a/upnpharvester/common/cmsqlwrapper/inc/cmsqlmaintenanceclauses.h	Mon Nov 01 13:44:24 2010 +0200
+++ /dev/null	Thu Jan 01 00:00:00 1970 +0000
@@ -1,233 +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:      Includes SQL clauses for creating and dropping tables/indexes
-*
-*/
-
-
-
-
-
-
-#ifndef __CMSQLMAINTENANCECLAUSES_H__
-#define __CMSQLMAINTENANCECLAUSES_H__
-
-///////////////////////////////////////////////////////////////////
-// DROP CLAUSES
-///////////////////////////////////////////////////////////////////
-_LIT8( KCmSqlDropArtists, "DROP TABLE Artists;");
-_LIT8( KCmSqlDropGenres, "DROP TABLE Genres;" );
-_LIT8( KCmSqlDropAlbums, "DROP TABLE Albums;" );
-_LIT8( KCmSqlDropUpnpProfiles, "DROP TABLE UpnpProfiles;" );
-_LIT8( KCmSqlDropUpnpClasses, "DROP TABLE Upnpclasses;" );
-_LIT8( KCmSqlDropResolutions, "DROP TABLE Resolutions;" );
-_LIT8( KCmSqlDropResources, "DROP TABLE Resources;" );
-_LIT8( KCmSqlDropItems, "DROP TABLE Items;" );
-
-///////////////////////////////////////////////////////////////////
-// CREATE CLAUSES FOR TABLES
-///////////////////////////////////////////////////////////////////
-_LIT8( KCmSqlCreateArtists, 
-    "CREATE TABLE Artists("
-        "ArtistId           INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,"
-        "Value              TEXT NOT NULL UNIQUE);"
-        );
-
-_LIT8( KCmSqlCreateGenres, 
-    "CREATE TABLE Genres("
-        "GenreId           INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,"
-        "Value             TEXT NOT NULL UNIQUE);"
-        );
-        
-_LIT8( KCmSqlCreateAlbums, 
-    "CREATE TABLE Albums("
-        "AlbumId           INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,"
-        "Value             TEXT NOT NULL UNIQUE);"
-        );
-
-_LIT8( KCmSqlCreateResolutions, 
-    "CREATE TABLE Resolutions("
-        "ResolutionId       INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,"
-        "Value              TEXT NOT NULL UNIQUE,"
-        "Width              INTEGER,"
-        "Height             INTEGER,"
-        "PixelCount         INTEGER);"
-        );
-            
-_LIT8( KCmSqlCreateUpnpclasses, 
-    "CREATE TABLE Upnpclasses("
-        "UpnpclassId        INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,"
-        "Value              TEXT NOT NULL UNIQUE);"
-        );            
-        
-_LIT8( KCmSqlCreateUpnpProfiles, 
-    "CREATE TABLE UpnpProfiles("
-        "ProfileId          INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,"
-        "Value              TEXT NOT NULL UNIQUE);"
-        );                         
-        
-_LIT8( KCmSqlCreateResources, 
-    "CREATE TABLE Resources("
-        "ResourceId       INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,"
-        "ResItemId        INTEGER NOT NULL REFERENCES Items( Id ),"
-        "ResResolution    INTEGER REFERENCES Resolutions( ResolutionId ),"
-        "ResUri           TEXT NOT NULL,"
-        "Size             INTEGER,"
-        "ResDuration      INTEGER,"
-        "ResBitrate       INTEGER);"
-        );
-
-_LIT8( KCmSqlCreateItems, 
-    "CREATE TABLE Items("
-        "Id                 INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,"
-        "ItemId             TEXT NOT NULL,"
-        "Hash               TEXT NOT NULL,"
-        "Uri                TEXT NOT NULL,"
-        "Title              TEXT NOT NULL,"
-        "AlbumArtUri        TEXT,"
-        "DeviceId           INTEGER NOT NULL,"
-        "Duration           INTEGER,"
-        "Bitrate            INTEGER,"
-        "Date               DATETIME,"
-        "HarvestDate        DATETIME,"
-        "Size               INTEGER,"
-        "Mediatype          INTEGER,"
-        "SearchId           INTEGER,"
-        "UpnpclassId        INTEGER REFERENCES Upnpclasses( UpnpclassId ),"
-        "ArtistId           INTEGER REFERENCES Artists( ArtistId ),"
-        "AlbumId            INTEGER REFERENCES Albums( AlbumId ),"
-        "GenreId            INTEGER REFERENCES Genres( GenreId ),"
-        "ProfileId          INTEGER REFERENCES UpnpProfiles( ProfileId ),"
-        "ResolutionId       INTEGER REFERENCES Resolutions( ResolutionId ) );"
-        );
-                
-///////////////////////////////////////////////////////////////////
-// INDEXES
-///////////////////////////////////////////////////////////////////
-_LIT8( KCmSqlCreateItemsIdIndex, 
-    "CREATE INDEX ItemsId_Index ON Items(Id);"
-    );
-
-_LIT8( KCmSqlCreateItemTitleIndex, 
-    "CREATE INDEX Item_Title_Index ON Items(Title);"
-    );
-    
-_LIT8( KCmSqlCreateItemDateIndex, 
-    "CREATE INDEX Item_Date_Index ON Items(Date);"
-    );        
-
-_LIT8( KCmSqlCreateItemHarvestDateIndex, 
-    "CREATE INDEX Item_HarvestDate_Index ON Items(HarvestDate);"
-    ); 
-    
-_LIT8( KCmSqlCreateItemArtistIndex, 
-    "CREATE INDEX Item_Artist_Index ON Items(ArtistId);"
-    );
-
-_LIT8( KCmSqlCreateItemAlbumIndex, 
-    "CREATE INDEX Item_Album_Index ON Items(AlbumId);"
-    );
-    
-_LIT8( KCmSqlCreateItemGenreIndex, 
-    "CREATE INDEX Item_Genre_Index ON Items(GenreId);"
-    );
-    
-_LIT8( KCmSqlCreateItemUpnpclassIndex, 
-    "CREATE INDEX Item_Upnpclass_Index ON Items(UpnpclassId);"
-    );
-
-_LIT8( KCmSqlCreateItemUpnpProfileIndex, 
-    "CREATE INDEX Item_UpnpProfile_Index ON Items(ProfileId);"
-    );                         
-
-_LIT8( KCmSqlCreateItemResolutionIndex, 
-    "CREATE INDEX Item_Resolution_Index ON Items(ResolutionId);"
-    );
-
-_LIT8( KCmSqlCreateItemMediatypeIndex, 
-    "CREATE INDEX Item_Mediatype_Index ON Items(Mediatype);" 
-    );
-
-_LIT8( KCmSqlCreateAlbumIdIndex,
-    "CREATE INDEX AlbumId_Index ON Albums(AlbumId);" 
-    );
-
-_LIT8( KCmSqlCreateArtistIdIndex,
-    "CREATE INDEX ArtistId_Index ON Artists(ArtistId);" 
-    ); 
-
-_LIT8( KCmSqlCreateGenreIdIndex,
-    "CREATE INDEX GenreId_Index ON Genres(GenreId);" 
-    );
-        
-// Dropping indexes
-_LIT8( KCmSqlDropItemsIdIndex, 
-    "DROP INDEX ItemsId_Index;"
-    );
-
-_LIT8( KCmSqlDropItemTitleIndex,
-    "DROP INDEX Item_Title_Index;"
-    );
-    
-_LIT8( KCmSqlDropItemDateIndex,
-    "DROP INDEX Item_Date_Index;"
-    ); 
-    
-_LIT8( KCmSqlDropItemHarvestDateIndex,
-    "DROP INDEX Item_HarvestDate_Index;"
-    );             
-
-_LIT8( KCmSqlDropItemArtistIndex, 
-    "DROP INDEX Item_Artist_Index;"
-    ); 
-
-_LIT8( KCmSqlDropItemAlbumIndex, 
-    "DROP INDEX Item_Album_Index;"
-    );                
-
-_LIT8( KCmSqlDropItemGenreIndex, 
-    "DROP INDEX Item_Genre_Index;"
-    ); 
-    
-_LIT8( KCmSqlDropItemUpnpclassIndex, 
-    "DROP INDEX Item_Upnpclass_Index;"
-    );
-    
-_LIT8( KCmSqlDropItemUpnpProfileIndex, 
-    "DROP INDEX Item_UpnpProfile_Index;"
-    );                 
-
-_LIT8( KCmSqlDropItemResolutionIndex, 
-    "DROP INDEX Item_Resolution_Index;"
-    );
-
-_LIT8( KCmSqlDropItemMediatypeIndex, 
-    "DROP INDEX Item_Mediatype_Index;" 
-    );
-
-_LIT8( KCmSqlDropAlbumIdIndex,
-    "DROP INDEX AlbumId_Index;" 
-    );
-
-_LIT8( KCmSqlDropArtistIdIndex,
-    "DROP INDEX ArtistId_Index;" 
-    ); 
-
-_LIT8( KCmSqlDropGenreIdIndex,
-    "DROP INDEX GenreId_Index;" 
-    );
-                                                                            
-#endif // __CMSQLMAINTENANCECLAUSES_H__
-
-