From ed107c4daf9e6ccd1bc158ccdb2dbe0950aa845a Mon Sep 17 00:00:00 2001
From: Adam Ierymenko <adam.ierymenko@gmail.com>
Date: Mon, 20 Apr 2015 17:47:12 -0700
Subject: Network preferred relay stuff in netconf controller.

---
 controller/schema.sql | 5 ++++-
 1 file changed, 4 insertions(+), 1 deletion(-)

(limited to 'controller/schema.sql')

diff --git a/controller/schema.sql b/controller/schema.sql
index 54571a22..f6d6e7e7 100644
--- a/controller/schema.sql
+++ b/controller/schema.sql
@@ -40,6 +40,8 @@ CREATE TABLE Member (
 
 CREATE INDEX Member_networkId ON Member (networkId);
 
+CREATE INDEX Member_networkId_activeBridge ON Member(networkId, activeBridge);
+
 CREATE UNIQUE INDEX Member_networkId_nodeId ON Member (networkId, nodeId);
 
 CREATE TABLE MulticastRate (
@@ -68,7 +70,8 @@ CREATE TABLE Network (
 
 CREATE TABLE Relay (
   networkId char(16) NOT NULL,
-  nodeId char(10) NOT NULL
+  nodeId char(10) NOT NULL,
+  address varchar(64) NOT NULL
 );
 
 CREATE UNIQUE INDEX Relay_networkId_nodeId ON Relay (networkId, nodeId);
-- 
cgit v1.2.3

