CREATE TABLE IF NOT EXISTS "album_data" ( [AlbID] INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, [AlbumTitle] NVARCHAR(160) NOT NULL, [ArtRef] INTEGER NOT NULL, FOREIGN KEY ([ArtRef]) REFERENCES "artist_data" ([ArtID]) ON DELETE NO ACTION ON UPDATE NO ACTION ); CREATE TABLE IF NOT EXISTS "artist_data" ( [ArtID] INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, [ArtistName] NVARCHAR(120) ); CREATE TABLE IF NOT EXISTS "cust_data" ( [CustID] INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, [First] NVARCHAR(40) NOT NULL, [Surname] NVARCHAR(20) NOT NULL, [Corp] NVARCHAR(80), [Addr] NVARCHAR(70), [Town] NVARCHAR(40), [Province] NVARCHAR(40), [Nation] NVARCHAR(40), [Zip] NVARCHAR(10), [Tel#] NVARCHAR(24), [TeleFax#] NVARCHAR(24), [Mail] NVARCHAR(60) NOT NULL, [SupportRef] INTEGER, FOREIGN KEY ([SupportRef]) REFERENCES "emp_data" ([EmpID]) ON DELETE NO ACTION ON UPDATE NO ACTION ); CREATE TABLE IF NOT EXISTS "emp_data" ( [EmpID] INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, [LName] NVARCHAR(20) NOT NULL, [FName] NVARCHAR(20) NOT NULL, [JobTitle] NVARCHAR(30), [ManagerID] INTEGER, [DOB] DATETIME, [DateHired] DATETIME, [Addr] NVARCHAR(70), [Town] NVARCHAR(40), [Province] NVARCHAR(40), [Nation] NVARCHAR(40), [Zip] NVARCHAR(10), [Tel#] NVARCHAR(24), [TeleFax#] NVARCHAR(24), [Mail] NVARCHAR(60), FOREIGN KEY ([ManagerID]) REFERENCES "emp_data" ([EmpID]) ON DELETE NO ACTION ON UPDATE NO ACTION ); CREATE TABLE IF NOT EXISTS "music_genre" ( [GenID] INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, [TypeName] NVARCHAR(120) ); CREATE TABLE IF NOT EXISTS "billings" ( [BillID] INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, [CustRef] INTEGER NOT NULL, [BillDate] DATETIME NOT NULL, [BillAddr] NVARCHAR(70), [BillTown] NVARCHAR(40), [BillProvince] NVARCHAR(40), [BillNation] NVARCHAR(40), [BillZip] NVARCHAR(10), [Amount$] NUMERIC(10,2) NOT NULL, FOREIGN KEY ([CustRef]) REFERENCES "cust_data" ([CustID]) ON DELETE NO ACTION ON UPDATE NO ACTION ); CREATE TABLE IF NOT EXISTS "billing_items" ( [BillItemID] INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, [BillRef] INTEGER NOT NULL, [SongRef] INTEGER NOT NULL, [PriceEach$] NUMERIC(10,2) NOT NULL, [ItemQty#] INTEGER NOT NULL, FOREIGN KEY ([BillRef]) REFERENCES "billings" ([BillID]) ON DELETE NO ACTION ON UPDATE NO ACTION, FOREIGN KEY ([SongRef]) REFERENCES "song_data" ([SongID]) ON DELETE NO ACTION ON UPDATE NO ACTION ); CREATE TABLE IF NOT EXISTS "media_category" ( [MediaTypeID] INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, [TypeName] NVARCHAR(120) ); CREATE TABLE IF NOT EXISTS "playlists" ( [ListID] INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, [ListName] NVARCHAR(120) ); CREATE TABLE IF NOT EXISTS "playlist_data" ( [ListRef] INTEGER NOT NULL, [SongRef] INTEGER NOT NULL, CONSTRAINT [PK_SongListData] PRIMARY KEY ([ListRef], [SongRef]), FOREIGN KEY ([ListRef]) REFERENCES "playlists" ([ListID]) ON DELETE NO ACTION ON UPDATE NO ACTION, FOREIGN KEY ([SongRef]) REFERENCES "song_data" ([SongID]) ON DELETE NO ACTION ON UPDATE NO ACTION ); CREATE TABLE IF NOT EXISTS "song_data" ( [SongID] INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, [SongName] NVARCHAR(200) NOT NULL, [AlbumRef] INTEGER, [MediaRef] INTEGER NOT NULL, [GenreRef] INTEGER, [SongWriter] NVARCHAR(220), [DurationMS] INTEGER NOT NULL, [FileSize] INTEGER, [PriceEach$] NUMERIC(10,2) NOT NULL, FOREIGN KEY ([AlbumRef]) REFERENCES "album_data" ([AlbID]) ON DELETE NO ACTION ON UPDATE NO ACTION, FOREIGN KEY ([GenreRef]) REFERENCES "music_genre" ([GenID]) ON DELETE NO ACTION ON UPDATE NO ACTION, FOREIGN KEY ([MediaRef]) REFERENCES "media_category" ([MediaTypeID]) ON DELETE NO ACTION ON UPDATE NO ACTION ); INSERT INTO album_data VALUES(1,'For Those About To Rock We Salute You',1); INSERT INTO album_data VALUES(2,'Balls to the Wall',2); INSERT INTO album_data VALUES(3,'Restless and Wild',2); INSERT INTO album_data VALUES(4,'Let There Be Rock',1); INSERT INTO album_data VALUES(5,'Big Ones',3); INSERT INTO album_data VALUES(6,'Jagged Little Pill',4); INSERT INTO album_data VALUES(7,'Facelift',5); INSERT INTO album_data VALUES(8,'Warner 25 Anos',6); INSERT INTO album_data VALUES(9,'Plays Metallica By Four Cellos',7); INSERT INTO album_data VALUES(10,'Audioslave',8); INSERT INTO album_data VALUES(11,'Out Of Exile',8); INSERT INTO album_data VALUES(12,'BackBeat Soundtrack',9); INSERT INTO album_data VALUES(13,'The Best Of Billy Cobham',10); INSERT INTO album_data VALUES(14,'Alcohol Fueled Brewtality Live! [Disc 1]',11); INSERT INTO album_data VALUES(15,'Alcohol Fueled Brewtality Live! [Disc 2]',11); INSERT INTO album_data VALUES(16,'Black Sabbath',12); INSERT INTO album_data VALUES(17,'Black Sabbath Vol. 4 (Remaster)',12); INSERT INTO album_data VALUES(18,'Body Count',13); INSERT INTO album_data VALUES(19,'Chemical Wedding',14); INSERT INTO album_data VALUES(20,'The Best Of Buddy Guy - The Millenium Collection',15); INSERT INTO artist_data VALUES(1,'AC/DC'); INSERT INTO artist_data VALUES(2,'Accept'); INSERT INTO artist_data VALUES(3,'Aerosmith'); INSERT INTO artist_data VALUES(4,'Alanis Morissette'); INSERT INTO artist_data VALUES(5,'Alice In Chains'); INSERT INTO artist_data VALUES(6,'Antônio Carlos Jobim'); INSERT INTO artist_data VALUES(7,'Apocalyptica'); INSERT INTO artist_data VALUES(8,'Audioslave'); INSERT INTO artist_data VALUES(9,'BackBeat'); INSERT INTO artist_data VALUES(10,'Billy Cobham'); INSERT INTO artist_data VALUES(11,'Black Label Society'); INSERT INTO artist_data VALUES(12,'Black Sabbath'); INSERT INTO artist_data VALUES(13,'Body Count'); INSERT INTO artist_data VALUES(14,'Bruce Dickinson'); INSERT INTO artist_data VALUES(15,'Buddy Guy'); INSERT INTO cust_data VALUES(1,'Luís','Gonçalves','Embraer - Empresa Brasileira de Aeronáutica S.A.','Av. Brigadeiro Faria Lima, 2170','São José dos Campos','SP','Brazil','12227-000','+55 (12) 3923-5555','+55 (12) 3923-5566','luisg@embraer.com.br',3); INSERT INTO cust_data VALUES(2,'Leonie','Köhler',NULL,'Theodor-Heuss-Straße 34','Stuttgart',NULL,'Germany','70174','+49 0711 2842222',NULL,'leonekohler@surfeu.de',5); INSERT INTO cust_data VALUES(3,'François','Tremblay',NULL,'1498 rue Bélanger','Montréal','QC','Canada','H2G 1A7','+1 (514) 721-4711',NULL,'ftremblay@gmail.com',3); INSERT INTO cust_data VALUES(4,'Bjørn','Hansen',NULL,'Ullevålsveien 14','Oslo',NULL,'Norway','0171','+47 22 44 22 22',NULL,'bjorn.hansen@yahoo.no',4); INSERT INTO cust_data VALUES(5,'František','Wichterlová','JetBrains s.r.o.','Klanova 9/506','Prague',NULL,'Czech Republic','14700','+420 2 4172 5555','+420 2 4172 5555','frantisekw@jetbrains.com',4); INSERT INTO cust_data VALUES(6,'Helena','Holý',NULL,'Rilská 3174/6','Prague',NULL,'Czech Republic','14300','+420 2 4177 0449',NULL,'hholy@gmail.com',5); INSERT INTO cust_data VALUES(7,'Astrid','Gruber',NULL,'Rotenturmstraße 4, 1010 Innere Stadt','Vienne',NULL,'Austria','1010','+43 01 5134505',NULL,'astrid.gruber@apple.at',5); INSERT INTO cust_data VALUES(8,'Daan','Peeters',NULL,'Grétrystraat 63','Brussels',NULL,'Belgium','1000','+32 02 219 03 03',NULL,'daan_peeters@apple.be',4); INSERT INTO cust_data VALUES(9,'Kara','Nielsen',NULL,'Sønder Boulevard 51','Copenhagen',NULL,'Denmark','1720','+453 3331 9991',NULL,'kara.nielsen@jubii.dk',4); INSERT INTO cust_data VALUES(10,'Eduardo','Martins','Woodstock Discos','Rua Dr. Falcão Filho, 155','São Paulo','SP','Brazil','01007-010','+55 (11) 3033-5446','+55 (11) 3033-4564','eduardo@woodstock.com.br',4); INSERT INTO cust_data VALUES(11,'Alexandre','Rocha','Banco do Brasil S.A.','Av. Paulista, 2022','São Paulo','SP','Brazil','01310-200','+55 (11) 3055-3278','+55 (11) 3055-8131','alero@uol.com.br',5); INSERT INTO cust_data VALUES(12,'Roberto','Almeida','Riotur','Praça Pio X, 119','Rio de Janeiro','RJ','Brazil','20040-020','+55 (21) 2271-7000','+55 (21) 2271-7070','roberto.almeida@riotur.gov.br',3); INSERT INTO cust_data VALUES(13,'Fernanda','Ramos',NULL,'Qe 7 Bloco G','Brasília','DF','Brazil','71020-677','+55 (61) 3363-5547','+55 (61) 3363-7855','fernadaramos4@uol.com.br',4); INSERT INTO cust_data VALUES(14,'Mark','Philips','Telus','8210 111 ST NW','Edmonton','AB','Canada','T6G 2C7','+1 (780) 434-4554','+1 (780) 434-5565','mphilips12@shaw.ca',5); INSERT INTO cust_data VALUES(15,'Jennifer','Peterson','Rogers Canada','700 W Pender Street','Vancouver','BC','Canada','V6C 1G8','+1 (604) 688-2255','+1 (604) 688-8756','jenniferp@rogers.ca',3); INSERT INTO cust_data VALUES(16,'Frank','Harris','Google Inc.','1600 Amphitheatre Parkway','Mountain View','CA','USA','94043-1351','+1 (650) 253-0000','+1 (650) 253-0000','fharris@google.com',4); INSERT INTO cust_data VALUES(17,'Jack','Smith','Microsoft Corporation','1 Microsoft Way','Redmond','WA','USA','98052-8300','+1 (425) 882-8080','+1 (425) 882-8081','jacksmith@microsoft.com',5); INSERT INTO cust_data VALUES(18,'Michelle','Brooks',NULL,'627 Broadway','New York','NY','USA','10012-2612','+1 (212) 221-3546','+1 (212) 221-4679','michelleb@aol.com',3); INSERT INTO cust_data VALUES(19,'Tim','Goyer','Apple Inc.','1 Infinite Loop','Cupertino','CA','USA','95014','+1 (408) 996-1010','+1 (408) 996-1011','tgoyer@apple.com',3); INSERT INTO cust_data VALUES(20,'Dan','Miller',NULL,'541 Del Medio Avenue','Mountain View','CA','USA','94040-111','+1 (650) 644-3358',NULL,'dmiller@comcast.com',4); INSERT INTO cust_data VALUES(21,'Kathy','Chase',NULL,'801 W 4th Street','Reno','NV','USA','89503','+1 (775) 223-7665',NULL,'kachase@hotmail.com',5); INSERT INTO cust_data VALUES(22,'Heather','Leacock',NULL,'120 S Orange Ave','Orlando','FL','USA','32801','+1 (407) 999-7788',NULL,'hleacock@gmail.com',4); INSERT INTO cust_data VALUES(23,'John','Gordon',NULL,'69 Salem Street','Boston','MA','USA','2113','+1 (617) 522-1333',NULL,'johngordon22@yahoo.com',4); INSERT INTO cust_data VALUES(24,'Frank','Ralston',NULL,'162 E Superior Street','Chicago','IL','USA','60611','+1 (312) 332-3232',NULL,'fralston@gmail.com',3); INSERT INTO cust_data VALUES(25,'Victor','Stevens',NULL,'319 N. Frances Street','Madison','WI','USA','53703','+1 (608) 257-0597',NULL,'vstevens@yahoo.com',5); INSERT INTO cust_data VALUES(26,'Richard','Cunningham',NULL,'2211 W Berry Street','Fort Worth','TX','USA','76110','+1 (817) 924-7272',NULL,'ricunningham@hotmail.com',4); INSERT INTO cust_data VALUES(27,'Patrick','Gray',NULL,'1033 N Park Ave','Tucson','AZ','USA','85719','+1 (520) 622-4200',NULL,'patrick.gray@aol.com',4); INSERT INTO cust_data VALUES(28,'Julia','Barnett',NULL,'302 S 700 E','Salt Lake City','UT','USA','84102','+1 (801) 531-7272',NULL,'jubarnett@gmail.com',5); INSERT INTO cust_data VALUES(29,'Robert','Brown',NULL,'796 Dundas Street West','Toronto','ON','Canada','M6J 1V1','+1 (416) 363-8888',NULL,'robbrown@shaw.ca',3); INSERT INTO cust_data VALUES(30,'Edward','Francis',NULL,'230 Elgin Street','Ottawa','ON','Canada','K2P 1L7','+1 (613) 234-3322',NULL,'edfrancis@yachoo.ca',3); INSERT INTO cust_data VALUES(31,'Martha','Silk',NULL,'194A Chain Lake Drive','Halifax','NS','Canada','B3S 1C5','+1 (902) 450-0450',NULL,'marthasilk@gmail.com',5); INSERT INTO cust_data VALUES(32,'Aaron','Mitchell',NULL,'696 Osborne Street','Winnipeg','MB','Canada','R3L 2B9','+1 (204) 452-6452',NULL,'aaronmitchell@yahoo.ca',4); INSERT INTO cust_data VALUES(33,'Ellie','Sullivan',NULL,'5112 48 Street','Yellowknife','NT','Canada','X1A 1N6','+1 (867) 920-2233',NULL,'ellie.sullivan@shaw.ca',3); INSERT INTO cust_data VALUES(34,'João','Fernandes',NULL,'Rua da Assunção 53','Lisbon',NULL,'Portugal',NULL,'+351 (213) 466-111',NULL,'jfernandes@yahoo.pt',4); INSERT INTO cust_data VALUES(35,'Madalena','Sampaio',NULL,'Rua dos Campeões Europeus de Viena, 4350','Porto',NULL,'Portugal',NULL,'+351 (225) 022-448',NULL,'masampaio@sapo.pt',4); INSERT INTO cust_data VALUES(36,'Hannah','Schneider',NULL,'Tauentzienstraße 8','Berlin',NULL,'Germany','10789','+49 030 26550280',NULL,'hannah.schneider@yahoo.de',5); INSERT INTO cust_data VALUES(37,'Fynn','Zimmermann',NULL,'Berger Straße 10','Frankfurt',NULL,'Germany','60316','+49 069 40598889',NULL,'fzimmermann@yahoo.de',3); INSERT INTO cust_data VALUES(38,'Niklas','Schröder',NULL,'Barbarossastraße 19','Berlin',NULL,'Germany','10779','+49 030 2141444',NULL,'nschroder@surfeu.de',3); INSERT INTO cust_data VALUES(39,'Camille','Bernard',NULL,'4, Rue Milton','Paris',NULL,'France','75009','+33 01 49 70 65 65',NULL,'camille.bernard@yahoo.fr',4); INSERT INTO cust_data VALUES(40,'Dominique','Lefebvre',NULL,'8, Rue Hanovre','Paris',NULL,'France','75002','+33 01 47 42 71 71',NULL,'dominiquelefebvre@gmail.com',4); INSERT INTO cust_data VALUES(41,'Marc','Dubois',NULL,'11, Place Bellecour','Lyon',NULL,'France','69002','+33 04 78 30 30 30',NULL,'marc.dubois@hotmail.com',5); INSERT INTO cust_data VALUES(42,'Wyatt','Girard',NULL,'9, Place Louis Barthou','Bordeaux',NULL,'France','33000','+33 05 56 96 96 96',NULL,'wyatt.girard@yahoo.fr',3); INSERT INTO cust_data VALUES(43,'Isabelle','Mercier',NULL,'68, Rue Jouvence','Dijon',NULL,'France','21000','+33 03 80 73 66 99',NULL,'isabelle_mercier@apple.fr',3); INSERT INTO cust_data VALUES(44,'Terhi','Hämäläinen',NULL,'Porthaninkatu 9','Helsinki',NULL,'Finland','00530','+358 09 870 2000',NULL,'terhi.hamalainen@apple.fi',3); INSERT INTO cust_data VALUES(45,'Ladislav','Kovács',NULL,'Erzsébet krt. 58.','Budapest',NULL,'Hungary','H-1073',NULL,NULL,'ladislav_kovacs@apple.hu',3); INSERT INTO cust_data VALUES(46,'Hugh','O''Reilly',NULL,'3 Chatham Street','Dublin','Dublin','Ireland',NULL,'+353 01 6792424',NULL,'hughoreilly@apple.ie',3); INSERT INTO cust_data VALUES(47,'Lucas','Mancini',NULL,'Via Degli Scipioni, 43','Rome','RM','Italy','00192','+39 06 39733434',NULL,'lucas.mancini@yahoo.it',5); INSERT INTO cust_data VALUES(48,'Johannes','Van der Berg',NULL,'Lijnbaansgracht 120bg','Amsterdam','VV','Netherlands','1016','+31 020 6223130',NULL,'johavanderberg@yahoo.nl',5); INSERT INTO cust_data VALUES(49,'Stanisław','Wójcik',NULL,'Ordynacka 10','Warsaw',NULL,'Poland','00-358','+48 22 828 37 39',NULL,'stanisław.wójcik@wp.pl',4); INSERT INTO cust_data VALUES(50,'Enrique','Muñoz',NULL,'C/ San Bernardo 85','Madrid',NULL,'Spain','28015','+34 914 454 454',NULL,'enrique_munoz@yahoo.es',5); INSERT INTO cust_data VALUES(51,'Joakim','Johansson',NULL,'Celsiusg. 9','Stockholm',NULL,'Sweden','11230','+46 08-651 52 52',NULL,'joakim.johansson@yahoo.se',5); INSERT INTO cust_data VALUES(52,'Emma','Jones',NULL,'202 Hoxton Street','London',NULL,'United Kingdom','N1 5LH','+44 020 7707 0707',NULL,'emma_jones@hotmail.com',3); INSERT INTO cust_data VALUES(53,'Phil','Hughes',NULL,'113 Lupus St','London',NULL,'United Kingdom','SW1V 3EN','+44 020 7976 5722',NULL,'phil.hughes@gmail.com',3); INSERT INTO cust_data VALUES(54,'Steve','Murray',NULL,'110 Raeburn Pl','Edinburgh ',NULL,'United Kingdom','EH4 1HH','+44 0131 315 3300',NULL,'steve.murray@yahoo.uk',5); INSERT INTO cust_data VALUES(55,'Mark','Taylor',NULL,'421 Bourke Street','Sidney','NSW','Australia','2010','+61 (02) 9332 3633',NULL,'mark.taylor@yahoo.au',4); INSERT INTO cust_data VALUES(56,'Diego','Gutiérrez',NULL,'307 Macacha Güemes','Buenos Aires',NULL,'Argentina','1106','+54 (0)11 4311 4333',NULL,'diego.gutierrez@yahoo.ar',4); INSERT INTO cust_data VALUES(57,'Luis','Rojas',NULL,'Calle Lira, 198','Santiago',NULL,'Chile',NULL,'+56 (0)2 635 4444',NULL,'luisrojas@yahoo.cl',5); INSERT INTO cust_data VALUES(58,'Manoj','Pareek',NULL,'12,Community Centre','Delhi',NULL,'India','110017','+91 0124 39883988',NULL,'manoj.pareek@rediff.com',3); INSERT INTO cust_data VALUES(59,'Puja','Srivastava',NULL,'3,Raj Bhavan Road','Bangalore',NULL,'India','560001','+91 080 22289999',NULL,'puja_srivastava@yahoo.in',3); INSERT INTO emp_data VALUES(1,'Adams','Andrew','General Manager',NULL,'1962-02-18 00:00:00','2002-08-14 00:00:00','11120 Jasper Ave NW','Edmonton','AB','Canada','T5K 2N1','+1 (780) 428-9482','+1 (780) 428-3457','andrew@chinookcorp.com'); INSERT INTO emp_data VALUES(2,'Edwards','Nancy','Sales Manager',1,'1958-12-08 00:00:00','2002-05-01 00:00:00','825 8 Ave SW','Calgary','AB','Canada','T2P 2T3','+1 (403) 262-3443','+1 (403) 262-3322','nancy@chinookcorp.com'); INSERT INTO emp_data VALUES(3,'Peacock','Jane','Sales Support Agent',2,'1973-08-29 00:00:00','2002-04-01 00:00:00','1111 6 Ave SW','Calgary','AB','Canada','T2P 5M5','+1 (403) 262-3443','+1 (403) 262-6712','jane@chinookcorp.com'); INSERT INTO emp_data VALUES(4,'Park','Margaret','Sales Support Agent',2,'1947-09-19 00:00:00','2003-05-03 00:00:00','683 10 Street SW','Calgary','AB','Canada','T2P 5G3','+1 (403) 263-4423','+1 (403) 263-4289','margaret@chinookcorp.com'); INSERT INTO emp_data VALUES(5,'Johnson','Steve','Sales Support Agent',2,'1965-03-03 00:00:00','2003-10-17 00:00:00','7727B 41 Ave','Calgary','AB','Canada','T3B 1Y7','1 (780) 836-9987','1 (780) 836-9543','steve@chinookcorp.com'); INSERT INTO emp_data VALUES(6,'Mitchell','Michael','IT Manager',1,'1973-07-01 00:00:00','2003-10-17 00:00:00','5827 Bowness Road NW','Calgary','AB','Canada','T3B 0C5','+1 (403) 246-9887','+1 (403) 246-9899','michael@chinookcorp.com'); INSERT INTO emp_data VALUES(7,'King','Robert','IT Staff',6,'1970-05-29 00:00:00','2004-01-02 00:00:00','590 Columbia Boulevard West','Lethbridge','AB','Canada','T1K 5N8','+1 (403) 456-9986','+1 (403) 456-8485','robert@chinookcorp.com'); INSERT INTO emp_data VALUES(8,'Callahan','Laura','IT Staff',6,'1968-01-09 00:00:00','2004-03-04 00:00:00','923 7 ST NW','Lethbridge','AB','Canada','T1H 1Y8','+1 (403) 467-3351','+1 (403) 467-8772','laura@chinookcorp.com'); INSERT INTO music_genre VALUES(1,'Rock'); INSERT INTO music_genre VALUES(2,'Jazz'); INSERT INTO music_genre VALUES(3,'Metal'); INSERT INTO music_genre VALUES(4,'Alternative & Punk'); INSERT INTO music_genre VALUES(5,'Rock And Roll'); INSERT INTO music_genre VALUES(6,'Blues'); INSERT INTO music_genre VALUES(7,'Latin'); INSERT INTO music_genre VALUES(8,'Reggae'); INSERT INTO music_genre VALUES(9,'Pop'); INSERT INTO music_genre VALUES(10,'Soundtrack'); INSERT INTO music_genre VALUES(11,'Bossa Nova'); INSERT INTO music_genre VALUES(12,'Easy Listening'); INSERT INTO music_genre VALUES(13,'Heavy Metal'); INSERT INTO music_genre VALUES(14,'R&B/Soul'); INSERT INTO music_genre VALUES(15,'Electronica/Dance'); INSERT INTO music_genre VALUES(16,'World'); INSERT INTO music_genre VALUES(17,'Hip Hop/Rap'); INSERT INTO music_genre VALUES(18,'Science Fiction'); INSERT INTO music_genre VALUES(19,'TV Shows'); INSERT INTO music_genre VALUES(20,'Sci Fi & Fantasy'); INSERT INTO music_genre VALUES(21,'Drama'); INSERT INTO music_genre VALUES(22,'Comedy'); INSERT INTO music_genre VALUES(23,'Alternative'); INSERT INTO music_genre VALUES(24,'Classical'); INSERT INTO music_genre VALUES(25,'Opera'); INSERT INTO billings VALUES(1,2,'2009-01-01 00:00:00','Theodor-Heuss-Straße 34','Stuttgart',NULL,'Germany','70174',1.9799999999999999822); INSERT INTO billings VALUES(2,4,'2009-01-02 00:00:00','Ullevålsveien 14','Oslo',NULL,'Norway','0171',3.9599999999999999644); INSERT INTO billings VALUES(3,8,'2009-01-03 00:00:00','Grétrystraat 63','Brussels',NULL,'Belgium','1000',5.9400000000000003907); INSERT INTO billings VALUES(4,14,'2009-01-06 00:00:00','8210 111 ST NW','Edmonton','AB','Canada','T6G 2C7',8.9100000000000001421); INSERT INTO billings VALUES(5,23,'2009-01-11 00:00:00','69 Salem Street','Boston','MA','USA','2113',13.859999999999999431); INSERT INTO billings VALUES(6,37,'2009-01-19 00:00:00','Berger Straße 10','Frankfurt',NULL,'Germany','60316',0.98999999999999999111); INSERT INTO billings VALUES(7,38,'2009-02-01 00:00:00','Barbarossastraße 19','Berlin',NULL,'Germany','10779',1.9799999999999999822); INSERT INTO billings VALUES(8,40,'2009-02-01 00:00:00','8, Rue Hanovre','Paris',NULL,'France','75002',1.9799999999999999822); INSERT INTO billings VALUES(9,42,'2009-02-02 00:00:00','9, Place Louis Barthou','Bordeaux',NULL,'France','33000',3.9599999999999999644); INSERT INTO billings VALUES(10,46,'2009-02-03 00:00:00','3 Chatham Street','Dublin','Dublin','Ireland',NULL,5.9400000000000003907); INSERT INTO billings VALUES(11,52,'2009-02-06 00:00:00','202 Hoxton Street','London',NULL,'United Kingdom','N1 5LH',8.9100000000000001421); INSERT INTO billings VALUES(12,2,'2009-02-11 00:00:00','Theodor-Heuss-Straße 34','Stuttgart',NULL,'Germany','70174',13.859999999999999431); INSERT INTO billings VALUES(13,16,'2009-02-19 00:00:00','1600 Amphitheatre Parkway','Mountain View','CA','USA','94043-1351',0.98999999999999999111); INSERT INTO billings VALUES(14,17,'2009-03-04 00:00:00','1 Microsoft Way','Redmond','WA','USA','98052-8300',1.9799999999999999822); INSERT INTO billings VALUES(15,19,'2009-03-04 00:00:00','1 Infinite Loop','Cupertino','CA','USA','95014',1.9799999999999999822); INSERT INTO billings VALUES(16,21,'2009-03-05 00:00:00','801 W 4th Street','Reno','NV','USA','89503',3.9599999999999999644); INSERT INTO billings VALUES(17,25,'2009-03-06 00:00:00','319 N. Frances Street','Madison','WI','USA','53703',5.9400000000000003907); INSERT INTO billings VALUES(18,31,'2009-03-09 00:00:00','194A Chain Lake Drive','Halifax','NS','Canada','B3S 1C5',8.9100000000000001421); INSERT INTO billings VALUES(19,40,'2009-03-14 00:00:00','8, Rue Hanovre','Paris',NULL,'France','75002',13.859999999999999431); INSERT INTO billings VALUES(20,54,'2009-03-22 00:00:00','110 Raeburn Pl','Edinburgh ',NULL,'United Kingdom','EH4 1HH',0.98999999999999999111); INSERT INTO billings VALUES(21,55,'2009-04-04 00:00:00','421 Bourke Street','Sidney','NSW','Australia','2010',1.9799999999999999822); INSERT INTO billings VALUES(22,57,'2009-04-04 00:00:00','Calle Lira, 198','Santiago',NULL,'Chile',NULL,1.9799999999999999822); INSERT INTO billings VALUES(23,59,'2009-04-05 00:00:00','3,Raj Bhavan Road','Bangalore',NULL,'India','560001',3.9599999999999999644); INSERT INTO billings VALUES(24,4,'2009-04-06 00:00:00','Ullevålsveien 14','Oslo',NULL,'Norway','0171',5.9400000000000003907); INSERT INTO billings VALUES(25,10,'2009-04-09 00:00:00','Rua Dr. Falcão Filho, 155','São Paulo','SP','Brazil','01007-010',8.9100000000000001421); INSERT INTO billings VALUES(26,19,'2009-04-14 00:00:00','1 Infinite Loop','Cupertino','CA','USA','95014',13.859999999999999431); INSERT INTO billings VALUES(27,33,'2009-04-22 00:00:00','5112 48 Street','Yellowknife','NT','Canada','X1A 1N6',0.98999999999999999111); INSERT INTO billings VALUES(28,34,'2009-05-05 00:00:00','Rua da Assunção 53','Lisbon',NULL,'Portugal',NULL,1.9799999999999999822); INSERT INTO billings VALUES(29,36,'2009-05-05 00:00:00','Tauentzienstraße 8','Berlin',NULL,'Germany','10789',1.9799999999999999822); INSERT INTO billings VALUES(30,38,'2009-05-06 00:00:00','Barbarossastraße 19','Berlin',NULL,'Germany','10779',3.9599999999999999644); INSERT INTO billing_items VALUES(1,1,2,0.98999999999999999111,1); INSERT INTO billing_items VALUES(2,1,4,0.98999999999999999111,1); INSERT INTO billing_items VALUES(3,2,6,0.98999999999999999111,1); INSERT INTO billing_items VALUES(4,2,8,0.98999999999999999111,1); INSERT INTO billing_items VALUES(5,2,10,0.98999999999999999111,1); INSERT INTO billing_items VALUES(6,2,12,0.98999999999999999111,1); INSERT INTO billing_items VALUES(7,3,16,0.98999999999999999111,1); INSERT INTO billing_items VALUES(8,3,20,0.98999999999999999111,1); INSERT INTO billing_items VALUES(9,3,24,0.98999999999999999111,1); INSERT INTO billing_items VALUES(10,3,28,0.98999999999999999111,1); INSERT INTO billing_items VALUES(11,3,32,0.98999999999999999111,1); INSERT INTO billing_items VALUES(12,3,36,0.98999999999999999111,1); INSERT INTO billing_items VALUES(13,4,42,0.98999999999999999111,1); INSERT INTO billing_items VALUES(14,4,48,0.98999999999999999111,1); INSERT INTO billing_items VALUES(15,4,54,0.98999999999999999111,1); INSERT INTO billing_items VALUES(16,4,60,0.98999999999999999111,1); INSERT INTO billing_items VALUES(17,4,66,0.98999999999999999111,1); INSERT INTO billing_items VALUES(18,4,72,0.98999999999999999111,1); INSERT INTO billing_items VALUES(19,4,78,0.98999999999999999111,1); INSERT INTO billing_items VALUES(20,4,84,0.98999999999999999111,1); INSERT INTO billing_items VALUES(21,4,90,0.98999999999999999111,1); INSERT INTO billing_items VALUES(22,5,99,0.98999999999999999111,1); INSERT INTO billing_items VALUES(23,5,108,0.98999999999999999111,1); INSERT INTO billing_items VALUES(24,5,117,0.98999999999999999111,1); INSERT INTO billing_items VALUES(25,5,126,0.98999999999999999111,1); INSERT INTO billing_items VALUES(26,5,135,0.98999999999999999111,1); INSERT INTO billing_items VALUES(27,5,144,0.98999999999999999111,1); INSERT INTO billing_items VALUES(28,5,153,0.98999999999999999111,1); INSERT INTO billing_items VALUES(29,5,162,0.98999999999999999111,1); INSERT INTO billing_items VALUES(30,5,171,0.98999999999999999111,1); INSERT INTO media_category VALUES(1,'MPEG audio file'); INSERT INTO media_category VALUES(2,'Protected AAC audio file'); INSERT INTO media_category VALUES(3,'Protected MPEG-4 video file'); INSERT INTO media_category VALUES(4,'Purchased AAC audio file'); INSERT INTO media_category VALUES(5,'AAC audio file'); INSERT INTO playlists VALUES(1,'Music'); INSERT INTO playlists VALUES(2,'Movies'); INSERT INTO playlists VALUES(3,'TV Shows'); INSERT INTO playlists VALUES(4,'Audiobooks'); INSERT INTO playlists VALUES(5,'90’s Music'); INSERT INTO playlists VALUES(6,'Audiobooks'); INSERT INTO playlists VALUES(7,'Movies'); INSERT INTO playlists VALUES(8,'Music'); INSERT INTO playlists VALUES(9,'Music Videos'); INSERT INTO playlists VALUES(10,'TV Shows'); INSERT INTO playlists VALUES(11,'Brazilian Music'); INSERT INTO playlists VALUES(12,'Classical'); INSERT INTO playlists VALUES(13,'Classical 101 - Deep Cuts'); INSERT INTO playlists VALUES(14,'Classical 101 - Next Steps'); INSERT INTO playlists VALUES(15,'Classical 101 - The Basics'); INSERT INTO playlists VALUES(16,'Grunge'); INSERT INTO playlists VALUES(17,'Heavy Metal Classic'); INSERT INTO playlists VALUES(18,'On-The-Go 1'); INSERT INTO playlist_data VALUES(1,99); INSERT INTO playlist_data VALUES(1,100); INSERT INTO playlist_data VALUES(1,101); INSERT INTO playlist_data VALUES(1,102); INSERT INTO playlist_data VALUES(1,103); INSERT INTO playlist_data VALUES(1,104); INSERT INTO playlist_data VALUES(1,105); INSERT INTO playlist_data VALUES(1,64); INSERT INTO playlist_data VALUES(1,65); INSERT INTO playlist_data VALUES(1,66); INSERT INTO playlist_data VALUES(1,67); INSERT INTO playlist_data VALUES(1,68); INSERT INTO playlist_data VALUES(1,69); INSERT INTO playlist_data VALUES(1,70); INSERT INTO playlist_data VALUES(1,71); INSERT INTO playlist_data VALUES(1,72); INSERT INTO playlist_data VALUES(1,78); INSERT INTO playlist_data VALUES(1,79); INSERT INTO playlist_data VALUES(1,80); INSERT INTO playlist_data VALUES(1,81); INSERT INTO playlist_data VALUES(1,82); INSERT INTO playlist_data VALUES(1,83); INSERT INTO playlist_data VALUES(1,84); INSERT INTO playlist_data VALUES(1,131); INSERT INTO playlist_data VALUES(1,132); INSERT INTO playlist_data VALUES(1,133); INSERT INTO playlist_data VALUES(1,134); INSERT INTO playlist_data VALUES(1,135); INSERT INTO playlist_data VALUES(1,136); INSERT INTO playlist_data VALUES(1,137); INSERT INTO playlist_data VALUES(1,138); INSERT INTO playlist_data VALUES(1,139); INSERT INTO playlist_data VALUES(1,9); INSERT INTO playlist_data VALUES(1,10); INSERT INTO playlist_data VALUES(1,11); INSERT INTO playlist_data VALUES(1,12); INSERT INTO playlist_data VALUES(1,13); INSERT INTO playlist_data VALUES(1,14); INSERT INTO playlist_data VALUES(1,15); INSERT INTO playlist_data VALUES(1,16); INSERT INTO playlist_data VALUES(1,17); INSERT INTO playlist_data VALUES(1,18); INSERT INTO playlist_data VALUES(1,19); INSERT INTO playlist_data VALUES(1,20); INSERT INTO playlist_data VALUES(1,88); INSERT INTO playlist_data VALUES(1,89); INSERT INTO playlist_data VALUES(1,90); INSERT INTO playlist_data VALUES(1,91); INSERT INTO playlist_data VALUES(1,92); INSERT INTO playlist_data VALUES(1,93); INSERT INTO playlist_data VALUES(1,94); INSERT INTO playlist_data VALUES(5,57); INSERT INTO playlist_data VALUES(5,58); INSERT INTO playlist_data VALUES(5,59); INSERT INTO playlist_data VALUES(5,60); INSERT INTO playlist_data VALUES(5,61); INSERT INTO playlist_data VALUES(5,62); INSERT INTO playlist_data VALUES(5,166); INSERT INTO playlist_data VALUES(5,167); INSERT INTO playlist_data VALUES(5,168); INSERT INTO playlist_data VALUES(5,169); INSERT INTO playlist_data VALUES(5,170); INSERT INTO playlist_data VALUES(5,171); INSERT INTO playlist_data VALUES(5,172); INSERT INTO playlist_data VALUES(5,173); INSERT INTO playlist_data VALUES(5,174); INSERT INTO playlist_data VALUES(5,3); INSERT INTO playlist_data VALUES(5,4); INSERT INTO playlist_data VALUES(5,5); INSERT INTO playlist_data VALUES(5,38); INSERT INTO playlist_data VALUES(5,39); INSERT INTO playlist_data VALUES(5,40); INSERT INTO playlist_data VALUES(5,41); INSERT INTO playlist_data VALUES(5,42); INSERT INTO playlist_data VALUES(5,43); INSERT INTO playlist_data VALUES(5,44); INSERT INTO playlist_data VALUES(5,45); INSERT INTO playlist_data VALUES(5,46); INSERT INTO playlist_data VALUES(5,47); INSERT INTO playlist_data VALUES(5,48); INSERT INTO playlist_data VALUES(5,49); INSERT INTO playlist_data VALUES(5,50); INSERT INTO playlist_data VALUES(5,77); INSERT INTO playlist_data VALUES(5,78); INSERT INTO playlist_data VALUES(5,79); INSERT INTO playlist_data VALUES(5,80); INSERT INTO playlist_data VALUES(5,81); INSERT INTO playlist_data VALUES(5,82); INSERT INTO playlist_data VALUES(5,83); INSERT INTO playlist_data VALUES(5,84); INSERT INTO playlist_data VALUES(5,183); INSERT INTO playlist_data VALUES(5,184); INSERT INTO playlist_data VALUES(5,185); INSERT INTO playlist_data VALUES(5,186); INSERT INTO playlist_data VALUES(5,187); INSERT INTO playlist_data VALUES(8,45); INSERT INTO playlist_data VALUES(8,46); INSERT INTO playlist_data VALUES(8,47); INSERT INTO playlist_data VALUES(8,48); INSERT INTO playlist_data VALUES(8,49); INSERT INTO playlist_data VALUES(8,50); INSERT INTO playlist_data VALUES(8,51); INSERT INTO playlist_data VALUES(8,52); INSERT INTO playlist_data VALUES(8,53); INSERT INTO playlist_data VALUES(8,54); INSERT INTO playlist_data VALUES(8,55); INSERT INTO playlist_data VALUES(8,56); INSERT INTO playlist_data VALUES(8,57); INSERT INTO playlist_data VALUES(8,58); INSERT INTO playlist_data VALUES(8,59); INSERT INTO playlist_data VALUES(8,60); INSERT INTO playlist_data VALUES(8,61); INSERT INTO playlist_data VALUES(8,62); INSERT INTO playlist_data VALUES(8,64); INSERT INTO playlist_data VALUES(8,65); INSERT INTO playlist_data VALUES(8,66); INSERT INTO playlist_data VALUES(8,67); INSERT INTO playlist_data VALUES(8,68); INSERT INTO playlist_data VALUES(8,69); INSERT INTO playlist_data VALUES(8,70); INSERT INTO playlist_data VALUES(8,71); INSERT INTO playlist_data VALUES(8,96); INSERT INTO playlist_data VALUES(8,97); INSERT INTO playlist_data VALUES(8,98); INSERT INTO playlist_data VALUES(8,99); INSERT INTO playlist_data VALUES(8,100); INSERT INTO playlist_data VALUES(8,101); INSERT INTO playlist_data VALUES(8,113); INSERT INTO playlist_data VALUES(16,52); INSERT INTO playlist_data VALUES(17,1); INSERT INTO playlist_data VALUES(17,2); INSERT INTO playlist_data VALUES(17,3); INSERT INTO playlist_data VALUES(17,4); INSERT INTO playlist_data VALUES(17,5); INSERT INTO playlist_data VALUES(17,152); INSERT INTO playlist_data VALUES(17,160); INSERT INTO playlist_data VALUES(18,597); INSERT INTO song_data VALUES(1,'For Those About To Rock (We Salute You)',1,1,1,'Angus Young, Malcolm Young, Brian Johnson',343719,11170334,0.98999999999999999111); INSERT INTO song_data VALUES(2,'Balls to the Wall',2,2,1,NULL,342562,5510424,0.98999999999999999111); INSERT INTO song_data VALUES(3,'Fast As a Shark',3,2,1,'F. Baltes, S. Kaufman, U. Dirkscneider & W. Hoffman',230619,3990994,0.98999999999999999111); INSERT INTO song_data VALUES(4,'Restless and Wild',3,2,1,'F. Baltes, R.A. Smith-Diesel, S. Kaufman, U. Dirkscneider & W. Hoffman',252051,4331779,0.98999999999999999111); INSERT INTO song_data VALUES(5,'Princess of the Dawn',3,2,1,'Deaffy & R.A. Smith-Diesel',375418,6290521,0.98999999999999999111); INSERT INTO song_data VALUES(6,'Put The Finger On You',1,1,1,'Angus Young, Malcolm Young, Brian Johnson',205662,6713451,0.98999999999999999111); INSERT INTO song_data VALUES(7,'Let''s Get It Up',1,1,1,'Angus Young, Malcolm Young, Brian Johnson',233926,7636561,0.98999999999999999111); INSERT INTO song_data VALUES(8,'Inject The Venom',1,1,1,'Angus Young, Malcolm Young, Brian Johnson',210834,6852860,0.98999999999999999111); INSERT INTO song_data VALUES(9,'Snowballed',1,1,1,'Angus Young, Malcolm Young, Brian Johnson',203102,6599424,0.98999999999999999111); INSERT INTO song_data VALUES(10,'Evil Walks',1,1,1,'Angus Young, Malcolm Young, Brian Johnson',263497,8611245,0.98999999999999999111); INSERT INTO song_data VALUES(11,'C.O.D.',1,1,1,'Angus Young, Malcolm Young, Brian Johnson',199836,6566314,0.98999999999999999111); INSERT INTO song_data VALUES(12,'Breaking The Rules',1,1,1,'Angus Young, Malcolm Young, Brian Johnson',263288,8596840,0.98999999999999999111); INSERT INTO song_data VALUES(13,'Night Of The Long Knives',1,1,1,'Angus Young, Malcolm Young, Brian Johnson',205688,6706347,0.98999999999999999111); INSERT INTO song_data VALUES(14,'Spellbound',1,1,1,'Angus Young, Malcolm Young, Brian Johnson',270863,8817038,0.98999999999999999111); INSERT INTO song_data VALUES(15,'Go Down',4,1,1,'AC/DC',331180,10847611,0.98999999999999999111); INSERT INTO song_data VALUES(16,'Dog Eat Dog',4,1,1,'AC/DC',215196,7032162,0.98999999999999999111); INSERT INTO song_data VALUES(17,'Let There Be Rock',4,1,1,'AC/DC',366654,12021261,0.98999999999999999111); INSERT INTO song_data VALUES(18,'Bad Boy Boogie',4,1,1,'AC/DC',267728,8776140,0.98999999999999999111); INSERT INTO song_data VALUES(19,'Problem Child',4,1,1,'AC/DC',325041,10617116,0.98999999999999999111); INSERT INTO song_data VALUES(20,'Overdose',4,1,1,'AC/DC',369319,12066294,0.98999999999999999111); INSERT INTO song_data VALUES(21,'Hell Ain''t A Bad Place To Be',4,1,1,'AC/DC',254380,8331286,0.98999999999999999111); INSERT INTO song_data VALUES(22,'Whole Lotta Rosie',4,1,1,'AC/DC',323761,10547154,0.98999999999999999111); INSERT INTO song_data VALUES(23,'Walk On Water',5,1,1,'Steven Tyler, Joe Perry, Jack Blades, Tommy Shaw',295680,9719579,0.98999999999999999111); INSERT INTO song_data VALUES(24,'Love In An Elevator',5,1,1,'Steven Tyler, Joe Perry',321828,10552051,0.98999999999999999111); INSERT INTO song_data VALUES(25,'Rag Doll',5,1,1,'Steven Tyler, Joe Perry, Jim Vallance, Holly Knight',264698,8675345,0.98999999999999999111); INSERT INTO song_data VALUES(26,'What It Takes',5,1,1,'Steven Tyler, Joe Perry, Desmond Child',310622,10144730,0.98999999999999999111); INSERT INTO song_data VALUES(27,'Dude (Looks Like A Lady)',5,1,1,'Steven Tyler, Joe Perry, Desmond Child',264855,8679940,0.98999999999999999111); INSERT INTO song_data VALUES(28,'Janie''s Got A Gun',5,1,1,'Steven Tyler, Tom Hamilton',330736,10869391,0.98999999999999999111); INSERT INTO song_data VALUES(29,'Cryin''',5,1,1,'Steven Tyler, Joe Perry, Taylor Rhodes',309263,10056995,0.98999999999999999111); INSERT INTO song_data VALUES(30,'Amazing',5,1,1,'Steven Tyler, Richie Supa',356519,11616195,0.98999999999999999111); INSERT INTO song_data VALUES(31,'Blind Man',5,1,1,'Steven Tyler, Joe Perry, Taylor Rhodes',240718,7877453,0.98999999999999999111); INSERT INTO song_data VALUES(32,'Deuces Are Wild',5,1,1,'Steven Tyler, Jim Vallance',215875,7074167,0.98999999999999999111); INSERT INTO song_data VALUES(33,'The Other Side',5,1,1,'Steven Tyler, Jim Vallance',244375,7983270,0.98999999999999999111); INSERT INTO song_data VALUES(34,'Crazy',5,1,1,'Steven Tyler, Joe Perry, Desmond Child',316656,10402398,0.98999999999999999111); INSERT INTO song_data VALUES(35,'Eat The Rich',5,1,1,'Steven Tyler, Joe Perry, Jim Vallance',251036,8262039,0.98999999999999999111); INSERT INTO song_data VALUES(36,'Angel',5,1,1,'Steven Tyler, Desmond Child',307617,9989331,0.98999999999999999111); INSERT INTO song_data VALUES(37,'Livin'' On The Edge',5,1,1,'Steven Tyler, Joe Perry, Mark Hudson',381231,12374569,0.98999999999999999111); INSERT INTO song_data VALUES(38,'All I Really Want',6,1,1,'Alanis Morissette & Glenn Ballard',284891,9375567,0.98999999999999999111); INSERT INTO song_data VALUES(39,'You Oughta Know',6,1,1,'Alanis Morissette & Glenn Ballard',249234,8196916,0.98999999999999999111); INSERT INTO song_data VALUES(40,'Perfect',6,1,1,'Alanis Morissette & Glenn Ballard',188133,6145404,0.98999999999999999111); INSERT INTO song_data VALUES(41,'Hand In My Pocket',6,1,1,'Alanis Morissette & Glenn Ballard',221570,7224246,0.98999999999999999111); INSERT INTO song_data VALUES(42,'Right Through You',6,1,1,'Alanis Morissette & Glenn Ballard',176117,5793082,0.98999999999999999111); INSERT INTO song_data VALUES(43,'Forgiven',6,1,1,'Alanis Morissette & Glenn Ballard',300355,9753256,0.98999999999999999111); INSERT INTO song_data VALUES(44,'You Learn',6,1,1,'Alanis Morissette & Glenn Ballard',239699,7824837,0.98999999999999999111); INSERT INTO song_data VALUES(45,'Head Over Feet',6,1,1,'Alanis Morissette & Glenn Ballard',267493,8758008,0.98999999999999999111); INSERT INTO song_data VALUES(46,'Mary Jane',6,1,1,'Alanis Morissette & Glenn Ballard',280607,9163588,0.98999999999999999111); INSERT INTO song_data VALUES(47,'Ironic',6,1,1,'Alanis Morissette & Glenn Ballard',229825,7598866,0.98999999999999999111); INSERT INTO song_data VALUES(48,'Not The Doctor',6,1,1,'Alanis Morissette & Glenn Ballard',227631,7604601,0.98999999999999999111); INSERT INTO song_data VALUES(49,'Wake Up',6,1,1,'Alanis Morissette & Glenn Ballard',293485,9703359,0.98999999999999999111); INSERT INTO song_data VALUES(50,'You Oughta Know (Alternate)',6,1,1,'Alanis Morissette & Glenn Ballard',491885,16008629,0.98999999999999999111); INSERT INTO song_data VALUES(51,'We Die Young',7,1,1,'Jerry Cantrell',152084,4925362,0.98999999999999999111); INSERT INTO song_data VALUES(52,'Man In The Box',7,1,1,'Jerry Cantrell, Layne Staley',286641,9310272,0.98999999999999999111); INSERT INTO song_data VALUES(53,'Sea Of Sorrow',7,1,1,'Jerry Cantrell',349831,11316328,0.98999999999999999111); INSERT INTO song_data VALUES(54,'Bleed The Freak',7,1,1,'Jerry Cantrell',241946,7847716,0.98999999999999999111); INSERT INTO song_data VALUES(55,'I Can''t Remember',7,1,1,'Jerry Cantrell, Layne Staley',222955,7302550,0.98999999999999999111); INSERT INTO song_data VALUES(56,'Love, Hate, Love',7,1,1,'Jerry Cantrell, Layne Staley',387134,12575396,0.98999999999999999111); INSERT INTO song_data VALUES(57,'It Ain''t Like That',7,1,1,'Jerry Cantrell, Michael Starr, Sean Kinney',277577,8993793,0.98999999999999999111); INSERT INTO song_data VALUES(58,'Sunshine',7,1,1,'Jerry Cantrell',284969,9216057,0.98999999999999999111); INSERT INTO song_data VALUES(59,'Put You Down',7,1,1,'Jerry Cantrell',196231,6420530,0.98999999999999999111); INSERT INTO song_data VALUES(60,'Confusion',7,1,1,'Jerry Cantrell, Michael Starr, Layne Staley',344163,11183647,0.98999999999999999111); INSERT INTO song_data VALUES(61,'I Know Somethin (Bout You)',7,1,1,'Jerry Cantrell',261955,8497788,0.98999999999999999111); INSERT INTO song_data VALUES(62,'Real Thing',7,1,1,'Jerry Cantrell, Layne Staley',243879,7937731,0.98999999999999999111); INSERT INTO song_data VALUES(63,'Desafinado',8,1,2,NULL,185338,5990473,0.98999999999999999111); INSERT INTO song_data VALUES(64,'Garota De Ipanema',8,1,2,NULL,285048,9348428,0.98999999999999999111); INSERT INTO song_data VALUES(65,'Samba De Uma Nota Só (One Note Samba)',8,1,2,NULL,137273,4535401,0.98999999999999999111); INSERT INTO song_data VALUES(66,'Por Causa De Você',8,1,2,NULL,169900,5536496,0.98999999999999999111); INSERT INTO song_data VALUES(67,'Ligia',8,1,2,NULL,251977,8226934,0.98999999999999999111); INSERT INTO song_data VALUES(68,'Fotografia',8,1,2,NULL,129227,4198774,0.98999999999999999111); INSERT INTO song_data VALUES(69,'Dindi (Dindi)',8,1,2,NULL,253178,8149148,0.98999999999999999111); INSERT INTO song_data VALUES(70,'Se Todos Fossem Iguais A Você (Instrumental)',8,1,2,NULL,134948,4393377,0.98999999999999999111); INSERT INTO song_data VALUES(71,'Falando De Amor',8,1,2,NULL,219663,7121735,0.98999999999999999111); INSERT INTO song_data VALUES(72,'Angela',8,1,2,NULL,169508,5574957,0.98999999999999999111); INSERT INTO song_data VALUES(73,'Corcovado (Quiet Nights Of Quiet Stars)',8,1,2,NULL,205662,6687994,0.98999999999999999111); INSERT INTO song_data VALUES(74,'Outra Vez',8,1,2,NULL,126511,4110053,0.98999999999999999111); INSERT INTO song_data VALUES(75,'O Boto (Bôto)',8,1,2,NULL,366837,12089673,0.98999999999999999111); INSERT INTO song_data VALUES(76,'Canta, Canta Mais',8,1,2,NULL,271856,8719426,0.98999999999999999111); INSERT INTO song_data VALUES(77,'Enter Sandman',9,1,3,'Apocalyptica',221701,7286305,0.98999999999999999111); INSERT INTO song_data VALUES(78,'Master Of Puppets',9,1,3,'Apocalyptica',436453,14375310,0.98999999999999999111); INSERT INTO song_data VALUES(79,'Harvester Of Sorrow',9,1,3,'Apocalyptica',374543,12372536,0.98999999999999999111); INSERT INTO song_data VALUES(80,'The Unforgiven',9,1,3,'Apocalyptica',322925,10422447,0.98999999999999999111); INSERT INTO song_data VALUES(81,'Sad But True',9,1,3,'Apocalyptica',288208,9405526,0.98999999999999999111); INSERT INTO song_data VALUES(82,'Creeping Death',9,1,3,'Apocalyptica',308035,10110980,0.98999999999999999111); INSERT INTO song_data VALUES(83,'Wherever I May Roam',9,1,3,'Apocalyptica',369345,12033110,0.98999999999999999111); INSERT INTO song_data VALUES(84,'Welcome Home (Sanitarium)',9,1,3,'Apocalyptica',350197,11406431,0.98999999999999999111); INSERT INTO song_data VALUES(85,'Cochise',10,1,1,'Audioslave/Chris Cornell',222380,5339931,0.98999999999999999111); INSERT INTO song_data VALUES(86,'Show Me How to Live',10,1,1,'Audioslave/Chris Cornell',277890,6672176,0.98999999999999999111); INSERT INTO song_data VALUES(87,'Gasoline',10,1,1,'Audioslave/Chris Cornell',279457,6709793,0.98999999999999999111); INSERT INTO song_data VALUES(88,'What You Are',10,1,1,'Audioslave/Chris Cornell',249391,5988186,0.98999999999999999111); INSERT INTO song_data VALUES(89,'Like a Stone',10,1,1,'Audioslave/Chris Cornell',294034,7059624,0.98999999999999999111); INSERT INTO song_data VALUES(90,'Set It Off',10,1,1,'Audioslave/Chris Cornell',263262,6321091,0.98999999999999999111); INSERT INTO song_data VALUES(91,'Shadow on the Sun',10,1,1,'Audioslave/Chris Cornell',343457,8245793,0.98999999999999999111); INSERT INTO song_data VALUES(92,'I am the Highway',10,1,1,'Audioslave/Chris Cornell',334942,8041411,0.98999999999999999111); INSERT INTO song_data VALUES(93,'Exploder',10,1,1,'Audioslave/Chris Cornell',206053,4948095,0.98999999999999999111); INSERT INTO song_data VALUES(94,'Hypnotize',10,1,1,'Audioslave/Chris Cornell',206628,4961887,0.98999999999999999111); INSERT INTO song_data VALUES(95,'Bring''em Back Alive',10,1,1,'Audioslave/Chris Cornell',329534,7911634,0.98999999999999999111); INSERT INTO song_data VALUES(96,'Light My Way',10,1,1,'Audioslave/Chris Cornell',303595,7289084,0.98999999999999999111); INSERT INTO song_data VALUES(97,'Getaway Car',10,1,1,'Audioslave/Chris Cornell',299598,7193162,0.98999999999999999111); INSERT INTO song_data VALUES(98,'The Last Remaining Light',10,1,1,'Audioslave/Chris Cornell',317492,7622615,0.98999999999999999111); INSERT INTO song_data VALUES(99,'Your Time Has Come',11,1,4,'Cornell, Commerford, Morello, Wilk',255529,8273592,0.98999999999999999111); INSERT INTO song_data VALUES(100,'Out Of Exile',11,1,4,'Cornell, Commerford, Morello, Wilk',291291,9506571,0.98999999999999999111); INSERT INTO song_data VALUES(101,'Be Yourself',11,1,4,'Cornell, Commerford, Morello, Wilk',279484,9106160,0.98999999999999999111); INSERT INTO song_data VALUES(102,'Doesn''t Remind Me',11,1,4,'Cornell, Commerford, Morello, Wilk',255869,8357387,0.98999999999999999111); INSERT INTO song_data VALUES(103,'Drown Me Slowly',11,1,4,'Cornell, Commerford, Morello, Wilk',233691,7609178,0.98999999999999999111); INSERT INTO song_data VALUES(104,'Heaven''s Dead',11,1,4,'Cornell, Commerford, Morello, Wilk',276688,9006158,0.98999999999999999111); INSERT INTO song_data VALUES(105,'The Worm',11,1,4,'Cornell, Commerford, Morello, Wilk',237714,7710800,0.98999999999999999111); INSERT INTO song_data VALUES(106,'Man Or Animal',11,1,4,'Cornell, Commerford, Morello, Wilk',233195,7542942,0.98999999999999999111); INSERT INTO song_data VALUES(107,'Yesterday To Tomorrow',11,1,4,'Cornell, Commerford, Morello, Wilk',273763,8944205,0.98999999999999999111); INSERT INTO song_data VALUES(108,'Dandelion',11,1,4,'Cornell, Commerford, Morello, Wilk',278125,9003592,0.98999999999999999111); INSERT INTO song_data VALUES(109,'#1 Zero',11,1,4,'Cornell, Commerford, Morello, Wilk',299102,9731988,0.98999999999999999111); INSERT INTO song_data VALUES(110,'The Curse',11,1,4,'Cornell, Commerford, Morello, Wilk',309786,10029406,0.98999999999999999111); INSERT INTO song_data VALUES(111,'Money',12,1,5,'Berry Gordy, Jr./Janie Bradford',147591,2365897,0.98999999999999999111); INSERT INTO song_data VALUES(112,'Long Tall Sally',12,1,5,'Enotris Johnson/Little Richard/Robert "Bumps" Blackwell',106396,1707084,0.98999999999999999111); INSERT INTO song_data VALUES(113,'Bad Boy',12,1,5,'Larry Williams',116088,1862126,0.98999999999999999111); INSERT INTO song_data VALUES(114,'Twist And Shout',12,1,5,'Bert Russell/Phil Medley',161123,2582553,0.98999999999999999111); INSERT INTO song_data VALUES(115,'Please Mr. Postman',12,1,5,'Brian Holland/Freddie Gorman/Georgia Dobbins/Robert Bateman/William Garrett',137639,2206986,0.98999999999999999111); INSERT INTO song_data VALUES(116,'C''Mon Everybody',12,1,5,'Eddie Cochran/Jerry Capehart',140199,2247846,0.98999999999999999111); INSERT INTO song_data VALUES(117,'Rock ''N'' Roll Music',12,1,5,'Chuck Berry',141923,2276788,0.98999999999999999111); INSERT INTO song_data VALUES(118,'Slow Down',12,1,5,'Larry Williams',163265,2616981,0.98999999999999999111); INSERT INTO song_data VALUES(119,'Roadrunner',12,1,5,'Bo Diddley',143595,2301989,0.98999999999999999111); INSERT INTO song_data VALUES(120,'Carol',12,1,5,'Chuck Berry',143830,2306019,0.98999999999999999111); INSERT INTO song_data VALUES(121,'Good Golly Miss Molly',12,1,5,'Little Richard',106266,1704918,0.98999999999999999111); INSERT INTO song_data VALUES(122,'20 Flight Rock',12,1,5,'Ned Fairchild',107807,1299960,0.98999999999999999111); INSERT INTO song_data VALUES(123,'Quadrant',13,1,2,'Billy Cobham',261851,8538199,0.98999999999999999111); INSERT INTO song_data VALUES(124,'Snoopy''s search-Red baron',13,1,2,'Billy Cobham',456071,15075616,0.98999999999999999111); INSERT INTO song_data VALUES(125,'Spanish moss-"A sound portrait"-Spanish moss',13,1,2,'Billy Cobham',248084,8217867,0.98999999999999999111); INSERT INTO song_data VALUES(126,'Moon germs',13,1,2,'Billy Cobham',294060,9714812,0.98999999999999999111); INSERT INTO song_data VALUES(127,'Stratus',13,1,2,'Billy Cobham',582086,19115680,0.98999999999999999111); INSERT INTO song_data VALUES(128,'The pleasant pheasant',13,1,2,'Billy Cobham',318066,10630578,0.98999999999999999111); INSERT INTO song_data VALUES(129,'Solo-Panhandler',13,1,2,'Billy Cobham',246151,8230661,0.98999999999999999111); INSERT INTO song_data VALUES(130,'Do what cha wanna',13,1,2,'George Duke',274155,9018565,0.98999999999999999111); INSERT INTO song_data VALUES(131,'Intro/ Low Down',14,1,3,NULL,323683,10642901,0.98999999999999999111); INSERT INTO song_data VALUES(132,'13 Years Of Grief',14,1,3,NULL,246987,8137421,0.98999999999999999111); INSERT INTO song_data VALUES(133,'Stronger Than Death',14,1,3,NULL,300747,9869647,0.98999999999999999111); INSERT INTO song_data VALUES(134,'All For You',14,1,3,NULL,235833,7726948,0.98999999999999999111); INSERT INTO song_data VALUES(135,'Super Terrorizer',14,1,3,NULL,319373,10513905,0.98999999999999999111); INSERT INTO song_data VALUES(136,'Phoney Smile Fake Hellos',14,1,3,NULL,273606,9011701,0.98999999999999999111); INSERT INTO song_data VALUES(137,'Lost My Better Half',14,1,3,NULL,284081,9355309,0.98999999999999999111); INSERT INTO song_data VALUES(138,'Bored To Tears',14,1,3,NULL,247327,8130090,0.98999999999999999111); INSERT INTO song_data VALUES(139,'A.N.D.R.O.T.A.Z.',14,1,3,NULL,266266,8574746,0.98999999999999999111); INSERT INTO song_data VALUES(140,'Born To Booze',14,1,3,NULL,282122,9257358,0.98999999999999999111); INSERT INTO song_data VALUES(141,'World Of Trouble',14,1,3,NULL,359157,11820932,0.98999999999999999111); INSERT INTO song_data VALUES(142,'No More Tears',14,1,3,NULL,555075,18041629,0.98999999999999999111); INSERT INTO song_data VALUES(143,'The Begining... At Last',14,1,3,NULL,365662,11965109,0.98999999999999999111); INSERT INTO song_data VALUES(144,'Heart Of Gold',15,1,3,NULL,194873,6417460,0.98999999999999999111); INSERT INTO song_data VALUES(145,'Snowblind',15,1,3,NULL,420022,13842549,0.98999999999999999111); INSERT INTO song_data VALUES(146,'Like A Bird',15,1,3,NULL,276532,9115657,0.98999999999999999111); INSERT INTO song_data VALUES(147,'Blood In The Wall',15,1,3,NULL,284368,9359475,0.98999999999999999111); INSERT INTO song_data VALUES(148,'The Beginning...At Last',15,1,3,NULL,271960,8975814,0.98999999999999999111); INSERT INTO song_data VALUES(149,'Black Sabbath',16,1,3,NULL,382066,12440200,0.98999999999999999111); INSERT INTO song_data VALUES(150,'The Wizard',16,1,3,NULL,264829,8646737,0.98999999999999999111); INSERT INTO song_data VALUES(151,'Behind The Wall Of Sleep',16,1,3,NULL,217573,7169049,0.98999999999999999111); INSERT INTO song_data VALUES(152,'N.I.B.',16,1,3,NULL,368770,12029390,0.98999999999999999111); INSERT INTO song_data VALUES(153,'Evil Woman',16,1,3,NULL,204930,6655170,0.98999999999999999111); INSERT INTO song_data VALUES(154,'Sleeping Village',16,1,3,NULL,644571,21128525,0.98999999999999999111); INSERT INTO song_data VALUES(155,'Warning',16,1,3,NULL,212062,6893363,0.98999999999999999111); INSERT INTO song_data VALUES(156,'Wheels Of Confusion / The Straightener',17,1,3,'Tony Iommi, Bill Ward, Geezer Butler, Ozzy Osbourne',494524,16065830,0.98999999999999999111); INSERT INTO song_data VALUES(157,'Tomorrow''s Dream',17,1,3,'Tony Iommi, Bill Ward, Geezer Butler, Ozzy Osbourne',192496,6252071,0.98999999999999999111); INSERT INTO song_data VALUES(158,'Changes',17,1,3,'Tony Iommi, Bill Ward, Geezer Butler, Ozzy Osbourne',286275,9175517,0.98999999999999999111); INSERT INTO song_data VALUES(159,'FX',17,1,3,'Tony Iommi, Bill Ward, Geezer Butler, Ozzy Osbourne',103157,3331776,0.98999999999999999111); INSERT INTO song_data VALUES(160,'Supernaut',17,1,3,'Tony Iommi, Bill Ward, Geezer Butler, Ozzy Osbourne',285779,9245971,0.98999999999999999111); INSERT INTO song_data VALUES(161,'Snowblind',17,1,3,'Tony Iommi, Bill Ward, Geezer Butler, Ozzy Osbourne',331676,10813386,0.98999999999999999111); INSERT INTO song_data VALUES(162,'Cornucopia',17,1,3,'Tony Iommi, Bill Ward, Geezer Butler, Ozzy Osbourne',234814,7653880,0.98999999999999999111); INSERT INTO song_data VALUES(163,'Laguna Sunrise',17,1,3,'Tony Iommi, Bill Ward, Geezer Butler, Ozzy Osbourne',173087,5671374,0.98999999999999999111); INSERT INTO song_data VALUES(164,'St. Vitus Dance',17,1,3,'Tony Iommi, Bill Ward, Geezer Butler, Ozzy Osbourne',149655,4884969,0.98999999999999999111); INSERT INTO song_data VALUES(165,'Under The Sun/Every Day Comes and Goes',17,1,3,'Tony Iommi, Bill Ward, Geezer Butler, Ozzy Osbourne',350458,11360486,0.98999999999999999111); INSERT INTO song_data VALUES(166,'Smoked Pork',18,1,4,NULL,47333,1549074,0.98999999999999999111); INSERT INTO song_data VALUES(167,'Body Count''s In The House',18,1,4,NULL,204251,6715413,0.98999999999999999111); INSERT INTO song_data VALUES(168,'Now Sports',18,1,4,NULL,4884,161266,0.98999999999999999111); INSERT INTO song_data VALUES(169,'Body Count',18,1,4,NULL,317936,10489139,0.98999999999999999111); INSERT INTO song_data VALUES(170,'A Statistic',18,1,4,NULL,6373,211997,0.98999999999999999111); INSERT INTO song_data VALUES(171,'Bowels Of The Devil',18,1,4,NULL,223216,7324125,0.98999999999999999111); INSERT INTO song_data VALUES(172,'The Real Problem',18,1,4,NULL,11650,387360,0.98999999999999999111); INSERT INTO song_data VALUES(173,'KKK Bitch',18,1,4,NULL,173008,5709631,0.98999999999999999111); INSERT INTO song_data VALUES(174,'D Note',18,1,4,NULL,95738,3067064,0.98999999999999999111); INSERT INTO song_data VALUES(175,'Voodoo',18,1,4,NULL,300721,9875962,0.98999999999999999111); INSERT INTO song_data VALUES(176,'The Winner Loses',18,1,4,NULL,392254,12843821,0.98999999999999999111); INSERT INTO song_data VALUES(177,'There Goes The Neighborhood',18,1,4,NULL,350171,11443471,0.98999999999999999111); INSERT INTO song_data VALUES(178,'Oprah',18,1,4,NULL,6635,224313,0.98999999999999999111); INSERT INTO song_data VALUES(179,'Evil Dick',18,1,4,NULL,239020,7828873,0.98999999999999999111); INSERT INTO song_data VALUES(180,'Body Count Anthem',18,1,4,NULL,166426,5463690,0.98999999999999999111); INSERT INTO song_data VALUES(181,'Momma''s Gotta Die Tonight',18,1,4,NULL,371539,12122946,0.98999999999999999111); INSERT INTO song_data VALUES(182,'Freedom Of Speech',18,1,4,NULL,281234,9337917,0.98999999999999999111); INSERT INTO song_data VALUES(183,'King In Crimson',19,1,3,'Roy Z',283167,9218499,0.98999999999999999111); INSERT INTO song_data VALUES(184,'Chemical Wedding',19,1,3,'Roy Z',246177,8022764,0.98999999999999999111); INSERT INTO song_data VALUES(185,'The Tower',19,1,3,'Roy Z',285257,9435693,0.98999999999999999111); INSERT INTO song_data VALUES(186,'Killing Floor',19,1,3,'Adrian Smith',269557,8854240,0.98999999999999999111); INSERT INTO song_data VALUES(187,'Book Of Thel',19,1,3,'Eddie Casillas/Roy Z',494393,16034404,0.98999999999999999111); INSERT INTO song_data VALUES(188,'Gates Of Urizen',19,1,3,'Roy Z',265351,8627004,0.98999999999999999111); INSERT INTO song_data VALUES(189,'Jerusalem',19,1,3,'Roy Z',402390,13194463,0.98999999999999999111); INSERT INTO song_data VALUES(190,'Trupets Of Jericho',19,1,3,'Roy Z',359131,11820908,0.98999999999999999111); INSERT INTO song_data VALUES(191,'Machine Men',19,1,3,'Adrian Smith',341655,11138147,0.98999999999999999111); INSERT INTO song_data VALUES(192,'The Alchemist',19,1,3,'Roy Z',509413,16545657,0.98999999999999999111); INSERT INTO song_data VALUES(193,'Realword',19,1,3,'Roy Z',237531,7802095,0.98999999999999999111); INSERT INTO song_data VALUES(194,'First Time I Met The Blues',20,1,6,'Eurreal Montgomery',140434,4604995,0.98999999999999999111); INSERT INTO song_data VALUES(195,'Let Me Love You Baby',20,1,6,'Willie Dixon',175386,5716994,0.98999999999999999111); INSERT INTO song_data VALUES(196,'Stone Crazy',20,1,6,'Buddy Guy',433397,14184984,0.98999999999999999111); INSERT INTO song_data VALUES(197,'Pretty Baby',20,1,6,'Willie Dixon',237662,7848282,0.98999999999999999111); INSERT INTO song_data VALUES(198,'When My Left Eye Jumps',20,1,6,'Al Perkins/Willie Dixon',235311,7685363,0.98999999999999999111); INSERT INTO song_data VALUES(199,'Leave My Girl Alone',20,1,6,'Buddy Guy',204721,6859518,0.98999999999999999111); INSERT INTO song_data VALUES(200,'She Suits Me To A Tee',20,1,6,'Buddy Guy',136803,4456321,0.98999999999999999111);