From 504d1815e1eeba16e2e278b3f8f71a73f4f0297b Mon Sep 17 00:00:00 2001 From: miker Date: Thu, 25 Aug 2005 18:48:53 +0000 Subject: [PATCH] adding "lifecyle" view to each audited table git-svn-id: svn://svn.open-ils.org/ILS/trunk@1735 dcc99617-32d9-48b4-a31d-7c20da2025e4 --- Open-ILS/src/sql/Pg/900.audit-tables.sql | 11 ++++++++++- 1 file changed, 10 insertions(+), 1 deletion(-) diff --git a/Open-ILS/src/sql/Pg/900.audit-tables.sql b/Open-ILS/src/sql/Pg/900.audit-tables.sql index f7e14e8e0f..5becb976e9 100644 --- a/Open-ILS/src/sql/Pg/900.audit-tables.sql +++ b/Open-ILS/src/sql/Pg/900.audit-tables.sql @@ -9,7 +9,7 @@ BEGIN EXECUTE $$ CREATE TABLE auditor.$$ || sch || $$_$$ || tbl || $$_history ( audit_time TIMESTAMP WITH TIME ZONE NOT NULL, - audit_action CHAR(1) NOT NULL, + audit_action "char" NOT NULL, LIKE $$ || sch || $$.$$ || tbl || $$ ); $$; @@ -30,6 +30,15 @@ BEGIN AFTER UPDATE OR DELETE ON $$ || sch || $$.$$ || tbl || $$ FOR EACH ROW EXECUTE PROCEDURE auditor.audit_$$ || sch || $$_$$ || tbl || $$_func (); $$; + + EXECUTE $$ + CREATE VIEW auditor.$$ || sch || $$_$$ || tbl || $$_lifecycle AS + SELECT now() as audit_time, 'C' as audit_action, * + FROM $$ || sch || $$.$$ || tbl || $$ + UNION ALL + SELECT * + FROM auditor.$$ || sch || $$_$$ || tbl || $$_history; + $$; RETURN TRUE; END; $creator$ LANGUAGE 'plpgsql'; -- 2.43.2