You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@cloudstack.apache.org by "Chip Childers (JIRA)" <ji...@apache.org> on 2013/04/02 21:57:15 UTC
[jira] [Commented] (CLOUDSTACK-1874) AWS Regions - Account table in
cloud_usage DB has region_id.
[ 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