[jira] [Updated] (AMBARI-21169) Service and Patch Upgrade Catalog Changes

["Jonathan Hurley (JIRA)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/AMBARI-21169?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Jonathan Hurley updated AMBARI-21169:
-------------------------------------
    Attachment: AMBARI-21530.patch

> Service and Patch Upgrade Catalog Changes
> -----------------------------------------
>
>                 Key: AMBARI-21169
>                 URL: https://issues.apache.org/jira/browse/AMBARI-21169
>             Project: Ambari
>          Issue Type: Task
>          Components: ambari-upgrade
>    Affects Versions: 3.0.0
>            Reporter: Jonathan Hurley
>            Assignee: Jonathan Hurley
>            Priority: Critical
>             Fix For: 3.0.0
>
>         Attachments: AMBARI-21530.patch
>
>
> 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)