cloudstack-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "ASF subversion and git services (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (CLOUDSTACK-1874) AWS Regions - Account table in cloud_usage DB has region_id.
Date Fri, 05 Apr 2013 08:28:15 GMT

    [ https://issues.apache.org/jira/browse/CLOUDSTACK-1874?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13623454#comment-13623454
] 

ASF subversion and git services commented on CLOUDSTACK-1874:
-------------------------------------------------------------

Commit 7ea0d7bce4b542bd8caada727416ec73e60f4977 in branch refs/heads/master from [~kishan]
[ https://git-wip-us.apache.org/repos/asf?p=cloudstack.git;h=7ea0d7b ]

CLOUDSTACK-1874: Removed region_id column from cloud_usage db account table

                
> 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

Mime
View raw message