[
https://issues.apache.org/jira/browse/CLOUDSTACK-1874?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13623738#comment-13623738
]
ASF subversion and git services commented on CLOUDSTACK-1874:
-------------------------------------------------------------
Commit 05ca08af1166d40a3e0708004789e30c3a11659e in branch refs/heads/4.1 from
[~kishan]
[ https://git-wip-us.apache.org/repos/asf?p=cloudstack.git;h=05ca08a ]
CLOUDSTACK-1874: Removed region_id column from cloud_usage db account table
Conflicts:
setup/db/db/schema-40to410.sql
> 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, 4.2.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
