equal
deleted
inserted
replaced
202 // rename thumb |
202 // rename thumb |
203 _LIT8( KThumbnailRename, "UPDATE ThumbnailInfo SET Path = :NewPath WHERE Path = :Path;" ); |
203 _LIT8( KThumbnailRename, "UPDATE ThumbnailInfo SET Path = :NewPath WHERE Path = :Path;" ); |
204 _LIT8( KThumbnailTempRename, "UPDATE TempThumbnailInfo SET Path = :NewPath WHERE Path = :Path;" ); |
204 _LIT8( KThumbnailTempRename, "UPDATE TempThumbnailInfo SET Path = :NewPath WHERE Path = :Path;" ); |
205 |
205 |
206 // reset blacklisted |
206 // reset blacklisted |
207 _LIT8( KThumbnailTouchBlacklistedRows, "UPDATE ThumbnailInfo SET Modified = 0 WHERE Flags & :Flag" ); |
207 _LIT8( KThumbnailTouchBlacklistedRows, "UPDATE ThumbnailInfo SET Flags = 4, Modified = 0 WHERE Flags & :Flag" ); |
208 |
208 |
209 // existence check |
209 // existence check |
210 _LIT8( KThumbnailSelectAllPaths, "SELECT ThumbnailInfo.RowID,Path FROM ThumbnailInfo " |
210 _LIT8( KThumbnailSelectAllPaths, "SELECT ThumbnailInfo.RowID,Path FROM ThumbnailInfo " |
211 "WHERE NOT EXISTS (SELECT Path FROM ThumbnailDeleted " |
211 "WHERE NOT EXISTS (SELECT Path FROM ThumbnailDeleted " |
212 "WHERE ThumbnailInfo.Path = ThumbnailDeleted.Path) " |
212 "WHERE ThumbnailInfo.Path = ThumbnailDeleted.Path) " |