summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorEvan Prodromou <evan@controlyourself.ca>2008-10-22 16:36:00 -0400
committerEvan Prodromou <evan@controlyourself.ca>2008-10-22 16:36:00 -0400
commita15034bea561c778207c899d5893dbf6bfc3b637 (patch)
tree37cf2b50ffdad3f7bb4db67bad27bb79982b6f81
parent34528df6d9de96a4447e851704af739d9ea21950 (diff)
notice inbox
darcs-hash:20081022203600-5ed1f-344e77e348655806a27db2de043b55ba67afc73a.gz
-rw-r--r--classes/Notice_inbox.php22
-rw-r--r--classes/laconica.ini9
-rw-r--r--db/laconica.sql10
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;