Repository: cloudstack Updated Branches: refs/heads/4.5 0f819f158 -> 79cdcf8d7
CLOUDSTACK-8265: added foreign key constriant on guest os id Project: http://git-wip-us.apache.org/repos/asf/cloudstack/repo Commit: http://git-wip-us.apache.org/repos/asf/cloudstack/commit/79cdcf8d Tree: http://git-wip-us.apache.org/repos/asf/cloudstack/tree/79cdcf8d Diff: http://git-wip-us.apache.org/repos/asf/cloudstack/diff/79cdcf8d Branch: refs/heads/4.5 Commit: 79cdcf8d7d9970654689b6ccfbb1af182ea02a49 Parents: 0f819f1 Author: Abhinandan Prateek <abhinandan.prat...@shapeblue.com> Authored: Tue Mar 3 01:45:48 2015 -0500 Committer: Abhinandan Prateek <abhinandan.prat...@shapeblue.com> Committed: Tue Mar 3 01:45:48 2015 -0500 ---------------------------------------------------------------------- setup/db/db/schema-442to450.sql | 1 + 1 file changed, 1 insertion(+) ---------------------------------------------------------------------- http://git-wip-us.apache.org/repos/asf/cloudstack/blob/79cdcf8d/setup/db/db/schema-442to450.sql ---------------------------------------------------------------------- diff --git a/setup/db/db/schema-442to450.sql b/setup/db/db/schema-442to450.sql index a1d9b0e..4a8f250 100644 --- a/setup/db/db/schema-442to450.sql +++ b/setup/db/db/schema-442to450.sql @@ -1024,3 +1024,4 @@ INSERT IGNORE INTO `cloud`.`configuration` (`category`, `instance`, `component`, UPDATE `cloud`.`configuration` SET description='Uuid of the service offering used by secondary storage; if NULL - system offering will be used' where name='secstorage.service.offering'; +ALTER TABLE `cloud`.`guest_os_hypervisor` ADD FOREIGN KEY (`guest_os_id`) REFERENCES `cloud`.`guest_os`(`id`);