Martin Betak has uploaded a new change for review. Change subject: core: Normalize default VM time zone representation ......................................................................
core: Normalize default VM time zone representation Added db migration script to update old VMs from engine versions which used empty string to represent 'Use default TimeZone' to value of NULL which is used currently. Change-Id: Ia5ffcfef3b2f1930e65c2f66e26c265df31e0813 Bug-Url: https://bugzilla.redhat.com/show_bug.cgi?id=988259 Signed-off-by: Martin Betak <[email protected]> --- A packaging/dbscripts/upgrade/03_03_0690_convert_empty_timezone_to_null.sql 1 file changed, 5 insertions(+), 0 deletions(-) git pull ssh://gerrit.ovirt.org:29418/ovirt-engine refs/changes/72/17672/1 diff --git a/packaging/dbscripts/upgrade/03_03_0690_convert_empty_timezone_to_null.sql b/packaging/dbscripts/upgrade/03_03_0690_convert_empty_timezone_to_null.sql new file mode 100644 index 0000000..30b02cb --- /dev/null +++ b/packaging/dbscripts/upgrade/03_03_0690_convert_empty_timezone_to_null.sql @@ -0,0 +1,5 @@ +-- update VMs from old engine version that used +-- empty string to represent 'default' time_zome +update vm_static +set time_zone = NULL +where time_zone = ''; -- To view, visit http://gerrit.ovirt.org/17672 To unsubscribe, visit http://gerrit.ovirt.org/settings Gerrit-MessageType: newchange Gerrit-Change-Id: Ia5ffcfef3b2f1930e65c2f66e26c265df31e0813 Gerrit-PatchSet: 1 Gerrit-Project: ovirt-engine Gerrit-Branch: master Gerrit-Owner: Martin Betak <[email protected]> _______________________________________________ Engine-patches mailing list [email protected] http://lists.ovirt.org/mailman/listinfo/engine-patches
