ALTER TABLE SUGESTAOITEM ADD NRORDEMSUG NUMBER(2)
/

ALTER TABLE GRUPROMOCPROD ADD IDIMPGRPROMO VARCHAR2(1) DEFAULT 'N' NOT NULL
	CONSTRAINT CKC_IDIMPGRPROM_GRUPMOCPROD CHECK (IDIMPGRPROMO IN ('S','N'))
/

ALTER TABLE GRUPROMOCPRFIL ADD IDIMPGRPROMOFIL VARCHAR2(1) DEFAULT 'N' NOT NULL
	CONSTRAINT CKC_IDIMPGRPROMFIL_GRPROPRFIL CHECK (IDIMPGRPROMOFIL IN ('S','N'))
/

ALTER TABLE PRODUTOADIC ADD IDCOBRAADIC VARCHAR2(1) DEFAULT 'S' NOT NULL
	CONSTRAINT CKC_IDCOBRAADIC_PRODADIC CHECK (IDCOBRAADIC IN ('S','N'))
/

ALTER TABLE PARAVEND ADD DSLOGINAME VARCHAR2(100)
/

ALTER TABLE PARAVEND ADD DSSENHAAME VARCHAR2(100)
/

ALTER TABLE PARAVEND ADD VRCASHBACK NUMBER
/

ALTER TABLE TIPORECE DROP CONSTRAINT CKC_IDTIPORECE
/

ALTER TABLE TIPORECE ADD CONSTRAINT CKC_IDTIPORECE CHECK (IDTIPORECE IN ('1','2','3','4','5','6','7','8','9','A','B','C','E','F','G','H', 'I'))
/