J0-NewsJob

CREATE TABLE IF NOT EXISTS `j0_news_employees` (
    `id` INT UNSIGNED NOT NULL AUTO_INCREMENT,
    `location_id` VARCHAR(64) NOT NULL,
    `citizenid` VARCHAR(64) NOT NULL,
    `role` VARCHAR(64) NOT NULL DEFAULT 'Staff',
    `salary` DECIMAL(10,2) NOT NULL DEFAULT 0.00,
    `created_at` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
    PRIMARY KEY (`id`),
    UNIQUE KEY `uniq_location_citizen` (`location_id`, `citizenid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE IF NOT EXISTS `j0_news_published` (
    `location_id` VARCHAR(64) NOT NULL,
    `body_html` LONGTEXT NOT NULL,
    `updated_at` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
    PRIMARY KEY (`location_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE IF NOT EXISTS `j0_news_finance` (
    `id` INT UNSIGNED NOT NULL AUTO_INCREMENT,
    `location_id` VARCHAR(64) NOT NULL,
    `entry_type` ENUM('deposit', 'withdraw') NOT NULL,
    `amount` DECIMAL(12,2) NOT NULL,
    `memo` VARCHAR(512) NOT NULL DEFAULT '',
    `source` VARCHAR(32) NOT NULL DEFAULT 'manual',
    `created_at` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
    PRIMARY KEY (`id`),
    KEY `idx_loc` (`location_id`),
    KEY `idx_created` (`created_at`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE IF NOT EXISTS `j0_news_world_tv` (
    `id` INT UNSIGNED NOT NULL AUTO_INCREMENT,
    `model` VARCHAR(64) NOT NULL,
    `pos_x` DOUBLE NOT NULL,
    `pos_y` DOUBLE NOT NULL,
    `pos_z` DOUBLE NOT NULL,
    `heading` DOUBLE NOT NULL,
    `pitch_deg` DOUBLE NOT NULL DEFAULT 0,
    `roll_deg` DOUBLE NOT NULL DEFAULT 0,
    `offset_x` DOUBLE NOT NULL DEFAULT 0,
    `offset_y` DOUBLE NOT NULL DEFAULT 0,
    `offset_z` DOUBLE NOT NULL DEFAULT 0,
    `scale` DOUBLE NOT NULL DEFAULT 0.085,
    `range_dist` DOUBLE NOT NULL DEFAULT 20,
    `load_distance` DOUBLE NOT NULL DEFAULT 42,
    `unload_distance` DOUBLE NULL DEFAULT NULL,
    `render_target` VARCHAR(64) NULL DEFAULT NULL,
    PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

['newspaper'] = {
    label = 'Newspaper',
    weight = 200,
    stack = true,
    close = true,
    consume = 0,
    description = 'Pick up the latest edition. Use from inventory to read.',
    client = {
        export = 'J0-NewsJob.useNewspaper',
    },
},

['newspaper'] = {
    name = 'newspaper',
    label = 'Newspaper',
    weight = 200,
    type = 'item',
    image = 'newspaper.png',
    unique = false,
    useable = true,
    shouldClose = true,
    combinable = nil,
    description = 'Pick up the latest edition. Use from inventory to read.',
},