]> git.evergreen-ils.org Git - working/Evergreen.git/commit
Create a unique index on authority records based on their heading, thesaurus, and...
authordbs <dbs@dcc99617-32d9-48b4-a31d-7c20da2025e4>
Wed, 15 Sep 2010 18:53:01 +0000 (18:53 +0000)
committerdbs <dbs@dcc99617-32d9-48b4-a31d-7c20da2025e4>
Wed, 15 Sep 2010 18:53:01 +0000 (18:53 +0000)
commitf8a36572a9d8515c3a1f594795751f95e3d13323
tree0d4ce04f026c9c59208b64fb9876b3481e80bf61
parent3ad7d6d8568314b0848962ace134e31af3301d79
Create a unique index on authority records based on their heading, thesaurus, and heading text

By providing a truly unique index for headings for a given thesaurus, this
index sets the stage for removing the arn_value / arn_source columns from
the database.

Sites with loaded authority records who attempt to add this index may find that
it fails due to existing duplicate entries; some suggestions for hunting down
the trouble-doers (duplicate entries) is provided in
Open-ILS/src/sql/Pg/0400.schema.unique_authority_index.sql

git-svn-id: svn://svn.open-ils.org/ILS/trunk@17704 dcc99617-32d9-48b4-a31d-7c20da2025e4
Open-ILS/src/sql/Pg/002.schema.config.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]