ALTER TABLE ALCADAGERFILI ADD IDEXIGJUSTIFICATIVA VARCHAR2(1) DEFAULT 'N' NOT NULL 
   CONSTRAINT CKC_IDEXIGJUSTIFICATIVA CHECK (IDEXIGJUSTIFICATIVA IN ('S','N'))
/
ALTER TABLE AUTOFORNE ADD CDSETOR VARCHAR2(4) NULL
/
ALTER TABLE AUTOFORNE ADD
	CONSTRAINT FKCMP00587SETOR FOREIGN KEY (CDSETOR)
		REFERENCES SETOR (CDSETOR)
/
CREATE INDEX FKCMP00587SETOR ON AUTOFORNE (CDSETOR)
/
ALTER TABLE PARASUPRI ADD IDUTLPERCORCCOMP VARCHAR2(1) DEFAULT 'N' NOT NULL 
   CONSTRAINT CKC_IDUTLPERCORCCOMP CHECK (IDUTLPERCORCCOMP IN ('S','N'))