diff options
| -rw-r--r-- | classes/Notice_inbox.php | 22 | ||||
| -rw-r--r-- | classes/laconica.ini | 9 | ||||
| -rw-r--r-- | db/laconica.sql | 10 |
3 files changed, 41 insertions, 0 deletions
diff --git a/classes/Notice_inbox.php b/classes/Notice_inbox.php new file mode 100644 index 000000000..3d838a7b0 --- /dev/null +++ b/classes/Notice_inbox.php @@ -0,0 +1,22 @@ +<?php +/** + * Table Definition for notice_inbox + */ +require_once 'classes/Memcached_DataObject'; + +class Notice_inbox extends Memcached_DataObject +{ + ###START_AUTOCODE + /* the code below is auto generated do not remove the above tag */ + + public $__table = 'notice_inbox'; // table name + public $user_id; // int(4) primary_key not_null + public $notice_id; // int(4) primary_key not_null + public $source; // tinyint(1) default_1 + + /* Static get */ + function staticGet($k,$v=NULL) { return Memcached_DataObject::staticGet('Notice_inbox',$k,$v); } + + /* the code above is auto generated do not remove the tag below */ + ###END_AUTOCODE +} diff --git a/classes/laconica.ini b/classes/laconica.ini index c74cd9cce..15055c12e 100644 --- a/classes/laconica.ini +++ b/classes/laconica.ini @@ -152,6 +152,15 @@ source = 2 [notice__keys] id = N +[notice_inbox] +user_id = 129 +notice_id = 129 +source = 17 + +[notice_inbox__keys] +user_id = K +notice_id = K + [notice_source] code = 130 name = 130 diff --git a/db/laconica.sql b/db/laconica.sql index ad4ae6983..f1d3a484f 100644 --- a/db/laconica.sql +++ b/db/laconica.sql @@ -331,3 +331,13 @@ create table message ( index message_to_idx (to_profile), index message_created_idx (created) ) ENGINE=InnoDB CHARACTER SET utf8 COLLATE utf8_bin; + +create table notice_inbox ( + + user_id integer not null comment 'user receiving the message' references user (id), + notice_id integer not null comment 'notice received' references notice (id), + source tinyint default 1 comment 'reason it is in the inbox; 1=subscription', + + constraint primary key (user_id, notice_id), + index notice_inbox_notice_id_idx (notice_id) +) ENGINE=InnoDB CHARACTER SET utf8 COLLATE utf8_bin; |