ALTER TABLE PARAVEND ADD DSLOGINAME VARCHAR2(100)
/

ALTER TABLE PARAVEND ADD DSLOGINAMEHOM VARCHAR2(100)
/

ALTER TABLE PARAVEND ADD DSSENHAAME VARCHAR2(100)
/

ALTER TABLE PARAVEND ADD DSSENHAAMEHOM VARCHAR2(100)
/

ALTER TABLE PARAVEND ADD IDAMBIENTEAME VARCHAR2(1) 
/

ALTER TABLE PARAVEND ADD CONSTRAINT CKC_PARAVEND_IDAMBIENTEAME CHECK (IDAMBIENTEAME IN ('H', 'P'))
/

ALTER TABLE PARAVEND ADD VRCASHBACK NUMBER
/

ALTER TABLE PARAVEND ADD DSURLSERVAME VARCHAR2(200)
/

ALTER TABLE MOVCAIXA ADD IDTRANSAME VARCHAR2(50)
/

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'))
/