-- phpMyAdmin SQL Dump
-- version 4.0.10deb1
-- http://www.phpmyadmin.net
--
-- Machine: localhost
-- Genereertijd: 19 apr 2016 om 20:33
-- Serverversie: 5.5.43-0ubuntu0.14.04.1
-- PHP-versie: 5.5.9-1ubuntu4.9

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;

--
-- Databank: `colorstrike`
--

-- --------------------------------------------------------

--
-- Tabelstructuur voor tabel `highscore`
--

CREATE TABLE IF NOT EXISTS `highscore` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `songinstance` int(11) NOT NULL,
  `username` varchar(5) NOT NULL,
  `score` bigint(20) NOT NULL,
  `date` date NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=95 ;

--
-- Gegevens worden uitgevoerd voor tabel `highscore`
--

INSERT INTO `highscore` (`id`, `songinstance`, `username`, `score`, `date`) VALUES
(1, 60, 'JANCO', 2306, '2015-11-04'),
(2, 6, 'JANCO', 2821, '2015-11-04'),
(3, 53, 'KENNY', 1603, '2015-11-04'),
(4, 51, 'KENNY', 1763, '2015-11-04'),
(5, 74, 'ABC', 477, '2015-11-06'),
(6, 79, 'JADD', 3589, '2015-11-06'),
(7, 8, 'JANCO', 2819, '2015-11-06'),
(8, 79, 'D-+', 190, '2015-11-07'),
(9, 33, 'JANCO', 1957, '2015-11-07'),
(10, 25, 'PANCO', 4, '2015-11-07'),
(11, 78, 'PANCO', 594, '2015-11-07'),
(12, 32, 'JANCO', 2883, '2015-11-07'),
(13, 95, 'JANCO', 6146, '2015-11-07'),
(14, 78, 'JANCO', 187, '2015-11-07'),
(15, 43, 'OHNOO', 370, '2015-11-07'),
(16, 66, 'OHNOO', 2, '2015-11-07'),
(17, 68, 'OHNNO', 114, '2015-11-07'),
(18, 67, 'OHNNO', 1303, '2015-11-07'),
(19, 125, 'OHNMO', 60, '2015-11-07'),
(20, 29, 'OHNMO', 291, '2015-11-07'),
(21, 34, 'OHNMO', 2325, '2015-11-07'),
(22, 78, 'OHNMO', 195, '2015-11-07'),
(23, 51, 'KENNY', 3139, '2015-11-07'),
(24, 29, 'KENNZ', 171, '2015-11-07'),
(25, 128, 'JANCO', 1371, '2015-11-07'),
(26, 139, 'JANCO', 1615, '2015-11-07'),
(27, 79, 'JANCO', 343, '2015-11-07'),
(28, 95, 'TIM', 1879, '2015-11-07'),
(29, 25, 'TIM', 8517, '2015-11-07'),
(30, 13, 'TIM', 166, '2015-11-07'),
(31, 81, 'TIM', 791, '2015-11-07'),
(32, 25, 'THM', 2511, '2015-11-07'),
(33, 8, 'JHM', 1514, '2015-11-07'),
(34, 4, 'KENNY', 1249, '2015-11-07'),
(35, 13, 'KENNY', 203, '2015-11-07'),
(36, 13, 'KENNY', 1094, '2015-11-07'),
(37, 79, 'JANCO', 4184, '2015-11-07'),
(38, 25, 'JANCN', 246, '2015-11-07'),
(39, 32, 'JANCO', 2747, '2015-11-07'),
(40, 32, 'JANCO', 352, '2015-11-07'),
(41, 32, 'JANCT', 2, '2015-11-07'),
(42, 31, 'JANCQ', 1458, '2015-11-07'),
(43, 32, 'JANZ-', 912, '2015-11-07'),
(44, 78, 'JANZ-', 45, '2015-11-07'),
(45, 5, 'JANZ-', 1295, '2015-11-07'),
(46, 25, 'TOBY', 2375, '2015-11-07'),
(47, 25, 'JAN', 3215, '2016-01-22'),
(48, 78, 'H!N', 144, '2016-01-22'),
(49, 118, 'H!N', 1234, '2016-01-22'),
(50, 81, 'DDCB', 1194, '2016-01-22'),
(51, 25, 'DABAA', 872, '2016-01-22'),
(52, 25, 'KENNY', 1892, '2016-01-23'),
(53, 66, 'KENNY', 498, '2016-01-23'),
(54, 25, 'KENNY', 1122, '2016-01-23'),
(55, 1, 'KENNY', 1008, '2016-01-23'),
(56, 139, 'KENNY', 452, '2016-01-23'),
(57, 9, 'KENNX', 356, '2016-01-23'),
(58, 79, 'KENNT', 945, '2016-01-23'),
(59, 5, 'KENNY', 135, '2016-01-23'),
(60, 114, 'KENNY', 1766, '2016-01-23'),
(61, 26, 'LENNY', 509, '2016-01-23'),
(62, 56, 'MENNY', 878, '2016-01-23'),
(63, 3, '3BDC', 174, '2016-01-23'),
(64, 105, '3BDC', 1422, '2016-01-23'),
(65, 57, '3BDCJ', 516, '2016-01-23'),
(66, 81, '3BDCJ', 173, '2016-01-23'),
(67, 17, 'YO!', 676, '2016-01-23'),
(68, 1, 'MARK', 1191, '2016-01-23'),
(69, 31, 'MARK', 8, '2016-01-23'),
(70, 25, 'MARK', 61, '2016-01-23'),
(71, 110, 'SEX!', 2790, '2016-01-23'),
(72, 120, 'PE+IS', 1554, '2016-01-23'),
(73, 56, 'KENNY', 1546, '2016-01-23'),
(74, 6, 'KENNY', 1255, '2016-01-23'),
(75, 7, 'LENNY', 1898, '2016-01-23'),
(76, 99, 'KENNY', 873, '2016-01-23'),
(77, 78, 'KENNY', 254, '2016-03-23'),
(78, 1, 'MAX', 974, '2016-03-23'),
(79, 14, 'MAX', 2052, '2016-03-23'),
(80, 13, 'MAX', 386, '2016-03-23'),
(81, 13, 'MAX', 327, '2016-03-23'),
(82, 14, 'MAX', 1438, '2016-03-23'),
(83, 13, 'MAX', 147, '2016-03-23'),
(84, 13, 'MAX', 460, '2016-03-23'),
(85, 13, '?CX', 543, '2016-03-23'),
(86, 59, 'XCX', 129, '2016-03-23'),
(87, 96, 'XCX', 328, '2016-03-23'),
(88, 31, 'XCX', 51, '2016-03-23'),
(89, 70, 'XDX', 135, '2016-03-23'),
(90, 71, 'XDX', 602, '2016-03-23'),
(91, 105, 'XDXC', 885, '2016-03-23'),
(92, 1, 'BARTM', 1714, '2016-03-23'),
(93, 51, 'BARTM', 997, '2016-03-23'),
(94, 13, 'HENTY', 2100, '2016-03-23');

