• Home
• io.gravitee.repository
• gravitee-repository-jdbc
• 3.5.0
• source code
• schema.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_5_0.schema.yml Maven / Gradle / Ivy

databaseChangeLog:
  - changeSet:
      id: 3.5.0
      author: GraviteeSource Team
      changes:
        - addNotNullConstraint:
            tableName: parameters
            columnDataType: nvarchar(32)
            columnName: reference_type
        - dropPrimaryKey:
            constraintName: pk_parameters
            tableName: parameters
        - addPrimaryKey:
            constraintName: pk_parameters
            columnNames: key, reference_id, reference_type
            tableName: parameters
        # dbms: mariadb, mysql
        - sql:
            dbms: mariadb, mysql
            sql: insert into parameters (`key`, reference_id, reference_type, value) select CONCAT('console.', `key`), 'DEFAULT', 'ORGANIZATION', value from parameters where (`key` = 'authentication.localLogin.enabled' or `key` like 'scheduler.%' or `key` like 'reCaptcha.%' or `key` like 'http.cors.%');
        - sql:
            dbms: mariadb, mysql
            sql: insert into parameters (`key`, reference_id, reference_type, value) select 'console.support.enabled', 'DEFAULT', 'ORGANIZATION', value from parameters where `key` = 'portal.support.enabled';
        - sql:
            dbms: mariadb, mysql
            sql: insert into parameters (`key`, reference_id, reference_type, value) select 'console.userCreation.enabled', 'DEFAULT', 'ORGANIZATION', value from parameters where `key` = 'portal.userCreation.enabled';
        - sql:
            dbms: mariadb, mysql
            sql: insert into parameters (`key`, reference_id, reference_type, value) select 'console.userCreation.automaticValidation.enabled', 'DEFAULT', 'ORGANIZATION', value from parameters where `key` = 'portal.userCreation.automaticValidation.enabled';
        - sql:
            dbms: mariadb, mysql
            sql: update parameters set `key` = CONCAT('portal.', `key`) where (`key` = 'authentication.localLogin.enabled' or `key` = 'authentication.forceLogin.enabled' or `key` like 'scheduler.%' or `key` like 'reCaptcha.%' or `key` like 'http.cors.%');

        # dbms: postgres
        - sql:
            dbms: postgres
            sql: insert into parameters ("key", reference_id, reference_type, value) select CONCAT('console.', "key"), 'DEFAULT', 'ORGANIZATION', value from parameters where ("key" = 'authentication.localLogin.enabled' or "key" like 'scheduler.%' or "key" like 'reCaptcha.%' or "key" like 'http.cors.%');
        - sql:
            dbms: postgres
            sql: insert into parameters ("key", reference_id, reference_type, value) select 'console.support.enabled', 'DEFAULT', 'ORGANIZATION', value from parameters where "key" = 'portal.support.enabled';
        - sql:
            dbms: postgres
            sql: insert into parameters ("key", reference_id, reference_type, value) select 'console.userCreation.enabled', 'DEFAULT', 'ORGANIZATION', value from parameters where "key" = 'portal.userCreation.enabled';
        - sql:
            dbms: postgres
            sql: insert into parameters ("key", reference_id, reference_type, value) select 'console.userCreation.automaticValidation.enabled', 'DEFAULT', 'ORGANIZATION', value from parameters where "key" = 'portal.userCreation.automaticValidation.enabled';
        - sql:
            dbms: postgres
            sql: update parameters set "key" = CONCAT('portal.', "key") where ("key" = 'authentication.localLogin.enabled' or "key" = 'authentication.forceLogin.enabled' or "key" like 'scheduler.%' or "key" like 'reCaptcha.%' or "key" like 'http.cors.%');

        # dbms: mssql
        - sql:
            dbms: mssql
            sql: insert into parameters ([key], reference_id, reference_type, value) select CONCAT('console.', [key]), 'DEFAULT', 'ORGANIZATION', value from parameters where ([key] = 'authentication.localLogin.enabled' or [key] like 'scheduler.%' or [key] like 'reCaptcha.%' or [key] like 'http.cors.%');
        - sql:
            dbms: mssql
            sql: insert into parameters ([key], reference_id, reference_type, value) select 'console.support.enabled', 'DEFAULT', 'ORGANIZATION', value from parameters where [key] = 'portal.support.enabled';
        - sql:
            dbms: mssql
            sql: insert into parameters ([key], reference_id, reference_type, value) select 'console.userCreation.enabled', 'DEFAULT', 'ORGANIZATION', value from parameters where [key] = 'portal.userCreation.enabled';
        - sql:
            dbms: mssql
            sql: insert into parameters ([key], reference_id, reference_type, value) select 'console.userCreation.automaticValidation.enabled', 'DEFAULT', 'ORGANIZATION', value from parameters where [key] = 'portal.userCreation.automaticValidation.enabled';
        - sql:
            dbms: mssql
            sql: update parameters set [key] = CONCAT('portal.', [key]) where ([key] = 'authentication.localLogin.enabled' or [key] = 'authentication.forceLogin.enabled' or [key] like 'scheduler.%' or [key] like 'reCaptcha.%' or [key] like 'http.cors.%');