Drop the arn_value / arn_source columns on authority.record_entry and create an index...
authordbs <dbs@dcc99617-32d9-48b4-a31d-7c20da2025e4>
Thu, 16 Sep 2010 05:25:51 +0000 (05:25 +0000)
committerdbs <dbs@dcc99617-32d9-48b4-a31d-7c20da2025e4>
Thu, 16 Sep 2010 05:25:51 +0000 (05:25 +0000)
commit09954064b0f76d9bd234eb186e90394aac97f9b8
treed416b4dc5feab984e96e08852766c9aaa9c33712
parentf54aa76da2075885549e97ea8e2a64b3a5f91571
Drop the arn_value / arn_source columns on authority.record_entry and create an index instead

The authority record number (ARN) was problematic when trying to generate
local authorities because the number had no correlation to the content of
the authority heading. By creating an index on authority records based on
their heading, thesaurus, and heading text, we can do a better job of
controlling the actual content of the authority records.

In a future release, we may convert this index to a unique index. 2.0
will give sites an opportunity to begin cleaning up their authorities
by identifying duplicate and problematic records through the
authority.normalize_heading(TEXT) database function.

git-svn-id: svn://svn.open-ils.org/ILS/branches/rel_2_0@17722 dcc99617-32d9-48b4-a31d-7c20da2025e4
13 files changed:
Open-ILS/examples/fm_IDL.xml
Open-ILS/src/extras/import/marc2are.pl
Open-ILS/src/perlmods/OpenILS/Application/Cat/AuthCommon.pm
Open-ILS/src/perlmods/OpenILS/Application/Storage/CDBI/authority.pm
Open-ILS/src/perlmods/OpenILS/WWW/Exporter.pm
Open-ILS/src/sql/Pg/002.functions.config.sql
Open-ILS/src/sql/Pg/011.schema.authority.sql
Open-ILS/src/sql/Pg/020.schema.functions.sql
Open-ILS/src/sql/Pg/800.fkeys.sql
Open-ILS/src/sql/Pg/upgrade/0400.schema.unique_authority_index.sql [new file with mode: 0644]
Open-ILS/src/sql/Pg/upgrade/0401.schema.authority_record_entry_drop_arn.sql [new file with mode: 0644]
Open-ILS/src/sql/Pg/upgrade/0402.schema.unique_authority_index_revisited.sql [new file with mode: 0644]
Open-ILS/xul/staff_client/server/cat/marcedit.js