From 5df185a5ed0040964dc53585c5187ac5004a7834 Mon Sep 17 00:00:00 2001
From: Evan Prodromou <evan@controlezvous.ca>
Date: Mon, 23 Jun 2008 22:02:05 -0400
Subject: add table for remember me codes

darcs-hash:20080624020205-34904-be536546e7058ed77a6d45be4f91ffe201b3448e.gz
---
 db/laconica.sql | 6 ++++++
 1 file changed, 6 insertions(+)

(limited to 'db')

diff --git a/db/laconica.sql b/db/laconica.sql
index 5e612cbd8..f61d5de15 100644
--- a/db/laconica.sql
+++ b/db/laconica.sql
@@ -167,3 +167,9 @@ create table confirm_address (
     address_type varchar(8) not null comment 'address type ("email", "jabber", "sms")',
     modified timestamp comment 'date this record was modified'
 ) ENGINE=InnoDB;
+
+create table remember_me (
+    code varchar(32) not null primary key comment 'good random code',
+    user_id integer not null comment 'user who is logged in' references user (id),
+    modified timestamp comment 'date this record was modified'
+) ENGINE=InnoDB;
-- 
cgit v1.2.3-54-g00ecf