summaryrefslogtreecommitdiff
path: root/db/laconica.sql
diff options
context:
space:
mode:
authorEvan Prodromou <evan@controlyourself.ca>2008-06-20 00:10:12 -0400
committerEvan Prodromou <evan@controlyourself.ca>2008-06-20 00:10:12 -0400
commit8ecd2a6b1dcfb21fae9a70bba65dfff3bb7503f1 (patch)
tree05ce3fc09b85cc858853cf9e64a1e158d0294ca3 /db/laconica.sql
parent6a6ad1f76effd973fdf0ffe6a7b308715c74f31b (diff)
add confirmemail table
darcs-hash:20080620041012-5ed1f-20a7d4df375250f5c4eff90cdab80b22348b1088.gz
Diffstat (limited to 'db/laconica.sql')
-rw-r--r--db/laconica.sql7
1 files changed, 7 insertions, 0 deletions
diff --git a/db/laconica.sql b/db/laconica.sql
index 03e823d50..7935b8b07 100644
--- a/db/laconica.sql
+++ b/db/laconica.sql
@@ -144,3 +144,10 @@ create table oid_nonces (
salt CHAR(40),
UNIQUE (server_url(255), timestamp, salt)
) ENGINE=InnoDB;
+
+create table confirmemail (
+ code varchar(32) not null primary key comment 'good random code',
+ user_id integer not null comment 'user who requested confirmation' references user (id),
+ email varchar(255) not null comment 'email address for password recovery etc.',
+ modified timestamp comment 'date this record was modified'
+);