diff options
Diffstat (limited to 'util')
-rw-r--r-- | util/updates/2020-04-27-audit-logging.sql | 11 |
1 files changed, 11 insertions, 0 deletions
diff --git a/util/updates/2020-04-27-audit-logging.sql b/util/updates/2020-04-27-audit-logging.sql new file mode 100644 index 00000000..47a99ce9 --- /dev/null +++ b/util/updates/2020-04-27-audit-logging.sql @@ -0,0 +1,11 @@ +CREATE TABLE audit_log ( + date timestamptz NOT NULL DEFAULT NOW(), + by_uid integer, + by_name text, + by_ip inet NOT NULL, + affected_uid integer, + affected_name text, + action text NOT NULL, + detail text +); +\i sql/perms.sql |