-- Add insurer_id FK to vehicle_insurance_policies
ALTER TABLE vehicle_insurance_policies
ADD COLUMN insurer_id BIGINT UNSIGNED NULL AFTER vehicle_id,
ADD CONSTRAINT fk_policy_insurer FOREIGN KEY (insurer_id) REFERENCES insurers(id) ON DELETE SET NULL;