ALTER TABLE AUTOFORNE ADD USR_NRIMPORTAF VARCHAR2(10)
/
ALTER TABLE PARAMINTEGRA ADD CDFORNECED VARCHAR2(21)
/
ALTER TABLE PARAMINTEGRA ADD CONSTRAINT FK_PARAMINTEGRA_FORNE001 FOREIGN KEY (CDFORNECED) REFERENCES FORNECEDOR(CDFORNECED)
/ 
ALTER TABLE PARAMINTEGRA ADD DSDIRENVIO VARCHAR2(250)
/
ALTER TABLE PARAMINTEGRA ADD DSHOST VARCHAR2(100)
/
ALTER TABLE PARAMINTEGRA ADD DSLOGIN VARCHAR2(50)
/
ALTER TABLE PARAMINTEGRA ADD DSSENHA VARCHAR2(20)
/
ALTER TABLE ITEMPREBASE ADD CONSTRAINT UN_ITEMPREBASE_SAP UNIQUE(CDPRECOBASE, CDPRODUTO)
/
ALTER TABLE PARAMINTEGRA ADD CDOPERADOR VARCHAR2(12)
/
ALTER TABLE PARAMINTEGRA ADD VRINTERVALO FLOAT
/
CREATE TABLE LOGIMPITEMAUTF
( 
  USR_NRIMPORTAF VARCHAR2(10),
  CDFILDEST VARCHAR2(4),
  CDPRODUTO VARCHAR2(10),
  DTPROGENTAF DATE,
  DTIMPITEMAUTF DATE,
  DSERROIMPORTAF VARCHAR2(100)
)
/
create index LOGIMPITEMAUTF_01 on LOGIMPITEMAUTF ( USR_NRIMPORTAF, CDFILDEST, CDPRODUTO, 
 DTPROGENTAF, DTIMPITEMAUTF)
/
-- VERSAO --
BEGIN ATUVEROBJ('ATUALIZACAO_ESTRUTURA_BD','5.60.061'); END;
/

