ALTER TABLE USR_SAP_PRODUTO
DROP CONSTRAINT CKC_STATUS_USR_SAP_PROD
/
ALTER TABLE USR_SAP_PRODUTO
ADD CONSTRAINT CKC_STATUS_USR_SAP_PROD CHECK (STATUS IN (0,1,2,3))
/

ALTER TABLE USR_SAP_FILIAL
DROP CONSTRAINT CKC_STATUS_USR_SAP_FIL
/
ALTER TABLE USR_SAP_FILIAL
ADD CONSTRAINT CKC_STATUS_USR_SAP_FIL CHECK (STATUS IN (0,1,2,3))
/

ALTER TABLE USR_SAP_FORNECEDOR
DROP CONSTRAINT CKC_STATUS_USR_SAP_FORN
/
ALTER TABLE USR_SAP_FORNECEDOR
ADD CONSTRAINT CKC_STATUS_USR_SAP_FORN CHECK (STATUS IN (0,1,2,3))
/

ALTER TABLE USR_SAP_CLIENTE
DROP CONSTRAINT CKC_STATUS_USR_SAP_CLI
/
ALTER TABLE USR_SAP_CLIENTE
ADD CONSTRAINT CKC_STATUS_USR_SAP_CLI CHECK (STATUS IN (0,1,2,3))
/

ALTER TABLE USR_SAP_MUNICIPIO
DROP CONSTRAINT CKC_STATUS_USR_SAP_MUNI
/
ALTER TABLE USR_SAP_MUNICIPIO
ADD CONSTRAINT CKC_STATUS_USR_SAP_MUNI CHECK (STATUS IN (0,1,2,3))
/

ALTER TABLE USR_SAP_NOTAFISCAL
DROP CONSTRAINT CKC_STATUS_USR_SAP_NF
/
ALTER TABLE USR_SAP_NOTAFISCAL
ADD CONSTRAINT CKC_STATUS_USR_SAP_NF CHECK (STATUS IN (0,1,2,3))
/

ALTER TABLE USR_SAP_ITEMPRODUTO
DROP CONSTRAINT CKC_STATUS_USR_SAP_ITPROD
/
ALTER TABLE USR_SAP_ITEMPRODUTO
ADD CONSTRAINT CKC_STATUS_USR_SAP_ITPROD CHECK (STATUS IN (0,1,2,3))
/

ALTER TABLE USR_SAP_ITEMPROIMPOS
DROP CONSTRAINT CKC_STATUS_USR_SAP_PROIMP
/
ALTER TABLE USR_SAP_ITEMPROIMPOS
ADD CONSTRAINT CKC_STATUS_USR_SAP_PROIMP CHECK (STATUS IN (0,1,2,3))
/

ALTER TABLE USR_SAP_ITEMENCARGO
DROP CONSTRAINT CKC_STATUS_USR_SAP_ITENC
/
ALTER TABLE USR_SAP_ITEMENCARGO
ADD CONSTRAINT CKC_STATUS_USR_SAP_ITENC CHECK (STATUS IN (0,1,2,3))
/

ALTER TABLE USR_SAP_VENCIMENTOS
DROP CONSTRAINT CKC_STATUS_USR_SAP_VENC
/
ALTER TABLE USR_SAP_VENCIMENTOS
ADD CONSTRAINT CKC_STATUS_USR_SAP_VENC CHECK (STATUS IN (0,1,2,3))
/

ALTER TABLE USR_SAP_EXPORTACAOTI
DROP CONSTRAINT CKC_STATUS_USR_SAP_TI
/
ALTER TABLE USR_SAP_EXPORTACAOTI
ADD CONSTRAINT CKC_STATUS_USR_SAP_TI CHECK (STATUS IN (0,1,2,3))
/

ALTER TABLE USR_SAP_EXPORTACAOTC
DROP CONSTRAINT CKC_STATUS_USR_SAP_TC
/
ALTER TABLE USR_SAP_EXPORTACAOTC
ADD CONSTRAINT CKC_STATUS_USR_SAP_TC CHECK (STATUS IN (0,1,2,3))
/

