CREATE TABLE public.bas_smtp_email_provedor
(
    sequencia integer NOT NULL,
	descricao character varying(100) NOT NULL,
	sugere_host character varying(1) NOT NULL,
    host character varying(100) NOT NULL,
	port integer NOT NULL,
	autenticacao_oauth character varying(1) NOT NULL,
	client_id character varying NOT NULL,
    client_secret character varying NOT NULL,
	redirect_uri character varying NOT NULL,
    CONSTRAINT pk_bas_smtp_email_provedor PRIMARY KEY (sequencia)
)

TABLESPACE pg_default;

ALTER TABLE IF EXISTS public.bas_smtp_email_provedor
    OWNER to postgres;
	

INSERT INTO bas_smtp_email_provedor (sequencia, descricao, sugere_host, host, port, autenticacao_oauth, client_id, client_secret, redirect_uri) VALUES(1, 'OUTROS', 'N', '', 0, 'N', '', '', '');
INSERT INTO bas_smtp_email_provedor (sequencia, descricao, sugere_host, host, port, autenticacao_oauth, client_id, client_secret, redirect_uri) VALUES(2, 'AZURE', 'S', 'smtp.office365.com', 587, 'S', '32258a9f-0e08-482d-bae1-0e7fc74af6fd', '~7_8Q~AkDDcI20b.i2CTYUCTwi7l9dFA5PLyYaqQ', 'https://solucaojundiai.com.br/validaemail');



ALTER TABLE bas_smtp_email
  ADD COLUMN provedor integer;

UPDATE bas_smtp_email SET provedor = 1 WHERE provedor IS NULL;

ALTER TABLE bas_smtp_email
  ALTER COLUMN provedor SET NOT NULL;



ALTER TABLE bas_smtp_email
  ADD COLUMN tenant_id character varying(20);

UPDATE bas_smtp_email SET tenant_id = '' WHERE tenant_id IS NULL;

ALTER TABLE bas_smtp_email
  ALTER COLUMN tenant_id SET NOT NULL;
  

 
ALTER TABLE bas_smtp_email
  ADD COLUMN access_token character varying;

UPDATE bas_smtp_email SET access_token = '' WHERE access_token IS NULL;

ALTER TABLE bas_smtp_email
  ALTER COLUMN access_token SET NOT NULL;
  
ALTER TABLE bas_smtp_email
  ADD COLUMN refresh_token character varying;

UPDATE bas_smtp_email SET refresh_token = '' WHERE refresh_token IS NULL;

ALTER TABLE bas_smtp_email
  ALTER COLUMN refresh_token SET NOT NULL;

  
ALTER TABLE bas_smtp_email
  ADD COLUMN expires bigint;

UPDATE bas_smtp_email SET expires = 0 WHERE expires IS NULL;

ALTER TABLE bas_smtp_email
  ALTER COLUMN expires SET NOT NULL;



ALTER TABLE bas_smtp_email
  ADD COLUMN state character varying;

UPDATE bas_smtp_email SET state = '' WHERE state IS NULL;

ALTER TABLE bas_smtp_email
  ALTER COLUMN state SET NOT NULL;



ALTER TABLE bas_smtp_email_log_envio
	 ADD COLUMN autenticacao_oauth character varying(1);
	 
UPDATE bas_smtp_email_log_envio SET autenticacao_oauth = 'N' WHERE autenticacao_oauth IS NULL;

ALTER TABLE bas_smtp_email_log_envio
	 ALTER COLUMN autenticacao_oauth SET NOT NULL;
	 

ALTER TABLE bas_smtp_email_log_envio
	 ADD COLUMN provedor character varying(100);
	 
UPDATE bas_smtp_email_log_envio SET provedor = 'OUTROS' WHERE provedor IS NULL;

ALTER TABLE bas_smtp_email_log_envio
	 ALTER COLUMN provedor SET NOT NULL;
	 
	 

ALTER TABLE bas_smtp_email_log_envio
	 ADD COLUMN tenant_id character varying(20);
	 
UPDATE bas_smtp_email_log_envio SET tenant_id = '' WHERE tenant_id IS NULL;

ALTER TABLE bas_smtp_email_log_envio
	 ALTER COLUMN tenant_id SET NOT NULL;
	 								

ALTER TABLE bas_smtp_email_log_envio
	 ADD COLUMN access_token character varying;
	 
UPDATE bas_smtp_email_log_envio SET access_token = '' WHERE access_token IS NULL;

ALTER TABLE bas_smtp_email_log_envio
	 ALTER COLUMN access_token SET NOT NULL;
	 
	 
ALTER TABLE bas_smtp_email_log_envio
	 ADD COLUMN refresh_token character varying;
	 
UPDATE bas_smtp_email_log_envio SET refresh_token = '' WHERE refresh_token IS NULL;

ALTER TABLE bas_smtp_email_log_envio
	 ALTER COLUMN refresh_token SET NOT NULL;
	 
ALTER TABLE bas_smtp_email_log_envio
	 ADD COLUMN expires bigint;
	 
UPDATE bas_smtp_email_log_envio SET expires = 0 WHERE expires IS NULL;

ALTER TABLE bas_smtp_email_log_envio
	 ALTER COLUMN expires SET NOT NULL;