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 | |
| parent | 60f05518aab585213fd053b1f6d0c96646e8f44d (diff) | |
| download | infinitytier-69076f8a45a3d5d521ef69ce3df2667c1fbcbfd4.tar.gz infinitytier-69076f8a45a3d5d521ef69ce3df2667c1fbcbfd4.zip | |
Add per-network relay stuff to sqlite table schema.
Diffstat (limited to 'controller')
| -rw-r--r-- | controller/schema.sql | 7 | ||||
| -rw-r--r-- | controller/schema.sql.c | 7 |
2 files changed, 14 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, diff --git a/controller/schema.sql.c b/controller/schema.sql.c index 315698ac..655f8e05 100644 --- a/controller/schema.sql.c +++ b/controller/schema.sql.c @@ -67,6 +67,13 @@ " revision integer NOT NULL DEFAULT(1)\n"\ ");\n"\ "\n"\ +"CREATE TABLE Relay (\n"\ +" networkId char(16) NOT NULL,\n"\ +" nodeId char(10) NOT NULL\n"\ +");\n"\ +"\n"\ +"CREATE UNIQUE INDEX Relay_networkId_nodeId ON Relay (networkId, nodeId);\n"\ +"\n"\ "CREATE TABLE Node (\n"\ " id char(10) PRIMARY KEY NOT NULL,\n"\ " identity varchar(4096) NOT NULL,\n"\ |