ALTER TABLE VIGFREQPRATMES ADD CONSTRAINT UN_VIGFREQPRATMES UNIQUE (CDFILIAL, DTVIGENCIA, IDTIPORESTRICAO)
/
ALTER TABLE VIGFREQGRPRATMES ADD IDTIPORESTRICAO VARCHAR2(30) DEFAULT 'CONTRATO' NOT NULL
/
ALTER TABLE VIGFREQGRPRATMES ADD CONSTRAINT CKC_IDTIPORESTRICAO_VFRGRPRMES CHECK (IDTIPORESTRICAO IN ('CONTRATO', 'PLANEJADO'))
/
ALTER TABLE VIGFREQGRPRATMES ADD DTVIGENCIAFIM DATE NULL