Yaniv Dary has uploaded a new change for review. Change subject: history: added enum values for reports ......................................................................
history: added enum values for reports Change-Id: I4f2ec6cb9b060ae3d5fb15a872745aef05e10824 Signed-off-by: Yaniv Dary <yd...@redhat.com> --- A data-warehouse/historydbscripts_postgres/upgrade/03_02_0040_add_more_reports_enum_values.sql 1 file changed, 26 insertions(+), 0 deletions(-) git pull ssh://gerrit.ovirt.org:29418/ovirt-dwh refs/changes/19/11119/1 diff --git a/data-warehouse/historydbscripts_postgres/upgrade/03_02_0040_add_more_reports_enum_values.sql b/data-warehouse/historydbscripts_postgres/upgrade/03_02_0040_add_more_reports_enum_values.sql new file mode 100644 index 0000000..6edb64c --- /dev/null +++ b/data-warehouse/historydbscripts_postgres/upgrade/03_02_0040_add_more_reports_enum_values.sql @@ -0,0 +1,26 @@ +INSERT INTO enum_translator(enum_type, enum_key, language_code, value) + (SELECT 'REPORTS_NONE_AVAILABLE', 0, 'en_US', 'None Available' + WHERE NOT EXISTS (SELECT 1 + FROM enum_translator + WHERE enum_type = 'REPORTS_NONE_AVAILABLE' + AND enum_key = 0 + AND language_code = 'en_US' + AND value = 'None Available')); + +INSERT INTO enum_translator(enum_type, enum_key, language_code, value) + (SELECT 'REPORTS_REMOVED_ON', 0, 'en_US', 'Removed on' + WHERE NOT EXISTS (SELECT 1 + FROM enum_translator + WHERE enum_type = 'REPORTS_REMOVED_ON' + AND enum_key = 0 + AND language_code = 'en_US' + AND value = 'Removed on')); + +INSERT INTO enum_translator(enum_type, enum_key, language_code, value) + (SELECT 'REPORTS_DETACHED_ON', 0, 'en_US', 'Detached on' + WHERE NOT EXISTS (SELECT 1 + FROM enum_translator + WHERE enum_type = 'REPORTS_DETACHED_ON' + AND enum_key = 0 + AND language_code = 'en_US' + AND value = 'Detached on')); -- To view, visit http://gerrit.ovirt.org/11119 To unsubscribe, visit http://gerrit.ovirt.org/settings Gerrit-MessageType: newchange Gerrit-Change-Id: I4f2ec6cb9b060ae3d5fb15a872745aef05e10824 Gerrit-PatchSet: 1 Gerrit-Project: ovirt-dwh Gerrit-Branch: master Gerrit-Owner: Yaniv Dary <yd...@redhat.com> _______________________________________________ Engine-patches mailing list Engine-patches@ovirt.org http://lists.ovirt.org/mailman/listinfo/engine-patches