ALTER TABLE USR_SAP_EXPORTACAOTM
DROP CONSTRAINT CKC_STATUS_USR_SAP_TM
/
ALTER TABLE USR_SAP_EXPORTACAOTM
ADD CONSTRAINT CKC_STATUS_USR_SAP_TM CHECK (STATUS IN (0,1,2,3))
/

ALTER TABLE USR_SAP_LOG
DROP CONSTRAINT CKC_STATUS_USR_SAP_LOG
/
ALTER TABLE USR_SAP_LOG
ADD CONSTRAINT CKC_STATUS_USR_SAP_LOG CHECK (STATUS IN (0,1,2,3))
/

ALTER TABLE USR_SAP_FATURAMENTO
DROP CONSTRAINT CKC_STATUS_USR_SAP_FAT
/
ALTER TABLE USR_SAP_FATURAMENTO
ADD CONSTRAINT CKC_STATUS_USR_SAP_FAT CHECK (STATUS IN (0,1,2,3))
/

ALTER TABLE USR_SAP_ITEM_FAT
DROP CONSTRAINT CKC_STATUS_USR_SAP_IT_FAT
/
ALTER TABLE USR_SAP_ITEM_FAT
ADD CONSTRAINT CKC_STATUS_USR_SAP_IT_FAT CHECK (STATUS IN (0,1,2,3))
/

ALTER TABLE USR_SAP_INSCESTA
DROP CONSTRAINT CKC_STATUS_USR_SAP_IESTA
/
ALTER TABLE USR_SAP_INSCESTA
ADD CONSTRAINT CKC_STATUS_USR_SAP_IESTA CHECK (STATUS IN (0,1,2,3))
/

ALTER TABLE USR_SAP_INSCMUNI
DROP CONSTRAINT CKC_STATUS_USR_SAP_IMUN
/
ALTER TABLE USR_SAP_INSCMUNI
ADD CONSTRAINT CKC_STATUS_USR_SAP_IMUN CHECK (STATUS IN (0,1,2,3))
/

ALTER TABLE USR_SAP_APURFATUR
DROP CONSTRAINT CKC_STATUS_USR_SAP_APUFAT
/
ALTER TABLE USR_SAP_APURFATUR
ADD CONSTRAINT CKC_STATUS_USR_SAP_APUFAT CHECK (STATUS IN (0,1,2,3))
/

ALTER TABLE USR_SAP_ITAPURFATUR
DROP CONSTRAINT CKC_STATUS_USR_SAP_IAPFAT
/
ALTER TABLE USR_SAP_ITAPURFATUR
ADD CONSTRAINT CKC_STATUS_USR_SAP_IAPFAT CHECK (STATUS IN (0,1,2,3))
/

ALTER TABLE USR_SAP_NFAPROVADA
DROP CONSTRAINT CKC_STATUS_USR_SAP_NFAPV
/
ALTER TABLE USR_SAP_NFAPROVADA
ADD CONSTRAINT CKC_STATUS_USR_SAP_NFAPV CHECK (STATUS IN (0,1,2,3))
/

ALTER TABLE USR_SAP_DADOSADIC
DROP CONSTRAINT CKC_STATUS_USR_DADOSADIC
/
ALTER TABLE USR_SAP_DADOSADIC
ADD CONSTRAINT CKC_STATUS_USR_DADOSADIC CHECK (STATUS IN (0,1,2,3))
/

ALTER TABLE USR_SAP_CLIENFILIAL
DROP CONSTRAINT CKC_STATUS_USR_SAP_CLFIL
/
ALTER TABLE USR_SAP_CLIENFILIAL
ADD CONSTRAINT CKC_STATUS_USR_SAP_CLFIL CHECK (STATUS IN (0,1,2,3))
/


-- VERSAO --
BEGIN ATUVEROBJ('ATUALIZACAO_ESTRUTURA_BD','5.42.XXX'); END;
/