Docs/DB schema/trunk/media type

This table contains [please add a brief table description].

Columns

Column	Detail	Default	NULL?	Type	Ref from	Ref to
mediatypeid		NONE	NOT NULL	id		alerts.mediatypeid C media.mediatypeid C opmessage.mediatypeid
type		0	NOT NULL	integer
description		EMPTY	NOT NULL	varchar(100)
smtp_server		EMPTY	NOT NULL	varchar(255)
smtp_helo		EMPTY	NOT NULL	varchar(255)
smtp_email		EMPTY	NOT NULL	varchar(255)
exec_path		EMPTY	NOT NULL	varchar(255)
gsm_modem		EMPTY	NOT NULL	varchar(255)
username		EMPTY	NOT NULL	varchar(255)
passwd		EMPTY	NOT NULL	varchar(255)
status		0	NOT NULL	integer
smtp_port		25	NOT NULL	integer
smtp_security		0	NOT NULL	integer
smtp_verify_peer		0	NOT NULL	integer
smtp_verify_host		0	NOT NULL	integer
smtp_authentication		0	NOT NULL	integer
exec_params		EMPTY	NOT NULL	varchar(255)
maxsessions		1	NOT NULL	integer
maxattempts		3	NOT NULL	integer
attempt_interval		10s	NOT NULL	varchar(32)

Indexes

Name	UNIQ	Columns
PRIMARY KEY	YES	mediatypeid
media_type_1	YES	description