Reduced chinook Postgres dataset

reduced-chinook.sql

-- -- /*******************************************************************************
-- --    Chinook Database - Version 1.4
-- --    Script: Chinook_PostgreSql.sql
-- --    Description: Creates and populates the Chinook database.
-- --    DB Server: PostgreSql
-- --    Author: Luis Rocha
-- --    License: http://www.codeplex.com/ChinookDatabase/license

-- --    Modified By: John Atten
-- --    Modification Date: 3/1/2014
-- --    Summary of Changes:
-- --     - Changed integer PKs to serial (auto-incrementing) Pks
-- --     - Added Transactions table to excercie Biggie code against a bigserial type
-- --     - Imported "Actors", "Cities", "Countries" and "Films" tables from pg dvdrentals Db to excercise 
-- --       Biggie code against Full-Text Search table. 
-- -- ********************************************************************************/


-- ----------------------------
-- Sequence structure for album_album_id_seq
-- ----------------------------
CREATE SEQUENCE "albums_id_seq"
 INCREMENT 1
 MINVALUE 1
 MAXVALUE 2147483647
 START 347
 CACHE 1;
SELECT setval('"public"."albums_id_seq"', 347, true);


-- ----------------------------
-- Sequence structure for artist_artist_id_seq
-- ----------------------------
CREATE SEQUENCE "artists_id_seq"
 INCREMENT 1
 MINVALUE 1
 MAXVALUE 2147483647
 START 275
 CACHE 1;
SELECT setval('"public"."artists_id_seq"', 275, true);


-- ----------------------------
-- Sequence structure for customer_customer_id_seq
-- ----------------------------
CREATE SEQUENCE "customers_id_seq"
 INCREMENT 1
 MINVALUE 1
 MAXVALUE 2147483647
 START 59
 CACHE 1;
SELECT setval('"public"."customers_id_seq"', 59, true);


-- ----------------------------
-- Sequence structure for genre_genre_id_seq
-- ----------------------------
CREATE SEQUENCE "genres_id_seq"
 INCREMENT 1
 MINVALUE 1
 MAXVALUE 2147483647
 START 25
 CACHE 1;
SELECT setval('"public"."genres_id_seq"', 25, true);


-- ----------------------------
-- Sequence structure for employee_employee_id_seq
-- ----------------------------
CREATE SEQUENCE "employees_id_seq"
 INCREMENT 1
 MINVALUE 1
 MAXVALUE 2147483647
 START 8
 CACHE 1;
SELECT setval('"public"."employees_id_seq"', 8, true);


-- ----------------------------
-- Sequence structure for invoice_invoice_id_seq
-- ----------------------------
CREATE SEQUENCE "invoices_id_seq"
 INCREMENT 1
 MINVALUE 1
 MAXVALUE 2147483647
 START 412
 CACHE 1;
SELECT setval('"public"."invoices_id_seq"', 412, true);


-- ----------------------------
-- Sequence structure for invoiceline_invoiceline_id_seq
-- ----------------------------
CREATE SEQUENCE "invoicelines_id_seq"
 INCREMENT 1
 MINVALUE 1
 MAXVALUE 2147483647
 START 2240
 CACHE 1;
SELECT setval('"public"."invoicelines_id_seq"', 2240, true);


-- ----------------------------
-- Sequence structure for mediatype_mediatype_id_seq
-- ----------------------------
CREATE SEQUENCE "mediatypes_id_seq"
 INCREMENT 1
 MINVALUE 1
 MAXVALUE 2147483647
 START 5
 CACHE 1;
SELECT setval('"public"."mediatypes_id_seq"', 5, true);


-- ----------------------------
-- Sequence structure for playlist_playlist_id_seq
-- ----------------------------
CREATE SEQUENCE "playlists_id_seq"
 INCREMENT 1
 MINVALUE 1
 MAXVALUE 2147483647
 START 18
 CACHE 1;
SELECT setval('"public"."playlists_id_seq"', 18, true);


