INSERT INTO `ima_game` (`Game_ID`, `Name`, `Resource_URL`, `Executable`, `Description`,`Version`,  `Display_Order`, `Active`, `Last_Edit`) VALUES
(56, 'The great obstacle course', '/images/games/gamefullbody1.png', 'GameJumpingJacks', 'Users are asked to move their arms and legs to avoid obstacles and get all light blue coins.',1,10, 1, CURRENT_TIMESTAMP),
(57, 'Jumping jack', '/images/games/gamefullbody2.png', 'GameJumpingJacks2', 'Users are asked move their arms and legs accordingly to the direction of the arrows inside the coins.',1,10, 1, CURRENT_TIMESTAMP),
(58, 'Run, run... RUUUN!', '/images/games/gamehighknees.png', 'GameHighKnees', 'Users are asked to run in place lifting their knees the higher they can.',1,10, 1, CURRENT_TIMESTAMP);

INSERT INTO `ima_game_device` (`Game_ID`, `Device_ID`, `Active`, `Last_Edit`) VALUES
(56, 1, 1, CURRENT_TIMESTAMP),
(56, 6, 1, CURRENT_TIMESTAMP),
(57, 1, 1, CURRENT_TIMESTAMP),
(57, 6, 1, CURRENT_TIMESTAMP),
(58, 1, 1, CURRENT_TIMESTAMP),
(58, 6, 1, CURRENT_TIMESTAMP);

INSERT INTO `ima_game_dependency` (`Game_ID`, `Resource_ID`, `Order`, `Active`, `Last_Edit`) VALUES
(56, 1, 1, 1, CURRENT_TIMESTAMP),
(56, 2, 2, 1, CURRENT_TIMESTAMP),
(56, 3, 3, 1, CURRENT_TIMESTAMP),
(56, 11, 4, 1, CURRENT_TIMESTAMP),
(56, 10, 4, 1, CURRENT_TIMESTAMP),

(57, 1, 1, 1, CURRENT_TIMESTAMP),
(57, 2, 2, 1, CURRENT_TIMESTAMP),
(57, 3, 3, 1, CURRENT_TIMESTAMP),
(57, 11, 4, 1, CURRENT_TIMESTAMP),
(57, 10, 4, 1, CURRENT_TIMESTAMP),

(58, 1, 1, 1, CURRENT_TIMESTAMP),
(58, 2, 2, 1, CURRENT_TIMESTAMP),
(58, 3, 3, 1, CURRENT_TIMESTAMP),
(58, 11, 4, 1, CURRENT_TIMESTAMP),
(58, 10, 4, 1, CURRENT_TIMESTAMP);

INSERT INTO `ima_game_parameter_association` (`Game_ID`, `Parameter_ID`, `Optional_Parameter`, `Active`, `Last_Edit`) VALUES
(56, 1, 0, 1,CURRENT_TIMESTAMP),
(56, 104, 0, 1,CURRENT_TIMESTAMP),
(56, 105, 0, 1,CURRENT_TIMESTAMP),
(56, 141, 0, 1,CURRENT_TIMESTAMP),
(56, 142, 0, 1,CURRENT_TIMESTAMP),
(56, 143, 0, 1,CURRENT_TIMESTAMP),
(56, 144, 0, 1,CURRENT_TIMESTAMP),

(57, 1, 0, 1,CURRENT_TIMESTAMP),
(57, 145, 0, 1,CURRENT_TIMESTAMP),
(57, 146, 0, 1,CURRENT_TIMESTAMP),

(58, 1, 0, 1,CURRENT_TIMESTAMP),
(58, 145, 0, 1,CURRENT_TIMESTAMP),
(42, 147, 0, 1,CURRENT_TIMESTAMP),

(5, 89, 0, 1, CURRENT_TIMESTAMP),
(5, 90, 0, 1, CURRENT_TIMESTAMP);

DELETE FROM `ima_game_parameter_association` WHERE Game_ID=5 and Parameter_ID in (12,85);

INSERT INTO `ima_game_parameter` (`Parameter_ID`, `Device_ID`, `Name`, `Label`, `Description`, `Default`, `Order`, `Levelable`, `Active`) VALUES
(141, NULL, 'distractors', 'percentage proportion of distractors', 'Defines the percentage of distractors there should be in proportion to the total number of objects.', 0, 0, 1, 1),
(142, NULL, 'laterals', 'percentage proportion of feet elements', 'Defines the percentage of feet elements.', 0, 0, 1, 1),
(143, NULL, 'doubles', 'percentage proportion of double elements', 'Defines the percentage of double elements, i.e. elements that shall be taken with two limbs contemporary.', 0, 0, 1, 1),
(144, NULL, 'rhythm', 'rhythm of the game', 'Defines the rhythm of the game, if random the elements are inserted randomly.', 0, 0, 1, 1),
(145, NULL, 'speed', 'Speed', 'Defines the target speed of the movement to perform.', 0, 0, 1, 1),
(146, NULL, 'rhythm', 'rhythm of the game', 'Defines in which order the limb of the patient shall move to play the game.', 0, 0, 1, 1),
(147, NULL, 'middlestep', 'enable central position', 'Enables the obstacles that need to be passed through while keeping an intermediate position between sitted and standing.', 0, 0, 1, 1);


INSERT INTO `ima_game_parameter_value` (`Parameter_ID`, `Value`, `Label`, `Description`, `Active`, `Last_Edit`, `Default`, `Order`) VALUES
(141, 'none','none',NULL, 1, CURRENT_TIMESTAMP, 0, 0),
(141, 'few','few',NULL, 1, CURRENT_TIMESTAMP, 1, 1),
(141, 'some','some',NULL, 1, CURRENT_TIMESTAMP, 0, 2),
(141, 'many','many',NULL, 1, CURRENT_TIMESTAMP, 0, 3),
(141, 'all','all',NULL, 1, CURRENT_TIMESTAMP, 0, 4),

(142, 'none', 'none', NULL, 1, CURRENT_TIMESTAMP, 0, 1),
(142, 'few', 'few', NULL, 1, CURRENT_TIMESTAMP, 0, 2),
(142, 'some', 'some', NULL, 1, CURRENT_TIMESTAMP, 1, 3),
(142, 'many', 'many', NULL, 1, CURRENT_TIMESTAMP, 0, 4),
(142, 'all', 'all', NULL, 0, CURRENT_TIMESTAMP, 0, 5),

(143, 'none', 'none', NULL, 1, CURRENT_TIMESTAMP, 0, 1),
(143, 'few', 'few', NULL, 1, CURRENT_TIMESTAMP, 0, 2),
(143, 'some', 'some', NULL, 1, CURRENT_TIMESTAMP, 1, 3),
(143, 'many', 'many', NULL, 1, CURRENT_TIMESTAMP, 0, 4),
(143, 'all', 'all', NULL, 0, CURRENT_TIMESTAMP, 0, 5),

(144, 'random', 'random', NULL, 1, CURRENT_TIMESTAMP, 0, 1),
(144, 'summer', 'summer', NULL, 1, CURRENT_TIMESTAMP, 1, 2),

(145, 'very-slow', 'very slow', NULL, 1, CURRENT_TIMESTAMP, 0, 1),
(145, 'slow', 'slow', NULL, 1, CURRENT_TIMESTAMP, 0, 2),
(145, 'normal', 'normal', NULL, 1, CURRENT_TIMESTAMP, 1, 3),
(145, 'fast', 'fast', NULL, 1, CURRENT_TIMESTAMP, 0, 4),
(145, 'very-fast', 'very fast', NULL, 1, CURRENT_TIMESTAMP, 0, 5),

(146, 'all', 'all', NULL, 1, CURRENT_TIMESTAMP, 1, 1),
(146, 'clockwise', 'clockwise', NULL, 1, CURRENT_TIMESTAMP, 0, 2),
(146, 'counterclockwise', 'counterclockwise', NULL, 1, CURRENT_TIMESTAMP, 0, 3),
(146, 'side', 'side', NULL, 1, CURRENT_TIMESTAMP, 0, 4),
(147, 'no', 'no', NULL, 1, CURRENT_TIMESTAMP, 1, 1),
(147, 'yes', 'yes', NULL, 1, CURRENT_TIMESTAMP, 0, 2);

INSERT INTO `cb_leaderboard` (`Id`, `Title`, `Description`, `UniqueRecords`, `ValueType`, `OrderType`, `AllowAnonymous`) VALUES
(54, 'The great obstacle course', 'Leaderboard for The great obstacle course', 0, 0, 0, 0),
(55, 'Jumping Jack', 'Leaderboard for Jumping Jack', 0, 0, 0, 0),
(56, 'Run, puppet, RUN!', 'Leaderboard for Run, puppet, RUN!', 0, 0, 0, 0);

INSERT INTO `ima_game_output`(`Id`,`Game_ID`, `Name`, `Parameter`,`Description`) VALUES 
(194, 56,'Score','{final-score}','The score of the play.'),
(195, 56,'Correct','{correct}/({input-parameters.duration}/{60})','Total coins taken by minute.'),
(196, 56,'Wrong','{wrong}/({input-parameters.duration}/{60})','Total obstacles collided by minute.'),
(197, 56,'Accuracy','({correct}/({missed-correct}+{correct})/{2})+({avoided-wrong}/({avoided-wrong}+{wrong})/{2})','Accuracy of the play.'),
(198, 57,'Score','{final-score}','The score of the play.'),
(199, 57,'Correct','{correct}/({input-parameters.duration}/{60})','Coins taken.'),
(200, 58,'Score','{final-score}','The score of the play.'),
(201, 58,'Correct','{correct}/({input-parameters.duration}/{60})','Coins taken by minute.'),
(202, 58,'Wrong','{hit}/({input-parameters.duration}/{60})','Hit time by minute.');

INSERT INTO `ima_chart_game_template` (`Chart_Template_ID`, `Game_ID`) VALUES
(  3,56),
(  4,56),
(  7,56),
( 44,56),
(269,56),
(270,56),
(275,56),
(311,56),

(324,56),
(335,56),
(336,56),
(337,56),
(338,56),
(339,56),
(340,56),
(341,56),
(342,56),

(  3,57),
(  4,57),
(  7,57),
( 44,57),
(269,57),
(270,57),
(275,57),
(343,57),
(344,57),
(345,57),

(  3,58),
(  4,58),
(  7,58),
( 44,58),
(269,58),
(270,58),
(275,58),
(343,58),
(346,58),
(347,58),

(348,5),
(349,5),
(350,5),
(351,5),
(352,5),
(353,5);


INSERT INTO `ima_chart_template` (`Chart_Template_ID`, `Type_ID`, `Name`, `Title`, `Resource_URL`, `Description`, `Session_Bound`, `Optional`, `Display_Order`, `Active`, `Last_Edit`) VALUES
(335, 5, 'correct-obj', 'Correct objects', NULL, 'This chart shows correct objects taken by the player.', 1, 1, 0, 1, CURRENT_TIMESTAMP),
(336, 10, 'correct-obj-pos', 'Correct objects by position', NULL, 'This chart shows how many correct objects were taken by the player by position.', 1, 1, 0, 1, CURRENT_TIMESTAMP),
(337, 10, 'wrong-obj-pos', 'Obstacle by position', NULL, 'This chart shows how many obstacle were avoided by the player by obstacle position.', 1, 1, 0, 1, CURRENT_TIMESTAMP),
(338, 11, 'globalSkifallDifficulty', 'Configuration parameters changes', NULL, 'For each session, this chart shows  possible configuration parameters changes compared to previous session configuration.', 0, 1, 0, 1, CURRENT_TIMESTAMP),
(341, 7, 'correct-wrong', 'Objects over time', NULL, 'This chart shows how many correct objects were taken and missed and how many obstacles were taken and avoided every 5 seconds', 1, 0, 0, 1, CURRENT_TIMESTAMP),
(342, 7, 'correct-obj-global', 'Correct objects', NULL, 'This chart shows correct objects taken by the player.', 0, 1, 0, 1, CURRENT_TIMESTAMP),
(343, 4, 'correct', 'Coins', NULL, 'This chart shows how many coins were taken by the player.', 1, 1, 0, 1, CURRENT_TIMESTAMP),
(344, 7, 'correct-global', 'Coins', NULL, 'This chart shows how many coins were taken by the player.', 0, 1, 0, 1, CURRENT_TIMESTAMP),
(345, 7, 'correct-line', 'Coins over time', NULL, 'This chart shows how many coins were taken every 5 seconds', 1, 0, 0, 1, CURRENT_TIMESTAMP),
(346, 7, 'correct-hit-global', 'Coins and hit', NULL, 'This chart shows how many coins were taken by the player.', 0, 1, 0, 1, CURRENT_TIMESTAMP),
(347, 7, 'correct-hit-line', 'Coins and hit over time', NULL, 'This chart shows how many coins were taken every 5 seconds', 1, 0, 0, 1, CURRENT_TIMESTAMP),

(348, 5, 'correct-cans-two-hands', 'Placed objects', NULL, 'This chart shows how many correct and wrong objects were placed in % and in absolute value in brackets.', 1, 0, 0, 1, CURRENT_TIMESTAMP),
(349, 10, 'correctcans-two-hands-left', 'Left hand placed objects per quadrant', NULL, 'This chart shows how many correct and wrong objects were placed in absolute value in every quadrant', 1, 1, 0, 1, CURRENT_TIMESTAMP),
(350, 10, 'correctcans-two-hands-right', 'Right hand placed objects per quadrant', NULL, 'This chart shows how many correct and wrong objects were placed in absolute value in every quadrant', 1, 1, 0, 1, CURRENT_TIMESTAMP),
(351, 7, 'globalcorrect-cans-two-hands', 'Placed objects per hand', NULL, 'This chart shows how many correct and wrong objects were placed per session.', 0, 0, 0, 1, CURRENT_TIMESTAMP),
(352, 7, 'globalcorrectcans-two-hands', 'Correctly placed objects per quadrant per hand', NULL, 'This chart shows how many correct objects were placed per quadrant per session.', 0, 1, 0, 1,CURRENT_TIMESTAMP),
(353, 7, 'globalwrongcans-two-hands', 'Wrongly placed objects per quadrant per hand', NULL, 'This chart shows how many wrong objects were placed per quadrant per session.', 0, 1, 0, 1, CURRENT_TIMESTAMP);

INSERT INTO `ima_chart_template` (`Chart_Template_ID`, `Type_ID`, `Name`, `Title`, `Resource_URL`, `Description`, `Session_Bound`, `User_Bound`, `Optional`, `Display_Order`, `Active`, `Last_Edit`) VALUES
(339, 1, 'accuracygamejj', 'Accuracy', NULL, '', 0, 0, 1, 0, 1, CURRENT_TIMESTAMP),
(340, 7, 'monthlyaccuracygamejj', 'Accuracy monthly', NULL, '', 0, 0, 1, 0, 1, CURRENT_TIMESTAMP);


INSERT INTO `ima_chart_template_data` (`Chart_Template_ID`, `Name`, `Source`, `Data_Order`, `Active`, `Last_Edit`) VALUES
(335, 'Correct', '{correct}', 1, 1, CURRENT_TIMESTAMP),
(335, 'Missed', '{missed-correct}', 2, 1, CURRENT_TIMESTAMP),

(336, 'Correct Left High', '{correct-left-top}', 1, 1, CURRENT_TIMESTAMP),
(336, '[diff]Correct Left High', '{missed-correct-left-top}', 2, 1, CURRENT_TIMESTAMP),
(336, 'Correct Left Middle', '{correct-left-middle}', 3, 1, CURRENT_TIMESTAMP),
(336, '[diff]Correct Left Middle', '{missed-correct-left-middle}', 4, 1, CURRENT_TIMESTAMP),
(336, 'Correct Left Low', '{correct-left-bottom}', 5, 1, CURRENT_TIMESTAMP),
(336, '[diff]Correct Left Low', '{missed-correct-left-bottom}', 6, 1, CURRENT_TIMESTAMP),
(336, 'Correct Left Foot Far', '{correct-feet-left-far}', 7, 1, CURRENT_TIMESTAMP),
(336, '[diff]Correct Left Foot Far', '{missed-correct-feet-left-far}', 8, 1, CURRENT_TIMESTAMP),
(336, 'Correct Left Foot Near', '{correct-feet-left-near}', 9, 1, CURRENT_TIMESTAMP),
(336, '[diff]Correct Left Foot Near', '{missed-correct-feet-left-near}', 10, 1, CURRENT_TIMESTAMP),
(336, 'Correct Right High', '{correct-right-top}', 11, 1, CURRENT_TIMESTAMP),
(336, '[diff]Correct Right High', '{missed-correct-right-top}', 12, 1, CURRENT_TIMESTAMP),
(336, 'Correct Right Middle', '{correct-right-middle}', 13, 1, CURRENT_TIMESTAMP),
(336, '[diff]Correct Right Middle', '{missed-correct-right-middle}', 14, 1, CURRENT_TIMESTAMP),
(336, 'Correct Right Low', '{correct-right-bottom}', 15, 1, CURRENT_TIMESTAMP),
(336, '[diff]Correct Right Low', '{missed-correct-right-bottom}', 16, 1, CURRENT_TIMESTAMP),
(336, 'Correct Right Foot Far', '{correct-feet-right-far}', 17, 1, CURRENT_TIMESTAMP),
(336, '[diff]Correct Right Foot Far', '{missed-correct-feet-right-far}', 18, 1, CURRENT_TIMESTAMP),
(336, 'Correct Right Foot Near', '{correct-feet-right-near}', 19, 1, CURRENT_TIMESTAMP),
(336, '[diff]Correct Right Foot Near', '{missed-correct-feet-right-near}', 20, 1, CURRENT_TIMESTAMP),

(337, 'Wrong Left High', '{wrong-left-top}', 1, 1, CURRENT_TIMESTAMP),
(337, '[diff]Wrong Left High', '{avoided-wrong-top}', 2, 1, CURRENT_TIMESTAMP),
(337, 'Wrong Left Middle', '{wrong-left-middle}', 3, 1, CURRENT_TIMESTAMP),
(337, '[diff]Wrong Left Middle', '{avoided-wrong-middle}+{avoided-wrong-middle-left}', 4, 1, CURRENT_TIMESTAMP),
(337, 'Wrong Left Low', '{wrong-left-bottom}', 5, 1, CURRENT_TIMESTAMP),
(337, '[diff]Wrong Left Low', '{avoided-wrong-low}', 6, 1, CURRENT_TIMESTAMP),
(337, 'Wrong Left Foot Far', '{wrong-feet-left-far}', 7, 1, CURRENT_TIMESTAMP),
(337, '[diff]Wrong Left Foot Far', '{avoided-wrong-feet-left-far}', 8, 1, CURRENT_TIMESTAMP),
(337, 'Wrong Left Foot Near', '{wrong-feet-left-near}', 9, 1, CURRENT_TIMESTAMP),
(337, '[diff]Wrong Left Foot Near', '{avoided-wrong-feet-near}', 10, 1, CURRENT_TIMESTAMP),
(337, 'Wrong Right High', '{wrong-right-top}', 11, 1, CURRENT_TIMESTAMP),
(337, '[diff]Wrong Right High', '{avoided-wrong-top}', 12, 1, CURRENT_TIMESTAMP),
(337, 'Wrong Right Middle', '{wrong-right-middle}', 13, 1, CURRENT_TIMESTAMP),
(337, '[diff]Wrong Right Middle', '{avoided-wrong-middle}+{avoided-wrong-middle-right}', 14, 1, CURRENT_TIMESTAMP),
(337, 'Wrong Right Low', '{wrong-right-bottom}', 15, 1, CURRENT_TIMESTAMP),
(337, '[diff]Wrong Right Low', '{avoided-wrong-low}', 16, 1, CURRENT_TIMESTAMP),
(337, 'Wrong Right Foot Far', '{wrong-feet-right-far}', 17, 1, CURRENT_TIMESTAMP),
(337, '[diff]Wrong Right Foot Far', '{avoided-wrong-feet-far}', 18, 1, CURRENT_TIMESTAMP),
(337, 'Wrong Right Foot Near', '{wrong-feet-right-near}', 19, 1, CURRENT_TIMESTAMP),
(337, '[diff]Wrong Right Foot Near', '{avoided-wrong-feet-near}', 20, 1, CURRENT_TIMESTAMP),

