diff options
| author | Adam Ierymenko <adam.ierymenko@gmail.com> | 2016-06-28 16:09:41 -0700 |
|---|---|---|
| committer | Adam Ierymenko <adam.ierymenko@gmail.com> | 2016-06-28 16:09:41 -0700 |
| commit | 1e00603241b03e738039b910828139b4e305f525 (patch) | |
| tree | 5a00af732199a0783b9c08595add6a9efae763d4 /controller/schema.sql.c | |
| parent | f6442f2752e256a0b08d1d2f1be5123a6f364c99 (diff) | |
| parent | 0410fd4824fd898fab7815c6ef67b8e39bb6d2b9 (diff) | |
| download | infinitytier-1e00603241b03e738039b910828139b4e305f525.tar.gz infinitytier-1e00603241b03e738039b910828139b4e305f525.zip | |
Merge branch 'dev' of http://10.6.6.2/zerotier/ZeroTierOne into dev
Diffstat (limited to 'controller/schema.sql.c')
| -rw-r--r-- | controller/schema.sql.c | 22 |
1 files changed, 5 insertions, 17 deletions
diff --git a/controller/schema.sql.c b/controller/schema.sql.c index 5c21403a..dab34138 100644 --- a/controller/schema.sql.c +++ b/controller/schema.sql.c @@ -34,23 +34,6 @@ " identity varchar(4096) NOT NULL\n"\ ");\n"\ "\n"\ -"CREATE TABLE NodeHistory (\n"\ -" nodeId char(10) NOT NULL REFERENCES Node(id) ON DELETE CASCADE,\n"\ -" networkId char(16) NOT NULL REFERENCES Network(id) ON DELETE CASCADE,\n"\ -" networkVisitCounter INTEGER NOT NULL DEFAULT(0),\n"\ -" networkRequestAuthorized INTEGER NOT NULL DEFAULT(0),\n"\ -" requestTime INTEGER NOT NULL DEFAULT(0),\n"\ -" clientMajorVersion INTEGER NOT NULL DEFAULT(0),\n"\ -" clientMinorVersion INTEGER NOT NULL DEFAULT(0),\n"\ -" clientRevision INTEGER NOT NULL DEFAULT(0),\n"\ -" networkRequestMetaData VARCHAR(1024),\n"\ -" fromAddress VARCHAR(128)\n"\ -");\n"\ -"\n"\ -"CREATE INDEX NodeHistory_nodeId ON NodeHistory (nodeId);\n"\ -"CREATE INDEX NodeHistory_networkId ON NodeHistory (networkId);\n"\ -"CREATE INDEX NodeHistory_requestTime ON NodeHistory (requestTime);\n"\ -"\n"\ "CREATE TABLE IpAssignment (\n"\ " networkId char(16) NOT NULL REFERENCES Network(id) ON DELETE CASCADE,\n"\ " nodeId char(10) REFERENCES Node(id) ON DELETE CASCADE,\n"\ @@ -80,12 +63,17 @@ " activeBridge integer NOT NULL DEFAULT(0),\n"\ " memberRevision integer NOT NULL DEFAULT(0),\n"\ " flags integer NOT NULL DEFAULT(0),\n"\ +" lastRequestTime integer NOT NULL DEFAULT(0),\n"\ +" lastPowDifficulty integer NOT NULL DEFAULT(0),\n"\ +" lastPowTime integer NOT NULL DEFAULT(0),\n"\ +" recentHistory blob,\n"\ " PRIMARY KEY (networkId, nodeId)\n"\ ");\n"\ "\n"\ "CREATE INDEX Member_networkId_nodeId ON Member(networkId,nodeId);\n"\ "CREATE INDEX Member_networkId_activeBridge ON Member(networkId, activeBridge);\n"\ "CREATE INDEX Member_networkId_memberRevision ON Member(networkId, memberRevision);\n"\ +"CREATE INDEX Member_networkId_lastRequestTime ON Member(networkId, lastRequestTime);\n"\ "\n"\ "CREATE TABLE Route (\n"\ " networkId char(16) NOT NULL REFERENCES Network(id) ON DELETE CASCADE,\n"\ |