Adding more fields to the unique index on report_grid_col_def
without this it is impossible to register multiple attestation types
<tagDatabase tag="v1.43"/> <!-- tag the current db version, i.e. the last -->
</changeSet>
+ <changeSet id="20220801-6103-1"
+ author="davidwatkins73">
+ <dropIndex tableName="report_grid_column_definition"
+ indexName="idx_rgcd_entity_ref_report_grid_id"/>
+
+ <createIndex tableName="report_grid_column_definition"
+ indexName="idx_rgcd_entity_ref_report_grid_id"
+ unique="true">
+ <column name="report_grid_id"
+ type="${id.type}"/>
+ <column name="column_entity_kind"
+ type="${enum.type}"/>
+ <column name="column_entity_id"
+ type="${id.type}"/>
+ <column name="entity_field_reference_id"
+ type="${id.type}"/>
+ <column name="column_qualifier_kind"
+ type="${enum.type}"/>
+ <column name="column_qualifier_id"
+ type="${id.type}"/>
+ </createIndex>
+ </changeSet>
+
</databaseChangeLog>
