From a43f15d02b9f0ccc3053ae8725ce58f88ba33416 Mon Sep 17 00:00:00 2001
From: matthew <matthew>
Date: Mon, 25 Sep 2006 22:59:06 +0000
Subject: Email confirmation of problems and comments; bugfix in AuthToken.

---
 db/schema.sql | 11 ++++++++++-
 1 file changed, 10 insertions(+), 1 deletion(-)

(limited to 'db/schema.sql')

diff --git a/db/schema.sql b/db/schema.sql
index c160e2e27..0944d427f 100644
--- a/db/schema.sql
+++ b/db/schema.sql
@@ -4,7 +4,7 @@
 -- Copyright (c) 2006 UK Citizens Online Democracy. All rights reserved.
 -- Email: matthew@mysociety.org; WWW: http://www.mysociety.org/
 --
--- $Id: schema.sql,v 1.7 2006-09-22 17:38:00 matthew Exp $
+-- $Id: schema.sql,v 1.8 2006-09-25 22:59:06 matthew Exp $
 --
 
 -- secret
@@ -220,3 +220,12 @@ create table comment (
 create index comment_problem_id_idx on comment(problem_id);
 create index comment_problem_id_whenposted_idx on comment(problem_id, whenposted);
 
+-- Tokens for confirmations
+create table token (
+    scope text not null,
+    token text not null,
+    data bytea not null,
+    created timestamp not null default ms_current_timestamp(),
+    primary key (scope, token)
+);
+
-- 
cgit v1.2.3

