diff -r 6369bfd1b60d -r 08b5eae9f9ff upnpharvester/common/dbmanager/inc/cmdmsqlmaintenanceclauses.h --- a/upnpharvester/common/dbmanager/inc/cmdmsqlmaintenanceclauses.h Mon Nov 01 13:44:24 2010 +0200 +++ /dev/null Thu Jan 01 00:00:00 1970 +0000 @@ -1,286 +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 -* -*/ - - - - - - -#ifndef __CMDMSQLMAINTENANCECLAUSES_H__ -#define __CMDMSQLMAINTENANCECLAUSES_H__ - -/////////////////////////////////////////////////////////////////// -// DROP CLAUSES -/////////////////////////////////////////////////////////////////// - -// Drop tables -_LIT8( KDropFillRuleGroup, "DROP TABLE FillRuleGroup;" ); -_LIT8( KDropRules, "DROP TABLE Rules;" ); -_LIT8( KDropRuleParams, "DROP TABLE RuleParams;" ); -_LIT8( KDropRuleGroupServers, "DROP TABLE RuleGroupServers;" ); -_LIT8( KDropMediaServers, "DROP TABLE MediaServers;" ); -_LIT8( KDropHashValues, "DROP TABLE HashValues;" ); -_LIT8( KDropStored, "DROP TABLE Stored;" ); -_LIT8( KDropFilled, "DROP TABLE Filled;" ); -_LIT8( KDropIDs, "DROP TABLE IDs;" ); -_LIT8( KDropStoreRules, "DROP TABLE StoreRules;" ); -_LIT8( KDropStoreRuleParams, "DROP TABLE StoreRuleParams;"); -_LIT8( KDropStoreRuleServers, "DROP TABLE StoreRuleServers;"); - -_LIT8( KDropFillFiles, "DROP TABLE FillFiles;"); -_LIT8( KDropStoreFiles, "DROP TABLE StoreFiles;"); -_LIT8( KDropStoreFileServers, "DROP TABLE StoreFileServers;"); -_LIT8( KDropImageShrinkingInfo, "DROP TABLE ImageShrinkingInfo;"); -_LIT8( KDropTransferInfo, "DROP TABLE TransferInfo;"); -_LIT8( KDropSyncTime, "DROP TABLE SyncTime;"); -_LIT8( KDropProgressInfo, "DROP TABLE ProgressInfo;"); - -_LIT8( KDropDrivesInfo, "DROP TABLE DrivesInfo;"); - -/////////////////////////////////////////////////////////////////// -// CREATE CLAUSES FOR TABLES -/////////////////////////////////////////////////////////////////// - -// ONTOLOGY TABLES -_LIT8( KCreateFillRuleGroup, - "CREATE TABLE FillRuleGroup(" - "RuleGroupID INTEGER NOT NULL," - "Name TEXT NOT NULL," - "Method INTEGER," - "LimitType INTEGER," - "Quantity INTEGER," - "Selected INTEGER," - "Priority INTEGER," - "TemplateId INTEGER," - "MediaType INTEGER," - "Status INTEGER," - "RealCount INTEGER," - "RealSize INTEGER," - "PRIMARY KEY(RuleGroupID));" - ); - -_LIT8( KCreateRules, - "CREATE TABLE Rules(" - "RuleID INTEGER NOT NULL," - "RuleGroupID INTEGER NOT NULL," - "MetadataField INTEGER," - "Operator INTEGER," - "PRIMARY KEY(RuleID));" - ); - -_LIT8( KCreateRuleParams, - "CREATE TABLE RuleParams(" - "RuleParamID INTEGER NOT NULL," - "RuleID INTEGER NOT NULL," - "ComparisonFieldData TEXT," - "ComparisonFieldIndex INTEGER," - "PRIMARY KEY(RuleParamID));" - ); - -_LIT8( KCreateRuleGroupServers, - "CREATE TABLE RuleGroupServers(" - "RuleGroupID INTEGER NOT NULL," - "MediaServerID INTEGER NOT NULL);" - ); - -_LIT8( KCreateMediaServers, - "CREATE TABLE MediaServers(" - "MediaServerID INTEGER NOT NULL," - "UDN TEXT NOT NULL," - "Name TEXT NOT NULL," - "SystemUpdateID INTEGER," - "VisibleDate DATETIME," - "DownloadData INTEGER," - "UploadData INTEGER," - "DownloadTime INTEGER," - "UploadTime INTEGER," - "IsActive INTEGER," - "CopyCapability INTEGER," - "FillUsage INTEGER," - "StoreUsage INTEGER," - "PRIMARY KEY(MediaServerID));" - ); - -_LIT8( KCreateHashValues, - "CREATE TABLE HashValues(" - "HashValueID INTEGER NOT NULL," - "MediaServerID INTEGER NOT NULL," - "StartIndex INTEGER NOT NULL," - "ItemCount INTEGER NOT NULL," - "Hash TEXT NOT NULL," - "PRIMARY KEY(HashValueID));" - ); - - -_LIT8( KCreateStored, - "CREATE TABLE Stored(" - "StoredFile TEXT NOT NULL," - "StoredID INTEGER NOT NULL," - "MediaServerID INTEGER NOT NULL," - "Date DATETIME," - "PRIMARY KEY(StoredID));" - ); - -_LIT8( KCreateIDs, - "CREATE TABLE IDs(" - "IDValue INTEGER NOT NULL," - "IDType INTEGER NOT NULL," - "PRIMARY KEY(IDType));" - ); - -_LIT8( KCreateStoreRules, - "CREATE TABLE StoreRules(" - "StoreRuleId INTEGER NOT NULL," - "Name TEXT NOT NULL," - "Selected INTEGER," - "Status INTEGER," - "PRIMARY KEY(StoreRuleId));" - ); - -_LIT8( KCreateStoreRuleParams, - "CREATE TABLE StoreRuleParams(" - "StoreRuleId INTEGER NOT NULL," - "StoreRuleParamId INTEGER NOT NULL," - "MediaType INTEGER," - "PRIMARY KEY(StoreRuleParamId));" - ); - -_LIT8( KCreateStoreRuleServers, - "CREATE TABLE StoreRuleServers(" - "StoreRuleId INTEGER NOT NULL," - "MediaServerID INTEGER NOT NULL);" - ); - -_LIT8( KCreateFillFiles, - "CREATE TABLE FillFiles(" - "FileId INTEGER NOT NULL," - "PrimaryText TEXT NOT NULL," - "SecondaryText TEXT," - "Path TEXT," - "Uri TEXT NOT NULL," - "ItemId TEXT NOT NULL," - "UpnpClass TEXT," - "MediaType INTEGER," - "Priority INTEGER,"// Highest priority is zero - "Size INTEGER,"// In bytes - "Status INTEGER," - "Date DATETIME," - "FillListId INTEGER NOT NULL," - "MediaServerId INTEGER NOT NULL," - "Selected INTEGER," - "RefId INTEGER," - "DriveId INTEGER," - "DriveNumber INTEGER );" - //"PRIMARY KEY(FileId));" - ); - -_LIT8( KCreateStoreFiles, - "CREATE TABLE StoreFiles(" - "FileId INTEGER NOT NULL," - "PrimaryText TEXT NOT NULL," - "SecondaryText TEXT," - "Path TEXT," - "Size INTEGER," - "Date DATETIME," - "StoreListId INTEGER NOT NULL," - "PRIMARY KEY(FileId));" - ); - -_LIT8( KCreateStoreFileServers, - "CREATE TABLE StoreFileServers(" - "Fid INTEGER NOT NULL," - "MediaServerId INTEGER NOT NULL," - "Status INTEGER );" - ); - -_LIT8( KCreateImageShrinkingInfo, - "CREATE TABLE ImageShrinkingInfo(" - "Count INTEGER," - "Time INTEGER );" - ); - -_LIT8( KCreateTransferInfo, - "CREATE TABLE TransferInfo(" - "Service INTEGER," - "Count INTEGER," - "Time INTEGER," - "PRIMARY KEY(Service));" - ); - -_LIT8( KCreateSyncTime, - "CREATE TABLE SyncTime(" - "Time DATETIME );" - ); - -_LIT8( KCreateProgressInfo, - "CREATE TABLE ProgressInfo(" - "Trasferred INTEGER," - "TotalCount INTEGER );" - ); - -_LIT8( KCreateDrivesInfo, - "CREATE TABLE DrivesInfo(" - "DriveNumber INTEGER," - "DriveType INTEGER," - "DriveName TEXT," - "Size INTEGER," - "Quota INTEGER," - "UsedQuota INTEGER," - "UniqueId INTEGER," - "Active INTEGER );" - ); - -/////////////////////////////////////////////////////////////////// -// CREATE CLAUSES FOR INDEXES -/////////////////////////////////////////////////////////////////// -_LIT8( KCreateStoreStatusIndex, - "CREATE INDEX Store_status_index ON StoreFiles(Status);" - ); - -_LIT8( KCreateFillStatusIndex, - "CREATE INDEX Fill_status_index ON FillFiles(Status);" - ); - -_LIT8( KCreateFillListIdIndex, - "CREATE INDEX FillListIdIndex ON FillFiles(FillListId);" - ); - -_LIT8( KCreateFillItemRefIndex, - "CREATE INDEX FillList_Ref_Index ON FillFiles( FileId, " - "RefId, Priority, Selected );" - ); - -// Dropping indexes -_LIT8( KDropStoreStatusIndex, - "DROP INDEX Store_status_index;" - ); - -_LIT8( KDropFillStatusIndex, - "DROP INDEX Fill_status_index;" - ); - -_LIT8( KDropFillListIdIndex, - "DROP INDEX FillListIdIndex;" - ); - -_LIT8( KDropFillItemRefIndex, - "DROP INDEX FillList_Ref_Index;" - ); - -#endif // __CMDMSQLMAINTENANCECLAUSES_H__ - -