Skip to content

The easy-to-use open source Business Intelligence and Embedded Analytics tool that lets everyone work with data :bar_chart:

1.6 KB
Raw Blame
databaseChangeLog:
  - property:
      name: timestamp_type
      value: timestamp with time zone
      dbms: postgresql,h2
  - property:
      name: timestamp_type
      value: timestamp(6)
      dbms: mysql,mariadb
  - property:
      name: blob.type
      value: blob
      dbms: mysql,h2,mariadb
  - property:
      name: blob.type
      value: bytea
      dbms: postgresql
  # In MySQL, use LONGTEXT instead of TEXT (#7006)
  - property:
      name: text.type
      value: text
      dbms: postgresql,h2
  - property:
      name: text.type
      value: longtext
      dbms: mysql,mariadb
  # databasechangelog is uppercase in MySQL and H2 but lower-case in Postgres for reasons
  - property:
      name: databasechangelog.name
      value: DATABASECHANGELOG
      dbms: h2,mysql,mariadb
  - property:
      name: databasechangelog.name
      value: databasechangelog
      dbms: postgresql
  # in MySQL, use bit(1) for booleans instead of tinyint
  - property:
      name: boolean.type
      value: boolean
      dbms: postgresql,h2
  - property:
      name: boolean.type
      value: bit(1)
      dbms: mysql,mariadb
  # entity_id columns compare byte by byte, so every app DB orders serialized entities alike
  - property:
      name: entity_id.type
      value: char(21) COLLATE "C"
      dbms: postgresql
  - property:
      name: entity_id.type
      value: char(21) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin
      dbms: mysql,mariadb
  - property:
      name: entity_id.type
      value: char(21)
      dbms: h2

  - objectQuotingStrategy: QUOTE_ALL_OBJECTS

  - includeAll:
      path: migrations
      endsWithFilter: ".yaml"
      maxDepth: 2