summaryrefslogtreecommitdiff
path: root/db/laconica.sql
diff options
context:
space:
mode:
authorEvan Prodromou <evan@prodromou.name>2008-06-22 22:38:59 -0400
committerEvan Prodromou <evan@prodromou.name>2008-06-22 22:38:59 -0400
commitf6d219bac42ebcd3a941bc421a131388ea4519ad (patch)
treef38eb9b2e4670e99cd1b4555d019ef27b254bf85 /db/laconica.sql
parent7d9372ec502ef681637eb48dac7a4444c9a86640 (diff)
add flags to db for jabber and sms notification
darcs-hash:20080623023859-84dde-1c72985ee0a840e59d1fac88f27f929f3c637b65.gz
Diffstat (limited to 'db/laconica.sql')
-rw-r--r--db/laconica.sql3
1 files changed, 3 insertions, 0 deletions
diff --git a/db/laconica.sql b/db/laconica.sql
index cc475e4cf..5e612cbd8 100644
--- a/db/laconica.sql
+++ b/db/laconica.sql
@@ -45,8 +45,11 @@ create table user (
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',
+ jabbernotify tinyint default 0 comment 'whether to send notices to jabber',
+ updatefrompresence tinyint default 0 comment 'whether to record updates from Jabber presence notices',
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',
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'