--Added New Archive Status in Post Inspection Table --
ALTER TABLE `tblpost_inspections` CHANGE `post_inspection_status` `post_inspection_status` ENUM('pending','completed','cancelled','in-complete','incomplete','sent','requested_changes','archived') CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT 'incomplete';
--Added New Archive Status in Post Inspection Table --

--Added New Archive Status in Work Order Table --
ALTER TABLE `tblwork_orders` CHANGE `status` `status` ENUM('pending','inprogress','completed','cancelled','sent','delegated','archived') CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT 'pending';
--Added New Archive Status in Work Order Table --

--Added New Archive Status in Shopping List Table --
ALTER TABLE `tblshopping_list` CHANGE `status` `status` ENUM('pending','in-progress','completed','archived') CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT 'pending';
--Added New Archive Status in Shopping List Table --