ALTER TABLE SOLICITA ADD IDSITSCALCADA VARCHAR2(30) NULL
/
ALTER TABLE SOLICITA ADD CONSTRAINT CKC_IDSITSCALCADA CHECK (IDSITSCALCADA IS NULL OR (IDSITSCALCADA IN ('PENDENTE', 'APROVADA', 'RECUSADA', 'SEM_ALCADA')))
/
ALTER TABLE CONSISTORCAMENTO ADD CDDESPPREV VARCHAR2(3) NULL
/
ALTER TABLE CONFIGALCADA ADD IDTIPORCAOP VARCHAR2(30) DEFAULT 'CONSUMO' NOT NULL
/
ALTER TABLE CONFIGALCADA ADD CONSTRAINT CKC_IDTIPORCAOP CHECK (IDTIPORCAOP IN ('CONSUMO', 'DESPESA'))
/
ALTER TABLE CONFIGALCADA ADD CDDESPPREV VARCHAR2(10) NULL