-- 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

