From b1a3c5616d3d1ea7a9a31892a22b876efa8f907e Mon Sep 17 00:00:00 2001 From: Bill Erickson Date: Thu, 9 Aug 2012 10:25:28 -0400 Subject: [PATCH] url verify seed data / null constraint repairs Signed-off-by: Bill Erickson --- Open-ILS/src/sql/Pg/075.schema.url_verify.sql | 10 +++++----- Open-ILS/src/sql/Pg/upgrade/XXXX.schema.url_verify.sql | 10 +++++----- 2 files changed, 10 insertions(+), 10 deletions(-) diff --git a/Open-ILS/src/sql/Pg/075.schema.url_verify.sql b/Open-ILS/src/sql/Pg/075.schema.url_verify.sql index 753c769c94..fd365e05b9 100644 --- a/Open-ILS/src/sql/Pg/075.schema.url_verify.sql +++ b/Open-ILS/src/sql/Pg/075.schema.url_verify.sql @@ -41,11 +41,11 @@ CREATE TABLE url_verify.url_selector ( CREATE TABLE url_verify.url ( id SERIAL PRIMARY KEY, redirect_from INT REFERENCES url_verify.url(id) DEFERRABLE INITIALLY DEFERRED, - item INT NOT NULL REFERENCES container.biblio_record_entry_bucket_item (id) DEFERRABLE INITIALLY DEFERRED, - url_selector INT NOT NULL REFERENCES url_verify.url_selector (id) DEFERRABLE INITIALLY DEFERRED, - tag TEXT NOT NULL, - subfield TEXT NOT NULL, - ord INT NOT NULL, -- ordinal position of this url within the record as found by url_selector, for later update + item INT REFERENCES container.biblio_record_entry_bucket_item (id) DEFERRABLE INITIALLY DEFERRED, + url_selector INT REFERENCES url_verify.url_selector (id) DEFERRABLE INITIALLY DEFERRED, + tag TEXT, + subfield TEXT, + ord INT, -- ordinal position of this url within the record as found by url_selector, for later update full_url TEXT NOT NULL, scheme TEXT, username TEXT, diff --git a/Open-ILS/src/sql/Pg/upgrade/XXXX.schema.url_verify.sql b/Open-ILS/src/sql/Pg/upgrade/XXXX.schema.url_verify.sql index 5c8a9ab7cb..e001f9f7e4 100644 --- a/Open-ILS/src/sql/Pg/upgrade/XXXX.schema.url_verify.sql +++ b/Open-ILS/src/sql/Pg/upgrade/XXXX.schema.url_verify.sql @@ -23,11 +23,11 @@ CREATE TABLE url_verify.url_selector ( CREATE TABLE url_verify.url ( id SERIAL PRIMARY KEY, redirect_from INT REFERENCES url_verify.url(id) DEFERRABLE INITIALLY DEFERRED, - item INT NOT NULL REFERENCES container.biblio_record_entry_bucket_item (id) DEFERRABLE INITIALLY DEFERRED, - url_selector INT NOT NULL REFERENCES url_verify.url_selector (id) DEFERRABLE INITIALLY DEFERRED, - tag TEXT NOT NULL, - subfield TEXT NOT NULL, - ord INT NOT NULL, -- ordinal position of this url within the record as found by url_selector, for later update + item INT REFERENCES container.biblio_record_entry_bucket_item (id) DEFERRABLE INITIALLY DEFERRED, + url_selector INT REFERENCES url_verify.url_selector (id) DEFERRABLE INITIALLY DEFERRED, + tag TEXT, + subfield TEXT, + ord INT, full_url TEXT NOT NULL, scheme TEXT, username TEXT, -- 2.11.0