GizzlerandCursor
0a449727ad
Auto-migrate SonicContainer schema on startup, rename legacy typo columns, and use fallback SQL when the column is not yet present. Co-authored-by: Cursor <cursoragent@cursor.com>
50 lines
1.4 KiB
Transact-SQL
50 lines
1.4 KiB
Transact-SQL
/*
|
|
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
|