AipGateway/Database/AIP 테이블 입력.SQL

-- 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,             'SetLabelId',				'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;'),
--(21,		1,             'AppName',						'AIP Gateway RESTFull Service'),
--(22,		1,             'AppVersion',				'1.0.0.0'),
(23,		1,             'ClientId',					'0e225915-3be3-419c-aa04-284d7de5e16b'),
(24,		1,             'TenantId',					'2e58414a-c6ae-43ff-aaf5-45ab8b78a404'),
(26,		1,             'LoginType',					'authLoginCert'),
(27,		1,             'Domain',						'AIP.Gateway'),
(28,		1,             'EMail',							'SeungHo@kangfamily.site'),
(29,		1,             'SecretValue',				'CvW8Q~0iANtLN1Y2EXR_nVyYb_tQTDwjW-Z7Ndg3'),
(30,		1,             'CertThumbPrint',		'C:\\Data\\SSL\\mip\\mip_gateway.pfx')

SET IDENTITY_INSERT [TB_AIP_CONFIG] OFF
GO


INSERT INTO [TB_AIP_API_INFO] 
([ApiId],	[AipEndPoint], 																	[ApiName],									[ApiDesc])
VALUES 
( 1,			'/api/v1/db/reload',											'ReloadDatabase',						'데이터베이스 재로딩'),
( 2,			'/api/v1/db/linked-systems',							'GetLinkedSystems',					'연계 시스템 정보 조회'),
( 3,			'/api/v1/db/linked-servers',							'GetLinkedServers',					'연계 서버 정보 조회'),
( 4,			'/api/v1/db/linked-api-keys',							'GetApiKeys',								'API Key 조회'),
( 5,			'/api/v1/db/linked-decrypt-keys',					'GetDecryptKeys',						'Decrypt Key 조회'),

(10,			'/api/v1/aip/download',										'DownloadAIP',							'AIP 정보 다운로드'),
(11,			'/api/v1/aip/labels',             				'GetLabels',								'AIP Label 정보 조회'),
(12,			'/api/v1/aip/policies',             			'GetPolicies',							'AIP Policy 정보 조회'),
(13,			'/api/v1/aip/protections',          			'GetProtections',						'AIP Protection 정보 조회'),

(21,			'/api/v1/file/info',            					'GetFileInfo',							'File AIP 정보 조회'),
(22,			'/api/v1/file/set-label',            			'SetLabel',									'File Label 설정'),
(23,			'/api/v1/file/delete-label',         			'DeleteLabel',							'File Label 해제'),
(24,			'/api/v1/file/set-protection',     				'SetProtection',						'File Protection 설정'),
(25,			'/api/v1/file/delete-protection',    			'DeleteProtection',					'File Protection 해제'),
(26,			'/api/v1/file/set-label-protection',    	'SetLabelOrProtection',			'File Lable Or Protection 설정'),
(27,			'/api/v1/file/delete-label-protection',		'DeleteLableOrProtection',	'File Label Or Protection 해제'),
(28,			'/api/v1/file/encrypt',            				'EncryptFile',							'File Encrypt'),
(29,			'/api/v1/file/decrypt',            				'DecryptFile',							'File Decrypt'),
(30,			'/api/v1/file/set-labels',           			'SetLabels',								'File Label 설정'),
(31,			'/api/v1/file/delete-labels',        			'DeleteLabels',		 					'File Label 해제'),

(41,			'/api/v1/stream/info',          					'GetStreamInfo',						'Stream AIP 정보 조회'),
(42,			'/api/v1/stream/set-label',         			'SetStreamLabel',						'Stream Label 설정'),
(43,			'/api/v1/stream/delete-label',      			'DeleteStreamLabel',				'Stream Label 해제'),
(44,			'/api/v1/stream/set-protection',    			'SetStreamProtection',			'Stream Protection 설정'),
(45,			'/api/v1/stream/delete-protection',				'DeleteStreamProtection',		'Stream Protection 해제'),
(46,			'/api/v1/stream/set-label-protection',  	'SetLabelOrProtection',			'Stream Lable Or Protection 설정'),
(47,			'/api/v1/stream/delete-label-protection', 'DeleteLableOrProtection',	'Stream Label Or Protection 해제'),
(48,			'/api/v1/stream/encrypt',            			'EncryptStream',						'Stream Encrypt'),
(49,			'/api/v1/stream/decrypt',            			'DecryptStream',						'Stream Decrypt'),
(50,			'/api/v1/stream/set-labels',         			'SetStreamLabels',					'Stream Label 설정'),
(51,			'/api/v1/stream/delete-labels',      			'DeleteStreamLabels',				'Stream Label 해제'),

(99,			'/api/v1/dummy',            		'Dummy',									'Dummy');

GO