From fcc5bf1e6695c9bfa0aff8d69ebe005043397967 Mon Sep 17 00:00:00 2001
From: Adam Ierymenko <adam.ierymenko@gmail.com>
Date: Wed, 29 Jul 2015 15:09:23 -0700
Subject: 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.

---
 controller/schema.sql.c | 13 +++++++++++++
 1 file changed, 13 insertions(+)

(limited to 'controller/schema.sql.c')

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"\
-- 
cgit v1.2.3