Sangeetha Hariharan created CLOUDSTACK-1874:
-----------------------------------------------
Summary: 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
