From 69076f8a45a3d5d521ef69ce3df2667c1fbcbfd4 Mon Sep 17 00:00:00 2001
From: Adam Ierymenko <adam.ierymenko@gmail.com>
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