-- ----------------------------
-- Sequence structure for track_track_id_seq
-- ----------------------------
CREATE SEQUENCE "tracks_id_seq"
 INCREMENT 1
 MINVALUE 1
 MAXVALUE 2147483647
 START 3503
 CACHE 1;
SELECT setval('"public"."tracks_id_seq"', 3503, true);

-- /*******************************************************************************
--    Create Tables
-- ********************************************************************************/
CREATE TABLE albums
(
    id int DEFAULT nextval('albums_id_seq'::regclass) NOT NULL,
    title VARCHAR(160) NOT NULL,
    artist_id INT NOT NULL,
    CONSTRAINT pk_albums PRIMARY KEY  (id)
);

CREATE TABLE artists
(
    id int DEFAULT nextval('artists_id_seq'::regclass) NOT NULL,
    name VARCHAR(120),
    CONSTRAINT pk_artists PRIMARY KEY  (id)
);

CREATE TABLE customers
(
    id int DEFAULT nextval('customers_id_seq'::regclass) 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 pk_customers PRIMARY KEY  (id)
);

CREATE TABLE employees
(
    id int DEFAULT nextval('employees_id_seq'::regclass) 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 pk_employees PRIMARY KEY  (id)
);

CREATE TABLE genres
(
    id int DEFAULT nextval('genres_id_seq'::regclass) NOT NULL,
    name VARCHAR(120),
    CONSTRAINT pk_genres PRIMARY KEY  (id)
);

CREATE TABLE invoices
(
    id int DEFAULT nextval('invoices_id_seq'::regclass) 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 pk_invoices PRIMARY KEY  (id)
);

CREATE TABLE invoice_lines
(
    id int DEFAULT nextval('invoicelines_id_seq'::regclass) NOT NULL,
    invoice_id INT NOT NULL,
    track_id INT NOT NULL,
    unit_price NUMERIC(10,2) NOT NULL,
    quantity INT NOT NULL,
    CONSTRAINT ok_invoice_lines PRIMARY KEY  (id)
);

CREATE TABLE media_types
(
    id int DEFAULT nextval('mediatypes_id_seq'::regclass) NOT NULL,
    name VARCHAR(120),
    CONSTRAINT pk_media_types PRIMARY KEY  (id)
);

CREATE TABLE playlists
(
    id int DEFAULT nextval('playlists_id_seq'::regclass) NOT NULL,
    name VARCHAR(120),
    CONSTRAINT pk_playlists PRIMARY KEY  (id)
);

CREATE TABLE playlist_track
(
    playlist_id INT NOT NULL,
    track_id INT NOT NULL,
    CONSTRAINT pk_playlist_track PRIMARY KEY  (playlist_id, track_id)
);

CREATE TABLE tracks
(
    id int DEFAULT nextval('tracks_id_seq'::regclass) 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 pk_tracks PRIMARY KEY  (id)
);



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

/*******************************************************************************
   Create Foreign Keys
********************************************************************************/
ALTER TABLE albums ADD CONSTRAINT fk_album_artist_id
    FOREIGN KEY (artist_id) REFERENCES artists (id) ON DELETE NO ACTION ON UPDATE NO ACTION;

CREATE INDEX ifk_album_artist_id ON albums (artist_id);

ALTER TABLE customers ADD CONSTRAINT fk_customer_support_rep_id
    FOREIGN KEY (support_rep_id) REFERENCES employees (id) ON DELETE NO ACTION ON UPDATE NO ACTION;

CREATE INDEX ifk_customer_support_rep_id ON customers (support_rep_id);

ALTER TABLE employees ADD CONSTRAINT fk_employee_reports_to
    FOREIGN KEY (reports_to) REFERENCES employees (id) ON DELETE NO ACTION ON UPDATE NO ACTION;

CREATE INDEX ifk_employee_reports_to ON employees (reports_to);

ALTER TABLE invoices ADD CONSTRAINT fk_invoice_customer_id
    FOREIGN KEY (customer_id) REFERENCES customers (id) ON DELETE NO ACTION ON UPDATE NO ACTION;

CREATE INDEX ifk_invoice_customer_id ON invoices (customer_id);

