CLOUDSTACK-7873 Fixed the user vm details length issue for higher key lengths
Project: http://git-wip-us.apache.org/repos/asf/cloudstack/repo Commit: http://git-wip-us.apache.org/repos/asf/cloudstack/commit/b6621428 Tree: http://git-wip-us.apache.org/repos/asf/cloudstack/tree/b6621428 Diff: http://git-wip-us.apache.org/repos/asf/cloudstack/diff/b6621428 Branch: refs/heads/statscollector-graphite Commit: b6621428a94866be043df30d8e94e918bfcbf4bb Parents: 97fa4a0 Author: Santhosh Edukulla <santhosh.eduku...@gmail.com> Authored: Mon Nov 10 20:05:32 2014 +0530 Committer: Santhosh Edukulla <santhosh.eduku...@gmail.com> Committed: Mon Nov 10 20:51:46 2014 +0530 ---------------------------------------------------------------------- engine/schema/src/com/cloud/vm/UserVmDetailVO.java | 2 +- setup/db/create-schema.sql | 2 +- setup/db/db/schema-441to450.sql | 4 ++++ 3 files changed, 6 insertions(+), 2 deletions(-) ---------------------------------------------------------------------- http://git-wip-us.apache.org/repos/asf/cloudstack/blob/b6621428/engine/schema/src/com/cloud/vm/UserVmDetailVO.java ---------------------------------------------------------------------- diff --git a/engine/schema/src/com/cloud/vm/UserVmDetailVO.java b/engine/schema/src/com/cloud/vm/UserVmDetailVO.java index d1a6e63..2b169a3 100644 --- a/engine/schema/src/com/cloud/vm/UserVmDetailVO.java +++ b/engine/schema/src/com/cloud/vm/UserVmDetailVO.java @@ -39,7 +39,7 @@ public class UserVmDetailVO implements ResourceDetail { @Column(name = "name") private String name; - @Column(name = "value", length = 1024) + @Column(name = "value", length = 5120) private String value; @Column(name = "display") http://git-wip-us.apache.org/repos/asf/cloudstack/blob/b6621428/setup/db/create-schema.sql ---------------------------------------------------------------------- diff --git a/setup/db/create-schema.sql b/setup/db/create-schema.sql index f95b02f..b4786c0 100755 --- a/setup/db/create-schema.sql +++ b/setup/db/create-schema.sql @@ -1140,7 +1140,7 @@ CREATE TABLE `cloud`.`user_vm_details` ( `id` bigint unsigned NOT NULL auto_increment, `vm_id` bigint unsigned NOT NULL COMMENT 'vm id', `name` varchar(255) NOT NULL, - `value` varchar(1024) NOT NULL, + `value` varchar(5120) NOT NULL, PRIMARY KEY (`id`), CONSTRAINT `fk_user_vm_details__vm_id` FOREIGN KEY `fk_user_vm_details__vm_id`(`vm_id`) REFERENCES `vm_instance`(`id`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8; http://git-wip-us.apache.org/repos/asf/cloudstack/blob/b6621428/setup/db/db/schema-441to450.sql ---------------------------------------------------------------------- diff --git a/setup/db/db/schema-441to450.sql b/setup/db/db/schema-441to450.sql index 5f1ddc1..0ee6c7f 100644 --- a/setup/db/db/schema-441to450.sql +++ b/setup/db/db/schema-441to450.sql @@ -766,3 +766,7 @@ DELETE t1 FROM guest_os_hypervisor t1, guest_os_hypervisor t2 WHERE (t1.hypervis UPDATE `cloud`.`vm_template` SET removed=NOW() WHERE unique_name="centos53-x86_64" AND hypervisor_type="XenServer"; ALTER TABLE `cloud_usage`.`usage_vpn_user` CHANGE `user_name` `user_name` VARCHAR(255); + +--Increase key value size generated from RSA-8192 to be stored. +ALTER TABLE `cloud`.`user_vm_details` MODIFY `value` VARCHAR(5120); +
