268 L"Corrupt INTEGER DEFAULT 0," |
268 L"Corrupt INTEGER DEFAULT 0," |
269 L"SaveDeletedRecordCount INTEGER DEFAULT 0)"); |
269 L"SaveDeletedRecordCount INTEGER DEFAULT 0)"); |
270 _LIT(KAuxiliaryDropTable,"DROP TABLE Auxiliary"); |
270 _LIT(KAuxiliaryDropTable,"DROP TABLE Auxiliary"); |
271 _LIT(KAuxiliaryCheckTable, "SELECT Id,Version,TimeRefreshed,TimeSynced,Corrupt,SaveDeletedRecordCount FROM AUXILIARY"); |
271 _LIT(KAuxiliaryCheckTable, "SELECT Id,Version,TimeRefreshed,TimeSynced,Corrupt,SaveDeletedRecordCount FROM AUXILIARY"); |
272 #ifdef ABSTRACTAUDIOALBUM_INCLUDED |
272 #ifdef ABSTRACTAUDIOALBUM_INCLUDED |
273 _LIT(KQueryAuxiliaryInsert, "INSERT INTO Auxiliary(Id,Version,Corrupt) VALUES(0,'6.5.0',%u)"); |
273 _LIT(KQueryAuxiliaryInsert, "INSERT INTO Auxiliary(Id,Version,Corrupt) VALUES(0,'6.6.0',%u)"); |
274 #else |
274 #else |
275 _LIT(KQueryAuxiliaryInsert, "INSERT INTO Auxiliary(Id,Version,Corrupt) VALUES(0,'6.4.0',%u)"); |
275 _LIT(KQueryAuxiliaryInsert, "INSERT INTO Auxiliary(Id,Version,Corrupt) VALUES(0,'6.6.1',%u)"); |
276 #endif // ABSTRACTAUDIOALBUM_INCLUDED |
276 #endif // ABSTRACTAUDIOALBUM_INCLUDED |
277 _LIT(KQueryAuxiliarySetTime, "UPDATE :dbname.Auxiliary SET TimeRefreshed='%S', Corrupt=0"); |
277 _LIT(KQueryAuxiliarySetTime, "UPDATE :dbname.Auxiliary SET TimeRefreshed='%S', Corrupt=0"); |
278 _LIT(KQueryAuxiliaryGetTime, "SELECT TimeRefreshed FROM :dbname.Auxiliary"); |
278 _LIT(KQueryAuxiliaryGetTime, "SELECT TimeRefreshed FROM :dbname.Auxiliary"); |
279 _LIT(KQueryAuxiliarySetCorrupt, "UPDATE :dbname.Auxiliary SET Corrupt=%u"); |
279 _LIT(KQueryAuxiliarySetCorrupt, "UPDATE :dbname.Auxiliary SET Corrupt=%u"); |
280 _LIT(KQueryAuxiliaryGetCorrupt, "SELECT Corrupt FROM :dbname.Auxiliary"); |
280 _LIT(KQueryAuxiliaryGetCorrupt, "SELECT Corrupt FROM :dbname.Auxiliary"); |
425 |
425 |
426 // == Album table queries ========================================== |
426 // == Album table queries ========================================== |
427 // |
427 // |
428 _LIT(KAlbumCreateTable,"CREATE TABLE Album(" |
428 _LIT(KAlbumCreateTable,"CREATE TABLE Album(" |
429 L"UniqueId INTEGER PRIMARY KEY," |
429 L"UniqueId INTEGER PRIMARY KEY," |
|
430 L"ArtistName TEXT COLLATE NOCASE," |
430 L"Name TEXT COLLATE NOCASE," |
431 L"Name TEXT COLLATE NOCASE," |
431 L"SongCount INTEGER," |
432 L"SongCount INTEGER," |
432 L"Artist INTEGER," |
433 L"Art TEXT)"); |
433 L"Art TEXT)"); |
434 |
434 |
435 _LIT(KAlbumCheckTable,"SELECT UniqueId,ArtistName,Name,SongCount,Art FROM Album"); |
435 _LIT(KAlbumCheckTable,"SELECT UniqueId,Name,SongCount,Artist,Art FROM Album"); |
436 |
436 |
437 _LIT(KQueryAlbumInsert, "INSERT INTO :dbname.Album(UniqueId,ArtistName,Name,SongCount,Art) VALUES(%u,'%S','%S',%u,'%S')"); |
437 _LIT(KQueryAlbumInsert, "INSERT INTO :dbname.Album(UniqueId,Name,SongCount,Artist,Art) VALUES(%u,'%S',%u,%u,'%S')"); |
|
438 _LIT(KQueryAlbumUpdate, "UPDATE :dbname.Album SET %S WHERE UniqueId=%u"); |
438 _LIT(KQueryAlbumUpdate, "UPDATE :dbname.Album SET %S WHERE UniqueId=%u"); |
439 |
439 |
440 _LIT(KQueryAlbumItem, "SELECT Album.*,Artist.Name FROM :dbname.Album,:dbname.Artist WHERE Album.Artist=Artist.UniqueId AND UniqueId=%u"); |
440 _LIT(KQueryAlbumItem, "SELECT Album.*,Artist.Name FROM :dbname.Album,:dbname.Artist WHERE Album.Artist=Artist.UniqueId AND UniqueId=%u"); |
441 _LIT(KQueryAlbumAll, "SELECT Album.*,Artist.Name FROM :dbname.Album,:dbname.Artist WHERE Album.Artist=Artist.UniqueId ORDER BY 2"); |
441 _LIT(KQueryAlbumAll, "SELECT Album.* FROM :dbname.Album ORDER BY Name"); |
442 _LIT(KQueryAlbumAllMediaWall, "SELECT Album.*,Artist.Name FROM :dbname.Album,:dbname.Artist WHERE Album.Artist=Artist.UniqueId ORDER BY 6"); |
442 _LIT(KQueryAlbumAllMediaWall, "SELECT Album.* FROM :dbname.Album ORDER BY ArtistName"); |
|
443 _LIT(KCriterionArtistName, "ArtistName='%S'"); |
|
444 _LIT(KCriterionArt, "Art='%S'"); |
|
445 |
443 // == Artist table queries ========================================== |
446 // == Artist table queries ========================================== |
444 // |
447 // |
445 _LIT(KArtistCreateTable,"CREATE TABLE Artist(" |
448 _LIT(KArtistCreateTable,"CREATE TABLE Artist(" |
446 L"UniqueId INTEGER PRIMARY KEY," |
449 L"UniqueId INTEGER PRIMARY KEY," |
447 L"Name TEXT COLLATE NOCASE," |
450 L"Name TEXT COLLATE NOCASE," |