ALTER TABLE invoice_lines ADD CONSTRAINT fk_invoice_line_invoice_id
    FOREIGN KEY (invoice_id) REFERENCES invoices (id) ON DELETE NO ACTION ON UPDATE NO ACTION;

CREATE INDEX ifk_invoice_line_invoice_id ON invoice_lines (invoice_id);

ALTER TABLE invoice_lines ADD CONSTRAINT fk_invoice_line_track_id
    FOREIGN KEY (track_id) REFERENCES tracks (id) ON DELETE NO ACTION ON UPDATE NO ACTION;

CREATE INDEX ifk_invoice_line_track_id ON invoice_lines (track_id);

ALTER TABLE playlist_track ADD CONSTRAINT fk_playlist_track_playlist_id
    FOREIGN KEY (playlist_id) REFERENCES playlists (id) ON DELETE NO ACTION ON UPDATE NO ACTION;

ALTER TABLE playlist_track ADD CONSTRAINT fk_playlist_track_track_id
    FOREIGN KEY (track_id) REFERENCES tracks (id) ON DELETE NO ACTION ON UPDATE NO ACTION;

CREATE INDEX ifk_playlist_track_track_id ON playlist_track (track_id);

ALTER TABLE tracks ADD CONSTRAINT fk_track_album_id
    FOREIGN KEY (album_id) REFERENCES albums (id) ON DELETE NO ACTION ON UPDATE NO ACTION;

CREATE INDEX ifk_track_album_id ON tracks (album_id);

ALTER TABLE tracks ADD CONSTRAINT fk_track_genre_id
    FOREIGN KEY (genre_id) REFERENCES genres (id) ON DELETE NO ACTION ON UPDATE NO ACTION;

CREATE INDEX ifk_track_genre_id ON tracks (genre_id);

ALTER TABLE tracks ADD CONSTRAINT fk_track_media_type_id
    FOREIGN KEY (media_type_id) REFERENCES media_types (id) ON DELETE NO ACTION ON UPDATE NO ACTION;

CREATE INDEX ifk_track_media_type_id ON tracks (media_type_id);


/*******************************************************************************
   Populate Tables
********************************************************************************/
INSERT INTO genres (id, name) VALUES (1, N'Rock');
INSERT INTO genres (id, name) VALUES (2, N'Jazz');
INSERT INTO genres (id, name) VALUES (3, N'Metal');
INSERT INTO genres (id, name) VALUES (4, N'Alternative & Punk');
INSERT INTO genres (id, name) VALUES (5, N'Rock And Roll');
INSERT INTO genres (id, name) VALUES (6, N'Blues');
INSERT INTO genres (id, name) VALUES (7, N'Latin');
INSERT INTO genres (id, name) VALUES (8, N'Reggae');
INSERT INTO genres (id, name) VALUES (9, N'Pop');
INSERT INTO genres (id, name) VALUES (10, N'Soundtrack');
INSERT INTO genres (id, name) VALUES (11, N'Bossa Nova');
INSERT INTO genres (id, name) VALUES (12, N'Easy Listening');
INSERT INTO genres (id, name) VALUES (13, N'Heavy Metal');
INSERT INTO genres (id, name) VALUES (14, N'R&B/Soul');
INSERT INTO genres (id, name) VALUES (15, N'Electronica/Dance');
INSERT INTO genres (id, name) VALUES (16, N'World');
INSERT INTO genres (id, name) VALUES (17, N'Hip Hop/Rap');
INSERT INTO genres (id, name) VALUES (18, N'Science Fiction');
INSERT INTO genres (id, name) VALUES (19, N'TV Shows');
INSERT INTO genres (id, name) VALUES (20, N'Sci Fi & Fantasy');
INSERT INTO genres (id, name) VALUES (21, N'Drama');
INSERT INTO genres (id, name) VALUES (22, N'Comedy');
INSERT INTO genres (id, name) VALUES (23, N'Alternative');
INSERT INTO genres (id, name) VALUES (24, N'Classical');
INSERT INTO genres (id, name) VALUES (25, N'Opera');

