1) Added the option 'Show template databases?' to display template databases regardless of the setting of 'Show system objects?'.
2) Ensure that the user should be able to create a template database using create dialog instead of updating it later. Fixes #7351 Branch ------ master Details ------- https://git.postgresql.org/gitweb?p=pgadmin4.git;a=commitdiff;h=628e609e6a5aab9da0ecdcfaaee472b4ff9862ee Author: Pradip Parkale <pradip.park...@enterprisedb.com> Modified Files -------------- docs/en_US/database_dialog.rst | 1 + docs/en_US/images/database_definition.png | Bin 72722 -> 68693 bytes docs/en_US/images/preferences_browser_display.png | Bin 177359 -> 181432 bytes docs/en_US/preferences.rst | 3 + docs/en_US/release_notes_6_11.rst | 1 + web/package.json | 2 +- web/pgadmin/browser/collection.py | 12 ++ .../browser/register_browser_preferences.py | 7 + .../server_groups/servers/databases/__init__.py | 71 ++++++++-- .../databases/static/img/template_database.svg | 8 ++ .../databases/static/img/template_database_bad.svg | 10 ++ .../servers/databases/static/js/database.js | 24 +++- .../servers/databases/static/js/database.ui.js | 8 +- .../databases/templates/databases/css/database.css | 21 +++ .../databases/sql/10_plus/alter_online.sql | 147 +++++++++++++++++++++ .../templates/databases/sql/10_plus/create.sql | 21 +++ .../templates/databases/sql/10_plus/properties.sql | 37 ++++++ .../templates/databases/sql/default/nodes.sql | 7 +- .../templates/databases/sql/default/properties.sql | 2 - .../alter_default_db_privileges_function.sql | 3 +- .../alter_default_db_privileges_function_msql.sql | 1 - .../alter_default_db_privileges_reset_all.sql | 3 +- .../alter_default_db_privileges_sequences.sql | 3 +- .../default/alter_default_db_privileges_tables.sql | 3 +- .../default/alter_default_db_privileges_types.sql | 4 +- .../alter_default_db_privileges_function.sql | 3 +- .../alter_default_db_privileges_function_msql.sql | 1 - .../alter_default_db_privileges_reset_all.sql | 3 +- .../alter_default_db_privileges_sequences.sql | 3 +- .../default/alter_default_db_privileges_tables.sql | 3 +- .../default/alter_default_db_privileges_types.sql | 5 +- .../server_groups/servers/databases/tests/utils.py | 1 + web/pgadmin/browser/static/js/panel.js | 7 +- web/pgadmin/misc/sql/static/js/SQL.jsx | 5 +- web/yarn.lock | 4 +- 35 files changed, 380 insertions(+), 54 deletions(-)
