/*
DATABASE:    [EsbZertifikatManager]
OBJECTNAME:  SonicContainer.CertificateCheckUrl
ACTION:      ALTER
IDX:         005
DATE:        2026-07-31
USER:        CUR
COMMENT:     URL/Host:Port fuer TLS-Zertifikatspruefung (curl-aehnlich) am Container.
*/
USE [EsbZertifikatManager];
GO

IF COL_LENGTH(N'dbo.SonicContainer', N'CertificateCheckUrl') IS NULL
BEGIN
    IF COL_LENGTH(N'dbo.SonicContainer', N'vertifiaktechecurl') IS NOT NULL
    BEGIN
        EXEC sp_rename
            N'dbo.SonicContainer.vertifiaktechecurl',
            N'CertificateCheckUrl',
            N'COLUMN';
    END
    ELSE IF COL_LENGTH(N'dbo.SonicContainer', N'VerifyCertificateCheckCurl') IS NOT NULL
    BEGIN
        EXEC sp_rename
            N'dbo.SonicContainer.VerifyCertificateCheckCurl',
            N'CertificateCheckUrl',
            N'COLUMN';
    END
    ELSE IF COL_LENGTH(N'dbo.SonicContainer', N'CertificateCheckCurl') IS NOT NULL
    BEGIN
        EXEC sp_rename
            N'dbo.SonicContainer.CertificateCheckCurl',
            N'CertificateCheckUrl',
            N'COLUMN';
    END
    ELSE IF COL_LENGTH(N'dbo.SonicContainer', N'ZertifikatCheckCurl') IS NOT NULL
    BEGIN
        EXEC sp_rename
            N'dbo.SonicContainer.ZertifikatCheckCurl',
            N'CertificateCheckUrl',
            N'COLUMN';
    END
    ELSE
    BEGIN
        ALTER TABLE [dbo].[SonicContainer]
        ADD [CertificateCheckUrl] [nvarchar](500) NULL;
    END
END;
GO