summaryrefslogtreecommitdiffstats
path: root/provisioning-scripts.lua
diff options
context:
space:
mode:
authorTed Trask <ttrask01@yahoo.com>2017-11-08 21:21:08 +0000
committerTed Trask <ttrask01@yahoo.com>2017-11-08 21:21:08 +0000
commited6cd04b89f247ef0d1ff227b5b50a6136639b8f (patch)
treeaa79f70d3943a900a5b7dee31e8c04ef72fefd7f /provisioning-scripts.lua
parent4f6b5c434ac8b7753d7885df70fbd9c281464e59 (diff)
downloadacf-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.lua8
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