summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorEvan Prodromou <evan@controlezvous.ca>2008-06-22 11:48:36 -0400
committerEvan Prodromou <evan@controlezvous.ca>2008-06-22 11:48:36 -0400
commit695ad02bdbc03150e8f7f5ebf74fa043f16b3257 (patch)
treea5f27856c8bc00f58d3031e4ce9e04f2b3801142
parent0239802682f4a7a9bc4955823102b892dde6ee58 (diff)
q
darcs-hash:20080622154836-34904-0673a1ee33f35cdfd906251e50dadcbe8c4c90e7.gz
-rw-r--r--db/laconica.sql7
1 files changed, 5 insertions, 2 deletions
diff --git a/db/laconica.sql b/db/laconica.sql
index 0b07148c7..5561076f9 100644
--- a/db/laconica.sql
+++ b/db/laconica.sql
@@ -36,6 +36,8 @@ create table user (
nickname varchar(64) unique key comment 'nickname or username, duped in profile',
password varchar(255) comment 'salted password, can be null for OpenID users',
email varchar(255) unique key comment 'email address for password recovery etc.',
+ jabber varchar(255) unique key comment 'jabber ID for notices',
+ sms varchar(64) unique key comment 'sms phone number',
uri varchar(255) unique key comment 'universally unique identifier, usually a tag URI',
created datetime not null comment 'date this record was created',
modified timestamp comment 'date this record was modified'
@@ -145,9 +147,10 @@ create table oid_nonces (
UNIQUE (server_url(255), timestamp, salt)
) ENGINE=InnoDB;
-create table confirm_email (
+create table confirm_address (
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.',
+ address varchar(255) not null comment 'address (email, Jabber, SMS, etc.)',
+ address_type varchar(32) not null comment 'address type ("email", "jabber", "sms")',
modified timestamp comment 'date this record was modified'
);