ALTER TABLE PRODFORNCOMP ADD DSPRODUTO VARCHAR2(4000) 
/ 
ALTER TABLE PRODFORNCOMP ADD DSIDFOTOFILESERV VARCHAR2(4000)
/
ALTER TABLE DADOSFORNECOMMERCE ADD IDACESSOUPLOAD VARCHAR2(1) DEFAULT 'N' 
	CONSTRAINT CKC_IDACESUPLD_DADSFORNCOMMER  CHECK (IDACESSOUPLOAD IN ('S','N'))
/
ALTER TABLE AUTGRUPOP DROP CONSTRAINT CKC_IDAUTGRUPOP
/

ALTER TABLE AUTGRUPOP ADD CONSTRAINT CKC_IDAUTGRUPOP CHECK (  
   IDAUTGRUPOP IN ('PCMP','PROD','INAC','ALAC','ENAC','VIAC','INDF','STAR','VALI', 
                   'CONT','VPLA','VPLT','VERI','QUAL','VLIB','CINS','CANA','LLOT', 
                   'FINC','TARE','IRET','RCUS','MABD','BLPR','CARD','REIP','ENAF', 
                   'CAAF','ABAF','APRC','PLPR','CFEC','APBC','REBC','BSOL','BKGA', 
                   'ARRV','SFOS','LBPS','APCO','EFCO','CACO','ALCO','LCMR','LRCD', 
                   'EXBR','EXBP','PROP','APAF','GEAF','RECC','EXCP','EMAP','ACSA', 
                   'AAPR','ACRM','COIM','ACTF','ACPS','PSUP','MTRA','PAOC','INCT', 
                   'CMIS','CENA','GECO','ESVN','GEST','GGER','GAUD','CRMP','CRMR', 
                   'CDGE','ALAT','ACET','ATPR','CLOT','ADSO','APSG','BLOL','AUDP', 
                   'CPRC','SVOL','PROC','DELI','METC','CONF','LOGS','LOGC','PEOL', 
                   'EXAF','SBTP','ACEP','DPAP','ATLC','PEME','PRVE','PRVC','EEEA',
                   'BLIP','TPED','ALTC','ALTP','ALEE','ALEP','AUPA','ALAF','IINP', 
                   'LIRB','ALOP','CQTD','EXCA','IEIA','COFO','CRAF'))
/
CREATE TABLE ACESSOSUPPLY
(
    CDFILIAL 			  VARCHAR2(4)		NOT NULL,
    CDOPERADOR      VARCHAR2(12)  NOT NULL,
    IDPERFILACES 		VARCHAR2(2)		NOT NULL CONSTRAINT CKC_IDPERFILACES_ACESSOSUPPLY CHECK (IDPERFILACES IN ('GU','GO')),
    NRORG 				  NUMBER DEFAULT SYS_CONTEXT('nrorg_ctx','nrorg') NOT NULL,
	  IDATIVO 			  VARCHAR2(1) DEFAULT 'S' NOT NULL CONSTRAINT 
			CKC_IDATIVO_ACESSOSUPPLY CHECK (IDATIVO IN ('S','N')),
    DTINCLUSAO 			DATE 				NULL,
    DTULTATU 			  DATE 			NULL,
    NRORGINCLUSAO 	NUMBER 			DEFAULT SYS_CONTEXT('nrorg_ctx','nrorg')  NULL,
    CDOPERINCLUSAO 	VARCHAR2(12)	DEFAULT '1' NULL,
    NRORGULTATU 		NUMBER 			DEFAULT SYS_CONTEXT('nrorg_ctx','nrorg')  NULL,
    CDOPERULTATU 		VARCHAR2(12) 	DEFAULT '1',
		CONSTRAINT PK_ACESSOSUPPLY PRIMARY KEY (CDFILIAL, CDOPERADOR)
)
/
ALTER TABLE ENDEVENDE MODIFY NMBAIRVEN VARCHAR2(50)
/