Consider to fix active_record_doctor warnings #642
Description
I use the https://rubygems.org/gems/active_record_doctor gem, which reports some warnings.
It would be great, if these warnings could be fixed:
add a updated_at column to solid_queue_claimed_executions
add a updated_at column to solid_queue_failed_executions
add a updated_at column to solid_queue_pauses
add a updated_at column to solid_queue_processes
add a updated_at column to solid_queue_recurring_executions
add a updated_at column to solid_queue_scheduled_executions
add a updated_at column to solid_queue_ready_executions
add a updated_at column to solid_queue_blocked_executions
use `dependent: :delete` or similar on SolidQueue::Job.recurring_execution - associated model SolidQueue::RecurringExecution has no callbacks and can be deleted without loading
add `NOT NULL` to solid_queue_claimed_executions.process_id - models validates its presence but it's not non-NULL in the database
the schema limits solid_queue_recurring_tasks.command to 2048 characters but there's no length validator on SolidQueue::RecurringTask.command - remove the database limit or add the validator
create a foreign key on solid_queue_claimed_executions.process_id - looks like an association without a foreign key constraint
create a foreign key on solid_queue_processes.supervisor_id - looks like an association without a foreign key constraint
add a `presence` validator to SolidQueue::BlockedExecution.queue_name - it's NOT NULL but lacks a validator
add a `presence` validator to SolidQueue::BlockedExecution.priority - it's NOT NULL but lacks a validator
add a `presence` validator to SolidQueue::BlockedExecution.concurrency_key - it's NOT NULL but lacks a validator
add a `presence` validator to SolidQueue::BlockedExecution.expires_at - it's NOT NULL but lacks a validator
add a `presence` validator to SolidQueue::Job.queue_name - it's NOT NULL but lacks a validator
add a `presence` validator to SolidQueue::Job.class_name - it's NOT NULL but lacks a validator
add a `presence` validator to SolidQueue::Job.priority - it's NOT NULL but lacks a validator
add a `presence` validator to SolidQueue::Pause.queue_name - it's NOT NULL but lacks a validator
add a `presence` validator to SolidQueue::Process.kind - it's NOT NULL but lacks a validator
add a `presence` validator to SolidQueue::Process.last_heartbeat_at - it's NOT NULL but lacks a validator
add a `presence` validator to SolidQueue::Process.pid - it's NOT NULL but lacks a validator
add a `presence` validator to SolidQueue::Process.name - it's NOT NULL but lacks a validator
add a `presence` validator to SolidQueue::ReadyExecution.queue_name - it's NOT NULL but lacks a validator
add a `presence` validator to SolidQueue::ReadyExecution.priority - it's NOT NULL but lacks a validator
add a `presence` validator to SolidQueue::RecurringExecution.task_key - it's NOT NULL but lacks a validator
add a `presence` validator to SolidQueue::RecurringExecution.run_at - it's NOT NULL but lacks a validator
add a `presence` validator to SolidQueue::RecurringTask.key - it's NOT NULL but lacks a validator
add a `presence` validator to SolidQueue::RecurringTask.schedule - it's NOT NULL but lacks a validator
add a `presence` validator to SolidQueue::RecurringTask.static - it's NOT NULL but lacks a validator
add a `presence` validator to SolidQueue::ScheduledExecution.queue_name - it's NOT NULL but lacks a validator
add a `presence` validator to SolidQueue::ScheduledExecution.priority - it's NOT NULL but lacks a validator
add a `presence` validator to SolidQueue::ScheduledExecution.scheduled_at - it's NOT NULL but lacks a validator
add a `presence` validator to SolidQueue::Semaphore.key - it's NOT NULL but lacks a validator
add a `presence` validator to SolidQueue::Semaphore.value - it's NOT NULL but lacks a validator
add a `presence` validator to SolidQueue::Semaphore.expires_at - it's NOT NULL but lacks a validator