BEGIN TRANSACTION;
CREATE TABLE metainformation (version integer,track_count integer,total_time integer);
INSERT INTO "metainformation" VALUES(11, 14, 3774.36);
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,thumb varchar,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,remote integer,moodlogic_mixable integer,musicmagic_mixable integer,multialbumsortkey varchar);
INSERT INTO "tracks" VALUES(1, 'file:///E:/audio/flac/D/Diverse_Artister/Diverse_Artister-Med_Blanke_Ark-1994.flac#0-255', 'Sønnavindvalsen', 'SA¸NNAVINDVALSEN', 'SA¸NNAVINDVALSEN', 1, 1, 'flc', NULL, NULL, NULL, 25850960, 0, 1994, 255, NULL, NULL, 'Eriksen-Med blanke ark-thumb.jpg', NULL, NULL, 810983.71538486, 44100, NULL, 2, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 0, NULL, NULL, 'ERIKSEN MED BLANKE ARK 001 SA¸NNAVINDVALSEN');
INSERT INTO "tracks" VALUES(2, 'file:///E:/audio/flac/D/Diverse_Artister/Diverse_Artister-Med_Blanke_Ark-1994.flac#255-427.76', 'BlÃ¥klokkevikua', 'BLA¥KLOKKEVIKUA', 'BLA¥KLOKKEVIKUA', 1, 2, 'flc', NULL, NULL, NULL, 17513772, 25850960, 1994, 172.76, NULL, NULL, NULL, NULL, NULL, 810983.71538486, 44100, NULL, 2, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 0, NULL, NULL, 'TRE SMA¥ KINESERE MED BLANKE ARK 002 BLA¥KLOKKEVIKUA');
INSERT INTO "tracks" VALUES(3, 'file:///E:/audio/flac/D/Diverse_Artister/Diverse_Artister-Med_Blanke_Ark-1994.flac#427.76-806.893333333333', 'Du ska fÃ¥ ein dag i morra', 'DU SKA FA¥ EIN DAG I MORRA', 'DU SKA FA¥ EIN DAG I MORRA', 1, 3, 'flc', NULL, NULL, NULL, 38435141, 43364732, 1994, 379.133333333333, NULL, NULL, NULL, NULL, NULL, 810983.71538486, 44100, NULL, 2, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 0, NULL, NULL, 'LYNNI TREEKREM KNUT REIERSRUD ANNBJA¸RG LIEN MED BLANKE ARK 003 DU SKA FA¥ EIN DAG I MORRA');
INSERT INTO "tracks" VALUES(4, 'file:///E:/audio/flac/D/Diverse_Artister/Diverse_Artister-Med_Blanke_Ark-1994.flac#806.893333333333-1136', 'Jørgen Hattemaker', 'JA¸RGEN HATTEMAKER', 'JA¸RGEN HATTEMAKER', 1, 4, 'flc', NULL, NULL, NULL, 33363621, 81799873, 1994, 329.106666666667, NULL, NULL, NULL, NULL, NULL, 810983.71538486, 44100, NULL, 2, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 0, NULL, NULL, 'BJA¸RN EIDSVA¥G MED BLANKE ARK 004 JA¸RGEN HATTEMAKER');
INSERT INTO "tracks" VALUES(5, 'file:///E:/audio/flac/D/Diverse_Artister/Diverse_Artister-Med_Blanke_Ark-1994.flac#1136-1396.22666666667', 'Steinrøysa neri bakkan', 'STEINRA¸YSA NERI BAKKAN', 'STEINRA¸YSA NERI BAKKAN', 1, 5, 'flc', NULL, NULL, NULL, 26380821, 115163494, 1994, 260.22666666667, NULL, NULL, NULL, NULL, NULL, 810983.71538486, 44100, NULL, 2, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 0, NULL, NULL, 'DANCE WITH A STRANGER MED BLANKE ARK 005 STEINRA¸YSA NERI BAKKAN');
INSERT INTO "tracks" VALUES(6, 'file:///E:/audio/flac/D/Diverse_Artister/Diverse_Artister-Med_Blanke_Ark-1994.flac#1396.22666666667-1635.8', 'Tango for Te-Ve', 'TANGO FOR TE VE', 'TANGO FOR TE VE', 1, 6, 'flc', NULL, NULL, NULL, 24287061, 141544315, 1994, 239.57333333333, NULL, NULL, NULL, NULL, NULL, 810983.71538486, 44100, NULL, 2, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 0, NULL, NULL, 'DUMDUM BOYS DE LILLOS MED BLANKE ARK 006 TANGO FOR TE VE');
INSERT INTO "tracks" VALUES(7, 'file:///E:/audio/flac/D/Diverse_Artister/Diverse_Artister-Med_Blanke_Ark-1994.flac#1635.8-1921.82666666667', 'Den skyldige', 'DEN SKYLDIGE', 'DEN SKYLDIGE', 1, 7, 'flc', NULL, NULL, NULL, 28996330, 165831376, 1994, 286.02666666667, NULL, NULL, NULL, NULL, NULL, 810983.71538486, 44100, NULL, 2, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 0, NULL, NULL, 'NOTODDEN BLUES BAND MED BLANKE ARK 007 DEN SKYLDIGE');
INSERT INTO "tracks" VALUES(8, 'file:///E:/audio/flac/D/Diverse_Artister/Diverse_Artister-Med_Blanke_Ark-1994.flac#1921.82666666667-2231.22666666667', 'Slibesteinsvalsen', 'SLIBESTEINSVALSEN', 'SLIBESTEINSVALSEN', 1, 8, 'flc', NULL, NULL, NULL, 31365832, 194827706, 1994, 309.4, NULL, NULL, NULL, NULL, NULL, 810983.71538486, 44100, NULL, 2, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 0, NULL, NULL, 'REIDAR LARSEN MED BLANKE ARK 008 SLIBESTEINSVALSEN');
INSERT INTO "tracks" VALUES(9, 'file:///E:/audio/flac/D/Diverse_Artister/Diverse_Artister-Med_Blanke_Ark-1994.flac#2231.22666666667-2596', 'Alle har et søskenbarn pÃ¥ Gjøvik', 'ALLE HAR ET SA¸SKENBARN PA¥ GJA¸VIK', 'ALLE HAR ET SA¸SKENBARN PA¥ GJA¸VIK', 1, 9, 'flc', NULL, NULL, NULL, 36979376, 226193538, 1994, 364.77333333333, NULL, NULL, NULL, NULL, NULL, 810983.71538486, 44100, NULL, 2, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 0, NULL, NULL, 'KARIN KROG MED BLANKE ARK 009 ALLE HAR ET SA¸SKENBARN PA¥ GJA¸VIK');
INSERT INTO "tracks" VALUES(10, 'file:///E:/audio/flac/D/Diverse_Artister/Diverse_Artister-Med_Blanke_Ark-1994.flac#2596-2809.86666666667', 'Den uskuldige', 'DEN USKULDIGE', 'DEN USKULDIGE', 1, 10, 'flc', NULL, NULL, NULL, 21681015, 263172914, 1994, 213.86666666667, NULL, NULL, NULL, NULL, NULL, 810983.71538486, 44100, NULL, 2, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 0, NULL, NULL, 'AGNES BUEN GARNA¥S GUTTORM GUTTORMSEN MED BLANKE ARK 010 DEN USKULDIGE');
INSERT INTO "tracks" VALUES(11, 'file:///E:/audio/flac/D/Diverse_Artister/Diverse_Artister-Med_Blanke_Ark-1994.flac#2809.86666666667-3014.33333333333', 'Kjæm du i kveld', 'KJA¦M DU I KVELD', 'KJA¦M DU I KVELD', 1, 11, 'flc', NULL, NULL, NULL, 20728077, 284853929, 1994, 204.46666666666, NULL, NULL, NULL, NULL, NULL, 810983.71538486, 44100, NULL, 2, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 0, NULL, NULL, 'MARIT MATHIESEN MED BLANKE ARK 011 KJA¦M DU I KVELD');
INSERT INTO "tracks" VALUES(12, 'file:///E:/audio/flac/D/Diverse_Artister/Diverse_Artister-Med_Blanke_Ark-1994.flac#3014.33333333333-3194.09333333333', 'Husmannspolka', 'HUSMANNSPOLKA', 'HUSMANNSPOLKA', 1, 12, 'flc', NULL, NULL, NULL, 18223407, 305582006, 1994, 179.76, NULL, NULL, NULL, NULL, NULL, 810983.71538486, 44100, NULL, 2, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 0, NULL, NULL, 'FRODE RA¸NLI MIA GUNDERSEN MED BLANKE ARK 012 HUSMANNSPOLKA');
INSERT INTO "tracks" VALUES(13, 'file:///E:/audio/flac/D/Diverse_Artister/Diverse_Artister-Med_Blanke_Ark-1994.flac#3194.09333333333-3395.8', 'Mannen pÃ¥ holdeplassen', 'MANNEN PA¥ HOLDEPLASSEN', 'MANNEN PA¥ HOLDEPLASSEN', 1, 13, 'flc', NULL, NULL, NULL, 20448279, 323805413, 1994, 201.70666666667, NULL, NULL, NULL, NULL, NULL, 810983.71538486, 44100, NULL, 2, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 0, NULL, NULL, 'POGO POPS MED BLANKE ARK 013 MANNEN PA¥ HOLDEPLASSEN');
INSERT INTO "tracks" VALUES(14, 'file:///E:/audio/flac/D/Diverse_Artister/Diverse_Artister-Med_Blanke_Ark-1994.flac#3395.8-3774.36', 'SÃ¥ seile vi pÃ¥ Mjøsa', 'SA¥ SEILE VI PA¥ MJA¸SA', 'SA¥ SEILE VI PA¥ MJA¸SA', 1, 14, 'flc', NULL, NULL, NULL, 38377018, 344253692, 1994, 378.56, NULL, NULL, NULL, NULL, NULL, 810983.71538486, 44100, NULL, 2, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 0, NULL, NULL, 'SILJE NERGAARD MED BLANKE ARK 014 SA¥ SEILE VI PA¥ MJA¸SA');
INSERT INTO "tracks" VALUES(15, 'file:///E:/audio/flac/D/Diverse_Artister/Diverse_Artister-Med_Blanke_Ark-1994.flac', 'Diverse_Artister-Med_Blanke_Ark-1994.flac', 'DIVERSE_ARTISTER MED_BLANKE_ARK 1994 FLAC', 'DIVERSE_ARTISTER MED_BLANKE_ARK 1994 FLAC', NULL, NULL, 'fec', 1, 1117954038, 382630710, 382630710, 0, 1994, 3774.36, NULL, NULL, NULL, NULL, NULL, 810983.71538486, 44100, NULL, 2, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 0, NULL, NULL, '  DIVERSE_ARTISTER MED_BLANKE_ARK 1994 FLAC');
CREATE TABLE playlist_track (id integer UNIQUE PRIMARY KEY NOT NULL,position integer,playlist integer,track integer);
INSERT INTO "playlist_track" VALUES(1, 0, 15, 1);
INSERT INTO "playlist_track" VALUES(2, 1, 15, 2);
INSERT INTO "playlist_track" VALUES(3, 2, 15, 3);
INSERT INTO "playlist_track" VALUES(4, 3, 15, 4);
INSERT INTO "playlist_track" VALUES(5, 4, 15, 5);
INSERT INTO "playlist_track" VALUES(6, 5, 15, 6);
INSERT INTO "playlist_track" VALUES(7, 6, 15, 7);
INSERT INTO "playlist_track" VALUES(8, 7, 15, 8);
INSERT INTO "playlist_track" VALUES(9, 8, 15, 9);
INSERT INTO "playlist_track" VALUES(10, 9, 15, 10);
INSERT INTO "playlist_track" VALUES(11, 10, 15, 11);
INSERT INTO "playlist_track" VALUES(12, 11, 15, 12);
INSERT INTO "playlist_track" VALUES(13, 12, 15, 13);
INSERT INTO "playlist_track" VALUES(14, 13, 15, 14);
CREATE TABLE dirlist_track (id integer UNIQUE PRIMARY KEY NOT NULL,position integer,dirlist integer,item varchar);
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,musicmagic_mixable integer);
INSERT INTO "albums" VALUES(1, 'Med blanke ark', 'MED BLANKE ARK', 'MED BLANKE ARK', NULL, 1, 1994, NULL, NULL, NULL, NULL);
CREATE TABLE contributors (id integer UNIQUE PRIMARY KEY NOT NULL,name varchar,namesort varchar,namesearch varchar,moodlogic_id integer,moodlogic_mixable integer,musicmagic_mixable integer);
INSERT INTO "contributors" VALUES(1, 'Eriksen', 'ERIKSEN', 'ERIKSEN', NULL, NULL, NULL);
INSERT INTO "contributors" VALUES(2, 'Tre SmÃ¥ Kinesere', 'TRE SMA¥ KINESERE', 'TRE SMA¥ KINESERE', NULL, NULL, NULL);
INSERT INTO "contributors" VALUES(3, 'Lynni Treekrem, Knut Reiersrud & Annbjørg Lien', 'LYNNI TREEKREM KNUT REIERSRUD ANNBJA¸RG LIEN', 'LYNNI TREEKREM KNUT REIERSRUD ANNBJA¸RG LIEN', NULL, NULL, NULL);
INSERT INTO "contributors" VALUES(4, 'Bjørn EidsvÃ¥g', 'BJA¸RN EIDSVA¥G', 'BJA¸RN EIDSVA¥G', NULL, NULL, NULL);
INSERT INTO "contributors" VALUES(5, 'Dance With A Stranger', 'DANCE WITH A STRANGER', 'DANCE WITH A STRANGER', NULL, NULL, NULL);
INSERT INTO "contributors" VALUES(6, 'DumDum Boys & De Lillos', 'DUMDUM BOYS DE LILLOS', 'DUMDUM BOYS DE LILLOS', NULL, NULL, NULL);
INSERT INTO "contributors" VALUES(7, 'Notodden Blues Band', 'NOTODDEN BLUES BAND', 'NOTODDEN BLUES BAND', NULL, NULL, NULL);
INSERT INTO "contributors" VALUES(8, 'Reidar Larsen', 'REIDAR LARSEN', 'REIDAR LARSEN', NULL, NULL, NULL);
INSERT INTO "contributors" VALUES(9, 'Karin Krog', 'KARIN KROG', 'KARIN KROG', NULL, NULL, NULL);
INSERT INTO "contributors" VALUES(10, 'Agnes Buen GarnÃ¥s & Guttorm Guttormsen', 'AGNES BUEN GARNA¥S GUTTORM GUTTORMSEN', 'AGNES BUEN GARNA¥S GUTTORM GUTTORMSEN', NULL, NULL, NULL);
INSERT INTO "contributors" VALUES(11, 'Marit Mathiesen', 'MARIT MATHIESEN', 'MARIT MATHIESEN', NULL, NULL, NULL);
INSERT INTO "contributors" VALUES(12, 'Frode Rønli & Mia Gundersen', 'FRODE RA¸NLI MIA GUNDERSEN', 'FRODE RA¸NLI MIA GUNDERSEN', NULL, NULL, NULL);
INSERT INTO "contributors" VALUES(13, 'Pogo Pops', 'POGO POPS', 'POGO POPS', NULL, NULL, NULL);
INSERT INTO "contributors" VALUES(14, 'Silje Nergaard', 'SILJE NERGAARD', 'SILJE NERGAARD', NULL, NULL, NULL);
INSERT INTO "contributors" VALUES(15, 'Diverse Artister', 'DIVERSE ARTISTER', 'DIVERSE ARTISTER', NULL, NULL, NULL);
INSERT INTO "contributors" VALUES(16, 'Various Artists', 'VARIOUS ARTISTS', 'VARIOUS ARTISTS', NULL, NULL, NULL);
CREATE TABLE contributor_track (id integer UNIQUE PRIMARY KEY NOT NULL,role integer,contributor integer,track integer,namesort varchar);
INSERT INTO "contributor_track" VALUES(1, 6, 1, 1, 'ERIKSEN');
INSERT INTO "contributor_track" VALUES(2, 1, 2, 2, 'TRE SMA¥ KINESERE');
INSERT INTO "contributor_track" VALUES(3, 1, 3, 3, 'LYNNI TREEKREM KNUT REIERSRUD ANNBJA¸RG LIEN');
INSERT INTO "contributor_track" VALUES(4, 1, 4, 4, 'BJA¸RN EIDSVA¥G');
INSERT INTO "contributor_track" VALUES(5, 6, 5, 5, 'DANCE WITH A STRANGER');
INSERT INTO "contributor_track" VALUES(6, 6, 6, 6, 'DUMDUM BOYS DE LILLOS');
INSERT INTO "contributor_track" VALUES(7, 6, 7, 7, 'NOTODDEN BLUES BAND');
INSERT INTO "contributor_track" VALUES(8, 6, 8, 8, 'REIDAR LARSEN');
INSERT INTO "contributor_track" VALUES(9, 6, 9, 9, 'KARIN KROG');
INSERT INTO "contributor_track" VALUES(10, 1, 10, 10, 'AGNES BUEN GARNA¥S GUTTORM GUTTORMSEN');
INSERT INTO "contributor_track" VALUES(11, 6, 11, 11, 'MARIT MATHIESEN');
INSERT INTO "contributor_track" VALUES(12, 1, 12, 12, 'FRODE RA¸NLI MIA GUNDERSEN');
INSERT INTO "contributor_track" VALUES(13, 6, 13, 13, 'POGO POPS');
INSERT INTO "contributor_track" VALUES(14, 6, 14, 14, 'SILJE NERGAARD');
INSERT INTO "contributor_track" VALUES(15, 1, 15, 15, 'DIVERSE ARTISTER');
INSERT INTO "contributor_track" VALUES(16, 5, 16, 1, 'VARIOUS ARTISTS');
INSERT INTO "contributor_track" VALUES(17, 5, 16, 2, 'VARIOUS ARTISTS');
INSERT INTO "contributor_track" VALUES(18, 6, 2, 2, 'TRE SMA KINESERE');
INSERT INTO "contributor_track" VALUES(19, 5, 16, 3, 'VARIOUS ARTISTS');
INSERT INTO "contributor_track" VALUES(20, 6, 3, 3, 'LYNNI TREEKREM KNUT REIERSRUD ANNBJORG LIEN');
INSERT INTO "contributor_track" VALUES(21, 5, 16, 4, 'VARIOUS ARTISTS');
INSERT INTO "contributor_track" VALUES(22, 6, 4, 4, 'BJORN EIDSVAG');
INSERT INTO "contributor_track" VALUES(23, 5, 16, 5, 'VARIOUS ARTISTS');
INSERT INTO "contributor_track" VALUES(24, 5, 16, 6, 'VARIOUS ARTISTS');
INSERT INTO "contributor_track" VALUES(25, 5, 16, 7, 'VARIOUS ARTISTS');
INSERT INTO "contributor_track" VALUES(26, 5, 16, 8, 'VARIOUS ARTISTS');
INSERT INTO "contributor_track" VALUES(27, 5, 16, 9, 'VARIOUS ARTISTS');
INSERT INTO "contributor_track" VALUES(28, 5, 16, 10, 'VARIOUS ARTISTS');
INSERT INTO "contributor_track" VALUES(29, 6, 10, 10, 'AGNES BUEN GARNAS GUTTORM GUTTORMSEN');
INSERT INTO "contributor_track" VALUES(30, 5, 16, 11, 'VARIOUS ARTISTS');
INSERT INTO "contributor_track" VALUES(31, 5, 16, 12, 'VARIOUS ARTISTS');
INSERT INTO "contributor_track" VALUES(32, 6, 12, 12, 'FRODE RONLI MIA GUNDERSEN');
INSERT INTO "contributor_track" VALUES(33, 5, 16, 13, 'VARIOUS ARTISTS');
INSERT INTO "contributor_track" VALUES(34, 5, 16, 14, 'VARIOUS ARTISTS');
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);
INSERT INTO "genres" VALUES(1, 'Folk', 'FOLK', 'FOLK', NULL, NULL, NULL);
CREATE TABLE genre_track (id integer UNIQUE PRIMARY KEY NOT NULL,genre integer,track integer);
INSERT INTO "genre_track" VALUES(1, 1, 1);
INSERT INTO "genre_track" VALUES(2, 1, 2);
INSERT INTO "genre_track" VALUES(3, 1, 3);
INSERT INTO "genre_track" VALUES(4, 1, 4);
INSERT INTO "genre_track" VALUES(5, 1, 5);
INSERT INTO "genre_track" VALUES(6, 1, 6);
INSERT INTO "genre_track" VALUES(7, 1, 7);
INSERT INTO "genre_track" VALUES(8, 1, 8);
INSERT INTO "genre_track" VALUES(9, 1, 9);
INSERT INTO "genre_track" VALUES(10, 1, 10);
INSERT INTO "genre_track" VALUES(11, 1, 11);
INSERT INTO "genre_track" VALUES(12, 1, 12);
INSERT INTO "genre_track" VALUES(13, 1, 13);
INSERT INTO "genre_track" VALUES(14, 1, 14);
CREATE TABLE comments (id integer UNIQUE PRIMARY KEY NOT NULL,track integer,value varchar);
CREATE TABLE pluginversion (id integer UNIQUE PRIMARY KEY NOT NULL,name varchar,version integer);
CREATE INDEX trackURLIndex ON tracks (url);
CREATE INDEX trackTitleIndex ON tracks (title);
CREATE INDEX trackAlbumIndex ON tracks (album);
CREATE INDEX ctSortIndex ON tracks (ct);
CREATE INDEX trackSortIndex ON tracks (titlesort);
CREATE INDEX trackSearchIndex ON tracks (titlesearch);
CREATE INDEX trackRatingIndex ON tracks (rating);
CREATE INDEX trackPlayCountIndex ON tracks (playCount);
CREATE INDEX trackAudioIndex ON tracks (audio);
CREATE INDEX trackRemoteIndex ON tracks (remote);
CREATE INDEX trackSortKeyIndex ON tracks (multialbumsortkey);
CREATE INDEX albumsTitleIndex ON albums (title);
CREATE INDEX albumsSortIndex ON albums (titlesort);
CREATE INDEX albumsSearchIndex ON albums (titlesearch);
CREATE INDEX compilationSortIndex ON albums (compilation);
CREATE INDEX contributorsNameIndex ON contributors (name);
CREATE INDEX contributorsSortIndex ON contributors (namesort);
CREATE INDEX contributorsSearchIndex ON contributors (namesearch);
CREATE INDEX contributor_trackContribIndex ON contributor_track (contributor);
CREATE INDEX contributor_trackRoleIndex ON contributor_track (role);
CREATE INDEX contributor_trackTrackIndex ON contributor_track (track);
CREATE INDEX contributor_trackSortIndex ON contributor_track (namesort);
CREATE INDEX genreNameIndex ON genres (name);
CREATE INDEX genreSortIndex ON genres (namesort);
CREATE INDEX genreSearchIndex ON genres (namesearch);
CREATE INDEX genre_trackGenreIndex ON genre_track (genre);
CREATE INDEX genre_trackTrackIndex ON genre_track (track);
COMMIT;