• Home
• io.gravitee.am.repository
• gravitee-am-repository-jdbc
• 4.5.0-alpha.3
• source code
• schema-add-default-scopes.yml

×

Project download

Many resources are needed to download a project. Please understand that we have to compensate our server costs. Thank you in advance.
Project price only 1 $

You can buy this project and download/modify it how often you want.

liquibase.changelogs.v3_10_0.schema-add-default-scopes.yml Maven / Gradle / Ivy

databaseChangeLog:
  - changeSet:
      id: 3.10.0-add-default-scopes
      author: GraviteeSource Team
      changes:

        - sql:
            dbms: postgresql
            sql: "UPDATE applications SET settings = jsonb_set(cast(settings as jsonb), '{oauth,defaultScopes}', settings->'oauth'->'scopes', true) where (settings->'oauth'->'scopes') IS NOT NULL;"

        - sql:
            dbms: mysql, mariadb
            sql: "UPDATE applications SET settings = JSON_SET(settings, '$.oauth.defaultScopes', JSON_EXTRACT(settings,'$.oauth.scopes')) where JSON_EXTRACT(settings,'$.oauth.scopes') IS NOT NULL;"

        - sql:
            dbms: mssql
            sql: "UPDATE applications SET settings = JSON_MODIFY(settings, '$.oauth.defaultScopes', JSON_QUERY(settings, '$.oauth.scopes')) where JSON_QUERY(settings, '$.oauth.scopes') IS NOT NULL;"