-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathChinook_PostgreSql.sql
15865 lines (15797 loc) · 586 KB
/
Chinook_PostgreSql.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
343
344
345
346
347
348
349
350
351
352
353
354
355
356
357
358
359
360
361
362
363
364
365
366
367
368
369
370
371
372
373
374
375
376
377
378
379
380
381
382
383
384
385
386
387
388
389
390
391
392
393
394
395
396
397
398
399
400
401
402
403
404
405
406
407
408
409
410
411
412
413
414
415
416
417
418
419
420
421
422
423
424
425
426
427
428
429
430
431
432
433
434
435
436
437
438
439
440
441
442
443
444
445
446
447
448
449
450
451
452
453
454
455
456
457
458
459
460
461
462
463
464
465
466
467
468
469
470
471
472
473
474
475
476
477
478
479
480
481
482
483
484
485
486
487
488
489
490
491
492
493
494
495
496
497
498
499
500
501
502
503
504
505
506
507
508
509
510
511
512
513
514
515
516
517
518
519
520
521
522
523
524
525
526
527
528
529
530
531
532
533
534
535
536
537
538
539
540
541
542
543
544
545
546
547
548
549
550
551
552
553
554
555
556
557
558
559
560
561
562
563
564
565
566
567
568
569
570
571
572
573
574
575
576
577
578
579
580
581
582
583
584
585
586
587
588
589
590
591
592
593
594
595
596
597
598
599
600
601
602
603
604
605
606
607
608
609
610
611
612
613
614
615
616
617
618
619
620
621
622
623
624
625
626
627
628
629
630
631
632
633
634
635
636
637
638
639
640
641
642
643
644
645
646
647
648
649
650
651
652
653
654
655
656
657
658
659
660
661
662
663
664
665
666
667
668
669
670
671
672
673
674
675
676
677
678
679
680
681
682
683
684
685
686
687
688
689
690
691
692
693
694
695
696
697
698
699
700
701
702
703
704
705
706
707
708
709
710
711
712
713
714
715
716
717
718
719
720
721
722
723
724
725
726
727
728
729
730
731
732
733
734
735
736
737
738
739
740
741
742
743
744
745
746
747
748
749
750
751
752
753
754
755
756
757
758
759
760
761
762
763
764
765
766
767
768
769
770
771
772
773
774
775
776
777
778
779
780
781
782
783
784
785
786
787
788
789
790
791
792
793
794
795
796
797
798
799
800
801
802
803
804
805
806
807
808
809
810
811
812
813
814
815
816
817
818
819
820
821
822
823
824
825
826
827
828
829
830
831
832
833
834
835
836
837
838
839
840
841
842
843
844
845
846
847
848
849
850
851
852
853
854
855
856
857
858
859
860
861
862
863
864
865
866
867
868
869
870
871
872
873
874
875
876
877
878
879
880
881
882
883
884
885
886
887
888
889
890
891
892
893
894
895
896
897
898
899
900
901
902
903
904
905
906
907
908
909
910
911
912
913
914
915
916
917
918
919
920
921
922
923
924
925
926
927
928
929
930
931
932
933
934
935
936
937
938
939
940
941
942
943
944
945
946
947
948
949
950
951
952
953
954
955
956
957
958
959
960
961
962
963
964
965
966
967
968
969
970
971
972
973
974
975
976
977
978
979
980
981
982
983
984
985
986
987
988
989
990
991
992
993
994
995
996
997
998
999
1000
/*******************************************************************************
Chinook Database - Version 1.4.5
Script: Chinook_PostgreSql.sql
Description: Creates and populates the Chinook database.
DB Server: PostgreSql
Author: Luis Rocha
License: https://github.com/lerocha/chinook-database/blob/master/LICENSE.md
********************************************************************************/
/*******************************************************************************
WARNING: This file was generated by a tool and changes to this file
will be lost when this file is regenerated.
********************************************************************************/
\c chinook;
/*******************************************************************************
Create Tables
********************************************************************************/
CREATE TABLE album
(
album_id INT NOT NULL,
title VARCHAR(160) NOT NULL,
artist_id INT NOT NULL,
CONSTRAINT album_pkey PRIMARY KEY (album_id)
);
CREATE TABLE artist
(
artist_id INT NOT NULL,
name VARCHAR(120),
CONSTRAINT artist_pkey PRIMARY KEY (artist_id)
);
CREATE TABLE customer
(
customer_id INT NOT NULL,
first_name VARCHAR(40) NOT NULL,
last_name VARCHAR(20) NOT NULL,
company VARCHAR(80),
address VARCHAR(70),
city VARCHAR(40),
state VARCHAR(40),
country VARCHAR(40),
postal_code VARCHAR(10),
phone VARCHAR(24),
fax VARCHAR(24),
email VARCHAR(60) NOT NULL,
support_rep_id INT,
CONSTRAINT customer_pkey PRIMARY KEY (customer_id)
);
CREATE TABLE employee
(
employee_id INT NOT NULL,
last_name VARCHAR(20) NOT NULL,
first_name VARCHAR(20) NOT NULL,
title VARCHAR(30),
reports_to INT,
birth_date TIMESTAMP,
hire_date TIMESTAMP,
address VARCHAR(70),
city VARCHAR(40),
state VARCHAR(40),
country VARCHAR(40),
postal_code VARCHAR(10),
phone VARCHAR(24),
fax VARCHAR(24),
email VARCHAR(60),
CONSTRAINT employee_pkey PRIMARY KEY (employee_id)
);
CREATE TABLE genre
(
genre_id INT NOT NULL,
name VARCHAR(120),
CONSTRAINT genre_pkey PRIMARY KEY (genre_id)
);
CREATE TABLE invoice
(
invoice_id INT NOT NULL,
customer_id INT NOT NULL,
invoice_date TIMESTAMP NOT NULL,
billing_address VARCHAR(70),
billing_city VARCHAR(40),
billing_state VARCHAR(40),
billing_country VARCHAR(40),
billing_postal_code VARCHAR(10),
total NUMERIC(10,2) NOT NULL,
CONSTRAINT invoice_pkey PRIMARY KEY (invoice_id)
);
CREATE TABLE invoice_line
(
invoice_line_id INT NOT NULL,
invoice_id INT NOT NULL,
track_id INT NOT NULL,
unit_price NUMERIC(10,2) NOT NULL,
quantity INT NOT NULL,
CONSTRAINT invoice_line_pkey PRIMARY KEY (invoice_line_id)
);
CREATE TABLE media_type
(
media_type_id INT NOT NULL,
name VARCHAR(120),
CONSTRAINT media_type_pkey PRIMARY KEY (media_type_id)
);
CREATE TABLE playlist
(
playlist_id INT NOT NULL,
name VARCHAR(120),
CONSTRAINT playlist_pkey PRIMARY KEY (playlist_id)
);
CREATE TABLE playlist_track
(
playlist_id INT NOT NULL,
track_id INT NOT NULL,
CONSTRAINT playlist_track_pkey PRIMARY KEY (playlist_id, track_id)
);
CREATE TABLE track
(
track_id INT NOT NULL,
name VARCHAR(200) NOT NULL,
album_id INT,
media_type_id INT NOT NULL,
genre_id INT,
composer VARCHAR(220),
milliseconds INT NOT NULL,
bytes INT,
unit_price NUMERIC(10,2) NOT NULL,
CONSTRAINT track_pkey PRIMARY KEY (track_id)
);
/*******************************************************************************
Create Primary Key Unique Indexes
********************************************************************************/
/*******************************************************************************
Create Foreign Keys
********************************************************************************/
ALTER TABLE album ADD CONSTRAINT album_artist_id_fkey
FOREIGN KEY (artist_id) REFERENCES artist (artist_id) ON DELETE NO ACTION ON UPDATE NO ACTION;
CREATE INDEX album_artist_id_idx ON album (artist_id);
ALTER TABLE customer ADD CONSTRAINT customer_support_rep_id_fkey
FOREIGN KEY (support_rep_id) REFERENCES employee (employee_id) ON DELETE NO ACTION ON UPDATE NO ACTION;
CREATE INDEX customer_support_rep_id_idx ON customer (support_rep_id);
ALTER TABLE employee ADD CONSTRAINT employee_reports_to_fkey
FOREIGN KEY (reports_to) REFERENCES employee (employee_id) ON DELETE NO ACTION ON UPDATE NO ACTION;
CREATE INDEX employee_reports_to_idx ON employee (reports_to);
ALTER TABLE invoice ADD CONSTRAINT invoice_customer_id_fkey
FOREIGN KEY (customer_id) REFERENCES customer (customer_id) ON DELETE NO ACTION ON UPDATE NO ACTION;
CREATE INDEX invoice_customer_id_idx ON invoice (customer_id);
ALTER TABLE invoice_line ADD CONSTRAINT invoice_line_invoice_id_fkey
FOREIGN KEY (invoice_id) REFERENCES invoice (invoice_id) ON DELETE NO ACTION ON UPDATE NO ACTION;
CREATE INDEX invoice_line_invoice_id_idx ON invoice_line (invoice_id);
ALTER TABLE invoice_line ADD CONSTRAINT invoice_line_track_id_fkey
FOREIGN KEY (track_id) REFERENCES track (track_id) ON DELETE NO ACTION ON UPDATE NO ACTION;
CREATE INDEX invoice_line_track_id_idx ON invoice_line (track_id);
ALTER TABLE playlist_track ADD CONSTRAINT playlist_track_playlist_id_fkey
FOREIGN KEY (playlist_id) REFERENCES playlist (playlist_id) ON DELETE NO ACTION ON UPDATE NO ACTION;
CREATE INDEX playlist_track_playlist_id_idx ON playlist_track (playlist_id);
ALTER TABLE playlist_track ADD CONSTRAINT playlist_track_track_id_fkey
FOREIGN KEY (track_id) REFERENCES track (track_id) ON DELETE NO ACTION ON UPDATE NO ACTION;
CREATE INDEX playlist_track_track_id_idx ON playlist_track (track_id);
ALTER TABLE track ADD CONSTRAINT track_album_id_fkey
FOREIGN KEY (album_id) REFERENCES album (album_id) ON DELETE NO ACTION ON UPDATE NO ACTION;
CREATE INDEX track_album_id_idx ON track (album_id);
ALTER TABLE track ADD CONSTRAINT track_genre_id_fkey
FOREIGN KEY (genre_id) REFERENCES genre (genre_id) ON DELETE NO ACTION ON UPDATE NO ACTION;
CREATE INDEX track_genre_id_idx ON track (genre_id);
ALTER TABLE track ADD CONSTRAINT track_media_type_id_fkey
FOREIGN KEY (media_type_id) REFERENCES media_type (media_type_id) ON DELETE NO ACTION ON UPDATE NO ACTION;
CREATE INDEX track_media_type_id_idx ON track (media_type_id);
/*******************************************************************************
Populate Tables
********************************************************************************/
INSERT INTO genre (genre_id, name) VALUES
(1, N'Rock'),
(2, N'Jazz'),
(3, N'Metal'),
(4, N'Alternative & Punk'),
(5, N'Rock And Roll'),
(6, N'Blues'),
(7, N'Latin'),
(8, N'Reggae'),
(9, N'Pop'),
(10, N'Soundtrack'),
(11, N'Bossa Nova'),
(12, N'Easy Listening'),
(13, N'Heavy Metal'),
(14, N'R&B/Soul'),
(15, N'Electronica/Dance'),
(16, N'World'),
(17, N'Hip Hop/Rap'),
(18, N'Science Fiction'),
(19, N'TV Shows'),
(20, N'Sci Fi & Fantasy'),
(21, N'Drama'),
(22, N'Comedy'),
(23, N'Alternative'),
(24, N'Classical'),
(25, N'Opera');
INSERT INTO media_type (media_type_id, name) VALUES
(1, N'MPEG audio file'),
(2, N'Protected AAC audio file'),
(3, N'Protected MPEG-4 video file'),
(4, N'Purchased AAC audio file'),
(5, N'AAC audio file');
INSERT INTO artist (artist_id, name) VALUES
(1, N'AC/DC'),
(2, N'Accept'),
(3, N'Aerosmith'),
(4, N'Alanis Morissette'),
(5, N'Alice In Chains'),
(6, N'Antônio Carlos Jobim'),
(7, N'Apocalyptica'),
(8, N'Audioslave'),
(9, N'BackBeat'),
(10, N'Billy Cobham'),
(11, N'Black Label Society'),
(12, N'Black Sabbath'),
(13, N'Body Count'),
(14, N'Bruce Dickinson'),
(15, N'Buddy Guy'),
(16, N'Caetano Veloso'),
(17, N'Chico Buarque'),
(18, N'Chico Science & Nação Zumbi'),
(19, N'Cidade Negra'),
(20, N'Cláudio Zoli'),
(21, N'Various Artists'),
(22, N'Led Zeppelin'),
(23, N'Frank Zappa & Captain Beefheart'),
(24, N'Marcos Valle'),
(25, N'Milton Nascimento & Bebeto'),
(26, N'Azymuth'),
(27, N'Gilberto Gil'),
(28, N'João Gilberto'),
(29, N'Bebel Gilberto'),
(30, N'Jorge Vercilo'),
(31, N'Baby Consuelo'),
(32, N'Ney Matogrosso'),
(33, N'Luiz Melodia'),
(34, N'Nando Reis'),
(35, N'Pedro Luís & A Parede'),
(36, N'O Rappa'),
(37, N'Ed Motta'),
(38, N'Banda Black Rio'),
(39, N'Fernanda Porto'),
(40, N'Os Cariocas'),
(41, N'Elis Regina'),
(42, N'Milton Nascimento'),
(43, N'A Cor Do Som'),
(44, N'Kid Abelha'),
(45, N'Sandra De Sá'),
(46, N'Jorge Ben'),
(47, N'Hermeto Pascoal'),
(48, N'Barão Vermelho'),
(49, N'Edson, DJ Marky & DJ Patife Featuring Fernanda Porto'),
(50, N'Metallica'),
(51, N'Queen'),
(52, N'Kiss'),
(53, N'Spyro Gyra'),
(54, N'Green Day'),
(55, N'David Coverdale'),
(56, N'Gonzaguinha'),
(57, N'Os Mutantes'),
(58, N'Deep Purple'),
(59, N'Santana'),
(60, N'Santana Feat. Dave Matthews'),
(61, N'Santana Feat. Everlast'),
(62, N'Santana Feat. Rob Thomas'),
(63, N'Santana Feat. Lauryn Hill & Cee-Lo'),
(64, N'Santana Feat. The Project G&B'),
(65, N'Santana Feat. Maná'),
(66, N'Santana Feat. Eagle-Eye Cherry'),
(67, N'Santana Feat. Eric Clapton'),
(68, N'Miles Davis'),
(69, N'Gene Krupa'),
(70, N'Toquinho & Vinícius'),
(71, N'Vinícius De Moraes & Baden Powell'),
(72, N'Vinícius De Moraes'),
(73, N'Vinícius E Qurteto Em Cy'),
(74, N'Vinícius E Odette Lara'),
(75, N'Vinicius, Toquinho & Quarteto Em Cy'),
(76, N'Creedence Clearwater Revival'),
(77, N'Cássia Eller'),
(78, N'Def Leppard'),
(79, N'Dennis Chambers'),
(80, N'Djavan'),
(81, N'Eric Clapton'),
(82, N'Faith No More'),
(83, N'Falamansa'),
(84, N'Foo Fighters'),
(85, N'Frank Sinatra'),
(86, N'Funk Como Le Gusta'),
(87, N'Godsmack'),
(88, N'Guns N'' Roses'),
(89, N'Incognito'),
(90, N'Iron Maiden'),
(91, N'James Brown'),
(92, N'Jamiroquai'),
(93, N'JET'),
(94, N'Jimi Hendrix'),
(95, N'Joe Satriani'),
(96, N'Jota Quest'),
(97, N'João Suplicy'),
(98, N'Judas Priest'),
(99, N'Legião Urbana'),
(100, N'Lenny Kravitz'),
(101, N'Lulu Santos'),
(102, N'Marillion'),
(103, N'Marisa Monte'),
(104, N'Marvin Gaye'),
(105, N'Men At Work'),
(106, N'Motörhead'),
(107, N'Motörhead & Girlschool'),
(108, N'Mônica Marianno'),
(109, N'Mötley Crüe'),
(110, N'Nirvana'),
(111, N'O Terço'),
(112, N'Olodum'),
(113, N'Os Paralamas Do Sucesso'),
(114, N'Ozzy Osbourne'),
(115, N'Page & Plant'),
(116, N'Passengers'),
(117, N'Paul D''Ianno'),
(118, N'Pearl Jam'),
(119, N'Peter Tosh'),
(120, N'Pink Floyd'),
(121, N'Planet Hemp'),
(122, N'R.E.M. Feat. Kate Pearson'),
(123, N'R.E.M. Feat. KRS-One'),
(124, N'R.E.M.'),
(125, N'Raimundos'),
(126, N'Raul Seixas'),
(127, N'Red Hot Chili Peppers'),
(128, N'Rush'),
(129, N'Simply Red'),
(130, N'Skank'),
(131, N'Smashing Pumpkins'),
(132, N'Soundgarden'),
(133, N'Stevie Ray Vaughan & Double Trouble'),
(134, N'Stone Temple Pilots'),
(135, N'System Of A Down'),
(136, N'Terry Bozzio, Tony Levin & Steve Stevens'),
(137, N'The Black Crowes'),
(138, N'The Clash'),
(139, N'The Cult'),
(140, N'The Doors'),
(141, N'The Police'),
(142, N'The Rolling Stones'),
(143, N'The Tea Party'),
(144, N'The Who'),
(145, N'Tim Maia'),
(146, N'Titãs'),
(147, N'Battlestar Galactica'),
(148, N'Heroes'),
(149, N'Lost'),
(150, N'U2'),
(151, N'UB40'),
(152, N'Van Halen'),
(153, N'Velvet Revolver'),
(154, N'Whitesnake'),
(155, N'Zeca Pagodinho'),
(156, N'The Office'),
(157, N'Dread Zeppelin'),
(158, N'Battlestar Galactica (Classic)'),
(159, N'Aquaman'),
(160, N'Christina Aguilera featuring BigElf'),
(161, N'Aerosmith & Sierra Leone''s Refugee Allstars'),
(162, N'Los Lonely Boys'),
(163, N'Corinne Bailey Rae'),
(164, N'Dhani Harrison & Jakob Dylan'),
(165, N'Jackson Browne'),
(166, N'Avril Lavigne'),
(167, N'Big & Rich'),
(168, N'Youssou N''Dour'),
(169, N'Black Eyed Peas'),
(170, N'Jack Johnson'),
(171, N'Ben Harper'),
(172, N'Snow Patrol'),
(173, N'Matisyahu'),
(174, N'The Postal Service'),
(175, N'Jaguares'),
(176, N'The Flaming Lips'),
(177, N'Jack''s Mannequin & Mick Fleetwood'),
(178, N'Regina Spektor'),
(179, N'Scorpions'),
(180, N'House Of Pain'),
(181, N'Xis'),
(182, N'Nega Gizza'),
(183, N'Gustavo & Andres Veiga & Salazar'),
(184, N'Rodox'),
(185, N'Charlie Brown Jr.'),
(186, N'Pedro Luís E A Parede'),
(187, N'Los Hermanos'),
(188, N'Mundo Livre S/A'),
(189, N'Otto'),
(190, N'Instituto'),
(191, N'Nação Zumbi'),
(192, N'DJ Dolores & Orchestra Santa Massa'),
(193, N'Seu Jorge'),
(194, N'Sabotage E Instituto'),
(195, N'Stereo Maracana'),
(196, N'Cake'),
(197, N'Aisha Duo'),
(198, N'Habib Koité and Bamada'),
(199, N'Karsh Kale'),
(200, N'The Posies'),
(201, N'Luciana Souza/Romero Lubambo'),
(202, N'Aaron Goldberg'),
(203, N'Nicolaus Esterhazy Sinfonia'),
(204, N'Temple of the Dog'),
(205, N'Chris Cornell'),
(206, N'Alberto Turco & Nova Schola Gregoriana'),
(207, N'Richard Marlow & The Choir of Trinity College, Cambridge'),
(208, N'English Concert & Trevor Pinnock'),
(209, N'Anne-Sophie Mutter, Herbert Von Karajan & Wiener Philharmoniker'),
(210, N'Hilary Hahn, Jeffrey Kahane, Los Angeles Chamber Orchestra & Margaret Batjer'),
(211, N'Wilhelm Kempff'),
(212, N'Yo-Yo Ma'),
(213, N'Scholars Baroque Ensemble'),
(214, N'Academy of St. Martin in the Fields & Sir Neville Marriner'),
(215, N'Academy of St. Martin in the Fields Chamber Ensemble & Sir Neville Marriner'),
(216, N'Berliner Philharmoniker, Claudio Abbado & Sabine Meyer'),
(217, N'Royal Philharmonic Orchestra & Sir Thomas Beecham'),
(218, N'Orchestre Révolutionnaire et Romantique & John Eliot Gardiner'),
(219, N'Britten Sinfonia, Ivor Bolton & Lesley Garrett'),
(220, N'Chicago Symphony Chorus, Chicago Symphony Orchestra & Sir Georg Solti'),
(221, N'Sir Georg Solti & Wiener Philharmoniker'),
(222, N'Academy of St. Martin in the Fields, John Birch, Sir Neville Marriner & Sylvia McNair'),
(223, N'London Symphony Orchestra & Sir Charles Mackerras'),
(224, N'Barry Wordsworth & BBC Concert Orchestra'),
(225, N'Herbert Von Karajan, Mirella Freni & Wiener Philharmoniker'),
(226, N'Eugene Ormandy'),
(227, N'Luciano Pavarotti'),
(228, N'Leonard Bernstein & New York Philharmonic'),
(229, N'Boston Symphony Orchestra & Seiji Ozawa'),
(230, N'Aaron Copland & London Symphony Orchestra'),
(231, N'Ton Koopman'),
(232, N'Sergei Prokofiev & Yuri Temirkanov'),
(233, N'Chicago Symphony Orchestra & Fritz Reiner'),
(234, N'Orchestra of The Age of Enlightenment'),
(235, N'Emanuel Ax, Eugene Ormandy & Philadelphia Orchestra'),
(236, N'James Levine'),
(237, N'Berliner Philharmoniker & Hans Rosbaud'),
(238, N'Maurizio Pollini'),
(239, N'Academy of St. Martin in the Fields, Sir Neville Marriner & William Bennett'),
(240, N'Gustav Mahler'),
(241, N'Felix Schmidt, London Symphony Orchestra & Rafael Frühbeck de Burgos'),
(242, N'Edo de Waart & San Francisco Symphony'),
(243, N'Antal Doráti & London Symphony Orchestra'),
(244, N'Choir Of Westminster Abbey & Simon Preston'),
(245, N'Michael Tilson Thomas & San Francisco Symphony'),
(246, N'Chor der Wiener Staatsoper, Herbert Von Karajan & Wiener Philharmoniker'),
(247, N'The King''s Singers'),
(248, N'Berliner Philharmoniker & Herbert Von Karajan'),
(249, N'Sir Georg Solti, Sumi Jo & Wiener Philharmoniker'),
(250, N'Christopher O''Riley'),
(251, N'Fretwork'),
(252, N'Amy Winehouse'),
(253, N'Calexico'),
(254, N'Otto Klemperer & Philharmonia Orchestra'),
(255, N'Yehudi Menuhin'),
(256, N'Philharmonia Orchestra & Sir Neville Marriner'),
(257, N'Academy of St. Martin in the Fields, Sir Neville Marriner & Thurston Dart'),
(258, N'Les Arts Florissants & William Christie'),
(259, N'The 12 Cellists of The Berlin Philharmonic'),
(260, N'Adrian Leaper & Doreen de Feis'),
(261, N'Roger Norrington, London Classical Players'),
(262, N'Charles Dutoit & L''Orchestre Symphonique de Montréal'),
(263, N'Equale Brass Ensemble, John Eliot Gardiner & Munich Monteverdi Orchestra and Choir'),
(264, N'Kent Nagano and Orchestre de l''Opéra de Lyon'),
(265, N'Julian Bream'),
(266, N'Martin Roscoe'),
(267, N'Göteborgs Symfoniker & Neeme Järvi'),
(268, N'Itzhak Perlman'),
(269, N'Michele Campanella'),
(270, N'Gerald Moore'),
(271, N'Mela Tenenbaum, Pro Musica Prague & Richard Kapp'),
(272, N'Emerson String Quartet'),
(273, N'C. Monteverdi, Nigel Rogers - Chiaroscuro; London Baroque; London Cornett & Sackbu'),
(274, N'Nash Ensemble'),
(275, N'Philip Glass Ensemble');
INSERT INTO album (album_id, title, artist_id) VALUES
(1, N'For Those About To Rock We Salute You', 1),
(2, N'Balls to the Wall', 2),
(3, N'Restless and Wild', 2),
(4, N'Let There Be Rock', 1),
(5, N'Big Ones', 3),
(6, N'Jagged Little Pill', 4),
(7, N'Facelift', 5),
(8, N'Warner 25 Anos', 6),
(9, N'Plays Metallica By Four Cellos', 7),
(10, N'Audioslave', 8),
(11, N'Out Of Exile', 8),
(12, N'BackBeat Soundtrack', 9),
(13, N'The Best Of Billy Cobham', 10),
(14, N'Alcohol Fueled Brewtality Live! [Disc 1]', 11),
(15, N'Alcohol Fueled Brewtality Live! [Disc 2]', 11),
(16, N'Black Sabbath', 12),
(17, N'Black Sabbath Vol. 4 (Remaster)', 12),
(18, N'Body Count', 13),
(19, N'Chemical Wedding', 14),
(20, N'The Best Of Buddy Guy - The Millenium Collection', 15),
(21, N'Prenda Minha', 16),
(22, N'Sozinho Remix Ao Vivo', 16),
(23, N'Minha Historia', 17),
(24, N'Afrociberdelia', 18),
(25, N'Da Lama Ao Caos', 18),
(26, N'Acústico MTV [Live]', 19),
(27, N'Cidade Negra - Hits', 19),
(28, N'Na Pista', 20),
(29, N'Axé Bahia 2001', 21),
(30, N'BBC Sessions [Disc 1] [Live]', 22),
(31, N'Bongo Fury', 23),
(32, N'Carnaval 2001', 21),
(33, N'Chill: Brazil (Disc 1)', 24),
(34, N'Chill: Brazil (Disc 2)', 6),
(35, N'Garage Inc. (Disc 1)', 50),
(36, N'Greatest Hits II', 51),
(37, N'Greatest Kiss', 52),
(38, N'Heart of the Night', 53),
(39, N'International Superhits', 54),
(40, N'Into The Light', 55),
(41, N'Meus Momentos', 56),
(42, N'Minha História', 57),
(43, N'MK III The Final Concerts [Disc 1]', 58),
(44, N'Physical Graffiti [Disc 1]', 22),
(45, N'Sambas De Enredo 2001', 21),
(46, N'Supernatural', 59),
(47, N'The Best of Ed Motta', 37),
(48, N'The Essential Miles Davis [Disc 1]', 68),
(49, N'The Essential Miles Davis [Disc 2]', 68),
(50, N'The Final Concerts (Disc 2)', 58),
(51, N'Up An'' Atom', 69),
(52, N'Vinícius De Moraes - Sem Limite', 70),
(53, N'Vozes do MPB', 21),
(54, N'Chronicle, Vol. 1', 76),
(55, N'Chronicle, Vol. 2', 76),
(56, N'Cássia Eller - Coleção Sem Limite [Disc 2]', 77),
(57, N'Cássia Eller - Sem Limite [Disc 1]', 77),
(58, N'Come Taste The Band', 58),
(59, N'Deep Purple In Rock', 58),
(60, N'Fireball', 58),
(61, N'Knocking at Your Back Door: The Best Of Deep Purple in the 80''s', 58),
(62, N'Machine Head', 58),
(63, N'Purpendicular', 58),
(64, N'Slaves And Masters', 58),
(65, N'Stormbringer', 58),
(66, N'The Battle Rages On', 58),
(67, N'Vault: Def Leppard''s Greatest Hits', 78),
(68, N'Outbreak', 79),
(69, N'Djavan Ao Vivo - Vol. 02', 80),
(70, N'Djavan Ao Vivo - Vol. 1', 80),
(71, N'Elis Regina-Minha História', 41),
(72, N'The Cream Of Clapton', 81),
(73, N'Unplugged', 81),
(74, N'Album Of The Year', 82),
(75, N'Angel Dust', 82),
(76, N'King For A Day Fool For A Lifetime', 82),
(77, N'The Real Thing', 82),
(78, N'Deixa Entrar', 83),
(79, N'In Your Honor [Disc 1]', 84),
(80, N'In Your Honor [Disc 2]', 84),
(81, N'One By One', 84),
(82, N'The Colour And The Shape', 84),
(83, N'My Way: The Best Of Frank Sinatra [Disc 1]', 85),
(84, N'Roda De Funk', 86),
(85, N'As Canções de Eu Tu Eles', 27),
(86, N'Quanta Gente Veio Ver (Live)', 27),
(87, N'Quanta Gente Veio ver--Bônus De Carnaval', 27),
(88, N'Faceless', 87),
(89, N'American Idiot', 54),
(90, N'Appetite for Destruction', 88),
(91, N'Use Your Illusion I', 88),
(92, N'Use Your Illusion II', 88),
(93, N'Blue Moods', 89),
(94, N'A Matter of Life and Death', 90),
(95, N'A Real Dead One', 90),
(96, N'A Real Live One', 90),
(97, N'Brave New World', 90),
(98, N'Dance Of Death', 90),
(99, N'Fear Of The Dark', 90),
(100, N'Iron Maiden', 90),
(101, N'Killers', 90),
(102, N'Live After Death', 90),
(103, N'Live At Donington 1992 (Disc 1)', 90),
(104, N'Live At Donington 1992 (Disc 2)', 90),
(105, N'No Prayer For The Dying', 90),
(106, N'Piece Of Mind', 90),
(107, N'Powerslave', 90),
(108, N'Rock In Rio [CD1]', 90),
(109, N'Rock In Rio [CD2]', 90),
(110, N'Seventh Son of a Seventh Son', 90),
(111, N'Somewhere in Time', 90),
(112, N'The Number of The Beast', 90),
(113, N'The X Factor', 90),
(114, N'Virtual XI', 90),
(115, N'Sex Machine', 91),
(116, N'Emergency On Planet Earth', 92),
(117, N'Synkronized', 92),
(118, N'The Return Of The Space Cowboy', 92),
(119, N'Get Born', 93),
(120, N'Are You Experienced?', 94),
(121, N'Surfing with the Alien (Remastered)', 95),
(122, N'Jorge Ben Jor 25 Anos', 46),
(123, N'Jota Quest-1995', 96),
(124, N'Cafezinho', 97),
(125, N'Living After Midnight', 98),
(126, N'Unplugged [Live]', 52),
(127, N'BBC Sessions [Disc 2] [Live]', 22),
(128, N'Coda', 22),
(129, N'Houses Of The Holy', 22),
(130, N'In Through The Out Door', 22),
(131, N'IV', 22),
(132, N'Led Zeppelin I', 22),
(133, N'Led Zeppelin II', 22),
(134, N'Led Zeppelin III', 22),
(135, N'Physical Graffiti [Disc 2]', 22),
(136, N'Presence', 22),
(137, N'The Song Remains The Same (Disc 1)', 22),
(138, N'The Song Remains The Same (Disc 2)', 22),
(139, N'A TempestadeTempestade Ou O Livro Dos Dias', 99),
(140, N'Mais Do Mesmo', 99),
(141, N'Greatest Hits', 100),
(142, N'Lulu Santos - RCA 100 Anos De Música - Álbum 01', 101),
(143, N'Lulu Santos - RCA 100 Anos De Música - Álbum 02', 101),
(144, N'Misplaced Childhood', 102),
(145, N'Barulhinho Bom', 103),
(146, N'Seek And Shall Find: More Of The Best (1963-1981)', 104),
(147, N'The Best Of Men At Work', 105),
(148, N'Black Album', 50),
(149, N'Garage Inc. (Disc 2)', 50),
(150, N'Kill ''Em All', 50),
(151, N'Load', 50),
(152, N'Master Of Puppets', 50),
(153, N'ReLoad', 50),
(154, N'Ride The Lightning', 50),
(155, N'St. Anger', 50),
(156, N'...And Justice For All', 50),
(157, N'Miles Ahead', 68),
(158, N'Milton Nascimento Ao Vivo', 42),
(159, N'Minas', 42),
(160, N'Ace Of Spades', 106),
(161, N'Demorou...', 108),
(162, N'Motley Crue Greatest Hits', 109),
(163, N'From The Muddy Banks Of The Wishkah [Live]', 110),
(164, N'Nevermind', 110),
(165, N'Compositores', 111),
(166, N'Olodum', 112),
(167, N'Acústico MTV', 113),
(168, N'Arquivo II', 113),
(169, N'Arquivo Os Paralamas Do Sucesso', 113),
(170, N'Bark at the Moon (Remastered)', 114),
(171, N'Blizzard of Ozz', 114),
(172, N'Diary of a Madman (Remastered)', 114),
(173, N'No More Tears (Remastered)', 114),
(174, N'Tribute', 114),
(175, N'Walking Into Clarksdale', 115),
(176, N'Original Soundtracks 1', 116),
(177, N'The Beast Live', 117),
(178, N'Live On Two Legs [Live]', 118),
(179, N'Pearl Jam', 118),
(180, N'Riot Act', 118),
(181, N'Ten', 118),
(182, N'Vs.', 118),
(183, N'Dark Side Of The Moon', 120),
(184, N'Os Cães Ladram Mas A Caravana Não Pára', 121),
(185, N'Greatest Hits I', 51),
(186, N'News Of The World', 51),
(187, N'Out Of Time', 122),
(188, N'Green', 124),
(189, N'New Adventures In Hi-Fi', 124),
(190, N'The Best Of R.E.M.: The IRS Years', 124),
(191, N'Cesta Básica', 125),
(192, N'Raul Seixas', 126),
(193, N'Blood Sugar Sex Magik', 127),
(194, N'By The Way', 127),
(195, N'Californication', 127),
(196, N'Retrospective I (1974-1980)', 128),
(197, N'Santana - As Years Go By', 59),
(198, N'Santana Live', 59),
(199, N'Maquinarama', 130),
(200, N'O Samba Poconé', 130),
(201, N'Judas 0: B-Sides and Rarities', 131),
(202, N'Rotten Apples: Greatest Hits', 131),
(203, N'A-Sides', 132),
(204, N'Morning Dance', 53),
(205, N'In Step', 133),
(206, N'Core', 134),
(207, N'Mezmerize', 135),
(208, N'[1997] Black Light Syndrome', 136),
(209, N'Live [Disc 1]', 137),
(210, N'Live [Disc 2]', 137),
(211, N'The Singles', 138),
(212, N'Beyond Good And Evil', 139),
(213, N'Pure Cult: The Best Of The Cult (For Rockers, Ravers, Lovers & Sinners) [UK]', 139),
(214, N'The Doors', 140),
(215, N'The Police Greatest Hits', 141),
(216, N'Hot Rocks, 1964-1971 (Disc 1)', 142),
(217, N'No Security', 142),
(218, N'Voodoo Lounge', 142),
(219, N'Tangents', 143),
(220, N'Transmission', 143),
(221, N'My Generation - The Very Best Of The Who', 144),
(222, N'Serie Sem Limite (Disc 1)', 145),
(223, N'Serie Sem Limite (Disc 2)', 145),
(224, N'Acústico', 146),
(225, N'Volume Dois', 146),
(226, N'Battlestar Galactica: The Story So Far', 147),
(227, N'Battlestar Galactica, Season 3', 147),
(228, N'Heroes, Season 1', 148),
(229, N'Lost, Season 3', 149),
(230, N'Lost, Season 1', 149),
(231, N'Lost, Season 2', 149),
(232, N'Achtung Baby', 150),
(233, N'All That You Can''t Leave Behind', 150),
(234, N'B-Sides 1980-1990', 150),
(235, N'How To Dismantle An Atomic Bomb', 150),
(236, N'Pop', 150),
(237, N'Rattle And Hum', 150),
(238, N'The Best Of 1980-1990', 150),
(239, N'War', 150),
(240, N'Zooropa', 150),
(241, N'UB40 The Best Of - Volume Two [UK]', 151),
(242, N'Diver Down', 152),
(243, N'The Best Of Van Halen, Vol. I', 152),
(244, N'Van Halen', 152),
(245, N'Van Halen III', 152),
(246, N'Contraband', 153),
(247, N'Vinicius De Moraes', 72),
(248, N'Ao Vivo [IMPORT]', 155),
(249, N'The Office, Season 1', 156),
(250, N'The Office, Season 2', 156),
(251, N'The Office, Season 3', 156),
(252, N'Un-Led-Ed', 157),
(253, N'Battlestar Galactica (Classic), Season 1', 158),
(254, N'Aquaman', 159),
(255, N'Instant Karma: The Amnesty International Campaign to Save Darfur', 150),
(256, N'Speak of the Devil', 114),
(257, N'20th Century Masters - The Millennium Collection: The Best of Scorpions', 179),
(258, N'House of Pain', 180),
(259, N'Radio Brasil (O Som da Jovem Vanguarda) - Seleccao de Henrique Amaro', 36),
(260, N'Cake: B-Sides and Rarities', 196),
(261, N'LOST, Season 4', 149),
(262, N'Quiet Songs', 197),
(263, N'Muso Ko', 198),
(264, N'Realize', 199),
(265, N'Every Kind of Light', 200),
(266, N'Duos II', 201),
(267, N'Worlds', 202),
(268, N'The Best of Beethoven', 203),
(269, N'Temple of the Dog', 204),
(270, N'Carry On', 205),
(271, N'Revelations', 8),
(272, N'Adorate Deum: Gregorian Chant from the Proper of the Mass', 206),
(273, N'Allegri: Miserere', 207),
(274, N'Pachelbel: Canon & Gigue', 208),
(275, N'Vivaldi: The Four Seasons', 209),
(276, N'Bach: Violin Concertos', 210),
(277, N'Bach: Goldberg Variations', 211),
(278, N'Bach: The Cello Suites', 212),
(279, N'Handel: The Messiah (Highlights)', 213),
(280, N'The World of Classical Favourites', 214),
(281, N'Sir Neville Marriner: A Celebration', 215),
(282, N'Mozart: Wind Concertos', 216),
(283, N'Haydn: Symphonies 99 - 104', 217),
(284, N'Beethoven: Symhonies Nos. 5 & 6', 218),
(285, N'A Soprano Inspired', 219),
(286, N'Great Opera Choruses', 220),
(287, N'Wagner: Favourite Overtures', 221),
(288, N'Fauré: Requiem, Ravel: Pavane & Others', 222),
(289, N'Tchaikovsky: The Nutcracker', 223),
(290, N'The Last Night of the Proms', 224),
(291, N'Puccini: Madama Butterfly - Highlights', 225),
(292, N'Holst: The Planets, Op. 32 & Vaughan Williams: Fantasies', 226),
(293, N'Pavarotti''s Opera Made Easy', 227),
(294, N'Great Performances - Barber''s Adagio and Other Romantic Favorites for Strings', 228),
(295, N'Carmina Burana', 229),
(296, N'A Copland Celebration, Vol. I', 230),
(297, N'Bach: Toccata & Fugue in D Minor', 231),
(298, N'Prokofiev: Symphony No.1', 232),
(299, N'Scheherazade', 233),
(300, N'Bach: The Brandenburg Concertos', 234),
(301, N'Chopin: Piano Concertos Nos. 1 & 2', 235),
(302, N'Mascagni: Cavalleria Rusticana', 236),
(303, N'Sibelius: Finlandia', 237),
(304, N'Beethoven Piano Sonatas: Moonlight & Pastorale', 238),
(305, N'Great Recordings of the Century - Mahler: Das Lied von der Erde', 240),
(306, N'Elgar: Cello Concerto & Vaughan Williams: Fantasias', 241),
(307, N'Adams, John: The Chairman Dances', 242),
(308, N'Tchaikovsky: 1812 Festival Overture, Op.49, Capriccio Italien & Beethoven: Wellington''s Victory', 243),
(309, N'Palestrina: Missa Papae Marcelli & Allegri: Miserere', 244),
(310, N'Prokofiev: Romeo & Juliet', 245),
(311, N'Strauss: Waltzes', 226),
(312, N'Berlioz: Symphonie Fantastique', 245),
(313, N'Bizet: Carmen Highlights', 246),
(314, N'English Renaissance', 247),
(315, N'Handel: Music for the Royal Fireworks (Original Version 1749)', 208),
(316, N'Grieg: Peer Gynt Suites & Sibelius: Pelléas et Mélisande', 248),
(317, N'Mozart Gala: Famous Arias', 249),
(318, N'SCRIABIN: Vers la flamme', 250),
(319, N'Armada: Music from the Courts of England and Spain', 251),
(320, N'Mozart: Symphonies Nos. 40 & 41', 248),
(321, N'Back to Black', 252),
(322, N'Frank', 252),
(323, N'Carried to Dust (Bonus Track Version)', 253),
(324, N'Beethoven: Symphony No. 6 ''Pastoral'' Etc.', 254),
(325, N'Bartok: Violin & Viola Concertos', 255),
(326, N'Mendelssohn: A Midsummer Night''s Dream', 256),
(327, N'Bach: Orchestral Suites Nos. 1 - 4', 257),
(328, N'Charpentier: Divertissements, Airs & Concerts', 258),
(329, N'South American Getaway', 259),
(330, N'Górecki: Symphony No. 3', 260),
(331, N'Purcell: The Fairy Queen', 261),
(332, N'The Ultimate Relexation Album', 262),
(333, N'Purcell: Music for the Queen Mary', 263),
(334, N'Weill: The Seven Deadly Sins', 264),
(335, N'J.S. Bach: Chaconne, Suite in E Minor, Partita in E Major & Prelude, Fugue and Allegro', 265),
(336, N'Prokofiev: Symphony No.5 & Stravinksy: Le Sacre Du Printemps', 248),
(337, N'Szymanowski: Piano Works, Vol. 1', 266),
(338, N'Nielsen: The Six Symphonies', 267),
(339, N'Great Recordings of the Century: Paganini''s 24 Caprices', 268),
(340, N'Liszt - 12 Études D''Execution Transcendante', 269),
(341, N'Great Recordings of the Century - Shubert: Schwanengesang, 4 Lieder', 270),
(342, N'Locatelli: Concertos for Violin, Strings and Continuo, Vol. 3', 271),
(343, N'Respighi:Pines of Rome', 226),
(344, N'Schubert: The Late String Quartets & String Quintet (3 CD''s)', 272),
(345, N'Monteverdi: L''Orfeo', 273),
(346, N'Mozart: Chamber Music', 274),
(347, N'Koyaanisqatsi (Soundtrack from the Motion Picture)', 275);
INSERT INTO track (track_id, name, album_id, media_type_id, genre_id, composer, milliseconds, bytes, unit_price) VALUES
(1, N'For Those About To Rock (We Salute You)', 1, 1, 1, N'Angus Young, Malcolm Young, Brian Johnson', 343719, 11170334, 0.99),
(2, N'Balls to the Wall', 2, 2, 1, N'U. Dirkschneider, W. Hoffmann, H. Frank, P. Baltes, S. Kaufmann, G. Hoffmann', 342562, 5510424, 0.99),
(3, N'Fast As a Shark', 3, 2, 1, N'F. Baltes, S. Kaufman, U. Dirkscneider & W. Hoffman', 230619, 3990994, 0.99),
(4, N'Restless and Wild', 3, 2, 1, N'F. Baltes, R.A. Smith-Diesel, S. Kaufman, U. Dirkscneider & W. Hoffman', 252051, 4331779, 0.99),
(5, N'Princess of the Dawn', 3, 2, 1, N'Deaffy & R.A. Smith-Diesel', 375418, 6290521, 0.99),
(6, N'Put The Finger On You', 1, 1, 1, N'Angus Young, Malcolm Young, Brian Johnson', 205662, 6713451, 0.99),
(7, N'Let''s Get It Up', 1, 1, 1, N'Angus Young, Malcolm Young, Brian Johnson', 233926, 7636561, 0.99),
(8, N'Inject The Venom', 1, 1, 1, N'Angus Young, Malcolm Young, Brian Johnson', 210834, 6852860, 0.99),
(9, N'Snowballed', 1, 1, 1, N'Angus Young, Malcolm Young, Brian Johnson', 203102, 6599424, 0.99),
(10, N'Evil Walks', 1, 1, 1, N'Angus Young, Malcolm Young, Brian Johnson', 263497, 8611245, 0.99),
(11, N'C.O.D.', 1, 1, 1, N'Angus Young, Malcolm Young, Brian Johnson', 199836, 6566314, 0.99),
(12, N'Breaking The Rules', 1, 1, 1, N'Angus Young, Malcolm Young, Brian Johnson', 263288, 8596840, 0.99),
(13, N'Night Of The Long Knives', 1, 1, 1, N'Angus Young, Malcolm Young, Brian Johnson', 205688, 6706347, 0.99),
(14, N'Spellbound', 1, 1, 1, N'Angus Young, Malcolm Young, Brian Johnson', 270863, 8817038, 0.99),
(15, N'Go Down', 4, 1, 1, N'AC/DC', 331180, 10847611, 0.99),
(16, N'Dog Eat Dog', 4, 1, 1, N'AC/DC', 215196, 7032162, 0.99),
(17, N'Let There Be Rock', 4, 1, 1, N'AC/DC', 366654, 12021261, 0.99),
(18, N'Bad Boy Boogie', 4, 1, 1, N'AC/DC', 267728, 8776140, 0.99),
(19, N'Problem Child', 4, 1, 1, N'AC/DC', 325041, 10617116, 0.99),
(20, N'Overdose', 4, 1, 1, N'AC/DC', 369319, 12066294, 0.99),
(21, N'Hell Ain''t A Bad Place To Be', 4, 1, 1, N'AC/DC', 254380, 8331286, 0.99),
(22, N'Whole Lotta Rosie', 4, 1, 1, N'AC/DC', 323761, 10547154, 0.99),
(23, N'Walk On Water', 5, 1, 1, N'Steven Tyler, Joe Perry, Jack Blades, Tommy Shaw', 295680, 9719579, 0.99),
(24, N'Love In An Elevator', 5, 1, 1, N'Steven Tyler, Joe Perry', 321828, 10552051, 0.99),
(25, N'Rag Doll', 5, 1, 1, N'Steven Tyler, Joe Perry, Jim Vallance, Holly Knight', 264698, 8675345, 0.99),
(26, N'What It Takes', 5, 1, 1, N'Steven Tyler, Joe Perry, Desmond Child', 310622, 10144730, 0.99),
(27, N'Dude (Looks Like A Lady)', 5, 1, 1, N'Steven Tyler, Joe Perry, Desmond Child', 264855, 8679940, 0.99),
(28, N'Janie''s Got A Gun', 5, 1, 1, N'Steven Tyler, Tom Hamilton', 330736, 10869391, 0.99),
(29, N'Cryin''', 5, 1, 1, N'Steven Tyler, Joe Perry, Taylor Rhodes', 309263, 10056995, 0.99),
(30, N'Amazing', 5, 1, 1, N'Steven Tyler, Richie Supa', 356519, 11616195, 0.99),
(31, N'Blind Man', 5, 1, 1, N'Steven Tyler, Joe Perry, Taylor Rhodes', 240718, 7877453, 0.99),
(32, N'Deuces Are Wild', 5, 1, 1, N'Steven Tyler, Jim Vallance', 215875, 7074167, 0.99),
(33, N'The Other Side', 5, 1, 1, N'Steven Tyler, Jim Vallance', 244375, 7983270, 0.99),
(34, N'Crazy', 5, 1, 1, N'Steven Tyler, Joe Perry, Desmond Child', 316656, 10402398, 0.99),
(35, N'Eat The Rich', 5, 1, 1, N'Steven Tyler, Joe Perry, Jim Vallance', 251036, 8262039, 0.99),
(36, N'Angel', 5, 1, 1, N'Steven Tyler, Desmond Child', 307617, 9989331, 0.99),
(37, N'Livin'' On The Edge', 5, 1, 1, N'Steven Tyler, Joe Perry, Mark Hudson', 381231, 12374569, 0.99),
(38, N'All I Really Want', 6, 1, 1, N'Alanis Morissette & Glenn Ballard', 284891, 9375567, 0.99),
(39, N'You Oughta Know', 6, 1, 1, N'Alanis Morissette & Glenn Ballard', 249234, 8196916, 0.99),
(40, N'Perfect', 6, 1, 1, N'Alanis Morissette & Glenn Ballard', 188133, 6145404, 0.99),
(41, N'Hand In My Pocket', 6, 1, 1, N'Alanis Morissette & Glenn Ballard', 221570, 7224246, 0.99),
(42, N'Right Through You', 6, 1, 1, N'Alanis Morissette & Glenn Ballard', 176117, 5793082, 0.99),
(43, N'Forgiven', 6, 1, 1, N'Alanis Morissette & Glenn Ballard', 300355, 9753256, 0.99),
(44, N'You Learn', 6, 1, 1, N'Alanis Morissette & Glenn Ballard', 239699, 7824837, 0.99),
(45, N'Head Over Feet', 6, 1, 1, N'Alanis Morissette & Glenn Ballard', 267493, 8758008, 0.99),
(46, N'Mary Jane', 6, 1, 1, N'Alanis Morissette & Glenn Ballard', 280607, 9163588, 0.99),
(47, N'Ironic', 6, 1, 1, N'Alanis Morissette & Glenn Ballard', 229825, 7598866, 0.99),
(48, N'Not The Doctor', 6, 1, 1, N'Alanis Morissette & Glenn Ballard', 227631, 7604601, 0.99),
(49, N'Wake Up', 6, 1, 1, N'Alanis Morissette & Glenn Ballard', 293485, 9703359, 0.99),
(50, N'You Oughta Know (Alternate)', 6, 1, 1, N'Alanis Morissette & Glenn Ballard', 491885, 16008629, 0.99),
(51, N'We Die Young', 7, 1, 1, N'Jerry Cantrell', 152084, 4925362, 0.99),
(52, N'Man In The Box', 7, 1, 1, N'Jerry Cantrell, Layne Staley', 286641, 9310272, 0.99),
(53, N'Sea Of Sorrow', 7, 1, 1, N'Jerry Cantrell', 349831, 11316328, 0.99),
(54, N'Bleed The Freak', 7, 1, 1, N'Jerry Cantrell', 241946, 7847716, 0.99),
(55, N'I Can''t Remember', 7, 1, 1, N'Jerry Cantrell, Layne Staley', 222955, 7302550, 0.99),
(56, N'Love, Hate, Love', 7, 1, 1, N'Jerry Cantrell, Layne Staley', 387134, 12575396, 0.99),
(57, N'It Ain''t Like That', 7, 1, 1, N'Jerry Cantrell, Michael Starr, Sean Kinney', 277577, 8993793, 0.99),
(58, N'Sunshine', 7, 1, 1, N'Jerry Cantrell', 284969, 9216057, 0.99),
(59, N'Put You Down', 7, 1, 1, N'Jerry Cantrell', 196231, 6420530, 0.99),
(60, N'Confusion', 7, 1, 1, N'Jerry Cantrell, Michael Starr, Layne Staley', 344163, 11183647, 0.99),
(61, N'I Know Somethin (Bout You)', 7, 1, 1, N'Jerry Cantrell', 261955, 8497788, 0.99),
(62, N'Real Thing', 7, 1, 1, N'Jerry Cantrell, Layne Staley', 243879, 7937731, 0.99),
(63, N'Desafinado', 8, 1, 2, NULL, 185338, 5990473, 0.99),
(64, N'Garota De Ipanema', 8, 1, 2, NULL, 285048, 9348428, 0.99),
(65, N'Samba De Uma Nota Só (One Note Samba)', 8, 1, 2, NULL, 137273, 4535401, 0.99),
(66, N'Por Causa De Você', 8, 1, 2, NULL, 169900, 5536496, 0.99),
(67, N'Ligia', 8, 1, 2, NULL, 251977, 8226934, 0.99),
(68, N'Fotografia', 8, 1, 2, NULL, 129227, 4198774, 0.99),
(69, N'Dindi (Dindi)', 8, 1, 2, NULL, 253178, 8149148, 0.99),
(70, N'Se Todos Fossem Iguais A Você (Instrumental)', 8, 1, 2, NULL, 134948, 4393377, 0.99),
(71, N'Falando De Amor', 8, 1, 2, NULL, 219663, 7121735, 0.99),
(72, N'Angela', 8, 1, 2, NULL, 169508, 5574957, 0.99),
(73, N'Corcovado (Quiet Nights Of Quiet Stars)', 8, 1, 2, NULL, 205662, 6687994, 0.99),
(74, N'Outra Vez', 8, 1, 2, NULL, 126511, 4110053, 0.99),
(75, N'O Boto (Bôto)', 8, 1, 2, NULL, 366837, 12089673, 0.99),
(76, N'Canta, Canta Mais', 8, 1, 2, NULL, 271856, 8719426, 0.99),
(77, N'Enter Sandman', 9, 1, 3, N'Apocalyptica', 221701, 7286305, 0.99),
(78, N'Master Of Puppets', 9, 1, 3, N'Apocalyptica', 436453, 14375310, 0.99),
(79, N'Harvester Of Sorrow', 9, 1, 3, N'Apocalyptica', 374543, 12372536, 0.99),
(80, N'The Unforgiven', 9, 1, 3, N'Apocalyptica', 322925, 10422447, 0.99),
(81, N'Sad But True', 9, 1, 3, N'Apocalyptica', 288208, 9405526, 0.99),
(82, N'Creeping Death', 9, 1, 3, N'Apocalyptica', 308035, 10110980, 0.99),
(83, N'Wherever I May Roam', 9, 1, 3, N'Apocalyptica', 369345, 12033110, 0.99),
(84, N'Welcome Home (Sanitarium)', 9, 1, 3, N'Apocalyptica', 350197, 11406431, 0.99),
(85, N'Cochise', 10, 1, 1, N'Audioslave/Chris Cornell', 222380, 5339931, 0.99),
(86, N'Show Me How to Live', 10, 1, 1, N'Audioslave/Chris Cornell', 277890, 6672176, 0.99),
(87, N'Gasoline', 10, 1, 1, N'Audioslave/Chris Cornell', 279457, 6709793, 0.99),
(88, N'What You Are', 10, 1, 1, N'Audioslave/Chris Cornell', 249391, 5988186, 0.99),
(89, N'Like a Stone', 10, 1, 1, N'Audioslave/Chris Cornell', 294034, 7059624, 0.99),
(90, N'Set It Off', 10, 1, 1, N'Audioslave/Chris Cornell', 263262, 6321091, 0.99),
(91, N'Shadow on the Sun', 10, 1, 1, N'Audioslave/Chris Cornell', 343457, 8245793, 0.99),
(92, N'I am the Highway', 10, 1, 1, N'Audioslave/Chris Cornell', 334942, 8041411, 0.99),
(93, N'Exploder', 10, 1, 1, N'Audioslave/Chris Cornell', 206053, 4948095, 0.99),
(94, N'Hypnotize', 10, 1, 1, N'Audioslave/Chris Cornell', 206628, 4961887, 0.99),
(95, N'Bring''em Back Alive', 10, 1, 1, N'Audioslave/Chris Cornell', 329534, 7911634, 0.99),
(96, N'Light My Way', 10, 1, 1, N'Audioslave/Chris Cornell', 303595, 7289084, 0.99),
(97, N'Getaway Car', 10, 1, 1, N'Audioslave/Chris Cornell', 299598, 7193162, 0.99),
(98, N'The Last Remaining Light', 10, 1, 1, N'Audioslave/Chris Cornell', 317492, 7622615, 0.99),
(99, N'Your Time Has Come', 11, 1, 4, N'Cornell, Commerford, Morello, Wilk', 255529, 8273592, 0.99),
(100, N'Out Of Exile', 11, 1, 4, N'Cornell, Commerford, Morello, Wilk', 291291, 9506571, 0.99),
(101, N'Be Yourself', 11, 1, 4, N'Cornell, Commerford, Morello, Wilk', 279484, 9106160, 0.99),
(102, N'Doesn''t Remind Me', 11, 1, 4, N'Cornell, Commerford, Morello, Wilk', 255869, 8357387, 0.99),
(103, N'Drown Me Slowly', 11, 1, 4, N'Cornell, Commerford, Morello, Wilk', 233691, 7609178, 0.99),
(104, N'Heaven''s Dead', 11, 1, 4, N'Cornell, Commerford, Morello, Wilk', 276688, 9006158, 0.99),
(105, N'The Worm', 11, 1, 4, N'Cornell, Commerford, Morello, Wilk', 237714, 7710800, 0.99),
(106, N'Man Or Animal', 11, 1, 4, N'Cornell, Commerford, Morello, Wilk', 233195, 7542942, 0.99),
(107, N'Yesterday To Tomorrow', 11, 1, 4, N'Cornell, Commerford, Morello, Wilk', 273763, 8944205, 0.99),
(108, N'Dandelion', 11, 1, 4, N'Cornell, Commerford, Morello, Wilk', 278125, 9003592, 0.99),
(109, N'#1 Zero', 11, 1, 4, N'Cornell, Commerford, Morello, Wilk', 299102, 9731988, 0.99),
(110, N'The Curse', 11, 1, 4, N'Cornell, Commerford, Morello, Wilk', 309786, 10029406, 0.99),
(111, N'Money', 12, 1, 5, N'Berry Gordy, Jr./Janie Bradford', 147591, 2365897, 0.99),
(112, N'Long Tall Sally', 12, 1, 5, N'Enotris Johnson/Little Richard/Robert "Bumps" Blackwell', 106396, 1707084, 0.99),
(113, N'Bad Boy', 12, 1, 5, N'Larry Williams', 116088, 1862126, 0.99),
(114, N'Twist And Shout', 12, 1, 5, N'Bert Russell/Phil Medley', 161123, 2582553, 0.99),
(115, N'Please Mr. Postman', 12, 1, 5, N'Brian Holland/Freddie Gorman/Georgia Dobbins/Robert Bateman/William Garrett', 137639, 2206986, 0.99),
(116, N'C''Mon Everybody', 12, 1, 5, N'Eddie Cochran/Jerry Capehart', 140199, 2247846, 0.99),
(117, N'Rock ''N'' Roll Music', 12, 1, 5, N'Chuck Berry', 141923, 2276788, 0.99),
(118, N'Slow Down', 12, 1, 5, N'Larry Williams', 163265, 2616981, 0.99),
(119, N'Roadrunner', 12, 1, 5, N'Bo Diddley', 143595, 2301989, 0.99),
(120, N'Carol', 12, 1, 5, N'Chuck Berry', 143830, 2306019, 0.99),
(121, N'Good Golly Miss Molly', 12, 1, 5, N'Little Richard', 106266, 1704918, 0.99),
(122, N'20 Flight Rock', 12, 1, 5, N'Ned Fairchild', 107807, 1299960, 0.99),
(123, N'Quadrant', 13, 1, 2, N'Billy Cobham', 261851, 8538199, 0.99),
(124, N'Snoopy''s search-Red baron', 13, 1, 2, N'Billy Cobham', 456071, 15075616, 0.99),
(125, N'Spanish moss-"A sound portrait"-Spanish moss', 13, 1, 2, N'Billy Cobham', 248084, 8217867, 0.99),
(126, N'Moon germs', 13, 1, 2, N'Billy Cobham', 294060, 9714812, 0.99),
(127, N'Stratus', 13, 1, 2, N'Billy Cobham', 582086, 19115680, 0.99),
(128, N'The pleasant pheasant', 13, 1, 2, N'Billy Cobham', 318066, 10630578, 0.99),
(129, N'Solo-Panhandler', 13, 1, 2, N'Billy Cobham', 246151, 8230661, 0.99),