Yaniv Dary has uploaded a new change for review. Change subject: history: added missing enum keys for OS (#966437) ......................................................................
history: added missing enum keys for OS (#966437) Bug-Url: https://bugzilla.redhat.com/966437 Change-Id: I86f8c98a54b686c470939c2601a355c7e3abc0f6 Signed-off-by: Yaniv Dary <[email protected]> --- A data-warehouse/historydbscripts_postgres/upgrade/03_02_0080_added_missing_os_enums.sql 1 file changed, 26 insertions(+), 0 deletions(-) git pull ssh://gerrit.ovirt.org:29418/ovirt-dwh refs/changes/64/15064/1 diff --git a/data-warehouse/historydbscripts_postgres/upgrade/03_02_0080_added_missing_os_enums.sql b/data-warehouse/historydbscripts_postgres/upgrade/03_02_0080_added_missing_os_enums.sql new file mode 100644 index 0000000..da70e3b --- /dev/null +++ b/data-warehouse/historydbscripts_postgres/upgrade/03_02_0080_added_missing_os_enums.sql @@ -0,0 +1,26 @@ +--add windows 8 +SELECT update_enum_translator(cast('OS_TYPE' as varchar(40)),cast(20 as smallint),cast('de' as varchar(40)),cast('Windows 8' as text)); +SELECT update_enum_translator(cast('OS_TYPE' as varchar(40)),cast(20 as smallint),cast('en_US' as varchar(40)),cast('Windows 8' as text)); +SELECT update_enum_translator(cast('OS_TYPE' as varchar(40)),cast(20 as smallint),cast('es' as varchar(40)),cast('Windows 8' as text)); +SELECT update_enum_translator(cast('OS_TYPE' as varchar(40)),cast(20 as smallint),cast('fr' as varchar(40)),cast('Windows 8' as text)); +SELECT update_enum_translator(cast('OS_TYPE' as varchar(40)),cast(20 as smallint),cast('ja' as varchar(40)),cast('Windows 8' as text)); +SELECT update_enum_translator(cast('OS_TYPE' as varchar(40)),cast(20 as smallint),cast('pt_BR' as varchar(40)),cast('Windows 8' as text)); +SELECT update_enum_translator(cast('OS_TYPE' as varchar(40)),cast(20 as smallint),cast('zh_CN' as varchar(40)),cast('Windows 8' as text)); + +--add windows 8 x64 +SELECT update_enum_translator(cast('OS_TYPE' as varchar(40)),cast(21 as smallint),cast('de' as varchar(40)),cast('Windows 8 x64' as text)); +SELECT update_enum_translator(cast('OS_TYPE' as varchar(40)),cast(21 as smallint),cast('en_US' as varchar(40)),cast('Windows 8 x64' as text)); +SELECT update_enum_translator(cast('OS_TYPE' as varchar(40)),cast(21 as smallint),cast('es' as varchar(40)),cast('Windows 8 x64' as text)); +SELECT update_enum_translator(cast('OS_TYPE' as varchar(40)),cast(21 as smallint),cast('fr' as varchar(40)),cast('Windows 8 x64' as text)); +SELECT update_enum_translator(cast('OS_TYPE' as varchar(40)),cast(21 as smallint),cast('ja' as varchar(40)),cast('Windows 8 x64' as text)); +SELECT update_enum_translator(cast('OS_TYPE' as varchar(40)),cast(21 as smallint),cast('pt_BR' as varchar(40)),cast('Windows 8 x64' as text)); +SELECT update_enum_translator(cast('OS_TYPE' as varchar(40)),cast(21 as smallint),cast('zh_CN' as varchar(40)),cast('Windows 8 x64' as text)); + +--add windows 2012 +SELECT update_enum_translator(cast('OS_TYPE' as varchar(40)),cast(23 as smallint),cast('de' as varchar(40)),cast('Windows 2012 x64' as text)); +SELECT update_enum_translator(cast('OS_TYPE' as varchar(40)),cast(23 as smallint),cast('en_US' as varchar(40)),cast('Windows 2012 x64' as text)); +SELECT update_enum_translator(cast('OS_TYPE' as varchar(40)),cast(23 as smallint),cast('es' as varchar(40)),cast('Windows 2012 x64' as text)); +SELECT update_enum_translator(cast('OS_TYPE' as varchar(40)),cast(23 as smallint),cast('fr' as varchar(40)),cast('Windows 2012 x64' as text)); +SELECT update_enum_translator(cast('OS_TYPE' as varchar(40)),cast(23 as smallint),cast('ja' as varchar(40)),cast('Windows 2012 x64' as text)); +SELECT update_enum_translator(cast('OS_TYPE' as varchar(40)),cast(23 as smallint),cast('pt_BR' as varchar(40)),cast('Windows 2012 x64' as text)); +SELECT update_enum_translator(cast('OS_TYPE' as varchar(40)),cast(23 as smallint),cast('zh_CN' as varchar(40)),cast('Windows 2012 x64' as text)); -- To view, visit http://gerrit.ovirt.org/15064 To unsubscribe, visit http://gerrit.ovirt.org/settings Gerrit-MessageType: newchange Gerrit-Change-Id: I86f8c98a54b686c470939c2601a355c7e3abc0f6 Gerrit-PatchSet: 1 Gerrit-Project: ovirt-dwh Gerrit-Branch: master Gerrit-Owner: Yaniv Dary <[email protected]> _______________________________________________ Engine-patches mailing list [email protected] http://lists.ovirt.org/mailman/listinfo/engine-patches