(338, 'Distractors', '{input-parameters.distractors}', 2, 1, CURRENT_TIMESTAMP),
(338, 'Feet', '{input-parameters.laterals}', 3, 1, CURRENT_TIMESTAMP),
(338, 'Duration', '{input-parameters.duration}', 1, 1, CURRENT_TIMESTAMP),
(338, 'Density', '{input-parameters.density}', 7, 1, CURRENT_TIMESTAMP),
(338, 'Speed', '{input-parameters.speed}', 5, 1, CURRENT_TIMESTAMP),
(338, 'Doubles', '{input-parameters.doubles}', 5, 1, CURRENT_TIMESTAMP),
(338, 'Rhythm', '{input-parameters.rhythm}', 5, 1, CURRENT_TIMESTAMP),
(338, 'x_axis', 'AUTO', 0, 1, CURRENT_TIMESTAMP),

(339, '80%-100%', '({correct}/({correct}+{missed-correct})/{2})+({avoided-wrong}/({avoided-wrong}+{wrong})/{2})>{0.8}+{OLD}', 1, 1, CURRENT_TIMESTAMP),
(339, '60%-80%', '(({correct}/({correct}+{missed-correct})/{2})+({avoided-wrong}/({avoided-wrong}+{wrong})/{2})<{0.8})*(({correct}/({correct}+{missed-correct})/{2})+({avoided-wrong}/({avoided-wrong}+{wrong})/{2})>{0.6})+{OLD}', 2, 1, CURRENT_TIMESTAMP),
(339, '40%-60%', '(({correct}/({correct}+{missed-correct})/{2})+({avoided-wrong}/({avoided-wrong}+{wrong})/{2})<{0.6})*(({correct}/({correct}+{missed-correct})/{2})+({avoided-wrong}/({avoided-wrong}+{wrong})/{2})>{0.4})+{OLD}', 3, 1, CURRENT_TIMESTAMP),
(339, '20%-40%', '(({correct}/({correct}+{missed-correct})/{2})+({avoided-wrong}/({avoided-wrong}+{wrong})/{2})<{0.4})*(({correct}/({correct}+{missed-correct})/{2})+({avoided-wrong}/({avoided-wrong}+{wrong})/{2})>{0.2})+{OLD}', 4, 1, CURRENT_TIMESTAMP),
(339, '0%-20%', '({correct}/({correct}+{missed-correct})/{2})+({avoided-wrong}/({avoided-wrong}+{wrong})/{2})<{0.2}', 5, 1, CURRENT_TIMESTAMP),

(340, '80%-100%', '({correct}/({correct}+{missed-correct})/{2})+({avoided-wrong}/({avoided-wrong}+{wrong})/{2})>{0.8}+{OLD}', 1, 1, CURRENT_TIMESTAMP),
(340, '60%-80%', '(({correct}/({correct}+{missed-correct})/{2})+({avoided-wrong}/({avoided-wrong}+{wrong})/{2})<{0.8})*(({correct}/({correct}+{missed-correct})/{2})+({avoided-wrong}/({avoided-wrong}+{wrong})/{2})>{0.6})+{OLD}', 2, 1, CURRENT_TIMESTAMP),
(340, '40%-60%', '(({correct}/({correct}+{missed-correct})/{2})+({avoided-wrong}/({avoided-wrong}+{wrong})/{2})<{0.6})*(({correct}/({correct}+{missed-correct})/{2})+({avoided-wrong}/({avoided-wrong}+{wrong})/{2})>{0.4})+{OLD}', 3, 1, CURRENT_TIMESTAMP),
(340, '20%-40%', '(({correct}/({correct}+{missed-correct})/{2})+({avoided-wrong}/({avoided-wrong}+{wrong})/{2})<{0.4})*(({correct}/({correct}+{missed-correct})/{2})+({avoided-wrong}/({avoided-wrong}+{wrong})/{2})>{0.2})+{OLD}', 4, 1, CURRENT_TIMESTAMP),
(340, '0%-20%', '({correct}/({correct}+{missed-correct})/{2})+({avoided-wrong}/({avoided-wrong}+{wrong})/{2})<{0.2}', 5, 1, CURRENT_TIMESTAMP),
(340, 'x_axis', 'MONTHLY', 0, 1, CURRENT_TIMESTAMP),

(341, 'Correct Missed', '{feedback-over-time.missed-correct}', 2, 1, CURRENT_TIMESTAMP),
(341, 'Correct Taken', '{feedback-over-time.correct}', 1, 1, CURRENT_TIMESTAMP),
(341, 'Wrong Avoided', '{feedback-over-time.avoided-wrong}', 4, 1, CURRENT_TIMESTAMP),
(341, 'Wrong Taken', '{feedback-over-time.wrong}', 3, 1, CURRENT_TIMESTAMP),

(342, 'Correct', '{correct}', 1, 1, CURRENT_TIMESTAMP),
(342, 'Missed', '{missed-correct}', 2, 1, CURRENT_TIMESTAMP),
(342, 'x_axis', 'AUTO', 0, 1, CURRENT_TIMESTAMP),

(343, 'Correct', '{correct}', 1, 1, CURRENT_TIMESTAMP),
(344, 'Correct', '{correct}', 1, 1, CURRENT_TIMESTAMP),
(344, 'x_axis', 'AUTO', 0, 1, CURRENT_TIMESTAMP),
(345, 'Correct', '{feedback-over-time.correct}', 1, 1, CURRENT_TIMESTAMP),
(346, 'Correct', '{correct}', 1, 1, CURRENT_TIMESTAMP),
(346, 'Hit', '{hit}', 1, 1, CURRENT_TIMESTAMP),
(346, 'x_axis', 'AUTO', 0, 1, CURRENT_TIMESTAMP),
(347, 'Correct', '{feedback-over-time.correct}', 1, 1, CURRENT_TIMESTAMP),
(347, 'Hit', '{feedback-over-time.hit}', 1, 1, CURRENT_TIMESTAMP),

(348, 'Correct left', '{correct-left}', 1, 1, CURRENT_TIMESTAMP),
(348, 'Wrong left', '{wrong-left}', 3, 1, CURRENT_TIMESTAMP),
(348, 'Correct right', '{correct-right}', 2, 1, CURRENT_TIMESTAMP),
(348, 'Wrong right', '{wrong-right}', 4, 1, CURRENT_TIMESTAMP),

(349, 'correct-left Bottom left', '{spatial-feedback.BottomLeft.correct-left}+{spatial-feedback.Bottom.correct-left}+{spatial-feedback.Left.correct-left}', 1, 1, CURRENT_TIMESTAMP),
(349, 'correct-left Bottom right', '{spatial-feedback.BottomRight.correct-left}+{spatial-feedback.Right.correct-left}', 2, 1, CURRENT_TIMESTAMP),
(349, 'correct-left Top Left', '{spatial-feedback.TopLeft.correct-left}+{spatial-feedback.Top.correct-left}', 3, 1, CURRENT_TIMESTAMP),
(349, 'correct-left Top Right', '{spatial-feedback.TopRight.correct-left}', 4, 1, CURRENT_TIMESTAMP),
(349, 'wrong-left Bottom left', '{spatial-feedback.BottomLeft.wrong-left}+{spatial-feedback.Left.wrong-left}+{spatial-feedback.Bottom.wrong-left}', 5, 1, CURRENT_TIMESTAMP),
(349, 'wrong-left Bottom right', '{spatial-feedback.BottomRight.wrong-left}+{spatial-feedback.Right.wrong-left}', 6, 1, CURRENT_TIMESTAMP),
(349, 'wrong-left Top left', '{spatial-feedback.TopLeft.wrong-left}+{spatial-feedback.Top.wrong-left}', 7, 1, CURRENT_TIMESTAMP),
(349, 'wrong-left Top right', '{spatial-feedback.TopRight.wrong-left}', 8, 1, CURRENT_TIMESTAMP),

(350, 'correct-right Bottom left', '{spatial-feedback.BottomLeft.correct-right}+{spatial-feedback.Bottom.correct-right}+{spatial-feedback.Left.correct-right}', 1, 1, CURRENT_TIMESTAMP),
(350, 'correct-right Bottom right', '{spatial-feedback.BottomRight.correct-right}+{spatial-feedback.Right.correct-right}', 2, 1, CURRENT_TIMESTAMP),
(350, 'correct-right Top Left', '{spatial-feedback.TopLeft.correct-right}+{spatial-feedback.Top.correct-right}', 3, 1, CURRENT_TIMESTAMP),
(350, 'correct-right Top Right', '{spatial-feedback.TopRight.correct-right}', 4, 1, CURRENT_TIMESTAMP),
(350, 'wrong-right Bottom left', '{spatial-feedback.BottomLeft.wrong-right}+{spatial-feedback.Left.wrong-right}+{spatial-feedback.Bottom.wrong-right}', 5, 1, CURRENT_TIMESTAMP),
(350, 'wrong-right Bottom right', '{spatial-feedback.BottomRight.wrong-right}+{spatial-feedback.Right.wrong-right}', 6, 1, CURRENT_TIMESTAMP),
(350, 'wrong-right Top left', '{spatial-feedback.TopLeft.wrong-right}+{spatial-feedback.Top.wrong-right}', 7, 1, CURRENT_TIMESTAMP),
(350, 'wrong-right Top right', '{spatial-feedback.TopRight.wrong-right}', 8, 1, CURRENT_TIMESTAMP),

(351, 'Correct left', '{correct-left}', 1, 1, CURRENT_TIMESTAMP),
(351, 'Correct right', '{correct-left}', 2, 1, CURRENT_TIMESTAMP),
(351, 'Wrong left', '{wrong-left}', 3, 1, CURRENT_TIMESTAMP),
(351, 'Wrong right', '{wrong-right}', 4, 1, CURRENT_TIMESTAMP),
(351, 'x_axis', 'AUTO', 0, 1, CURRENT_TIMESTAMP),

(352, 'Bottom left (left hand)', '{spatial-feedback.BottomLeft.correct-left}+{spatial-feedback.Bottom.correct-left}+{spatial-feedback.Left.correct-left}', 1, 1, CURRENT_TIMESTAMP),
(352, 'Bottom right (left hand)', '{spatial-feedback.BottomRight.correct-left}+{spatial-feedback.Right.correct-left}', 2, 1, CURRENT_TIMESTAMP),
(352, 'Top left (left hand)', '{spatial-feedback.TopLeft.correct-left}+{spatial-feedback.Top.correct-left}', 3, 1, CURRENT_TIMESTAMP),
(352, 'Top right (left hand)', '{spatial-feedback.TopRight.correct-left}', 4, 1, CURRENT_TIMESTAMP),

(352, 'Bottom left (right hand)', '{spatial-feedback.BottomLeft.correct-right}+{spatial-feedback.Bottom.correct-right}+{spatial-feedback.Left.correct-right}', 1, 1, CURRENT_TIMESTAMP),
(352, 'Bottom right (right hand)', '{spatial-feedback.BottomRight.correct-right}+{spatial-feedback.Right.correct-right}', 2, 1, CURRENT_TIMESTAMP),
(352, 'Top left (right hand)', '{spatial-feedback.TopLeft.correct-right}+{spatial-feedback.Top.correct-right}', 3, 1, CURRENT_TIMESTAMP),
(352, 'Top right (right hand)', '{spatial-feedback.TopRight.correct-right}', 4, 1, CURRENT_TIMESTAMP),

(352, 'x_axis', 'AUTO', 0, 1, CURRENT_TIMESTAMP),

(353, 'Bottom left (left hand)', '{spatial-feedback.BottomLeft.wrong-left}+{spatial-feedback.Bottom.wrong-left}+{spatial-feedback.Left.wrong-left}', 1, 1, CURRENT_TIMESTAMP),
(353, 'Bottom right (left hand)', '{spatial-feedback.BottomRight.wrong-left}+{spatial-feedback.Right.wrong-left}', 2, 1, CURRENT_TIMESTAMP),
(353, 'Top left (left hand)', '{spatial-feedback.TopLeft.wrong-left}+{spatial-feedback.Top.wrong-left}', 3, 1, CURRENT_TIMESTAMP),
(353, 'Top right (left hand)', '{spatial-feedback.TopRight.wrong-left}', 4, 1, CURRENT_TIMESTAMP),

(353, 'Bottom left (right hand)', '{spatial-feedback.BottomLeft.wrong-right}+{spatial-feedback.Bottom.wrong-right}+{spatial-feedback.Left.wrong-right}', 1, 1, CURRENT_TIMESTAMP),
(353, 'Bottom right (right hand)', '{spatial-feedback.BottomRight.wrong-right}+{spatial-feedback.Right.wrong-right}', 2, 1, CURRENT_TIMESTAMP),
(353, 'Top left (right hand)', '{spatial-feedback.TopLeft.wrong-right}+{spatial-feedback.Top.wrong-right}', 3, 1, CURRENT_TIMESTAMP),
(353, 'Top right (right hand)', '{spatial-feedback.TopRight.wrong-right}', 4, 1, CURRENT_TIMESTAMP),

(353, 'x_axis', 'AUTO', 0, 1, CURRENT_TIMESTAMP);



INSERT INTO `ima_chart_template_option` (`Chart_Template_ID`, `Name`, `Value`, `Active`, `Last_Edit`) VALUES

(336, 'type', 'ten_diff', 1, CURRENT_TIMESTAMP),
(336, 'color-schema', 'positive_diff', 1, CURRENT_TIMESTAMP),

(337, 'type', 'ten_diff', 1, CURRENT_TIMESTAMP),
(337, 'color-schema', 'negative_diff', 1, CURRENT_TIMESTAMP),


(338, 'y-axis-label', 'variations', 1, CURRENT_TIMESTAMP),
(339, 'color-schema', 'stair', 1, CURRENT_TIMESTAMP),
(340, 'color-schema', 'stair', 1, CURRENT_TIMESTAMP),
(341, 'color-schema', 'diff', 1, CURRENT_TIMESTAMP),
(341, 'groupby', '2', 1, CURRENT_TIMESTAMP),
(341, 'time-interval', '5', 1, CURRENT_TIMESTAMP),
(342, 'color-schema', 'dual', 1, CURRENT_TIMESTAMP),
(343, 'color-schema', 'dual', 1, CURRENT_TIMESTAMP),
(344, 'color-schema', 'dual', 1, CURRENT_TIMESTAMP),
(345, 'color-schema', 'dual', 1, CURRENT_TIMESTAMP),
(345, 'time-interval', '5', 1, CURRENT_TIMESTAMP),
(346, 'color-schema', 'dual', 1, CURRENT_TIMESTAMP),
(346, 'groupby', '1', 1, CURRENT_TIMESTAMP),
(347, 'color-schema', 'dual', 1, CURRENT_TIMESTAMP),
(347, 'time-interval', '5', 1, CURRENT_TIMESTAMP),
(347, 'groupby', '1', 1, CURRENT_TIMESTAMP),
(348, 'check','{input-parameters.hand}={"both"}',1,CURRENT_TIMESTAMP),
(349, 'check','{input-parameters.hand}={"both"}',1,CURRENT_TIMESTAMP),
(349, 'color-schema', 'quadrants', 1, CURRENT_TIMESTAMP),
(349, 'type', 'double', 1, CURRENT_TIMESTAMP),
(350, 'check','{input-parameters.hand}={"both"}',1,CURRENT_TIMESTAMP),
(350, 'color-schema', 'quadrants', 1,CURRENT_TIMESTAMP),
(350, 'type', 'double',1,CURRENT_TIMESTAMP),

(351, 'check','{input-parameters.hand}={"both"}',1,CURRENT_TIMESTAMP),
(351, 'color-schema', 'dual',1,CURRENT_TIMESTAMP),

(352, 'check','{input-parameters.hand}={"both"}',1,CURRENT_TIMESTAMP),
(352, 'color-schema', 'positive',1,CURRENT_TIMESTAMP),

(353, 'check','{input-parameters.hand}={"both"}',1,CURRENT_TIMESTAMP),
(353, 'color-schema', 'negative',1,CURRENT_TIMESTAMP);

UPDATE `ima_chart_template_data` SET `Source`='{correct-top}+{correct-bottom}+{correct-middle}' WHERE Chart_Template_ID=249 and Name='Avoided';
UPDATE `ima_chart_template_data` SET `Source`='{wrong-top}+{wrong-bottom}+{wrong-middle}' WHERE Chart_Template_ID=249 and Name='Hit';

UPDATE `ima_chart_template_data` SET `Source`='{correct-top}+{correct-bottom}+{correct-middle}' WHERE Chart_Template_ID=260 and Name='Correct';
UPDATE `ima_chart_template_data` SET `Source`='{wrong-top}+{wrong-bottom}+{wrong-middle}' WHERE Chart_Template_ID=260 and Name='Wrong';

INSERT INTO `ima_chart_template_data` (`Chart_Template_ID`, `Name`, `Source`, `Data_Order`, `Active`, `Checksum`, `Last_Edit`) VALUES
(250, 'Middle', '{correct-middle}', 5, 1, NULL, '2020-09-24 12:57:07'),
(250, '[diff]Middle', '{wrong-middle}', 6, 1, NULL, '2020-09-24 12:57:07'),

(251, 'Correct middle', '{correct-middle}', 5, 1, NULL, '2020-09-24 12:57:07'),
(251, 'Wrong middle', '{wrong-middle}', 6, 1, NULL, '2020-09-24 12:57:07'),

(253, 'Middle', '{time-middle}', 3, 1, NULL, '2020-09-24 12:57:07'),

(254, 'Middle', '{feedback-over-time.time-middle}', 3, 1, NULL, '2020-09-24 12:57:07'),

(256, 'Middle', '{time-middle}', 3, 1, NULL, '2020-09-24 12:57:07'),

(258, 'correct middle', '{feedback-over-time.correct-middle}', 5, 1, NULL, '2020-09-24 12:57:07'),
(258, 'wrong middle', '{feedback-over-time.wrong-middle}', 6, 1, NULL, '2020-09-24 12:57:07');

UPDATE `ima_chart_template_data` SET `Source`='({correct-top}+{correct-bottom}+{correct-middle})/({correct-top}+{correct-middle}+{wrong-middle}+{wrong-top}+{correct-bottom}+{wrong-bottom})<{0.2}+{OLD}' WHERE Chart_Template_ID=285 and Name='0%-20%';
UPDATE `ima_chart_template_data` SET `Source`='(({correct-top}+{correct-bottom}+{correct-middle})/({correct-top}+{correct-middle}+{wrong-middle}+{wrong-top}+{correct-bottom}+{wrong-bottom})<{0.4})*(({correct-top}+{correct-bottom}+{correct-middle})/({correct-top}+{correct-middle}+{wrong-middle}+{wrong-top}+{correct-bottom}+{wrong-bottom})>{0.2})+{OLD}' WHERE Chart_Template_ID=285 and Name='20%-40%';
UPDATE `ima_chart_template_data` SET `Source`='(({correct-top}+{correct-bottom}+{correct-middle})/({correct-top}+{correct-middle}+{wrong-middle}+{wrong-top}+{correct-bottom}+{wrong-bottom})<{0.6})*(({correct-top}+{correct-bottom}+{correct-middle})/({correct-top}+{correct-middle}+{wrong-middle}+{wrong-top}+{correct-bottom}+{wrong-bottom})>{0.4})+{OLD}' WHERE Chart_Template_ID=285 and Name='40%-60%';
UPDATE `ima_chart_template_data` SET `Source`='(({correct-top}+{correct-bottom}+{correct-middle})/({correct-top}+{correct-middle}+{wrong-middle}+{wrong-top}+{correct-bottom}+{wrong-bottom})<{0.8})*(({correct-top}+{correct-bottom}+{correct-middle})/({correct-top}+{correct-middle}+{wrong-middle}+{wrong-top}+{correct-bottom}+{wrong-bottom})>{0.6})+{OLD}' WHERE Chart_Template_ID=285 and Name='60%-80%';
UPDATE `ima_chart_template_data` SET `Source`='({correct-top}+{correct-bottom}+{correct-middle})/({correct-top}+{correct-middle}+{wrong-middle}+{wrong-top}+{correct-bottom}+{wrong-bottom})>{0.8}+{OLD}' WHERE Chart_Template_ID=285 and Name='80%-100%';

