SQLite format 3@ = =-&##!tableArtistArtistCREATE TABLE [Artist]
(
[ArtistId] INTEGER NOT NULL,
[Name] NVARCHAR(120),
CONSTRAINT [PK_Artist] PRIMARY KEY ([ArtistId])
)4GtableAlbumAlbumCREATE TABLE [Album]
(
[AlbumId] INTEGER NOT NULL,
[Title] NVARCHAR(160) NOT NULL,
[ArtistId] INTEGER NOT NULL,
CONSTRAINT [PK_Album] PRIMARY KEY ([AlbumId]),
FOREIGN KEY ([ArtistId]) REFERENCES [Artist] ([ArtistId])
O
JbN(pZ?%̸~c#5Garage Inc. (Disc 1)2"9Chill: Brazil (Disc 2)!9Chill: Brazil (Disc 1) 'Carnaval 2001!Bongo Fury!EBBC Sessions [Disc 1] [Live]+Axé Bahia 2001
Na Pista3Cidade Negra - Hits5Acústico MTV [Live]+Da Lama Ao Caos)Afrociberdelia)Minha Historia7Sozinho Remix Ao Vivo%Prenda Minha5mThe Best Of Buddy Guy - The Millenium Collection-Chemical Wedding!Body Count
$KBlack Sabbath Vol. 4 (Remaster)'Black Sabbath-]Alcohol Fueled Brewtality Live! [Disc 2]-]Alcohol Fueled Brewtality Live! [Disc 1]
=The Best Of Billy Cobham
3BackBeat Soundtrack %Out Of Exile
!Audioslave# IPlays Metallica By Four Cellos)Warner 25 Anos
Facelift1Jagged Little Pill
Big Ones/ Let There Be Rock/Restless and WildGSF>E)DAr@R?,:
9g8D7#6[C1"qM<h\O;(0+Barão Vermelho/+Hermeto Pascoal.Jorge Ben-'Sandra De Sá
,!Kid Abelha+%A Cor Do Som*/Milton Nascimento)#Elis Regina(#Os Cariocas')Fernanda Porto&+Banda Black Rio%Ed Motta
$O Rappa#9Pedro Luís & A Parede
"!Nando Reis!%Luiz Melodia )Ney Matogrosso'Baby Consuelo'Jorge Vercilo)Bebel Gilberto)João Gilberto%Gilberto Gil
AzymuthAMilton Nascimento & Bebeto%Marcos Valle"KFrank Zappa & Captain Beefheart%Led Zeppelin+Various Artists'Cláudio Zoli%Cidade Negra GChico Science & Nação Zumbi'Chico Buarque)Caetano VelosoBuddy Guy+Bruce Dickinson
!Body Count'Black Sabbath3Black Label Society
%Billy Cobham BackBeat
!Audioslave%Apocalyptica7Antônio Carlos Jobim+Alice In Chains/Alanis Moris53j2W19.-Y,0b--7DaanPeetersGrétrystraat 63BrusselsBelgium1000+32 02 219 03 03daan_peeters@apple.beuW)9AstridGruberRotenturmstraße 4, 1010 Innere StadtVienneAustria1010+43 01 5134505astrid.gruber@apple.at`))-+HelenaHolýRilská 3174/6PragueCzech Republic14300+420 2 4177 0449hholy@gmail.com!%-')--=FrantišekWichterlováJetBrains s.r.o.Klanova 9/506PragueCzech Republic14700+420 2 4172 5555+420 2 4172 5555frantisekw@jetbrains.com^/+7BjørnHansenUllevålsveien 14OsloNorway0171+47 22 44 22 22bjorn.hansen@yahoo.non1/3FrançoisTremblay1498 rue BélangerMontréalQCCanadaH2G 1A7+1 (514) 721-4711ftremblay@gmail.comn=-7LeonieKöhlerTheodor-Heuss-Straße 34StuttgartGermany70174+49 0711 2842222leonekohler@surfeu.deL!oK7115LuísGonçalvesEmbraer - Empresa Brasileira de Aeronáutica S.A.Av. Brigadeiro Faria Lima, 2170São José dos CamposSPBrazil12227-000+55 (12) 3923-5555+55 (12) 2)
##Z4GtableAlbumAlbumCREATE TABLE [Album]
(
[AlbumId] INTEGER NOT NULL,
[Title] NVARCHAR(160) NOT NULL,
[ArtistId] INTEGER NOT NULL,
CONSTRAINT [PK_Album] PRIMARY KEY ([AlbumId]),
FOREIGN KEY ([ArtistId]) REFERENCES [Artist] ([ArtistId])
ON DELETE NO ACTION ON UPDATE NO ACTION
)#!tableArtistArtistCREATE TABLE [Artist]
(
[ArtistId] INTEGER NOT NULL,
[Name] NVARCHAR(120),
CONSTRAINT [PK_Artist] PRIMARY KEY ([ArtistId])
)
n/tableCustomerCustomerCREATE TABLE [Customer]
(
[CustomerId] INTEGER NOT NULL,
[FirstName] NVARCHAR(40) NOT NULL,
[LastName] NVARCHAR(20) NOT NULL,
[Company] NVARCHAR(80),
[Address] NVARCHAR(70),
[City] NVARCHAR(40),
[State] NVARCHAR(40),
[Country] NVARCHAR(40),
[PostalCode] NVARCHAR(10),
[Phone] NVARCHAR(24),
[Fax] NVARCHAR(24),
[Email] NVARCHAR(60) NOT NULL,
[SupportRepId] INTEGER,
CONSTRAINT [PK_Customer] PRIMARY KEY ([CustomerId]),
FOREIGN KEY ([SupportRepId]) REFERENCES [Employee] ([EmployeeId])
ON DELETE NO ACTION ON UPDATE NO ACTION
)6-333%--7JohnsonSteveSales Support Agent1965-03-03 00:00:002003-10-17 00:00:007727B 41 AveCalgaryABCanadaT3B 1Y71 (780) 836-99871 (780) 836-9543steve@chinookcorp.com6333-//=ParkMargaretSales Support Agent1947-09-19 00:00:002003-05-03 00:00:00683 10 Street SWCalgaryABCanadaT2P 5G3+1 (403) 263-4423+1 (403) 263-4289margaret@chinookcorp.com.333'//5PeacockJaneSales Support Agent1973-08-29 00:00:002002-04-01 00:00:001111 6 Ave SWCalgaryABCanadaT2P 5M5+1 (403) 262-3443+1 (403) 262-6712jane@chinookcorp.com(' 33%//7EdwardsNancySales Manager1958-12-08 00:00:002002-05-01 00:00:00825 8 Ave SWCalgaryABCanadaT2P 2T3+1 (403) 262-3443+1 (403) 262-3322nancy@chinookcorp.com2+333//9AdamsAndrewGeneral Manager1962-02-18 00:00:002002-08-14 00:00:0011120 Jasper Ave NWEdmontonABCanadaT5K 2N1+1 (780) 428-9482+1 (780) 428-3457andrew@chinookcor
`qtableEmployeeEmployeeCREATE TABLE [Employee]
(
[EmployeeId] INTEGER NOT NULL,
[LastName] NVARCHAR(20) NOT NULL,
[FirstName] NVARCHAR(20) NOT NULL,
[Title] NVARCHAR(30),
[ReportsTo] INTEGER,
[BirthDate] DATETIME,
[HireDate] DATETIME,
[Address] NVARCHAR(70),
[City] NVARCHAR(40),
[State] NVARCHAR(40),
[Country] NVARCHAR(40),
[PostalCode] NVARCHAR(10),
[Phone] NVARCHAR(24),
[Fax] NVARCHAR(24),
[Email] NVARCHAR(60),
CONSTRAINT [PK_Employee] PRIMARY KEY ([EmployeeId]),
FOREIGN KEY ([ReportsTo]) REFERENCES [Employee] ([EmployeeId])
ON DELETE NO ACTION ON UPDATE NO ACTION
)tableGenreGenre CREATE TABLE [Genre]
(
[GenreId] INTEGER NOT NULL,
[Name] NVARCHAR(120),
CONSTRAINT [PK_Genre] PRIMARY KEY ([GenreId])
)
vcSF0&OperaClassical#Alternative ComedyDrama-Sci Fi & FantasyTV Shows+Science Fiction#Hip Hop/RapWorld/Electronica/DanceR&B/Soul
#Heavy Metal)Easy Listening
!Bossa Nova
!Soundtrack Pop ReggaeLatinBlues'Rock And Roll1Alternative & PunkMetalJazzRock">ztnhb\VPJD>S
3=2009-02-11 00:00:00Theodor-Heuss-Straße 34StuttgartGermany70174@+QQ
3/)42009-02-06 00:00:00202 Hoxton StreetLondonUnited KingdomN1 5LH@!RI
3-.2009-02-03 00:00:003 Chatham StreetDublinDublinIreland@\(O
39*2009-02-02 00:00:009, Place Louis BarthouBordeauxFrance33000@zGD
3)(2009-02-01 00:00:008, Rue HanovreParisFrance75002?zGL
35&2009-02-01 00:00:00Barbarossastraße 19BerlinGermany10779?zGL
3/%2009-01-19 00:00:00Berger Straße 10FrankfurtGermany60316?zGD
3+2009-01-11 00:00:0069 Salem StreetBostonMAUSA2113@+QK
3)2009-01-06 00:00:008210 111 ST NWEdmontonABCanadaT6G 2C7@!RI
3-2009-01-03 00:00:00Grét{pdYMA5)ymaUI>2&߁ށفxl`TH<0$
tableInvoiceInvoice
CREATE TABLE [Invoice]
(
[InvoiceId] INTEGER NOT NULL,
[CustomerId] INTEGER NOT NULL,
[InvoiceDate] DATETIME NOT NULL,
[BillingAddress] NVARCHAR(70),
[BillingCity] NVARCHAR(40),
[BillingState] NVARCHAR(40),
[BillingCountry] NVARCHAR(40),
[BillingPostalCode] NVARCHAR(10),
[Total] NUMERIC(10,2) NOT NULL,
CONSTRAINT [PK_Invoice] PRIMARY KEY ([InvoiceId]),
FOREIGN KEY ([CustomerId]) REFERENCES [Customer] ([CustomerId])
ON DELETE NO ACTION ON UPDATE NO ACTION
)2u~xrlf`ZTNHB<60*$1
?zG0
?zG/
?zG.
?zG-
?zG, ?zG+ ?zG* ?zG) ?zG( ?zG' ?zG& ?zG% ?zG$ ?zG# ?zG" ?zG! ?zG ?zG ?zG ?zG ?zG ?zG ?zG ?zG ~?zG u?zG l?zG c?zG Z?zG T?zG N?zG H?zGs<pmdk8hf`d4a^\\0ZWXU,RPTM(K|HPF$CxAL> <t:H75p2D0-l+@)&h$<! d8].R$v Hl>a1
;;HJJ9M'indexsqlite_autoindex_PlaylistTrack_1PlaylistTrack/ 1tablePlaylistPlaylistCREATE TABLE [Playlist]
(
[PlaylistId] INTEGER NOT NULL,
[Name] NVARCHAR(120),
CONSTRAINT [PK_Playlist] PRIMARY KEY ([PlaylistId])
)
##[tableInvoiceLineInvoiceLineCREATE TABLE [InvoiceLine]
(
[InvoiceLineId] INTEGER NOT NULL,
[InvoiceId] INTEGER NOT NULL,
[TrackId] INTEGER NOT NULL,
[UnitPrice] NUMERIC(10,2) NOT NULL,
[Quantity] INTEGER NOT NULL,
CONSTRAINT [PK_InvoiceLine] PRIMARY KEY ([InvoiceLineId]),
FOREIGN KEY ([InvoiceId]) REFERENCES [Invoice] ([InvoiceId])
ON DELETE NO ACTION ON UPDATE NO ACTION,
FOREIGN KEY ([TrackId]) REFERENCES [Track] ([TrackId])
ON DELETE NO ACTION ON UPDATE NO ACTION
)59tableMediaTypeMediaTypeCREATE TABLE [MediaType]
(
[MediaTypeId] INTEGER NOT NULL,
[Name] NVARCHAR(120),
CONSTRAINT [PK_MediaType] PRIMARY KEY ([MediaTypeId])
)
)AAC audio file=Purchased AAC audio fileCProtected MPEG-4 video file=Protected AAC audio file+MPEG audio file
|hZ<#On-The-Go 13Heavy Metal Classic GrungeAClassical 101 - The BasicsAClassical 101 - Next Steps
?Classical 101 - Deep CutsClassical+Brazilian Music
TV Shows %Music VideosMusic Movies
!Audiobooks%90’s Music
!AudiobooksTV Shows MoviesMusic[}wqke_YSMGA;5/)#{uoic]WQKE?93-'! zsle^WPIB;4-&
r q p o n m l k j i h g f e d c b a ` _ ^ ] \ [ Z Y X W
0V
/U
.T
-S
,R
+Q
*P&Jn6Z~"Fjۻ2VϹz˹ǸB÷f
.Rv>b*Nr:^|&xJonie6aZ]}YS;M_KG'BK=o<872[+~(!%D f
.Ru:To
%@[vޒ,ڑGؐbя}ȏĎ+Fa|1Lg8Sl"=}X|rtsfYL?2%|pcVI</"}oaSE7)
Ⱥj f 2!b _ DZEN
yaC [X> :
W
\U H t\4 J. I9, KJ) /@& ! P YE 6 G X #=
B
Y
O u KG F
O
4
'N ~\ &
~ "
r ; ~ d B \ e 5 3 R 6%
j~ w s KJ
dd`/ 1tablePlaylistPlaylistCREATE TABLE [Playlist]
(
[PlaylistId] INTEGER NOT NULL,
[Name] NVARCHAR(120),
CONSTRAINT [PK_Playlist] PRIMARY KEY ([PlaylistId])
),
''tablePlaylistTrackPlaylistTrackCREATE TABLE [PlaylistTrack]
(
[PlaylistId] INTEGER NOT NULL,
[TrackId] INTEGER NOT NULL,
CONSTRAINT [PK_PlaylistTrack] PRIMARY KEY ([PlaylistId], [TrackId]),
FOREIGN KEY ([PlaylistId]) REFERENCES [Playlist] ([PlaylistId])
ON DELETE NO ACTION ON UPDATE NO ACTION,
FOREIGN KEY ([TrackId]) REFERENCES [Track] ([TrackId])
ON DELETE NO ACTION ON UPDATE NO ACTION
)9M'indexsqlite_autoindex_PlaylistTrack_1PlaylistTrack~xrlf`ZTNHB<60*$|vpjd^XRLF@:4.("
ztnhb\VPJD>82,& _tf\M>1 $uj\Q=,qcWK?3&q\J:*܋ۊsڊd؊VHՊ8ӊ(ъЊΉt͉fˉZʉMɉ?lj-ʼnÉ
wl[H7%
|mdWE9(
ydO=-$}scP>/veTA4(~y|j{^ySxAv1u sronn]lRkFj6i(gf cyae`U_F^4]"XSRqQdPVOEN5M'L=
88I=YtableTrackTrackCREATE TABLE [Track]
(
[TrackId] INTEGER NOT NULL,
[Name] NVARCHAR(200) NOT NULL,
[AlbumId] INTEGER,
[MediaTypeId] INTEGER NOT NULL,
[GenreId] INTEGER,
[Composer] NVARCHAR(220),
[Milliseconds] INTEGER NOT NULL,
[Bytes] INTEGER,
[UnitPrice] NUMERIC(10,2) NOT NULL,
CONSTRAINT [PK_Track] PRIMARY KEY ([TrackId]),
FOREIGN KEY ([AlbumId]) REFERENCES [Album] ([AlbumId])
ON DELETE NO ACTION ON UPDATE NO ACTION,
FOREIGN KEY ([GenreId]) REFERENCES [Genre] ([GenreId])
ON DELETE NO ACTION ON UPDATE NO ACTION,
FOREIGN KEY ([MediaTypeId]) REFERENCES [MediaType] ([MediaTypeId])
ON DELETE NO ACTION ON UPDATE NO ACTION
)O
windexIPK_AlbumAlbumCREATE UNIQUE INDEX [IPK_Album] ON [Album]([AlbumId])T!}indexIPK_ArtistArtistCREATE UNIQUE INDEX [IPK_Artist] ON [Artist]([ArtistId])_% indexIPK_CustomerCustomerCREATE UNIQUE INDEX [IPK_Customer] ON [Customer]([CustomerId])H~xrlf`ZTNHB<60*$|vpjd^XRLF@:4.("
ztnhb\VPJD>82,& ~~}}||{{zzyyxxwwvvuuttssrrqqppoonnmmllkkjjiihhggffeeddccbbaa``__^^]]\\[[ZZYYXXWWVVUUTTSSRRQQPPOONNMMLLKKJJIIHHGGFFEEDDCCBBAA@@??>>==<<;;::99887766554433221100//..--,,++**))((''&&%%$$##""!!
B<;qq4~xrlf`ZTNHB<60*$|vpjd^XRLF@:4.("
ztnhb\VPJD>82,& ~~}}||{{zzyyxxwwvvuuttssrrqqppoonnmmllkkjjiihhggffeeddccbbaa``__^^]]\\[[ZZYYXXWWVVUUTTSSRRQQPPOONNMMLLKKJJIIHHGGFFEEDDCCBBAA@@??>>==<<;;::99887766554433221100//..--,,++**))((''&&%%$$##""!!
0/aa
;~xrlf`ZTNHB<60*$;;::99887766554433221100//..--,,++**))((''&&%%$$##""!!
@rS3~/'3indexIPK_PlaylistTrackPlaylistTrackCREATE UNIQUE INDEX [IPK_PlaylistTrack] ON [Pl_% indexIPK_EmployeeEmployeeCREATE UNIQUE INDEX [IPK_Employee] ON [Employee]([EmployeeId])OwindexIPK_GenreGenreCREATE UNIQUE INDEX [IPK_Genre] ON [Genre]([GenreId])Z#indexIPK_InvoiceInvoiceCREATE UNIQUE INDEX [IPK_Invoice] ON [Invoice]([InvoiceId])n+#indexIPK_InvoiceLineInvoiceLineCREATE UNIQUE INDEX [IPK_InvoiceLine] ON [InvoiceLine]([InvoiceLineId])d'indexIPK_MediaTypeMediaTypeCREATE UNIQUE INDEX [IPK_MediaType] ON [MediaType]([MediaTypeId])_% indexIPK_PlaylistPlaylistCREATE UNIQUE INDEX [IPK_Playlist] ON [Playlist]([PlaylistId])~/'3indexIPK_PlaylistTrackPlaylistTrackCREATE UNIQUE INDEX [IPK_PlaylistTrack] ON [PlaylistTrack]([PlaylistId], [TrackId])OwindexIPK_TrackTrack CREATE UNIQUE INDEX [IPK_Track] ON [Track]([TrackId])Z/}indexIFK_AlbumArtistIdAlbum!CREATE INDEX [IFK_AlbumArtistId] ON [Album] ([ArtistId])
l~xrl
~xrlf`ZTNHB<60*$|vpjd^XRLF@:4.("
ztnhb\VPJD>82,& ~~}}||{{zzyyxxwwvvuuttssrrqqppoonnmmllkkjjiihhggffeeddccbbaa``__^^]]\\[[ZZYYXXWWVVUUTTSSRRQQPPOONNMMLLKKJJIIHHGGFFEEDDCCBBAA@@??>>==<<;;::99887766554433221100//..--,,++**))((''&&%%$$##""!!
88qqt~rfZNB6*`ZTNHB<60*$|vpjd^XRLF@:4.("
ztnhb\VPJD>82,& ~~}}||{{zzyyxxwwvvuuttssrrqqppoonnmmllkkjjiihhggffeeddccbbaa``__^^]]\\[[ZZYYXXWWVVUUTTSSRRQQPPOONNMMLLKKJJIIHHGGFFEEDDCCBBAA@@??>>==<<;;::998877665544332211o||j//e`||[""VQnnLGB``=83RR.(#DD66((qq
wsfYL?2%|pcVI</"}oaSE7)
Ⱥk g 2!c ` D[EO
yaD [X? ;
X
\V I t\5 J/ I9- KJ* /@' " Q YF 7 G X #=
B
Y
O u KG F
O
4
'N ~\ &
~ "
r ; ~ d B \ e 5 3 R 6%
j y v KJ&:~rfZNB6*vj^RF:|vpjd^XRLF@:4.("
ztnhb\VPJD>82,& ~~}}||{{zzyyxxwwvvuuttssrrqqppoonnmmllkkjjiihhggffeeddccbbaa``__^^]]\\[[ZZYYXXWWVVUUTTSSRRQQPPOONNMM
h
h
hh|ZZuj
a
L
LX M C > >9/%00||""nn``RRDD66wmb((UTqqI7ysmga[UCO I=Y'1+%
}wqke_SMGA;5/)#{uoic]WQKE?93-!4~b}a|`{.z_y^x]w\v\u\t[sZrZqZpZoZnZmZlZkZjZiZhZgZfZeZdZcZbZaZ`Z_Z^Y]X\X[XZ6YWXWVUVTUSTRTQTPTOSNRMRLRKRJQIQH)GPFPEODNC:B:A:@:?:>:=:<:;::M9M8L7L65F4E3:2D1D0%/;.-,:+9*8)7(6'5&4%3$2#"!
C >=PF
;qSM;#}we_A5/kYG);:9876543210/.-,+*)('&%$#"!
8lC-8x='indexIFK_Plad!5 indexIFK_TrackMediaTypeIdTrack+CREATE INDEX [IFK_TrackMediaTypeId] ON [Track] ([MediaTypeId])W -yindexIFK_TrackGenreIdTrack*CREATE INDEX [IFK_TrackGenreId] ON [Track] ([GenreId])s=indexIFK_CustomerSupportRepIdCustomer"CREATE INDEX [IFK_CustomerSupportRepId] ON [Customer] ([SupportRepId])j7
indexIFK_EmployeeReportsToEmployee$CREATE INDEX [IFK_EmployeeReportsTo] ON [Employee] ([ReportsTo])i7
indexIFK_InvoiceCustomerIdInvoice%CREATE INDEX [IFK_InvoiceCustomerId] ON [Invoice] ([CustomerId])v=#indexIFK_InvoiceLineInvoiceIdInvoiceLine&CREATE INDEX [IFK_InvoiceLineInvoiceId] ON [InvoiceLine] ([InvoiceId])p9#indexIFK_InvoiceLineTrackIdInvoiceLine'CREATE INDEX [IFK_InvoiceLineTrackId] ON [InvoiceLine] ([TrackId])x='indexIFK_PlaylistTrackTrackIdPlaylistTrack(CREATE INDEX [IFK_PlaylistTrackTrackId] ON [PlaylistTrack] ([TrackId])W-yindexIFK_TrackAlbumIdTrack)CREATE INDEX [IFK_TrackAlbumId] ON [Track] ([AlbumId])
nq93'-'ki!5/!)#hbe\Vc]PWQJ_YKS MEDG zA?{tu>8};2w%#~"}|{z y:x8w7v)u tsrqpon5m/l+k)j'i&hgf edc b;a-`$_^]\[ZY9X3W/V-U+T*SRQ
P ONML1K(J"IHGFEDC7B3A1@/?.> =<;
:9 8756,5&4"3 210/.;-7,5+3*2)$('&%$
#"9!0 *&$"!
;976(
4.
* (!2) "qwk_SG;/#ga[UOIC=71+%
}wqke_YSMGA;5/)#{uoic]WQKE?93-'! ~}|{zyxwvutsrqponmlkjihgfedcba`_^]\[ZYXWVUTSRQPONMLK
JIHGFEDCBA@?>=<;:9876543
2
1
0
/lkg}bj][WXKT9O*IJE?;;61-,'y"rc_
K;8(prpeYMA5)|d]VOHA:3,% }vohaZSLE>70)"
zsle^WPIB;4-&
srqponmlk{jriih`gWfNeEd