CREATE DEFINER=`lawrence880301`@`192.168.56.1` PROCEDURE `sp_RegisterUser`(
    IN in_Email VARCHAR(200),
    IN in_FirstName VARCHAR(100),
    IN in_LastName VARCHAR(100),
    IN in_Dob DATE,
    IN in_Salt CHAR(64),
    IN in_HashedPwd VARCHAR(512)
)
BEGIN
    INSERT INTO tblUser(Email,FirstName,LastName,Dob,Salt,UUID,RegisterDateTime)
    VALUES(in_Email,in_FirstName,in_LastName,in_Dob,in_Salt,uuid(),now());

    SET @last_id_in_tblUser =  last_insert_id();

    INSERT INTO tblUserCredential(HashedPwd,CreateDateTime,UserID)
    VALUES(in_HashedPwd,now(),@last_id_in_tblUser);
END