INSERT INTO "games" ( "slug", "name", "docker_image", "default_port", "config_files", "automation_rules", "startup_command", "stop_command", "environment_vars", "created_at", "updated_at" ) VALUES ( 'satisfactory', 'Satisfactory', 'wolveix/satisfactory-server:latest', 7777, '[]'::jsonb, '[]'::jsonb, '', 'quit', '[ { "key": "MAXPLAYERS", "default": "4", "description": "Maximum player count", "required": false }, { "key": "STEAMBETA", "label": "Branch", "default": "false", "description": "Use the experimental branch instead of stable", "required": false, "inputType": "boolean", "enabledLabel": "Experimental", "disabledLabel": "Stable" }, { "key": "AUTOSAVENUM", "default": "5", "description": "Number of rotating autosaves", "required": false }, { "key": "MAXTICKRATE", "default": "30", "description": "Maximum simulation tick rate", "required": false } ]'::jsonb, now(), now() ) ON CONFLICT ("slug") DO UPDATE SET "name" = EXCLUDED."name", "docker_image" = EXCLUDED."docker_image", "default_port" = EXCLUDED."default_port", "config_files" = EXCLUDED."config_files", "automation_rules" = EXCLUDED."automation_rules", "startup_command" = EXCLUDED."startup_command", "stop_command" = EXCLUDED."stop_command", "environment_vars" = EXCLUDED."environment_vars", "updated_at" = now();