From 50b0b2ae11c05ed889541988424c11ec2f9e0aef Mon Sep 17 00:00:00 2001
From: Jason Etheridge <jason@EquinoxOLI.org>
Date: Sun, 12 Mar 2023 09:33:27 -0400
Subject: [PATCH] lp1993824: linkchecker; sql

Signed-off-by: Jason Etheridge <jason@EquinoxOLI.org>
---
 .../sql/Pg/upgrade/XXXX.data.schema.url_verify.sql | 94 ++++++++++++++++++++++
 1 file changed, 94 insertions(+)
 create mode 100644 Open-ILS/src/sql/Pg/upgrade/XXXX.data.schema.url_verify.sql

diff --git a/Open-ILS/src/sql/Pg/upgrade/XXXX.data.schema.url_verify.sql b/Open-ILS/src/sql/Pg/upgrade/XXXX.data.schema.url_verify.sql
new file mode 100644
index 0000000000..fa088cdddf
--- /dev/null
+++ b/Open-ILS/src/sql/Pg/upgrade/XXXX.data.schema.url_verify.sql
@@ -0,0 +1,94 @@
+
+BEGIN;
+
+--SELECT evergreen.upgrade_deps_block_check('XXXX', :eg_version);
+
+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'
+    )
+);
+
+COMMIT;
-- 
2.11.0