UPDATE `ima_chart_template_data` SET `Source`='({correct-top}+{correct-bottom}+{correct-middle})/({correct-top}+{correct-middle}+{wrong-middle}+{wrong-top}+{correct-bottom}+{wrong-bottom})<{0.2}+{OLD}' WHERE Chart_Template_ID=295 and Name='0%-20%';
UPDATE `ima_chart_template_data` SET `Source`='(({correct-top}+{correct-bottom}+{correct-middle})/({correct-top}+{correct-middle}+{wrong-middle}+{wrong-top}+{correct-bottom}+{wrong-bottom})<{0.4})*(({correct-top}+{correct-bottom}+{correct-middle})/({correct-top}+{correct-middle}+{wrong-middle}+{wrong-top}+{correct-bottom}+{wrong-bottom})>{0.2})+{OLD}' WHERE Chart_Template_ID=295 and Name='20%-40%';
UPDATE `ima_chart_template_data` SET `Source`='(({correct-top}+{correct-bottom}+{correct-middle})/({correct-top}+{correct-middle}+{wrong-middle}+{wrong-top}+{correct-bottom}+{wrong-bottom})<{0.6})*(({correct-top}+{correct-bottom}+{correct-middle})/({correct-top}+{correct-middle}+{wrong-middle}+{wrong-top}+{correct-bottom}+{wrong-bottom})>{0.4})+{OLD}' WHERE Chart_Template_ID=295 and Name='40%-60%';
UPDATE `ima_chart_template_data` SET `Source`='(({correct-top}+{correct-bottom}+{correct-middle})/({correct-top}+{correct-middle}+{wrong-middle}+{wrong-top}+{correct-bottom}+{wrong-bottom})<{0.8})*(({correct-top}+{correct-bottom}+{correct-middle})/({correct-top}+{correct-middle}+{wrong-middle}+{wrong-top}+{correct-bottom}+{wrong-bottom})>{0.6})+{OLD}' WHERE Chart_Template_ID=295 and Name='60%-80%';
UPDATE `ima_chart_template_data` SET `Source`='({correct-top}+{correct-bottom}+{correct-middle})/({correct-top}+{correct-middle}+{wrong-middle}+{wrong-top}+{correct-bottom}+{wrong-bottom})>{0.8}+{OLD}' WHERE Chart_Template_ID=295 and Name='80%-100%';

INSERT INTO `ima_game` (`Game_ID`, `Name`, `Resource_URL`, `Executable`, `Description`,`Version`,  `Display_Order`, `Active`, `Last_Edit`) VALUES
(59, 'Night & day', '/images/games/game1c.png', 'Game1C', 'Users are asked to touch as many flowers as they can whilst avoiding the insects in day time.  At night time, users are asked to touch the insects whilst avoiding the flowers.',1,2, 1, CURRENT_TIMESTAMP),
(60, 'Shooting stars', '/images/games/game1dv3.png', 'Game1Dv3', 'Users are asked to touch as many rockets as they can whilst avoiding the meteorites. At the same time, users are asked to count how many shooting stars cross the sky.',1,2, 1, CURRENT_TIMESTAMP),
(61, 'Alternate fishing', '/images/games/game1ev2.png', 'Game1Ev2', 'Users are asked to touch each of the two kinds of fish alternatively whilst avoiding the jellyfish.',1,2, 1, CURRENT_TIMESTAMP),
(62, 'Fruit passion', '/images/games/game6b.png', 'Game6B', 'Users are asked to collect a single type of fruit whilst avoiding every other types of fruit and balls.',1,7, 1, CURRENT_TIMESTAMP),
(63, 'Grand canyon', '/images/games/gameballooncogni.png', 'GameBalloonCogni', 'Users are asked to explore the canyon whilst avoiding cactuses, dangerous bridges and rocks.',1,9, 1, CURRENT_TIMESTAMP),
(64, 'Cooking Challenge', '/images/games/game2v4.png', 'Game2v4', 'Users are asked to drag the food to arrange them on the correct pan according to the same type of food.',1,3, 1, CURRENT_TIMESTAMP),
(65, 'Moles & worms', '/images/games/gamefeet3b.png', 'GameFeet3B', 'Users are asked to touch the mole and the worm in turn whilst avoiding the vegetables.',1,8, 1, CURRENT_TIMESTAMP);

INSERT INTO `ima_game_device` (`Game_ID`, `Device_ID`, `Active`, `Last_Edit`) VALUES
(59, 4, 1, CURRENT_TIMESTAMP),
(60, 4, 1, CURRENT_TIMESTAMP),
(61, 4, 1, CURRENT_TIMESTAMP),
(62, 4, 1, CURRENT_TIMESTAMP),
(63, 4, 1, CURRENT_TIMESTAMP),
(64, 4, 1, CURRENT_TIMESTAMP),
(65, 4, 1, CURRENT_TIMESTAMP),

(59, 2, 1, CURRENT_TIMESTAMP),
(60, 2, 1, CURRENT_TIMESTAMP),
(61, 2, 1, CURRENT_TIMESTAMP),
(62, 2, 1, CURRENT_TIMESTAMP),
(63, 2, 1, CURRENT_TIMESTAMP),
(64, 2, 1, CURRENT_TIMESTAMP),
(65, 2, 1, CURRENT_TIMESTAMP),

(59, 3, 1, CURRENT_TIMESTAMP),
(60, 3, 1, CURRENT_TIMESTAMP),
(61, 3, 1, CURRENT_TIMESTAMP),
(62, 3, 1, CURRENT_TIMESTAMP),
(63, 3, 1, CURRENT_TIMESTAMP),
(64, 3, 1, CURRENT_TIMESTAMP),
(65, 3, 1, CURRENT_TIMESTAMP),

(59, 1, 1, CURRENT_TIMESTAMP),
(60, 1, 1, CURRENT_TIMESTAMP),
(61, 1, 1, CURRENT_TIMESTAMP),
(62, 1, 1, CURRENT_TIMESTAMP),
(63, 1, 1, CURRENT_TIMESTAMP),
(64, 1, 1, CURRENT_TIMESTAMP),
(65, 1, 1, CURRENT_TIMESTAMP),

(59, 6, 1, CURRENT_TIMESTAMP),
(60, 6, 1, CURRENT_TIMESTAMP),
(61, 6, 1, CURRENT_TIMESTAMP),
(62, 6, 1, CURRENT_TIMESTAMP),
(63, 6, 1, CURRENT_TIMESTAMP),
(64, 6, 1, CURRENT_TIMESTAMP),
(65, 6, 1, CURRENT_TIMESTAMP);


INSERT INTO `ima_game_dependency` (`Game_ID`, `Resource_ID`, `Order`, `Active`, `Last_Edit`) VALUES
(59, 1, 1, 1, CURRENT_TIMESTAMP),
(59, 2, 2, 1, CURRENT_TIMESTAMP),

(60, 1, 1, 1, CURRENT_TIMESTAMP),
(60, 2, 2, 1, CURRENT_TIMESTAMP),

(61, 1, 1, 1, CURRENT_TIMESTAMP),
(61, 2, 2, 1, CURRENT_TIMESTAMP),

(62, 8, 1, 1, CURRENT_TIMESTAMP),
(62, 2, 2, 1, CURRENT_TIMESTAMP),

(63, 1, 1, 1, CURRENT_TIMESTAMP),
(63, 2, 2, 1, CURRENT_TIMESTAMP),
(63, 3, 3, 1, CURRENT_TIMESTAMP),
(63, 11, 4, 1, CURRENT_TIMESTAMP),
(63, 10, 5, 1, CURRENT_TIMESTAMP),

(64, 1, 1, 1, CURRENT_TIMESTAMP),
(64, 2, 2, 1, CURRENT_TIMESTAMP),

(65, 1, 1, 1, CURRENT_TIMESTAMP),
(65, 2, 2, 1, CURRENT_TIMESTAMP);

INSERT INTO `ima_game_parameter_association` (`Game_ID`, `Parameter_ID`, `Optional_Parameter`, `Active`, `Last_Edit`) VALUES

(59, 1, 0,1, CURRENT_TIMESTAMP),
(59, 46, 0,1, CURRENT_TIMESTAMP),
(59, 3, 0,1, CURRENT_TIMESTAMP),
(59, 4, 0,1, CURRENT_TIMESTAMP),

(60, 1, 0,1, CURRENT_TIMESTAMP),
(60, 65, 0,1, CURRENT_TIMESTAMP),
(60, 3, 0,1, CURRENT_TIMESTAMP),
(60, 64, 0,1, CURRENT_TIMESTAMP),

(61, 1, 0,1, CURRENT_TIMESTAMP),
(61, 62, 0,1, CURRENT_TIMESTAMP),
(61, 3, 0,1, CURRENT_TIMESTAMP),
(61, 61, 0,1, CURRENT_TIMESTAMP),

(62, 1, 0, 1,CURRENT_TIMESTAMP),
(62, 50, 0, 1,CURRENT_TIMESTAMP),
(62, 51, 0, 1,CURRENT_TIMESTAMP),
(62, 52, 0, 1,CURRENT_TIMESTAMP),
(62, 53, 0, 1,CURRENT_TIMESTAMP),

(63, 1, 0, 1, CURRENT_TIMESTAMP),
(63, 104, 0, 1, CURRENT_TIMESTAMP),
(63, 105, 0, 1, CURRENT_TIMESTAMP),

(64, 1, 0,1, CURRENT_TIMESTAMP),
(64, 67, 0,1, CURRENT_TIMESTAMP),
(64, 68, 0,1, CURRENT_TIMESTAMP),

(65, 1, 0, 1, CURRENT_TIMESTAMP),
(65, 99, 0, 1, CURRENT_TIMESTAMP),
(65, 100, 0, 1, CURRENT_TIMESTAMP),
(65, 101, 0, 1, CURRENT_TIMESTAMP),
(65, 102, 0, 1, CURRENT_TIMESTAMP),
(65, 103, 0, 1, CURRENT_TIMESTAMP),
(65, 106, 0, 1, CURRENT_TIMESTAMP),

(59, 148, 0,1, CURRENT_TIMESTAMP),
(60, 148, 0,1, CURRENT_TIMESTAMP),
(3, 148, 0,1, CURRENT_TIMESTAMP),
(4, 148, 0,1, CURRENT_TIMESTAMP),
(22, 148, 0,1, CURRENT_TIMESTAMP),
(23, 148, 0,1, CURRENT_TIMESTAMP),
(24, 148, 0,1, CURRENT_TIMESTAMP),
(25, 148, 0,1, CURRENT_TIMESTAMP),
(41, 148, 0,1, CURRENT_TIMESTAMP),
(32, 148, 0,1, CURRENT_TIMESTAMP),

(59, 149, 0,1, CURRENT_TIMESTAMP),
(60, 150, 0,1, CURRENT_TIMESTAMP),
(8, 151, 0,1, CURRENT_TIMESTAMP),
(14, 152, 0,1, CURRENT_TIMESTAMP),
(15, 152, 0,1, CURRENT_TIMESTAMP),
(15, 153, 0,1, CURRENT_TIMESTAMP);


INSERT INTO `ima_game_parameter` (`Parameter_ID`, `Device_ID`, `Name`, `Label`, `Description`, `Default`, `Order`, `Levelable`, `Active`) VALUES
(148, NULL, 'target', 'number of target/distractors', 'Amount of different target and distractors.', 0, 0, 1, 1),
(149, NULL, 'switch_frequency', 'day night cycle timing', 'Frequency of the switch between night and day.', 0, 0, 1, 1),

(150, NULL, 'counter-elements', 'shooting stars frequency', 'How many shooting stars appears on the screen.', 0, 0, 1, 1),
(151, NULL, 'hide-target', 'hide target', 'Hide the target that shows where the element will fall.', 0, 0, 1, 1),
(152, NULL, 'enable_hint', 'enable hint', 'Enable the possibility to review to use a hint.', 0, 0, 1, 1),
(153, NULL, 'keep_cards', 'keep cards', 'Keep cards when selecting a correct match.', 0, 0, 1, 1);

UPDATE `ima_game_parameter_value` SET Label='very slow' WHERE Value='very slow' and  `Parameter_ID`=51;
INSERT INTO `ima_game_parameter_value` (`Parameter_ID`, `Value`, `Label`, `Description`, `Active`, `Last_Edit`, `Default`, `Order`) VALUES
(148, 'one', 'one', NULL, 1, CURRENT_TIMESTAMP, 1, 1),
(148, 'many', 'many', NULL, 1,CURRENT_TIMESTAMP, 0, 2),

(149, 'never', 'never', NULL, 1, CURRENT_TIMESTAMP, 0, 1),
(149, 'slow', 'slow', NULL, 1, CURRENT_TIMESTAMP, 0, 2),
(149, 'medium', 'medium', NULL, 1, CURRENT_TIMESTAMP, 1, 3),
(149, 'fast', 'fast', NULL, 1, CURRENT_TIMESTAMP, 0, 4),


(150, 'few', 'never', NULL, 1, CURRENT_TIMESTAMP, 0, 1),
(150, 'medium', 'slow', NULL, 1, CURRENT_TIMESTAMP, 1, 2),
(150, 'many', 'medium', NULL, 1, CURRENT_TIMESTAMP, 0, 3),

(151, 'no', 'no', NULL, 1, CURRENT_TIMESTAMP, 1, 1),
(151, 'yes', 'yes', NULL, 1, CURRENT_TIMESTAMP, 0, 2),

(152, 'no', 'no', NULL, 1, CURRENT_TIMESTAMP, 1, 1),
(152, 'yes', 'yes', NULL, 1, CURRENT_TIMESTAMP, 0, 2),

(153, 'no', 'no', NULL, 1, CURRENT_TIMESTAMP, 1, 1),
(153, 'yes', 'yes', NULL, 1, CURRENT_TIMESTAMP, 0, 2);

-- UPDATE `ima_game_parameter_value` SET Label='very slow' WHERE Value='very slow' and  `Parameter_ID`=51;
-- INSERT INTO `ima_game_parameter_value` (`Parameter_ID`, `Value`, `Label`, `Description`, `Active`, `Last_Edit`, `Default`, `Order`) VALUES
-- (51, 'slow', 'slow', NULL, 1, CURRENT_TIMESTAMP, 0, 1);



INSERT INTO `cb_leaderboard` (`Id`, `Title`, `Description`, `UniqueRecords`, `ValueType`, `OrderType`, `AllowAnonymous`) VALUES
(57, 'Night & day', 'Leaderboard for Night & day', 0, 0, 0, 0),
(58, 'Shooting stars', 'Leaderboard for Shooting stars', 0, 0, 0, 0),
(59, 'Alternate fishing', 'Leaderboard for Alternate fishing', 0, 0, 0, 0),
(60, 'Fruit passion', 'Leaderboard for Fruit passion', 0, 0, 0, 0),
(61, 'Grand canyon', 'Leaderboard for Grand canyon', 0, 0, 0, 0),
(62, 'Cooking Challenge', 'Leaderboard for Cooking Challenge', 0, 0, 0, 0),
(63, 'Moles & worms', 'Leaderboard for Moles & worms', 0, 0, 0, 0);

INSERT INTO `ima_game_output`(`Id`,`Game_ID`, `Name`, `Parameter`,`Description`) VALUES 
(203, 59,'Score','{final-score}','The score of the play.'),
(204, 60,'Score','{final-score}','The score of the play.'),
(205, 61,'Score','{final-score}','The score of the play.'),
(206, 62,'Score','{final-score}','The score of the play.'),
(207, 63,'Score','{final-score}','The score of the play.'),
(208, 64,'Score','{final-score}','The score of the play.'),
(209, 65,'Score','{final-score}','The score of the play.'),

(210, 59,'Correct','{taken-correct}/({input-parameters.duration}/{60})','Total correct object taken by minute.'),
(211, 59,'Wrong','{taken-wrong}/({input-parameters.duration}/{60})','Total wrong object taken by minute.'),
(212, 59,'Accuracy','({taken-correct}/({taken-correct}+{missed-correct})/{2})+({avoided-wrong}/({avoided-wrong}+{taken-wrong})/{2})','The average between the taken correct objects out of the total ones and the avoided wrong objects out of the total ones.'),

(213, 60,'Accuracy','({taken-flowers}/{total-flowers}/{2})+({total-bees}-{taken-bees}/{total-bees}/{2})','The average between the taken correct objects out of the total ones and the avoided wrong objects out of the total ones.'),
(214, 60,'Correct','{taken-flowers}/({input-parameters.duration}/{60})','Total correct objects taken by minute.'),
(215, 60,'Wrong','{taken-bees}/({input-parameters.duration}/{60})','Total wrong objects taken by minute.'),
(216, 60,'Correct count','{correct-counter}','If count of shooting stars.'),

(217,61,'Accuracy','({taken-flowers}/({taken-flowers}+{taken-wrong-flowers})/{2})+({total-bees}-{taken-bees}/{total-bees}/{2})','The average between the taken correct objects out of to the total ones taken and the avoided wrong objects out of the total ones.'),
(219,61,'Correct','{taken-flowers}/({input-parameters.duration}/{60})','Total fish taken by minute.'),
(220,61,'Wrong','({taken-bees}+{taken-wrong-flowers})/({input-parameters.duration}/{60})','Total wrong fishes and jellyfishes taken by minute.'),

(221, 62,'Accuracy','({taken-fruits}/{total-fruits}/{2})+({total-distractors}-{taken-distractors}/{total-distractors}/{2})','The average between the taken correct objects out of the total ones and the avoided wrong objects out of the total ones.'),
(222, 62,'Correct','{taken-fruits}/({input-parameters.duration}/{60})','Total fruits taken by minute.'),
(223, 62,'Wrong','{taken-distractors}/({input-parameters.duration}/{60})','Total distractors taken by minute.'),

(224, 63,'Accuracy','({correct-top}+{correct-bottom}+{correct-center}+{correct-left}+{correct-right})/({correct-top}+{wrong-top}+{correct-bottom}+{wrong-bottom}+{correct-center}+{wrong-center}+{correct-left}+{wrong-left}+{correct-right}+{wrong-right})','Correcly avoided obstacles out of total obstacles.'),
(225, 63,'Correct','({correct-top}+{correct-bottom}+{correct-center}+{correct-left}+{correct-right})/({input-parameters.duration}/{60})','The correctly avoided obstacles by minute.'),
(226, 63,'Wrong','({wrong-top}+{wrong-bottom}+{wrong-center}+{wrong-left}+{wrong-right})/({input-parameters.duration}/{60})','The wrongly hit obstacles by minute.'),

(227, 64,'Accuracy','{correct}/({correct}+{wrong})','Correct placed food out of all placed food.'),
(228, 64,'Correct','{correct}/({input-parameters.duration}/{60})','The correct placed food by minute.'),
(229, 64,'Wrong','{wrong}/({input-parameters.duration}/{60})','The wrong placed food by minute.'),

(230, 65,'Accuracy','({taken-correct}/({taken-correct}+{taken-wrong})/{2})+({total-distractor}-{taken-distractor}/{total-distractor}/{2})','The average between the taken correct objects out of the total ones taken and the avoided wrong objects out of the total ones.'),
(231, 65,'Correct','{taken-correct}/({input-parameters.duration}/{60})','The correctly taken moles by minute.'),
(232, 65,'Wrong','{taken-distractor}/({input-parameters.duration}/{60})','The wrongly taken carrots by minute.');


