UPDATE tblapad_options SET VALUE='{"image": ["jpeg","jpg","png","gif","webp"]}' 
WHERE TYPE = 'estimate_image_files' AND NAME = 'allowed_file_extention' ;

UPDATE tblapad_options SET VALUE = '{"image":["jpeg","jpg","png","gif","webp"],"video":["mp4","mpeg","3gp","mov","mts","m2ts","mxf","webp","avi","mkv","webm"],"audio":[],"document":["pdf","doc","docx","csv","ppt","pptx","xls","xlsx","txt"]}' 
WHERE TYPE = 'estimate_files' AND NAME = 'allowed_file_extention' ;

UPDATE tblapad_options SET VALUE='{"image":["jpeg","jpg","png","gif","webp"],"video":[],"audio":[],"document":[]}' 
WHERE TYPE = 'detail_estimates' AND NAME = 'allowed_file_extention' ;

UPDATE tblapad_options SET VALUE='{"image":["jpeg","jpg","png","gif","webp"],"video":["mp4","mpeg","3gp","mov","mts","m2ts","mxf","webp","avi","mkv","webm"],"audio":[],"document":["pdf","doc","docx","csv","ppt","pptx","xls","xlsx","txt"]}' 
WHERE TYPE = 'expenses' AND NAME = 'allowed_file_extention' ;

UPDATE tblapad_options SET VALUE='{"image":["jpeg","jpg","png","gif","webp"],"video":["mp4","mpeg","3gp","mov","mts","m2ts","mxf","webp","avi","mkv","webm"],"audio":[],"document":["pdf","doc","docx","csv","ppt","pptx","xls","xlsx","txt"]}' 
WHERE TYPE = 'ideas' AND NAME = 'allowed_file_extention' ;

UPDATE tblapad_options SET VALUE='{"image":["jpeg","jpg","png","gif","webp"],"video":["mp4","mpeg","3gp","mov","mts","m2ts","mxf","webp","avi","mkv","webm"],"audio":[],"document":["pdf","doc","docx","csv","ppt","pptx","xls","xlsx","txt"]}' 
WHERE TYPE = 'insurance_license' AND NAME = 'allowed_file_extention' ;

UPDATE tblapad_options SET VALUE='{"image":["jpeg","jpg","png","gif","webp"],"video":["mp4","mpeg","3gp","mov","mts","m2ts","mxf","webp","avi","mkv","webm"],"audio":[],"document":["pdf","doc","docx","csv","ppt","pptx","xls","xlsx","txt"]}' 
WHERE TYPE = 'invoice_files' AND NAME = 'allowed_file_extention' ;

UPDATE tblapad_options SET VALUE='{"image": ["jpeg","jpg","png","gif","webp"]}' 
WHERE TYPE = 'invoice_image_files' AND NAME = 'allowed_file_extention' ;

UPDATE tblapad_options SET VALUE='{"image":["jpeg","jpg","png","gif","webp"],"video":["mp4","mpeg","3gp","mov","mts","m2ts","mxf","webp","avi","mkv","webm"],"audio":[],"document":["pdf","doc","docx","csv","ppt","pptx","xls","xlsx","txt"]}' 
WHERE TYPE = 'job_visit_files' AND NAME = 'allowed_file_extention' ;

UPDATE tblapad_options SET VALUE='{"image": ["jpeg","jpg","png","gif","webp"]}' 
WHERE TYPE = 'job_visit_image_files' AND NAME = 'allowed_file_extention' ;

UPDATE tblapad_options SET VALUE='{"image":["jpeg","jpg","png","gif","webp"],"video":[],"audio":[],"document":[]}' 
WHERE TYPE = 'logo_dark' AND NAME = 'allowed_file_extention' ;

UPDATE tblapad_options SET VALUE='{"image":["jpeg","jpg","png","gif","webp"],"video":["mp4","mpeg","3gp","mov","mts","m2ts","mxf","webp","avi","mkv","webm"],"audio":[],"document":["pdf","doc","docx","csv","ppt","pptx","xls","xlsx","txt"]}' 
WHERE TYPE = 'logo_designing_service' AND NAME = 'allowed_file_extention' ;

UPDATE tblapad_options SET VALUE='{"image":["jpeg","jpg","png","gif","webp"],"video":[],"audio":[],"document":[]}' 
WHERE TYPE = 'logo_light' AND NAME = 'allowed_file_extention' ;

UPDATE tblapad_options SET VALUE='{"image":["jpeg","jpg","png","gif","webp"],"video":[],"audio":[],"document":[]}' 
WHERE TYPE = 'my_business_logo' AND NAME = 'allowed_file_extention' ;

UPDATE tblapad_options SET VALUE='{"image":["jpeg","jpg","png","gif","webp"],"video":["mp4","mpeg","3gp","mov","mts","m2ts","mxf","webp","avi","mkv","webm"],"audio":[],"document":["pdf","doc","docx","csv","ppt","pptx","xls","xlsx","txt"]}' 
WHERE TYPE = 'notes' AND NAME = 'allowed_file_extention' ;

UPDATE tblapad_options SET VALUE='{"image":["jpeg","jpg","png","gif","webp"],"video":["mp4","mpeg","3gp","mov","mts","m2ts","mxf","webp","avi","mkv","webm"],"audio":[],"document":["pdf","doc","docx","csv","ppt","pptx","xls","xlsx","txt"]}' 
WHERE TYPE = 'notification_file' AND NAME = 'allowed_file_extention' ;

UPDATE tblapad_options SET VALUE='{"image":["jpeg","jpg","png","gif","webp"],"video":[],"audio":[],"document":[]}' 
WHERE TYPE = 'post_inspections' AND NAME = 'allowed_file_extention' ;

UPDATE tblapad_options SET VALUE = '{"image":["jpeg","jpg","png","gif","webp"],"video":["mp4","mpeg","3gp","mov","mts","m2ts","mxf","webp","avi","mkv","webm"],"audio":[],"document":["pdf","doc","docx","csv","ppt","pptx","xls","xlsx","txt"]}' 
WHERE TYPE = 'work_order_files' AND NAME = 'allowed_file_extention' ;

UPDATE tblapad_options SET VALUE='{"image": ["jpeg","jpg","png","gif","webp"]}' 
WHERE TYPE = 'work_order_image_files' AND NAME = 'allowed_file_extention' ;

UPDATE tblapad_options SET VALUE='16000' WHERE NAME= 'allowed_file_size' 
AND TYPE IN ('detail_estimates','estimate_files','estimate_image_files','expenses','job_visit_files','job_visit_image_files','logo_designing_service','notes','post_inspections','work_order_files','work_order_image_files','invoice_files','invoice_image_files');








