diff options
| author | Adam Ierymenko <adam.ierymenko@gmail.com> | 2015-07-22 14:01:49 -0700 |
|---|---|---|
| committer | Adam Ierymenko <adam.ierymenko@gmail.com> | 2015-07-22 14:01:49 -0700 |
| commit | e2a2993b186c521f9521d1a9adeb150d27c15629 (patch) | |
| tree | cf560bab70e083108815afdfc731058678568b87 /controller/schema.sql.c | |
| parent | 8ca885d27c0785bbd4f7932ff2393e32a5c557c7 (diff) | |
| download | infinitytier-e2a2993b186c521f9521d1a9adeb150d27c15629.tar.gz infinitytier-e2a2993b186c521f9521d1a9adeb150d27c15629.zip | |
Add a Log table to log queries for debugging and security logging. No JSON API support for querying the log yet, but will probably come via /network/###/member/###/log/... or something.
Diffstat (limited to 'controller/schema.sql.c')
| -rw-r--r-- | controller/schema.sql.c | 11 |
1 files changed, 11 insertions, 0 deletions
diff --git a/controller/schema.sql.c b/controller/schema.sql.c index efeb280c..ac0213bc 100644 --- a/controller/schema.sql.c +++ b/controller/schema.sql.c @@ -66,6 +66,17 @@ "CREATE INDEX Member_networkId_activeBridge ON Member(networkId, activeBridge);\n"\ "CREATE INDEX Member_networkId_memberRevision ON Member(networkId, memberRevision);\n"\ "\n"\ +"CREATE TABLE Log (\n"\ +" networkId char(16) NOT NULL,\n"\ +" nodeId char(10) NOT NULL,\n"\ +" ts integer NOT NULL,\n"\ +" authorized integer NOT NULL,\n"\ +" fromAddr varchar(64)\n"\ +");\n"\ +"\n"\ +"CREATE INDEX Log_networkId_nodeId ON Log(networkId, nodeId);\n"\ +"CREATE INDEX Log_ts ON Log(ts);\n"\ +"\n"\ "CREATE TABLE Relay (\n"\ " networkId char(16) NOT NULL REFERENCES Network(id) ON DELETE CASCADE,\n"\ " address char(10) NOT NULL,\n"\ |