INSERT INTO media_types (id, name) VALUES (1, N'MPEG audio file');
INSERT INTO media_types (id, name) VALUES (2, N'Protected AAC audio file');
INSERT INTO media_types (id, name) VALUES (3, N'Protected MPEG-4 video file');
INSERT INTO media_types (id, name) VALUES (4, N'Purchased AAC audio file');
INSERT INTO media_types (id, name) VALUES (5, N'AAC audio file');

INSERT INTO artists (id, name) VALUES (1, N'AC/DC');
INSERT INTO artists (id, name) VALUES (2, N'Accept');
INSERT INTO artists (id, name) VALUES (3, N'Aerosmith');
INSERT INTO artists (id, name) VALUES (4, N'Alanis Morissette');
INSERT INTO artists (id, name) VALUES (5, N'Alice In Chains');
INSERT INTO artists (id, name) VALUES (6, N'Antônio Carlos Jobim');
INSERT INTO artists (id, name) VALUES (7, N'Apocalyptica');
INSERT INTO artists (id, name) VALUES (8, N'Audioslave');
INSERT INTO artists (id, name) VALUES (9, N'BackBeat');
INSERT INTO artists (id, name) VALUES (10, N'Billy Cobham');

INSERT INTO albums (id, title, artist_id) VALUES (1, N'For Those About To Rock We Salute You', 1);
INSERT INTO albums (id, title, artist_id) VALUES (2, N'Balls to the Wall', 2);
INSERT INTO albums (id, title, artist_id) VALUES (3, N'Restless and Wild', 2);
INSERT INTO albums (id, title, artist_id) VALUES (4, N'Let There Be Rock', 1);
INSERT INTO albums (id, title, artist_id) VALUES (5, N'Big Ones', 3);
INSERT INTO albums (id, title, artist_id) VALUES (6, N'Jagged Little Pill', 4);
INSERT INTO albums (id, title, artist_id) VALUES (7, N'Facelift', 5);
INSERT INTO albums (id, title, artist_id) VALUES (8, N'Warner 25 Anos', 6);
INSERT INTO albums (id, title, artist_id) VALUES (9, N'Plays Metallica By Four Cellos', 7);
INSERT INTO albums (id, title, artist_id) VALUES (10, N'Audioslave', 8);
INSERT INTO albums (id, title, artist_id) VALUES (11, N'Out Of Exile', 8);
INSERT INTO albums (id, title, artist_id) VALUES (12, N'BackBeat Soundtrack', 9);
INSERT INTO albums (id, title, artist_id) VALUES (13, N'The Best Of Billy Cobham', 10);
INSERT INTO albums (id, title, artist_id) VALUES (34, N'Chill: Brazil (Disc 2)', 6);

