/var/lib/gnumed/server/sql/gmAudit.sql is in gnumed-server 16.17-1.
This file is owned by root:root, with mode 0o644.
The actual contents of the file can be viewed below.
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 | -- GNUmed auditing functionality
-- ===================================================================
-- license: GPL v2 or later
-- author: Karsten Hilbert
-- ===================================================================
-- force terminate + exit(3) on errors if non-interactive
\set ON_ERROR_STOP 1
-- ===================================================================
create schema audit authorization "gm-dbo";
-- ===================================================================
create table audit.audited_tables (
id serial primary key,
schema name
not null
default 'public',
table_name name
not null,
unique(schema, table_name)
);
-- ===================================================================
create table audit.audit_fields (
pk_audit serial
primary key,
row_version integer
not null
default 0,
modified_when timestamp with time zone
not null
default CURRENT_TIMESTAMP,
modified_by name
not null
default CURRENT_USER
);
-- ===================================================================
create table audit.audit_trail (
pk_audit serial
primary key,
orig_version integer
not null
default 0,
orig_when timestamp with time zone
not null,
orig_by name
not null,
orig_tableoid oid
not null,
audit_action text
not null
check (audit_action in ('UPDATE', 'DELETE')),
audit_when timestamp with time zone
not null
default CURRENT_TIMESTAMP,
audit_by name
not null
default CURRENT_USER
);
-- ===================================================================
-- do simple schema revision tracking
delete from gm_schema_revision where filename = '$RCSfile: gmAudit.sql,v $';
insert into gm_schema_revision (filename, version) values ('$RCSfile: gmAudit.sql,v $', '$Revision: 1.15 $');
-- ===================================================================
|