----Work Order In Expense Table -- 
ALTER TABLE `tblexpenses`  ADD `work_order_id` BIGINT NULL DEFAULT NULL  AFTER `job_id`,  ADD   INDEX  `work_order_id` (`work_order_id`);

----Work Order In Shopping List Table -- 
ALTER TABLE `tblshopping_list` ADD `work_order_id` BIGINT NULL DEFAULT NULL AFTER `job_id`, ADD INDEX `work_order_id` (`work_order_id`);