INSERT INTO `ima_chart_game_template` (`Chart_Template_ID`, `Game_ID`) VALUES
(354, 59), 
(  2, 59),
(  3, 59),
(  4, 59),
(355, 59), 
(356, 59), 
(  7, 59),
(357, 59), 
(358, 59), 
(359, 59), 
( 44, 59),  
( 45, 59),  
(360, 59), 
(361, 59), 
(362, 59),  
(363, 59), 
(364, 59),  
(365, 59),  
(366, 59), 
(367, 59), 
(368, 59),  
(369, 59),  
(370, 59),  
(371, 59), 
(372, 59), 
(373, 59), 
(269, 59),
(270, 59),
(275, 59),
(374, 59), 
(375, 59), 
(296, 59),  
(297, 59),
(298, 59),
(299, 59),
(300, 59),
(301, 59),

(  1, 60),
(  2, 60),
(  3, 60),
(  4, 60),
(  5, 60),
(  6, 60),
(  7, 60),
( 28, 60),
( 29, 60),
( 42, 60),
( 43, 60),
( 44, 60),
( 45, 60),
( 46, 60),
( 47, 60),
(376, 60),
(201, 60),
(202, 60),
(204, 60),
(205, 60),
(206, 60),
(207, 60),
(208, 60),
(209, 60),
(210, 60),
(211, 60),
(212, 60),
(225, 60),
(226, 60),
(269, 60),
(270, 60),
(275, 60),
(276, 60),
(286, 60),
(377, 60),
(378, 60),

(379, 61), 
(  2, 61), 
(  3, 61),
(  4, 61),
(380, 61),
(  6, 61),
(  7, 61),
(381, 61),
( 29, 61),
( 42, 61),
(382, 61),
( 44, 61),
( 45, 61),
( 46, 61),
( 47, 61),
( 62, 61),
(383, 61), 
(202, 61),
(204, 61),
(206, 61),
(384, 61),
(385, 61), 
(211, 61),
(212, 61),
(386, 61),
(269, 61),
(270, 61),
(275, 61),
(387, 61), 
(388, 61),

(  3, 62),
(  4, 62),
( 44, 62),
(126, 62),
(127, 62),
(128, 62),
(129, 62),
(130, 62),
(131, 62),
(132, 62),
(133, 62),
(134, 62),
(135, 62),
(136, 62),
(140, 62),
(144, 62),
(145, 62),
(146, 62),
(147, 62),
(148, 62),
(149, 62),
(150, 62),
(151, 62),
(269, 62),
(270, 62),
(275, 62),
(284, 62),
(294, 62),

(  3, 63),
(  4, 63),
(  7, 63),
( 44, 63),
(389, 63),
(390, 63),
(391, 63),
(392, 63),
(259, 63),
(393, 63),
(269, 63),
(270, 63),
(275, 63),
(394, 63),
(395, 63),
(298, 63),
(299, 63),

(  2, 64),
(  3, 64),
(  4, 64),
(  7, 64),
( 10, 64),
( 11, 64),
( 44, 64),
( 45, 64),
( 48, 64),
( 49, 64),
( 50, 64),
( 63, 64),
(269, 64),
(270, 64),
(275, 64),
(277, 64),
(287, 64),
(296, 64),
(297, 64),
(298, 64),
(299, 64),
(300, 64),
(301, 64),

(  3, 65),
(  4, 65),
(  7, 65),
( 44, 65),
(237, 65),
(396, 65), 
(239, 65),
(397, 65), 

(242, 65),
(398, 65), 
(244, 65),
(245, 65),
(246, 65),
(247, 65),
(399, 65), 
(269, 65),
(270, 65),
(275, 65),
(400, 65), 
(401, 65); 



INSERT INTO `ima_chart_template` (`Chart_Template_ID`, `Type_ID`, `Name`, `Title`, `Resource_URL`, `Description`, `Session_Bound`, `Optional`, `Display_Order`, `Active`, `Last_Edit`) VALUES
(354, 5, 'taken-correct-nd', 'Correct objects', NULL, 'This chart shows how many correct objects were taken and how many wrong objects in % and in absolute value in brackets.', 1, 0, 0, 1, CURRENT_TIMESTAMP),
(355, 3, 'taken-correct-nd-gauge', 'Correct objects ', NULL, '', 1, 0, 0, 0, CURRENT_TIMESTAMP),
(356, 5, 'avoided-wrong-nd', 'Wrong objects ', NULL, 'This chart shows how many wrong objects were avoided and how many were taken in % and in absolute value in brackets.', 1, 0, 0, 1, CURRENT_TIMESTAMP),
(357, 7, 'takencorrect-nd', 'Objects over time', NULL, 'This chart shows how many correct objects were taken and missed and how many wrong objects were taken and avoided every 5 seconds', 1, 0, 0, 1, CURRENT_TIMESTAMP),
(358, 7, 'globalavoided-wrong-nd', 'Wrong objects', NULL, 'This chart shows how many wrong objects were avoided and how many were taken per session.', 0, 0, 0, 1, CURRENT_TIMESTAMP),
(359, 7, 'globaltaken-correct-nd', 'Correct objects', NULL, 'This chart shows how many correct objects were taken and how many were missed per session.', 0, 0, 0, 1, CURRENT_TIMESTAMP),
(360, 7, 'globaltakenwrong-nd', 'Wrong objects per quadrant', NULL, 'This chart shows how many wrong objects were avoided and how many were taken per quadrant per session.', 0, 0, 0, 1, CURRENT_TIMESTAMP),
(361, 7, 'globaltakencorrect-nd', 'Correct objects per quadrant', NULL, 'This chart shows how many correct objects were taken and how many were missed per quadrant per session.', 0, 0, 0, 1, CURRENT_TIMESTAMP),
(362, 11, 'global-parameters-game1c', 'Configuration parameters changes', NULL, 'For each session, this chart shows  possible configuration parameters changes compared to previous session configuration.', 0, 0, 0, 1, CURRENT_TIMESTAMP),
(363, 1, 'both-taken-correct-nd', 'Correct objects per hand', NULL, 'This chart shows how many correct objects were taken per hand.', 1, 1, 0, 1, CURRENT_TIMESTAMP),
(364, 1, 'both-avoided-wrong-nd', 'Wrong objects per hand', NULL, 'This chart shows how many wrong objects were taken per hand.', 1, 1, 0, 1, CURRENT_TIMESTAMP),
(365, 10, 'both-takencorrect-nd-right', 'Right hand objects per quadrant', NULL, 'This chart shows how many correct and wrong objects were taken with the right hand per quadrant.', 1, 1, 0, 1, CURRENT_TIMESTAMP),
(366, 10, 'both-takencorrect-nd-left', 'Left hand objects per quadrant', NULL, 'This chart shows how many correct and wrong objects were taken with the left hand per quadrant.', 1, 1, 0, 1, CURRENT_TIMESTAMP),
(367, 7, 'both-takencorrect-nd', 'Correct objects per hand over time', NULL, 'This chart shows how many correct objects were taken and missed per hand every 5 seconds.', 1, 1, 0, 1, CURRENT_TIMESTAMP),
(368, 7, 'both-avoidedwrongtime-nd', 'Wrong objects per hand over time', NULL, 'This chart shows how many wrong objects were taken and avoided per hand every 5 seconds.', 1, 1, 0, 1, CURRENT_TIMESTAMP),
(369, 7, 'both-globalavoided-wrong-nd', 'Wrong objects per hand', NULL, 'This chart shows how many wrong objects were taken per hand per session.', 0, 1, 0, 1, CURRENT_TIMESTAMP),
(370, 7, 'both-globaltaken-correct-nd', 'Correct objects per hand', NULL, 'This chart shows how many correct objects were taken per hand per session.', 0, 1, 0, 1, CURRENT_TIMESTAMP),
(371, 7, 'both-globaltakenwrong-nd', 'Wrong objects per quadrant per hand', NULL, 'This chart shows how many wrong objects were taken per quadrant per hand for each session.', 0, 1, 0, 1, CURRENT_TIMESTAMP),
(372, 7, 'both-globaltakencorrect-nd', 'Correct objects per quadrant per hand', NULL, 'This chart shows how many correct objects were taken per quadrant per hand for each session.', 0, 1, 0, 1, CURRENT_TIMESTAMP),
(373, 10, 'takencorrect-nd-g', 'Objects per quadrant', NULL, 'This chart shows how many correct and wrong objects were taken in every quadrant.', 1, 1, 0, 1, CURRENT_TIMESTAMP),
(376, 11, 'global-parameters-game1d', 'Configuration parameters changes', NULL, 'For each session, this chart shows  possible configuration parameters changes compared to previous session configuration.', 0, 0, 0, 1, CURRENT_TIMESTAMP),
(377, 6, 'correct-stars', 'Stars selected', NULL, '', 1, 0, 0, 1, CURRENT_TIMESTAMP),
(378, 7, 'correct-stars-glob', 'Stars selected', NULL, '', 0, 0, 0, 1, CURRENT_TIMESTAMP),
(379, 5, 'taken-correct-alt', 'Correct objects', NULL, 'This chart shows how many correct objects were taken and how many wrong objects in % and in absolute value in brackets.', 1, 0, 0, 1, CURRENT_TIMESTAMP),
(380, 3, 'taken-correct-alt-gauge', 'Correct objects ', NULL, '', 1, 0, 0, 0, CURRENT_TIMESTAMP),
(381, 7, 'takenflowers-alt', 'Objects over time', NULL, 'This chart shows how many correct objects were taken and missed and how many wrong objects were taken and avoided every 5 seconds', 1, 0, 0, 1, CURRENT_TIMESTAMP),
(382, 7, 'globaltaken-flowers-alt', 'Correct objects', NULL, 'This chart shows how many correct objects were taken and how many were missed per session.', 0, 0, 0, 1, CURRENT_TIMESTAMP),
(383, 1, 'both-taken-flowers-alt', 'Correct objects per hand', NULL, 'This chart shows how many correct objects were taken per hand.', 1, 1, 0, 1, CURRENT_TIMESTAMP),

(384, 7, 'both-takenflowers-alt', 'Correct objects per hand over time', NULL, 'This chart shows how many correct objects were taken and missed per hand every 5 seconds.', 1, 1, 0, 1, CURRENT_TIMESTAMP),
(385, 7, 'both-globaltaken-flowers-alt', 'Correct objects per hand', NULL, 'This chart shows how many correct objects were taken per hand per session.', 0, 1, 0, 1, CURRENT_TIMESTAMP),
(386, 10, 'takenflowers-alt', 'Objects per quadrant', NULL, 'This chart shows how many correct and wrong objects were taken in every quadrant.', 1, 1, 0, 1, CURRENT_TIMESTAMP),

(389, 5, 'correct-obstacle-cogni', 'Obstacles', NULL, 'This chart shows how many obstacles were avoided and how many were hit -- Unit of measurement: Percentage (Number of obstacles in brackets)', 1, 0, 0, 1, CURRENT_TIMESTAMP),
(390, 10, 'correct-obstacle-topvsbottom-cogni', 'Avoided obstacles', NULL, 'This chart shows how many obstacles were avoided per obstacles position (top, bottom) -- Unit of measurement: Number of obstacles', 1, 0, 0, 1, CURRENT_TIMESTAMP),
(391, 7, 'globalcorrect-obstacles-cogni', 'Obstacles per position', NULL, 'This chart shows how many obstacles were avoided and how many were hit per obstacles position (top, bottom) per session -- Unit of measurement: Number of obstacles.', 0, 0, 0, 1, CURRENT_TIMESTAMP),
(392, 7, 'obstacles-time-cogni', 'Obstacles over time', NULL, 'This chart shows how many obstacles were avoided and how many were hit per obstacles position (top, bottom) every 5 seconds -- Unit of measurement: Number of obstacles.', 1, 0, 1, 1, CURRENT_TIMESTAMP),
(393, 2, 'globalcorrect-obstacles-line-cogni', 'Obstacles', NULL, 'This chart shows how many obstacles were avoided and how many were hit per session -- Unit of measurement: Number of obstacles.', 0, 0, 0, 1, CURRENT_TIMESTAMP),
(396, 5, 'caughtMoles', 'Correct alternation', NULL, 'This chart shows how many correct alternated objects were caught and how many were wrongly taken.', 1, 0, 0, 1, CURRENT_TIMESTAMP),
(397, 10, 'caughtMolesByHole', 'Object per hole', NULL, 'This chart shows how many correct and wrong objects were caught per hole.', 1, 1, 0, 1, CURRENT_TIMESTAMP),
(398, 7, 'globalCaughtMoles', 'Correct alternation', NULL, 'This chart shows how many correct alternated objects were caught and how many were wrongly taken per session.', 0, 0, 0, 1, CURRENT_TIMESTAMP),
(399, 7, 'caughtMolesCarrotsInTime', 'Correct and wrong objects over time.', NULL, 'This chart shows how many correct objects were taken/missed and wrong objects were avoided/taken every 5 seconds.', 1, 0, 0, 1, CURRENT_TIMESTAMP);

INSERT INTO `ima_chart_template` (`Chart_Template_ID`, `Type_ID`, `Name`, `Title`, `Resource_URL`, `Description`, `Session_Bound`, `User_Bound`, `Optional`, `Display_Order`, `Active`, `Last_Edit`) VALUES
(374, 1, 'accuracygame1c', 'Accuracy', NULL, '', 0, 0, 1, 0, 1, CURRENT_TIMESTAMP),
(375, 7, 'monthlyaccuracygame1c', 'Accuracy monthly', NULL, '', 0, 0, 1, 0, 1, CURRENT_TIMESTAMP),
(387, 1, 'accuracygame1-alt', 'Accuracy', NULL, '', 0, 0, 1, 0, 1, CURRENT_TIMESTAMP),
(388, 7, 'monthlyaccuracygame1-alt', 'Accuracy monthly', NULL, '', 0, 0, 1, 0, 1, CURRENT_TIMESTAMP),
(394, 1, 'accuracygameb-cogni', 'Accuracy', NULL, '', 0, 0, 1, 0, 1, CURRENT_TIMESTAMP),
(395, 7, 'monthlyaccuracygameb-cogni', 'Accuracy monthly', NULL, '', 0, 0, 1, 0, 1, CURRENT_TIMESTAMP),
(400, 1, 'accuracygames', 'Accuracy', NULL, '', 0, 0, 1, 0, 1, CURRENT_TIMESTAMP),
(401, 7, 'monthlyaccuracygames', 'Accuracy monthly', NULL, '', 0, 0, 1, 0, 1, CURRENT_TIMESTAMP);

