36 lines
1.1 KiB
Transact-SQL
36 lines
1.1 KiB
Transact-SQL
|
|
|
|
--任务管理
|
|
IF NOT EXISTS (SELECT 1 FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'InterFaceSet' AND COLUMN_NAME = 'IsSingleRequest')
|
|
BEGIN
|
|
ALTER TABLE InterFaceSet ADD IsSingleRequest bit;
|
|
ALTER TABLE InterFaceSet ADD RequestJsonBody nvarchar(2000);
|
|
END
|
|
GO
|
|
--任务管理
|
|
IF NOT EXISTS (SELECT 1 FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'InterFaceTask' AND COLUMN_NAME = 'Frequency')
|
|
BEGIN
|
|
ALTER TABLE InterFaceTask ADD Frequency nvarchar(50);
|
|
END
|
|
ELSE
|
|
BEGIN
|
|
ALTER TABLE InterFaceTask ALTER COLUMN Frequency nvarchar(50);
|
|
END
|
|
GO
|
|
|
|
exec sp_addextendedproperty 'MS_Description', N'是否单一请求', 'SCHEMA', 'dbo', 'TABLE', 'InterFaceSet', 'COLUMN',
|
|
'IsSingleRequest'
|
|
|
|
go
|
|
exec sp_addextendedproperty 'MS_Description', N'请求报文体', 'SCHEMA', 'dbo', 'TABLE', 'InterFaceSet', 'COLUMN',
|
|
'RequestJsonBody'
|
|
|
|
go
|
|
exec sp_addextendedproperty 'MS_Description', N'频率(表达式)', 'SCHEMA', 'dbo', 'TABLE', 'InterFaceTask', 'COLUMN',
|
|
'Frequency'
|
|
go
|
|
|
|
ALTER TABLE InterFaceLog ALTER COLUMN InterFaceName nvarchar(500);
|
|
ALTER TABLE InterFaceLog ALTER COLUMN InterFaceMehtod nvarchar(200);
|
|
GO
|