Updated Branches: refs/heads/4.2 1e64df854 -> 743d35cae
CLOUDSTACK-3612: DB changes for template virtual size usage Project: http://git-wip-us.apache.org/repos/asf/cloudstack/repo Commit: http://git-wip-us.apache.org/repos/asf/cloudstack/commit/743d35ca Tree: http://git-wip-us.apache.org/repos/asf/cloudstack/tree/743d35ca Diff: http://git-wip-us.apache.org/repos/asf/cloudstack/diff/743d35ca Branch: refs/heads/4.2 Commit: 743d35cae4985a8d898da06e5768ae282b32adb2 Parents: d89115b Author: Saksham Srivastava <[email protected]> Authored: Wed Jul 24 18:06:22 2013 +0530 Committer: Kishan Kavala <[email protected]> Committed: Wed Jul 24 18:20:37 2013 +0530 ---------------------------------------------------------------------- setup/db/db/schema-410to420.sql | 5 +++++ 1 file changed, 5 insertions(+) ---------------------------------------------------------------------- http://git-wip-us.apache.org/repos/asf/cloudstack/blob/743d35ca/setup/db/db/schema-410to420.sql ---------------------------------------------------------------------- diff --git a/setup/db/db/schema-410to420.sql b/setup/db/db/schema-410to420.sql index f9417a0..8409c47 100644 --- a/setup/db/db/schema-410to420.sql +++ b/setup/db/db/schema-410to420.sql @@ -2151,3 +2151,8 @@ INSERT IGNORE INTO `cloud`.`configuration` VALUES ('Advanced', 'DEFAULT', 'manag INSERT IGNORE INTO `cloud`.`configuration` VALUES ('Advanced', 'DEFAULT', 'management-server', 'vmsnapshot.max', '10', 'Maximum vm snapshots for a VM'); INSERT IGNORE INTO `cloud`.`configuration` VALUES ('Advanced', 'DEFAULT', 'management-server', 'vmsnapshot.create.wait', '1800','In second, timeout for create vm snapshot'); + +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;