INSERT INTO `ima_chart_template_data` (`Chart_Template_ID`, `Name`, `Source`, `Data_Order`, `Active`, `Last_Edit`) VALUES
(354, 'Missed day', '{missed-correct-day}', 3, 1, CURRENT_TIMESTAMP),
(354, 'Taken day', '{taken-correct-day}', 1, 1, CURRENT_TIMESTAMP),
(354, 'Missed night', '{missed-correct-night}', 4, 1, CURRENT_TIMESTAMP),
(354, 'Taken night', '{taken-correct-night}', 1, 1, CURRENT_TIMESTAMP),
(355, 'total', '{taken-correct}+{missed-correct}', 0, 1, CURRENT_TIMESTAMP),
(355, 'value', '{taken-correct}', 0, 1, CURRENT_TIMESTAMP),
(356, 'Avoided day', '{avoided-wrong-day}', 2, 1, CURRENT_TIMESTAMP),
(356, 'Taken day', '{taken-wrong-day}', 2, 1, CURRENT_TIMESTAMP),
(357, 'Correct Missed night', '{feedback-over-time.missed-correct-night}', 2, 1, CURRENT_TIMESTAMP),
(357, 'Correct Taken night', '{feedback-over-time.taken-correct-night}', 1, 1, CURRENT_TIMESTAMP),
(357, 'Wrong Avoided night', '{feedback-over-time.avoided-wrong-night}', 6, 1, CURRENT_TIMESTAMP),
(357, 'Wrong Taken night', '{feedback-over-time.taken-wrong-night}', 5, 1, CURRENT_TIMESTAMP),
(357, 'Correct Missed day', '{feedback-over-time.missed-correct-day}', 4, 1, CURRENT_TIMESTAMP),
(357, 'Correct Taken day', '{feedback-over-time.taken-correct-day}', 3, 1, CURRENT_TIMESTAMP),
(357, 'Wrong Avoided day', '{feedback-over-time.avoided-wrong-day}', 8, 1, CURRENT_TIMESTAMP),
(357, 'Wrong Taken day', '{feedback-over-time.taken-wrong-day}', 7, 1, CURRENT_TIMESTAMP),
(358, 'Avoided night', '{avoided-wrong-night}', 2, 1, CURRENT_TIMESTAMP),
(358, 'Taken night', '{taken-wrong-night}', 3, 1, CURRENT_TIMESTAMP),
(358, 'Avoided day', '{avoided-wrong-day}', 1, 1, CURRENT_TIMESTAMP),
(358, 'Taken day', '{taken-wrong-day}', 4, 1, CURRENT_TIMESTAMP),
(358, 'x_axis', 'AUTO', 0, 1, CURRENT_TIMESTAMP),
(359, 'Missed night', '{missed-correct-night}', 4, 1, CURRENT_TIMESTAMP),
(359, 'Taken night', '{taken-correct-night}', 2, 1, CURRENT_TIMESTAMP),
(359, 'Missed day', '{missed-correct-day}', 3, 1, CURRENT_TIMESTAMP),
(359, 'Taken day', '{taken-correct-day}', 1, 1, CURRENT_TIMESTAMP),
(359, 'x_axis', 'AUTO', 0, 1, CURRENT_TIMESTAMP),
(360, 'Bottom left day', '{spatial-feedback.BottomLeft.taken-wrong-day}', 1, 1, CURRENT_TIMESTAMP),
(360, 'Bottom right day', '{spatial-feedback.BottomRight.taken-wrong-day}', 2, 1, CURRENT_TIMESTAMP),
(360, 'Top left day', '{spatial-feedback.TopLeft.taken-wrong-day}', 3, 1, CURRENT_TIMESTAMP),
(360, 'Top right day', '{spatial-feedback.TopRight.taken-wrong-day}', 4, 1, CURRENT_TIMESTAMP),
(360, 'Bottom left night', '{spatial-feedback.BottomLeft.taken-wrong-night}', 5, 1, CURRENT_TIMESTAMP),
(360, 'Bottom right night', '{spatial-feedback.BottomRight.taken-wrong-night}', 6, 1, CURRENT_TIMESTAMP),
(360, 'Top left night', '{spatial-feedback.TopLeft.taken-wrong-night}', 7, 1, CURRENT_TIMESTAMP),
(360, 'Top right night', '{spatial-feedback.TopRight.taken-wrong-night}', 8, 1, CURRENT_TIMESTAMP),
(360, 'x_axis', 'AUTO', 0, 1, CURRENT_TIMESTAMP),
(361, 'Bottom left day', '{spatial-feedback.BottomLeft.taken-correct-day}', 1, 1, CURRENT_TIMESTAMP),
(361, 'Bottom right day', '{spatial-feedback.BottomRight.taken-correct-day}', 2, 1, CURRENT_TIMESTAMP),
(361, 'Top left day', '{spatial-feedback.TopLeft.taken-correct-day}', 3, 1, CURRENT_TIMESTAMP),
(361, 'Top right day', '{spatial-feedback.TopRight.taken-correct-day}', 4, 1, CURRENT_TIMESTAMP),
(361, 'Bottom left night', '{spatial-feedback.BottomLeft.taken-correct-night}', 5, 1, CURRENT_TIMESTAMP),
(361, 'Bottom right night', '{spatial-feedback.BottomRight.taken-correct-night}', 6, 1, CURRENT_TIMESTAMP),
(361, 'Top left night', '{spatial-feedback.TopLeft.taken-correct-night}', 7, 1, CURRENT_TIMESTAMP),
(361, 'Top right night', '{spatial-feedback.TopRight.taken-correct-night}', 8, 1, CURRENT_TIMESTAMP),
(361, 'x_axis', 'AUTO', 0, 1, CURRENT_TIMESTAMP),
(362, 'Density', '{input-parameters.density}', 1, 1, CURRENT_TIMESTAMP),
(362, 'Duration', '{input-parameters.duration}', 1, 1, CURRENT_TIMESTAMP),
(362, 'Proportion', '{input-parameters.proportion}', 1, 1, CURRENT_TIMESTAMP),
(362, 'Velocity', '{input-parameters.velocity}', 1, 1, CURRENT_TIMESTAMP),
(362, 'Switch frequency', '{input-parameters.switch_frequency}', 1, 1, CURRENT_TIMESTAMP),
(362, 'Target', '{input-parameters.target}', 1, 1, CURRENT_TIMESTAMP),
(362, 'x_axis', 'AUTO', 0, 1, CURRENT_TIMESTAMP),
(363, 'Left', '{left-taken-correct-day}+{left-taken-correct-night}', 1, 1, CURRENT_TIMESTAMP),
(363, 'Missed', '{missed-correct-day}+{missed-correct-night}', 3, 1, CURRENT_TIMESTAMP),
(363, 'Right', '{right-taken-correct-day}+{right-taken-correct-night}', 2, 1, CURRENT_TIMESTAMP),
(364, 'Avoided', '{avoided-wrong-day}+{avoided-wrong-night}', 1, 1, CURRENT_TIMESTAMP),
(364, 'Left', '{left-taken-wrong-day}+{left-taken-wrong-night}', 2, 1, CURRENT_TIMESTAMP),
(364, 'Right', '{right-taken-wrong-day}+{right-taken-wrong-night}', 3, 1, CURRENT_TIMESTAMP),
(365, 'Correct Bottom left', '{spatial-feedback.BottomLeft.right-taken-correct-day}+{spatial-feedback.Bottom.right-taken-correct-day}+{spatial-feedback.Left.right-taken-correct-day}+{spatial-feedback.BottomLeft.right-taken-correct-night}+{spatial-feedback.Bottom.right-taken-correct-night}+{spatial-feedback.Left.right-taken-correct-night}', 1, 1, CURRENT_TIMESTAMP),
(365, 'Correct Bottom right', '{spatial-feedback.BottomRight.right-taken-correct-day}+{spatial-feedback.Right.right-taken-correct-day}+{spatial-feedback.BottomRight.right-taken-correct-night}+{spatial-feedback.Right.right-taken-correct-night}', 3, 1, CURRENT_TIMESTAMP),
(365, 'Correct Top left', '{spatial-feedback.TopLeft.right-taken-correct-day}+{spatial-feedback.Top.right-taken-correct-day}+{spatial-feedback.TopLeft.right-taken-correct-night}+{spatial-feedback.Top.right-taken-correct-night}', 5, 1, CURRENT_TIMESTAMP),
(365, 'Correct Top right', '{spatial-feedback.TopRight.right-taken-correct-day}+{spatial-feedback.TopRight.right-taken-correct-night}', 7, 1, CURRENT_TIMESTAMP),
(365, 'Wrong Bottom left', '{spatial-feedback.BottomLeft.right-taken-wrong-day}+{spatial-feedback.Bottom.right-taken-wrong-day}+{spatial-feedback.Left.right-taken-wrong-day}+{spatial-feedback.BottomLeft.right-taken-wrong-night}+{spatial-feedback.Bottom.right-taken-wrong-night}+{spatial-feedback.Left.right-taken-wrong-night}', 9, 1, CURRENT_TIMESTAMP),
(365, 'Wrong Bottom right', '{spatial-feedback.BottomRight.right-taken-wrong-day}+{spatial-feedback.Right.right-taken-wrong-day}+{spatial-feedback.BottomRight.right-taken-wrong-night}+{spatial-feedback.Right.right-taken-wrong-night}', 11, 1, CURRENT_TIMESTAMP),
(365, 'Wrong Top left', '{spatial-feedback.TopLeft.right-taken-wrong-day}+{spatial-feedback.Top.right-taken-wrong-day}+{spatial-feedback.TopLeft.right-taken-wrong-night}+{spatial-feedback.Top.right-taken-wrong-night}', 13, 1, CURRENT_TIMESTAMP),
(365, 'Wrong Top right', '{spatial-feedback.TopRight.right-taken-wrong-day}+{spatial-feedback.TopRight.right-taken-wrong-night}', 15, 1, CURRENT_TIMESTAMP),
(365, '[diff]Correct Bottom left', '{spatial-feedback.BottomLeft.left-taken-correct-day}+{spatial-feedback.Bottom.left-taken-correct-day}+{spatial-feedback.Left.left-taken-correct-day}+{spatial-feedback.BottomLeft.left-taken-correct-night}+{spatial-feedback.Bottom.left-taken-correct-night}+{spatial-feedback.Left.left-taken-correct-night}', 2, 1, CURRENT_TIMESTAMP),
(365, '[diff]Correct Bottom right', '{spatial-feedback.BottomRight.left-taken-correct-day}+{spatial-feedback.Right.left-taken-correct-day}+{spatial-feedback.BottomRight.left-taken-correct-night}+{spatial-feedback.Right.left-taken-correct-night}', 4, 1, CURRENT_TIMESTAMP),
(365, '[diff]Correct Top left', '{spatial-feedback.TopLeft.left-taken-correct-day}+{spatial-feedback.Top.left-taken-correct-day}+{spatial-feedback.TopLeft.left-taken-correct-night}+{spatial-feedback.Top.left-taken-correct-night}', 6, 1, CURRENT_TIMESTAMP),
(365, '[diff]Correct Top right', '{spatial-feedback.TopRight.left-taken-correct-day}+{spatial-feedback.TopRight.left-taken-correct-night}', 8, 1, CURRENT_TIMESTAMP),
(365, '[diff]Wrong Bottom left', '{spatial-feedback.BottomLeft.left-taken-wrong-day}+{spatial-feedback.Bottom.left-taken-wrong-day}+{spatial-feedback.Left.left-taken-wrong-day}+{spatial-feedback.BottomLeft.left-taken-wrong-night}+{spatial-feedback.Bottom.left-taken-wrong-night}+{spatial-feedback.Left.left-taken-wrong-night}', 10, 1, CURRENT_TIMESTAMP),
(365, '[diff]Wrong Bottom right', '{spatial-feedback.BottomRight.left-taken-wrong-day}+{spatial-feedback.Right.left-taken-wrong-day}+{spatial-feedback.BottomRight.left-taken-wrong-night}+{spatial-feedback.Right.left-taken-wrong-night}', 12, 1, CURRENT_TIMESTAMP),
(365, '[diff]Wrong Top left', '{spatial-feedback.TopLeft.left-taken-wrong-day}+{spatial-feedback.Top.left-taken-wrong-day}+{spatial-feedback.TopLeft.left-taken-wrong-night}+{spatial-feedback.Top.left-taken-wrong-night}', 14, 1, CURRENT_TIMESTAMP),
(365, '[diff]Wrong Top right', '{spatial-feedback.TopRight.left-taken-wrong-day}+{spatial-feedback.TopRight.left-taken-wrong-night}', 16, 1, CURRENT_TIMESTAMP),
(366, 'Correct Bottom left', '{spatial-feedback.BottomLeft.left-taken-correct-day}+{spatial-feedback.Bottom.left-taken-correct-day}+{spatial-feedback.Left.left-taken-correct-day}+{spatial-feedback.BottomLeft.left-taken-correct-night}+{spatial-feedback.Bottom.left-taken-correct-night}+{spatial-feedback.Left.left-taken-correct-night}', 1, 1, CURRENT_TIMESTAMP),
(366, 'Correct Bottom right', '{spatial-feedback.BottomRight.left-taken-correct-day}+{spatial-feedback.Right.left-taken-correct-day}+{spatial-feedback.BottomRight.left-taken-correct-night}+{spatial-feedback.Right.left-taken-correct-night}', 3, 1, CURRENT_TIMESTAMP),
(366, 'Correct Top left', '{spatial-feedback.TopLeft.left-taken-correct-day}+{spatial-feedback.Top.left-taken-correct-day}+{spatial-feedback.TopLeft.left-taken-correct-night}+{spatial-feedback.Top.left-taken-correct-night}', 5, 1, CURRENT_TIMESTAMP),
(366, 'Correct Top right', '{spatial-feedback.TopRight.left-taken-correct-day}+{spatial-feedback.TopRight.left-taken-correct-night}', 7, 1, CURRENT_TIMESTAMP),
(366, 'Wrong Bottom left', '{spatial-feedback.BottomLeft.left-taken-wrong-day}+{spatial-feedback.Bottom.left-taken-wrong-day}+{spatial-feedback.Left.left-taken-wrong-day}', 9, 1, CURRENT_TIMESTAMP),
(366, 'Wrong Bottom right', '{spatial-feedback.BottomRight.left-taken-wrong-day}+{spatial-feedback.Right.left-taken-wrong-day}+{spatial-feedback.BottomRight.left-taken-wrong-night}+{spatial-feedback.Right.left-taken-wrong-night}', 11, 1, CURRENT_TIMESTAMP),
(366, 'Wrong Top left', '{spatial-feedback.TopLeft.left-taken-wrong-day}+{spatial-feedback.Top.left-taken-wrong-day}+{spatial-feedback.TopLeft.left-taken-wrong-night}+{spatial-feedback.Top.left-taken-wrong-night}', 13, 1, CURRENT_TIMESTAMP),
(366, 'Wrong Top right', '{spatial-feedback.TopRight.left-taken-wrong-day}+{spatial-feedback.TopRight.left-taken-wrong-night}', 15, 1, CURRENT_TIMESTAMP),
(366, '[diff]Correct Bottom left', '{spatial-feedback.BottomLeft.right-taken-correct-day}+{spatial-feedback.Bottom.right-taken-correct-day}+{spatial-feedback.Left.right-taken-correct-day}+{spatial-feedback.BottomLeft.right-taken-correct-night}+{spatial-feedback.Bottom.right-taken-correct-night}+{spatial-feedback.Left.right-taken-correct-night}', 2, 1, CURRENT_TIMESTAMP),
(366, '[diff]Correct Bottom right', '{spatial-feedback.BottomRight.right-taken-correct-day}+{spatial-feedback.Right.right-taken-correct-day}+{spatial-feedback.BottomRight.right-taken-correct-night}+{spatial-feedback.Right.right-taken-correct-night}', 4, 1, CURRENT_TIMESTAMP),
(366, '[diff]Correct Top left', '{spatial-feedback.TopLeft.right-taken-correct-day}+{spatial-feedback.Top.right-taken-correct-day}+{spatial-feedback.TopLeft.right-taken-correct-night}+{spatial-feedback.Top.right-taken-correct-night}', 6, 1, CURRENT_TIMESTAMP),
(366, '[diff]Correct Top right', '{spatial-feedback.TopRight.right-taken-correct-day}+{spatial-feedback.TopRight.right-taken-correct-night}', 8, 1, CURRENT_TIMESTAMP),
(366, '[diff]Wrong Bottom left', '{spatial-feedback.BottomLeft.right-taken-wrong-day}+{spatial-feedback.Bottom.right-taken-wrong-day}+{spatial-feedback.Left.right-taken-wrong-day}+{spatial-feedback.BottomLeft.right-taken-wrong-night}+{spatial-feedback.Bottom.right-taken-wrong-night}+{spatial-feedback.Left.right-taken-wrong-night}', 10, 1, CURRENT_TIMESTAMP),
(366, '[diff]Wrong Bottom right', '{spatial-feedback.BottomRight.right-taken-wrong-day}+{spatial-feedback.Right.right-taken-wrong-day}+{spatial-feedback.BottomRight.right-taken-wrong-night}+{spatial-feedback.Right.right-taken-wrong-night}', 12, 1, CURRENT_TIMESTAMP),
(366, '[diff]Wrong Top left', '{spatial-feedback.TopLeft.right-taken-wrong-day}+{spatial-feedback.Top.right-taken-wrong-day}+{spatial-feedback.TopLeft.right-taken-wrong-night}+{spatial-feedback.Top.right-taken-wrong-night}', 14, 1, CURRENT_TIMESTAMP),
(366, '[diff]Wrong Top right', '{spatial-feedback.TopRight.right-taken-wrong-day}+{spatial-feedback.TopRight.right-taken-wrong-night}', 16, 1, CURRENT_TIMESTAMP),
(367, 'Left day', '{feedback-over-time.left-taken-correct-day}', 1, 1, CURRENT_TIMESTAMP),
(367, 'Missed day', '{feedback-over-time.missed-correct-day}', 5, 1, CURRENT_TIMESTAMP),
(367, 'Right day', '{feedback-over-time.right-taken-correct-day}', 4, 1, CURRENT_TIMESTAMP),
(367, 'Left night', '{feedback-over-time.left-taken-correct-night}', 2, 1, CURRENT_TIMESTAMP),
(367, 'Missed night', '{feedback-over-time.missed-correct-night}', 6, 1, CURRENT_TIMESTAMP),
(367, 'Right night', '{feedback-over-time.right-taken-correct-night}', 3, 1, CURRENT_TIMESTAMP),
(368, 'Avoided day', '{feedback-over-time.avoided-wrong-day}', 1, 1, CURRENT_TIMESTAMP),
(368, 'Left day', '{feedback-over-time.left-taken-wrong-day}', 3, 1, CURRENT_TIMESTAMP),
(368, 'Right day', '{feedback-over-time.right-taken-wrong-day}', 5, 1, CURRENT_TIMESTAMP),
(368, 'Avoided night', '{feedback-over-time.avoided-wrong-night}', 2, 1, CURRENT_TIMESTAMP),
(368, 'Left night', '{feedback-over-time.left-taken-wrong-night}', 4, 1, CURRENT_TIMESTAMP),
(368, 'Right night', '{feedback-over-time.right-taken-wrong-night}', 6, 1, CURRENT_TIMESTAMP),
(369, 'Avoided day', '{avoided-wrong-day}', 1, 1, CURRENT_TIMESTAMP),
(369, 'Left day', '{left-taken-wrong-day}', 3, 1, CURRENT_TIMESTAMP),
(369, 'Right day', '{right-taken-wrong-day}', 5, 1, CURRENT_TIMESTAMP),
(369, 'Avoided night', '{avoided-wrong-night}', 2, 1, CURRENT_TIMESTAMP),
(369, 'Left night', '{left-taken-wrong-night}', 4, 1, CURRENT_TIMESTAMP),
(369, 'Right night', '{right-taken-wrong-night}', 6, 1, CURRENT_TIMESTAMP),
(369, 'x_axis', 'AUTO', 0, 1, CURRENT_TIMESTAMP),
(370, 'Left day', '{left-taken-correct}', 1, 1, CURRENT_TIMESTAMP),
(370, 'Missed day', '{missed-correct}', 5, 1, CURRENT_TIMESTAMP),
(370, 'Right day', '{right-taken-correct}', 3, 1, CURRENT_TIMESTAMP),
(370, 'Left night', '{left-taken-correct}', 2, 1, CURRENT_TIMESTAMP),
(370, 'Missed night', '{missed-correct}', 6, 1, CURRENT_TIMESTAMP),
(370, 'Right night', '{right-taken-correct}', 4, 1, CURRENT_TIMESTAMP),
(370, 'x_axis', 'AUTO', 0, 1, CURRENT_TIMESTAMP),
(371, 'Bottom left (left hand)', '{spatial-feedback.BottomLeft.left-taken-wrong-day}+{spatial-feedback.BottomLeft.left-taken-wrong-night}', 1, 1, CURRENT_TIMESTAMP),
(371, 'Bottom left (right hand)', '{spatial-feedback.BottomLeft.right-taken-wrong-day}+{spatial-feedback.BottomLeft.right-taken-wrong-night}', 1, 1, CURRENT_TIMESTAMP),
(371, 'Bottom right (left hand)', '{spatial-feedback.BottomRight.left-taken-wrong-day}+{spatial-feedback.BottomRight.left-taken-wrong-night}', 2, 1, CURRENT_TIMESTAMP),
(371, 'Bottom right (right hand)', '{spatial-feedback.BottomRight.right-taken-wrong-day}+{spatial-feedback.BottomRight.right-taken-wrong-night}', 2, 1, CURRENT_TIMESTAMP),
(371, 'Top left (left hand)', '{spatial-feedback.TopLeft.left-taken-wrong-day}+{spatial-feedback.TopLeft.left-taken-wrong-night}', 3, 1, CURRENT_TIMESTAMP),
(371, 'Top left (right hand)', '{spatial-feedback.TopLeft.right-taken-wrong-day}+{spatial-feedback.TopLeft.right-taken-wrong-night}', 3, 1, CURRENT_TIMESTAMP),
(371, 'Top right (left hand)', '{spatial-feedback.TopRight.left-taken-wrong-day}+{spatial-feedback.TopRight.left-taken-wrong-night}', 4, 1, CURRENT_TIMESTAMP),
(371, 'Top right (right hand)', '{spatial-feedback.TopRight.right-taken-wrong-day}+{spatial-feedback.TopRight.right-taken-wrong-night}', 4, 1, CURRENT_TIMESTAMP),
(371, 'x_axis', 'AUTO', 0, 1, CURRENT_TIMESTAMP),
(372, 'Bottom left (left hand)', '{spatial-feedback.BottomLeft.left-taken-correct-day}+{spatial-feedback.BottomLeft.left-taken-correct-night}', 1, 1, CURRENT_TIMESTAMP),
(372, 'Bottom left (right hand)', '{spatial-feedback.BottomLeft.right-taken-correct-day}+{spatial-feedback.BottomLeft.right-taken-correct-night}', 1, 1, CURRENT_TIMESTAMP),
(372, 'Bottom right (left hand)', '{spatial-feedback.BottomRight.left-taken-correct-day}+{spatial-feedback.BottomRight.left-taken-correct-night}', 2, 1, CURRENT_TIMESTAMP),
(372, 'Bottom right (right hand)', '{spatial-feedback.BottomRight.right-taken-correct-day}+{spatial-feedback.BottomRight.right-taken-correct-night}', 2, 1, CURRENT_TIMESTAMP),
(372, 'Top left (left hand)', '{spatial-feedback.TopLeft.left-taken-correct-day}+{spatial-feedback.TopLeft.left-taken-correct-night}', 3, 1, CURRENT_TIMESTAMP),
(372, 'Top left (right hand)', '{spatial-feedback.TopLeft.right-taken-correct-day}+{spatial-feedback.TopLeft.right-taken-correct-night}', 3, 1, CURRENT_TIMESTAMP),
(372, 'Top right (left hand)', '{spatial-feedback.TopRight.left-taken-correct-day}+{spatial-feedback.TopRight.left-taken-correct-night}', 4, 1, CURRENT_TIMESTAMP),
(372, 'Top right (right hand)', '{spatial-feedback.TopRight.right-taken-correct-day}+{spatial-feedback.TopRight.right-taken-correct-night}', 4, 1, CURRENT_TIMESTAMP),
(372, 'x_axis', 'AUTO', 0, 1, CURRENT_TIMESTAMP),
(373, 'Correct Bottom left', '{spatial-feedback.BottomLeft.taken-correct-day}+{spatial-feedback.Bottom.taken-correct-day}+{spatial-feedback.Left.taken-correct-day}+{spatial-feedback.BottomLeft.taken-correct-night}+{spatial-feedback.Bottom.taken-correct-night}+{spatial-feedback.Left.taken-correct-night}', 1, 1, CURRENT_TIMESTAMP),
(373, 'Correct Bottom right', '{spatial-feedback.BottomRight.taken-correct-day}+{spatial-feedback.Right.taken-correct-day}+{spatial-feedback.BottomRight.taken-correct-night}+{spatial-feedback.Right.taken-correct-night}', 3, 1, CURRENT_TIMESTAMP),
(373, 'Correct Top left', '{spatial-feedback.TopLeft.taken-correct-day}+{spatial-feedback.Top.taken-correct-day}+{spatial-feedback.TopLeft.taken-correct-night}+{spatial-feedback.Top.taken-correct-night}', 5, 1, CURRENT_TIMESTAMP),
(373, 'Correct Top right', '{spatial-feedback.TopRight.taken-correct-day}+{spatial-feedback.TopRight.taken-correct-night}', 7, 1, CURRENT_TIMESTAMP),
(373, 'Wrong Bottom left', '{spatial-feedback.BottomLeft.taken-wrong-day}+{spatial-feedback.Bottom.taken-wrong-day}+{spatial-feedback.Left.taken-wrong-day}+{spatial-feedback.BottomLeft.taken-wrong-night}+{spatial-feedback.Bottom.taken-wrong-night}+{spatial-feedback.Left.taken-wrong-night}', 9, 1, CURRENT_TIMESTAMP),
(373, 'Wrong Bottom right', '{spatial-feedback.BottomRight.taken-wrong-day}+{spatial-feedback.Right.taken-wrong-day}+{spatial-feedback.BottomRight.taken-wrong-night}+{spatial-feedback.Right.taken-wrong-night}', 11, 1, CURRENT_TIMESTAMP),
(373, 'Wrong Top left', '{spatial-feedback.TopLeft.taken-wrong-day}+{spatial-feedback.Top.taken-wrong-day}+{spatial-feedback.TopLeft.taken-wrong-night}+{spatial-feedback.Top.taken-wrong-night}', 13, 1, CURRENT_TIMESTAMP),
(373, 'Wrong Top right', '{spatial-feedback.TopRight.taken-wrong-day}+{spatial-feedback.TopRight.taken-wrong-night}', 15, 1, CURRENT_TIMESTAMP),
(373, '[diff]Correct Bottom left', '{spatial-feedback.BottomLeft.missed-correct-day}+{spatial-feedback.Bottom.missed-correct-day}+{spatial-feedback.Left.missed-correct-day}+{spatial-feedback.BottomLeft.missed-correct-night}+{spatial-feedback.Bottom.missed-correct-night}+{spatial-feedback.Left.missed-correct-night}', 2, 1, CURRENT_TIMESTAMP),
(373, '[diff]Correct Bottom right', '{spatial-feedback.BottomRight.missed-correct-day}+{spatial-feedback.Right.missed-correct-day}+{spatial-feedback.BottomRight.missed-correct-night}+{spatial-feedback.Right.missed-correct-night}', 4, 1, CURRENT_TIMESTAMP),
(373, '[diff]Correct Top left', '{spatial-feedback.TopLeft.missed-correct-day}+{spatial-feedback.Top.missed-correct-day}+{spatial-feedback.TopLeft.missed-correct-night}+{spatial-feedback.Top.missed-correct-night}', 6, 1, CURRENT_TIMESTAMP),
(373, '[diff]Correct Top right', '{spatial-feedback.TopRight.missed-correct-day}+{spatial-feedback.TopRight.missed-correct-night}', 8, 1, CURRENT_TIMESTAMP),
(373, '[diff]Wrong Bottom left', '{spatial-feedback.BottomLeft.avoided-wrong-day}+{spatial-feedback.Bottom.avoided-wrong-day}+{spatial-feedback.Left.avoided-wrong-day}+{spatial-feedback.BottomLeft.avoided-wrong-night}+{spatial-feedback.Bottom.avoided-wrong-night}+{spatial-feedback.Left.avoided-wrong-night}', 10, 1, CURRENT_TIMESTAMP),
(373, '[diff]Wrong Bottom right', '{spatial-feedback.BottomRight.avoided-wrong-day}+{spatial-feedback.Right.avoided-wrong-day}+{spatial-feedback.BottomRight.avoided-wrong-night}+{spatial-feedback.Right.avoided-wrong-night}', 12, 1, CURRENT_TIMESTAMP),
(373, '[diff]Wrong Top left', '{spatial-feedback.TopLeft.avoided-wrong-day}+{spatial-feedback.Top.avoided-wrong-day}+{spatial-feedback.TopLeft.avoided-wrong-night}+{spatial-feedback.Top.avoided-wrong-night}', 14, 1, CURRENT_TIMESTAMP),
(373, '[diff]Wrong Top right', '{spatial-feedback.TopRight.avoided-wrong-day}+{spatial-feedback.TopRight.avoided-wrong-night}', 16, 1, CURRENT_TIMESTAMP),
(374, '80%-100%', '({taken-correct-day}+{taken-correct-night}/({taken-correct-day}+{taken-correct-night}+{missed-correct-day}+{missed-correct-night})/{2})+({avoided-wrong-day}+{avoided-wrong-night}/({avoided-wrong-day}+{avoided-wrong-night}+{taken-wrong-day}+{taken-wrong-night})/{2})>{0.8}+{OLD}', 1, 1, CURRENT_TIMESTAMP),
(374, '60%-80%', '(({taken-correct-day}+{taken-correct-night}/({taken-correct-day}+{taken-correct-night}+{missed-correct-day}+{missed-correct-night})/{2})+({avoided-wrong-day}+{avoided-wrong-night}/({avoided-wrong-day}+{avoided-wrong-night}+{taken-wrong-day}+{taken-wrong-night})/{2})<{0.8})*(({taken-correct-day}+{taken-correct-night}/({taken-correct-day}+{taken-correct-night}+{missed-correct-day}+{missed-correct-night})/{2})+({avoided-wrong-day}+{avoided-wrong-night}/({avoided-wrong-day}+{avoided-wrong-night}+{taken-wrong-day}+{taken-wrong-night})/{2})>{0.6})+{OLD}', 2, 1, CURRENT_TIMESTAMP),
(374, '40%-60%', '(({taken-correct-day}+{taken-correct-night}/({taken-correct-day}+{taken-correct-night}+{missed-correct-day}+{missed-correct-night})/{2})+({avoided-wrong-day}+{avoided-wrong-night}/({avoided-wrong-day}+{avoided-wrong-night}+{taken-wrong-day}+{taken-wrong-night})/{2})<{0.6})*(({taken-correct-day}+{taken-correct-night}/({taken-correct-day}+{taken-correct-night}+{missed-correct-day}+{missed-correct-night})/{2})+({avoided-wrong-day}+{avoided-wrong-night}/({avoided-wrong-day}+{avoided-wrong-night}+{taken-wrong-day}+{taken-wrong-night})/{2})>{0.4})+{OLD}', 3, 1, CURRENT_TIMESTAMP),
(374, '20%-40%', '(({taken-correct-day}+{taken-correct-night}/({taken-correct-day}+{taken-correct-night}+{missed-correct-day}+{missed-correct-night})/{2})+({avoided-wrong-day}+{avoided-wrong-night}/({avoided-wrong-day}+{avoided-wrong-night}+{taken-wrong-day}+{taken-wrong-night})/{2})<{0.4})*(({taken-correct-day}+{taken-correct-night}/({taken-correct-day}+{taken-correct-night}+{missed-correct-day}+{missed-correct-night})/{2})+({avoided-wrong-day}+{avoided-wrong-night}/({avoided-wrong-day}+{avoided-wrong-night}+{taken-wrong-day}+{taken-wrong-night})/{2})>{0.2})+{OLD}', 4, 1, CURRENT_TIMESTAMP),
(374, '0%-20%', '({taken-correct-day}+{taken-correct-night}/({taken-correct-day}+{taken-correct-night}+{missed-correct-day}+{missed-correct-night})/{2})+({avoided-wrong-day}+{avoided-wrong-night}/({avoided-wrong-day}+{avoided-wrong-night}+{taken-wrong-day}+{taken-wrong-night})/{2})<{0.2}+{OLD}', 5, 1, CURRENT_TIMESTAMP),
(375, '80%-100%', '({taken-correct-day}+{taken-correct-night}/({taken-correct-day}+{taken-correct-night}+{missed-correct-day}+{missed-correct-night})/{2})+({avoided-wrong-day}+{avoided-wrong-night}/({avoided-wrong-day}+{avoided-wrong-night}+{taken-wrong-day}+{taken-wrong-night})/{2})>{0.8}+{OLD}', 1, 1, CURRENT_TIMESTAMP),
(375, '60%-80%', '(({taken-correct-day}+{taken-correct-night}/({taken-correct-day}+{taken-correct-night}+{missed-correct-day}+{missed-correct-night})/{2})+({avoided-wrong-day}+{avoided-wrong-night}/({avoided-wrong-day}+{avoided-wrong-night}+{taken-wrong-day}+{taken-wrong-night})/{2})<{0.8})*(({taken-correct-day}+{taken-correct-night}/({taken-correct-day}+{taken-correct-night}+{missed-correct-day}+{missed-correct-night})/{2})+({avoided-wrong-day}+{avoided-wrong-night}/({avoided-wrong-day}+{avoided-wrong-night}+{taken-wrong-day}+{taken-wrong-night})/{2})>{0.6})+{OLD}', 2, 1, CURRENT_TIMESTAMP),
(375, '40%-60%', '(({taken-correct-day}+{taken-correct-night}/({taken-correct-day}+{taken-correct-night}+{missed-correct-day}+{missed-correct-night})/{2})+({avoided-wrong-day}+{avoided-wrong-night}/({avoided-wrong-day}+{avoided-wrong-night}+{taken-wrong-day}+{taken-wrong-night})/{2})<{0.6})*(({taken-correct-day}+{taken-correct-night}/({taken-correct-day}+{taken-correct-night}+{missed-correct-day}+{missed-correct-night})/{2})+({avoided-wrong-day}+{avoided-wrong-night}/({avoided-wrong-day}+{avoided-wrong-night}+{taken-wrong-day}+{taken-wrong-night})/{2})>{0.4})+{OLD}', 3, 1, CURRENT_TIMESTAMP),
(375, '20%-40%', '(({taken-correct-day}+{taken-correct-night}/({taken-correct-day}+{taken-correct-night}+{missed-correct-day}+{missed-correct-night})/{2})+({avoided-wrong-day}+{avoided-wrong-night}/({avoided-wrong-day}+{avoided-wrong-night}+{taken-wrong-day}+{taken-wrong-night})/{2})<{0.4})*(({taken-correct-day}+{taken-correct-night}/({taken-correct-day}+{taken-correct-night}+{missed-correct-day}+{missed-correct-night})/{2})+({avoided-wrong-day}+{avoided-wrong-night}/({avoided-wrong-day}+{avoided-wrong-night}+{taken-wrong-day}+{taken-wrong-night})/{2})>{0.2})+{OLD}', 4, 1, CURRENT_TIMESTAMP),
(375, '0%-20%', '({taken-correct-day}+{taken-correct-night}/({taken-correct-day}+{taken-correct-night}+{missed-correct-day}+{missed-correct-night})/{2})+({avoided-wrong-day}+{avoided-wrong-night}/({avoided-wrong-day}+{avoided-wrong-night}+{taken-wrong-day}+{taken-wrong-night})/{2})<{0.2}+{OLD}', 5, 1, CURRENT_TIMESTAMP),
(375, 'x_axis', 'MONTHLY', 0, 1, CURRENT_TIMESTAMP),
(376, 'Density', '{input-parameters.density}', 1, 1, CURRENT_TIMESTAMP),
(376, 'Duration', '{input-parameters.duration}', 1, 1, CURRENT_TIMESTAMP),
(376, 'Proportion', '{input-parameters.proportion}', 1, 1, CURRENT_TIMESTAMP),
(376, 'Target', '{input-parameters.target}', 1, 1, CURRENT_TIMESTAMP),
(376, 'Stars to count', '{input-parameters.counter-elements}', 1, 1, CURRENT_TIMESTAMP),
(376, 'Velocity', '{input-parameters.velocity}', 1, 1, CURRENT_TIMESTAMP),
(376, 'x_axis', 'AUTO', 0, 1, CURRENT_TIMESTAMP),
(377, 'Stars appeared', '{stars-spawned}', 3, 1, CURRENT_TIMESTAMP),
(377, 'Reply (wrong)', '{correct-counter}={0}*{stars-counter}', 2, 1, CURRENT_TIMESTAMP),
(377, 'Reply (correct)', '{correct-counter}={1}*{stars-counter}', 1, 1, CURRENT_TIMESTAMP),
(378, 'Stars appeared', '{stars-spawned}', 3, 1, CURRENT_TIMESTAMP),
(378, 'Reply (wrong)', '{correct-counter}={0}*{stars-counter}', 2, 1, CURRENT_TIMESTAMP),
(378, 'Reply (correct)', '{correct-counter}={1}*{stars-counter}', 1, 1, CURRENT_TIMESTAMP),
(378, 'x_axis', 'AUTO', 0, 1, CURRENT_TIMESTAMP),
(379, 'Wrong', '{taken-wrong-flowers}', 2, 1, CURRENT_TIMESTAMP),
(379, 'Correct', '{taken-flowers}', 1, 1, CURRENT_TIMESTAMP),

