diff options
| author | matthew <matthew> | 2006-09-25 22:59:06 +0000 |
|---|---|---|
| committer | matthew <matthew> | 2006-09-25 22:59:06 +0000 |
| commit | a43f15d02b9f0ccc3053ae8725ce58f88ba33416 (patch) | |
| tree | 157c9cd28be10838fa209ef11b4043c69a640a42 /db/schema.sql | |
| parent | 4ac4fe8bdcdf6dedbae80d11b664a7d27025095b (diff) | |
Email confirmation of problems and comments; bugfix in AuthToken.
Diffstat (limited to 'db/schema.sql')
| -rw-r--r-- | db/schema.sql | 11 |
1 files changed, 10 insertions, 1 deletions
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) +); + |