 --
 
 INSERT INTO `tbl_post_passage` (`posten_passage_ID`, `post_ID`, `event_ID`, `group_ID`, `gepasseerd`, `binnenkomst`, `vertrek`, `create_time`, `create_user_ID`, `update_time`, `update_user_ID`) VALUES
-(1, 1, 6, 5, 1, '2014-09-05 20:47:00', '2014-09-05 20:55:00', '2014-09-05 20:47:54', 6, '2014-09-05 20:50:46', 6),
-(2, 1, 6, 8, 1, '2014-09-05 20:55:00', '2014-09-05 20:57:00', '2014-09-05 20:55:34', 6, '2014-09-05 20:57:48', 6),
-(3, 1, 6, 7, 1, '2014-09-05 21:38:00', '2014-09-05 22:05:00', '2014-09-05 21:38:56', 6, '2014-09-05 22:05:59', 6),
-(4, 1, 6, 9, 1, '2014-09-05 21:40:00', '2014-09-05 21:46:00', '2014-09-05 21:40:43', 6, '2014-09-05 21:53:58', 6),
-(5, 1, 6, 4, 1, '2014-09-05 22:01:00', '2014-09-05 22:13:00', '2014-09-05 22:01:17', 6, '2014-09-05 22:13:10', 6),
-(6, 1, 6, 6, 1, '2014-09-05 22:01:00', '2014-09-05 22:12:00', '2014-09-05 22:01:45', 6, '2014-09-05 22:12:56', 6),
-(7, 2, 6, 5, 1, '2014-09-05 23:31:00', '2014-09-06 00:02:00', '2014-09-05 23:31:55', 2, '2014-09-06 00:02:27', 2),
-(8, 2, 6, 4, 1, '2014-09-06 00:44:00', '2014-09-06 01:34:00', '2014-09-06 00:45:20', 2, '2014-09-06 01:34:54', 5),
-(9, 2, 6, 8, 1, '2014-09-06 00:45:00', '2014-09-06 01:36:00', '2014-09-06 00:46:18', 2, '2014-09-06 01:36:19', 5),
-(10, 2, 6, 6, 1, '2014-09-06 01:01:00', '2014-09-06 01:35:00', '2014-09-06 01:01:40', 5, '2014-09-06 01:35:32', 5),
-(11, 3, 6, 5, 1, '2014-09-06 01:03:00', '2014-09-06 10:22:00', '2014-09-06 01:03:48', 2, '2014-09-06 10:22:43', 6),
-(12, 2, 6, 9, 1, '2014-09-06 01:08:00', '2014-09-06 01:09:00', '2014-09-06 01:08:35', 5, '2014-09-06 01:10:50', 5),
-(13, 2, 6, 7, 1, '2014-09-06 01:31:00', '2014-09-06 01:52:00', '2014-09-06 01:31:36', 5, '2014-09-06 01:52:36', 5),
-(14, 3, 6, 7, 1, '2014-09-06 02:58:00', '2014-09-06 09:56:00', '2014-09-06 02:59:02', 2, '2014-09-06 09:56:17', 6),
-(15, 3, 6, 8, 1, '2014-09-06 02:59:00', '2014-09-06 10:05:00', '2014-09-06 03:00:35', 2, '2014-09-06 10:05:25', 6),
-(16, 3, 6, 9, 1, '2014-09-06 03:11:00', '2014-09-06 09:45:00', '2014-09-06 03:11:17', 2, '2014-09-06 09:45:34', 2),
-(17, 3, 6, 6, 1, '2014-09-06 03:25:00', '2014-09-06 09:36:00', '2014-09-06 03:25:48', 2, '2014-09-06 09:36:29', 2),
-(18, 3, 6, 4, 1, '2014-09-06 03:28:00', '2014-09-06 10:15:00', '2014-09-06 03:29:21', 2, '2014-09-06 10:15:38', 2),
-(19, 4, 6, 6, 1, '2014-09-06 10:58:00', '2014-09-06 10:59:00', '2014-09-06 10:59:28', 5, '2014-09-06 11:00:03', 5),
-(20, 4, 6, 7, 1, '2014-09-06 11:42:00', '2014-09-06 12:05:00', '2014-09-06 11:44:21', 5, '2014-09-06 12:05:59', 5),
-(21, 4, 6, 5, 1, '2014-09-06 11:54:00', '2014-09-06 12:19:00', '2014-09-06 11:55:14', 5, '2014-09-06 12:19:16', 5),
-(22, 4, 6, 4, 1, '2014-09-06 11:59:00', '2014-09-06 12:21:00', '2014-09-06 11:59:25', 5, '2014-09-06 12:21:28', 5),
-(23, 4, 6, 8, 1, '2014-09-06 12:20:00', '2014-09-06 13:09:00', '2014-09-06 12:20:23', 5, '2014-09-06 13:09:55', 5),
-(24, 4, 6, 9, 1, '2014-09-06 12:45:00', '2014-09-06 12:55:00', '2014-09-06 12:45:37', 5, '2014-09-06 12:55:46', 5),
-(25, 5, 6, 6, 1, '2014-09-06 15:47:00', '2014-09-06 16:28:00', '2014-09-06 15:48:22', 2, '2014-09-06 16:28:26', 5),
-(26, 5, 6, 4, 1, '2014-09-06 16:21:00', '2014-09-06 17:15:00', '2014-09-06 16:21:48', 2, '2014-09-06 17:16:06', 6),
-(27, 5, 6, 5, 1, '2014-09-06 17:18:00', '2014-09-06 18:03:00', '2014-09-06 17:18:51', 6, '2014-09-06 18:03:58', 5),
-(28, 5, 6, 7, 1, '2014-09-06 18:43:00', '2014-09-06 18:44:00', '2014-09-06 18:43:57', 4, '2014-09-06 18:44:20', 4),
-(29, 5, 6, 9, 1, '2014-09-06 19:07:00', '2014-09-06 19:09:00', '2014-09-06 19:07:55', 6, '2014-09-06 19:09:41', 6),
-(30, 8, 6, 8, 1, '2014-09-06 20:17:00', '2014-09-06 21:15:00', '2014-09-06 20:17:51', 4, '2014-09-06 21:15:37', 4),
-(31, 8, 6, 4, 1, '2014-09-06 20:18:00', '2014-09-06 21:34:00', '2014-09-06 20:19:02', 4, '2014-09-06 21:34:54', 4),
-(32, 8, 6, 5, 1, '2014-09-06 20:19:00', '2014-09-06 21:12:00', '2014-09-06 20:20:39', 4, '2014-09-06 21:12:52', 4),
-(33, 8, 6, 7, 1, '2014-09-06 21:42:00', NULL, '2014-09-06 21:43:59', 2, '2014-09-06 21:43:59', 2),
-(34, 8, 6, 6, 1, '2014-09-06 22:05:00', '2014-09-06 22:47:00', '2014-09-06 22:06:34', 2, '2014-09-06 22:47:58', 5),
-(35, 8, 6, 9, 1, '2014-09-06 22:47:00', '2014-09-06 22:48:00', '2014-09-06 22:47:32', 5, '2014-09-06 22:48:23', 5),
-(36, 6, 6, 5, 1, '2014-09-06 23:14:00', NULL, '2014-09-06 23:14:55', 2, '2014-09-06 23:14:55', 2),
-(37, 6, 6, 8, 1, '2014-09-06 23:25:00', NULL, '2014-09-06 23:25:41', 2, '2014-09-06 23:25:41', 2),
-(38, 6, 6, 4, 1, '2014-09-07 00:04:00', NULL, '2014-09-07 00:04:50', 6, '2014-09-07 00:04:50', 6),
-(39, 6, 6, 7, 1, '2014-09-07 00:23:00', NULL, '2014-09-07 00:24:10', 2, '2014-09-07 00:24:10', 2),
-(40, 6, 6, 9, 1, '2014-09-07 02:03:00', NULL, '2014-09-07 02:04:43', 4, '2014-09-07 02:04:43', 4);
+--(1, 1, 6, 5, 1, '2014-09-05 20:47:00', '2014-09-05 20:55:00', '2014-09-05 20:47:54', 6, '2014-09-05 20:50:46', 6),
+--(2, 1, 6, 8, 1, '2014-09-05 20:55:00', '2014-09-05 20:57:00', '2014-09-05 20:55:34', 6, '2014-09-05 20:57:48', 6),
+--(3, 1, 6, 7, 1, '2014-09-05 21:38:00', '2014-09-05 22:05:00', '2014-09-05 21:38:56', 6, '2014-09-05 22:05:59', 6),
+--(4, 1, 6, 9, 1, '2014-09-05 21:40:00', '2014-09-05 21:46:00', '2014-09-05 21:40:43', 6, '2014-09-05 21:53:58', 6),
+--(5, 1, 6, 4, 1, '2014-09-05 22:01:00', '2014-09-05 22:13:00', '2014-09-05 22:01:17', 6, '2014-09-05 22:13:10', 6),
+--(6, 1, 6, 6, 1, '2014-09-05 22:01:00', '2014-09-05 22:12:00', '2014-09-05 22:01:45', 6, '2014-09-05 22:12:56', 6);
 
 -- --------------------------------------------------------
 

