ALTER TABLE RELACFILESERVER MODIFY DSEXTENSAO VARCHAR2(10) 
/

CREATE TABLE LOGEMAILVENDA 
(
   NRLOGEMAILVEND   VARCHAR2(10)        NOT NULL,
   DSLOGEMAILVEND   VARCHAR2(1000)      NOT NULL,
   DTLOGEMAILVEND   DATE                NOT NULL,
   IDCONCLEMAILVD   VARCHAR2(1)       	NOT NULL
         CONSTRAINT CKC_IDCONCLEMAILVD CHECK (IDCONCLEMAILVD IN ('S','N')),
   NRORG 			NUMBER 				DEFAULT SYS_CONTEXT('nrorg_ctx','nrorg') NOT NULL,
   IDATIVO 			VARCHAR2(1) 		DEFAULT 'S' NOT NULL
	CONSTRAINT CKC_IDATIVO_LOGEMAILVENDA CHECK (IDATIVO IN ('S','N')),
   DTINCLUSAO 		DATE 				NULL,
   DTULTATU 		DATE 				NULL,
   NRORGINCLUSAO 	NUMBER 				DEFAULT SYS_CONTEXT('nrorg_ctx','nrorg')  NULL,
   CDOPERINCLUSA 	VARCHAR2(12) 		DEFAULT '1' NULL,
   NRORGULTATU 		NUMBER 				DEFAULT SYS_CONTEXT('nrorg_ctx','nrorg') NULL,
   CDOPERULTATU 	VARCHAR2(12) 		DEFAULT '1',
		CONSTRAINT PK_NRLOGEMAILVEND PRIMARY KEY (NRLOGEMAILVEND)
) 