· 6 years ago · Mar 28, 2019, 08:28 PM
12019-03-29 09:19:25.341029+1300 JC11[56699:1491848] QUERY: PRAGMA journal_mode
22019-03-29 09:19:25.349314+1300 JC11[56699:1491848] QUERY: PRAGMA journal_mode = PERSIST
32019-03-29 09:19:25.349469+1300 JC11[56699:1491848] QUERY: PRAGMA journal_mode
42019-03-29 09:19:25.349712+1300 JC11[56699:1491848] QUERY: PRAGMA foreign_keys = ON
52019-03-29 09:19:25.349894+1300 JC11[56699:1491848] QUERY: SELECT uuid FROM Information WHERE id = ?
62019-03-29 09:19:25.351624+1300 JC11[56699:1491848] QUERY: PRAGMA journal_mode
72019-03-29 09:19:25.352124+1300 JC11[56699:1491848] QUERY: PRAGMA journal_mode = PERSIST
82019-03-29 09:19:25.352289+1300 JC11[56699:1491848] QUERY: PRAGMA journal_mode
92019-03-29 09:19:25.352421+1300 JC11[56699:1491848] QUERY: PRAGMA foreign_keys = ON
102019-03-29 09:19:25.352550+1300 JC11[56699:1491848] QUERY: SELECT uuid FROM Information WHERE id = ?
112019-03-29 09:19:25.353035+1300 JC11[56699:1491848] QUERY: SELECT 1
122019-03-29 09:19:25.353220+1300 JC11[56699:1491848] QUERY: SELECT 1
132019-03-29 09:19:25.353773+1300 JC11[56699:1491848] QUERY: SELECT schemaVersionMajor, schemaVersionMinor, schemaVersionPatch FROM Information WHERE id = ?
142019-03-29 09:19:25.354237+1300 JC11[56699:1491848] QUERY: SELECT schemaVersionMajor, schemaVersionMinor, schemaVersionPatch FROM Information WHERE id = ?
152019-03-29 09:19:25.355599+1300 JC11[56699:1491848] QUERY: PRAGMA journal_mode
162019-03-29 09:19:25.363152+1300 JC11[56699:1491848] QUERY: PRAGMA journal_mode = PERSIST
172019-03-29 09:19:25.363299+1300 JC11[56699:1491848] QUERY: PRAGMA journal_mode
182019-03-29 09:19:25.363398+1300 JC11[56699:1491848] QUERY: PRAGMA foreign_keys = ON
192019-03-29 09:19:25.363498+1300 JC11[56699:1491848] QUERY: SELECT uuid FROM Information WHERE id = ?
202019-03-29 09:19:25.365968+1300 JC11[56699:1491848] QUERY: PRAGMA journal_mode
212019-03-29 09:19:25.367133+1300 JC11[56699:1491848] QUERY: PRAGMA journal_mode = PERSIST
222019-03-29 09:19:25.367239+1300 JC11[56699:1491848] QUERY: PRAGMA journal_mode
232019-03-29 09:19:25.367342+1300 JC11[56699:1491848] QUERY: PRAGMA foreign_keys = ON
242019-03-29 09:19:25.367441+1300 JC11[56699:1491848] QUERY: SELECT uuid FROM Information WHERE id = ?
252019-03-29 09:19:25.367927+1300 JC11[56699:1491848] QUERY: SELECT 1
262019-03-29 09:19:25.368061+1300 JC11[56699:1491848] QUERY: SELECT 1
272019-03-29 09:19:25.368393+1300 JC11[56699:1491848] QUERY: SELECT schemaVersionMajor, schemaVersionMinor, schemaVersionPatch FROM Information WHERE id = ?
282019-03-29 09:19:25.368672+1300 JC11[56699:1491848] QUERY: SELECT schemaVersionMajor, schemaVersionMinor, schemaVersionPatch FROM Information WHERE id = ?
292019-03-29 09:19:25.369675+1300 JC11[56699:1491848] QUERY: PRAGMA journal_mode
302019-03-29 09:19:25.373439+1300 JC11[56699:1491848] QUERY: PRAGMA journal_mode = PERSIST
312019-03-29 09:19:25.373549+1300 JC11[56699:1491848] QUERY: PRAGMA journal_mode
322019-03-29 09:19:25.373672+1300 JC11[56699:1491848] QUERY: PRAGMA foreign_keys = ON
332019-03-29 09:19:25.373848+1300 JC11[56699:1491848] QUERY: SELECT uuid FROM Information WHERE id = ?
342019-03-29 09:19:25.374582+1300 JC11[56699:1491848] QUERY: SELECT id, uuid, schemaVersionMajor, schemaVersionMinor, schemaVersionPatch, currentPlayedIndiciator, lastRekordBoxLibraryImportReadCounter FROM Information WHERE id = ?
352019-03-29 09:19:25.375112+1300 JC11[56699:1491848] QUERY: UPDATE Information SET id = ? , uuid = ? , schemaVersionMajor = ? , schemaVersionMinor = ? , schemaVersionPatch = ? , currentPlayedIndiciator = ? , lastRekordBoxLibraryImportReadCounter = ? WHERE id = ?
362019-03-29 09:19:25.376964+1300 JC11[56699:1491848] QUERY: SELECT 1
372019-03-29 09:19:25.379327+1300 JC11[56699:1491848] QUERY: PRAGMA journal_mode
382019-03-29 09:19:25.379982+1300 JC11[56699:1491848] QUERY: PRAGMA journal_mode = PERSIST
392019-03-29 09:19:25.380073+1300 JC11[56699:1491848] QUERY: PRAGMA journal_mode
402019-03-29 09:19:25.380172+1300 JC11[56699:1491848] QUERY: PRAGMA foreign_keys = ON
412019-03-29 09:19:25.380322+1300 JC11[56699:1491848] QUERY: SELECT COUNT(*) FROM sqlite_master WHERE ( type='table' OR type='view' ) AND name=?
422019-03-29 09:19:25.380972+1300 JC11[56699:1491848] 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:19:25.383870+1300 JC11[56699:1491848] QUERY: CREATE INDEX IF NOT EXISTS index_Track_id ON Track ( id )
442019-03-29 09:19:25.384563+1300 JC11[56699:1491848] QUERY: CREATE INDEX IF NOT EXISTS index_Track_path ON Track ( path )
452019-03-29 09:19:25.385082+1300 JC11[56699:1491848] QUERY: CREATE INDEX IF NOT EXISTS index_Track_filename ON Track ( filename )
462019-03-29 09:19:25.385679+1300 JC11[56699:1491848] QUERY: CREATE INDEX IF NOT EXISTS index_Track_isExternalTrack ON Track ( isExternalTrack )
472019-03-29 09:19:25.386923+1300 JC11[56699:1491848] QUERY: CREATE INDEX IF NOT EXISTS index_Track_uuidOfExternalDatabase ON Track ( uuidOfExternalDatabase )
482019-03-29 09:19:25.387984+1300 JC11[56699:1491848] QUERY: CREATE INDEX IF NOT EXISTS index_Track_idTrackInExternalDatabase ON Track ( idTrackInExternalDatabase )
492019-03-29 09:19:25.389285+1300 JC11[56699:1491848] QUERY: CREATE INDEX IF NOT EXISTS index_Track_idAlbumArt ON Track ( idAlbumArt )
502019-03-29 09:19:25.389887+1300 JC11[56699:1491848] QUERY: SELECT COUNT(*) FROM sqlite_master WHERE ( type='table' OR type='view' ) AND name=?
512019-03-29 09:19:25.390216+1300 JC11[56699:1491848] QUERY: CREATE TABLE Information ( [id] INTEGER, [uuid] TEXT, [schemaVersionMajor] INTEGER, [schemaVersionMinor] INTEGER, [schemaVersionPatch] INTEGER, [currentPlayedIndiciator] INTEGER, [lastRekordBoxLibraryImportReadCounter] INTEGER, PRIMARY KEY ( [id] ) )
522019-03-29 09:19:25.391295+1300 JC11[56699:1491848] QUERY: CREATE INDEX IF NOT EXISTS index_Information_id ON Information ( id )
532019-03-29 09:19:25.391936+1300 JC11[56699:1491848] QUERY: SELECT id, uuid, schemaVersionMajor, schemaVersionMinor, schemaVersionPatch, currentPlayedIndiciator, lastRekordBoxLibraryImportReadCounter FROM Information WHERE id = ?
542019-03-29 09:19:25.392389+1300 JC11[56699:1491848] QUERY: INSERT INTO Information ( id, uuid, schemaVersionMajor, schemaVersionMinor, schemaVersionPatch, currentPlayedIndiciator, lastRekordBoxLibraryImportReadCounter ) VALUES ( ?, ?, ?, ?, ?, ?, ? )
552019-03-29 09:19:25.393035+1300 JC11[56699:1491848] QUERY: SELECT COUNT(*) FROM sqlite_master WHERE ( type='table' OR type='view' ) AND name=?
562019-03-29 09:19:25.393311+1300 JC11[56699:1491848] QUERY: CREATE TABLE MetaData ( [id] INTEGER, [type] INTEGER, [text] TEXT, PRIMARY KEY ( [id], [type] ) , FOREIGN KEY ( [id] ) REFERENCES Track ( [id] ) ON DELETE CASCADE)
572019-03-29 09:19:25.394192+1300 JC11[56699:1491848] QUERY: CREATE INDEX IF NOT EXISTS index_MetaData_id ON MetaData ( id )
582019-03-29 09:19:25.394793+1300 JC11[56699:1491848] QUERY: CREATE INDEX IF NOT EXISTS index_MetaData_type ON MetaData ( type )
592019-03-29 09:19:25.395350+1300 JC11[56699:1491848] QUERY: CREATE INDEX IF NOT EXISTS index_MetaData_text ON MetaData ( text )
602019-03-29 09:19:25.396009+1300 JC11[56699:1491848] QUERY: SELECT COUNT(*) FROM sqlite_master WHERE ( type='table' OR type='view' ) AND name=?
612019-03-29 09:19:25.396281+1300 JC11[56699:1491848] QUERY: CREATE TABLE MetaDataInteger ( [id] INTEGER, [type] INTEGER, [value] INTEGER, PRIMARY KEY ( [id], [type] ) , FOREIGN KEY ( [id] ) REFERENCES Track ( [id] ) ON DELETE CASCADE)
622019-03-29 09:19:25.398176+1300 JC11[56699:1491848] QUERY: CREATE INDEX IF NOT EXISTS index_MetaDataInteger_id ON MetaDataInteger ( id )
632019-03-29 09:19:25.398882+1300 JC11[56699:1491848] QUERY: CREATE INDEX IF NOT EXISTS index_MetaDataInteger_type ON MetaDataInteger ( type )
642019-03-29 09:19:25.399338+1300 JC11[56699:1491848] QUERY: CREATE INDEX IF NOT EXISTS index_MetaDataInteger_value ON MetaDataInteger ( value )
652019-03-29 09:19:25.399815+1300 JC11[56699:1491848] QUERY: SELECT COUNT(*) FROM sqlite_master WHERE ( type='table' OR type='view' ) AND name=?
662019-03-29 09:19:25.400036+1300 JC11[56699:1491848] QUERY: CREATE TABLE AlbumArt ( [id] INTEGER, [hash] TEXT, [albumArt] BLOB, PRIMARY KEY ( [id] ) )
672019-03-29 09:19:25.400575+1300 JC11[56699:1491848] QUERY: CREATE INDEX IF NOT EXISTS index_AlbumArt_id ON AlbumArt ( id )
682019-03-29 09:19:25.401066+1300 JC11[56699:1491848] QUERY: CREATE INDEX IF NOT EXISTS index_AlbumArt_hash ON AlbumArt ( hash )
692019-03-29 09:19:25.401529+1300 JC11[56699:1491848] QUERY: SELECT COUNT(*) FROM sqlite_master WHERE ( type='table' OR type='view' ) AND name=?
702019-03-29 09:19:25.401753+1300 JC11[56699:1491848] QUERY: CREATE TABLE CopiedTrack ( [trackId] INTEGER, [uuidOfSourceDatabase] TEXT, [idOfTrackInSourceDatabase] INTEGER, PRIMARY KEY ( [trackId] ) , FOREIGN KEY ( [trackId] ) REFERENCES Track ( [id] ) ON DELETE CASCADE)
712019-03-29 09:19:25.402298+1300 JC11[56699:1491848] QUERY: CREATE INDEX IF NOT EXISTS index_CopiedTrack_trackId ON CopiedTrack ( trackId )
722019-03-29 09:19:25.402788+1300 JC11[56699:1491848] QUERY: SELECT COUNT(*) FROM sqlite_master WHERE ( type='table' OR type='view' ) AND name=?
732019-03-29 09:19:25.403012+1300 JC11[56699:1491848] QUERY: CREATE TABLE List ( [id] INTEGER, [type] INTEGER, [title] TEXT, [path] TEXT, [isFolder] NUMERIC, [trackCount] INTEGER, [ordering] INTEGER, PRIMARY KEY ( [id], [type] ) )
742019-03-29 09:19:25.403633+1300 JC11[56699:1491848] QUERY: CREATE INDEX IF NOT EXISTS index_List_id ON List ( id )
752019-03-29 09:19:25.404301+1300 JC11[56699:1491848] QUERY: CREATE INDEX IF NOT EXISTS index_List_type ON List ( type )
762019-03-29 09:19:25.404826+1300 JC11[56699:1491848] QUERY: CREATE INDEX IF NOT EXISTS index_List_path ON List ( path )
772019-03-29 09:19:25.405379+1300 JC11[56699:1491848] QUERY: CREATE INDEX IF NOT EXISTS index_List_ordering ON List ( ordering )
782019-03-29 09:19:25.406102+1300 JC11[56699:1491848] QUERY: CREATE VIEW IF NOT EXISTS Playlist AS SELECT id, title FROM List WHERE type = 1
792019-03-29 09:19:25.406865+1300 JC11[56699:1491848] QUERY: CREATE VIEW IF NOT EXISTS Historylist AS SELECT id, title FROM List WHERE type = 2
802019-03-29 09:19:25.408279+1300 JC11[56699:1491848] QUERY: CREATE VIEW IF NOT EXISTS Preparelist AS SELECT id, title FROM List WHERE type = 3
812019-03-29 09:19:25.409906+1300 JC11[56699:1491848] QUERY: CREATE VIEW IF NOT EXISTS Crate AS SELECT id AS id, title AS title, path AS path FROM List WHERE type = 4
822019-03-29 09:19:25.411601+1300 JC11[56699:1491848] QUERY: SELECT COUNT(*) FROM sqlite_master WHERE ( type='table' OR type='view' ) AND name=?
832019-03-29 09:19:25.411971+1300 JC11[56699:1491848] 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)
842019-03-29 09:19:25.413639+1300 JC11[56699:1491848] QUERY: CREATE INDEX IF NOT EXISTS index_ListTrackList_listId ON ListTrackList ( listId )
852019-03-29 09:19:25.414380+1300 JC11[56699:1491848] QUERY: CREATE INDEX IF NOT EXISTS index_ListTrackList_listType ON ListTrackList ( listType )
862019-03-29 09:19:25.415067+1300 JC11[56699:1491848] QUERY: CREATE INDEX IF NOT EXISTS index_ListTrackList_trackId ON ListTrackList ( trackId )
872019-03-29 09:19:25.415747+1300 JC11[56699:1491848] 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
882019-03-29 09:19:25.416493+1300 JC11[56699:1491848] 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
892019-03-29 09:19:25.417260+1300 JC11[56699:1491848] 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
902019-03-29 09:19:25.418021+1300 JC11[56699:1491848] 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
912019-03-29 09:19:25.418795+1300 JC11[56699:1491848] 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
922019-03-29 09:19:25.419420+1300 JC11[56699:1491848] 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
932019-03-29 09:19:25.420040+1300 JC11[56699:1491848] 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
942019-03-29 09:19:25.420663+1300 JC11[56699:1491848] 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
952019-03-29 09:19:25.421481+1300 JC11[56699:1491848] 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
962019-03-29 09:19:25.422167+1300 JC11[56699:1491848] 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
972019-03-29 09:19:25.422961+1300 JC11[56699:1491848] 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
982019-03-29 09:19:25.423690+1300 JC11[56699:1491848] 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
992019-03-29 09:19:25.424454+1300 JC11[56699:1491848] 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
1002019-03-29 09:19:25.425132+1300 JC11[56699:1491848] 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
1012019-03-29 09:19:25.425798+1300 JC11[56699:1491848] 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
1022019-03-29 09:19:25.426504+1300 JC11[56699:1491848] 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
1032019-03-29 09:19:25.427063+1300 JC11[56699:1491848] 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
1042019-03-29 09:19:25.427716+1300 JC11[56699:1491848] 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
1052019-03-29 09:19:25.428480+1300 JC11[56699:1491848] 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
1062019-03-29 09:19:25.431195+1300 JC11[56699:1491848] 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
1072019-03-29 09:19:25.431893+1300 JC11[56699:1491848] 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
1082019-03-29 09:19:25.432223+1300 JC11[56699:1491848] 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
1092019-03-29 09:19:25.433282+1300 JC11[56699:1491848] 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
1102019-03-29 09:19:25.434344+1300 JC11[56699:1491848] 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
1112019-03-29 09:19:25.436455+1300 JC11[56699:1491848] 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
1122019-03-29 09:19:25.438189+1300 JC11[56699:1491848] 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
1132019-03-29 09:19:25.439145+1300 JC11[56699:1491848] 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
1142019-03-29 09:19:25.441136+1300 JC11[56699:1491848] 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
1152019-03-29 09:19:25.442012+1300 JC11[56699:1491848] 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
1162019-03-29 09:19:25.442806+1300 JC11[56699:1491848] 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
1172019-03-29 09:19:25.443531+1300 JC11[56699:1491848] 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
1182019-03-29 09:19:25.444145+1300 JC11[56699:1491848] 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
1192019-03-29 09:19:25.444745+1300 JC11[56699:1491848] QUERY: SELECT COUNT(*) FROM sqlite_master WHERE ( type='table' OR type='view' ) AND name=?
1202019-03-29 09:19:25.444961+1300 JC11[56699:1491848] 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)
1212019-03-29 09:19:25.445644+1300 JC11[56699:1491848] QUERY: CREATE INDEX IF NOT EXISTS index_ListHierarchy_listId ON ListHierarchy ( listId )
1222019-03-29 09:19:25.446372+1300 JC11[56699:1491848] QUERY: CREATE INDEX IF NOT EXISTS index_ListHierarchy_listType ON ListHierarchy ( listType )
1232019-03-29 09:19:25.447120+1300 JC11[56699:1491848] QUERY: CREATE INDEX IF NOT EXISTS index_ListHierarchy_listIdChild ON ListHierarchy ( listIdChild )
1242019-03-29 09:19:25.448636+1300 JC11[56699:1491848] QUERY: CREATE INDEX IF NOT EXISTS index_ListHierarchy_listTypeChild ON ListHierarchy ( listTypeChild )
1252019-03-29 09:19:25.449326+1300 JC11[56699:1491848] QUERY: CREATE VIEW IF NOT EXISTS CrateHierarchy AS SELECT listId AS crateId, listIdChild AS crateIdChild FROM ListHierarchy WHERE listType = 4 AND listTypeChild = 4
1262019-03-29 09:19:25.449951+1300 JC11[56699:1491848] 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
1272019-03-29 09:19:25.450509+1300 JC11[56699:1491848] 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
1282019-03-29 09:19:25.451140+1300 JC11[56699:1491848] QUERY: SELECT COUNT(*) FROM sqlite_master WHERE ( type='table' OR type='view' ) AND name=?
1292019-03-29 09:19:25.451366+1300 JC11[56699:1491848] 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)
1302019-03-29 09:19:25.452076+1300 JC11[56699:1491848] QUERY: CREATE INDEX IF NOT EXISTS index_ListParentList_listOriginId ON ListParentList ( listOriginId )
1312019-03-29 09:19:25.452688+1300 JC11[56699:1491848] QUERY: CREATE INDEX IF NOT EXISTS index_ListParentList_listOriginType ON ListParentList ( listOriginType )
1322019-03-29 09:19:25.453245+1300 JC11[56699:1491848] QUERY: CREATE INDEX IF NOT EXISTS index_ListParentList_listParentId ON ListParentList ( listParentId )
1332019-03-29 09:19:25.453706+1300 JC11[56699:1491848] QUERY: CREATE INDEX IF NOT EXISTS index_ListParentList_listParentType ON ListParentList ( listParentType )
1342019-03-29 09:19:25.454231+1300 JC11[56699:1491848] QUERY: CREATE VIEW IF NOT EXISTS CrateParentList AS SELECT listOriginId AS crateOriginId, listParentId AS crateParentId FROM ListParentList WHERE listOriginType = 4 AND listParentType = 4
1352019-03-29 09:19:25.454893+1300 JC11[56699:1491848] 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