--

INSERT INTO `tbl_qr_check` (`qr_check_ID`, `qr_ID`, `event_ID`, `group_ID`, `create_time`, `create_user_ID`, `update_time`, `update_user_ID`) VALUES
(12, 29, 6, 6, '2014-08-31 14:03:05', 26, '2014-08-31 14:03:05', 26),
(13, 29, 6, 8, '2014-08-31 14:06:44', 30, '2014-08-31 14:06:44', 30),
(15, 29, 6, 5, '2014-08-31 14:19:03', 25, '2014-08-31 14:19:03', 25),
(16, 29, 6, 4, '2014-08-31 14:30:00', 17, '2014-08-31 14:30:00', 17),
(18, 29, 6, 7, '2014-08-31 15:22:24', 20, '2014-08-31 15:22:24', 20),
(19, 29, 6, 9, '2014-09-02 13:35:47', 35, '2014-09-02 13:35:47', 35),
(20, 5, 6, 5, '2014-09-05 23:05:34', 25, '2014-09-05 23:05:34', 25),
(21, 6, 6, 5, '2014-09-05 23:18:41', 25, '2014-09-05 23:18:41', 25),
(22, 5, 6, 4, '2014-09-05 23:48:06', 32, '2014-09-05 23:48:06', 32),
(23, 5, 6, 6, '2014-09-05 23:53:05', 27, '2014-09-05 23:53:05', 27),
(24, 5, 6, 8, '2014-09-05 23:54:03', 37, '2014-09-05 23:54:03', 37),
(25, 5, 6, 7, '2014-09-05 23:55:47', 19, '2014-09-05 23:55:47', 19),
(26, 6, 6, 6, '2014-09-06 00:19:37', 27, '2014-09-06 00:19:37', 27),
(27, 6, 6, 8, '2014-09-06 00:37:51', 37, '2014-09-06 00:37:51', 37),
(28, 13, 6, 6, '2014-09-06 09:43:02', 27, '2014-09-06 09:43:02', 27),
(29, 14, 6, 9, '2014-09-06 10:11:56', 35, '2014-09-06 10:11:56', 35),
(30, 13, 6, 7, '2014-09-06 10:12:00', 20, '2014-09-06 10:12:00', 20),
(31, 14, 6, 6, '2014-09-06 10:22:19', 27, '2014-09-06 10:22:19', 27),
(32, 14, 6, 7, '2014-09-06 10:31:14', 19, '2014-09-06 10:31:14', 19),
(33, 15, 6, 6, '2014-09-06 10:33:34', 27, '2014-09-06 10:33:34', 27),
(34, 14, 6, 5, '2014-09-06 10:46:56', 25, '2014-09-06 10:46:56', 25),
(35, 16, 6, 6, '2014-09-06 11:01:43', 27, '2014-09-06 11:01:43', 27),
(36, 16, 6, 9, '2014-09-06 11:02:27', 35, '2014-09-06 11:02:27', 35),
(37, 15, 6, 5, '2014-09-06 11:27:23', 25, '2014-09-06 11:27:23', 25),
(38, 16, 6, 7, '2014-09-06 11:41:38', 19, '2014-09-06 11:41:38', 19),
(39, 15, 6, 4, '2014-09-06 11:42:02', 32, '2014-09-06 11:42:02', 32),
(40, 15, 6, 8, '2014-09-06 11:49:35', 37, '2014-09-06 11:49:35', 37),
(41, 16, 6, 5, '2014-09-06 11:52:56', 25, '2014-09-06 11:52:56', 25),
(42, 16, 6, 4, '2014-09-06 11:57:31', 32, '2014-09-06 11:57:31', 32),
(43, 17, 6, 9, '2014-09-06 12:10:28', 35, '2014-09-06 12:10:28', 35),
(44, 16, 6, 8, '2014-09-06 12:13:16', 37, '2014-09-06 12:13:16', 37),
(45, 17, 6, 7, '2014-09-06 12:16:20', 19, '2014-09-06 12:16:20', 19),
(46, 17, 6, 5, '2014-09-06 12:25:45', 25, '2014-09-06 12:25:45', 25),
(47, 17, 6, 4, '2014-09-06 12:32:52', 32, '2014-09-06 12:32:52', 32),
(48, 17, 6, 8, '2014-09-06 13:21:40', 37, '2014-09-06 13:21:40', 37),
(49, 18, 6, 5, '2014-09-06 13:28:25', 25, '2014-09-06 13:28:25', 25),
(50, 18, 6, 4, '2014-09-06 13:30:45', 17, '2014-09-06 13:30:45', 17),
(51, 19, 6, 5, '2014-09-06 13:52:46', 25, '2014-09-06 13:52:46', 25),
(52, 18, 6, 8, '2014-09-06 14:04:43', 37, '2014-09-06 14:04:43', 37),
(53, 20, 6, 5, '2014-09-06 14:06:32', 25, '2014-09-06 14:06:32', 25),
(54, 19, 6, 4, '2014-09-06 14:20:02', 32, '2014-09-06 14:20:02', 32),
(55, 19, 6, 7, '2014-09-06 14:32:22', 19, '2014-09-06 14:32:22', 19),
(56, 20, 6, 4, '2014-09-06 14:43:30', 32, '2014-09-06 14:43:30', 32),
(57, 21, 6, 5, '2014-09-06 14:58:34', 25, '2014-09-06 14:58:34', 25),
(58, 19, 6, 8, '2014-09-06 15:12:00', 37, '2014-09-06 15:12:00', 37),
(59, 21, 6, 4, '2014-09-06 15:35:15', 32, '2014-09-06 15:35:15', 32),
(60, 20, 6, 8, '2014-09-06 15:43:45', 37, '2014-09-06 15:43:45', 37),
(61, 21, 6, 6, '2014-09-06 16:01:15', 27, '2014-09-06 16:01:15', 27),
(62, 20, 6, 6, '2014-09-06 16:01:33', 27, '2014-09-06 16:01:33', 27),
(63, 18, 6, 6, '2014-09-06 16:01:45', 27, '2014-09-06 16:01:45', 27),
(64, 17, 6, 6, '2014-09-06 16:02:04', 27, '2014-09-06 16:02:04', 27),
(65, 22, 6, 4, '2014-09-06 16:19:42', 32, '2014-09-06 16:19:42', 32),
(66, 21, 6, 9, '2014-09-06 16:59:53', 35, '2014-09-06 16:59:53', 35),
(67, 23, 6, 6, '2014-09-06 17:03:56', 27, '2014-09-06 17:03:56', 27),
(68, 23, 6, 5, '2014-09-06 18:35:41', 25, '2014-09-06 18:35:41', 25),
(69, 23, 6, 4, '2014-09-06 18:52:35', 17, '2014-09-06 18:52:35', 17),
(70, 24, 6, 4, '2014-09-06 19:22:30', 32, '2014-09-06 19:22:30', 32),
(71, 23, 6, 7, '2014-09-06 19:22:47', 20, '2014-09-06 19:22:47', 20),
(72, 24, 6, 5, '2014-09-06 19:32:08', 25, '2014-09-06 19:32:08', 25),
(73, 22, 6, 9, '2014-09-06 19:34:02', 35, '2014-09-06 19:34:02', 35),
(74, 24, 6, 7, '2014-09-06 20:05:52', 20, '2014-09-06 20:05:52', 20),
(75, 25, 6, 4, '2014-09-06 20:14:44', 32, '2014-09-06 20:14:44', 32),
(76, 24, 6, 6, '2014-09-06 20:15:46', 27, '2014-09-06 20:15:46', 27),
(77, 23, 6, 9, '2014-09-06 20:21:43', 35, '2014-09-06 20:21:43', 35),
(78, 25, 6, 5, '2014-09-06 20:23:24', 25, '2014-09-06 20:23:24', 25),
(79, 26, 6, 4, '2014-09-06 22:01:21', 17, '2014-09-06 22:01:21', 17),
(80, 26, 6, 5, '2014-09-06 22:11:34', 25, '2014-09-06 22:11:34', 25),
(81, 26, 6, 7, '2014-09-06 22:41:35', 19, '2014-09-06 22:41:35', 19),
(82, 27, 6, 4, '2014-09-06 22:49:40', 17, '2014-09-06 22:49:40', 17),
(83, 28, 6, 5, '2014-09-06 23:03:48', 25, '2014-09-06 23:03:48', 25),
(84, 28, 6, 4, '2014-09-06 23:57:42', 17, '2014-09-06 23:57:42', 17),
(85, 27, 6, 9, '2014-09-07 00:51:50', 35, '2014-09-07 00:51:50', 35);

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


