ALTER TABLE FCM_HIERARQUIAFUNC ADD NRLOCALCLIENTE NUMBER
/

ALTER TABLE FCM_HIERARQUIAFUNC 
  ADD CONSTRAINT FCM_LOCALCLI_HIERARQFUNC FOREIGN KEY (NRLOCALCLIENTE)
      REFERENCES FCM_LOCALCLI (NRLOCALCLIENTE)
/

	 
ALTER TABLE FCM_PARAMGERAL ADD IDNOTIFNAOCONFORM CHAR(1) NULL
/

ALTER TABLE FCM_PARAMGERAL ADD CONSTRAINT CKC_IDNOTIFNAOCONFORM CHECK (IDNOTIFNAOCONFORM IN ('S', 'N'))
/

UPDATE FCM_PARAMGERAL
   SET IDNOTIFNAOCONFORM = 'N'
 WHERE IDNOTIFNAOCONFORM IS NULL
/
COMMIT
/

ALTER TABLE FCM_PARAMGERAL ADD LISTNOTIFNAOCONFORM VARCHAR2(4000)
/

ALTER TABLE FCM_PARAMGERAL ADD EMAILSNOTIFNAOCONFROM VARCHAR2(4000)
/