• Home
• io.gravitee.am.repository
• gravitee-am-repository-jdbc
• 4.5.5
• source code
• 4.4.0-add-password-policies-table.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.v4_4_0.4.4.0-add-password-policies-table.yml Maven / Gradle / Ivy

databaseChangeLog:
  - changeSet:
      id: 4.4.0-add-password-policies-table
      author: GraviteeSource Team
      validCheckSum: ANY
      preConditions:
        - onFail: MARK_RAN
        - not:
            - tableExists:
                tableName: password_policies
      changes:
        - createTable:
            tableName: password_policies
            columns:
              - column: { name: id, type: nvarchar(64), constraints: { nullable: false } }
              - column: { name: reference_id, type: nvarchar(255), constraints: { nullable: false } }
              - column: { name: reference_type, type: nvarchar(64), constraints: { nullable: false } }
              - column: { name: created_at, type: timestamp(6), constraints: { nullable: false } }
              - column: { name: updated_at, type: timestamp(6), constraints: { nullable: false } }
              - column: { name: name, type: nvarchar(255), constraints: { nullable: false } }
              - column: { name: min_length, type: integer, constraints: { nullable: true } }
              - column: { name: max_length, type: integer, constraints: { nullable: true } }
              - column: { name: incl_numbers, type: boolean, constraints: { nullable: true } }
              - column: { name: incl_special_chars, type: boolean, constraints: { nullable: true } }
              - column: { name: letters_mixed_case, type: boolean, constraints: { nullable: true } }
              - column: { name: max_consecutive_letters, type: integer, constraints: { nullable: true } }
              - column: { name: exclude_pwd_in_dict, type: boolean, constraints: { nullable: true } }
              - column: { name: exclude_user_info_in_pwd, type: boolean, constraints: { nullable: true } }
              - column: { name: expiry_duration, type: integer, constraints: { nullable: true } }
              - column: { name: password_history_enabled, type: boolean, constraints: { nullable: true } }
              - column: { name: old_passwords, type: tinyint, constraints: { nullable: true } }

        - addPrimaryKey:
            constraintName: pk_password_policies
            columnNames: id
            tableName: password_policies

        - createIndex:
            columns:
              - column:
                  name: reference_id
              - column:
                  name: reference_type
            indexName: idx_password_policies_reference_type_identifier
            tableName: password_policies
            unique: false