| 1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071727374 |
- -- TB_AIP_SERVER --
- SET IDENTITY_INSERT [TB_AIP_SERVER] ON
- INSERT INTO [TB_AIP_SERVER]
- (AipServerId, [AipServerName], [IpAddr], [Port])
- VALUES
- (0, 'AIP Gateway Server', '192.168.20.99', 5000)
- SET IDENTITY_INSERT [TB_AIP_SERVER] OFF
- GO
- -- TB_AIP_SERVER --
- SET IDENTITY_INSERT [TB_AIP_CONFIG] ON
- INSERT INTO [TB_AIP_CONFIG]
- (Id, [AipServerId], [ConfigKey], [ConfigValue])
- VALUES
- ( 1, 0, 'AppName', 'AIP Gateway RESTFull Service'),
- ( 2, 0, 'AppVersion', '1.0.0.0'),
- ( 3, 0, 'ClientId', '0e225915-3be3-419c-aa04-284d7de5e16b'),
- ( 4, 0, 'TenantId', '2e58414a-c6ae-43ff-aaf5-45ab8b78a404'),
- ( 5, 0, 'MipData', 'App_Data\\mip_data'),
- ( 6, 0, 'LoginType', 'authLoginCert'),
- ( 7, 0, 'Domain', 'AIP.Gateway'),
- ( 8, 0, 'EMail', 'SeungHo@kangfamily.site'),
- ( 9, 0, 'SecretValue', 'CvW8Q~0iANtLN1Y2EXR_nVyYb_tQTDwjW-Z7Ndg3'),
- (10, 0, 'CertThumbPrint', 'C:\\DEV\\SOLUTION\\IIS\\OpenSSL\\mip\\mip_gateway.pfx'),
- (11, 0, 'SourceFileDir', 'C:\\Data\\Source\\'),
- (12, 0, 'TargetFileDir', 'C:\\Data\\Target\\'),
- (13, 0, 'SetLableId', '1098bdb0-f2bc-43d3-b9c7-e610431fc1a4'),
- (14, 0, 'DeleteLabelId', '878173ae-cc36-4881-af57-604af868314c'),
- (15, 0, 'SetTemplateId', '3c597cfe-ec81-4c18-add7-3867f2d3b4d4'),
- (16, 0, 'DeleteTemplateId', '0166b75f-6a93-47f3-8fd3-e1e7c59141ab'),
- (17, 0, 'SupportedFileExt', '.doc;.docx;.docm;.dot;.dotm;.dotx;.xls;.xlt;.xlsx;.xltx;.xltm;.xlsm;.xlsb;.ppt;.pps;.pot;.pptx;.ppsx;.pptm;.ppsm;.potx;.potm;.pdf;.txt;.xml;.jpg;.jpeg;.png;.tif;.tiff;.bmp;.gif;.jpe;.jfif;.jt;'),
- (18, 0, 'ProtectedFileExt', '.txt-.ptxt;.xml-.pxml;.jpg-.pjpg;.jpeg-.pjpeg;.png-.ppng;.tif-.ptif;.tiff-.ptiff;.bmp-.pbmp;.gif-.pgif;.jpe-.pjpe;.jfif-.pjfif;.jt-.pjt;')
- SET IDENTITY_INSERT [TB_AIP_CONFIG] OFF
- GO
- INSERT INTO [TB_AIP_API_INFO]
- ([ApiId], [AipEndPoint], [ApiName], [ApiDesc])
- VALUES
- ( 1, '/v1/aip-api/db/reload', 'ReloadDatabase', '데이터베이스 재로딩'),
- ( 3, '/v1/aip-api/db/linked-systems', 'GetLinkedSystems', '연계 시스템 정보 조회'),
- ( 4, '/v1/aip-api/db/linked-servers', 'GetLinkedServers', '연계 서버 정보 조회'),
- ( 5, '/v1/aip-api/db/linked-api-keys', 'GetApiKeys', 'API Key 조회'),
- ( 6, '/v1/aip-api/db/linked-decrypt-keys', 'GetDecryptKeys', 'Decrypt Key 조회'),
- (10, '/v1/aip-api/aip/download', 'DownloadAIP', 'AIP 정보 다운로드'),
- (11, '/v1/aip-api/aip/labels', 'GetLabels', 'AIP Label 정보 조회'),
- (12, '/v1/aip-api/aip/policies', 'GetPolicies', 'AIP Policy 정보 조회'),
- (13, '/v1/aip-api/aip/protections', 'GetProtections', 'AIP Protection 정보 조회'),
- (21, '/v1/aip-api/file/info', 'GetFileInfo', 'File AIP 정보 조회'),
- (22, '/v1/aip-api/file/set-label', 'SetLabel', 'File Label 설정'),
- (23, '/v1/aip-api/file/delete-label', 'DeleteLabel', 'File Label 해제'),
- (24, '/v1/aip-api/file/set-protection', 'SetProtection', 'File Protection 설정'),
- (25, '/v1/aip-api/file/delete-protection', 'DeleteProtection', 'File Protection 해제'),
- (26, '/v1/aip-api/file/set-label-protection', 'SetLabelOrProtection', 'File Lable Or Protection 설정'),
- (27, '/v1/aip-api/file/delete-label-protection', 'DeleteLableOrProtection', 'File Label Or Protection 해제'),
- (61, '/v1/aip-api/stream/info', 'GetStreamInfo', 'Stream AIP 정보 조회'),
- (62, '/v1/aip-api/stream/set-label', 'SetStreamLabel', 'Stream Label 설정'),
- (63, '/v1/aip-api/stream/delete-label', 'DeleteStream Label', 'Stream Label 해제'),
- (64, '/v1/aip-api/stream/set-protection', 'SetStream Protection', 'Stream Protection 설정'),
- (65, '/v1/aip-api/stream/delete-protection', 'DeleteStream Protection', 'Stream Protection 해제'),
- (66, '/v1/aip-api/stream/set-label-protection', 'SetLabelOrProtection', 'Stream Lable Or Protection 설정'),
- (67, '/v1/aip-api/stream/delete-label-protection', 'DeleteLableOrProtection', 'Stream Label Or Protection 해제'),
- (99, '/v1/aip-api/dummy', 'Dummy', 'Dummy')
- GO
|
