ALTER TABLE FCM_PARAMGERAL ADD IDUTILIZAPERCENTUALAUDIT CHAR (1) DEFAULT 'N' NOT NULL
/

ALTER TABLE FCM_PARAMGERAL ADD IDUTILIZANOTAAUDIT CHAR (1) DEFAULT 'N' NOT NULL
/

ALTER TABLE FCM_TOPICOAUDIT ADD NOTATOPICAUDIT NUMBER
/

ALTER TABLE FCM_CRITERIOAUDIT ADD IDSOMAPERCENTUAL CHAR (1) DEFAULT 'N'
/

ALTER TABLE FCM_CRITERIOAUDIT ADD IDSOMANOTA CHAR (1) DEFAULT 'N'
/

ALTER TABLE FCM_AUDITORIA ADD NOTATOTAL NUMBER
/

ALTER TABLE FCM_AUDITORIA ADD PERCENTUALCONCLUSAO NUMBER
/

ALTER TABLE FCM_CHECKLISTAGEND DROP CONSTRAINT CHK_IDSITUACAOAGEND
/

ALTER TABLE FCM_CHECKLISTAGEND ADD CONSTRAINT CKC_IDSITUACAOAGEND CHECK (IDSITUACAOAGEND IN ('1', '2', '3', '4', '5', '6'))
/

ALTER TABLE FCM_CHECKLISTAGEND ADD NRESCOPOSTAREFA NUMBER
/

ALTER TABLE FCM_GERENCIAMENTOCHK DROP CONSTRAINT CKC_IDSITUACAOGERCHK
/

ALTER TABLE FCM_GERENCIAMENTOCHK ADD CONSTRAINT CKC_IDSITUACAOGERCHK CHECK (IDSITUACAOGERCHK IN ('1', '2', '3', '4', '5'))
/

ALTER TABLE FCM_GERCHKHISTORICO DROP CONSTRAINT CKC_IDTIPOHISTORICO_GERCHKHIST
/

ALTER TABLE FCM_GERCHKHISTORICO ADD CONSTRAINT CKC_IDTIPOHISTORICO_GERCHKHIST CHECK (IDTIPOHISTORICO IN ('1', '2', '3', '4', '5', '6', '7'))
/