diff options
| author | Adam Ierymenko <adam.ierymenko@gmail.com> | 2015-07-29 15:09:23 -0700 |
|---|---|---|
| committer | Adam Ierymenko <adam.ierymenko@gmail.com> | 2015-07-29 15:09:23 -0700 |
| commit | fcc5bf1e6695c9bfa0aff8d69ebe005043397967 (patch) | |
| tree | aa210ccd90041badd15b9c0b328709b1d3134099 /controller/schema.sql.c | |
| parent | 7578b5629849f6c286c353dce713b0816b1cc4a9 (diff) | |
| download | infinitytier-fcc5bf1e6695c9bfa0aff8d69ebe005043397967.tar.gz infinitytier-fcc5bf1e6695c9bfa0aff8d69ebe005043397967.zip | |
Go ahead and spec out controller DB support for AuthToken -- GitHub issue #211 -- even though full implementation won't make it into 1.0.4.
Diffstat (limited to 'controller/schema.sql.c')
| -rw-r--r-- | controller/schema.sql.c | 13 |
1 files changed, 13 insertions, 0 deletions
diff --git a/controller/schema.sql.c b/controller/schema.sql.c index fa83f880..49c44548 100644 --- a/controller/schema.sql.c +++ b/controller/schema.sql.c @@ -18,6 +18,18 @@ " memberRevisionCounter integer NOT NULL DEFAULT(1)\n"\ ");\n"\ "\n"\ +"CREATE TABLE AuthToken (\n"\ +" id integer PRIMARY KEY NOT NULL,\n"\ +" networkId char(16) NOT NULL REFERENCES Network(id) ON DELETE CASCADE,\n"\ +" authMode integer NOT NULL DEFAULT(1),\n"\ +" useCount integer NOT NULL DEFAULT(0),\n"\ +" maxUses integer NOT NULL DEFAULT(0),\n"\ +" expiresAt integer NOT NULL DEFAULT(0),\n"\ +" token varchar(256) NOT NULL\n"\ +");\n"\ +"\n"\ +"CREATE INDEX AuthToken_networkId_token ON AuthToken(networkId,token);\n"\ +"\n"\ "CREATE TABLE Node (\n"\ " id char(10) PRIMARY KEY NOT NULL,\n"\ " identity varchar(4096) NOT NULL\n"\ @@ -71,6 +83,7 @@ " nodeId char(10) NOT NULL,\n"\ " ts integer NOT NULL,\n"\ " authorized integer NOT NULL,\n"\ +" authTokenId integer,\n"\ " version varchar(16),\n"\ " fromAddr varchar(64)\n"\ ");\n"\ |