inventory/backend/migrate_rental_client.sql

USE inventory_db;

ALTER TABLE rental_prices 
ADD COLUMN client_id INT(11) NULL AFTER item_id,
ADD FOREIGN KEY (client_id) REFERENCES clients(id) ON DELETE SET NULL;