incubator-cloudstack-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From ke4...@apache.org
Subject [49/50] [abbrv] git commit: CS-15070: remove invalid refs from storage_pool_host_ref
Date Sun, 27 May 2012 22:35:42 GMT
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 <alena.prokharchyk@citrix.com>
Authored: Wed May 23 14:49:28 2012 -0700
Committer: Alena Prokharchyk <alena.prokharchyk@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);


Mime
View raw message