diff options
| author | Adam Ierymenko <adam.ierymenko@gmail.com> | 2015-04-20 15:46:20 -0700 |
|---|---|---|
| committer | Adam Ierymenko <adam.ierymenko@gmail.com> | 2015-04-20 15:46:20 -0700 |
| commit | 69076f8a45a3d5d521ef69ce3df2667c1fbcbfd4 (patch) | |
| tree | 7821a5d143c348a4d1a12d95e09d56559b34f711 /controller/schema.sql | |
| parent | 60f05518aab585213fd053b1f6d0c96646e8f44d (diff) | |
| download | infinitytier-69076f8a45a3d5d521ef69ce3df2667c1fbcbfd4.tar.gz infinitytier-69076f8a45a3d5d521ef69ce3df2667c1fbcbfd4.zip | |
Add per-network relay stuff to sqlite table schema.
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, |