-- -------------------------------------------------------- -- Host: 127.0.0.1 -- Server version: 5.7.14-log - MySQL Community Server (GPL) -- Server OS: Win64 -- HeidiSQL Version: 9.4.0.5145 -- -------------------------------------------------------- /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET NAMES utf8 */; /*!50503 SET NAMES utf8mb4 */; /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */; /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; -- Dumping database structure for music library CREATE DATABASE IF NOT EXISTS `test db` /*!40100 DEFAULT CHARACTER SET utf8 */; USE `test db`; -- Dumping structure for table music library.artists CREATE TABLE IF NOT EXISTS `artists` ( `artist_id` int(11) NOT NULL AUTO_INCREMENT, `artist_name` varchar(128) NOT NULL, `artist_timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (`artist_id`) ) ENGINE=InnoDB AUTO_INCREMENT=100 DEFAULT CHARSET=latin1; -- Dumping data for table music library.artists: ~80 rows (approximately) /*!40000 ALTER TABLE `artists` DISABLE KEYS */; INSERT INTO `artists` (`artist_id`, `artist_name`, `artist_timestamp`) VALUES (20, '45 Singles', '2013-02-18 11:47:24'), (21, '78 Singles', '2013-02-18 11:47:46'), (22, 'Ahmad Jamal', '2013-02-18 11:47:47'), (23, 'Al Jolson', '2013-02-18 11:47:47'), (24, 'Al Stewart', '2013-02-18 11:47:47'), (25, 'Alan White', '2013-02-18 11:47:47'), (26, 'Badfinger', '2013-02-18 11:47:48'), (27, 'Beatles', '2013-02-18 11:47:48'), (28, 'Blood Sweat and Tears', '2013-02-18 11:47:51'), (29, 'Bread', '2013-02-18 11:47:51'), (30, 'Britten', '2013-02-18 11:47:51'), (31, 'Carly Simon', '2013-02-18 11:47:52'), (32, 'Chicago', '2013-02-18 11:47:52'), (33, 'Chris Squire', '2013-02-18 11:47:52'), (34, 'Christmas Music', '2013-02-18 11:47:52'), (35, 'Chuck Mangione', '2013-02-18 11:47:53'), (36, 'Claude Bolling', '2013-02-18 11:47:53'), (37, 'Commodores', '2013-02-18 11:47:53'), (38, 'Cream', '2013-02-18 11:47:53'), (39, 'Deep Purple', '2013-02-18 11:47:54'), (40, 'Eagles', '2013-02-18 11:47:54'), (41, 'Eric Clapton', '2013-02-18 11:47:55'), (42, 'Genesis', '2013-02-18 11:47:55'), (43, 'George Benson', '2013-02-18 11:47:56'), (44, 'George Harrison', '2013-02-18 11:47:56'), (45, 'Guess Who', '2013-02-18 11:47:57'), (46, 'Igor Stravinsky', '2013-02-18 11:47:58'), (47, 'Jan Akkerman', '2013-02-18 11:47:58'), (48, 'Jethro Tull', '2013-02-18 11:47:58'), (49, 'Jim Croce', '2013-02-18 11:47:59'), (50, 'John Denver', '2013-02-18 11:47:59'), (51, 'John Entwistle', '2013-02-18 11:48:00'), (52, 'John Lennon', '2013-02-18 11:48:00'), (53, 'Jon Anderson', '2013-02-18 11:48:00'), (54, 'Julian Lennon', '2013-02-18 11:48:01'), (55, 'Ludwig van Beethoven', '2013-02-18 11:48:01'), (56, 'Mamas and Papas', '2013-02-18 11:48:01'), (57, 'Modern Jazz Quartet', '2013-02-18 11:48:01'), (58, 'Oliver Mtukudzi', '2013-02-18 11:48:01'), (59, 'Patrick Moraz', '2013-02-18 11:48:01'), (60, 'Paul McCartney', '2013-02-18 11:48:02'), (61, 'Peter Paul and Mary', '2013-02-18 11:48:02'), (62, 'Prokofiev', '2013-02-18 11:48:02'), (63, 'Rick Wakeman', '2013-02-18 11:48:02'), (64, 'Seals and Crofts', '2013-02-18 11:48:03'), (65, 'Spyra Gyra', '2013-02-18 11:48:04'), (66, 'Stanley Clarke', '2013-02-18 11:48:04'), (67, 'Steve Howe', '2013-02-18 11:48:04'), (68, 'The Who', '2013-02-18 11:48:04'), (69, 'Ventures', '2013-02-18 11:48:05'), (70, 'Waylon Jennings', '2013-02-18 11:48:05'), (71, 'Willie Nelson', '2013-02-18 11:48:05'), (72, 'Yes', '2013-02-18 11:48:06'), (73, 'BB King', '2013-03-03 16:59:08'), (74, 'Led Zeppelin', '2013-03-03 16:59:23'), (75, 'Rush', '2013-03-03 16:59:26'), (76, 'Warren Zevon', '2013-03-03 16:59:30'), (77, 'Pink Floyd', '2013-03-11 12:58:00'), (78, 'Rolling Stones', '2013-03-11 12:58:02'), (79, 'Cat Stevens', '2013-03-26 20:57:20'), (80, 'Crosby Stills Nash and Young', '2013-03-26 20:57:26'), (81, 'Donovan', '2013-03-26 20:57:28'), (82, 'Focus', '2013-03-26 20:57:30'), (83, 'Graham Nash', '2013-03-26 20:57:33'), (84, 'Lionel Ritchie', '2013-03-26 20:57:38'), (85, 'Neil Young', '2013-03-26 20:57:39'), (86, 'Santana', '2013-03-26 20:57:44'), (87, 'Stephen Stills', '2013-03-26 20:57:46'), (88, 'Chase', '2013-05-03 10:32:08'), (89, 'Leon Russell', '2013-05-03 10:32:31'), (90, 'The Doors', '2013-05-03 10:32:42'), (91, 'The Four Tops', '2013-05-03 10:32:43'), (92, 'The Spinners', '2013-05-03 10:32:43'), (93, 'The Supremes', '2013-05-03 10:32:43'), (94, 'The Temptations', '2013-05-03 10:32:44'), (95, 'America', '2014-09-10 16:00:21'), (96, 'Jon and Vangelis', '2014-09-10 16:00:35'), (97, 'Ted Nugent and the Amboy Dukes', '2014-09-10 16:00:43'), (98, 'The Carpenters', '2014-09-10 16:00:43'), (99, 'Vangelis', '2014-09-10 16:00:44'); /*!40000 ALTER TABLE `artists` ENABLE KEYS */; /*!40101 SET SQL_MODE=IFNULL(@OLD_SQL_MODE, '') */; /*!40014 SET FOREIGN_KEY_CHECKS=IF(@OLD_FOREIGN_KEY_CHECKS IS NULL, 1, @OLD_FOREIGN_KEY_CHECKS) */; /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;