You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@cloudstack.apache.org by ke...@apache.org on 2012/05/28 00:35:42 UTC
[49/50] [abbrv] git commit: CS-15070: remove invalid refs from
storage_pool_host_ref
CS-15070: remove invalid refs from storage_pool_host_ref
Project: http://git-wip-us.apache.org/repos/asf/incubator-cloudstack/repo
Commit: http://git-wip-us.apache.org/repos/asf/incubator-cloudstack/commit/44b88e09
Tree: http://git-wip-us.apache.org/repos/asf/incubator-cloudstack/tree/44b88e09
Diff: http://git-wip-us.apache.org/repos/asf/incubator-cloudstack/diff/44b88e09
Branch: refs/heads/3.0.x
Commit: 44b88e093f225ef1eb347bfd0209a1455f7e172a
Parents: 63d512b
Author: Alena Prokharchyk <al...@citrix.com>
Authored: Wed May 23 14:49:28 2012 -0700
Committer: Alena Prokharchyk <al...@citrix.com>
Committed: Wed May 23 14:50:03 2012 -0700
----------------------------------------------------------------------
setup/db/db/schema-302to303.sql | 2 ++
1 files changed, 2 insertions(+), 0 deletions(-)
----------------------------------------------------------------------
http://git-wip-us.apache.org/repos/asf/incubator-cloudstack/blob/44b88e09/setup/db/db/schema-302to303.sql
----------------------------------------------------------------------
diff --git a/setup/db/db/schema-302to303.sql b/setup/db/db/schema-302to303.sql
index 4ae6aac..998d1c9 100755
--- a/setup/db/db/schema-302to303.sql
+++ b/setup/db/db/schema-302to303.sql
@@ -171,3 +171,5 @@ CREATE TABLE `cloud`.`port_profile` (
`port_binding` varchar(20),
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
+
+DELETE FROM `cloud`.`storage_pool_host_ref` WHERE pool_id IN (SELECT id FROM storage_pool WHERE removed IS NOT NULL);