IF COL_LENGTH('dbo.asr_wrk_detl', 'pic') IS NULL
BEGIN
    ALTER TABLE [dbo].[asr_wrk_detl]
        ADD [pic] NVARCHAR(MAX) NULL;
END
GO

IF COL_LENGTH('dbo.asr_wrk_detl_log', 'pic') IS NULL
BEGIN
    ALTER TABLE [dbo].[asr_wrk_detl_log]
        ADD [pic] NVARCHAR(MAX) NULL;
END
GO

IF COL_LENGTH('dbo.asr_loc_detl', 'pic') IS NULL
BEGIN
    ALTER TABLE [dbo].[asr_loc_detl]
        ADD [pic] NVARCHAR(MAX) NULL;
END
GO

IF NOT EXISTS (SELECT 1 FROM sys_config WHERE code = N'InboundCameraCapture')
BEGIN
    INSERT INTO sys_config (name, code, value, type, status)
    VALUES (
        N'入库站点抓拍配置',
        N'InboundCameraCapture',
        N'{"enabled":true,"captureUrl":"http://192.168.10.11:8000/startPic","imageUrlPrefix":"http://192.168.10.11:8000/image/","stations":{"101":[{"ip":"10.10.16.13","port":554,"user":"admin","password":"a327482030"},{"ip":"10.10.16.14","port":554,"user":"admin","password":"a327482030"}]}}',
        2,
        1
    );
END
GO