#CLICKHOME TEAM:

When an email as per below is sent, we need to check the company for legitimacy, decided if they are a builder or supplier and then verify their account and set their account to Builder if required.

Following this we need to send them an email.

Scripts 

update tbluser
set inuserstatus = 1
where iduser = X


update tblCompany
set bPrivate = 1
where idCompany = X