add table for remember me codes

[quix0rs-gnu-social.git] / db / laconica.sql

diff --git a/db/laconica.sql b/db/laconica.sql
index 5e612cbd8a339f82964034f2483cf143196132a5..f61d5de15d48cf6f148f61a14fd1ef59f477eca2 100644 (file)
--- 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;