mirror of
https://github.com/didyouexpectthat/zerotierone.git
synced 2024-11-09 01:40:06 -08:00
22 lines
724 B
SQL
22 lines
724 B
SQL
/* 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");
|