diff options
author | Craig Andrews <candrews@integralblue.com> | 2009-11-02 18:40:18 -0500 |
---|---|---|
committer | Craig Andrews <candrews@integralblue.com> | 2009-11-02 18:40:49 -0500 |
commit | b9d40f723bce8e01ddcbbb989bd7035b92cd9af8 (patch) | |
tree | a995cf45dbd3d913ba31bd097a5f14cf72a8c095 /db/08to09_pg.sql | |
parent | a2b830392597d88c435baf54ad0df4ecda02dc41 (diff) |
Added 'login' command that gives you a link that can be used to login to the website
Diffstat (limited to 'db/08to09_pg.sql')
-rw-r--r-- | db/08to09_pg.sql | 10 |
1 files changed, 10 insertions, 0 deletions
diff --git a/db/08to09_pg.sql b/db/08to09_pg.sql index 9e37314aa..197fcabfd 100644 --- a/db/08to09_pg.sql +++ b/db/08to09_pg.sql @@ -38,3 +38,13 @@ create table user_role ( primary key (user_id, role) ); + +create table login_token ( + user_id integer not null /* comment 'user owning this token'*/ references user (id), + token char(32) not null /* comment 'token useable for logging in'*/, + created timestamp not null DEFAULT CURRENT_TIMESTAMP /* comment 'date this record was created'*/, + modified timestamp /* comment 'date this record was modified'*/, + + constraint primary key (user_id) +); + |