ALTER TABLE GRUPOPER ADD IDPARAMETROS CHAR(1) DEFAULT 'N' NOT NULL
/
ALTER TABLE GRUPOPER ADD CONSTRAINT CKC_IDPARAMETROS  
    CHECK (IDPARAMETROS IN ('S','N','C','O'))
/

ALTER TABLE GRUPOPER ADD IDGESTAOSISTEM CHAR(1) DEFAULT 'N' NOT NULL
/
ALTER TABLE GRUPOPER ADD CONSTRAINT CKC_IDGESTAOSISTEM  
    CHECK (IDGESTAOSISTEM IN ('S','N','C','O'))
/

ALTER TABLE GRUPOPER ADD IDCONFIGVERSAO CHAR(1) DEFAULT 'N' NOT NULL
/
ALTER TABLE GRUPOPER ADD CONSTRAINT CKC_IDCONFIGVERSAO  
    CHECK (IDCONFIGVERSAO IN ('S','N','C','O'))
/
ALTER TABLE GRUPOPER ADD IDGERENSERVI CHAR(1) DEFAULT 'N' NOT NULL
/
ALTER TABLE GRUPOPER ADD CONSTRAINT CKC_IDGERENSERVI  
    CHECK (IDGERENSERVI IN ('S','N','C','O'))
/