From afaedc097fdea0f54b3b903e94fe7c1b7f9929bc Mon Sep 17 00:00:00 2001 From: miker Date: Mon, 11 Apr 2005 19:18:12 +0000 Subject: [PATCH] fixup on the generated audit triggers git-svn-id: svn://svn.open-ils.org/ILS/trunk@475 dcc99617-32d9-48b4-a31d-7c20da2025e4 --- Open-ILS/src/sql/Postgres/900.audit-tables.sql | 13 +++++-------- 1 file changed, 5 insertions(+), 8 deletions(-) diff --git a/Open-ILS/src/sql/Postgres/900.audit-tables.sql b/Open-ILS/src/sql/Postgres/900.audit-tables.sql index 9cea608c45..f7e14e8e0f 100644 --- a/Open-ILS/src/sql/Postgres/900.audit-tables.sql +++ b/Open-ILS/src/sql/Postgres/900.audit-tables.sql @@ -8,7 +8,8 @@ CREATE FUNCTION auditor.create_auditor ( sch TEXT, tbl TEXT ) RETURNS BOOL AS $c BEGIN EXECUTE $$ CREATE TABLE auditor.$$ || sch || $$_$$ || tbl || $$_history ( - audit_time TIMESTAMP WITH TIME ZONE NOT NULL DEFAULT NOW(), + audit_time TIMESTAMP WITH TIME ZONE NOT NULL, + audit_action CHAR(1) NOT NULL, LIKE $$ || sch || $$.$$ || tbl || $$ ); $$; @@ -18,19 +19,15 @@ BEGIN RETURNS TRIGGER AS $func$ BEGIN INSERT INTO auditor.$$ || sch || $$_$$ || tbl || $$_history - (NOW(),OLD.*); - RETURN NEW; + SELECT now(), SUBSTR(TG_OP,1,1), OLD.*; + RETURN NULL; END; $func$ LANGUAGE 'plpgsql'; $$; EXECUTE $$ CREATE TRIGGER audit_$$ || sch || $$_$$ || tbl || $$_update_trigger - AFTER UPDATE ON $$ || sch || $$.$$ || tbl || $$ FOR EACH ROW - EXECUTE PROCEDURE auditor.audit_$$ || sch || $$_$$ || tbl || $$_func (); - - CREATE TRIGGER audit_$$ || sch || $$_$$ || tbl || $$_delete_trigger - BEFORE DELETE ON $$ || sch || $$.$$ || tbl || $$ FOR EACH ROW + AFTER UPDATE OR DELETE ON $$ || sch || $$.$$ || tbl || $$ FOR EACH ROW EXECUTE PROCEDURE auditor.audit_$$ || sch || $$_$$ || tbl || $$_func (); $$; RETURN TRUE; -- 2.43.2