From d52100e237e2ae35f6ec3d3f9f557d05b909f325 Mon Sep 17 00:00:00 2001 From: miker Date: Thu, 20 Apr 2006 03:45:24 +0000 Subject: [PATCH] adding quality field to biblio records -- for use in metarecord lead picking git-svn-id: svn://svn.open-ils.org/ILS/trunk@3758 dcc99617-32d9-48b4-a31d-7c20da2025e4 --- .../OpenILS/Application/Storage/CDBI/biblio.pm | 2 +- Open-ILS/src/sql/Pg/010.schema.biblio.sql | 15 +++++++++------ 2 files changed, 10 insertions(+), 7 deletions(-) diff --git a/Open-ILS/src/perlmods/OpenILS/Application/Storage/CDBI/biblio.pm b/Open-ILS/src/perlmods/OpenILS/Application/Storage/CDBI/biblio.pm index 38f0bb4d9b..0a6b447a09 100644 --- a/Open-ILS/src/perlmods/OpenILS/Application/Storage/CDBI/biblio.pm +++ b/Open-ILS/src/perlmods/OpenILS/Application/Storage/CDBI/biblio.pm @@ -10,7 +10,7 @@ use base qw/biblio/; biblio::record_entry->table( 'biblio_record_entry' ); biblio::record_entry->columns( Essential => qw/id tcn_source tcn_value creator editor - create_date edit_date source active + create_date edit_date source active quality deleted marc last_xact_id fingerprint/ ); #------------------------------------------------------------------------------- diff --git a/Open-ILS/src/sql/Pg/010.schema.biblio.sql b/Open-ILS/src/sql/Pg/010.schema.biblio.sql index cb5c934ce0..f3637925a2 100644 --- a/Open-ILS/src/sql/Pg/010.schema.biblio.sql +++ b/Open-ILS/src/sql/Pg/010.schema.biblio.sql @@ -10,22 +10,25 @@ $$ LANGUAGE PLPGSQL; CREATE TABLE biblio.record_entry ( id BIGSERIAL PRIMARY KEY, - fingerprint TEXT, - tcn_source TEXT NOT NULL DEFAULT 'AUTOGEN', - tcn_value TEXT NOT NULL DEFAULT biblio.next_autogen_tcn_value(), creator INT NOT NULL DEFAULT 1, editor INT NOT NULL DEFAULT 1, + source INT, + quality INT, create_date TIMESTAMP WITH TIME ZONE NOT NULL DEFAULT now(), edit_date TIMESTAMP WITH TIME ZONE NOT NULL DEFAULT now(), active BOOL NOT NULL DEFAULT TRUE, deleted BOOL NOT NULL DEFAULT FALSE, - source INT, + fingerprint TEXT, + tcn_source TEXT NOT NULL DEFAULT 'AUTOGEN', + tcn_value TEXT NOT NULL DEFAULT biblio.next_autogen_tcn_value(), marc TEXT NOT NULL, last_xact_id TEXT NOT NULL ); CREATE INDEX biblio_record_entry_creator_idx ON biblio.record_entry ( creator ); CREATE INDEX biblio_record_entry_editor_idx ON biblio.record_entry ( editor ); -CREATE UNIQUE INDEX biblio_record_unique_tcn ON biblio.record_entry (tcn_source,tcn_value) WHERE deleted IS FALSE; +CREATE INDEX biblio_record_entry_fp_idx ON biblio.record_entry ( fingerprint ); +CREATE UNIQUE INDEX biblio_record_unique_tcn ON biblio.record_entry (tcn_value) WHERE deleted IS FALSE; + CREATE RULE protect_bib_rec_delete AS ON DELETE TO biblio.record_entry DO INSTEAD UPDATE biblio.record_entry SET deleted = TRUE WHERE OLD.id = biblio.record_entry.id; @@ -43,6 +46,6 @@ CREATE INDEX biblio_record_note_record_idx ON biblio.record_note ( record ); CREATE INDEX biblio_record_note_creator_idx ON biblio.record_note ( creator ); CREATE INDEX biblio_record_note_editor_idx ON biblio.record_note ( editor ); -INSERT INTO biblio.record_entry VALUES (-1,'','AUTOGEN','-1',1,1,NOW(),NOW(),FALSE,FALSE,1,'','FOO'); +INSERT INTO biblio.record_entry VALUES (-1,1,1,1,-1,NOW(),NOW(),FALSE,FALSE,'','AUTOGEN','-1','','FOO'); COMMIT; -- 2.43.2