Good point! :) I should have said what branch it was in. You are correct it was master.
On Fri, Mar 7, 2014 at 2:33 AM, Rajesh Battala <rajesh.batt...@citrix.com>wrote: > Hi Mike, > This change is for master right? > > Thanks > Rajesh Battala > > -----Original Message----- > From: Mike Tutkowski [mailto:mike.tutkow...@solidfire.com] > Sent: Friday, March 7, 2014 1:36 AM > To: dev@cloudstack.apache.org > Subject: Just checked in a minor change to the DB > > Hi everyone, > > Just wanted to give you a heads up that I made a minor change to two views > in the DB in 9b66866dc2085486f465159cbd446ac03e266a2c: > > service_offering_view and disk_offering_view > > I added some columns to these views so I could present additional info in > the GUI. > > If you want to bring these two views up to date, just run the following > SQL: > > DROP VIEW IF EXISTS `cloud`.`disk_offering_view`; CREATE VIEW > `cloud`.`disk_offering_view` AS > select > disk_offering.id, > disk_offering.uuid, > disk_offering.name, > disk_offering.display_text, > disk_offering.disk_size, > disk_offering.min_iops, > disk_offering.max_iops, > disk_offering.created, > disk_offering.tags, > disk_offering.customized, > disk_offering.customized_iops, > disk_offering.removed, > disk_offering.use_local_storage, > disk_offering.system_use, > disk_offering.hv_ss_reserve, > disk_offering.bytes_read_rate, > disk_offering.bytes_write_rate, > disk_offering.iops_read_rate, > disk_offering.iops_write_rate, > disk_offering.cache_mode, > disk_offering.sort_key, > disk_offering.type, > disk_offering.display_offering, > domain.id domain_id, > domain.uuid domain_uuid, > domain.name domain_name, > domain.path domain_path > from > `cloud`.`disk_offering` > left join > `cloud`.`domain` ON disk_offering.domain_id = domain.id > where > disk_offering.state='ACTIVE'; > > DROP VIEW IF EXISTS `cloud`.`service_offering_view`; CREATE VIEW > `cloud`.`service_offering_view` AS > select > service_offering.id, > disk_offering.uuid, > disk_offering.name, > disk_offering.display_text, > disk_offering.created, > disk_offering.tags, > disk_offering.removed, > disk_offering.use_local_storage, > disk_offering.system_use, > disk_offering.customized_iops, > disk_offering.min_iops, > disk_offering.max_iops, > disk_offering.hv_ss_reserve, > disk_offering.bytes_read_rate, > disk_offering.bytes_write_rate, > disk_offering.iops_read_rate, > disk_offering.iops_write_rate, > disk_offering.cache_mode, > service_offering.cpu, > service_offering.speed, > service_offering.ram_size, > service_offering.nw_rate, > service_offering.mc_rate, > service_offering.ha_enabled, > service_offering.limit_cpu_use, > service_offering.host_tag, > service_offering.default_use, > service_offering.vm_type, > service_offering.sort_key, > service_offering.is_volatile, > service_offering.deployment_planner, > domain.id domain_id, > domain.uuid domain_uuid, > domain.name domain_name, > domain.path domain_path > from > `cloud`.`service_offering` > inner join > `cloud`.`disk_offering` ON service_offering.id = disk_offering.id > left join > `cloud`.`domain` ON disk_offering.domain_id = domain.id > where > disk_offering.state='Active'; > > Thanks! > > -- > *Mike Tutkowski* > *Senior CloudStack Developer, SolidFire Inc.* > e: mike.tutkow...@solidfire.com > o: 303.746.7302 > Advancing the way the world uses the > cloud<http://solidfire.com/solution/overview/?video=play> > *(tm)* > -- *Mike Tutkowski* *Senior CloudStack Developer, SolidFire Inc.* e: mike.tutkow...@solidfire.com o: 303.746.7302 Advancing the way the world uses the cloud<http://solidfire.com/solution/overview/?video=play> *(tm)*
