1 /* |
|
2 * Copyright (c) 2008 Nokia Corporation and/or its subsidiary(-ies). |
|
3 * All rights reserved. |
|
4 * This component and the accompanying materials are made available |
|
5 * under the terms of "Eclipse Public License v1.0" |
|
6 * which accompanies this distribution, and is available |
|
7 * at the URL "http://www.eclipse.org/legal/epl-v10.html". |
|
8 * |
|
9 * Initial Contributors: |
|
10 * Nokia Corporation - initial contribution. |
|
11 * |
|
12 * Contributors: |
|
13 * |
|
14 * Description: Includes SQL clauses for creating and dropping tables |
|
15 * |
|
16 */ |
|
17 |
|
18 |
|
19 |
|
20 |
|
21 |
|
22 |
|
23 #ifndef __CMDMSQLMAINTENANCECLAUSES_H__ |
|
24 #define __CMDMSQLMAINTENANCECLAUSES_H__ |
|
25 |
|
26 /////////////////////////////////////////////////////////////////// |
|
27 // DROP CLAUSES |
|
28 /////////////////////////////////////////////////////////////////// |
|
29 |
|
30 // Drop tables |
|
31 _LIT8( KDropFillRuleGroup, "DROP TABLE FillRuleGroup;" ); |
|
32 _LIT8( KDropRules, "DROP TABLE Rules;" ); |
|
33 _LIT8( KDropRuleParams, "DROP TABLE RuleParams;" ); |
|
34 _LIT8( KDropRuleGroupServers, "DROP TABLE RuleGroupServers;" ); |
|
35 _LIT8( KDropMediaServers, "DROP TABLE MediaServers;" ); |
|
36 _LIT8( KDropHashValues, "DROP TABLE HashValues;" ); |
|
37 _LIT8( KDropStored, "DROP TABLE Stored;" ); |
|
38 _LIT8( KDropFilled, "DROP TABLE Filled;" ); |
|
39 _LIT8( KDropIDs, "DROP TABLE IDs;" ); |
|
40 _LIT8( KDropStoreRules, "DROP TABLE StoreRules;" ); |
|
41 _LIT8( KDropStoreRuleParams, "DROP TABLE StoreRuleParams;"); |
|
42 _LIT8( KDropStoreRuleServers, "DROP TABLE StoreRuleServers;"); |
|
43 |
|
44 _LIT8( KDropFillFiles, "DROP TABLE FillFiles;"); |
|
45 _LIT8( KDropStoreFiles, "DROP TABLE StoreFiles;"); |
|
46 _LIT8( KDropStoreFileServers, "DROP TABLE StoreFileServers;"); |
|
47 _LIT8( KDropImageShrinkingInfo, "DROP TABLE ImageShrinkingInfo;"); |
|
48 _LIT8( KDropTransferInfo, "DROP TABLE TransferInfo;"); |
|
49 _LIT8( KDropSyncTime, "DROP TABLE SyncTime;"); |
|
50 _LIT8( KDropProgressInfo, "DROP TABLE ProgressInfo;"); |
|
51 |
|
52 _LIT8( KDropDrivesInfo, "DROP TABLE DrivesInfo;"); |
|
53 |
|
54 /////////////////////////////////////////////////////////////////// |
|
55 // CREATE CLAUSES FOR TABLES |
|
56 /////////////////////////////////////////////////////////////////// |
|
57 |
|
58 // ONTOLOGY TABLES |
|
59 _LIT8( KCreateFillRuleGroup, |
|
60 "CREATE TABLE FillRuleGroup(" |
|
61 "RuleGroupID INTEGER NOT NULL," |
|
62 "Name TEXT NOT NULL," |
|
63 "Method INTEGER," |
|
64 "LimitType INTEGER," |
|
65 "Quantity INTEGER," |
|
66 "Selected INTEGER," |
|
67 "Priority INTEGER," |
|
68 "TemplateId INTEGER," |
|
69 "MediaType INTEGER," |
|
70 "Status INTEGER," |
|
71 "RealCount INTEGER," |
|
72 "RealSize INTEGER," |
|
73 "PRIMARY KEY(RuleGroupID));" |
|
74 ); |
|
75 |
|
76 _LIT8( KCreateRules, |
|
77 "CREATE TABLE Rules(" |
|
78 "RuleID INTEGER NOT NULL," |
|
79 "RuleGroupID INTEGER NOT NULL," |
|
80 "MetadataField INTEGER," |
|
81 "Operator INTEGER," |
|
82 "PRIMARY KEY(RuleID));" |
|
83 ); |
|
84 |
|
85 _LIT8( KCreateRuleParams, |
|
86 "CREATE TABLE RuleParams(" |
|
87 "RuleParamID INTEGER NOT NULL," |
|
88 "RuleID INTEGER NOT NULL," |
|
89 "ComparisonFieldData TEXT," |
|
90 "ComparisonFieldIndex INTEGER," |
|
91 "PRIMARY KEY(RuleParamID));" |
|
92 ); |
|
93 |
|
94 _LIT8( KCreateRuleGroupServers, |
|
95 "CREATE TABLE RuleGroupServers(" |
|
96 "RuleGroupID INTEGER NOT NULL," |
|
97 "MediaServerID INTEGER NOT NULL);" |
|
98 ); |
|
99 |
|
100 _LIT8( KCreateMediaServers, |
|
101 "CREATE TABLE MediaServers(" |
|
102 "MediaServerID INTEGER NOT NULL," |
|
103 "UDN TEXT NOT NULL," |
|
104 "Name TEXT NOT NULL," |
|
105 "SystemUpdateID INTEGER," |
|
106 "VisibleDate DATETIME," |
|
107 "DownloadData INTEGER," |
|
108 "UploadData INTEGER," |
|
109 "DownloadTime INTEGER," |
|
110 "UploadTime INTEGER," |
|
111 "IsActive INTEGER," |
|
112 "CopyCapability INTEGER," |
|
113 "FillUsage INTEGER," |
|
114 "StoreUsage INTEGER," |
|
115 "PRIMARY KEY(MediaServerID));" |
|
116 ); |
|
117 |
|
118 _LIT8( KCreateHashValues, |
|
119 "CREATE TABLE HashValues(" |
|
120 "HashValueID INTEGER NOT NULL," |
|
121 "MediaServerID INTEGER NOT NULL," |
|
122 "StartIndex INTEGER NOT NULL," |
|
123 "ItemCount INTEGER NOT NULL," |
|
124 "Hash TEXT NOT NULL," |
|
125 "PRIMARY KEY(HashValueID));" |
|
126 ); |
|
127 |
|
128 |
|
129 _LIT8( KCreateStored, |
|
130 "CREATE TABLE Stored(" |
|
131 "StoredFile TEXT NOT NULL," |
|
132 "StoredID INTEGER NOT NULL," |
|
133 "MediaServerID INTEGER NOT NULL," |
|
134 "Date DATETIME," |
|
135 "PRIMARY KEY(StoredID));" |
|
136 ); |
|
137 |
|
138 _LIT8( KCreateIDs, |
|
139 "CREATE TABLE IDs(" |
|
140 "IDValue INTEGER NOT NULL," |
|
141 "IDType INTEGER NOT NULL," |
|
142 "PRIMARY KEY(IDType));" |
|
143 ); |
|
144 |
|
145 _LIT8( KCreateStoreRules, |
|
146 "CREATE TABLE StoreRules(" |
|
147 "StoreRuleId INTEGER NOT NULL," |
|
148 "Name TEXT NOT NULL," |
|
149 "Selected INTEGER," |
|
150 "Status INTEGER," |
|
151 "PRIMARY KEY(StoreRuleId));" |
|
152 ); |
|
153 |
|
154 _LIT8( KCreateStoreRuleParams, |
|
155 "CREATE TABLE StoreRuleParams(" |
|
156 "StoreRuleId INTEGER NOT NULL," |
|
157 "StoreRuleParamId INTEGER NOT NULL," |
|
158 "MediaType INTEGER," |
|
159 "PRIMARY KEY(StoreRuleParamId));" |
|
160 ); |
|
161 |
|
162 _LIT8( KCreateStoreRuleServers, |
|
163 "CREATE TABLE StoreRuleServers(" |
|
164 "StoreRuleId INTEGER NOT NULL," |
|
165 "MediaServerID INTEGER NOT NULL);" |
|
166 ); |
|
167 |
|
168 _LIT8( KCreateFillFiles, |
|
169 "CREATE TABLE FillFiles(" |
|
170 "FileId INTEGER NOT NULL," |
|
171 "PrimaryText TEXT NOT NULL," |
|
172 "SecondaryText TEXT," |
|
173 "Path TEXT," |
|
174 "Uri TEXT NOT NULL," |
|
175 "ItemId TEXT NOT NULL," |
|
176 "UpnpClass TEXT," |
|
177 "MediaType INTEGER," |
|
178 "Priority INTEGER,"// Highest priority is zero |
|
179 "Size INTEGER,"// In bytes |
|
180 "Status INTEGER," |
|
181 "Date DATETIME," |
|
182 "FillListId INTEGER NOT NULL," |
|
183 "MediaServerId INTEGER NOT NULL," |
|
184 "Selected INTEGER," |
|
185 "RefId INTEGER," |
|
186 "DriveId INTEGER," |
|
187 "DriveNumber INTEGER );" |
|
188 //"PRIMARY KEY(FileId));" |
|
189 ); |
|
190 |
|
191 _LIT8( KCreateStoreFiles, |
|
192 "CREATE TABLE StoreFiles(" |
|
193 "FileId INTEGER NOT NULL," |
|
194 "PrimaryText TEXT NOT NULL," |
|
195 "SecondaryText TEXT," |
|
196 "Path TEXT," |
|
197 "Size INTEGER," |
|
198 "Date DATETIME," |
|
199 "StoreListId INTEGER NOT NULL," |
|
200 "PRIMARY KEY(FileId));" |
|
201 ); |
|
202 |
|
203 _LIT8( KCreateStoreFileServers, |
|
204 "CREATE TABLE StoreFileServers(" |
|
205 "Fid INTEGER NOT NULL," |
|
206 "MediaServerId INTEGER NOT NULL," |
|
207 "Status INTEGER );" |
|
208 ); |
|
209 |
|
210 _LIT8( KCreateImageShrinkingInfo, |
|
211 "CREATE TABLE ImageShrinkingInfo(" |
|
212 "Count INTEGER," |
|
213 "Time INTEGER );" |
|
214 ); |
|
215 |
|
216 _LIT8( KCreateTransferInfo, |
|
217 "CREATE TABLE TransferInfo(" |
|
218 "Service INTEGER," |
|
219 "Count INTEGER," |
|
220 "Time INTEGER," |
|
221 "PRIMARY KEY(Service));" |
|
222 ); |
|
223 |
|
224 _LIT8( KCreateSyncTime, |
|
225 "CREATE TABLE SyncTime(" |
|
226 "Time DATETIME );" |
|
227 ); |
|
228 |
|
229 _LIT8( KCreateProgressInfo, |
|
230 "CREATE TABLE ProgressInfo(" |
|
231 "Trasferred INTEGER," |
|
232 "TotalCount INTEGER );" |
|
233 ); |
|
234 |
|
235 _LIT8( KCreateDrivesInfo, |
|
236 "CREATE TABLE DrivesInfo(" |
|
237 "DriveNumber INTEGER," |
|
238 "DriveType INTEGER," |
|
239 "DriveName TEXT," |
|
240 "Size INTEGER," |
|
241 "Quota INTEGER," |
|
242 "UsedQuota INTEGER," |
|
243 "UniqueId INTEGER," |
|
244 "Active INTEGER );" |
|
245 ); |
|
246 |
|
247 /////////////////////////////////////////////////////////////////// |
|
248 // CREATE CLAUSES FOR INDEXES |
|
249 /////////////////////////////////////////////////////////////////// |
|
250 _LIT8( KCreateStoreStatusIndex, |
|
251 "CREATE INDEX Store_status_index ON StoreFiles(Status);" |
|
252 ); |
|
253 |
|
254 _LIT8( KCreateFillStatusIndex, |
|
255 "CREATE INDEX Fill_status_index ON FillFiles(Status);" |
|
256 ); |
|
257 |
|
258 _LIT8( KCreateFillListIdIndex, |
|
259 "CREATE INDEX FillListIdIndex ON FillFiles(FillListId);" |
|
260 ); |
|
261 |
|
262 _LIT8( KCreateFillItemRefIndex, |
|
263 "CREATE INDEX FillList_Ref_Index ON FillFiles( FileId, " |
|
264 "RefId, Priority, Selected );" |
|
265 ); |
|
266 |
|
267 // Dropping indexes |
|
268 _LIT8( KDropStoreStatusIndex, |
|
269 "DROP INDEX Store_status_index;" |
|
270 ); |
|
271 |
|
272 _LIT8( KDropFillStatusIndex, |
|
273 "DROP INDEX Fill_status_index;" |
|
274 ); |
|
275 |
|
276 _LIT8( KDropFillListIdIndex, |
|
277 "DROP INDEX FillListIdIndex;" |
|
278 ); |
|
279 |
|
280 _LIT8( KDropFillItemRefIndex, |
|
281 "DROP INDEX FillList_Ref_Index;" |
|
282 ); |
|
283 |
|
284 #endif // __CMDMSQLMAINTENANCECLAUSES_H__ |
|
285 |
|
286 |
|