/* To prevent any potential data loss issues, you should review this script in detail before running it outside the context of the database designer.*/
BEGIN TRANSACTION
SET QUOTED_IDENTIFIER ON
SET ARITHABORT ON
SET NUMERIC_ROUNDABORT OFF
SET CONCAT_NULL_YIELDS_NULL ON
SET ANSI_NULLS ON
SET ANSI_PADDING ON
SET ANSI_WARNINGS ON
COMMIT
BEGIN TRANSACTION
GO
ALTER TABLE dbo.TDU_ConfigEasyPay
    DROP CONSTRAINT FK_TDU_ConfigEasyPay_TDU_ModulosERP
GO
ALTER TABLE dbo.TDU_ModulosERP SET (LOCK_ESCALATION = TABLE)
GO
COMMIT
BEGIN TRANSACTION
GO
ALTER TABLE dbo.TDU_ConfigEasyPay
    DROP CONSTRAINT FK_TDU_ConfigEasyPay_DocumentosCCT
GO
ALTER TABLE dbo.TDU_ConfigEasyPay
    DROP CONSTRAINT FK_TDU_ConfigEasyPay_DocumentosCCT1
GO
ALTER TABLE dbo.DocumentosCCT SET (LOCK_ESCALATION = TABLE)
GO
COMMIT
BEGIN TRANSACTION
GO
ALTER TABLE dbo.TDU_ConfigEasyPay
    DROP CONSTRAINT FK_TDU_ConfigEasyPay_DocumentosBancos
GO
ALTER TABLE dbo.TDU_ConfigEasyPay
    DROP CONSTRAINT FK_TDU_ConfigEasyPay_DocumentosBancos1
GO
ALTER TABLE dbo.TDU_ConfigEasyPay
    DROP CONSTRAINT FK_TDU_ConfigEasyPay_DocumentosBancos2
GO
ALTER TABLE dbo.DocumentosBancos SET (LOCK_ESCALATION = TABLE)
GO
COMMIT
BEGIN TRANSACTION
GO
ALTER TABLE dbo.TDU_ConfigEasyPay
    DROP CONSTRAINT FK_TDU_ConfigEasyPay_ContasBancarias
GO
ALTER TABLE dbo.ContasBancarias SET (LOCK_ESCALATION = TABLE)
GO
COMMIT
BEGIN TRANSACTION
GO
CREATE TABLE dbo.Tmp_TDU_ConfigEasyPay
    (
    CDU_ID int NOT NULL,
    CDU_Descricao nvarchar(100) NULL,
    CDU_Client_id nvarchar(50) NULL,
    CDU_Public_Key nvarchar(200) NULL,
    CDU_Country nvarchar(50) NULL,
    CDU_Entity nvarchar(50) NULL,
    CDU_Cin nvarchar(50) NULL,
    CDU_NewAPI bit NULL,
    CDU_AccountId nvarchar(50) NULL,
    CDU_ApiKey nvarchar(50) NULL,
    CDU_Status nvarchar(50) NULL,
    CDU_Number nvarchar(50) NULL,
    CDU_First nvarchar(50) NULL,
    CDU_Last nvarchar(50) NULL,
    CDU_Date_Ini datetime NULL,
    CDU_Date_End datetime NULL,
    CDU_Transfer_Frequency nvarchar(50) NULL,
    CDU_Nib nvarchar(50) NULL,
    CDU_Alert bit NULL,
    CDU_Mb bit NULL,
    CDU_Visa bit NULL,
    CDU_Amex bit NULL,
    CDU_Dd bit NULL,
    CDU_Credit_Card_Title_From nvarchar(200) NULL,
    CDU_Validation_code nvarchar(200) NULL,
    CDU_DocumentoLiquidacao nvarchar(5) NULL,
    CDU_SerieDocumentoLiquidacao nvarchar(5) NULL,
    CDU_ModoRecebimentoLiquidacao nvarchar(5) NULL,
    CDU_DocumentoLiquidacaoCredito nvarchar(5) NULL,
    CDU_SerieDocumentoLiquidacaoCredito nvarchar(5) NULL,
    CDU_ModoRecebimentoLiquidacaoCredito nvarchar(5) NULL,
    CDU_EfetuaCompensacao bit NULL,
    CDU_DocumentoCompensacao nvarchar(5) NULL,
    CDU_SerieDocumentoCompensacao nvarchar(5) NULL,
    CDU_ModoRecebimentoCompensacao nvarchar(5) NULL,
    CDU_ContaBancaria nvarchar(5) NULL,
    CDU_Demo bit NULL,
    CDU_ValidaIP bit NULL,
    CDU_IntegracaoCRM365 bit NULL,
    CDU_CriaNotaCredito bit NULL,
    CDU_ModuloNotaCredito nvarchar(2) NULL,
    CDU_NotaCredito nvarchar(5) NULL,
    CDU_SerieNotaCredito nvarchar(5) NULL,
    CDU_ModoRecebimentoNotaCredito nvarchar(5) NULL,
    CDU_DiasPesquisaPagamentos int NULL
    )  ON [PRIMARY]
