ALTER TABLE FCT_PARAMETROGERAL ADD DSHOSTEMAIL VARCHAR2(500) NULL
/
ALTER TABLE FCT_PARAMETROGERAL ADD DSPORTAEMAIL VARCHAR2(500) NULL
/
ALTER TABLE FCT_PARAMETROGERAL ADD DSUSUARIOEMAIL VARCHAR2(500) NULL
/
ALTER TABLE FCT_PARAMETROGERAL ADD DSSENHAEMAIL VARCHAR2(500) NULL
/
ALTER TABLE FCT_SERVICOORCA ADD IDLICENUSOMANUT CHAR(1) NULL
/
ALTER TABLE FCT_SERVICOORCA ADD CONSTRAINT CK_IDLICENUSOMANUT CHECK(IDLICENUSOMANUT IS NULL OR IDLICENUSOMANUT IN ('L', 'M'))
/
ALTER TABLE FCT_TIPOMEDIDASERV ADD IDQTMINIMA CHAR(1) DEFAULT 'N'  NOT NULL
/
ALTER TABLE FCT_TIPOMEDIDASERV ADD CONSTRAINT CK_IDQTMINIMA CHECK(IDQTMINIMA IN ('S', 'N'))
/
ALTER TABLE FCT_RELACDESPPROPOSTA ADD VRUNITDESPESA FLOAT(126)
/
ALTER TABLE FCT_RESULTORCALIMENT ADD VRPERCSERVICO FLOAT(126)
