1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
| 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
|
|
