diff options
| author | Adam Ierymenko <adam.ierymenko@gmail.com> | 2015-07-16 17:34:03 -0700 |
|---|---|---|
| committer | Adam Ierymenko <adam.ierymenko@gmail.com> | 2015-07-16 17:34:03 -0700 |
| commit | 99969b186b3a078fb5cc8d3bfa004ebf9fc6d95a (patch) | |
| tree | 5e1141d7c3689a74438ac00a77d207d6151c6aef /controller/schema.sql.c | |
| parent | f9f7de0ec7015a82b6c8f15cfbf13f52936df6d2 (diff) | |
| download | infinitytier-99969b186b3a078fb5cc8d3bfa004ebf9fc6d95a.tar.gz infinitytier-99969b186b3a078fb5cc8d3bfa004ebf9fc6d95a.zip | |
Add a concept of a member revision counter to networks. This can be used to select all members that have been added or changed since a given point.
Diffstat (limited to 'controller/schema.sql.c')
| -rw-r--r-- | controller/schema.sql.c | 5 |
1 files changed, 4 insertions, 1 deletions
diff --git a/controller/schema.sql.c b/controller/schema.sql.c index 30b88850..7f1342a8 100644 --- a/controller/schema.sql.c +++ b/controller/schema.sql.c @@ -14,7 +14,8 @@ " v6AssignMode varchar(8) NOT NULL DEFAULT('none'),\n"\ " multicastLimit integer NOT NULL DEFAULT(32),\n"\ " creationTime integer NOT NULL DEFAULT(0),\n"\ -" revision integer NOT NULL DEFAULT(1)\n"\ +" revision integer NOT NULL DEFAULT(1),\n"\ +" memberRevisionCounter integer NOT NULL DEFAULT(1)\n"\ ");\n"\ "\n"\ "CREATE TABLE Node (\n"\ @@ -58,10 +59,12 @@ " nodeId char(10) NOT NULL REFERENCES Node(id) ON DELETE CASCADE,\n"\ " authorized integer NOT NULL DEFAULT(0),\n"\ " activeBridge integer NOT NULL DEFAULT(0),\n"\ +" memberRevision integer NOT NULL DEFAULT(0)\n"\ " PRIMARY KEY (networkId, nodeId)\n"\ ");\n"\ "\n"\ "CREATE INDEX Member_networkId_activeBridge ON Member(networkId, activeBridge);\n"\ +"CREATE INDEX Member_networkId_memberRevision ON Member(networkId, memberRevision);\n"\ "\n"\ "CREATE TABLE Relay (\n"\ " networkId char(16) NOT NULL REFERENCES Network(id) ON DELETE CASCADE,\n"\ |