summaryrefslogtreecommitdiff
path: root/db
diff options
context:
space:
mode:
authorEvan Prodromou <evan@prodromou.name>2008-07-20 23:59:19 -0400
committerEvan Prodromou <evan@prodromou.name>2008-07-20 23:59:19 -0400
commit3345f54186262c29b79efd18b4546eff8a6d0c0b (patch)
treee60bef63c6670b003dfdeee1f7fcbac813c69a53 /db
parenta439f49866c5cc6ca7f7e05b681abea4d3d9c3bb (diff)
add sms email address to user
darcs-hash:20080721035919-84dde-e06f9094902522d2cd0ad71d65d565293f19db4a.gz
Diffstat (limited to 'db')
-rw-r--r--db/laconica.sql1
1 files changed, 1 insertions, 0 deletions
diff --git a/db/laconica.sql b/db/laconica.sql
index 3c8478beb..84e1d1fac 100644
--- a/db/laconica.sql
+++ b/db/laconica.sql
@@ -55,6 +55,7 @@ create table user (
sms varchar(64) unique key comment 'sms phone number',
carrier integer comment 'foreign key to sms_carrier' references sms_carrier (id),
smsnotify tinyint default 0 comment 'whether to send notices to SMS',
+ smsemail varchar(255) comment 'built from sms and carrier',
uri varchar(255) unique key comment 'universally unique identifier, usually a tag URI',
autosubscribe tinyint default 0 comment 'automatically subscribe to users who subscribe to us',
created datetime not null comment 'date this record was created',