CREATE TABLE USR_DESCATIVCLIE
(
 CDCLIENTE VARCHAR2(21),
 DESCATIV VARCHAR2(40),
 CONSTRAINT PK_DESCATIVCLIE PRIMARY KEY (CDCLIENTE)
)

/
CREATE TABLE USR_CODTRIBUTSITE
(
 CDFILIAL VARCHAR2(4),
 CDTRIBUTSITE VARCHAR2(9),
 CONSTRAINT PK_CODTRIBUTSITE PRIMARY KEY (CDFILIAL)
)
/

ALTER TABLE USR_DESCATIVCLIE
    ADD CONSTRAINT FKUSR00001DESCATIVCLIE FOREIGN KEY  (CDCLIENTE)
       REFERENCES CLIENTE (CDCLIENTE)
/

ALTER TABLE USR_CODTRIBUTSITE
    ADD CONSTRAINT FKUSR00002CODTRIBUTSITE FOREIGN KEY  (CDFILIAL)
       REFERENCES FILIAL (CDFILIAL)
/

-- VERSAO --
BEGIN ATUVEROBJ('ATUALIZACAO_ESTRUTURA_BD','5.45.xxx'); END;
/