** This file contains an SQLite 2.1 database **(uãÚ£ HôÿÿFEÛ€ &)Ûtablelist_tagslist_tags23create table list_tags ( item_id integer, üø item_id integer , item_order integer )ø group_name char ) 0 € captiontag_280g_Ð tag_name char, tag_col char, tag_free integer )è(€ tag_11H€ tag_21h€ tag_31ˆ€ tag_41¨€ tag_51È€ tag_61è€ tag_71€ tag_81(€  tag_91H€  tag_101h€  tag_111ˆ€  tag_121¨€  tag_131È€ tag_141è€ tag_151€ tag_1618€Original artisttag_170h€Original titletag_180”€Release typetag_1900¼€ Sourcetag_200_19ä€Rip datetag_2109€Ripping tooltag_2200@ € Encoding settingstag_230h€Languagetag_240t€ ratingtag_2500t¸€ lyricstag_2600t€in-queue-imagetag_270080€ sectiontag_290g_T€ filetag_300x€ Tempotag_310 € Copyrighttag_320Ô$€!"$Comment-iTunes_CDDB_1tag_330.€"%,.Comment-iTunes_CDDB_TrackNumbertag_340@€#Media typetag_350Trah€$File typetag_360€%Composertag_370¸€& Lengthtag_3800à€' Decadetag_3900 €(Encoded bytag_400Tra0€) Yeartag_410_X€* Commenttag_4200€€+Publishertag_430¤€, Bandtag_4404È€- Tracktag_450ì€. Genretag_460€/ Albumtag_470€0 Artisttag_4800È$D cversion€cdata-version€¼P( € version4€data-version15019° param_value char )–€ *,–tablegroup_itemsgroup_items3create table group_items ( group_id integer , D€  "Dtablegroupsgroups5create table groups ( group_id integer primary key , @M€ (+Mtableparametersparameters12create table parameters ( param_name char primary key , H3€ %033index(parameters autoindex 1)parameters11Dý€ (+ýtableview_stepsview_steps16create table view_steps ( view_step_id integer primary key, c€ !ctableviewsviews20create table views ( view_id integer primary key , À4€Ä 3AlbumimagesyesÌ view_id integer , group_tag char , group_func char, mode char, sort_tag char, sort_asc char, sort_type char )è4€º 6indexindexyesX€» 6listyesŒ"€¼ ""1ArtistlistArtistyes¸€½ 1Albumimagesyesð&€¾ "&1album-tracksTrackyesint$"€¿ ""2ArtistindexindexyesinP€À 2Artistlistyese|€Á 2Albumimagesyes´&€Â "&2album-tracksTrackyesint!€Ã !!3Albumindexindexyesin @&€Å "&3album-tracksTrackyesintl€Æ 4Genreindexyesc˜€Ç 4ArtistlistyescÄ€È 4Albumimagesyesü&€É "&4album-tracksTrackyesint(€Ê 5GenreindexyescT€Ë 5AlbumimagesyesŒ&€Ì "&5album-tracksTrackyesint¼€Í 7YearindexYearnoyeè€Î 7Albumimagesyes&€Ï "&7album-tracksTrackyesintà48 € By Artist Alphabetical1d€By Artist Index2icaŒ€By Album Index3¼€By Genre And Artist41è€By Genre And Album5€By Title Index6€By Year7ndeÌ view_name char, view_order integer, view_filter char, custom_1 char, custom_2 char )øø tag_name char, tag_values char, primary key ( item_id , tag_name ) )d.group_id; end@L1€  $.11index(list_tags autoindex 1)list_tags22H€ ")+triggergroups_deletegroups0create trigger groups_delete before delete on groups begin delete from group_items where group_id = olDÿ€ !#ÿtriggerviews_deleteviews0create trigger views_delete before delete on views begin delete from view_steps where view_id = old.view_id;–€ (+–tableitem_datesitem_dates28create table item_dates ( item_id integer primary key, À endø created integer, modified integer )ø item_name char , item_location char , item_ext_id char , item_date integer, item_image char, tag_2 char ,tag_3 char ,tag_14 char ,tag_7 char ,tag_22 char ,tag_17 char ,tag_21 char ,tag_13 char ,tag_20 char ,tag_5 char ,tag_8 char ,tag_23 char ,tag_6 char ,tag_16 char ,tag_24 char ,tag_9 char ,tag_12 char ,tag_19 char ,tag_15 char ,tag_10 char ,tag_11 char ,tag_18 char ,tag_1 char ,tag_4 char ,tag_25 char ,tag_26 char ,tag_27 char ,tag_28 char ,tag_29 char ,tag_30 char ,tag_31 char ,tag_32 char ,tag_33 char ,tag_34 char ,tag_35 char ,tag_36 char ,tag_37 char ,tag_38 char ,tag_39 char ,tag_40 char ,tag_41 char ,tag_42 char ,tag_43 char ,tag_44 char ,tag_45 char ,tag_46 char ,tag_47 char ,tag_48 char )øøøà|c€ %(cindexitems_location_idxitems32create index items_location_idx on items ( item_location )|ì]€ #&]indexitems_ext_id_idxitems33create index items_ext_id_idx on items ( item_ext_id )\HK€  Kindexitem_tag_2items34create index item_tag_2 on items ( tag_2 )s¤K€  Kindexitem_tag_3items36create index item_tag_3 on items ( tag_3 )sN€ !Nindexitem_tag_14items37create index item_tag_14 on items ( tag_14 ) i`K€  Kindexitem_tag_7items38create index item_tag_7 on items ( tag_7 ) ÀN€ !Nindexitem_tag_22items39create index item_tag_22 on items ( tag_22 ) i N€ !Nindexitem_tag_17items40create index item_tag_17 on items ( tag_17 ) i€N€ !Nindexitem_tag_21items41create index item_tag_21 on items ( tag_21 ) iN€ !Nindexitem_tag_13items42create index item_tag_13 on items ( tag_13 ) i øøøøøøøø¸dK€  Kindexitem_tag_5items45create index item_tag_5 on items ( tag_5 ) ÀK€  Kindexitem_tag_8items46create index item_tag_8 on items ( tag_8 )  N€ !Nindexitem_tag_23items47create index item_tag_23 on items ( tag_23 ) i|K€  Kindexitem_tag_6items48create index item_tag_6 on items ( tag_6 ) ÜN€ !Nindexitem_tag_16items49create index item_tag_16 on items ( tag_16 ) i<N€ !Nindexitem_tag_24items50create index item_tag_24 on items ( tag_24 ) i˜K€  Kindexitem_tag_9items51create index item_tag_9 on items ( tag_9 ) øN€  !Nindexitem_tag_12items52create index item_tag_12 on items ( tag_12 ) iXN€! !Nindexitem_tag_19items53create index item_tag_19 on items ( tag_19 ) iN€" !Nindexitem_tag_15items54create index item_tag_15 on items ( tag_15 ) iHøøøøøøøøøøøÀhN€$ !Nindexitem_tag_11items57create index item_tag_11 on items ( tag_11 ) iÈN€% !Nindexitem_tag_18items58create index item_tag_18 on items ( tag_18 ) i$K€&  Kindexitem_tag_1items59create index item_tag_1 on items ( tag_1 ) €K€'  Kindexitem_tag_4items60create index item_tag_4 on items ( tag_4 ) àN€( !Nindexitem_tag_25items61create index item_tag_25 on items ( tag_25 ) i@N€) !Nindexitem_tag_26items62create index item_tag_26 on items ( tag_26 ) i N€* !Nindexitem_tag_27items63create index item_tag_27 on items ( tag_27 ) iN€+ !Nindexitem_tag_28items64create index item_tag_28 on items ( tag_28 ) i`N€, !Nindexitem_tag_29items65create index item_tag_29 on items ( tag_29 ) iN€- !Nindexitem_tag_30items66create index item_tag_30 on items ( tag_30 ) i@øøøøøøøøøøøÈhN€/ !Nindexitem_tag_32items71create index item_tag_32 on items ( tag_32 ) iÈN€0 !Nindexitem_tag_33items72create index item_tag_33 on items ( tag_33 ) i(N€1 !Nindexitem_tag_34items73create index item_tag_34 on items ( tag_34 ) iˆN€2 !Nindexitem_tag_35items74create index item_tag_35 on items ( tag_35 ) ièN€3 !Nindexitem_tag_36items75create index item_tag_36 on items ( tag_36 ) iHN€4 !Nindexitem_tag_37items76create index item_tag_37 on items ( tag_37 ) i¨N€5 !Nindexitem_tag_38items77create index item_tag_38 on items ( tag_38 ) iN€6 !Nindexitem_tag_39items78create index item_tag_39 on items ( tag_39 ) ihN€7 !Nindexitem_tag_40items79create index item_tag_40 on items ( tag_40 ) iN€8 !Nindexitem_tag_41items80create index item_tag_41 on items ( tag_41 ) i8Ѐ Ðtabletagstags7create table tags ( tag_id integer primary key, ü[€Ä€ !Ätableitemsitems30create table items ( item_id integer primary key , #dN€ !Nindexitem_tag_20items43create index item_tag_20 on items ( tag_20 ) i,ÄN€# !Nindexitem_tag_10items55create index item_tag_10 on items ( tag_10 ) i8$N€. !Nindexitem_tag_31items67create index item_tag_31 on items ( tag_31 ) iD„N€9 !Nindexitem_tag_42items81create index item_tag_42 on items ( tag_42 ) iRM€@ !')Mtriggeritems_deleteitems0create trigger items_delete before delete on items begin delete from group_items where item_id = old.iY€øøøøøøøøøøøHhN€: !Nindexitem_tag_43items83create index item_tag_43 on items ( tag_43 ) iÈN€; !Nindexitem_tag_44items84create index item_tag_44 on items ( tag_44 ) i(N€< !Nindexitem_tag_45items85create index item_tag_45 on items ( tag_45 ) iˆN€= !Nindexitem_tag_46items86create index item_tag_46 on items ( tag_46 ) ièN€> !Nindexitem_tag_47items87create index item_tag_47 on items ( tag_47 ) iN€? !Nindexitem_tag_48items88create index item_tag_48 on items ( tag_48 ) i¸øøøøøøtem_id; delete from list_tags where item_id = old.item_id; end_id , created , modified ) values ( new.item_id , idt_now() , idt_now() ); update parameters set param_value = param_value + 1 where param_name = "data-version"; endüâ€A &,.âtriggeritem_dates_insertitems0create trigger item_dates_insert after insert on items begin insert or replace into item_dates ( itemZš€B &,.štriggeritem_dates_deleteitems0create trigger item_dates_delete after delete on items begin delete from item_dates where item_id = o\â€C &,.âtriggeritem_dates_updateitems0create trigger item_dates_update after update on items begin update item_dates set modified = idt_now]ld.item_id; update parameters set param_value = param_value + 1 where param_name = "data-version"; end() where item_id = new.item_id; update parameters set param_value = param_value + 1 where param_name = "data-version"; end