ALTER TABLE USR_ENTR_MERC ADD CDRETIRADA VARCHAR2(2)
/

ALTER TABLE USR_ITEM_ENTR_MERC ADD DTFABRPROD DATE
/

ALTER TABLE USR_ITEM_ENTR_MERC ADD DTVALILOTE DATE
/

ALTER TABLE USR_ITEM_ENTR_MERC ADD CDALMOXARIFE VARCHAR2(6)
/

ALTER TABLE USR_ITEM_ENTR_MERC ADD CDLOCALESTOQ VARCHAR2(6)
/

ALTER TABLE USR_ITEM_ENTR_MERC ADD NRLOTEESTQ VARCHAR2(20)
/

ALTER TABLE USR_ITEM_ENTR_MERC ADD NRSUBLOTE VARCHAR2(4)
/

ALTER TABLE USR_LOG_WEBSERVICE ADD CDOPERADOR VARCHAR2(12)
/

ALTER TABLE USR_LOG_WEBSERVICE ADD CUSTOMVAR1 VARCHAR2(100)
/

ALTER TABLE USR_LOG_WEBSERVICE ADD CUSTOMVAR2 VARCHAR2(100)
/

ALTER TABLE USR_LOG_WEBSERVICE ADD CUSTOMVAR3 VARCHAR2(100)
/

ALTER TABLE USR_LOG_WEBSERVICE ADD CUSTOMDATE1 DATE
/

ALTER TABLE USR_LOG_WEBSERVICE ADD CUSTOMFLOAT1 FLOAT
/

ALTER TABLE USR_LOG_WEBSERVICE ADD CUSTOMFLOAT2 FLOAT
/

ALTER TABLE USR_LOG_WEBSERVICE ADD CUSTOMBOOL1 NUMBER
/

ALTER TABLE USR_LOG_WEBSERVICE ADD CUSTOMCLOB1 CLOB
/

ALTER TABLE USR_LOG_WEBSERVICE MODIFY IDACAO VARCHAR2(20)
/

ALTER TABLE USR_LOG_WEBSERVICE DROP CONSTRAINT CKC_IDACAO_USR_LOG_WS
/

ALTER TABLE USR_LOG_WEBSERVICE_DRILL ADD CDBARPRODUTO VARCHAR2(30)
/

ALTER TABLE USR_LOG_WEBSERVICE_DRILL ADD CUSTOMCLOB2 CLOB
/

ALTER TABLE USR_LOG_WEBSERVICE_DRILL ADD SEQLOGDRILL NUMBER
/

ALTER TABLE USR_LOG_WEBSERVICE_DRILL MODIFY IDACAO VARCHAR2(20)
/

ALTER TABLE USR_LOG_WEBSERVICE_DRILL DROP CONSTRAINT FKFIS00728USR_LOG_WS_DRILL
/

ALTER TABLE USR_LOG_WEBSERVICE_DRILL ADD CONSTRAINT FKFIS00728USR_LOG_WS_DRILL PRIMARY KEY (SEQLOG, SEQLOGDRILL)
/