DELETE FROM `e4wbo_conlucra_game_game` WHERE `id`=15;
INSERT INTO `e4wbo_conlucra_game_game` (`id`, `owner_id`, `description`, `published`, `start_datetime`, `end_datetime`) VALUES
(15, 211, 'Demo projects for nocodebots.co.uk', 0, '2000-04-01 12:18:13', '2100-05-20 12:18:26');

DELETE FROM `e4wbo_conlucra_game_level` WHERE `id`=999;
INSERT INTO `e4wbo_conlucra_game_level` (`id`, `game_id`, `type_id`, `start_block`, `debug`, `description`, `published`, `graph_challenges`, `start_datetime`, `end_datetime`, `shortcode`, `ordering`) VALUES
(999, 15, 2, 427, 0, 'Child benefit form filler', 1, '{\"graph_challenges\":[{\"id\":427,\"position\":{\"x\":110,\"y\":250}},{\"id\":428,\"position\":{\"x\":110,\"y\":380}},{\"id\":433,\"position\":{\"x\":420,\"y\":380}},{\"id\":429,\"position\":{\"x\":730,\"y\":380}},{\"id\":435,\"position\":{\"x\":1010,\"y\":380}},{\"id\":430,\"position\":{\"x\":1010,\"y\":510}},{\"id\":434,\"position\":{\"x\":740,\"y\":510}},{\"id\":436,\"position\":{\"x\":430,\"y\":510}},{\"id\":431,\"position\":{\"x\":110,\"y\":510}},{\"id\":432,\"position\":{\"x\":110,\"y\":660}}]}', '2000-04-01 12:18:13', '2100-05-20 12:18:26', 'CHILDBENFILLER', 3);

DELETE FROM `e4wbo_conlucra_game_challenge` WHERE `level_id`=999;
INSERT INTO `e4wbo_conlucra_game_challenge` (`id`, `level_id`, `type_id`, `options`, `description`, `question`, `hint`, `points`, `graph_challenges`, `start_datetime`, `end_datetime`, `shortcode`, `ordering`) VALUES
(427, 999, 80, '', 'Hi let\'s fill a form', '<p>Hi I\'m Freddie the form-filler bot!</p>\r\n<p>I can help you fill out your application for Child Benefit.</p>', '', 10, '{\"graph_challenges\":[{\"id\":427,\"position\":{\"x\":550,\"y\":75}},{\"id\":428,\"position\":{\"x\":1000,\"y\":150}}]}', '2000-04-01 12:18:13', '2100-05-20 12:18:26', '', 1),
(428, 999, 10, '', 'What is your first name?', '<p>What\'s your first name?</p>', '', 10, '{\"graph_challenges\":[{\"id\":0,\"position\":{\"x\":550,\"y\":75}}]}', '2000-04-01 12:18:13', '2100-05-20 12:18:26', 'FIRST_NAME', 2),
(429, 999, 10, '', 'And what is your last name?', '<p>Thanks *|FIRST_NAME|*, and what is your last name?</p>', '', 10, '{\"graph_challenges\":[{\"id\":0,\"position\":{\"x\":550,\"y\":75}}]}', '2000-04-01 12:18:13', '2100-05-20 12:18:26', 'LAST_NAME', 4),
(430, 999, 10, '', 'What is your nationality?', '<p>What is your nationality?</p>', '', 10, '{\"graph_challenges\":[{\"id\":430,\"position\":{\"x\":550,\"y\":75}},{\"id\":435,\"position\":{\"x\":550,\"y\":75}},{\"id\":434,\"position\":{\"x\":1000,\"y\":150}}]}', '2000-04-01 12:18:13', '2100-05-20 12:18:26', 'NATIONALITY', 6),
(431, 999, 120, '4', 'Here\'s your form', '<p>Thanks *|FIRST_NAME|*.</p>\r\n<p>To download your form <a href=\"*|FILLED_FORM|*\" target=\"_blank\" rel=\"noopener noreferrer\">please click here</a>.</p>', '', 10, '{\"graph_challenges\":[{\"id\":431,\"position\":{\"x\":960,\"y\":310}},{\"id\":434,\"position\":{\"x\":550,\"y\":75}},{\"id\":432,\"position\":{\"x\":960,\"y\":530}}]}', '2000-04-01 12:18:13', '2100-05-20 12:18:26', 'FILLED_FORM', 9),
(433, 999, 10, '', 'What\'s your title (e.g. Mrs, Miss, Ms, Mr or Dr) ?', '<p>What\'s your title (e.g. Mrs, Miss, Ms, Mr or Dr) ?</p>', '', 10, '{\"graph_challenges\":[{\"id\":0,\"position\":{\"x\":550,\"y\":75}}]}', '2000-04-01 12:18:13', '2100-05-20 12:18:26', 'TITLE', 3),
(434, 999, 10, '', 'What country do you usually live in?', '<p>What country do you usually live in?</p>', '', 10, '{\"graph_challenges\":[{\"id\":434,\"position\":{\"x\":550,\"y\":75}},{\"id\":430,\"position\":{\"x\":550,\"y\":75}},{\"id\":431,\"position\":{\"x\":1000,\"y\":150}}]}', '2000-04-01 12:18:13', '2100-05-20 12:18:26', 'USUAL_COUNTRY', 7),
(435, 999, 10, '', 'What\'s the best phone number to contact you on?', '<p>What\'s the best phone number to contact you on?</p>', '', 10, '{\"graph_challenges\":[{\"id\":0,\"position\":{\"x\":550,\"y\":75}}]}', '2000-04-01 12:18:13', '2100-05-20 12:18:26', 'PHONE', 5),
(436, 999, 55, '', 'And finally, what is your date of birth?', '<p>And finally, what is your date of birth?</p>', '', 10, '{\"graph_challenges\":[{\"id\":0,\"position\":{\"x\":550,\"y\":75}}]}', '2000-04-01 12:18:13', '2100-05-20 12:18:26', 'DOB', 8);

INSERT INTO `e4wbo_conlucra_game_rule` (`id`, `challenge_id`, `type_id`, `min_value`, `max_value`, `min_date`, `max_date`, `value`, `next_id`, `ordering`) VALUES
(518, 343, 0, 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '', 344, 1),
(582, 427, 0, 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '', 428, 1),
(583, 428, 0, 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '', 433, 1),
(584, 429, 0, 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '', 435, 1),
(585, 430, 0, 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '', 434, 1),
(587, 433, 0, 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '', 429, 1),
(589, 435, 0, 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '', 430, 1),
(590, 436, 0, 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '', 431, 1);