(380, 'total', '{taken-flowers}+{taken-wrong-flowers}', 0, 1, CURRENT_TIMESTAMP),
(380, 'value', '{taken-flowers}', 0, 1, CURRENT_TIMESTAMP),

(381, 'Wrong Alternate', '{feedback-over-time.taken-wrong-flowers}', 2, 1, CURRENT_TIMESTAMP),
(381, 'Correct', '{feedback-over-time.taken-flowers}', 1, 1, CURRENT_TIMESTAMP),
(381, 'Wrong Avoided', '{feedback-over-time.total-bees}-{feedback-over-time.taken-bees}', 4, 1, CURRENT_TIMESTAMP),
(381, 'Wrong Taken', '{feedback-over-time.taken-bees}', 3, 1, CURRENT_TIMESTAMP),

(382, 'Missed', '{taken-wrong-flowers}', 2, 1, CURRENT_TIMESTAMP),
(382, 'Taken', '{taken-flowers}', 1, 1, CURRENT_TIMESTAMP),
(382, 'x_axis', 'AUTO', 0, 1, CURRENT_TIMESTAMP),

(383, 'Left', '{left-taken-flowers}', 1, 1, CURRENT_TIMESTAMP),
(383, 'Wrong Left', '{left-taken-wrong-flowers}', 3, 1, CURRENT_TIMESTAMP),
(383, 'Wrong Right', '{right-taken-wrong-flowers}', 4, 1, CURRENT_TIMESTAMP),
(383, 'Right', '{right-taken-flowers}', 2, 1, CURRENT_TIMESTAMP),
(384, 'Left', '{feedback-over-time.left-taken-flowers}', 1, 1, CURRENT_TIMESTAMP),
(384, 'Wrong Left', '{feedback-over-time.left-taken-wrong-flowers}', 3, 1, CURRENT_TIMESTAMP),
(384, 'Wrong Right', '{feedback-over-time.right-taken-wrong-flowers}', 4, 1, CURRENT_TIMESTAMP),
(384, 'Right', '{feedback-over-time.right-taken-flowers}', 2, 1, CURRENT_TIMESTAMP),

(385, 'Left', '{left-taken-flowers}', 1, 1, CURRENT_TIMESTAMP),
(385, 'Wrong Left', '{left-taken-wrong-flowers}', 3, 1, CURRENT_TIMESTAMP),
(385, 'Wrong Right', '{right-taken-wrong-flowers}', 4, 1, CURRENT_TIMESTAMP),
(385, 'Right', '{right-taken-flowers}', 2, 1, CURRENT_TIMESTAMP),
(385, 'x_axis', 'AUTO', 0, 1, CURRENT_TIMESTAMP),

(386, 'Correct Bottom left', '{spatial-feedback.BottomLeft.taken-flowers}+{spatial-feedback.Bottom.taken-flowers}+{spatial-feedback.Left.taken-flowers}', 1, 1, CURRENT_TIMESTAMP),
(386, 'Correct Bottom right', '{spatial-feedback.BottomRight.taken-flowers}+{spatial-feedback.Right.taken-flowers}', 3, 1, CURRENT_TIMESTAMP),
(386, 'Correct Top left', '{spatial-feedback.TopLeft.taken-flowers}+{spatial-feedback.Top.taken-flowers}', 5, 1, CURRENT_TIMESTAMP),
(386, 'Correct Top right', '{spatial-feedback.TopRight.taken-flowers}', 7, 1, CURRENT_TIMESTAMP),
(386, 'Wrong Bottom left', '{spatial-feedback.BottomLeft.taken-bees}+{spatial-feedback.Bottom.taken-bees}+{spatial-feedback.Left.taken-bees}', 9, 1, CURRENT_TIMESTAMP),
(386, 'Wrong Bottom right', '{spatial-feedback.BottomRight.taken-bees}+{spatial-feedback.Right.taken-bees}', 11, 1, CURRENT_TIMESTAMP),
(386, 'Wrong Top left', '{spatial-feedback.TopLeft.taken-bees}+{spatial-feedback.Top.taken-bees}', 13, 1, CURRENT_TIMESTAMP),
(386, 'Wrong Top right', '{spatial-feedback.TopRight.taken-bees}', 15, 1, CURRENT_TIMESTAMP),
(386, '[diff]Correct Bottom left', '{spatial-feedback.BottomLeft.taken-wrong-flowers}+{spatial-feedback.Bottom.taken-wrong-flowers}+{spatial-feedback.Left.taken-wrong-flowers}', 2, 1, CURRENT_TIMESTAMP),
(386, '[diff]Correct Bottom right', '{spatial-feedback.BottomRight.taken-wrong-flowers}+{spatial-feedback.Right.taken-wrong-flowers}', 4, 1, CURRENT_TIMESTAMP),
(386, '[diff]Correct Top left', '{spatial-feedback.TopLeft.taken-wrong-flowers}+{spatial-feedback.Top.taken-wrong-flowers}', 6, 1, CURRENT_TIMESTAMP),
(386, '[diff]Correct Top right', '{spatial-feedback.TopRight.taken-wrong-flowers}', 8, 1, CURRENT_TIMESTAMP),
(386, '[diff]Wrong Bottom left', '{spatial-feedback.BottomLeft.total-bees}+{spatial-feedback.Bottom.total-bees}+{spatial-feedback.Left.total-bees}-{spatial-feedback.BottomLeft.taken-bees}-{spatial-feedback.Bottom.taken-bees}-{spatial-feedback.Left.taken-bees}', 10, 1, CURRENT_TIMESTAMP),
(386, '[diff]Wrong Bottom right', '{spatial-feedback.BottomRight.total-bees}+{spatial-feedback.Right.total-bees}-{spatial-feedback.BottomRight.taken-bees}-{spatial-feedback.Right.taken-bees}', 12, 1, CURRENT_TIMESTAMP),
(386, '[diff]Wrong Top left', '{spatial-feedback.TopLeft.total-bees}+{spatial-feedback.Top.total-bees}-{spatial-feedback.TopLeft.taken-bees}-{spatial-feedback.Top.taken-bees}', 14, 1, CURRENT_TIMESTAMP),
(386, '[diff]Wrong Top right', '{spatial-feedback.TopRight.total-bees}-{spatial-feedback.TopRight.taken-bees}', 16, 1, CURRENT_TIMESTAMP),

(387, '80%-100%', '({taken-flowers}/({taken-flowers}+{taken-wrong-flowers})/{2})+({total-bees}-{taken-bees}/{total-bees}/{2})>{0.8}+{OLD}', 1, 1, CURRENT_TIMESTAMP),
(387, '60%-80%', '(({taken-flowers}/({taken-flowers}+{taken-wrong-flowers})/{2})+({total-bees}-{taken-bees}/{total-bees}/{2})<{0.8})*(({taken-flowers}/({taken-flowers}+{taken-wrong-flowers})/{2})+({total-bees}-{taken-bees}/{total-bees}/{2})>{0.6})+{OLD}', 2, 1, CURRENT_TIMESTAMP),
(387, '40%-60%', '(({taken-flowers}/({taken-flowers}+{taken-wrong-flowers})/{2})+({total-bees}-{taken-bees}/{total-bees}/{2})<{0.6})*(({taken-flowers}/({taken-flowers}+{taken-wrong-flowers})/{2})+({total-bees}-{taken-bees}/{total-bees}/{2})>{0.4})+{OLD}', 3, 1, CURRENT_TIMESTAMP),
(387, '20%-40%', '(({taken-flowers}/({taken-flowers}+{taken-wrong-flowers})/{2})+({total-bees}-{taken-bees}/{total-bees}/{2})<{0.4})*(({taken-flowers}/({taken-flowers}+{taken-wrong-flowers})/{2})+({total-bees}-{taken-bees}/{total-bees}/{2})>{0.2})+{OLD}', 4, 1, CURRENT_TIMESTAMP),
(387, '0%-20%', '({taken-flowers}/({taken-flowers}+{taken-wrong-flowers})/{2})+({total-bees}-{taken-bees}/{total-bees}/{2})<{0.2}+{OLD}', 5, 1, CURRENT_TIMESTAMP),

