Liquibase: Add indexes
Add the following indexes to the database:
-
unique index
ndx_uniq_inventoryNumber
oninventory
columnsinventory_number
- non-unique index
ndx_i_storageLocation
oninventory
columnssite_id
,form_type_code
,storage_location_part1
,storage_location_part2
,storage_location_part3
,storage_location_part4
-
unique index
ndx_uniq_accessionNumber
onaccession
columnsaccession_number