summaryrefslogtreecommitdiffstats
path: root/provisioning-scripts.lua
diff options
context:
space:
mode:
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