summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
-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'
+);