67 lines
1.5 KiB
SQL
67 lines
1.5 KiB
SQL
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();
|