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_17_0.schema.yml Maven / Gradle / Ivy
databaseChangeLog:
- changeSet:
id: 3.17.0
author: GraviteeSource Team
changes:
##########################
# application_identities #
##########################
- addColumn:
tableName: application_identities
columns:
- column: { name: selection_rule, type: clob, constraints: { nullable: true } }
- column: { name: priority, type: integer, constraints: { nullable: false }, defaultValue: -1 }
##############
# flow_steps #
##############
- addColumn:
tableName: flow_steps
columns:
- column: { name: condition, type: clob, constraints: { nullable: true } }
###########
# domains #
###########
- addColumn:
tableName: domains
columns:
- column: { name: saml, type: clob, constraints: { nullable: true } }
- sql:
dbms: postgresql
sql: "UPDATE roles SET permission_acls = jsonb_set(cast(permission_acls as jsonb), '{DOMAIN_SAML}', '[\"CREATE\",\"READ\", \"UPDATE\", \"DELETE\", \"LIST\"]', true) WHERE name in ('ORGANIZATION_PRIMARY_OWNER', 'ORGANIZATION_OWNER', 'ENVIRONMENT_PRIMARY_OWNER', 'ENVIRONMENT_OWNER', 'DOMAIN_PRIMARY_OWNER', 'DOMAIN_OWNER');"
- sql:
dbms: mysql, mariadb
sql: "UPDATE roles SET permission_acls = JSON_SET(permission_acls, '$.DOMAIN_SAML', JSON_ARRAY('CREATE', 'READ', 'UPDATE', 'DELETE', 'LIST')) WHERE name in ('ORGANIZATION_PRIMARY_OWNER', 'ORGANIZATION_OWNER', 'ENVIRONMENT_PRIMARY_OWNER', 'ENVIRONMENT_OWNER', 'DOMAIN_PRIMARY_OWNER', 'DOMAIN_OWNER');"
- sql:
dbms: mssql
sql: "UPDATE roles SET permission_acls = JSON_MODIFY(permission_acls, '$.DOMAIN_SAML', JSON_QUERY('[\"CREATE\", \"READ\", \"UPDATE\", \"DELETE\", \"LIST\"]', '$')) WHERE name in ('ORGANIZATION_PRIMARY_OWNER', 'ORGANIZATION_OWNER', 'ENVIRONMENT_PRIMARY_OWNER', 'ENVIRONMENT_OWNER', 'DOMAIN_PRIMARY_OWNER', 'DOMAIN_OWNER');"
- sql:
dbms: postgresql
sql: "UPDATE roles SET permission_acls = jsonb_set(cast(permission_acls as jsonb), '{APPLICATION_SAML}', '[\"CREATE\",\"READ\", \"UPDATE\", \"DELETE\", \"LIST\"]', true) WHERE name in ('APPLICATION_PRIMARY_OWNER', 'APPLICATION_OWNER');"
- sql:
dbms: mysql, mariadb
sql: "UPDATE roles SET permission_acls = JSON_SET(permission_acls, '$.APPLICATION_SAML', JSON_ARRAY('CREATE', 'READ', 'UPDATE', 'DELETE', 'LIST')) WHERE name in ('APPLICATION_PRIMARY_OWNER', 'APPLICATION_OWNER', 'ENVIRONMENT_PRIMARY_OWNER');"
- sql:
dbms: mssql
sql: "UPDATE roles SET permission_acls = JSON_MODIFY(permission_acls, '$.APPLICATION_SAML', JSON_QUERY('[\"CREATE\", \"READ\", \"UPDATE\", \"DELETE\", \"LIST\"]', '$')) WHERE name in ('APPLICATION_PRIMARY_OWNER', 'APPLICATION_OWNER');"
