[jira] [Created] (CLOUDSTACK-7081) 3.x - 4.5 upgrade: some inconsistencies in key names between fresh and upgraded dbs

["Alena Prokharchyk (JIRA)" <ji...@apache.org>]

Alena Prokharchyk created CLOUDSTACK-7081:
---------------------------------------------

             Summary: 3.x - 4.5 upgrade: some inconsistencies in key names between fresh and upgraded dbs
                 Key: CLOUDSTACK-7081
                 URL: https://issues.apache.org/jira/browse/CLOUDSTACK-7081
             Project: CloudStack
          Issue Type: Bug
      Security Level: Public (Anyone can view this level - this is the default.)
    Affects Versions: 4.5.0
            Reporter: Alena Prokharchyk
            Assignee: Alena Prokharchyk
             Fix For: 4.5.0


Steps to reproduce:
=====================
1) Install any 3.0.x version of CS
2) Upgrade to 4.5. 

Found following inconsistencies:

* Fresh db, cloud.volumes table is missing description for iso_id field:

 `iso_id` bigint(20) unsigned DEFAULT NULL,

Upgraded setup has the description

* Fresh db, cloud.storage pool table has 2 duplicated keys (id and id_2):

 UNIQUE KEY `id` (`id`),
  UNIQUE KEY `id_2` (`id`),

Upgraded setup has just id



--
This message was sent by Atlassian JIRA
(v6.2#6252)