summaryrefslogtreecommitdiff
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
parenta439f49866c5cc6ca7f7e05b681abea4d3d9c3bb (diff)
add sms email address to user
darcs-hash:20080721035919-84dde-e06f9094902522d2cd0ad71d65d565293f19db4a.gz
-rw-r--r--classes/User.php1
-rw-r--r--classes/stoica.ini1
-rw-r--r--db/laconica.sql1
3 files changed, 3 insertions, 0 deletions
diff --git a/classes/User.php b/classes/User.php
index edf11728c..f22144e5c 100644
--- a/classes/User.php
+++ b/classes/User.php
@@ -44,6 +44,7 @@ class User extends DB_DataObject
public $sms; // varchar(64) unique_key
public $carrier; // int(4)
public $smsnotify; // tinyint(1)
+ public $smsemail; // varchar(255)
public $uri; // varchar(255) unique_key
public $autosubscribe; // tinyint(1)
public $created; // datetime() not_null
diff --git a/classes/stoica.ini b/classes/stoica.ini
index 955b4d9fc..cffefa96d 100644
--- a/classes/stoica.ini
+++ b/classes/stoica.ini
@@ -168,6 +168,7 @@ updatefrompresence = 17
sms = 2
carrier = 1
smsnotify = 17
+smsemail = 2
uri = 2
autosubscribe = 17
created = 142
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',