diff options
| author | Adam Ierymenko <adam.ierymenko@gmail.com> | 2015-04-20 17:47:12 -0700 |
|---|---|---|
| committer | Adam Ierymenko <adam.ierymenko@gmail.com> | 2015-04-20 17:47:12 -0700 |
| commit | ed107c4daf9e6ccd1bc158ccdb2dbe0950aa845a (patch) | |
| tree | 038c1d2df93e8f01598d68b395aa4784668245e5 /controller/schema.sql | |
| parent | 8a13cfdacee72a4af90336a329aaecb0ed38c33d (diff) | |
| download | infinitytier-ed107c4daf9e6ccd1bc158ccdb2dbe0950aa845a.tar.gz infinitytier-ed107c4daf9e6ccd1bc158ccdb2dbe0950aa845a.zip | |
Network preferred relay stuff in netconf controller.
Diffstat (limited to 'controller/schema.sql')
| -rw-r--r-- | controller/schema.sql | 5 |
1 files changed, 4 insertions, 1 deletions
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); |