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.


update tbluser
set inuserstatus = 1
where iduser = X

update tblCompany
set bPrivate = 1
where idCompany = X