ALTER TABLE VIGLIMPESERGR ADD IDTIPORESTRICAO VARCHAR2(30) DEFAULT 'CONTRATO' NOT NULL
/
ALTER TABLE VIGLIMPESERGR ADD CONSTRAINT CKC_IDTIPORESTRICAO_VLIMPSERGR CHECK (IDTIPORESTRICAO IN ('CONTRATO', 'PLANEJADO'))
/
ALTER TABLE VIGLIMPESERGR DROP CONSTRAINT UN_VIGLIMPESERGR
/
ALTER TABLE VIGLIMPESERGR ADD CONSTRAINT UN_VIGLIMPESERGR UNIQUE (CDFILIAL, DTVIGENCIA, IDTIPORESTRICAO)
/
ALTER TABLE VIGLIMPESERGR ADD DTVIGENCIAFIM DATE NULL