-- OT game catalog, generated from Assets/1_C/Scene/Games/CoreUI.unity.
-- Pure INSERTs (does NOT delete existing rows). For a full OT-only reset,
-- run: php artisan db:seed --class="Database\Seeders\OthGameCatalogSeeder"

INSERT INTO oth_therapy_type (name, slug, sort_order, is_active, created_at, updated_at) VALUES ('OT', 'oth', 0, 1, NOW(), NOW());
SET @oth = (SELECT id FROM oth_therapy_type WHERE slug='oth');

INSERT INTO oth_category (name, slug, therapy_type_id, sort_order, is_active, created_at, updated_at) VALUES
  ('Tracking', 'tracking', @oth, 1, 1, NOW(), NOW()),
  ('Eye Hand', 'eyehand', @oth, 2, 1, NOW(), NOW()),
  ('Pictures', 'pictures', @oth, 3, 1, NOW(), NOW()),
  ('Parts', 'parts', @oth, 4, 1, NOW(), NOW()),
  ('Lights', 'lights', @oth, 5, 1, NOW(), NOW()),
  ('Search', 'search', @oth, 6, 1, NOW(), NOW());

SET @cat_tracking = (SELECT id FROM oth_category WHERE slug='tracking');
SET @cat_eyehand = (SELECT id FROM oth_category WHERE slug='eyehand');
SET @cat_pictures = (SELECT id FROM oth_category WHERE slug='pictures');
SET @cat_parts = (SELECT id FROM oth_category WHERE slug='parts');
SET @cat_lights = (SELECT id FROM oth_category WHERE slug='lights');
SET @cat_search = (SELECT id FROM oth_category WHERE slug='search');

