ALTER TABLE bas_smtp_email_log_envio DROP COLUMN autenticacao_oauth;
ALTER TABLE bas_smtp_email_log_envio DROP COLUMN provedor;
ALTER TABLE bas_smtp_email_log_envio DROP COLUMN tenant_id;
ALTER TABLE bas_smtp_email_log_envio DROP COLUMN access_token;
ALTER TABLE bas_smtp_email_log_envio DROP COLUMN refresh_token;
ALTER TABLE bas_smtp_email_log_envio DROP COLUMN expires;

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 client_id character varying;
	 
UPDATE bas_smtp_email_log_envio SET client_id = '' WHERE client_id IS NULL;

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

ALTER TABLE bas_smtp_email_log_envio
	 ALTER COLUMN client_secret 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;