SQL File

SQL File

CREATE TABLE IF NOT EXISTS `delivery_job_users` (
    `identifier` VARCHAR(64) NOT NULL,
    `rp_name` VARCHAR(100) NOT NULL DEFAULT 'Unknown Driver',
    `xp` INT UNSIGNED NOT NULL DEFAULT 0,
    `deliveries_completed` INT UNSIGNED NOT NULL DEFAULT 0,
    `total_earned` INT UNSIGNED NOT NULL DEFAULT 0,
    `daily_runs` INT UNSIGNED NOT NULL DEFAULT 0,
    `last_daily_date` DATE DEFAULT NULL,
    `updated_at` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
    PRIMARY KEY (`identifier`),
    KEY `idx_deliveries_completed` (`deliveries_completed` DESC),
    KEY `idx_xp` (`xp` DESC)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;