Mailing-List: contact dev-help@cloudstack.apache.org; run by ezmlm
Precedence: bulk
Reply-To: dev@cloudstack.apache.org
Received-SPF: pass (athena.apache.org: domain of mike.tutkowski@solidfire.com
 designates 209.85.219.44 as permitted sender)
MIME-Version: 1.0
In-Reply-To: <CF464646.D81C%amogh.vasekar@citrix.com>
References: 
 <CACOnxCg9w8VYKX7AeSQD=Erjo0f7Vu0y07KrUGAq=awVofLTzg@mail.gmail.com>
	<CF464646.D81C%amogh.vasekar@citrix.com>
Date: Wed, 12 Mar 2014 18:24:16 -0600
Message-ID: 
 <CACOnxCgQLH2S_eys41-VP+zAgC+vyFu6vU8=kARGRx1TAbnyBA@mail.gmail.com>
Subject: Re: Just checked in a minor change to the DB
From: Mike Tutkowski <mike.tutkowski@solidfire.com>
To: "dev@cloudstack.apache.org" <dev@cloudstack.apache.org>
Content-Type: multipart/alternative; boundary=089e015366b43fe09c04f471f9e7

--089e015366b43fe09c04f471f9e7
Content-Type: text/plain; charset=ISO-8859-1

Thanks for the notification! :)

We decided (Daan suggested and I agreed) that [DB-CHANGE] can be used for
these types of messages.

Thanks! I'm guessing this will be a big week for schema changes.


On Wed, Mar 12, 2014 at 6:17 PM, Amogh Vasekar <amogh.vasekar@citrix.com>wrote:

> Hi All,
>
> (Since I am not sure yet if a tag has been agreed to, sending on this
> thread instead)
> I made a couple of changes to guest_os and guest_os_hypervisor tables, the
> following should take care of schema changes after git pull:
>
> ===guest_os_hypervisor====
> ALTER TABLE `cloud`.`guest_os_hypervisor` ADD COLUMN `hypervisor_version`
> varchar(32) NOT NULL DEFAULT 'default' COMMENT 'Hypervisor version for
> this mapping';
> ALTER TABLE `cloud`.`guest_os_hypervisor` ADD COLUMN `uuid` varchar(40)
> COMMENT 'UUID of the mapping';
> ALTER TABLE `cloud`.`guest_os_hypervisor` ADD CONSTRAINT
> `uc_guest_os_hypervisor__uuid` UNIQUE (`uuid`);
> ALTER TABLE `cloud`.`guest_os_hypervisor` ADD COLUMN `created` datetime
> COMMENT 'Time when mapping was created';
> ALTER TABLE `cloud`.`guest_os_hypervisor` ADD COLUMN `removed` datetime
> COMMENT 'Time when mapping was removed if deleted, else NULL';
> UPDATE `cloud`.`guest_os_hypervisor` SET `uuid` = UUID();
> UPDATE `cloud`.`guest_os_hypervisor` SET `created` = now();
> ==========================
>
> ===guest_os====
>
> ALTER TABLE `cloud`.`guest_os` ADD COLUMN `created` datetime COMMENT 'Time
> when Guest OS was created in system';
> ALTER TABLE `cloud`.`guest_os` ADD COLUMN `removed` datetime COMMENT 'Time
> when Guest OS was removed if deleted, else NULL';
> UPDATE `cloud`.`guest_os` SET `created` = now();
> ===============
>
>
> Thanks,
> Amogh
>
> On 3/6/14 12:05 PM, "Mike Tutkowski" <mike.tutkowski@solidfire.com> wrote:
>
> >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.tutkowski@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.tutkowski@solidfire.com
o: 303.746.7302
Advancing the way the world uses the
cloud<http://solidfire.com/solution/overview/?video=play>
*(tm)*

--089e015366b43fe09c04f471f9e7--