[jira] [Updated] (AMBARI-15094) Patch Upgrade UpgradeCatalog Changes

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

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

Jonathan Hurley updated AMBARI-15094:
-------------------------------------
    Attachment: AMBARI-15094.patch

> Patch Upgrade UpgradeCatalog Changes
> ------------------------------------
>
>                 Key: AMBARI-15094
>                 URL: https://issues.apache.org/jira/browse/AMBARI-15094
>             Project: Ambari
>          Issue Type: Task
>          Components: ambari-upgrade
>    Affects Versions: 2.4.0
>            Reporter: Jonathan Hurley
>            Assignee: Jonathan Hurley
>            Priority: Critical
>             Fix For: 2.4.0
>
>         Attachments: AMBARI-15094.patch
>
>
> This JIRA will be used to keep track of the changes required for the UpgradeCatalog that will be used for PU.
> +Changed tables+
> {{repo_version}}
> * Add {{type}} column, default 'STANDARD'
> * Add {{version_url}} varchar(1024)
> * Add {{version_xml}} mediumtext/text
> * Add {{version_xsd}} varchar(512)
> * Add {{parent_id}} bigint, nullable
> {{servicecomponentdesiredstate}}
> * Add PK {{id}} column
> * Remove existing PK, create {{UNIQUE}} constraint out of same columns
> * Create {{INDEX}} on old PK columns
> {{hostcomponentdesiredstate}}
> * Reorder {{hstcmpnntdesiredstatecmpnntnme}} {{FOREIGN KEY}}
> ** {{(component_name, service_name, cluster_id)}}
> {{hostcomponentstate}}
> * Reorder {{hstcomponentstatecomponentname}} {{FOREIGN KEY}}
> ** {{(component_name, service_name, cluster_id)}}
> {{servicecomponent_history}}
> * Creation of new table
> * Addition of new sequence to track PK ID



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)