Changelog

These instructions cover sky_dojjob 0.1.1 → 0.2.0. Complete earlier required schema installation first if your installed version is older. Prepare Base 1.44.0, Jobs Base 1.47.0 and the complete DOJ 0.2.0 download for the same maintenance window. Follow the Base and Jobs Base update instructions too.

Before stopping the server

1. Download Sky DOJ Job 0.2.0 and the matching sky_base 1.44.0 and sky_jobs_base 1.47.0 packages. Prepare these companion updates now; replace them together during the maintenance steps below.
2. Record Config.AutoExecuteQuery from sky_dojjob/config/config.lua. true selects the automatic database update; false requires the manual SQL update below. Keep your chosen value when merging the new configuration. This startup setting is read before the later in-game configuration is applied.
3. Record your existing /jobconfig settings, roles, shared-workspace access and Creator placements. Collect completed printer output before maintenance. In particular, check each printer's deleteCopiesAfterRestart setting: if enabled, this update removes its uncollected completed DOJ output on initialization. The default is false; copies already in an inventory are not removed.
4. Finish active court sessions and give players time to save their work. Tell election administrators that published elections containing old votes will be closed by the update, with their results retained. They must start a new election if voting needs to continue after the update.
5. Keep the existing private election secret with the backup. The new voting system no longer uses it, but it is still needed if the entire installation is restored to 0.1.1.

Stop and back up

1. Stop FXServer so players and resources cannot write during the update. Back up the database, the existing resource folders and configuration, saved job settings/Creator data, and your inventory storage with its item metadata. Use a consistent backup of these parts before proceeding.
2. In your database tool, select the server's existing database and run SELECT DATABASE();. Save the election status and vote totals from these read-only queries so you can compare them after migration:

SELECT id, election_key, status, version, closed_at
FROM sky_doj_elections
ORDER BY id;

SELECT election_id, option_id, COUNT(*) AS votes
FROM sky_doj_election_votes
GROUP BY election_id, option_id
ORDER BY election_id, option_id;

Use the complete downloads and follow their own update instructions. These are the matching dependency releases for this update. Keep your configured framework, database and optional provider resources ahead of the Sky resources in the server start order.

ensure sky_base
ensure sky_jobs_base
# Start the compatible optional job/provider resources you actually use here.
ensure sky_dojjob

Keep the compatible Police resource running for citizen searches, bank investigations against real characters, Police case imports and Police-backed conditions. Keep Mechanic running when using its permitted vehicle reports. Their data remains subject to the source job's access rules. A missing banking, billing or license capability cannot be enabled by a DOJ feature switch.

Use the matching 0.2.0 package. Delete the complete old sky_dojjob/source/ folder and insert the new folder, including the built interface. Replace sky_dojjob/fxmanifest.lua from the same download. Refresh the complete sky_dojjob/config/locales/ tree, then merge your custom translations back. Do not merge old generated interface files into the new source/ folder.

Replace sky_dojjob/README.md, sky_dojjob/import.sql and the supplied sky_dojjob/stream/ tree. Copying import.sql does not execute it. Preserve any separate custom assets deliberately. No files outside source/ are removed or renamed in this release.

Replace the manifest with the version from the same 0.2.0 download and merge the changes below into sky_dojjob/config/config.lua. Install all these new files in the exact locations shown:

• sky_dojjob/config/registry.lua
• sky_dojjob/config/registry/README.md
• sky_dojjob/config/registry/businesses.lua
• sky_dojjob/config/registry/licenses.lua
• sky_dojjob/config/registry/marriages.lua
• sky_dojjob/config/registry/name_changes.lua
• sky_dojjob/config/registry/client/businesses.lua
• sky_dojjob/config/registry/client/marriages.lua
• sky_dojjob/config/registry/server/businesses.lua
• sky_dojjob/config/registry/server/licenses.lua
• sky_dojjob/config/registry/server/marriages.lua
• sky_dojjob/config/registry/server/name_changes.lua

