From 1fad56266ce2db6b0f6c1c61c333b5b7f27d0d96 Mon Sep 17 00:00:00 2001 From: =?utf8?q?Bernd=20Ble=C3=9Fmann?= Date: Fri, 25 Jan 2019 11:09:33 +0100 Subject: [PATCH] DisplayableNamePrefs: DB-Upgrade-Skript um defaults zu setzen --- sql/Pg-upgrade2/displayable_name_prefs_defaults.sql | 13 +++++++++++++ 1 file changed, 13 insertions(+) create mode 100644 sql/Pg-upgrade2/displayable_name_prefs_defaults.sql diff --git a/sql/Pg-upgrade2/displayable_name_prefs_defaults.sql b/sql/Pg-upgrade2/displayable_name_prefs_defaults.sql new file mode 100644 index 000000000..542b36b2a --- /dev/null +++ b/sql/Pg-upgrade2/displayable_name_prefs_defaults.sql @@ -0,0 +1,13 @@ +-- @tag: displayable_name_prefs_defaults +-- @description: Setzen der Default-Einstellungen für einstellbare Picker-Anzeigen +-- @depends: user_preferences + +INSERT INTO user_preferences (login, namespace, version, key, value) + SELECT '#default#','DisplayableName','0.00000','SL::DB::Customer','<%customernumber%> <%name%>' + WHERE NOT EXISTS (SELECT id FROM user_preferences WHERE login LIKE '#default#' AND namespace LIKE 'DisplayableName' AND version = 0.00000 AND key LIKE 'SL::DB::Customer'); +INSERT INTO user_preferences (login, namespace, version, key, value) + SELECT '#default#','DisplayableName','0.00000','SL::DB::Vendor','<%vendornumber%> <%name%>' + WHERE NOT EXISTS (SELECT id FROM user_preferences WHERE login LIKE '#default#' AND namespace LIKE 'DisplayableName' AND version = 0.00000 AND key LIKE 'SL::DB::Vendor'); +INSERT INTO user_preferences (login, namespace, version, key, value) + SELECT '#default#','DisplayableName','0.00000','SL::DB::Part','<%partnumber%> <%description%>' + WHERE NOT EXISTS (SELECT id FROM user_preferences WHERE login LIKE '#default#' AND namespace LIKE 'DisplayableName' AND version = 0.00000 AND key LIKE 'SL::DB::Part'); -- 2.20.1