diff options
| author | Adam Ierymenko <adam.ierymenko@gmail.com> | 2015-09-15 10:59:23 -0700 |
|---|---|---|
| committer | Adam Ierymenko <adam.ierymenko@gmail.com> | 2015-09-15 10:59:23 -0700 |
| commit | 610ab0750ce3f104663577663d4b5883906c9641 (patch) | |
| tree | 1496f6606d9b5751905c88aed6b02fc945fc9bc4 /controller/schema.sql | |
| parent | ef316ced3bf52434eab34490b3f12b8d080c9252 (diff) | |
| download | infinitytier-610ab0750ce3f104663577663d4b5883906c9641.tar.gz infinitytier-610ab0750ce3f104663577663d4b5883906c9641.zip | |
Drop Sqlite-based Log table for now and switch to an in-memory log for recent activity. Log table gets too big on busy nodes. Should probably support push of events to some kind of event system later.
Diffstat (limited to 'controller/schema.sql')
| -rw-r--r-- | controller/schema.sql | 13 |
1 files changed, 0 insertions, 13 deletions
diff --git a/controller/schema.sql b/controller/schema.sql index 48d5607c..b6db7fa4 100644 --- a/controller/schema.sql +++ b/controller/schema.sql @@ -77,19 +77,6 @@ CREATE TABLE Member ( CREATE INDEX Member_networkId_activeBridge ON Member(networkId, activeBridge); CREATE INDEX Member_networkId_memberRevision ON Member(networkId, memberRevision); -CREATE TABLE Log ( - networkId char(16) NOT NULL, - nodeId char(10) NOT NULL, - ts integer NOT NULL, - authorized integer NOT NULL, - authTokenId integer, - version varchar(16), - fromAddr varchar(64) -); - -CREATE INDEX Log_networkId_nodeId ON Log(networkId, nodeId); -CREATE INDEX Log_ts ON Log(ts); - CREATE TABLE Relay ( networkId char(16) NOT NULL REFERENCES Network(id) ON DELETE CASCADE, address char(10) NOT NULL, |