Updated Branches: refs/heads/object_store b7e14ce19 -> db76107df
add image_data_store_details to store more properties for s3, swift like data store properties. Project: http://git-wip-us.apache.org/repos/asf/cloudstack/repo Commit: http://git-wip-us.apache.org/repos/asf/cloudstack/commit/49323790 Tree: http://git-wip-us.apache.org/repos/asf/cloudstack/tree/49323790 Diff: http://git-wip-us.apache.org/repos/asf/cloudstack/diff/49323790 Branch: refs/heads/object_store Commit: 4932379094126c44079f860cb5f0aa050a856ea0 Parents: b7e14ce Author: Min Chen <[email protected]> Authored: Mon Apr 1 14:16:34 2013 -0700 Committer: Min Chen <[email protected]> Committed: Mon Apr 1 14:16:34 2013 -0700 ---------------------------------------------------------------------- setup/db/db/schema-410to420.sql | 10 ++++++++++ 1 files changed, 10 insertions(+), 0 deletions(-) ---------------------------------------------------------------------- http://git-wip-us.apache.org/repos/asf/cloudstack/blob/49323790/setup/db/db/schema-410to420.sql ---------------------------------------------------------------------- diff --git a/setup/db/db/schema-410to420.sql b/setup/db/db/schema-410to420.sql index 60f84b2..cbff750 100644 --- a/setup/db/db/schema-410to420.sql +++ b/setup/db/db/schema-410to420.sql @@ -79,6 +79,16 @@ CREATE TABLE `cloud`.`image_data_store` ( PRIMARY KEY(`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; +CREATE TABLE `cloud`.`image_data_store_details` ( + `id` bigint unsigned UNIQUE NOT NULL AUTO_INCREMENT COMMENT 'id', + `store_id` bigint unsigned NOT NULL COMMENT 'store the detail is related to', + `name` varchar(255) NOT NULL COMMENT 'name of the detail', + `value` varchar(255) NOT NULL COMMENT 'value of the detail', + PRIMARY KEY (`id`), + CONSTRAINT `fk_image_data_store_details__store_id` FOREIGN KEY `fk_image_data_store__store_id`(`store_id`) REFERENCES `image_data_store`(`id`) ON DELETE CASCADE, + INDEX `i_image_data_store__name__value`(`name`(128), `value`(128)) +) ENGINE=InnoDB DEFAULT CHARSET=utf8; + CREATE TABLE `cloud`.`template_store_ref` ( `id` bigint unsigned NOT NULL auto_increment,
