diff -r 6369bfd1b60d -r 08b5eae9f9ff upnpharvester/common/dbmanager/inc/cmdmsqlclausedef.h
--- a/upnpharvester/common/dbmanager/inc/cmdmsqlclausedef.h	Mon Nov 01 13:44:24 2010 +0200
+++ /dev/null	Thu Jan 01 00:00:00 1970 +0000
@@ -1,931 +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:      SQL clause definitions
-*
-*/
-
-
-
-
-
-
-#ifndef __CMDMSQLCLAUSEDEF_H__
-#define __CMDMSQLCLAUSEDEF_H__
-
-// ---------------------------------------------------------------------------
-// SELECT clauses
-// ---------------------------------------------------------------------------
-//
-_LIT8( KSelectDeviceInfoByUDN, "SELECT " 
-    "MediaServerID, UDN, Name, SystemUpdateID, VisibleDate, IsActive, FillUsage " 
-    "FROM MediaServers " 
-    "WHERE UDN = ?"
-    );
-    
-_LIT8( KSelectAllMediaServers, "SELECT " 
-    "UDN, Name, SystemUpdateID, VisibleDate, IsActive, MediaServerID, "
-    "CopyCapability, FillUsage, StoreUsage " 
-    "FROM MediaServers"
-    );
-        
-_LIT8( KSelectMediaServerIDByUDN, 
-    "SELECT "
-    "MediaServerID "
-    "FROM MediaServers "
-    "WHERE UDN = ?"
-    );
-
-_LIT8( KSelectHashValuesByMediaServer, "SELECT " 
-    "StartIndex, ItemCount, Hash " 
-    "FROM HashValues "
-    "WHERE MediaServerID = ?"
-    );
-    
-_LIT8( KSelectMediaServerUDNByID, 
-    "SELECT "
-    "UDN "
-    "FROM MediaServers "
-    "WHERE MediaServerID = ?"
-    );       
-
-_LIT8( KSelectStoredByUDN, 
-    "SELECT "
-    "StoredFile " 
-    "FROM Stored " 
-    "WHERE MediaServerID = ( " 
-    "SELECT MediaServerID "
-    "FROM MediaServers "
-    "WHERE UDN = ? )"
-    );
-    
-_LIT8( KIsFileAlreadyStored,
-    "SELECT "
-    "MediaServerID "
-    "FROM MediaServers "
-    "WHERE MediaServerID = ( "    
-    "SELECT "
-    "MediaServerID "
-    "FROM Stored "
-    "WHERE StoredFile = ? ) "
-    "AND "
-    "UDN = ?"   
-    );  
-
-_LIT8( KSelectID,
-    "SELECT "
-    "IDValue "
-    "FROM IDs "
-    "WHERE IDType = ?"
-    );
-
-_LIT8( KSelectRuleGroupID,
-    "SELECT "
-    "RuleGroupID "
-    "FROM FillRuleGroup "
-    "WHERE Name = ?"
-    );
-    
-_LIT8( KSelectStoreRuleID,
-    "SELECT "
-    "StoreRuleId "
-    "FROM StoreRules "
-    "WHERE Name = ?"
-    );
-
-// Loading Fill Rule 1.    
-_LIT8( KSelectFillRule,
-    "SELECT "
-    "RuleGroupID, Name, Method, LimitType, Quantity, Selected, Priority, "
-    "TemplateId, MediaType, Status, RealCount, RealSize "
-    "FROM FillRuleGroup "
-    "WHERE Name = ? "
-    "ORDER BY Priority ASC"
-    );
-    
-// Loading Fill Rule 2.                
-_LIT8( KSelectRule,
-    "SELECT "
-    "RuleID, MetadataField, Operator "
-    "FROM Rules "
-    "JOIN FillRuleGroup frg ON Rules.RuleGroupID = frg.RuleGroupID "
-    "WHERE frg.Name = ?"
-    );
-
-// Loading Fill Rule 3.    
-_LIT8( KSelectRuleParams, 
-    "SELECT "
-    "ComparisonFieldData "
-    "FROM RuleParams "
-    "WHERE RuleID = ( SELECT "
-    "RuleID "
-    "FROM Rules "
-    "WHERE RuleGroupID = ( SELECT "
-    "RuleGroupID "
-    "FROM FillRuleGroup "
-    "WHERE Name = ? ))"
-    );
-
-// Loading Fill Rule 3.1    
-_LIT8( KSelectRuleParamsByRuleID, 
-    "SELECT "
-    "ComparisonFieldData, ComparisonFieldIndex "
-    "FROM RuleParams "
-    "WHERE RuleID = ?"
-    );
-    
-// Loading Fill Rule 4.    
-_LIT8( KSelectMediaServerID, 
-    "SELECT "
-    "MediaServerID "
-    "FROM RuleGroupServers "
-    "WHERE RuleGroupID = ( SELECT "
-    "RuleGroupID "
-    "FROM FillRuleGroup "
-    "WHERE Name = ? )"
-    );
-
-// Loading Fill Rule 4.1    
-_LIT8( KSelectMediaServerIDByRuleGroupID, 
-    "SELECT "
-    "MediaServerID "
-    "FROM RuleGroupServers "
-    "WHERE RuleGroupID = ?"
-    );
-    
-// Loading Fill Rule 5.    
-_LIT8( KSelectRuleUDNs, 
-    "SELECT "
-    "UDN "
-    "FROM MediaServers "
-    "WHERE MediaServerID = ( SELECT "
-    "MediaServerID "
-    "FROM RuleGroupServers "
-    "WHERE RuleGroupID = ( SELECT "
-    "RuleGroupID "
-    "FROM FillRuleGroup "
-    "WHERE Name = ? ))"
-    );
-
-// Loading Fill Rule 5.1    
-_LIT8( KSelectRuleUDNsByMediaServerID, 
-    "SELECT "
-    "UDN "
-    "FROM MediaServers "
-    "WHERE MediaServerID = ?"
-    );
-    
-// Loading selected ( or not selected rules )    
-_LIT8( KSelectSelectedFillRuleNames, 
-    "SELECT "
-    "Name "
-    "FROM FillRuleGroup "
-    "WHERE Selected = ?"
-    );        
-
-// Loading all fill rule names
-_LIT8( KSelectFillRuleNames, 
-    "SELECT "
-    "Name "
-    "FROM FillRuleGroup"
-    );
-
-_LIT8( KSelectFillRuleName, 
-    "SELECT Name "
-    "FROM FillRuleGroup "
-    "WHERE RuleGroupID = ?"
-    );
-    
-// Loading Store Rule 1.    
-_LIT8( KSelectStoreRule,
-    "SELECT "
-    "StoreRuleID, Name, Selected, Status "
-    "FROM StoreRules "
-    "WHERE Name = ?"
-    );
-
-// Loading Store Rule 2.                
-_LIT8( KSelectStoreRuleDefs,
-    "SELECT "
-    "StoreRuleParamId, MediaType "
-    "FROM StoreRuleParams "
-    "WHERE StoreRuleID = ( SELECT "
-    "StoreRuleID "
-    "FROM StoreRules "
-    "WHERE Name = ? )"
-    );
-
-// Loading Store rule 3.    
-_LIT8( KSelectStoreRuleMediaServerID, 
-    "SELECT "
-    "MediaServerID "
-    "FROM StoreRuleServers "
-    "WHERE StoreRuleID = ?"
-    );
-    
-// Loading all store rule names
-_LIT8( KSelectStoreRuleNames, 
-    "SELECT "
-    "Name "
-    "FROM StoreRules"
-    );        
-
-// Loading selected ( or not selected rules )    
-_LIT8( KSelectSelectedStoreRuleNames, 
-    "SELECT "
-    "Name "
-    "FROM StoreRules "
-    "WHERE Selected = ?"
-    );    
-
-_LIT8( KSelectFillFiles, 
-    "SELECT "
-    "PrimaryText, SecondaryText, Path, Size, Status, Date, FileId, RefId "
-    "FROM FillFiles "
-    "WHERE ((Status & ? ) AND ( FillListId = "
-    "( SELECT RuleGroupId FROM FillRuleGroup WHERE Name = ? ) ) ) "
-    "ORDER BY PrimaryText"
-    );
-    
-_LIT8( KSelectDeletedFillFiles,
-    "SELECT "
-    "PrimaryText, SecondaryText, Path, Size, Status, Date, FileId "
-    "FROM FillFiles "
-    "WHERE ((Status & ? ) AND ( Selected = '2' ) )"
-    "ORDER BY PrimaryText"
-    );
-        
-_LIT8( KSelectAllFillFiles, 
-    "SELECT "
-    "FileId, PrimaryText, SecondaryText, Path, Uri, ItemId, UpnpClass, "
-    "MediaType, Priority, Size, Status, Date, FillListId, MediaServerId, "
-    "RefId, Selected, DriveId, DriveNumber "
-    "FROM FillFiles "
-    "ORDER BY Priority ASC"
-    );    
-    
-_LIT8( KGetAllFillFiles, 
-    "SELECT "
-    "FileId, PrimaryText, SecondaryText, Path, Uri, ItemId, UpnpClass, "
-    "MediaType, Priority, Size, Status, Date, FillListId, MediaServerId, "
-    "RefId, Selected, DriveId, DriveNumber "
-    "FROM FillFiles "
-    "WHERE ( Status & ? ) "
-    "ORDER BY Priority ASC"
-    );    
-        
-_LIT8( KSelectStoreFiles, 
-    "SELECT "
-    "PrimaryText, SecondaryText, Path, Size, Date "
-    "FROM StoreFiles "
-    "WHERE (StoreListId = "
-    "( SELECT StoreRuleID FROM StoreRules WHERE Name = ? )) "
-    "ORDER BY PrimaryText"
-    );
-
-_LIT8( KSelectAllStoreFiles, 
-    "SELECT "
-    "FileId, PrimaryText, SecondaryText, Path, Size, sfd.Status, "
-    "StoreListId, sfd.MediaServerId "
-    "FROM StoreFiles JOIN StoreFileServers sfd ON FileId = sfd.Fid"    
-    );
-
-_LIT8( KGetAllStoreFiles, 
-    "SELECT "
-    "PrimaryText, SecondaryText, Path, Size, sfd.Status, "
-    "StoreListId, sfd.MediaServerId "
-    "FROM StoreFiles JOIN StoreFileServers sfd ON FileId = sfd.Fid "
-    "WHERE ( sfd.Status & ? )"
-    );         
-
-_LIT8( KSelectLowestPriorityFilled,
-    "SELECT "
-    "Path, Size, FillListId, FileId "
-    "FROM FillFiles "
-    "WHERE ( Status & ? ) "
-    "AND ( Priority = "
-    "( SELECT MAX(Priority) FROM FillFiles "
-    "WHERE ( Status & ? AND RefId = '0' AND DriveNumber = ? ) ) )"
-    "ORDER BY Priority DESC"
-    );
-
-_LIT8( KSelectTransferHistory, 
-    "SELECT "
-    "DownloadData, UploadData, DownloadTime, UploadTime "
-    "FROM MediaServers "
-    "WHERE UDN = ?"
-    );
-
-// Count all files from selected store lists ( multiple servers included )
-_LIT8( KStoreFileCount,
-    "SELECT count(*) "
-    "FROM StoreRules "
-    "JOIN StoreFiles files,  StoreFileServers servers ON files.StoreListId = StoreRuleId "
-    "WHERE selected = '1' AND servers.FId = files.FileId  AND servers.status & ?" 
-    );
-
-_LIT8( KStoreFileCountNoDuplicates,
-    "SELECT count(*) "
-    "FROM StoreRules "
-    "JOIN StoreFiles files ON files.StoreListId = StoreRuleId "
-    "WHERE selected = '1'" 
-    );
-        
-_LIT8( KFillFileCount,
-    "SELECT count(*) "
-    "FROM FillFiles "
-    "WHERE status & ? AND RefId = '0' AND Selected = '1'"
-    );
-    
-_LIT8( KImageShrinkingInfo,
-    "SELECT Count, Time "
-    "FROM ImageShrinkingInfo"
-    );
-
-_LIT8( KTranferValues,
-    "SELECT Count "
-    "FROM TransferInfo "
-    "WHERE Service = ?"
-    );
-
-_LIT8( KStoreListFileCount,
-    "SELECT count(*) "
-    "FROM StoreFiles JOIN StoreRules sr ON StoreListId = sr.StoreRuleId "
-    "WHERE sr.Name = ?"
-    ); 
-
-_LIT8( KFillListFileCount,
-    "SELECT count(*) "
-    "FROM FillFiles "
-    "WHERE (( Status & ?) AND (FillListId = "
-    "(SELECT RuleGroupID FROM FillRuleGroup WHERE Name = ?)) AND "
-    "( Selected = '1') )"
-    );
-    
-_LIT8( KGetSyncTime, 
-    "SELECT * "
-    "FROM SyncTime" 
-    );               
-
-_LIT8( KGetProgressInfo,
-    "SELECT Trasferred, TotalCount "
-    "FROM ProgressInfo" 
-    ); 
-
-_LIT8( KGetFillListStatus,
-    "SELECT Status "
-    "FROM FillRuleGroup "
-    "WHERE Name = ?"
-    );
-    
-_LIT8( KGetDrives, 
-    "SELECT DriveNumber, DriveType, DriveName, Size, Quota, UsedQuota, "
-    "UniqueId, Active "
-    "FROM DrivesInfo "
-    "ORDER BY DriveType ASC"
-    );
-                                  
-// ---------------------------------------------------------------------------
-// INSERT clauses
-// ---------------------------------------------------------------------------
-//    
-// FillRuleGroup table
-_LIT8( KAddFillGroup,
-    "INSERT INTO FillRuleGroup("
-        "RuleGroupID, Name, Method, LimitType, Quantity, "
-        "Selected, Priority, TemplateId, MediaType, Status, RealCount, "
-        "RealSize )"
-        "VALUES(?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)"
-        );
-        
-// Rules table
-_LIT8( KAddRule,
-    "INSERT INTO Rules("
-        "RuleID, RuleGroupID, MetadataField, Operator )"
-        "VALUES(?, ?, ?, ?)"
-        );
-        
-_LIT8( KAddRuleParam,
-    "INSERT INTO RuleParams("
-    "RuleParamID, RuleID, ComparisonFieldData, ComparisonFieldIndex )"
-    "VALUES(?, ?, ?, ?)"
-    );
-    
-_LIT8( KAddRuleGroupServer,
-    "INSERT INTO RuleGroupServers("
-    "RuleGroupID, MediaServerID )"
-    "VALUES(?, ?)"
-    );            
-
-_LIT8( KAddMediaServer,
-    "INSERT INTO MediaServers("
-    "MediaServerID, UDN, Name, SystemUpdateID, VisibleDate, "
-    "DownloadData, UploadData, DownloadTime, UploadTime, "
-    "IsActive, CopyCapability, FillUsage, StoreUsage )"
-    "VALUES(?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)"
-    );
-
-_LIT8( KAddHashValue,
-    "INSERT INTO HashValues("
-    "MediaServerID, StartIndex, ItemCount, Hash )"
-    "VALUES(?, ?, ?, ?)"
-    );
-    
-    
-_LIT8( KAddStored,
-    "INSERT INTO Stored("
-    "StoredID, StoredFile, MediaServerID, Date )"
-    "VALUES(?, ?, ?, ?)"
-    );
-            
-_LIT8( KAddIDs,
-    "INSERT INTO IDs("
-    "IDValue, IDType )"
-    "VALUES(?, ?)"
-    );
-    
-_LIT8( KAddStoreRule,
-    "INSERT INTO StoreRules("
-    "StoreRuleId, Name, Selected, Status )"
-    "VALUES(?, ?, ?, ?)"
-    );
-    
-_LIT8( KAddStoreRuleParams,
-    "INSERT INTO StoreRuleParams("
-    "StoreRuleId, StoreRuleParamId, MediaType )"
-    "VALUES(?, ?, ?)"
-    );    
-
-_LIT8( KAddStoreRuleServers,
-    "INSERT INTO StoreRuleServers("
-    "StoreRuleId, MediaServerID )"
-    "VALUES(?, ?)"
-    );
-
-_LIT8( KAddFillFile, 
-    "INSERT INTO FillFiles("
-    "FileId, PrimaryText, SecondaryText, Path, Uri, ItemId, UpnpClass, "
-    "MediaType, Priority, Size, Status, Date, FillListId, MediaServerId, "
-    "RefId, Selected, DriveId, DriveNumber ) "
-    "VALUES(?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)"  
-    );
-
-_LIT8( KAddStoreFile, 
-    "INSERT INTO StoreFiles("
-    "FileId, PrimaryText, SecondaryText, Path, Size, Date, StoreListId) "
-    "VALUES(?, ?, ?, ?, ?, ?, ?)"  
-    );    
-           
-_LIT8( KAddStoreFileServer, 
-    "INSERT INTO StoreFileServers("
-    "Fid, MediaServerId, Status ) "
-    "VALUES(?, ?, ?)"  
-    );
-        
-_LIT8( KInitShrinkingTime,
-    "INSERT INTO ImageShrinkingInfo("
-    "Count, Time ) "
-    "VALUES(0, 0)"      
-    );    
-        
-_LIT8( KInitTransferInfo,
-     "INSERT INTO TransferInfo("
-    "Service, Count, Time ) "
-    "VALUES(?,0,0)"    
-    );        
-
-_LIT8( KSetSyncTime,
-    "INSERT INTO SyncTime("
-    "Time ) "
-    "VALUES( ? )"
-    );
-    
-_LIT8( KSetProgressInfo,
-    "INSERT INTO ProgressInfo( "
-    "Trasferred, TotalCount ) "
-    "VALUES( ?, ? )"
-    ); 
-
-_LIT8( KSetDrivesInfo,
-    "INSERT INTO DrivesInfo("
-    "DriveNumber, DriveType, DriveName, Size, Quota, UsedQuota, UniqueId, "
-    "Active ) "
-    "VALUES( ?, ?, ?, ?, ?, ?, ?, ? )"
-    ); 
-                            
-// count queries
-   
-_LIT8( KValidateTableExistence,
-    "SELECT count(*)"
-        " FROM IDs"
-        );
-
-// Sum queries
-_LIT8( KFillListSize,
-    "SELECT SUM(Size) "
-    "FROM FillFiles "
-    "WHERE (( Status & ?) AND (FillListId = "
-    "(SELECT RuleGroupID FROM FillRuleGroup WHERE Name = ?)))"
-    );
-    
-_LIT8( KStoreListSize,
-    "SELECT SUM(Size) "
-    "FROM StoreFiles "
-    "WHERE ( StoreListId = "
-    "( SELECT StoreRuleId FROM StoreRules WHERE Name = ? ))"
-    );    
-
-_LIT8( KDataAmountFilled,
-    "SELECT SUM(Size) "
-    "FROM FillFiles "
-    "WHERE (( Status & 2 ) AND ( FillListId = ? ))" 
-    );
-_LIT8( KDataAmountToBeFilled,
-    "SELECT SUM(Size) "
-    "FROM FillFiles "
-    "WHERE (( Status & ?) AND (MediaServerId = ?) AND "
-    "( Selected = '1'))" 
-    );
-
-_LIT8( KDataAmountToBeStored,
-    "SELECT SUM(Size) "
-    "FROM StoreFiles JOIN StoreFileServers sfd ON FileId = sfd.Fid "
-    "WHERE ((sfd.MediaServerId = ?) AND (sfd.Status & ?))" 
-    );
-
-_LIT8( KTranferTime,
-    "SELECT Time "
-    "FROM TransferInfo "
-    "WHERE Service = ?"
-    );
-
-_LIT8( KGetStoreFileCountNoDuplicates, 
-    "SELECT COUNT( DISTINCT Fid ) "
-    "FROM StoreFileServers servers "
-    "JOIN StoreFiles files, StoreRules rules "
-    "ON (files.FileId = servers.Fid AND rules.StoreRuleId = files.StoreListId) "
-    "WHERE (servers.Status & ? AND rules.Selected = 1)" 
-    );    
-                             
-// ---------------------------------------------------------------------------
-// UPDATE / REPLACE clauses
-// ---------------------------------------------------------------------------
-//
-_LIT8( KUpdateMediaServerInfo,
-    "UPDATE MediaServers"
-        " SET Name = ?, "
-        "SystemUpdateID = ?, "
-        "VisibleDate = ?"
-        " WHERE UDN = ?"
-        );
-        
-_LIT8( KUpdateFillRule,
-    "UPDATE FillRuleGroup"
-    " SET Quantity = ?"
-    " WHERE Name = ?"
-    );
-    
-_LIT8( KUpdateID,
-    "UPDATE IDs"
-    " SET IDValue = ?"
-    " WHERE IDType = ?"
-    );
-    
-// Updating Fill rules selected state
-_LIT8( KUpdateFillRuleSelected, 
-    "UPDATE FillRuleGroup"
-    " SET Selected = ?"
-    " WHERE Name = ?"
-    );
-
-// Updating Fill rules selected state
-_LIT8( KUpdateFillRuleRealInformation, 
-    "UPDATE FillRuleGroup"
-    " SET RealCount = ?, RealSize = ?"
-    " WHERE RuleGroupID = ?"
-    );      
-
-// Updating download history
-_LIT8( KUpdateDownloadHistory,
-    "UPDATE MediaServers "
-    "SET DownloadData = DownloadData + ?, DownloadTime = DownloadTime + ? "
-    "WHERE MediaServerId = ?"
-    );
-        
-// Updating upload history        
-_LIT8( KUpdateUploadHistory,
-    "UPDATE MediaServers "
-    "SET UploadData = UploadData + ?, UploadTime = UploadTime + ? "
-    "WHERE MediaServerId = ?"
-    );
-    
-_LIT8( KIncrementImageShrinkingInfo,
-    "UPDATE ImageShrinkingInfo "
-    "SET Count = Count + ?, Time = Time + ?"
-    );    
-
-_LIT8( KUpdateTransferInfo,
-    "UPDATE TransferInfo "
-    "SET Count = ?, Time = ? "
-    "WHERE Service = ?"
-    );
-
-//updates active status, name, fillusage and storeusage
-_LIT8( KUpdateMsIsActive,
-    "UPDATE MediaServers "
-    "SET IsActive = ?, SystemUpdateID = ?, Name = ?, FillUsage = ?, StoreUsage = ? "
-    "WHERE UDN = ?"
-    );
-    
-_LIT8( KInitIsActiveFlags,
-    "UPDATE MediaServers "
-    "SET IsActive = '0'"
-    );    
-
-_LIT8( KUpdateFileStatus,
-    "UPDATE FillFiles "
-    "SET Status = ? "
-    "WHERE ( ( FileId = ? ) OR ( RefId = ? ) )"
-    );
-
-_LIT8( KUpdateFillItemPriorities, 
-    "UPDATE FillFiles "
-    "SET Priority = ?, Selected = ? "
-    "WHERE FillListId = "
-    "( SELECT RuleGroupID FROM FillRuleGroup "
-    "WHERE Name = ? )"
-    );
-
-//Updates Fill item's status if the status isn't equal to
-//ECmFilled    
-_LIT8( KUpdateFillItemStatusByRuleName, 
-    "UPDATE FillFiles "
-     "SET Status = ? "
-    "WHERE  FillListId = "
-    "( SELECT RuleGroupID FROM FillRuleGroup "
-    "WHERE Name = ? )"
-    "AND ( Status > '2' OR Status < '2' )"
-    "AND ( Status != '64' )"
-    );
-           
-// Updates highest priority item as a target for
-// the reference
-_LIT8( KUpdateFillItemRef_Zero,
-    "UPDATE FillFiles "
-    "SET RefId = '0' WHERE ( Priority = "
-    "( SELECT MIN( Priority ) FROM FillFiles "
-    "WHERE Selected = '1' ) )"
-    );
-
-_LIT8( KRestoreListItemStatuses, 
-    "UPDATE FillFiles "
-    "SET Status = ? "
-    "WHERE (( FillListId = ? ) AND ( RefId = '0' ) )"
-    );
-
-_LIT8( KRestoreFileStatus, 
-    "UPDATE FillFiles "
-    "SET Status = ? "
-    "WHERE ( FileId = ? OR RefId = ? )"
-    );
-
-_LIT8( KUpdateSelectionStatus,
-    "UPDATE FillFiles "
-    "SET Selected = ?, "
-    "FillListId = 255, "
-    "Priority = 255 "
-    "WHERE FillListId = ?"
-    );
-
-_LIT8( KUpdateStoreTransferStatus, 
-    "UPDATE StoreFileServers SET Status = ? WHERE "
-    "Fid = ? AND MediaServerId = ?;"
-    );
-            
-_LIT8( KUpdateFillTransferStatus, 
-    "UPDATE FillFiles SET Status = ?, Path = ?, "
-    "DriveId = ?, DriveNumber = ? WHERE "
-    "MediaServerId =? AND ((FileId =? AND FillListId =?) OR (RefId =?));"
-    );
-
-_LIT8( KUpdateFillDriveInfo,
-    "UPDATE FillFiles "
-        "SET DriveNumber = ?, "
-        "DriveId = ? "
-        "WHERE DriveId = ?"
-        );
-
-_LIT8( KUpdateFillDriveAndStatusInfo,
-    "UPDATE FillFiles "
-        "SET Path = ?, "
-        "DriveNumber = ?, "
-        "DriveId = ?, "
-        "Status = ? " // Set all to EToBeFilled
-        "WHERE DriveId = ?"
-        );
-                                            
-// ---------------------------------------------------------------------------
-// REMOVE clauses
-// ---------------------------------------------------------------------------
-//
-_LIT8( KRemoveMediaServersByUDN,
-    "DELETE FROM MediaServers"
-    " WHERE UDN = ?"
-    );
-    
-_LIT8( KRemoveFillRuleByName,
-    "DELETE FROM FillRuleGroup"
-    " WHERE Name = ?"
-    );
-        
-_LIT8( KRemoveRuleByRuleGroupID,
-    "DELETE FROM Rules"
-    " WHERE RuleGroupID = (SELECT "
-    "RuleGroupID "
-    "FROM FillRuleGroup "
-    "WHERE Name = ? )"
-    );
-
-_LIT8( KRemoveRuleParamsByRuleID,
-    "DELETE FROM RuleParams"
-    " WHERE RuleID = (SELECT "
-    "RuleID "
-    "FROM Rules "
-    "WHERE RuleGroupID = (SELECT "
-    "RuleGroupID "
-    "FROM FillRuleGroup "
-    "WHERE Name = ? ) )"
-    );
-
-_LIT8( KRemoveRuleGroupServers,
-    "DELETE FROM RuleGroupServers "
-    "WHERE RuleGroupID = (SELECT "
-    "RuleGroupID "
-    "FROM FillRuleGroup "
-    "WHERE Name = ? )"
-    );
-    
-/** Delete all fill rules */ 
-   
-_LIT8( KRemoveFillRuleAll,
-    "DELETE FROM FillRuleGroup"
-    );
-        
-_LIT8( KRemoveRuleAll,
-    "DELETE FROM Rules"
-    );
-
-_LIT8( KRemoveRuleParamAll,
-    "DELETE FROM RuleParams"
-    );
-
-_LIT8( KRemoveRuleGroupServerAll,
-    "DELETE FROM RuleGroupServers"
-    );
-    
-/** Delete all store rules */
-
-_LIT8( KRemoveStoreRuleServers,
-    "DELETE FROM StoreRuleServers"
-    );
-        
-_LIT8( KRemoveStoreRuleParams,
-    "DELETE FROM StoreRuleParams"
-    );
-
-_LIT8( KRemoveStoreRules,
-    "DELETE FROM StoreRules"
-    );
-
-_LIT8( KRemoveRuleGroupServer,
-    "DELETE FROM RuleGroupServers "
-    "WHERE RuleGroupID = ? AND MediaServerID = ?"
-    );
-    
-_LIT8( KRemoveStoreRuleServer,
-    "DELETE FROM StoreRuleServers "
-    "WHERE StoreRuleID = ? AND MediaServerID = ?"
-    );
-
-/** Delete All Filled files */
-_LIT8( KRemoveFillFiles, 
-    "DELETE FROM FillFiles"
-    );
-    
-/** Delete all fill rule's files */
-_LIT8( KRemoveFillList, 
-    "DELETE FROM FillFiles "
-    "WHERE FillListId = ( SELECT RuleGroupID FROM FillRuleGroup "
-    "WHERE Name = ?)"
-    );    
-    
-/** Delete all fillFiles by defined FillListId */
-_LIT8( KRemoveFillListItems, 
-    "DELETE FROM FillFiles "
-    "WHERE FillListId = ?"
-    );
-    
-/** Delete Stored file */
-_LIT8( KRemoveStoreFile, 
-    "DELETE FROM StoreFiles "
-    "WHERE PrimaryText = ?"
-    );    
-        
-/** Delete All Stored files */
-_LIT8( KRemoveStoreFiles, 
-    "DELETE FROM StoreFiles"
-    );
-    
-_LIT8( KRemoveStoreFileServers,
-    "DELETE FROM StoreFileServers"
-    );    
- 
-/** Delete in active fill rule servers */
-_LIT8( KRemoveInActiveFillRuleServers,
-    "DELETE FROM RuleGroupServers "
-    "WHERE MediaServerID IN ( SELECT MediaServerID "
-    "FROM MediaServers WHERE MediaServers.FillUsage = '0' )"
-    ); 
-
-/** Delete in active store rule servers */    
-_LIT8( KRemoveInActiveStoreRuleServers,
-    "DELETE FROM StoreRuleServers "
-    "WHERE MediaServerID IN ( SELECT MediaServerID "
-    "FROM MediaServers WHERE StoreUsage = '0')"    
-    );
-    
-/** Delete in active fill files */    
-_LIT8( KRemoveInActiveFillFiles,
-    "DELETE FROM FillFiles "
-    "WHERE MediaServerId IN ( SELECT MediaServerID "
-    "FROM MediaServers WHERE FillUsage = '0' )" 
-    );    
-
-/** Delete in active store file servers */
-_LIT8( KRemoveInActiveStoreFilesServers,
-    "DELETE FROM StoreFileServers "
-    "WHERE MediaServerId IN ( SELECT MediaServerID "
-    "FROM MediaServers WHERE StoreUsage = '0')" 
-    ); 
-
-/** Delete in active store files */
-_LIT8( KRemoveInActiveStoreFiles,
-    "DELETE FROM StoreFiles "
-    "WHERE FileId NOT IN ( SELECT Fid "
-    "FROM StoreFileServers )"    
-    );
-
-_LIT8( KRemoveProgressInfo,
-    "DELETE FROM ProgressInfo"
-    );
-    
-_LIT8( KRemoveDrivesInfo,
-    "DELETE FROM DrivesInfo"
-    );    
-
-_LIT8( KRemoveSyncTime,
-    "DELETE FROM SyncTime"
-    );
-
-_LIT8( KRemoveDeletedFillFiles, 
-    "DELETE FROM FillFiles "
-    "WHERE Selected = '2'"
-    );
-
-_LIT8( KRemoveDeletedMediaServers, 
-    "DELETE FROM MediaServers "
-    "WHERE FillUsage = '0' AND StoreUsage = '0'"
-    );
-
-_LIT8( KRemoveHash,
-    "DELETE FROM HashValues "
-    "WHERE ( ( MediaServerID = ? ) AND ( StartIndex >= ? ) )"
-    );
-
-_LIT8( KSetNullRealSizes,
-    "UPDATE FillRuleGroup SET RealCount = '0', RealSize = '0' "
-    "WHERE RuleGroupID NOT IN "
-    "( SELECT FillListId FROM FillFiles ) "
-    );
-    
-// ---------------------------------------------------------------------------
-// TRANSACTION HANDLING
-// ---------------------------------------------------------------------------
-//
-_LIT8(KCmDbBeginTransaction, "BEGIN");
-_LIT8(KCmDbSqlCommit, "COMMIT");
-                                    
-#endif // __CMDMSQLCLAUSEDEF_H__
-
-
-