· 6 years ago · Mar 28, 2019, 08:30 PM
12019-03-29 09:21:16.164875+1300 JC11[1029:308681] QUERY: PRAGMA journal_mode
22019-03-29 09:21:16.178316+1300 JC11[1029:308681] QUERY: PRAGMA journal_mode = PERSIST
32019-03-29 09:21:16.178420+1300 JC11[1029:308681] QUERY: PRAGMA journal_mode
42019-03-29 09:21:16.178511+1300 JC11[1029:308681] QUERY: PRAGMA foreign_keys = ON
52019-03-29 09:21:16.178661+1300 JC11[1029:308681] QUERY: SELECT uuid FROM Information WHERE id = ?
62019-03-29 09:21:16.180558+1300 JC11[1029:308681] QUERY: PRAGMA journal_mode
72019-03-29 09:21:16.181691+1300 JC11[1029:308681] QUERY: PRAGMA journal_mode = PERSIST
82019-03-29 09:21:16.181764+1300 JC11[1029:308681] QUERY: PRAGMA journal_mode
92019-03-29 09:21:16.181833+1300 JC11[1029:308681] QUERY: PRAGMA foreign_keys = ON
102019-03-29 09:21:16.181910+1300 JC11[1029:308681] QUERY: SELECT uuid FROM Information WHERE id = ?
112019-03-29 09:21:16.182603+1300 JC11[1029:308681] QUERY: SELECT 1
122019-03-29 09:21:16.182725+1300 JC11[1029:308681] QUERY: SELECT 1
132019-03-29 09:21:16.183235+1300 JC11[1029:308681] QUERY: SELECT schemaVersionMajor, schemaVersionMinor, schemaVersionPatch FROM Information WHERE id = ?
142019-03-29 09:21:16.183588+1300 JC11[1029:308681] QUERY: SELECT schemaVersionMajor, schemaVersionMinor, schemaVersionPatch FROM Information WHERE id = ?
152019-03-29 09:21:16.184889+1300 JC11[1029:308681] QUERY: PRAGMA journal_mode
162019-03-29 09:21:16.191579+1300 JC11[1029:308681] QUERY: PRAGMA journal_mode = PERSIST
172019-03-29 09:21:16.191661+1300 JC11[1029:308681] QUERY: PRAGMA journal_mode
182019-03-29 09:21:16.191736+1300 JC11[1029:308681] QUERY: PRAGMA foreign_keys = ON
192019-03-29 09:21:16.191807+1300 JC11[1029:308681] QUERY: SELECT uuid FROM Information WHERE id = ?
202019-03-29 09:21:16.193500+1300 JC11[1029:308681] QUERY: PRAGMA journal_mode
212019-03-29 09:21:16.194623+1300 JC11[1029:308681] QUERY: PRAGMA journal_mode = PERSIST
222019-03-29 09:21:16.194694+1300 JC11[1029:308681] QUERY: PRAGMA journal_mode
232019-03-29 09:21:16.194764+1300 JC11[1029:308681] QUERY: PRAGMA foreign_keys = ON
242019-03-29 09:21:16.194832+1300 JC11[1029:308681] QUERY: SELECT uuid FROM Information WHERE id = ?
252019-03-29 09:21:16.195433+1300 JC11[1029:308681] QUERY: SELECT 1
262019-03-29 09:21:16.195547+1300 JC11[1029:308681] QUERY: SELECT 1
272019-03-29 09:21:16.195806+1300 JC11[1029:308681] QUERY: SELECT schemaVersionMajor, schemaVersionMinor, schemaVersionPatch FROM Information WHERE id = ?
282019-03-29 09:21:16.195986+1300 JC11[1029:308681] QUERY: SELECT schemaVersionMajor, schemaVersionMinor, schemaVersionPatch FROM Information WHERE id = ?
292019-03-29 09:21:16.196772+1300 JC11[1029:308681] QUERY: PRAGMA journal_mode
302019-03-29 09:21:16.202227+1300 JC11[1029:308681] QUERY: PRAGMA journal_mode = PERSIST
312019-03-29 09:21:16.202292+1300 JC11[1029:308681] QUERY: PRAGMA journal_mode
322019-03-29 09:21:16.202350+1300 JC11[1029:308681] QUERY: PRAGMA foreign_keys = ON
332019-03-29 09:21:16.202432+1300 JC11[1029:308681] QUERY: SELECT uuid FROM Information WHERE id = ?
342019-03-29 09:21:16.202856+1300 JC11[1029:308681] QUERY: SELECT id, uuid, schemaVersionMajor, schemaVersionMinor, schemaVersionPatch, currentPlayedIndiciator, lastRekordBoxLibraryImportReadCounter FROM Information WHERE id = ?
352019-03-29 09:21:16.203920+1300 JC11[1029:308681] QUERY: UPDATE Information SET id = ? , uuid = ? , schemaVersionMajor = ? , schemaVersionMinor = ? , schemaVersionPatch = ? , currentPlayedIndiciator = ? , lastRekordBoxLibraryImportReadCounter = ? WHERE id = ?
362019-03-29 09:21:16.205654+1300 JC11[1029:308681] QUERY: SELECT 1
372019-03-29 09:21:16.206833+1300 JC11[1029:308681] QUERY: PRAGMA journal_mode
382019-03-29 09:21:16.207293+1300 JC11[1029:308681] QUERY: PRAGMA journal_mode = PERSIST
392019-03-29 09:21:16.207359+1300 JC11[1029:308681] QUERY: PRAGMA journal_mode
402019-03-29 09:21:16.207419+1300 JC11[1029:308681] QUERY: PRAGMA foreign_keys = ON
412019-03-29 09:21:16.207528+1300 JC11[1029:308681] QUERY: SELECT COUNT(*) FROM sqlite_master WHERE ( type='table' OR type='view' ) AND name=?
422019-03-29 09:21:16.208111+1300 JC11[1029:308681] QUERY: CREATE TABLE Track ( [id] INTEGER, [playOrder] INTEGER, [length] INTEGER, [lengthCalculated] INTEGER, [bpm] INTEGER, [year] INTEGER, [path] TEXT, [filename] TEXT, [bitrate] INTEGER, [bpmAnalyzed] REAL, [trackType] INTEGER, [isExternalTrack] NUMERIC, [uuidOfExternalDatabase] TEXT, [idTrackInExternalDatabase] INTEGER, [idAlbumArt] INTEGER, [pdbImportKey] INTEGER, PRIMARY KEY ( [id] ) , UNIQUE ([path]), FOREIGN KEY ( [idAlbumArt] ) REFERENCES AlbumArt ( [id] ) ON DELETE RESTRICT)
432019-03-29 09:21:16.212328+1300 JC11[1029:308681] QUERY: CREATE INDEX IF NOT EXISTS index_Track_id ON Track ( id )
442019-03-29 09:21:16.212672+1300 JC11[1029:308913] CoreAudio ( Line: 123 ): STOP()
452019-03-29 09:21:16.212910+1300 JC11[1029:308681] QUERY: CREATE INDEX IF NOT EXISTS index_Track_path ON Track ( path )
462019-03-29 09:21:16.213330+1300 JC11[1029:308681] QUERY: CREATE INDEX IF NOT EXISTS index_Track_filename ON Track ( filename )
472019-03-29 09:21:16.213849+1300 JC11[1029:308681] QUERY: CREATE INDEX IF NOT EXISTS index_Track_isExternalTrack ON Track ( isExternalTrack )
482019-03-29 09:21:16.214355+1300 JC11[1029:308681] QUERY: CREATE INDEX IF NOT EXISTS index_Track_uuidOfExternalDatabase ON Track ( uuidOfExternalDatabase )
492019-03-29 09:21:16.214738+1300 JC11[1029:308681] QUERY: CREATE INDEX IF NOT EXISTS index_Track_idTrackInExternalDatabase ON Track ( idTrackInExternalDatabase )
502019-03-29 09:21:16.215120+1300 JC11[1029:308681] QUERY: CREATE INDEX IF NOT EXISTS index_Track_idAlbumArt ON Track ( idAlbumArt )
512019-03-29 09:21:16.215569+1300 JC11[1029:308681] QUERY: SELECT COUNT(*) FROM sqlite_master WHERE ( type='table' OR type='view' ) AND name=?
522019-03-29 09:21:16.215781+1300 JC11[1029:308681] QUERY: CREATE TABLE Information ( [id] INTEGER, [uuid] TEXT, [schemaVersionMajor] INTEGER, [schemaVersionMinor] INTEGER, [schemaVersionPatch] INTEGER, [currentPlayedIndiciator] INTEGER, [lastRekordBoxLibraryImportReadCounter] INTEGER, PRIMARY KEY ( [id] ) )
532019-03-29 09:21:16.216306+1300 JC11[1029:308681] QUERY: CREATE INDEX IF NOT EXISTS index_Information_id ON Information ( id )
542019-03-29 09:21:16.216748+1300 JC11[1029:308681] QUERY: SELECT id, uuid, schemaVersionMajor, schemaVersionMinor, schemaVersionPatch, currentPlayedIndiciator, lastRekordBoxLibraryImportReadCounter FROM Information WHERE id = ?
552019-03-29 09:21:16.217101+1300 JC11[1029:308681] QUERY: INSERT INTO Information ( id, uuid, schemaVersionMajor, schemaVersionMinor, schemaVersionPatch, currentPlayedIndiciator, lastRekordBoxLibraryImportReadCounter ) VALUES ( ?, ?, ?, ?, ?, ?, ? )
562019-03-29 09:21:16.217534+1300 JC11[1029:308681] QUERY: SELECT COUNT(*) FROM sqlite_master WHERE ( type='table' OR type='view' ) AND name=?
572019-03-29 09:21:16.217743+1300 JC11[1029:308681] QUERY: CREATE TABLE MetaData ( [id] INTEGER, [type] INTEGER, [text] TEXT, PRIMARY KEY ( [id], [type] ) , FOREIGN KEY ( [id] ) REFERENCES Track ( [id] ) ON DELETE CASCADE)
58
592019-03-29 09:21:16.218361+1300 JC11[1029:308681] QUERY: CREATE INDEX IF NOT EXISTS index_MetaData_id ON MetaData ( id )
602019-03-29 09:21:16.218774+1300 JC11[1029:308681] QUERY: CREATE INDEX IF NOT EXISTS index_MetaData_type ON MetaData ( type )
612019-03-29 09:21:16.219155+1300 JC11[1029:308681] QUERY: CREATE INDEX IF NOT EXISTS index_MetaData_text ON MetaData ( text )
622019-03-29 09:21:16.219625+1300 JC11[1029:308681] QUERY: SELECT COUNT(*) FROM sqlite_master WHERE ( type='table' OR type='view' ) AND name=?
632019-03-29 09:21:16.219832+1300 JC11[1029:308681] QUERY: CREATE TABLE MetaDataInteger ( [id] INTEGER, [type] INTEGER, [value] INTEGER, PRIMARY KEY ( [id], [type] ) , FOREIGN KEY ( [id] ) REFERENCES Track ( [id] ) ON DELETE CASCADE)
642019-03-29 09:21:16.220416+1300 JC11[1029:308681] QUERY: CREATE INDEX IF NOT EXISTS index_MetaDataInteger_id ON MetaDataInteger ( id )
652019-03-29 09:21:16.220880+1300 JC11[1029:308681] QUERY: CREATE INDEX IF NOT EXISTS index_MetaDataInteger_type ON MetaDataInteger ( type )
662019-03-29 09:21:16.221421+1300 JC11[1029:308681] QUERY: CREATE INDEX IF NOT EXISTS index_MetaDataInteger_value ON MetaDataInteger ( value )
672019-03-29 09:21:16.221800+1300 JC11[1029:308681] QUERY: SELECT COUNT(*) FROM sqlite_master WHERE ( type='table' OR type='view' ) AND name=?
682019-03-29 09:21:16.221982+1300 JC11[1029:308681] QUERY: CREATE TABLE AlbumArt ( [id] INTEGER, [hash] TEXT, [albumArt] BLOB, PRIMARY KEY ( [id] ) )
692019-03-29 09:21:16.222361+1300 JC11[1029:308681] QUERY: CREATE INDEX IF NOT EXISTS index_AlbumArt_id ON AlbumArt ( id )
702019-03-29 09:21:16.222692+1300 JC11[1029:308681] QUERY: CREATE INDEX IF NOT EXISTS index_AlbumArt_hash ON AlbumArt ( hash )
712019-03-29 09:21:16.223035+1300 JC11[1029:308681] QUERY: SELECT COUNT(*) FROM sqlite_master WHERE ( type='table' OR type='view' ) AND name=?
722019-03-29 09:21:16.223217+1300 JC11[1029:308681] QUERY: CREATE TABLE CopiedTrack ( [trackId] INTEGER, [uuidOfSourceDatabase] TEXT, [idOfTrackInSourceDatabase] INTEGER, PRIMARY KEY ( [trackId] ) , FOREIGN KEY ( [trackId] ) REFERENCES Track ( [id] ) ON DELETE CASCADE)
732019-03-29 09:21:16.223623+1300 JC11[1029:308681] QUERY: CREATE INDEX IF NOT EXISTS index_CopiedTrack_trackId ON CopiedTrack ( trackId )
742019-03-29 09:21:16.224542+1300 JC11[1029:308681] QUERY: SELECT COUNT(*) FROM sqlite_master WHERE ( type='table' OR type='view' ) AND name=?
752019-03-29 09:21:16.224834+1300 JC11[1029:308681] QUERY: CREATE TABLE List ( [id] INTEGER, [type] INTEGER, [title] TEXT, [path] TEXT, [isFolder] NUMERIC, [trackCount] INTEGER, [ordering] INTEGER, PRIMARY KEY ( [id], [type] ) )
762019-03-29 09:21:16.225597+1300 JC11[1029:308681] QUERY: CREATE INDEX IF NOT EXISTS index_List_id ON List ( id )
772019-03-29 09:21:16.225970+1300 JC11[1029:308681] QUERY: CREATE INDEX IF NOT EXISTS index_List_type ON List ( type )
782019-03-29 09:21:16.226295+1300 JC11[1029:308681] QUERY: CREATE INDEX IF NOT EXISTS index_List_path ON List ( path )
792019-03-29 09:21:16.226736+1300 JC11[1029:308681] QUERY: CREATE INDEX IF NOT EXISTS index_List_ordering ON List ( ordering )
802019-03-29 09:21:16.227210+1300 JC11[1029:308681] QUERY: CREATE VIEW IF NOT EXISTS Playlist AS SELECT id, title FROM List WHERE type = 1
812019-03-29 09:21:16.227666+1300 JC11[1029:308681] QUERY: CREATE VIEW IF NOT EXISTS Historylist AS SELECT id, title FROM List WHERE type = 2
822019-03-29 09:21:16.228092+1300 JC11[1029:308681] QUERY: CREATE VIEW IF NOT EXISTS Preparelist AS SELECT id, title FROM List WHERE type = 3
832019-03-29 09:21:16.228515+1300 JC11[1029:308681] QUERY: CREATE VIEW IF NOT EXISTS Crate AS SELECT id AS id, title AS title, path AS path FROM List WHERE type = 4
842019-03-29 09:21:16.229323+1300 JC11[1029:308681] QUERY: SELECT COUNT(*) FROM sqlite_master WHERE ( type='table' OR type='view' ) AND name=?
852019-03-29 09:21:16.229560+1300 JC11[1029:308681] QUERY: CREATE TABLE ListTrackList ( [id] INTEGER, [listId] INTEGER, [listType] INTEGER, [trackId] INTEGER, [trackIdInOriginDatabase] INTEGER, [databaseUuid] TEXT, [trackNumber] INTEGER, PRIMARY KEY ( [id] ) , FOREIGN KEY ( [listId], [listType] ) REFERENCES List ( [id], [type] ) ON DELETE CASCADE, FOREIGN KEY ( [trackId] ) REFERENCES Track ( [id] ) ON DELETE CASCADE)
862019-03-29 09:21:16.230068+1300 JC11[1029:308681] QUERY: CREATE INDEX IF NOT EXISTS index_ListTrackList_listId ON ListTrackList ( listId )
872019-03-29 09:21:16.230629+1300 JC11[1029:308681] QUERY: CREATE INDEX IF NOT EXISTS index_ListTrackList_listType ON ListTrackList ( listType )
882019-03-29 09:21:16.231082+1300 JC11[1029:308681] QUERY: CREATE INDEX IF NOT EXISTS index_ListTrackList_trackId ON ListTrackList ( trackId )
892019-03-29 09:21:16.231595+1300 JC11[1029:308681] QUERY: CREATE VIEW IF NOT EXISTS PlaylistTrackList AS SELECT listId AS playlistId, trackId, trackIdInOriginDatabase, databaseUuid, trackNumber FROM ListTrackList AS ltl INNER JOIN List AS l ON l.id = ltl.listId AND l.type = ltl.listType WHERE ltl.listType = 1
902019-03-29 09:21:16.232210+1300 JC11[1029:308681] QUERY: CREATE VIEW IF NOT EXISTS HistorylistTrackList AS SELECT listId AS historylistId, trackId, trackIdInOriginDatabase, databaseUuid, 0 AS date FROM ListTrackList AS ltl INNER JOIN List AS l ON l.id = ltl.listId AND l.type = ltl.listType WHERE ltl.listType = 2
912019-03-29 09:21:16.232777+1300 JC11[1029:308681] QUERY: CREATE VIEW IF NOT EXISTS PreparelistTrackList AS SELECT listId AS playlistId, trackId, trackIdInOriginDatabase, databaseUuid, trackNumber FROM ListTrackList AS ltl INNER JOIN List AS l ON l.id = ltl.listId AND l.type = ltl.listType WHERE ltl.listType = 3
922019-03-29 09:21:16.233327+1300 JC11[1029:308681] QUERY: CREATE VIEW IF NOT EXISTS CrateTrackList AS SELECT listId AS crateId, trackId AS trackId FROM ListTrackList AS ltl INNER JOIN List AS l ON l.id = ltl.listId AND l.type = ltl.listType WHERE ltl.listType = 4
932019-03-29 09:21:16.233889+1300 JC11[1029:308681] QUERY: CREATE TRIGGER IF NOT EXISTS trigger_delete_Playlist INSTEAD OF DELETE ON Playlist FOR EACH ROW BEGIN DELETE FROM List WHERE type = 1 AND OLD.id = id AND OLD.title = title; END
942019-03-29 09:21:16.234330+1300 JC11[1029:308681] QUERY: CREATE TRIGGER IF NOT EXISTS trigger_update_Playlist INSTEAD OF UPDATE ON Playlist FOR EACH ROW BEGIN UPDATE List SET id = NEW.id, title = NEW.title WHERE id = OLD.id AND title = OLD.title ; END
952019-03-29 09:21:16.234795+1300 JC11[1029:308681] QUERY: CREATE TRIGGER IF NOT EXISTS trigger_delete_Historylist INSTEAD OF DELETE ON Historylist FOR EACH ROW BEGIN DELETE FROM List WHERE type = 2 AND OLD.id = id AND OLD.title = title; END
962019-03-29 09:21:16.235244+1300 JC11[1029:308681] QUERY: CREATE TRIGGER IF NOT EXISTS trigger_update_Historylist INSTEAD OF UPDATE ON Historylist FOR EACH ROW BEGIN UPDATE List SET id = NEW.id, title = NEW.title WHERE id = OLD.id AND title = OLD.title ; END
972019-03-29 09:21:16.235728+1300 JC11[1029:308681] QUERY: CREATE TRIGGER IF NOT EXISTS trigger_delete_Preparelist INSTEAD OF DELETE ON Preparelist FOR EACH ROW BEGIN DELETE FROM List WHERE type = 3 AND OLD.id = id AND OLD.title = title; END
982019-03-29 09:21:16.236161+1300 JC11[1029:308681] QUERY: CREATE TRIGGER IF NOT EXISTS trigger_update_Preparelist INSTEAD OF UPDATE ON Preparelist FOR EACH ROW BEGIN UPDATE List SET id = NEW.id, title = NEW.title WHERE id = OLD.id AND title = OLD.title ; END
992019-03-29 09:21:16.236661+1300 JC11[1029:308681] QUERY: CREATE TRIGGER IF NOT EXISTS trigger_delete_Crate INSTEAD OF DELETE ON Crate FOR EACH ROW BEGIN DELETE FROM List WHERE type = 4 AND OLD.id = id AND OLD.title = title AND OLD.path = path; END
1002019-03-29 09:21:16.237231+1300 JC11[1029:308681] QUERY: CREATE TRIGGER IF NOT EXISTS trigger_update_Crate INSTEAD OF UPDATE ON Crate FOR EACH ROW BEGIN UPDATE List SET id = NEW.id, title = NEW.title, path = NEW.path WHERE id = OLD.id AND title = OLD.title AND path = OLD.path ; END
1012019-03-29 09:21:16.237888+1300 JC11[1029:308681] QUERY: CREATE TRIGGER IF NOT EXISTS trigger_insert_Playlist INSTEAD OF INSERT ON Playlist FOR EACH ROW BEGIN INSERT INTO List ( id, type, title, path, isFolder, trackCount, ordering ) VALUES ( NEW.id, 1, NEW.title, NEW.title || ";", 0, 0, NEW.id ) ; INSERT INTO ListParentList ( listOriginId, listOriginType, listParentId, listParentType ) VALUES ( NEW.id, 1, NEW.id, 1 ) ; END
1022019-03-29 09:21:16.238570+1300 JC11[1029:308681] QUERY: CREATE TRIGGER IF NOT EXISTS trigger_insert_Historylist INSTEAD OF INSERT ON Historylist FOR EACH ROW BEGIN INSERT INTO List ( id, type, title, path, isFolder, trackCount, ordering ) VALUES ( NEW.id, 2, NEW.title, NEW.title || ";", 0, 0, NEW.id ) ; INSERT INTO ListParentList ( listOriginId, listOriginType, listParentId, listParentType ) VALUES ( NEW.id, 2, NEW.id, 2 ) ; END
1032019-03-29 09:21:16.239149+1300 JC11[1029:308681] QUERY: CREATE TRIGGER IF NOT EXISTS trigger_insert_Preparelist INSTEAD OF INSERT ON Preparelist FOR EACH ROW BEGIN INSERT INTO List ( id, type, title, path, isFolder, trackCount, ordering ) VALUES ( NEW.id, 3, NEW.title, NEW.title || ";", 0, 0, NEW.id ) ; INSERT INTO ListParentList ( listOriginId, listOriginType, listParentId, listParentType ) VALUES ( NEW.id, 3, NEW.id, 3 ) ; END
1042019-03-29 09:21:16.239694+1300 JC11[1029:308681] QUERY: CREATE TRIGGER IF NOT EXISTS trigger_insert_Crate INSTEAD OF INSERT ON Crate FOR EACH ROW BEGIN INSERT INTO List ( id, type, title, path, isFolder, trackCount, ordering ) VALUES ( NEW.id, 4, NEW.title, NEW.path, 0, 0, NEW.id ) ; END
1052019-03-29 09:21:16.240144+1300 JC11[1029:308681] QUERY: CREATE TRIGGER IF NOT EXISTS trigger_insert_order_update_List AFTER INSERT ON List FOR EACH ROW WHEN NEW.ordering IS NULL BEGIN UPDATE List SET ordering = (SELECT IFNULL(MAX(ordering) + 1, 1) FROM List ) WHERE id = NEW.id AND type = NEW.type; END
1062019-03-29 09:21:16.240665+1300 JC11[1029:308681] QUERY: CREATE TRIGGER IF NOT EXISTS trigger_after_insert_List AFTER INSERT ON List FOR EACH ROW BEGIN UPDATE List SET trackCount = 0 WHERE id = NEW.id AND type = NEW.type AND trackCount IS NULL ;END
1072019-03-29 09:21:16.241174+1300 JC11[1029:308681] QUERY: CREATE TRIGGER IF NOT EXISTS trigger_track_added_to_ListTrackList AFTER INSERT ON ListTrackList FOR EACH ROW BEGIN UPDATE List SET trackCount = trackCount + 1 WHERE id = NEW.listId AND type = NEW.listType; END
1082019-03-29 09:21:16.241591+1300 JC11[1029:308681] QUERY: CREATE TRIGGER IF NOT EXISTS trigger_track_removed_from_ListTrackList AFTER DELETE ON ListTrackList FOR EACH ROW BEGIN UPDATE List SET trackCount = trackCount - 1 WHERE id = OLD.listId AND type = OLD.listType; END
1092019-03-29 09:21:16.242015+1300 JC11[1029:308681] QUERY: CREATE TRIGGER IF NOT EXISTS trigger_insert_order_update_List AFTER INSERT ON List FOR EACH ROW WHEN NEW.ordering IS NULL BEGIN UPDATE List SET ordering = (SELECT IFNULL(MAX(ordering) + 1, 1) FROM List ) WHERE id = NEW.id AND type = NEW.type; END
1102019-03-29 09:21:16.242226+1300 JC11[1029:308681] QUERY: CREATE TRIGGER IF NOT EXISTS trigger_delete_PlaylistTrackList INSTEAD OF DELETE ON PlaylistTrackList FOR EACH ROW BEGIN DELETE FROM ListTrackList WHERE listType = 1 AND OLD.playlistId = listId AND OLD.trackId = trackId AND OLD.trackIdInOriginDatabase = trackIdInOriginDatabase AND OLD.databaseUuid = databaseUuid AND OLD.trackNumber = trackNumber; END
1112019-03-29 09:21:16.242720+1300 JC11[1029:308681] QUERY: CREATE TRIGGER IF NOT EXISTS trigger_update_PlaylistTrackList INSTEAD OF UPDATE ON PlaylistTrackList FOR EACH ROW BEGIN UPDATE ListTrackList SET listId = NEW.playlistId , trackId = NEW.trackId , trackIdInOriginDatabase = NEW.trackIdInOriginDatabase , databaseUuid = NEW.databaseUuid , trackNumber = NEW.trackNumber WHERE listType = 1 AND OLD.playlistId = listId AND OLD.trackId = trackId AND OLD.trackIdInOriginDatabase = trackIdInOriginDatabase AND OLD.databaseUuid = databaseUuid AND OLD.trackNumber = trackNumber ; END
1122019-03-29 09:21:16.243358+1300 JC11[1029:308681] QUERY: CREATE TRIGGER IF NOT EXISTS trigger_insert_PlaylistTrackList INSTEAD OF INSERT ON PlaylistTrackList FOR EACH ROW BEGIN INSERT INTO ListTrackList ( listId, listType, trackId, trackIdInOriginDatabase, databaseUuid, trackNumber ) SELECT NEW.playlistId, 1, NEW.trackId, NEW.trackIdInOriginDatabase, NEW.databaseUuid, NEW.trackNumber FROM List AS l WHERE l.id = NEW.playlistId AND l.type = 1 AND l.isFolder = 0 ; END
1132019-03-29 09:21:16.244060+1300 JC11[1029:308681] QUERY: CREATE TRIGGER IF NOT EXISTS trigger_delete_HistorylistTrackList INSTEAD OF DELETE ON HistorylistTrackList FOR EACH ROW BEGIN DELETE FROM ListTrackList WHERE listType = 2 AND OLD.historylistId = listId AND OLD.trackId = trackId AND OLD.trackIdInOriginDatabase = trackIdInOriginDatabase AND OLD.databaseUuid = databaseUuid; END
1142019-03-29 09:21:16.244639+1300 JC11[1029:308681] QUERY: CREATE TRIGGER IF NOT EXISTS trigger_update_HistorylistTrackList INSTEAD OF UPDATE ON HistorylistTrackList FOR EACH ROW BEGIN UPDATE ListTrackList SET listId = NEW.historylistId , trackId = NEW.trackId , trackIdInOriginDatabase = NEW.trackIdInOriginDatabase , databaseUuid = NEW.databaseUuid WHERE listType = 2 AND OLD.historylistId = listId AND OLD.trackId = trackId AND OLD.trackIdInOriginDatabase = trackIdInOriginDatabase AND OLD.databaseUuid = databaseUuid ; END
1152019-03-29 09:21:16.245160+1300 JC11[1029:308681] QUERY: CREATE TRIGGER IF NOT EXISTS trigger_insert_HistorylistTrackList INSTEAD OF INSERT ON HistorylistTrackList FOR EACH ROW BEGIN INSERT INTO ListTrackList ( listId, listType, trackId, trackIdInOriginDatabase, databaseUuid, trackNumber ) SELECT NEW.historylistId, 2, NEW.trackId, NEW.trackIdInOriginDatabase, NEW.databaseUuid, 0 FROM List AS l WHERE l.id = NEW.historylistId AND l.type = 2 AND l.isFolder = 0 ; END
1162019-03-29 09:21:16.245709+1300 JC11[1029:308681] QUERY: CREATE TRIGGER IF NOT EXISTS trigger_delete_PreparelistTrackList INSTEAD OF DELETE ON PreparelistTrackList FOR EACH ROW BEGIN DELETE FROM ListTrackList WHERE listType = 3 AND OLD.playlistId = listId AND OLD.trackId = trackId AND OLD.trackIdInOriginDatabase = trackIdInOriginDatabase AND OLD.databaseUuid = databaseUuid AND OLD.trackNumber = trackNumber; END
1172019-03-29 09:21:16.246186+1300 JC11[1029:308681] QUERY: CREATE TRIGGER IF NOT EXISTS trigger_update_PreparelistTrackList INSTEAD OF UPDATE ON PreparelistTrackList FOR EACH ROW BEGIN UPDATE ListTrackList SET listId = NEW.playlistId , trackId = NEW.trackId , trackIdInOriginDatabase = NEW.trackIdInOriginDatabase , databaseUuid = NEW.databaseUuid , trackNumber = NEW.trackNumber WHERE listType = 3 AND OLD.playlistId = listId AND OLD.trackId = trackId AND OLD.trackIdInOriginDatabase = trackIdInOriginDatabase AND OLD.databaseUuid = databaseUuid AND OLD.trackNumber = trackNumber ; END
1182019-03-29 09:21:16.246828+1300 JC11[1029:308681] QUERY: CREATE TRIGGER IF NOT EXISTS trigger_insert_PreparelistTrackList INSTEAD OF INSERT ON PreparelistTrackList FOR EACH ROW BEGIN INSERT INTO ListTrackList ( listId, listType, trackId, trackIdInOriginDatabase, databaseUuid, trackNumber ) SELECT NEW.playlistId, 3, NEW.trackId, NEW.trackIdInOriginDatabase, NEW.databaseUuid, NEW.trackNumber FROM List AS l WHERE l.id = NEW.playlistId AND l.type = 3 AND l.isFolder = 0 ; END
1192019-03-29 09:21:16.247481+1300 JC11[1029:308681] QUERY: CREATE TRIGGER IF NOT EXISTS trigger_delete_CrateTrackList INSTEAD OF DELETE ON CrateTrackList FOR EACH ROW BEGIN DELETE FROM ListTrackList WHERE listType = 4 AND OLD.crateId = listId AND OLD.trackId = trackId; END
1202019-03-29 09:21:16.248184+1300 JC11[1029:308681] QUERY: CREATE TRIGGER IF NOT EXISTS trigger_insert_CrateTrackList INSTEAD OF INSERT ON CrateTrackList FOR EACH ROW BEGIN INSERT INTO ListTrackList ( listId, listType, trackId, trackIdInOriginDatabase, databaseUuid, trackNumber ) VALUES ( NEW.crateId, 4, NEW.trackId, 0, 0, 0 ) ; END
1212019-03-29 09:21:16.248753+1300 JC11[1029:308681] QUERY: SELECT COUNT(*) FROM sqlite_master WHERE ( type='table' OR type='view' ) AND name=?
1222019-03-29 09:21:16.249019+1300 JC11[1029:308681] QUERY: CREATE TABLE ListHierarchy ( [listId] INTEGER, [listType] INTEGER, [listIdChild] INTEGER, [listTypeChild] INTEGER, FOREIGN KEY ( [listId], [listType] ) REFERENCES List ( [id], [type] ) ON DELETE CASCADE, FOREIGN KEY ( [listIdChild], [listTypeChild] ) REFERENCES List ( [id], [type] ) ON DELETE CASCADE)
1232019-03-29 09:21:16.249524+1300 JC11[1029:308681] QUERY: CREATE INDEX IF NOT EXISTS index_ListHierarchy_listId ON ListHierarchy ( listId )
1242019-03-29 09:21:16.249968+1300 JC11[1029:308681] QUERY: CREATE INDEX IF NOT EXISTS index_ListHierarchy_listType ON ListHierarchy ( listType )
1252019-03-29 09:21:16.250309+1300 JC11[1029:308681] QUERY: CREATE INDEX IF NOT EXISTS index_ListHierarchy_listIdChild ON ListHierarchy ( listIdChild )
1262019-03-29 09:21:16.250649+1300 JC11[1029:308681] QUERY: CREATE INDEX IF NOT EXISTS index_ListHierarchy_listTypeChild ON ListHierarchy ( listTypeChild )
1272019-03-29 09:21:16.251022+1300 JC11[1029:308681] QUERY: CREATE VIEW IF NOT EXISTS CrateHierarchy AS SELECT listId AS crateId, listIdChild AS crateIdChild FROM ListHierarchy WHERE listType = 4 AND listTypeChild = 4
1282019-03-29 09:21:16.251456+1300 JC11[1029:308681] QUERY: CREATE TRIGGER IF NOT EXISTS trigger_delete_CrateHierarchy INSTEAD OF DELETE ON CrateHierarchy FOR EACH ROW BEGIN DELETE FROM ListHierarchy WHERE listId = OLD.crateId AND listType = 4 AND listIdChild = OLD.crateIdChild AND listTypeChild = 4 ; END
1292019-03-29 09:21:16.251913+1300 JC11[1029:308681] QUERY: CREATE TRIGGER IF NOT EXISTS trigger_insert_CrateHierarchy INSTEAD OF INSERT ON CrateHierarchy FOR EACH ROW BEGIN INSERT INTO ListHierarchy ( listId, listType, listIdChild, listTypeChild ) VALUES ( NEW.crateId, 4, NEW.crateIdChild, 4 ) ; END
1302019-03-29 09:21:16.252422+1300 JC11[1029:308681] QUERY: SELECT COUNT(*) FROM sqlite_master WHERE ( type='table' OR type='view' ) AND name=?
1312019-03-29 09:21:16.252646+1300 JC11[1029:308681] QUERY: CREATE TABLE ListParentList ( [listOriginId] INTEGER, [listOriginType] INTEGER, [listParentId] INTEGER, [listParentType] INTEGER, FOREIGN KEY ( [listOriginId], [listOriginType] ) REFERENCES List ( [id], [type] ) ON DELETE CASCADE, FOREIGN KEY ( [listParentId], [listParentType] ) REFERENCES List ( [id], [type] ) ON DELETE CASCADE)
1322019-03-29 09:21:16.253152+1300 JC11[1029:308681] QUERY: CREATE INDEX IF NOT EXISTS index_ListParentList_listOriginId ON ListParentList ( listOriginId )
1332019-03-29 09:21:16.253515+1300 JC11[1029:308681] QUERY: CREATE INDEX IF NOT EXISTS index_ListParentList_listOriginType ON ListParentList ( listOriginType )
1342019-03-29 09:21:16.253854+1300 JC11[1029:308681] QUERY: CREATE INDEX IF NOT EXISTS index_ListParentList_listParentId ON ListParentList ( listParentId )
1352019-03-29 09:21:16.254184+1300 JC11[1029:308681] QUERY: CREATE INDEX IF NOT EXISTS index_ListParentList_listParentType ON ListParentList ( listParentType )
1362019-03-29 09:21:16.254551+1300 JC11[1029:308681] QUERY: CREATE VIEW IF NOT EXISTS CrateParentList AS SELECT listOriginId AS crateOriginId, listParentId AS crateParentId FROM ListParentList WHERE listOriginType = 4 AND listParentType = 4
1372019-03-29 09:21:16.255017+1300 JC11[1029:308681] QUERY: CREATE TRIGGER IF NOT EXISTS trigger_delete_CrateParentList INSTEAD OF DELETE ON CrateParentList FOR EACH ROW BEGIN DELETE FROM ListParentList WHERE OLD.crateOriginId = listOriginId AND listOriginType = 4 AND OLD.crateParentId = listParentId AND listParentType = 4; END
1382019-03-29 09:21:16.255503+1300 JC11[1029:308681] QUERY: CREATE TRIGGER IF NOT EXISTS trigger_insert_CrateParentList INSTEAD OF INSERT ON CrateParentList FOR EACH ROW BEGIN INSERT INTO ListParentList ( listOriginId, listOriginType, listParentId, listParentType ) VALUES ( NEW.crateOriginId, 4, NEW.crateParentId, 4 ) ; END
1392019-03-29 09:21:16.255973+1300 JC11[1029:308681] QUERY: SELECT COUNT(*) FROM sqlite_master WHERE ( type='table' OR type='view' ) AND name=?
1402019-03-29 09:21:16.256201+1300 JC11[1029:308681] QUERY: CREATE TABLE InternalDatabase ( [uuid] TEXT, [name] TEXT, PRIMARY KEY ( [uuid] ) )
1412019-03-29 09:21:16.256755+1300 JC11[1029:308681] QUERY: CREATE INDEX IF NOT EXISTS index_InternalDatabase_uuid ON InternalDatabase ( uuid )
1422019-03-29 09:21:16.257152+1300 JC11[1029:308681] QUERY: SELECT uuid FROM Information WHERE id = ?
1432019-03-29 09:21:16.257608+1300 JC11[1029:308681] QUERY: PRAGMA journal_mode
1442019-03-29 09:21:16.257958+1300 JC11[1029:308681] QUERY: PRAGMA journal_mode = PERSIST
1452019-03-29 09:21:16.258005+1300 JC11[1029:308681] QUERY: PRAGMA journal_mode
1462019-03-29 09:21:16.258047+1300 JC11[1029:308681] QUERY: PRAGMA foreign_keys = ON
1472019-03-29 09:21:16.258112+1300 JC11[1029:308681] QUERY: SELECT COUNT(*) FROM sqlite_master WHERE ( type='table' OR type='view' ) AND name=?
1482019-03-29 09:21:16.258257+1300 JC11[1029:308681] QUERY: CREATE TABLE PerformanceData ( [id] INTEGER, [isAnalyzed] NUMERIC, [isRendered] NUMERIC, [trackData] BLOB, [highResolutionWaveFormData] BLOB, [overviewWaveFormData] BLOB, [beatData] BLOB, [quickCues] BLOB, [loops] BLOB, [hasSeratoValues] NUMERIC, [hasRekordboxValues] NUMERIC, [hasTraktorValues] NUMERIC, PRIMARY KEY ( [id] ) )
1492019-03-29 09:21:16.259321+1300 JC11[1029:308681] QUERY: CREATE INDEX IF NOT EXISTS index_PerformanceData_id ON PerformanceData ( id )
1502019-03-29 09:21:16.259734+1300 JC11[1029:308681] QUERY: SELECT COUNT(*) FROM sqlite_master WHERE ( type='table' OR type='view' ) AND name=?
1512019-03-29 09:21:16.259871+1300 JC11[1029:308681] QUERY: CREATE TABLE Information ( [id] INTEGER, [uuid] TEXT, [schemaVersionMajor] INTEGER, [schemaVersionMinor] INTEGER, [schemaVersionPatch] INTEGER, [currentPlayedIndiciator] INTEGER, [lastRekordBoxLibraryImportReadCounter] INTEGER, PRIMARY KEY ( [id] ) )
1522019-03-29 09:21:16.260340+1300 JC11[1029:308681] QUERY: CREATE INDEX IF NOT EXISTS index_Information_id ON Information ( id )
1532019-03-29 09:21:16.260669+1300 JC11[1029:308681] QUERY: SELECT id, uuid, schemaVersionMajor, schemaVersionMinor, schemaVersionPatch, currentPlayedIndiciator, lastRekordBoxLibraryImportReadCounter FROM Information WHERE id = ?
1542019-03-29 09:21:16.260888+1300 JC11[1029:308681] QUERY: INSERT INTO Information ( id, uuid, schemaVersionMajor, schemaVersionMinor, schemaVersionPatch, currentPlayedIndiciator, lastRekordBoxLibraryImportReadCounter ) VALUES ( ?, ?, ?, ?, ?, ?, ? )
1552019-03-29 09:21:16.261173+1300 JC11[1029:308681] QUERY: SELECT uuid FROM Information WHERE id = ?
1562019-03-29 09:21:16.261275+1300 JC11[1029:308681] QUERY: SELECT 1
1572019-03-29 09:21:16.261340+1300 JC11[1029:308681] QUERY: SELECT 1
1582019-03-29 09:21:16.261534+1300 JC11[1029:308681] QUERY: SELECT schemaVersionMajor, schemaVersionMinor, schemaVersionPatch FROM Information WHERE id = ?
1592019-03-29 09:21:16.261637+1300 JC11[1029:308681] QUERY: SELECT schemaVersionMajor, schemaVersionMinor, schemaVersionPatch FROM Information WHERE id = ?
1602019-03-29 09:21:16.262076+1300 JC11[1029:308681] QUERY: PRAGMA journal_mode
1612019-03-29 09:21:16.265903+1300 JC11[1029:308681] QUERY: PRAGMA journal_mode = PERSIST
1622019-03-29 09:21:16.265952+1300 JC11[1029:308681] QUERY: PRAGMA journal_mode
1632019-03-29 09:21:16.265995+1300 JC11[1029:308681] QUERY: PRAGMA foreign_keys = ON
1642019-03-29 09:21:16.266043+1300 JC11[1029:308681] QUERY: SELECT uuid FROM Information WHERE id = ?
1652019-03-29 09:21:16.266443+1300 JC11[1029:308681] QUERY: DELETE FROM Track
1662019-03-29 09:21:16.266887+1300 JC11[1029:308681] QUERY: DELETE FROM MetaData
1672019-03-29 09:21:16.267074+1300 JC11[1029:308681] QUERY: DELETE FROM MetaDataInteger
1682019-03-29 09:21:16.267248+1300 JC11[1029:308681] QUERY: DELETE FROM AlbumArt
1692019-03-29 09:21:16.267468+1300 JC11[1029:308681] QUERY: DELETE FROM CopiedTrack
1702019-03-29 09:21:16.267698+1300 JC11[1029:308681] QUERY: DELETE FROM ListHierarchy
1712019-03-29 09:21:16.267924+1300 JC11[1029:308681] QUERY: DELETE FROM ListParentList
1722019-03-29 09:21:16.268112+1300 JC11[1029:308681] QUERY: DELETE FROM List WHERE type = ?
1732019-03-29 09:21:16.268617+1300 JC11[1029:308681] QUERY: DELETE FROM ListTrackList WHERE listType = ?
1742019-03-29 09:21:16.268812+1300 JC11[1029:308681] QUERY: DELETE FROM List WHERE type = ?
1752019-03-29 09:21:16.269210+1300 JC11[1029:308681] QUERY: DELETE FROM ListTrackList WHERE listType = ?
1762019-03-29 09:21:16.269382+1300 JC11[1029:308681] QUERY: DELETE FROM List WHERE type = ?
1772019-03-29 09:21:16.269781+1300 JC11[1029:308681] QUERY: DELETE FROM ListTrackList WHERE listType = ?
1782019-03-29 09:21:16.269953+1300 JC11[1029:308681] QUERY: DELETE FROM List WHERE type = ?
1792019-03-29 09:21:16.270348+1300 JC11[1029:308681] QUERY: DELETE FROM ListTrackList WHERE listType = ?
1802019-03-29 09:21:16.270521+1300 JC11[1029:308681] QUERY: DELETE FROM List WHERE type = ?
1812019-03-29 09:21:16.270906+1300 JC11[1029:308681] QUERY: DELETE FROM ListTrackList WHERE listType = ?
1822019-03-29 09:21:16.271106+1300 JC11[1029:308681] QUERY: DELETE FROM PerformanceData
1832019-03-29 09:21:16.271718+1300 JC11[1029:308681] QUERY: SELECT 1
1842019-03-29 09:21:16.272440+1300 JC11[1029:308681] QUERY: PRAGMA journal_mode
1852019-03-29 09:21:16.277878+1300 JC11[1029:308681] QUERY: PRAGMA journal_mode = PERSIST
1862019-03-29 09:21:16.277952+1300 JC11[1029:308681] QUERY: PRAGMA journal_mode
1872019-03-29 09:21:16.278011+1300 JC11[1029:308681] QUERY: PRAGMA foreign_keys = ON
1882019-03-29 09:21:16.278071+1300 JC11[1029:308681] QUERY: SELECT uuid FROM Information WHERE id = ?
1892019-03-29 09:21:16.279537+1300 JC11[1029:308681] QUERY: PRAGMA journal_mode
1902019-03-29 09:21:16.280533+1300 JC11[1029:308681] QUERY: PRAGMA journal_mode = PERSIST
1912019-03-29 09:21:16.280584+1300 JC11[1029:308681] QUERY: PRAGMA journal_mode
1922019-03-29 09:21:16.280635+1300 JC11[1029:308681] QUERY: PRAGMA foreign_keys = ON
1932019-03-29 09:21:16.280687+1300 JC11[1029:308681] QUERY: SELECT uuid FROM Information WHERE id = ?
1942019-03-29 09:21:16.281100+1300 JC11[1029:308681] QUERY: SELECT 1
1952019-03-29 09:21:16.281185+1300 JC11[1029:308681] QUERY: SELECT 1
1962019-03-29 09:21:16.281416+1300 JC11[1029:308681] QUERY: SELECT schemaVersionMajor, schemaVersionMinor, schemaVersionPatch FROM Information WHERE id = ?
1972019-03-29 09:21:16.281659+1300 JC11[1029:308681] QUERY: SELECT schemaVersionMajor, schemaVersionMinor, schemaVersionPatch FROM Information WHERE id = ?
1982019-03-29 09:21:16.282641+1300 JC11[1029:308681] QUERY: PRAGMA journal_mode
1992019-03-29 09:21:16.287934+1300 JC11[1029:308681] QUERY: PRAGMA journal_mode = PERSIST
2002019-03-29 09:21:16.288010+1300 JC11[1029:308681] QUERY: PRAGMA journal_mode
2012019-03-29 09:21:16.288064+1300 JC11[1029:308681] QUERY: PRAGMA foreign_keys = ON
2022019-03-29 09:21:16.288119+1300 JC11[1029:308681] QUERY: SELECT uuid FROM Information WHERE id = ?
2032019-03-29 09:21:16.289623+1300 JC11[1029:308681] QUERY: PRAGMA journal_mode
2042019-03-29 09:21:16.290421+1300 JC11[1029:308681] QUERY: PRAGMA journal_mode = PERSIST
2052019-03-29 09:21:16.290475+1300 JC11[1029:308681] QUERY: PRAGMA journal_mode
2062019-03-29 09:21:16.290526+1300 JC11[1029:308681] QUERY: PRAGMA foreign_keys = ON
2072019-03-29 09:21:16.290580+1300 JC11[1029:308681] QUERY: SELECT uuid FROM Information WHERE id = ?
2082019-03-29 09:21:16.291000+1300 JC11[1029:308681] QUERY: SELECT 1
2092019-03-29 09:21:16.291097+1300 JC11[1029:308681] QUERY: SELECT 1
2102019-03-29 09:21:16.291300+1300 JC11[1029:308681] QUERY: SELECT schemaVersionMajor, schemaVersionMinor, schemaVersionPatch FROM Information WHERE id = ?
2112019-03-29 09:21:16.291563+1300 JC11[1029:308681] QUERY: SELECT schemaVersionMajor, schemaVersionMinor, schemaVersionPatch FROM Information WHERE id = ?
2122019-03-29 09:21:16.297998+1300 JC11[1029:308681] QUERY: SELECT t.id, t.type, t.title, t.path, t.isFolder, t.trackCount, t.ordering FROM List as t WHERE type = ? ORDER BY id ASC
2132019-03-29 09:21:16.300322+1300 JC11[1029:308913] CoreAudio ( Line: 123 ): STOP()
2142019-03-29 09:21:16.301907+1300 JC11[1029:309005] QUERY: SELECT t.id, t.type, t.title, t.path, t.isFolder, t.trackCount, t.ordering FROM List as t WHERE id = ? AND type = ?
2152019-03-29 09:21:16.303069+1300 JC11[1029:309005] QUERY: PRAGMA journal_mode
2162019-03-29 09:21:16.357777+1300 JC11[1029:309005] QUERY: PRAGMA journal_mode = PERSIST
2172019-03-29 09:21:16.357885+1300 JC11[1029:309005] QUERY: PRAGMA journal_mode
2182019-03-29 09:21:16.357965+1300 JC11[1029:309005] QUERY: PRAGMA foreign_keys = ON
2192019-03-29 09:21:16.358051+1300 JC11[1029:309005] QUERY: SELECT uuid FROM Information WHERE id = ?
2202019-03-29 09:21:16.358421+1300 JC11[1029:309005] QUERY: ATTACH DATABASE '/var/mobile/Containers/Data/Application/CF555966-A9D7-42BB-A86D-44C26830A7F5/Documents/AIR Music Technology/JC11/Engine Library/itm.db' AS db1
2212019-03-29 09:21:16.363693+1300 JC11[1029:309005] QUERY: ATTACH DATABASE '/var/mobile/Containers/Data/Application/CF555966-A9D7-42BB-A86D-44C26830A7F5/Documents/AIR Music Technology/JC11/Engine Library/trm.db' AS db2
2222019-03-29 09:21:16.368336+1300 JC11[1029:309005] QUERY: ATTACH DATABASE '/var/mobile/Containers/Data/Application/CF555966-A9D7-42BB-A86D-44C26830A7F5/Documents/AIR Music Technology/JC11/Engine Library/m.db' AS db3
2232019-03-29 09:21:16.372574+1300 JC11[1029:309005] QUERY: ATTACH DATABASE '/var/mobile/Containers/Data/Application/CF555966-A9D7-42BB-A86D-44C26830A7F5/Documents/AIR Music Technology/JC11/Engine Library/fsm.db' AS db4
2242019-03-29 09:21:16.378508+1300 JC11[1029:309005] QUERY: SELECT t.trackId AS TrackId3, 3 AS SourceDatabase, t.id, t.trackNumber FROM db3.ListTrackList AS t WHERE t.listType = ? AND t.listId IN ( SELECT id FROM db3.List WHERE path LIKE ? ESCAPE "\" ) ORDER BY trackNumber ASC
2252019-03-29 09:21:16.379342+1300 JC11[1029:309005] QUERY: SELECT 1
2262019-03-29 09:21:16.379741+1300 JC11[1029:308913] CoreAudio ( Line: 123 ): STOP()
2272019-03-29 09:21:16.409634+1300 JC11[1029:308681] [air.planck.database.collector] Invalid CollectionJob::Settings object
2282019-03-29 09:21:16.410311+1300 JC11[1029:309005] QUERY: PRAGMA journal_mode
2292019-03-29 09:21:16.414549+1300 JC11[1029:309005] QUERY: PRAGMA journal_mode = PERSIST
2302019-03-29 09:21:16.414620+1300 JC11[1029:309005] QUERY: PRAGMA journal_mode
2312019-03-29 09:21:16.414674+1300 JC11[1029:309005] QUERY: PRAGMA foreign_keys = ON
2322019-03-29 09:21:16.414732+1300 JC11[1029:309005] QUERY: SELECT uuid FROM Information WHERE id = ?
2332019-03-29 09:21:16.415136+1300 JC11[1029:309005] QUERY: PRAGMA journal_mode
2342019-03-29 09:21:16.415469+1300 JC11[1029:308681] QUERY: SELECT id, type, title, path, isFolder, trackCount, ordering FROM List INNER JOIN ListParentList AS j1 ON id = listOriginId AND type = listOriginType WHERE title = ? AND type = ? AND j1.listParentId = id
2352019-03-29 09:21:16.416317+1300 JC11[1029:308681] QUERY: PRAGMA journal_mode
2362019-03-29 09:21:16.418932+1300 JC11[1029:309005] QUERY: PRAGMA journal_mode = PERSIST
2372019-03-29 09:21:16.418982+1300 JC11[1029:309005] QUERY: PRAGMA journal_mode
2382019-03-29 09:21:16.419028+1300 JC11[1029:309005] QUERY: PRAGMA foreign_keys = ON
2392019-03-29 09:21:16.419081+1300 JC11[1029:309005] QUERY: SELECT uuid FROM Information WHERE id = ?
2402019-03-29 09:21:16.419420+1300 JC11[1029:309005] QUERY: PRAGMA journal_mode
2412019-03-29 09:21:16.420274+1300 JC11[1029:308681] QUERY: PRAGMA journal_mode = PERSIST
2422019-03-29 09:21:16.420320+1300 JC11[1029:308681] QUERY: PRAGMA journal_mode
2432019-03-29 09:21:16.420361+1300 JC11[1029:308681] QUERY: PRAGMA foreign_keys = ON
2442019-03-29 09:21:16.420412+1300 JC11[1029:308681] QUERY: SELECT uuid FROM Information WHERE id = ?
2452019-03-29 09:21:16.420821+1300 JC11[1029:308681] QUERY: PRAGMA journal_mode
2462019-03-29 09:21:16.423420+1300 JC11[1029:309005] QUERY: PRAGMA journal_mode = PERSIST
2472019-03-29 09:21:16.423476+1300 JC11[1029:309005] QUERY: PRAGMA journal_mode
2482019-03-29 09:21:16.423518+1300 JC11[1029:309005] QUERY: PRAGMA foreign_keys = ON
2492019-03-29 09:21:16.423568+1300 JC11[1029:309005] QUERY: SELECT uuid FROM Information WHERE id = ?
2502019-03-29 09:21:16.423855+1300 JC11[1029:309005] QUERY: ATTACH DATABASE '/var/mobile/Containers/Data/Application/CF555966-A9D7-42BB-A86D-44C26830A7F5/Documents/AIR Music Technology/JC11/Engine Library/itm.db' AS db1
2512019-03-29 09:21:16.424928+1300 JC11[1029:308681] QUERY: PRAGMA journal_mode = PERSIST
2522019-03-29 09:21:16.424969+1300 JC11[1029:308681] QUERY: PRAGMA journal_mode
2532019-03-29 09:21:16.425010+1300 JC11[1029:308681] QUERY: PRAGMA foreign_keys = ON
2542019-03-29 09:21:16.425062+1300 JC11[1029:308681] QUERY: SELECT uuid FROM Information WHERE id = ?
2552019-03-29 09:21:16.425267+1300 JC11[1029:308681] QUERY: SELECT MAX(ordering) FROM List WHERE type = ?
2562019-03-29 09:21:16.425592+1300 JC11[1029:308681] QUERY: SELECT 1
2572019-03-29 09:21:16.425712+1300 JC11[1029:308681] QUERY: SELECT t.id, t.type, t.title, t.path, t.isFolder, t.trackCount, t.ordering FROM List as t WHERE type = ? AND ordering >= ? AND ordering <= ? ORDER BY ordering ASC
2582019-03-29 09:21:16.426065+1300 JC11[1029:308681] QUERY: UPDATE List SET ordering = ordering + ? WHERE type = ? AND ordering >= ?
2592019-03-29 09:21:16.426365+1300 JC11[1029:308681] QUERY: SELECT MAX("id") FROM "List"
2602019-03-29 09:21:16.426600+1300 JC11[1029:308681] QUERY: INSERT INTO List ( id, type, title, path, isFolder, trackCount, ordering ) VALUES ( ?, ?, ?, ?, ?, ?, ? )
2612019-03-29 09:21:16.427659+1300 JC11[1029:308681] QUERY: SELECT EXISTS ( SELECT 1 FROM ListParentList WHERE listOriginId = ? AND listOriginType = ? AND listParentId = ? AND listParentType = ? ) AS entryExists
2622019-03-29 09:21:16.427914+1300 JC11[1029:308681] QUERY: INSERT INTO ListParentList ( listOriginId, listOriginType, listParentId, listParentType ) VALUES ( ?, ?, ?, ? )
2632019-03-29 09:21:16.428206+1300 JC11[1029:309005] QUERY: PRAGMA journal_mode
2642019-03-29 09:21:16.429167+1300 JC11[1029:308681] QUERY: SELECT t.id, t.type, t.title, t.path, t.isFolder, t.trackCount, t.ordering FROM List as t WHERE id = ? AND type = ?
2652019-03-29 09:21:16.430249+1300 JC11[1029:308681] QUERY: SELECT 1
2662019-03-29 09:21:16.432355+1300 JC11[1029:309005] QUERY: PRAGMA journal_mode = PERSIST
2672019-03-29 09:21:16.432416+1300 JC11[1029:309005] QUERY: PRAGMA journal_mode
2682019-03-29 09:21:16.432466+1300 JC11[1029:309005] QUERY: PRAGMA foreign_keys = ON
2692019-03-29 09:21:16.432516+1300 JC11[1029:309005] QUERY: SELECT uuid FROM Information WHERE id = ?
2702019-03-29 09:21:16.432811+1300 JC11[1029:309005] QUERY: ATTACH DATABASE '/var/mobile/Containers/Data/Application/CF555966-A9D7-42BB-A86D-44C26830A7F5/Documents/AIR Music Technology/JC11/Engine Library/trm.db' AS db2
2712019-03-29 09:21:16.436901+1300 JC11[1029:309005] QUERY: ATTACH DATABASE '/var/mobile/Containers/Data/Application/CF555966-A9D7-42BB-A86D-44C26830A7F5/Documents/AIR Music Technology/JC11/Engine Library/m.db' AS db3
2722019-03-29 09:21:16.441028+1300 JC11[1029:309005] QUERY: ATTACH DATABASE '/var/mobile/Containers/Data/Application/CF555966-A9D7-42BB-A86D-44C26830A7F5/Documents/AIR Music Technology/JC11/Engine Library/fsm.db' AS db4
2732019-03-29 09:21:16.445177+1300 JC11[1029:309005] QUERY: SELECT id, type, title, path, isFolder, trackCount, ordering, 3 AS SourceDatabase, UPPER(title) AS v FROM db3.List INNER JOIN db3.ListParentList AS j1 ON id = listOriginId WHERE j1.listParentId = id AND type = ? ORDER BY v ASC
2742019-03-29 09:21:16.445594+1300 JC11[1029:309005] QUERY: SELECT 1
2752019-03-29 09:21:16.446331+1300 JC11[1029:309005] QUERY: SELECT id, type, title, path, isFolder, trackCount, ordering, 3 AS SourceDatabase, UPPER(title) AS v FROM db3.List INNER JOIN db3.ListParentList AS j1 ON id = listOriginId WHERE j1.listParentId = id AND type = ? ORDER BY v ASC