-- --------------------------------------------------------

--
-- Tabelstructuur voor tabel `playdata`
--

CREATE TABLE IF NOT EXISTS `playdata` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `songinstance` int(11) NOT NULL,
  `enemies_missed` int(11) NOT NULL,
  `enemies_hit` int(11) NOT NULL,
  `buttons_pressed` int(11) NOT NULL,
  `joystick_moved` int(11) NOT NULL,
  `start_time` datetime NOT NULL,
  `play_time` bigint(20) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=165 ;

--
-- Gegevens worden uitgevoerd voor tabel `playdata`
--

INSERT INTO `playdata` (`id`, `songinstance`, `enemies_missed`, `enemies_hit`, `buttons_pressed`, `joystick_moved`, `start_time`, `play_time`) VALUES
(1, 60, 2, 61, 65, 119, '2015-11-04 14:10:50', 77230),
(2, 6, 23, 82, 123, 173, '2015-11-04 14:13:39', 63228),
(3, 53, 38, 59, 82, 115, '2015-11-04 14:16:18', 59389),
(4, 51, 20, 12, 20, 25, '2015-11-04 14:18:08', 23363),
(5, 51, 17, 59, 73, 114, '2015-11-04 14:19:43', 78738),
(6, 14, 33, 65, 105, 139, '2015-11-04 14:21:40', 56900),
(7, 95, 34, 31, 64, 172, '2015-11-06 14:08:05', 39955),
(8, 27, 10, 0, 0, 38, '2015-11-06 14:09:03', 15123),
(9, 27, 10, 0, 0, 27, '2015-11-06 14:09:23', 15141),
(10, 62, 28, 50, 81, 148, '2015-11-06 14:25:57', 44684),
(11, 74, 18, 21, 47, 69, '2015-11-06 14:31:20', 44505),
(12, 96, 13, 0, 0, 59, '2015-11-06 14:32:15', 7557),
(13, 79, 20, 11, 22, 26, '2015-11-06 14:33:37', 18156),
(14, 79, 38, 88, 138, 280, '2015-11-06 14:35:09', 83054),
(15, 8, 3, 73, 79, 161, '2015-11-06 15:34:27', 76266),
(16, 79, 13, 0, 1, 0, '2015-11-07 09:29:16', 7379),
(17, 79, 16, 7, 29, 70, '2015-11-07 09:29:37', 14380),
(18, 33, 23, 41, 67, 121, '2015-11-07 09:34:40', 36694),
(19, 119, 14, 3, 10, 27, '2015-11-07 10:21:46', 12002),
(20, 25, 13, 0, 1, 5, '2015-11-07 11:06:05', 8980),
(21, 25, 14, 1, 6, 10, '2015-11-07 11:06:25', 10142),
(22, 78, 25, 21, 43, 104, '2015-11-07 11:19:28', 32211),
(23, 32, 30, 75, 101, 174, '2015-11-07 11:25:42', 59599),
(24, 95, 32, 132, 160, 255, '2015-11-07 11:39:06', 110591),
(25, 78, 15, 7, 17, 26, '2015-11-07 11:41:10', 20053),
(26, 81, 13, 0, 3, 11, '2015-11-07 11:43:58', 7761),
(27, 43, 16, 12, 28, 43, '2015-11-07 11:44:40', 27826),
(28, 66, 16, 11, 24, 36, '2015-11-07 11:48:17', 20105),
(29, 66, 5, 2, 3, 2, '2015-11-07 11:48:46', 9387),
(30, 66, 12, 1, 5, 6, '2015-11-07 11:55:58', 12362),
(31, 66, 15, 8, 16, 17, '2015-11-07 11:56:24', 18023),
(32, 68, 14, 8, 12, 35, '2015-11-07 11:58:11', 26175),
(33, 67, 16, 61, 72, 133, '2015-11-07 11:59:44', 79983),
(34, 125, 14, 1, 3, 5, '2015-11-07 12:03:49', 8251),
(35, 29, 12, 20, 34, 45, '2015-11-07 12:05:09', 46727),
(36, 34, 9, 48, 53, 94, '2015-11-07 12:10:51', 71810),
(37, 9, 14, 21, 24, 42, '2015-11-07 12:20:46', 50649),
(38, 13, 12, 7, 22, 35, '2015-11-07 12:26:26', 22173),
(39, 110, 13, 0, 0, 8, '2015-11-07 12:44:30', 8021),
(40, 3, 9, 0, 0, 17, '2015-11-07 12:45:05', 15803),
(41, 33, 28, 55, 92, 149, '2015-11-07 12:51:12', 46071),
(42, 78, 14, 5, 12, 28, '2015-11-07 12:55:09', 18509),
(43, 51, 5, 71, 73, 111, '2015-11-07 13:01:32', 78748),
(44, 28, 14, 7, 8, 15, '2015-11-07 13:21:26', 17531),
(45, 29, 13, 12, 14, 114, '2015-11-07 13:27:32', 32731),
(46, 61, 12, 20, 23, 59, '2015-11-07 13:30:13', 51287),
(47, 5, 13, 3, 12, 20, '2015-11-07 13:31:45', 12346),
(48, 21, 21, 18, 34, 63, '2015-11-07 13:32:55', 34754),
(49, 128, 29, 35, 56, 114, '2015-11-07 13:40:54', 37224),
(50, 139, 5, 33, 42, 85, '2015-11-07 13:55:31', 47096),
(51, 79, 26, 17, 29, 59, '2015-11-07 13:59:30', 24422),
(52, 95, 39, 50, 79, 142, '2015-11-07 14:02:47', 53876),
(53, 25, 52, 189, 276, 314, '2015-11-07 14:17:25', 129676),
(54, 25, 13, 0, 2, 11, '2015-11-07 14:20:41', 8913),
(55, 13, 12, 5, 18, 27, '2015-11-07 14:21:09', 19996),
(56, 81, 30, 25, 53, 80, '2015-11-07 14:23:44', 30869),
(57, 81, 17, 5, 9, 3, '2015-11-07 14:24:08', 12527),
(58, 25, 57, 76, 147, 181, '2015-11-07 14:25:31', 72189),
(59, 8, 21, 65, 93, 168, '2015-11-07 14:27:24', 91970),
(60, 4, 6, 50, 59, 99, '2015-11-07 14:31:49', 70856),
(61, 13, 12, 6, 18, 20, '2015-11-07 15:04:14', 21129),
(62, 13, 22, 40, 64, 115, '2015-11-07 15:05:43', 58316),
(63, 79, 42, 106, 166, 205, '2015-11-07 15:11:38', 94218),
(64, 25, 19, 8, 17, 31, '2015-11-07 15:18:55', 16915),
(65, 32, 29, 74, 106, 189, '2015-11-07 15:23:25', 58668),
(66, 32, 12, 0, 0, 12, '2015-11-07 15:25:53', 10802),
(67, 31, 11, 0, 0, 24, '2015-11-07 15:26:13', 13331),
(68, 32, 12, 0, 0, 11, '2015-11-07 15:26:36', 10763),
(69, 32, 17, 13, 23, 26, '2015-11-07 15:27:00', 20030),
(70, 32, 11, 1, 9, 1, '2015-11-07 15:27:17', 10876),
(71, 31, 13, 54, 75, 107, '2015-11-07 15:28:42', 71302),
(72, 32, 31, 36, 65, 96, '2015-11-07 15:29:54', 39396),
(73, 32, 10, 0, 11, 16, '2015-11-07 15:30:35', 9763),
(74, 78, 13, 5, 15, 21, '2015-11-07 15:31:35', 18358),
(75, 75, 14, 27, 52, 52, '2015-11-07 15:32:59', 51526),
(76, 5, 31, 45, 75, 123, '2015-11-07 15:34:05', 44000),
(77, 128, 27, 39, 77, 82, '2015-11-07 15:35:13', 38229),
(78, 25, 57, 74, 185, 213, '2015-11-07 15:48:56', 71097),
(79, 61, 10, 22, 26, 40, '2015-11-07 15:51:23', 50756),
(80, 58, 19, 14, 20, 68, '2016-01-22 14:19:40', 23503),
(81, 31, 11, 0, 0, 0, '2016-01-22 14:46:40', 13530),
(82, 25, 48, 95, 140, 187, '2016-01-22 14:51:37', 77146),
(83, 78, 16, 8, 14, 32, '2016-01-22 14:53:09', 21113),
(84, 118, 38, 36, 68, 98, '2016-01-22 14:54:29', 39963),
(85, 64, 33, 33, 60, 102, '2016-01-22 14:58:43', 41668),
(86, 89, 13, 0, 0, 0, '2016-01-22 14:59:22', 7848),
(87, 89, 13, 0, 0, 0, '2016-01-22 14:59:58', 7851),
(88, 90, 10, 0, 0, 0, '2016-01-22 15:00:30', 13760),
(89, 79, 26, 81, 105, 173, '2016-01-22 15:15:28', 65425),
(90, 81, 37, 43, 62, 152, '2016-01-22 15:19:35', 45072),
(91, 46, 5, 0, 0, 0, '2016-01-22 15:39:20', 8878),
(92, 25, 12, 0, 8, 17, '2016-01-22 15:54:17', 8356),
(93, 25, 24, 31, 41, 69, '2016-01-22 15:54:52', 31868),
(94, 25, 47, 67, 86, 124, '2016-01-23 09:27:46', 62446),
(95, 66, 17, 17, 28, 34, '2016-01-23 09:40:48', 23810),
(96, 25, 35, 34, 69, 73, '2016-01-23 10:12:31', 39365),
(97, 1, 18, 34, 47, 113, '2016-01-23 10:54:37', 61193),
(98, 139, 15, 23, 41, 74, '2016-01-23 10:57:50', 47091),
(99, 9, 13, 13, 18, 39, '2016-01-23 11:11:30', 41899),
(100, 79, 38, 33, 49, 84, '2016-01-23 11:35:07', 39347),
(101, 5, 11, 0, 7, 13, '2016-01-23 11:37:53', 9706),
(102, 5, 16, 6, 20, 35, '2016-01-23 11:38:11', 15096),
(103, 114, 17, 51, 61, 118, '2016-01-23 11:49:03', 69787),
(104, 26, 13, 11, 22, 45, '2016-01-23 11:50:16', 22117),
(105, 95, 22, 11, 23, 36, '2016-01-23 11:53:42', 18769),
(106, 56, 17, 29, 36, 69, '2016-01-23 11:55:23', 78054),
(107, 34, 21, 36, 51, 82, '2016-01-23 12:12:24', 71798),
(108, 3, 13, 6, 13, 49, '2016-01-23 12:38:04', 23066),
(109, 105, 13, 37, 39, 54, '2016-01-23 12:49:11', 47946),
(110, 57, 26, 17, 29, 60, '2016-01-23 12:56:55', 23137),
(111, 81, 18, 6, 12, 13, '2016-01-23 13:09:44', 13286),
(112, 81, 13, 0, 2, 9, '2016-01-23 13:18:02', 7694),
(113, 1, 11, 44, 57, 128, '2016-01-23 13:19:42', 70598),
(114, 15, 6, 26, 35, 53, '2016-01-23 13:44:25', 38114),
(115, 17, 19, 36, 40, 100, '2016-01-23 14:06:27', 69560),
(116, 1, 7, 48, 55, 104, '2016-01-23 14:29:27', 70601),
(117, 31, 11, 1, 1, 31, '2016-01-23 14:50:24', 14281),
(118, 31, 11, 0, 0, 19, '2016-01-23 14:50:52', 13231),
(119, 25, 13, 0, 0, 15, '2016-01-23 14:51:41', 8835),
(120, 25, 12, 0, 3, 9, '2016-01-23 14:51:59', 8469),
(121, 25, 13, 2, 8, 15, '2016-01-23 14:52:14', 10137),
(122, 79, 16, 5, 11, 24, '2016-01-23 14:52:59', 13267),
(123, 110, 60, 85, 139, 220, '2016-01-23 14:54:52', 86843),
(124, 25, 55, 57, 104, 138, '2016-01-23 14:58:16', 61511),
(125, 25, 18, 8, 21, 45, '2016-01-23 14:59:02', 15502),
(126, 120, 26, 51, 72, 140, '2016-01-23 15:04:35', 62273),
(127, 56, 11, 41, 52, 137, '2016-01-23 15:23:31', 84806),
(128, 6, 34, 39, 55, 80, '2016-01-23 15:34:35', 44367),
(129, 7, 35, 62, 119, 164, '2016-01-23 15:37:38', 79449),
(130, 99, 15, 28, 32, 75, '2016-01-23 15:40:29', 50480),
(131, 78, 15, 7, 16, 39, '2016-03-23 18:03:22', 20138),
(132, 78, 14, 0, 0, 7, '2016-03-23 18:04:21', 7832),
(133, 95, 13, 0, 1, 4, '2016-03-23 18:04:54', 9463),
(134, 1, 12, 43, 56, 113, '2016-03-23 18:36:22', 70583),
(135, 1, 8, 0, 1, 0, '2016-03-23 18:37:23', 17514),
(136, 14, 38, 56, 89, 134, '2016-03-23 18:38:29', 55184),
(137, 13, 11, 2, 4, 22, '2016-03-23 18:40:06', 16867),
(138, 13, 14, 13, 33, 54, '2016-03-23 18:40:43', 28247),
(139, 13, 20, 17, 30, 55, '2016-03-23 18:41:32', 35999),
(140, 14, 12, 0, 0, 28, '2016-03-23 18:51:30', 10706),
(141, 14, 22, 42, 59, 117, '2016-03-23 18:52:13', 38012),
(142, 13, 15, 17, 63, 70, '2016-03-23 18:57:41', 32961),
(143, 13, 12, 5, 15, 33, '2016-03-23 19:11:27', 20092),
(144, 13, 15, 10, 26, 46, '2016-03-23 19:12:11', 26327),
(145, 13, 19, 18, 38, 52, '2016-03-23 19:13:10', 36096),
(146, 59, 13, 9, 18, 44, '2016-03-23 19:15:29', 29910),
(147, 59, 10, 0, 2, 18, '2016-03-23 19:15:49', 13498),
(148, 96, 14, 1, 4, 18, '2016-03-23 19:22:10', 8478),
(149, 96, 22, 11, 26, 41, '2016-03-23 19:22:32', 17477),
(150, 63, 23, 18, 30, 35, '2016-03-23 19:45:27', 26441),
(151, 31, 11, 1, 4, 60, '2016-03-23 19:59:05', 14608),
(152, 103, 15, 2, 3, 21, '2016-03-23 20:04:01', 9359),
(153, 103, 15, 2, 5, 13, '2016-03-23 20:04:18', 9165),
(154, 103, 15, 3, 12, 34, '2016-03-23 20:06:33', 10032),
(155, 103, 14, 0, 0, 26, '2016-03-23 20:11:44', 7658),
(156, 103, 14, 0, 0, 13, '2016-03-23 20:11:59', 7857),
(157, 103, 14, 0, 0, 8, '2016-03-23 20:12:17', 7685),
(158, 103, 14, 0, 0, 7, '2016-03-23 20:13:13', 7798),
(159, 70, 16, 3, 4, 10, '2016-03-23 20:13:38', 10453),
(160, 71, 7, 24, 55, 37, '2016-03-23 20:14:39', 44617),
(161, 105, 24, 29, 58, 91, '2016-03-23 20:26:06', 49914),
(162, 1, 15, 40, 70, 109, '2016-03-23 20:34:07', 70583),
(163, 51, 27, 37, 62, 220, '2016-03-23 20:46:11', 57973),
(164, 13, 16, 60, 85, 120, '2016-03-23 20:51:49', 76270);

