|
id
|
char(36)
|
|
|
|
|
name
|
varchar(255)
|
|
|
|
|
type
|
varchar(15)
|
|
|
user
|
|
user_id
|
char(36)
|
|
|
|
|
smtp_from_name
|
varchar(255)
|
|
|
|
|
smtp_from_addr
|
varchar(255)
|
|
|
|
|
reply_to_name
|
varchar(255)
|
|
|
|
|
reply_to_addr
|
varchar(255)
|
|
|
|
|
signature
|
text
|
|
|
|
|
mail_sendtype
|
varchar(8)
|
|
|
SMTP
|
|
mail_smtptype
|
varchar(20)
|
|
|
other
|
|
mail_smtpserver
|
varchar(100)
|
|
|
|
|
mail_smtpport
|
varchar(5)
|
|
|
25
|
|
mail_smtpuser
|
varchar(100)
|
|
|
|
|
mail_smtppass
|
varchar(100)
|
|
|
|
|
mail_smtpauth_req
|
tinyint(1)
|
|
|
0
|
|
mail_smtpssl
|
varchar(1)
|
|
|
0
|
|
date_entered
|
datetime
|
|
|
|
|
date_modified
|
datetime
|
|
|
|
|
modified_user_id
|
char(36)
|
|
|
|
|
created_by
|
char(36)
|
|
|
|
|
deleted
|
tinyint(1)
|
|
|
0
|
|
assigned_user_id
|
char(36)
|
|
|
|
|
auth_type
|
varchar(255)
|
|
|
no_auth
|
|
external_oauth_connection_id
|
char(36)
|
|
|
|