diff options
| author | Adam Ierymenko <adam.ierymenko@gmail.com> | 2015-04-21 16:41:35 -0700 |
|---|---|---|
| committer | Adam Ierymenko <adam.ierymenko@gmail.com> | 2015-04-21 16:41:35 -0700 |
| commit | ddebe2d4c7fa4220d2cfad3693edfb15bf7a737c (patch) | |
| tree | c8c4816080ffaefd39c58a87bd180898e8457710 /controller/schema.sql | |
| parent | ed107c4daf9e6ccd1bc158ccdb2dbe0950aa845a (diff) | |
| download | infinitytier-ddebe2d4c7fa4220d2cfad3693edfb15bf7a737c.tar.gz infinitytier-ddebe2d4c7fa4220d2cfad3693edfb15bf7a737c.zip | |
Network controller CRUD... :P
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 f6d6e7e7..0d17a94b 100644 --- a/controller/schema.sql +++ b/controller/schema.sql @@ -71,9 +71,11 @@ CREATE TABLE Network ( CREATE TABLE Relay ( networkId char(16) NOT NULL, nodeId char(10) NOT NULL, - address varchar(64) NOT NULL + phyAddress varchar(64) NOT NULL ); +CREATE INDEX Relay_networkId ON Relay (networkId); + CREATE UNIQUE INDEX Relay_networkId_nodeId ON Relay (networkId, nodeId); CREATE TABLE Node ( @@ -86,6 +88,7 @@ CREATE TABLE Node ( CREATE TABLE Rule ( networkId char(16) NOT NULL, + ordering integer NOT NULL DEFAULT(0), nodeId char(10), vlanId integer, vlanPcp integer, |