[ https://issues.apache.org/jira/browse/CLOUDSTACK-1874?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13620201#comment-13620201 ]
Chip Childers commented on CLOUDSTACK-1874: ------------------------------------------- Is this actually critical? It seems like it's Minor at best. > AWS Regions - Account table in cloud_usage DB has region_id. > ------------------------------------------------------------ > > Key: CLOUDSTACK-1874 > URL: https://issues.apache.org/jira/browse/CLOUDSTACK-1874 > Project: CloudStack > Issue Type: Bug > Security Level: Public(Anyone can view this level - this is the > default.) > Components: Management Server > Affects Versions: 4.1.0 > Environment: Build from 4.1 > Reporter: Sangeetha Hariharan > Assignee: Kishan Kavala > Priority: Critical > Fix For: 4.1.0 > > > Account table in cloud_usage DB has region_id. > There should be no region_id in Account table since there is no notion of an > account being owned by a region and this notion has been already removed from > the cloud DB. > mysql> desc account; > +-----------------+---------------------+------+-----+---------+-------+ > | Field | Type | Null | Key | Default | Extra | > +-----------------+---------------------+------+-----+---------+-------+ > | id | bigint(20) unsigned | NO | PRI | NULL | | > | account_name | varchar(100) | YES | | NULL | | > | uuid | varchar(40) | YES | UNI | NULL | | > | type | int(1) unsigned | NO | | NULL | | > | domain_id | bigint(20) unsigned | YES | | NULL | | > | state | varchar(10) | NO | | enabled | | > | removed | datetime | YES | MUL | NULL | | > | cleanup_needed | tinyint(1) | NO | | 0 | | > | network_domain | varchar(100) | YES | | NULL | | > | default_zone_id | bigint(20) unsigned | YES | | NULL | | > | region_id | int(10) unsigned | NO | | 1 | | > +-----------------+---------------------+------+-----+---------+-------+ > 11 rows in set (0.00 sec) -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators For more information on JIRA, see: http://www.atlassian.com/software/jira