ALTER TABLE PREVPAXVOOPRODM ADD IDPADRAOCALC VARCHAR2(1) DEFAULT '1' NOT NULL
/
ALTER TABLE PREVPAXVOOPRODM ADD CONSTRAINT CKC_IDPADRAOCALC_PREVPAXVOO CHECK (IDPADRAOCALC IN ('1', '2', '3', '4', '5'))
/
ALTER TABLE PREVPAXVOOPRODM ADD NRPADRAOGERPREVPAX NUMBER NULL
/
ALTER TABLE PREVPAXVOOPRODM ADD CONSTRAINT FKCOC00742PADRAOGERPREVPAX FOREIGN KEY  (CDFILIAL, NRPADRAOGERPREVPAX, NRORG) REFERENCES PADRAOGERPREVPAX (CDFILIAL, NRPADRAOGERPREVPAX, NRORG)
/
CREATE INDEX FKCOC00742PADRAOGERPREVPAX ON PREVPAXVOOPRODM (CDFILIAL, NRPADRAOGERPREVPAX, NRORG)
/
ALTER TABLE PREVPAXVOOPRODM DROP CONSTRAINT CKC_IDPREVISAOPROD_PREVPAXVOO
/
ALTER TABLE PREVPAXVOOPRODM ADD CONSTRAINT CKC_IDPREVISAOPROD_PREVPAXVOO CHECK (IDPREVISAOPROD IN ('P', 'A', 'G', 'C'))
/
ALTER TABLE PREVPAXPRODM ADD CONSTRAINT UN_PREVPAXPRODM UNIQUE (CDFILIAL, DTPREVISAOPROD, NRORG)