chinook-mysql.sql

/*******************************************************************************
   Chinook Database - Version 1.4.5
   Script: Chinook_MySql.sql
   Description: Creates and populates the Chinook database.
   DB Server: MySql
   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.
********************************************************************************/

/*******************************************************************************
   Drop database if it exists
********************************************************************************/
DROP DATABASE IF EXISTS `Chinook`;


/*******************************************************************************
   Create database
********************************************************************************/
CREATE DATABASE `Chinook`;


USE `Chinook`;


/*******************************************************************************
   Create Tables
********************************************************************************/
CREATE TABLE `Album`
(
    `AlbumId` INT NOT NULL,
    `Title` NVARCHAR(160) NOT NULL,
    `ArtistId` INT NOT NULL,
    CONSTRAINT `PK_Album` PRIMARY KEY  (`AlbumId`)
);

CREATE TABLE `Artist`
(
    `ArtistId` INT NOT NULL,
    `Name` NVARCHAR(120),
    CONSTRAINT `PK_Artist` PRIMARY KEY  (`ArtistId`)
);

CREATE TABLE `Customer`
(
    `CustomerId` INT 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` INT,
    CONSTRAINT `PK_Customer` PRIMARY KEY  (`CustomerId`)
);

CREATE TABLE `Employee`
(
    `EmployeeId` INT NOT NULL,
    `LastName` NVARCHAR(20) NOT NULL,
    `FirstName` NVARCHAR(20) NOT NULL,
    `Title` NVARCHAR(30),
    `ReportsTo` INT,
    `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`)
);

CREATE TABLE `Genre`
(
    `GenreId` INT NOT NULL,
    `Name` NVARCHAR(120),
    CONSTRAINT `PK_Genre` PRIMARY KEY  (`GenreId`)
);

CREATE TABLE `Invoice`
(
    `InvoiceId` INT NOT NULL,
    `CustomerId` INT 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`)
);

CREATE TABLE `InvoiceLine`
(
    `InvoiceLineId` INT NOT NULL,
    `InvoiceId` INT NOT NULL,
    `TrackId` INT NOT NULL,
    `UnitPrice` NUMERIC(10,2) NOT NULL,
    `Quantity` INT NOT NULL,
    CONSTRAINT `PK_InvoiceLine` PRIMARY KEY  (`InvoiceLineId`)
);

CREATE TABLE `MediaType`
(
    `MediaTypeId` INT NOT NULL,
    `Name` NVARCHAR(120),
    CONSTRAINT `PK_MediaType` PRIMARY KEY  (`MediaTypeId`)
);

CREATE TABLE `Playlist`
(
    `PlaylistId` INT NOT NULL,
    `Name` NVARCHAR(120),
    CONSTRAINT `PK_Playlist` PRIMARY KEY  (`PlaylistId`)
);

CREATE TABLE `PlaylistTrack`
(
    `PlaylistId` INT NOT NULL,
    `TrackId` INT NOT NULL,
    CONSTRAINT `PK_PlaylistTrack` PRIMARY KEY  (`PlaylistId`, `TrackId`)
);

CREATE TABLE `Track`
(
    `TrackId` INT NOT NULL,
    `Name` NVARCHAR(200) NOT NULL,
    `AlbumId` INT,
    `MediaTypeId` INT NOT NULL,
    `GenreId` INT,
    `Composer` NVARCHAR(220),
    `Milliseconds` INT NOT NULL,
    `Bytes` INT,
    `UnitPrice` NUMERIC(10,2) NOT NULL,
    CONSTRAINT `PK_Track` PRIMARY KEY  (`TrackId`)
);



/*******************************************************************************
   Create Primary Key Unique Indexes
********************************************************************************/

/*******************************************************************************
   Create Foreign Keys
********************************************************************************/
ALTER TABLE `Album` ADD CONSTRAINT `FK_AlbumArtistId`
    FOREIGN KEY (`ArtistId`) REFERENCES `Artist` (`ArtistId`) ON DELETE NO ACTION ON UPDATE NO ACTION;

CREATE INDEX `IFK_AlbumArtistId` ON `Album` (`ArtistId`);