(388, '80%-100%', '({taken-flowers}/({taken-flowers}+{taken-wrong-flowers})/{2})+({total-bees}-{taken-bees}/{total-bees}/{2})>{0.8}+{OLD}', 1, 1, CURRENT_TIMESTAMP),
(388, '60%-80%', '(({taken-flowers}/({taken-flowers}+{taken-wrong-flowers})/{2})+({total-bees}-{taken-bees}/{total-bees}/{2})<{0.8})*(({taken-flowers}/({taken-flowers}+{taken-wrong-flowers})/{2})+({total-bees}-{taken-bees}/{total-bees}/{2})>{0.6})+{OLD}', 2, 1, CURRENT_TIMESTAMP),
(388, '40%-60%', '(({taken-flowers}/({taken-flowers}+{taken-wrong-flowers})/{2})+({total-bees}-{taken-bees}/{total-bees}/{2})<{0.6})*(({taken-flowers}/({taken-flowers}+{taken-wrong-flowers})/{2})+({total-bees}-{taken-bees}/{total-bees}/{2})>{0.4})+{OLD}', 3, 1, CURRENT_TIMESTAMP),
(388, '20%-40%', '(({taken-flowers}/({taken-flowers}+{taken-wrong-flowers})/{2})+({total-bees}-{taken-bees}/{total-bees}/{2})<{0.4})*(({taken-flowers}/({taken-flowers}+{taken-wrong-flowers})/{2})+({total-bees}-{taken-bees}/{total-bees}/{2})>{0.2})+{OLD}', 4, 1, CURRENT_TIMESTAMP),
(388, '0%-20%', '({taken-flowers}/({taken-flowers}+{taken-wrong-flowers})/{2})+({total-bees}-{taken-bees}/{total-bees}/{2})<{0.2}+{OLD}', 5, 1, CURRENT_TIMESTAMP),
(388, 'x_axis', 'MONTHLY', 0, 1, CURRENT_TIMESTAMP),

(389, 'Avoided', '{correct-top}+{correct-bottom}+{correct-center}+{correct-left}+{correct-right}', 1, 1, CURRENT_TIMESTAMP),
(389, 'Hit', '{wrong-top}+{wrong-bottom}+{wrong-center}+{wrong-left}+{wrong-right}', 2, 1, CURRENT_TIMESTAMP),

(390, 'Bottom', '{correct-bottom}', 3, 1, CURRENT_TIMESTAMP),
(390, 'Top', '{correct-top}', 1, 1, CURRENT_TIMESTAMP),
(390, '[diff]Bottom', '{wrong-bottom}', 4, 1, CURRENT_TIMESTAMP),
(390, '[diff]Top', '{wrong-top}', 2, 1, CURRENT_TIMESTAMP),
(390, 'Center', '{correct-center}', 5, 1, CURRENT_TIMESTAMP),
(390, '[diff]Center', '{wrong-center}', 6, 1, CURRENT_TIMESTAMP),
(390, 'Left', '{correct-left}', 7, 1, CURRENT_TIMESTAMP),
(390, '[diff]Left', '{wrong-left}', 8, 1, CURRENT_TIMESTAMP),
(390, 'Right', '{correct-right}', 9, 1, CURRENT_TIMESTAMP),
(390, '[diff]Right', '{wrong-right}', 10, 1, CURRENT_TIMESTAMP),

(391, 'Correct bottom', '{correct-bottom}', 2, 1, CURRENT_TIMESTAMP),
(391, 'Correct top', '{correct-top}', 1, 1, CURRENT_TIMESTAMP),
(391, 'Correct center', '{correct-center}', 4, 1, CURRENT_TIMESTAMP),
(391, 'Correct left', '{correct-left}', 5, 1, CURRENT_TIMESTAMP),
(391, 'Correct right', '{correct-right}', 5, 1, CURRENT_TIMESTAMP),
(391, 'Wrong bottom', '{wrong-bottom}', 7, 1, CURRENT_TIMESTAMP),
(391, 'Wrong top', '{wrong-top}', 6, 1, CURRENT_TIMESTAMP),
(391, 'Wrong center', '{wrong-center}', 8, 1, CURRENT_TIMESTAMP),
(391, 'Wrong left', '{wrong-left}', 9, 1, CURRENT_TIMESTAMP),
(391, 'Wrong right', '{wrong-right}', 10, 1, CURRENT_TIMESTAMP),
(391, 'x_axis', 'AUTO', 0, 1, CURRENT_TIMESTAMP),

(392, 'correct bottom', '{feedback-over-time.correct-bottom}', 2, 1, CURRENT_TIMESTAMP),
(392, 'correct top', '{feedback-over-time.correct-top}', 1, 1, CURRENT_TIMESTAMP),
(392, 'correct center', '{feedback-over-time.correct-center}', 3, 1, CURRENT_TIMESTAMP),
(392, 'correct left', '{feedback-over-time.correct-left}', 4, 1, CURRENT_TIMESTAMP),
(392, 'correct right', '{feedback-over-time.correct-right}', 5, 1, CURRENT_TIMESTAMP),
(392, 'wrong bottom', '{feedback-over-time.wrong-bottom}',7, 1, CURRENT_TIMESTAMP),
(392, 'wrong top', '{feedback-over-time.wrong-top}', 6, 1, CURRENT_TIMESTAMP),
(392, 'wrong center', '{feedback-over-time.wrong-center}',8, 1, CURRENT_TIMESTAMP),
(392, 'wrong left', '{feedback-over-time.wrong-left}', 9, 1, CURRENT_TIMESTAMP),
(392, 'wrong right', '{feedback-over-time.wrong-right}', 10, 1, CURRENT_TIMESTAMP),

(393, 'Correct', '{correct-top}+{correct-bottom}+{correct-center}+{correct-left}+{correct-right}', 1, 1, CURRENT_TIMESTAMP),
(393, 'Wrong', '{wrong-top}+{wrong-bottom}+{wrong-center}+{wrong-left}+{wrong-right}', 2, 1, CURRENT_TIMESTAMP),
(393, 'x_axis', 'AUTO', 0, 1, CURRENT_TIMESTAMP),

(394, '80%-100%', '({correct-top}+{correct-bottom}+{correct-center}+{correct-left}+{correct-right})/({correct-top}+{wrong-top}+{correct-bottom}+{wrong-bottom}+{correct-center}+{wrong-center}+{correct-left}+{wrong-left}+{correct-right}+{wrong-right})>{0.8}+{OLD}', 1, 1, CURRENT_TIMESTAMP),
(394, '60%-80%', '(({correct-top}+{correct-bottom}+{correct-center}+{correct-left}+{correct-right})/({correct-top}+{wrong-top}+{correct-bottom}+{wrong-bottom}+{correct-center}+{wrong-center}+{correct-left}+{wrong-left}+{correct-right}+{wrong-right})<{0.8})*(({correct-top}+{correct-bottom}+{correct-center}+{correct-left}+{correct-right})/({correct-top}+{wrong-top}+{correct-bottom}+{wrong-bottom}+{correct-center}+{wrong-center}+{correct-left}+{wrong-left}+{correct-right}+{wrong-right})>{0.6})+{OLD}', 2, 1, CURRENT_TIMESTAMP),
(394, '40%-60%', '(({correct-top}+{correct-bottom}+{correct-center}+{correct-left}+{correct-right})/({correct-top}+{wrong-top}+{correct-bottom}+{wrong-bottom}+{correct-center}+{wrong-center}+{correct-left}+{wrong-left}+{correct-right}+{wrong-right})<{0.6})*(({correct-top}+{correct-bottom}+{correct-center}+{correct-left}+{correct-right})/({correct-top}+{wrong-top}+{correct-bottom}+{wrong-bottom}+{correct-center}+{wrong-center}+{correct-left}+{wrong-left}+{correct-right}+{wrong-right})>{0.4})+{OLD}', 3, 1, CURRENT_TIMESTAMP),
(394, '20%-40%', '(({correct-top}+{correct-bottom}+{correct-center}+{correct-left}+{correct-right})/({correct-top}+{wrong-top}+{correct-bottom}+{wrong-bottom}+{correct-center}+{wrong-center}+{correct-left}+{wrong-left}+{correct-right}+{wrong-right})<{0.4})*(({correct-top}+{correct-bottom}+{correct-center}+{correct-left}+{correct-right})/({correct-top}+{wrong-top}+{correct-bottom}+{wrong-bottom}+{correct-center}+{wrong-center}+{correct-left}+{wrong-left}+{correct-right}+{wrong-right})>{0.2})+{OLD}', 4, 1, CURRENT_TIMESTAMP),
(394, '0%-20%', '({correct-top}+{correct-bottom}+{correct-center}+{correct-left}+{correct-right})/({correct-top}+{wrong-top}+{correct-bottom}+{wrong-bottom}+{correct-center}+{wrong-center}+{correct-left}+{wrong-left}+{correct-right}+{wrong-right})<{0.2}+{OLD}', 5, 1, CURRENT_TIMESTAMP),

(395, '80%-100%', '({correct-top}+{correct-bottom}+{correct-center}+{correct-left}+{correct-right})/({correct-top}+{wrong-top}+{correct-bottom}+{wrong-bottom}+{correct-center}+{wrong-center}+{correct-left}+{wrong-left}+{correct-right}+{wrong-right})>{0.8}+{OLD}', 1, 1, CURRENT_TIMESTAMP),
(395, '60%-80%', '(({correct-top}+{correct-bottom}+{correct-center}+{correct-left}+{correct-right})/({correct-top}+{wrong-top}+{correct-bottom}+{wrong-bottom}+{correct-center}+{wrong-center}+{correct-left}+{wrong-left}+{correct-right}+{wrong-right})<{0.8})*(({correct-top}+{correct-bottom}+{correct-center}+{correct-left}+{correct-right})/({correct-top}+{wrong-top}+{correct-bottom}+{wrong-bottom}+{correct-center}+{wrong-center}+{correct-left}+{wrong-left}+{correct-right}+{wrong-right})>{0.6})+{OLD}', 2, 1, CURRENT_TIMESTAMP),
(395, '40%-60%', '(({correct-top}+{correct-bottom}+{correct-center}+{correct-left}+{correct-right})/({correct-top}+{wrong-top}+{correct-bottom}+{wrong-bottom}+{correct-center}+{wrong-center}+{correct-left}+{wrong-left}+{correct-right}+{wrong-right})<{0.6})*(({correct-top}+{correct-bottom}+{correct-center}+{correct-left}+{correct-right})/({correct-top}+{wrong-top}+{correct-bottom}+{wrong-bottom}+{correct-center}+{wrong-center}+{correct-left}+{wrong-left}+{correct-right}+{wrong-right})>{0.4})+{OLD}', 3, 1, CURRENT_TIMESTAMP),
(395, '20%-40%', '(({correct-top}+{correct-bottom}+{correct-center}+{correct-left}+{correct-right})/({correct-top}+{wrong-top}+{correct-bottom}+{wrong-bottom}+{correct-center}+{wrong-center}+{correct-left}+{wrong-left}+{correct-right}+{wrong-right})<{0.4})*(({correct-top}+{correct-bottom}+{correct-center}+{correct-left}+{correct-right})/({correct-top}+{wrong-top}+{correct-bottom}+{wrong-bottom}+{correct-center}+{wrong-center}+{correct-left}+{wrong-left}+{correct-right}+{wrong-right})>{0.2})+{OLD}', 4, 1, CURRENT_TIMESTAMP),
(395, '0%-20%', '({correct-top}+{correct-bottom}+{correct-center}+{correct-left}+{correct-right})/({correct-top}+{wrong-top}+{correct-bottom}+{wrong-bottom}+{correct-center}+{wrong-center}+{correct-left}+{wrong-left}+{correct-right}+{wrong-right})<{0.2}+{OLD}', 5, 1, CURRENT_TIMESTAMP),
(395, 'x_axis', 'MONTHLY', 0, 1, CURRENT_TIMESTAMP),

(396, 'Correct', '{taken-correct}', 1, 1, CURRENT_TIMESTAMP),
(396, 'Wrong Alternate', '{taken-wrong}', 2, 1, CURRENT_TIMESTAMP),

(397, 'Correct Back Left', '{feedback-by-target.back-left.taken-correct}', 3, 1, CURRENT_TIMESTAMP),
(397, 'Correct Back Left Corner', '{feedback-by-target.back-left-corner.taken-correct}', 1, 1, CURRENT_TIMESTAMP),
(397, 'Correct Back Right', '{feedback-by-target.back-right.taken-correct}', 5, 1, CURRENT_TIMESTAMP),
(397, 'Correct Back Right Corner', '{feedback-by-target.back-right-corner.taken-correct}', 7, 1, CURRENT_TIMESTAMP),
(397, 'Correct Front Left', '{feedback-by-target.front-left.taken-correct}', 15, 1, CURRENT_TIMESTAMP),
(397, 'Correct Front Left Corner', '{feedback-by-target.front-left-corner.taken-correct}', 13, 1, CURRENT_TIMESTAMP),
(397, 'Correct Front Right', '{feedback-by-target.front-right.taken-correct}', 17, 1, CURRENT_TIMESTAMP),
(397, 'Correct Front Right Corner', '{feedback-by-target.front-right-corner.taken-correct}', 19, 1, CURRENT_TIMESTAMP),
(397, 'Correct Left', '{feedback-by-target.left.taken-correct}', 9, 1, CURRENT_TIMESTAMP),
(397, 'Correct Right', '{feedback-by-target.right.taken-correct}', 11, 1, CURRENT_TIMESTAMP),
(397, 'Wrong Back Left', '{feedback-by-target.back-left.taken-distractor}', 23, 1, CURRENT_TIMESTAMP),
(397, 'Wrong Back Left Corner', '{feedback-by-target.back-left-corner.taken-distractor}', 21, 1, CURRENT_TIMESTAMP),
(397, 'Wrong Back Right', '{feedback-by-target.back-right.taken-distractor}', 25, 1, CURRENT_TIMESTAMP),
(397, 'Wrong Back Right Corner', '{feedback-by-target.back-right-corner.taken-distractor}', 27, 1, CURRENT_TIMESTAMP),
(397, 'Wrong Front Left', '{feedback-by-target.front-left.taken-distractor}', 35, 1, CURRENT_TIMESTAMP),
(397, 'Wrong Front Left Corner', '{feedback-by-target.front-left-corner.taken-distractor}', 33, 1, CURRENT_TIMESTAMP),
(397, 'Wrong Front Right', '{feedback-by-target.front-right.taken-distractor}', 37, 1, CURRENT_TIMESTAMP),
(397, 'Wrong Front Right Corner', '{feedback-by-target.front-right-corner.taken-distractor}', 39, 1, CURRENT_TIMESTAMP),
(397, 'Wrong Left', '{feedback-by-target.left.taken-distractor}', 29, 1, CURRENT_TIMESTAMP),
(397, 'Wrong Right', '{feedback-by-target.right.taken-distractor}', 31, 1, CURRENT_TIMESTAMP),
(397, '[diff]Correct Back Left', '{feedback-by-target.back-left.taken-wrong}', 4, 1, CURRENT_TIMESTAMP),
(397, '[diff]Correct Back Left Corner', '{feedback-by-target.back-left-corner.taken-wrong}', 2, 1, CURRENT_TIMESTAMP),
(397, '[diff]Correct Back Right', '{feedback-by-target.back-right.taken-wrong}', 6, 1, CURRENT_TIMESTAMP),
(397, '[diff]Correct Back Right Corner', '{feedback-by-target.back-right-corner.taken-wrong}', 8, 1, CURRENT_TIMESTAMP),
(397, '[diff]Correct Front Left', '{feedback-by-target.front-left.taken-wrong}', 16, 1, CURRENT_TIMESTAMP),
(397, '[diff]Correct Front Left Corner', '{feedback-by-target.front-left-corner.taken-wrong}', 14, 1, CURRENT_TIMESTAMP),
(397, '[diff]Correct Front Right', '{feedback-by-target.front-right.taken-wrong}', 18, 1, CURRENT_TIMESTAMP),
(397, '[diff]Correct Front Right Corner', '{feedback-by-target.front-right-corner.taken-wrong}', 20, 1, CURRENT_TIMESTAMP),
(397, '[diff]Correct Left', '{feedback-by-target.left.taken-wrong}', 10, 1, CURRENT_TIMESTAMP),
(397, '[diff]Correct Right', '{feedback-by-target.right.taken-wrong}', 12, 1, CURRENT_TIMESTAMP),
(397, '[diff]Wrong Back Left', '{feedback-by-target.back-left.total-distractor}-{feedback-by-target.back-left.taken-distractor}', 24, 1, CURRENT_TIMESTAMP),
(397, '[diff]Wrong Back Left Corner', '{feedback-by-target.back-left-corner.total-distractor}-{feedback-by-target.back-left-corner.taken-distractor}', 22, 1, CURRENT_TIMESTAMP),
(397, '[diff]Wrong Back Right', '{feedback-by-target.back-right.total-distractor}-{feedback-by-target.back-right.taken-distractor}', 26, 1, CURRENT_TIMESTAMP),
(397, '[diff]Wrong Back Right Corner', '{feedback-by-target.back-right-corner.total-distractor}-{feedback-by-target.back-right-corner.taken-distractor}', 28, 1, CURRENT_TIMESTAMP),
(397, '[diff]Wrong Front Left', '{feedback-by-target.front-left.total-distractor}-{feedback-by-target.front-left.taken-distractor}', 36, 1, CURRENT_TIMESTAMP),
(397, '[diff]Wrong Front Left Corner', '{feedback-by-target.front-left-corner.total-distractor}-{feedback-by-target.front-left-corner.taken-distractor}', 34, 1, CURRENT_TIMESTAMP),
(397, '[diff]Wrong Front Right', '{feedback-by-target.front-right.total-distractor}-{feedback-by-target.front-right.taken-distractor}', 38, 1, CURRENT_TIMESTAMP),
(397, '[diff]Wrong Front Right Corner', '{feedback-by-target.front-right-corner.total-distractor}-{feedback-by-target.front-right-corner.taken-distractor}', 40, 1, CURRENT_TIMESTAMP),
(397, '[diff]Wrong Left', '{feedback-by-target.left.total-distractor}-{feedback-by-target.left.taken-distractor}', 30, 1, CURRENT_TIMESTAMP),
(397, '[diff]Wrong Right', '{feedback-by-target.right.total-distractor}-{feedback-by-target.right.taken-distractor}', 32, 1, CURRENT_TIMESTAMP),

(398, 'Caught', '{taken-correct}', 1, 1, CURRENT_TIMESTAMP),
(398, 'Missed', '{taken-wrong}', 2, 1, CURRENT_TIMESTAMP),
(398, 'x_axis', 'AUTO', 0, 1, CURRENT_TIMESTAMP),

(399, 'Correct wrongly taken', '{feedback-over-time.taken-wrong}', 2, 1, CURRENT_TIMESTAMP),
(399, 'Correct taken', '{feedback-over-time.taken-correct}', 1, 1, CURRENT_TIMESTAMP),
(399, 'Wrong avoided', '{feedback-over-time.total-distractor}-{feedback-over-time.taken-distractor}', 4, 1, CURRENT_TIMESTAMP),
(399, 'Wrong taken', '{feedback-over-time.taken-distractor}', 3, 1, CURRENT_TIMESTAMP),