Copy the matching server/client hook files from the download; the field definitions alone are not sufficient. Keep any custom register keys and custom hook changes. Update sky_dojjob/config/locales/* from the same download, carrying over your translations. No configuration file is deleted or renamed in this update. The old Config.RegistryCatalog assignment moves out of config.lua; its legacy records are not deleted.

The display model catalogues and the register field/hook files still need these file updates when /jobconfig is enabled. Those definitions are not replaced by editing a saved setting. Keep existing courthouse, room, screen and printer placements; adding a model type does not require re-importing or recreating existing placements.

If you use /jobconfig

Keep Config.UseJobConfigurator = true. Saved managed values take precedence over local Lua values. Untouched/defaulted values follow the new supplied defaults. In particular, Finance is new and enabled, and Registry changes from disabled to enabled. An old false equal to the old default may never have been stored as an override. After the update, explicitly save Registry as disabled if you want to keep it off. Asset taxes remain disabled by default.

Prepare your choices for the following areas now, and update the Lua files while the server is stopped. After the updated resources and migrations have started successfully, keep player access restricted for maintenance, open /jobconfig, select DOJ, and apply/check these choices. Run any deliberate /jobconfigimport only at that point:

The license-type choices come from the configured provider. dojRegistryLicenseOptions is a live selection list, not a value to save or paste into configuration. Register fields, templates, permission IDs and Create/Update/Remove functions remain in the Lua definition/hook files.

Import is optional and deliberate. Editing managed Lua values does not overwrite your saved configuration. If you choose /jobconfigimport sky_dojjob, first prepare the entire local config and keep a backup: import applies local jobs, settings, feature switches and interaction values together. It is not a selective import of only the new settings. Do not use Default data/reset as a routine update step. You can set the new values directly in their own /jobconfig sections instead.

Exact config.lua changes

Use these changes directly when Config.UseJobConfigurator = false. When it is true, keep the file definitions current and make managed choices in /jobconfig as described above. Preserve your existing values elsewhere in the file.

Finance and fines

Config.Finance did not exist. Add the complete block:

Config.Finance = {
    treasuryJob = "doj",
    -- Only registered Sky jobs in this list are visible and available for transfers.
    allowedJobs = { "police", "ambulance", "fire", "mechanic" },
    maxTransferAmount = 10000000,
}

Config.Conditions.finePaymentMode did not exist. Add this line after the existing Config.Conditions = { ... } block, or add the same member inside it:

Config.Conditions.finePaymentMode = "bank"

The old fine path submitted an external bill. The new default attempts an immediate bank payment. To retain invoices, use "billing" instead of "bank" (or choose Invoice in /jobconfig). An invoice being accepted is not confirmation that it has been paid. Bank payment needs a supported adapter, an online target and sufficient funds. Keep Config.Conditions.billingSocietyJob at your actual receiving job; its supplied value remains "doj", but it is now also managed by dojFineSociety. Config.Conditions.policeResource is unchanged.

Config.ToggleFeatures.finance is new; Config.ToggleFeatures.civilRegistries changes from false to true. Add/update these two members of the existing feature table without resetting other features:

Config.ToggleFeatures.finance = true
Config.ToggleFeatures.civilRegistries = true

Put standalone assignments after the existing Config.ToggleFeatures = { ... } block. You may choose false for either feature. taxes = false is unchanged.

Mobile board key

Config.Keybinds did not exist. Add the full block:

Config.Keybinds = { dojCourtroomBoardMove = "F" }

This is the default grab/release key. The supplied mobile board uses the rear handle. Moving it is temporary; restarting the resource returns it to the saved placement. Keep the stable board_93/sky_doj_court_board_93 IDs even though the current board is 150 inches.

Courtroom evidence models

Replace the props list inside Config.Courtroom.presentation with the following list, keeping any additional custom model entries you need. The first three model IDs and their location suffixes stay unchanged. Their obsolete overlay values are removed:

The five additional entries did not exist: 100/120/150-inch displays, the mobile board and projection display. The assignment below is also copyable after the complete Config.Courtroom block:

Config.Courtroom.presentation.props = {
    {
        name = "sky_doj_court_tv_55",
        locationSuffix = "wall_55",
        label = "Courtroom evidence display - 55-inch wall TV",
    },
    {
        name = "sky_doj_court_tv_75",
        locationSuffix = "wall_75",
        label = "Courtroom evidence display - 75-inch wall TV",
    },
    {
        name = "sky_doj_court_monitor_27",
        locationSuffix = "desk_27",
        label = "Courtroom evidence monitor - 27-inch desk display",
    },
    {
        name = "sky_doj_court_tv_100",
        locationSuffix = "wall_100",
        label = "Courtroom evidence display - 100-inch wall TV",
    },
    {
        name = "sky_doj_court_tv_120",
        locationSuffix = "wall_120",
        label = "Courtroom evidence display - 120-inch wall TV",
    },
    {
        name = "sky_doj_court_tv_150",
        locationSuffix = "wall_150",
        label = "Courtroom evidence display - 150-inch wall TV",
    },
    {
        name = "sky_doj_court_board_93",
        locationSuffix = "board_93",
        label = "Courtroom interactive board - 150-inch mobile stand",
    },
    {
        name = "sky_doj_court_projection_screen_01",
        locationSuffix = "projection",
        label = "Courtroom evidence display - 4.5 m projection screen",
    },
}

Update the matching streamed model/material files from the download. Do not keep the old overlay fields on the three supplied entries. Other Config.Courtroom.presentation values are unchanged, including alwaysVisible = true, renderDistance = 48.0, its intervals and resolution.

Public display models

Keep the existing first four entries of Config.PublicDisplays.props (sky_doj_wall_tv_55, sky_doj_wall_tv_75, sky_doj_desk_monitor_27, sky_doj_floor_terminal_43) unchanged. Add these four complete entries inside that list, before its closing brace; each is new:

{
    name = "sky_doj_wall_tv_100",
    locationType = "public_display_wall_100",
    labelKey = "workshopConfig.locations.publicDisplayWall100",
    view = {
        targetOffset = {
            z = 0,
            y = -0.0515,
            x = 0,
        },
        cameraOffset = {
            z = 0,
            y = -1.973,
            x = 0,
        },
        interactionDistance = 2.75,
    },
    label = "Public display - 100-inch wall TV",
    textureDictionary = "sky_doj_wall_tv_100",
},
{
    name = "sky_doj_wall_tv_120",
    locationType = "public_display_wall_120",
    labelKey = "workshopConfig.locations.publicDisplayWall120",
    view = {
        targetOffset = {
            z = 0,
            y = -0.0515,
            x = 0,
        },
        cameraOffset = {
            z = 0,
            y = -2.368,
            x = 0,
        },
        interactionDistance = 3,
    },
    label = "Public display - 120-inch wall TV",
    textureDictionary = "sky_doj_wall_tv_120",
},
{
    name = "sky_doj_wall_tv_150",
    locationType = "public_display_wall_150",
    labelKey = "workshopConfig.locations.publicDisplayWall150",
    view = {
        targetOffset = {
            z = 0,
            y = -0.0515,
            x = 0,
        },
        cameraOffset = {
            z = 0,
            y = -2.96,
            x = 0,
        },
        interactionDistance = 3.5,
    },
    label = "Public display - 150-inch wall TV",
    textureDictionary = "sky_doj_wall_tv_150",
},
{
    name = "sky_doj_projection_screen_01",
    locationType = "public_display_projection",
    labelKey = "workshopConfig.locations.publicDisplayProjection",
    view = {
        targetOffset = {
            z = 0,
            y = -0.014,
            x = 0,
        },
        cameraOffset = {
            z = 0,
            y = -4,
            x = 0,
        },
        interactionDistance = 4.5,
    },
    label = "Public display - 4.5 m projection screen",
    textureDictionary = "sky_doj_projection_screen_01",
},

Keep their name, textureDictionary, locationType and labelKey values together. The per-model view.interactionDistance, targetOffset and cameraOffset values above are part of the new definitions. Existing public display settings and placements are not otherwise reset.

Interaction appearance

Config.Interactions did not exist. Add this complete table as a top-level assignment. It supplies all 23 interaction overrides. A missing distance in an entry deliberately inherits that type's definition; do not add a guessed value.

Config.Interactions = {
    courtroom_check_in = { marker = { enabled = true, type = 1 }, blip = { enabled = false }, npc = { enabled = false }, interactionDistance = 2 },
    courtroom_display_board_93 = { marker = { enabled = false }, blip = { enabled = false }, npc = { enabled = false }, interactionDistance = 2.4 },
    courtroom_display_desk_27 = { marker = { enabled = false }, blip = { enabled = false }, npc = { enabled = false } },
    courtroom_display_projection = { marker = { enabled = false }, blip = { enabled = false }, npc = { enabled = false } },
    courtroom_display_wall_100 = { marker = { enabled = false }, blip = { enabled = false }, npc = { enabled = false } },
    courtroom_display_wall_120 = { marker = { enabled = false }, blip = { enabled = false }, npc = { enabled = false } },
    courtroom_display_wall_150 = { marker = { enabled = false }, blip = { enabled = false }, npc = { enabled = false } },
    courtroom_display_wall_55 = { marker = { enabled = false }, blip = { enabled = false }, npc = { enabled = false } },
    courtroom_display_wall_75 = { marker = { enabled = false }, blip = { enabled = false }, npc = { enabled = false } },
    courtroom_judge_mic = { marker = { enabled = true, type = 1 }, blip = { enabled = false }, npc = { enabled = false }, interactionDistance = 2 },
    courtroom_jury_room = { marker = { enabled = true, type = 1 }, blip = { enabled = false }, npc = { enabled = false }, interactionDistance = 2 },
    courtroom_room = { marker = { enabled = false, type = 1 }, blip = { enabled = false }, npc = { enabled = false }, interactionDistance = 2 },
    courtroom_witness = { marker = { enabled = true, type = 1 }, blip = { enabled = false }, npc = { enabled = false }, interactionDistance = 2 },
    election_booth = { marker = { enabled = false }, blip = { enabled = false }, npc = { enabled = false }, interactionDistance = 2.25 },
    public_display_desk_27 = { marker = { enabled = false }, blip = { enabled = false }, npc = { enabled = false } },
    public_display_projection = { marker = { enabled = false }, blip = { enabled = false }, npc = { enabled = false } },
    public_display_terminal_43 = { marker = { enabled = false }, blip = { enabled = false }, npc = { enabled = false } },
    public_display_wall_100 = { marker = { enabled = false }, blip = { enabled = false }, npc = { enabled = false } },
    public_display_wall_120 = { marker = { enabled = false }, blip = { enabled = false }, npc = { enabled = false } },
    public_display_wall_150 = { marker = { enabled = false }, blip = { enabled = false }, npc = { enabled = false } },
    public_display_wall_55 = { marker = { enabled = false }, blip = { enabled = false }, npc = { enabled = false } },
    public_display_wall_75 = { marker = { enabled = false }, blip = { enabled = false }, npc = { enabled = false } },
    public_legal_code = { marker = { enabled = true, type = 1 }, blip = { enabled = false }, npc = { enabled = false }, interactionDistance = 2 },
}

With /jobconfig enabled, use its Interactions editor for effective overrides. Without it, change these entries in Lua. For a custom model, keep its own definition and add an interaction override only if you need to change its appearance. This table changes appearance and interaction range, not saved world coordinates or courtroom associations.

Elections

Remove pepperConvar = "sky_dojjob_election_pepper", from Config.Elections. That option is retired; the other election configuration is unchanged. There is no new secret option to add.

Keep your pre-update election backup. Apply the matching 0.2.0 database migration while the old resource is stopped. Only after the new implementation and migration are installed should you remove the old set sky_dojjob_election_pepper "..." line from server.cfg. Do not remove it from a server still running 0.1.1. The migration preserves existing vote totals and closes published elections containing legacy votes; review those ballots before starting new voting. Do not copy or publish the old secret in an update notice.

Register configuration

Remove the old Config.RegistryCatalog = { ... } assignment from config/config.lua. The new config/registry.lua loads afterwards and owns registry settings. Its complete supplied contents are:

-- With UseJobConfigurator enabled, edit Registry settings in /jobconfig.
-- Import loads these local values; Reset restores the shipped defaults.
Config.Registry = {}

-- Empty means: use access settings from each definition in config/registry/.
Config.RegistryAccess = { definitions = {} }

-- Each entry is a separate register. Select a license from the sky_base provider
-- and give the register a name. Only these license types may be issued here.
-- Removing an entry hides its register; existing licenses and records are kept.
Config.RegistryLicenses = { definitions = {
    { type = "weapon", label = "Weapon licenses" },
} }

-- Optional legacy workflows. Existing saved overrides and records are retained.
Config.RegistryCatalog = { definitions = {} }

Exact changes:

• Config.Registry is new and initialized once here; the four definition files below fill it afterwards.
• Config.RegistryAccess.definitions is new and empty. Each definition supplies enabled = true, groups = { "doj" }, jobs = {}, minimumLevel = 1, editLevel = 1 unless overridden. Removing an override restores those file defaults; use enabled = false to disable a register deliberately.
• Config.RegistryLicenses.definitions is new and initially contains only weapon / Weapon licenses. Add only license types supported by your selected Sky Base license provider. Removing a type hides its register; it does not revoke licenses or delete records. An empty list hides all license registers.
• Config.RegistryCatalog.definitions previously held notarial_contracts, powers_of_attorney, name_changes, company_registry, association_registry, licensing, administrative_decisions and administrative_objections; the new supplied list is empty. This remains a separate optional legacy catalogue.

Preserve any legacy registers you use

Existing saved dojRegistryCatalog overrides remain effective. If you inherited the old catalogue without an override, or run without /jobconfig, transfer the definitions you actually use into the new location. Keep their existing keys, access and custom names. The complete old standard catalogue is shown below so it can be retained when needed. Put it in config/registry.lua instead of its empty Config.RegistryCatalog assignment, or enter the equivalent values under /jobconfig → DOJ → Registry → DOJ registers. Do not add it as a second conflicting assignment.

Config.RegistryCatalog = {
    definitions = {
        { key = "notarial_contracts", enabled = true, editLevel = 1, jobs = {}, minimumLevel = 1, groups = { "doj" }, label = "Notarial contracts" },
        { key = "powers_of_attorney", enabled = true, editLevel = 1, jobs = {}, minimumLevel = 1, groups = { "doj" }, label = "Powers of attorney" },
        { key = "name_changes", enabled = true, editLevel = 1, jobs = {}, minimumLevel = 1, groups = { "doj" }, label = "Name changes" },
        { key = "company_registry", enabled = true, editLevel = 1, jobs = {}, minimumLevel = 1, groups = { "doj" }, label = "Company registry" },
        { key = "association_registry", enabled = true, editLevel = 1, jobs = {}, minimumLevel = 1, groups = { "doj" }, label = "Association registry" },
        { key = "licensing", enabled = true, editLevel = 1, jobs = {}, minimumLevel = 1, groups = { "doj" }, label = "Licensing" },
        { key = "administrative_decisions", enabled = true, editLevel = 1, jobs = {}, minimumLevel = 1, groups = { "doj" }, label = "Administrative decisions" },
        { key = "administrative_objections", enabled = true, editLevel = 1, jobs = {}, minimumLevel = 1, groups = { "doj" }, label = "Administrative objections" },
    },
}

The legacy register tables remain separate from the new file-based records. Keeping a definition exposes its legacy workflow again; it does not convert or replay old entries through the new name/license hooks. Do not rename an old persistent key to a new one as a migration shortcut.

New file-defined register tables

These four complete new definition tables are supplied in the named files. Keep the matching server hooks listed above. Field IDs and register keys identify saved data; retain them when adjusting labels or access. The Permission.* values are supplied by the resource and should not be replaced with invented numbers.

sky_dojjob/config/registry/name_changes.lua — previously absent:

Config.Registry.name_changes = {
    documentTemplate = "doj-rnc",
    label = "Name changes", labelKey = "registryFiles.nameChanges", order = 1,
    descriptionKey = "registryFiles.nameChangesHint",
    configLabelKey = "workshopConfig.registryCatalog.names.name_changes",
    enabled = true, jobs = {}, groups = { "doj" }, minimumLevel = 1, editLevel = 1,
    readPermission = Permission.VIEW_NAME_CHANGES,
    writePermission = Permission.AUTHORIZE_NAME_CHANGES,
    fields = {
        { key = "identifier", label = "Person", labelKey = "registryFiles.person", type = "text", control = "person", required = true, readonlyOnEdit = true, fullWidth = true, options = {} },
        { key = "firstName", label = "New first name", labelKey = "registryFiles.firstName", type = "text", required = true, options = {} },
        { key = "lastName", label = "New last name", labelKey = "registryFiles.lastName", type = "text", required = true, options = {} },
        { key = "reason", label = "Reason", labelKey = "registryFiles.reason", type = "longtext", required = true, options = {} },
    },
}

sky_dojjob/config/registry/marriages.lua — previously absent:

Config.Registry.marriages = {
    documentTemplate = "doj-rmc", inactiveDocumentTemplate = "doj-rdc",
    label = "Marriage register", labelKey = "registryFiles.marriages", order = 2,
    descriptionKey = "registryFiles.marriagesHint",
    configLabelKey = "workshopConfig.registryFiles.marriages",
    enabled = true, jobs = {}, groups = { "doj" }, minimumLevel = 1, editLevel = 1,
    writePermission = Permission.MANAGE_CASE_FILES,
    fields = {
        { key = "firstPartner", label = "First partner", labelKey = "registryFiles.firstPartner", type = "text", control = "person", required = true, readonlyOnEdit = true, options = {} },
        { key = "secondPartner", label = "Second partner", labelKey = "registryFiles.secondPartner", type = "text", control = "person", required = true, readonlyOnEdit = true, options = {} },
        { key = "date", label = "Marriage date", labelKey = "registryFiles.date", type = "date", required = true, options = {} },
        { key = "active", label = "Marriage in effect", labelKey = "registryFiles.marriageActive", type = "boolean", required = true, default = true, options = {} },
        { key = "divorceDate", label = "Divorce date", labelKey = "registryFiles.divorceDate", type = "date", required = false, options = {}, visibleWhen = { field = "active", value = false } },
        { key = "divorceReason", label = "Divorce reason / decision", labelKey = "registryFiles.divorceReason", type = "longtext", required = false, options = {}, visibleWhen = { field = "active", value = false } },
        { key = "notes", label = "Notes", labelKey = "registryFiles.notes", type = "longtext", required = false, options = {} },
    },
}

sky_dojjob/config/registry/licenses.lua — previously absent:

Config.Registry.licenses = {
    documentTemplate = "doj-rlc",
    label = "Licenses", labelKey = "registryFiles.licenses", order = 3,
    descriptionKey = "registryFiles.licensesHint", removeHintKey = "registryFiles.licensesRemoveHint",
    configLabelKey = "workshopConfig.registryCatalog.names.licensing",
    enabled = true, jobs = {}, groups = { "doj" }, minimumLevel = 1, editLevel = 1,
    readPermission = Permission.VIEW_LICENSING,
    writePermission = Permission.AUTHORIZE_LICENSING,
    fields = {
        { key = "identifier", label = "Person", labelKey = "registryFiles.person", type = "text", control = "person", required = true, readonlyOnEdit = true, options = {} },
        { key = "license", label = "License", labelKey = "registryFiles.license", type = "select", required = true, readonlyOnEdit = true, options = {}, optionsSource = "licenses", emptyHintKey = "registryFiles.noLicenseTypes" },
        { key = "active", label = "License granted", labelKey = "registryFiles.licenseActive", type = "boolean", required = true, default = true, options = {} },
        { key = "reason", label = "Reason", labelKey = "registryFiles.reason", type = "longtext", required = true, options = {} },
    },
}

sky_dojjob/config/registry/businesses.lua — previously absent:

Config.Registry.businesses = {
    documentTemplate = "doj-rbc",
    label = "Business register", labelKey = "registryFiles.businesses", order = 4,
    titleLabelKey = "registryFiles.businessName", descriptionKey = "registryFiles.businessesHint",
    configLabelKey = "workshopConfig.registryCatalog.names.company_registry",
    enabled = true, jobs = {}, groups = { "doj" }, minimumLevel = 1, editLevel = 1,
    writePermission = Permission.MANAGE_CASE_FILES,
    fields = {
        { key = "owner", label = "Owner", labelKey = "registryFiles.businessOwner", type = "text", control = "person", required = true, options = {} },
        { key = "activity", label = "Business activity", labelKey = "registryFiles.businessActivity", type = "text", required = true, options = {} },
        { key = "address", label = "Business address", labelKey = "registryFiles.businessAddress", type = "text", required = false, options = {} },
        { key = "date", label = "Registration date", labelKey = "registryFiles.businessDate", type = "date", required = true, options = {} },
        { key = "active", label = "Business active", labelKey = "registryFiles.businessActive", type = "boolean", required = true, default = true, options = {} },
        { key = "notes", label = "Notes", labelKey = "registryFiles.notes", type = "longtext", required = false, options = {} },
    },
}

The supplied template keys are doj-rnc (name change), doj-rmc (marriage), doj-rdc (divorce), doj-rlc (license) and doj-rbc (business). Custom replacement templates must be published before use. The marriage status selects marriage versus divorce output. Register certificates use the shared job_document printer item; this does not replace the existing doj_document and doj_law_book items. Follow the separate item and SQL steps for this release.

Roles, accounts, integrations and placements

• Case-file access: keep your existing RecordsAuthorization.mappingVersion and technical grade_name assignments. They have no changed Lua default in this update. For an installation without a configured access mapping, first set real values under /jobconfig → DOJ → Case-file access (dojRecordsMappingVersion, dojRecordsProsecutionGradeKeys, dojRecordsJudiciaryGradeKeys, dojRecordsCourtAdministrationGradeKeys). With the configurator off, use the existing Config.RecordsAuthorization table. Then an on-duty manager with Manage roles (shared permission 2) can open Case Files and set up the new functional roles. Keep at least one assigned manager when saving the policy. A saved functional-role policy takes precedence over grade fallback; changing Lua defaults will not overwrite it.
• Register access: file-based register writes require the court-administration functional role plus the file's action permission and clearance. Business/marriage changes require Manage case files (2306); name changes require Authorize name changes (2318); license-register changes require Authorize licensing (2327). Read permissions remain separate. Registry file access does not bypass the normal job/duty/role checks. Person lookup follows the authorized Police Citizens directory; name/license changes need a real supported framework character.
• Finance permissions: assign only the actions intended for your staff: View Finance 2340, Transfer Finance 2341, Collect Finance 2342, View bank accounts 2343, Freeze bank accounts 2344, Manage citizen licenses 2345. These do not get granted by enabling the Finance feature. Citizen license management and license-register authorization are different permission paths.
• Accounts: treasuryJob, allowedJobs and the fine recipient use registered Sky job keys, not raw bank account IDs. Preserve the jobs' existing societyAccount settings. Choosing a new job name does not create a job, business or bank account. Check the selected provider before making real transfers; account lookup, statements and freezes are separate capabilities. For providers without supported direct personal bank payment, choose billing for fines.
• Register integrations: name changes use the selected framework name-change adapter; licenses use the selected license provider. Complete holder import requires provider support for online and offline holders. An incomplete-list notice does not mean nobody owns a license. Marriage records do not change surnames; business records do not create framework jobs or accounts.
• Screens and room groups: keep existing Creator entries and their IDs. Add new display types to the intended courtroom group or public location. The mobile board keeps board_93/sky_doj_court_board_93; its label changes do not change identity. Update the streamed assets together with the config. No courthouse MLO or predefined room/printer placement is added by this update.
• Evidence media: retain Config.Courtroom.allowedMediaHosts and allowAllHttps choices; their defaults are still {} and false. Add the exact approved HTTPS hosts you use. Bodycam/CCTV evidence additionally needs access to the Jobs Base source recording; the URL allowlist alone grants no record access.
• Printers: keep existing DOJ job printer entries. DOJ's printerSettings.paperEnabled = false, capacity 100, refill item printer_paper and refill amount 25 are unchanged. Printer retention is a shared per-printer setting, deleteCopiesAfterRestart, managed in the job's printer editor. Review that value for each printer. Only ready output on opted-in printers is removed at restart; collected items are preserved. Do not add this option as a new global DOJ Config.PrintedDocuments key.

Optional performance diagnostics

Extra profiler information remains disabled by default. If support requests a recording, prepare setr sky_profiler 1 in server.cfg before the Sky ensure lines. Finish all remaining file, configuration, inventory and SQL steps before starting the server through the update sequence below. After the completed update has started and passed its checks, run profiler record 1000 in the server console, wait until profiler status reports completion, then run profiler saveJSON sky-doj-profile.json. Share the file only when requested. To disable the extra information afterward, change the line to setr sky_profiler 0 and restart again. If enabling it later on an already updated server, add the same line and restart before recording. This is not a /jobconfig setting; enabling it does not record or upload anything automatically.

Keep source/ and fxmanifest.lua from the same download even when diagnostics are disabled. Profiler processing changes only source Lua and the manifest. If an older profiler package changed public files outside source/, restore those files once from the clean current download and reapply your own customizations.

Inventory items and printer supplies

Register certificates use the shared job_document item. Existing DOJ document copies continue to use doj_document, and law books continue to use doj_law_book. Do not rename or convert existing items to another type. All three need unique, reusable inventory items with preserved individual metadata; existing issued copies and law editions must retain their identifiers.

For ox_inventory, merge this entry from sky_jobs_base/config/inventory/items_ox.lua into the existing table in ox_inventory/data/items.lua if it is not already installed. Correct an existing entry rather than adding the same key twice:

["job_document"] = {
    label = "Dokument",
    weight = 10,
    stack = false,
    close = true,
    consume = 0,
    description = "Gedruckte Kopie einer Job-Akte.",
    client = { image = "job_document.png" },
},

Copy sky_jobs_base/config/inventory/job_document.png to ox_inventory/web/images/job_document.png. If paper or ink consumption is enabled for a printer, also merge printer_paper and printer_ink from the same Jobs Base item file and copy their matching PNG files to the inventory image directory. Use the configured refill names if you customized them. The supplied definitions use stackable refill items with consume = 0; the printer workflow handles consumption.

Keep the existing doj_document and doj_law_book definitions and their PNG files. Their defaults remain non-stackable and non-consuming, with weights of 10 and 500. The DOJ inventory guide provides the definitions and downloadable icons if they are missing. For another supported inventory, add equivalent entries using that inventory's own format and metadata support. Restart/reload item definitions according to the inventory's normal process. Sky registers the usable actions; do not add a second usable-item callback.

Briefcases and portable case folders are optional Jobs Base items, not a new DOJ certificate requirement. Keep their existing contents and metadata if installed.

Assets and media

• Replace the supplied DOJ display models, texture dictionaries and stream/sky_doj_props.ytyp together from the same package. Keep every numbered courtroom model variant supplied in stream/; they belong to the separate display instances. The updated source/ also supplies the certificate font/layout media and courtroom UI. No extra font installation or courthouse MLO is required.
• Existing Creator placements remain. Configure the larger displays, projection screen or mobile smartboard only where you want to use them. The mobile board is a 150-inch display even though its model is named sky_doj_court_board_93. Its default movement key is F from the rear handle; existing player key-binding overrides still apply. Moving it changes the temporary position, and a resource restart returns it to the saved placement.
• Keep Config.Courtroom.allowedMediaHosts aligned with the exact HTTPS hosts used by your evidence media. The default list is empty; allowAllHttps, allowInsecureMedia and allowNuiMedia are false. List the required hosts instead of enabling broad media access just to make a test pass. Verify a real evidence URL from each configured service after starting. Existing saved /jobconfig overrides also apply to managed courtroom settings.

Database changes

The update adds 19 tables and removes no existing table. New storage covers managed workspaces and permissions, functional roles, handovers and court submissions, immutable redacted/disclosed copies, case placement/responsibility/source links, and the DOJ Finance operation history.

The following existing columns change:

The new nullable columns have no explicit non-null default. Old votes remain with char_id = NULL, because their former keys cannot be converted back to character IDs. Their election/option links and vote totals are preserved. Only published elections containing those old votes are closed; their version increases by one and the migration records the closure. Other election statuses remain unchanged. New votes store the character ID and allow one vote per character per election.

Existing personal workspace storage keys and contents remain. Ownership is pre-registered for legacy owners associated with one job; the personal workspace is also registered when its owner opens the workspace. The default register certificate templates are installed/published while custom template revisions, deleted templates and previously issued document versions are preserved.

Automatic update — Config.AutoExecuteQuery = true

1. Keep Config.AutoExecuteQuery = true in sky_dojjob/config/config.lua. No separate manual import is required for an intact 0.1.1 database.
2. Finish the file, configuration and item changes first. Start the database/framework/inventory dependencies, then sky_base, sky_jobs_base and sky_dojjob, with player access still restricted for maintenance.
3. Let the resource finish starting. Check for database errors as well as the migration messages; a single migration-complete line does not replace the checks below. The automatic path creates the new tables, adds missing columns, replaces the voting key/index, registers existing personal workspaces and seeds the supplied templates.
4. Run the database checks below before opening the server to players. Use /jobconfig only after the resources have started successfully, while maintenance is still active.

Manual update — Config.AutoExecuteQuery = false

1. Keep FXServer stopped and Config.AutoExecuteQuery = false. Open the complete sky_dojjob/import.sql from the 0.2.0 download in your database tool, using the server's existing database.
2. Execute it as a SQL script with support for DELIMITER, stored routines and the supplied MariaDB SQL syntax. The database account must be able to perform the supplied schema changes, create/call/drop the temporary upgrade procedures, and write the migrated/seeded data. Use script execution that stops on errors, and inspect the complete result. Do not send the entire file as one ordinary SQL statement or skip failed statements.
3. Run the full file once. Its CREATE TABLE IF NOT EXISTS statements create the new tables; its separate ALTER, conditional workspace upgrades and election procedure update existing tables. Copying only the new CREATE TABLE definitions would leave an existing server incompletely upgraded.
4. Run the database checks below while the server is still stopped. On an SQL error or a mismatch, keep the server stopped, preserve the error and diagnose the incomplete step. Do not delete a table or its rows to force the import through. Restore the consistent backup if the update must be abandoned; changing only the Lua files back does not undo a migrated database. Schema changes are not all rolled back by a SQL ROLLBACK.
5. After the checks pass, continue to Restart and verify below. Keep FXServer stopped until that step; the manual SQL update is now complete.

Database verification

Run these checks against the database you backed up. On the automatic path, do this after the successful first start; on the manual path, do this after the import and before starting FXServer.

1. Re-run the election queries saved before migration. Every (election_id, option_id) total must match. Published elections that had votes must now be closed; published elections without votes and other previous statuses stay unchanged. Existing vote rows with a null character ID are valid historical votes and must not be deleted or assigned guessed IDs.
2. Confirm that the seven new columns exist with the expected definitions:

SELECT TABLE_NAME, COLUMN_NAME, COLUMN_TYPE, IS_NULLABLE, COLUMN_DEFAULT
FROM INFORMATION_SCHEMA.COLUMNS
WHERE TABLE_SCHEMA = DATABASE() AND (
    (TABLE_NAME = 'sky_doj_case_files' AND COLUMN_NAME = 'record_kind')
    OR (TABLE_NAME = 'sky_doj_workspace_template_versions' AND COLUMN_NAME = 'audience_json')
    OR (TABLE_NAME = 'sky_doj_workspace_template_nodes' AND COLUMN_NAME = 'applied_sort_order')
    OR (TABLE_NAME = 'sky_doj_police_imports' AND COLUMN_NAME IN ('source_job_id', 'source_type', 'source_key'))
    OR (TABLE_NAME = 'sky_doj_election_votes' AND COLUMN_NAME = 'char_id')
)
ORDER BY TABLE_NAME, COLUMN_NAME;

3. Confirm that this returns no rows:

SELECT TABLE_NAME, COLUMN_NAME
FROM INFORMATION_SCHEMA.COLUMNS
WHERE TABLE_SCHEMA = DATABASE() AND (
    (TABLE_NAME = 'sky_doj_election_votes' AND COLUMN_NAME = 'voter_key')
    OR (TABLE_NAME = 'sky_doj_elections' AND COLUMN_NAME = 'voter_pepper_fingerprint')
);

4. Check the voting index. The result must contain uq_sky_doj_election_vote_char, NON_UNIQUE = 0 and columns election_id,char_id; the old voter-key index must be absent:

SELECT INDEX_NAME, NON_UNIQUE,
       GROUP_CONCAT(COLUMN_NAME ORDER BY SEQ_IN_INDEX) AS indexed_columns
FROM INFORMATION_SCHEMA.STATISTICS
WHERE TABLE_SCHEMA = DATABASE() AND TABLE_NAME = 'sky_doj_election_votes'
GROUP BY INDEX_NAME, NON_UNIQUE
ORDER BY INDEX_NAME;

5. Confirm that all 19 new tables exist; this query must return 19:

SELECT COUNT(*) AS new_table_count
FROM INFORMATION_SCHEMA.TABLES
WHERE TABLE_SCHEMA = DATABASE() AND TABLE_TYPE = 'BASE TABLE'
AND TABLE_NAME IN (
    'sky_doj_functional_roles', 'sky_doj_workspaces',
    'sky_doj_workspace_acl_scopes', 'sky_doj_workspace_grants',
    'sky_doj_workflow_commands', 'sky_doj_application_details',
    'sky_doj_filings', 'sky_doj_filing_entries', 'sky_doj_filing_receipts',
    'sky_doj_assignments', 'sky_doj_decision_deliveries',
    'sky_doj_redacted_versions', 'sky_doj_disclosure_packages',
    'sky_doj_handover_routes', 'sky_doj_case_file_relations',
    'sky_doj_case_custody', 'sky_doj_case_custody_handoffs',
    'sky_doj_case_source_links', 'sky_doj_finance_operations'
);

6. sky_doj_courtroom_evidence.file_snapshot_json LONGTEXT NULL already belongs to 0.1.1 and must still exist. It is not a new 0.2.0 column. If it is absent, the installed schema does not match the 0.1.1 starting point; resolve that discrepancy before proceeding with a manual update.

With the automatic SQL path, the updated resources are already running from the database step; keep maintenance active and continue with the checks below. With the manual SQL path, start the database/framework/inventory and configured providers, Base 1.44.0, Jobs Base 1.47.0, the compatible optional Sky jobs you use and DOJ 0.2.0 now. Resolve startup and migration errors while player access is restricted for maintenance.

After all resources have started, connect while maintenance is still active. Perform the applicable checks for the modules and integrations you use; keep deliberately disabled features off. Use an authorized on-duty DOJ character and then a character without the corresponding access:

1. Open existing case files and personal/shared folders. Verify case numbers, document references, stored layouts and access. If enabled, open /jobconfig now to finish the documented role bindings, functional-role setup and saved configuration checks; confirm that a restricted character cannot use the same protected action.
2. Open the register list, save an allowed test record and preview its certificate. Confirm the correct published template is available. Verify an existing customized template still has its intended layout; deliberately deleted templates must stay deleted.
3. Print one register certificate, collect it from the selected physical printer, then read that actual inventory copy. Also read an existing doj_document and law-book item. Check their labels, content and metadata after transfer using your normal test characters. A plain administrator-created item without a copy identifier is not a printing test.
4. Check the configured printer's output count and chosen restart-retention behavior. With retention enabled, a completed uncollected test copy should remain after a controlled restart; with deleteCopiesAfterRestart = true, uncollected completed output should be cleared. Previously collected inventory documents must still read correctly.
5. Compare the migrated election totals and statuses, then use a new test election to check one vote per character. Do not reopen a legacy election containing old votes by changing its database status.
6. Open permitted Mechanic vehicle reports, test the configured evidence host on a courtroom display and try the smartboard's rear handle. Confirm nearby viewers receive the presentation and unauthorized actions are rejected.
7. Test the Finance actions you actually enable against their configured banking/billing providers and role permissions. A submitted bill is not proof of payment. Keep the server in maintenance if any required dependency, migration, item, saved access rule or configured integration fails.

Confirm your intended Finance/Registry feature choices, custom fine recipient and legacy register definitions survived. If /jobconfig is enabled, verify its saved interaction appearance and ranges as well as the unchanged courthouse/printer positions. Test one ordinary handover with selected documents, then a separate transfer of case responsibility with authorized test characters: accepting responsibility gives access to the whole case, including unselected and future content. Existing independent grants remain. Check that neighboring private folders remain inaccessible. If a Finance operation requests administrator review, reconcile its operation history with the provider before attempting another payment.