ALTER TABLE `Customer` ADD CONSTRAINT `FK_CustomerSupportRepId`
    FOREIGN KEY (`SupportRepId`) REFERENCES `Employee` (`EmployeeId`) ON DELETE NO ACTION ON UPDATE NO ACTION;

CREATE INDEX `IFK_CustomerSupportRepId` ON `Customer` (`SupportRepId`);

ALTER TABLE `Employee` ADD CONSTRAINT `FK_EmployeeReportsTo`
    FOREIGN KEY (`ReportsTo`) REFERENCES `Employee` (`EmployeeId`) ON DELETE NO ACTION ON UPDATE NO ACTION;

CREATE INDEX `IFK_EmployeeReportsTo` ON `Employee` (`ReportsTo`);

ALTER TABLE `Invoice` ADD CONSTRAINT `FK_InvoiceCustomerId`
    FOREIGN KEY (`CustomerId`) REFERENCES `Customer` (`CustomerId`) ON DELETE NO ACTION ON UPDATE NO ACTION;

CREATE INDEX `IFK_InvoiceCustomerId` ON `Invoice` (`CustomerId`);

ALTER TABLE `InvoiceLine` ADD CONSTRAINT `FK_InvoiceLineInvoiceId`
    FOREIGN KEY (`InvoiceId`) REFERENCES `Invoice` (`InvoiceId`) ON DELETE NO ACTION ON UPDATE NO ACTION;

CREATE INDEX `IFK_InvoiceLineInvoiceId` ON `InvoiceLine` (`InvoiceId`);

ALTER TABLE `InvoiceLine` ADD CONSTRAINT `FK_InvoiceLineTrackId`
    FOREIGN KEY (`TrackId`) REFERENCES `Track` (`TrackId`) ON DELETE NO ACTION ON UPDATE NO ACTION;

CREATE INDEX `IFK_InvoiceLineTrackId` ON `InvoiceLine` (`TrackId`);

ALTER TABLE `PlaylistTrack` ADD CONSTRAINT `FK_PlaylistTrackPlaylistId`
    FOREIGN KEY (`PlaylistId`) REFERENCES `Playlist` (`PlaylistId`) ON DELETE NO ACTION ON UPDATE NO ACTION;

CREATE INDEX `IFK_PlaylistTrackPlaylistId` ON `PlaylistTrack` (`PlaylistId`);

ALTER TABLE `PlaylistTrack` ADD CONSTRAINT `FK_PlaylistTrackTrackId`
    FOREIGN KEY (`TrackId`) REFERENCES `Track` (`TrackId`) ON DELETE NO ACTION ON UPDATE NO ACTION;

CREATE INDEX `IFK_PlaylistTrackTrackId` ON `PlaylistTrack` (`TrackId`);

ALTER TABLE `Track` ADD CONSTRAINT `FK_TrackAlbumId`
    FOREIGN KEY (`AlbumId`) REFERENCES `Album` (`AlbumId`) ON DELETE NO ACTION ON UPDATE NO ACTION;

CREATE INDEX `IFK_TrackAlbumId` ON `Track` (`AlbumId`);

ALTER TABLE `Track` ADD CONSTRAINT `FK_TrackGenreId`
    FOREIGN KEY (`GenreId`) REFERENCES `Genre` (`GenreId`) ON DELETE NO ACTION ON UPDATE NO ACTION;

CREATE INDEX `IFK_TrackGenreId` ON `Track` (`GenreId`);

ALTER TABLE `Track` ADD CONSTRAINT `FK_TrackMediaTypeId`
    FOREIGN KEY (`MediaTypeId`) REFERENCES `MediaType` (`MediaTypeId`) ON DELETE NO ACTION ON UPDATE NO ACTION;

CREATE INDEX `IFK_TrackMediaTypeId` ON `Track` (`MediaTypeId`);


/*******************************************************************************
   Populate Tables
********************************************************************************/

INSERT INTO `Genre` (`GenreId`, `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 `MediaType` (`MediaTypeId`, `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` (`ArtistId`, `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` (`AlbumId`, `Title`, `ArtistId`) 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