Jonathan Hurley created AMBARI-15094:
----------------------------------------
Summary: 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
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)