diff options
author | Ted Trask <ttrask01@yahoo.com> | 2017-11-08 21:21:08 +0000 |
---|---|---|
committer | Ted Trask <ttrask01@yahoo.com> | 2017-11-08 21:21:08 +0000 |
commit | ed6cd04b89f247ef0d1ff227b5b50a6136639b8f (patch) | |
tree | aa79f70d3943a900a5b7dee31e8c04ef72fefd7f /provisioning-scripts.lua | |
parent | 4f6b5c434ac8b7753d7885df70fbd9c281464e59 (diff) | |
download | acf-provisioning-ed6cd04b89f247ef0d1ff227b5b50a6136639b8f.tar.bz2 acf-provisioning-ed6cd04b89f247ef0d1ff227b5b50a6136639b8f.tar.xz |
Added viewactivitylog functionality (no actual logs yet)
Diffstat (limited to 'provisioning-scripts.lua')
-rw-r--r-- | provisioning-scripts.lua | 8 |
1 files changed, 7 insertions, 1 deletions
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 |