--

INSERT INTO `tbl_open_vragen_antwoorden` (`open_vragen_antwoorden_ID`, `open_vragen_ID`, `event_ID`, `group_ID`, `antwoord_spelers`, `checked`, `correct`, `create_time`, `create_user_ID`, `update_time`, `update_user_ID`) VALUES
--(3, 39, 6, 5, 'Rijksdriehoekscoördinaten', 1, 1, '2014-08-31 13:46:28', 25, '2014-08-31 13:48:55', 2),
--(4, 40, 6, 5, ' ''de spits van de Onze Lieve Vrouwetoren (''''Lange Jan'''') in Amersfoort. Met coördinaten x = 155 000,  y = 463 000.''', 1, 1, '2014-08-31 13:49:10', 25, '2014-08-31 13:50:22', 2),
--(5, 39, 6, 6, 'Rijksdriehoekscoördinaten', 1, 1, '2014-08-31 14:19:14', 26, '2014-08-31 14:19:31', 2),
--(6, 40, 6, 6, ' ''Het centrale punt van het stelsel is de spits van de Onze Lieve Vrouwetoren (''''Lange Jan'''') in Amersfoort. Dit punt heeft de coördinaten x = 155 000,  y = 463 000.''', 1, 1, '2014-08-31 14:24:03', 26, '2014-08-31 14:28:43', 2),
--(7, 39, 6, 4, 'rijksdriehoekscoördinaten', 1, 1, '2014-08-31 14:36:25', 17, '2014-08-31 15:35:21', 5),
--(8, 40, 6, 4, 'Onze Lieve Vrouwetoren Amersfoort', 1, 1, '2014-08-31 14:37:22', 17, '2014-08-31 15:35:24', 5),
--(9, 39, 6, 8, 'Rijksdriehoekscoördinaten', 1, 1, '2014-08-31 14:56:36', 30, '2014-08-31 15:35:03', 5);

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