INSERT INTO tracks (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);
INSERT INTO tracks (id, name, album_id, media_type_id, genre_id, milliseconds, bytes, unit_price) VALUES (2, N'Balls to the Wall', 2, 2, 1, 342562, 5510424, 0.99);
INSERT INTO tracks (id, name, album_id, media_type_id, genre_id, composer, milliseconds, bytes, unit_price) VALUES (3, N'Fast As a Shark', 3, 2, 1, N'F. Baltes, S. Kaufman, U. Dirkscneider & W. Hoffman', 230619, 3990994, 0.99);
INSERT INTO tracks (id, name, album_id, media_type_id, genre_id, composer, milliseconds, bytes, unit_price) VALUES (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);
INSERT INTO tracks (id, name, album_id, media_type_id, genre_id, composer, milliseconds, bytes, unit_price) VALUES (5, N'Princess of the Dawn', 3, 2, 1, N'Deaffy & R.A. Smith-Diesel', 375418, 6290521, 0.99);
INSERT INTO tracks (id, name, album_id, media_type_id, genre_id, composer, milliseconds, bytes, unit_price) VALUES (6, N'Put The Finger On You', 1, 1, 1, N'Angus Young, Malcolm Young, Brian Johnson', 205662, 6713451, 0.99);
INSERT INTO tracks (id, name, album_id, media_type_id, genre_id, composer, milliseconds, bytes, unit_price) VALUES (7, N'Let''s Get It Up', 1, 1, 1, N'Angus Young, Malcolm Young, Brian Johnson', 233926, 7636561, 0.99);
INSERT INTO tracks (id, name, album_id, media_type_id, genre_id, composer, milliseconds, bytes, unit_price) VALUES (8, N'Inject The Venom', 1, 1, 1, N'Angus Young, Malcolm Young, Brian Johnson', 210834, 6852860, 0.99);
INSERT INTO tracks (id, name, album_id, media_type_id, genre_id, composer, milliseconds, bytes, unit_price) VALUES (9, N'Snowballed', 1, 1, 1, N'Angus Young, Malcolm Young, Brian Johnson', 203102, 6599424, 0.99);
INSERT INTO tracks (id, name, album_id, media_type_id, genre_id, composer, milliseconds, bytes, unit_price) VALUES (10, N'Evil Walks', 1, 1, 1, N'Angus Young, Malcolm Young, Brian Johnson', 263497, 8611245, 0.99);
INSERT INTO tracks (id, name, album_id, media_type_id, genre_id, composer, milliseconds, bytes, unit_price) VALUES (11, N'C.O.D.', 1, 1, 1, N'Angus Young, Malcolm Young, Brian Johnson', 199836, 6566314, 0.99);
INSERT INTO tracks (id, name, album_id, media_type_id, genre_id, composer, milliseconds, bytes, unit_price) VALUES (12, N'Breaking The Rules', 1, 1, 1, N'Angus Young, Malcolm Young, Brian Johnson', 263288, 8596840, 0.99);
INSERT INTO tracks (id, name, album_id, media_type_id, genre_id, composer, milliseconds, bytes, unit_price) VALUES (13, N'Night Of The Long Knives', 1, 1, 1, N'Angus Young, Malcolm Young, Brian Johnson', 205688, 6706347, 0.99);
INSERT INTO tracks (id, name, album_id, media_type_id, genre_id, composer, milliseconds, bytes, unit_price) VALUES (14, N'Spellbound', 1, 1, 1, N'Angus Young, Malcolm Young, Brian Johnson', 270863, 8817038, 0.99);
INSERT INTO tracks (id, name, album_id, media_type_id, genre_id, composer, milliseconds, bytes, unit_price) VALUES (15, N'Go Down', 4, 1, 1, N'AC/DC', 331180, 10847611, 0.99);
INSERT INTO tracks (id, name, album_id, media_type_id, genre_id, composer, milliseconds, bytes, unit_price) VALUES (16, N'Dog Eat Dog', 4, 1, 1, N'AC/DC', 215196, 7032162, 0.99);
INSERT INTO tracks (id, name, album_id, media_type_id, genre_id, composer, milliseconds, bytes, unit_price) VALUES (17, N'Let There Be Rock', 4, 1, 1, N'AC/DC', 366654, 12021261, 0.99);
INSERT INTO tracks (id, name, album_id, media_type_id, genre_id, composer, milliseconds, bytes, unit_price) VALUES (18, N'Bad Boy Boogie', 4, 1, 1, N'AC/DC', 267728, 8776140, 0.99);
INSERT INTO tracks (id, name, album_id, media_type_id, genre_id, composer, milliseconds, bytes, unit_price) VALUES (19, N'Problem Child', 4, 1, 1, N'AC/DC', 325041, 10617116, 0.99);
INSERT INTO tracks (id, name, album_id, media_type_id, genre_id, composer, milliseconds, bytes, unit_price) VALUES (20, N'Overdose', 4, 1, 1, N'AC/DC', 369319, 12066294, 0.99);
INSERT INTO tracks (id, name, album_id, media_type_id, genre_id, composer, milliseconds, bytes, unit_price) VALUES (21, N'Hell Ain''t A Bad Place To Be', 4, 1, 1, N'AC/DC', 254380, 8331286, 0.99);
INSERT INTO tracks (id, name, album_id, media_type_id, genre_id, composer, milliseconds, bytes, unit_price) VALUES (22, N'Whole Lotta Rosie', 4, 1, 1, N'AC/DC', 323761, 10547154, 0.99);
INSERT INTO tracks (id, name, album_id, media_type_id, genre_id, composer, milliseconds, bytes, unit_price) VALUES (23, N'Walk On Water', 5, 1, 1, N'Steven Tyler, Joe Perry, Jack Blades, Tommy Shaw', 295680, 9719579, 0.99);
INSERT INTO tracks (id, name, album_id, media_type_id, genre_id, composer, milliseconds, bytes, unit_price) VALUES (24, N'Love In An Elevator', 5, 1, 1, N'Steven Tyler, Joe Perry', 321828, 10552051, 0.99);
INSERT INTO tracks (id, name, album_id, media_type_id, genre_id, composer, milliseconds, bytes, unit_price) VALUES (25, N'Rag Doll', 5, 1, 1, N'Steven Tyler, Joe Perry, Jim Vallance, Holly Knight', 264698, 8675345, 0.99);
INSERT INTO tracks (id, name, album_id, media_type_id, genre_id, composer, milliseconds, bytes, unit_price) VALUES (26, N'What It Takes', 5, 1, 1, N'Steven Tyler, Joe Perry, Desmond Child', 310622, 10144730, 0.99);
INSERT INTO tracks (id, name, album_id, media_type_id, genre_id, composer, milliseconds, bytes, unit_price) VALUES (27, N'Dude (Looks Like A Lady)', 5, 1, 1, N'Steven Tyler, Joe Perry, Desmond Child', 264855, 8679940, 0.99);
INSERT INTO tracks (id, name, album_id, media_type_id, genre_id, composer, milliseconds, bytes, unit_price) VALUES (28, N'Janie''s Got A Gun', 5, 1, 1, N'Steven Tyler, Tom Hamilton', 330736, 10869391, 0.99);
INSERT INTO tracks (id, name, album_id, media_type_id, genre_id, composer, milliseconds, bytes, unit_price) VALUES (29, N'Cryin''', 5, 1, 1, N'Steven Tyler, Joe Perry, Taylor Rhodes', 309263, 10056995, 0.99);
INSERT INTO tracks (id, name, album_id, media_type_id, genre_id, composer, milliseconds, bytes, unit_price) VALUES (30, N'Amazing', 5, 1, 1, N'Steven Tyler, Richie Supa', 356519, 11616195, 0.99);
INSERT INTO tracks (id, name, album_id, media_type_id, genre_id, composer, milliseconds, bytes, unit_price) VALUES (31, N'Blind Man', 5, 1, 1, N'Steven Tyler, Joe Perry, Taylor Rhodes', 240718, 7877453, 0.99);
INSERT INTO tracks (id, name, album_id, media_type_id, genre_id, composer, milliseconds, bytes, unit_price) VALUES (32, N'Deuces Are Wild', 5, 1, 1, N'Steven Tyler, Jim Vallance', 215875, 7074167, 0.99);
INSERT INTO tracks (id, name, album_id, media_type_id, genre_id, composer, milliseconds, bytes, unit_price) VALUES (33, N'The Other Side', 5, 1, 1, N'Steven Tyler, Jim Vallance', 244375, 7983270, 0.99);
INSERT INTO tracks (id, name, album_id, media_type_id, genre_id, composer, milliseconds, bytes, unit_price) VALUES (34, N'Crazy', 5, 1, 1, N'Steven Tyler, Joe Perry, Desmond Child', 316656, 10402398, 0.99);
INSERT INTO tracks (id, name, album_id, media_type_id, genre_id, composer, milliseconds, bytes, unit_price) VALUES (35, N'Eat The Rich', 5, 1, 1, N'Steven Tyler, Joe Perry, Jim Vallance', 251036, 8262039, 0.99);
INSERT INTO tracks (id, name, album_id, media_type_id, genre_id, composer, milliseconds, bytes, unit_price) VALUES (36, N'Angel', 5, 1, 1, N'Steven Tyler, Desmond Child', 307617, 9989331, 0.99);
INSERT INTO tracks (id, name, album_id, media_type_id, genre_id, composer, milliseconds, bytes, unit_price) VALUES (37, N'Livin'' On The Edge', 5, 1, 1, N'Steven Tyler, Joe Perry, Mark Hudson', 381231, 12374569, 0.99);
INSERT INTO tracks (id, name, album_id, media_type_id, genre_id, composer, milliseconds, bytes, unit_price) VALUES (38, N'All I Really Want', 6, 1, 1, N'Alanis Morissette & Glenn Ballard', 284891, 9375567, 0.99);
INSERT INTO tracks (id, name, album_id, media_type_id, genre_id, composer, milliseconds, bytes, unit_price) VALUES (39, N'You Oughta Know', 6, 1, 1, N'Alanis Morissette & Glenn Ballard', 249234, 8196916, 0.99);
INSERT INTO tracks (id, name, album_id, media_type_id, genre_id, composer, milliseconds, bytes, unit_price) VALUES (40, N'Perfect', 6, 1, 1, N'Alanis Morissette & Glenn Ballard', 188133, 6145404, 0.99);
INSERT INTO tracks (id, name, album_id, media_type_id, genre_id, composer, milliseconds, bytes, unit_price) VALUES (41, N'Hand In My Pocket', 6, 1, 1, N'Alanis Morissette & Glenn Ballard', 221570, 7224246, 0.99);
INSERT INTO tracks (id, name, album_id, media_type_id, genre_id, composer, milliseconds, bytes, unit_price) VALUES (42, N'Right Through You', 6, 1, 1, N'Alanis Morissette & Glenn Ballard', 176117, 5793082, 0.99);
INSERT INTO tracks (id, name, album_id, media_type_id, genre_id, composer, milliseconds, bytes, unit_price) VALUES (43, N'Forgiven', 6, 1, 1, N'Alanis Morissette & Glenn Ballard', 300355, 9753256, 0.99);
INSERT INTO tracks (id, name, album_id, media_type_id, genre_id, composer, milliseconds, bytes, unit_price) VALUES (44, N'You Learn', 6, 1, 1, N'Alanis Morissette & Glenn Ballard', 239699, 7824837, 0.99);
INSERT INTO tracks (id, name, album_id, media_type_id, genre_id, composer, milliseconds, bytes, unit_price) VALUES (45, N'Head Over Feet', 6, 1, 1, N'Alanis Morissette & Glenn Ballard', 267493, 8758008, 0.99);
INSERT INTO tracks (id, name, album_id, media_type_id, genre_id, composer, milliseconds, bytes, unit_price) VALUES (46, N'Mary Jane', 6, 1, 1, N'Alanis Morissette & Glenn Ballard', 280607, 9163588, 0.99);
INSERT INTO tracks (id, name, album_id, media_type_id, genre_id, composer, milliseconds, bytes, unit_price) VALUES (47, N'Ironic', 6, 1, 1, N'Alanis Morissette & Glenn Ballard', 229825, 7598866, 0.99);
INSERT INTO tracks (id, name, album_id, media_type_id, genre_id, composer, milliseconds, bytes, unit_price) VALUES (48, N'Not The Doctor', 6, 1, 1, N'Alanis Morissette & Glenn Ballard', 227631, 7604601, 0.99);
INSERT INTO tracks (id, name, album_id, media_type_id, genre_id, composer, milliseconds, bytes, unit_price) VALUES (49, N'Wake Up', 6, 1, 1, N'Alanis Morissette & Glenn Ballard', 293485, 9703359, 0.99);
INSERT INTO tracks (id, name, album_id, media_type_id, genre_id, composer, milliseconds, bytes, unit_price) VALUES (50, N'You Oughta Know (Alternate)', 6, 1, 1, N'Alanis Morissette & Glenn Ballard', 491885, 16008629, 0.99);
INSERT INTO tracks (id, name, album_id, media_type_id, genre_id, composer, milliseconds, bytes, unit_price) VALUES (51, N'We Die Young', 7, 1, 1, N'Jerry Cantrell', 152084, 4925362, 0.99);
INSERT INTO tracks (id, name, album_id, media_type_id, genre_id, composer, milliseconds, bytes, unit_price) VALUES (52, N'Man In The Box', 7, 1, 1, N'Jerry Cantrell, Layne Staley', 286641, 9310272, 0.99);
INSERT INTO tracks (id, name, album_id, media_type_id, genre_id, composer, milliseconds, bytes, unit_price) VALUES (53, N'Sea Of Sorrow', 7, 1, 1, N'Jerry Cantrell', 349831, 11316328, 0.99);
INSERT INTO tracks (id, name, album_id, media_type_id, genre_id, composer, milliseconds, bytes, unit_price) VALUES (54, N'Bleed The Freak', 7, 1, 1, N'Jerry Cantrell', 241946, 7847716, 0.99);
INSERT INTO tracks (id, name, album_id, media_type_id, genre_id, composer, milliseconds, bytes, unit_price) VALUES (55, N'I Can''t Remember', 7, 1, 1, N'Jerry Cantrell, Layne Staley', 222955, 7302550, 0.99);
INSERT INTO tracks (id, name, album_id, media_type_id, genre_id, composer, milliseconds, bytes, unit_price) VALUES (56, N'Love, Hate, Love', 7, 1, 1, N'Jerry Cantrell, Layne Staley', 387134, 12575396, 0.99);
INSERT INTO tracks (id, name, album_id, media_type_id, genre_id, composer, milliseconds, bytes, unit_price) VALUES (57, N'It Ain''t Like That', 7, 1, 1, N'Jerry Cantrell, Michael Starr, Sean Kinney', 277577, 8993793, 0.99);
INSERT INTO tracks (id, name, album_id, media_type_id, genre_id, composer, milliseconds, bytes, unit_price) VALUES (58, N'Sunshine', 7, 1, 1, N'Jerry Cantrell', 284969, 9216057, 0.99);
INSERT INTO tracks (id, name, album_id, media_type_id, genre_id, composer, milliseconds, bytes, unit_price) VALUES (59, N'Put You Down', 7, 1, 1, N'Jerry Cantrell', 196231, 6420530, 0.99);
INSERT INTO tracks (id, name, album_id, media_type_id, genre_id, composer, milliseconds, bytes, unit_price) VALUES (60, N'Confusion', 7, 1, 1, N'Jerry Cantrell, Michael Starr, Layne Staley', 344163, 11183647, 0.99);
INSERT INTO tracks (id, name, album_id, media_type_id, genre_id, composer, milliseconds, bytes, unit_price) VALUES (61, N'I Know Somethin (Bout You)', 7, 1, 1, N'Jerry Cantrell', 261955, 8497788, 0.99);
INSERT INTO tracks (id, name, album_id, media_type_id, genre_id, composer, milliseconds, bytes, unit_price) VALUES (62, N'Real Thing', 7, 1, 1, N'Jerry Cantrell, Layne Staley', 243879, 7937731, 0.99);
INSERT INTO tracks (id, name, album_id, media_type_id, genre_id, milliseconds, bytes, unit_price) VALUES (63, N'Desafinado', 8, 1, 2, 185338, 5990473, 0.99);
INSERT INTO tracks (id, name, album_id, media_type_id, genre_id, milliseconds, bytes, unit_price) VALUES (64, N'Garota De Ipanema', 8, 1, 2, 285048, 9348428, 0.99);
INSERT INTO tracks (id, name, album_id, media_type_id, genre_id, milliseconds, bytes, unit_price) VALUES (65, N'Samba De Uma Nota Só (One Note Samba)', 8, 1, 2, 137273, 4535401, 0.99);
INSERT INTO tracks (id, name, album_id, media_type_id, genre_id, milliseconds, bytes, unit_price) VALUES (66, N'Por Causa De Você', 8, 1, 2, 169900, 5536496, 0.99);