From 7376301ed44726f483af74ef4bd881463d7ea4a9 Mon Sep 17 00:00:00 2001
From: Michael Hoennig <michael@hoennig.de>
Date: Wed, 19 Oct 2022 07:39:10 +0200
Subject: [PATCH] use lower case in audit-log and rbac tables
---
src/main/resources/db/changelog/020-audit-log.sql | 2 ++
src/main/resources/db/changelog/058-rbac-generators.sql | 4 ++++
2 files changed, 6 insertions(+), 0 deletions(-)
diff --git a/src/main/resources/db/changelog/020-audit-log.sql b/src/main/resources/db/changelog/020-audit-log.sql
index e9a6b41..428f1e8 100644
--- a/src/main/resources/db/changelog/020-audit-log.sql
+++ b/src/main/resources/db/changelog/020-audit-log.sql
@@ -109,6 +109,8 @@
declare
createTriggerSQL varchar;
begin
+ targetTable := lower(targetTable);
+
createTriggerSQL = 'CREATE TRIGGER ' || targetTable || '_journal' ||
' AFTER INSERT OR UPDATE OR DELETE ON ' || targetTable ||
' FOR EACH ROW EXECUTE PROCEDURE tx_journal_trigger()';
diff --git a/src/main/resources/db/changelog/058-rbac-generators.sql b/src/main/resources/db/changelog/058-rbac-generators.sql
index ab20937..8268502 100644
--- a/src/main/resources/db/changelog/058-rbac-generators.sql
+++ b/src/main/resources/db/changelog/058-rbac-generators.sql
@@ -97,6 +97,8 @@
declare
sql text;
begin
+ targettable := lower(targettable);
+
-- create a view to the target main table which maps an idName to the objectUuid
sql = format($sql$
create or replace view %1$s_iv as
@@ -140,6 +142,8 @@
declare
sql text;
begin
+ targetTable := lower(targetTable);
+
/*
Creates a restricted view based on the 'view' permission of the current subject.
*/
--
Gitblit v1.9.3