From ed6cd04b89f247ef0d1ff227b5b50a6136639b8f Mon Sep 17 00:00:00 2001 From: Ted Trask Date: Wed, 8 Nov 2017 21:21:08 +0000 Subject: Added viewactivitylog functionality (no actual logs yet) --- provisioning-scripts.lua | 8 +++++++- 1 file changed, 7 insertions(+), 1 deletion(-) (limited to 'provisioning-scripts.lua') diff --git a/provisioning-scripts.lua b/provisioning-scripts.lua index 83be198..65cd36b 100644 --- a/provisioning-scripts.lua +++ b/provisioning-scripts.lua @@ -1493,7 +1493,13 @@ mymodule.provisioning_options = { -- List of getfile requests mymodule.provisioning_requests = { - "CREATE TABLE provisioning_requests (mac VARCHAR(12) unique, ip VARCHAR(15), agent VARCHAR(255), date timestamp)", + "CREATE TABLE provisioning_requests (mac VARCHAR(12) UNIQUE, ip VARCHAR(15), agent VARCHAR(255), date timestamp)", +} + +-- History +mymodule.dbhistlog = { + "CREATE TABLE dbhistlog (logdatetime timestamp(3) without time zone NOT NULL, msgtext text, userid text)", + "CREATE INDEX dbhistlogdatetimeidx ON dbhistlog USING btree (logdatetime)", } return mymodule -- cgit v1.2.3