Repository: cloudstack Updated Branches: refs/heads/master ef99f01e5 -> 58c5850be
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/58c5850b Tree: http://git-wip-us.apache.org/repos/asf/cloudstack/tree/58c5850b Diff: http://git-wip-us.apache.org/repos/asf/cloudstack/diff/58c5850b Branch: refs/heads/master Commit: 58c5850beed8037c608e2b902004be6375ed0dae Parents: ef99f01 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 02:25:09 2015 -0500 ---------------------------------------------------------------------- setup/db/db/schema-442to450.sql | 1 + 1 file changed, 1 insertion(+) ---------------------------------------------------------------------- http://git-wip-us.apache.org/repos/asf/cloudstack/blob/58c5850b/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`);