From f908e2beed16a7526ad990fa72daa9ec239d291e Mon Sep 17 00:00:00 2001 From: Mike Rylander Date: Tue, 14 Aug 2012 15:08:40 -0400 Subject: [PATCH] New container type for url verification sessions Signed-off-by: Mike Rylander --- Open-ILS/src/sql/Pg/950.data.seed-values.sql | 1 + Open-ILS/src/sql/Pg/upgrade/XXXX.schema.url_verify.sql | 5 +++++ 2 files changed, 6 insertions(+) diff --git a/Open-ILS/src/sql/Pg/950.data.seed-values.sql b/Open-ILS/src/sql/Pg/950.data.seed-values.sql index a89c22041f..9bb480bcd2 100644 --- a/Open-ILS/src/sql/Pg/950.data.seed-values.sql +++ b/Open-ILS/src/sql/Pg/950.data.seed-values.sql @@ -4862,6 +4862,7 @@ INSERT INTO container.biblio_record_entry_bucket_type (code,label) VALUES ('staf INSERT INTO container.biblio_record_entry_bucket_type (code,label) VALUES ('bookbag', oils_i18n_gettext('bookbag', 'Book Bag', 'cbrebt', 'label')); INSERT INTO container.biblio_record_entry_bucket_type (code,label) VALUES ('reading_list', oils_i18n_gettext('reading_list', 'Reading List', 'cbrebt', 'label')); INSERT INTO container.biblio_record_entry_bucket_type (code,label) VALUES ('template_merge',oils_i18n_gettext('template_merge','Template Merge Container', 'cbrebt', 'label')); +INSERT INTO container.biblio_record_entry_bucket_type (code,label) VALUES ('url_verify', oils_i18n_gettext('url_verify', 'URL Verification Queue', 'cbrebt', 'label')); INSERT INTO container.user_bucket_type (code,label) VALUES ('misc', oils_i18n_gettext('misc', 'Miscellaneous', 'cubt', 'label')); INSERT INTO container.user_bucket_type (code,label) VALUES ('folks', oils_i18n_gettext('folks', 'Friends', 'cubt', 'label')); 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 e001f9f7e4..82da8ee24c 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 @@ -1,3 +1,7 @@ +BEGIN; + +INSERT INTO container.biblio_record_entry_bucket_type (code, label) VALUES ('url_verify', 'URL Verification Queue'); + DROP SCHEMA IF EXISTS url_verify CASCADE; CREATE SCHEMA url_verify; @@ -80,3 +84,4 @@ CREATE TABLE url_verify.filter_set ( CONSTRAINT uvfs_name_once_per_lib UNIQUE (name, owning_lib) ); +COMMIT; -- 2.11.0