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/ae14d4ba Tree: http://git-wip-us.apache.org/repos/asf/cloudstack/tree/ae14d4ba Diff: http://git-wip-us.apache.org/repos/asf/cloudstack/diff/ae14d4ba Branch: refs/heads/object_store Commit: ae14d4bab42ba3290ab8a9fab21150e155605ac2 Parents: 5b31a45 Author: Min Chen <[email protected]> Authored: Mon Apr 1 14:16:34 2013 -0700 Committer: Min Chen <[email protected]> Committed: Fri Apr 5 11:18:32 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/ae14d4ba/setup/db/db/schema-410to420.sql ---------------------------------------------------------------------- diff --git a/setup/db/db/schema-410to420.sql b/setup/db/db/schema-410to420.sql index a3a756e..c48cb5e 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,
