CLOUDSTACK-3612: DB changes for template virtual size usage
Conflicts:
setup/db/db/schema-410to420.sql
Project: http://git-wip-us.apache.org/repos/asf/cloudstack/repo
Commit: http://git-wip-us.apache.org/repos/asf/cloudstack/commit/2b9d9cf0
Tree: http://git-wip-us.apache.org/repos/asf/cloudstack/tree/2b9d9cf0
Diff: http://git-wip-us.apache.org/repos/asf/cloudstack/diff/2b9d9cf0
Branch: refs/heads/master
Commit: 2b9d9cf0360b22a703f27600292f22711f51c62f
Parents: 135a2e6
Author: Saksham Srivastava <[email protected]>
Authored: Wed Jul 24 18:06:22 2013 +0530
Committer: Kishan Kavala <[email protected]>
Committed: Wed Jul 24 18:19:39 2013 +0530
----------------------------------------------------------------------
setup/db/db/schema-410to420.sql | 5 +++++
1 file changed, 5 insertions(+)
----------------------------------------------------------------------
http://git-wip-us.apache.org/repos/asf/cloudstack/blob/2b9d9cf0/setup/db/db/schema-410to420.sql
----------------------------------------------------------------------
diff --git a/setup/db/db/schema-410to420.sql b/setup/db/db/schema-410to420.sql
index 664e9b0..7fc5ea2 100644
--- a/setup/db/db/schema-410to420.sql
+++ b/setup/db/db/schema-410to420.sql
@@ -2150,3 +2150,8 @@ ALTER TABLE `cloud`.`sync_queue` MODIFY `queue_size`
smallint(6) NOT NULL DEFAUL
ALTER TABLE `cloud`.`sync_queue` MODIFY `queue_size_limit` smallint(6) NOT
NULL DEFAULT '1' COMMENT 'max number of items the queue can process
concurrently';
INSERT IGNORE INTO `cloud`.`configuration` VALUES ('Advanced', 'DEFAULT',
'management-server', 'ucs.sync.blade.interval', '3600', 'the interval
cloudstack sync with UCS manager for available blades in case user remove
blades from chassis without notifying CloudStack');
+
+ALTER TABLE `cloud`.`usage_event` ADD COLUMN `virtual_size` bigint unsigned;
+ALTER TABLE `cloud_usage`.`usage_event` ADD COLUMN `virtual_size` bigint
unsigned;
+ALTER TABLE `cloud_usage`.`usage_storage` ADD COLUMN `virtual_size` bigint
unsigned;
+ALTER TABLE `cloud_usage`.`cloud_usage` ADD COLUMN `virtual_size` bigint
unsigned;