-- --------------------------------------------------------

--
-- Tabelstructuur voor tabel `song`
--

CREATE TABLE IF NOT EXISTS `song` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `folder` varchar(256) NOT NULL,
  `title` varchar(128) NOT NULL,
  `author` varchar(128) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `folder` (`folder`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=192 ;

--
-- Gegevens worden uitgevoerd voor tabel `song`
--

INSERT INTO `song` (`id`, `folder`, `title`, `author`) VALUES
(1, 'Radioactive3', 'Radioactive', 'Imagine Dragons'),
(2, 'Technologic7', 'Technologic', 'Daft Punk'),
(3, 'Shake_it_Off7', 'Shake it Off', 'Taylor Swift'),
(4, 'Winnie_The_Pooh9', 'Winnie The Pooh', 'King & Queen'),
(5, 'Timber0', 'Timber', 'Pitbull feat. KE$HA'),
(6, 'You_Can_Fly__You_Can_Fly__You_Can_Fly_6', 'You Can Fly! You Can Fly! You Can Fly!', 'Disney Grooves'),
(7, 'GREEN_HILL_ZONE_Sonic_the_Hedgehog_3', 'GREEN HILL ZONE', 'Sonic Team'),
(8, 'Fury_of_the_Storm4', 'Fury of the Storm', 'Dragonforce'),
(9, 'Boom_Clap3', 'Boom Clap', 'Charli XCX'),
(10, 'Da_Roots_Folk_Mix_5', 'Da Roots', 'Mind Reflection'),
(11, 'Boogie_Down6', 'Boogie Down', 'Inurvise'),
(12, 'Feel_Good__Inc.1', 'Feel Good, Inc.', 'Gorillaz'),
(13, 'Hakanaku_mo_Towa_no_KanashiDuvet_00_2nd_Season__2008_4', 'Hakanaku mo Towa no Kanashi', 'UVERworld'),
(14, 'Itsumo_Nando_DemoSen_to_Chihiro_no_Kamikakushi__2001_8', 'Itsumo Nando Demo', 'B.U.S feat. MAKI'),
(15, 'Moskau1', 'Moskau', 'Dschinghis Khan'),
(16, 'Hikari_no_SenritsuSound_of_the_Sky_OP__2010_8', 'Hikari no Senritsu', 'Kalafina'),
(17, '___-HOMURA-1', 'ç„”-HOMURA-', 'zzzz'),
(18, 'First_Helping5', 'First Helping', 'Jun Ishikawa'),
(19, 'Break_Free3', 'Break Free', 'Ariana Grande'),
(20, 'Eight6', 'Eight', 'Emotional Joystick'),
(21, 'Love_KanonKami_nomi_zo_Shiru_Sekai_IN5__2010_1', 'Love Kanon', 'Nakagawa Kanon (Nao Toyama)'),
(22, 'Penny_Arcade_Theme0', 'Penny Arcade Theme', 'MC Frontalot'),
(23, 'Blurred_Lines__feat._Pharell_6', 'Blurred Lines (feat. Pharell)', 'Robin Thicke'),
(24, 'KIM_POSSIBLE_THEME_SONG3', 'KIM POSSIBLE THEME SONG', 'KIM POSSIBLE'),
(25, 'Route_29Pokemon_Gold___Silver4', 'Route 29', 'Junichi Masuda, Go Ichinose'),
(26, 'Du_Hast0', 'Du Hast', 'Rammstein'),
(27, 'Popcorn8', 'Popcorn', 'Kraftwerk'),
(28, 'Supercalifragilisticexpialidocious4', 'Supercalifragilisticexpialidocious', 'Go Go Girls'),
(29, 'Makka_na_ChikaiBusou_Renkin_OP__2006_4', 'Makka na Chikai', 'Fukuyama Yoshiki'),
(30, 'Ievan_Polkka6', 'Ievan Polkka', 'Hatsune Miku'),
(31, 'Maccarron_Chacarron8', 'Maccarron Chacarron', 'El Mudo'),
(32, 'All_The_Things_She_Said9', 'All The Things She Said', 'T.a.t.u'),
(33, '_Ending_Pokemon_Red_Blue9', '~Ending~', 'Go Ichinose'),
(34, 'Changes5', 'Changes', 'Rivera & Haze'),
(35, 'Connect_1986IcyWorld6', 'Connect 1986', 'Fantom'),
(36, 'Pokerap4', 'Pokerap', 'That guy who must have been high when he created this song, but who ended up making millions off of it'),
(37, 'Why_Me9', 'Why Me', 'Desire'),
(38, 'Take_On_Me2', 'Take On Me', 'A-Ha'),
(39, 'One_Winged_Angel_Advent_Children_0', 'One Winged Angel', 'Final Fantasy 7'),
(40, 'Popipo3', 'Popipo', 'Hatsune Miku'),
(41, 'America__Fuck_Yah_0', 'America, Fuck Yah!', 'DVDA'),
(42, 'Nippon_Egao_HyakkeiJoshiraku_ED__2012_7', 'Nippon Egao Hyakkei', 'Momokurotei Ichimon'),
(43, 'The_Bare_Necessities5', 'The Bare Necessities', 'Disney Grooves'),
(44, 'Cooking_by_the_Book5', 'Cooking by the Book', 'LazyTown'),
(45, 'Triple_Baka5', 'Triple Baka', 'Hatsune Miku, Akita Neru & Kasane Teto'),
(46, 'Meteor_ImpactStardust_Witch_Meruru_OP__Oreimo_Insert_8', 'Meteor Impact', 'Tamura Yukari'),
(47, 'Wiggle__feat._Snoop_Dogg_6', 'Wiggle (feat. Snoop Dogg)', 'Jason Derulo'),
(48, 'Taiyou_Iwaku_Moeyo_ChaosHaiyore__Nyaruko-san_OP__2012_8', 'Taiyou Iwaku Moeyo Chaos', 'Ushiro Kara Haiyoritai G'),
(49, 'THE_BEST_OF_BOTH_WORLDS0', 'THE BEST OF BOTH WORLDS', 'HANNAH MONTANA'),
(148, 'All_The_Things_She_Said1', 'All The Things She Said', 'T.a.t.u'),
(149, 'America__Fuck_Yah_9', 'America, Fuck Yah!', 'DVDA'),
(150, 'Boogie_Down8', 'Boogie Down', 'Inurvise'),
(151, 'Changes3', 'Changes', 'Rivera & Haze'),
(152, 'Connect_1986IcyWorld0', 'Connect 1986', 'Fantom'),
(153, 'Cooking_by_the_Book0', 'Cooking by the Book', 'LazyTown'),
(154, 'Da_Roots_Folk_Mix_6', 'Da Roots', 'Mind Reflection'),
(155, 'Du_Hast7', 'Du Hast', 'Rammstein'),
(156, 'Eight3', 'Eight', 'Emotional Joystick'),
(157, 'Feel_Good__Inc.8', 'Feel Good, Inc.', 'Gorillaz'),
(158, 'First_Helping2', 'First Helping', 'Jun Ishikawa'),
(159, 'Fury_of_the_Storm2', 'Fury of the Storm', 'Dragonforce'),
(160, 'GREEN_HILL_ZONE_Sonic_the_Hedgehog_5', 'GREEN HILL ZONE', 'Sonic Team'),
(161, 'Hakanaku_mo_Towa_no_KanashiDuvet_00_2nd_Season__2008_9', 'Hakanaku mo Towa no Kanashi', 'UVERworld'),
(162, 'Hikari_no_SenritsuSound_of_the_Sky_OP__2010_5', 'Hikari no Senritsu', 'Kalafina'),
(164, 'Itsumo_Nando_DemoSen_to_Chihiro_no_Kamikakushi__2001_0', 'Itsumo Nando Demo', 'B.U.S feat. MAKI'),
(165, 'KIM_POSSIBLE_THEME_SONG1', 'KIM POSSIBLE THEME SONG', 'KIM POSSIBLE'),
(166, 'Love_KanonKami_nomi_zo_Shiru_Sekai_IN5__2010_0', 'Love Kanon', 'Nakagawa Kanon (Nao Toyama)'),
(167, 'Maccarron_Chacarron5', 'Maccarron Chacarron', 'El Mudo'),
(169, 'Meteor_ImpactStardust_Witch_Meruru_OP__Oreimo_Insert_1', 'Meteor Impact', 'Tamura Yukari'),
(170, 'Moskau7', 'Moskau', 'Dschinghis Khan'),
(172, 'One_Winged_Angel_Advent_Children_1', 'One Winged Angel', 'Final Fantasy 7'),
(173, 'Penny_Arcade_Theme2', 'Penny Arcade Theme', 'MC Frontalot'),
(174, 'Pokerap1', 'Pokerap', 'That guy who must have been high when he created this song, but who ended up making millions off of it'),
(175, 'Popcorn6', 'Popcorn', 'Kraftwerk'),
(177, 'Route_29Pokemon_Gold___Silver0', 'Route 29', 'Junichi Masuda, Go Ichinose'),
(178, 'Supercalifragilisticexpialidocious7', 'Supercalifragilisticexpialidocious', 'Go Go Girls'),
(179, 'Taiyou_Iwaku_Moeyo_ChaosHaiyore__Nyaruko-san_OP__2012_4', 'Taiyou Iwaku Moeyo Chaos', 'Ushiro Kara Haiyoritai G'),
(180, 'Take_On_Me0', 'Take On Me', 'A-Ha'),
(181, 'Technologic4', 'Technologic', 'Daft Punk'),
(182, 'The_Bare_Necessities7', 'The Bare Necessities', 'Disney Grooves'),
(183, 'THE_BEST_OF_BOTH_WORLDS1', 'THE BEST OF BOTH WORLDS', 'HANNAH MONTANA'),
(184, 'Triple_Baka2', 'Triple Baka', 'Hatsune Miku, Akita Neru & Kasane Teto'),
(185, 'Why_Me4', 'Why Me', 'Desire'),
(186, 'Winnie_The_Pooh7', 'Winnie The Pooh', 'King & Queen'),
(187, 'You_Can_Fly__You_Can_Fly__You_Can_Fly_4', 'You Can Fly! You Can Fly! You Can Fly!', 'Disney Grooves'),
(188, '_Ending_Pokemon_Red_Blue7', '~Ending~', 'Go Ichinose'),
(189, '___VCP_11', '???', 'ryo feat. ????'),
(190, '___VCP_13', '???', '???P feat. ?????'),
(191, '___________VCP_19', '???????????', '????P feat. ????');

-- --------------------------------------------------------

--
-- Tabelstructuur voor tabel `songinstance`
--

CREATE TABLE IF NOT EXISTS `songinstance` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `song` int(11) NOT NULL,
  `enemies` int(11) NOT NULL,
  `difficulty` varchar(12) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=265 ;

--
-- Gegevens worden uitgevoerd voor tabel `songinstance`
--

INSERT INTO `songinstance` (`id`, `song`, `enemies`, `difficulty`) VALUES
(1, 1, 55, 'beginner'),
(2, 1, 90, 'hard'),
(3, 1, 63, 'medium'),
(4, 1, 56, 'easy'),
(5, 2, 124, 'hard'),
(6, 3, 146, 'hard'),
(7, 3, 106, 'medium'),
(8, 3, 86, 'easy'),
(9, 3, 67, 'beginner'),
(10, 4, 138, 'beginner'),
(11, 4, 152, 'easy'),
(12, 4, 172, 'medium'),
(13, 5, 76, 'easy'),
(14, 5, 122, 'hard'),
(15, 5, 61, 'beginner'),
(16, 5, 91, 'medium'),
(17, 6, 55, 'beginner'),
(18, 6, 56, 'easy'),
(19, 6, 47, 'medium'),
(20, 6, 89, 'hard'),
(21, 7, 66, 'easy'),
(22, 7, 78, 'medium'),
(23, 7, 87, 'hard'),
(24, 7, 108, 'challenge'),
(25, 8, 616, 'challenge'),
(26, 9, 45, 'medium'),
(27, 9, 38, 'easy'),
(28, 9, 59, 'hard'),
(29, 9, 32, 'beginner'),
(30, 9, 67, 'challenge'),
(31, 10, 67, 'easy'),
(32, 10, 116, 'hard'),
(33, 10, 123, 'challenge'),
(34, 10, 57, 'beginner'),
(35, 10, 78, 'medium'),
(36, 11, 86, 'easy'),
(37, 11, 96, 'medium'),
(38, 11, 155, 'hard'),
(39, 11, 81, 'beginner'),
(40, 11, 162, 'challenge'),
(41, 12, 230, 'hard'),
(42, 12, 159, 'medium'),
(43, 12, 145, 'easy'),
(44, 12, 140, 'beginner'),
(45, 12, 225, 'challenge'),
(46, 13, 51, 'beginner'),
(47, 13, 61, 'easy'),
(48, 13, 68, 'medium'),
(49, 13, 88, 'hard'),
(50, 13, 102, 'challenge'),
(51, 14, 76, 'medium'),
(52, 14, 124, 'challenge'),
(53, 15, 244, 'hard'),
(54, 16, 137, 'challenge'),
(55, 16, 133, 'hard'),
(56, 17, 67, 'Challenge'),
(57, 18, 97, 'hard'),
(58, 19, 93, 'hard'),
(59, 19, 66, 'medium'),
(60, 19, 63, 'easy'),
(61, 19, 51, 'beginner'),
(62, 19, 129, 'challenge'),
(63, 20, 199, 'hard'),
(64, 21, 126, 'hard'),
(65, 21, 106, 'medium'),
(66, 22, 125, 'hard'),
(67, 22, 77, 'medium'),
(68, 22, 67, 'easy'),
(69, 22, 67, 'beginner'),
(70, 23, 77, 'hard'),
(71, 23, 31, 'beginner'),
(72, 23, 42, 'easy'),
(73, 23, 54, 'medium'),
(74, 24, 39, 'beginner'),
(75, 24, 41, 'easy'),
(76, 24, 51, 'medium'),
(77, 24, 65, 'hard'),
(78, 25, 49, 'hard'),
(79, 26, 199, 'challenge'),
(80, 26, 208, 'hard'),
(81, 27, 221, 'hard'),
(82, 28, 146, 'beginner'),
(83, 28, 161, 'easy'),
(84, 28, 204, 'medium'),
(85, 29, 82, 'easy'),
(86, 29, 93, 'medium'),
(87, 29, 124, 'hard'),
(88, 29, 133, 'challenge'),
(89, 30, 106, 'challenge'),
(90, 30, 49, 'beginner'),
(91, 30, 106, 'hard'),
(92, 30, 79, 'medium'),
(93, 30, 57, 'easy'),
(94, 31, 222, 'hard'),
(95, 32, 236, 'hard'),
(96, 33, 111, 'hard'),
(97, 34, 102, 'hard'),
(98, 34, 63, 'medium'),
(99, 34, 55, 'easy'),
(100, 34, 53, 'beginner'),
(101, 34, 107, 'challenge'),
(102, 35, 263, 'challenge'),
(103, 36, 147, 'hard'),
(104, 37, 64, 'easy'),
(105, 37, 72, 'medium'),
(106, 37, 109, 'hard'),
(107, 37, 117, 'challenge'),
(108, 37, 55, 'beginner'),
(109, 38, 134, 'hard'),
(110, 39, 325, 'hard'),
(111, 40, 119, 'challenge'),
(112, 40, 102, 'hard'),
(113, 40, 91, 'medium'),
(114, 40, 68, 'easy'),
(115, 40, 52, 'beginner'),
(116, 41, 140, 'hard'),
(117, 41, 153, 'challenge'),
(118, 42, 104, 'hard'),
(119, 42, 84, 'medium'),
(120, 42, 77, 'easy'),
(121, 43, 32, 'beginner'),
(122, 43, 22, 'easy'),
(123, 43, 40, 'medium'),
(124, 43, 62, 'hard'),
(125, 44, 77, 'hard'),
(126, 44, 85, 'challenge'),
(127, 44, 93, 'edit'),
(128, 45, 116, 'challenge'),
(129, 45, 109, 'hard'),
(130, 45, 57, 'beginner'),
(131, 45, 53, 'easy'),
(132, 45, 82, 'medium'),
(133, 46, 93, 'easy'),
(134, 46, 120, 'hard'),
(135, 46, 100, 'medium'),
(136, 46, 133, 'challenge'),
(137, 47, 28, 'beginner'),
(138, 47, 70, 'challenge'),
(139, 47, 38, 'easy'),
(140, 47, 53, 'medium'),
(141, 47, 68, 'hard'),
(142, 48, 94, 'challenge'),
(143, 48, 67, 'easy'),
(144, 48, 72, 'medium'),
(145, 48, 93, 'hard'),
(146, 48, 65, 'beginner'),
(147, 49, 49, 'beginner'),
(148, 49, 41, 'easy'),
(149, 49, 61, 'medium'),
(150, 49, 81, 'hard'),
(151, 148, 82, 'Hard'),
(152, 149, 29, 'Hard'),
(153, 149, 31, 'Challenge'),
(154, 150, 12, 'Easy'),
(155, 150, 32, 'Medium'),
(156, 150, 13, 'Hard'),
(157, 150, 0, 'Beginner'),
(158, 150, 22, 'Challenge'),
(159, 151, 19, 'Hard'),
(160, 151, 21, 'Medium'),
(161, 151, 17, 'Easy'),
(162, 151, 0, 'Beginner'),
(163, 151, 14, 'Challenge'),
(164, 152, 41, 'Challenge'),
(165, 153, 20, 'Hard'),
(166, 153, 21, 'Challenge'),
(167, 153, 19, 'Edit'),
(168, 154, 23, 'Easy'),
(169, 154, 16, 'Hard'),
(170, 154, 3, 'Challenge'),
(171, 154, 0, 'Beginner'),
(172, 154, 24, 'Medium'),
(173, 155, 62, 'Challenge'),
(174, 155, 49, 'Hard'),
(175, 156, 64, 'Hard'),
(176, 157, 72, 'Hard'),
(177, 157, 61, 'Medium'),
(178, 157, 94, 'Easy'),
(179, 157, 72, 'Beginner'),
(180, 157, 68, 'Challenge'),
(181, 158, 30, 'Hard'),
(182, 159, 197, 'Challenge'),
(183, 160, 6, 'Easy'),
(184, 160, 28, 'Medium'),
(185, 160, 44, 'Hard'),
(186, 160, 33, 'Challenge'),
(187, 161, 28, 'Beginner'),
(188, 161, 25, 'Easy'),
(189, 161, 31, 'Medium'),
(190, 161, 24, 'Hard'),
(191, 161, 18, 'Challenge'),
(192, 162, 27, 'Challenge'),
(193, 162, 33, 'Hard'),
(194, 164, 15, 'Medium'),
(195, 164, 16, 'Challenge'),
(196, 165, 5, 'Beginner'),
(197, 165, 12, 'Easy'),
(198, 165, 23, 'Medium'),
(199, 165, 16, 'Hard'),
(200, 166, 9, 'Hard'),
(201, 166, 17, 'Medium'),
(202, 167, 98, 'Hard'),
(203, 169, 44, 'Easy'),
(204, 169, 28, 'Hard'),
(205, 169, 34, 'Medium'),
(206, 169, 15, 'Challenge'),
(207, 170, 61, 'Hard'),
(208, 172, 79, 'Hard'),
(209, 173, 43, 'Hard'),
(210, 173, 26, 'Medium'),
(211, 173, 10, 'Easy'),
(212, 173, 5, 'Beginner'),
(213, 174, 35, 'Hard'),
(214, 175, 62, 'Hard'),
(215, 177, 21, 'Hard'),
(216, 178, 9, 'Beginner'),
(217, 178, 37, 'Easy'),
(218, 178, 100, 'Medium'),
(219, 179, 19, 'Challenge'),
(220, 179, 24, 'Easy'),
(221, 179, 28, 'Medium'),
(222, 179, 35, 'Hard'),
(223, 179, 18, 'Beginner'),
(224, 180, 43, 'Hard'),
(225, 181, 34, 'Hard'),
(226, 182, 0, 'Beginner'),
(227, 182, 0, 'Easy'),
(228, 182, 23, 'Medium'),
(229, 182, 4, 'Hard'),
(230, 183, 0, 'Beginner'),
(231, 183, 15, 'Easy'),
(232, 183, 13, 'Medium'),
(233, 183, 15, 'Hard'),
(234, 184, 33, 'Challenge'),
(235, 184, 36, 'Hard'),
(236, 184, 5, 'Beginner'),
(237, 184, 29, 'Easy'),
(238, 184, 37, 'Medium'),
(239, 185, 8, 'Easy'),
(240, 185, 34, 'Medium'),
(241, 185, 17, 'Hard'),
(242, 185, 27, 'Challenge'),
(243, 185, 1, 'Beginner'),
(244, 186, 1, 'Beginner'),
(245, 186, 1, 'Easy'),
(246, 186, 47, 'Medium'),
(247, 187, 0, 'Beginner'),
(248, 187, 12, 'Easy'),
(249, 187, 15, 'Medium'),
(250, 187, 35, 'Hard'),
(251, 188, 6, 'Hard'),
(252, 189, 10, 'Challenge'),
(253, 189, 0, 'Beginner'),
(254, 189, 24, 'Easy'),
(255, 189, 18, 'Medium'),
(256, 189, 16, 'Hard'),
(257, 190, 27, 'Hard'),
(258, 190, 27, 'Medium'),
(259, 190, 38, 'Easy'),
(260, 191, 0, 'Beginner'),
(261, 191, 70, 'Easy'),
(262, 191, 112, 'Medium'),
(263, 191, 96, 'Hard'),
(264, 191, 155, 'Challenge');

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;