From 6bc648f1cd62aa92b5ec17c8ad1ae599b0e10492 Mon Sep 17 00:00:00 2001
From: Jason Etheridge <phasefx@gmail.com>
Date: Fri, 12 May 2023 08:03:31 -0400
Subject: [PATCH] db

---
 Open-ILS/src/sql/Pg/950.data.seed-values.sql | 93 ++++++++++++++++++++++++++++
 1 file changed, 93 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 ec54030d8b..910c0bd73e 100644
--- a/Open-ILS/src/sql/Pg/950.data.seed-values.sql
+++ b/Open-ILS/src/sql/Pg/950.data.seed-values.sql
@@ -23464,3 +23464,96 @@ INSERT INTO config.org_unit_setting_type (name, label, grp, description, datatyp
     'link', 'csp')
 ;
 
+
+-- XXXX.data.schema.url_verify.sql
+-- Do we need to distribute these changes? (workstation setting types to that one big INSERT,
+-- table changes made without using ALTER, etc.)
+
+ALTER TABLE url_verify.url_selector
+    DROP CONSTRAINT url_selector_session_fkey,
+    ADD CONSTRAINT url_selector_session_fkey 
+        FOREIGN KEY (session) 
+        REFERENCES url_verify.session(id) 
+        ON UPDATE CASCADE
+        ON DELETE CASCADE
+        DEFERRABLE INITIALLY DEFERRED;
+
+ALTER TABLE url_verify.url
+    DROP CONSTRAINT url_session_fkey,
+    DROP CONSTRAINT url_redirect_from_fkey,
+    ADD CONSTRAINT url_session_fkey 
+        FOREIGN KEY (session) 
+        REFERENCES url_verify.session(id) 
+        ON UPDATE CASCADE
+        ON DELETE CASCADE
+        DEFERRABLE INITIALLY DEFERRED,
+    ADD CONSTRAINT url_redirect_from_fkey
+        FOREIGN KEY (redirect_from)
+        REFERENCES url_verify.url(id)
+        ON UPDATE CASCADE
+        ON DELETE CASCADE
+        DEFERRABLE INITIALLY DEFERRED;
+
+ALTER TABLE url_verify.verification_attempt
+    DROP CONSTRAINT verification_attempt_session_fkey,
+    ADD CONSTRAINT verification_attempt_session_fkey 
+        FOREIGN KEY (session) 
+        REFERENCES url_verify.session(id) 
+        ON UPDATE CASCADE
+        ON DELETE CASCADE
+        DEFERRABLE INITIALLY DEFERRED;
+
+ALTER TABLE url_verify.url_verification
+    DROP CONSTRAINT url_verification_url_fkey,
+    ADD CONSTRAINT url_verification_url_fkey
+        FOREIGN KEY (url)
+        REFERENCES url_verify.url(id)
+        ON UPDATE CASCADE
+        ON DELETE CASCADE
+        DEFERRABLE INITIALLY DEFERRED;
+
+INSERT into config.workstation_setting_type (name, grp, datatype, label)
+VALUES (
+    'eg.grid.catalog.link_checker', 'gui', 'object',
+    oils_i18n_gettext(
+        'eg.grid.catalog.link_checker',
+        'Grid Config: catalog.link_checker',
+        'cwst', 'label'
+    )
+), (
+    'eg.grid.catalog.link_checker.attempt', 'gui', 'object',
+    oils_i18n_gettext(
+        'eg.grid.catalog.link_checker.attempt',
+        'Grid Config: catalog.link_checker.attempt',
+        'cwst', 'label'
+    )
+), (
+    'eg.grid.catalog.link_checker.url', 'gui', 'object',
+    oils_i18n_gettext(
+        'eg.grid.catalog.link_checker.url',
+        'Grid Config: catalog.link_checker.url',
+        'cwst', 'label'
+    )
+), (
+    'eg.grid.filters.catalog.link_checker', 'gui', 'object',
+    oils_i18n_gettext(
+        'eg.grid.filters.catalog.link_checker',
+        'Grid Filter Sets: catalog.link_checker',
+        'cwst', 'label'
+    )
+), (
+    'eg.grid.filters.catalog.link_checker.attempt', 'gui', 'object',
+    oils_i18n_gettext(
+        'eg.grid.filters.catalog.link_checker.attempt',
+        'Grid Filter Sets: catalog.link_checker.attempt',
+        'cwst', 'label'
+    )
+), (
+    'eg.grid.filters.catalog.link_checker.url', 'gui', 'object',
+    oils_i18n_gettext(
+        'eg.grid.filters.catalog.link_checker.url',
+        'Grid Filter Sets: catalog.link_checker.url',
+        'cwst', 'label'
+    )
+);
+
-- 
2.11.0