summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorEvan Prodromou <evan@controlyourself.ca>2008-12-08 22:36:37 -0500
committerEvan Prodromou <evan@controlyourself.ca>2008-12-08 22:36:37 -0500
commita68f513cc8527544aec5b5f96b4e47861faf694d (patch)
tree7a5d947281d4195204fda2b3f084384eb0333a64
parent8286fd1281dcce8732aae1faba41e621f6bdbcbf (diff)
database changes to say whether to deliver messages for a subscription
darcs-hash:20081209033637-5ed1f-df5ef40e57cc0e9485e34e2f5e46249dcb0d9130.gz
-rw-r--r--classes/Subscription.php2
-rw-r--r--classes/laconica.ini2
-rw-r--r--db/laconica.sql2
3 files changed, 6 insertions, 0 deletions
diff --git a/classes/Subscription.php b/classes/Subscription.php
index ace2fa4c4..cc174fcce 100644
--- a/classes/Subscription.php
+++ b/classes/Subscription.php
@@ -32,6 +32,8 @@ class Subscription extends Memcached_DataObject
public $__table = 'subscription'; // table name
public $subscriber; // int(4) primary_key not_null
public $subscribed; // int(4) primary_key not_null
+ public $jabber; // tinyint(1) default_1
+ public $sms; // tinyint(1) default_1
public $token; // varchar(255)
public $secret; // varchar(255)
public $created; // datetime() not_null
diff --git a/classes/laconica.ini b/classes/laconica.ini
index 4f5f9c2e4..db76b2dee 100644
--- a/classes/laconica.ini
+++ b/classes/laconica.ini
@@ -268,6 +268,8 @@ id = N
[subscription]
subscriber = 129
subscribed = 129
+jabber = 17
+sms = 17
token = 2
secret = 2
created = 142
diff --git a/db/laconica.sql b/db/laconica.sql
index 42e427d0b..a366a6bcb 100644
--- a/db/laconica.sql
+++ b/db/laconica.sql
@@ -88,6 +88,8 @@ create table remote_profile (
create table subscription (
subscriber integer not null comment 'profile listening',
subscribed integer not null comment 'profile being listened to',
+ jabber tinyint default 1 comment 'deliver jabber messages',
+ sms tinyint default 1 comment 'deliver sms messages',
token varchar(255) comment 'authorization token',
secret varchar(255) comment 'token secret',
created datetime not null comment 'date this record was created',