From 8ecd2a6b1dcfb21fae9a70bba65dfff3bb7503f1 Mon Sep 17 00:00:00 2001
From: Evan Prodromou <evan@controlyourself.ca>
Date: Fri, 20 Jun 2008 00:10:12 -0400
Subject: add confirmemail table

darcs-hash:20080620041012-5ed1f-20a7d4df375250f5c4eff90cdab80b22348b1088.gz
---
 db/laconica.sql | 7 +++++++
 1 file changed, 7 insertions(+)

(limited to 'db/laconica.sql')

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'
+);
-- 
cgit v1.2.3-54-g00ecf

