From 6fabaae736de2daa1ba0c22701bbb11539e3fba7 Mon Sep 17 00:00:00 2001
From: Adam Ierymenko <adam.ierymenko@gmail.com>
Date: Tue, 4 Apr 2017 16:47:14 -0700
Subject: Add simple root server watcher (for our own new dashboard, but also
 for user use).

---
 root-watcher/schema.sql | 21 +++++++++++++++++++++
 1 file changed, 21 insertions(+)
 create mode 100644 root-watcher/schema.sql

(limited to 'root-watcher/schema.sql')

diff --git a/root-watcher/schema.sql b/root-watcher/schema.sql
new file mode 100644
index 00000000..bdb3a1cf
--- /dev/null
+++ b/root-watcher/schema.sql
@@ -0,0 +1,21 @@
+/* Schema for ZeroTier root watcher log database */
+
+/* If you cluster this DB using any PG clustering scheme that uses logs, you must remove UNLOGGED here! */
+CREATE UNLOGGED TABLE "Peer"
+(
+	"ztAddress" BIGINT NOT NULL,
+	"timestamp" BIGINT NOT NULL,
+	"versionMajor" INTEGER NOT NULL,
+	"versionMinor" INTEGER NOT NULL,
+	"versionRev" INTEGER NOT NULL,
+	"rootId" INTEGER NOT NULL,
+	"phyPort" INTEGER NOT NULL,
+	"phyLinkQuality" REAL NOT NULL,
+	"phyLastReceive" BIGINT NOT NULL,
+	"phyAddress" INET NOT NULL
+);
+
+CREATE INDEX "Peer_ztAddress" ON "Peer" ("ztAddress");
+CREATE INDEX "Peer_timestamp" ON "Peer" ("timestamp");
+CREATE INDEX "Peer_rootId" ON "Peer" ("rootId");
+CREATE INDEX "Peer_phyAddress" ON "Peer" ("phyAddress");
-- 
cgit v1.2.3

