From bdbcc734d179f8c12a27ec65f49650667ed658cc Mon Sep 17 00:00:00 2001 From: Mike Rylander Date: Sun, 3 Apr 2011 18:48:30 -0400 Subject: [PATCH] Reworking tables a bit to include subfield list on controlling tags, specify hierarchy of tags (main-entry pointers for non-main fields), and remove unneeded name/description on bib fields --- Open-ILS/src/sql/Pg/011.schema.authority.sql | 6 +++--- 1 file changed, 3 insertions(+), 3 deletions(-) diff --git a/Open-ILS/src/sql/Pg/011.schema.authority.sql b/Open-ILS/src/sql/Pg/011.schema.authority.sql index 460d836fd2..d2e57956c3 100644 --- a/Open-ILS/src/sql/Pg/011.schema.authority.sql +++ b/Open-ILS/src/sql/Pg/011.schema.authority.sql @@ -30,8 +30,10 @@ CREATE TABLE authority.control_set ( CREATE TABLE authority.control_set_authority_field ( id SERIAL PRIMARY KEY, + main_entry INT REFERENCES authority.control_set_authority_field (id) ON UPDATE CASCADE ON DELETE CASCADE DEFERRABLE INITIALLY DEFERRED, control_set INT NOT NULL REFERENCES authority.control_set (id) ON UPDATE CASCADE ON DELETE CASCADE DEFERRABLE INITIALLY DEFERRED, tag CHAR(3) NOT NULL, + sf_list TEXT NOT NULL, name TEXT NOT NULL, -- i18n description TEXT -- i18n ); @@ -39,9 +41,7 @@ CREATE TABLE authority.control_set_authority_field ( CREATE TABLE authority.control_set_bib_field ( id SERIAL PRIMARY KEY, authority_field INT NOT NULL REFERENCES authority.control_set_authority_field (id) ON UPDATE CASCADE ON DELETE CASCADE DEFERRABLE INITIALLY DEFERRED, - tag CHAR(3) NOT NULL, - name TEXT NOT NULL, -- i18n - description TEXT -- i18n + tag CHAR(3) NOT NULL ); CREATE TABLE authority.thesaurus ( -- 2.11.0