update accept_order_details as a left join master_app_production.products as p on a.product_id=p.id set a.validity_period = p.validity_period ;
update order_details as a left join master_app_production.products as p on a.product_id=p.id set a.validity_period = p.validity_period ;
update purchase_details as a left join master_app_production.products as p on a.product_id=p.id set a.validity_period = p.validity_period ;
update sale_details as a left join master_app_production.products as p on a.product_id=p.id set a.validity_period = p.validity_period ;
update shipping_details as a left join master_app_production.products as p on a.product_id=p.id set a.validity_period = p.validity_period ;
update restoration_details as a left join master_app_production.products as p on a.product_id=p.id set a.validity_period = p.validity_period ;
update disposal_details as a left join master_app_production.products as p on a.product_id=p.id set a.validity_period = p.validity_period ;
update sample_details as a left join master_app_production.products as p on a.product_id=p.id set a.validity_period = p.validity_period ;
update adjustment_details as a left join master_app_production.products as p on a.product_id=p.id set a.validity_period = p.validity_period ;
update stocks as a left join master_app_production.products as p on a.product_id=p.id set a.validity_period = p.validity_period ;
