CREATE TABLE bas_api_smtp (
    sequencia integer NOT NULL,
    tipo_envio character varying (1) NOT NULL,
    endpoint_api character varying (50) NOT NULL,
    host_smtp character varying (50) NOT NULL,
	porta integer NOT NULL,
	tipo_conexao character varying (6) NOT NULL,
    usuario_smtp character varying (50) NOT NULL,
    senha_smtp character varying (50) NOT NULL,

    CONSTRAINT pk_bas_api_smtp PRIMARY KEY (sequencia)
);
COMMENT ON COLUMN public.bas_api_smtp.tipo_envio
    IS 'Campo para informar qual o email de envio: A - API, S - SMPT , C - SMTP do Cliente(bas_smtp_email)';

INSERT INTO public.bas_api_smtp(sequencia,  tipo_envio, endpoint_api, host_smtp, porta, tipo_conexao, usuario_smtp, senha_smtp)
	VALUES (1,
	'C',
	'https://api.xmailer.com.br/',
	'smtp18.xmailer.com.br',
	465,
	'ssl',
	'solucaojundiai@solucaojundiai.com.br',
	'djf73msdm2p9k');