diff options
| -rw-r--r-- | classes/User.php | 1 | ||||
| -rw-r--r-- | classes/stoica.ini | 1 | ||||
| -rw-r--r-- | db/laconica.sql | 5 |
3 files changed, 6 insertions, 1 deletions
diff --git a/classes/User.php b/classes/User.php index f22144e5c..a6cab262c 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 $smsreplies; // tinyint(1) public $smsemail; // varchar(255) public $uri; // varchar(255) unique_key public $autosubscribe; // tinyint(1) diff --git a/classes/stoica.ini b/classes/stoica.ini index cffefa96d..99196909e 100644 --- a/classes/stoica.ini +++ b/classes/stoica.ini @@ -168,6 +168,7 @@ updatefrompresence = 17 sms = 2 carrier = 1 smsnotify = 17 +smsreplies = 17 smsemail = 2 uri = 2 autosubscribe = 17 diff --git a/db/laconica.sql b/db/laconica.sql index 84e1d1fac..66510b148 100644 --- a/db/laconica.sql +++ b/db/laconica.sql @@ -55,11 +55,14 @@ 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', + smsreplies tinyint default 0 comment 'whether to send notices to SMS on replies', 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', - modified timestamp comment 'date this record was modified' + modified timestamp comment 'date this record was modified', + + index user_smsemail_idx (smsemail) ) ENGINE=MyISAM; /* remote people */ |