ALTER TABLE GRUPOPRATO ADD CONSTRAINT UN_GRUPOPRATO UNIQUE (CDFILIAL, CDGRUPOPRATO, IDTIPORESTRICAO)
/
ALTER TABLE VIGFREQPRATMES ADD IDTIPORESTRICAO VARCHAR2(30) DEFAULT 'CONTRATO' NOT NULL
/
ALTER TABLE VIGFREQPRATMES ADD CONSTRAINT CKC_IDTIPORESTRICAO_VIGFRPRMES CHECK (IDTIPORESTRICAO IN ('CONTRATO', 'PLANEJADO'))
/
ALTER TABLE VIGFREQPRATMES ADD DTVIGENCIAFIM DATE NULL