ALTER TABLE tbltenant_logo_orders ADD tenant_first_name varchar(355) DEFAULT NULL AFTER tenant_id;
ALTER TABLE tbltenant_logo_orders ADD tenant_last_name varchar(355) DEFAULT NULL AFTER tenant_first_name;
ALTER TABLE tbltenant_logo_orders ADD tenant_email varchar(355) DEFAULT NULL AFTER tenant_last_name;
ALTER TABLE tbltenant_logo_orders ADD tenant_mobile_no varchar(355) DEFAULT NULL AFTER tenant_email;
ALTER TABLE tbltenant_logo_orders ADD tenant_company varchar(355) DEFAULT NULL AFTER tenant_mobile_no;
ALTER TABLE tbltenant_logo_orders ADD business_card_design_back_approved_src varchar(200) DEFAULT NULL AFTER business_card_design_approved_src;

UPDATE tbltenant_logo_orders 
LEFT JOIN tblstaff as staff ON staff.tenant_id = tbltenant_logo_orders.tenant_id AND staff.is_tenant = 1
SET tenant_first_name = staff.firstname,tenant_last_name = staff.lastname ,
tenant_email = staff.email , tenant_mobile_no = staff.phonenumber; 

UPDATE tbltenant_logo_orders 
LEFT JOIN tbltenants as t ON t.id = tbltenant_logo_orders.tenant_id 
SET tenant_company = t.company;
