{ CALL ibeammac_iScan.spt_signup(
'simple', #:signuptype,
'initial', #:signupaction,
'', #:customerid,
'', #:customertype,
'Jeff', #:firstname,
'', #:midinit,
'Alphin', #lastname,
'5039997897', #:phone1,
'', #:phone2,
'', #:phone3,
'', #:phone_other,
'JA@gmail.com', #:emailaddress,
'', #:address1,
'', #:address2,
'', #:city,
'', #:state,
'', #:postalcode,
'pw12000', #:password,
'Do you really need a hint?', #:passwordhint,
'', #:notes,
'', #:county,
'', #:country,
'','','','','', #:userfield1,:userfield2,:userfield3,:userfield4,:userfield5,
'','','','','', #:userfield6,:userfield7,:userfield8,:userfield9,:userfield10,
'sq1','sqa1', #:securityquestion1,:securityanswer1,
'sq2','sqa2', #:securityquestion2,:securityanswer2,
'sq3','sqa3', #:securityquestion3,:securityanswer3,
0 , #:usetwofactor,
't1','tt1', #:twofactor1,:twofactor1type,
't2','tt2', #:twofactor2,:twofactor2type,
't3','tt3' #:twofactor3,:twofactor3type,
,?,?,?,?) }


/*
Select *  from customers where emailaddress = 'JA@gmail.com';

Select 
##	concat(' SET VALUE = ',char(39),'xxx',char(39) ,'WHERE propname = ',char(39), propname,char(39) , 'and parentid = v_customerid; ')  
	* FROM ibeammac_iScan.sys_properties where parenttype = 'login'  and parentid in (
Select customerid  from customers where emailaddress = 'JA@gmail.com');




DELETE FROM ibeammac_iScan.sys_properties 
where parenttype = 'login'  
and parentid in (Select customerid  from customers where emailaddress = 'JA@gmail.com');

DELETE from customers where emailaddress = 'JA@gmail.com';

DELETE from ibeammac_iScan.sysseq_nextcustomerno  where identifier = 'JA@gmail.com';

DELETE from 
*/


