From 4bd270faa852b17b487acee3f309cbc74e0ca6ec Mon Sep 17 00:00:00 2001 From: Bill Erickson Date: Tue, 22 Mar 2016 10:47:06 -0700 Subject: [PATCH] JBAS-1132 SQL sequence copy/paste repair Signed-off-by: Bill Erickson --- KCLS/sql/schema/deploy/patron-self-reg-mods.sql | 2 +- KCLS/sql/schema/revert/patron-self-reg-mods.sql | 2 +- 2 files changed, 2 insertions(+), 2 deletions(-) diff --git a/KCLS/sql/schema/deploy/patron-self-reg-mods.sql b/KCLS/sql/schema/deploy/patron-self-reg-mods.sql index 80b9ce4787..8e15efc413 100644 --- a/KCLS/sql/schema/deploy/patron-self-reg-mods.sql +++ b/KCLS/sql/schema/deploy/patron-self-reg-mods.sql @@ -38,7 +38,7 @@ BEGIN VALUES (10, 1, 'Card Design (online)'); -- need to retain the ID since it's referenced in the code. - PERFORM SETVAL('biblio.peer_type_id_seq'::TEXT, 11); + PERFORM SETVAL('actor.stat_cat_id_seq'::TEXT, 11); END IF; diff --git a/KCLS/sql/schema/revert/patron-self-reg-mods.sql b/KCLS/sql/schema/revert/patron-self-reg-mods.sql index e9354f0981..59c4c73a67 100644 --- a/KCLS/sql/schema/revert/patron-self-reg-mods.sql +++ b/KCLS/sql/schema/revert/patron-self-reg-mods.sql @@ -6,7 +6,7 @@ DELETE FROM actor.stat_cat_entry_usr_map WHERE stat_cat = 10; DELETE FROM actor.stat_cat WHERE id = 10; -- need to retain the ID since it's referenced in the code. -SELECT SETVAL('biblio.peer_type_id_seq'::TEXT, 10); +SELECT SETVAL('actor.stat_cat_id_seq'::TEXT, 10); DELETE FROM actor.org_unit_setting WHERE name = 'opac.self_register.profile'; -- 2.11.0