[jira] [Commented] (AMBARI-21683) Service and Patch Upgrade Catalog Changes for 3.0

["Dmitry Lysnichenko (JIRA)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/AMBARI-21683?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16118738#comment-16118738 ] 

Dmitry Lysnichenko commented on AMBARI-21683:
---------------------------------------------

cloned from original AMBARI-21683 since it targets 3.0

> Service and Patch Upgrade Catalog Changes for 3.0
> -------------------------------------------------
>
>                 Key: AMBARI-21683
>                 URL: https://issues.apache.org/jira/browse/AMBARI-21683
>             Project: Ambari
>          Issue Type: Task
>          Components: ambari-upgrade
>    Affects Versions: 3.0.0
>            Reporter: Dmitry Lysnichenko
>            Assignee: Jonathan Hurley
>            Priority: Critical
>             Fix For: 3.0.0
>
>
> Implement the following upgrade catalog changes related to service/patch upgrades:
> h5. {{servicecomponentdesiredstate}}
> - Remove:  desired_stack_id BIGINT NOT NULL
> - Remove: desired_version VARCHAR(255) NOT NULL DEFAULT 'UNKNOWN'
> - Remove: FK on desired_stack_id (FK_scds_desired_stack_id)
> - Add: desired_repo_version_id BIGINT NOT NULL
> - Add: FK to repo_version_id (FK_scds_desired_repo_id)
> h5. {{hostcomponentdesiredstate}}
> - Remove: desired_stack_id BIGINT NOT NULL
> - Remove: FK on desired_stack_id (FK_hcds_desired_stack_id)
> h5. {{hostcomponentstate}}
> - Remove: current_stack_id BIGINT NOT NULL
> - Remove: FK on desired_stack_id (FK_hcs_current_stack_id)
> h5. {{servicedesiredstate}}
> - Remove: desired_stack_id BIGINT NOT NULL
> - Add: desired_repo_version_id BIGINT NOT NULL
> - Add: FK  to repo_version_id (FK_repo_version_id)
> h5. {{host_version}}
> - Change the {{UNIQUE}} constraint to allow for multiple {{CURRENT}} repositories per host. Restriction should also include the {{repo_version_id}} for uniqueness now.
> h5. {{cluster_version}}
> - This table was removed.
> h5. {{servicecomponent_version}}
> - Create this table and populate with data
> h5. {{upgrade}}
> - Add orchestration VARCHAR(255) NOT NULL DEFAULT 'STANDARD'



--
This message was sent by Atlassian JIRA
(v6.4.14#64029)