add table for remember me codes

darcs-hash:20080624020205-34904-be536546e7058ed77a6d45be4f91ffe201b3448e.gz

1 files changed, 6 insertions, 0 deletions

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;