-- ~~~~~~~~~~~~~~~~~~~~~~~~~~~~  Update existing Server  ~~~~~~~~~~~~~~~~~~~~~~~~~~~~
-- ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
--      <Hostname>       =  (Eg: 'VITALDC401')
--      <IP>             =  (Eg: '100.64.28.11')
--      <Description>    =  (Eg: 'P4 IIS Server' / 'NONP4 DataBase Server' / 'Beta and Stage Database Server')
--      <Server_Type>    =  'Armor IIS Server' / 'Armor Database Server' / 'Azure IIS Server' / 'Azure Database Server' / 'Integration Server' / 'Storage Server' / 'AD Server' / 'CACHE Server' / 'Load Balancer'
-- ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
UPDATE SMDServers 
SET 
    ip = '<New_IP>' 
    --, description = '<New_Description>' 
    --, type = '<New_Server_Type>' 
WHERE hostname = '<Hostname>'; 
GO


-- ~~~~~~~~~~~~~~~~~~~~~~~~~~~~  Update existing Deployment  ~~~~~~~~~~~~~~~~~~~~~~~~~~~~
-- ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
--      <Environment>    =  'Live' / 'Stage' / 'Beta'
-- ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
UPDATE SMDDeployments 
SET 
    description = '<New_Description>' 
    --, db_name = '<New_Database_Name>' 
    --, db_username = '<New_Database_Username>' 
    --, db_password = '<New_Database_Password>' 
    --, product = '<New_Product>' 
    --, version = '<New_Version>' 
    --, static_application = '<New_Static_Application>' 
WHERE deployment_name = '<Deployment_Name>' 
AND type = '<Environment>'; 
GO


-- ~~~~~~~~~~~~~~~~~~~~~~~~~~~~  Update existing Application  ~~~~~~~~~~~~~~~~~~~~~~~~~~~~
-- ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
--      <Application_Path>  =  Folder Path (Eg: E:/VitalAxis/Websites-IIS/VALive-MYLIS)
--      <Application_Type>  =  'Web-Site' / 'Windows-Services' / 'Integration-Services' / 'Elasticsearch-service'
-- ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
UPDATE SMDApplications 
SET 
    target_path = '<New_Application_Path>' 
    --, type = '<New_Application_Type>' 
    --, source_path = '<New_Source_Path>' 
WHERE application_name = '<Application_Name>'; 
GO


-- ~~~~~~~~~~~~~~~~~~~~~~~~~~~~  Update existing Application-Server Mapping  ~~~~~~~~~~~~~~~~~~~~~~~~~~~~
-- ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
--      <Application_Name>            =  (Eg: 'VitalAxis-LIS')
--      <Primary_Server_Hostname>     =  (Eg: 'VITALWEB403')
--      <Secondary_Server_Hostname>   =  (Eg: 'VITALWEB404')
--      <Server_Type>                 =  'IIS' / 'Database'
-- ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
UPDATE SMDApplicationServerMapping 
SET 
    primary_server_id = (SELECT server_id FROM SMDServers WHERE hostname = '<Primary_Server_Hostname>') 
    --, secondary_server_id = (SELECT server_id FROM SMDServers WHERE hostname = '<Secondary_Server_Hostname>') 
WHERE application_id = (SELECT application_id FROM SMDApplications WHERE application_name = '<Application_Name>') 
AND EXISTS (SELECT primary_server_id FROM SMDServers s WHERE s.server_id = SMDApplicationServerMapping.primary_server_id 
AND s.type LIKE '%' + '<Server_Type>' + '%'); 
GO


-- ~~~~~~~~~~~~~~~~~~~~~~~~~~~~  Update existing Azure Application  ~~~~~~~~~~~~~~~~~~~~~~~~~~~~
-- ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
--      <Environment>  =  'Live' / 'Stage' / 'QC'
--      <Team>  =  'VitalHub' / 'VitalEdge' / 'VitalOrders'
--      <is_active>  =  1 / 0
-- ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
UPDATE SMDAzureApplications 
SET 
    application_name = '<New_Application_Name>' 
    , application_type = '<New_Application_Type>' 
    , subscription = '<New_Subscription>' 
    --, resource_group = '<New_Resource_Group>' 
    --, location = '<New_Location>' 
    --, source_path = '<New_Source_Path>' 
    --, environment = '<New_Environment>' 
    --, team = '<New_Team>' 
    --, email = '<New_Email>' 
    --, is_active = 1 
WHERE application_id = '<Application_Id>' 
GO