Created
January 14, 2015 13:22
-
-
Save eriweb/683f78fb9a91b2b2f71e to your computer and use it in GitHub Desktop.
acs45 create-schema-premium patch
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
diff --git a/setup/db/create-schema-premium.sql b/setup/db/create-schema-premium.sql | |
index 2f86c0b..a8feff4 100644 | |
--- a/setup/db/create-schema-premium.sql | |
+++ b/setup/db/create-schema-premium.sql | |
@@ -296,7 +296,7 @@ CREATE TABLE `cloud`.`netapp_volume` ( | |
`password` varchar(200) COMMENT 'password', | |
`round_robin_marker` int COMMENT 'This marks the volume to be picked up for lun creation, RR fashion', | |
PRIMARY KEY (`id`), | |
- CONSTRAINT `fk_netapp_volume__pool_id` FOREIGN KEY `fk_netapp_volume__pool_id` (`pool_id`) REFERENCES `netapp_pool` (`id`) ON DELETE CASCADE, | |
+ CONSTRAINT `fk_netapp_volume__pool_id` FOREIGN KEY `fk_netapp_volume__pool_id` (`pool_id`) REFERENCES `cloud`.`netapp_pool` (`id`) ON DELETE CASCADE, | |
INDEX `i_netapp_volume__pool_id`(`pool_id`) | |
) ENGINE=InnoDB DEFAULT CHARSET=utf8; | |
@@ -315,7 +315,7 @@ CREATE TABLE `cloud`.`netapp_lun` ( | |
`size` bigint NOT NULL COMMENT 'lun size', | |
`volume_id` bigint unsigned NOT NULL COMMENT 'parent volume id', | |
PRIMARY KEY (`id`), | |
- CONSTRAINT `fk_netapp_lun__volume_id` FOREIGN KEY `fk_netapp_lun__volume_id` (`volume_id`) REFERENCES `netapp_volume` (`id`) ON DELETE CASCADE, | |
+ CONSTRAINT `fk_netapp_lun__volume_id` FOREIGN KEY `fk_netapp_lun__volume_id` (`volume_id`) REFERENCES `cloud`.`netapp_volume` (`id`) ON DELETE CASCADE, | |
INDEX `i_netapp_lun__volume_id`(`volume_id`), | |
INDEX `i_netapp_lun__lun_name`(`lun_name`) | |
) ENGINE=InnoDB DEFAULT CHARSET=utf8; |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment