ALTER TABLE VERSAOGOP ADD CONSTRAINT CKC_IDPERIODOORCA_VERSAOGOP CHECK (IDPERIODOORCA IN ('MENSAL','BIMESTRAL','TRIMESTRAL','QUADRIMESTRAL','SEMESTRAL','ANUAL'))
/
ALTER TABLE VERSAOGOP ADD CONSTRAINT CKC_IDATIVO_VERSAOGOP CHECK (IDATIVO IN ('S','N'))
/
ALTER TABLE VERSAOGOP ADD CONSTRAINT PK_VERSAOGOP PRIMARY KEY (NRVERSAOGOP)
/
CREATE INDEX FKGOP00721APROVAORCAGOP ON VERSAOGOP (NRAPROVAORCAGOP)