2006-04-25 12:21:51.5346 Start and End node: [default:default]
2006-04-25 12:21:51.5359 Field query. Need additional join. start and End node: [default:default]
2006-04-25 12:21:51.5365 Running SQL query: [SELECT DISTINCT tracks.id AS id,tracks.album AS album,tracks.url AS url,tracks.multialbumsortkey AS multialbumsortkey,tracks.ct AS ct FROM tracks  WHERE ( tracks.ct IN ( ?, ?, ? ) ) ORDER BY tracks.titlesort]
2006-04-25 12:21:51.5369 Bind arguments: [itu, mlp, mmp]

2006-04-25 12:21:51.7254 Start and End node: [default:default]
2006-04-25 12:21:51.7257 Field query. Need additional join. start and End node: [default:default]
2006-04-25 12:21:51.7261 Running SQL query: [SELECT DISTINCT tracks.id AS id,tracks.album AS album,tracks.url AS url,tracks.multialbumsortkey AS multialbumsortkey,tracks.ct AS ct FROM tracks  WHERE ( tracks.ct = ? ) ORDER BY tracks.titlesort]
2006-04-25 12:21:51.7263 Bind arguments: [ssp]

2006-04-25 12:21:52.1992 Executing SQL statement: [DROP TABLE metainformation;]
2006-04-25 12:21:52.2018 Executing SQL statement: [DROP TABLE tracks;]
2006-04-25 12:21:52.2308 Executing SQL statement: [DROP TABLE playlist_track;]
2006-04-25 12:21:52.2316 Executing SQL statement: [DROP TABLE albums;]
2006-04-25 12:21:52.2337 Executing SQL statement: [DROP TABLE contributors;]
2006-04-25 12:21:52.2357 Executing SQL statement: [DROP TABLE contributor_track;]
2006-04-25 12:21:52.2372 Executing SQL statement: [DROP TABLE contributor_album;]
2006-04-25 12:21:52.2436 Executing SQL statement: [DROP TABLE genres;]
2006-04-25 12:21:52.2447 Executing SQL statement: [DROP TABLE genre_track;]
2006-04-25 12:21:52.2465 Executing SQL statement: [DROP TABLE comments;]
2006-04-25 12:21:52.2710 Executing SQL statement: [DROP TABLE dirlist_track;]
2006-04-25 12:21:52.2720 Executing SQL statement: [DROP TABLE pluginversion;]
2006-04-25 12:21:52.7247 Executing SQL statement: [CREATE TABLE metainformation (version integer,track_count integer,total_time integer);]
2006-04-25 12:21:52.7295 Executing SQL statement: [INSERT INTO metainformation VALUES (17, 0, 0);]
2006-04-25 12:21:52.7364 Executing SQL statement: [CREATE TABLE tracks (id integer UNIQUE PRIMARY KEY NOT NULL,url varchar UNIQUE NOT NULL,title varchar,titlesort varchar,titlesearch varchar,album integer,tracknum integer,ct varchar,tag integer,age integer,fs integer,size integer,offset integer,year integer,secs integer,cover varchar,covertype varchar,thumbvarchar,thumbtype varchar,vbr_scale varchar,bitrate integer,rate integer,samplesize integer,channels integer,blockalign integer,endian integer,bpm integer,tagversion varchar,tagsize integer,drm integer,rating integer,disc integer,moodlogic_id integer,playCount integer,lastPlayed integer,audio integer,lossless integer,remote integer,lyrics text,moodlogic_mixable integer,musicbrainz_id varchar,musicmagic_mixable integer,replay_gain float,replay_peak float,multialbumsortkey varchar);]
2006-04-25 12:21:52.7397 Executing SQL statement: [CREATE INDEX trackURLIndex ON tracks (url);]
2006-04-25 12:21:52.7405 Executing SQL statement: [CREATE INDEX trackTitleIndex ON tracks (title);]
2006-04-25 12:21:52.7420 Executing SQL statement: [CREATE INDEX trackAlbumIndex ON tracks (album);]
2006-04-25 12:21:52.7427 Executing SQL statement: [CREATE INDEX ctSortIndex ON tracks (ct);]
2006-04-25 12:21:52.7442 Executing SQL statement: [CREATE INDEX trackSortIndex ON tracks (titlesort);]
2006-04-25 12:21:52.7500 Executing SQL statement: [CREATE INDEX trackSearchIndex ON tracks (titlesearch);]
2006-04-25 12:21:52.7507 Executing SQL statement: [CREATE INDEX trackRatingIndex ON tracks (rating);]
2006-04-25 12:21:52.7521 Executing SQL statement: [CREATE INDEX trackPlayCountIndex ON tracks (playCount);]
2006-04-25 12:21:52.7531 Executing SQL statement: [CREATE INDEX trackAudioIndex ON tracks (audio);]
2006-04-25 12:21:52.7590 Executing SQL statement: [CREATE INDEX trackLosslessIndex ON tracks (lossless);]
2006-04-25 12:21:52.7607 Executing SQL statement: [CREATE INDEX trackRemoteIndex ON tracks (remote);]
2006-04-25 12:21:52.7615 Executing SQL statement: [CREATE INDEX trackSortKeyIndex ON tracks (multialbumsortkey);]
2006-04-25 12:21:52.7631 Executing SQL statement: [CREATE TABLE playlist_track (id integer UNIQUE PRIMARY KEY NOT NULL,position integer,playlist integer,track integer);]
2006-04-25 12:21:52.7641 Executing SQL statement: [CREATE TABLE dirlist_track (id integer UNIQUE PRIMARY KEY NOT NULL,position integer,dirlist integer,item varchar);]
2006-04-25 12:21:52.7657 Executing SQL statement: [CREATE TABLE albums (id integer UNIQUE PRIMARY KEY NOT NULL,title varchar,titlesort varchar,titlesearch varchar,contributor varchar,compilation integer,year integer,artwork_path varchar,disc integer,discc integer,replay_gain float,replay_peak float,musicbrainz_id varchar,musicmagic_mixable integer);]
2006-04-25 12:21:52.7669 Executing SQL statement: [CREATE INDEX albumsTitleIndex ON albums (title);]
2006-04-25 12:21:52.7684 Executing SQL statement: [CREATE INDEX albumsSortIndex ON albums (titlesort);]
2006-04-25 12:21:52.7692 Executing SQL statement: [CREATE INDEX albumsSearchIndex ON albums (titlesearch);]
2006-04-25 12:21:52.7752 Executing SQL statement: [CREATE INDEX compilationSortIndex ON albums (compilation);]
2006-04-25 12:21:52.7769 Executing SQL statement: [CREATE TABLE contributors (id integer UNIQUE PRIMARY KEY NOT NULL,name varchar,namesort varchar,namesearch varchar,moodlogic_id integer,moodlogic_mixable integer,musicbrainz_id varchar,musicmagic_mixable integer);]
2006-04-25 12:21:52.7778 Executing SQL statement: [CREATE INDEX contributorsNameIndex ON contributors (name);]
2006-04-25 12:21:52.7795 Executing SQL statement: [CREATE INDEX contributorsSortIndex ON contributors (namesort);]
2006-04-25 12:21:52.7805 Executing SQL statement: [CREATE INDEX contributorsSearchIndex ON contributors (namesearch);]
2006-04-25 12:21:52.7823 Executing SQL statement: [CREATE TABLE contributor_track (id integer UNIQUE PRIMARY KEY NOT NULL,role integer,contributor integer,track integer,namesort varchar);]
2006-04-25 12:21:52.7868 Executing SQL statement: [CREATE INDEX contributor_trackContribIndex ON contributor_track (contributor);]
2006-04-25 12:21:52.7878 Executing SQL statement: [CREATE INDEX contributor_trackRoleIndex ON contributor_track (role);]
2006-04-25 12:21:52.7888 Executing SQL statement: [CREATE INDEX contributor_trackTrackIndex ON contributor_track (track);]
2006-04-25 12:21:52.7905 Executing SQL statement: [CREATE INDEX contributor_trackSortIndex ON contributor_track (namesort);]
2006-04-25 12:21:52.7922 Executing SQL statement: [CREATE TABLE contributor_album (id integer UNIQUE PRIMARY KEY NOT NULL,role integer,contributor integer,album integer);]
2006-04-25 12:21:52.7935 Executing SQL statement: [CREATE INDEX contributor_albumContribIndex ON contributor_album (contributor);]
2006-04-25 12:21:52.7976 Executing SQL statement: [CREATE INDEX contributor_albumRoleIndex ON contributor_album (role);]
2006-04-25 12:21:52.7987 Executing SQL statement: [CREATE INDEX contributor_albumAlbumIndex ON contributor_album (album);]
2006-04-25 12:21:52.8004 Executing SQL statement: [CREATE TABLE genres (id integer UNIQUE PRIMARY KEY NOT NULL,name varchar,namesort varchar,namesearch varchar,moodlogic_id integer,moodlogic_mixable integer,musicmagic_mixable integer);]
2006-04-25 12:21:52.8016 Executing SQL statement: [CREATE INDEX genreNameIndex ON genres (name);]
2006-04-25 12:21:52.8033 Executing SQL statement: [CREATE INDEX genreSortIndex ON genres (namesort);]
2006-04-25 12:21:52.8044 Executing SQL statement: [CREATE INDEX genreSearchIndex ON genres (namesearch);]
2006-04-25 12:21:52.8110 Executing SQL statement: [CREATE TABLE genre_track (id integer UNIQUE PRIMARY KEY NOT NULL,genre integer,track integer);]
2006-04-25 12:21:52.8123 Executing SQL statement: [CREATE INDEX genre_trackGenreIndex ON genre_track (genre);]
2006-04-25 12:21:52.8140 Executing SQL statement: [CREATE INDEX genre_trackTrackIndex ON genre_track (track);]
2006-04-25 12:21:52.8150 Executing SQL statement: [CREATE TABLE comments (id integer UNIQUE PRIMARY KEY NOT NULL,track integer,value varchar);]
2006-04-25 12:21:52.8169 Executing SQL statement: [CREATE TABLE pluginversion (id integer UNIQUE PRIMARY KEY NOT NULL,name varchar,version integer);]