-- One row per distinct playable scene+name; unity m_GameId + scene kept in metadata.
INSERT INTO oth_games (category_id, title, slug, launch_url, game_type, is_active, sort_order, metadata, created_at, updated_at) VALUES
  (@cat_tracking, 'Animated Up', 'baloonpopping-animated-up', '1_C/Scene/Games/Tracking/BaloonPopping', 'BaloonPopping', 1, 1, '{"unity_game_id": 60008, "scene": "1_C/Scene/Games/Tracking/BaloonPopping"}', NOW(), NOW()),
  (@cat_parts, 'Dress', 'higlightparts-dress', '1_C/Scene/Games/Parts/HIglightParts', 'HIglightParts', 1, 2, '{"unity_game_id": 7007, "scene": "1_C/Scene/Games/Parts/HIglightParts"}', NOW(), NOW()),
  (@cat_lights, 'Fluid Dynamics', 'fluiddynamics-fluid-dynamics', '1_C/Scene/Games/Lights/FluidDynamics', 'FluidDynamics', 1, 3, '{"unity_game_id": 1001, "scene": "1_C/Scene/Games/Lights/FluidDynamics"}', NOW(), NOW()),
  (@cat_parts, 'Animals', 'higlightparts-animals', '1_C/Scene/Games/Parts/HIglightParts', 'HIglightParts', 1, 4, '{"unity_game_id": 7001, "scene": "1_C/Scene/Games/Parts/HIglightParts"}', NOW(), NOW()),
  (@cat_tracking, 'Saccades', 'circulartrackinggames-saccades', '1_C/Scene/Games/Tracking/CirCularTrackingGames', 'CirCularTrackingGames', 1, 5, '{"unity_game_id": 50002, "scene": "1_C/Scene/Games/Tracking/CirCularTrackingGames"}', NOW(), NOW()),
  (@cat_pictures, 'Basic Colors', 'basiccolors-basic-colors', '1_C/Scene/Games/Pictures/BasicColors', 'BasicColors', 1, 6, '{"unity_game_id": 1002, "scene": "1_C/Scene/Games/Pictures/BasicColors"}', NOW(), NOW()),
  (@cat_lights, 'Draw Sparkle', 'sparkles-draw-sparkle', '1_C/Scene/Games/Lights/Sparkles', 'Sparkles', 1, 7, '{"unity_game_id": 1003, "scene": "1_C/Scene/Games/Lights/Sparkles"}', NOW(), NOW()),
  (@cat_eyehand, 'Piano Canvas', 'pianocanvas-piano-canvas', '1_C/Scene/Games/EyeHand/PianoCanvas', 'PianoCanvas', 1, 8, '{"unity_game_id": 11002, "scene": "1_C/Scene/Games/EyeHand/PianoCanvas"}', NOW(), NOW()),
  (@cat_eyehand, 'Drag And Drop', 'draganddrop-drag-and-drop', '1_C/Scene/Games/EyeHand/DragAndDrop', 'DragAndDrop', 1, 9, '{"unity_game_id": 1002, "scene": "1_C/Scene/Games/EyeHand/DragAndDrop"}', NOW(), NOW()),
  (@cat_tracking, 'Animated Down', 'baloonpopping-animated-down', '1_C/Scene/Games/Tracking/BaloonPopping', 'BaloonPopping', 1, 10, '{"unity_game_id": 60007, "scene": "1_C/Scene/Games/Tracking/BaloonPopping"}', NOW(), NOW()),
  (@cat_tracking, 'Diagonal Right', 'circulartrackinggames-diagonal-right', '1_C/Scene/Games/Tracking/CirCularTrackingGames', 'CirCularTrackingGames', 1, 11, '{"unity_game_id": 50008, "scene": "1_C/Scene/Games/Tracking/CirCularTrackingGames"}', NOW(), NOW()),
  (@cat_tracking, 'Animated Right', 'baloonpopping-animated-right', '1_C/Scene/Games/Tracking/BaloonPopping', 'BaloonPopping', 1, 12, '{"unity_game_id": 60006, "scene": "1_C/Scene/Games/Tracking/BaloonPopping"}', NOW(), NOW()),
  (@cat_lights, 'Click Sparkle', 'sparkles-click-sparkle', '1_C/Scene/Games/Lights/Sparkles', 'Sparkles', 1, 13, '{"unity_game_id": 1005, "scene": "1_C/Scene/Games/Lights/Sparkles"}', NOW(), NOW()),
  (@cat_tracking, 'Up', 'baloonpopping-up', '1_C/Scene/Games/Tracking/BaloonPopping', 'BaloonPopping', 1, 14, '{"unity_game_id": 60002, "scene": "1_C/Scene/Games/Tracking/BaloonPopping"}', NOW(), NOW()),
  (@cat_tracking, 'OKN Simple Patterns', 'oknpatterns-okn-simple-patterns', '1_C/Scene/Games/Tracking/OKNPatterns', 'OKNPatterns', 1, 15, '{"unity_game_id": 50003, "scene": "1_C/Scene/Games/Tracking/OKNPatterns"}', NOW(), NOW()),
  (@cat_parts, 'Face', 'higlightparts-face', '1_C/Scene/Games/Parts/HIglightParts', 'HIglightParts', 1, 16, '{"unity_game_id": 7004, "scene": "1_C/Scene/Games/Parts/HIglightParts"}', NOW(), NOW()),
  (@cat_pictures, 'Vegetables', 'basicpictures-vegetables', '1_C/Scene/Games/Pictures/BasicPictures', 'BasicPictures', 1, 17, '{"unity_game_id": 1002, "scene": "1_C/Scene/Games/Pictures/BasicPictures"}', NOW(), NOW()),
  (@cat_tracking, 'Box', 'circulartrackinggames-box', '1_C/Scene/Games/Tracking/CirCularTrackingGames', 'CirCularTrackingGames', 1, 18, '{"unity_game_id": 50009, "scene": "1_C/Scene/Games/Tracking/CirCularTrackingGames"}', NOW(), NOW()),
  (@cat_tracking, 'Pursuits', 'circulartrackinggames-pursuits', '1_C/Scene/Games/Tracking/CirCularTrackingGames', 'CirCularTrackingGames', 1, 19, '{"unity_game_id": 50001, "scene": "1_C/Scene/Games/Tracking/CirCularTrackingGames"}', NOW(), NOW()),
  (@cat_eyehand, 'Drag Game Dog', 'draggamedog-drag-game-dog', '1_C/Scene/Games/EyeHand/DragGameDog', 'DragGameDog', 1, 20, '{"unity_game_id": 11008, "scene": "1_C/Scene/Games/EyeHand/DragGameDog"}', NOW(), NOW()),
  (@cat_tracking, 'Diagonal Left', 'circulartrackinggames-diagonal-left', '1_C/Scene/Games/Tracking/CirCularTrackingGames', 'CirCularTrackingGames', 1, 21, '{"unity_game_id": 50007, "scene": "1_C/Scene/Games/Tracking/CirCularTrackingGames"}', NOW(), NOW()),
  (@cat_eyehand, 'Music Box Saccade', 'pianocanvassaccad-music-box-saccade', '1_C/Scene/Games/EyeHand/PianoCanvasSaccad', 'PianoCanvasSaccad', 1, 22, '{"unity_game_id": 11003, "scene": "1_C/Scene/Games/EyeHand/PianoCanvasSaccad"}', NOW(), NOW()),
  (@cat_tracking, 'Cir Cular Tracking Games', 'circulartrackinggames-cir-cular-tracking-games', '1_C/Scene/Games/Tracking/CirCularTrackingGames', 'CirCularTrackingGames', 1, 23, '{"unity_game_id": 50003, "scene": "1_C/Scene/Games/Tracking/CirCularTrackingGames"}', NOW(), NOW()),
  (@cat_tracking, 'Left', 'baloonpopping-left', '1_C/Scene/Games/Tracking/BaloonPopping', 'BaloonPopping', 1, 24, '{"unity_game_id": 60004, "scene": "1_C/Scene/Games/Tracking/BaloonPopping"}', NOW(), NOW()),
  (@cat_eyehand, 'Drag Game Toaster', 'draggametoaster-drag-game-toaster', '1_C/Scene/Games/EyeHand/DragGameToaster', 'DragGameToaster', 1, 25, '{"unity_game_id": 11006, "scene": "1_C/Scene/Games/EyeHand/DragGameToaster"}', NOW(), NOW()),
  (@cat_lights, 'Auto Saccade Sparkle', 'sparkles-auto-saccade-sparkle', '1_C/Scene/Games/Lights/Sparkles', 'Sparkles', 1, 26, '{"unity_game_id": 1002, "scene": "1_C/Scene/Games/Lights/Sparkles"}', NOW(), NOW()),
  (@cat_tracking, 'OKN Complex Patterns', 'oknsimple-okn-complex-patterns', '1_C/Scene/Games/Tracking/OKNSimple', 'OKNSimple', 1, 27, '{"unity_game_id": 50003, "scene": "1_C/Scene/Games/Tracking/OKNSimple"}', NOW(), NOW()),
  (@cat_tracking, 'Down', 'baloonpopping-down', '1_C/Scene/Games/Tracking/BaloonPopping', 'BaloonPopping', 1, 28, '{"unity_game_id": 60001, "scene": "1_C/Scene/Games/Tracking/BaloonPopping"}', NOW(), NOW()),
  (@cat_lights, 'Auto Pursuit Sparkle', 'sparkles-auto-pursuit-sparkle', '1_C/Scene/Games/Lights/Sparkles', 'Sparkles', 1, 29, '{"unity_game_id": 1004, "scene": "1_C/Scene/Games/Lights/Sparkles"}', NOW(), NOW()),
  (@cat_eyehand, 'Drag Game Monkey', 'draggamemonkey-drag-game-monkey', '1_C/Scene/Games/EyeHand/DragGameMonkey', 'DragGameMonkey', 1, 30, '{"unity_game_id": 11009, "scene": "1_C/Scene/Games/EyeHand/DragGameMonkey"}', NOW(), NOW()),
  (@cat_tracking, 'All Direction - Down', 'direction-all-direction-down', '1_C/Scene/Games/Tracking/Direction', 'Direction', 1, 31, '{"unity_game_id": 600014, "scene": "1_C/Scene/Games/Tracking/Direction"}', NOW(), NOW()),
  (@cat_eyehand, 'Drag Game Flowering', 'draggameflowering-drag-game-flowering', '1_C/Scene/Games/EyeHand/DragGameFlowering', 'DragGameFlowering', 1, 32, '{"unity_game_id": 11012, "scene": "1_C/Scene/Games/EyeHand/DragGameFlowering"}', NOW(), NOW()),
  (@cat_search, 'Spot The Items Beach1', 'spottheitemsbeach1-spot-the-items-beach1', '1_C/Scene/Games/Search/SpotTheItemsBeach1', 'SpotTheItemsBeach1', 1, 33, '{"unity_game_id": 1002, "scene": "1_C/Scene/Games/Search/SpotTheItemsBeach1"}', NOW(), NOW()),
  (@cat_eyehand, 'Drag Game Seedto Plant', 'draggameseedtoplant-drag-game-seedto-plant', '1_C/Scene/Games/EyeHand/DragGameSeedtoPlant', 'DragGameSeedtoPlant', 1, 34, '{"unity_game_id": 11010, "scene": "1_C/Scene/Games/EyeHand/DragGameSeedtoPlant"}', NOW(), NOW()),
  (@cat_tracking, 'Two Direction - Left', 'direction-two-direction-left', '1_C/Scene/Games/Tracking/Direction', 'Direction', 1, 35, '{"unity_game_id": 600013, "scene": "1_C/Scene/Games/Tracking/Direction"}', NOW(), NOW()),
  (@cat_eyehand, 'Drag Game Kettle', 'draggamekettle-drag-game-kettle', '1_C/Scene/Games/EyeHand/DragGameKettle', 'DragGameKettle', 1, 36, '{"unity_game_id": 11005, "scene": "1_C/Scene/Games/EyeHand/DragGameKettle"}', NOW(), NOW()),
  (@cat_parts, 'Vegetables', 'higlightparts-vegetables', '1_C/Scene/Games/Parts/HIglightParts', 'HIglightParts', 1, 37, '{"unity_game_id": 7003, "scene": "1_C/Scene/Games/Parts/HIglightParts"}', NOW(), NOW()),
  (@cat_tracking, 'OKN', 'okn-okn', '1_C/Scene/Games/Tracking/OKN', 'OKN', 1, 38, '{"unity_game_id": 2001, "scene": "1_C/Scene/Games/Tracking/OKN"}', NOW(), NOW()),
  (@cat_parts, 'Kitchen', 'higlightparts-kitchen', '1_C/Scene/Games/Parts/HIglightParts', 'HIglightParts', 1, 39, '{"unity_game_id": 7005, "scene": "1_C/Scene/Games/Parts/HIglightParts"}', NOW(), NOW()),
  (@cat_tracking, 'Diamond', 'circulartrackinggames-diamond', '1_C/Scene/Games/Tracking/CirCularTrackingGames', 'CirCularTrackingGames', 1, 40, '{"unity_game_id": 50006, "scene": "1_C/Scene/Games/Tracking/CirCularTrackingGames"}', NOW(), NOW()),
  (@cat_tracking, 'Animated Left', 'baloonpopping-animated-left', '1_C/Scene/Games/Tracking/BaloonPopping', 'BaloonPopping', 1, 41, '{"unity_game_id": 60005, "scene": "1_C/Scene/Games/Tracking/BaloonPopping"}', NOW(), NOW()),
  (@cat_pictures, 'Animals', 'basicpictures-animals', '1_C/Scene/Games/Pictures/BasicPictures', 'BasicPictures', 1, 42, '{"unity_game_id": 1002, "scene": "1_C/Scene/Games/Pictures/BasicPictures"}', NOW(), NOW()),
  (@cat_parts, 'Fruits', 'higlightparts-fruits', '1_C/Scene/Games/Parts/HIglightParts', 'HIglightParts', 1, 43, '{"unity_game_id": 7006, "scene": "1_C/Scene/Games/Parts/HIglightParts"}', NOW(), NOW()),
  (@cat_pictures, 'Fruits', 'basicpictures-fruits', '1_C/Scene/Games/Pictures/BasicPictures', 'BasicPictures', 1, 44, '{"unity_game_id": 1002, "scene": "1_C/Scene/Games/Pictures/BasicPictures"}', NOW(), NOW()),
  (@cat_tracking, 'Horizontal', 'circulartrackinggames-horizontal', '1_C/Scene/Games/Tracking/CirCularTrackingGames', 'CirCularTrackingGames', 1, 45, '{"unity_game_id": 50005, "scene": "1_C/Scene/Games/Tracking/CirCularTrackingGames"}', NOW(), NOW()),
  (@cat_eyehand, 'Drag Game Cow', 'draggamecow-drag-game-cow', '1_C/Scene/Games/EyeHand/DragGameCow', 'DragGameCow', 1, 46, '{"unity_game_id": 11007, "scene": "1_C/Scene/Games/EyeHand/DragGameCow"}', NOW(), NOW()),
  (@cat_tracking, 'Right', 'baloonpopping-right', '1_C/Scene/Games/Tracking/BaloonPopping', 'BaloonPopping', 1, 47, '{"unity_game_id": 60003, "scene": "1_C/Scene/Games/Tracking/BaloonPopping"}', NOW(), NOW()),
  (@cat_tracking, 'All Direction - Up', 'direction-all-direction-up', '1_C/Scene/Games/Tracking/Direction', 'Direction', 1, 48, '{"unity_game_id": 600015, "scene": "1_C/Scene/Games/Tracking/Direction"}', NOW(), NOW()),
  (@cat_tracking, 'All Direction - Right', 'direction-all-direction-right', '1_C/Scene/Games/Tracking/Direction', 'Direction', 1, 49, '{"unity_game_id": 600016, "scene": "1_C/Scene/Games/Tracking/Direction"}', NOW(), NOW()),
  (@cat_eyehand, 'Drag Game Rabbit', 'draggamerabbit-drag-game-rabbit', '1_C/Scene/Games/EyeHand/DragGameRabbit', 'DragGameRabbit', 1, 50, '{"unity_game_id": 11004, "scene": "1_C/Scene/Games/EyeHand/DragGameRabbit"}', NOW(), NOW()),
  (@cat_tracking, 'All Direction - Left', 'direction-all-direction-left', '1_C/Scene/Games/Tracking/Direction', 'Direction', 1, 51, '{"unity_game_id": 600017, "scene": "1_C/Scene/Games/Tracking/Direction"}', NOW(), NOW()),
  (@cat_search, 'Spot The Items Beach', 'spottheitemsbeach-spot-the-items-beach', '1_C/Scene/Games/Search/SpotTheItemsBeach', 'SpotTheItemsBeach', 1, 52, '{"unity_game_id": 1001, "scene": "1_C/Scene/Games/Search/SpotTheItemsBeach"}', NOW(), NOW()),
  (@cat_tracking, 'Two Direction - Right', 'direction-two-direction-right', '1_C/Scene/Games/Tracking/Direction', 'Direction', 1, 53, '{"unity_game_id": 600012, "scene": "1_C/Scene/Games/Tracking/Direction"}', NOW(), NOW()),
  (@cat_tracking, 'Vertical', 'circulartrackinggames-vertical', '1_C/Scene/Games/Tracking/CirCularTrackingGames', 'CirCularTrackingGames', 1, 54, '{"unity_game_id": 50004, "scene": "1_C/Scene/Games/Tracking/CirCularTrackingGames"}', NOW(), NOW()),
  (@cat_tracking, 'Two Direction - Down', 'direction-two-direction-down', '1_C/Scene/Games/Tracking/Direction', 'Direction', 1, 55, '{"unity_game_id": 600010, "scene": "1_C/Scene/Games/Tracking/Direction"}', NOW(), NOW()),
  (@cat_tracking, 'Two Direction - Up', 'direction-two-direction-up', '1_C/Scene/Games/Tracking/Direction', 'Direction', 1, 56, '{"unity_game_id": 600011, "scene": "1_C/Scene/Games/Tracking/Direction"}', NOW(), NOW()),
  (@cat_pictures, 'Birds', 'basicpictures-birds', '1_C/Scene/Games/Pictures/BasicPictures', 'BasicPictures', 1, 57, '{"unity_game_id": 1002, "scene": "1_C/Scene/Games/Pictures/BasicPictures"}', NOW(), NOW()),
  (@cat_pictures, 'Gents Wear', 'collectionpictures-gents-wear', '1_C/Scene/Games/Pictures/CollectionPictures', 'CollectionPictures', 1, 58, '{"unity_game_id": 20589, "scene": "1_C/Scene/Games/Pictures/CollectionPictures"}', NOW(), NOW()),
  (@cat_pictures, 'Insects', 'collectionpictures-insects', '1_C/Scene/Games/Pictures/CollectionPictures', 'CollectionPictures', 1, 59, '{"unity_game_id": 20590, "scene": "1_C/Scene/Games/Pictures/CollectionPictures"}', NOW(), NOW()),
  (@cat_pictures, 'Kitchen Items', 'collectionpictures-kitchen-items', '1_C/Scene/Games/Pictures/CollectionPictures', 'CollectionPictures', 1, 60, '{"unity_game_id": 20591, "scene": "1_C/Scene/Games/Pictures/CollectionPictures"}', NOW(), NOW()),
  (@cat_pictures, 'Ladies Wear', 'collectionpictures-ladies-wear', '1_C/Scene/Games/Pictures/CollectionPictures', 'CollectionPictures', 1, 61, '{"unity_game_id": 20592, "scene": "1_C/Scene/Games/Pictures/CollectionPictures"}', NOW(), NOW()),
  (@cat_pictures, 'Musical Instrument', 'collectionpictures-musical-instrument', '1_C/Scene/Games/Pictures/CollectionPictures', 'CollectionPictures', 1, 62, '{"unity_game_id": 20593, "scene": "1_C/Scene/Games/Pictures/CollectionPictures"}', NOW(), NOW()),
  (@cat_pictures, 'Profession', 'collectionpictures-profession', '1_C/Scene/Games/Pictures/CollectionPictures', 'CollectionPictures', 1, 63, '{"unity_game_id": 20594, "scene": "1_C/Scene/Games/Pictures/CollectionPictures"}', NOW(), NOW()),
  (@cat_pictures, 'Bathroom Things', 'collectionpictures-bathroom-things', '1_C/Scene/Games/Pictures/CollectionPictures', 'CollectionPictures', 1, 64, '{"unity_game_id": 20595, "scene": "1_C/Scene/Games/Pictures/CollectionPictures"}', NOW(), NOW()),
  (@cat_pictures, 'Transport', 'collectionpictures-transport', '1_C/Scene/Games/Pictures/CollectionPictures', 'CollectionPictures', 1, 65, '{"unity_game_id": 20596, "scene": "1_C/Scene/Games/Pictures/CollectionPictures"}', NOW(), NOW()),
  (@cat_pictures, 'Wild Animals', 'collectionpictures-wild-animals', '1_C/Scene/Games/Pictures/CollectionPictures', 'CollectionPictures', 1, 66, '{"unity_game_id": 20597, "scene": "1_C/Scene/Games/Pictures/CollectionPictures"}', NOW(), NOW()),
  (@cat_pictures, 'Domestic Animals', 'collectionpictures-domestic-animals', '1_C/Scene/Games/Pictures/CollectionPictures', 'CollectionPictures', 1, 67, '{"unity_game_id": 20585, "scene": "1_C/Scene/Games/Pictures/CollectionPictures"}', NOW(), NOW()),
  (@cat_pictures, 'Everyday Things', 'collectionpictures-everyday-things', '1_C/Scene/Games/Pictures/CollectionPictures', 'CollectionPictures', 1, 68, '{"unity_game_id": 20586, "scene": "1_C/Scene/Games/Pictures/CollectionPictures"}', NOW(), NOW()),
  (@cat_pictures, 'Flowers', 'collectionpictures-flowers', '1_C/Scene/Games/Pictures/CollectionPictures', 'CollectionPictures', 1, 69, '{"unity_game_id": 20587, "scene": "1_C/Scene/Games/Pictures/CollectionPictures"}', NOW(), NOW()),
  (@cat_pictures, 'Food Items', 'collectionpictures-food-items', '1_C/Scene/Games/Pictures/CollectionPictures', 'CollectionPictures', 1, 70, '{"unity_game_id": 20588, "scene": "1_C/Scene/Games/Pictures/CollectionPictures"}', NOW(), NOW());
-- 70 games across 6 categories