GO
ALTER TABLE dbo.Tmp_TDU_ConfigEasyPay SET (LOCK_ESCALATION = TABLE)
GO
IF EXISTS(SELECT * FROM dbo.TDU_ConfigEasyPay)
     EXEC('INSERT INTO dbo.Tmp_TDU_ConfigEasyPay (CDU_ID, CDU_Descricao, CDU_Client_id, CDU_Public_Key, CDU_Country, CDU_Entity, CDU_Cin, CDU_Status, CDU_Number, CDU_First, CDU_Last, CDU_Date_Ini, CDU_Date_End, CDU_Transfer_Frequency, CDU_Nib, CDU_Alert, CDU_Mb, CDU_Visa, CDU_Amex, CDU_Dd, CDU_Credit_Card_Title_From, CDU_Validation_code, CDU_DocumentoLiquidacao, CDU_SerieDocumentoLiquidacao, CDU_ModoRecebimentoLiquidacao, CDU_DocumentoLiquidacaoCredito, CDU_SerieDocumentoLiquidacaoCredito, CDU_ModoRecebimentoLiquidacaoCredito, CDU_EfetuaCompensacao, CDU_DocumentoCompensacao, CDU_SerieDocumentoCompensacao, CDU_ModoRecebimentoCompensacao, CDU_ContaBancaria, CDU_Demo, CDU_ValidaIP, CDU_IntegracaoCRM365, CDU_CriaNotaCredito, CDU_ModuloNotaCredito, CDU_NotaCredito, CDU_SerieNotaCredito, CDU_ModoRecebimentoNotaCredito, CDU_DiasPesquisaPagamentos)
        SELECT CDU_ID, CDU_Descricao, CDU_Client_id, CDU_Public_Key, CDU_Country, CDU_Entity, CDU_Cin, CDU_Status, CDU_Number, CDU_First, CDU_Last, CDU_Date_Ini, CDU_Date_End, CDU_Transfer_Frequency, CDU_Nib, CDU_Alert, CDU_Mb, CDU_Visa, CDU_Amex, CDU_Dd, CDU_Credit_Card_Title_From, CDU_Validation_code, CDU_DocumentoLiquidacao, CDU_SerieDocumentoLiquidacao, CDU_ModoRecebimentoLiquidacao, CDU_DocumentoLiquidacaoCredito, CDU_SerieDocumentoLiquidacaoCredito, CDU_ModoRecebimentoLiquidacaoCredito, CDU_EfetuaCompensacao, CDU_DocumentoCompensacao, CDU_SerieDocumentoCompensacao, CDU_ModoRecebimentoCompensacao, CDU_ContaBancaria, CDU_Demo, CDU_ValidaIP, CDU_IntegracaoCRM365, CDU_CriaNotaCredito, CDU_ModuloNotaCredito, CDU_NotaCredito, CDU_SerieNotaCredito, CDU_ModoRecebimentoNotaCredito, CDU_DiasPesquisaPagamentos FROM dbo.TDU_ConfigEasyPay WITH (HOLDLOCK TABLOCKX)')
GO
ALTER TABLE dbo.TDU_Parceiros
    DROP CONSTRAINT FK_TDU_Parceiros_TDU_ConfigEasyPay
GO
ALTER TABLE dbo.TDU_Parceiros
    DROP CONSTRAINT FK_TDU_Parceiros_TDU_ConfigEasyPay1
GO
ALTER TABLE dbo.TDU_Parceiros
    DROP CONSTRAINT FK_TDU_Parceiros_TDU_ConfigEasyPay2
GO
ALTER TABLE dbo.TDU_Parceiros
    DROP CONSTRAINT FK_TDU_Parceiros_TDU_ConfigEasyPay3
GO
ALTER TABLE dbo.TDU_Parceiros
    DROP CONSTRAINT FK_TDU_Parceiros_TDU_ConfigEasyPay4
GO
ALTER TABLE dbo.TDU_Parceiros
    DROP CONSTRAINT FK_TDU_Parceiros_TDU_ConfigEasyPay5
GO
ALTER TABLE dbo.TDU_Parceiros
    DROP CONSTRAINT FK_TDU_Parceiros_TDU_ConfigEasyPay6
GO
ALTER TABLE dbo.TDU_Parceiros
    DROP CONSTRAINT FK_TDU_Parceiros_TDU_ConfigEasyPay7
GO
ALTER TABLE dbo.TDU_Parceiros
    DROP CONSTRAINT FK_TDU_Parceiros_TDU_ConfigEasyPay8
GO
ALTER TABLE dbo.TDU_Parceiros
    DROP CONSTRAINT FK_TDU_Parceiros_TDU_ConfigEasyPay9
GO
DROP TABLE dbo.TDU_ConfigEasyPay
GO
EXECUTE sp_rename N'dbo.Tmp_TDU_ConfigEasyPay', N'TDU_ConfigEasyPay', 'OBJECT'
GO
ALTER TABLE dbo.TDU_ConfigEasyPay ADD CONSTRAINT
    PK_TDU_ConfigEasyPay PRIMARY KEY CLUSTERED
    (
    CDU_ID
    ) WITH( STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]

GO
ALTER TABLE dbo.TDU_ConfigEasyPay ADD CONSTRAINT
    FK_TDU_ConfigEasyPay_ContasBancarias FOREIGN KEY
    (
    CDU_ContaBancaria
    ) REFERENCES dbo.ContasBancarias
    (
    Conta
    ) ON UPDATE  NO ACTION
     ON DELETE  NO ACTION

GO
ALTER TABLE dbo.TDU_ConfigEasyPay ADD CONSTRAINT
    FK_TDU_ConfigEasyPay_DocumentosBancos FOREIGN KEY
    (
    CDU_ModoRecebimentoLiquidacao
    ) REFERENCES dbo.DocumentosBancos
    (
    Movim
    ) ON UPDATE  NO ACTION
     ON DELETE  NO ACTION

GO
ALTER TABLE dbo.TDU_ConfigEasyPay ADD CONSTRAINT
    FK_TDU_ConfigEasyPay_DocumentosBancos1 FOREIGN KEY
    (
    CDU_ModoRecebimentoNotaCredito
    ) REFERENCES dbo.DocumentosBancos
    (
    Movim
    ) ON UPDATE  NO ACTION
     ON DELETE  NO ACTION

GO
ALTER TABLE dbo.TDU_ConfigEasyPay ADD CONSTRAINT
    FK_TDU_ConfigEasyPay_DocumentosBancos2 FOREIGN KEY
    (
    CDU_ModoRecebimentoLiquidacaoCredito
    ) REFERENCES dbo.DocumentosBancos
    (
    Movim
    ) ON UPDATE  NO ACTION
     ON DELETE  NO ACTION

GO
ALTER TABLE dbo.TDU_ConfigEasyPay ADD CONSTRAINT
    FK_TDU_ConfigEasyPay_DocumentosCCT FOREIGN KEY
    (
    CDU_DocumentoLiquidacao
    ) REFERENCES dbo.DocumentosCCT
    (
    Documento
    ) ON UPDATE  NO ACTION
     ON DELETE  NO ACTION

GO
ALTER TABLE dbo.TDU_ConfigEasyPay ADD CONSTRAINT
    FK_TDU_ConfigEasyPay_DocumentosCCT1 FOREIGN KEY
    (
    CDU_DocumentoLiquidacaoCredito
    ) REFERENCES dbo.DocumentosCCT
    (
    Documento
    ) ON UPDATE  NO ACTION
     ON DELETE  NO ACTION

GO
ALTER TABLE dbo.TDU_ConfigEasyPay ADD CONSTRAINT
    FK_TDU_ConfigEasyPay_TDU_ModulosERP FOREIGN KEY
    (
    CDU_ModuloNotaCredito
    ) REFERENCES dbo.TDU_ModulosERP
    (
    CDU_ID
    ) ON UPDATE  NO ACTION
     ON DELETE  NO ACTION

GO
COMMIT
BEGIN TRANSACTION
GO
ALTER TABLE dbo.TDU_Parceiros ADD CONSTRAINT
    FK_TDU_Parceiros_TDU_ConfigEasyPay FOREIGN KEY
    (
    CDU_ConfiguracaoEasyPay1
    ) REFERENCES dbo.TDU_ConfigEasyPay
    (
    CDU_ID
    ) ON UPDATE  NO ACTION
     ON DELETE  NO ACTION

GO
ALTER TABLE dbo.TDU_Parceiros ADD CONSTRAINT
    FK_TDU_Parceiros_TDU_ConfigEasyPay1 FOREIGN KEY
    (
    CDU_ConfiguracaoEasyPay2
    ) REFERENCES dbo.TDU_ConfigEasyPay
    (
    CDU_ID
    ) ON UPDATE  NO ACTION
     ON DELETE  NO ACTION

GO
ALTER TABLE dbo.TDU_Parceiros ADD CONSTRAINT
    FK_TDU_Parceiros_TDU_ConfigEasyPay2 FOREIGN KEY
    (
    CDU_ConfiguracaoEasyPay3
    ) REFERENCES dbo.TDU_ConfigEasyPay
    (
    CDU_ID
    ) ON UPDATE  NO ACTION
     ON DELETE  NO ACTION

GO
ALTER TABLE dbo.TDU_Parceiros ADD CONSTRAINT
    FK_TDU_Parceiros_TDU_ConfigEasyPay3 FOREIGN KEY
    (
    CDU_ConfiguracaoEasyPay4
    ) REFERENCES dbo.TDU_ConfigEasyPay
    (
    CDU_ID
    ) ON UPDATE  NO ACTION
     ON DELETE  NO ACTION

GO
ALTER TABLE dbo.TDU_Parceiros ADD CONSTRAINT
    FK_TDU_Parceiros_TDU_ConfigEasyPay4 FOREIGN KEY
    (
    CDU_ConfiguracaoEasyPay5
    ) REFERENCES dbo.TDU_ConfigEasyPay
    (
    CDU_ID
    ) ON UPDATE  NO ACTION
     ON DELETE  NO ACTION

GO
ALTER TABLE dbo.TDU_Parceiros ADD CONSTRAINT
    FK_TDU_Parceiros_TDU_ConfigEasyPay5 FOREIGN KEY
    (
    CDU_ConfiguracaoEasyPay6
    ) REFERENCES dbo.TDU_ConfigEasyPay
    (
    CDU_ID
    ) ON UPDATE  NO ACTION
     ON DELETE  NO ACTION

GO
ALTER TABLE dbo.TDU_Parceiros ADD CONSTRAINT
    FK_TDU_Parceiros_TDU_ConfigEasyPay6 FOREIGN KEY
    (
    CDU_ConfiguracaoEasyPay7
    ) REFERENCES dbo.TDU_ConfigEasyPay
    (
    CDU_ID
    ) ON UPDATE  NO ACTION
     ON DELETE  NO ACTION

GO
ALTER TABLE dbo.TDU_Parceiros ADD CONSTRAINT
    FK_TDU_Parceiros_TDU_ConfigEasyPay7 FOREIGN KEY
    (
    CDU_ConfiguracaoEasyPay8
    ) REFERENCES dbo.TDU_ConfigEasyPay
    (
    CDU_ID
    ) ON UPDATE  NO ACTION
     ON DELETE  NO ACTION

GO
ALTER TABLE dbo.TDU_Parceiros ADD CONSTRAINT
    FK_TDU_Parceiros_TDU_ConfigEasyPay8 FOREIGN KEY
    (
    CDU_ConfiguracaoEasyPay9
    ) REFERENCES dbo.TDU_ConfigEasyPay
    (
    CDU_ID
    ) ON UPDATE  NO ACTION
     ON DELETE  NO ACTION

GO
ALTER TABLE dbo.TDU_Parceiros ADD CONSTRAINT
    FK_TDU_Parceiros_TDU_ConfigEasyPay9 FOREIGN KEY
    (
    CDU_ConfiguracaoEasyPay10
    ) REFERENCES dbo.TDU_ConfigEasyPay
    (
    CDU_ID
    ) ON UPDATE  NO ACTION
     ON DELETE  NO ACTION

GO
ALTER TABLE dbo.TDU_Parceiros SET (LOCK_ESCALATION = TABLE)
GO
COMMIT