From 69076f8a45a3d5d521ef69ce3df2667c1fbcbfd4 Mon Sep 17 00:00:00 2001 From: Adam Ierymenko Date: Mon, 20 Apr 2015 15:46:20 -0700 Subject: Add per-network relay stuff to sqlite table schema. --- controller/schema.sql | 7 +++++++ 1 file changed, 7 insertions(+) (limited to 'controller/schema.sql') diff --git a/controller/schema.sql b/controller/schema.sql index e68b095d..54571a22 100644 --- a/controller/schema.sql +++ b/controller/schema.sql @@ -66,6 +66,13 @@ CREATE TABLE Network ( revision integer NOT NULL DEFAULT(1) ); +CREATE TABLE Relay ( + networkId char(16) NOT NULL, + nodeId char(10) NOT NULL +); + +CREATE UNIQUE INDEX Relay_networkId_nodeId ON Relay (networkId, nodeId); + CREATE TABLE Node ( id char(10) PRIMARY KEY NOT NULL, identity varchar(4096) NOT NULL, -- cgit v1.2.3