@@ -24,6 +24,55 @@ UPDATE `cloud`.`hypervisor_capabilities` SET `max_hosts_per_cluster`=32 WHERE `h
2424INSERT IGNORE INTO ` cloud` .` hypervisor_capabilities` (hypervisor_type, hypervisor_version, max_guests_limit, security_group_enabled, max_hosts_per_cluster) VALUES (' VMware' , ' 5.1' , 128 , 0 , 32 );
2525DELETE FROM ` cloud` .` configuration` where name= ' vmware.percluster.host.max' ;
2626INSERT IGNORE INTO ` cloud` .` configuration` VALUES (' Advanced' , ' DEFAULT' , ' AgentManager' , ' xen.nics.max' , ' 7' , ' Maximum allowed nics for Vms created on Xen' );
27+ alter table template_host_ref add state varchar (255 );
28+ alter table template_host_ref add update_count bigint unsigned;
29+ alter table template_host_ref add updated datetime;
30+ alter table volume_host_ref add state varchar (255 );
31+ alter table volume_host_ref add update_count bigint unsigned;
32+ alter table volume_host_ref add updated datetime;
33+ alter table template_spool_ref add updated datetime;
34+ CREATE TABLE `cloud `.` object_datastore_ref` (
35+ ` id` bigint unsigned NOT NULL auto_increment,
36+ ` datastore_uuid` varchar (255 ) NOT NULL ,
37+ ` datastore_role` varchar (255 ) NOT NULL ,
38+ ` object_uuid` varchar (255 ) NOT NULL ,
39+ ` object_type` varchar (255 ) NOT NULL ,
40+ ` created` DATETIME NOT NULL ,
41+ ` last_updated` DATETIME,
42+ ` job_id` varchar (255 ),
43+ ` download_pct` int (10 ) unsigned,
44+ ` download_state` varchar (255 ),
45+ ` url` varchar (255 ),
46+ ` format` varchar (255 ),
47+ ` checksum` varchar (255 ),
48+ ` error_str` varchar (255 ),
49+ ` local_path` varchar (255 ),
50+ ` install_path` varchar (255 ),
51+ ` size` bigint unsigned COMMENT ' the size of the template on the pool' ,
52+ ` state` varchar (255 ) NOT NULL ,
53+ ` update_count` bigint unsigned NOT NULL ,
54+ ` updated` DATETIME,
55+ PRIMARY KEY (` id` )
56+ ) ENGINE= InnoDB AUTO_INCREMENT= 1 DEFAULT CHARSET= utf8;
57+
58+ CREATE TABLE `cloud `.` data_store_provider` (
59+ ` id` bigint unsigned NOT NULL AUTO_INCREMENT COMMENT ' id' ,
60+ ` name` varchar (255 ) NOT NULL COMMENT ' name of primary data store provider' ,
61+ ` uuid` varchar (255 ) NOT NULL COMMENT ' uuid of primary data store provider' ,
62+ PRIMARY KEY (` id` )
63+ ) ENGINE= InnoDB DEFAULT CHARSET= utf8;
64+
65+ CREATE TABLE `cloud `.` image_data_store` (
66+ ` id` bigint unsigned NOT NULL AUTO_INCREMENT COMMENT ' id' ,
67+ ` name` varchar (255 ) NOT NULL COMMENT ' name of data store' ,
68+ ` image_provider_id` bigint unsigned NOT NULL COMMENT ' id of image_data_store_provider' ,
69+ ` protocol` varchar (255 ) NOT NULL COMMENT ' protocol of data store' ,
70+ ` data_center_id` bigint unsigned COMMENT ' datacenter id of data store' ,
71+ ` scope` varchar (255 ) COMMENT ' scope of data store' ,
72+ ` uuid` varchar (255 ) COMMENT ' uuid of data store' ,
73+ PRIMARY KEY (` id` ),
74+ CONSTRAINT ` fk_tags__image_data_store_provider_id` FOREIGN KEY (` image_provider_id` ) REFERENCES ` data_store_provider` (` id` )
75+ ) ENGINE= InnoDB DEFAULT CHARSET= utf8;
2776
2877
2978ALTER TABLE ` cloud` .` service_offering` ADD COLUMN ` is_volatile` tinyint (1 ) unsigned NOT NULL DEFAULT 0 COMMENT ' true if the vm needs to be volatile, i.e., on every reboot of vm from API root disk is discarded and creates a new root disk' ;
0 commit comments