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,44) and Resource_ID in (1,2,3);

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