SET table_type=INNODB;
CREATE TABLE track (
trkid INTEGER,
trknum INTEGER NOT NULL,
trktitle VARCHAR(25) NOT NULL,
trklength DECIMAL(4,2) NOT NULL,
	PRIMARY KEY(trkid));
	
INSERT INTO track VALUES (1, 1, 'Giant steps', 4.72);
INSERT INTO track VALUES (2, 2, 'Cousin Mary', 5.75);
INSERT INTO track VALUES (3, 3, 'Countdown', 2.35);
INSERT INTO track VALUES (4, 4, 'Spiral', 5.93);
INSERT INTO track VALUES (5, 5, 'Syeeda''s song flute', 7);
INSERT INTO track VALUES (6, 6, 'Naima', 4.35);
INSERT INTO track VALUES (7, 7, 'Mr. P.C.', 6.95);
INSERT INTO track VALUES (8, 8, 'Giant steps', 3.67);
INSERT INTO track VALUES (9, 9, 'Naima', 4.45);
INSERT INTO track VALUES (10, 10, 'Cousin Mary', 5.9);
INSERT INTO track VALUES (11, 11, 'Countdown', 4.55);
INSERT INTO track VALUES (12, 12, 'Syeeda''s song flute', 7.03);
INSERT INTO track VALUES (13, 1, 'Stomp of King Porter', 3.2);
INSERT INTO track VALUES (14, 2, 'Sing a Study in Brown', 2.85);
INSERT INTO track VALUES (15, 3, 'Sing Moten''s Swing', 3.6);
INSERT INTO track VALUES (16, 4, 'A-tisket, A-tasket', 2.95);
INSERT INTO track VALUES (17, 5, 'I Know Why', 3.57);
INSERT INTO track VALUES (18, 6, 'Sing You Sinners', 2.75);
INSERT INTO track VALUES (19, 7, 'Java Jive', 2.85);
INSERT INTO track VALUES (20, 8, 'Down South Camp Meetin''', 3.25);
INSERT INTO track VALUES (21, 9, 'Topsy', 3.23);
INSERT INTO track VALUES (22, 10, 'Clouds', 7.2);
INSERT INTO track VALUES (23, 11, 'Skyliner', 3.18);
INSERT INTO track VALUES (24, 12, 'It''s Good Enough to Keep', 3.18);
INSERT INTO track VALUES (25, 13, 'Choo Choo Ch'' Boogie', 3);