Omer Frenkel has posted comments on this change. Change subject: core: Set default timezone to a Templates and VMs ......................................................................
Patch Set 4: (1 comment) http://gerrit.ovirt.org/#/c/28168/4/packaging/dbscripts/upgrade/03_05_0590_set_default_time_zone.sql File packaging/dbscripts/upgrade/03_05_0590_set_default_time_zone.sql: Line 1: -- set the defalut time zone from vdc_options Line 2: Line 3: -- set windows timezone if not set Line 4: update vm_static set time_zone=(select option_value from vdc_options where option_name = 'DefaultGeneralTimeZone') where time_zone is NULL and os in (select os_id from dwh_osinfo where os_name ilike '%windows%') and vm_guid != '00000000-0000-0000-0000-000000000000'; should set windows default for windows os Line 5: Line 6: -- set other os timezone if not set Line 7: update vm_static set time_zone=(select option_value from vdc_options where option_name = 'DefaultGeneralTimeZone') where time_zone is NULL and os not in (select os_id from dwh_osinfo where os_name ilike '%windows%') and vm_guid != '00000000-0000-0000-0000-000000000000'; -- To view, visit http://gerrit.ovirt.org/28168 To unsubscribe, visit http://gerrit.ovirt.org/settings Gerrit-MessageType: comment Gerrit-Change-Id: Id55b02a10c2faa17a7a50b64516d902c3d97e06d Gerrit-PatchSet: 4 Gerrit-Project: ovirt-engine Gerrit-Branch: master Gerrit-Owner: Shahar Havivi <[email protected]> Gerrit-Reviewer: Martin Betak <[email protected]> Gerrit-Reviewer: Omer Frenkel <[email protected]> Gerrit-Reviewer: Shahar Havivi <[email protected]> Gerrit-Reviewer: [email protected] Gerrit-Reviewer: oVirt Jenkins CI Server Gerrit-HasComments: Yes _______________________________________________ Engine-patches mailing list [email protected] http://lists.ovirt.org/mailman/listinfo/engine-patches
