3 INSERT INTO config.upgrade_log (version) VALUES ('0291'); -- dbs
5 DROP INDEX IF EXISTS authority.authority_record_unique_tcn;
6 CREATE UNIQUE INDEX authority_record_unique_tcn ON authority.record_entry (arn_source,arn_value) WHERE deleted = FALSE OR deleted IS FALSE;
8 DROP INDEX IF EXISTS asset.asset_call_number_label_once_per_lib;
9 CREATE UNIQUE INDEX asset_call_number_label_once_per_lib ON asset.call_number (record, owning_lib, label) WHERE deleted = FALSE OR deleted IS FALSE;
11 DROP INDEX IF EXISTS asset.copy_barcode_key;
12 CREATE UNIQUE INDEX copy_barcode_key ON asset.copy (barcode) WHERE deleted = FALSE OR deleted IS FALSE;
14 DROP INDEX IF EXISTS biblio.biblio_record_unique_tcn;
15 CREATE UNIQUE INDEX biblio_record_unique_tcn ON biblio.record_entry (tcn_value) WHERE deleted = FALSE OR deleted IS FALSE;