diff options
Diffstat (limited to 'controller/schema.sql')
| -rw-r--r-- | controller/schema.sql | 7 |
1 files changed, 7 insertions, 0 deletions
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, |