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;
Axel Delivery Job
SQL File
SQL File