(400, '80%-100%', '({taken-correct}/({taken-correct}+{taken-wrong})/{2})+({total-distractor}-{taken-distractor}/{total-distractor}/{2})>{0.8}+{OLD}', 1, 1, CURRENT_TIMESTAMP),
(400, '60%-80%', '(({taken-correct}/({taken-correct}+{taken-wrong})/{2})+({total-distractor}-{taken-distractor}/{total-distractor}/{2})<{0.8})*(({taken-correct}/({taken-correct}+{taken-wrong})/{2})+({total-distractor}-{taken-distractor}/{total-distractor}/{2})>{0.6})+{OLD}', 2, 1, CURRENT_TIMESTAMP),
(400, '40%-60%', '(({taken-correct}/({taken-correct}+{taken-wrong})/{2})+({total-distractor}-{taken-distractor}/{total-distractor}/{2})<{0.6})*(({taken-correct}/({taken-correct}+{taken-wrong})/{2})+({total-distractor}-{taken-distractor}/{total-distractor}/{2})>{0.4})+{OLD}', 3, 1, CURRENT_TIMESTAMP),
(400, '20%-40%', '(({taken-correct}/({taken-correct}+{taken-wrong})/{2})+({total-distractor}-{taken-distractor}/{total-distractor}/{2})<{0.4})*(({taken-correct}/({taken-correct}+{taken-wrong})/{2})+({total-distractor}-{taken-distractor}/{total-distractor}/{2})>{0.2})+{OLD}', 4, 1, CURRENT_TIMESTAMP),
(400, '0%-20%', '({taken-correct}/({taken-correct}+{taken-wrong})/{2})+({total-distractor}-{taken-distractor}/{total-distractor}/{2})<{0.2}+{OLD}', 5, 1, CURRENT_TIMESTAMP),

(401, '80%-100%', '({taken-correct}/({taken-correct}+{taken-wrong})/{2})+({total-distractor}-{taken-distractor}/{total-distractor}/{2})>{0.8}+{OLD}', 1, 1, CURRENT_TIMESTAMP),
(401, '60%-80%', '(({taken-correct}/({taken-correct}+{taken-wrong})/{2})+({total-distractor}-{taken-distractor}/{total-distractor}/{2})<{0.8})*(({taken-correct}/({taken-correct}+{taken-wrong})/{2})+({total-distractor}-{taken-distractor}/{total-distractor}/{2})>{0.6})+{OLD}', 2, 1, CURRENT_TIMESTAMP),
(401, '40%-60%', '(({taken-correct}/({taken-correct}+{taken-wrong})/{2})+({total-distractor}-{taken-distractor}/{total-distractor}/{2})<{0.6})*(({taken-correct}/({taken-correct}+{taken-wrong})/{2})+({total-distractor}-{taken-distractor}/{total-distractor}/{2})>{0.4})+{OLD}', 3, 1, CURRENT_TIMESTAMP),
(401, '20%-40%', '(({taken-correct}/({taken-correct}+{taken-wrong})/{2})+({total-distractor}-{taken-distractor}/{total-distractor}/{2})<{0.4})*(({taken-correct}/({taken-correct}+{taken-wrong})/{2})+({total-distractor}-{taken-distractor}/{total-distractor}/{2})>{0.2})+{OLD}', 4, 1, CURRENT_TIMESTAMP),
(401, '0%-20%', '({taken-correct}/({taken-correct}+{taken-wrong})/{2})+({total-distractor}-{taken-distractor}/{total-distractor}/{2})<{0.2}+{OLD}', 5, 1, CURRENT_TIMESTAMP),
(401, 'x_axis', 'MONTHLY', 0, 1, CURRENT_TIMESTAMP);
 
INSERT INTO `ima_chart_template_option` (`Chart_Template_ID`, `Name`, `Value`, `Active`, `Last_Edit`) VALUES
(354, 'color-schema', 'double_dual', 1, CURRENT_TIMESTAMP),
(356, 'color-schema', 'double_dual', 1, CURRENT_TIMESTAMP),
(357, 'color-schema', 'double_diff', 1, CURRENT_TIMESTAMP),
(357, 'groupby', '2', 1, CURRENT_TIMESTAMP),
(357, 'time-interval', '5', 1, CURRENT_TIMESTAMP),
(358, 'color-schema', 'double_dual', 1, CURRENT_TIMESTAMP),
(359, 'color-schema', 'double_dual', 1, CURRENT_TIMESTAMP),
(360, 'color-schema', 'negative', 1, CURRENT_TIMESTAMP),
(361, 'color-schema', 'positive', 1, CURRENT_TIMESTAMP),
(362, 'y-axis-label', 'variations', 1, CURRENT_TIMESTAMP),
(363, 'check', '{input-parameters.hand}={\"both\"}', 1, CURRENT_TIMESTAMP),
(363, 'color-schema', 'double_dual', 1, CURRENT_TIMESTAMP),
(363, 'device', '1,6', 1, CURRENT_TIMESTAMP),
(364, 'check', '{input-parameters.hand}={\"both\"}', 1, CURRENT_TIMESTAMP),
(364, 'color-schema', 'double_dual_neg', 1, CURRENT_TIMESTAMP),
(364, 'device', '1,6', 1, CURRENT_TIMESTAMP),
(365, 'check', '{input-parameters.hand}={\"both\"}', 1, CURRENT_TIMESTAMP),
(365, 'color-schema', 'quadrants_diff', 1, CURRENT_TIMESTAMP),
(365, 'device', '1,6', 1, CURRENT_TIMESTAMP),
(365, 'type', 'double_diff', 1, CURRENT_TIMESTAMP),
(366, 'check', '{input-parameters.hand}={\"both\"}', 1, CURRENT_TIMESTAMP),
(366, 'color-schema', 'quadrants_diff', 1, CURRENT_TIMESTAMP),
(366, 'device', '1,6', 1, CURRENT_TIMESTAMP),
(366, 'type', 'double_diff', 1, CURRENT_TIMESTAMP),
(367, 'check', '{input-parameters.hand}={\"both\"}', 1, CURRENT_TIMESTAMP),
(367, 'color-schema', 'double_dual', 1, CURRENT_TIMESTAMP),
(367, 'device', '1,6', 1, CURRENT_TIMESTAMP),
(367, 'time-interval', '5', 1, CURRENT_TIMESTAMP),
(368, 'check', '{input-parameters.hand}={\"both\"}', 1, CURRENT_TIMESTAMP),
(368, 'color-schema', 'double_dual_neg', 1, CURRENT_TIMESTAMP),
(368, 'device', '1,6', 1, CURRENT_TIMESTAMP),
(368, 'time-interval', '5', 1, CURRENT_TIMESTAMP),
(369, 'check', '{input-parameters.hand}={\"both\"}', 1, CURRENT_TIMESTAMP),
(369, 'color-schema', 'double_dual_neg', 1, CURRENT_TIMESTAMP),
(369, 'device', '1,6', 1, CURRENT_TIMESTAMP),
(370, 'check', '{input-parameters.hand}={\"both\"}', 1, CURRENT_TIMESTAMP),
(370, 'color-schema', 'double_dual', 1, CURRENT_TIMESTAMP),
(370, 'device', '1,6', 1, CURRENT_TIMESTAMP),
(371, 'check', '{input-parameters.hand}={\"both\"}', 1, CURRENT_TIMESTAMP),
(371, 'color-schema', 'negative', 1, CURRENT_TIMESTAMP),
(371, 'device', '1,6', 1, CURRENT_TIMESTAMP),
(372, 'check', '{input-parameters.hand}={\"both\"}', 1, CURRENT_TIMESTAMP),
(372, 'color-schema', 'positive', 1, CURRENT_TIMESTAMP),
(372, 'device', '1,6', 1, CURRENT_TIMESTAMP),
(373, 'color-schema', 'quadrants_diff', 1, CURRENT_TIMESTAMP),
(373, 'type', 'double_diff', 1, CURRENT_TIMESTAMP),
(374, 'color-schema', 'stair', 1, CURRENT_TIMESTAMP),
(375, 'color-schema', 'stair', 1, CURRENT_TIMESTAMP),
(376, 'y-axis-label', 'variations', 1, CURRENT_TIMESTAMP),
(377, 'color-schema', 'dual', 1, CURRENT_TIMESTAMP),
(378, 'color-schema', 'dual', 1, CURRENT_TIMESTAMP),
(381, 'color-schema', 'diff', 1, CURRENT_TIMESTAMP),
(381, 'groupby', '2', 1, CURRENT_TIMESTAMP),
(381, 'time-interval', '5', 1, CURRENT_TIMESTAMP),

(382, 'color-schema', 'dual', 1, CURRENT_TIMESTAMP),
(383, 'check', '{input-parameters.hand}={\"both\"}', 1, CURRENT_TIMESTAMP),
(383, 'color-schema', 'double_dual', 1, CURRENT_TIMESTAMP),
(383, 'device', '1,6', 1, CURRENT_TIMESTAMP),

(384, 'check', '{input-parameters.hand}={\"both\"}', 1, CURRENT_TIMESTAMP),
(384, 'color-schema', 'double_dual', 1, CURRENT_TIMESTAMP),
(384, 'device', '1,6', 1, CURRENT_TIMESTAMP),
(384, 'time-interval', '5', 1, CURRENT_TIMESTAMP),

(385, 'check', '{input-parameters.hand}={\"both\"}', 1, CURRENT_TIMESTAMP),
(385, 'color-schema', 'double_dual', 1, CURRENT_TIMESTAMP),
(385, 'device', '1,6', 1, CURRENT_TIMESTAMP),

(386, 'color-schema', 'quadrants_diff', 1, CURRENT_TIMESTAMP),
(386, 'type', 'double_diff', 1, CURRENT_TIMESTAMP),
(387, 'color-schema', 'stair', 1, CURRENT_TIMESTAMP),
(388, 'color-schema', 'stair', 1, CURRENT_TIMESTAMP),

(390, 'color-schema', 'five_diff', 1, CURRENT_TIMESTAMP),
(390, 'type', 'cross_diff', 1, CURRENT_TIMESTAMP),
(392, 'time-interval', '5', 1, CURRENT_TIMESTAMP),
(393, 'color-schema', 'dual', 1, CURRENT_TIMESTAMP),
(394, 'color-schema', 'stair', 1, CURRENT_TIMESTAMP),
(395, 'color-schema', 'stair', 1, CURRENT_TIMESTAMP),
(397, 'color-schema', 'around_diff', 1, CURRENT_TIMESTAMP),
(397, 'type', 'around_diff', 1, CURRENT_TIMESTAMP),
(398, 'color-schema', 'dual', 1, CURRENT_TIMESTAMP),
(399, 'color-schema', 'diff', 1, CURRENT_TIMESTAMP),
(399, 'groupby', '2', 1, CURRENT_TIMESTAMP),
(399, 'time-interval', '5', 1, CURRENT_TIMESTAMP),
(400, 'color-schema', 'stair', 1, CURRENT_TIMESTAMP),
(401, 'color-schema', 'stair', 1, CURRENT_TIMESTAMP);



DELETE FROM `ima_game` WHERE `Game_ID` in (21,33,34,35,38,44);

INSERT INTO `ima_game` (`Game_ID`, `Name`, `Resource_URL`, `Executable`, `Description`,`Version`, `Active`, `Last_Edit`) VALUES
(21, 'Diamonds', '/images/games/game2K.png', 'Game2AKids', 'Users are asked to pick the gem and move it to the right container.',10, 0, CURRENT_TIMESTAMP),
(33, 'Season machine', '/images/games/gameSeasonsK.png', 'GameStagioniKids', 'Users are asked to touch only the bubbles which contain elements about the season shown in the background.',1, 0, CURRENT_TIMESTAMP),
(34, 'Sky battle', '/images/games/game1K.png', 'Game1Kids', 'Users are asked to destroy correct items (meteorites) and avoid distractors (satellites). Objects descend from the top of the screen.',1, 0, CURRENT_TIMESTAMP),
(35, 'Enigma', '/images/games/game3BK.png', 'Game3BKids', 'Users are asked to drag the talisman to the correct natural element following the path within the dotted area and collect as many symbols as possible.',1, 0, CURRENT_TIMESTAMP),
(38, 'Fish the duck', '/images/games/game5K.png', 'Game5Kids', 'Users are asked to move the duck to the drain.',1, 0, CURRENT_TIMESTAMP),
(44, 'Skiing holidays', '/images/games/gamepostural4.png', 'GamePostural4', 'Users are asked to get down to avoid obstacles and lean to the right or left to take the carrots.',1, 0, CURRENT_TIMESTAMP);

UPDATE `ima_game` SET `Active` = 1, Display_Order=0 WHERE Game_ID in (21,33,34,35,38,44);

-- UPDATE `ima_game` SET `Active` = 0, Display_Order=2 WHERE Game_ID in (14,15,16,17);

INSERT INTO `ima_game_resource` (`Resource_ID`, `Name`, `Resource_URL`, `Type`, `Version`, `Active`, `Last_Edit`) VALUES
(13, 'LOADER', 'LoaderKids', 'Scene', 13, 1, CURRENT_TIMESTAMP);

DELETE FROM `ima_game_dependency` WHERE `Game_ID` in (21,33,34,35,38,42,54,63,56,57,58,14,15,16,17) and Resource_ID in (1,2,3);

INSERT INTO `ima_game_dependency` (`Game_ID`, `Resource_ID`, `Order`, `Active`, `Last_Edit`) VALUES
(3,9,-3,1,CURRENT_TIMESTAMP),
(3,10,-2,1,CURRENT_TIMESTAMP),
(3,13,-1,1,CURRENT_TIMESTAMP),

(4,9,-3,1,CURRENT_TIMESTAMP),
(4,10,-2,1,CURRENT_TIMESTAMP),
(4,13,-1,1,CURRENT_TIMESTAMP),

(5,9,-3,1,CURRENT_TIMESTAMP),
(5,10,-2,1,CURRENT_TIMESTAMP),
(5,13,-1,1,CURRENT_TIMESTAMP),

(7,9,-3,1,CURRENT_TIMESTAMP),
(7,10,-2,1,CURRENT_TIMESTAMP),
(7,13,-1,1,CURRENT_TIMESTAMP),

(8,9,-3,1,CURRENT_TIMESTAMP),
(8,10,-2,1,CURRENT_TIMESTAMP),
(8,13,-1,1,CURRENT_TIMESTAMP),

(10,9,-3,1,CURRENT_TIMESTAMP),
(10,10,-2,1,CURRENT_TIMESTAMP),
(10,13,-1,1,CURRENT_TIMESTAMP),

(18,9,-3,1,CURRENT_TIMESTAMP),
(18,10,-2,1,CURRENT_TIMESTAMP),
(18,13,-1,1,CURRENT_TIMESTAMP),

(19,9,-3,1,CURRENT_TIMESTAMP),
(19,10,-2,1,CURRENT_TIMESTAMP),
(19,13,-1,1,CURRENT_TIMESTAMP),

(20,9,-3,1,CURRENT_TIMESTAMP),
(20,10,-2,1,CURRENT_TIMESTAMP),
(20,13,-1,1,CURRENT_TIMESTAMP),

(22,9,-3,1,CURRENT_TIMESTAMP),
(22,10,-2,1,CURRENT_TIMESTAMP),
(22,13,-1,1,CURRENT_TIMESTAMP),

(23,9,-3,1,CURRENT_TIMESTAMP),
(23,10,-2,1,CURRENT_TIMESTAMP),
(23,13,-1,1,CURRENT_TIMESTAMP),

(24,9,-3,1,CURRENT_TIMESTAMP),
(24,10,-2,1,CURRENT_TIMESTAMP),
(24,13,-1,1,CURRENT_TIMESTAMP),

(25,9,-3,1,CURRENT_TIMESTAMP),
(25,10,-2,1,CURRENT_TIMESTAMP),
(25,13,-1,1,CURRENT_TIMESTAMP),

(26,9,-3,1,CURRENT_TIMESTAMP),
(26,10,-2,1,CURRENT_TIMESTAMP),
(26,13,-1,1,CURRENT_TIMESTAMP),

(28,9,-3,1,CURRENT_TIMESTAMP),
(28,10,-2,1,CURRENT_TIMESTAMP),
(28,13,-1,1,CURRENT_TIMESTAMP),

(30,9,-3,1,CURRENT_TIMESTAMP),
(30,10,-2,1,CURRENT_TIMESTAMP),
(30,13,-1,1,CURRENT_TIMESTAMP),

(31,9,-3,1,CURRENT_TIMESTAMP),
(31,10,-2,1,CURRENT_TIMESTAMP),
(31,13,-1,1,CURRENT_TIMESTAMP),

(32,9,-3,1,CURRENT_TIMESTAMP),
(32,10,-2,1,CURRENT_TIMESTAMP),
(32,13,-1,1,CURRENT_TIMESTAMP),

(36,9,-3,1,CURRENT_TIMESTAMP),
(36,10,-2,1,CURRENT_TIMESTAMP),
(36,13,-1,1,CURRENT_TIMESTAMP),

(37,9,-3,1,CURRENT_TIMESTAMP),
(37,10,-2,1,CURRENT_TIMESTAMP),
(37,13,-1,1,CURRENT_TIMESTAMP),

(39,9,-3,1,CURRENT_TIMESTAMP),
(39,10,-2,1,CURRENT_TIMESTAMP),
(39,13,-1,1,CURRENT_TIMESTAMP),

(40,9,-3,1,CURRENT_TIMESTAMP),
(40,10,-2,1,CURRENT_TIMESTAMP),
(40,13,-1,1,CURRENT_TIMESTAMP),

(41,9,-3,1,CURRENT_TIMESTAMP),
(41,10,-2,1,CURRENT_TIMESTAMP),
(41,13,-1,1,CURRENT_TIMESTAMP),

(42,9,-3,1,CURRENT_TIMESTAMP),
(42,2,-2,1,CURRENT_TIMESTAMP),
(42,13,-1,1,CURRENT_TIMESTAMP),

(43,9,-3,1,CURRENT_TIMESTAMP),
(43,10,-2,1,CURRENT_TIMESTAMP),
(43,13,-1,1,CURRENT_TIMESTAMP),

(52,9,-3,1,CURRENT_TIMESTAMP),
(52,10,-2,1,CURRENT_TIMESTAMP),
(52,13,-1,1,CURRENT_TIMESTAMP),

(53,9,-3,1,CURRENT_TIMESTAMP),
(53,10,-2,1,CURRENT_TIMESTAMP),
(53,13,-1,1,CURRENT_TIMESTAMP),

(54,9,-3,1,CURRENT_TIMESTAMP),
(54,2,-2,1,CURRENT_TIMESTAMP),
(54,13,-1,1,CURRENT_TIMESTAMP),

(56,9,-3,1,CURRENT_TIMESTAMP),
(56,2,-2,1,CURRENT_TIMESTAMP),
(56,13,-1,1,CURRENT_TIMESTAMP),

(57,9,-3,1,CURRENT_TIMESTAMP),
(57,2,-2,1,CURRENT_TIMESTAMP),
(57,13,-1,1,CURRENT_TIMESTAMP),

(58,9,-3,1,CURRENT_TIMESTAMP),
(58,2,-2,1,CURRENT_TIMESTAMP),
(58,13,-1,1,CURRENT_TIMESTAMP),

(59,9,-3,1,CURRENT_TIMESTAMP),
(59,10,-2,1,CURRENT_TIMESTAMP),
(59,13,-1,1,CURRENT_TIMESTAMP),

(60,9,-3,1,CURRENT_TIMESTAMP),
(60,10,-2,1,CURRENT_TIMESTAMP),
(60,13,-1,1,CURRENT_TIMESTAMP),

(61,9,-3,1,CURRENT_TIMESTAMP),
(61,10,-2,1,CURRENT_TIMESTAMP),
(61,13,-1,1,CURRENT_TIMESTAMP),

(62,9,-3,1,CURRENT_TIMESTAMP),
(62,10,-2,1,CURRENT_TIMESTAMP),
(62,13,-1,1,CURRENT_TIMESTAMP),

(63,9,-3,1,CURRENT_TIMESTAMP),
(63,2,-2,1,CURRENT_TIMESTAMP),
(63,13,-1,1,CURRENT_TIMESTAMP),

(64,9,-3,1,CURRENT_TIMESTAMP),
(64,10,-2,1,CURRENT_TIMESTAMP),
(64,13,-1,1,CURRENT_TIMESTAMP),

(65,9,-3,1,CURRENT_TIMESTAMP),
(65,10,-2,1,CURRENT_TIMESTAMP),
(65,13,-1,1,CURRENT_TIMESTAMP);