add type field in DB and mail template

Signed-off-by: alfabrad <zerovamp@hotmail.com>